Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

99.84 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

50.25 ms
(50.33%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.locale = ? AND n0_.active = ? ORDER BY n0_.id DESC LIMIT 9 OFFSET 18

Parameters:

[
  "fr"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.summary AS summary_3,
  n0_.content AS content_4,
  n0_.content2 AS content2_5,
  n0_.nm AS nm_6,
  n0_.locale AS locale_7,
  n0_.aside AS aside_8,
  n0_.notes AS notes_9,
  n0_.mindate AS mindate_10,
  n0_.published_at AS published_at_11,
  n0_.active AS active_12,
  n0_.illustration AS illustration_13,
  n0_.illustration2 AS illustration2_14,
  n0_.illustration3 AS illustration3_15,
  n0_.user_id_id AS user_id_id_16
FROM
  news_post n0_
WHERE
  n0_.locale = ?
  AND n0_.active = ?
ORDER BY
  n0_.id DESC
LIMIT
  9
OFFSET
  18

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.locale = 'fr' AND n0_.active = 1 ORDER BY n0_.id DESC LIMIT 9 OFFSET 18;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 33)
7	App\Repository\NewsPostRepository->getAllPaginated (line 20)
8	App\Controller\NewsPostPublicController->allNewsPaginated (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)

24.85 ms
(24.88%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.active = ? AND n0_.locale = ? ORDER BY n0_.nm DESC LIMIT 2

Parameters:

[
  1
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.summary AS summary_3,
  n0_.content AS content_4,
  n0_.content2 AS content2_5,
  n0_.nm AS nm_6,
  n0_.locale AS locale_7,
  n0_.aside AS aside_8,
  n0_.notes AS notes_9,
  n0_.mindate AS mindate_10,
  n0_.published_at AS published_at_11,
  n0_.active AS active_12,
  n0_.illustration AS illustration_13,
  n0_.illustration2 AS illustration2_14,
  n0_.illustration3 AS illustration3_15,
  n0_.user_id_id AS user_id_id_16
FROM
  news_post n0_
WHERE
  n0_.active = ?
  AND n0_.locale = ?
ORDER BY
  n0_.nm DESC
LIMIT
  2

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.active = 1 AND n0_.locale = 'fr' ORDER BY n0_.nm DESC LIMIT 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 109)
6	App\Repository\NewsPostRepository->findLatest2Posts (line 85)
7	App\Controller\NewsPostPublicController->news2 (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 184)
15	__TwigTemplate_dc5c8ee9bb7eb238ecb40b0317c54ab7->doDisplay (line 388)
16	Twig\Template->yield (line 176)
17	__TwigTemplate_672c66e03ba1b167314361ba9a1937b8->doDisplay (line 388)
18	Twig\Template->yield (line 53)
19	__TwigTemplate_9a43214dc9a3a34e36dac74ea6017a4a->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 22)
28	App\Controller\NewsPostPublicController->allNewsPaginated (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

24.75 ms
(24.79%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15 FROM news_post n0_ WHERE n0_.locale = ? AND n0_.active = ? ORDER BY n0_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  "fr"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.title AS title_1,
          n0_.slug AS slug_2,
          n0_.summary AS summary_3,
          n0_.content AS content_4,
          n0_.content2 AS content2_5,
          n0_.nm AS nm_6,
          n0_.locale AS locale_7,
          n0_.aside AS aside_8,
          n0_.notes AS notes_9,
          n0_.mindate AS mindate_10,
          n0_.published_at AS published_at_11,
          n0_.active AS active_12,
          n0_.illustration AS illustration_13,
          n0_.illustration2 AS illustration2_14,
          n0_.illustration3 AS illustration3_15
        FROM
          news_post n0_
        WHERE
          n0_.locale = ?
          AND n0_.active = ?
        ORDER BY
          n0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15 FROM news_post n0_ WHERE n0_.locale = 'fr' AND n0_.active = 1 ORDER BY n0_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 36)
8	App\Repository\NewsPostRepository->getAllPaginated (line 20)
9	App\Controller\NewsPostPublicController->allNewsPaginated (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\NewsPost	No errors.
App\Entity\User	No errors.
App\Entity\Categorie	No errors.

Symfony Profiler

GET http://85.215.90.140:8082/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CNewsPostPublicController%253A%253Anews2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping