Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 14
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Emails
• Serializer
• JMS Serializer 0 + 0
• VichUploader
• Configuration

Query Metrics

SELECT c0_.id AS id_0, c0_.lvl AS lvl_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.name AS name_5, c0_.role AS role_6, c0_.parent_id AS parent_id_7 FROM cms_roles c0_ WHERE c0_.lvl IN (0, 1) AND c0_.role NOT LIKE 'ROLE_ADMIN_%' ORDER BY c0_.root ASC, c0_.lft ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.lvl AS lvl_1,
  c0_.lft AS lft_2,
  c0_.rgt AS rgt_3,
  c0_.root AS root_4,
  c0_.name AS name_5,
  c0_.role AS role_6,
  c0_.parent_id AS parent_id_7
FROM
  cms_roles c0_
WHERE
  c0_.lvl IN (0, 1)
  AND c0_.role NOT LIKE 'ROLE_ADMIN_%'
ORDER BY
  c0_.root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.lvl AS lvl_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.name AS name_5, c0_.role AS role_6, c0_.parent_id AS parent_id_7 FROM cms_roles c0_ WHERE c0_.lvl IN (0, 1) AND c0_.role NOT LIKE 'ROLE_ADMIN_%' ORDER BY c0_.root ASC, c0_.lft ASC;

SELECT t0.id AS id_1, t0.package AS package_2, t0.name AS name_3, t0.description AS description_4, t0.display_name AS display_name_5, t0.list_name AS list_name_6, t0.is_internal AS is_internal_7, t0.is_categorizable AS is_categorizable_8, t0.is_fileable AS is_fileable_9, t0.is_printable AS is_printable_10, t0.is_embeddable AS is_embeddable_11, t0.is_searchable AS is_searchable_12, t0.is_queryable AS is_queryable_13, t0.accepts_comments AS accepts_comments_14, t0.has_authors AS has_authors_15, t0.has_attachments AS has_attachments_16, t0.has_source AS has_source_17, t0.has_tags AS has_tags_18, t0.has_summary AS has_summary_19, t0.has_aggregates AS has_aggregates_20 FROM content_type t0

[]

SELECT
  t0.id AS id_1,
  t0.package AS package_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.display_name AS display_name_5,
  t0.list_name AS list_name_6,
  t0.is_internal AS is_internal_7,
  t0.is_categorizable AS is_categorizable_8,
  t0.is_fileable AS is_fileable_9,
  t0.is_printable AS is_printable_10,
  t0.is_embeddable AS is_embeddable_11,
  t0.is_searchable AS is_searchable_12,
  t0.is_queryable AS is_queryable_13,
  t0.accepts_comments AS accepts_comments_14,
  t0.has_authors AS has_authors_15,
  t0.has_attachments AS has_attachments_16,
  t0.has_source AS has_source_17,
  t0.has_tags AS has_tags_18,
  t0.has_summary AS has_summary_19,
  t0.has_aggregates AS has_aggregates_20
FROM
  content_type t0

SELECT t0.id AS id_1, t0.package AS package_2, t0.name AS name_3, t0.description AS description_4, t0.display_name AS display_name_5, t0.list_name AS list_name_6, t0.is_internal AS is_internal_7, t0.is_categorizable AS is_categorizable_8, t0.is_fileable AS is_fileable_9, t0.is_printable AS is_printable_10, t0.is_embeddable AS is_embeddable_11, t0.is_searchable AS is_searchable_12, t0.is_queryable AS is_queryable_13, t0.accepts_comments AS accepts_comments_14, t0.has_authors AS has_authors_15, t0.has_attachments AS has_attachments_16, t0.has_source AS has_source_17, t0.has_tags AS has_tags_18, t0.has_summary AS has_summary_19, t0.has_aggregates AS has_aggregates_20 FROM content_type t0;

SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_

[]

SELECT
  r0_.name AS name_0,
  r0_.value AS value_1
FROM
  runtime_parameter r0_

SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM tag t0 WHERE t0.name = ? LIMIT 1

