|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|platform|SELECT * FROM `valueaddedlog`|1|2|2||0|0|31774|31774|31774|31774|
|score_player|SELECT * FROM `supervise_record`|1|1|1||0|0|18399|18399|18399|18399|
|v4_sales|SELECT * FROM `warranty_detail_img`|1|36|36||0|0|1384665|1384665|1384665|1384665|
|v4_employee|SELECT t?.average_score,emp.employee_name,es.sales_no,tm.member_name,tm.mobile_no FROM v4_sales.`comment`t? JOIN v4_sales.erp_sales es ON es.id=t?.order_id AND es.tenant_id=t?.tenant_id AND es.tenant_app_id=t?.tenant_app_id AND es.is_sales=? AND es.sales_status=? JOIN tenant.employee emp ON emp.tenant_id=t?.tenant_id AND emp.employee_erp_id=es.employee_erp_id LEFT JOIN v4_employee.shop sp ON es.tenant_id=sp.tenant_id AND es.dept_erp_id=sp.dept_id LEFT JOIN v4_user.member tm ON t?.tenant_id=tm.tenant_id AND t?.tenant_app_id=tm.tenant_app_id AND t?.member_id=tm.id WHERE t?.tenant_id=? AND sp.id IN (?) AND t?.create_time>=? AND t?.create_time<=? AND t?.average_score<t?.low_score|1|3|3||0|0|69933|69933|0|0|
|mini_app|SELECT * FROM `app_qrcode`|1|2|2||0|0|338286|338286|338286|338286|
|v4_sales|SELECT * FROM `value_added_record`|1|39|39||0|0|2514224|2514224|2514224|2514224|
|position|SELECT * FROM `geo_position`|1|312|312||0|0|10050050|10050050|10050050|10050050|
|tenant|SELECT * FROM `employee_tenant_user`|1|1|1||0|0|35872|35872|35872|35872|
|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|2359|2359|344|344|
|v4_user|SELECT * FROM `cwx_external_user`|1|42|42||0|0|5417701|5417701|5417701|5417701|
|qrcode_service|SELECT * FROM `qrcode_scan_log`|1|157|157||0|0|3860960|3860960|3860960|3860960|
|mini_app|SELECT * FROM `mini_qrcode_params`|1|9|9||0|0|982305|982305|982305|982305|
|v4_user|SELECT * FROM `member_butler`|1|21|21||0|0|4134400|4134400|4134400|4134400|
|user_service|SELECT * FROM `wx_user_mobile_no`|1|3|3||0|0|908330|908330|908330|908330|
|shop_work|SELECT * FROM `task_item`|1|61|61||0|0|1091587|1091587|1091587|1091587|
|sms|SELECT * FROM `sms_report`|1|977|977||0|0|10758326|10758326|10758326|10758326|
|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|
|message_push|SELECT * FROM `message_log_back`|1|31|31||0|0|839236|839236|839236|839236|
|v4_user|SELECT * FROM `employee_external_bind_log`|1|76|76||0|0|12041521|12041521|12041521|12041521|
|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|367|367||0|0|691295|691295|691295|691295|
|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|34068|34068|34068|34068|
|v4_sales|SELECT * FROM `warranty_can_added`|1|79|79||0|0|3556927|3556927|3556927|3556927|
|authorization_service|SELECT * FROM `ip_table_local`|1|1|1||0|0|462824|462824|462824|462824|
|account|SELECT DISTINCT tenant_wechatapp_id tenant_app_id,date_format(create_time,?) AS statistic_date,sales_date AS busi_date FROM tenant.erp_sales WHERE tenant_id=? AND tenant_wechatapp_id=? AND update_time>=? AND update_time<=? AND sales_status=?|1|1|1||0|0|0|0|0|0|
|v4_user|SELECT DATE_FORMAT(t?.sales_date,?) AS statistic_date,DATE_FORMAT(t?.sales_date,?) AS statistic_month,? AS statistic_version,DATE_FORMAT(t?.update_time,?) AS busi_date,? AS sale_status,t?.tenant_id,t?.tenant_app_id,ifnull(sp.id,?) AS shop_id,ifnull(emp.id,?) AS employee_id,?*count(*) AS sales_order,?*ifnull(sum(t?.amount),?) AS sales_amount,?*ifnull(sum(if(t?.member_erp_id=?,?,?)),?) AS no_sales_order,?*ifnull(sum(if(t?.member_erp_id=?,t?.amount,?)),?) AS no_sales_amount,?*ifnull(sum(if(t?.member_erp_id>? AND t?.member_status=?,?,?)),?) AS new_sales_order,?*ifnull(sum(if(t?.member_erp_id>? AND t?.member_status=?,t?.amount,?)),?) AS new_sales_amount FROM v4_sales.erp_sales t? JOIN v4_sales.erp_sales_extend? t? ON t?.tenant_id=t?.tenant_id AND t?.id=t?.id LEFT JOIN v4_employee.shop sp ON t?.tenant_id=sp.tenant_id AND t?.dept_erp_id=sp.dept_id LEFT JOIN tenant.employee emp ON t?.tenant_id=emp.tenant_id AND t?.employee_erp_id=emp.employee_erp_id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<? AND t?.is_sales=? AND t?.sales_status=? GROUP BY t?.tenant_id,t?.tenant_app_id,sp.id,emp.id,DATE_FORMAT(t?.sales_date,?),DATE_FORMAT(t?.sales_date,?),DATE_FORMAT(t?.update_time,?) LIMIT ? OFFSET ?|1|1|1||0|0|3383|3383|10|10|
|shop_work|SELECT * FROM `report_data_source`|1|7|7||0|0|57893|57893|57893|57893|
|platform|SELECT * FROM `custommadeorderstatus`|1|1|1||0|0|37709|37709|37709|37709|
|order|SELECT * FROM `order_info`|1|32|32||0|0|265994|265994|265994|265994|
|payment|SELECT * FROM `refund_order`|1|2|2||0|0|14285|14285|14285|14285|
|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|27|27||0|0|940234|940234|0|0|
|v4_user|SELECT * FROM `member_butler_back`|1|1|1||0|0|372098|372098|372098|372098|
|sms|SELECT * FROM `sms_send_extend`|1|75|75||0|0|3748564|3748564|3748564|3748564|
|sms|SELECT * FROM `sms_send`|1|992|992||0|0|9377124|9377124|9377124|9377124|
|order|SELECT * FROM `order_operator_log`|1|50|50||0|0|1100353|1100353|1100353|1100353|
|order|SELECT * FROM `order_service_log`|1|1|1||0|0|26389|26389|26389|26389|
|account|SELECT sales_date,tenant_id,tenant_wechatapp_id tenant_app_id,dept_erp_id shop_id,employee_erp_id user_id,count(*)amount FROM tenant.erp_sales WHERE tenant_id=? AND tenant_wechatapp_id=? AND sales_status IN (?) AND is_sales=? AND create_time>=? AND create_time<=? GROUP BY tenant_id,tenant_app_id,sales_date,dept_erp_id,employee_erp_id|1|1|1||0|0|717|717|2|2|
|payment|SELECT * FROM `refund_order_msg`|1|16|16||0|0|14285|14285|14285|14285|
|v4_sales|SELECT * FROM `warranty_detail`|1|44|44||0|0|4558665|4558665|4558665|4558665|
|tenant|SELECT * FROM `employee_shop`|1|3|3||0|0|93527|93527|93527|93527|
|employee|SELECT * FROM `backlog_detail`|1|8|8||0|0|1429463|1429463|1429463|1429463|
|user_service|SELECT * FROM `wx_user`|1|146|146||0|0|12550700|12550700|12550700|12550700|
|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|17958|17958|0|0|
|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|44308|44308|37|37|
|payment|SELECT * FROM `close_order_msg`|1|10|10||0|0|41074|41074|41074|41074|
|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|21|21||0|0|35525|35525|32|32|
|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 * FROM `member`|1|39|39||0|0|4136240|4136240|4136240|4136240|
|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|5466|5466|1|1|
|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|2|2||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|52130|52130|0|0|
|v4_coupon|SELECT * FROM `coupon`|1|9|9||0|0|1100908|1100908|1100908|1100908|
|tenant|SELECT * FROM `erp_employee`|1|5|5||0|0|88488|88488|88488|88488|
|shop_work|SELECT * FROM `task`|1|81|81||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|1|1||0|0|5008|5008|397|397|
|platform|SELECT * FROM `tbhy_hyda_sync`|1|1|1||0|0|15838|15838|15838|15838|
|v4_sales|SELECT * FROM `warranty`|1|92|92||0|0|2629810|2629810|2629810|2629810|
|platform|SELECT * FROM `custommadeorder`|1|4|4||0|0|11805|11805|11805|11805|
|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|1|1||0|0|7356|7356|290|290|
|qrcode_service|SELECT * FROM `qrcode`|1|6|6||0|0|77815|77815|77815|77815|
|qrcode_login|SELECT * FROM `qrcode_log`|1|1|1||0|0|8231|8231|8231|8231|
|account|SELECT count(*) FROM tenant.sjfx_dct_erp_sales_detail WHERE version>?|1|1|1||0|0|170046|170046|1|1|
|v4_sales|SELECT * FROM `erp_sales_detail`|1|377|377||0|0|13257507|13257507|13257507|13257507|
|payment|SELECT * FROM `pay_order`|1|58|58||0|0|349010|349010|349010|349010|
|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|1482|1482|494|494|
|platform|SELECT * FROM `callbacklog`|1|3|3||0|0|34421|34421|34421|34421|
|erp_sync|SELECT * FROM `cwx_checkin_sync_log`|1|10|10||0|0|264814|264814|264814|264814|
|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|
|activity_service|SELECT * FROM `user_trace`|1|15|15||0|0|1263687|1263687|1263687|1263687|
|v4_user|SELECT DATE_FORMAT(tt?.recept_time,?) AS statistic_date,DATE_FORMAT(tt?.recept_time,?) AS statistic_month,DATE_FORMAT(tt?.create_time,?) AS busiDate,tt?.tenant_id,tt?.tenant_app_id,tt?.shop_id,tt?.fieldName,tt?.fieldValue,count(*) AS total FROM (SELECT t?.id AS reception_customer_id,t?.recept_time,t?.create_time,t?.tenant_id,t?.tenant_app_id,t?.shop_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,?),DATE_FORMAT(tt?.create_time,?),tt?.tenant_id,tt?.tenant_app_id,tt?.shop_id,tt?.fieldName,tt?.fieldValue|1|10|10||0|0|35483|35483|11|11|
|v4_user|SELECT * FROM `employee_external_bind`|1|51|51||0|0|7100216|7100216|7100216|7100216|
|v4_user|SELECT DATE_FORMAT(es.sales_date,?) AS statistic_date,DATE_FORMAT(es.sales_date,?) AS statistic_month,DATE_FORMAT(es.update_time,?) AS busi_date,es.tenant_id,es.tenant_app_id,ifnull(sp.id,?) AS shop_id,ifnull(emp.id,es.employee_erp_id) AS employee_id,? AS saleStatus,?*count(t?.id) AS added FROM v4_sales.warranty t? JOIN v4_sales.erp_sales es ON es.tenant_id=t?.tenant_id AND es.id=t?.sales_id AND es.is_sales=? AND es.sales_status=? LEFT JOIN tenant.employee emp ON es.tenant_id=emp.tenant_id AND es.employee_erp_id=emp.employee_erp_id LEFT JOIN v4_employee.shop sp ON es.tenant_id=sp.tenant_id AND es.dept_erp_id=sp.dept_id WHERE es.tenant_id=? AND es.tenant_app_id=? AND es.update_time>=? AND es.update_time<? GROUP BY es.tenant_id,es.tenant_app_id,sp.id,emp.id,es.employee_erp_id,DATE_FORMAT(es.sales_date,?),DATE_FORMAT(es.sales_date,?),DATE_FORMAT(es.update_time,?) LIMIT ? OFFSET ?|1|1|1||0|0|243|243|0|0|
|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|2550|2550|425|425|
|sms|SELECT * FROM `sms_send_back`|1|1|1||0|0|16036|16036|16036|16036|
|v4_user|SELECT * FROM `member_butler_update_error`|1|11|11||0|0|1591768|1591768|1591768|1591768|
|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|1|1|1||0|0|561|561|88|88|
|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|66916|66916|66916|66916|
|platform|SELECT * FROM `productdesc`|1|1|1||0|0|2228|2228|2228|2228|
