Redirect 302 redirect from POST @app_login (61deed)

GET https://zamowienia.dhapps.co.pl/order/

Query Metrics

57 Database Queries
16 Different statements
16.14 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.38 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.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  179
]
2 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.city AS city_4, t0.address AS address_5, t0.month_limit AS month_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.postcode AS postcode_9, t0.email AS email_10, t0.shortcut AS shortcut_11, t0.logo AS logo_12, t0.www AS www_13, t0.nip AS nip_14 FROM hotel t0 WHERE t0.id = ?
Parameters:
[
  29
]
3 0.55 ms
SELECT t0.id AS id_1, t0.hotel_id AS hotel_id_2, t0.supplier_id AS supplier_id_3 FROM hotel_has_supplier t0 WHERE t0.hotel_id = ?
Parameters:
[
  29
]
4 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sell_limit AS sell_limit_3, t0.hotel_id AS hotel_id_4 FROM hotel_department t0 WHERE t0.id = ?
Parameters:
[
  141
]
5 0.48 ms
SELECT t0.id AS id_1, t0.hotel_has_supplier_id AS hotel_has_supplier_id_2, t0.department_id AS department_id_3 FROM hotel_supplier_exclude_department t0 WHERE t0.department_id = ?
Parameters:
[
  141
]
6 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  15
]
7 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  37
]
8 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  32
]
9 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  31
]
10 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  30
]
11 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  29
]
12 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  27
]
13 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  25
]
14 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  24
]
15 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  23
]
16 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  22
]
17 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  18
]
18 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  16
]
19 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  39
]
20 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  43
]
21 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  35
]
22 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  41
]
23 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  47
]
24 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  36
]
25 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  49
]
26 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  48
]
27 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  50
]
28 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  26
]
29 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  34
]
30 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  19
]
31 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  80
]
32 0.27 ms
SELECT t0.id AS id_1, t0.hotel_department_id AS hotel_department_id_2, t0.product_category_id AS product_category_id_3 FROM hotel_department_has_exclude_category t0 WHERE t0.hotel_department_id = ?
Parameters:
[
  141
]
33 0.15 ms
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM product_category p0_ ORDER BY p0_.name ASC
Parameters:
[]
34 3.67 ms
SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id LEFT JOIN `user` u5_ ON o0_.user_id = u5_.id LEFT JOIN hotel h6_ ON o0_.hotel_id = h6_.id LEFT JOIN hotel_department h7_ ON h6_.id = h7_.hotel_id WHERE o0_.status <> ? AND o0_.hotel_id = ? AND h7_.id = ? AND u5_.id = ? GROUP BY o0_.id
Parameters:
[
  "template"
  29
  141
  179
]
35 1.04 ms
SELECT DISTINCT o0_.id AS id_0, o0_.id AS id_1 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id LEFT JOIN `user` u5_ ON o0_.user_id = u5_.id LEFT JOIN hotel h6_ ON o0_.hotel_id = h6_.id LEFT JOIN hotel_department h7_ ON h6_.id = h7_.hotel_id WHERE o0_.status <> ? AND o0_.hotel_id = ? AND h7_.id = ? AND u5_.id = ? GROUP BY o0_.id ORDER BY o0_.id DESC LIMIT 50
Parameters:
[
  "template"
  29
  141
  179
]
36 0.79 ms
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.is_confirmed AS is_confirmed_2, o0_.status AS status_3, o0_.order_number AS order_number_4, o0_.is_template AS is_template_5, o0_.template_name AS template_name_6, o0_.basket_number AS basket_number_7, o0_.is_only_template AS is_only_template_8, o0_.extra_data AS extra_data_9, o0_.updated_at AS updated_at_10, o0_.hotel_id AS hotel_id_11, o0_.user_id AS user_id_12, o0_.accepted_by_id AS accepted_by_id_13 FROM `order` o0_ LEFT JOIN order_has_product o1_ ON o0_.id = o1_.hotel_order_id LEFT JOIN supplier s2_ ON o1_.supplier_id = s2_.id LEFT JOIN product p3_ ON o1_.product_id = p3_.id LEFT JOIN supplier_has_product s4_ ON p3_.id = s4_.product_id LEFT JOIN `user` u5_ ON o0_.user_id = u5_.id LEFT JOIN hotel h6_ ON o0_.hotel_id = h6_.id LEFT JOIN hotel_department h7_ ON h6_.id = h7_.hotel_id WHERE o0_.status <> ? AND o0_.hotel_id = ? AND h7_.id = ? AND u5_.id = ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY o0_.id ORDER BY o0_.id DESC
Parameters:
[
  "template"
  29
  141
  179
  9103
  9087
  9058
  9047
  8981
  8646
  8499
  8489
  8485
]
37 0.22 ms
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.phone AS phone_2, h0_.city AS city_3, h0_.address AS address_4, h0_.month_limit AS month_limit_5, h0_.is_active AS is_active_6, h0_.created_at AS created_at_7, h0_.postcode AS postcode_8, h0_.email AS email_9, h0_.shortcut AS shortcut_10, h0_.logo AS logo_11, h0_.www AS www_12, h0_.nip AS nip_13 FROM hotel h0_ WHERE h0_.id = ? ORDER BY h0_.name ASC
Parameters:
[
  29
]
38 0.30 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.first_name AS first_name_5, u0_.last_name AS last_name_6, u0_.created_at AS created_at_7, u0_.is_active AS is_active_8, u0_.sell_limit AS sell_limit_9, u0_.position AS position_10, u0_.logo AS logo_11, u0_.phone AS phone_12, u0_.is_price_changed AS is_price_changed_13, u0_.last_price_read_at AS last_price_read_at_14, u0_.hotel_id AS hotel_id_15, u0_.hotel_department_id AS hotel_department_id_16 FROM `user` u0_ WHERE u0_.hotel_id = ? ORDER BY u0_.first_name ASC
Parameters:
[
  29
]
39 0.28 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.is_confirmed AS is_confirmed_3, t0.status AS status_4, t0.order_number AS order_number_5, t0.is_template AS is_template_6, t0.template_name AS template_name_7, t0.basket_number AS basket_number_8, t0.is_only_template AS is_only_template_9, t0.extra_data AS extra_data_10, t0.updated_at AS updated_at_11, t0.hotel_id AS hotel_id_12, t0.user_id AS user_id_13, t0.accepted_by_id AS accepted_by_id_14 FROM `order` t0 WHERE t0.user_id = ?
Parameters:
[
  179
]
40 0.31 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  9103
]
41 0.35 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  9103
]
42 0.19 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  9087
]
43 0.27 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  9087
]
44 0.17 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  9058
]
45 0.20 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  9058
]
46 0.24 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  9047
]
47 0.31 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  9047
]
48 0.15 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8981
]
49 0.27 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8981
]
50 0.20 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8646
]
51 0.30 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8646
]
52 0.20 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8499
]
53 0.22 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8499
]
54 0.18 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8489
]
55 0.23 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8489
]
56 0.17 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.hotel_order_id AS hotel_order_id_4, t0.product_id AS product_id_5, t0.supplier_id AS supplier_id_6 FROM order_has_product t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8485
]
57 0.19 ms
SELECT t0.id AS id_1, t0.invoice_no AS invoice_no_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.receipt_date AS receipt_date_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.number AS number_8, t0.date_confirmed AS date_confirmed_9, t0.hash AS hash_10, t0.is_api AS is_api_11, t0.supplier_comment AS supplier_comment_12, t0.supplier_number AS supplier_number_13, t0.comment AS comment_14, t0.extra_data AS extra_data_15, t0.api_status AS api_status_16, t0.api_status_description AS api_status_description_17, t0.is_accepted AS is_accepted_18, t0.accepted_at AS accepted_at_19, t0.hotel_order_id AS hotel_order_id_20, t0.supplier_id AS supplier_id_21, t0.accepted_by_id AS accepted_by_id_22 FROM delivery t0 WHERE t0.hotel_order_id = ?
Parameters:
[
  8485
]

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.