Symfony Profiler

Query Metrics

93 Database Queries

7 Different statements

49.23 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

23.08 ms
(46.88%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = ?

Parameters:

[
  94
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.parent_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = 94;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 115)
8	__TwigTemplate_faf3810bae4eb9e7c624d835fa22a0b9->doDisplay (line 360)
9	Twig\Template->yield (line 203)
10	__TwigTemplate_ee6f99a8291fc7069da36c98e7dbe67b->block_header (line 430)
11	Twig\Template->yieldBlock (line 139)
12	__TwigTemplate_ee6f99a8291fc7069da36c98e7dbe67b->block_body (line 430)
13	Twig\Template->yieldBlock (line 76)
14	__TwigTemplate_ee6f99a8291fc7069da36c98e7dbe67b->doDisplay (line 360)
15	Twig\Template->yield (line 52)
16	__TwigTemplate_bfc366619682b7058dd8d743bace1a85->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 299)
20	Twig\Environment->render (line 242)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 164)
23	App\Controller\PagesController->indexWomen (line 163)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

19.28 ms
(39.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.composition AS composition_4, t0.quantity AS quantity_5, t0.weight AS weight_6, t0.main_image AS main_image_7, t0.price AS price_8, t0.retail_price AS retail_price_9, t0.description AS description_10, t0.ean AS ean_11, t0.slug AS slug_12, t0.stripe_id AS stripe_id_13, t0.color AS color_14, t0.images AS images_15, t0.promotion_rate AS promotion_rate_16, t0.profit_margin AS profit_margin_17, t0.stripe_obj_id AS stripe_obj_id_18, t0.api_last_updated AS api_last_updated_19, t0.selling_price AS selling_price_20, t0.api_id AS api_id_21, t0.media_path AS media_path_22, t0.product_id AS product_id_23 FROM product_variant t0 WHERE t0.product_id = ?

Parameters:

[
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.composition AS composition_4,
  t0.quantity AS quantity_5,
  t0.weight AS weight_6,
  t0.main_image AS main_image_7,
  t0.price AS price_8,
  t0.retail_price AS retail_price_9,
  t0.description AS description_10,
  t0.ean AS ean_11,
  t0.slug AS slug_12,
  t0.stripe_id AS stripe_id_13,
  t0.color AS color_14,
  t0.images AS images_15,
  t0.promotion_rate AS promotion_rate_16,
  t0.profit_margin AS profit_margin_17,
  t0.stripe_obj_id AS stripe_obj_id_18,
  t0.api_last_updated AS api_last_updated_19,
  t0.selling_price AS selling_price_20,
  t0.api_id AS api_id_21,
  t0.media_path AS media_path_22,
  t0.product_id AS product_id_23
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.composition AS composition_4, t0.quantity AS quantity_5, t0.weight AS weight_6, t0.main_image AS main_image_7, t0.price AS price_8, t0.retail_price AS retail_price_9, t0.description AS description_10, t0.ean AS ean_11, t0.slug AS slug_12, t0.stripe_id AS stripe_id_13, t0.color AS color_14, t0.images AS images_15, t0.promotion_rate AS promotion_rate_16, t0.profit_margin AS profit_margin_17, t0.stripe_obj_id AS stripe_obj_id_18, t0.api_last_updated AS api_last_updated_19, t0.selling_price AS selling_price_20, t0.api_id AS api_id_21, t0.media_path AS media_path_22, t0.product_id AS product_id_23 FROM product_variant t0 WHERE t0.product_id = 91;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 331)
8	App\Entity\Product->firstVariantId (line 1709)
9	Twig\Extension\CoreExtension::getAttribute (line 349)
10	__TwigTemplate_bfc366619682b7058dd8d743bace1a85->block_main (line 430)
11	Twig\Template->yieldBlock (line 150)
12	__TwigTemplate_ee6f99a8291fc7069da36c98e7dbe67b->block_body (line 430)
13	Twig\Template->yieldBlock (line 76)
14	__TwigTemplate_ee6f99a8291fc7069da36c98e7dbe67b->doDisplay (line 360)
15	Twig\Template->yield (line 52)
16	__TwigTemplate_bfc366619682b7058dd8d743bace1a85->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 299)
20	Twig\Environment->render (line 242)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 164)
23	App\Controller\PagesController->indexWomen (line 163)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

