Query Metrics

289 Database Queries
95 Different statements
1606.30 ms Query time
1 Invalid entities
0 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 4.56 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
2 5.60 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 1) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/es/productos/p/hexo-mini-1.0~49622"
  "path"
  "auto_create"
  "/es/productos/p/hexo-mini-1.0~49622"
  "path_query"
  "https://testing.weverducre.com/es/productos/p/hexo-mini-1.0~49622"
  "entire_uri"
]
3 4.73 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
4 4.60 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "reports"
  "pimcore"
]
5 4.99 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/es/productos/p/"
  "hexo-mini-1.0~49622"
]
6 5.35 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/es/productos/p/hexo-mini-1.0~49622"
]
7 5.22 ms
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/weverducre.com/%"
  "/es/productos/p/hexo-mini-1.0~49622"
]
8 4.80 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/es/productos/"
  "p"
]
9 4.33 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/es/productos/p"
]
10 4.44 ms
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/weverducre.com/%"
  "/es/productos/p"
]
11 4.53 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/es/"
  "productos"
]
12 4.70 ms
SELECT object_localized_SCONF_es.id as id, object_localized_SCONF_es.type as `type` FROM object_localized_SCONF_es LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1
AND `EcommerceB2B`.id = `object_localized_SCONF_es`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_es `EcommerceB2B_localized` ON 1
AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_es`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1
AND `EcommerceB2C`.id = `object_localized_SCONF_es`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_es `EcommerceB2C_localized` ON 1
AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_es`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?))  AND  object_localized_SCONF_es.type IN ('object','variant','folder')) AND object_localized_SCONF_es.published = 1 LIMIT 1
Parameters:
[
  "wdbe"
  "wdbe"
]
13 4.43 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SCONF"
]
14 9.27 ms
SELECT * FROM object_relations_SCONF WHERE src_id = ?
Parameters:
[
  1547
]
15 4.54 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "prod"
]
16 5.60 ms
SELECT * FROM object_collection_AxVersion_prod WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  49622
  "axVersions"
]
17 4.80 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
18 4.69 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
19 9.30 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49622
]
20 4.74 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17349
]
21 4.75 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17202
]
22 4.87 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17175
]
23 4.78 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "EF_FD"
]
24 5.18 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  159
]
25 4.51 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  11
]
26 7.16 ms
SELECT object_localized_SOPT_es.id as id, object_localized_SOPT_es.type as `type` FROM object_localized_SOPT_es WHERE ((context = ?)  AND (val = ?)  AND  object_localized_SOPT_es.type IN ('object','variant','folder')) AND object_localized_SOPT_es.published = 1 LIMIT 1
Parameters:
[
  "color"
  "Gold"
]
27 5.20 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SOPT"
]
28 1.12 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  48
]
29 3.82 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  26
]
30 3.22 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  106
]
31 3.70 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  20
]
32 3.51 ms
SELECT object_localized_SOPT_es.id as id, object_localized_SOPT_es.type as `type` FROM object_localized_SOPT_es WHERE ((context = ?)  AND (val = ?)  AND  object_localized_SOPT_es.type IN ('object','variant','folder')) AND object_localized_SOPT_es.published = 1 LIMIT 1
Parameters:
[
  "color"
  "Gold"
]
33 3.32 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "PCAT"
]
34 3.37 ms
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1  ORDER BY `prio` ASC
Parameters:
[]
35 3.49 ms
SELECT COUNT(*) FROM object_localized_7_es WHERE ((ifnull(headline, "") != "")  AND (products like ?)  AND  object_localized_7_es.type IN ('object','variant','folder')) AND object_localized_7_es.published = 1
Parameters:
[
  "%,17349,%"
]
36 3.53 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
37 3.57 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
38 3.70 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
39 3.70 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
40 3.63 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
41 3.74 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
42 3.72 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
43 3.68 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  12
]
44 3.32 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  13
]
45 3.51 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  14
]
46 3.45 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  15
]
47 3.37 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  37
]
48 3.39 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  8
]
49 3.45 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  7
]
50 3.45 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  41
]
51 3.89 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  9
]
52 3.94 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  168
]
53 3.82 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  177
]
54 3.75 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  31
]
55 3.81 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  225
]
56 3.87 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
57 4.57 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction"
  "entire_uri"
]
58 3.42 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
59 4.68 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
60 3.88 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  2526
]
61 3.91 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  16
]
62 4.09 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  2532
]
63 4.19 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4574046
]
64 3.92 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4574046
]
65 4.13 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4538784
]
66 3.70 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4538784
]
67 3.80 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
68 4.69 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
69 3.99 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  2530
]
70 4.29 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  41
]
71 3.91 ms
SELECT object_localized_8_es.id as id, object_localized_8_es.type as `type` FROM object_localized_8_es WHERE ( object_localized_8_es.type IN ('object','variant','folder')) AND object_localized_8_es.published = 1
Parameters:
[]
72 4.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "8"
]
73 4.28 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  2523
]
74 4.25 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  797541
]
75 4.37 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  797541
]
76 4.23 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "7"
]
77 4.40 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737995
]
78 4.28 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737995
]
79 4.00 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
80 5.17 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
81 4.30 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  2527
]
82 4.44 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  38
]
83 3.99 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  2494
]
84 4.26 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  2543
]
85 4.19 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5042933
]
86 4.29 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5042933
]
87 4.39 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  2203379
]
88 4.26 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  2203379
]
89 4.43 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
90 5.13 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
91 4.24 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  2529
]
92 4.34 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  39
]
93 4.11 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  2489
]
94 4.07 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737893
]
95 4.29 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737893
]
96 4.41 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737897
]
97 4.14 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737897
]
98 4.54 ms
SELECT id FROM assets WHERE id IN (4975663,4975848)
Parameters:
[]
99 4.08 ms
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
Parameters:
[
  17349
  4975663
  "projectImages"
  "object"
  ""
  "0"
  1
]
100 4.19 ms
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
Parameters:
[
  17349
  4975848
  "projectImages"
  "object"
  ""
  "0"
  2
]
101 27.71 ms
select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
Parameters:
[]
102 4.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4975663
]
103 4.26 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4975663
]
104 4.50 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4976279
]
105 4.34 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4976279
]
106 4.48 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4976282
]
107 4.47 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4976282
]
108 4.33 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4976275
]
109 4.30 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4976275
]
110 4.47 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4976272
]
111 4.64 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4976272
]
112 4.36 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4976279
]
113 4.50 ms
SELECT * FROM object_relations_PCAT WHERE src_id = ?
Parameters:
[
  22223
]
114 4.74 ms
SELECT * FROM object_relations_PCAT WHERE src_id = ?
Parameters:
[
  22233
]
115 4.56 ms
SELECT * FROM object_relations_PCAT WHERE src_id = ?
Parameters:
[
  22236
]
116 4.63 ms
SELECT * FROM object_relations_PCAT WHERE src_id = ?
Parameters:
[
  22239
]
117 4.56 ms
SELECT * FROM object_relations_PCAT WHERE src_id = ?
Parameters:
[
  22221
]
118 4.44 ms
SELECT * FROM object_relations_PCAT WHERE src_id = ?
Parameters:
[
  128511
]
119 4.53 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "ACPAL"
]
120 4.68 ms
SELECT * FROM object_collection_AccessoryDemand_ACPAL WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  74043
  "accessoryDemands"
]
121 4.62 ms
SELECT * FROM object_collection_AccessoryDemand_localized_ACPAL WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  74043
  "accessoryDemands"
  0
]
122 4.76 ms
SELECT * FROM object_relations_ACPAL WHERE src_id = ?
Parameters:
[
  74043
]
123 4.79 ms
SELECT id FROM objects WHERE id IN (28389,28390,22376,23748,22378,68181)
Parameters:
[]
124 4.67 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  74043
  28389
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  1
]
125 4.75 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  74043
  28390
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  2
]
126 4.78 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  74043
  22376
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  3
]
127 4.82 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  74043
  23748
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  4
]
128 4.75 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  74043
  22378
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  5
]
129 4.84 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  74043
  68181
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  6
]
130 4.53 ms
SELECT id FROM objects WHERE published=1 AND id IN (28389,28390,22376,23748,22378,68181);
Parameters:
[]
131 4.60 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "ACCES"
]
132 4.50 ms
SELECT * FROM object_collection_AccessoryDemand_ACPAL WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  50894
  "accessoryDemands"
]
133 4.83 ms
SELECT * FROM object_collection_AccessoryDemand_localized_ACPAL WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  50894
  "accessoryDemands"
  0
]
134 3.12 ms
SELECT * FROM object_relations_ACPAL WHERE src_id = ?
Parameters:
[
  50894
]
135 4.81 ms
SELECT id FROM objects WHERE id IN (50886,50887,50888,50889)
Parameters:
[]
136 4.15 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  50894
  50886
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  1
]
137 4.81 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  50894
  50887
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  2
]
138 4.62 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  50894
  50888
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  3
]
139 4.84 ms
SELECT * FROM object_metadata_ACPAL WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (`type` = 'object' or `type` = '')
Parameters:
[
  50894
  50889
  "accessories"
  "fieldcollection"
  "accessoryDemands"
  "0"
  4
]
140 4.80 ms
SELECT id FROM objects WHERE published=1 AND id IN (50886,50887,50888,50889);
Parameters:
[]
141 24.50 ms
select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
Parameters:
[]
142 4.45 ms
SELECT TRIM(`lampType`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`)
Parameters:
[]
143 0.48 ms
SELECT count(*) FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (IFNULL(isSalesItem, 0) = 0)
Parameters:
[]
144 0.54 ms
SELECT dest as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_es_relations a WHERE fieldname = 'colorObject' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest
Parameters:
[]
145 0.44 ms
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
Parameters:
[
  1553
]
146 0.43 ms
SELECT dest FROM ecommerceframework_productindex_wdbe_es_relations a WHERE fieldname = 'colorObject' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (TRIM(`lampType`) = 'PAR16')) GROUP BY dest
Parameters:
[]
147 0.48 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  187931
]
148 0.98 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  187931
]
149 4.92 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  187960
]
150 4.83 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  187960
]
151 4.44 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  187916
]
152 4.83 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  187916
]
153 4.98 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  187977
]
154 4.73 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  187977
]
155 3.35 ms
SELECT TRIM(`mountingText`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`mountingText`)
Parameters:
[]
156 3.35 ms
SELECT TRIM(`lightColorTemperature`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`)
Parameters:
[]
157 4.95 ms
SELECT TRIM(`resultPowerPerLengthSelect`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`resultPowerPerLengthSelect`)
Parameters:
[]
158 4.91 ms
SELECT TRIM(`opticsCategory`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`opticsCategory`)
Parameters:
[]
159 4.92 ms
SELECT TRIM(`itemNumber`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`itemNumber`)
Parameters:
[]
160 61.29 ms
SELECT `itemNumber` FROM ecommerceframework_productindex_wdbe_es a  INNER JOIN ecommerceframework_productindex_wdbe_es_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_es_relations WHERE `fieldname` = 'colorObject' AND dest = '23499') AND (((virtualProductId = '17349' and a.id != '17349') or parentProducts like '%,17349,%')) AND (TRIM(`lampType`) = 'PAR16') GROUP BY `itemNumber`
Parameters:
[]
161 4.48 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5422274
]
162 4.78 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5422274
]
163 5.05 ms
SELECT * FROM object_relations_ACCES WHERE src_id = ?
Parameters:
[
  50886
]
164 5.11 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5422272
]
165 4.82 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5422272
]
166 4.83 ms
SELECT * FROM object_relations_ACCES WHERE src_id = ?
Parameters:
[
  50887
]
167 4.61 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4976865
]
168 4.32 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4976865
]
169 4.92 ms
SELECT * FROM object_relations_ACCES WHERE src_id = ?
Parameters:
[
  50888
]
170 5.01 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5422273
]
171 4.81 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5422273
]
172 5.02 ms
SELECT * FROM object_relations_ACCES WHERE src_id = ?
Parameters:
[
  50889
]
173 5.53 ms
SELECT sum(a0_.amount) AS sclr_0 FROM app_stock_reservation a0_ WHERE a0_.itemNumber = ?
Parameters:
[
  "000398289"
]
174 5.03 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "LCONF"
]
175 6.88 ms
SELECT object_localized_prod_es.id as id, object_localized_prod_es.type as `type` FROM object_localized_prod_es WHERE (`itemNumber` = '258420G0'  AND  object_localized_prod_es.type IN ('variant','object')) AND object_localized_prod_es.published = 1 LIMIT 1
Parameters:
[]
176 5.07 ms
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
Parameters:
[
  146
]
177 5.34 ms
SELECT assets.id, assets.type FROM assets WHERE parentId = ? ORDER BY `filename` ASC
Parameters:
[
  1196332
]
178 206.17 ms
(
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_es as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.productType = ? and o.chapterId = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_es as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.productType = ? and o.lineName = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_es as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.itemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_es as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale`
            from object_localized_prod_es as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale`
            from object_localized_prod_es as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
Parameters:
[
  "chapter"
  "917"
  "line"
  "HEXO mini 1.0"
  "258420G0"
  "article"
  "258420G0"
  "aspect"
  "258420G0"
  "aspect"
  "258420G0"
  "aspect"
]
179 4.48 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5426143
]
180 4.50 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5426143
]
181 3.68 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5426143
]
182 3.82 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5426143
]
183 3.87 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5439773
]
184 3.75 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5439773
]
185 3.69 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5439773
]
186 3.80 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5439773
]
187 4.10 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5458596
]
188 3.77 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5458596
]
189 3.63 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5458596
]
190 3.77 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5458596
]
191 3.49 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5470424
]
192 4.27 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5470424
]
193 3.68 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5470424
]
194 3.75 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5470424
]
195 3.89 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5510538
]
196 6.53 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5510538
]
197 3.94 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5510538
]
198 3.96 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5510538
]
199 2.72 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5547401
]
200 2.95 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5547401
]
201 2.28 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5547401
]
202 2.63 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5547401
]
203 3.08 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5475015
]
204 2.58 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5475015
]
205 2.60 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5475015
]
206 2.70 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5475015
]
207 2.91 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5492193
]
208 2.86 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5492193
]
209 2.95 ms
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  5492193
]
210 2.65 ms
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5492193
]
211 2.06 ms
SELECT object_localized_prod_es.id as id, object_localized_prod_es.type as `type` FROM object_localized_prod_es WHERE (itemNumber is null)  AND (productType = ?)  AND  object_localized_prod_es.type IN ('object','variant','folder') LIMIT 1
Parameters:
[
  "article"
]
212 2.08 ms
SELECT object_localized_prod_es.id as id, object_localized_prod_es.type as `type` FROM object_localized_prod_es WHERE (itemNumber = ?)  AND (productType = ?)  AND  object_localized_prod_es.type IN ('object','variant','folder') LIMIT 1
Parameters:
[
  "258420G0"
  "article"
]
213 3.81 ms
SELECT object_localized_prod_es.id as id, object_localized_prod_es.type as `type` FROM object_localized_prod_es WHERE (itemNumber = ?)  AND (productType = ?)  AND  object_localized_prod_es.type IN ('object','variant','folder') LIMIT 1
Parameters:
[
  "258420G0 900199W3"
  "article"
]
214 2.93 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  94824
]
215 2.87 ms
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  94824
]
216 9.07 ms
SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE
Parameters:
[
  94824
]
217 3.21 ms
SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
Parameters:
[
  94824
]
218 3.02 ms
select `iconLabels` from object_store_prod where oo_id  = 94824
Parameters:
[]
219 2.76 ms
SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ?
Parameters:
[
  94824
  "videos"
]
220 3.08 ms
SELECT * FROM object_classificationstore_groups_prod WHERE id = 94824 AND fieldname = 'attributes'
Parameters:
[]
221 3.80 ms
SELECT * FROM object_classificationstore_data_prod WHERE id = 94824 AND fieldname = 'attributes'
Parameters:
[]
222 2.88 ms
select `combinedBlock` from object_store_prod where oo_id  = 94824
Parameters:
[]
223 2.66 ms
select `colorMatchExceptions` from object_store_prod where oo_id  = 94824
Parameters:
[]
224 2.71 ms
select `accessoryDemand` from object_store_prod where oo_id  = 94824
Parameters:
[]
225 2.67 ms
select `accessoryFilterGroups` from object_store_prod where oo_id  = 94824
Parameters:
[]
226 2.70 ms
select `combinedImage` from object_store_prod where oo_id  = 94824
Parameters:
[]
227 3.12 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  94824
]
228 4.10 ms
SELECT object_localized_prod_es.id as id, object_localized_prod_es.type as `type` FROM object_localized_prod_es WHERE (itemNumber = ?)  AND (productType = ?)  AND  object_localized_prod_es.type IN ('object','variant','folder') LIMIT 1
Parameters:
[
  "258420G0 900199Q3"
  "article"
]
229 3.07 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  94828
]
230 3.20 ms
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  94828
]
231 6.40 ms
SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE
Parameters:
[
  94828
]
232 3.15 ms
SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
Parameters:
[
  94828
]
233 2.95 ms
select `iconLabels` from object_store_prod where oo_id  = 94828
Parameters:
[]
234 3.09 ms
SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ?
Parameters:
[
  94828
  "videos"
]
235 3.12 ms
SELECT * FROM object_classificationstore_groups_prod WHERE id = 94828 AND fieldname = 'attributes'
Parameters:
[]
236 3.86 ms
SELECT * FROM object_classificationstore_data_prod WHERE id = 94828 AND fieldname = 'attributes'
Parameters:
[]
237 3.24 ms
select `combinedBlock` from object_store_prod where oo_id  = 94828
Parameters:
[]
238 3.22 ms
select `colorMatchExceptions` from object_store_prod where oo_id  = 94828
Parameters:
[]
239 3.23 ms
select `accessoryDemand` from object_store_prod where oo_id  = 94828
Parameters:
[]
240 2.82 ms
select `accessoryFilterGroups` from object_store_prod where oo_id  = 94828
Parameters:
[]
241 3.11 ms
select `combinedImage` from object_store_prod where oo_id  = 94828
Parameters:
[]
242 3.14 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  94828
]
243 4.12 ms
SELECT object_localized_prod_es.id as id, object_localized_prod_es.type as `type` FROM object_localized_prod_es WHERE (itemNumber = ?)  AND (productType = ?)  AND  object_localized_prod_es.type IN ('object','variant','folder') LIMIT 1
Parameters:
[
  "258420G0 900199G3"
  "article"
]
244 3.06 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  94832
]
245 3.19 ms
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  94832
]
246 6.39 ms
SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE
Parameters:
[
  94832
]
247 3.17 ms
SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
Parameters:
[
  94832
]
248 3.00 ms
select `iconLabels` from object_store_prod where oo_id  = 94832
Parameters:
[]
249 3.11 ms
SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ?
Parameters:
[
  94832
  "videos"
]
250 3.18 ms
SELECT * FROM object_classificationstore_groups_prod WHERE id = 94832 AND fieldname = 'attributes'
Parameters:
[]
251 3.61 ms
SELECT * FROM object_classificationstore_data_prod WHERE id = 94832 AND fieldname = 'attributes'
Parameters:
[]
252 2.89 ms
select `combinedBlock` from object_store_prod where oo_id  = 94832
Parameters:
[]
253 3.23 ms
select `colorMatchExceptions` from object_store_prod where oo_id  = 94832
Parameters:
[]
254 3.24 ms
select `accessoryDemand` from object_store_prod where oo_id  = 94832
Parameters:
[]
255 3.25 ms
select `accessoryFilterGroups` from object_store_prod where oo_id  = 94832
Parameters:
[]
256 3.21 ms
select `combinedImage` from object_store_prod where oo_id  = 94832
Parameters:
[]
257 3.15 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  94832
]
258 4.12 ms
SELECT object_localized_prod_es.id as id, object_localized_prod_es.type as `type` FROM object_localized_prod_es WHERE (itemNumber = ?)  AND (productType = ?)  AND  object_localized_prod_es.type IN ('object','variant','folder') LIMIT 1
Parameters:
[
  "258420G0 900199B3"
  "article"
]
259 3.01 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  94836
]
260 3.20 ms
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  94836
]
261 6.94 ms
SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE
Parameters:
[
  94836
]
262 3.24 ms
SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
Parameters:
[
  94836
]
263 3.26 ms
select `iconLabels` from object_store_prod where oo_id  = 94836
Parameters:
[]
264 3.33 ms
SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ?
Parameters:
[
  94836
  "videos"
]
265 3.15 ms
SELECT * FROM object_classificationstore_groups_prod WHERE id = 94836 AND fieldname = 'attributes'
Parameters:
[]
266 3.91 ms
SELECT * FROM object_classificationstore_data_prod WHERE id = 94836 AND fieldname = 'attributes'
Parameters:
[]
267 2.95 ms
select `combinedBlock` from object_store_prod where oo_id  = 94836
Parameters:
[]
268 3.19 ms
select `colorMatchExceptions` from object_store_prod where oo_id  = 94836
Parameters:
[]
269 3.20 ms
select `accessoryDemand` from object_store_prod where oo_id  = 94836
Parameters:
[]
270 3.20 ms
select `accessoryFilterGroups` from object_store_prod where oo_id  = 94836
Parameters:
[]
271 3.25 ms
select `combinedImage` from object_store_prod where oo_id  = 94836
Parameters:
[]
272 3.64 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  94836
]
273 3.61 ms
(
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_es as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.productType = ? and o.chapterId = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_es as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.productType = ? and o.lineName = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_es as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.itemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_es as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale`
            from object_localized_prod_es as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale`
            from object_localized_prod_es as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
Parameters:
[
  "chapter"
  "917"
  "line"
  "HEXO mini 1.0"
  "258420G0"
  "article"
  "258420G0"
  "aspect"
  "258420G0"
  "aspect"
  "258420G0"
  "aspect"
]
274 3.13 ms
SELECT object_localized_prod_es.id as id, object_localized_prod_es.type as `type` FROM object_localized_prod_es WHERE (itemNumber is null)  AND (productType = ?)  AND  object_localized_prod_es.type IN ('object','variant','folder') LIMIT 1
Parameters:
[
  "article"
]
275 3.31 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4976269
]
276 3.38 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4976269
]
277 3.29 ms
SELECT assets.id, assets.type FROM assets WHERE parentId = ? ORDER BY `filename` ASC
Parameters:
[
  1196331
]
278 3.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
279 4.57 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=es&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction"
  "entire_uri"
]
280 3.76 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  2525
]
281 3.49 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  10
]

ax connection

# Time Info
1 28.71 ms
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
Parameters:
[
  "wdbe"
  "G_TG"
  "000398289"
]
2 29.68 ms
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
Parameters:
[
  "wdbe"
  "G_TG"
  "000398289"
]
3 29.22 ms
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
Parameters:
[
  "wdbe"
  "G_TG"
  "000398289"
]
4 28.94 ms
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
Parameters:
[
  "wdbe"
  "G_TG"
  "000398289"
]
5 1.15 ms
SELECT * FROM WS_AVAILABLEPHYSICAL WHERE ITEMID = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
  "000398289"
]
6 2.59 ms
SELECT *
            FROM WS_SALESPRICE
            WHERE ITEMNUMBER IN (?)
Parameters:
[
  "000398289"
]
7 28.98 ms
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
Parameters:
[
  "wdbe"
  "G_TG"
  "000398289"
]
8 28.96 ms
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
Parameters:
[
  "wdbe"
  "G_TG"
  "000398289"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
ax doctrine.dbal.ax_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

Entities Mapping

Class Mapping errors
App\Entity\StockReservation
  • The field 'App\Entity\StockReservation#amount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.