Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.94 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.35 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.short_description AS short_description_3, s0_.description AS description_4, s0_.image AS image_5, s0_.video_url AS video_url_6, s0_.pricing_type AS pricing_type_7, s0_.billing_mode AS billing_mode_8, s0_.price AS price_9, s0_.recurring_interval AS recurring_interval_10, s0_.min_engagement_months AS min_engagement_months_11, s0_.promo_price AS promo_price_12, s0_.promo_ends_at AS promo_ends_at_13, s0_.is_pack AS is_pack_14, s0_.is_published AS is_published_15, s0_.is_featured AS is_featured_16, s0_.position AS position_17, s0_.stripe_price_id AS stripe_price_id_18, s0_.stripe_promo_price_id AS stripe_promo_price_id_19, s0_.created_at AS created_at_20, s0_.updated_at AS updated_at_21 FROM service s0_ WHERE s0_.is_published = 1 AND s0_.is_featured = 1 ORDER BY s0_.position ASC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.short_description AS short_description_3,
  s0_.description AS description_4,
  s0_.image AS image_5,
  s0_.video_url AS video_url_6,
  s0_.pricing_type AS pricing_type_7,
  s0_.billing_mode AS billing_mode_8,
  s0_.price AS price_9,
  s0_.recurring_interval AS recurring_interval_10,
  s0_.min_engagement_months AS min_engagement_months_11,
  s0_.promo_price AS promo_price_12,
  s0_.promo_ends_at AS promo_ends_at_13,
  s0_.is_pack AS is_pack_14,
  s0_.is_published AS is_published_15,
  s0_.is_featured AS is_featured_16,
  s0_.position AS position_17,
  s0_.stripe_price_id AS stripe_price_id_18,
  s0_.stripe_promo_price_id AS stripe_promo_price_id_19,
  s0_.created_at AS created_at_20,
  s0_.updated_at AS updated_at_21
FROM
  service s0_
WHERE
  s0_.is_published = 1
  AND s0_.is_featured = 1
ORDER BY
  s0_.position ASC
LIMIT
  3

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.short_description AS short_description_3, s0_.description AS description_4, s0_.image AS image_5, s0_.video_url AS video_url_6, s0_.pricing_type AS pricing_type_7, s0_.billing_mode AS billing_mode_8, s0_.price AS price_9, s0_.recurring_interval AS recurring_interval_10, s0_.min_engagement_months AS min_engagement_months_11, s0_.promo_price AS promo_price_12, s0_.promo_ends_at AS promo_ends_at_13, s0_.is_pack AS is_pack_14, s0_.is_published AS is_published_15, s0_.is_featured AS is_featured_16, s0_.position AS position_17, s0_.stripe_price_id AS stripe_price_id_18, s0_.stripe_promo_price_id AS stripe_promo_price_id_19, s0_.created_at AS created_at_20, s0_.updated_at AS updated_at_21 FROM service s0_ WHERE s0_.is_published = 1 AND s0_.is_featured = 1 ORDER BY s0_.position ASC LIMIT 3;

#	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\ServiceRepository->findFeatured (line 51)
7	App\Controller\SecurityController->login (line 25)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.00 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.short_description AS short_description_3, s0_.description AS description_4, s0_.image AS image_5, s0_.video_url AS video_url_6, s0_.pricing_type AS pricing_type_7, s0_.billing_mode AS billing_mode_8, s0_.price AS price_9, s0_.recurring_interval AS recurring_interval_10, s0_.min_engagement_months AS min_engagement_months_11, s0_.promo_price AS promo_price_12, s0_.promo_ends_at AS promo_ends_at_13, s0_.is_pack AS is_pack_14, s0_.is_published AS is_published_15, s0_.is_featured AS is_featured_16, s0_.position AS position_17, s0_.stripe_price_id AS stripe_price_id_18, s0_.stripe_promo_price_id AS stripe_promo_price_id_19, s0_.created_at AS created_at_20, s0_.updated_at AS updated_at_21 FROM service s0_ WHERE s0_.is_published = 1 AND s0_.promo_price IS NOT NULL AND (s0_.promo_ends_at IS NULL OR s0_.promo_ends_at > ?) ORDER BY s0_.position ASC LIMIT 3

Parameters:

[
  "2026-05-21 02:07:03"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.short_description AS short_description_3,
  s0_.description AS description_4,
  s0_.image AS image_5,
  s0_.video_url AS video_url_6,
  s0_.pricing_type AS pricing_type_7,
  s0_.billing_mode AS billing_mode_8,
  s0_.price AS price_9,
  s0_.recurring_interval AS recurring_interval_10,
  s0_.min_engagement_months AS min_engagement_months_11,
  s0_.promo_price AS promo_price_12,
  s0_.promo_ends_at AS promo_ends_at_13,
  s0_.is_pack AS is_pack_14,
  s0_.is_published AS is_published_15,
  s0_.is_featured AS is_featured_16,
  s0_.position AS position_17,
  s0_.stripe_price_id AS stripe_price_id_18,
  s0_.stripe_promo_price_id AS stripe_promo_price_id_19,
  s0_.created_at AS created_at_20,
  s0_.updated_at AS updated_at_21
FROM
  service s0_
WHERE
  s0_.is_published = 1
  AND s0_.promo_price IS NOT NULL
  AND (
    s0_.promo_ends_at IS NULL
    OR s0_.promo_ends_at > ?
  )
ORDER BY
  s0_.position ASC
LIMIT
  3

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.short_description AS short_description_3, s0_.description AS description_4, s0_.image AS image_5, s0_.video_url AS video_url_6, s0_.pricing_type AS pricing_type_7, s0_.billing_mode AS billing_mode_8, s0_.price AS price_9, s0_.recurring_interval AS recurring_interval_10, s0_.min_engagement_months AS min_engagement_months_11, s0_.promo_price AS promo_price_12, s0_.promo_ends_at AS promo_ends_at_13, s0_.is_pack AS is_pack_14, s0_.is_published AS is_published_15, s0_.is_featured AS is_featured_16, s0_.position AS position_17, s0_.stripe_price_id AS stripe_price_id_18, s0_.stripe_promo_price_id AS stripe_promo_price_id_19, s0_.created_at AS created_at_20, s0_.updated_at AS updated_at_21 FROM service s0_ WHERE s0_.is_published = 1 AND s0_.promo_price IS NOT NULL AND (s0_.promo_ends_at IS NULL OR s0_.promo_ends_at > '2026-05-21 02:07:03') ORDER BY s0_.position ASC LIMIT 3;

#	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\ServiceRepository->findFeatured (line 75)
7	App\Controller\SecurityController->login (line 25)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.31 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.short_description AS short_description_3, s0_.description AS description_4, s0_.image AS image_5, s0_.video_url AS video_url_6, s0_.pricing_type AS pricing_type_7, s0_.billing_mode AS billing_mode_8, s0_.price AS price_9, s0_.recurring_interval AS recurring_interval_10, s0_.min_engagement_months AS min_engagement_months_11, s0_.promo_price AS promo_price_12, s0_.promo_ends_at AS promo_ends_at_13, s0_.is_pack AS is_pack_14, s0_.is_published AS is_published_15, s0_.is_featured AS is_featured_16, s0_.position AS position_17, s0_.stripe_price_id AS stripe_price_id_18, s0_.stripe_promo_price_id AS stripe_promo_price_id_19, s0_.created_at AS created_at_20, s0_.updated_at AS updated_at_21 FROM service s0_ WHERE s0_.is_published = 1 AND s0_.id NOT IN (?) ORDER BY s0_.created_at DESC LIMIT 2

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.short_description AS short_description_3,
  s0_.description AS description_4,
  s0_.image AS image_5,
  s0_.video_url AS video_url_6,
  s0_.pricing_type AS pricing_type_7,
  s0_.billing_mode AS billing_mode_8,
  s0_.price AS price_9,
  s0_.recurring_interval AS recurring_interval_10,
  s0_.min_engagement_months AS min_engagement_months_11,
  s0_.promo_price AS promo_price_12,
  s0_.promo_ends_at AS promo_ends_at_13,
  s0_.is_pack AS is_pack_14,
  s0_.is_published AS is_published_15,
  s0_.is_featured AS is_featured_16,
  s0_.position AS position_17,
  s0_.stripe_price_id AS stripe_price_id_18,
  s0_.stripe_promo_price_id AS stripe_promo_price_id_19,
  s0_.created_at AS created_at_20,
  s0_.updated_at AS updated_at_21
FROM
  service s0_
WHERE
  s0_.is_published = 1
  AND s0_.id NOT IN (?)
ORDER BY
  s0_.created_at DESC
LIMIT
  2

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.short_description AS short_description_3, s0_.description AS description_4, s0_.image AS image_5, s0_.video_url AS video_url_6, s0_.pricing_type AS pricing_type_7, s0_.billing_mode AS billing_mode_8, s0_.price AS price_9, s0_.recurring_interval AS recurring_interval_10, s0_.min_engagement_months AS min_engagement_months_11, s0_.promo_price AS promo_price_12, s0_.promo_ends_at AS promo_ends_at_13, s0_.is_pack AS is_pack_14, s0_.is_published AS is_published_15, s0_.is_featured AS is_featured_16, s0_.position AS position_17, s0_.stripe_price_id AS stripe_price_id_18, s0_.stripe_promo_price_id AS stripe_promo_price_id_19, s0_.created_at AS created_at_20, s0_.updated_at AS updated_at_21 FROM service s0_ WHERE s0_.is_published = 1 AND s0_.id NOT IN (8) ORDER BY s0_.created_at DESC LIMIT 2;

#	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\ServiceRepository->findFeatured (line 97)
7	App\Controller\SecurityController->login (line 25)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.28 ms

SELECT COUNT(*) FROM service t0 WHERE t0.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  service t0
WHERE
  t0.is_published = ?

SELECT COUNT(*) FROM service t0 WHERE t0.is_published = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 87)
4	App\Twig\AppExtension->getGlobals (line 18)
5	Twig\ExtensionSet->getGlobals (line 365)
6	Twig\Environment->getGlobals (line 908)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
15	App\Controller\SecurityController->login (line 27)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	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

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Service	3

Entities Mapping

Class	Mapping errors
App\Entity\Service	No errors.
App\Entity\ServiceCategory	No errors.
App\Entity\Subscription	No errors.

Symfony Profiler

GET https://demande.sylvain-caron.me/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping