Query Metrics
3
Database Queries
3
Different statements
2.52 ms
Query time
0
Invalid entities
111
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.98 ms |
SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.sport_id AS sport_id_2, t0_.week_description AS week_description_3, t0_.website AS website_4, t0_.address AS address_5, t0_.monday AS monday_6, t0_.tuesday AS tuesday_7, t0_.wednesday AS wednesday_8, t0_.thursday AS thursday_9, t0_.friday AS friday_10, t0_.saturday AS saturday_11, t0_.sunday AS sunday_12, t0_.reservation_phone AS reservation_phone_13, t0_.reservation_email AS reservation_email_14, t0_.reservation_web AS reservation_web_15, t0_.display AS display_16, t0_.hash AS hash_17, t0_.full AS full_18, t0_.created_by AS created_by_19, t0_.created_at AS created_at_20, t0_.updated_at AS updated_at_21, t0_.year AS year_22, t0_.slug AS slug_23, t0_.featured AS featured_24, f1_.id AS id_25, f1_.name AS name_26, f1_.address AS address_27, f1_.phone AS phone_28, f1_.description AS description_29, f1_.website AS website_30, f1_.type AS type_31, f1_.sports AS sports_32, f1_.coordinates AS coordinates_33, f1_.email AS email_34, f1_.administrative_district AS administrative_district_35, f1_.update_status AS update_status_36, f1_.image AS image_37, f2_.id AS id_38, f2_.description AS description_39, f2_.url AS url_40, s3_.id AS id_41, s3_.name AS name_42, s3_.icon AS icon_43, s3_.slug AS slug_44, c4_.id AS id_45, c4_.name AS name_46, c4_.address AS address_47, c4_.phone AS phone_48, c4_.description AS description_49, c4_.website AS website_50, c4_.sports AS sports_51, c4_.logo AS logo_52, c4_.email AS email_53, c4_.ico AS ico_54, c4_.coordinates AS coordinates_55, c4_.parking_capacity AS parking_capacity_56, c4_.barrier_free AS barrier_free_57, c4_.administrative_district AS administrative_district_58, c4_.month2017 AS month2017_59, c4_.month_program AS month_program_60, c4_.update_status AS update_status_61, t0_.facility_id AS facility_id_62, t0_.club_id AS club_id_63, t0_.sport_id AS sport_id_64, f2_.facility_id AS facility_id_65 FROM tyden_sportu t0_ LEFT JOIN facility f1_ ON t0_.facility_id = f1_.id LEFT JOIN facility_photo f2_ ON f1_.id = f2_.facility_id LEFT JOIN sport s3_ ON t0_.sport_id = s3_.id LEFT JOIN club c4_ ON t0_.club_id = c4_.id WHERE t0_.slug = ? AND t0_.year = ? AND s3_.slug = ? AND t0_.display = ?
Parameters:
[ "eagles-park-baseball-softball" 2026 "baseball-softball" "ano" ]
|
||||||||||||||||||||||||||||
| 2 | 1.17 ms |
SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.sport_id AS sport_id_2, t0_.week_description AS week_description_3, t0_.website AS website_4, t0_.address AS address_5, t0_.monday AS monday_6, t0_.tuesday AS tuesday_7, t0_.wednesday AS wednesday_8, t0_.thursday AS thursday_9, t0_.friday AS friday_10, t0_.saturday AS saturday_11, t0_.sunday AS sunday_12, t0_.reservation_phone AS reservation_phone_13, t0_.reservation_email AS reservation_email_14, t0_.reservation_web AS reservation_web_15, t0_.display AS display_16, t0_.hash AS hash_17, t0_.full AS full_18, t0_.created_by AS created_by_19, t0_.created_at AS created_at_20, t0_.updated_at AS updated_at_21, t0_.year AS year_22, t0_.slug AS slug_23, t0_.featured AS featured_24, f1_.id AS id_25, f1_.name AS name_26, f1_.address AS address_27, f1_.phone AS phone_28, f1_.description AS description_29, f1_.website AS website_30, f1_.type AS type_31, f1_.sports AS sports_32, f1_.coordinates AS coordinates_33, f1_.email AS email_34, f1_.administrative_district AS administrative_district_35, f1_.update_status AS update_status_36, f1_.image AS image_37, s2_.id AS id_38, s2_.name AS name_39, s2_.icon AS icon_40, s2_.slug AS slug_41, t0_.facility_id AS facility_id_42, t0_.club_id AS club_id_43, t0_.sport_id AS sport_id_44 FROM tyden_sportu t0_ LEFT JOIN facility f1_ ON t0_.facility_id = f1_.id LEFT JOIN sport s2_ ON t0_.sport_id = s2_.id WHERE t0_.year = ? AND t0_.facility_id IS NOT NULL AND t0_.display = ? AND t0_.id <> ?
Parameters:
[ 2026 "ano" 1040 ]
|
||||||||||||||||||||||||||||
| 3 | 0.36 ms |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.perex AS perex_3, n0_.content AS content_4, n0_.image AS image_5, n0_.published_at AS published_at_6, n0_.created_at AS created_at_7, n0_.updated_at AS updated_at_8 FROM news n0_ ORDER BY n0_.published_at DESC LIMIT 2
Parameters:
[]
|
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\TydenSportu | 47 |
| App\Entity\Facility | 41 |
| App\Entity\Sport | 21 |
| App\Entity\News | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\TydenSportu | No errors. |
| App\Entity\Facility | No errors. |
| App\Entity\FacilityPhoto | No errors. |
| App\Entity\Sport | No errors. |
| App\Entity\Club | No errors. |
| App\Entity\News | No errors. |