Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.03 ms Query time

7 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
2.03 ms (100.00%)	1	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.first_name AS first_name_15, t0.last_name AS last_name_16, t0.gender AS gender_17, t0.phone_number AS phone_number_18, t0.country_code AS country_code_19, t0.business_entity AS business_entity_20, t0.verified_at AS verified_at_21, t0.is_verified AS is_verified_22, t0.password_reset_expiry_date AS password_reset_expiry_date_23, t0.password_reset_requested AS password_reset_requested_24, t0.password_reset_code AS password_reset_code_25, t0.last_password_reset_date AS last_password_reset_date_26, t0.profile_pix AS profile_pix_27, t0.is_account_finally_approved AS is_account_finally_approved_28, t0.last_verification_email_sent_at AS last_verification_email_sent_at_29, t0.email_retry_count AS email_retry_count_30, t31.id AS id_32, t31.legal_business_name AS legal_business_name_33, t31.registration_type AS registration_type_34, t31.ownership_structure AS ownership_structure_35, t31.business_type AS business_type_36, t31.industry AS industry_37, t31.staff_size AS staff_size_38, t31.tax_identification_number AS tax_identification_number_39, t31.certificate_of_incorporation AS certificate_of_incorporation_40, t31.form3 AS form3_41, t31.name_of_directors AS name_of_directors_42, t31.beneficiary_owners AS beneficiary_owners_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.owner_id AS owner_id_46, t0.tenant_id AS tenant_id_47 FROM user__user t0 LEFT JOIN user_company t31 ON t31.owner_id = t0.id WHERE t0.email_canonical = ? LIMIT 1 Parameters: [`"slamadeku@hotmail.com"`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.first_name AS first_name_15, t0.last_name AS last_name_16, t0.gender AS gender_17, t0.phone_number AS phone_number_18, t0.country_code AS country_code_19, t0.business_entity AS business_entity_20, t0.verified_at AS verified_at_21, t0.is_verified AS is_verified_22, t0.password_reset_expiry_date AS password_reset_expiry_date_23, t0.password_reset_requested AS password_reset_requested_24, t0.password_reset_code AS password_reset_code_25, t0.last_password_reset_date AS last_password_reset_date_26, t0.profile_pix AS profile_pix_27, t0.is_account_finally_approved AS is_account_finally_approved_28, t0.last_verification_email_sent_at AS last_verification_email_sent_at_29, t0.email_retry_count AS email_retry_count_30, t31.id AS id_32, t31.legal_business_name AS legal_business_name_33, t31.registration_type AS registration_type_34, t31.ownership_structure AS ownership_structure_35, t31.business_type AS business_type_36, t31.industry AS industry_37, t31.staff_size AS staff_size_38, t31.tax_identification_number AS tax_identification_number_39, t31.certificate_of_incorporation AS certificate_of_incorporation_40, t31.form3 AS form3_41, t31.name_of_directors AS name_of_directors_42, t31.beneficiary_owners AS beneficiary_owners_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.owner_id AS owner_id_46, t0.tenant_id AS tenant_id_47 FROM user__user t0 LEFT JOIN user_company t31 ON t31.owner_id = t0.id WHERE t0.email_canonical = ? LIMIT 1 SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.first_name AS first_name_15, t0.last_name AS last_name_16, t0.gender AS gender_17, t0.phone_number AS phone_number_18, t0.country_code AS country_code_19, t0.business_entity AS business_entity_20, t0.verified_at AS verified_at_21, t0.is_verified AS is_verified_22, t0.password_reset_expiry_date AS password_reset_expiry_date_23, t0.password_reset_requested AS password_reset_requested_24, t0.password_reset_code AS password_reset_code_25, t0.last_password_reset_date AS last_password_reset_date_26, t0.profile_pix AS profile_pix_27, t0.is_account_finally_approved AS is_account_finally_approved_28, t0.last_verification_email_sent_at AS last_verification_email_sent_at_29, t0.email_retry_count AS email_retry_count_30, t31.id AS id_32, t31.legal_business_name AS legal_business_name_33, t31.registration_type AS registration_type_34, t31.ownership_structure AS ownership_structure_35, t31.business_type AS business_type_36, t31.industry AS industry_37, t31.staff_size AS staff_size_38, t31.tax_identification_number AS tax_identification_number_39, t31.certificate_of_incorporation AS certificate_of_incorporation_40, t31.form3 AS form3_41, t31.name_of_directors AS name_of_directors_42, t31.beneficiary_owners AS beneficiary_owners_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.owner_id AS owner_id_46, t0.tenant_id AS tenant_id_47 FROM user__user t0 LEFT JOIN user_company t31 ON t31.owner_id = t0.id WHERE t0.email_canonical = 'slamadeku@hotmail.com' LIMIT 1;

Time▼

Count

Info

2.03 ms
(100.00%)

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.first_name AS first_name_15, t0.last_name AS last_name_16, t0.gender AS gender_17, t0.phone_number AS phone_number_18, t0.country_code AS country_code_19, t0.business_entity AS business_entity_20, t0.verified_at AS verified_at_21, t0.is_verified AS is_verified_22, t0.password_reset_expiry_date AS password_reset_expiry_date_23, t0.password_reset_requested AS password_reset_requested_24, t0.password_reset_code AS password_reset_code_25, t0.last_password_reset_date AS last_password_reset_date_26, t0.profile_pix AS profile_pix_27, t0.is_account_finally_approved AS is_account_finally_approved_28, t0.last_verification_email_sent_at AS last_verification_email_sent_at_29, t0.email_retry_count AS email_retry_count_30, t31.id AS id_32, t31.legal_business_name AS legal_business_name_33, t31.registration_type AS registration_type_34, t31.ownership_structure AS ownership_structure_35, t31.business_type AS business_type_36, t31.industry AS industry_37, t31.staff_size AS staff_size_38, t31.tax_identification_number AS tax_identification_number_39, t31.certificate_of_incorporation AS certificate_of_incorporation_40, t31.form3 AS form3_41, t31.name_of_directors AS name_of_directors_42, t31.beneficiary_owners AS beneficiary_owners_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.owner_id AS owner_id_46, t0.tenant_id AS tenant_id_47 FROM user__user t0 LEFT JOIN user_company t31 ON t31.owner_id = t0.id WHERE t0.email_canonical = ? LIMIT 1

Parameters:

[
  "slamadeku@hotmail.com"
]

View formatted query View runnable query Explain query

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.id AS id_14,
  t0.first_name AS first_name_15,
  t0.last_name AS last_name_16,
  t0.gender AS gender_17,
  t0.phone_number AS phone_number_18,
  t0.country_code AS country_code_19,
  t0.business_entity AS business_entity_20,
  t0.verified_at AS verified_at_21,
  t0.is_verified AS is_verified_22,
  t0.password_reset_expiry_date AS password_reset_expiry_date_23,
  t0.password_reset_requested AS password_reset_requested_24,
  t0.password_reset_code AS password_reset_code_25,
  t0.last_password_reset_date AS last_password_reset_date_26,
  t0.profile_pix AS profile_pix_27,
  t0.is_account_finally_approved AS is_account_finally_approved_28,
  t0.last_verification_email_sent_at AS last_verification_email_sent_at_29,
  t0.email_retry_count AS email_retry_count_30,
  t31.id AS id_32,
  t31.legal_business_name AS legal_business_name_33,
  t31.registration_type AS registration_type_34,
  t31.ownership_structure AS ownership_structure_35,
  t31.business_type AS business_type_36,
  t31.industry AS industry_37,
  t31.staff_size AS staff_size_38,
  t31.tax_identification_number AS tax_identification_number_39,
  t31.certificate_of_incorporation AS certificate_of_incorporation_40,
  t31.form3 AS form3_41,
  t31.name_of_directors AS name_of_directors_42,
  t31.beneficiary_owners AS beneficiary_owners_43,
  t31.created_at AS created_at_44,
  t31.updated_at AS updated_at_45,
  t31.owner_id AS owner_id_46,
  t0.tenant_id AS tenant_id_47
FROM
  user__user t0
  LEFT JOIN user_company t31 ON t31.owner_id = t0.id
WHERE
  t0.email_canonical = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.first_name AS first_name_15, t0.last_name AS last_name_16, t0.gender AS gender_17, t0.phone_number AS phone_number_18, t0.country_code AS country_code_19, t0.business_entity AS business_entity_20, t0.verified_at AS verified_at_21, t0.is_verified AS is_verified_22, t0.password_reset_expiry_date AS password_reset_expiry_date_23, t0.password_reset_requested AS password_reset_requested_24, t0.password_reset_code AS password_reset_code_25, t0.last_password_reset_date AS last_password_reset_date_26, t0.profile_pix AS profile_pix_27, t0.is_account_finally_approved AS is_account_finally_approved_28, t0.last_verification_email_sent_at AS last_verification_email_sent_at_29, t0.email_retry_count AS email_retry_count_30, t31.id AS id_32, t31.legal_business_name AS legal_business_name_33, t31.registration_type AS registration_type_34, t31.ownership_structure AS ownership_structure_35, t31.business_type AS business_type_36, t31.industry AS industry_37, t31.staff_size AS staff_size_38, t31.tax_identification_number AS tax_identification_number_39, t31.certificate_of_incorporation AS certificate_of_incorporation_40, t31.form3 AS form3_41, t31.name_of_directors AS name_of_directors_42, t31.beneficiary_owners AS beneficiary_owners_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.owner_id AS owner_id_46, t0.tenant_id AS tenant_id_47 FROM user__user t0 LEFT JOIN user_company t31 ON t31.owner_id = t0.id WHERE t0.email_canonical = 'slamadeku@hotmail.com' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
secondary	doctrine.dbal.secondary_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
Sonata\UserBundle\Entity\BaseUser	No errors.
App\Entity\SonataUserUser	The field App\Entity\SonataUserUser#welfareRequests is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\WelfareRequest#applicant does not contain the required 'inversedBy="welfareRequests"' attribute.
App\Entity\UserCompany	No errors.
App\Entity\ProsperityCircleTenant	No errors.
App\Entity\UserProfile	No errors.
App\Entity\UserContactDetails	No errors.
App\Entity\UserMomoBankInformation	No errors.
App\Entity\WelfareMembership	No errors.
App\Entity\WelfareRequest	No errors.
App\Entity\ProsperityCircleEmployee	No errors.
App\Entity\ProsperityCircleScheme	No errors.
App\Entity\WelfareScheme	No errors.
App\Entity\WelfareContribution	No errors.
App\Entity\WelfareDependent	No errors.
App\Entity\WelfareCommitteeVote	No errors.
App\Entity\WelfareRequestLog	No errors.
App\Entity\WelfareDisbursement	No errors.
App\Entity\Payout	No errors.
App\Entity\AlumniCampaignMember	No errors.
App\Entity\ProsperityCircleFundYieldHistory	No errors.
App\Entity\AlumniContribution	No errors.
App\Entity\FixedSusuPayout	No errors.
App\Entity\ProsperityCircleWithdrawalRequest	No errors.
App\Entity\InvestmentSusuTransaction	No errors.
App\Entity\ProsperityCircleVoluntaryTopupWithdrawalRequest	No errors.
App\Entity\ProsperityCircleLoanRequest	No errors.
App\Entity\InvestmentSusuPlan	The field App\Entity\InvestmentSusuPlan#payout is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InvestmentSusuPayout#plan does not contain the required 'inversedBy="payout"' attribute.
App\Entity\ProsperityCircleLoanRepayment	No errors.
App\Entity\ProsperityCircleLoanSetting	No errors.
App\Entity\ProsperityCircleContributionBatch	No errors.
App\Entity\SusuGroupMember	No errors.
App\Entity\SusuGroupInvitation	No errors.
App\Entity\AlumniPayoutRequest	The field App\Entity\AlumniPayoutRequest#votes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AlumniPayoutVote#payoutRequest does not contain the required 'inversedBy="votes"' attribute.
App\Entity\ProsperityCircleSchemeForfeitureLedger	No errors.
App\Entity\ProsperityCircleEmployeeEarningsLedger	No errors.
App\Entity\InvestmentSusuInterestLog	No errors.
App\Entity\ProsperityCircleLoanApprovalAuditLog	No errors.
App\Entity\InvestmentSusuTier	No errors.
App\Entity\WelfareFund	The association App\Entity\WelfareFund#requests refers to the owning side field App\Entity\WelfareRequest#fund which does not exist.
App\Entity\FixedSusuContribution	No errors.
App\Entity\UserServiceAgreement	No errors.
App\Entity\SusuGroupAudit	No errors.
App\Entity\FuneralDonation	No errors.
App\Entity\ProsperityCircleContributionItem	No errors.
App\Entity\AlumniCampaignAudit	No errors.
App\Entity\AlumniPayoutAttachment	The association App\Entity\AlumniPayoutAttachment#payoutRequest refers to the inverse side field App\Entity\AlumniPayoutRequest#attachments which does not exist.
App\Entity\ServicesAgreement	No errors.
App\Entity\SusuGroup	No errors.
App\Entity\AlumniCampaign	The field App\Entity\AlumniCampaign#payoutRequests is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AlumniPayoutRequest#campaign does not contain the required 'inversedBy="payoutRequests"' attribute.
App\Entity\WelfarePayoutLog	No errors.
App\Entity\FuneralDonationPayout	The field App\Entity\FuneralDonationPayout#memberApprovals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\FuneralDonationMemberApproval#payout does not contain the required 'inversedBy="memberApprovals"' attribute.
App\Entity\WelfareWaiverLog	No errors.
App\Entity\WelfareAuditLog	No errors.
App\Entity\AlumniCampaignMilestone	No errors.
App\Entity\FixedSusuPlan	No errors.
App\Entity\FuneralDonationMember	No errors.
App\Entity\CommissionConfig	No errors.
App\Entity\FuneralDonationMemberApproval	No errors.
App\Entity\ProsperityCircleVoluntaryTopup	No errors.
App\Entity\FuneralDonationContribution	No errors.
App\Entity\WelfareDependentAuditLog	No errors.
App\Entity\LoginAttempt	No errors.
App\Entity\InvestmentSusuPayout	No errors.
App\Entity\AlumniPayoutVote	No errors.
App\Entity\Contribution	No errors.
App\Entity\ProsperityCircleCompanyYieldAllocation	No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry	No errors.
Gedmo\Loggable\Entity\LogEntry	No errors.

Symfony Profiler

POST https://staging.kolect4me.com/admin/login_check

Configuration Settings

Theme

Page Width