SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684062 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684062 [ RunTime:0.004269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984599,851110,720014,1030661,1042952,407073,363264,611029,800096,399061,897171,622653,80712,647967,203260,839056,108908,42807,234915,889891,974185,521632,22962,1038920,581206,137359,146473,518144,198389,365301,382319,252011,452450,267801,266593,347242,946448,134311,837360,437280,292171,669488,869011,435676,42742,209194,914811,197140,930109,703354,13911,1048749,986305,591480,410156,856499,245443,34326,407930,738367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001653s ]