GET https://701130.web24.swisscenter.com/admin/app/certificate/list?filters=reset

Query Metrics

18 Database Queries
5 Different statements
14.44 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.49 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.ordering AS ordering_2, p0_.type_id AS type_id_3 FROM position p0_
Parameters:
[]
2 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
Parameters:
[
  3
]
5 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
6 2.54 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM certificate c0_
Parameters:
[]
7 0.72 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.orange_period AS orange_period_2, c0_.red_period AS red_period_3 FROM certificate c0_ ORDER BY c0_.id ASC LIMIT 25
Parameters:
[]
8 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  1
]
9 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  2
]
10 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  3
]
11 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  4
]
12 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  5
]
13 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  6
]
14 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  7
]
15 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  8
]
16 0.82 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  9
]
17 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  10
]
18 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = ?
Parameters:
[
  11
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Certificate No errors.
App\Entity\Position No errors.
App\Entity\PositionType No errors.
App\Entity\Employee No errors.
App\Entity\Training No errors.