Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

4.81 ms Query time

1 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.02 ms
(62.84%)

"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 479)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Manager\Setting\SettingManager->updateSetting (line 35)
5	App\Service\Setting\SettingService->updateSettingSubFolder (line 42)
6	App\Service\FileUpload\UploadFileService->updateCurrentSubFolder (line 143)
7	App\Service\FileUpload\UploadFileService->subFolder (line 114)
8	App\Service\FileUpload\UploadFileService->uploadFile (line 41)
9	App\Controller\FileUpload\FileUploadController->fileUpload (line 61)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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.73 ms
(15.24%)

SELECT t0.id AS id_1, t0.upload_sub_folder AS upload_sub_folder_2, t0.updated_at AS updated_at_3, t0.sms AS sms_4, t0.send_order_to_external_party AS send_order_to_external_party_5 FROM setting_entity t0 ORDER BY t0.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.upload_sub_folder AS upload_sub_folder_2,
  t0.updated_at AS updated_at_3,
  t0.sms AS sms_4,
  t0.send_order_to_external_party AS send_order_to_external_party_5
FROM
  setting_entity t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.upload_sub_folder AS upload_sub_folder_2, t0.updated_at AS updated_at_3, t0.sms AS sms_4, t0.send_order_to_external_party AS send_order_to_external_party_5 FROM setting_entity t0 ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Manager\Setting\SettingManager->fetchSetting (line 27)
4	App\Service\Setting\SettingService->updateSettingSubFolder (line 33)
5	App\Service\FileUpload\UploadFileService->updateCurrentSubFolder (line 143)
6	App\Service\FileUpload\UploadFileService->subFolder (line 114)
7	App\Service\FileUpload\UploadFileService->uploadFile (line 41)
8	App\Controller\FileUpload\FileUploadController->fileUpload (line 61)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.46 ms
(9.56%)

UPDATE setting_entity SET upload_sub_folder = ? WHERE id = ?

Parameters:

[
  "2025-12-17_11-25-11"
  1
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  setting_entity
SET
  upload_sub_folder = ?
WHERE
  id = ?

UPDATE setting_entity SET upload_sub_folder = '2025-12-17_11-25-11' WHERE id = 1;

#	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 1282)
4	Doctrine\ORM\UnitOfWork->commit (line 455)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Manager\Setting\SettingManager->updateSetting (line 35)
7	App\Service\Setting\SettingService->updateSettingSubFolder (line 42)
8	App\Service\FileUpload\UploadFileService->updateCurrentSubFolder (line 143)
9	App\Service\FileUpload\UploadFileService->subFolder (line 114)
10	App\Service\FileUpload\UploadFileService->uploadFile (line 41)
11	App\Controller\FileUpload\FileUploadController->fileUpload (line 61)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.44 ms
(9.19%)

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.roles AS roles_3, t0.password AS password_4, t0.verification_status AS verification_status_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM user_entity t0 WHERE t0.user_id = ? LIMIT 1

Parameters:

[
  "966590269517"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.verification_status AS verification_status_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  user_entity t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.roles AS roles_3, t0.password AS password_4, t0.verification_status AS verification_status_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM user_entity t0 WHERE t0.user_id = '966590269517' 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 54)
4	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 105)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 87)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
19	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
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 122)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.15 ms
(3.18%)

"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 429)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Manager\Setting\SettingManager->updateSetting (line 35)
4	App\Service\Setting\SettingService->updateSettingSubFolder (line 42)
5	App\Service\FileUpload\UploadFileService->updateCurrentSubFolder (line 143)
6	App\Service\FileUpload\UploadFileService->subFolder (line 114)
7	App\Service\FileUpload\UploadFileService->uploadFile (line 41)
8	App\Controller\FileUpload\FileUploadController->fileUpload (line 61)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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\UserEntity	1
App\Entity\SettingEntity	1

Entities Mapping

Class	Mapping errors
App\Entity\UserEntity	No errors.
App\Entity\RateEntity	The mappings App\Entity\RateEntity#rated and App\Entity\UserEntity#rateEntities are inconsistent with each other.
App\Entity\VerificationEntity	No errors.
App\Entity\ResetPasswordOrderEntity	No errors.
App\Entity\NotificationFirebaseTokenEntity	No errors.
App\Entity\SettingEntity	No errors.

Symfony Profiler

POST https://prod-api.callme4d.com/uploadfile

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping