SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164510 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164510 [ RunTime:0.004051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516621,156904,1029480,421592,132954,623989,229586,490645,401305,415574,442756,602578,455620,185737,103314,538054,325324,595298,663752,930703,1015510,186,173504,749356,762522,125387,133602,969095,362468,464588,172915,1025140,415137,1017766,290443,15204,778281,829259,612831,328715,583250,867217,350863,681349,93635,390560,589728,798324,534613,914168,265208,311742,189271,682761,133129,693891,881554,749526,159870,102866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]