GET https://www.condescending-keller.89-46-65-47.plesk.page/en/borghi?region=7

Query Metrics

139 Database Queries
9 Different statements
41.86 ms Query time
0 Invalid entities
390 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
31.42 ms
(75.06%)
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
]
5.87 ms
(14.03%)
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.13 ms
(2.70%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.slug AS slug_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM city_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.83 ms
(1.99%)
3
SELECT t0.id AS id_1, t0.image_name AS image_name_2 FROM image t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.71 ms
(1.69%)
2
SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0
Parameters:
[]
0.54 ms
(1.28%)
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:
[
  7
]
0.48 ms
(1.14%)
1
SELECT c0_.id AS id_0, c0_.views AS views_1, c0_.main_image_id AS main_image_id_2, c0_.province_id AS province_id_3 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 = ? AND c0_.id IN (?, ?, ?)
Parameters:
[
  7
  2
  3
  4
]
0.47 ms
(1.11%)
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:
[
  7
]
0.42 ms
(1.00%)
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
App\Entity\City 3
App\Entity\Image 3
App\Entity\CityTranslation 3

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\Image No errors.
App\Entity\PlaceOfInterest No errors.
App\Entity\ProvinceTranslation No errors.
App\Entity\RegionTranslation No errors.