SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001892s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648438 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648438 [ RunTime:0.005002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354213,151732,731737,949016,234265,729873,476819,393251,181210,405777,559801,1010939,423572,758537,14192,554141,437954,409916,433689,304459,1003720,464996,259755,975768,189711,168390,93882,725437,983895,488821,837846,65949,356683,967984,627051,636308,647012,66772,64587,655623,229308,846631,529892,994095,769315,270815,415433,600295,366515,41938,864192,31792,906642,192713,516045,84932,509128,545445,525315,308166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]