Query Metrics
2
Database Queries
2
Different statements
1.76 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.47 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.accesslevel AS accesslevel_3, t0.targeturl AS targeturl_4, t0.color AS color_5, t0.internationaltitle AS internationaltitle_6, t0.icon AS icon_7, t0.published AS published_8, t0.homesearch AS homesearch_9, t0.menuicons AS menuicons_10, t0.menutext AS menutext_11, t0.views AS views_12, t0.environments AS environments_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.active AS active_16, t0.exportdata AS exportdata_17, t0.domain_id AS domain_id_18, t0.user_id AS user_id_19 FROM menu t0 WHERE t0.id = ?
Parameters:
[
"64"
]
|
2 | 1.29 ms |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.accesslevel AS accesslevel_2, m0_.targeturl AS targeturl_3, m0_.color AS color_4, m0_.internationaltitle AS internationaltitle_5, m0_.icon AS icon_6, m0_.published AS published_7, m0_.homesearch AS homesearch_8, m0_.menuicons AS menuicons_9, m0_.menutext AS menutext_10, m0_.views AS views_11, m0_.environments AS environments_12, m0_.created_at AS created_at_13, m0_.updated_at AS updated_at_14, m0_.active AS active_15, m0_.exportdata AS exportdata_16, m1_.id AS id_17, m1_.sequence AS sequence_18, m1_.created_at AS created_at_19, m1_.updated_at AS updated_at_20, m1_.active AS active_21, m1_.exportdata AS exportdata_22, t2_.id AS id_23, t2_.title AS title_24, t2_.background AS background_25, t2_.description AS description_26, t2_.template AS template_27, t2_.created_at AS created_at_28, t2_.updated_at AS updated_at_29, t2_.active AS active_30, t2_.exportdata AS exportdata_31, n3_.id AS id_32, n3_.is_mobile AS is_mobile_33, n3_.parent AS parent_34, n3_.nodekey AS nodekey_35, n3_.expanded AS expanded_36, n3_.published AS published_37, n3_.folder AS folder_38, n3_.selected AS selected_39, n3_.title AS title_40, n3_.tooltip AS tooltip_41, n3_.template AS template_42, n3_.nodedata AS nodedata_43, n3_.sequence AS sequence_44, n3_.created_at AS created_at_45, n3_.updated_at AS updated_at_46, n3_.active AS active_47, n3_.exportdata AS exportdata_48 FROM menu m0_ LEFT JOIN menutree m1_ ON m0_.id = m1_.menu_id LEFT JOIN tree t2_ ON m1_.tree_id = t2_.id AND (m1_.active = ?) LEFT JOIN node n3_ ON t2_.id = n3_.tree_id AND (n3_.active = ?) WHERE m1_.menu_id = ? AND n3_.nodekey = ? ORDER BY m1_.sequence ASC, m1_.id ASC
Parameters:
[ 1 1 "64" "root_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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\TimeStamped | No errors. |
App\Entity\Menu | No errors. |
App\Entity\Domain | No errors. |
App\Entity\User | No errors. |
App\Entity\Menutree | No errors. |
App\Entity\ClassRoom\ClassRoom | No errors. |
App\Entity\UserMenus | No errors. |
App\Entity\MenuRequestAmount | No errors. |
App\Entity\Tree | No errors. |
App\Entity\Node | No errors. |