|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|account|SELECT es.tenant_id,es.tenant_wechatapp_id tenant_app_id,es.member_erp_id,ifnull(group_concat(DISTINCT if(es.sales_status=?,sd.category_erp_id,?)),?)categoryId,ifnull(group_concat(DISTINCT if(es.sales_status=?,ifnull(pc.category_name,sd.category_name),?)),?) AS categoryName,min(if(es.sales_status=?,es.sales_date,?)) AS firstSalesTime,max(if(es.sales_status=?,es.sales_date,?)) AS lastSalesTime 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 AND sd.sales_type=? 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.is_sales=? AND es.sales_status>=? AND es.member_erp_id IN|2|171|113||0|0|145308|83170|977|496|
|user_service|SELECT * FROM `user_employee_?`|2|7|4||0|0|1234777|835482|1234777|835482|
|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 ?|2|16|13||0|0|130618|106270|131|95|
|v4_sales|SELECT * FROM `erp_sales`|1|55|55||0|0|6040927|6040927|6040927|6040927|
|oa_gateway|SELECT * FROM `login_user`|1|1|1||0|0|18808|18808|18808|18808|
|v4_sales|SELECT * FROM `erp_sales_extend?`|1|99|99||0|0|5916158|5916158|5916158|5916158|
|score_player|SELECT * FROM `supervise_record`|1|1|1||0|0|18399|18399|18399|18399|
|v4_sales|SELECT * FROM `warranty_detail_img`|1|26|26||0|0|1389330|1389330|1389330|1389330|
|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|1|1||0|0|70588|70588|0|0|
|mini_app|SELECT * FROM `app_qrcode`|1|27|27||0|0|338648|338648|338648|338648|
|user_service|SELECT * FROM `user_employee`|1|85|85||0|0|13987604|13987604|13987604|13987604|
|v4_sales|SELECT * FROM `value_added_record`|1|37|37||0|0|2528523|2528523|2528523|2528523|
|tenant|SELECT * FROM `employee_tenant_user`|1|1|1||0|0|35884|35884|35884|35884|
|v4_user|SELECT * FROM `cwx_external_user`|1|43|43||0|0|5427921|5427921|5427921|5427921|
|qrcode_service|SELECT * FROM `qrcode_scan_log`|1|176|176||0|0|3865821|3865821|3865821|3865821|
|mini_app|SELECT * FROM `mini_qrcode_params`|1|29|29||0|0|983250|983250|983250|983250|
|v4_user|SELECT * FROM `member_butler`|1|20|20||0|0|4140836|4140836|4140836|4140836|
|sms|SELECT * FROM `sms_report`|1|940|940||0|0|10760374|10760374|10760374|10760374|
|shop_work|SELECT * FROM `work_report`|1|3|3||0|0|19290|19290|19290|19290|
|oss|SELECT * FROM `oss_res`|1|7|7||0|0|127425|127425|127425|127425|
|order|SELECT * FROM `order_detail`|1|47|47||0|0|266115|266115|266115|266115|
|message_push|SELECT * FROM `message_log_back`|1|398|398||0|0|961085|961085|961085|961085|
|account|SELECT es.id,es.tenant_id,es.tenant_wechatapp_id AS tenant_app_id,sp.id AS shop_id,emp.id AS employee_id,mb.user_id,es.sales_erp_id,es.sales_date,es.erp_create_time AS deal_time FROM tenant.erp_sales es JOIN tenant.tenant_wechatapp_shop sp ON sp.tenant_id=es.tenant_id AND es.tenant_wechatapp_id=sp.tenant_wechatapp_id AND es.dept_erp_id=sp.dept_erp_id JOIN tenant.employee emp ON es.tenant_id=emp.tenant_id AND es.employee_erp_id=emp.employee_erp_id JOIN user_service.tenant_member_bind mb ON es.tenant_id=mb.tenant_id AND es.tenant_wechatapp_id=mb.tenant_app_id AND es.member_erp_id=mb.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<=? LIMIT ? OFFSET ?|1|1|1||0|0|163|163|4|4|
|activity_service|SELECT * FROM `vote_log`|1|8|8||0|0|2605213|2605213|2605213|2605213|
|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|48958|48958|0|0|
|employee|SELECT * FROM `backlog_bak`|1|2|2||0|0|66096|66096|66096|66096|
|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|34134|34134|34134|34134|
|v4_sales|SELECT * FROM `warranty_can_added`|1|29|29||0|0|3561344|3561344|3561344|3561344|
|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|3268|3268|449|449|
|authorization_service|SELECT * FROM `ip_table_local`|1|1|1||0|0|462824|462824|462824|462824|
|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|742|742|171|171|
|order|SELECT * FROM `order_address`|1|9|9||0|0|266115|266115|266115|266115|
|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|3390|3390|10|10|
|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|1|1|1||0|0|40524|40524|2|2|
|shop_work|SELECT * FROM `report_data_source`|1|7|7||0|0|57893|57893|57893|57893|
|order|SELECT * FROM `order_info`|1|58|58||0|0|266115|266115|266115|266115|
|oa_gateway|SELECT * FROM `product_script_execute_record`|1|1|1||0|0|14694|14694|14694|14694|
|account|SELECT t.id,t.tenant_id,t.tenant_wechatapp_id,t.sales_erp_id,t.sales_index,t.sales_brand,t.sales_craft,t.extend_col?,t.extend_col?,t.extend_col?,t.extend_col?,t.extend_col?,ct.id AS pk_id,ct.change_type AS SYS_CHANGE_OPERATION FROM tenant.erp_sales_detail_extend AS t RIGHT OUTER JOIN tenant.sjfx_dct_erp_sales_detail_extend ct ON t.id=ct.id WHERE ct.version>? AND (t.tenant_id=?)|1|1|1||0|0|21|21|0|0|
|tenant|SELECT * FROM `employee`|1|9|9||0|0|95302|95302|95302|95302|
|v4_user|SELECT * FROM `member_butler_back`|1|1|1||0|0|372098|372098|372098|372098|
|sms|SELECT * FROM `sms_send_extend`|1|92|92||0|0|3750586|3750586|3750586|3750586|
|sms|SELECT * FROM `sms_send`|1|1118|1118||0|0|9381296|9381296|9381296|9381296|
|order|SELECT * FROM `order_operator_log`|1|47|47||0|0|1101129|1101129|1101129|1101129|
|activity_service|SELECT * FROM `intelligent_marketing_activity_gift`|1|2|2||0|0|498054|498054|498054|498054|
|order|SELECT * FROM `order_service_log`|1|1|1||0|0|26400|26400|26400|26400|
|account|SELECT min(create_time)create_time FROM coupon_service.template WHERE tenant_id=? AND tenant_app_id=?|1|1|1||0|0|22123|22123|1|1|
|activity_service|SELECT * FROM `assist_task_receive_prize`|1|1|1||0|0|10487|10487|10487|10487|
|account|SELECT min(create_time)create_time FROM goods.goods WHERE tenant_id=? AND tenant_app_id=?|1|1|1||0|0|15965|15965|1|1|
|v4_sales|SELECT * FROM `warranty_detail`|1|41|41||0|0|4567957|4567957|4567957|4567957|
|tenant|SELECT * FROM `employee_shop`|1|3|3||0|0|93552|93552|93552|93552|
|employee|SELECT * FROM `backlog_detail`|1|7|7||0|0|1429463|1429463|1429463|1429463|
|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|3|3||0|0|70588|70588|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|44326|44326|37|37|
|activity_service|SELECT * FROM `activity_gift_grant`|1|1|1||0|0|181225|181225|181225|181225|
|payment|SELECT * FROM `close_order_msg`|1|7|7||0|0|41100|41100|41100|41100|
|activity_service|SELECT * FROM `assist_task_user`|1|3|3||0|0|400022|400022|400022|400022|
|shop_work|SELECT * FROM `task_old`|1|1|1||0|0|3211|3211|3211|3211|
|account|SELECT tm.id,tm.tenant_id,tm.tenant_app_id,tu.user_id AS external_user_id,? updateTime FROM corpwx.external_user tu INNER JOIN user_service.tenant_member_bind tm ON tu.tenant_id=tm.tenant_id AND tm.tenant_app_id=? AND tu.union_id=tm.wx_union_id WHERE tu.tenant_id=? AND tu.un_assign_flag=? AND tu.union_id IS NOT ? AND tu.create_time>=? AND tu.create_time<=? ORDER BY id LIMIT ? OFFSET ?|1|1|1||0|0|5|5|0|0|
|v4_user|SELECT t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id,? AS statisticDate,? AS bizType,count(*) AS amount FROM v4_employee.task_task t? WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.task_type=? AND t?.finish_time>=? AND t?.finish_time<? GROUP BY t?.tenant_id,t?.tenant_app_id,t?.shop_id,t?.employee_id LIMIT ? OFFSET ?|1|1|1||0|0|5499|5499|0|0|
|account|SELECT * FROM `wx_redpacket_send_msg`|1|31|31||0|0|818881|818881|818881|818881|
|tenant|SELECT * FROM `erp_employee`|1|6|6||0|0|88513|88513|88513|88513|
|message_push|SELECT * FROM `message_log`|1|575|575||0|0|3188470|3188470|3188470|3188470|
|v4_sales|SELECT * FROM `warranty`|1|33|33||0|0|2633590|2633590|2633590|2633590|
|account|SELECT esd.id,es.tenant_id,es.tenant_wechatapp_id AS tenantAppId,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 ? OFFSET ?|1|1|1||0|0|0|0|0|0|
|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|1618|1618|128|128|
|v4_sales|SELECT * FROM `erp_sales_detail`|1|533|533||0|0|13276469|13276469|13276469|13276469|
|payment|SELECT * FROM `pay_order`|1|48|48||0|0|349157|349157|349157|349157|
|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|1395|1395|465|465|
|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_user|SELECT * FROM `employee_external_bind`|1|48|48||0|0|7111457|7111457|7111457|7111457|
|sms|SELECT * FROM `sms_send_back`|1|2|2||0|0|16036|16036|16036|16036|
|v4_user|SELECT DATE_FORMAT(es.sales_date,?) AS statistic_date,DATE_FORMAT(es.sales_date,?) AS statistic_month,DATE_FORMAT(t?.create_time,?) AS busi_date,t?.tenant_id,t?.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 IN(?) 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 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,sp.id,emp.id,DATE_FORMAT(es.sales_date,?),DATE_FORMAT(es.sales_date,?),DATE_FORMAT(t?.create_time,?) LIMIT ? OFFSET ?|1|1|1||0|0|70509|70509|0|0|
|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|655|655|122|122|
|export|SELECT t.id,t.product_name,CASE WHEN t.take_type=? THEN ? ELSE ? END take_type,t.user_name,t.mobile_no,t.create_time,t.update_time,t.quantity,t.pay_price,CASE WHEN t.order_status=? THEN ? ELSE ? END order_status,t.remark,date_format(tt.can_take_date,?)can_take_date,tt.shop_name,tt.take_shop_name,tt.take_employee_name,ta.recipients,ta.user_tel,CONCAT(ta.area,ta.address)address,if(t.trade_type=?,pl.id,it.barcode) AS barcode,t.cash_price,ws.shop_name userAscriptionShop,if(t.order_status=?,?,t.write_off_time) AS write_off_time FROM gift_mail.trade t LEFT JOIN gift_mail.trade_take tt ON t.tenant_wechatapp_id=tt.tenant_wechatapp_id AND t.id=tt.trade_id LEFT JOIN gift_mail.trade_addr ta ON t.tenant_wechatapp_id=ta.tenant_wechatapp_id AND t.id=ta.trade_id LEFT JOIN gift_mail.product p ON p.id=t.product_id LEFT JOIN gift_mail.platform_product pl ON pl.id=t.product_id LEFT JOIN gift_mail.inventory it ON it.product_id=t.product_id AND it.specification=t.specification LEFT JOIN user_service.tenant_member_info tm ON t.tenant_id=tm.tenant_id AND t.tenant_wechatapp_id=tm.tenant_app_id AND t.user_id=tm.user_id LEFT JOIN tenant.tenant_wechatapp_shop ws ON tm.shop_id=ws.id WHERE t.tenant_wechatapp_id=? AND t.trade_type=? ORDER BY t.id DESC|1|3|3||0|0|14193|14193|1577|1577|
|account|SELECT * FROM `wx_redpacket_send_order`|1|16|16||0|0|886396|886396|886396|886396|
|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,tu.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 LEFT JOIN user_service.tenant_user tu ON tu.tenant_id=es.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.create_time>=? AND es.create_time<=? AND es.sales_status=? AND es.is_sales=? AND sd.sales_type=? ORDER BY es.id LIMIT ? OFFSET ?|1|1|1||0|0|2630|2630|570|570|
|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|
|order|SELECT * FROM `order_discount`|1|1|1||0|0|32494|32494|32494|32494|
|tenant|SELECT * FROM `employee_qrcode`|1|3|3||0|0|66851|66851|66851|66851|
