Symfony Profiler

Query Metrics

44 Database Queries

11 Different statements

16.55 ms Query time

0 Invalid entities

44 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.74 ms
(22.58%)

SELECT t0.id AS id_1, t0.src AS src_2, t0.position AS position_3, t0.active AS active_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6, t0.blog_id AS blog_id_7 FROM image t0 WHERE t0.product_id = ?

Parameters:

[
  256
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.src AS src_2,
  t0.position AS position_3,
  t0.active AS active_4,
  t0.product_id AS product_id_5,
  t0.category_id AS category_id_6,
  t0.blog_id AS blog_id_7
FROM
  image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.src AS src_2, t0.position AS position_3, t0.active AS active_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6, t0.blog_id AS blog_id_7 FROM image t0 WHERE t0.product_id = 256;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 59)
10	__TwigTemplate_d759bef74ac35a7e90c70a9b0e21de9d->doDisplay (line 388)
11	Twig\Template->yield (line 84)
12	__TwigTemplate_bca6a9bf073e568f4c5112f73c3f1f65->doDisplay (line 388)
13	Twig\Template->yield (line 107)
14	__TwigTemplate_6238f0bea83f08290378d8963149525d->block_body (line 432)
15	Twig\Template->yieldBlock (line 96)
16	__TwigTemplate_f603705c015bc1551b4231b723d50592->doDisplay (line 388)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_6238f0bea83f08290378d8963149525d->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
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 34)
27	App\Controller\MainController->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)

3.36 ms
(20.29%)

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = ?

Parameters:

[
  256
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 256;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 63)
12	App\Repository\ProductRepository->findFeaturedProducts (line 26)
13	App\Service\ProductService->App\Service\{closure} (line 111)
14	Symfony\Component\Cache\LockRegistry::compute (line 102)
15	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
16	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
17	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
18	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 22)
19	App\Service\ProductService->getFeaturedProducts (line 37)
20	App\Controller\MainController->index (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

3.33 ms
(20.10%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = ?

Parameters:

[
  256
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 256;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 63)
12	App\Repository\ProductRepository->findFeaturedProducts (line 26)
13	App\Service\ProductService->App\Service\{closure} (line 111)
14	Symfony\Component\Cache\LockRegistry::compute (line 102)
15	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
16	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
17	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
18	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 22)
19	App\Service\ProductService->getFeaturedProducts (line 37)
20	App\Controller\MainController->index (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

2.22 ms
(13.41%)

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN cart_line c2_ ON (c2_.product_id = p0_.id) LEFT JOIN `cart` c3_ ON c2_.cart_id = c3_.id LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c3_.status = ? AND p0_.visibility = ? AND p0_.category_id IS NOT NULL GROUP BY p0_.id ORDER BY COUNT(c2_.id) DESC LIMIT 8

Parameters:

[
  "STATUS_VALIDE"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.common_name AS common_name_1,
  p0_.slug AS slug_2,
  p0_.latin_name AS latin_name_3,
  p0_.visibility AS visibility_4,
  p0_.average_purchase_price AS average_purchase_price_5,
  p0_.selling_price_ht AS selling_price_ht_6,
  p0_.selling_price_ttc AS selling_price_ttc_7,
  p0_.margin_rate AS margin_rate_8,
  p0_.is_active AS is_active_9,
  p0_.description AS description_10,
  p0_.short_description AS short_description_11,
  p0_.composed AS composed_12,
  p0_.created_at AS created_at_13,
  p0_.image AS image_14,
  p0_.reference AS reference_15,
  c1_.id AS id_16,
  c1_.name AS name_17,
  c1_.slug AS slug_18,
  c1_.position AS position_19,
  c1_.visible AS visible_20,
  c1_.margin_rate AS margin_rate_21,
  c1_.description AS description_22,
  p0_.vat_id AS vat_id_23,
  p0_.category_id AS category_id_24,
  p0_.product_variation_origin_id AS product_variation_origin_id_25,
  c1_.parent_id AS parent_id_26
FROM
  product p0_
  LEFT JOIN cart_line c2_ ON (c2_.product_id = p0_.id)
  LEFT JOIN `cart` c3_ ON c2_.cart_id = c3_.id
  LEFT JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  c3_.status = ?
  AND p0_.visibility = ?
  AND p0_.category_id IS NOT NULL
GROUP BY
  p0_.id
ORDER BY
  COUNT(c2_.id) DESC
LIMIT
  8

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN cart_line c2_ ON (c2_.product_id = p0_.id) LEFT JOIN `cart` c3_ ON c2_.cart_id = c3_.id LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c3_.status = 'STATUS_VALIDE' AND p0_.visibility = 1 AND p0_.category_id IS NOT NULL GROUP BY p0_.id ORDER BY COUNT(c2_.id) DESC LIMIT 8;

#	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 83)
7	App\Repository\ProductRepository->findBestSellers (line 49)
8	App\Service\ProductService->App\Service\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 45)
14	App\Service\ProductService->getBestOrdersProducts (line 38)
15	App\Controller\MainController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.15 ms
(6.93%)

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.is_active = ? AND p0_.visibility = ? AND p0_.category_id IS NOT NULL ORDER BY p0_.created_at DESC LIMIT 4

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.common_name AS common_name_1,
  p0_.slug AS slug_2,
  p0_.latin_name AS latin_name_3,
  p0_.visibility AS visibility_4,
  p0_.average_purchase_price AS average_purchase_price_5,
  p0_.selling_price_ht AS selling_price_ht_6,
  p0_.selling_price_ttc AS selling_price_ttc_7,
  p0_.margin_rate AS margin_rate_8,
  p0_.is_active AS is_active_9,
  p0_.description AS description_10,
  p0_.short_description AS short_description_11,
  p0_.composed AS composed_12,
  p0_.created_at AS created_at_13,
  p0_.image AS image_14,
  p0_.reference AS reference_15,
  c1_.id AS id_16,
  c1_.name AS name_17,
  c1_.slug AS slug_18,
  c1_.position AS position_19,
  c1_.visible AS visible_20,
  c1_.margin_rate AS margin_rate_21,
  c1_.description AS description_22,
  p0_.vat_id AS vat_id_23,
  p0_.category_id AS category_id_24,
  p0_.product_variation_origin_id AS product_variation_origin_id_25,
  c1_.parent_id AS parent_id_26
FROM
  product p0_
  LEFT JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  p0_.is_active = ?
  AND p0_.visibility = ?
  AND p0_.category_id IS NOT NULL
ORDER BY
  p0_.created_at DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.is_active = 1 AND p0_.visibility = 1 AND p0_.category_id IS NOT NULL ORDER BY p0_.created_at DESC LIMIT 4;

#	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 63)
7	App\Repository\ProductRepository->findFeaturedProducts (line 26)
8	App\Service\ProductService->App\Service\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 22)
14	App\Service\ProductService->getFeaturedProducts (line 37)
15	App\Controller\MainController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.74 ms
(4.47%)

INSERT INTO statistic (ip, date, user_agent, request_uri, referer, user_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "66.249.77.225"
  "2025-06-07 04:33:19"
  "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.7103.113 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
  "/"
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO statistic (
  ip, date, user_agent, request_uri,
  referer, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO statistic (ip, date, user_agent, request_uri, referer, user_id) VALUES ('66.249.77.225', '2025-06-07 04:33:19', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.7103.113 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', '/', NULL, 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 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 24)
7	App\Repository\StatisticRepository->add (line 43)
8	App\EventListener\VisitorAgentSubscriber->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.61 ms
(3.70%)

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.common_name AS common_name_1,
  p0_.slug AS slug_2,
  p0_.latin_name AS latin_name_3,
  p0_.visibility AS visibility_4,
  p0_.average_purchase_price AS average_purchase_price_5,
  p0_.selling_price_ht AS selling_price_ht_6,
  p0_.selling_price_ttc AS selling_price_ttc_7,
  p0_.margin_rate AS margin_rate_8,
  p0_.is_active AS is_active_9,
  p0_.description AS description_10,
  p0_.short_description AS short_description_11,
  p0_.composed AS composed_12,
  p0_.created_at AS created_at_13,
  p0_.image AS image_14,
  p0_.reference AS reference_15,
  c1_.id AS id_16,
  c1_.name AS name_17,
  c1_.slug AS slug_18,
  c1_.position AS position_19,
  c1_.visible AS visible_20,
  c1_.margin_rate AS margin_rate_21,
  c1_.description AS description_22,
  p0_.vat_id AS vat_id_23,
  p0_.category_id AS category_id_24,
  p0_.product_variation_origin_id AS product_variation_origin_id_25,
  c1_.parent_id AS parent_id_26
FROM
  product p0_
  LEFT JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.id IN (18, 123, 26, 238, 19, 85, 127, 136);

#	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 118)
7	App\Repository\ProductRepository->findBestSellers (line 49)
8	App\Service\ProductService->App\Service\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 45)
14	App\Service\ProductService->getBestOrdersProducts (line 38)
15	App\Controller\MainController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.52 ms
(3.12%)

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visibility = ? AND p0_.category_id IS NOT NULL

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.visibility = ?
  AND p0_.category_id IS NOT NULL

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visibility = 1 AND p0_.category_id IS NOT 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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 103)
7	App\Repository\ProductRepository->findBestSellers (line 49)
8	App\Service\ProductService->App\Service\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 102)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 45)
14	App\Service\ProductService->getBestOrdersProducts (line 38)
15	App\Controller\MainController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.44 ms
(2.68%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.content AS content_4, t0.votes AS votes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.status AS status_8, t0.slug AS slug_9, t0.category_id AS category_id_10 FROM blog_article t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.content AS content_4,
  t0.votes AS votes_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.status AS status_8,
  t0.slug AS slug_9,
  t0.category_id AS category_id_10
FROM
  blog_article t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.content AS content_4, t0.votes AS votes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.status AS status_8, t0.slug AS slug_9, t0.category_id AS category_id_10 FROM blog_article 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 39)
6	App\Controller\MainController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.24 ms
(1.43%)

"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 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 24)
4	App\Repository\StatisticRepository->add (line 43)
5	App\EventListener\VisitorAgentSubscriber->onKernelRequest (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 159)
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.21 ms
(1.29%)

"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 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 24)
5	App\Repository\StatisticRepository->add (line 43)
6	App\EventListener\VisitorAgentSubscriber->onKernelRequest (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
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)

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	12
App\Entity\Stock	10
App\Entity\Category	6
App\Entity\Image	6
App\Entity\BlogArticle	5
App\Entity\Vat	2
App\Entity\BlogCategory	2
App\Entity\Statistic	1

Entities Mapping

Class	Mapping errors
App\Entity\Statistic	No errors.
App\Entity\User	No errors.
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Vat	No errors.
App\Entity\Image	No errors.
App\Entity\ProductFeature	No errors.
App\Entity\CartLine	No errors.
App\Entity\Stock	No errors.
App\Entity\SupplierOrderLine	No errors.
App\Entity\LogPrices	No errors.
App\Entity\ProductComposed	No errors.
App\Entity\Cart	No errors.
App\Entity\BlogArticle	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\BlogComment	No errors.
App\Entity\BlogTag	No errors.

Symfony Profiler

GET https://dunefleur-alautre.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping