GET https://www.hotelpeninsulargirona.com/en/contact

Query Metrics

30 Database Queries
9 Different statements
18.61 ms Query time
0 Invalid entities
79 Managed entities

Queries

Group similar statements

# Time Info
1 0.43 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.updated_at AS updated_at_4, t0.is_published AS is_published_5, t0.video AS video_6, t0.main_image_id AS main_image_id_7 FROM page t0 WHERE t0.code = ? AND t0.is_published = ? LIMIT 1
Parameters:
[
  "contact_index"
  1
]
2 4.75 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.introduction AS introduction_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7, t0.seo_id AS seo_id_8 FROM page_content t0 WHERE t0.page_id = ?
Parameters:
[
  14
]
3 7.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 1.29 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.17 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = ?
Parameters:
[
  4
]
7 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5, t0.listing_image_id AS listing_image_id_6 FROM room t0 WHERE t0.is_published = ?
Parameters:
[
  1
]
8 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  1
  "en"
]
9 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  7
  "en"
]
10 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  8
  "en"
]
11 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  9
  "en"
]
12 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  10
  "en"
]
13 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  11
  "en"
]
14 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?
Parameters:
[
  1
]
15 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?
Parameters:
[
  7
]
16 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?
Parameters:
[
  8
]
17 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?
Parameters:
[
  9
]
18 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?
Parameters:
[
  10
]
19 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?
Parameters:
[
  11
]
20 0.27 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 ORDER BY t0.position ASC
Parameters:
[]
21 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5, t0.listing_image_id AS listing_image_id_6 FROM room t0 WHERE t0.is_published = ?
Parameters:
[
  1
]
22 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  1
  "en"
]
23 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  7
  "en"
]
24 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  8
  "en"
]
25 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  9
  "en"
]
26 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  10
  "en"
]
27 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  11
  "en"
]
28 0.19 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 ORDER BY t0.position ASC
Parameters:
[]
29 0.28 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 WHERE t0.id = ?
Parameters:
[
  87
]
30 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.body AS body_5, t0.rate AS rate_6, t0.is_published AS is_published_7, t0.language_id AS language_id_8 FROM review t0 WHERE t0.is_published = ?
Parameters:
[
  1
]

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\Seo 28
App\Entity\RoomContent 24
App\Entity\Image 7
App\Entity\Room 6
App\Entity\Review 5
App\Entity\PageContent 4
App\Entity\Language 4
App\Entity\Page 1