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

Query Metrics

11 Database Queries
4 Different statements
42.58 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 2.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:
[
  "28"
]
2 4.21 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13029
]
3 4.12 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13054
]
4 5.64 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13133
]
5 3.98 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13134
]
6 2.99 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13135
]
7 8.15 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13137
]
8 3.98 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13139
]
9 4.08 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13140
]
10 1.70 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:
[
  "28"
]
11 0.80 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:
[
  28
]

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.