Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.content AS content_4, t0.type AS type_5, t0.blocks AS blocks_6, t0.chapter_id AS chapter_id_7 FROM chapter_section t0 WHERE t0.chapter_id = ? ORDER BY t0.position ASC

[
  131
]

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.type AS type_5,
  t0.blocks AS blocks_6,
  t0.chapter_id AS chapter_id_7
FROM
  chapter_section t0
WHERE
  t0.chapter_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.content AS content_4, t0.type AS type_5, t0.blocks AS blocks_6, t0.chapter_id AS chapter_id_7 FROM chapter_section t0 WHERE t0.chapter_id = 131 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.position AS position_2, t0.question_text AS question_text_3, t0.type AS type_4, t0.options AS options_5, t0.correct_answer AS correct_answer_6, t0.explanation AS explanation_7, t0.chapter_id AS chapter_id_8 FROM chapter_question t0 WHERE t0.chapter_id = ? ORDER BY t0.position ASC

[
  131
]

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.question_text AS question_text_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.correct_answer AS correct_answer_6,
  t0.explanation AS explanation_7,
  t0.chapter_id AS chapter_id_8
FROM
  chapter_question t0
WHERE
  t0.chapter_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.question_text AS question_text_3, t0.type AS type_4, t0.options AS options_5, t0.correct_answer AS correct_answer_6, t0.explanation AS explanation_7, t0.chapter_id AS chapter_id_8 FROM chapter_question t0 WHERE t0.chapter_id = 131 ORDER BY t0.position ASC;

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.level AS level_2, c0_.description AS description_3, c0_.course AS course_4, c0_.is_completed AS is_completed_5, c0_.completed_at AS completed_at_6, c0_.level_code AS level_code_7, c0_.is_progressive AS is_progressive_8, c0_.structure_generated_at AS structure_generated_at_9, c0_.language AS language_10, c0_.subject AS subject_11, c0_.rating_average AS rating_average_12, c0_.rating_count AS rating_count_13, c0_.public_view_count AS public_view_count_14, c0_.weekly_recommandation_id AS weekly_recommandation_id_15, c0_.future_skill_id AS future_skill_id_16, c0_.company_document_id AS company_document_id_17 FROM course c0_ WHERE c0_.id = ? AND (((c0_.is_progressive = 0 AND c0_.course IS NOT NULL) OR (c0_.is_progressive = 1 AND c0_.structure_generated_at IS NOT NULL AND EXISTS (SELECT c1_.id FROM course_chapter c1_ WHERE c1_.course_id = c0_.id) AND NOT EXISTS (SELECT c2_.id FROM course_chapter c2_ WHERE c2_.course_id = c0_.id AND c2_.status <> ?)))) AND c0_.company_document_id IS NULL LIMIT 1

[
  9857
  "ready"
]

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.level AS level_2,
  c0_.description AS description_3,
  c0_.course AS course_4,
  c0_.is_completed AS is_completed_5,
  c0_.completed_at AS completed_at_6,
  c0_.level_code AS level_code_7,
  c0_.is_progressive AS is_progressive_8,
  c0_.structure_generated_at AS structure_generated_at_9,
  c0_.language AS language_10,
  c0_.subject AS subject_11,
  c0_.rating_average AS rating_average_12,
  c0_.rating_count AS rating_count_13,
  c0_.public_view_count AS public_view_count_14,
  c0_.weekly_recommandation_id AS weekly_recommandation_id_15,
  c0_.future_skill_id AS future_skill_id_16,
  c0_.company_document_id AS company_document_id_17
FROM
  course c0_
WHERE
  c0_.id = ?
  AND (
    (
      (
        c0_.is_progressive = 0
        AND c0_.course IS NOT NULL
      )
      OR (
        c0_.is_progressive = 1
        AND c0_.structure_generated_at IS NOT NULL
        AND EXISTS (
          SELECT
            c1_.id
          FROM
            course_chapter c1_
          WHERE
            c1_.course_id = c0_.id
        )
        AND NOT EXISTS (
          SELECT
            c2_.id
          FROM
            course_chapter c2_
          WHERE
            c2_.course_id = c0_.id
            AND c2_.status <> ?
        )
      )
    )
  )
  AND c0_.company_document_id IS NULL
LIMIT
  1

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.level AS level_2, c0_.description AS description_3, c0_.course AS course_4, c0_.is_completed AS is_completed_5, c0_.completed_at AS completed_at_6, c0_.level_code AS level_code_7, c0_.is_progressive AS is_progressive_8, c0_.structure_generated_at AS structure_generated_at_9, c0_.language AS language_10, c0_.subject AS subject_11, c0_.rating_average AS rating_average_12, c0_.rating_count AS rating_count_13, c0_.public_view_count AS public_view_count_14, c0_.weekly_recommandation_id AS weekly_recommandation_id_15, c0_.future_skill_id AS future_skill_id_16, c0_.company_document_id AS company_document_id_17 FROM course c0_ WHERE c0_.id = 9857 AND (((c0_.is_progressive = 0 AND c0_.course IS NOT NULL) OR (c0_.is_progressive = 1 AND c0_.structure_generated_at IS NOT NULL AND EXISTS (SELECT c1_.id FROM course_chapter c1_ WHERE c1_.course_id = c0_.id) AND NOT EXISTS (SELECT c2_.id FROM course_chapter c2_ WHERE c2_.course_id = c0_.id AND c2_.status <> 'ready')))) AND c0_.company_document_id IS NULL LIMIT 1;

SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.summary AS summary_4, t0.learning_objectives AS learning_objectives_5, t0.content AS content_6, t0.status AS status_7, t0.generated_at AS generated_at_8, t0.quiz_passed AS quiz_passed_9, t0.quiz_passed_at AS quiz_passed_at_10, t0.course_id AS course_id_11 FROM course_chapter t0 WHERE t0.course_id = ? ORDER BY t0.position ASC

[
  9857
]

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.title AS title_3,
  t0.summary AS summary_4,
  t0.learning_objectives AS learning_objectives_5,
  t0.content AS content_6,
  t0.status AS status_7,
  t0.generated_at AS generated_at_8,
  t0.quiz_passed AS quiz_passed_9,
  t0.quiz_passed_at AS quiz_passed_at_10,
  t0.course_id AS course_id_11
FROM
  course_chapter t0
WHERE
  t0.course_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.summary AS summary_4, t0.learning_objectives AS learning_objectives_5, t0.content AS content_6, t0.status AS status_7, t0.generated_at AS generated_at_8, t0.quiz_passed AS quiz_passed_9, t0.quiz_passed_at AS quiz_passed_at_10, t0.course_id AS course_id_11 FROM course_chapter t0 WHERE t0.course_id = 9857 ORDER BY t0.position ASC;