Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.page_key AS page_key_1,
  c0_.is_active AS is_active_2,
  c1_.id AS id_3,
  c1_.position AS position_4,
  c1_.is_active AS is_active_5,
  c1_.texts AS texts_6,
  c1_.image_key AS image_key_7,
  c1_.video_url AS video_url_8,
  c1_.video_thumb_key AS video_thumb_key_9,
  c1_.layout AS layout_10,
  c1_.variant AS variant_11,
  c1_.source AS source_12,
  c1_.interval_seconds AS interval_seconds_13,
  c1_.image_position AS image_position_14,
  c1_.cta_link_destination AS cta_link_destination_15,
  c1_.cta_link_route_name AS cta_link_route_name_16,
  c1_.cta_link_external_url AS cta_link_external_url_17,
  c1_.cta_link_fragment AS cta_link_fragment_18,
  c1_.type AS type_19,
  c1_.page_content_id AS page_content_id_20
FROM
  content_page_contents c0_
  LEFT JOIN content_blocks c1_ ON c0_.id = c1_.page_content_id
  AND c1_.type IN (
    'hero', 'text', 'image_strip', 'cards',
    'banner', 'carousel', 'logo_row',
    'newsletter', 'questionnaires',
    'contact_banner', 'instructors_grid',
    'static_programs'
  )
WHERE
  c0_.page_key = ?
  AND c0_.is_active = 1
ORDER BY
  c1_.position ASC

SELECT c0_.id AS id_0, c0_.page_key AS page_key_1, c0_.is_active AS is_active_2, c1_.id AS id_3, c1_.position AS position_4, c1_.is_active AS is_active_5, c1_.texts AS texts_6, c1_.image_key AS image_key_7, c1_.video_url AS video_url_8, c1_.video_thumb_key AS video_thumb_key_9, c1_.layout AS layout_10, c1_.variant AS variant_11, c1_.source AS source_12, c1_.interval_seconds AS interval_seconds_13, c1_.image_position AS image_position_14, c1_.cta_link_destination AS cta_link_destination_15, c1_.cta_link_route_name AS cta_link_route_name_16, c1_.cta_link_external_url AS cta_link_external_url_17, c1_.cta_link_fragment AS cta_link_fragment_18, c1_.type AS type_19, c1_.page_content_id AS page_content_id_20 FROM content_page_contents c0_ LEFT JOIN content_blocks c1_ ON c0_.id = c1_.page_content_id AND c1_.type IN ('hero', 'text', 'image_strip', 'cards', 'banner', 'carousel', 'logo_row', 'newsletter', 'questionnaires', 'contact_banner', 'instructors_grid', 'static_programs') WHERE c0_.page_key = 'about_us' AND c0_.is_active = 1 ORDER BY c1_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.since_year AS since_year_1,
  c0_.image_key AS image_key_2,
  c0_.is_active AS is_active_3,
  t1_.id AS id_4,
  t1_.name AS name_5,
  t1_.logo_key AS logo_key_6,
  t1_.city AS city_7,
  t1_.address AS address_8,
  t1_.maps_url AS maps_url_9,
  t1_.photo_key AS photo_key_10,
  c2_.id AS id_11,
  c2_.locale AS locale_12,
  c2_.title AS title_13,
  c2_.description AS description_14,
  c3_.id AS id_15,
  c3_.role AS role_16,
  c3_.position AS position_17,
  t4_.id AS id_18,
  t4_.name AS name_19,
  t4_.photo_key AS photo_key_20,
  t4_.cv_url AS cv_url_21,
  t4_.linkedin_url AS linkedin_url_22,
  t4_.kind AS kind_23,
  t4_.detail_photo_key AS detail_photo_key_24,
  c0_.institution_id AS institution_id_25,
  c2_.chair_id AS chair_id_26,
  c3_.chair_id AS chair_id_27,
  c3_.instructor_id AS instructor_id_28,
  t4_.profession_id AS profession_id_29
FROM
  content_chairs c0_
  LEFT JOIN training_institutions t1_ ON c0_.institution_id = t1_.id
  LEFT JOIN content_chair_translations c2_ ON c0_.id = c2_.chair_id
  LEFT JOIN content_chair_members c3_ ON c0_.id = c3_.chair_id
  LEFT JOIN training_instructors t4_ ON c3_.instructor_id = t4_.id
WHERE
  c0_.is_active = 1
ORDER BY
  c0_.since_year ASC,
  c3_.position ASC

