SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485354 LIMIT 1 [ RunTime:0.001764s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485354 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241411,810130,560833,466666,938663,908699,644859,162021,2585,944350,623799,198770,1031583,485956,448360,234870,965322,384606,423381,759733,792421,368186,960924,694290,736386,193680,965621,807267,260152,475638,345547,189801,494682,37458,160700,835490,980789,1007667,235138,839051,354101,697986,662325,451998,865866,761697,387138,678294,564232,389654,962743,83664,1023026,226076,813277,301477,967366,134214,59887,284073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002731s ]