Query Metrics
321
Database Queries
12
Different statements
281.26 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
74.38 ms (26.44%) |
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:
[
"0956922959"
]
|
61.63 ms (21.91%) |
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:
[ 230187 363 ] |
51.73 ms (18.39%) |
102 |
INSERT INTO test_recluta_proceso_pregunta (id, respuesta, recluta_proceso, pregunta) VALUES (?, ?, ?, ?)
Parameters:
[ 4532382 "1" 230187 363 ] |
47.69 ms (16.95%) |
102 |
SELECT NEXTVAL('test_recluta_proceso_pregunta_id_seq')
Parameters:
[] |
31.53 ms (11.21%) |
2 |
"COMMIT"
Parameters:
[] |
3.33 ms (1.19%) |
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:
[ 189862 47 ] |
3.07 ms (1.09%) |
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 ] |
2.85 ms (1.01%) |
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.42 ms (0.86%) |
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:
[ 363 373 372 330 408 341 349 375 343 322 340 348 400 398 317 374 313 395 376 399 359 329 310 336 352 331 360 371 367 385 325 364 316 318 350 397 403 366 394 381 314 345 346 379 324 387 327 383 390 382 308 396 370 401 405 337 380 321 334 358 404 339 347 311 323 389 354 326 328 402 351 391 369 353 335 365 320 377 355 386 388 393 319 333 362 315 361 407 309 406 344 384 357 378 342 312 307 338 368 392 332 356 ] |
0.91 ms (0.32%) |
1 |
UPDATE proceso_reclutamiento_lugar_base SET turno = ?, registrado_masculino = ? WHERE id = ?
Parameters:
[ 442 473 298 ] |
0.89 ms (0.32%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.84 ms (0.30%) |
1 |
UPDATE recluta_proceso SET idoneo = ?, intentos = ?, fecha_intento1 = ?, turno = ? WHERE id = ?
Parameters:
[ 1 1 "2024-09-20 10:35:21" 442 230187 ] |
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. |