Query Metrics
3
Database Queries
3
Different statements
2.28 ms
Query time
2
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.00 ms |
SELECT y0_.is_published AS is_published_0, y0_.date_added AS date_added_1, y0_.created_by AS created_by_2, y0_.created_by_user AS created_by_user_3, y0_.date_modified AS date_modified_4, y0_.modified_by AS modified_by_5, y0_.modified_by_user AS modified_by_user_6, y0_.checked_out AS checked_out_7, y0_.checked_out_by AS checked_out_by_8, y0_.checked_out_by_user AS checked_out_by_user_9, y0_.id AS id_10, y0_.username AS username_11, y0_.password AS password_12, y0_.first_name AS first_name_13, y0_.last_name AS last_name_14, y0_.email AS email_15, y0_.position AS position_16, y0_.timezone AS timezone_17, y0_.locale AS locale_18, y0_.last_login AS last_login_19, y0_.last_active AS last_active_20, y0_.preferences AS preferences_21, y0_.signature AS signature_22, y1_.is_published AS is_published_23, y1_.date_added AS date_added_24, y1_.created_by AS created_by_25, y1_.created_by_user AS created_by_user_26, y1_.date_modified AS date_modified_27, y1_.modified_by AS modified_by_28, y1_.modified_by_user AS modified_by_user_29, y1_.checked_out AS checked_out_30, y1_.checked_out_by AS checked_out_by_31, y1_.checked_out_by_user AS checked_out_by_user_32, y1_.id AS id_33, y1_.name AS name_34, y1_.description AS description_35, y1_.is_admin AS is_admin_36, y1_.readable_permissions AS readable_permissions_37, y1_.uuid AS uuid_38, y0_.role_id AS role_id_39 FROM yd_users y0_ LEFT JOIN yd_roles y1_ ON y0_.role_id = y1_.id WHERE (y0_.username = ? OR y0_.email = ?) AND y0_.is_published = ?
Parameters:
[ "admin" "admin" 1 ] |
| 2 | 0.55 ms |
SELECT y0_.id AS id_0, y0_.bundle AS bundle_1, y0_.name AS name_2, y0_.bitwise AS bitwise_3, y0_.uuid AS uuid_4 FROM yd_permissions y0_ WHERE y0_.role_id = ? ORDER BY y0_.bundle ASC
Parameters:
[
1
]
|
| 3 | 0.73 ms |
SELECT y0_.id AS id_0, y0_.name AS name_1, y0_.is_published AS is_published_2, y0_.supported_features AS supported_features_3, y0_.api_keys AS api_keys_4, y0_.feature_settings AS feature_settings_5, y0_.plugin_id AS plugin_id_6 FROM yd_plugin_integration_settings y0_ WHERE y0_.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 |
|
| Mautic\ApiBundle\Entity\oAuth2\RefreshToken |
|
| 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. |