Query Metrics
11
Database Queries
10
Different statements
22.79 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.09 ms (26.74%) |
1 |
SELECT t0_.id AS id_0, t0_.respuesta AS respuesta_1, t1_.id AS id_2, t1_.nombre AS nombre_3, t1_.tipo AS tipo_4, t2_.id AS id_5, t2_.nombre AS nombre_6, t2_.riesgo_bajo_desde AS riesgo_bajo_desde_7, t2_.riesgo_bajo_hasta AS riesgo_bajo_hasta_8, t2_.riesgo_medio_desde AS riesgo_medio_desde_9, t2_.riesgo_medio_hasta AS riesgo_medio_hasta_10, t2_.riesgo_alto_desde AS riesgo_alto_desde_11, t2_.riesgo_alto_hasta AS riesgo_alto_hasta_12, t3_.id AS id_13, t3_.nombre AS nombre_14, t4_.id AS id_15, t4_.nombre AS nombre_16, t0_.recluta_proceso AS recluta_proceso_17, t0_.pregunta AS pregunta_18, t1_.criterio AS criterio_19, t2_.eje AS eje_20, t3_.sistema AS sistema_21, t4_.proceso AS proceso_22 FROM test_recluta_proceso_pregunta t0_ INNER JOIN recluta_proceso r5_ ON t0_.recluta_proceso = r5_.id INNER JOIN test_preguntas t1_ ON t0_.pregunta = t1_.id INNER JOIN test_criterios t2_ ON t1_.criterio = t2_.id INNER JOIN test_ejes t3_ ON t2_.eje = t3_.id INNER JOIN test_sistemas t4_ ON t3_.sistema = t4_.id WHERE r5_.id = ?
Parameters:
[
"220721"
]
|
3.96 ms (17.38%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.telefono AS telefono_5, t0.celular AS celular_6, t0.email AS email_7, t0.direccion AS direccion_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_vigencia_password AS fecha_vigencia_password_10, t0.causa_bloqueo AS causa_bloqueo_11, t0.password AS password_12, t0.eliminado AS eliminado_13, t0.fecha_eliminacion AS fecha_eliminacion_14, t0.intentos_fallidos AS intentos_fallidos_15, t0.primer_ingreso AS primer_ingreso_16, t0.activo AS activo_17, t0.conectado AS conectado_18, t0.fecha_acceso AS fecha_acceso_19, t0.cargo AS cargo_20, t0.grado AS grado_21, t0.foto AS foto_22, t0.base AS base_23, t0.centro AS centro_24, t0.unidad AS unidad_25, t0.centro_instruccion AS centro_instruccion_26 FROM seg_usuario t0 WHERE t0.id = ?
Parameters:
[
5050
]
|
3.42 ms (15.00%) |
1 |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_catalog = ? AND table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type = 'BASE TABLE'
Parameters:
[
"integral_produccion"
]
|
2.18 ms (9.55%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.sistema AS sistema_3, t0.descripcion AS descripcion_4, t0.asignable AS asignable_5 FROM seg_rol t0 INNER JOIN seg_usuario_rol ON t0.id = seg_usuario_rol.rol WHERE seg_usuario_rol.usuario = ?
Parameters:
[
5050
]
|
2.16 ms (9.46%) |
1 |
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.id = ?
Parameters:
[
141578
]
|
1.81 ms (7.96%) |
1 |
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.id = ?
Parameters:
[
"220721"
]
|
1.30 ms (5.69%) |
1 |
SELECT n0_.id AS id_0, n0_.fecha_ingreso AS fecha_ingreso_1, n0_.asunto AS asunto_2, n0_.leida AS leida_3, n0_.fecha_leida AS fecha_leida_4, n0_.texto AS texto_5, n0_.accion AS accion_6, n0_.usuario AS usuario_7 FROM notificacion n0_ INNER JOIN seg_usuario s1_ ON n0_.usuario = s1_.id WHERE n0_.leida = false AND s1_.id = 5050 ORDER BY n0_.asunto ASC, n0_.fecha_ingreso DESC
Parameters:
[] |
0.86 ms (3.78%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
0.77 ms (3.37%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
0.25 ms (1.09%) |
1 |
SHOW search_path
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\SeguridadUsuario | No errors. |
App\Entity\NmclCargo | No errors. |
App\Entity\NmclGrado | No errors. |
App\Entity\Adjunto | No errors. |
App\Entity\BaseMovilizacion | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\UnidadMilitar | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\SeguridadRol | No errors. |
App\Entity\Notificacion | No errors. |
App\Entity\ReclutaProceso | No errors. |
App\Entity\ProcesoReclutamiento | No errors. |
App\Entity\Recluta | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\Curso | No errors. |
App\Entity\TestReclutaProcesoPregunta | No errors. |
App\Entity\TestPregunta | No errors. |
App\Entity\TestCriterio | No errors. |
App\Entity\TestEje | No errors. |
App\Entity\TestSistema | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\NmclLocalizacion | No errors. |