SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021024 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021024 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560824,778588,537163,991238,667449,622865,219261,401473,555765,540553,546015,773350,549808,419601,821313,925282,751266,966296,614641,20188,592647,873915,656161,4725,20042,374620,593217,550918,242935,678345,900236,397862,567613,616614,143113,546734,168774,736703,796420,226480,113631,639884,857465,444018,523907,449649,175032,742940,917726,332470,890735,640388,85027,1038250,502477,503248,1030438,369385,759450,311967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]