Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.is_active AS is_active_1,
  h0_.position AS position_2,
  h0_.name AS name_3,
  h0_.variables AS variables_4,
  h0_.display_until AS display_until_5,
  h0_.created_at AS created_at_6,
  h0_.updated_at AS updated_at_7,
  h0_.type AS type_8,
  h0_.portal_settings_id AS portal_settings_id_9,
  h0_.created_by_id AS created_by_id_10,
  h0_.updated_by_id AS updated_by_id_11
FROM
  homepage_landing_section h0_
WHERE
  (
    h0_.is_active = ?
    AND (
      h0_.display_until IS NULL
      OR h0_.display_until >= ?
    )
  )
  AND h0_.type IN (
    'counters_section', 'html_section',
    'testimonial_section', 'knowledge_base_section',
    'authors_carousel_section', 'category_carousel_section',
    'courses_carousel_section', 'multi_courses_carousel_section',
    'partners_carousel_section', 'partners_description_section'
  )
ORDER BY
  h0_.position ASC

SELECT h0_.id AS id_0, h0_.is_active AS is_active_1, h0_.position AS position_2, h0_.name AS name_3, h0_.variables AS variables_4, h0_.display_until AS display_until_5, h0_.created_at AS created_at_6, h0_.updated_at AS updated_at_7, h0_.type AS type_8, h0_.portal_settings_id AS portal_settings_id_9, h0_.created_by_id AS created_by_id_10, h0_.updated_by_id AS updated_by_id_11 FROM homepage_landing_section h0_ WHERE (h0_.is_active = 1 AND (h0_.display_until IS NULL OR h0_.display_until >= '2026-07-16 21:31:32')) AND h0_.type IN ('counters_section', 'html_section', 'testimonial_section', 'knowledge_base_section', 'authors_carousel_section', 'category_carousel_section', 'courses_carousel_section', 'multi_courses_carousel_section', 'partners_carousel_section', 'partners_description_section') ORDER BY h0_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.footer_text AS footer_text_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.seo_keywords AS seo_keywords_5,
  p0_.seo_meta_title AS seo_meta_title_6,
  p0_.seo_meta_description AS seo_meta_description_7,
  p0_.seo_open_graph_title AS seo_open_graph_title_8,
  p0_.seo_open_graph_description AS seo_open_graph_description_9,
  p0_.seo_open_graph_image_url AS seo_open_graph_image_url_10,
  p0_.seo_is_no_index AS seo_is_no_index_11,
  p0_.social_facebook AS social_facebook_12,
  p0_.social_twitter AS social_twitter_13,
  p0_.social_instagram AS social_instagram_14,
  p0_.social_linked_in AS social_linked_in_15,
  p0_.social_youtube AS social_youtube_16,
  p0_.login_settings_google_id AS login_settings_google_id_17,
  p0_.login_settings_google_secret AS login_settings_google_secret_18,
  p0_.created_by_id AS created_by_id_19,
  p0_.updated_by_id AS updated_by_id_20
FROM
  portal_settings p0_
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.footer_text AS footer_text_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.seo_keywords AS seo_keywords_5, p0_.seo_meta_title AS seo_meta_title_6, p0_.seo_meta_description AS seo_meta_description_7, p0_.seo_open_graph_title AS seo_open_graph_title_8, p0_.seo_open_graph_description AS seo_open_graph_description_9, p0_.seo_open_graph_image_url AS seo_open_graph_image_url_10, p0_.seo_is_no_index AS seo_is_no_index_11, p0_.social_facebook AS social_facebook_12, p0_.social_twitter AS social_twitter_13, p0_.social_instagram AS social_instagram_14, p0_.social_linked_in AS social_linked_in_15, p0_.social_youtube AS social_youtube_16, p0_.login_settings_google_id AS login_settings_google_id_17, p0_.login_settings_google_secret AS login_settings_google_secret_18, p0_.created_by_id AS created_by_id_19, p0_.updated_by_id AS updated_by_id_20 FROM portal_settings p0_ LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.portal_settings_id AS portal_settings_id_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  footer_link t0
WHERE
  t0.portal_settings_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.portal_settings_id AS portal_settings_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM footer_link t0 WHERE t0.portal_settings_id = 1 ORDER BY t0.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c1_.id AS id_3,
  c1_.name AS name_4,
  c1_.slug AS slug_5
FROM
  course_category c0_
  LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id
WHERE
  c0_.is_active = 1
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c1_.id AS id_3, c1_.name AS name_4, c1_.slug AS slug_5 FROM course_category c0_ LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id WHERE c0_.is_active = 1 ORDER BY c0_.name ASC;

SELECT
  a0_.id AS id_0,
  a0_.is_active AS is_active_1,
  a0_.name AS name_2,
  a0_.slug AS slug_3,
  a0_.icon AS icon_4,
  a0_.color AS color_5,
  a0_.short_body AS short_body_6,
  a0_.body AS body_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.image_id AS image_id_10,
  a0_.desktop_banner_id AS desktop_banner_id_11,
  a0_.mobile_banner_id AS mobile_banner_id_12,
  a0_.created_by_id AS created_by_id_13,
  a0_.updated_by_id AS updated_by_id_14,
  a0_.parent_id AS parent_id_15
FROM
  article_category a0_
