https://stage.steiermark.com/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AdefaultAction

Method
GET
HTTP Status
200
IP
18.190.160.6
Profiled on
Token
550f23

Query Metrics

200 Database Queries
53 Different statements
113.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
54.40 ms
(48.07%) 		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 ((o_parentId in (select o_id from object_12 where town__id in (11550,11552,11546,11938,11563,11553,11561,11562,11540,11554,11551,3896604,11548,11547,11545,11543,11549,11550,11552,11546,11938,11563,11553,11561,11562,11540,11551,11554,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,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) 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 > 1732575600 and object_collection_demiDate_11.from < 1764111600)))  AND (dates.to > 1732575600)  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: 
[]
View formatted query    View runnable query    Explain query
5.73 ms
(5.06%) 		24 
SELECT object_39.o_id as o_id, object_39.o_type as o_type FROM object_39 WHERE fid='bbe9dd0c-d667-443b-aff7-ffe61920774b' AND  object_39.o_type IN ('object') ORDER BY `o_published` DESC   LIMIT 2
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.81 ms
(3.37%) 		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 (2566824,2566859,2589081,2589127,2589153,2589170,38973787,275894,275894,275894,7780383,8086279,8086279,8086279,8086279,8167001,11031281,11031294,11031820,13400308,11031319,11031319,19910387,19910395,17015714,11616598,27736061,14043963,15659562,16540678,16540678,16540678,16540678,16540678,23813976,19400317,19400317,19400317,19400317,19400317,19764417,20709029,6052991,6053007,11283166,7362863,31833558,7362256,26934679,14043580,38343234,13690328,14076362,36362226,36362390,36519347,14383736,26934343,26934343,27152704,27152704,26608409,14624161,1992169,16306208,30095488,30177961,30177986,30178011,30440781,1395031,14012808,14012808,32621795,32701752,33904980,33905060,33905060,33905068,34345077,34345077,34345077,34345077,34345077,34345077,34345077,33905076,33905076,35522253,35522253,35522370,35522381,35522381,34776154,35522101,35522111,35522237,35617545,35617545,35617545,35617545,35617762,35617762,35617749,35617749,35617749,35700739,35753917,35753939,35618095,35908970,35908970,35950683,35950683,35950693,35950693,35753965,35753965,35753965,35753965,35617857,35992211,37709964,37709989,36035024,36034312,35991002,31037202,31037216,39269169,14849580,39269181,14913999,33102160,34554520,34554787,34554798,34554809,34554891,34554901,34554911,34554921,34554933,34554943,34554953,32703242,1394856,5161458,5161469,5161545,5161545,5161545,36862814,36862814,36862814,36862814,36862814,36863094,36278469,14914328,25414333,25414333,2591921,34066094,34066094,41971814,1395640,1395640,20709274,35659220,30724860,43782063,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,15374855,13979816,32621915,32662775,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,18471669,18471669,32938522,1394832,1394832,15135646,15135646,27152995,49259082,12630589,4065525,12586588,12586588,12585349,14012026,14012026,14012026,14012026,14012026,14012026,14012026,14012026,12592028,12592734,12593305,12594035,13818514,13818514,13818514,13818514,32662788,32662994,4065687,14557577,14557577,14557577,14557577,14557577,14557577,14557577,32663119,14075457,12944069,12944069,12944069,12944069,4443383,18701851,14012222,14012222,11653373,11653373,11653373,11653373,11653373,12630144,12630144,14415073,16306584,30724966,7512454,7512465,7512476,1394939,1394939,1394953,1394953,33704134,41413607,1394889,1394889,1395702,7901762,41619135,33059583,33059583,33059583,33059583,33059583,33059583,1395449,1395437,25414130,25414130,1395381,1395405,1395418,15135590,42315304,42315304,42315304,42315304,42315304,27946232,28019291,42493377,42493388,42698003,42698003,42698003,42698003,42698003,42698003,42698003,42698003,5161489,42698697,42697666,42698459,42742362,42742368,42742362,42742368,42742362,42742368,42742362,42742368,18433001,18433001,42830497,42830507,42830497,42830507,42830497,42830507,42830507,42830625,42830625,42830625,42830625,41795373,45440858,33333444,36091522,36091535,36091545,36091555,36091565,13135550,41618828,41618828,30177417,43691625,43692182,43692182,296666,296666,43782440,44225083,44225083,44225162,44225172,44282241,1395169,2566344,33372294,44281504,44386516,44386716,5225154,275323,44573470,44869975,2405566,2405566,4063990,14383060,14383060,14383060,14383060,14383060,14383060,14383060,14660106,45440191,45440475,45489235,45538356,2766521,45583273,45583273,45583424,45583823,45747038,45932156,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,46238539,46460933,46460933,46460933,46460933,36908177,36908177,36908177,36908177,36908177,46648624,46648633,46648633,46648633,46648633,46648633,46648633,46648633,47201129,47559716,47602667,47293285,29829605,36034380,36034380,48569434,48569434,49168160,49304735,49304735,49304735,49305181,49305181,49305181,1395480,25760379,25760379,7049765,49587230,49680138,14383078,49969402,49827307,50158516,50158516,50535697,50584068,50678715,47604426,47604448,46095619,46095619,46097099,46097099,46766359,46766359,43692959,35618106,35700663,1394970,16110763,42653256,38505363,38344039,51021659,49827753,37667199,43442351,31037686,41970851,45840895,46298178,50253494,50584232,35659220,45840895,42315304,42315304,42315304,42315304,42315304,1394361,1394939,1394939,1394953,1394953,19593264,38211017,50584232,46298178,19593264,38211017,50584232,50584232,50584232,9314968,36091522,36091535,36091545,36091555,36091565,9924716,9314968,42994525,35700752,35700641,35700641,35700641,41971460,26060191,26060191,41971421,35618106,35700663,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, 2566824,2566859,2589081,2589127,2589153,2589170,38973787,275894,275894,275894,7780383,8086279,8086279,8086279,8086279,8167001,11031281,11031294,11031820,13400308,11031319,11031319,19910387,19910395,17015714,11616598,27736061,14043963,15659562,16540678,16540678,16540678,16540678,16540678,23813976,19400317,19400317,19400317,19400317,19400317,19764417,20709029,6052991,6053007,11283166,7362863,31833558,7362256,26934679,14043580,38343234,13690328,14076362,36362226,36362390,36519347,14383736,26934343,26934343,27152704,27152704,26608409,14624161,1992169,16306208,30095488,30177961,30177986,30178011,30440781,1395031,14012808,14012808,32621795,32701752,33904980,33905060,33905060,33905068,34345077,34345077,34345077,34345077,34345077,34345077,34345077,33905076,33905076,35522253,35522253,35522370,35522381,35522381,34776154,35522101,35522111,35522237,35617545,35617545,35617545,35617545,35617762,35617762,35617749,35617749,35617749,35700739,35753917,35753939,35618095,35908970,35908970,35950683,35950683,35950693,35950693,35753965,35753965,35753965,35753965,35617857,35992211,37709964,37709989,36035024,36034312,35991002,31037202,31037216,39269169,14849580,39269181,14913999,33102160,34554520,34554787,34554798,34554809,34554891,34554901,34554911,34554921,34554933,34554943,34554953,32703242,1394856,5161458,5161469,5161545,5161545,5161545,36862814,36862814,36862814,36862814,36862814,36863094,36278469,14914328,25414333,25414333,2591921,34066094,34066094,41971814,1395640,1395640,20709274,35659220,30724860,43782063,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,15374855,13979816,32621915,32662775,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,18471669,18471669,32938522,1394832,1394832,15135646,15135646,27152995,49259082,12630589,4065525,12586588,12586588,12585349,14012026,14012026,14012026,14012026,14012026,14012026,14012026,14012026,12592028,12592734,12593305,12594035,13818514,13818514,13818514,13818514,32662788,32662994,4065687,14557577,14557577,14557577,14557577,14557577,14557577,14557577,32663119,14075457,12944069,12944069,12944069,12944069,4443383,18701851,14012222,14012222,11653373,11653373,11653373,11653373,11653373,12630144,12630144,14415073,16306584,30724966,7512454,7512465,7512476,1394939,1394939,1394953,1394953,33704134,41413607,1394889,1394889,1395702,7901762,41619135,33059583,33059583,33059583,33059583,33059583,33059583,1395449,1395437,25414130,25414130,1395381,1395405,1395418,15135590,42315304,42315304,42315304,42315304,42315304,27946232,28019291,42493377,42493388,42698003,42698003,42698003,42698003,42698003,42698003,42698003,42698003,5161489,42698697,42697666,42698459,42742362,42742368,42742362,42742368,42742362,42742368,42742362,42742368,18433001,18433001,42830497,42830507,42830497,42830507,42830497,42830507,42830507,42830625,42830625,42830625,42830625,41795373,45440858,33333444,36091522,36091535,36091545,36091555,36091565,13135550,41618828,41618828,30177417,43691625,43692182,43692182,296666,296666,43782440,44225083,44225083,44225162,44225172,44282241,1395169,2566344,33372294,44281504,44386516,44386716,5225154,275323,44573470,44869975,2405566,2405566,4063990,14383060,14383060,14383060,14383060,14383060,14383060,14383060,14660106,45440191,45440475,45489235,45538356,2766521,45583273,45583273,45583424,45583823,45747038,45932156,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,46238539,46460933,46460933,46460933,46460933,36908177,36908177,36908177,36908177,36908177,46648624,46648633,46648633,46648633,46648633,46648633,46648633,46648633,47201129,47559716,47602667,47293285,29829605,36034380,36034380,48569434,48569434,49168160,49304735,49304735,49304735,49305181,49305181,49305181,1395480,25760379,25760379,7049765,49587230,49680138,14383078,49969402,49827307,50158516,50158516,50535697,50584068,50678715,47604426,47604448,46095619,46095619,46097099,46097099,46766359,46766359,43692959,35618106,35700663,1394970,16110763,42653256,38505363,38344039,51021659,49827753,37667199,43442351,31037686,41970851,45840895,46298178,50253494,50584232,35659220,45840895,42315304,42315304,42315304,42315304,42315304,1394361,1394939,1394939,1394953,1394953,19593264,38211017,50584232,46298178,19593264,38211017,50584232,50584232,50584232,9314968,36091522,36091535,36091545,36091555,36091565,9924716,9314968,42994525,35700752,35700641,35700641,35700641,41971460,26060191,26060191,41971421,35618106,35700663,36091522,36091535,36091545,36091555,36091565)    LIMIT 8 OFFSET 8
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.76 ms
(3.32%) 		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: 
[
  11512
]
View formatted query    View runnable query    Explain query
3.68 ms
(3.26%) 		1 
SELECT COUNT(*) FROM object_localized_11_en WHERE (o_id in (2566824,2566859,2589081,2589127,2589153,2589170,38973787,275894,275894,275894,7780383,8086279,8086279,8086279,8086279,8167001,11031281,11031294,11031820,13400308,11031319,11031319,19910387,19910395,17015714,11616598,27736061,14043963,15659562,16540678,16540678,16540678,16540678,16540678,23813976,19400317,19400317,19400317,19400317,19400317,19764417,20709029,6052991,6053007,11283166,7362863,31833558,7362256,26934679,14043580,38343234,13690328,14076362,36362226,36362390,36519347,14383736,26934343,26934343,27152704,27152704,26608409,14624161,1992169,16306208,30095488,30177961,30177986,30178011,30440781,1395031,14012808,14012808,32621795,32701752,33904980,33905060,33905060,33905068,34345077,34345077,34345077,34345077,34345077,34345077,34345077,33905076,33905076,35522253,35522253,35522370,35522381,35522381,34776154,35522101,35522111,35522237,35617545,35617545,35617545,35617545,35617762,35617762,35617749,35617749,35617749,35700739,35753917,35753939,35618095,35908970,35908970,35950683,35950683,35950693,35950693,35753965,35753965,35753965,35753965,35617857,35992211,37709964,37709989,36035024,36034312,35991002,31037202,31037216,39269169,14849580,39269181,14913999,33102160,34554520,34554787,34554798,34554809,34554891,34554901,34554911,34554921,34554933,34554943,34554953,32703242,1394856,5161458,5161469,5161545,5161545,5161545,36862814,36862814,36862814,36862814,36862814,36863094,36278469,14914328,25414333,25414333,2591921,34066094,34066094,41971814,1395640,1395640,20709274,35659220,30724860,43782063,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,15374855,13979816,32621915,32662775,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,13948248,18471669,18471669,32938522,1394832,1394832,15135646,15135646,27152995,49259082,12630589,4065525,12586588,12586588,12585349,14012026,14012026,14012026,14012026,14012026,14012026,14012026,14012026,12592028,12592734,12593305,12594035,13818514,13818514,13818514,13818514,32662788,32662994,4065687,14557577,14557577,14557577,14557577,14557577,14557577,14557577,32663119,14075457,12944069,12944069,12944069,12944069,4443383,18701851,14012222,14012222,11653373,11653373,11653373,11653373,11653373,12630144,12630144,14415073,16306584,30724966,7512454,7512465,7512476,1394939,1394939,1394953,1394953,33704134,41413607,1394889,1394889,1395702,7901762,41619135,33059583,33059583,33059583,33059583,33059583,33059583,1395449,1395437,25414130,25414130,1395381,1395405,1395418,15135590,42315304,42315304,42315304,42315304,42315304,27946232,28019291,42493377,42493388,42698003,42698003,42698003,42698003,42698003,42698003,42698003,42698003,5161489,42698697,42697666,42698459,42742362,42742368,42742362,42742368,42742362,42742368,42742362,42742368,18433001,18433001,42830497,42830507,42830497,42830507,42830497,42830507,42830507,42830625,42830625,42830625,42830625,41795373,45440858,33333444,36091522,36091535,36091545,36091555,36091565,13135550,41618828,41618828,30177417,43691625,43692182,43692182,296666,296666,43782440,44225083,44225083,44225162,44225172,44282241,1395169,2566344,33372294,44281504,44386516,44386716,5225154,275323,44573470,44869975,2405566,2405566,4063990,14383060,14383060,14383060,14383060,14383060,14383060,14383060,14660106,45440191,45440475,45489235,45538356,2766521,45583273,45583273,45583424,45583823,45747038,45932156,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,46238539,46460933,46460933,46460933,46460933,36908177,36908177,36908177,36908177,36908177,46648624,46648633,46648633,46648633,46648633,46648633,46648633,46648633,47201129,47559716,47602667,47293285,29829605,36034380,36034380,48569434,48569434,49168160,49304735,49304735,49304735,49305181,49305181,49305181,1395480,25760379,25760379,7049765,49587230,49680138,14383078,49969402,49827307,50158516,50158516,50535697,50584068,50678715,47604426,47604448,46095619,46095619,46097099,46097099,46766359,46766359,43692959,35618106,35700663,1394970,16110763,42653256,38505363,38344039,51021659,49827753,37667199,43442351,31037686,41970851,45840895,46298178,50253494,50584232,35659220,45840895,42315304,42315304,42315304,42315304,42315304,1394361,1394939,1394939,1394953,1394953,19593264,38211017,50584232,46298178,19593264,38211017,50584232,50584232,50584232,9314968,36091522,36091535,36091545,36091555,36091565,9924716,9314968,42994525,35700752,35700641,35700641,35700641,41971460,26060191,26060191,41971421,35618106,35700663,36091522,36091535,36091545,36091555,36091565) AND  object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.62 ms
(3.20%) 		3 
SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 8167001)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.57 ms
(3.16%) 		3 
SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 7780383)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.16 ms
(2.79%) 		3 
SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 8086279)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.10 ms
(2.74%) 		3 
SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 11031319)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.04 ms
(2.68%) 		3 
SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 13400308)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.00 ms
(2.65%) 		3 
SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 11031281)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.76 ms
(2.44%) 		3 
SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 11031294)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.74 ms
(2.42%) 		3 
SELECT min(price) p from object_collection_demiPricePrice_58 WHERE o_id in (select o_id from object_58 where o_published = 1 and o_id in
            (select dest_id from object_relations_10 where src_id in
            (select o_id from object_10 where o_published = 1 and o_id in
            (select dest_id from object_relations_11 where src_id = 11031820)
            and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.51 ms
(2.22%) 		31 
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters: 
[
  "id" => "reports"
  "scope" => "pimcore"
]
View formatted query    View runnable query    Explain query
1.78 ms
(1.57%) 		3 
SELECT COUNT(*) FROM object_localized_Region_en WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id
                              from object_31
                              where filterElements LIKE :demiRegionId AND o_key != "Steiermark"))  AND  object_localized_Region_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1
Parameters: 
[
  "demiRegionId" => "%,11420%"
]
View formatted query    View runnable query    Explain query
1.42 ms
(1.25%) 		3 
SELECT object_localized_Region_en.o_id as o_id, object_localized_Region_en.o_type as o_type FROM object_localized_Region_en WHERE ((IFNULL(isLive,0) = 1 and demiFilterObject__id IN (select o_id
                              from object_31
                              where filterElements LIKE :demiRegionId AND o_key != "Steiermark"))  AND  object_localized_Region_en.o_type IN ('object','folder')) AND object_localized_Region_en.o_published = 1 LIMIT 1
Parameters: 
[
  "demiRegionId" => "%,11420%"
]
View formatted query    View runnable query    Explain query
1.26 ms
(1.12%) 		11 
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters: 
[
  "cid" => 3189171
]
View formatted query    View runnable query    Explain query
1.24 ms
(1.09%) 		13 
SELECT name FROM classes WHERE id = ?
Parameters: 
[
  "SiteConfig"
]
View formatted query    View runnable query    Explain query
1.10 ms
(0.97%) 		8 
SELECT * FROM object_collection_demiDate_11 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters: 
[
  7780383
  "dates"
]
View formatted query    View runnable query    Explain query
0.83 ms
(0.73%) 		8 
SELECT * FROM object_collection_demiStartTime_11 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters: 
[
  7780383
  "startTime"
]
View formatted query    View runnable query    Explain query
0.72 ms
(0.64%) 		4 
SELECT * FROM documents_editables WHERE documentId = ?
Parameters: 
[
  4092
]
View formatted query    View runnable query    Explain query
0.57 ms
(0.51%) 		6 
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters: 
[
  "key" => "Travel-shop"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
View formatted query    View runnable query    Explain query
0.57 ms
(0.51%) 		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
]
View formatted query    View runnable query    Explain query
0.51 ms
(0.45%) 		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/Travel-shop"
]
View formatted query    View runnable query    Explain query
0.45 ms
(0.40%) 		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/Travel-shop"
  "sourcePathQuery" => "/en/Plan-your-holiday/Travel-shop?page=2"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Travel-shop?page=2"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
