Query Metrics
179
Database Queries
24
Different statements
57.02 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
27.42 ms (48.09%) |
2 |
SELECT object_localized_11_en.o_id as o_id, object_localized_11_en.o_type as o_type FROM object_localized_11_en LEFT JOIN object_collection_demiDate_11 dates ON dates.o_id = object_localized_11_en.oo_id LEFT JOIN object_collection_demiStartTime_11 times ON times.o_id = object_localized_11_en.oo_id WHERE ((object_localized_11_en.o_id in (select o_parentId from object_10 where object_10.o_id in (select src_id from object_relations_10 where dest_id in (8588)))) AND (o_parentId in (select o_id from object_12 where town__id in (11431,11422,11423,11541,11430,3192505,3192507,3192504,3192506,11426,3192508,11434,11848,11504,11474,11849,11470,11493,11499,11492,11841,11487,11501,11475,11495,11494,11496,11482,11846,11484,11847,11506,11479,11837,11478,11839,11505,11489,11842,11845,11836,11476,11503,11471,11483,11850,11498,11481,11497,11500,11843,11472,11490,11844,11491,11473,11838,11477,11488,11840,11485,11486,11480,11502,10003651,10003639,10003640,10003652,10003641,10003650,10003612,10003642,10003643,10003660,10003613,10003644,10003610,10003614,10003616,10003653,10003645,10003617,10003618,10003654,10003620,10003621,10003622,10003655,10003656,10003646,10003649,10003624,10003648,10003659,10003629,10003625,10003647,10003657,10003626,10003628,10003630,10003632,10003633,10003634,10003636,10003658,10003637,10003638,11534,11539,11538,11527,11522,11524,11559,11521,11567,11560,11526,11536,3896603,11528,11535,11537,11959,11948,11910,11909,11965,11963,11947,11922,11921,11950,11914,11920,11946,11937,29785444,29785442,11956,11929,11935,11923,11936,11926,11927,11918,11966,11971,11972,11931,11928,11953,11930,11924,11954,11955,11942,11932,3239518,12146,12115,12122,12133,12531,12143,12116,12129,12138,12136,12118,12163,12164,12155,12152,12525,3552351,12162,12154,5099244,3552346,3190431,12157,3552350,3238735,12110,3552345,3552348,3552347,12120,12123,12135,12137,12140,12099,12098,12117,12108,12151,12134,12109,12156,12106,12126,12132,3190432,12158,12103,12139,3552349,12114,12111,12160,12112,11195,11196,11191,11194,11190,3192509,11197,11409,6944,6971,12312,12321,6973,12320,6953,12309,6955,6957,6963,6948,12304,6969,6945,6966,6951,6968,6949,12305,6958,6959,6970,6974,12324,12342,6946,6956,6964,6954,6967,12319,12333,6965,12323,12316,6961,12318,6972,6962,6960,12329,12311,6947,12478,12548,12464,12539,12535,12532,12555,12472,12489,12505,12503,12508,12526,12544,12530,12537,12463,12491,12547,12519,12480,12542,12551,12477,12469,3239510,12528,12507,3239509,12510,3239507,3239508,12522,12543,12502,12546,12552,12538,12465,11465,11466,11464,11463,1612603,11550,11552,11546,11938,11563,11553,11561,11562,11540,11554,11551,3896604,11548,11547,11545,11543,11549,11431,11422,11423,11541,11430,3192505,3192507,3192504,3192506,11426,3192508,11434,11848,11504,11474,11849,11470,11493,11499,11492,11841,11487,11501,11475,11495,11494,11496,11482,11846,11484,11847,11506,11479,11837,11478,11839,11505,11489,11842,11845,11836,11476,11503,11471,11483,11850,11498,11481,11497,11500,11843,11472,11490,11844,11491,11473,11838,11477,11488,11840,11485,11486,11480,11502,10003651,10003639,10003640,10003652,10003641,10003650,10003612,10003642,10003643,10003660,10003613,10003644,10003610,10003614,10003616,10003653,10003645,10003617,10003618,10003654,10003620,10003621,10003622,10003655,10003656,10003646,10003649,10003624,10003648,10003659,10003629,10003625,10003647,10003657,10003626,10003628,10003630,10003632,10003633,10003634,10003636,10003658,10003637,10003638,11534,11539,11538,11527,11522,11524,11559,11521,11567,11560,11526,11536,3896603,11528,11535,11537,11959,11948,11910,11909,11965,11963,11947,11922,11921,11950,11914,11920,11946,11937,11956,11929,11935,11923,11936,11926,11927,11918,11966,11971,11972,11931,11928,11953,11930,11924,11954,11955,11942,11932,3239518,12146,12115,12122,12133,12531,12143,12116,12129,12138,12136,12118,12163,12164,12155,12152,12525,3552351,12162,12154,5099244,3552346,3190431,12157,3552350,3238735,12110,3552345,3552348,3552347,12120,12123,12135,12137,12140,12099,12098,12117,12108,12151,12134,12109,12156,12106,12126,12132,3190432,12158,12103,12139,3552349,12114,12111,12160,12112,11409,11195,11196,11191,11194,11190,3192509,11197,6944,6971,12312,12321,6973,12320,6953,12309,6955,6957,6963,6948,12304,6969,6945,6966,6951,6968,6949,12305,6958,6959,6970,6974,12324,12342,6946,6956,6964,6954,6967,12319,12333,6965,12323,12316,6961,12318,6972,6962,6960,12329,12311,6947,12478,12548,12464,12539,12535,12532,12555,12472,12489,12505,12503,12508,12526,12544,12530,12537,12463,12491,12547,12519,12480,12542,12551,12477,12469,3239510,12528,12507,3239509,12510,3239507,3239508,12522,12543,12502,12546,12552,12538,12465,29785444,29785442) AND o_published = 1)) AND (needAcco is null or needAcco = 0) AND (object_localized_11_en.o_id in (select o_parentId from object_10 where packageOnly is null or packageOnly = 0)) AND (object_localized_11_en.o_id in (select o_id from object_collection_demiDate_11 where (object_collection_demiDate_11.to > 1738364400 and object_collection_demiDate_11.from < 1769900400))) AND (dates.to > 1738364400) AND object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1 ORDER BY dates.from ASC, dates.to ASC, times.time ASC, `order`
Parameters:
[] |
|
8.33 ms (14.61%) |
39 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 3189171 ] |
|
6.90 ms (12.10%) |
41 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
4099
]
|
|
5.42 ms (9.51%) |
14 |
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
Parameters:
[
11420
]
|
|
2.61 ms (4.57%) |
36 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
1.11 ms (1.95%) |
11 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
|
0.92 ms (1.61%) |
1 |
SELECT object_localized_11_en.o_id as o_id, object_localized_11_en.o_type as o_type FROM object_localized_11_en WHERE (o_id in (19910395,11616598,27736061,14043963,16540678,16540678,16540678,16540678,16540678,19400317,19400317,19400317,19400317,19400317,38343234,13690328,36362226,36362390,36519347,1395031,33905068,33905076,33905076,34776154,35522101,35522111,35522237,30724860,43782063,13135550,2566344,47602667,49587230,42315304,42315304,42315304,42315304,42315304,1394939,1394939,36091522,36091535,36091545,36091555,36091565,41971460,36091522,36091535,36091545,36091555,36091565) AND object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1 ORDER BY FIELD(o_id, 19910395,11616598,27736061,14043963,16540678,16540678,16540678,16540678,16540678,19400317,19400317,19400317,19400317,19400317,38343234,13690328,36362226,36362390,36519347,1395031,33905068,33905076,33905076,34776154,35522101,35522111,35522237,30724860,43782063,13135550,2566344,47602667,49587230,42315304,42315304,42315304,42315304,42315304,1394939,1394939,36091522,36091535,36091545,36091555,36091565,41971460,36091522,36091535,36091545,36091555,36091565) LIMIT 8 OFFSET 32
Parameters:
[] |
|
0.58 ms (1.01%) |
1 |
SELECT COUNT(*) FROM object_localized_11_en WHERE (o_id in (19910395,11616598,27736061,14043963,16540678,16540678,16540678,16540678,16540678,19400317,19400317,19400317,19400317,19400317,38343234,13690328,36362226,36362390,36519347,1395031,33905068,33905076,33905076,34776154,35522101,35522111,35522237,30724860,43782063,13135550,2566344,47602667,49587230,42315304,42315304,42315304,42315304,42315304,1394939,1394939,36091522,36091535,36091545,36091555,36091565,41971460,36091522,36091535,36091545,36091555,36091565) AND object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1
Parameters:
[] |
|
0.50 ms (0.89%) |
2 |
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:
[ "defaultSiteConfig" null null ] |
|
0.42 ms (0.73%) |
6 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Holidays-in-spring" "path" => "/steiermark.com/en/Plan-your-holiday/" ] |
|
0.35 ms (0.61%) |
4 |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/steiermark.com/%" "/en/Plan-your-holiday/Holidays-in-spring" ] |
|
0.35 ms (0.61%) |
4 |
SELECT id FROM sites
Parameters:
[] |
|
0.31 ms (0.55%) |
1 |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/en/Plan-your-holiday/Holidays-in-spring" "sourcePathQuery" => "/en/Plan-your-holiday/Holidays-in-spring?page=5" "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Holidays-in-spring?page=5" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.30 ms (0.52%) |
2 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
|
0.26 ms (0.45%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
|
0.22 ms (0.39%) |
4 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/Plan-your-holiday/Holidays-in-spring" ] |
|
0.18 ms (0.31%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 4099 4099 ] |
|
0.17 ms (0.29%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.14 ms (0.25%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 208 4099 4099 ] |
|
0.14 ms (0.25%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
|
0.13 ms (0.22%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Holidays-in-spring' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.11 ms (0.19%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.09 ms (0.15%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
4099
]
|
|
0.07 ms (0.12%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Holidays-in-spring' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
demi_vacancies connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| demi_vacancies | doctrine.dbal.demi_vacancies_connection |
Entity Managers
| Name | Service |
|---|---|
| portal_engine | doctrine.orm.portal_engine_entity_manager |
| pimcore_direct_edit | doctrine.orm.pimcore_direct_edit_entity_manager |
| statistics_explorer | doctrine.orm.statistics_explorer_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
portal_engine entity manager
No loaded entities.
pimcore_direct_edit entity manager
No loaded entities.
statistics_explorer entity manager
No loaded entities.