GET http://51.83.79.128:8005/competition/delete/1

Query Metrics

5 Database Queries
5 Different statements
1.21 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.42 ms
(34.65%)
1
DELETE rsp FROM result_swimmer_split rsp INNER JOIN result_swimmer rs ON rs.id = rsp.result_swimmer_id INNER JOIN result r ON r.id = rs.result_id WHERE r.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 1
]
0.23 ms
(18.74%)
1
DELETE rs FROM result_swimmer rs INNER JOIN result r ON r.id = rs.result_id WHERE r.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 1
]
0.21 ms
(17.59%)
1
DELETE r FROM result r WHERE r.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 1
]
0.19 ms
(15.52%)
1
DELETE cs FROM competition_swimmer cs WHERE cs.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 1
]
0.16 ms
(13.50%)
1
DELETE c FROM competition c WHERE c.id = :idCompetition;
Parameters:
[
  "idCompetition" => 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

Entities Mapping

Class Mapping errors
App\Entity\Competition No errors.