Query Metrics

13 Database Queries
8 Different statements
5.11 ms Query time
0 Invalid entities
15 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.44 ms
(47.81%)
3
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 FROM room t0 WHERE t0.is_published = ?
Parameters:
[
  1
]
0.65 ms
(12.73%)
3
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
  "ca"
]
0.42 ms
(8.29%)
2
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:
[
  24
]
0.39 ms
(7.55%)
1
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.code = ? LIMIT 1
Parameters:
[
  "ca"
]
0.33 ms
(6.49%)
1
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:
[
  1
]
0.33 ms
(6.48%)
1
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 = ? LIMIT 1
Parameters:
[
  "home_index"
]
0.32 ms
(6.26%)
1
SELECT t0.id AS id_1, t0.video AS video_2, t0.image AS image_3, t0.image_mobile AS image_mobile_4, t0.updated_at AS updated_at_5, t0.title AS title_6, t0.body AS body_7, t0.button AS button_8, t0.link AS link_9, t0.position AS position_10, t0.is_published AS is_published_11, t0.subtitle AS subtitle_12, t0.language_id AS language_id_13 FROM banner t0 WHERE t0.is_published = ? AND t0.language_id = ?
Parameters:
[
  1
  1
]
0.22 ms
(4.38%)
1
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
]

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\Language 4
App\Entity\RoomContent 4
App\Entity\Image 2
App\Entity\Seo 2
App\Entity\Page 1
App\Entity\PageContent 1
App\Entity\Room 1