SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002634s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40482 LIMIT 1 [ RunTime:0.001449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40482 [ RunTime:0.004450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007956,609220,121144,13971,274023,380376,439325,58757,758434,173490,556386,841898,621135,987393,976628,374735,958496,591806,1025858,1038096,890363,293426,992648,393815,872055,104208,882391,434321,807934,216580,1003707,816411,333308,603470,422281,875664,752848,987181,421873,936575,144513,1033967,114130,484040,803332,903973,771493,233934,724560,826881,29053,167192,399863,566716,168635,380566,159150,556074,74883,619918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]