Symfony Profiler

Query Metrics

11 Database Queries

8 Different statements

30.19 ms Query time

0 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.64 ms
(41.88%)

SELECT COUNT(o0_.id) AS sclr_0 FROM offer o0_ LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id LEFT JOIN store s3_ ON s1_.store_id = s3_.id WHERE o0_.lw_send = ? AND s2_.code <> ? AND (s3_.id = ? OR s3_.id IS NULL)

Parameters:

[
  3
  "optical_partner"
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offer o0_
  LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id
  LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id
  LEFT JOIN store s3_ ON s1_.store_id = s3_.id
WHERE
  o0_.lw_send = ?
  AND s2_.code <> ?
  AND (
    s3_.id = ?
    OR s3_.id IS NULL
  )

SELECT COUNT(o0_.id) AS sclr_0 FROM offer o0_ LEFT JOIN sale_place s1_ ON o0_.sale_place_id = s1_.id LEFT JOIN sale_place_kind s2_ ON s1_.sale_place_kind_id = s2_.id LEFT JOIN store s3_ ON s1_.store_id = s3_.id WHERE o0_.lw_send = 3 AND s2_.code <> 'optical_partner' AND (s3_.id = 3 OR s3_.id IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Repository\OfferRepository->countByLwSendAndStore (line 203)
8	App\Controller\Admin\DashboardController->index (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

6.19 ms
(20.51%)

SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.tiss_id AS tiss_id_7, t0.lw_customer_id AS lw_customer_id_8, t0.lw_password AS lw_password_9, t0.is_lw_send AS is_lw_send_10, t0.is_remote_edging AS is_remote_edging_11, t0.is_lw_stock_lenses_enabled AS is_lw_stock_lenses_enabled_12, t0.lw_stock_lenses_test_remark AS lw_stock_lenses_test_remark_13, t0.erp_id AS erp_id_14, t0.sale_place_kind_id AS sale_place_kind_id_15, t0.store_id AS store_id_16, t17.id AS id_18, t17.sale_place_id AS sale_place_id_19 FROM sale_place t0 LEFT JOIN persefona_sale_place t17 ON t17.sale_place_id = t0.id INNER JOIN users_sale_places ON t0.id = users_sale_places.sale_place_id WHERE users_sale_places.user_id = ?

Parameters:

[
  533
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.is_active AS is_active_2,
  t0.code AS code_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.tiss_id AS tiss_id_7,
  t0.lw_customer_id AS lw_customer_id_8,
  t0.lw_password AS lw_password_9,
  t0.is_lw_send AS is_lw_send_10,
  t0.is_remote_edging AS is_remote_edging_11,
  t0.is_lw_stock_lenses_enabled AS is_lw_stock_lenses_enabled_12,
  t0.lw_stock_lenses_test_remark AS lw_stock_lenses_test_remark_13,
  t0.erp_id AS erp_id_14,
  t0.sale_place_kind_id AS sale_place_kind_id_15,
  t0.store_id AS store_id_16,
  t17.id AS id_18,
  t17.sale_place_id AS sale_place_id_19
FROM
  sale_place t0
  LEFT JOIN persefona_sale_place t17 ON t17.sale_place_id = t0.id
  INNER JOIN users_sale_places ON t0.id = users_sale_places.sale_place_id
WHERE
  users_sale_places.user_id = ?

SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.tiss_id AS tiss_id_7, t0.lw_customer_id AS lw_customer_id_8, t0.lw_password AS lw_password_9, t0.is_lw_send AS is_lw_send_10, t0.is_remote_edging AS is_remote_edging_11, t0.is_lw_stock_lenses_enabled AS is_lw_stock_lenses_enabled_12, t0.lw_stock_lenses_test_remark AS lw_stock_lenses_test_remark_13, t0.erp_id AS erp_id_14, t0.sale_place_kind_id AS sale_place_kind_id_15, t0.store_id AS store_id_16, t17.id AS id_18, t17.sale_place_id AS sale_place_id_19 FROM sale_place t0 LEFT JOIN persefona_sale_place t17 ON t17.sale_place_id = t0.id INNER JOIN users_sale_places ON t0.id = users_sale_places.sale_place_id WHERE users_sale_places.user_id = 533;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1065)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3322)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Manager\AdminScopeManager->getAllowedStores (line 65)
8	App\Manager\AdminScopeManager->getCurrentStore (line 86)
9	App\Controller\Admin\DashboardController->index (line 128)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

3.51 ms
(11.64%)

SELECT t0.email AS email_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_activity AS last_activity_6, t0.referral_code AS referral_code_7, t0.tiss_id AS tiss_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.erp_id AS erp_id_12, t0.is_active AS is_active_13 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "developer@kodano.pl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.last_activity AS last_activity_6,
  t0.referral_code AS referral_code_7,
  t0.tiss_id AS tiss_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.id AS id_11,
  t0.erp_id AS erp_id_12,
  t0.is_active AS is_active_13
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.email AS email_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_activity AS last_activity_6, t0.referral_code AS referral_code_7, t0.tiss_id AS tiss_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.erp_id AS erp_id_12, t0.is_active AS is_active_13 FROM user t0 WHERE t0.email = 'developer@kodano.pl' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
4	Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler->consumeRememberMeCookie (line 60)
5	Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler->consumeRememberMeCookie (line 64)
6	Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator->Symfony\Component\Security\Http\Authenticator\{closure} (line 105)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
31	require_once (line 32)
32	require_once (line 5)

2.06 ms
(6.81%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 480)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\EventSubscriber\UserActivitySubscriber->onKernelController (line 42)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

2.05 ms
(6.78%)

UPDATE user SET last_activity = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-10-16 12:06:05"
  "2026-10-16 12:06:05"
  533
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  last_activity = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET last_activity = '2026-10-16 12:06:05', updated_at = '2026-10-16 12:06:05' WHERE id = 533;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 536)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 422)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1283)
4	Doctrine\ORM\UnitOfWork->commit (line 456)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\EventSubscriber\UserActivitySubscriber->onKernelController (line 42)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 5)

1.81 ms
(5.99%)

SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM store t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.is_active AS is_active_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM store t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Store::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Store->__get (line 153)
7	App\Entity\Store->getCode (line 90)
8	App\Manager\StoreManager->getCachedStoreDto (line 45)
9	App\Manager\StoreManager->getCurrentStore (line 80)
10	App\EventListener\LocaleListener->onKernelRequest (line 34)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
19	require_once (line 32)
20	require_once (line 5)

1.60 ms
(5.28%)

SELECT t0.name AS name_1, t0.value AS value_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.store_id AS store_id_7 FROM config t0 WHERE t0.value = ? LIMIT 1

Parameters:

[
  "https://kodano-pl.stage.dionizos.szkkla.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.value AS value_2,
  t0.code AS code_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.store_id AS store_id_7
FROM
  config t0
WHERE
  t0.value = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.value AS value_2, t0.code AS code_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.store_id AS store_id_7 FROM config t0 WHERE t0.value = 'https://kodano-pl.stage.dionizos.szkkla.com' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Repository\ConfigRepository->getByValue (line 58)
4	App\Manager\CurrentStoreManager->getCurrentStoreEntity (line 51)
5	App\Manager\StoreManager->getCurrentStoreEntity (line 89)
6	App\Manager\StoreManager->getCurrentStore (line 80)
7	App\EventListener\LocaleListener->onKernelRequest (line 34)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
16	require_once (line 32)
17	require_once (line 5)

0.33 ms
(1.10%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 430)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\EventSubscriber\UserActivitySubscriber->onKernelController (line 42)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\SalePlace	5
App\Entity\Store	3
App\Entity\PersefonaSalePlace	3
App\Entity\Config	1
App\Entity\User	1
App\Entity\SalePlaceKind	1

Entities Mapping

Class	Mapping errors
App\Entity\Store	No errors.
App\Entity\Config	No errors.
App\Entity\Promotion	No errors.
App\Entity\Service	No errors.
App\Entity\AbstractDictionary	No errors.
App\Entity\SalePlace	No errors.
App\Entity\User	No errors.
App\Entity\Offer	No errors.
App\Entity\EyeExamination	No errors.
App\Entity\SalePlaceKind	No errors.
App\Entity\PersefonaSalePlace	No errors.

Symfony Profiler

GET https://kodano-pl.stage.dionizos.szkkla.com/wszechmogacy

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping