SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54678 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54678 [ RunTime:0.005377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417011,197126,377149,876512,494182,448152,180389,359790,633644,566029,821845,216587,564759,55819,319630,831591,762855,345698,363924,90294,692956,422699,673444,946986,456501,351625,761355,856510,306194,388062,254979,97104,977601,228141,584271,1005439,804275,466806,937744,262027,981674,289230,560317,827465,1048423,587574,748486,906579,577121,625510,335419,231703,861421,338553,980201,301378,736157,157052,397675,279663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]