|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|v4_coupon|SELECT * FROM `coupon_write_off`|1|1|1||0|0|279669|279669|279669|279669|
|v4_sales|SELECT * FROM `erp_sales_extend?`|1|52|52||0|0|5878257|5878257|5878257|5878257|
|platform|SELECT * FROM `valueaddedlog`|1|2|2||0|0|31774|31774|31774|31774|
|v4_sales|SELECT * FROM `comment_prize`|1|1|1||0|0|23308|23308|23308|23308|
|score_player|SELECT * FROM `supervise_record`|1|2|2||0|0|18399|18399|18399|18399|
|user_service|SELECT * FROM `user_employee`|1|91|91||0|0|13954361|13954361|13954361|13954361|
|v4_sales|SELECT * FROM `value_added_record`|1|11|11||0|0|2444983|2444983|2444983|2444983|
|position|SELECT * FROM `geo_position`|1|356|356||0|0|10015386|10015386|10015386|10015386|
|tenant|SELECT * FROM `employee_tenant_user`|1|1|1||0|0|35794|35794|35794|35794|
|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 FROM warranty_service.warranty wt INNER JOIN tenant.erp_sales es ON es.tenant_id=? AND wt.tenant_wechatapp_id=es.tenant_wechatapp_id AND wt.erp_sales_id=es.sales_erp_id WHERE wt.tenant_wechatapp_id=? AND wt.is_disable=? AND wt.create_time>=? AND wt.create_time<=? GROUP BY es.tenant_id,es.tenant_wechatapp_id,es.sales_date,es.dept_erp_id,es.employee_erp_id|1|1|1||0|0|812|812|161|161|
|qrcode_service|SELECT * FROM `qrcode_scan_log`|1|198|198||0|0|3838257|3838257|3838257|3838257|
|v4_coupon|SELECT * FROM `coupon_extend`|1|52|52||0|0|2129319|2129319|2129319|2129319|
|v4_coupon|SELECT * FROM `tag_push_coupon_log`|1|1|1||0|0|412290|412290|412290|412290|
|v4_user|SELECT * FROM `member_butler`|1|15|15||0|0|4071455|4071455|4071455|4071455|
|user_service|SELECT * FROM `wx_user_mobile_no`|1|3|3||0|0|908330|908330|908330|908330|
|v4_user|SELECT * FROM `member_change_log`|1|136|136||0|0|11222043|11222043|11222043|11222043|
|shop_work|SELECT * FROM `task_item`|1|75|75||0|0|1091587|1091587|1091587|1091587|
|account|SELECT pd.id product_id,pd.tenant_id,pd.tenant_wechatapp_id,pd.product_name,pd.product_type,ifnull(it.price,pd.tag_price)price,it.volume,ifnull(it.id,?)inventory_id,it.barcode,it.specification,it.quantity,pd.create_time,? partner_id,? partner_name,pd.update_time FROM gift_mail.product pd LEFT JOIN gift_mail.inventory it ON pd.id=it.product_id WHERE pd.tenant_id=? AND pd.product_type=? AND (pd.update_time>=? OR it.update_time>=?) AND (pd.update_time<=? OR it.update_time<=?) AND pd.is_disable IS ? LIMIT ? OFFSET ?|1|1|1||0|0|8058|8058|0|0|
|sms|SELECT * FROM `sms_report`|1|1047|1047||0|0|10750285|10750285|10750285|10750285|
|shop_work|SELECT * FROM `work_report`|1|4|4||0|0|19290|19290|19290|19290|
|shop_work|SELECT * FROM `attached`|1|9|9||0|0|116545|116545|116545|116545|
|v4_employee|SELECT * FROM `_task_task_new`|1|20|20||0|0|1697193|1697193|1697193|1697193|
|activity_service|SELECT * FROM `vote_log`|1|8|8||0|0|2605213|2605213|2605213|2605213|
|employee|SELECT * FROM `backlog_bak`|1|3|3||0|0|66096|66096|66096|66096|
|payment|SELECT * FROM `pay_order_msg`|1|157|157||0|0|689772|689772|689772|689772|
|score_player|SELECT * FROM `supervise_record_image`|1|1|1||0|0|21294|21294|21294|21294|
|tenant|SELECT * FROM `day_price`|1|1|1||0|0|33547|33547|33547|33547|
|v4_sales|SELECT * FROM `warranty_can_added`|1|10|10||0|0|3534033|3534033|3534033|3534033|
|authorization_service|SELECT * FROM `ip_table_local`|1|1|1||0|0|462824|462824|462824|462824|
|shop_work|SELECT * FROM `report_data_source`|1|9|9||0|0|57893|57893|57893|57893|
|platform|SELECT * FROM `custommadeorderstatus`|1|1|1||0|0|37709|37709|37709|37709|
|corpwx|SELECT * FROM `corpwx_external_user`|1|96|96||0|0|8197369|8197369|8197369|8197369|
|user_service|SELECT * FROM `user_source`|1|101|101||0|0|18702545|18702545|18702545|18702545|
|payment|SELECT * FROM `refund_order`|1|2|2||0|0|14258|14258|14258|14258|
|account|SELECT * FROM `account`|1|144|144||0|0|31721084|31721084|31721084|31721084|
|value_added|SELECT * FROM `value_added_user_extend`|1|9|9||0|0|2108038|2108038|2108038|2108038|
|tenant|SELECT * FROM `employee`|1|12|12||0|0|95078|95078|95078|95078|
|v4_user|SELECT * FROM `member_butler_back`|1|1|1||0|0|372098|372098|372098|372098|
|sms|SELECT * FROM `sms_send_extend`|1|79|79||0|0|3740636|3740636|3740636|3740636|
|sms|SELECT * FROM `sms_send`|1|999|999||0|0|9359716|9359716|9359716|9359716|
|account|SELECT DISTINCT tenant_wechatapp_id tenant_app_id,date_format(create_time,?)statistic_date,sales_date busi_date FROM warranty_service.warranty WHERE tenant_wechatapp_id=? AND update_time>=? AND update_time<=? AND is_disable=?|1|1|1||0|0|0|0|0|0|
|corpwx|SELECT * FROM `external_user_log`|1|61|61||0|0|12891915|12891915|12891915|12891915|
|payment|SELECT * FROM `refund_order_msg`|1|14|14||0|0|14258|14258|14258|14258|
|account|SELECT es.tenant_id,es.tenant_wechatapp_id tenant_app_id,es.member_erp_id,es.sales_erp_id lastSaleErpId,sd.category_erp_id lastCategoryId,ifnull(pc.category_name,sd.category_name) AS lastCategoryName,sd.stone_weight lastStoneWeight,sd.gold_weight lastGoldWeight,round(sd.amount_pay/if(sd.quantity=?,?,sd.quantity),?)price,sd.amount_pay salesBalance FROM tenant.erp_sales es INNER JOIN tenant.erp_sales_detail sd ON sd.tenant_id=es.tenant_id AND es.tenant_wechatapp_id=sd.tenant_wechatapp_id AND es.sales_erp_id=sd.sales_erp_id LEFT JOIN tenant.erp_product_category pc ON es.tenant_id=pc.tenant_id AND sd.category_erp_id=pc.category_erp_id WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.member_erp_id=? AND es.sales_date>=? AND es.sales_status=? AND es.is_sales=? AND sd.sales_type=? ORDER BY es.sales_erp_id DESC,price DESC LIMIT ?|1|1|1||0|0|26|26|1|1|
|tenant|SELECT * FROM `employee_shop`|1|3|3||0|0|93363|93363|93363|93363|
|employee|SELECT * FROM `backlog_detail`|1|8|8||0|0|1429463|1429463|1429463|1429463|
|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|7938|7938|0|0|
|v4_coupon|SELECT * FROM `coupon_grant`|1|6|6||0|0|2045162|2045162|2045162|2045162|
|corpwx|SELECT * FROM `external_userid_transform`|1|34|34||0|0|7776994|7776994|7776994|7776994|
|v4_sales|SELECT * FROM `comment_not_remind_sales`|1|3|3||0|0|121822|121822|121822|121822|
|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|16|16||0|0|22914|22914|33|33|
|v4_employee|SELECT * FROM `task_task`|1|109|109||0|0|3712833|3712833|3712833|3712833|
|shop_work|SELECT * FROM `task_old`|1|1|1||0|0|3211|3211|3211|3211|
|v4_employee|SELECT * FROM `task_task_attach`|1|16|16||0|0|1333112|1333112|1333112|1333112|
|shop_work|SELECT * FROM `manage_report`|1|1|1||0|0|662|662|662|662|
|v4_user|SELECT * FROM `member`|1|29|29||0|0|4073303|4073303|4073303|4073303|
|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|5235|5235|0|0|
|v4_user|SELECT t.id,t.tenant_id,t.employee_id,t.external_user_id,t.corp_user_id AS employeeCorpId,t.create_time AS oper_time FROM v4_user.employee_external_bind t WHERE t.tenant_id=? LIMIT ? OFFSET ?|1|1|1||0|0|5000|5000|5000|5000|
|account|SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.coupon_id,ifnull(tb?.erp_member_id,?) AS giveMemberId,ifnull(tb.erp_member_id,?) AS receiveMemberId,t?.create_time AS receiveTime FROM coupon_service.user_coupon_give_record t? LEFT 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=? LEFT 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?.give_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|52039|52039|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|15009|15009|1|1|
|v4_user|SELECT * FROM `wx_user_subscribe_log`|1|17|17||0|0|4730754|4730754|4730754|4730754|
|v4_employee|SELECT * FROM `mark_label_task`|1|3|3||0|0|672134|672134|672134|672134|
|v4_coupon|SELECT * FROM `coupon`|1|8|8||0|0|1086476|1086476|1086476|1086476|
|tenant|SELECT * FROM `erp_employee`|1|7|7||0|0|88345|88345|88345|88345|
|shop_work|SELECT * FROM `task`|1|97|97||0|0|464505|464505|464505|464505|
|v4_sales|SELECT * FROM `comment_detail`|1|9|9||0|0|334225|334225|334225|334225|
|platform|SELECT * FROM `tbhy_hyda_sync`|1|1|1||0|0|15838|15838|15838|15838|
|v4_sales|SELECT * FROM `warranty`|1|21|21||0|0|2610263|2610263|2610263|2610263|
|platform|SELECT * FROM `custommadeorder`|1|3|3||0|0|11805|11805|11805|11805|
|qrcode_service|SELECT * FROM `qrcode`|1|8|8||0|0|77122|77122|77122|77122|
|qrcode_login|SELECT * FROM `qrcode_log`|1|1|1||0|0|7748|7748|7748|7748|
|user_service|SELECT * FROM `wx_member_card_redirect`|1|8|8||0|0|855584|855584|855584|855584|
|v4_sales|SELECT * FROM `erp_sales_detail`|1|476|476||0|0|13161865|13161865|13161865|13161865|
|payment|SELECT * FROM `pay_order`|1|5|5||0|0|348247|348247|348247|348247|
|account|SELECT u.id,u.tenant_id,u.tenant_app_id,tw.dept_erp_id AS shop_id,date_format(u.birthday,?) AS tempBirthDay,ifnull(u.birthday_is_lunar,?) AS birthdayIsLunar,u.memorial_name,date_format(u.memorial_day,?) AS tempMemorialDay,ifnull(u.memorial_day_is_lunar,?) AS memorialDayIsLunar,u.grade_id AS gradeErpId,if(u.birthday IS ?,?,?) AS fullFlag FROM user_service.tenant_member_info u LEFT JOIN tenant.tenant_wechatapp_shop tw ON u.shop_id=tw.id WHERE u.tenant_id=? AND u.tenant_app_id=? AND u.update_time>=? AND u.update_time<=? ORDER BY u.tenant_id,u.id LIMIT ? OFFSET ?|1|1|1||0|0|921|921|307|307|
|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|
|value_added|SELECT * FROM `value_added_user`|1|17|17||0|0|2110201|2110201|2110201|2110201|
|platform|SELECT * FROM `callbacklog`|1|2|2||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|5|5||0|0|1367212|1367212|1367212|1367212|
|v4_user|SELECT * FROM `employee_external_bind`|1|36|36||0|0|7036723|7036723|7036723|7036723|
|account|SELECT tenant_wechatapp_id tenant_app_id,member_erp_id FROM tenant.erp_sales WHERE tenant_id=? AND tenant_wechatapp_id=? AND update_time BETWEEN ? AND ? GROUP BY tenant_wechatapp_id,member_erp_id LIMIT ? OFFSET ?|1|1|1||0|0|20|20|5|5|
|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|456|456|76|76|
|sms|SELECT * FROM `sms_send_back`|1|1|1||0|0|16036|16036|16036|16036|
|account|SELECT od.tenant_id,od.tenant_wechatapp_id tenant_app_id,od.user_id,count(?)order_amount FROM `order`.order_info od WHERE od.tenant_wechatapp_id=? AND od.status IN (?) AND od.user_id IN (?) GROUP BY od.tenant_id,od.tenant_wechatapp_id,od.user_id|1|1|1||0|0|765|765|136|136|
|v4_user|SELECT * FROM `reception_customer_potential`|1|22|22||0|0|5339040|5339040|5339040|5339040|
|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|33|33|0|0|
|v4_user|SELECT * FROM `member_butler_update_error`|1|10|10||0|0|1591768|1591768|1591768|1591768|
|score_player|SELECT * FROM `score_flow`|1|1|1||0|0|34499|34499|34499|34499|
|tenant|SELECT * FROM `employee_qrcode`|1|4|4||0|0|66887|66887|66887|66887|
|platform|SELECT * FROM `productdesc`|1|1|1||0|0|2228|2228|2228|2228|
