Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.13 ms Query time

4 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.13 ms (100.00%)	1	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.dominio_backend = ? LIMIT 1 Parameters: [`"horizonte-sid-qa.dienst.ar"`] View formatted query View runnable query Explain query 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.dominio_backend = ? LIMIT 1 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.dominio_backend = 'horizonte-sid-qa.dienst.ar' LIMIT 1;

Time▼

Count

Info

1.13 ms
(100.00%)

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.dominio_backend = ? LIMIT 1

Parameters:

[
  "horizonte-sid-qa.dienst.ar"
]

View formatted query View runnable query Explain query

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.dominio_backend = ?
LIMIT
  1

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.dominio_backend = 'horizonte-sid-qa.dienst.ar' LIMIT 1;

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

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.

Symfony Profiler

GET http://horizonte-sid-qa.dienst.ar/login

Configuration Settings

Theme

Page Width