SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344093 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344093 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254604,75914,93742,975036,27291,382976,401052,754105,427929,1015637,848476,870783,1045732,825102,4140,951942,1007346,964292,67482,403833,285549,476498,656550,102881,444374,792708,302372,167779,167618,499211,698565,275442,665109,618529,700578,725614,1039467,280281,950249,615443,105876,209641,932497,388166,623985,787540,818385,970073,638058,858868,170840,694387,474054,291917,200414,383342,137452,638151,202401,245016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]