Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.52 ms Query time

18 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.77 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.username AS username_4, t0.address AS address_5, t0.roles AS roles_6, t0.company_relation AS company_relation_7, t0.avatar AS avatar_8, t0.phone AS phone_9, t0.birth_date AS birth_date_10, t0.card_number AS card_number_11, t0.cad_date_issue AS cad_date_issue_12, t0.card_expiry_date AS card_expiry_date_13, t0.license_number AS license_number_14, t0.license_date_issue AS license_date_issue_15, t0.license_expiry_date AS license_expiry_date_16, t0.stripecustomerid AS stripecustomerid_17, t0.phones AS phones_18, t0.discount_limit AS discount_limit_19, t0.points AS points_20, t0.deleted_at AS deleted_at_21, t0.reset_token AS reset_token_22, t0.reset_token_expires_at AS reset_token_expires_at_23, t0.visa_card_number AS visa_card_number_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.user_id AS user_id_27, t0.company_id AS company_id_28, t0.role_id AS role_id_29, t0.company_agency_id AS company_agency_id_30, t0.country_id AS country_id_31, t0.created_by_id AS created_by_id_32, t33.id AS id_34, t33.deleted_at AS deleted_at_35, t33.status AS status_36, t33.created_at AS created_at_37, t33.updated_at AS updated_at_38, t33.badge_id AS badge_id_39, t33.customer_id AS customer_id_40, t33.affected_by_id AS affected_by_id_41, t33.company_id AS company_id_42, t0.user_organization_id AS user_organization_id_43 FROM user_company t0 LEFT JOIN user_badge t33 ON t33.customer_id = t0.id WHERE t0.email = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "montasser@omancar.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.username AS username_4,
  t0.address AS address_5,
  t0.roles AS roles_6,
  t0.company_relation AS company_relation_7,
  t0.avatar AS avatar_8,
  t0.phone AS phone_9,
  t0.birth_date AS birth_date_10,
  t0.card_number AS card_number_11,
  t0.cad_date_issue AS cad_date_issue_12,
  t0.card_expiry_date AS card_expiry_date_13,
  t0.license_number AS license_number_14,
  t0.license_date_issue AS license_date_issue_15,
  t0.license_expiry_date AS license_expiry_date_16,
  t0.stripecustomerid AS stripecustomerid_17,
  t0.phones AS phones_18,
  t0.discount_limit AS discount_limit_19,
  t0.points AS points_20,
  t0.deleted_at AS deleted_at_21,
  t0.reset_token AS reset_token_22,
  t0.reset_token_expires_at AS reset_token_expires_at_23,
  t0.visa_card_number AS visa_card_number_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.user_id AS user_id_27,
  t0.company_id AS company_id_28,
  t0.role_id AS role_id_29,
  t0.company_agency_id AS company_agency_id_30,
  t0.country_id AS country_id_31,
  t0.created_by_id AS created_by_id_32,
  t33.id AS id_34,
  t33.deleted_at AS deleted_at_35,
  t33.status AS status_36,
  t33.created_at AS created_at_37,
  t33.updated_at AS updated_at_38,
  t33.badge_id AS badge_id_39,
  t33.customer_id AS customer_id_40,
  t33.affected_by_id AS affected_by_id_41,
  t33.company_id AS company_id_42,
  t0.user_organization_id AS user_organization_id_43
FROM
  user_company t0
  LEFT JOIN user_badge t33 ON t33.customer_id = t0.id
WHERE
  t0.email = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.username AS username_4, t0.address AS address_5, t0.roles AS roles_6, t0.company_relation AS company_relation_7, t0.avatar AS avatar_8, t0.phone AS phone_9, t0.birth_date AS birth_date_10, t0.card_number AS card_number_11, t0.cad_date_issue AS cad_date_issue_12, t0.card_expiry_date AS card_expiry_date_13, t0.license_number AS license_number_14, t0.license_date_issue AS license_date_issue_15, t0.license_expiry_date AS license_expiry_date_16, t0.stripecustomerid AS stripecustomerid_17, t0.phones AS phones_18, t0.discount_limit AS discount_limit_19, t0.points AS points_20, t0.deleted_at AS deleted_at_21, t0.reset_token AS reset_token_22, t0.reset_token_expires_at AS reset_token_expires_at_23, t0.visa_card_number AS visa_card_number_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.user_id AS user_id_27, t0.company_id AS company_id_28, t0.role_id AS role_id_29, t0.company_agency_id AS company_agency_id_30, t0.country_id AS country_id_31, t0.created_by_id AS created_by_id_32, t33.id AS id_34, t33.deleted_at AS deleted_at_35, t33.status AS status_36, t33.created_at AS created_at_37, t33.updated_at AS updated_at_38, t33.badge_id AS badge_id_39, t33.customer_id AS customer_id_40, t33.affected_by_id AS affected_by_id_41, t33.company_id AS company_id_42, t0.user_organization_id AS user_organization_id_43 FROM user_company t0 LEFT JOIN user_badge t33 ON t33.customer_id = t0.id WHERE t0.email = 'montasser@omancar.com' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.76 ms

