SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420460 LIMIT 1 [ RunTime:0.000783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420460 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728212,530362,1034970,963689,196018,781070,154185,132057,184366,397811,278112,424579,590647,978460,578770,1013149,538431,48171,91146,131745,887561,88330,149474,389199,277985,551093,158510,252017,585169,613572,173217,438324,894515,990264,680283,360168,311966,358104,1028382,293620,641225,868559,258541,277215,163413,382430,734492,653937,396693,161948,660721,55873,784132,337154,1014559,301625,586128,944568,611808,772238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]