Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.66 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.66 ms
(100.00%)

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.

Symfony Profiler

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

Configuration Settings

Theme