SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535180 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535180 [ RunTime:0.003106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727393,296847,923312,867778,994681,34057,205523,76047,135964,586926,932856,444827,613185,395470,311865,59359,480989,797246,304480,271081,1012648,1029799,668611,338159,729246,521758,538197,342587,5734,241989,198714,759934,638733,185226,232029,465851,1001874,707546,540673,71603,57859,924689,761357,518940,87762,985117,430255,675520,57471,563770,131754,889921,479585,669218,148179,654616,601331,771091,1016030,1045822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]