SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580208 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580208 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156469,557781,331794,931282,632948,65653,539043,1038855,1038785,668683,112750,168836,662302,533451,729265,174175,84595,295562,561159,137412,413246,365295,784326,429605,701925,708608,886166,980119,274546,967495,345042,398061,638267,638442,114671,334287,575517,231382,656295,93447,925675,680660,110607,481110,368874,1048746,958228,687756,25395,341502,342901,996881,894623,87584,583718,443094,770650,1045447,885233,829639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]