Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

6.30 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.48 ms
(87.00%)

SELECT l0_.id AS id_0, l0_.fake_id AS fake_id_1, l0_.date_created AS date_created_2, l0_.price AS price_3, l0_.wf_status AS wf_status_4, l0_.seller_ref AS seller_ref_5, l0_.step_annonce AS step_annonce_6, l0_.marge AS marge_7, l0_.taux_marge AS taux_marge_8, l0_.prix_haut AS prix_haut_9, l0_.prix_attractive AS prix_attractive_10, l0_.good_price AS good_price_11, l0_.end_auction AS end_auction_12, l0_.updated_at AS updated_at_13, l0_.link AS link_14, l0_.price_proposed AS price_proposed_15, l0_.old_part_price AS old_part_price_16, l0_.is_covered AS is_covered_17, l0_.price_covered AS price_covered_18, l0_.status_id AS status_id_19, l0_.storage_address_id AS storage_address_id_20, l0_.scrap_id AS scrap_id_21, l0_.garage_id AS garage_id_22, l0_.vehicle_id AS vehicle_id_23 FROM listing l0_ WHERE l0_.wf_status = ? AND l0_.end_auction > ?

Parameters:

[
  "auction"
  "2025-12-20 16:41:52"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.fake_id AS fake_id_1,
  l0_.date_created AS date_created_2,
  l0_.price AS price_3,
  l0_.wf_status AS wf_status_4,
  l0_.seller_ref AS seller_ref_5,
  l0_.step_annonce AS step_annonce_6,
  l0_.marge AS marge_7,
  l0_.taux_marge AS taux_marge_8,
  l0_.prix_haut AS prix_haut_9,
  l0_.prix_attractive AS prix_attractive_10,
  l0_.good_price AS good_price_11,
  l0_.end_auction AS end_auction_12,
  l0_.updated_at AS updated_at_13,
  l0_.link AS link_14,
  l0_.price_proposed AS price_proposed_15,
  l0_.old_part_price AS old_part_price_16,
  l0_.is_covered AS is_covered_17,
  l0_.price_covered AS price_covered_18,
  l0_.status_id AS status_id_19,
  l0_.storage_address_id AS storage_address_id_20,
  l0_.scrap_id AS scrap_id_21,
  l0_.garage_id AS garage_id_22,
  l0_.vehicle_id AS vehicle_id_23
FROM
  listing l0_
WHERE
  l0_.wf_status = ?
  AND l0_.end_auction > ?

SELECT l0_.id AS id_0, l0_.fake_id AS fake_id_1, l0_.date_created AS date_created_2, l0_.price AS price_3, l0_.wf_status AS wf_status_4, l0_.seller_ref AS seller_ref_5, l0_.step_annonce AS step_annonce_6, l0_.marge AS marge_7, l0_.taux_marge AS taux_marge_8, l0_.prix_haut AS prix_haut_9, l0_.prix_attractive AS prix_attractive_10, l0_.good_price AS good_price_11, l0_.end_auction AS end_auction_12, l0_.updated_at AS updated_at_13, l0_.link AS link_14, l0_.price_proposed AS price_proposed_15, l0_.old_part_price AS old_part_price_16, l0_.is_covered AS is_covered_17, l0_.price_covered AS price_covered_18, l0_.status_id AS status_id_19, l0_.storage_address_id AS storage_address_id_20, l0_.scrap_id AS scrap_id_21, l0_.garage_id AS garage_id_22, l0_.vehicle_id AS vehicle_id_23 FROM listing l0_ WHERE l0_.wf_status = 'auction' AND l0_.end_auction > '2025-12-20 16:41:52';

#	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 808)
7	App\Repository\ListingRepository->countListingInAuction (line 126)
8	App\Twig\MenuExtention->getAuction (line 71)
9	__TwigTemplate_31d1c7ba635458284f57f4f53318365b->doDisplay (line 388)
10	Twig\Template->yield (line 164)
11	__TwigTemplate_32d3e19d77a9efb8701a8f86ec185416->doDisplay (line 388)
12	Twig\Template->yield (line 58)
13	__TwigTemplate_2fdc85fb4d57cd3c5f3e11f6ae26dcf2->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 188)
22	App\Controller\AuthController->passwordRecovery (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 7)

