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
  c0_.id AS id_0
FROM
  content_type c0_
WHERE
  c0_.name = ?

SELECT c0_.id AS id_0 FROM content_type c0_ WHERE c0_.name = 'article';

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,
  e2_.id AS id_44,
  e2_.name AS name_45,
  e2_.value AS value_46,
  a3_.id AS id_47,
  a3_.title AS title_48,
  a3_.website AS website_49,
  a3_.email AS email_50,
  a3_.phone AS phone_51,
  a3_.fax AS fax_52,
  a3_.photo AS photo_53,
  a3_.is_enabled AS is_enabled_54,
  a3_.is_active AS is_active_55,
  a3_.popularity AS popularity_56,
  a3_.views_count AS views_count_57,
  a3_.created_at AS created_at_58,
  a3_.updated_at AS updated_at_59,
  a3_.deleted_at AS deleted_at_60,
  a3_.extra_fields AS extra_fields_61,
  a4_.name AS name_62,
  a4_.brief_biography AS brief_biography_63,
  a4_.full_biography AS full_biography_64,
  a4_.deleted_at AS deleted_at_65,
  a4_.locale AS locale_66,
  c5_.id AS id_67,
  c5_.lft AS lft_68,
  c5_.rgt AS rgt_69,
  c5_.level AS level_70,
  c5_.root_id AS root_id_71,
  c5_.created_at AS created_at_72,
  c5_.updated_at AS updated_at_73,
  c5_.deleted_at AS deleted_at_74,
  c6_.name AS name_75,
  c6_.description AS description_76,
  c6_.deleted_at AS deleted_at_77,
  c6_.locale AS locale_78,
  t7_.id AS id_79,
  t7_.name AS name_80,
  t7_.description AS description_81,
  c8_.id AS id_82,
  c8_.name AS name_83,
  c8_.description AS description_84,
  c8_.is_group AS is_group_85,
  c8_.image AS image_86,
  c8_.podcast_url AS podcast_url_87,
  c8_.is_published AS is_published_88,
  c8_.views_count AS views_count_89,
  c8_.popularity AS popularity_90,
  c8_.lft AS lft_91,
  c8_.rgt AS rgt_92,
  c8_.level AS level_93,
  c8_.root_id AS root_id_94,
  c8_.created_at AS created_at_95,
  c8_.updated_at AS updated_at_96,
  c8_.deleted_at AS deleted_at_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,
  u10_.id AS id_107,
  u10_.created_at AS created_at_108,
  u10_.deleted_at AS deleted_at_109,
  r11_.id AS id_110,
  r11_.classification AS classification_111,
  r11_.extension AS extension_112,
  r11_.mime_type AS mime_type_113,
  r11_.embeddable AS embeddable_114,
  r11_.priority AS priority_115,
  r11_.viewer_width AS viewer_width_116,
  r11_.viewer_height AS viewer_height_117,
  e0_.type_id AS type_id_118,
  e0_.source_id AS source_id_119,
  e0_.collection_id AS collection_id_120,
  e0_.comments_thread_id AS comments_thread_id_121,
  e0_.created_by AS created_by_122,
  e0_.updated_by AS updated_by_123,
  e2_.entry_id AS entry_id_124,
  a3_.country_id AS country_id_125,
  a3_.user_id AS user_id_126,
  a3_.created_by AS created_by_127,
  a3_.updated_by AS updated_by_128,
  a4_.id AS id_129,
  c5_.parent_id AS parent_id_130,
  c5_.created_by AS created_by_131,
  c5_.updated_by AS updated_by_132,
  c6_.id AS id_133,
  c8_.entries_type_id AS entries_type_id_134,
  c8_.author_id AS author_id_135,
  c8_.category_id AS category_id_136,
  c8_.parent_id AS parent_id_137,
  c8_.created_by AS created_by_138,
  c8_.updated_by AS updated_by_139,
  e9_.entry_id AS entry_id_140,
  e9_.type_id AS type_id_141,
  u10_.entry_id AS entry_id_142,
  u10_.user_id AS user_id_143
FROM
  entry e0_
  INNER JOIN content_type c1_ ON e0_.type_id = c1_.id
  LEFT JOIN entry_property e2_ ON e0_.id = e2_.entry_id
  LEFT JOIN entry_author e12_ ON e0_.id = e12_.entry_id
  LEFT JOIN author a3_ ON a3_.id = e12_.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_category e13_ ON e0_.id = e13_.entry_id
  LEFT JOIN category c5_ ON c5_.id = e13_.category_id
  AND (c5_.deleted_at IS NULL)
  AND (c5_.deleted_at IS NULL)
  LEFT JOIN category_translation c6_ ON c5_.id = c6_.id
  AND (c6_.locale = 'ar')
  AND (c6_.deleted_at IS NULL)
  AND (c6_.deleted_at IS NULL)
  LEFT JOIN entry_tag e14_ ON e0_.id = e14_.entry_id
  LEFT JOIN tag t7_ ON t7_.id = e14_.tag_id
  LEFT JOIN collection c8_ ON e0_.collection_id = c8_.id
  AND (c8_.deleted_at IS NULL)
  AND (c8_.deleted_at IS NULL)
  LEFT JOIN entry_resource e9_ ON e0_.id = e9_.entry_id
  AND (e9_.is_published = 1)
  LEFT JOIN user_favourite u10_ ON e0_.id = u10_.entry_id
  AND (u10_.deleted_at IS NULL)
  AND (u10_.deleted_at IS NULL)
  LEFT JOIN resource_type r11_ ON e9_.type_id = r11_.id
WHERE
  (
    (
      e0_.is_published = 1
      AND e0_.is_banned = 0
      AND (
        a3_.is_enabled = 1
        OR a3_.is_enabled IS NULL
      )
    )
    AND (
      e0_.local_id = ?
      AND e0_.type_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
  r11_.priority DESC,
  e9_.view_order ASC

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, e2_.id AS id_44, e2_.name AS name_45, e2_.value AS value_46, a3_.id AS id_47, a3_.title AS title_48, a3_.website AS website_49, a3_.email AS email_50, a3_.phone AS phone_51, a3_.fax AS fax_52, a3_.photo AS photo_53, a3_.is_enabled AS is_enabled_54, a3_.is_active AS is_active_55, a3_.popularity AS popularity_56, a3_.views_count AS views_count_57, a3_.created_at AS created_at_58, a3_.updated_at AS updated_at_59, a3_.deleted_at AS deleted_at_60, a3_.extra_fields AS extra_fields_61, a4_.name AS name_62, a4_.brief_biography AS brief_biography_63, a4_.full_biography AS full_biography_64, a4_.deleted_at AS deleted_at_65, a4_.locale AS locale_66, c5_.id AS id_67, c5_.lft AS lft_68, c5_.rgt AS rgt_69, c5_.level AS level_70, c5_.root_id AS root_id_71, c5_.created_at AS created_at_72, c5_.updated_at AS updated_at_73, c5_.deleted_at AS deleted_at_74, c6_.name AS name_75, c6_.description AS description_76, c6_.deleted_at AS deleted_at_77, c6_.locale AS locale_78, t7_.id AS id_79, t7_.name AS name_80, t7_.description AS description_81, c8_.id AS id_82, c8_.name AS name_83, c8_.description AS description_84, c8_.is_group AS is_group_85, c8_.image AS image_86, c8_.podcast_url AS podcast_url_87, c8_.is_published AS is_published_88, c8_.views_count AS views_count_89, c8_.popularity AS popularity_90, c8_.lft AS lft_91, c8_.rgt AS rgt_92, c8_.level AS level_93, c8_.root_id AS root_id_94, c8_.created_at AS created_at_95, c8_.updated_at AS updated_at_96, c8_.deleted_at AS deleted_at_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, u10_.id AS id_107, u10_.created_at AS created_at_108, u10_.deleted_at AS deleted_at_109, r11_.id AS id_110, r11_.classification AS classification_111, r11_.extension AS extension_112, r11_.mime_type AS mime_type_113, r11_.embeddable AS embeddable_114, r11_.priority AS priority_115, r11_.viewer_width AS viewer_width_116, r11_.viewer_height AS viewer_height_117, e0_.type_id AS type_id_118, e0_.source_id AS source_id_119, e0_.collection_id AS collection_id_120, e0_.comments_thread_id AS comments_thread_id_121, e0_.created_by AS created_by_122, e0_.updated_by AS updated_by_123, e2_.entry_id AS entry_id_124, a3_.country_id AS country_id_125, a3_.user_id AS user_id_126, a3_.created_by AS created_by_127, a3_.updated_by AS updated_by_128, a4_.id AS id_129, c5_.parent_id AS parent_id_130, c5_.created_by AS created_by_131, c5_.updated_by AS updated_by_132, c6_.id AS id_133, c8_.entries_type_id AS entries_type_id_134, c8_.author_id AS author_id_135, c8_.category_id AS category_id_136, c8_.parent_id AS parent_id_137, c8_.created_by AS created_by_138, c8_.updated_by AS updated_by_139, e9_.entry_id AS entry_id_140, e9_.type_id AS type_id_141, u10_.entry_id AS entry_id_142, u10_.user_id AS user_id_143 FROM entry e0_ INNER JOIN content_type c1_ ON e0_.type_id = c1_.id LEFT JOIN entry_property e2_ ON e0_.id = e2_.entry_id LEFT JOIN entry_author e12_ ON e0_.id = e12_.entry_id LEFT JOIN author a3_ ON a3_.id = e12_.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_category e13_ ON e0_.id = e13_.entry_id LEFT JOIN category c5_ ON c5_.id = e13_.category_id AND (c5_.deleted_at IS NULL) AND (c5_.deleted_at IS NULL) LEFT JOIN category_translation c6_ ON c5_.id = c6_.id AND (c6_.locale = 'ar') AND (c6_.deleted_at IS NULL) AND (c6_.deleted_at IS NULL) LEFT JOIN entry_tag e14_ ON e0_.id = e14_.entry_id LEFT JOIN tag t7_ ON t7_.id = e14_.tag_id LEFT JOIN collection c8_ ON e0_.collection_id = c8_.id AND (c8_.deleted_at IS NULL) AND (c8_.deleted_at IS NULL) LEFT JOIN entry_resource e9_ ON e0_.id = e9_.entry_id AND (e9_.is_published = 1) LEFT JOIN user_favourite u10_ ON e0_.id = u10_.entry_id AND (u10_.deleted_at IS NULL) AND (u10_.deleted_at IS NULL) LEFT JOIN resource_type r11_ ON e9_.type_id = r11_.id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND (e0_.local_id = '5165' AND e0_.type_id = 4)) 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 r11_.priority DESC, e9_.view_order ASC;