WHERE
  a0_.parent_id IS NULL
  AND a0_.is_active = 1

SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.name AS name_2, a0_.slug AS slug_3, a0_.icon AS icon_4, a0_.color AS color_5, a0_.short_body AS short_body_6, a0_.body AS body_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.image_id AS image_id_10, a0_.desktop_banner_id AS desktop_banner_id_11, a0_.mobile_banner_id AS mobile_banner_id_12, a0_.created_by_id AS created_by_id_13, a0_.updated_by_id AS updated_by_id_14, a0_.parent_id AS parent_id_15 FROM article_category a0_ WHERE a0_.parent_id IS NULL AND a0_.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019A5E2FB02D798B8E4B952F3781BC46);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019CFBC1220B75E4B61881ED79770E60);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019D915BD0CF7B04B76AD6FED6FF208F);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019EBAEFB00E7ACF930DAE393BF5995C);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ECA2DA1AC7191ADDA0F2806848CC9);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ECA8FEECB7E9B9D1D749A9C90CF7E);

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.icon AS icon_5,
  t0.color AS color_6,
  t0.short_body AS short_body_7,
  t0.body AS body_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.image_id AS image_id_11,
  t0.desktop_banner_id AS desktop_banner_id_12,
  t0.mobile_banner_id AS mobile_banner_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.parent_id AS parent_id_16
FROM
  article_category t0
WHERE
  (
    (t0.is_active = ?)
    AND t0.parent_id = ?
  )

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019ECAA6E728716EBFF576ACFF48A6F9);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c1_.id AS id_3,
  c1_.name AS name_4,
  c1_.slug AS slug_5
FROM
  course_category c0_
  LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id
WHERE
  c0_.is_active = 1
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c1_.id AS id_3, c1_.name AS name_4, c1_.slug AS slug_5 FROM course_category c0_ LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id WHERE c0_.is_active = 1 ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_continuous AS is_continuous_3,
  t0.is_medical_product AS is_medical_product_4,
  t0.is_content_complete AS is_content_complete_5,
  t0.is_promoted AS is_promoted_6,
  t0.promotion_end_date AS promotion_end_date_7,
  t0.promotion_label AS promotion_label_8,
  t0.position AS position_9,
  t0.name AS name_10,
  t0.slug AS slug_11,
  t0.short_body AS short_body_12,
  t0.difficulty AS difficulty_13,
  t0.start_date AS start_date_14,
  t0.hide_date AS hide_date_15,
  t0.deactivation_date AS deactivation_date_16,
  t0.duration AS duration_17,
  t0.action_number AS action_number_18,
  t0.from_source AS from_source_19,
  t0.products_for_cos AS products_for_cos_20,
  t0.redirect_to_url AS redirect_to_url_21,
  t0.gos_id AS gos_id_22,
  t0.certificate_gos_id AS certificate_gos_id_23,
  t0.deactivation_note AS deactivation_note_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.seo_keywords AS seo_keywords_27,
  t0.seo_meta_title AS seo_meta_title_28,
  t0.seo_meta_description AS seo_meta_description_29,
  t0.seo_open_graph_title AS seo_open_graph_title_30,
  t0.seo_open_graph_description AS seo_open_graph_description_31,
  t0.seo_open_graph_image_url AS seo_open_graph_image_url_32,
  t0.seo_is_no_index AS seo_is_no_index_33,
  t0.beacon_name AS beacon_name_34,
  t0.category_id AS category_id_35,
  t0.image_id AS image_id_36,
  t0.created_by_id AS created_by_id_37,
  t0.updated_by_id AS updated_by_id_38,
  t0.type
FROM
  course t0
WHERE
  t0.id = ?
  AND t0.type IN ('future_degree')

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_continuous AS is_continuous_3, t0.is_medical_product AS is_medical_product_4, t0.is_content_complete AS is_content_complete_5, t0.is_promoted AS is_promoted_6, t0.promotion_end_date AS promotion_end_date_7, t0.promotion_label AS promotion_label_8, t0.position AS position_9, t0.name AS name_10, t0.slug AS slug_11, t0.short_body AS short_body_12, t0.difficulty AS difficulty_13, t0.start_date AS start_date_14, t0.hide_date AS hide_date_15, t0.deactivation_date AS deactivation_date_16, t0.duration AS duration_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.products_for_cos AS products_for_cos_20, t0.redirect_to_url AS redirect_to_url_21, t0.gos_id AS gos_id_22, t0.certificate_gos_id AS certificate_gos_id_23, t0.deactivation_note AS deactivation_note_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.seo_keywords AS seo_keywords_27, t0.seo_meta_title AS seo_meta_title_28, t0.seo_meta_description AS seo_meta_description_29, t0.seo_open_graph_title AS seo_open_graph_title_30, t0.seo_open_graph_description AS seo_open_graph_description_31, t0.seo_open_graph_image_url AS seo_open_graph_image_url_32, t0.seo_is_no_index AS seo_is_no_index_33, t0.beacon_name AS beacon_name_34, t0.category_id AS category_id_35, t0.image_id AS image_id_36, t0.created_by_id AS created_by_id_37, t0.updated_by_id AS updated_by_id_38, t0.type FROM course t0 WHERE t0.id = 0x019EBBDE67AA7D7280158F4EE5FDFCB3 AND t0.type IN ('future_degree');