Query Metrics

6 Database Queries
5 Different statements
25.94 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 13.84 ms
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.id = ?
Parameters:
[
  "157936"
]
2 1.13 ms
SELECT CURRENT_DATABASE()
Parameters:
[]
3 8.98 ms
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"
]
4 1.04 ms
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters:
[]
5 0.48 ms
SHOW search_path
Parameters:
[]
6 0.47 ms
SELECT CURRENT_DATABASE()
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\ReservistaProceso No errors.
App\Entity\ProcesoRegistroReservistas No errors.
App\Entity\Reservista
  • The association App\Entity\Reservista#procesos refers to the owning side field App\Entity\ProcesoRegistroReservistas#reservista which does not exist.
App\Entity\NmclDominioLocalizacion No errors.
App\Entity\CentroMovilizacion No errors.
App\Entity\Adjunto No errors.
App\Entity\NmclGrado No errors.
App\Entity\NmclFuerza No errors.
App\Entity\NmclArma No errors.
App\Entity\NmclNivelLocalizacion No errors.
App\Entity\SeguridadUsuario No errors.
App\Entity\CentroInstruccion No errors.
App\Entity\NmclLocalizacion No errors.
App\Entity\SeguridadRol No errors.
App\Entity\Notificacion No errors.
App\Entity\NmclCargo No errors.
App\Entity\BaseMovilizacion No errors.
App\Entity\UnidadMilitar No errors.