SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685763 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685763 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510414,1023748,964148,244386,1032337,817606,773858,464107,21614,747346,37777,693231,224597,471817,1017016,683654,861981,684585,818603,1002587,528064,315909,874755,801723,804871,366065,855564,355804,588756,296797,327851,132319,633609,1023757,909153,605392,618123,109703,446776,660192,162001,279836,923558,932969,96416,503463,665593,413099,200758,624055,474802,63916,962832,642536,421194,634065,1001938,400057,223019,905161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]