|数据库名称|SQL语句|总执行次数|总执行时间(秒)|最大执行时长|平均执行时间|锁定总时长|最大锁定时长|解析总行数|解析最大行数|返回总行数|返回最大行数|
| - | - | - | - | - | - | - | - | - | - | - | - |
|order|SELECT * FROM `order_detail`|1|52|52||0|0|265467|265467|265467|265467|
|message_push|SELECT * FROM `message_log_back`|1|79|79||0|0|322058|322058|322058|322058|
|v4_user|SELECT * FROM `employee_external_bind_log`|1|443|443||0|0|11958330|11958330|11958330|11958330|
|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|3261|3261|740|740|
|account|SELECT es.tenant_id,es.tenant_wechatapp_id AS tenant_app_id,es.member_erp_id,ifnull(GROUP_CONCAT(DISTINCT if(es.sales_status=?,if(sde.sales_brand=? OR sde.sales_brand=?,?,sde.sales_brand),?)),?) AS sales_brand,ifnull(GROUP_CONCAT(DISTINCT if(es.sales_status=?,if(sde.sales_craft=? OR sde.sales_craft=?,?,sde.sales_craft),?)),?) AS sales_craft FROM tenant.erp_sales es LEFT JOIN tenant.erp_sales_detail_extend sde ON sde.tenant_id=es.tenant_id AND sde.tenant_wechatapp_id=es.tenant_wechatapp_id AND sde.sales_erp_id=es.sales_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|1|38|38||0|0|12527|12527|500|500|
|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|398|398|0|0|
|tenant|SELECT * FROM `day_price`|1|1|1||0|0|33704|33704|33704|33704|
|v4_sales|SELECT * FROM `warranty_can_added`|1|10|10||0|0|3541241|3541241|3541241|3541241|
|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|3128|3128|262|262|
|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|3351|3351|10|10|
|shop_work|SELECT * FROM `report_data_source`|1|6|6||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|45|45||0|0|265467|265467|265467|265467|
|account|SELECT es.tenant_id,es.tenant_wechatapp_id tenant_app_id,es.member_erp_id,sum(esd.amount_pay) AS salesBalance,count(DISTINCT if(es.sales_status=?,concat(es.dept_erp_id,?,es.sales_date),?)) AS salesAmount,group_concat(DISTINCT if(es.sales_status=?,DATE_FORMAT(es.sales_date,?),?)) AS saleDates,group_concat(DISTINCT if(es.sales_status=?,if(esd.quantity>?,round(esd.amount_pay/esd.quantity,?),?),?)) AS singleConsumeMoneys 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 WHERE es.tenant_id=? AND es.tenant_wechatapp_id=? AND es.is_sales=? AND es.sales_status>=? AND es.member_erp_id IN|1|47|47||0|0|16722|16722|500|500|
|account|SELECT * FROM `account`|1|138|138||0|0|31737418|31737418|31737418|31737418|
|tenant|SELECT * FROM `employee`|1|10|10||0|0|95139|95139|95139|95139|
|v4_user|SELECT * FROM `member_butler_back`|1|3|3||0|0|372098|372098|372098|372098|
|sms|SELECT * FROM `sms_send`|1|958|958||0|0|9365125|9365125|9365125|9365125|
|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|212|212|1|1|
|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|68589|68589|0|0|
|account|SELECT min(create_time)create_time FROM goods.goods WHERE tenant_id=? AND tenant_app_id=?|1|1|1||0|0|15917|15917|1|1|
|v4_sales|SELECT * FROM `warranty_detail`|1|17|17||0|0|4526279|4526279|4526279|4526279|
|tenant|SELECT * FROM `employee_shop`|1|4|4||0|0|93407|93407|93407|93407|
|account|SELECT tm.id,tm.tenant_id,tm.tenant_app_id,eub.external_user_id AS external_user_id,? updateTime FROM corpwx.external_user_bind eub INNER JOIN user_service.tenant_member_bind tm ON tm.tenant_id=eub.tenant_id AND tm.tenant_app_id=eub.tenant_app_id AND tm.wx_user_id=eub.wx_user_id WHERE eub.tenant_id=? AND eub.tenant_app_id=? AND eub.create_time>=? AND eub.create_time<=? ORDER BY tm.id LIMIT ? OFFSET ?|1|1|1||0|0|516|516|0|0|
|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|279|279|0|0|
|v4_user|SELECT * FROM `member`|1|83|83||0|0|4078208|4078208|4078208|4078208|
|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|1|1||0|0|25000|25000|5000|5000|
|account|SELECT * FROM `wx_redpacket_send_msg`|1|45|45||0|0|818796|818796|818796|818796|
|tenant|SELECT * FROM `erp_employee`|1|7|7||0|0|88392|88392|88392|88392|
|shop_work|SELECT * FROM `task`|1|80|80||0|0|464505|464505|464505|464505|
|message_push|SELECT * FROM `message_log`|1|93|93||0|0|3315038|3315038|3315038|3315038|
|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<=? ORDER BY od.create_time DESC|1|2|2||0|0|185613|185613|61871|61871|
|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|1|1||0|0|20942|20942|1|1|
|v4_sales|SELECT * FROM `warranty`|1|19|19||0|0|2616238|2616238|2616238|2616238|
|platform|SELECT * FROM `custommadeorder`|1|4|4||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|
|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?.product_id,t?.product_name,t?.category_id AS classifyId,t?.category_name AS classifyName,ifnull(tt.take_shop_id,?) AS usedShopid,sum(t?.quantity) AS used,count(t?.member_id) AS used_member,sum(t?.pay_points) AS used_point,sum(t?.pay_price) AS deal_amount FROM v4_giftmall.trade t? JOIN v4_giftmall.product t? ON t?.tenant_id=t?.tenant_id AND t?.product_id=t?.id JOIN v4_giftmall.category t? ON t?.category_id=t?.id LEFT JOIN v4_giftmall.trade_take tt ON t?.id=trade_id WHERE t?.tenant_id=? AND t?.tenant_app_id=? AND t?.trade_type=? AND t?.order_status=? AND t?.update_time>=? AND t?.update_time<? GROUP BY t?.tenant_id,t?.tenant_app_id,t?.product_id,t?.product_name,t?.category_id,t?.category_name,ifnull(tt.take_shop_id,?),DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.create_time,?),DATE_FORMAT(t?.update_time,?) LIMIT ? OFFSET ?|1|5|5||0|0|13912|13912|20|20|
|qrcode_service|SELECT * FROM `qrcode`|1|7|7||0|0|77392|77392|77392|77392|
|qrcode_login|SELECT * FROM `qrcode_log`|1|1|1||0|0|7913|7913|7913|7913|
|payment|SELECT * FROM `pay_order`|1|60|60||0|0|348463|348463|348463|348463|
|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|3|3||0|0|9480|9480|3160|3160|
|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|
|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|1|32|32||0|0|23381|23381|500|500|
|v4_user|SELECT * FROM `employee_external_bind`|1|152|152||0|0|7054061|7054061|7054061|7054061|
|sms|SELECT * FROM `sms_send_back`|1|1|1||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|67840|67840|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|990|990|180|180|
|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 ?|1|9|9||0|0|23289|23289|39|39|
|account|SELECT t.id,t.tenant_id,t.tenant_wechatapp_id,t.sales_erp_id,t.sales_index,t.sales_type,t.product_barcode,t.product_name,t.cert_no,t.hand_size,t.category_erp_id,t.category_name,t.stone_weight,t.gold_weight,t.total_weight,t.quantity,t.amount_total,t.amount_pay,ifnull(amount_pay/quantity,?) AS amount_avg,t.integral,ct.id AS pk_id,ct.change_type AS SYS_CHANGE_OPERATION FROM tenant.erp_sales_detail AS t RIGHT OUTER JOIN tenant.sjfx_dct_erp_sales_detail ct ON t.id=ct.id WHERE ct.version>? AND (t.tenant_id=?)|1|1|1||0|0|69|69|0|0|
|v4_user|SELECT * FROM `member_butler_update_error`|1|30|30||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|32235|32235|32235|32235|
|tenant|SELECT * FROM `employee_qrcode`|1|6|6||0|0|66935|66935|66935|66935|
