Query Metrics
1329
Database Queries
200
Different statements
592.93 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
213.84 ms (36.06%) |
613 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1750448126 "site_domain_d2e56211df699ff032c2a3df66a6a2ab" ] |
61.84 ms (10.43%) |
153 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1750448126 "system\x01tags\x01" "site\x01tags\x01" ] |
60.14 ms (10.14%) |
107 |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
1
]
|
58.71 ms (9.90%) |
154 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1750448126 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
16.75 ms (2.82%) |
47 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[ 1750448126 "document_51\x01tags\x01" "asset_348\x01tags\x01" "asset_347\x01tags\x01" "asset_349\x01tags\x01" ] |
16.49 ms (2.78%) |
26 |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
1
]
|
5.60 ms (0.94%) |
15 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?)
Parameters:
[ 1750448126 "document_112\x01tags\x01" "asset_336\x01tags\x01" "asset_382\x01tags\x01" "asset_378\x01tags\x01" "asset_374\x01tags\x01" ] |
5.06 ms (0.85%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '91'
Parameters:
[] |
3.68 ms (0.62%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '325'
Parameters:
[] |
3.14 ms (0.53%) |
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:
[ 1750448126 "document_100\x01tags\x01" "asset_341\x01tags\x01" "asset_360\x01tags\x01" "document_57\x01tags\x01" "document_54\x01tags\x01" "document_55\x01tags\x01" ] |
3.02 ms (0.51%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '276'
Parameters:
[] |
2.61 ms (0.44%) |
5 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
1.94 ms (0.33%) |
1 |
SELECT object_localized_NE_en.id AS id, object_localized_NE_en.type AS `type` FROM object_localized_NE_en WHERE ( object_localized_NE_en.type IN ('object','variant','folder')) AND object_localized_NE_en.published = 1 ORDER BY `date` DESC
Parameters:
[] |
1.74 ms (0.29%) |
1 |
SELECT object_localized_CA_en.id AS id, object_localized_CA_en.type AS `type` FROM object_localized_CA_en WHERE ( object_localized_CA_en.type IN ('object','variant','folder')) AND object_localized_CA_en.published = 1
Parameters:
[] |
1.69 ms (0.28%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '334'
Parameters:
[] |
1.66 ms (0.28%) |
1 |
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (carClass IS NOT NULL)
Parameters:
[] |
1.54 ms (0.26%) |
3 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "sitemap.xml" ] |
1.43 ms (0.24%) |
3 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"NE"
]
|
1.22 ms (0.21%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '97'
Parameters:
[] |
1.16 ms (0.20%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '92'
Parameters:
[] |
1.11 ms (0.19%) |
2 |
SELECT id FROM sites
Parameters:
[] |
1.06 ms (0.18%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '98'
Parameters:
[] |
1.05 ms (0.18%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '250'
Parameters:
[] |
1.02 ms (0.17%) |
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:
[ 1750448126 "document_1\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01" ] |
1.02 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '353'
Parameters:
[] |
1.01 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '229'
Parameters:
[] |
1.00 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '341'
Parameters:
[] |
0.98 ms (0.17%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '328'
Parameters:
[] |
0.97 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '344'
Parameters:
[] |
0.94 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '252'
Parameters:
[] |
0.93 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '329'
Parameters:
[] |
0.92 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '66'
Parameters:
[] |
0.92 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '308'
Parameters:
[] |
0.91 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '102'
Parameters:
[] |
0.90 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '326'
Parameters:
[] |
0.89 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '339'
Parameters:
[] |
0.89 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '292'
Parameters:
[] |
0.88 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '287'
Parameters:
[] |
0.86 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '306'
Parameters:
[] |
0.86 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '352'
Parameters:
[] |
0.85 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '280'
Parameters:
[] |
0.85 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '235'
Parameters:
[] |
0.85 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '347'
Parameters:
[] |
0.85 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '299'
Parameters:
[] |
0.84 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '332'
Parameters:
[] |
0.84 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '14'
Parameters:
[] |
0.84 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '342'
Parameters:
[] |
0.84 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '350'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '278'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '274'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '150'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '358'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '318'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '105'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '232'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '184'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '259'
Parameters:
[] |
0.83 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '282'
Parameters:
[] |
0.82 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '273'
Parameters:
[] |
0.82 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '279'
Parameters:
[] |
0.82 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '215'
Parameters:
[] |
0.81 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '126'
Parameters:
[] |
0.81 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '90'
Parameters:
[] |
0.81 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '104'
Parameters:
[] |
0.81 ms (0.14%) |
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:
[ 1750448126 "document_101\x01tags\x01" "asset_319\x01tags\x01" "asset_321\x01tags\x01" "asset_341\x01tags\x01" "asset_14\x01tags\x01" "asset_46\x01tags\x01" "asset_57\x01tags\x01" "asset_13\x01tags\x01" "asset_81\x01tags\x01" ] |
0.80 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '309'
Parameters:
[] |
0.80 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '15'
Parameters:
[] |
0.80 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '143'
Parameters:
[] |
0.80 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '262'
Parameters:
[] |
0.80 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '180'
Parameters:
[] |
0.80 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '217'
Parameters:
[] |
0.80 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:
[ 1750448126 "document_95\x01tags\x01" "object_75\x01tags\x01" "object_74\x01tags\x01" "object_399\x01tags\x01" "asset_384\x01tags\x01" "asset_385\x01tags\x01" "asset_386\x01tags\x01" ] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '257'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '103'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '337'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '338'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '348'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '228'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '285'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '194'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '110'
Parameters:
[] |
0.79 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '311'
Parameters:
[] |
0.78 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '249'
Parameters:
[] |
0.78 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '316'
Parameters:
[] |
0.78 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '16'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '156'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '195'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '77'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '297'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '359'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '175'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '172'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '304'
Parameters:
[] |
0.77 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '305'
Parameters:
[] |
0.76 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '303'
Parameters:
[] |
0.76 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '298'
Parameters:
[] |
0.76 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '360'
Parameters:
[] |
0.75 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '321'
Parameters:
[] |
0.75 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '288'
Parameters:
[] |
0.75 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '161'
Parameters:
[] |
0.75 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '312'
Parameters:
[] |
0.75 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '13'
Parameters:
[] |
0.75 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '286'
Parameters:
[] |
0.75 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '244'
Parameters:
[] |
0.74 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '115'
Parameters:
[] |
0.74 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '238'
Parameters:
[] |
0.74 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:
[ 1750448126 "document_103\x01tags\x01" "asset_25\x01tags\x01" "asset_340\x01tags\x01" "asset_341\x01tags\x01" "asset_35\x01tags\x01" "asset_123\x01tags\x01" "asset_114\x01tags\x01" "asset_186\x01tags\x01" "asset_127\x01tags\x01" "asset_277\x01tags\x01" ] |
0.74 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '53'
Parameters:
[] |
0.74 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '131'
Parameters:
[] |
0.74 ms (0.13%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '192'
Parameters:
[] |
0.74 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '221'
Parameters:
[] |
0.74 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '51'
Parameters:
[] |
0.74 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '188'
Parameters:
[] |
0.74 ms (0.12%) |
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:
[ 1750448126 "document_46\x01tags\x01" "asset_321\x01tags\x01" "asset_362\x01tags\x01" "asset_340\x01tags\x01" "asset_360\x01tags\x01" "asset_339\x01tags\x01" "asset_364\x01tags\x01" "asset_341\x01tags\x01" ] |
0.73 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '323'
Parameters:
[] |
0.73 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '24'
Parameters:
[] |
0.73 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '67'
Parameters:
[] |
0.73 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '162'
Parameters:
[] |
0.73 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '277'
Parameters:
[] |
0.72 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '166'
Parameters:
[] |
0.72 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '220'
Parameters:
[] |
0.72 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '231'
Parameters:
[] |
0.72 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '152'
Parameters:
[] |
0.72 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '253'
Parameters:
[] |
0.72 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '295'
Parameters:
[] |
0.72 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '133'
Parameters:
[] |
0.71 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '196'
Parameters:
[] |
0.71 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '114'
Parameters:
[] |
0.71 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '223'
Parameters:
[] |
0.71 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '224'
Parameters:
[] |
0.70 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '200'
Parameters:
[] |
0.70 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '263'
Parameters:
[] |
0.70 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '54'
Parameters:
[] |
0.70 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '227'
Parameters:
[] |
0.70 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '293'
Parameters:
[] |
0.69 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '351'
Parameters:
[] |
0.69 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '57'
Parameters:
[] |
0.69 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '294'
Parameters:
[] |
0.68 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '198'
Parameters:
[] |
0.68 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '346'
Parameters:
[] |
0.68 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '157'
Parameters:
[] |
0.67 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '82'
Parameters:
[] |
0.67 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '222'
Parameters:
[] |
0.67 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '283'
Parameters:
[] |
0.67 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '265'
Parameters:
[] |
0.67 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '216'
Parameters:
[] |
0.66 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '202'
Parameters:
[] |
0.66 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '125'
Parameters:
[] |
0.66 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '116'
Parameters:
[] |
0.66 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '88'
Parameters:
[] |
0.65 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '124'
Parameters:
[] |
0.65 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '205'
Parameters:
[] |
0.65 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '236'
Parameters:
[] |
0.65 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '87'
Parameters:
[] |
0.65 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '203'
Parameters:
[] |
0.64 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '144'
Parameters:
[] |
0.64 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '74'
Parameters:
[] |
0.63 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:
[ 1750448126 "document_3\x01tags\x01" "document_1\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01" ] |
0.63 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '118'
Parameters:
[] |
0.63 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '138'
Parameters:
[] |
0.62 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '174'
Parameters:
[] |
0.62 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '149'
Parameters:
[] |
0.62 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '269'
Parameters:
[] |
0.62 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '112'
Parameters:
[] |
0.62 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '266'
Parameters:
[] |
0.62 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '58'
Parameters:
[] |
0.62 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '26'
Parameters:
[] |
0.61 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '70'
Parameters:
[] |
0.61 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '271'
Parameters:
[] |
0.61 ms (0.10%) |
1 |
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:
[ "/sitemap.xml" "path" "auto_create" "/sitemap.xml" "path_query" "http://159.203.89.10/sitemap.xml" "entire_uri" ] |
0.59 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '139'
Parameters:
[] |
0.58 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '75'
Parameters:
[] |
0.57 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '63'
Parameters:
[] |
0.57 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '191'
Parameters:
[] |
0.55 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '78'
Parameters:
[] |
0.55 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '33'
Parameters:
[] |
0.54 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '189'
Parameters:
[] |
0.54 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '30'
Parameters:
[] |
0.54 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '20'
Parameters:
[] |
0.54 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '44'
Parameters:
[] |
0.54 ms (0.09%) |
1 |
SELECT * FROM properties WHERE cid = ? AND ctype='document'
Parameters:
[
46
]
|
0.53 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '34'
Parameters:
[] |
0.51 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '111'
Parameters:
[] |
0.51 ms (0.09%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '247'
Parameters:
[] |
0.50 ms (0.08%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '119'
Parameters:
[] |
0.50 ms (0.08%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '120'
Parameters:
[] |
0.50 ms (0.08%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '19'
Parameters:
[] |
0.49 ms (0.08%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '25'
Parameters:
[] |
0.46 ms (0.08%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '69'
Parameters:
[] |
0.43 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '38'
Parameters:
[] |
0.43 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:
[ 1750448126 "document_110\x01tags\x01" "document_104\x01tags\x01" "document_54\x01tags\x01" "document_55\x01tags\x01" "document_56\x01tags\x01" "document_57\x01tags\x01" "object_548\x01tags\x01" "object_561\x01tags\x01" "object_551\x01tags\x01" "object_550\x01tags\x01" "asset_390\x01tags\x01" "asset_391\x01tags\x01" "asset_392\x01tags\x01" "asset_389\x01tags\x01" ] |
0.41 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '12'
Parameters:
[] |
0.41 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:
[ 1750448126 "document_49\x01tags\x01" "asset_252\x01tags\x01" "asset_250\x01tags\x01" "asset_249\x01tags\x01" "asset_251\x01tags\x01" "asset_115\x01tags\x01" "asset_117\x01tags\x01" "asset_114\x01tags\x01" "asset_35\x01tags\x01" "asset_36\x01tags\x01" "asset_41\x01tags\x01" ] |
0.41 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '31'
Parameters:
[] |
0.40 ms (0.07%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/sitemap.xml"
]
|
0.39 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '43'
Parameters:
[] |
0.39 ms (0.07%) |
1 |
SELECT FOUND_ROWS()
Parameters:
[] |
0.36 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '245'
Parameters:
[] |
0.35 ms (0.06%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
0.29 ms (0.05%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
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.
Entities Mapping
No mapped entities.