Inicio Explorar Ayuda
Registro Iniciar sesión
zhaobo
/
doris-sync
1
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Rama: master
Ramas Etiquetas
doris-sync
/
sql
/
grossprofit
/
无标题.txt

无标题.txt 4.7 KB
Permalink Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 
  1. "trx_id"	"trx_state"	"trx_started"	"trx_requested_lock_id"	"trx_wait_started"	"trx_weight"	"trx_mysql_thread_id"	"trx_query"	"trx_operation_state"	"trx_tables_in_use"	"trx_tables_locked"	"trx_lock_structs"	"trx_lock_memory_bytes"	"trx_rows_locked"	"trx_rows_modified"	"trx_concurrency_tickets"	"trx_isolation_level"	"trx_unique_checks"	"trx_foreign_key_checks"	"trx_last_foreign_key_error"	"trx_adaptive_hash_latched"	"trx_adaptive_hash_timeout"	"trx_is_read_only"	"trx_autocommit_non_locking"
    2. 

  2. "2273680473"	"RUNNING"	"12/4/2026 16:50:10"			"0"	"16075346"	"SELECT
    3. 

  3.             x.id, x.created, x.modified, x.patient_name, x.patient_identity,
    4. 

  4.             x.patient_mobile, x.patientId, x.org_name, x.order_no, x.fee_class,
    5. 

  5.             x.class_name, x.combo_name, x.per_id, x.name, x.unit,
    6. 

  6.             x.price, x.num, x.sum_price, x.should_amt, x.discount,
    7. 

  7.             x.discount_memo, x.coupon_name, x.flag, x.type_flag, x.order_status,
    8. 

  8.             x.pay_time, x.exec_time, x.exec_status, x.cost_price, x.mcost_price,
    9. 

  9.             x.jcost_price, x.cost_flag, x.cost_flag2, x.cost_update_time, x.cost_update_time2,
    10. 

  10.             x.profit_amt, x.profit_rate, x.mprofit_amt, x.mprofit_rate,
    11. 

  11.             x.jprofit_amt, x.jprofit_rate, x.blq_amt, x.swap_card_amt, x.eye_card_amt,
    12. 

  12.             x.hx_amt, x.hx_cost_price, x.hx_sum_price, x.hx_num,
    13. 

  13.             x.pay_amt, x.pay_cost_price, x.pay_sum_price, x.pay_num,
    14. 

  14.             x.pay_profit_amt, x.pay_profit_rate, x.by_user_name, x.doctor_name,
    15. 

  15.             x.acp_doctor_name, x.acp_opt_name, x.acp_assistant_name,
    16. 

  16.             x.clinic_id, x.o"		"4"	"0"	"0"	"1136"	"0"	"0"	"0"	"READ COMMITTED"	"1"	"1"		"0"	"0"	"0"	"0"
    17. 

  17. "421146616091952"	"RUNNING"	"12/4/2026 18:06:30"			"0"	"16317500"	"select  p.name, p.sex, timestampdiff(YEAR, p.birthday, current_date()) as age, p.source as source, p.mobile, p.birthday,
    18. 

  18. 

  19.                             p.inviter_phone as inviter_phone, p.patientId as patientId, p.tag, p.id, p.avatar,p.customer_manager_staff_id,
    20. 

  20.                             p.last_apt_opt_name, sc.last_clinlc_name, p.customer_optometrist_staff_id
    21. 

  21.                             from patient_custome p
    22. 

  22.                             join patient_selectcustome as sc on sc.custome_id=p.id
    23. 

  23.                             where p.visual = 1  and (p.`name` like '%%赵岚漪%%' or p.mobile like '%%赵岚漪%%')  and p.group_id='1'
    24. 

  24.                             limit 0, 20"	"fetching rows"	"2"	"0"	"0"	"1136"	"0"	"0"	"0"	"READ COMMITTED"	"1"	"1"		"0"	"0"	"1"	"1"
    25. 

  25. "421146616221952"	"RUNNING"	"12/4/2026 16:33:51"			"0"	"16011358"	"SELECT
    26. 

  26.             x.id, x.created, x.modified, x.patient_name, x.patient_identity,
    27. 

  27.             x.patient_mobile, x.patientId, x.org_name, x.order_no, x.fee_class,
    28. 

  28.             x.class_name, x.combo_name, x.per_id, x.name, x.unit,
    29. 

  29.             x.price, x.num, x.sum_price, x.should_amt, x.discount,
    30. 

  30.             x.discount_memo, x.coupon_name, x.flag, x.type_flag, x.order_status,
    31. 

  31.             x.pay_time, x.exec_time, x.exec_status, x.cost_price, x.mcost_price,
    32. 

  32.             x.jcost_price, x.cost_flag, x.cost_flag2, x.cost_update_time, x.cost_update_time2,
    33. 

  33.             x.profit_amt, x.profit_rate, x.mprofit_amt, x.mprofit_rate,
    34. 

  34.             x.jprofit_amt, x.jprofit_rate, x.blq_amt, x.swap_card_amt, x.eye_card_amt,
    35. 

  35.             x.hx_amt, x.hx_cost_price, x.hx_sum_price, x.hx_num,
    36. 

  36.             x.pay_amt, x.pay_cost_price, x.pay_sum_price, x.pay_num,
    37. 

  37.             x.pay_profit_amt, x.pay_profit_rate, x.by_user_name, x.doctor_name,
    38. 

  38.             x.acp_doctor_name, x.acp_opt_name, x.acp_assistant_name,
    39. 

  39.             x.clinic_id, x.o"		"4"	"0"	"0"	"1136"	"0"	"0"	"0"	"READ COMMITTED"	"1"	"1"		"0"	"0"	"0"	"0"
    40. 

  40. "421146616164952"	"RUNNING"	"12/4/2026 16:31:50"			"0"	"16002428"	"SELECT
    41. 

  41.             x.id, x.created, x.modified, x.patient_name, x.patient_identity,
    42. 

  42.             x.patient_mobile, x.patientId, x.org_name, x.order_no, x.fee_class,
    43. 

  43.             x.class_name, x.combo_name, x.per_id, x.name, x.unit,
    44. 

  44.             x.price, x.num, x.sum_price, x.should_amt, x.discount,
    45. 

  45.             x.discount_memo, x.coupon_name, x.flag, x.type_flag, x.order_status,
    46. 

  46.             x.pay_time, x.exec_time, x.exec_status, x.cost_price, x.mcost_price,
    47. 

  47.             x.jcost_price, x.cost_flag, x.cost_flag2, x.cost_update_time, x.cost_update_time2,
    48. 

  48.             x.profit_amt, x.profit_rate, x.mprofit_amt, x.mprofit_rate,
    49. 

  49.             x.jprofit_amt, x.jprofit_rate, x.blq_amt, x.swap_card_amt, x.eye_card_amt,
    50. 

  50.             x.hx_amt, x.hx_cost_price, x.hx_sum_price, x.hx_num,
    51. 

  51.             x.pay_amt, x.pay_cost_price, x.pay_sum_price, x.pay_num,
    52. 

  52.             x.pay_profit_amt, x.pay_profit_rate, x.by_user_name, x.doctor_name,
    53. 

  53.             x.acp_doctor_name, x.acp_opt_name, x.acp_assistant_name,
    54. 

  54.             x.clinic_id, x.o"		"4"	"0"	"0"	"1136"	"0"	"0"	"0"	"READ COMMITTED"	"1"	"1"		"0"	"0"	"0"	"0"
    55.