GET http://159.203.89.10/sitemap.xml

Query Metrics

1329 Database Queries
200 Different statements
592.93 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.