Symfony Profiler

Query Metrics

19 Database Queries

11 Different statements

8.55 ms Query time

0 Invalid entities

878 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.19 ms
(25.63%)

SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.volume AS volume_1,
  t0.is_default AS is_default_2,
  t0.offer_sort AS offer_sort_3,
  t0.id AS id_4,
  t0.uuid AS uuid_5,
  t0.code AS code_6,
  t0.name AS name_7,
  t0.name_en AS name_en_8,
  t0.status AS status_9,
  t0.regex AS regex_10
FROM
  product_format t0

SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 57)
6	App\Service\Import\Common\Common->getAllFormats (line 25)
7	App\Service\Import\Parser\PackagingParser->__construct (line 29)
8	ContainerR5Vl0KB\getPackagingParserService::do (line 665)
9	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 59)
10	ContainerR5Vl0KB\getImportParserServiceService::do (line 665)
11	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 38)
12	ContainerR5Vl0KB\getOfferFormService::ContainerR5Vl0KB\{closure} (line 46)
13	ContainerR5Vl0KB\getOfferFormService::do (line 665)
14	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 405)
15	Symfony\Component\DependencyInjection\Container->getService (line 36)
16	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
17	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
18	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
19	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 77)
20	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->block_content (line 446)
21	Twig\Template->yieldBlock (line 118)
22	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->block_layout (line 446)
23	Twig\Template->yieldBlock (line 105)
24	__TwigTemplate_286480bf3dd863a3201a52e2e759b0a2->doDisplay (line 402)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->doDisplay (line 402)
27	Twig\Template->yield (line 53)
28	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
37	App\Controller\App\Offer\ImportController->index (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.99 ms
(11.56%)

SELECT t0.value AS value_1, t0.last_update AS last_update_2, t0.id AS id_3, t0.code AS code_4 FROM currency t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.value AS value_1,
  t0.last_update AS last_update_2,
  t0.id AS id_3,
  t0.code AS code_4
FROM
  currency t0

SELECT t0.value AS value_1, t0.last_update AS last_update_2, t0.id AS id_3, t0.code AS code_4 FROM currency t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 59)
6	App\Service\Currency\CurrencyService->getAllCurrencies (line 761)
7	App\Service\Import\ImportParserService->_getAllCurrencies (line 209)
8	App\Service\Import\ImportParserService->__construct (line 70)
9	ContainerR5Vl0KB\getImportParserServiceService::do (line 665)
10	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 38)
11	ContainerR5Vl0KB\getOfferFormService::ContainerR5Vl0KB\{closure} (line 46)
12	ContainerR5Vl0KB\getOfferFormService::do (line 665)
13	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 405)
14	Symfony\Component\DependencyInjection\Container->getService (line 36)
15	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
16	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 77)
19	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->block_content (line 446)
20	Twig\Template->yieldBlock (line 118)
21	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->block_layout (line 446)
22	Twig\Template->yieldBlock (line 105)
23	__TwigTemplate_286480bf3dd863a3201a52e2e759b0a2->doDisplay (line 402)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->doDisplay (line 402)
26	Twig\Template->yield (line 53)
27	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->doDisplay (line 402)
28	Twig\Template->yield (line 358)
29	Twig\Template->display (line 373)
30	Twig\Template->render (line 51)
31	Twig\TemplateWrapper->render (line 333)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
36	App\Controller\App\Offer\ImportController->index (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

0.96 ms
(11.26%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.status AS status_4 FROM product_appellation t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.status AS status_4
FROM
  product_appellation t0

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.status AS status_4 FROM product_appellation t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 577)
6	App\Service\Import\ImportParserService->_getAllAppelations (line 213)
7	App\Service\Import\ImportParserService->__construct (line 70)
8	ContainerR5Vl0KB\getImportParserServiceService::do (line 665)
9	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 38)
10	ContainerR5Vl0KB\getOfferFormService::ContainerR5Vl0KB\{closure} (line 46)
11	ContainerR5Vl0KB\getOfferFormService::do (line 665)
12	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 405)
13	Symfony\Component\DependencyInjection\Container->getService (line 36)
14	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
15	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 77)
18	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->block_content (line 446)
19	Twig\Template->yieldBlock (line 118)
20	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->block_layout (line 446)
21	Twig\Template->yieldBlock (line 105)
22	__TwigTemplate_286480bf3dd863a3201a52e2e759b0a2->doDisplay (line 402)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->doDisplay (line 402)
25	Twig\Template->yield (line 53)
26	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 333)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
35	App\Controller\App\Offer\ImportController->index (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

0.91 ms
(10.68%)

"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.88 ms
(10.31%)

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:

[
  20
]

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 = 20;

#	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.61 ms
(7.11%)

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_aa2eeafe2976cadadf6cf5e9d408ac5f->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 51)
27	App\Controller\App\Offer\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.52 ms
(6.13%)

SELECT t0.qty AS qty_1, t0.is_default AS is_default_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.code AS code_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.position AS position_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_packaging t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.qty AS qty_1,
  t0.is_default AS is_default_2,
  t0.id AS id_3,
  t0.uuid AS uuid_4,
  t0.code AS code_5,
  t0.name AS name_6,
  t0.name_en AS name_en_7,
  t0.position AS position_8,
  t0.status AS status_9,
  t0.regex AS regex_10
