Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.11 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.97 ms
(58.15%)

SELECT COUNT(p0_.id) AS sclr_0 FROM produits p0_ LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id AND (p1_.date_debut <= CURRENT_TIMESTAMP AND p1_.date_fin >= CURRENT_TIMESTAMP OR p1_.id IS NULL) LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id WHERE c2_.nom = ?

Parameters:

[
  "Vendredi"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  produits p0_
  LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id
  AND (
    p1_.date_debut <= CURRENT_TIMESTAMP
    AND p1_.date_fin >= CURRENT_TIMESTAMP
    OR p1_.id IS NULL
  )
  LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id
WHERE
  c2_.nom = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM produits p0_ LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id AND (p1_.date_debut <= CURRENT_TIMESTAMP AND p1_.date_fin >= CURRENT_TIMESTAMP OR p1_.id IS NULL) LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id WHERE c2_.nom = 'Vendredi';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Repository\ProduitsRepository->getProduitPromoduJour (line 95)
8	App\Controller\ApiController->GetPromoduJour (line 745)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 185)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.52 ms
(29.70%)

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, p1_.prix AS prix_2, p1_.date_fin AS date_fin_3, c2_.nom AS nom_4, MIN(i3_.url) AS sclr_5 FROM produits p0_ LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id AND (p1_.date_debut <= CURRENT_TIMESTAMP AND p1_.date_fin >= CURRENT_TIMESTAMP OR p1_.id IS NULL) LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id LEFT JOIN produits_images p4_ ON p0_.id = p4_.produits_id LEFT JOIN images i3_ ON i3_.id = p4_.images_id WHERE c2_.nom = ? GROUP BY p0_.id, p0_.nom_produit ORDER BY p0_.id ASC LIMIT 1

Parameters:

[
  "Vendredi"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nom_produit AS nom_produit_1,
  p1_.prix AS prix_2,
  p1_.date_fin AS date_fin_3,
  c2_.nom AS nom_4,
  MIN(i3_.url) AS sclr_5
FROM
  produits p0_
  LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id
  AND (
    p1_.date_debut <= CURRENT_TIMESTAMP
    AND p1_.date_fin >= CURRENT_TIMESTAMP
    OR p1_.id IS NULL
  )
  LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id
  LEFT JOIN produits_images p4_ ON p0_.id = p4_.produits_id
  LEFT JOIN images i3_ ON i3_.id = p4_.images_id
WHERE
  c2_.nom = ?
GROUP BY
  p0_.id,
  p0_.nom_produit
ORDER BY
  p0_.id ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, p1_.prix AS prix_2, p1_.date_fin AS date_fin_3, c2_.nom AS nom_4, MIN(i3_.url) AS sclr_5 FROM produits p0_ LEFT JOIN promo p1_ ON p0_.id = p1_.le_produit_id AND (p1_.date_debut <= CURRENT_TIMESTAMP AND p1_.date_fin >= CURRENT_TIMESTAMP OR p1_.id IS NULL) LEFT JOIN categorie_promo c2_ ON p1_.la_categorie_promo_id = c2_.id LEFT JOIN produits_images p4_ ON p0_.id = p4_.produits_id LEFT JOIN images i3_ ON i3_.id = p4_.images_id WHERE c2_.nom = 'Vendredi' GROUP BY p0_.id, p0_.nom_produit ORDER BY p0_.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
6	App\Repository\ProduitsRepository->getProduitPromoduJour (line 110)
7	App\Controller\ApiController->GetPromoduJour (line 745)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.62 ms
(12.14%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.classe AS classe_8, t0.fidelite AS fidelite_9, t0.photo_url AS photo_url_10, t0.fcm_token AS fcm_token_11, t0.display_name AS display_name_12, t0.is_leaderboard_opt_in AS is_leaderboard_opt_in_13, t0.pref_newsletter AS pref_newsletter_14, t0.pref_promo_notifications AS pref_promo_notifications_15, t0.pref_order_alerts AS pref_order_alerts_16, t0.reset_token AS reset_token_17, t0.reset_token_expiry AS reset_token_expiry_18 FROM user t0 WHERE t0.id = ?

Parameters:

[
  43
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.telephone AS telephone_7,
  t0.classe AS classe_8,
  t0.fidelite AS fidelite_9,
  t0.photo_url AS photo_url_10,
  t0.fcm_token AS fcm_token_11,
  t0.display_name AS display_name_12,
  t0.is_leaderboard_opt_in AS is_leaderboard_opt_in_13,
  t0.pref_newsletter AS pref_newsletter_14,
  t0.pref_promo_notifications AS pref_promo_notifications_15,
  t0.pref_order_alerts AS pref_order_alerts_16,
  t0.reset_token AS reset_token_17,
  t0.reset_token_expiry AS reset_token_expiry_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.classe AS classe_8, t0.fidelite AS fidelite_9, t0.photo_url AS photo_url_10, t0.fcm_token AS fcm_token_11, t0.display_name AS display_name_12, t0.is_leaderboard_opt_in AS is_leaderboard_opt_in_13, t0.pref_newsletter AS pref_newsletter_14, t0.pref_promo_notifications AS pref_promo_notifications_15, t0.pref_order_alerts AS pref_order_alerts_16, t0.reset_token AS reset_token_17, t0.reset_token_expiry AS reset_token_expiry_18 FROM user t0 WHERE t0.id = 43;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 127)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 154)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 185)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	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\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Reserver	No errors.
App\Entity\Commandes	No errors.
App\Entity\Commentaires	No errors.
App\Entity\Favoris	No errors.
App\Entity\Messages	No errors.
App\Entity\Produits	No errors.
App\Entity\Promo	No errors.
App\Entity\CategoriePromo	No errors.
App\Entity\Images	No errors.

Symfony Profiler

POST https://dantecmarket.com/api/mobile/produitdujour

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping