Query Metrics
321
Database Queries
12
Different statements
339.17 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
80.06 ms (23.61%) |
2 |
SELECT t0.id AS id_1, t0.identificacion AS identificacion_2, t0.nombres AS nombres_3, t0.apellido_paterno AS apellido_paterno_4, t0.apellido_materno AS apellido_materno_5, t0.telefono AS telefono_6, t0.telefono_emergencias AS telefono_emergencias_7, t0.email AS email_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_nacimiento AS fecha_nacimiento_10, t0.sexo AS sexo_11, t0.estado_civil AS estado_civil_12, t0.estatura AS estatura_13, t0.edad AS edad_14, t0.lugar_string AS lugar_string_15, t0.edad_string AS edad_string_16, t0.pais_nacimiento AS pais_nacimiento_17, t0.foto_cedula AS foto_cedula_18, t0.localizacion_nacimiento AS localizacion_nacimiento_19, t0.foto AS foto_20, t0.certif_covid AS certif_covid_21 FROM recluta t0 WHERE t0.identificacion = ? LIMIT 1
Parameters:
[
"0706835659"
]
|
68.51 ms (20.20%) |
102 |
SELECT NEXTVAL('test_recluta_proceso_pregunta_id_seq')
Parameters:
[] |
61.39 ms (18.10%) |
2 |
"COMMIT"
Parameters:
[] |
59.35 ms (17.50%) |
102 |
SELECT t0.id AS id_1, t0.respuesta AS respuesta_2, t0.recluta_proceso AS recluta_proceso_3, t0.pregunta AS pregunta_4 FROM test_recluta_proceso_pregunta t0 WHERE t0.recluta_proceso = ? AND t0.pregunta = ? LIMIT 1
Parameters:
[ 230161 343 ] |
54.87 ms (16.18%) |
102 |
INSERT INTO test_recluta_proceso_pregunta (id, respuesta, recluta_proceso, pregunta) VALUES (?, ?, ?, ?)
Parameters:
[ 4531974 "2" 230161 343 ] |
5.09 ms (1.50%) |
2 |
SELECT t0.id AS id_1, t0.fecha_registro AS fecha_registro_2, t0.pais_residencia AS pais_residencia_3, t0.calle_principal_residencia AS calle_principal_residencia_4, t0.calle_secundaria_residencia AS calle_secundaria_residencia_5, t0.num_casa AS num_casa_6, t0.referencias AS referencias_7, t0.geometria AS geometria_8, t0.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_9, t0.resultados_antecedentes AS resultados_antecedentes_10, t0.fecha_consulta_estudios AS fecha_consulta_estudios_11, t0.resultados_estudios AS resultados_estudios_12, t0.idoneo AS idoneo_13, t0.fecha_resultado AS fecha_resultado_14, t0.fecha_asignacion AS fecha_asignacion_15, t0.causa_rechazo AS causa_rechazo_16, t0.observaciones AS observaciones_17, t0.volver_presentarse AS volver_presentarse_18, t0.intentos AS intentos_19, t0.fecha_intento1 AS fecha_intento1_20, t0.fecha_intento2 AS fecha_intento2_21, t0.fecha_intento3 AS fecha_intento3_22, t0.turno AS turno_23, t0.fecha_baja AS fecha_baja_24, t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_25, t0.talla_uniforme AS talla_uniforme_26, t0.talla_jockey AS talla_jockey_27, t0.talla_calzado AS talla_calzado_28, t0.talla_camiseta AS talla_camiseta_29, t0.estudio AS estudio_30, t0.proceso AS proceso_31, t0.base_movilizacion AS base_movilizacion_32, t0.centro_movilizacion AS centro_movilizacion_33, t0.unidad_militar AS unidad_militar_34, t0.recluta AS recluta_35, t0.localizacion_residencia AS localizacion_residencia_36, t0.unidad_militar_inicial AS unidad_militar_inicial_37 FROM recluta_proceso t0 WHERE t0.recluta = ? AND t0.proceso = ? LIMIT 1
Parameters:
[ 189846 47 ] |
3.29 ms (0.97%) |
2 |
SELECT p0_.id AS id_0, p0_.anno AS anno_1, p0_.llamada AS llamada_2, p0_.fecha_inicio_registro AS fecha_inicio_registro_3, p0_.fecha_fin_registro AS fecha_fin_registro_4, p0_.fecha_acuartelamiento AS fecha_acuartelamiento_5, p0_.fecha_fin_dias AS fecha_fin_dias_6, p0_.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_7, p0_.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_8, p0_.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_9, p0_.minutos_test AS minutos_test_10, p0_.bajas_permitidas AS bajas_permitidas_11, p0_.activo AS activo_12, p0_.cant_cursos AS cant_cursos_13, p0_.titulo_reporte_uniforme AS titulo_reporte_uniforme_14, p0_.titulo_reporte_jockey AS titulo_reporte_jockey_15, p0_.titulo_reporte_calzado AS titulo_reporte_calzado_16, p0_.titulo_reporte_camiseta AS titulo_reporte_camiseta_17, p0_.titulo_reporte_estudios AS titulo_reporte_estudios_18, p0_.foto_uniforme AS foto_uniforme_19, p0_.foto_jockey AS foto_jockey_20, p0_.foto_calzado AS foto_calzado_21, p0_.foto_camiseta AS foto_camiseta_22 FROM proceso_reclutamiento p0_ WHERE p0_.activo = true
Parameters:
[] |
2.63 ms (0.78%) |
2 |
SELECT t0.id AS id_1, t0.nombre_lugar AS nombre_lugar_2, t0.jefe_cedula AS jefe_cedula_3, t0.jefe_nombres AS jefe_nombres_4, t0.jefe_apellidos AS jefe_apellidos_5, t0.jefe_cargo AS jefe_cargo_6, t0.jefe_grado AS jefe_grado_7, t0.turno AS turno_8, t0.cupo_masculino AS cupo_masculino_9, t0.cupo_femenino AS cupo_femenino_10, t0.registrado_masculino AS registrado_masculino_11, t0.registrado_femenino AS registrado_femenino_12, t0.organico_masculino AS organico_masculino_13, t0.organico_femenino AS organico_femenino_14, t0.proceso AS proceso_15, t0.lugar AS lugar_16, t0.base AS base_17, t0.psicologo AS psicologo_18, t0.medico AS medico_19, t0.odontologo AS odontologo_20, t0.laboratorista AS laboratorista_21 FROM proceso_reclutamiento_lugar_base t0 WHERE t0.lugar = ? AND t0.proceso = ? LIMIT 1
Parameters:
[ 22 47 ] |
1.69 ms (0.50%) |
1 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.tipo AS tipo_2, t0_.criterio AS criterio_3 FROM test_preguntas t0_ WHERE t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 343 309 348 399 329 327 400 333 308 338 371 377 328 341 395 349 323 354 367 319 337 312 366 375 392 368 344 390 332 396 378 331 320 364 316 403 314 360 330 307 386 404 318 317 394 365 408 350 380 347 326 352 381 355 356 357 388 387 322 402 313 376 405 325 321 398 358 363 335 379 310 397 384 372 324 369 334 385 351 359 345 406 401 407 391 346 382 361 353 362 339 315 342 374 370 373 393 340 336 383 389 311 ] |
0.80 ms (0.24%) |
1 |
UPDATE proceso_reclutamiento_lugar_base SET turno = ?, registrado_masculino = ? WHERE id = ?
Parameters:
[ 441 472 298 ] |
0.78 ms (0.23%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.72 ms (0.21%) |
1 |
UPDATE recluta_proceso SET idoneo = ?, intentos = ?, fecha_intento1 = ?, turno = ? WHERE id = ?
Parameters:
[ 1 1 "2024-09-20 08:45:26" 441 230161 ] |
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\Recluta | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\Adjunto | No errors. |
App\Entity\ReclutaProceso | No errors. |
App\Entity\ProcesoReclutamiento | No errors. |
App\Entity\Curso | No errors. |
App\Entity\BaseMovilizacion | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\UnidadMilitar | No errors. |
App\Entity\ProcesoReclutamientoCentro | No errors. |
App\Entity\SeguridadUsuario | No errors. |
App\Entity\NmclCargo | No errors. |
App\Entity\NmclGrado | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\NmclLocalizacion | No errors. |
App\Entity\TestPregunta | No errors. |
App\Entity\TestCriterio | No errors. |
App\Entity\TestReclutaProcesoPregunta | No errors. |
App\Entity\TestEje | No errors. |
App\Entity\TestSistema | No errors. |