Query Metrics

61 Database Queries
14 Different statements
39.93 ms Query time
0 Invalid entities
269 Managed entities

Queries

Group similar statements

# Time Info
1 0.75 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.intro AS intro_6, t0.body AS body_7, t0.metaTitle AS metaTitle_8, t0.metaDescription AS metaDescription_9, t0.metaKeywords AS metaKeywords_10, t0.bannerText AS bannerText_11, t0.redirect_url AS redirect_url_12, t0.is_external AS is_external_13, t0.bannerImage AS bannerImage_14, t0.page AS page_15, t0.language AS language_16 FROM pages_contents t0 WHERE t0.language = ? AND t0.slug = ? LIMIT 1
Parameters:
[
  "ca"
  "arees-de-treball"
]
2 0.51 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.orderPosition AS orderPosition_3, t0.opcionals AS opcionals_4, t0.fieldType AS fieldType_5, t0.pages_categories AS pages_categories_6, t0.bannerImage AS bannerImage_7 FROM pages t0 WHERE t0.id = ?
Parameters:
[
  "areesMunicipals"
]
3 0.42 ms
SELECT t0.id AS id_1, t0.iso2 AS iso2_2, t0.iso3 AS iso3_3, t0.i18n AS i18n_4, t0.name AS name_5, t0.fieldOrder AS fieldOrder_6, t0.isActiveFront AS isActiveFront_7, t0.isActiveBack AS isActiveBack_8 FROM languages t0 ORDER BY t0.fieldOrder ASC
Parameters:
[]
4 1.75 ms
SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.role AS role_4, t0.email AS email_5, t0.phone AS phone_6, t0.instagram AS instagram_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.transparency AS transparency_10, t0.retribution AS retribution_11, t0.declaration AS declaration_12, t0.agenda AS agenda_13, t0.photoFilename AS photoFilename_14, t0.bio AS bio_15, t0.isAlcalde AS isAlcalde_16, t0.isGovern AS isGovern_17, t0.displayOrder AS displayOrder_18, t0.updatedAt AS updatedAt_19, t0.party_id AS party_id_20 FROM elected_officials t0 WHERE t0.isGovern = ? AND t0.isAlcalde = ? ORDER BY t0.displayOrder ASC
Parameters:
[
  1
  0
]
5 0.51 ms
SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.role AS role_4, t0.email AS email_5, t0.phone AS phone_6, t0.instagram AS instagram_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.transparency AS transparency_10, t0.retribution AS retribution_11, t0.declaration AS declaration_12, t0.agenda AS agenda_13, t0.photoFilename AS photoFilename_14, t0.bio AS bio_15, t0.isAlcalde AS isAlcalde_16, t0.isGovern AS isGovern_17, t0.displayOrder AS displayOrder_18, t0.updatedAt AS updatedAt_19, t0.party_id AS party_id_20 FROM elected_officials t0 WHERE t0.isGovern = ? ORDER BY t0.displayOrder ASC
Parameters:
[
  0
]
6 0.25 ms
SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.role AS role_4, t0.email AS email_5, t0.phone AS phone_6, t0.instagram AS instagram_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.transparency AS transparency_10, t0.retribution AS retribution_11, t0.declaration AS declaration_12, t0.agenda AS agenda_13, t0.photoFilename AS photoFilename_14, t0.bio AS bio_15, t0.isAlcalde AS isAlcalde_16, t0.isGovern AS isGovern_17, t0.displayOrder AS displayOrder_18, t0.updatedAt AS updatedAt_19, t0.party_id AS party_id_20 FROM elected_officials t0 WHERE t0.isAlcalde = ? LIMIT 1
Parameters:
[
  1
]
7 2.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iconOrImage AS iconOrImage_3, t0.displayOrder AS displayOrder_4, t0.email AS email_5, t0.updatedAt AS updatedAt_6, t0.image_id AS image_id_7, t0.responsible_official_id AS responsible_official_id_8 FROM municipal_areas t0 ORDER BY t0.displayOrder ASC
Parameters:
[]
8 1.97 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  10
]
9 0.69 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  10
]
10 0.52 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  11
]
11 0.52 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  11
]
12 2.70 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  12
]
13 0.63 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  12
]
14 0.39 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  13
]
15 0.42 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  13
]
16 2.90 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  14
]
17 0.42 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  14
]
18 0.35 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  24
]
19 0.31 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  24
]
20 1.90 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  15
]
21 0.42 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  15
]
22 0.43 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  16
]
23 0.34 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  16
]
24 2.37 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  17
]
25 0.43 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  17
]
26 0.28 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  18
]
27 0.33 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  18
]
28 1.03 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  19
]
29 0.43 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  19
]
30 0.37 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  20
]
31 0.37 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  20
]
32 1.46 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  21
]
33 0.43 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  21
]
34 0.23 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.orderPosition AS orderPosition_3, t0.opcionals AS opcionals_4, t0.fieldType AS fieldType_5, t0.pages_categories AS pages_categories_6, t0.bannerImage AS bannerImage_7 FROM pages t0 WHERE t0.id = ?
Parameters:
[
  "agenda"
]
35 0.23 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.intro AS intro_6, t0.body AS body_7, t0.metaTitle AS metaTitle_8, t0.metaDescription AS metaDescription_9, t0.metaKeywords AS metaKeywords_10, t0.bannerText AS bannerText_11, t0.redirect_url AS redirect_url_12, t0.is_external AS is_external_13, t0.bannerImage AS bannerImage_14, t0.page AS page_15, t0.language AS language_16 FROM pages_contents t0 WHERE t0.page = ?
Parameters:
[
  "agenda"
]
36 0.47 ms
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.agendaCategory AS agendaCategory_3, a0_.language AS language_4 FROM agenda_categories_contents a0_ INNER JOIN agenda_categories a1_ ON a0_.agendaCategory = a1_.id INNER JOIN languages l2_ ON a0_.language = l2_.id WHERE l2_.id = ? AND a1_.isActive = 1 ORDER BY a1_.orderPosition ASC
Parameters:
[
  "ca"
]
37 0.52 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.pageCategory AS pageCategory_4, t0.language AS language_5 FROM pages_categories_contents t0 WHERE t0.language = ? AND t0.pageCategory = ? LIMIT 1
Parameters:
[
  "ca"
  23
]
38 0.41 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.name AS name_2, p0_.title AS title_3, p0_.subtitle AS subtitle_4, p0_.intro AS intro_5, p0_.body AS body_6, p0_.metaTitle AS metaTitle_7, p0_.metaDescription AS metaDescription_8, p0_.metaKeywords AS metaKeywords_9, p0_.bannerText AS bannerText_10, p0_.redirect_url AS redirect_url_11, p0_.is_external AS is_external_12, p0_.bannerImage AS bannerImage_13, p0_.page AS page_14, p0_.language AS language_15 FROM pages_contents p0_ INNER JOIN pages p1_ ON p0_.page = p1_.id INNER JOIN languages l2_ ON p0_.language = l2_.id WHERE l2_.id = ? AND p1_.active = 1 AND p1_.pages_categories = ? ORDER BY p1_.orderPosition ASC, p1_.id ASC
Parameters:
[
  "ca"
  23
]
39 3.25 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  1
]
40 0.29 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  3
]
41 0.17 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  2
]
42 0.15 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  13
]
43 0.12 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  12
]
44 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  4
]
45 0.17 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  5
]
46 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  6
]
47 0.17 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  7
]
48 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  8
]
49 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  9
]
50 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  10
]
51 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  11
]
52 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.introduction AS introduction_5, t0.url AS url_6, t0.active AS active_7, t0.language_id AS language_id_8, t0.municipal_area_id AS municipal_area_id_9 FROM municipal_areas_contents t0 WHERE t0.municipal_area_id = ?
Parameters:
[
  14
]
53 2.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.color AS color_4, t0.logoName AS logoName_5, t0.updatedAt AS updatedAt_6 FROM political_parties t0 WHERE t0.id = ?
Parameters:
[
  1
]
54 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iconOrImage AS iconOrImage_3, t0.displayOrder AS displayOrder_4, t0.email AS email_5, t0.updatedAt AS updatedAt_6, t0.image_id AS image_id_7, t0.responsible_official_id AS responsible_official_id_8 FROM municipal_areas t0 WHERE t0.responsible_official_id = ?
Parameters:
[
  1
]
55 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iconOrImage AS iconOrImage_3, t0.displayOrder AS displayOrder_4, t0.email AS email_5, t0.updatedAt AS updatedAt_6, t0.image_id AS image_id_7, t0.responsible_official_id AS responsible_official_id_8 FROM municipal_areas t0 WHERE t0.responsible_official_id = ?
Parameters:
[
  2
]
56 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.color AS color_4, t0.logoName AS logoName_5, t0.updatedAt AS updatedAt_6 FROM political_parties t0 WHERE t0.id = ?
Parameters:
[
  2
]
57 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iconOrImage AS iconOrImage_3, t0.displayOrder AS displayOrder_4, t0.email AS email_5, t0.updatedAt AS updatedAt_6, t0.image_id AS image_id_7, t0.responsible_official_id AS responsible_official_id_8 FROM municipal_areas t0 WHERE t0.responsible_official_id = ?
Parameters:
[
  3
]
58 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iconOrImage AS iconOrImage_3, t0.displayOrder AS displayOrder_4, t0.email AS email_5, t0.updatedAt AS updatedAt_6, t0.image_id AS image_id_7, t0.responsible_official_id AS responsible_official_id_8 FROM municipal_areas t0 WHERE t0.responsible_official_id = ?
Parameters:
[
  4
]
59 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iconOrImage AS iconOrImage_3, t0.displayOrder AS displayOrder_4, t0.email AS email_5, t0.updatedAt AS updatedAt_6, t0.image_id AS image_id_7, t0.responsible_official_id AS responsible_official_id_8 FROM municipal_areas t0 WHERE t0.responsible_official_id = ?
Parameters:
[
  5
]
60 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iconOrImage AS iconOrImage_3, t0.displayOrder AS displayOrder_4, t0.email AS email_5, t0.updatedAt AS updatedAt_6, t0.image_id AS image_id_7, t0.responsible_official_id AS responsible_official_id_8 FROM municipal_areas t0 WHERE t0.responsible_official_id = ?
Parameters:
[
  6
]
61 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iconOrImage AS iconOrImage_3, t0.displayOrder AS displayOrder_4, t0.email AS email_5, t0.updatedAt AS updatedAt_6, t0.image_id AS image_id_7, t0.responsible_official_id AS responsible_official_id_8 FROM municipal_areas t0 WHERE t0.responsible_official_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\PageContent 83
App\Entity\Page 82
App\Entity\MunicipalAreaContent 28
App\Entity\PageCategory 15
App\Entity\MunicipalArea 14
App\Entity\PageCategoryContent 14
App\Entity\ElectedOfficial 13
App\Entity\AgendaCategoryContent 7
App\Entity\AgendaCategory 7
App\Entity\PoliticalParty 4
App\Entity\Language 2