GET https://vconfe.ru/events/ii-regionalnyy-endokrinologicheskiy-sezd-vyzovy-i-perspektivy-privolzhya-den-2

Response
200 OK
IP
216.73.216.48
Profiled on
Token
5e346b

Query Metrics

2 Database Queries
2 Different statements
349.06 ms Query time
2 Invalid entities
152 Managed entities

Queries

Group similar statements

#▲ Time Info
1 346.34 ms 
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.created_at AS created_at_12, e0_.is_show_chat AS is_show_chat_13, e0_.is_registration AS is_registration_14, e0_.is_calendar AS is_calendar_15, e0_.is_nmo AS is_nmo_16, e0_.is_show_slider AS is_show_slider_17, e0_.image_name AS image_name_18, e0_.image_original_name AS image_original_name_19, e0_.image_mime_type AS image_mime_type_20, e0_.image_size AS image_size_21, e0_.image_updated_at AS image_updated_at_22, e0_.card_image_name AS card_image_name_23, e0_.card_image_original_name AS card_image_original_name_24, e0_.card_image_mime_type AS card_image_mime_type_25, e0_.card_image_size AS card_image_size_26, e0_.card_image_updated_at AS card_image_updated_at_27, e1_.id AS id_28, e1_.title AS title_29, e1_.seo_title AS seo_title_30, e1_.seo_description AS seo_description_31, e1_.content AS content_32, l2_.id AS id_33, l2_.name AS name_34, s3_.id AS id_35, s3_.is_enabled AS is_enabled_36, s3_.created_at AS created_at_37, s3_.image_name AS image_name_38, s3_.image_original_name AS image_original_name_39, s3_.image_mime_type AS image_mime_type_40, s3_.image_size AS image_size_41, s3_.image_updated_at AS image_updated_at_42, s4_.id AS id_43, s4_.name AS name_44, s4_.content AS content_45, l5_.id AS id_46, l5_.name AS name_47, s6_.id AS id_48, s6_.is_enabled AS is_enabled_49, s6_.created_at AS created_at_50, s6_.image_name AS image_name_51, s6_.image_original_name AS image_original_name_52, s6_.image_mime_type AS image_mime_type_53, s6_.image_size AS image_size_54, s6_.image_updated_at AS image_updated_at_55, s7_.id AS id_56, s7_.name AS name_57, s7_.content AS content_58, l8_.id AS id_59, l8_.name AS name_60, s9_.id AS id_61, s9_.name AS name_62, s9_.type AS type_63, e10_.id AS id_64, e10_.website_url AS website_url_65, e10_.is_enabled AS is_enabled_66, e10_.created_at AS created_at_67, e10_.image_name AS image_name_68, e10_.image_original_name AS image_original_name_69, e10_.image_mime_type AS image_mime_type_70, e10_.image_size AS image_size_71, e10_.image_updated_at AS image_updated_at_72, e11_.id AS id_73, e11_.title AS title_74, e11_.short_description AS short_description_75, l12_.id AS id_76, l12_.name AS name_77, e13_.id AS id_78, e13_.website_url AS website_url_79, e13_.is_enabled AS is_enabled_80, e13_.created_at AS created_at_81, e13_.image_name AS image_name_82, e13_.image_original_name AS image_original_name_83, e13_.image_mime_type AS image_mime_type_84, e13_.image_size AS image_size_85, e13_.image_updated_at AS image_updated_at_86, e14_.id AS id_87, e14_.title AS title_88, e14_.short_description AS short_description_89, l15_.id AS id_90, l15_.name AS name_91, e16_.id AS id_92, e16_.website_url AS website_url_93, e16_.is_enabled AS is_enabled_94, e16_.created_at AS created_at_95, e16_.image_name AS image_name_96, e16_.image_original_name AS image_original_name_97, e16_.image_mime_type AS image_mime_type_98, e16_.image_size AS image_size_99, e16_.image_updated_at AS image_updated_at_100, e17_.id AS id_101, e17_.title AS title_102, e17_.short_description AS short_description_103, l18_.id AS id_104, l18_.name AS name_105, e19_.id AS id_106, e19_.website_url AS website_url_107, e19_.is_enabled AS is_enabled_108, e19_.created_at AS created_at_109, e19_.image_name AS image_name_110, e19_.image_original_name AS image_original_name_111, e19_.image_mime_type AS image_mime_type_112, e19_.image_size AS image_size_113, e19_.image_updated_at AS image_updated_at_114, e20_.id AS id_115, e20_.title AS title_116, e20_.short_description AS short_description_117, l21_.id AS id_118, l21_.name AS name_119, e22_.id AS id_120, e22_.website_url AS website_url_121, e22_.is_enabled AS is_enabled_122, e22_.created_at AS created_at_123, e22_.image_name AS image_name_124, e22_.image_original_name AS image_original_name_125, e22_.image_mime_type AS image_mime_type_126, e22_.image_size AS image_size_127, e22_.image_updated_at AS image_updated_at_128, e23_.id AS id_129, e23_.title AS title_130, e23_.short_description AS short_description_131, l24_.id AS id_132, l24_.name AS name_133, e25_.id AS id_134, e25_.iframe AS iframe_135, e25_.title AS title_136, e25_.sort AS sort_137, l26_.id AS id_138, l26_.name AS name_139, e0_.poll_id AS poll_id_140, e0_.event_group_id AS event_group_id_141, e1_.lang_id AS lang_id_142, e1_.event_id AS event_id_143, s4_.speaker_id AS speaker_id_144, s4_.lang_id AS lang_id_145, s7_.speaker_id AS speaker_id_146, s7_.lang_id AS lang_id_147, e11_.lang_id AS lang_id_148, e11_.event_organization_id AS event_organization_id_149, e14_.lang_id AS lang_id_150, e14_.event_organization_id AS event_organization_id_151, e17_.lang_id AS lang_id_152, e17_.event_organization_id AS event_organization_id_153, e20_.lang_id AS lang_id_154, e20_.event_organization_id AS event_organization_id_155, e23_.lang_id AS lang_id_156, e23_.event_organization_id AS event_organization_id_157, e25_.lang_id AS lang_id_158, e25_.event_id AS event_id_159 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_speaker e27_ ON e0_.id = e27_.event_id LEFT JOIN speaker s3_ ON s3_.id = e27_.speaker_id LEFT JOIN speaker_translate s4_ ON s3_.id = s4_.speaker_id LEFT JOIN language l5_ ON s4_.lang_id = l5_.id LEFT JOIN event_organizational_committee e28_ ON e0_.id = e28_.event_id LEFT JOIN speaker s6_ ON s6_.id = e28_.speaker_id LEFT JOIN speaker_translate s7_ ON s6_.id = s7_.speaker_id LEFT JOIN language l8_ ON s7_.lang_id = l8_.id LEFT JOIN event_specialty e29_ ON e0_.id = e29_.event_id LEFT JOIN specialty s9_ ON s9_.id = e29_.specialty_id LEFT JOIN event_organizer e30_ ON e0_.id = e30_.event_id LEFT JOIN event_organization e10_ ON e10_.id = e30_.event_organization_id LEFT JOIN event_organization_translate e11_ ON e10_.id = e11_.event_organization_id LEFT JOIN language l12_ ON e11_.lang_id = l12_.id LEFT JOIN event_co_organizer e31_ ON e0_.id = e31_.event_id LEFT JOIN event_organization e13_ ON e13_.id = e31_.event_organization_id LEFT JOIN event_organization_translate e14_ ON e13_.id = e14_.event_organization_id LEFT JOIN language l15_ ON e14_.lang_id = l15_.id LEFT JOIN event_supporter e32_ ON e0_.id = e32_.event_id LEFT JOIN event_organization e16_ ON e16_.id = e32_.event_organization_id LEFT JOIN event_organization_translate e17_ ON e16_.id = e17_.event_organization_id LEFT JOIN language l18_ ON e17_.lang_id = l18_.id LEFT JOIN event_partner e33_ ON e0_.id = e33_.event_id LEFT JOIN event_organization e19_ ON e19_.id = e33_.event_organization_id LEFT JOIN event_organization_translate e20_ ON e19_.id = e20_.event_organization_id LEFT JOIN language l21_ ON e20_.lang_id = l21_.id LEFT JOIN event_information_partner e34_ ON e0_.id = e34_.event_id LEFT JOIN event_organization e22_ ON e22_.id = e34_.event_organization_id LEFT JOIN event_organization_translate e23_ ON e22_.id = e23_.event_organization_id LEFT JOIN language l24_ ON e23_.lang_id = l24_.id LEFT JOIN event_tab e25_ ON e0_.id = e25_.event_id LEFT JOIN language l26_ ON e25_.lang_id = l26_.id WHERE e0_.slug = ? AND e0_.is_enabled = ? AND e0_.is_activated = ?
Parameters: 
[
  "ii-regionalnyy-endokrinologicheskiy-sezd-vyzovy-i-perspektivy-privolzhya-den-2"
  1
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2 2.72 ms 
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2 FROM specialty s0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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
App\Entity\Specialty 143
App\Entity\Speaker 3
App\Entity\SpeakerTranslate 3
App\Entity\Event\Event 1
App\Entity\Event\EventTranslate 1
App\Entity\Language 1

Entities Mapping

Class Mapping errors
App\Entity\ImageEmbeddableClass No errors.
App\Entity\Event\Event No errors.
App\Entity\Event\EventTranslate No errors.
App\Entity\Language No errors.
App\Entity\Speaker No errors.
App\Entity\SpeakerTranslate No errors.
App\Entity\Specialty No errors.
App\Entity\Event\EventOrganization No errors.
App\Entity\Event\EventOrganizationTranslate No errors.
App\Entity\Event\EventTab No errors.
App\Entity\Poll\Poll No errors.
App\Entity\Event\EventGroup No errors.
App\Entity\User\UserEventRegister No errors.
App\Entity\User\UserCertificate No errors.
App\Entity\Test\Test No errors.
App\Entity\Certificate\CustomCertificate No errors.
App\Entity\PageTranslate No errors.
App\Entity\Event\EventGroupTranslate No errors.
App\Entity\Banner No errors.
App\Entity\Faq No errors.
App\Entity\User\User
  • The association App\Entity\User\User#tests refers to the owning side field App\Entity\Test\Test#user which does not exist.
App\Entity\Poll\PollQuestion No errors.
App\Entity\User\UserPoll No errors.
App\Entity\Test\TestQuestion No errors.
App\Entity\User\UserTest No errors.
App\Entity\Certificate\CustomCertificateElement No errors.
App\Entity\Page No errors.
App\Entity\User\UserPollAnswer No errors.
App\Entity\User\UserTestAnswer No errors.
App\Entity\City No errors.
App\Entity\User\UserOrganization No errors.
App\Entity\Feedback No errors.
App\Entity\Poll\PollOption No errors.
App\Entity\Test\TestAnswer
  • The association App\Entity\Test\TestAnswer#test refers to the inverse side field App\Entity\Test\Test#testAnswers which does not exist.
App\Entity\Country No errors.
App\Entity\Event\ChatReportJob No errors.
Vich\UploaderBundle\Entity\File No errors.