Symfony Profiler

Query Metrics

170 Database Queries

18 Different statements

42.85 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 (?)
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
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 (?)
SELECT `id`, `name` FROM classes WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE  object_localized_13_en.type IN ('object','variant','folder') ORDER BY `name` ASC
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 (?)
SELECT `id`, `name` FROM classes WHERE id = ?
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 (?, ?)
SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE  object_localized_19_en.type IN ('object','variant','folder') ORDER BY `name` ASC
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 (?)
SELECT `id`, `name` FROM classes WHERE id = ?
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 (?, ?)
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 (?)
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 (?, ?)
SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE  object_localized_16_en.type IN ('object','variant','folder') ORDER BY `name` ASC
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 (?)
SELECT `id`, `name` FROM classes WHERE id = ?
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 (?, ?)
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 (?)
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 (?, ?)
SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE  object_localized_17_en.type IN ('object','variant','folder') ORDER BY `name` ASC
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 (?)
SELECT `id`, `name` FROM classes WHERE id = ?
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 (?, ?)
SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE  object_localized_21_en.type IN ('object','variant','folder') ORDER BY `name` ASC
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 (?)
SELECT `id`, `name` FROM classes WHERE id = ?
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 (?, ?)
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
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 (?)
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 (?, ?)
SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE  object_39.type IN ('object','variant','folder') ORDER BY `code` ASC
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 (?)
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 (?, ?)
SELECT * FROM translations_admin LIMIT 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 (?)
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 (?, ?, ?)
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 (?, ?)
SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE  object_localized_13_en.type IN ('object','variant','folder') ORDER BY `name` ASC
SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE  object_localized_19_en.type IN ('object','variant','folder') ORDER BY `name` ASC
SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE  object_localized_16_en.type IN ('object','variant','folder') ORDER BY `name` ASC
SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE  object_localized_17_en.type IN ('object','variant','folder') ORDER BY `name` ASC
SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE  object_localized_21_en.type IN ('object','variant','folder') ORDER BY `name` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND  object_22.type IN ('object','variant','folder') ORDER BY `key` ASC
SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE  object_39.type IN ('object','variant','folder') ORDER BY `code` ASC

#▲	Time	Info
1	0.42 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
2	0.39 ms	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: [`1780413222 "maintenance_mode"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');
3	0.38 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 2`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 2;
4	0.24 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 2;
5	0.22 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 2;
6	0.18 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 2;
7	0.41 ms	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: [`1780413222 "object_1377"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1377');
8	0.36 ms	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"6"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = '6' ;
9	0.30 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
10	0.68 ms	SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE object_localized_13_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE object_localized_13_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE object_localized_13_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
11	0.23 ms	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: [`1780413222 "object_1225"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1225');
12	0.16 ms	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"13"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = '13' ;
13	0.22 ms	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: [`1780413222 "object_1225\x01tags\x01" "class_13\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1225tags', 'class_13tags');
14	0.66 ms	SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE object_localized_19_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE object_localized_19_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE object_localized_19_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
15	0.20 ms	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: [`1780413222 "object_1290"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1290');
16	0.15 ms	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"19"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = '19' ;
17	0.23 ms	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: [`1780413222 "object_1290\x01tags\x01" "class_19\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1290tags', 'class_19tags');
18	0.18 ms	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: [`1780413222 "object_1251"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1251');
19	0.19 ms	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: [`1780413222 "object_1251\x01tags\x01" "class_19\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1251tags', 'class_19tags');
20	0.65 ms	SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE object_localized_16_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE object_localized_16_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE object_localized_16_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
21	0.21 ms	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: [`1780413222 "object_1232"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1232');
22	0.15 ms	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"16"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = '16' ;
23	0.21 ms	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: [`1780413222 "object_1232\x01tags\x01" "class_16\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1232tags', 'class_16tags');
24	0.17 ms	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: [`1780413222 "object_1234"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1234');
25	0.18 ms	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: [`1780413222 "object_1234\x01tags\x01" "class_16\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1234tags', 'class_16tags');
26	0.52 ms	SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE object_localized_17_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE object_localized_17_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE object_localized_17_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
27	0.17 ms	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: [`1780413222 "object_1235"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1235');
28	0.15 ms	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"17"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = '17' ;
29	0.21 ms	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: [`1780413222 "object_1235\x01tags\x01" "class_17\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1235tags', 'class_17tags');
30	0.59 ms	SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE object_localized_21_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE object_localized_21_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE object_localized_21_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
31	0.18 ms	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: [`1780413222 "object_1257"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1257');
32	0.15 ms	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = '21' ;
33	0.21 ms	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: [`1780413222 "object_1257\x01tags\x01" "class_21\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1257tags', 'class_21tags');
34	0.17 ms	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: [`1780413222 "object_1291"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1291');
35	0.19 ms	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: [`1780413222 "object_1291\x01tags\x01" "class_21\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1291tags', 'class_21tags');
36	0.31 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Business Dev"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Business Dev';
37	0.18 ms	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: [`1780413222 "object_1258"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1258');
38	0.18 ms	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: [`1780413222 "object_1258\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1258tags');
39	0.46 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1258`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1258 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
40	0.17 ms	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: [`1780413222 "object_1273"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1273');
41	0.19 ms	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: [`1780413222 "object_1273\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1273tags', 'class_22tags');
42	0.22 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "BD for America"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'BD for America';
43	0.16 ms	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: [`1780413222 "object_1259"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1259');
44	0.16 ms	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: [`1780413222 "object_1259\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1259tags');
45	0.41 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1259`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1259 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
46	0.17 ms	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: [`1780413222 "object_1274"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1274');
47	0.20 ms	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: [`1780413222 "object_1274\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1274tags', 'class_22tags');
48	0.21 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "BD for Europe"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'BD for Europe';
49	0.16 ms	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: [`1780413222 "object_1261"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1261');
50	0.16 ms	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: [`1780413222 "object_1261\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1261tags');
51	0.39 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1261`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1261 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
52	0.17 ms	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: [`1780413222 "object_1276"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1276');
53	0.19 ms	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: [`1780413222 "object_1276\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1276tags', 'class_22tags');
54	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "BD for APAC"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'BD for APAC';
55	0.17 ms	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: [`1780413222 "object_1260"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1260');
56	0.16 ms	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: [`1780413222 "object_1260\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1260tags');
57	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1260`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1260 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
58	0.17 ms	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: [`1780413222 "object_1275"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1275');
59	0.18 ms	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: [`1780413222 "object_1275\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1275tags', 'class_22tags');
60	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "BD for Middle East"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'BD for Middle East';
61	0.16 ms	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: [`1780413222 "object_1262"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1262');
62	0.21 ms	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: [`1780413222 "object_1262\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1262tags');
63	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1262`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1262 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
64	0.18 ms	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: [`1780413222 "object_1277"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1277');
65	0.18 ms	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: [`1780413222 "object_1277\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1277tags', 'class_22tags');
66	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Product Manager"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Product Manager';
67	0.17 ms	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: [`1780413222 "object_1263"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1263');
68	0.15 ms	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: [`1780413222 "object_1263\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1263tags');
69	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1263`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1263 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
70	0.17 ms	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: [`1780413222 "object_1278"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1278');
71	0.18 ms	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: [`1780413222 "object_1278\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1278tags', 'class_22tags');
72	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Process Contact"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Process Contact';
73	0.16 ms	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: [`1780413222 "object_1265"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1265');
74	0.16 ms	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: [`1780413222 "object_1265\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1265tags');
75	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1265`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1265 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
76	0.17 ms	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: [`1780413222 "object_1292"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1292');
77	0.19 ms	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: [`1780413222 "object_1292\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1292tags', 'class_22tags');
78	0.16 ms	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: [`1780413222 "object_1280"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1280');
79	0.18 ms	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: [`1780413222 "object_1280\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1280tags', 'class_22tags');
80	0.21 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical Support"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical Support';
81	0.16 ms	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: [`1780413222 "object_1266"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1266');
82	0.16 ms	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: [`1780413222 "object_1266\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1266tags');
83	0.35 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1266`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1266 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
84	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical for America"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical for America';
85	0.16 ms	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: [`1780413222 "object_1267"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1267');
86	0.16 ms	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: [`1780413222 "object_1267\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1267tags');
87	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1267`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1267 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
88	0.17 ms	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: [`1780413222 "object_1281"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1281');
89	0.18 ms	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: [`1780413222 "object_1281\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1281tags', 'class_22tags');
90	0.21 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Marcom Contact"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Marcom Contact';
91	0.16 ms	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: [`1780413222 "object_1264"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1264');
92	0.16 ms	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: [`1780413222 "object_1264\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1264tags');
93	0.36 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1264`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1264 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
94	0.18 ms	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: [`1780413222 "object_1279"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1279');
95	0.19 ms	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: [`1780413222 "object_1279\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1279tags', 'class_22tags');
96	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical for Europe"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical for Europe';
97	0.17 ms	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: [`1780413222 "object_1269"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1269');
98	0.16 ms	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: [`1780413222 "object_1269\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1269tags');
99	0.36 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1269`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1269 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
100	0.17 ms	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: [`1780413222 "object_1283"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1283');
101	0.18 ms	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: [`1780413222 "object_1283\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1283tags', 'class_22tags');
102	0.22 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical for APAC"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical for APAC';
103	0.18 ms	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: [`1780413222 "object_1268"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1268');
104	0.16 ms	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: [`1780413222 "object_1268\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1268tags');
105	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1268`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1268 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
106	0.17 ms	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: [`1780413222 "object_1282"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1282');
107	0.18 ms	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: [`1780413222 "object_1282\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1282tags', 'class_22tags');
108	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Design Center or Corporate Support"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Design Center or Corporate Support';
109	0.17 ms	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: [`1780413222 "object_1271"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1271');
110	0.16 ms	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: [`1780413222 "object_1271\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1271tags');
111	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1271`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1271 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
112	0.16 ms	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: [`1780413222 "object_1293"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1293');
113	0.18 ms	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: [`1780413222 "object_1293\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1293tags', 'class_22tags');
114	0.16 ms	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: [`1780413222 "object_1286"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1286');
115	0.19 ms	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: [`1780413222 "object_1286\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1286tags', 'class_22tags');
116	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical for Middle East"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical for Middle East';
117	0.16 ms	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: [`1780413222 "object_1270"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1270');
118	0.16 ms	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: [`1780413222 "object_1270\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1270tags');
119	0.36 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1270`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1270 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
120	0.17 ms	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: [`1780413222 "object_1285"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1285');
121	0.18 ms	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: [`1780413222 "object_1285\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1285tags', 'class_22tags');
122	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Veolia Contact (BSP)"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Veolia Contact (BSP)';
123	0.16 ms	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: [`1780413222 "object_1272"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1272');
124	0.15 ms	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: [`1780413222 "object_1272\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1272tags');
125	0.42 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1272`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1272 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
126	0.18 ms	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: [`1780413222 "object_1294"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1294');
127	0.18 ms	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: [`1780413222 "object_1294\x01tags\x01" "class_22\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1294tags', 'class_22tags');
128	0.38 ms	SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE object_39.type IN ('object','variant','folder') ORDER BY `code` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE object_39.type IN ('object', 'variant', 'folder') ORDER BY `code` ASC SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE object_39.type IN ('object','variant','folder') ORDER BY `code` ASC ;
129	0.17 ms	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: [`1780413222 "object_1374"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1374');
130	0.18 ms	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: [`1780413222 "object_1374\x01tags\x01" "class_39\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1374tags', 'class_39tags');
131	0.34 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
132	0.37 ms	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: [`1780413222 "translation_data_2e364d315ad5ad984609e7f4beedf0f7"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_2e364d315ad5ad984609e7f4beedf0f7');
133	0.25 ms	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: [`1780413222 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags');
134	0.21 ms	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: [`1780413222 "object_1377\x01tags\x01" "class_6\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780413222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1377tags', 'class_6tags');
135	0.51 ms	SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE object_localized_13_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE object_localized_13_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE object_localized_13_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
136	0.53 ms	SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE object_localized_19_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE object_localized_19_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE object_localized_19_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
137	0.50 ms	SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE object_localized_16_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE object_localized_16_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE object_localized_16_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
138	0.42 ms	SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE object_localized_17_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE object_localized_17_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE object_localized_17_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
139	0.50 ms	SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE object_localized_21_en.type IN ('object','variant','folder') ORDER BY `name` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE object_localized_21_en.type IN ('object', 'variant', 'folder') ORDER BY `name` ASC SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE object_localized_21_en.type IN ('object','variant','folder') ORDER BY `name` ASC ;
140	0.26 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Business Dev"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Business Dev';
141	0.39 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1258`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1258 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
142	0.21 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "BD for America"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'BD for America';
143	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1259`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1259 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
144	0.21 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "BD for Europe"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'BD for Europe';
145	0.38 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1261`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1261 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
146	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "BD for APAC"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'BD for APAC';
147	0.36 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1260`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1260 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
148	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "BD for Middle East"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'BD for Middle East';
149	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1262`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1262 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
150	0.24 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Product Manager"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Product Manager';
151	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1263`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1263 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
152	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Process Contact"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Process Contact';
153	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1265`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1265 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
154	0.21 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical Support"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical Support';
155	0.36 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1266`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1266 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
156	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical for America"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical for America';
157	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1267`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1267 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
158	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Marcom Contact"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Marcom Contact';
159	0.36 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1264`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1264 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
160	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical for Europe"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical for Europe';
161	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1269`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1269 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
162	0.21 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical for APAC"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical for APAC';
163	0.36 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1268`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1268 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
164	0.22 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Design Center or Corporate Support"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Design Center or Corporate Support';
165	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1271`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1271 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
166	0.21 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Technical for Middle East"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Technical for Middle East';
167	0.36 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1270`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1270 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
168	0.20 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/PIM/Master Data/Contact/" "Veolia Contact (BSP)"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/PIM/Master Data/Contact/' AND `key` = BINARY 'Veolia Contact (BSP)';
169	0.37 ms	SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC Parameters: [`1272`] View formatted query View runnable query Explain query SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object', 'variant', 'folder') ORDER BY `key` ASC SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = 1272 AND object_22.type IN ('object','variant','folder') ORDER BY `key` ASC ;
170	0.36 ms	SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE object_39.type IN ('object','variant','folder') ORDER BY `code` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE object_39.type IN ('object', 'variant', 'folder') ORDER BY `code` ASC SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE object_39.type IN ('object','variant','folder') ORDER BY `code` ASC ;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://pim12-demo.pimcoredemos.com/pimcore-studio/api/class/field-collection/1377/object/layout

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping