GET http://dev.hrabarev.netlion.cz/paintball-events

Query Metrics

120 Database Queries
6 Different statements
17.35 ms Query time
0 Invalid entities
205 Managed entities

Grouped Statements

Show all queries

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