SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419513 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419513 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96032,625297,683781,923395,689873,880664,470859,421857,765651,423143,145239,492678,904669,910553,380064,514833,354354,591210,411131,189002,1046112,209724,148079,317823,831431,487368,899658,155308,137788,116517,17722,473579,399300,350998,795252,350947,520853,59899,1042986,120064,221960,518035,42383,832690,511252,531828,151669,577425,127025,363919,991709,1038012,376581,825032,1041228,58404,850287,833168,96557,995386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]