Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.33 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.88 ms
(89.58%)

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 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
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 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.45 ms
(10.42%)

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\ProductOptionAvantage	No errors.
App\Entity\Technology	No errors.
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\Actuality	No errors.
App\Entity\ProductPlus	No errors.
App\Entity\ProductInfoMedia	No errors.
App\Entity\ServiceAvantage	No errors.
App\Entity\ProductInfoAvantage	No errors.
App\Entity\TechnologyTab	No errors.
App\Entity\ProductDataTable	No errors.
App\Entity\ProductInfo	No errors.
App\Entity\Service	No errors.
App\Entity\Product	No errors.
App\Entity\ServiceParagraph	No errors.
App\Entity\ActualityParagraph	No errors.
Cofondateur\SocleTechniqueBundle\Entity\User	No errors.
App\Entity\User	No errors.
App\Entity\Homepage	No errors.
App\Entity\TechnologyTabParagraph	No errors.
App\Entity\Contact	No errors.
App\Entity\ProductOptionParagraph	No errors.
App\Entity\Dealer	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.
Cofondateur\SocleTechniqueBundle\Entity\Blog\Article	The target entity 'App\Entity\Blog\ArticleParagraph' specified on Cofondateur\SocleTechniqueBundle\Entity\Blog\Article#paragraphs is unknown or not an entity.
Vich\UploaderBundle\Entity\File	No errors.
Lexik\Bundle\TranslationBundle\Model\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Model\Translation	No errors.
Lexik\Bundle\TranslationBundle\Entity\Translation	No errors.
Lexik\Bundle\TranslationBundle\Model\File	No errors.
Lexik\Bundle\TranslationBundle\Entity\File	No errors.

Symfony Profiler

GET https://spectre.asb-digital.fr/_profiler/7b2fc3/search/null

Configuration Settings

Theme