SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024833 LIMIT 1 [ RunTime:0.002704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024833 [ RunTime:0.003711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985261,828426,678797,914420,932666,307215,87012,889261,684084,482366,290170,273336,555524,759680,300545,852563,1036469,327482,823897,126631,268053,383587,988922,692646,482622,452845,169011,843611,793514,905122,478566,95346,612471,286708,724039,446687,957159,67536,780399,160274,957408,114715,201264,585296,897552,490383,907387,175262,165289,465571,270430,247628,424822,231425,91652,427272,432426,464424,662338,177310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]