GET https://budget.higumadev.fr/api/categories?page=1&search=

Query Metrics

12 Database Queries
3 Different statements
2.51 ms Query time
0 Invalid entities
25 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.67 ms
(66.53%)
10
SELECT t0.id AS id_1, t0.name AS name_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.category_id AS category_id_6 FROM sub_category t0 WHERE t0.category_id = ?
Parameters:
[
  21
]
0.48 ms
(18.99%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.color AS color_2, c0_.uuid AS uuid_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.user_id AS user_id_6 FROM category c0_ WHERE c0_.user_id = ? ORDER BY c0_.name ASC
Parameters:
[
  1
]
0.36 ms
(14.48%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.username AS username_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.uuid AS uuid_8, t0.roles AS roles_9, t0.password AS password_10, t0.profile_picture AS profile_picture_11 FROM `user` t0 WHERE t0.id = ?
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\SubCategory 13
App\Entity\Category 11
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Category No errors.
App\Entity\SubCategory No errors.