SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502285 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502285 [ RunTime:0.002925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604541,593509,359011,956131,695186,261644,419497,98378,838056,525981,829391,462467,439676,52610,693657,17735,594600,785819,392163,316223,413620,1007780,772791,472290,769748,798541,496628,833828,964958,1022829,787476,209462,872010,771789,391224,724172,470002,507294,696915,648610,231633,40907,215023,461987,865701,528536,854756,403687,748653,125933,616367,614981,340203,3760,493180,921760,754186,1029041,104218,213366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502285 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502285 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]