SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 965075 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 965075 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994040,837236,310592,604846,1046705,238006,828201,485890,855566,558155,928529,710888,454574,431633,66812,377501,290988,398484,421774,868397,611019,75254,896403,285770,361269,378786,851035,201729,776755,577301,799096,478816,614196,60123,1000612,4057,655884,613477,712648,514417,1021507,476416,358851,93977,675717,407242,656579,50647,71426,612937,318186,452337,971422,437074,642012,435790,157310,161782,313587,877699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 965075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 965075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]