Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

5.01 ms Query time

1 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.03 ms
(40.64%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = ?

Parameters:

[
  239
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.shop_id AS shop_id_4
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = 239;

#	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 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\Media::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Media->__get (line 62)
8	App\Entity\Media->getName (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 780)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 198)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 227)
16	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
18	Symfony\Component\Serializer\Serializer->normalize (line 170)
19	Symfony\Component\Serializer\Serializer->normalize (line 755)
20	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 198)
21	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
22	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
23	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
24	Symfony\Component\Serializer\Serializer->normalize (line 170)
25	Symfony\Component\Serializer\Serializer->normalize (line 170)
26	Symfony\Component\Serializer\Serializer->normalize (line 131)
27	Symfony\Component\Serializer\Serializer->serialize (line 44)
28	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 151)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 103)
30	App\Controller\Api\Product\ProductController->getNewProducts (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 14)

1.06 ms
(21.10%)

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, p1_.product_id AS product_id_28, p1_.media_id AS media_id_29 FROM product p0_ LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC, 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,
  p1_.product_id AS product_id_28,
  p1_.media_id AS media_id_29
FROM
  product p0_
  LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.id ASC,
  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, p1_.product_id AS product_id_28, p1_.media_id AS media_id_29 FROM product p0_ LEFT JOIN product_media p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (142, 606, 607, 650, 652, 653) ORDER BY p0_.id ASC, 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 268)
7	App\Repository\ProductRepository->findProductsByShopPaginated (line 102)
8	App\Controller\Api\Product\ProductController->getNewProducts (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)

0.87 ms
(17.32%)

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_.new = 1 ORDER BY p0_.id ASC LIMIT 6

Parameters:

[
  1
]

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_.new = 1
ORDER BY
  p0_.id ASC
LIMIT
  6

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 = 1 AND p0_.new = 1 ORDER BY p0_.id ASC LIMIT 6;

#	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 254)
7	App\Repository\ProductRepository->findProductsByShopPaginated (line 102)
8	App\Controller\Api\Product\ProductController->getNewProducts (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)

0.85 ms
(17.02%)

SELECT COUNT(DISTINCT p0_.id) AS sclr_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_.new = 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_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_.new = 1

SELECT COUNT(DISTINCT p0_.id) AS sclr_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 = 1 AND p0_.new = 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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 276)
8	App\Repository\ProductRepository->findProductsByShopPaginated (line 102)
9	App\Controller\Api\Product\ProductController->getNewProducts (line 183)
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 14)

0.20 ms
(3.93%)

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:

[
  "1"
]

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 = '1';

#	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 86)
7	App\Controller\Api\Product\ProductController->getNewProducts (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\Product	6
App\Entity\ProductMedia	6
App\Entity\Media	6
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\ProductMedia	No errors.
App\Entity\Media	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.

Symfony Profiler

GET https://www.arcanes-labo.btov-dev.fr/api/custom/products/new?shop=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping