GET https://701130.web24.swisscenter.com/admin/app/certificate/list

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.41 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.25 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
Parameters:
[
  3
]
5 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
6 1.14 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM certificate c0_
Parameters:
[]
7 0.31 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.41 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.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:
[
  2
]
10 3.01 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.43 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.35 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.35 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.38 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.35 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.35 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.32 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.39 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.