GET http://roadmap.hiddn.dev/en?category=security

Query Metrics

5 Database Queries
2 Different statements
8.29 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 5.30 ms
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.description AS description_2, r0_.status AS status_3, r0_.category AS category_4, r0_.is_user_submitted AS is_user_submitted_5, r0_.is_approved AS is_approved_6, r0_.approved_at AS approved_at_7, r0_.target_version AS target_version_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.submitted_by_id AS submitted_by_id_11 FROM roadmap_items r0_ WHERE r0_.is_approved = ? AND r0_.category = ? ORDER BY r0_.created_at DESC
Parameters:
[
  1
  "security"
]
2 1.40 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.roadmap_item_id AS roadmap_item_id_3, t0.user_id AS user_id_4 FROM roadmap_votes t0 WHERE t0.roadmap_item_id = ?
Parameters:
[
  "019aef75-8644-742d-bd7d-f39b3c185178"
]
3 0.60 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.roadmap_item_id AS roadmap_item_id_3, t0.user_id AS user_id_4 FROM roadmap_votes t0 WHERE t0.roadmap_item_id = ?
Parameters:
[
  "019aef75-867f-74ae-bc12-e9fac162b610"
]
4 0.51 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.roadmap_item_id AS roadmap_item_id_3, t0.user_id AS user_id_4 FROM roadmap_votes t0 WHERE t0.roadmap_item_id = ?
Parameters:
[
  "019aef75-86df-7cfa-bf49-7026e6bb9a3c"
]
5 0.48 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.roadmap_item_id AS roadmap_item_id_3, t0.user_id AS user_id_4 FROM roadmap_votes t0 WHERE t0.roadmap_item_id = ?
Parameters:
[
  "019ae3ff-f07a-7227-9f78-2e8969becc28"
]

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\RoadmapItem 4

Entities Mapping

Class Mapping errors
App\Entity\RoadmapItem No errors.
App\Entity\User No errors.
App\Entity\RoadmapVote No errors.