SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401499 LIMIT 1 [ RunTime:0.000805s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401499 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290647,99271,284755,510130,1032503,756032,349396,613988,843737,625645,99654,983672,420463,29315,77731,758243,49936,691394,797169,141847,882055,73624,931515,436989,416629,803468,843738,366900,966579,831618,609719,663272,419259,106840,562222,24687,278599,212203,500146,850691,458545,169665,314608,792167,455447,87486,657947,735110,317074,99286,786137,992487,1012208,656595,555814,1027110,91606,494370,923307,985921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]