Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

5.42 ms Query time

1 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.03 ms
(37.54%)

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.expires_at AS expires_at_4, c0_.user_id AS user_id_5 FROM carts c0_ WHERE c0_.session_id = ? AND c0_.user_id IS NULL

Parameters:

[
  "qc1su3jctv3u9s2gu242o90bv9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.expires_at AS expires_at_4,
  c0_.user_id AS user_id_5
FROM
  carts c0_
WHERE
  c0_.session_id = ?
  AND c0_.user_id IS NULL

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.expires_at AS expires_at_4, c0_.user_id AS user_id_5 FROM carts c0_ WHERE c0_.session_id = 'qc1su3jctv3u9s2gu242o90bv9' AND c0_.user_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 42)
7	App\Repository\CartRepository->findBySessionId (line 67)
8	App\Repository\CartRepository->findOrCreateForSession (line 56)
9	App\Service\CartService->getCurrentCart (line 293)
10	App\Service\CartService->getCartData (line 275)
11	App\Controller\CartController->widget (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
15	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
16	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
17	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
18	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 48)
19	__TwigTemplate_c44a37a1e5d0933f2e23db5eb2d9947b->doDisplay (line 402)
20	Twig\Template->yield (line 162)
21	__TwigTemplate_c4c87d78c0127b274944a4f4f614e971->doDisplay (line 402)
22	Twig\Template->yield (line 111)
23	__TwigTemplate_34fd3289a18aa6d52931cffb8db25349->doDisplay (line 402)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_94d17a8ae09a4eab125ca6799074f93d->doDisplay (line 402)
26	Twig\Template->yield (line 358)
27	Twig\Template->display (line 373)
28	Twig\Template->render (line 51)
29	Twig\TemplateWrapper->render (line 333)
30	Twig\Environment->render (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 198)
34	App\Controller\SecurityController->forgotPassword (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

1.52 ms
(28.03%)

"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 78)
5	App\Repository\CartRepository->findOrCreateForSession (line 56)
6	App\Service\CartService->getCurrentCart (line 293)
7	App\Service\CartService->getCartData (line 275)
8	App\Controller\CartController->widget (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 48)
16	__TwigTemplate_c44a37a1e5d0933f2e23db5eb2d9947b->doDisplay (line 402)
17	Twig\Template->yield (line 162)
18	__TwigTemplate_c4c87d78c0127b274944a4f4f614e971->doDisplay (line 402)
19	Twig\Template->yield (line 111)
20	__TwigTemplate_34fd3289a18aa6d52931cffb8db25349->doDisplay (line 402)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_94d17a8ae09a4eab125ca6799074f93d->doDisplay (line 402)
23	Twig\Template->yield (line 358)
24	Twig\Template->display (line 373)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 333)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 198)
31	App\Controller\SecurityController->forgotPassword (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.49 ms
(9.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.seo_data AS seo_data_6, t0.is_active AS is_active_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM universes t0 WHERE t0.is_active = ? ORDER BY t0.sort_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.seo_data AS seo_data_6,
  t0.is_active AS is_active_7,
  t0.sort_order AS sort_order_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  universes t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.seo_data AS seo_data_6, t0.is_active AS is_active_7, t0.sort_order AS sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM universes t0 WHERE t0.is_active = 1 ORDER BY t0.sort_order ASC;

#	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 18)
5	App\Twig\UniverseExtension->getGlobals (line 359)
6	Twig\ExtensionSet->getGlobals (line 900)
7	Twig\Environment->getGlobals (line 398)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 198)
16	App\Controller\SecurityController->forgotPassword (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.38 ms
(7.03%)

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.unit_price AS unit_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.dolibarr_id AS dolibarr_id_6, p1_.ref AS ref_7, p1_.label AS label_8, p1_.slug AS slug_9, p1_.description AS description_10, p1_.long_description AS long_description_11, p1_.price AS price_12, p1_.public_price AS public_price_13, p1_.stock AS stock_14, p1_.low_stock_threshold AS low_stock_threshold_15, p1_.weight AS weight_16, p1_.dimensions AS dimensions_17, p1_.main_image AS main_image_18, p1_.secondary_images AS secondary_images_19, p1_.documents AS documents_20, p1_.is_active AS is_active_21, p1_.is_featured AS is_featured_22, p1_.seo_data AS seo_data_23, p1_.status AS status_24, p1_.created_at AS created_at_25, p1_.updated_at AS updated_at_26, p1_.last_sync_at AS last_sync_at_27, c0_.cart_id AS cart_id_28, c0_.product_id AS product_id_29, p1_.category_id AS category_id_30, p1_.universe_id AS universe_id_31 FROM cart_items c0_ LEFT JOIN products p1_ ON c0_.product_id = p1_.id WHERE c0_.cart_id = ? ORDER BY c0_.created_at ASC

Parameters:

[
  826
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.quantity AS quantity_1,
  c0_.unit_price AS unit_price_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  p1_.id AS id_5,
  p1_.dolibarr_id AS dolibarr_id_6,
  p1_.ref AS ref_7,
  p1_.label AS label_8,
  p1_.slug AS slug_9,
  p1_.description AS description_10,
  p1_.long_description AS long_description_11,
  p1_.price AS price_12,
  p1_.public_price AS public_price_13,
  p1_.stock AS stock_14,
  p1_.low_stock_threshold AS low_stock_threshold_15,
  p1_.weight AS weight_16,
  p1_.dimensions AS dimensions_17,
  p1_.main_image AS main_image_18,
  p1_.secondary_images AS secondary_images_19,
  p1_.documents AS documents_20,
  p1_.is_active AS is_active_21,
  p1_.is_featured AS is_featured_22,
  p1_.seo_data AS seo_data_23,
  p1_.status AS status_24,
  p1_.created_at AS created_at_25,
  p1_.updated_at AS updated_at_26,
  p1_.last_sync_at AS last_sync_at_27,
  c0_.cart_id AS cart_id_28,
  c0_.product_id AS product_id_29,
  p1_.category_id AS category_id_30,
  p1_.universe_id AS universe_id_31
FROM
  cart_items c0_
  LEFT JOIN products p1_ ON c0_.product_id = p1_.id
WHERE
  c0_.cart_id = ?
ORDER BY
  c0_.created_at ASC

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.unit_price AS unit_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.dolibarr_id AS dolibarr_id_6, p1_.ref AS ref_7, p1_.label AS label_8, p1_.slug AS slug_9, p1_.description AS description_10, p1_.long_description AS long_description_11, p1_.price AS price_12, p1_.public_price AS public_price_13, p1_.stock AS stock_14, p1_.low_stock_threshold AS low_stock_threshold_15, p1_.weight AS weight_16, p1_.dimensions AS dimensions_17, p1_.main_image AS main_image_18, p1_.secondary_images AS secondary_images_19, p1_.documents AS documents_20, p1_.is_active AS is_active_21, p1_.is_featured AS is_featured_22, p1_.seo_data AS seo_data_23, p1_.status AS status_24, p1_.created_at AS created_at_25, p1_.updated_at AS updated_at_26, p1_.last_sync_at AS last_sync_at_27, c0_.cart_id AS cart_id_28, c0_.product_id AS product_id_29, p1_.category_id AS category_id_30, p1_.universe_id AS universe_id_31 FROM cart_items c0_ LEFT JOIN products p1_ ON c0_.product_id = p1_.id WHERE c0_.cart_id = 826 ORDER BY c0_.created_at ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 47)
7	App\Repository\CartItemRepository->findByCartWithProducts (line 181)
8	App\Service\CartService->getCartItems (line 294)
9	App\Service\CartService->getCartData (line 275)
10	App\Controller\CartController->widget (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 48)
18	__TwigTemplate_c44a37a1e5d0933f2e23db5eb2d9947b->doDisplay (line 402)
19	Twig\Template->yield (line 162)
20	__TwigTemplate_c4c87d78c0127b274944a4f4f614e971->doDisplay (line 402)
21	Twig\Template->yield (line 111)
22	__TwigTemplate_34fd3289a18aa6d52931cffb8db25349->doDisplay (line 402)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_94d17a8ae09a4eab125ca6799074f93d->doDisplay (line 402)
25	Twig\Template->yield (line 358)
26	Twig\Template->display (line 373)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 333)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 198)
33	App\Controller\SecurityController->forgotPassword (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.37 ms
(6.79%)

INSERT INTO carts (session_id, created_at, updated_at, expires_at, user_id) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "qc1su3jctv3u9s2gu242o90bv9"
  "2025-12-07 00:33:33"
  "2025-12-07 00:33:33"
  "2026-01-06 00:33:33"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO carts (
  session_id, created_at, updated_at,
  expires_at, user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO carts (session_id, created_at, updated_at, expires_at, user_id) VALUES ('qc1su3jctv3u9s2gu242o90bv9', '2025-12-07 00:33:33', '2025-12-07 00:33:33', '2026-01-06 00:33:33', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1052)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 401)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 78)
7	App\Repository\CartRepository->findOrCreateForSession (line 56)
8	App\Service\CartService->getCurrentCart (line 293)
9	App\Service\CartService->getCartData (line 275)
10	App\Controller\CartController->widget (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 48)
18	__TwigTemplate_c44a37a1e5d0933f2e23db5eb2d9947b->doDisplay (line 402)
19	Twig\Template->yield (line 162)
20	__TwigTemplate_c4c87d78c0127b274944a4f4f614e971->doDisplay (line 402)
21	Twig\Template->yield (line 111)
22	__TwigTemplate_34fd3289a18aa6d52931cffb8db25349->doDisplay (line 402)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_94d17a8ae09a4eab125ca6799074f93d->doDisplay (line 402)
25	Twig\Template->yield (line 358)
26	Twig\Template->display (line 373)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 333)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 198)
33	App\Controller\SecurityController->forgotPassword (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.33 ms
(6.11%)

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.unit_price AS unit_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.dolibarr_id AS dolibarr_id_6, p1_.ref AS ref_7, p1_.label AS label_8, p1_.slug AS slug_9, p1_.description AS description_10, p1_.long_description AS long_description_11, p1_.price AS price_12, p1_.public_price AS public_price_13, p1_.stock AS stock_14, p1_.low_stock_threshold AS low_stock_threshold_15, p1_.weight AS weight_16, p1_.dimensions AS dimensions_17, p1_.main_image AS main_image_18, p1_.secondary_images AS secondary_images_19, p1_.documents AS documents_20, p1_.is_active AS is_active_21, p1_.is_featured AS is_featured_22, p1_.seo_data AS seo_data_23, p1_.status AS status_24, p1_.created_at AS created_at_25, p1_.updated_at AS updated_at_26, p1_.last_sync_at AS last_sync_at_27, c0_.cart_id AS cart_id_28, c0_.product_id AS product_id_29, p1_.category_id AS category_id_30, p1_.universe_id AS universe_id_31 FROM cart_items c0_ LEFT JOIN products p1_ ON c0_.product_id = p1_.id WHERE c0_.cart_id = ? AND c0_.unit_price <> p1_.price

Parameters:

[
  826
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.quantity AS quantity_1,
  c0_.unit_price AS unit_price_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  p1_.id AS id_5,
  p1_.dolibarr_id AS dolibarr_id_6,
  p1_.ref AS ref_7,
  p1_.label AS label_8,
  p1_.slug AS slug_9,
  p1_.description AS description_10,
  p1_.long_description AS long_description_11,
  p1_.price AS price_12,
  p1_.public_price AS public_price_13,
  p1_.stock AS stock_14,
  p1_.low_stock_threshold AS low_stock_threshold_15,
  p1_.weight AS weight_16,
  p1_.dimensions AS dimensions_17,
  p1_.main_image AS main_image_18,
  p1_.secondary_images AS secondary_images_19,
  p1_.documents AS documents_20,
  p1_.is_active AS is_active_21,
  p1_.is_featured AS is_featured_22,
  p1_.seo_data AS seo_data_23,
  p1_.status AS status_24,
  p1_.created_at AS created_at_25,
  p1_.updated_at AS updated_at_26,
  p1_.last_sync_at AS last_sync_at_27,
  c0_.cart_id AS cart_id_28,
  c0_.product_id AS product_id_29,
  p1_.category_id AS category_id_30,
  p1_.universe_id AS universe_id_31
FROM
  cart_items c0_
  LEFT JOIN products p1_ ON c0_.product_id = p1_.id
WHERE
  c0_.cart_id = ?
  AND c0_.unit_price <> p1_.price

SELECT c0_.id AS id_0, c0_.quantity AS quantity_1, c0_.unit_price AS unit_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.dolibarr_id AS dolibarr_id_6, p1_.ref AS ref_7, p1_.label AS label_8, p1_.slug AS slug_9, p1_.description AS description_10, p1_.long_description AS long_description_11, p1_.price AS price_12, p1_.public_price AS public_price_13, p1_.stock AS stock_14, p1_.low_stock_threshold AS low_stock_threshold_15, p1_.weight AS weight_16, p1_.dimensions AS dimensions_17, p1_.main_image AS main_image_18, p1_.secondary_images AS secondary_images_19, p1_.documents AS documents_20, p1_.is_active AS is_active_21, p1_.is_featured AS is_featured_22, p1_.seo_data AS seo_data_23, p1_.status AS status_24, p1_.created_at AS created_at_25, p1_.updated_at AS updated_at_26, p1_.last_sync_at AS last_sync_at_27, c0_.cart_id AS cart_id_28, c0_.product_id AS product_id_29, p1_.category_id AS category_id_30, p1_.universe_id AS universe_id_31 FROM cart_items c0_ LEFT JOIN products p1_ ON c0_.product_id = p1_.id WHERE c0_.cart_id = 826 AND c0_.unit_price <> p1_.price;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 91)
7	App\Repository\CartItemRepository->findItemsWithOutdatedPrices (line 275)
8	App\Service\CartService->hasOutdatedPrices (line 320)
9	App\Service\CartService->getCartData (line 275)
10	App\Controller\CartController->widget (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 48)
18	__TwigTemplate_c44a37a1e5d0933f2e23db5eb2d9947b->doDisplay (line 402)
19	Twig\Template->yield (line 162)
20	__TwigTemplate_c4c87d78c0127b274944a4f4f614e971->doDisplay (line 402)
21	Twig\Template->yield (line 111)
22	__TwigTemplate_34fd3289a18aa6d52931cffb8db25349->doDisplay (line 402)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_94d17a8ae09a4eab125ca6799074f93d->doDisplay (line 402)
25	Twig\Template->yield (line 358)
26	Twig\Template->display (line 373)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 333)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 198)
33	App\Controller\SecurityController->forgotPassword (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.30 ms
(5.48%)

"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 78)
4	App\Repository\CartRepository->findOrCreateForSession (line 56)
5	App\Service\CartService->getCurrentCart (line 293)
6	App\Service\CartService->getCartData (line 275)
7	App\Controller\CartController->widget (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 48)
15	__TwigTemplate_c44a37a1e5d0933f2e23db5eb2d9947b->doDisplay (line 402)
16	Twig\Template->yield (line 162)
17	__TwigTemplate_c4c87d78c0127b274944a4f4f614e971->doDisplay (line 402)
18	Twig\Template->yield (line 111)
19	__TwigTemplate_34fd3289a18aa6d52931cffb8db25349->doDisplay (line 402)
20	Twig\Template->yield (line 54)
21	__TwigTemplate_94d17a8ae09a4eab125ca6799074f93d->doDisplay (line 402)
22	Twig\Template->yield (line 358)
23	Twig\Template->display (line 373)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 333)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 198)
30	App\Controller\SecurityController->forgotPassword (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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\Universe	5
App\Entity\Cart	1

Entities Mapping

Class	Mapping errors
App\Entity\Universe	No errors.
App\Entity\UniverseCharacteristic	No errors.
App\Entity\Product	No errors.
App\Entity\Cart	No errors.
App\Entity\User	The field App\Entity\User#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#user does not contain the required 'inversedBy="orders"' attribute.
App\Entity\CartItem	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://dev.precision-tools.fr/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCartController%253A%253Awidget

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping