Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.21 ms Query time

0 Invalid entities

3 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

0.42 ms

SELECT s0_.name AS name_0, s0_.duration_months AS duration_months_1, s0_.price AS price_2, s0_.currency AS currency_3, s0_.features AS features_4, s0_.original_price AS original_price_5, s0_.badge AS badge_6, s0_.is_popular AS is_popular_7, s0_.offer_expires_at AS offer_expires_at_8, s0_.id AS id_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_enabled AS is_enabled_12, s0_.position AS position_13, s0_.last_position AS last_position_14 FROM subscription_plan s0_ WHERE (s0_.is_enabled = ?) AND (s0_.is_enabled = '1') ORDER BY s0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.duration_months AS duration_months_1,
  s0_.price AS price_2,
  s0_.currency AS currency_3,
  s0_.features AS features_4,
  s0_.original_price AS original_price_5,
  s0_.badge AS badge_6,
  s0_.is_popular AS is_popular_7,
  s0_.offer_expires_at AS offer_expires_at_8,
  s0_.id AS id_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.is_enabled AS is_enabled_12,
  s0_.position AS position_13,
  s0_.last_position AS last_position_14
FROM
  subscription_plan s0_
WHERE
  (s0_.is_enabled = ?)
  AND (s0_.is_enabled = '1')
ORDER BY
  s0_.position ASC

SELECT s0_.name AS name_0, s0_.duration_months AS duration_months_1, s0_.price AS price_2, s0_.currency AS currency_3, s0_.features AS features_4, s0_.original_price AS original_price_5, s0_.badge AS badge_6, s0_.is_popular AS is_popular_7, s0_.offer_expires_at AS offer_expires_at_8, s0_.id AS id_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_enabled AS is_enabled_12, s0_.position AS position_13, s0_.last_position AS last_position_14 FROM subscription_plan s0_ WHERE (s0_.is_enabled = 1) AND (s0_.is_enabled = '1') ORDER BY s0_.position ASC;

#	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->getResult (line 688)
6	App\Repository\Subscription\PlanRepository->findEnabledOrderedByPosition (line 49)
7	App\Feature\Subscription\Service\PlanService->getAvailablePlans (line 17)
8	App\EventSubscriber\InertiaSubscriber->onControllerEvent (line 40)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.48 ms

SELECT c0_.question AS question_0, c0_.answer AS answer_1, c0_.category AS category_2, c0_.views AS views_3, c0_.id AS id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.position AS position_7, c0_.last_position AS last_position_8, c0_.is_enabled AS is_enabled_9 FROM content_faq_entry c0_ WHERE (c0_.is_enabled = ?) AND (c0_.is_enabled = '1') ORDER BY c0_.views DESC, c0_.position ASC LIMIT 100

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.question AS question_0,
  c0_.answer AS answer_1,
  c0_.category AS category_2,
  c0_.views AS views_3,
  c0_.id AS id_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.position AS position_7,
  c0_.last_position AS last_position_8,
  c0_.is_enabled AS is_enabled_9
FROM
  content_faq_entry c0_
WHERE
  (c0_.is_enabled = ?)
  AND (c0_.is_enabled = '1')
ORDER BY
  c0_.views DESC,
  c0_.position ASC
LIMIT
  100

SELECT c0_.question AS question_0, c0_.answer AS answer_1, c0_.category AS category_2, c0_.views AS views_3, c0_.id AS id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.position AS position_7, c0_.last_position AS last_position_8, c0_.is_enabled AS is_enabled_9 FROM content_faq_entry c0_ WHERE (c0_.is_enabled = 1) AND (c0_.is_enabled = '1') ORDER BY c0_.views DESC, c0_.position ASC LIMIT 100;

#	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->getResult (line 688)
6	App\Feature\Content\Service\FaqService->search (line 44)
7	App\Controller\HomeController->index (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.31 ms

SELECT s0_.name AS name_0, s0_.duration_months AS duration_months_1, s0_.price AS price_2, s0_.currency AS currency_3, s0_.features AS features_4, s0_.original_price AS original_price_5, s0_.badge AS badge_6, s0_.is_popular AS is_popular_7, s0_.offer_expires_at AS offer_expires_at_8, s0_.id AS id_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_enabled AS is_enabled_12, s0_.position AS position_13, s0_.last_position AS last_position_14 FROM subscription_plan s0_ WHERE (s0_.is_enabled = ?) AND (s0_.is_enabled = '1') ORDER BY s0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.duration_months AS duration_months_1,
  s0_.price AS price_2,
  s0_.currency AS currency_3,
  s0_.features AS features_4,
  s0_.original_price AS original_price_5,
  s0_.badge AS badge_6,
  s0_.is_popular AS is_popular_7,
  s0_.offer_expires_at AS offer_expires_at_8,
  s0_.id AS id_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.is_enabled AS is_enabled_12,
  s0_.position AS position_13,
  s0_.last_position AS last_position_14
FROM
  subscription_plan s0_
WHERE
  (s0_.is_enabled = ?)
  AND (s0_.is_enabled = '1')
ORDER BY
  s0_.position ASC

SELECT s0_.name AS name_0, s0_.duration_months AS duration_months_1, s0_.price AS price_2, s0_.currency AS currency_3, s0_.features AS features_4, s0_.original_price AS original_price_5, s0_.badge AS badge_6, s0_.is_popular AS is_popular_7, s0_.offer_expires_at AS offer_expires_at_8, s0_.id AS id_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_enabled AS is_enabled_12, s0_.position AS position_13, s0_.last_position AS last_position_14 FROM subscription_plan s0_ WHERE (s0_.is_enabled = 1) AND (s0_.is_enabled = '1') ORDER BY s0_.position ASC;

#	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->getResult (line 688)
6	App\Repository\Subscription\PlanRepository->findEnabledOrderedByPosition (line 49)
7	App\Feature\Subscription\Service\PlanService->getAvailablePlans (line 17)
8	App\Controller\HomeController->index (line 36)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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
App\Entity\Content\FaqEntry	3

Entities Mapping

Class	Mapping errors
App\Entity\Subscription\Plan	No errors.
App\Entity\Content\FaqEntry	No errors.

Symfony Profiler

GET https://reussirlexamencivique.webconnectia.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping