SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 678197 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 678197 [ RunTime:0.004235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005239,573895,930118,979304,474225,49814,374387,796987,108331,152826,1019164,113573,104683,19402,199049,393385,649347,993052,430776,611967,301039,950219,455981,740209,187988,287463,105384,866482,789859,300040,556527,677048,1025389,1028742,336149,270108,14587,1038626,455318,626095,576749,880109,812840,1041006,1027155,373549,908134,797366,596141,927215,1037520,86420,282741,536360,933829,675279,1024523,395038,782998,266228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 678197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 678197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]