|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|v4_user|SELECT DISTINCT DATE_FORMAT(t?.create_time,?) FROM v4_sales.erp_sales t? WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<? AND t?.create_time<? AND t?.is_sales=? AND t?.sales_status IN(?)|3|5|2||0|0|570900|272447|24|8|
|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 ?|3|4|2||0|0|18023|7210|1757|931|
|v4_user|SELECT t?.tenant_id,t?.tenant_app_id,DATE_FORMAT(t?.recept_time,?) AS statistic_date,DATE_FORMAT(t?.recept_time,?) AS statistic_month,DATE_FORMAT(t?.recept_time,?) AS `hour`,DATE_FORMAT(t?.create_time,?) AS busi_date,t?.shop_id,count(*) AS total FROM v4_user.reception_customer 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,DATE_FORMAT(t?.recept_time,?),DATE_FORMAT(t?.recept_time,?),DATE_FORMAT(t?.recept_time,?),DATE_FORMAT(t?.create_time,?),t?.shop_id LIMIT ? OFFSET ?|3|6|3||0|0|247768|102303|145|85|
|v4_employee|SELECT * FROM `employee`|3|10|7||0|0|122270|94936|122270|94936|
|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 od.create_time>=? AND od.create_time<=? AND (od.status=?) ORDER BY od.create_time DESC|3|6|3||0|0|23501|8137|7156|2660|
|account|SELECT * FROM `wx_redpacket_send_order`|2|142|116||0|0|1772407|886205|1772407|886205|
|v4_user|SELECT t.scene AS scence,count(*) AS couponNum FROM v4_coupon.coupon t WHERE t.tenant_id=? AND t.tenant_app_id=? AND t.create_time>=? AND t.create_time<? GROUP BY t.scene|2|2|1||0|0|28768|14384|6|3|
|account|SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.goods_id AS goodsId,t?.goods_name AS goodsName,t?.barcode,t?.spec,t?.sales_volume AS salesVolume,t?.quantity FROM goods.goods_sku t? JOIN goods.goods t? ON t?.goods_id=t?.id WHERE t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<=? LIMIT ? OFFSET ?|2|2|1||0|0|43291|21648|0|0|
|new_shop_work|SELECT * FROM `task_item`|2|78|75||0|0|1121683|1091587|1121683|1091587|
|activity_service|SELECT * FROM `lottery_winner`|2|545|512||0|0|836669|418376|836669|418376|
|comment_service|SELECT * FROM `comment`|2|46|43||0|0|1057163|993262|1057163|993262|
|user_service|SELECT * FROM `user_employee_?`|2|65|43||0|0|1234777|835482|1234777|835482|
|v4_user|SELECT t.tenant_id,t.tenant_app_id,t.registry_shop_id AS shopId,date_format(?,?) 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.registry_shop_id=? AND t.create_time>=? AND t.create_time<DATE_ADD(?,INTERVAL ? Day) GROUP BY t.tenant_id,t.tenant_app_id,t.registry_shop_id,t.source_type|2|2|1||0|0|83579|47849|2|1|
|coupon_service|SELECT * FROM `employee_give_coupon_log`|2|34|32||0|0|859283|815815|859283|815815|
|activity_service|SELECT * FROM `activity_qualified`|2|6|4||0|0|134015|118670|134015|118670|
|activity_service|SELECT * FROM `activity_gift_grant`|2|7|6||0|0|362450|181225|362450|181225|
|account|SELECT t?.id,t?.tenant_id,t?.tenant_wechatapp_id AS tenantAppId,t?.dept_erp_id AS deptErpId,t?.employee_erp_id AS empErpId,t?.sales_erp_id AS salesErpId,tb.erp_member_id AS memberId,t?.score,t?.content,t?.create_time AS commentDate FROM comment_service.`comment` t? JOIN tenant.erp_sales t? ON t?.tenant_id=t?.tenant_id AND t?.primary_key_id=t?.id JOIN user_service.tenant_member_bind tb ON tb.tenant_id=t?.tenant_id AND tb.tenant_app_id=t?.tenant_wechatapp_id AND tb.user_id=t?.user_id AND tb.tenant_id=? WHERE t?.tenant_id=? AND t?.tenant_wechatapp_id=? AND t?.type=? AND t?.create_time>=? AND t?.create_time<=? LIMIT ? OFFSET ?|2|2|1||0|0|0|0|0|0|
|account|SELECT t.id,t.tenant_id,t.tenant_wechatapp_id,t.sales_erp_id,t.sales_date,t.member_erp_id,t.dept_erp_id,t.employee_erp_id,t.amount,t.sales_status,t.is_sales,ct.id AS pk_id,ct.change_type AS SYS_CHANGE_OPERATION FROM tenant.erp_sales AS t RIGHT OUTER JOIN tenant.sjfx_dct_erp_sales ct ON t.id=ct.id WHERE ct.version>? AND (t.tenant_id=?)|2|2|1||0|0|9|5|0|0|
|activity_service|SELECT * FROM `assist_task_user`|2|23|21||0|0|800044|400022|800044|400022|
|coupon_service|SELECT * FROM `coupon_extend`|2|1723|1500||0|0|14011649|11958462|14011649|11958462|
|account|SELECT min(create_time)create_time FROM coupon_service.template WHERE tenant_id=? AND tenant_app_id=?|2|2|1||0|0|44068|22034|2|1|
|v4_user|SELECT DATE_FORMAT(t?.create_time,?) AS statistic_date,DATE_FORMAT(t?.create_time,?) AS statistic_month,DATE_FORMAT(t?.update_time,?) AS busi_date,t?.tenant_id,t?.tenant_app_id,eg.shop_id,eg.employee_id,? AS `status`,?*count(t?.coupon_id) AS used FROM v4_coupon.coupon t? JOIN v4_coupon.coupon_write_off t? ON t?.id=t?.coupon_id JOIN v4_coupon.coupon_grant cg ON t?.grant_id=cg.id JOIN v4_coupon.employee_grant_record eg ON cg.business_id=eg.id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<? AND t?.`status`=? GROUP BY t?.tenant_id,t?.tenant_app_id,eg.shop_id,eg.employee_id,DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.update_time,?) LIMIT ? OFFSET ?|2|3|1||0|0|36790|34064|0|0|
|corpwx|SELECT * FROM `external_user`|2|723|591||0|0|22895378|11451960|22895378|11451960|
|new_shop_work|SELECT * FROM `work_report`|2|3|2||0|0|26586|19290|26586|19290|
|activity_service|SELECT * FROM `user_trace`|2|162|148||0|0|2526450|1263233|2526450|1263233|
|account|SELECT * FROM `wx_redpacket_send_msg`|2|234|192||0|0|1637381|818692|1637381|818692|
|activity_service|SELECT * FROM `online_sign_user_sign_log`|2|9|6||0|0|951680|475915|951680|475915|
|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.product_name LIKE concat(?,?,?) AND t.trade_type=? ORDER BY t.id DESC|2|3|2||0|0|5030|3840|94|55|
|activity_service|SELECT * FROM `intelligent_marketing_activity_gift`|2|34|31||0|0|996108|498054|996108|498054|
|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 ?|2|2|1||0|0|12012|12012|2002|2002|
|account|SELECT * FROM `account_flow`|2|1284|1122||0|0|32624631|16312455|32624631|16312455|
|corpwx_license|SELECT * FROM `active_log`|1|1|1||0|0|18083|18083|18083|18083|
|corpwx|SELECT * FROM `contact_me`|1|8|8||0|0|104688|104688|104688|104688|
|activity_service|SELECT * FROM `online_sign_user`|1|5|5||0|0|143954|143954|143954|143954|
|corpwx_license|SELECT * FROM `cwx_sync_list_order_account`|1|2|2||0|0|29848|29848|29848|29848|
|v4_user|SELECT es?.tenant_id AS tenantId,es?.tenant_app_id AS tenantAppId,es?.member_erp_id AS id,max(es?.sales_erp_id) AS saleErpId FROM v4_sales.erp_sales es? JOIN (SELECT es.member_erp_id AS member_erp_id,max(es.sales_date) AS sales_date FROM v4_sales.erp_sales es WHERE es.tenant_id=? AND es.tenant_app_id=? AND es.is_sales=? AND es.sales_status=? AND es.member_erp_id IN (?) GROUP BY es.tenant_id,es.tenant_app_id,es.member_erp_id)es? ON es?.member_erp_id=es?.member_erp_id AND es?.sales_date=es?.sales_date WHERE es?.tenant_id=? AND es?.tenant_app_id=? AND es?.is_sales=? AND es?.sales_status=? AND es?.member_erp_id IN (?) GROUP BY es?.tenant_id,es?.tenant_app_id,es?.member_erp_id|1|4|4||0|0|16813|16813|83|83|
|tenant|SELECT * FROM `erp_sales_back_?`|1|50|50||0|0|438960|438960|438960|438960|
|shop_work|SELECT * FROM `task_old`|1|1|1||0|0|3211|3211|3211|3211|
|activity_service|SELECT * FROM `activity_signup_user_apply`|1|7|7||0|0|22312|22312|22312|22312|
|employee|SELECT * FROM `backlog_report`|1|2|2||0|0|40501|40501|40501|40501|
|coupon_service|SELECT * FROM `template`|1|1|1||0|0|22034|22034|22034|22034|
|activity_service|SELECT * FROM `intelligent_push_msg_obj`|1|482|482||0|0|6108350|6108350|6108350|6108350|
|coupon_service|SELECT * FROM `coupon_not_received`|1|19|19||0|0|488583|488583|488583|488583|
|order|SELECT * FROM `order_detail`|1|49|49||0|0|264070|264070|264070|264070|
|export|SELECT sg.id,sg.sneak_guest_no,sg.user_id,sg.user_type,ifnull(tm.user_name,ceu.nick_name) AS userName,(CASE WHEN sg.user_type=? THEN ? ELSE tm.mobile_no END) AS mobileNo,ey.employee_name AS maintainEmployeeName,sg.last_maintain_date,ws.shop_name AS createShopName,sg.status,sg.create_time,t?.employee_name AS createEmployeeName,sg.finish_date,gs.sales_id,gs.sales_no,w?.shop_name AS salesShopName,gs.create_time AS salesDate,gs.product_name,gs.product_quantity,gs.amount salesAmount, CASE WHEN sg.status=? THEN ? ELSE ? END statusName,if(sg.status=?,(CASE WHEN sg.fail_type=? THEN ? ELSE ifnull(emp.employee_name,?) END),?) AS operFailEmployeeName,if(sg.status=?,sg.finish_date,?) AS failTime,(CASE fail_type WHEN ? THEN ? ELSE ? END) AS failType,DATEDIFF(if(sg.status=? OR sg.status=?,sg.finish_date,CURRENT_DATE),sg.create_time) AS addDate FROM tenant.sneak_guest sg LEFT JOIN user_service.tenant_member tm ON sg.tenant_id=tm.tenant_id AND sg.tenant_app_id=tm.tenant_app_id AND sg.user_id=tm.user_id AND sg.user_type=? LEFT JOIN corpwx.corpwx_external_user ceu ON sg.tenant_id=ceu.tenant_id AND sg.user_id=ceu.id AND sg.user_type=? LEFT JOIN tenant.employee ey ON sg.maintain_employee_id=ey.id LEFT JOIN tenant.tenant_wechatapp_shop ws ON sg.create_shop_id=ws.id LEFT JOIN tenant.employee t? ON sg.create_employee_id=t?.id LEFT JOIN tenant.sneak_guest_sales gs ON sg.tenant_app_id=gs.tenant_app_id AND sg.id=gs.sneak_guest_id LEFT JOIN tenant.tenant_wechatapp_shop w? ON gs.shop_id=w?.id LEFT JOIN tenant.sneak_guest_maintain gm ON gm.sneak_guest_id=sg.id AND gm.event_type=? LEFT JOIN tenant.employee emp ON gm.employee_id=emp.id WHERE sg.tenant_app_id=? AND sg.create_time>=? AND sg.create_time<=? AND gs.create_time>=? AND gs.create_time<=? ORDER BY sg.id DESC|1|1|1||0|0|2630|2630|132|132|
|coupon_service|SELECT * FROM `coupon_expire_task`|1|37|37||0|0|837469|837469|837469|837469|
|timer|SELECT * FROM `task_info`|1|13|13||0|0|204810|204810|204810|204810|
|customer|SELECT * FROM `customer_entry_shop`|1|2|2||0|0|38729|38729|38729|38729|
|coupon_service|SELECT * FROM `write_off_log`|1|3|3||0|0|76597|76597|76597|76597|
|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|5635|5635|0|0|
|user_service|SELECT * FROM `fix_duplicate_user`|1|1|1||0|0|41463|41463|41463|41463|
|corpwx_license|SELECT * FROM `cwx_sync_list_actived_account`|1|1|1||0|0|15302|15302|15302|15302|
|v4_sales|SELECT * FROM `warranty_detail`|1|18|18||0|0|4476750|4476750|4476750|4476750|
|corpwx|SELECT * FROM `external_user_log`|1|329|329||0|0|12618417|12618417|12618417|12618417|
|authorization_service|SELECT * FROM `user_login_token`|1|3494|3494||0|0|35509860|35509860|35509860|35509860|
|tenant|SELECT * FROM `sjfx_dct_erp_sales_detail`|1|3|3||0|0|147478|147478|147478|147478|
|employee|SELECT * FROM `batch_job_execution`|1|5|5||0|0|125594|125594|125594|125594|
|instant_messaging|SELECT * FROM `messages`|1|1|1||0|0|27610|27610|27610|27610|
|qrcode_service|SELECT * FROM `qrcode_scan_log`|1|143|143||0|0|3821379|3821379|3821379|3821379|
|coupon_service|SELECT * FROM `coupon_user`|1|72|72||0|0|792948|792948|792948|792948|
|user_service|SELECT * FROM `user`|1|253|253||0|0|3647898|3647898|3647898|3647898|
||SELECT * FROM timer.task_execute_log t WHERE t.task_id=? ORDER BY id DESC LIMIT ?|1|135|135||0|0|4546489|4546489|0|0|
|platform|SELECT * FROM `custommadeorder`|1|5|5||0|0|11805|11805|11805|11805|
|coupon_service|SELECT * FROM `coupon_write_off_log`|1|254|254||0|0|7144734|7144734|7144734|7144734|
|activity_service|SELECT * FROM `vote_log`|1|9|9||0|0|2605213|2605213|2605213|2605213|
|export|SELECT cu.id couponId,cu.coupon_name,cu.coupon_type,CASE cu.coupon_type WHEN ? THEN ? ELSE ? END couponTypeName,cu.coupon_no, CASE cu.source WHEN ? THEN ? ELSE ? END couponChannelName, CASE cu.coupon_state WHEN ? THEN ? ELSE ? END couponStateName,ce.user_name,ce.creator_user_name,round(cu.face_value/?,?) AS faceValue,round(cu.balance/?,?) AS balance,cu.begin_time,cu.end_time,ce.remark,ce.mobile_no,ce.creator_mobile_no,cu.create_time,ce.writeoff_time,cu.user_id,if(ce.source_user_type=?,ce.source_user_id,?)employeeId,ce.member_source_shop FROM coupon_service.coupon cu JOIN coupon_service.coupon_extend ce ON ce.tenant_id=? AND ce.tenant_app_id=? AND ce.id=cu.id WHERE cu.tenant_id=? AND cu.tenant_app_id=? AND cu.template_id=?|1|5|5||0|0|4576|4576|2288|2288|
|coupon_service|SELECT * FROM `coupon_market_order_detail`|1|18|18||0|0|994434|994434|994434|994434|
|activity_service|SELECT * FROM `cutdown_price_activity_apply`|1|5|5||0|0|105762|105762|105762|105762|
|account|SELECT * FROM (SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.share_user_id AS user_id,t?.user_name AS user_name,t?.share_user_type AS user_identity,t?.business_id AS activity_id,t?.activity_name AS activity_name,DATE_FORMAT(oi.finish_time,?) AS busi_date,count(*) AS deal_amount,ifnull(sum(oi.total_fee),?) AS deal_money FROM goods.`share` t? JOIN goods.share_detail sd ON t?.id=sd.share_id JOIN ORDER.order_info oi ON sd.order_id=oi.id AND oi.tenant_wechatapp_id=? AND oi.status=? JOIN activity_service.activity t? ON t?.business_id=t?.id JOIN user_service.tenant_member t? ON t?.tenant_id=t?.tenant_id AND t?.tenant_app_id=t?.tenant_app_id AND t?.share_user_id=t?.user_id WHERE t?.tenant_app_id=? AND t?.share_user_type=? AND t?.business_type!=? AND oi.finish_time>=? AND oi.finish_time<=? GROUP BY t?.id,DATE_FORMAT(oi.finish_time,?) UNION ALL SELECT t?.id,t?.tenant_id,t?.tenant_app_id,t?.share_user_id AS user_id,t?.employee_name AS user_name,t?.share_user_type AS user_identity,t?.business_id AS activity_id,t?.activity_name AS activity_name,DATE_FORMAT(oi.finish_time,?) AS busi_date,count(*) AS deal_amount,ifnull(sum(oi.total_fee),?) AS deal_money FROM goods.`share` t? JOIN goods.share_detail sd ON t?.id=sd.share_id JOIN ORDER.order_info oi ON sd.order_id=oi.id AND oi.tenant_wechatapp_id=? AND oi.status=? JOIN activity_service.activity t? ON t?.business_id=t?.id JOIN tenant.employee t? ON t?.share_user_id=t?.id WHERE t?.tenant_app_id=? AND t?.share_user_type=? AND t?.business_type!=? AND oi.finish_time>=? AND oi.finish_time<=? GROUP BY t?.id,DATE_FORMAT(oi.finish_time,?))tt ORDER BY tt.id ASC LIMIT ? OFFSET ?|1|2|2||0|0|3003|3003|0|0|
|account|SELECT t.tenant_id,t.tenant_app_id,t.shop_id,t.user_id,t.scene,t.busi_date,count(*)total_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.scene NOT IN(?) AND bg.create_time>=? AND bg.create_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|8403|8403|1005|1005|
|v4_activity|SELECT * FROM `lottery_member`|1|2|2||0|0|18224|18224|18224|18224|
|sms|SELECT * FROM `sms_send_extend`|1|73|73||0|0|3732828|3732828|3732828|3732828|
|mini_app|SELECT * FROM `mini_qrcode_params`|1|33|33||0|0|967389|967389|967389|967389|
|v4_giftmall|SELECT * FROM `trade_take`|1|1|1||0|0|11017|11017|11017|11017|
|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|1513|1513|272|272|
|corpwx|SELECT * FROM `task_card_send_record`|1|264|264||0|0|799727|799727|799727|799727|
|bespoke|SELECT * FROM `bespoke_trade_status`|1|7|7||0|0|171692|171692|171692|171692|
|account|SELECT * FROM `store_card_detail`|1|1|1||0|0|13286|13286|13286|13286|
|payment|SELECT * FROM `close_order_msg`|1|11|11||0|0|40675|40675|40675|40675|
|customer|SELECT * FROM `customer_maintain_follow`|1|1|1||0|0|24090|24090|24090|24090|
|activity_service|SELECT * FROM `sign_in_activity_log`|1|7|7||0|0|39625|39625|39625|39625|
|check_stock|SELECT * FROM `realtime_gold_price`|1|18|18||0|0|553064|553064|553064|553064|
|customer|SELECT * FROM `tenant_user_image`|1|42|42||0|0|1615602|1615602|1615602|1615602|
|v4_user|SELECT * FROM `member_butler_update_error`|1|11|11||0|0|1591768|1591768|1591768|1591768|
|customer|SELECT * FROM `customer_maintain_log`|1|2|2||0|0|26482|26482|26482|26482|
|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|796|796|1|1|
|activity_service|SELECT * FROM `lottery_prize`|1|5|5||0|0|13576|13576|13576|13576|
|item_manage|SELECT * FROM `unread_log`|1|1|1||0|0|65692|65692|65692|65692|
|corpwx|SELECT * FROM `corp_mini_qrcode_params`|1|19|19||0|0|729982|729982|729982|729982|
|user_service|SELECT * FROM `user_employee_back_?`|1|5|5||0|0|126632|126632|126632|126632|
|user_service|SELECT * FROM `user_employee`|1|480|480||0|0|13930270|13930270|13930270|13930270|
|order|SELECT * FROM `order_info`|1|75|75||0|0|264070|264070|264070|264070|
|activity_service|SELECT * FROM `assist_task_receive_prize`|1|6|6||0|0|10487|10487|10487|10487|
|v4_user|SELECT ifnull(group_concat(DISTINCT IF(es.sales_status=?,sd.category_erp_id,?)),?)saleCategoryIds,ifnull(group_concat(DISTINCT IF(es.sales_status=?,ifnull(pc.category_name,sd.category_name),?)),?) AS saleCategoryNames,ifnull(GROUP_CONCAT(DISTINCT IF(es.sales_status=?,if(sd.sales_brand=? OR sd.sales_brand=?,?,sd.sales_brand),?)),?) AS salesBrand,ifnull(GROUP_CONCAT(DISTINCT IF(es.sales_status=?,if(sd.sales_craft=? OR sd.sales_craft=?,?,sd.sales_craft),?)),?) AS salesCraft FROM v4_sales.erp_sales es INNER JOIN v4_sales.erp_sales_detail sd ON sd.tenant_id=es.tenant_id AND es.tenant_app_id=sd.tenant_app_id AND es.sales_erp_id=sd.sales_erp_id AND sd.sales_type=? LEFT JOIN v4_sales.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_app_id=? AND es.member_erp_id IN (?) AND es.is_sales=? AND es.sales_status>=?|1|5|5||0|0|12454|12454|1|1|
|user_service|SELECT * FROM `tenant_member_change_shop`|1|171|171||0|0|2821399|2821399|2821399|2821399|
|employee|SELECT * FROM `batch_job_instance`|1|3|3||0|0|125594|125594|125594|125594|
|employee|SELECT * FROM `backlog_detail`|1|39|39||0|0|1429463|1429463|1429463|1429463|
|coupon_service|SELECT * FROM `coupon_give`|1|2|2||0|0|66273|66273|66273|66273|
|customer|SELECT * FROM `tenant_user_received`|1|2|2||0|0|28781|28781|28781|28781|
|activity_service|SELECT * FROM `scene_luck_winner`|1|1|1||0|0|2807|2807|2807|2807|
|order|SELECT * FROM `order_operator_log`|1|66|66||0|0|1091284|1091284|1091284|1091284|
|customer|SELECT * FROM `customer_info`|1|1|1||0|0|33651|33651|33651|33651|
|user_service|SELECT * FROM `customer_user`|1|2|2||0|0|32853|32853|32853|32853|
|v4_sales|SELECT * FROM `warranty_detail_img`|1|11|11||0|0|1344333|1344333|1344333|1344333|
|employee|SELECT * FROM `backlog_file`|1|341|341||0|0|9969731|9969731|9969731|9969731|
|employee|SELECT * FROM `batch_job_execution_params`|1|19|19||0|0|638134|638134|638134|638134|
|platform|SELECT * FROM `callbacklog`|1|2|2||0|0|34421|34421|34421|34421|
|v4_sales|SELECT * FROM `comment_not_remind_sales`|1|3|3||0|0|119903|119903|119903|119903|
|corpwx|SELECT * FROM `corpwx_external_user`|1|464|464||0|0|8156775|8156775|8156775|8156775|
|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|3034|3034|430|430|
|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=? LEFT 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 t?.tenant_app_id=? AND sp.id=? AND t?.create_time>=? AND t?.create_time<=? AND t?.average_score<t?.low_score|1|2|2||0|0|63894|63894|0|0|
|customize_page|SELECT * FROM `gift_qualified`|1|4|4||0|0|165082|165082|165082|165082|
|message_push|SELECT * FROM `message_log_back`|1|3104|3104||0|0|10834520|10834520|10834520|10834520|
|message_push|SELECT * FROM `message_log`|1|648|648||0|0|3272558|3272558|3272558|3272558|
|activity_service|SELECT * FROM `activity`|1|1|1||0|0|9786|9786|9786|9786|
|coupon_service|SELECT * FROM `grant_info`|1|2|2||0|0|43456|43456|43456|43456|
|order|SELECT * FROM `order_address`|1|14|14||0|0|264070|264070|264070|264070|
|bespoke|SELECT * FROM `bespoke_trade`|1|27|27||0|0|57510|57510|57510|57510|
|corpwx_license|SELECT * FROM `cwx_sync_active_info`|1|2|2||0|0|29628|29628|29628|29628|
|corpwx_license|SELECT * FROM `active_code`|1|3|3||0|0|29665|29665|29665|29665|
|user_service|SELECT * FROM `tenant_member`|1|884|884||0|0|18702503|18702503|18702503|18702503|
|gift_mail|SELECT * FROM `inventory_log`|1|6|6||0|0|200646|200646|200646|200646|
|export|SELECT sp.id AS shopId,sp.shop_name AS shopName,ifnull(sum(tt.maintainCount),?) AS maintainCount,ifnull(sum(tt.maintainNum),?) AS maintainNum,ifnull(sum(tt.successNum),?) AS successNum,ifnull(sum(tt.failNum),?) AS failNum,ifnull(sum(tt.saleMoney),?) AS saleMoney FROM tenant.tenant_wechatapp_shop sp LEFT JOIN (SELECT g.create_shop_id AS shop_id,count(?) AS maintainCount,count(DISTINCT t.sneak_guest_id) AS maintainNum,? AS successNum,? AS failNum,? AS saleMoney FROM tenant.sneak_guest g JOIN tenant.sneak_guest_maintain t ON t.sneak_guest_id=g.id WHERE g.tenant_app_id=? AND (g.fail_type IS ? OR g.fail_type=?) AND t.event_type IN (?) AND t.create_time>=? AND t.create_time<? GROUP BY g.create_shop_id UNION ALL SELECT g.create_shop_id AS shop_id,? AS maintainCount,? AS maintainNum,count(sgs.sneak_guest_id) AS successNum,? AS failNum,sum(sgs.`amount`) AS saleMoney FROM tenant.sneak_guest g JOIN tenant.sneak_guest_sales sgs ON g.tenant_app_id=sgs.tenant_app_id AND g.id=sgs.sneak_guest_id WHERE g.tenant_app_id=? AND sgs.create_time>=? AND sgs.create_time<? GROUP BY g.create_shop_id UNION ALL SELECT g.create_shop_id AS shop_id,? AS maintainCount,? AS maintainNum,? AS successNum,count(DISTINCT t.sneak_guest_id) AS failNum,? AS saleMoney FROM tenant.sneak_guest g JOIN tenant.sneak_guest_maintain t ON t.sneak_guest_id=g.id WHERE g.tenant_app_id=? AND g.fail_type=? AND t.event_type IN (?) AND t.create_time>=? AND t.create_time<? GROUP BY g.create_shop_id)tt ON sp.id=tt.shop_id WHERE sp.status=? AND sp.tenant_wechatapp_id=? GROUP BY sp.id,sp.shop_name ORDER BY sp.id|1|103|103||0|0|889967|889967|23|23|
|customize_page|SELECT * FROM `award_qualified`|1|55|55||0|0|1177578|1177578|1177578|1177578|
|v4_sales|SELECT * FROM `comment_detail`|1|12|12||0|0|319505|319505|319505|319505|
|customize_page|SELECT * FROM `customize_page`|1|3|3||0|0|5673|5673|5673|5673|
|platform|SELECT * FROM `custommadeorderstatus`|1|1|1||0|0|37709|37709|37709|37709|
|v4_coupon|SELECT * FROM `sales_give_coupon_record`|1|49|49||0|0|1363003|1363003|1363003|1363003|
|employee|SELECT * FROM `batch_step_execution_context`|1|20|20||0|0|334225|334225|334225|334225|
|corpwx|SELECT * FROM `app`|1|1|1||0|0|1505|1505|1505|1505|
|corpwx_license|SELECT * FROM `app_blocked`|1|1|1||0|0|20915|20915|20915|20915|
|tenant|SELECT * FROM `sjfx_dct_erp_sales_extend?`|1|1|1||0|0|47922|47922|47922|47922|
|employee|SELECT * FROM `backlog_bak`|1|21|21||0|0|66096|66096|66096|66096|
|user_service|SELECT * FROM `tenant_user`|1|547|547||0|0|3794328|3794328|3794328|3794328|
|user_service|SELECT * FROM `wx_member_card_redirect`|1|58|58||0|0|855584|855584|855584|855584|
|v4_coupon|SELECT * FROM `tag_push_coupon_log`|1|15|15||0|0|412290|412290|412290|412290|
|item_manage|SELECT * FROM `item_operator`|1|2|2||0|0|65582|65582|65582|65582|
|comment_service|SELECT * FROM `reply`|1|2|2||0|0|38040|38040|38040|38040|
|platform|SELECT * FROM `tbhy_hyda_sync`|1|1|1||0|0|15838|15838|15838|15838|
|comment_service|SELECT * FROM `comment_reward`|1|27|27||0|0|483867|483867|483867|483867|
|tenant|SELECT * FROM `erp_employee`|1|6|6||0|0|88260|88260|88260|88260|
||SELECT * FROM corpwx.app|1|1|1||0|0|1505|1505|1505|1505|
|customer|SELECT * FROM `customer_demand`|1|5|5||0|0|26324|26324|26324|26324|
|v4_user|SELECT DATE_FORMAT(t?.create_time,?) AS statistic_date,DATE_FORMAT(t?.create_time,?) AS statistic_month,DATE_FORMAT(t?.update_time,?) AS busi_date,t?.tenant_id,t?.tenant_app_id,eg.shop_id,eg.employee_id,? AS `status`,?*count(es.id) AS `order`,?*ifnull(sum(es.amount),?) AS deal_amount FROM v4_coupon.coupon t? JOIN v4_coupon.coupon_write_off t? ON t?.id=t?.coupon_id AND t?.type=? JOIN v4_coupon.coupon_grant cg ON t?.grant_id=cg.id JOIN v4_coupon.employee_grant_record eg ON cg.business_id=eg.id JOIN v4_sales.erp_sales_detail esd ON esd.tenant_id=? AND convert(t?.id,char)=esd.product_barcode AND esd.sales_type=? JOIN v4_sales.erp_sales es ON es.tenant_id=? AND es.tenant_app_id=? AND es.sales_erp_id=esd.sales_erp_id AND t?.business_id=es.sales_erp_id AND es.sales_status IN(?) WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<? AND t?.`status`=? GROUP BY t?.tenant_id,t?.tenant_app_id,eg.shop_id,eg.employee_id,DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.update_time,?) LIMIT ? OFFSET ?|1|1|1||0|0|1325|1325|0|0|
|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,?) AS employee_id,? AS saleStatus,?*count(t?.id) AS `comment`,?*ifnull(sum(if(t?.average_score<t?.low_score,?,?)),?) AS low_comment,?*ifnull(sum(t?.average_score),?) AS score_total 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=? LEFT JOIN tenant.employee emp ON es.tenant_id=emp.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 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,DATE_FORMAT(es.sales_date,?),DATE_FORMAT(es.sales_date,?),DATE_FORMAT(es.update_time,?) LIMIT ? OFFSET ?|1|1|1||0|0|63892|63892|0|0|
|employee|SELECT * FROM `backlog_system`|1|132|132||0|0|1436954|1436954|1436954|1436954|
|tenant|SELECT * FROM `erp_sales_extend`|1|4|4||0|0|89830|89830|89830|89830|
|coupon_service|SELECT * FROM `coupon_market_order`|1|24|24||0|0|622699|622699|622699|622699|
|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|
|payment|SELECT * FROM `pay_order`|1|59|59||0|0|347452|347452|347452|347452|
|sms|SELECT * FROM `sms_send_back`|1|2|2||0|0|16036|16036|16036|16036|
|tenant|SELECT * FROM `erp_sales`|1|2365|2365||0|0|33268139|33268139|33268139|33268139|
|account|SELECT * FROM `store_card`|1|1|1||0|0|9264|9264|9264|9264|
|tenant|SELECT * FROM `erp_sales_extend?`|1|1247|1247||0|0|28118069|28118069|28118069|28118069|
|check_stock|SELECT * FROM `realtime_gold_price_sync_log`|1|2|2||0|0|138267|138267|138267|138267|
|tenant|SELECT * FROM `day_price`|1|2|2||0|0|33252|33252|33252|33252|
|platform|SELECT * FROM `valueaddedlog`|1|2|2||0|0|31774|31774|31774|31774|
|activity_service|SELECT * FROM `intelligent_marketing_activity_msg`|1|187|187||0|0|1059554|1059554|1059554|1059554|
|tenant|SELECT * FROM `tenant_product_role_permission_back`|1|1|1||0|0|26655|26655|26655|26655|
|v4_coupon|SELECT * FROM `employee_grant_coupon_qrcode`|1|1|1||0|0|10902|10902|10902|10902|
|corpwx_license|SELECT * FROM `active_employee`|1|2|2||0|0|26689|26689|26689|26689|
|employee|SELECT * FROM `batch_step_execution`|1|24|24||0|0|334225|334225|334225|334225|
|sms|SELECT * FROM `sms_report`|1|743|743||0|0|10735039|10735039|10735039|10735039|
|new_shop_work|SELECT * FROM `attached`|1|1|1||0|0|15968|15968|15968|15968|
|v4_coupon|SELECT * FROM `employee_grant_record`|1|1|1||0|0|18461|18461|18461|18461|
|tenant|SELECT * FROM `sneak_guest`|1|56|56||0|0|878889|878889|878889|878889|
|coupon_service|SELECT * FROM `user_coupon_give_record`|1|1|1||0|0|51945|51945|51945|51945|
|customize_page|SELECT * FROM `gift_receive_detail`|1|5|5||0|0|171834|171834|171834|171834|
|user_service|SELECT * FROM `user_relation`|1|2|2||0|0|32839|32839|32839|32839|
|coupon_service|SELECT * FROM `coupon_push`|1|1|1||0|0|33146|33146|33146|33146|
|v4_user|SELECT t.shop_id,t.shop_name,count(DISTINCT t.id) AS couponNum,ifnull(sum(es.amount_pay),?) AS saleAmount FROM v4_coupon.coupon_write_off t LEFT JOIN v4_sales.erp_sales_detail es ON es.tenant_id=? AND es.tenant_app_id=? AND t.business_id=es.sales_erp_id WHERE t.tenant_id=? AND t.tenant_app_id=? AND t.shop_id>? AND t.create_time>=? AND t.create_time<? GROUP BY t.shop_id,t.shop_name|1|1|1||0|0|166|166|2|2|
|tenant|SELECT * FROM `employee_shop`|1|2|2||0|0|93191|93191|93191|93191|
|corpwx|SELECT * FROM `cwx_user`|1|4|4||0|0|52399|52399|52399|52399|
||SELECT count(*) FROM v4_employee.task_task|1|48|48||0|0|3635138|3635138|1|1|
|tenant|SELECT * FROM `sjfx_dct_erp_sales`|1|1|1||0|0|56868|56868|56868|56868|
|oa_gateway|SELECT * FROM `login_user`|1|2|2||0|0|18653|18653|18653|18653|
|order|SELECT * FROM `order_service_log`|1|1|1||0|0|26224|26224|26224|26224|
|tenant|SELECT * FROM `tenant_product_role_permission`|1|1|1||0|0|40634|40634|40634|40634|
|customize_page|SELECT * FROM `award_receive_detail`|1|3|3||0|0|84220|84220|84220|84220|
|tenant|SELECT * FROM `permission_log`|1|25|25||0|0|610336|610336|610336|610336|
|corpwx_license|SELECT * FROM `msg_send`|1|1|1||0|0|16845|16845|16845|16845|
|mini_app|SELECT * FROM `app_qrcode`|1|19|19||0|0|333343|333343|333343|333343|
|tenant|SELECT * FROM `employee_tenant_user`|1|1|1||0|0|35726|35726|35726|35726|
|user_service|SELECT * FROM `tenant_member_channel`|1|4|4||0|0|95619|95619|95619|95619|
|employee|SELECT * FROM `label_task_employee`|1|64|64||0|0|1033721|1033721|1033721|1033721|
|export|SELECT bg.id,bg.employee_id,bg.shop_id,CASE bg.scene WHEN ? THEN ? ELSE ? END scene,CASE bg.status WHEN ? THEN ? ELSE ? END status,bg.create_time,bg.begin_time,bg.expire_time,bg.member_user_name,bg.mobile_no member_mobile_no,ws.shop_name,ey.employee_name userName,ey.mobile_no FROM employee.backlog_? bg LEFT JOIN tenant.tenant_wechatapp_shop ws ON bg.shop_id=ws.id LEFT JOIN tenant.employee ey ON bg.employee_id=ey.id WHERE bg.tenant_app_id=? AND bg.scene NOT IN(?) AND bg.expire_time BETWEEN ? AND ? AND bg.shop_id=? AND bg.leave_flag=? ORDER BY bg.id DESC|1|1|1||0|0|13460|13460|203|203|
|v4_activity|SELECT * FROM `lottery_log`|1|1|1||0|0|22143|22143|22143|22143|
|user_service|SELECT * FROM `erp_member_info`|1|547|547||0|0|8457699|8457699|8457699|8457699|
|sms|SELECT * FROM `sms_send`|1|902|902||0|0|9341440|9341440|9341440|9341440|
|v4_user|SELECT sp.id FROM v4_sales.erp_sales es JOIN v4_employee.shop sp ON sp.tenant_id=? AND es.dept_erp_id=sp.dept_id WHERE es.tenant_id=? AND es.tenant_app_id=? AND es.member_erp_id IN (?) AND es.is_sales=? AND es.sales_status=? ORDER BY es.sales_erp_id ASC LIMIT ?|1|3|3||0|0|3080|3080|1|1|
|user_service|SELECT * FROM `user_employee_alloc_log`|1|1384|1384||0|0|23302707|23302707|23302707|23302707|
|v4_user|SELECT DATE_FORMAT(t?.create_time,?) AS statistic_date,DATE_FORMAT(t?.create_time,?) AS statistic_month,DATE_FORMAT(t?.update_time,?) AS busi_date,t?.tenant_id,t?.tenant_app_id,t?.scene AS channleName,t?.template_id AS templateId,ct.coupon_name,ifnull(sp.id,?) AS shopId,? AS `status`,?*count(es.id) AS `order`,?*ifnull(sum(es.amount),?) AS dealAmount FROM v4_coupon.coupon t? JOIN v4_coupon.coupon_template ct ON t?.template_id=ct.id JOIN v4_coupon.coupon_write_off t? ON t?.id=t?.coupon_id AND t?.type=? JOIN v4_sales.erp_sales_detail esd ON esd.tenant_id=? AND convert(t?.id,char)=esd.product_barcode AND esd.sales_type=? JOIN v4_sales.erp_sales es ON es.tenant_id=? AND es.tenant_app_id=? AND es.sales_erp_id=esd.sales_erp_id AND t?.business_id=es.sales_erp_id AND es.sales_status IN(?) LEFT JOIN v4_employee.shop sp ON sp.tenant_id=? AND t?.dept_erp_id=sp.dept_id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.update_time>=? AND t?.update_time<? AND t?.`status`=? GROUP BY DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.update_time,?),t?.tenant_id,t?.tenant_app_id,t?.scene,t?.template_id,sp.id,ct.coupon_name LIMIT ? OFFSET ?|1|1|1||0|0|1255|1255|0|0|
|oss|SELECT * FROM `oss_res`|1|9|9||0|0|127425|127425|127425|127425|
|tenant|SELECT * FROM `sneak_guest_maintain`|1|653|653||0|0|3860430|3860430|3860430|3860430|
|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|3317|3317|10|10|
|account|SELECT t?.id,t?.tenant_id,t?.tenant_app_id,tb.erp_member_id AS memberId,t?.card_no,(CASE t?.`oper_type` WHEN ? THEN ? ELSE ? END) AS oper_type,t?.oper_amount,t?.real_oper_amount-t?.oper_amount AS give_amount,t?.oper_time FROM account.store_card_detail t? JOIN account.store_card t? ON t?.store_card_id=t?.id 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?.oper_result=? AND t?.create_time>=? AND t?.create_time<=? LIMIT ? OFFSET ?|1|1|1||0|0|5635|5635|0|0|
|activity_service|SELECT * FROM `intelligent_push_gift_qualitied`|1|30|30||0|0|510203|510203|510203|510203|
|tenant|SELECT * FROM `employee_qrcode`|1|5|5||0|0|66787|66787|66787|66787|
|tenant|SELECT * FROM `sjfx_dct_erp_sales_detail_extend`|1|2|2||0|0|83242|83242|83242|83242|
|v4_employee|SELECT * FROM `task_task_attach`|1|45|45||0|0|1293407|1293407|1293407|1293407|
|order|SELECT * FROM `order_discount`|1|1|1||0|0|31498|31498|31498|31498|
|customer|SELECT * FROM `customer_entry_oper_log`|1|2|2||0|0|84274|84274|84274|84274|
|activity_service|SELECT * FROM `lottery_user`|1|26|26||0|0|683949|683949|683949|683949|
|v4_employee|SELECT * FROM `task_task`|1|402|402||0|0|3634553|3634553|3634553|3634553|
|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|
|coupon_service|SELECT * FROM `template_grant_limit`|1|1|1||0|0|31667|31667|31667|31667|
|user_service|SELECT * FROM `tenant_member_bind`|1|782|782||0|0|18701809|18701809|18701809|18701809|
|account|SELECT * FROM `store_card_log`|1|1|1||0|0|10355|10355|10355|10355|
|coupon_service|SELECT * FROM `coupon`|1|839|839||0|0|11958463|11958463|11958463|11958463|
|timer|SELECT * FROM `task_execute_log`|1|176|176||0|0|4543058|4543058|4543058|4543058|
|coupon_service|SELECT * FROM `employee_give_coupon_qrcode`|1|9|9||0|0|230476|230476|230476|230476|
|corpwx|SELECT * FROM `external_user_bind_log`|1|4|4||0|0|118782|118782|118782|118782|
|coupon_service|SELECT * FROM `coupon_can_give`|1|8|8||0|0|334202|334202|334202|334202|
|tenant|SELECT * FROM `erp_sales_detail_extend`|1|2101|2101||0|0|48340917|48340917|48340917|48340917|
|tenant|SELECT * FROM `tenant_wechatapp_para`|1|1|1||0|0|11419|11419|11419|11419|
|activity_service|SELECT * FROM `poster_share_browse`|1|1|1||0|0|17474|17474|17474|17474|
|user_service|SELECT * FROM `mini_app_user`|1|4|4||0|0|78575|78575|78575|78575|
|v4_user|SELECT count(*) FROM v4_coupon.coupon t? JOIN v4_coupon.coupon_extend t? ON t?.id=t?.id 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|2941|2941|1|1|
|v4_coupon|SELECT * FROM `coupon_write_off`|1|9|9||0|0|272792|272792|272792|272792|
|v4_coupon|SELECT * FROM `coupon_grant`|1|51|51||0|0|1969878|1969878|1969878|1969878|
|employee|SELECT * FROM `batch_job_execution_context`|1|2|2||0|0|125594|125594|125594|125594|
