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.title AS title_2,
  t0.website AS website_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.fax AS fax_6,
  t0.photo AS photo_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_active AS is_active_9,
  t0.popularity AS popularity_10,
  t0.views_count AS views_count_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.extra_fields AS extra_fields_15,
  t0.country_id AS country_id_16,
  t0.user_id AS user_id_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19
FROM
  author t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.website AS website_3, t0.email AS email_4, t0.phone AS phone_5, t0.fax AS fax_6, t0.photo AS photo_7, t0.is_enabled AS is_enabled_8, t0.is_active AS is_active_9, t0.popularity AS popularity_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.extra_fields AS extra_fields_15, t0.country_id AS country_id_16, t0.user_id AS user_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM author t0 WHERE t0.id = '3395' AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.brief_biography AS brief_biography_2,
  t0.full_biography AS full_biography_3,
  t0.deleted_at AS deleted_at_4,
  t0.locale AS locale_5,
  t0.id AS id_6,
  t7.id AS id_8,
  t7.title AS title_9,
  t7.website AS website_10,
  t7.email AS email_11,
  t7.phone AS phone_12,
  t7.fax AS fax_13,
  t7.photo AS photo_14,
  t7.is_enabled AS is_enabled_15,
  t7.is_active AS is_active_16,
  t7.popularity AS popularity_17,
  t7.views_count AS views_count_18,
  t7.created_at AS created_at_19,
  t7.updated_at AS updated_at_20,
  t7.deleted_at AS deleted_at_21,
  t7.extra_fields AS extra_fields_22,
  t7.country_id AS country_id_23,
  t7.user_id AS user_id_24,
  t7.created_by AS created_by_25,
  t7.updated_by AS updated_by_26
FROM
  author_translation t0
  LEFT JOIN author t7 ON t0.id = t7.id
  AND (
    (t7.deleted_at IS NULL)
    AND (t7.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.brief_biography AS brief_biography_2, t0.full_biography AS full_biography_3, t0.deleted_at AS deleted_at_4, t0.locale AS locale_5, t0.id AS id_6, t7.id AS id_8, t7.title AS title_9, t7.website AS website_10, t7.email AS email_11, t7.phone AS phone_12, t7.fax AS fax_13, t7.photo AS photo_14, t7.is_enabled AS is_enabled_15, t7.is_active AS is_active_16, t7.popularity AS popularity_17, t7.views_count AS views_count_18, t7.created_at AS created_at_19, t7.updated_at AS updated_at_20, t7.deleted_at AS deleted_at_21, t7.extra_fields AS extra_fields_22, t7.country_id AS country_id_23, t7.user_id AS user_id_24, t7.created_by AS created_by_25, t7.updated_by AS updated_by_26 FROM author_translation t0 LEFT JOIN author t7 ON t0.id = t7.id AND ((t7.deleted_at IS NULL) AND (t7.deleted_at IS NULL)) WHERE t0.id = 3395 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)
    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 a2_.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
  DATE(e.published_at),
  _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) 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 a2_.id = 3395) 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 DATE(e.published_at), _type, _id
            ORDER BY _rank DESC
            LIMIT 20;