Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.58 ms Query time

10 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.26 ms

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7, t0.meta_title_en AS meta_title_en_8, t0.meta_description_en AS meta_description_en_9, t0.h1_en AS h1_en_10 FROM seopage t0 WHERE t0.route IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.page_name AS page_name_2,
  t0.route AS route_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.h1_enabled AS h1_enabled_6,
  t0.h1 AS h1_7,
  t0.meta_title_en AS meta_title_en_8,
  t0.meta_description_en AS meta_description_en_9,
  t0.h1_en AS h1_en_10
FROM
  seopage t0
WHERE
  t0.route IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7, t0.meta_title_en AS meta_title_en_8, t0.meta_description_en AS meta_description_en_9, t0.h1_en AS h1_en_10 FROM seopage t0 WHERE t0.route IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 36)
4	Cofondateur\SocleTechniqueBundle\EventSubscriber\TwigEventSubscriber->onRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 111)
11	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 236)
16	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.32 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 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 41)
5	Cofondateur\SocleTechniqueBundle\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 111)
12	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 236)
17	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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
Cofondateur\SocleTechniqueBundle\Entity\SEOPage	No errors.
App\Entity\SEOPage	No errors.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings	No errors.
App\Entity\SiteSettings	No errors.
App\Entity\ApproachSpecificOffer	No errors.
App\Entity\ApproachSpecificOfferImages	No errors.
App\Entity\PostPage	No errors.
App\Entity\WhoWeAre	The mappings App\Entity\WhoWeAre#ourValuesParagraphs and App\Entity\WhoWeAreParagraph#whoWeAreOurValues are inconsistent with each other.
Cofondateur\SocleTechniqueBundle\Entity\User	No errors.
App\Entity\User	No errors.
App\Entity\Approach	The association App\Entity\Approach#asie1Documentations refers to the inverse side field App\Entity\Documentation#approachAsie1 which does not exist.
App\Entity\Skill	No errors.
App\Entity\Post	No errors.
App\Entity\Documentation	The mappings App\Entity\Documentation#approachAsi1 and App\Entity\Approach#asie1Documentations are inconsistent with each other.
App\Entity\DocumentationCategory	No errors.
App\Entity\PressureDevicePage	No errors.
App\Entity\PressureVessel	No errors.
App\Entity\Homepage	No errors.
App\Entity\PressureVesselSchema	No errors.
App\Entity\Achievement	No errors.
App\Entity\Product	No errors.
App\Entity\Contact	No errors.
Cofondateur\SocleTechniqueBundle\Entity\Blog\ArticleParagraph	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\Blog\Article' specified on Cofondateur\SocleTechniqueBundle\Entity\Blog\ArticleParagraph#article is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Blog\ArticleParagraph	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\Blog\Article' specified on App\Entity\Blog\ArticleParagraph#article is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Cofondateur\SocleTechniqueBundle\Entity\Blog\Article	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\User' specified on Cofondateur\SocleTechniqueBundle\Entity\Blog\Article#updatedBy is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Blog\Article	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\User' specified on App\Entity\Blog\Article#updatedBy is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Cofondateur\SocleTechniqueBundle\Entity\AboutUs\AboutUsPageParagraph	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\AboutUs\AboutUsPage' specified on Cofondateur\SocleTechniqueBundle\Entity\AboutUs\AboutUsPageParagraph#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\AboutUs\AboutUsPageParagraph	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\AboutUs\AboutUsPage' specified on App\Entity\AboutUs\AboutUsPageParagraph#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Cofondateur\SocleTechniqueBundle\Entity\AboutUs\AboutUsPage	No errors.
App\Entity\AboutUs\AboutUsPage	No errors.
App\Entity\ContactPage	No errors.
App\Entity\PostParagraph	No errors.
App\Entity\WhoWeAreParagraph	The association App\Entity\WhoWeAreParagraph#whoWeAreOurValues refers to the inverse side field App\Entity\WhoWeAre#ourValuesParagraph which does not exist.
App\Entity\ApproachParagraph	No errors.
App\Entity\DownloadProduct	No errors.
App\Entity\DownloadDocumentation	No errors.
App\Entity\DocumentationPage	No errors.
App\Entity\Application	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Lexik\Bundle\TranslationBundle\Model\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Model\File	No errors.
Lexik\Bundle\TranslationBundle\Entity\File	No errors.
Lexik\Bundle\TranslationBundle\Model\Translation	No errors.
Lexik\Bundle\TranslationBundle\Entity\Translation	No errors.

Symfony Profiler

GET https://ravanat-new.asb-digital.fr/back-end/app/.env

Configuration Settings

Theme