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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.77 ms
(34.77%)
35
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "barLounge"
]
2.10 ms
(26.40%)
31
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "18"
]
0.75 ms
(9.44%)
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` > '1770091021') )  AND  object_localized_10_en.type IN ('object','folder','variant')
Parameters:
[]
0.53 ms
(6.66%)
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:
[
  1770091082
  "site_domain_c0d65ebf83354c98307dde87e6e5a961"
]
0.52 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` > '1770091021') )  AND  object_localized_10_en.type IN ('object','folder','variant')
Parameters:
[]
0.32 ms
(4.08%)
3
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/pimcore-graphql-webservices/"
  "offers"
]
0.29 ms
(3.60%)
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:
[
  1770091082
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.22 ms
(2.70%)
2
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/pimcore-graphql-webservices/offers"
]
0.19 ms
(2.44%)
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:
[
  1770091082
  "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.15 ms
(1.87%)
1
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
0.12 ms
(1.47%)
1
SELECT id, name FROM classes
Parameters:
[]

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.