GET https://mail.bricklocator.com/nl-NL/blog/eerste-blog.html

Query Metrics

15 Database Queries
8 Different statements
2.43 ms Query time
0 Invalid entities
27 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "nl-NL"
]
2 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0
Parameters:
[]
3 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0
Parameters:
[]
4 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content AS content_5, t0.short_description AS short_description_6, t0.language_id AS language_id_7, t0.article_id AS article_id_8 FROM blog_article_translation t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "eerste-blog"
]
5 0.34 ms
SELECT t0.id AS id_1, t0.internal_name AS internal_name_2, t0.published_at AS published_at_3, t0.featured_image AS featured_image_4, t0.product_ids AS product_ids_5, t0.product_id AS product_id_6 FROM blog_article t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content AS content_5, t0.short_description AS short_description_6, t0.language_id AS language_id_7, t0.article_id AS article_id_8 FROM blog_article_translation t0 WHERE t0.article_id = ?
Parameters:
[
  1
]
7 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "nl-NL"
]
8 0.15 ms
SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.description AS description_3, t0_.thema_id AS thema_id_4, t0_.language_id AS language_id_5 FROM thema_translation t0_ WHERE t0_.language_id = ? AND t0_.slug IS NOT NULL ORDER BY t0_.name ASC
Parameters:
[
  2
]
9 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0
Parameters:
[]
10 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "nl-NL"
]
11 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM content_page t0 WHERE t0.name IN (?, ?, ?, ?)
Parameters:
[
  "algemene voorwaarden"
  "privacy"
  "contact"
  "overons"
]
12 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  1
  2
]
13 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  2
  2
]
14 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  3
  2
]
15 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  4
  2
]

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 8
App\Entity\ThemaTranslation 4
App\Entity\Thema 4
App\Entity\ContentPage 4
App\Entity\ContentPageTranslation 4
App\Entity\BlogArticleTranslation 2
App\Entity\BlogArticle 1

Entities Mapping