SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011109 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011109 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537843,321236,177057,856323,74665,985474,488840,657079,836709,474495,219787,870402,330361,894396,983612,50106,217178,573813,308416,131943,918713,79671,515768,141088,627180,845596,626212,446556,960690,829328,416586,8033,144457,314635,72548,327988,1004910,554073,35297,417651,821251,925546,522126,632378,1023976,252140,336393,441431,81932,718218,914439,513482,880206,28623,496760,996526,942305,256234,605143,251201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]