Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.63 ms Query time

0 Invalid entities

0 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

0.63 ms
(100.00%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_9 FROM (SELECT d0_.Email AS Email_0, d0_.StatusPrivate AS StatusPrivate_1, d0_.created AS created_2, d0_.Amount AS Amount_3, d0_.Money AS Money_4, d0_.namegiven AS namegiven_5, d0_.referencepaypal AS referencepaypal_6, d0_.membercomment AS membercomment_7, d0_.SystemComment AS SystemComment_8, d0_.id AS id_9 FROM donations d0_ ORDER BY d0_.created DESC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_9
    FROM
      (
        SELECT
          d0_.Email AS Email_0,
          d0_.StatusPrivate AS StatusPrivate_1,
          d0_.created AS created_2,
          d0_.Amount AS Amount_3,
          d0_.Money AS Money_4,
          d0_.namegiven AS namegiven_5,
          d0_.referencepaypal AS referencepaypal_6,
          d0_.membercomment AS membercomment_7,
          d0_.SystemComment AS SystemComment_8,
          d0_.id AS id_9
        FROM
          donations d0_
        ORDER BY
          d0_.created DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_9 FROM (SELECT d0_.Email AS Email_0, d0_.StatusPrivate AS StatusPrivate_1, d0_.created AS created_2, d0_.Amount AS Amount_3, d0_.Money AS Money_4, d0_.namegiven AS namegiven_5, d0_.referencepaypal AS referencepaypal_6, d0_.membercomment AS membercomment_7, d0_.SystemComment AS SystemComment_8, d0_.id AS id_9 FROM donations d0_ ORDER BY d0_.created DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 42)
8	Pagerfanta\Pagerfanta->getNbResults (line 292)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_a3efd8562dca66b5e424aa9e5862f7dd::block_content (line 111)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_15b4049db828b741b516f19e68860129->{closure:__TwigTemplate_15b4049db828b741b516f19e68860129::block_main():273} (line 391)
13	Twig\Extension\CoreExtension->captureOutput (line 2108)
14	__TwigTemplate_15b4049db828b741b516f19e68860129::block_main (line 273)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_15b4049db828b741b516f19e68860129->doDisplay (line 154)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_a3efd8562dca66b5e424aa9e5862f7dd->doDisplay (line 54)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
27	App\Controller\DonationController->listDonations (line 98)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 191)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Donation	No errors.

Symfony Profiler

GET https://alpha.stage.bewelcome.org/donations/list

Configuration Settings

Theme

Page Width