SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 37810 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 37810 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314746,859667,405510,143398,141435,96511,1045831,198432,742755,1003928,889951,159293,493170,477642,853977,744916,1046820,220281,36954,641888,110440,831471,1017353,868835,8736,960162,879090,882058,167322,222186,834843,426231,256758,462294,917673,355490,604389,461620,1023519,111518,689539,765317,172628,547830,717656,874944,26962,279902,497635,22143,286249,212280,618426,650266,612758,445246,478988,657539,398508,863476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 37810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 37810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]