[
  "(لا) القرآن"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  tag t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM tag t0 WHERE t0.name = '(لا) القرآن' LIMIT 1;

SELECT e0_.id AS id_0 FROM entry e0_ INNER JOIN content_type c1_ ON e0_.type_id = c1_.id LEFT JOIN collection c2_ ON e0_.collection_id = c2_.id AND (c2_.deleted_at IS NULL) AND (c2_.deleted_at IS NULL) LEFT JOIN entry_author e4_ ON e0_.id = e4_.entry_id LEFT JOIN author a3_ ON a3_.id = e4_.author_id AND (a3_.deleted_at IS NULL) AND (a3_.deleted_at IS NULL) LEFT JOIN entry_tag e6_ ON e0_.id = e6_.entry_id LEFT JOIN tag t5_ ON t5_.id = e6_.tag_id INNER JOIN entry_tag e8_ ON e0_.id = e8_.entry_id INNER JOIN tag t7_ ON t7_.id = e8_.tag_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND t7_.name = ?) AND (e0_.is_draft = 0) AND (e0_.locale = 'ar') AND (e0_.published_at <= CURRENT_TIMESTAMP) AND (e0_.deleted_at IS NULL) AND (e0_.deleted_at IS NULL) GROUP BY e0_.id, e0_.published_at ORDER BY e0_.published_at DESC, e0_.id DESC LIMIT 20

[
  "(لا) القرآن"
]

SELECT
  e0_.id AS id_0
FROM
  entry e0_
  INNER JOIN content_type c1_ ON e0_.type_id = c1_.id
  LEFT JOIN collection c2_ ON e0_.collection_id = c2_.id
  AND (c2_.deleted_at IS NULL)
  AND (c2_.deleted_at IS NULL)
  LEFT JOIN entry_author e4_ ON e0_.id = e4_.entry_id
  LEFT JOIN author a3_ ON a3_.id = e4_.author_id
  AND (a3_.deleted_at IS NULL)
  AND (a3_.deleted_at IS NULL)
  LEFT JOIN entry_tag e6_ ON e0_.id = e6_.entry_id
  LEFT JOIN tag t5_ ON t5_.id = e6_.tag_id
  INNER JOIN entry_tag e8_ ON e0_.id = e8_.entry_id
  INNER JOIN tag t7_ ON t7_.id = e8_.tag_id
WHERE
  (
    (
      e0_.is_published = 1
      AND e0_.is_banned = 0
      AND (
        a3_.is_enabled = 1
        OR a3_.is_enabled IS NULL
      )
    )
    AND t7_.name = ?
  )
  AND (e0_.is_draft = 0)
  AND (e0_.locale = 'ar')
  AND (
    e0_.published_at <= CURRENT_TIMESTAMP
  )
  AND (e0_.deleted_at IS NULL)
  AND (e0_.deleted_at IS NULL)
GROUP BY
  e0_.id,
  e0_.published_at
ORDER BY
  e0_.published_at DESC,
  e0_.id DESC
LIMIT
  20

SELECT e0_.id AS id_0 FROM entry e0_ INNER JOIN content_type c1_ ON e0_.type_id = c1_.id LEFT JOIN collection c2_ ON e0_.collection_id = c2_.id AND (c2_.deleted_at IS NULL) AND (c2_.deleted_at IS NULL) LEFT JOIN entry_author e4_ ON e0_.id = e4_.entry_id LEFT JOIN author a3_ ON a3_.id = e4_.author_id AND (a3_.deleted_at IS NULL) AND (a3_.deleted_at IS NULL) LEFT JOIN entry_tag e6_ ON e0_.id = e6_.entry_id LEFT JOIN tag t5_ ON t5_.id = e6_.tag_id INNER JOIN entry_tag e8_ ON e0_.id = e8_.entry_id INNER JOIN tag t7_ ON t7_.id = e8_.tag_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND t7_.name = '(لا) القرآن') AND (e0_.is_draft = 0) AND (e0_.locale = 'ar') AND (e0_.published_at <= CURRENT_TIMESTAMP) AND (e0_.deleted_at IS NULL) AND (e0_.deleted_at IS NULL) GROUP BY e0_.id, e0_.published_at ORDER BY e0_.published_at DESC, e0_.id DESC LIMIT 20;