GET https://murder.komakaw.com/documents

Query Metrics

12 Database Queries
5 Different statements
6.90 ms Query time
0 Invalid entities
19 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.55 ms
(51.38%)
4
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.content AS content_4, t0.image AS image_5, t0.attachments AS attachments_6 FROM page t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.24 ms
(18.00%)
2
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d1_.id AS id_3, d1_.name AS name_4, d1_.description AS description_5, u2_.id AS id_6, u2_.name AS name_7, u2_.description AS description_8, d0_.parent_id AS parent_id_9, d1_.parent_id AS parent_id_10 FROM document_category d0_ LEFT JOIN document_category d1_ ON d0_.id = d1_.parent_id LEFT JOIN document_category_access_groups d3_ ON d0_.id = d3_.document_category_id LEFT JOIN user_group u2_ ON u2_.id = d3_.user_group_id WHERE d0_.parent_id IS NULL ORDER BY d0_.name ASC, d1_.name ASC
Parameters:
[]
1.21 ms
(17.57%)
4
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id = ? AND m0_.enabled = ? ORDER BY m0_.position ASC
Parameters:
[
  3
  1
]
0.50 ms
(7.24%)
1
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.description AS description_2, d0_.file AS file_3, d0_.is_public AS is_public_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.notification_sent AS notification_sent_7, d1_.id AS id_8, d1_.name AS name_9, d1_.description AS description_10, d2_.id AS id_11, d2_.name AS name_12, d2_.description AS description_13, u3_.id AS id_14, u3_.name AS name_15, u3_.description AS description_16, u4_.id AS id_17, u4_.name AS name_18, u4_.description AS description_19, d0_.category_id AS category_id_20, d1_.parent_id AS parent_id_21, d2_.parent_id AS parent_id_22 FROM document d0_ LEFT JOIN document_category d1_ ON d0_.category_id = d1_.id LEFT JOIN document_category d2_ ON d1_.parent_id = d2_.id LEFT JOIN document_category_access_groups d5_ ON d1_.id = d5_.document_category_id LEFT JOIN user_group u3_ ON u3_.id = d5_.user_group_id LEFT JOIN document_category_access_groups d6_ ON d2_.id = d6_.document_category_id LEFT JOIN user_group u4_ ON u4_.id = d6_.user_group_id WHERE d0_.is_public = ? ORDER BY d0_.created_at DESC
Parameters:
[
  1
]
0.40 ms
(5.81%)
1
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id IS NULL AND m0_.enabled = ? ORDER BY m0_.position ASC
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\MenuItem 10
App\Entity\DocumentCategory 5
App\Entity\Page 4

Entities Mapping

Class Mapping errors
App\Entity\MenuItem No errors.
App\Entity\Page No errors.
App\Entity\Category No errors.
App\Entity\DocumentCategory No errors.
App\Entity\UserGroup No errors.
App\Entity\Document No errors.