SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335580 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335580 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662168,862029,673245,412319,742103,586603,1015021,416624,167191,94608,184731,77143,802378,244635,503954,502441,311592,78346,1019675,560225,1047092,733084,1027385,78335,386077,242354,1015279,827463,3310,577648,616195,583895,7333,322643,684915,508730,318718,454914,659557,384313,708354,328115,303623,59718,446508,833281,425672,885207,601064,265251,277959,438457,459611,547972,696935,994416,388304,542998,223406,77760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002945s ]