Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

4.98 ms Query time

3 Invalid entities

113 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.08 ms
(41.84%)

SELECT a0_.id_actualite AS id_actualite_0, a0_.titre AS titre_1, a0_.date_publication AS date_publication_2, a0_.photo_1 AS photo_1_3, a0_.contenu AS contenu_4, a0_.page_accueil AS page_accueil_5, a0_.visible AS visible_6, a0_.id_tc_flux AS id_tc_flux_7 FROM actualite a0_ LEFT JOIN gpso_flux_ou_prestation g1_ ON a0_.id_tc_flux = g1_.id_gpso_flux_ou_prestation LEFT JOIN tc_structure t2_ ON g1_.structure = t2_.id_tc_structure WHERE a0_.visible = ? AND a0_.date_publication <= CURRENT_TIMESTAMP AND ((g1_.id_gpso_flux_ou_prestation IS NULL) OR (g1_.id_gpso_flux_ou_prestation IS NOT NULL AND t2_.id_tc_structure = ?)) ORDER BY a0_.date_publication DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id_actualite AS id_actualite_0,
  a0_.titre AS titre_1,
  a0_.date_publication AS date_publication_2,
  a0_.photo_1 AS photo_1_3,
  a0_.contenu AS contenu_4,
  a0_.page_accueil AS page_accueil_5,
  a0_.visible AS visible_6,
  a0_.id_tc_flux AS id_tc_flux_7
FROM
  actualite a0_
  LEFT JOIN gpso_flux_ou_prestation g1_ ON a0_.id_tc_flux = g1_.id_gpso_flux_ou_prestation
  LEFT JOIN tc_structure t2_ ON g1_.structure = t2_.id_tc_structure
WHERE
  a0_.visible = ?
  AND a0_.date_publication <= CURRENT_TIMESTAMP
  AND (
    (
      g1_.id_gpso_flux_ou_prestation IS NULL
    )
    OR (
      g1_.id_gpso_flux_ou_prestation IS NOT NULL
      AND t2_.id_tc_structure = ?
    )
  )
ORDER BY
  a0_.date_publication DESC

SELECT a0_.id_actualite AS id_actualite_0, a0_.titre AS titre_1, a0_.date_publication AS date_publication_2, a0_.photo_1 AS photo_1_3, a0_.contenu AS contenu_4, a0_.page_accueil AS page_accueil_5, a0_.visible AS visible_6, a0_.id_tc_flux AS id_tc_flux_7 FROM actualite a0_ LEFT JOIN gpso_flux_ou_prestation g1_ ON a0_.id_tc_flux = g1_.id_gpso_flux_ou_prestation LEFT JOIN tc_structure t2_ ON g1_.structure = t2_.id_tc_structure WHERE a0_.visible = 1 AND a0_.date_publication <= CURRENT_TIMESTAMP AND ((g1_.id_gpso_flux_ou_prestation IS NULL) OR (g1_.id_gpso_flux_ou_prestation IS NOT NULL AND t2_.id_tc_structure = 102)) ORDER BY a0_.date_publication DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActualiteRepository->findAllVisibles (line 54)
7	App\Controller\ActualitesController->index (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.87 ms
(37.57%)

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:

[
  443
]

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 = 443;

#	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 152)
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_d1a61a4be7c489c0ed89da1223fcda28::doDisplay (line 76)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_bfa284fdf5eb82679f8daac9e0788292->block_page (line 203)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_9b6068e96932d722c9912845b76c74b0->doDisplay (line 232)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_bfa284fdf5eb82679f8daac9e0788292->doDisplay (line 56)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
30	App\Controller\ActualitesController->index (line 40)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 182)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

1.02 ms
(20.59%)

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.libelle AS libelle_1 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = ?

Parameters:

[
  102
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.libelle AS libelle_1
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.libelle AS libelle_1 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\FluxRepository->findIdAndLibelle (line 29)
7	App\Controller\ActualitesController->index (line 35)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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	108
App\Entity\Flux	2
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\Tc_structure	The mappings App\Entity\Tc_structure#TcSignalementFile and App\Entity\TcSignalementsFiles#tcStructure are inconsistent with each other.
App\Entity\TcVille	No errors.
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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping