Query Metrics

7 Database Queries
6 Different statements
14.95 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 3.77 ms
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.id = ?
Parameters:
[
  "4693"
]
2 1.09 ms
SELECT t0.id AS id_1, t0.archivo AS archivo_2, t0.ruta AS ruta_3, t0.archivo_hash AS archivo_hash_4, t0.size AS size_5, t0.contenido AS contenido_6 FROM adjunto t0 WHERE t0.id = ?
Parameters:
[
  80749
]
3 0.66 ms
SELECT CURRENT_DATABASE()
Parameters:
[]
4 7.13 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"
]
5 1.31 ms
SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'
Parameters:
[]
6 0.47 ms
SHOW search_path
Parameters:
[]
7 0.51 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\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\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\NmclNivelLocalizacion No errors.