Symfony Profiler

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)
WHERE
  (
    (
      e0_.is_published = 1
      AND e0_.is_banned = 0
      AND (
        a3_.is_enabled = 1
        OR a3_.is_enabled IS NULL
      )
    )
    AND e0_.is_exclusive = 1
    AND c1_.is_internal = 0
  )
  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
  5

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) WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND e0_.is_exclusive = 1 AND c1_.is_internal = 0) 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 5;

SELECT
  t0.id AS id_1,
  t0.type_name AS type_name_2,
  t0.title AS title_3,
  t0.theme AS theme_4,
  t0.properties AS properties_5,
  t0.is_published AS is_published_6,
  t0.block_id AS block_id_7
FROM
  page_composer_widget t0
WHERE
  t0.block_id = ?

SELECT t0.id AS id_1, t0.type_name AS type_name_2, t0.title AS title_3, t0.theme AS theme_4, t0.properties AS properties_5, t0.is_published AS is_published_6, t0.block_id AS block_id_7 FROM page_composer_widget t0 WHERE t0.block_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.col_number AS col_number_3,
  t0.zone_id AS zone_id_4
FROM
  page_composer_block t0
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.col_number AS col_number_3, t0.zone_id AS zone_id_4 FROM page_composer_block t0 WHERE t0.zone_id = 1;