2.67 ms
(5.43%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.composition AS composition_3, t0.quantity AS quantity_4, t0.weight AS weight_5, t0.main_image AS main_image_6, t0.price AS price_7, t0.retail_price AS retail_price_8, t0.description AS description_9, t0.ean AS ean_10, t0.slug AS slug_11, t0.collection_name AS collection_name_12, t0.images AS images_13, t0.profit_margin AS profit_margin_14, t0.promotion_margin AS promotion_margin_15, t0.api_last_updated AS api_last_updated_16, t0.model_id AS model_id_17, t0.api_id AS api_id_18, t0.media_path AS media_path_19, t0.supplier_id AS supplier_id_20 FROM product t0 INNER JOIN product_product_collection ON t0.id = product_product_collection.product_id WHERE product_product_collection.product_collection_id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.composition AS composition_3,
  t0.quantity AS quantity_4,
  t0.weight AS weight_5,
  t0.main_image AS main_image_6,
  t0.price AS price_7,
  t0.retail_price AS retail_price_8,
  t0.description AS description_9,
  t0.ean AS ean_10,
  t0.slug AS slug_11,
  t0.collection_name AS collection_name_12,
  t0.images AS images_13,
  t0.profit_margin AS profit_margin_14,
  t0.promotion_margin AS promotion_margin_15,
  t0.api_last_updated AS api_last_updated_16,
  t0.model_id AS model_id_17,
  t0.api_id AS api_id_18,
  t0.media_path AS media_path_19,
  t0.supplier_id AS supplier_id_20
FROM
  product t0
  INNER JOIN product_product_collection ON t0.id = product_product_collection.product_id
WHERE
  product_product_collection.product_collection_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.composition AS composition_3, t0.quantity AS quantity_4, t0.weight AS weight_5, t0.main_image AS main_image_6, t0.price AS price_7, t0.retail_price AS retail_price_8, t0.description AS description_9, t0.ean AS ean_10, t0.slug AS slug_11, t0.collection_name AS collection_name_12, t0.images AS images_13, t0.profit_margin AS profit_margin_14, t0.promotion_margin AS promotion_margin_15, t0.api_last_updated AS api_last_updated_16, t0.model_id AS model_id_17, t0.api_id AS api_id_18, t0.media_path AS media_path_19, t0.supplier_id AS supplier_id_20 FROM product t0 INNER JOIN product_product_collection ON t0.id = product_product_collection.product_id WHERE product_product_collection.product_collection_id = 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3302)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 334)
8	__TwigTemplate_bfc366619682b7058dd8d743bace1a85->block_main (line 430)
9	Twig\Template->yieldBlock (line 150)
10	__TwigTemplate_ee6f99a8291fc7069da36c98e7dbe67b->block_body (line 430)
11	Twig\Template->yieldBlock (line 76)
12	__TwigTemplate_ee6f99a8291fc7069da36c98e7dbe67b->doDisplay (line 360)
13	Twig\Template->yield (line 52)
14	__TwigTemplate_bfc366619682b7058dd8d743bace1a85->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 299)
18	Twig\Environment->render (line 242)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 164)
21	App\Controller\PagesController->indexWomen (line 163)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.46 ms
(2.97%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.gender AS gender_5, t0.featured AS featured_6 FROM product_collection t0 WHERE t0.gender = ? AND t0.name = ? LIMIT 8

Parameters:

[
  2
  "New Arrival"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.gender AS gender_5,
  t0.featured AS featured_6
FROM
  product_collection t0
WHERE
  t0.gender = ?
  AND t0.name = ?
LIMIT
  8

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.gender AS gender_5, t0.featured AS featured_6 FROM product_collection t0 WHERE t0.gender = 2 AND t0.name = 'New Arrival' LIMIT 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 141)
4	App\Controller\PagesController->indexWomen (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.14 ms
(2.32%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.level = ?

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.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.level = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.level = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 130)
4	App\Controller\PagesController->indexWomen (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.84 ms
(1.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = ? AND t0.level = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0
WHERE
  t0.parent_category_id = ?
  AND t0.level = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.level AS level_4, t0.image AS image_5, t0.slug AS slug_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = 2 AND t0.level = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 133)
4	App\Controller\PagesController->indexWomen (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.76 ms
(1.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.gender AS gender_5, t0.featured AS featured_6 FROM product_collection t0 WHERE t0.gender = ? AND t0.featured = ? LIMIT 12

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.gender AS gender_5,
  t0.featured AS featured_6
FROM
  product_collection t0
WHERE
  t0.gender = ?
  AND t0.featured = ?
LIMIT
  12

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.gender AS gender_5, t0.featured AS featured_6 FROM product_collection t0 WHERE t0.gender = 2 AND t0.featured = 1 LIMIT 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 136)
4	App\Controller\PagesController->indexWomen (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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.

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\CategoryMatching	No errors.
App\Entity\Product	No errors.
App\Entity\ProductCollection	No errors.
App\Entity\NewsletterSubscriber	No errors.
App\Entity\Suplier	No errors.
App\Entity\Option	No errors.
App\Entity\ProductVariant	No errors.
App\Entity\MarketPlace	No errors.
App\Entity\Listing	No errors.
App\Entity\Size	No errors.
App\Entity\OptionValue	No errors.
App\Entity\OrderItem	No errors.

Symfony Profiler

GET https://selectwears.com/en/women

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping