GET http://dev.hrabarev.netlion.cz/de/fields

Query Metrics

32 Database Queries
5 Different statements
5.26 ms Query time
0 Invalid entities
70 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 ms
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.deleted = ?
Parameters:
[
  0
]
2 0.30 ms
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:
[
  "field_index.hero_heading"
]
3 0.24 ms
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:
[
  164
]
4 0.13 ms
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:
[
  "field_index.hero_sub"
]
5 0.12 ms
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:
[
  162
]
6 0.17 ms
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
]
7 0.16 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.field_id AS field_id_3 FROM field_photo t0 WHERE t0.field_id = ?
Parameters:
[
  1
]
8 0.15 ms
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:
[
  2
]
9 0.11 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.field_id AS field_id_3 FROM field_photo t0 WHERE t0.field_id = ?
Parameters:
[
  2
]
10 0.13 ms
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:
[
  3
]
11 0.11 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.field_id AS field_id_3 FROM field_photo t0 WHERE t0.field_id = ?
Parameters:
[
  3
]
12 0.17 ms
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
]
13 0.20 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.field_id AS field_id_3 FROM field_photo t0 WHERE t0.field_id = ?
Parameters:
[
  4
]
14 0.18 ms
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:
[
  5
]
15 0.13 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.field_id AS field_id_3 FROM field_photo t0 WHERE t0.field_id = ?
Parameters:
[
  5
]
16 0.25 ms
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:
[
  "shared.legend_restaurant"
]
17 0.29 ms
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:
[
  111
]
18 0.16 ms
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:
[
  "shared.legend_toilets"
]
19 0.17 ms
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:
[
  112
]
20 0.13 ms
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:
[
  "shared.legend_wifi"
]
21 0.11 ms
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:
[
  113
]
22 0.09 ms
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:
[
  "shared.legend_parking"
]
23 0.09 ms
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:
[
  114
]
24 0.08 ms
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:
[
  "shared.legend_public_transport"
]
25 0.11 ms
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:
[
  115
]
26 0.12 ms
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:
[
  "shared.legend_heated_lobby"
]
27 0.09 ms
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:
[
  116
]
28 0.08 ms
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:
[
  "shared.legend_lighting"
]
29 0.08 ms
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:
[
  117
]
30 0.31 ms
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.deleted = ?
Parameters:
[
  0
]
31 0.20 ms
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:
[
  "field_index.play_elsewhere_heading"
]
32 0.15 ms
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:
[
  163
]

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\FieldPhoto 25
App\Entity\TextBlockTranslation 20
App\Entity\TextBlock 10
App\Entity\FieldTranslation 10
App\Entity\Field 5

Entities Mapping

Class Mapping errors
App\Entity\Field No errors.
App\Entity\FieldPhoto No errors.
App\Entity\FieldTranslation No errors.
App\Entity\TextBlock No errors.
App\Entity\TextBlockTranslation No errors.