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

[
  3485
  "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 = 3485 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;