Query Metrics

10 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.34 ms
(13.90%)
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.32 ms
(12.82%)
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.31 ms
(12.34%)
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 = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  1
  "ca"
]
0.28 ms
(11.20%)
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:
[
  14
  "per-que-lhotel-peninsular-es-ideal-per-a-viatges-de-negocis-i-trobades-amb-encant"
]
0.26 ms
(10.32%)
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.22 ms
(8.79%)
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.20 ms
(8.22%)
1
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.20 ms
(8.06%)
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:
[
  14
]
0.19 ms
(7.77%)
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.16 ms
(6.57%)
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

Entities Mapping