Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.66 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.66 ms

SELECT t0.name AS name_1, t0.radius AS radius_2, t0.zipcodeslist AS zipcodeslist_3, t0.pizza_count AS pizza_count_4, t0.active AS active_5, t0.street AS street_6, t0.house_number AS house_number_7, t0.city AS city_8, t0.postal_code AS postal_code_9, t0.phone AS phone_10, t0.email AS email_11, t0.time_slot AS time_slot_12, t0.time_slot_start AS time_slot_start_13, t0.time_slot_end AS time_slot_end_14, t0.time_slot_break_start AS time_slot_break_start_15, t0.time_slot_break_end AS time_slot_break_end_16, t0.adress_lat AS adress_lat_17, t0.adress_long AS adress_long_18, t0.accept_orders_from AS accept_orders_from_19, t0.chatId AS chatId_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t24.email AS email_25, t24.password AS password_26, t24.first_name AS first_name_27, t24.last_name AS last_name_28, t24.street AS street_29, t24.house_number AS house_number_30, t24.city AS city_31, t24.postal_code AS postal_code_32, t24.birth_date AS birth_date_33, t24.phone AS phone_34, t24.invite_code_used AS invite_code_used_35, t24.invite_code AS invite_code_36, t24.is_verified AS is_verified_37, t24.roles AS roles_38, t24.shipping_adresses AS shipping_adresses_39, t24.delivery_address_count AS delivery_address_count_40, t24.store_name AS store_name_41, t24.tax_number AS tax_number_42, t24.tax_department AS tax_department_43, t24.tax_office_location AS tax_office_location_44, t24.bank_name AS bank_name_45, t24.bank_account_holder AS bank_account_holder_46, t24.bank_iban AS bank_iban_47, t24.bank_bic AS bank_bic_48, t24.access_code AS access_code_49, t24.id AS id_50, t24.created_at AS created_at_51, t24.updated_at AS updated_at_52, t24.location_id AS location_id_53 FROM location t0 LEFT JOIN `user` t24 ON t24.location_id = t0.id WHERE t0.id = ?

Parameters:

[
  "0deebde7-ca6c-452f-870e-bf2e7186f338"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.radius AS radius_2,
  t0.zipcodeslist AS zipcodeslist_3,
  t0.pizza_count AS pizza_count_4,
  t0.active AS active_5,
  t0.street AS street_6,
  t0.house_number AS house_number_7,
  t0.city AS city_8,
  t0.postal_code AS postal_code_9,
  t0.phone AS phone_10,
  t0.email AS email_11,
  t0.time_slot AS time_slot_12,
  t0.time_slot_start AS time_slot_start_13,
  t0.time_slot_end AS time_slot_end_14,
  t0.time_slot_break_start AS time_slot_break_start_15,
  t0.time_slot_break_end AS time_slot_break_end_16,
  t0.adress_lat AS adress_lat_17,
  t0.adress_long AS adress_long_18,
  t0.accept_orders_from AS accept_orders_from_19,
  t0.chatId AS chatId_20,
  t0.id AS id_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t24.email AS email_25,
  t24.password AS password_26,
  t24.first_name AS first_name_27,
  t24.last_name AS last_name_28,
  t24.street AS street_29,
  t24.house_number AS house_number_30,
  t24.city AS city_31,
  t24.postal_code AS postal_code_32,
  t24.birth_date AS birth_date_33,
  t24.phone AS phone_34,
  t24.invite_code_used AS invite_code_used_35,
  t24.invite_code AS invite_code_36,
  t24.is_verified AS is_verified_37,
  t24.roles AS roles_38,
  t24.shipping_adresses AS shipping_adresses_39,
  t24.delivery_address_count AS delivery_address_count_40,
  t24.store_name AS store_name_41,
  t24.tax_number AS tax_number_42,
  t24.tax_department AS tax_department_43,
  t24.tax_office_location AS tax_office_location_44,
  t24.bank_name AS bank_name_45,
  t24.bank_account_holder AS bank_account_holder_46,
  t24.bank_iban AS bank_iban_47,
  t24.bank_bic AS bank_bic_48,
  t24.access_code AS access_code_49,
  t24.id AS id_50,
  t24.created_at AS created_at_51,
  t24.updated_at AS updated_at_52,
  t24.location_id AS location_id_53
FROM
  location t0
  LEFT JOIN `user` t24 ON t24.location_id = t0.id
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.radius AS radius_2, t0.zipcodeslist AS zipcodeslist_3, t0.pizza_count AS pizza_count_4, t0.active AS active_5, t0.street AS street_6, t0.house_number AS house_number_7, t0.city AS city_8, t0.postal_code AS postal_code_9, t0.phone AS phone_10, t0.email AS email_11, t0.time_slot AS time_slot_12, t0.time_slot_start AS time_slot_start_13, t0.time_slot_end AS time_slot_end_14, t0.time_slot_break_start AS time_slot_break_start_15, t0.time_slot_break_end AS time_slot_break_end_16, t0.adress_lat AS adress_lat_17, t0.adress_long AS adress_long_18, t0.accept_orders_from AS accept_orders_from_19, t0.chatId AS chatId_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t24.email AS email_25, t24.password AS password_26, t24.first_name AS first_name_27, t24.last_name AS last_name_28, t24.street AS street_29, t24.house_number AS house_number_30, t24.city AS city_31, t24.postal_code AS postal_code_32, t24.birth_date AS birth_date_33, t24.phone AS phone_34, t24.invite_code_used AS invite_code_used_35, t24.invite_code AS invite_code_36, t24.is_verified AS is_verified_37, t24.roles AS roles_38, t24.shipping_adresses AS shipping_adresses_39, t24.delivery_address_count AS delivery_address_count_40, t24.store_name AS store_name_41, t24.tax_number AS tax_number_42, t24.tax_department AS tax_department_43, t24.tax_office_location AS tax_office_location_44, t24.bank_name AS bank_name_45, t24.bank_account_holder AS bank_account_holder_46, t24.bank_iban AS bank_iban_47, t24.bank_bic AS bank_bic_48, t24.access_code AS access_code_49, t24.id AS id_50, t24.created_at AS created_at_51, t24.updated_at AS updated_at_52, t24.location_id AS location_id_53 FROM location t0 LEFT JOIN `user` t24 ON t24.location_id = t0.id WHERE t0.id = '0deebde7-ca6c-452f-870e-bf2e7186f338';

#	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 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\Location	No errors.
App\Entity\User	No errors.
App\Entity\OrderHeader	No errors.
App\Entity\VoucherCode	No errors.
App\Entity\Subscription	No errors.
App\Entity\Inventory	No errors.
App\Entity\InventoryLog	No errors.

Symfony Profiler

GET https://demo.inlovewithpizza.de/order/location/0deebde7-ca6c-452f-870e-bf2e7186f338?error%253DNoItems%3D=

Configuration Settings

Theme