Query Metrics
449
Database Queries
46
Different statements
103.80 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.39 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 2 | 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:
[ 1789054038 "app:775ae8d4f3ce5b9320a87413f7344263aeb2f23a" ] |
| 3 | 0.93 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "app:775ae8d4f3ce5b9320a87413f7344263aeb2f23a" ] |
| 4 | 5.34 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 => 97 3 => 1789054038 0 => "app:775ae8d4f3ce5b9320a87413f7344263aeb2f23a" 1 => b"O:1:"©":1:{s:6:"0)e\x08À\x1E";O:50:"Symfony\Component\RateLimiter\Policy\SlidingWindow":1:{s:45:"\x00\x00\x00\e\x00\x00\x002\x00\x00\x00<studio_api_general-136.226.250.90";d:1789054075.438976;}}" ] |
| 5 | 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:
[ 1789054038 "maintenance_mode" ] |
| 6 | 0.49 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
| 7 | 0.29 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
| 8 | 0.22 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
| 9 | 0.17 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
| 10 | 0.37 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "object_2074" ] |
| 11 | 0.32 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1789054038 "object_2074\x01tags\x01" "class_31\x01tags\x01" ] |
| 12 | 0.21 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"31"
]
|
| 13 | 0.45 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:
[] |
| 14 | 0.21 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"Car"
]
|
| 15 | 0.19 ms |
SELECT `id`, `name` FROM classes WHERE name = ?
Parameters:
[
"MasterProduct"
]
|
| 16 | 0.33 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 17 | 0.77 ms |
SELECT object_localized_Region_en.id as id, object_localized_Region_en.type as `type` FROM object_localized_Region_en WHERE object_localized_Region_en.type IN ('object','variant','folder')
Parameters:
[] |
| 18 | 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:
[ 1789054038 "object_1633" ] |
| 19 | 0.17 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"Region"
]
|
| 20 | 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:
[ 1789054038 "object_1633\x01tags\x01" "class_Region\x01tags\x01" ] |
| 21 | 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:
[ 1789054038 "object_1634" ] |
| 22 | 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:
[ 1789054038 "object_1634\x01tags\x01" "class_Region\x01tags\x01" ] |
| 23 | 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:
[ 1789054038 "object_1635" ] |
| 24 | 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:
[ 1789054038 "object_1635\x01tags\x01" "class_Region\x01tags\x01" ] |
| 25 | 0.73 ms |
SELECT object_localized_Country_en.id as id, object_localized_Country_en.type as `type` FROM object_localized_Country_en WHERE object_localized_Country_en.type IN ('object','variant','folder') ORDER BY `name` ASC
Parameters:
[] |
| 26 | 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:
[ 1789054038 "object_1637" ] |
| 27 | 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:
[ 1789054038 "object_1637\x01tags\x01" "class_Country\x01tags\x01" ] |
| 28 | 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:
[ 1789054038 "object_1638" ] |
| 29 | 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:
[ 1789054038 "object_1638\x01tags\x01" "class_Country\x01tags\x01" ] |
| 30 | 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:
[ 1789054038 "object_1639" ] |
| 31 | 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:
[ 1789054038 "object_1639\x01tags\x01" "class_Country\x01tags\x01" ] |
| 32 | 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:
[ 1789054038 "object_1640" ] |
| 33 | 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:
[ 1789054038 "object_1640\x01tags\x01" "class_Country\x01tags\x01" ] |
| 34 | 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:
[ 1789054038 "object_1641" ] |
| 35 | 0.66 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1789054038 "object_1641\x01tags\x01" "class_Country\x01tags\x01" ] |
| 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:
[ 1789054038 "object_1642" ] |
| 37 | 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:
[ 1789054038 "object_1642\x01tags\x01" "class_Country\x01tags\x01" ] |
| 38 | 0.56 ms |
SELECT object_localized_MaterialGroup_en.id as id, object_localized_MaterialGroup_en.type as `type` FROM object_localized_MaterialGroup_en WHERE object_localized_MaterialGroup_en.type IN ('object','variant','folder')
Parameters:
[] |
| 39 | 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:
[ 1789054038 "object_1671" ] |
| 40 | 0.18 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"MaterialGroup"
]
|
| 41 | 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:
[ 1789054038 "object_1671\x01tags\x01" "class_MaterialGroup\x01tags\x01" ] |
| 42 | 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:
[ 1789054038 "object_1672" ] |
| 43 | 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:
[ 1789054038 "object_1672\x01tags\x01" "class_MaterialGroup\x01tags\x01" ] |
| 44 | 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:
[ 1789054038 "object_1673" ] |
| 45 | 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:
[ 1789054038 "object_1673\x01tags\x01" "class_MaterialGroup\x01tags\x01" ] |
| 46 | 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:
[ 1789054038 "object_1674" ] |
| 47 | 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:
[ 1789054038 "object_1674\x01tags\x01" "class_MaterialGroup\x01tags\x01" ] |
| 48 | 0.51 ms |
SELECT object_localized_MaterialType_en.id as id, object_localized_MaterialType_en.type as `type` FROM object_localized_MaterialType_en WHERE object_localized_MaterialType_en.type IN ('object','variant','folder')
Parameters:
[] |
| 49 | 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:
[ 1789054038 "object_1686" ] |
| 50 | 0.15 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"MaterialType"
]
|
| 51 | 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:
[ 1789054038 "object_1686\x01tags\x01" "class_MaterialType\x01tags\x01" ] |
| 52 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "object_1687" ] |
| 53 | 0.19 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1789054038 "object_1687\x01tags\x01" "class_MaterialType\x01tags\x01" ] |
| 54 | 0.61 ms |
SELECT object_localized_LicensingOption_en.id as id, object_localized_LicensingOption_en.type as `type` FROM object_localized_LicensingOption_en WHERE object_localized_LicensingOption_en.type IN ('object','variant','folder')
Parameters:
[] |
| 55 | 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:
[ 1789054038 "object_1714" ] |
| 56 | 0.14 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"LicensingOption"
]
|
| 57 | 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:
[ 1789054038 "object_1714\x01tags\x01" "class_LicensingOption\x01tags\x01" ] |
| 58 | 0.48 ms |
SELECT object_localized_SoftwareLicenseType_en.id as id, object_localized_SoftwareLicenseType_en.type as `type` FROM object_localized_SoftwareLicenseType_en WHERE object_localized_SoftwareLicenseType_en.type IN ('object','variant','folder')
Parameters:
[] |
| 59 | 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:
[ 1789054038 "object_1697" ] |
| 60 | 0.14 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"SoftwareLicenseType"
]
|
| 61 | 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:
[ 1789054038 "object_1697\x01tags\x01" "class_SoftwareLicenseType\x01tags\x01" ] |
| 62 | 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:
[ 1789054038 "object_1698" ] |
| 63 | 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:
[ 1789054038 "object_1698\x01tags\x01" "class_SoftwareLicenseType\x01tags\x01" ] |
| 64 | 0.41 ms |
SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE object_39.type IN ('object','variant','folder')
Parameters:
[] |
| 65 | 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:
[ 1789054038 "object_1374" ] |
| 66 | 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:
[ 1789054038 "object_1374\x01tags\x01" "class_39\x01tags\x01" ] |
| 67 | 0.17 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "object_2378" ] |
| 68 | 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:
[ 1789054038 "object_2378\x01tags\x01" "class_39\x01tags\x01" ] |
| 69 | 0.27 ms |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
| 70 | 0.33 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "translation_data_2e364d315ad5ad984609e7f4beedf0f7" ] |
| 71 | 0.23 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1789054038 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01" ] |
| 72 | 0.29 ms |
SELECT * FROM classificationstore_groups WHERE (storeId = 2) ORDER BY `name` ASC
Parameters:
[] |
| 73 | 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:
[ 1789054038 "system_supported_locales_en" ] |
| 74 | 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:
[ 1789054038 "system\x01tags\x01" ] |
| 75 | 0.26 ms |
SELECT id FROM targeting_target_groups ORDER BY `name` ASC
Parameters:
[] |
| 76 | 0.18 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
5
]
|
| 77 | 0.14 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
4
]
|
| 78 | 0.13 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
1
]
|
| 79 | 0.12 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
2
]
|
| 80 | 0.12 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
6
]
|
| 81 | 0.12 ms |
SELECT * FROM targeting_target_groups WHERE id = ?
Parameters:
[
3
]
|
| 82 | 0.77 ms |
SELECT object_localized_ValuationClass_en.id as id, object_localized_ValuationClass_en.type as `type` FROM object_localized_ValuationClass_en WHERE object_localized_ValuationClass_en.type IN ('object','variant','folder')
Parameters:
[] |
| 83 | 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:
[ 1789054038 "object_1703" ] |
| 84 | 0.19 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"ValuationClass"
]
|
| 85 | 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:
[ 1789054038 "object_1703\x01tags\x01" "class_ValuationClass\x01tags\x01" ] |
| 86 | 1.03 ms |
SELECT object_localized_MrpType_en.id as id, object_localized_MrpType_en.type as `type` FROM object_localized_MrpType_en WHERE object_localized_MrpType_en.type IN ('object','variant','folder')
Parameters:
[] |
| 87 | 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:
[ 1789054038 "object_1688" ] |
| 88 | 0.14 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"MrpType"
]
|
| 89 | 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:
[ 1789054038 "object_1688\x01tags\x01" "class_MrpType\x01tags\x01" ] |
| 90 | 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:
[ 1789054038 "object_1689" ] |
| 91 | 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:
[ 1789054038 "object_1689\x01tags\x01" "class_MrpType\x01tags\x01" ] |
| 92 | 0.55 ms |
SELECT object_localized_AccountAssignmentGroup_en.id as id, object_localized_AccountAssignmentGroup_en.type as `type` FROM object_localized_AccountAssignmentGroup_en WHERE object_localized_AccountAssignmentGroup_en.type IN ('object','variant','folder')
Parameters:
[] |
| 93 | 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:
[ 1789054038 "object_1647" ] |
| 94 | 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:
[ 1789054038 "object_1647\x01tags\x01" "class_AccountAssignmentGroup\x01tags\x01" ] |
| 95 | 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:
[ 1789054038 "object_1648" ] |
| 96 | 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:
[ 1789054038 "object_1648\x01tags\x01" "class_AccountAssignmentGroup\x01tags\x01" ] |
| 97 | 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:
[ 1789054038 "object_1649" ] |
| 98 | 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:
[ 1789054038 "object_1649\x01tags\x01" "class_AccountAssignmentGroup\x01tags\x01" ] |
| 99 | 0.50 ms |
SELECT object_localized_ItemCategoryGroup_en.id as id, object_localized_ItemCategoryGroup_en.type as `type` FROM object_localized_ItemCategoryGroup_en WHERE object_localized_ItemCategoryGroup_en.type IN ('object','variant','folder')
Parameters:
[] |
| 100 | 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:
[ 1789054038 "object_1662" ] |
| 101 | 0.64 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"ItemCategoryGroup"
]
|
| 102 | 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:
[ 1789054038 "object_1662\x01tags\x01" "class_ItemCategoryGroup\x01tags\x01" ] |
| 103 | 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:
[ 1789054038 "object_1663" ] |
| 104 | 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:
[ 1789054038 "object_1663\x01tags\x01" "class_ItemCategoryGroup\x01tags\x01" ] |
| 105 | 0.53 ms |
SELECT object_localized_MaterialPricingGroup_en.id as id, object_localized_MaterialPricingGroup_en.type as `type` FROM object_localized_MaterialPricingGroup_en WHERE object_localized_MaterialPricingGroup_en.type IN ('object','variant','folder')
Parameters:
[] |
| 106 | 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:
[ 1789054038 "object_1676" ] |
| 107 | 0.14 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"MaterialPricingGroup"
]
|
| 108 | 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:
[ 1789054038 "object_1676\x01tags\x01" "class_MaterialPricingGroup\x01tags\x01" ] |
| 109 | 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:
[ 1789054038 "object_1677" ] |
| 110 | 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:
[ 1789054038 "object_1677\x01tags\x01" "class_MaterialPricingGroup\x01tags\x01" ] |
| 111 | 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:
[ 1789054038 "object_1678" ] |
| 112 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1789054038 "object_1678\x01tags\x01" "class_MaterialPricingGroup\x01tags\x01" ] |
| 113 | 0.48 ms |
SELECT object_localized_ProductHierarchy_en.id as id, object_localized_ProductHierarchy_en.type as `type` FROM object_localized_ProductHierarchy_en WHERE object_localized_ProductHierarchy_en.type IN ('object','variant','folder')
Parameters:
[] |
| 114 | 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:
[ 1789054038 "object_1692" ] |
| 115 | 0.14 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"ProductHierarchy"
]
|
| 116 | 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:
[ 1789054038 "object_1692\x01tags\x01" "class_ProductHierarchy\x01tags\x01" ] |
| 117 | 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:
[ 1789054038 "object_1693" ] |
| 118 | 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:
[ 1789054038 "object_1693\x01tags\x01" "class_ProductHierarchy\x01tags\x01" ] |
| 119 | 0.72 ms |
SELECT object_localized_TaxMaterialGroup_en.id as id, object_localized_TaxMaterialGroup_en.type as `type` FROM object_localized_TaxMaterialGroup_en WHERE object_localized_TaxMaterialGroup_en.type IN ('object','variant','folder')
Parameters:
[] |
| 120 | 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:
[ 1789054038 "object_1699" ] |
| 121 | 0.14 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"TaxMaterialGroup"
]
|
| 122 | 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:
[ 1789054038 "object_1699\x01tags\x01" "class_TaxMaterialGroup\x01tags\x01" ] |
| 123 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "object_1700" ] |
| 124 | 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:
[ 1789054038 "object_1700\x01tags\x01" "class_TaxMaterialGroup\x01tags\x01" ] |
| 125 | 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:
[ 1789054038 "object_1701" ] |
| 126 | 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:
[ 1789054038 "object_1701\x01tags\x01" "class_TaxMaterialGroup\x01tags\x01" ] |
| 127 | 0.39 ms |
SELECT id,type FROM users WHERE id > 0 AND `type` IN ('user','userfolder') ORDER BY `name` ASC
Parameters:
[] |
| 128 | 0.26 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "userfolder" 39 ] |
| 129 | 0.19 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 40 ] |
| 130 | 0.72 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
40
]
|
| 131 | 0.20 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
40
]
|
| 132 | 0.17 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
40
]
|
| 133 | 0.17 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 42 ] |
| 134 | 0.17 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
42
]
|
| 135 | 0.16 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
42
]
|
| 136 | 0.16 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
42
]
|
| 137 | 0.16 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 41 ] |
| 138 | 0.16 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
41
]
|
| 139 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
41
]
|
| 140 | 0.14 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
41
]
|
| 141 | 0.16 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 19 ] |
| 142 | 0.15 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
19
]
|
| 143 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
19
]
|
| 144 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
19
]
|
| 145 | 0.18 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 6 ] |
| 146 | 0.17 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
6
]
|
| 147 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
6
]
|
| 148 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
6
]
|
| 149 | 0.17 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 4 ] |
| 150 | 0.15 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
4
]
|
| 151 | 0.17 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
4
]
|
| 152 | 0.16 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
4
]
|
| 153 | 0.21 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 17 ] |
| 154 | 0.17 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
17
]
|
| 155 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
17
]
|
| 156 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
17
]
|
| 157 | 0.17 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 16 ] |
| 158 | 0.16 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
16
]
|
| 159 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
16
]
|
| 160 | 0.14 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
16
]
|
| 161 | 0.16 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 30 ] |
| 162 | 0.15 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
30
]
|
| 163 | 0.14 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
30
]
|
| 164 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
30
]
|
| 165 | 0.16 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 18 ] |
| 166 | 0.15 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
18
]
|
| 167 | 0.65 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
18
]
|
| 168 | 0.16 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
18
]
|
| 169 | 0.17 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 15 ] |
| 170 | 0.16 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
15
]
|
| 171 | 0.14 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
15
]
|
| 172 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
15
]
|
| 173 | 0.16 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 31 ] |
| 174 | 0.15 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
31
]
|
| 175 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
31
]
|
| 176 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
31
]
|
| 177 | 0.17 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 13 ] |
| 178 | 0.18 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
13
]
|
| 179 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
13
]
|
| 180 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
13
]
|
| 181 | 0.16 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 32 ] |
| 182 | 0.15 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
32
]
|
| 183 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
32
]
|
| 184 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
32
]
|
| 185 | 0.16 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 33 ] |
| 186 | 0.15 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
33
]
|
| 187 | 0.15 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
33
]
|
| 188 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
33
]
|
| 189 | 0.16 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 14 ] |
| 190 | 0.16 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
14
]
|
| 191 | 0.16 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
14
]
|
| 192 | 0.15 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
14
]
|
| 193 | 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:
[ 1789054038 "system_supported_locales_en" ] |
| 194 | 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:
[ 1789054038 "system_supported_locales_en" ] |
| 195 | 0.41 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"
]
|
| 196 | 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:
[ 1789054038 "document_297" ] |
| 197 | 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:
[ 1789054038 "document_297\x01tags\x01" "asset_429\x01tags\x01" "asset_701\x01tags\x01" "asset_703\x01tags\x01" "asset_426\x01tags\x01" ] |
| 198 | 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:
[ 1789054038 "document_315" ] |
| 199 | 0.23 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1789054038 "document_315\x01tags\x01" "asset_318\x01tags\x01" "asset_526\x01tags\x01" ] |
| 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:
[ 1789054038 "document_328" ] |
| 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:
[ 1789054038 "document_328\x01tags\x01" "asset_318\x01tags\x01" "asset_526\x01tags\x01" ] |
| 202 | 0.70 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
297
]
|
| 203 | 0.22 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
297
]
|
| 204 | 0.40 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:
[ "/portal/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 205 | 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:
[ 1789054038 "document_342" ] |
| 206 | 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:
[ 1789054038 "document_342\x01tags\x01" ] |
| 207 | 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:
[ 1789054038 "document_343" ] |
| 208 | 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:
[ 1789054038 "document_343\x01tags\x01" ] |
| 209 | 0.30 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
343
]
|
| 210 | 0.46 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "object_1196" ] |
| 211 | 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:
[ 1789054038 "object_1196\x01tags\x01" ] |
| 212 | 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:
[ 1789054038 "document_properties_342" ] |
| 213 | 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:
[ 1789054038 "document_properties\x01tags\x01" "document_342\x01tags\x01" ] |
| 214 | 0.28 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
342
]
|
| 215 | 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:
[ 1789054038 "asset_355" ] |
| 216 | 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:
[ 1789054038 "asset_355\x01tags\x01" ] |
| 217 | 0.22 ms |
SELECT * FROM translations_portal_engine_frontend LIMIT 1;
Parameters:
[] |
| 218 | 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:
[ 1789054038 "translation_data_261908ff69ba47343efb67cc61df1a24" ] |
| 219 | 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:
[ 1789054038 "document_properties_343" ] |
| 220 | 0.31 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "5274340e-6309-4e97-ab94-061b8f808ef8" "pimcore_object_custom_layout" ] |
| 221 | 0.26 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
315
]
|
| 222 | 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:
[ 1789054038 "document_319" ] |
| 223 | 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:
[ 1789054038 "document_319\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:
[ 1789054038 "document_320" ] |
| 225 | 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:
[ 1789054038 "document_320\x01tags\x01" ] |
| 226 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
315
]
|
| 227 | 0.48 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:
[ "/PimcorePortal/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 228 | 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:
[ 1789054038 "document_326" ] |
| 229 | 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:
[ 1789054038 "document_326\x01tags\x01" ] |
| 230 | 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:
[ 1789054038 "document_324" ] |
| 231 | 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:
[ 1789054038 "document_324\x01tags\x01" ] |
| 232 | 0.20 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
324
]
|
| 233 | 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:
[ 1789054038 "object_1" ] |
| 234 | 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:
[ 1789054038 "object_1\x01tags\x01" ] |
| 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:
[ 1789054038 "document_properties_326" ] |
| 236 | 0.22 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
326
]
|
| 237 | 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:
[ 1789054038 "asset_1" ] |
| 238 | 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:
[ 1789054038 "asset_1\x01tags\x01" ] |
| 239 | 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:
[ 1789054038 "document_properties_324" ] |
| 240 | 0.22 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
328
]
|
| 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:
[ 1789054038 "document_332" ] |
| 242 | 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:
[ 1789054038 "document_332\x01tags\x01" ] |
| 243 | 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:
[ 1789054038 "document_333" ] |
| 244 | 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:
[ 1789054038 "document_333\x01tags\x01" ] |
| 245 | 0.19 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
328
]
|
| 246 | 0.47 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:
[ "/PimcorePortal_1/%" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\AssetController::listAction" "Pimcore\Bundle\PortalEngineBundle\Controller\DataPool\DataObjectController::listAction" ] |
| 247 | 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:
[ 1789054038 "document_337" ] |
| 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:
[ 1789054038 "document_337\x01tags\x01" ] |
| 249 | 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:
[ 1789054038 "document_339" ] |
| 250 | 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:
[ 1789054038 "document_339\x01tags\x01" ] |
| 251 | 0.19 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
337
]
|
| 252 | 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:
[ 1789054038 "document_properties_337" ] |
| 253 | 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:
[ 1789054038 "document_properties_339" ] |
| 254 | 0.24 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
339
]
|
| 255 | 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:
[ 1789054038 "system_supported_locales_en" ] |
| 256 | 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:
[ 1789054038 "system_supported_locales_en" ] |
| 257 | 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"
]
|
| 258 | 0.16 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
297
]
|
| 259 | 0.18 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
315
]
|
| 260 | 0.17 ms |
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
328
]
|
| 261 | 0.78 ms |
SELECT object_localized_13_en.id as id, object_localized_13_en.type as `type` FROM object_localized_13_en WHERE object_localized_13_en.type IN ('object','variant','folder')
Parameters:
[] |
| 262 | 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:
[ 1789054038 "object_1225" ] |
| 263 | 0.19 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"13"
]
|
| 264 | 0.23 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1789054038 "object_1225\x01tags\x01" "class_13\x01tags\x01" ] |
| 265 | 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:
[ 1789054038 "object_1474" ] |
| 266 | 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:
[ 1789054038 "object_1474\x01tags\x01" "class_13\x01tags\x01" ] |
| 267 | 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:
[ 1789054038 "object_1476" ] |
| 268 | 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:
[ 1789054038 "object_1476\x01tags\x01" "class_13\x01tags\x01" ] |
| 269 | 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:
[ 1789054038 "object_1477" ] |
| 270 | 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:
[ 1789054038 "object_1477\x01tags\x01" "class_13\x01tags\x01" ] |
| 271 | 0.91 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "object_1482" ] |
| 272 | 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:
[ 1789054038 "object_1482\x01tags\x01" "class_13\x01tags\x01" ] |
| 273 | 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:
[ 1789054038 "object_1483" ] |
| 274 | 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:
[ 1789054038 "object_1483\x01tags\x01" "class_13\x01tags\x01" ] |
| 275 | 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:
[ 1789054038 "object_1489" ] |
| 276 | 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:
[ 1789054038 "object_1489\x01tags\x01" "class_13\x01tags\x01" ] |
| 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:
[ 1789054038 "object_1535" ] |
| 278 | 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:
[ 1789054038 "object_1535\x01tags\x01" "class_13\x01tags\x01" ] |
| 279 | 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:
[ 1789054038 "object_1540" ] |
| 280 | 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:
[ 1789054038 "object_1540\x01tags\x01" "class_13\x01tags\x01" ] |
| 281 | 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:
[ 1789054038 "object_1549" ] |
| 282 | 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:
[ 1789054038 "object_1549\x01tags\x01" "class_13\x01tags\x01" ] |
| 283 | 0.54 ms |
SELECT object_localized_16_en.id as id, object_localized_16_en.type as `type` FROM object_localized_16_en WHERE object_localized_16_en.type IN ('object','variant','folder')
Parameters:
[] |
| 284 | 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:
[ 1789054038 "object_1232" ] |
| 285 | 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:
[ 1789054038 "object_1232\x01tags\x01" "class_16\x01tags\x01" ] |
| 286 | 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:
[ 1789054038 "object_1234" ] |
| 287 | 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:
[ 1789054038 "object_1234\x01tags\x01" "class_16\x01tags\x01" ] |
| 288 | 0.53 ms |
SELECT object_localized_19_en.id as id, object_localized_19_en.type as `type` FROM object_localized_19_en WHERE object_localized_19_en.type IN ('object','variant','folder')
Parameters:
[] |
| 289 | 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:
[ 1789054038 "object_1251" ] |
| 290 | 0.15 ms |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"19"
]
|
| 291 | 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:
[ 1789054038 "object_1251\x01tags\x01" "class_19\x01tags\x01" ] |
| 292 | 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:
[ 1789054038 "object_1290" ] |
| 293 | 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:
[ 1789054038 "object_1290\x01tags\x01" "class_19\x01tags\x01" ] |
| 294 | 0.56 ms |
SELECT object_localized_17_en.id as id, object_localized_17_en.type as `type` FROM object_localized_17_en WHERE object_localized_17_en.type IN ('object','variant','folder')
Parameters:
[] |
| 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:
[ 1789054038 "object_1235" ] |
| 296 | 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:
[ 1789054038 "object_1235\x01tags\x01" "class_17\x01tags\x01" ] |
| 297 | 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:
[ 1789054038 "object_1481" ] |
| 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:
[ 1789054038 "object_1481\x01tags\x01" "class_17\x01tags\x01" ] |
| 299 | 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:
[ 1789054038 "object_1486" ] |
| 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:
[ 1789054038 "object_1486\x01tags\x01" "class_17\x01tags\x01" ] |
| 301 | 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:
[ 1789054038 "object_1494" ] |
| 302 | 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:
[ 1789054038 "object_1494\x01tags\x01" "class_17\x01tags\x01" ] |
| 303 | 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:
[ 1789054038 "object_1566" ] |
| 304 | 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:
[ 1789054038 "object_1566\x01tags\x01" "class_17\x01tags\x01" ] |
| 305 | 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:
[ 1789054038 "object_1568" ] |
| 306 | 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:
[ 1789054038 "object_1568\x01tags\x01" "class_17\x01tags\x01" ] |
| 307 | 0.59 ms |
SELECT object_localized_21_en.id as id, object_localized_21_en.type as `type` FROM object_localized_21_en WHERE object_localized_21_en.type IN ('object','variant','folder')
Parameters:
[] |
| 308 | 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:
[ 1789054038 "object_1257" ] |
| 309 | 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:
[ 1789054038 "object_1257\x01tags\x01" "class_21\x01tags\x01" ] |
| 310 | 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:
[ 1789054038 "object_1291" ] |
| 311 | 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:
[ 1789054038 "object_1291\x01tags\x01" "class_21\x01tags\x01" ] |
| 312 | 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:
[ 1789054038 "object_1472" ] |
| 313 | 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:
[ 1789054038 "object_1472\x01tags\x01" "class_21\x01tags\x01" ] |
| 314 | 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:
[ 1789054038 "object_1484" ] |
| 315 | 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:
[ 1789054038 "object_1484\x01tags\x01" "class_21\x01tags\x01" ] |
| 316 | 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:
[ 1789054038 "object_1491" ] |
| 317 | 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:
[ 1789054038 "object_1491\x01tags\x01" "class_21\x01tags\x01" ] |
| 318 | 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:
[ 1789054038 "object_1493" ] |
| 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:
[ 1789054038 "object_1493\x01tags\x01" "class_21\x01tags\x01" ] |
| 320 | 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:
[ 1789054038 "object_1497" ] |
| 321 | 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:
[ 1789054038 "object_1497\x01tags\x01" "class_21\x01tags\x01" ] |
| 322 | 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:
[ 1789054038 "object_1498" ] |
| 323 | 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:
[ 1789054038 "object_1498\x01tags\x01" "class_21\x01tags\x01" ] |
| 324 | 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:
[ 1789054038 "object_1525" ] |
| 325 | 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:
[ 1789054038 "object_1525\x01tags\x01" "class_21\x01tags\x01" ] |
| 326 | 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:
[ 1789054038 "object_1547" ] |
| 327 | 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:
[ 1789054038 "object_1547\x01tags\x01" "class_21\x01tags\x01" ] |
| 328 | 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:
[ 1789054038 "object_1559" ] |
| 329 | 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:
[ 1789054038 "object_1559\x01tags\x01" "class_21\x01tags\x01" ] |
| 330 | 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:
[ 1789054038 "object_1574" ] |
| 331 | 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:
[ 1789054038 "object_1574\x01tags\x01" "class_21\x01tags\x01" ] |
| 332 | 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:
[ 1789054038 "object_1580" ] |
| 333 | 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:
[ 1789054038 "object_1580\x01tags\x01" "class_21\x01tags\x01" ] |
| 334 | 0.31 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Business Dev" ] |
| 335 | 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:
[ 1789054038 "object_1258" ] |
| 336 | 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:
[ 1789054038 "object_1258\x01tags\x01" ] |
| 337 | 0.50 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1258
]
|
| 338 | 0.68 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1789054038 "object_1273" ] |
| 339 | 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:
[ 1789054038 "object_1273\x01tags\x01" "class_22\x01tags\x01" ] |
| 340 | 0.23 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "BD for America" ] |
| 341 | 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:
[ 1789054038 "object_1259" ] |
| 342 | 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:
[ 1789054038 "object_1259\x01tags\x01" ] |
| 343 | 0.40 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1259
]
|
| 344 | 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:
[ 1789054038 "object_1274" ] |
| 345 | 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:
[ 1789054038 "object_1274\x01tags\x01" "class_22\x01tags\x01" ] |
| 346 | 0.21 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "BD for Europe" ] |
| 347 | 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:
[ 1789054038 "object_1261" ] |
| 348 | 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:
[ 1789054038 "object_1261\x01tags\x01" ] |
| 349 | 0.40 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1261
]
|
| 350 | 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:
[ 1789054038 "object_1276" ] |
| 351 | 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:
[ 1789054038 "object_1276\x01tags\x01" "class_22\x01tags\x01" ] |
| 352 | 0.21 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "BD for APAC" ] |
| 353 | 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:
[ 1789054038 "object_1260" ] |
| 354 | 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:
[ 1789054038 "object_1260\x01tags\x01" ] |
| 355 | 0.38 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1260
]
|
| 356 | 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:
[ 1789054038 "object_1275" ] |
| 357 | 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:
[ 1789054038 "object_1275\x01tags\x01" "class_22\x01tags\x01" ] |
| 358 | 0.21 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "BD for Middle East" ] |
| 359 | 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:
[ 1789054038 "object_1262" ] |
| 360 | 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:
[ 1789054038 "object_1262\x01tags\x01" ] |
| 361 | 0.40 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1262
]
|
| 362 | 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:
[ 1789054038 "object_1277" ] |
| 363 | 0.73 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1789054038 "object_1277\x01tags\x01" "class_22\x01tags\x01" ] |
| 364 | 0.24 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Product Manager" ] |
| 365 | 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:
[ 1789054038 "object_1263" ] |
| 366 | 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:
[ 1789054038 "object_1263\x01tags\x01" ] |
| 367 | 0.42 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1263
]
|
| 368 | 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:
[ 1789054038 "object_1278" ] |
| 369 | 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:
[ 1789054038 "object_1278\x01tags\x01" "class_22\x01tags\x01" ] |
| 370 | 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:
[ 1789054038 "object_1500" ] |
| 371 | 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:
[ 1789054038 "object_1500\x01tags\x01" "class_22\x01tags\x01" ] |
| 372 | 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:
[ 1789054038 "object_1530" ] |
| 373 | 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:
[ 1789054038 "object_1530\x01tags\x01" "class_22\x01tags\x01" ] |
| 374 | 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:
[ 1789054038 "object_1567" ] |
| 375 | 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:
[ 1789054038 "object_1567\x01tags\x01" "class_22\x01tags\x01" ] |
| 376 | 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:
[ 1789054038 "object_1583" ] |
| 377 | 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:
[ 1789054038 "object_1583\x01tags\x01" "class_22\x01tags\x01" ] |
| 378 | 0.20 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Process Contact" ] |
| 379 | 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:
[ 1789054038 "object_1265" ] |
| 380 | 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:
[ 1789054038 "object_1265\x01tags\x01" ] |
| 381 | 0.36 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1265
]
|
| 382 | 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:
[ 1789054038 "object_1280" ] |
| 383 | 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:
[ 1789054038 "object_1280\x01tags\x01" "class_22\x01tags\x01" ] |
| 384 | 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:
[ 1789054038 "object_1292" ] |
| 385 | 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:
[ 1789054038 "object_1292\x01tags\x01" "class_22\x01tags\x01" ] |
| 386 | 0.19 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Technical Support" ] |
| 387 | 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:
[ 1789054038 "object_1266" ] |
| 388 | 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:
[ 1789054038 "object_1266\x01tags\x01" ] |
| 389 | 0.29 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1266
]
|
| 390 | 0.16 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Technical for America" ] |
| 391 | 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:
[ 1789054038 "object_1267" ] |
| 392 | 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:
[ 1789054038 "object_1267\x01tags\x01" ] |
| 393 | 0.27 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1267
]
|
| 394 | 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:
[ 1789054038 "object_1281" ] |
| 395 | 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:
[ 1789054038 "object_1281\x01tags\x01" "class_22\x01tags\x01" ] |
| 396 | 0.16 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Marcom Contact" ] |
| 397 | 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:
[ 1789054038 "object_1264" ] |
| 398 | 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:
[ 1789054038 "object_1264\x01tags\x01" ] |
| 399 | 0.26 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1264
]
|
| 400 | 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:
[ 1789054038 "object_1279" ] |
| 401 | 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:
[ 1789054038 "object_1279\x01tags\x01" "class_22\x01tags\x01" ] |
| 402 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Technical for Europe" ] |
| 403 | 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:
[ 1789054038 "object_1269" ] |
| 404 | 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:
[ 1789054038 "object_1269\x01tags\x01" ] |
| 405 | 0.26 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1269
]
|
| 406 | 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:
[ 1789054038 "object_1283" ] |
| 407 | 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:
[ 1789054038 "object_1283\x01tags\x01" "class_22\x01tags\x01" ] |
| 408 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Technical for APAC" ] |
| 409 | 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:
[ 1789054038 "object_1268" ] |
| 410 | 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:
[ 1789054038 "object_1268\x01tags\x01" ] |
| 411 | 0.26 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1268
]
|
| 412 | 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:
[ 1789054038 "object_1282" ] |
| 413 | 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:
[ 1789054038 "object_1282\x01tags\x01" "class_22\x01tags\x01" ] |
| 414 | 0.17 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Design Center or Corporate Support" ] |
| 415 | 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:
[ 1789054038 "object_1271" ] |
| 416 | 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:
[ 1789054038 "object_1271\x01tags\x01" ] |
| 417 | 0.26 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1271
]
|
| 418 | 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:
[ 1789054038 "object_1286" ] |
| 419 | 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:
[ 1789054038 "object_1286\x01tags\x01" "class_22\x01tags\x01" ] |
| 420 | 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:
[ 1789054038 "object_1293" ] |
| 421 | 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:
[ 1789054038 "object_1293\x01tags\x01" "class_22\x01tags\x01" ] |
| 422 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Technical for Middle East" ] |
| 423 | 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:
[ 1789054038 "object_1270" ] |
| 424 | 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:
[ 1789054038 "object_1270\x01tags\x01" ] |
| 425 | 0.25 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1270
]
|
| 426 | 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:
[ 1789054038 "object_1285" ] |
| 427 | 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:
[ 1789054038 "object_1285\x01tags\x01" "class_22\x01tags\x01" ] |
| 428 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/PIM/Master Data/Contact/" "Veolia Contact (BSP)" ] |
| 429 | 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:
[ 1789054038 "object_1272" ] |
| 430 | 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:
[ 1789054038 "object_1272\x01tags\x01" ] |
| 431 | 0.25 ms |
SELECT object_22.id as id, object_22.type as `type` FROM object_22 WHERE parentId = ? AND object_22.type IN ('object','variant','folder')
Parameters:
[
1272
]
|
| 432 | 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:
[ 1789054038 "object_1294" ] |
| 433 | 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:
[ 1789054038 "object_1294\x01tags\x01" "class_22\x01tags\x01" ] |
| 434 | 0.29 ms |
SELECT object_39.id as id, object_39.type as `type` FROM object_39 WHERE object_39.type IN ('object','variant','folder')
Parameters:
[] |
| 435 | 0.97 ms |
SELECT object_InsightCurrency.id as id, object_InsightCurrency.type as `type` FROM object_InsightCurrency WHERE object_InsightCurrency.type IN ('object','variant','folder')
Parameters:
[] |
| 436 | 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:
[ 1789054038 "object_1644" ] |
| 437 | 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:
[ 1789054038 "object_1644\x01tags\x01" "class_InsightCurrency\x01tags\x01" ] |
| 438 | 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:
[ 1789054038 "object_1645" ] |
| 439 | 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:
[ 1789054038 "object_1645\x01tags\x01" "class_InsightCurrency\x01tags\x01" ] |
| 440 | 0.39 ms |
SELECT object_localized_CostType_en.id as id, object_localized_CostType_en.type as `type` FROM object_localized_CostType_en WHERE object_localized_CostType_en.type IN ('object','variant','folder')
Parameters:
[] |
| 441 | 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:
[ 1789054038 "object_1651" ] |
| 442 | 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:
[ 1789054038 "object_1651\x01tags\x01" "class_CostType\x01tags\x01" ] |
| 443 | 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:
[ 1789054038 "object_1652" ] |
| 444 | 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:
[ 1789054038 "object_1652\x01tags\x01" "class_CostType\x01tags\x01" ] |
| 445 | 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:
[ 1789054038 "object_1653" ] |
| 446 | 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:
[ 1789054038 "object_1653\x01tags\x01" "class_CostType\x01tags\x01" ] |
| 447 | 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:
[ 1789054038 "object_1654" ] |
| 448 | 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:
[ 1789054038 "object_1654\x01tags\x01" "class_CostType\x01tags\x01" ] |
| 449 | 0.29 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:
[] |
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.