GET https://condescending-keller.89-46-65-47.plesk.page/it/borghi?region=11

Query Metrics

132 Database Queries
6 Different statements
42.43 ms Query time
0 Invalid entities
381 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
32.63 ms
(76.90%)
107
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  77
]
6.53 ms
(15.38%)
20
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM region_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
1.72 ms
(4.06%)
2
SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0
Parameters:
[]
0.60 ms
(1.42%)
1
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM city c0_ LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN province p2_ ON c0_.province_id = p2_.id LEFT JOIN region r3_ ON p2_.region_id = r3_.id WHERE r3_.id = ?
Parameters:
[
  11
]
0.48 ms
(1.14%)
1
SELECT DISTINCT c0_.id AS id_0 FROM city c0_ LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN province p2_ ON c0_.province_id = p2_.id LEFT JOIN region r3_ ON p2_.region_id = r3_.id WHERE r3_.id = ? LIMIT 9
Parameters:
[
  11
]
0.47 ms
(1.10%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.region_id AS region_id_3 FROM province t0 ORDER BY t0.code ASC
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\ProvinceTranslation 214
App\Entity\Province 107
App\Entity\RegionTranslation 40
App\Entity\Region 20

Entities Mapping

Class Mapping errors
App\Entity\City No errors.
App\Entity\CityTranslation No errors.
App\Entity\Province No errors.
App\Entity\Region No errors.
App\Entity\ProvinceTranslation No errors.
App\Entity\RegionTranslation No errors.