Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

1.30 ms Query time

4 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.52 ms
(39.93%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.matomo_url AS matomo_url_18, t0.matomo_js AS matomo_js_19, t0.matomo_tracker AS matomo_tracker_20, t0.google_map AS google_map_21, t0.maintenance AS maintenance_22, t0.logo AS logo_23, t0.fav_icon AS fav_icon_24, t0.contact_url AS contact_url_25, t0.contact_background AS contact_background_26, t0.contact_latitude AS contact_latitude_27, t0.contact_longitude AS contact_longitude_28, t0.type_map AS type_map_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.default_blog_image AS default_blog_image_32, t0.default_auction_image AS default_auction_image_33 FROM site t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zip AS zip_4,
  t0.city AS city_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.opening_hours AS opening_hours_8,
  t0.net_helium AS net_helium_9,
  t0.facebook AS facebook_10,
  t0.twitter AS twitter_11,
  t0.instagram AS instagram_12,
  t0.linkedin AS linkedin_13,
  t0.youtube AS youtube_14,
  t0.gta AS gta_15,
  t0.gtm AS gtm_16,
  t0.matomo AS matomo_17,
  t0.matomo_url AS matomo_url_18,
  t0.matomo_js AS matomo_js_19,
  t0.matomo_tracker AS matomo_tracker_20,
  t0.google_map AS google_map_21,
  t0.maintenance AS maintenance_22,
  t0.logo AS logo_23,
  t0.fav_icon AS fav_icon_24,
  t0.contact_url AS contact_url_25,
  t0.contact_background AS contact_background_26,
  t0.contact_latitude AS contact_latitude_27,
  t0.contact_longitude AS contact_longitude_28,
  t0.type_map AS type_map_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.default_blog_image AS default_blog_image_32,
  t0.default_auction_image AS default_auction_image_33
FROM
  site t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.matomo_url AS matomo_url_18, t0.matomo_js AS matomo_js_19, t0.matomo_tracker AS matomo_tracker_20, t0.google_map AS google_map_21, t0.maintenance AS maintenance_22, t0.logo AS logo_23, t0.fav_icon AS fav_icon_24, t0.contact_url AS contact_url_25, t0.contact_background AS contact_background_26, t0.contact_latitude AS contact_latitude_27, t0.contact_longitude AS contact_longitude_28, t0.type_map AS type_map_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.default_blog_image AS default_blog_image_32, t0.default_auction_image AS default_auction_image_33 FROM site t0 WHERE t0.id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Clockbox\Core\Service\SiteProvider->get (line 18)
5	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelController (line 37)
6	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelRequest (line 46)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.29 ms
(21.95%)

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_contact_zoom AS agence_contact_zoom_12, t0.breadcrumb AS breadcrumb_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.title AS title_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.affichage_menu AS affichage_menu_19, t0.slug AS slug_20, t0.display AS display_21, t0.no_index AS no_index_22, t0.parent_id AS parent_id_23 FROM page t0 WHERE t0.display = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.agence AS agence_2,
  t0.agence_address AS agence_address_3,
  t0.agence_zip AS agence_zip_4,
  t0.agence_city AS agence_city_5,
  t0.agence_email AS agence_email_6,
  t0.agence_phone AS agence_phone_7,
  t0.agence_opening_hours AS agence_opening_hours_8,
  t0.agence_contact_url AS agence_contact_url_9,
  t0.agence_contact_latitude AS agence_contact_latitude_10,
  t0.agence_contact_longitude AS agence_contact_longitude_11,
  t0.agence_contact_zoom AS agence_contact_zoom_12,
  t0.breadcrumb AS breadcrumb_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.title AS title_16,
  t0.meta_title AS meta_title_17,
  t0.meta_description AS meta_description_18,
  t0.affichage_menu AS affichage_menu_19,
  t0.slug AS slug_20,
  t0.display AS display_21,
  t0.no_index AS no_index_22,
  t0.parent_id AS parent_id_23
FROM
  page t0
WHERE
  t0.display = ?

SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_contact_zoom AS agence_contact_zoom_12, t0.breadcrumb AS breadcrumb_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.title AS title_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.affichage_menu AS affichage_menu_19, t0.slug AS slug_20, t0.display AS display_21, t0.no_index AS no_index_22, t0.parent_id AS parent_id_23 FROM page t0 WHERE t0.display = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Clockbox\Core\Service\PageProvider->getPagesOrderBySlugType (line 19)
5	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelController (line 39)
6	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelRequest (line 46)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.19 ms
(14.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter t0 WHERE t0.public = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.libelle AS libelle_4,
  t0.public AS public_5
FROM
  parameter t0
WHERE
  t0.public = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter t0 WHERE t0.public = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Clockbox\Core\Service\ParameterProvider->getAll (line 18)
5	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelController (line 40)
6	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelRequest (line 46)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.17 ms
(13.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter_module t0 WHERE t0.public = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.libelle AS libelle_4,
  t0.public AS public_5
FROM
  parameter_module t0
WHERE
  t0.public = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter_module t0 WHERE t0.public = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Clockbox\Core\Service\ParameterModuleProvider->getAll (line 18)
5	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelController (line 41)
6	Clockbox\Core\EventSubscriber\SiteSubscriber->onKernelRequest (line 46)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 208)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.14 ms
(10.70%)

SELECT t0.id AS id_1, t0.vignette_text AS vignette_text_2, t0.vignette_image AS vignette_image_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.breadcrumb AS breadcrumb_6, t0.sub_title AS sub_title_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.affichage_menu AS affichage_menu_13, t0.slug AS slug_14, t0.display AS display_15, t0.no_index AS no_index_16 FROM blog_article t0 WHERE t0.slug = ? AND t0.display = ? LIMIT 1

Parameters:

[
  "test-2"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.vignette_text AS vignette_text_2,
  t0.vignette_image AS vignette_image_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.breadcrumb AS breadcrumb_6,
  t0.sub_title AS sub_title_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.title AS title_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.affichage_menu AS affichage_menu_13,
  t0.slug AS slug_14,
  t0.display AS display_15,
  t0.no_index AS no_index_16
FROM
  blog_article t0
WHERE
  t0.slug = ?
  AND t0.display = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.vignette_text AS vignette_text_2, t0.vignette_image AS vignette_image_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.breadcrumb AS breadcrumb_6, t0.sub_title AS sub_title_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.affichage_menu AS affichage_menu_13, t0.slug AS slug_14, t0.display AS display_15, t0.no_index AS no_index_16 FROM blog_article t0 WHERE t0.slug = 'test-2' AND t0.display = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Clockbox\Blog\Controller\BlogController->show (line 32)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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\Page	20
App\Entity\Parameter	4
App\Entity\Site	1
Clockbox\Blog\Entity\BlogArticle	1

Entities Mapping

Class	Mapping errors
Clockbox\Core\Entity\Site	No errors.
App\Entity\Site	No errors.
Clockbox\Core\Entity\Page	No errors.
App\Entity\Page	No errors.
Clockbox\Core\Entity\PageSection	No errors.
App\Entity\PageSection	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on App\Entity\PageSection#blogCategories is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Parameter	No errors.
App\Entity\Parameter	No errors.
Clockbox\Core\Entity\ParameterModule	No errors.
App\Entity\ParameterModule	No errors.
Clockbox\Blog\Entity\BlogArticle	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on Clockbox\Blog\Entity\BlogArticle#categories is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Blog\Entity\BlogCategory	The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on Clockbox\Blog\Entity\BlogCategory#parent is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Blog\Entity\BlogArticleSection	The target entity 'Clockbox\Blog\Entity\BlogArticle' specified on Clockbox\Blog\Entity\BlogArticleSection#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.

Symfony Profiler

GET https://salorges-encheres.recette.agence-11h10.fr/blog/annonces/test-2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping