Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

29.47 ms Query time

2 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.66 ms
(63.31%)

SELECT DISTINCT date_apply, sum(sales_amount) as total_sales, sum(transaction_count) as total_transactions 
            FROM store_hourly_transaction
            WHERE DAYOFWEEK(date_apply) = ?
            AND store_id = ?
            GROUP by date_apply
            ORDER BY date_apply DESC
            LIMIT 6

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT date_apply,
  sum(sales_amount) as total_sales,
  sum(transaction_count) as total_transactions
FROM
  store_hourly_transaction
WHERE
  DAYOFWEEK(date_apply) = ?
  AND store_id = ?
GROUP by
  date_apply
ORDER BY
  date_apply DESC
LIMIT
  6

SELECT DISTINCT date_apply, sum(sales_amount) as total_sales, sum(transaction_count) as total_transactions 
            FROM store_hourly_transaction
            WHERE DAYOFWEEK(date_apply) = 4
            AND store_id = 3
            GROUP by date_apply
            ORDER BY date_apply DESC
            LIMIT 6
        ;

#	File/Call
1	App\Controller\StoreController->getSalesAndTransactionData (line 305)
2	App\Controller\StoreController->scheduleData (line 453)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 182)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 29)
8	require_once (line 5)

7.94 ms
(26.95%)

SELECT date_apply, hour, sales_amount, transaction_count
            FROM store_hourly_transaction
            WHERE date_apply in (?,?,?,?,?,?)
            AND store_id = ?

Parameters:

[
  "2025-12-03"
  "2025-11-26"
  "2025-11-19"
  "2025-11-12"
  "2025-11-05"
  "2025-10-29"
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  date_apply,
  hour,
  sales_amount,
  transaction_count
FROM
  store_hourly_transaction
WHERE
  date_apply in (?, ?, ?, ?, ?, ?)
  AND store_id = ?

SELECT date_apply, hour, sales_amount, transaction_count
            FROM store_hourly_transaction
            WHERE date_apply in ('2025-12-03','2025-11-26','2025-11-19','2025-11-12','2025-11-05','2025-10-29')
            AND store_id = 3
        ;

#	File/Call
1	App\Controller\StoreController->getSalesAndTransactionData (line 344)
2	App\Controller\StoreController->scheduleData (line 453)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 182)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 29)
8	require_once (line 5)

0.75 ms
(2.54%)

SELECT t0.id AS id_1, t0.date_apply AS date_apply_2, t0.employee_rows AS employee_rows_3, t0.manager_rows AS manager_rows_4, t0.projected_sales AS projected_sales_5, t0.percentage_multiplier AS percentage_multiplier_6, t0.is_final AS is_final_7, t0.store_hour_start AS store_hour_start_8, t0.store_hour_end AS store_hour_end_9, t0.store_id AS store_id_10 FROM store_schedule t0 WHERE t0.store_id = ? AND t0.date_apply = ? LIMIT 1

Parameters:

[
  3
  "2025-12-17"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_apply AS date_apply_2,
  t0.employee_rows AS employee_rows_3,
  t0.manager_rows AS manager_rows_4,
  t0.projected_sales AS projected_sales_5,
  t0.percentage_multiplier AS percentage_multiplier_6,
  t0.is_final AS is_final_7,
  t0.store_hour_start AS store_hour_start_8,
  t0.store_hour_end AS store_hour_end_9,
  t0.store_id AS store_id_10
FROM
  store_schedule t0
WHERE
  t0.store_id = ?
  AND t0.date_apply = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_apply AS date_apply_2, t0.employee_rows AS employee_rows_3, t0.manager_rows AS manager_rows_4, t0.projected_sales AS projected_sales_5, t0.percentage_multiplier AS percentage_multiplier_6, t0.is_final AS is_final_7, t0.store_hour_start AS store_hour_start_8, t0.store_hour_end AS store_hour_end_9, t0.store_id AS store_id_10 FROM store_schedule t0 WHERE t0.store_id = 3 AND t0.date_apply = '2025-12-17' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Controller\StoreController->scheduleData (line 459)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.59 ms
(2.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.address AS address_4, t0.store_type_id AS store_type_id_5, t0.asset_type_id AS asset_type_id_6 FROM store 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.code AS code_3,
  t0.address AS address_4,
  t0.store_type_id AS store_type_id_5,
  t0.asset_type_id AS asset_type_id_6
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.address AS address_4, t0.store_type_id AS store_type_id_5, t0.asset_type_id AS asset_type_id_6 FROM store t0 WHERE t0.id = '3';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
9	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.52 ms
(1.77%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.acl_attributes AS acl_attributes_4 FROM app_role t0 INNER JOIN app_user_role ON t0.id = app_user_role.role_id WHERE app_user_role.user_id = ?

Parameters:

[
  18
]

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.acl_attributes AS acl_attributes_4
FROM
  app_role t0
  INNER JOIN app_user_role ON t0.id = app_user_role.role_id
WHERE
  app_user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.acl_attributes AS acl_attributes_4 FROM app_role t0 INNER JOIN app_user_role ON t0.id = app_user_role.role_id WHERE app_user_role.user_id = 18;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	Kinetic\AuthBundle\Entity\User->getRoles (line 103)
8	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 318)
9	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 217)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.51 ms
(1.75%)

SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.contact_number AS contact_number_3, t0.email AS email_4, t0.flag_email_verified AS flag_email_verified_5, t0.date_create AS date_create_6, t0.metadata AS metadata_7, t0.api_key AS api_key_8, t0.secret_key AS secret_key_9, t0.id AS id_10, t0.username AS username_11, t0.password AS password_12, t0.flag_enabled AS flag_enabled_13 FROM app_user t0 WHERE t0.id = ?

Parameters:

[
  18
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.first_name AS first_name_1,
  t0.last_name AS last_name_2,
  t0.contact_number AS contact_number_3,
  t0.email AS email_4,
  t0.flag_email_verified AS flag_email_verified_5,
  t0.date_create AS date_create_6,
  t0.metadata AS metadata_7,
  t0.api_key AS api_key_8,
  t0.secret_key AS secret_key_9,
  t0.id AS id_10,
  t0.username AS username_11,
  t0.password AS password_12,
  t0.flag_enabled AS flag_enabled_13
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.contact_number AS contact_number_3, t0.email AS email_4, t0.flag_email_verified AS flag_email_verified_5, t0.date_create AS date_create_6, t0.metadata AS metadata_7, t0.api_key AS api_key_8, t0.secret_key AS secret_key_9, t0.id AS id_10, t0.username AS username_11, t0.password AS password_12, t0.flag_enabled AS flag_enabled_13 FROM app_user t0 WHERE t0.id = 18;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.49 ms
(1.68%)

SELECT t0.id AS id_1, t0.year AS year_2, t0.jan AS jan_3, t0.feb AS feb_4, t0.mar AS mar_5, t0.apr AS apr_6, t0.may AS may_7, t0.jun AS jun_8, t0.jul AS jul_9, t0.aug AS aug_10, t0.sep AS sep_11, t0.oct AS oct_12, t0.nov AS nov_13, t0.`dec` AS dec_14, t0.store_id AS store_id_15 FROM store_peculiarity t0 WHERE t0.store_id = ? AND t0.year = ? LIMIT 1

Parameters:

[
  3
  "2025"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.jan AS jan_3,
  t0.feb AS feb_4,
  t0.mar AS mar_5,
  t0.apr AS apr_6,
  t0.may AS may_7,
  t0.jun AS jun_8,
  t0.jul AS jul_9,
  t0.aug AS aug_10,
  t0.sep AS sep_11,
  t0.oct AS oct_12,
  t0.nov AS nov_13,
  t0.`dec` AS dec_14,
  t0.store_id AS store_id_15
FROM
  store_peculiarity t0
WHERE
  t0.store_id = ?
  AND t0.year = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.year AS year_2, t0.jan AS jan_3, t0.feb AS feb_4, t0.mar AS mar_5, t0.apr AS apr_6, t0.may AS may_7, t0.jun AS jun_8, t0.jul AS jul_9, t0.aug AS aug_10, t0.sep AS sep_11, t0.oct AS oct_12, t0.nov AS nov_13, t0.`dec` AS dec_14, t0.store_id AS store_id_15 FROM store_peculiarity t0 WHERE t0.store_id = 3 AND t0.year = '2025' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Controller\StoreController->getPeculiarity (line 419)
4	App\Controller\StoreController->scheduleData (line 481)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1
App\Entity\Role	1
App\Entity\Store	1
App\Entity\StoreType	1
App\Entity\AssetType	1
App\Entity\StoreSchedule	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Role	No errors.
App\Entity\Store	The association App\Entity\Store#storeType refers to the inverse side field App\Entity\StoreType#store which does not exist.
App\Entity\StoreType	The mappings App\Entity\StoreType#stores and App\Entity\Store#storeType are inconsistent with each other.
App\Entity\AssetType	No errors.
App\Entity\Employee	No errors.
App\Entity\StoreSchedule	No errors.
App\Entity\StorePeculiarity	No errors.

Symfony Profiler

GET https://scheduler.wildcard.dev/stores/3/schedule/2025-12-17

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping