Symfony Profiler

Query Metrics

46 Database Queries

7 Different statements

29.74 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.62 ms
(35.73%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.category AS category_5 FROM pos_feature t0 WHERE t0.id = ?

Parameters:

[
  32
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.category AS category_5
FROM
  pos_feature t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.category AS category_5 FROM pos_feature t0 WHERE t0.id = 32;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\PosFeature::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\PosFeature->__get (line 63)
8	App\Entity\PosFeature->getCode (line 144)
9	App\Controller\Api\FeatureController->getPointOfSaleFeatures (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

6.11 ms
(20.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone_number AS phone_number_4, t0.address AS address_5, t0.email AS email_6, t0.country AS country_7, t0.city AS city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.business_id AS business_id_11 FROM point_of_sale t0 WHERE t0.id = ?

Parameters:

[
  54
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.phone_number AS phone_number_4,
  t0.address AS address_5,
  t0.email AS email_6,
  t0.country AS country_7,
  t0.city AS city_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.business_id AS business_id_11
FROM
  point_of_sale t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone_number AS phone_number_4, t0.address AS address_5, t0.email AS email_6, t0.country AS country_7, t0.city AS city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.business_id AS business_id_11 FROM point_of_sale t0 WHERE t0.id = 54;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 107)
7	App\Controller\Api\FeatureController->getPointOfSaleFeatures (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

4.52 ms
(15.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone_number AS phone_number_4, t0.email AS email_5, t0.logo AS logo_6, t0.description_activity_sector AS description_activity_sector_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10, t0.activity_sector_id AS activity_sector_id_11 FROM business t0 WHERE t0.id = ?

Parameters:

[
  75
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.phone_number AS phone_number_4,
  t0.email AS email_5,
  t0.logo AS logo_6,
  t0.description_activity_sector AS description_activity_sector_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10,
  t0.activity_sector_id AS activity_sector_id_11
FROM
  business t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone_number AS phone_number_4, t0.email AS email_5, t0.logo AS logo_6, t0.description_activity_sector AS description_activity_sector_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10, t0.activity_sector_id AS activity_sector_id_11 FROM business t0 WHERE t0.id = 75;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Business::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Business->__get (line 206)
8	App\Entity\Business->getUser (line 114)
9	App\Controller\Api\FeatureController->getPointOfSaleFeatures (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

3.16 ms
(10.61%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.profil AS profil_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.business_name AS business_name_9, t0.phone_number AS phone_number_10, t0.status_subscription AS status_subscription_11, t0.selected_sale_types AS selected_sale_types_12, t0.reset_token AS reset_token_13, t0.reset_token_expires_at AS reset_token_expires_at_14, t0.is_verified AS is_verified_15, t0.verification_token AS verification_token_16, t0.verification_token_expires_at AS verification_token_expires_at_17, t0.rccm AS rccm_18, t0.identity_document_of_manager AS identity_document_of_manager_19, t0.proof_of_domiciliation AS proof_of_domiciliation_20, t0.address AS address_21, t0.trial_start_date AS trial_start_date_22, t0.parent_id AS parent_id_23, t0.business_type_id AS business_type_id_24 FROM user t0 WHERE t0.id = ?

Parameters:

[
  78
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.profil AS profil_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.business_name AS business_name_9,
  t0.phone_number AS phone_number_10,
  t0.status_subscription AS status_subscription_11,
  t0.selected_sale_types AS selected_sale_types_12,
  t0.reset_token AS reset_token_13,
  t0.reset_token_expires_at AS reset_token_expires_at_14,
  t0.is_verified AS is_verified_15,
  t0.verification_token AS verification_token_16,
  t0.verification_token_expires_at AS verification_token_expires_at_17,
  t0.rccm AS rccm_18,
  t0.identity_document_of_manager AS identity_document_of_manager_19,
  t0.proof_of_domiciliation AS proof_of_domiciliation_20,
  t0.address AS address_21,
  t0.trial_start_date AS trial_start_date_22,
  t0.parent_id AS parent_id_23,
  t0.business_type_id AS business_type_id_24
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.profil AS profil_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.business_name AS business_name_9, t0.phone_number AS phone_number_10, t0.status_subscription AS status_subscription_11, t0.selected_sale_types AS selected_sale_types_12, t0.reset_token AS reset_token_13, t0.reset_token_expires_at AS reset_token_expires_at_14, t0.is_verified AS is_verified_15, t0.verification_token AS verification_token_16, t0.verification_token_expires_at AS verification_token_expires_at_17, t0.rccm AS rccm_18, t0.identity_document_of_manager AS identity_document_of_manager_19, t0.proof_of_domiciliation AS proof_of_domiciliation_20, t0.address AS address_21, t0.trial_start_date AS trial_start_date_22, t0.parent_id AS parent_id_23, t0.business_type_id AS business_type_id_24 FROM user t0 WHERE t0.id = 78;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\User->__get (line 641)
8	App\Entity\User->isTrialActive (line 660)
9	App\Entity\User->hasActiveSubscription (line 18)
10	App\Service\SubscriptionChecker->hasAccess (line 121)
11	App\Controller\Api\FeatureController->getPointOfSaleFeatures (line 178)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

2.20 ms
(7.39%)

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7, t0.pricing_plan_id AS pricing_plan_id_8 FROM subscription t0 WHERE t0.user_id = ?

Parameters:

[
  78
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.user_id AS user_id_7,
  t0.pricing_plan_id AS pricing_plan_id_8
FROM
  subscription t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7, t0.pricing_plan_id AS pricing_plan_id_8 FROM subscription t0 WHERE t0.user_id = 78;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 664)
8	App\Entity\User->hasActiveSubscription (line 18)
9	App\Service\SubscriptionChecker->hasAccess (line 121)
10	App\Controller\Api\FeatureController->getPointOfSaleFeatures (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.93 ms
(6.50%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.price_per_month AS price_per_month_3, t0.price_per_year AS price_per_year_4, t0.type_subscription AS type_subscription_5 FROM pricing_plan t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price_per_month AS price_per_month_3,
  t0.price_per_year AS price_per_year_4,
  t0.type_subscription AS type_subscription_5
FROM
  pricing_plan t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price_per_month AS price_per_month_3, t0.price_per_year AS price_per_year_4, t0.type_subscription AS type_subscription_5 FROM pricing_plan t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\PricingPlan::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\PricingPlan->__get (line 105)
8	App\Entity\PricingPlan->getFeatures (line 140)
9	App\Controller\Api\FeatureController->getPointOfSaleFeatures (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.20 ms
(4.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.pricing_id AS pricing_id_4, t0.pos_feature_id AS pos_feature_id_5 FROM feature t0 WHERE t0.pricing_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.pricing_id AS pricing_id_4,
  t0.pos_feature_id AS pos_feature_id_5
FROM
  feature t0
WHERE
  t0.pricing_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.pricing_id AS pricing_id_4, t0.pos_feature_id AS pos_feature_id_5 FROM feature t0 WHERE t0.pricing_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 140)
8	App\Controller\Api\FeatureController->getPointOfSaleFeatures (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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
App\Entity\PointOfSale	No errors.
App\Entity\Business	No errors.
App\Entity\User	No errors.
App\Entity\ActivitySector	No errors.
App\Entity\BusinessType	No errors.
App\Entity\Subscription	No errors.
App\Entity\Payment	No errors.
App\Entity\PricingPlan	No errors.
App\Entity\Feature	No errors.
App\Entity\PosFeature	No errors.

Symfony Profiler

GET http://dev-connect.binn.pro/api/point-of-sale/54/features

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping