Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

110 Database Queries

28 Different statements

15.17 ms Query time

0 Invalid entities

Queries

Group similar statements


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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
SELECT name FROM classes WHERE id = ?
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT * FROM object_store_35 WHERE oo_id = ?
SELECT * FROM object_localized_data_35 WHERE ooo_id = ? AND language IN ('en','de','fr','it','da','ro','nl','uk','ru')
select `highlights` from object_localized_data_35 where language = 'da' and  ooo_id  = 3140
select `highlights` from object_localized_data_35 where language = 'de' and  ooo_id  = 3140
select `highlights` from object_localized_data_35 where language = 'en' and  ooo_id  = 3140
select `highlights` from object_localized_data_35 where language = 'fr' and  ooo_id  = 3140
select `highlights` from object_localized_data_35 where language = 'it' and  ooo_id  = 3140
select `highlights` from object_localized_data_35 where language = 'nl' and  ooo_id  = 3140
select `highlights` from object_localized_data_35 where language = 'ro' and  ooo_id  = 3140
select `highlights` from object_localized_data_35 where language = 'ru' and  ooo_id  = 3140
select `highlights` from object_localized_data_35 where language = 'uk' and  ooo_id  = 3140
SELECT item_id, 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 item_id, 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 item_id, 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 item_id, 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 object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters'
SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters'
SELECT item_id, 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 item_id, 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 item_id, 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 item_id, 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 * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties'
SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties'
SELECT item_id, 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 item_id, 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 item_id, 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 item_id, 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 item_id, 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 item_id, 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 object_relations_35 WHERE src_id = ?
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
SELECT id FROM versions WHERE cid = ? AND ctype = ? AND (autoSave=0 OR (autoSave=1 AND userId = ?))   ORDER BY `date` ASC
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?

#▲	Time	Info
1	0.22 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 16`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 16;
2	0.13 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 16;
3	0.10 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 16;
4	0.09 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 16;
5	0.30 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: [`1789636301 [ "\x00tags\x00object_3140" "object_3140" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3140', 'object_3140');
6	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: [`1789636301 [ "object_3140\x00tags\x00" "class_35\x00tags\x00" "asset_51688\x00tags\x00" "asset_51689\x00tags\x00" "asset_51690\x00tags\x00" "asset_51691\x00tags\x00" "asset_51692\x00tags\x00" "asset_51693\x00tags\x00" "asset_51694\x00tags\x00" "asset_51695\x00tags\x00" "asset_51696\x00tags\x00" "asset_51697\x00tags\x00" "asset_51698\x00tags\x00" "asset_51699\x00tags\x00" "asset_51700\x00tags\x00" "asset_47194\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3140\0tags\0', 'class_35\0tags\0', 'asset_51688\0tags\0', 'asset_51689\0tags\0', 'asset_51690\0tags\0', 'asset_51691\0tags\0', 'asset_51692\0tags\0', 'asset_51693\0tags\0', 'asset_51694\0tags\0', 'asset_51695\0tags\0', 'asset_51696\0tags\0', 'asset_51697\0tags\0', 'asset_51698\0tags\0', 'asset_51699\0tags\0', 'asset_51700\0tags\0', 'asset_47194\0tags\0');
7	0.18 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`3 => null 4 => 1789636301 1 => "object_3140\x00tags\x00" 2 => b"\x00\x00\x00\x02 t¥¥êZ#±("`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('object_3140\0tags\0', 0x000000022074A5A5EA5A23B128, NULL, 1789636301) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
8	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"35"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '35';
9	0.11 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`3140`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 3140;
10	0.15 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`3140`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 3140;
11	0.22 ms	SELECT * FROM object_store_35 WHERE oo_id = ? Parameters: [`3140`] View formatted query View runnable query Explain query SELECT * FROM object_store_35 WHERE oo_id = ? SELECT * FROM object_store_35 WHERE oo_id = 3140;
12	0.89 ms	SELECT * FROM object_localized_data_35 WHERE ooo_id = ? AND language IN ('en','de','fr','it','da','ro','nl','uk','ru') Parameters: [`3140`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_35 WHERE ooo_id = ? AND language IN ( 'en', 'de', 'fr', 'it', 'da', 'ro', 'nl', 'uk', 'ru' ) SELECT * FROM object_localized_data_35 WHERE ooo_id = 3140 AND language IN ('en','de','fr','it','da','ro','nl','uk','ru');
13	0.11 ms	select `highlights` from object_localized_data_35 where language = 'da' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'da' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'da' and ooo_id = 3140;
14	0.09 ms	select `highlights` from object_localized_data_35 where language = 'de' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'de' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'de' and ooo_id = 3140;
15	0.08 ms	select `highlights` from object_localized_data_35 where language = 'en' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'en' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'en' and ooo_id = 3140;
16	0.07 ms	select `highlights` from object_localized_data_35 where language = 'fr' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'fr' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'fr' and ooo_id = 3140;
17	0.08 ms	select `highlights` from object_localized_data_35 where language = 'it' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'it' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'it' and ooo_id = 3140;
18	0.07 ms	select `highlights` from object_localized_data_35 where language = 'nl' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'nl' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'nl' and ooo_id = 3140;
19	0.07 ms	select `highlights` from object_localized_data_35 where language = 'ro' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'ro' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'ro' and ooo_id = 3140;
20	0.06 ms	select `highlights` from object_localized_data_35 where language = 'ru' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'ru' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'ru' and ooo_id = 3140;
21	0.07 ms	select `highlights` from object_localized_data_35 where language = 'uk' and ooo_id = 3140 Parameters: [] View formatted query View runnable query Explain query select `highlights` from object_localized_data_35 where language = 'uk' and ooo_id = 3140 select `highlights` from object_localized_data_35 where language = 'uk' and ooo_id = 3140;
22	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: [`1789636301 [ "\x00tags\x00asset_51688" "asset_51688" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51688', 'asset_51688');
23	0.13 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: [`1789636301 [ "\x00tags\x00asset_51689" "asset_51689" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51689', 'asset_51689');
24	0.13 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: [`1789636301 [ "\x00tags\x00asset_51690" "asset_51690" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51690', 'asset_51690');
25	0.12 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: [`1789636301 [ "\x00tags\x00asset_51691" "asset_51691" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51691', 'asset_51691');
26	0.11 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: [`1789636301 [ "\x00tags\x00asset_51692" "asset_51692" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51692', 'asset_51692');
27	0.11 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: [`1789636301 [ "\x00tags\x00asset_51693" "asset_51693" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51693', 'asset_51693');
28	0.12 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: [`1789636301 [ "\x00tags\x00asset_51694" "asset_51694" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51694', 'asset_51694');
29	0.11 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: [`1789636301 [ "\x00tags\x00asset_51695" "asset_51695" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51695', 'asset_51695');
30	0.11 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: [`1789636301 [ "\x00tags\x00asset_51696" "asset_51696" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51696', 'asset_51696');
31	0.12 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: [`1789636301 [ "\x00tags\x00asset_51697" "asset_51697" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51697', 'asset_51697');
32	0.12 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: [`1789636301 [ "\x00tags\x00asset_51698" "asset_51698" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51698', 'asset_51698');
33	0.11 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: [`1789636301 [ "\x00tags\x00asset_51699" "asset_51699" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51699', 'asset_51699');
34	0.11 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: [`1789636301 [ "\x00tags\x00asset_51700" "asset_51700" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_51700', 'asset_51700');
35	0.25 ms	SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters' SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters';
36	0.27 ms	SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters' SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryParameters';
37	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: [`1789636301 [ "\x00tags\x00cs_keyconfig_120" "cs_keyconfig_120" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_120', 'cs_keyconfig_120');
38	0.11 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: [`1789636301 [ "cs_keyconfig_120\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_120\0tags\0');
39	0.14 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_125" "cs_keyconfig_125" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_125', 'cs_keyconfig_125');
40	0.10 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: [`1789636301 [ "cs_keyconfig_125\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_125\0tags\0');
41	0.13 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_126" "cs_keyconfig_126" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_126', 'cs_keyconfig_126');
42	0.10 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: [`1789636301 [ "cs_keyconfig_126\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_126\0tags\0');
43	0.11 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_148" "cs_keyconfig_148" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_148', 'cs_keyconfig_148');
44	0.09 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: [`1789636301 [ "cs_keyconfig_148\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_148\0tags\0');
45	0.12 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_150" "cs_keyconfig_150" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_150', 'cs_keyconfig_150');
46	0.09 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: [`1789636301 [ "cs_keyconfig_150\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_150\0tags\0');
47	0.11 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_152" "cs_keyconfig_152" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_152', 'cs_keyconfig_152');
48	0.09 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: [`1789636301 [ "cs_keyconfig_152\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_152\0tags\0');
49	0.12 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_153" "cs_keyconfig_153" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_153', 'cs_keyconfig_153');
50	0.10 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: [`1789636301 [ "cs_keyconfig_153\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_153\0tags\0');
51	0.11 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_154" "cs_keyconfig_154" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_154', 'cs_keyconfig_154');
52	0.09 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: [`1789636301 [ "cs_keyconfig_154\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_154\0tags\0');
53	0.13 ms	SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties' SELECT * FROM object_classificationstore_groups_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties';
54	0.17 ms	SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties' SELECT * FROM object_classificationstore_data_35 WHERE o_id = '3140' AND fieldname = 'categoryProperties';
55	0.12 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_131" "cs_keyconfig_131" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_131', 'cs_keyconfig_131');
56	0.10 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: [`1789636301 [ "cs_keyconfig_131\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_131\0tags\0');
57	0.13 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_135" "cs_keyconfig_135" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_135', 'cs_keyconfig_135');
58	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: [`1789636301 [ "cs_keyconfig_135\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_135\0tags\0');
59	0.12 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_156" "cs_keyconfig_156" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_156', 'cs_keyconfig_156');
60	0.10 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: [`1789636301 [ "cs_keyconfig_156\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_156\0tags\0');
61	0.12 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_167" "cs_keyconfig_167" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_167', 'cs_keyconfig_167');
62	0.27 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: [`1789636301 [ "cs_keyconfig_167\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_167\0tags\0');
63	0.13 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_168" "cs_keyconfig_168" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_168', 'cs_keyconfig_168');
64	0.11 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: [`1789636301 [ "cs_keyconfig_168\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_168\0tags\0');
65	0.12 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_169" "cs_keyconfig_169" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_169', 'cs_keyconfig_169');
66	0.10 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: [`1789636301 [ "cs_keyconfig_169\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_169\0tags\0');
67	0.11 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_171" "cs_keyconfig_171" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_171', 'cs_keyconfig_171');
68	0.10 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: [`1789636301 [ "cs_keyconfig_171\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_171\0tags\0');
69	0.11 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_172" "cs_keyconfig_172" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_172', 'cs_keyconfig_172');
70	0.09 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: [`1789636301 [ "cs_keyconfig_172\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_172\0tags\0');
71	0.11 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_173" "cs_keyconfig_173" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_173', 'cs_keyconfig_173');
72	0.09 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: [`1789636301 [ "cs_keyconfig_173\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_173\0tags\0');
73	0.36 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: [`1789636301 [ "\x00tags\x00cs_keyconfig_193" "cs_keyconfig_193" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cs_keyconfig_193', 'cs_keyconfig_193');
74	0.11 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: [`1789636301 [ "cs_keyconfig_193\x00tags\x00" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_keyconfig_193\0tags\0');
75	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: [`1789636301 [ "\x00tags\x00asset_47194" "asset_47194" ]`] 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 > 1789636301 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_47194', 'asset_47194');
76	0.25 ms	SELECT * FROM object_relations_35 WHERE src_id = ? Parameters: [`3140`] View formatted query View runnable query Explain query SELECT * FROM object_relations_35 WHERE src_id = ? SELECT * FROM object_relations_35 WHERE src_id = 3140;
77	0.14 ms	SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? Parameters: [`3140 "object"`] View formatted query View runnable query Explain query SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? SELECT id FROM schedule_tasks WHERE `cid` = 3140 AND `ctype` = 'object' ;
78	1.73 ms	SELECT id FROM versions WHERE cid = ? AND ctype = ? AND (autoSave=0 OR (autoSave=1 AND userId = ?)) ORDER BY `date` ASC Parameters: [`3140 "object" 16`] View formatted query View runnable query Explain query SELECT id FROM versions WHERE cid = ? AND ctype = ? AND ( autoSave = 0 OR ( autoSave = 1 AND userId = ? ) ) ORDER BY `date` ASC SELECT id FROM versions WHERE cid = 3140 AND ctype = 'object' AND (autoSave=0 OR (autoSave=1 AND userId = 16)) ORDER BY `date` ASC;
79	0.13 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227115`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227115;
80	0.09 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227116`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227116;
81	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227118`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227118;
82	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227119`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227119;
83	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227129`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227129;
84	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227130`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227130;
85	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227132`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227132;
86	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227137`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227137;
87	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227139`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227139;
88	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227140`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227140;
89	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227146`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227146;
90	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227176`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227176;
91	0.07 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227177`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227177;
92	0.07 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227182`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227182;
93	0.07 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227183`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227183;
94	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`227187`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 227187;
95	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230265`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230265;
96	0.19 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230264`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230264;
97	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230266`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230266;
98	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230267`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230267;
99	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230268`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230268;
100	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230269`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230269;
101	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230270`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230270;
102	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230271`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230271;
103	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230272`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230272;
104	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230863`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230863;
105	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`230864`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 230864;
106	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`247041`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 247041;
107	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`247042`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 247042;
108	0.09 ms	SELECT * FROM versions WHERE id = ? Parameters: [`279606`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 279606;
109	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`279620`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 279620;
110	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`279621`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 279621;

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.

Entities Mapping

No loaded entities.

Symfony Profiler

https://pim.ampm-service.com/admin/element/get-versions?_dc=1789636301186&elementType=object&id=3140&limit=25&page=1&start=0

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping