Query Metrics
164
Database Queries
45
Different statements
76.81 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
12.98 ms (16.90%) |
67 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
8.22 ms (10.70%) |
1 |
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" ] |
8.14 ms (10.60%) |
26 |
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" ] |
5.61 ms (7.31%) |
1 |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
30820
]
|
3.94 ms (5.13%) |
1 |
SHOW COLUMNS FROM versions
Parameters:
[] |
3.82 ms (4.97%) |
2 |
"COMMIT"
Parameters:
[] |
3.04 ms (3.96%) |
1 |
SHOW COLUMNS FROM object_store_27
Parameters:
[] |
2.82 ms (3.67%) |
1 |
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 ] |
2.82 ms (3.66%) |
1 |
SHOW COLUMNS FROM object_query_27
Parameters:
[] |
2.57 ms (3.35%) |
12 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/vue/scheduler/getscheduler/30820/" "checkin" ] |
2.17 ms (2.82%) |
11 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/de/vue/scheduler/getscheduler/30820/checkin"
]
|
1.87 ms (2.44%) |
1 |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_30820\x01tags\x01" "object_properties\x01tags\x01" ] |
1.82 ms (2.36%) |
1 |
SHOW COLUMNS FROM objects
Parameters:
[] |
1.47 ms (1.92%) |
1 |
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;}" ] |
1.47 ms (1.91%) |
1 |
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" ] |
1.33 ms (1.73%) |
4 |
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" ] |
1.05 ms (1.37%) |
1 |
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 ] |
0.88 ms (1.15%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
0.75 ms (0.97%) |
1 |
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" ] |
0.67 ms (0.88%) |
2 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/App/Scheduler/" "1723540508-9" ] |
0.62 ms (0.81%) |
1 |
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" ] |
0.61 ms (0.80%) |
2 |
SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = ?
Parameters:
[
30460
]
|
0.51 ms (0.67%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
0.51 ms (0.66%) |
1 |
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
]
|
0.50 ms (0.65%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
0.47 ms (0.61%) |
1 |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 30820 ] |
0.47 ms (0.61%) |
1 |
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 ] |
0.47 ms (0.61%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 30820 "object" ] |
0.45 ms (0.58%) |
1 |
DELETE FROM tree_locks WHERE id = ? AND TYPE = ?
Parameters:
[ 30820 "object" ] |
0.43 ms (0.56%) |
1 |
SELECT `src_id` FROM `object_relations_27` WHERE (src_id = '30820' AND ownertype = "object" AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1
Parameters:
[] |
0.40 ms (0.53%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
0.37 ms (0.48%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.34 ms (0.45%) |
1 |
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 ] |
0.34 ms (0.44%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.32 ms (0.42%) |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
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" ] |
0.31 ms (0.40%) |
1 |
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 ] |
0.31 ms (0.40%) |
1 |
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 ] |
0.28 ms (0.37%) |
1 |
SELECT * FROM object_query_27 WHERE oo_id = ?
Parameters:
[
30820
]
|
0.27 ms (0.35%) |
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 (?, ?, ?)
Parameters:
[ 1726776133 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
0.26 ms (0.34%) |
1 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
0.26 ms (0.34%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"27"
]
|
0.25 ms (0.33%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/de/vue/scheduler/getscheduler/30820/checkin' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
0.23 ms (0.30%) |
1 |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
30820
]
|
0.21 ms (0.27%) |
1 |
DELETE FROM schedule_tasks WHERE `cid` = '30820' AND `ctype` = 'object'
Parameters:
[] |
0.19 ms (0.25%) |
1 |
SELECT TYPE,classId,className FROM objects WHERE id = ?
Parameters:
[
30820
]
|
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.