http://terium.org/ninegate/

Query Metrics

29 Database Queries
6 Different statements
11.29 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.37 ms
(56.38%)
20
SELECT t0.id AS id_1, t0.label AS label_2, t0.tags AS tags_3, t0.user_id AS user_id_4 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  119
]
1.59 ms
(14.04%)
3
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:
[]
1.50 ms
(13.29%)
3
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:
[]
0.68 ms
(6.02%)
1
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:
[]
0.66 ms
(5.83%)
1
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:
[]
0.50 ms
(4.44%)
1
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:
[]

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.
App\Entity\PermModoProfil No errors.
App\Entity\Country No errors.
App\Entity\City No errors.
App\Entity\Niveau01 No errors.
App\Entity\Niveau02 No errors.
App\Entity\UserGroup No errors.
App\Entity\UserModo No errors.
App\Entity\Bookmark No errors.
App\Entity\Calendar No errors.
App\Entity\Notice No errors.
App\Entity\Blog No errors.
App\Entity\Blogarticle No errors.
App\Entity\Blogcomment No errors.
App\Entity\Project No errors.
App\Entity\Projecttask No errors.
App\Entity\Projectcomment No errors.
App\Entity\Message No errors.
App\Entity\Alert No errors.
App\Entity\Item No errors.
App\Entity\Flux No errors.
App\Entity\Calendarevent No errors.
App\Entity\Statistic No errors.
App\Entity\Slide No errors.
App\Entity\Itemcategory No errors.
App\Entity\Alertcategory No errors.
App\Entity\PermModo No errors.
App\Entity\Registration No errors.
App\Entity\Projecttasktag No errors.
App\Entity\Projecttaskstatus No errors.