Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.16 ms Query time

5 Invalid entities

Queries

Group similar statements

#▲

Time

Info

3.92 ms

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM project p0_ WHERE p0_.category_id = ?

Parameters:

[
  "165"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  project p0_
WHERE
  p0_.category_id = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM project p0_ WHERE p0_.category_id = '165';

#	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 39)
16	App\Controller\Public\ProjectController->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.25 ms

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM project p0_ WHERE p0_.category_id = ? ORDER BY p0_.id DESC LIMIT 9

Parameters:

[
  "165"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  project p0_
WHERE
  p0_.category_id = ?
ORDER BY
  p0_.id DESC
LIMIT
  9

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM project p0_ WHERE p0_.category_id = '165' ORDER BY p0_.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 39)
16	App\Controller\Public\ProjectController->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\User	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.
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\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\Membership	No errors.
App\Entity\KycVerification	No errors.
App\Entity\PaymentMethod	No errors.
App\Entity\ProjectCategory	No errors.
App\Entity\ProjectUpdate	No errors.
App\Entity\ProjectReview	No errors.
App\Entity\ProjectFAQ	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\Earning	No errors.
App\Entity\EventDetails	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Event	No errors.
App\Entity\NewsCategory	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\Testimonial	No errors.
App\Entity\MainSlider	No errors.
App\Entity\SystemConfiguration	No errors.
App\Entity\PonctualDonation	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://preprod.abeillesolidaire.club/projects/?category=165

Configuration Settings

Theme