Query Metrics

3 Database Queries
3 Different statements
1.65 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.77 ms
SELECT f0_.id AS id_0, f0_.size AS size_1, f0_.map_link AS map_link_2, f0_.car_link AS car_link_3, f0_.public_transport_link AS public_transport_link_4, f0_.cover_image AS cover_image_5, f0_.taxi_price_one AS taxi_price_one_6, f0_.taxi_price_two AS taxi_price_two_7, f0_.number_of_buildings AS number_of_buildings_8, f0_.has_artificial_obstacles AS has_artificial_obstacles_9, f0_.recommended_number_of_players AS recommended_number_of_players_10, f0_.has_wc AS has_wc_11, f0_.has_heated_lobby AS has_heated_lobby_12, f0_.has_small_refreshments AS has_small_refreshments_13, f0_.has_grill AS has_grill_14, f0_.has_professional_catering AS has_professional_catering_15, f0_.has_parking AS has_parking_16, f0_.has_public_transport AS has_public_transport_17, f0_.has_hilly_terrain AS has_hilly_terrain_18, f0_.has_pyrotechnics_usage AS has_pyrotechnics_usage_19, f0_.has_showers AS has_showers_20, f0_.has_wifi AS has_wifi_21, f0_.gps_lat AS gps_lat_22, f0_.gps_lng AS gps_lng_23, f0_.headline_image AS headline_image_24, f0_.address AS address_25, f0_.public_transport_station_name AS public_transport_station_name_26, f0_.public_transport_station_description AS public_transport_station_description_27, f0_.field_index AS field_index_28, f0_.deleted AS deleted_29, f0_.ical_token AS ical_token_30, f0_.has_lighting AS has_lighting_31, f0_.has_trenches AS has_trenches_32, f0_.has_storied_buildings AS has_storied_buildings_33, f0_.number_of_shelters AS number_of_shelters_34, f0_.google_calendar_id AS google_calendar_id_35 FROM field f0_
Parameters:
[]
2 0.46 ms
SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ WHERE (((e0_.status = ? AND e0_.public = ?) AND e0_.event_start >= ?) AND e0_.category = ?) AND e0_.status <> ?
Parameters:
[
  "DELETED"
  1
  "2026-03-14 17:37:10"
  "OTHERS"
  "DELETED"
]
3 0.43 ms
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_.status = ? AND e0_.public = ?) AND e0_.event_start >= ?) AND e0_.category = ? ORDER BY e0_.event_start ASC LIMIT 10
Parameters:
[
  "ACCEPTED"
  1
  "2026-03-14 17:37:10"
  "OTHERS"
]

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\Field No errors.
App\Entity\Event No errors.
App\Entity\Reservation No errors.