Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.13 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.13 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.roles AS roles_5, t0.is_verified AS is_verified_6, t0.app_version AS app_version_7, t0.id_sso AS id_sso_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.push_notifications AS push_notifications_13, t11.email_notifications AS email_notifications_14, t11.email_event AS email_event_15, t11.email_promo AS email_promo_16, t11.push_event AS push_event_17, t11.push_promo AS push_promo_18, t11.push_alert AS push_alert_19, t11.push_comment AS push_comment_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.user_id AS user_id_23, t24.id AS id_25, t24.verify_request_date AS verify_request_date_26, t24.verify_request_token AS verify_request_token_27, t24.created_at AS created_at_28, t24.updated_at AS updated_at_29, t24.user_id AS user_id_30, t31.id AS id_32, t31.login_failure_attempts AS login_failure_attempts_33, t31.created_at AS created_at_34, t31.updated_at AS updated_at_35, t31.user_id AS user_id_36, t37.id AS id_38, t37.civility AS civility_39, t37.firstname AS firstname_40, t37.lastname AS lastname_41, t37.othernames AS othernames_42, t37.birthcountry AS birthcountry_43, t37.birthcity AS birthcity_44, t37.nationality AS nationality_45, t37.phone AS phone_46, t37.mobile AS mobile_47, t37.birthdate AS birthdate_48, t37.photopath AS photopath_49, t37.idpath AS idpath_50, t37.avatar AS avatar_51, t37.comment AS comment_52, t37.created_at AS created_at_53, t37.updated_at AS updated_at_54, t37.user_id AS user_id_55, t37.address_id AS address_id_56, t0.service_regional_id AS service_regional_id_57 FROM user t0 LEFT JOIN notification_preference t11 ON t11.user_id = t0.id LEFT JOIN user_account_verification t24 ON t24.user_id = t0.id LEFT JOIN user_login_failure t31 ON t31.user_id = t0.id LEFT JOIN user_profile t37 ON t37.user_id = t0.id WHERE t0.email IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.roles AS roles_5, t0.is_verified AS is_verified_6, t0.app_version AS app_version_7, t0.id_sso AS id_sso_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.push_notifications AS push_notifications_13, t11.email_notifications AS email_notifications_14, t11.email_event AS email_event_15, t11.email_promo AS email_promo_16, t11.push_event AS push_event_17, t11.push_promo AS push_promo_18, t11.push_alert AS push_alert_19, t11.push_comment AS push_comment_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.user_id AS user_id_23, t24.id AS id_25, t24.verify_request_date AS verify_request_date_26, t24.verify_request_token AS verify_request_token_27, t24.created_at AS created_at_28, t24.updated_at AS updated_at_29, t24.user_id AS user_id_30, t31.id AS id_32, t31.login_failure_attempts AS login_failure_attempts_33, t31.created_at AS created_at_34, t31.updated_at AS updated_at_35, t31.user_id AS user_id_36, t37.id AS id_38, t37.civility AS civility_39, t37.firstname AS firstname_40, t37.lastname AS lastname_41, t37.othernames AS othernames_42, t37.birthcountry AS birthcountry_43, t37.birthcity AS birthcity_44, t37.nationality AS nationality_45, t37.phone AS phone_46, t37.mobile AS mobile_47, t37.birthdate AS birthdate_48, t37.photopath AS photopath_49, t37.idpath AS idpath_50, t37.avatar AS avatar_51, t37.comment AS comment_52, t37.created_at AS created_at_53, t37.updated_at AS updated_at_54, t37.user_id AS user_id_55, t37.address_id AS address_id_56, t0.service_regional_id AS service_regional_id_57 FROM user t0 LEFT JOIN notification_preference t11 ON t11.user_id = t0.id LEFT JOIN user_account_verification t24 ON t24.user_id = t0.id LEFT JOIN user_login_failure t31 ON t31.user_id = t0.id LEFT JOIN user_profile t37 ON t37.user_id = t0.id WHERE t0.email IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.roles AS roles_5, t0.is_verified AS is_verified_6, t0.app_version AS app_version_7, t0.id_sso AS id_sso_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.push_notifications AS push_notifications_13, t11.email_notifications AS email_notifications_14, t11.email_event AS email_event_15, t11.email_promo AS email_promo_16, t11.push_event AS push_event_17, t11.push_promo AS push_promo_18, t11.push_alert AS push_alert_19, t11.push_comment AS push_comment_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.user_id AS user_id_23, t24.id AS id_25, t24.verify_request_date AS verify_request_date_26, t24.verify_request_token AS verify_request_token_27, t24.created_at AS created_at_28, t24.updated_at AS updated_at_29, t24.user_id AS user_id_30, t31.id AS id_32, t31.login_failure_attempts AS login_failure_attempts_33, t31.created_at AS created_at_34, t31.updated_at AS updated_at_35, t31.user_id AS user_id_36, t37.id AS id_38, t37.civility AS civility_39, t37.firstname AS firstname_40, t37.lastname AS lastname_41, t37.othernames AS othernames_42, t37.birthcountry AS birthcountry_43, t37.birthcity AS birthcity_44, t37.nationality AS nationality_45, t37.phone AS phone_46, t37.mobile AS mobile_47, t37.birthdate AS birthdate_48, t37.photopath AS photopath_49, t37.idpath AS idpath_50, t37.avatar AS avatar_51, t37.comment AS comment_52, t37.created_at AS created_at_53, t37.updated_at AS updated_at_54, t37.user_id AS user_id_55, t37.address_id AS address_id_56, t0.service_regional_id AS service_regional_id_57 FROM user t0 LEFT JOIN notification_preference t11 ON t11.user_id = t0.id LEFT JOIN user_account_verification t24 ON t24.user_id = t0.id LEFT JOIN user_login_failure t31 ON t31.user_id = t0.id LEFT JOIN user_profile t37 ON t37.user_id = t0.id WHERE t0.email IS NULL LIMIT 1;

#▲

Time

Info

1.13 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.roles AS roles_5, t0.is_verified AS is_verified_6, t0.app_version AS app_version_7, t0.id_sso AS id_sso_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.push_notifications AS push_notifications_13, t11.email_notifications AS email_notifications_14, t11.email_event AS email_event_15, t11.email_promo AS email_promo_16, t11.push_event AS push_event_17, t11.push_promo AS push_promo_18, t11.push_alert AS push_alert_19, t11.push_comment AS push_comment_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.user_id AS user_id_23, t24.id AS id_25, t24.verify_request_date AS verify_request_date_26, t24.verify_request_token AS verify_request_token_27, t24.created_at AS created_at_28, t24.updated_at AS updated_at_29, t24.user_id AS user_id_30, t31.id AS id_32, t31.login_failure_attempts AS login_failure_attempts_33, t31.created_at AS created_at_34, t31.updated_at AS updated_at_35, t31.user_id AS user_id_36, t37.id AS id_38, t37.civility AS civility_39, t37.firstname AS firstname_40, t37.lastname AS lastname_41, t37.othernames AS othernames_42, t37.birthcountry AS birthcountry_43, t37.birthcity AS birthcity_44, t37.nationality AS nationality_45, t37.phone AS phone_46, t37.mobile AS mobile_47, t37.birthdate AS birthdate_48, t37.photopath AS photopath_49, t37.idpath AS idpath_50, t37.avatar AS avatar_51, t37.comment AS comment_52, t37.created_at AS created_at_53, t37.updated_at AS updated_at_54, t37.user_id AS user_id_55, t37.address_id AS address_id_56, t0.service_regional_id AS service_regional_id_57 FROM user t0 LEFT JOIN notification_preference t11 ON t11.user_id = t0.id LEFT JOIN user_account_verification t24 ON t24.user_id = t0.id LEFT JOIN user_login_failure t31 ON t31.user_id = t0.id LEFT JOIN user_profile t37 ON t37.user_id = t0.id WHERE t0.email IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.status AS status_4,
  t0.roles AS roles_5,
  t0.is_verified AS is_verified_6,
  t0.app_version AS app_version_7,
  t0.id_sso AS id_sso_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.push_notifications AS push_notifications_13,
  t11.email_notifications AS email_notifications_14,
  t11.email_event AS email_event_15,
  t11.email_promo AS email_promo_16,
  t11.push_event AS push_event_17,
  t11.push_promo AS push_promo_18,
  t11.push_alert AS push_alert_19,
  t11.push_comment AS push_comment_20,
  t11.created_at AS created_at_21,
  t11.updated_at AS updated_at_22,
  t11.user_id AS user_id_23,
  t24.id AS id_25,
  t24.verify_request_date AS verify_request_date_26,
  t24.verify_request_token AS verify_request_token_27,
  t24.created_at AS created_at_28,
  t24.updated_at AS updated_at_29,
  t24.user_id AS user_id_30,
  t31.id AS id_32,
  t31.login_failure_attempts AS login_failure_attempts_33,
  t31.created_at AS created_at_34,
  t31.updated_at AS updated_at_35,
  t31.user_id AS user_id_36,
  t37.id AS id_38,
  t37.civility AS civility_39,
  t37.firstname AS firstname_40,
  t37.lastname AS lastname_41,
  t37.othernames AS othernames_42,
  t37.birthcountry AS birthcountry_43,
  t37.birthcity AS birthcity_44,
  t37.nationality AS nationality_45,
  t37.phone AS phone_46,
  t37.mobile AS mobile_47,
  t37.birthdate AS birthdate_48,
  t37.photopath AS photopath_49,
  t37.idpath AS idpath_50,
  t37.avatar AS avatar_51,
  t37.comment AS comment_52,
  t37.created_at AS created_at_53,
  t37.updated_at AS updated_at_54,
  t37.user_id AS user_id_55,
  t37.address_id AS address_id_56,
  t0.service_regional_id AS service_regional_id_57
