GET https://westmar.intgate.io/warehouse/api/items/search?limit=200&q=&warehouse=3

Query Metrics

104 Database Queries
5 Different statements
7.48 ms Query time
0 Invalid entities
113 Managed entities

Queries

Group similar statements

# Time Info
1 0.18 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.position AS position_7, t0.user_group AS user_group_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.created_by_name AS created_by_name_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.43 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.material AS material_2, w0_.dimension AS dimension_3, w0_.quantity AS quantity_4, w0_.cut_length AS cut_length_5, w0_.warning_level AS warning_level_6, w0_.price AS price_7, w0_.position AS position_8, w0_.supplier AS supplier_9, w0_.product_code AS product_code_10, w0_.image_file_name AS image_file_name_11, w0_.created_at AS created_at_12, w0_.updated_at AS updated_at_13, w0_.item_type AS item_type_14, w0_.is_active AS is_active_15, w0_.unit_id AS unit_id_16, w0_.warehouse_id AS warehouse_id_17, w0_.category_id AS category_id_18, w0_.subcategory_id AS subcategory_id_19 FROM warehouse_items w0_ WHERE (w0_.name LIKE ? OR w0_.material LIKE ? OR w0_.dimension LIKE ?) AND w0_.warehouse_id = ? ORDER BY w0_.name ASC LIMIT 100
Parameters:
[
  "%%"
  "%%"
  "%%"
  3
]
3 0.17 ms
SELECT COUNT(w0_.id) AS sclr_0 FROM warehouse_items w0_ WHERE (w0_.name LIKE ? OR w0_.material LIKE ? OR w0_.dimension LIKE ?) AND w0_.is_active = ? AND w0_.warehouse_id = ?
Parameters:
[
  "%%"
  "%%"
  "%%"
  1
  3
]
4 0.13 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2936
]
5 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_cut AS is_cut_4, t0.is_active AS is_active_5 FROM warehouse_units t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.10 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2939
]
7 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2937
]
8 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2940
]
9 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2938
]
10 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  8
]
11 0.10 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  10
]
12 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2824
]
13 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2964
]
14 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2771
]
15 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2772
]
16 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2769
]
17 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2770
]
18 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  3096
]
19 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  3095
]
20 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  3094
]
21 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2778
]
22 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  85
]
23 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  86
]
24 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  89
]
25 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  87
]
26 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  13
]
27 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  14
]
28 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  15
]
29 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  16
]
30 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  17
]
31 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  18
]
32 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2966
]
33 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  3051
]
34 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2928
]
35 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2965
]
36 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2820
]
37 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2821
]
38 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2817
]
39 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2818
]
40 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2833
]
41 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2834
]
42 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2825
]
43 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2832
]
44 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2826
]
45 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2835
]
46 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2827
]
47 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2836
]
48 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2837
]
49 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2828
]
50 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2830
]
51 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2829
]
52 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2831
]
53 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2838
]
54 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2839
]
55 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2945
]
56 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2944
]
57 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  38
]
58 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  49
]
59 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  55
]
60 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  59
]
61 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  95
]
62 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  98
]
63 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  100
]
64 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  51
]
65 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  93
]
66 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  94
]
67 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  97
]
68 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  101
]
69 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  123
]
70 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  122
]
71 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  124
]
72 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  132
]
73 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  133
]
74 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  31
]
75 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  23
]
76 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  30
]
77 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  11
]
78 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  24
]
79 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  129
]
80 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  82
]
81 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  84
]
82 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  102
]
83 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  110
]
84 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  106
]
85 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  35
]
86 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  134
]
87 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  120
]
88 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  121
]
89 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  128
]
90 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  136
]
91 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  138
]
92 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  43
]
93 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  58
]
94 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  26
]
95 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  22
]
96 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  64
]
97 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  79
]
98 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  28
]
99 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  29
]
100 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  88
]
101 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  83
]
102 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  57
]
103 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  111
]
104 0.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  112
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\WarehouseItem 100
App\Entity\WarehouseCategory 6
App\Entity\WarehouseItemValue 2
App\Entity\WarehouseCategoryField 2
App\Entity\User 1
App\Entity\WarehouseUnit 1
App\Entity\Warehouse 1