Query Metrics
2
Database Queries
2
Different statements
3.12 ms
Query time
0
Invalid entities
2
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.description AS description_9, t0.logo AS logo_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.delivery_fee AS delivery_fee_14, t0.minimum_order AS minimum_order_15, t0.owner_name AS owner_name_16, t0.setup_paid AS setup_paid_17, t0.api_key AS api_key_18, t0.latitude AS latitude_19, t0.longitude AS longitude_20, t0.website AS website_21, t0.allow_pickup AS allow_pickup_22, t0.allow_delivery AS allow_delivery_23, t0.orders_stopped AS orders_stopped_24, t0.preparation_time AS preparation_time_25, t0.delivery_radius AS delivery_radius_26, t0.delivery_instructions AS delivery_instructions_27, t0.payment_methods AS payment_methods_28, t0.delivery_time AS delivery_time_29, t0.pickup_time AS pickup_time_30, t0.paypal_client_id AS paypal_client_id_31, t0.paypal_client_secret AS paypal_client_secret_32, t0.paypal_webhook_id AS paypal_webhook_id_33, t0.paypal_sandbox AS paypal_sandbox_34, t0.paypal_enabled AS paypal_enabled_35, t0.paypal_fee_payer AS paypal_fee_payer_36, t0.paypal_fee_percentage AS paypal_fee_percentage_37, t0.paypal_fee_fixed AS paypal_fee_fixed_38, t0.stripe_publishable_key AS stripe_publishable_key_39, t0.stripe_secret_key AS stripe_secret_key_40, t0.stripe_webhook_secret AS stripe_webhook_secret_41, t0.stripe_enabled AS stripe_enabled_42, t0.onboarding_completed AS onboarding_completed_43, t0.current_onboarding_step AS current_onboarding_step_44, t0.menu_upload_status AS menu_upload_status_45, t0.menu_upload_progress AS menu_upload_progress_46, t0.menu_upload_file_path AS menu_upload_file_path_47, t0.menu_upload_error AS menu_upload_error_48, t0.menu_upload_started_at AS menu_upload_started_at_49, t0.menu_upload_completed_at AS menu_upload_completed_at_50, t0.menu_upload_payload AS menu_upload_payload_51, t0.menu_upload_retry_count AS menu_upload_retry_count_52, t0.printer_type AS printer_type_53, t0.printer_path AS printer_path_54, t0.printer_logo_path AS printer_logo_path_55, t0.setup_fee AS setup_fee_56, t0.monthly_fixed_fee AS monthly_fixed_fee_57, t0.per_order_fee_euro AS per_order_fee_euro_58, t0.per_order_fee_percent AS per_order_fee_percent_59, t0.tariff_id AS tariff_id_60, t0.affiliate_owner_id AS affiliate_owner_id_61, t0.agent_tariff_id AS agent_tariff_id_62 FROM restaurant t0 WHERE t0.api_key = ? LIMIT 1
Parameters:
[
"rest_8cd28871d01024cb5594c28d377b9285b1a0f4d2a6862d7b"
]
|
||||||||||||||||||||||||||
| 2 | 1.02 ms |
SELECT o0_.id AS id_0, o0_.order_number AS order_number_1, o0_.public_token AS public_token_2, o0_.order_type AS order_type_3, o0_.customer_name AS customer_name_4, o0_.customer_email AS customer_email_5, o0_.customer_phone AS customer_phone_6, o0_.delivery_address AS delivery_address_7, o0_.delivery_zip_code AS delivery_zip_code_8, o0_.delivery_city AS delivery_city_9, o0_.delivery_latitude AS delivery_latitude_10, o0_.delivery_longitude AS delivery_longitude_11, o0_.delivery_instructions AS delivery_instructions_12, o0_.pickup_time AS pickup_time_13, o0_.delivery_time AS delivery_time_14, o0_.subtotal AS subtotal_15, o0_.delivery_fee AS delivery_fee_16, o0_.tax AS tax_17, o0_.payment_fee AS payment_fee_18, o0_.total AS total_19, o0_.total_amount AS total_amount_20, o0_.status AS status_21, o0_.payment_status AS payment_status_22, o0_.payment_method AS payment_method_23, o0_.paypal_transaction_id AS paypal_transaction_id_24, o0_.paypal_order_id AS paypal_order_id_25, o0_.paypal_capture_id AS paypal_capture_id_26, o0_.paypal_refund_id AS paypal_refund_id_27, o0_.eta_minutes AS eta_minutes_28, o0_.notes AS notes_29, o0_.requested_time AS requested_time_30, o0_.preparing_at AS preparing_at_31, o0_.ready_at AS ready_at_32, o0_.completed_at AS completed_at_33, o0_.cancelled_at AS cancelled_at_34, o0_.cancellation_reason AS cancellation_reason_35, o0_.paid_at AS paid_at_36, o0_.pickup_phone AS pickup_phone_37, o0_.created_at AS created_at_38, o0_.updated_at AS updated_at_39, o0_.estimated_ready_time AS estimated_ready_time_40, o0_.confirmed_ready_time AS confirmed_ready_time_41, o0_.delay_accepted AS delay_accepted_42, o0_.restaurant_id AS restaurant_id_43, o0_.customer_id AS customer_id_44, o0_.delivery_zone_id AS delivery_zone_id_45 FROM `order` o0_ WHERE o0_.restaurant_id = ? AND o0_.status IN (?, ?, ?, ?, ?, ?) ORDER BY o0_.created_at DESC LIMIT 100
Parameters:
[ 1 "pending" "confirmed" "waiting_for_confirmation" "preparing" "ready" "out_for_delivery" ]
|
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 |
|---|---|
| App\Entity\Restaurant | 1 |
| App\Entity\Tariff | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Restaurant | No errors. |
| App\Entity\Tariff | No errors. |
| App\Entity\User | No errors. |
| App\Entity\AgentTariff | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Dish | No errors. |
| App\Entity\Ingredient | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\OpeningHours | No errors. |
| App\Entity\RestaurantHoliday | No errors. |
| App\Entity\DeliveryZone | No errors. |
| App\Entity\Size | No errors. |
| App\Entity\Choice | No errors. |
| App\Entity\SideDish | No errors. |
| App\Entity\Extra | No errors. |
| App\Entity\Order | No errors. |