SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002968s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045450 LIMIT 1 [ RunTime:0.001766s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045450 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536763,564356,846120,775231,719922,171647,876987,963215,719507,973163,106472,335548,901406,397088,217439,913900,192405,859767,299629,467997,297443,16251,925158,492768,566645,170515,552868,244215,69925,61125,859762,610746,932085,370492,871752,578829,643465,616878,716926,462350,1016662,396757,1024809,386813,822870,186575,553596,736601,265576,27830,800740,3958,838480,898628,372920,376146,656312,112607,698913,570905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001595s ]