SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413543 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413543 [ RunTime:0.003063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128017,847873,639004,382398,806078,983623,394386,784836,524413,1038543,741636,731610,593131,338030,349052,988493,471640,184945,639228,50706,294500,348754,194727,566249,962864,633810,5902,357627,265782,1864,890576,848195,183572,766630,700141,998247,516279,465395,279411,112148,876552,811280,311931,570038,727353,550828,382143,949086,424148,624985,706254,406825,921294,378015,192482,358247,857278,217284,823861,578145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]