Symfony Profiler

Query Metrics

164 Database Queries

45 Different statements

76.81 ms Query time

0 Invalid 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 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 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 * FROM object_url_slugs WHERE slug = '/de/vue/scheduler/getscheduler/30820/checkin' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 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 id FROM documents_page WHERE prettyUrl = ?
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 name FROM classes 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`,`key`) AS `path` FROM objects WHERE id = ?
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
"START TRANSACTION"
SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = ?
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
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 name, TYPE, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,30460,1261) AND inheritable = 1)
                         OR cid = ? ) AND ctype='object'
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
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 objects
SELECT TYPE,classId,className FROM objects WHERE id = ?
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ?
DELETE FROM tree_locks WHERE id = ? AND TYPE = ?
SELECT `src_id` FROM `object_relations_27`
        WHERE (src_id = '30820' AND ownertype = "object" AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1
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 object_store_27
INSERT INTO object_store_27 (`oo_id`, `text`, `startDate`, `endDate`, `recurrenceRule`, `eventType`, `typetext`, `coursetext`, `locationtext`, `trainertext`, `description`, `checkdata`, `typeid`, `courseid`, `locationid`, `trainerid`, `startTs`, `endTs`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE object_store_27 SET `oo_id` = ?, `text` = ?, `startDate` = ?, `endDate` = ?, `recurrenceRule` = ?, `eventType` = ?, `typetext` = ?, `coursetext` = ?, `locationtext` = ?, `trainertext` = ?, `description` = ?, `checkdata` = ?, `typeid` = ?, `courseid` = ?, `locationid` = ?, `trainerid` = ?, `startTs` = ?, `endTs` = ? WHERE `oo_id` = ?
SELECT * FROM object_query_27 WHERE oo_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 object_query_27
INSERT INTO object_query_27 (`text`, `startDate`, `endDate`, `recurrenceRule`, `eventType`, `typetext`, `coursetext`, `locationtext`, `trainertext`, `description`, `checkdata`, `typeid`, `courseid`, `locationid`, `trainerid`, `startTs`, `endTs`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE object_query_27 SET `text` = ?, `startDate` = ?, `endDate` = ?, `recurrenceRule` = ?, `eventType` = ?, `typetext` = ?, `coursetext` = ?, `locationtext` = ?, `trainertext` = ?, `description` = ?, `checkdata` = ?, `typeid` = ?, `courseid` = ?, `locationid` = ?, `trainerid` = ?, `startTs` = ?, `endTs` = ?, `oo_id` = ? WHERE `oo_id` = ?
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
DELETE FROM schedule_tasks WHERE `cid` = '30820' AND `ctype` = 'object'
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 = ?
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 versions
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) 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 (?)
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 (?, ?)
"START TRANSACTION"
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
"COMMIT"
SELECT object_27.id AS id, object_27.type AS `type` FROM object_27 WHERE ((typeid = ?)  AND (startTs > ?)  AND  object_27.type IN ('object','variant','folder')) AND object_27.published = 1 ORDER BY `startTs` ASC

#▲	Time	Info
1	1.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: [`1726776133 "site_domain_bc8af0b98a09669d2a31ad3bedc1dfa3"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_bc8af0b98a09669d2a31ad3bedc1dfa3');
2	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: [`1726776133 "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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.29 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.37 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.62 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: [`"/de/vue/scheduler/getscheduler/30820/checkin" "path" "auto_create" "/de/vue/scheduler/getscheduler/30820/checkin?customerid=31104&filtertype=1&filterstart=1726776072159" "path_query" "https://apimsa.mysportapp.ch/de/vue/scheduler/getscheduler/30820/checkin?customerid=31104&filterstart=1726776072159&filtertype=1" "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 = '/de/vue/scheduler/getscheduler/30820/checkin' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/vue/scheduler/getscheduler/30820/checkin?customerid=31104&filtertype=1&filterstart=1726776072159' AND `type` = 'path_query') OR (source = 'https://apimsa.mysportapp.ch/de/vue/scheduler/getscheduler/30820/checkin?customerid=31104&filterstart=1726776072159&filtertype=1' 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.27 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: [`1726776133 "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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
7	0.27 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: [`1726776133 "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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
8	0.34 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.24 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.40 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/scheduler/getscheduler/30820/" "checkin"`] 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 '/de/vue/scheduler/getscheduler/30820/' AND `key` = BINARY 'checkin';
11	0.26 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler/getscheduler/30820/checkin"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler/getscheduler/30820/checkin';
12	0.31 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/scheduler/getscheduler/30820/" "checkin"`] 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 '/de/vue/scheduler/getscheduler/30820/' AND `key` = BINARY 'checkin';
13	0.20 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler/getscheduler/30820/checkin"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler/getscheduler/30820/checkin';
14	0.18 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/scheduler/getscheduler/" "30820"`] 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 '/de/vue/scheduler/getscheduler/' AND `key` = BINARY '30820';
15	0.18 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler/getscheduler/30820"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler/getscheduler/30820';
16	0.18 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/scheduler/" "getscheduler"`] 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 '/de/vue/scheduler/' AND `key` = BINARY 'getscheduler';
17	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler/getscheduler"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler/getscheduler';
18	0.18 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/" "scheduler"`] 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 '/de/vue/' AND `key` = BINARY 'scheduler';
19	0.18 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler';
20	0.17 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/" "vue"`] 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 '/de/' AND `key` = BINARY 'vue';
21	0.20 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue';
22	0.20 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "de"`] 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 'de';
23	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: [`1726776133 "document_136"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136');
24	0.32 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: [`1726776133 "document_136\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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136tags', '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');
25	0.25 ms	SELECT * FROM object_url_slugs WHERE slug = '/de/vue/scheduler/getscheduler/30820/checkin' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/de/vue/scheduler/getscheduler/30820/checkin' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/de/vue/scheduler/getscheduler/30820/checkin' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
26	0.26 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';
27	0.21 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"05cfed39-821e-4d10-ac5b-40f74029a7d1" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '05cfed39-821e-4d10-ac5b-40f74029a7d1' AND scope = 'pimcore_staticroutes';
28	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"08162c68-f521-49f5-8e8b-aa03d62f25a8" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '08162c68-f521-49f5-8e8b-aa03d62f25a8' AND scope = 'pimcore_staticroutes';
29	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"09f83229-221d-480b-90b5-cbb878ba139c" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '09f83229-221d-480b-90b5-cbb878ba139c' AND scope = 'pimcore_staticroutes';
30	0.21 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"0ba861cb-4ef6-47a8-a4e6-75644fef8097" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '0ba861cb-4ef6-47a8-a4e6-75644fef8097' AND scope = 'pimcore_staticroutes';
31	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"0e854fd9-0284-4a4d-9e77-700ec5379034" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '0e854fd9-0284-4a4d-9e77-700ec5379034' AND scope = 'pimcore_staticroutes';
32	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"167cf18f-3fd6-4c3c-a58e-7872a7e32cdb" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '167cf18f-3fd6-4c3c-a58e-7872a7e32cdb' AND scope = 'pimcore_staticroutes';
33	0.21 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"1b0efa8f-2ccf-4007-8e00-00a0a23e0e3a" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '1b0efa8f-2ccf-4007-8e00-00a0a23e0e3a' AND scope = 'pimcore_staticroutes';
34	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"1b980376-4d91-4dc4-b4cd-cb7f6b01079e" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '1b980376-4d91-4dc4-b4cd-cb7f6b01079e' AND scope = 'pimcore_staticroutes';
35	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"20e398f8-395c-47bb-9352-d54dd1590fb7" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '20e398f8-395c-47bb-9352-d54dd1590fb7' AND scope = 'pimcore_staticroutes';
36	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"219125f4-e291-4a3d-ad2a-b856bbaa5160" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '219125f4-e291-4a3d-ad2a-b856bbaa5160' AND scope = 'pimcore_staticroutes';
37	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"2df3117a-c9ba-445c-9919-147c3bef3261" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '2df3117a-c9ba-445c-9919-147c3bef3261' AND scope = 'pimcore_staticroutes';
38	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"314b42af-cd69-4562-a3f6-992146e459ab" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '314b42af-cd69-4562-a3f6-992146e459ab' AND scope = 'pimcore_staticroutes';
39	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"328c3766-7013-43aa-b1cb-b89dfd14802a" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '328c3766-7013-43aa-b1cb-b89dfd14802a' AND scope = 'pimcore_staticroutes';
40	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"35d5abc9-a603-40c9-b3de-af011e33626f" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '35d5abc9-a603-40c9-b3de-af011e33626f' AND scope = 'pimcore_staticroutes';
41	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"37323b6f-63a4-4104-a905-27cf561f5ba4" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '37323b6f-63a4-4104-a905-27cf561f5ba4' AND scope = 'pimcore_staticroutes';
42	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"37453496-d29c-491b-9daf-a6316417611e" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '37453496-d29c-491b-9daf-a6316417611e' AND scope = 'pimcore_staticroutes';
43	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"38d8db1e-e548-4740-bae3-351c14c03387" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '38d8db1e-e548-4740-bae3-351c14c03387' AND scope = 'pimcore_staticroutes';
44	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"44c5a667-fb2a-485e-a756-31f7583592ff" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '44c5a667-fb2a-485e-a756-31f7583592ff' AND scope = 'pimcore_staticroutes';
45	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"4f6771a5-64b1-4531-822a-36c95f92db70" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '4f6771a5-64b1-4531-822a-36c95f92db70' AND scope = 'pimcore_staticroutes';
46	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"522c1b73-f2d4-4402-9e4f-800f2b3a7a2c" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '522c1b73-f2d4-4402-9e4f-800f2b3a7a2c' AND scope = 'pimcore_staticroutes';
47	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"52789200-f041-4743-9bc6-fb54d91390cf" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '52789200-f041-4743-9bc6-fb54d91390cf' AND scope = 'pimcore_staticroutes';
48	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"57daad83-26d0-4b00-b14b-9d4fe5080f2d" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '57daad83-26d0-4b00-b14b-9d4fe5080f2d' AND scope = 'pimcore_staticroutes';
49	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"5f260de4-cd44-4fdd-b77f-73caa275fac6" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '5f260de4-cd44-4fdd-b77f-73caa275fac6' AND scope = 'pimcore_staticroutes';
50	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"5f2e4d4e-be20-421f-af08-85c08a88d1cf" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '5f2e4d4e-be20-421f-af08-85c08a88d1cf' AND scope = 'pimcore_staticroutes';
51	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"6839e995-d209-44b2-9c04-a6c488a23bbb" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '6839e995-d209-44b2-9c04-a6c488a23bbb' AND scope = 'pimcore_staticroutes';
52	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"6bec0973-9f71-4f6b-95d1-16ac607fecc1" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '6bec0973-9f71-4f6b-95d1-16ac607fecc1' AND scope = 'pimcore_staticroutes';
53	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"6c562840-b38d-413c-bbed-7e6beec4da7d" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '6c562840-b38d-413c-bbed-7e6beec4da7d' AND scope = 'pimcore_staticroutes';
54	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"7219a53a-81a9-4421-ac64-cac2dc115e4b" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '7219a53a-81a9-4421-ac64-cac2dc115e4b' AND scope = 'pimcore_staticroutes';
55	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"73ec20cd-9fbd-4483-84db-079d0a3f6760" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '73ec20cd-9fbd-4483-84db-079d0a3f6760' AND scope = 'pimcore_staticroutes';
56	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"74faea7b-f30d-4b40-affb-323f50dad639" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '74faea7b-f30d-4b40-affb-323f50dad639' AND scope = 'pimcore_staticroutes';
57	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"7b3890cf-348c-4d8c-9bcb-6194773d951b" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '7b3890cf-348c-4d8c-9bcb-6194773d951b' AND scope = 'pimcore_staticroutes';
58	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"8164e68e-050a-40d3-955f-bb6d3aac513f" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '8164e68e-050a-40d3-955f-bb6d3aac513f' AND scope = 'pimcore_staticroutes';
59	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"91737a79-d45d-42ee-be7e-96668b97a381" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '91737a79-d45d-42ee-be7e-96668b97a381' AND scope = 'pimcore_staticroutes';
60	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"943867db-a7c3-4dd9-9882-d7e96e2489f1" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '943867db-a7c3-4dd9-9882-d7e96e2489f1' AND scope = 'pimcore_staticroutes';
61	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"98c74f53-7be8-48ee-a7dc-d5f522af8202" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '98c74f53-7be8-48ee-a7dc-d5f522af8202' AND scope = 'pimcore_staticroutes';
62	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"9da76c56-123f-48d8-8aa2-4c16294a5b6c" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '9da76c56-123f-48d8-8aa2-4c16294a5b6c' AND scope = 'pimcore_staticroutes';
63	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"9eccbc8a-e039-40a4-a898-417591843bab" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '9eccbc8a-e039-40a4-a898-417591843bab' AND scope = 'pimcore_staticroutes';
64	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"a3abda20-2ba2-4741-bb1b-e248fe02caa8" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'a3abda20-2ba2-4741-bb1b-e248fe02caa8' AND scope = 'pimcore_staticroutes';
65	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"aed891b6-20e8-41ec-8520-e1ae793da455" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'aed891b6-20e8-41ec-8520-e1ae793da455' AND scope = 'pimcore_staticroutes';
66	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"b4112faa-9c20-4b5d-93c7-caf4d2daadef" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'b4112faa-9c20-4b5d-93c7-caf4d2daadef' AND scope = 'pimcore_staticroutes';
67	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"b6b0ef46-949d-44c4-81c4-433ab973ae80" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'b6b0ef46-949d-44c4-81c4-433ab973ae80' AND scope = 'pimcore_staticroutes';
68	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"b7d566dc-b48f-43e9-8fda-c10b596aea52" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'b7d566dc-b48f-43e9-8fda-c10b596aea52' AND scope = 'pimcore_staticroutes';
69	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"bd3049a0-ed74-4849-af0b-49cb15615c42" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'bd3049a0-ed74-4849-af0b-49cb15615c42' AND scope = 'pimcore_staticroutes';
70	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"c04f4692-21f5-438f-9a50-f6fb51941dbb" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'c04f4692-21f5-438f-9a50-f6fb51941dbb' AND scope = 'pimcore_staticroutes';
71	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"c3d284de-6af4-4ad0-91fa-7dbc4d8409f6" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'c3d284de-6af4-4ad0-91fa-7dbc4d8409f6' AND scope = 'pimcore_staticroutes';
72	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"c405f872-4457-4e0d-9e9a-2abd01355615" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'c405f872-4457-4e0d-9e9a-2abd01355615' AND scope = 'pimcore_staticroutes';
73	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"c5cdb20e-f8ae-4e08-9126-1a9c446a1711" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'c5cdb20e-f8ae-4e08-9126-1a9c446a1711' AND scope = 'pimcore_staticroutes';
74	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"ca8adf5f-77c1-4fa1-8bc5-4d1395f81a28" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'ca8adf5f-77c1-4fa1-8bc5-4d1395f81a28' AND scope = 'pimcore_staticroutes';
75	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"cabdf1cf-9ec8-422d-81dd-c288be365d55" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'cabdf1cf-9ec8-422d-81dd-c288be365d55' AND scope = 'pimcore_staticroutes';
76	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"cc452965-aaea-4ec7-9157-1fb2ba0e5ed3" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'cc452965-aaea-4ec7-9157-1fb2ba0e5ed3' AND scope = 'pimcore_staticroutes';
77	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"d1f78a3d-cc71-47e9-953f-94932df72b80" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'd1f78a3d-cc71-47e9-953f-94932df72b80' AND scope = 'pimcore_staticroutes';
78	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"d3821466-bb08-4a49-af9d-2ff732625c72" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'd3821466-bb08-4a49-af9d-2ff732625c72' AND scope = 'pimcore_staticroutes';
79	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"d984ff46-a111-49ab-80cd-1389c5052f3c" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'd984ff46-a111-49ab-80cd-1389c5052f3c' AND scope = 'pimcore_staticroutes';
80	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"da737047-d200-445b-a7f2-20fb9cdde99c" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'da737047-d200-445b-a7f2-20fb9cdde99c' AND scope = 'pimcore_staticroutes';
81	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"e56564c0-34b8-42ad-8bb9-1d58a3e396e2" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'e56564c0-34b8-42ad-8bb9-1d58a3e396e2' AND scope = 'pimcore_staticroutes';
82	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"e57d20ad-7c1f-4477-b9ed-7c85113f4272" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'e57d20ad-7c1f-4477-b9ed-7c85113f4272' AND scope = 'pimcore_staticroutes';
83	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"eb26f545-e623-4c89-a989-d3cf849ef61a" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'eb26f545-e623-4c89-a989-d3cf849ef61a' AND scope = 'pimcore_staticroutes';
84	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"ec8ba554-031c-4935-80b5-e21146bebbd0" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'ec8ba554-031c-4935-80b5-e21146bebbd0' AND scope = 'pimcore_staticroutes';
85	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"ee9b4829-3d9a-43bb-9672-ac594e13b3f7" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'ee9b4829-3d9a-43bb-9672-ac594e13b3f7' AND scope = 'pimcore_staticroutes';
86	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"ef8450dd-a539-4e46-a03b-ebf8e9b58bc8" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'ef8450dd-a539-4e46-a03b-ebf8e9b58bc8' AND scope = 'pimcore_staticroutes';
87	0.19 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"f9058843-cb59-411e-b973-35e2f19b5b95" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'f9058843-cb59-411e-b973-35e2f19b5b95' AND scope = 'pimcore_staticroutes';
88	0.20 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"fafa1261-92f5-417b-a51f-09a652a205d9" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'fafa1261-92f5-417b-a51f-09a652a205d9' AND scope = 'pimcore_staticroutes';
89	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"fd64a6a6-67ee-4c99-afac-03733c118b5d" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'fd64a6a6-67ee-4c99-afac-03733c118b5d' AND scope = 'pimcore_staticroutes';
90	0.23 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/scheduler/getscheduler/30820/" "checkin"`] 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 '/de/vue/scheduler/getscheduler/30820/' AND `key` = BINARY 'checkin';
91	0.21 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler/getscheduler/30820/checkin"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler/getscheduler/30820/checkin';
92	0.18 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/scheduler/getscheduler/" "30820"`] 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 '/de/vue/scheduler/getscheduler/' AND `key` = BINARY '30820';
93	0.20 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler/getscheduler/30820"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler/getscheduler/30820';
94	0.19 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/scheduler/" "getscheduler"`] 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 '/de/vue/scheduler/' AND `key` = BINARY 'getscheduler';
95	0.18 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler/getscheduler"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler/getscheduler';
96	0.17 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/vue/" "scheduler"`] 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 '/de/vue/' AND `key` = BINARY 'scheduler';
97	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue/scheduler"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue/scheduler';
98	0.19 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/" "vue"`] 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 '/de/' AND `key` = BINARY 'vue';
99	0.18 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/vue"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/vue';
100	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: [`1726776133 "document_properties_136"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_136');
101	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: [`1726776133 "document_properties\x01tags\x01" "document_136\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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_136tags');
102	0.50 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: [`1726776133 "object_31104"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_31104');
103	0.45 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: [`1726776133 "object_31104\x01tags\x01" "class_CU\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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_31104tags', 'class_CUtags');
104	0.31 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: [`1726776133 "object_30820"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30820');
105	0.34 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: [`1726776133 "object_30820\x01tags\x01" "class_27\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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30820tags', 'class_27tags');
106	0.26 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"27"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '27';
107	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: [`1726776133 "object_30460"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30460');
108	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: [`1726776133 "object_30460\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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30460tags');
109	0.28 ms	SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = ? Parameters: [`30460`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, `key`) AS `path` FROM objects WHERE id = ? SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = 30460;
110	0.44 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/App/Scheduler/" "1723540508-9"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/App/Scheduler/' AND `key` = BINARY '1723540508-9';
111	0.24 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/App/Scheduler/" "1723540508-9"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/App/Scheduler/' AND `key` = BINARY '1723540508-9';
112	0.19 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
113	0.33 ms	SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = ? Parameters: [`30820`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, `key`) AS `path` FROM objects WHERE id = ? SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = 30820;
114	0.23 ms	SELECT versionCount FROM objects WHERE id = ? FOR UPDATE Parameters: [`30820`] View formatted query View runnable query Explain query SELECT versionCount FROM objects WHERE id = ? FOR UPDATE SELECT versionCount FROM objects WHERE id = 30820 FOR UPDATE;
115	5.61 ms	SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object' Parameters: [`30820`] View formatted query View runnable query Explain query SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object' SELECT MAX(versionCount) FROM versions WHERE cid = 30820 AND ctype = 'object';
116	0.39 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: [`1726776133 "object_properties_30820"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_properties_30820');
117	0.27 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: [`1726776133 "\x00tags\x00object_properties_30820"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_properties_30820');
118	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: [`1726776133 "object_1261"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1261');
119	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: [`1726776133 "object_1261\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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1261tags');
120	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: [`1726776133 "object_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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1');
121	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: [`1726776133 "object_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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1tags');
122	0.51 ms	SELECT name, TYPE, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,30460,1261) AND inheritable = 1) OR cid = ? ) AND ctype='object' Parameters: [`30820`] View formatted query View runnable query Explain query SELECT name, TYPE, data, cid, inheritable, cpath FROM properties WHERE ( ( cid IN (1, 30460, 1261) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'object' SELECT name, TYPE, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,30460,1261) AND inheritable = 1) OR cid = 30820 ) AND ctype='object';
123	0.47 ms	SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ? Parameters: [`"object" 30820`] 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= 'object' AND sourceId = 30820;
124	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: [`1726776133 "system_resource_columns_objects"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_objects');
125	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: [`1726776133 "\x00tags\x00system_resource_columns_objects"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_objects');
126	1.82 ms	SHOW COLUMNS FROM objects Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM objects SHOW COLUMNS FROM objects;
127	0.19 ms	SELECT TYPE,classId,className FROM objects WHERE id = ? Parameters: [`30820`] View formatted query View runnable query Explain query SELECT TYPE, classId, className FROM objects WHERE id = ? SELECT TYPE,classId,className FROM objects WHERE id = 30820;
128	8.22 ms	INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"/App/Scheduler/" 30820 1723540508 1726776133 5 0 0 30460 "object" "1723540508-9" 0 null null 1 "27" "AppScheduler"`] View formatted query View runnable query Explain query INSERT INTO objects ( `path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES ('/App/Scheduler/', 30820, 1723540508, 1726776133, 5, 0, 0, 30460, 'object', '1723540508-9', 0, NULL, NULL, 1, '27', 'AppScheduler');
129	2.82 ms	UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ? Parameters: [`"/App/Scheduler/" 30820 1723540508 1726776133 5 0 0 30460 "object" "1723540508-9" 0 null null 1 "27" "AppScheduler" 30820`] View formatted query View runnable query Explain query UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ? UPDATE objects SET `path` = '/App/Scheduler/', `id` = 30820, `creationDate` = 1723540508, `modificationDate` = 1726776133, `versionCount` = 5, `userOwner` = 0, `userModification` = 0, `parentId` = 30460, `type` = 'object', `key` = '1723540508-9', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `published` = 1, `classId` = '27', `className` = 'AppScheduler' WHERE `id` = 30820;
130	0.45 ms	DELETE FROM tree_locks WHERE id = ? AND TYPE = ? Parameters: [`30820 "object"`] View formatted query View runnable query Explain query DELETE FROM tree_locks WHERE id = ? AND TYPE = ? DELETE FROM tree_locks WHERE id = 30820 AND TYPE = 'object';
131	0.43 ms	SELECT `src_id` FROM `object_relations_27` WHERE (src_id = '30820' AND ownertype = "object" AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT `src_id` FROM `object_relations_27` WHERE ( src_id = '30820' AND ownertype = "object" AND ownerType != "localizedfield" AND ownerType != "fieldcollection" ) LIMIT 1 SELECT `src_id` FROM `object_relations_27` WHERE (src_id = '30820' AND ownertype = "object" AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1;
132	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: [`1726776133 "system_resource_columns_object_store_27"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_object_store_27');
133	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: [`1726776133 "\x00tags\x00system_resource_columns_object_store_27"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_object_store_27');
134	3.04 ms	SHOW COLUMNS FROM object_store_27 Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM object_store_27 SHOW COLUMNS FROM object_store_27;
135	0.47 ms	INSERT INTO object_store_27 (`oo_id`, `text`, `startDate`, `endDate`, `recurrenceRule`, `eventType`, `typetext`, `coursetext`, `locationtext`, `trainertext`, `description`, `checkdata`, `typeid`, `courseid`, `locationid`, `trainerid`, `startTs`, `endTs`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [30820 "Fitboxen" "2024-08-13T10:00:00.000Z" "2024-08-13T11:00:00.000Z" null null "Gruppenkurse" "Fitboxen" "Kriens" "Pascal" "" "{"30817":{"firstname":"Georg","lastname":"Mahler","avatar":"https:\/\/apimsa.mysportapp.ch\/avatar\/1352\/image-thumb__1352__300x300\/30817.491167e3.jpg","time":1723540538},"31104":{"firstname":"Harvi","lastname":"Seitaj","avatar":"https:\/\/apimsa.mysportapp.ch\/static\/assets\/img\/default-avatar.png","time":1726776133}}" 1.0 1517.0 30488.0 1709.0 1723543200.0 1723546800.0] View formatted query View runnable query Explain query INSERT INTO object_store_27 ( `oo_id`, `text`, `startDate`, `endDate`, `recurrenceRule`, `eventType`, `typetext`, `coursetext`, `locationtext`, `trainertext`, `description`, `checkdata`, `typeid`, `courseid`, `locationid`, `trainerid`, `startTs`, `endTs` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO object_store_27 (`oo_id`, `text`, `startDate`, `endDate`, `recurrenceRule`, `eventType`, `typetext`, `coursetext`, `locationtext`, `trainertext`, `description`, `checkdata`, `typeid`, `courseid`, `locationid`, `trainerid`, `startTs`, `endTs`) VALUES (30820, 'Fitboxen', '2024-08-13T10:00:00.000Z', '2024-08-13T11:00:00.000Z', NULL, NULL, 'Gruppenkurse', 'Fitboxen', 'Kriens', 'Pascal', '', '{\"30817\":{\"firstname\":\"Georg\",\"lastname\":\"Mahler\",\"avatar\":\"https:\\/\\/apimsa.mysportapp.ch\\/avatar\\/1352\\/image-thumb__1352__300x300\\/30817.491167e3.jpg\",\"time\":1723540538},\"31104\":{\"firstname\":\"Harvi\",\"lastname\":\"Seitaj\",\"avatar\":\"https:\\/\\/apimsa.mysportapp.ch\\/static\\/assets\\/img\\/default-avatar.png\",\"time\":1726776133}}', 1, 1517, 30488, 1709, 1723543200, 1723546800);
136	0.31 ms	UPDATE object_store_27 SET `oo_id` = ?, `text` = ?, `startDate` = ?, `endDate` = ?, `recurrenceRule` = ?, `eventType` = ?, `typetext` = ?, `coursetext` = ?, `locationtext` = ?, `trainertext` = ?, `description` = ?, `checkdata` = ?, `typeid` = ?, `courseid` = ?, `locationid` = ?, `trainerid` = ?, `startTs` = ?, `endTs` = ? WHERE `oo_id` = ? Parameters: [30820 "Fitboxen" "2024-08-13T10:00:00.000Z" "2024-08-13T11:00:00.000Z" null null "Gruppenkurse" "Fitboxen" "Kriens" "Pascal" "" "{"30817":{"firstname":"Georg","lastname":"Mahler","avatar":"https:\/\/apimsa.mysportapp.ch\/avatar\/1352\/image-thumb__1352__300x300\/30817.491167e3.jpg","time":1723540538},"31104":{"firstname":"Harvi","lastname":"Seitaj","avatar":"https:\/\/apimsa.mysportapp.ch\/static\/assets\/img\/default-avatar.png","time":1726776133}}" 1.0 1517.0 30488.0 1709.0 1723543200.0 1723546800.0 30820] View formatted query View runnable query Explain query UPDATE object_store_27 SET `oo_id` = ?, `text` = ?, `startDate` = ?, `endDate` = ?, `recurrenceRule` = ?, `eventType` = ?, `typetext` = ?, `coursetext` = ?, `locationtext` = ?, `trainertext` = ?, `description` = ?, `checkdata` = ?, `typeid` = ?, `courseid` = ?, `locationid` = ?, `trainerid` = ?, `startTs` = ?, `endTs` = ? WHERE `oo_id` = ? UPDATE object_store_27 SET `oo_id` = 30820, `text` = 'Fitboxen', `startDate` = '2024-08-13T10:00:00.000Z', `endDate` = '2024-08-13T11:00:00.000Z', `recurrenceRule` = NULL, `eventType` = NULL, `typetext` = 'Gruppenkurse', `coursetext` = 'Fitboxen', `locationtext` = 'Kriens', `trainertext` = 'Pascal', `description` = '', `checkdata` = '{\"30817\":{\"firstname\":\"Georg\",\"lastname\":\"Mahler\",\"avatar\":\"https:\\/\\/apimsa.mysportapp.ch\\/avatar\\/1352\\/image-thumb__1352__300x300\\/30817.491167e3.jpg\",\"time\":1723540538},\"31104\":{\"firstname\":\"Harvi\",\"lastname\":\"Seitaj\",\"avatar\":\"https:\\/\\/apimsa.mysportapp.ch\\/static\\/assets\\/img\\/default-avatar.png\",\"time\":1726776133}}', `typeid` = 1, `courseid` = 1517, `locationid` = 30488, `trainerid` = 1709, `startTs` = 1723543200, `endTs` = 1723546800 WHERE `oo_id` = 30820;
137	0.28 ms	SELECT * FROM object_query_27 WHERE oo_id = ? Parameters: [`30820`] View formatted query View runnable query Explain query SELECT * FROM object_query_27 WHERE oo_id = ? SELECT * FROM object_query_27 WHERE oo_id = 30820;
138	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: [`1726776133 "system_resource_columns_object_query_27"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_object_query_27');
139	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: [`1726776133 "\x00tags\x00system_resource_columns_object_query_27"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_object_query_27');
140	2.82 ms	SHOW COLUMNS FROM object_query_27 Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM object_query_27 SHOW COLUMNS FROM object_query_27;
141	0.34 ms	INSERT INTO object_query_27 (`text`, `startDate`, `endDate`, `recurrenceRule`, `eventType`, `typetext`, `coursetext`, `locationtext`, `trainertext`, `description`, `checkdata`, `typeid`, `courseid`, `locationid`, `trainerid`, `startTs`, `endTs`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["Fitboxen" "2024-08-13T10:00:00.000Z" "2024-08-13T11:00:00.000Z" null null "Gruppenkurse" "Fitboxen" "Kriens" "Pascal" "" "{"30817":{"firstname":"Georg","lastname":"Mahler","avatar":"https:\/\/apimsa.mysportapp.ch\/avatar\/1352\/image-thumb__1352__300x300\/30817.491167e3.jpg","time":1723540538},"31104":{"firstname":"Harvi","lastname":"Seitaj","avatar":"https:\/\/apimsa.mysportapp.ch\/static\/assets\/img\/default-avatar.png","time":1726776133}}" 1.0 1517.0 30488.0 1709.0 1723543200.0 1723546800.0 30820] View formatted query View runnable query Explain query INSERT INTO object_query_27 ( `text`, `startDate`, `endDate`, `recurrenceRule`, `eventType`, `typetext`, `coursetext`, `locationtext`, `trainertext`, `description`, `checkdata`, `typeid`, `courseid`, `locationid`, `trainerid`, `startTs`, `endTs`, `oo_id` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO object_query_27 (`text`, `startDate`, `endDate`, `recurrenceRule`, `eventType`, `typetext`, `coursetext`, `locationtext`, `trainertext`, `description`, `checkdata`, `typeid`, `courseid`, `locationid`, `trainerid`, `startTs`, `endTs`, `oo_id`) VALUES ('Fitboxen', '2024-08-13T10:00:00.000Z', '2024-08-13T11:00:00.000Z', NULL, NULL, 'Gruppenkurse', 'Fitboxen', 'Kriens', 'Pascal', '', '{\"30817\":{\"firstname\":\"Georg\",\"lastname\":\"Mahler\",\"avatar\":\"https:\\/\\/apimsa.mysportapp.ch\\/avatar\\/1352\\/image-thumb__1352__300x300\\/30817.491167e3.jpg\",\"time\":1723540538},\"31104\":{\"firstname\":\"Harvi\",\"lastname\":\"Seitaj\",\"avatar\":\"https:\\/\\/apimsa.mysportapp.ch\\/static\\/assets\\/img\\/default-avatar.png\",\"time\":1726776133}}', 1, 1517, 30488, 1709, 1723543200, 1723546800, 30820);
142	0.31 ms	UPDATE object_query_27 SET `text` = ?, `startDate` = ?, `endDate` = ?, `recurrenceRule` = ?, `eventType` = ?, `typetext` = ?, `coursetext` = ?, `locationtext` = ?, `trainertext` = ?, `description` = ?, `checkdata` = ?, `typeid` = ?, `courseid` = ?, `locationid` = ?, `trainerid` = ?, `startTs` = ?, `endTs` = ?, `oo_id` = ? WHERE `oo_id` = ? Parameters: ["Fitboxen" "2024-08-13T10:00:00.000Z" "2024-08-13T11:00:00.000Z" null null "Gruppenkurse" "Fitboxen" "Kriens" "Pascal" "" "{"30817":{"firstname":"Georg","lastname":"Mahler","avatar":"https:\/\/apimsa.mysportapp.ch\/avatar\/1352\/image-thumb__1352__300x300\/30817.491167e3.jpg","time":1723540538},"31104":{"firstname":"Harvi","lastname":"Seitaj","avatar":"https:\/\/apimsa.mysportapp.ch\/static\/assets\/img\/default-avatar.png","time":1726776133}}" 1.0 1517.0 30488.0 1709.0 1723543200.0 1723546800.0 30820 30820] View formatted query View runnable query Explain query UPDATE object_query_27 SET `text` = ?, `startDate` = ?, `endDate` = ?, `recurrenceRule` = ?, `eventType` = ?, `typetext` = ?, `coursetext` = ?, `locationtext` = ?, `trainertext` = ?, `description` = ?, `checkdata` = ?, `typeid` = ?, `courseid` = ?, `locationid` = ?, `trainerid` = ?, `startTs` = ?, `endTs` = ?, `oo_id` = ? WHERE `oo_id` = ? UPDATE object_query_27 SET `text` = 'Fitboxen', `startDate` = '2024-08-13T10:00:00.000Z', `endDate` = '2024-08-13T11:00:00.000Z', `recurrenceRule` = NULL, `eventType` = NULL, `typetext` = 'Gruppenkurse', `coursetext` = 'Fitboxen', `locationtext` = 'Kriens', `trainertext` = 'Pascal', `description` = '', `checkdata` = '{\"30817\":{\"firstname\":\"Georg\",\"lastname\":\"Mahler\",\"avatar\":\"https:\\/\\/apimsa.mysportapp.ch\\/avatar\\/1352\\/image-thumb__1352__300x300\\/30817.491167e3.jpg\",\"time\":1723540538},\"31104\":{\"firstname\":\"Harvi\",\"lastname\":\"Seitaj\",\"avatar\":\"https:\\/\\/apimsa.mysportapp.ch\\/static\\/assets\\/img\\/default-avatar.png\",\"time\":1726776133}}', `typeid` = 1, `courseid` = 1517, `locationid` = 30488, `trainerid` = 1709, `startTs` = 1723543200, `endTs` = 1723546800, `oo_id` = 30820 WHERE `oo_id` = 30820;
143	0.47 ms	SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? Parameters: [`30820 "object"`] View formatted query View runnable query Explain query SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? SELECT id FROM schedule_tasks WHERE `cid` = 30820 AND `ctype` = 'object' ;
144	0.21 ms	DELETE FROM schedule_tasks WHERE `cid` = '30820' AND `ctype` = 'object' Parameters: [] View formatted query View runnable query Explain query DELETE FROM schedule_tasks WHERE `cid` = '30820' AND `ctype` = 'object' DELETE FROM schedule_tasks WHERE `cid` = '30820' AND `ctype` = 'object';
145	0.22 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';
146	0.88 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;
147	0.50 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;
148	0.40 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;
149	0.51 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;
150	0.42 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: [`1726776133 "system_resource_columns_versions"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_versions');
151	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: [`1726776133 "\x00tags\x00system_resource_columns_versions"`] 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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_versions');
152	3.94 ms	SHOW COLUMNS FROM versions Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM versions SHOW COLUMNS FROM versions;
153	1.47 ms	INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [null 30820 "object" 0 "" 1726776133 0 1 """ #0 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/Element/AbstractElement.php(596): Pimcore\Model\Version->save()\n #1 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/DataObject/Concrete.php(278): Pimcore\Model\Element\AbstractElement->doSaveVersion(NULL, false, true, false)\n #2 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/DataObject/Concrete.php(216): Pimcore\Model\DataObject\Concrete->saveVersion(false, false, NULL)\n #3 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(562): Pimcore\Model\DataObject\Concrete->update(true, Array)\n #4 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/DataObject/Concrete.php(666): Pimcore\Model\DataObject\AbstractObject->save(Array)\n #5 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/src/Controller/SchedulerController.php(106): Pimcore\Model\DataObject\Concrete->save()\n #6 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\SchedulerController->getschedulerAction(Object(Symfony\Component\HttpFoundation\Request))\n #7 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)\n #8 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)\n #9 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))\n #10 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n #11 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/public/index.php(19): require_once('/var/www/vhosts...')\n #12 {main} """ 5 null null 0 "fs"] View formatted query View runnable query Explain query INSERT INTO versions ( `id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (NULL, 30820, 'object', 0, '', 1726776133, 0, 1, '#0 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/Element/AbstractElement.php(596): Pimcore\\Model\\Version->save() #1 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/DataObject/Concrete.php(278): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion(NULL, false, true, false) #2 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/DataObject/Concrete.php(216): Pimcore\\Model\\DataObject\\Concrete->saveVersion(false, false, NULL) #3 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(562): Pimcore\\Model\\DataObject\\Concrete->update(true, Array) #4 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/pimcore/pimcore/models/DataObject/Concrete.php(666): Pimcore\\Model\\DataObject\\AbstractObject->save(Array) #5 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/src/Controller/SchedulerController.php(106): Pimcore\\Model\\DataObject\\Concrete->save() #6 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/symfony/http-kernel/HttpKernel.php(181): App\\Controller\\SchedulerController->getschedulerAction(Object(Symfony\\Component\\HttpFoundation\\Request)) #7 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1) #8 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true) #9 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request)) #10 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run() #11 /var/www/vhosts/mysportapp.ch/httpdocs/apimsa.mysportapp.ch/public/index.php(19): require_once(\'/var/www/vhosts...\') #12 {main}', 5, NULL, NULL, 0, 'fs');
154	2.31 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
155	0.27 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: [`1726776133 "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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_cache_write_lock');
156	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: [`1726776133 "\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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_cache_write_lock');
157	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: [`1726776133 "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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_cache_write_lock');
158	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: [`1726776133 "\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 > 1726776133 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_cache_write_lock');
159	1.47 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 => 1726776133 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"Üß®\x04À\x1E";i:1726776133;}"`] 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 ('system_cache_write_lock', 0x4F3A313A22A9223A313A7B733A363A22DCDFAE04C01E223B693A313732363737363133333B7D, 30, 1726776133) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
160	1.87 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"object_30820\x01tags\x01" "object_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 ('object_30820tags', 'object_propertiestags');
161	0.18 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
162	0.75 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:6:\"object\";s:5:\"\0\0id\";i:30820;}}" "[]" "pimcore_search_backend_message" "2024-09-19 20:02:13" "2024-09-19 20:02:13"] 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:6:\\\"object\\\";s:5:\\\"\\0\\0id\\\";i:30820;}}', '[]', 'pimcore_search_backend_message', '2024-09-19 20:02:13', '2024-09-19 20:02:13');
163	1.50 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
164	1.05 ms	SELECT object_27.id AS id, object_27.type AS `type` FROM object_27 WHERE ((typeid = ?) AND (startTs > ?) AND object_27.type IN ('object','variant','folder')) AND object_27.published = 1 ORDER BY `startTs` ASC Parameters: [`1 1726776072`] View formatted query View runnable query Explain query SELECT object_27.id AS id, object_27.type AS `type` FROM object_27 WHERE ( (typeid = ?) AND (startTs > ?) AND object_27.type IN ('object', 'variant', 'folder') ) AND object_27.published = 1 ORDER BY `startTs` ASC SELECT object_27.id AS id, object_27.type AS `type` FROM object_27 WHERE ((typeid = 1) AND (startTs > 1726776072) AND object_27.type IN ('object','variant','folder')) AND object_27.published = 1 ORDER BY `startTs` ASC ;

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.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://apimsa.mysportapp.ch/de/vue/scheduler/getscheduler/30820/checkin?customerid=31104&filterstart=1726776072159&filtertype=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping