Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.73 ms Query time

3 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.61 ms
(58.98%)

SELECT t0.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.fa_icon AS fa_icon_4, t0.color AS color_5, t0.is_active AS is_active_6, t0.structure AS structure_7, t8.id_decheterie AS id_decheterie_9, t8.nom AS nom_10, t8.adresse AS adresse_11, t8.latitude AS latitude_12, t8.longitude AS longitude_13, t8.telephone AS telephone_14, t8.open_lun_matin AS open_lun_matin_15, t8.open_lun_aprem AS open_lun_aprem_16, t8.open_mar_matin AS open_mar_matin_17, t8.open_mar_aprem AS open_mar_aprem_18, t8.open_mer_matin AS open_mer_matin_19, t8.open_mer_aprem AS open_mer_aprem_20, t8.open_jeu_matin AS open_jeu_matin_21, t8.open_jeu_aprem AS open_jeu_aprem_22, t8.open_ven_matin AS open_ven_matin_23, t8.open_ven_aprem AS open_ven_aprem_24, t8.open_sam_matin AS open_sam_matin_25, t8.open_sam_aprem AS open_sam_aprem_26, t8.open_dim_matin AS open_dim_matin_27, t8.open_dim_aprem AS open_dim_aprem_28, t8.icon AS icon_29, t8.conditions_acces AS conditions_acces_30, t8.informations AS informations_31, t8.photo_1 AS photo_1_32, t8.photo_2 AS photo_2_33, t8.photo_3 AS photo_3_34, t8.visible AS visible_35, t8.id_tc_flux AS id_tc_flux_36, t8.id_tc_ville AS id_tc_ville_37 FROM gpso_flux_ou_prestation t0 LEFT JOIN decheterie t8 ON t8.id_tc_flux = t0.id_gpso_flux_ou_prestation WHERE t0.id_gpso_flux_ou_prestation = ?

Parameters:

[
  454
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.fa_icon AS fa_icon_4,
  t0.color AS color_5,
  t0.is_active AS is_active_6,
  t0.structure AS structure_7,
  t8.id_decheterie AS id_decheterie_9,
  t8.nom AS nom_10,
  t8.adresse AS adresse_11,
  t8.latitude AS latitude_12,
  t8.longitude AS longitude_13,
  t8.telephone AS telephone_14,
  t8.open_lun_matin AS open_lun_matin_15,
  t8.open_lun_aprem AS open_lun_aprem_16,
  t8.open_mar_matin AS open_mar_matin_17,
  t8.open_mar_aprem AS open_mar_aprem_18,
  t8.open_mer_matin AS open_mer_matin_19,
  t8.open_mer_aprem AS open_mer_aprem_20,
  t8.open_jeu_matin AS open_jeu_matin_21,
  t8.open_jeu_aprem AS open_jeu_aprem_22,
  t8.open_ven_matin AS open_ven_matin_23,
  t8.open_ven_aprem AS open_ven_aprem_24,
  t8.open_sam_matin AS open_sam_matin_25,
  t8.open_sam_aprem AS open_sam_aprem_26,
  t8.open_dim_matin AS open_dim_matin_27,
  t8.open_dim_aprem AS open_dim_aprem_28,
  t8.icon AS icon_29,
  t8.conditions_acces AS conditions_acces_30,
  t8.informations AS informations_31,
  t8.photo_1 AS photo_1_32,
  t8.photo_2 AS photo_2_33,
  t8.photo_3 AS photo_3_34,
  t8.visible AS visible_35,
  t8.id_tc_flux AS id_tc_flux_36,
  t8.id_tc_ville AS id_tc_ville_37
FROM
  gpso_flux_ou_prestation t0
  LEFT JOIN decheterie t8 ON t8.id_tc_flux = t0.id_gpso_flux_ou_prestation
WHERE
  t0.id_gpso_flux_ou_prestation = ?

SELECT t0.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.fa_icon AS fa_icon_4, t0.color AS color_5, t0.is_active AS is_active_6, t0.structure AS structure_7, t8.id_decheterie AS id_decheterie_9, t8.nom AS nom_10, t8.adresse AS adresse_11, t8.latitude AS latitude_12, t8.longitude AS longitude_13, t8.telephone AS telephone_14, t8.open_lun_matin AS open_lun_matin_15, t8.open_lun_aprem AS open_lun_aprem_16, t8.open_mar_matin AS open_mar_matin_17, t8.open_mar_aprem AS open_mar_aprem_18, t8.open_mer_matin AS open_mer_matin_19, t8.open_mer_aprem AS open_mer_aprem_20, t8.open_jeu_matin AS open_jeu_matin_21, t8.open_jeu_aprem AS open_jeu_aprem_22, t8.open_ven_matin AS open_ven_matin_23, t8.open_ven_aprem AS open_ven_aprem_24, t8.open_sam_matin AS open_sam_matin_25, t8.open_sam_aprem AS open_sam_aprem_26, t8.open_dim_matin AS open_dim_matin_27, t8.open_dim_aprem AS open_dim_aprem_28, t8.icon AS icon_29, t8.conditions_acces AS conditions_acces_30, t8.informations AS informations_31, t8.photo_1 AS photo_1_32, t8.photo_2 AS photo_2_33, t8.photo_3 AS photo_3_34, t8.visible AS visible_35, t8.id_tc_flux AS id_tc_flux_36, t8.id_tc_ville AS id_tc_ville_37 FROM gpso_flux_ou_prestation t0 LEFT JOIN decheterie t8 ON t8.id_tc_flux = t0.id_gpso_flux_ou_prestation WHERE t0.id_gpso_flux_ou_prestation = 454;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Flux::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Flux->__get (line 129)
7	App\Entity\Flux->getLibelle (line 96)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_afa95b8a2ce21a39749b41a3d507ef50::doDisplay (line 189)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1518)
15	__TwigTemplate_7ef99be2030599d695e33bc66905a69d::block_page (line 118)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_9b6068e96932d722c9912845b76c74b0->doDisplay (line 232)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_7ef99be2030599d695e33bc66905a69d->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
28	App\Controller\ActualitesController->showActualite (line 80)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

1.12 ms
(41.02%)

SELECT t0.id_actualite AS id_actualite_1, t0.titre AS titre_2, t0.date_publication AS date_publication_3, t0.photo_1 AS photo_1_4, t0.contenu AS contenu_5, t0.page_accueil AS page_accueil_6, t0.visible AS visible_7, t0.id_tc_flux AS id_tc_flux_8 FROM actualite t0 WHERE t0.id_actualite = ?

Parameters:

[
  42
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_actualite AS id_actualite_1,
  t0.titre AS titre_2,
  t0.date_publication AS date_publication_3,
  t0.photo_1 AS photo_1_4,
  t0.contenu AS contenu_5,
  t0.page_accueil AS page_accueil_6,
  t0.visible AS visible_7,
  t0.id_tc_flux AS id_tc_flux_8
FROM
  actualite t0
WHERE
  t0.id_actualite = ?

SELECT t0.id_actualite AS id_actualite_1, t0.titre AS titre_2, t0.date_publication AS date_publication_3, t0.photo_1 AS photo_1_4, t0.contenu AS contenu_5, t0.page_accueil AS page_accueil_6, t0.visible AS visible_7, t0.id_tc_flux AS id_tc_flux_8 FROM actualite t0 WHERE t0.id_actualite = 42;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\ActualitesController->showActualite (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (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\Actualite	1
App\Entity\Flux	1
App\Entity\Tc_structure	1
App\Entity\Decheterie	1
App\Entity\TcVille	1

Entities Mapping

Class	Mapping errors
App\Entity\Actualite	The association App\Entity\Actualite#villesRattachees refers to the inverse side field App\Entity\TcVille#actualitesRattachees which does not exist.
App\Entity\Flux	The association App\Entity\Flux#valorisations refers to the owning side field App\Entity\Valorisation#flux which does not exist.
App\Entity\TcVille	No errors.
App\Entity\Tc_structure	The mappings App\Entity\Tc_structure#TcSignalementFile and App\Entity\TcSignalementsFiles#tcStructure are inconsistent with each other.
App\Entity\Decheterie	No errors.
App\Entity\Objectif	No errors.
App\Entity\Pav	No errors.
App\Entity\Tonnage	No errors.
App\Entity\Valorisation	No errors.
App\Entity\Cout	No errors.

Symfony Profiler

GET http://demo-app.wastreet.app/actualites/42

Configuration Settings

Theme

Page Width