https://api.theswarm.io/api/order/status/2/659b2f65-e15f-4174-8352-f802aa57b00a

Query Metrics

3 Database Queries
3 Different statements
5.55 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 4.93 ms
SELECT t0.id AS id_1, t0.order_pos_id AS order_pos_id_2, t0.order_status AS order_status_3, t0.is_sent AS is_sent_4, t0.total_price AS total_price_5, t0.original_total_price AS original_total_price_6, t0.pickup_time AS pickup_time_7, t0.restaurant_id AS restaurant_id_8, t0.user_uuid AS user_uuid_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.order_items_json AS order_items_json_12, t0.used_reward AS used_reward_13, t0.gained_reward AS gained_reward_14, t0.wallet_deduct AS wallet_deduct_15, t0.order_items_names AS order_items_names_16, t0.order_reward_items AS order_reward_items_17, t0.remote_order_id AS remote_order_id_18, t0.stripe_id AS stripe_id_19, t0.remote_response AS remote_response_20, t0.discounts AS discounts_21 FROM customer_orders t0 WHERE t0.remote_order_id = ? LIMIT 1
Parameters:
[
  "659b2f65-e15f-4174-8352-f802aa57b00a"
]
2 0.42 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.firebase_id AS firebase_id_4, t0.reward_points AS reward_points_5, t0.wallet_amount AS wallet_amount_6, t0.phone_number AS phone_number_7, t0.fcm_token AS fcm_token_8, t0.push_notifications AS push_notifications_9, t0.apple_id AS apple_id_10, t0.birthday AS birthday_11 FROM user_info t0 WHERE t0.firebase_id = ? LIMIT 1
Parameters:
[
  "hcvYq1MQ3eYPJZG1Zs0lnqDM7Ps1"
]
3 0.20 ms
SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.name AS name_3, t0.pos_id AS pos_id_4, t0.pos_id_1050 AS pos_id_1050_5, t0.pos_id_10202 AS pos_id_10202_6, t0.image AS image_7, t0.price AS price_8, t0.is_active AS is_active_9, t0.description AS description_10, t0.category_id AS category_id_11 FROM food_item t0 WHERE t0.id = ?
Parameters:
[
  10
]

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.
App\Entity\UserInfo No errors.
App\Entity\FoodItem No errors.
App\Entity\FoodCategory No errors.
App\Entity\Toppings No errors.