SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806513 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806513 [ RunTime:0.003215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330957,117798,638447,146957,221279,526714,847740,845059,723246,489358,124252,784250,858554,23186,731515,102577,833521,909090,116217,994749,356751,2965,189376,10356,581675,150673,669381,636690,967223,484251,990963,351583,861789,696175,504817,758416,58775,318871,931566,9132,35948,914136,218172,455263,450751,173598,286325,766789,868449,193594,926851,501270,1015526,389257,907707,404769,134917,849913,26942,909864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]