Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.16 ms Query time

10 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.13 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:

[
  "amer@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 = 'amer@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.86 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:

[
  131
]

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 (131) 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)

1.17 ms

SELECT t0.id AS id_1, t0.points AS points_2, t0.time_used AS time_used_3, t0.point_used AS point_used_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.customer_id AS customer_id_8, t0.company_id AS company_id_9 FROM user_point t0 WHERE t0.customer_id = ? AND t0.company_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "113"
  "53"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.points AS points_2,
  t0.time_used AS time_used_3,
  t0.point_used AS point_used_4,
  t0.deleted_at AS deleted_at_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.customer_id AS customer_id_8,
  t0.company_id AS company_id_9
FROM
  user_point t0
WHERE
  t0.customer_id = ?
  AND t0.company_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.points AS points_2, t0.time_used AS time_used_3, t0.point_used AS point_used_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.customer_id AS customer_id_8, t0.company_id AS company_id_9 FROM user_point t0 WHERE t0.customer_id = '113' AND t0.company_id = '53' 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 87)
5	App\Controller\Api\V1\UserPoint\UserPointApiController->listCustomer (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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.

Symfony Profiler

GET https://api.al-mooriyat.ifbegin.com/api/v1/userPoint/customer/bycompany?company=53&customer=113&localeLang=ar

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping