SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519563 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519563 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465362,895632,853827,19102,665329,821457,388626,595580,348976,382882,486217,5991,599216,514436,142316,470260,56070,323899,425233,50876,124918,210728,365691,581963,123074,635996,583878,209727,448547,128143,726384,954780,152106,284902,42966,280001,374489,1029210,111886,749570,730429,889902,635123,47072,654461,915567,146586,990132,150925,620077,30734,190153,492242,58607,695185,845476,884389,880456,511898,149532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]