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 = 'find_out' AND c0_.is_active = 1 ORDER BY c1_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.area AS area_2,
  c0_.image_key AS image_key_3,
  c0_.estimated_minutes AS estimated_minutes_4,
  c0_.duration_minutes_min AS duration_minutes_min_5,
  c0_.duration_minutes_max AS duration_minutes_max_6,
  c0_.require_all_answers AS require_all_answers_7,
  c0_.is_active AS is_active_8,
  c0_.position AS position_9,
  c0_.texts AS texts_10,
  c1_.id AS id_11,
  c1_.position AS position_12,
  c1_.texts AS texts_13,
  c2_.id AS id_14,
  c2_.position AS position_15,
  c2_.texts AS texts_16,
  c3_.id AS id_17,
  c3_.position AS position_18,
  c3_.texts AS texts_19,
  c3_.is_active AS is_active_20,
  c4_.id AS id_21,
  c4_.position AS position_22,
  c4_.score_min AS score_min_23,
  c4_.score_max AS score_max_24,
  c4_.texts AS texts_25,
  c0_.professional_profile_id AS professional_profile_id_26,
  c0_.recommended_specialty_id AS recommended_specialty_id_27,
  c1_.questionnaire_id AS questionnaire_id_28,
  c2_.questionnaire_id AS questionnaire_id_29,
  c3_.section_id AS section_id_30,
  c3_.block_id AS block_id_31,
  c3_.competence_id AS competence_id_32,
  c4_.questionnaire_id AS questionnaire_id_33
FROM
  content_questionnaires c0_
  LEFT JOIN content_questionnaire_competences c1_ ON c0_.id = c1_.questionnaire_id
  LEFT JOIN content_questionnaire_sections c2_ ON c0_.id = c2_.questionnaire_id
  LEFT JOIN content_questionnaire_questions c3_ ON c2_.id = c3_.section_id
  LEFT JOIN content_questionnaire_result_profiles c4_ ON c0_.id = c4_.questionnaire_id
WHERE
  c0_.is_active = 1
ORDER BY
  c0_.position ASC,
  c1_.position ASC,
  c2_.position ASC,
  c3_.position ASC,
  c4_.position ASC

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.area AS area_2, c0_.image_key AS image_key_3, c0_.estimated_minutes AS estimated_minutes_4, c0_.duration_minutes_min AS duration_minutes_min_5, c0_.duration_minutes_max AS duration_minutes_max_6, c0_.require_all_answers AS require_all_answers_7, c0_.is_active AS is_active_8, c0_.position AS position_9, c0_.texts AS texts_10, c1_.id AS id_11, c1_.position AS position_12, c1_.texts AS texts_13, c2_.id AS id_14, c2_.position AS position_15, c2_.texts AS texts_16, c3_.id AS id_17, c3_.position AS position_18, c3_.texts AS texts_19, c3_.is_active AS is_active_20, c4_.id AS id_21, c4_.position AS position_22, c4_.score_min AS score_min_23, c4_.score_max AS score_max_24, c4_.texts AS texts_25, c0_.professional_profile_id AS professional_profile_id_26, c0_.recommended_specialty_id AS recommended_specialty_id_27, c1_.questionnaire_id AS questionnaire_id_28, c2_.questionnaire_id AS questionnaire_id_29, c3_.section_id AS section_id_30, c3_.block_id AS block_id_31, c3_.competence_id AS competence_id_32, c4_.questionnaire_id AS questionnaire_id_33 FROM content_questionnaires c0_ LEFT JOIN content_questionnaire_competences c1_ ON c0_.id = c1_.questionnaire_id LEFT JOIN content_questionnaire_sections c2_ ON c0_.id = c2_.questionnaire_id LEFT JOIN content_questionnaire_questions c3_ ON c2_.id = c3_.section_id LEFT JOIN content_questionnaire_result_profiles c4_ ON c0_.id = c4_.questionnaire_id WHERE c0_.is_active = 1 ORDER BY c0_.position ASC, c1_.position ASC, c2_.position ASC, c3_.position ASC, c4_.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  content_questionnaire_blocks t0
WHERE
  t0.questionnaire_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = 0x01A0FA4883C07E5EB9A4A07CF913BC0F ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.is_active AS is_active_4,
  t0.section_id AS section_id_5,
  t0.block_id AS block_id_6,
  t0.competence_id AS competence_id_7
FROM
  content_questionnaire_questions 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.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = 0x01A0FA4883C170109E62E93A3EB714C3 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  content_questionnaire_blocks t0
WHERE
  t0.questionnaire_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = 0x01A0FA4883E57B93936A5A8191031822 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.is_active AS is_active_4,
  t0.section_id AS section_id_5,
  t0.block_id AS block_id_6,
  t0.competence_id AS competence_id_7
FROM
  content_questionnaire_questions 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.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = 0x01A0FA4883E57D3B936A5A8193ADBE4F ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  content_questionnaire_blocks t0
WHERE
  t0.questionnaire_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = 0x01A0FA48840573E5A504868AA16B5F24 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.is_active AS is_active_4,
  t0.section_id AS section_id_5,
  t0.block_id AS block_id_6,
  t0.competence_id AS competence_id_7
FROM
  content_questionnaire_questions 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.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = 0x01A0FA488405752DA504868AA4EF8645 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  content_questionnaire_blocks t0
WHERE
  t0.questionnaire_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = 0x01A0FA48842572CC97C4217746C46EE6 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.is_active AS is_active_4,
  t0.section_id AS section_id_5,
  t0.block_id AS block_id_6,
  t0.competence_id AS competence_id_7
FROM
  content_questionnaire_questions 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.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = 0x01A0FA48842573EC97C421774B400A03 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  content_questionnaire_blocks t0
WHERE
  t0.questionnaire_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = 0x01A0FA48844A7DACA2F6D30344E4EE9D ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.is_active AS is_active_4,
  t0.section_id AS section_id_5,
  t0.block_id AS block_id_6,
  t0.competence_id AS competence_id_7
FROM
  content_questionnaire_questions 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.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = 0x01A0FA48844A7EE8A2F6D303499EE59B ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  content_questionnaire_blocks t0
WHERE
  t0.questionnaire_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = 0x01A0FA48846A7161884CDBA4503BD257 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.is_active AS is_active_4,
  t0.section_id AS section_id_5,
  t0.block_id AS block_id_6,
  t0.competence_id AS competence_id_7
FROM
  content_questionnaire_questions 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.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = 0x01A0FA48846A7285884CDBA451AF854E ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.texts AS texts_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  content_questionnaire_blocks t0
WHERE
  t0.questionnaire_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = 0x01A0FA4884A57C848A35D337E6180278 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;