导图 1
广告查询接口
  Ad
    属性
      id(adid)
      name，ad_title，ad_body，ad_image，ad_sort，jump_status，companyid，ad_property，createtime
      in_used
    新增
      mysql:ad
      redis:adinfo::adid
    删除
      mysql:in_ued=0
      redis:expire adinfo::adid
    变更
      mysql:update
      redis:expire,hmset
  Location
    属性
      id(locationid)
      gameid,channelid
      area,x,y,x_offset,y_offset
      type,mode,ld_property
      in_used
    新增
      mysql:location
      redis:locationinfo::locationid
    删除
      mysql:in_used=0
      redis:repire locationinfo::locationid
    变更
      mysql:update
      redis:expire,hmset
  ad_location
    属性
      adid
      locationid
      gameid,channelid
      begin_time，end_time，ad_num
      in_used
      status
    新增
      mysql:ad_location
      redis:adinfo::gameid::area::location
    变更
      mysql:update
      redis:expire,smerber adinfo::gameid::area::location
    删除
      mysql:in_used=0
      redis:expire
  缓存消费者
    gameid::area or locationid
      adinfo::adid::area:location
        adinfo::adid
        locationinfo:locationid
  缓存生产者
    set adinfo::gameid::area::location
    set:adinfo::adid
    set:locationinfo::locationid
    find 过期adid,hrem from adinfo::gameid::area::location