Symfony Profiler

Query Metrics

178 Database Queries

49 Different statements

36.20 ms Query time

0 Invalid entities

0 Managed entities

Queries


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 (?)
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 (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 AND priority = 99 ORDER BY `priority` DESC
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 (?)
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 (?, ?, ?)
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
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 (?)
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 (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id, name FROM classes
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
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 (?)
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 (?)
SELECT id FROM tags WHERE (name = ?)  AND (parentId = 0 OR parentId IS NULL)   LIMIT 1
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE (name = ?)  AND (parentId = ?)   LIMIT 1
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE (name = ?)  AND (parentId = ?)   LIMIT 1
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE (name = ?)  AND (parentId = 0 OR parentId IS NULL)   LIMIT 1
SELECT id FROM tags WHERE (name = ?)  AND (parentId = ?)   LIMIT 1
SELECT id FROM tags WHERE (name = ?)  AND (parentId = ?)   LIMIT 1
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE (name = ?)  AND (parentId = 0 OR parentId IS NULL)   LIMIT 1
SELECT id FROM tags WHERE (name = ?)  AND (parentId = ?)   LIMIT 1
SELECT id FROM tags WHERE (name = ?)  AND (parentId = ?)   LIMIT 1
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE (name = ?)  AND (parentId = 0 OR parentId IS NULL)   LIMIT 1
SELECT id FROM tags WHERE (name = ?)  AND (parentId = ?)   LIMIT 1
SELECT id FROM tags WHERE (name = ?)  AND (parentId = ?)   LIMIT 1
SELECT * FROM tags WHERE id = ?
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 (?)
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 (?)
SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ?
SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
"START TRANSACTION"
SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ?
SELECT customSettings FROM assets WHERE id = ?
DELETE FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT versionCount FROM assets WHERE id = ? FOR UPDATE
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'asset'
UPDATE assets SET customSettings = ? WHERE id = ?
SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ?
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 (?)
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 (?)
SHOW COLUMNS FROM assets
SELECT `name` FROM assets_metadata WHERE cid = ? LIMIT 1
DELETE FROM assets_metadata WHERE cid = ?
INSERT INTO assets (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE assets SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `filename` = ?, `mimetype` = ?, `customSettings` = ?, `hasMetaData` = ?, `dataModificationDate` = ? WHERE `id` = ?
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?)
DELETE FROM tree_locks WHERE id = ? AND type = ?
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
DELETE FROM schedule_tasks WHERE `cid` = 412 AND `ctype` = 'asset'
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
"COMMIT"
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 (?)
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 (?)
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 (?)
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 (?)
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)
DELETE FROM cache_items WHERE item_id IN (?, ?)
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 (?)
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 (?)
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 (?)
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 (?)
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 (?)
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 (?)
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 (?)
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 (?)
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,411,410,409) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP(NOW(6)) + 300)
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP(NOW(6)) + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP(NOW(6)))
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
"START TRANSACTION"
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
"COMMIT"
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
"START TRANSACTION"
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
DELETE FROM tags_assignment WHERE ctype = ? AND cid = ?
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 (?)
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 (?)
SHOW COLUMNS FROM tags_assignment
INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?)
INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?)
INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?)
INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?)
"COMMIT"
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 (?)
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 (?)

#▲	Time	Info
1	0.37 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: [`1781794867 "site_domain_d985bcc5be48a425ca8bc6f2c4cfe076"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_d985bcc5be48a425ca8bc6f2c4cfe076');
2	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: [`1781794867 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
4	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
5	0.32 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 AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/pimcore-graphql-webservices/celum" "path" "auto_create" "/pimcore-graphql-webservices/celum?apikey=5214d93d2379853b9aa0d6c203458027" "path_query" "https://pimcore.demo.integration.netcare.io/pimcore-graphql-webservices/celum?apikey=5214d93d2379853b9aa0d6c203458027" "entire_uri"`] View formatted query View runnable query Explain query 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 AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/pimcore-graphql-webservices/celum' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/pimcore-graphql-webservices/celum?apikey=5214d93d2379853b9aa0d6c203458027' AND `type` = 'path_query') OR (source = 'https://pimcore.demo.integration.netcare.io/pimcore-graphql-webservices/celum?apikey=5214d93d2379853b9aa0d6c203458027' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
6	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: [`1781794867 "system_route_redirect"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
7	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: [`1781794867 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
8	0.17 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
9	0.17 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
10	0.21 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/pimcore-graphql-webservices/" "celum"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/pimcore-graphql-webservices/' AND `key` = BINARY 'celum';
11	0.15 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-graphql-webservices/celum"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices/celum';
12	0.13 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "pimcore-graphql-webservices"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'pimcore-graphql-webservices';
13	0.13 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-graphql-webservices"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices';
14	0.16 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ""`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';
15	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: [`1781794867 "document_1"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
16	0.26 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: [`1781794867 "document_1\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01"`] View formatted query View runnable query Explain query 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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags', 'asset_337tags', 'asset_3tags', 'asset_319tags', 'asset_361tags', 'asset_320tags', 'asset_318tags', 'asset_321tags', 'asset_224tags', 'asset_35tags', 'asset_211tags', 'asset_90tags', 'asset_58tags', 'asset_180tags', 'asset_124tags', 'asset_164tags', 'asset_81tags');
17	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: [`1781794867 "document_properties_1"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_1');
18	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: [`1781794867 "document_properties\x01tags\x01" "document_1\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_1tags');
19	0.34 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"celum" "pimcore_data_hub"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'celum' AND scope = 'pimcore_data_hub';
20	0.18 ms	SELECT id, name FROM classes Parameters: [] View formatted query View runnable query Explain query SELECT id, name FROM classes SELECT id, name FROM classes;
21	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"AccessoryPart"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'AccessoryPart';
22	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"AP"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'AP';
23	0.18 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"BodyStyle"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'BodyStyle';
24	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BS"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BS';
25	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Car"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Car';
26	0.11 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CAR"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CAR';
27	0.16 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Category"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Category';
28	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CA';
29	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Customer"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Customer';
30	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CU"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CU';
31	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"CustomerSegment"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'CustomerSegment';
32	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '2';
33	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"CustomerSegmentGroup"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'CustomerSegmentGroup';
34	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '1';
35	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Event"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Event';
36	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EV"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EV';
37	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"FilterDefinition"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'FilterDefinition';
38	0.11 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_FD"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_FD';
39	0.24 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"LinkActivityDefinition"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'LinkActivityDefinition';
40	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"5"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '5';
41	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Manufacturer"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Manufacturer';
42	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"MA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'MA';
43	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"News"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'News';
44	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"NE"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'NE';
45	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"OfferToolCustomProduct"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'OfferToolCustomProduct';
46	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OTCP"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OTCP';
47	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"OfferToolOffer"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'OfferToolOffer';
48	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OTO"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OTO';
49	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"OfferToolOfferItem"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'OfferToolOfferItem';
50	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OTOI"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OTOI';
51	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"OnlineShopOrder"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'OnlineShopOrder';
52	0.13 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OSO"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OSO';
53	0.17 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"OnlineShopOrderItem"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'OnlineShopOrderItem';
54	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OSOI"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OSOI';
55	0.15 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"OnlineShopTaxClass"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'OnlineShopTaxClass';
56	0.20 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OSTC"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OSTC';
57	0.18 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"OnlineShopVoucherSeries"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'OnlineShopVoucherSeries';
58	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OSVS"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OSVS';
59	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"OnlineShopVoucherToken"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'OnlineShopVoucherToken';
60	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OSVT"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OSVT';
61	0.14 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"TermSegmentBuilderDefinition"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'TermSegmentBuilderDefinition';
62	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '4';
63	0.50 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/CELUM-Assets/Pimcore/Integration-Demo/" "img_0977.jpg"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/CELUM-Assets/Pimcore/Integration-Demo/' AND `filename` = BINARY 'img_0977.jpg';
64	0.25 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: [`1781794867 "asset_412"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_412');
65	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: [`1781794867 "asset_412\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_412tags');
66	0.28 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = 0 OR parentId IS NULL) LIMIT 1 Parameters: [`"CELUM-Tags"`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND ( parentId = 0 OR parentId IS NULL ) LIMIT 1 SELECT id FROM tags WHERE (name = 'CELUM-Tags') AND (parentId = 0 OR parentId IS NULL) LIMIT 1;
67	0.16 ms	SELECT * FROM tags WHERE id = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 15;
68	0.19 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 Parameters: [`"Cities" 15`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 SELECT id FROM tags WHERE (name = 'Cities') AND (parentId = 15) LIMIT 1;
69	0.17 ms	SELECT * FROM tags WHERE id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 16;
70	0.19 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 Parameters: [`"Florenz" 16`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 SELECT id FROM tags WHERE (name = 'Florenz') AND (parentId = 16) LIMIT 1;
71	0.13 ms	SELECT * FROM tags WHERE id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 17;
72	0.19 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = 0 OR parentId IS NULL) LIMIT 1 Parameters: [`"CELUM-Tags"`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND ( parentId = 0 OR parentId IS NULL ) LIMIT 1 SELECT id FROM tags WHERE (name = 'CELUM-Tags') AND (parentId = 0 OR parentId IS NULL) LIMIT 1;
73	0.18 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 Parameters: [`"Cities" 15`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 SELECT id FROM tags WHERE (name = 'Cities') AND (parentId = 15) LIMIT 1;
74	0.21 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 Parameters: [`"Köln" 16`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 SELECT id FROM tags WHERE (name = 'Köln') AND (parentId = 16) LIMIT 1;
75	0.14 ms	SELECT * FROM tags WHERE id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 18;
76	0.19 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = 0 OR parentId IS NULL) LIMIT 1 Parameters: [`"CELUM-Tags"`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND ( parentId = 0 OR parentId IS NULL ) LIMIT 1 SELECT id FROM tags WHERE (name = 'CELUM-Tags') AND (parentId = 0 OR parentId IS NULL) LIMIT 1;
77	0.20 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 Parameters: [`"Cities" 15`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 SELECT id FROM tags WHERE (name = 'Cities') AND (parentId = 15) LIMIT 1;
78	0.17 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 Parameters: [`"Stuttgart" 16`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 SELECT id FROM tags WHERE (name = 'Stuttgart') AND (parentId = 16) LIMIT 1;
79	0.13 ms	SELECT * FROM tags WHERE id = ? Parameters: [`19`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 19;
80	0.17 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = 0 OR parentId IS NULL) LIMIT 1 Parameters: [`"CELUM-Tags"`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND ( parentId = 0 OR parentId IS NULL ) LIMIT 1 SELECT id FROM tags WHERE (name = 'CELUM-Tags') AND (parentId = 0 OR parentId IS NULL) LIMIT 1;
81	0.18 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 Parameters: [`"Cities" 15`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 SELECT id FROM tags WHERE (name = 'Cities') AND (parentId = 15) LIMIT 1;
82	0.16 ms	SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 Parameters: [`"Genf" 16`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE (name = ?) AND (parentId = ?) LIMIT 1 SELECT id FROM tags WHERE (name = 'Genf') AND (parentId = 16) LIMIT 1;
83	0.13 ms	SELECT * FROM tags WHERE id = ? Parameters: [`20`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 20;
84	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: [`1781794867 "asset_411"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_411');
85	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: [`1781794867 "asset_411\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_411tags');
86	0.14 ms	SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ? Parameters: [`411`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, filename) as `path` FROM assets WHERE id = ? SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = 411;
87	0.18 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/CELUM-Assets/Pimcore/Integration-Demo/" "img_0977.jpg"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/CELUM-Assets/Pimcore/Integration-Demo/' AND `filename` = BINARY 'img_0977.jpg';
88	0.16 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/CELUM-Assets/Pimcore/Integration-Demo/" "img_0977.jpg"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/CELUM-Assets/Pimcore/Integration-Demo/' AND `filename` = BINARY 'img_0977.jpg';
89	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
90	0.14 ms	SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ? Parameters: [`412`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, filename) as `path` FROM assets WHERE id = ? SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = 412;
91	0.14 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`412`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 412;
92	0.16 ms	DELETE FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`412`] View formatted query View runnable query Explain query DELETE FROM assets_image_thumbnail_cache WHERE cid = ? DELETE FROM assets_image_thumbnail_cache WHERE cid = 412;
93	0.15 ms	SELECT versionCount FROM assets WHERE id = ? FOR UPDATE Parameters: [`412`] View formatted query View runnable query Explain query SELECT versionCount FROM assets WHERE id = ? FOR UPDATE SELECT versionCount FROM assets WHERE id = 412 FOR UPDATE;
94	0.18 ms	SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'asset' Parameters: [`412`] View formatted query View runnable query Explain query SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'asset' SELECT MAX(versionCount) FROM versions WHERE cid = 412 AND ctype = 'asset';
95	0.20 ms	UPDATE assets SET customSettings = ? WHERE id = ? Parameters: [`"a:1:{s:8:"checksum";s:32:"9def3a8a1f65f2edb4bd2f18dac3338c";}" 412`] View formatted query View runnable query Explain query UPDATE assets SET customSettings = ? WHERE id = ? UPDATE assets SET customSettings = 'a:1:{s:8:\"checksum\";s:32:\"9def3a8a1f65f2edb4bd2f18dac3338c\";}' WHERE id = 412;
96	0.15 ms	SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ? Parameters: [`412`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, filename) as `path` FROM assets WHERE id = ? SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = 412;
97	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: [`1781794867 "system_resource_columns_assets"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_assets');
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: [`1781794867 "\x00tags\x00system_resource_columns_assets"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_assets');
99	0.70 ms	SHOW COLUMNS FROM assets Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM assets SHOW COLUMNS FROM assets;
100	0.18 ms	SELECT `name` FROM assets_metadata WHERE cid = ? LIMIT 1 Parameters: [`412`] View formatted query View runnable query Explain query SELECT `name` FROM assets_metadata WHERE cid = ? LIMIT 1 SELECT `name` FROM assets_metadata WHERE cid = 412 LIMIT 1;
101	0.26 ms	DELETE FROM assets_metadata WHERE cid = ? Parameters: [`412`] View formatted query View runnable query Explain query DELETE FROM assets_metadata WHERE cid = ? DELETE FROM assets_metadata WHERE cid = 412;
102	0.32 ms	INSERT INTO assets (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"/CELUM-Assets/Pimcore/Integration-Demo/" 412 1781788753 1781794867 1 0 0 411 "image" "img_0977.jpg" "image/jpeg" "a:1:{s:8:"checksum";s:32:"9def3a8a1f65f2edb4bd2f18dac3338c";}" 1 1781794867`] View formatted query View runnable query Explain query INSERT INTO assets ( `path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO assets (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate`) VALUES ('/CELUM-Assets/Pimcore/Integration-Demo/', 412, 1781788753, 1781794867, 1, 0, 0, 411, 'image', 'img_0977.jpg', 'image/jpeg', 'a:1:{s:8:\"checksum\";s:32:\"9def3a8a1f65f2edb4bd2f18dac3338c\";}', 1, 1781794867);
103	0.21 ms	UPDATE assets SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `filename` = ?, `mimetype` = ?, `customSettings` = ?, `hasMetaData` = ?, `dataModificationDate` = ? WHERE `id` = ? Parameters: [`"/CELUM-Assets/Pimcore/Integration-Demo/" 412 1781788753 1781794867 1 0 0 411 "image" "img_0977.jpg" "image/jpeg" "a:1:{s:8:"checksum";s:32:"9def3a8a1f65f2edb4bd2f18dac3338c";}" 1 1781794867 412`] View formatted query View runnable query Explain query UPDATE assets SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `filename` = ?, `mimetype` = ?, `customSettings` = ?, `hasMetaData` = ?, `dataModificationDate` = ? WHERE `id` = ? UPDATE assets SET `path` = '/CELUM-Assets/Pimcore/Integration-Demo/', `id` = 412, `creationDate` = 1781788753, `modificationDate` = 1781794867, `versionCount` = 1, `userOwner` = 0, `userModification` = 0, `parentId` = 411, `type` = 'image', `filename` = 'img_0977.jpg', `mimetype` = 'image/jpeg', `customSettings` = 'a:1:{s:8:\"checksum\";s:32:\"9def3a8a1f65f2edb4bd2f18dac3338c\";}', `hasMetaData` = 1, `dataModificationDate` = 1781794867 WHERE `id` = 412;
104	0.17 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_originalFileName" "input" "img_0977.jpg" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_originalFileName', 'input', 'img_0977.jpg', '', 412);
105	0.13 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_assetTypeId" "input" "1000" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_assetTypeId', 'input', '1000', '', 412);
106	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_doubleNumberField" "input" "1000.04" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_doubleNumberField', 'input', '1000.04', '', 412);
107	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_cities" "input" "Köln\|Stuttgart\|Genf\|Florenz" "de" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_cities', 'input', 'Köln\|Stuttgart\|Genf\|Florenz', 'de', 412);
108	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_cities" "input" "Colone\|Stuttgart (en)\|Geneva\|Florence" "en" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_cities', 'input', 'Colone\|Stuttgart (en)\|Geneva\|Florence', 'en', 412);
109	0.12 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_lastModifiedDate" "input" "2026-06-18T15:00:59.042+00:00" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_lastModifiedDate', 'input', '2026-06-18T15:00:59.042+00:00', '', 412);
110	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_copyrightRequired" "input" "true" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_copyrightRequired', 'input', 'true', '', 412);
111	0.10 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_lastModifiedBy" "input" "109" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_lastModifiedBy', 'input', '109', '', 412);
112	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_Advertising Slogan" "input" "Pimcore ist super" "de" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_Advertising Slogan', 'input', 'Pimcore ist super', 'de', 412);
113	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_Advertising Slogan" "input" "Pimcore is awesome" "en" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_Advertising Slogan', 'input', 'Pimcore is awesome', 'en', 412);
114	0.12 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_description" "input" "Demobeschreibung" "de" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_description', 'input', 'Demobeschreibung', 'de', 412);
115	0.13 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_description" "input" "Description in english" "en" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_description', 'input', 'Description in english', 'en', 412);
116	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_creationDate" "input" "2025-11-13T10:12:26.586+00:00" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_creationDate', 'input', '2025-11-13T10:12:26.586+00:00', '', 412);
117	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_simpleNumberField" "input" "10" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_simpleNumberField', 'input', '10', '', 412);
118	0.12 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_version" "input" "0" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_version', 'input', '0', '', 412);
119	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_versionDate" "input" "2025-11-13T10:12:26.587+00:00" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_versionDate', 'input', '2025-11-13T10:12:26.587+00:00', '', 412);
120	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_dropdownField" "input" "Dropdown Wert 01" "de" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_dropdownField', 'input', 'Dropdown Wert 01', 'de', 412);
121	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_dropdownField" "input" "Dropdown value 01" "en" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_dropdownField', 'input', 'Dropdown value 01', 'en', 412);
122	0.12 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_dropdownField" "input" "Dropdown value 01 FR" "fr" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_dropdownField', 'input', 'Dropdown value 01 FR', 'fr', 412);
123	0.10 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_availabilityType" "input" "DIRECT" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_availabilityType', 'input', 'DIRECT', '', 412);
124	0.10 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_Copyright Information" "input" "infokk" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_Copyright Information', 'input', 'infokk', '', 412);
125	0.10 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_activeStatus" "input" "true" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_activeStatus', 'input', 'true', '', 412);
126	0.10 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_versionedBy" "input" "101" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_versionedBy', 'input', '101', '', 412);
127	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_assetName" "input" "img_0977.jpg" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_assetName', 'input', 'img_0977.jpg', '', 412);
128	0.10 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_id" "input" "1923" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_id', 'input', '1923', '', 412);
129	0.11 ms	INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) Parameters: [`"celum_createdById" "input" "101" "" 412`] View formatted query View runnable query Explain query INSERT INTO assets_metadata (name, type, data, language, cid) VALUES (?, ?, ?, ?, ?) INSERT INTO assets_metadata (name, type, data, language, cid) VALUES ('celum_createdById', 'input', '101', '', 412);
130	4.14 ms	DELETE FROM tree_locks WHERE id = ? AND type = ? Parameters: [`412 "asset"`] View formatted query View runnable query Explain query DELETE FROM tree_locks WHERE id = ? AND type = ? DELETE FROM tree_locks WHERE id = 412 AND type = 'asset';
131	0.28 ms	SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? Parameters: [`412 "asset"`] View formatted query View runnable query Explain query SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? SELECT id FROM schedule_tasks WHERE `cid` = 412 AND `ctype` = 'asset' ;
132	0.12 ms	DELETE FROM schedule_tasks WHERE `cid` = 412 AND `ctype` = 'asset' Parameters: [] View formatted query View runnable query Explain query DELETE FROM schedule_tasks WHERE `cid` = 412 AND `ctype` = 'asset' DELETE FROM schedule_tasks WHERE `cid` = 412 AND `ctype` = 'asset';
133	0.15 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
134	0.21 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 0`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 0;
135	0.16 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 0;
136	0.14 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 0;
137	0.15 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 0;
138	0.81 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
139	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: [`1781794867 "system_cache_write_lock"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_cache_write_lock');
140	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: [`1781794867 "\x00tags\x00system_cache_write_lock"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_cache_write_lock');
141	0.13 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: [`1781794867 "system_cache_write_lock"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_cache_write_lock');
142	0.13 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: [`1781794867 "\x00tags\x00system_cache_write_lock"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_cache_write_lock');
143	0.48 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: [`2 => 30 3 => 1781794867 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"Êdö\x07À\x1E";i:1781794867;}"`] View formatted query View runnable query Explain query 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) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (30, 1781794867, 'system_cache_write_lock', 0x4F3A313A22A9223A313A7B733A363A22CA64F607C01E223B693A313738313739343836373B7D) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
144	0.43 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"asset_412\x01tags\x01" "asset_properties\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('asset_412tags', 'asset_propertiestags');
145	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: [`1781794867 "asset_properties_412"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_properties_412');
146	0.13 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: [`1781794867 "\x00tags\x00asset_properties_412"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_properties_412');
147	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: [`1781794867 "asset_410"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_410');
148	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: [`1781794867 "asset_410\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_410tags');
149	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: [`1781794867 "asset_409"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_409');
150	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: [`1781794867 "asset_409\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_409tags');
151	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: [`1781794867 "asset_1"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1');
152	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: [`1781794867 "asset_1\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1tags');
153	0.22 ms	SELECT * FROM properties WHERE ( (cid IN (1,411,410,409) AND inheritable = 1) OR cid = ? ) AND ctype='asset' Parameters: [`412`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 411, 410, 409) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'asset' SELECT * FROM properties WHERE ( (cid IN (1,411,410,409) AND inheritable = 1) OR cid = 412 ) AND ctype='asset';
154	0.17 ms	SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ? Parameters: [`"asset" 412`] View formatted query View runnable query Explain query SELECT id, targetType, targetId FROM dependencies WHERE sourceType = ? AND sourceId = ? SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'asset' AND sourceId = 412;
155	0.55 ms	INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP(NOW(6)) + 300) Parameters: [`"07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2" "EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4="`] View formatted query View runnable query Explain query INSERT INTO lock_keys ( key_id, key_token, key_expiration ) VALUES ( ?, ?, UNIX_TIMESTAMP( NOW(6) ) + 300 ) INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2', 'EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4=', UNIX_TIMESTAMP(NOW(6)) + 300);
156	0.17 ms	UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP(NOW(6)) + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP(NOW(6))) Parameters: [`300.0 "EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4=" "07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2" "EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4="`] View formatted query View runnable query Explain query UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP( NOW(6) ) + ?, key_token = ? WHERE key_id = ? AND ( key_token = ? OR key_expiration <= UNIX_TIMESTAMP( NOW(6) ) ) UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP(NOW(6)) + 300, key_token = 'EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4=' WHERE key_id = '07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2' AND (key_token = 'EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4=' OR key_expiration <= UNIX_TIMESTAMP(NOW(6)));
157	0.16 ms	SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6)) Parameters: [`"07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2" "EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4="`] View formatted query View runnable query Explain query SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP( NOW(6) ) SELECT 1 FROM lock_keys WHERE key_id = '07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2' AND key_token = 'EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4=' AND key_expiration > UNIX_TIMESTAMP(NOW(6));
158	0.16 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
159	0.24 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:41:\"Pimcore\\Messenger\\AssetUpdateTasksMessage\":1:{s:5:\"\0\0id\";i:412;}}" "[]" "pimcore_asset_update" "2026-06-18 15:01:07" "2026-06-18 15:01:07"] View formatted query View runnable query Explain query INSERT INTO messenger_messages ( body, headers, queue_name, created_at, available_at ) VALUES (?, ?, ?, ?, ?) INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('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:41:\\\"Pimcore\\\\Messenger\\\\AssetUpdateTasksMessage\\\":1:{s:5:\\\"\\0\\0id\\\";i:412;}}', '[]', 'pimcore_asset_update', '2026-06-18 15:01:07', '2026-06-18 15:01:07');
160	0.49 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
161	0.24 ms	SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6)) Parameters: [`"07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2" "EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4="`] View formatted query View runnable query Explain query SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP( NOW(6) ) SELECT 1 FROM lock_keys WHERE key_id = '07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2' AND key_token = 'EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4=' AND key_expiration > UNIX_TIMESTAMP(NOW(6));
162	0.54 ms	DELETE FROM lock_keys WHERE key_id = ? AND key_token = ? Parameters: [`"07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2" "EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4="`] View formatted query View runnable query Explain query DELETE FROM lock_keys WHERE key_id = ? AND key_token = ? DELETE FROM lock_keys WHERE key_id = '07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2' AND key_token = 'EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4=';
163	0.15 ms	SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6)) Parameters: [`"07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2" "EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4="`] View formatted query View runnable query Explain query SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP( NOW(6) ) SELECT 1 FROM lock_keys WHERE key_id = '07068159779a5d32f485d05c342cfb49ff77b098301bcaa5b224d8069d5b7de2' AND key_token = 'EKHW+1OKUdySF8ElvG2hLugr/g5+4zAXu1bO9DqAHO4=' AND key_expiration > UNIX_TIMESTAMP(NOW(6));
164	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
165	0.19 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:69:\"Pimcore\\Bundle\\SimpleBackendSearchBundle\\Message\\SearchBackendMessage\":2:{s:7:\"\0\0type\";s:5:\"asset\";s:5:\"\0\0id\";i:412;}}" "[]" "pimcore_search_backend_message" "2026-06-18 15:01:07" "2026-06-18 15:01:07"] View formatted query View runnable query Explain query INSERT INTO messenger_messages ( body, headers, queue_name, created_at, available_at ) VALUES (?, ?, ?, ?, ?) INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('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:69:\\\"Pimcore\\\\Bundle\\\\SimpleBackendSearchBundle\\\\Message\\\\SearchBackendMessage\\\":2:{s:7:\\\"\\0\\0type\\\";s:5:\\\"asset\\\";s:5:\\\"\\0\\0id\\\";i:412;}}', '[]', 'pimcore_search_backend_message', '2026-06-18 15:01:07', '2026-06-18 15:01:07');
166	0.37 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
167	0.07 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
168	0.23 ms	DELETE FROM tags_assignment WHERE ctype = ? AND cid = ? Parameters: [`"asset" 412`] View formatted query View runnable query Explain query DELETE FROM tags_assignment WHERE ctype = ? AND cid = ? DELETE FROM tags_assignment WHERE ctype = 'asset' AND cid = 412;
169	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: [`1781794867 "system_resource_columns_tags_assignment"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_tags_assignment');
170	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: [`1781794867 "\x00tags\x00system_resource_columns_tags_assignment"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_tags_assignment');
171	0.62 ms	SHOW COLUMNS FROM tags_assignment Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM tags_assignment SHOW COLUMNS FROM tags_assignment;
172	0.21 ms	INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?) Parameters: [`17 "asset" 412`] View formatted query View runnable query Explain query INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?) INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (17, 'asset', 412);
173	0.15 ms	INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?) Parameters: [`18 "asset" 412`] View formatted query View runnable query Explain query INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?) INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (18, 'asset', 412);
174	0.12 ms	INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?) Parameters: [`19 "asset" 412`] View formatted query View runnable query Explain query INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?) INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (19, 'asset', 412);
175	0.11 ms	INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?) Parameters: [`20 "asset" 412`] View formatted query View runnable query Explain query INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (?, ?, ?) INSERT INTO tags_assignment (`tagid`, `ctype`, `cid`) VALUES (20, 'asset', 412);
176	0.35 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
177	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: [`1781794867 "datahub_workspace_permissions_celum_asset"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('datahub_workspace_permissions_celum_asset');
178	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: [`1781794867 "datahub_workspace_permissions_celum\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781794867 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('datahub_workspace_permissions_celumtags');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore	doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

pimcore entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

POST https://pimcore.demo.integration.netcare.io/pimcore-graphql-webservices/celum?apikey=5214d93d2379853b9aa0d6c203458027

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

pimcore entity manager

Entities Mapping