Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

2.16 ms Query time

3 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	2.16 ms	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_ WHERE c0_.id NOT IN ('AMXX', 'CMXX', 'AMX1', 'AM00', 'CM00') AND c0_.habilitado = 1 Parameters: [] View formatted query View runnable query Explain query 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_ WHERE c0_.id NOT IN ( 'AMXX', 'CMXX', 'AMX1', 'AM00', 'CM00' ) AND c0_.habilitado = 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_ WHERE c0_.id NOT IN ('AMXX', 'CMXX', 'AMX1', 'AM00', 'CM00') AND c0_.habilitado = 1;

#▲

Time

Info

2.16 ms

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_ WHERE c0_.id NOT IN ('AMXX', 'CMXX', 'AMX1', 'AM00', 'CM00') AND c0_.habilitado = 1

Parameters:

[]

View formatted query View runnable query Explain query

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_
WHERE
  c0_.id NOT IN (
    'AMXX', 'CMXX', 'AMX1', 'AM00', 'CM00'
  )
  AND c0_.habilitado = 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_ WHERE c0_.id NOT IN ('AMXX', 'CMXX', 'AMX1', 'AM00', 'CM00') AND c0_.habilitado = 1;

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\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.