Query Metrics
87
Database Queries
53
Different statements
50.08 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 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:
[ 1726785088 "\x01tags\x01site_domain_bfacdba3e5dd64ab7be7588b8c53f170" "site_domain_bfacdba3e5dd64ab7be7588b8c53f170" ] |
2 | 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:
[ 1726785088 "system\x01tags\x01" "site\x01tags\x01" ] |
3 | 0.21 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
4 | 0.34 ms |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/pimcore-graphql-webservices/bol" "path" "auto_create" "/pimcore-graphql-webservices/bol?apikey=5361b1e8d71875b2326b35ceba87c21e" "path_query" "http://pimcore.huisdier.online/pimcore-graphql-webservices/bol?apikey=5361b1e8d71875b2326b35ceba87c21e" "entire_uri" ] |
5 | 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:
[ 1726785088 "\x01tags\x01system_route_redirect" "system_route_redirect" ] |
6 | 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:
[ 1726785088 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
7 | 0.21 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
8 | 0.24 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/pimcore-graphql-webservices/" "bol" ] |
9 | 0.17 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/pimcore-graphql-webservices/bol"
]
|
10 | 0.16 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "pimcore-graphql-webservices" ] |
11 | 0.16 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/pimcore-graphql-webservices"
]
|
12 | 0.15 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
"/"
""
]
|
13 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1726785088 "\x01tags\x01document_1" "document_1" ] |
14 | 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:
[ 1726785088 "document_1\x01tags\x01" ] |
15 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1726785088 "\x01tags\x01document_properties_1" "document_properties_1" ] |
16 | 0.20 ms |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
17 | 0.21 ms |
SELECT id, name FROM classes
Parameters:
[] |
18 | 0.17 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"Product"
]
|
19 | 0.19 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"ProductSpecialPrice"
]
|
20 | 0.16 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"ProductStock"
]
|
21 | 0.16 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Product"
]
|
22 | 0.15 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"ProductStock"
]
|
23 | 0.14 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"ProductSpecialPrice"
]
|
24 | 0.17 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Product"
]
|
25 | 0.15 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"ProductStock"
]
|
26 | 0.47 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:
[ 1726785088 "\x01tags\x01object_108631" "object_108631" ] |
27 | 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:
[ 1726785088 "object_108631\x01tags\x01" "class_ProductStock\x01tags\x01" ] |
28 | 0.36 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
108631
]
|
29 | 0.26 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
108631
]
|
30 | 0.37 ms |
SELECT * FROM object_store_ProductStock WHERE oo_id = ?
Parameters:
[
108631
]
|
31 | 0.37 ms |
SELECT * FROM object_relations_ProductStock WHERE src_id = ?
Parameters:
[
108631
]
|
32 | 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:
[ 1726785088 "\x01tags\x01object_3" "object_3" ] |
33 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1726785088 "object_3\x01tags\x01" ] |
34 | 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:
[ 1726785088 "\x01tags\x01object_1" "object_1" ] |
35 | 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:
[ 1726785088 "object_1\x01tags\x01" ] |
36 | 0.25 ms |
SELECT `update` FROM plugin_datahub_workspaces_object WHERE cid IN (1,3,1,108631) AND configuration = 'bol' AND `update`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
37 | 0.18 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
3
]
|
38 | 0.35 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Product stock/" "410386" ] |
39 | 0.17 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Product stock/" "410386" ] |
40 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
41 | 0.16 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
108631
]
|
42 | 0.40 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:
[ 1726785088 "\x01tags\x01object_12128" "object_12128" ] |
43 | 0.36 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
12128
]
|
44 | 0.21 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
12128
]
|
45 | 0.43 ms |
SELECT * FROM object_store_Product WHERE oo_id = ?
Parameters:
[
12128
]
|
46 | 0.43 ms |
SELECT * FROM object_localized_data_Product WHERE ooo_id = ? AND language IN ('en','nl')
Parameters:
[
12128
]
|
47 | 0.36 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:
[ 1726785088 "\x01tags\x01asset_23728" "asset_23728" ] |
48 | 0.72 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
23728
]
|
49 | 0.23 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
23728
]
|
50 | 0.53 ms |
SELECT * FROM object_relations_Product WHERE src_id = ?
Parameters:
[
12128
]
|
51 | 0.18 ms |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
108631
]
|
52 | 25.79 ms |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
108631
]
|
53 | 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:
[ 1726785088 "\x01tags\x01object_properties_108631" "object_properties_108631" ] |
54 | 0.21 ms |
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,3) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
108631
]
|
55 | 0.19 ms |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 108631 ] |
56 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1726785088 "\x01tags\x01system_resource_columns_objects" "system_resource_columns_objects" ] |
57 | 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:
[ 1726785088 "system\x01tags\x01" "resource\x01tags\x01" ] |
58 | 0.15 ms |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
108631
]
|
59 | 0.35 ms |
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "/Product stock/" 108631 1711983887 1726785088 179 0 0 3 "object" "410386" 0 null null 0 "ProductStock" "ProductStock" ] |
60 | 0.27 ms |
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ?
Parameters:
[ "/Product stock/" 108631 1711983887 1726785088 179 0 0 3 "object" "410386" 0 null null 0 "ProductStock" "ProductStock" 108631 ] |
61 | 0.14 ms |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 108631 "object" ] |
62 | 0.30 ms |
SELECT `src_id` FROM `object_relations_ProductStock` WHERE (src_id = '108631' AND fieldname not in ('product') AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1
Parameters:
[] |
63 | 0.23 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1726785088 "\x01tags\x01system_resource_columns_object_store_ProductStock" "system_resource_columns_object_store_ProductStock" ] |
64 | 0.68 ms |
SHOW COLUMNS FROM object_store_ProductStock
Parameters:
[] |
65 | 0.20 ms |
INSERT INTO object_store_ProductStock (`oo_id`, `sku`, `stockSupplierUnit`, `stockConsumerUnit`, `minStockSupplierUnit`, `orderUnit`, `backorder`, `status`, `expectedSupplyDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 108631 "410386" 0.0 0.0 0.0 1.0 "1" "9" null ] |
66 | 0.17 ms |
UPDATE object_store_ProductStock SET `oo_id` = ?, `sku` = ?, `stockSupplierUnit` = ?, `stockConsumerUnit` = ?, `minStockSupplierUnit` = ?, `orderUnit` = ?, `backorder` = ?, `status` = ?, `expectedSupplyDate` = ? WHERE `oo_id` = ?
Parameters:
[ 108631 "410386" 0.0 0.0 0.0 1.0 "1" "9" null 108631 ] |
67 | 0.37 ms |
SELECT * FROM object_query_ProductStock WHERE oo_id = ?
Parameters:
[
108631
]
|
68 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1726785088 "\x01tags\x01system_resource_columns_object_query_ProductStock" "system_resource_columns_object_query_ProductStock" ] |
69 | 0.83 ms |
SHOW COLUMNS FROM object_query_ProductStock
Parameters:
[] |
70 | 0.28 ms |
INSERT INTO object_query_ProductStock (`sku`, `stockSupplierUnit`, `stockConsumerUnit`, `minStockSupplierUnit`, `orderUnit`, `backorder`, `status`, `expectedSupplyDate`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "410386" 0.0 0.0 0.0 1.0 "1" "9" null 108631 ] |
71 | 0.42 ms |
UPDATE object_query_ProductStock SET `sku` = ?, `stockSupplierUnit` = ?, `stockConsumerUnit` = ?, `minStockSupplierUnit` = ?, `orderUnit` = ?, `backorder` = ?, `status` = ?, `expectedSupplyDate` = ?, `oo_id` = ? WHERE `oo_id` = ?
Parameters:
[ "410386" 0.0 0.0 0.0 1.0 "1" "9" null 108631 108631 ] |
72 | 0.36 ms |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 108631 "object" ] |
73 | 0.15 ms |
DELETE FROM schedule_tasks WHERE `cid` = '108631' AND `ctype` = 'object'
Parameters:
[] |
74 | 0.24 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
75 | 0.22 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
76 | 0.18 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
77 | 0.17 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
78 | 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:
[ 1726785088 "\x01tags\x01system_resource_columns_versions" "system_resource_columns_versions" ] |
79 | 0.34 ms |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 108631 "object" 0 "" 1726785088 0 1 """ #0 /var/www/html/vendor/pimcore/pimcore/models/Element/AbstractElement.php(596): Pimcore\Model\Version->save()\n #1 /var/www/html/vendor/pimcore/pimcore/models/DataObject/Concrete.php(278): Pimcore\Model\Element\AbstractElement->doSaveVersion(NULL, false, true, false)\n #2 /var/www/html/vendor/pimcore/pimcore/models/DataObject/Concrete.php(216): Pimcore\Model\DataObject\Concrete->saveVersion(false, false, NULL)\n #3 /var/www/html/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(563): Pimcore\Model\DataObject\Concrete->update(true, Array)\n #4 /var/www/html/vendor/pimcore/pimcore/models/DataObject/Concrete.php(666): Pimcore\Model\DataObject\AbstractObject->save(Array)\n #5 /var/www/html/vendor/pimcore/data-hub/src/GraphQL/Mutation/MutationType.php(1580): Pimcore\Model\DataObject\Concrete->save()\n #6 /var/www/html/vendor/pimcore/data-hub/src/GraphQL/Mutation/MutationType.php(899): Pimcore\Bundle\DataHubBundle\GraphQL\Mutation\MutationType->saveElement(Object(Pimcore\Model\DataObject\ProductStock), Array)\n #7 /var/www/html/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(714): Pimcore\Bundle\DataHubBundle\GraphQL\Mutation\MutationType::Pimcore\Bundle\DataHubBundle\GraphQL\Mutation\{closure}(false, Array, Array, Object(GraphQL\Type\Definition\ResolveInfo))\n #8 /var/www/html/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(631): GraphQL\Executor\ReferenceExecutor->resolveFieldValueOrError(Object(GraphQL\Type\Definition\FieldDefinition), Object(GraphQL\Language\AST\FieldNode), Object(Closure), Array, Object(GraphQL\Type\Definition\ResolveInfo), Array)\n #9 /var/www/html/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(541): GraphQL\Executor\ReferenceExecutor->resolveField(Object(Pimcore\Bundle\DataHubBundle\GraphQL\Mutation\MutationType), Array, Object(ArrayObject), Array, Array)\n #10 /var/www/html/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(949): GraphQL\Executor\ReferenceExecutor->GraphQL\Executor\{closure}(Array, 'updateProductSt...')\n #11 [internal function]: GraphQL\Executor\ReferenceExecutor->GraphQL\Executor\{closure}(Array, 'updateProductSt...')\n #12 /var/www/html/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(941): array_reduce(Array, Object(Closure), Array)\n #13 /var/www/html/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(533): GraphQL\Executor\ReferenceExecutor->promiseReduce(Array, Object(Closure), Array)\n #14 /var/www/html/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(297): GraphQL\Executor\ReferenceExecutor->executeFieldsSerially(Object(Pimcore\Bundle\DataHubBundle\GraphQL\Mutation\MutationType), Array, Array, Object(ArrayObject), Array)\n #15 /var/www/html/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(237): GraphQL\Executor\ReferenceExecutor->executeOperation(Object(GraphQL\Language\AST\OperationDefinitionNode), Array)\n #16 /var/www/html/vendor/webonyx/graphql-php/src/Executor/Executor.php(159): GraphQL\Executor\ReferenceExecutor->doExecute()\n #17 /var/www/html/vendor/webonyx/graphql-php/src/GraphQL.php(162): GraphQL\Executor\Executor::promiseToExecute(Object(GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter), Object(GraphQL\Type\Schema), Object(GraphQL\Language\AST\DocumentNode), Array, Array, Array, NULL, NULL)\n #18 /var/www/html/vendor/webonyx/graphql-php/src/GraphQL.php(96): GraphQL\GraphQL::promiseToExecute(Object(GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter), Object(GraphQL\Type\Schema), 'mutation ($id: ...', Array, Array, Array, NULL, NULL, NULL)\n #19 /var/www/html/vendor/pimcore/data-hub/src/Controller/WebserviceController.php(203): GraphQL\GraphQL::executeQuery(Object(GraphQL\Type\Schema), 'mutation ($id: ...', Array, Array, Array, NULL, NULL, NULL)\n #20 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(181): Pimcore\Bundle\DataHubBundle\Controller\WebserviceController->webonyxAction(Object(Pimcore\Bundle\DataHubBundle\GraphQL\Service), Object(Pimcore\Localization\LocaleService), Object(Pimcore\Model\Factory), Object(Symfony\Component\HttpFoundation\Request), Object(Pimcore\Helper\LongRunningHelper))\n #21 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)\n #22 /var/www/html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)\n #23 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))\n #24 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n #25 /var/www/html/public/index.php(19): require_once('/var/www/html/v...')\n #26 {main} """ 179 null null 0 "fs" ] |
80 | 1.48 ms |
"COMMIT"
Parameters:
[] |
81 | 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:
[ 1726785088 "\x01tags\x01system_cache_write_lock" "system_cache_write_lock" ] |
82 | 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:
[ 1726785088 "\x01tags\x01system_cache_write_lock" "system_cache_write_lock" ] |
83 | 0.60 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 => 1726785088 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"×\x02¯\x04À\x1E";i:1726785088;}" ] |
84 | 0.15 ms |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_108631\x01tags\x01" "object_properties\x01tags\x01" ] |
85 | 0.58 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:108631;}}" "[]" "pimcore_search_backend_message" "2024-09-19 22:31:28" "2024-09-19 22:31:28" ] |
86 | 0.44 ms |
SELECT object_ProductStock.id as id, object_ProductStock.type as `type` FROM object_ProductStock WHERE (id =108631) AND object_ProductStock.type IN ('object','folder','variant') LIMIT 1
Parameters:
[] |
87 | 0.24 ms |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,3,1,108631) AND configuration = 'bol' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
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.