Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

10.10 ms Query time

1 Invalid entities

23 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.59 ms
(45.48%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.price AS price_5, p0_.is_gift_card AS is_gift_card_6, p0_.is_only_for_seo AS is_only_for_seo_7, p0_.visible AS visible_8, p0_.new AS new_9, p0_.featured AS featured_10, p0_.sku AS sku_11, p0_.meta_title AS meta_title_12, p0_.meta_description AS meta_description_13, p0_.meta_robots AS meta_robots_14, p0_.url_path AS url_path_15, p0_.buying_price AS buying_price_16, p0_.vat_rate AS vat_rate_17, p0_.weight AS weight_18, p0_.width AS width_19, p0_.height AS height_20, p0_.additional_shipping_costs AS additional_shipping_costs_21, p0_.inventory AS inventory_22, p0_.data AS data_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p1_.id AS id_26, p1_.ordering AS ordering_27, m2_.id AS id_28, m2_.name AS name_29, m2_.original_name AS original_name_30, p1_.product_id AS product_id_31, p1_.media_id AS media_id_32, m2_.shop_id AS shop_id_33 FROM product p0_ LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id LEFT JOIN media m2_ ON p1_.media_id = m2_.id WHERE p0_.id IN (?, ?, ?, ?) ORDER BY p1_.ordering ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.short_description AS short_description_4,
  p0_.price AS price_5,
  p0_.is_gift_card AS is_gift_card_6,
  p0_.is_only_for_seo AS is_only_for_seo_7,
  p0_.visible AS visible_8,
  p0_.new AS new_9,
  p0_.featured AS featured_10,
  p0_.sku AS sku_11,
  p0_.meta_title AS meta_title_12,
  p0_.meta_description AS meta_description_13,
  p0_.meta_robots AS meta_robots_14,
  p0_.url_path AS url_path_15,
  p0_.buying_price AS buying_price_16,
  p0_.vat_rate AS vat_rate_17,
  p0_.weight AS weight_18,
  p0_.width AS width_19,
  p0_.height AS height_20,
  p0_.additional_shipping_costs AS additional_shipping_costs_21,
  p0_.inventory AS inventory_22,
  p0_.data AS data_23,
  p0_.created_at AS created_at_24,
  p0_.updated_at AS updated_at_25,
  p1_.id AS id_26,
  p1_.ordering AS ordering_27,
  m2_.id AS id_28,
  m2_.name AS name_29,
  m2_.original_name AS original_name_30,
  p1_.product_id AS product_id_31,
  p1_.media_id AS media_id_32,
  m2_.shop_id AS shop_id_33
FROM
  product p0_
  LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id
  LEFT JOIN media m2_ ON p1_.media_id = m2_.id
WHERE
  p0_.id IN (?, ?, ?, ?)
ORDER BY
  p1_.ordering ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.price AS price_5, p0_.is_gift_card AS is_gift_card_6, p0_.is_only_for_seo AS is_only_for_seo_7, p0_.visible AS visible_8, p0_.new AS new_9, p0_.featured AS featured_10, p0_.sku AS sku_11, p0_.meta_title AS meta_title_12, p0_.meta_description AS meta_description_13, p0_.meta_robots AS meta_robots_14, p0_.url_path AS url_path_15, p0_.buying_price AS buying_price_16, p0_.vat_rate AS vat_rate_17, p0_.weight AS weight_18, p0_.width AS width_19, p0_.height AS height_20, p0_.additional_shipping_costs AS additional_shipping_costs_21, p0_.inventory AS inventory_22, p0_.data AS data_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p1_.id AS id_26, p1_.ordering AS ordering_27, m2_.id AS id_28, m2_.name AS name_29, m2_.original_name AS original_name_30, p1_.product_id AS product_id_31, p1_.media_id AS media_id_32, m2_.shop_id AS shop_id_33 FROM product p0_ LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id LEFT JOIN media m2_ ON p1_.media_id = m2_.id WHERE p0_.id IN (769, 746, 710, 780) ORDER BY p1_.ordering 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 368)
7	App\Repository\ProductRepository->findSimilarProducts (line 147)
8	App\Controller\Api\Product\ProductController->getSimilarProducts (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 14)

2.61 ms
(25.85%)

SELECT p0_.id AS id_0 FROM product p0_ INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id INNER JOIN shop s1_ ON s1_.id = s2_.shop_id WHERE s1_.id = ? AND p0_.id <> ? AND p0_.visible = 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0
FROM
  product p0_
  INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id
  INNER JOIN shop s1_ ON s1_.id = s2_.shop_id
WHERE
  s1_.id = ?
  AND p0_.id <> ?
  AND p0_.visible = 1

SELECT p0_.id AS id_0 FROM product p0_ INNER JOIN shop_product s2_ ON p0_.id = s2_.product_id INNER JOIN shop s1_ ON s1_.id = s2_.shop_id WHERE s1_.id = 2 AND p0_.id <> 847 AND p0_.visible = 1;

#	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 713)
6	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 349)
7	App\Repository\ProductRepository->findSimilarProducts (line 147)
8	App\Controller\Api\Product\ProductController->getSimilarProducts (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 14)

2.27 ms
(22.52%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.price AS price_6, t0.is_gift_card AS is_gift_card_7, t0.is_only_for_seo AS is_only_for_seo_8, t0.visible AS visible_9, t0.new AS new_10, t0.featured AS featured_11, t0.sku AS sku_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.meta_robots AS meta_robots_15, t0.url_path AS url_path_16, t0.buying_price AS buying_price_17, t0.vat_rate AS vat_rate_18, t0.weight AS weight_19, t0.width AS width_20, t0.height AS height_21, t0.additional_shipping_costs AS additional_shipping_costs_22, t0.inventory AS inventory_23, t0.data AS data_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM product t0 WHERE t0.id = ?

Parameters:

[
  847
]

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.short_description AS short_description_5,
  t0.price AS price_6,
  t0.is_gift_card AS is_gift_card_7,
  t0.is_only_for_seo AS is_only_for_seo_8,
  t0.visible AS visible_9,
  t0.new AS new_10,
  t0.featured AS featured_11,
  t0.sku AS sku_12,
  t0.meta_title AS meta_title_13,
  t0.meta_description AS meta_description_14,
  t0.meta_robots AS meta_robots_15,
  t0.url_path AS url_path_16,
  t0.buying_price AS buying_price_17,
  t0.vat_rate AS vat_rate_18,
  t0.weight AS weight_19,
  t0.width AS width_20,
  t0.height AS height_21,
  t0.additional_shipping_costs AS additional_shipping_costs_22,
  t0.inventory AS inventory_23,
  t0.data AS data_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.price AS price_6, t0.is_gift_card AS is_gift_card_7, t0.is_only_for_seo AS is_only_for_seo_8, t0.visible AS visible_9, t0.new AS new_10, t0.featured AS featured_11, t0.sku AS sku_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.meta_robots AS meta_robots_15, t0.url_path AS url_path_16, t0.buying_price AS buying_price_17, t0.vat_rate AS vat_rate_18, t0.weight AS weight_19, t0.width AS width_20, t0.height AS height_21, t0.additional_shipping_costs AS additional_shipping_costs_22, t0.inventory AS inventory_23, t0.data AS data_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM product t0 WHERE t0.id = 847;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	App\Controller\Api\Product\ProductController->getSimilarProducts (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 14)

0.62 ms
(6.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t5.id AS id_6, t5.text AS text_7, t5.link AS link_8, t5.text_color AS text_color_9, t5.bg_color AS bg_color_10, t5.display AS display_11, t5.start_at AS start_at_12, t5.end_at AS end_at_13, t5.shop_id AS shop_id_14 FROM shop t0 LEFT JOIN banner t5 ON t5.shop_id = t0.id WHERE t0.id = ?

Parameters:

[
  "2"
]

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.address AS address_4,
  t5.id AS id_6,
  t5.text AS text_7,
  t5.link AS link_8,
  t5.text_color AS text_color_9,
  t5.bg_color AS bg_color_10,
  t5.display AS display_11,
  t5.start_at AS start_at_12,
  t5.end_at AS end_at_13,
  t5.shop_id AS shop_id_14
FROM
  shop t0
  LEFT JOIN banner t5 ON t5.shop_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t5.id AS id_6, t5.text AS text_7, t5.link AS link_8, t5.text_color AS text_color_9, t5.bg_color AS bg_color_10, t5.display AS display_11, t5.start_at AS start_at_12, t5.end_at AS end_at_13, t5.shop_id AS shop_id_14 FROM shop t0 LEFT JOIN banner t5 ON t5.shop_id = t0.id WHERE t0.id = '2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 128)
7	App\Controller\Api\Product\ProductController->getSimilarProducts (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 14)

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\ProductMedia	8
App\Entity\Media	8
App\Entity\Product	5
App\Entity\Shop	1
App\Entity\Banner	1

Entities Mapping

Class	Mapping errors
App\Entity\Shop	No errors.
App\Entity\Banner	No errors.
App\Entity\EmployeProfile	No errors.
App\Entity\Product	No errors.
App\Entity\Order	No errors.
App\Entity\Invoice	No errors.
App\Entity\CustomerProfil	No errors.
App\Entity\Category	No errors.
App\Entity\ProductVisibility	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\ProductVariant	The field 'App\Entity\ProductVariant#additionalShippingCosts' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ProductOption	No errors.
App\Entity\ProductPricingRule	No errors.
App\Entity\ProductMedia	No errors.
App\Entity\Media	No errors.

Symfony Profiler

GET https://www.arcanes-labo.btov-dev.fr/api/custom/products/similar/847?shop=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping