SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004837s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340440 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340440 [ RunTime:0.004012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031470,695687,687518,23750,718316,366989,775668,189992,834375,635638,879959,777947,180343,651957,837477,1022141,40403,446707,514167,455031,651833,348700,789815,64549,516889,288593,302244,353417,88644,722986,212420,295689,976565,48570,600725,516508,924443,553252,203220,662290,905412,569650,564961,66705,264291,346145,58168,445811,687167,385706,207279,246345,265860,234089,666542,705612,943024,736461,436394,212991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]