SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524220 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524220 [ RunTime:0.002486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527234,691446,525192,688132,852661,161166,258218,821715,168634,630507,579109,919131,486088,174164,30831,846560,167740,415737,643253,575508,424882,622519,858222,427419,1034835,729632,568100,755506,306826,189415,401026,1013420,210585,920635,182238,431752,889596,937946,178589,675512,134021,127541,124345,637617,114382,667596,12344,938170,853004,187185,574309,234982,663311,893210,476828,198197,93105,1039518,877454,6369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]