SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018502 LIMIT 1 [ RunTime:0.002478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018502 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255830,1026360,970132,703465,838142,774685,839608,469714,824364,397335,736860,570981,772591,250390,530560,912449,490514,638275,402480,765124,241689,264291,167013,613554,186941,344952,253362,633807,1022987,282569,153185,555301,489922,380417,748281,562117,457976,823858,436179,549788,432360,524979,673979,485818,124302,481789,728413,692169,536200,327898,711262,500275,26733,909633,996525,951502,608483,300341,2046,87546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]