SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546030 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546030 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383200,442323,237573,242929,316006,816568,447788,1024112,890942,509501,942799,21897,665078,160368,230912,634509,96170,604280,262749,290963,6839,656983,924468,364701,710286,103299,85660,32190,218324,956913,739656,81775,442740,916310,926738,1035222,41969,978713,723231,282207,149443,607135,1007924,657837,696226,684772,578546,289672,833008,927549,46148,299656,901967,288796,497357,837141,473240,143460,714464,829074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]