SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456486 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456486 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019128,678770,381037,804070,800602,983462,304410,930840,376816,776291,964941,35593,71141,944514,411619,660109,778106,671528,505073,413846,375645,18034,199074,255643,700121,416906,990653,504929,234976,683999,558123,833403,513703,443091,339401,113723,587021,907889,896635,852815,517567,694308,480306,462155,666395,20424,388938,123977,686708,735987,318446,817354,838225,684997,1005370,391093,488929,491306,393914,861481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]