SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52008 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52008 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799558,898908,613187,210567,29750,501249,977969,1047865,133456,96368,17132,901532,120836,402012,308325,343472,602603,708209,453661,83152,808363,853656,177681,150284,595898,36551,496533,801348,1015034,462779,527812,1035023,10221,324690,341873,647154,365467,559745,257038,994870,371941,361387,1019204,29277,361818,173433,297928,853299,449934,970124,36694,300634,967725,831235,179746,142991,432036,1033065,1038092,404478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]