# Query_time: 4.267657  Lock_time: 0.001942 Rows_sent: 1  Rows_examined: 1524697

select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='diagnosis concept set' and (lower(source2_.name)='org.openmrs.module.emrapi' or lower(source2_.hl7_code)='org.openmrs.module.emrapi') order by concept3_.retired asc;


# Query_time: 2.001344  Lock_time: 0.002926 Rows_sent: 2  Rows_examined: 684427

select this_.concept_name_id as concept_1_34_1_, this_.concept_id as concept_2_34_1_, this_.name as name3_34_1_, this_.locale as locale4_34_1_, this_.date_created as date_cre5_34_1_, this_.creator as creator6_34_1_, this_.voided as voided7_34_1_, this_.date_voided as date_voi8_34_1_, this_.void_reason as void_rea9_34_1_, this_.voided_by as voided_10_34_1_, this_.concept_name_type as concept11_34_1_, this_.locale_preferred as locale_12_34_1_, this_.uuid as uuid13_34_1_, this_.changed_by as changed14_34_1_, this_.date_changed as date_ch15_34_1_, concept1_.concept_id as concept_1_25_0_, concept1_.uuid as uuid2_25_0_, concept1_.retired as retired3_25_0_, concept1_.date_created as date_cre4_25_0_, concept1_.version as version5_25_0_, concept1_.date_changed as date_cha6_25_0_, concept1_.is_set as is_set7_25_0_, concept1_.retire_reason as retire_r8_25_0_, concept1_.date_retired as date_ret9_25_0_, concept1_.retired_by as retired10_25_0_, concept1_.datatype_id as datatyp11_25_0_, concept1_.class_id as class_i12_25_0_, concept1_.changed_by as changed13_25_0_, concept1_.creator as creator14_25_0_, concept1_1_.hi_absolute as hi_absol2_37_0_, concept1_1_.hi_critical as hi_criti3_37_0_, concept1_1_.hi_normal as hi_norma4_37_0_, concept1_1_.low_absolute as low_abso5_37_0_, concept1_1_.low_critical as low_crit6_37_0_, concept1_1_.low_normal as low_norm7_37_0_, concept1_1_.units as units8_37_0_, concept1_1_.precise as precise9_37_0_, concept1_1_.display_precision as display10_37_0_, concept1_2_.handler as handler2_30_0_, case when concept1_1_.concept_id is not null then 1 when concept1_2_.concept_id is not null then 2 when concept1_.concept_id is not null then 0 end as clazz_0_ from concept_name this_ inner join concept concept1_ on this_.concept_id=concept1_.concept_id left outer join concept_numeric concept1_1_ on concept1_.concept_id=concept1_1_.concept_id left outer join concept_complex concept1_2_ on concept1_.concept_id=concept1_2_.concept_id where (this_.locale='en' or this_.locale like 'en%') and lower(this_.name) like 'bahmni diagnosis status' and this_.voided=0 and concept1_.retired=0;




# Query_time: 1.871977  Lock_time: 0.000189 Rows_sent: 1  Rows_examined: 1524697

select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='specimen_collection_date' and (lower(source2_.name)='org.openmrs.module.bacteriology' or lower(source2_.hl7_code)='org.openmrs.module.bacteriology') order by concept3_.retired asc;


# Query_time: 1.830748  Lock_time: 0.000296 Rows_sent: 1  Rows_examined: 1524698

select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='diagnosis certainty' and (lower(source2_.name)='org.openmrs.module.emrapi' or lower(source2_.hl7_code)='org.openmrs.module.emrapi') order by concept3_.retired asc;


# Query_time: 1.863085  Lock_time: 0.000210 Rows_sent: 1  Rows_examined: 1524698

select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='non-coded diagnosis' and (lower(source2_.name)='org.openmrs.module.emrapi' or lower(source2_.hl7_code)='org.openmrs.module.emrapi') order by concept3_.retired asc;
# Time: 2021-03-26T07:30:33.001686Z