Query Metrics

3 Database Queries
3 Different statements
2.28 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.00 ms
(43.77%)
1
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
]
0.73 ms
(32.18%)
1
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"
]
0.55 ms
(24.06%)
1
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
]

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
  • The field 'Mautic\ApiBundle\Entity\oAuth2\AccessToken#expiresAt' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
Mautic\ApiBundle\Entity\oAuth2\RefreshToken
  • The field 'Mautic\ApiBundle\Entity\oAuth2\RefreshToken#expiresAt' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
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.