Query Metrics
774
Database Queries
85
Different statements
189.76 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
15.21 ms (8.02%) |
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 (11465,11466,11464,11463,1612603,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,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 (object_localized_11_en.o_id in (select src_id from object_relations_11 where dest_id in (14628056,11181))) 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 > 1732834800 and object_collection_demiDate_11.from < 1764370800))) AND (dates.to > 1732834800) 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:
[] |
|
12.50 ms (6.59%) |
52 |
SELECT * FROM object_localized_data_27 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
13369873
]
|
|
10.28 ms (5.42%) |
28 |
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:
[] |
|
8.71 ms (4.59%) |
71 |
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:
[
6075878
]
|
|
8.50 ms (4.48%) |
34 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 3189171 ] |
|
8.29 ms (4.37%) |
52 |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
1453147
]
|
|
8.03 ms (4.23%) |
71 |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
6075878
]
|
|
7.99 ms (4.21%) |
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:
[
11462
]
|
|
7.76 ms (4.09%) |
10 |
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" => "%,12089%" ] |
|
7.10 ms (3.74%) |
52 |
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
1453147
]
|
|
5.78 ms (3.05%) |
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 = 42830625) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.74 ms (3.03%) |
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 = 44225083) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.62 ms (2.96%) |
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 = 44225162) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.45 ms (2.87%) |
10 |
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" => "%,12089%" ] |
|
5.38 ms (2.84%) |
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 = 44225172) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.24 ms (2.76%) |
52 |
SELECT * FROM object_relations_27 WHERE src_id = ?
Parameters:
[
13369873
]
|
|
5.17 ms (2.73%) |
52 |
SELECT * FROM object_store_27 WHERE oo_id = ?
Parameters:
[
13369873
]
|
|
4.93 ms (2.60%) |
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 = 1395169) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
3.88 ms (2.04%) |
37 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
3.39 ms (1.78%) |
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 = 29829605) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
3.38 ms (1.78%) |
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 = 5225154) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
3.30 ms (1.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 = 45932156) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
2.77 ms (1.46%) |
14 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
4617
]
|
|
2.69 ms (1.42%) |
18 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
|
1.94 ms (1.02%) |
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 (11031319,11031319,19910387,19910395,17015714,16540678,16540678,16540678,16540678,16540678,20709029,27152704,27152704,26608409,35753917,1394856,5161458,5161469,5161545,5161545,5161545,36862814,36862814,36862814,36862814,36862814,25414333,25414333,2591921,34066094,34066094,12630589,4065687,4443383,12630144,12630144,1394939,1394939,1394889,1394889,1395437,25414130,25414130,1395381,1395405,27946232,28019291,42698003,42698003,42698003,42698003,42698003,42698003,42698003,42698003,5161489,42698697,42697666,42742362,42742368,42742362,42742368,42742362,42742368,42742362,42742368,18433001,18433001,42830625,42830625,42830625,42830625,44225083,44225083,44225162,44225172,1395169,44281504,5225154,45747038,45932156,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,46460933,46460933,46460933,46460933,29829605,1395480,25760379,25760379,49827307,50158516,50158516,47604426,47604448,46097099,46097099,46766359,46766359,1394970,16110763,51021659,1394939,1394939) AND object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1 ORDER BY FIELD(o_id, 11031319,11031319,19910387,19910395,17015714,16540678,16540678,16540678,16540678,16540678,20709029,27152704,27152704,26608409,35753917,1394856,5161458,5161469,5161545,5161545,5161545,36862814,36862814,36862814,36862814,36862814,25414333,25414333,2591921,34066094,34066094,12630589,4065687,4443383,12630144,12630144,1394939,1394939,1394889,1394889,1395437,25414130,25414130,1395381,1395405,27946232,28019291,42698003,42698003,42698003,42698003,42698003,42698003,42698003,42698003,5161489,42698697,42697666,42742362,42742368,42742362,42742368,42742362,42742368,42742362,42742368,18433001,18433001,42830625,42830625,42830625,42830625,44225083,44225083,44225162,44225172,1395169,44281504,5225154,45747038,45932156,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,46460933,46460933,46460933,46460933,29829605,1395480,25760379,25760379,49827307,50158516,50158516,47604426,47604448,46097099,46097099,46766359,46766359,1394970,16110763,51021659,1394939,1394939) LIMIT 12 OFFSET 36
Parameters:
[] |
|
1.91 ms (1.01%) |
10 |
SELECT * FROM object_collection_demiDate_11 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42830625 "dates" ] |
|
1.61 ms (0.85%) |
1 |
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 = 46460933) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
1.52 ms (0.80%) |
1 |
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 = 45747038) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
1.45 ms (0.77%) |
10 |
SELECT * FROM object_collection_demiStartTime_11 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 42830625 "startTime" ] |
|
1.39 ms (0.73%) |
3 |
SELECT * FROM object_localized_data_45 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
6075878
]
|
|
1.33 ms (0.70%) |
1 |
SELECT COUNT(*) FROM object_localized_11_en WHERE (o_id in (11031319,11031319,19910387,19910395,17015714,16540678,16540678,16540678,16540678,16540678,20709029,27152704,27152704,26608409,35753917,1394856,5161458,5161469,5161545,5161545,5161545,36862814,36862814,36862814,36862814,36862814,25414333,25414333,2591921,34066094,34066094,12630589,4065687,4443383,12630144,12630144,1394939,1394939,1394889,1394889,1395437,25414130,25414130,1395381,1395405,27946232,28019291,42698003,42698003,42698003,42698003,42698003,42698003,42698003,42698003,5161489,42698697,42697666,42742362,42742368,42742362,42742368,42742362,42742368,42742362,42742368,18433001,18433001,42830625,42830625,42830625,42830625,44225083,44225083,44225162,44225172,1395169,44281504,5225154,45747038,45932156,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,45884637,46460933,46460933,46460933,46460933,29829605,1395480,25760379,25760379,49827307,50158516,50158516,47604426,47604448,46097099,46097099,46766359,46766359,1394970,16110763,51021659,1394939,1394939) AND object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1
Parameters:
[] |
|
1.32 ms (0.70%) |
1 |
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 = 45884637) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
1.30 ms (0.69%) |
1 |
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 = 44281504) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
0.96 ms (0.50%) |
7 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Culinary-experiences" "path" => "/steiermark.com/en/Styria/Experience-Styrias-cuisine/" ] |
|
0.89 ms (0.47%) |
4 |
SELECT * FROM object_localized_data_10 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
44225177
]
|
|
0.74 ms (0.39%) |
5 |
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/Styria/Experience-Styrias-cuisine/Culinary-experiences" ] |
|
0.69 ms (0.36%) |
5 |
SELECT * FROM object_store_12 WHERE oo_id = ?
Parameters:
[
42830494
]
|
|
0.69 ms (0.36%) |
3 |
SELECT * FROM object_relations_45 WHERE src_id = ?
Parameters:
[
6075878
]
|
|
0.64 ms (0.34%) |
4 |
SELECT id FROM sites
Parameters:
[] |
|
0.61 ms (0.32%) |
3 |
SELECT * FROM object_store_45 WHERE oo_id = ?
Parameters:
[
6075878
]
|
|
0.54 ms (0.29%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/Styria/Experience-Styrias-cuisine/Culinary-experiences" ] |
|
0.53 ms (0.28%) |
5 |
SELECT * FROM object_relations_12 WHERE src_id = ?
Parameters:
[
42830494
]
|
|
0.52 ms (0.28%) |
4 |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 44225179 "mealTypes" ] |
|
0.48 ms (0.25%) |
4 |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 44225179 "periods" ] |
|
0.46 ms (0.24%) |
3 |
SELECT * FROM object_collection_demiCapacityCeremony_45 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 6075878 "capacityCeremonies" ] |
|
0.45 ms (0.24%) |
4 |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 44225179 "prices" ] |
|
0.45 ms (0.24%) |
4 |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 44225179 "prices" ] |
|
0.45 ms (0.24%) |
4 |
SELECT * FROM object_relations_10 WHERE src_id = ?
Parameters:
[
44225177
]
|
|
0.43 ms (0.23%) |
3 |
SELECT * FROM object_collection_demiOperationSchedule_45 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 6075878 "operationSchedule" ] |
|
0.42 ms (0.22%) |
2 |
SELECT * FROM object_relations_11 WHERE src_id = ?
Parameters:
[
44225172
]
|
|
0.40 ms (0.21%) |
4 |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
44225179
]
|
|
0.40 ms (0.21%) |
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.40 ms (0.21%) |
3 |
SELECT * FROM object_collection_demiDishRates_45 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 6075878 "dishRates" ] |
|
0.38 ms (0.20%) |
2 |
SELECT * FROM object_localized_data_11 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
44225172
]
|
|
0.37 ms (0.19%) |
4 |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
44225179
]
|
|
0.36 ms (0.19%) |
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/Styria/Experience-Styrias-cuisine/Culinary-experiences" "sourcePathQuery" => "/en/Styria/Experience-Styrias-cuisine/Culinary-experiences?page=4" "sourceEntireUri" => "https://stage.steiermark.com/en/Styria/Experience-Styrias-cuisine/Culinary-experiences?page=4" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.35 ms (0.18%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
4617
]
|
|
0.34 ms (0.18%) |
5 |
SELECT * FROM object_brick_store_demiYoungStyria_12 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 42830494 "demiExtension" ] |
|
0.33 ms (0.18%) |
4 |
SELECT * FROM object_store_10 WHERE oo_id = ?
Parameters:
[
44225177
]
|
|
0.33 ms (0.17%) |
3 |
SELECT * FROM object_brick_store_demiLegacyId_45 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.32 ms (0.17%) |
4 |
SELECT * FROM object_brick_store_desklineDummyProduct_10 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 44225177 "demiExtension" ] |
|
0.31 ms (0.16%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.31 ms (0.16%) |
1 |
SELECT * FROM object_brick_localized_demiExternalLink_45 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk') AND `fieldname` = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.30 ms (0.16%) |
3 |
SELECT * FROM object_brick_store_demiCanonicalRegion_45 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.27 ms (0.14%) |
3 |
SELECT * FROM object_brick_store_demiInfrastructureSommerCardExtension_45 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.27 ms (0.14%) |
3 |
SELECT * FROM object_brick_store_demiAccessibilityCategories_45 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.26 ms (0.14%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 4617 4617 ] |
|
0.26 ms (0.14%) |
3 |
SELECT * FROM object_brick_store_SchladmingAS_45 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.26 ms (0.13%) |
4 |
SELECT * FROM object_brick_store_demiMerchandiseProductExtension_10 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 44225177 "demiExtension" ] |
|
0.26 ms (0.13%) |
3 |
SELECT * FROM object_brick_store_demiBergfexLake_45 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.25 ms (0.13%) |
3 |
SELECT * FROM object_brick_store_demiExternalLink_45 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.25 ms (0.13%) |
3 |
SELECT * FROM object_brick_store_demiYoungStyria_45 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 6075878 "demiExtension" ] |
|
0.25 ms (0.13%) |
4 |
SELECT * FROM object_brick_store_demiMerchPEX_10 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 44225177 "demiExtension" ] |
|
0.22 ms (0.12%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 106 4617 4617 ] |
|
0.20 ms (0.11%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Styria/Experience-Styrias-cuisine/Culinary-experiences' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.18 ms (0.09%) |
2 |
SELECT * FROM object_store_11 WHERE oo_id = ?
Parameters:
[
44225172
]
|
|
0.16 ms (0.09%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
|
0.15 ms (0.08%) |
2 |
SELECT * FROM object_brick_store_demiMerchServEX_11 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 44225172 "demiExtension" ] |
|
0.14 ms (0.07%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.12 ms (0.06%) |
1 |
SELECT * FROM object_relations_79 WHERE src_id = ?
Parameters:
[
14630083
]
|
|
0.12 ms (0.06%) |
2 |
SELECT * FROM object_brick_store_demiMerchandiseServiceExtension_11 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 44225172 "demiExtension" ] |
|
0.12 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Styria/Experience-Styrias-cuisine/Culinary-experiences' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.12 ms (0.06%) |
2 |
SELECT * FROM object_brick_store_demiCanonicalRegion_11 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 44225172 "demiExtension" ] |
|
0.11 ms (0.06%) |
1 |
SELECT * FROM object_store_79 WHERE oo_id = ?
Parameters:
[
14630083
]
|
|
0.10 ms (0.05%) |
1 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
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.