SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 90408 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 90408 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811375,782809,104885,1026215,408406,600125,505712,1040601,571621,375786,471297,936575,387395,720571,195340,145323,926097,348031,86348,776683,35990,445081,164024,742094,817664,70924,231361,508541,970541,354230,270549,629741,353083,1004144,578375,365589,1022127,315592,345947,81173,956385,4867,799711,103873,214412,749255,260107,30822,989158,527391,13701,287401,11970,59597,754418,1045500,668969,349574,655666,448472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 90408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 90408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001746s ]