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

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 0.66 ms
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
]
2 0.46 ms
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
]
3 1.70 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_ 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
]
4 0.50 ms
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:
[]
5 0.32 ms
SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0
Parameters:
[]
6 0.55 ms
SELECT t0.id AS id_1, t0.area AS area_2 FROM region t0
Parameters:
[]
7 0.39 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.32 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.31 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.29 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.28 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.29 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.27 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.27 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.27 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.29 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.29 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.28 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.27 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.31 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.26 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.26 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.26 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.26 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.28 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.30 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.37 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  77
]
28 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  58
]
29 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  51
]
30 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  100
]
31 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  52
]
32 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
33 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  86
]
34 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  59
]
35 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
36 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  66
]
37 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  39
]
38 0.33 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  60
]
39 0.30 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  101
]
40 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
41 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  17
]
42 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  68
]
43 0.33 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  40
]
44 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  67
]
45 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  96
]
46 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  72
]
47 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  56
]
48 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  14
]
49 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
50 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  78
]
51 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  61
]
52 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  41
]
53 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  42
]
54 0.31 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
55 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  79
]
56 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
57 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  80
]
58 0.30 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
59 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
60 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  69
]
61 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  87
]
62 0.32 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  53
]
63 0.35 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  30
]
64 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  35
]
65 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  26
]
66 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  88
]
67 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  36
]
68 0.30 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  57
]
69 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
70 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  43
]
71 0.30 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  70
]
72 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  89
]
73 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  44
]
74 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  31
]
75 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  90
]
76 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  47
]
77 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  54
]
78 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  81
]
79 0.30 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  46
]
80 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  45
]
81 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
82 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  91
]
83 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
84 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  15
]
85 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  62
]
86 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  73
]
87 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  74
]
88 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  82
]
89 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  22
]
90 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  102
]
91 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
92 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  98
]
93 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  92
]
94 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  27
]
95 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  94
]
96 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  21
]
97 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  93
]
98 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  55
]
99 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  48
]
100 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
101 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  23
]
102 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
103 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  24
]
104 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  83
]
105 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  32
]
106 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  33
]
107 0.29 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  25
]
108 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  103
]
109 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  16
]
110 0.25 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  95
]
111 0.25 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  49
]
112 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  37
]
113 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  84
]
114 0.25 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  75
]
115 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  76
]
116 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  38
]
117 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  71
]
118 0.31 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
119 0.30 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  97
]
120 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  63
]
121 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  85
]
122 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  99
]
123 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  28
]
124 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  104
]
125 0.25 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  29
]
126 0.28 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  50
]
127 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  64
]
128 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  65
]
129 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  105
]
130 0.25 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  107
]
131 0.27 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  106
]
132 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  34
]
133 0.26 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 province_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
134 0.29 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2 FROM image t0 WHERE t0.id = ?
Parameters:
[
  1
]
135 0.31 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:
[
  2
]
136 0.26 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2 FROM image t0 WHERE t0.id = ?
Parameters:
[
  9
]
137 0.31 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
]
138 0.26 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2 FROM image t0 WHERE t0.id = ?
Parameters:
[
  12
]
139 0.30 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:
[
  4
]

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.