SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012011 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012011 [ RunTime:0.003237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785278,500473,930240,492213,619240,943866,263764,797963,317419,359305,640004,242244,606663,542155,72725,219430,222148,459668,477044,29298,528091,96390,618833,301566,330605,144595,427947,366921,878584,106506,945383,870000,752250,571472,813368,328158,72077,615337,232869,452788,507628,677809,301083,542116,888051,852420,410480,871129,413808,738454,598819,737688,346940,787134,906415,874580,204163,480839,477438,664375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003449s ]