SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803053 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803053 [ RunTime:0.003936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563820,120132,782500,881780,131695,617936,512457,335299,418098,187541,759247,424240,541636,483135,613223,898231,109514,735360,930304,103819,14723,207172,201866,167947,50695,879643,288987,972915,694141,35751,703330,564828,128454,290825,142065,137927,161212,545394,728464,714495,428914,1017785,316868,823227,677925,1010956,717212,775000,304417,736471,62955,657936,742061,418443,944879,378292,35552,803415,23200,114899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]