SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121521 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121521 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720009,1021441,583908,35105,229709,267070,452517,213036,242417,65977,143433,529246,857298,1009390,695432,742965,780762,335398,616712,259484,605862,214032,883917,795660,757440,310477,739923,509388,550,225003,1011485,556909,246795,191513,1008162,1018669,995775,972672,555262,10091,117466,654630,685960,707770,854256,1043976,846572,592733,660302,171878,150120,19910,453063,958040,22738,415270,177944,659131,697777,1040927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]