SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483933 LIMIT 1 [ RunTime:0.001066s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483933 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318080,138212,666070,780981,969365,14965,523380,301214,829252,1031966,285271,838285,1023510,486006,289015,229350,402579,532755,592825,141523,819484,878481,536808,536456,767494,466268,769070,749754,59962,75160,595575,387612,620702,7861,1024381,78697,446990,397579,638838,1012374,464943,27847,983253,375806,148697,964243,831281,15338,145644,948294,789712,951242,1029145,690984,617140,288154,485677,613916,856520,832442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]