API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 21st, 2017
136
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 104.12 KB | None | 0 0
raw download clone embed print report
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8. 2017-08-21 17:18:50 YAKT [2195]: [5164-1] db=postgres,appname=[unknown],user=dbwa,client=127.0.0.1 LOG: duration: 12.416 ms statement: SELECT stat_name AS stat_name,
  9. stat_value AS stat_value
  10. FROM eyes.get_activity();
  11. 2017-08-21 17:18:51 YAKT [27335]: [221-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.493 ms parse S_4: select individual0_.id as id193_, individual0_1_.note as note193_, individual0_1_.type_id as type4_193_, individual0_1_.version as version193_, individual0_.birth_dt as birth1_233_, individual0_.death_dt as death2_233_, individual0_.gender_id as gender16_233_, individual0_.has_citizenship as has3_233_, individual0_.list_identity_doc as list4_233_, individual0_.list_job_org as list5_233_, individual0_.list_main_contact as list6_233_, individual0_.list_oms_doc as list7_233_, individual0_.list_reg_name as list8_233_, individual0_.list_snils as list9_233_, individual0_.list_uid as list10_233_, individual0_.aud_when as aud11_233_, individual0_.name as name233_, individual0_.nationality_id as nationa17_233_, individual0_.patr_name as patr13_233_, individual0_.surname as surname233_, upper(individual0_.SURNAME)||upper(individual0_.NAME)||upper(individual0_.PATR_NAME) as formula22_ from pim_individual individual0_ inner join pim_party individual0_1_ on individual0_.id=individual0_1_.id inner join pim_indiv_code codes1_ on individual0_.id=codes1_.indiv_id where individual0_.birth_dt=$1 and codes1_.type_id=(select documentty2_.code_type_id from pim_doc_type documentty2_, pim_code_type codetype3_ where documentty2_.code_type_id=codetype3_.id and (documentty2_.code in ($2 , $3 , $4))) and codes1_.code=$5 and upper(individual0_.surname)=upper($6) and upper(individual0_.name)=upper($7) and upper(individual0_.patr_name)=upper($8)
  12. 2017-08-21 17:18:51 YAKT [27335]: [222-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 1.644 ms bind S_4: select individual0_.id as id193_, individual0_1_.note as note193_, individual0_1_.type_id as type4_193_, individual0_1_.version as version193_, individual0_.birth_dt as birth1_233_, individual0_.death_dt as death2_233_, individual0_.gender_id as gender16_233_, individual0_.has_citizenship as has3_233_, individual0_.list_identity_doc as list4_233_, individual0_.list_job_org as list5_233_, individual0_.list_main_contact as list6_233_, individual0_.list_oms_doc as list7_233_, individual0_.list_reg_name as list8_233_, individual0_.list_snils as list9_233_, individual0_.list_uid as list10_233_, individual0_.aud_when as aud11_233_, individual0_.name as name233_, individual0_.nationality_id as nationa17_233_, individual0_.patr_name as patr13_233_, individual0_.surname as surname233_, upper(individual0_.SURNAME)||upper(individual0_.NAME)||upper(individual0_.PATR_NAME) as formula22_ from pim_individual individual0_ inner join pim_party individual0_1_ on individual0_.id=individual0_1_.id inner join pim_indiv_code codes1_ on individual0_.id=codes1_.indiv_id where individual0_.birth_dt=$1 and codes1_.type_id=(select documentty2_.code_type_id from pim_doc_type documentty2_, pim_code_type codetype3_ where documentty2_.code_type_id=codetype3_.id and (documentty2_.code in ($2 , $3 , $4))) and codes1_.code=$5 and upper(individual0_.surname)=upper($6) and upper(individual0_.name)=upper($7) and upper(individual0_.patr_name)=upper($8)
  13. 2017-08-21 17:18:51 YAKT [27335]: [223-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '1986-01-09', $2 = 'MHI_UNIFORM', $3 = 'MHI_OLDER', $4 = 'MHI_TEMP', $5 = '1658310840000067', $6 = 'Насибуллин', $7 = 'Ильнар', $8 = 'Рафаэлевич'
  14. 2017-08-21 17:18:51 YAKT [27335]: [224-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.157 ms execute S_4: select individual0_.id as id193_, individual0_1_.note as note193_, individual0_1_.type_id as type4_193_, individual0_1_.version as version193_, individual0_.birth_dt as birth1_233_, individual0_.death_dt as death2_233_, individual0_.gender_id as gender16_233_, individual0_.has_citizenship as has3_233_, individual0_.list_identity_doc as list4_233_, individual0_.list_job_org as list5_233_, individual0_.list_main_contact as list6_233_, individual0_.list_oms_doc as list7_233_, individual0_.list_reg_name as list8_233_, individual0_.list_snils as list9_233_, individual0_.list_uid as list10_233_, individual0_.aud_when as aud11_233_, individual0_.name as name233_, individual0_.nationality_id as nationa17_233_, individual0_.patr_name as patr13_233_, individual0_.surname as surname233_, upper(individual0_.SURNAME)||upper(individual0_.NAME)||upper(individual0_.PATR_NAME) as formula22_ from pim_individual individual0_ inner join pim_party individual0_1_ on individual0_.id=individual0_1_.id inner join pim_indiv_code codes1_ on individual0_.id=codes1_.indiv_id where individual0_.birth_dt=$1 and codes1_.type_id=(select documentty2_.code_type_id from pim_doc_type documentty2_, pim_code_type codetype3_ where documentty2_.code_type_id=codetype3_.id and (documentty2_.code in ($2 , $3 , $4))) and codes1_.code=$5 and upper(individual0_.surname)=upper($6) and upper(individual0_.name)=upper($7) and upper(individual0_.patr_name)=upper($8)
  15. 2017-08-21 17:18:51 YAKT [27335]: [225-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '1986-01-09', $2 = 'MHI_UNIFORM', $3 = 'MHI_OLDER', $4 = 'MHI_TEMP', $5 = '1658310840000067', $6 = 'Насибуллин', $7 = 'Ильнар', $8 = 'Рафаэлевич'
  16. 2017-08-21 17:18:51 YAKT [27335]: [226-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.061 ms parse <unnamed>: select partytype0_.id as id237_0_, partytype0_.name as name237_0_, partytype0_.note as note237_0_ from pim_party_type partytype0_ where partytype0_.id=$1
  17. 2017-08-21 17:18:51 YAKT [27335]: [227-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.065 ms bind <unnamed>: select partytype0_.id as id237_0_, partytype0_.name as name237_0_, partytype0_.note as note237_0_ from pim_party_type partytype0_ where partytype0_.id=$1
  18. 2017-08-21 17:18:51 YAKT [27335]: [228-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  19. 2017-08-21 17:18:51 YAKT [27335]: [229-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.012 ms execute <unnamed>: select partytype0_.id as id237_0_, partytype0_.name as name237_0_, partytype0_.note as note237_0_ from pim_party_type partytype0_ where partytype0_.id=$1
  20. 2017-08-21 17:18:51 YAKT [27335]: [230-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  21. 2017-08-21 17:18:51 YAKT [27335]: [231-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.088 ms parse <unnamed>: select gender0_.id as id217_0_, gender0_.code as code217_0_, gender0_.name as name217_0_, gender0_.scope_id as scope4_217_0_, (select case pg.code when 'UNKNOWN' then 'Общий' else pg.name end from pim_gender pg where pg.id= gender0_.id) as formula21_0_ from pim_gender gender0_ where gender0_.id=$1
  22. 2017-08-21 17:18:51 YAKT [27335]: [232-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.108 ms bind <unnamed>: select gender0_.id as id217_0_, gender0_.code as code217_0_, gender0_.name as name217_0_, gender0_.scope_id as scope4_217_0_, (select case pg.code when 'UNKNOWN' then 'Общий' else pg.name end from pim_gender pg where pg.id= gender0_.id) as formula21_0_ from pim_gender gender0_ where gender0_.id=$1
  23. 2017-08-21 17:18:51 YAKT [27335]: [233-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  24. 2017-08-21 17:18:51 YAKT [27335]: [234-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.020 ms execute <unnamed>: select gender0_.id as id217_0_, gender0_.code as code217_0_, gender0_.name as name217_0_, gender0_.scope_id as scope4_217_0_, (select case pg.code when 'UNKNOWN' then 'Общий' else pg.name end from pim_gender pg where pg.id= gender0_.id) as formula21_0_ from pim_gender gender0_ where gender0_.id=$1
  25. 2017-08-21 17:18:51 YAKT [27335]: [235-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  26. 2017-08-21 17:18:51 YAKT [27335]: [236-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.279 ms parse S_5: select individual0_.id as id193_, individual0_1_.note as note193_, individual0_1_.type_id as type4_193_, individual0_1_.version as version193_, individual0_.birth_dt as birth1_233_, individual0_.death_dt as death2_233_, individual0_.gender_id as gender16_233_, individual0_.has_citizenship as has3_233_, individual0_.list_identity_doc as list4_233_, individual0_.list_job_org as list5_233_, individual0_.list_main_contact as list6_233_, individual0_.list_oms_doc as list7_233_, individual0_.list_reg_name as list8_233_, individual0_.list_snils as list9_233_, individual0_.list_uid as list10_233_, individual0_.aud_when as aud11_233_, individual0_.name as name233_, individual0_.nationality_id as nationa17_233_, individual0_.patr_name as patr13_233_, individual0_.surname as surname233_, upper(individual0_.SURNAME)||upper(individual0_.NAME)||upper(individual0_.PATR_NAME) as formula22_ from pim_individual individual0_ inner join pim_party individual0_1_ on individual0_.id=individual0_1_.id inner join pim_individual_doc documents1_ on individual0_.id=documents1_.indiv_id cross join pim_doc_type documentty2_ where documents1_.type_id=documentty2_.id and individual0_.birth_dt=$1 and (documentty2_.code in ($2 , $3 , $4)) and documents1_.number=$5 and ($6=false or upper(documents1_.series)=$7) and upper(individual0_.surname)=upper($8) and upper(individual0_.name)=upper($9) and upper(individual0_.patr_name)=upper($10)
  27. 2017-08-21 17:18:51 YAKT [27335]: [237-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 1.399 ms bind S_5: select individual0_.id as id193_, individual0_1_.note as note193_, individual0_1_.type_id as type4_193_, individual0_1_.version as version193_, individual0_.birth_dt as birth1_233_, individual0_.death_dt as death2_233_, individual0_.gender_id as gender16_233_, individual0_.has_citizenship as has3_233_, individual0_.list_identity_doc as list4_233_, individual0_.list_job_org as list5_233_, individual0_.list_main_contact as list6_233_, individual0_.list_oms_doc as list7_233_, individual0_.list_reg_name as list8_233_, individual0_.list_snils as list9_233_, individual0_.list_uid as list10_233_, individual0_.aud_when as aud11_233_, individual0_.name as name233_, individual0_.nationality_id as nationa17_233_, individual0_.patr_name as patr13_233_, individual0_.surname as surname233_, upper(individual0_.SURNAME)||upper(individual0_.NAME)||upper(individual0_.PATR_NAME) as formula22_ from pim_individual individual0_ inner join pim_party individual0_1_ on individual0_.id=individual0_1_.id inner join pim_individual_doc documents1_ on individual0_.id=documents1_.indiv_id cross join pim_doc_type documentty2_ where documents1_.type_id=documentty2_.id and individual0_.birth_dt=$1 and (documentty2_.code in ($2 , $3 , $4)) and documents1_.number=$5 and ($6=false or upper(documents1_.series)=$7) and upper(individual0_.surname)=upper($8) and upper(individual0_.name)=upper($9) and upper(individual0_.patr_name)=upper($10)
  28. 2017-08-21 17:18:51 YAKT [27335]: [238-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '1986-01-09', $2 = 'MHI_UNIFORM', $3 = 'MHI_OLDER', $4 = 'MHI_TEMP', $5 = '1658310840000067', $6 = 't', $7 = '?', $8 = 'Насибуллин', $9 = 'Ильнар', $10 = 'Рафаэлевич'
  29. 2017-08-21 17:18:51 YAKT [27335]: [239-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.049 ms execute S_5: select individual0_.id as id193_, individual0_1_.note as note193_, individual0_1_.type_id as type4_193_, individual0_1_.version as version193_, individual0_.birth_dt as birth1_233_, individual0_.death_dt as death2_233_, individual0_.gender_id as gender16_233_, individual0_.has_citizenship as has3_233_, individual0_.list_identity_doc as list4_233_, individual0_.list_job_org as list5_233_, individual0_.list_main_contact as list6_233_, individual0_.list_oms_doc as list7_233_, individual0_.list_reg_name as list8_233_, individual0_.list_snils as list9_233_, individual0_.list_uid as list10_233_, individual0_.aud_when as aud11_233_, individual0_.name as name233_, individual0_.nationality_id as nationa17_233_, individual0_.patr_name as patr13_233_, individual0_.surname as surname233_, upper(individual0_.SURNAME)||upper(individual0_.NAME)||upper(individual0_.PATR_NAME) as formula22_ from pim_individual individual0_ inner join pim_party individual0_1_ on individual0_.id=individual0_1_.id inner join pim_individual_doc documents1_ on individual0_.id=documents1_.indiv_id cross join pim_doc_type documentty2_ where documents1_.type_id=documentty2_.id and individual0_.birth_dt=$1 and (documentty2_.code in ($2 , $3 , $4)) and documents1_.number=$5 and ($6=false or upper(documents1_.series)=$7) and upper(individual0_.surname)=upper($8) and upper(individual0_.name)=upper($9) and upper(individual0_.patr_name)=upper($10)
  30. 2017-08-21 17:18:51 YAKT [27335]: [240-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '1986-01-09', $2 = 'MHI_UNIFORM', $3 = 'MHI_OLDER', $4 = 'MHI_TEMP', $5 = '1658310840000067', $6 = 't', $7 = '?', $8 = 'Насибуллин', $9 = 'Ильнар', $10 = 'Рафаэлевич'
  31. 2017-08-21 17:18:51 YAKT [27335]: [241-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.016 ms parse <unnamed>: BEGIN
  32. 2017-08-21 17:18:51 YAKT [27335]: [242-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.007 ms bind <unnamed>: BEGIN
  33. 2017-08-21 17:18:51 YAKT [27335]: [243-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.006 ms execute <unnamed>: BEGIN
  34. 2017-08-21 17:18:51 YAKT [27335]: [244-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.038 ms parse <unnamed>: SELECT set_config('app.user', '', true)
  35. 2017-08-21 17:18:51 YAKT [27335]: [245-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.032 ms bind <unnamed>: SELECT set_config('app.user', '', true)
  36. 2017-08-21 17:18:51 YAKT [27335]: [246-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.024 ms execute <unnamed>: SELECT set_config('app.user', '', true)
  37. 2017-08-21 17:18:51 YAKT [27335]: [247-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.035 ms parse <unnamed>: SELECT set_config('app.source', 'concentrator-ws', true)
  38. 2017-08-21 17:18:51 YAKT [27335]: [248-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.028 ms bind <unnamed>: SELECT set_config('app.source', 'concentrator-ws', true)
  39. 2017-08-21 17:18:51 YAKT [27335]: [249-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.013 ms execute <unnamed>: SELECT set_config('app.source', 'concentrator-ws', true)
  40. 2017-08-21 17:18:51 YAKT [27335]: [250-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.089 ms bind S_3: select patientses0_.id as id729_, patientses0_.history_json as history2_729_, patientses0_.last_req_dt as last3_729_, patientses0_.patient_id as patient4_729_, patientses0_.session_uid as session5_729_ from concentrator.patient_session patientses0_ where patientses0_.session_uid=$1
  41. 2017-08-21 17:18:51 YAKT [27335]: [251-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '123'
  42. 2017-08-21 17:18:51 YAKT [27335]: [252-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.030 ms execute S_3: select patientses0_.id as id729_, patientses0_.history_json as history2_729_, patientses0_.last_req_dt as last3_729_, patientses0_.patient_id as patient4_729_, patientses0_.session_uid as session5_729_ from concentrator.patient_session patientses0_ where patientses0_.session_uid=$1
  43. 2017-08-21 17:18:51 YAKT [27335]: [253-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '123'
  44. 2017-08-21 17:18:51 YAKT [27335]: [254-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.155 ms parse <unnamed>: select user0_.id as id25_, user0_.blocked as blocked25_, user0_.close_dt as close3_25_, user0_.comment as comment25_, user0_.cr_dt as cr5_25_, user0_.email as email25_, user0_.login as login25_, user0_.password as password25_, user0_.scope_id as scope10_25_, user0_.use_global_context as use9_25_, user0_1_.party_id as party2_414_, case when user0_1_.id is not null then 1 when user0_.id is not null then 0 end as clazz_ from sec_user user0_ left outer join sec_user_party user0_1_ on user0_.id=user0_1_.id where upper(user0_.login)=upper($1) limit $2
  45. 2017-08-21 17:18:51 YAKT [27335]: [255-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.351 ms bind <unnamed>: select user0_.id as id25_, user0_.blocked as blocked25_, user0_.close_dt as close3_25_, user0_.comment as comment25_, user0_.cr_dt as cr5_25_, user0_.email as email25_, user0_.login as login25_, user0_.password as password25_, user0_.scope_id as scope10_25_, user0_.use_global_context as use9_25_, user0_1_.party_id as party2_414_, case when user0_1_.id is not null then 1 when user0_.id is not null then 0 end as clazz_ from sec_user user0_ left outer join sec_user_party user0_1_ on user0_.id=user0_1_.id where upper(user0_.login)=upper($1) limit $2
  46. 2017-08-21 17:18:51 YAKT [27335]: [256-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = 'system', $2 = '2'
  47. 2017-08-21 17:18:51 YAKT [27335]: [257-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.036 ms execute <unnamed>: select user0_.id as id25_, user0_.blocked as blocked25_, user0_.close_dt as close3_25_, user0_.comment as comment25_, user0_.cr_dt as cr5_25_, user0_.email as email25_, user0_.login as login25_, user0_.password as password25_, user0_.scope_id as scope10_25_, user0_.use_global_context as use9_25_, user0_1_.party_id as party2_414_, case when user0_1_.id is not null then 1 when user0_.id is not null then 0 end as clazz_ from sec_user user0_ left outer join sec_user_party user0_1_ on user0_.id=user0_1_.id where upper(user0_.login)=upper($1) limit $2
  48. 2017-08-21 17:18:51 YAKT [27335]: [258-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = 'system', $2 = '2'
  49. 2017-08-21 17:18:51 YAKT [27335]: [259-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.054 ms parse <unnamed>: update concentrator.patient_session set history_json=$1, last_req_dt=$2, patient_id=$3, session_uid=$4 where id=$5
  50. 2017-08-21 17:18:51 YAKT [27335]: [260-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.098 ms bind <unnamed>: update concentrator.patient_session set history_json=$1, last_req_dt=$2, patient_id=$3, session_uid=$4 where id=$5
  51. 2017-08-21 17:18:51 YAKT [27335]: [261-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = NULL, $2 = '2017-08-21 17:19:06.458', $3 = '7281717', $4 = '123', $5 = '23'
  52. 2017-08-21 17:18:51 YAKT [27335]: [262-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.225 ms execute <unnamed>: update concentrator.patient_session set history_json=$1, last_req_dt=$2, patient_id=$3, session_uid=$4 where id=$5
  53. 2017-08-21 17:18:51 YAKT [27335]: [263-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = NULL, $2 = '2017-08-21 17:19:06.458', $3 = '7281717', $4 = '123', $5 = '23'
  54. 2017-08-21 17:18:51 YAKT [27335]: [264-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.013 ms bind S_1: COMMIT
  55. 2017-08-21 17:18:51 YAKT [27335]: [265-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.625 ms execute S_1: COMMIT
  56.  
  57.  
  58.  
  59.  
  60.  
  61.  
  62.  
  63.  
  64.  
  65.  
  66.  
  67.  
  68.  
  69.  
  70.  
  71.  
  72.  
  73.  
  74.  
  75. 2017-08-21 17:19:23 YAKT [27335]: [266-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.059 ms parse <unnamed>: BEGIN
  76. 2017-08-21 17:19:23 YAKT [27335]: [267-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.011 ms bind <unnamed>: BEGIN
  77. 2017-08-21 17:19:23 YAKT [27335]: [268-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.009 ms execute <unnamed>: BEGIN
  78. 2017-08-21 17:19:23 YAKT [27335]: [269-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.088 ms parse <unnamed>: SELECT set_config('app.user', '', true)
  79. 2017-08-21 17:19:23 YAKT [27335]: [270-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.045 ms bind <unnamed>: SELECT set_config('app.user', '', true)
  80. 2017-08-21 17:19:23 YAKT [27335]: [271-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.021 ms execute <unnamed>: SELECT set_config('app.user', '', true)
  81. 2017-08-21 17:19:23 YAKT [27335]: [272-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.061 ms parse <unnamed>: SELECT set_config('app.source', 'concentrator-ws', true)
  82. 2017-08-21 17:19:23 YAKT [27335]: [273-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.022 ms bind <unnamed>: SELECT set_config('app.source', 'concentrator-ws', true)
  83. 2017-08-21 17:19:23 YAKT [27335]: [274-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.011 ms execute <unnamed>: SELECT set_config('app.source', 'concentrator-ws', true)
  84. 2017-08-21 17:19:23 YAKT [27335]: [275-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.147 ms bind S_3: select patientses0_.id as id729_, patientses0_.history_json as history2_729_, patientses0_.last_req_dt as last3_729_, patientses0_.patient_id as patient4_729_, patientses0_.session_uid as session5_729_ from concentrator.patient_session patientses0_ where patientses0_.session_uid=$1
  85. 2017-08-21 17:19:23 YAKT [27335]: [276-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '123'
  86. 2017-08-21 17:19:23 YAKT [27335]: [277-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.032 ms execute S_3: select patientses0_.id as id729_, patientses0_.history_json as history2_729_, patientses0_.last_req_dt as last3_729_, patientses0_.patient_id as patient4_729_, patientses0_.session_uid as session5_729_ from concentrator.patient_session patientses0_ where patientses0_.session_uid=$1
  87. 2017-08-21 17:19:23 YAKT [27335]: [278-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = '123'
  88. 2017-08-21 17:19:23 YAKT [27335]: [279-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.073 ms parse <unnamed>: update concentrator.patient_session set history_json=$1, last_req_dt=$2, patient_id=$3, session_uid=$4 where id=$5
  89. 2017-08-21 17:19:23 YAKT [27335]: [280-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.087 ms bind <unnamed>: update concentrator.patient_session set history_json=$1, last_req_dt=$2, patient_id=$3, session_uid=$4 where id=$5
  90. 2017-08-21 17:19:23 YAKT [27335]: [281-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = NULL, $2 = '2017-08-21 17:19:38.478', $3 = '7281717', $4 = '123', $5 = '23'
  91. 2017-08-21 17:19:23 YAKT [27335]: [282-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.245 ms execute <unnamed>: update concentrator.patient_session set history_json=$1, last_req_dt=$2, patient_id=$3, session_uid=$4 where id=$5
  92. 2017-08-21 17:19:23 YAKT [27335]: [283-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 DETAIL: parameters: $1 = NULL, $2 = '2017-08-21 17:19:38.478', $3 = '7281717', $4 = '123', $5 = '23'
  93. 2017-08-21 17:19:23 YAKT [27335]: [284-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.010 ms bind S_1: COMMIT
  94. 2017-08-21 17:19:23 YAKT [27335]: [285-1] db=lsd,appname=192.168.7.2,user=rep,client=127.0.0.1 LOG: duration: 0.470 ms execute S_1: COMMIT
  95. 2017-08-21 17:19:23 YAKT [1726]: [630-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.058 ms parse <unnamed>: select 'lsd_slave'
  96. 2017-08-21 17:19:23 YAKT [1726]: [631-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.022 ms bind <unnamed>: select 'lsd_slave'
  97. 2017-08-21 17:19:23 YAKT [1726]: [632-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.006 ms execute <unnamed>: select 'lsd_slave'
  98. 2017-08-21 17:19:23 YAKT [1726]: [633-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.013 ms bind S_10: BEGIN
  99. 2017-08-21 17:19:23 YAKT [1726]: [634-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.005 ms execute S_10: BEGIN
  100. 2017-08-21 17:19:23 YAKT [1726]: [635-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 11.665 ms bind S_11: select patient0_.id as id269_17_, patient0_.birthweight as birthwei2_269_17_, patient0_.rh_blood_group_id as rh9_269_17_, patient0_.created_dt as created3_269_17_, patient0_.death_src_inf_id as death10_269_17_, patient0_.education_type_id as education11_269_17_, patient0_.empl_state_death_id as empl12_269_17_, patient0_.employee_reg_death_position_id as employee13_269_17_, patient0_.ethnic_group_id as ethnic14_269_17_, patient0_.aud_when as aud4_269_17_, patient0_.newborn_number as newborn5_269_17_, patient0_.note as note269_17_, patient0_.social_group_id as social15_269_17_, patient0_.unidentified_dt as unidenti7_269_17_, patient0_.vip as vip269_17_, bloodgroup1_.id as id622_0_, bloodgroup1_.code as code622_0_, bloodgroup1_.note as note622_0_, deathsourc2_.id as id244_1_, deathsourc2_.code as code244_1_, deathsourc2_.name as name244_1_, educationt3_.id as id406_2_, educationt3_.code as code406_2_, educationt3_.level_id as level4_406_2_, educationt3_.name as name406_2_, educationl4_.id as id402_3_, educationl4_.code as code402_3_, educationl4_.name as name402_3_, employee5_.id as id399_4_, employee5_.callup_subject_id as callup8_399_4_, employee5_.dismissal_dt as dismissal2_399_4_, employee5_.is_dismissed as is3_399_4_, employee5_.employment_dt as employment4_399_4_, employee5_.individual_id as individual9_399_4_, employee5_.note as note399_4_, employee5_.number as number399_4_, employee5_.organization_id as organiz10_399_4_, employee5_.photo as photo399_4_, exists(select 1 from pim_empl_posit_to_prefer_recipe pR inner join pim_employee_position ep ON pR.employee_position_id=ep.id inner join pim_employee e ON ep.employee_id=e.id inner join md_clinic c ON e.organization_id=c.id where e.id = employee5_.id and (pR.begin_date is NULL or pR.begin_date <= CURRENT_DATE) and (pr.end_date is NULL or pr.end_date >= CURRENT_DATE) and c.is_in_ads limit 1) as formula33_4_, exists(select 1 from pim_employee_position_resource pepr inner join pim_employee_position pep on pepr.employee_position_id=pep.id inner join pim_employee pe on pep.employee_id=pe.id where pe.id =employee5_.id and ((pep.start_date < CURRENT_TIMESTAMP and CURRENT_TIMESTAMP < pep.end_date) or (pep.start_date < CURRENT_TIMESTAMP and pep.end_date is NULL) or (pep.start_date is NULL and CURRENT_TIMESTAMP < pep.end_date) or (pep.start_date is NULL and pep.end_date is NULL))) as formula34_4_, (select sup.id from sec_user_party sup inner join pim_employee pe on sup.party_id=pe.individual_id where pe.id=employee5_.id limit 1) as formula35_4_, individual6_.id as id193_5_, individual6_1_.note as note193_5_, individual6_1_.type_id as type4_193_5_, individual6_1_.version as version193_5_, individual6_.birth_dt as birth1_233_5_, individual6_.death_dt as death2_233_5_, individual6_.gender_id as gender16_233_5_, individual6_.has_citizenship as has3_233_5_, individual6_.list_identity_doc as list4_233_5_, individual6_.list_job_org as list5_233_5_, individual6_.list_main_contact as list6_233_5_, individual6_.list_oms_doc as list7_233_5_, individual6_.list_reg_name as list8_233_5_, individual6_.list_snils as list9_233_5_, individual6_.list_uid as list10_233_5_, individual6_.aud_when as aud11_233_5_, individual6_.name as name233_5_, individual6_.nationality_id as nationa17_233_5_, individual6_.patr_name as patr13_233_5_, individual6_.surname as surname233_5_, upper(individual6_.SURNAME)||upper(individual6_.NAME)||upper(individual6_.PATR_NAME) as formula22_5_, partytype7_.id as id237_6_, partytype7_.name as name237_6_, partytype7_.note as note237_6_, gender8_.id as id217_7_, gender8_.code as code217_7_, gender8_.name as name217_7_, gender8_.scope_id as scope4_217_7_, (select case pg.code when 'UNKNOWN' then 'Общий' else pg.name end from pim_gender pg where pg.id= gender8_.id) as formula21_7_, nationalit9_.id as id192_8_, nationalit9_.code as code192_8_, nationalit9_.name as name192_8_, nationalit9_.parent_id as parent4_192_8_, nationalit10_.id as id192_9_, nationalit10_.code as code192_9_, nationalit10_.name as name192_9_, nationalit10_.parent_id as parent4_192_9_, employeeto11_.id as id389_10_, employeeto11_.code as code389_10_, employeeto11_.dismissal_order_code as dismissal3_389_10_, employeeto11_.dismissal_reason_id as dismissal8_389_10_, employeeto11_.employee_id as employee9_389_10_, employeeto11_.employment_type_id as employment10_389_10_, employeeto11_.start_date as start4_389_10_, employeeto11_.hiring_order_code as hiring5_389_10_, employeeto11_.hiring_type_id as hiring11_389_10_, employeeto11_.position_id as position12_389_10_, employeeto11_.position_type_id as position13_389_10_, employeeto11_.rate as rate389_10_, employeeto11_.end_date as end7_389_10_, employeeto11_.unit_id as unit14_389_10_, exists(select 1 from md_clinic mc inner join pim_position pp ON mc.id=pp.organization_id inner join pim_employee_position pep ON pp.id=pep.position_id where pep.id=employeeto11_.id and mc.is_in_ads) as formula30_10_, (select pR.id from pim_empl_posit_to_prefer_recipe pR where pR.employee_position_id = employeeto11_.id and (pR.begin_date <= CURRENT_DATE or pr.begin_date is null) and (pr.end_date >= CURRENT_DATE or pr.end_date is null) limit 1) as formula31_10_, employee12_.id as id399_11_, employee12_.callup_subject_id as callup8_399_11_, employee12_.dismissal_dt as dismissal2_399_11_, employee12_.is_dismissed as is3_399_11_, employee12_.employment_dt as employment4_399_11_, employee12_.individual_id as individual9_399_11_, employee12_.note as note399_11_, employee12_.number as number399_11_, employee12_.organization_id as organiz10_399_11_, employee12_.photo as photo399_11_, exists(select 1 from pim_empl_posit_to_prefer_recipe pR inner join pim_employee_position ep ON pR.employee_position_id=ep.id inner join pim_employee e ON ep.employee_id=e.id inner join md_clinic c ON e.organization_id=c.id where e.id = employee12_.id and (pR.begin_date is NULL or pR.begin_date <= CURRENT_DATE) and (pr.end_date is NULL or pr.end_date >= CURRENT_DATE) and c.is_in_ads limit 1) as formula33_11_, exists(select 1 from pim_employee_position_resource pepr inner join pim_employee_position pep on pepr.employee_position_id=pep.id inner join pim_employee pe on pep.employee_id=pe.id where pe.id =employee12_.id and ((pep.start_date < CURRENT_TIMESTAMP and CURRENT_TIMESTAMP < pep.end_date) or (pep.start_date < CURRENT_TIMESTAMP and pep.end_date is NULL) or (pep.start_date is NULL and CURRENT_TIMESTAMP < pep.end_date) or (pep.start_date is NULL and pep.end_date is NULL))) as formula34_11_, (select sup.id from sec_user_party sup inner join pim_employee pe on sup.party_id=pe.individual_id where pe.id=employee12_.id limit 1) as formula35_11_, position13_.id as id395_12_, position13_.code as code395_12_, position13_.department_id as department7_395_12_, position13_.start_date as start3_395_12_, position13_.name as name395_12_, position13_.organization_id as organiza8_395_12_, position13_.role_id as role9_395_12_, position13_.rate as rate395_12_, position13_.speciality_id as speciality10_395_12_, position13_.end_date as end6_395_12_, (select sum(pep.rate) from pim_employee_position pep where pep.position_id = position13_.id and (pep.start_date is null or pep.start_date <= current_date) and (pep.end_date is null or pep.end_date >= current_date)) as formula32_12_, speciality14_.id as id392_13_, speciality14_.code as code392_13_, speciality14_.code_regional as code3_392_13_, speciality14_.education_type_id as education5_392_13_, speciality14_.name as name392_13_, speciality14_.parent_id as parent6_392_13_, speciality14_.sphere_id as sphere7_392_13_, ethnicgrou15_.id as id636_14_, ethnicgrou15_.code as code636_14_, ethnicgrou15_.name as name636_14_, socialgrou16_.id as id645_15_, socialgrou16_.code as code645_15_, socialgrou16_.from_age as from3_645_15_, socialgrou16_.from_dt as from4_645_15_, socialgrou16_.name as name645_15_, socialgrou16_.to_age as to6_645_15_, socialgrou16_.to_dt as to7_645_15_, individual17_.id as id193_16_, individual17_1_.note as note193_16_, individual17_1_.type_id as type4_193_16_, individual17_1_.version as version193_16_, individual17_.birth_dt as birth1_233_16_, individual17_.death_dt as death2_233_16_, individual17_.gender_id as gender16_233_16_, individual17_.has_citizenship as has3_233_16_, individual17_.list_identity_doc as list4_233_16_, individual17_.list_job_org as list5_233_16_, individual17_.list_main_contact as list6_233_16_, individual17_.list_oms_doc as list7_233_16_, individual17_.list_reg_name as list8_233_16_, individual17_.list_snils as list9_233_16_, individual17_.list_uid as list10_233_16_, individual17_.aud_when as aud11_233_16_, individual17_.name as name233_16_, individual17_.nationality_id as nationa17_233_16_, individual17_.patr_name as patr13_233_16_, individual17_.surname as surname233_16_, upper(individual17_.SURNAME)||upper(individual17_.NAME)||upper(individual17_.PATR_NAME) as formula22_16_ from pci_patient patient0_ left outer join md_rh_blood_group bloodgroup1_ on patient0_.rh_blood_group_id=bloodgroup1_.id left outer join pim_death_source_info deathsourc2_ on patient0_.death_src_inf_id=deathsourc2_.id left outer join pim_education_type educationt3_ on patient0_.education_type_id=educationt3_.id left outer join pim_education_level educationl4_ on educationt3_.level_id=educationl4_.id left outer join pim_employee employee5_ on patient0_.empl_state_death_id=employee5_.id left outer join pim_individual individual6_ on employee5_.individual_id=individual6_.id left outer join pim_party individual6_1_ on individual6_.id=individual6_1_.id left outer join pim_party_type partytype7_ on individual6_1_.type_id=partytype7_.id left outer join pim_gender gender8_ on individual6_.gender_id=gender8_.id left outer join pim_nationality nationalit9_ on individual6_.nationality_id=nationalit9_.id left outer join pim_nationality nationalit10_ on nationalit9_.parent_id=nationalit10_.id left outer join pim_employee_position employeeto11_ on patient0_.employee_reg_death_position_id=employeeto11_.id left outer join pim_employee employee12_ on employeeto11_.employee_id=employee12_.id left outer join pim_position position13_ on employeeto11_.position_id=position13_.id left outer join pim_speciality speciality14_ on position13_.speciality_id=speciality14_.id left outer join md_ethnic_group ethnicgrou15_ on patient0_.ethnic_group_id=ethnicgrou15_.id left outer join md_soc_group socialgrou16_ on patient0_.social_group_id=socialgrou16_.id left outer join pim_individual individual17_ on patient0_.id=individual17_.id left outer join pim_party individual17_1_ on individual17_.id=individual17_1_.id where patient0_.id=$1
  101. 2017-08-21 17:19:23 YAKT [1726]: [636-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '7281717'
  102. 2017-08-21 17:19:23 YAKT [1726]: [637-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.347 ms execute S_11: select patient0_.id as id269_17_, patient0_.birthweight as birthwei2_269_17_, patient0_.rh_blood_group_id as rh9_269_17_, patient0_.created_dt as created3_269_17_, patient0_.death_src_inf_id as death10_269_17_, patient0_.education_type_id as education11_269_17_, patient0_.empl_state_death_id as empl12_269_17_, patient0_.employee_reg_death_position_id as employee13_269_17_, patient0_.ethnic_group_id as ethnic14_269_17_, patient0_.aud_when as aud4_269_17_, patient0_.newborn_number as newborn5_269_17_, patient0_.note as note269_17_, patient0_.social_group_id as social15_269_17_, patient0_.unidentified_dt as unidenti7_269_17_, patient0_.vip as vip269_17_, bloodgroup1_.id as id622_0_, bloodgroup1_.code as code622_0_, bloodgroup1_.note as note622_0_, deathsourc2_.id as id244_1_, deathsourc2_.code as code244_1_, deathsourc2_.name as name244_1_, educationt3_.id as id406_2_, educationt3_.code as code406_2_, educationt3_.level_id as level4_406_2_, educationt3_.name as name406_2_, educationl4_.id as id402_3_, educationl4_.code as code402_3_, educationl4_.name as name402_3_, employee5_.id as id399_4_, employee5_.callup_subject_id as callup8_399_4_, employee5_.dismissal_dt as dismissal2_399_4_, employee5_.is_dismissed as is3_399_4_, employee5_.employment_dt as employment4_399_4_, employee5_.individual_id as individual9_399_4_, employee5_.note as note399_4_, employee5_.number as number399_4_, employee5_.organization_id as organiz10_399_4_, employee5_.photo as photo399_4_, exists(select 1 from pim_empl_posit_to_prefer_recipe pR inner join pim_employee_position ep ON pR.employee_position_id=ep.id inner join pim_employee e ON ep.employee_id=e.id inner join md_clinic c ON e.organization_id=c.id where e.id = employee5_.id and (pR.begin_date is NULL or pR.begin_date <= CURRENT_DATE) and (pr.end_date is NULL or pr.end_date >= CURRENT_DATE) and c.is_in_ads limit 1) as formula33_4_, exists(select 1 from pim_employee_position_resource pepr inner join pim_employee_position pep on pepr.employee_position_id=pep.id inner join pim_employee pe on pep.employee_id=pe.id where pe.id =employee5_.id and ((pep.start_date < CURRENT_TIMESTAMP and CURRENT_TIMESTAMP < pep.end_date) or (pep.start_date < CURRENT_TIMESTAMP and pep.end_date is NULL) or (pep.start_date is NULL and CURRENT_TIMESTAMP < pep.end_date) or (pep.start_date is NULL and pep.end_date is NULL))) as formula34_4_, (select sup.id from sec_user_party sup inner join pim_employee pe on sup.party_id=pe.individual_id where pe.id=employee5_.id limit 1) as formula35_4_, individual6_.id as id193_5_, individual6_1_.note as note193_5_, individual6_1_.type_id as type4_193_5_, individual6_1_.version as version193_5_, individual6_.birth_dt as birth1_233_5_, individual6_.death_dt as death2_233_5_, individual6_.gender_id as gender16_233_5_, individual6_.has_citizenship as has3_233_5_, individual6_.list_identity_doc as list4_233_5_, individual6_.list_job_org as list5_233_5_, individual6_.list_main_contact as list6_233_5_, individual6_.list_oms_doc as list7_233_5_, individual6_.list_reg_name as list8_233_5_, individual6_.list_snils as list9_233_5_, individual6_.list_uid as list10_233_5_, individual6_.aud_when as aud11_233_5_, individual6_.name as name233_5_, individual6_.nationality_id as nationa17_233_5_, individual6_.patr_name as patr13_233_5_, individual6_.surname as surname233_5_, upper(individual6_.SURNAME)||upper(individual6_.NAME)||upper(individual6_.PATR_NAME) as formula22_5_, partytype7_.id as id237_6_, partytype7_.name as name237_6_, partytype7_.note as note237_6_, gender8_.id as id217_7_, gender8_.code as code217_7_, gender8_.name as name217_7_, gender8_.scope_id as scope4_217_7_, (select case pg.code when 'UNKNOWN' then 'Общий' else pg.name end from pim_gender pg where pg.id= gender8_.id) as formula21_7_, nationalit9_.id as id192_8_, nationalit9_.code as code192_8_, nationalit9_.name as name192_8_, nationalit9_.parent_id as parent4_192_8_, nationalit10_.id as id192_9_, nationalit10_.code as code192_9_, nationalit10_.name as name192_9_, nationalit10_.parent_id as parent4_192_9_, employeeto11_.id as id389_10_, employeeto11_.code as code389_10_, employeeto11_.dismissal_order_code as dismissal3_389_10_, employeeto11_.dismissal_reason_id as dismissal8_389_10_, employeeto11_.employee_id as employee9_389_10_, employeeto11_.employment_type_id as employment10_389_10_, employeeto11_.start_date as start4_389_10_, employeeto11_.hiring_order_code as hiring5_389_10_, employeeto11_.hiring_type_id as hiring11_389_10_, employeeto11_.position_id as position12_389_10_, employeeto11_.position_type_id as position13_389_10_, employeeto11_.rate as rate389_10_, employeeto11_.end_date as end7_389_10_, employeeto11_.unit_id as unit14_389_10_, exists(select 1 from md_clinic mc inner join pim_position pp ON mc.id=pp.organization_id inner join pim_employee_position pep ON pp.id=pep.position_id where pep.id=employeeto11_.id and mc.is_in_ads) as formula30_10_, (select pR.id from pim_empl_posit_to_prefer_recipe pR where pR.employee_position_id = employeeto11_.id and (pR.begin_date <= CURRENT_DATE or pr.begin_date is null) and (pr.end_date >= CURRENT_DATE or pr.end_date is null) limit 1) as formula31_10_, employee12_.id as id399_11_, employee12_.callup_subject_id as callup8_399_11_, employee12_.dismissal_dt as dismissal2_399_11_, employee12_.is_dismissed as is3_399_11_, employee12_.employment_dt as employment4_399_11_, employee12_.individual_id as individual9_399_11_, employee12_.note as note399_11_, employee12_.number as number399_11_, employee12_.organization_id as organiz10_399_11_, employee12_.photo as photo399_11_, exists(select 1 from pim_empl_posit_to_prefer_recipe pR inner join pim_employee_position ep ON pR.employee_position_id=ep.id inner join pim_employee e ON ep.employee_id=e.id inner join md_clinic c ON e.organization_id=c.id where e.id = employee12_.id and (pR.begin_date is NULL or pR.begin_date <= CURRENT_DATE) and (pr.end_date is NULL or pr.end_date >= CURRENT_DATE) and c.is_in_ads limit 1) as formula33_11_, exists(select 1 from pim_employee_position_resource pepr inner join pim_employee_position pep on pepr.employee_position_id=pep.id inner join pim_employee pe on pep.employee_id=pe.id where pe.id =employee12_.id and ((pep.start_date < CURRENT_TIMESTAMP and CURRENT_TIMESTAMP < pep.end_date) or (pep.start_date < CURRENT_TIMESTAMP and pep.end_date is NULL) or (pep.start_date is NULL and CURRENT_TIMESTAMP < pep.end_date) or (pep.start_date is NULL and pep.end_date is NULL))) as formula34_11_, (select sup.id from sec_user_party sup inner join pim_employee pe on sup.party_id=pe.individual_id where pe.id=employee12_.id limit 1) as formula35_11_, position13_.id as id395_12_, position13_.code as code395_12_, position13_.department_id as department7_395_12_, position13_.start_date as start3_395_12_, position13_.name as name395_12_, position13_.organization_id as organiza8_395_12_, position13_.role_id as role9_395_12_, position13_.rate as rate395_12_, position13_.speciality_id as speciality10_395_12_, position13_.end_date as end6_395_12_, (select sum(pep.rate) from pim_employee_position pep where pep.position_id = position13_.id and (pep.start_date is null or pep.start_date <= current_date) and (pep.end_date is null or pep.end_date >= current_date)) as formula32_12_, speciality14_.id as id392_13_, speciality14_.code as code392_13_, speciality14_.code_regional as code3_392_13_, speciality14_.education_type_id as education5_392_13_, speciality14_.name as name392_13_, speciality14_.parent_id as parent6_392_13_, speciality14_.sphere_id as sphere7_392_13_, ethnicgrou15_.id as id636_14_, ethnicgrou15_.code as code636_14_, ethnicgrou15_.name as name636_14_, socialgrou16_.id as id645_15_, socialgrou16_.code as code645_15_, socialgrou16_.from_age as from3_645_15_, socialgrou16_.from_dt as from4_645_15_, socialgrou16_.name as name645_15_, socialgrou16_.to_age as to6_645_15_, socialgrou16_.to_dt as to7_645_15_, individual17_.id as id193_16_, individual17_1_.note as note193_16_, individual17_1_.type_id as type4_193_16_, individual17_1_.version as version193_16_, individual17_.birth_dt as birth1_233_16_, individual17_.death_dt as death2_233_16_, individual17_.gender_id as gender16_233_16_, individual17_.has_citizenship as has3_233_16_, individual17_.list_identity_doc as list4_233_16_, individual17_.list_job_org as list5_233_16_, individual17_.list_main_contact as list6_233_16_, individual17_.list_oms_doc as list7_233_16_, individual17_.list_reg_name as list8_233_16_, individual17_.list_snils as list9_233_16_, individual17_.list_uid as list10_233_16_, individual17_.aud_when as aud11_233_16_, individual17_.name as name233_16_, individual17_.nationality_id as nationa17_233_16_, individual17_.patr_name as patr13_233_16_, individual17_.surname as surname233_16_, upper(individual17_.SURNAME)||upper(individual17_.NAME)||upper(individual17_.PATR_NAME) as formula22_16_ from pci_patient patient0_ left outer join md_rh_blood_group bloodgroup1_ on patient0_.rh_blood_group_id=bloodgroup1_.id left outer join pim_death_source_info deathsourc2_ on patient0_.death_src_inf_id=deathsourc2_.id left outer join pim_education_type educationt3_ on patient0_.education_type_id=educationt3_.id left outer join pim_education_level educationl4_ on educationt3_.level_id=educationl4_.id left outer join pim_employee employee5_ on patient0_.empl_state_death_id=employee5_.id left outer join pim_individual individual6_ on employee5_.individual_id=individual6_.id left outer join pim_party individual6_1_ on individual6_.id=individual6_1_.id left outer join pim_party_type partytype7_ on individual6_1_.type_id=partytype7_.id left outer join pim_gender gender8_ on individual6_.gender_id=gender8_.id left outer join pim_nationality nationalit9_ on individual6_.nationality_id=nationalit9_.id left outer join pim_nationality nationalit10_ on nationalit9_.parent_id=nationalit10_.id left outer join pim_employee_position employeeto11_ on patient0_.employee_reg_death_position_id=employeeto11_.id left outer join pim_employee employee12_ on employeeto11_.employee_id=employee12_.id left outer join pim_position position13_ on employeeto11_.position_id=position13_.id left outer join pim_speciality speciality14_ on position13_.speciality_id=speciality14_.id left outer join md_ethnic_group ethnicgrou15_ on patient0_.ethnic_group_id=ethnicgrou15_.id left outer join md_soc_group socialgrou16_ on patient0_.social_group_id=socialgrou16_.id left outer join pim_individual individual17_ on patient0_.id=individual17_.id left outer join pim_party individual17_1_ on individual17_.id=individual17_1_.id where patient0_.id=$1
  103. 2017-08-21 17:19:23 YAKT [1726]: [638-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '7281717'
  104. 2017-08-21 17:19:23 YAKT [1726]: [639-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.139 ms bind S_12: select partytype0_.id as id237_0_, partytype0_.name as name237_0_, partytype0_.note as note237_0_ from pim_party_type partytype0_ where partytype0_.id=$1
  105. 2017-08-21 17:19:23 YAKT [1726]: [640-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  106. 2017-08-21 17:19:23 YAKT [1726]: [641-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.016 ms execute S_12: select partytype0_.id as id237_0_, partytype0_.name as name237_0_, partytype0_.note as note237_0_ from pim_party_type partytype0_ where partytype0_.id=$1
  107. 2017-08-21 17:19:23 YAKT [1726]: [642-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  108. 2017-08-21 17:19:23 YAKT [1726]: [643-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.120 ms bind S_13: select gender0_.id as id217_0_, gender0_.code as code217_0_, gender0_.name as name217_0_, gender0_.scope_id as scope4_217_0_, (select case pg.code when 'UNKNOWN' then 'Общий' else pg.name end from pim_gender pg where pg.id= gender0_.id) as formula21_0_ from pim_gender gender0_ where gender0_.id=$1
  109. 2017-08-21 17:19:23 YAKT [1726]: [644-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  110. 2017-08-21 17:19:23 YAKT [1726]: [645-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.026 ms execute S_13: select gender0_.id as id217_0_, gender0_.code as code217_0_, gender0_.name as name217_0_, gender0_.scope_id as scope4_217_0_, (select case pg.code when 'UNKNOWN' then 'Общий' else pg.name end from pim_gender pg where pg.id= gender0_.id) as formula21_0_ from pim_gender gender0_ where gender0_.id=$1
  111. 2017-08-21 17:19:23 YAKT [1726]: [646-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  112. 2017-08-21 17:19:23 YAKT [1726]: [647-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 2.990 ms bind S_14: select patientreg0_.patient_id as patient15_269_11_, patientreg0_.id as id11_, patientreg0_.id as id275_10_, patientreg0_.is_assertion as is2_275_10_, patientreg0_.automatic_district_dt as automatic3_275_10_, patientreg0_.clinic_id as clinic10_275_10_, patientreg0_.district_id as district11_275_10_, patientreg0_.district_by_addr_id as district12_275_10_, patientreg0_.department_id as department13_275_10_, patientreg0_.aud_when as aud4_275_10_, patientreg0_.number_attach as number5_275_10_, patientreg0_.address_id as address14_275_10_, patientreg0_.patient_id as patient15_275_10_, patientreg0_.reg_dt as reg6_275_10_, patientreg0_.state_id as state16_275_10_, patientreg0_.type_id as type17_275_10_, patientreg0_.request_dt as request7_275_10_, patientreg0_.request_uid as request8_275_10_, patientreg0_.unreg_cause_id as unreg18_275_10_, patientreg0_.unreg_dt as unreg9_275_10_, clinicdist1_.id as id705_0_, clinicdist1_.attache_number as attache2_705_0_, clinicdist1_.kind_id as kind8_705_0_, clinicdist1_.type_id as type9_705_0_, clinicdist1_.separation_id as separation10_705_0_, clinicdist1_.code as code705_0_, clinicdist1_.from_dt as from4_705_0_, clinicdist1_.name as name705_0_, clinicdist1_.order_number as order6_705_0_, clinicdist1_.to_dt as to7_705_0_, clinicdist2_.id as id703_1_, clinicdist2_.code as code703_1_, clinicdist2_.name as name703_1_, clinicdist3_.id as id707_2_, clinicdist3_.code as code707_2_, clinicdist3_.name as name707_2_, clinicsepa4_.id as id700_3_, clinicsepa4_.clinic_id as clinic5_700_3_, clinicsepa4_.profile_id as profile6_700_3_, clinicsepa4_.from_dt as from2_700_3_, clinicsepa4_.name as name700_3_, clinicsepa4_.reg_type_id as reg7_700_3_, clinicsepa4_.to_dt as to4_700_3_, clinic5_.id as id655_4_, clinic5_.is_in_ads as is2_655_4_, clinic5_.code as code655_4_, clinic5_.departmental_attachment_id as departme6_655_4_, clinic5_.level_id as level7_655_4_, clinic5_.location_id as location8_655_4_, clinic5_.nomenclature_type_id as nomencla9_655_4_, clinic5_.note as note655_4_, clinic5_.is_offline as is5_655_4_, clinic5_.scope_id as scope10_655_4_, clinic5_.subordination_category_id as subordi11_655_4_, clinic5_.territory_id as territory12_655_4_, organizati6_.id as id193_5_, organizati6_1_.note as note193_5_, organizati6_1_.type_id as type4_193_5_, organizati6_1_.version as version193_5_, organizati6_.close_dt as close1_194_5_, organizati6_.code as code194_5_, organizati6_.country_jurisdiction_id as country7_194_5_, organizati6_.full_name as full3_194_5_, organizati6_.legal_form_id as legal8_194_5_, organizati6_.own_form_id as own9_194_5_, organizati6_.parent_id as parent10_194_5_, organizati6_.reg_dt as reg4_194_5_, organizati6_.scope_id as scope11_194_5_, organizati6_.short_name as short5_194_5_, organizati6_.sphere_id as sphere12_194_5_, organizati6_.unit_id as unit13_194_5_, organizati6_.work_territory_id as work14_194_5_, coalesce(organizati6_.SHORT_NAME, organizati6_.FULL_NAME) as formula19_5_, (select max(poc.code) from pim_org_code poc, pim_code_type pct where poc.org_id = organizati6_.id and poc.type_id = pct.id and pct.code = 'INN_ORGANIZATION') as formula20_5_, partytype7_.id as id237_6_, partytype7_.name as name237_6_, partytype7_.note as note237_6_, medicalpro8_.id as id630_7_, medicalpro8_.code as code630_7_, medicalpro8_.genitive_name as genitive3_630_7_, medicalpro8_.name as name630_7_, regtype9_.id as id598_8_, regtype9_.code as code598_8_, regtype9_.from_dt as from3_598_8_, regtype9_.is_portal as is4_598_8_, regtype9_.name as name598_8_, regtype9_.to_dt as to6_598_8_, clinicdist10_.id as id705_9_, clinicdist10_.attache_number as attache2_705_9_, clinicdist10_.kind_id as kind8_705_9_, clinicdist10_.type_id as type9_705_9_, clinicdist10_.separation_id as separation10_705_9_, clinicdist10_.code as code705_9_, clinicdist10_.from_dt as from4_705_9_, clinicdist10_.name as name705_9_, clinicdist10_.order_number as order6_705_9_, clinicdist10_.to_dt as to7_705_9_ from pci_patient_reg patientreg0_ left outer join md_clinic_district clinicdist1_ on patientreg0_.district_id=clinicdist1_.id left outer join md_clinic_district_kind clinicdist2_ on clinicdist1_.kind_id=clinicdist2_.id left outer join md_clinic_district_type clinicdist3_ on clinicdist1_.type_id=clinicdist3_.id left outer join md_clinic_separation clinicsepa4_ on clinicdist1_.separation_id=clinicsepa4_.id left outer join md_clinic clinic5_ on clinicsepa4_.clinic_id=clinic5_.id left outer join pim_organization organizati6_ on clinic5_.id=organizati6_.id left outer join pim_party organizati6_1_ on organizati6_.id=organizati6_1_.id left outer join pim_party_type partytype7_ on organizati6_1_.type_id=partytype7_.id left outer join md_profile medicalpro8_ on clinicsepa4_.profile_id=medicalpro8_.id left outer join md_reg_type regtype9_ on clinicsepa4_.reg_type_id=regtype9_.id left outer join md_clinic_district clinicdist10_ on patientreg0_.district_by_addr_id=clinicdist10_.id where patientreg0_.patient_id=$1 order by patientreg0_.reg_dt desc
  113. 2017-08-21 17:19:23 YAKT [1726]: [648-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '7281717'
  114. 2017-08-21 17:19:23 YAKT [1726]: [649-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.079 ms execute S_14: select patientreg0_.patient_id as patient15_269_11_, patientreg0_.id as id11_, patientreg0_.id as id275_10_, patientreg0_.is_assertion as is2_275_10_, patientreg0_.automatic_district_dt as automatic3_275_10_, patientreg0_.clinic_id as clinic10_275_10_, patientreg0_.district_id as district11_275_10_, patientreg0_.district_by_addr_id as district12_275_10_, patientreg0_.department_id as department13_275_10_, patientreg0_.aud_when as aud4_275_10_, patientreg0_.number_attach as number5_275_10_, patientreg0_.address_id as address14_275_10_, patientreg0_.patient_id as patient15_275_10_, patientreg0_.reg_dt as reg6_275_10_, patientreg0_.state_id as state16_275_10_, patientreg0_.type_id as type17_275_10_, patientreg0_.request_dt as request7_275_10_, patientreg0_.request_uid as request8_275_10_, patientreg0_.unreg_cause_id as unreg18_275_10_, patientreg0_.unreg_dt as unreg9_275_10_, clinicdist1_.id as id705_0_, clinicdist1_.attache_number as attache2_705_0_, clinicdist1_.kind_id as kind8_705_0_, clinicdist1_.type_id as type9_705_0_, clinicdist1_.separation_id as separation10_705_0_, clinicdist1_.code as code705_0_, clinicdist1_.from_dt as from4_705_0_, clinicdist1_.name as name705_0_, clinicdist1_.order_number as order6_705_0_, clinicdist1_.to_dt as to7_705_0_, clinicdist2_.id as id703_1_, clinicdist2_.code as code703_1_, clinicdist2_.name as name703_1_, clinicdist3_.id as id707_2_, clinicdist3_.code as code707_2_, clinicdist3_.name as name707_2_, clinicsepa4_.id as id700_3_, clinicsepa4_.clinic_id as clinic5_700_3_, clinicsepa4_.profile_id as profile6_700_3_, clinicsepa4_.from_dt as from2_700_3_, clinicsepa4_.name as name700_3_, clinicsepa4_.reg_type_id as reg7_700_3_, clinicsepa4_.to_dt as to4_700_3_, clinic5_.id as id655_4_, clinic5_.is_in_ads as is2_655_4_, clinic5_.code as code655_4_, clinic5_.departmental_attachment_id as departme6_655_4_, clinic5_.level_id as level7_655_4_, clinic5_.location_id as location8_655_4_, clinic5_.nomenclature_type_id as nomencla9_655_4_, clinic5_.note as note655_4_, clinic5_.is_offline as is5_655_4_, clinic5_.scope_id as scope10_655_4_, clinic5_.subordination_category_id as subordi11_655_4_, clinic5_.territory_id as territory12_655_4_, organizati6_.id as id193_5_, organizati6_1_.note as note193_5_, organizati6_1_.type_id as type4_193_5_, organizati6_1_.version as version193_5_, organizati6_.close_dt as close1_194_5_, organizati6_.code as code194_5_, organizati6_.country_jurisdiction_id as country7_194_5_, organizati6_.full_name as full3_194_5_, organizati6_.legal_form_id as legal8_194_5_, organizati6_.own_form_id as own9_194_5_, organizati6_.parent_id as parent10_194_5_, organizati6_.reg_dt as reg4_194_5_, organizati6_.scope_id as scope11_194_5_, organizati6_.short_name as short5_194_5_, organizati6_.sphere_id as sphere12_194_5_, organizati6_.unit_id as unit13_194_5_, organizati6_.work_territory_id as work14_194_5_, coalesce(organizati6_.SHORT_NAME, organizati6_.FULL_NAME) as formula19_5_, (select max(poc.code) from pim_org_code poc, pim_code_type pct where poc.org_id = organizati6_.id and poc.type_id = pct.id and pct.code = 'INN_ORGANIZATION') as formula20_5_, partytype7_.id as id237_6_, partytype7_.name as name237_6_, partytype7_.note as note237_6_, medicalpro8_.id as id630_7_, medicalpro8_.code as code630_7_, medicalpro8_.genitive_name as genitive3_630_7_, medicalpro8_.name as name630_7_, regtype9_.id as id598_8_, regtype9_.code as code598_8_, regtype9_.from_dt as from3_598_8_, regtype9_.is_portal as is4_598_8_, regtype9_.name as name598_8_, regtype9_.to_dt as to6_598_8_, clinicdist10_.id as id705_9_, clinicdist10_.attache_number as attache2_705_9_, clinicdist10_.kind_id as kind8_705_9_, clinicdist10_.type_id as type9_705_9_, clinicdist10_.separation_id as separation10_705_9_, clinicdist10_.code as code705_9_, clinicdist10_.from_dt as from4_705_9_, clinicdist10_.name as name705_9_, clinicdist10_.order_number as order6_705_9_, clinicdist10_.to_dt as to7_705_9_ from pci_patient_reg patientreg0_ left outer join md_clinic_district clinicdist1_ on patientreg0_.district_id=clinicdist1_.id left outer join md_clinic_district_kind clinicdist2_ on clinicdist1_.kind_id=clinicdist2_.id left outer join md_clinic_district_type clinicdist3_ on clinicdist1_.type_id=clinicdist3_.id left outer join md_clinic_separation clinicsepa4_ on clinicdist1_.separation_id=clinicsepa4_.id left outer join md_clinic clinic5_ on clinicsepa4_.clinic_id=clinic5_.id left outer join pim_organization organizati6_ on clinic5_.id=organizati6_.id left outer join pim_party organizati6_1_ on organizati6_.id=organizati6_1_.id left outer join pim_party_type partytype7_ on organizati6_1_.type_id=partytype7_.id left outer join md_profile medicalpro8_ on clinicsepa4_.profile_id=medicalpro8_.id left outer join md_reg_type regtype9_ on clinicsepa4_.reg_type_id=regtype9_.id left outer join md_clinic_district clinicdist10_ on patientreg0_.district_by_addr_id=clinicdist10_.id where patientreg0_.patient_id=$1 order by patientreg0_.reg_dt desc
  115. 2017-08-21 17:19:23 YAKT [1726]: [650-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '7281717'
  116. 2017-08-21 17:19:23 YAKT [1726]: [651-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.158 ms parse <unnamed>: SELECT o.id, oc.code, trim(coalesce(o.short_name, o.full_name)) FROM public.pim_organization o JOIN public.pim_org_code oc ON oc.org_id = o.id JOIN public.pim_code_type ct ON ct.id = oc.type_id AND ct.code = 'OID' WHERE o.id IN ($1)
  117. 2017-08-21 17:19:23 YAKT [1726]: [652-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.310 ms bind <unnamed>: SELECT o.id, oc.code, trim(coalesce(o.short_name, o.full_name)) FROM public.pim_organization o JOIN public.pim_org_code oc ON oc.org_id = o.id JOIN public.pim_code_type ct ON ct.id = oc.type_id AND ct.code = 'OID' WHERE o.id IN ($1)
  118. 2017-08-21 17:19:23 YAKT [1726]: [653-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  119. 2017-08-21 17:19:23 YAKT [1726]: [654-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.043 ms execute <unnamed>: SELECT o.id, oc.code, trim(coalesce(o.short_name, o.full_name)) FROM public.pim_organization o JOIN public.pim_org_code oc ON oc.org_id = o.id JOIN public.pim_code_type ct ON ct.id = oc.type_id AND ct.code = 'OID' WHERE o.id IN ($1)
  120. 2017-08-21 17:19:23 YAKT [1726]: [655-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  121. 2017-08-21 17:19:23 YAKT [1726]: [656-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.106 ms bind S_4: select partyaddre0_.id as id186_, partyaddre0_.addr_id as addr8_186_, partyaddre0_.from_date as from2_186_, partyaddre0_.aud_when as aud3_186_, partyaddre0_.note as note186_, partyaddre0_.party_id as party9_186_, partyaddre0_.register_type_id as register10_186_, partyaddre0_.text_addr as text5_186_, partyaddre0_.to_date as to6_186_, partyaddre0_.is_valid as is7_186_ from pim_party_address partyaddre0_ where partyaddre0_.party_id=$1
  122. 2017-08-21 17:19:23 YAKT [1726]: [657-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  123. 2017-08-21 17:19:23 YAKT [1726]: [658-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.027 ms execute S_4: select partyaddre0_.id as id186_, partyaddre0_.addr_id as addr8_186_, partyaddre0_.from_date as from2_186_, partyaddre0_.aud_when as aud3_186_, partyaddre0_.note as note186_, partyaddre0_.party_id as party9_186_, partyaddre0_.register_type_id as register10_186_, partyaddre0_.text_addr as text5_186_, partyaddre0_.to_date as to6_186_, partyaddre0_.is_valid as is7_186_ from pim_party_address partyaddre0_ where partyaddre0_.party_id=$1
  124. 2017-08-21 17:19:23 YAKT [1726]: [659-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  125. 2017-08-21 17:19:23 YAKT [1726]: [660-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.053 ms bind S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  126. 2017-08-21 17:19:23 YAKT [1726]: [661-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1310946'
  127. 2017-08-21 17:19:23 YAKT [1726]: [662-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.046 ms execute S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  128. 2017-08-21 17:19:23 YAKT [1726]: [663-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1310946'
  129. 2017-08-21 17:19:23 YAKT [1726]: [664-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.430 ms bind S_5: select partyaddre0_.party_address_id as party3_186_3_, partyaddre0_.id as id3_, partyaddre0_.id as id246_2_, partyaddre0_.address_type_id as address2_246_2_, partyaddre0_.party_address_id as party3_246_2_, addresstyp1_.id as id234_0_, addresstyp1_.code as code234_0_, addresstyp1_.name as name234_0_, addresstyp1_.note as note234_0_, addresstyp1_.party_type_id as party5_234_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_addr_to_addr_type partyaddre0_ inner join pim_address_type addresstyp1_ on partyaddre0_.address_type_id=addresstyp1_.id left outer join pim_party_type partytype2_ on addresstyp1_.party_type_id=partytype2_.id where partyaddre0_.party_address_id=$1
  130. 2017-08-21 17:19:23 YAKT [1726]: [665-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1258118'
  131. 2017-08-21 17:19:23 YAKT [1726]: [666-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.050 ms execute S_5: select partyaddre0_.party_address_id as party3_186_3_, partyaddre0_.id as id3_, partyaddre0_.id as id246_2_, partyaddre0_.address_type_id as address2_246_2_, partyaddre0_.party_address_id as party3_246_2_, addresstyp1_.id as id234_0_, addresstyp1_.code as code234_0_, addresstyp1_.name as name234_0_, addresstyp1_.note as note234_0_, addresstyp1_.party_type_id as party5_234_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_addr_to_addr_type partyaddre0_ inner join pim_address_type addresstyp1_ on partyaddre0_.address_type_id=addresstyp1_.id left outer join pim_party_type partytype2_ on addresstyp1_.party_type_id=partytype2_.id where partyaddre0_.party_address_id=$1
  132. 2017-08-21 17:19:23 YAKT [1726]: [667-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1258118'
  133. 2017-08-21 17:19:24 YAKT [1726]: [668-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.151 ms bind S_6: select organizati0_.id as id228_, organizati0_.is_main as is2_228_, organizati0_.note as note228_, organizati0_.type_id as type5_228_, organizati0_.value as value228_, organizati0_.org_id as org6_228_ from pim_org_contact organizati0_ where organizati0_.org_id=$1 and organizati0_.is_main=true order by organizati0_.type_id
  134. 2017-08-21 17:19:24 YAKT [1726]: [669-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  135. 2017-08-21 17:19:24 YAKT [1726]: [670-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.042 ms execute S_6: select organizati0_.id as id228_, organizati0_.is_main as is2_228_, organizati0_.note as note228_, organizati0_.type_id as type5_228_, organizati0_.value as value228_, organizati0_.org_id as org6_228_ from pim_org_contact organizati0_ where organizati0_.org_id=$1 and organizati0_.is_main=true order by organizati0_.type_id
  136. 2017-08-21 17:19:24 YAKT [1726]: [671-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  137. 2017-08-21 17:19:24 YAKT [1726]: [672-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.068 ms bind S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  138. 2017-08-21 17:19:24 YAKT [1726]: [673-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '9'
  139. 2017-08-21 17:19:24 YAKT [1726]: [674-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.046 ms execute S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  140. 2017-08-21 17:19:24 YAKT [1726]: [675-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '9'
  141. 2017-08-21 17:19:24 YAKT [1726]: [676-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.501 ms bind S_7: select organizati0_.id as id193_1_, organizati0_1_.note as note193_1_, organizati0_1_.type_id as type4_193_1_, organizati0_1_.version as version193_1_, organizati0_.close_dt as close1_194_1_, organizati0_.code as code194_1_, organizati0_.country_jurisdiction_id as country7_194_1_, organizati0_.full_name as full3_194_1_, organizati0_.legal_form_id as legal8_194_1_, organizati0_.own_form_id as own9_194_1_, organizati0_.parent_id as parent10_194_1_, organizati0_.reg_dt as reg4_194_1_, organizati0_.scope_id as scope11_194_1_, organizati0_.short_name as short5_194_1_, organizati0_.sphere_id as sphere12_194_1_, organizati0_.unit_id as unit13_194_1_, organizati0_.work_territory_id as work14_194_1_, coalesce(organizati0_.SHORT_NAME, organizati0_.FULL_NAME) as formula19_1_, (select max(poc.code) from pim_org_code poc, pim_code_type pct where poc.org_id = organizati0_.id and poc.type_id = pct.id and pct.code = 'INN_ORGANIZATION') as formula20_1_, partytype1_.id as id237_0_, partytype1_.name as name237_0_, partytype1_.note as note237_0_ from pim_organization organizati0_ inner join pim_party organizati0_1_ on organizati0_.id=organizati0_1_.id inner join pim_party_type partytype1_ on organizati0_1_.type_id=partytype1_.id where organizati0_.id=$1
  142. 2017-08-21 17:19:24 YAKT [1726]: [677-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  143. 2017-08-21 17:19:24 YAKT [1726]: [678-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.067 ms execute S_7: select organizati0_.id as id193_1_, organizati0_1_.note as note193_1_, organizati0_1_.type_id as type4_193_1_, organizati0_1_.version as version193_1_, organizati0_.close_dt as close1_194_1_, organizati0_.code as code194_1_, organizati0_.country_jurisdiction_id as country7_194_1_, organizati0_.full_name as full3_194_1_, organizati0_.legal_form_id as legal8_194_1_, organizati0_.own_form_id as own9_194_1_, organizati0_.parent_id as parent10_194_1_, organizati0_.reg_dt as reg4_194_1_, organizati0_.scope_id as scope11_194_1_, organizati0_.short_name as short5_194_1_, organizati0_.sphere_id as sphere12_194_1_, organizati0_.unit_id as unit13_194_1_, organizati0_.work_territory_id as work14_194_1_, coalesce(organizati0_.SHORT_NAME, organizati0_.FULL_NAME) as formula19_1_, (select max(poc.code) from pim_org_code poc, pim_code_type pct where poc.org_id = organizati0_.id and poc.type_id = pct.id and pct.code = 'INN_ORGANIZATION') as formula20_1_, partytype1_.id as id237_0_, partytype1_.name as name237_0_, partytype1_.note as note237_0_ from pim_organization organizati0_ inner join pim_party organizati0_1_ on organizati0_.id=organizati0_1_.id inner join pim_party_type partytype1_ on organizati0_1_.type_id=partytype1_.id where organizati0_.id=$1
  144. 2017-08-21 17:19:24 YAKT [1726]: [679-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  145. 2017-08-21 17:19:24 YAKT [1726]: [680-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.055 ms bind S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  146. 2017-08-21 17:19:24 YAKT [1726]: [681-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '13'
  147. 2017-08-21 17:19:24 YAKT [1726]: [682-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.038 ms execute S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  148. 2017-08-21 17:19:24 YAKT [1726]: [683-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '13'
  149. 2017-08-21 17:19:24 YAKT [1726]: [684-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 3.198 ms bind S_9: SELECT DISTINCT d.id, d.name FROM public.pim_department d JOIN public.pc_department pd ON pd.id = d.id AND pd.is_visible JOIN md_department_address da ON da.dep_id = pd.id WHERE d.org_id = $1 AND exists(SELECT 1 FROM sr_scgenerated g JOIN sr_res_group rg ON g.res_group_id = rg.id WHERE g.date > current_date AND rg.department_id = pd.id AND g.source_id = (SELECT s.id FROM md_appointment_source s WHERE s.code = 'EPGU'))
  150. 2017-08-21 17:19:24 YAKT [1726]: [685-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  151. 2017-08-21 17:19:24 YAKT [1726]: [686-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 19.027 ms execute S_9: SELECT DISTINCT d.id, d.name FROM public.pim_department d JOIN public.pc_department pd ON pd.id = d.id AND pd.is_visible JOIN md_department_address da ON da.dep_id = pd.id WHERE d.org_id = $1 AND exists(SELECT 1 FROM sr_scgenerated g JOIN sr_res_group rg ON g.res_group_id = rg.id WHERE g.date > current_date AND rg.department_id = pd.id AND g.source_id = (SELECT s.id FROM md_appointment_source s WHERE s.code = 'EPGU'))
  152. 2017-08-21 17:19:24 YAKT [1726]: [687-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  153. 2017-08-21 17:19:24 YAKT [1726]: [688-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.183 ms parse <unnamed>: SELECT o.id, oc.code, trim(coalesce(o.short_name, o.full_name)) FROM public.pc_clinic c JOIN public.pim_organization o ON o.id = c.id JOIN public.pim_org_code oc ON oc.org_id = o.id JOIN public.pim_code_type ct ON ct.id = oc.type_id AND ct.code = 'OID' WHERE c.show_on_epgu AND o.id NOT IN ($1)
  154. 2017-08-21 17:19:24 YAKT [1726]: [689-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.700 ms bind <unnamed>: SELECT o.id, oc.code, trim(coalesce(o.short_name, o.full_name)) FROM public.pc_clinic c JOIN public.pim_organization o ON o.id = c.id JOIN public.pim_org_code oc ON oc.org_id = o.id JOIN public.pim_code_type ct ON ct.id = oc.type_id AND ct.code = 'OID' WHERE c.show_on_epgu AND o.id NOT IN ($1)
  155. 2017-08-21 17:19:24 YAKT [1726]: [690-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  156. 2017-08-21 17:19:24 YAKT [1726]: [691-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.065 ms execute <unnamed>: SELECT o.id, oc.code, trim(coalesce(o.short_name, o.full_name)) FROM public.pc_clinic c JOIN public.pim_organization o ON o.id = c.id JOIN public.pim_org_code oc ON oc.org_id = o.id JOIN public.pim_code_type ct ON ct.id = oc.type_id AND ct.code = 'OID' WHERE c.show_on_epgu AND o.id NOT IN ($1)
  157. 2017-08-21 17:19:24 YAKT [1726]: [692-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10909'
  158. 2017-08-21 17:19:24 YAKT [1726]: [693-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.094 ms bind S_4: select partyaddre0_.id as id186_, partyaddre0_.addr_id as addr8_186_, partyaddre0_.from_date as from2_186_, partyaddre0_.aud_when as aud3_186_, partyaddre0_.note as note186_, partyaddre0_.party_id as party9_186_, partyaddre0_.register_type_id as register10_186_, partyaddre0_.text_addr as text5_186_, partyaddre0_.to_date as to6_186_, partyaddre0_.is_valid as is7_186_ from pim_party_address partyaddre0_ where partyaddre0_.party_id=$1
  159. 2017-08-21 17:19:24 YAKT [1726]: [694-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10927'
  160. 2017-08-21 17:19:24 YAKT [1726]: [695-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.026 ms execute S_4: select partyaddre0_.id as id186_, partyaddre0_.addr_id as addr8_186_, partyaddre0_.from_date as from2_186_, partyaddre0_.aud_when as aud3_186_, partyaddre0_.note as note186_, partyaddre0_.party_id as party9_186_, partyaddre0_.register_type_id as register10_186_, partyaddre0_.text_addr as text5_186_, partyaddre0_.to_date as to6_186_, partyaddre0_.is_valid as is7_186_ from pim_party_address partyaddre0_ where partyaddre0_.party_id=$1
  161. 2017-08-21 17:19:24 YAKT [1726]: [696-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10927'
  162. 2017-08-21 17:19:24 YAKT [1726]: [697-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.043 ms bind S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  163. 2017-08-21 17:19:24 YAKT [1726]: [698-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1230809'
  164. 2017-08-21 17:19:24 YAKT [1726]: [699-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.041 ms execute S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  165. 2017-08-21 17:19:24 YAKT [1726]: [700-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1230809'
  166. 2017-08-21 17:19:24 YAKT [1726]: [701-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.311 ms bind S_5: select partyaddre0_.party_address_id as party3_186_3_, partyaddre0_.id as id3_, partyaddre0_.id as id246_2_, partyaddre0_.address_type_id as address2_246_2_, partyaddre0_.party_address_id as party3_246_2_, addresstyp1_.id as id234_0_, addresstyp1_.code as code234_0_, addresstyp1_.name as name234_0_, addresstyp1_.note as note234_0_, addresstyp1_.party_type_id as party5_234_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_addr_to_addr_type partyaddre0_ inner join pim_address_type addresstyp1_ on partyaddre0_.address_type_id=addresstyp1_.id left outer join pim_party_type partytype2_ on addresstyp1_.party_type_id=partytype2_.id where partyaddre0_.party_address_id=$1
  167. 2017-08-21 17:19:24 YAKT [1726]: [702-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '9381'
  168. 2017-08-21 17:19:24 YAKT [1726]: [703-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.044 ms execute S_5: select partyaddre0_.party_address_id as party3_186_3_, partyaddre0_.id as id3_, partyaddre0_.id as id246_2_, partyaddre0_.address_type_id as address2_246_2_, partyaddre0_.party_address_id as party3_246_2_, addresstyp1_.id as id234_0_, addresstyp1_.code as code234_0_, addresstyp1_.name as name234_0_, addresstyp1_.note as note234_0_, addresstyp1_.party_type_id as party5_234_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_addr_to_addr_type partyaddre0_ inner join pim_address_type addresstyp1_ on partyaddre0_.address_type_id=addresstyp1_.id left outer join pim_party_type partytype2_ on addresstyp1_.party_type_id=partytype2_.id where partyaddre0_.party_address_id=$1
  169. 2017-08-21 17:19:24 YAKT [1726]: [704-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '9381'
  170. 2017-08-21 17:19:24 YAKT [1726]: [705-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.103 ms bind S_6: select organizati0_.id as id228_, organizati0_.is_main as is2_228_, organizati0_.note as note228_, organizati0_.type_id as type5_228_, organizati0_.value as value228_, organizati0_.org_id as org6_228_ from pim_org_contact organizati0_ where organizati0_.org_id=$1 and organizati0_.is_main=true order by organizati0_.type_id
  171. 2017-08-21 17:19:24 YAKT [1726]: [706-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10927'
  172. 2017-08-21 17:19:24 YAKT [1726]: [707-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.053 ms execute S_6: select organizati0_.id as id228_, organizati0_.is_main as is2_228_, organizati0_.note as note228_, organizati0_.type_id as type5_228_, organizati0_.value as value228_, organizati0_.org_id as org6_228_ from pim_org_contact organizati0_ where organizati0_.org_id=$1 and organizati0_.is_main=true order by organizati0_.type_id
  173. 2017-08-21 17:19:24 YAKT [1726]: [708-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10927'
  174. 2017-08-21 17:19:24 YAKT [1726]: [709-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.052 ms bind S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  175. 2017-08-21 17:19:24 YAKT [1726]: [710-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  176. 2017-08-21 17:19:24 YAKT [1726]: [711-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.038 ms execute S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  177. 2017-08-21 17:19:24 YAKT [1726]: [712-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1'
  178. 2017-08-21 17:19:24 YAKT [1726]: [713-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.463 ms bind S_7: select organizati0_.id as id193_1_, organizati0_1_.note as note193_1_, organizati0_1_.type_id as type4_193_1_, organizati0_1_.version as version193_1_, organizati0_.close_dt as close1_194_1_, organizati0_.code as code194_1_, organizati0_.country_jurisdiction_id as country7_194_1_, organizati0_.full_name as full3_194_1_, organizati0_.legal_form_id as legal8_194_1_, organizati0_.own_form_id as own9_194_1_, organizati0_.parent_id as parent10_194_1_, organizati0_.reg_dt as reg4_194_1_, organizati0_.scope_id as scope11_194_1_, organizati0_.short_name as short5_194_1_, organizati0_.sphere_id as sphere12_194_1_, organizati0_.unit_id as unit13_194_1_, organizati0_.work_territory_id as work14_194_1_, coalesce(organizati0_.SHORT_NAME, organizati0_.FULL_NAME) as formula19_1_, (select max(poc.code) from pim_org_code poc, pim_code_type pct where poc.org_id = organizati0_.id and poc.type_id = pct.id and pct.code = 'INN_ORGANIZATION') as formula20_1_, partytype1_.id as id237_0_, partytype1_.name as name237_0_, partytype1_.note as note237_0_ from pim_organization organizati0_ inner join pim_party organizati0_1_ on organizati0_.id=organizati0_1_.id inner join pim_party_type partytype1_ on organizati0_1_.type_id=partytype1_.id where organizati0_.id=$1
  179. 2017-08-21 17:19:24 YAKT [1726]: [714-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10927'
  180. 2017-08-21 17:19:24 YAKT [1726]: [715-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.061 ms execute S_7: select organizati0_.id as id193_1_, organizati0_1_.note as note193_1_, organizati0_1_.type_id as type4_193_1_, organizati0_1_.version as version193_1_, organizati0_.close_dt as close1_194_1_, organizati0_.code as code194_1_, organizati0_.country_jurisdiction_id as country7_194_1_, organizati0_.full_name as full3_194_1_, organizati0_.legal_form_id as legal8_194_1_, organizati0_.own_form_id as own9_194_1_, organizati0_.parent_id as parent10_194_1_, organizati0_.reg_dt as reg4_194_1_, organizati0_.scope_id as scope11_194_1_, organizati0_.short_name as short5_194_1_, organizati0_.sphere_id as sphere12_194_1_, organizati0_.unit_id as unit13_194_1_, organizati0_.work_territory_id as work14_194_1_, coalesce(organizati0_.SHORT_NAME, organizati0_.FULL_NAME) as formula19_1_, (select max(poc.code) from pim_org_code poc, pim_code_type pct where poc.org_id = organizati0_.id and poc.type_id = pct.id and pct.code = 'INN_ORGANIZATION') as formula20_1_, partytype1_.id as id237_0_, partytype1_.name as name237_0_, partytype1_.note as note237_0_ from pim_organization organizati0_ inner join pim_party organizati0_1_ on organizati0_.id=organizati0_1_.id inner join pim_party_type partytype1_ on organizati0_1_.type_id=partytype1_.id where organizati0_.id=$1
  181. 2017-08-21 17:19:24 YAKT [1726]: [716-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10927'
  182. 2017-08-21 17:19:24 YAKT [1726]: [717-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.054 ms bind S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  183. 2017-08-21 17:19:24 YAKT [1726]: [718-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '8'
  184. 2017-08-21 17:19:24 YAKT [1726]: [719-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.037 ms execute S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  185. 2017-08-21 17:19:24 YAKT [1726]: [720-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '8'
  186. 2017-08-21 17:19:24 YAKT [1726]: [721-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.048 ms bind S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  187. 2017-08-21 17:19:24 YAKT [1726]: [722-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10'
  188. 2017-08-21 17:19:24 YAKT [1726]: [723-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.036 ms execute S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  189. 2017-08-21 17:19:24 YAKT [1726]: [724-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10'
  190. 2017-08-21 17:19:24 YAKT [1726]: [725-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.049 ms bind S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  191. 2017-08-21 17:19:24 YAKT [1726]: [726-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '12'
  192. 2017-08-21 17:19:24 YAKT [1726]: [727-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.036 ms execute S_2: select partyconta0_.id as id190_2_, partyconta0_.category_id as category5_190_2_, partyconta0_.code as code190_2_, partyconta0_.name as name190_2_, partyconta0_.notice as notice190_2_, partyconta0_.party_type_id as party6_190_2_, partyconta1_.id as id215_0_, partyconta1_.code as code215_0_, partyconta1_.name as name215_0_, partyconta1_.note as note215_0_, partyconta1_.short_name as short5_215_0_, partytype2_.id as id237_1_, partytype2_.name as name237_1_, partytype2_.note as note237_1_ from pim_party_contact_type partyconta0_ inner join pim_party_contact_category partyconta1_ on partyconta0_.category_id=partyconta1_.id inner join pim_party_type partytype2_ on partyconta0_.party_type_id=partytype2_.id where partyconta0_.id=$1
  193. 2017-08-21 17:19:24 YAKT [1726]: [728-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '12'
  194. 2017-08-21 17:19:24 YAKT [1726]: [729-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 2.768 ms bind S_9: SELECT DISTINCT d.id, d.name FROM public.pim_department d JOIN public.pc_department pd ON pd.id = d.id AND pd.is_visible JOIN md_department_address da ON da.dep_id = pd.id WHERE d.org_id = $1 AND exists(SELECT 1 FROM sr_scgenerated g JOIN sr_res_group rg ON g.res_group_id = rg.id WHERE g.date > current_date AND rg.department_id = pd.id AND g.source_id = (SELECT s.id FROM md_appointment_source s WHERE s.code = 'EPGU'))
  195. 2017-08-21 17:19:24 YAKT [1726]: [730-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10927'
  196. 2017-08-21 17:19:24 YAKT [1726]: [731-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 12.531 ms execute S_9: SELECT DISTINCT d.id, d.name FROM public.pim_department d JOIN public.pc_department pd ON pd.id = d.id AND pd.is_visible JOIN md_department_address da ON da.dep_id = pd.id WHERE d.org_id = $1 AND exists(SELECT 1 FROM sr_scgenerated g JOIN sr_res_group rg ON g.res_group_id = rg.id WHERE g.date > current_date AND rg.department_id = pd.id AND g.source_id = (SELECT s.id FROM md_appointment_source s WHERE s.code = 'EPGU'))
  197. 2017-08-21 17:19:24 YAKT [1726]: [732-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '10927'
  198. 2017-08-21 17:19:24 YAKT [1726]: [733-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.111 ms bind S_8: select department0_.id as id613_, department0_.addr_id as addr3_613_, department0_.dep_id as dep4_613_, department0_.is_display as is2_613_ from md_department_address department0_ where department0_.dep_id=$1
  199. 2017-08-21 17:19:24 YAKT [1726]: [734-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '13773'
  200. 2017-08-21 17:19:24 YAKT [1726]: [735-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.024 ms execute S_8: select department0_.id as id613_, department0_.addr_id as addr3_613_, department0_.dep_id as dep4_613_, department0_.is_display as is2_613_ from md_department_address department0_ where department0_.dep_id=$1
  201. 2017-08-21 17:19:24 YAKT [1726]: [736-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '13773'
  202. 2017-08-21 17:19:24 YAKT [1726]: [737-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.093 ms bind S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  203. 2017-08-21 17:19:24 YAKT [1726]: [738-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1198831'
  204. 2017-08-21 17:19:24 YAKT [1726]: [739-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.039 ms execute S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  205. 2017-08-21 17:19:24 YAKT [1726]: [740-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1198831'
  206. 2017-08-21 17:19:24 YAKT [1726]: [741-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.039 ms bind S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  207. 2017-08-21 17:19:24 YAKT [1726]: [742-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1096378'
  208. 2017-08-21 17:19:24 YAKT [1726]: [743-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.036 ms execute S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  209. 2017-08-21 17:19:24 YAKT [1726]: [744-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1096378'
  210. 2017-08-21 17:19:24 YAKT [1726]: [745-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.042 ms bind S_8: select department0_.id as id613_, department0_.addr_id as addr3_613_, department0_.dep_id as dep4_613_, department0_.is_display as is2_613_ from md_department_address department0_ where department0_.dep_id=$1
  211. 2017-08-21 17:19:24 YAKT [1726]: [746-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '13771'
  212. 2017-08-21 17:19:24 YAKT [1726]: [747-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.044 ms execute S_8: select department0_.id as id613_, department0_.addr_id as addr3_613_, department0_.dep_id as dep4_613_, department0_.is_display as is2_613_ from md_department_address department0_ where department0_.dep_id=$1
  213. 2017-08-21 17:19:24 YAKT [1726]: [748-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '13771'
  214. 2017-08-21 17:19:24 YAKT [1726]: [749-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.041 ms bind S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  215. 2017-08-21 17:19:24 YAKT [1726]: [750-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1097658'
  216. 2017-08-21 17:19:24 YAKT [1726]: [751-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.043 ms execute S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  217. 2017-08-21 17:19:24 YAKT [1726]: [752-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1097658'
  218. 2017-08-21 17:19:24 YAKT [1726]: [753-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.039 ms bind S_8: select department0_.id as id613_, department0_.addr_id as addr3_613_, department0_.dep_id as dep4_613_, department0_.is_display as is2_613_ from md_department_address department0_ where department0_.dep_id=$1
  219. 2017-08-21 17:19:24 YAKT [1726]: [754-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '12877'
  220. 2017-08-21 17:19:24 YAKT [1726]: [755-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.024 ms execute S_8: select department0_.id as id613_, department0_.addr_id as addr3_613_, department0_.dep_id as dep4_613_, department0_.is_display as is2_613_ from md_department_address department0_ where department0_.dep_id=$1
  221. 2017-08-21 17:19:24 YAKT [1726]: [756-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '12877'
  222. 2017-08-21 17:19:24 YAKT [1726]: [757-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.040 ms bind S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  223. 2017-08-21 17:19:24 YAKT [1726]: [758-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1672686'
  224. 2017-08-21 17:19:24 YAKT [1726]: [759-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.038 ms execute S_3: select addressele0_.id as id785_0_, addressele0_.display_format_id as display3_785_0_, addressele0_.level_id as level4_785_0_, addressele0_.name as name785_0_, addressele0_.parent_id as parent5_785_0_, addressele0_.type_id as type6_785_0_, addressele0_1_.is_city as is1_786_0_, addressele0_1_.path as path786_0_, addressele0_1_.search_name as search3_786_0_ from address_element addressele0_ left outer join address_element_data addressele0_1_ on addressele0_.id=addressele0_1_.id where addressele0_.id=$1
  225. 2017-08-21 17:19:24 YAKT [1726]: [760-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 DETAIL: parameters: $1 = '1672686'
  226. 2017-08-21 17:19:24 YAKT [1726]: [761-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.017 ms bind S_1: COMMIT
  227. 2017-08-21 17:19:24 YAKT [1726]: [762-1] db=lsd,appname=192.168.7.2,user=rep_slave,client=127.0.0.1 LOG: duration: 0.217 ms execute S_1: COMMIT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!