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

Query Metrics

25 Database Queries
10 Different statements
3.62 ms Query time
0 Invalid entities
40 Managed entities

Queries

Group similar statements

# Time Info
1 0.58 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.14 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.13 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"
]
4 0.29 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.text AS text_3, c1_.id AS id_4, c1_.name AS name_5, l2_.id AS id_6, l2_.name AS name_7, l2_.image AS image_8, l2_.locale AS locale_9, l2_.sorting AS sorting_10, c0_.language_id AS language_id_11, c0_.content_page_id AS content_page_id_12 FROM content_page_translation c0_ INNER JOIN content_page c1_ ON c0_.content_page_id = c1_.id INNER JOIN language l2_ ON c0_.language_id = l2_.id WHERE c0_.slug = ? AND l2_.locale = ?
Parameters:
[
  "privacy"
  "nl-NL"
]
5 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.thema_id AS thema_id_5, t0.language_id AS language_id_6 FROM thema_translation t0
Parameters:
[]
6 0.21 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.slug = ? LIMIT 1
Parameters:
[
  "privacy"
]
7 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 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "nl-NL"
]
8 0.17 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.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:
[]
10 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.slug = ? LIMIT 1
Parameters:
[
  "privacy"
]
11 0.15 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.language_id = ? AND t0.content_page_id = ? LIMIT 1
Parameters:
[
  1
  2
]
12 0.11 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.language_id = ? AND t0.content_page_id = ? LIMIT 1
Parameters:
[
  2
  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.language_id = ? AND t0.content_page_id = ? LIMIT 1
Parameters:
[
  3
  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.language_id = ? AND t0.content_page_id = ? LIMIT 1
Parameters:
[
  4
  2
]
15 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.language_id = ? AND t0.content_page_id = ? LIMIT 1
Parameters:
[
  5
  2
]
16 0.11 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.language_id = ? AND t0.content_page_id = ? LIMIT 1
Parameters:
[
  6
  2
]
17 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.language_id = ? AND t0.content_page_id = ? LIMIT 1
Parameters:
[
  7
  2
]
18 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.language_id = ? AND t0.content_page_id = ? LIMIT 1
Parameters:
[
  8
  2
]
19 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:
[
  "nl-NL"
]
20 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"
]
21 0.11 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
]
22 0.11 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
]
23 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
]
24 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
]
25 0.13 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 = ?
Parameters:
[
  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\ThemaTranslation 20
App\Entity\Language 8
App\Entity\ContentPageTranslation 4
App\Entity\ContentPage 4
App\Entity\Thema 4

Entities Mapping

Class Mapping errors
App\Entity\Language No errors.
App\Entity\ContentPageTranslation No errors.
App\Entity\ContentPage No errors.
App\Entity\ThemaTranslation No errors.
App\Entity\Thema No errors.