Symfony Profiler

Query Metrics

14 Database Queries

7 Different statements

10.19 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

5.83 ms
(57.27%)

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:

[
  "g6skmhc48taatqd5fa880c6erk"
]

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 = 'g6skmhc48taatqd5fa880c6erk' 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 27)
11	App\Controller\CartController->index (line 183)
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)

1.36 ms
(13.37%)

"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 27)
8	App\Controller\CartController->index (line 183)
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.76 ms
(7.50%)

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:

[
  1773
]

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 = 1773 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 27)
10	App\Controller\CartController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.63 ms
(6.16%)

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:

[
  1773
]

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 = 1773 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 27)
10	App\Controller\CartController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.30 ms
(2.90%)

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

Parameters:

[
  "g6skmhc48taatqd5fa880c6erk"
  "2026-04-07 02:28:20"
  "2026-04-07 02:28:20"
  "2026-05-07 02:28:20"
  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 ('g6skmhc48taatqd5fa880c6erk', '2026-04-07 02:28:20', '2026-04-07 02:28:20', '2026-05-07 02:28:20', 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 27)
10	App\Controller\CartController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.14 ms
(1.33%)

"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 27)
7	App\Controller\CartController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

pim connection

Time▼	Count	Info
1.17 ms (11.47%)	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

1.17 ms
(11.47%)

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;

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

default connection

pim connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping