Query Metrics
4
Database Queries
4
Different statements
299.10 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 296.11 ms |
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nombre AS nombre_2, c0_.enabled AS enabled_3, c0_.disabletranslation AS disabletranslation_4, c0_.descripcion_corta AS descripcion_corta_5, c0_.descripcion_larga AS descripcion_larga_6, c0_.destacada AS destacada_7, c0_.localizacion AS localizacion_8, c0_.position AS position_9, ST_AsEWKT(c0_.point) AS point_10, c0_.deleted_at AS deleted_at_11 FROM ciudad c0_ WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 1.14 ms |
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.enabled AS enabled_2, c0_.asunto AS asunto_3, c0_.disabletranslation AS disabletranslation_4, c0_.fecha_inicio AS fecha_inicio_5, c0_.destacada AS destacada_6, c0_.fecha_fin AS fecha_fin_7, c0_.cuerpo AS cuerpo_8, c0_.direccion AS direccion_9, c0_.telefono AS telefono_10, c0_.web AS web_11, c0_.localizacion AS localizacion_12, c0_.ciudad_id AS ciudad_id_13, c0_.tipo AS tipo_14 FROM calendario c0_ WHERE c0_.fecha_inicio > CURRENT_TIMESTAMP
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 0.82 ms |
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.enabled AS enabled_2, t0_.disabletranslation AS disabletranslation_3, t0_.nombre AS nombre_4, t0_.descripcion AS descripcion_5, t0_.ruta_archivo AS ruta_archivo_6, t0_.position AS position_7 FROM tipo_poi t0_ ORDER BY t0_.id ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 1.04 ms |
SELECT f0_.id AS id_0, f0_.nombre AS nombre_1, f0_.enabled AS enabled_2, f0_.disabletranslation AS disabletranslation_3, f0_.url AS url_4, f0_.nolocal AS nolocal_5, f0_.auth AS auth_6, f0_.position AS position_7, f0_.deleted_at AS deleted_at_8, f0_.parent_id AS parent_id_9 FROM front_menu f0_ WHERE f0_.parent_id IS NULL AND f0_.enabled = true ORDER BY f0_.position ASC
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Ciudad | No errors. |
| App\Entity\Calendario | No errors. |
| App\Entity\CalendarioTipos | No errors. |
| App\Entity\TipoPoi | No errors. |
| App\Entity\Frontmenu | No errors. |