SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587851 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587851 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15993,8214,83700,711723,807165,50280,44444,58068,937548,181540,205610,905241,895187,556369,469294,325253,529880,513492,33022,633550,203832,860065,97075,622772,992953,50107,110361,491335,714664,977918,21028,946517,906356,1007701,396169,584973,9948,792861,51445,137244,702560,440102,545772,401083,3689,425300,450618,407110,487505,244954,985739,765632,804288,189132,130993,544717,473252,234541,321365,233528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]