Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.44 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.12 ms

SELECT COUNT(DISTINCT l0_.id) AS sclr_0, (SELECT COUNT(p1_.id) AS sclr_2 FROM posts p1_ WHERE p1_.post_id = p2_.id) AS sclr_1, 0 AS sclr_3, p2_.id AS id_4, p2_.content AS content_5, p2_.created_at AS created_at_6, p2_.is_brouillon AS is_brouillon_7, p2_.adresseip AS adresseip_8, p2_.is_statut AS is_statut_9, c3_.id AS id_10, c3_.nom AS nom_11, c3_.ordre AS ordre_12, c3_.photo AS photo_13, m4_.id AS id_14, m4_.email AS email_15, m4_.username AS username_16, m4_.roles AS roles_17, m4_.password AS password_18, m4_.biographie AS biographie_19, m4_.money AS money_20, m4_.created_at AS created_at_21, m4_.updated_at AS updated_at_22, m4_.last_activity AS last_activity_23, m4_.naissance AS naissance_24, m4_.is_verified AS is_verified_25, m4_.is_public AS is_public_26, m4_.ip AS ip_27, m4_.lastip AS lastip_28, l0_.id AS id_29, l0_.ip_vote AS ip_vote_30, l0_.is_active AS is_active_31, f5_.id AS id_32, f5_.filename AS filename_33, f5_.title AS title_34, f5_.type AS type_35, p2_.membre_id AS membre_id_36, p2_.categorie_id AS categorie_id_37, p2_.post_id AS post_id_38, m4_.parrain_id AS parrain_id_39, l0_.membre_id AS membre_id_40, l0_.post_id AS post_id_41, f5_.membre_id AS membre_id_42, f5_.post_id AS post_id_43 FROM posts p2_ INNER JOIN categories c3_ ON p2_.categorie_id = c3_.id INNER JOIN membres m4_ ON p2_.membre_id = m4_.id LEFT JOIN likes l0_ ON p2_.id = l0_.post_id LEFT JOIN files f5_ ON p2_.id = f5_.post_id WHERE p2_.id = ? AND (p2_.post_id = 0 OR p2_.post_id IS NULL) AND p2_.is_statut = 1 GROUP BY p2_.id

Parameters:

[
  3393
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT l0_.id) AS sclr_0,
  (
    SELECT
      COUNT(p1_.id) AS sclr_2
    FROM
      posts p1_
    WHERE
      p1_.post_id = p2_.id
  ) AS sclr_1,
  0 AS sclr_3,
  p2_.id AS id_4,
  p2_.content AS content_5,
  p2_.created_at AS created_at_6,
  p2_.is_brouillon AS is_brouillon_7,
  p2_.adresseip AS adresseip_8,
  p2_.is_statut AS is_statut_9,
  c3_.id AS id_10,
  c3_.nom AS nom_11,
  c3_.ordre AS ordre_12,
  c3_.photo AS photo_13,
  m4_.id AS id_14,
  m4_.email AS email_15,
  m4_.username AS username_16,
  m4_.roles AS roles_17,
  m4_.password AS password_18,
  m4_.biographie AS biographie_19,
  m4_.money AS money_20,
  m4_.created_at AS created_at_21,
  m4_.updated_at AS updated_at_22,
  m4_.last_activity AS last_activity_23,
  m4_.naissance AS naissance_24,
  m4_.is_verified AS is_verified_25,
  m4_.is_public AS is_public_26,
  m4_.ip AS ip_27,
  m4_.lastip AS lastip_28,
  l0_.id AS id_29,
  l0_.ip_vote AS ip_vote_30,
  l0_.is_active AS is_active_31,
  f5_.id AS id_32,
  f5_.filename AS filename_33,
  f5_.title AS title_34,
  f5_.type AS type_35,
  p2_.membre_id AS membre_id_36,
  p2_.categorie_id AS categorie_id_37,
  p2_.post_id AS post_id_38,
  m4_.parrain_id AS parrain_id_39,
  l0_.membre_id AS membre_id_40,
  l0_.post_id AS post_id_41,
  f5_.membre_id AS membre_id_42,
  f5_.post_id AS post_id_43
FROM
  posts p2_
  INNER JOIN categories c3_ ON p2_.categorie_id = c3_.id
  INNER JOIN membres m4_ ON p2_.membre_id = m4_.id
  LEFT JOIN likes l0_ ON p2_.id = l0_.post_id
  LEFT JOIN files f5_ ON p2_.id = f5_.post_id
WHERE
  p2_.id = ?
  AND (
    p2_.post_id = 0
    OR p2_.post_id IS NULL
  )
  AND p2_.is_statut = 1
GROUP BY
  p2_.id

SELECT COUNT(DISTINCT l0_.id) AS sclr_0, (SELECT COUNT(p1_.id) AS sclr_2 FROM posts p1_ WHERE p1_.post_id = p2_.id) AS sclr_1, 0 AS sclr_3, p2_.id AS id_4, p2_.content AS content_5, p2_.created_at AS created_at_6, p2_.is_brouillon AS is_brouillon_7, p2_.adresseip AS adresseip_8, p2_.is_statut AS is_statut_9, c3_.id AS id_10, c3_.nom AS nom_11, c3_.ordre AS ordre_12, c3_.photo AS photo_13, m4_.id AS id_14, m4_.email AS email_15, m4_.username AS username_16, m4_.roles AS roles_17, m4_.password AS password_18, m4_.biographie AS biographie_19, m4_.money AS money_20, m4_.created_at AS created_at_21, m4_.updated_at AS updated_at_22, m4_.last_activity AS last_activity_23, m4_.naissance AS naissance_24, m4_.is_verified AS is_verified_25, m4_.is_public AS is_public_26, m4_.ip AS ip_27, m4_.lastip AS lastip_28, l0_.id AS id_29, l0_.ip_vote AS ip_vote_30, l0_.is_active AS is_active_31, f5_.id AS id_32, f5_.filename AS filename_33, f5_.title AS title_34, f5_.type AS type_35, p2_.membre_id AS membre_id_36, p2_.categorie_id AS categorie_id_37, p2_.post_id AS post_id_38, m4_.parrain_id AS parrain_id_39, l0_.membre_id AS membre_id_40, l0_.post_id AS post_id_41, f5_.membre_id AS membre_id_42, f5_.post_id AS post_id_43 FROM posts p2_ INNER JOIN categories c3_ ON p2_.categorie_id = c3_.id INNER JOIN membres m4_ ON p2_.membre_id = m4_.id LEFT JOIN likes l0_ ON p2_.id = l0_.post_id LEFT JOIN files f5_ ON p2_.id = f5_.post_id WHERE p2_.id = 3393 AND (p2_.post_id = 0 OR p2_.post_id IS NULL) AND p2_.is_statut = 1 GROUP BY p2_.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 172)
7	App\Repository\PostsRepository->displayPostWithId (line 202)
8	App\Controller\CloudsController->post (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.32 ms

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.ordre AS ordre_2, c0_.photo AS photo_3 FROM categories c0_ ORDER BY c0_.nom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.ordre AS ordre_2,
  c0_.photo AS photo_3
FROM
  categories c0_
ORDER BY
  c0_.nom ASC

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.ordre AS ordre_2, c0_.photo AS photo_3 FROM categories c0_ ORDER BY c0_.nom ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1157)
3	Doctrine\DBAL\Connection->executeCacheQuery (line 1084)
4	Doctrine\DBAL\Connection->executeQuery (line 31)
5	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
6	Doctrine\ORM\Query->_doExecute (line 1218)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
8	Doctrine\ORM\AbstractQuery->execute (line 907)
9	Doctrine\ORM\AbstractQuery->getResult (line 51)
10	App\Repository\CategoriesRepository->findAllCached (line 23)
11	App\Controller\HeaderController->index (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
15	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
16	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
17	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
18	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 77)
19	__TwigTemplate_7a254d1e0c9da7e0e12f8974b3675912->doDisplay (line 388)
20	Twig\Template->yield (line 54)
21	__TwigTemplate_0ce9d1445d1106070fd2db66ff7dccdc->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 231)
30	App\Controller\CloudsController->post (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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.

Entities Mapping

Class	Mapping errors
App\Entity\Posts	No errors.
App\Entity\Categories	No errors.
App\Entity\Membres	No errors.
App\Entity\Likes	No errors.
App\Entity\Files	No errors.
App\Entity\Messages	No errors.
App\Entity\Friends	No errors.

Symfony Profiler

GET https://www.waluu.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CHeaderController%253A%253Aindex

Configuration Settings

Theme