GET https://system.tesera.lt/admin?routeName=admin&routeParams%5BrouteParamName%5D=admin

Query Metrics

154 Database Queries
10 Different statements
85.16 ms Query time
7 Invalid entities
13828 Managed entities

Queries

Group similar statements

# Time Info
1 0.84 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.location_id AS location_id_3 FROM production_location t0
Parameters:
[]
3 1.26 ms
SELECT o0_.id AS id_0, o0_.completed AS completed_1, o0_.client_id AS client_id_2 FROM `order` o0_ WHERE o0_.completed = 0 ORDER BY o0_.id ASC LIMIT 1000
Parameters:
[]
4 5.24 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.quantity AS quantity_3, t0.client_id AS client_id_4, t0.product_id AS product_id_5, t0.attribute_id AS attribute_id_6, t0.order_id_id AS order_id_id_7, t0.production_location_id AS production_location_id_8 FROM loading t0
Parameters:
[]
5 11.65 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.date AS date_3, t0.production_location_id AS production_location_id_4, t0.product_id AS product_id_5, t0.product_attribute_id AS product_attribute_id_6 FROM production t0
Parameters:
[]
6 1.02 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
  1
]
7 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  6
]
10 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  2
]
11 0.85 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  3
]
13 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  4
]
14 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  13
]
15 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  7
]
16 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  27
]
17 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  17
]
18 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  14
]
19 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  27
]
20 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  11
]
21 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  4
]
22 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  9
]
23 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  8
]
24 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  53
]
25 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  21
]
26 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  28
]
27 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  15
]
28 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  7
]
29 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  20
]
30 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  14
]
31 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  18
]
32 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  26
]
33 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  9
]
34 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  45
]
35 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  23
]
36 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  10
]
37 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  12
]
38 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  33
]
39 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  35
]
40 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  22
]
41 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  8
]
42 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  41
]
43 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  11
]
44 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  26
]
45 0.70 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
  3
]
46 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  46
]
47 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  6
]
48 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  54
]
49 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  10
]
50 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  23
]
51 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  22
]
52 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  3
]
53 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  5
]
54 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  42
]
55 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  43
]
56 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  15
]
57 0.72 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
  4
]
58 0.58 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
  5
]
59 0.40 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
  6
]
60 0.46 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
  7
]
61 0.32 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
  8
]
62 0.30 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_attribute_id AS product_attribute_id_4, t0.location_id AS location_id_5 FROM warehouse t0 WHERE t0.location_id = ?
Parameters:
[
  9
]
63 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  25
]
64 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  21
]
65 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  20
]
66 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  16
]
67 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  17
]
68 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  12
]
69 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  28
]
70 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  29
]
71 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  30
]
72 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  32
]
73 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  34
]
74 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  19
]
75 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  35
]
76 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  25
]
77 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  31
]
78 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  29
]
79 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  40
]
80 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  32
]
81 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  37
]
82 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  38
]
83 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  34
]
84 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  33
]
85 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  39
]
86 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  40
]
87 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  41
]
88 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  42
]
89 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  43
]
90 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  44
]
91 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  5
]
92 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM attributes t0 WHERE t0.id = ?
Parameters:
[
  44
]
93 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  46
]
94 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  47
]
95 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  48
]
96 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  50
]
97 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  13
]
98 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  30
]
99 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM product t0 WHERE t0.id = ?
Parameters:
[
  49
]
100 0.86 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  607
]
101 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  64
]
102 0.69 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  721
]
103 0.43 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  752
]
104 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  422
]
105 0.42 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  786
]
106 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  438
]
107 0.43 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  822
]
108 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  458
]
109 0.37 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  829
]
110 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  460
]
111 0.48 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  840
]
112 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  457
]
113 0.46 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  869
]
114 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  473
]
115 0.46 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  870
]
116 0.48 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  895
]
117 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  478
]
118 0.73 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  900
]
119 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  486
]
120 0.48 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  907
]
121 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  483
]
122 0.42 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  911
]
123 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  484
]
124 0.58 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  914
]
125 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  485
]
126 0.50 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  916
]
127 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  487
]
128 0.46 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  919
]
129 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  368
]
130 0.56 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  920
]
131 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  432
]
132 0.49 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  921
]
133 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  431
]
134 0.41 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  922
]
135 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  453
]
136 0.54 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  923
]
137 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  430
]
138 0.45 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  925
]
139 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  489
]
140 0.64 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  933
]
141 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  490
]
142 0.48 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  934
]
143 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  491
]
144 0.43 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  936
]
145 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  492
]
146 0.49 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  939
]
147 0.47 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  940
]
148 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  493
]
149 0.54 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  941
]
150 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  65
]
151 0.64 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  942
]
152 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  494
]
153 0.51 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.moved_quantity AS moved_quantity_3, t0.product_id AS product_id_4, t0.order_id_id AS order_id_id_5, t0.order_product_attribute_id AS order_product_attribute_id_6 FROM order_products t0 WHERE t0.order_id_id = ?
Parameters:
[
  944
]
154 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.address AS address_4, t0.company_code AS company_code_5, t0.pvmcode AS pvmcode_6, t0.is_company AS is_company_7 FROM client t0 WHERE t0.id = ?
Parameters:
[
  471
]

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\Production 9065
App\Entity\Loading 3046
App\Entity\Order 877
App\Entity\Client 470
App\Entity\Warehouse 207
App\Entity\OrderProducts 64
App\Entity\Product 46
App\Entity\Attributes 40
App\Entity\ProductionLocation 8
App\Entity\Location 4
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\ProductionLocation
  • The association App\Entity\ProductionLocation#warehouses refers to the owning side field App\Entity\Warehouse#ProductionLocation which does not exist.
App\Entity\Location No errors.
App\Entity\Warehouse
  • The mappings App\Entity\Warehouse#Location and App\Entity\ProductionLocation#warehouses are inconsistent with each other.
App\Entity\Order
  • The association App\Entity\Order#client refers to the inverse side field App\Entity\Client#product which does not exist.
App\Entity\Client
  • The mappings App\Entity\Client#order and App\Entity\Order#client are inconsistent with each other.
App\Entity\OrderProducts
  • The mappings App\Entity\OrderProducts#product and App\Entity\Product#productOrders are inconsistent with each other.
  • The association App\Entity\OrderProducts#orderProductAttribute refers to the inverse side field App\Entity\Attributes#AttributeOrders which does not exist.
App\Entity\Loading No errors.
App\Entity\Product
  • The association App\Entity\Product#productOrders refers to the owning side field App\Entity\OrderProducts#productId which does not exist.
  • The mappings App\Entity\Product#Attributes and App\Entity\Warehouse#Product are inconsistent with each other.
App\Entity\Attributes
  • The mappings App\Entity\Attributes#attributeOrders and App\Entity\OrderProducts#orderProductAttribute are inconsistent with each other.
  • The association App\Entity\Attributes#warehouses refers to the owning side field App\Entity\Warehouse#Attributes which does not exist.
App\Entity\Production No errors.