Query Metrics
6
Database Queries
6
Different statements
5.18 ms
Query time
6
Invalid entities
7
Managed entities
Queries
#▲ | 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 |
|
App\Entity\Localidad | No errors. |
App\Entity\Turnero\ConfiguracionClienteTurnero |
|
App\Entity\ClienteAgenteSolicitud | No errors. |
App\Entity\ModulosContratados |
|
App\Entity\Asociacion | No errors. |
App\Entity\CentroAtencion |
|
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 |
|
App\Entity\Rol | No errors. |
App\Entity\Sexo | No errors. |
App\Entity\HistorialEstadosLicencia | No errors. |
App\Entity\Licencia |
|
App\Entity\DictamenNew | No errors. |
App\Entity\DictamenJM | No errors. |
App\Entity\Funcionalidad | No errors. |