GET https://dev.fcsprint2.nl/api/get/menu/getall?p=api%2Fget%2Fmenu%2Fgetall

Query Metrics

1 Database Queries
1 Different statements
272.05 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

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.