Query Metrics
1161
Database Queries
8
Different statements
154.13 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
77.25 ms (50.12%) |
622 |
SELECT t0.id AS id_1, t0.fecha_ingreso_trabajar AS fecha_ingreso_trabajar_2, t0.horario_laboral AS horario_laboral_3, t0.horas_trabajadas AS horas_trabajadas_4, t0.remuneracion AS remuneracion_5, t0.fecha_egreso AS fecha_egreso_6, t0.is_active AS is_active_7, t0.empresa_id AS empresa_id_8, t0.sucursal_id AS sucursal_id_9, t0.user_cargo_id AS user_cargo_id_10, t0.cargo_id AS cargo_id_11, t0.empleado_id AS empleado_id_12 FROM empleado_empresa_sucursal t0 WHERE t0.empleado_id = ? AND t0.is_active = ?
Parameters:
[ 1 1 ] |
37.66 ms (24.43%) |
313 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.porcentaje AS porcentaje_3, t0.ente_banco AS ente_banco_4, t0.nombre_corto AS nombre_corto_5, t0.articulo_numero AS articulo_numero_6, t0.is_active AS is_active_7, t0.admin_cargo_id AS admin_cargo_id_8 FROM concepto t0 INNER JOIN empleado_concepto ON t0.id = empleado_concepto.concepto_id WHERE empleado_concepto.empleado_id = ?
Parameters:
[
1
]
|
18.02 ms (11.69%) |
36 |
SELECT t0.id AS id_3, t0.nombre AS nombre_4, t0.apellido AS apellido_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.foto AS foto_9, t0.is_verified AS is_verified_10, t0.enabled AS enabled_11, t0.register_date AS register_date_12, t0.id_viejo AS id_viejo_13, t0.discr, t2.matricula AS matricula_14, t2.domicilio AS domicilio_15, t2.telefono_fijo AS telefono_fijo_16, t2.celular AS celular_17, t2.nombre_del_estudio AS nombre_del_estudio_18, t2.localidad_id AS localidad_id_19 FROM `user` t0 LEFT JOIN `admin` t1 ON t0.id = t1.id LEFT JOIN `contador` t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
1
]
|
12.19 ms (7.91%) |
107 |
SELECT t0.id AS id_1, t0.razon_social AS razon_social_2, t0.titular AS titular_3, t0.nombre_fantasia AS nombre_fantasia_4, t0.cuit AS cuit_5, t0.fecha_alta AS fecha_alta_6, t0.domicilio_empresa AS domicilio_empresa_7, t0.domicilio_afip AS domicilio_afip_8, t0.telefono_empresa AS telefono_empresa_9, t0.inicio_actividad AS inicio_actividad_10, t0.fecha_ingreso_sindicato AS fecha_ingreso_sindicato_11, t0.socios AS socios_12, t0.is_active AS is_active_13, t0.enabled AS enabled_14, t0.localidad_id AS localidad_id_15, t0.admin_cargo_id AS admin_cargo_id_16, t0.estado_empresa_id AS estado_empresa_id_17 FROM empresa t0 WHERE t0.id = ?
Parameters:
[
4
]
|
6.46 ms (4.19%) |
66 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.entre_calles AS entre_calles_4, t0.latitud AS latitud_5, t0.longitud AS longitud_6, t0.fecha_alta AS fecha_alta_7, t0.is_active AS is_active_8, t0.localidad_id AS localidad_id_9, t0.user_id AS user_id_10, t0.empresa_id AS empresa_id_11 FROM sucursal t0 WHERE t0.id = ?
Parameters:
[
87
]
|
1.15 ms (0.74%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.dni AS dni_4, t0.cuil AS cuil_5, t0.email AS email_6, t0.horario_laboral AS horario_laboral_7, t0.fecha_nacimiento AS fecha_nacimiento_8, t0.nacionalidad AS nacionalidad_9, t0.provincia AS provincia_10, t0.domicilio AS domicilio_11, t0.telefono AS telefono_12, t0.motivo AS motivo_13, t0.fecha_alta_afip AS fecha_alta_afip_14, t0.fecha_limite_mutual AS fecha_limite_mutual_15, t0.fecha_limite_obra_social AS fecha_limite_obra_social_16, t0.horas_trabajadas AS horas_trabajadas_17, t0.horas_trabajadas_declarada_por_empleado AS horas_trabajadas_declarada_por_empleado_18, t0.horas_trabajadas_acuerdo AS horas_trabajadas_acuerdo_19, t0.fecha_ingreso_trabajar AS fecha_ingreso_trabajar_20, t0.fecha_ingreso_trabajar_acuerdo AS fecha_ingreso_trabajar_acuerdo_21, t0.fecha_egreso_acuerdo AS fecha_egreso_acuerdo_22, t0.fecha_ingreso_sindicato AS fecha_ingreso_sindicato_23, t0.remuneracion AS remuneracion_24, t0.estado_civil AS estado_civil_25, t0.harina AS harina_26, t0.otra_obra_social AS otra_obra_social_27, t0.sexo AS sexo_28, t0.fecha_baja AS fecha_baja_29, t0.caja AS caja_30, t0.presentismo AS presentismo_31, t0.foto AS foto_32, t0.aguinaldo AS aguinaldo_33, t0.fecha_register AS fecha_register_34, t0.afiliado AS afiliado_35, t0.fecha_alta_temprana AS fecha_alta_temprana_36, t0.is_active AS is_active_37, t0.localidad_id AS localidad_id_38, t0.empresa_id AS empresa_id_39, t0.sucursal_id AS sucursal_id_40, t0.user_cargo_id AS user_cargo_id_41, t0.cargo_id AS cargo_id_42, t0.cargo_acuerdo_id AS cargo_acuerdo_id_43, t0.motivo_liquidacion_empleado_id AS motivo_liquidacion_empleado_id_44 FROM empleado t0 WHERE t0.afiliado = ?
Parameters:
[
1
]
|
0.84 ms (0.55%) |
9 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo_postal AS codigo_postal_3, t0.is_active AS is_active_4, t0.zona_id AS zona_id_5 FROM localidad t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.56 ms (0.36%) |
7 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.horas_minima AS horas_minima_3, t0.is_active AS is_active_4 FROM cargo t0 WHERE t0.id = ?
Parameters:
[
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Admin | No errors. |
App\Entity\Contador | No errors. |
App\Entity\Localidad | No errors. |
App\Entity\Observacion | No errors. |
App\Entity\RegistroAcceso | No errors. |
App\Entity\Sucursal | No errors. |
App\Entity\Empleado | No errors. |
App\Entity\Familiar | No errors. |
App\Entity\Boleta | No errors. |
App\Entity\ContadorMensaje | No errors. |
App\Entity\EmpleadoEmpresaSucursal | No errors. |
App\Entity\Empresa | No errors. |
App\Entity\SolicitarEmpresa | No errors. |
App\Entity\Prestador | No errors. |
App\Entity\SubBeneficio | No errors. |
App\Entity\Beneficio | No errors. |
App\Entity\Proveedor | No errors. |
App\Entity\FacturaDeCompra | No errors. |
App\Entity\CompraStock | No errors. |
App\Entity\EmpleadoBeneficio | No errors. |
App\Entity\Concepto | No errors. |
App\Entity\MediosDePago | No errors. |
App\Entity\EscalaSalarial | No errors. |
App\Entity\MotivoLiquidacionEmpleado | No errors. |
App\Entity\AcuerdoDePago | No errors. |
App\Entity\PagosAcuerdo | No errors. |
App\Entity\InformarPago | No errors. |
App\Entity\ItemDenuncia | No errors. |
App\Entity\Denuncia | No errors. |
App\Entity\PagosBanco | No errors. |
App\Entity\CertificadoDeDeuda | No errors. |
App\Entity\EmpleadoRecibo | No errors. |
App\Entity\Cargo | No errors. |
App\Entity\EmpleadoBoleta | No errors. |
App\Entity\Zona | No errors. |
App\Entity\CertificadoTrabajadores | No errors. |
App\Entity\EstadoEmpresa | No errors. |
App\Entity\MedioConceptoEmpresa | No errors. |