GET https://arqonz.in/manufacturer/product/Mattress-1723742907

Query Metrics

115 Database Queries
49 Different statements
66.90 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.