Query Metrics
1
Database Queries
1
Different statements
272.05 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
272.05 ms (100.00%) |
1 |
SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.active AS active_2, m0_.exportdata AS exportdata_3, m0_.id AS id_4, m0_.title AS title_5, m0_.accesslevel AS accesslevel_6, m0_.targeturl AS targeturl_7, m0_.color AS color_8, m0_.internationaltitle AS internationaltitle_9, m0_.icon AS icon_10, m0_.published AS published_11, m0_.homesearch AS homesearch_12, m0_.menuicons AS menuicons_13, m0_.menutext AS menutext_14, m0_.views AS views_15, m0_.environments AS environments_16, m1_.created_at AS created_at_17, m1_.updated_at AS updated_at_18, m1_.active AS active_19, m1_.exportdata AS exportdata_20, m1_.id AS id_21, m1_.sequence AS sequence_22, t2_.created_at AS created_at_23, t2_.updated_at AS updated_at_24, t2_.active AS active_25, t2_.exportdata AS exportdata_26, t2_.id AS id_27, t2_.title AS title_28, t2_.background AS background_29, t2_.description AS description_30, t2_.template AS template_31, n3_.created_at AS created_at_32, n3_.updated_at AS updated_at_33, n3_.active AS active_34, n3_.exportdata AS exportdata_35, n3_.id AS id_36, n3_.is_mobile AS is_mobile_37, n3_.parent AS parent_38, n3_.nodekey AS nodekey_39, n3_.expanded AS expanded_40, n3_.published AS published_41, n3_.folder AS folder_42, n3_.selected AS selected_43, n3_.title AS title_44, n3_.tooltip AS tooltip_45, n3_.template AS template_46, n3_.nodedata AS nodedata_47, n3_.sequence AS sequence_48, m4_.id AS id_49, m4_.amount AS amount_50, m4_.referer AS referer_51 FROM menu m0_ INNER JOIN menutree m1_ ON m0_.id = m1_.menu_id AND (m1_.active = ?) INNER JOIN tree t2_ ON m1_.tree_id = t2_.id AND (t2_.active = ?) INNER JOIN node n3_ ON t2_.id = n3_.tree_id AND (n3_.active = ?) LEFT JOIN menu_amount m4_ ON m0_.id = m4_.menu_id WHERE n3_.nodekey = ? AND m0_.published = ? AND m0_.active = ? ORDER BY m0_.title ASC, m1_.sequence ASC, m1_.id ASC
Parameters:
[ 1 1 1 "root_1" 1 1 ] |
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\TimeStamped | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\Menutree | No errors. |
| App\Entity\Tree | No errors. |
| App\Entity\Node | No errors. |
| App\Entity\MenuRequestAmount | No errors. |