Query Metrics

4 Database Queries
4 Different statements
8.98 ms Query time
1 Invalid entities
152 Managed entities

Queries

Group similar statements

# Time Info
1 0.92 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.image AS image_2, b0_.is_enabled AS is_enabled_3, b0_.is_activated AS is_activated_4, b0_.redirect_url AS redirect_url_5, b0_.start_at AS start_at_6, b0_.end_at AS end_at_7, b0_.sort AS sort_8, b0_.type AS type_9, b0_.gradient_overlay_level AS gradient_overlay_level_10, b0_.image_name AS image_name_11, b0_.image_original_name AS image_original_name_12, b0_.image_mime_type AS image_mime_type_13, b0_.image_size AS image_size_14, b0_.image_updated_at AS image_updated_at_15, b0_.lang_id AS lang_id_16 FROM banner b0_ WHERE b0_.is_enabled = ? AND b0_.is_activated = ? AND b0_.start_at <= ? AND ((b0_.end_at IS NULL OR b0_.end_at >= ?)) ORDER BY b0_.sort ASC, b0_.start_at DESC
Parameters:
[
  1
  1
  "2026-05-22 00:00:00"
  "2026-05-22 00:00:00"
]
2 3.62 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_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, e0_.poll_id AS poll_id_36, e0_.event_group_id AS event_group_id_37, e1_.lang_id AS lang_id_38, e1_.event_id AS event_id_39 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id WHERE e0_.is_calendar = ? AND e0_.is_enabled = ? AND e0_.is_activated = ? AND e0_.start_at IS NOT NULL AND e0_.start_at < ? AND (e0_.end_at IS NULL OR e0_.end_at >= ?) ORDER BY e0_.start_at ASC
Parameters:
[
  1
  1
  1
  "2027-01-01 00:00:00"
  "2026-01-01 00:00:00"
]
3 3.66 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_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, s3_.id AS id_36, s3_.name AS name_37, s3_.type AS type_38, e0_.poll_id AS poll_id_39, e0_.event_group_id AS event_group_id_40, e1_.lang_id AS lang_id_41, e1_.event_id AS event_id_42 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_specialty e4_ ON e0_.id = e4_.event_id LEFT JOIN specialty s3_ ON s3_.id = e4_.specialty_id WHERE e0_.is_enabled = ? AND e0_.is_activated = ? AND e0_.start_at IS NOT NULL AND ((e0_.start_at >= ? OR (e0_.end_at IS NOT NULL AND e0_.end_at >= ?))) AND e0_.status IN (?, ?, ?) ORDER BY e0_.start_at ASC LIMIT 5
Parameters:
[
  1
  1
  "2026-05-22 14:24:41"
  "2026-05-22 14:24:41"
  "active"
  "online"
  "postponed"
]
4 0.77 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2 FROM specialty s0_
Parameters:
[]

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\Event\Event 3
App\Entity\Event\EventTranslate 3
App\Entity\Banner 1
App\Entity\Language 1
App\Entity\Poll\Poll 1

Entities Mapping

Class Mapping errors
App\Entity\ImageEmbeddableClass No errors.
App\Entity\Banner No errors.
App\Entity\Language No errors.
App\Entity\Event\Event No errors.
App\Entity\Event\EventTranslate 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\Event\EventTab No errors.
App\Entity\Speaker No errors.
App\Entity\Specialty No errors.
App\Entity\Event\EventOrganization No errors.
App\Entity\Certificate\CustomCertificate No errors.
App\Entity\PageTranslate No errors.
App\Entity\Event\EventGroupTranslate No errors.
App\Entity\Event\EventOrganizationTranslate No errors.
App\Entity\SpeakerTranslate 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.