SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 652207 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 652207 [ RunTime:0.002607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121270,723994,425457,222205,1011327,848726,197175,849055,658427,940270,847106,281894,784213,203787,494215,537971,769196,461506,801020,216705,213623,514472,275560,246199,16261,829717,1028378,315785,368999,689195,177400,278427,1021239,88408,276250,318054,963850,16169,839089,58668,487523,871151,500273,923178,160578,62340,36894,367684,864280,772157,789228,276623,808811,525252,38479,791735,690731,232797,279405,41680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 652207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 652207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]