|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|payment|SELECT * FROM `pay_order_msg`|1|357|357||0|0|687881|687881|687881|687881|
|youzan|SELECT * FROM `youzan_message_push`|1|28|28||0|0|255461|255461|255461|255461|
|activity_service|SELECT * FROM `scene_luck_partake`|1|1|1||0|0|11499|11499|11499|11499|
|oa_gateway|SELECT * FROM `product_script_execute_record`|1|1|1||0|0|14691|14691|14691|14691|
|v4_user|SELECT mp.member_id AS `key`,sum(mpd.oper_amount) AS `value` FROM v4_user.member_points mp JOIN v4_user.member_points_detail mpd ON mpd.member_points_id=mp.id WHERE mp.tenant_id=? AND mp.tenant_app_id=? AND mpd.oper_time>=? AND mpd.oper_time<? AND mpd.status=? AND mpd.scene=? AND mp.member_id IN (?) GROUP BY mp.member_id|1|2|2||0|0|31|31|4|4|
|value_added|SELECT * FROM `value_added_user_extend_back_?`|1|1|1||0|0|35430|35430|35430|35430|
|v4_user|SELECT * FROM `reception_customer_potential`|1|233|233||0|0|5338182|5338182|5338182|5338182|
|v4_user|SELECT * FROM `member_butler_back`|1|16|16||0|0|372098|372098|372098|372098|
|sms|SELECT * FROM `sms_send_back`|1|1|1||0|0|16036|16036|16036|16036|
|corpwx|SELECT * FROM `external_user`|1|648|648||0|0|11435344|11435344|11435344|11435344|
|v4_user|SELECT * FROM `member`|1|309|309||0|0|4059976|4059976|4059976|4059976|
|tenant|SELECT * FROM `sneak_guest_maintain_file`|1|87|87||0|0|1975922|1975922|1975922|1975922|
|customer|SELECT * FROM `tenant_user_received`|1|2|2||0|0|28773|28773|28773|28773|
|timer|SELECT * FROM `task_info`|1|14|14||0|0|204214|204214|204214|204214|
|v4_user|SELECT * FROM `sjfx_dct_member_source`|1|2|2||0|0|92370|92370|92370|92370|
|item_manage|SELECT * FROM `item_operator`|1|2|2||0|0|65582|65582|65582|65582|
|coupon_service|SELECT * FROM `coupon_expire_task`|1|39|39||0|0|836184|836184|836184|836184|
|coupon_service|SELECT * FROM `write_off_log`|1|4|4||0|0|76597|76597|76597|76597|
|mini_app|SELECT * FROM `mini_qrcode_params`|1|36|36||0|0|966991|966991|966991|966991|
|customize_page|SELECT * FROM `gift_qualified`|1|5|5||0|0|165082|165082|165082|165082|
|v4_sales|SELECT * FROM `value_added`|1|1|1||0|0|6609|6609|6609|6609|
|v4_user|SELECT ifnull(sum(esd.amount_pay),?) AS sales_money FROM v4_sales.erp_sales es JOIN v4_sales.erp_sales_detail esd ON es.tenant_id=esd.tenant_id AND es.tenant_app_id=esd.tenant_app_id AND es.sales_erp_id=esd.sales_erp_id AND esd.sales_type=? JOIN v4_employee.shop sp ON es.tenant_id=sp.tenant_id AND es.dept_erp_id=sp.dept_id JOIN tenant.employee emp ON es.tenant_id=emp.tenant_id AND es.employee_erp_id=emp.employee_erp_id WHERE es.tenant_id=? AND es.tenant_app_id=? AND sp.id=? AND emp.id=? AND es.is_sales=? AND es.sales_status=? AND es.sales_date=date_format(?,?)|1|1|1||0|0|5|5|1|1|
|platform|SELECT * FROM `bargainapplication`|1|1|1||0|0|59587|59587|59587|59587|
|v4_employee|SELECT * FROM `task_task_attach`|1|44|44||0|0|1286512|1286512|1286512|1286512|
|activity_service|SELECT * FROM `intelligent_push_msg_obj`|1|309|309||0|0|6104481|6104481|6104481|6104481|
|qrcode_service|SELECT * FROM `qrcode`|1|6|6||0|0|75616|75616|75616|75616|
|v4_user|SELECT * FROM `sjfx_dct_member_grade`|1|4|4||0|0|154934|154934|154934|154934|
|coupon_service|SELECT * FROM `coupon_can_give`|1|8|8||0|0|334191|334191|334191|334191|
|wx_gateway|SELECT * FROM `wx_image`|1|15|15||0|0|231867|231867|231867|231867|
|order|SELECT * FROM `order_discount`|1|2|2||0|0|31311|31311|31311|31311|
|customize_page|SELECT * FROM `gift_receive_detail`|1|4|4||0|0|171834|171834|171834|171834|
|user_service|SELECT * FROM `erp_integral_log`|1|666|666||0|0|12858715|12858715|12858715|12858715|
|v4_user|SELECT * FROM `wx_user_subscribe_log`|1|78|78||0|0|4699812|4699812|4699812|4699812|
|activity_service|SELECT * FROM `lottery_prize`|1|3|3||0|0|13570|13570|13570|13570|
|activity_service|SELECT * FROM `cutdown_price_activity_apply`|1|4|4||0|0|105762|105762|105762|105762|
|authorization_service|SELECT * FROM `user_login_token`|1|3152|3152||0|0|35458310|35458310|35458310|35458310|
|v4_user|SELECT * FROM `member_change_log`|1|1375|1375||0|0|11038581|11038581|11038581|11038581|
|mini_app|SELECT * FROM `app_qrcode`|1|17|17||0|0|333192|333192|333192|333192|
|corpwx_license|SELECT * FROM `msg_send`|1|1|1||0|0|16830|16830|16830|16830|
|v4_activity|SELECT * FROM `lottery_log`|1|1|1||0|0|22106|22106|22106|22106|
|customer|SELECT * FROM `customer_demand`|1|5|5||0|0|26324|26324|26324|26324|
|v4_user|SELECT ifnull(group_concat(DISTINCT IF(es.sales_status=?,sd.category_erp_id,?)),?)saleCategoryIds,ifnull(group_concat(DISTINCT IF(es.sales_status=?,ifnull(pc.category_name,sd.category_name),?)),?) AS saleCategoryNames,ifnull(GROUP_CONCAT(DISTINCT IF(es.sales_status=?,if(sd.sales_brand=? OR sd.sales_brand=?,?,sd.sales_brand),?)),?) AS salesBrand,ifnull(GROUP_CONCAT(DISTINCT IF(es.sales_status=?,if(sd.sales_craft=? OR sd.sales_craft=?,?,sd.sales_craft),?)),?) AS salesCraft FROM v4_sales.erp_sales es INNER JOIN v4_sales.erp_sales_detail sd ON sd.tenant_id=es.tenant_id AND es.tenant_app_id=sd.tenant_app_id AND es.sales_erp_id=sd.sales_erp_id AND sd.sales_type=? LEFT JOIN v4_sales.erp_product_category pc ON es.tenant_id=pc.tenant_id AND sd.category_erp_id=pc.category_erp_id WHERE es.tenant_id=? AND es.tenant_app_id=? AND es.member_erp_id IN (?) AND es.is_sales=? AND es.sales_status>=?|1|1|1||0|0|20554|20554|1|1|
|youzan|SELECT * FROM `weimob_platform_sync_log`|1|55|55||0|0|115254|115254|115254|115254|
|v4_user|SELECT * FROM `member_butler_update_error`|1|132|132||0|0|1591768|1591768|1591768|1591768|
|shop_work|SELECT * FROM `work_report`|1|4|4||0|0|19290|19290|19290|19290|
|activity_service|SELECT * FROM `intelligent_marketing_activity_gift`|1|39|39||0|0|498054|498054|498054|498054|
|account|SELECT * FROM `store_card`|1|1|1||0|0|9264|9264|9264|9264|
|v4_coupon|SELECT * FROM `tag_push_coupon_log`|1|19|19||0|0|346294|346294|346294|346294|
|activity_service|SELECT * FROM `lottery_user`|1|17|17||0|0|683795|683795|683795|683795|
|activity_service|SELECT * FROM `activity_?`|1|1|1||0|0|4455|4455|4455|4455|
|authorization_service|SELECT * FROM `ip_table_local`|1|12|12||0|0|462824|462824|462824|462824|
|item_manage|SELECT * FROM `unread_log`|1|1|1||0|0|65692|65692|65692|65692|
|activity_service|SELECT * FROM `assist_task_receive_prize`|1|6|6||0|0|10487|10487|10487|10487|
|user_service|SELECT * FROM `tenant_member_bind`|1|858|858||0|0|18699245|18699245|18699245|18699245|
|user_service|SELECT * FROM `tenant_member`|1|1141|1141||0|0|18699939|18699939|18699939|18699939|
|customer|SELECT * FROM `customer_entry_oper_log`|1|6|6||0|0|84274|84274|84274|84274|
|payment|SELECT * FROM `pay_order`|1|48|48||0|0|347298|347298|347298|347298|
|v4_coupon|SELECT * FROM `employee_grant_coupon_qrcode`|1|1|1||0|0|10883|10883|10883|10883|
|activity_service|SELECT * FROM `vote_player`|1|2|2||0|0|7885|7885|7885|7885|
|v4_employee|SELECT t?.average_score,emp.employee_name,es.sales_no,tm.member_name,tm.mobile_no FROM v4_sales.`comment`t? JOIN v4_sales.erp_sales es ON es.id=t?.order_id AND es.tenant_id=t?.tenant_id AND es.tenant_app_id=t?.tenant_app_id AND es.is_sales=? AND es.sales_status=? LEFT JOIN tenant.employee emp ON emp.tenant_id=t?.tenant_id AND emp.employee_erp_id=es.employee_erp_id LEFT JOIN v4_employee.shop sp ON es.tenant_id=sp.tenant_id AND es.dept_erp_id=sp.dept_id LEFT JOIN v4_user.member tm ON t?.tenant_id=tm.tenant_id AND t?.tenant_app_id=tm.tenant_app_id AND t?.member_id=tm.id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND sp.id=? AND t?.create_time>=? AND t?.create_time<=? AND t?.average_score<t?.low_score|1|2|2||0|0|63537|63537|0|0|
|account|SELECT * FROM `wx_redpacket_send_msg`|1|208|208||0|0|818682|818682|818682|818682|
|customer|SELECT * FROM `customer_maintain_log`|1|2|2||0|0|26482|26482|26482|26482|
|account|SELECT * FROM `store_card_detail`|1|1|1||0|0|13285|13285|13285|13285|
|instant_messaging|SELECT * FROM `messages`|1|1|1||0|0|27610|27610|27610|27610|
|employee|SELECT * FROM `backlog_bak`|1|24|24||0|0|66096|66096|66096|66096|
|oss|SELECT * FROM `oss_res`|1|8|8||0|0|127425|127425|127425|127425|
|shop_work|SELECT * FROM `task_old`|1|1|1||0|0|3211|3211|3211|3211|
|coupon_service|SELECT * FROM `coupon_user`|1|69|69||0|0|792948|792948|792948|792948|
|user_service|SELECT * FROM `tenant_member_info`|1|1488|1488||0|0|18699943|18699943|18699943|18699943|
|v4_sales|SELECT * FROM `comment_detail`|1|13|13||0|0|317700|317700|317700|317700|
|corpwx|SELECT * FROM `external_user_bind_log`|1|5|5||0|0|117585|117585|117585|117585|
||SELECT t.* FROM v4_user.member t WHERE t.tenant_id=? AND t.update_time>? ORDER BY update_time DESC LIMIT ?|1|2|2||0|0|92782|92782|0|0|
|score_player|SELECT * FROM `supervise_record_image`|1|1|1||0|0|21294|21294|21294|21294|
|employee|SELECT * FROM `backlog_report`|1|1|1||0|0|40494|40494|40494|40494|
|erp_sync|SELECT * FROM `retry_data`|1|1|1||0|0|4030|4030|4030|4030|
|timer|SELECT * FROM `task_execute_log`|1|186|186||0|0|4506656|4506656|4506656|4506656|
|activity_service|SELECT * FROM `employee_give_coupon_log`|1|1|1||0|0|43468|43468|43468|43468|
|v4_activity|SELECT * FROM `lottery_member`|1|1|1||0|0|18198|18198|18198|18198|
|user_service|SELECT * FROM `tenant_member_change_shop`|1|275|275||0|0|2817804|2817804|2817804|2817804|
|user_service|SELECT * FROM `user_employee_back_?`|1|4|4||0|0|126632|126632|126632|126632|
|v4_employee|SELECT * FROM `task_task`|1|452|452||0|0|3623784|3623784|3623784|3623784|
|v4_employee|SELECT * FROM `mark_label_task`|1|39|39||0|0|655715|655715|655715|655715|
|wx_gateway|SELECT * FROM `wx_news_articles`|1|139|139||0|0|13637|13637|13637|13637|
|v4_user|SELECT t?.tenant_id,t?.tenant_app_id,t?.maintain_shop_id AS shopId,t?.maintain_employee_id AS employeeId,sum(if(t?.event_type=?,?,?)) AS maintain_times,count(DISTINCT if(t?.event_type IN(?),t?.potential_customer_id,?)) AS maintain_trade,count(DISTINCT if(t?.event_type=?,t?.potential_customer_id,?)) AS success_trade,count(DISTINCT if(t?.event_type=?,t?.potential_customer_id,?)) AS failed_trade,sum(if(t?.event_type=?,t?.deal_sale_amount,?)) AS deal_amount FROM v4_user.potential_customer_maintain t? JOIN v4_user.potential_customer t? ON t?.id=t?.potential_customer_id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.create_time>=? AND t?.create_time<? GROUP BY t?.tenant_id,t?.tenant_app_id,t?.maintain_shop_id,t?.maintain_employee_id LIMIT ? OFFSET ?|1|1|1||0|0|645|645|62|62|
|oa_gateway|SELECT * FROM `login_user`|1|1|1||0|0|18640|18640|18640|18640|
|wx_gateway|SELECT * FROM `wx_template_push_detail`|1|2|2||0|0|60227|60227|60227|60227|
|shop_work|SELECT * FROM `manage_report`|1|1|1||0|0|662|662|662|662|
|employee|SELECT * FROM `batch_step_execution`|1|16|16||0|0|334225|334225|334225|334225|
|employee|SELECT * FROM `label_task_employee`|1|50|50||0|0|1033721|1033721|1033721|1033721|
||SELECT t.* FROM v4_user.member t WHERE t.tenant_id=? ORDER BY update_time DESC LIMIT ?|1|3|3||0|0|92787|92787|5|5|
|platform|SELECT * FROM `callbacklog`|1|1|1||0|0|34421|34421|34421|34421|
|check_stock|SELECT * FROM `realtime_gold_price`|1|21|21||0|0|547396|547396|547396|547396|
|v4_user|SELECT COUNT(*) AS total FROM v4_user.member m JOIN (SELECT recommend_id,count(*) AS recommend_count FROM v4_user.member WHERE tenant_id=? AND tenant_app_id=? AND recommend_id>? AND recommend_bind_time>=? AND recommend_bind_time<? GROUP BY recommend_id)x ON x.recommend_id=m.id WHERE m.tenant_id=? AND m.tenant_app_id=?|1|3|3||0|0|92332|92332|1|1|
|v4_user|SELECT * FROM `cwx_external_user`|1|231|231||0|0|5276216|5276216|5276216|5276216|
|tenant|SELECT * FROM `erp_sales_extend`|1|2|2||0|0|89810|89810|89810|89810|
|value_added|SELECT * FROM `value_added_user_extend`|1|67|67||0|0|2104326|2104326|2104326|2104326|
|v4_user|SELECT * FROM `member_import_log`|1|86|86||0|0|1002123|1002123|1002123|1002123|
|activity_service|SELECT * FROM `online_sign_user_sign_log`|1|7|7||0|0|475629|475629|475629|475629|
|wx_gateway|SELECT * FROM `wx_template_msg`|1|164|164||0|0|617583|617583|617583|617583|
|v4_user|SELECT es.recommend_id AS `key`,sum(esd.amount_pay) AS `value` FROM v4_sales.erp_sales es JOIN v4_sales.erp_sales_detail esd ON es.tenant_id=esd.tenant_id AND es.tenant_app_id=esd.tenant_app_id AND es.sales_erp_id=esd.sales_erp_id WHERE es.tenant_id=? AND es.tenant_app_id=? AND es.sales_date>=date_format(?,?) AND es.sales_date<date_format(?,?) AND es.is_sales=? AND es.sales_status=? AND es.recommend_id IN (?) GROUP BY es.recommend_id|1|1|1||0|0|2190|2190|6|6|
|corpwx_license|SELECT * FROM `cwx_sync_list_order_account`|1|1|1||0|0|29848|29848|29848|29848|
|erp_to_platform|SELECT * FROM `sync_log`|1|9|9||0|0|269164|269164|269164|269164|
|payment|SELECT * FROM `close_order_msg`|1|10|10||0|0|40600|40600|40600|40600|
|comment_service|SELECT * FROM `comment`|1|44|44||0|0|992985|992985|992985|992985|
|employee|SELECT * FROM `batch_job_instance`|1|1|1||0|0|125594|125594|125594|125594|
|export|SELECT t.id,t.product_name,CASE WHEN t.take_type=? THEN ? ELSE ? END take_type,t.user_name,t.mobile_no,t.create_time,t.update_time,t.quantity,t.pay_price,CASE WHEN t.order_status=? THEN ? ELSE ? END order_status,t.remark,date_format(tt.can_take_date,?)can_take_date,tt.shop_name,tt.take_shop_name,tt.take_employee_name,ta.recipients,ta.user_tel,CONCAT(ta.area,ta.address)address,if(t.trade_type=?,pl.id,it.barcode) AS barcode,t.cash_price,ws.shop_name userAscriptionShop,if(t.order_status=?,?,t.write_off_time) AS write_off_time FROM gift_mail.trade t LEFT JOIN gift_mail.trade_take tt ON t.tenant_wechatapp_id=tt.tenant_wechatapp_id AND t.id=tt.trade_id LEFT JOIN gift_mail.trade_addr ta ON t.tenant_wechatapp_id=ta.tenant_wechatapp_id AND t.id=ta.trade_id LEFT JOIN gift_mail.product p ON p.id=t.product_id LEFT JOIN gift_mail.platform_product pl ON pl.id=t.product_id LEFT JOIN gift_mail.inventory it ON it.product_id=t.product_id AND it.specification=t.specification LEFT JOIN user_service.tenant_member_info tm ON t.tenant_id=tm.tenant_id AND t.tenant_wechatapp_id=tm.tenant_app_id AND t.user_id=tm.user_id LEFT JOIN tenant.tenant_wechatapp_shop ws ON tm.shop_id=ws.id WHERE t.tenant_wechatapp_id=? AND t.trade_type=? ORDER BY t.id DESC|1|29|29||0|0|121284|121284|13476|13476|
|value_added|SELECT * FROM `value_added_user_back_?`|1|2|2||0|0|35430|35430|35430|35430|
|position|SELECT * FROM `geo_position`|1|312|312||0|0|9987483|9987483|9987483|9987483|
|user_service|SELECT * FROM `user_employee`|1|474|474||0|0|13931609|13931609|13931609|13931609|
|order|SELECT * FROM `order_info`|1|59|59||0|0|263749|263749|263749|263749|
|export|SELECT cu.id couponId,cu.coupon_name,cu.coupon_type,CASE cu.coupon_type WHEN ? THEN ? ELSE ? END couponTypeName,cu.coupon_no, CASE cu.source WHEN ? THEN ? ELSE ? END couponChannelName, CASE cu.coupon_state WHEN ? THEN ? ELSE ? END couponStateName,ce.user_name,ce.creator_user_name,round(cu.face_value/?,?) AS faceValue,round(cu.balance/?,?) AS balance,cu.begin_time,cu.end_time,ce.remark,ce.mobile_no,ce.creator_mobile_no,cu.create_time,ce.writeoff_time,cu.user_id,if(ce.source_user_type=?,ce.source_user_id,?)employeeId,ce.member_source_shop FROM coupon_service.coupon cu JOIN coupon_service.coupon_extend ce ON ce.tenant_id=? AND ce.tenant_app_id=? AND ce.id=cu.id WHERE cu.tenant_id=? AND cu.tenant_app_id=? AND cu.create_time>=? AND cu.create_time<=?|1|1|1||0|0|396|396|198|198|
|v4_user|SELECT * FROM `reception_customer_log`|1|20|20||0|0|298010|298010|298010|298010|
|authorization_service|SELECT * FROM `login_account`|1|3|3||0|0|65756|65756|65756|65756|
|customer|SELECT * FROM `customer_maintain_follow`|1|2|2||0|0|24090|24090|24090|24090|
|comment_service|SELECT * FROM `reply`|1|1|1||0|0|38040|38040|38040|38040|
|v4_sales|SELECT * FROM `value_added_record`|1|75|75||0|0|2392192|2392192|2392192|2392192|
|warranty_service|SELECT * FROM `warranty_data`|1|5019|5019||0|0|13471818|13471818|13471818|13471818|
|v4_coupon|SELECT * FROM `employee_grant_record`|1|2|2||0|0|18409|18409|18409|18409|
|order|SELECT * FROM `order_service_log`|1|1|1||0|0|26195|26195|26195|26195|
|activity_service|SELECT * FROM `activity`|1|2|2||0|0|9783|9783|9783|9783|
|activity_service|SELECT * FROM `activity_gift_grant`|1|8|8||0|0|181225|181225|181225|181225|
|corpwx_license|SELECT * FROM `active_code`|1|2|2||0|0|29665|29665|29665|29665|
|corpwx|SELECT * FROM `corpwx_external_user`|1|606|606||0|0|8152442|8152442|8152442|8152442|
|activity_service|SELECT * FROM `user_trace`|1|158|158||0|0|1263203|1263203|1263203|1263203|
|user_service|SELECT * FROM `tenant_member_remark_log`|1|6|6||0|0|69931|69931|69931|69931|
|corpwx|SELECT * FROM `contact_me`|1|9|9||0|0|104584|104584|104584|104584|
|user_service|SELECT * FROM `user_relation`|1|1|1||0|0|32839|32839|32839|32839|
|account|SELECT t.tenant_id,t.tenant_app_id,t.shop_id,t.user_id,t.scene,t.busi_date,count(*)total_amount FROM (SELECT bg.id,bg.tenant_id,bg.tenant_app_id,ifnull(ws.dept_erp_id,?)shop_id,ifnull(ey.employee_erp_id,?)user_id,bg.status,bg.scene,date_format(bg.expire_time,?)busi_date FROM employee.backlog_? bg INNER JOIN tenant.tenant_wechatapp_shop ws ON bg.shop_id=ws.id INNER JOIN tenant.employee ey ON bg.employee_id=ey.id WHERE bg.tenant_app_id=? AND bg.scene NOT IN(?) AND bg.create_time>=? AND bg.create_time<=?)t GROUP BY t.tenant_id,t.tenant_app_id,t.shop_id,t.user_id,t.scene,t.busi_date LIMIT ? OFFSET ?|1|1|1||0|0|8264|8264|946|946|
|account|SELECT tm.id,tm.tenant_id,tm.tenant_app_id,tu.user_id AS external_user_id,? updateTime FROM corpwx.external_user tu INNER JOIN user_service.tenant_member_bind tm ON tu.tenant_id=tm.tenant_id AND tm.tenant_app_id=? AND tu.union_id=tm.wx_union_id WHERE tu.tenant_id=? AND tu.un_assign_flag=? AND tu.union_id IS NOT ? AND tu.create_time>=? AND tu.create_time<=? ORDER BY id LIMIT ? OFFSET ?|1|1|1||0|0|3050|3050|0|0|
|tenant|SELECT * FROM `erp_sales_detail_back_?`|1|133|133||0|0|902339|902339|902339|902339|
|payment|SELECT * FROM `refund_order`|1|1|1||0|0|14228|14228|14228|14228|
|v4_user|SELECT * FROM `potential_customer_follow`|1|42|42||0|0|712885|712885|712885|712885|
|tenant|SELECT * FROM `tenant_wechatapp_para`|1|1|1||0|0|11417|11417|11417|11417|
|account|SELECT * FROM `wx_redpacket_send_order`|1|127|127||0|0|886195|886195|886195|886195|
|v4_sales|SELECT * FROM `comment_not_remind_sales`|1|3|3||0|0|119637|119637|119637|119637|
|v4_user|SELECT * FROM `employee_external_bind_log`|1|515|515||0|0|11746196|11746196|11746196|11746196|
|account|SELECT * FROM `account_flow`|1|1026|1026||0|0|16311924|16311924|16311924|16311924|
|customer|SELECT * FROM `customer_entry_shop`|1|4|4||0|0|38729|38729|38729|38729|
|youzan|SELECT * FROM `weimob_message_push`|1|14|14||0|0|198183|198183|198183|198183|
|v4_user|SELECT * FROM `reception_customer_deal`|1|534|534||0|0|8883894|8883894|8883894|8883894|
|corpwx|SELECT * FROM `corp_mini_qrcode_params`|1|22|22||0|0|727897|727897|727897|727897|
|v4_user|SELECT * FROM `member_points_import_log`|1|5|5||0|0|122043|122043|122043|122043|
|export|SELECT * FROM `export_log`|1|1|1||0|0|63307|63307|63307|63307|
|v4_user|SELECT * FROM `member_points_clear_task_detail`|1|3|3||0|0|59778|59778|59778|59778|
|employee|SELECT * FROM `batch_job_execution`|1|5|5||0|0|125594|125594|125594|125594|
|tenant|SELECT * FROM `sneak_guest`|1|59|59||0|0|878424|878424|878424|878424|
|v4_user|SELECT * FROM `member_points_detail`|1|145|145||0|0|3114316|3114316|3114316|3114316|
|employee|SELECT * FROM `backlog_system`|1|102|102||0|0|1436221|1436221|1436221|1436221|
|employee|SELECT * FROM `backlog_file`|1|299|299||0|0|9961604|9961604|9961604|9961604|
|customize_page|SELECT * FROM `customize_page`|1|3|3||0|0|5673|5673|5673|5673|
|value_added|SELECT * FROM `value_added_user`|1|113|113||0|0|2106487|2106487|2106487|2106487|
|corpwx|SELECT * FROM `external_user_bind`|1|88|88||0|0|3493142|3493142|3493142|3493142|
|tenant|SELECT * FROM `sneak_guest_maintain`|1|692|692||0|0|3858145|3858145|3858145|3858145|
|corpwx_license|SELECT * FROM `app_blocked`|1|1|1||0|0|20890|20890|20890|20890|
|payment|SELECT * FROM `refund_order_msg`|1|10|10||0|0|14228|14228|14228|14228|
|check_stock|SELECT * FROM `realtime_gold_price_sync_log`|1|3|3||0|0|136850|136850|136850|136850|
|activity_service|SELECT * FROM `activity_qualified`|1|4|4||0|0|118606|118606|118606|118606|
|corpwx|SELECT * FROM `external_userid_transform`|1|169|169||0|0|7697250|7697250|7697250|7697250|
|corpwx|SELECT * FROM `cwx_user`|1|3|3||0|0|52323|52323|52323|52323|
|comment_service|SELECT * FROM `comment_reward`|1|25|25||0|0|483759|483759|483759|483759|
|customize_page|SELECT * FROM `award_receive_detail`|1|3|3||0|0|84220|84220|84220|84220|
|activity_service|SELECT * FROM `activity_signup_user_apply`|1|7|7||0|0|22312|22312|22312|22312|
|order|SELECT * FROM `order_detail`|1|17|17||0|0|263749|263749|263749|263749|
|corpwx|SELECT * FROM `mini_app_msg`|1|1583|1583||0|0|12380021|12380021|12380021|12380021|
|youzan|SELECT * FROM `youzan_platform_sync_log`|1|16|16||0|0|175822|175822|175822|175822|
|score_player|SELECT * FROM `score_flow`|1|2|2||0|0|34499|34499|34499|34499|
|sms|SELECT * FROM `sms_send`|1|894|894||0|0|9339692|9339692|9339692|9339692|
|v4_sales|SELECT * FROM `warranty_detail_img`|1|95|95||0|0|1342333|1342333|1342333|1342333|
|export|SELECT * FROM `export_file`|1|2|2||0|0|42676|42676|42676|42676|
|v4_user|SELECT DATE_FORMAT(t?.create_time,?) AS statistic_date,DATE_FORMAT(t?.create_time,?) AS statistic_month,DATE_FORMAT(t?.update_time,?) AS busi_date,t?.tenant_id,t?.tenant_app_id,t?.scene AS channleName,t?.template_id AS templateId,ct.coupon_name,ifnull(sp.id,?) AS shopId,? AS `status`,?*count(es.id) AS `order`,?*ifnull(sum(es.amount),?) AS dealAmount FROM v4_coupon.coupon t? JOIN v4_coupon.coupon_template ct ON t?.template_id=ct.id JOIN v4_coupon.coupon_write_off t? ON t?.id=t?.coupon_id AND t?.type=? JOIN v4_sales.erp_sales_detail esd ON esd.tenant_id=? AND convert(t?.id,char)=esd.product_barcode AND esd.sales_type=? JOIN v4_sales.erp_sales es ON es.tenant_id=? AND es.tenant_app_id=? AND es.sales_erp_id=esd.sales_erp_id AND t?.business_id=es.sales_erp_id AND es.sales_status IN(?) LEFT JOIN v4_employee.shop sp ON sp.tenant_id=? AND t?.dept_erp_id=sp.dept_id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<? AND t?.`status`=? GROUP BY DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.update_time,?),t?.tenant_id,t?.tenant_app_id,t?.scene,t?.template_id,sp.id,ct.coupon_name LIMIT ? OFFSET ?|1|1|1||0|0|966|966|0|0|
|v4_user|SELECT * FROM `wx_user`|1|369|369||0|0|5233212|5233212|5233212|5233212|
|account|SELECT * FROM `store_card_log`|1|1|1||0|0|10354|10354|10354|10354|
|sms|SELECT * FROM `sms_report`|1|666|666||0|0|10734191|10734191|10734191|10734191|
|v4_user|SELECT * FROM `sjfx_dct_member`|1|2|2||0|0|108339|108339|108339|108339|
