Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.gos_id AS gos_id_4,
  t0.is_visible AS is_visible_5,
  t0.is_optional AS is_optional_6,
  t0.minimum_score AS minimum_score_7,
  t0.good_answer_points AS good_answer_points_8,
  t0.wrong_answer_points AS wrong_answer_points_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.course_id AS course_id_14,
  t0.type
FROM
  test t0
WHERE
  t0.course_id = ?
  AND t0.type IN ('course')

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.gos_id AS gos_id_4, t0.is_visible AS is_visible_5, t0.is_optional AS is_optional_6, t0.minimum_score AS minimum_score_7, t0.good_answer_points AS good_answer_points_8, t0.wrong_answer_points AS wrong_answer_points_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.course_id AS course_id_14, t0.type FROM test t0 WHERE t0.course_id = 0x019CE23F0F5975FC9BDC4128313B244E AND t0.type IN ('course');

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
  course_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 course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019A5D63CC257E8DB9FE1E1B1D2FE166);

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.position AS position_5,
  t0.name AS name_6,
  t0.slug AS slug_7,
  t0.short_body AS short_body_8,
  t0.difficulty AS difficulty_9,
  t0.start_date AS start_date_10,
  t0.hide_date AS hide_date_11,
  t0.deactivation_date AS deactivation_date_12,
  t0.duration AS duration_13,
  t0.action_number AS action_number_14,
  t0.from_source AS from_source_15,
  t0.products_for_cos AS products_for_cos_16,
  t0.redirect_to_url AS redirect_to_url_17,
  t0.gos_id AS gos_id_18,
  t0.certificate_gos_id AS certificate_gos_id_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.seo_keywords AS seo_keywords_22,
  t0.seo_meta_title AS seo_meta_title_23,
  t0.seo_meta_description AS seo_meta_description_24,
  t0.seo_is_no_index AS seo_is_no_index_25,
  t0.category_id AS category_id_26,
  t0.image_id AS image_id_27,
  t0.created_by_id AS created_by_id_28,
  t0.updated_by_id AS updated_by_id_29,
  t0.type,
  t0.beacon_name AS beacon_name_30
FROM
  course t0
WHERE
  (
    t0.is_active = ?
    AND t0.category_id = ?
  )
  AND t0.type IN (
    'academy', 'future_degree', 'webinar',
    'no_front'
  )
ORDER BY
  t0.position 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.position AS position_5, t0.name AS name_6, t0.slug AS slug_7, t0.short_body AS short_body_8, t0.difficulty AS difficulty_9, t0.start_date AS start_date_10, t0.hide_date AS hide_date_11, t0.deactivation_date AS deactivation_date_12, t0.duration AS duration_13, t0.action_number AS action_number_14, t0.from_source AS from_source_15, t0.products_for_cos AS products_for_cos_16, t0.redirect_to_url AS redirect_to_url_17, t0.gos_id AS gos_id_18, t0.certificate_gos_id AS certificate_gos_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.seo_keywords AS seo_keywords_22, t0.seo_meta_title AS seo_meta_title_23, t0.seo_meta_description AS seo_meta_description_24, t0.seo_is_no_index AS seo_is_no_index_25, t0.category_id AS category_id_26, t0.image_id AS image_id_27, t0.created_by_id AS created_by_id_28, t0.updated_by_id AS updated_by_id_29, t0.type, t0.beacon_name AS beacon_name_30 FROM course t0 WHERE (t0.is_active = 1 AND t0.category_id = 0x019A5D63CC257E8DB9FE1E1B1D2FE166) AND t0.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY t0.position ASC;

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
  course_category t0
WHERE
  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 course_category t0 WHERE t0.parent_id = 0x019A5D63CC257E8DB9FE1E1B1D2FE166;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.context AS context_3,
  t0.coupon_code AS coupon_code_4,
  t0.price_net AS price_net_5,
  t0.price_gross AS price_gross_6,
  t0.price_net_discounted AS price_net_discounted_7,
  t0.price_gross_discounted AS price_gross_discounted_8,
  t0.valid_until AS valid_until_9,
  t0.main_promo_text AS main_promo_text_10,
  t0.sub_promo_text AS sub_promo_text_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.course_id AS course_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.type
