Symfony Profiler

Query Metrics

11 Database Queries

9 Different statements

9.29 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

pim connection

Time▼	Count	Info
2.59 ms (27.89%)	1	SELECT p., u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true ORDER BY p.created_at DESC LIMIT ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT p., u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true ORDER BY p.created_at DESC LIMIT ? SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true ORDER BY p.created_at DESC LIMIT 8;
0.71 ms (7.64%)	1	SELECT u., COUNT(p.id) as product_count FROM universe u LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true WHERE u.is_active = true GROUP BY u.id ORDER BY u.sort_order ASC, u.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT u., COUNT(p.id) as product_count FROM universe u LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true WHERE u.is_active = true GROUP BY u.id ORDER BY u.sort_order ASC, u.name ASC SELECT u.*, COUNT(p.id) as product_count FROM universe u LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true WHERE u.is_active = true GROUP BY u.id ORDER BY u.sort_order ASC, u.name ASC;
0.23 ms (2.45%)	1	SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC;

Time▼

Count

Info

2.59 ms
(27.89%)

SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true
    ORDER BY p.created_at DESC
    LIMIT ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query

SELECT
  p.*,
  u.name as universe_name,
  u.slug as universe_slug,
  m.name as manufacturer_name,
  m.code as manufacturer_code
FROM
  product p
  LEFT JOIN universe u ON p.universe_id = u.id
  LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
WHERE
  p.is_active = true
ORDER BY
  p.created_at DESC
LIMIT
  ?

SELECT p.*,
           u.name as universe_name,
           u.slug as universe_slug,
           m.name as manufacturer_name,
           m.code as manufacturer_code
    FROM product p
    LEFT JOIN universe u ON p.universe_id = u.id
    LEFT JOIN manufacturer m ON p.manufacturer_id = m.id
    WHERE p.is_active = true
    ORDER BY p.created_at DESC
    LIMIT 8;

0.71 ms
(7.64%)

SELECT u.*, COUNT(p.id) as product_count
    FROM universe u
    LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true
    WHERE u.is_active = true
    GROUP BY u.id
    ORDER BY u.sort_order ASC, u.name ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  u.*,
  COUNT(p.id) as product_count
FROM
  universe u
  LEFT JOIN product p ON p.universe_id = u.id
  AND p.is_active = true
WHERE
  u.is_active = true
GROUP BY
  u.id
ORDER BY
  u.sort_order ASC,
  u.name ASC

SELECT u.*, COUNT(p.id) as product_count
    FROM universe u
    LEFT JOIN product p ON p.universe_id = u.id AND p.is_active = true
    WHERE u.is_active = true
    GROUP BY u.id
    ORDER BY u.sort_order ASC, u.name ASC;

0.23 ms
(2.45%)

SELECT u.*
    FROM universe u
    WHERE u.is_active = true
    ORDER BY u.sort_order ASC, u.name ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  u.*
FROM
  universe u
WHERE
  u.is_active = true
ORDER BY
  u.sort_order ASC,
  u.name ASC

SELECT u.*
    FROM universe u
    WHERE u.is_active = true
    ORDER BY u.sort_order ASC, u.name ASC;

default connection

Time▼

Count

Info

2.62 ms
(28.19%)

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:

[
  "tvb9aenhhb5qejjtdm1lvj1452"
]

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 = 'tvb9aenhhb5qejjtdm1lvj1452' 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 55)
25	__TwigTemplate_55cb085bdbd557eaf566014e0ceac4cb->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 50)
34	App\Controller\HomeController->index (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.88 ms
(20.21%)

"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 55)
22	__TwigTemplate_55cb085bdbd557eaf566014e0ceac4cb->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 50)
31	App\Controller\HomeController->index (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.53 ms
(5.72%)

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:

[
  1229
]

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 = 1229 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 55)
24	__TwigTemplate_55cb085bdbd557eaf566014e0ceac4cb->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 50)
33	App\Controller\HomeController->index (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.31 ms
(3.36%)

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

Parameters:

[
  "tvb9aenhhb5qejjtdm1lvj1452"
  "2026-02-05 06:42:16"
  "2026-02-05 06:42:16"
  "2026-03-07 06:42:16"
  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 ('tvb9aenhhb5qejjtdm1lvj1452', '2026-02-05 06:42:16', '2026-02-05 06:42:16', '2026-03-07 06:42:16', 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 55)
24	__TwigTemplate_55cb085bdbd557eaf566014e0ceac4cb->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 50)
33	App\Controller\HomeController->index (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
(3.18%)

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:

[
  1229
]

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 = 1229 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 55)
24	__TwigTemplate_55cb085bdbd557eaf566014e0ceac4cb->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 50)
33	App\Controller\HomeController->index (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.13 ms
(1.37%)

"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 55)
21	__TwigTemplate_55cb085bdbd557eaf566014e0ceac4cb->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 50)
30	App\Controller\HomeController->index (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
pim	doctrine.dbal.pim_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\Cart	1

Entities Mapping

Class	Mapping 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\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Universe	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

pim connection

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping