SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539791 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539791 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618852,820418,895853,147208,528303,773383,369723,56373,345727,642429,326185,331682,188598,131965,360892,331591,873346,756350,138373,543155,660224,670460,546195,481585,150063,465691,868607,238271,302065,916140,593622,443883,15895,344996,5822,78564,707341,928326,776368,542561,160902,697986,962755,148591,516816,643883,505661,331603,1005030,839400,436476,97256,516648,1022273,1033930,873634,980745,796103,494068,98510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]