SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4308 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4308 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999545,539903,176442,192412,785418,792814,577245,990064,47709,275144,928402,822034,863963,444106,553531,577251,911023,830326,124148,264753,17120,809534,510723,724903,899566,598927,445997,883670,986532,519794,157125,96019,883555,840165,136741,201019,857425,933933,139427,128405,261377,381828,732615,34895,657376,387888,296725,23658,474909,706611,1011529,664321,848987,564209,1048264,308937,216671,5516,596276,221355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]