Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.link_from AS link_from_1,
  r0_.link_to AS link_to_2,
  r0_.code AS code_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5
FROM
  redirect r0_
WHERE
  r0_.link_from = '/training-course/2026-2'

SELECT r0_.id AS id_0, r0_.link_from AS link_from_1, r0_.link_to AS link_to_2, r0_.code AS code_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5 FROM redirect r0_ WHERE r0_.link_from = '/training-course/2026-2';

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.teacher_name AS teacher_name_1,
          t0_.teacher_name_en AS teacher_name_en_2,
          t0_.price AS price_3,
          t0_.seats_limit AS seats_limit_4,
          t0_.start_date AS start_date_5,
          t0_.end_date AS end_date_6,
          t0_.display AS display_7,
          t0_.created_at AS created_at_8,
          t0_.updated_at AS updated_at_9,
          t1_.id AS id_10,
          t1_.name AS name_11,
          t1_.name_en AS name_en_12,
          t1_.photo AS photo_13,
          t1_.description AS description_14,
          t1_.description_en AS description_en_15,
          t1_.created_at AS created_at_16,
          t1_.updated_at AS updated_at_17,
          o2_.id AS id_18,
          o2_.name AS name_19,
          o2_.phone AS phone_20,
          o2_.email AS email_21,
          o2_.price AS price_22,
          o2_.comment AS comment_23,
          o2_.viewed_at AS viewed_at_24,
          o2_.status AS status_25,
          o2_.created_at AS created_at_26,
          o2_.updated_at AS updated_at_27,
          o2_.type AS type_28
        FROM
          training_course_date t0_
          INNER JOIN training_course t1_ ON t0_.course_id = t1_.id
          LEFT JOIN order_training_course o3_ ON t0_.id = o3_.date_id
          LEFT JOIN `order` o2_ ON o3_.id = o2_.id
        WHERE
          (
            YEAR(t0_.start_date) = 2026
            AND MONTH(t0_.start_date) = 2
          )
          AND t0_.start_date >= NOW()
        ORDER BY
          t0_.start_date ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.teacher_name AS teacher_name_1, t0_.teacher_name_en AS teacher_name_en_2, t0_.price AS price_3, t0_.seats_limit AS seats_limit_4, t0_.start_date AS start_date_5, t0_.end_date AS end_date_6, t0_.display AS display_7, t0_.created_at AS created_at_8, t0_.updated_at AS updated_at_9, t1_.id AS id_10, t1_.name AS name_11, t1_.name_en AS name_en_12, t1_.photo AS photo_13, t1_.description AS description_14, t1_.description_en AS description_en_15, t1_.created_at AS created_at_16, t1_.updated_at AS updated_at_17, o2_.id AS id_18, o2_.name AS name_19, o2_.phone AS phone_20, o2_.email AS email_21, o2_.price AS price_22, o2_.comment AS comment_23, o2_.viewed_at AS viewed_at_24, o2_.status AS status_25, o2_.created_at AS created_at_26, o2_.updated_at AS updated_at_27, o2_.type AS type_28 FROM training_course_date t0_ INNER JOIN training_course t1_ ON t0_.course_id = t1_.id LEFT JOIN order_training_course o3_ ON t0_.id = o3_.date_id LEFT JOIN `order` o2_ ON o3_.id = o2_.id WHERE (YEAR(t0_.start_date) = 2026 AND MONTH(t0_.start_date) = 2) AND t0_.start_date >= NOW() ORDER BY t0_.start_date ASC) dctrn_result) dctrn_table;

SELECT
  s0_.id AS id_0,
  s0_.link AS link_1,
  s0_.title AS title_2,
  s0_.title_en AS title_en_3,
  s0_.description AS description_4,
  s0_.description_en AS description_en_5,
  s0_.keywords AS keywords_6,
  s0_.keywords_en AS keywords_en_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9
FROM
  static_meta s0_
WHERE
  s0_.link = '/training-course/2026-2'

SELECT s0_.id AS id_0, s0_.link AS link_1, s0_.title AS title_2, s0_.title_en AS title_en_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.keywords AS keywords_6, s0_.keywords_en AS keywords_en_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9 FROM static_meta s0_ WHERE s0_.link = '/training-course/2026-2';

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      start_date_5
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.teacher_name AS teacher_name_1,
          t0_.teacher_name_en AS teacher_name_en_2,
          t0_.price AS price_3,
          t0_.seats_limit AS seats_limit_4,
          t0_.start_date AS start_date_5,
          t0_.end_date AS end_date_6,
          t0_.display AS display_7,
          t0_.created_at AS created_at_8,
          t0_.updated_at AS updated_at_9,
          t1_.id AS id_10,
          t1_.name AS name_11,
          t1_.name_en AS name_en_12,
          t1_.photo AS photo_13,
          t1_.description AS description_14,
          t1_.description_en AS description_en_15,
          t1_.created_at AS created_at_16,
          t1_.updated_at AS updated_at_17,
          o2_.id AS id_18,
          o2_.name AS name_19,
          o2_.phone AS phone_20,
          o2_.email AS email_21,
          o2_.price AS price_22,
          o2_.comment AS comment_23,
          o2_.viewed_at AS viewed_at_24,
          o2_.status AS status_25,
          o2_.created_at AS created_at_26,
          o2_.updated_at AS updated_at_27,
          o2_.type AS type_28
        FROM
          training_course_date t0_
          INNER JOIN training_course t1_ ON t0_.course_id = t1_.id
          LEFT JOIN order_training_course o3_ ON t0_.id = o3_.date_id
          LEFT JOIN `order` o2_ ON o3_.id = o2_.id
        WHERE
          (
            YEAR(t0_.start_date) = 2026
            AND MONTH(t0_.start_date) = 2
          )
          AND t0_.start_date >= NOW()
      ) dctrn_result_inner
    ORDER BY
      start_date_5 ASC
  ) dctrn_result
LIMIT
  100

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_date_5 FROM (SELECT t0_.id AS id_0, t0_.teacher_name AS teacher_name_1, t0_.teacher_name_en AS teacher_name_en_2, t0_.price AS price_3, t0_.seats_limit AS seats_limit_4, t0_.start_date AS start_date_5, t0_.end_date AS end_date_6, t0_.display AS display_7, t0_.created_at AS created_at_8, t0_.updated_at AS updated_at_9, t1_.id AS id_10, t1_.name AS name_11, t1_.name_en AS name_en_12, t1_.photo AS photo_13, t1_.description AS description_14, t1_.description_en AS description_en_15, t1_.created_at AS created_at_16, t1_.updated_at AS updated_at_17, o2_.id AS id_18, o2_.name AS name_19, o2_.phone AS phone_20, o2_.email AS email_21, o2_.price AS price_22, o2_.comment AS comment_23, o2_.viewed_at AS viewed_at_24, o2_.status AS status_25, o2_.created_at AS created_at_26, o2_.updated_at AS updated_at_27, o2_.type AS type_28 FROM training_course_date t0_ INNER JOIN training_course t1_ ON t0_.course_id = t1_.id LEFT JOIN order_training_course o3_ ON t0_.id = o3_.date_id LEFT JOIN `order` o2_ ON o3_.id = o2_.id WHERE (YEAR(t0_.start_date) = 2026 AND MONTH(t0_.start_date) = 2) AND t0_.start_date >= NOW()) dctrn_result_inner ORDER BY start_date_5 ASC) dctrn_result LIMIT 100;