GET https://www.bricklocator.com/en-EN/blog

Query Metrics

18 Database Queries
10 Different statements
2.23 ms Query time
0 Invalid entities
22 Managed entities

Queries

Group similar statements

# Time Info
1 0.28 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:
[
  "en-EN"
]
2 0.12 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.08 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.08 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:
[
  "en-EN"
]
5 0.14 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.meta_description AS meta_description_3, b0_.content AS content_4, b0_.short_description AS short_description_5, b0_.language_id AS language_id_6, b0_.article_id AS article_id_7 FROM blog_article_translation b0_ WHERE b0_.language_id = ?
Parameters:
[
  1
]
6 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 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "en-EN"
]
7 0.26 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:
[
  1
]
8 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
Parameters:
[]
9 0.08 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:
[
  "en-EN"
]
10 0.09 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"
]
11 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
  1
]
12 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
  1
]
13 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:
[
  3
  1
]
14 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
  1
]
15 0.15 ms
SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.meta_description AS meta_description_3, b0_.content AS content_4, b0_.short_description AS short_description_5 FROM blog_article_translation b0_ WHERE b0_.language_id = ?) dctrn_result LIMIT 10
Parameters:
[
  1
]
16 0.10 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.meta_description AS meta_description_3, b0_.content AS content_4, b0_.short_description AS short_description_5, b0_.language_id AS language_id_6, b0_.article_id AS article_id_7 FROM blog_article_translation b0_ WHERE b0_.language_id = ? AND b0_.id IN (?)
Parameters:
[
  1
  1
]
17 0.10 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
]
18 0.16 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.meta_description AS meta_description_3, b0_.content AS content_4, b0_.short_description AS short_description_5 FROM blog_article_translation b0_ WHERE b0_.language_id = ?) dctrn_result) dctrn_table
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 8
App\Entity\ThemaTranslation 4
App\Entity\Thema 4
App\Entity\ContentPage 4
App\Entity\BlogArticleTranslation 1
App\Entity\BlogArticle 1

Entities Mapping