Query Metrics
1
Database Queries
1
Different statements
0.83 ms
Query time
0
Invalid entities
3
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.83 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.code AS code_2, e0_.event_start_at AS event_start_at_3, e0_.event_end_at AS event_end_at_4, e0_.description AS description_5, e0_.reservation AS reservation_6, e0_.is_active AS is_active_7, e0_.is_canceled AS is_canceled_8, e0_.is_archived AS is_archived_9, e0_.is_public AS is_public_10, e0_.access_code AS access_code_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, a1_.id AS id_14, a1_.name AS name_15, a1_.code AS code_16, a1_.start_at AS start_at_17, a1_.end_at AS end_at_18, a1_.registration_start_at AS registration_start_at_19, a1_.registration_end_at AS registration_end_at_20, a1_.description AS description_21, a1_.document AS document_22, a1_.orchestra AS orchestra_23, a1_.price AS price_24, a1_.price_child AS price_child_25, a1_.reservation AS reservation_26, a1_.observations AS observations_27, a1_.is_canceled AS is_canceled_28, a1_.is_public AS is_public_29, a1_.access_code AS access_code_30, a1_.max_capacity AS max_capacity_31, a1_.created_at AS created_at_32, a1_.updated_at AS updated_at_33, p2_.id AS id_34, p2_.name AS name_35, p2_.address AS address_36, p2_.capacity AS capacity_37, p2_.created_at AS created_at_38, p2_.updated_at AS updated_at_39, a1_.event_id AS event_id_40, a1_.form_id AS form_id_41, a1_.place_id AS place_id_42 FROM event e0_ LEFT JOIN activity a1_ ON e0_.id = a1_.event_id LEFT JOIN place p2_ ON a1_.place_id = p2_.id WHERE e0_.is_archived = ? AND COALESCE(e0_.event_end_at, e0_.event_start_at) >= ? AND (e0_.description IS NOT NULL AND e0_.description <> '') AND ((e0_.is_public = ?) OR (EXISTS (SELECT 1 AS sclr_43 FROM activity a3_ WHERE a3_.event_id = e0_.id AND a3_.is_public = ? AND a3_.description IS NOT NULL AND a3_.description <> ''))) ORDER BY e0_.event_start_at ASC
Parameters:
[ 0 "2026-04-07 00:00:00" 1 1 ]
|
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\Event | 1 |
| App\Entity\Activity | 1 |
| App\Entity\Place | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\Activity | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\Form | No errors. |