Query Metrics
6
Database Queries
6
Different statements
2.14 ms
Query time
1
Invalid entities
21
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.69 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.occure_at AS occure_at_2, e0_.start_at AS start_at_3, e0_.finish_at AS finish_at_4, e0_.connection_url AS connection_url_5, e0_.description AS description_6, e0_.description_search AS description_search_7, e0_.image AS image_8, e0_.hidden AS hidden_9, e0_.subscribers_max AS subscribers_max_10, e0_.subscribers_count AS subscribers_count_11, e0_.subscribers_present AS subscribers_present_12, e0_.participation_rate AS participation_rate_13, e0_.review_teacher_status AS review_teacher_status_14, e0_.review_event_speaker_status AS review_event_speaker_status_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17, e0_.status AS status_18, e0_.comment AS comment_19, e0_.event_type_id AS event_type_id_20 FROM event_session e0_ WHERE e0_.status = ? AND e0_.hidden = ? AND e0_.hidden = ?
Parameters:
[ "published" 0 0 ] |
| 2 | 0.21 ms |
SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.half_day AS half_day_2 FROM week_item w0_
Parameters:
[] |
| 3 | 0.34 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.occure_at AS occure_at_2, e0_.finish_at AS finish_at_3 FROM event_type e0_ INNER JOIN event_session e1_ ON e0_.id = e1_.event_type_id WHERE e1_.occure_at >= ? GROUP BY e0_.id ORDER BY e0_.name ASC
Parameters:
[
"2025-11-01 19:00:42"
]
|
| 4 | 0.41 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1 FROM event_theme e0_ INNER JOIN event_session_event_theme e2_ ON e0_.id = e2_.event_theme_id INNER JOIN event_session e1_ ON e1_.id = e2_.event_session_id WHERE e1_.occure_at > ? GROUP BY e0_.id
Parameters:
[
"2025-11-01 19:00:42"
]
|
| 5 | 0.27 ms |
SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.occure_at AS occure_at_2, e0_.start_at AS start_at_3, e0_.finish_at AS finish_at_4, e0_.connection_url AS connection_url_5, e0_.description AS description_6, e0_.description_search AS description_search_7, e0_.image AS image_8, e0_.hidden AS hidden_9, e0_.subscribers_max AS subscribers_max_10, e0_.subscribers_count AS subscribers_count_11, e0_.subscribers_present AS subscribers_present_12, e0_.participation_rate AS participation_rate_13, e0_.review_teacher_status AS review_teacher_status_14, e0_.review_event_speaker_status AS review_event_speaker_status_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17, e0_.status AS status_18, e0_.comment AS comment_19 FROM event_session e0_ WHERE e0_.status = ? AND e0_.hidden = ? AND e0_.hidden = ?) dctrn_result LIMIT 10
Parameters:
[ "published" 0 0 ] |
| 6 | 0.22 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.occure_at AS occure_at_2, e0_.start_at AS start_at_3, e0_.finish_at AS finish_at_4, e0_.connection_url AS connection_url_5, e0_.description AS description_6, e0_.description_search AS description_search_7, e0_.image AS image_8, e0_.hidden AS hidden_9, e0_.subscribers_max AS subscribers_max_10, e0_.subscribers_count AS subscribers_count_11, e0_.subscribers_present AS subscribers_present_12, e0_.participation_rate AS participation_rate_13, e0_.review_teacher_status AS review_teacher_status_14, e0_.review_event_speaker_status AS review_event_speaker_status_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17, e0_.status AS status_18, e0_.comment AS comment_19, e0_.event_type_id AS event_type_id_20 FROM event_session e0_ WHERE e0_.status = ? AND e0_.hidden = ? AND e0_.hidden = ? AND e0_.id IN (?)
Parameters:
[ "published" 0 0 72 ] |
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\WeekItem | 14 |
| App\Entity\EventTheme | 5 |
| App\Entity\EventSession | 1 |
| App\Entity\EventType | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\EventSession | No errors. |
| App\Entity\EventType | No errors. |
| App\Entity\EventTheme | No errors. |
| App\Entity\EventSessionSubscription | No errors. |
| App\Entity\EventSessionSpeaker | No errors. |
| App\Entity\Feedback | No errors. |
| App\Entity\WeekItem |
|
| App\Entity\Teacher | No errors. |