https://test01.nextcaddy.com/

Query Metrics

3 Database Queries
3 Different statements
91.46 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
56.48 ms
(61.75%)
1
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c1_.nombre AS nombre_2, DATE_FORMAT(c0_.fecha, '%Y-%m-%dT%H:%i:%s') AS sclr_3, DATE_FORMAT(c0_.fin, '%Y-%m-%dT%H:%i:%s') AS sclr_4, c0_.plazas AS plazas_5, c0_.lista_espera AS lista_espera_6 FROM Competicion c0_ INNER JOIN Club c2_ ON (c2_.id = c0_.Organizador_id) INNER JOIN Club c1_ ON (c1_.id = c0_.Club_id) INNER JOIN Modo m3_ ON (m3_.id = c0_.Modo_id) WHERE (c0_.estado = 'abierta' AND m3_.codigo = 'ONL' AND c0_.visible = 1 AND c0_.fin >= ? AND c2_.id LIKE '%00') AND (c0_.deleted_at IS NULL) ORDER BY c0_.fin ASC LIMIT 12
Parameters:
[
  "26-02-04"
]
34.35 ms
(37.56%)
1
SELECT MAX(c0_.id) AS sclr_0 FROM Competicion c0_ WHERE (c0_.deleted_at IS NULL)
Parameters:
[]
0.63 ms
(0.69%)
1
SELECT CAST(MAX(id) - 496781 AS SIGNED) AS resultado FROM Inscrito
Parameters:
[]

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\Competicion
  • The mappings App\Entity\Backend\Competicion#competitionSectionHidden and App\Entity\Backend\CompetitionSectionHidden#competition are inconsistent with each other.
App\Entity\Backend\Inscrito No errors.
App\Entity\Backend\Club No errors.
App\Entity\Backend\Modo No errors.

encrypt entity manager

No loaded entities.