GET https://api.radioshanson.project.codegate.ru/api/v1/news/list?filter%5BgroupCodes%5D%5B0%5D=sitemap.xml&pagination%5Bpage%5D=1&pagination%5Blimit%5D=48

Response
200 OK
IP
95.216.162.244
Profiled on
Token
a798bd

Query Metrics

2 Database Queries
2 Different statements
6.93 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 4.32 ms 
SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, published_at_14 FROM (SELECT b0_.has_photo AS has_photo_0, b0_.has_video AS has_video_1, b0_.image_handaled AS image_handaled_2, b0_.id AS id_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.system_deleted_at AS system_deleted_at_6, b0_.event_date AS event_date_7, b0_.event_title AS event_title_8, b0_.event_sub_title AS event_sub_title_9, b0_.title AS title_10, b0_.code AS code_11, b0_.auto_publish AS auto_publish_12, b0_.published AS published_13, b0_.published_at AS published_at_14, b0_.unpublished_at AS unpublished_at_15, b0_.ordering AS ordering_16, b0_.description AS description_17, b0_.seo_no_index AS seo_no_index_18, b0_.seo_canonical AS seo_canonical_19, b0_.seo_h1 AS seo_h1_20, b0_.seo_title AS seo_title_21, b0_.seo_description AS seo_description_22, b0_.seo_keywords AS seo_keywords_23, b0_.comments_enabled AS comments_enabled_24, b0_.content AS content_25, b0_.announce AS announce_26, b0_.external_id AS external_id_27, b0_.on_main_page AS on_main_page_28, b0_.analytics_views_per_day AS analytics_views_per_day_29, b0_.analytics_views_per_month AS analytics_views_per_month_30, b0_.analytics_views_total AS analytics_views_total_31, b0_.migrate_id AS migrate_id_32, b0_.migrate_info AS migrate_info_33, b0_.exclude_from_rss AS exclude_from_rss_34, b1_.id AS id_35, b1_.created_at AS created_at_36, b1_.updated_at AS updated_at_37, b1_.system_deleted_at AS system_deleted_at_38, b1_.title AS title_39, b1_.code AS code_40, b1_.published AS published_41, b1_.description AS description_42, b2_.id AS id_43, b2_.created_at AS created_at_44, b2_.updated_at AS updated_at_45, b2_.system_deleted_at AS system_deleted_at_46, b2_.title AS title_47, b2_.code AS code_48, b2_.published AS published_49, b2_.description AS description_50, b2_.migrate_id AS migrate_id_51, b2_.migrate_info AS migrate_info_52, b2_.ordering AS ordering_53, b2_.content AS content_54, b2_.exclude_from_rss AS exclude_from_rss_55, b3_.id AS id_56, b3_.created_at AS created_at_57, b3_.updated_at AS updated_at_58, b3_.system_deleted_at AS system_deleted_at_59, b3_.title AS title_60, b3_.published AS published_61, b3_.ordering AS ordering_62, b3_.description AS description_63, b3_.migrate_id AS migrate_id_64, b3_.migrate_info AS migrate_info_65, m4_.name AS name_66, m4_.description AS description_67, m4_.enabled AS enabled_68, m4_.provider_name AS provider_name_69, m4_.provider_status AS provider_status_70, m4_.provider_reference AS provider_reference_71, m4_.provider_metadata AS provider_metadata_72, m4_.width AS width_73, m4_.height AS height_74, m4_.length AS length_75, m4_.content_type AS content_type_76, m4_.content_size AS content_size_77, m4_.copyright AS copyright_78, m4_.author_name AS author_name_79, m4_.context AS context_80, m4_.cdn_is_flushable AS cdn_is_flushable_81, m4_.cdn_flush_identifier AS cdn_flush_identifier_82, m4_.cdn_flush_at AS cdn_flush_at_83, m4_.cdn_status AS cdn_status_84, m4_.updated_at AS updated_at_85, m4_.created_at AS created_at_86, m4_.id AS id_87, m5_.name AS name_88, m5_.description AS description_89, m5_.enabled AS enabled_90, m5_.provider_name AS provider_name_91, m5_.provider_status AS provider_status_92, m5_.provider_reference AS provider_reference_93, m5_.provider_metadata AS provider_metadata_94, m5_.width AS width_95, m5_.height AS height_96, m5_.length AS length_97, m5_.content_type AS content_type_98, m5_.content_size AS content_size_99, m5_.copyright AS copyright_100, m5_.author_name AS author_name_101, m5_.context AS context_102, m5_.cdn_is_flushable AS cdn_is_flushable_103, m5_.cdn_flush_identifier AS cdn_flush_identifier_104, m5_.cdn_flush_at AS cdn_flush_at_105, m5_.cdn_status AS cdn_status_106, m5_.updated_at AS updated_at_107, m5_.created_at AS created_at_108, m5_.id AS id_109, m6_.name AS name_110, m6_.description AS description_111, m6_.enabled AS enabled_112, m6_.provider_name AS provider_name_113, m6_.provider_status AS provider_status_114, m6_.provider_reference AS provider_reference_115, m6_.provider_metadata AS provider_metadata_116, m6_.width AS width_117, m6_.height AS height_118, m6_.length AS length_119, m6_.content_type AS content_type_120, m6_.content_size AS content_size_121, m6_.copyright AS copyright_122, m6_.author_name AS author_name_123, m6_.context AS context_124, m6_.cdn_is_flushable AS cdn_is_flushable_125, m6_.cdn_flush_identifier AS cdn_flush_identifier_126, m6_.cdn_flush_at AS cdn_flush_at_127, m6_.cdn_status AS cdn_status_128, m6_.updated_at AS updated_at_129, m6_.created_at AS created_at_130, m6_.id AS id_131 FROM buckler_news_page b0_ LEFT JOIN buckler_news_page_tag b7_ ON b0_.id = b7_.page_id LEFT JOIN buckler_tag b1_ ON b1_.id = b7_.tag_id LEFT JOIN buckler_news_page_group b8_ ON b0_.id = b8_.page_id LEFT JOIN buckler_news_group b2_ ON b2_.id = b8_.group_id LEFT JOIN buckler_news_page_file b3_ ON b0_.id = b3_.page_id LEFT JOIN media__media m4_ ON b3_.file_id = m4_.id LEFT JOIN media__media m5_ ON b0_.announce_picture_id = m5_.id LEFT JOIN media__media m6_ ON b0_.detail_picture_id = m6_.id WHERE b0_.published = ? AND b2_.code IN (?)) dctrn_result_inner ORDER BY published_at_14 DESC) dctrn_result LIMIT 48
Parameters: 
[
  1
  "sitemap.xml"
]
View formatted query    View runnable query    Explain query
2 2.61 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT b0_.has_photo AS has_photo_0, b0_.has_video AS has_video_1, b0_.image_handaled AS image_handaled_2, b0_.id AS id_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.system_deleted_at AS system_deleted_at_6, b0_.event_date AS event_date_7, b0_.event_title AS event_title_8, b0_.event_sub_title AS event_sub_title_9, b0_.title AS title_10, b0_.code AS code_11, b0_.auto_publish AS auto_publish_12, b0_.published AS published_13, b0_.published_at AS published_at_14, b0_.unpublished_at AS unpublished_at_15, b0_.ordering AS ordering_16, b0_.description AS description_17, b0_.seo_no_index AS seo_no_index_18, b0_.seo_canonical AS seo_canonical_19, b0_.seo_h1 AS seo_h1_20, b0_.seo_title AS seo_title_21, b0_.seo_description AS seo_description_22, b0_.seo_keywords AS seo_keywords_23, b0_.comments_enabled AS comments_enabled_24, b0_.content AS content_25, b0_.announce AS announce_26, b0_.external_id AS external_id_27, b0_.on_main_page AS on_main_page_28, b0_.analytics_views_per_day AS analytics_views_per_day_29, b0_.analytics_views_per_month AS analytics_views_per_month_30, b0_.analytics_views_total AS analytics_views_total_31, b0_.migrate_id AS migrate_id_32, b0_.migrate_info AS migrate_info_33, b0_.exclude_from_rss AS exclude_from_rss_34, b1_.id AS id_35, b1_.created_at AS created_at_36, b1_.updated_at AS updated_at_37, b1_.system_deleted_at AS system_deleted_at_38, b1_.title AS title_39, b1_.code AS code_40, b1_.published AS published_41, b1_.description AS description_42, b2_.id AS id_43, b2_.created_at AS created_at_44, b2_.updated_at AS updated_at_45, b2_.system_deleted_at AS system_deleted_at_46, b2_.title AS title_47, b2_.code AS code_48, b2_.published AS published_49, b2_.description AS description_50, b2_.migrate_id AS migrate_id_51, b2_.migrate_info AS migrate_info_52, b2_.ordering AS ordering_53, b2_.content AS content_54, b2_.exclude_from_rss AS exclude_from_rss_55, b3_.id AS id_56, b3_.created_at AS created_at_57, b3_.updated_at AS updated_at_58, b3_.system_deleted_at AS system_deleted_at_59, b3_.title AS title_60, b3_.published AS published_61, b3_.ordering AS ordering_62, b3_.description AS description_63, b3_.migrate_id AS migrate_id_64, b3_.migrate_info AS migrate_info_65, m4_.name AS name_66, m4_.description AS description_67, m4_.enabled AS enabled_68, m4_.provider_name AS provider_name_69, m4_.provider_status AS provider_status_70, m4_.provider_reference AS provider_reference_71, m4_.provider_metadata AS provider_metadata_72, m4_.width AS width_73, m4_.height AS height_74, m4_.length AS length_75, m4_.content_type AS content_type_76, m4_.content_size AS content_size_77, m4_.copyright AS copyright_78, m4_.author_name AS author_name_79, m4_.context AS context_80, m4_.cdn_is_flushable AS cdn_is_flushable_81, m4_.cdn_flush_identifier AS cdn_flush_identifier_82, m4_.cdn_flush_at AS cdn_flush_at_83, m4_.cdn_status AS cdn_status_84, m4_.updated_at AS updated_at_85, m4_.created_at AS created_at_86, m4_.id AS id_87, m5_.name AS name_88, m5_.description AS description_89, m5_.enabled AS enabled_90, m5_.provider_name AS provider_name_91, m5_.provider_status AS provider_status_92, m5_.provider_reference AS provider_reference_93, m5_.provider_metadata AS provider_metadata_94, m5_.width AS width_95, m5_.height AS height_96, m5_.length AS length_97, m5_.content_type AS content_type_98, m5_.content_size AS content_size_99, m5_.copyright AS copyright_100, m5_.author_name AS author_name_101, m5_.context AS context_102, m5_.cdn_is_flushable AS cdn_is_flushable_103, m5_.cdn_flush_identifier AS cdn_flush_identifier_104, m5_.cdn_flush_at AS cdn_flush_at_105, m5_.cdn_status AS cdn_status_106, m5_.updated_at AS updated_at_107, m5_.created_at AS created_at_108, m5_.id AS id_109, m6_.name AS name_110, m6_.description AS description_111, m6_.enabled AS enabled_112, m6_.provider_name AS provider_name_113, m6_.provider_status AS provider_status_114, m6_.provider_reference AS provider_reference_115, m6_.provider_metadata AS provider_metadata_116, m6_.width AS width_117, m6_.height AS height_118, m6_.length AS length_119, m6_.content_type AS content_type_120, m6_.content_size AS content_size_121, m6_.copyright AS copyright_122, m6_.author_name AS author_name_123, m6_.context AS context_124, m6_.cdn_is_flushable AS cdn_is_flushable_125, m6_.cdn_flush_identifier AS cdn_flush_identifier_126, m6_.cdn_flush_at AS cdn_flush_at_127, m6_.cdn_status AS cdn_status_128, m6_.updated_at AS updated_at_129, m6_.created_at AS created_at_130, m6_.id AS id_131 FROM buckler_news_page b0_ LEFT JOIN buckler_news_page_tag b7_ ON b0_.id = b7_.page_id LEFT JOIN buckler_tag b1_ ON b1_.id = b7_.tag_id LEFT JOIN buckler_news_page_group b8_ ON b0_.id = b8_.page_id LEFT JOIN buckler_news_group b2_ ON b2_.id = b8_.group_id LEFT JOIN buckler_news_page_file b3_ ON b0_.id = b3_.page_id LEFT JOIN media__media m4_ ON b3_.file_id = m4_.id LEFT JOIN media__media m5_ ON b0_.announce_picture_id = m5_.id LEFT JOIN media__media m6_ ON b0_.detail_picture_id = m6_.id WHERE b0_.published = ? AND b2_.code IN (?) ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters: 
[
  1
  "sitemap.xml"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
Buckler\User\Entity\RefreshToken No errors.
Buckler\News\Entity\Page No errors.
Buckler\Tag\Entity\Tag No errors.
Buckler\News\Entity\Group No errors.
Buckler\News\Entity\PageFile No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
Buckler\Media\Entity\Media No errors.