Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.25 ms Query time

6 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.25 ms
(100.00%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image_pub AS image_pub_3, t0.created_at AS created_at_4, t0.image_size AS image_size_5, t0.updated_at AS updated_at_6, t0.description AS description_7, t0.admin_id AS admin_id_8 FROM pub_infos t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image_pub AS image_pub_3,
  t0.created_at AS created_at_4,
  t0.image_size AS image_size_5,
  t0.updated_at AS updated_at_6,
  t0.description AS description_7,
  t0.admin_id AS admin_id_8
FROM
  pub_infos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.image_pub AS image_pub_3, t0.created_at AS created_at_4, t0.image_size AS image_size_5, t0.updated_at AS updated_at_6, t0.description AS description_7, t0.admin_id AS admin_id_8 FROM pub_infos t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 225)
6	App\Controller\ArticleController->showPub (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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.

Entities Mapping

Class	Mapping errors
App\Entity\PubInfos	No errors.
App\Entity\User	The association App\Entity\User#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Admin	The association App\Entity\Admin#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Annonce	No errors.
App\Entity\Boutique	No errors.
App\Entity\Code	No errors.
App\Entity\Avis	No errors.
App\Entity\OffreCredit	No errors.
App\Entity\JournalCredit	No errors.
App\Entity\Message	No errors.
App\Entity\Article	The association App\Entity\Article#professionel refers to the inverse side field App\Entity\Professionel#articles which does not exist.
App\Entity\Portrait	No errors.
App\Entity\Professionel	The association App\Entity\Professionel#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist. The mappings App\Entity\Professionel#artilces and App\Entity\Article#professionel are inconsistent with each other.
App\Entity\Particulier	The association App\Entity\Particulier#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Picture	No errors.
App\Entity\Comment	No errors.
App\Entity\Abonne	No errors.
App\Entity\Contact	No errors.
App\Entity\Recommandation	The association App\Entity\Recommandation#annonce refers to the inverse side field App\Entity\Annonce#recommandations which does not exist.
App\Entity\Abonnee	No errors.
App\Entity\Marque	No errors.
App\Entity\Visiteur	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Vitrine	No errors.
App\Entity\DepotRecherche	No errors.
App\Entity\Pub	No errors.
App\Entity\Offer	No errors.
App\Entity\Modele	No errors.
App\Entity\EssaiVehicule	No errors.
App\Entity\ContactTel	No errors.
App\Entity\ContactAnnonce	No errors.
App\Entity\Commenter	No errors.
App\Entity\Annuaire	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET http://eposta.sn-topauto.com/fr/publicite/show/-4

Configuration Settings

Theme