SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545120 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545120 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773250,198774,68212,581828,724474,939170,158247,868862,566484,681470,413292,559921,454999,1004964,971510,761903,832826,538388,784497,882992,752970,777474,624869,426342,741198,1047066,586015,529013,940507,405371,125950,42157,257180,86833,46522,633141,618808,314562,537983,781004,763921,825994,720564,322764,646780,847966,1008350,465520,810290,214226,887958,139185,680012,553838,673857,930863,593613,982175,92733,535791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]