SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537907 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537907 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456426,902011,150952,132082,1031166,374719,581726,931323,192418,15278,29872,206975,478916,694111,994579,348318,488322,823477,697520,907548,541158,136080,665690,873052,993849,44958,894443,918060,554466,96754,144295,906790,536377,116034,155336,280332,179396,49962,372225,34955,217976,681517,524436,859689,246816,745620,428721,688617,742447,918495,982807,239342,357965,493636,184809,646901,1093,362815,1019338,780627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]