Query Metrics
344
Database Queries
30
Different statements
68.81 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.24 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 2 | 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:
[ 1793189634 "app:46e455d981ac1cc3fed9317d1575692bad8db072" ] |
| 3 | 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:
[ 1793189634 "app:46e455d981ac1cc3fed9317d1575692bad8db072" ] |
| 4 | 1.22 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:
[ 2 => 110 3 => 1793189634 0 => "app:46e455d981ac1cc3fed9317d1575692bad8db072" 1 => b"O:1:"©":1:{s:6:"éC¤\x08À\x1E";O:50:"Symfony\Component\RateLimiter\Policy\SlidingWindow":1:{s:45:"\x00\x00\x00\x02\x00\x00\x00\x00\x00\x00\x00<studio_api_general-175.107.141.54";d:1793189685.056817;}}" ] |
| 5 | 0.56 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:
[ 1793189634 "maintenance_mode" ] |
| 6 | 0.39 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "default_embeddings" "backend_power_tools_embeddings" ] |
| 7 | 0.23 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 22 ] |
| 8 | 0.15 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
22
]
|
| 9 | 0.12 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
22
]
|
| 10 | 0.12 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
22
]
|
| 11 | 0.26 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:
[ 1793189634 "studio_backend_user_permissions" ] |
| 12 | 0.25 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 13 | 0.15 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"6"
]
|
| 14 | 0.45 ms |
SELECT object_20.id as id, object_20.type as `type` FROM object_20 WHERE object_20.type IN ('object','variant','folder')
Parameters:
[] |
| 15 | 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:
[ 1793189634 "object_1211" ] |
| 16 | 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:
[ 1793189634 "object_1211\x01tags\x01" "class_20\x01tags\x01" ] |
| 17 | 0.24 ms |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
| 18 | 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:
[ 1793189634 "translation_data_2e364d315ad5ad984609e7f4beedf0f7" ] |
| 19 | 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:
[ 1793189634 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01" ] |
| 20 | 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:
[ 1793189634 "object_1233" ] |
| 21 | 0.28 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:
[ 1793189634 "object_1233\x01tags\x01" "class_6\x01tags\x01" ] |
| 22 | 0.44 ms |
SELECT * FROM versions WHERE cid = ? AND ctype = ? AND (`date` > ? OR versionCount > ?) AND ((autoSave = 1 AND userId = ?) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1
Parameters:
[ 1233 "object" 1793176379 22 22 ] |
| 23 | 0.36 ms |
SELECT object_20.id as id, object_20.type as `type` FROM object_20 WHERE object_20.type IN ('object','variant','folder')
Parameters:
[] |
| 24 | 0.22 ms |
UPDATE users SET lastLogin = ? WHERE id = ?
Parameters:
[ 1793189634 22 ] |
| 25 | 0.43 ms |
SELECT object_20.id as id, object_20.type as `type` FROM object_20 WHERE object_20.type IN ('object','variant','folder')
Parameters:
[] |
| 26 | 0.18 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 27 | 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:
[ 1793189634 "object_1232" ] |
| 28 | 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:
[ 1793189634 "object_1232\x01tags\x01" ] |
| 29 | 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:
[ 1793189634 "object_1227" ] |
| 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:
[ 1793189634 "object_1227\x01tags\x01" ] |
| 31 | 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:
[ 1793189634 "object_1185" ] |
| 32 | 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:
[ 1793189634 "object_1185\x01tags\x01" ] |
| 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:
[ 1793189634 "object_1184" ] |
| 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:
[ 1793189634 "object_1184\x01tags\x01" ] |
| 35 | 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:
[ 1793189634 "object_1" ] |
| 36 | 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:
[ 1793189634 "object_1\x01tags\x01" ] |
| 37 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 38 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 39 | 0.15 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 40 | 0.15 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 41 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 42 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 43 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 44 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 45 | 0.33 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 46 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 47 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 48 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 49 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 50 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 51 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 52 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 53 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 54 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 55 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 56 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 57 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 58 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 59 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 60 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 61 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 62 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 63 | 0.15 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 64 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 65 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 66 | 0.17 ms |
SELECT * FROM object_relations_6 WHERE src_id = ?
Parameters:
[
1233
]
|
| 67 | 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:
[ 1793189634 "object_1193" ] |
| 68 | 0.13 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"19"
]
|
| 69 | 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:
[ 1793189634 "object_1193\x01tags\x01" "class_19\x01tags\x01" ] |
| 70 | 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:
[ 1793189634 "object_1197" ] |
| 71 | 0.12 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"7"
]
|
| 72 | 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:
[ 1793189634 "object_1197\x01tags\x01" "class_7\x01tags\x01" ] |
| 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:
[ 1793189634 "object_1205" ] |
| 74 | 0.13 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"21"
]
|
| 75 | 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:
[ 1793189634 "object_1205\x01tags\x01" "class_21\x01tags\x01" ] |
| 76 | 0.16 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 77 | 0.14 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 78 | 0.14 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 79 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 80 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 81 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 82 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 83 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 84 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 85 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 86 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 87 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 88 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 89 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 90 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 91 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 92 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 93 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 94 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 95 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 96 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 97 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 98 | 0.62 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 99 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 100 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 101 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 102 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 103 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 104 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 105 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 106 | 0.14 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 107 | 0.41 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemName' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 108 | 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:
[ 1793189634 "object_1241" ] |
| 109 | 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:
[ 1793189634 "object_1241\x01tags\x01" "class_14\x01tags\x01" ] |
| 110 | 0.11 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"14"
]
|
| 111 | 0.22 ms |
SELECT `id`, `name` FROM classes WHERE name not LIKE 'AutoTagRule' AND name not LIKE 'AssetMetadataRule' AND name not LIKE 'AutoClassificationRule' AND name not LIKE 'DataDuplicationRule' AND name not LIKE 'DataEnrichmentRule' AND name not LIKE 'DataValidationRule' AND name not LIKE 'NamingRule' AND name not LIKE 'SuffixRule' AND name not LIKE 'PrefixRule' AND name not LIKE 'SeparatorRule' AND name not LIKE 'CaseRule' AND name not LIKE 'PriceRule' AND name not LIKE 'CalculationRule' AND name not LIKE 'ConditionalDataCopyRule' ORDER BY `name` ASC
Parameters:
[] |
| 112 | 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:
[ 1793189634 "system_supported_locales_en" ] |
| 113 | 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:
[ 1793189634 "system\x01tags\x01" ] |
| 114 | 0.18 ms |
SELECT id FROM targeting_target_groups ORDER BY `name` ASC
Parameters:
[] |
| 115 | 0.21 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
5
]
|
| 116 | 0.15 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
4
]
|
| 117 | 0.14 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
1
]
|
| 118 | 0.16 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
2
]
|
| 119 | 0.14 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
6
]
|
| 120 | 0.15 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
3
]
|
| 121 | 0.19 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "EventStatus" "pimcore_select_options" ] |
| 122 | 0.33 ms |
SELECT id,type FROM users WHERE id > 0 AND `type` IN ('user','userfolder') ORDER BY `name` ASC
Parameters:
[] |
| 123 | 0.25 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "userfolder" 30 ] |
| 124 | 0.17 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "userfolder" 27 ] |
| 125 | 0.14 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 31 ] |
| 126 | 0.14 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
31
]
|
| 127 | 0.13 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
31
]
|
| 128 | 0.12 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
31
]
|
| 129 | 0.71 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 33 ] |
| 130 | 0.14 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
33
]
|
| 131 | 0.12 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
33
]
|
| 132 | 0.13 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
33
]
|
| 133 | 0.21 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "userfolder" 10 ] |
| 134 | 0.20 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 9 ] |
| 135 | 0.17 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
9
]
|
| 136 | 0.17 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
9
]
|
| 137 | 0.19 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
9
]
|
| 138 | 0.19 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "userfolder" 2 ] |
| 139 | 0.20 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 4 ] |
| 140 | 0.17 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
4
]
|
| 141 | 0.18 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
4
]
|
| 142 | 0.19 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
4
]
|
| 143 | 0.20 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 3 ] |
| 144 | 0.17 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
3
]
|
| 145 | 0.16 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
3
]
|
| 146 | 0.18 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
3
]
|
| 147 | 0.20 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "userfolder" 29 ] |
| 148 | 0.19 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 11 ] |
| 149 | 0.17 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
11
]
|
| 150 | 0.16 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
11
]
|
| 151 | 0.17 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
11
]
|
| 152 | 0.19 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 32 ] |
| 153 | 0.16 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
32
]
|
| 154 | 0.16 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
32
]
|
| 155 | 0.17 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
32
]
|
| 156 | 0.19 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 12 ] |
| 157 | 0.16 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
12
]
|
| 158 | 0.68 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
12
]
|
| 159 | 0.17 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
12
]
|
| 160 | 0.20 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 14 ] |
| 161 | 0.17 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
14
]
|
| 162 | 0.17 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
14
]
|
| 163 | 0.19 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
14
]
|
| 164 | 0.19 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "userfolder" 28 ] |
| 165 | 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:
[ 1793189634 "system_supported_locales_en" ] |
| 166 | 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:
[ 1793189634 "system_supported_locales_en" ] |
| 167 | 0.28 ms |
select documents.id, concat(documents.path, documents.`key`) as fullPath from documents, documents_page, sites where sites.rootId = documents_page.id and documents.id = documents_page.id and documents_page.controller = ?
Parameters:
[
"Pimcore\Bundle\PortalEngineBundle\Controller\PortalController::pageAction"
]
|
| 168 | 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:
[ 1793189634 "document_203" ] |
| 169 | 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:
[ 1793189634 "document_203\x01tags\x01" "asset_320\x01tags\x01" "asset_368\x01tags\x01" "asset_367\x01tags\x01" ] |
| 170 | 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:
[ 1793189634 "document_227" ] |
| 171 | 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:
[ 1793189634 "document_227\x01tags\x01" "asset_502\x01tags\x01" "asset_456\x01tags\x01" ] |
| 172 | 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:
[ 1793189634 "document_236" ] |
| 173 | 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:
[ 1793189634 "document_236\x01tags\x01" "asset_457\x01tags\x01" "asset_456\x01tags\x01" ] |
| 174 | 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:
[ 1793189634 "document_247" ] |
| 175 | 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:
[ 1793189634 "document_247\x01tags\x01" "asset_457\x01tags\x01" "asset_456\x01tags\x01" ] |
| 176 | 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:
[ 1793189634 "document_258" ] |
| 177 | 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:
[ 1793189634 "document_258\x01tags\x01" "asset_457\x01tags\x01" "asset_456\x01tags\x01" ] |
| 178 | 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:
[ 1793189634 "document_269" ] |
| 179 | 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:
[ 1793189634 "document_269\x01tags\x01" "asset_457\x01tags\x01" "asset_456\x01tags\x01" ] |
| 180 | 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:
[ 1793189634 "document_280" ] |
| 181 | 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:
[ 1793189634 "document_280\x01tags\x01" "asset_457\x01tags\x01" "asset_456\x01tags\x01" ] |
| 182 | 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:
[ 1793189634 "document_291" ] |
| 183 | 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:
[ 1793189634 "document_291\x01tags\x01" "asset_457\x01tags\x01" "asset_456\x01tags\x01" ] |
| 184 | 0.20 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
203
]
|
| 185 | 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:
[ 1793189634 "document_207" ] |
| 186 | 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:
[ 1793189634 "document_207\x01tags\x01" ] |
| 187 | 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:
[ 1793189634 "document_208" ] |
| 188 | 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:
[ 1793189634 "document_208\x01tags\x01" ] |
| 189 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
203
]
|
| 190 | 0.38 ms |
select d.id from (select * from documents where `path` like ? and `published` = 1) as d join (select * from documents_page where `controller` = ? or `controller` = ? ) as p on d.id = p.id
Parameters:
[ "/Classic Cars Portal/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 191 | 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:
[ 1793189634 "document_212" ] |
| 192 | 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:
[ 1793189634 "document_212\x01tags\x01" ] |
| 193 | 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:
[ 1793189634 "document_214" ] |
| 194 | 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:
[ 1793189634 "document_214\x01tags\x01" ] |
| 195 | 0.59 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:
[ 1793189634 "document_218" ] |
| 196 | 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:
[ 1793189634 "document_218\x01tags\x01" ] |
| 197 | 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:
[ 1793189634 "document_216" ] |
| 198 | 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:
[ 1793189634 "document_216\x01tags\x01" ] |
| 199 | 0.21 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
214
]
|
| 200 | 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:
[ 1793189634 "object_744" ] |
| 201 | 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:
[ 1793189634 "object_744\x01tags\x01" ] |
| 202 | 0.19 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
218
]
|
| 203 | 0.19 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
216
]
|
| 204 | 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:
[ 1793189634 "document_properties_212" ] |
| 205 | 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:
[ 1793189634 "document_properties\x01tags\x01" "document_212\x01tags\x01" ] |
| 206 | 0.21 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
212
]
|
| 207 | 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:
[ 1793189634 "asset_409" ] |
| 208 | 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:
[ 1793189634 "asset_409\x01tags\x01" ] |
| 209 | 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:
[ 1793189634 "asset_288" ] |
| 210 | 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:
[ 1793189634 "asset_288\x01tags\x01" ] |
| 211 | 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:
[ 1793189634 "asset_355" ] |
| 212 | 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:
[ 1793189634 "asset_355\x01tags\x01" ] |
| 213 | 0.17 ms |
SELECT * FROM translations_portal_engine_frontend LIMIT 1;
Parameters:
[] |
| 214 | 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:
[ 1793189634 "translation_data_261908ff69ba47343efb67cc61df1a24" ] |
| 215 | 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:
[ 1793189634 "document_properties_214" ] |
| 216 | 0.22 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "CP" "pimcore_object_custom_layout" ] |
| 217 | 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:
[ 1793189634 "document_properties_218" ] |
| 218 | 0.22 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "EP" "pimcore_object_custom_layout" ] |
| 219 | 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:
[ 1793189634 "document_properties_216" ] |
| 220 | 0.17 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "MP" "pimcore_object_custom_layout" ] |
| 221 | 0.23 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
227
]
|
| 222 | 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:
[ 1793189634 "document_231" ] |
| 223 | 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:
[ 1793189634 "document_231\x01tags\x01" ] |
| 224 | 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:
[ 1793189634 "document_232" ] |
| 225 | 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:
[ 1793189634 "document_232\x01tags\x01" ] |
| 226 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
227
]
|
| 227 | 0.36 ms |
select d.id from (select * from documents where `path` like ? and `published` = 1) as d join (select * from documents_page where `controller` = ? or `controller` = ? ) as p on d.id = p.id
Parameters:
[ "/Asset Portal/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 228 | 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:
[ 1793189634 "document_301" ] |
| 229 | 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:
[ 1793189634 "document_301\x01tags\x01" ] |
| 230 | 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:
[ 1793189634 "document_300" ] |
| 231 | 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:
[ 1793189634 "document_300\x01tags\x01" ] |
| 232 | 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:
[ 1793189634 "document_properties_301" ] |
| 233 | 0.20 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
301
]
|
| 234 | 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:
[ 1793189634 "asset_447" ] |
| 235 | 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:
[ 1793189634 "asset_447\x01tags\x01" ] |
| 236 | 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:
[ 1793189634 "asset_433" ] |
| 237 | 0.54 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:
[ 1793189634 "asset_433\x01tags\x01" ] |
| 238 | 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:
[ 1793189634 "document_properties_300" ] |
| 239 | 0.21 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
300
]
|
| 240 | 0.21 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
236
]
|
| 241 | 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:
[ 1793189634 "document_240" ] |
| 242 | 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:
[ 1793189634 "document_240\x01tags\x01" ] |
| 243 | 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:
[ 1793189634 "document_241" ] |
| 244 | 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:
[ 1793189634 "document_241\x01tags\x01" ] |
| 245 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
236
]
|
| 246 | 0.38 ms |
select d.id from (select * from documents where `path` like ? and `published` = 1) as d join (select * from documents_page where `controller` = ? or `controller` = ? ) as p on d.id = p.id
Parameters:
[ "/Asset Portal_1/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 247 | 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:
[ 1793189634 "document_245" ] |
| 248 | 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:
[ 1793189634 "document_245\x01tags\x01" ] |
| 249 | 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:
[ 1793189634 "document_properties_245" ] |
| 250 | 0.18 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
245
]
|
| 251 | 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:
[ 1793189634 "asset_1" ] |
| 252 | 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:
[ 1793189634 "asset_1\x01tags\x01" ] |
| 253 | 0.21 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
247
]
|
| 254 | 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:
[ 1793189634 "document_251" ] |
| 255 | 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:
[ 1793189634 "document_251\x01tags\x01" ] |
| 256 | 0.48 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:
[ 1793189634 "document_252" ] |
| 257 | 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:
[ 1793189634 "document_252\x01tags\x01" ] |
| 258 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
247
]
|
| 259 | 0.37 ms |
select d.id from (select * from documents where `path` like ? and `published` = 1) as d join (select * from documents_page where `controller` = ? or `controller` = ? ) as p on d.id = p.id
Parameters:
[ "/Asset Portal_2/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 260 | 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:
[ 1793189634 "document_256" ] |
| 261 | 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:
[ 1793189634 "document_256\x01tags\x01" ] |
| 262 | 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:
[ 1793189634 "document_properties_256" ] |
| 263 | 0.19 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
256
]
|
| 264 | 0.21 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
258
]
|
| 265 | 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:
[ 1793189634 "document_262" ] |
| 266 | 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:
[ 1793189634 "document_262\x01tags\x01" ] |
| 267 | 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:
[ 1793189634 "document_263" ] |
| 268 | 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:
[ 1793189634 "document_263\x01tags\x01" ] |
| 269 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
258
]
|
| 270 | 0.36 ms |
select d.id from (select * from documents where `path` like ? and `published` = 1) as d join (select * from documents_page where `controller` = ? or `controller` = ? ) as p on d.id = p.id
Parameters:
[ "/Asset Portal_3/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 271 | 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:
[ 1793189634 "document_267" ] |
| 272 | 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:
[ 1793189634 "document_267\x01tags\x01" ] |
| 273 | 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:
[ 1793189634 "document_properties_267" ] |
| 274 | 0.18 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
267
]
|
| 275 | 0.77 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
269
]
|
| 276 | 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:
[ 1793189634 "document_273" ] |
| 277 | 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:
[ 1793189634 "document_273\x01tags\x01" ] |
| 278 | 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:
[ 1793189634 "document_274" ] |
| 279 | 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:
[ 1793189634 "document_274\x01tags\x01" ] |
| 280 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
269
]
|
| 281 | 0.35 ms |
select d.id from (select * from documents where `path` like ? and `published` = 1) as d join (select * from documents_page where `controller` = ? or `controller` = ? ) as p on d.id = p.id
Parameters:
[ "/Asset Portal_4/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 282 | 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:
[ 1793189634 "document_278" ] |
| 283 | 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:
[ 1793189634 "document_278\x01tags\x01" ] |
| 284 | 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:
[ 1793189634 "document_properties_278" ] |
| 285 | 0.17 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
278
]
|
| 286 | 0.20 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
280
]
|
| 287 | 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:
[ 1793189634 "document_284" ] |
| 288 | 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:
[ 1793189634 "document_284\x01tags\x01" ] |
| 289 | 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:
[ 1793189634 "document_285" ] |
| 290 | 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:
[ 1793189634 "document_285\x01tags\x01" ] |
| 291 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
280
]
|
| 292 | 0.34 ms |
select d.id from (select * from documents where `path` like ? and `published` = 1) as d join (select * from documents_page where `controller` = ? or `controller` = ? ) as p on d.id = p.id
Parameters:
[ "/Asset Portal_5/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 293 | 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:
[ 1793189634 "document_289" ] |
| 294 | 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:
[ 1793189634 "document_289\x01tags\x01" ] |
| 295 | 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:
[ 1793189634 "document_properties_289" ] |
| 296 | 0.68 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
289
]
|
| 297 | 0.20 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
291
]
|
| 298 | 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:
[ 1793189634 "document_295" ] |
| 299 | 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:
[ 1793189634 "document_295\x01tags\x01" ] |
| 300 | 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:
[ 1793189634 "document_296" ] |
| 301 | 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:
[ 1793189634 "document_296\x01tags\x01" ] |
| 302 | 0.15 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
291
]
|
| 303 | 0.33 ms |
select d.id from (select * from documents where `path` like ? and `published` = 1) as d join (select * from documents_page where `controller` = ? or `controller` = ? ) as p on d.id = p.id
Parameters:
[ "/Asset Portal_6/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 304 | 0.24 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:
[ 1793189634 "system_supported_locales_en" ] |
| 305 | 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:
[ 1793189634 "system_supported_locales_en" ] |
| 306 | 0.25 ms |
select documents.id, concat(documents.path, documents.`key`) as fullPath from documents, documents_page, sites where sites.rootId = documents_page.id and documents.id = documents_page.id and documents_page.controller = ?
Parameters:
[
"Pimcore\Bundle\PortalEngineBundle\Controller\PortalController::pageAction"
]
|
| 307 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
203
]
|
| 308 | 0.18 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
227
]
|
| 309 | 0.18 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
236
]
|
| 310 | 0.17 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
247
]
|
| 311 | 0.17 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
258
]
|
| 312 | 0.18 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
269
]
|
| 313 | 0.17 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
280
]
|
| 314 | 0.17 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
291
]
|
| 315 | 0.24 ms |
SELECT * FROM object_collection_Condition_14 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 1241 "conditions" ] |
| 316 | 0.17 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 317 | 0.43 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemCode' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 318 | 0.53 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:
[ 1793189634 "object_1255" ] |
| 319 | 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:
[ 1793189634 "object_1255\x01tags\x01" "class_14\x01tags\x01" ] |
| 320 | 0.20 ms |
SELECT * FROM object_collection_Condition_14 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 1255 "conditions" ] |
| 321 | 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:
[ 1793189634 "object_1251" ] |
| 322 | 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:
[ 1793189634 "object_1251\x01tags\x01" "class_17\x01tags\x01" ] |
| 323 | 0.16 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 324 | 0.38 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemDescription' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 325 | 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:
[ 1793189634 "object_1256" ] |
| 326 | 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:
[ 1793189634 "object_1256\x01tags\x01" "class_14\x01tags\x01" ] |
| 327 | 0.20 ms |
SELECT * FROM object_collection_Condition_14 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 1256 "conditions" ] |
| 328 | 0.35 ms |
SELECT object_20.id as id, object_20.type as `type` FROM object_20 WHERE object_20.type IN ('object','variant','folder')
Parameters:
[] |
| 329 | 0.35 ms |
SELECT object_20.id as id, object_20.type as `type` FROM object_20 WHERE object_20.type IN ('object','variant','folder')
Parameters:
[] |
| 330 | 0.21 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 331 | 0.41 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemName' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 332 | 0.17 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 333 | 0.36 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemName' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 334 | 0.16 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 335 | 0.35 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemCode' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 336 | 0.17 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 337 | 0.37 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemCode' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 338 | 0.16 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 339 | 0.34 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemDescription' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 340 | 0.62 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"AHEProduct"
]
|
| 341 | 0.35 ms |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE attribute = 'systemDescription' AND classes = '6' AND active = 1 AND (category IS NULL OR category = '') AND object_14.type IN ('object','variant','folder')
Parameters:
[] |
| 342 | 0.33 ms |
SELECT object_20.id as id, object_20.type as `type` FROM object_20 WHERE object_20.type IN ('object','variant','folder')
Parameters:
[] |
| 343 | 0.34 ms |
SELECT object_20.id as id, object_20.type as `type` FROM object_20 WHERE object_20.type IN ('object','variant','folder')
Parameters:
[] |
| 344 | 0.33 ms |
SELECT object_20.id as id, object_20.type as `type` FROM object_20 WHERE object_20.type IN ('object','variant','folder')
Parameters:
[] |
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.