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

Query Metrics

2 Database Queries
2 Different statements
10.45 ms Query time
1 Invalid entities
  • Queries
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Group similar statements

# Time Info
1 5.17 ms
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:
0 of 0
[ "dispatched" 1 "2025-04-05 00:00:00" "2025-04-05 23:59:59" ]
2 5.28 ms
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:
0 of 0
[ "sent" "rejected" 1 "2025-04-05 00:00:00" "2025-04-05 23:59:59" ]