SELECT
  e0_.id AS id_0,
  e0_.local_id AS local_id_1,
  e0_.title AS title_2,
  e0_.summary AS summary_3,
  e0_.content AS content_4,
  e0_.is_comments_enabled AS is_comments_enabled_5,
  e0_.is_exclusive AS is_exclusive_6,
  e0_.show_in_homepage AS show_in_homepage_7,
  e0_.is_draft AS is_draft_8,
  e0_.is_published AS is_published_9,
  e0_.published_at AS published_at_10,
  e0_.views_count AS views_count_11,
  e0_.up_votes AS up_votes_12,
  e0_.down_votes AS down_votes_13,
  e0_.shares AS shares_14,
  e0_.popularity AS popularity_15,
  e0_.created_at AS created_at_16,
  e0_.updated_at AS updated_at_17,
  e0_.deleted_at AS deleted_at_18,
  e0_.view_order AS view_order_19,
  e0_.reporting_reference_id AS reporting_reference_id_20,
  e0_.is_banned AS is_banned_21,
  e0_.is_immune AS is_immune_22,
  e0_.locale AS locale_23,
  c1_.id AS id_24,
  c1_.package AS package_25,
  c1_.name AS name_26,
  c1_.description AS description_27,
  c1_.display_name AS display_name_28,
  c1_.list_name AS list_name_29,
  c1_.is_internal AS is_internal_30,
  c1_.is_categorizable AS is_categorizable_31,
  c1_.is_fileable AS is_fileable_32,
  c1_.is_printable AS is_printable_33,
  c1_.is_embeddable AS is_embeddable_34,
  c1_.is_searchable AS is_searchable_35,
  c1_.is_queryable AS is_queryable_36,
  c1_.accepts_comments AS accepts_comments_37,
  c1_.has_authors AS has_authors_38,
  c1_.has_attachments AS has_attachments_39,
  c1_.has_source AS has_source_40,
  c1_.has_tags AS has_tags_41,
  c1_.has_summary AS has_summary_42,
  c1_.has_aggregates AS has_aggregates_43,
  c2_.id AS id_44,
  c2_.name AS name_45,
  c2_.description AS description_46,
  c2_.is_group AS is_group_47,
  c2_.image AS image_48,
  c2_.podcast_url AS podcast_url_49,
  c2_.is_published AS is_published_50,
  c2_.views_count AS views_count_51,
  c2_.popularity AS popularity_52,
  c2_.lft AS lft_53,
  c2_.rgt AS rgt_54,
  c2_.level AS level_55,
  c2_.root_id AS root_id_56,
  c2_.created_at AS created_at_57,
  c2_.updated_at AS updated_at_58,
  c2_.deleted_at AS deleted_at_59,
  a3_.id AS id_60,
  a3_.title AS title_61,
  a3_.website AS website_62,
  a3_.email AS email_63,
  a3_.phone AS phone_64,
  a3_.fax AS fax_65,
  a3_.photo AS photo_66,
  a3_.is_enabled AS is_enabled_67,
  a3_.is_active AS is_active_68,
  a3_.popularity AS popularity_69,
  a3_.views_count AS views_count_70,
  a3_.created_at AS created_at_71,
  a3_.updated_at AS updated_at_72,
  a3_.deleted_at AS deleted_at_73,
  a3_.extra_fields AS extra_fields_74,
  a4_.name AS name_75,
  a4_.brief_biography AS brief_biography_76,
  a4_.full_biography AS full_biography_77,
  a4_.deleted_at AS deleted_at_78,
  a4_.locale AS locale_79,
  e5_.id AS id_80,
  e5_.name AS name_81,
  e5_.value AS value_82,
  c6_.id AS id_83,
  c6_.lft AS lft_84,
  c6_.rgt AS rgt_85,
  c6_.level AS level_86,
  c6_.root_id AS root_id_87,
  c6_.created_at AS created_at_88,
  c6_.updated_at AS updated_at_89,
  c6_.deleted_at AS deleted_at_90,
  c7_.name AS name_91,
  c7_.description AS description_92,
  c7_.deleted_at AS deleted_at_93,
  c7_.locale AS locale_94,
  t8_.id AS id_95,
  t8_.name AS name_96,
  t8_.description AS description_97,
  e9_.id AS id_98,
  e9_.description AS description_99,
  e9_.path AS path_100,
  e9_.size_kb AS size_kb_101,
  e9_.properties AS properties_102,
  e9_.view_order AS view_order_103,
  e9_.is_published AS is_published_104,
  e9_.created_at AS created_at_105,
  e9_.updated_at AS updated_at_106,
  r10_.id AS id_107,
  r10_.classification AS classification_108,
  r10_.extension AS extension_109,
  r10_.mime_type AS mime_type_110,
  r10_.embeddable AS embeddable_111,
  r10_.priority AS priority_112,
  r10_.viewer_width AS viewer_width_113,
  r10_.viewer_height AS viewer_height_114,
  e0_.type_id AS type_id_115,
  e0_.source_id AS source_id_116,
  e0_.collection_id AS collection_id_117,
  e0_.comments_thread_id AS comments_thread_id_118,
  e0_.created_by AS created_by_119,
  e0_.updated_by AS updated_by_120,
  c2_.entries_type_id AS entries_type_id_121,
  c2_.author_id AS author_id_122,
  c2_.category_id AS category_id_123,
  c2_.parent_id AS parent_id_124,
  c2_.created_by AS created_by_125,
  c2_.updated_by AS updated_by_126,
  a3_.country_id AS country_id_127,
  a3_.user_id AS user_id_128,
  a3_.created_by AS created_by_129,
  a3_.updated_by AS updated_by_130,
  a4_.id AS id_131,
  e5_.entry_id AS entry_id_132,
  c6_.parent_id AS parent_id_133,
  c6_.created_by AS created_by_134,
  c6_.updated_by AS updated_by_135,
  c7_.id AS id_136,
  e9_.entry_id AS entry_id_137,
  e9_.type_id AS type_id_138
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 e11_ ON e0_.id = e11_.entry_id
  LEFT JOIN author a3_ ON a3_.id = e11_.author_id
  AND (a3_.deleted_at IS NULL)
  AND (a3_.deleted_at IS NULL)
  LEFT JOIN author_translation a4_ ON a3_.id = a4_.id
  AND (a4_.locale = 'ar')
  AND (a4_.deleted_at IS NULL)
  AND (a4_.deleted_at IS NULL)
  LEFT JOIN entry_property e5_ ON e0_.id = e5_.entry_id
  LEFT JOIN entry_category e12_ ON e0_.id = e12_.entry_id
  LEFT JOIN category c6_ ON c6_.id = e12_.category_id
  AND (c6_.deleted_at IS NULL)
  AND (c6_.deleted_at IS NULL)
  LEFT JOIN category_translation c7_ ON c6_.id = c7_.id
  AND (c7_.locale = 'ar')
  AND (c7_.deleted_at IS NULL)
  AND (c7_.deleted_at IS NULL)
  LEFT JOIN entry_tag e13_ ON e0_.id = e13_.entry_id
  LEFT JOIN tag t8_ ON t8_.id = e13_.tag_id
  LEFT JOIN entry_resource e9_ ON e0_.id = e9_.entry_id
  AND (e9_.is_published = 1)
  LEFT JOIN resource_type r10_ ON e9_.type_id = r10_.id
  LEFT JOIN user_favourite u14_ ON e0_.id = u14_.entry_id
  AND (u14_.deleted_at IS NULL)
  AND (u14_.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)
ORDER BY
  e0_.published_at DESC,
  e0_.id DESC,
  r10_.priority DESC

SELECT e0_.id AS id_0, e0_.local_id AS local_id_1, e0_.title AS title_2, e0_.summary AS summary_3, e0_.content AS content_4, e0_.is_comments_enabled AS is_comments_enabled_5, e0_.is_exclusive AS is_exclusive_6, e0_.show_in_homepage AS show_in_homepage_7, e0_.is_draft AS is_draft_8, e0_.is_published AS is_published_9, e0_.published_at AS published_at_10, e0_.views_count AS views_count_11, e0_.up_votes AS up_votes_12, e0_.down_votes AS down_votes_13, e0_.shares AS shares_14, e0_.popularity AS popularity_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17, e0_.deleted_at AS deleted_at_18, e0_.view_order AS view_order_19, e0_.reporting_reference_id AS reporting_reference_id_20, e0_.is_banned AS is_banned_21, e0_.is_immune AS is_immune_22, e0_.locale AS locale_23, c1_.id AS id_24, c1_.package AS package_25, c1_.name AS name_26, c1_.description AS description_27, c1_.display_name AS display_name_28, c1_.list_name AS list_name_29, c1_.is_internal AS is_internal_30, c1_.is_categorizable AS is_categorizable_31, c1_.is_fileable AS is_fileable_32, c1_.is_printable AS is_printable_33, c1_.is_embeddable AS is_embeddable_34, c1_.is_searchable AS is_searchable_35, c1_.is_queryable AS is_queryable_36, c1_.accepts_comments AS accepts_comments_37, c1_.has_authors AS has_authors_38, c1_.has_attachments AS has_attachments_39, c1_.has_source AS has_source_40, c1_.has_tags AS has_tags_41, c1_.has_summary AS has_summary_42, c1_.has_aggregates AS has_aggregates_43, c2_.id AS id_44, c2_.name AS name_45, c2_.description AS description_46, c2_.is_group AS is_group_47, c2_.image AS image_48, c2_.podcast_url AS podcast_url_49, c2_.is_published AS is_published_50, c2_.views_count AS views_count_51, c2_.popularity AS popularity_52, c2_.lft AS lft_53, c2_.rgt AS rgt_54, c2_.level AS level_55, c2_.root_id AS root_id_56, c2_.created_at AS created_at_57, c2_.updated_at AS updated_at_58, c2_.deleted_at AS deleted_at_59, a3_.id AS id_60, a3_.title AS title_61, a3_.website AS website_62, a3_.email AS email_63, a3_.phone AS phone_64, a3_.fax AS fax_65, a3_.photo AS photo_66, a3_.is_enabled AS is_enabled_67, a3_.is_active AS is_active_68, a3_.popularity AS popularity_69, a3_.views_count AS views_count_70, a3_.created_at AS created_at_71, a3_.updated_at AS updated_at_72, a3_.deleted_at AS deleted_at_73, a3_.extra_fields AS extra_fields_74, a4_.name AS name_75, a4_.brief_biography AS brief_biography_76, a4_.full_biography AS full_biography_77, a4_.deleted_at AS deleted_at_78, a4_.locale AS locale_79, e5_.id AS id_80, e5_.name AS name_81, e5_.value AS value_82, c6_.id AS id_83, c6_.lft AS lft_84, c6_.rgt AS rgt_85, c6_.level AS level_86, c6_.root_id AS root_id_87, c6_.created_at AS created_at_88, c6_.updated_at AS updated_at_89, c6_.deleted_at AS deleted_at_90, c7_.name AS name_91, c7_.description AS description_92, c7_.deleted_at AS deleted_at_93, c7_.locale AS locale_94, t8_.id AS id_95, t8_.name AS name_96, t8_.description AS description_97, e9_.id AS id_98, e9_.description AS description_99, e9_.path AS path_100, e9_.size_kb AS size_kb_101, e9_.properties AS properties_102, e9_.view_order AS view_order_103, e9_.is_published AS is_published_104, e9_.created_at AS created_at_105, e9_.updated_at AS updated_at_106, r10_.id AS id_107, r10_.classification AS classification_108, r10_.extension AS extension_109, r10_.mime_type AS mime_type_110, r10_.embeddable AS embeddable_111, r10_.priority AS priority_112, r10_.viewer_width AS viewer_width_113, r10_.viewer_height AS viewer_height_114, e0_.type_id AS type_id_115, e0_.source_id AS source_id_116, e0_.collection_id AS collection_id_117, e0_.comments_thread_id AS comments_thread_id_118, e0_.created_by AS created_by_119, e0_.updated_by AS updated_by_120, c2_.entries_type_id AS entries_type_id_121, c2_.author_id AS author_id_122, c2_.category_id AS category_id_123, c2_.parent_id AS parent_id_124, c2_.created_by AS created_by_125, c2_.updated_by AS updated_by_126, a3_.country_id AS country_id_127, a3_.user_id AS user_id_128, a3_.created_by AS created_by_129, a3_.updated_by AS updated_by_130, a4_.id AS id_131, e5_.entry_id AS entry_id_132, c6_.parent_id AS parent_id_133, c6_.created_by AS created_by_134, c6_.updated_by AS updated_by_135, c7_.id AS id_136, e9_.entry_id AS entry_id_137, e9_.type_id AS type_id_138 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 e11_ ON e0_.id = e11_.entry_id LEFT JOIN author a3_ ON a3_.id = e11_.author_id AND (a3_.deleted_at IS NULL) AND (a3_.deleted_at IS NULL) LEFT JOIN author_translation a4_ ON a3_.id = a4_.id AND (a4_.locale = 'ar') AND (a4_.deleted_at IS NULL) AND (a4_.deleted_at IS NULL) LEFT JOIN entry_property e5_ ON e0_.id = e5_.entry_id LEFT JOIN entry_category e12_ ON e0_.id = e12_.entry_id LEFT JOIN category c6_ ON c6_.id = e12_.category_id AND (c6_.deleted_at IS NULL) AND (c6_.deleted_at IS NULL) LEFT JOIN category_translation c7_ ON c6_.id = c7_.id AND (c7_.locale = 'ar') AND (c7_.deleted_at IS NULL) AND (c7_.deleted_at IS NULL) LEFT JOIN entry_tag e13_ ON e0_.id = e13_.entry_id LEFT JOIN tag t8_ ON t8_.id = e13_.tag_id LEFT JOIN entry_resource e9_ ON e0_.id = e9_.entry_id AND (e9_.is_published = 1) LEFT JOIN resource_type r10_ ON e9_.type_id = r10_.id LEFT JOIN user_favourite u14_ ON e0_.id = u14_.entry_id AND (u14_.deleted_at IS NULL) AND (u14_.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 (36378, 36377, 36376, 36375, 36373)) 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_.published_at DESC, e0_.id DESC, r10_.priority DESC;

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
  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.title AS title_2,
  t0.name AS name_3,
  t0.page_id AS page_id_4,
  t0.container_id AS container_id_5
FROM
  page_composer_zone t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.page_id AS page_id_4, t0.container_id AS container_id_5 FROM page_composer_zone t0 WHERE t0.page_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.is_system AS is_system_4,
  t0.template_path AS template_path_5
FROM
  page_composer_page t0
WHERE
  t0.template_path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_system AS is_system_4, t0.template_path AS template_path_5 FROM page_composer_page t0 WHERE t0.template_path = 'Home/newindex.html.twig' 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

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;