|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|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 ?|194|497|17||0|0|2913913|38122|194|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, '%Y-%m-%d') >= ?) AND w.id IS NULL AND es.tenant_id = ? AND es.tenant_app_id = ?|158|288|8||0|0|608750|28306|158|1|
|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 < ?|106|563|21||0|0|12199168|115087|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|86|143|7||0|0|171416|2337|75891|1056|
|user_service|SELECT tu.user_id, tm.shop_id, mb.erp_member_id AS 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 (?)|86|214|10||0|0|33966536|1329757|4384|200|
|user_service|SELECT count(0) FROM user_service.tenant_member t1 JOIN user_service.tenant_member_info t2 ON t1.tenant_id = t2.tenant_id AND t1.id = t2.id AND t2.tenant_app_id = ? AND t2.shop_id = ? JOIN user_service.user_employee ue ON t1.tenant_id = ue.tenant_id AND t1.tenant_app_id = ue.tenant_wechatapp_id AND t1.user_id = ue.user_id AND ue.employee_id = ? AND ue.shop_id = ? WHERE t1.tenant_id = ? AND t1.tenant_app_id = ?|83|154|11||0|0|591414|14949|83|1|
|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 > ?|66|215|9||0|0|11587558|175570|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 = ?|65|120|4||0|0|406016|15439|65|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 = ?|62|114|4||0|0|356871|15407|62|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 NULL 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|56|88|3||0|0|147469|6697|121|5|
|user_service|SELECT * FROM user_service.user_employee WHERE employee_erp_id = ? AND tenant_id = ? AND tenant_wechatapp_id = ? AND date_format(update_time, '%Y-%m-%d %H') = date_format(now(), '%Y-%m-%d %H')|39|1082|64||0|0|2842186|219428|10647|1420|
|v4_sales|SELECT ifnull(sum(integral), ?) AS 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 = ?|35|96|6||0|0|526651|34725|35|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 = ?|34|86|13||0|0|254887|7738|5|1|
|v4_employee|SELECT sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙1店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙2店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙3店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙4店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙5店` , sum(ifnull(shop_id = ?, ?)) AS `shop|德阳老庙1店` , sum(ifnull(member_integral_total <= ?, ?)) AS `integral_total|2000分以下` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|2001-10000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|10001-50000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|50001-99999分` , sum(ifnull(member_integral_total >= ?, ?)) AS `integral_total|100000分以上` , sum(ifnull(member_sales_amount <= ?, ?)) AS `amount_total_consume|2000元以下` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|2001-10000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|10001-50000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|50001-99999元` , sum(ifnull(member_sales_amount >= ?, ?)) AS `amount_total_consume|100000元以上` , sum(ifnull(member_age <= ?, ?)) AS `age|25岁以下` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|26-35岁` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|36-40岁` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|41-55岁` , sum(ifnull(member_age >= ?, ?)) AS `age|56岁以上` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|宠粉会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|白银会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|黄金会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|钻石会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|彩宝会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|翡翠会籍` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|0次` , sum(ifnull(member_sales_count = ?, ?)) |33|968|103||0|0|93523894|2836250|33|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 = ?|31|69|5||0|0|5782215|187335|155|5|
|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|31|69|5||0|0|221924|7738|13|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 = ?|26|49|4||0|0|4852645|187600|26|1|
|v4_employee|SELECT sum(ifnull(member_sales_amount <= ?, ?)) AS `amount_total_consume|2000元以下` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|2001-10000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|10001-50000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|50001-99999元` , sum(ifnull(member_sales_amount >= ?, ?)) AS `amount_total_consume|100000元以上` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|0次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|1次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|2次` , sum(ifnull(member_sales_count BETWEEN ? AND ?, ?)) AS `consume_num|3-5次` , sum(ifnull(member_sales_count >= ?, ?)) AS `consume_num|6次以上` , sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|2000分以下` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|2001-10000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|10001-30000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|30001-50000分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|50001分以上` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙1店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙2店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙3店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙4店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙5店` , sum(ifnull(shop_id = ?, ?)) AS `shop|德阳老庙1店` , sum(ifnull(member_integral_total <= ?, ?)) AS `integral_total|2000分以下` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|2001-10000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|10001-50000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|50001-99999分` , sum(ifnull(member_integral_total >= ?, ?)) AS `integral_total|100000分以上` , sum(ifnull(member_age <= ?, |25|744|116||0|0|70888161|2836250|25|1|
|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 ?|25|72|7||0|0|6134949|387887|4|1|
|corpwx|UPDATE external_user SET un_assign_flag = ? WHERE tenant_id = ? AND status = ? AND un_assign_flag = ?|24|89|9||0|0|694441|73874|0|0|
|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 = ?|21|37|4||0|0|146091|14098|21|1|
|tenant|SELECT count(0) 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 = ?|20|38|8||0|0|54870|5685|20|1|
|employee|SELECT count(*) FROM label_task_employee t1 JOIN label_task_setting t2 ON t1.label_task_id = t2.id AND t2.disabled = ? WHERE t1.tenant_app_id = ? AND t1.shop_id = ? AND t1.visit_status > ? AND t1.finish_time >= DATE_SUB(CURRENT_DATE, INTERVAL ? DAY) AND t1.finish_time < CURRENT_DATE|19|37|4||0|0|243014|48167|19|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 ?|18|42|4||0|0|756899|54281|18|1|
|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) AS category_erp_id, max(es.sales_date) AS 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, 1 = 1) AND va.id IS NULL AND i.id IS NULL|17|27|3||0|0|150963|16653|17|1|
|v4_employee|SELECT sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|小于等于50分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|51-100分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|101-200分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|201-300分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|大于等于301分` , sum(ifnull(shop_id = ?, ?)) AS `shop|市场中心` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙大悦城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙锦华万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙凯德二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙青羊万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙万象城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|广汉老庙一店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙泸县二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州谢瑞麟万象汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州谢瑞麟重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金宝瑞雅店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金城北店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金金街店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金纳溪二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金时代店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金重百店` , sum(i|17|151|33||0|0|48155611|2832683|17|1|
|authorization_service|update user_login_token set status=? where login_token in|17|29|4||0|0|30067|4662|0|0|
|v4_employee|SELECT count(1) AS total_count, count(finish_time) AS finish_count FROM task_task t JOIN task_system_task_template t2 ON t.task_template_id = t2.id AND t2.status = ? AND t2.tenant_id = ? AND t2.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 = ?|14|29|6||0|0|147827|29955|14|1|
|v4_employee|SELECT sum(ifnull(member_sex = ?, ?)) AS `sex|男` , sum(ifnull(member_sex = ?, ?)) AS `sex|女` , sum(ifnull(member_sex = ?, ?)) AS `sex|其他` , sum(ifnull(shop_id = ?, ?)) AS `shop|市场中心` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙大悦城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙锦华万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙凯德二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙青羊万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙万象城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|广汉老庙一店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙泸县二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州谢瑞麟万象汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州谢瑞麟重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金宝瑞雅店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金城北店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金金街店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金纳溪二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金时代店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生泸县店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|攀枝花金伯利总�|14|44|22||0|0|39657562|2832683|14|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_role2 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 = ?|14|19|2||0|0|909453|64996|288|40|
|user_service|SELECT count(0) FROM user_service.tenant_member t1 JOIN user_service.tenant_member_info t2 ON t1.tenant_id = t2.tenant_id AND t1.id = t2.id AND t2.tenant_app_id = ? AND t2.shop_id = ? WHERE t1.tenant_id = ? AND t1.tenant_app_id = ?|13|50|16||0|0|4428254|875269|13|1|
|v4_sales|SELECT es.id AS salesId, es.sales_no, es.sales_date, es.member_erp_id AS 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 NULL AND es.tenant_id = ? AND es.tenant_app_id = ? ORDER BY es.sales_date DESC, es.id DESC LIMIT ?|12|147|27||0|0|4359499|605871|12|1|
|coupon_service|SELECT cmod.coupon_id, cmo.pay_type, cmo.id AS 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 (?)|12|46|10||0|0|999393|113616|138|20|
|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 (?)|11|14|1||0|0|513|60|171|20|
|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 NULL AND es.tenant_id = ? AND es.tenant_app_id = ?|11|66|15||0|0|3231226|361297|11|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, '%Y-%m-%d') >= ?) AND w.id IS NOT NULL AND es.tenant_id = ? AND es.tenant_app_id = ?|10|17|3||0|0|48024|7864|10|1|
|v4_employee|SELECT sum(ifnull(member_sex = ?, ?)) AS `sex|男` , sum(ifnull(member_sex = ?, ?)) AS `sex|女` , sum(ifnull(member_sex = ?, ?)) AS `sex|其他` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙1店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙2店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙3店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙4店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙5店` , sum(ifnull(shop_id = ?, ?)) AS `shop|德阳老庙1店` , sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|2000分以下` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|2001-10000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|10001-30000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|30001-50000分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|50001分以上` , sum(ifnull(member_integral_total <= ?, ?)) AS `integral_total|2000分以下` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|2001-10000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|10001-50000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|50001-99999分` , sum(ifnull(member_integral_total >= ?, ?)) AS `integral_total|100000分以上` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|宠粉会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|白银会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|黄金会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|钻石会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|彩宝会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|翡翠会籍` , sum(ifnull(member_age <= ?, ?)) AS `age|25岁以下` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|26-35岁` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|36-40岁` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|41-55岁` , sum(ifnull(member|10|127|40||0|0|27996051|2802941|10|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 = ?|10|21|6||0|0|57794|31499|10|1|
|v4_employee|SELECT sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|2000分以下` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|2001-10000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|10001-30000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|30001-50000分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|50001分以上` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙1店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙2店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙3店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙4店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙5店` , sum(ifnull(shop_id = ?, ?)) AS `shop|德阳老庙1店` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|宠粉会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|白银会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|黄金会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|钻石会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|彩宝会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|翡翠会籍` , sum(ifnull(member_integral_total <= ?, ?)) AS `integral_total|2000分以下` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|2001-10000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|10001-50000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|50001-99999分` , sum(ifnull(member_integral_total >= ?, ?)) AS `integral_total|100000分以上` , sum(ifnull(member_sex = ?, ?)) AS `sex|男` , sum(ifnull(member_sex = ?, ?)) AS `sex|女` , sum(ifnull(member_sex = ?, ?)) AS `sex|其他` , sum(ifnull(member_age <= ?, ?)) AS `age|25岁以下` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|26-35岁` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|36-40岁` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|41-55岁` , sum(ifnull(member|10|197|38||0|0|27964639|2802848|10|1|
|v4_sales|SELECT t1.sales_erp_id AS salesErpId, t1.sales_no AS salesNo, DATE_FORMAT(t1.sales_date, '%Y-%m-%d') AS salesDate , t1.member_erp_id AS memberId, t1.employee_erp_id AS employeeErpId, t1.employee_name AS employeeName, t1.assist_employee_erp_id AS assistEmployeeErpId, t1.assist_employee_name AS assistEmployeeName , t1.dept_erp_id AS deptErpId, t1.amount, t1.post_time AS postTime FROM erp_sales t1 WHERE t1.employee_erp_id = ? AND t1.post_time >= ? AND t1.post_time <= ? AND t1.is_sales = ? AND t1.sales_status = ? AND t1.tenant_id = ? AND t1.tenant_app_id = ?|10|14|2||0|0|39030|11221|17|3|
|v4_employee|SELECT sum(ifnull(shop_id = ?, ?)) AS `shop|市场中心` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙大悦城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙锦华万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙凯德二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙青羊万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙万象城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|广汉老庙一店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙泸县二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州谢瑞麟万象汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州谢瑞麟重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金宝瑞雅店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金城北店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金金街店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金纳溪二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金时代店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生泸县店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|攀枝花金伯利总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|攀枝花老庙万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|攀枝花六福万达店` , sum(if|10|74|19||0|0|28119812|2818161|10|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 = ?|9|13|2||0|0|21790|4662|21790|4662|
|user_service|SELECT t1.id, t1.user_id AS userId, t1.user_name AS userName, t1.sex, t1.mobile_no AS mobileNo , t1.head_img_url AS headImg FROM user_service.tenant_member t1 JOIN user_service.tenant_member_info t2 ON t1.tenant_id = t2.tenant_id AND t1.id = t2.id AND t2.tenant_app_id = ? AND t2.shop_id = ? JOIN user_service.user_employee ue ON t1.tenant_id = ue.tenant_id AND t1.tenant_app_id = ue.tenant_wechatapp_id AND t1.user_id = ue.user_id AND ue.employee_id = ? AND ue.shop_id = ? WHERE t1.tenant_id = ? AND t1.tenant_app_id = ? ORDER BY ue.update_time DESC, t1.id DESC LIMIT ?|9|17|5||0|0|76138|12192|90|10|
|order|SELECT count(0) 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 = ?|8|15|2||0|0|530892|166665|8|1|
|order|SELECT max(create_time) FROM `order`.order_operator_log WHERE tenant_wechatapp_id = ? AND order_id = ?|8|50|13||0|0|8497077|1062352|8|1|
|v4_employee|SELECT sum(ifnull(member_sales_amount <= ?, ?)) AS `amount_total_consume|2000元以下` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|2001-10000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|10001-50000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|50001-99999元` , sum(ifnull(member_sales_amount >= ?, ?)) AS `amount_total_consume|100000元以上` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|0次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|1次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|2次` , sum(ifnull(member_sales_count BETWEEN ? AND ?, ?)) AS `consume_num|3-5次` , sum(ifnull(member_sales_count >= ?, ?)) AS `consume_num|6次以上` , sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|小于等于50分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|51-100分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|101-200分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|201-300分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|大于等于301分` , sum(ifnull(shop_id = ?, ?)) AS `shop|市场中心` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙大悦城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙锦华万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙凯德二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙青羊万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙万象城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|广汉老庙一店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|�|8|38|24||0|0|22492559|2818161|8|1|
|order|SELECT count(1) AS total , ifnull(sum(if(od.status > ?, od.payment_fee, ?)), ?) AS paymentFee , ifnull(sum(if(od.status > ?, od.offline_payment_fee, ?)), ?) AS offlinePaymentFee , ifnull(sum(if(od.status > ?, od.payment_fee + od.offline_payment_fee, ?)), ?) AS 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 = ?|7|12|2||0|0|525396|166665|7|1|
|user_service|SELECT ue.id AS userEmployeeId, ue.tenant_id AS tenantId, ue.tenant_wechatapp_id AS tenantAppId, ue.shop_id AS shopId, tu.user_id AS userId , tu.user_name AS nickName, tu.user_name AS userName, tu.mobile_no AS mobileNo, tu.head_img_url AS headImgUrl FROM user_service.user_employee ue JOIN user_service.tenant_member tu ON tu.tenant_id = ue.tenant_id AND ue.tenant_wechatapp_id = tu.tenant_app_id AND ue.user_id = tu.user_id WHERE ue.tenant_id = ? AND ue.tenant_wechatapp_id = ? AND ue.employee_id = ? AND ue.shop_id = ?|7|28|10||0|0|22726|5942|11363|2971|
|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|7|36|19||0|0|7631964|1892314|2710|612|
|v4_sales|SELECT es.dept_erp_id AS deptId , sum(CASE  WHEN w.id IS NOT NULL THEN ? ELSE ? END) AS addedTotal , sum(CASE  WHEN w.id IS NULL THEN ? ELSE ? END) AS notAddTotal , count(es.id) AS 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|7|12|2||0|0|1573832|256315|242|41|
|v4_employee|SELECT ? AS task_type, t1.id AS invite_task_id, t1.name , ifnull(t2.undo_count, ?) AS undo_count, t1.invite_time AS invite_task_start_time , ifnull(t1.interrupt_time, t1.end_time) AS invite_task_end_time FROM task_invite_task_template t1 LEFT JOIN ( SELECT t.task_template_id AS id , sum(if(t.finish_time IS NULL, ?, ?)) 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 ) t2 ON t1.id = t2.id WHERE t1.status IN (?) AND t1.tenant_id = ? AND t1.tenant_app_id = ? ORDER BY t1.id DESC|6|7|1||0|0|16843|3259|27|5|
|user_service|SELECT count(0) FROM user_service.tenant_member tm JOIN user_service.tenant_member_info tmi ON tm.tenant_id = tmi.tenant_id AND tm.id = tmi.id LEFT JOIN user_service.user_employee t3 ON tm.user_id = t3.user_id AND tm.tenant_id = t3.tenant_id AND tm.tenant_app_id = t3.tenant_wechatapp_id WHERE t3.id IS NULL AND tmi.shop_id = ? AND tmi.tenant_id = ? AND tmi.tenant_app_id = ?|6|20|5||0|0|96268|32546|6|1|
|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|13565|2500|2713|500|
|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 = ? 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 if(wca.source = ?, es.sales_date >= ?, date_format(wca.create_time, '%Y-%m-%d') >= ?) AND es.employee_erp_id = ? AND dept_erp_id = ? AND w.id IS NULL AND es.tenant_id = ? AND es.tenant_app_id = ?|6|8|2||0|0|11807|2525|6|1|
|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|6|8|1||0|0|28855|4826|1|1|
|tenant|SELECT count(*) AS amount FROM sneak_guest WHERE tenant_app_id = ? AND status = ? AND create_shop_id = ? AND maintain_employee_id = ? AND create_time >= ?|6|7|1||0|0|4418|1733|6|1|
|v4_sales|SELECT es.id AS salesId, es.sales_no, es.sales_date, es.member_erp_id AS 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 NULL AND es.tenant_id = ? AND es.tenant_app_id = ? ORDER BY es.sales_date DESC, es.id DESC LIMIT ?|6|29|7||0|0|2644204|606250|20|5|
|value_added|SELECT ? AS limitDayType, t.tenant_wechatapp_id AS tenantAppId, t.user_id AS userId, min(ue.employee_erp_id) AS 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(?, '%Y-%m-%d'), INTERVAL ? * (t.add_days - ?) DAY) AND t.start_add_time < date_add(DATE_FORMAT(?, '%Y-%m-%d'), INTERVAL ? * (t.add_days - ?) + ? DAY) GROUP BY t.tenant_wechatapp_id, t.user_id, ue.dept_erp_id|5|16|10||0|0|1341568|465332|530|321|
|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|7|2||0|0|108780|21756|7|2|
|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 = ?|5|12|7||0|0|49395|9879|0|0|
|employee|SELECT id, scene, employee_id, member_user_name AS 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 ?|5|87|38||0|0|4781155|956231|25|5|
|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 = ?|5|11|2||0|0|11484|7480|5742|3740|
|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 = ?|5|6|1||0|0|3965|1137|5|1|
|order|SELECT od.id, od.order_no AS orderNo, od.status, od.take_type AS takeType, od.create_time AS createTime , od.remark, od.total_fee AS totalFee, od.freight_fee AS freightFee, od.discount_fee AS discountFee, od.take_id AS takeId , od.payment_fee AS paymentFee, dt.product_id AS productId, dt.price, dt.quantity, dt.sku_id AS skuId , dt.art_no AS artNo, dt.image_url AS imageUrl, dt.product_name AS productName, dt.take_remark AS takeRemark, dt.take_day AS takeDay , od.product_fee AS productFee, ad.user_name AS receiveName, ad.mobile_no AS mobileNo, ad.shop_name AS shopName, ad.address , ad.express_no AS expressNo, ad.express_company AS expressCompany, od.user_name AS userName, od.update_time AS updateTime, od.child_status AS childStatus , od.finish_type AS finishType, od.receive_time AS receiveTime, od.user_id AS userId, od.mobile_no AS buyMobileNo, od.edit_fee_flag AS editFeeFlag , dt.spec AS 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 = ?) ORDER BY od.create_time DESC LIMIT ?|5|25|11||0|0|824544|166767|32|20|
|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 = ?|5|9|4||0|0|837434|271743|5|1|
|tenant|SELECT count(0) 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, t1.employee_name AS createEmployeeName , sg.finish_date, sg.fail_type, gs.sales_id, gs.sales_no, w1.shop_name AS salesShopName , gs.create_time AS salesDate, gs.product_name, gs.product_quantity, gs.amount AS salesAmount , if(sg.status = ?, CASE  WHEN sg.fail_type = ? THEN ? 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 t1 ON sg.create_employee_id = t1.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 w1 ON gs.shop_id = w1.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|5|20|8||0|0|330055|178351|5|1|
|v4_coupon|UPDATE v4_coupon.coupon SET coupon_status = ? WHERE tenant_id = ? AND tenant_app_id = ? AND coupon_status = ? AND end_time < now()|5|8|3||0|0|867089|827338|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 NULL AND es.tenant_id = ? AND es.tenant_app_id = ?|4|16|5||0|0|787558|369195|4|1|
|order|SELECT count(0) 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 = ?)|4|17|11||0|0|667002|166767|4|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 = ?|4|4|1||0|0|3118|950|4|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 ?|4|18|12||0|0|1259513|327331|2|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 (?) AND t.un_assign_flag = ?|4|7|2||0|0|1740|435|792|198|
|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()|4|5|1||0|0|846|370|4|1|
|user_service|UPDATE user_service.tenant_member_info t1 JOIN user_service.user_employee t2 ON t1.tenant_id = t2.tenant_id AND t1.tenant_app_id = t2.tenant_wechatapp_id AND t1.user_id = t2.user_id SET t1.shop_id = ?, t2.shop_id = ? WHERE t1.tenant_id = ? AND t1.tenant_app_id = ? AND t2.employee_id = ? AND t1.shop_id = ?|4|15|5||0|0|11052|5220|0|0|
|goods|SELECT id, img_url, img_index FROM goods_img WHERE goods_id = ? ORDER BY update_time DESC|4|4|1||0|0|109848|27465|8|5|
|v4_coupon|SELECT COUNT(*) AS total FROM v4_coupon.coupon c JOIN v4_coupon.coupon_extend ce ON ce.id = c.id AND ce.tenant_id = ? AND ce.tenant_app_id = ? LEFT JOIN v4_coupon.coupon_write_off cwo ON cwo.coupon_id = c.id AND cwo.status = ? AND cwo.tenant_id = ? AND cwo.tenant_app_id = ? WHERE ce.coupon_name LIKE CONCAT(?, ?, ?) AND c.scene IN (?) AND c.coupon_status IN (?) AND c.create_time >= ? AND c.create_time <= ? AND c.tenant_id = ? AND c.tenant_app_id = ?|4|12|4||0|0|799899|205543|4|1|
|coupon_service|SELECT count(1) FROM coupon_service.coupon_expire_task WHERE tenant_id = ? AND tenant_app_id = ? AND shop_id = ? AND employee_id = ? AND status = ? AND expire_time > now()|3|6|2||0|0|11949|3983|3|1|
|order|SELECT count(1) AS total , ifnull(sum(if(od.status > ?, od.payment_fee, ?)), ?) AS paymentFee , ifnull(sum(if(od.status > ?, od.offline_payment_fee, ?)), ?) AS offlinePaymentFee , ifnull(sum(if(od.status > ?, od.payment_fee + od.offline_payment_fee, ?)), ?) AS 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 = ?)|3|15|11||0|0|500235|166767|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 = ?|3|5|3||0|0|12113|8922|3|1|
|order|SELECT count(0) 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(?, ?, ?) AND (od.status = ?)|3|12|4||0|0|231889|77311|3|1|
|v4_employee|SELECT sum(ifnull(member_sales_amount <= ?, ?)) AS `amount_total_consume|2000元以下` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|2001-10000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|10001-50000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|50001-99999元` , sum(ifnull(member_sales_amount >= ?, ?)) AS `amount_total_consume|100000元以上` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|0次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|1次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|2次` , sum(ifnull(member_sales_count BETWEEN ? AND ?, ?)) AS `consume_num|3-5次` , sum(ifnull(member_sales_count >= ?, ?)) AS `consume_num|6次以上` , sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|2000分以下` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|2001-10000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|10001-30000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|30001-50000分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|50001分以上` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙1店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙2店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙3店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙4店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙5店` , sum(ifnull(shop_id = ?, ?)) AS `shop|德阳老庙1店` , sum(ifnull(member_integral_total <= ?, ?)) AS `integral_total|2000分以下` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|2001-10000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|10001-50000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|50001-99999分` , sum(ifnull(member_integral_total >= ?, ?)) AS `integral_total|100000分以上` , sum(ifnull(member_age <= ?, |3|15|5||0|0|4843550|1614517|3|1|
|v4_employee|SELECT sum(ifnull(member_sales_amount <= ?, ?)) AS `amount_total_consume|2000元以下` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|2001-10000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|10001-50000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|50001-99999元` , sum(ifnull(member_sales_amount >= ?, ?)) AS `amount_total_consume|100000元以上` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|0次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|1次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|2次` , sum(ifnull(member_sales_count BETWEEN ? AND ?, ?)) AS `consume_num|3-5次` , sum(ifnull(member_sales_count >= ?, ?)) AS `consume_num|6次以上` , sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|2000分以下` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|2001-10000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|10001-30000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|30001-50000分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|50001分以上` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙1店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙2店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙3店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙4店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙5店` , sum(ifnull(shop_id = ?, ?)) AS `shop|德阳老庙1店` , sum(ifnull(member_integral_total <= ?, ?)) AS `integral_total|2000分以下` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|2001-10000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|10001-50000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|50001-99999分` , sum(ifnull(member_integral_total >= ?, ?)) AS `integral_total|100000分以上` , sum(ifnull(member_age <= ?, |3|5|1||0|0|8508750|2836250|3|1|
|employee|SELECT count(*) FROM employee.backlog WHERE tenant_id = ? AND tenant_app_id = ? AND shop_id = ? AND status = ? AND expire_time BETWEEN ? AND ?|3|5|2||0|0|15002|10735|3|1|
|tenant|SELECT count(*) AS amount FROM sneak_guest WHERE tenant_app_id = ? AND status = ? AND create_shop_id = ? AND create_time <= ?|3|4|2||0|0|12314|4110|3|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|3|4|2||0|0|24628|8220|12314|4110|
|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 = ?)|3|3|1||0|0|5931|3103|3|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 ?|3|6|3||0|0|1288408|496822|3|1|
|v4_employee|SELECT count(*) AS total_count , ifnull(sum(if(finish_time, ?, ?)), ?) AS undo_count , count(finish_time) AS finish_count, count(accept_time) AS accept_count , count(arrival_shop_time) AS arrival_shop_count, count(trade_time) AS trade_count , count(send_coupons) AS coupon_send_count, count(recv_coupons) AS coupon_recv_count , ifnull(sum(trade_amount), ?) AS trade_amount , ifnull(sum(trade_num), ?) AS trade_num FROM task_task WHERE task_type = ? AND `status` != ? AND task_template_id = ? AND tenant_id = ? AND tenant_app_id = ?|3|9|4||0|0|112209|37403|3|1|
|gift_mail|SELECT count(0) 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) AS address , if(t.trade_type = ?, pl.id, it.barcode) AS barcode , if(t.trade_type = ?, pl.default_image_url, p.default_image_url) AS defaultImageUrl FROM trade t LEFT JOIN trade_take tt ON t.tenant_wechatapp_id = tt.tenant_wechatapp_id AND t.id = tt.trade_id LEFT JOIN trade_addr ta ON t.tenant_wechatapp_id = ta.tenant_wechatapp_id AND t.id = ta.trade_id LEFT JOIN product p ON p.id = t.product_id LEFT JOIN platform_product pl ON pl.id = t.product_id LEFT JOIN inventory it ON it.product_id = t.product_id AND it.specification = t.specification LEFT 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|3|6|2||0|0|214223|93051|3|1|
|order|SELECT count(0) 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|9|5||0|0|135720|45240|3|1|
|employee|UPDATE backlog SET leave_flag = ? WHERE tenant_app_id = ? AND employee_id = ?|3|8|5||0|0|11029|4437|0|0|
|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 NULL OR sg.fail_type = ?) AND sgm.create_time BETWEEN ? AND ? ) t JOIN tenant.employee e ON e.id = t.employee_id|3|19|9||0|0|82964|29318|18|8|
|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|8|3||0|0|6196|2068|0|0|
|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|3|1||0|0|194162|64721|3|1|
|export|select od.coupon_id, case o.pay_type when ? then ? when ? then ? when ? then ? 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|3|7|3||0|0|166186|113616|2106|1741|
|order|SELECT id, type, operator_type AS operatorType, operator_result AS operatorResult, reason_label AS reasonLabel , reason_value AS reasonValue, remark, create_time AS createTime, status FROM order_service_log WHERE order_id = ? ORDER BY create_time DESC|3|4|1||0|0|76884|25628|0|0|
|tenant|SELECT count(*) FROM sneak_guest WHERE tenant_app_id = ? AND status = ? AND create_shop_id = ? AND maintain_employee_id = ?|3|3|1||0|0|2540|1733|3|1|
|tenant|SELECT count(0) 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 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 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 = ?|3|3|1||0|0|16257|5479|3|1|
|v4_employee|SELECT sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙1店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙2店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙3店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙4店` , sum(ifnull(shop_id = ?, ?)) AS `shop|达州老庙5店` , sum(ifnull(shop_id = ?, ?)) AS `shop|德阳老庙1店` , sum(ifnull(member_integral_total <= ?, ?)) AS `integral_total|2000分以下` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|2001-10000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|10001-50000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|50001-99999分` , sum(ifnull(member_integral_total >= ?, ?)) AS `integral_total|100000分以上` , sum(ifnull(member_sales_amount <= ?, ?)) AS `amount_total_consume|2000元以下` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|2001-10000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|10001-50000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|50001-99999元` , sum(ifnull(member_sales_amount >= ?, ?)) AS `amount_total_consume|100000元以上` , sum(ifnull(member_age <= ?, ?)) AS `age|25岁以下` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|26-35岁` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|36-40岁` , sum(ifnull(member_age BETWEEN ? AND ?, ?)) AS `age|41-55岁` , sum(ifnull(member_age >= ?, ?)) AS `age|56岁以上` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|宠粉会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|白银会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|黄金会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|钻石会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|彩宝会籍` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|翡翠会籍` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|0次` , sum(ifnull(member_sales_count = ?, ?)) |3|39|23||0|0|4843560|1614523|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.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 NULL AND es.dept_erp_id IN (?) AND es.tenant_id = ? AND es.tenant_app_id = ?|3|5|2||0|0|1177883|562979|3|1|
|v4_user|SELECT t2.id AS memberId, t1.id AS potentialCustomerId, t1.checkin_time AS checkinTime FROM potential_customer t1 JOIN member t2 ON t2.id = t1.member_id AND t2.tenant_id = ? AND t2.tenant_app_id = ? WHERE t1.maintain_shop_id = ? AND t1.maintain_employee_id = ? AND t1.`status` IN (?) AND t1.tenant_id = ? AND t1.tenant_app_id = ? UNION SELECT t2.id AS memberId, t1.id AS potentialCustomerId, t1.checkin_time AS checkinTime FROM potential_customer t1 JOIN member t2 ON t2.external_user_id = t1.external_user_id AND t2.tenant_id = ? AND t2.tenant_app_id = ? WHERE t1.maintain_shop_id = ? AND t1.maintain_employee_id = ? AND t1.`status` IN (?) AND t1.member_id = ? AND t1.tenant_id = ? AND t1.tenant_app_id = ?|3|5|2||0|0|4442|3192|258|107|
|v4_employee|SELECT s.id, s.name FROM shop s JOIN ( SELECT DISTINCT shop_id FROM task_task WHERE status != ? AND task_template_id = ? AND tenant_id = ? AND tenant_app_id = ? ) t ON s.id = t.shop_id WHERE s.tenant_id = ? AND s.tenant_app_id = ?|3|9|4||0|0|112239|37413|15|5|
|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 NULL|3|6|2||0|0|61208|26586|30603|13293|
|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 = ?|3|14|5||0|0|114337|38121|3|1|
|employee|UPDATE backlog SET status = ?, finish_time = now() WHERE tenant_app_id = ? AND employee_id = ? AND status IN (?) AND shop_id = ?|3|8|3||0|0|6000|2369|0|0|
|warranty_service|SELECT count(*) FROM warranty WHERE user_id = ? AND tenant_wechatapp_id = ? AND is_disable = ?|3|23|8||0|0|46777|15599|3|1|
|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 NULL AND es.dept_erp_id IN (?) AND es.tenant_id = ? AND es.tenant_app_id = ?|3|3|1||0|0|765196|301967|90775|45897|
|user_service|SELECT count(0) 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 = ?|3|31|15||0|0|290994|96998|3|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|3|11|6||0|0|1713093|576161|41|18|
|coupon_service|SELECT * FROM coupon_service.coupon_can_give WHERE coupon_id = ? LIMIT ?|2|3|2||0|0|631749|326576|2|1|
||SELECT t.id FROM v4_employee.task_task t LEFT JOIN v4_employee.employee e ON t.tenant_id = e.tenant_id AND t.tenant_app_id = e.tenant_app_id AND t.employee_id = e.employee_id WHERE t.tenant_id = ? AND e.id IS NULL|2|4|3||0|0|27885|14519|0|0|
|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 NULL, ?, ?) 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 NULL AND p.product_status = ? ORDER BY i.volume DESC, p.tag_price ASC, p.id DESC LIMIT ?|2|2|1||0|0|17597|8799|12|6|
|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 = ?|2|2|1||0|0|4131|2067|1|1|
|user_service|SELECT count(0) 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 = ?)|2|2|1||0|0|515097|477901|2|1|
|v4_employee|SELECT sum(ifnull(member_sales_amount <= ?, ?)) AS `amount_total_consume|2000元以下` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|2001-10000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|10001-50000元` , sum(ifnull(member_sales_amount BETWEEN ? AND ?, ?)) AS `amount_total_consume|50001-99999元` , sum(ifnull(member_sales_amount >= ?, ?)) AS `amount_total_consume|100000元以上` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|0次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|1次` , sum(ifnull(member_sales_count = ?, ?)) AS `consume_num|2次` , sum(ifnull(member_sales_count BETWEEN ? AND ?, ?)) AS `consume_num|3-5次` , sum(ifnull(member_sales_count >= ?, ?)) AS `consume_num|6次以上` , sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|小于等于50分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|51-100分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|101-200分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|201-300分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|大于等于301分` , sum(ifnull(shop_id = ?, ?)) AS `shop|市场中心` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙大悦城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙锦华万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙凯德二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙青羊万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙万象城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|广汉老庙一店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|�|2|22|20||0|0|5636322|2818161|2|1|
|activity_service|SELECT count(DISTINCT user_id) FROM user_trace WHERE tenant_app_id = ? AND activity_id = ? AND status != ?|2|2|1||0|0|7030|3515|2|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 NULL OR sg.fail_type = ?) WHERE s.tenant_id = ? AND s.tenant_app_id = ? AND s.shop_id = ? AND s.event_type = ? AND s.create_time BETWEEN ? AND ? GROUP BY s.sneak_guest_id ) a|2|2|1||0|0|7532|3766|2|1|
|coupon_service|SELECT count(0) 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.create_time >= ? AND cu.create_time <= ?|2|6|5||0|0|43904|30334|2|1|
|export|SELECT count(0) 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 (?)|2|3|1||0|0|119025|59515|2|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 = ?|2|4|3||0|0|15428|7714|0|0|
|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 = ?|2|2|1||0|0|192646|165167|2|1|
|employee|SELECT id, scene, employee_id, member_user_name AS 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|2|1||0|0|306080|153040|9|7|
||SELECT * FROM employee.backlog WHERE create_time > ? AND id >= ? ORDER BY id|2|4|3||0|0|308132|154066|53028|26514|
|coupon_service|SELECT id, tenant_id, tenant_app_id, template_id, coupon_type , take_effect_way, take_start_day, take_effect_day, begin_time, end_time , source, source_id, can_give, need_booking, use_threshold , wx_card_id, state, create_time, update_time FROM coupon_push WHERE tenant_id = ? AND tenant_app_id = ? AND wx_card_id = ?|2|2|1||0|0|3980|1990|0|0|
|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 ?|2|3|1||0|0|28000|14000|0|0|
|v4_sales|SELECT t1.sales_erp_id AS salesErpId, t1.sales_no AS salesNo, DATE_FORMAT(t1.sales_date, '%Y-%m-%d') AS salesDate , t1.member_erp_id AS memberId, t1.employee_erp_id AS employeeErpId, t1.employee_name AS employeeName, t1.assist_employee_erp_id AS assistEmployeeErpId, t1.assist_employee_name AS assistEmployeeName , t1.dept_erp_id AS deptErpId, t1.amount, t1.post_time AS postTime FROM erp_sales t1 WHERE t1.dept_erp_id = ? AND t1.member_erp_id IN (?) AND t1.post_time >= ? AND t1.is_sales = ? AND t1.sales_status = ? AND t1.tenant_id = ? AND t1.tenant_app_id = ?|2|3|1||0|0|1720|1083|337|205|
|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 ?|2|4|2||0|0|180931|90481|17|16|
|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(1) AS 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 NULL AND us.shop_id IS NOT NULL GROUP BY us.from_id ORDER BY count(1) DESC ) obj, ( SELECT @rownum := ?, @rowtotal := NULL ) r|2|2|1||0|0|7341|6277|12|7|
|employee|UPDATE backlog_system SET status = ?, finish_time = now() WHERE tenant_app_id = ? AND scene = ?|2|18|17||0|0|1562884|1384046|0|0|
|v4_coupon|SELECT tenant_id, tenant_app_id, member_id, count(1) AS total FROM v4_coupon.coupon WHERE DATEDIFF(DATE_FORMAT(end_time, '%Y-%m-%d'), DATE_FORMAT(now(), '%Y-%m-%d')) = ? AND coupon_status IN (?) GROUP BY tenant_id, tenant_app_id, member_id|2|18|9||0|0|1660909|831012|191|97|
|user_service|SELECT count(0) FROM user_service.tenant_member tm JOIN user_service.tenant_member_info tmi ON tmi.tenant_id = ? AND tmi.tenant_app_id = ? AND tm.id = tmi.id WHERE tm.tenant_id = ? AND tm.tenant_app_id = ? AND (tm.user_name LIKE concat(?, ?, ?) OR tm.mobile_no = ?)|2|2|1||0|0|129621|91601|2|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(1) AS 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 NULL AND us.shop_id IS NOT NULL GROUP BY us.from_id, us.shop_id ORDER BY count(1) DESC ) obj, ( SELECT @rownum := ?, @rowtotal := NULL ) r|2|2|1||0|0|8568|7450|421|398|
|gift_mail|SELECT count(*) FROM gift_mail.trade t WHERE t.tenant_wechatapp_id = ? AND t.trade_type = ? AND t.order_status = ?|2|3|2||0|0|18224|9112|2|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|2|4|3||0|0|572378|286243|2|1|
||INSERT INTO v4_user.wx_user (id, app_type, app_id, open_id, union_id , nick_name, mobile_no, head_img_url, is_subscribe, subscribe_time , cancel_subscribe_time, sex, country, province, city) SELECT id, ?, wx_app_id, open_id, union_id , nick_name, mobile_no, head_img_url, is_subscribe, subscribe_time , unsubscribe_time, sex, country, province, city FROM user_service.wx_user WHERE wx_app_id = ? ON DUPLICATE KEY UPDATE update_time = now()|2|122|95||0|0|63154|31579|0|0|
|v4_user|SELECT COUNT(*) AS total FROM potential_customer t1 WHERE t1.maintain_shop_id = ? AND t1.maintain_employee_id = ? AND t1.status IN (?) AND t1.tenant_id = ? AND t1.tenant_app_id = ?|2|3|2||0|0|1764|1506|2|1|
|v4_employee|SELECT sum(ifnull(member_level_id = ?, ?)) AS `member_level|普通卡` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|黄金会员` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|铂金会员` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|钻石会员` , sum(ifnull(member_level_id = ?, ?)) AS `member_level|至尊会员` , sum(ifnull(member_integral_total <= ?, ?)) AS `integral_total|2000分以下` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|2001-10000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|10001-50000分` , sum(ifnull(member_integral_total BETWEEN ? AND ?, ?)) AS `integral_total|50001-99999分` , sum(ifnull(member_integral_total >= ?, ?)) AS `integral_total|100000分以上` , sum(ifnull(member_sex = ?, ?)) AS `sex|男` , sum(ifnull(member_sex = ?, ?)) AS `sex|女` , sum(ifnull(member_sex = ?, ?)) AS `sex|其他` , sum(ifnull(shop_id = ?, ?)) AS `shop|岳阳友阿张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|岳阳九方店（步行街）` , sum(ifnull(shop_id = ?, ?)) AS `shop|宁乡吾悦张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|家润多张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|汉华张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|金都张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|华容周大生` , sum(ifnull(shop_id = ?, ?)) AS `shop|株洲天虹张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|湘潭天虹周六福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|长沙开福万达周大生珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|株洲万达张万福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|衡阳酃湖万达张万福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|株洲张万福珠宝（老公安局店）` , sum(ifnull(shop_id = ?, ?)) AS `shop|邵阳县凤凰城周六福珠宝1` , sum(ifnull(shop_id = ?, ?)) AS `shop|邵阳县凤凰城周大福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|天虹商场周六福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|运达汇周大生珠|2|81|53||0|0|5666284|2833142|2|1|
|order|SELECT count(1) AS total , ifnull(sum(if(od.status > ?, od.payment_fee, ?)), ?) AS paymentFee , ifnull(sum(if(od.status > ?, od.offline_payment_fee, ?)), ?) AS offlinePaymentFee , ifnull(sum(if(od.status > ?, od.payment_fee + od.offline_payment_fee, ?)), ?) AS 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(?, ?, ?)|2|6|5||0|0|90480|45240|2|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|2|4|2||0|0|102816|95934|28|24|
|wx_gateway|SELECT count(0) FROM wx_template_msg WHERE tenant_id = ? AND tenant_app_id = ? AND create_time BETWEEN ? AND ?|2|19|17||0|0|33059|16530|2|1|
|employee|UPDATE backlog SET employee_id = ?, update_time = now() WHERE tenant_app_id = ? AND shop_id = ? AND employee_id = ? AND status IN (?)|2|2|1||0|0|1034|604|0|0|
|tenant|SELECT count(0) FROM ( SELECT sg.id, sneak_guest_no, sg.status, sg.user_id, sg.user_type , smg.time , if(sg.status = ?, e.employee_name, ?) AS maintainEmployeeName , smg._count AS maintainNum, sg.update_employee_id FROM tenant.sneak_guest sg JOIN tenant.employee e ON e.id = sg.maintain_employee_id JOIN ( SELECT sneak_guest_id, count(*) AS _count, min(create_time) AS time FROM tenant.sneak_guest_maintain WHERE tenant_id = ? AND tenant_app_id = ? AND shop_id = ? AND employee_id = ? AND event_type IN (?) AND create_time BETWEEN ? AND ? GROUP BY sneak_guest_id ) smg ON smg.sneak_guest_id = sg.id WHERE sg.tenant_id = ? AND sg.tenant_app_id = ? AND (sg.fail_type IS NULL OR sg.fail_type = ?) ) tmp_count|1|1|1||0|0|3796|3796|1|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 subject_type = ? AND tenant_id = ? AND tenant_app_id = ?|1|1|1||0|0|186345|186345|4|4|
|order|SELECT od.id, od.order_no AS orderNo, od.status, od.take_type AS takeType, od.create_time AS createTime , od.remark, od.total_fee AS totalFee, od.freight_fee AS freightFee, od.discount_fee AS discountFee, od.take_id AS takeId , od.payment_fee AS paymentFee, dt.product_id AS productId, dt.price, dt.quantity, dt.sku_id AS skuId , dt.art_no AS artNo, dt.image_url AS imageUrl, dt.product_name AS productName, dt.take_remark AS takeRemark, dt.take_day AS takeDay , od.product_fee AS productFee, ad.user_name AS receiveName, ad.mobile_no AS mobileNo, ad.shop_name AS shopName, ad.address , ad.express_no AS expressNo, ad.express_company AS expressCompany, od.finish_type AS finishType, od.send_time AS sendTime, od.receive_time AS receiveTime , od.finish_time AS finishTime, od.child_status AS childStatus, od.send_good_remark AS sendGoodRemark, od.service_flag AS serviceFlag, od.coupon_id AS couponId , od.tenant_wechatapp_id AS 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|256348|256348|0|0|
|value_added|SELECT ? AS limitDayType, t.tenant_wechatapp_id, t.user_id, min(ue.employee_erp_id) AS 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(?, '%Y-%m-%d'), INTERVAL ? * (t.add_days + t.keeping_days - ?) DAY) AND t.start_add_time < date_add(DATE_FORMAT(?, '%Y-%m-%d'), 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|465230|465230|34|34|
|order|SELECT od.id, od.order_no AS orderNo, od.status, od.take_type AS takeType, od.create_time AS createTime , od.remark, od.total_fee AS totalFee, od.freight_fee AS freightFee, od.discount_fee AS discountFee, od.take_id AS takeId , od.payment_fee AS paymentFee, dt.product_id AS productId, dt.price, dt.quantity, dt.sku_id AS skuId , dt.art_no AS artNo, dt.image_url AS imageUrl, dt.product_name AS productName, dt.take_remark AS takeRemark, dt.take_day AS takeDay , od.product_fee AS productFee, ad.user_name AS receiveName, ad.mobile_no AS mobileNo, ad.shop_name AS shopName, ad.address , ad.express_no AS expressNo, ad.express_company AS expressCompany, od.user_name AS userName, od.update_time AS updateTime, od.child_status AS childStatus , od.finish_type AS finishType, od.receive_time AS receiveTime, od.user_id AS userId, od.mobile_no AS buyMobileNo, od.edit_fee_flag AS editFeeFlag , dt.spec AS 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.take_type = ? AND (od.status = ? OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.finish_type = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.finish_type = ?)) AND ad.shop_id = ? AND dt.product_id = ? AND dt.sku_id = ? ORDER BY od.create_time DESC LIMIT ?|1|1|1||0|0|25088|25088|20|20|
|coupon_service|SELECT * FROM coupon_service.coupon WHERE DATEDIFF(DATE_FORMAT(end_time, '%Y-%m-%d'), DATE_FORMAT(now(), '%Y-%m-%d')) = ? AND coupon_state IN (?)|1|114|114||0|0|11551258|11551258|1445|1445|
|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|15|15||0|0|2101724|2101724|1221|1221|
|tenant|SELECT count(0) FROM ( SELECT es.id, es.sales_no, es.sales_date, es.sales_erp_id, es.amount , ifnull(shop.shop_name, ed.dept_name) AS 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|1|1|1||0|0|604078|604078|1|1|
|tenant|SELECT count(0) 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|91427|91427|1|1|
|v4_employee|SELECT sum(ifnull(shop_id = ?, ?)) AS `shop|市场中心` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙大悦城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙锦华万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙凯德二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙青羊万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|成都老庙万象城店` , sum(ifnull(shop_id = ?, ?)) AS `shop|广汉老庙一店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州金伯利总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙欢乐汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙泸县二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州老庙总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州谢瑞麟万象汇店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州谢瑞麟重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金宝瑞雅店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金城北店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金金街店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金纳溪二店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金时代店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州中金总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生泸县店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生重百店` , sum(ifnull(shop_id = ?, ?)) AS `shop|泸州周大生总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|攀枝花金伯利总店` , sum(ifnull(shop_id = ?, ?)) AS `shop|攀枝花老庙万达店` , sum(ifnull(shop_id = ?, ?)) AS `shop|攀枝花六福万达店` , sum(if|1|7|7||0|0|2818161|2818161|1|1|
|corpwx_license|DELETE FROM cwx_sync_active_info WHERE tenant_id = ? AND user_id = ? AND tenant_id = ?|1|2|2||0|0|27461|27461|0|0|
|value_added|SELECT t1.id, t2.sales_no AS salesNo, DATE_FORMAT(t2.sales_date, '%Y-%m-%d') AS salesDate , DATE_FORMAT(t1.start_add_time, '%Y-%m-%d') AS valueAddDate, t2.dept_erp_id AS shopId , t1.shop_name AS shopName, t2.employee_erp_id AS userId, t2.employee_name AS userName, t1.product_name AS productName, t1.amount_pay AS amountPay , t1.id AS valueAddNo, t1.amount_added AS valueAddAmount, t1.state , if(t1.state = ?, t1.coupon_user_id, NULL) AS valueAddCoupon , t1.user_id AS memberUserId , CASE  WHEN start_add_time > ? THEN ? WHEN DATE_ADD(start_add_time, INTERVAL add_days DAY) > ? AND state = ? THEN ? WHEN DATE_ADD(start_add_time, INTERVAL add_days + keeping_days DAY) > ? AND DATE_ADD(start_add_time, INTERVAL add_days DAY) < ? AND state = ? THEN ? WHEN DATE_ADD(start_add_time, INTERVAL add_days + keeping_days DAY) < ? AND amount_added > ? AND state = ? THEN ? ELSE ? END AS addedStatus FROM value_added.value_added_user t1 JOIN value_added.`value_added_user_extend` t2 ON t1.id = t2.id WHERE t1.tenant_wechatapp_id = ? AND t2.dept_erp_id = ? AND t2.employee_erp_id IN (?) AND t2.sales_date >= ? AND t2.sales_date < ? AND t1.state != ? LIMIT ?|1|2|2||0|0|16807|16807|3|3|
|gift_mail|SELECT count(0) 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) AS address , if(t.trade_type = ?, pl.id, it.barcode) AS barcode , if(t.trade_type = ?, pl.default_image_url, p.default_image_url) AS defaultImageUrl FROM trade t LEFT JOIN trade_take tt ON t.tenant_wechatapp_id = tt.tenant_wechatapp_id AND t.id = tt.trade_id LEFT JOIN trade_addr ta ON t.tenant_wechatapp_id = ta.tenant_wechatapp_id AND t.id = ta.trade_id LEFT JOIN product p ON p.id = t.product_id LEFT JOIN platform_product pl ON pl.id = t.product_id LEFT JOIN inventory it ON it.product_id = t.product_id AND it.specification = t.specification LEFT JOIN trade_express te ON te.tenant_wechatapp_id = t.tenant_wechatapp_id AND te.trade_id = t.id WHERE t.mobile_no LIKE ? AND t.tenant_wechatapp_id = ? AND t.trade_type = ? ORDER BY create_time DESC ) tmp_count|1|1|1||0|0|13299|13299|1|1|
|v4_user|SELECT t1.maintain_shop_id, t1.maintain_employee_id, t1.maintain_level, count(*) AS maintainNum FROM potential_customer t1 WHERE t1.tenant_app_id = ? AND t1.`status` IN (?) AND t1.next_maintain_time >= ? AND t1.tenant_id = ? AND t1.tenant_app_id = ? GROUP BY t1.maintain_shop_id, t1.maintain_employee_id, t1.maintain_level|1|5|5||0|0|8428|8428|340|340|
|v4_employee|SELECT count(1) AS total_count, count(finish_time) AS finish_count FROM task_task t JOIN task_system_task_template t2 ON t.task_template_id = t2.id AND t2.status = ? AND t2.tenant_id = ? AND t2.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|1959|1959|1|1|
|wx_gateway|SELECT media_id FROM wx_gateway.wx_image WHERE tenant_app_id = ? AND state = ?|1|2|2||0|0|226564|226564|832|832|
|v4_user|SELECT id FROM potential_customer WHERE status IN (?) AND next_maintain_time < ? AND tenant_id = ? AND tenant_app_id = ?|1|4|4||0|0|7750|7750|401|401|
|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|6|6||0|0|2101724|2101724|1204|1204|
|v4_employee|SELECT count(*) AS total_count , ifnull(sum(if(finish_time, ?, ?)), ?) AS undo_count , ifnull(sum(if(finish_time AND accept_time IS NULL, ?, ?)), ?) AS finish_count , ifnull(sum(if(accept_time AND arrival_shop_time IS NULL, ?, ?)), ?) AS accept_count , ifnull(sum(if(arrival_shop_time AND trade_time IS NULL, ?, ?)), ?) AS arrival_shop_count , count(trade_time) AS trade_count, count(send_coupons) AS coupon_send_count , count(recv_coupons) AS coupon_recv_count , ifnull(sum(trade_amount), ?) AS trade_amount , ifnull(sum(trade_num), ?) AS trade_num FROM task_task WHERE task_type = ? AND `status` != ? AND task_template_id = ? AND tenant_id = ? AND tenant_app_id = ?|1|1|1||0|0|37403|37403|1|1|
|tenant|SELECT count(*) AS amount FROM sneak_guest WHERE tenant_app_id = ? AND status = ? AND create_shop_id = ? AND maintain_employee_id = ? AND create_time >= ? AND create_time <= ?|1|1|1||0|0|647|647|1|1|
||INSERT INTO user_service.wx_user_back SELECT * FROM user_service.wx_user WHERE wx_app_id = ? ON DUPLICATE KEY UPDATE update_time = now()|1|8|8||0|0|31579|31579|0|0|
|coupon_service|SELECT count(0) 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.create_time >= ? AND cu.create_time <= ? AND cu.template_id = ? AND cu.source = ?|1|2|2||0|0|3411|3411|1|1|
|v4_employee|SELECT e.shop_id, e.employee_id, e.employee_name FROM employee e JOIN ( SELECT DISTINCT employee_id FROM task_task WHERE status != ? AND task_template_id = ? AND shop_id = ? ) t ON e.employee_id = t.employee_id WHERE e.shop_id = ?|1|10|10||0|0|2836292|2836292|15|15|
|v4_user|SELECT COUNT(*) AS total FROM potential_customer pc WHERE EXISTS ( SELECT ? FROM potential_customer_maintain t1 WHERE pc.id = t1.potential_customer_id AND t1.create_time >= ? AND t1.create_time <= ? AND t1.maintain_employee_id = ? AND t1.event_type IN (?) AND t1.tenant_app_id = ? ) AND pc.tenant_app_id = ?|1|1|1||0|0|6055|6055|1|1|
|v4_employee|DELETE t FROM v4_employee.task_task t LEFT JOIN v4_employee.employee e ON t.tenant_id = e.tenant_id AND t.employee_id = e.employee_id WHERE t.tenant_id = ? AND e.id IS NULL|1|479|479||0|0|564598606|564598606|0|0|
|activity_service|SELECT t3.id, t1.activity_name AS activityName, t3.head_img_url AS headImgUrl, t3.user_name AS userName, t3.mobile_no AS mobileNo , t3.prize_type AS prizeType, t3.prize_name AS prizeName, t3.prize_image_url AS prizeImageUrl , DATE_FORMAT(t3.create_time, '%Y-%m-%d %H:%i:%s') AS prizeTime FROM activity t1 JOIN lottery_activity t2 ON t1.id = t2.activity_id JOIN lottery_winner t3 ON t2.id = t3.lottery_activity_id WHERE t2.id = ? ORDER BY t3.create_time DESC LIMIT ?|1|1|1||0|0|1993|1993|20|20|
|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|1296|1296|1|1|
|user_service|select tu.user_id,tm.shop_id,mb.erp_member_id memberErpId,tu.mobile_no,tu.user_name,ue.employee_id,tm.grade_id from user_service.tenant_member tu inner join user_service.tenant_member_info tm on tu.tenant_id = tm.tenant_id and tu.id = tm.id inner join user_service.tenant_member_bind mb on tu.tenant_id = mb.tenant_id and tu.id = mb.id left join user_service.user_employee ue on tu.tenant_app_id = ue.tenant_wechatapp_id and tu.user_id = ue.user_id where tu.tenant_id=? and tu.tenant_app_id = ? and tu.status=? and mb.erp_member_id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?\|1|5|5||0|0|1253896|1253896|270|270|
|mysql|DELETE FROM wx_gateway.wx_template_msg WHERE create_time < DATE_SUB(now(), INTERVAL ? DAY)|1|34|34||0|0|969412|969412|0|0|
|v4_user|SELECT COUNT(*) AS total FROM potential_customer pc WHERE EXISTS ( SELECT ? FROM potential_customer_maintain t1 WHERE pc.id = t1.potential_customer_id AND t1.create_time >= ? AND t1.create_time <= ? AND t1.event_type IN (?) AND t1.tenant_app_id = ? ) AND pc.tenant_app_id = ?|1|5|5||0|0|25165|25165|1|1|
|order|SELECT od.id, od.order_no AS orderNo, od.status, od.take_type AS takeType, od.create_time AS createTime , od.remark, od.total_fee AS totalFee, od.freight_fee AS freightFee, od.discount_fee AS discountFee, od.take_id AS takeId , od.payment_fee AS paymentFee, dt.product_id AS productId, dt.price, dt.quantity, dt.sku_id AS skuId , dt.art_no AS artNo, dt.image_url AS imageUrl, dt.product_name AS productName, dt.take_remark AS takeRemark, dt.take_day AS takeDay , od.product_fee AS productFee, od.finish_type AS finishType, od.send_time AS sendTime, od.receive_time AS receiveTime, od.finish_time AS finishTime , od.child_status AS childStatus, od.send_good_remark AS sendGoodRemark, od.service_flag AS serviceFlag, od.coupon_id AS couponId, od.tenant_wechatapp_id AS tenantAppId , od.tenant_id AS tenantId, od.pay_id AS payId, od.user_id AS userId, od.user_name AS userName, od.mobile_no AS 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|256389|256389|41|41|
|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|3|3||0|0|189214|189214|56|56|
|authorization_service|DELETE FROM account_role2 WHERE tenant_id = ? AND login_account_id = ? AND tenant_app_id = ? AND shop_id = ?|1|1|1||0|0|64963|64963|0|0|
|export|select coupon_id, create_time as writeoffTime, ifnull(employee_name,user_name) writeoffUserName, shop_name from coupon_service.coupon_write_off_log where tenant_app_id=? and coupon_id in|1|1|1||0|0|5459|5459|5459|5459|
|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|11218|11218|10|10|
|v4_sales|SELECT t1.sales_erp_id AS salesErpId, t1.sales_no AS salesNo, DATE_FORMAT(t1.sales_date, '%Y-%m-%d') AS salesDate , t1.member_erp_id AS memberId, t1.employee_erp_id AS employeeErpId, t1.employee_name AS employeeName, t1.assist_employee_erp_id AS assistEmployeeErpId, t1.assist_employee_name AS assistEmployeeName , t1.dept_erp_id AS deptErpId, t1.amount, t1.post_time AS postTime FROM erp_sales t1 WHERE t1.member_erp_id IN (?) AND t1.post_time >= ? AND t1.is_sales = ? AND t1.sales_status = ? AND t1.tenant_id = ? AND t1.tenant_app_id = ?|1|1|1||0|0|228|228|63|63|
|employee|SELECT id, scene, employee_id, member_user_name AS userName, finish_time , status FROM employee.backlog WHERE tenant_id = ? AND tenant_app_id = ? AND shop_id = ? AND expire_time BETWEEN ? AND ? AND scene = ? AND status = ? AND scene NOT IN (?) ORDER BY id DESC LIMIT ?|1|3|3||0|0|474314|474314|2|2|
|order|SELECT count(0) 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 NULL, wait_take_shop_id, take_shop_id) AS takeShopId , take_employee_user_name, o.receive_time, o.cancel_time, od.take_start_date, o.refund_start_time AS refundTime , o.user_name AS 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 NOT IN (?) ORDER BY o.id ) tmp_count|1|1|1||0|0|4811|4811|1|1|
|v4_employee|SELECT t.id AS task_id, t.employee_id, e.employee_name, t.member_id, t.member_name , t.finish_time, t.plan_arrival_shop_time, t.remark, tta.task_attaches 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 = ? ORDER BY t.finish_time DESC, t.id DESC LIMIT ?|1|1|1||0|0|271743|271743|5|5|
|v4_sales|SELECT COUNT(*) AS total FROM value_added_record WHERE value_added_id = ? AND tenant_id = ? AND tenant_app_id = ?|1|7|7||0|0|2071550|2071550|1|1|
|order|SELECT ifnull(sum(if(od.status = ?, ?, ?)), ?) AS "2" , ifnull(sum(if(od.status = ?, ?, ?)), ?) AS "3" , ifnull(sum(if(od.status = ?, ?, ?)), ?) AS "4" , ifnull(sum(if(od.status = ?, ?, ?)), ?) AS "5" , count(1) AS total , ifnull(sum(if(od.status > ?, od.payment_fee, ?)), ?) AS paymentFee , ifnull(sum(if(od.status > ?, od.offline_payment_fee, ?)), ?) AS offlinePaymentFee , ifnull(sum(if(od.status > ?, od.payment_fee + od.offline_payment_fee, ?)), ?) AS 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(?, ?, ?) AND (od.status = ?)|1|4|4||0|0|77289|77289|1|1|
|v4_employee|SELECT e.shop_id, e.employee_id, e.employee_name FROM employee e JOIN ( SELECT DISTINCT employee_id FROM task_task WHERE status = ? AND task_template_id = ? AND shop_id = ? ) t ON e.employee_id = t.employee_id WHERE e.shop_id = ?|1|42|42||0|0|2836277|2836277|0|0|
|v4_user|SELECT count(1) FROM ( SELECT member_points_id FROM member_points_detail d INNER JOIN member_points p ON p.id = d.member_points_id AND d.tenant_id = ? AND p.tenant_id = ? AND d.tenant_app_id = ? AND p.tenant_app_id = ? WHERE d.oper_time < ? AND d.status = ? AND p.balance > ? GROUP BY d.member_points_id HAVING sum(d.oper_amount) > ? ) temp|1|1|1||0|0|480713|480713|1|1|
|v4_employee|SELECT sum(ifnull(member_integral_balance <= ?, ?)) AS `integral_balance|2000分以下` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|2001-10000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|10001-30000分` , sum(ifnull(member_integral_balance BETWEEN ? AND ?, ?)) AS `integral_balance|30001-50000分` , sum(ifnull(member_integral_balance >= ?, ?)) AS `integral_balance|50001分以上` , sum(ifnull(shop_id = ?, ?)) AS `shop|岳阳友阿张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|岳阳九方店（步行街）` , sum(ifnull(shop_id = ?, ?)) AS `shop|宁乡吾悦张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|家润多张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|汉华张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|金都张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|华容周大生` , sum(ifnull(shop_id = ?, ?)) AS `shop|株洲天虹张万福` , sum(ifnull(shop_id = ?, ?)) AS `shop|湘潭天虹周六福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|长沙开福万达周大生珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|株洲万达张万福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|衡阳酃湖万达张万福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|株洲张万福珠宝（老公安局店）` , sum(ifnull(shop_id = ?, ?)) AS `shop|邵阳县凤凰城周六福珠宝1` , sum(ifnull(shop_id = ?, ?)) AS `shop|邵阳县凤凰城周大福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|天虹商场周六福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|运达汇周大生珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|株洲天虹周大生珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|板塘铺步步高周六福` , sum(ifnull(shop_id = ?, ?)) AS `shop|衡阳蒸湘万达周大生` , sum(ifnull(shop_id = ?, ?)) AS `shop|岳阳天虹周六福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|银盆岭万达周大生珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|海信广场周六福珠宝` , sum(ifnull(shop_id = ?, ?)) AS `shop|常德万|1|43|43||0|0|2833142|2833142|1|1|
|v4_employee|SELECT count(*) AS total_count, count(finish_time) AS finish_count FROM task_task t JOIN task_invite_task_template t2 ON t.task_template_id = t2.id AND t2.tenant_id = ? AND t2.tenant_app_id = ? WHERE t2.invite_time < ? AND t.end_time > ? AND t2.status IN (?) AND t.task_type = ? AND t.status = ? AND t.shop_id = ? AND t.tenant_id = ? AND t.tenant_app_id = ?|1|1|1||0|0|14976|14976|1|1|
||UPDATE v4_user.wx_user wu JOIN v4_user.member m ON wu.open_id = m.h5_open_id SET wu.member_id = m.id WHERE wu.member_id = ? AND m.tenant_id = ?|1|8|8||0|0|140119|140119|0|0|
|order|SELECT count(0) 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.take_type = ? AND (od.status = ? OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.finish_type = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.finish_type = ?)) AND ad.shop_id = ? AND dt.product_id = ? AND dt.sku_id = ?|1|12|12||0|0|102870|102870|1|1|
||DELETE FROM tenant.sjfx_dct_erp_sales_extend1 WHERE create_time < ?|1|5|5||0|0|420207|420207|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_role2 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 = ? AND ar.role_code IN (?)|1|1|1||0|0|64956|64956|3|3|
|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|1|1||0|0|286034|286034|788|788|
||SELECT * FROM employee.backlog WHERE create_time > ? ORDER BY id|1|1|1||0|0|154066|154066|26514|26514|
|value_added|SELECT count(0) FROM ( SELECT t1.id, t2.sales_no AS salesNo, DATE_FORMAT(t2.sales_date, '%Y-%m-%d') AS salesDate , DATE_FORMAT(t1.start_add_time, '%Y-%m-%d') AS valueAddDate, t2.dept_erp_id AS shopId , t1.shop_name AS shopName, t2.employee_erp_id AS userId, t2.employee_name AS userName, t1.product_name AS productName, t1.amount_pay AS amountPay , t1.id AS valueAddNo, t1.amount_added AS valueAddAmount, t1.state , if(t1.state = ?, t1.coupon_user_id, NULL) AS valueAddCoupon , t1.user_id AS memberUserId , CASE  WHEN start_add_time > ? THEN ? WHEN DATE_ADD(start_add_time, INTERVAL add_days DAY) > ? AND state = ? THEN ? WHEN DATE_ADD(start_add_time, INTERVAL add_days + keeping_days DAY) > ? AND DATE_ADD(start_add_time, INTERVAL add_days DAY) < ? AND state = ? THEN ? WHEN DATE_ADD(start_add_time, INTERVAL add_days + keeping_days DAY) < ? AND amount_added > ? AND state = ? THEN ? ELSE ? END AS addedStatus FROM value_added.value_added_user t1 JOIN value_added.`value_added_user_extend` t2 ON t1.id = t2.id WHERE t1.tenant_wechatapp_id = ? AND t2.dept_erp_id = ? AND t2.employee_erp_id IN (?) AND t2.sales_date >= ? AND t2.sales_date < ? AND t1.state != ? ) tmp_count|1|2|2||0|0|16400|16400|1|1|
||SELECT tm.mobile_no, wu.open_id FROM user_service.tenant_member_bind tmb JOIN user_service.tenant_member tm ON tmb.tenant_id = tm.tenant_id AND tmb.user_id = tm.user_id JOIN user_service.wx_user_back wu ON tmb.wx_user_id = wu.id WHERE tmb.tenant_id = ? AND tmb.tenant_app_id = ?|1|2|2||0|0|170580|170580|16842|16842|
|mysql|DELETE FROM message_push.message_log WHERE create_time < DATE_SUB(now(), INTERVAL ? DAY)|1|76|76||0|0|2761972|2761972|0|0|
|user_service|SELECT count(0) FROM user_service.tenant_member t1 JOIN user_service.tenant_member_info t2 ON t1.tenant_id = t2.tenant_id AND t1.id = t2.id AND t2.tenant_app_id = ? AND t2.shop_id = ? JOIN user_service.user_employee ue ON t1.tenant_id = ue.tenant_id AND t1.tenant_app_id = ue.tenant_wechatapp_id AND t1.user_id = ue.user_id AND ue.employee_id = ? AND ue.shop_id = ? WHERE t1.tenant_id = ? AND t1.tenant_app_id = ? AND (t1.mobile_no LIKE concat(?, ?) OR t1.user_name LIKE concat(?, ?, ?))|1|1|1||0|0|5348|5348|1|1|
||DELETE FROM tenant.sjfx_dct_erp_sales_detail WHERE create_time < ?|1|9|9||0|0|1056248|1056248|0|0|
|user_service|select * from user_service.tenant_member_info where tenant_id=? and tenant_app_id=? and user_id in|1|3|3||0|0|3338|3338|3338|3338|
|v4_sales|SELECT * FROM v4_sales.value_added_record WHERE value_added_id = ? AND date_format(create_time, '%Y-%m-%d') = ? AND tenant_id = ? AND tenant_app_id = ?|1|5|5||0|0|2068362|2068362|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 = ?|1|1|1||0|0|48760|48760|1|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_time < ?|1|2|2||0|0|3510|3510|9|9|
|coupon_service|SELECT count(0) 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 JOIN ( SELECT coupon_id FROM coupon_service.coupon_write_off_log wol WHERE wol.tenant_id = ? AND wol.tenant_app_id = ? AND wol.state = ? AND wol.create_time >= ? AND wol.create_time <= ? GROUP BY coupon_id ) w ON w.coupon_id = cu.id WHERE cu.tenant_id = ? AND cu.tenant_app_id = ?|1|1|1||0|0|9026|9026|1|1|
|order|SELECT ifnull(sum(if(od.status = ?, ?, ?)), ?) AS "2" , ifnull(sum(if(od.status = ?, ?, ?)), ?) AS "3" , ifnull(sum(if(od.status = ?, ?, ?)), ?) AS "4" , ifnull(sum(if(od.status = ?, ?, ?)), ?) AS "5" , ifnull(sum(if(od.status = ? AND od.child_status = ?, ?, ?)), ?) AS "9" , ifnull(sum(if(od.status = ? AND od.child_status = ?, ?, ?)), ?) AS "10" , ifnull(sum(if(od.status = ? AND od.finish_type = ?, ?, ?)), ?) AS "11" , ifnull(sum(if(od.status = ? AND od.child_status = ?, ?, ?)), ?) AS "12" , ifnull(sum(if(od.status = ? AND od.child_status = ?, ?, ?)), ?) AS "13" , ifnull(sum(if(od.status = ? AND od.child_status = ?, ?, ?)), ?) AS "14" , ifnull(sum(if(od.status = ? AND od.child_status = ?, ?, ?)), ?) AS "15" , ifnull(sum(if(od.status = ? AND od.child_status = ?, ?, ?)), ?) AS "16" , ifnull(sum(if(od.status = ? AND od.finish_type = ?, ?, ?)), ?) AS "17" , count(1) AS total , ifnull(sum(if(od.status > ?, od.payment_fee, ?)), ?) AS paymentFee , ifnull(sum(if(od.status > ?, od.offline_payment_fee, ?)), ?) AS offlinePaymentFee , ifnull(sum(if(od.status > ?, od.payment_fee + od.offline_payment_fee, ?)), ?) AS 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.take_type = ? AND (od.status = ? OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.finish_type = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.child_status = ?) OR (od.status = ? AND od.finish_type = ?))|1|12|12||0|0|138855|138855|1|1|
|v4_employee|SELECT * FROM v4_employee.task_task t LEFT JOIN v4_employee.employee e ON t.tenant_id = e.tenant_id AND t.tenant_app_id AND t.employee_id = e.employee_id WHERE t.tenant_id = ? AND e.id IS NULL|1|1|1||0|0|963557|963557|0|0|
||DELETE FROM tenant.sjfx_dct_erp_sales WHERE create_time < ?|1|3|3||0|0|443775|443775|0|0|
||DELETE FROM tenant.sjfx_dct_erp_sales_detail_extend WHERE create_time < ?|1|6|6||0|0|648827|648827|0|0|
|value_added|UPDATE value_added_user SET amount_added = IF(? > (added_percent_per_day / ? * IF(? >= TIMESTAMPDIFF(DAY, DATE_FORMAT(start_add_time, '%Y-%m-%d'), CURRENT_DATE) + ? - add_days, TIMESTAMPDIFF(DAY, DATE_FORMAT(start_add_time, '%Y-%m-%d'), CURRENT_DATE) + ?, add_days) - devalue_percent_per_day / ? * IF(? >= TIMESTAMPDIFF(DAY, DATE_FORMAT(start_add_time, '%Y-%m-%d'), CURRENT_DATE) + ? - add_days - keeping_days, ?, TIMESTAMPDIFF(DAY, DATE_FORMAT(start_add_time, '%Y-%m-%d'), CURRENT_DATE) + ? - add_days - keeping_days)) * amount_pay, ?, (added_percent_per_day / ? * IF(? >= TIMESTAMPDIFF(DAY, DATE_FORMAT(start_add_time, '%Y-%m-%d'), CURRENT_DATE) + ? - add_days, TIMESTAMPDIFF(DAY, DATE_FORMAT(start_add_time, '%Y-%m-%d'), CURRENT_DATE) + ?, add_days) - devalue_percent_per_day / ? * IF(? >= TIMESTAMPDIFF(DAY, DATE_FORMAT(start_add_time, '%Y-%m-%d'), CURRENT_DATE) + ? - add_days - keeping_days, ?, TIMESTAMPDIFF(DAY, DATE_FORMAT(start_add_time, '%Y-%m-%d'), 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|2101717|2101717|0|0|
|v4_employee|SELECT ? AS task_type, t2.type AS system_task_type, t.task_template_id, count(1) AS total_count , count(finish_time) AS finish_count FROM task_task t JOIN task_system_task_template t2 ON t.task_template_id = t2.id AND t2.status = ? AND t2.tenant_id = ? AND t2.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 = ? GROUP BY t.task_template_id, t2.type|1|1|1||0|0|7903|7903|4|4|
|v4_user|SELECT id, member_id, employee_id, shop_id, tenant_id, tenant_app_id, create_time, update_time FROM member_butler WHERE (member_id IN|1|1|1||0|0|16678|16678|16678|16678|
|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 = ?|1|1|1||0|0|91948|91948|1|1|
