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

Queries

Group similar statements

# Time Info
1 0.42 ms
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
]
2 0.23 ms
DELETE rs FROM result_swimmer rs INNER JOIN result r ON r.id = rs.result_id WHERE r.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 1
]
3 0.21 ms
DELETE r FROM result r WHERE r.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 1
]
4 0.19 ms
DELETE cs FROM competition_swimmer cs WHERE cs.competition_id = :idCompetition;
Parameters:
[
  "idCompetition" => 1
]
5 0.16 ms
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.