Query Metrics
473
Database Queries
12
Different statements
706.21 ms
Query time
0
Invalid entities
Grouped Statements
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.