Symfony Profiler

SELECT 
  t0.parent_id AS parent_id_1, 
  t0.inst_type_id AS inst_type_id_2, 
  t0.inst_name AS inst_name_3, 
  t0.inst_name_eng AS inst_name_eng_4, 
  t0.inst_address AS inst_address_5, 
  t0.addr_2 AS addr_2_6, 
  t0.city AS city_7, 
  t0.state AS state_8, 
  t0.postcode AS postcode_9, 
  t0.country_code AS country_code_10, 
  t0.acronym AS acronym_11, 
  t0.inst_tel AS inst_tel_12, 
  t0.inst_fax AS inst_fax_13, 
  t0.inst_email AS inst_email_14, 
  t0.inst_url AS inst_url_15, 
  t0.inst_logo AS inst_logo_16, 
  t0.edmo_code AS edmo_code_17, 
  t0.activities AS activities_18, 
  t0.inst_region AS inst_region_19, 
  t0.popularity AS popularity_20, 
  t0.activated AS activated_21, 
  t0.f_date_entered AS f_date_entered_22, 
  t0.l_date_updated AS l_date_updated_23, 
  t0.created_by AS created_by_24, 
  t0.last_edit_by AS last_edit_by_25, 
  t0.id_inst AS id_inst_26 
FROM 
  institutions t0 
WHERE 
  t0.id_inst = ? 
LIMIT 
  1

SELECT t0.parent_id AS parent_id_1, t0.inst_type_id AS inst_type_id_2, t0.inst_name AS inst_name_3, t0.inst_name_eng AS inst_name_eng_4, t0.inst_address AS inst_address_5, t0.addr_2 AS addr_2_6, t0.city AS city_7, t0.state AS state_8, t0.postcode AS postcode_9, t0.country_code AS country_code_10, t0.acronym AS acronym_11, t0.inst_tel AS inst_tel_12, t0.inst_fax AS inst_fax_13, t0.inst_email AS inst_email_14, t0.inst_url AS inst_url_15, t0.inst_logo AS inst_logo_16, t0.edmo_code AS edmo_code_17, t0.activities AS activities_18, t0.inst_region AS inst_region_19, t0.popularity AS popularity_20, t0.activated AS activated_21, t0.f_date_entered AS f_date_entered_22, t0.l_date_updated AS l_date_updated_23, t0.created_by AS created_by_24, t0.last_edit_by AS last_edit_by_25, t0.id_inst AS id_inst_26 FROM institutions t0 WHERE t0.id_inst = '15932' LIMIT 1;

SELECT 
  i0_.id_inst AS id_inst_0, 
  i0_.inst_type_id AS inst_type_id_1, 
  i0_.inst_name AS inst_name_2, 
  i0_.inst_name_eng AS inst_name_eng_3, 
  i0_.inst_address AS inst_address_4, 
  i0_.addr_2 AS addr_2_5, 
  i0_.city AS city_6, 
  i0_.state AS state_7, 
  i0_.postcode AS postcode_8, 
  i0_.country_code AS country_code_9, 
  i0_.acronym AS acronym_10, 
  i0_.inst_logo AS inst_logo_11, 
  i0_.inst_tel AS inst_tel_12, 
  i0_.inst_fax AS inst_fax_13, 
  i0_.inst_email AS inst_email_14, 
  i0_.inst_url AS inst_url_15, 
  i0_.edmo_code AS edmo_code_16, 
  i0_.inst_region AS inst_region_17, 
  i0_.activities AS activities_18, 
  i0_.popularity AS popularity_19, 
  i0_.activated AS activated_20, 
  i0_.f_date_entered AS f_date_entered_21, 
  i0_.l_date_updated AS l_date_updated_22, 
  i0_.created_by AS created_by_23, 
  i0_.last_edit_by AS last_edit_by_24, 
  i1_.insttype_name AS insttype_name_25, 
  c2_.country AS country_26, 
  c2_.country_code AS country_code_27, 
  i0_.parent_id AS parent_id_28, 
  i3_.inst_name AS inst_name_29, 
  i3_.inst_name_eng AS inst_name_eng_30, 
  i3_.acronym AS acronym_31, 
  i3_.inst_logo AS inst_logo_32 
FROM 
  institutions i0_ 
  LEFT JOIN insttypes i1_ ON (
    i1_.id_insttype = i0_.inst_type_id
  ) 
  LEFT JOIN countries c2_ ON (
    c2_.id_country = i0_.country_code
  ) 
  LEFT JOIN institutions i3_ ON (
    i3_.id_inst = i0_.parent_id 
    AND i3_.activated = 1
  ) 
WHERE 
  i0_.id_inst = ? 
  AND i0_.activated = 1

SELECT i0_.id_inst AS id_inst_0, i0_.inst_type_id AS inst_type_id_1, i0_.inst_name AS inst_name_2, i0_.inst_name_eng AS inst_name_eng_3, i0_.inst_address AS inst_address_4, i0_.addr_2 AS addr_2_5, i0_.city AS city_6, i0_.state AS state_7, i0_.postcode AS postcode_8, i0_.country_code AS country_code_9, i0_.acronym AS acronym_10, i0_.inst_logo AS inst_logo_11, i0_.inst_tel AS inst_tel_12, i0_.inst_fax AS inst_fax_13, i0_.inst_email AS inst_email_14, i0_.inst_url AS inst_url_15, i0_.edmo_code AS edmo_code_16, i0_.inst_region AS inst_region_17, i0_.activities AS activities_18, i0_.popularity AS popularity_19, i0_.activated AS activated_20, i0_.f_date_entered AS f_date_entered_21, i0_.l_date_updated AS l_date_updated_22, i0_.created_by AS created_by_23, i0_.last_edit_by AS last_edit_by_24, i1_.insttype_name AS insttype_name_25, c2_.country AS country_26, c2_.country_code AS country_code_27, i0_.parent_id AS parent_id_28, i3_.inst_name AS inst_name_29, i3_.inst_name_eng AS inst_name_eng_30, i3_.acronym AS acronym_31, i3_.inst_logo AS inst_logo_32 FROM institutions i0_ LEFT JOIN insttypes i1_ ON (i1_.id_insttype = i0_.inst_type_id) LEFT JOIN countries c2_ ON (c2_.id_country = i0_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i0_.parent_id AND i3_.activated = 1) WHERE i0_.id_inst = '15932' AND i0_.activated = 1;

SELECT 
  i0_.id_ind AS id_ind_0, 
  i0_.fname AS fname_1, 
  i0_.mname AS mname_2, 
  i0_.sname AS sname_3, 
  i0_.jobtitle AS jobtitle_4, 
  i0_.deceased AS deceased_5, 
  i0_.retired AS retired_6, 
  i0_.quality_checked AS quality_checked_7 
FROM 
  indiv i0_ 
  LEFT JOIN indiv_institution i1_ ON (i1_.id_ind = i0_.id_ind) 
  LEFT JOIN institutions i2_ ON (i2_.id_inst = i1_.id_inst) 
WHERE 
  i2_.id_inst = ? 
  AND i0_.status = 1 
ORDER BY 
  i0_.sname ASC

SELECT i0_.id_ind AS id_ind_0, i0_.fname AS fname_1, i0_.mname AS mname_2, i0_.sname AS sname_3, i0_.jobtitle AS jobtitle_4, i0_.deceased AS deceased_5, i0_.retired AS retired_6, i0_.quality_checked AS quality_checked_7 FROM indiv i0_ LEFT JOIN indiv_institution i1_ ON (i1_.id_ind = i0_.id_ind) LEFT JOIN institutions i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_inst = '15932' AND i0_.status = 1 ORDER BY i0_.sname ASC;

SELECT 
  i0_.id_ind AS id_ind_0, 
  i0_.fname AS fname_1, 
  i0_.mname AS mname_2, 
  i0_.sname AS sname_3, 
  i0_.jobtitle AS jobtitle_4, 
  i0_.deceased AS deceased_5, 
  i0_.retired AS retired_6, 
  i0_.quality_checked AS quality_checked_7, 
  i1_.id_inst AS id_inst_8, 
  i1_.inst_name AS inst_name_9 
