POST https://pimcore.jolix.se/pimcore-graphql-webservices/owlstreet

Query Metrics

473 Database Queries
12 Different statements
706.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
634.28 ms
(89.81%)
449
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:
[
  1738291804
  "\x01tags\x01site_domain_0f9cf23bf062eeb2c86284e20766c48e"
  "site_domain_0f9cf23bf062eeb2c86284e20766c48e"
]
12.61 ms
(1.79%)
1
SELECT id, name FROM classes
Parameters:
[]
11.53 ms
(1.63%)
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:
[
  1738291804
  "system\x01tags\x01"
  "site\x01tags\x01"
  "site_domain_0f9cf23bf062eeb2c86284e20766c48e\x01tags\x01"
]
9.58 ms
(1.36%)
3
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/pimcore-graphql-webservices/"
  "owlstreet"
]
9.00 ms
(1.27%)
2
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/pimcore-graphql-webservices/owlstreet"
]
8.30 ms
(1.18%)
1
SELECT object_localized_item_en.id as id, object_localized_item_en.type as `type` FROM object_localized_item_en WHERE ( ((`object_localized_item_en`.`modificationDate` > '1738263003') )  AND  object_localized_item_en.type IN ('object','folder','variant')) AND object_localized_item_en.published = 1 ORDER BY `modificationDate` ASC   LIMIT 200
Parameters:
[]
5.30 ms
(0.75%)
1
SELECT object_localized_product_en.id as id, object_localized_product_en.type as `type` FROM object_localized_product_en LEFT JOIN object_brick_query_armaturtillbehor_product `armaturtillbehor` ON 1
AND `armaturtillbehor`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_batterylight_product `batterylight` ON 1
AND `batterylight`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_downlight_product `downlight` ON 1
AND `downlight`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_energy_product `energy` ON 1
AND `energy`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_light_product `light` ON 1
AND `light`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_security_product `security` ON 1
AND `security`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_stringoflights_product `stringoflights` ON 1
AND `stringoflights`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_technical_product `technical` ON 1
AND `technical`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_typeselection_product `typeselection` ON 1
AND `typeselection`.id = `object_localized_product_en`.id LEFT JOIN object_brick_query_appearance_product `appearance` ON 1
AND `appearance`.id = `object_localized_product_en`.id WHERE ( ((`object_localized_product_en`.`modificationDate` > '1738278325') )  AND  object_localized_product_en.type IN ('object','folder','variant')) AND object_localized_product_en.published = 1 ORDER BY `modificationDate` ASC   LIMIT 200
Parameters:
[]
4.89 ms
(0.69%)
7
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Category"
]
3.84 ms
(0.54%)
1
SELECT object_localized_translation_entry_en.id as id, object_localized_translation_entry_en.type as `type` FROM object_localized_translation_entry_en WHERE ( object_localized_translation_entry_en.type IN ('object','folder','variant')) AND object_localized_translation_entry_en.published = 1 LIMIT 1000
Parameters:
[]
2.81 ms
(0.40%)
5
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "brand"
]
2.73 ms
(0.39%)
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:
[
  1738291805
  "document_1\x01tags\x01"
]
1.35 ms
(0.19%)
1
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  1
]

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.