Query Metrics
193
Database Queries
58
Different statements
27.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 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:
[ 1781179879 "site_domain_b373a0015e6925ad9b52b97b4121698d" ] |
| 2 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "system\x01tags\x01" "site\x01tags\x01" ] |
| 3 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 4 | 0.10 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 5 | 0.13 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "deliveries" ] |
| 6 | 0.12 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/deliveries"
]
|
| 7 | 0.11 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
"/"
""
]
|
| 8 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "document_1" ] |
| 9 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "document_1\x01tags\x01" ] |
| 10 | 0.09 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:
[ 1781179879 "document_properties_1" ] |
| 11 | 0.09 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:
[ 1781179879 "\x00tags\x00document_properties_1" ] |
| 12 | 0.15 ms |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
| 13 | 0.16 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/00_Entregas/" "App" ] |
| 14 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_447" ] |
| 15 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_447\x01tags\x01" ] |
| 16 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "e" "ntrega-1781179821887" ] |
| 17 | 0.16 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"4"
]
|
| 18 | 0.16 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
447
]
|
| 19 | 0.13 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/00_Entregas/App/" "entrega-1781179821887" ] |
| 20 | 0.06 ms |
"START TRANSACTION"
Parameters:
[] |
| 21 | 0.27 ms |
INSERT INTO objects (`key`, `path`) VALUES (?, ?)
Parameters:
[ "entrega-1781179821887" "/00_Entregas/App/" ] |
| 22 | 0.14 ms |
SELECT * FROM object_relations_4 WHERE src_id = ?
Parameters:
[
1130
]
|
| 23 | 0.12 ms |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
1130
]
|
| 24 | 0.17 ms |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
1130
]
|
| 25 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "system_resource_columns_objects" ] |
| 26 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "\x00tags\x00system_resource_columns_objects" ] |
| 27 | 1.02 ms |
SHOW COLUMNS FROM objects
Parameters:
[] |
| 28 | 0.14 ms |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
1130
]
|
| 29 | 0.38 ms |
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "/00_Entregas/App/" 1130 1781179879 1781179879 1 0 0 447 "object" "entrega-1781179821887" 0 null null 1 "4" "Entrega" ] |
| 30 | 0.30 ms |
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ?
Parameters:
[ "/00_Entregas/App/" 1130 1781179879 1781179879 1 0 0 447 "object" "entrega-1781179821887" 0 null null 1 "4" "Entrega" 1130 ] |
| 31 | 0.12 ms |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 1130 "object" ] |
| 32 | 0.17 ms |
DELETE FROM object_metadata_4 WHERE id = '1130' AND fieldname = 'productos' AND position = '0'
Parameters:
[] |
| 33 | 0.13 ms |
INSERT INTO object_store_4 (`oo_id`, `pago`, `entrega`, `cobro`) VALUES (?, ?, ?, ?)
Parameters:
[ 1130 null "2026-06-11" "2026-06-22" ] |
| 34 | 0.14 ms |
SELECT * FROM object_query_4 WHERE oo_id = ?
Parameters:
[
1130
]
|
| 35 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "system_resource_columns_object_query_4" ] |
| 36 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "\x00tags\x00system_resource_columns_object_query_4" ] |
| 37 | 0.93 ms |
SHOW COLUMNS FROM object_query_4
Parameters:
[] |
| 38 | 0.12 ms |
INSERT INTO object_query_4 (`productos`, `total`, `pago`, `resta`, `ganancia`, `perdidaVenta`, `perdidaCosto`, `gananciaPerdida`, `entrega`, `cobro`, `cliente__id`, `cliente__type`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "0" null "0" "0" "0" "0" "0" "2026-06-11" "2026-06-22" null null 1130 ] |
| 39 | 0.16 ms |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 1130 "object" ] |
| 40 | 0.10 ms |
DELETE FROM schedule_tasks WHERE `cid` = 1130 AND `ctype` = 'object'
Parameters:
[] |
| 41 | 0.20 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
| 42 | 0.18 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
| 43 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
| 44 | 0.16 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
| 45 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_properties_1130" ] |
| 46 | 0.10 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:
[ 1781179879 "\x00tags\x00object_properties_1130" ] |
| 47 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_192" ] |
| 48 | 0.11 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:
[ 1781179879 "object_192\x01tags\x01" ] |
| 49 | 0.10 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:
[ 1781179879 "object_1" ] |
| 50 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_1\x01tags\x01" ] |
| 51 | 0.18 ms |
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,447,192) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
1130
]
|
| 52 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "system_resource_columns_versions" ] |
| 53 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "system\x01tags\x01" "resource\x01tags\x01" ] |
| 54 | 0.24 ms |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 1130 "object" 0 "" 1781179879 0 1 """ #0 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\Model\Version->save()\n #1 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(281): Pimcore\Model\Element\AbstractElement->doSaveVersion()\n #2 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(219): Pimcore\Model\DataObject\Concrete->saveVersion()\n #3 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(538): Pimcore\Model\DataObject\Concrete->update()\n #4 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(669): Pimcore\Model\DataObject\AbstractObject->save()\n #5 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/src/Controller/BaseController.php(82): Pimcore\Model\DataObject\Concrete->save()\n #6 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/src/Controller/DeliveryController.php(65): App\Controller\BaseController->saveObject()\n #7 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\DeliveryController->createOrUpdateDelivery()\n #8 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n #9 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()\n #10 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()\n #11 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n #12 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/public/index.php(19): require_once('/home/u93449028...')\n #13 {main} """ 1 null null 0 "fs" ] |
| 55 | 0.11 ms |
"COMMIT"
Parameters:
[] |
| 56 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "system_cache_write_lock" ] |
| 57 | 0.10 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:
[ 1781179879 "\x00tags\x00system_cache_write_lock" ] |
| 58 | 0.10 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:
[ 1781179879 "system_cache_write_lock" ] |
| 59 | 0.10 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:
[ 1781179879 "\x00tags\x00system_cache_write_lock" ] |
| 60 | 0.15 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 => 1781179879 0 => "system_cache_write_lock" 1 => b"\x00\x00\x00\x02\x17\x01©\x14\x01\x11\x06~\x02í\x07À\x1E\nj*¥ç" ] |
| 61 | 0.10 ms |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_1130\x01tags\x01" "object_properties\x01tags\x01" ] |
| 62 | 0.17 ms |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 1130 ] |
| 63 | 0.05 ms |
"START TRANSACTION"
Parameters:
[] |
| 64 | 0.15 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:1130;}}" "[]" "pimcore_search_backend_message" "2026-06-11 12:11:19" "2026-06-11 12:11:19" ] |
| 65 | 0.06 ms |
"COMMIT"
Parameters:
[] |
| 66 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\UuidBundle\PimcoreUuidBundle" "pimcore" ] |
| 67 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_549" ] |
| 68 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_549\x01tags\x01" "class_3\x01tags\x01" ] |
| 69 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_996" ] |
| 70 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_996\x01tags\x01" "class_3\x01tags\x01" ] |
| 71 | 0.11 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:
[ 1781179879 "object_548" ] |
| 72 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_548\x01tags\x01" "class_3\x01tags\x01" ] |
| 73 | 0.13 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
447
]
|
| 74 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/00_Entregas/App/" "entrega-1781179821887" ] |
| 75 | 0.10 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/00_Entregas/App/" "entrega-1781179821887" ] |
| 76 | 0.04 ms |
"START TRANSACTION"
Parameters:
[] |
| 77 | 0.10 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
1130
]
|
| 78 | 0.10 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"3"
]
|
| 79 | 0.15 ms |
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
549
]
|
| 80 | 0.09 ms |
SELECT id FROM objects WHERE id IN (89)
Parameters:
[] |
| 81 | 0.26 ms |
SELECT * FROM object_metadata_3 WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (`type` = 'object' or `type` = '')
Parameters:
[ 549 89 "ingredientes" "object" "" "0" 1 ] |
| 82 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_89" ] |
| 83 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_89\x01tags\x01" "class_2\x01tags\x01" ] |
| 84 | 0.09 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"2"
]
|
| 85 | 0.13 ms |
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
996
]
|
| 86 | 0.13 ms |
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
548
]
|
| 87 | 0.12 ms |
SELECT id FROM objects WHERE id IN (92,111,84,114,98,87,110)
Parameters:
[] |
| 88 | 0.22 ms |
SELECT * FROM object_metadata_3 WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (`type` = 'object' or `type` = '')
Parameters:
[ 548 92 "ingredientes" "object" "" "0" 1 ] |
| 89 | 0.22 ms |
SELECT * FROM object_metadata_3 WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (`type` = 'object' or `type` = '')
Parameters:
[ 548 111 "ingredientes" "object" "" "0" 2 ] |
| 90 | 0.21 ms |
SELECT * FROM object_metadata_3 WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (`type` = 'object' or `type` = '')
Parameters:
[ 548 84 "ingredientes" "object" "" "0" 3 ] |
| 91 | 0.20 ms |
SELECT * FROM object_metadata_3 WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (`type` = 'object' or `type` = '')
Parameters:
[ 548 114 "ingredientes" "object" "" "0" 4 ] |
| 92 | 0.20 ms |
SELECT * FROM object_metadata_3 WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (`type` = 'object' or `type` = '')
Parameters:
[ 548 98 "ingredientes" "object" "" "0" 5 ] |
| 93 | 0.21 ms |
SELECT * FROM object_metadata_3 WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (`type` = 'object' or `type` = '')
Parameters:
[ 548 87 "ingredientes" "object" "" "0" 6 ] |
| 94 | 0.21 ms |
SELECT * FROM object_metadata_3 WHERE id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (`type` = 'object' or `type` = '')
Parameters:
[ 548 110 "ingredientes" "object" "" "0" 7 ] |
| 95 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_92" ] |
| 96 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_92\x01tags\x01" "class_2\x01tags\x01" ] |
| 97 | 0.11 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:
[ 1781179879 "object_111" ] |
| 98 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_111\x01tags\x01" "class_2\x01tags\x01" ] |
| 99 | 0.11 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:
[ 1781179879 "object_84" ] |
| 100 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_84\x01tags\x01" "class_2\x01tags\x01" ] |
| 101 | 0.11 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:
[ 1781179879 "object_114" ] |
| 102 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_114\x01tags\x01" "class_2\x01tags\x01" ] |
| 103 | 0.11 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:
[ 1781179879 "object_98" ] |
| 104 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_98\x01tags\x01" "class_2\x01tags\x01" ] |
| 105 | 0.11 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:
[ 1781179879 "object_87" ] |
| 106 | 0.11 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:
[ 1781179879 "object_87\x01tags\x01" "class_2\x01tags\x01" ] |
| 107 | 0.11 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:
[ 1781179879 "object_110" ] |
| 108 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_110\x01tags\x01" "class_2\x01tags\x01" ] |
| 109 | 0.13 ms |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
1130
]
|
| 110 | 0.18 ms |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
1130
]
|
| 111 | 0.09 ms |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
1130
]
|
| 112 | 0.15 ms |
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "/00_Entregas/App/" 1130 1781179879 1781179879 2 0 0 447 "object" "entrega-1781179821887" 0 null null 1 "4" "Entrega" ] |
| 113 | 0.14 ms |
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ?
Parameters:
[ "/00_Entregas/App/" 1130 1781179879 1781179879 2 0 0 447 "object" "entrega-1781179821887" 0 null null 1 "4" "Entrega" 1130 ] |
| 114 | 0.08 ms |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 1130 "object" ] |
| 115 | 0.11 ms |
DELETE FROM object_metadata_4 WHERE id = '1130' AND fieldname = 'productos' AND position = '0' AND ownertype = 'object'
Parameters:
[] |
| 116 | 0.10 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:
[ 1781179879 "system_resource_columns_object_metadata_4" ] |
| 117 | 0.08 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:
[ 1781179879 "\x00tags\x00system_resource_columns_object_metadata_4" ] |
| 118 | 0.66 ms |
SHOW COLUMNS FROM object_metadata_4
Parameters:
[] |
| 119 | 0.12 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 549 "productos" "object" "" 1 "0" "object" "entregados" 5 ] |
| 120 | 0.08 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 549 "productos" "object" "" 1 "0" "object" "vendidos" 0 ] |
| 121 | 0.07 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 549 "productos" "object" "" 1 "0" "object" "pagado" false ] |
| 122 | 0.07 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 996 "productos" "object" "" 2 "0" "object" "entregados" 5 ] |
| 123 | 0.07 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 996 "productos" "object" "" 2 "0" "object" "vendidos" 0 ] |
| 124 | 0.07 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 996 "productos" "object" "" 2 "0" "object" "pagado" false ] |
| 125 | 0.07 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 548 "productos" "object" "" 3 "0" "object" "entregados" 9 ] |
| 126 | 0.07 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 548 "productos" "object" "" 3 "0" "object" "vendidos" 0 ] |
| 127 | 0.07 ms |
INSERT INTO object_metadata_4 (`id`, `dest_id`, `fieldname`, `ownertype`, `ownername`, `index`, `position`, `type`, `column`, `data`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1130 548 "productos" "object" "" 3 "0" "object" "pagado" false ] |
| 128 | 0.11 ms |
SELECT * FROM object_relations_4 WHERE src_id = ?
Parameters:
[
1130
]
|
| 129 | 0.09 ms |
INSERT INTO object_relations_4 (`dest_id`, `type`, `fieldname`, `index`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 549 "object" "productos" 1 1130 "object" "" "0" ] |
| 130 | 0.07 ms |
INSERT INTO object_relations_4 (`dest_id`, `type`, `fieldname`, `index`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 996 "object" "productos" 2 1130 "object" "" "0" ] |
| 131 | 0.07 ms |
INSERT INTO object_relations_4 (`dest_id`, `type`, `fieldname`, `index`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 548 "object" "productos" 3 1130 "object" "" "0" ] |
| 132 | 0.10 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:
[ 1781179879 "system_resource_columns_object_store_4" ] |
| 133 | 0.08 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:
[ 1781179879 "\x00tags\x00system_resource_columns_object_store_4" ] |
| 134 | 0.59 ms |
SHOW COLUMNS FROM object_store_4
Parameters:
[] |
| 135 | 0.10 ms |
INSERT INTO object_store_4 (`oo_id`, `pago`, `entrega`, `cobro`) VALUES (?, ?, ?, ?)
Parameters:
[ 1130 null "2026-06-11" "2026-06-22" ] |
| 136 | 0.08 ms |
UPDATE object_store_4 SET `oo_id` = ?, `pago` = ?, `entrega` = ?, `cobro` = ? WHERE `oo_id` = ?
Parameters:
[ 1130 null "2026-06-11" "2026-06-22" 1130 ] |
| 137 | 0.10 ms |
SELECT * FROM object_query_4 WHERE oo_id = ?
Parameters:
[
1130
]
|
| 138 | 0.15 ms |
INSERT INTO object_query_4 (`productos`, `total`, `pago`, `resta`, `ganancia`, `perdidaVenta`, `perdidaCosto`, `gananciaPerdida`, `entrega`, `cobro`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ ",549,996,548," "0" null "0" "0" "39900" "8624.441986111" "-8624.441986111" "2026-06-11" "2026-06-22" 1130 ] |
| 139 | 0.15 ms |
UPDATE object_query_4 SET `productos` = ?, `total` = ?, `pago` = ?, `resta` = ?, `ganancia` = ?, `perdidaVenta` = ?, `perdidaCosto` = ?, `gananciaPerdida` = ?, `entrega` = ?, `cobro` = ?, `oo_id` = ? WHERE `oo_id` = ?
Parameters:
[ ",549,996,548," "0" null "0" "0" "39900" "8624.441986111" "-8624.441986111" "2026-06-11" "2026-06-22" 1130 1130 ] |
| 140 | 0.14 ms |
DELETE FROM schedule_tasks WHERE `cid` = 1130 AND `ctype` = 'object'
Parameters:
[] |
| 141 | 0.23 ms |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 1130 "object" 0 "" 1781179879 0 1 """ #0 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\Model\Version->save()\n #1 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(281): Pimcore\Model\Element\AbstractElement->doSaveVersion()\n #2 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(219): Pimcore\Model\DataObject\Concrete->saveVersion()\n #3 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(538): Pimcore\Model\DataObject\Concrete->update()\n #4 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(669): Pimcore\Model\DataObject\AbstractObject->save()\n #5 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/src/Controller/DeliveryController.php(82): Pimcore\Model\DataObject\Concrete->save()\n #6 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\DeliveryController->createOrUpdateDelivery()\n #7 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n #8 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()\n #9 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()\n #10 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n #11 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/public/index.php(19): require_once('/home/u93449028...')\n #12 {main} """ 2 null null 0 "fs" ] |
| 142 | 0.10 ms |
"COMMIT"
Parameters:
[] |
| 143 | 0.11 ms |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_1130\x01tags\x01" "object_properties\x01tags\x01" ] |
| 144 | 0.16 ms |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 1130 ] |
| 145 | 0.13 ms |
INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (?, ?, ?, ?)
Parameters:
[ 1130 "object" 549 "object" ] |
| 146 | 0.09 ms |
INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (?, ?, ?, ?)
Parameters:
[ 1130 "object" 996 "object" ] |
| 147 | 0.11 ms |
INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (?, ?, ?, ?)
Parameters:
[ 1130 "object" 548 "object" ] |
| 148 | 0.05 ms |
"START TRANSACTION"
Parameters:
[] |
| 149 | 0.13 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:1130;}}" "[]" "pimcore_search_backend_message" "2026-06-11 12:11:19" "2026-06-11 12:11:19" ] |
| 150 | 0.06 ms |
"COMMIT"
Parameters:
[] |
| 151 | 0.32 ms |
SELECT object_1.id as id, object_1.type as `type` FROM object_1 WHERE object_1.type IN ('object','variant','folder')
Parameters:
[] |
| 152 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_194" ] |
| 153 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_194\x01tags\x01" "class_1\x01tags\x01" ] |
| 154 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1781179879 "object_639" ] |
| 155 | 0.12 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1781179879 "object_639\x01tags\x01" "class_1\x01tags\x01" ] |
| 156 | 0.09 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:
[ 1781179879 "object_781" ] |
| 157 | 0.11 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:
[ 1781179879 "object_781\x01tags\x01" "class_1\x01tags\x01" ] |
| 158 | 0.10 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:
[ 1781179879 "object_897" ] |
| 159 | 0.10 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:
[ 1781179879 "object_897\x01tags\x01" "class_1\x01tags\x01" ] |
| 160 | 0.09 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:
[ 1781179879 "object_974" ] |
| 161 | 0.10 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:
[ 1781179879 "object_974\x01tags\x01" "class_1\x01tags\x01" ] |
| 162 | 0.13 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
447
]
|
| 163 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/00_Entregas/App/" "entrega-1781179821887" ] |
| 164 | 0.13 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/00_Entregas/App/" "entrega-1781179821887" ] |
| 165 | 0.05 ms |
"START TRANSACTION"
Parameters:
[] |
| 166 | 0.10 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
1130
]
|
| 167 | 0.14 ms |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
1130
]
|
| 168 | 0.19 ms |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
1130
]
|
| 169 | 0.11 ms |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
1130
]
|
| 170 | 0.18 ms |
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "/00_Entregas/App/" 1130 1781179879 1781179879 3 0 0 447 "object" "entrega-1781179821887" 0 null null 1 "4" "Entrega" ] |
| 171 | 0.17 ms |
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ?
Parameters:
[ "/00_Entregas/App/" 1130 1781179879 1781179879 3 0 0 447 "object" "entrega-1781179821887" 0 null null 1 "4" "Entrega" 1130 ] |
| 172 | 0.11 ms |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 1130 "object" ] |
| 173 | 0.15 ms |
SELECT * FROM object_relations_4 WHERE src_id = ?
Parameters:
[
1130
]
|
| 174 | 0.12 ms |
INSERT INTO object_relations_4 (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 194 "object" "cliente" 1130 "object" "" "0" ] |
| 175 | 0.12 ms |
INSERT INTO object_store_4 (`oo_id`, `pago`, `entrega`, `cobro`) VALUES (?, ?, ?, ?)
Parameters:
[ 1130 null "2026-06-11" "2026-06-22" ] |
| 176 | 0.12 ms |
UPDATE object_store_4 SET `oo_id` = ?, `pago` = ?, `entrega` = ?, `cobro` = ? WHERE `oo_id` = ?
Parameters:
[ 1130 null "2026-06-11" "2026-06-22" 1130 ] |
| 177 | 0.13 ms |
SELECT * FROM object_query_4 WHERE oo_id = ?
Parameters:
[
1130
]
|
| 178 | 0.13 ms |
INSERT INTO object_query_4 (`total`, `pago`, `resta`, `ganancia`, `perdidaVenta`, `perdidaCosto`, `gananciaPerdida`, `entrega`, `cobro`, `cliente__id`, `cliente__type`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "0" null "0" "0" "39900" "8624.441986111" "-8624.441986111" "2026-06-11" "2026-06-22" 194 "object" 1130 ] |
| 179 | 0.12 ms |
UPDATE object_query_4 SET `total` = ?, `pago` = ?, `resta` = ?, `ganancia` = ?, `perdidaVenta` = ?, `perdidaCosto` = ?, `gananciaPerdida` = ?, `entrega` = ?, `cobro` = ?, `cliente__id` = ?, `cliente__type` = ?, `oo_id` = ? WHERE `oo_id` = ?
Parameters:
[ "0" null "0" "0" "39900" "8624.441986111" "-8624.441986111" "2026-06-11" "2026-06-22" 194 "object" 1130 1130 ] |
| 180 | 0.08 ms |
DELETE FROM schedule_tasks WHERE `cid` = 1130 AND `ctype` = 'object'
Parameters:
[] |
| 181 | 0.17 ms |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 1130 "object" 0 "" 1781179879 0 1 """ #0 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\Model\Version->save()\n #1 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(281): Pimcore\Model\Element\AbstractElement->doSaveVersion()\n #2 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(219): Pimcore\Model\DataObject\Concrete->saveVersion()\n #3 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(538): Pimcore\Model\DataObject\Concrete->update()\n #4 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(669): Pimcore\Model\DataObject\AbstractObject->save()\n #5 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/src/Controller/DeliveryController.php(94): Pimcore\Model\DataObject\Concrete->save()\n #6 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\DeliveryController->createOrUpdateDelivery()\n #7 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n #8 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()\n #9 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()\n #10 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n #11 /home/u934490283/domains/goldenlux-pim.webcomprehensive.com/public/index.php(19): require_once('/home/u93449028...')\n #12 {main} """ 3 null null 0 "fs" ] |
| 182 | 0.09 ms |
"COMMIT"
Parameters:
[] |
| 183 | 0.11 ms |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_1130\x01tags\x01" "object_properties\x01tags\x01" ] |
| 184 | 0.16 ms |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 1130 ] |
| 185 | 0.12 ms |
INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (?, ?, ?, ?)
Parameters:
[ 1130 "object" 194 "object" ] |
| 186 | 0.05 ms |
"START TRANSACTION"
Parameters:
[] |
| 187 | 0.14 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:1130;}}" "[]" "pimcore_search_backend_message" "2026-06-11 12:11:19" "2026-06-11 12:11:19" ] |
| 188 | 0.08 ms |
"COMMIT"
Parameters:
[] |
| 189 | 0.19 ms |
SELECT id FROM objects WHERE published=1 AND id IN (549,996,548);
Parameters:
[] |
| 190 | 0.12 ms |
SELECT id FROM objects WHERE published=1 AND id IN (89);
Parameters:
[] |
| 191 | 0.12 ms |
SELECT id FROM objects WHERE published=1 AND id IN (89);
Parameters:
[] |
| 192 | 0.15 ms |
SELECT id FROM objects WHERE published=1 AND id IN (92,111,84,114,98,87,110);
Parameters:
[] |
| 193 | 0.15 ms |
SELECT id FROM objects WHERE published=1 AND id IN (92,111,84,114,98,87,110);
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| pimcore | doctrine.orm.pimcore_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.