SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599730 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599730 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124742,206831,567770,31074,217055,793979,727907,449694,198972,798340,623574,979990,163337,544541,580869,51166,200215,1040609,913755,265428,277381,241062,37641,605459,422835,947255,245717,910463,604535,542321,576506,494628,706202,316664,337191,670481,324789,507655,7981,250639,149015,225178,821161,127066,534094,583914,143965,815074,667433,37717,352478,1039752,500089,552684,35279,760290,810741,620973,518500,975547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]