Query Metrics
83
Database Queries
5
Different statements
12.88 ms
Query time
0
Invalid entities
142
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.75 ms (44.61%) |
34 |
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:
[
202
]
|
|
4.86 ms (37.70%) |
37 |
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:
[
"info_contacts.hero_heading"
]
|
|
0.83 ms (6.42%) |
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.76 ms (5.92%) |
2 |
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
]
|
|
0.69 ms (5.36%) |
5 |
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
]
|
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\TextBlockTranslation | 68 |
| App\Entity\TextBlock | 34 |
| App\Entity\FieldPhoto | 25 |
| 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. |