Query Metrics
3
Database Queries
3
Different statements
1.38 ms
Query time
0
Invalid entities
5
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.51 ms (37.21%) |
1 |
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
]
|
|
0.49 ms (35.76%) |
1 |
SELECT t0.id AS id_1, t0.public AS public_2, t0.status AS status_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.phone AS phone_7, t0.number_of_unequipped_players AS number_of_unequipped_players_8, t0.number_of_equipped_players AS number_of_equipped_players_9, t0.created AS created_10, t0.comment AS comment_11, t0.name AS name_12, t0.category AS category_13, t0.event_start AS event_start_14, t0.event_end AS event_end_15, t0.registrations_start AS registrations_start_16, t0.registrations_end AS registrations_end_17, t0.transportation_time AS transportation_time_18, t0.referee AS referee_19, t0.type AS type_20, t0.price AS price_21, t0.ammunition_price AS ammunition_price_22, t0.description AS description_23, t0.price_comment AS price_comment_24, t0.mail_sent AS mail_sent_25, t0.admin_comment AS admin_comment_26, t0.station AS station_27, t0.image AS image_28, t0.google_calendar_id AS google_calendar_id_29, t0.confirmed AS confirmed_30, t0.google_calendar_event_id AS google_calendar_event_id_31, t0.field_id AS field_id_32, t0.reservation_id AS reservation_id_33, t34.id AS id_35, t34.price AS price_36, t34.image AS image_37, t34.deleted AS deleted_38, t34.quantity AS quantity_39, t34.enabled_payments AS enabled_payments_40, t34.enabled_deliveries AS enabled_deliveries_41, t34.event_id AS event_id_42 FROM event t0 LEFT JOIN eshop_product t34 ON t34.event_id = t0.id WHERE t0.id = ?
Parameters:
[
70
]
|
|
0.37 ms (27.03%) |
1 |
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:
[
5
]
|
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 | 2 |
| App\Entity\Event | 1 |
| App\Entity\Field | 1 |
| App\Entity\Reservation | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\Field | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\EshopProduct | No errors. |
| App\Entity\Registration | No errors. |
| App\Entity\FieldPhoto | No errors. |
| App\Entity\FieldTranslation | No errors. |
| App\Entity\User | No errors. |
| App\Entity\EshopProductTranslation | No errors. |