Query Metrics
321
Database Queries
12
Different statements
279.76 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
73.44 ms (26.25%) |
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:
[
"0950666628"
]
|
55.98 ms (20.01%) |
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:
[ 230099 382 ] |
55.79 ms (19.94%) |
102 |
INSERT INTO test_recluta_proceso_pregunta (id, respuesta, recluta_proceso, pregunta) VALUES (?, ?, ?, ?)
Parameters:
[ 4530240 "3" 230099 382 ] |
43.33 ms (15.49%) |
102 |
SELECT NEXTVAL('test_recluta_proceso_pregunta_id_seq')
Parameters:
[] |
36.12 ms (12.91%) |
2 |
"COMMIT"
Parameters:
[] |
3.74 ms (1.34%) |
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:
[ 189806 47 ] |
3.20 ms (1.14%) |
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.91 ms (1.04%) |
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.29 ms (0.82%) |
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:
[ 382 375 356 361 374 312 315 316 322 368 354 330 355 314 391 323 378 340 386 394 377 313 373 358 329 371 399 311 308 381 348 337 317 405 352 364 343 359 333 325 376 350 326 408 390 396 401 384 365 353 341 380 397 367 342 369 395 392 379 346 347 324 328 389 370 393 309 403 366 345 321 318 334 385 407 372 319 349 344 360 363 351 320 398 383 362 404 336 387 335 338 327 339 406 400 332 307 331 388 310 357 402 ] |
1.22 ms (0.44%) |
1 |
UPDATE proceso_reclutamiento_lugar_base SET turno = ?, registrado_masculino = ? WHERE id = ?
Parameters:
[ 432 467 298 ] |
0.88 ms (0.32%) |
1 |
UPDATE recluta_proceso SET idoneo = ?, intentos = ?, fecha_intento1 = ?, turno = ? WHERE id = ?
Parameters:
[ 1 1 "2024-09-19 22:54:15" 432 230099 ] |
0.86 ms (0.31%) |
2 |
"START TRANSACTION"
Parameters:
[] |
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. |