Query Metrics
141
Database Queries
51
Different statements
32.17 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.41 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00site_domain_06c2195738ee89c603fd115fec0303e3" "site_domain_06c2195738ee89c603fd115fec0303e3" ] ] |
2 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_06c2195738ee89c603fd115fec0303e3\x00tags\x00" ] ] |
3 | 0.74 ms |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/webservice/yedi/data-object" "sourcePathQuery" => "/webservice/yedi/data-object?apikey=MDLA7ASF872AVNAQAUBWRP91Z6SAC5D12" "sourceEntireUri" => "https://pimcore-dev.kindermann.de/webservice/yedi/data-object?apikey=MDLA7ASF872AVNAQAUBWRP91Z6SAC5D12" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
4 | 0.30 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00system_route_redirect" "system_route_redirect" ] ] |
5 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ] ] |
6 | 0.20 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
7 | 0.44 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "data-object" "path" => "/webservice/yedi/" ] |
8 | 0.17 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/webservice/yedi/data-object" ] |
9 | 0.18 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "yedi" "path" => "/webservice/" ] |
10 | 0.14 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/webservice/yedi" ] |
11 | 0.20 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "webservice" "path" => "/" ] |
12 | 0.17 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/webservice" ] |
13 | 0.21 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "" "path" => "/" ] |
14 | 0.23 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00document_1" "document_1" ] ] |
15 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "document_1\x00tags\x00" ] ] |
16 | 0.18 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00document_properties_1" "document_properties_1" ] ] |
17 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "document_properties\x00tags\x00" "document_1\x00tags\x00" "document_properties_1\x00tags\x00" ] ] |
18 | 0.65 ms |
SELECT * FROM users WHERE `type` = ? AND `name` = ?
Parameters:
[ "user" "api" ] |
19 | 0.26 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
3
]
|
20 | 0.30 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
3
]
|
21 | 0.22 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
3
]
|
22 | 0.24 ms |
SELECT * FROM users WHERE `type` = ? AND `name` = ?
Parameters:
[ "user" "api" ] |
23 | 0.19 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
3
]
|
24 | 0.19 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
3
]
|
25 | 0.14 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
3
]
|
26 | 0.70 ms |
SELECT object_localized_7_en.o_id as o_id, object_localized_7_en.o_type as o_type FROM object_localized_7_en WHERE ((externer_schluessel='3009000245') AND object_localized_7_en.o_type IN ('object','folder')) AND object_localized_7_en.o_published = 1
Parameters:
[] |
27 | 0.28 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_34372" "object_34372" ] ] |
28 | 0.24 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_34372\x00tags\x00" "class_7\x00tags\x00" ] ] |
29 | 0.23 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"7"
]
|
30 | 0.22 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00system_resource_columns_quantityvalue_units" "system_resource_columns_quantityvalue_units" ] ] |
31 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "system\x00tags\x00" "resource\x00tags\x00" "system_resource_columns_quantityvalue_units\x00tags\x00" ] ] |
32 | 0.15 ms |
SELECT * FROM quantityvalue_units WHERE abbreviation='mm'
Parameters:
[] |
33 | 0.15 ms |
SELECT * FROM quantityvalue_units WHERE abbreviation='mm'
Parameters:
[] |
34 | 0.15 ms |
SELECT * FROM quantityvalue_units WHERE abbreviation='mm'
Parameters:
[] |
35 | 0.15 ms |
SELECT * FROM quantityvalue_units WHERE abbreviation='mm'
Parameters:
[] |
36 | 0.12 ms |
SELECT * FROM quantityvalue_units WHERE abbreviation='mm'
Parameters:
[] |
37 | 0.14 ms |
SELECT * FROM quantityvalue_units WHERE abbreviation='mm'
Parameters:
[] |
38 | 0.15 ms |
SELECT * FROM quantityvalue_units WHERE abbreviation='kg'
Parameters:
[] |
39 | 0.14 ms |
SELECT * FROM quantityvalue_units WHERE abbreviation='€'
Parameters:
[] |
40 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_21928" "object_21928" ] ] |
41 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_21928\x00tags\x00" "class_9\x00tags\x00" ] ] |
42 | 0.15 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
21928
]
|
43 | 0.19 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
21928
]
|
44 | 0.14 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"9"
]
|
45 | 0.13 ms |
SELECT * FROM object_store_9 WHERE oo_id = ?
Parameters:
[
21928
]
|
46 | 0.14 ms |
SELECT * FROM object_relations_9 WHERE src_id = ?
Parameters:
[
21928
]
|
47 | 0.17 ms |
SELECT CONCAT(o_path,`o_key`) as o_path FROM objects WHERE o_id = ?
Parameters:
[
21928
]
|
48 | 0.20 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "3009000245 - RISE 4205 Motorized Trolley 50" "path" => "/Produktdaten/Produkte/AKTIV/" ] |
49 | 0.16 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "3009000245 - RISE 4205 Motorized Trolley 50" "path" => "/Produktdaten/Produkte/AKTIV/" ] |
50 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
51 | 0.12 ms |
SELECT CONCAT(o_path,`o_key`) as o_path FROM objects WHERE o_id = ?
Parameters:
[
34372
]
|
52 | 0.29 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_15864" "object_15864" ] ] |
53 | 0.28 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_15864\x00tags\x00" "class_11\x00tags\x00" "asset_41091\x00tags\x00" ] ] |
54 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00asset_102658" "asset_102658" ] ] |
55 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "asset_102658\x00tags\x00" ] ] |
56 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00asset_102659" "asset_102659" ] ] |
57 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "asset_102659\x00tags\x00" ] ] |
58 | 0.19 ms |
SELECT id FROM assets WHERE id IN (102660,102661,102662)
Parameters:
[] |
59 | 0.52 ms |
SELECT * FROM object_metadata_7 WHERE object_metadata_7.o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND type = 'asset'
Parameters:
[ 34372 102660 "anleitungen" "object" "" "0" 1 ] |
60 | 0.31 ms |
SELECT * FROM object_metadata_7 WHERE object_metadata_7.o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND type = 'asset'
Parameters:
[ 34372 102661 "anleitungen" "object" "" "0" 2 ] |
61 | 0.33 ms |
SELECT * FROM object_metadata_7 WHERE object_metadata_7.o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND type = 'asset'
Parameters:
[ 34372 102662 "anleitungen" "object" "" "0" 3 ] |
62 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00asset_102660" "asset_102660" ] ] |
63 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "asset_102660\x00tags\x00" ] ] |
64 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00asset_102661" "asset_102661" ] ] |
65 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "asset_102661\x00tags\x00" ] ] |
66 | 0.22 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00asset_102662" "asset_102662" ] ] |
67 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "asset_102662\x00tags\x00" ] ] |
68 | 0.24 ms |
SELECT * FROM object_collection_Sachmerkmal_7 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 34372 "Sachmerkmal" ] |
69 | 0.21 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_34371" "object_34371" ] ] |
70 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_34371\x00tags\x00" "class_7\x00tags\x00" ] ] |
71 | 0.12 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
34371
]
|
72 | 0.16 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
34371
]
|
73 | 0.22 ms |
SELECT * FROM object_store_7 WHERE oo_id = ?
Parameters:
[
34371
]
|
74 | 0.20 ms |
SELECT * FROM object_localized_data_7 WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
34371
]
|
75 | 0.19 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
34371
]
|
76 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_34370" "object_34370" ] ] |
77 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_34370\x00tags\x00" "class_7\x00tags\x00" ] ] |
78 | 0.21 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 1 => null 2 => null 3 => null 4 => 1744927398 ] |
79 | 0.15 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
34370
]
|
80 | 0.16 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
34370
]
|
81 | 0.32 ms |
SELECT * FROM object_store_7 WHERE oo_id = ?
Parameters:
[
34370
]
|
82 | 0.22 ms |
SELECT * FROM object_localized_data_7 WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
34370
]
|
83 | 0.20 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
34370
]
|
84 | 0.18 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_34375" "object_34375" ] ] |
85 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_34375\x00tags\x00" "class_7\x00tags\x00" ] ] |
86 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_33391" "object_33391" ] ] |
87 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_33391\x00tags\x00" "class_7\x00tags\x00" ] ] |
88 | 0.13 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
33391
]
|
89 | 0.15 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
33391
]
|
90 | 0.21 ms |
SELECT * FROM object_store_7 WHERE oo_id = ?
Parameters:
[
33391
]
|
91 | 0.23 ms |
SELECT * FROM object_localized_data_7 WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
33391
]
|
92 | 0.20 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
33391
]
|
93 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_33392" "object_33392" ] ] |
94 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_33392\x00tags\x00" "class_7\x00tags\x00" ] ] |
95 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_33380" "object_33380" ] ] |
96 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_33380\x00tags\x00" "class_7\x00tags\x00" ] ] |
97 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_28063" "object_28063" ] ] |
98 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_28063\x00tags\x00" "class_7\x00tags\x00" ] ] |
99 | 0.18 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_28092" "object_28092" ] ] |
100 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_28092\x00tags\x00" "class_7\x00tags\x00" ] ] |
101 | 0.14 ms |
SELECT o_versionCount FROM objects WHERE o_id = ? FOR UPDATE
Parameters:
[
34372
]
|
102 | 0.23 ms |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
34372
]
|
103 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_properties_34372" "object_properties_34372" ] ] |
104 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_3725" "object_3725" ] ] |
105 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_3725\x00tags\x00" ] ] |
106 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_3724" "object_3724" ] ] |
107 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_3724\x00tags\x00" ] ] |
108 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00object_1" "object_1" ] ] |
109 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "object_1\x00tags\x00" ] ] |
110 | 0.22 ms |
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,21928,3725,3724) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
34372
]
|
111 | 0.14 ms |
DELETE FROM properties WHERE cid = ? AND ctype = ?
Parameters:
[ 34372 "object" ] |
112 | 0.18 ms |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 34372 ] |
113 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00system_resource_columns_objects" "system_resource_columns_objects" ] ] |
114 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "system\x00tags\x00" "resource\x00tags\x00" "system_resource_columns_objects\x00tags\x00" ] ] |
115 | 0.14 ms |
SELECT o_type,o_classId,o_className FROM objects WHERE o_id = ?
Parameters:
[
34372
]
|
116 | 0.77 ms |
INSERT INTO `objects` (`o_id`, `o_parentId`, `o_type`, `o_key`, `o_path`, `o_index`, `o_creationDate`, `o_modificationDate`, `o_userOwner`, `o_userModification`, `o_childrenSortBy`, `o_childrenSortOrder`, `o_versionCount`, `o_published`, `o_classId`, `o_className`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14, :col15) ON DUPLICATE KEY UPDATE `o_id` = :col0, `o_parentId` = :col1, `o_type` = :col2, `o_key` = :col3, `o_path` = :col4, `o_index` = :col5, `o_creationDate` = :col6, `o_modificationDate` = :col7, `o_userOwner` = :col8, `o_userModification` = :col9, `o_childrenSortBy` = :col10, `o_childrenSortOrder` = :col11, `o_versionCount` = :col12, `o_published` = :col13, `o_classId` = :col14, `o_className` = :col15;
Parameters:
[ ":col0" => 34372 ":col1" => 21928 ":col2" => "object" ":col3" => "3009000245 - RISE 4205 Motorized Trolley 50" ":col4" => "/Produktdaten/Produkte/AKTIV/" ":col5" => 0 ":col6" => 1743508985 ":col7" => 1744927398 ":col8" => 0 ":col9" => 0 ":col10" => null ":col11" => null ":col12" => 62 ":col13" => 1 ":col14" => "7" ":col15" => "product" ] |
117 | 0.23 ms |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 34372 "object" ] |
118 | 0.27 ms |
SELECT `src_id` FROM `object_relations_7` WHERE (src_id = '34372' AND fieldname not in ('has_category','has_lieferant','has_marke','localizedfields','images','anleitungen','Videos','zubehoerartikel','Konnect_images') AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1
Parameters:
[] |
119 | 0.21 ms |
SELECT `o_id` FROM `object_collection_Sachmerkmal_7` WHERE `o_id` = '34372' AND `fieldname` = 'Sachmerkmal' LIMIT 1
Parameters:
[] |
120 | 0.18 ms |
SELECT `ooo_id` FROM `object_collection_Sachmerkmal_localized_7` WHERE `ooo_id` = '34372' AND `fieldname` = 'Sachmerkmal' LIMIT 1
Parameters:
[] |
121 | 0.13 ms |
DELETE FROM object_relations_7 WHERE (ownertype = 'fieldcollection' AND ownername = 'Sachmerkmal' AND src_id = '34372')
Parameters:
[] |
122 | 0.12 ms |
DELETE FROM object_relations_7 WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~Sachmerkmal/%' AND src_id = '34372')
Parameters:
[] |
123 | 1.45 ms |
INSERT INTO `object_store_7` (`oo_id`, `externer_schluessel`, `gtin`, `zolltarif`, `productnr`, `pimcore_exported`, `artikelstatus`, `highlight`, `neuheit`, `kindermannprodukt`, `verkaufsprodukt`, `reachkonform`, `rohskonform`, `eukonform`, `praeferenzberechtigt`, `teilestatus`, `sperrgrund`, `teilezyklus`, `aktionsbedingung`, `servicelevel`, `Garantiedauer`, `versandpauschale__value`, `versandpauschale__unit`, `sml`, `slmbezeichnung`, `vkpreis__value`, `vkpreis__unit`, `vkpreisneu__value`, `vkpreisneu__unit`, `vkpreisneuga__value`, `vkpreisneuga__unit`, `vplaenge__value`, `vplaenge__unit`, `vpbreite__value`, `vpbreite__unit`, `vphoehe__value`, `vphoehe__unit`, `gewicht__value`, `gewicht__unit`, `liefergewicht__value`, `liefergewicht__unit`, `nettogewicht__value`, `nettogewicht__unit`, `laenge__value`, `laenge__unit`, `breite__value`, `breite__unit`, `hoehe__value`, `hoehe__unit`, `volumen__value`, `volumen__unit`, `caturl`, `yweeerel`, `yweeelg`, `ynweeerel`, `yearkat`, `yeargewicht`, `le`, `ybattrel`, `ynbattrel`, `ybattla`, `ybklasse`, `ybtyp`, `ybaufl`, `ybattgew`, `yurhebabg`, `yurhebgkl`, `ynurhebabg`, `yvverst`, `ynvverst`, `yvvgewgl`, `yvvgewpa`, `yvvgewwb`, `yvvgewal`, `yvvgewks`, `yvvgewkv`, `yvvgewsv`, `yvvgewnm`, `ycnoce`, `ynceerkl`, `yceerkl`, `yukca`, `ynukca`, `ykukca`, `deepl_translated`, `connect_tdispl`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14, :col15, :col16, :col17, :col18, :col19, :col20, :col21, :col22, :col23, :col24, :col25, :col26, :col27, :col28, :col29, :col30, :col31, :col32, :col33, :col34, :col35, :col36, :col37, :col38, :col39, :col40, :col41, :col42, :col43, :col44, :col45, :col46, :col47, :col48, :col49, :col50, :col51, :col52, :col53, :col54, :col55, :col56, :col57, :col58, :col59, :col60, :col61, :col62, :col63, :col64, :col65, :col66, :col67, :col68, :col69, :col70, :col71, :col72, :col73, :col74, :col75, :col76, :col77, :col78, :col79, :col80, :col81, :col82, :col83, :col84, :col85) ON DUPLICATE KEY UPDATE `oo_id` = :col0, `externer_schluessel` = :col1, `gtin` = :col2, `zolltarif` = :col3, `productnr` = :col4, `pimcore_exported` = :col5, `artikelstatus` = :col6, `highlight` = :col7, `neuheit` = :col8, `kindermannprodukt` = :col9, `verkaufsprodukt` = :col10, `reachkonform` = :col11, `rohskonform` = :col12, `eukonform` = :col13, `praeferenzberechtigt` = :col14, `teilestatus` = :col15, `sperrgrund` = :col16, `teilezyklus` = :col17, `aktionsbedingung` = :col18, `servicelevel` = :col19, `Garantiedauer` = :col20, `versandpauschale__value` = :col21, `versandpauschale__unit` = :col22, `sml` = :col23, `slmbezeichnung` = :col24, `vkpreis__value` = :col25, `vkpreis__unit` = :col26, `vkpreisneu__value` = :col27, `vkpreisneu__unit` = :col28, `vkpreisneuga__value` = :col29, `vkpreisneuga__unit` = :col30, `vplaenge__value` = :col31, `vplaenge__unit` = :col32, `vpbreite__value` = :col33, `vpbreite__unit` = :col34, `vphoehe__value` = :col35, `vphoehe__unit` = :col36, `gewicht__value` = :col37, `gewicht__unit` = :col38, `liefergewicht__value` = :col39, `liefergewicht__unit` = :col40, `nettogewicht__value` = :col41, `nettogewicht__unit` = :col42, `laenge__value` = :col43, `laenge__unit` = :col44, `breite__value` = :col45, `breite__unit` = :col46, `hoehe__value` = :col47, `hoehe__unit` = :col48, `volumen__value` = :col49, `volumen__unit` = :col50, `caturl` = :col51, `yweeerel` = :col52, `yweeelg` = :col53, `ynweeerel` = :col54, `yearkat` = :col55, `yeargewicht` = :col56, `le` = :col57, `ybattrel` = :col58, `ynbattrel` = :col59, `ybattla` = :col60, `ybklasse` = :col61, `ybtyp` = :col62, `ybaufl` = :col63, `ybattgew` = :col64, `yurhebabg` = :col65, `yurhebgkl` = :col66, `ynurhebabg` = :col67, `yvverst` = :col68, `ynvverst` = :col69, `yvvgewgl` = :col70, `yvvgewpa` = :col71, `yvvgewwb` = :col72, `yvvgewal` = :col73, `yvvgewks` = :col74, `yvvgewkv` = :col75, `yvvgewsv` = :col76, `yvvgewnm` = :col77, `ycnoce` = :col78, `ynceerkl` = :col79, `yceerkl` = :col80, `yukca` = :col81, `ynukca` = :col82, `ykukca` = :col83, `deepl_translated` = :col84, `connect_tdispl` = :col85;
Parameters:
[ ":col0" => 34372 ":col1" => "3009000245" ":col2" => "8712285408786" ":col3" => "94032080" ":col4" => null ":col5" => 0 ":col6" => "" ":col7" => null ":col8" => null ":col9" => 0 ":col10" => 0 ":col11" => 1 ":col12" => 1 ":col13" => 0 ":col14" => null ":col15" => "Teilestatus ALL" ":col16" => "Neuanlage mc 01.04.2025 12:53:55" ":col17" => "Neu" ":col18" => "" ":col19" => "Bring-In" ":col20" => "60" ":col21" => 0.0 ":col22" => "9" ":col23" => "7631" ":col24" => "Technische Daten Wandhalterungen" ":col25" => 889 ":col26" => "9" ":col27" => 0.0 ":col28" => "9" ":col29" => 0.0 ":col30" => "9" ":col31" => "1059" ":col32" => "2" ":col33" => "769" ":col34" => "2" ":col35" => "0" ":col36" => "2" ":col37" => "0 " ":col38" => "3" ":col39" => 0.0 ":col40" => "3" ":col41" => 0.0 ":col42" => "3" ":col43" => "1059 " ":col44" => "2" ":col45" => "769 " ":col46" => "2" ":col47" => "222 " ":col48" => "2" ":col49" => 0.0 ":col50" => "2" ":col51" => "" ":col52" => null ":col53" => null ":col54" => null ":col55" => "" ":col56" => null ":col57" => null ":col58" => null ":col59" => null ":col60" => null ":col61" => "" ":col62" => "" ":col63" => null ":col64" => null ":col65" => null ":col66" => null ":col67" => null ":col68" => null ":col69" => null ":col70" => null ":col71" => null ":col72" => null ":col73" => null ":col74" => null ":col75" => null ":col76" => null ":col77" => null ":col78" => null ":col79" => null ":col80" => null ":col81" => null ":col82" => null ":col83" => null ":col84" => null ":col85" => 0 ] |
124 | 0.28 ms |
SELECT * FROM object_query_7 WHERE oo_id = ?
Parameters:
[
34372
]
|
125 | 1.64 ms |
INSERT INTO `object_query_7` (`externer_schluessel`, `gtin`, `zolltarif`, `productnr`, `pimcore_exported`, `artikelstatus`, `highlight`, `neuheit`, `kindermannprodukt`, `verkaufsprodukt`, `reachkonform`, `rohskonform`, `eukonform`, `praeferenzberechtigt`, `teilestatus`, `sperrgrund`, `teilezyklus`, `aktionsbedingung`, `servicelevel`, `Garantiedauer`, `versandpauschale__value`, `versandpauschale__unit`, `sml`, `slmbezeichnung`, `vkpreis__value`, `vkpreis__unit`, `vkpreisneu__value`, `vkpreisneu__unit`, `vkpreisneuga__value`, `vkpreisneuga__unit`, `vplaenge__value`, `vplaenge__unit`, `vpbreite__value`, `vpbreite__unit`, `vphoehe__value`, `vphoehe__unit`, `gewicht__value`, `gewicht__unit`, `liefergewicht__value`, `liefergewicht__unit`, `nettogewicht__value`, `nettogewicht__unit`, `laenge__value`, `laenge__unit`, `breite__value`, `breite__unit`, `hoehe__value`, `hoehe__unit`, `volumen__value`, `volumen__unit`, `caturl`, `yweeerel`, `yweeelg`, `ynweeerel`, `yearkat`, `yeargewicht`, `le`, `ybattrel`, `ynbattrel`, `ybattla`, `ybklasse`, `ybtyp`, `ybaufl`, `ybattgew`, `yurhebabg`, `yurhebgkl`, `ynurhebabg`, `yvverst`, `ynvverst`, `yvvgewgl`, `yvvgewpa`, `yvvgewwb`, `yvvgewal`, `yvvgewks`, `yvvgewkv`, `yvvgewsv`, `yvvgewnm`, `ycnoce`, `ynceerkl`, `yceerkl`, `yukca`, `ynukca`, `ykukca`, `deepl_translated`, `connect_tdispl`, `oo_id`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14, :col15, :col16, :col17, :col18, :col19, :col20, :col21, :col22, :col23, :col24, :col25, :col26, :col27, :col28, :col29, :col30, :col31, :col32, :col33, :col34, :col35, :col36, :col37, :col38, :col39, :col40, :col41, :col42, :col43, :col44, :col45, :col46, :col47, :col48, :col49, :col50, :col51, :col52, :col53, :col54, :col55, :col56, :col57, :col58, :col59, :col60, :col61, :col62, :col63, :col64, :col65, :col66, :col67, :col68, :col69, :col70, :col71, :col72, :col73, :col74, :col75, :col76, :col77, :col78, :col79, :col80, :col81, :col82, :col83, :col84, :col85) ON DUPLICATE KEY UPDATE `externer_schluessel` = :col0, `gtin` = :col1, `zolltarif` = :col2, `productnr` = :col3, `pimcore_exported` = :col4, `artikelstatus` = :col5, `highlight` = :col6, `neuheit` = :col7, `kindermannprodukt` = :col8, `verkaufsprodukt` = :col9, `reachkonform` = :col10, `rohskonform` = :col11, `eukonform` = :col12, `praeferenzberechtigt` = :col13, `teilestatus` = :col14, `sperrgrund` = :col15, `teilezyklus` = :col16, `aktionsbedingung` = :col17, `servicelevel` = :col18, `Garantiedauer` = :col19, `versandpauschale__value` = :col20, `versandpauschale__unit` = :col21, `sml` = :col22, `slmbezeichnung` = :col23, `vkpreis__value` = :col24, `vkpreis__unit` = :col25, `vkpreisneu__value` = :col26, `vkpreisneu__unit` = :col27, `vkpreisneuga__value` = :col28, `vkpreisneuga__unit` = :col29, `vplaenge__value` = :col30, `vplaenge__unit` = :col31, `vpbreite__value` = :col32, `vpbreite__unit` = :col33, `vphoehe__value` = :col34, `vphoehe__unit` = :col35, `gewicht__value` = :col36, `gewicht__unit` = :col37, `liefergewicht__value` = :col38, `liefergewicht__unit` = :col39, `nettogewicht__value` = :col40, `nettogewicht__unit` = :col41, `laenge__value` = :col42, `laenge__unit` = :col43, `breite__value` = :col44, `breite__unit` = :col45, `hoehe__value` = :col46, `hoehe__unit` = :col47, `volumen__value` = :col48, `volumen__unit` = :col49, `caturl` = :col50, `yweeerel` = :col51, `yweeelg` = :col52, `ynweeerel` = :col53, `yearkat` = :col54, `yeargewicht` = :col55, `le` = :col56, `ybattrel` = :col57, `ynbattrel` = :col58, `ybattla` = :col59, `ybklasse` = :col60, `ybtyp` = :col61, `ybaufl` = :col62, `ybattgew` = :col63, `yurhebabg` = :col64, `yurhebgkl` = :col65, `ynurhebabg` = :col66, `yvverst` = :col67, `ynvverst` = :col68, `yvvgewgl` = :col69, `yvvgewpa` = :col70, `yvvgewwb` = :col71, `yvvgewal` = :col72, `yvvgewks` = :col73, `yvvgewkv` = :col74, `yvvgewsv` = :col75, `yvvgewnm` = :col76, `ycnoce` = :col77, `ynceerkl` = :col78, `yceerkl` = :col79, `yukca` = :col80, `ynukca` = :col81, `ykukca` = :col82, `deepl_translated` = :col83, `connect_tdispl` = :col84, `oo_id` = :col85;
Parameters:
[ ":col0" => "3009000245" ":col1" => "8712285408786" ":col2" => "94032080" ":col3" => null ":col4" => 0 ":col5" => "" ":col6" => null ":col7" => null ":col8" => 0 ":col9" => 0 ":col10" => 1 ":col11" => 1 ":col12" => 0 ":col13" => null ":col14" => "Teilestatus ALL" ":col15" => "Neuanlage mc 01.04.2025 12:53:55" ":col16" => "Neu" ":col17" => "" ":col18" => "Bring-In" ":col19" => "60" ":col20" => 0.0 ":col21" => "9" ":col22" => "7631" ":col23" => "Technische Daten Wandhalterungen" ":col24" => 889.0 ":col25" => "9" ":col26" => 0.0 ":col27" => "9" ":col28" => 0.0 ":col29" => "9" ":col30" => 1059.0 ":col31" => "2" ":col32" => 769.0 ":col33" => "2" ":col34" => 0.0 ":col35" => "2" ":col36" => 0.0 ":col37" => "3" ":col38" => 0.0 ":col39" => "3" ":col40" => 0.0 ":col41" => "3" ":col42" => 1059.0 ":col43" => "2" ":col44" => 769.0 ":col45" => "2" ":col46" => 222.0 ":col47" => "2" ":col48" => 0.0 ":col49" => "2" ":col50" => "" ":col51" => null ":col52" => null ":col53" => null ":col54" => "" ":col55" => null ":col56" => null ":col57" => null ":col58" => null ":col59" => null ":col60" => "" ":col61" => "" ":col62" => null ":col63" => null ":col64" => null ":col65" => null ":col66" => null ":col67" => null ":col68" => null ":col69" => null ":col70" => null ":col71" => null ":col72" => null ":col73" => null ":col74" => null ":col75" => null ":col76" => null ":col77" => null ":col78" => null ":col79" => null ":col80" => null ":col81" => null ":col82" => null ":col83" => null ":col84" => 0 ":col85" => 34372 ] |
126 | 0.20 ms |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 34372 "object" ] |
127 | 0.16 ms |
DELETE FROM schedule_tasks WHERE `cid` = '34372' AND `ctype` = 'object'
Parameters:
[] |
128 | 0.25 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
129 | 0.20 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
130 | 0.16 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
131 | 0.16 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
132 | 0.21 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00system_resource_columns_versions" "system_resource_columns_versions" ] ] |
133 | 0.18 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "system\x00tags\x00" "resource\x00tags\x00" "system_resource_columns_versions\x00tags\x00" ] ] |
134 | 0.47 ms |
INSERT INTO `versions` (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13) ON DUPLICATE KEY UPDATE `id` = :col0, `cid` = :col1, `ctype` = :col2, `userId` = :col3, `note` = :col4, `date` = :col5, `public` = :col6, `serialized` = :col7, `stackTrace` = :col8, `versionCount` = :col9, `binaryFileHash` = :col10, `binaryFileId` = :col11, `autoSave` = :col12, `storageType` = :col13;
Parameters:
[ ":col0" => null ":col1" => 34372 ":col2" => "object" ":col3" => 0 ":col4" => "Updated by YEDIBundle" ":col5" => 1744927398 ":col6" => 0 ":col7" => 1 ":col8" => """ #0 /home/kinlcfpg/pimcore/vendor/pimcore/pimcore/models/Element/AbstractElement.php(733): Pimcore\Model\Version->save()\n #1 /home/kinlcfpg/pimcore/vendor/pimcore/pimcore/models/DataObject/Concrete.php(281): Pimcore\Model\Element\AbstractElement->doSaveVersion()\n #2 /home/kinlcfpg/pimcore/vendor/pimcore/pimcore/models/DataObject/Concrete.php(212): Pimcore\Model\DataObject\Concrete->saveVersion()\n #3 /home/kinlcfpg/pimcore/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(773): Pimcore\Model\DataObject\Concrete->update()\n #4 /home/kinlcfpg/pimcore/vendor/pimcore/pimcore/models/DataObject/Concrete.php(720): Pimcore\Model\DataObject\AbstractObject->save()\n #5 /home/kinlcfpg/pimcore/src/YEDIBundle/Services/API/Actions/DataObject/Update.php(44): Pimcore\Model\DataObject\Concrete->save()\n #6 /home/kinlcfpg/pimcore/src/YEDIBundle/Services/API/Actions/Action.php(90): App\YEDIBundle\Services\API\Actions\DataObject\Update->action()\n #7 /home/kinlcfpg/pimcore/src/YEDIBundle/Services/API/Actions/DataObject/DataObjectAction.php(31): App\YEDIBundle\Services\API\Actions\Action->call()\n #8 /home/kinlcfpg/pimcore/src/YEDIBundle/Services/API/ActionService.php(128): App\YEDIBundle\Services\API\Actions\DataObject\DataObjectAction->call()\n #9 /home/kinlcfpg/pimcore/src/YEDIBundle/Services/API/ActionService.php(78): App\YEDIBundle\Services\API\ActionService->getDynamicEntities()\n #10 /home/kinlcfpg/pimcore/src/YEDIBundle/Services/API/ActionService.php(58): App\YEDIBundle\Services\API\ActionService->processEntity()\n #11 [internal function]: App\YEDIBundle\Services\API\ActionService->App\YEDIBundle\Services\API\{closure}()\n #12 /home/kinlcfpg/pimcore/src/YEDIBundle/Services/API/ActionService.php(57): array_map()\n #13 /home/kinlcfpg/pimcore/src/YEDIBundle/Controller/Admin/APIController.php(93): App\YEDIBundle\Services\API\ActionService->process()\n #14 /home/kinlcfpg/pimcore/src/YEDIBundle/Controller/Admin/APIController.php(51): App\YEDIBundle\Controller\Admin\APIController->entityAction()\n #15 /home/kinlcfpg/pimcore/vendor/symfony/http-kernel/HttpKernel.php(163): App\YEDIBundle\Controller\Admin\APIController->dataObjectAction()\n #16 /home/kinlcfpg/pimcore/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n #17 /home/kinlcfpg/pimcore/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()\n #18 /home/kinlcfpg/pimcore/public/index.php(36): Symfony\Component\HttpKernel\Kernel->handle()\n #19 {main} """ ":col9" => 62 ":col10" => null ":col11" => null ":col12" => 0 ":col13" => "fs" ] |
135 | 0.28 ms |
"COMMIT"
Parameters:
[] |
136 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00system_cache_write_lock" "system_cache_write_lock" ] ] |
137 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1744927398 [ "\x00tags\x00system_cache_write_lock" "system_cache_write_lock" ] ] |
138 | 0.20 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 1 => null 2 => null 3 => 30 4 => 1744927398 ] |
139 | 0.22 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 1 => null 2 => null 3 => 30 4 => 1744927398 ] |
140 | 0.20 ms |
DELETE FROM cache_items WHERE item_id IN (?)
Parameters:
[ [ "object_34372\x00tags\x00" "object_properties\x00tags\x00" ] ] |
141 | 0.28 ms |
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[ "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:26:\"messenger.bus.pimcore-core\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:38:\"Pimcore\\Messenger\\SearchBackendMessage\":2:{s:7:\"\0*\0type\";s:6:\"object\";s:5:\"\0*\0id\";i:34372;}}" "[]" "pimcore_core" "2025-04-18 00:03:18" "2025-04-18 00:03:18" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.