|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|v4_sales|SELECT count(es.id) FROM v4_sales.erp_sales es JOIN v4_sales.warranty_can_added wca ON wca.sales_id=es.id AND if(wca.source=?,es.sales_date>=?,wca.create_time>=?) AND wca.tenant_id=? AND wca.tenant_app_id=? LEFT JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE es.sales_status=? AND is_sales=? AND es.employee_erp_id=? AND dept_erp_id=? AND w.id IS ? AND es.tenant_id=? AND es.tenant_app_id=?|925|1787|12||0|0|4703341|28506|925|1|
|v4_employee|SELECT ? AS task_type,t.system_task_type,count(*) AS undo_count FROM task_task t JOIN task_system_task_template st ON t.task_template_id=st.id AND st.status=? AND st.tenant_id=? AND st.tenant_app_id=? WHERE t.`status`=? AND t.finish_time IS ? AND t.end_time>? AND shop_id=? AND employee_id=? AND t.task_template_id IN (?) AND t.tenant_id=? AND t.tenant_app_id=? GROUP BY t.system_task_type|312|580|13||0|0|1003646|7591|656|5|
|youzan|SELECT id,merchant_id,merchant_shop_id,sync_type,api_name,api_request,api_response,status,error_msg,retry_num,create_time,update_time FROM weimob_platform_sync_log WHERE (status=? AND sync_type IN (?) AND retry_num<?)|251|820|30||0|0|28925668|115242|0|0|
|corpwx|SELECT t.tenant_id AS tenantId,t.wx_user_id AS wxUserId,t.union_id AS wxUnionId,t.user_id AS externalUserId,ifnull(et.raw_external_user_id,t.old_user_id) AS rawExternalUserId,t.corp_user_id AS employeeCorpUserId FROM corpwx.external_user t LEFT JOIN corpwx.external_userid_transform et ON t.tenant_id=et.tenant_id AND t.user_id=et.external_user_id WHERE t.tenant_id=? AND t.status=? AND t.user_id IN|156|294|12||0|0|270268|2109|121356|956|
|tenant|SELECT sales_date FROM tenant.erp_sales WHERE tenant_id=? AND tenant_wechatapp_id=? AND member_erp_id=? AND sales_erp_id<? AND is_sales=? AND sales_status=? ORDER BY sales_erp_id ASC LIMIT ?|151|413|9||0|0|2593002|40057|151|1|
|v4_sales|SELECT id,comment_id,subject_id,subject_type,subject,score,labels,content,tenant_id,tenant_app_id,create_time,update_time FROM comment_detail WHERE (comment_id=?) AND tenant_id=? AND tenant_app_id=?|123|233|7||0|0|37086050|302215|615|5|
|user_service|SELECT count(?) FROM user_service.tenant_member t? JOIN user_service.tenant_member_info t? ON t?.tenant_id=t?.tenant_id AND t?.id=t?.id AND t?.tenant_app_id=? AND t?.shop_id=? JOIN user_service.user_employee ue ON t?.tenant_id=ue.tenant_id AND t?.tenant_app_id=ue.tenant_wechatapp_id AND t?.user_id=ue.user_id AND ue.employee_id=? AND ue.shop_id=? WHERE t?.tenant_id=? AND t?.tenant_app_id=?|121|301|22||0|0|1506052|277980|121|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=? AND tu.tenant_app_id=? AND tu.status=? AND mb.erp_member_id IN (?)|90|254|18||0|0|41418923|1905183|5531|300|
|youzan|SELECT id,merchant_shop_id,api_name,api_request,api_response,status,error_msg,retry_num,sync_type,create_time,update_time FROM youzan_platform_sync_log WHERE (status=? AND retry_num<? AND create_time>?)|83|221|16||0|0|14591070|175797|0|0|
|corpwx|SELECT t.tenant_id AS tenantId,t.wx_user_id AS wxUserId,t.union_id AS wxUnionId,t.user_id AS externalUserId,ifnull(et.raw_external_user_id,t.old_user_id) AS rawExternalUserId,t.corp_user_id AS employeeCorpUserId FROM corpwx.external_user t LEFT JOIN corpwx.external_userid_transform et ON t.tenant_id=et.tenant_id AND t.user_id=et.external_user_id WHERE t.tenant_id=? AND t.status=? AND t.user_id IN (?) AND t.un_assign_flag=?|71|137|8||0|0|45299|741|21014|347|
|v4_employee|SELECT ? AS task_type,t?.id AS invite_task_id,t?.name,ifnull(t?.undo_count,?) AS undo_count,t?.invite_time AS invite_task_start_time,ifnull(t?.interrupt_time,t?.end_time) AS invite_task_end_time FROM task_invite_task_template t? LEFT JOIN (SELECT t.task_template_id AS id,sum(if(t.finish_time IS ?,?,?)) AS undo_count FROM task_task t WHERE t.task_type=? AND t.`status`=? AND t.end_time>? AND t.shop_id=? AND t.employee_id=? AND t.tenant_id=? AND t.tenant_app_id=? GROUP BY t.task_template_id)t? ON t?.id=t?.id WHERE t?.status IN (?) AND t?.tenant_id=? AND t?.tenant_app_id=? ORDER BY t?.id DESC|60|110|7||0|0|896396|20923|525|12|
|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=? AND es.tenant_wechatapp_id=? AND es.sales_status=? AND es.sales_no LIKE concat(?,?) ORDER BY es.sales_date DESC LIMIT ?|59|815|126||0|0|40737441|1245617|4|1|
|tenant|SELECT count(?) FROM erp_sales es WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.sales_date>=? AND es.employee_erp_id=? AND es.sales_status=?|43|75|4||0|0|148973|4871|43|1|
|gift_mail|SELECT count(*) FROM gift_mail.trade t LEFT JOIN gift_mail.trade_take tt ON tt.trade_id=t.id WHERE t.tenant_id=? AND t.tenant_wechatapp_id=? AND t.trade_type IN (?) AND t.order_status=? AND t.take_type=? AND tt.shop_id=?|37|70|8||0|0|230175|13459|37|1|
|gift_mail|SELECT count(*) FROM gift_mail.trade t LEFT JOIN gift_mail.trade_take tt ON tt.trade_id=t.id WHERE t.tenant_id=? AND t.tenant_wechatapp_id=? AND t.trade_type=? AND t.order_status=? AND t.take_type=? AND tt.shop_id=?|36|69|8||0|0|260471|15437|36|1|
|v4_sales|SELECT ifnull(sum(integral),?)points FROM v4_sales.erp_sales es JOIN v4_sales.erp_sales_detail esd ON esd.sales_erp_id=es.sales_erp_id AND esd.tenant_id=? AND esd.tenant_app_id=? WHERE es.member_erp_id IN (?) AND es.sales_status=? AND es.is_sales=? AND esd.sales_type=? AND es.tenant_id=? AND es.tenant_app_id=?|33|115|12||0|0|499568|36966|33|1|
|v4_sales|SELECT round(avg(cd.score),?) FROM comment c JOIN comment_detail cd ON cd.comment_id=c.id AND cd.tenant_id=? AND cd.tenant_app_id=? WHERE c.erp_dept_id=? AND c.erp_employee_id=? AND c.create_time BETWEEN ? AND ? AND c.tenant_id=? AND c.tenant_app_id=?|33|61|4||0|0|9953075|302335|33|1|
|tenant|SELECT count(?) FROM (SELECT es.id,es.sales_no,es.sales_date,es.sales_erp_id,es.amount,ifnull(shop.shop_name,ed.dept_name)dept_name,es.employee_name FROM tenant.erp_sales es JOIN tenant.erp_department ed ON ed.dept_erp_id=es.dept_erp_id AND ed.tenant_id=? LEFT JOIN tenant.tenant_wechatapp_shop shop ON shop.dept_erp_id=ed.dept_erp_id AND shop.tenant_wechatapp_id=? WHERE es.member_erp_id=? AND es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.sales_status=? AND NOT EXISTS (SELECT i.id FROM tenant.erp_sales_ignore i WHERE i.tenant_id=? AND i.tenant_app_id=? AND es.sales_erp_id=i.erp_sales_id))table_count|31|49|2||0|0|191341586|6273602|31|1|
|v4_user|SELECT id,shop_id,mobile_no,member_name,head_img_url,sex,birthday,birthday_is_lunar,memorial_name,memorial_day,memorial_day_is_lunar,address,interest,mini_open_id,h5_open_id,wx_card_code,status,butler_employee_mobile_no,register_time,point_balance,total_sale_point,import_status,import_err_msg,tenant_id,tenant_app_id,create_time,update_time FROM member_import WHERE (import_status=?) AND tenant_id=? ORDER BY id ASC LIMIT ?|29|459|26||0|0|56588937|2021305|144961|5000|
|corpwx|UPDATE external_user SET un_assign_flag=? WHERE (tenant_id=? AND status=? AND un_assign_flag=?)|28|99|8||0|0|755102|73914|0|0|
|user_service|SELECT t?.id,t?.user_id AS userId,t?.user_name AS userName,t?.sex,t?.mobile_no AS mobileNo,t?.head_img_url AS headImg FROM user_service.tenant_member t? JOIN user_service.tenant_member_info t? ON t?.tenant_id=t?.tenant_id AND t?.id=t?.id AND t?.tenant_app_id=? AND t?.shop_id=? JOIN user_service.user_employee ue ON t?.tenant_id=ue.tenant_id AND t?.tenant_app_id=ue.tenant_wechatapp_id AND t?.user_id=ue.user_id AND ue.employee_id=? AND ue.shop_id=? WHERE t?.tenant_id=? AND t?.tenant_app_id=? ORDER BY ue.update_time DESC,t?.id DESC LIMIT ?|25|46|4||0|0|616598|284743|250|10|
|v4_sales|SELECT * FROM v4_sales.value_added_record WHERE value_added_id=? AND date_format(create_time,?)=? AND tenant_id=? AND tenant_app_id=?|23|29|5||0|0|53631840|2334847|0|0|
|authorization_service|SELECT ar.tenant_id,ar.tenant_app_id,a.employee_id,ar.shop_id,ar.role_code,ar.role_name,a.status AS account_status,ar.status AS role_status FROM authorization_service.account_role? ar JOIN authorization_service.account a ON ar.account_id=a.id WHERE ar.tenant_id=? AND ar.tenant_app_id=? AND ar.shop_id=?|22|34|3||0|0|1448375|65859|435|39|
|v4_user|SELECT id,checkin_employee_name,maintain_employee_name FROM potential_customer WHERE ((external_user_id=? OR member_id=?) AND status IN (?)) AND tenant_id=? AND tenant_app_id=? ORDER BY id ASC|22|64|5||0|0|177922|8315|14|2|
|v4_user|SELECT id,member_id,external_user_id,serial_number,checkin_shop_id,checkin_employee_id,checkin_employee_name,checkin_time,maintain_shop_id,maintain_employee_id,maintain_employee_name,first_maintain_time,last_maintain_time,next_maintain_time,maintain_num,intention_num,latest_intention,status,finish_time,finish_shop_id,deal_employee_id,deal_employee_name,deal_sale_amount,fail_employee_id,fail_employee_name,fail_reason,remark,sex,cutomer_grade,maintain_level,tenant_id,tenant_app_id,create_time,update_time FROM potential_customer WHERE ((member_id=? OR external_user_id=?) AND status IN (?)) AND tenant_id=? AND tenant_app_id=?|20|72|10||0|0|166198|8317|5|1|
|order|SELECT count(*) FROM `order`.order_info WHERE tenant_id=? AND tenant_wechatapp_id=? AND take_type=? AND status=? AND (wait_take_shop_id=? OR take_shop_id=?)|20|31|3||0|0|63947|3518|20|1|
|user_service|SELECT * FROM user_service.user_employee WHERE employee_erp_id=? AND tenant_id=? AND tenant_wechatapp_id=? AND date_format(update_time,?)=date_format(now(),?)|19|385|47||0|0|2621617|310246|12148|6761|
|user_service|SELECT count(?) 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.user_employee t? ON tm.user_id=t?.user_id AND tm.tenant_id=t?.tenant_id AND tm.tenant_app_id=t?.tenant_wechatapp_id WHERE t?.id IS ? AND tmi.shop_id=? AND tmi.tenant_id=? AND tmi.tenant_app_id=?|19|321|53||0|0|497789|70601|19|1|
|v4_sales|SELECT count(DISTINCT sales_date) FROM v4_sales.erp_sales WHERE member_erp_id IN (?) AND is_sales=? AND sales_status=? AND tenant_id=? AND tenant_app_id=?|18|31|3||0|0|143814|15029|18|1|
|user_service|SELECT count(?) FROM (SELECT count(?) FROM user_source us WHERE us.tenant_id=? AND us.tenant_wechatapp_id=? AND us.from_id=? AND us.shop_id=? AND us.create_time>=? AND us.create_time<? AND us.source_type=? AND us.from_id IS NOT ? AND us.shop_id IS NOT ?)table_count|18|32|3||0|0|24738|2345|18|1|
|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 FROM user_service.tenant_member tm WHERE tm.tenant_id=? AND tm.tenant_app_id=? AND (tm.user_name LIKE CONCAT(?,?,?) OR tm.mobile_no=?) ORDER BY tm.id DESC LIMIT ?|17|39|6||0|0|6825796|401554|17|1|
|coupon_service|SELECT * FROM coupon_service.coupon_can_give WHERE coupon_id=? LIMIT ?|17|44|7||0|0|5648891|333953|17|1|
|tenant|SELECT es.id,es.sales_no,es.sales_date,es.sales_erp_id,es.amount,ifnull(shop.shop_name,ed.dept_name)dept_name,es.employee_name FROM tenant.erp_sales es JOIN tenant.erp_department ed ON ed.dept_erp_id=es.dept_erp_id AND ed.tenant_id=? LEFT JOIN tenant.tenant_wechatapp_shop shop ON shop.dept_erp_id=ed.dept_erp_id AND shop.tenant_wechatapp_id=? WHERE es.member_erp_id=? AND es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.sales_status=? AND NOT EXISTS(SELECT i.id FROM tenant.erp_sales_ignore i WHERE i.tenant_id=? AND i.tenant_app_id=? AND es.sales_erp_id=i.erp_sales_id) ORDER BY es.sales_date DESC LIMIT ?,?|17|26|1||0|0|106628532|6272286|170|10|
|v4_employee|SELECT count(?) AS total_count,count(finish_time) AS finish_count FROM task_task t JOIN task_system_task_template t? ON t.task_template_id=t?.id AND t?.status=? AND t?.tenant_id=? AND t?.tenant_app_id=? WHERE t.task_type=? AND t.status=? AND t.start_time>=? AND t.start_time<? AND t.shop_id=? AND t.tenant_id=? AND t.tenant_app_id=?|17|40|5||0|0|176168|36197|17|1|
|v4_sales|SELECT * FROM erp_sales WHERE member_erp_id=? AND is_sales=? AND sales_status=? AND id<? AND tenant_id=? AND tenant_app_id=? ORDER BY sales_date ASC,sales_erp_id ASC LIMIT ?|16|34|4||0|0|576377|54281|16|1|
|user_service|SELECT count(*) FROM user_service.user_employee ue WHERE ue.tenant_id=? AND ue.employee_id=? AND ue.tenant_wechatapp_id=? AND ue.shop_id=?|14|26|4||0|0|75814|12667|14|1|
|tenant|SELECT es.id,es.sales_no,es.sales_date,es.sales_erp_id,es.amount,ifnull(shop.shop_name,ed.dept_name)dept_name,es.employee_name FROM tenant.erp_sales es JOIN tenant.erp_department ed ON ed.dept_erp_id=es.dept_erp_id AND ed.tenant_id=? LEFT JOIN tenant.tenant_wechatapp_shop shop ON shop.dept_erp_id=ed.dept_erp_id AND shop.tenant_wechatapp_id=? WHERE es.member_erp_id=? AND es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.sales_status=? AND NOT EXISTS(SELECT i.id FROM tenant.erp_sales_ignore i WHERE i.tenant_id=? AND i.tenant_app_id=? AND es.sales_erp_id=i.erp_sales_id) ORDER BY es.sales_date DESC LIMIT ?|13|20|1||0|0|81538938|6272226|130|10|
|user_service|SELECT obj.id,obj.total, CASE WHEN @rowtotal=obj.total THEN @rownum WHEN @rowtotal:=obj.total THEN @rownum:=@rownum+? WHEN @rowtotal=? THEN @rownum:=@rownum+? END AS rank_idx FROM (SELECT us.from_id AS id,count(?)total FROM user_source us WHERE us.tenant_id=? AND us.tenant_wechatapp_id=? AND us.shop_id=? AND us.create_time>=? AND us.create_time<? AND us.source_type=? AND us.from_id IS NOT ? AND us.shop_id IS NOT ? GROUP BY us.from_id ORDER BY count(?) DESC) AS obj,(SELECT @rownum:=?,@rowtotal:=?)r|12|19|3||0|0|30090|5845|70|11|
|user_service|SELECT tmb.erp_member_id AS member_erp_id,tm.tenant_id,tm.tenant_app_id,tm.mobile_no,tm.user_name,tmi.grade_id AS grade_erp_id FROM user_service.tenant_member tm 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 tmb.tenant_id=? AND tmb.tenant_app_id=? AND tmb.erp_member_id IN (?)|12|16|2||0|0|279|48|93|16|
|user_service|SELECT obj.id,obj.shop_id,obj.total, CASE WHEN @rowtotal=obj.total THEN @rownum WHEN @rowtotal:=obj.total THEN @rownum:=@rownum+? WHEN @rowtotal=? THEN @rownum:=@rownum+? END AS rank_idx FROM (SELECT us.from_id AS id,us.shop_id,count(?)total FROM user_source us WHERE us.tenant_id=? AND us.tenant_wechatapp_id=? AND us.create_time>=? AND us.create_time<? AND us.source_type=? AND us.from_id IS NOT ? AND us.shop_id IS NOT ? GROUP BY us.from_id,us.shop_id ORDER BY count(?) DESC) AS obj,(SELECT @rownum:=?,@rowtotal:=?)r|12|19|3||0|0|33339|5959|1153|359|
|v4_user|SELECT COUNT(*) AS total FROM member_import WHERE (import_status=?) AND tenant_id=?|11|15|2||0|0|1594571|144961|11|1|
|coupon_service|SELECT cmod.coupon_id,cmo.pay_type,cmo.id orderId,cmo.cash_flow_id AS payId FROM coupon_service.coupon_market_order_detail cmod JOIN coupon_service.coupon_market_order cmo ON cmo.tenant_id=? AND cmo.tenant_app_id=? AND cmo.id=cmod.order_id WHERE cmod.tenant_id=? AND cmod.tenant_app_id=? AND cmod.coupon_id IN (?)|11|19|2||0|0|422256|38403|150|19|
|v4_sales|SELECT t?.sales_erp_id AS salesErpId,t?.sales_no AS salesNo,DATE_FORMAT(t?.sales_date,?) AS salesDate,t?.member_erp_id AS memberId,t?.employee_erp_id AS employeeErpId,t?.employee_name AS employeeName,t?.assist_employee_erp_id AS assistEmployeeErpId,t?.assist_employee_name AS assistEmployeeName,t?.dept_erp_id AS deptErpId,t?.amount,t?.post_time AS postTime FROM erp_sales t? WHERE t?.employee_erp_id=? AND t?.post_time>=? AND t?.post_time<=? AND t?.sales_status=? AND NOT EXISTS (SELECT ? FROM erp_sales_relate esr WHERE t?.tenant_id=esr.tenant_id AND t?.tenant_app_id=esr.tenant_app_id AND t?.sales_erp_id=esr.sales_erp_id AND esr.sales_status IN (?) AND esr.tenant_id=? AND esr.tenant_app_id=?) AND EXISTS (SELECT ? FROM erp_sales_detail esd WHERE t?.tenant_id=esd.tenant_id AND t?.tenant_app_id=esd.tenant_app_id AND t?.sales_erp_id=esd.sales_erp_id AND esd.sales_type IN (?) AND esd.tenant_id=? AND esd.tenant_app_id=?) AND t?.tenant_id=? AND t?.tenant_app_id=?|11|29|9||0|0|54694|11423|16|2|
|order|SELECT count(?)total,ifnull(sum(if(od.status>?,od.payment_fee,?)),?)paymentFee,ifnull(sum(if(od.status>?,od.offline_payment_fee,?)),?)offlinePaymentFee,ifnull(sum(if(od.status>?,od.payment_fee+od.offline_payment_fee,?)),?)payTotalFee 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.tenant_id=? AND od.tenant_wechatapp_id=?|10|21|4||0|0|1229145|177879|10|1|
|v4_sales|SELECT COUNT(*) AS total FROM v4_sales.erp_sales es LEFT JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE is_sales=? AND sales_status=? AND (es.sales_no LIKE concat(?,?) OR es.member_erp_id=?) AND w.id IS ? AND es.tenant_id=? AND es.tenant_app_id=?|10|22|4||0|0|2036737|369690|10|1|
|order|SELECT count(?) 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.tenant_id=? AND od.tenant_wechatapp_id=?|10|21|4||0|0|1229145|177879|10|1|
|user_service|SELECT count(?) FROM user_service.tenant_member tm WHERE tm.tenant_id=? AND tm.tenant_app_id=? AND (tm.user_name LIKE CONCAT(?,?,?) OR tm.mobile_no=?)|9|18|3||0|0|909214|481355|9|1|
|user_service|SELECT count(?) FROM user_service.tenant_member tm JOIN user_service.user_employee ue ON ue.tenant_id=? AND ue.tenant_wechatapp_id=? AND tm.user_id=ue.user_id AND ue.employee_id=? AND ue.shop_id=? WHERE tm.tenant_id=? AND tm.tenant_app_id=?|9|61|24||0|0|701318|99940|9|1|
|v4_user|SELECT id,member_id,external_user_id,serial_number,checkin_shop_id,checkin_employee_id,checkin_employee_name,checkin_time,maintain_shop_id,maintain_employee_id,maintain_employee_name,first_maintain_time,last_maintain_time,next_maintain_time,maintain_num,intention_num,latest_intention,status,finish_time,finish_shop_id,deal_employee_id,deal_employee_name,deal_sale_amount,fail_employee_id,fail_employee_name,fail_reason,remark,sex,cutomer_grade,maintain_level,tenant_id,tenant_app_id,create_time,update_time FROM potential_customer WHERE ((member_id=?) AND status IN (?) AND maintain_shop_id=?) AND tenant_id=? AND tenant_app_id=?|8|12|3||0|0|19119|2395|2|1|
|v4_employee|SELECT count(*) AS total_count,count(finish_time) AS finish_count,ifnull(sum(if(finish_time>=? AND finish_time<?,?,?)),?) AS todayFinishCount,count(send_coupons) AS coupon_send_count,count(recv_coupons) AS coupon_recv_count,count(accept_time) AS accept_count,count(arrival_shop_time) AS arrival_shop_count,count(trade_time) AS trade_count FROM task_task WHERE task_type=? AND status=? AND shop_id=? AND employee_id=? AND system_task_type=? AND start_time<=? AND end_time>? AND tenant_id=? AND tenant_app_id=?|8|10|1||0|0|7211|2184|8|1|
|v4_sales|SELECT COUNT(*) AS total FROM v4_sales.erp_sales es JOIN v4_sales.warranty_can_added wca ON wca.sales_id=es.id AND wca.tenant_id=? AND wca.tenant_app_id=? LEFT JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE is_sales=? AND sales_status=? AND es.employee_erp_id=? AND es.dept_erp_id=? AND if(wca.source=?,es.sales_date>=?,date_format(wca.create_time,?)>=?) AND w.id IS ? AND es.tenant_id=? AND es.tenant_app_id=?|8|22|7||0|0|62299|14735|8|1|
|user_service|SELECT count(?) FROM user_service.tenant_member t? JOIN user_service.tenant_member_info t? ON t?.tenant_id=t?.tenant_id AND t?.id=t?.id AND t?.tenant_app_id=? AND t?.shop_id=? WHERE t?.tenant_id=? AND t?.tenant_app_id=?|7|11|2||0|0|650934|287826|7|1|
|v4_coupon|UPDATE v4_coupon.coupon SET coupon_status=? WHERE tenant_id=? AND tenant_app_id=? AND coupon_status=? AND end_time<now()|7|12|3||0|0|2975021|977502|0|0|
|erp_app|INSERT INTO app_status(id,tenant_id,app_name,version,pid) VALUES (?,?,?,?,?) ON DUPLICATE key UPDATE version=?,pid=?,online_status_time=?|7|10|1||0|0|0|0|0|0|
|v4_sales|SELECT count(s.sales_erp_id) FROM (SELECT es.tenant_id,es.tenant_app_id,es.sales_erp_id,esd.product_barcode,max(esd.category_erp_id)category_erp_id,max(es.sales_date)sales_date FROM v4_sales.erp_sales es JOIN v4_sales.erp_sales_detail esd ON esd.sales_erp_id=es.sales_erp_id AND esd.tenant_id=? AND esd.tenant_app_id=? WHERE dept_erp_id=? AND employee_erp_id=? AND es.sales_status=? AND es.is_sales=? AND es.tenant_id=? AND es.tenant_app_id=? GROUP BY es.tenant_id,es.tenant_app_id,es.sales_erp_id,esd.product_barcode)s LEFT JOIN v4_sales.value_added_ignore i ON i.erp_sales_id=s.sales_erp_id AND i.product_barcode=s.product_barcode AND i.tenant_id=? AND i.tenant_app_id=? LEFT JOIN v4_sales.value_added va ON va.erp_sales_id=s.sales_erp_id AND va.product_barcode=s.product_barcode AND va.tenant_id=? AND va.tenant_app_id=? JOIN v4_sales.value_added_category vac ON vac.erp_category_id=s.category_erp_id AND vac.status=? AND vac.tenant_id=? AND vac.tenant_app_id=? JOIN v4_sales.value_added_template vat ON vat.id=vac.template_id AND vat.status=? AND vat.tenant_id=? AND vat.tenant_app_id=? WHERE if(ifnull(vat.effective_date,?)!=?,s.sales_date>vat.effective_date,?=?) AND va.id IS ? AND i.id IS ?|7|9|2||0|0|74323|17270|7|1|
|tenant|SELECT e.id,e.employee_name FROM (SELECT DISTINCT sgm.employee_id FROM tenant.sneak_guest sg JOIN tenant.sneak_guest_maintain sgm ON sgm.sneak_guest_id=sg.id WHERE sg.tenant_id=? AND sg.tenant_app_id=? AND sg.update_shop_id=? AND sgm.event_type IN (?) AND (sg.fail_type IS ? OR sg.fail_type=?) AND sgm.create_time BETWEEN ? AND ?)t JOIN tenant.employee e ON e.id=t.employee_id|7|45|20||0|0|222543|49872|37|6|
|v4_sales|SELECT es.id salesId,es.sales_no,es.sales_date,es.member_erp_id memberId,w.warranty_no FROM v4_sales.erp_sales es LEFT JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE is_sales=? AND sales_status=? AND (es.sales_no LIKE concat(?,?) OR es.member_erp_id=?) AND w.id IS ? AND es.tenant_id=? AND es.tenant_app_id=? ORDER BY es.sales_date DESC,es.id DESC LIMIT ?|7|11|2||0|0|3308631|635392|9|2|
|user_service|SELECT tmi.tenant_id,tmi.id,tmi.tenant_app_id,tmi.user_id,tmi.shop_id,tmi.birthday,tmi.birthday_is_lunar,tmi.address,tmi.memorial_name,tmi.memorial_day,tmi.memorial_day_is_lunar,tmi.interest,tmi.grade_id,tmi.create_time,tmi.update_time FROM user_service.tenant_member_info tmi JOIN user_service.tenant_member tm ON tm.tenant_id=? AND tm.tenant_app_id=? AND tm.user_id=tmi.user_id WHERE tmi.tenant_id=? AND tmi.tenant_app_id=? AND tm.status=? AND tmi.user_id IN|7|8|1||0|0|190512|151764|95168|75863|
|corpwx|SELECT count(*) AS addedNum FROM external_user t WHERE t.tenant_id=? AND t.corp_user_id=? AND t.create_time>=? AND t.create_time<?|7|13|3||0|0|274058|67252|7|1|
|v4_user|SELECT t?.id AS memberId,t?.id AS potentialCustomerId,t?.checkin_time AS checkinTime FROM potential_customer t? JOIN member t? ON t?.id=t?.member_id AND t?.tenant_id=? AND t?.tenant_app_id=? WHERE t?.maintain_shop_id=? AND t?.maintain_employee_id=? AND t?.`status` IN (?) AND t?.tenant_id=? AND t?.tenant_app_id=? UNION SELECT t?.id AS memberId,t?.id AS potentialCustomerId,t?.checkin_time AS checkinTime FROM potential_customer t? JOIN member t? ON t?.external_user_id=t?.external_user_id AND t?.tenant_id=? AND t?.tenant_app_id=? WHERE t?.maintain_shop_id=? AND t?.maintain_employee_id=? AND t?.`status` IN (?) AND t?.member_id=? AND t?.tenant_id=? AND t?.tenant_app_id=?|7|13|2||0|0|18796|3538|1218|255|
|v4_sales|SELECT t?.sales_erp_id AS salesErpId,t?.sales_no AS salesNo,DATE_FORMAT(t?.sales_date,?) AS salesDate,t?.member_erp_id AS memberId,t?.employee_erp_id AS employeeErpId,t?.employee_name AS employeeName,t?.assist_employee_erp_id AS assistEmployeeErpId,t?.assist_employee_name AS assistEmployeeName,t?.dept_erp_id AS deptErpId,t?.amount,t?.post_time AS postTime FROM erp_sales t? WHERE t?.dept_erp_id=? AND t?.member_erp_id IN (?) AND t?.post_time>=? AND t?.sales_status=? AND NOT EXISTS (SELECT ? FROM erp_sales_relate esr WHERE t?.tenant_id=esr.tenant_id AND t?.tenant_app_id=esr.tenant_app_id AND t?.sales_erp_id=esr.sales_erp_id AND esr.sales_status IN (?) AND esr.tenant_id=? AND esr.tenant_app_id=?) AND EXISTS (SELECT ? FROM erp_sales_detail esd WHERE t?.tenant_id=esd.tenant_id AND t?.tenant_app_id=esd.tenant_app_id AND t?.sales_erp_id=esd.sales_erp_id AND esd.sales_type IN (?) AND esd.tenant_id=? AND esd.tenant_app_id=?) AND t?.tenant_id=? AND t?.tenant_app_id=?|6|16|6||0|0|7591|1505|1251|241|
|user_service|SELECT tu.user_name AS memberName,tu.mobile_no AS mobile,emg.grade_name AS gradeLevel,tu.user_id AS memberUserId,tu.tenant_id AS tenantId,tu.tenant_app_id AS tenantAppId,ue.employee_id AS employeeId,ue.employee_erp_id AS employeeErpId,tmb.erp_member_id AS memberErpId,tmi.shop_id FROM user_service.tenant_member tu JOIN user_service.tenant_member_info tmi ON tu.tenant_id=tmi.tenant_id AND tu.id=tmi.id LEFT JOIN user_service.tenant_member_bind tmb ON tu.tenant_id=tmb.tenant_id AND tu.id=tmb.id LEFT JOIN user_service.erp_member_grade emg ON tu.tenant_id=emg.tenant_id AND tmi.grade_id=emg.grade_erp_id LEFT JOIN user_service.user_employee ue ON tu.tenant_id=ue.tenant_id AND tu.tenant_app_id=ue.tenant_wechatapp_id AND tu.user_id=ue.user_id WHERE tu.tenant_id=? AND tu.tenant_app_id=? AND tu.user_id IN|6|12|2||0|0|14435|2500|2887|500|
|corpwx_license|DELETE FROM cwx_sync_active_info WHERE (tenant_id=? AND user_id=?) AND tenant_id=?|6|9|3||0|0|173569|29101|0|0|
|v4_sales|SELECT count(DISTINCT es.id) FROM v4_sales.erp_sales es JOIN v4_sales.erp_sales_detail esd ON esd.sales_erp_id=es.sales_erp_id AND esd.tenant_id=? AND esd.tenant_app_id=? LEFT JOIN v4_sales.warranty_can_added w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE es.sales_status=? AND es.is_sales=? AND es.sales_date BETWEEN ? AND ? AND w.id IS ? AND es.dept_erp_id IN (?) AND es.tenant_id=? AND es.tenant_app_id=?|6|18|4||0|0|1863216|502113|6|1|
|authorization_service|UPDATE user_login_token SET status=? WHERE login_token IN|6|14|5||0|0|10264|2753|0|0|
|user_service|SELECT tm.user_id AS userId,tm.head_img_url AS headImgUrl,tm.user_name AS nickName,tm.mobile_no AS mobileNo,tm.sex,DATE_FORMAT(tm.create_time,?) AS registerTime,tm.id AS tenantUserId 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.user_employee t? ON tm.user_id=t?.user_id AND tm.tenant_id=t?.tenant_id AND tm.tenant_app_id=t?.tenant_wechatapp_id WHERE t?.id IS ? AND tmi.shop_id=? AND tmi.tenant_id=? AND tmi.tenant_app_id=? ORDER BY tm.id ASC LIMIT ?|6|92|25||0|0|184124|52194|60|10|
|tenant|SELECT sales_erp_id FROM tenant.erp_sales es JOIN tenant.erp_sales_ignore ei ON ei.tenant_id=? AND ei.tenant_app_id=? AND es.sales_erp_id=ei.erp_sales_id WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND member_erp_id=?|6|21|13||0|0|59590|10341|132|66|
|employee|SELECT count(*) FROM label_task_employee t? JOIN label_task_setting t? ON t?.label_task_id=t?.id AND t?.disabled=? WHERE t?.tenant_app_id=? AND t?.shop_id=? AND t?.visit_status>? AND t?.finish_time>=DATE_SUB(CURRENT_DATE,INTERVAL ? day) AND t?.finish_time<CURRENT_DATE|6|20|7||0|0|160137|51424|6|1|
|gift_mail|SELECT count(?) FROM (SELECT t.*,tt.can_take_date,tt.shop_id,tt.shop_name,tt.take_shop_name,tt.take_employee_name,ta.recipients,ta.user_tel,CONCAT(ta.area,ta.address)address,if(t.trade_type=? OR t.trade_type=?,pl.id,it.barcode) AS barcode,if(t.trade_type=? OR t.trade_type=?,pl.default_image_url,p.default_image_url) AS defaultImageUrl FROM trade t LEFT OUTER JOIN trade_take tt ON t.tenant_wechatapp_id=tt.tenant_wechatapp_id AND t.id=tt.trade_id LEFT OUTER JOIN trade_addr ta ON t.tenant_wechatapp_id=ta.tenant_wechatapp_id AND t.id=ta.trade_id LEFT OUTER JOIN product p ON p.id=t.product_id LEFT OUTER JOIN platform_product pl ON pl.id=t.product_id LEFT OUTER JOIN inventory it ON it.product_id=t.product_id AND it.specification=t.specification LEFT OUTER JOIN trade_express te ON te.tenant_wechatapp_id=t.tenant_wechatapp_id AND te.trade_id=t.id WHERE (t.tenant_wechatapp_id=? AND t.trade_type=?) ORDER BY create_time DESC)tmp_count|5|13|6||0|0|264147|94192|5|1|
|gift_mail|SELECT tt.shop_id FROM gift_mail.trade t JOIN gift_mail.trade_take tt ON tt.tenant_wechatapp_id=t.tenant_wechatapp_id AND tt.trade_id=t.id WHERE t.tenant_id=? AND t.tenant_wechatapp_id=? AND tt.shop_id IS NOT ?|5|13|6||0|0|75437|26912|37700|13456|
|coupon_service|SELECT t.id FROM coupon_service.template t LEFT JOIN coupon_service.coupon_scope s ON s.tenant_id=t.tenant_id AND s.tenant_app_id=t.tenant_app_id AND s.template_id=t.id WHERE t.coupon_type=? AND t.tenant_id=? AND t.tenant_app_id=? AND (t.scope=? OR (s.scope=? AND s.product_id=?) OR (s.scope=? AND s.classify_id=?))|5|6|1||0|0|110053|22042|3|1|
|v4_sales|SELECT count(DISTINCT es.id) FROM v4_sales.erp_sales es JOIN v4_sales.erp_sales_detail esd ON esd.sales_erp_id=es.sales_erp_id AND esd.sales_type IN (?) AND member_erp_id IN (?) AND esd.tenant_id=? AND esd.tenant_app_id=? WHERE es.tenant_id=? AND es.tenant_app_id=?|5|11|4||0|0|16070|9894|5|1|
|user_service|SELECT count(?) FROM user_service.tenant_member t? JOIN user_service.tenant_member_info t? ON t?.tenant_id=t?.tenant_id AND t?.id=t?.id AND t?.tenant_app_id=? AND t?.shop_id=? JOIN user_service.user_employee ue ON t?.tenant_id=ue.tenant_id AND t?.tenant_app_id=ue.tenant_wechatapp_id AND t?.user_id=ue.user_id AND ue.employee_id=? AND ue.shop_id=? WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND (t?.mobile_no LIKE concat(?,?) OR t?.user_name LIKE concat(?,?,?))|5|6|1||0|0|18865|8261|5|1|
|v4_coupon|SELECT COUNT(*) AS total FROM (SELECT DISTINCT c.id,c.activity_name,c.push_time,c.tag_id,c.butler_call_member FROM v4_coupon.tag_push_coupon c JOIN v4_coupon.tag_push_coupon_log l ON l.tag_push_coupon_id=c.id AND l.push_coupon_state=? AND l.tenant_id=? AND l.tenant_app_id=? WHERE c.push_state=? AND c.butler_visible=? AND l.shop_id=? AND l.employee_id=? AND c.push_time>=? AND c.tenant_id=? AND c.tenant_app_id=? ORDER BY c.push_time DESC)c|5|7|2||0|0|1721654|344331|5|1|
|v4_user|SELECT id,member_name,mobile_no,head_img_url,combine_status,combine_id FROM member WHERE ((mobile_no LIKE ? OR member_name LIKE ?)) AND tenant_id=? AND tenant_app_id=? LIMIT ?|5|10|3||0|0|598269|120452|5|1|
|value_added|SELECT ? 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=? AND t.state=? AND t.start_add_time>=date_add(DATE_FORMAT(?,?),interval ?*(t.add_days?)day) AND t.start_add_time<date_add(DATE_FORMAT(?,?),interval(?*(t.add_days?)+?)day) GROUP BY t.tenant_wechatapp_id,t.user_id,ue.dept_erp_id|5|16|10||0|0|1365631|472551|325|105|
|tenant|SELECT count(?) FROM (SELECT shop.*,dept.dept_name,count(es.id) AS employeesCount FROM tenant_wechatapp_shop shop LEFT JOIN erp_department dept ON shop.dept_erp_id=dept.dept_erp_id AND shop.tenant_id=dept.tenant_id LEFT JOIN employee_shop es ON shop.id=es.shop_id AND es.status IN (?) WHERE shop.tenant_wechatapp_id=? AND shop.status IN (?) GROUP BY shop.id)table_count|5|9|2||0|0|465494|93197|5|1|
|v4_employee|SELECT count(*) AS total_count,count(finish_time) AS finish_count FROM task_task t JOIN task_invite_task_template t? ON t.task_template_id=t?.id AND t?.tenant_id=? AND t?.tenant_app_id=? WHERE t?.invite_time<? AND t.end_time>? AND t?.status IN (?) AND t.task_type=? AND t.status=? AND t.shop_id=? AND t.tenant_id=? AND t.tenant_app_id=?|4|9|4||0|0|158589|78417|4|1|
|tenant|SELECT id,tenant_id,tenant_app_id,user_id,status,group_label,maintain_level,remark,create_time,create_shop_id,create_employee_id,update_time,update_shop_id,update_employee_id,sales_amount,next_maintain_date,maintain_employee_id,sneak_guest_no,last_maintain_date,finish_date,fail_type,oid,user_type FROM sneak_guest WHERE (tenant_app_id=? AND status=? AND create_shop_id=?) ORDER BY id DESC|4|9|4||0|0|29978|8408|14989|4204|
|v4_employee|SELECT COUNT(*) AS total FROM mark_label_task WHERE (employee_id=? AND start_time>=? AND end_time<? AND status=?) AND tenant_id=? AND tenant_app_id=?|4|5|1||0|0|2730|929|4|1|
|warranty_service|SELECT count(*) FROM warranty WHERE user_id=? AND tenant_wechatapp_id=? AND is_disable=?|4|23|12||0|0|35654|16666|4|1|
|v4_employee|SELECT COUNT(*) AS total FROM task_task t JOIN employee e ON e.employee_id=t.employee_id AND e.shop_id=t.shop_id AND e.tenant_id=? AND e.tenant_app_id=? LEFT JOIN (SELECT task_id,GROUP_CONCAT(file_url SEPARATOR ?) AS task_attaches FROM task_task_attach WHERE tenant_id=? AND tenant_app_id=? GROUP BY task_id)tta ON t.id=tta.task_id WHERE t.status=? AND system_task_type=? AND t.shop_id=? AND finish_time>=? AND finish_time<? AND t.employee_id=? AND t.tenant_id=? AND t.tenant_app_id=?|4|6|1||0|0|54030|13533|4|1|
|coupon_service|SELECT market_id AS id,count(market_id) AS quantity FROM (SELECT market_id FROM coupon_service.coupon_market_order WHERE market_id IN (?) AND order_state=? GROUP BY user_id,market_id)number GROUP BY market_id|4|18|9||0|0|2294487|574190|67|20|
|payment|SELECT id,tenant_id,tenant_app_id,goods_order_source,goods_order_no,pay_order_id,transaction_id,goods_amount,refund_amount,fee_type,refund_reason,refund_account,request_ip,user_id,user_identify,user_sub_identify,order_start_time,refund_id,settlement_refund_amount,refund_recv_accout,refund_request_source,refund_finish_time,refund_status,refund_status_desc,error_msg,wxappid,sub_wxappid,mch_id,sub_mch_id,callback_tag,callback_result,create_time,update_time FROM refund_order WHERE callback_result IN(?) AND refund_status IN(?) ORDER BY id ASC LIMIT ?|4|5|1||0|0|56777|14195|0|0|
|employee|SELECT id,scene,employee_id,member_user_name userName,finish_time,status FROM employee.backlog_? WHERE tenant_id=? AND tenant_app_id=? AND shop_id=? AND expire_time BETWEEN ? AND ? AND status!=? AND scene NOT IN(?) ORDER BY id DESC LIMIT ?|4|12|3||0|0|1554908|508838|13|7|
|v4_user|SELECT maintain_employee_id,id FROM potential_customer WHERE (maintain_shop_id=? AND status IN (?)) AND tenant_id=? AND tenant_app_id=?|4|4|1||0|0|7875|2396|1550|589|
|tenant|SELECT count(DISTINCT concat(dept_erp_id,?,sales_date)) AS total FROM tenant.erp_sales WHERE tenant_id=? AND tenant_wechatapp_id=? AND member_erp_id=? AND sales_status=? AND is_sales=?|4|10|4||0|0|44763|40049|4|1|
|tenant|SELECT count(*)amount FROM sneak_guest WHERE tenant_app_id=? AND status=? AND create_shop_id=? AND create_time<=?|4|8|4||0|0|14989|4204|4|1|
|user_service|SELECT * FROM user_employee WHERE tenant_wechatapp_id=? AND employee_id=?|4|4|1||0|0|134486|113883|36660|16057|
|sms|SELECT ifnull(sum(ifnull(t?.sms_size,?)*t?.send_count),?) AS amount FROM sms_send t? LEFT JOIN sms.sms_send_extend t? ON t?.biz_id=t?.biz_id WHERE t?.tenant_app_id=? AND t?.code=? AND t?.create_time>=? AND t?.create_time<?|3|9|5||0|0|12742|5009|3|1|
|v4_sales|SELECT COUNT(*) AS total FROM value_added_record WHERE (value_added_id=?) AND tenant_id=? AND tenant_app_id=?|3|29|14||0|0|7007283|2335761|3|1|
|message_push|INSERT INTO message_log(id,tenant_id,tenant_app_id,user_id,scene_type,msg_id,post_data,create_time,update_time) VALUES (?,?,?,?,?,?,?,?,?)|3|3|1||0|0|0|0|0|0|
|v4_sales|SELECT * FROM v4_sales.comment WHERE order_id=? AND tenant_id=? AND tenant_app_id=? LIMIT ?|3|4|2||0|0|180822|60373|0|0|
|employee|UPDATE backlog_? SET status=?,finish_time=? WHERE tenant_app_id=? AND scene=? AND status IN (?)|3|20|14||0|0|2891285|1390189|0|0|
|v4_user|SELECT t?.id,t?.external_user_id AS externalUserId,t?.member_id AS memberId,t?.checkin_time,t?.maintain_num AS maintainNum,if(t?.event_type=?,t?.next_maintain_time,?) AS nextMaintainTime,t?.event_type AS `status`,(CASE t?.event_type WHEN ? THEN ? ELSE ? END) AS statusName,t?.create_time AS maintainTime FROM potential_customer_maintain t? JOIN potential_customer t? ON t?.id=t?.potential_customer_id AND t?.tenant_id=? AND t?.tenant_app_id=? WHERE t?.maintain_shop_id=? AND t?.maintain_employee_id=? AND t?.create_time>=? AND t?.create_time<? AND t?.event_type=? AND t?.tenant_id=? AND t?.tenant_app_id=? ORDER BY t?.id LIMIT ?|3|23|16||0|0|1480917|495902|24|10|
|coupon_service|SELECT cm.id,cp.coupon_type,t.coupon_name,cm.display_way,round(t.face_value/?,?) AS faceValue,round(t.discount/?,?) AS discount,t.face_value AS point,tgl.get_quantity,cp.take_effect_way,cm.pay_type,cm.state,(tgl.put_quantity-tgl.get_quantity) AS surplusQuantity,cp.take_start_day,cp.take_effect_day,cp.begin_time,cp.end_time,tr.type AS redpackType,round(tr.min_price/?,?) AS minPrice,round(tr.max_price/?,?) AS maxPrice,round(cp.use_threshold/?,?) AS useThreshold FROM coupon_service.coupon_market cm JOIN coupon_service.coupon_push cp ON cp.source_id=cm.id AND cp.source=? AND cp.state=? JOIN coupon_service.template t ON t.id=cp.template_id JOIN coupon_service.template_grant_limit tgl ON tgl.coupon_push_id=cp.id LEFT JOIN coupon_service.template_redpack tr ON tr.template_id=t.id WHERE cm.tenant_app_id=? AND cm.state!=? AND cm.type=? ORDER BY cm.id DESC LIMIT ?|3|6|2||0|0|118464|39810|60|20|
|authorization_service|SELECT id,platform_user_id,user_id,wx_user_id,employee_id,shop_id,tenant_id,tenant_wx_app_id,account_id,login_way,login_code,login_token,roles,status,expire_time,create_time,update_time,login_ip,login_time,login_data,wx_app_user_id FROM user_login_token WHERE (tenant_id=? AND employee_id=? AND status=?)|3|4|2||0|0|6208|2753|6208|2753|
|coupon_service|SELECT count(?) FROM coupon_service.coupon_market cm JOIN coupon_service.coupon_push cp ON cp.source_id=cm.id AND cp.source=? AND cp.state=? JOIN coupon_service.template t ON t.id=cp.template_id JOIN coupon_service.template_grant_limit tgl ON tgl.coupon_push_id=cp.id LEFT JOIN coupon_service.template_redpack tr ON tr.template_id=t.id WHERE cm.tenant_app_id=? AND cm.state!=? AND cm.type=?|3|4|1||0|0|117781|39475|3|1|
|gift_mail|DELETE FROM inventory_log WHERE inventory_id=?|3|8|4||0|0|598938|199649|0|0|
|gift_mail|SELECT id,tenant_wechatapp_id,shop_id,shop_name,product_id,create_time,update_time FROM take_shop WHERE product_id=?|3|6|2||0|0|147426|49144|12|9|
|v4_user|SELECT id,member_id,external_user_id,serial_number,checkin_shop_id,checkin_employee_id,checkin_employee_name,checkin_time,maintain_shop_id,maintain_employee_id,maintain_employee_name,first_maintain_time,last_maintain_time,next_maintain_time,maintain_num,intention_num,latest_intention,status,finish_time,finish_shop_id,deal_employee_id,deal_employee_name,deal_sale_amount,fail_employee_id,fail_employee_name,fail_reason,remark,sex,cutomer_grade,maintain_level,tenant_id,tenant_app_id,create_time,update_time FROM potential_customer WHERE ((member_id=? OR external_user_id=?) AND status IN (?) AND maintain_shop_id=?) AND tenant_id=? AND tenant_app_id=?|3|4|1||0|0|7175|2393|1|1|
|activity_service|SELECT count(*)>? FROM activity_service.online_sign_user_sign_log WHERE tenant_app_id=? AND user_id=? AND to_days(create_time)=to_days(?)|3|4|1||0|0|3065|1343|3|1|
|authorization_service|SELECT id,user_id,tenant_id,tenant_wx_app_id,account_id,login_way,login_code,login_token,roles,status,expire_time,create_time,update_time,login_ip,login_time,login_data,employee_id,shop_id,platform_user_id,wx_user_id,wx_app_user_id FROM user_login_token WHERE user_id=? AND tenant_id=? AND tenant_wx_app_id=? AND login_way=? AND status=? AND expire_time>now()|3|7|4||0|0|727|377|3|1|
|coupon_service|SELECT cet.id,cet.coupon_id,cet.user_id,cet.coupon_type,cet.expire_time,if((cet.expire_time<now() AND cet.status=?),?,cet.status) AS status FROM coupon_service.coupon_expire_task cet JOIN coupon_service.coupon_extend ce ON ce.tenant_id=? AND ce.tenant_app_id=? AND ce.coupon_id=cet.coupon_id WHERE cet.tenant_id=? AND cet.tenant_app_id=? AND cet.employee_id=? AND cet.shop_id=?|3|4|2||0|0|21118|12938|10559|6469|
||SELECT wx_app_id,count(*) AS c FROM user_service.wx_user WHERE wx_app_id IN(?) GROUP BY wx_app_id|3|61|38||0|0|103712|34572|4|2|
|tenant|SELECT shop.*,dept.dept_name,count(es.id) AS employeesCount FROM tenant_wechatapp_shop shop LEFT JOIN erp_department dept ON shop.dept_erp_id=dept.dept_erp_id AND shop.tenant_id=dept.tenant_id LEFT JOIN employee_shop es ON shop.id=es.shop_id AND es.status IN(?) WHERE shop.tenant_wechatapp_id=? AND shop.status IN (?) GROUP BY shop.id ORDER BY shop.create_time DESC LIMIT ?|3|6|2||0|0|279227|93077|60|20|
|authorization_service|SELECT id,tenant_id,account_id,type,login_name,hash_password,salt,user_id,employee_id,tenant_app_id,status,create_time,update_time FROM login_account WHERE (type=? AND login_name=?)|3|4|1||0|0|196747|65586|3|1|
|v4_user|SELECT COUNT(*) AS total FROM potential_customer t? WHERE t?.maintain_shop_id=? AND t?.maintain_employee_id=? AND t?.status IN (?) AND t?.tenant_id=? AND t?.tenant_app_id=?|3|4|1||0|0|3603|1658|3|1|
|tenant|SELECT count(?) FROM (SELECT sg.id,sg.sneak_guest_no,sg.user_id,sg.user_type,ey.employee_name AS maintainEmployeeName,sg.last_maintain_date,ws.shop_name AS createShopName,sg.status,sg.create_time,t?.employee_name AS createEmployeeName,sg.finish_date,sg.fail_type,gs.sales_id,gs.sales_no,w?.shop_name salesShopName,gs.create_time AS salesDate,gs.product_name,gs.product_quantity,gs.amount salesAmount,if(sg.status=?,(CASE WHEN sg.fail_type=? THEN ? ELSE ifnull(emp.employee_name,?) END),?) AS operFailEmployeeName FROM sneak_guest sg LEFT JOIN employee ey ON sg.maintain_employee_id=ey.id LEFT JOIN tenant_wechatapp_shop ws ON sg.create_shop_id=ws.id LEFT JOIN employee t? ON sg.create_employee_id=t?.id LEFT JOIN sneak_guest_sales gs ON sg.tenant_app_id=gs.tenant_app_id AND sg.id=gs.sneak_guest_id LEFT JOIN tenant_wechatapp_shop w? ON gs.shop_id=w?.id LEFT JOIN tenant.sneak_guest_maintain gm ON gm.sneak_guest_id=sg.id AND gm.event_type=? LEFT JOIN employee emp ON gm.employee_id=emp.id WHERE sg.tenant_app_id=? ORDER BY sg.id DESC)tmp_count|3|9|4||0|0|116670|38890|3|1|
|v4_giftmall|SELECT * FROM v4_giftmall.trade WHERE trade_type=? AND order_status=? AND update_time<=DATE_SUB(NOW(),INTERVAL ? MINUTE)|2|3|1||0|0|21890|10946|0|0|
|coupon_service|SELECT count(?) FROM coupon_service.coupon cu JOIN coupon_service.coupon_extend ce ON ce.tenant_id=? AND ce.tenant_app_id=? AND ce.id=cu.id WHERE cu.tenant_id=? AND cu.tenant_app_id=? AND cu.coupon_name LIKE CONCAT(CONCAT(?,?),?) AND cu.create_time>=? AND cu.create_time<=?|2|41|21||0|0|457838|228919|2|1|
|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 FROM user_service.tenant_member tm JOIN user_service.user_employee ue ON ue.tenant_id=? AND ue.tenant_wechatapp_id=? AND tm.user_id=ue.user_id AND ue.employee_id=? AND ue.shop_id=? WHERE tm.tenant_id=? AND tm.tenant_app_id=? ORDER BY tm.id DESC LIMIT ?|2|2|1||0|0|8853|7392|24|12|
|v4_coupon|SELECT tenant_id,tenant_app_id,member_id,count(?)total FROM v4_coupon.coupon WHERE DATEDIFF(DATE_FORMAT(end_time,?),DATE_FORMAT(now(),?))=? AND coupon_status IN (?) GROUP BY tenant_id,tenant_app_id,member_id|2|34|18||0|0|1967750|984396|5840|2923|
|employee|UPDATE backlog_system SET status=?,finish_time=now() WHERE tenant_app_id=? AND scene=?|2|27|25||0|0|1616778|1429358|0|0|
|tenant|SELECT count(*) FROM sneak_guest WHERE (tenant_app_id=? AND status=? AND create_shop_id=? AND maintain_employee_id=?)|2|2|1||0|0|2559|1721|2|1|
|employee|SELECT id,scene,employee_id,member_user_name userName,finish_time,status FROM employee.backlog_? WHERE tenant_id=? AND tenant_app_id=? AND shop_id=? AND expire_time BETWEEN ? AND ? AND status!=? AND scene NOT IN(?) ORDER BY id DESC LIMIT ?,?|2|339|177||0|0|6599218|3299609|4|2|
|tenant|SELECT sg.tenant_app_id AS tenantAppId,sg.create_shop_id AS shopId,sg.maintain_employee_id AS employeeId,emp.corp_wx_user_id AS corpwxUserId,count(*) AS waitMaintainNum FROM tenant.sneak_guest sg JOIN tenant.employee emp ON sg.maintain_employee_id=emp.id WHERE sg.tenant_app_id=? AND sg.status=? AND sg.next_maintain_date>=CURRENT_DATE AND sg.next_maintain_date<DATE_ADD(CURRENT_DATE,INTERVAL ? day) GROUP BY sg.tenant_app_id,sg.create_shop_id,sg.maintain_employee_id,emp.corp_wx_user_id|2|7|5||0|0|12952|7354|5|5|
|authorization_service|INSERT INTO user_login_token(id,platform_user_id,user_id,wx_user_id,wx_app_user_id,employee_id,shop_id,tenant_id,tenant_wx_app_id,account_id,login_way,login_code,login_token,roles,status,expire_time,create_time,update_time,login_ip,login_time,login_data) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)|2|3|1||0|0|0|0|0|0|
|v4_user|SELECT checkin_time,id FROM potential_customer WHERE (maintain_shop_id=? AND status IN (?)) AND tenant_id=? AND tenant_app_id=?|2|2|1||0|0|4197|2396|828|589|
|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 WHERE ue.employee_id=? AND ue.tenant_id=? AND ue.tenant_wechatapp_id=? AND ue.shop_id=? ORDER BY tm.id DESC LIMIT ?|2|4|3||0|0|40586|20293|20|10|
|erp_sync|SELECT * FROM erp_sync.retry_data WHERE (need_erp_member_id=? OR (need_erp_member_id=? AND erp_member_id IS NOT ?)) AND retry_times>? ORDER BY id|2|3|1||0|0|7868|3934|562|281|
|order|SELECT count(?) FROM (SELECT o.id,o.order_no,o.user_name,o.take_type,o.mobile_no,od.product_name,od.image_url,if(take_shop_id IS ?,wait_take_shop_id,take_shop_id)takeShopId,take_employee_user_name,o.receive_time,o.cancel_time,od.take_start_date,o.refund_start_time refundTime,o.user_name refundUserName,o.status,oa.express_company,oa.express_no,om.mark FROM `order`.order_info o JOIN `order`.order_detail od ON od.tenant_id=? AND od.tenant_wechatapp_id=? AND od.order_id=o.id LEFT JOIN `order`.order_mark om ON om.tenant_id=? AND om.tenant_app_id=? AND om.order_id=o.id AND om.status=? LEFT JOIN `order`.order_address oa ON oa.tenant_id=? AND oa.tenant_app_id=? AND oa.order_id=o.id WHERE o.tenant_id=? AND o.tenant_wechatapp_id=? AND o.take_type=? AND (o.wait_take_shop_id=? OR o.take_shop_id=?) AND o.status=? ORDER BY o.id)tmp_count|2|2|1||0|0|7146|3579|2|1|
|gift_mail|SELECT count(*) FROM gift_mail.trade t WHERE t.tenant_wechatapp_id=? AND t.trade_type=? AND t.order_status=?|2|5|3||0|0|18446|9224|2|1|
|gift_mail|SELECT count(?) FROM (SELECT p.*,sp.take_type,ifnull(pp.integral_price,ifnull((SELECT min(inventory.price) FROM inventory WHERE inventory.product_id=p.id),?)) AS price,ifnull(t.quantity,?)quantity,pt.partner_name vendorName,? distance,c.categroy_name categroy_name,pp.partner_id FROM product p INNER JOIN category c ON c.id=p.category_id LEFT OUTER JOIN self_product sp ON p.id=sp.product_id LEFT OUTER JOIN partner_product pp ON p.id=pp.product_id LEFT OUTER JOIN partner pt ON pt.id=pp.partner_id LEFT OUTER JOIN (SELECT product_id,sum(quantity)quantity FROM gift_mail.inventory GROUP BY product_id)t ON p.id=t.product_id WHERE ((p.is_disable IS ? OR p.is_disable=?))) AS p LEFT OUTER JOIN product_status ps ON p.id=ps.product_id AND ps.tenant_wechatapp_id=? WHERE (p.tenant_id=? AND p.product_name LIKE ? AND p.product_type=? AND (ps.id IS NOT ? OR p.tenant_wechatapp_id=?))|2|5|4||0|0|108497|54263|2|1|
|erp_app|COMMIT ?|2|2|1||0|0|0|0|0|0|
|v4_employee|SELECT count(?) AS total_count,count(finish_time) AS finish_count FROM task_task t JOIN task_system_task_template t? ON t.task_template_id=t?.id AND t?.status=? AND t?.tenant_id=? AND t?.tenant_app_id=? WHERE t.task_type=? AND t.status=? AND t.start_time>=? AND t.start_time<? AND t.shop_id=? AND t.employee_id=? AND t.tenant_id=? AND t.tenant_app_id=?|2|2|1||0|0|2795|2261|2|1|
|goods|SELECT * FROM goods WHERE tenant_id=? AND style_no=? AND status<?|2|2|1||0|0|31438|15725|0|0|
|v4_user|SELECT t?.id,t?.external_user_id AS externalUserId,t?.member_id AS memberId,t?.checkin_time,t?.maintain_num AS maintainNum,if(t?.event_type=?,t?.next_maintain_time,?) AS nextMaintainTime,t?.event_type AS `status`,(CASE t?.event_type WHEN ? THEN ? ELSE ? END) AS statusName,t?.create_time AS maintainTime FROM potential_customer_maintain t? JOIN potential_customer t? ON t?.id=t?.potential_customer_id AND t?.tenant_id=? AND t?.tenant_app_id=? WHERE t?.maintain_shop_id=? AND t?.maintain_employee_id=? AND t?.create_time>=? AND t?.create_time<? AND t?.event_type IN (?) AND t?.tenant_id=? AND t?.tenant_app_id=? ORDER BY t?.id LIMIT ?|2|28|18||0|0|926108|463054|20|10|
|v4_sales|SELECT DISTINCT es.* FROM v4_sales.erp_sales es JOIN v4_sales.erp_sales_detail esd ON esd.sales_erp_id=es.sales_erp_id AND esd.tenant_id=? AND esd.tenant_app_id=? LEFT JOIN v4_sales.warranty_can_added w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE es.sales_status=? AND es.is_sales=? AND es.sales_date BETWEEN ? AND ? AND w.id IS ? AND es.dept_erp_id IN (?) AND es.tenant_id=? AND es.tenant_app_id=?|2|2|1||0|0|945424|500797|102509|60616|
|goods|SELECT count(?) FROM (SELECT gs.id,gs.tenant_id,gs.tenant_app_id,gs.category_id,gs.activity_id,gs.goods_name,gs.style_no,gs.base_sale_number,gs.limit_sale,if(gs.status=?,gs.status,if(t.id IS ?,?,?))status,gs.thumbnail_img,gs.express_type,gs.take_stock_day,gs.take_remark,gs.express_fee,gs.create_time,gs.update_time,gs.sale_type,gs.take_start_time,gs.page_id,gs.pay_way,gs.advance_payment,gs.exchange_money,ifnull(sku.minPrice,?) AS minPrice,ifnull(sku.marketPrice,?) AS marketPrice,ifnull(sku.totalSalesVolume,?) AS totalSalesVolume,ifnull(sku.totalQuantity,?) AS totalQuantity,ifnull(number,?)skuNumber,gs.topping FROM goods.goods gs LEFT JOIN (SELECT id,goods_id FROM goods.goods_up_app gu WHERE gu.tenant_app_id=?)t ON gs.id=t.goods_id LEFT JOIN (SELECT goods_id,min(price) AS minPrice,max(market_price)marketPrice,sum(sales_volume) AS totalSalesVolume,sum(quantity) AS totalQuantity,count(*)number FROM goods.goods_sku WHERE activity_id=? GROUP BY tenant_id,goods_id)sku ON sku.goods_id=gs.id WHERE gs.tenant_id=? AND gs.status<? ORDER BY gs.topping DESC,sku.totalSalesVolume DESC,gs.id DESC)tmp_count|2|2|1||0|0|133121|66612|2|1|
|v4_sales|SELECT count(es.id) FROM v4_sales.erp_sales es JOIN v4_sales.warranty_can_added wca ON wca.sales_id=es.id AND wca.tenant_id=? AND wca.tenant_app_id=? WHERE es.sales_status=? AND es.is_sales=? AND es.sales_date BETWEEN ? AND ? AND es.tenant_id=? AND es.tenant_app_id=?|2|4|2||0|0|237634|160908|2|1|
|gift_mail|SELECT p.id,p.product_name,p.tag_price,i.volume,p.product_status AS status,p.default_image_url,i.quantity,i.market_price,if(prp.id IS ?,?,?) AS hasRecommend FROM gift_mail.platform_product p JOIN gift_mail.platform_inventory i ON i.product_id=p.id LEFT JOIN gift_mail.platform_recommend_product prp ON prp.tenant_app_id=? AND prp.is_recommend=? AND prp.platform_product_id=p.id WHERE prp.id IS ? AND p.product_status=? ORDER BY i.volume DESC ,p.tag_price ASC ,p.id DESC LIMIT ?|2|2|1||0|0|17789|8901|12|6|
|v4_sales|SELECT es.id salesId,es.sales_no,es.sales_date,es.member_erp_id memberId,w.warranty_no FROM v4_sales.erp_sales es LEFT JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE is_sales=? AND sales_status=? AND (es.sales_no LIKE concat(?,?) OR es.member_erp_id=?) AND w.id IS NOT ? AND es.tenant_id=? AND es.tenant_app_id=? ORDER BY es.sales_date DESC,es.id DESC LIMIT ?|2|2|1||0|0|677413|635339|5|3|
|v4_sales|SELECT count(DISTINCT es.id) FROM v4_sales.erp_sales es JOIN v4_sales.warranty_can_added wca ON wca.sales_id=es.id AND wca.tenant_id=? AND wca.tenant_app_id=? WHERE es.dept_erp_id=? AND es.employee_erp_id=? AND es.sales_status=? AND es.is_sales=? AND es.sales_date BETWEEN ? AND ? AND es.tenant_id=? AND es.tenant_app_id=?|2|2|1||0|0|8680|5828|2|1|
|v4_user|SELECT t?.maintain_shop_id,t?.maintain_employee_id,t?.maintain_level,count(*) AS maintainNum FROM potential_customer t? WHERE t?.tenant_app_id=? AND t?.`status` IN (?) AND t?.next_maintain_time>=? AND t?.tenant_id=? AND t?.tenant_app_id=? GROUP BY t?.maintain_shop_id,t?.maintain_employee_id,t?.maintain_level|2|9|8||0|0|16090|8982|498|334|
|v4_sales|SELECT count(*) FROM v4_sales.erp_sales es JOIN v4_sales.warranty_can_added wca ON wca.sales_id=es.id AND wca.tenant_id=? AND wca.tenant_app_id=? LEFT JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE es.sales_status=? AND es.is_sales=? AND w.id IS ? AND es.sales_date BETWEEN ? AND ? AND es.tenant_id=? AND es.tenant_app_id=?|2|3|1||0|0|166265|127902|2|1|
|v4_employee|SELECT count(?) FROM v4_employee.task_task t WHERE t.shop_id=? AND t.employee_id=? AND t.`status`=? AND t.task_type=? AND t.finish_time IS ? AND t.end_time>now() AND t.tenant_id=? AND t.tenant_app_id=?|2|2|1||0|0|4414|2207|2|1|
|tenant|SELECT count(?) FROM sneak_guest sg LEFT JOIN employee ey ON sg.maintain_employee_id=ey.id WHERE sg.tenant_app_id=? AND sg.create_shop_id=? AND sg.maintain_employee_id=? AND EXISTS (SELECT ? FROM tenant.sneak_guest_maintain sgm WHERE sg.id=sgm.sneak_guest_id AND sgm.event_type=? AND sgm.intention_info REGEXP ?) AND sg.status=?|2|3|2||0|0|1293|917|2|1|
|v4_sales|SELECT es.dept_erp_id deptId,sum(CASE WHEN w.id IS NOT ? THEN ? ELSE ? END)addedTotal,sum(CASE WHEN w.id IS ? THEN ? ELSE ? END)notAddTotal,count(es.id)salesTotal FROM v4_sales.erp_sales es JOIN v4_sales.warranty_can_added wca ON wca.sales_id=es.id AND wca.tenant_id=? AND wca.tenant_app_id=? LEFT JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE es.sales_status=? AND es.is_sales=? AND es.sales_date BETWEEN ? AND ? AND es.tenant_id=? AND es.tenant_app_id=? GROUP BY es.dept_erp_id|2|12|8||0|0|594972|479875|8|4|
|tenant|SELECT count(?) FROM erp_sales es WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.sales_date>=? AND es.employee_erp_id=? AND es.sales_status=? AND es.is_sales=?|2|4|2||0|0|6732|3366|2|1|
|user_service|SELECT t?.id,t?.user_id AS userId,t?.user_name AS userName,t?.sex,t?.mobile_no AS mobileNo,t?.head_img_url AS headImg FROM user_service.tenant_member t? JOIN user_service.tenant_member_info t? ON t?.tenant_id=t?.tenant_id AND t?.id=t?.id AND t?.tenant_app_id=? AND t?.shop_id=? JOIN user_service.user_employee ue ON t?.tenant_id=ue.tenant_id AND t?.tenant_app_id=ue.tenant_wechatapp_id AND t?.user_id=ue.user_id AND ue.employee_id=? AND ue.shop_id=? WHERE t?.tenant_id=? AND t?.tenant_app_id=? ORDER BY ue.update_time DESC,t?.id DESC LIMIT ?,?|2|3|2||0|0|16036|8832|20|10|
|tenant|SELECT count(*) FROM tenant.sneak_guest_maintain s JOIN tenant.sneak_guest sg ON sg.tenant_id=s.tenant_id AND sg.tenant_app_id=s.tenant_app_id AND sg.id=s.sneak_guest_id JOIN tenant.employee e ON e.tenant_id=s.tenant_id AND e.id=s.employee_id WHERE s.tenant_id=? AND s.tenant_app_id=? AND sg.create_shop_id=? AND (sg.fail_type IS ? OR sg.fail_type=?) AND s.event_type=? AND s.create_time BETWEEN ? AND ?|2|3|1||0|0|1902|951|2|1|
|tenant|SELECT count(*) FROM erp_sales es WHERE tenant_id=? AND member_erp_id=? AND tenant_wechatapp_id=? AND sales_status=? AND (comment_id IS ? OR comment_id=?) AND sales_date>=? AND NOT EXISTS(SELECT i.id FROM tenant.erp_sales_ignore i WHERE i.tenant_id=? AND i.tenant_app_id=? AND es.sales_erp_id=i.erp_sales_id)|1|1|1||0|0|5|5|1|1|
|tenant|SELECT count(?) FROM erp_sales_detail t? LEFT JOIN erp_sales_detail_extend t? ON t?.tenant_id=t?.tenant_id AND t?.tenant_wechatapp_id=t?.tenant_wechatapp_id AND t?.sales_erp_id=t?.sales_erp_id AND t?.sales_index=t?.sales_index LEFT JOIN erp_sales t? ON t?.tenant_id=t?.tenant_id AND t?.tenant_wechatapp_id=t?.tenant_wechatapp_id AND t?.sales_erp_id=t?.sales_erp_id WHERE t?.tenant_id=? AND t?.tenant_wechatapp_id=? AND t?.tenant_id=t?.tenant_id AND t?.tenant_wechatapp_id=t?.tenant_wechatapp_id AND t?.member_erp_id=? AND t?.sales_status=? AND t?.is_sales=?|1|1|1||0|0|34|34|1|1|
|v4_user|SELECT id FROM potential_customer WHERE (status IN (?) AND next_maintain_time<?) AND tenant_id=? AND tenant_app_id=?|1|5|5||0|0|8314|8314|429|429|
|employee|SELECT count(*) FROM employee.backlog_? WHERE tenant_id=? AND tenant_app_id=? AND shop_id=? AND status=? AND finish_time BETWEEN ? AND ?|1|1|1||0|0|1376|1376|1|1|
|export|SELECT od.coupon_id, CASE o.pay_type WHEN ? THEN ? ELSE ? END payTypeText FROM coupon_service.coupon_market_order_detail od JOIN coupon_service.coupon_market_order o ON o.tenant_id=? AND o.tenant_app_id=? AND o.id=od.order_id WHERE od.tenant_id=? AND od.tenant_app_id=? AND od.coupon_id IN (?)|1|2|2||0|0|9515|9515|0|0|
|v4_sales|SELECT id,value_added_id,change_amount,balance,tenant_id,tenant_app_id,create_time,update_time FROM value_added_record WHERE (value_added_id=?) AND tenant_id=? AND tenant_app_id=? ORDER BY create_time DESC LIMIT ?|1|1|1||0|0|2335771|2335771|10|10|
|order|SELECT count(*) FROM order_info WHERE tenant_wechatapp_id=? AND status=? AND payment_time BETWEEN ? AND ? AND confirm_time IS ?|1|1|1||0|0|3518|3518|1|1|
|timer|UPDATE task_info SET service=?,name=?,callback=?,params=?,cron=?,delay=?,next_time=?,status=?,create_time=?,update_time=? WHERE id=?|1|1|1||0|0|1|1|0|0|
|tenant|SELECT DISTINCT s.employee_id AS id,e.employee_name FROM tenant.sneak_guest_maintain s JOIN tenant.sneak_guest sg ON sg.id=s.sneak_guest_id JOIN tenant.employee e ON s.tenant_id=e.tenant_id AND s.employee_id=e.id WHERE s.tenant_id=? AND s.tenant_app_id=? AND sg.create_shop_id=? AND (sg.fail_type IS ? OR sg.fail_type=?) AND s.event_type=? AND s.create_time BETWEEN ? AND ?|1|1|1||0|0|922|922|4|4|
|v4_user|SELECT employee_id FROM member_butler WHERE (shop_id=? AND employee_id IN (?)) AND tenant_id=? AND tenant_app_id=?|1|1|1||0|0|113793|113793|32462|32462|
|tenant|SELECT id,tenant_id,tenant_app_id,user_id,status,group_label,maintain_level,remark,create_time,create_shop_id,create_employee_id,update_time,update_shop_id,update_employee_id,sales_amount,next_maintain_date,maintain_employee_id,sneak_guest_no,last_maintain_date,finish_date,fail_type,oid,user_type FROM sneak_guest WHERE (tenant_app_id=? AND status=? AND create_time<?)|1|2|2||0|0|4680|4680|13|13|
|v4_coupon|SELECT id,tag_push_coupon_id,member_id,employee_id,shop_id,push_coupon_state,push_fail_reason,call_state,tenant_id,tenant_app_id,create_time,update_time FROM tag_push_coupon_log WHERE (tag_push_coupon_id=? AND push_coupon_state=?) AND tenant_id=? AND tenant_app_id=?|1|3|3||0|0|344331|344331|1|1|
|v4_user|UPDATE member_grade SET grade_id=?,grade_name=?,user_id=?,sale_number=?,sale_amount=?,sale_points=?,tenant_id=?,tenant_app_id=?,create_time=?,update_time=? WHERE id=? AND tenant_id=? AND tenant_app_id=?|1|1|1||0|0|1|1|0|0|
|user_service|SELECT count(*) FROM wx_user WHERE (wx_app_id=?)|1|21|21||0|0|34568|34568|1|1|
|corpwx|DELETE FROM corpwx.corpwx_external_user WHERE tenant_id=?|1|38|38||0|0|49126|49126|0|0|
|v4_user|SELECT count(*) FROM member_change_log t? WHERE t?.change_type IN (?) AND t?.change_time>=? AND t?.change_time<? AND t?.new_shop_id=? AND t?.tenant_id=? AND t?.tenant_app_id=?|1|2|2||0|0|169866|169866|1|1|
|employee|SELECT scene FROM employee.backlog_? WHERE tenant_id=? AND tenant_app_id=? AND shop_id=? AND status=? AND finish_time BETWEEN ? AND ? GROUP BY scene|1|3|3||0|0|45489|45489|3|3|
|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=? AND od.send_time<=? AND od.take_type=?|1|3|3||0|0|261647|261647|0|0|
|v4_coupon|SELECT COUNT(*) AS total FROM v4_coupon.employee_grant_coupon egc JOIN v4_coupon.coupon_put cp ON egc.put_id=cp.id AND cp.tenant_id=? AND cp.tenant_app_id=? JOIN v4_coupon.coupon_put_limit cpl ON cpl.put_id=cp.id AND cpl.tenant_id=? AND cpl.tenant_app_id=? LEFT JOIN v4_coupon.employee_grant_record egr ON egr.employee_grant_id=egc.id AND egr.employee_id=? AND egr.shop_id=? AND (egr.external_user_id=? OR egr.member_id=?) AND egr.tenant_id=? AND egr.tenant_app_id=? WHERE cp.put_scene=? AND cp.status=? AND if(cp.take_effect_way=?,cp.end_time>now(),?) AND (egc.limit_grant_time=? OR (egc.grant_begin_time<=now() AND egc.grant_end_time>now())) AND (cpl.put_quantity>get_quantity OR cpl.put_quantity=?) AND (egc.limit_shop=? OR EXISTS (SELECT ? FROM v4_coupon.employee_grant_shop cs WHERE egc.id=cs.employee_grant_id AND cs.shop_id=? AND cs.tenant_id=? AND cs.tenant_app_id=?)) AND limit_role IN (?) AND egc.tenant_id=? AND egc.tenant_app_id=?|1|1|1||0|0|20767|20767|1|1|
|deliver|SELECT * FROM express_address WHERE user_id=? AND type=?|1|1|1||0|0|12537|12537|0|0|
|mysql|DELETE FROM message_push.message_log WHERE create_time<DATE_SUB(now(),interval ? day)|1|64|64||0|0|2312868|2312868|0|0|
||UPDATE v4_user.member_import SET memorial_day=? WHERE memorial_day=? AND tenant_id=?|1|2|2||0|0|144961|144961|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=? AND tu.tenant_app_id=? AND tu.status=? AND mb.erp_member_id IN|1|1|1||0|0|1222295|1222295|563|563|
|tenant|SELECT t.id AS employeeid,t.tenant_id,t.employee_erp_id AS employeeerpid,t.employee_name AS employeename,t.employee_type_id AS employeetypeid,t.employee_type AS employeetype,t.shop_id,sp.shop_name,t.employee_no AS employeeno,t.sex,t.mobile_no AS mobileno,t.corp_wx_user_id,t.head_img_url AS headimgurl,t.dept_erp_id,ed.dept_name AS dept_erp_name,t.status FROM employee t LEFT JOIN tenant_wechatapp_shop sp ON sp.tenant_id=t.tenant_id AND t.shop_id=sp.id LEFT JOIN tenant.erp_department ed ON ed.tenant_id=t.tenant_id AND ed.dept_erp_id=t.dept_erp_id WHERE t.tenant_id=? AND (t.employee_name LIKE concat(?,?,?) OR t.mobile_no LIKE concat(?,?,?)) AND t.status IN (?) ORDER BY t.id ASC LIMIT ?|1|4|4||0|0|93276|93276|1|1|
|value_added|SELECT ? AS limitDayType,t.tenant_wechatapp_id,t.user_id,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=? AND t.state=? AND t.start_add_time>=date_add(DATE_FORMAT(?,?),interval ?*(t.add_days+t.keeping_days?)day) AND t.start_add_time<date_add(DATE_FORMAT(?,?),interval(?*(t.add_days+t.keeping_days?)+?)day) GROUP BY t.tenant_wechatapp_id,t.user_id,ue.dept_erp_id|1|1|1||0|0|472446|472446|53|53|
|v4_user|SELECT t?.id AS memberId,t?.external_user_id AS externalUserId,t?.corp_user_id AS corpUserId,t?.employee_id,t?.raw_external_user_id AS rawExternalUserId FROM member t? JOIN employee_external_bind t? ON t?.tenant_id=t?.tenant_id AND t?.external_user_id=t?.external_user_id AND t?.tenant_id=? JOIN cwx_external_user t? ON t?.tenant_id=t?.tenant_id AND t?.external_user_id=t?.external_user_id AND t?.tenant_id=? WHERE t?.id IN (?) AND t?.tenant_id=? AND t?.tenant_app_id=?|1|1|1||0|0|19|19|10|10|
||DELETE FROM v4_sales.sjfx_dct_erp_sales_extend? WHERE create_time<?|1|4|4||0|0|614359|614359|0|0|
|goods|SELECT id,img_url,img_index FROM goods_img WHERE goods_id=? ORDER BY update_time DESC|1|1|1||0|0|27610|27610|1|1|
|tenant|SELECT count(*)amount FROM sneak_guest WHERE tenant_app_id=? AND status=? AND create_shop_id=? AND maintain_employee_id=? AND create_time>=?|1|1|1||0|0|1721|1721|1|1|
|account|SELECT count(?) FROM account_flow WHERE ((src_account_type=? AND src_account_id=?) OR (dst_account_type=? AND dst_account_id=?)) AND create_time>=? AND create_time<=? AND oper_type=?|1|1|1||0|0|623|623|1|1|
|tenant|SELECT count(*) FROM (SELECT s.sneak_guest_id FROM tenant.sneak_guest_maintain s JOIN tenant.sneak_guest sg ON sg.id=s.sneak_guest_id AND (sg.fail_type IS ? OR sg.fail_type=?) WHERE s.tenant_id=? AND s.tenant_app_id=? AND s.shop_id=? AND s.create_time BETWEEN ? AND ? AND s.event_type IN (?) GROUP BY s.sneak_guest_id)a|1|1|1||0|0|576|576|1|1|
|tenant|INSERT INTO erp_sales_detail(id,tenant_id,tenant_wechatapp_id,sales_erp_id,sales_index,sales_type,product_barcode,product_name,cert_no,hand_size,category_erp_id,category_name,stone_weight,gold_weight,total_weight,quantity,amount_total,amount_pay,integral,remark) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE key UPDATE update_time=now(),sales_type=?,product_barcode=?,product_name=?,cert_no=?,hand_size=?,category_erp_id=?,category_name=?,stone_weight=?,gold_weight=?,total_weight=?,quantity=?,amount_total=?,amount_pay=?,integral=?,remark=?|1|1|1||0|0|0|0|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? DAY),DATE_ADD(start_add_time,INTERVAL add_days+keeping_days? DAY) FROM value_added_user WHERE keeping_days>? AND state=? AND start_add_time=date_add(CURDATE(),interval ?*(add_days?)day)|1|16|16||0|0|2102360|2102360|964|964|
|tenant|SELECT sum(tt.maintainCount) AS maintainCount,sum(tt.maintainNum) AS maintainNum,sum(tt.successNum) AS successNum,sum(tt.failNum) AS failNum,sum(tt.saleMoney) AS saleMoney FROM (SELECT count(?) AS maintainCount,count(DISTINCT t.sneak_guest_id) AS maintainNum,? AS successNum,? AS failNum,? AS saleMoney FROM tenant.sneak_guest g JOIN tenant.sneak_guest_maintain t ON t.sneak_guest_id=g.id WHERE g.tenant_app_id=? AND (g.fail_type IS ? OR g.fail_type=?) AND t.event_type IN (?) AND t.create_time>=? AND t.create_time<? UNION ALL SELECT ? AS maintainCount,? AS maintainNum,count(sgs.sneak_guest_id) AS successNum,? AS failNum,sum(sgs.`amount`) AS saleMoney FROM tenant.sneak_guest g JOIN tenant.sneak_guest_sales sgs ON g.id=sgs.sneak_guest_id WHERE g.tenant_app_id=? AND sgs.create_time>=? AND sgs.create_time<? UNION ALL SELECT ? AS maintainCount,? AS maintainNum,? AS successNum,count(DISTINCT t.sneak_guest_id) AS failNum,? AS saleMoney FROM tenant.sneak_guest g JOIN tenant.sneak_guest_maintain t ON t.sneak_guest_id=g.id WHERE g.tenant_app_id=? AND g.fail_type=? AND t.event_type IN (?) AND t.create_time>=? AND t.create_time<?)tt|1|3|3||0|0|30130|30130|1|1|
|authorization_service|SELECT id,user_id,tenant_id,tenant_wx_app_id,account_id,login_way,login_code,login_token,roles,status,expire_time,create_time,update_time,login_ip,login_time,login_data,employee_id,shop_id,platform_user_id,wx_user_id,wx_app_user_id FROM user_login_token WHERE wx_user_id=? AND tenant_id=? AND tenant_wx_app_id=? AND login_way=? AND expire_time>now() AND status=? AND user_id=?|1|1|1||0|0|0|0|0|0|
|user_service|INSERT INTO tenant_member_bind(tenant_id,id,tenant_app_id,user_id,wx_user_id,erp_member_id,customer_user_id,wx_union_id,create_time,update_time,external_user_id) VALUES (?,?,?,?,?,?,?,?,?,?,?)|1|1|1||0|0|0|0|0|0|
|coupon_service|SELECT count(?) FROM coupon_service.template t LEFT JOIN coupon_service.template_redpack r ON r.template_id=t.id LEFT JOIN coupon_service.template_activity a ON a.template_id=t.id WHERE t.state!=? AND t.tenant_app_id=? AND (t.tenant_app_id=?)|1|2|2||0|0|22141|22141|1|1|
|corpwx|DELETE FROM corpwx.external_user_bind WHERE tenant_id=?|1|70|70||0|0|42185|42185|0|0|
|export|SELECT count(?) FROM export_log el INNER JOIN export_file ef ON el.tenant_app_id=ef.tenant_app_id AND el.batch_no=ef.batch_no AND el.md5_key=ef.md5_key AND el.export_code=ef.export_code WHERE el.tenant_app_id=? AND el.employee_id=? AND (el.batch_no BETWEEN ? AND ?) AND ef.export_code IN (?)|1|1|1||0|0|62637|62637|1|1|
|user_service|SELECT count(?) 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 WHERE ue.employee_id=? AND ue.tenant_id=? AND ue.tenant_wechatapp_id=? AND ue.shop_id=?|1|1|1||0|0|13522|13522|1|1|
|order|SELECT max(create_time) FROM `order`.order_operator_log WHERE tenant_wechatapp_id=? AND order_id=?|1|8|8||0|0|1084033|1084033|1|1|
|v4_sales|SELECT id,template_id,no,member_id,erp_sales_id,product_barcode,product_name,dept_id,amount_total,amount_pay,added_amount,added_rate,added_days,keep_days,impairment_rate,exchange_days,added_time,status,coupon_id,tenant_id,tenant_app_id,create_time,update_time FROM value_added WHERE (member_id=? AND status<>?) AND tenant_id=? AND tenant_app_id=?|1|1|1||0|0|6285|6285|1|1|
|goods|SELECT count(?) FROM (SELECT gs.id,gs.category_id,gs.goods_name,gs.style_no,gs.status,gs.thumbnail_img,gs.express_type,gs.take_stock_day,gs.take_remark,gs.express_fee,ifnull(gs.base_sale_number,?)+ifnull(t?.sales_volume,?)total_sales_volume,ifnull(ifnull(t?.quantity,t?.quantity),?)total_quantity,ifnull(ifnull(t?.price,t?.price),?)min_price,gs.create_time,gs.exchange_money,ifnull(t?.number,?)skuNumber,ifnull(t?.number,?)activitySkuNumber FROM goods.goods gs LEFT JOIN goods.goods_category cg ON gs.category_id=cg.id INNER JOIN goods.goods_up_app t ON gs.id=t.goods_id AND t.tenant_app_id=? LEFT JOIN (SELECT tenant_app_id,goods_id,sum(sales_volume)sales_volume FROM goods.goods_sku GROUP BY tenant_app_id,goods_id)t? ON t.tenant_app_id=t?.tenant_app_id AND t.goods_id=t?.goods_id LEFT JOIN (SELECT tenant_app_id,goods_id,sum(quantity)quantity,min(price)price,count(*)number FROM goods.goods_sku WHERE activity_id=? GROUP BY tenant_app_id,goods_id)t? ON t.tenant_app_id=t?.tenant_app_id AND t.goods_id=t?.goods_id LEFT JOIN (SELECT tenant_app_id,goods_id,sum(quantity)quantity,min(price)price,count(*)number FROM goods.goods_sku WHERE activity_id>? GROUP BY tenant_app_id,goods_id)t? ON t.tenant_app_id=t?.tenant_app_id AND t.goods_id=t?.goods_id WHERE ?=? AND gs.topping=?)tmp|1|1|1||0|0|129260|129260|1|1|
|gift_mail|SELECT p.id,p.product_name,p.tag_price,i.volume,p.product_status AS status,p.default_image_url,i.quantity,i.market_price,if(prp.id IS ?,?,?) AS hasRecommend FROM gift_mail.platform_product p JOIN gift_mail.platform_inventory i ON i.product_id=p.id LEFT JOIN gift_mail.platform_recommend_product prp ON prp.tenant_app_id=? AND prp.is_recommend=? AND prp.platform_product_id=p.id WHERE prp.id IS ? AND p.product_status=? ORDER BY p.tag_price ASC ,p.id DESC LIMIT ?,?|1|1|1||0|0|9159|9159|6|6|
|warranty_service|SELECT * FROM warranty_data WHERE id=?|1|1|1||0|0|1|1|1|1|
|v4_user|SELECT pc.id,count(*) AS maintainCount FROM potential_customer pc JOIN potential_customer_maintain pcm ON pc.id=pcm.potential_customer_id AND pcm.tenant_id=? AND pcm.tenant_app_id=? WHERE pc.maintain_shop_id=? AND pc.status=? AND pcm.event_type IN (?) AND pc.finish_time>=? AND pc.finish_time<? AND pc.tenant_id=? AND pc.tenant_app_id=? GROUP BY pc.id|1|2|2||0|0|1865|1865|5|5|
|value_added|UPDATE value_added_user SET amount_added=IF(?>(((added_percent_per_day/?)*IF(?>=TIMESTAMPDIFF(DAY,DATE_FORMAT(start_add_time,?),CURRENT_DATE)+?-add_days,TIMESTAMPDIFF(DAY,DATE_FORMAT(start_add_time,?),CURRENT_DATE)+?,add_days))-((devalue_percent_per_day/?)*IF(?>=TIMESTAMPDIFF(DAY,DATE_FORMAT(start_add_time,?),CURRENT_DATE)+?-add_days-keeping_days,?,TIMESTAMPDIFF(DAY,DATE_FORMAT(start_add_time,?),CURRENT_DATE)+?-add_days-keeping_days)))*amount_pay,?,(((added_percent_per_day/?)*IF(?>=TIMESTAMPDIFF(DAY,DATE_FORMAT(start_add_time,?),CURRENT_DATE)+?-add_days,TIMESTAMPDIFF(DAY,DATE_FORMAT(start_add_time,?),CURRENT_DATE)+?,add_days))-((devalue_percent_per_day/?)*IF(?>=TIMESTAMPDIFF(DAY,DATE_FORMAT(start_add_time,?),CURRENT_DATE)+?-add_days-keeping_days,?,TIMESTAMPDIFF(DAY,DATE_FORMAT(start_add_time,?),CURRENT_DATE)+?-add_days-keeping_days)))*amount_pay),update_time=now() WHERE state=? AND update_time<=CURDATE() AND (start_add_time>=DATE_ADD(CURDATE(),INTERVAL-(add_days+keeping_days-?)DAY) OR (amount_added>? AND start_add_time<DATE_ADD(CURDATE(),INTERVAL-(add_days+keeping_days-?)DAY)))|1|19|19||0|0|2102357|2102357|0|0|
|v4_sales|SELECT COUNT(*) AS total FROM v4_sales.erp_sales es LEFT JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE is_sales=? AND sales_status=? AND (es.sales_no LIKE concat(?,?) OR es.member_erp_id=?) AND w.id IS NOT ? AND es.tenant_id=? AND es.tenant_app_id=?|1|3|3||0|0|120864|120864|1|1|
|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? DAY),DATE_ADD(start_add_time,INTERVAL add_days+keeping_days? DAY) FROM value_added_user WHERE state=? AND start_add_time=date_add(CURDATE(),interval ?*(add_days+keeping_days?)day)|1|3|3||0|0|2102360|2102360|811|811|
|v4_user|SELECT id,checkin_employee_name,maintain_employee_name FROM potential_customer WHERE ((member_id=?) AND status IN (?)) AND tenant_id=? AND tenant_app_id=? ORDER BY id ASC|1|2|2||0|0|6238|6238|0|0|
|user_service|SELECT tenant_id,id,tenant_app_id,user_id,wx_user_id,erp_member_id,customer_user_id,wx_union_id,create_time,update_time,external_user_id FROM tenant_member_bind WHERE (tenant_id=? AND tenant_app_id=? AND user_id IN|1|1|1||0|0|6761|6761|6761|6761|
||DELETE FROM v4_user.sjfx_dct_member_grade WHERE create_time<?|1|1|1||0|0|291236|291236|0|0|
|warranty_service|INSERT INTO warranty_data(id,warranty_data,create_time,update_time) VALUES (?,?,now(),now())|1|1|1||0|0|0|0|0|0|
||UPDATE v4_user.member_import SET birthday=? WHERE birthday=? AND tenant_id=?|1|1|1||0|0|144961|144961|0|0|
||LOAD DATA LOCAL INFILE ? REPLACE INTO TABLE v4_user.member_import CHARACTER SET utf8mb4 FIELDS TERMINATED BY ?(@type,tenant_id,tenant_app_id,shop_id,mobile_no,member_name,sex,birthday,birthday_is_lunar,memorial_name,memorial_day,address,point_balance,total_sale_point,butler_employee_mobile_no,register_time) SET update_time=now()|1|1|1||0|0|0|0|0|0|
|v4_sales|SELECT COUNT(*) AS total FROM comment WHERE (order_id=? AND member_id=?) AND tenant_id=? AND tenant_app_id=?|1|1|1||0|0|60304|60304|1|1|
|coupon_service|SELECT tenant_id,tenant_app_id,employee_id,count(DISTINCT user_id) AS count FROM coupon_service.coupon_expire_task WHERE tenant_id=? AND tenant_app_id=? AND status=? AND expire_time>now() AND expire_time BETWEEN ? AND ? GROUP BY tenant_id,tenant_app_id,employee_id|1|7|7||0|0|176756|176756|33|33|
|corpwx|UPDATE user_service.tenant_member_bind SET external_user_id=?,update_time=now() WHERE tenant_id=? AND external_user_id IS NOT ?|1|15|15||0|0|127081|127081|0|0|
||DELETE FROM tenant.sjfx_dct_erp_sales_detail WHERE create_time<?|1|1|1||0|0|180222|180222|0|0|
|v4_sales|SELECT count(DISTINCT es.id) FROM v4_sales.warranty_can_added wca JOIN v4_sales.erp_sales es ON wca.sales_id=es.id AND es.tenant_id=? AND es.tenant_app_id=? LEFT JOIN v4_sales.warranty w ON w.sales_id=wca.sales_id AND w.tenant_id=? AND w.tenant_app_id=? WHERE es.is_sales=? AND es.sales_status=? AND sales_date BETWEEN ? AND ? AND w.id IS ? AND wca.tenant_id=? AND wca.tenant_app_id=?|1|1|1||0|0|124444|124444|1|1|
|v4_sales|SELECT erp_employee_id FROM comment WHERE erp_dept_id=? AND create_time BETWEEN ? AND ? AND tenant_id=? AND tenant_app_id=? GROUP BY erp_employee_id|1|1|1||0|0|60305|60305|0|0|
|goods|DELETE FROM goods_img WHERE tenant_id=? AND goods_id=?|1|2|2||0|0|27595|27595|0|0|
|v4_sales|SELECT id,sales_id,status,tenant_id,tenant_app_id,create_time,update_time FROM comment_not_remind_sales WHERE (status=?)|1|1|1||0|0|117131|117131|321|321|
|coupon_service|SELECT id,tenant_id,tenant_app_id,template_id,coupon_id,give_user_id,user_id,create_time,update_time FROM user_coupon_give_record WHERE (tenant_id=? AND tenant_app_id=? AND coupon_id=? AND give_user_id=? AND user_id=?)|1|1|1||0|0|1709|1709|0|0|
|user_service|SELECT count(*) FROM user_service.tenant_member_info t WHERE t.tenant_id=? AND t.tenant_app_id=? AND t.shop_id=?|1|1|1||0|0|17479|17479|1|1|
|coupon_service|SELECT count(?) FROM coupon_service.coupon cu JOIN coupon_service.coupon_extend ce ON ce.tenant_id=? AND ce.tenant_app_id=? AND ce.id=cu.id WHERE cu.tenant_id=? AND cu.tenant_app_id=? AND (cu.coupon_state=? OR (cu.coupon_state=? AND ce.writeoff_time IS NOT ?)) AND cu.create_time>=? AND cu.create_time<=? AND cu.template_id=? AND cu.source=?|1|2|2||0|0|23277|23277|1|1|
|v4_sales|SELECT count(DISTINCT es.id) FROM v4_sales.erp_sales es JOIN v4_sales.warranty w ON w.sales_id=es.id AND w.tenant_id=? AND w.tenant_app_id=? WHERE sales_status=? AND sales_date BETWEEN ? AND ? AND es.tenant_id=? AND es.tenant_app_id=?|1|1|1||0|0|206823|206823|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=? AND od.receive_time<=?|1|3|3||0|0|261694|261694|47|47|
|coupon_service|SELECT * FROM coupon_service.coupon WHERE DATEDIFF(DATE_FORMAT(end_time,?),DATE_FORMAT(now(),?))=? AND coupon_state IN(?)|1|162|162||0|0|11896892|11896892|15868|15868|
|v4_sales|SELECT COUNT(*) FROM (SELECT c.order_id,c.id AS commentId,c.create_time AS commentTime,c.member_id,c.average_score average,if(c.average_score<c.low_score AND ?=?,?,?)hasHandle,if(cls.id IS ?,?,?)handleLowScore FROM v4_sales.comment c LEFT JOIN v4_sales.comment_low_score_handle cls ON cls.comment_id=c.id AND cls.tenant_id=? AND cls.tenant_app_id=? WHERE c.erp_dept_id=? AND c.create_time BETWEEN ? AND ? AND c.average_score<c.low_score AND cls.id IS ? AND c.tenant_id=? AND c.tenant_app_id=?)TOTAL|1|1|1||0|0|60305|60305|1|1|
|mysql|DELETE FROM wx_gateway.wx_template_msg WHERE create_time<DATE_SUB(now(),interval ? day)|1|26|26||0|0|710368|710368|0|0|
|authorization_service|SELECT ar.tenant_id,ar.tenant_app_id,a.employee_id,ar.shop_id,ar.role_code,ar.role_name,a.status AS account_status,ar.status AS role_status FROM authorization_service.account_role? ar JOIN authorization_service.account a ON ar.account_id=a.id WHERE ar.tenant_id=? AND ar.tenant_app_id=? AND ar.role_code IN (?)|1|1|1||0|0|65797|65797|0|0|
|gift_mail|SELECT count(?) FROM (SELECT p.*,sp.take_type,ifnull(pp.integral_price,ifnull((SELECT min(inventory.price) FROM inventory WHERE inventory.product_id=p.id),?)) AS price,ifnull(t.quantity,?)quantity,pt.partner_name vendorName,? distance,c.categroy_name categroy_name,pp.partner_id FROM product p INNER JOIN category c ON c.id=p.category_id LEFT OUTER JOIN self_product sp ON p.id=sp.product_id LEFT OUTER JOIN partner_product pp ON p.id=pp.product_id LEFT OUTER JOIN partner pt ON pt.id=pp.partner_id LEFT OUTER JOIN (SELECT product_id,sum(quantity)quantity FROM gift_mail.inventory GROUP BY product_id)t ON p.id=t.product_id WHERE ((p.is_disable IS ? OR p.is_disable=?))) AS p LEFT OUTER JOIN product_status ps ON p.id=ps.product_id AND ps.tenant_wechatapp_id=? WHERE (p.tenant_id=? AND p.product_type=? AND (ps.id IS NOT ? OR p.tenant_wechatapp_id=?))|1|3|3||0|0|54456|54456|1|1|
|employee|UPDATE backlog_? SET status=?,finish_time=now() WHERE tenant_app_id=? AND employee_id=? AND status IN (?) AND shop_id=?|1|1|1||0|0|2296|2296|0|0|
|user_service|INSERT INTO erp_integral_log(id,tenant_id,tenant_wechatapp_id,integral_erp_id,member_erp_id,note_erp_id,remark,integral,erp_create_time,create_time,update_time,busi_type,busi_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE key UPDATE update_time=now()|1|1|1||0|0|0|0|0|0|
|corpwx|DELETE FROM corpwx.external_user WHERE tenant_id=?|1|23|23||0|0|52150|52150|0|0|
|gift_mail|SELECT p.id,product_name,default_image_url,tag_price,product_status,(SELECT ifnull(MIN(price),?) FROM gift_mail.inventory WHERE product_id=p.id)price,if(product_type=?,?,ifnull(i.quantity,?))quantity,ifnull(i.volume,?)volume FROM gift_mail.product p LEFT OUTER JOIN (SELECT sum(quantity)quantity,sum(volume)volume,product_id FROM gift_mail.inventory GROUP BY product_id)i ON i.product_id=p.id WHERE (p.id IN (?))|1|1|1||0|0|8333|8333|1|1|
|v4_user|SELECT id FROM member_points_detail WHERE (member_points_id=? AND oper_biz_id=? AND oper_biz_type=? AND status=?) AND tenant_id=? AND tenant_app_id=? LIMIT ?|1|1|1||0|0|1313|1313|0|0|
|employee|SELECT employee_id FROM employee.backlog_? WHERE tenant_id=? AND tenant_app_id=? AND shop_id=? AND status=? AND finish_time BETWEEN ? AND ? GROUP BY employee_id|1|3|3||0|0|45483|45483|10|10|
||UPDATE v4_user.member_import SET butler_employee_mobile_no=? WHERE butler_employee_mobile_no=? AND tenant_id=?|1|1|1||0|0|144961|144961|0|0|
|v4_employee|SELECT COUNT(*) AS total FROM task_task WHERE (task_template_id=?) AND tenant_id=? AND tenant_app_id=?|1|1|1||0|0|14689|14689|1|1|
|v4_user|SELECT COUNT(*) AS total FROM member_import WHERE (tenant_id=? AND import_status=?) AND tenant_id=?|1|1|1||0|0|144961|144961|1|1|
|v4_employee|SELECT LEFT(start_time,?) AS day,count(*) AS undo_count,datediff(end_time,?) AS left_days FROM task_task WHERE task_type=? AND status=? AND system_task_type=? AND finish_time IS ? AND end_time>? AND shop_id=? AND tenant_id=? AND tenant_app_id=? GROUP BY LEFT(start_time,?),end_time|1|1|1||0|0|88430|88430|0|0|
