Query Metrics

12 Database Queries
10 Different statements
2.48 ms Query time
0 Invalid entities
24 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.50 ms
(20.07%)
2
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.38 ms
(15.32%)
2
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.28 ms
(11.21%)
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:
[
  "articles_index"
]
0.23 ms
(9.23%)
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:
[
  13
]
0.22 ms
(8.71%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.introduction AS introduction_4, t0.body AS body_5, t0.bibliography AS bibliography_6, t0.article_id AS article_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM article_content t0 WHERE t0.article_id = ? AND t0.slug = ? LIMIT 1
Parameters:
[
  12
  "troba-el-menu-ideal-per-al-teu-pla-al-restaurant-savoy"
]
0.19 ms
(7.74%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.video AS video_4, t0.publication_date AS publication_date_5, t0.article_category_id AS article_category_id_6, t0.main_image_id AS main_image_id_7 FROM article t0 WHERE t0.id = ?
Parameters:
[
  12
]
0.19 ms
(7.51%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.article_category_id AS article_category_id_4, t0.language_id AS language_id_5, t0.seo_id AS seo_id_6 FROM article_category_content t0 WHERE t0.article_category_id = ?
Parameters:
[
  1
]
0.18 ms
(7.18%)
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.id = ?
Parameters:
[
  1
]
0.17 ms
(6.89%)
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
]
0.15 ms
(6.13%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3 FROM article_category t0 WHERE t0.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\ArticleCategoryContent 4
App\Entity\RoomContent 4
App\Entity\Image 3
App\Entity\Seo 3
App\Entity\Page 1
App\Entity\PageContent 1
App\Entity\Article 1
App\Entity\ArticleCategory 1
App\Entity\ArticleContent 1
App\Entity\Room 1