|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|user_service|select ue.employee_id as employeeid , count ( * ) as quantity from user_service.user_employee ue join user_service.tenant_member_info tmi on ue.tenant_id = tmi.tenant_id and ue.tenant_wechatapp_id = tmi.tenant_app_id and ue.user_id = tmi.user_id join user_service.tenant_member tm on tm.tenant_id = tmi.tenant_id and tm.id = tmi.id where ue.employee_id in ( :1 ) and ue.tenant_id = :2 and ue.tenant_wechatapp_id = :3 and tmi.shop_id = :4 group by ue.employee_id|545|948|11||0|0|165201891|514464|535|1|
|corpwx|update external_user set un_assign_flag = :1 where ( tenant_id = :2 and un_assign_flag = :3 )|148|229|9||0|0|182414906|1267643|0|0|
|value_added|select id , template_name as templatename , added_percent_per_day as addedpercentperday , add_days as adddays , keeping_days as keepingdays , devalue_percent_per_day as devaluepercentperday , exchange_days as exchangedays , is_disable as isdisable , effective_days as effectivedays , ifnull ( usenumber , 0 ) as usenumber , generator_method as generatormethod , remark as remark from value_added_template left join ( select template_id , count ( * ) usenumber from value_added_user where tenant_wechatapp_id = :1 group by template_id ) value_added_user on value_added_template.id = value_added_user.template_id where tenant_wechatapp_id = :2 and id = :3|80|228|10||0|0|10407404|206707|80|1|
|tenant|select count ( * ) from tenant.sneak_guest_maintain where tenant_id = :1 and tenant_app_id = :2 and shop_id = :3 and event_type = :4 and create_time between :5 and :6|57|143|6||0|0|3964443|120403|57|1|
|authorization_service|update user_login_token set status = :1 , update_time = now ( ) where employee_id = :2 and tenant_id = :3 and tenant_wx_app_id = :4 and shop_id = :5 and login_way = :6 and status = :7|44|261|10||0|0|140|8|0|0|
|tenant|select count ( 0 ) from erp_sales es where es.tenant_id = :1 and es.tenant_wechatapp_id = :2 and es.sales_date >= :3 and es.employee_erp_id = :4 and es.sales_status = :5|35|314|12||0|0|3712172|106079|35|1|
|user_service|select count ( * ) from user_service.tenant_member tm left join user_service.user_employee t3 on tm.tenant_id = t3.tenant_id and tm.user_id = t3.user_id and tm.tenant_app_id = t3.tenant_wechatapp_id join user_service.tenant_member_bind tmb on tm.tenant_id = tmb.tenant_id and tm.id = tmb.id join user_service.tenant_member_info tmi on tm.tenant_id = tmi.tenant_id and tm.id = tmi.id where t3.id is null and tmi.shop_id = :1 and tmi.tenant_app_id = :2 and tmi.tenant_id = :3|29|42|3||0|0|5470218|446933|29|1|
|user_service|select count ( 0 ) from ( select tm.user_id as id , tm.user_name as username , tm.head_img_url as headimgurl , tm.user_name as nickname , tm.mobile_no as mobile , tm.sex , if ( ifnull ( wu.is_subscribe , 0 ) = 0 , false , true ) as hassubscribe from user_service.tenant_member tm left join user_service.user_employee ue on tm.tenant_id = ue.tenant_id and tm.tenant_app_id = ue.tenant_wechatapp_id and tm.user_id = ue.user_id join user_service.tenant_member_info tmi on tmi.tenant_id = tm.tenant_id and tmi.id = tm.id join user_service.tenant_member_bind tmb on tmb.tenant_id = tm.tenant_id and tmb.tenant_app_id = tm.tenant_app_id and tmb.user_id = tm.user_id left join user_service.wx_user wu on wu.id = tmb.wx_user_id where tm.tenant_id = :1 and tm.tenant_app_id = :2 order by tm.id desc ) tmp_count|27|105|12||0|0|7509648|700111|27|1|
|shop_work|select * from shop_work.work_report wr where exists ( select * from shop_work.task t where t.tenant_id = wr.tenant_id and t.task_group_id = wr.id and t.status = :1 and t.task_type = :2 ) and tenant_id = :3|22|81|5||0|0|6783154|309398|22732|1048|
|erp_sync|select * from erp_sync.retry_data where ( need_erp_member_id = :1 or ( need_erp_member_id = :2 and erp_member_id is not null ) ) and retry_times > :3 order by id|18|35|3||0|0|2114825|117491|558|31|
|tenant|select es.id , es.sales_no , es.sales_date , es.member_erp_id , es.sales_erp_id , es.is_sales from erp_sales es where es.tenant_id = :1 and es.tenant_wechatapp_id = :2 and es.sales_status = :3 and es.sales_no like concat ( :4 , :5 ) order by es.sales_date desc limit :6|14|52|6||0|0|8462419|904050|1|1|
|order|select max ( create_time ) from `order`.order_operator_log where tenant_wechatapp_id = :1 and order_id = :2|10|17|4||0|0|4885017|488522|10|1|
|coupon_service|update coupon_service.coupon_write_off_log set state = :1 where coupon_id = :2|10|28|4||0|0|11348213|1136398|0|0|
|item_manage|select id , tenant_id , `name` , `describe` , `type` , parent_id , employee_id , status , start_time , end_time , startup_time , submit_time , sub_num , sub_complete_num , delete_flag , dynamic_update_time , before_status from task where ( tenant_id = :1 and type = :2 and parent_id = :3 )|9|10|1||0|0|390052|43420|8|1|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and union_id = :2 )|8|14|2||0|0|603158|137216|1|1|
|comment_service|select *from comment_service.comment_reward where comment_id = :1 limit :2|8|10|1||0|0|1244256|155658|4|1|
|tenant|select *from warranty_service.warranty where tenant_wechatapp_id = :1|7|16|4||0|0|70483|17285|70483|17285|
|account|select id , tenant_id , tenant_wechatapp_id , shop_id , account_type , user_id , mch_billno , send_name , mch_id , sub_mch_id , wxappid , msgappid , re_openid , total_amount , total_num , wishing , client_ip , act_name , remark , scene_id , risk_info , consume_mch_id , send_time , order_status , failure_reason , biz_id , biz_type , biz_tag , send_listid , need_callback , create_time , update_time , user_name , mobile_no , receive_time , refund_amount , refund_time from wx_redpacket_send_order where order_status in ( :1 , :2 ) order by id desc|7|9|1||0|0|519459|74220|148|24|
|shop_work|select t.task_category , t.task_template_id , ti.task_item_template_id , ti.field_type , ti.field_name , sum ( if ( ti.field_type = 'type_bool' and ti.value in ( :1 , :2 ) , :3 , :4 ) ) as bool_true_count , sum ( if ( ti.field_type = :5 and ti.value in ( :6 , :7 ) , :8 , :9 ) ) as bool_false_count , sum ( if ( ti.field_type = :10 , :11 , :12 ) ) as string_count , sum ( if ( ti.field_type = :13 , :14 , :15 ) ) as date_count , sum ( if ( ti.field_type = :16 , ti.value , :17 ) ) as number_sum , sum ( if ( ti.field_type = :18 , substring_index ( ti.value , :19 , :20 ) , :21 ) ) as progress_target , sum ( if ( ti.field_type = :22 , substring_index ( ti.value , :23 , :24 ) , :25 ) ) as progress_reach from shop_work.work_report wr join shop_work.task t on wr.id = t.task_group_id join shop_work.task_item ti on ti.task_id = t.id where wr.tenant_id = :26 and wr.shop_id = :27 and wr.create_time >= :28 and wr.create_time < :29 and wr.report_type = :30 and wr.status = :31 and wr.execute_role = :32 and ti.status != :33 and ti.field_type in ( :34 , :35 , :36 , :37 , :38 ) and ti.value is not null and t.status = :39 group by t.task_category , t.task_template_id , ti.task_item_template_id , ti.field_type , ti.field_name|7|25|5||0|0|8359057|1511177|63|11|
|sms|select count ( 0 ) from ( select a.phone_numbers as phoneno , concat ( '【' , a.sign_name , '】' , case when b.content is not null then b.content when stc.content is not null then stc.content else a.template_param end ) as content , a.template_code , a.out_id as outid , a.template_param , a.create_time as sendtime , a.create_time as recevietime , a.code as state , a.send_count , a.message , a.source_type from sms_send a left join sms_template b on a.template_code = b.code left join sms_template_custom stc on a.tenant_app_id = stc.tenant_app_id and a.template_code = stc.code and stc.status = :1 where a.tenant_id = :2 ) table_count|5|209|50||0|0|24120729|4971959|5|1|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and un_assign_flag = :2 and wx_user_id = :3 )|5|8|2||0|0|290815|108395|186|186|
|sms|select a.phone_numbers as phoneno , concat ( '【' , a.sign_name , '】' , case when b.content is not null then b.content when stc.content is not null then stc.content else a.template_param end ) as content , a.template_code , a.out_id as outid , a.template_param , a.create_time as sendtime , a.create_time as recevietime , a.code as state , a.send_count , a.message , a.source_type from sms_send a left join sms_template b on a.template_code = b.code left join sms_template_custom stc on a.tenant_app_id = stc.tenant_app_id and a.template_code = stc.code and stc.status = :1 where a.tenant_id = :2 order by a.create_time desc limit :3|5|125|35||0|0|23303170|4661330|100|20|
|employee|select id , tenant_id , tenant_app_id , backlog_id , url , status , create_time , update_time from backlog_file where ( tenant_id = :1 and tenant_app_id = :2 and backlog_id in ( :3 , :4 , :5 , :6 , :7 , :8 ) and status = :9 )|5|7|2||0|0|1569929|315150|12|6|
|employee|select id , tenant_id , tenant_app_id , backlog_id , url , status , create_time , update_time from backlog_file where ( tenant_id = :1 and tenant_app_id = :2 and backlog_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 ) and status = :13 )|5|6|1||0|0|1564488|314731|29|9|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115|4|9|4||0|0|2219724|615859|841|380|
|coupon_service|select count ( 0 ) from ( select cu.id , cu.coupon_name , cu.coupon_type , cu.coupon_no , cu.source as couponchannel , cu.coupon_state , ce.user_name , ce.creator_user_name as creatorname , if ( coupon_type in ( 'point' , 'interact_point' ) , cu.face_value , round ( cu.face_value/100 , 2 ) ) as facevalue , cu.begin_time , cu.end_time , ce.remark , ce.mobile_no , ce.creator_mobile_no , cu.create_time , wol.create_time as writeofftime , r.create_time as reservationdate , r.shop_name as reservationshopname , if ( wol.employee_id is null , wol.user_name , wol.employee_name ) writeoffusername , wol.shop_id as shopid , wol.dept_erp_id as erpdeptid , cu.user_id , ce.source_user_id , ce.source_user_type , cal.create_time as abolishtime , cal.employee_id as abolishemployeeid from coupon_service.coupon cu join coupon_service.coupon_extend ce on ce.id = cu.id left join coupon_service.coupon_write_off_log wol on wol.tenant_app_id = cu.tenant_app_id and wol.coupon_id = cu.id and wol.state = :1 left join coupon_service.reservation r on r.coupon_user_id = cu.id and r.state = :2 left join coupon_service.coupon_abolish_log cal on cal.tenant_id = cu.tenant_id and cal.tenant_app_id = cu.tenant_app_id and cal.coupon_id = cu.id where cu.tenant_app_id = :3 and cu.template_id = :4 ) tmp_count|4|23|7||0|0|619710|192803|4|1|
|employee|select tenant_id , tenant_app_id , employee_id , scene , shop_id , count ( * ) as record from backlog where tenant_app_id = :1 and employee_id = :2 and expire_time >= :3 and status in ( :4 , :5 ) group by tenant_id , tenant_app_id , employee_id , scene , shop_id|4|4|1||0|0|36435|15522|18|6|
|tenant|select erp_sales.id , erp_sales.sales_erp_id as saleserpid , erp_sales.sales_no as salesno , erp_sales.sales_date as salesdate , erp_sales.member_erp_id as membererpid , erp_sales.employee_erp_id as employeeerpid , erp_sales.employee_name as employeename , erp_sales.dept_erp_id as depterpid , erp_sales.amount as amount , erp_sales.sales_remark as salesremark , erp_sales.receipts as receipts , erp_sales.sales_status as salesstatus , erp_sales.busi_date as busidate , erp_department.dept_name as deptname , tenant.full_name as tenantfullname , tenant.short_name as tenantshortname from erp_sales join tenant.tenant_wechatapp tw on tw.is_disable = :1 and tw.id = erp_sales.tenant_wechatapp_id join erp_department on tw.tenant_id = erp_department.tenant_id and erp_department.dept_erp_id = erp_sales.dept_erp_id join tenant tenant on tw.tenant_id = tenant.id and tenant.`status` = :2 where :3 = :4 and tenant.id = :5 and erp_sales.sales_no = :6 limit :7|4|4|1||0|0|1952280|488070|4|1|
|coupon_service|select count ( 0 ) from ( select cu.id , cu.coupon_name , cu.coupon_type , cu.coupon_no , cu.source as couponchannel , cu.coupon_state , ce.user_name , ce.creator_user_name as creatorname , if ( coupon_type in ( 'point' , 'interact_point' ) , cu.face_value , round ( cu.face_value/100 , 2 ) ) as facevalue , cu.begin_time , cu.end_time , ce.remark , ce.mobile_no , ce.creator_mobile_no , cu.create_time , wol.create_time as writeofftime , r.create_time as reservationdate , r.shop_name as reservationshopname , if ( wol.employee_id is null , wol.user_name , wol.employee_name ) writeoffusername , wol.shop_id as shopid , wol.dept_erp_id as erpdeptid , cu.user_id , ce.source_user_id , ce.source_user_type , cal.create_time as abolishtime , cal.employee_id as abolishemployeeid from coupon_service.coupon cu join coupon_service.coupon_extend ce on ce.id = cu.id left join coupon_service.coupon_write_off_log wol on wol.tenant_app_id = cu.tenant_app_id and wol.coupon_id = cu.id and wol.state = :1 left join coupon_service.reservation r on r.coupon_user_id = cu.id and r.state = :2 left join coupon_service.coupon_abolish_log cal on cal.tenant_id = cu.tenant_id and cal.tenant_app_id = cu.tenant_app_id and cal.coupon_id = cu.id where cu.tenant_app_id = :3 and wol.create_time >= :4 and wol.create_time <= :5 and wol.shop_id = :6 ) tmp_count|4|8|3||0|0|113197|28511|4|1|
|user_service|select count ( 0 ) from user_service.tenant_member tm join user_service.tenant_member_info tmi on tm.tenant_id = tmi.tenant_id and tm.id = tmi.id left join user_service.tenant_member_bind tmb on tm.tenant_id = tmb.tenant_id and tm.id = tmb.id left join user_service.wx_user wu on tmb.wx_user_id = wu.id where tm.tenant_id = :1 and tm.tenant_app_id = :2 and tm.user_id not in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 )|4|5|1||0|0|370465|92620|4|1|
|employee|select count ( 0 ) from employee.backlog bg where bg.tenant_app_id = :1 and bg.leave_flag = :2|4|8|2||0|0|172480|43120|4|1|
|user_service|select * from user_employee where tenant_wechatapp_id = :1 and employee_id = :2|3|3|1||0|0|605540|305723|2|2|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and wx_user_id = :2 )|3|4|2||0|0|137350|108367|1|1|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 ,|3|8|3||0|0|1770621|728175|507|210|
|tenant|select count ( 0 ) from erp_sales join tenant.tenant_wechatapp tw on tw.is_disable = :1 and tw.id = erp_sales.tenant_wechatapp_id join erp_department on tw.tenant_id = erp_department.tenant_id and erp_department.dept_erp_id = erp_sales.dept_erp_id join tenant tenant on tw.tenant_id = tenant.id and tenant.`status` = :2 where :3 = :4 and tenant.id = :5|3|10|5||0|0|2113138|976123|3|1|
|order|select id from order_operator_log where tenant_wechatapp_id = :1 and order_id = :2 and ( src_child_status = :3 and dst_child_status = :4 ) order by create_time desc limit :5|3|5|1||0|0|1465371|488505|0|0|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and union_id in ( :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , ...|2|3|2||0|0|30601|18939|0|0|
|coupon_service|select count ( 0 ) from ( select egc.id , tmp.coupon_name , tmp.coupon_type , tmp.remark , cp.take_effect_way , cp.take_start_day , cp.take_effect_day , date_format ( cp.begin_time , '%y-%m-%d' ) as begin_time , date_format ( cp.end_time , '%y-%m-%d' ) as end_time , egc.limit_grant_time , date_format ( egc.grant_begin_time , '%y-%m-%d' ) as grant_begin_time , date_format ( egc.grant_end_time , '%y-%m-%d' ) as grant_end_time , ifnull ( tmp.face_value , 0 ) /100 as face_value , tmp.face_value as point , ifnull ( tmp.discount , 0 ) /10 as discount , tmp.scope , tmp.product_name , if ( egc.state = 'down' , 1 , ( case when cp.end_time is not null and cp.end_time < now ( ) then :1 when egc.limit_grant_time = :2 and egc.grant_end_time < now ( ) then :3 when tgl.put_quantity <= ( select count ( * ) from coupon_service.employee_give_coupon_log where employee_give_coupon_id = egc.id ) then :4 else :5 end ) ) as state , tr.type as redpacktype , ifnull ( tr.min_price , :6 ) /100 as minprice from coupon_service.employee_give_coupon egc inner join coupon_service.coupon_push cp on egc.template_id = cp.template_id and cp.source = :7 and egc.id = cp.source_id and cp.state = :8 inner join coupon_service.template tmp on egc.template_id = tmp.id and tmp.state = :9 inner join coupon_service.template_grant_limit tgl on cp.id = tgl.coupon_push_id left join coupon_service.template_redpack tr on tr.template_id = tmp.id where egc.tenant_app_id = :10 and egc.state = :11 and ( egc.limit_grant_time = :12 or egc.grant_begin_time <= now ( ) ) and ( egc.limit_shop = :13 or exists ( select 1 from coupon_service.employee_give_coupon_shop cs where egc.id = cs.employee_give_id and cs.shop_id = :14 ) ) and egc.limit_role in ( :15 , :16 ) order by state asc , egc.id desc ) tmp_count|2|2|1||0|0|791328|427407|2|1|
|erp_sync|select * from retry_data where tenant_app_id = :1 and user_id = :2|2|3|2||0|0|16528|10123|2|1|
|user_service|select count ( * ) from user_service.tenant_member_info t where t.tenant_id = :1 and t.tenant_app_id = :2 and t.shop_id = :3|2|3|1||0|0|377817|215016|2|1|
|coupon_service|select count ( 0 ) from ( select cu.id , cu.coupon_name , cu.coupon_type , cu.coupon_no , cu.source as couponchannel , cu.coupon_state , ce.user_name , ce.creator_user_name as creatorname , if ( coupon_type in ( 'point' , 'interact_point' ) , cu.face_value , round ( cu.face_value/100 , 2 ) ) as facevalue , cu.begin_time , cu.end_time , ce.remark , ce.mobile_no , ce.creator_mobile_no , cu.create_time , wol.create_time as writeofftime , r.create_time as reservationdate , r.shop_name as reservationshopname , if ( wol.employee_id is null , wol.user_name , wol.employee_name ) writeoffusername , wol.shop_id as shopid , wol.dept_erp_id as erpdeptid , cu.user_id , ce.source_user_id , ce.source_user_type , cal.create_time as abolishtime , cal.employee_id as abolishemployeeid from coupon_service.coupon cu join coupon_service.coupon_extend ce on ce.id = cu.id left join coupon_service.coupon_write_off_log wol on wol.tenant_app_id = cu.tenant_app_id and wol.coupon_id = cu.id and wol.state = :1 left join coupon_service.reservation r on r.coupon_user_id = cu.id and r.state = :2 left join coupon_service.coupon_abolish_log cal on cal.tenant_id = cu.tenant_id and cal.tenant_app_id = cu.tenant_app_id and cal.coupon_id = cu.id where cu.tenant_app_id = :3 and ce.mobile_no = :4 and cu.create_time >= :5 and cu.create_time <= :6 ) tmp_count|2|3|2||0|0|79032|39537|2|1|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and wx_user_id in ( :2 , :3 ) )|2|5|4||0|0|69759|44134|3|2|
|coupon_service|select count ( 0 ) from ( select egc.id , tmp.coupon_name , tmp.coupon_type , tmp.remark , cp.take_effect_way , cp.take_start_day , cp.take_effect_day , date_format ( cp.begin_time , '%y-%m-%d' ) as begin_time , date_format ( cp.end_time , '%y-%m-%d' ) as end_time , egc.limit_grant_time , date_format ( egc.grant_begin_time , '%y-%m-%d' ) as grant_begin_time , date_format ( egc.grant_end_time , '%y-%m-%d' ) as grant_end_time , ifnull ( tmp.face_value , 0 ) /100 as face_value , tmp.face_value as point , ifnull ( tmp.discount , 0 ) /10 as discount , tmp.scope , tmp.product_name , if ( egc.state = 'down' , 1 , ( case when cp.end_time is not null and cp.end_time < now ( ) then :1 when egc.limit_grant_time = :2 and egc.grant_end_time < now ( ) then :3 when tgl.put_quantity <= ( select count ( * ) from coupon_service.employee_give_coupon_log where employee_give_coupon_id = egc.id ) then :4 else :5 end ) ) as state , tr.type as redpacktype , ifnull ( tr.min_price , :6 ) /100 as minprice from coupon_service.employee_give_coupon egc inner join coupon_service.coupon_push cp on egc.template_id = cp.template_id and cp.source = :7 and egc.id = cp.source_id and cp.state = :8 inner join coupon_service.template tmp on egc.template_id = tmp.id and tmp.state = :9 inner join coupon_service.template_grant_limit tgl on cp.id = tgl.coupon_push_id left join coupon_service.template_redpack tr on tr.template_id = tmp.id where egc.tenant_app_id = :10 and egc.state = :11 and ( egc.limit_grant_time = :12 or egc.grant_begin_time <= now ( ) ) and ( egc.limit_shop = :13 or exists ( select 1 from coupon_service.employee_give_coupon_shop cs where egc.id = cs.employee_give_id and cs.shop_id = :14 ) ) and egc.limit_role in ( :15 , :16 , :17 ) order by state asc , egc.id desc ) tmp_count|2|2|1||0|0|1366112|1124032|2|1|
|employee|select id , tenant_id , tenant_app_id , backlog_id , url , status , create_time , update_time from backlog_file where ( tenant_id = :1 and tenant_app_id = :2 and backlog_id in ( :3 , :4 , :5 , :6 , :7 ) and status = :8 )|2|2|1||0|0|625464|313324|0|0|
|payment|select original_task_id from job_status_trace_log where task_id = :1 and state = :2|2|8|4||0|0|21868|10935|21868|10935|
|payment|select id , tenant_id , tenant_app_id , goods_order_source , goods_order_no , goods_name , goods_amount , fee_type , request_ip , user_id , user_identify , user_sub_identify , pay_way , trade_type , order_start_time , order_expire_time , prepay_id , transaction_id , pay_amount , pay_finish_time , pay_status , pay_status_desc , error_msg , wxappid , sub_wxappid , mch_id , sub_mch_id , callback_tag , callback_result , create_time , update_time from pay_order where callback_result in ( :1 , :2 ) and pay_status in ( :3 , :4 ) order by id asc limit :5|1|7|7||0|0|159345|159345|0|0|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 )|1|1|1||0|0|104317|104317|45|45|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and wx_user_id in ( :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 ) and un_assign_flag = :16 )|1|1|1||0|0|42765|42765|0|0|
|coupon_service|select *from coupon_service.coupon_market_order where pay_type in ( :1 , :2 ) and order_state = :3 and update_time <= date_sub ( now ( ) , interval :4 minute )|1|1|1||0|0|161737|161737|0|0|
|employee|select id , tenant_id , tenant_app_id , shop_id , employee_id , user_id , external_user_id , mobile_no , scene , status , begin_time , expire_time , create_time , update_time , directional_task_id , member_erp_id , finish_time , md5_str , tenant_open_id , data from backlog_system where ( tenant_app_id = :1 and scene = :2 and status = :3 and create_time between :4 and :5 )|1|1|1||0|0|106444|106444|339|339|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 )|1|1|1||0|0|172855|172855|12|12|
|order|select od.id , od.order_no orderno , od.status , od.take_type taketype , od.create_time createtime , od.remark , od.total_fee totalfee , od.freight_fee freightfee , od.discount_fee discountfee , od.take_id takeid , od.payment_fee paymentfee , dt.product_id productid , dt.price , dt.quantity , dt.sku_id skuid , dt.art_no artno , dt.image_url imageurl , dt.product_name productname , dt.take_remark takeremark , dt.take_day takeday , od.product_fee productfee , ad.user_name receivename , ad.mobile_no mobileno , ad.shop_name shopname , ad.address , ad.express_no expressno , ad.express_company expresscompany , od.finish_type finishtype , od.send_time sendtime , od.receive_time receivetime , od.finish_time finishtime , od.child_status childstatus , od.send_good_remark sendgoodremark , od.service_flag serviceflag , od.coupon_id couponid , od.tenant_wechatapp_id tenantappid , od.tenant_id from order_info od left join order_detail dt on od.id = dt.order_id left join order_address ad on od.id = ad.order_id where od.status = :1 and od.send_time <= :2 and od.take_type = :3|1|1|1||0|0|121422|121422|0|0|
|user_service|select count ( 0 ) from user_service.user_employee ue join user_service.tenant_member tm on tm.tenant_id = ue.tenant_id and tm.tenant_app_id = ue.tenant_wechatapp_id and tm.user_id = ue.user_id join user_service.tenant_member_info tmi on tmi.tenant_id = tm.tenant_id and tmi.id = tm.id where ue.employee_id = :1 and ue.tenant_id = :2 and ue.tenant_wechatapp_id = :3 and tmi.shop_id = :4 and ( tm.user_name like concat ( :5 , :6 , :7 ) or tm.mobile_no like concat ( :8 , :9 ) )|1|1|1||0|0|215085|215085|1|1|
|order|select od.id , od.order_no orderno , od.status , od.take_type taketype , od.create_time createtime , od.remark , od.total_fee totalfee , od.freight_fee freightfee , od.discount_fee discountfee , od.take_id takeid , od.payment_fee paymentfee , dt.product_id productid , dt.price , dt.quantity , dt.sku_id skuid , dt.art_no artno , dt.image_url imageurl , dt.product_name productname , dt.take_remark takeremark , dt.take_day takeday , od.product_fee productfee , od.finish_type finishtype , od.send_time sendtime , od.receive_time receivetime , od.finish_time finishtime , od.child_status childstatus , od.send_good_remark sendgoodremark , od.service_flag serviceflag , od.coupon_id couponid , od.tenant_wechatapp_id tenantappid , od.tenant_id tenantid , od.pay_id payid , od.user_id userid , od.user_name username , od.mobile_no buymobileno , od.activity_id , od.offline_payment_fee , od.activity_type , dt.spec , od.take_shop_id , od.take_shop_name , od.take_employee_user_id , od.take_employee_user_name from order_info od left join order_detail dt on od.id = dt.order_id where od.status = :1 and od.receive_time <= :2|1|1|1||0|0|121504|121504|82|82|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 )|1|2|2||0|0|411989|411989|6|6|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 )|1|1|1||0|0|569333|569333|96|96|
|mysql|delete from wx_gateway.wx_template_msg where create_time < date_sub ( now ( ) , interval :1 day )|1|49|49||0|0|1742599|1742599|0|0|
|activity_service|select count ( 0 ) from activity_service.user_trace ut left join activity_service.activity at on ut.activity_id = at.id where ut.step = :1 and ut.status = :2 and ut.activity_id = :3|1|6|6||0|0|1135790|1135790|1|1|
|user_service|select ue.user_id as id , tm.user_name as username , tm.head_img_url as headimgurl , tm.user_name as nickname , tm.mobile_no as mobile , tm.sex from user_service.user_employee ue join user_service.tenant_member tm on tm.tenant_id = ue.tenant_id and tm.tenant_app_id = ue.tenant_wechatapp_id and tm.user_id = ue.user_id join user_service.tenant_member_info tmi on tmi.tenant_id = tm.tenant_id and tmi.id = tm.id where ue.employee_id = :1 and ue.tenant_id = :2 and ue.tenant_wechatapp_id = :3 and tmi.shop_id = :4 order by tm.id desc limit :5|1|2|2||0|0|208773|208773|10|10|
|employee|update backlog_system set status = :1 , finish_time = now ( ) where tenant_app_id = :2 and scene = :3|1|1|1||0|0|205045|205045|0|0|
|coupon_service|select c.* from coupon_service.coupon c left join coupon_service.coupon_expire_task ct on ct.tenant_id = :1 and ct.tenant_app_id = :2 and c.id = ct.coupon_id where c.tenant_id = :3 and c.tenant_app_id = :4 and c.end_time between :5 and :6 and c.coupon_state in ( :7 ) and ct.id is null|1|3|3||0|0|32987|32987|23|23|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 )|1|1|1||0|0|270084|270084|80|80|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 )|1|1|1||0|0|219846|219846|107|107|
|user_service|select count ( 0 ) from user_service.tenant_member tm join user_service.tenant_member_info tmi on tm.tenant_id = tmi.tenant_id and tm.id = tmi.id left join user_service.tenant_member_bind tmb on tm.tenant_id = tmb.tenant_id and tm.id = tmb.id left join user_service.wx_user wu on tmb.wx_user_id = wu.id where tm.tenant_id = :1 and tm.tenant_app_id = :2 and tm.user_id not in ( :3 , :4 , :5 , :6 , :7 )|1|3|3||0|0|333928|333928|1|1|
|user_service|select t1.id , t1.user_id as userid , t1.user_name as username , t1.sex , t1.mobile_no as mobileno , t1.head_img_url as headimg from user_service.tenant_member t1 join user_service.tenant_member_info t2 on t1.tenant_id = t2.tenant_id and t1.id = t2.id join user_service.user_employee t3 on t1.tenant_app_id = t3.tenant_wechatapp_id and t1.user_id = t3.user_id and t3.employee_id = :1 where t1.tenant_id = :2 and t1.tenant_app_id = :3 and t2.tenant_app_id = :4 and t2.shop_id = :5 order by t3.update_time desc , t1.id desc limit :6 , :7|1|1|1||0|0|514800|514800|10|10|
|employee|select count ( 0 ) from employee.backlog bg where bg.tenant_app_id = :1 and bg.status in ( :2 ) and bg.leave_flag = :3|1|1|1||0|0|43120|43120|1|1|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 )|1|2|2||0|0|207269|207269|47|47|
|user_service|select count ( 0 ) from user_service.tenant_member t1 join user_service.tenant_member_info t2 on t1.tenant_id = t2.tenant_id and t1.id = t2.id join user_service.user_employee t3 on t1.tenant_app_id = t3.tenant_wechatapp_id and t1.user_id = t3.user_id and t3.employee_id = :1 where t1.tenant_id = :2 and t1.tenant_app_id = :3 and t2.tenant_app_id = :4 and t2.shop_id = :5|1|1|1||0|0|141172|141172|1|1|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 )|1|1|1||0|0|488372|488372|101|101|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 )|1|1|1||0|0|189740|189740|75|75|
|mysql|update warranty_service.warranty set id = :1 , warranty_data = ... pos刷卡：1311.00","userid":"828854123200823296","amount":1311,"detail":[{"id":"477929656563214855","saleserpid":"22118","salestype":"销售","productbarcode":"0000001041891","productname":"足金戒指","certno":"","categoryname":"黄金 ( g ) ...|1|115|115||0|0|3876273|3876273|0|0|
|user_service|select count ( 0 ) from user_service.tenant_member t1 join user_service.tenant_member_info t2 on t1.tenant_id = t2.tenant_id and t1.id = t2.id where t1.tenant_id = :1 and t1.tenant_app_id = :2 and t2.tenant_app_id = :3 and t2.shop_id = :4|1|1|1||0|0|256343|256343|1|1|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 )|1|1|1||0|0|196938|196938|32|32|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 )|1|3|3||0|0|458172|458172|31|31|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 )|1|1|1||0|0|400519|400519|90|90|
|value_added|-- 增值达到最大天数 select 'value_added_limit_contact' as limitdaytype , t.tenant_wechatapp_id as tenantappid , t.user_id as userid , min ( ue.employee_erp_id ) employee_erp_id , ue.dept_erp_id , group_concat ( t.product_barcode order by product_barcode asc ) as productcode , group_concat ( t.product_name order by product_barcode asc ) as productname from value_added_user t inner join value_added_user_extend ue on t.id = ue.id where t.tenant_wechatapp_id = :1 and t.state = :2 and t.start_add_time >= date_add ( date_format ( :3 , :4 ) , interval :5 * ( t.add_days-1 ) day ) and t.start_add_time < date_add ( date_format ( :6 , :7 ) , interval ( :8 * ( t.add_days-1 ) :9 :10 ) day ) group by t.tenant_wechatapp_id , t.user_id , ue.dept_erp_id|1|2|2||0|0|50059|50059|32|32|
|mysql|delete from message_push.message_log where create_time < date_sub ( now ( ) , interval :1 day )|1|40|40||0|0|2143704|2143704|0|0|
|coupon_service|select count ( 0 ) from ( select cu.id , cu.coupon_name , cu.coupon_type , cu.coupon_no , cu.source as couponchannel , cu.coupon_state , ce.user_name , ce.creator_user_name as creatorname , if ( coupon_type in ( 'point' , 'interact_point' ) , cu.face_value , round ( cu.face_value/100 , 2 ) ) as facevalue , cu.begin_time , cu.end_time , ce.remark , ce.mobile_no , ce.creator_mobile_no , cu.create_time , wol.create_time as writeofftime , r.create_time as reservationdate , r.shop_name as reservationshopname , if ( wol.employee_id is null , wol.user_name , wol.employee_name ) writeoffusername , wol.shop_id as shopid , wol.dept_erp_id as erpdeptid , cu.user_id , ce.source_user_id , ce.source_user_type , cal.create_time as abolishtime , cal.employee_id as abolishemployeeid from coupon_service.coupon cu join coupon_service.coupon_extend ce on ce.id = cu.id left join coupon_service.coupon_write_off_log wol on wol.tenant_app_id = cu.tenant_app_id and wol.coupon_id = cu.id and wol.state = :1 left join coupon_service.reservation r on r.coupon_user_id = cu.id and r.state = :2 left join coupon_service.coupon_abolish_log cal on cal.tenant_id = cu.tenant_id and cal.tenant_app_id = cu.tenant_app_id and cal.coupon_id = cu.id where cu.tenant_app_id = :3 and ce.mobile_no = :4 and wol.create_time >= :5 and wol.create_time <= :6 ) tmp_count|1|1|1||0|0|11253|11253|1|1|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and wx_user_id in ( :2 , :3 , :4 ) )|1|2|2||0|0|44135|44135|5|5|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 )|1|1|1||0|0|331515|331515|19|19|
|coupon_service|select * from coupon_service.coupon where datediff ( date_format ( end_time , :1 ) , date_format ( now ( ) , :2 ) ) = :3 and coupon_state in ( :4 )|1|15|15||0|0|2819641|2819641|762|762|
|user_service|select count ( 0 ) from user_service.tenant_member tm join user_service.tenant_member_info tmi on tm.tenant_id = tmi.tenant_id and tm.id = tmi.id left join user_service.tenant_member_bind tmb on tm.tenant_id = tmb.tenant_id and tm.id = tmb.id left join user_service.wx_user wu on tmb.wx_user_id = wu.id where tm.tenant_id = :1 and tm.tenant_app_id = :2 and tm.user_id not in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 )|1|7|7||0|0|284102|284102|1|1|
|warranty_service|select count ( 0 ) from warranty_service.warranty where tenant_wechatapp_id = :1 and is_disable = false and sales_date >= :2 and sales_date <= :3|1|4|4||0|0|14285|14285|1|1|
|employee|select id , tenant_id , tenant_app_id , backlog_id , url , status , create_time , update_time from backlog_file where ( tenant_id = :1 and tenant_app_id = :2 and backlog_id in ( :3 , :4 ) and status = :5 )|1|1|1||0|0|313827|313827|0|0|
|user_service|select tm.user_id as id , tm.user_name as username , tm.head_img_url as headimgurl , tm.user_name as nickname , tm.mobile_no as mobile , tm.sex , if ( ifnull ( wu.is_subscribe , 0 ) = 0 , false , true ) as hassubscribe from user_service.tenant_member tm left join user_service.user_employee ue on tm.tenant_id = ue.tenant_id and tm.tenant_app_id = ue.tenant_wechatapp_id and tm.user_id = ue.user_id join user_service.tenant_member_info tmi on tmi.tenant_id = tm.tenant_id and tmi.id = tm.id join user_service.tenant_member_bind tmb on tmb.tenant_id = tm.tenant_id and tmb.tenant_app_id = tm.tenant_app_id and tmb.user_id = tm.user_id left join user_service.wx_user wu on wu.id = tmb.wx_user_id where tm.tenant_id = :1 and tm.tenant_app_id = :2 order by tm.id desc limit :3|1|1|1||0|0|270240|270240|12|12|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and union_id in ( :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 ) and un_assign_flag = :30 )|1|1|1||0|0|15472|15472|1|1|
|coupon_service|select ifnull ( sum ( quantity ) , 0 ) from coupon_service.coupon_market_order where market_id = :1 and user_id = :2 and order_state = :3|1|1|1||0|0|161476|161476|1|1|
|tenant|select count ( 0 ) from erp_sales es where es.tenant_id = :1 and es.tenant_wechatapp_id = :2 and es.sales_date >= :3 and es.employee_erp_id = :4 and es.sales_status = :5 and es.is_sales = :6|1|5|5||0|0|106056|106056|1|1|
|user_service|select tenant_id , id , tenant_app_id , user_id , shop_id , birthday , birthday_is_lunar , address , memorial_name , memorial_day , memorial_day_is_lunar , interest , grade_id , create_time , update_time from tenant_member_info where tenant_id = :1 and tenant_app_id = :2 and user_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 ,|1|1|1||0|0|2655|2655|2655|2655|
|corpwx|select id , tenant_id , cwx_user_id , user_id , union_id , name , create_time , update_time , sex , avatar , tenant_user_id , un_assign_flag , corp_user_id , wx_user_id from external_user where ( tenant_id = :1 and wx_user_id in ( :2 , :3 , :4 , :5 , :6 , :7 , :8 ) )|1|1|1||0|0|73673|73673|10|10|
|value_added|select count ( 0 ) from ( select t1.id , t2.sales_no as salesno , date_format ( t2.sales_date , '%y-%m-%d' ) as salesdate , date_format ( t1.start_add_time , '%y-%m-%d' ) as valueadddate , t2.dept_erp_id as shopid , t1.shop_name as shopname , t2.employee_erp_id as userid , t2.employee_name as username , t1.product_name as productname , t1.amount_pay as amountpay , t1.id as valueaddno , t1.amount_added as valueaddamount , t1.state , if ( t1.state = 2 , t1.coupon_user_id , null ) as valueaddcoupon , t1.user_id as memberuserid from value_added.value_added_user t1 join value_added.`value_added_user_extend` t2 on t1.id = t2.id where t1.tenant_wechatapp_id = :1 and exists ( select null from value_added.value_added_category t3 join value_added.value_added_template t4 on t3.template_id = t4.id and t4.is_disable = :2 where t1.tenant_wechatapp_id = t3.tenant_wechatapp_id and t2.category_erp_id = t3.erp_product_category_id ) and t2.dept_erp_id = :3 and t2.employee_erp_id in ( :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 ) and t2.sales_date >= :22 and t2.sales_date < :23 and t1.state != :24 ) tmp_count|1|1|1||0|0|11678|11678|1|1|
|shop_work|select wr.team_id , wr.report_user as employee_id , t.task_template_id , substring_index ( group_concat ( t.name ) , ',' , 1 ) as task_name , sum ( if ( p.point , p.point , 0 ) ) as point , ti.task_item_template_id , ti.field_type , ti.field_name , sum ( if ( ti.field_type = 'type_bool' and ti.value in ( :1 , :2 ) , :3 , :4 ) ) as bool_true_count , sum ( if ( ti.field_type = :5 and ti.value in ( :6 , :7 ) , :8 , :9 ) ) as bool_false_count , sum ( if ( ti.field_type = :10 , :11 , :12 ) ) as string_count , sum ( if ( ti.field_type = :13 , :14 , :15 ) ) as date_count , sum ( if ( ti.field_type = :16 , ti.value , :17 ) ) as number_sum , sum ( if ( ti.field_type = :18 , substring_index ( ti.value , :19 , :20 ) , :21 ) ) as progress_target , sum ( if ( ti.field_type = :22 , substring_index ( ti.value , :23 , :24 ) , :25 ) ) as progress_reach from shop_work.work_report wr join shop_work.task t on wr.id = t.task_group_id join shop_work.task_item ti on ti.task_id = t.id left join ( select p.team_id , p.employee_id , p.task_id , sum ( p.amount ) as point from shop_work.point p where p.tenant_id = :26 and p.shop_id = :27 and p.work_report_time >= :28 and p.work_report_time < :29 group by p.team_id , p.employee_id , p.task_id ) p on p.team_id = wr.team_id and p.employee_id = wr.report_user and p.task_id = t.id where wr.tenant_id = :30 and wr.shop_id = :31 and wr.create_time >= :32 and wr.create_time < :33 and ti.task_item_template_id in ( :34 , :35 ) and wr.report_type = :36 and wr.status = :37 and wr.execute_role = :38 and ti.status != :39 and ti.field_type in ( :40 , :41 , :42 , :43 , :44 ) and ti.value is not null and t.status = :45 group by wr.team_id , wr.report_user , t.task_template_id , ti.task_item_template_id , ti.field_type , ti.field_name|1|9|9||0|0|1144795|1144795|0|0|
|value_added|select id , tenant_wechatapp_id as tenantwechatappid , user_id as userid , template_id as templateid , sales_erp_id as saleserpid , product_name as productname , shop_name as shopname , product_barcode as productbarcode , amount_total as amounttotal , amount_pay as amountpay , amount_added as amountadded , state as state , add_days , added_percent_per_day as addedpercentperday , devalue_percent_per_day as devaluepercentperday , keeping_days as keepingdays , exchange_days as exchangedays , coupon_user_id as couponuserid , sales_index as salesindex , start_add_time as createtime , date_add ( start_add_time , interval add_days-1 day ) , date_add ( start_add_time , interval add_days + keeping_days-1 day ) from value_added_user where keeping_days > :1 and state = :2 and start_add_time = date_add ( curdate ( ) , interval :3 * ( add_days-1 ) day )|1|4|4||0|0|787080|787080|1428|1428|
|value_added|-- 根据添加时间得出当前增值金额 update value_added_user set amount_added = if ( :1 > ( ( ( added_percent_per_day / :2 ) * if ( :3 >= timestampdiff ( day , date_format ( start_add_time , :4 ) , now ( ) ) :5 :6 :7 add_days , timestampdiff ( day , date_format ( start_add_time , :8 ) , now ( ) ) :9 :10 , add_days ) ) :11 ( ( devalue_percent_per_day / :12 ) * if ( :13 >= timestampdiff ( day , date_format ( start_add_time , :14 ) , now ( ) ) :15 :16 :17 add_days :18 keeping_days , :19 , timestampdiff ( day , date_format ( start_add_time , :20 ) , now ( ) ) :21 :22 :23 add_days :24 keeping_days ) ) ) * amount_pay , :25 , ( ( ( added_percent_per_day / :26 ) * if ( :27 >= timestampdiff ( day , date_format ( start_add_time , :28 ) , now ( ) ) :29 :30 :31 add_days , timestampdiff ( day , date_format ( start_add_time , :32 ) , now ( ) ) :33 :34 , add_days ) ) :35 ( ( devalue_percent_per_day / :36 ) * if ( :37 >= timestampdiff ( day , date_format ( start_add_time , :38 ) , now ( ) ) :39 :40 :41 add_days :42 keeping_days , :43 , timestampdiff ( day , date_format ( start_add_time , :44 ) , now ( ) ) :45 :46 :47 add_days :48 keeping_days ) ) ) * amount_pay ) , update_time = now ( ) where state = :49 and update_time <= curdate ( ) and ( start_add_time >= date_add ( curdate ( ) , interval :50 ( add_days :51 keeping_days :52 :53 ) day ) or ( amount_added > :54 and start_add_time < date_add ( curdate ( ) , interval :55 ( add_days :56 keeping_days :57 :58 ) day ) ) ) -- 判断条件 在增值时间内 增值金大于0 状态正常|1|5|5||0|0|787029|787029|0|0|
|coupon_service|select count ( 0 ) from ( select cu.id , cu.coupon_name , cu.coupon_type , cu.coupon_no , cu.source as couponchannel , cu.coupon_state , ce.user_name , ce.creator_user_name as creatorname , if ( coupon_type in ( 'point' , 'interact_point' ) , cu.face_value , round ( cu.face_value/100 , 2 ) ) as facevalue , cu.begin_time , cu.end_time , ce.remark , ce.mobile_no , ce.creator_mobile_no , cu.create_time , wol.create_time as writeofftime , r.create_time as reservationdate , r.shop_name as reservationshopname , if ( wol.employee_id is null , wol.user_name , wol.employee_name ) writeoffusername , wol.shop_id as shopid , wol.dept_erp_id as erpdeptid , cu.user_id , ce.source_user_id , ce.source_user_type , cal.create_time as abolishtime , cal.employee_id as abolishemployeeid from coupon_service.coupon cu join coupon_service.coupon_extend ce on ce.id = cu.id left join coupon_service.coupon_write_off_log wol on wol.tenant_app_id = cu.tenant_app_id and wol.coupon_id = cu.id and wol.state = :1 left join coupon_service.reservation r on r.coupon_user_id = cu.id and r.state = :2 left join coupon_service.coupon_abolish_log cal on cal.tenant_id = cu.tenant_id and cal.tenant_app_id = cu.tenant_app_id and cal.coupon_id = cu.id where cu.tenant_app_id = :3 and ce.mobile_no = :4 ) tmp_count|1|7|7||0|0|93268|93268|1|1|
|user_service|select count ( 0 ) from user_service.tenant_member tm join user_service.tenant_member_info tmi on tm.tenant_id = tmi.tenant_id and tm.id = tmi.id left join user_service.tenant_member_bind tmb on tm.tenant_id = tmb.tenant_id and tm.id = tmb.id left join user_service.wx_user wu on tmb.wx_user_id = wu.id where tm.tenant_id = :1 and tm.tenant_app_id = :2 and tm.user_id not in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 )|1|1|1||0|0|92617|92617|1|1|
|user_service|select count ( 0 ) from user_service.tenant_member tm join user_service.tenant_member_info tmi on tm.tenant_id = tmi.tenant_id and tm.id = tmi.id left join user_service.tenant_member_bind tmb on tm.tenant_id = tmb.tenant_id and tm.id = tmb.id left join user_service.wx_user wu on tmb.wx_user_id = wu.id where tm.tenant_id = :1 and tm.tenant_app_id = :2 and tm.user_id not in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 )|1|1|1||0|0|92618|92618|1|1|
|user_service|select tu.user_id , tm.shop_id , mb.erp_member_id membererpid , tu.mobile_no , tu.user_name , ue.employee_id , tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id = :1 and tu.tenant_app_id = :2 and mb.erp_member_id in ( :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 )|1|1|1||0|0|261603|261603|60|60|
|tenant|select count ( 0 ) from erp_sales join tenant.tenant_wechatapp tw on tw.is_disable = :1 and tw.id = erp_sales.tenant_wechatapp_id join erp_department on tw.tenant_id = erp_department.tenant_id and erp_department.dept_erp_id = erp_sales.dept_erp_id join tenant tenant on tw.tenant_id = tenant.id and tenant.`status` = :2 where :3 = :4 and tenant.id = :5 and erp_sales.sales_no = :6|1|5|5||0|0|488070|488070|1|1|
|user_service|select count ( 0 ) from user_service.tenant_member t1 join user_service.tenant_member_info t2 on t1.tenant_id = t2.tenant_id and t1.id = t2.id where t1.tenant_id = :1 and t1.tenant_app_id = :2 and t2.tenant_app_id = :3 and t2.shop_id = :4 and ( t1.mobile_no like concat ( :5 , :6 ) or t1.user_name like concat ( :7 , :8 , :9 ) )|1|1|1||0|0|256342|256342|1|1|