FROM
  product_packaging t0

SELECT t0.qty AS qty_1, t0.is_default AS is_default_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.code AS code_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.position AS position_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_packaging t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 218)
6	App\Service\Import\Common\Common->getAllPackaging (line 34)
7	App\Service\Import\Parser\PackagingParser->__construct (line 29)
8	ContainerR5Vl0KB\getPackagingParserService::do (line 665)
9	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 59)
10	ContainerR5Vl0KB\getImportParserServiceService::do (line 665)
11	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 38)
12	ContainerR5Vl0KB\getOfferFormService::ContainerR5Vl0KB\{closure} (line 46)
13	ContainerR5Vl0KB\getOfferFormService::do (line 665)
14	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 405)
15	Symfony\Component\DependencyInjection\Container->getService (line 36)
16	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
17	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
18	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
19	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 77)
20	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->block_content (line 446)
21	Twig\Template->yieldBlock (line 118)
22	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->block_layout (line 446)
23	Twig\Template->yieldBlock (line 105)
24	__TwigTemplate_286480bf3dd863a3201a52e2e759b0a2->doDisplay (line 402)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->doDisplay (line 402)
27	Twig\Template->yield (line 53)
28	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
37	App\Controller\App\Offer\ImportController->index (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.46 ms
(5.39%)

UPDATE user SET last_activity = ? WHERE id = ?

Parameters:

[
  "2025-07-07 09:15:06"
  20
]

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 09:15:06' WHERE id = 20;

#	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.46 ms
(5.34%)

SELECT t0.is_default AS is_default_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.position AS position_4, t0.old_id AS old_id_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.code AS code_8, t0.status AS status_9 FROM product_color t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.is_default AS is_default_1,
  t0.id AS id_2,
  t0.uuid AS uuid_3,
  t0.position AS position_4,
  t0.old_id AS old_id_5,
  t0.name AS name_6,
  t0.name_en AS name_en_7,
  t0.code AS code_8,
  t0.status AS status_9
FROM
  product_color t0

SELECT t0.is_default AS is_default_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.position AS position_4, t0.old_id AS old_id_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.code AS code_8, t0.status AS status_9 FROM product_color t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 173)
6	App\Service\Import\Common\Common->getAllColors (line 26)
7	App\Service\Import\Parser\PackagingParser->__construct (line 29)
8	ContainerR5Vl0KB\getPackagingParserService::do (line 665)
9	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 59)
10	ContainerR5Vl0KB\getImportParserServiceService::do (line 665)
11	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 38)
12	ContainerR5Vl0KB\getOfferFormService::ContainerR5Vl0KB\{closure} (line 46)
13	ContainerR5Vl0KB\getOfferFormService::do (line 665)
14	ContainerR5Vl0KB\App_KernelDevDebugContainer->load (line 405)
15	Symfony\Component\DependencyInjection\Container->getService (line 36)
16	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
17	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
18	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
19	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 77)
20	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->block_content (line 446)
21	Twig\Template->yieldBlock (line 118)
22	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->block_layout (line 446)
23	Twig\Template->yieldBlock (line 105)
24	__TwigTemplate_286480bf3dd863a3201a52e2e759b0a2->doDisplay (line 402)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_7d2d6a8ede16dd2c65b2907c1184b844->doDisplay (line 402)
27	Twig\Template->yield (line 53)
28	__TwigTemplate_aa2eeafe2976cadadf6cf5e9d408ac5f->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
37	App\Controller\App\Offer\ImportController->index (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.39 ms
(4.50%)

SELECT t0.type AS type_1, t0.is_full AS is_full_2, t0.files_datas AS files_datas_3, t0.duration AS duration_4, t0.items AS items_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.entity_id AS entity_id_8 FROM import_prepare t0 WHERE t0.uuid IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.type AS type_1,
  t0.is_full AS is_full_2,
  t0.files_datas AS files_datas_3,
  t0.duration AS duration_4,
  t0.items AS items_5,
  t0.id AS id_6,
  t0.uuid AS uuid_7,
  t0.entity_id AS entity_id_8
FROM
  import_prepare t0
WHERE
  t0.uuid IS NULL
LIMIT
  1

SELECT t0.type AS type_1, t0.is_full AS is_full_2, t0.files_datas AS files_datas_3, t0.duration AS duration_4, t0.items AS items_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.entity_id AS entity_id_8 FROM import_prepare t0 WHERE t0.uuid IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
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)

0.18 ms
(2.09%)

"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\Product\Appellation	486
App\Entity\Currency	341
App\Entity\Product\Format	27
App\Entity\Product\Packaging	15
App\Entity\Product\Color	6
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\Import\ImportPrepare	No errors.
App\Entity\Property\Property	No errors.
App\Entity\Country	No errors.
App\Entity\Sales\Transactions	No errors.
App\Entity\Product\Format	No errors.
App\Entity\Product\Color	No errors.
App\Entity\Product\Packaging	No errors.
App\Entity\Currency	No errors.
App\Entity\Product\Appellation	No errors.
App\Entity\Product\Product	No errors.

Symfony Profiler

GET https://app103.fr/app/offer-import/import

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping