Query Metrics
974
Database Queries
148
Different statements
220.67 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
46.61 ms (21.12%) |
263 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1734953635 "site_domain_edeba2033b891e73733d3bc86fb4ce51" ] |
22.77 ms (10.32%) |
90 |
SELECT * FROM object_collection_TechnicalImages_72 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 32123 "technicalImages" ] |
17.66 ms (8.00%) |
47 |
SELECT * FROM object_localized_data_72 WHERE ooo_id = ? AND language IN ('de','en','fr','es','pt','pl','nl','it','cs','tr','zh','ja')
Parameters:
[
32123
]
|
10.30 ms (4.67%) |
6 |
SELECT `oo_id` FROM `object_72` WHERE `type` = "variant" AND `path` LIKE ? AND `published` = 1
Parameters:
[
"/Products/Catalog_Products/Schutzzaeune/SZ-01/%"
]
|
9.04 ms (4.09%) |
45 |
SELECT * FROM object_collection_CatalogImages_72 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 32123 "catalogImages" ] |
8.82 ms (4.00%) |
48 |
SELECT * FROM object_relations_72 WHERE src_id = ?
Parameters:
[
32123
]
|
8.47 ms (3.84%) |
47 |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
32123
]
|
7.95 ms (3.60%) |
38 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
9433
]
|
7.35 ms (3.33%) |
47 |
SELECT * FROM object_store_72 WHERE oo_id = ?
Parameters:
[
32123
]
|
6.51 ms (2.95%) |
24 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
2516
]
|
6.40 ms (2.90%) |
47 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
32123
]
|
4.94 ms (2.24%) |
29 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
9433
]
|
4.87 ms (2.21%) |
25 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1734953635 "system\x01tags\x01" "site\x01tags\x01" ] |
4.12 ms (1.87%) |
4 |
SELECT * FROM object_collection_TechnicalImages_localized_72 WHERE ooo_id = ? AND language IN ('de','en','fr','es','pt','pl','nl','it','cs','tr','zh','ja') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 32123 "technicalImages" 0 ] |
3.30 ms (1.50%) |
17 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/schutzzaune/" "32073-sz-01" ] |
2.78 ms (1.26%) |
6 |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/de/schutzzaune/32073-sz-01" "path" "auto_create" "/de/schutzzaune/32073-sz-01" "path_query" "http://stage.rohde-technics.com/de/schutzzaune/32073-sz-01" "entire_uri" ] |
2.76 ms (1.25%) |
5 |
SELECT * FROM object_collection_TableAttributeSelection_72 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 32073 "tableRowConfigLeft" ] |
2.64 ms (1.20%) |
2 |
SELECT * FROM object_collection_TableAttributeSelection_localized_72 WHERE ooo_id = ? AND language IN ('de','en','fr','es','pt','pl','nl','it','cs','tr','zh','ja') AND `fieldname` = ? AND `index` = ?
Parameters:
[ 32073 "tableRowConfigLeft" 0 ] |
2.00 ms (0.90%) |
8 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
1.84 ms (0.83%) |
1 |
SELECT * FROM object_collection_Logos_72 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 32073 "logos" ] |
1.66 ms (0.75%) |
9 |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
9184
]
|
1.43 ms (0.65%) |
8 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_1125\x01tags\x01" "asset_5384\x01tags\x01" "asset_5386\x01tags\x01" "asset_5385\x01tags\x01" "document_1149\x01tags\x01" "document_1148\x01tags\x01" "asset_5383\x01tags\x01" ] |
1.34 ms (0.61%) |
5 |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "googleMapApiKey" null null ] |
0.84 ms (0.38%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/de/schutzzaune/32073-sz-01"
]
|
0.84 ms (0.38%) |
4 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1734953635 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
0.78 ms (0.35%) |
5 |
SELECT id, title, name FROM classificationstore_keys WHERE id IN (?)
Parameters:
[
"593"
]
|
0.76 ms (0.34%) |
4 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"72"
]
|
0.74 ms (0.33%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "output\x01tags\x01" "navigation\x01tags\x01" "document_3\x01tags\x01" "document_2141\x01tags\x01" "document_2142\x01tags\x01" "document_2516\x01tags\x01" "document_1982\x01tags\x01" "document_1979\x01tags\x01" "document_1983\x01tags\x01" "document_1980\x01tags\x01" "document_1968\x01tags\x01" "document_1981\x01tags\x01" "document_1978\x01tags\x01" "document_2124\x01tags\x01" "document_2143\x01tags\x01" "document_2127\x01tags\x01" "document_19\x01tags\x01" "document_34\x01tags\x01" "document_35\x01tags\x01" "document_36\x01tags\x01" "document_37\x01tags\x01" "document_38\x01tags\x01" "document_18\x01tags\x01" "document_22\x01tags\x01" "document_21\x01tags\x01" "document_25\x01tags\x01" "document_24\x01tags\x01" "document_6\x01tags\x01" "document_39\x01tags\x01" "document_40\x01tags\x01" "document_41\x01tags\x01" "document_42\x01tags\x01" "document_43\x01tags\x01" "document_44\x01tags\x01" "document_45\x01tags\x01" "document_46\x01tags\x01" "document_9\x01tags\x01" "document_47\x01tags\x01" "document_48\x01tags\x01" "document_49\x01tags\x01" "document_50\x01tags\x01" "document_51\x01tags\x01" "document_52\x01tags\x01" "document_53\x01tags\x01" "document_54\x01tags\x01" "document_10\x01tags\x01" "document_11\x01tags\x01" "document_12\x01tags\x01" "document_13\x01tags\x01" "document_14\x01tags\x01" "document_55\x01tags\x01" "document_57\x01tags\x01" "document_58\x01tags\x01" "document_59\x01tags\x01" "document_4\x01tags\x01" "document_5\x01tags\x01" "document_26\x01tags\x01" "document_27\x01tags\x01" "document_28\x01tags\x01" "document_7\x01tags\x01" "document_60\x01tags\x01" "document_61\x01tags\x01" "document_62\x01tags\x01" "document_63\x01tags\x01" "document_64\x01tags\x01" "document_65\x01tags\x01" "document_66\x01tags\x01" "document_8\x01tags\x01" "document_16\x01tags\x01" "document_32\x01tags\x01" "document_71\x01tags\x01" "document_72\x01tags\x01" "document_73\x01tags\x01" "document_2556\x01tags\x01" "document_2564\x01tags\x01" "document_70\x01tags\x01" "document_1895\x01tags\x01" "document_1896\x01tags\x01" "document_2550\x01tags\x01" "document_2559\x01tags\x01" "document_2562\x01tags\x01" "document_2084\x01tags\x01" "document_2188\x01tags\x01" "document_2217\x01tags\x01" "document_2207\x01tags\x01" "document_2179\x01tags\x01" "document_2180\x01tags\x01" "document_2185\x01tags\x01" "document_2190\x01tags\x01" "document_2189\x01tags\x01" "document_2537\x01tags\x01" "document_2538\x01tags\x01" "document_2536\x01tags\x01" "document_2519\x01tags\x01" "document_2222\x01tags\x01" "document_2543\x01tags\x01" "document_2544\x01tags\x01" "document_2542\x01tags\x01" ] |
0.71 ms (0.32%) |
4 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_1899\x01tags\x01" "asset_9177\x01tags\x01" "asset_9178\x01tags\x01" "asset_9179\x01tags\x01" "asset_9176\x01tags\x01" ] |
0.60 ms (0.27%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 2 2 2 ] |
0.59 ms (0.27%) |
3 |
SELECT * FROM classificationstore_keys WHERE id = ?
Parameters:
[
592
]
|
0.55 ms (0.25%) |
2 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_1055\x01tags\x01" "asset_5384\x01tags\x01" "asset_5386\x01tags\x01" "asset_5385\x01tags\x01" "document_1080\x01tags\x01" "document_1081\x01tags\x01" "asset_5383\x01tags\x01" "asset_7977\x01tags\x01" ] |
0.55 ms (0.25%) |
3 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[ 1734953635 "document_1265\x01tags\x01" "document_1080\x01tags\x01" "document_1081\x01tags\x01" "asset_7977\x01tags\x01" ] |
0.54 ms (0.24%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_2141\x01tags\x01" "document_2207\x01tags\x01" "asset_10016\x01tags\x01" "asset_9711\x01tags\x01" "asset_10876\x01tags\x01" "asset_9698\x01tags\x01" "asset_9763\x01tags\x01" "asset_9709\x01tags\x01" "asset_9700\x01tags\x01" "asset_9692\x01tags\x01" "asset_9715\x01tags\x01" "asset_9695\x01tags\x01" "asset_9694\x01tags\x01" "asset_9854\x01tags\x01" "asset_10877\x01tags\x01" "asset_10878\x01tags\x01" "asset_9705\x01tags\x01" "asset_9701\x01tags\x01" "asset_9856\x01tags\x01" "asset_9685\x01tags\x01" "asset_9745\x01tags\x01" "asset_9707\x01tags\x01" "asset_9693\x01tags\x01" "asset_9967\x01tags\x01" "document_2188\x01tags\x01" "asset_10017\x01tags\x01" "asset_10189\x01tags\x01" "asset_10859\x01tags\x01" "asset_9855\x01tags\x01" "asset_9762\x01tags\x01" "asset_9703\x01tags\x01" "asset_10184\x01tags\x01" "asset_10185\x01tags\x01" "asset_10250\x01tags\x01" "asset_10191\x01tags\x01" "asset_9720\x01tags\x01" "asset_9723\x01tags\x01" "asset_9724\x01tags\x01" "asset_9725\x01tags\x01" "asset_9722\x01tags\x01" "asset_9721\x01tags\x01" "asset_10326\x01tags\x01" "asset_10312\x01tags\x01" "asset_10424\x01tags\x01" "asset_9853\x01tags\x01" "asset_10023\x01tags\x01" "asset_9710\x01tags\x01" "asset_10695\x01tags\x01" "asset_10857\x01tags\x01" "asset_10697\x01tags\x01" "asset_10896\x01tags\x01" "asset_10775\x01tags\x01" "asset_10787\x01tags\x01" "asset_10283\x01tags\x01" "asset_9433\x01tags\x01" ] |
0.52 ms (0.23%) |
2 |
SELECT `id`, `name` FROM `classificationstore_keys`
Parameters:
[] |
0.46 ms (0.21%) |
2 |
SELECT t0.id AS id_1, t0.`name` AS name_2, t0.`group` AS group_3, t0.creationDate AS creationDate_4, t0.modificationDate AS modificationDate_5, t0.createdBy AS createdBy_6, t0.modifiedBy AS modifiedBy_7, t0.mailLayout AS mailLayout_8, t0.configuration AS configuration_9, t0.conditionalLogic AS conditionalLogic_10, t0.fields AS fields_11 FROM formbuilder_forms t0 WHERE t0.id = ?
Parameters:
[
6
]
|
0.45 ms (0.21%) |
1 |
SELECT `oo_id` FROM `object_72` WHERE `type` = "object" AND (`path` LIKE ? OR `path` = ?) AND `productCode` <> "" AND `published` = 1
Parameters:
[ "/Products/Catalog_Products/Schutzzaeune/SZ-01/%" "/Products/Catalog_Products/Schutzzaeune/SZ-01" ] |
0.44 ms (0.20%) |
3 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
8
]
|
0.37 ms (0.17%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32123 AND fieldname = 'technicalData'
Parameters:
[] |
0.37 ms (0.17%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1,2) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1899
]
|
0.37 ms (0.17%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32126 AND fieldname = 'technicalData'
Parameters:
[] |
0.36 ms (0.16%) |
2 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
2
]
|
0.36 ms (0.16%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32149 AND fieldname = 'technicalData'
Parameters:
[] |
0.32 ms (0.14%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32143 AND fieldname = 'technicalData'
Parameters:
[] |
0.31 ms (0.14%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_2142\x01tags\x01" "document_2188\x01tags\x01" "asset_10014\x01tags\x01" "asset_9724\x01tags\x01" "asset_9725\x01tags\x01" "asset_9722\x01tags\x01" "asset_9721\x01tags\x01" "asset_10184\x01tags\x01" "asset_10185\x01tags\x01" "asset_10250\x01tags\x01" "asset_10191\x01tags\x01" "asset_10013\x01tags\x01" "asset_9720\x01tags\x01" "asset_9723\x01tags\x01" "asset_10015\x01tags\x01" "document_2207\x01tags\x01" "asset_10018\x01tags\x01" "asset_10189\x01tags\x01" "asset_10187\x01tags\x01" "asset_9853\x01tags\x01" "asset_10023\x01tags\x01" "asset_9710\x01tags\x01" "asset_9711\x01tags\x01" "asset_9704\x01tags\x01" "asset_9698\x01tags\x01" "asset_9763\x01tags\x01" "asset_9855\x01tags\x01" "asset_9762\x01tags\x01" "asset_9703\x01tags\x01" "asset_10424\x01tags\x01" "asset_10326\x01tags\x01" "asset_10312\x01tags\x01" "asset_9432\x01tags\x01" ] |
0.31 ms (0.14%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_64\x01tags\x01" "asset_7962\x01tags\x01" "asset_7963\x01tags\x01" "asset_7959\x01tags\x01" "asset_7960\x01tags\x01" "asset_7965\x01tags\x01" "asset_7958\x01tags\x01" "asset_7954\x01tags\x01" "asset_7956\x01tags\x01" "asset_7953\x01tags\x01" "asset_7952\x01tags\x01" "asset_7950\x01tags\x01" "asset_7949\x01tags\x01" "asset_7948\x01tags\x01" "asset_9282\x01tags\x01" "asset_9970\x01tags\x01" "asset_7946\x01tags\x01" "asset_7945\x01tags\x01" "asset_7964\x01tags\x01" "asset_7938\x01tags\x01" "asset_7944\x01tags\x01" "asset_7943\x01tags\x01" "asset_7961\x01tags\x01" "asset_7940\x01tags\x01" "asset_7937\x01tags\x01" "asset_8679\x01tags\x01" "asset_7955\x01tags\x01" "asset_7947\x01tags\x01" "asset_7939\x01tags\x01" "asset_7966\x01tags\x01" "asset_7957\x01tags\x01" "asset_7942\x01tags\x01" "asset_7941\x01tags\x01" "asset_5492\x01tags\x01" ] |
0.31 ms (0.14%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32144 AND fieldname = 'technicalData'
Parameters:
[] |
0.30 ms (0.13%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32185 AND fieldname = 'technicalData'
Parameters:
[] |
0.29 ms (0.13%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32131 AND fieldname = 'technicalData'
Parameters:
[] |
0.29 ms (0.13%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32124 AND fieldname = 'technicalData'
Parameters:
[] |
0.29 ms (0.13%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32157 AND fieldname = 'technicalData'
Parameters:
[] |
0.28 ms (0.13%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32123 AND fieldname = 'technicalData'
Parameters:
[] |
0.28 ms (0.13%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32130 AND fieldname = 'technicalData'
Parameters:
[] |
0.28 ms (0.13%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32139 AND fieldname = 'technicalData'
Parameters:
[] |
0.27 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32137 AND fieldname = 'technicalData'
Parameters:
[] |
0.27 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32138 AND fieldname = 'technicalData'
Parameters:
[] |
0.26 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32155 AND fieldname = 'technicalData'
Parameters:
[] |
0.26 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32166 AND fieldname = 'technicalData'
Parameters:
[] |
0.26 ms (0.12%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_2127\x01tags\x01" "asset_9176\x01tags\x01" "asset_9258\x01tags\x01" "asset_9257\x01tags\x01" "asset_10452\x01tags\x01" "asset_9610\x01tags\x01" "asset_5384\x01tags\x01" "asset_10925\x01tags\x01" "asset_5385\x01tags\x01" "document_64\x01tags\x01" "document_63\x01tags\x01" "asset_10453\x01tags\x01" ] |
0.26 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32135 AND fieldname = 'technicalData'
Parameters:
[] |
0.26 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32128 AND fieldname = 'technicalData'
Parameters:
[] |
0.26 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32141 AND fieldname = 'technicalData'
Parameters:
[] |
0.26 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32145 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.12%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "object_31911\x01tags\x01" "object_30567\x01tags\x01" "object_32231\x01tags\x01" "asset_9901\x01tags\x01" "asset_9902\x01tags\x01" ] |
0.25 ms (0.12%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32159 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32156 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32135 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32136 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32142 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_61\x01tags\x01" "asset_5679\x01tags\x01" "asset_5682\x01tags\x01" "asset_5683\x01tags\x01" "asset_5685\x01tags\x01" "asset_5676\x01tags\x01" "asset_5684\x01tags\x01" "asset_5681\x01tags\x01" "asset_5678\x01tags\x01" "asset_5686\x01tags\x01" "asset_5675\x01tags\x01" "asset_5674\x01tags\x01" "asset_5677\x01tags\x01" "asset_5490\x01tags\x01" ] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32127 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_2\x01tags\x01" "asset_5384\x01tags\x01" "asset_5385\x01tags\x01" "document_64\x01tags\x01" "document_63\x01tags\x01" "asset_10455\x01tags\x01" "asset_5383\x01tags\x01" "asset_7977\x01tags\x01" "asset_5505\x01tags\x01" "asset_5517\x01tags\x01" "asset_5769\x01tags\x01" "asset_5523\x01tags\x01" "asset_5519\x01tags\x01" "asset_9180\x01tags\x01" "asset_10319\x01tags\x01" ] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32148 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32126 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32140 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32141 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32146 AND fieldname = 'technicalData'
Parameters:
[] |
0.25 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32165 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32134 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32164 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32147 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32162 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32125 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32129 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32153 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32133 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32158 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32132 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32128 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32154 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32161 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32163 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32150 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1734953635 "document_11\x01tags\x01" "asset_5396\x01tags\x01" "asset_5614\x01tags\x01" "asset_5615\x01tags\x01" "asset_5616\x01tags\x01" "asset_8502\x01tags\x01" "asset_8503\x01tags\x01" "asset_8501\x01tags\x01" "asset_5394\x01tags\x01" "asset_5395\x01tags\x01" "asset_5454\x01tags\x01" ] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32144 AND fieldname = 'technicalData'
Parameters:
[] |
0.24 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32152 AND fieldname = 'technicalData'
Parameters:
[] |
0.23 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32160 AND fieldname = 'technicalData'
Parameters:
[] |
0.23 ms (0.11%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32157 AND fieldname = 'technicalData'
Parameters:
[] |
0.23 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32151 AND fieldname = 'technicalData'
Parameters:
[] |
0.23 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32155 AND fieldname = 'technicalData'
Parameters:
[] |
0.23 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32138 AND fieldname = 'technicalData'
Parameters:
[] |
0.23 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32119 AND fieldname = 'technicalData'
Parameters:
[] |
0.22 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32136 AND fieldname = 'technicalData'
Parameters:
[] |
0.22 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32137 AND fieldname = 'technicalData'
Parameters:
[] |
0.22 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32160 AND fieldname = 'technicalData'
Parameters:
[] |
0.21 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32164 AND fieldname = 'technicalData'
Parameters:
[] |
0.21 ms (0.10%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32132 AND fieldname = 'technicalData'
Parameters:
[] |
0.21 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32185 AND fieldname = 'technicalData'
Parameters:
[] |
0.21 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32146 AND fieldname = 'technicalData'
Parameters:
[] |
0.21 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32127 AND fieldname = 'technicalData'
Parameters:
[] |
0.21 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32156 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32158 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_relations_73 WHERE src_id = ?
Parameters:
[
32231
]
|
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32130 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32166 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32125 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32120 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32149 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32124 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32162 AND fieldname = 'technicalData'
Parameters:
[] |
0.20 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32131 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32139 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32133 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32145 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32119 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.09%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32147 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32129 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32142 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32143 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32161 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32163 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32148 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32152 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32154 AND fieldname = 'technicalData'
Parameters:
[] |
0.19 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32159 AND fieldname = 'technicalData'
Parameters:
[] |
0.18 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32140 AND fieldname = 'technicalData'
Parameters:
[] |
0.18 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32150 AND fieldname = 'technicalData'
Parameters:
[] |
0.18 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32134 AND fieldname = 'technicalData'
Parameters:
[] |
0.18 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32153 AND fieldname = 'technicalData'
Parameters:
[] |
0.18 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32165 AND fieldname = 'technicalData'
Parameters:
[] |
0.18 ms (0.08%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.18 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_groups_72 WHERE id = 32151 AND fieldname = 'technicalData'
Parameters:
[] |
0.18 ms (0.08%) |
1 |
SELECT * FROM object_classificationstore_data_72 WHERE id = 32120 AND fieldname = 'technicalData'
Parameters:
[] |
0.18 ms (0.08%) |
1 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
0.17 ms (0.08%) |
1 |
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
9184
]
|
0.16 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/de/schutzzaune/32073-sz-01' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
0.15 ms (0.07%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
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.
Entities Mapping
Class | Mapping errors |
---|---|
FormBuilderBundle\Model\OutputWorkflow | No errors. |
FormBuilderBundle\Model\FormDefinition | No errors. |
FormBuilderBundle\Model\OutputWorkflowChannel | No errors. |