GET https://komakaw.duckdns.org/documents

Query Metrics

8 Database Queries
5 Different statements
4.79 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.43 ms
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
]
2 0.45 ms
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
]
3 0.19 ms
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:
[
  7
  1
]
4 0.20 ms
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:
[
  1
  1
]
5 2.59 ms
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:
[
  1
]
6 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM document_category t0
Parameters:
[]
7 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM document_category t0
Parameters:
[]
8 0.33 ms
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, d0_.category_id AS category_id_11 FROM document d0_ LEFT JOIN document_category d1_ ON d0_.category_id = d1_.id WHERE d0_.is_public = ? ORDER BY d0_.created_at DESC
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 6
App\Entity\DocumentCategory 2
App\Entity\Page 1

Entities Mapping

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