SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440266 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440266 [ RunTime:0.002388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610883,102440,478191,604954,259005,115577,430652,26089,189864,1018495,297456,310107,204880,983783,421398,806429,494404,483209,481417,419765,703121,731019,964118,309631,769505,363565,775913,218025,301615,611915,1021031,45358,268280,783608,967389,830471,338132,198271,977881,525396,581762,962823,795854,954259,487554,27518,359648,283078,892643,279883,161503,824270,962769,820288,907947,377062,387131,649547,428813,239235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]