Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.97 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.97 ms

SELECT t0.ordered_at AS ordered_at_1, t0.shipping_method AS shipping_method_2, t0.delivery_adress AS delivery_adress_3, t0.delivery_adress_lat AS delivery_adress_lat_4, t0.delivery_adress_long AS delivery_adress_long_5, t0.time AS time_6, t0.hints AS hints_7, t0.packaging_method AS packaging_method_8, t0.membership_type AS membership_type_9, t0.status AS status_10, t0.paid AS paid_11, t0.sent_delivery_notification AS sent_delivery_notification_12, t0.delivered_at AS delivered_at_13, t0.delivery_delay AS delivery_delay_14, t0.vip_discount_applied AS vip_discount_applied_15, t0.vip_discount_amount AS vip_discount_amount_16, t0.voucher_discount_amount AS voucher_discount_amount_17, t0.event_order_number AS event_order_number_18, t0.tip_amount AS tip_amount_19, t0.telegram_sent AS telegram_sent_20, t0.estimated_distance_km AS estimated_distance_km_21, t0.estimated_delivery_time_minutes AS estimated_delivery_time_minutes_22, t0.announced_delay_minutes AS announced_delay_minutes_23, t0.blocks_next_slot AS blocks_next_slot_24, t0.id AS id_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.location_id AS location_id_28, t0.user_id AS user_id_29, t0.delivery_id AS delivery_id_30, t0.voucher_id AS voucher_id_31, t0.pending_pizza_voucher_id AS pending_pizza_voucher_id_32 FROM order_header t0 WHERE t0.id = ?

Parameters:

[
  "64944b4e-d502-4bfd-af13-c9fc971df784"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.ordered_at AS ordered_at_1,
  t0.shipping_method AS shipping_method_2,
  t0.delivery_adress AS delivery_adress_3,
  t0.delivery_adress_lat AS delivery_adress_lat_4,
  t0.delivery_adress_long AS delivery_adress_long_5,
  t0.time AS time_6,
  t0.hints AS hints_7,
  t0.packaging_method AS packaging_method_8,
  t0.membership_type AS membership_type_9,
  t0.status AS status_10,
  t0.paid AS paid_11,
  t0.sent_delivery_notification AS sent_delivery_notification_12,
  t0.delivered_at AS delivered_at_13,
  t0.delivery_delay AS delivery_delay_14,
  t0.vip_discount_applied AS vip_discount_applied_15,
  t0.vip_discount_amount AS vip_discount_amount_16,
  t0.voucher_discount_amount AS voucher_discount_amount_17,
  t0.event_order_number AS event_order_number_18,
  t0.tip_amount AS tip_amount_19,
  t0.telegram_sent AS telegram_sent_20,
  t0.estimated_distance_km AS estimated_distance_km_21,
  t0.estimated_delivery_time_minutes AS estimated_delivery_time_minutes_22,
  t0.announced_delay_minutes AS announced_delay_minutes_23,
  t0.blocks_next_slot AS blocks_next_slot_24,
  t0.id AS id_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.location_id AS location_id_28,
  t0.user_id AS user_id_29,
  t0.delivery_id AS delivery_id_30,
  t0.voucher_id AS voucher_id_31,
  t0.pending_pizza_voucher_id AS pending_pizza_voucher_id_32
FROM
  order_header t0
WHERE
  t0.id = ?

SELECT t0.ordered_at AS ordered_at_1, t0.shipping_method AS shipping_method_2, t0.delivery_adress AS delivery_adress_3, t0.delivery_adress_lat AS delivery_adress_lat_4, t0.delivery_adress_long AS delivery_adress_long_5, t0.time AS time_6, t0.hints AS hints_7, t0.packaging_method AS packaging_method_8, t0.membership_type AS membership_type_9, t0.status AS status_10, t0.paid AS paid_11, t0.sent_delivery_notification AS sent_delivery_notification_12, t0.delivered_at AS delivered_at_13, t0.delivery_delay AS delivery_delay_14, t0.vip_discount_applied AS vip_discount_applied_15, t0.vip_discount_amount AS vip_discount_amount_16, t0.voucher_discount_amount AS voucher_discount_amount_17, t0.event_order_number AS event_order_number_18, t0.tip_amount AS tip_amount_19, t0.telegram_sent AS telegram_sent_20, t0.estimated_distance_km AS estimated_distance_km_21, t0.estimated_delivery_time_minutes AS estimated_delivery_time_minutes_22, t0.announced_delay_minutes AS announced_delay_minutes_23, t0.blocks_next_slot AS blocks_next_slot_24, t0.id AS id_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.location_id AS location_id_28, t0.user_id AS user_id_29, t0.delivery_id AS delivery_id_30, t0.voucher_id AS voucher_id_31, t0.pending_pizza_voucher_id AS pending_pizza_voucher_id_32 FROM order_header t0 WHERE t0.id = '64944b4e-d502-4bfd-af13-c9fc971df784';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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\OrderHeader	No errors.
App\Entity\Location	No errors.
App\Entity\User	No errors.
App\Entity\Delivery	No errors.
App\Entity\Voucher	No errors.
App\Entity\VoucherCode	No errors.
App\Entity\OrderPosition	The field 'App\Entity\OrderPosition#price' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type. The field 'App\Entity\OrderPosition#store_share' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\OrderPayment	The field 'App\Entity\OrderPayment#amount' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.

Symfony Profiler

GET http://demo.inlovewithpizza.de/completion/64944b4e-d502-4bfd-af13-c9fc971df784?amp%3D%26amp%253D%2526status%25253Dsuccess%253D%3D=

Configuration Settings

Theme