GET http://qa-sid.dienst.ar/api/public/clientes/rionegro-qa.dienst.ar

Query Metrics

4 Database Queries
4 Different statements
4.45 ms Query time
10 Invalid entities
22 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.98 ms
(44.49%)
1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.codigo_postal AS codigo_postal_3, t0.municipio_id AS municipio_id_4 FROM localidad t0 WHERE t0.id = ?
Parameters:
[
  3345
]
0.88 ms
(19.81%)
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 = ? LIMIT 1
Parameters:
[
  "rionegro-qa.dienst.ar"
]
0.87 ms
(19.48%)
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 = ? LIMIT 1
Parameters:
[
  "qa-sid.dienst.ar"
]
0.72 ms
(16.22%)
1
SELECT t0.id AS id_1, t0.cuit AS cuit_2, t0.telefono AS telefono_3, t0.email AS email_4, t0.nombre AS nombre_5, t0.calle AS calle_6, t0.numero AS numero_7, t0.piso AS piso_8, t0.departamento AS departamento_9, t0.codigo_postal AS codigo_postal_10, t0.referente AS referente_11, t0.dias_yhoras_atencion AS dias_yhoras_atencion_12, t0.cantidad_consultorios AS cantidad_consultorios_13, t0.latitud AS latitud_14, t0.longitud AS longitud_15, t0.habilitado AS habilitado_16, t0.localidad_id AS localidad_id_17, t0.modalidad_id AS modalidad_id_18 FROM centro_atencion t0 INNER JOIN centro_atencion_cliente ON t0.id = centro_atencion_cliente.centro_atencion_id WHERE centro_atencion_cliente.cliente_id = ?
Parameters:
[
  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
App\Entity\Localidad 9
App\Entity\CentroAtencion 9
App\Entity\ModalidadSolicitud 2
App\Entity\Cliente 1
App\Entity\Municipio 1

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.
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\Municipio
  • The association App\Entity\Municipio#clientes refers to the owning side field App\Entity\Cliente#municipio which does not exist.
  • The association App\Entity\Municipio#licencias refers to the owning side field App\Entity\Licencia#municipio which does not exist.
  • The association App\Entity\Municipio#agentes refers to the owning side field App\Entity\Agente#municipio which does not exist.
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\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\ModalidadSolicitud
  • The association App\Entity\ModalidadSolicitud#solicitudes refers to the owning side field App\Entity\SolicitudLicenciaCliente#modalidadSolicitud which does not exist.
App\Entity\ValoresCentroAtencion No errors.
App\Entity\AdministradorCentro No errors.
App\Entity\SolicitudLicenciaCliente
  • The association App\Entity\SolicitudLicenciaCliente#centroMedicoJuntaMedica refers to the inverse side field App\Entity\CentroAtencion#solicitudLicenciaClientes which does not exist.
App\Entity\Turnero\Consultorio
  • The field App\Entity\Turnero\Consultorio#horarios is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Turnero\HorarioAtencion#consultorio does not contain the required 'inversedBy="horarios"' attribute.
App\Entity\Especialidad No errors.
App\Entity\TipoCentroAtencion No errors.

read entity manager

No loaded entities.