GET https://novara-peninsular.mitica.net/ca/blog

Query Metrics

29 Database Queries
12 Different statements
16.91 ms Query time
0 Invalid entities
106 Managed entities

Queries

Group similar statements

# Time Info
1 2.07 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 3.74 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 3.24 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.44 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.is_published = ? ORDER BY t0.publication_date DESC
Parameters:
[
  1
]
5 0.74 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
]
6 0.33 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"
]
7 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 = ?
Parameters:
[
  1
]
8 0.37 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.72 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.25 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:
[
  86
]
11 0.41 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 = ?
Parameters:
[
  17
]
12 0.25 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
]
13 0.28 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
]
14 0.24 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:
[
  139
]
15 0.70 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 = ?
Parameters:
[
  15
]
16 0.20 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:
[
  137
]
17 0.24 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 = ?
Parameters:
[
  16
]
18 0.26 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:
[
  138
]
19 0.23 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 = ?
Parameters:
[
  13
]
20 0.20 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:
[
  135
]
21 0.33 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 = ?
Parameters:
[
  14
]
22 0.19 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:
[
  136
]
23 0.19 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 = ?
Parameters:
[
  12
]
24 0.16 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:
[
  134
]
25 0.17 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 = ?
Parameters:
[
  11
]
26 0.18 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:
[
  133
]
27 0.16 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 = ?
Parameters:
[
  2
]
28 0.15 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:
[
  4
]
29 0.21 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 34
App\Entity\ArticleContent 32
App\Entity\Image 10
App\Entity\Article 8
App\Entity\Review 6
App\Entity\Language 4
App\Entity\RoomContent 4
App\Entity\ArticleCategoryContent 4
App\Entity\Page 1
App\Entity\PageContent 1
App\Entity\ArticleCategory 1
App\Entity\Room 1