https://test01.nextcaddy.com/circuitos/31

Query Metrics

20 Database Queries
4 Different statements
38.09 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.94 ms
SELECT c0_.nombre AS nombre_0, c1_.id AS id_1, c1_.nombre AS nombre_2, c1_.wagr AS wagr_3, c1_.estado AS estado_4, c1_.fecha AS fecha_5, c2_.nombre AS nombre_6, c1_.estado AS estado_7, c1_.Modo_id AS sclr_8 FROM Circuito c0_ INNER JOIN Circuito_Competicion c3_ ON c0_.id = c3_.circuito_id INNER JOIN Competicion c1_ ON c1_.id = c3_.competicion_id AND (c1_.deleted_at IS NULL) INNER JOIN Club c2_ ON c1_.Club_id = c2_.id WHERE c0_.id = ? AND c1_.estado <> 'fecha indeterminada' ORDER BY c1_.fecha ASC
Parameters:
[
  "31"
]
2 1.87 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13032
]
3 1.99 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13033
]
4 0.93 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13034
]
5 3.57 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13051
]
6 0.87 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13052
]
7 0.48 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13050
]
8 4.20 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13088
]
9 2.95 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13089
]
10 0.79 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13090
]
11 0.76 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13100
]
12 2.70 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13112
]
13 3.39 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13114
]
14 2.61 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13113
]
15 2.32 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13127
]
16 4.36 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13128
]
17 2.23 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13129
]
18 0.67 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13131
]
19 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cartel AS cartel_3, t0.fecha_inicio AS fecha_inicio_4, t0.fecha_fin AS fecha_fin_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.destacada AS destacada_8, t0.Cliente_id AS Cliente_id_9 FROM Circuito t0 WHERE t0.id = ?
Parameters:
[
  "31"
]
20 0.24 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.activo AS activo_4, t0.slug AS slug_5, t0.rfga_id AS rfga_id_6, t0.url AS url_7, t0.tipo AS tipo_8, t0.active_federation AS active_federation_9, t0.Cliente_id AS Cliente_id_10 FROM Comite t0 INNER JOIN Comite_Circuito ON t0.id = Comite_Circuito.Comite_id WHERE Comite_Circuito.Circuito_id = ?
Parameters:
[
  31
]

Database Connections

Name Service
default doctrine.dbal.default_connection
encrypt doctrine.dbal.encrypt_connection
nodoql doctrine.dbal.nodoql_connection
copy_to_check doctrine.dbal.copy_to_check_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
encrypt doctrine.orm.encrypt_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Backend\Circuito No errors.
App\Entity\Backend\Competicion
  • The mappings App\Entity\Backend\Competicion#competitionSectionHidden and App\Entity\Backend\CompetitionSectionHidden#competition are inconsistent with each other.
App\Entity\Backend\Club No errors.
App\Entity\Backend\Modo No errors.
App\Entity\Backend\Inscrito No errors.
App\Entity\Backend\Cliente No errors.
App\Entity\Backend\Comite No errors.
App\Entity\Backend\AutorizadasCircuito No errors.

encrypt entity manager

No loaded entities.