Query Metrics

148 Database Queries
44 Different statements
833.02 ms Query time
1 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time Count Info
235.42 ms
(28.26%)
5
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
Parameters:
[
  36303
  36295
  36282
]
79.73 ms
(9.57%)
4
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_.view_order ASC, e0_.id ASC, r10_.priority DESC
Parameters:
[
  36301
  36290
  36272
  36251
]
72.29 ms
(8.68%)
1
"COMMIT"
Parameters:
[]
62.85 ms
(7.54%)
7
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 c1_.list_name = ? AND e0_.id NOT 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 LIMIT 3
Parameters:
[
  "researches"
  36347
]
50.53 ms
(6.07%)
14
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
Parameters:
[
  36347
]
46.98 ms
(5.64%)
2
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_.view_order ASC, e0_.id ASC, r10_.priority DESC
Parameters:
[
  36305
  36302
  36298
]
29.16 ms
(3.50%)
10
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) INNER JOIN entry_property e5_ ON e0_.id = e5_.entry_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND (e5_.name = ? AND e5_.value = ?) AND c1_.list_name = ?) 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 4
Parameters:
[
  "is_pinned"
  "1"
  "articles"
]
28.75 ms
(3.45%)
10
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) INNER JOIN entry_property e5_ ON e0_.id = e5_.entry_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND (e5_.name = ? AND e5_.value = ?) AND c1_.list_name = ?) 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
Parameters:
[
  "is_pinned"
  "1"
  "articles"
]
27.45 ms
(3.29%)
4
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
Parameters:
[
  36378
  36323
  36308
  36309
]
22.57 ms
(2.71%)
5
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_.view_order ASC, e0_.id ASC, r10_.priority DESC
Parameters:
[
  36309
]
21.48 ms
(2.58%)
2
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_.view_order ASC, e0_.id ASC, r10_.priority DESC
Parameters:
[
  36323
  36378
]
19.22 ms
(2.31%)
25
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.url AS url_2, n0_.target AS target_3, n0_.tag AS tag_4, n0_.icon AS icon_5, n0_.icon_type AS icon_type_6, n0_.sortorder AS sortorder_7, n0_.published AS published_8, n0_.is_system AS is_system_9, n0_.parent AS parent_10 FROM navigation_menu n0_ WHERE n0_.published = 1 AND n0_.parent = ? ORDER BY n0_.sortorder ASC
Parameters:
[
  1
]
18.80 ms
(2.26%)
8
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) INNER JOIN entry_property e5_ ON e0_.id = e5_.entry_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND c2_.id = ? AND (e5_.name = ? AND e5_.value = ?)) 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 ORDER BY e0_.view_order ASC, e0_.id ASC LIMIT 4
Parameters:
[
  "656"
  "is_pinned"
  "1"
]
17.22 ms
(2.07%)
3
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
Parameters:
[
  36303
  36225
]
16.62 ms
(1.99%)
8
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) INNER JOIN entry_property e5_ ON e0_.id = e5_.entry_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND c2_.id = ? AND (e5_.name = ? AND e5_.value = ?)) 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 ORDER BY e0_.view_order ASC, e0_.id ASC
Parameters:
[
  "656"
  "is_pinned"
  "1"
]
14.54 ms
(1.75%)
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
Parameters:
[
  36310
  36299
  36286
  36276
  36262
  36254
  36241
  36238
]
11.45 ms
(1.37%)
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
Parameters:
[
  36378
  36323
  36308
  36309
  36307
]
8.66 ms
(1.04%)
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 c2_.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) GROUP BY e0_.id ORDER BY e0_.view_order ASC, e0_.id ASC LIMIT 4
Parameters:
[
  "660"
]
7.54 ms
(0.91%)
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
Parameters:
[
  36381
  36380
  36367
  36360
  36358
  36349
  36043
]
6.48 ms
(0.78%)
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_.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 c2_.id = ? AND e0_.id NOT 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 ORDER BY e0_.view_order ASC, e0_.id ASC LIMIT 3
Parameters:
[
  "656"
  36309
]
6.23 ms
(0.75%)
6
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.name = ? LIMIT 1
Parameters:
[
  "article"
]
3.36 ms
(0.40%)
1
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) INNER JOIN entry_property e5_ ON e0_.id = e5_.entry_id INNER JOIN entry_property e6_ ON e0_.id = e6_.entry_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND c1_.id = ? AND (e5_.name = ? AND e5_.value = ?) AND (e6_.name = ? AND e6_.value = ?)) 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 10
Parameters:
[
  11
  "show_in_newsbar"
  "1"
  "is_pinned"
  "1"
]
2.66 ms
(0.32%)
1
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) INNER JOIN entry_property e5_ ON e0_.id = e5_.entry_id INNER JOIN entry_property e6_ ON e0_.id = e6_.entry_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND c1_.id = ? AND (e5_.name = ? AND e5_.value = ?) AND (e6_.name = ? AND e6_.value = ?)) 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
Parameters:
[
  11
  "show_in_newsbar"
  "1"
  "is_pinned"
  "1"
]
2.33 ms
(0.28%)
1
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 c2_.id = ? AND e0_.id NOT 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 ORDER BY e0_.view_order ASC, e0_.id ASC LIMIT 2
Parameters:
[
  "652"
  36323
  36378
]
2.31 ms
(0.28%)
1
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) INNER JOIN entry_property e5_ ON e0_.id = e5_.entry_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND c1_.id = ? AND (e5_.name = ? AND e5_.value = ?) AND e0_.id NOT 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 LIMIT 8
Parameters:
[
  11
  "show_in_newsbar"
  "1"
  36345
  36342
]
2.23 ms
(0.27%)
1
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) LEFT JOIN entry_tag e6_ ON e0_.id = e6_.entry_id LEFT JOIN tag t5_ ON t5_.id = e6_.tag_id INNER JOIN entry_tag e8_ ON e0_.id = e8_.entry_id INNER JOIN tag t7_ ON t7_.id = e8_.tag_id WHERE ((e0_.is_published = 1 AND e0_.is_banned = 0 AND (a3_.is_enabled = 1 OR a3_.is_enabled IS NULL)) AND t7_.name = ?) 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 20
Parameters:
[
  "التفسير الموضوعي"
]
1.61 ms
(0.19%)
1
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
Parameters:
[]
1.55 ms
(0.19%)
2
SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_
Parameters:
[]
1.52 ms
(0.18%)
1
SELECT c0_.name AS name_0, c0_.list_name AS list_name_1, COUNT(DISTINCT e1_.id) AS sclr_2 FROM content_type c0_ INNER JOIN entry e1_ ON (c0_.id = e1_.type_id) AND (e1_.is_draft = 0) AND (e1_.locale = 'ar') AND (e1_.published_at <= CURRENT_TIMESTAMP) AND (e1_.deleted_at IS NULL) AND (e1_.deleted_at IS NULL) INNER JOIN entry_tag e3_ ON e1_.id = e3_.entry_id INNER JOIN tag t2_ ON t2_.id = e3_.tag_id LEFT JOIN entry_author e5_ ON e1_.id = e5_.entry_id LEFT JOIN author a4_ ON a4_.id = e5_.author_id AND (a4_.deleted_at IS NULL) AND (a4_.deleted_at IS NULL) WHERE e1_.is_published = 1 AND e1_.is_banned = 0 AND (a4_.is_enabled = 1 OR a4_.is_enabled IS NULL) AND t2_.id = ? GROUP BY c0_.id ORDER BY sclr_2 DESC
Parameters:
[
  2088
]
1.01 ms
(0.12%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM tag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "التفسير الموضوعي"
]
0.96 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.type_id AS type_id_4 FROM content_type_tags t0 WHERE t0.type_id IS NULL
Parameters:
[]
0.93 ms
(0.11%)
1
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 INNER JOIN content_type_tags_category ON t0.id = content_type_tags_category.category_id WHERE content_type_tags_category.content_type_tags_id = ? AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL))
Parameters:
[
  1
]
0.93 ms
(0.11%)
1
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))
Parameters:
[
  374
]
0.92 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM tag t0 INNER JOIN content_type_tags_tag ON t0.id = content_type_tags_tag.tag_id WHERE content_type_tags_tag.content_type_tags_id = ?
Parameters:
[
  1
]
0.92 ms
(0.11%)
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
Parameters:
[]
0.91 ms
(0.11%)
1
UPDATE ads_impression SET imps = ? WHERE id = ?
Parameters:
[
  94
  8958
]
0.83 ms
(0.10%)
1
SELECT MIN(a0_.id) AS sclr_0 FROM ads_banner a0_ INNER JOIN ads_banner_state a1_ ON a0_.id = a1_.banner_id INNER JOIN ads_campaigns a2_ ON a1_.campaign_id = a2_.id WHERE a0_.active = ? AND a1_.zone_id = ? AND a2_.active = ? ORDER BY a1_.id DESC
Parameters:
[
  1
  1
  1
]
0.70 ms
(0.08%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.link AS link_2, a0_.active AS active_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.banner_name AS banner_name_6 FROM ads_banner a0_ INNER JOIN ads_banner_state a1_ ON a0_.id = a1_.banner_id INNER JOIN ads_campaigns a2_ ON a1_.campaign_id = a2_.id WHERE a0_.id >= ? AND a0_.active = 1 AND a1_.zone_id = ? ORDER BY a0_.id ASC LIMIT 1
Parameters:
[
  5
  1
]
0.67 ms
(0.08%)
1
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.clicks AS clicks_3, t0.imps AS imps_4, t0.bannerstate_id AS bannerstate_id_5 FROM ads_impression t0 WHERE t0.bannerstate_id = ? AND t0.start_date = ? LIMIT 1
Parameters:
[
  5
  "2025-07-04 10:00:00"
]
0.65 ms
(0.08%)
1
SELECT MAX(a0_.id) AS sclr_0 FROM ads_banner a0_ INNER JOIN ads_banner_state a1_ ON a0_.id = a1_.banner_id INNER JOIN ads_campaigns a2_ ON a1_.campaign_id = a2_.id WHERE a0_.active = ? AND a1_.zone_id = ? AND a2_.active = ? ORDER BY a1_.id DESC
Parameters:
[
  1
  1
  1
]
0.58 ms
(0.07%)
1
SELECT t0.id AS id_1, t0.date_time AS date_time_2, t0.banner_id AS banner_id_3, t0.zone_id AS zone_id_4, t0.campaign_id AS campaign_id_5 FROM ads_banner_state t0 WHERE t0.banner_id = ? ORDER BY t0.id ASC
Parameters:
[
  5
]
0.58 ms
(0.07%)
1
SELECT t0.id AS id_1, t0.zone_key AS zone_key_2, t0.name AS name_3, t0.width AS width_4, t0.height AS height_5, t0.refresh_after AS refresh_after_6, t0.active AS active_7, t0.is_system AS is_system_8 FROM ads_zones t0 WHERE t0.zone_key = ? LIMIT 1
Parameters:
[
  "lm1"
]
0.55 ms
(0.07%)
1
SELECT t0.id AS id_1, t0.zone_key AS zone_key_2, t0.name AS name_3, t0.width AS width_4, t0.height AS height_5, t0.refresh_after AS refresh_after_6, t0.active AS active_7, t0.is_system AS is_system_8 FROM ads_zones t0 WHERE t0.zone_key = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "lm1"
  1
]
0.37 ms
(0.04%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
tq doctrine.orm.tq_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Rawafed\UserBundle\Entity\User 2
App\Entity\ContentTypeTags 1
Rawafed\ContentOrganizationBundle\Entity\Tag 1
Rawafed\ContentOrganizationBundle\Entity\Category 1
Rawafed\ContentOrganizationBundle\Entity\CategoryTranslation 1

tq entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
Rawafed\SecurityBundle\Entity\Role No errors.
Rawafed\SecurityBundle\Entity\RoleRoute No errors.
Rawafed\UserBundle\Entity\Group No errors.
Rawafed\ContentManagementBundle\Entity\ContentType No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsMessage No errors.
FOS\UserBundle\Model\User No errors.
Rawafed\UserBundle\Entity\User
  • The field Rawafed\UserBundle\Entity\User#userProfile is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Rawafed\CommonsBundle\Entity\UserProfile#user does not contain the required 'inversedBy="userProfile"' attribute.
Rawafed\CommentsBundle\Entity\Comment No errors.
Rawafed\RuntimeConfigBundle\Entity\Parameter No errors.
Rawafed\ContentOrganizationBundle\Entity\Collection No errors.
Rawafed\JobsListBundle\Entity\Job No errors.
Rawafed\ContentOrganizationBundle\Entity\Tag No errors.
Rawafed\ContentManagementBundle\Entity\Entry No errors.
Rawafed\AuthorsBundle\Entity\Author No errors.
Rawafed\AuthorsBundle\Entity\AuthorTranslation No errors.
Rawafed\ContentManagementBundle\Entity\EntryProperty No errors.
Rawafed\ContentOrganizationBundle\Entity\Category No errors.
Rawafed\ContentOrganizationBundle\Entity\CategoryTranslation No errors.
Rawafed\ContentManagementBundle\Entity\EntryResource No errors.
Rawafed\ContentManagementBundle\Entity\ResourceType No errors.
Rawafed\ContentManagementBundle\Entity\UserFavourite No errors.
Rawafed\ContentManagementBundle\Entity\ContentSource No errors.
Rawafed\CommentsBundle\Entity\CommentsThread No errors.
Rawafed\CommonsBundle\Entity\Country No errors.
Rawafed\ContentOrganizationBundle\Entity\Aggregate No errors.
Rawafed\ContentManagementBundle\Entity\EntryRelationship No errors.
Rawafed\ContentManagementBundle\Entity\RelatedLink No errors.
Rawafed\ContentManagementBundle\Entity\EntrySocialPublisher No errors.
Rawafed\ContentManagementBundle\Entity\EntryCounters No errors.
Rawafed\ContentOrganizationBundle\Entity\CollectionSocialPublisher No errors.
Rawafed\ContentManagementBundle\Entity\EntryResourceUserProperty No errors.
Rawafed\NavigationBundle\Entity\NavigationMenu No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsMessageReply No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsCategory No errors.
Rawafed\HWIFOSUserBundle\Entity\HWIUserExtraFields No errors.
Rawafed\CommonsBundle\Entity\UserProfile No errors.
Rawafed\CommentsBundle\Entity\CommentLike No errors.
Rawafed\RuntimeConfigBundle\Entity\ParameterGroup No errors.
Rawafed\RuntimeConfigBundle\Entity\ParameterTranslation No errors.
Rawafed\JobsListBundle\Entity\JobStatus No errors.
Rawafed\JobsListBundle\Entity\JobParameter No errors.
Rawafed\JobsListBundle\Entity\JobItem No errors.
Rawafed\ContentManagementBundle\Entity\ContentSourceTranslation No errors.
Rawafed\CommonsBundle\Entity\City No errors.
Rawafed\CommonsBundle\Entity\CountryTranslation No errors.
App\Entity\BestAuthor No errors.
App\Entity\ChosenEntry No errors.
App\Entity\ContentTypeTags No errors.
Rawafed\CommonsBundle\Entity\ProfileInterestsThread No errors.
Rawafed\CommonsBundle\Entity\Timezone No errors.
Rawafed\CommonsBundle\Entity\Group No errors.
Rawafed\CommonsBundle\Entity\HWIUserExtraFields No errors.
Rawafed\CommonsBundle\Entity\User No errors.
Rawafed\CommonsBundle\Entity\UserTitle No errors.
Rawafed\CommonsBundle\Entity\UserTitleTranslation No errors.
Rawafed\CommonsBundle\Entity\ViewsIntermediate No errors.
Rawafed\AdminBundle\Entity\AdminBundle No errors.
Rawafed\AdminBundle\Entity\Favorite No errors.
Rawafed\AdminBundle\Entity\AdminSidemenu No errors.
Rawafed\ContactFormsBundle\Entity\ContactUsEmailRecipient No errors.
Rawafed\ReportViewerBundle\Entity\ReportviewerCache No errors.
Rawafed\ContentManagementBundle\Entity\EntryBookmark No errors.
Rawafed\ContentManagementBundle\Entity\EntryRate No errors.
Rawafed\ContentManagementBundle\Entity\TopEntries No errors.
Rawafed\RuntimeConfigBundle\Entity\ParameterGroupTranslation No errors.
Rawafed\AdvancedSeoBundle\Entity\TermType No errors.
Rawafed\AdvancedSeoBundle\Entity\Term No errors.
Rawafed\NewsletterBundle\Entity\Newsletter No errors.
Rawafed\NewsletterBundle\Entity\NewsletterEmail No errors.
Rawafed\NewsletterBundle\Entity\NewsletterEmailgroup No errors.
Rawafed\NewsletterBundle\Entity\NewsletterTransaction No errors.
Rawafed\NewsletterBundle\Entity\NewsletterTransactionDetails No errors.
Rawafed\SolrSearchBundle\Entity\LogEntry No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformData No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformField No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformFieldproperty No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformForm No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformSection No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformSubmission No errors.
Rawafed\FormGeneratorBundle\Entity\DynamicformVersion No errors.
Rawafed\AdsBundle\Entity\Campaign No errors.
Rawafed\AdsBundle\Entity\Zone No errors.
Rawafed\AdsBundle\Entity\Banner No errors.
Rawafed\AdsBundle\Entity\BannerState No errors.
Rawafed\AdsBundle\Entity\Impression No errors.
Rawafed\PageComposerBundle\Entity\Block No errors.
Rawafed\PageComposerBundle\Entity\Container No errors.
Rawafed\PageComposerBundle\Entity\Page No errors.
Rawafed\PageComposerBundle\Entity\Widget No errors.
Rawafed\PageComposerBundle\Entity\Zone No errors.
Rawafed\MonitoringBundle\Entity\MonitoringMetrics No errors.
Rawafed\MonitoringBundle\Entity\MonitoringWindow No errors.
Rawafed\SocialPublisherBundle\Entity\Post No errors.
Rawafed\VideoBundle\Entity\Channel No errors.
Vich\UploaderBundle\Entity\File No errors.

tq entity manager

Class Mapping errors
Rawafed\TaskQueueBundle\Entity\Task No errors.