Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

10.44 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.16 ms
(68.61%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3 FROM actualite t0 ORDER BY t0.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.texte AS texte_3
FROM
  actualite t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3 FROM actualite t0 ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\ApiController->derniereactualite (line 1352)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 185)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

1.34 ms
(12.81%)

SELECT t0.id AS id_1, t0.nom_produit AS nom_produit_2, t0.description AS description_3, t0.prix AS prix_4, t0.quantite_disponible AS quantite_disponible_5, t0.descriptioncourte AS descriptioncourte_6, t0.etoiles AS etoiles_7, t0.nbvotes AS nbvotes_8, t0.nb_avis AS nb_avis_9, t0.points AS points_10, t0.date_creation AS date_creation_11, t0.cout_achat AS cout_achat_12, t0.la_categorie_id AS la_categorie_id_13 FROM produits t0 INNER JOIN produits_images ON t0.id = produits_images.produits_id WHERE produits_images.images_id = ?

Parameters:

[
  531
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_produit AS nom_produit_2,
  t0.description AS description_3,
  t0.prix AS prix_4,
  t0.quantite_disponible AS quantite_disponible_5,
  t0.descriptioncourte AS descriptioncourte_6,
  t0.etoiles AS etoiles_7,
  t0.nbvotes AS nbvotes_8,
  t0.nb_avis AS nb_avis_9,
  t0.points AS points_10,
  t0.date_creation AS date_creation_11,
  t0.cout_achat AS cout_achat_12,
  t0.la_categorie_id AS la_categorie_id_13
FROM
  produits t0
  INNER JOIN produits_images ON t0.id = produits_images.produits_id
WHERE
  produits_images.images_id = ?

SELECT t0.id AS id_1, t0.nom_produit AS nom_produit_2, t0.description AS description_3, t0.prix AS prix_4, t0.quantite_disponible AS quantite_disponible_5, t0.descriptioncourte AS descriptioncourte_6, t0.etoiles AS etoiles_7, t0.nbvotes AS nbvotes_8, t0.nb_avis AS nb_avis_9, t0.points AS points_10, t0.date_creation AS date_creation_11, t0.cout_achat AS cout_achat_12, t0.la_categorie_id AS la_categorie_id_13 FROM produits t0 INNER JOIN produits_images ON t0.id = produits_images.produits_id WHERE produits_images.images_id = 531;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1065)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3322)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 167)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 212)
9	Symfony\Component\Serializer\Serializer->normalize (line 150)
10	Symfony\Component\Serializer\Serializer->normalize (line 168)
11	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 212)
12	Symfony\Component\Serializer\Serializer->normalize (line 150)
13	Symfony\Component\Serializer\Serializer->serialize (line 129)
14	App\Utils\Utils->GetJsonResponse (line 35)
15	App\Controller\ApiController->derniereactualite (line 1354)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 185)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.21 ms
(11.58%)

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\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 154)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 185)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.73 ms
(7.00%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.image_name AS image_name_3, t0.la_actualite_id AS la_actualite_id_4 FROM images t0 WHERE t0.la_actualite_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.image_name AS image_name_3,
  t0.la_actualite_id AS la_actualite_id_4
FROM
  images t0
WHERE
  t0.la_actualite_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.image_name AS image_name_3, t0.la_actualite_id AS la_actualite_id_4 FROM images t0 WHERE t0.la_actualite_id = 11;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 167)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 212)
9	Symfony\Component\Serializer\Serializer->normalize (line 150)
10	Symfony\Component\Serializer\Serializer->serialize (line 129)
11	App\Utils\Utils->GetJsonResponse (line 35)
12	App\Controller\ApiController->derniereactualite (line 1354)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 185)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	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\Actualite	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\Actualite	No errors.
App\Entity\Images	No errors.
App\Entity\Produits	No errors.
App\Entity\Categorie	No errors.

Symfony Profiler

GET https://dantecmarket.com/api/mobile/derniereactualite

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping