Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

11.35 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
5.86 ms (51.60%)	1	SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status IN (?, ?) AND c0_.restaurant_id = ? AND (c0_.created_at BETWEEN ? AND ?) ORDER BY c0_.id DESC Parameters: [`"sent" "rejected" 1 "2025-04-05 00:00:00" "2025-04-05 23:59:59"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status IN (?, ?) AND c0_.restaurant_id = ? AND ( c0_.created_at BETWEEN ? AND ? ) ORDER BY c0_.id DESC SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status IN ('sent', 'rejected') AND c0_.restaurant_id = 1 AND (c0_.created_at BETWEEN '2025-04-05 00:00:00' AND '2025-04-05 23:59:59') ORDER BY c0_.id DESC;
5.49 ms (48.40%)	1	SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status = ? AND c0_.restaurant_id = ? AND (c0_.created_at BETWEEN ? AND ?) ORDER BY c0_.id DESC Parameters: [`"dispatched" 1 "2025-04-05 00:00:00" "2025-04-05 23:59:59"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status = ? AND c0_.restaurant_id = ? AND ( c0_.created_at BETWEEN ? AND ? ) ORDER BY c0_.id DESC SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status = 'dispatched' AND c0_.restaurant_id = 1 AND (c0_.created_at BETWEEN '2025-04-05 00:00:00' AND '2025-04-05 23:59:59') ORDER BY c0_.id DESC;

Time▼

Count

Info

5.86 ms
(51.60%)

SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status IN (?, ?) AND c0_.restaurant_id = ? AND (c0_.created_at BETWEEN ? AND ?) ORDER BY c0_.id DESC

Parameters:

[
  "sent"
  "rejected"
  1
  "2025-04-05 00:00:00"
  "2025-04-05 23:59:59"
]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.order_pos_id AS order_pos_id_1,
  c0_.order_status AS order_status_2,
  c0_.is_sent AS is_sent_3,
  c0_.total_price AS total_price_4,
  c0_.original_total_price AS original_total_price_5,
  c0_.pickup_time AS pickup_time_6,
  c0_.restaurant_id AS restaurant_id_7,
  c0_.user_uuid AS user_uuid_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.order_items_json AS order_items_json_11,
  c0_.used_reward AS used_reward_12,
  c0_.gained_reward AS gained_reward_13,
  c0_.wallet_deduct AS wallet_deduct_14,
  c0_.order_items_names AS order_items_names_15,
  c0_.order_reward_items AS order_reward_items_16,
  c0_.remote_order_id AS remote_order_id_17,
  c0_.stripe_id AS stripe_id_18,
  c0_.remote_response AS remote_response_19,
  c0_.discounts AS discounts_20
FROM
  customer_orders c0_
WHERE
  c0_.order_status IN (?, ?)
  AND c0_.restaurant_id = ?
  AND (
    c0_.created_at BETWEEN ?
    AND ?
  )
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status IN ('sent', 'rejected') AND c0_.restaurant_id = 1 AND (c0_.created_at BETWEEN '2025-04-05 00:00:00' AND '2025-04-05 23:59:59') ORDER BY c0_.id DESC;

5.49 ms
(48.40%)

SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status = ? AND c0_.restaurant_id = ? AND (c0_.created_at BETWEEN ? AND ?) ORDER BY c0_.id DESC

Parameters:

[
  "dispatched"
  1
  "2025-04-05 00:00:00"
  "2025-04-05 23:59:59"
]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.order_pos_id AS order_pos_id_1,
  c0_.order_status AS order_status_2,
  c0_.is_sent AS is_sent_3,
  c0_.total_price AS total_price_4,
  c0_.original_total_price AS original_total_price_5,
  c0_.pickup_time AS pickup_time_6,
  c0_.restaurant_id AS restaurant_id_7,
  c0_.user_uuid AS user_uuid_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.order_items_json AS order_items_json_11,
  c0_.used_reward AS used_reward_12,
  c0_.gained_reward AS gained_reward_13,
  c0_.wallet_deduct AS wallet_deduct_14,
  c0_.order_items_names AS order_items_names_15,
  c0_.order_reward_items AS order_reward_items_16,
  c0_.remote_order_id AS remote_order_id_17,
  c0_.stripe_id AS stripe_id_18,
  c0_.remote_response AS remote_response_19,
  c0_.discounts AS discounts_20
FROM
  customer_orders c0_
WHERE
  c0_.order_status = ?
  AND c0_.restaurant_id = ?
  AND (
    c0_.created_at BETWEEN ?
    AND ?
  )
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.order_pos_id AS order_pos_id_1, c0_.order_status AS order_status_2, c0_.is_sent AS is_sent_3, c0_.total_price AS total_price_4, c0_.original_total_price AS original_total_price_5, c0_.pickup_time AS pickup_time_6, c0_.restaurant_id AS restaurant_id_7, c0_.user_uuid AS user_uuid_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.order_items_json AS order_items_json_11, c0_.used_reward AS used_reward_12, c0_.gained_reward AS gained_reward_13, c0_.wallet_deduct AS wallet_deduct_14, c0_.order_items_names AS order_items_names_15, c0_.order_reward_items AS order_reward_items_16, c0_.remote_order_id AS remote_order_id_17, c0_.stripe_id AS stripe_id_18, c0_.remote_response AS remote_response_19, c0_.discounts AS discounts_20 FROM customer_orders c0_ WHERE c0_.order_status = 'dispatched' AND c0_.restaurant_id = 1 AND (c0_.created_at BETWEEN '2025-04-05 00:00:00' AND '2025-04-05 23:59:59') ORDER BY c0_.id DESC;

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\Order	The field 'App\Entity\Order#discounts' has the property type 'array' that differs from the metadata field type 'string' returned by the 'text' DBAL type.

Symfony Profiler

https://api.theswarm.io/api/orders/list/1

Configuration Settings

Theme