|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|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(?,?,?) AND od.take_shop_id=? ORDER BY od.create_time DESC|2|20|19||0|0|47364|24429|60|34|
|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|111|80||0|0|69403|56040|998|500|
|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|17|13||0|0|130795|106292|88|52|
|account|SELECT tu.id,tu.tenant_id tenantId,tu.tenant_app_id tenantAppId,tu.user_id userId,tu.user_name userName,tu.mobile_no mobileNo,tu.create_time createTime,? updateTime,tu.sex,if(tu.mobile_no IS ?,?,?)registerFlag,tu.status FROM user_service.tenant_member tu WHERE tu.tenant_id=? AND tu.tenant_app_id=? AND tu.update_time>=? AND tu.update_time<=? ORDER BY tu.id LIMIT ? OFFSET ?|2|3|2||0|0|67941|48974|7744|5000|
|platform|SELECT * FROM `valueaddedlog`|1|2|2||0|0|31774|31774|31774|31774|
|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|2|2||0|0|70790|70790|0|0|
|mini_app|SELECT * FROM `app_qrcode`|1|2|2||0|0|338847|338847|338847|338847|
|position|SELECT * FROM `geo_position`|1|326|326||0|0|10060164|10060164|10060164|10060164|
|tenant|SELECT * FROM `employee_tenant_user`|1|1|1||0|0|35895|35895|35895|35895|
|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|140|140|30|30|
|mini_app|SELECT * FROM `mini_qrcode_params`|1|3|3||0|0|983780|983780|983780|983780|
|v4_user|SELECT * FROM `member_butler`|1|119|119||0|0|4144128|4144128|4144128|4144128|
|v4_user|SELECT * FROM `member_change_log`|1|332|332||0|0|11458910|11458910|11458910|11458910|
|shop_work|SELECT * FROM `task_item`|1|56|56||0|0|1091587|1091587|1091587|1091587|
|sms|SELECT * FROM `sms_report`|1|882|882||0|0|10761261|10761261|10761261|10761261|
|shop_work|SELECT * FROM `work_report`|1|3|3||0|0|19290|19290|19290|19290|
|oss|SELECT * FROM `oss_res`|1|9|9||0|0|127425|127425|127425|127425|
|activity_service|SELECT * FROM `intelligent_push_gift_qualitied`|1|1|1||0|0|510203|510203|510203|510203|
|order|SELECT * FROM `order_detail`|1|4|4||0|0|266165|266165|266165|266165|
|message_push|SELECT * FROM `message_log_back`|1|38|38||0|0|1024218|1024218|1024218|1024218|
|v4_user|SELECT * FROM `employee_external_bind_log`|1|309|309||0|0|12075091|12075091|12075091|12075091|
|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|1|1|1||0|0|19744|19744|3|3|
|employee|SELECT * FROM `backlog_bak`|1|4|4||0|0|66096|66096|66096|66096|
|payment|SELECT * FROM `pay_order_msg`|1|334|334||0|0|691647|691647|691647|691647|
|tenant|SELECT * FROM `day_price`|1|1|1||0|0|34194|34194|34194|34194|
|v4_user|SELECT DATE_FORMAT(t?.create_time,?) AS statistic_date,DATE_FORMAT(t?.create_time,?) AS statistic_month,DATE_FORMAT(t?.create_time,?) AS busi_date,t?.tenant_id,t?.tenant_app_id,t?.scene AS channleName,t?.template_id AS templateId,ct.coupon_name,count(t?.id) AS got FROM v4_coupon.coupon t? JOIN v4_coupon.coupon_template ct ON t?.template_id=ct.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,t?.scene,t?.template_id,ct.coupon_name,DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.create_time,?) LIMIT ? OFFSET ?|1|4|4||0|0|37892|37892|2|2|
|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|943|943|225|225|
|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|17|17|1|1|
|order|SELECT * FROM `order_address`|1|1|1||0|0|266165|266165|266165|266165|
|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|3421|3421|16|16|
|shop_work|SELECT * FROM `report_data_source`|1|8|8||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|4|4||0|0|266165|266165|266165|266165|
|payment|SELECT * FROM `refund_order`|1|2|2||0|0|14288|14288|14288|14288|
|tenant|SELECT * FROM `employee`|1|10|10||0|0|95334|95334|95334|95334|
|v4_user|SELECT * FROM `member_butler_back`|1|13|13||0|0|372098|372098|372098|372098|
|sms|SELECT * FROM `sms_send_extend`|1|75|75||0|0|3751446|3751446|3751446|3751446|
|order|SELECT * FROM `order_operator_log`|1|53|53||0|0|1101506|1101506|1101506|1101506|
|activity_service|SELECT * FROM `intelligent_marketing_activity_gift`|1|3|3||0|0|498054|498054|498054|498054|
|order|SELECT * FROM `order_service_log`|1|1|1||0|0|26410|26410|26410|26410|
|payment|SELECT * FROM `refund_order_msg`|1|15|15||0|0|14288|14288|14288|14288|
|account|SELECT min(create_time)create_time FROM goods.goods WHERE tenant_id=? AND tenant_app_id=?|1|1|1||0|0|15973|15973|1|1|
|tenant|SELECT * FROM `employee_shop`|1|3|3||0|0|93570|93570|93570|93570|
|employee|SELECT * FROM `backlog_detail`|1|13|13||0|0|1429463|1429463|1429463|1429463|
|v4_user|SELECT DATE_FORMAT(t?.create_time,?) AS busi_date,t?.tenant_id,t?.tenant_app_id,eg.shop_id,eg.employee_id,count(DISTINCT t?.id) AS got FROM v4_coupon.coupon t? 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?.create_time>=? AND t?.create_time<? GROUP BY t?.tenant_id,t?.tenant_app_id,eg.shop_id,eg.employee_id,DATE_FORMAT(t?.create_time,?) LIMIT ? OFFSET ?|1|2|2||0|0|37888|37888|0|0|
|tenant|SELECT * FROM `erp_sales_back_?`|1|14|14||0|0|438960|438960|438960|438960|
|v4_user|SELECT * FROM `member_import`|1|13|13||0|0|2172012|2172012|2172012|2172012|
|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|44348|44348|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|9|9||0|0|41112|41112|41112|41112|
|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|6|6||0|0|24499|24499|34|34|
|activity_service|SELECT * FROM `assist_task_user`|1|2|2||0|0|400022|400022|400022|400022|
|shop_work|SELECT * FROM `task_old`|1|1|1||0|0|3211|3211|3211|3211|
|v4_user|SELECT * FROM `member`|1|218|218||0|0|4145967|4145967|4145967|4145967|
|tenant|SELECT * FROM `erp_employee`|1|6|6||0|0|88521|88521|88521|88521|
|shop_work|SELECT * FROM `task`|1|82|82||0|0|464505|464505|464505|464505|
|activity_service|SELECT * FROM `intelligent_marketing_activity_msg`|1|16|16||0|0|1059554|1059554|1059554|1059554|
|platform|SELECT * FROM `tbhy_hyda_sync`|1|1|1||0|0|15838|15838|15838|15838|
|platform|SELECT * FROM `custommadeorder`|1|3|3||0|0|11805|11805|11805|11805|
|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|2012|2012|114|114|
|qrcode_service|SELECT * FROM `qrcode`|1|7|7||0|0|77976|77976|77976|77976|
|qrcode_login|SELECT * FROM `qrcode_log`|1|1|1||0|0|8368|8368|8368|8368|
|payment|SELECT * FROM `pay_order`|1|58|58||0|0|349186|349186|349186|349186|
|platform|SELECT * FROM `callbacklog`|1|2|2||0|0|34421|34421|34421|34421|
|platform|SELECT * FROM `bargainapplication`|1|1|1||0|0|59587|59587|59587|59587|
|account|SELECT pd.id product_id,? tenant_id,? tenant_wechatapp_id,pd.product_name,? product_type,pd.tag_price price,it.volume,it.id inventory_id,pd.create_time,? partner_id,? partner_name,pd.update_time FROM gift_mail.platform_product pd LEFT JOIN gift_mail.platform_inventory it ON pd.id=it.product_id LIMIT ? OFFSET ?|1|2|2||0|0|4366|4366|2183|2183|
|v4_user|SELECT * FROM `employee_external_bind`|1|43|43||0|0|7118912|7118912|7118912|7118912|
|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|0|0|0|0|
|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|70766|70766|0|0|
|v4_user|SELECT * FROM `member_grade`|1|21|21||0|0|4142490|4142490|4142490|4142490|
|v4_user|SELECT * FROM `member_butler_update_error`|1|69|69||0|0|1591768|1591768|1591768|1591768|
|tenant|SELECT * FROM `employee_qrcode`|1|4|4||0|0|66873|66873|66873|66873|
|platform|SELECT * FROM `productdesc`|1|1|1||0|0|2228|2228|2228|2228|
