Query Metrics
662
Database Queries
55
Different statements
333.93 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
83.61 ms (25.04%) |
150 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1774393592 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
82.99 ms (24.85%) |
210 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1774393592 "site_domain_e19013cb161706785ddee46d4210cfcb" ] |
|
47.77 ms (14.31%) |
55 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
5931
]
|
|
16.84 ms (5.04%) |
61 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
5931
]
|
|
7.47 ms (2.24%) |
1 |
SELECT object_localized_5_en.id as id, object_localized_5_en.type as `type` FROM object_localized_5_en WHERE (isDevItem IS false AND workType = 'work' AND published IS true AND artist__id = 490 AND object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1 ORDER BY `priority` ASC, `workDateEnd` DESC, `workDate` DESC
Parameters:
[] |
|
7.03 ms (2.11%) |
2 |
SELECT COUNT(*) FROM object_localized_5_en INNER JOIN object_1 artist ON object_localized_5_en.artist__id = artist.oo_id AND object_localized_5_en.isDevItem IS false AND (artist.status = 'artist' OR artist.status = 'guest' OR artist.oo_id = 490 ) AND workType = 'architecture' AND object_localized_5_en.published IS true AND artist__id = 490 WHERE ( object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1
Parameters:
[] |
|
7.03 ms (2.11%) |
2 |
SELECT COUNT(*) FROM (SELECT object_localized_5_en.id FROM object_localized_5_en WHERE (isDevItem IS false AND workType = 'edition' AND workgroup__id > 0 AND published IS true AND artist__id = 490 AND object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1 GROUP BY `workgroup__id`) XYZ
Parameters:
[] |
|
7.03 ms (2.10%) |
2 |
SELECT COUNT(*) FROM object_localized_5_en INNER JOIN object_1 artist ON object_localized_5_en.artist__id = artist.oo_id AND object_localized_5_en.isDevItem IS false AND (artist.status = 'artist' OR artist.status = 'guest' OR artist.status = 'exMarketingEdition' OR artist.oo_id = 490 ) AND workType = 'edition' AND object_localized_5_en.published IS true AND artist__id = 490 WHERE ( object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1
Parameters:
[] |
|
6.81 ms (2.04%) |
1 |
SELECT COUNT(*) FROM object_localized_5_en WHERE (isDevItem IS false AND workType = 'edition' AND workgroup__id IS NULL AND published IS true AND artist__id = 490 AND object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1
Parameters:
[] |
|
6.29 ms (1.88%) |
1 |
SELECT object_localized_5_en.id as id, object_localized_5_en.type as `type` FROM object_localized_5_en WHERE (isDevItem IS false AND workType = 'work' AND workgroup__id > 0 AND published IS true AND artist__id = 490 AND object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1 GROUP BY `workgroup__id` ORDER BY `workDateEnd` DESC, `workDate` DESC
Parameters:
[] |
|
4.87 ms (1.46%) |
1 |
SELECT object_localized_5_en.id as id, object_localized_5_en.type as `type` FROM object_localized_5_en INNER JOIN object_1 artist ON object_localized_5_en.artist__id = artist.oo_id AND object_localized_5_en.isDevItem IS false AND (artist.status = 'artist' OR artist.status = 'guest' OR artist.status = 'exMarketingEdition' OR artist.oo_id = 490 ) AND workType = 'edition' AND object_localized_5_en.published IS true AND artist__id = 490 WHERE ( object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1 ORDER BY `workDateEnd` DESC, `workDate` DESC
Parameters:
[] |
|
4.52 ms (1.35%) |
2 |
SELECT COUNT(*) FROM object_localized_5_en WHERE (isDevItem IS false AND workType = 'work' AND published IS true AND artist__id = 490 AND object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1
Parameters:
[] |
|
4.48 ms (1.34%) |
2 |
SELECT COUNT(*) FROM (SELECT object_localized_5_en.id FROM object_localized_5_en WHERE (isDevItem IS false AND workType = 'work' AND workgroup__id > 0 AND published IS true AND artist__id = 490 AND object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1 GROUP BY `workgroup__id`) XYZ
Parameters:
[] |
|
4.41 ms (1.32%) |
24 |
SELECT * FROM object_relations_4 WHERE src_id = ?
Parameters:
[
18711
]
|
|
4.25 ms (1.27%) |
1 |
SELECT COUNT(*) FROM object_localized_5_en WHERE (isDevItem IS false AND workType = 'work' AND workgroup__id IS NULL AND preview = true AND published IS true AND artist__id = 490 AND object_localized_5_en.type IN ('object','variant','folder')) AND object_localized_5_en.published = 1
Parameters:
[] |
|
3.81 ms (1.14%) |
5 |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
18200
]
|
|
3.23 ms (0.97%) |
19 |
SELECT * FROM object_relations_5 WHERE src_id = ?
Parameters:
[
10594
]
|
|
3.22 ms (0.97%) |
14 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[ 1774393592 "object_10731\x01tags\x01" "class_5\x01tags\x01" "asset_8070\x01tags\x01" "asset_8071\x01tags\x01" ] |
|
2.87 ms (0.86%) |
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:
[ 1774393592 "object_10617\x01tags\x01" "class_5\x01tags\x01" "asset_9094\x01tags\x01" "asset_9095\x01tags\x01" "asset_9096\x01tags\x01" "asset_9097\x01tags\x01" "asset_9098\x01tags\x01" "asset_9099\x01tags\x01" "asset_9100\x01tags\x01" ] |
|
2.67 ms (0.80%) |
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:
[ 1774393592 "object_10665\x01tags\x01" "class_5\x01tags\x01" "asset_9078\x01tags\x01" "asset_9079\x01tags\x01" "asset_9080\x01tags\x01" "asset_9081\x01tags\x01" ] |
|
1.75 ms (0.52%) |
7 |
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
18709
]
|
|
1.61 ms (0.48%) |
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:
[ 1774393592 "object_10614\x01tags\x01" "class_5\x01tags\x01" "asset_9082\x01tags\x01" "asset_9083\x01tags\x01" "asset_9084\x01tags\x01" "asset_9085\x01tags\x01" "asset_9086\x01tags\x01" "asset_9087\x01tags\x01" "asset_9088\x01tags\x01" "asset_9089\x01tags\x01" "asset_9090\x01tags\x01" "asset_9091\x01tags\x01" "asset_9092\x01tags\x01" "asset_9093\x01tags\x01" ] |
|
1.60 ms (0.48%) |
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:
[ 1774393592 "object_9405\x01tags\x01" "class_3\x01tags\x01" "asset_8262\x01tags\x01" "asset_8263\x01tags\x01" "asset_8264\x01tags\x01" "asset_8265\x01tags\x01" "asset_8266\x01tags\x01" "asset_8267\x01tags\x01" "asset_8268\x01tags\x01" "asset_8269\x01tags\x01" "asset_8270\x01tags\x01" "asset_8271\x01tags\x01" ] |
|
1.37 ms (0.41%) |
4 |
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:
[ "/en/artist/giacomo-santiago-rogado~a490" "path" "auto_create" "/en/artist/giacomo-santiago-rogado~a490" "path_query" "https://dev.bernhardknaus.com/en/artist/giacomo-santiago-rogado~a490" "entire_uri" ] |
|
1.24 ms (0.37%) |
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:
[ 1774393592 "object_12889\x01tags\x01" "class_5\x01tags\x01" "asset_9155\x01tags\x01" "asset_9156\x01tags\x01" "asset_9157\x01tags\x01" "asset_9158\x01tags\x01" "asset_9159\x01tags\x01" "asset_9160\x01tags\x01" "asset_9161\x01tags\x01" "asset_9162\x01tags\x01" "asset_9163\x01tags\x01" "asset_9164\x01tags\x01" "asset_9165\x01tags\x01" "asset_9166\x01tags\x01" "asset_9167\x01tags\x01" "asset_9168\x01tags\x01" "asset_9169\x01tags\x01" "asset_9170\x01tags\x01" "asset_9171\x01tags\x01" "asset_9172\x01tags\x01" "asset_9173\x01tags\x01" "asset_9174\x01tags\x01" "asset_9175\x01tags\x01" "asset_9176\x01tags\x01" "asset_9177\x01tags\x01" "asset_9178\x01tags\x01" "asset_9179\x01tags\x01" "asset_9180\x01tags\x01" "asset_9181\x01tags\x01" "asset_9182\x01tags\x01" "asset_9183\x01tags\x01" "asset_9184\x01tags\x01" ] |
|
1.10 ms (0.33%) |
1 |
SELECT object_localized_4_en.id as id, object_localized_4_en.type as `type` FROM object_localized_4_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_4_en.type IN ('object','variant','folder')) AND object_localized_4_en.published = 1 ORDER BY `dateStart` DESC
Parameters:
[] |
|
1.06 ms (0.32%) |
19 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
1.00 ms (0.30%) |
6 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1774393592 "system\x01tags\x01" "site\x01tags\x01" ] |
|
0.97 ms (0.29%) |
2 |
SELECT COUNT(*) FROM object_localized_4_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_4_en.type IN ('object','variant','folder')) AND object_localized_4_en.published = 1
Parameters:
[] |
|
0.85 ms (0.26%) |
2 |
SELECT COUNT(*) FROM object_localized_2_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_2_en.type IN ('object','variant','folder')) AND object_localized_2_en.published = 1
Parameters:
[] |
|
0.83 ms (0.25%) |
2 |
SELECT COUNT(*) FROM object_localized_3_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_3_en.type IN ('object','variant','folder')) AND object_localized_3_en.published = 1
Parameters:
[] |
|
0.82 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:
[ 1774393592 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "document_85\x01tags\x01" "document_86\x01tags\x01" "document_96\x01tags\x01" "document_87\x01tags\x01" "object_12999\x01tags\x01" "object_13000\x01tags\x01" ] |
|
0.80 ms (0.24%) |
16 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.75 ms (0.23%) |
2 |
SELECT COUNT(*) FROM object_localized_12_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_12_en.type IN ('object','variant','folder')) AND object_localized_12_en.published = 1
Parameters:
[] |
|
0.72 ms (0.21%) |
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:
[ 1774393592 "object_10737\x01tags\x01" "class_5\x01tags\x01" "asset_9134\x01tags\x01" "asset_9135\x01tags\x01" "asset_9136\x01tags\x01" "asset_9137\x01tags\x01" "asset_9138\x01tags\x01" "asset_9139\x01tags\x01" "asset_9140\x01tags\x01" "asset_9141\x01tags\x01" "asset_9142\x01tags\x01" "asset_9143\x01tags\x01" "asset_9144\x01tags\x01" "asset_9145\x01tags\x01" "asset_9146\x01tags\x01" "asset_9147\x01tags\x01" "asset_9148\x01tags\x01" "asset_9149\x01tags\x01" "asset_9150\x01tags\x01" "asset_9151\x01tags\x01" "asset_9152\x01tags\x01" ] |
|
0.65 ms (0.19%) |
1 |
SELECT object_localized_3_en.id as id, object_localized_3_en.type as `type` FROM object_localized_3_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_3_en.type IN ('object','variant','folder')) AND object_localized_3_en.published = 1 ORDER BY `dateEnd` DESC
Parameters:
[] |
|
0.63 ms (0.19%) |
1 |
SELECT object_localized_2_en.id as id, object_localized_2_en.type as `type` FROM object_localized_2_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_2_en.type IN ('object','variant','folder')) AND object_localized_2_en.published = 1 ORDER BY `year` DESC
Parameters:
[] |
|
0.58 ms (0.17%) |
7 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
|
0.55 ms (0.17%) |
2 |
SELECT COUNT(*) FROM object_localized_11_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_11_en.type IN ('object','variant','folder')) AND object_localized_11_en.published = 1
Parameters:
[] |
|
0.52 ms (0.15%) |
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:
[ 1774393592 "object_2919\x01tags\x01" "class_4\x01tags\x01" "asset_6593\x01tags\x01" "asset_6594\x01tags\x01" "asset_6595\x01tags\x01" "asset_6596\x01tags\x01" "asset_6597\x01tags\x01" ] |
|
0.48 ms (0.14%) |
1 |
SELECT object_localized_12_en.id as id, object_localized_12_en.type as `type` FROM object_localized_12_en WHERE (isDevItem IS false AND published IS true AND artists LIKE '%,490,%' AND object_localized_12_en.type IN ('object','variant','folder')) AND object_localized_12_en.published = 1 ORDER BY `date` DESC
Parameters:
[] |
|
0.43 ms (0.13%) |
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:
[ 1774393592 "object_17906\x01tags\x01" "class_3\x01tags\x01" "asset_10034\x01tags\x01" "asset_10035\x01tags\x01" "asset_10036\x01tags\x01" "asset_10037\x01tags\x01" "asset_10038\x01tags\x01" "asset_10039\x01tags\x01" ] |
|
0.41 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:
[ 1774393592 "object_12885\x01tags\x01" "class_5\x01tags\x01" "asset_9104\x01tags\x01" "asset_9105\x01tags\x01" "asset_9106\x01tags\x01" "asset_9107\x01tags\x01" "asset_9108\x01tags\x01" "asset_9109\x01tags\x01" "asset_9110\x01tags\x01" "asset_9111\x01tags\x01" "asset_9112\x01tags\x01" "asset_9113\x01tags\x01" "asset_9114\x01tags\x01" "asset_9115\x01tags\x01" "asset_9116\x01tags\x01" "asset_9117\x01tags\x01" "asset_9118\x01tags\x01" "asset_9119\x01tags\x01" "asset_9120\x01tags\x01" "asset_9121\x01tags\x01" "asset_9122\x01tags\x01" "asset_9123\x01tags\x01" "asset_9124\x01tags\x01" "asset_9125\x01tags\x01" "asset_9126\x01tags\x01" "asset_9127\x01tags\x01" "asset_9128\x01tags\x01" "asset_9129\x01tags\x01" "asset_9130\x01tags\x01" "asset_9131\x01tags\x01" "asset_9132\x01tags\x01" ] |
|
0.36 ms (0.11%) |
3 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/en/artist/" "giacomo-santiago-rogado~a490" ] |
|
0.24 ms (0.07%) |
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:
[ 1774393592 "object_9424\x01tags\x01" "class_3\x01tags\x01" "asset_3856\x01tags\x01" "asset_3857\x01tags\x01" "asset_3858\x01tags\x01" "asset_3859\x01tags\x01" "asset_3860\x01tags\x01" "asset_3861\x01tags\x01" "asset_3862\x01tags\x01" "asset_3863\x01tags\x01" "asset_3864\x01tags\x01" ] |
|
0.22 ms (0.07%) |
3 |
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:
[ "viewDummyContent" null null ] |
|
0.22 ms (0.07%) |
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:
[ 1774393592 "output\x01tags\x01" "navigation\x01tags\x01" "document_5\x01tags\x01" "document_6\x01tags\x01" "document_112\x01tags\x01" "document_81\x01tags\x01" "document_117\x01tags\x01" "document_79\x01tags\x01" "document_49\x01tags\x01" "document_50\x01tags\x01" "document_51\x01tags\x01" "document_80\x01tags\x01" "document_47\x01tags\x01" "document_52\x01tags\x01" "document_108\x01tags\x01" "document_100\x01tags\x01" "document_95\x01tags\x01" "document_94\x01tags\x01" "document_76\x01tags\x01" "document_53\x01tags\x01" "document_9\x01tags\x01" "document_54\x01tags\x01" "document_89\x01tags\x01" "document_92\x01tags\x01" "document_93\x01tags\x01" ] |
|
0.18 ms (0.06%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/en/artist/giacomo-santiago-rogado~a490"
]
|
|
0.17 ms (0.05%) |
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:
[ 1774393592 "object_12777\x01tags\x01" "class_4\x01tags\x01" "asset_8430\x01tags\x01" "asset_8431\x01tags\x01" "asset_8432\x01tags\x01" ] |
|
0.14 ms (0.04%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.14 ms (0.04%) |
1 |
SELECT * FROM object_relations_12 WHERE src_id = ?
Parameters:
[
14839
]
|
|
0.14 ms (0.04%) |
3 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
3
]
|
|
0.07 ms (0.02%) |
1 |
SELECT object_14.id as id, object_14.type as `type` FROM object_14 WHERE ( object_14.type IN ('object','variant','folder')) AND object_14.published = 1 ORDER BY `name` ASC
Parameters:
[] |
|
0.06 ms (0.02%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
11
]
|
|
0.05 ms (0.01%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
No managed entities.
Entities Mapping
No mapped entities.