GET http://dev.hrabarev.netlion.cz/event/calendar/?page=1

Query Metrics

22 Database Queries
7 Different statements
4.04 ms Query time
0 Invalid entities
41 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.16 ms
(28.75%)
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:
[
  1
]
0.99 ms
(24.58%)
10
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:
[
  30
]
0.45 ms
(11.03%)
2
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:
[
  "event_index.hero_heading"
]
0.42 ms
(10.32%)
2
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:
[
  167
]
0.41 ms
(10.17%)
1
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:
[]
0.37 ms
(9.18%)
1
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 >= ? ORDER BY e0_.event_start ASC LIMIT 10
Parameters:
[
  "ACCEPTED"
  1
  "2026-05-29 18:05:03"
]
0.24 ms
(5.96%)
1
SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ WHERE ((e0_.status = ? AND e0_.public = ?) AND e0_.event_start >= ?) AND e0_.status <> ?
Parameters:
[
  "DELETED"
  1
  "2026-05-29 18:05:03"
  "DELETED"
]

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\FieldTranslation 10
App\Entity\Event 10
App\Entity\Reservation 10
App\Entity\Field 5
App\Entity\TextBlockTranslation 4
App\Entity\TextBlock 2

Entities Mapping