GET http://dev.hrabarev.netlion.cz/info/faq

Query Metrics

38 Database Queries
4 Different statements
4.40 ms Query time
0 Invalid entities
102 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT f0_.id AS id_0, f0_.category AS category_1, f0_.position AS position_2 FROM faq f0_ ORDER BY f0_.category ASC, f0_.position ASC
Parameters:
[]
2 0.29 ms
SELECT t0.id AS id_1, t0.block_key AS block_key_2, t0.section AS section_3 FROM text_block t0 WHERE t0.block_key = ? LIMIT 1
Parameters:
[
  "info_faq.hero_heading"
]
3 0.20 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM text_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  207
]
4 0.11 ms
SELECT t0.id AS id_1, t0.block_key AS block_key_2, t0.section AS section_3 FROM text_block t0 WHERE t0.block_key = ? LIMIT 1
Parameters:
[
  "info_faq.hero_sub_1"
]
5 0.15 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM text_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  227
]
6 0.12 ms
SELECT t0.id AS id_1, t0.block_key AS block_key_2, t0.section AS section_3 FROM text_block t0 WHERE t0.block_key = ? LIMIT 1
Parameters:
[
  "info_faq.hero_sub_2"
]
7 0.12 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM text_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  228
]
8 0.12 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
9 0.10 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
10 0.10 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
11 0.11 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
12 0.11 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
13 0.10 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
14 0.09 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
15 0.10 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
16 0.12 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
17 0.12 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  14
]
18 0.11 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  26
]
19 0.10 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  27
]
20 0.09 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  28
]
21 0.08 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  29
]
22 0.09 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  30
]
23 0.11 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  31
]
24 0.10 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
25 0.09 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
26 0.09 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
27 0.08 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  21
]
28 0.08 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  22
]
29 0.08 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  23
]
30 0.11 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  24
]
31 0.08 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  25
]
32 0.09 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
33 0.11 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
34 0.10 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
35 0.11 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
36 0.12 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  15
]
37 0.09 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  16
]
38 0.09 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM faq_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  17
]

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\FaqTranslation 62
App\Entity\Faq 31
App\Entity\TextBlockTranslation 6
App\Entity\TextBlock 3

Entities Mapping

Class Mapping errors
App\Entity\Faq No errors.
App\Entity\FaqTranslation No errors.
App\Entity\TextBlock No errors.
App\Entity\TextBlockTranslation No errors.