Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.34 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 = ? LIMIT 1
Parameters:
[
  "articles_index"
]
2 0.29 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:
[
  13
]
3 0.20 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 0.18 ms
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:
[
  11
]
5 0.22 ms
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:
[
  11
  "girona-paradis-per-als-ciclistes-i-amants-de-lesport-actiu"
]
6 0.14 ms
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
]
7 0.15 ms
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
]
8 0.23 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 FROM room t0 WHERE t0.is_published = ?
Parameters:
[
  1
]
9 0.23 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
  "ca"
]
10 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
]
11 0.18 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 FROM room t0 WHERE t0.is_published = ?
Parameters:
[
  1
]
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:
[
  1
  "ca"
]

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