FROM 
  indiv i0_ 
  LEFT JOIN indiv_institution i2_ ON (i2_.id_ind = i0_.id_ind) 
  LEFT JOIN institutions i1_ ON (i1_.id_inst = i2_.id_inst) 
WHERE 
  i1_.parent_id = ? 
  AND i0_.status = 1 
  AND i1_.activated = 1 
ORDER BY 
  i0_.sname ASC

SELECT i0_.id_ind AS id_ind_0, i0_.fname AS fname_1, i0_.mname AS mname_2, i0_.sname AS sname_3, i0_.jobtitle AS jobtitle_4, i0_.deceased AS deceased_5, i0_.retired AS retired_6, i0_.quality_checked AS quality_checked_7, i1_.id_inst AS id_inst_8, i1_.inst_name AS inst_name_9 FROM indiv i0_ LEFT JOIN indiv_institution i2_ ON (i2_.id_ind = i0_.id_ind) LEFT JOIN institutions i1_ ON (i1_.id_inst = i2_.id_inst) WHERE i1_.parent_id = '15932' AND i0_.status = 1 AND i1_.activated = 1 ORDER BY i0_.sname ASC;

SELECT 
  i0_.id_inst AS id_inst_0, 
  i0_.inst_type_id AS inst_type_id_1, 
  i0_.inst_name AS inst_name_2, 
  i0_.inst_name_eng AS inst_name_eng_3, 
  i0_.inst_address AS inst_address_4, 
  i0_.addr_2 AS addr_2_5, 
  i0_.city AS city_6, 
  i0_.state AS state_7, 
  i0_.postcode AS postcode_8, 
  i0_.country_code AS country_code_9, 
  i0_.acronym AS acronym_10, 
  i0_.inst_logo AS inst_logo_11, 
  i0_.inst_tel AS inst_tel_12, 
  i0_.inst_fax AS inst_fax_13, 
  i0_.inst_email AS inst_email_14, 
  i0_.inst_url AS inst_url_15, 
  i0_.edmo_code AS edmo_code_16, 
  i0_.inst_region AS inst_region_17, 
  i0_.activities AS activities_18, 
  i0_.popularity AS popularity_19, 
  i0_.activated AS activated_20, 
  i0_.f_date_entered AS f_date_entered_21, 
  i0_.l_date_updated AS l_date_updated_22, 
  i0_.created_by AS created_by_23, 
  i0_.last_edit_by AS last_edit_by_24, 
  i1_.insttype_name AS insttype_name_25, 
  c2_.country AS country_26, 
  c2_.country_code AS country_code_27 
FROM 
  institutions i0_ 
  LEFT JOIN insttypes i1_ ON (
    i1_.id_insttype = i0_.inst_type_id
  ) 
  LEFT JOIN countries c2_ ON (
    c2_.id_country = i0_.country_code
  ) 
WHERE 
  i0_.parent_id = ? 
  AND i0_.activated = 1 
ORDER BY 
  i0_.inst_name ASC

SELECT i0_.id_inst AS id_inst_0, i0_.inst_type_id AS inst_type_id_1, i0_.inst_name AS inst_name_2, i0_.inst_name_eng AS inst_name_eng_3, i0_.inst_address AS inst_address_4, i0_.addr_2 AS addr_2_5, i0_.city AS city_6, i0_.state AS state_7, i0_.postcode AS postcode_8, i0_.country_code AS country_code_9, i0_.acronym AS acronym_10, i0_.inst_logo AS inst_logo_11, i0_.inst_tel AS inst_tel_12, i0_.inst_fax AS inst_fax_13, i0_.inst_email AS inst_email_14, i0_.inst_url AS inst_url_15, i0_.edmo_code AS edmo_code_16, i0_.inst_region AS inst_region_17, i0_.activities AS activities_18, i0_.popularity AS popularity_19, i0_.activated AS activated_20, i0_.f_date_entered AS f_date_entered_21, i0_.l_date_updated AS l_date_updated_22, i0_.created_by AS created_by_23, i0_.last_edit_by AS last_edit_by_24, i1_.insttype_name AS insttype_name_25, c2_.country AS country_26, c2_.country_code AS country_code_27 FROM institutions i0_ LEFT JOIN insttypes i1_ ON (i1_.id_insttype = i0_.inst_type_id) LEFT JOIN countries c2_ ON (c2_.id_country = i0_.country_code) WHERE i0_.parent_id = '15932' AND i0_.activated = 1 ORDER BY i0_.inst_name ASC;

SELECT 
  r0_.id_region AS id_region_0, 
  r0_.name AS name_1 
FROM 
  regions r0_ 
WHERE 
  r0_.id_region IN (?)

SELECT r0_.id_region AS id_region_0, r0_.name AS name_1 FROM regions r0_ WHERE r0_.id_region IN ('');

SELECT 
  r0_.id_region AS id_region_0, 
  r0_.name AS name_1 
FROM 
  regions r0_ 
ORDER BY 
  r0_.name ASC

SELECT r0_.id_region AS id_region_0, r0_.name AS name_1 FROM regions r0_ ORDER BY r0_.name ASC;

SELECT 
  t0.id_ind AS id_ind_1, 
  t0.title AS title_2, 
  t0.fname AS fname_3, 
  t0.mname AS mname_4, 
  t0.sname AS sname_5, 
  t0.identifier AS identifier_6, 
  t0.reg_type AS reg_type_7, 
  t0.use_inst_addr AS use_inst_addr_8, 
  t0.private_address AS private_address_9, 
  t0.addr_1 AS addr_1_10, 
  t0.addr_2 AS addr_2_11, 
  t0.city AS city_12, 
  t0.state AS state_13, 
  t0.postcode AS postcode_14, 
  t0.country_code AS country_code_15, 
  t0.id_nationality AS id_nationality_16, 
  t0.gender AS gender_17, 
  t0.tel AS tel_18, 
  t0.fax AS fax_19, 
  t0.email1 AS email1_20, 
  t0.email2 AS email2_21, 
  t0.email3 AS email3_22, 
  t0.emailtouse AS emailtouse_23, 
  t0.url1 AS url1_24, 
  t0.url1Valid AS url1Valid_25, 
  t0.url2 AS url2_26, 
  t0.url2Valid AS url2Valid_27, 
  t0.url3 AS url3_28, 
  t0.url3Valid AS url3Valid_29, 
  t0.urlsChecked AS urlsChecked_30, 
  t0.linkedin AS linkedin_31, 
  t0.facebook AS facebook_32, 
  t0.twitter AS twitter_33, 
  t0.flickr AS flickr_34, 
  t0.other AS other_35, 
  t0.degree AS degree_36, 
  t0.activeng AS activeng_37, 
  t0.activother AS activother_38, 
  t0.jobtitle AS jobtitle_39, 
  t0.dept AS dept_40, 
  t0.studyregion AS studyregion_41, 
  t0.languages AS languages_42, 
  t0.skills AS skills_43, 
  t0.comments AS comments_44, 
  t0.do_not_invite AS do_not_invite_45, 
  t0.do_no_invite_by AS do_no_invite_by_46, 
  t0.do_no_invite_on AS do_no_invite_on_47, 
  t0.admin_comments AS admin_comments_48, 
  t0.id_imagefile AS id_imagefile_49, 
  t0.id_imagefile_full AS id_imagefile_full_50, 
  t0.receive_mail AS receive_mail_51, 
  t0.member_alert AS member_alert_52, 
  t0.cit_alert AS cit_alert_53, 
  t0.f_date_ent AS f_date_ent_54, 
  t0.l_date_upd AS l_date_upd_55, 
  t0.created_by AS created_by_56, 
  t0.last_edit_by AS last_edit_by_57, 
  t0.quality_checked_by AS quality_checked_by_58, 
  t0.quality_checked_date AS quality_checked_date_59, 
  t0.quality_checked AS quality_checked_60, 
  t0.is_global AS is_global_61, 
  t0.status AS status_62, 
  t0.statusLastChanged AS statusLastChanged_63, 
  t0.deceased AS deceased_64, 
  t0.deceased_date AS deceased_date_65, 
  t0.retired AS retired_66, 
  t0.retired_date AS retired_date_67, 
  t0.id AS id_68 
