GET https://condescending-keller.89-46-65-47.plesk.page/en/city/bolsena

Query Metrics

32 Database Queries
11 Different statements
17.20 ms Query time
0 Invalid entities
70 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.73 ms
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_ INNER JOIN city_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.slug = ?
Parameters:
[
  "bolsena"
]
2 0.31 ms
"START TRANSACTION"
Parameters:
[]
3 0.47 ms
UPDATE city SET views = ? WHERE id = ?
Parameters:
[
  13
  3
]
4 2.22 ms
"COMMIT"
Parameters:
[]
5 0.63 ms
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:
[
  3
]
6 0.69 ms
SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0
Parameters:
[]
7 0.53 ms
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
]
8 0.42 ms
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:
[
  6
]
9 0.46 ms
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:
[
  8
]
10 0.41 ms
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:
[
  9
]
11 0.45 ms
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:
[
  12
]
12 0.45 ms
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:
[
  17
]
13 0.54 ms
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:
[
  19
]
14 0.51 ms
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:
[
  20
]
15 0.44 ms
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:
[
  7
]
16 0.42 ms
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:
[
  10
]
17 0.43 ms
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:
[
  16
]
18 0.53 ms
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:
[
  18
]
19 0.50 ms
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:
[
  1
]
20 0.48 ms
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:
[
  2
]
21 0.49 ms
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:
[
  3
]
22 0.44 ms
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:
[
  4
]
23 0.42 ms
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:
[
  11
]
24 0.45 ms
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:
[
  13
]
25 0.46 ms
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:
[
  14
]
26 0.51 ms
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:
[
  15
]
27 0.50 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2 FROM image t0 WHERE t0.id = ?
Parameters:
[
  9
]
28 0.44 ms
SELECT t0.id AS id_1, t0.city_id AS city_id_2 FROM place_of_interest t0 WHERE t0.city_id = ?
Parameters:
[
  3
]
29 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM place_of_interest_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
30 0.48 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2 FROM image t0 INNER JOIN place_of_interest_image ON t0.id = place_of_interest_image.image_id WHERE place_of_interest_image.place_of_interest_id = ?
Parameters:
[
  5
]
31 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM place_of_interest_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
32 0.45 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2 FROM image t0 INNER JOIN place_of_interest_image ON t0.id = place_of_interest_image.image_id WHERE place_of_interest_image.place_of_interest_id = ?
Parameters:
[
  7
]

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\RegionTranslation 40
App\Entity\Region 20
App\Entity\Image 3
App\Entity\PlaceOfInterest 2
App\Entity\PlaceOfInterestTranslation 2
App\Entity\City 1
App\Entity\Province 1
App\Entity\CityTranslation 1

Entities Mapping