Symfony Profiler

Query Metrics

9 Database Queries

5 Different statements

3.13 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.36 ms
(43.51%)

SELECT t0.id AS id_1, t0.disable AS disable_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.info_text AS info_text_6, t0.features_text AS features_text_7, t0.features_pdf_name AS features_pdf_name_8, t0.features_pdf_size AS features_pdf_size_9, t0.features_pdf_updated_at AS features_pdf_updated_at_10, t0.features_pdf_title AS features_pdf_title_11, t0.products_range_text AS products_range_text_12, t0.products_range_pdf_name AS products_range_pdf_name_13, t0.products_range_pdf_size AS products_range_pdf_size_14, t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15, t0.products_range_pdf_title AS products_range_pdf_title_16, t0.regulatory_notices_text AS regulatory_notices_text_17, t0.contact_email AS contact_email_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.slug AS slug_21, t22.published AS published_23, t22.available_on_pwa AS available_on_pwa_24, t22.id AS id_25, t22.position AS position_26, t22.category_id AS category_id_27, t22.homepage_id AS homepage_id_28, t22.translation_en_id AS translation_en_id_29, t22.translation_fr_id AS translation_fr_id_30, t22.translation_us_id AS translation_us_id_31, t22.translation_es_id AS translation_es_id_32, t22.translation_de_id AS translation_de_id_33, t22.translation_pt_id AS translation_pt_id_34, t35.published AS published_36, t35.available_on_pwa AS available_on_pwa_37, t35.id AS id_38, t35.position AS position_39, t35.category_id AS category_id_40, t35.homepage_id AS homepage_id_41, t35.translation_en_id AS translation_en_id_42, t35.translation_fr_id AS translation_fr_id_43, t35.translation_us_id AS translation_us_id_44, t35.translation_es_id AS translation_es_id_45, t35.translation_de_id AS translation_de_id_46, t35.translation_pt_id AS translation_pt_id_47, t48.published AS published_49, t48.available_on_pwa AS available_on_pwa_50, t48.id AS id_51, t48.position AS position_52, t48.category_id AS category_id_53, t48.homepage_id AS homepage_id_54, t48.translation_en_id AS translation_en_id_55, t48.translation_fr_id AS translation_fr_id_56, t48.translation_us_id AS translation_us_id_57, t48.translation_es_id AS translation_es_id_58, t48.translation_de_id AS translation_de_id_59, t48.translation_pt_id AS translation_pt_id_60, t61.published AS published_62, t61.available_on_pwa AS available_on_pwa_63, t61.id AS id_64, t61.position AS position_65, t61.category_id AS category_id_66, t61.homepage_id AS homepage_id_67, t61.translation_en_id AS translation_en_id_68, t61.translation_fr_id AS translation_fr_id_69, t61.translation_us_id AS translation_us_id_70, t61.translation_es_id AS translation_es_id_71, t61.translation_de_id AS translation_de_id_72, t61.translation_pt_id AS translation_pt_id_73, t74.published AS published_75, t74.available_on_pwa AS available_on_pwa_76, t74.id AS id_77, t74.position AS position_78, t74.category_id AS category_id_79, t74.homepage_id AS homepage_id_80, t74.translation_en_id AS translation_en_id_81, t74.translation_fr_id AS translation_fr_id_82, t74.translation_us_id AS translation_us_id_83, t74.translation_es_id AS translation_es_id_84, t74.translation_de_id AS translation_de_id_85, t74.translation_pt_id AS translation_pt_id_86, t87.published AS published_88, t87.available_on_pwa AS available_on_pwa_89, t87.id AS id_90, t87.position AS position_91, t87.category_id AS category_id_92, t87.homepage_id AS homepage_id_93, t87.translation_en_id AS translation_en_id_94, t87.translation_fr_id AS translation_fr_id_95, t87.translation_us_id AS translation_us_id_96, t87.translation_es_id AS translation_es_id_97, t87.translation_de_id AS translation_de_id_98, t87.translation_pt_id AS translation_pt_id_99 FROM product t0 LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id WHERE t0.id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.disable AS disable_2,
  t0.title AS title_3,
  t0.sub_title AS sub_title_4,
  t0.description AS description_5,
  t0.info_text AS info_text_6,
  t0.features_text AS features_text_7,
  t0.features_pdf_name AS features_pdf_name_8,
  t0.features_pdf_size AS features_pdf_size_9,
  t0.features_pdf_updated_at AS features_pdf_updated_at_10,
  t0.features_pdf_title AS features_pdf_title_11,
  t0.products_range_text AS products_range_text_12,
  t0.products_range_pdf_name AS products_range_pdf_name_13,
  t0.products_range_pdf_size AS products_range_pdf_size_14,
  t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15,
  t0.products_range_pdf_title AS products_range_pdf_title_16,
  t0.regulatory_notices_text AS regulatory_notices_text_17,
  t0.contact_email AS contact_email_18,
  t0.meta_title AS meta_title_19,
  t0.meta_description AS meta_description_20,
  t0.slug AS slug_21,
  t22.published AS published_23,
  t22.available_on_pwa AS available_on_pwa_24,
  t22.id AS id_25,
  t22.position AS position_26,
  t22.category_id AS category_id_27,
  t22.homepage_id AS homepage_id_28,
  t22.translation_en_id AS translation_en_id_29,
  t22.translation_fr_id AS translation_fr_id_30,
  t22.translation_us_id AS translation_us_id_31,
  t22.translation_es_id AS translation_es_id_32,
  t22.translation_de_id AS translation_de_id_33,
  t22.translation_pt_id AS translation_pt_id_34,
  t35.published AS published_36,
  t35.available_on_pwa AS available_on_pwa_37,
  t35.id AS id_38,
  t35.position AS position_39,
  t35.category_id AS category_id_40,
  t35.homepage_id AS homepage_id_41,
  t35.translation_en_id AS translation_en_id_42,
  t35.translation_fr_id AS translation_fr_id_43,
  t35.translation_us_id AS translation_us_id_44,
  t35.translation_es_id AS translation_es_id_45,
  t35.translation_de_id AS translation_de_id_46,
  t35.translation_pt_id AS translation_pt_id_47,
  t48.published AS published_49,
  t48.available_on_pwa AS available_on_pwa_50,
  t48.id AS id_51,
  t48.position AS position_52,
  t48.category_id AS category_id_53,
  t48.homepage_id AS homepage_id_54,
  t48.translation_en_id AS translation_en_id_55,
  t48.translation_fr_id AS translation_fr_id_56,
  t48.translation_us_id AS translation_us_id_57,
  t48.translation_es_id AS translation_es_id_58,
  t48.translation_de_id AS translation_de_id_59,
  t48.translation_pt_id AS translation_pt_id_60,
  t61.published AS published_62,
  t61.available_on_pwa AS available_on_pwa_63,
  t61.id AS id_64,
  t61.position AS position_65,
  t61.category_id AS category_id_66,
  t61.homepage_id AS homepage_id_67,
  t61.translation_en_id AS translation_en_id_68,
  t61.translation_fr_id AS translation_fr_id_69,
  t61.translation_us_id AS translation_us_id_70,
  t61.translation_es_id AS translation_es_id_71,
  t61.translation_de_id AS translation_de_id_72,
  t61.translation_pt_id AS translation_pt_id_73,
  t74.published AS published_75,
  t74.available_on_pwa AS available_on_pwa_76,
  t74.id AS id_77,
  t74.position AS position_78,
  t74.category_id AS category_id_79,
  t74.homepage_id AS homepage_id_80,
  t74.translation_en_id AS translation_en_id_81,
  t74.translation_fr_id AS translation_fr_id_82,
  t74.translation_us_id AS translation_us_id_83,
  t74.translation_es_id AS translation_es_id_84,
  t74.translation_de_id AS translation_de_id_85,
  t74.translation_pt_id AS translation_pt_id_86,
  t87.published AS published_88,
  t87.available_on_pwa AS available_on_pwa_89,
  t87.id AS id_90,
  t87.position AS position_91,
  t87.category_id AS category_id_92,
  t87.homepage_id AS homepage_id_93,
  t87.translation_en_id AS translation_en_id_94,
  t87.translation_fr_id AS translation_fr_id_95,
  t87.translation_us_id AS translation_us_id_96,
  t87.translation_es_id AS translation_es_id_97,
  t87.translation_de_id AS translation_de_id_98,
  t87.translation_pt_id AS translation_pt_id_99
FROM
  product t0
  LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id
  LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id
  LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id
  LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id
  LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id
  LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.disable AS disable_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.info_text AS info_text_6, t0.features_text AS features_text_7, t0.features_pdf_name AS features_pdf_name_8, t0.features_pdf_size AS features_pdf_size_9, t0.features_pdf_updated_at AS features_pdf_updated_at_10, t0.features_pdf_title AS features_pdf_title_11, t0.products_range_text AS products_range_text_12, t0.products_range_pdf_name AS products_range_pdf_name_13, t0.products_range_pdf_size AS products_range_pdf_size_14, t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15, t0.products_range_pdf_title AS products_range_pdf_title_16, t0.regulatory_notices_text AS regulatory_notices_text_17, t0.contact_email AS contact_email_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.slug AS slug_21, t22.published AS published_23, t22.available_on_pwa AS available_on_pwa_24, t22.id AS id_25, t22.position AS position_26, t22.category_id AS category_id_27, t22.homepage_id AS homepage_id_28, t22.translation_en_id AS translation_en_id_29, t22.translation_fr_id AS translation_fr_id_30, t22.translation_us_id AS translation_us_id_31, t22.translation_es_id AS translation_es_id_32, t22.translation_de_id AS translation_de_id_33, t22.translation_pt_id AS translation_pt_id_34, t35.published AS published_36, t35.available_on_pwa AS available_on_pwa_37, t35.id AS id_38, t35.position AS position_39, t35.category_id AS category_id_40, t35.homepage_id AS homepage_id_41, t35.translation_en_id AS translation_en_id_42, t35.translation_fr_id AS translation_fr_id_43, t35.translation_us_id AS translation_us_id_44, t35.translation_es_id AS translation_es_id_45, t35.translation_de_id AS translation_de_id_46, t35.translation_pt_id AS translation_pt_id_47, t48.published AS published_49, t48.available_on_pwa AS available_on_pwa_50, t48.id AS id_51, t48.position AS position_52, t48.category_id AS category_id_53, t48.homepage_id AS homepage_id_54, t48.translation_en_id AS translation_en_id_55, t48.translation_fr_id AS translation_fr_id_56, t48.translation_us_id AS translation_us_id_57, t48.translation_es_id AS translation_es_id_58, t48.translation_de_id AS translation_de_id_59, t48.translation_pt_id AS translation_pt_id_60, t61.published AS published_62, t61.available_on_pwa AS available_on_pwa_63, t61.id AS id_64, t61.position AS position_65, t61.category_id AS category_id_66, t61.homepage_id AS homepage_id_67, t61.translation_en_id AS translation_en_id_68, t61.translation_fr_id AS translation_fr_id_69, t61.translation_us_id AS translation_us_id_70, t61.translation_es_id AS translation_es_id_71, t61.translation_de_id AS translation_de_id_72, t61.translation_pt_id AS translation_pt_id_73, t74.published AS published_75, t74.available_on_pwa AS available_on_pwa_76, t74.id AS id_77, t74.position AS position_78, t74.category_id AS category_id_79, t74.homepage_id AS homepage_id_80, t74.translation_en_id AS translation_en_id_81, t74.translation_fr_id AS translation_fr_id_82, t74.translation_us_id AS translation_us_id_83, t74.translation_es_id AS translation_es_id_84, t74.translation_de_id AS translation_de_id_85, t74.translation_pt_id AS translation_pt_id_86, t87.published AS published_88, t87.available_on_pwa AS available_on_pwa_89, t87.id AS id_90, t87.position AS position_91, t87.category_id AS category_id_92, t87.homepage_id AS homepage_id_93, t87.translation_en_id AS translation_en_id_94, t87.translation_fr_id AS translation_fr_id_95, t87.translation_us_id AS translation_us_id_96, t87.translation_es_id AS translation_es_id_97, t87.translation_de_id AS translation_de_id_98, t87.translation_pt_id AS translation_pt_id_99 FROM product t0 LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id WHERE t0.id = 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Product\Product::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Product\Product->__get (line 173)
8	App\Entity\Product\Product->getTitle (line 159)
9	App\Entity\Product\ProductGlobal->getTranslatedProperty (line 55)
10	App\State\Product\PublicProductProvider->entityToDto (line 46)
11	App\State\Product\PublicProductProvider->provide (line 43)
12	ApiPlatform\State\CallableProvider->provide (line 79)
13	ApiPlatform\State\Provider\ReadProvider->provide (line 86)
14	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 104)
15	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
16	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
18	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 87)
19	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 116)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.72 ms
(23.00%)

SELECT t0.id AS id_1, t0.picture_name AS picture_name_2, t0.picture_size AS picture_size_3, t0.picture_updated_at AS picture_updated_at_4, t0.picture_alt AS picture_alt_5, t0.video_link AS video_link_6, t0.mp4_name AS mp4_name_7, t0.mp4_size AS mp4_size_8, t0.mp4_updated_at AS mp4_updated_at_9, t0.position AS position_10, t0.product_id AS product_id_11 FROM pwaproduct_media t0 WHERE t0.product_id = ? ORDER BY t0.position ASC

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.picture_name AS picture_name_2,
  t0.picture_size AS picture_size_3,
  t0.picture_updated_at AS picture_updated_at_4,
  t0.picture_alt AS picture_alt_5,
  t0.video_link AS video_link_6,
  t0.mp4_name AS mp4_name_7,
  t0.mp4_size AS mp4_size_8,
  t0.mp4_updated_at AS mp4_updated_at_9,
  t0.position AS position_10,
  t0.product_id AS product_id_11
FROM
  pwaproduct_media t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.picture_name AS picture_name_2, t0.picture_size AS picture_size_3, t0.picture_updated_at AS picture_updated_at_4, t0.picture_alt AS picture_alt_5, t0.video_link AS video_link_6, t0.mp4_name AS mp4_name_7, t0.mp4_size AS mp4_size_8, t0.mp4_updated_at AS mp4_updated_at_9, t0.position AS position_10, t0.product_id AS product_id_11 FROM pwaproduct_media t0 WHERE t0.product_id = 20 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 162)
9	App\Entity\Product\ProductGlobal->getTranslatedProperty (line 65)
10	App\State\Product\PublicProductProvider->entityToDto (line 46)
11	App\State\Product\PublicProductProvider->provide (line 43)
12	ApiPlatform\State\CallableProvider->provide (line 79)
13	ApiPlatform\State\Provider\ReadProvider->provide (line 86)
14	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 104)
15	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
16	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
18	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 87)
19	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 116)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.65 ms
(20.63%)

SELECT t0.published AS published_1, t0.available_on_pwa AS available_on_pwa_2, t0.id AS id_3, t0.position AS position_4, t0.category_id AS category_id_5, t0.homepage_id AS homepage_id_6, t0.translation_en_id AS translation_en_id_7, t0.translation_fr_id AS translation_fr_id_8, t0.translation_us_id AS translation_us_id_9, t0.translation_es_id AS translation_es_id_10, t0.translation_de_id AS translation_de_id_11, t0.translation_pt_id AS translation_pt_id_12 FROM product_global t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.published AS published_1,
  t0.available_on_pwa AS available_on_pwa_2,
  t0.id AS id_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5,
  t0.homepage_id AS homepage_id_6,
  t0.translation_en_id AS translation_en_id_7,
  t0.translation_fr_id AS translation_fr_id_8,
  t0.translation_us_id AS translation_us_id_9,
  t0.translation_es_id AS translation_es_id_10,
  t0.translation_de_id AS translation_de_id_11,
  t0.translation_pt_id AS translation_pt_id_12
FROM
  product_global t0
WHERE
  t0.id = ?

