Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.92 ms Query time

1 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.92 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.jm_con_reprogramacion AS jm_con_reprogramacion_48, t0.maneja_centro_costo AS maneja_centro_costo_49, t0.permite_aviso_ausente AS permite_aviso_ausente_50, t0.cantidad_horas_aviso_ausente AS cantidad_horas_aviso_ausente_51, t0.notifica_por_defecto AS notifica_por_defecto_52, t0.certificado_obligatorio AS certificado_obligatorio_53, t0.maneja_coincidencia_geolocalizacion AS maneja_coincidencia_geolocalizacion_54, t0.localidad_id AS localidad_id_55 FROM cliente t0 WHERE t0.dominio_backend = ? LIMIT 1 Parameters: [`"qa-sid.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.jm_con_reprogramacion AS jm_con_reprogramacion_48, t0.maneja_centro_costo AS maneja_centro_costo_49, t0.permite_aviso_ausente AS permite_aviso_ausente_50, t0.cantidad_horas_aviso_ausente AS cantidad_horas_aviso_ausente_51, t0.notifica_por_defecto AS notifica_por_defecto_52, t0.certificado_obligatorio AS certificado_obligatorio_53, t0.maneja_coincidencia_geolocalizacion AS maneja_coincidencia_geolocalizacion_54, t0.localidad_id AS localidad_id_55 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.jm_con_reprogramacion AS jm_con_reprogramacion_48, t0.maneja_centro_costo AS maneja_centro_costo_49, t0.permite_aviso_ausente AS permite_aviso_ausente_50, t0.cantidad_horas_aviso_ausente AS cantidad_horas_aviso_ausente_51, t0.notifica_por_defecto AS notifica_por_defecto_52, t0.certificado_obligatorio AS certificado_obligatorio_53, t0.maneja_coincidencia_geolocalizacion AS maneja_coincidencia_geolocalizacion_54, t0.localidad_id AS localidad_id_55 FROM cliente t0 WHERE t0.dominio_backend = 'qa-sid.dienst.ar' LIMIT 1;

#▲

Time

Info

0.92 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.jm_con_reprogramacion AS jm_con_reprogramacion_48, t0.maneja_centro_costo AS maneja_centro_costo_49, t0.permite_aviso_ausente AS permite_aviso_ausente_50, t0.cantidad_horas_aviso_ausente AS cantidad_horas_aviso_ausente_51, t0.notifica_por_defecto AS notifica_por_defecto_52, t0.certificado_obligatorio AS certificado_obligatorio_53, t0.maneja_coincidencia_geolocalizacion AS maneja_coincidencia_geolocalizacion_54, t0.localidad_id AS localidad_id_55 FROM cliente t0 WHERE t0.dominio_backend = ? LIMIT 1

Parameters:

[
  "qa-sid.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.jm_con_reprogramacion AS jm_con_reprogramacion_48,
  t0.maneja_centro_costo AS maneja_centro_costo_49,
  t0.permite_aviso_ausente AS permite_aviso_ausente_50,
  t0.cantidad_horas_aviso_ausente AS cantidad_horas_aviso_ausente_51,
  t0.notifica_por_defecto AS notifica_por_defecto_52,
  t0.certificado_obligatorio AS certificado_obligatorio_53,
  t0.maneja_coincidencia_geolocalizacion AS maneja_coincidencia_geolocalizacion_54,
  t0.localidad_id AS localidad_id_55
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.jm_con_reprogramacion AS jm_con_reprogramacion_48, t0.maneja_centro_costo AS maneja_centro_costo_49, t0.permite_aviso_ausente AS permite_aviso_ausente_50, t0.cantidad_horas_aviso_ausente AS cantidad_horas_aviso_ausente_51, t0.notifica_por_defecto AS notifica_por_defecto_52, t0.certificado_obligatorio AS certificado_obligatorio_53, t0.maneja_coincidencia_geolocalizacion AS maneja_coincidencia_geolocalizacion_54, t0.localidad_id AS localidad_id_55 FROM cliente t0 WHERE t0.dominio_backend = 'qa-sid.dienst.ar' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
replica	doctrine.dbal.replica_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
read	doctrine.orm.read_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

read entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

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.

read entity manager

No loaded entities.

Symfony Profiler

GET http://qa-sid.dienst.ar/_profiler

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

read entity manager

Entities Mapping

default entity manager

read entity manager