View formatted query    View runnable query    Explain query
0.33 ms
(0.29%) 		4 
SELECT id FROM sites
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.33 ms
(0.29%) 		4 
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters: 
[
  "prettyUrl" => "/en/Plan-your-holiday/Travel-shop"
]
View formatted query    View runnable query    Explain query
0.25 ms
(0.23%) 		3 
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters: 
[
  8167055
]
View formatted query    View runnable query    Explain query
0.24 ms
(0.21%) 		2 
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters: 
[
  4092
  4092
]
View formatted query    View runnable query    Explain query
0.20 ms
(0.18%) 		1 
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters: 
[
  196
  4092
  4092
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.17%) 		1 
SELECT * FROM object_localized_data_27 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters: 
[
  8167055
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.17%) 		3 
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters: 
[
  8167055
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.16%) 		1 
SELECT * FROM translations_messages LIMIT 1;
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.16 ms
(0.14%) 		1 
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Travel-shop' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.16 ms
(0.14%) 		2 
SELECT * FROM website_settings WHERE id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.15 ms
(0.14%) 		1 
SELECT * FROM object_localized_data_10 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters: 
[
  8167057
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.11%) 		1 
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.12 ms
(0.10%) 		1 
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters: 
[
  4092
]
View formatted query    View runnable query    Explain query
0.10 ms
(0.09%) 		1 
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Travel-shop' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.10 ms
(0.09%) 		1 
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters: 
[
  8167059
  "prices"
]
View formatted query    View runnable query    Explain query
0.10 ms
(0.09%) 		1 
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters: 
[
  8167059
  "mealTypes"
]
View formatted query    View runnable query    Explain query
0.10 ms
(0.08%) 		1 
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters: 
[
  8167059
  "prices"
]
View formatted query    View runnable query    Explain query
0.09 ms
(0.08%) 		1 
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters: 
[
  8167059
  "periods"
]
View formatted query    View runnable query    Explain query
0.09 ms
(0.08%) 		1 
SELECT id FROM settings_store WHERE scope = ?
Parameters: 
[
  "pimcore_staticroutes"
]
View formatted query    View runnable query    Explain query
0.08 ms
(0.07%) 		1 
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters: 
[
  8167059
]
View formatted query    View runnable query    Explain query
0.08 ms
(0.07%) 		1 
SELECT * FROM object_relations_10 WHERE src_id = ?
Parameters: 
[
  8167057
]
View formatted query    View runnable query    Explain query
0.07 ms
(0.06%) 		1 
SELECT * FROM object_store_27 WHERE oo_id = ?
Parameters: 
[
  8167055
]
View formatted query    View runnable query    Explain query
0.07 ms
(0.06%) 		1 
SELECT * FROM object_relations_27 WHERE src_id = ?
Parameters: 
[
  8167055
]
View formatted query    View runnable query    Explain query
0.07 ms
(0.06%) 		1 
SELECT * FROM object_brick_store_desklineDummyProduct_10 WHERE o_id = ? AND fieldname = ?
Parameters: 
[
  8167057
  "demiExtension"
]
View formatted query    View runnable query    Explain query
0.07 ms
(0.06%) 		1 
SELECT * FROM object_store_10 WHERE oo_id = ?
Parameters: 
[
  8167057
]
View formatted query    View runnable query    Explain query
0.06 ms
(0.06%) 		1 
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters: 
[
  8167059
]
View formatted query    View runnable query    Explain query
0.05 ms
(0.05%) 		1 
SELECT * FROM object_brick_store_demiMerchPEX_10 WHERE o_id = ? AND fieldname = ?
Parameters: 
[
  8167057
  "demiExtension"
]
View formatted query    View runnable query    Explain query
0.05 ms
(0.04%) 		1 
SELECT * FROM object_brick_store_demiMerchandiseProductExtension_10 WHERE o_id = ? AND fieldname = ?
Parameters: 
[
  8167057
  "demiExtension"
]
View formatted query    View runnable query    Explain query

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.