SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536847 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536847 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49807,390507,578578,581898,453663,576542,15023,197431,48627,159450,186058,532527,521104,429603,88939,218423,883081,769446,1014153,544861,413118,1011993,204373,51462,41477,239989,287722,716923,214501,345217,1010923,863244,917506,505211,42838,33643,453004,849692,44186,787089,456034,274539,771939,27939,844719,518996,703994,199956,344288,122223,275645,88193,613940,189741,413590,116112,817041,520512,36222,738364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]