SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316021 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316021 [ RunTime:0.004047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604111,487435,802161,697869,754555,340859,979861,209276,347793,913890,709792,217014,549923,46115,953870,452136,1002017,817452,1005127,266034,386223,411535,175299,181568,436974,616635,59270,20213,972665,656442,169861,737191,831787,720433,173206,122651,920513,1033431,294950,467783,568723,358169,532648,987568,306935,1020654,205860,953200,36439,1032263,765524,998638,500694,1014886,154554,141825,839520,1023119,901243,599848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]