Query Metrics
4
Database Queries
4
Different statements
4.56 ms
Query time
2
Invalid entities
152
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.85 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 | 1.73 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 | 1.57 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 18:39:14" "2026-05-22 18:39:14" "active" "online" "postponed" ]
|
||||||||||||||||||||||||||||
| 4 | 0.42 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 |