POST http://qa-sid.dienst.ar/api/public/login

Query Metrics

6 Database Queries
6 Different statements
5.18 ms Query time
6 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 1.63 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.razon_social AS razon_social_3, t0.cuit AS cuit_4, t0.email AS email_5, t0.telefono AS telefono_6, t0.calle AS calle_7, t0.altura AS altura_8, t0.piso AS piso_9, t0.departamento AS departamento_10, t0.entre_calle1 AS entre_calle1_11, t0.entre_calle2 AS entre_calle2_12, t0.codigo_postal AS codigo_postal_13, t0.numero_dienst AS numero_dienst_14, t0.activo AS activo_15, t0.slug AS slug_16, t0.servidor_smtp AS servidor_smtp_17, t0.responder_a AS responder_a_18, t0.puerto_smtp AS puerto_smtp_19, t0.protocolo_smtp AS protocolo_smtp_20, t0.usuario_smtp AS usuario_smtp_21, t0.password_smtp AS password_smtp_22, t0.header AS header_23, t0.footer AS footer_24, t0.body_html AS body_html_25, t0.titulo_text AS titulo_text_26, t0.descripcion_html AS descripcion_html_27, t0.logo AS logo_28, t0.logo_banner AS logo_banner_29, t0.imagen_fondo AS imagen_fondo_30, t0.icono AS icono_31, t0.dominio AS dominio_32, t0.dominio_backend AS dominio_backend_33, t0.color_primario AS color_primario_34, t0.color_secundario AS color_secundario_35, t0.logo_base64 AS logo_base64_36, t0.cant_dias_fecha_solicitud_para_atras AS cant_dias_fecha_solicitud_para_atras_37, t0.brinda_readecuacion AS brinda_readecuacion_38, t0.permite_registro AS permite_registro_39, t0.permite_registro_publico AS permite_registro_publico_40, t0.terminos_ycondiciones AS terminos_ycondiciones_41, t0.prefijo AS prefijo_42, t0.codigo_licencia_interno AS codigo_licencia_interno_43, t0.notifica_responsable_en_citacion AS notifica_responsable_en_citacion_44, t0.notifica_responsable_en_auditoria AS notifica_responsable_en_auditoria_45, t0.notifica_responsable_en_solicitud AS notifica_responsable_en_solicitud_46, t0.brinda_jm AS brinda_jm_47, t0.localidad_id AS localidad_id_48 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 1.06 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.apellido AS apellido_4, u0_.nombre AS nombre_5, u0_.super_admin AS super_admin_6, u0_.habilitado AS habilitado_7, u0_.reset_token AS reset_token_8, u0_.reset_token_expires_at AS reset_token_expires_at_9, u0_.rol_id AS rol_id_10 FROM usuario u0_ INNER JOIN agente a1_ ON u0_.id = a1_.usuario_id WHERE a1_.cuil = ? AND u0_.habilitado = 1
Parameters:
[
  "20-37344843-6"
]
3 0.70 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.dni AS dni_4, t0.email AS email_5, t0.fecha_nacimiento AS fecha_nacimiento_6, t0.telefono AS telefono_7, t0.calle AS calle_8, t0.altura AS altura_9, t0.departamento AS departamento_10, t0.entre_calle1 AS entre_calle1_11, t0.entre_calle2 AS entre_calle2_12, t0.legajo AS legajo_13, t0.cuil AS cuil_14, t0.codigo_postal AS codigo_postal_15, t0.latitud AS latitud_16, t0.longitud AS longitud_17, t0.search_localidad AS search_localidad_18, t0.localidad_id AS localidad_id_19, t0.usuario_id AS usuario_id_20, t0.sexo_id AS sexo_id_21, t0.centro_atencion_id AS centro_atencion_id_22, t0.centro_atencion_junta_medica_id AS centro_atencion_junta_medica_id_23, t0.ocupacion_id AS ocupacion_id_24 FROM agente t0 WHERE t0.usuario_id = ?
Parameters:
[
  139
]
4 0.67 ms
SELECT t0.id AS id_1, t0.legajo AS legajo_2, t0.tiene_alerta AS tiene_alerta_3, t0.motivo_alerta AS motivo_alerta_4, t0.cliente_id AS cliente_id_5, t0.agente_id AS agente_id_6, t0.ocupacion_id AS ocupacion_id_7, t0.centro_atencion_id AS centro_atencion_id_8 FROM cliente_agente t0 WHERE t0.cliente_id = ? AND t0.agente_id = ? LIMIT 1
Parameters:
[
  3
  17392
]
5 0.53 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.role AS role_3 FROM rol t0 WHERE t0.id = ?
Parameters:
[
  6
]
6 0.60 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.rol AS rol_3 FROM funcionalidad t0 INNER JOIN rol_funcionalidad ON t0.id = rol_funcionalidad.funcionalidad_id WHERE rol_funcionalidad.rol_id = ?
Parameters:
[
  6
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Cliente 1
App\Entity\Localidad 1
App\Entity\Usuario 1
App\Entity\Rol 1
App\Entity\Agente 1
App\Entity\Ocupacion 1
App\Entity\ClienteAgente 1

Entities Mapping

Class Mapping errors
App\Entity\Cliente
  • The mappings App\Entity\Cliente#configuracionesTurnero and App\Entity\Turnero\ConfiguracionClienteTurnero#cliente are inconsistent with each other.
App\Entity\Localidad No errors.
App\Entity\Turnero\ConfiguracionClienteTurnero
  • The field 'App\Entity\Turnero\ConfiguracionClienteTurnero#radio' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ClienteAgenteSolicitud No errors.
App\Entity\ModulosContratados
  • The association App\Entity\ModulosContratados#configuracionesTurnero refers to the owning side field App\Entity\Turnero\ConfiguracionTurnero#moduloContratado which does not exist.
App\Entity\Asociacion No errors.
App\Entity\CentroAtencion
  • The field 'App\Entity\CentroAtencion#latitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\CentroAtencion#longitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\Entity\CentroAtencion#consultorios is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Turnero\Consultorio#centroMedico does not contain the required 'inversedBy="consultorios"' attribute.
App\Entity\SolicitudLicencia No errors.
App\Entity\Dependencia No errors.
App\Entity\Ocupacion No errors.
App\Entity\AdministradorCliente No errors.
App\Entity\ClienteAgente No errors.
App\Entity\ConfiguracionAlerta No errors.
App\Entity\Prestador No errors.
App\Entity\Usuario No errors.
App\Entity\Agente
  • The field 'App\Entity\Agente#latitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Agente#longitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The association App\Entity\Agente#clientes refers to the owning side field App\Entity\Cliente#agentes which does not exist.
App\Entity\Rol No errors.
App\Entity\Sexo No errors.
App\Entity\HistorialEstadosLicencia No errors.
App\Entity\Licencia
  • The field 'App\Entity\Licencia#latitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Licencia#longitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\DictamenNew No errors.
App\Entity\DictamenJM No errors.
App\Entity\Funcionalidad No errors.