|数据库名称|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=?|645|1017|4||0|0|3150028|28606|645|1|
|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 ?|143|318|6||0|0|2677616|40685|143|1|
|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|141|225|5||0|0|242570|2132|107008|972|
|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|135|200|3||0|0|588353|8073|238|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=? AND tu.tenant_app_id=? AND tu.status=? AND mb.erp_member_id IN (?)|85|210|7||0|0|35950278|1432249|4163|270|
|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=?|79|136|5||0|0|474832|16878|79|1|
|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=?|60|69|6||0|0|151005428|2520049|0|0|
|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=?|43|61|2||0|0|312347|15556|43|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|57|2||0|0|151605|6502|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=?|43|60|2||0|0|282881|13561|43|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=?|30|93|8||0|0|663783|45148|30|1|
|corpwx|UPDATE external_user SET un_assign_flag=? WHERE (tenant_id=? AND status=? AND un_assign_flag=?)|27|101|9||0|0|780554|77310|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=?|24|36|2||0|0|18560|861|8872|410|
|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 ?|23|107|21||0|0|6652788|744288|5|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(),?)|18|258|30||0|0|3892113|451203|2306|300|
|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|33|5||0|0|218541|15679|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 ?|16|26|6||0|0|6461124|403840|16|1|
|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|14|36|3||0|0|113676|8718|8|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=?|12|35|5||0|0|2008102|372997|12|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=?|12|91|28||0|0|921686|100922|12|1|
|order|SELECT max(create_time) FROM `order`.order_operator_log WHERE tenant_wechatapp_id=? AND order_id=?|11|74|14||0|0|12109733|1100966|11|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=? OR external_user_id=?) AND status IN (?)) AND tenant_id=? AND tenant_app_id=?|10|33|4||0|0|87120|8717|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.tenant_id=? AND t.tenant_app_id=?|9|15|3||0|0|128953|32976|9|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 ?|8|18|4||0|0|347280|54281|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 NOT ? AND es.tenant_id=? AND es.tenant_app_id=?|8|12|2||0|0|37120|7172|8|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 ?|7|10|2||0|0|59514|12226|70|10|
|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=?)|7|8|1||0|0|27725|3965|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()|6|12|6||0|0|3349068|1102441|0|0|
|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|6|6|1||0|0|39362|10014|19612|5007|
|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|9|2||0|0|120996|54695|6|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(?,?,?))|6|6|1||0|0|23656|6284|6|1|
|tenant|SELECT count(*)amount FROM sneak_guest WHERE tenant_app_id=? AND status=? AND create_shop_id=? AND create_time<=?|5|6|1||0|0|18801|4105|5|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|5|21|5||0|0|2879949|576007|6|2|
|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|15|8||0|0|1374225|474720|255|180|
|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=?|5|9|2||0|0|143966|45002|5|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=?|5|6|2||0|0|10922|2430|0|0|
|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|5|6|1||0|0|37602|8210|18801|4105|
|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=?|4|4|1||0|0|239085|186843|4|1|
|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|4|53|25||0|0|160782|70221|58|30|
|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=?|4|11|4||0|0|346814|125576|4|1|
|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|4|53|25||0|0|165774|72327|1722|711|
|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|24|8||0|0|2096392|524098|15|5|
|authorization_service|UPDATE user_login_token SET status=? WHERE login_token IN|4|11|5||0|0|9076|4571|0|0|
|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|21|7||0|0|100528|40684|4|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=? OR external_user_id=?) AND status IN (?) AND maintain_shop_id=?) AND tenant_id=? AND tenant_app_id=?|4|4|1||0|0|9683|2424|1|1|
|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 ?|4|6|2||0|0|2092225|647535|4|1|
|v4_sales|SELECT COUNT(*) AS total FROM value_added_record WHERE (value_added_id=?) AND tenant_id=? AND tenant_app_id=?|4|35|10||0|0|10085448|2521362|4|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|3|1||0|0|1002|406|3|1|
|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 ?|3|7|2||0|0|1942221|647557|5|2|
|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 ?|3|3|1||0|0|42856|14286|0|0|
|warranty_service|SELECT count(*) FROM warranty WHERE user_id=? AND tenant_wechatapp_id=? AND is_disable=?|3|24|10||0|0|39432|17019|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|1||0|0|18834|8492|9417|4246|
|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|3|3|1||0|0|4817|2033|3|1|
|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=?|3|10|5||0|0|100787|41267|3|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=?)|3|3|1||0|0|160680|61113|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|8|3||0|0|126654|42218|3|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=?|3|6|3||0|0|5609|3221|3|1|
|v4_sales|SELECT id,sales_erp_id,sales_no,sales_date,member_erp_id,employee_erp_id,employee_name,assist_employee_erp_id,assist_employee_name,dept_erp_id,amount,sales_remark,receipts,sales_status,is_sales,busi_date,erp_create_time,recommend_id,post_time,tenant_id,tenant_app_id,create_time,update_time FROM erp_sales WHERE (sales_no=?) AND tenant_id=? AND tenant_app_id=?|3|5|2||0|0|717095|334567|3|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|3|9|5||0|0|87691|51358|14|7|
|user_service|SELECT * FROM user_employee WHERE tenant_wechatapp_id=? AND employee_id=?|3|3|1||0|0|120307|113883|13058|6634|
|coupon_service|SELECT * FROM coupon_service.coupon_can_give WHERE coupon_id=? LIMIT ?|3|4|1||0|0|971438|337162|3|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|3|11|8||0|0|19399|9395|610|340|
|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=? AND dt.product_name LIKE concat(?,?,?)|3|15|6||0|0|374159|124857|3|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|2|2|1||0|0|2219920|1846898|2|1|
|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|38|19||0|0|2225401|1122731|224|112|
|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=?))|2|2|1||0|0|44390|22198|0|0|
|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=?|2|2|1||0|0|2867|1539|497|254|
|erp_app|INSERT INTO app_status(id,tenant_id,app_name,version,pid) VALUES (?,?,?,?,?) ON DUPLICATE key UPDATE version=?,pid=?,online_status_time=?|2|2|1||0|0|0|0|0|0|
|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=?|2|2|1||0|0|226761|186843|2|1|
|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=?|2|4|2||0|0|21114|10557|0|0|
|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=?|2|5|2||0|0|81506|56767|2|1|
|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=?)|2|5|3||0|0|7040|4571|7040|4571|
|employee|UPDATE backlog_? SET status=?,finish_time=now() WHERE tenant_app_id=? AND employee_id=? AND status IN (?) AND shop_id=?|2|2|1||0|0|4292|2978|0|0|
|employee|UPDATE backlog_system SET status=?,finish_time=now() WHERE tenant_app_id=? AND scene=?|2|15|13||0|0|1639217|1448937|0|0|
||SELECT wx_app_id,count(*) AS c FROM user_service.wx_user WHERE wx_app_id IN(?) GROUP BY wx_app_id|2|12|6||0|0|26354|13177|4|2|
|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=?|2|2|1||0|0|102959|75501|2|1|
|v4_user|SELECT id FROM potential_customer WHERE (status IN (?) AND next_maintain_time<?) AND tenant_id=? AND tenant_app_id=?|2|4|3||0|0|15753|8716|968|550|
|erp_app|COMMIT ?|2|3|1||0|0|0|0|0|0|
|v4_user|SELECT maintain_employee_id,id FROM potential_customer WHERE (maintain_shop_id=? AND status IN (?)) AND tenant_id=? AND tenant_app_id=?|2|2|1||0|0|3740|2429|685|662|
|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=?|2|4|2||0|0|304306|152157|2|1|
|employee|SELECT bg.id,bg.employee_id,bg.shop_id,bg.scene,bg.status,bg.create_time,bg.begin_time,bg.expire_time,bg.member_user_name,bg.mobile_no member_mobile_no FROM employee.backlog_? bg WHERE bg.tenant_app_id=? AND bg.scene NOT IN(?) AND bg.expire_time BETWEEN ? AND ? AND bg.shop_id=? AND bg.status IN (?) AND bg.leave_flag=? ORDER BY id DESC LIMIT ?|2|10|5||0|0|1048196|524098|10|5|
|gift_mail|SELECT count(*) FROM gift_mail.trade t WHERE t.tenant_wechatapp_id=? AND t.trade_type=? AND t.order_status=?|2|4|2||0|0|18569|9285|2|1|
|v4_employee|SELECT * FROM v4_user.member WHERE mobile_no=?|1|28|28||0|0|4138077|4138077|1|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=? AND (t?.mobile_no LIKE concat(?,?) OR t?.user_name LIKE concat(?,?,?))|1|1|1||0|0|482567|482567|1|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 tenant_id=? AND tenant_app_id=?|1|1|1||0|0|754|754|0|0|
|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(?)|1|1|1||0|0|1084|1084|1|1|
|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=?|1|1|1||0|0|2488|2488|2|2|
|mysql|DELETE FROM wx_gateway.wx_template_msg WHERE create_time<DATE_SUB(now(),interval ? day)|1|23|23||0|0|648106|648106|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 state=? AND start_add_time=date_add(CURDATE(),interval ?*(add_days+keeping_days?)day)|1|2|2||0|0|2115288|2115288|606|606|
|coupon_service|SELECT * FROM coupon_service.coupon WHERE DATEDIFF(DATE_FORMAT(end_time,?),DATE_FORMAT(now(),?))=? AND coupon_state IN(?)|1|119|119||0|0|12023765|12023765|861|861|
|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=?|1|1|1||0|0|3273|3273|1|1|
|erp_sync|UPDATE retry_data SET tenant_id=?,tenant_app_id=?,business_type=?,operation_type=?,data_id=?,user_id=?,need_erp_member_id=?,retry_times=?,msg=?,send_time=?,create_time=?,update_time=?,data=? WHERE id=?|1|1|1||0|0|1|1|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|14|14||0|0|2115287|2115287|662|662|
|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 ?|1|1|1||0|0|147548|147548|1|1|
|user_service|SELECT tenant_id,id,tenant_app_id,user_id,mobile_no,user_name,head_img_url,sex,status,create_time,update_time FROM tenant_member WHERE (tenant_id=? AND tenant_app_id=? AND user_name LIKE ?)|1|1|1||0|0|2394|2394|2393|2393|
|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=? AND (od.mobile_no=? OR ad.mobile_no=?)|1|1|1||0|0|186864|186864|1|1|
|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|1|3|3||0|0|7657|7657|10|10|
|warranty_service|UPDATE warranty SET upload_frequency=? WHERE id=?|1|1|1||0|0|1|1|0|0|
|mysql|DELETE FROM message_push.message_log WHERE create_time<DATE_SUB(now(),interval ? day)|1|92|92||0|0|3202109|3202109|0|0|
||DELETE FROM tenant.sjfx_dct_erp_sales_detail WHERE create_time<?|1|1|1||0|0|180766|180766|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=?|1|1|1||0|0|1311|1311|23|23|
|v4_user|SELECT td?.added,td?.dealed,td?.failed,td?.maintain FROM (SELECT count(DISTINCT CASE WHEN t.event_type=? THEN t.potential_customer_id ELSE ? END) AS dealed,count(DISTINCT CASE WHEN t.event_type=? THEN t.potential_customer_id ELSE ? END) AS failed FROM potential_customer_maintain t WHERE t.create_time>=? AND t.create_time<=? AND t.event_type IN (?) AND t.tenant_app_id=?)td?,(SELECT count(DISTINCT t?.potential_customer_id) AS added FROM potential_customer_maintain t? LEFT JOIN potential_customer_maintain t? ON t?.potential_customer_id=t?.potential_customer_id AND t?.create_time>=? AND t?.create_time<=? AND t?.event_type IN (?) AND t?.tenant_app_id=? WHERE t?.create_time>=? AND t?.create_time<=? AND t?.event_type=? AND t?.id IS ? AND t?.tenant_app_id=?)td?,(SELECT count(DISTINCT t?.potential_customer_id) AS maintain FROM potential_customer_maintain t? LEFT JOIN potential_customer_maintain t? ON t?.potential_customer_id=t?.potential_customer_id AND t?.create_time>=? AND t?.create_time<=? AND t?.event_type IN (?) AND t?.tenant_app_id=? WHERE t?.create_time>=? AND t?.create_time<=? AND t?.event_type=? AND t?.id IS ? AND t?.tenant_app_id=?)td?|1|1|1||0|0|13410|13410|1|1|
|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|125098|125098|344|344|
|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|266144|266144|103|103|
|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|6|6||0|0|196590|196590|22|22|
|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.employee_id=? AND t.tenant_id=? AND t.tenant_app_id=?|1|1|1||0|0|2176|2176|1|1|
|order|SELECT id,tenant_id,tenant_wechatapp_id,order_id,user_id,user_name,shop_id,shop_name,operator_type,src_status,dst_status,full_message,remark,create_time,update_time,src_child_status,dst_child_status FROM order_operator_log WHERE tenant_wechatapp_id=? AND order_id=? AND dst_status=? ORDER BY create_time DESC|1|1|1||0|0|1100954|1100954|1|1|
|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|18|18||0|0|2115285|2115285|0|0|
|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=? AND dt.product_name LIKE concat(?,?,?)|1|4|4||0|0|124649|124649|1|1|
|employee|UPDATE backlog_? SET leave_flag=? WHERE tenant_app_id=? AND employee_id=?|1|1|1||0|0|2755|2755|0|0|
|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.activity_id activityId,od.tenant_id tenantId,od.user_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|6|6||0|0|267051|267051|504|504|
|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|475032|475032|59|59|
|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|266041|266041|0|0|
|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|1|1|1||0|0|93681|93681|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|1465|1465|0|0|
|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|1|1|1||0|0|65954|65954|1|1|
|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=? AND (od.mobile_no=? OR ad.mobile_no=?)|1|1|1||0|0|186864|186864|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,ad.user_name receiveName,ad.mobile_no mobileNo,ad.shop_name shopName,ad.address,ad.express_no expressNo,ad.express_company expressCompany,od.user_name userName,od.update_time updateTime,od.child_status childStatus,od.finish_type finishType,od.receive_time receiveTime,od.user_id userId,od.mobile_no buyMobileNo,od.edit_fee_flag editFeeFlag,dt.spec spec,od.source,od.take_shop_id,od.take_shop_name,od.take_employee_user_id,od.take_employee_user_name,od.activity_type,od.activity_id,od.offline_payment_fee,od.online_wait_fee,od.offline_wait_fee,od.pay_way,od.take_employee_id,od.pay_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.tenant_id=? AND od.tenant_wechatapp_id=? AND (od.mobile_no=? OR ad.mobile_no=?) AND (od.status=?) ORDER BY od.create_time DESC LIMIT ?|1|2|2||0|0|148670|148670|1|1|
|gift_mail|SELECT count(?) FROM gift_mail.trade t LEFT OUTER JOIN gift_mail.product p ON p.id=t.product_id LEFT OUTER JOIN gift_mail.trade_take tt ON tt.trade_id=t.id WHERE (t.tenant_wechatapp_id=? AND t.trade_type=? AND t.order_status=?)|1|1|1||0|0|10998|10998|1|1|
|user_service|SELECT t.user_id FROM user_service.tenant_member_bind t JOIN user_service.tenant_member m ON t.tenant_id=m.tenant_id AND t.tenant_app_id=m.tenant_app_id AND t.user_id=m.user_id WHERE t.tenant_id=? AND t.tenant_app_id=? AND t.erp_member_id IS ?|1|1|1||0|0|338|338|169|169|
|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=? AND (od.mobile_no=? OR ad.mobile_no=?) AND (od.status=?)|1|2|2||0|0|129567|129567|1|1|
|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 a.employee_id IN (?)|1|1|1||0|0|66300|66300|31|31|
|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 ?|1|1|1||0|0|8882|8882|6|6|
|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 ?|1|1|1||0|0|4435|4435|10|10|
|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|1|1|1||0|0|431112|431112|1|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=?|1|1|1||0|0|47052|47052|1|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 ?|1|1|1||0|0|18817|18817|9395|9395|
|order|SELECT id FROM order_operator_log WHERE tenant_wechatapp_id=? AND order_id=? AND (src_child_status=? AND dst_child_status=?) ORDER BY create_time DESC LIMIT ?|1|6|6||0|0|1100888|1100888|0|0|
|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|4850|4850|5|5|
|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|4|4||0|0|431112|431112|18822|18822|
|v4_user|SELECT td?.shop_id AS shopId,ifnull(td?.added,?) AS added,ifnull(td?.dealed,?) AS dealed,ifnull(td?.failed,?) AS failed,ifnull(td?.maintain,?) AS maintain FROM (SELECT DISTINCT t.maintain_shop_id AS shop_id FROM potential_customer_maintain t WHERE t.create_time>=? AND t.create_time<=? AND t.event_type IN (?) AND t.tenant_app_id=?)td? LEFT JOIN (SELECT t.maintain_shop_id AS shop_id,count(DISTINCT CASE WHEN t.event_type=? THEN t.potential_customer_id ELSE ? END) AS dealed,count(DISTINCT CASE WHEN t.event_type=? THEN t.potential_customer_id ELSE ? END) AS failed FROM potential_customer_maintain t WHERE t.create_time>=? AND t.create_time<=? AND t.event_type IN (?) AND t.tenant_app_id=? GROUP BY t.maintain_shop_id)td? ON td?.shop_id=td?.shop_id LEFT JOIN (SELECT t?.maintain_shop_id AS shop_id,count(DISTINCT t?.potential_customer_id) AS added FROM potential_customer_maintain t? LEFT JOIN potential_customer_maintain t? ON t?.potential_customer_id=t?.potential_customer_id AND t?.create_time>=? AND t?.create_time<=? AND t?.event_type IN (?) AND t?.tenant_app_id=? WHERE t?.create_time>=? AND t?.create_time<=? AND t?.event_type=? AND t?.id IS ? AND t?.tenant_app_id=? GROUP BY t?.maintain_shop_id)td? ON td?.shop_id=td?.shop_id LEFT JOIN (SELECT t?.maintain_shop_id AS shop_id,count(DISTINCT t?.potential_customer_id) AS maintain FROM potential_customer_maintain t? LEFT JOIN potential_customer_maintain t? ON t?.potential_customer_id=t?.potential_customer_id AND t?.create_time>=? AND t?.create_time<=? AND t?.event_type IN (?) AND t?.tenant_app_id=? WHERE t?.create_time>=? AND t?.create_time<=? AND t?.event_type=? AND t?.id IS ? AND t?.tenant_app_id=? GROUP BY t?.maintain_shop_id)td? ON td?.shop_id=td?.shop_id|1|1|1||0|0|21887|21887|15|15|