FROM
  user t0
  LEFT JOIN notification_preference t11 ON t11.user_id = t0.id
  LEFT JOIN user_account_verification t24 ON t24.user_id = t0.id
  LEFT JOIN user_login_failure t31 ON t31.user_id = t0.id
  LEFT JOIN user_profile t37 ON t37.user_id = t0.id
WHERE
  t0.email IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.status AS status_4, t0.roles AS roles_5, t0.is_verified AS is_verified_6, t0.app_version AS app_version_7, t0.id_sso AS id_sso_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.push_notifications AS push_notifications_13, t11.email_notifications AS email_notifications_14, t11.email_event AS email_event_15, t11.email_promo AS email_promo_16, t11.push_event AS push_event_17, t11.push_promo AS push_promo_18, t11.push_alert AS push_alert_19, t11.push_comment AS push_comment_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.user_id AS user_id_23, t24.id AS id_25, t24.verify_request_date AS verify_request_date_26, t24.verify_request_token AS verify_request_token_27, t24.created_at AS created_at_28, t24.updated_at AS updated_at_29, t24.user_id AS user_id_30, t31.id AS id_32, t31.login_failure_attempts AS login_failure_attempts_33, t31.created_at AS created_at_34, t31.updated_at AS updated_at_35, t31.user_id AS user_id_36, t37.id AS id_38, t37.civility AS civility_39, t37.firstname AS firstname_40, t37.lastname AS lastname_41, t37.othernames AS othernames_42, t37.birthcountry AS birthcountry_43, t37.birthcity AS birthcity_44, t37.nationality AS nationality_45, t37.phone AS phone_46, t37.mobile AS mobile_47, t37.birthdate AS birthdate_48, t37.photopath AS photopath_49, t37.idpath AS idpath_50, t37.avatar AS avatar_51, t37.comment AS comment_52, t37.created_at AS created_at_53, t37.updated_at AS updated_at_54, t37.user_id AS user_id_55, t37.address_id AS address_id_56, t0.service_regional_id AS service_regional_id_57 FROM user t0 LEFT JOIN notification_preference t11 ON t11.user_id = t0.id LEFT JOIN user_account_verification t24 ON t24.user_id = t0.id LEFT JOIN user_login_failure t31 ON t31.user_id = t0.id LEFT JOIN user_profile t37 ON t37.user_id = t0.id WHERE t0.email IS NULL LIMIT 1;

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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\NotificationPreference	No errors.
App\Entity\UserAccountVerification	No errors.
App\Entity\UserLoginFailure	No errors.
App\Entity\UserProfile	No errors.
App\Entity\Address	No errors.
App\Entity\ServiceRegional	No errors.

Symfony Profiler

GET https://bo.crr.frenchappweb.com/api/v1/auth/verify

Configuration Settings

Theme

Page Width