SELECT c0_.id AS id_0, c0_.since_year AS since_year_1, c0_.image_key AS image_key_2, c0_.is_active AS is_active_3, t1_.id AS id_4, t1_.name AS name_5, t1_.logo_key AS logo_key_6, t1_.city AS city_7, t1_.address AS address_8, t1_.maps_url AS maps_url_9, t1_.photo_key AS photo_key_10, c2_.id AS id_11, c2_.locale AS locale_12, c2_.title AS title_13, c2_.description AS description_14, c3_.id AS id_15, c3_.role AS role_16, c3_.position AS position_17, t4_.id AS id_18, t4_.name AS name_19, t4_.photo_key AS photo_key_20, t4_.cv_url AS cv_url_21, t4_.linkedin_url AS linkedin_url_22, t4_.kind AS kind_23, t4_.detail_photo_key AS detail_photo_key_24, c0_.institution_id AS institution_id_25, c2_.chair_id AS chair_id_26, c3_.chair_id AS chair_id_27, c3_.instructor_id AS instructor_id_28, t4_.profession_id AS profession_id_29 FROM content_chairs c0_ LEFT JOIN training_institutions t1_ ON c0_.institution_id = t1_.id LEFT JOIN content_chair_translations c2_ ON c0_.id = c2_.chair_id LEFT JOIN content_chair_members c3_ ON c0_.id = c3_.chair_id LEFT JOIN training_instructors t4_ ON c3_.instructor_id = t4_.id WHERE c0_.is_active = 1 ORDER BY c0_.since_year ASC, c3_.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.block_id AS block_id_3,
  t0.instructor_id AS instructor_id_4
FROM
  content_block_instructors t0
WHERE
  t0.block_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.block_id AS block_id_3, t0.instructor_id AS instructor_id_4 FROM content_block_instructors t0 WHERE t0.block_id = 0x01A0FA48854070008F2D7FF6FBE5DE2A ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1
FROM
  shared_professions t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM shared_professions t0 WHERE t0.id = 0x01A0FA487FE9767CA222A26AD6B3BD7B;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.profession_id AS profession_id_4
FROM
  shared_profession_translations t0
WHERE
  t0.profession_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.profession_id AS profession_id_4 FROM shared_profession_translations t0 WHERE t0.profession_id = 0x01A0FA487FE9767CA222A26AD6B3BD7B;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.bio AS bio_3,
  t0.curriculum AS curriculum_4,
  t0.instructor_id AS instructor_id_5
FROM
  training_instructor_translations t0
WHERE
  t0.instructor_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.bio AS bio_3, t0.curriculum AS curriculum_4, t0.instructor_id AS instructor_id_5 FROM training_instructor_translations t0 WHERE t0.instructor_id = 0x01A0FA48833E767C813997A0A3EE0475;

SELECT
  t0.id AS id_1
FROM
  shared_professions t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM shared_professions t0 WHERE t0.id = 0x01A0FA488005720AB7C2AB84BFDED457;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.profession_id AS profession_id_4
FROM
  shared_profession_translations t0
WHERE
  t0.profession_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.profession_id AS profession_id_4 FROM shared_profession_translations t0 WHERE t0.profession_id = 0x01A0FA488005720AB7C2AB84BFDED457;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.bio AS bio_3,
  t0.curriculum AS curriculum_4,
  t0.instructor_id AS instructor_id_5
FROM
  training_instructor_translations t0
WHERE
  t0.instructor_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.bio AS bio_3, t0.curriculum AS curriculum_4, t0.instructor_id AS instructor_id_5 FROM training_instructor_translations t0 WHERE t0.instructor_id = 0x01A0FA4883417EBCA79D7BDA33BBBF4F;

SELECT
  t0.id AS id_1
FROM
  shared_professions t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM shared_professions t0 WHERE t0.id = 0x01A0FA487FFB7236AB2891E94DA8034F;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.profession_id AS profession_id_4
FROM
  shared_profession_translations t0
WHERE
  t0.profession_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.profession_id AS profession_id_4 FROM shared_profession_translations t0 WHERE t0.profession_id = 0x01A0FA487FFB7236AB2891E94DA8034F;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.bio AS bio_3,
  t0.curriculum AS curriculum_4,
  t0.instructor_id AS instructor_id_5
FROM
  training_instructor_translations t0
WHERE
  t0.instructor_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.bio AS bio_3, t0.curriculum AS curriculum_4, t0.instructor_id AS instructor_id_5 FROM training_instructor_translations t0 WHERE t0.instructor_id = 0x01A0FA48834575B1A9C98B607EA9623E;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.bio AS bio_3,
  t0.curriculum AS curriculum_4,
  t0.instructor_id AS instructor_id_5