FROM
  course_price t0
WHERE
  (
    t0.is_active = ?
    AND t0.course_id = ?
  )
  AND t0.type IN ('variant', 'pack')

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.context AS context_3, t0.coupon_code AS coupon_code_4, t0.price_net AS price_net_5, t0.price_gross AS price_gross_6, t0.price_net_discounted AS price_net_discounted_7, t0.price_gross_discounted AS price_gross_discounted_8, t0.valid_until AS valid_until_9, t0.main_promo_text AS main_promo_text_10, t0.sub_promo_text AS sub_promo_text_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.course_id AS course_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.type FROM course_price t0 WHERE (t0.is_active = 1 AND t0.course_id = 0x019CE23F0F5975FC9BDC4128313B244E) AND t0.type IN ('variant', 'pack');

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

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.icon AS icon_4, c0_.color AS color_5, c0_.short_body AS short_body_6, c0_.body AS body_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.image_id AS image_id_10, c0_.desktop_banner_id AS desktop_banner_id_11, c0_.mobile_banner_id AS mobile_banner_id_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.parent_id AS parent_id_15 FROM course_category c0_ WHERE c0_.parent_id IS NULL AND c0_.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
  course_category t0
WHERE
  t0.slug = ?
LIMIT
  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 course_category t0 WHERE t0.slug = 'hr' LIMIT 1;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  course c0_
  INNER JOIN course_category c1_ ON c0_.category_id = c1_.id
  LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id
WHERE
  (
    (
      c1_.id = ?
      OR c2_.id = ?
    )
    AND c1_.is_active = ?
    AND c0_.type NOT IN ('no_front')
    AND (
      c0_.is_active = ?
      OR (
        c0_.is_active = ?
        AND c0_.hide_date > ?
      )
    )
  )
  AND c0_.type IN (
    'academy', 'future_degree', 'webinar',
    'no_front'
  )

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = 0x019CF757545679FF9CA33FCD43B04EC0 OR c2_.id = 0x019CF757545679FF9CA33FCD43B04EC0) AND c1_.is_active = 1 AND c0_.type NOT IN ('no_front') AND (c0_.is_active = 1 OR (c0_.is_active = 0 AND c0_.hide_date > '2026-03-30 18:56:32'))) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front');

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.created_at AS created_at_1
FROM
  course c0_
  INNER JOIN course_category c1_ ON c0_.category_id = c1_.id
  LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id
WHERE
  (
    (
      c1_.id = ?
      OR c2_.id = ?
    )
    AND c1_.is_active = ?
    AND c0_.type NOT IN ('no_front')
    AND (
      c0_.is_active = ?
      OR (
        c0_.is_active = ?
        AND c0_.hide_date > ?
      )
    )
  )
  AND c0_.type IN (
    'academy', 'future_degree', 'webinar',
    'no_front'
  )
ORDER BY
  c0_.created_at DESC
LIMIT
  12

SELECT DISTINCT c0_.id AS id_0, c0_.created_at AS created_at_1 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = 0x019CF757545679FF9CA33FCD43B04EC0 OR c2_.id = 0x019CF757545679FF9CA33FCD43B04EC0) AND c1_.is_active = 1 AND c0_.type NOT IN ('no_front') AND (c0_.is_active = 1 OR (c0_.is_active = 0 AND c0_.hide_date > '2026-03-30 18:56:32'))) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY c0_.created_at DESC LIMIT 12;

