Query Metrics
115
Database Queries
49
Different statements
66.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.55 ms (33.71%) |
2 |
"COMMIT"
Parameters:
[] |
|
7.95 ms (11.88%) |
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 => 1765047546 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"‘Ùö\x06À\x1E";i:1765047546;}" ] |
|
7.48 ms (11.18%) |
1 |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_2443\x01tags\x01" "object_properties\x01tags\x01" ] |
|
6.83 ms (10.22%) |
32 |
SELECT item_id, 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:
[ 1765047546 "site_domain_43419afe57696b349fd61a20df5a68f3" ] |
|
2.27 ms (3.39%) |
11 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
|
1.34 ms (2.01%) |
1 |
SHOW COLUMNS FROM objects
Parameters:
[] |
|
1.19 ms (1.78%) |
1 |
SHOW COLUMNS FROM versions
Parameters:
[] |
|
1.03 ms (1.54%) |
1 |
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ?
Parameters:
[ "/Services/Manufacturers/Products/" 2443 1723742907 1765047546 18 0 0 1212 "object" "Mattress-1723742907" 0 null null 1 "10" "ProProduct" 2443 ] |
|
0.95 ms (1.42%) |
1 |
SHOW COLUMNS FROM object_query_10
Parameters:
[] |
|
0.92 ms (1.38%) |
1 |
SHOW COLUMNS FROM object_store_10
Parameters:
[] |
|
0.88 ms (1.32%) |
3 |
SELECT * FROM object_relations_26 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 2443 "ProProduct" ] |
|
0.85 ms (1.27%) |
3 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Services/Manufacturers/Products/" "Mattress-1723742907" ] |
|
0.85 ms (1.26%) |
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:
[ 1765047546 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
0.84 ms (1.25%) |
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:
[ 1765047546 "system\x01tags\x01" "site\x01tags\x01" ] |
|
0.80 ms (1.19%) |
4 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/manufacturer/product/" "Mattress-1723742907" ] |
|
0.69 ms (1.03%) |
4 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"10"
]
|
|
0.50 ms (0.75%) |
2 |
SELECT * FROM object_relations_22 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 2443 "ProRequirementProduct" ] |
|
0.47 ms (0.70%) |
2 |
SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = ?
Parameters:
[
1212
]
|
|
0.45 ms (0.68%) |
2 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
469
]
|
|
0.44 ms (0.66%) |
3 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/manufacturer/product/Mattress-1723742907"
]
|
|
0.42 ms (0.62%) |
2 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
469
]
|
|
0.40 ms (0.59%) |
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:
[ "/manufacturer/product/Mattress-1723742907" "path" "auto_create" "/manufacturer/product/Mattress-1723742907" "path_query" "https://arqonz.in/manufacturer/product/Mattress-1723742907" "entire_uri" ] |
|
0.38 ms (0.57%) |
1 |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 2443 "object" 0 "" 1765047546 0 1 """ #0 /var/www/pimcore/vendor/pimcore/pimcore/models/Element/AbstractElement.php(596): Pimcore\Model\Version->save()\n #1 /var/www/pimcore/vendor/pimcore/pimcore/models/DataObject/Concrete.php(278): Pimcore\Model\Element\AbstractElement->doSaveVersion()\n #2 /var/www/pimcore/vendor/pimcore/pimcore/models/DataObject/Concrete.php(216): Pimcore\Model\DataObject\Concrete->saveVersion()\n #3 /var/www/pimcore/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(563): Pimcore\Model\DataObject\Concrete->update()\n #4 /var/www/pimcore/vendor/pimcore/pimcore/models/DataObject/Concrete.php(666): Pimcore\Model\DataObject\AbstractObject->save()\n #5 /var/www/pimcore/src/Controller/ContentController.php(12584): Pimcore\Model\DataObject\Concrete->save()\n #6 /var/www/pimcore/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\ContentController->ManufacturerProductDetails()\n #7 /var/www/pimcore/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n #8 /var/www/pimcore/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()\n #9 /var/www/pimcore/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()\n #10 /var/www/pimcore/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n #11 /var/www/pimcore/public/index.php(21): require_once('...')\n #12 {main} """ 18 null null 0 "fs" ] |
|
0.35 ms (0.52%) |
2 |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"SupplierBid"
]
|
|
0.32 ms (0.47%) |
1 |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
2443
]
|
|
0.31 ms (0.46%) |
1 |
UPDATE object_store_10 SET `oo_id` = ?, `ProductName` = ?, `ProductDescription` = ?, `ProductImage__images` = ?, `ProductImage__hotspots` = ?, `Specifications` = ?, `ProductCategory` = ?, `ParentCategory` = ?, `SubSubCategory` = ?, `SubCategory` = ?, `ProductType` = ?, `ProductBrand` = ?, `Material` = ?, `Price` = ?, `Unit` = ?, `Tags` = ?, `InternationalBrand` = ?, `PageViewsCount` = ?, `ProductVideoPaths` = ? WHERE `oo_id` = ?
Parameters:
[ 2443 "Mattress" "Our premium mattresses are handcrafted to perfection for giving you a restful sleep. The mattress has 100% natural fine kapok cotton filling to provide ergonomic support to your body. We have strived to bring the best of Mother Nature to ensure that you have a comfortable sleep and fulfil your dreams at nature’s lap." ",469," "a:1:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" "Standard Sizes & Custom sizes available." null "Furniture" "Matress" "Bedroom" null "Kana Mattress" "Kapok Cotton" "starting from INR 10000.00" "1" "mattress, Kapok Cotton, Single Mattress, Double Mattress, Queen Mattress, King Mattress" null 16.0 null 2443 ] |
|
0.31 ms (0.46%) |
1 |
INSERT INTO object_query_10 (`ProductName`, `ProductDescription`, `ProductImage__images`, `ProductImage__hotspots`, `Specifications`, `ProfessionalPath`, `ProductCategory`, `ParentCategory`, `SubSubCategory`, `SubCategory`, `ProductType`, `ProductBrand`, `Material`, `Price`, `Unit`, `Tags`, `ObjKey`, `InternationalBrand`, `PageViewsCount`, `ProductVideoPaths`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Mattress" "Our premium mattresses are handcrafted to perfection for giving you a restful sleep. The mattress has 100% natural fine kapok cotton filling to provide ergonomic support to your body. We have strived to bring the best of Mother Nature to ensure that you have a comfortable sleep and fulfil your dreams at nature’s lap." ",469," "a:1:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" "Standard Sizes & Custom sizes available." "/Services/Manufacturers/Profiles/Kana-Mattress-1710525826" null "Furniture" "Matress" "Bedroom" null "Kana Mattress" "Kapok Cotton" "starting from INR 10000.00" "1" "mattress, Kapok Cotton, Single Mattress, Double Mattress, Queen Mattress, King Mattress" "Mattress-1723742907" null 16.0 null 2443 ] |
|
0.29 ms (0.44%) |
1 |
UPDATE object_query_10 SET `ProductName` = ?, `ProductDescription` = ?, `ProductImage__images` = ?, `ProductImage__hotspots` = ?, `Specifications` = ?, `ProfessionalPath` = ?, `ProductCategory` = ?, `ParentCategory` = ?, `SubSubCategory` = ?, `SubCategory` = ?, `ProductType` = ?, `ProductBrand` = ?, `Material` = ?, `Price` = ?, `Unit` = ?, `Tags` = ?, `ObjKey` = ?, `InternationalBrand` = ?, `PageViewsCount` = ?, `ProductVideoPaths` = ?, `oo_id` = ? WHERE `oo_id` = ?
Parameters:
[ "Mattress" "Our premium mattresses are handcrafted to perfection for giving you a restful sleep. The mattress has 100% natural fine kapok cotton filling to provide ergonomic support to your body. We have strived to bring the best of Mother Nature to ensure that you have a comfortable sleep and fulfil your dreams at nature’s lap." ",469," "a:1:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" "Standard Sizes & Custom sizes available." "/Services/Manufacturers/Profiles/Kana-Mattress-1710525826" null "Furniture" "Matress" "Bedroom" null "Kana Mattress" "Kapok Cotton" "starting from INR 10000.00" "1" "mattress, Kapok Cotton, Single Mattress, Double Mattress, Queen Mattress, King Mattress" "Mattress-1723742907" null 16.0 null 2443 2443 ] |
|
0.29 ms (0.43%) |
1 |
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "/Services/Manufacturers/Products/" 2443 1723742907 1765047546 18 0 0 1212 "object" "Mattress-1723742907" 0 null null 1 "10" "ProProduct" ] |
|
0.28 ms (0.42%) |
1 |
INSERT INTO object_store_10 (`oo_id`, `ProductName`, `ProductDescription`, `ProductImage__images`, `ProductImage__hotspots`, `Specifications`, `ProductCategory`, `ParentCategory`, `SubSubCategory`, `SubCategory`, `ProductType`, `ProductBrand`, `Material`, `Price`, `Unit`, `Tags`, `InternationalBrand`, `PageViewsCount`, `ProductVideoPaths`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2443 "Mattress" "Our premium mattresses are handcrafted to perfection for giving you a restful sleep. The mattress has 100% natural fine kapok cotton filling to provide ergonomic support to your body. We have strived to bring the best of Mother Nature to ensure that you have a comfortable sleep and fulfil your dreams at nature’s lap." ",469," "a:1:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" "Standard Sizes & Custom sizes available." null "Furniture" "Matress" "Bedroom" null "Kana Mattress" "Kapok Cotton" "starting from INR 10000.00" "1" "mattress, Kapok Cotton, Single Mattress, Double Mattress, Queen Mattress, King Mattress" null 16.0 null ] |
|
0.28 ms (0.42%) |
1 |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 2443 ] |
|
0.27 ms (0.41%) |
1 |
SELECT name, TYPE, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,1212,1209,1190) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
2443
]
|
|
0.27 ms (0.40%) |
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:2443;}}" "[]" "pimcore_search_backend_message" "2025-12-06 18:59:06" "2025-12-06 18:59:06" ] |
|
0.26 ms (0.39%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 2443 "object" ] |
|
0.26 ms (0.39%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
|
0.26 ms (0.39%) |
1 |
SELECT `src_id` FROM `object_relations_10` WHERE (src_id = '2443' AND fieldname NOT IN ('Professional','SupplierBid','ProductReviews') AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1
Parameters:
[] |
|
0.24 ms (0.36%) |
1 |
DELETE FROM tree_locks WHERE id = ? AND TYPE = ?
Parameters:
[ 2443 "object" ] |
|
0.24 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:
[ 1765047546 "document_1\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01" ] |
|
0.23 ms (0.35%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
|
0.23 ms (0.34%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
|
0.22 ms (0.33%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
|
0.22 ms (0.32%) |
1 |
SELECT * FROM object_query_10 WHERE oo_id = ?
Parameters:
[
2443
]
|
|
0.22 ms (0.32%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
|
0.19 ms (0.29%) |
1 |
DELETE FROM schedule_tasks WHERE `cid` = '2443' AND `ctype` = 'object'
Parameters:
[] |
|
0.19 ms (0.29%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.19 ms (0.28%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.18 ms (0.27%) |
1 |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
2443
]
|
|
0.18 ms (0.26%) |
1 |
SELECT TYPE,classId,className FROM objects WHERE id = ?
Parameters:
[
2443
]
|
|
0.16 ms (0.24%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
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.