Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.63 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.35 ms
(37.16%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 431)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 49)
5	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.86 ms
(23.75%)

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.need_password_update AS need_password_update_4,
  t0.tryout AS tryout_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.image AS image_10,
  t0.theme AS theme_11,
  t0.status AS status_12,
  t0.last_login AS last_login_13,
  t0.last_activity AS last_activity_14,
  t0.note AS note_15,
  t0.acl AS acl_16,
  t0.widgets AS widgets_17,
  t0.preferences AS preferences_18,
  t0.notification AS notification_19,
  t0.id AS id_20,
  t0.uuid AS uuid_21,
  t0.company_id AS company_id_22
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = 17;

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

0.66 ms
(18.16%)

SELECT t0.image AS image_1, t0.siret_number AS siret_number_2, t0.vat_number AS vat_number_3, t0.model_letter AS model_letter_4, t0.is_default AS is_default_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.code AS code_8, t0.name AS name_9, t0.address AS address_10, t0.address2 AS address2_11, t0.postcode AS postcode_12, t0.city AS city_13, t0.phone AS phone_14, t0.status AS status_15, t0.country_id AS country_id_16 FROM company t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.image AS image_1,
  t0.siret_number AS siret_number_2,
  t0.vat_number AS vat_number_3,
  t0.model_letter AS model_letter_4,
  t0.is_default AS is_default_5,
  t0.id AS id_6,
  t0.uuid AS uuid_7,
  t0.code AS code_8,
  t0.name AS name_9,
  t0.address AS address_10,
  t0.address2 AS address2_11,
  t0.postcode AS postcode_12,
  t0.city AS city_13,
  t0.phone AS phone_14,
  t0.status AS status_15,
  t0.country_id AS country_id_16
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.image AS image_1, t0.siret_number AS siret_number_2, t0.vat_number AS vat_number_3, t0.model_letter AS model_letter_4, t0.is_default AS is_default_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.code AS code_8, t0.name AS name_9, t0.address AS address_10, t0.address2 AS address2_11, t0.postcode AS postcode_12, t0.city AS city_13, t0.phone AS phone_14, t0.status AS status_15, t0.country_id AS country_id_16 FROM company t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
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\Company::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Company->__get (line 115)
8	App\Entity\Company->getImage (line 70)
9	App\Twig\AppExtension->getUserAvatar (line 91)
10	__TwigTemplate_0f3c5658173680daff759260d4ddd997->doDisplay (line 402)
11	Twig\Template->yield (line 88)
12	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->block_layout (line 446)
13	Twig\Template->yieldBlock (line 105)
14	__TwigTemplate_286480bf3dd863a3201a52e2e759b0a2->doDisplay (line 402)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->doDisplay (line 402)
17	Twig\Template->yield (line 53)
18	__TwigTemplate_8e6472eb41fdaad1df677dff101aa938->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 32)
27	App\Controller\App\Admin\Import\ImportController->index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.53 ms
(14.65%)

UPDATE user SET last_activity = ? WHERE id = ?

Parameters:

[
  "2025-07-07 06:55:29"
  17
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  last_activity = ?
WHERE
  id = ?

UPDATE user SET last_activity = '2025-07-07 06:55:29' WHERE id = 17;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1130)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 406)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 49)
7	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.23 ms
(6.27%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 49)
4	App\EventSubscriber\User\UserSubscriber->onKernelController (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1
App\Entity\Company	1
App\Entity\Country	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Product\Offer	No errors.
App\Entity\Product\FavouriteOffer	No errors.
App\Entity\Offer\OfferProposal	No errors.
App\Entity\Offer\OfferUserConsult	No errors.
App\Entity\Country	No errors.
App\Entity\Property\Property	No errors.
App\Entity\Sales\Transactions	No errors.

Symfony Profiler

GET https://app103.fr/app/admin/feed-import/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping