SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549611 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549611 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306643,544020,737933,478378,57527,720639,361647,338805,360937,217034,547262,577540,539131,929308,792889,866507,168426,472781,1035045,537646,968465,5413,41280,422880,297896,366388,35837,595693,359921,643644,445718,957807,828671,1026820,442862,314232,235359,1002312,546603,847051,210521,624111,141499,911420,1003265,10121,327036,337220,593007,696964,705572,807315,747715,1032943,709690,873072,211662,660093,789905,393012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]