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

Query Metrics

22 Database Queries
4 Different statements
22.26 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.24 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:
[
  "30"
]
2 2.35 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13040
]
3 0.57 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13042
]
4 0.73 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13173
]
5 0.63 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13175
]
6 1.06 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13174
]
7 0.96 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13092
]
8 2.84 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13093
]
9 0.46 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13094
]
10 0.21 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13096
]
11 0.89 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13102
]
12 0.58 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13106
]
13 0.63 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13104
]
14 2.91 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  17935
]
15 0.78 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  17936
]
16 1.01 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13120
]
17 0.76 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13124
]
18 0.97 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13122
]
19 1.59 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13126
]
20 0.69 ms
SELECT COUNT(i0_.id) AS sclr_0 FROM Inscrito i0_ WHERE i0_.Competicion_id = ? AND i0_.estado = 'pagado'
Parameters:
[
  13160
]
21 0.15 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:
[
  "30"
]
22 0.25 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:
[
  30
]

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.