FROM
  training_instructor_translations t0
WHERE
  t0.instructor_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.bio AS bio_3, t0.curriculum AS curriculum_4, t0.instructor_id AS instructor_id_5 FROM training_instructor_translations t0 WHERE t0.instructor_id = 0x01A0FA4883487E9DB59BFA1627881F50;

SELECT
  t0.id AS id_1
FROM
  shared_professions t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM shared_professions t0 WHERE t0.id = 0x01A0FA48800278B080F2C9D2E82307AF;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.profession_id AS profession_id_4
FROM
  shared_profession_translations t0
WHERE
  t0.profession_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.profession_id AS profession_id_4 FROM shared_profession_translations t0 WHERE t0.profession_id = 0x01A0FA48800278B080F2C9D2E82307AF;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.bio AS bio_3,
  t0.curriculum AS curriculum_4,
  t0.instructor_id AS instructor_id_5
FROM
  training_instructor_translations t0
WHERE
  t0.instructor_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.bio AS bio_3, t0.curriculum AS curriculum_4, t0.instructor_id AS instructor_id_5 FROM training_instructor_translations t0 WHERE t0.instructor_id = 0x01A0FA48834C783593FFD968F690FC95;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.image_key AS image_key_4,
  t0.link_destination AS link_destination_5,
  t0.link_route_name AS link_route_name_6,
  t0.link_external_url AS link_external_url_7,
  t0.link_fragment AS link_fragment_8,
  t0.block_id AS block_id_9
FROM
  content_logo_items t0
WHERE
  t0.block_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.image_key AS image_key_4, t0.link_destination AS link_destination_5, t0.link_route_name AS link_route_name_6, t0.link_external_url AS link_external_url_7, t0.link_fragment AS link_fragment_8, t0.block_id AS block_id_9 FROM content_logo_items t0 WHERE t0.block_id = 0x01A0FA4885417299B81CED37D4221465 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.texts AS texts_2,
  t0.contact_email AS contact_email_3,
  t0.contact_phone AS contact_phone_4
FROM
  content_footer_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.texts AS texts_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4 FROM content_footer_settings t0 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.texts AS texts_1,
  c0_.position AS position_2,
  c1_.id AS id_3,
  c1_.texts AS texts_4,
  c1_.position AS position_5,
  c1_.destination AS destination_6,
  c1_.route_name AS route_name_7,
  c1_.external_url AS external_url_8,
  c1_.fragment AS fragment_9,
  c0_.footer_id AS footer_id_10,
  c1_.column_id AS column_id_11
FROM
  content_footer_columns c0_
  LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id
ORDER BY
  c0_.position ASC,
  c1_.position ASC

SELECT c0_.id AS id_0, c0_.texts AS texts_1, c0_.position AS position_2, c1_.id AS id_3, c1_.texts AS texts_4, c1_.position AS position_5, c1_.destination AS destination_6, c1_.route_name AS route_name_7, c1_.external_url AS external_url_8, c1_.fragment AS fragment_9, c0_.footer_id AS footer_id_10, c1_.column_id AS column_id_11 FROM content_footer_columns c0_ LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id ORDER BY c0_.position ASC, c1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.icon_key AS icon_key_2,
  t0.url AS url_3,
  t0.label AS label_4,
  t0.position AS position_5,
  t0.footer_id AS footer_id_6
FROM
  content_footer_social_links t0
WHERE
  t0.footer_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.icon_key AS icon_key_2, t0.url AS url_3, t0.label AS label_4, t0.position AS position_5, t0.footer_id AS footer_id_6 FROM content_footer_social_links t0 WHERE t0.footer_id = 0x01A0FA48859677E0B601C7073FA368E8 ORDER BY t0.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.document_key AS document_key_1,
  c0_.is_active AS is_active_2,
  c0_.texts AS texts_3
FROM
  content_legal_documents c0_
WHERE
  c0_.document_key = ?
  AND c0_.is_active = 1

SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = 'legal_notice' AND c0_.is_active = 1;

SELECT
  c0_.id AS id_0,
  c0_.document_key AS document_key_1,
  c0_.is_active AS is_active_2,
  c0_.texts AS texts_3
FROM
  content_legal_documents c0_
WHERE
  c0_.document_key = ?
  AND c0_.is_active = 1

SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = 'privacy_policy' AND c0_.is_active = 1;