Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.33 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.position AS position_4, t0.status AS status_5, t0.langue AS langue_6 FROM block t0 WHERE t0.position = ? LIMIT 1 Parameters: [`"FOOTER_MAP"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.position AS position_4, t0.status AS status_5, t0.langue AS langue_6 FROM block t0 WHERE t0.position = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.position AS position_4, t0.status AS status_5, t0.langue AS langue_6 FROM block t0 WHERE t0.position = 'FOOTER_MAP' LIMIT 1;

#▲

Time

Info

0.33 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.position AS position_4, t0.status AS status_5, t0.langue AS langue_6 FROM block t0 WHERE t0.position = ? LIMIT 1

Parameters:

[
  "FOOTER_MAP"
]

View formatted query View runnable query Explain query

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.content AS content_3, 
  t0.position AS position_4, 
  t0.status AS status_5, 
  t0.langue AS langue_6 
FROM 
  block t0 
WHERE 
  t0.position = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.position AS position_4, t0.status AS status_5, t0.langue AS langue_6 FROM block t0 WHERE t0.position = 'FOOTER_MAP' LIMIT 1;

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
Sonata\NotificationBundle\Entity\BaseMessage	No errors.
Application\Sonata\NotificationBundle\Entity\Message	No errors.
Sonata\MediaBundle\Entity\BaseGalleryHasMedia	No errors.
Sonata\MediaBundle\Entity\BaseGallery	No errors.
Sonata\MediaBundle\Entity\BaseMedia	No errors.
Sonata\ClassificationBundle\Entity\BaseContext	No errors.
Application\Sonata\ClassificationBundle\Entity\Context	No errors.
Sonata\ClassificationBundle\Entity\BaseTag	No errors.
Application\Sonata\ClassificationBundle\Entity\Tag	No errors.
Sonata\ClassificationBundle\Entity\BaseCollection	No errors.
Application\Sonata\ClassificationBundle\Entity\Collection	No errors.
Sonata\ClassificationBundle\Entity\BaseCategory	No errors.
Application\Sonata\ClassificationBundle\Entity\Category	No errors.
Application\Sonata\MediaBundle\Entity\Gallery	No errors.
Application\Sonata\MediaBundle\Entity\Media	No errors.
Application\Sonata\MediaBundle\Entity\GalleryHasMedia	No errors.
FOS\UserBundle\Model\User	No errors.
Sonata\UserBundle\Entity\BaseUser	No errors.
FOS\UserBundle\Model\Group	No errors.
Sonata\UserBundle\Entity\BaseGroup	No errors.
Application\Sonata\UserBundle\Entity\User	No errors.
Application\Sonata\UserBundle\Entity\Group	No errors.
FOS\MessageBundle\Entity\Message	No errors.
FOS\MessageBundle\Entity\ThreadMetadata	No errors.
FOS\MessageBundle\Entity\MessageMetadata	No errors.
FOS\MessageBundle\Entity\Thread	No errors.
Front\EcommerceBundle\Entity\Tva	No errors.
Front\EcommerceBundle\Entity\Transaction	No errors.
Front\EcommerceBundle\Entity\Order	No errors.
Front\EcommerceBundle\Entity\Status	No errors.
Front\EcommerceBundle\Entity\Produits	No errors.
Front\EcommerceBundle\Entity\OrderStatus	No errors.
Front\EcommerceBundle\Entity\Categories	No errors.
Front\EcommerceBundle\Entity\Reponse	No errors.
Front\EcommerceBundle\Entity\PaymentMethod	No errors.
Front\EcommerceBundle\Entity\ShippingMethod	No errors.
Front\EcommerceBundle\Entity\Favoris	No errors.
Front\EcommerceBundle\Entity\OldInvoice	No errors.
Front\EcommerceBundle\Entity\OrderProduct	No errors.
Front\EcommerceBundle\Entity\Commentaire	No errors.
Front\EcommerceBundle\Entity\Subscription	No errors.
Front\EcommerceBundle\Entity\SepaDeadline	No errors.
Common\CoreBundle\Entity\Setting	No errors.
Common\CoreBundle\Entity\TemplateMail	No errors.
Common\CoreBundle\Entity\Newsletter	No errors.
Front\CmsBundle\Entity\Page	No errors.
Front\CmsBundle\Entity\Block	No errors.
Front\CmsBundle\Entity\Enquiry	No errors.
Front\CmsBundle\Entity\HomeSlider	No errors.
Front\MemberBundle\Entity\Message	No errors.
Front\MemberBundle\Entity\UserFormation	No errors.
Front\MemberBundle\Entity\Member	No errors.
Front\MemberBundle\Entity\Thread	No errors.
Front\MemberBundle\Entity\ThreadMetadata	No errors.
Front\MemberBundle\Entity\UserTitle	No errors.
Front\MemberBundle\Entity\MessageMetadata	No errors.
Front\MemberBundle\Entity\Ville	No errors.
Cnge\CommonBundle\Entity\NotifiableNotification	No errors.
Cnge\CommonBundle\Entity\NotifiableEntity	No errors.
Cnge\CommonBundle\Entity\Notification	No errors.
Tlconseil\SystempayBundle\Entity\Transaction	No errors.
Front\FormationsBundle\Entity\Inscrits	No errors.
Front\FormationsBundle\Entity\Code	No errors.
Front\FormationsBundle\Entity\Financement	No errors.
Front\FormationsBundle\Entity\FormationExperts	No errors.
Front\FormationsBundle\Entity\FormationsStatus	No errors.
Front\FormationsBundle\Entity\Secretaires	No errors.
Front\FormationsBundle\Entity\Log	No errors.
Front\FormationsBundle\Entity\Lieu	No errors.
Front\FormationsBundle\Entity\College	No errors.
Front\FormationsBundle\Entity\Formations	No errors.
Front\FormationsBundle\Entity\CollegeSecretaire	No errors.
Front\FormationsBundle\Entity\Modules	No errors.
Front\FormationsBundle\Entity\NoteHonoraires	No errors.
Front\FormationsBundle\Entity\Attachement	No errors.
Front\FormationsBundle\Entity\NoteFrais	No errors.
Front\FormationsBundle\Entity\Organisateurs	No errors.
Front\FormationsBundle\Entity\Experts	No errors.
Front\SecretariatBundle\Entity\Secretariat	No errors.
Front\ComptabiliteBundle\Entity\Comptabilite	No errors.

Symfony Profiler

https://formation.dev.pre-view.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DCommonCoreBundle%253ADefault%253Anewsletter

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping