SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003011s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803664 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803664 [ RunTime:0.005010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928045,672537,236078,261143,31516,131519,828116,182514,605600,547527,77484,536765,243139,587484,58313,973259,433015,170142,336980,720498,997011,355107,141203,49447,404690,76142,805585,874097,929737,310529,107366,442310,29751,338234,865810,388500,789599,786330,933623,645843,899808,550887,13267,554634,1005563,807129,477627,154581,13723,1018095,256830,329459,895726,782500,407549,464522,155835,293945,522797,13250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803664 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803664 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]