|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|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|84|11409|255||0|0|52162850|983994|14446|399|
|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|78|10205|214||0|0|50252210|983702|49303|1430|
|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|76|9798|211||0|0|48885006|983748|10883|276|
|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|74|9608|235||0|0|48207342|983476|3228|87|
|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|66|8588|217||0|0|44027870|983808|44654|1430|
|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|53|7057|190||0|0|351306361|7128741|1060|20|
|tag_service|update member_label_match set match_label = :1 where id = :2|25|3532|243||397|51|205784512|8657568|0|0|
|tag_service|select id , tenant_id , tenant_app_id , user_id , match_label , match_label2 from member_label_match where id = :1|3|330|113||0|0|25972520|8657568|3|1|
|statistic|delete from statistic.batch_step_execution where step_execution_id <= :1|1|161|161||0|0|853859|853859|0|0|
|tag_service|select t1.id , t1.tenant_id as tenantid , t1.tenant_app_id as tenantappid , ifnull ( dept.shop_id , ifnull ( dept.dept_erp_id , 0 ) ) as shopid , ifnull ( t1.user_id , t1.member_user_id ) as userid , ifnull ( t2.employee_user_id , ifnull ( t1.employee_user_id , 0 ) ) as employeeid , ifnull ( t1.age , - 1 ) as age , ifnull ( t1.sex , 0 ) as sex , t1.mobile_no as mobileno , date_format ( t1.birthday , '%y-%m-%d' ) as birthday , ifnull ( t1.birthday_is_lunar , 0 ) as birthdayislunar , t1.birthday_month_day as birthdaymonthday , t1.identity , t1.source_type as sourcetype , ifnull ( t1.subscribe_flag , 0 ) as subscribeflag , ifnull ( t1.register_flag , 1 ) as registerflag , t1.bind_flag as bindflag , t1.full_flag as fullflag , date_format ( t1.memorial_day , '%y-%m-%d' ) as memorialday , t1.memorial_day_is_lunar as memorialdayislunar , t2.grade_erp_id as gradeerpid , t2.sales_balance as salesbalance , t2.sales_amount as salesamount , t2.consumption_integral as consumptionintegral , t2.cumulation , t2.balance , t2.service_amount as serviceamount , ifnull ( t2.registe_time , t1.create_time ) as registetime , t2.first_shop_time as firstshoptime , t2.last_shop_time as lastshoptime , t2.first_sales_time as firstsalestime , t2.last_sales_time as lastsalestime , t2.last_login_time as lastlogintime , t2.last_score_time as lastscoretime , t2.follow_time as followtime , t2.cancel_follow_time as cancelfollowtime , t2.bind_time as bindtime , t2.last_service_time as lastservicetime , t2.category_id as categoryid , t2.last_sale_balance as lastsalebalance , t2.last_stone_weight as laststoneweight , t2.last_gold_weight as lastgoldweight , t2.last_category_id as lastcategoryid , t1.external_user_id as externaluserid , ifnull ( t1.agency_id , 0 ) as agencyid , ifnull ( t1.partner_id , 0 ) as partnerid , ifnull ( la.match_label , 0 ) as matchlabel from statistic.member t1 join statistic.member_extra t2 on t1.id = t2.id left join tag_service.member_label_match la on la.tenant_id = :1 and t1.tenant_app_id = la.tenant_app_id and t1.user_id = la.user_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 where t1.tenant_app_id = :2 and t2.tenant_app_id = :3 and t1.id >= :4 and t1.id <= :5 limit :6 offset :7|1|100|100||0|0|365756|365756|1439|1439|
