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

Query Metrics

13 Database Queries
4 Different statements
170.85 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 61.18 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:
[
  "21"
]
2 61.62 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  10873
]
3 1.78 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  10874
]
4 16.01 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  10886
]
5 3.56 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  10887
]
6 3.61 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  11321
]
7 6.48 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  11314
]
8 0.62 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  11824
]
9 4.42 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  11924
]
10 0.90 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  11925
]
11 2.05 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  11936
]
12 0.38 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:
[
  "21"
]
13 8.23 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:
[
  21
]

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.
App\Entity\Backend\AsignacionAnualComite No errors.
App\Entity\Backend\DocumentoContabilidad No errors.

encrypt entity manager

No loaded entities.