|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|account|SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.shop_id,tb.erp_member_id AS memberId,t?.enter_shop_time AS enterShopTime,t?.employee_id,t?.received_time AS receivedTime FROM customer.tenant_user_received t? JOIN user_service.tenant_member_bind tb ON tb.tenant_id=t?.tenant_id AND tb.tenant_app_id=t?.tenant_app_id AND tb.user_id=t?.user_id AND tb.tenant_id=? WHERE t?.tenant_app_id=? AND t?.create_time>=? AND t?.create_time<=? LIMIT ? OFFSET ?|1|1|1||0|0|8135|8135|1|1|
|export|SELECT cu.id couponId,cu.coupon_name,cu.coupon_type,CASE cu.coupon_type WHEN ? THEN ? ELSE ? END couponTypeName,cu.coupon_no, CASE cu.source WHEN ? THEN ? ELSE ? END couponChannelName, CASE cu.coupon_state WHEN ? THEN ? ELSE ? END couponStateName,ce.user_name,ce.creator_user_name,round(cu.face_value/?,?) AS faceValue,round(cu.balance/?,?) AS balance,cu.begin_time,cu.end_time,ce.remark,ce.mobile_no,ce.creator_mobile_no,cu.create_time,ce.writeoff_time,cu.user_id,if(ce.source_user_type=?,ce.source_user_id,?)employeeId,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 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=? AND cu.create_time>=? AND cu.create_time<=?|1|2|2||0|0|7078|7078|1141|1141|
|account|SELECT t?.id,tb.tenant_id,t?.tenant_wechatapp_id AS tenantAppId,t?.employee_erp_id AS saleEmployeeId,t?.dept_erp_id AS saleDeptId,t?.erp_sales_id AS salesErpId,tb.erp_member_id AS memberId,t?.warranty_no AS warrantyNo,(CASE t?.is_disable WHEN ? THEN ? ELSE ? END) AS status,t?.create_time AS operTime,t?.has_read hasRead FROM warranty_service.warranty t? JOIN user_service.tenant_member_bind tb ON tb.tenant_id=? AND tb.tenant_app_id=t?.tenant_wechatapp_id AND tb.user_id=t?.user_id WHERE t?.tenant_wechatapp_id=? AND t?.version IN (?) AND t?.is_disable=? AND t?.update_time>=? AND t?.update_time<=? ORDER BY t?.id ASC LIMIT ? OFFSET ?|1|1|1||0|0|84|84|28|28|
|gift_mail|SELECT * FROM `trade_take`|1|1|1||0|0|213139|213139|213139|213139|
|employee|SELECT * FROM `backlog_file`|1|58|58||0|0|10352940|10352940|10352940|10352940|
|v4_user|SELECT t.tenant_id,t.tenant_app_id,ifnull(s.dept_id,?) AS deptId,ifnull(e.employee_erp_id,?) AS empErpId,t.shop_id,t.employee_id,t.employee_name,t.`status`,t.create_time FROM v4_employee.employee t LEFT JOIN tenant.employee e ON t.tenant_id AND e.tenant_id AND t.employee_id=e.id LEFT JOIN v4_employee.shop s ON t.shop_id=s.id WHERE t.tenant_app_id=?|1|1|1||0|0|23218|23218|1696|1696|
|account|SELECT t.id,t.tenant_id,t.tenant_app_id,t.coupon_name,(CASE t.status WHEN ? THEN ? ELSE ? END) AS coupon_status,(CASE t.coupon_type WHEN ? THEN ? ELSE ? END) AS coupon_type,t.create_time FROM (SELECT ct.id,ct.tenant_id,ct.tenant_app_id,ct.coupon_name,ct.state status,ct.coupon_type,ct.create_time FROM coupon_service.template ct WHERE ct.tenant_id=? AND ct.tenant_app_id=? UNION ALL SELECT ct.id,? AS tenant_id,? AS tenant_app_id,ct.coupon_name,ct.state status,ct.coupon_type,ct.create_time FROM coupon_service.template ct WHERE ct.tenant_id=?)t ORDER BY id ASC|1|1|1||0|0|44838|44838|41|41|
|v4_user|SELECT DATE_FORMAT(tt?.recept_time,?) AS statistic_date,DATE_FORMAT(tt?.recept_time,?) AS statistic_month,tt?.tenant_id,tt?.tenant_app_id,tt?.shop_id,tt?.employee_id,tt?.fieldName,tt?.fieldValue,count(*) AS total FROM (SELECT t?.recept_time,t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id,? AS fieldName,TRIM(? FROM JSON_EXTRACT(t?.checkin_labels,concat(SUBSTRING(TRIM(? FROM JSON_SEARCH(t?.checkin_labels,?,?)),?,LOCATE(?,TRIM(? FROM JSON_SEARCH(t?.checkin_labels,?,?)))-?),?))) AS fieldValue FROM v4_user.reception_customer t? WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.create_time>=? AND t?.create_time<? AND JSON_CONTAINS(t?.checkin_labels,JSON_OBJECT(?,?)))tt? GROUP BY DATE_FORMAT(tt?.recept_time,?),DATE_FORMAT(tt?.recept_time,?),tt?.tenant_id,tt?.tenant_app_id,tt?.shop_id,tt?.employee_id,tt?.fieldName,tt?.fieldValue|1|1|1||0|0|112697|112697|117|117|
|erp_sync|SELECT * FROM `sync_record_?`|1|66|66||0|0|3115040|3115040|3115040|3115040|
|account|SELECT DISTINCT vu.tenant_wechatapp_id tenant_app_id,date_format(vu.create_time,?)statistic_date,date_format(ue.sales_date,?)busi_date FROM value_added.value_added_user vu INNER JOIN value_added.value_added_user_extend ue ON vu.id=ue.id WHERE vu.tenant_wechatapp_id=? AND vu.update_time>=? AND vu.update_time<=? AND vu.state=? AND ue.sales_date IS NOT ?|1|1|1||0|0|8219|8219|0|0|
|v4_user|SELECT count(*) FROM v4_activity.lottery_log t WHERE t.tenant_id=? AND t.tenant_app_id=? AND t.member_id=? AND t.create_time>=? AND t.create_time<DATE_ADD(?,INTERVAL ? day)|1|1|1||0|0|17373|17373|1|1|
|v4_coupon|SELECT count(*) FROM v4_sales.erp_sales_detail WHERE sales_type=? LIMIT ?|1|84|84||0|0|14611766|14611766|1|1|
|user_service|SELECT * FROM `tenant_member_change_shop`|1|18|18||0|0|2977695|2977695|2977695|2977695|
|message_push|SELECT * FROM `message_log`|1|40|40||0|0|2693496|2693496|2693496|2693496|
|account|SELECT * FROM (SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.share_user_id AS user_id,t?.user_name AS user_name,t?.share_user_type AS user_identity,t?.business_id AS activity_id,t?.activity_name AS activity_name,DATE_FORMAT(oi.finish_time,?) AS busi_date,count(*) AS deal_amount,ifnull(sum(oi.total_fee),?) AS deal_money FROM goods.`share` t? JOIN goods.share_detail sd ON t?.id=sd.share_id JOIN ORDER.order_info oi ON sd.order_id=oi.id AND oi.tenant_wechatapp_id=? AND oi.status=? JOIN activity_service.activity t? ON t?.business_id=t?.id JOIN user_service.tenant_member t? ON t?.tenant_id=t?.tenant_id AND t?.tenant_app_id=t?.tenant_app_id AND t?.share_user_id=t?.user_id WHERE t?.tenant_app_id=? AND t?.share_user_type=? AND t?.business_type!=? AND oi.finish_time>=? AND oi.finish_time<=? GROUP BY t?.id,DATE_FORMAT(oi.finish_time,?) UNION ALL SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.share_user_id AS user_id,t?.employee_name AS user_name,t?.share_user_type AS user_identity,t?.business_id AS activity_id,t?.activity_name AS activity_name,DATE_FORMAT(oi.finish_time,?) AS busi_date,count(*) AS deal_amount,ifnull(sum(oi.total_fee),?) AS deal_money FROM goods.`share` t? JOIN goods.share_detail sd ON t?.id=sd.share_id JOIN ORDER.order_info oi ON sd.order_id=oi.id AND oi.tenant_wechatapp_id=? AND oi.status=? JOIN activity_service.activity t? ON t?.business_id=t?.id JOIN tenant.employee t? ON t?.share_user_id=t?.id WHERE t?.tenant_app_id=? AND t?.share_user_type=? AND t?.business_type!=? AND oi.finish_time>=? AND oi.finish_time<=? GROUP BY t?.id,DATE_FORMAT(oi.finish_time,?))tt ORDER BY tt.id ASC LIMIT ? OFFSET ?|1|1|1||0|0|2926|2926|0|0|
|account|SELECT es.sales_date,es.tenant_id,es.tenant_wechatapp_id tenant_app_id,es.dept_erp_id shop_id,es.employee_erp_id user_id,count(*)amount,sum(if(tu.id>?,?,?))register_amount FROM tenant.erp_sales es LEFT JOIN user_service.tenant_user tu ON es.tenant_id=tu.tenant_id AND es.tenant_wechatapp_id=tu.tenant_app_id AND es.member_erp_id=tu.erp_member_id WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.sales_status=? AND es.is_sales=? AND es.create_time>=? AND es.create_time<=? GROUP BY es.tenant_id,es.tenant_wechatapp_id,es.sales_date,es.dept_erp_id,es.employee_erp_id|1|2|2||0|0|2001|2001|172|172|
|erp_sync|SELECT * FROM `cwx_checkin_sync_log`|1|9|9||0|0|268334|268334|268334|268334|
|employee|SELECT * FROM `batch_job_execution_params`|1|1|1||0|0|638134|638134|638134|638134|
