Query Metrics

7 Database Queries
4 Different statements
5.81 ms Query time
0 Invalid entities
13 Managed entities

Queries

Group similar statements

# Time Info
1 1.79 ms
SELECT DISTINCT s0_.id AS id_0, s0_.active AS active_1 FROM service s0_ ORDER BY s0_.active ASC LIMIT 20
Parameters:
[]
2 0.99 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.price AS price_3, s0_.duration AS duration_4, s0_.active AS active_5, s0_.relation AS relation_6, s0_.category_id AS category_id_7 FROM service s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.active ASC
Parameters:
[
  28
  29
  30
  31
  32
  33
  34
  35
  36
]
3 0.67 ms
SELECT count(*) AS sclr_0 FROM service s0_
Parameters:
[]
4 0.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
  13
]
5 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
  14
]
6 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
  15
]
7 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
  16
]

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\Service 9
App\Entity\Category 4

Entities Mapping

Class Mapping errors
App\Entity\Service No errors.
App\Entity\Category No errors.
App\Entity\Reservation No errors.