Query Metrics

7 Database Queries
5 Different statements
3.92 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.order AS order_3, t0.visible AS visible_4, t0.changeable AS changeable_5, t0.required AS required_6, t0.type AS type_7, t0.grouped AS grouped_8, t0.help AS help_9 FROM config t0
Parameters:
[]
2 0.48 ms
SELECT t0.id AS id_1, t0.roworder AS roworder_2, t0.label AS label_3, t0.path AS path_4, t0.fonticon AS fonticon_5, t0.permission AS permission_6, t0.appactivate AS appactivate_7, t0.parent_id AS parent_id_8 FROM sidebar t0 WHERE t0.parent_id IS NULL ORDER BY t0.roworder ASC
Parameters:
[]
3 0.50 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.roworder AS roworder_2, p0_.maxwidth AS maxwidth_3, p0_.fonticon AS fonticon_4, p0_.url AS url_5, p0_.toreload AS toreload_6, p0_.html AS html_7, p0_.template AS template_8, p0_.parentfor AS parentfor_9, p0_.roles AS roles_10, p0_.fgpreference AS fgpreference_11, p0_.pagecategory_id AS pagecategory_id_12, p0_.user_id AS user_id_13, p0_.page_id AS page_id_14 FROM page p0_ WHERE p0_.roles LIKE '%ROLE_ANONYME%' AND p0_.user_id IS NULL AND p0_.parentfor IS NULL
Parameters:
[]
4 0.68 ms
SELECT w0_.id AS id_0, w0_.roworder AS roworder_1, w0_.name AS name_2, w0_.description AS description_3, w0_.routeview AS routeview_4, w0_.height AS height_5, w0_.autoajust AS autoajust_6, w0_.border AS border_7, w0_.opened AS opened_8, w0_.colorheaderback AS colorheaderback_9, w0_.colorheaderfont AS colorheaderfont_10, w0_.colorbodyback AS colorbodyback_11, w0_.colorbodyfont AS colorbodyfont_12, w0_.access AS access_13, w0_.parameter AS parameter_14, w0_.icon_id AS icon_id_15 FROM widget w0_ WHERE w0_.access LIKE '%user%'
Parameters:
[]
5 0.66 ms
SELECT w0_.id AS id_0, w0_.roworder AS roworder_1, w0_.name AS name_2, w0_.description AS description_3, w0_.routeview AS routeview_4, w0_.height AS height_5, w0_.autoajust AS autoajust_6, w0_.border AS border_7, w0_.opened AS opened_8, w0_.colorheaderback AS colorheaderback_9, w0_.colorheaderfont AS colorheaderfont_10, w0_.colorbodyback AS colorbodyback_11, w0_.colorbodyfont AS colorbodyfont_12, w0_.access AS access_13, w0_.parameter AS parameter_14, w0_.icon_id AS icon_id_15 FROM widget w0_ WHERE w0_.access LIKE '%group%'
Parameters:
[]
6 0.52 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.order AS order_3, t0.visible AS visible_4, t0.changeable AS changeable_5, t0.required AS required_6, t0.type AS type_7, t0.grouped AS grouped_8, t0.help AS help_9 FROM config t0
Parameters:
[]
7 0.54 ms
SELECT t0.id AS id_1, t0.roworder AS roworder_2, t0.label AS label_3, t0.path AS path_4, t0.fonticon AS fonticon_5, t0.permission AS permission_6, t0.appactivate AS appactivate_7, t0.parent_id AS parent_id_8 FROM sidebar t0 WHERE t0.parent_id IS NULL ORDER BY t0.roworder ASC
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\Config No errors.
App\Entity\Sidebar No errors.
App\Entity\Page No errors.
App\Entity\Pagecategory No errors.
App\Entity\User No errors.
App\Entity\Group No errors.
App\Entity\Pagewidget No errors.
App\Entity\Widget No errors.
App\Entity\Icon No errors.