SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045676 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045676 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031197,591793,855220,798809,51203,737062,217486,899243,858495,296693,1043361,944802,886252,805311,485737,15409,488993,191774,784994,955421,762273,142570,131372,1015041,840119,284758,244041,267887,882057,265693,312187,561254,1003297,298889,318015,21237,199862,285459,635802,1005078,77903,785440,426605,235274,294424,613645,496971,1019613,801168,625371,797039,58600,343243,974109,681431,375476,446988,778624,1015179,688557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]