|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|warranty_service|INSERT LOW_PRIORITY IGNORE INTO `warranty_service`.`_warranty_new` (`id`, `tenant_wechatapp_id`, `user_id`, `erp_sales_id`, `update_user_id` , `warranty_no`, `warranty_data`, `has_read`, `is_disable`, `create_time` , `update_time`, `version`, `source_id`, `warranty_img_url`, `upload_frequency` , `v2_img_url`, `sales_no`, `employee_erp_id`, `dept_erp_id`, `sales_date` , `update_employee_id`, `style_id`) SELECT `id`, `tenant_wechatapp_id`, `user_id`, `erp_sales_id`, `update_user_id` , `warranty_no`, `warranty_data`, `has_read`, `is_disable`, `create_time` , `update_time`, `version`, `source_id`, `warranty_img_url`, `upload_frequency` , `v2_img_url`, `sales_no`, `employee_erp_id`, `dept_erp_id`, `sales_date` , `update_employee_id`, `style_id` FROM `warranty_service`.`warranty` FORCE INDEX (`PRIMARY`) WHERE `id` >= ? AND `id` <= ? LOCK IN SHARE MODE|454|767|8||0|0|838396|6403|0|0|
|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 ?|280|639|7||0|0|4943826|37523|277|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 = ?|145|247|5||0|0|575305|28240|145|1|
|user_service|SELECT count(0) FROM user_service.tenant_member t1 JOIN user_service.tenant_member_info t2 ON t1.tenant_id = t2.tenant_id AND t1.id = t2.id 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 = ?|115|397|66||0|0|1310491|99076|115|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|89|141|3||0|0|132164|1997|60733|908|
|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 mb.erp_member_id IN (?)|71|179|12||0|0|27079369|1322439|4316|224|
|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 = ?|45|63|5||0|0|238138|15439|45|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 ?|44|147|12||0|0|15857045|1085581|12|1|
|v4_user|SELECT id, checkin_employee_name, maintain_employee_name FROM potential_customer WHERE (external_user_id = ? OR member_id = ?) AND status IN (?) AND tenant_id = ? AND tenant_app_id = ? ORDER BY id ASC|44|99|5||0|0|328844|7821|12|1|
|gift_mail|SELECT count(*) FROM gift_mail.trade t LEFT JOIN gift_mail.trade_take tt ON tt.trade_id = t.id WHERE t.tenant_id = ? AND t.tenant_wechatapp_id = ? AND t.trade_type IN (?) AND t.order_status = ? AND t.take_type = ? AND tt.shop_id = ?|43|62|5||0|0|207552|15407|43|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 = ?|41|73|9||0|0|141676|5155|41|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|52|2||0|0|4962355|160685|155|5|
|v4_sales|SELECT id, template_id, no, member_id, erp_sales_id , product_barcode, product_name, dept_id, amount_total, amount_pay , added_amount, added_rate, added_days, keep_days, impairment_rate , exchange_days, added_time, status, coupon_id, tenant_id , tenant_app_id, create_time, update_time FROM value_added WHERE member_id = ? AND status <> ? AND tenant_id = ? AND tenant_app_id = ?|30|55|3||0|0|1815380|60560|64|11|
|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 = ?|30|88|11||0|0|644728|33992|30|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 = ?|29|47|3||0|0|1877579|64770|679|49|
|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 = ?|27|86|10||0|0|210198|7816|5|1|
|corpwx|UPDATE external_user SET un_assign_flag = ? WHERE tenant_id = ? AND status = ? AND un_assign_flag = ?|26|105|11||0|0|835000|77140|0|0|
|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|4166690|161035|26|1|
|v4_sales|SELECT COUNT(*) AS total FROM v4_sales.erp_sales es LEFT JOIN v4_sales.warranty w ON w.sales_id = es.id AND w.tenant_id = ? AND w.tenant_app_id = ? WHERE is_sales = ? AND sales_status = ? AND (es.sales_no LIKE concat(?, ?) OR es.member_erp_id = ?) AND w.id IS NULL AND es.tenant_id = ? AND es.tenant_app_id = ?|25|77|7||0|0|5128570|363401|25|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 = ?|24|41|5||0|0|29330|2412|24|1|
|v4_sales|SELECT count(DISTINCT sales_date) FROM v4_sales.erp_sales WHERE member_erp_id IN (?) AND is_sales = ? AND sales_status = ? AND tenant_id = ? AND tenant_app_id = ?|19|38|5||0|0|220555|13786|19|1|
|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 = ?|18|30|3||0|0|204553|30509|18|1|
|user_service|SELECT t1.id, t1.user_id AS userId, t1.user_name AS userName, t1.sex, t1.mobile_no AS mobileNo , t1.head_img_url AS headImg FROM user_service.tenant_member t1 JOIN user_service.tenant_member_info t2 ON t1.tenant_id = t2.tenant_id AND t1.id = t2.id 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 ?|17|206|65||0|0|718246|102436|170|10|
|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')|17|220|34||0|0|2075659|310407|17409|3273|
|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 = ?|16|23|3||0|0|103839|13926|16|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 < ?|16|68|12||0|0|1840673|115043|0|0|
|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|15|32|7||0|0|43095|3698|30|2|
|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 ?|15|51|11||0|0|3630339|595442|45|10|
|warranty_service|SELECT count(0) FROM ( SELECT tenant_wechatapp_id, shopId, sum(total) AS total , sum(`read`) AS `read`, sum(notRead) AS notRead FROM ( SELECT tenant_wechatapp_id, sales_date, dept_erp_id AS shopId, count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE tenant_wechatapp_id = ? AND is_disable = ? AND sales_date BETWEEN date_format(?, '%Y-%m-%d') AND date_format(?, '%Y-%m-%d') GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id ) w GROUP BY tenant_wechatapp_id, shopId ) table_count|14|460|89||0|0|1390156|137221|14|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 = ?)|14|23|2||0|0|3347233|493905|14|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 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 = ?|13|18|2||0|0|55612|11157|22|4|
|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 = ?)|11|16|3||0|0|24857|3171|11|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 ?|11|22|6||0|0|4333322|393974|11|1|
|activity_service|SELECT date_format(create_time, '%Y-%m-%d') AS `date`, count(*) AS quantity FROM activity_service.online_sign_user_sign_log WHERE tenant_app_id = ? AND DATE_FORMAT(create_time, '%Y-%m-%d') BETWEEN ? AND ? GROUP BY date_format(create_time, '%Y-%m-%d')|11|29|5||0|0|5079061|461762|8|1|
|v4_sales|SELECT COUNT(*) AS total FROM v4_sales.erp_sales es LEFT JOIN v4_sales.warranty w ON w.sales_id = es.id AND w.tenant_id = ? AND w.tenant_app_id = ? WHERE is_sales = ? AND sales_status = ? AND (es.sales_no LIKE concat(?, ?) OR es.member_erp_id = ?) AND w.id IS NOT NULL AND es.tenant_id = ? AND es.tenant_app_id = ?|11|20|3||0|0|297954|106144|11|1|
|authorization_service|INSERT INTO user_login_token (id, platform_user_id, user_id, wx_user_id, wx_app_user_id , employee_id, shop_id, tenant_id, tenant_wx_app_id, account_id , login_way, login_code, login_token, roles, status , expire_time, create_time, update_time, login_ip, login_time , login_data) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?)|10|18|2||0|0|0|0|0|0|
|warranty_service|SELECT tenant_wechatapp_id, shopId, sum(total) AS total , sum(`read`) AS `read`, sum(notRead) AS notRead FROM ( SELECT tenant_wechatapp_id, sales_date, dept_erp_id AS shopId, count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE tenant_wechatapp_id = ? AND is_disable = ? AND sales_date BETWEEN date_format(?, '%Y-%m-%d') AND date_format(?, '%Y-%m-%d') GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id ) w GROUP BY tenant_wechatapp_id, shopId LIMIT ?|10|399|83||0|0|1371592|137201|192|20|
|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 = ?|10|14|2||0|0|24551|3255|10|1|
|v4_sales|SELECT count(s.sales_erp_id) FROM ( SELECT esd.product_barcode, max(esd.sales_erp_id) AS sales_erp_id, max(esd.category_erp_id) AS category_erp_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 = ? 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 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 = ? LEFT 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 = ? LEFT 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 va.id IS NULL AND i.id IS NULL AND vat.id IS NOT NULL|10|14|2||0|0|80962|17572|10|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 mb.erp_member_id in|10|53|21||0|0|12353417|1890074|4244|667|
|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 (?)|9|10|1||0|0|372|57|124|19|
|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 = ?|9|16|4||0|0|19774|2199|2|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|9|18|4||0|0|154585|44920|9|1|
|user_service|SELECT count(0) FROM user_service.tenant_member t1 JOIN user_service.tenant_member_info t2 ON t1.tenant_id = t2.tenant_id AND t1.id = t2.id 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(?, ?, ?))|9|13|2||0|0|18298|3810|9|1|
|v4_sales|SELECT * FROM erp_sales WHERE member_erp_id = ? AND is_sales = ? AND sales_status = ? AND id < ? AND tenant_id = ? AND tenant_app_id = ? ORDER BY sales_date ASC, sales_erp_id ASC LIMIT ?|9|32|18||0|0|345660|54281|9|1|
|user_service|SELECT count(0) FROM user_service.tenant_member tm JOIN user_service.tenant_member_info tmi ON tm.tenant_id = tmi.tenant_id AND tm.id = tmi.id LEFT JOIN user_service.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 = ?|8|34|8||0|0|280195|98849|8|1|
|activity_service|SELECT count(*) FROM online_sign_user WHERE tenant_app_id = ? AND day > ?|8|13|3||0|0|1115974|139508|8|1|
|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 = ?|8|17|4||0|0|43024|6700|8|1|
|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 = ?|8|37|9||0|0|195329|37522|8|1|
|corpwx|SELECT count(*) AS addedNum FROM external_user t WHERE t.tenant_id = ? AND t.corp_user_id = ? AND t.create_time >= ? AND t.create_time < ?|7|8|1||0|0|71112|34670|7|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 = ?|7|9|1||0|0|30939|5647|7|1|
|tenant|SELECT e.id, e.employee_name FROM ( SELECT DISTINCT sgm.employee_id FROM tenant.sneak_guest sg JOIN tenant.sneak_guest_maintain sgm ON sgm.sneak_guest_id = sg.id WHERE sg.tenant_id = ? AND sg.tenant_app_id = ? AND sg.update_shop_id = ? AND sgm.event_type IN (?) AND (sg.fail_type IS NULL OR sg.fail_type = ?) AND sgm.create_time BETWEEN ? AND ? ) t JOIN tenant.employee e ON e.id = t.employee_id|7|30|6||0|0|316926|97693|42|9|
|corpwx|INSERT INTO mini_app_msg (id, tenant_id, to_user, msg_type, msg_scene , msg_id, msg_content, status, err_msg, template_id) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ?)|6|7|1||0|0|0|0|0|0|
|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 = ?))|6|8|2||0|0|130057|21677|4|1|
|v4_employee|SELECT COUNT(*) AS total FROM task_task t JOIN employee e ON e.employee_id = t.employee_id AND e.shop_id = t.shop_id AND e.tenant_id = ? AND e.tenant_app_id = ? LEFT JOIN ( SELECT task_id, GROUP_CONCAT(file_url SEPARATOR '|') AS task_attaches FROM task_task_attach WHERE tenant_id = ? AND tenant_app_id = ? GROUP BY task_id ) tta ON t.id = tta.task_id WHERE t.status = ? AND system_task_type = ? AND t.shop_id = ? AND finish_time >= ? AND finish_time < ? AND t.employee_id = ? AND t.tenant_id = ? AND t.tenant_app_id = ?|6|16|9||0|0|1320807|262229|6|1|
||SELECT w.id, w.create_time FROM ( SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? AND is_disable = ? GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ? ) t JOIN warranty_service.warranty w ON t.tenant_wechatapp_id = w.tenant_wechatapp_id AND t.erp_sales_id = w.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|6|26|9||0|0|2218598|607608|0|0|
|tenant|SELECT id, tenant_id, tenant_app_id, user_id, status , group_label, maintain_level, remark, create_time, create_shop_id , create_employee_id, update_time, update_shop_id, update_employee_id, sales_amount , next_maintain_date, maintain_employee_id, sneak_guest_no, last_maintain_date, finish_date , fail_type, oid, user_type FROM sneak_guest WHERE tenant_app_id = ? AND status = ? AND create_shop_id = ? ORDER BY id DESC|5|5|1||0|0|39574|8212|19787|4106|
|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 = ?|5|7|1||0|0|440442|164229|5|1|
|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|1331832|462827|398|142|
|employee|UPDATE backlog_system SET status = ?, finish_time = now() WHERE tenant_app_id = ? AND scene = ?|5|54|32||0|0|2980190|1372450|0|0|
|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|9|4||0|0|6520|1486|3260|743|
|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 = ?|5|6|1||0|0|1355|271|665|133|
|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 = ?|5|7|1||0|0|12152|6409|5|1|
|warranty_service|SELECT count(*) FROM warranty WHERE user_id = ? AND tenant_wechatapp_id = ? AND is_disable = ?|5|36|9||0|0|65968|15274|5|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 ?|5|6|1||0|0|1311143|262229|5|1|
|tenant|SELECT sales_erp_id FROM tenant.erp_sales es JOIN tenant.erp_sales_ignore ei ON ei.tenant_id = ? AND ei.tenant_app_id = ? AND es.sales_erp_id = ei.erp_sales_id WHERE es.tenant_id = ? AND es.tenant_wechatapp_id = ? AND member_erp_id = ?|5|7|2||0|0|47463|9691|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 = ? WHERE t1.tenant_id = ? AND t1.tenant_app_id = ?|4|4|1||0|0|369934|234900|4|1|
|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|4|5|1||0|0|6779642|5381202|4|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 = ?|4|4|1||0|0|6942|3106|450|188|
|v4_coupon|UPDATE v4_coupon.coupon SET coupon_status = ? WHERE tenant_id = ? AND tenant_app_id = ? AND coupon_status = ? AND end_time < now()|4|6|3||0|0|786006|768893|0|0|
|activity_service|SELECT count(*) FROM online_sign_user_sign_log WHERE tenant_app_id = ?|4|7|2||0|0|1846904|461729|4|1|
|employee|SELECT count(0) FROM employee.backlog t WHERE t.tenant_id = ? AND t.tenant_app_id = ? AND t.employee_id = ? AND t.begin_time >= ? AND t.expire_time < ? AND t.`status` != ? AND t.scene = ?|4|12|6||0|0|29512|12608|4|1|
|tenant|SELECT count(*) AS amount FROM sneak_guest WHERE tenant_app_id = ? AND status = ? AND create_shop_id = ? AND create_time <= ?|4|4|1||0|0|15681|4106|4|1|
|v4_employee|SELECT COUNT(*) FROM ( SELECT t.id AS task_id, task_type , if(task_type = ?, st.description, it.description) AS description , if(task_type = ?, st.quick_reply, it.quick_reply) AS quick_reply , task_name, member_id, member_name, member_mobile_no, member_sex , member_level, t.start_time, t.end_time , datediff(t.end_time, NULL) AS left_days, send_coupons , recv_coupons, st.coupons, t.accept_time, t.plan_arrival_shop_time, t.arrival_shop_time , t.trade_time FROM task_task t LEFT JOIN task_system_task_template st ON st.id = t.task_template_id AND st.tenant_id = ? AND st.tenant_app_id = ? LEFT JOIN task_invite_task_template it ON it.id = t.task_template_id AND it.tenant_id = ? AND it.tenant_app_id = ? WHERE t.status = ? AND task_type = ? AND task_template_id = ? AND shop_id = ? AND employee_id = ? AND finish_time IS NULL AND t.end_time > now() AND t.tenant_id = ? AND t.tenant_app_id = ? ) TOTAL|4|5|1||0|0|8308|2142|4|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 ?|4|28|17||0|0|1917100|595148|12|4|
|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 = ?|4|12|7||0|0|131338|46689|4|1|
|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 = ?|4|4|1||0|0|3087|1468|4|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 = ?|4|6|1||0|0|435048|164229|4|1|
|v4_user|SELECT id, member_id, external_user_id, serial_number, checkin_shop_id , checkin_employee_id, checkin_employee_name, checkin_time, maintain_shop_id, maintain_employee_id , maintain_employee_name, first_maintain_time, last_maintain_time, next_maintain_time, maintain_num , intention_num, latest_intention, status, finish_time, finish_shop_id , deal_employee_id, deal_employee_name, deal_sale_amount, fail_employee_id, fail_employee_name , fail_reason, remark, sex, cutomer_grade, maintain_level , tenant_id, tenant_app_id, create_time, update_time FROM potential_customer WHERE (member_id = ? OR external_user_id = ?) AND status IN (?) AND maintain_shop_id = ? AND tenant_id = ? AND tenant_app_id = ?|3|4|1||0|0|6588|2196|0|0|
|coupon_service|SELECT cu.id, cu.coupon_name, cu.coupon_type, cu.coupon_no, cu.source AS couponChannel , cu.coupon_state, ce.user_name, ce.creator_user_name AS creatorName , if(coupon_type IN (?), cu.face_value, round(cu.face_value / ?, ?)) AS faceValue , cu.begin_time, cu.end_time, ce.remark, ce.mobile_no, ce.creator_mobile_no , cu.create_time, cu.user_id , round(cu.balance / ?, ?) AS balance , ce.source_user_id, ce.source_user_type, ce.member_source_shop FROM coupon_service.coupon cu JOIN coupon_service.coupon_extend ce ON ce.tenant_id = ? AND ce.tenant_app_id = ? AND ce.id = cu.id WHERE cu.tenant_id = ? AND cu.tenant_app_id = ? AND cu.coupon_name LIKE CONCAT(CONCAT(?, ?), ?) LIMIT ?|3|6|3||0|0|610506|203502|60|20|
|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|24|18||0|0|134289|44763|3|1|
|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|5|2||0|0|193389|64464|3|1|
||SELECT w.id, w.create_time FROM ( SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty WHERE create_time >= ? AND is_disable = ? GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ? ) t JOIN warranty_service.warranty w ON t.tenant_wechatapp_id = w.tenant_wechatapp_id AND t.erp_sales_id = w.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|3|34|29||0|0|294078|127252|734|367|
|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 (?)|3|8|5||0|0|145491|95774|28|17|
|warranty_service|SELECT count(id) FROM warranty_data|3|32|13||0|0|38797679|12934493|3|1|
|tenant|SELECT count(*) FROM sneak_guest WHERE tenant_app_id = ? AND status = ? AND create_shop_id = ? AND maintain_employee_id = ?|3|4|2||0|0|1616|786|3|1|
|user_service|select tenant_id, id, tenant_app_id, user_id, shop_id, birthday, birthday_is_lunar, address, memorial_name, memorial_day, memorial_day_is_lunar, interest, grade_id, create_time, update_time from tenant_member_info where tenant_id = ? and tenant_app_id = ? and user_id in|3|3|1||0|0|9901|4000|9901|4000|
|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(?, ?, ?)|3|24|18||0|0|134289|44763|3|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.coupon_name LIKE CONCAT(CONCAT(?, ?), ?)|3|88|43||0|0|649476|216492|3|1|
||SELECT * FROM warranty_service.warranty_data WHERE create_time > ? AND warranty_data IS NOT NULL|3|26|13||0|0|41656|18333|41656|18333|
||SELECT * FROM ( SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty WHERE create_time > ? AND is_disable = ? GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ? ) t JOIN warranty_service.warranty w ON t.tenant_wechatapp_id = w.tenant_wechatapp_id AND t.erp_sales_id = w.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|3|43|39||0|0|302506|127067|734|367|
||SELECT w.* FROM warranty_service.warranty w JOIN ( SELECT w.tenant_wechatapp_id, w.erp_sales_id FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ? ) t ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE w.warranty_data IS NULL AND wd.warranty_data IS NOT NULL AND wd.erp_sales_id IS NULL|3|7|4||0|0|116757|45859|3660|1285|
|position|COMMIT ?|3|3|1||0|0|0|0|0|0|
|order|SELECT max(create_time) FROM `order`.order_operator_log WHERE tenant_wechatapp_id = ? AND order_id = ?|3|14|5||0|0|3165332|1055117|3|1|
|warranty_service|INSERT INTO warranty (id, tenant_wechatapp_id, user_id, erp_sales_id, warranty_no , is_disable, version, upload_frequency, update_employee_id, employee_erp_id , dept_erp_id, sales_no, sales_date, style_id) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?, ?, ?, ?)|3|3|1||0|0|0|0|0|0|
|v4_employee|SELECT COUNT(*) AS total FROM task_task WHERE task_template_id = ? AND tenant_id = ? AND tenant_app_id = ?|3|4|1||0|0|112209|37403|3|1|
||SELECT * FROM warranty_service.warranty w JOIN ( SELECT w.tenant_wechatapp_id, w.erp_sales_id FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ? ) t ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|3|4|1||0|0|129945|43315|1674|558|
|warranty_service|SELECT count(0) FROM ( SELECT tenant_wechatapp_id, dept_erp_id, employeeId, sum(total) AS total , sum(`read`) AS `read`, sum(notRead) AS notRead FROM ( SELECT tenant_wechatapp_id, sales_date, dept_erp_id, employee_erp_id AS employeeId , count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE tenant_wechatapp_id = ? AND dept_erp_id = ? AND is_disable = ? AND sales_date BETWEEN date_format(?, '%Y-%m-%d') AND date_format(?, '%Y-%m-%d') GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id, employee_erp_id ) w GROUP BY tenant_wechatapp_id, dept_erp_id, employeeId ) table_count|2|75|45||0|0|271646|135823|2|1|
|employee|SELECT count(*) FROM employee.backlog WHERE tenant_id = ? AND tenant_app_id = ? AND shop_id = ? AND status = ? AND expire_time BETWEEN ? AND ?|2|5|3||0|0|25061|12830|2|1|
|erp_app|INSERT INTO app_status (id, tenant_id, app_name, version, pid) VALUES (?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE version = ?, pid = ?, online_status_time = ?|2|3|1||0|0|0|0|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|2|1||0|0|27904|13952|0|0|
|gift_mail|SELECT count(0) FROM ( SELECT p.id, p.default_image_url, p.product_name, p.product_type, p.tag_price , ifnull(pp.integral_price, ifnull(( SELECT min(inventory.price) FROM gift_mail.inventory WHERE inventory.product_id = p.id ), ?)) AS price , p.volume, p.category_id, p.product_status, ? AS quantity, pp.partner_id AS partner_id , p.topping FROM gift_mail.product p LEFT JOIN gift_mail.partner_product pp ON p.id = pp.product_id LEFT JOIN gift_mail.product_status ps ON ps.product_id = p.id WHERE p.tenant_id = ? AND product_status = ? AND (p.is_disable IS NULL OR p.is_disable = ?) AND (ps.tenant_wechatapp_id = ? OR p.product_type = ?) ) p WHERE p.topping = ?|2|2|1||0|0|34465|17243|2|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|2|2|1||0|0|10007|5004|0|0|
|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|2|5|4||0|0|80850|40425|2|1|
|tenant|INSERT INTO erp_sales_detail (id, tenant_id, tenant_wechatapp_id, sales_erp_id, sales_index , sales_type, product_barcode, product_name, cert_no, hand_size , category_erp_id, category_name, stone_weight, gold_weight, total_weight , quantity, amount_total, amount_pay, integral, remark) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE update_time = now(), sales_type = ?, product_barcode = ?, product_name = ?, cert_no = ? , hand_size = ?, category_erp_id = ?, category_name = ?, stone_weight = ?, gold_weight = ? , total_weight = ?, quantity = ?, amount_total = ?, amount_pay = ?, integral = ? , remark = ?|2|3|2||0|0|0|0|0|0|
|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|2|5|4||0|0|23100|11550|11550|5775|
|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|25|13||0|0|1539548|770479|161|83|
|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 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|2|1||0|0|1251|908|223|184|
||SELECT count(1) FROM warranty_service.warranty|2|25|13||0|0|25864553|12932279|2|1|
|goods|SELECT count(0) FROM ( SELECT gs.id, gs.category_id, gs.goods_name, gs.style_no, gs.status , gs.thumbnail_img, gs.express_type, gs.take_stock_day, gs.take_remark, gs.express_fee , ifnull(gs.base_sale_number, ?) + ifnull(t1.sales_volume, ?) AS total_sales_volume , ifnull(ifnull(t2.quantity, t3.quantity), ?) AS total_quantity , ifnull(ifnull(t2.price, t3.price), ?) AS min_price , gs.create_time, gs.exchange_money, ifnull(t2.number, ?) AS skuNumber , ifnull(t3.number, ?) AS activitySkuNumber FROM goods.goods gs LEFT JOIN goods.goods_category cg ON gs.category_id = cg.id INNER JOIN goods.goods_up_app t ON gs.id = t.goods_id AND t.tenant_app_id = ? LEFT JOIN ( SELECT tenant_app_id, goods_id, sum(sales_volume) AS sales_volume FROM goods.goods_sku GROUP BY tenant_app_id, goods_id ) t1 ON t.tenant_app_id = t1.tenant_app_id AND t.goods_id = t1.goods_id LEFT JOIN ( SELECT tenant_app_id, goods_id, sum(quantity) AS quantity , min(price) AS price, count(*) AS number FROM goods.goods_sku WHERE activity_id = ? GROUP BY tenant_app_id, goods_id ) t2 ON t.tenant_app_id = t2.tenant_app_id AND t.goods_id = t2.goods_id LEFT JOIN ( SELECT tenant_app_id, goods_id, sum(quantity) AS quantity , min(price) AS price, count(*) AS number FROM goods.goods_sku WHERE activity_id > ? GROUP BY tenant_app_id, goods_id ) t3 ON t.tenant_app_id = t3.tenant_app_id AND t.goods_id = t3.goods_id WHERE 1 = 1 AND gs.topping = ? ) tmp|2|2|1||0|0|257856|129386|2|1|
|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|2|3|2||0|0|51038|25519|0|0|
|user_service|SELECT * FROM user_employee WHERE tenant_wechatapp_id = ? AND employee_id = ?|2|2|1||0|0|6378|3544|6378|3544|
|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|6|4||0|0|12109|6768|11|10|
|warranty_service|SELECT tenant_wechatapp_id, dept_erp_id, employeeId, sum(total) AS total , sum(`read`) AS `read`, sum(notRead) AS notRead FROM ( SELECT tenant_wechatapp_id, sales_date, dept_erp_id, employee_erp_id AS employeeId , count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE tenant_wechatapp_id = ? AND dept_erp_id = ? AND is_disable = ? AND sales_date BETWEEN date_format(?, '%Y-%m-%d') AND date_format(?, '%Y-%m-%d') GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id, employee_erp_id ) w GROUP BY tenant_wechatapp_id, dept_erp_id, employeeId LIMIT ?|2|50|25||0|0|271636|135818|10|5|
|tenant|INSERT INTO erp_sales (id, tenant_id, tenant_wechatapp_id, sales_erp_id, sales_no , sales_date, member_erp_id, employee_erp_id, employee_name, dept_erp_id , amount, sales_remark, receipts, sales_status, is_sales , busi_date) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?) ON DUPLICATE KEY UPDATE sales_date = ?, member_erp_id = ?, employee_erp_id = ?, employee_name = ?, dept_erp_id = ? , amount = ?, sales_remark = ?, receipts = ?, sales_status = ?, is_sales = ? , busi_date = ?|2|2|1||0|0|0|0|0|0|
|warranty_service|SELECT count(id) FROM warranty|2|25|12||0|0|25865542|12933297|2|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 ?|2|5|3||0|0|651846|325923|2|1|
||SELECT w.id FROM ( SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty WHERE create_time > ? AND is_disable = ? GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ? ) t JOIN warranty_service.warranty w ON t.tenant_wechatapp_id = w.tenant_wechatapp_id AND t.erp_sales_id = w.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|2|4|2||0|0|254344|127188|734|367|
|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|18163|9082|2|1|
|warranty_service|INSERT INTO warranty (id, tenant_wechatapp_id, user_id, erp_sales_id, warranty_no , is_disable, update_employee_id, employee_erp_id, dept_erp_id, sales_no , sales_date, style_id) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?, ?)|2|3|2||0|0|0|0|0|0|
|mysql|DELETE FROM message_push.message_log WHERE create_time < DATE_SUB(now(), INTERVAL ? DAY)|1|81|81||0|0|2955821|2955821|0|0|
||SELECT w.id, w.create_time FROM ( SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty WHERE create_time > ? AND is_disable = ? GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ? ) t JOIN warranty_service.warranty w ON t.tenant_wechatapp_id = w.tenant_wechatapp_id AND t.erp_sales_id = w.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|1|3|3||0|0|127228|127228|367|367|
|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 (?)|1|1|1||0|0|58635|58635|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|8|8||0|0|8490|8490|357|357|
||SELECT * FROM warranty_service.warranty w JOIN ( SELECT w.tenant_wechatapp_id, w.erp_sales_id FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ? ) t ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NOT NULL|1|1|1||0|0|45653|45653|2896|2896|
|corpwx_license|SELECT corp_id, agent_id, corp_wx_user_id, max(blocked_time) AS blocked_time FROM app_blocked WHERE corp_wx_user_id = ? AND tenant_id = ? GROUP BY corp_id, agent_id, corp_wx_user_id|1|1|1||0|0|19971|19971|0|0|
||SELECT * FROM warranty_service.warranty w WHERE create_time > ? AND NOT EXISTS ( SELECT ? FROM warranty_service.warranty_data wd WHERE create_time > ? AND warranty_data IS NOT NULL AND wd.id = w.id ) LIMIT ?|1|1|1||0|0|17190|17190|100|100|
|message_push|INSERT INTO message_log (id, tenant_id, tenant_app_id, user_id, scene_type , msg_id, post_data, create_time, update_time) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?)|1|1|1||0|0|0|0|0|0|
||SELECT * FROM warranty_service.warranty WHERE create_time > ?|1|1|1||0|0|5001|5001|5001|5001|
||SELECT * FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ?|1|2|2||0|0|37576|37576|1727|1727|
|mysql|DELETE FROM wx_gateway.wx_template_msg WHERE create_time < DATE_SUB(now(), INTERVAL ? DAY)|1|33|33||0|0|951017|951017|0|0|
||SELECT tenant_wechatapp_id, shopId, sum(total) AS total , sum(`read`) AS `read`, sum(notRead) AS notRead FROM ( SELECT tenant_wechatapp_id, sales_date, dept_erp_id AS shopId, count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE tenant_wechatapp_id = ? AND is_disable = ? AND sales_date BETWEEN ? AND ? GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id ) w GROUP BY tenant_wechatapp_id, shopId|1|42|42||0|0|137147|137147|19|19|
|erp_sync|SELECT * FROM erp_sync.retry_data WHERE (need_erp_member_id = ? OR (need_erp_member_id = ? AND erp_member_id IS NOT NULL)) AND retry_times > ? ORDER BY id|1|1|1||0|0|3632|3632|64|64|
|warranty_service|SELECT id FROM warranty_data WHERE tenant_wechatapp_id = ?|1|1|1||0|0|636213|636213|636213|636213|
||SELECT tenant_wechatapp_id, shopId, sum(total) AS total , sum(`read`) AS `read`, sum(notRead) AS notRead FROM ( SELECT tenant_wechatapp_id, sales_date, dept_erp_id AS shopId, count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE is_disable = ? AND sales_date BETWEEN ? AND ? GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id ) w GROUP BY tenant_wechatapp_id, shopId|1|3|3||0|0|321559|321559|1307|1307|
|v4_coupon|SELECT COUNT(*) AS total FROM coupon WHERE coupon_status = ? AND member_id = ? AND tenant_id = ? AND tenant_app_id = ?|1|3|3||0|0|6857|6857|1|1|
||SELECT * FROM warranty_service.warranty WHERE warranty_data IS NOT NULL|1|21|21||0|0|1558614|1558614|0|0|
||SELECT * FROM warranty_service.warranty w WHERE NOT EXISTS ( SELECT ? FROM warranty_service.warranty_data wd WHERE create_time > ? AND warranty_data IS NOT NULL AND wd.id = w.id )|1|12|12||0|0|130498|130498|65249|65249|
||DELETE FROM tenant.sjfx_dct_erp_sales_detail WHERE create_time < ?|1|1|1||0|0|449719|449719|0|0|
|user_service|SELECT count(*) FROM user_service.tenant_member_info t WHERE t.tenant_id = ? AND t.tenant_app_id = ? AND t.shop_id = ?|1|1|1||0|0|15287|15287|1|1|
||SELECT count(1) FROM warranty_service.warranty w WHERE EXISTS ( SELECT * FROM warranty_service.warranty_copy2 c2 WHERE c2.id = w.id )|1|25|25||0|0|12935027|12935027|1|1|
||DELETE FROM tenant.sjfx_dct_erp_sales_detail_extend WHERE create_time < ?|1|1|1||0|0|258424|258424|0|0|
|authorization_service|UPDATE user_login_token SET 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_data = ? WHERE id = ?|1|1|1||0|0|1|1|0|0|
|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()|1|1|1||0|0|0|0|0|0|
||SELECT w.id, w.create_time FROM warranty_service.warranty w JOIN ( SELECT w.tenant_wechatapp_id, w.erp_sales_id FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ? ) t ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id|1|1|1||0|0|46211|46211|3454|3454|
|authorization_service|update user_login_token set status=? where login_token in|1|1|1||0|0|537|537|0|0|
|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 sg.status = ?|1|1|1||0|0|4176|4176|1|1|
|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|2089428|2089428|0|0|
|warranty_service|INSERT INTO warranty (id, tenant_wechatapp_id, user_id, erp_sales_id, warranty_no , is_disable, version, upload_frequency, update_employee_id, employee_erp_id , dept_erp_id, sales_no, sales_date) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?, ?, ?)|1|1|1||0|0|0|0|0|0|
|v4_sales|SELECT COUNT(*) AS total FROM warranty WHERE member_id IN (?) AND is_disable = ? AND tenant_id = ? AND tenant_app_id = ?|1|3|3||0|0|8400|8400|1|1|
|warranty_service|SELECT id FROM warranty|1|37|37||0|0|12932251|12932251|12932251|12932251|
||SELECT w.* FROM warranty_service.warranty w JOIN ( SELECT w.tenant_wechatapp_id, w.erp_sales_id FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ? ) t ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|1|1|1||0|0|43315|43315|558|558|
|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|12|12||0|0|2089430|2089430|1119|1119|
|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|786|786|1|1|
|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|462692|462692|63|63|
||SELECT * FROM warranty_service.warranty_data wd WHERE id IN ( SELECT max(w.id) FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ? )|1|89|89||0|0|1605245|1605245|0|0|
|goods|SELECT id, img_url, img_index FROM goods_img WHERE goods_id = ? ORDER BY update_time DESC|1|1|1||0|0|27432|27432|1|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 = ?|1|1|1||0|0|6548|6548|3274|3274|
|warranty_service|SELECT count(id) FROM warranty WHERE tenant_wechatapp_id > ?|1|14|14||0|0|12932240|12932240|1|1|
|user_service|SELECT tm.user_id AS id, tm.user_name AS userName, tm.head_img_url AS headImgUrl, tm.user_name AS nickName, tm.mobile_no AS mobile , tm.sex FROM user_service.tenant_member tm JOIN user_service.user_employee ue ON ue.tenant_id = ? AND ue.tenant_wechatapp_id = ? AND tm.user_id = ue.user_id AND ue.employee_id = ? AND ue.shop_id = ? WHERE tm.tenant_id = ? AND tm.tenant_app_id = ? ORDER BY tm.id DESC LIMIT ?|1|1|1||0|0|2772|2772|12|12|
||SELECT tenant_wechatapp_id, shopId, sum(total) AS total , sum(`read`) AS `read`, sum(notRead) AS notRead FROM ( SELECT tenant_wechatapp_id, sales_date, dept_erp_id AS shopId, count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE tenant_wechatapp_id = ? AND is_disable = ? AND sales_date BETWEEN date_format(?, '%Y-%m-%d') AND date_format(?, '%Y-%m-%d') GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id ) w GROUP BY tenant_wechatapp_id, shopId|1|13|13||0|0|47272|47272|0|0|
|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 >= ?|1|2|2||0|0|647|647|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|90909|90909|1|1|
|tenant|SELECT count(*) FROM tenant.sneak_guest_maintain s JOIN tenant.sneak_guest sg ON sg.tenant_id = s.tenant_id AND sg.tenant_app_id = s.tenant_app_id AND sg.id = s.sneak_guest_id JOIN tenant.employee e ON e.tenant_id = s.tenant_id AND e.id = s.employee_id WHERE s.tenant_id = ? AND s.tenant_app_id = ? AND sg.create_shop_id = ? AND (sg.fail_type IS NULL OR sg.fail_type = ?) AND s.event_type = ? AND s.create_time BETWEEN ? AND ?|1|1|1||0|0|663|663|1|1|
|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|103|103||0|0|11443661|11443661|1249|1249|
|v4_sales|SELECT id, sales_erp_id, sales_no, sales_date, member_erp_id , employee_erp_id, employee_name, assist_employee_erp_id, assist_employee_name, dept_erp_id , amount, sales_remark, receipts, sales_status, is_sales , busi_date, erp_create_time, recommend_id, post_time, tenant_id , tenant_app_id, create_time, update_time FROM erp_sales WHERE sales_no = ? AND tenant_id = ? AND tenant_app_id = ?|1|1|1||0|0|175899|175899|0|0|
|message_push|INSERT INTO message_log (id, tenant_id, tenant_app_id, user_id, scene_type , msg_id, content, post_data, create_time, update_time) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ?)|1|1|1||0|0|0|0|0|0|
|gift_mail|SELECT count(0) FROM ( SELECT p.*, sp.take_type , ifnull(pp.integral_price, ifnull(( SELECT min(inventory.price) FROM inventory WHERE inventory.product_id = p.id ), ?)) AS price , ifnull(t.quantity, ?) AS quantity, pt.partner_name AS vendorName , ? AS distance, c.categroy_name AS categroy_name, pp.partner_id FROM product p INNER JOIN category c ON c.id = p.category_id LEFT JOIN self_product sp ON p.id = sp.product_id LEFT JOIN partner_product pp ON p.id = pp.product_id LEFT JOIN partner pt ON pt.id = pp.partner_id LEFT JOIN ( SELECT product_id, sum(quantity) AS quantity FROM gift_mail.inventory GROUP BY product_id ) t ON p.id = t.product_id WHERE p.is_disable IS NULL OR p.is_disable = ? ) p LEFT JOIN product_status ps ON p.id = ps.product_id AND ps.tenant_wechatapp_id = ? WHERE p.tenant_id = ? AND p.product_type = ? AND (ps.id IS NOT NULL OR p.tenant_wechatapp_id = ?)|1|1|1||0|0|53397|53397|1|1|
||SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty WHERE is_disable = ? GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ?|1|67|67||0|0|103945|103945|0|0|
|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|1|2|2||0|0|1582|1582|115|115|
|goods|SELECT count(0) FROM ( SELECT gs.id, gs.tenant_id, gs.tenant_app_id, gs.category_id, gs.activity_id , gs.goods_name, gs.style_no, gs.base_sale_number, gs.limit_sale , if(gs.status = ?, gs.status, if(t.id IS NULL, ?, ?)) AS status , gs.thumbnail_img, gs.express_type, gs.take_stock_day, gs.take_remark, gs.express_fee , gs.create_time, gs.update_time, gs.sale_type, gs.take_start_time, gs.page_id , gs.pay_way, gs.advance_payment, gs.exchange_money , ifnull(sku.minPrice, ?) AS minPrice , ifnull(sku.marketPrice, ?) AS marketPrice , ifnull(sku.totalSalesVolume, ?) AS totalSalesVolume , ifnull(sku.totalQuantity, ?) AS totalQuantity , ifnull(number, ?) AS skuNumber, gs.topping FROM goods.goods gs LEFT JOIN ( SELECT id, goods_id FROM goods.goods_up_app gu WHERE gu.tenant_app_id = ? ) t ON gs.id = t.goods_id LEFT JOIN ( SELECT goods_id, min(price) AS minPrice, max(market_price) AS marketPrice , sum(sales_volume) AS totalSalesVolume, sum(quantity) AS totalQuantity , count(*) AS number FROM goods.goods_sku WHERE activity_id = ? GROUP BY tenant_id, goods_id ) sku ON sku.goods_id = gs.id WHERE gs.tenant_id = ? AND gs.status < ? ORDER BY gs.topping DESC, sku.totalSalesVolume DESC, gs.id DESC ) tmp_count|1|1|1||0|0|67508|67508|1|1|
||SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ?|1|8|8||0|0|3163319|3163319|5001|5001|
|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|255005|255005|62|62|
|v4_sales|SELECT COUNT(*) AS total FROM v4_sales.warranty w JOIN v4_sales.erp_sales es ON es.id = w.sales_id AND es.tenant_id = ? AND es.tenant_app_id = ? WHERE w.member_id IN (?) AND is_disable = ? AND w.tenant_id = ? AND w.tenant_app_id = ?|1|5|5||0|0|16613|16613|1|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|1|1|1||0|0|2500|2500|500|500|
|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|254943|254943|0|0|
|v4_sales|SELECT rownum FROM ( SELECT erp_employee_id, average, @rank := @rank + ? AS rownum FROM ( SELECT erp_employee_id, round(avg(c.average_score), ?) AS average FROM v4_sales.comment c WHERE c.tenant_id = ? AND c.tenant_app_id = ? AND c.erp_dept_id = ? AND c.create_time BETWEEN ? AND ? GROUP BY c.erp_employee_id ) a, ( SELECT @rank := ? ) b ORDER BY average DESC ) r WHERE r.erp_employee_id = ?|1|1|1||0|0|31979|31979|0|0|
|v4_user|SELECT COUNT(*) AS total FROM member_butler t1 JOIN member t2 ON t1.tenant_id = t2.tenant_id AND t1.member_id = t2.id AND t2.tenant_id = ? AND t2.tenant_app_id = ? WHERE t1.shop_id = ? AND t1.employee_id = ? AND t1.tenant_id = ? AND t1.tenant_app_id = ?|1|1|1||0|0|14730|14730|1|1|
|v4_activity|SELECT ? AS member_id , ( SELECT count(1) FROM lottery_log WHERE activity_id = ? AND member_id = ? AND qualified_id = ? AND tenant_id = ? AND tenant_app_id = ? ) AS play_count , ( SELECT count(1) FROM lottery_log WHERE win_status = ? AND activity_id = ? AND member_id = ? AND qualified_id = ? AND tenant_id = ? AND tenant_app_id = ? ) AS play_count_win|1|1|1||0|0|20016|20016|1|1|
||SELECT count(1) FROM warranty_service.warranty_data|1|11|11||0|0|12931628|12931628|1|1|
|order|SELECT id FROM order_operator_log WHERE tenant_wechatapp_id = ? AND order_id = ? AND (src_child_status = ? AND dst_child_status = ?) ORDER BY create_time DESC LIMIT ?|1|6|6||0|0|1055083|1055083|0|0|
|employee|UPDATE backlog SET leave_flag = ? WHERE tenant_app_id = ? AND employee_id = ?|1|1|1||0|0|6159|6159|0|0|
||SELECT w.id, w.create_time FROM warranty_service.warranty w JOIN ( SELECT w.tenant_wechatapp_id, w.erp_sales_id FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ? ) t ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|1|1|1||0|0|43315|43315|558|558|
|sms|SELECT count(0) FROM ( SELECT a.phone_numbers AS phoneNo , CONCAT(?, a.sign_name, ?, CASE  WHEN b.content IS NOT NULL THEN b.content WHEN stc.content IS NOT NULL THEN stc.content ELSE a.template_param END) AS content , a.template_code, a.out_id AS outId, a.template_param, a.create_time AS sendTime, a.create_time AS recevieTime , a.code AS state , ifnull(ifnull(e.sms_size, ?) * if(a.code = ?, a.send_count, ?), ?) AS send_count , a.message, a.source_type FROM sms_send a LEFT JOIN sms.sms_send_extend e ON a.biz_id = e.biz_id LEFT JOIN sms_template b ON a.template_code = b.code LEFT JOIN sms_template_custom stc ON a.tenant_app_id = stc.tenant_app_id AND a.template_code = stc.code AND stc.status = ? WHERE a.tenant_id = ? AND a.tenant_app_id = ? ORDER BY a.create_time DESC ) tmp_count|1|3|3||0|0|4865|4865|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|72929|72929|1|1|
|mysql|DELETE FROM warranty_service.warranty WHERE id IN ( SELECT id FROM warranty_service.warranty_copy2 )|1|116|116||0|0|12935133|12935133|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|48315|48315|18|18|
|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 <= ?|1|1|1||0|0|1292|1292|1|1|
||SELECT * FROM warranty_service.warranty WHERE create_time <= ? ORDER BY id DESC LIMIT ?|1|7|7||0|0|848446|848446|0|0|
||SELECT tenant_wechatapp_id, sales_date, dept_erp_id, employee_erp_id AS employeeId , count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE sales_date BETWEEN ? AND ? AND tenant_wechatapp_id = ? AND dept_erp_id = ? AND is_disable = ? GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id, employee_erp_id|1|15|15||0|0|47416|47416|0|0|
|mysql|INSERT INTO warranty_service.warranty_copy2 SELECT w.* FROM warranty_service.warranty w JOIN ( SELECT w.tenant_wechatapp_id, w.erp_sales_id FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ? ) t ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id WHERE wd.id IS NULL|1|1|1||0|0|63640|63640|0|0|
||SELECT tenant_wechatapp_id, count(1) FROM warranty_service.warranty GROUP BY tenant_wechatapp_id|1|27|27||0|0|12932324|12932324|436|436|
|v4_activity|SELECT COUNT(*) AS total FROM lottery_log l WHERE l.win_status = ? AND l.win_prize_id IS NOT NULL AND l.activity_id = ? AND l.member_id = ? AND qualified_id = ? AND l.tenant_id = ? AND l.tenant_app_id = ?|1|1|1||0|0|10008|10008|1|1|
||SELECT * FROM warranty_service.warranty w WHERE create_time > ? AND NOT EXISTS ( SELECT * FROM warranty_service.warranty_data wd WHERE wd.id = w.id )|1|106|106||0|0|3077572|3077572|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.role_code IN (?)|1|1|1||0|0|64718|64718|0|0|
|v4_user|SELECT maintain_employee_id, id FROM potential_customer WHERE maintain_shop_id = ? AND status IN (?) AND tenant_id = ? AND tenant_app_id = ?|1|1|1||0|0|1195|1195|63|63|
|user_service|SELECT count(0) FROM ( SELECT count(1) FROM user_source us WHERE us.tenant_id = ? AND us.tenant_wechatapp_id = ? AND us.from_id = ? AND us.shop_id = ? AND us.create_time >= ? AND us.create_time < ? AND us.source_type = ? AND us.from_id IS NOT NULL AND us.shop_id IS NOT NULL ) table_count|1|2|2||0|0|1238|1238|1|1|
||SELECT * FROM warranty_service.warranty w WHERE EXISTS ( SELECT * FROM warranty_service.warranty_copy2 c2 WHERE c2.id = w.id )|1|15|15||0|0|1562727|1562727|0|0|
|tenant|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 ) ORDER BY es.sales_date DESC LIMIT ?|1|1|1||0|0|5379940|5379940|10|10|
|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|2|2||0|0|1202057|1202057|0|0|
|activity_service|SELECT count(*) > ? FROM activity_service.online_sign_user_sign_log WHERE tenant_app_id = ? AND user_id = ? AND to_days(create_time) = to_days(?)|1|1|1||0|0|810|810|1|1|
|value_added|SELECT ID, tenant_wechatapp_id AS tenantWechatappId, user_id AS userId, template_id AS templateId, sales_erp_id AS saleserpid , product_name AS productName, shop_name AS shopName, product_barcode AS productBarcode, amount_total AS amountTotal, amount_pay AS amountPay , amount_added AS amountAdded, state AS state, add_days, added_percent_per_day AS addedPercentPerDay, devalue_percent_per_day AS devaluePercentPerDay , keeping_days AS keepingDays, exchange_days AS exchangeDays, coupon_user_id AS couponUserId, sales_index AS salesIndex, start_add_time AS createtime , DATE_ADD(start_add_time, INTERVAL add_days - ? DAY) , DATE_ADD(start_add_time, INTERVAL add_days + keeping_days - ? DAY) FROM value_added_user WHERE state = ? AND start_add_time = date_add(CURDATE(), INTERVAL ? * (add_days + keeping_days - ?) DAY)|1|2|2||0|0|2089430|2089430|962|962|
|wx_gateway|SELECT count(0) FROM wx_template_msg WHERE tenant_id = ? AND tenant_app_id = ?|1|2|2||0|0|9113|9113|1|1|
|v4_user|SELECT t1.id, t1.external_user_id AS externalUserId, t1.checkin_time, t1.maintain_num AS maintainNum , if(t2.event_type = ?, t1.next_maintain_time, NULL) AS nextMaintainTime , t2.event_type AS `status` , CASE t2.event_type WHEN ? THEN ? WHEN ? THEN ? ELSE ? END AS statusName, t2.create_time AS maintainTime FROM potential_customer_maintain t2 JOIN potential_customer t1 ON t1.id = t2.potential_customer_id AND t1.tenant_id = ? AND t1.tenant_app_id = ? WHERE t2.maintain_shop_id = ? AND t2.maintain_employee_id = ? AND t2.create_time >= ? AND t2.create_time < ? AND t2.event_type IN (?) AND t2.tenant_id = ? AND t2.tenant_app_id = ? ORDER BY t2.id LIMIT ?|1|2|2||0|0|5051|5051|10|10|
||SELECT * FROM ( SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty WHERE create_time > ? AND is_disable = ? GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ? ) t JOIN warranty_service.warranty w ON t.tenant_wechatapp_id = w.tenant_wechatapp_id AND t.erp_sales_id = w.tenant_wechatapp_id LEFT JOIN warranty_service.warranty_data wd ON wd.id = w.id|1|1|1||0|0|38287|38287|0|0|
|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|7777|7777|397|397|
|v4_user|SELECT id FROM member_points_detail WHERE member_points_id = ? AND oper_biz_id = ? AND oper_biz_type = ? AND status = ? AND tenant_id = ? AND tenant_app_id = ? LIMIT ?|1|1|1||0|0|849|849|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|64719|64719|1|1|
||SELECT * FROM ( SELECT tenant_wechatapp_id, erp_sales_id, count(1) FROM warranty_service.warranty WHERE create_time > ? AND is_disable = ? GROUP BY tenant_wechatapp_id, erp_sales_id HAVING count(1) > ? ) t JOIN warranty_service.warranty w ON t.tenant_wechatapp_id = w.tenant_wechatapp_id AND t.erp_sales_id = w.tenant_wechatapp_id|1|4|4||0|0|124231|124231|0|0|
|employee|SELECT tenant_id, tenant_app_id, employee_id, scene, shop_id , count(*) AS record FROM backlog WHERE tenant_app_id = ? AND employee_id = ? AND expire_time >= ? AND status IN (?) AND shop_id = ? AND scene NOT IN (?) GROUP BY tenant_id, tenant_app_id, employee_id, scene, shop_id|1|1|1||0|0|666|666|2|2|
|v4_user|SELECT checkin_time, id FROM potential_customer WHERE maintain_shop_id = ? AND status IN (?) AND tenant_id = ? AND tenant_app_id = ?|1|1|1||0|0|1195|1195|63|63|
|warranty_service|INSERT INTO warranty_data (id, warranty_data, create_time, update_time) VALUES (?, ?, now(), now())|1|1|1||0|0|0|0|0|0|
|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|1|1|1||0|0|576|576|3|3|
|v4_coupon|SELECT COUNT(*) AS total FROM ( SELECT DISTINCT c.id, c.activity_name, c.push_time, c.tag_id, c.butler_call_member FROM v4_coupon.tag_push_coupon c JOIN v4_coupon.tag_push_coupon_log l ON l.tag_push_coupon_id = c.id AND l.push_coupon_state = ? AND l.tenant_id = ? AND l.tenant_app_id = ? WHERE c.push_state = ? AND c.butler_visible = ? AND l.shop_id = ? AND l.employee_id = ? AND c.push_time >= ? AND c.tenant_id = ? AND c.tenant_app_id = ? ORDER BY c.push_time DESC ) c|1|1|1||0|0|255676|255676|1|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 ?|1|1|1||0|0|58623|58623|1|1|
|user_service|SELECT t1.id, t1.user_id AS userId, t1.user_name AS userName, t1.sex, t1.mobile_no AS mobileNo , t1.head_img_url AS headImg FROM user_service.tenant_member t1 JOIN user_service.tenant_member_info t2 ON t1.tenant_id = t2.tenant_id AND t1.id = t2.id AND t2.tenant_app_id = ? AND t2.shop_id = ? WHERE t1.tenant_id = ? AND t1.tenant_app_id = ? AND (t1.mobile_no LIKE concat(?, ?) OR t1.user_name LIKE concat(?, ?, ?)) ORDER BY t1.id DESC LIMIT ?|1|1|1||0|0|476330|476330|1|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 ?|1|2|2||0|0|463222|463222|2|2|
||SELECT tenant_wechatapp_id, dept_erp_id, employeeId, sum(total) AS total , sum(`read`) AS `read`, sum(notRead) AS notRead FROM ( SELECT tenant_wechatapp_id, sales_date, dept_erp_id, employee_erp_id AS employeeId , count(*) AS total , sum(if(has_read, ?, ?)) AS `read` , sum(if(has_read, ?, ?)) AS notRead FROM warranty_service.warranty WHERE tenant_wechatapp_id = ? AND dept_erp_id = ? AND is_disable = ? AND sales_date BETWEEN ? AND ? GROUP BY tenant_wechatapp_id, sales_date, dept_erp_id, employee_erp_id ) w GROUP BY tenant_wechatapp_id, dept_erp_id, employeeId|1|51|51||0|0|135815|135815|5|5|
||SELECT w.tenant_wechatapp_id, w.erp_sales_id, count(1) FROM ( SELECT tenant_wechatapp_id, erp_sales_id FROM warranty_service.warranty WHERE create_time BETWEEN ? AND ? ) t JOIN warranty_service.warranty w ON w.tenant_wechatapp_id = t.tenant_wechatapp_id AND w.erp_sales_id = t.erp_sales_id GROUP BY w.tenant_wechatapp_id, w.erp_sales_id HAVING count(1) > ?|1|1|1||0|0|37576|37576|1727|1727|
|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|1|2|2||0|0|1249|1249|4|4|
|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 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|229|229|63|63|
|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|1|1||0|0|3387|3387|8|8|
|warranty_service|UPDATE warranty_service.warranty_data SET has_read = ? WHERE tenant_wechatapp_id = ? AND id = ?|1|2|2||0|0|1|1|0|0|
