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 = '2857' 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 = 2857 AND ((t0.locale = 'ar') AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

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
WHERE
  t0.list_name = ?
LIMIT
  1

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 WHERE t0.list_name = 'videos' LIMIT 1;

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_.is_published = true
        OR c1_.is_published IS NULL
      )
      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 e0_.type_id = ?
        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
  e.id,
  _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_.is_published = true OR c1_.is_published IS NULL) 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 e0_.type_id = 14 AND a2_.id = 2857) 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 e.id, _type, _id
            ORDER BY _rank DESC
            LIMIT 20;

SELECT
  MAX(e0_.published_at) AS sclr_0,
  MAX(e0_.updated_at) AS sclr_1,
  COUNT(e0_.id) AS sclr_2,
  SUM(e0_.views_count) AS sclr_3,
  AVG(e0_.up_votes - e0_.down_votes) AS sclr_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.description AS description_7,
  c1_.is_group AS is_group_8,
  c1_.image AS image_9,
  c1_.podcast_url AS podcast_url_10,
  c1_.is_published AS is_published_11,
  c1_.views_count AS views_count_12,
  c1_.popularity AS popularity_13,
  c1_.lft AS lft_14,
  c1_.rgt AS rgt_15,
  c1_.level AS level_16,
  c1_.root_id AS root_id_17,
  c1_.created_at AS created_at_18,
  c1_.updated_at AS updated_at_19,
  c1_.deleted_at AS deleted_at_20,
  a2_.id AS id_21,
  a2_.title AS title_22,
  a2_.website AS website_23,
  a2_.email AS email_24,
  a2_.phone AS phone_25,
  a2_.fax AS fax_26,
  a2_.photo AS photo_27,
  a2_.is_enabled AS is_enabled_28,
  a2_.is_active AS is_active_29,
  a2_.popularity AS popularity_30,
  a2_.views_count AS views_count_31,
  a2_.created_at AS created_at_32,
  a2_.updated_at AS updated_at_33,
  a2_.deleted_at AS deleted_at_34,
  a2_.extra_fields AS extra_fields_35,
  c3_.id AS id_36,
  c3_.lft AS lft_37,
  c3_.rgt AS rgt_38,
  c3_.level AS level_39,
  c3_.root_id AS root_id_40,
  c3_.created_at AS created_at_41,
  c3_.updated_at AS updated_at_42,
  c3_.deleted_at AS deleted_at_43,
  c1_.entries_type_id AS entries_type_id_44,
  c1_.author_id AS author_id_45,
  c1_.category_id AS category_id_46,
  c1_.parent_id AS parent_id_47,
  c1_.created_by AS created_by_48,
  c1_.updated_by AS updated_by_49,
  a2_.country_id AS country_id_50,
  a2_.user_id AS user_id_51,
  a2_.created_by AS created_by_52,
  a2_.updated_by AS updated_by_53,
  c3_.parent_id AS parent_id_54,
  c3_.created_by AS created_by_55,
  c3_.updated_by AS updated_by_56
FROM
  collection c1_
  INNER JOIN entry e0_ ON c1_.id = e0_.collection_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)
  LEFT JOIN content_type c4_ ON c1_.entries_type_id = c4_.id
  LEFT JOIN author a2_ ON c1_.author_id = a2_.id
  AND (a2_.deleted_at IS NULL)
  AND (a2_.deleted_at IS NULL)
  LEFT JOIN category c3_ ON c1_.category_id = c3_.id
  AND (c3_.deleted_at IS NULL)
  AND (c3_.deleted_at IS NULL)
WHERE
  (
    (
      c1_.is_published = 1
      AND (
        a2_.is_enabled = 1
        OR a2_.is_enabled IS NULL
      )
    )
    AND c1_.id IN (?, ?, ?)
  )
  AND (
    c1_.is_published = true
    OR c1_.is_published IS NULL
  )
  AND (c1_.deleted_at IS NULL)
  AND (c1_.deleted_at IS NULL)
GROUP BY
  c1_.id,
  c1_.name,
  c1_.description,
  c1_.is_group,
  c1_.image,
  c1_.podcast_url,
  c1_.is_published,
  c1_.views_count,
  c1_.popularity,
  c1_.lft,
  c1_.rgt,
  c1_.level,
  c1_.root_id,
  c1_.created_at,
  c1_.updated_at,
  c1_.deleted_at,
  c1_.entries_type_id,
  c1_.author_id,
  c1_.category_id,
  c1_.parent_id,
  c1_.created_by,
  c1_.updated_by
ORDER BY
  sclr_0 DESC,
  c1_.id DESC

SELECT MAX(e0_.published_at) AS sclr_0, MAX(e0_.updated_at) AS sclr_1, COUNT(e0_.id) AS sclr_2, SUM(e0_.views_count) AS sclr_3, AVG(e0_.up_votes - e0_.down_votes) AS sclr_4, c1_.id AS id_5, c1_.name AS name_6, c1_.description AS description_7, c1_.is_group AS is_group_8, c1_.image AS image_9, c1_.podcast_url AS podcast_url_10, c1_.is_published AS is_published_11, c1_.views_count AS views_count_12, c1_.popularity AS popularity_13, c1_.lft AS lft_14, c1_.rgt AS rgt_15, c1_.level AS level_16, c1_.root_id AS root_id_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, c1_.deleted_at AS deleted_at_20, a2_.id AS id_21, a2_.title AS title_22, a2_.website AS website_23, a2_.email AS email_24, a2_.phone AS phone_25, a2_.fax AS fax_26, a2_.photo AS photo_27, a2_.is_enabled AS is_enabled_28, a2_.is_active AS is_active_29, a2_.popularity AS popularity_30, a2_.views_count AS views_count_31, a2_.created_at AS created_at_32, a2_.updated_at AS updated_at_33, a2_.deleted_at AS deleted_at_34, a2_.extra_fields AS extra_fields_35, c3_.id AS id_36, c3_.lft AS lft_37, c3_.rgt AS rgt_38, c3_.level AS level_39, c3_.root_id AS root_id_40, c3_.created_at AS created_at_41, c3_.updated_at AS updated_at_42, c3_.deleted_at AS deleted_at_43, c1_.entries_type_id AS entries_type_id_44, c1_.author_id AS author_id_45, c1_.category_id AS category_id_46, c1_.parent_id AS parent_id_47, c1_.created_by AS created_by_48, c1_.updated_by AS updated_by_49, a2_.country_id AS country_id_50, a2_.user_id AS user_id_51, a2_.created_by AS created_by_52, a2_.updated_by AS updated_by_53, c3_.parent_id AS parent_id_54, c3_.created_by AS created_by_55, c3_.updated_by AS updated_by_56 FROM collection c1_ INNER JOIN entry e0_ ON c1_.id = e0_.collection_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) LEFT JOIN content_type c4_ ON c1_.entries_type_id = c4_.id LEFT JOIN author a2_ ON c1_.author_id = a2_.id AND (a2_.deleted_at IS NULL) AND (a2_.deleted_at IS NULL) LEFT JOIN category c3_ ON c1_.category_id = c3_.id AND (c3_.deleted_at IS NULL) AND (c3_.deleted_at IS NULL) WHERE ((c1_.is_published = 1 AND (a2_.is_enabled = 1 OR a2_.is_enabled IS NULL)) AND c1_.id IN (162, 478, 383)) AND (c1_.is_published = true OR c1_.is_published IS NULL) AND (c1_.deleted_at IS NULL) AND (c1_.deleted_at IS NULL) GROUP BY c1_.id, c1_.name, c1_.description, c1_.is_group, c1_.image, c1_.podcast_url, c1_.is_published, c1_.views_count, c1_.popularity, c1_.lft, c1_.rgt, c1_.level, c1_.root_id, c1_.created_at, c1_.updated_at, c1_.deleted_at, c1_.entries_type_id, c1_.author_id, c1_.category_id, c1_.parent_id, c1_.created_by, c1_.updated_by ORDER BY sclr_0 DESC, c1_.id DESC;

SELECT
  e0_.id AS id_0
FROM
  entry e0_
WHERE
  (
    (
      e0_.collection_id = ?
      AND e0_.is_published = 1
      AND e0_.is_banned = 0
    )
    AND (
      e0_.view_order < ?
      OR (
        e0_.view_order = 65535
        AND e0_.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
  e0_.view_order DESC,
  e0_.id DESC
LIMIT
  2

SELECT e0_.id AS id_0 FROM entry e0_ WHERE ((e0_.collection_id = 383 AND e0_.is_published = 1 AND e0_.is_banned = 0) AND (e0_.view_order < 65535 OR (e0_.view_order = 65535 AND e0_.id < 36357))) 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 e0_.view_order DESC, e0_.id DESC LIMIT 2;

SELECT
  e0_.id AS id_0
FROM
  entry e0_
WHERE
  (
    (
      e0_.collection_id = ?
      AND e0_.is_published = 1
      AND e0_.is_banned = 0
    )
    AND (
      e0_.view_order > ?
      OR (
        e0_.view_order = 65535
        AND e0_.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
  e0_.view_order ASC,
  e0_.id ASC
LIMIT
  2

SELECT e0_.id AS id_0 FROM entry e0_ WHERE ((e0_.collection_id = 383 AND e0_.is_published = 1 AND e0_.is_banned = 0) AND (e0_.view_order > 65535 OR (e0_.view_order = 65535 AND e0_.id > 36357))) 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 e0_.view_order ASC, e0_.id ASC LIMIT 2;

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_.is_published = true
    OR c2_.is_published IS NULL
  )
  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)
WHERE
  (
    (
      e0_.is_published = 1
      AND e0_.is_banned = 0
      AND (
        a3_.is_enabled = 1
        OR a3_.is_enabled IS NULL
      )
    )
    AND e0_.id IN (?)
  )
  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

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_.is_published = true OR c2_.is_published IS NULL) 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) WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND e0_.id IN (36357)) 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;