w Count       : 1
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,375| QU
ERY: [CRITERIA] select this_.person_name_id as person_n1_76_0_, this_.uuid as uu
id2_76_0_, this_.preferred as preferre3_76_0_, this_.person_id as person_i4_76_0
_, this_.prefix as prefix5_76_0_, this_.given_name as given_na6_76_0_, this_.mid
dle_name as middle_n7_76_0_, this_.family_name_prefix as family_n8_76_0_, this_.
family_name as family_n9_76_0_, this_.family_name2 as family_10_76_0_, this_.fam
ily_name_suffix as family_11_76_0_, this_.degree as degree12_76_0_, this_.creato
r as creator13_76_0_, this_.date_created as date_cr14_76_0_, this_.changed_by as
 changed15_76_0_, this_.date_changed as date_ch16_76_0_, this_.voided_by as void
ed_17_76_0_, this_.date_voided as date_vo18_76_0_, this_.void_reason as void_re1
9_76_0_, this_.voided as voided20_76_0_ from person_name this_ where this_.perso
n_name_id in (?)
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,378| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,378| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,379| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,379| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,379| Av
erage time    : 18
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,380| Ro
w Count       : 1
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,380| QU
ERY: [CRITERIA] select count(*) as y0_ from person_attribute this_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,381| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,381| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,382| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,382| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,383| Av
erage time    : 47
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,383| Ro
w Count       : 1
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,384| QU
ERY: [CRITERIA] select count(*) as y0_ from patient_identifier this_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,384| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,385| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,386| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,387| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,387| Av
erage time    : 63
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,387| Ro
w Count       : 1
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,388| QU
ERY: from User u where (u.username = ? or u.systemId = ? or u.systemId = ?) and
u.retired = '0'
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,388| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,389| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,390| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,390| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,391| Av
erage time    : 8
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,391| Ro
w Count       : 1
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,391| QU
ERY: [CRITERIA] select this_.concept_name_id as y0_ from concept_name this_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,392| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,392| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,393| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,394| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,394| Av
erage time    : 28
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,394| Ro
w Count       : 0
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,395| QU
ERY: [CRITERIA] select this_.property as property1_43_0_, this_.property_value a
s property2_43_0_, this_.description as descript3_43_0_, this_.datatype as datat
ype4_43_0_, this_.datatype_config as datatype5_43_0_, this_.preferred_handler as
 preferre6_43_0_, this_.handler_config as handler_7_43_0_, this_.uuid as uuid8_4
3_0_, this_.changed_by as changed_9_43_0_, this_.date_changed as date_ch10_43_0_
 from global_property this_ where lower(this_.property) like ?
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,397| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,397| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,398| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,398| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,398| Av
erage time    : 2
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,401| Ro
w Count       : 0
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,402| QU
ERY: [CRITERIA] select this_.concept_id as y0_ from concept_complex this_ inner
join concept this_1_ on this_.concept_id=this_1_.concept_id
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,403| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,404| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,404| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,404| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,405| Av
erage time    : 0
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,405| Ro
w Count       : 0
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,405| QU
ERY: [CRITERIA] select this_.task_config_id as task_con1_90_0_, this_.uuid as uu
id2_90_0_, this_.name as name3_90_0_, this_.description as descript4_90_0_, this
_.schedulable_class as schedula5_90_0_, this_.repeat_interval as repeat_i6_90_0_
, this_.start_time as start_ti7_90_0_, this_.start_time_pattern as start_ti8_90_
0_, this_.last_execution_time as last_exe9_90_0_, this_.start_on_startup as star
t_o10_90_0_, this_.started as started11_90_0_, this_.created_by as created12_90_
0_, this_.changed_by as changed13_90_0_, this_.date_created as date_cr14_90_0_,
this_.date_changed as date_ch15_90_0_ from scheduler_task_config this_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,407| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,408| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,408| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,408| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,410| Av
erage time    : 170
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,410| Ro
w Count       : 1
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,410| QU
ERY: [CRITERIA] select this_.person_attribute_id as y0_ from person_attribute th
is_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,411| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,411| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,412| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,412| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,413| Av
erage time    : 47
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,414| Ro
w Count       : 0
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,414| QU
ERY: [CRITERIA] select this_.drug_id as y0_ from drug this_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,415| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,415| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,415| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,416| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,417| Av
erage time    : 14
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,417| Ro
w Count       : 0
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,421| QU
ERY: [CRITERIA] select this_.concept_name_id as concept_1_15_0_, this_.concept_i
d as concept_2_15_0_, this_.name as name3_15_0_, this_.locale as locale4_15_0_,
this_.date_created as date_cre5_15_0_, this_.creator as creator6_15_0_, this_.vo
ided as voided7_15_0_, this_.date_voided as date_voi8_15_0_, this_.void_reason a
s void_rea9_15_0_, this_.voided_by as voided_10_15_0_, this_.concept_name_type a
s concept11_15_0_, this_.locale_preferred as locale_12_15_0_, this_.uuid as uuid
13_15_0_, this_.changed_by as changed14_15_0_, this_.date_changed as date_ch15_1
5_0_ from concept_name this_ where this_.concept_name_id in (?, ?, ?, ?, ?, ?, ?
, ?, ?, ?)
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,422| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,422| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,423| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,424| Ex
ecution Count : 2
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,424| Av
erage time    : 27
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,425| Ro
w Count       : 20
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,425| QU
ERY: [CRITERIA] select count(*) as y0_ from person_name this_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,425| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,426| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,426| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,427| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,428| Av
erage time    : 2
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,428| Ro
w Count       : 1
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,428| QU
ERY: [CRITERIA] select this_.patient_identifier_id as y0_ from patient_identifie
r this_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,429| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,429| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,429| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,430| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,431| Av
erage time    : 56
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,431| Ro
w Count       : 0
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,431| QU
ERY: [CRITERIA] select count(*) as y0_ from drug this_
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,432| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,432| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,432| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,433| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,434| Av
erage time    : 98
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,434| Ro
w Count       : 1
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,435| QU
ERY: [CRITERIA] select this_.property as property1_43_0_, this_.property_value a
s property2_43_0_, this_.description as descript3_43_0_, this_.datatype as datat
ype4_43_0_, this_.datatype_config as datatype5_43_0_, this_.preferred_handler as
 preferre6_43_0_, this_.handler_config as handler_7_43_0_, this_.uuid as uuid8_4
3_0_, this_.changed_by as changed_9_43_0_, this_.date_changed as date_ch10_43_0_
 from global_property this_ where lower(this_.property)=?
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,437| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,437| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,437| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,438| Ex
ecution Count : 105
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,438| Av
erage time    : 1
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,439| Ro
w Count       : 0
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,439| QU
ERY: from Privilege p order by p.privilege
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,440| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,440| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,441| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,441| Ex
ecution Count : 1
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,442| Av
erage time    : 26
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,442| Ro
w Count       : 154
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,442| QU
ERY: from User u where u.uuid = :uuid
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,443| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,444| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,444| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,445| Ex
ecution Count : 7
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,445| Av
erage time    : 66
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,445| Ro
w Count       : 7
INFO - HibernateContextDAO.showUsageStatistics(414) |2019-10-25 15:08:17,446| QU
ERY: select distinct user from User as user inner join user.person.names as name
 inner join user.roles as role where user.uuid != :DAEMON_USER_UUID and user.ret
ired = false  and  role in (:roleList)
INFO - HibernateContextDAO.showUsageStatistics(416) |2019-10-25 15:08:17,447| Ca
che Hit Count : 0
INFO - HibernateContextDAO.showUsageStatistics(417) |2019-10-25 15:08:17,448| Ca
che Miss Count: 0
INFO - HibernateContextDAO.showUsageStatistics(418) |2019-10-25 15:08:17,448| Ca
che Put Count : 0
INFO - HibernateContextDAO.showUsageStatistics(419) |2019-10-25 15:08:17,448| Ex
ecution Count : 3
INFO - HibernateContextDAO.showUsageStatistics(420) |2019-10-25 15:08:17,449| Av
erage time    : 147
INFO - HibernateContextDAO.showUsageStatistics(421) |2019-10-25 15:08:17,449| Ro
w Count       : 3
[INFO] Stopped o.e.j.m.p.JettyWebAppContext@43e9089{/openmrs,file:///C:/Users/Cl
iff/Desktop/project/openmrs-core/webapp/src/main/webapp/,UNAVAILABLE}{file:///C:
/Users/Cliff/Desktop/project/openmrs-core/webapp/src/main/webapp/}
Terminate batch job (Y/N)? Y

C:\Users\Cliff\Desktop\project\openmrs-core\webapp>