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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
0.42 ms
(38.72%)
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" => 3
]
0.20 ms
(19.02%)
1
DELETE rs FROM result_swimmer rs INNER JOIN result r ON r.id = rs.result_id WHERE r.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 3
]
0.16 ms
(15.01%)
1
DELETE r FROM result r WHERE r.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 3
]
0.15 ms
(14.19%)
1
DELETE cs FROM competition_swimmer cs WHERE cs.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 3
]
0.14 ms
(13.06%)
1
DELETE c FROM competition c WHERE c.id = :idCompetition;
Parameters:
[
  "idCompetition" => 3
]

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.