SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002751s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030354 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030354 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457042,259075,201501,394062,946979,249087,1024482,726597,165945,693545,442342,376392,518202,607628,856981,730976,660602,699170,209798,915777,375492,787805,643215,344238,52782,438320,330534,102586,754044,969545,149366,97954,124874,186387,44830,764213,809055,331387,933583,166967,1047853,263039,153149,369766,578273,865454,306967,66027,870914,861396,267093,439496,396373,556786,666617,973115,359628,74951,268105,429937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]