GET https://filialnet.pieper.de/handbuch/category/19

Query Metrics

6 Database Queries
5 Different statements
2.72 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.82 ms
SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.author AS author_3, f0_.created_at AS created_at_4, f0_.approved AS approved_5, f0_.updated_at AS updated_at_6, f0_.replaced_by AS replaced_by_7, c1_.id AS id_8, c1_.name AS name_9, c1_.sort AS sort_10, f0_.updated_by_id AS updated_by_id_11, f0_.master_id AS master_id_12 FROM faq f0_ LEFT JOIN faq_category f2_ ON f0_.id = f2_.faq_id LEFT JOIN category c1_ ON c1_.id = f2_.category_id WHERE c1_.id = ? AND f0_.replaced_by IS NULL AND f0_.approved = 1 ORDER BY f0_.created_at DESC
Parameters:
[
  "19"
]
2 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3 FROM category t0 ORDER BY t0.sort ASC, t0.name ASC
Parameters:
[]
3 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "19"
]
4 0.19 ms
SELECT t0.id AS id_1, t0.attachment AS attachment_2, t0.updated_at AS updated_at_3, t0.searchindex AS searchindex_4, t0.faq_id AS faq_id_5 FROM faqattachments t0 WHERE t0.faq_id = ?
Parameters:
[
  253
]
5 0.17 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.plain_password AS plain_password_7, t0.email AS email_8 FROM `admin` t0 WHERE t0.id = ?
Parameters:
[
  12
]
6 1.17 ms
SELECT t0.id AS id_1, t0.attachment AS attachment_2, t0.updated_at AS updated_at_3, t0.searchindex AS searchindex_4, t0.faq_id AS faq_id_5 FROM faqattachments t0 WHERE t0.faq_id = ?
Parameters:
[
  251
]

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.

Entities Mapping

Class Mapping errors
App\Entity\FAQ No errors.
App\Entity\Category No errors.
App\Entity\Admin No errors.
App\Entity\FAQAttachments No errors.
App\Entity\Documents No errors.
App\Entity\BlogArticle No errors.