SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487181 LIMIT 1 [ RunTime:0.000891s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487181 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027518,859962,312530,970626,124941,573041,501007,270967,848084,37397,66619,200382,23499,419793,633726,201669,27507,841407,857473,656295,976146,1016581,155870,827594,837697,86610,907096,72752,1045289,568715,1014998,602179,355553,649398,1026411,653853,547864,1008989,515262,283615,988496,625614,941861,6554,675120,123767,75799,24055,534137,301649,315572,299066,231672,274583,110212,429503,693524,731066,528824,989384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]