Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

11.32 ms Query time

0 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.00 ms

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)

8.91 ms

SELECT c0_.id AS id_0, c0_.date_commande AS date_commande_1, c0_.montant_total AS montant_total_2, c0_.valider AS valider_3, c0_.fidelite_credite AS fidelite_credite_4, c0_.etat AS etat_5, r1_.id AS id_6, r1_.date AS date_7, r1_.heure AS heure_8, c2_.id AS id_9, c2_.quantite AS quantite_10, c2_.prixretenu AS prixretenu_11, c2_.note_donnee AS note_donnee_12, c2_.traite AS traite_13, c2_.livre AS livre_14, p3_.id AS id_15, p3_.nom_produit AS nom_produit_16, p3_.description AS description_17, p3_.prix AS prix_18, p3_.quantite_disponible AS quantite_disponible_19, p3_.descriptioncourte AS descriptioncourte_20, p3_.etoiles AS etoiles_21, p3_.nbvotes AS nbvotes_22, p3_.nb_avis AS nb_avis_23, p3_.points AS points_24, p3_.date_creation AS date_creation_25, p3_.cout_achat AS cout_achat_26, i4_.id AS id_27, i4_.url AS url_28, i4_.image_name AS image_name_29, c0_.le_user_id AS le_user_id_30, r1_.le_user_id AS le_user_id_31, r1_.le_planning_id AS le_planning_id_32, r1_.la_commande_id AS la_commande_id_33, c2_.la_commande_id AS la_commande_id_34, c2_.le_produit_id AS le_produit_id_35, p3_.la_categorie_id AS la_categorie_id_36, i4_.la_actualite_id AS la_actualite_id_37 FROM commandes c0_ LEFT JOIN reserver r1_ ON c0_.id = r1_.la_commande_id LEFT JOIN commander c2_ ON c0_.id = c2_.la_commande_id LEFT JOIN produits p3_ ON c2_.le_produit_id = p3_.id LEFT JOIN produits_images p5_ ON p3_.id = p5_.produits_id LEFT JOIN images i4_ ON i4_.id = p5_.images_id WHERE c0_.le_user_id = ? AND c0_.etat = ? AND c0_.etat <> ? ORDER BY c0_.date_commande DESC

Parameters:

