Query Metrics
340
Database Queries
60
Different statements
155.33 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
16.88 ms (10.87%) |
36 |
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:
[] |
|
13.44 ms (8.65%) |
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 (8564)))) 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,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,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,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 > 1731625200 and object_collection_demiDate_11.from < 1763161200))) AND (dates.to > 1731625200) 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:
[] |
|
11.62 ms (7.48%) |
41 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 3189171 ] |
|
7.15 ms (4.61%) |
7 |
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%" ] |
|
5.74 ms (3.69%) |
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
]
|
|
5.53 ms (3.56%) |
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 = 39269181) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.38 ms (3.46%) |
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 = 30724860) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.34 ms (3.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 = 6052991) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.06 ms (3.26%) |
11 |
SELECT * FROM properties WHERE ((cid IN (1,4340,4011,3944,3943,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
34088
]
|
|
5.04 ms (3.25%) |
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 = 6053007) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.02 ms (3.23%) |
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 = 14624161) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
4.75 ms (3.06%) |
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 = 2591921) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
4.69 ms (3.02%) |
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 = 35950693) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
4.52 ms (2.91%) |
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 = 31037216) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
4.50 ms (2.90%) |
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 = 14913999) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
4.17 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 = 39269169) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
4.17 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 = 32703242) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
4.14 ms (2.66%) |
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 = 41368966) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
4.09 ms (2.63%) |
7 |
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%" ] |
|
3.86 ms (2.48%) |
17 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
4676
]
|
|
3.56 ms (2.29%) |
34 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
3.56 ms (2.29%) |
15 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
|
2.38 ms (1.53%) |
10 |
SELECT * FROM object_collection_demiDate_11 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 6052991 "dates" ] |
|
1.86 ms (1.20%) |
14 |
SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
34088
]
|
|
1.59 ms (1.02%) |
10 |
SELECT * FROM object_collection_demiStartTime_11 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 6052991 "startTime" ] |
|
1.29 ms (0.83%) |
12 |
SELECT documents.*, documents_snippet.*, tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
34088
]
|
|
1.25 ms (0.80%) |
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 ] |
|
1.10 ms (0.71%) |
1 |
SELECT COUNT(*) FROM object_localized_11_en WHERE (o_id in (6052991,6053007,14624161,35950693,35950693,31037216,39269169,39269181,14913999,32703242,2591921,30724860,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,4065525,4065687,14075457,11653373,11653373,11653373,11653373,11653373,30724966,44386516,44386716,2405566,2405566,41970851,31037686,41970851,41971460,41971421) AND object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1
Parameters:
[] |
|
1.06 ms (0.68%) |
4 |
SELECT id FROM sites
Parameters:
[] |
|
1.04 ms (0.67%) |
7 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Treasures-of-nature" "path" => "/steiermark.com/en/Styria/Active-holidays-in-nature/" ] |
|
1.01 ms (0.65%) |
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 (6052991,6053007,14624161,35950693,35950693,31037216,39269169,39269181,14913999,32703242,2591921,30724860,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,4065525,4065687,14075457,11653373,11653373,11653373,11653373,11653373,30724966,44386516,44386716,2405566,2405566,41970851,31037686,41970851,41971460,41971421) AND object_localized_11_en.o_type IN ('object','folder')) AND object_localized_11_en.o_published = 1 ORDER BY FIELD(o_id, 6052991,6053007,14624161,35950693,35950693,31037216,39269169,39269181,14913999,32703242,2591921,30724860,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,41368966,4065525,4065687,14075457,11653373,11653373,11653373,11653373,11653373,30724966,44386516,44386716,2405566,2405566,41970851,31037686,41970851,41971460,41971421) LIMIT 12
Parameters:
[] |
|
0.82 ms (0.53%) |
5 |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
42697658
]
|
|
0.81 ms (0.52%) |
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/Active-holidays-in-nature/Treasures-of-nature" "sourcePathQuery" => "/en/Styria/Active-holidays-in-nature/Treasures-of-nature" "sourceEntireUri" => "https://stage.steiermark.com/en/Styria/Active-holidays-in-nature/Treasures-of-nature" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.76 ms (0.49%) |
5 |
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:
[
42697658
]
|
|
0.73 ms (0.47%) |
2 |
SELECT * FROM object_collection_demiPeriod_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 27983215 "periods" ] |
|
0.60 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/Active-holidays-in-nature/Treasures-of-nature" ] |
|
0.59 ms (0.38%) |
2 |
SELECT * FROM object_localized_data_10 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
42697658
]
|
|
0.47 ms (0.30%) |
2 |
SELECT * FROM object_collection_demiPriceBasePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 27983215 "prices" ] |
|
0.47 ms (0.30%) |
2 |
SELECT * FROM object_relations_58 WHERE src_id = ?
Parameters:
[
27983215
]
|
|
0.43 ms (0.28%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/Styria/Active-holidays-in-nature/Treasures-of-nature" ] |
|
0.42 ms (0.27%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
4676
]
|
|
0.39 ms (0.25%) |
2 |
SELECT * FROM object_collection_demiMealTypeRelation_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 27983215 "mealTypes" ] |
|
0.37 ms (0.24%) |
2 |
SELECT * FROM object_relations_10 WHERE src_id = ?
Parameters:
[
42697658
]
|
|
0.37 ms (0.23%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.35 ms (0.22%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Styria/Active-holidays-in-nature/Treasures-of-nature' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (0.20%) |
2 |
SELECT * FROM object_collection_demiPricePrice_58 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 27983215 "prices" ] |
|
0.27 ms (0.17%) |
2 |
SELECT * FROM object_store_58 WHERE oo_id = ?
Parameters:
[
27983215
]
|
|
0.25 ms (0.16%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 99 4676 4676 ] |
|
0.25 ms (0.16%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 4676 4676 ] |
|
0.23 ms (0.15%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
|
0.22 ms (0.14%) |
2 |
SELECT * FROM object_brick_store_demiMerchPEX_10 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 42697658 "demiExtension" ] |
|
0.22 ms (0.14%) |
2 |
SELECT * FROM object_brick_store_desklineDummyProduct_10 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 42697658 "demiExtension" ] |
|
0.22 ms (0.14%) |
2 |
SELECT * FROM object_store_10 WHERE oo_id = ?
Parameters:
[
42697658
]
|
|
0.20 ms (0.13%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.19 ms (0.12%) |
2 |
SELECT * FROM object_brick_store_demiMerchandiseProductExtension_10 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 42697658 "demiExtension" ] |
|
0.18 ms (0.12%) |
1 |
SELECT * FROM object_relations_12 WHERE src_id = ?
Parameters:
[
30255507
]
|
|
0.14 ms (0.09%) |
1 |
SELECT * FROM object_store_12 WHERE oo_id = ?
Parameters:
[
30255507
]
|
|
0.11 ms (0.07%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Styria/Active-holidays-in-nature/Treasures-of-nature' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.10 ms (0.07%) |
1 |
SELECT * FROM object_brick_store_demiYoungStyria_12 WHERE o_id = ? AND fieldname = ?
Parameters:
[ 30255507 "demiExtension" ] |
|
0.09 ms (0.06%) |
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.