0.46 ms
(7.35%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.wf_status AS wf_status_3, t0.marque AS marque_4, t0.model AS model_5, t0.power AS power_6, t0.kilometers_maximum AS kilometers_maximum_7, t0.mec_min AS mec_min_8, t0.fuel AS fuel_9, t0.gear AS gear_10, t0.price_max AS price_max_11, t0.details AS details_12, t0.garage_id AS garage_id_13 FROM personalized_search t0 WHERE t0.wf_status = ?

Parameters:

[
  "online"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.wf_status AS wf_status_3,
  t0.marque AS marque_4,
  t0.model AS model_5,
  t0.power AS power_6,
  t0.kilometers_maximum AS kilometers_maximum_7,
  t0.mec_min AS mec_min_8,
  t0.fuel AS fuel_9,
  t0.gear AS gear_10,
  t0.price_max AS price_max_11,
  t0.details AS details_12,
  t0.garage_id AS garage_id_13
FROM
  personalized_search t0
WHERE
  t0.wf_status = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.wf_status AS wf_status_3, t0.marque AS marque_4, t0.model AS model_5, t0.power AS power_6, t0.kilometers_maximum AS kilometers_maximum_7, t0.mec_min AS mec_min_8, t0.fuel AS fuel_9, t0.gear AS gear_10, t0.price_max AS price_max_11, t0.details AS details_12, t0.garage_id AS garage_id_13 FROM personalized_search t0 WHERE t0.wf_status = 'online';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 203)
5	App\Twig\MenuExtention->getSearch (line 88)
6	__TwigTemplate_31d1c7ba635458284f57f4f53318365b->doDisplay (line 388)
7	Twig\Template->yield (line 164)
8	__TwigTemplate_32d3e19d77a9efb8701a8f86ec185416->doDisplay (line 388)
9	Twig\Template->yield (line 58)
10	__TwigTemplate_2fdc85fb4d57cd3c5f3e11f6ae26dcf2->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 188)
19	App\Controller\AuthController->passwordRecovery (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 7)

0.36 ms
(5.65%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.monthly_price AS monthly_price_3, t0.fake_id AS fake_id_4, t0.duration AS duration_5, t0.int_ref AS int_ref_6, t0.role AS role_7, t0.image AS image_8, t0.id_stripe AS id_stripe_9, t0.dms AS dms_10, t0.color AS color_11 FROM subscription t0 WHERE t0.int_ref = ? LIMIT 1

Parameters:

[
  "Vendeur"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.monthly_price AS monthly_price_3,
  t0.fake_id AS fake_id_4,
  t0.duration AS duration_5,
  t0.int_ref AS int_ref_6,
  t0.role AS role_7,
  t0.image AS image_8,
  t0.id_stripe AS id_stripe_9,
  t0.dms AS dms_10,
  t0.color AS color_11
FROM
  subscription t0
WHERE
  t0.int_ref = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.monthly_price AS monthly_price_3, t0.fake_id AS fake_id_4, t0.duration AS duration_5, t0.int_ref AS int_ref_6, t0.role AS role_7, t0.image AS image_8, t0.id_stripe AS id_stripe_9, t0.dms AS dms_10, t0.color AS color_11 FROM subscription t0 WHERE t0.int_ref = 'Vendeur' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 30)
5	App\Twig\Abonnement->seller (line 328)
6	__TwigTemplate_32d3e19d77a9efb8701a8f86ec185416->doDisplay (line 388)
7	Twig\Template->yield (line 58)
8	__TwigTemplate_2fdc85fb4d57cd3c5f3e11f6ae26dcf2->doDisplay (line 388)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 188)
17	App\Controller\AuthController->passwordRecovery (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Subscription	2
App\Entity\PersonalizedSearch	1
App\Entity\Garage	1

Entities Mapping

Class	Mapping errors
App\Entity\Listing	No errors.
App\Entity\Status	No errors.
App\Entity\Address	No errors.
App\Entity\Scrap	No errors.
App\Entity\Garage	No errors.
App\Entity\Vehicle	No errors.
App\Entity\PersonalizedSearch	No errors.
App\Entity\Conversation	No errors.
App\Entity\Subscription	No errors.
App\Entity\Subscribe	No errors.

Symfony Profiler

GET https://preprod.entre-marchands-auto.com/connexion/aide

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping