Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.33 ms Query time

5 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.61 ms

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cause c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  cause c0_

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM cause c0_;

#	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 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	ContainerNKBxkXH\PaginatorProxyBa079e5->paginate (line 40)
16	App\Controller\Public\CauseController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 38)
20	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
21	frankenphp_handle_request (line 45)
22	Runtime\FrankenPhpSymfony\Runner->run (line 29)
23	require_once (line 7)

0.62 ms

SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM cause c0_ ORDER BY c0_.id DESC LIMIT 9

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.id AS id_1
FROM
  cause c0_
ORDER BY
  c0_.id DESC
LIMIT
  9

SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM cause c0_ ORDER BY c0_.id DESC LIMIT 9;

#	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 127)
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	ContainerNKBxkXH\PaginatorProxyBa079e5->paginate (line 40)
16	App\Controller\Public\CauseController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 38)
20	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
21	frankenphp_handle_request (line 45)
22	Runtime\FrankenPhpSymfony\Runner->run (line 29)
23	require_once (line 7)

1.10 ms

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.goal AS goal_5, c0_.image AS image_6, c0_.pledged AS pledged_7, c0_.status AS status_8, c0_.slug AS slug_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11 FROM cause c0_ WHERE c0_.id IN (?, ?) ORDER BY c0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.start_date AS start_date_3,
  c0_.end_date AS end_date_4,
  c0_.goal AS goal_5,
  c0_.image AS image_6,
  c0_.pledged AS pledged_7,
  c0_.status AS status_8,
  c0_.slug AS slug_9,
  c0_.created_at AS created_at_10,
  c0_.updated_at AS updated_at_11
FROM
  cause c0_
WHERE
  c0_.id IN (?, ?)
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.goal AS goal_5, c0_.image AS image_6, c0_.pledged AS pledged_7, c0_.status AS status_8, c0_.slug AS slug_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11 FROM cause c0_ WHERE c0_.id IN (4, 3) ORDER BY c0_.id DESC;

#	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 145)
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	ContainerNKBxkXH\PaginatorProxyBa079e5->paginate (line 40)
16	App\Controller\Public\CauseController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 38)
20	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
21	frankenphp_handle_request (line 45)
22	Runtime\FrankenPhpSymfony\Runner->run (line 29)
23	require_once (line 7)

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\Membership	No errors.
App\Entity\User	No errors.
App\Entity\Flower	The field 'App\Entity\Flower#donationAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PaymentMethod	No errors.
App\Entity\EventDetails	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Earning	No errors.
App\Entity\Event	No errors.
App\Entity\KycVerification	No errors.
App\Entity\NewsCategory	No errors.
App\Entity\ProjectCategory	No errors.
App\Entity\Service	No errors.
App\Entity\EventCategory	No errors.
App\Entity\Comment	No errors.
App\Entity\FAQ	No errors.
App\Entity\Cause	The field 'App\Entity\Cause#pledged' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\EventContent	No errors.
App\Entity\NewsArticle	No errors.
App\Entity\ProjectFAQ	No errors.
App\Entity\Donation	The field 'App\Entity\Donation#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ProjectReview	No errors.
App\Entity\Testimonial	No errors.
App\Entity\Withdrawal	The field 'App\Entity\Withdrawal#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Withdrawal#feeAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Withdrawal#cryptoAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\MainSlider	No errors.
App\Entity\SystemConfiguration	No errors.
App\Entity\ProjectUpdate	No errors.
App\Entity\PonctualDonation	No errors.
App\Entity\Project	The field 'App\Entity\Project#goal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Project#pledged' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://preprod.abeillesolidaire.club/cause/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping