Symfony Profiler

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
  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.lft AS lft_2,
  t0.rgt AS rgt_3,
  t0.level AS level_4,
  t0.root_id AS root_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.parent_id AS parent_id_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11
FROM
  category t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.lft AS lft_2, t0.rgt AS rgt_3, t0.level AS level_4, t0.root_id AS root_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM category t0 WHERE t0.id = '463' AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.deleted_at AS deleted_at_3,
  t0.locale AS locale_4,
  t0.id AS id_5,
  t6.id AS id_7,
  t6.lft AS lft_8,
  t6.rgt AS rgt_9,
  t6.level AS level_10,
  t6.root_id AS root_id_11,
  t6.created_at AS created_at_12,
  t6.updated_at AS updated_at_13,
  t6.deleted_at AS deleted_at_14,
  t6.parent_id AS parent_id_15,
  t6.created_by AS created_by_16,
  t6.updated_by AS updated_by_17
FROM
  category_translation t0
  LEFT JOIN category t6 ON t0.id = t6.id
  AND (
    (t6.deleted_at IS NULL)
    AND (t6.deleted_at IS NULL)
  )
WHERE
  t0.id = ?
  AND (
    (t0.locale = 'ar')
    AND (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.description AS description_2, t0.deleted_at AS deleted_at_3, t0.locale AS locale_4, t0.id AS id_5, t6.id AS id_7, t6.lft AS lft_8, t6.rgt AS rgt_9, t6.level AS level_10, t6.root_id AS root_id_11, t6.created_at AS created_at_12, t6.updated_at AS updated_at_13, t6.deleted_at AS deleted_at_14, t6.parent_id AS parent_id_15, t6.created_by AS created_by_16, t6.updated_by AS updated_by_17 FROM category_translation t0 LEFT JOIN category t6 ON t0.id = t6.id AND ((t6.deleted_at IS NULL) AND (t6.deleted_at IS NULL)) WHERE t0.id = 463 AND ((t0.locale = 'ar') AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

SELECT
  CASE WHEN e.collection_id IS NOT NULL THEN
    'collection'
  ELSE
    'entry'
  END as _type,
  CASE WHEN e.collection_id IS NOT NULL THEN
    e.collection_id
  ELSE
    e.id
  END as _id,
  COUNT(e.id) AS entriesCount,
  e.id as activeEntryId,
  e.view_order,
  DATE(e.published_at) as publishDate,
  _rank
FROM
  (
    SELECT
      e0_.id AS id,
      e0_.collection_id AS collection_id,
      e0_.published_at AS published_at,
      e0_.view_order AS view_order,
      e0_.published_at AS _rank
    FROM
      entry e0_
      LEFT JOIN collection c1_ ON e0_.collection_id = c1_.id
      AND (c1_.deleted_at IS NULL)
      AND (c1_.deleted_at IS NULL)
      LEFT JOIN entry_author e3_ ON e0_.id = e3_.entry_id
      LEFT JOIN author a2_ ON a2_.id = e3_.author_id
      AND (a2_.deleted_at IS NULL)
      AND (a2_.deleted_at IS NULL)
      LEFT JOIN entry_category e5_ ON e0_.id = e5_.entry_id
      LEFT JOIN category c4_ ON c4_.id = e5_.category_id
      AND (c4_.deleted_at IS NULL)
      AND (c4_.deleted_at IS NULL)
    WHERE
      (
        (
          e0_.is_published = 1
          AND e0_.is_banned = 0
        )
        AND (
          c1_.is_published = 1
          OR c1_.is_published IS NULL
        )
        AND (
          a2_.is_enabled = 1
          OR a2_.is_enabled IS NULL
        )
        AND c4_.id = ?
      )
      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)
    ORDER BY
      _rank DESC,
      e0_.id DESC
    LIMIT
      1500
  ) e
GROUP BY
  _type,
  _id
ORDER BY
  _rank DESC
LIMIT
  20

SELECT 
                CASE WHEN e.collection_id IS NOT NULL THEN 'collection'    ELSE 'entry' END as _type,
                CASE WHEN e.collection_id IS NOT NULL THEN e.collection_id ELSE e.id    END as _id,
                COUNT(e.id) AS entriesCount, e.id as activeEntryId, e.view_order, DATE(e.published_at) as publishDate, _rank
            FROM (SELECT e0_.id AS id, e0_.collection_id AS collection_id, e0_.published_at AS published_at, e0_.view_order AS view_order, e0_.published_at AS _rank FROM entry e0_ LEFT JOIN collection c1_ ON e0_.collection_id = c1_.id AND (c1_.deleted_at IS NULL) AND (c1_.deleted_at IS NULL) LEFT JOIN entry_author e3_ ON e0_.id = e3_.entry_id LEFT JOIN author a2_ ON a2_.id = e3_.author_id AND (a2_.deleted_at IS NULL) AND (a2_.deleted_at IS NULL) LEFT JOIN entry_category e5_ ON e0_.id = e5_.entry_id LEFT JOIN category c4_ ON c4_.id = e5_.category_id AND (c4_.deleted_at IS NULL) AND (c4_.deleted_at IS NULL) WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0) AND (c1_.is_published = 1 OR c1_.is_published IS NULL) AND (a2_.is_enabled = 1 OR a2_.is_enabled IS NULL) AND c4_.id = '463') 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) ORDER BY _rank DESC, e0_.id DESC LIMIT 1500) e
            GROUP BY _type, _id
            ORDER BY _rank DESC
            LIMIT 20;