Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.original_institution_id AS original_institution_id_2,
  t3.id AS id_4,
  t3.name AS name_5,
  t3.acronym AS acronym_6,
  t3.address AS address_7,
  t3.translation AS translation_8,
  t3.slug AS slug_9,
  t3.status AS status_10,
  t3.created_at AS created_at_11,
  t3.website AS website_12,
  t3.logo AS logo_13,
  t3.linked_in AS linked_in_14,
  t3.twitter AS twitter_15,
  t3.facebook AS facebook_16,
  t3.instagram AS instagram_17,
  t3.youtube AS youtube_18,
  t3.review AS review_19,
  t0.copy_institution_id AS copy_institution_id_20,
  t21.id AS id_22,
  t21.name AS name_23,
  t21.acronym AS acronym_24,
  t21.address AS address_25,
  t21.translation AS translation_26,
  t21.slug AS slug_27,
  t21.status AS status_28,
  t21.created_at AS created_at_29,
  t21.website AS website_30,
  t21.logo AS logo_31,
  t21.linked_in AS linked_in_32,
  t21.twitter AS twitter_33,
  t21.facebook AS facebook_34,
  t21.instagram AS instagram_35,
  t21.youtube AS youtube_36,
  t21.review AS review_37
FROM
  institution_copy t0
  LEFT JOIN institution t3 ON t0.original_institution_id = t3.id
  LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id
WHERE
  t0.copy_institution_id IN (?)

SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (187);

SELECT
  t0.id AS id_1,
  t0.original_institution_id AS original_institution_id_2,
  t3.id AS id_4,
  t3.name AS name_5,
  t3.acronym AS acronym_6,
  t3.address AS address_7,
  t3.translation AS translation_8,
  t3.slug AS slug_9,
  t3.status AS status_10,
  t3.created_at AS created_at_11,
  t3.website AS website_12,
  t3.logo AS logo_13,
  t3.linked_in AS linked_in_14,
  t3.twitter AS twitter_15,
  t3.facebook AS facebook_16,
  t3.instagram AS instagram_17,
  t3.youtube AS youtube_18,
  t3.review AS review_19,
  t0.copy_institution_id AS copy_institution_id_20,
  t21.id AS id_22,
  t21.name AS name_23,
  t21.acronym AS acronym_24,
  t21.address AS address_25,
  t21.translation AS translation_26,
  t21.slug AS slug_27,
  t21.status AS status_28,
  t21.created_at AS created_at_29,
  t21.website AS website_30,
  t21.logo AS logo_31,
  t21.linked_in AS linked_in_32,
  t21.twitter AS twitter_33,
  t21.facebook AS facebook_34,
  t21.instagram AS instagram_35,
  t21.youtube AS youtube_36,
  t21.review AS review_37
FROM
  institution_copy t0
  LEFT JOIN institution t3 ON t0.original_institution_id = t3.id
  LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id
WHERE
  t0.original_institution_id IN (?)

SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (1);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hide_description AS hide_description_3,
  t0.alt_text AS alt_text_4,
  t0.media_url AS media_url_5,
  t0.type AS type_6,
  t0.extension AS extension_7,
  t0.dimension AS dimension_8,
  t0.description AS description_9,
  t0.size AS size_10,
  t0.status AS status_11,
  t0.copyright AS copyright_12,
  t0.created_at AS created_at_13,
  t0.path AS path_14
FROM
  media t0
  INNER JOIN media_institution ON t0.id = media_institution.media_id
WHERE
  media_institution.institution_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = 1;

SELECT
  g0_.id AS id_0,
  g0_.continent AS continent_1,
  g0_.country AS country_2,
  g0_.region AS region_3,
  g0_.department AS department_4,
  g0_.city AS city_5,
  g0_.status AS status_6,
  g0_.created_at AS created_at_7,
  g0_.zip_code AS zip_code_8,
  g0_.address AS address_9,
  g0_.department_num AS department_num_10,
  i1_.id AS id_11,
  i1_.name AS name_12,
  i1_.acronym AS acronym_13,
  i1_.address AS address_14,
  i1_.translation AS translation_15,
  i1_.slug AS slug_16,
  i1_.status AS status_17,
  i1_.created_at AS created_at_18,
  i1_.website AS website_19,
  i1_.logo AS logo_20,
  i1_.linked_in AS linked_in_21,
  i1_.twitter AS twitter_22,
  i1_.facebook AS facebook_23,
  i1_.instagram AS instagram_24,
  i1_.youtube AS youtube_25,
  i1_.review AS review_26
FROM
  geolocation g0_
  INNER JOIN institution_geolocation i2_ ON g0_.id = i2_.geolocation_id
  INNER JOIN institution i1_ ON i1_.id = i2_.institution_id
WHERE
  g0_.status = 'a:1:{s:9:\"published\";i:1;}'

SELECT g0_.id AS id_0, g0_.continent AS continent_1, g0_.country AS country_2, g0_.region AS region_3, g0_.department AS department_4, g0_.city AS city_5, g0_.status AS status_6, g0_.created_at AS created_at_7, g0_.zip_code AS zip_code_8, g0_.address AS address_9, g0_.department_num AS department_num_10, i1_.id AS id_11, i1_.name AS name_12, i1_.acronym AS acronym_13, i1_.address AS address_14, i1_.translation AS translation_15, i1_.slug AS slug_16, i1_.status AS status_17, i1_.created_at AS created_at_18, i1_.website AS website_19, i1_.logo AS logo_20, i1_.linked_in AS linked_in_21, i1_.twitter AS twitter_22, i1_.facebook AS facebook_23, i1_.instagram AS instagram_24, i1_.youtube AS youtube_25, i1_.review AS review_26 FROM geolocation g0_ INNER JOIN institution_geolocation i2_ ON g0_.id = i2_.geolocation_id INNER JOIN institution i1_ ON i1_.id = i2_.institution_id WHERE g0_.status = 'a:1:{s:9:\"published\";i:1;}';

