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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.74 ms
(35.26%)
35
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "barLounge"
]
2.13 ms
(27.41%)
31
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "18"
]
0.65 ms
(8.34%)
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` > '1770090002') )  AND  object_localized_10_en.type IN ('object','folder','variant')
Parameters:
[]
0.54 ms
(6.99%)
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` > '1770090002') )  AND  object_localized_10_en.type IN ('object','folder','variant')
Parameters:
[]
0.44 ms
(5.61%)
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:
[
  1770090062
  "site_domain_c0d65ebf83354c98307dde87e6e5a961"
]
0.35 ms
(4.52%)
3
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/pimcore-graphql-webservices/"
  "offers"
]
0.27 ms
(3.42%)
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:
[
  1770090062
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.22 ms
(2.82%)
2
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/pimcore-graphql-webservices/offers"
]
0.19 ms
(2.50%)
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:
[
  1770090062
  "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.12 ms
(1.57%)
1
SELECT id, name FROM classes
Parameters:
[]
0.12 ms
(1.56%)
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.