GET https://dev.fcsprint2.nl/api/tree/menutree?menuid=64&p=api%2Ftree%2Fmenutree

Query Metrics

2 Database Queries
2 Different statements
1.76 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.