SELECT
  d0_.id AS id_0,
  d0_.domain AS domain_1,
  d0_.status AS status_2,
  d0_.created_at AS created_at_3,
  d0_.review AS review_4,
  d0_.slug AS slug_5,
  i1_.id AS id_6,
  i1_.name AS name_7,
  i1_.acronym AS acronym_8,
  i1_.address AS address_9,
  i1_.translation AS translation_10,
  i1_.slug AS slug_11,
  i1_.status AS status_12,
  i1_.created_at AS created_at_13,
  i1_.website AS website_14,
  i1_.logo AS logo_15,
  i1_.linked_in AS linked_in_16,
  i1_.twitter AS twitter_17,
  i1_.facebook AS facebook_18,
  i1_.instagram AS instagram_19,
  i1_.youtube AS youtube_20,
  i1_.review AS review_21,
  d0_.parent_id AS parent_id_22,
  d0_.author_id AS author_id_23
FROM
  domain d0_
  INNER JOIN institution_domain i2_ ON d0_.id = i2_.domain_id
  INNER JOIN institution i1_ ON i1_.id = i2_.institution_id
WHERE
  d0_.status = 'a:1:{s:9:\"published\";i:1;}'
  AND i1_.status = 'a:1:{s:9:\"published\";i:1;}'

SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, i1_.id AS id_6, i1_.name AS name_7, i1_.acronym AS acronym_8, i1_.address AS address_9, i1_.translation AS translation_10, i1_.slug AS slug_11, i1_.status AS status_12, i1_.created_at AS created_at_13, i1_.website AS website_14, i1_.logo AS logo_15, i1_.linked_in AS linked_in_16, i1_.twitter AS twitter_17, i1_.facebook AS facebook_18, i1_.instagram AS instagram_19, i1_.youtube AS youtube_20, i1_.review AS review_21, d0_.parent_id AS parent_id_22, d0_.author_id AS author_id_23 FROM domain d0_ INNER JOIN institution_domain i2_ ON d0_.id = i2_.domain_id INNER JOIN institution i1_ ON i1_.id = i2_.institution_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND i1_.status = 'a:1:{s:9:\"published\";i:1;}';

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.acronym AS acronym_2,
  i0_.address AS address_3,
  i0_.translation AS translation_4,
  i0_.slug AS slug_5,
  i0_.status AS status_6,
  i0_.created_at AS created_at_7,
  i0_.website AS website_8,
  i0_.logo AS logo_9,
  i0_.linked_in AS linked_in_10,
  i0_.twitter AS twitter_11,
  i0_.facebook AS facebook_12,
  i0_.instagram AS instagram_13,
  i0_.youtube AS youtube_14,
  i0_.review AS review_15
FROM
  institution i0_
WHERE
  i0_.status = 'a:1:{s:9:\"published\";i:1;}'
ORDER BY
  i0_.acronym ASC

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.acronym AS acronym_2, i0_.address AS address_3, i0_.translation AS translation_4, i0_.slug AS slug_5, i0_.status AS status_6, i0_.created_at AS created_at_7, i0_.website AS website_8, i0_.logo AS logo_9, i0_.linked_in AS linked_in_10, i0_.twitter AS twitter_11, i0_.facebook AS facebook_12, i0_.instagram AS instagram_13, i0_.youtube AS youtube_14, i0_.review AS review_15 FROM institution i0_ WHERE i0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY i0_.acronym ASC;

SELECT
  d0_.id AS id_0,
  d0_.discipline AS discipline_1,
  d0_.status AS status_2,
  d0_.created_at AS created_at_3,
  d0_.review AS review_4,
  d0_.slug AS slug_5,
  i1_.id AS id_6,
  i1_.name AS name_7,
  i1_.acronym AS acronym_8,
  i1_.address AS address_9,
  i1_.translation AS translation_10,
  i1_.slug AS slug_11,
  i1_.status AS status_12,
  i1_.created_at AS created_at_13,
  i1_.website AS website_14,
  i1_.logo AS logo_15,
  i1_.linked_in AS linked_in_16,
  i1_.twitter AS twitter_17,
  i1_.facebook AS facebook_18,
  i1_.instagram AS instagram_19,
  i1_.youtube AS youtube_20,
  i1_.review AS review_21,
  d0_.parent_id AS parent_id_22,
  d0_.author_id AS author_id_23
FROM
  discipline d0_
  INNER JOIN institution_discipline i2_ ON d0_.id = i2_.discipline_id
  INNER JOIN institution i1_ ON i1_.id = i2_.institution_id
WHERE
  d0_.status = 'a:1:{s:9:\"published\";i:1;}'
  AND i1_.status = 'a:1:{s:9:\"published\";i:1;}'

SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, i1_.id AS id_6, i1_.name AS name_7, i1_.acronym AS acronym_8, i1_.address AS address_9, i1_.translation AS translation_10, i1_.slug AS slug_11, i1_.status AS status_12, i1_.created_at AS created_at_13, i1_.website AS website_14, i1_.logo AS logo_15, i1_.linked_in AS linked_in_16, i1_.twitter AS twitter_17, i1_.facebook AS facebook_18, i1_.instagram AS instagram_19, i1_.youtube AS youtube_20, i1_.review AS review_21, d0_.parent_id AS parent_id_22, d0_.author_id AS author_id_23 FROM discipline d0_ INNER JOIN institution_discipline i2_ ON d0_.id = i2_.discipline_id INNER JOIN institution i1_ ON i1_.id = i2_.institution_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND i1_.status = 'a:1:{s:9:\"published\";i:1;}';