GET https://dev.ps.netlion.cz/

Query Metrics

18 Database Queries
3 Different statements
4.76 ms Query time
0 Invalid entities
70 Managed entities

Queries

Group similar statements

# Time Info
1 0.73 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, t0_.facility_id AS facility_id_38, t0_.club_id AS club_id_39, t0_.sport_id AS sport_id_40 FROM tyden_sportu t0_ LEFT JOIN facility f1_ ON t0_.facility_id = f1_.id WHERE t0_.year = ? AND t0_.facility_id IS NOT NULL AND t0_.display = ? AND t0_.featured = ?
Parameters:
[
  2026
  "ano"
  1
]
2 0.33 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:
[]
3 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1288
]
4 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1283
]
5 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1278
]
6 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1277
]
7 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1285
]
8 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1263
]
9 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1256
]
10 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1297
]
11 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1265
]
12 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1284
]
13 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1274
]
14 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1254
]
15 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1286
]
16 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1264
]
17 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1269
]
18 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  1272
]

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 26
App\Entity\Facility 26
App\Entity\Sport 16
App\Entity\News 2

Entities Mapping

Class Mapping errors
App\Entity\TydenSportu No errors.
App\Entity\Facility No errors.
App\Entity\Club No errors.
App\Entity\Sport No errors.
App\Entity\FacilityPhoto No errors.
App\Entity\News No errors.