SELECT
  c0_.id AS id_0,
  c0_.is_active AS is_active_1,
  c0_.is_continuous AS is_continuous_2,
  c0_.is_medical_product AS is_medical_product_3,
  c0_.position AS position_4,
  c0_.name AS name_5,
  c0_.slug AS slug_6,
  c0_.short_body AS short_body_7,
  c0_.difficulty AS difficulty_8,
  c0_.start_date AS start_date_9,
  c0_.hide_date AS hide_date_10,
  c0_.deactivation_date AS deactivation_date_11,
  c0_.duration AS duration_12,
  c0_.action_number AS action_number_13,
  c0_.from_source AS from_source_14,
  c0_.products_for_cos AS products_for_cos_15,
  c0_.redirect_to_url AS redirect_to_url_16,
  c0_.gos_id AS gos_id_17,
  c0_.certificate_gos_id AS certificate_gos_id_18,
  c0_.created_at AS created_at_19,
  c0_.updated_at AS updated_at_20,
  c0_.seo_keywords AS seo_keywords_21,
  c0_.seo_meta_title AS seo_meta_title_22,
  c0_.seo_meta_description AS seo_meta_description_23,
  c0_.seo_is_no_index AS seo_is_no_index_24,
  c0_.beacon_name AS beacon_name_25,
  c0_.type AS type_26,
  c0_.category_id AS category_id_27,
  c0_.image_id AS image_id_28,
  c0_.created_by_id AS created_by_id_29,
  c0_.updated_by_id AS updated_by_id_30
FROM
  course c0_
  INNER JOIN course_category c1_ ON c0_.category_id = c1_.id
  LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id
WHERE
  (
    (
      c1_.id = ?
      OR c2_.id = ?
    )
    AND c1_.is_active = ?
    AND c0_.type NOT IN ('no_front')
    AND (
      c0_.is_active = ?
      OR (
        c0_.is_active = ?
        AND c0_.hide_date > ?
      )
    )
    AND c0_.id IN (?, ?)
  )
  AND c0_.type IN (
    'academy', 'future_degree', 'webinar',
    'no_front'
  )
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_continuous AS is_continuous_2, c0_.is_medical_product AS is_medical_product_3, c0_.position AS position_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.short_body AS short_body_7, c0_.difficulty AS difficulty_8, c0_.start_date AS start_date_9, c0_.hide_date AS hide_date_10, c0_.deactivation_date AS deactivation_date_11, c0_.duration AS duration_12, c0_.action_number AS action_number_13, c0_.from_source AS from_source_14, c0_.products_for_cos AS products_for_cos_15, c0_.redirect_to_url AS redirect_to_url_16, c0_.gos_id AS gos_id_17, c0_.certificate_gos_id AS certificate_gos_id_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.seo_keywords AS seo_keywords_21, c0_.seo_meta_title AS seo_meta_title_22, c0_.seo_meta_description AS seo_meta_description_23, c0_.seo_is_no_index AS seo_is_no_index_24, c0_.beacon_name AS beacon_name_25, c0_.type AS type_26, c0_.category_id AS category_id_27, c0_.image_id AS image_id_28, c0_.created_by_id AS created_by_id_29, c0_.updated_by_id AS updated_by_id_30 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = 0x019CF757545679FF9CA33FCD43B04EC0 OR c2_.id = 0x019CF757545679FF9CA33FCD43B04EC0) AND c1_.is_active = 1 AND c0_.type NOT IN ('no_front') AND (c0_.is_active = 1 OR (c0_.is_active = 0 AND c0_.hide_date > '2026-03-30 18:56:32')) AND c0_.id IN (0x019CE23F0F5975FC9BDC4128313B244E, 0x019C7B6D83317B41B1FD75E7BCD5B5A5)) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY c0_.created_at DESC;

SELECT
  t0.name AS name_1,
  t0.original_name AS original_name_2,
  t0.size AS size_3,
  t0.mime_type AS mime_type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.dimensions AS dimensions_7,
  t0.id AS id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10
FROM
  course_image t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dimensions AS dimensions_7, t0.id AS id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM course_image t0 WHERE t0.id = 0x019CE23F229D7B20BC1BC4D441D54874;

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
  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;