Query Metrics
249
Database Queries
6
Different statements
63.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
61.07 ms (95.55%) |
241 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM pais_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
1.09 ms (1.70%) |
4 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM tipo_documento_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
|
0.57 ms (0.89%) |
1 |
SELECT p0_.id AS id_0, p0_.isonum AS isonum_1, p0_.iso2 AS iso2_2, p0_.iso3 AS iso3_3 FROM pais p0_
Parameters:
[] |
|
0.51 ms (0.80%) |
1 |
SELECT m0_.id AS id_0, m0_.path AS path_1, m0_.lvl AS lvl_2, m0_.position AS position_3, m0_.tipo AS tipo_4, m0_.target AS target_5, m0_.contenido AS contenido_6, m0_.activo AS activo_7, m1_.titulo AS titulo_8, m1_.url AS url_9, m1_.id AS id_10, m1_.locale AS locale_11, i2_.name AS name_12, i2_.description AS description_13, i2_.enabled AS enabled_14, i2_.provider_name AS provider_name_15, i2_.provider_status AS provider_status_16, i2_.provider_reference AS provider_reference_17, i2_.provider_metadata AS provider_metadata_18, i2_.width AS width_19, i2_.height AS height_20, i2_.length AS length_21, i2_.content_type AS content_type_22, i2_.content_size AS content_size_23, i2_.copyright AS copyright_24, i2_.author_name AS author_name_25, i2_.context AS context_26, i2_.cdn_is_flushable AS cdn_is_flushable_27, i2_.cdn_flush_identifier AS cdn_flush_identifier_28, i2_.cdn_flush_at AS cdn_flush_at_29, i2_.cdn_status AS cdn_status_30, i2_.updated_at AS updated_at_31, i2_.created_at AS created_at_32, i2_.id AS id_33 FROM menu_item m0_ INNER JOIN menu_item_translation m1_ ON m0_.id = m1_.translatable_id LEFT JOIN imagen i2_ ON m0_.imagen_id = i2_.id WHERE m0_.menu_id = '1' ORDER BY m0_.path ASC
Parameters:
[] |
|
0.44 ms (0.68%) |
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.activo AS activo_2, m0_.zona AS zona_3 FROM menu m0_ WHERE m0_.activo = ? AND m0_.zona = ?
Parameters:
[ 1 "principal" ] |
|
0.24 ms (0.38%) |
1 |
SELECT t0_.id AS id_0, t0_.codigo AS codigo_1 FROM tipo_documento t0_
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\Pais | No errors. |
| App\Entity\TipoDocumento | No errors. |
| App\Entity\PaisTranslation | No errors. |
| App\Entity\TipoDocumentoTranslation | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuItem | No errors. |
| App\Entity\MenuItemTranslation | No errors. |
| Sonata\MediaBundle\Entity\BaseMedia | No errors. |
| App\Entity\Imagen | No errors. |