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 j0_.id AS id_0, j0_.created_at AS created_at_1 FROM job_offre j0_ WHERE j0_.is_active = 1 ORDER BY j0_.created_at DESC, j0_.id DESC

[]

SELECT
  j0_.id AS id_0,
  j0_.created_at AS created_at_1
FROM
  job_offre j0_
WHERE
  j0_.is_active = 1
ORDER BY
  j0_.created_at DESC,
  j0_.id DESC

SELECT j0_.id AS id_0, j0_.created_at AS created_at_1 FROM job_offre j0_ WHERE j0_.is_active = 1 ORDER BY j0_.created_at DESC, j0_.id DESC;

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_.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 ORDER BY c0_.id DESC LIMIT 2000

[
  "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_.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
ORDER BY
  c0_.id DESC
LIMIT
  2000

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_.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 ORDER BY c0_.id DESC LIMIT 2000;

SELECT p0_.id AS id_0, p0_.subject_type AS subject_type_1, p0_.subject_id AS subject_id_2, p0_.share_enabled AS share_enabled_3, p0_.indexable AS indexable_4, p0_.show_avatar AS show_avatar_5, p0_.show_learner_name AS show_learner_name_6, p0_.revoked_at AS revoked_at_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.owner_id AS owner_id_10 FROM public_share_access p0_ WHERE p0_.subject_type = ? AND p0_.share_enabled = 1 AND p0_.indexable = 1 AND p0_.revoked_at IS NULL ORDER BY p0_.updated_at DESC LIMIT 2000

[
  "profile"
]

SELECT
  p0_.id AS id_0,
  p0_.subject_type AS subject_type_1,
  p0_.subject_id AS subject_id_2,
  p0_.share_enabled AS share_enabled_3,
  p0_.indexable AS indexable_4,
  p0_.show_avatar AS show_avatar_5,
  p0_.show_learner_name AS show_learner_name_6,
  p0_.revoked_at AS revoked_at_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.owner_id AS owner_id_10
FROM
  public_share_access p0_
WHERE
  p0_.subject_type = ?
  AND p0_.share_enabled = 1
  AND p0_.indexable = 1
  AND p0_.revoked_at IS NULL
ORDER BY
  p0_.updated_at DESC
LIMIT
  2000

SELECT p0_.id AS id_0, p0_.subject_type AS subject_type_1, p0_.subject_id AS subject_id_2, p0_.share_enabled AS share_enabled_3, p0_.indexable AS indexable_4, p0_.show_avatar AS show_avatar_5, p0_.show_learner_name AS show_learner_name_6, p0_.revoked_at AS revoked_at_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.owner_id AS owner_id_10 FROM public_share_access p0_ WHERE p0_.subject_type = 'profile' AND p0_.share_enabled = 1 AND p0_.indexable = 1 AND p0_.revoked_at IS NULL ORDER BY p0_.updated_at DESC LIMIT 2000;