Query Metrics
148
Database Queries
44
Different statements
833.02 ms
Query time
1
Invalid entities
6
Managed entities
Grouped Statements
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
tq entity manager
Class | Mapping errors |
---|---|
Rawafed\TaskQueueBundle\Entity\Task | No errors. |