SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201435 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201435 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357391,977541,880541,538976,391669,645801,342628,301074,124535,760992,269005,290778,859060,369910,99197,264143,606968,697140,770199,407418,735008,279787,602775,177931,367532,108595,473322,25698,324600,242760,826589,28608,262154,722523,683382,525009,841334,148498,28689,1041712,396283,550667,461658,100932,34759,417518,384823,1048298,426472,343121,404974,592268,188708,697319,403004,225160,59101,162926,302805,200953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]