Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.97 ms Query time

1 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.97 ms
(100.00%)

SELECT c0_.id AS id_0, c0_.document_type AS document_type_1, c0_.document_version AS document_version_2, c0_.subject_of_the_document AS subject_of_the_document_3, c0_.document_origin AS document_origin_4, c0_.document_status AS document_status_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.number AS number_8, c0_.is_processed AS is_processed_9, c0_.closing_at AS closing_at_10, c0_.processing_at AS processing_at_11, c0_.reference AS reference_12, c0_.name_destinateur AS name_destinateur_13, c0_.mail_destinateur AS mail_destinateur_14, c0_.date_of_receipt AS date_of_receipt_15, c0_.date_on_the_mail_at AS date_on_the_mail_at_16, c0_.nature_courier AS nature_courier_17, c0_.path_discharge AS path_discharge_18, c0_.is_handled AS is_handled_19, c0_.contacts AS contacts_20, c0_.discharge_mention_statut AS discharge_mention_statut_21, c0_.default_name_category AS default_name_category_22, c0_.is_sign AS is_sign_23, c0_.is_answer_cs AS is_answer_cs_24, c0_.is_valid AS is_valid_25, c0_.comment AS comment_26, c0_.date_transmission AS date_transmission_27, c0_.category_id AS category_id_28, c0_.owner_id AS owner_id_29, c0_.coursier_id AS coursier_id_30, c0_.contact_interne_id AS contact_interne_id_31 FROM courier c0_ WHERE c0_.id = ?

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.document_type AS document_type_1,
  c0_.document_version AS document_version_2,
  c0_.subject_of_the_document AS subject_of_the_document_3,
  c0_.document_origin AS document_origin_4,
  c0_.document_status AS document_status_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.number AS number_8,
  c0_.is_processed AS is_processed_9,
  c0_.closing_at AS closing_at_10,
  c0_.processing_at AS processing_at_11,
  c0_.reference AS reference_12,
  c0_.name_destinateur AS name_destinateur_13,
  c0_.mail_destinateur AS mail_destinateur_14,
  c0_.date_of_receipt AS date_of_receipt_15,
  c0_.date_on_the_mail_at AS date_on_the_mail_at_16,
  c0_.nature_courier AS nature_courier_17,
  c0_.path_discharge AS path_discharge_18,
  c0_.is_handled AS is_handled_19,
  c0_.contacts AS contacts_20,
  c0_.discharge_mention_statut AS discharge_mention_statut_21,
  c0_.default_name_category AS default_name_category_22,
  c0_.is_sign AS is_sign_23,
  c0_.is_answer_cs AS is_answer_cs_24,
  c0_.is_valid AS is_valid_25,
  c0_.comment AS comment_26,
  c0_.date_transmission AS date_transmission_27,
  c0_.category_id AS category_id_28,
  c0_.owner_id AS owner_id_29,
  c0_.coursier_id AS coursier_id_30,
  c0_.contact_interne_id AS contact_interne_id_31
FROM
  courier c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.document_type AS document_type_1, c0_.document_version AS document_version_2, c0_.subject_of_the_document AS subject_of_the_document_3, c0_.document_origin AS document_origin_4, c0_.document_status AS document_status_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.number AS number_8, c0_.is_processed AS is_processed_9, c0_.closing_at AS closing_at_10, c0_.processing_at AS processing_at_11, c0_.reference AS reference_12, c0_.name_destinateur AS name_destinateur_13, c0_.mail_destinateur AS mail_destinateur_14, c0_.date_of_receipt AS date_of_receipt_15, c0_.date_on_the_mail_at AS date_on_the_mail_at_16, c0_.nature_courier AS nature_courier_17, c0_.path_discharge AS path_discharge_18, c0_.is_handled AS is_handled_19, c0_.contacts AS contacts_20, c0_.discharge_mention_statut AS discharge_mention_statut_21, c0_.default_name_category AS default_name_category_22, c0_.is_sign AS is_sign_23, c0_.is_answer_cs AS is_answer_cs_24, c0_.is_valid AS is_valid_25, c0_.comment AS comment_26, c0_.date_transmission AS date_transmission_27, c0_.category_id AS category_id_28, c0_.owner_id AS owner_id_29, c0_.coursier_id AS coursier_id_30, c0_.contact_interne_id AS contact_interne_id_31 FROM courier c0_ WHERE c0_.id = NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 45)
7	App\EventSubscriber\AuthorizationMiddlewareSubscriber->onControllerEvent (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
14	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
19	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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

Entities Mapping

Class	Mapping errors
App\Entity\Courier	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.
App\Entity\Coursier	No errors.
App\Entity\Document	The association App\Entity\Document#historyViews refers to the owning side field App\Entity\HistoryView#document which does not exist.
App\Entity\Annotation	No errors.
App\Entity\UserCourier	No errors.
App\Entity\History	No errors.
App\Entity\TechnicalMemo	No errors.
App\Entity\AnswerCourier	No errors.
App\Entity\Notification	No errors.
App\Entity\Folder	No errors.
App\Entity\Descharge	No errors.
App\Entity\LinkDocumentToDocument	No errors.
App\Entity\CourierProcessingUser	No errors.
App\Entity\HistoryView	No errors.
App\Entity\Service	No errors.
App\Entity\Setting	No errors.
App\Entity\UserProfile	No errors.

Symfony Profiler

GET https://dev-courrier-arcep.brainsense.fr/robots.txt

Configuration Settings

Theme

Page Width