Projection_75 102550875.22 root weplayzy.weplay_gift_consume.id, weplayzy.weplay_gift_consume.uid, weplayzy.weplay_gift_consume.recipient_id, weplayzy.weplay_gift_consume.recipient_name, weplayzy.weplay_gift_consume.gift_id, weplayzy.weplay_gift_consume.gift_name, weplayzy.weplay_gift_consume.gift_type, weplayzy.weplay_gift_consume.gift_amount, weplayzy.weplay_gift_consume.gift_icon, weplayzy.weplay_gift_consume.gift_price, weplayzy.weplay_gift_consume.host_id, weplayzy.weplay_gift_consume.room_id, weplayzy.weplay_gift_consume.diamond_amount, weplayzy.weplay_gift_consume.wealth_amount, weplayzy.weplay_gift_consume.remark, weplayzy.weplay_gift_consume.data_source, weplayzy.weplay_gift_consume.channel_id, weplayzy.weplay_gift_consume.create_time, weplayzy.weplay_gift_consume.gift_source, weplayzy.weplay_gift_consume.gift_order_id, weplayzy.weplay_user.nickname, weplayzy.weplay_user.channel_id, mul(weplayzy.weplay_gift_config.charm_score, weplayzy.weplay_gift_consume.gift_amount)->Column#115
└─IndexJoin_81 102550875.22 root left outer join, inner:TableReader_78, outer key:weplayzy.weplay_gift_consume.gift_id, inner key:weplayzy.weplay_gift_config.id, equal cond:eq(weplayzy.weplay_gift_consume.gift_id, weplayzy.weplay_gift_config.id)
├─IndexJoin_93(Build) 102550875.22 root left outer join, inner:TableReader_90, outer key:weplayzy.weplay_gift_consume.uid, inner key:weplayzy.weplay_user.uid, equal cond:eq(weplayzy.weplay_gift_consume.uid, weplayzy.weplay_user.uid)
│ ├─IndexLookUp_99(Build) 102158297.00 root
│ │ ├─IndexFullScan_97(Build) 102158297.00 cop[tikv] table:wgc, index:idx_create_time(create_time) keep order:true, desc
│ │ └─TableRowIDScan_98(Probe) 102158297.00 cop[tikv] table:wgc keep order:false
│ └─TableReader_90(Probe) 1.00 root data:TableRangeScan_89
│ └─TableRangeScan_89 1.00 cop[tikv] table:wu range: decided by [weplayzy.weplay_gift_consume.uid], keep order:false
└─TableReader_78(Probe) 0.96 root data:TableRangeScan_77
└─TableRangeScan_77 0.96 cop[tikv] table:b range: decided by [weplayzy.weplay_gift_consume.gift_id], keep order:false