SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329711 LIMIT 1 [ RunTime:0.007394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329711 [ RunTime:0.014925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466837,456389,179701,738329,896850,32483,602986,115698,661697,155059,562935,211864,674851,468592,770224,527628,705871,566368,186883,416798,464699,317670,1043503,256008,176035,789650,530483,552252,747323,731420,791312,772723,1019151,538002,573409,507258,465046,566744,1015111,80941,961591,12469,415780,124205,354335,941489,405580,453025,494146,294692,436154,607097,1029820,591049,704402,213241,344276,879115,1001495,945348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]