Query Metrics
160
Database Queries
5
Different statements
16.59 ms
Query time
3
Invalid entities
Grouped Statements
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 |
|
| App\Entity\User\User | No errors. |
| App\Entity\Backend\Cliente | No errors. |
| App\Entity\Backend\Timezone | No errors. |
| App\Entity\Backend\Competicion |
|
| 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 |
|
| App\Entity\Backend\RankingPointPositionTemplate | No errors. |
| App\Entity\Backend\ExternalCompetition | No errors. |
encrypt entity manager
No loaded entities.