Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.17 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.61 ms
(52.36%)

SELECT
  g.id AS gallery_id,
  g.title AS gallery_title,
  g.type AS gallery_type,
  g.description AS gallery_description,
  g.slug AS gallery_slug,
  ph.id AS photo_id,
  ph.title AS photo_title,
  ph.picpath,
  ph.is_default,
  ph.order_photo
FROM gallery g
LEFT JOIN photos ph ON ph.gallery_id = g.id
WHERE g.projet_id = ?
  AND COALESCE(g.is_active, 0) = 1
ORDER BY g.id ASC, COALESCE(ph.order_photo, 999999) ASC, ph.id ASC

Parameters:

[
  27
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g.id AS gallery_id,
  g.title AS gallery_title,
  g.type AS gallery_type,
  g.description AS gallery_description,
  g.slug AS gallery_slug,
  ph.id AS photo_id,
  ph.title AS photo_title,
  ph.picpath,
  ph.is_default,
  ph.order_photo
FROM
  gallery g
  LEFT JOIN photos ph ON ph.gallery_id = g.id
WHERE
  g.projet_id = ?
  AND COALESCE(g.is_active, 0) = 1
ORDER BY
  g.id ASC,
  COALESCE(ph.order_photo, 999999) ASC,
  ph.id ASC

SELECT
  g.id AS gallery_id,
  g.title AS gallery_title,
  g.type AS gallery_type,
  g.description AS gallery_description,
  g.slug AS gallery_slug,
  ph.id AS photo_id,
  ph.title AS photo_title,
  ph.picpath,
  ph.is_default,
  ph.order_photo
FROM gallery g
LEFT JOIN photos ph ON ph.gallery_id = g.id
WHERE g.projet_id = 27
  AND COALESCE(g.is_active, 0) = 1
ORDER BY g.id ASC, COALESCE(ph.order_photo, 999999) ASC, ph.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Service\LegacyProjectService->getProjectGalleriesWithPhotos (line 263)
3	App\Controller\Front\MediathequeController->detail (line 35)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.56 ms
(47.64%)

SELECT
  p.id,
  p.slug,
  p.image,
  p.image2,
  p.champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu,
  COALESCE(pt.programme, ptfr.programme) AS programme,
  COALESCE(pt.partenaire, ptfr.partenaire) AS partenaire,
  COALESCE(pt.financement, ptfr.financement) AS financement,
  COALESCE(pt.champ7, ptfr.champ7) AS champ7,
  COALESCE(pt.budget, ptfr.budget) AS budget,
  COALESCE(pt.localisation, ptfr.localisation) AS localisation,
  COALESCE(pt.etat, ptfr.etat) AS etat,
  t.slug AS type_slug,
  t.color AS type_color,
  t.background AS type_background,
  COALESCE(tt.titre, ttfr.titre, '') AS type_titre
FROM projet p
INNER JOIN projettype t ON t.id = p.type_id
LEFT JOIN projet_translation pt   ON pt.id = p.id AND pt.lang = ?
LEFT JOIN projet_translation ptfr ON ptfr.id = p.id AND ptfr.lang = 'fr'
LEFT JOIN projettype_translation tt   ON tt.id = t.id AND tt.lang = ?
LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id AND ttfr.lang = 'fr'
WHERE p.is_publier = 1
  AND t.is_publier = 1
  AND p.slug = ?
LIMIT 1

Parameters:

[
  "fr"
  "fr"
  "centre-regional-de-la-musique-et-de-l-art-de-la-choregraphie-de-l-hermitage"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.id,
  p.slug,
  p.image,
  p.image2,
  p.champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu,
  COALESCE(pt.programme, ptfr.programme) AS programme,
  COALESCE(pt.partenaire, ptfr.partenaire) AS partenaire,
  COALESCE(
    pt.financement, ptfr.financement
  ) AS financement,
  COALESCE(pt.champ7, ptfr.champ7) AS champ7,
  COALESCE(pt.budget, ptfr.budget) AS budget,
  COALESCE(
    pt.localisation, ptfr.localisation
  ) AS localisation,
  COALESCE(pt.etat, ptfr.etat) AS etat,
  t.slug AS type_slug,
  t.color AS type_color,
  t.background AS type_background,
  COALESCE(tt.titre, ttfr.titre, '') AS type_titre
FROM
  projet p
  INNER JOIN projettype t ON t.id = p.type_id
  LEFT JOIN projet_translation pt ON pt.id = p.id
  AND pt.lang = ?
  LEFT JOIN projet_translation ptfr ON ptfr.id = p.id
  AND ptfr.lang = 'fr'
  LEFT JOIN projettype_translation tt ON tt.id = t.id
  AND tt.lang = ?
  LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id
  AND ttfr.lang = 'fr'
WHERE
  p.is_publier = 1
  AND t.is_publier = 1
  AND p.slug = ?
LIMIT
  1

SELECT
  p.id,
  p.slug,
  p.image,
  p.image2,
  p.champ11,
  COALESCE(pt.titre, ptfr.titre, '') AS titre,
  COALESCE(pt.contenu, ptfr.contenu) AS contenu,
  COALESCE(pt.programme, ptfr.programme) AS programme,
  COALESCE(pt.partenaire, ptfr.partenaire) AS partenaire,
  COALESCE(pt.financement, ptfr.financement) AS financement,
  COALESCE(pt.champ7, ptfr.champ7) AS champ7,
  COALESCE(pt.budget, ptfr.budget) AS budget,
  COALESCE(pt.localisation, ptfr.localisation) AS localisation,
  COALESCE(pt.etat, ptfr.etat) AS etat,
  t.slug AS type_slug,
  t.color AS type_color,
  t.background AS type_background,
  COALESCE(tt.titre, ttfr.titre, '') AS type_titre
FROM projet p
INNER JOIN projettype t ON t.id = p.type_id
LEFT JOIN projet_translation pt   ON pt.id = p.id AND pt.lang = 'fr'
LEFT JOIN projet_translation ptfr ON ptfr.id = p.id AND ptfr.lang = 'fr'
LEFT JOIN projettype_translation tt   ON tt.id = t.id AND tt.lang = 'fr'
LEFT JOIN projettype_translation ttfr ON ttfr.id = t.id AND ttfr.lang = 'fr'
WHERE p.is_publier = 1
  AND t.is_publier = 1
  AND p.slug = 'centre-regional-de-la-musique-et-de-l-art-de-la-choregraphie-de-l-hermitage'
LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 300)
2	App\Service\LegacyProjectService->getPublishedProjectBySlug (line 172)
3	App\Controller\Front\MediathequeController->detail (line 29)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	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

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://casasite-up.prowebplanners.com/fr/mediatheques/centre-regional-de-la-musique-et-de-l-art-de-la-choregraphie-de-l-hermitage

Configuration Settings

Theme

Page Width