[
  43
  "Traitée"
  "Livrée"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.date_commande AS date_commande_1,
  c0_.montant_total AS montant_total_2,
  c0_.valider AS valider_3,
  c0_.fidelite_credite AS fidelite_credite_4,
  c0_.etat AS etat_5,
  r1_.id AS id_6,
  r1_.date AS date_7,
  r1_.heure AS heure_8,
  c2_.id AS id_9,
  c2_.quantite AS quantite_10,
  c2_.prixretenu AS prixretenu_11,
  c2_.note_donnee AS note_donnee_12,
  c2_.traite AS traite_13,
  c2_.livre AS livre_14,
  p3_.id AS id_15,
  p3_.nom_produit AS nom_produit_16,
  p3_.description AS description_17,
  p3_.prix AS prix_18,
  p3_.quantite_disponible AS quantite_disponible_19,
  p3_.descriptioncourte AS descriptioncourte_20,
  p3_.etoiles AS etoiles_21,
  p3_.nbvotes AS nbvotes_22,
  p3_.nb_avis AS nb_avis_23,
  p3_.points AS points_24,
  p3_.date_creation AS date_creation_25,
  p3_.cout_achat AS cout_achat_26,
  i4_.id AS id_27,
  i4_.url AS url_28,
  i4_.image_name AS image_name_29,
  c0_.le_user_id AS le_user_id_30,
  r1_.le_user_id AS le_user_id_31,
  r1_.le_planning_id AS le_planning_id_32,
  r1_.la_commande_id AS la_commande_id_33,
  c2_.la_commande_id AS la_commande_id_34,
  c2_.le_produit_id AS le_produit_id_35,
  p3_.la_categorie_id AS la_categorie_id_36,
  i4_.la_actualite_id AS la_actualite_id_37
FROM
  commandes c0_
  LEFT JOIN reserver r1_ ON c0_.id = r1_.la_commande_id
  LEFT JOIN commander c2_ ON c0_.id = c2_.la_commande_id
  LEFT JOIN produits p3_ ON c2_.le_produit_id = p3_.id
  LEFT JOIN produits_images p5_ ON p3_.id = p5_.produits_id
  LEFT JOIN images i4_ ON i4_.id = p5_.images_id
WHERE
  c0_.le_user_id = ?
  AND c0_.etat = ?
  AND c0_.etat <> ?
ORDER BY
  c0_.date_commande DESC

SELECT c0_.id AS id_0, c0_.date_commande AS date_commande_1, c0_.montant_total AS montant_total_2, c0_.valider AS valider_3, c0_.fidelite_credite AS fidelite_credite_4, c0_.etat AS etat_5, r1_.id AS id_6, r1_.date AS date_7, r1_.heure AS heure_8, c2_.id AS id_9, c2_.quantite AS quantite_10, c2_.prixretenu AS prixretenu_11, c2_.note_donnee AS note_donnee_12, c2_.traite AS traite_13, c2_.livre AS livre_14, p3_.id AS id_15, p3_.nom_produit AS nom_produit_16, p3_.description AS description_17, p3_.prix AS prix_18, p3_.quantite_disponible AS quantite_disponible_19, p3_.descriptioncourte AS descriptioncourte_20, p3_.etoiles AS etoiles_21, p3_.nbvotes AS nbvotes_22, p3_.nb_avis AS nb_avis_23, p3_.points AS points_24, p3_.date_creation AS date_creation_25, p3_.cout_achat AS cout_achat_26, i4_.id AS id_27, i4_.url AS url_28, i4_.image_name AS image_name_29, c0_.le_user_id AS le_user_id_30, r1_.le_user_id AS le_user_id_31, r1_.le_planning_id AS le_planning_id_32, r1_.la_commande_id AS la_commande_id_33, c2_.la_commande_id AS la_commande_id_34, c2_.le_produit_id AS le_produit_id_35, p3_.la_categorie_id AS la_categorie_id_36, i4_.la_actualite_id AS la_actualite_id_37 FROM commandes c0_ LEFT JOIN reserver r1_ ON c0_.id = r1_.la_commande_id LEFT JOIN commander c2_ ON c0_.id = c2_.la_commande_id LEFT JOIN produits p3_ ON c2_.le_produit_id = p3_.id LEFT JOIN produits_images p5_ ON p3_.id = p5_.produits_id LEFT JOIN images i4_ ON i4_.id = p5_.images_id WHERE c0_.le_user_id = 43 AND c0_.etat = 'Traitée' AND c0_.etat <> 'Livrée' ORDER BY c0_.date_commande DESC;

#	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->getResult (line 906)
6	App\Repository\CommandesRepository->findReadyButNotDeliveredByUser (line 222)
7	App\Controller\ReserverController->commandesPretes (line 137)
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)

1.41 ms

SELECT t0.id AS id_1, t0.jour AS jour_2, t0.heure_debut AS heure_debut_3, t0.heure_fin AS heure_fin_4 FROM planning t0 WHERE t0.id = ?

Parameters:

[
  84
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.jour AS jour_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_fin AS heure_fin_4
FROM
  planning t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.jour AS jour_2, t0.heure_debut AS heure_debut_3, t0.heure_fin AS heure_fin_4 FROM planning t0 WHERE t0.id = 84;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Planning::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Planning->__get (line 120)
7	App\Entity\Planning->getJour (line 43)
8	App\Entity\Reserver->getPlanningDetails (line 103)
9	App\Controller\ReserverController->App\Controller\{closure} (line 151)
10	array_map (line 146)
11	App\Controller\ReserverController::App\Controller\{closure} (line 146)
12	array_map (line 139)
13	App\Controller\ReserverController::commandesPretes (line 139)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 185)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	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
App\Entity\Commandes	1
App\Entity\Reserver	1
App\Entity\Planning	1
App\Entity\Commander	1
App\Entity\Produits	1
App\Entity\Categorie	1
App\Entity\Images	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\Commander	No errors.
App\Entity\Produits	No errors.
App\Entity\Images	No errors.
App\Entity\Planning	No errors.
App\Entity\Categorie	No errors.
App\Entity\Actualite	No errors.
App\Entity\Promo	No errors.

Symfony Profiler

POST https://dantecmarket.com/reserver/commande/prete

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping