|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|statistic|select mt.tenant_id , mt.tenant_app_id , ifnull ( mt.shop_id , -1 ) shop_id , ifnull ( mt.employee_user_id , -1 ) employee_user_id , count ( * ) amount from member mb inner join member_extra mt on mb.id = mt.id where mb.tenant_app_id = :1 and mb.create_time <= :2 and mb.register_flag = :3 group by mt.tenant_id , mt.tenant_app_id , mt.shop_id , mt.employee_user_id|41|6806|394||0|0|28398876|983332|22167|1520|
|statistic|select mt.tenant_id , mt.tenant_app_id , ifnull ( mt.shop_id , -1 ) shop_id , ifnull ( mt.grade_erp_id , -1 ) grade_erp_id , count ( * ) amount from member mb inner join member_extra mt on mb.id = mt.id where mb.tenant_app_id = :1 and mb.create_time <= :2 and mb.register_flag = :3 group by mt.tenant_id , mt.tenant_app_id , mt.shop_id , mt.grade_erp_id|40|6519|363||0|0|29592742|983496|9620|399|
|statistic|select mb.tenant_id , mb.tenant_app_id , ifnull ( mt.shop_id , -1 ) shop_id , sum ( if ( mb.subscribe_flag = 1 , 0 , 1 ) ) cancel_amount , sum ( if ( mb.subscribe_flag = 1 , 1 , 0 ) ) subscribe_amount , sum ( if ( mb.bind_flag = 1 , 1 , 0 ) ) bind_amount , sum ( if ( mb.full_flag = 1 , 1 , 0 ) ) full_amount from member mb inner join member_extra mt on mb.id = mt.id where mb.tenant_app_id = :1 and mb.create_time <= :2 and mb.register_flag = :3 group by mb.tenant_id , mb.tenant_app_id , mt.shop_id|36|5259|391||0|0|23407538|982628|1440|87|
|tag_service|select t1.user_id , t1.user_name , t1.sex , t1.mobile_no , t1.age , t1.source_type as membersource , t1.subscribe_flag as subscribestatus , t1.full_flag as fullstatus , t2.grade_erp_id as gradeerp , t2.sales_balance as totalconsumemoney , t2.consumption_integral as totalconsumepoint , t2.cumulation as totalpoint , t2.balance as pointbalance , t2.sales_amount as consumenum , t2.follow_time as subscribetime , t2.cancel_follow_time as cancelsubscribetime , date_format ( t1.birthday , '%y-%m-%d' ) as birthday , ifnull ( t1.birthday_is_lunar , 0 ) as birthdayislunar , date_format ( t1.memorial_day , '%y-%m-%d' ) as memorialday , ifnull ( t1.memorial_day_is_lunar , 0 ) as memorialdayislunar , ifnull ( t1.memorial_name , '' ) as memorialname , t2.first_shop_time as firstentershoptime , t2.last_shop_time as lastentershoptime , t2.first_sales_time as firstconsumetime , t2.last_sales_time as latestconsumetime , t2.last_login_time as lastaccesstime , t2.last_service_time as lastservicetime , t2.last_score_time as lastscoretime , t2.registe_time as registertime , t2.category_name as categoryname , ( case when ifnull ( t1.partner_id , 0 ) > 0 then '联盟商家' when ifnull ( t1.agency_id , 0 ) > 0 then '钻石大使' else '会员' end ) as `identity` , ( case when t1.external_user_id is not null and t1.register_flag = :1 then :2 when t1.subscribe_flag = :3 and t1.register_flag = :4 then :5 else :6 end ) as `memberstate` , ifnull ( emp.employee_name , :7 ) as employeename , ifnull ( dept.shop_name , :8 ) as shopname , t1.tenant_app_open_id , t2.service_amount , ifnull ( t3.match_label , :9 ) as labelmatch from statistic.member t1 join statistic.member_extra t2 on t1.id = t2.id left join statistic.meta_erp_employee emp on t2.tenant_app_id = emp.tenant_app_id and t2.shop_id = emp.dept_erp_id and t2.employee_user_id = emp.employee_erp_id left join statistic.meta_erp_dept dept on t2.tenant_app_id = dept.tenant_app_id and t2.shop_id = dept.dept_erp_id left join tag_service.member_label_match t3 on t3.tenant_id = :10 and t1.tenant_app_id = t3.tenant_app_id and t1.user_id = t3.user_id where t1.tenant_app_id = :11 and t2.tenant_app_id = :12 order by t1.id asc limit :13|36|4737|187||0|0|238038336|6728517|720|20|
|statistic|select mb.tenant_id , mb.tenant_app_id , ifnull ( mt.shop_id , -1 ) shop_id , ifnull ( mb.source_type , 'unknow' ) source_type , count ( * ) amount from member mb inner join member_extra mt on mb.id = mt.id where mb.tenant_app_id = :1 and mb.create_time <= :2 and mb.register_flag = :3 group by mb.tenant_id , mb.tenant_app_id , mt.shop_id , mb.source_type|35|5637|445||0|0|23838738|983142|5310|276|
|statistic|select mb.tenant_id , mb.tenant_app_id , ifnull ( mt.shop_id , -1 ) shop_id , ifnull ( mt.employee_user_id , -1 ) user_id , count ( * ) service_amount , sum ( if ( mb.external_user_id is not null , 1 , 0 ) ) corp_amount , sum ( ifnull ( mt.member_image_flag , 0 ) ) image_amount from statistic.member mb inner join statistic.member_extra mt on mb.id = mt.id where mb.tenant_app_id = :1 and mb.create_time <= :2 and mb.register_flag = :3 group by mb.tenant_id , mb.tenant_app_id , mt.shop_id , mt.employee_user_id|29|4061|340||0|0|18443156|983270|18021|1520|
|tag_service|select t1.user_id , t1.user_name , t1.sex , t1.mobile_no , t1.age , t1.source_type as membersource , t1.subscribe_flag as subscribestatus , t1.full_flag as fullstatus , t2.grade_erp_id as gradeerp , t2.sales_balance as totalconsumemoney , t2.consumption_integral as totalconsumepoint , t2.cumulation as totalpoint , t2.balance as pointbalance , t2.sales_amount as consumenum , t2.follow_time as subscribetime , t2.cancel_follow_time as cancelsubscribetime , date_format ( t1.birthday , '%y-%m-%d' ) as birthday , ifnull ( t1.birthday_is_lunar , 0 ) as birthdayislunar , date_format ( t1.memorial_day , '%y-%m-%d' ) as memorialday , ifnull ( t1.memorial_day_is_lunar , 0 ) as memorialdayislunar , ifnull ( t1.memorial_name , '' ) as memorialname , t2.first_shop_time as firstentershoptime , t2.last_shop_time as lastentershoptime , t2.first_sales_time as firstconsumetime , t2.last_sales_time as latestconsumetime , t2.last_login_time as lastaccesstime , t2.last_service_time as lastservicetime , t2.last_score_time as lastscoretime , t2.registe_time as registertime , t2.category_name as categoryname , ( case when ifnull ( t1.partner_id , 0 ) > 0 then '联盟商家' when ifnull ( t1.agency_id , 0 ) > 0 then '钻石大使' else '会员' end ) as `identity` , ( case when t1.external_user_id is not null and t1.register_flag = :1 then :2 when t1.subscribe_flag = :3 and t1.register_flag = :4 then :5 else :6 end ) as `memberstate` , ifnull ( emp.employee_name , :7 ) as employeename , ifnull ( dept.shop_name , :8 ) as shopname , t1.tenant_app_open_id , t2.service_amount , ifnull ( t3.match_label , :9 ) as labelmatch from statistic.member t1 join statistic.member_extra t2 on t1.id = t2.id left join statistic.meta_erp_employee emp on t2.tenant_app_id = emp.tenant_app_id and t2.shop_id = emp.dept_erp_id and t2.employee_user_id = emp.employee_erp_id left join statistic.meta_erp_dept dept on t2.tenant_app_id = dept.tenant_app_id and t2.shop_id = dept.dept_erp_id left join tag_service.member_label_match t3 on t3.tenant_id = :10 and t1.tenant_app_id = t3.tenant_app_id and t1.user_id = t3.user_id where t1.tenant_app_id = :11 and t2.tenant_app_id = :12 and t3.match_label = :13 order by t1.id asc limit :14|6|837|150||0|0|10026006|1671001|120|20|
|tag_service|update member_label_match set match_label = :1 where id = :2|4|564|175||38|38|34613566|8653478|0|0|
|statistic|delete from statistic.batch_step_execution where step_execution_id <= :1|1|334|334||0|0|857313|857313|0|0|
|statistic|select tenant_id , tenant_app_id , ifnull ( shop_id , -1 ) shop_id , sum ( if ( tenant_app_open_id is null and external_user_id is null , :1 , :2 ) ) normal_amount , sum ( if ( tenant_app_open_id is not null and external_user_id is null , :3 , :4 ) ) app_amount , sum ( if ( external_user_id is not null , :5 , :6 ) ) corp_amount from member where tenant_app_id = :7 and create_time <= :8 and register_flag = :9 group by tenant_id , tenant_app_id , shop_id|1|101|101||0|0|491401|491401|87|87|
