|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|v4_user|SELECT t?.tenant_id,t?.tenant_app_id,DATE_FORMAT(t?.recept_time,?) AS recept_time FROM v4_user.reception_customer t? JOIN v4_user.reception_customer_log t? ON t?.id=t?.reception_customer_id AND t?.oper_type=? WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.create_time>=? AND t?.create_time<? AND t?.oper_status&?=? GROUP BY t?.tenant_id,t?.tenant_app_id,DATE_FORMAT(t?.recept_time,?)|2|10|6||0|0|611908|305956|2|2|
|account|SELECT t.tenant_app_id,t.user_id,t.is_drawed_img FROM customer.tenant_user_image t WHERE t.tenant_app_id=? AND t.update_time>=? AND t.update_time<=? AND t.is_drawed_img=? GROUP BY t.tenant_app_id,t.user_id,t.is_drawed_img LIMIT ? OFFSET ?|2|6|3||0|0|496441|351403|13|13|
|account|SELECT tu.id,tu.tenant_id,tu.tenant_app_id,tu.erp_member_id,tu.customer_user_id,? updateTime,wx_user_id FROM user_service.tenant_member_bind tu WHERE tu.tenant_id=? AND tu.tenant_app_id=? AND tu.create_time>=? AND tu.create_time<=? ORDER BY id LIMIT ? OFFSET ?|2|2|1||0|0|12|12|6|6|
|account|SELECT min(create_time)create_time FROM goods.goods WHERE tenant_id=? AND tenant_app_id=?|2|7|4||0|0|31770|15885|2|1|
|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=?|2|3|1||0|0|35988|18260|483|375|
|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<=? AND es.sales_date=? GROUP BY es.tenant_id,es.tenant_wechatapp_id,es.sales_date,es.dept_erp_id,es.employee_erp_id|2|3|1||0|0|905|600|108|54|
|account|SELECT es.tenant_id AS tenantId,es.tenant_wechatapp_id AS tenantAppId,? AS collectType,es.id AS salesId FROM tenant.erp_sales es JOIN tenant.erp_sales_detail sd ON es.tenant_id=sd.tenant_id AND es.tenant_wechatapp_id=sd.tenant_wechatapp_id AND es.sales_erp_id=sd.sales_erp_id AND sd.sales_type=? WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.create_time>=? AND es.create_time<=? AND es.sales_status=? AND es.is_sales=? LIMIT ? OFFSET ?|2|2|1||0|0|1393|1135|0|0|
|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 ?|2|2|1||0|0|3|3|1|1|
|score_player|SELECT * FROM `score_flow`|1|1|1||0|0|34499|34499|34499|34499|
|corpwx|SELECT * FROM `corp_mini_qrcode_params`|1|2|2||0|0|741212|741212|741212|741212|
|qrcode_service|SELECT * FROM `qrcode_scan_log`|1|189|189||0|0|3836610|3836610|3836610|3836610|
|account|SELECT es.tenant_id,es.tenant_wechatapp_id tenant_app_id,es.sales_date,es.dept_erp_id,es.employee_erp_id erpEmployeeId,sd.category_erp_id FROM tenant.erp_sales es LEFT JOIN tenant.erp_sales_detail sd ON es.tenant_id=sd.tenant_id AND es.tenant_wechatapp_id=sd.tenant_wechatapp_id AND es.sales_erp_id=sd.sales_erp_id WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.create_time>=? AND es.create_time<=? AND es.sales_date=? AND es.sales_status IN (?) AND es.is_sales=? AND sd.sales_type=? ORDER BY es.id LIMIT ? OFFSET ?|1|1|1||0|0|1394|1394|446|446|
|shop_work|SELECT * FROM `report_data_source`|1|9|9||0|0|57893|57893|57893|57893|
|v4_user|SELECT t.tenant_id,t.tenant_app_id,t.registry_shop_id AS shopId,? AS statisticDate,t.source_type AS memberSource,count(*)amount FROM v4_user.member_source t WHERE t.tenant_id=? AND t.tenant_app_id=? AND t.create_time>=? AND t.create_time<? GROUP BY t.tenant_id,t.tenant_app_id,t.registry_shop_id,t.source_type LIMIT ? OFFSET ?|1|1|1||0|0|114352|114352|8|8|
|corpwx|SELECT * FROM `corpwx_external_user`|1|74|74||0|0|8193362|8193362|8193362|8193362|
||SELECT esd.id,es.tenant_id,es.tenant_wechatapp_id,es.sales_erp_id,esd.sales_index,es.dept_erp_id,es.employee_erp_id,es.member_erp_id,es.sales_status,es.sales_date,esd.category_erp_id,ifnull(esde.sales_brand,?) AS sales_brand,ifnull(esde.sales_craft,?) AS sales_craft,esd.amount_total,esd.amount_pay,esd.quantity,round(esd.amount_pay/esd.quantity,?) AS amount_avg FROM tenant.erp_sales es JOIN tenant.erp_sales_detail esd ON es.tenant_id=esd.tenant_id AND es.tenant_wechatapp_id=esd.tenant_wechatapp_id AND es.sales_erp_id=esd.sales_erp_id AND esd.sales_type=? LEFT JOIN tenant.erp_sales_detail_extend esde ON esde.tenant_id=esd.tenant_id AND esde.tenant_wechatapp_id=esd.tenant_wechatapp_id AND esde.sales_erp_id=esd.sales_erp_id AND esde.sales_index=esd.sales_index WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.update_time>=? AND es.update_time<? AND es.sales_status IN(?) LIMIT ?|1|1|1||0|0|2053|2053|500|500|
|v4_user|SELECT * FROM `member_import`|1|75|75||0|0|2169351|2169351|2169351|2169351|
|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|1|1||0|0|469|469|79|79|
|v4_user|SELECT * FROM `member_import_log`|1|35|35||0|0|1005579|1005579|1005579|1005579|
|tenant|SELECT * FROM `employee`|1|10|10||0|0|95059|95059|95059|95059|
|shop_work|SELECT * FROM `task`|1|97|97||0|0|464505|464505|464505|464505|
|check_stock|SELECT * FROM `realtime_gold_price`|1|2|2||0|0|592444|592444|592444|592444|
|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|
|comment_service|SELECT * FROM `comment`|1|6|6||0|0|995915|995915|995915|995915|
|tenant|SELECT * FROM `employee_tenant_user`|1|1|1||0|0|35789|35789|35789|35789|
|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|12|12||0|0|42843|42843|0|0|
|value_added|SELECT * FROM `value_added_user`|1|22|22||0|0|2109661|2109661|2109661|2109661|
|v4_user|SELECT t?.tenant_id,t?.tenant_app_id,t?.id,min(t?.recept_time) AS firstShopTime,max(t?.recept_time) AS lastShopTime,count(t?.id) AS enterShopNum FROM v4_user.reception_customer t? JOIN v4_user.member t? ON t?.tenant_id=t?.tenant_id AND t?.tenant_app_id=t?.tenant_app_id AND t?.external_user_id=t?.external_user_id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.id IN (?) GROUP BY t?.tenant_id,t?.tenant_app_id,t?.id|1|2|2||0|0|484302|484302|74|74|
|shop_work|SELECT * FROM `task_old`|1|1|1||0|0|3211|3211|3211|3211|
|account|SELECT * FROM `account`|1|140|140||0|0|31717687|31717687|31717687|31717687|
|shop_work|SELECT * FROM `task_item`|1|68|68||0|0|1091587|1091587|1091587|1091587|
|corpwx|SELECT * FROM `external_userid_transform`|1|34|34||0|0|7773978|7773978|7773978|7773978|
|comment_service|SELECT * FROM `comment_reward`|1|2|2||0|0|484886|484886|484886|484886|
|bespoke|SELECT * FROM `bespoke_trade`|1|3|3||0|0|57510|57510|57510|57510|
|v4_user|SELECT * FROM `member_grade`|1|91|91||0|0|4072150|4072150|4072150|4072150|
|authorization_service|SELECT * FROM `user_login_token`|1|463|463||0|0|33897446|33897446|33897446|33897446|
|v4_user|SELECT * FROM `member_points`|1|47|47||0|0|4072215|4072215|4072215|4072215|
|shop_work|SELECT * FROM `manage_report`|1|1|1||0|0|662|662|662|662|
|account|SELECT cu.tenant_id,cu.tenant_app_id,cu.id AS coupon_id,es.amount AS total_fee,DATE_FORMAT(es.erp_create_time,?) AS saleDate FROM tenant.erp_sales es 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 JOIN coupon_service.coupon cu ON cu.tenant_id=sd.tenant_id AND sd.tenant_wechatapp_id=cu.tenant_app_id AND sd.product_barcode=cu.id WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.is_sales=? AND es.amount>? AND es.create_time>=? AND es.create_time<=? LIMIT ? OFFSET ?|1|1|1||0|0|10|10|0|0|
|v4_user|SELECT * FROM `member_login_log`|1|16|16||0|0|2345152|2345152|2345152|2345152|
|warranty_service|SELECT * FROM `warranty`|1|121|121||0|0|13196842|13196842|13196842|13196842|
|score_player|SELECT * FROM `supervise_record_image`|1|1|1||0|0|21294|21294|21294|21294|
|tenant|SELECT * FROM `employee_qrcode`|1|4|4||0|0|66874|66874|66874|66874|
|account|SELECT od.id,od.tenant_id,od.tenant_wechatapp_id tenant_app_id,od.order_no,od.source,od.type,od.activity_id,od.activity_type,od.user_id,od.user_name,od.mobile_no,od.take_type,td.shop_id,td.shop_name,od.coupon_id,dt.product_id goods_id,dt.product_name goods_name,dt.art_no style_no,dt.sku_id,dt.spec,gs.barcode,od.product_fee,od.freight_fee,od.discount_fee,od.total_fee,od.payment_fee+od.offline_payment_fee payment_fee,od.status,od.finish_type,od.take_shop_id,od.take_shop_name,od.take_employee_user_id,od.take_employee_user_name,od.manager_shop_id,od.manager_shop_name,od.manager_user_id,od.manager_user_name,od.manager_mobile_no,od.manager_brokerage,od.create_time,od.update_time,? collect_time,dt.quantity FROM `order`.order_info od LEFT JOIN ORDER.order_detail dt ON od.id=dt.order_id LEFT JOIN deliver.trade_deliver td ON od.tenant_wechatapp_id=td.tenant_app_id AND od.id=td.trade_id LEFT JOIN goods.goods_sku gs ON dt.sku_id=gs.id WHERE od.tenant_wechatapp_id=? AND od.update_time>=? AND od.create_time<=? AND od.update_time<=? LIMIT ? OFFSET ?|1|1|1||0|0|690|690|146|146|
|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|8105|8105|0|0|
|shop_work|SELECT * FROM `work_report`|1|3|3||0|0|19290|19290|19290|19290|
|corpwx|SELECT * FROM `external_user_log`|1|84|84||0|0|12862428|12862428|12862428|12862428|
|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|1|1||0|0|7|7|0|0|
|qrcode_service|SELECT * FROM `qrcode`|1|6|6||0|0|77000|77000|77000|77000|
|v4_user|SELECT * FROM `wx_user_subscribe_log`|1|17|17||0|0|4727729|4727729|4727729|4727729|
|tenant|SELECT * FROM `erp_employee`|1|6|6||0|0|88335|88335|88335|88335|
|value_added|SELECT * FROM `value_added_user_extend`|1|10|10||0|0|2107498|2107498|2107498|2107498|
||SELECT esd.id,es.tenant_id,es.tenant_wechatapp_id,es.sales_erp_id,esd.sales_index,es.dept_erp_id,es.employee_erp_id,es.member_erp_id,es.sales_status,es.sales_date,esd.category_erp_id,ifnull(esde.sales_brand,?) AS sales_brand,ifnull(esde.sales_craft,?) AS sales_craft,esd.amount_total,esd.amount_pay,esd.quantity,round(esd.amount_pay/esd.quantity,?) AS amount_avg FROM tenant.erp_sales es JOIN tenant.erp_sales_detail esd ON es.tenant_id=esd.tenant_id AND es.tenant_wechatapp_id=esd.tenant_wechatapp_id AND es.sales_erp_id=esd.sales_erp_id AND esd.sales_type=? LEFT JOIN tenant.erp_sales_detail_extend esde ON esde.tenant_id=esd.tenant_id AND esde.tenant_wechatapp_id=esd.tenant_wechatapp_id AND esde.sales_erp_id=esd.sales_erp_id AND esde.sales_index=esd.sales_index WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.update_time>=? AND es.update_time<? AND es.sales_status IN(?) ORDER BY esd.id LIMIT ?|1|5|5||0|0|23700|23700|500|500|
|warranty_service|SELECT * FROM `warranty_back_?`|1|2|2||0|0|309596|309596|309596|309596|
|v4_user|SELECT * FROM `member_points_detail`|1|47|47||0|0|3143098|3143098|3143098|3143098|
|erp_sync|SELECT * FROM `cwx_checkin_sync_log`|1|12|12||0|0|263724|263724|263724|263724|
|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|470|470|1|1|
|activity_service|SELECT * FROM `intelligent_push_msg_obj`|1|37|37||0|0|6119869|6119869|6119869|6119869|
|tenant|SELECT * FROM `employee_shop`|1|2|2||0|0|93350|93350|93350|93350|
|sms|SELECT * FROM `sms_send_back`|1|2|2||0|0|16036|16036|16036|16036|
|sms|SELECT * FROM `sms_send`|1|1017|1017||0|0|9358356|9358356|9358356|9358356|
|sms|SELECT * FROM `sms_report`|1|1038|1038||0|0|10749664|10749664|10749664|10749664|
|score_player|SELECT * FROM `supervise_record`|1|1|1||0|0|18399|18399|18399|18399|
|shop_work|SELECT * FROM `attached`|1|7|7||0|0|116545|116545|116545|116545|
|activity_service|SELECT * FROM `lottery_user`|1|3|3||0|0|684680|684680|684680|684680|
|account|SELECT tenant_id,tenant_app_id,user_id,member_image_flag,member_image_time FROM user_service.tenant_member_info WHERE tenant_id=? AND tenant_app_id=? AND member_image_flag=? AND update_time>=? AND update_time<=? LIMIT ? OFFSET ?|1|1|1||0|0|272|272|0|0|
|v4_user|SELECT * FROM `member_change_log`|1|507|507||0|0|11205052|11205052|11205052|11205052|
