Query Metrics
7
Database Queries
6
Different statements
4.26 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 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:
[] |
2 | 0.59 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.96 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.password AS password_5, t0.salt AS salt_6, t0.passwordad AS passwordad_7, t0.email AS email_8, t0.visible AS visible_9, t0.avatar AS avatar_10, t0.role AS role_11, t0.authlevel AS authlevel_12, t0.siren AS siren_13, t0.siret AS siret_14, t0.labelniveau01 AS labelniveau01_15, t0.labelniveau02 AS labelniveau02_16, t0.usualname AS usualname_17, t0.telephonenumber AS telephonenumber_18, t0.postaladress AS postaladress_19, t0.givensname AS givensname_20, t0.birthdate AS birthdate_21, t0.gender AS gender_22, t0.job AS job_23, t0.position AS position_24, t0.apikey AS apikey_25, t0.keyexpire AS keyexpire_26, t0.keyvalue AS keyvalue_27, t0.belongingpopulation AS belongingpopulation_28, t0.viewcalendar AS viewcalendar_29, t0.visitedate AS visitedate_30, t0.visitecpt AS visitecpt_31, t0.niveau01other AS niveau01other_32, t0.motivation AS motivation_33, t0.note AS note_34, t0.preference AS preference_35, t0.permmodoprofil_id AS permmodoprofil_id_36, t0.birthcountry_id AS birthcountry_id_37, t0.birthplace_id AS birthplace_id_38, t0.niveau01_id AS niveau01_id_39, t0.niveau02_id AS niveau02_id_40 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"nononononouser"
]
|
4 | 0.80 ms |
SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.subtitle AS subtitle_2, i0_.slug AS slug_3, i0_.url AS url_4, i0_.target AS target_5, i0_.content AS content_6, i0_.rowOrder AS rowOrder_7, i0_.essential AS essential_8, i0_.protected AS protected_9, i0_.color AS color_10, i0_.badgeurl AS badgeurl_11, i0_.roles AS roles_12, i0_.ssoitem AS ssoitem_13, i0_.clicksonde AS clicksonde_14, i0_.clicksondeservice AS clicksondeservice_15, i0_.icon_id AS icon_id_16, i0_.category AS category_17 FROM item i0_ WHERE i0_.roles LIKE '%ROLE_ANONYME%'
Parameters:
[] |
5 | 0.42 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.color AS color_3, t0.rowOrder AS rowOrder_4, t0.icon_id AS icon_id_5 FROM itemcategory t0 ORDER BY t0.rowOrder ASC
Parameters:
[] |
6 | 0.34 ms |
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:
[
235
]
|
7 | 0.63 ms |
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:
[
189
]
|
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\User | 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\Item | No errors. |
App\Entity\Icon | No errors. |
App\Entity\Itemcategory | No errors. |
App\Entity\Bookmark | No errors. |
App\Entity\Group | No errors. |
App\Entity\Alert | No errors. |
App\Entity\Alertcategory | No errors. |
App\Entity\Pagewidget | No errors. |
App\Entity\Widget | No errors. |