SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284317 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284317 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191822,392117,1025653,384079,818034,47024,24676,290042,726299,1048172,341728,344476,451935,320185,555352,592561,790146,742881,590655,992626,215317,523807,452714,109455,916641,793215,16980,91277,122598,44423,976201,507222,500805,848369,314517,551697,112208,1000520,13235,1024502,22744,777477,905297,1039436,226446,582469,382746,103427,700418,230627,754995,535986,853038,150984,903943,435667,516978,49864,645955,609401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001822s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001060s ]