FROM 
  indiv t0 
WHERE 
  t0.id_ind = ? 
LIMIT 
  1

SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = 17477 LIMIT 1;

SELECT 
  t0.id_ind AS id_ind_1, 
  t0.title AS title_2, 
  t0.fname AS fname_3, 
  t0.mname AS mname_4, 
  t0.sname AS sname_5, 
  t0.identifier AS identifier_6, 
  t0.reg_type AS reg_type_7, 
  t0.use_inst_addr AS use_inst_addr_8, 
  t0.private_address AS private_address_9, 
  t0.addr_1 AS addr_1_10, 
  t0.addr_2 AS addr_2_11, 
  t0.city AS city_12, 
  t0.state AS state_13, 
  t0.postcode AS postcode_14, 
  t0.country_code AS country_code_15, 
  t0.id_nationality AS id_nationality_16, 
  t0.gender AS gender_17, 
  t0.tel AS tel_18, 
  t0.fax AS fax_19, 
  t0.email1 AS email1_20, 
  t0.email2 AS email2_21, 
  t0.email3 AS email3_22, 
  t0.emailtouse AS emailtouse_23, 
  t0.url1 AS url1_24, 
  t0.url1Valid AS url1Valid_25, 
  t0.url2 AS url2_26, 
  t0.url2Valid AS url2Valid_27, 
  t0.url3 AS url3_28, 
  t0.url3Valid AS url3Valid_29, 
  t0.urlsChecked AS urlsChecked_30, 
  t0.linkedin AS linkedin_31, 
  t0.facebook AS facebook_32, 
  t0.twitter AS twitter_33, 
  t0.flickr AS flickr_34, 
  t0.other AS other_35, 
  t0.degree AS degree_36, 
  t0.activeng AS activeng_37, 
  t0.activother AS activother_38, 
  t0.jobtitle AS jobtitle_39, 
  t0.dept AS dept_40, 
  t0.studyregion AS studyregion_41, 
  t0.languages AS languages_42, 
  t0.skills AS skills_43, 
  t0.comments AS comments_44, 
  t0.do_not_invite AS do_not_invite_45, 
  t0.do_no_invite_by AS do_no_invite_by_46, 
  t0.do_no_invite_on AS do_no_invite_on_47, 
  t0.admin_comments AS admin_comments_48, 
  t0.id_imagefile AS id_imagefile_49, 
  t0.id_imagefile_full AS id_imagefile_full_50, 
  t0.receive_mail AS receive_mail_51, 
  t0.member_alert AS member_alert_52, 
  t0.cit_alert AS cit_alert_53, 
  t0.f_date_ent AS f_date_ent_54, 
  t0.l_date_upd AS l_date_upd_55, 
  t0.created_by AS created_by_56, 
  t0.last_edit_by AS last_edit_by_57, 
  t0.quality_checked_by AS quality_checked_by_58, 
  t0.quality_checked_date AS quality_checked_date_59, 
  t0.quality_checked AS quality_checked_60, 
  t0.is_global AS is_global_61, 
  t0.status AS status_62, 
  t0.statusLastChanged AS statusLastChanged_63, 
  t0.deceased AS deceased_64, 
  t0.deceased_date AS deceased_date_65, 
  t0.retired AS retired_66, 
  t0.retired_date AS retired_date_67, 
  t0.id AS id_68 
FROM 
  indiv t0 
WHERE 
  t0.id_ind = ? 
LIMIT 
  1

SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = 35711 LIMIT 1;