https://test01.nextcaddy.com/provincias/4

Query Metrics

160 Database Queries
5 Different statements
16.59 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
7.55 ms
(45.52%)
134
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  73
]
7.07 ms
(42.64%)
1
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.nombre_canonical AS nombre_canonical_2, c0_.created_at AS created_at_3, c0_.nombre_corto AS nombre_corto_4, c0_.direccion AS direccion_5, c0_.telefono AS telefono_6, c0_.web AS web_7, c0_.rfeg_id AS rfeg_id_8, c0_.intervalo_facturacion AS intervalo_facturacion_9, c0_.minimo_factura AS minimo_factura_10, c0_.latitud AS latitud_11, c0_.longitud AS longitud_12, c0_.habilitado AS habilitado_13, c0_.graphql_enabled AS graphql_enabled_14, c0_.graphql_key AS graphql_key_15, c0_.graphql_signature AS graphql_signature_16, c0_.visible AS visible_17, c0_.allowTpv AS allowTpv_18, c0_.externalId AS externalId_19, c0_.rfc_seguro AS rfc_seguro_20, c0_.flickr_gallery AS flickr_gallery_21, c0_.livescoring_policy AS livescoring_policy_22, c0_.localidad_id AS localidad_id_23, c0_.User_id AS User_id_24, c0_.Cliente_id AS Cliente_id_25, c0_.timezone_id AS timezone_id_26 FROM Club c0_ INNER JOIN Localidad l1_ ON (c0_.localidad_id = l1_.id) INNER JOIN Provincia p2_ ON (l1_.provincia_id = p2_.id) WHERE c0_.id NOT IN ('AMXX', 'CMXX', 'AM00', 'CM00', 'AMLP', 'JGLF', '7700', 'EQLT', 'MAJC', 'AMX1') AND c0_.habilitado = 1 AND c0_.visible = 1 AND p2_.comunidad_id IN (1, 10, 13, 14, 7, 5) ORDER BY p2_.comunidad_id ASC, p2_.id ASC, c0_.nombre ASC
Parameters:
[]
1.32 ms
(7.95%)
23
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.56 ms
(3.36%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.default_logo AS default_logo_3 FROM Comunidad t0
Parameters:
[]
0.09 ms
(0.52%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0
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\Club No errors.
App\Entity\Backend\Provincia No errors.
App\Entity\Backend\Comunidad No errors.
App\Entity\Backend\Localidad
  • The field App\Entity\Backend\Localidad#clubes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Backend\Club#localidad does not contain the required 'inversedBy="clubes"' attribute.
App\Entity\User\User No errors.
App\Entity\Backend\Cliente No errors.
App\Entity\Backend\Timezone 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\Socio No errors.
App\Entity\Backend\Empleado No errors.
App\Entity\Backend\Federacion No errors.
App\Entity\Backend\Voucher No errors.
App\Entity\Gestion\Ranking
  • The association App\Entity\Gestion\Ranking#ranking_point_position_template refers to the inverse side field App\Entity\Backend\RankingPointPositionTemplate#rankings which does not exist.
App\Entity\Backend\RankingPointPositionTemplate No errors.
App\Entity\Backend\ExternalCompetition No errors.

encrypt entity manager

No loaded entities.