Symfony Profiler

Query Metrics

16 Database Queries

5 Different statements

5.33 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.05 ms
(76.10%)

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.started_at AS started_at_2, s0_.expires_at AS expires_at_3, s0_.created_at AS created_at_4, s1_.id AS id_5, s1_.name AS name_6, s1_.slug AS slug_7, s1_.description AS description_8, s1_.price AS price_9, s1_.currency AS currency_10, s1_.duration_days AS duration_days_11, s1_.is_trial AS is_trial_12, s1_.is_active AS is_active_13, s1_.created_at AS created_at_14, s0_.user_id AS user_id_15, s0_.plan_id AS plan_id_16 FROM subscription s0_ LEFT JOIN subscription_plan s1_ ON s0_.plan_id = s1_.id WHERE s0_.user_id = ? AND s0_.status = ? AND s0_.expires_at > ? ORDER BY s0_.expires_at DESC LIMIT 1

Parameters:

[
  2
  "active"
  "2026-09-25 05:05:45"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.status AS status_1,
  s0_.started_at AS started_at_2,
  s0_.expires_at AS expires_at_3,
  s0_.created_at AS created_at_4,
  s1_.id AS id_5,
  s1_.name AS name_6,
  s1_.slug AS slug_7,
  s1_.description AS description_8,
  s1_.price AS price_9,
  s1_.currency AS currency_10,
  s1_.duration_days AS duration_days_11,
  s1_.is_trial AS is_trial_12,
  s1_.is_active AS is_active_13,
  s1_.created_at AS created_at_14,
  s0_.user_id AS user_id_15,
  s0_.plan_id AS plan_id_16
FROM
  subscription s0_
  LEFT JOIN subscription_plan s1_ ON s0_.plan_id = s1_.id
WHERE
  s0_.user_id = ?
  AND s0_.status = ?
  AND s0_.expires_at > ?
ORDER BY
  s0_.expires_at DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.started_at AS started_at_2, s0_.expires_at AS expires_at_3, s0_.created_at AS created_at_4, s1_.id AS id_5, s1_.name AS name_6, s1_.slug AS slug_7, s1_.description AS description_8, s1_.price AS price_9, s1_.currency AS currency_10, s1_.duration_days AS duration_days_11, s1_.is_trial AS is_trial_12, s1_.is_active AS is_active_13, s1_.created_at AS created_at_14, s0_.user_id AS user_id_15, s0_.plan_id AS plan_id_16 FROM subscription s0_ LEFT JOIN subscription_plan s1_ ON s0_.plan_id = s1_.id WHERE s0_.user_id = 2 AND s0_.status = 'active' AND s0_.expires_at > '2026-09-25 05:05:45' ORDER BY s0_.expires_at DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\SubscriptionService->getActiveSubscription (line 36)
7	App\Service\SubscriptionService->hasActiveSubscription (line 46)
8	App\EventSubscriber\SubscriptionAccessSubscriber->onKernelRequest (line 68)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 208)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

0.40 ms
(7.57%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.country AS country_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  2
]

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.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.country AS country_8
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.country AS country_8 FROM user t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 233)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 134)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 73)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 40)
13	App\EventSubscriber\SubscriptionAccessSubscriber->onKernelRequest (line 60)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 208)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.37 ms
(7.04%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.phone AS phone_5, t0.whatsapp_number AS whatsapp_number_6, t0.country AS country_7, t0.city AS city_8, t0.currency AS currency_9, t0.logo AS logo_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.owner_id AS owner_id_13, t14.id AS id_15, t14.business_account_id AS business_account_id_16, t14.phone_number_id AS phone_number_id_17, t14.display_phone_number AS display_phone_number_18, t14.access_token AS access_token_19, t14.status AS status_20, t14.connected_at AS connected_at_21, t14.updated_at AS updated_at_22, t14.shop_id AS shop_id_23 FROM shop t0 LEFT JOIN whats_app_connection t14 ON t14.shop_id = t0.id WHERE t0.owner_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.phone AS phone_5,
  t0.whatsapp_number AS whatsapp_number_6,
  t0.country AS country_7,
  t0.city AS city_8,
  t0.currency AS currency_9,
  t0.logo AS logo_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.owner_id AS owner_id_13,
  t14.id AS id_15,
  t14.business_account_id AS business_account_id_16,
  t14.phone_number_id AS phone_number_id_17,
  t14.display_phone_number AS display_phone_number_18,
  t14.access_token AS access_token_19,
  t14.status AS status_20,
  t14.connected_at AS connected_at_21,
  t14.updated_at AS updated_at_22,
  t14.shop_id AS shop_id_23
FROM
  shop t0
  LEFT JOIN whats_app_connection t14 ON t14.shop_id = t0.id
WHERE
  t0.owner_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.phone AS phone_5, t0.whatsapp_number AS whatsapp_number_6, t0.country AS country_7, t0.city AS city_8, t0.currency AS currency_9, t0.logo AS logo_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.owner_id AS owner_id_13, t14.id AS id_15, t14.business_account_id AS business_account_id_16, t14.phone_number_id AS phone_number_id_17, t14.display_phone_number AS display_phone_number_18, t14.access_token AS access_token_19, t14.status AS status_20, t14.connected_at AS connected_at_21, t14.updated_at AS updated_at_22, t14.shop_id AS shop_id_23 FROM shop t0 LEFT JOIN whats_app_connection t14 ON t14.shop_id = t0.id WHERE t0.owner_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->first (line 169)
7	Doctrine\ORM\PersistentCollection->first (line 516)
8	App\Controller\WhatsAppController->index (line 27)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.25 ms
(4.71%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.started_at AS started_at_3, t0.expires_at AS expires_at_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.plan_id AS plan_id_7 FROM subscription t0 WHERE t0.user_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.started_at AS started_at_3,
  t0.expires_at AS expires_at_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.plan_id AS plan_id_7
FROM
  subscription t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.started_at AS started_at_3, t0.expires_at AS expires_at_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.plan_id AS plan_id_7 FROM subscription t0 WHERE t0.user_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	IteratorIterator->__construct (line 2004)
8	Twig\Extension\CoreExtension->filter (line 2004)
9	__TwigTemplate_419d94b7f1178f9fc622b6367dee9977::doDisplay (line 78)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_c85e6979a7687e66eb1616c4240ed23b->doDisplay (line 118)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_797f5f8a91d5ccdca26f6ae0515a3ec1->doDisplay (line 55)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\WhatsAppController->index (line 39)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.24 ms
(4.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.currency AS currency_6, t0.duration_days AS duration_days_7, t0.is_trial AS is_trial_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10 FROM subscription_plan t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.currency AS currency_6,
  t0.duration_days AS duration_days_7,
  t0.is_trial AS is_trial_8,
  t0.is_active AS is_active_9,
  t0.created_at AS created_at_10
FROM
  subscription_plan t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.currency AS currency_6, t0.duration_days AS duration_days_7, t0.is_trial AS is_trial_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10 FROM subscription_plan t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 339)
4	Proxies\__CG__\App\Entity\SubscriptionPlan::Doctrine\ORM\Proxy\{closure} (line 417)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\SubscriptionPlan->__get (line 184)
7	App\Entity\SubscriptionPlan->getName (line 64)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_419d94b7f1178f9fc622b6367dee9977::doDisplay (line 83)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_c85e6979a7687e66eb1616c4240ed23b->doDisplay (line 118)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_797f5f8a91d5ccdca26f6ae0515a3ec1->doDisplay (line 55)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\WhatsAppController->index (line 39)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Subscription	2
App\Entity\SubscriptionPlan	2
App\Entity\User	1
App\Entity\Shop	1
App\Entity\WhatsAppConnection	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Shop	No errors.
App\Entity\Subscription	No errors.
App\Entity\SubscriptionPlan	No errors.
App\Entity\WhatsAppConnection	No errors.
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Customer	No errors.
App\Entity\Conversation	No errors.
App\Entity\Order	No errors.

Symfony Profiler

GET https://kivogroup.store/whatsapp

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping