SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178601 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178601 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570231,249269,245047,936335,485514,906066,613642,252485,534004,822005,81616,283181,816254,10408,585358,703662,225203,201565,186574,504537,1030436,1038745,951545,58891,282131,687494,494626,897512,721756,279002,1035444,402514,733659,818278,558486,175990,674917,567934,559432,355310,44731,550446,275225,418706,341110,736260,904759,691389,145729,448703,435506,591619,598664,5332,322983,238843,981658,556435,194723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]