SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583856 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583856 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953831,144900,710503,273249,445783,408489,718713,569486,164891,397944,755442,344960,984805,555620,767189,121155,68328,645866,108670,987997,599264,127349,224324,401196,381607,671434,170164,893923,743974,188251,545522,840939,433838,469411,706254,339750,481267,584737,281428,727089,519664,806260,186286,921543,356767,536922,596226,281695,639567,462467,222407,540951,778797,4291,332826,306447,754654,26732,995873,263207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]