POST https://pim.experienciah.app/pimcore-graphql-webservices/offers

Query Metrics

81 Database Queries
11 Different statements
7.52 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.51 ms
(33.41%)
35
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "barLounge"
]
1.96 ms
(26.08%)
31
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "18"
]
0.68 ms
(9.09%)
1
SELECT COUNT(*) FROM object_localized_10_en WHERE  (
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'offers'
                AND LOCATE(CONCAT(`object_localized_10_en`.path,`object_localized_10_en`.key),`plugin_datahub_workspaces_object`.cpath)=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            OR
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'offers'
                AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_10_en`.path,`object_localized_10_en`.key))=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            ) AND  ((`object_localized_10_en`.`modificationDate` > '1770085382') )  AND  object_localized_10_en.type IN ('object','folder','variant')
Parameters:
[]
0.49 ms
(6.58%)
1
SELECT object_localized_10_en.id as id, object_localized_10_en.type as `type` FROM object_localized_10_en WHERE  (
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'offers'
                AND LOCATE(CONCAT(`object_localized_10_en`.path,`object_localized_10_en`.key),`plugin_datahub_workspaces_object`.cpath)=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            OR
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'offers'
                AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_10_en`.path,`object_localized_10_en`.key))=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            ) AND  ((`object_localized_10_en`.`modificationDate` > '1770085382') )  AND  object_localized_10_en.type IN ('object','folder','variant')
Parameters:
[]
0.48 ms
(6.32%)
3
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:
[
  1770085442
  "site_domain_c0d65ebf83354c98307dde87e6e5a961"
]
0.32 ms
(4.23%)
3
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/pimcore-graphql-webservices/"
  "offers"
]
0.31 ms
(4.14%)
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:
[
  1770085442
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.28 ms
(3.69%)
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:
[
  1770085442
  "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.20 ms
(2.68%)
2
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/pimcore-graphql-webservices/offers"
]
0.16 ms
(2.16%)
1
SELECT id, name FROM classes
Parameters:
[]
0.12 ms
(1.62%)
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.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.