|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|v4_user|SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.task_type,t?.system_task_type,t?.task_template_id,t?.task_name,t?.shop_id,t?.employee_id,t?.create_time AS task_time,t?.start_time,t?.end_time,t?.finish_time,t?.`status` FROM v4_employee.task_task t? WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<? LIMIT ? OFFSET ?|1|1|1||0|0|23|23|23|23|
|account|SELECT * FROM `account_flow`|1|199|199||0|0|16315876|16315876|16315876|16315876|
|platform|SELECT * FROM `valueaddedlog`|1|2|2||0|0|31774|31774|31774|31774|
|mini_app|SELECT * FROM `app_qrcode`|1|2|2||0|0|337380|337380|337380|337380|
||SELECT * FROM tenant.erp_sales t WHERE t.tenant_id=? AND t.sales_no=?|1|9|9||0|0|1251685|1251685|1|1|
|position|SELECT * FROM `geo_position`|1|319|319||0|0|10035978|10035978|10035978|10035978|
|tenant|SELECT * FROM `employee_tenant_user`|1|1|1||0|0|35834|35834|35834|35834|
|v4_user|SELECT * FROM `cwx_external_user`|1|39|39||0|0|5397199|5397199|5397199|5397199|
|authorization_service|SELECT login_token FROM authorization_service.user_login_token WHERE user_id=? AND tenant_id=? AND tenant_wx_app_id=? ORDER BY id DESC LIMIT ?,?|1|1|1||0|0|1|1|1|1|
|mini_app|SELECT * FROM `mini_qrcode_params`|1|3|3||0|0|979788|979788|979788|979788|
|v4_coupon|SELECT * FROM `tag_push_coupon_log`|1|2|2||0|0|412290|412290|412290|412290|
|v4_user|SELECT * FROM `member_change_log`|1|790|790||0|0|11300105|11300105|11300105|11300105|
|shop_work|SELECT * FROM `task_item`|1|68|68||0|0|1091587|1091587|1091587|1091587|
|sms|SELECT * FROM `sms_report`|1|940|940||0|0|10755064|10755064|10755064|10755064|
|shop_work|SELECT * FROM `work_report`|1|3|3||0|0|19290|19290|19290|19290|
|oss|SELECT * FROM `oss_res`|1|8|8||0|0|127425|127425|127425|127425|
|order|SELECT * FROM `order_detail`|1|4|4||0|0|265686|265686|265686|265686|
|v4_employee|SELECT * FROM `_task_task_new`|1|19|19||0|0|1697193|1697193|1697193|1697193|
|message_push|SELECT * FROM `message_log_back`|1|19|19||0|0|509665|509665|509665|509665|
|employee|SELECT * FROM `backlog_bak`|1|2|2||0|0|66096|66096|66096|66096|
|payment|SELECT * FROM `pay_order_msg`|1|331|331||0|0|690648|690648|690648|690648|
|tenant|SELECT * FROM `day_price`|1|1|1||0|0|33852|33852|33852|33852|
|order|SELECT * FROM `order_address`|1|1|1||0|0|265686|265686|265686|265686|
|platform|SELECT * FROM `custommadeorderstatus`|1|1|1||0|0|37709|37709|37709|37709|
|order|SELECT * FROM `order_info`|1|4|4||0|0|265686|265686|265686|265686|
|payment|SELECT * FROM `refund_order`|1|3|3||0|0|14269|14269|14269|14269|
|v4_user|SELECT t.change_time FROM v4_user.member_change_log t WHERE t.tenant_id=? AND t.tenant_app_id=? AND t.member_id=? AND t.change_type=? ORDER BY t.id ASC LIMIT ?|1|24|24||0|0|939091|939091|0|0|
|tenant|SELECT * FROM `employee`|1|9|9||0|0|95191|95191|95191|95191|
|sms|SELECT * FROM `sms_send_extend`|1|84|84||0|0|3745348|3745348|3745348|3745348|
|sms|SELECT * FROM `sms_send`|1|986|986||0|0|9369997|9369997|9369997|9369997|
|order|SELECT * FROM `order_operator_log`|1|36|36||0|0|1099106|1099106|1099106|1099106|
|order|SELECT * FROM `order_service_log`|1|1|1||0|0|26358|26358|26358|26358|
|payment|SELECT * FROM `refund_order_msg`|1|14|14||0|0|14269|14269|14269|14269|
|tenant|SELECT * FROM `employee_shop`|1|2|2||0|0|93457|93457|93457|93457|
|export|SELECT od.id,if(od.take_type=?,?,?)takeType,od.create_time,od.freight_fee,od.payment_fee,dt.price,dt.quantity,dt.art_no,dt.product_name,ad.user_name receiveName,ad.mobile_no,ad.shop_name,ad.address,ad.express_no,ad.express_company,od.user_name,od.update_time,od.receive_time,od.user_id,od.mobile_no buyMobileNo,od.remark,dt.spec,od.take_shop_name,od.take_employee_user_name,od.offline_payment_fee, CASE WHEN od.pay_way=? THEN ? ELSE ? END payWay,od.pay_id,od.payment_time, CASE WHEN od.status=? AND od.finish_type=? THEN ? WHEN od.status=? THEN ? WHEN od.status=? AND od.child_status=? THEN ? ELSE ? END statusName, CASE WHEN od.activity_type=? THEN ? ELSE ? END activityName,if(od.take_type=?,od.receive_time,?)takeTime FROM `order`.order_info od LEFT JOIN `order`.order_detail dt ON od.id=dt.order_id LEFT JOIN `order`.order_address ad ON od.id=ad.order_id WHERE od.tenant_wechatapp_id=? AND dt.product_name LIKE concat(?,?,?) ORDER BY od.create_time DESC|1|1|1||0|0|9787|9787|55|55|
|employee|SELECT * FROM `backlog_detail`|1|25|25||0|0|1429463|1429463|1429463|1429463|
|corpwx|SELECT * FROM `external_userid_transform`|1|34|34||0|0|7797792|7797792|7797792|7797792|
|v4_user|SELECT * FROM `member_import_log`|1|9|9||0|0|1008702|1008702|1008702|1008702|
|v4_user|SELECT * FROM `member_import`|1|38|38||0|0|2169351|2169351|2169351|2169351|
|payment|SELECT * FROM `close_order_msg`|1|9|9||0|0|41008|41008|41008|41008|
|v4_user|SELECT * FROM `member_login_log`|1|16|16||0|0|2411337|2411337|2411337|2411337|
|shop_work|SELECT * FROM `task_old`|1|1|1||0|0|3211|3211|3211|3211|
|account|SELECT t.busi_date,t.tenant_id,t.tenant_app_id,t.ambassador_id,count(*)finish_amount,t.statistic_date,ifnull(sum(ifnull(t.brokerage,?)),?)brokerage_amount,ifnull(sum(ifnull(t.amount,?)),?)sale_amount FROM (SELECT date_format(bl.create_time,?)busi_date,bl.tenant_id,bl.tenant_app_id,bl.ambassador_id,sl.brokerage,es.amount,date_format(sl.create_time,?)statistic_date FROM agency.sale sl INNER JOIN agency.booking_order bl ON sl.tenant_app_id=bl.tenant_app_id AND sl.order_id=bl.id LEFT JOIN tenant.erp_sales es ON es.tenant_id=sl.tenant_id AND sl.tenant_app_id=es.tenant_wechatapp_id AND sl.erp_sale_id=es.sales_erp_id WHERE sl.tenant_id=? AND sl.tenant_app_id=? AND sl.create_time>=? AND sl.create_time<=?)t GROUP BY t.busi_date,t.tenant_id,t.tenant_app_id,t.ambassador_id,t.statistic_date LIMIT ? OFFSET ?|1|1|1||0|0|0|0|0|0|
|v4_user|SELECT t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id,? AS statisticDate,? AS bizType,count(*) AS amount FROM v4_employee.task_task t? WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.task_type=? AND t?.finish_time>=? AND t?.finish_time<? GROUP BY t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id LIMIT ? OFFSET ?|1|1|1||0|0|5368|5368|1|1|
|account|SELECT * FROM `wx_redpacket_send_msg`|1|44|44||0|0|818823|818823|818823|818823|
|account|SELECT t.tenant_id,t.tenant_app_id,t.coupon_id,t.statistic_date,t.coupon_type,t.ambassador_id,ifnull(sum(ifnull(t.total_fee,?)),?)amount,t.busi_date FROM (SELECT cu.tenant_id,cu.tenant_app_id,cu.template_id coupon_id,date_format(od.payment_time,?)statistic_date,cu.coupon_type,ce.source_user_id ambassador_id,od.total_fee,date_format(cu.create_time,?)busi_date FROM `order`.order_info od INNER JOIN coupon_service.coupon cu ON od.tenant_wechatapp_id=cu.tenant_app_id AND od.coupon_id=cu.id INNER JOIN coupon_service.coupon_extend ce ON cu.tenant_app_id=ce.tenant_app_id AND cu.id=ce.coupon_id WHERE od.tenant_wechatapp_id=? AND od.status>=? AND cu.source=? AND od.payment_time>=? AND od.payment_time<=?)t GROUP BY t.tenant_id,t.tenant_app_id,t.coupon_id,t.statistic_date,t.coupon_type,t.ambassador_id,t.busi_date LIMIT ? OFFSET ?|1|1|1||0|0|43131|43131|0|0|
|v4_employee|SELECT * FROM `mark_label_task`|1|3|3||0|0|682463|682463|682463|682463|
|tenant|SELECT * FROM `erp_employee`|1|4|4||0|0|88437|88437|88437|88437|
|shop_work|SELECT * FROM `task`|1|89|89||0|0|464505|464505|464505|464505|
|account|SELECT t.tenant_id,t.tenant_app_id,t.shop_id,t.user_id,t.scene,t.busi_date,count(*)finish_amount FROM (SELECT bg.id,bg.tenant_id,bg.tenant_app_id,ifnull(ws.dept_erp_id,?)shop_id,ifnull(ey.employee_erp_id,?)user_id,bg.status,bg.scene,date_format(bg.expire_time,?)busi_date FROM employee.backlog_? bg INNER JOIN tenant.tenant_wechatapp_shop ws ON bg.shop_id=ws.id INNER JOIN tenant.employee ey ON bg.employee_id=ey.id WHERE bg.tenant_app_id=? AND bg.status IN (?) AND bg.scene NOT IN(?) AND bg.finish_time>=? AND bg.finish_time<=?)t GROUP BY t.tenant_id,t.tenant_app_id,t.shop_id,t.user_id,t.scene,t.busi_date LIMIT ? OFFSET ?|1|2|2||0|0|6268|6268|834|834|
|message_push|SELECT * FROM `message_log`|1|93|93||0|0|3305772|3305772|3305772|3305772|
|platform|SELECT * FROM `tbhy_hyda_sync`|1|1|1||0|0|15838|15838|15838|15838|
|platform|SELECT * FROM `custommadeorder`|1|3|3||0|0|11805|11805|11805|11805|
|qrcode_service|SELECT * FROM `qrcode`|1|7|7||0|0|77626|77626|77626|77626|
|qrcode_login|SELECT * FROM `qrcode_log`|1|1|1||0|0|8033|8033|8033|8033|
|payment|SELECT * FROM `pay_order`|1|57|57||0|0|348686|348686|348686|348686|
|account|SELECT tmp.tenant_id,tmp.tenant_app_id,tmp.statistic_date,sum(if(tmp.oper_type=?,tmp.oper_amount,?))recharge_balance,sum(if(tmp.oper_type=?,tmp.oper_amount,?))consume_balance,sum(if(tmp.oper_type=?,tmp.give_amount,?))give_balance FROM (SELECT date_format(oper_time,?)statistic_date,tenant_id,tenant_app_id,oper_type,oper_amount,real_oper_amount-oper_amount give_amount FROM account.store_card_detail WHERE tenant_app_id=? AND oper_result=? AND oper_time>=? AND oper_time<=?)tmp GROUP BY tmp.tenant_id,tmp.tenant_app_id,tmp.statistic_date|1|1|1||0|0|5639|5639|0|0|
|platform|SELECT * FROM `callbacklog`|1|3|3||0|0|34421|34421|34421|34421|
|platform|SELECT * FROM `bargainapplication`|1|1|1||0|0|59587|59587|59587|59587|
|account|SELECT pd.id product_id,? tenant_id,? tenant_wechatapp_id,pd.product_name,? product_type,pd.tag_price price,it.volume,it.id inventory_id,pd.create_time,? partner_id,? partner_name,pd.update_time FROM gift_mail.platform_product pd LEFT JOIN gift_mail.platform_inventory it ON pd.id=it.product_id LIMIT ? OFFSET ?|1|2|2||0|0|4366|4366|2183|2183|
|v4_coupon|SELECT * FROM `sales_give_coupon_record`|1|6|6||0|0|1369697|1369697|1369697|1369697|
|account|SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.sneak_guest_no,ifnull(tb.erp_member_id,?) AS memberId,(CASE t?.user_type WHEN ? THEN ? ELSE ? END) AS userType,ifnull(tm.user_name,ceu.nick_name) AS userName,tm.mobile_no,t?.create_employee_id,t?.create_shop_id,t?.create_time AS recordTime,t?.maintain_employee_id,t?.last_maintain_date,(CASE t?.`status` WHEN ? THEN ? ELSE ? END)`status`,t?.sales_erp_id,if(t?.`status`=?,t?.update_employee_id,?) AS failEmployeeId,(CASE fail_type WHEN ? THEN ? ELSE ? END) AS failType,t?.finish_date FROM tenant.sneak_guest t? LEFT JOIN user_service.tenant_member tm ON tm.tenant_id=? AND tm.tenant_app_id=t?.tenant_app_id AND tm.user_id=t?.user_id LEFT JOIN user_service.tenant_member_bind tb ON tb.tenant_id=? AND tb.id=tm.id LEFT JOIN corpwx.corpwx_external_user ceu ON t?.user_id=ceu.id LEFT JOIN tenant.sneak_guest_sales t? ON t?.tenant_id=t?.tenant_id AND t?.id=t?.sneak_guest_id LEFT JOIN tenant.erp_sales t? ON t?.tenant_id=t?.tenant_id AND t?.sales_id=t?.id AND t?.tenant_wechatapp_id=? WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<=? LIMIT ? OFFSET ?|1|1|1||0|0|1938|1938|323|323|
|sms|SELECT * FROM `sms_send_back`|1|2|2||0|0|16036|16036|16036|16036|
|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|53874|53874|5986|5986|
|v4_user|SELECT * FROM `reception_customer_potential`|1|25|25||0|0|5339614|5339614|5339614|5339614|
|v4_user|SELECT * FROM `member_grade`|1|56|56||0|0|4083809|4083809|4083809|4083809|
|account|SELECT t.id,t.tenant_id,t.tenant_wechatapp_id,t.sales_erp_id,t.sales_index,t.sales_type,t.product_barcode,t.product_name,t.cert_no,t.hand_size,t.category_erp_id,t.category_name,t.stone_weight,t.gold_weight,t.total_weight,t.quantity,t.amount_total,t.amount_pay,ifnull(amount_pay/quantity,?) AS amount_avg,t.integral,ct.id AS pk_id,ct.change_type AS SYS_CHANGE_OPERATION FROM tenant.erp_sales_detail AS t RIGHT OUTER JOIN tenant.sjfx_dct_erp_sales_detail ct ON t.id=ct.id WHERE ct.version>? AND (t.tenant_id=?)|1|1|1||0|0|41|41|0|0|
|v4_user|SELECT * FROM `member_butler_update_error`|1|12|12||0|0|1591768|1591768|1591768|1591768|
|tenant|SELECT * FROM `employee_qrcode`|1|3|3||0|0|66984|66984|66984|66984|
|platform|SELECT * FROM `productdesc`|1|1|1||0|0|2228|2228|2228|2228|
