Query Metrics
1
Database Queries
1
Different statements
0.60 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.60 ms (100.00%) |
1 |
SELECT e0_.name AS name_0, e0_.description AS description_1, e0_.starts_at AS starts_at_2, e0_.ends_at AS ends_at_3, e0_.duration_minutes AS duration_minutes_4, e0_.capacity_min AS capacity_min_5, e0_.capacity_max AS capacity_max_6, e0_.registration_count AS registration_count_7, e0_.waiting_list_count AS waiting_list_count_8, e0_.price_amount AS price_amount_9, e0_.currency AS currency_10, e0_.is_modified_from_series AS is_modified_from_series_11, e0_.modification_scope AS modification_scope_12, e0_.registration_opens_at AS registration_opens_at_13, e0_.registration_closes_at AS registration_closes_at_14, e0_.is_cancelled AS is_cancelled_15, e0_.cancelled_at AS cancelled_at_16, e0_.status AS status_17, e0_.id AS id_18, e0_.token AS token_19, e0_.created_at AS created_at_20, e0_.updated_at AS updated_at_21, e0_.series_id AS series_id_22, e0_.club_id AS club_id_23, e0_.sport_id AS sport_id_24, e0_.court_type_id AS court_type_id_25 FROM event_occurrence e0_ INNER JOIN event_series e1_ ON e0_.series_id = e1_.id WHERE e1_.deleted_at IS NULL AND e1_.status = ? AND e1_.visibility = ? AND e0_.is_cancelled = 0 AND e0_.status NOT IN (?, ?) AND e0_.starts_at >= ? ORDER BY e0_.starts_at ASC LIMIT 80
Parameters:
[ "PUBLISHED" "PUBLIC" "DRAFT" "CANCELLED" "2026-06-05 20:45:08" ]
|
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\EventOccurrence | No errors. |
| App\Entity\EventSeries | No errors. |
| App\Entity\Club | No errors. |
| App\Entity\Sport | No errors. |
| App\Entity\CourtType | No errors. |