SELECT t0.id AS id_1, t0.star_date AS star_date_2, t0.end_date AS end_date_3, t0.start_date_transfer AS start_date_transfer_4, t0.end_date_transfer AS end_date_transfer_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.authority_role_id AS authority_role_id_9, t0.user_company_id AS user_company_id_10, t0.transfer_to_id AS transfer_to_id_11 FROM user_role t0 WHERE t0.user_company_id IN (?) AND ((t0.deleted_at IS NULL))

Parameters:

[
  120
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.star_date AS star_date_2,
  t0.end_date AS end_date_3,
  t0.start_date_transfer AS start_date_transfer_4,
  t0.end_date_transfer AS end_date_transfer_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.authority_role_id AS authority_role_id_9,
  t0.user_company_id AS user_company_id_10,
  t0.transfer_to_id AS transfer_to_id_11
FROM
  user_role t0
WHERE
  t0.user_company_id IN (?)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.star_date AS star_date_2, t0.end_date AS end_date_3, t0.start_date_transfer AS start_date_transfer_4, t0.end_date_transfer AS end_date_transfer_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.authority_role_id AS authority_role_id_9, t0.user_company_id AS user_company_id_10, t0.transfer_to_id AS transfer_to_id_11 FROM user_role t0 WHERE t0.user_company_id IN (120) AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2653)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2629)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 742)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
8	Doctrine\ORM\EntityRepository->findOneBy (line 80)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
10	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
11	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
12	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
13	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
14	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
15	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
20	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
21	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
22	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
23	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
24	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
25	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
26	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
27	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
28	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

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.

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\UserCompany	The association App\Entity\UserCompany#companies refers to the owning side field App\Entity\Company#createdBy which does not exist. The association App\Entity\UserCompany#incomes refers to the owning side field App\Entity\Income#userCompany which does not exist.
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Role	No errors.
App\Entity\CompanyAgency	The mappings App\Entity\CompanyAgency#updatedBy and App\Entity\UserCompany#companyAgencies are inconsistent with each other.
App\Entity\Country	No errors.
App\Entity\UserBadge	No errors.
App\Entity\Badge	No errors.
App\Entity\UserOrganization	No errors.
App\Entity\UserRole	No errors.
App\Entity\UserCompanyTranslate	No errors.
App\Entity\OptionValue	No errors.
App\Entity\Booking	The mappings App\Entity\Booking#checkedOutBy and App\Entity\UserCompany#bookingsChecked are inconsistent with each other. The mappings App\Entity\Booking#driverBy and App\Entity\UserCompany#bookingsChecked are inconsistent with each other.
App\Entity\Car	The mappings App\Entity\Car#updatedBy and App\Entity\UserCompany#cars are inconsistent with each other.
App\Entity\Invoice	The association App\Entity\Invoice#bank refers to the inverse side field App\Entity\Bank#invoices which does not exist.
App\Entity\Maintenance	No errors.
App\Entity\DamageType	No errors.
App\Entity\PaymentMethod	The association App\Entity\PaymentMethod#bookings refers to the owning side field App\Entity\Booking#paymentMethod which is not defined as association, but as field. The association App\Entity\PaymentMethod#bookings refers to the owning side field App\Entity\Booking#paymentMethod which does not exist.
App\Entity\NotificationUser	No errors.
App\Entity\Favori	No errors.
App\Entity\UserHistory	No errors.
App\Entity\FeedBack	No errors.
App\Entity\Ressource	No errors.
App\Entity\MaintenanceBuy	No errors.
App\Entity\Chat	No errors.
App\Entity\Message	No errors.
App\Entity\Support	No errors.
App\Entity\SupportResponse	No errors.
App\Entity\Subscription	No errors.
App\Entity\Request	No errors.
App\Entity\RequestPartnerCar	No errors.
App\Entity\CarExpense	No errors.
App\Entity\BookingPackage	No errors.
App\Entity\AuthorityRole	No errors.
App\Entity\RequestDiscount	No errors.
App\Entity\UserPoint	No errors.
App\Entity\BlackList	The mappings App\Entity\BlackList#createdBy and App\Entity\UserCompany#blackLists are inconsistent with each other.
App\Entity\Insurance	No errors.
App\Entity\VehicleLicense	No errors.
App\Entity\PaymentInstallment	The mappings App\Entity\PaymentInstallment#income and App\Entity\Income#paymentInstallments are inconsistent with each other.
App\Entity\Bank	No errors.
App\Entity\Violation	No errors.
App\Entity\Income	The mappings App\Entity\Income#incomeTranslates and App\Entity\IncomeTranslate#income are inconsistent with each other. The mappings App\Entity\Income#customer and App\Entity\UserCompany#incomes are inconsistent with each other. The field App\Entity\Income#bookingGuarantee is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Booking#incomeGuarantee does not contain the required 'inversedBy="bookingGuarantee"' attribute.
App\Entity\Expense	The field App\Entity\Expense#bookingGuarantee is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Booking#expenseGuarantee does not contain the required 'inversedBy="bookingGuarantee"' attribute.
App\Entity\CompanyCustomer	No errors.
App\Entity\CustomerDelivery	No errors.
App\Entity\UserTranslate	No errors.
App\Entity\CompanyTranslate	No errors.
App\Entity\BookingCar	No errors.
App\Entity\CompanySetting	No errors.
App\Entity\CompanyType	No errors.
App\Entity\Partner	The mappings App\Entity\Partner#companyPartner and App\Entity\Company#partners are inconsistent with each other. The mappings App\Entity\Partner#companyAgencyPartner and App\Entity\CompanyAgency#partners are inconsistent with each other.
App\Entity\Contract	No errors.
App\Entity\PartnerCar	No errors.
App\Entity\Terms	No errors.
App\Entity\CarOption	No errors.
App\Entity\Station	No errors.
App\Entity\Penalty	No errors.
App\Entity\BookingCharge	No errors.
App\Entity\LoyaltyCard	No errors.
App\Entity\Package	No errors.
App\Entity\LetterSetting	No errors.
App\Entity\LetterTo	No errors.
App\Entity\VatSetting	No errors.
App\Entity\ViolationType	The mappings App\Entity\ViolationType#violationTypeTranslates and App\Entity\ViolationTypeTranslate#violationType are inconsistent with each other.
App\Entity\ContractPackage	No errors.
App\Entity\CompanyUserOrganization	No errors.
App\Entity\TermsFullInsurance	No errors.
App\Entity\NotificationTemplateTranslate	No errors.
App\Entity\CompanyAgencyTranslate	The association App\Entity\CompanyAgencyTranslate#user refers to the inverse side field App\Entity\UserCompany#companyAgencyTranslate which does not exist.
App\Entity\City	No errors.
App\Entity\CountryTranslate	No errors.
App\Entity\BadgeTranslate	No errors.
App\Entity\UserOrganizationTranslate	No errors.
App\Entity\Language	The association App\Entity\Language#optionTranslates refers to the owning side field App\Entity\OptionTranslate#langauge which does not exist.
App\Entity\Option	No errors.
App\Entity\OptionValueTranslate	No errors.
App\Entity\BookingType	No errors.
App\Entity\ExtensionBooking	No errors.
App\Entity\BookingInstallment	No errors.
App\Entity\CarTranslate	No errors.
App\Entity\Model	No errors.
App\Entity\Image	No errors.
App\Entity\PurchaseType	No errors.
App\Entity\Installment	No errors.
App\Entity\CarProperty	No errors.
App\Entity\InsuranceType	No errors.
App\Entity\CarCategory	No errors.
App\Entity\RequestCar	No errors.
App\Entity\CarOptionPrice	The association App\Entity\CarOptionPrice#bookingCarOptions refers to the owning side field App\Entity\BookingCarOption#carOptionPrice which does not exist.
App\Entity\Version	No errors.
App\Entity\Wheel	No errors.
App\Entity\Funding	No errors.
App\Entity\Color	No errors.
App\Entity\CarType	No errors.
App\Entity\CarLevel	No errors.
App\Entity\Payment	No errors.
App\Entity\InvoiceInstallment	No errors.
App\Entity\MaintenanceTranslate	No errors.
App\Entity\MaintenanceType	No errors.
App\Entity\Check	The mappings App\Entity\Check#income and App\Entity\Income#checks are inconsistent with each other.
App\Entity\DamageTypeTranslate	No errors.
App\Entity\PaymentMethodTranslate	No errors.
App\Entity\Notification	No errors.
App\Entity\UserHistoryTranslate	No errors.
App\Entity\MaintenanceBuyTranslate	No errors.
App\Entity\Mark	No errors.
App\Entity\CarExpenseTranslate	No errors.
App\Entity\AuthorityAction	No errors.
App\Entity\AuthorityRoleTranslate	No errors.
App\Entity\BankTranslate	No errors.
App\Entity\IncomeTranslate	The association App\Entity\IncomeTranslate#income refers to the inverse side field App\Entity\Income#incometranslates which does not exist.
App\Entity\ExpenseTranslate	No errors.
App\Entity\ExpenseType	No errors.
App\Entity\CompanyCustomerTranslate	The association App\Entity\CompanyCustomerTranslate#language refers to the inverse side field App\Entity\Language#companyCustomerTranslates which does not exist.

Symfony Profiler

GET https://api-car.demo-projects.ifbegin.com/api/v1/car/position/last_vehicle_states?localeLang=ar&vehicle=

Configuration Settings

Theme