Query Metrics
8
Database Queries
8
Different statements
41.90 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
19.90 ms (47.50%) |
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.instruccion AS instruccion_19, t0.localizacion_nacimiento AS localizacion_nacimiento_20, t0.foto AS foto_21, t0.certif_covid AS certif_covid_22, t0.grado AS grado_23, t0.fuerza AS fuerza_24, t0.arma AS arma_25 FROM reservistas t0 WHERE t0.identificacion = ? LIMIT 1
Parameters:
[
"1725412751"
]
|
11.70 ms (27.91%) |
1 |
"COMMIT"
Parameters:
[] |
2.69 ms (6.42%) |
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.causa_rechazo AS causa_rechazo_15, t0.observaciones AS observaciones_16, t0.volver_presentarse AS volver_presentarse_17, t0.fecha_baja AS fecha_baja_18, t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_19, t0.disponibilidad AS disponibilidad_20, t0.actividad AS actividad_21, t0.error_registro AS error_registro_22, t0.proceso AS proceso_23, t0.reservista AS reservista_24, t0.localizacion_residencia AS localizacion_residencia_25, t0.centro_movilizacion AS centro_movilizacion_26 FROM reservista_proceso t0 WHERE t0.reservista = ? AND t0.proceso = ? LIMIT 1
Parameters:
[ 43391 9 ] |
2.36 ms (5.64%) |
1 |
UPDATE reservista_proceso SET pais_residencia = ?, calle_principal_residencia = ?, calle_secundaria_residencia = ?, num_casa = ?, referencias = ?, geometria = ?, localizacion_residencia = ?, centro_movilizacion = ? WHERE id = ?
Parameters:
[ "Ecuador" "amalia uriguen" "pedro cabezas " "lote 8" "colegio municipal calderon" "" 1394 120 56611 ] |
1.72 ms (4.11%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.geometria AS geometria_4, t0.direccion_acuartelamiento AS direccion_acuartelamiento_5, t0.activo AS activo_6, t0.localizacion AS localizacion_7, t0.jefe AS jefe_8 FROM centro_movilizacion t0 WHERE t0.id = ?
Parameters:
[
"120"
]
|
1.69 ms (4.04%) |
1 |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.nivel_localizacion AS nivel_localizacion_3, t0.padre AS padre_4 FROM nmcl_dominio_localizacion t0 WHERE t0.id = ?
Parameters:
[
"1394"
]
|
0.98 ms (2.34%) |
1 |
SELECT p0_.id AS id_0, p0_.fecha_inicio_registro AS fecha_inicio_registro_1, p0_.fecha_fin_registro AS fecha_fin_registro_2, p0_.anno_desde AS anno_desde_3, p0_.anno_hasta AS anno_hasta_4, p0_.activo AS activo_5 FROM proceso_registro_reservistas p0_ WHERE p0_.activo = true
Parameters:
[] |
0.86 ms (2.04%) |
1 |
"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\Reservista |
|
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\Adjunto | No errors. |
App\Entity\NmclGrado | No errors. |
App\Entity\NmclFuerza | No errors. |
App\Entity\NmclArma | No errors. |
App\Entity\ProcesoRegistroReservistas | No errors. |
App\Entity\ReservistaProceso | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\SeguridadUsuario | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\NmclCargo | No errors. |
App\Entity\BaseMovilizacion | No errors. |
App\Entity\UnidadMilitar | No errors. |
App\Entity\NmclLocalizacion | No errors. |