Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.75 ms Query time

2 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.87 ms

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 FROM seopage_global s0_ WHERE s0_.route = ?

Parameters:

[
  "app_product_show"
]

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
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 FROM seopage_global s0_ WHERE s0_.route = 'app_product_show';

#	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)

0.72 ms

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 982)
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)

1.16 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "meteor-original"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.summary AS summary_3,
  t0.banner_name AS banner_name_4,
  t0.banner_size AS banner_size_5,
  t0.banner_updated_at AS banner_updated_at_6,
  t0.banner_alt AS banner_alt_7,
  t0.banner_youtube_url_original AS banner_youtube_url_original_8,
  t0.banner_youtube_url_embed AS banner_youtube_url_embed_9,
  t0.advantage_title AS advantage_title_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.slug AS slug_13,
  t14.product_name AS product_name_15,
  t14.product_size AS product_size_16,
  t14.product_updated_at AS product_updated_at_17,
  t14.product_alt AS product_alt_18,
  t14.cover_name AS cover_name_19,
  t14.cover_size AS cover_size_20,
  t14.cover_updated_at AS cover_updated_at_21,
  t14.cover_alt AS cover_alt_22,
  t14.logo_name AS logo_name_23,
  t14.logo_size AS logo_size_24,
  t14.logo_updated_at AS logo_updated_at_25,
  t14.logo_alt AS logo_alt_26,
  t14.display_hp AS display_hp_27,
  t14.id AS id_28,
  t14.position AS position_29,
  t14.is_published AS is_published_30,
  t14.category_id AS category_id_31,
  t14.translation_en_id AS translation_en_id_32,
  t14.translation_fr_id AS translation_fr_id_33,
  t34.product_name AS product_name_35,
  t34.product_size AS product_size_36,
  t34.product_updated_at AS product_updated_at_37,
  t34.product_alt AS product_alt_38,
  t34.cover_name AS cover_name_39,
  t34.cover_size AS cover_size_40,
  t34.cover_updated_at AS cover_updated_at_41,
  t34.cover_alt AS cover_alt_42,
  t34.logo_name AS logo_name_43,
  t34.logo_size AS logo_size_44,
  t34.logo_updated_at AS logo_updated_at_45,
  t34.logo_alt AS logo_alt_46,
  t34.display_hp AS display_hp_47,
  t34.id AS id_48,
  t34.position AS position_49,
  t34.is_published AS is_published_50,
  t34.category_id AS category_id_51,
  t34.translation_en_id AS translation_en_id_52,
  t34.translation_fr_id AS translation_fr_id_53
FROM
  product t0
  LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id
  LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.banner_name AS banner_name_4, t0.banner_size AS banner_size_5, t0.banner_updated_at AS banner_updated_at_6, t0.banner_alt AS banner_alt_7, t0.banner_youtube_url_original AS banner_youtube_url_original_8, t0.banner_youtube_url_embed AS banner_youtube_url_embed_9, t0.advantage_title AS advantage_title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.slug AS slug_13, t14.product_name AS product_name_15, t14.product_size AS product_size_16, t14.product_updated_at AS product_updated_at_17, t14.product_alt AS product_alt_18, t14.cover_name AS cover_name_19, t14.cover_size AS cover_size_20, t14.cover_updated_at AS cover_updated_at_21, t14.cover_alt AS cover_alt_22, t14.logo_name AS logo_name_23, t14.logo_size AS logo_size_24, t14.logo_updated_at AS logo_updated_at_25, t14.logo_alt AS logo_alt_26, t14.display_hp AS display_hp_27, t14.id AS id_28, t14.position AS position_29, t14.is_published AS is_published_30, t14.category_id AS category_id_31, t14.translation_en_id AS translation_en_id_32, t14.translation_fr_id AS translation_fr_id_33, t34.product_name AS product_name_35, t34.product_size AS product_size_36, t34.product_updated_at AS product_updated_at_37, t34.product_alt AS product_alt_38, t34.cover_name AS cover_name_39, t34.cover_size AS cover_size_40, t34.cover_updated_at AS cover_updated_at_41, t34.cover_alt AS cover_alt_42, t34.logo_name AS logo_name_43, t34.logo_size AS logo_size_44, t34.logo_updated_at AS logo_updated_at_45, t34.logo_alt AS logo_alt_46, t34.display_hp AS display_hp_47, t34.id AS id_48, t34.position AS position_49, t34.is_published AS is_published_50, t34.category_id AS category_id_51, t34.translation_en_id AS translation_en_id_52, t34.translation_fr_id AS translation_fr_id_53 FROM product t0 LEFT JOIN product_global t14 ON t14.translation_en_id = t0.id LEFT JOIN product_global t34 ON t34.translation_fr_id = t0.id WHERE t0.slug = 'meteor-original' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\SiteSettings	1
App\Entity\Product\Product	1

Entities Mapping

Class	Mapping 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.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings	No errors.
App\Entity\SiteSettings	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.
App\Entity\Product\ProductGlobal	No errors.
App\Entity\Product\ProductCategoryGlobal	No errors.
App\Entity\Product\ProductAttribute	No errors.
App\Entity\Paragraph	No errors.
App\Entity\Advantage	No errors.
App\Entity\TestimonialGlobal	No errors.
App\Entity\Product\ProductMedia	No errors.
App\Entity\Product\ProductDataTable	No errors.
App\Entity\DocumentGlobal	No errors.

Symfony Profiler

GET https://evrard.asb-digital.fr/fr/produits/meteor-original

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping