Symfony Profiler

Query Metrics

14 Database Queries

13 Different statements

3.53 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.02 ms
(28.98%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC

Parameters:

[
  "2024-12-23 03:42:01"
  1
  "%0%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.date AS date_2,
  p0_.content AS content_3,
  p0_.image AS image_4,
  p0_.description AS description_5,
  p0_.parish AS parish_6,
  p0_.video AS video_7,
  p0_.vis AS vis_8,
  p0_.start_at AS start_at_9,
  p0_.highli AS highli_10
FROM
  posts p0_
WHERE
  p0_.start_at >= ?
  AND p0_.vis LIKE ?
  AND p0_.highli LIKE ?
ORDER BY
  p0_.start_at ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 03:42:01' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%' ORDER BY p0_.start_at ASC;

#	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 104)
7	App\Repository\PostsRepository->findAllHome (line 28)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.64 ms
(18.27%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_at_9 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ?) dctrn_result_inner ORDER BY start_at_9 ASC) dctrn_result LIMIT 7

Parameters:

[
  "2024-12-23 03:42:01"
  1
  "%0%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      start_at_9
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.title AS title_1,
          p0_.date AS date_2,
          p0_.content AS content_3,
          p0_.image AS image_4,
          p0_.description AS description_5,
          p0_.parish AS parish_6,
          p0_.video AS video_7,
          p0_.vis AS vis_8,
          p0_.start_at AS start_at_9,
          p0_.highli AS highli_10
        FROM
          posts p0_
        WHERE
          p0_.start_at >= ?
          AND p0_.vis LIKE ?
          AND p0_.highli LIKE ?
      ) dctrn_result_inner
    ORDER BY
      start_at_9 ASC
  ) dctrn_result
LIMIT
  7

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_at_9 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 03:42:01' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%') dctrn_result_inner ORDER BY start_at_9 ASC) dctrn_result LIMIT 7;

#	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 401)
8	__TwigTemplate_577b09aa8224f64e01d8086a7737c2e7->block_body (line 431)
9	Twig\Template->yieldBlock (line 523)
10	__TwigTemplate_dc8f60e77295f0376960049a07f80fbd->doDisplay (line 387)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_577b09aa8224f64e01d8086a7737c2e7->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 49)
21	App\Controller\HomeController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.39 ms
(11.10%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC) dctrn_result) dctrn_table

Parameters:

[
  "2024-12-23 03:42:01"
  1
  "%0%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.title AS title_1,
          p0_.date AS date_2,
          p0_.content AS content_3,
          p0_.image AS image_4,
          p0_.description AS description_5,
          p0_.parish AS parish_6,
          p0_.video AS video_7,
          p0_.vis AS vis_8,
          p0_.start_at AS start_at_9,
          p0_.highli AS highli_10
        FROM
          posts p0_
        WHERE
          p0_.start_at >= ?
          AND p0_.vis LIKE ?
          AND p0_.highli LIKE ?
        ORDER BY
          p0_.start_at ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 03:42:01' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%' ORDER BY p0_.start_at ASC) dctrn_result) dctrn_table;

#	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 38)
8	App\Services\PaginatorService->lastPage (line 29)
9	App\Controller\HomeController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.34 ms
(9.54%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.start_at ASC

Parameters:

[
  "2024-12-23 03:42:01"
  1
  "%0%"
  761
  738
  737
  727
  722
  754
  708
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.date AS date_2,
  p0_.content AS content_3,
  p0_.image AS image_4,
  p0_.description AS description_5,
  p0_.parish AS parish_6,
  p0_.video AS video_7,
  p0_.vis AS vis_8,
  p0_.start_at AS start_at_9,
  p0_.highli AS highli_10
FROM
  posts p0_
WHERE
  p0_.start_at >= ?
  AND p0_.vis LIKE ?
  AND p0_.highli LIKE ?
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.start_at ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 03:42:01' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%' AND p0_.id IN (761, 738, 737, 727, 722, 754, 708) ORDER BY p0_.start_at ASC;

#	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 401)
8	__TwigTemplate_577b09aa8224f64e01d8086a7737c2e7->block_body (line 431)
9	Twig\Template->yieldBlock (line 523)
10	__TwigTemplate_dc8f60e77295f0376960049a07f80fbd->doDisplay (line 387)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_577b09aa8224f64e01d8086a7737c2e7->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 49)
21	App\Controller\HomeController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.33 ms
(9.37%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC LIMIT 3 OFFSET 4

Parameters:

[
  "2024-12-23 03:42:01"
  1
  "%0%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.date AS date_2,
  p0_.content AS content_3,
  p0_.image AS image_4,
  p0_.description AS description_5,
  p0_.parish AS parish_6,
  p0_.video AS video_7,
  p0_.vis AS vis_8,
  p0_.start_at AS start_at_9,
  p0_.highli AS highli_10
FROM
  posts p0_
WHERE
  p0_.start_at >= ?
  AND p0_.vis LIKE ?
  AND p0_.highli LIKE ?
ORDER BY
  p0_.start_at ASC
LIMIT
  3
OFFSET
  4

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= '2024-12-23 03:42:01' AND p0_.vis LIKE 1 AND p0_.highli LIKE '%0%' ORDER BY p0_.start_at ASC LIMIT 3 OFFSET 4;

#	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 85)
7	App\Repository\PostsRepository->findAdditional (line 31)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.21 ms
(5.81%)

SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= ? ORDER BY d0_.date ASC LIMIT 5

Parameters:

[
  "2024-12-23 03:42:01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.date AS date_1,
  d0_.title AS title_2,
  d0_.description AS description_3,
  d0_.place AS place_4,
  d0_.file AS file_5,
  d0_.slug AS slug_6
FROM
  dates d0_
WHERE
  d0_.date >= ?
ORDER BY
  d0_.date ASC
LIMIT
  5

SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= '2024-12-23 03:42:01' ORDER BY d0_.date ASC LIMIT 5;

#	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 108)
7	App\Repository\DatesRepository->findSomeHome (line 33)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.15 ms
(4.11%)

SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= ? ORDER BY d0_.date ASC LIMIT 1

Parameters:

[
  "2024-12-23 03:42:01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.date AS date_1,
  d0_.title AS title_2,
  d0_.description AS description_3,
  d0_.place AS place_4,
  d0_.file AS file_5,
  d0_.slug AS slug_6
FROM
  dates d0_
WHERE
  d0_.date >= ?
ORDER BY
  d0_.date ASC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= '2024-12-23 03:42:01' ORDER BY d0_.date ASC LIMIT 1;

#	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 121)
7	App\Repository\DatesRepository->nextEvent (line 34)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.11 ms
(3.09%)

SELECT w0_.id AS id_0, w0_.sort AS sort_1, w0_.title AS title_2, w0_.content AS content_3, w0_.file AS file_4, w0_.slug AS slug_5 FROM wtw w0_ ORDER BY w0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.sort AS sort_1,
  w0_.title AS title_2,
  w0_.content AS content_3,
  w0_.file AS file_4,
  w0_.slug AS slug_5
FROM
  wtw w0_
ORDER BY
  w0_.sort ASC

SELECT w0_.id AS id_0, w0_.sort AS sort_1, w0_.title AS title_2, w0_.content AS content_3, w0_.file AS file_4, w0_.slug AS slug_5 FROM wtw w0_ ORDER BY w0_.sort ASC;

#	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 40)
7	App\Repository\WtwRepository->sortList (line 32)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.08 ms
(2.30%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.vis LIKE ? AND p0_.highli LIKE ? LIMIT 2

Parameters:

[
  "%1%"
  "%1%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.date AS date_2,
  p0_.content AS content_3,
  p0_.image AS image_4,
  p0_.description AS description_5,
  p0_.parish AS parish_6,
  p0_.video AS video_7,
  p0_.vis AS vis_8,
  p0_.start_at AS start_at_9,
  p0_.highli AS highli_10
FROM
  posts p0_
WHERE
  p0_.vis LIKE ?
  AND p0_.highli LIKE ?
LIMIT
  2

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.vis LIKE '%1%' AND p0_.highli LIKE '%1%' LIMIT 2;

#	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 141)
7	App\Repository\PostsRepository->highlight (line 42)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.07 ms
(2.07%)

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.description AS description_2,
  g0_.image AS image_3,
  g0_.video AS video_4,
  g0_.date AS date_5
FROM
  galary g0_
ORDER BY
  g0_.date DESC
LIMIT
  10

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 10;

#	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 51)
7	App\Repository\GalaryRepository->findSome (line 40)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.06 ms
(1.84%)

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.content AS content_2, l0_.file AS file_3 FROM laden l0_ ORDER BY l0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.content AS content_2,
  l0_.file AS file_3
FROM
  laden l0_
ORDER BY
  l0_.id DESC
LIMIT
  1

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.content AS content_2, l0_.file AS file_3 FROM laden l0_ ORDER BY l0_.id DESC LIMIT 1;

#	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 39)
7	App\Controller\HomeController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.06 ms
(1.84%)

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.content AS content_2, j0_.image AS image_3, j0_.create_at AS create_at_4, j0_.updated_at AS updated_at_5, j0_.sectioon AS sectioon_6, j0_.pdf AS pdf_7 FROM jobs j0_ ORDER BY j0_.create_at DESC LIMIT 2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.content AS content_2,
  j0_.image AS image_3,
  j0_.create_at AS create_at_4,
  j0_.updated_at AS updated_at_5,
  j0_.sectioon AS sectioon_6,
  j0_.pdf AS pdf_7
FROM
  jobs j0_
ORDER BY
  j0_.create_at DESC
LIMIT
  2

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.content AS content_2, j0_.image AS image_3, j0_.create_at AS create_at_4, j0_.updated_at AS updated_at_5, j0_.sectioon AS sectioon_6, j0_.pdf AS pdf_7 FROM jobs j0_ ORDER BY j0_.create_at DESC LIMIT 2;

#	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 47)
7	App\Controller\HomeController->index (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.06 ms
(1.69%)

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.description AS description_2,
  g0_.image AS image_3,
  g0_.video AS video_4,
  g0_.date AS date_5
FROM
  galary g0_
ORDER BY
  g0_.date DESC
LIMIT
  3

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 3;

#	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 60)
7	App\Repository\GalaryRepository->findSome3 (line 41)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\Posts	No errors.
App\Entity\Wtw	No errors.
App\Entity\Dates	No errors.
App\Entity\Laden	No errors.
App\Entity\Galary	No errors.
App\Entity\Jobs	No errors.

Symfony Profiler

GET https://85.214.117.201/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping