Query Metrics
6
Database Queries
6
Different statements
2.99 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.92 ms (30.72%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.start_time AS start_time_8, t0.end_time AS end_time_9, t0.min_subscription AS min_subscription_10, t0.max_subscription AS max_subscription_11, t0.is_free AS is_free_12, t0.price AS price_13, t0.has_certificate AS has_certificate_14, t0.status AS status_15, t0.directory_path AS directory_path_16, t0.call_link AS call_link_17, t0.event_type_id AS event_type_id_18, t0.place_id AS place_id_19, t0.organizator_id AS organizator_id_20 FROM cer_event t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"perche-non-ho-mai-tempo-25-05-2023"
]
|
|
0.72 ms (24.06%) |
1 |
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.title AS title_2, c0_.subtitle AS subtitle_3, c0_.date AS date_4, c0_.short_description AS short_description_5, c0_.description AS description_6, c0_.start_time AS start_time_7, c0_.end_time AS end_time_8, c0_.min_subscription AS min_subscription_9, c0_.max_subscription AS max_subscription_10, c0_.is_free AS is_free_11, c0_.price AS price_12, c0_.has_certificate AS has_certificate_13, c0_.status AS status_14, c0_.directory_path AS directory_path_15, c0_.call_link AS call_link_16, c0_.event_type_id AS event_type_id_17, c0_.place_id AS place_id_18, c0_.organizator_id AS organizator_id_19 FROM cer_event c0_ WHERE c0_.status = 1 AND c0_.date >= ? ORDER BY c0_.date DESC
Parameters:
[
"2026-10-26"
]
|
|
0.51 ms (17.07%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.poster_path AS poster_path_4, t0.file_path AS file_path_5, t0.event_id AS event_id_6 FROM cer_material t0 WHERE t0.event_id = ?
Parameters:
[
"10"
]
|
|
0.32 ms (10.87%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2 FROM cer_teacher t0 INNER JOIN cer_join_table_event_teacher ON t0.id = cer_join_table_event_teacher.teacher_id WHERE cer_join_table_event_teacher.event_id = ?
Parameters:
[
"10"
]
|
|
0.28 ms (9.26%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.color AS color_4 FROM cer_event_type t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
|
0.24 ms (8.00%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2 FROM cer_organizator t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
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\Material | 2 |
| App\Entity\Teacher | 2 |
| App\Entity\Event | 1 |
| App\Entity\EventType | 1 |
| App\Entity\Organizator | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\EventType | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\Organizator | No errors. |
| App\Entity\JoinTableUserEvent | No errors. |
| App\Entity\Material | No errors. |
| App\Entity\Teacher | No errors. |
| App\Entity\Course | No errors. |
| App\Entity\Meeting | No errors. |