|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|statistic|SELECT mb.tenant_id,mb.tenant_app_id,ifnull(mt.shop_id,?)shop_id,ifnull(mt.grade_erp_id,?)grade_erp_id,count(*)amount FROM member mb INNER JOIN member_extra mt ON mb.tenant_id=mt.tenant_id AND mb.id=mt.id WHERE mb.tenant_id=? AND mb.tenant_app_id=? AND mb.create_time<=? AND mb.register_flag=? GROUP BY mb.tenant_id,mb.tenant_app_id,mt.shop_id,mt.grade_erp_id|13|1575|186||0|0|12208520|1616654|2718|461|
|v4_statistic|SELECT statistic_date,statistic_month,statistic_version,busi_date,sale_status,tenant_id,tenant_app_id,shop_id,employee_id,sales_order,sales_amount,birth_order,birth_amount,no_sales_order,no_sales_amount,new_sales_order,new_sales_amount,old_sales_order,old_sales_amount,update_time FROM bi_member_sales WHERE tenant_id=? AND tenant_app_id=? AND update_time>=? AND tenant_id=? AND tenant_app_id=? LIMIT ? OFFSET ?|13|1588|155||0|0|792951|86701|52951|5000|
|statistic|SELECT mb.tenant_id,mb.tenant_app_id,ifnull(mt.shop_id,?)shop_id,ifnull(mt.employee_user_id,?)employee_user_id,count(*)amount FROM member mb INNER JOIN member_extra mt ON mb.tenant_id=mt.tenant_id AND mb.id=mt.id WHERE mb.tenant_id=? AND mb.tenant_app_id=? AND mb.create_time<=? AND mb.register_flag=? GROUP BY mb.tenant_id,mb.tenant_app_id,mt.shop_id,mt.employee_user_id|10|1195|159||0|0|9230786|1618664|6939|1466|
|statistic|SELECT mb.tenant_id,mb.tenant_app_id,ifnull(mt.shop_id,?)shop_id,sum(if(mb.subscribe_flag=?,?,?))cancel_amount,sum(if(mb.subscribe_flag=?,?,?))subscribe_amount,sum(if(mb.bind_flag=?,?,?))bind_amount,sum(if(mb.full_flag=?,?,?))full_amount FROM member mb INNER JOIN member_extra mt ON mb.tenant_id=mt.tenant_id AND mb.id=mt.id WHERE mb.tenant_id=? AND mb.tenant_app_id=? AND mb.create_time<=? AND mb.register_flag=? GROUP BY mb.tenant_id,mb.tenant_app_id,mt.shop_id|7|959|157||0|0|7291808|1615908|379|88|
|statistic|SELECT mb.tenant_id,mb.tenant_app_id,ifnull(mt.shop_id,?)shop_id,ifnull(mt.employee_user_id,?)user_id,count(*)service_amount,sum(if(mb.external_user_id IS NOT ?,?,?))corp_amount,sum(ifnull(mt.member_image_flag,?))image_amount FROM statistic.member mb INNER JOIN statistic.member_extra mt ON mb.tenant_id=mt.tenant_id AND mb.id=mt.id WHERE mb.tenant_id=? AND mb.tenant_app_id=? AND mb.create_time<=? AND mb.register_flag=? GROUP BY mb.tenant_id,mb.tenant_app_id,mt.shop_id,mt.employee_user_id|7|994|204||0|0|7302516|1618664|5733|1466|
|statistic|SELECT id,tenant_app_id,start_time,statistic_date,busi_type,type,status,create_time,update_time FROM timer_execute_log WHERE (status=?)|3|705|316||0|0|25483724|8498302|24|12|
|tag_service|SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.member_user_id AS member_id,t?.match_label,t?.match_label?,t?.match_feature_label FROM statistic.member t? JOIN tag_service.member_label_match_? t? ON t?.tenant_app_id=t?.tenant_app_id AND t?.user_id=t?.user_id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.member_user_id IS NOT ? ORDER BY t?.id LIMIT ? OFFSET ?|3|333|128||0|0|3863410|1813877|9952|5000|
|v4_statistic|DELETE FROM bi_member_sales WHERE tenant_id=? AND tenant_app_id=? AND busi_date=? AND statistic_version=? AND tenant_id=? AND tenant_app_id=?|2|818|413||0|0|1892212|1330553|0|0|
|v4_statistic|SELECT DATE_FORMAT(t?.sales_date,?) AS statistic_date,DATE_FORMAT(t?.sales_date,?) AS statistic_month,? AS statistic_version,DATE_FORMAT(t?.create_time,?) AS busi_date,? AS sale_status,t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id,count(*) AS birthOrder,ifnull(sum(t?.amount),?) AS birthAmount FROM biz_erp_sales t? JOIN member_? t? ON t?.tenant_id=t?.tenant_id AND t?.member_id=t?.id AND DATE_FORMAT(t?.sales_date,?)=DATE_FORMAT(t?.curr_month_birthday,?) WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.create_time>=? AND t?.create_time<? AND t?.sales_status IN (?) AND t?.tenant_id=? AND t?.tenant_app_id=? GROUP BY t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id,DATE_FORMAT(t?.sales_date,?),DATE_FORMAT(t?.sales_date,?),DATE_FORMAT(t?.create_time,?) LIMIT ? OFFSET ?|2|311|175||0|0|1326436|665462|3260|2752|
|v4_statistic|DELETE FROM member_mark_label_change WHERE (is_sync_wx=? AND create_time<?)|1|114|114||0|0|1151676|1151676|0|0|
|statistic|DELETE je FROM statistic.BATCH_JOB_EXECUTION_PARAMS je JOIN statistic.BATCH_JOB_EXECUTION e ON je.job_execution_id=e.job_execution_id WHERE e.job_execution_id<=?|1|218|218||0|0|3886780|3886780|0|0|
|v4_statistic|SELECT DATE_FORMAT(t?.sales_date,?) AS statistic_date,DATE_FORMAT(t?.sales_date,?) AS statistic_month,? AS statistic_version,DATE_FORMAT(t?.update_time,?) AS busi_date,? AS sale_status,t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id,?*count(*) AS birthOrder,?*ifnull(sum(t?.amount),?) AS birthAmount FROM biz_erp_sales t? JOIN member_? t? ON t?.tenant_id=t?.tenant_id AND t?.member_id=t?.id AND DATE_FORMAT(t?.sales_date,?)=DATE_FORMAT(t?.curr_month_birthday,?) WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<? AND t?.sales_status=? AND t?.tenant_id=? AND t?.tenant_app_id=? GROUP BY t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id,DATE_FORMAT(t?.sales_date,?),DATE_FORMAT(t?.sales_date,?),DATE_FORMAT(t?.update_time,?) LIMIT ? OFFSET ?|1|105|105||0|0|659958|659958|0|0|
|v4_statistic|DELETE FROM BATCH_JOB_EXECUTION_PARAMS WHERE job_execution_id<=?|1|112|112||0|0|343917|343917|0|0|
