SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472310 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472310 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857866,499196,919672,739486,148706,802507,1020486,334916,681566,990382,937568,448095,48713,869572,477385,295285,305054,699781,43666,686977,857005,667320,665328,601481,18023,526272,1014718,1032115,124917,876784,1000432,82226,113985,242623,617890,424211,462128,757353,556854,658131,775620,116418,277262,568674,194281,582584,304377,439147,334398,784852,409685,496655,42580,993310,206043,26427,1000478,904593,824161,216599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]