Symfony Profiler

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 = 9863 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 = 9863 AND i0_.activated = 1 ORDER BY i0_.inst_name 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 = ?
  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 = 9863 AND i0_.status = 1 ORDER BY i0_.sname ASC;

SELECT
  t0.country AS country_1,
  t0.postcode_pos AS postcode_pos_2,
  t0.postcode_spacer AS postcode_spacer_3,
  t0.country_code AS country_code_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.unesco_member AS unesco_member_7,
  t0.ioc_member AS ioc_member_8,
  t0.is_executive AS is_executive_9,
  t0.id_country AS id_country_10
FROM
  countries t0
ORDER BY
  t0.country ASC

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.unesco_member AS unesco_member_7, t0.ioc_member AS ioc_member_8, t0.is_executive AS is_executive_9, t0.id_country AS id_country_10 FROM countries t0 ORDER BY t0.country 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,
  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
    OR i0_.created_by = ?
  )

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 = 9863 AND (i0_.activated = 1 OR i0_.created_by = 0);

SELECT
  s0_.id_searegion AS id_searegion_0,
  s0_.name AS name_1
FROM
  searegions s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id_searegion AS id_searegion_0, s0_.name AS name_1 FROM searegions s0_ ORDER BY s0_.name ASC;

SELECT
  s0_.id_searegion AS id_searegion_0,
  s0_.name AS name_1
FROM
  searegions s0_
WHERE
  s0_.id_searegion IN (?)

SELECT s0_.id_searegion AS id_searegion_0, s0_.name AS name_1 FROM searegions s0_ WHERE s0_.id_searegion IN ('');

SELECT
  t0.insttype_name AS insttype_name_1,
  t0.id_insttype AS id_insttype_2
FROM
  insttypes t0

SELECT t0.insttype_name AS insttype_name_1, t0.id_insttype AS id_insttype_2 FROM insttypes t0;