SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805818 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805818 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97860,827326,136061,123851,314661,189764,131502,199390,650886,380749,361322,227279,2442,229199,1020933,504568,430235,83628,391979,273944,990790,492648,93853,557923,202600,538382,103997,586941,1017409,890172,695376,591703,855946,947040,835471,852355,343884,448347,81487,932493,225532,350889,235037,350994,675192,102537,608101,624298,924555,549924,970641,416521,365376,484049,148005,395729,1029261,358921,407528,211014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]