SELECT t0.published AS published_1, t0.available_on_pwa AS available_on_pwa_2, t0.id AS id_3, t0.position AS position_4, t0.category_id AS category_id_5, t0.homepage_id AS homepage_id_6, t0.translation_en_id AS translation_en_id_7, t0.translation_fr_id AS translation_fr_id_8, t0.translation_us_id AS translation_us_id_9, t0.translation_es_id AS translation_es_id_10, t0.translation_de_id AS translation_de_id_11, t0.translation_pt_id AS translation_pt_id_12 FROM product_global t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 40)
6	App\State\Product\PublicProductProvider->provide (line 43)
7	ApiPlatform\State\CallableProvider->provide (line 79)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 86)
9	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 104)
10	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
11	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
12	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
13	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 87)
14	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.21 ms
(6.83%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.address_street AS address_street_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.legal_site_name AS legal_site_name_7,
  t0.legal_siret AS legal_siret_8,
  t0.legal_siren AS legal_siren_9,
  t0.legal_rcs AS legal_rcs_10,
  t0.legal_address AS legal_address_11,
  t0.legal_zipcode AS legal_zipcode_12,
  t0.legal_city AS legal_city_13,
  t0.legal_phone AS legal_phone_14,
  t0.legal_email AS legal_email_15,
  t0.legal_publication_owner AS legal_publication_owner_16,
  t0.legal_site_url AS legal_site_url_17,
  t0.default_title AS default_title_18,
  t0.default_meta_desc AS default_meta_desc_19
FROM
  site_settings t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 41)
5	App\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.19 ms
(6.03%)

SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5, s0_.translation_us_id AS translation_us_id_6, s0_.translation_es_id AS translation_es_id_7, s0_.translation_de_id AS translation_de_id_8, s0_.translation_pt_id AS translation_pt_id_9 FROM seopage_global s0_ WHERE s0_.route = ?

Parameters:

[
  "_api_/public/products/{id}_get"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.page_name AS page_name_1,
  s0_.route AS route_2,
  s0_.h1_enabled AS h1_enabled_3,
  s0_.translation_en_id AS translation_en_id_4,
  s0_.translation_fr_id AS translation_fr_id_5,
  s0_.translation_us_id AS translation_us_id_6,
  s0_.translation_es_id AS translation_es_id_7,
  s0_.translation_de_id AS translation_de_id_8,
  s0_.translation_pt_id AS translation_pt_id_9
FROM
  seopage_global s0_
WHERE
  s0_.route = ?

SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5, s0_.translation_us_id AS translation_us_id_6, s0_.translation_es_id AS translation_es_id_7, s0_.translation_de_id AS translation_de_id_8, s0_.translation_pt_id AS translation_pt_id_9 FROM seopage_global s0_ WHERE s0_.route = '_api_/public/products/{id}_get';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 48)
7	App\Repository\SEOPageGlobalRepository->findExistingRoute (line 36)
8	App\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	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\Product\ProductGlobal	The field App\Entity\Product\ProductGlobal#contact is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contact#product does not contain the required 'inversedBy="contact"' attribute.
App\Entity\Product\ProductCategoryGlobal	No errors.
App\Entity\HomepageGlobal	No errors.
App\Entity\Product\Product	The field App\Entity\Product\Product#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\Product\Product#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\Product\Product#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\Product\Product#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\Product\Product#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\Product\Product#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
App\Entity\Contact	No errors.
App\Entity\PWA\ProductDocumentationGlobal	No errors.
App\Entity\IFU\IFUDocument	No errors.
App\Entity\Product\ProductMedia	No errors.
App\Entity\PWA\Product3DView	No errors.
App\Entity\PWA\ProductMP4Media	No errors.
App\Entity\PWA\PWAProductMedia	No errors.
App\Entity\SEOPageGlobal	No errors.
App\Entity\SEOPage	The field App\Entity\SEOPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute. The field App\Entity\SEOPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute. The field App\Entity\SEOPage#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute. The field App\Entity\SEOPage#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute. The field App\Entity\SEOPage#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute. The field App\Entity\SEOPage#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings	No errors.
App\Entity\SiteSettings	No errors.

Symfony Profiler

GET https://spineway.asb-digital.fr/api/public/products/6

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping