Query Metrics
120
Database Queries
6
Different statements
17.35 ms
Query time
0
Invalid entities
205
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.10 ms (40.95%) |
59 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.image AS image_3, t0.deleted AS deleted_4, t0.quantity AS quantity_5, t0.enabled_payments AS enabled_payments_6, t0.enabled_deliveries AS enabled_deliveries_7, t0.event_id AS event_id_8 FROM eshop_product t0 WHERE t0.event_id = ?
Parameters:
[
84
]
|
|
3.64 ms (20.97%) |
24 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM text_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
197
]
|
|
3.32 ms (19.12%) |
24 |
SELECT t0.id AS id_1, t0.block_key AS block_key_2, t0.section AS section_3 FROM text_block t0 WHERE t0.block_key = ? LIMIT 1
Parameters:
[
"service_public_games.hero_heading"
]
|
|
1.25 ms (7.18%) |
3 |
SELECT e0_.id AS id_0, e0_.public AS public_1, e0_.status AS status_2, e0_.firstname AS firstname_3, e0_.lastname AS lastname_4, e0_.email AS email_5, e0_.phone AS phone_6, e0_.number_of_unequipped_players AS number_of_unequipped_players_7, e0_.number_of_equipped_players AS number_of_equipped_players_8, e0_.created AS created_9, e0_.comment AS comment_10, e0_.name AS name_11, e0_.category AS category_12, e0_.event_start AS event_start_13, e0_.event_end AS event_end_14, e0_.registrations_start AS registrations_start_15, e0_.registrations_end AS registrations_end_16, e0_.transportation_time AS transportation_time_17, e0_.referee AS referee_18, e0_.type AS type_19, e0_.price AS price_20, e0_.ammunition_price AS ammunition_price_21, e0_.description AS description_22, e0_.price_comment AS price_comment_23, e0_.mail_sent AS mail_sent_24, e0_.admin_comment AS admin_comment_25, e0_.station AS station_26, e0_.image AS image_27, e0_.google_calendar_id AS google_calendar_id_28, e0_.confirmed AS confirmed_29, e0_.google_calendar_event_id AS google_calendar_event_id_30, e0_.field_id AS field_id_31, e0_.reservation_id AS reservation_id_32 FROM event e0_ WHERE e0_.public = 1 AND e0_.category = ? AND e0_.event_start > ? ORDER BY e0_.event_start ASC
Parameters:
[ "FOR-BEGINNERS" "2026-05-29 17:15:53" ] |
|
1.17 ms (6.75%) |
5 |
SELECT t0.id AS id_1, t0.size AS size_2, t0.map_link AS map_link_3, t0.car_link AS car_link_4, t0.public_transport_link AS public_transport_link_5, t0.cover_image AS cover_image_6, t0.taxi_price_one AS taxi_price_one_7, t0.taxi_price_two AS taxi_price_two_8, t0.number_of_buildings AS number_of_buildings_9, t0.has_artificial_obstacles AS has_artificial_obstacles_10, t0.recommended_number_of_players AS recommended_number_of_players_11, t0.has_wc AS has_wc_12, t0.has_heated_lobby AS has_heated_lobby_13, t0.has_small_refreshments AS has_small_refreshments_14, t0.has_grill AS has_grill_15, t0.has_professional_catering AS has_professional_catering_16, t0.has_parking AS has_parking_17, t0.has_public_transport AS has_public_transport_18, t0.has_hilly_terrain AS has_hilly_terrain_19, t0.has_pyrotechnics_usage AS has_pyrotechnics_usage_20, t0.has_showers AS has_showers_21, t0.has_wifi AS has_wifi_22, t0.gps_lat AS gps_lat_23, t0.gps_lng AS gps_lng_24, t0.headline_image AS headline_image_25, t0.address AS address_26, t0.public_transport_station_name AS public_transport_station_name_27, t0.public_transport_station_description AS public_transport_station_description_28, t0.field_index AS field_index_29, t0.deleted AS deleted_30, t0.ical_token AS ical_token_31, t0.has_lighting AS has_lighting_32, t0.has_trenches AS has_trenches_33, t0.has_storied_buildings AS has_storied_buildings_34, t0.number_of_shelters AS number_of_shelters_35, t0.google_calendar_id AS google_calendar_id_36 FROM field t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
0.87 ms (5.03%) |
5 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.param_one AS param_one_3, t0.param_two AS param_two_4, t0.param_three AS param_three_5, t0.opening_hours AS opening_hours_6, t0.description AS description_7, t0.text AS text_8, t0.car_description AS car_description_9, t0.public_transport_description AS public_transport_description_10, t0.taxi_description AS taxi_description_11, t0.location_name AS location_name_12, t0.slug AS slug_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM field_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
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 | 59 |
| App\Entity\Reservation | 59 |
| App\Entity\TextBlockTranslation | 48 |
| App\Entity\TextBlock | 24 |
| App\Entity\FieldTranslation | 10 |
| App\Entity\Field | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\Field | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\Registration | No errors. |
| App\Entity\EshopProduct | No errors. |
| App\Entity\FieldPhoto | No errors. |
| App\Entity\FieldTranslation | No errors. |
| App\Entity\User | No errors. |
| App\Entity\EshopProductTranslation | No errors. |
| App\Entity\TextBlock | No errors. |
| App\Entity\TextBlockTranslation | No errors. |