|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|user_service|SELECT * FROM `tenant_member_change_shop`|1|15|15||0|0|2970115|2970115|2970115|2970115|
|message_push|SELECT * FROM `message_log`|1|41|41||0|0|2611825|2611825|2611825|2611825|
|account|SELECT count(?) FROM tenant.erp_sales t? LEFT JOIN tenant.erp_sales_extend? ese ON t?.tenant_id=ese.tenant_id AND t?.tenant_wechatapp_id=ese.tenant_app_id AND t?.sales_erp_id=ese.sales_erp_id LEFT JOIN warranty_service.warranty t? ON t?.tenant_wechatapp_id=t?.tenant_wechatapp_id AND t?.sales_erp_id=t?.erp_sales_id AND t?.is_disable=? WHERE t?.tenant_id=? AND t?.tenant_wechatapp_id=? AND t?.sales_status=? AND t?.is_sales=? AND t?.dept_erp_id=? AND t?.sales_date>=date_format(?,?) AND t?.sales_date<=date_format(?,?)|1|1|1||0|0|10664|10664|1|1|
|export|SELECT pc.id,pc.cutomer_grade AS cutomerGrade,ifnull(mem.member_name,ifnull(eu.external_user_name,?)) AS `name`,mem.mobile_no,pc.maintain_employee_name AS maintainEmployee,pc.last_maintain_time,(CASE WHEN pc.`status`=? THEN pc.finish_time ELSE ? END)dealTime,pc.maintain_num AS maintainNum,pc.intention_num,pc.latest_intention,sp.`name` AS maintainShop,pc.`status`,(CASE pc.`status` WHEN ? THEN ? ELSE ? END) AS statusName,pc.fail_employee_name AS failEmployee,pc.checkin_time,pc.finish_time AS finishTime FROM v4_user.potential_customer pc LEFT JOIN (SELECT t?.tenant_id,ifnull(t?.member_name,t?.external_user_name) AS external_user_name,t?.external_user_id FROM v4_user.cwx_external_user t? LEFT JOIN v4_user.member t? ON t?.tenant_id=? AND t?.tenant_app_id=? AND t?.external_user_id=t?.external_user_id WHERE t?.tenant_id=?)eu ON pc.tenant_id=eu.tenant_id AND pc.external_user_id=eu.external_user_id LEFT JOIN v4_user.member mem ON pc.tenant_id=mem.tenant_id AND pc.member_id=mem.id AND mem.`status`=? LEFT JOIN v4_employee.shop sp ON pc.maintain_shop_id=sp.id WHERE pc.tenant_id=? AND pc.tenant_app_id=? AND EXISTS (SELECT ? FROM v4_user.potential_customer_maintain t? WHERE pc.id=t?.potential_customer_id AND t?.create_time>=? AND t?.create_time<=? AND t?.event_type IN(?)) ORDER BY pc.id DESC|1|30|30||0|0|30250|30250|262|262|
|v4_sales|SELECT * FROM `erp_sales_detail`|1|89|89||0|0|14571927|14571927|14571927|14571927|
|user_service|SELECT * FROM `tenant_member_bind`|1|109|109||0|0|18901420|18901420|18901420|18901420|
|erp_sync|SELECT * FROM `cwx_checkin_sync_log`|1|8|8||0|0|268252|268252|268252|268252|
|v4_user|SELECT * FROM `employee_external_bind`|1|37|37||0|0|7654447|7654447|7654447|7654447|
|export|SELECT t.id,t.product_name,CASE WHEN t.take_type=? THEN ? ELSE ? END take_type,t.user_name,t.mobile_no,t.create_time,t.update_time,t.quantity,t.pay_price,CASE WHEN t.order_status=? THEN ? ELSE ? END order_status,t.remark,date_format(tt.can_take_date,?)can_take_date,tt.shop_name,tt.take_shop_name,tt.take_employee_name,ta.recipients,ta.user_tel,CONCAT(ta.area,ta.address)address,if(t.trade_type=?,pl.id,it.barcode) AS barcode,t.cash_price,ws.shop_name userAscriptionShop,if(t.order_status=?,?,t.write_off_time) AS write_off_time FROM gift_mail.trade t LEFT JOIN gift_mail.trade_take tt ON t.tenant_wechatapp_id=tt.tenant_wechatapp_id AND t.id=tt.trade_id LEFT JOIN gift_mail.trade_addr ta ON t.tenant_wechatapp_id=ta.tenant_wechatapp_id AND t.id=ta.trade_id LEFT JOIN gift_mail.product p ON p.id=t.product_id LEFT JOIN gift_mail.platform_product pl ON pl.id=t.product_id LEFT JOIN gift_mail.inventory it ON it.product_id=t.product_id AND it.specification=t.specification LEFT JOIN user_service.tenant_member_info tm ON t.tenant_id=tm.tenant_id AND t.tenant_wechatapp_id=tm.tenant_app_id AND t.user_id=tm.user_id LEFT JOIN tenant.tenant_wechatapp_shop ws ON tm.shop_id=ws.id WHERE t.tenant_wechatapp_id=? AND t.trade_type=? ORDER BY t.id DESC|1|3|3||0|0|37662|37662|4183|4183|
|v4_user|SELECT count(DISTINCT es.id) AS totalSalesCount,ifnull(sum(esd.amount_pay),?) AS totalSalesAmount,count(DISTINCT if(es.member_erp_id=?,es.id,es.member_erp_id)) AS countSalesPerson,ifnull(sum(esd.quantity),?) AS countGoodsAmount FROM v4_sales.erp_sales es JOIN v4_sales.erp_sales_detail esd ON es.tenant_id=esd.tenant_id AND es.tenant_app_id=esd.tenant_app_id AND es.sales_erp_id=esd.sales_erp_id AND esd.sales_type=? JOIN v4_employee.shop sp ON es.tenant_id=sp.tenant_id AND es.dept_erp_id=sp.dept_id AND sp.id=? JOIN tenant.employee emp ON es.tenant_id=emp.tenant_id AND es.employee_erp_id=emp.employee_erp_id AND emp.id=? WHERE es.tenant_id=? AND es.tenant_app_id=? AND es.sales_date>=? AND es.sales_date<? AND es.is_sales=? AND es.sales_status=?|1|1|1||0|0|903|903|1|1|
