Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

7.54 ms Query time

6 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.88 ms
(38.26%)

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title_fr AS meta_title_fr_4, t0.meta_description_fr AS meta_description_fr_5, t0.meta_title_en AS meta_title_en_6, t0.meta_description_en AS meta_description_en_7, t0.meta_title_it AS meta_title_it_8, t0.meta_description_it AS meta_description_it_9, t0.meta_title_ru AS meta_title_ru_10, t0.meta_description_ru AS meta_description_ru_11, t0.meta_title_es AS meta_title_es_12, t0.meta_description_es AS meta_description_es_13, t0.meta_title_de AS meta_title_de_14, t0.meta_description_de AS meta_description_de_15, t0.h1_enabled AS h1_enabled_16, t0.h1 AS h1_17 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_fr AS meta_title_fr_4,
  t0.meta_description_fr AS meta_description_fr_5,
  t0.meta_title_en AS meta_title_en_6,
  t0.meta_description_en AS meta_description_en_7,
  t0.meta_title_it AS meta_title_it_8,
  t0.meta_description_it AS meta_description_it_9,
  t0.meta_title_ru AS meta_title_ru_10,
  t0.meta_description_ru AS meta_description_ru_11,
  t0.meta_title_es AS meta_title_es_12,
  t0.meta_description_es AS meta_description_es_13,
  t0.meta_title_de AS meta_title_de_14,
  t0.meta_description_de AS meta_description_de_15,
  t0.h1_enabled AS h1_enabled_16,
  t0.h1 AS h1_17
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_fr AS meta_title_fr_4, t0.meta_description_fr AS meta_description_fr_5, t0.meta_title_en AS meta_title_en_6, t0.meta_description_en AS meta_description_en_7, t0.meta_title_it AS meta_title_it_8, t0.meta_description_it AS meta_description_it_9, t0.meta_title_ru AS meta_title_ru_10, t0.meta_description_ru AS meta_description_ru_11, t0.meta_title_es AS meta_title_es_12, t0.meta_description_es AS meta_description_es_13, t0.meta_title_de AS meta_title_de_14, t0.meta_description_de AS meta_description_de_15, t0.h1_enabled AS h1_enabled_16, t0.h1 AS h1_17 FROM seopage t0 WHERE t0.route IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
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)

2.19 ms
(29.08%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.machine_name AS machine_name_4, t0.machine_size AS machine_size_5, t0.machine_updated_at AS machine_updated_at_6, t0.machine_alt AS machine_alt_7, t0.landing_position AS landing_position_8, t0.display_on_landing AS display_on_landing_9, t0.for_offer AS for_offer_10, t0.summary AS summary_11, t0.description AS description_12, t0.position AS position_13, t0.slug AS slug_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.brand_id AS brand_id_17 FROM machine t0 WHERE t0.id = ?

Parameters:

[
  "144"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.machine_name AS machine_name_4,
  t0.machine_size AS machine_size_5,
  t0.machine_updated_at AS machine_updated_at_6,
  t0.machine_alt AS machine_alt_7,
  t0.landing_position AS landing_position_8,
  t0.display_on_landing AS display_on_landing_9,
  t0.for_offer AS for_offer_10,
  t0.summary AS summary_11,
  t0.description AS description_12,
  t0.position AS position_13,
  t0.slug AS slug_14,
  t0.meta_title AS meta_title_15,
  t0.meta_description AS meta_description_16,
  t0.brand_id AS brand_id_17
FROM
  machine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.machine_name AS machine_name_4, t0.machine_size AS machine_size_5, t0.machine_updated_at AS machine_updated_at_6, t0.machine_alt AS machine_alt_7, t0.landing_position AS landing_position_8, t0.display_on_landing AS display_on_landing_9, t0.for_offer AS for_offer_10, t0.summary AS summary_11, t0.description AS description_12, t0.position AS position_13, t0.slug AS slug_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.brand_id AS brand_id_17 FROM machine t0 WHERE t0.id = '144';

#	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 239)
6	App\Controller\FrontController->contact (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

2.14 ms
(28.32%)

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title_fr AS meta_title_fr_4, t0.meta_description_fr AS meta_description_fr_5, t0.meta_title_en AS meta_title_en_6, t0.meta_description_en AS meta_description_en_7, t0.meta_title_it AS meta_title_it_8, t0.meta_description_it AS meta_description_it_9, t0.meta_title_ru AS meta_title_ru_10, t0.meta_description_ru AS meta_description_ru_11, t0.meta_title_es AS meta_title_es_12, t0.meta_description_es AS meta_description_es_13, t0.meta_title_de AS meta_title_de_14, t0.meta_description_de AS meta_description_de_15, t0.h1_enabled AS h1_enabled_16, t0.h1 AS h1_17 FROM seopage t0 WHERE t0.route = ? LIMIT 1

Parameters:

[
  "front_contact"
]

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_fr AS meta_title_fr_4,
  t0.meta_description_fr AS meta_description_fr_5,
  t0.meta_title_en AS meta_title_en_6,
  t0.meta_description_en AS meta_description_en_7,
  t0.meta_title_it AS meta_title_it_8,
  t0.meta_description_it AS meta_description_it_9,
  t0.meta_title_ru AS meta_title_ru_10,
  t0.meta_description_ru AS meta_description_ru_11,
  t0.meta_title_es AS meta_title_es_12,
  t0.meta_description_es AS meta_description_es_13,
  t0.meta_title_de AS meta_title_de_14,
  t0.meta_description_de AS meta_description_de_15,
  t0.h1_enabled AS h1_enabled_16,
  t0.h1 AS h1_17
FROM
  seopage t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title_fr AS meta_title_fr_4, t0.meta_description_fr AS meta_description_fr_5, t0.meta_title_en AS meta_title_en_6, t0.meta_description_en AS meta_description_en_7, t0.meta_title_it AS meta_title_it_8, t0.meta_description_it AS meta_description_it_9, t0.meta_title_ru AS meta_title_ru_10, t0.meta_description_ru AS meta_description_ru_11, t0.meta_title_es AS meta_title_es_12, t0.meta_description_es AS meta_description_es_13, t0.meta_title_de AS meta_title_de_14, t0.meta_description_de AS meta_description_de_15, t0.h1_enabled AS h1_enabled_16, t0.h1 AS h1_17 FROM seopage t0 WHERE t0.route = 'front_contact' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
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 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.33 ms
(4.34%)

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	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 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\SEOPage	1
App\Entity\SiteSettings	1
App\Entity\Machine	1
App\Entity\Brand	1

Entities Mapping

Class	Mapping errors
App\Entity\SEOPage	No errors.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings	No errors.
App\Entity\SiteSettings	No errors.
App\Entity\Machine	No errors.
App\Entity\Brand	No errors.
App\Entity\MachineDatatable	No errors.
App\Entity\BrandParagraph	No errors.
App\Entity\MachineDatatableHeaderField	No errors.
App\Entity\MachineDatatableRow	No errors.
App\Entity\Contact	No errors.
App\Entity\MachineDatatableField	No errors.
App\Entity\Post	No errors.
App\Entity\Homepage	No errors.
App\Entity\Country	No errors.
Cofondateur\SocleTechniqueBundle\Entity\User	No errors.
App\Entity\User	No errors.
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\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\AboutUs\AboutUsPage	No errors.
App\Entity\AboutUs\AboutUsPage	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\SEOPage	No errors.
Vich\UploaderBundle\Entity\File	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.
Lexik\Bundle\TranslationBundle\Model\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit	No errors.

Symfony Profiler

GET https://cmsolutions.asb-digital.fr/es/contacto?from=machine&machine=144

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping