Query Metrics
8
Database Queries
7
Different statements
21.95 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.28 ms (37.74%) |
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"
]
|
4.39 ms (20.02%) |
1 |
SELECT n0_.id AS id_0, n0_.valor AS valor_1, n0_.nivel_localizacion AS nivel_localizacion_2, n0_.padre AS padre_3 FROM nmcl_dominio_localizacion n0_
Parameters:
[] |
4.20 ms (19.12%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.fuerza AS fuerza_2, c0_.direccion AS direccion_3, c0_.geometria AS geometria_4, c0_.localizacion AS localizacion_5 FROM centro_instruccion c0_ ORDER BY c0_.nombre ASC, c0_.fuerza ASC, c0_.localizacion ASC, c0_.direccion ASC, c0_.geometria ASC
Parameters:
[] |
1.85 ms (8.44%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.direccion AS direccion_2, c0_.geometria AS geometria_3, c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4, c0_.activo AS activo_5, c0_.localizacion AS localizacion_6, c0_.jefe AS jefe_7 FROM centro_movilizacion c0_
Parameters:
[] |
1.44 ms (6.56%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
1.35 ms (6.13%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
0.44 ms (1.98%) |
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\CentroInstruccion | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\SeguridadUsuario | No errors. |
App\Entity\NmclLocalizacion | No errors. |
App\Entity\SeguridadRol | No errors. |
App\Entity\Notificacion | No errors. |
App\Entity\NmclCargo | No errors. |
App\Entity\NmclGrado | No errors. |
App\Entity\Adjunto | No errors. |
App\Entity\BaseMovilizacion | No errors. |
App\Entity\UnidadMilitar | No errors. |