Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

9.10 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.96 ms
(32.49%)

SELECT n.* FROM news_article n WHERE n.tags::jsonb @> ?

Parameters:

[
  "["Legal"]"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n.*
FROM
  news_article n
WHERE
  n.tags :: jsonb @ > ?

SELECT n.* FROM news_article n WHERE n.tags::jsonb @> '[\"Legal\"]';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 74)
2	App\Repository\NewsArticleRepository->getPaginatedByTag (line 118)
3	App\Controller\Public\NewsController->byTag (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
6	Symfony\Component\HttpKernel\Kernel->handle (line 38)
7	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
8	frankenphp_handle_request (line 45)
9	Runtime\FrankenPhpSymfony\Runner->run (line 29)
10	require_once (line 7)

1.85 ms
(20.31%)

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM news_article n0_ WHERE n0_.id IN (?)

Parameters:

[
  134
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT n0_.id) AS sclr_0
FROM
  news_article n0_
WHERE
  n0_.id IN (?)

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM news_article n0_ WHERE n0_.id IN (134);

#	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 89)
16	App\Repository\NewsArticleRepository->getPaginatedByTag (line 118)
17	App\Controller\Public\NewsController->byTag (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 38)
21	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
22	frankenphp_handle_request (line 45)
23	Runtime\FrankenPhpSymfony\Runner->run (line 29)
24	require_once (line 7)

1.70 ms
(18.66%)

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.slug AS slug_2 FROM news_category n0_ ORDER BY n0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.slug AS slug_2
FROM
  news_category n0_
ORDER BY
  n0_.name ASC

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.slug AS slug_2 FROM news_category n0_ ORDER BY n0_.name ASC;

#	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 43)
7	App\Repository\NewsCategoryRepository->findByOrderedByName (line 130)
8	App\Controller\Public\NewsController->byTag (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 38)
12	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
13	frankenphp_handle_request (line 45)
14	Runtime\FrankenPhpSymfony\Runner->run (line 29)
15	require_once (line 7)

1.35 ms
(14.87%)

SELECT DISTINCT n0_.id AS id_0, n0_.created_at AS created_at_1 FROM news_article n0_ WHERE n0_.id IN (?) ORDER BY n0_.created_at DESC LIMIT 6

Parameters:

[
  134
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.created_at AS created_at_1
FROM
  news_article n0_
WHERE
  n0_.id IN (?)
ORDER BY
  n0_.created_at DESC
LIMIT
  6

SELECT DISTINCT n0_.id AS id_0, n0_.created_at AS created_at_1 FROM news_article n0_ WHERE n0_.id IN (134) ORDER BY n0_.created_at DESC LIMIT 6;

#	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 89)
16	App\Repository\NewsArticleRepository->getPaginatedByTag (line 118)
17	App\Controller\Public\NewsController->byTag (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 38)
21	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
22	frankenphp_handle_request (line 45)
23	Runtime\FrankenPhpSymfony\Runner->run (line 29)
24	require_once (line 7)

0.65 ms
(7.10%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ ORDER BY n0_.created_at DESC LIMIT 3

Parameters:

[]

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_.image AS image_3,
  n0_.excerpt AS excerpt_4,
  n0_.content AS content_5,
  n0_.author AS author_6,
  n0_.comments_count AS comments_count_7,
  n0_.tags AS tags_8,
  n0_.created_at AS created_at_9,
  n0_.updated_at AS updated_at_10,
  n0_.category_id AS category_id_11
FROM
  news_article n0_
ORDER BY
  n0_.created_at DESC
LIMIT
  3

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ ORDER BY n0_.created_at DESC LIMIT 3;

#	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 28)
7	App\Repository\NewsArticleRepository->findLatest (line 129)
8	App\Controller\Public\NewsController->byTag (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 38)
12	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
13	frankenphp_handle_request (line 45)
14	Runtime\FrankenPhpSymfony\Runner->run (line 29)
15	require_once (line 7)

0.60 ms
(6.57%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ WHERE n0_.id IN (?) AND n0_.id IN (?) ORDER BY n0_.created_at DESC

Parameters:

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_.image AS image_3,
  n0_.excerpt AS excerpt_4,
  n0_.content AS content_5,
  n0_.author AS author_6,
  n0_.comments_count AS comments_count_7,
  n0_.tags AS tags_8,
  n0_.created_at AS created_at_9,
  n0_.updated_at AS updated_at_10,
  n0_.category_id AS category_id_11
FROM
  news_article n0_
WHERE
  n0_.id IN (?)
  AND n0_.id IN (?)
ORDER BY
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ WHERE n0_.id IN (134) AND n0_.id IN (134) ORDER BY n0_.created_at 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 89)
16	App\Repository\NewsArticleRepository->getPaginatedByTag (line 118)
17	App\Controller\Public\NewsController->byTag (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 38)
21	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
22	frankenphp_handle_request (line 45)
23	Runtime\FrankenPhpSymfony\Runner->run (line 29)
24	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\MainSlider	No errors.
App\Entity\ProjectCategory	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\User	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\Earning	No errors.
App\Entity\ProjectUpdate	No errors.
App\Entity\ProjectReview	No errors.
App\Entity\ProjectFAQ	No errors.
App\Entity\Testimonial	No errors.
App\Entity\NewsArticle	No errors.
App\Entity\NewsCategory	No errors.
App\Entity\Comment	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\Membership	No errors.
App\Entity\KycVerification	No errors.
App\Entity\PaymentMethod	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\EventDetails	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Event	No errors.
App\Entity\Service	No errors.
App\Entity\EventCategory	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\SystemConfiguration	No errors.
App\Entity\PonctualDonation	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://preprod.abeillesolidaire.club/news/tag/Legal

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping