Query Metrics
1
Database Queries
1
Different statements
3.80 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 3.80 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.capacity AS capacity_3, e0_.max_tickets_per_user AS max_tickets_per_user_4, e0_.price AS price_5, e0_.administrative_costs AS administrative_costs_6, e0_.status AS status_7, e0_.main_image_path AS main_image_path_8, e0_.manual_sale_control AS manual_sale_control_9, e0_.ticket_start_date AS ticket_start_date_10, e0_.organizer_email AS organizer_email_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e1_.id AS id_14, e1_.fromDate AS fromDate_15, e1_.toDate AS toDate_16, e1_.price AS price_17, e1_.administrative_costs AS administrative_costs_18, e1_.capacity AS capacity_19, e1_.sitemap_path AS sitemap_path_20, e1_.created_at AS created_at_21, e1_.updated_at AS updated_at_22, e0_.room_id AS room_id_23, e1_.event_id AS event_id_24, e1_.room_id AS room_id_25 FROM event e0_ INNER JOIN room r2_ ON e0_.room_id = r2_.id INNER JOIN space s3_ ON r2_.space_id = s3_.id INNER JOIN event_show e1_ ON e0_.id = e1_.event_id WHERE e0_.status = ? AND e1_.fromDate > ? ORDER BY e1_.fromDate ASC
Parameters:
[ "published" "2026-01-20 21:06:53" ]
|
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\Room | No errors. |
| App\Entity\Space | No errors. |
| App\Entity\EventShow | No errors. |