SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541042 LIMIT 1 [ RunTime:0.001089s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541042 [ RunTime:0.006018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964300,960497,533553,543319,694247,828155,273689,231510,389001,946284,107807,895850,911957,178466,98900,952413,613164,915778,539989,129204,146413,406165,313187,341368,564200,684280,57822,353097,99116,324831,683942,733405,41753,385841,69446,446251,327880,729449,507781,398988,791480,346507,812139,830739,924291,940644,198770,614245,613361,581030,320358,262118,30839,347531,535746,198086,503828,149266,428170,123443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]