Query Metrics
3
Database Queries
3
Different statements
2.83 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.32 ms (46.44%) |
1 |
SELECT p0_.id AS id_0, p0_.bundle AS bundle_1, p0_.name AS name_2, p0_.bitwise AS bitwise_3, p0_.uuid AS uuid_4 FROM permissions p0_ WHERE p0_.role_id = ? ORDER BY p0_.bundle ASC
Parameters:
[
1
]
|
|
1.06 ms (37.37%) |
1 |
SELECT u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.preferences AS preferences_21, u0_.signature AS signature_22, r1_.is_published AS is_published_23, r1_.date_added AS date_added_24, r1_.created_by AS created_by_25, r1_.created_by_user AS created_by_user_26, r1_.date_modified AS date_modified_27, r1_.modified_by AS modified_by_28, r1_.modified_by_user AS modified_by_user_29, r1_.checked_out AS checked_out_30, r1_.checked_out_by AS checked_out_by_31, r1_.checked_out_by_user AS checked_out_by_user_32, r1_.id AS id_33, r1_.name AS name_34, r1_.description AS description_35, r1_.is_admin AS is_admin_36, r1_.readable_permissions AS readable_permissions_37, r1_.uuid AS uuid_38, u0_.role_id AS role_id_39 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE (u0_.username = ? OR u0_.email = ?) AND u0_.is_published = ?
Parameters:
[ "admin" "admin" 1 ] |
|
0.46 ms (16.19%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_published AS is_published_2, p0_.supported_features AS supported_features_3, p0_.api_keys AS api_keys_4, p0_.feature_settings AS feature_settings_5, p0_.plugin_id AS plugin_id_6 FROM plugin_integration_settings p0_ WHERE p0_.name = ? LIMIT 1
Parameters:
[
"grapesjsbuilder"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| unbuffered | doctrine.dbal.unbuffered_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 |
|---|---|
| Mautic\ApiBundle\Entity\oAuth2\Client | No errors. |
| Mautic\ApiBundle\Entity\oAuth2\AccessToken | No errors. |
| Mautic\ApiBundle\Entity\oAuth2\RefreshToken | No errors. |
| Mautic\CoreBundle\Entity\CommonEntity | No errors. |
| Mautic\CoreBundle\Entity\FormEntity | No errors. |
| Mautic\UserBundle\Entity\User | No errors. |
| Mautic\UserBundle\Entity\Role | No errors. |
| Mautic\UserBundle\Entity\Permission | No errors. |
| Mautic\PluginBundle\Entity\Integration | No errors. |
| Mautic\PluginBundle\Entity\Plugin | No errors. |