Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

9.19 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.36 ms

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM posts p0_ INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id INNER JOIN membres m2_ ON p0_.membre_id = m2_.id LEFT JOIN likes l3_ ON p0_.id = l3_.post_id LEFT JOIN files f4_ ON p0_.id = f4_.post_id WHERE m2_.is_public = ? AND (p0_.post_id = 0 OR p0_.post_id IS NULL) AND p0_.is_statut = 1 GROUP BY p0_.id

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  posts p0_
  INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id
  INNER JOIN membres m2_ ON p0_.membre_id = m2_.id
  LEFT JOIN likes l3_ ON p0_.id = l3_.post_id
  LEFT JOIN files f4_ ON p0_.id = f4_.post_id
WHERE
  m2_.is_public = ?
  AND (
    p0_.post_id = 0
    OR p0_.post_id IS NULL
  )
  AND p0_.is_statut = 1
GROUP BY
  p0_.id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM posts p0_ INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id INNER JOIN membres m2_ ON p0_.membre_id = m2_.id LEFT JOIN likes l3_ ON p0_.id = l3_.post_id LEFT JOIN files f4_ ON p0_.id = f4_.post_id WHERE m2_.is_public = 1 AND (p0_.post_id = 0 OR p0_.post_id IS NULL) AND p0_.is_statut = 1 GROUP BY p0_.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 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerA3VdKgt\PaginatorProxyBa079e5->paginate (line 76)
16	App\Repository\PostsRepository->getPostsFromPublicProfiles (line 73)
17	App\Controller\CloudsController->getPostsForPage (line 85)
18	App\Controller\CloudsController->index (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

6.45 ms

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM posts p0_ INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id INNER JOIN membres m2_ ON p0_.membre_id = m2_.id LEFT JOIN likes l3_ ON p0_.id = l3_.post_id LEFT JOIN files f4_ ON p0_.id = f4_.post_id WHERE m2_.is_public = ? AND (p0_.post_id = 0 OR p0_.post_id IS NULL) AND p0_.is_statut = 1 GROUP BY p0_.id ORDER BY p0_.created_at DESC LIMIT 10 OFFSET 30

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at AS created_at_1
FROM
  posts p0_
  INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id
  INNER JOIN membres m2_ ON p0_.membre_id = m2_.id
  LEFT JOIN likes l3_ ON p0_.id = l3_.post_id
  LEFT JOIN files f4_ ON p0_.id = f4_.post_id
WHERE
  m2_.is_public = ?
  AND (
    p0_.post_id = 0
    OR p0_.post_id IS NULL
  )
  AND p0_.is_statut = 1
GROUP BY
  p0_.id
ORDER BY
  p0_.created_at DESC
LIMIT
  10
OFFSET
  30

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM posts p0_ INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id INNER JOIN membres m2_ ON p0_.membre_id = m2_.id LEFT JOIN likes l3_ ON p0_.id = l3_.post_id LEFT JOIN files f4_ ON p0_.id = f4_.post_id WHERE m2_.is_public = 1 AND (p0_.post_id = 0 OR p0_.post_id IS NULL) AND p0_.is_statut = 1 GROUP BY p0_.id ORDER BY p0_.created_at DESC LIMIT 10 OFFSET 30;

#	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 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerA3VdKgt\PaginatorProxyBa079e5->paginate (line 76)
16	App\Repository\PostsRepository->getPostsFromPublicProfiles (line 73)
17	App\Controller\CloudsController->getPostsForPage (line 85)
18	App\Controller\CloudsController->index (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

2.17 ms

SELECT COUNT(l0_.id) AS sclr_0, p1_.id AS id_1, p1_.content AS content_2, p1_.created_at AS created_at_3, p1_.is_brouillon AS is_brouillon_4, p1_.adresseip AS adresseip_5, p1_.is_statut AS is_statut_6, c2_.id AS id_7, c2_.nom AS nom_8, c2_.ordre AS ordre_9, c2_.photo AS photo_10, m3_.id AS id_11, m3_.email AS email_12, m3_.username AS username_13, m3_.roles AS roles_14, m3_.password AS password_15, m3_.biographie AS biographie_16, m3_.money AS money_17, m3_.created_at AS created_at_18, m3_.updated_at AS updated_at_19, m3_.last_activity AS last_activity_20, m3_.naissance AS naissance_21, m3_.is_verified AS is_verified_22, m3_.is_public AS is_public_23, m3_.ip AS ip_24, m3_.lastip AS lastip_25, l0_.id AS id_26, l0_.ip_vote AS ip_vote_27, l0_.is_active AS is_active_28, f4_.id AS id_29, f4_.filename AS filename_30, f4_.title AS title_31, f4_.type AS type_32, p1_.membre_id AS membre_id_33, p1_.categorie_id AS categorie_id_34, p1_.post_id AS post_id_35, m3_.parrain_id AS parrain_id_36, l0_.membre_id AS membre_id_37, l0_.post_id AS post_id_38, f4_.membre_id AS membre_id_39, f4_.post_id AS post_id_40 FROM posts p1_ INNER JOIN categories c2_ ON p1_.categorie_id = c2_.id INNER JOIN membres m3_ ON p1_.membre_id = m3_.id LEFT JOIN likes l0_ ON p1_.id = l0_.post_id LEFT JOIN files f4_ ON p1_.id = f4_.post_id WHERE m3_.is_public = ? AND (p1_.post_id = 0 OR p1_.post_id IS NULL) AND p1_.is_statut = 1 AND p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p1_.id ORDER BY p1_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(l0_.id) AS sclr_0,
  p1_.id AS id_1,
  p1_.content AS content_2,
  p1_.created_at AS created_at_3,
  p1_.is_brouillon AS is_brouillon_4,
  p1_.adresseip AS adresseip_5,
  p1_.is_statut AS is_statut_6,
  c2_.id AS id_7,
  c2_.nom AS nom_8,
  c2_.ordre AS ordre_9,
  c2_.photo AS photo_10,
  m3_.id AS id_11,
  m3_.email AS email_12,
  m3_.username AS username_13,
  m3_.roles AS roles_14,
  m3_.password AS password_15,
  m3_.biographie AS biographie_16,
  m3_.money AS money_17,
  m3_.created_at AS created_at_18,
  m3_.updated_at AS updated_at_19,
  m3_.last_activity AS last_activity_20,
  m3_.naissance AS naissance_21,
  m3_.is_verified AS is_verified_22,
  m3_.is_public AS is_public_23,
  m3_.ip AS ip_24,
  m3_.lastip AS lastip_25,
  l0_.id AS id_26,
  l0_.ip_vote AS ip_vote_27,
  l0_.is_active AS is_active_28,
  f4_.id AS id_29,
  f4_.filename AS filename_30,
  f4_.title AS title_31,
  f4_.type AS type_32,
  p1_.membre_id AS membre_id_33,
  p1_.categorie_id AS categorie_id_34,
  p1_.post_id AS post_id_35,
  m3_.parrain_id AS parrain_id_36,
  l0_.membre_id AS membre_id_37,
  l0_.post_id AS post_id_38,
  f4_.membre_id AS membre_id_39,
  f4_.post_id AS post_id_40
FROM
  posts p1_
  INNER JOIN categories c2_ ON p1_.categorie_id = c2_.id
  INNER JOIN membres m3_ ON p1_.membre_id = m3_.id
  LEFT JOIN likes l0_ ON p1_.id = l0_.post_id
  LEFT JOIN files f4_ ON p1_.id = f4_.post_id
WHERE
  m3_.is_public = ?
  AND (
    p1_.post_id = 0
    OR p1_.post_id IS NULL
  )
  AND p1_.is_statut = 1
  AND p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  p1_.id
ORDER BY
  p1_.created_at DESC

SELECT COUNT(l0_.id) AS sclr_0, p1_.id AS id_1, p1_.content AS content_2, p1_.created_at AS created_at_3, p1_.is_brouillon AS is_brouillon_4, p1_.adresseip AS adresseip_5, p1_.is_statut AS is_statut_6, c2_.id AS id_7, c2_.nom AS nom_8, c2_.ordre AS ordre_9, c2_.photo AS photo_10, m3_.id AS id_11, m3_.email AS email_12, m3_.username AS username_13, m3_.roles AS roles_14, m3_.password AS password_15, m3_.biographie AS biographie_16, m3_.money AS money_17, m3_.created_at AS created_at_18, m3_.updated_at AS updated_at_19, m3_.last_activity AS last_activity_20, m3_.naissance AS naissance_21, m3_.is_verified AS is_verified_22, m3_.is_public AS is_public_23, m3_.ip AS ip_24, m3_.lastip AS lastip_25, l0_.id AS id_26, l0_.ip_vote AS ip_vote_27, l0_.is_active AS is_active_28, f4_.id AS id_29, f4_.filename AS filename_30, f4_.title AS title_31, f4_.type AS type_32, p1_.membre_id AS membre_id_33, p1_.categorie_id AS categorie_id_34, p1_.post_id AS post_id_35, m3_.parrain_id AS parrain_id_36, l0_.membre_id AS membre_id_37, l0_.post_id AS post_id_38, f4_.membre_id AS membre_id_39, f4_.post_id AS post_id_40 FROM posts p1_ INNER JOIN categories c2_ ON p1_.categorie_id = c2_.id INNER JOIN membres m3_ ON p1_.membre_id = m3_.id LEFT JOIN likes l0_ ON p1_.id = l0_.post_id LEFT JOIN files f4_ ON p1_.id = f4_.post_id WHERE m3_.is_public = 1 AND (p1_.post_id = 0 OR p1_.post_id IS NULL) AND p1_.is_statut = 1 AND p1_.id IN (3351, 3350, 3349, 3348, 3343, 3328, 3323, 3322, 3320, 3319) GROUP BY p1_.id ORDER BY p1_.created_at DESC;

#	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 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerA3VdKgt\PaginatorProxyBa079e5->paginate (line 76)
16	App\Repository\PostsRepository->getPostsFromPublicProfiles (line 73)
17	App\Controller\CloudsController->getPostsForPage (line 85)
18	App\Controller\CloudsController->index (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.21 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_9c93f4a3af6a3cdf105a3587a0094e6c->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 88)
30	App\Controller\CloudsController->index (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

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping