Query Metrics
118
Database Queries
49
Different statements
101.98 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
45.22 ms (44.35%) |
2 |
"COMMIT"
Parameters:
[] |
26.40 ms (25.89%) |
1 |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_7258\x01tags\x01" "object_properties\x01tags\x01" ] |
6.78 ms (6.65%) |
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:
[ 1760091265 "site_domain_43419afe57696b349fd61a20df5a68f3" ] |
2.31 ms (2.26%) |
11 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
1.29 ms (1.26%) |
1 |
SHOW COLUMNS FROM object_query_10
Parameters:
[] |
1.23 ms (1.20%) |
1 |
SHOW COLUMNS FROM objects
Parameters:
[] |
1.21 ms (1.19%) |
5 |
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:
[ 1760091265 "system\x01tags\x01" "site\x01tags\x01" ] |
1.06 ms (1.04%) |
1 |
SHOW COLUMNS FROM object_store_10
Parameters:
[] |
1.05 ms (1.03%) |
4 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/manufacturer/product/" "My-New-Add-Product-test-1758580498" ] |
0.97 ms (0.95%) |
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/" 7258 1758580498 1760091265 26 0 0 1212 "object" "My-New-Add-Product-test-1758580498" 0 null null 1 "10" "ProProduct" 7258 ] |
0.97 ms (0.95%) |
4 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
950
]
|
0.83 ms (0.81%) |
1 |
SHOW COLUMNS FROM versions
Parameters:
[] |
0.82 ms (0.80%) |
4 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
950
]
|
0.79 ms (0.78%) |
3 |
SELECT * FROM object_relations_26 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 7258 "ProProduct" ] |
0.75 ms (0.73%) |
3 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Services/Manufacturers/Products/" "My-New-Add-Product-test-1758580498" ] |
0.70 ms (0.69%) |
4 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"10"
]
|
0.63 ms (0.61%) |
3 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/manufacturer/product/My-New-Add-Product-test-1758580498"
]
|
0.57 ms (0.56%) |
2 |
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:
[ 1760091265 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
0.55 ms (0.54%) |
2 |
SELECT * FROM object_relations_22 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 7258 "ProRequirementProduct" ] |
0.44 ms (0.43%) |
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/My-New-Add-Product-test-1758580498" "path" "auto_create" "/manufacturer/product/My-New-Add-Product-test-1758580498" "path_query" "https://arqonz.in/manufacturer/product/My-New-Add-Product-test-1758580498" "entire_uri" ] |
0.38 ms (0.37%) |
2 |
SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = ?
Parameters:
[
1212
]
|
0.35 ms (0.34%) |
2 |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"SupplierBid"
]
|
0.34 ms (0.34%) |
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:
[ 7258 "My New Add Product test" "New" ",950,954,955,956," "a:4:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:1;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:2;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:3;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" null null "Bathroom" null "Bathroom Faucets" null "Tester" "Good Material" "2000" "cms" "hey" "false" 15.0 "/static/videos/1758581520_68d1d310530aa_file_example_MP4_480_1_5MG.mp4" 7258 ] |
0.34 ms (0.33%) |
1 |
SELECT `src_id` FROM `object_relations_10` WHERE (src_id = '7258' AND fieldname NOT IN ('Professional','SupplierBid','ProductReviews') AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1
Parameters:
[] |
0.34 ms (0.33%) |
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:
[ 1760091265 "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.33 ms (0.33%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
0.33 ms (0.32%) |
1 |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
7258
]
|
0.31 ms (0.31%) |
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:
[ "My New Add Product test" "New" ",950,954,955,956," "a:4:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:1;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:2;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:3;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" null "/Services/Manufacturers/Profiles/Bharat-Industrial-Manufacturing-Co-1726637039" null "Bathroom" null "Bathroom Faucets" null "Tester" "Good Material" "2000" "cms" "hey" "My-New-Add-Product-test-1758580498" "false" 15.0 "/static/videos/1758581520_68d1d310530aa_file_example_MP4_480_1_5MG.mp4" 7258 7258 ] |
0.30 ms (0.29%) |
1 |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 7258 "object" 0 "" 1760091265 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(12156): 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} """ 26 null null 0 "fs" ] |
0.30 ms (0.29%) |
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:
[
7258
]
|
0.28 ms (0.27%) |
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:7258;}}" "[]" "pimcore_search_backend_message" "2025-10-10 10:14:25" "2025-10-10 10:14:25" ] |
0.28 ms (0.27%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
0.27 ms (0.26%) |
1 |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 7258 ] |
0.25 ms (0.24%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
0.24 ms (0.23%) |
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:
[ "My New Add Product test" "New" ",950,954,955,956," "a:4:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:1;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:2;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:3;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" null "/Services/Manufacturers/Profiles/Bharat-Industrial-Manufacturing-Co-1726637039" null "Bathroom" null "Bathroom Faucets" null "Tester" "Good Material" "2000" "cms" "hey" "My-New-Add-Product-test-1758580498" "false" 15.0 "/static/videos/1758581520_68d1d310530aa_file_example_MP4_480_1_5MG.mp4" 7258 ] |
0.23 ms (0.23%) |
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:
[ 7258 "My New Add Product test" "New" ",950,954,955,956," "a:4:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:1;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:2;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";i:3;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" null null "Bathroom" null "Bathroom Faucets" null "Tester" "Good Material" "2000" "cms" "hey" "false" 15.0 "/static/videos/1758581520_68d1d310530aa_file_example_MP4_480_1_5MG.mp4" ] |
0.22 ms (0.22%) |
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:
[ 1760091265 "object_7258\x01tags\x01" "class_10\x01tags\x01" "asset_950\x01tags\x01" "asset_954\x01tags\x01" "asset_955\x01tags\x01" "asset_956\x01tags\x01" ] |
0.22 ms (0.22%) |
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/" 7258 1758580498 1760091265 26 0 0 1212 "object" "My-New-Add-Product-test-1758580498" 0 null null 1 "10" "ProProduct" ] |
0.22 ms (0.22%) |
1 |
DELETE FROM tree_locks WHERE id = ? AND TYPE = ?
Parameters:
[ 7258 "object" ] |
0.22 ms (0.21%) |
1 |
SELECT * FROM object_query_10 WHERE oo_id = ?
Parameters:
[
7258
]
|
0.20 ms (0.20%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
0.20 ms (0.20%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
0.20 ms (0.20%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
0.20 ms (0.19%) |
1 |
DELETE FROM schedule_tasks WHERE `cid` = '7258' AND `ctype` = 'object'
Parameters:
[] |
0.19 ms (0.19%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.19 ms (0.18%) |
1 |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
7258
]
|
0.18 ms (0.17%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 7258 "object" ] |
0.17 ms (0.17%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.17 ms (0.16%) |
1 |
SELECT TYPE,classId,className FROM objects WHERE id = ?
Parameters:
[
7258
]
|
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.