GET https://mellis-command.mypreprod.xyz/api/orders?limit=300&status=12

Query Metrics

59 Database Queries
7 Different statements
23.19 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.50 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "415a7875fa0841846q@melis.com"
]
2 0.44 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "415a7875fa0841846q@melis.com"
]
3 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created AS created_4, t0.updated AS updated_5 FROM "order_statut" t0 WHERE t0.id = ?
Parameters:
[
  "12"
]
4 0.90 ms
SELECT o0_.id AS id_0, o0_.deliver_to AS deliver_to_1, o0_.deliver_at AS deliver_at_2, o0_.amount AS amount_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.uid AS uid_6, o0_.hub AS hub_7, o0_.sale_type AS sale_type_8, o0_.note AS note_9, o0_.created AS created_10, o0_.updated AS updated_11, o0_.delivery_man_id AS delivery_man_id_12, o0_.commercial_id AS commercial_id_13, o0_.client_id AS client_id_14, o0_.distributor_id AS distributor_id_15, o0_.status_id AS status_id_16, o0_.local_area_id AS local_area_id_17, o0_.storage_id AS storage_id_18, o0_.driver_id AS driver_id_19, o0_.vehicle_id AS vehicle_id_20 FROM "order" o0_ WHERE o0_.status_id = ? ORDER BY o0_.status_id ASC LIMIT 300
Parameters:
[
  12
]
5 0.52 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  163355
]
6 0.68 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  161684
]
7 0.95 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  161684
]
8 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.local AS local_3, t0.sage_id AS sage_id_4 FROM local_area t0 WHERE t0.id = ?
Parameters:
[
  40
]
9 0.55 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  266
]
10 0.30 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  170990
]
11 0.35 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  170990
]
12 0.20 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  244
]
13 0.22 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  161570
]
14 0.33 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  161570
]
15 0.25 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  254
]
16 0.35 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  249
]
17 0.53 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  262
]
18 0.31 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  171159
]
19 0.27 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  171160
]
20 0.29 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  259
]
21 0.19 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  255
]
22 0.19 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  251
]
23 0.32 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  253
]
24 0.35 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  161562
]
25 0.39 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  161562
]
26 0.33 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  250
]
27 0.34 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  258
]
28 0.21 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  171222
]
29 0.26 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  161567
]
30 0.28 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  161567
]
31 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.local AS local_3, t0.sage_id AS sage_id_4 FROM local_area t0 WHERE t0.id = ?
Parameters:
[
  41
]
32 0.16 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  268
]
33 0.26 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  260
]
34 0.83 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  264
]
35 0.55 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  246
]
36 0.42 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  162520
]
37 0.86 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  162520
]
38 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.local AS local_3, t0.sage_id AS sage_id_4 FROM local_area t0 WHERE t0.id = ?
Parameters:
[
  45
]
39 0.47 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  242
]
40 0.39 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  241
]
41 0.46 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  247
]
42 0.35 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  161580
]
43 0.47 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  161580
]
44 0.35 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  269
]
45 0.37 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  161725
]
46 0.36 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  161725
]
47 0.22 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  248
]
48 0.27 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  261
]
49 0.25 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  263
]
50 0.30 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  252
]
51 0.26 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  265
]
52 0.25 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  243
]
53 0.26 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  245
]
54 0.20 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  257
]
55 0.33 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  271
]
56 0.31 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  161566
]
57 0.38 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?
Parameters:
[
  161566
]
58 0.25 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  270
]
59 0.22 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?
Parameters:
[
  272
]

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#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\User
  • The association App\Entity\User#equipmentAttributions refers to the owning side field App\Entity\EquipmentAttribution#users which does not exist.
App\Entity\Address No errors.
App\Entity\OrderHistory No errors.
App\Entity\EquipmentAttribution
  • The mappings App\Entity\EquipmentAttribution#user and App\Entity\User#equipmentAttributions are inconsistent with each other.
App\Entity\Equipment No errors.
App\Entity\LocalArea No errors.
App\Entity\Distributor No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\ProductPrice No errors.
App\Entity\Stock No errors.
App\Entity\Storage No errors.
App\Entity\ProductConnection No errors.
App\Entity\OrderStatut No errors.
App\Entity\OrderLine No errors.
App\Entity\Vehicle No errors.