Symfony Profiler

Query Metrics

14 Database Queries

5 Different statements

3.58 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.66 ms
(46.41%)

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = ? ORDER BY t0.system_date_time DESC

Parameters:

[
  117
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 117 ORDER BY t0.system_date_time DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1099)
3	Doctrine\DBAL\Connection->executeQuery (line 1916)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
5	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
6	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
7	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
8	Doctrine\ORM\PersistentCollection->initialize (line 177)
9	Doctrine\Common\Collections\AbstractLazyCollection->last (line 188)
10	App\Entity\Order\Order->getLastStateColor (line 1754)
11	Twig\Extension\CoreExtension::getAttribute (line 458)
12	__TwigTemplate_52d28d4963543ef06b05007acc102f7e->block_page_content (line 437)
13	Twig\Template->yieldBlock (line 190)
14	__TwigTemplate_820617dcaf79d155f5934bf0116124fa->doDisplay (line 393)
15	Twig\Template->yield (line 71)
16	__TwigTemplate_a0cdabd05543804faca0e06ba4769aaa->doDisplay (line 393)
17	Twig\Template->yield (line 68)
18	__TwigTemplate_52d28d4963543ef06b05007acc102f7e->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 83)
27	App\Controller\Driver\OrderController->index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.72 ms
(19.98%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.debitor_number AS debitor_number_3, t0.supplier_number AS supplier_number_4, t0.is_supplier AS is_supplier_5, t0.is_customer AS is_customer_6, t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7, t0.deleted_at AS deleted_at_8, t0.deleted_by_user_id AS deleted_by_user_id_9 FROM contact_contact t0 WHERE t0.id = ?

Parameters:

[
  42
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.debitor_number AS debitor_number_3,
  t0.supplier_number AS supplier_number_4,
  t0.is_supplier AS is_supplier_5,
  t0.is_customer AS is_customer_6,
  t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7,
  t0.deleted_at AS deleted_at_8,
  t0.deleted_by_user_id AS deleted_by_user_id_9
FROM
  contact_contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.debitor_number AS debitor_number_3, t0.supplier_number AS supplier_number_4, t0.is_supplier AS is_supplier_5, t0.is_customer AS is_customer_6, t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7, t0.deleted_at AS deleted_at_8, t0.deleted_by_user_id AS deleted_by_user_id_9 FROM contact_contact t0 WHERE t0.id = 42;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1099)
3	Doctrine\DBAL\Connection->executeQuery (line 776)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
5	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
6	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
7	Proxies\__CG__\App\Entity\Contact\Contact::Doctrine\ORM\Proxy\{closure} (line 59)
8	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
9	Proxies\__CG__\App\Entity\Contact\Contact->__get (line 107)
10	App\Entity\Contact\Contact->getName (line 74)
11	App\Entity\Contact\Contact->__toString (line 113)
12	Twig\Runtime\EscaperRuntime->escape (line 465)
13	__TwigTemplate_52d28d4963543ef06b05007acc102f7e->block_page_content (line 437)
14	Twig\Template->yieldBlock (line 190)
15	__TwigTemplate_820617dcaf79d155f5934bf0116124fa->doDisplay (line 393)
16	Twig\Template->yield (line 71)
17	__TwigTemplate_a0cdabd05543804faca0e06ba4769aaa->doDisplay (line 393)
18	Twig\Template->yield (line 68)
19	__TwigTemplate_52d28d4963543ef06b05007acc102f7e->doDisplay (line 393)
20	Twig\Template->yield (line 349)
21	Twig\Template->display (line 364)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 306)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 83)
28	App\Controller\Driver\OrderController->index (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.50 ms
(14.03%)

SELECT o0_.id AS id_0, o0_.number AS number_1, o0_.name AS name_2, o0_.construction_site_cost_center AS construction_site_cost_center_3, o0_.order_date AS order_date_4, o0_.start_time AS start_time_5, o0_.end_time AS end_time_6, o0_.repeat_order AS repeat_order_7, o0_.repeat_order_amount AS repeat_order_amount_8, o0_.daily_use AS daily_use_9, o0_.night_operation AS night_operation_10, o0_.delivery_note_mail AS delivery_note_mail_11, o0_.contact_person AS contact_person_12, o0_.contact_person_phone AS contact_person_phone_13, o0_.description AS description_14, o0_.customer_not_present AS customer_not_present_15, o0_.delivery_note_driver_text AS delivery_note_driver_text_16, o0_.contact_id AS contact_id_17, o0_.vehicle_id AS vehicle_id_18, o0_.driver_id AS driver_id_19, o0_.unloading_point_id AS unloading_point_id_20, o0_.loading_point_id AS loading_point_id_21, o0_.signature_id AS signature_id_22, o0_.delivery_note_id AS delivery_note_id_23, o0_.invoice_id AS invoice_id_24 FROM order_order o0_ LEFT JOIN order_state o1_ ON o0_.id = o1_.order_relation_id WHERE o0_.driver_id = ? AND o0_.order_date >= ? AND o0_.order_date <= ? AND o1_.type IN (?)

Parameters:

[
  6
  "2024-11-14"
  "2024-11-27"
  "DISPONIERT"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.number AS number_1,
  o0_.name AS name_2,
  o0_.construction_site_cost_center AS construction_site_cost_center_3,
  o0_.order_date AS order_date_4,
  o0_.start_time AS start_time_5,
  o0_.end_time AS end_time_6,
  o0_.repeat_order AS repeat_order_7,
  o0_.repeat_order_amount AS repeat_order_amount_8,
  o0_.daily_use AS daily_use_9,
  o0_.night_operation AS night_operation_10,
  o0_.delivery_note_mail AS delivery_note_mail_11,
  o0_.contact_person AS contact_person_12,
  o0_.contact_person_phone AS contact_person_phone_13,
  o0_.description AS description_14,
  o0_.customer_not_present AS customer_not_present_15,
  o0_.delivery_note_driver_text AS delivery_note_driver_text_16,
  o0_.contact_id AS contact_id_17,
  o0_.vehicle_id AS vehicle_id_18,
  o0_.driver_id AS driver_id_19,
  o0_.unloading_point_id AS unloading_point_id_20,
  o0_.loading_point_id AS loading_point_id_21,
  o0_.signature_id AS signature_id_22,
  o0_.delivery_note_id AS delivery_note_id_23,
  o0_.invoice_id AS invoice_id_24
FROM
  order_order o0_
  LEFT JOIN order_state o1_ ON o0_.id = o1_.order_relation_id
WHERE
  o0_.driver_id = ?
  AND o0_.order_date >= ?
  AND o0_.order_date <= ?
  AND o1_.type IN (?)

SELECT o0_.id AS id_0, o0_.number AS number_1, o0_.name AS name_2, o0_.construction_site_cost_center AS construction_site_cost_center_3, o0_.order_date AS order_date_4, o0_.start_time AS start_time_5, o0_.end_time AS end_time_6, o0_.repeat_order AS repeat_order_7, o0_.repeat_order_amount AS repeat_order_amount_8, o0_.daily_use AS daily_use_9, o0_.night_operation AS night_operation_10, o0_.delivery_note_mail AS delivery_note_mail_11, o0_.contact_person AS contact_person_12, o0_.contact_person_phone AS contact_person_phone_13, o0_.description AS description_14, o0_.customer_not_present AS customer_not_present_15, o0_.delivery_note_driver_text AS delivery_note_driver_text_16, o0_.contact_id AS contact_id_17, o0_.vehicle_id AS vehicle_id_18, o0_.driver_id AS driver_id_19, o0_.unloading_point_id AS unloading_point_id_20, o0_.loading_point_id AS loading_point_id_21, o0_.signature_id AS signature_id_22, o0_.delivery_note_id AS delivery_note_id_23, o0_.invoice_id AS invoice_id_24 FROM order_order o0_ LEFT JOIN order_state o1_ ON o0_.id = o1_.order_relation_id WHERE o0_.driver_id = 6 AND o0_.order_date >= '2024-11-14' AND o0_.order_date <= '2024-11-27' AND o1_.type IN ('DISPONIERT');

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1099)
3	Doctrine\DBAL\Connection->executeQuery (line 31)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
5	Doctrine\ORM\Query->_doExecute (line 1218)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
7	Doctrine\ORM\AbstractQuery->execute (line 907)
8	Doctrine\ORM\AbstractQuery->getResult (line 46)
9	App\Repository\Order\OrderRepository->getFilteredResults (line 71)
10	App\Controller\Driver\OrderController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.48 ms
(13.47%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar AS avatar_7 FROM user t0 WHERE t0.id = ?

Parameters:

[
  6
]

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.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.avatar AS avatar_7
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar AS avatar_7 FROM user t0 WHERE t0.id = 6;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1099)
3	Doctrine\DBAL\Connection->executeQuery (line 776)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
5	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
6	Doctrine\ORM\EntityManager->find (line 196)
7	Doctrine\ORM\EntityRepository->find (line 92)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
9	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.22 ms
(6.10%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.license_plate AS license_plate_3, t0.type AS type_4, t0.deleted_at AS deleted_at_5, t0.primary_driver_id AS primary_driver_id_6, t0.deleted_by_user_id AS deleted_by_user_id_7 FROM vehicle t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.license_plate AS license_plate_3,
  t0.type AS type_4,
  t0.deleted_at AS deleted_at_5,
  t0.primary_driver_id AS primary_driver_id_6,
  t0.deleted_by_user_id AS deleted_by_user_id_7
FROM
  vehicle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.license_plate AS license_plate_3, t0.type AS type_4, t0.deleted_at AS deleted_at_5, t0.primary_driver_id AS primary_driver_id_6, t0.deleted_by_user_id AS deleted_by_user_id_7 FROM vehicle t0 WHERE t0.id = 2;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 43)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1099)
3	Doctrine\DBAL\Connection->executeQuery (line 776)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
5	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
6	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
7	Proxies\__CG__\App\Entity\Vehicle::Doctrine\ORM\Proxy\{closure} (line 59)
8	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
9	Proxies\__CG__\App\Entity\Vehicle->__get (line 42)
10	App\Entity\Vehicle->getName (line 32)
11	App\Entity\Vehicle->__toString (line 1353)
12	Twig\Extension\CoreExtension::testEmpty (line 479)
13	__TwigTemplate_52d28d4963543ef06b05007acc102f7e->block_page_content (line 437)
14	Twig\Template->yieldBlock (line 190)
15	__TwigTemplate_820617dcaf79d155f5934bf0116124fa->doDisplay (line 393)
16	Twig\Template->yield (line 71)
17	__TwigTemplate_a0cdabd05543804faca0e06ba4769aaa->doDisplay (line 393)
18	Twig\Template->yield (line 68)
19	__TwigTemplate_52d28d4963543ef06b05007acc102f7e->doDisplay (line 393)
20	Twig\Template->yield (line 349)
21	Twig\Template->display (line 364)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 306)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 83)
28	App\Controller\Driver\OrderController->index (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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\User	No errors.
App\Entity\Order\Order	No errors.
App\Entity\Order\State	No errors.
App\Entity\Contact\Contact	No errors.
App\Entity\Vehicle	No errors.
App\Entity\Order\Address\Address	No errors.
App\Entity\Order\Address\UnloadingPoint	No errors.
App\Entity\Order\Address\LoadingPoint	No errors.
App\Entity\Order\Signature	No errors.
App\Entity\DeliveryNote\DeliveryNote	No errors.
App\Entity\Invoice\Invoice	No errors.
App\Entity\Order\Charge	No errors.
App\Entity\Order\Document	No errors.
App\Entity\Order\DocumentFromDriver	No errors.
App\Entity\Contact\Address	No errors.
App\Entity\DeliveryNote\Contact	No errors.
App\Entity\Contact\MailAddress	No errors.
App\Entity\Invoice\Contact	No errors.

Symfony Profiler

GET https://clement.netzhirsch.de/driver/order/list

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping