|数据库名称|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|67|8249|350||0|0|48767532|1003604|14133|401|
|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|62|7703|324||0|0|45641664|1003382|38779|1586|
|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|59|7182|291||0|0|43062266|1003382|37354|1601|
|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|58|6870|262||0|0|43559946|1003356|9684|277|
|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|55|6773|286||0|0|40913372|1002976|2747|87|
|statistic|select oe.employee_id id , oe.employee_name name from result_employee_task t inner join meta_erp_employee oe on t.tenant_app_id = oe.tenant_app_id and t.shop_id = oe.dept_erp_id and t.user_id = oe.employee_erp_id and oe.employee_status = :1 where t.tenant_id = :2 and t.tenant_app_id = :3 and t.shop_id = :4 and t.busi_date between :5 and :6 and oe.shop_id > :7 and oe.employee_id > :8 group by oe.employee_id , oe.employee_name order by oe.employee_name|4|562|154||0|0|11711170|2927793|79|20|
|statistic|delete from statistic.batch_job_execution where job_execution_id <= :1|1|287|287||0|0|2229248|2229248|0|0|
|statistic|delete from statistic.batch_step_execution where step_execution_id <= :1|1|245|245||0|0|873498|873498|0|0|
|statistic|delete from statistic.batch_job_execution_params where job_execution_id <= :1|1|442|442||0|0|4348665|4348665|0|0|
