Query Metrics
481
Database Queries
78
Different statements
171.14 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
27.94 ms (16.32%) |
126 |
SELECT * FROM object_metadata_AlpsteinTour WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 854052 234470 "regions" "object" "" "0" 1 ] |
|
12.99 ms (7.59%) |
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:
[] |
|
10.68 ms (6.24%) |
60 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 3189171 ] |
|
8.08 ms (4.72%) |
2 |
SELECT object_localized_11_de.o_id as o_id, object_localized_11_de.o_type as o_type FROM object_localized_11_de LEFT JOIN object_collection_demiDate_11 dates ON dates.o_id = object_localized_11_de.oo_id LEFT JOIN object_collection_demiStartTime_11 times ON times.o_id = object_localized_11_de.oo_id WHERE ((object_localized_11_de.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_de.o_id in (select o_parentId from object_10 where packageOnly is null or packageOnly = 0)) AND (object_localized_11_de.o_id in (select o_id from object_collection_demiDate_11 where (object_collection_demiDate_11.to > 1729461600 and object_collection_demiDate_11.from < 1760997600))) AND (dates.to > 1729461600) AND object_localized_11_de.o_type IN ('object','folder')) AND object_localized_11_de.o_published = 1 ORDER BY dates.from ASC, dates.to ASC, times.time ASC, `order`
Parameters:
[] |
|
6.76 ms (3.95%) |
9 |
SELECT COUNT(*) FROM object_localized_Region_de 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_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[ "demiRegionId" => "%,11420%" ] |
|
6.48 ms (3.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 = 4066038) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
6.21 ms (3.63%) |
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 = 30724966) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
6.03 ms (3.52%) |
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 = 4065629) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.65 ms (3.30%) |
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 = 4065644) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.51 ms (3.22%) |
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 = 14075457) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.44 ms (3.18%) |
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 = 11653373) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
5.01 ms (2.93%) |
9 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de 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_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1 LIMIT 1
Parameters:
[ "demiRegionId" => "%,11420%" ] |
|
4.21 ms (2.46%) |
21 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
99
]
|
|
3.73 ms (2.18%) |
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:
[] |
|
3.60 ms (2.11%) |
40 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
3.57 ms (2.09%) |
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 = 4065687) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
3.49 ms (2.04%) |
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:
[] |
|
3.39 ms (1.98%) |
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:
[] |
|
3.28 ms (1.92%) |
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:
[] |
|
3.27 ms (1.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 = 4065525) and src_id not in (select src_id from object_relations_10 where dest_id=27527855 and fieldname='holidayThemes'))))
Parameters:
[] |
|
3.25 ms (1.90%) |
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.32 ms (1.35%) |
6 |
SELECT * FROM properties WHERE ((cid IN (1,2474,19,4,2,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
2475
]
|
|
2.30 ms (1.34%) |
17 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
|
1.60 ms (0.93%) |
10 |
SELECT * FROM object_collection_demiDate_11 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 32703242 "dates" ] |
|
1.44 ms (0.84%) |
10 |
SELECT * FROM object_collection_demiStartTime_11 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 32703242 "startTime" ] |
|
1.25 ms (0.73%) |
2 |
SELECT object_localized_80_de.o_id as o_id, object_localized_80_de.o_type as o_type FROM object_localized_80_de WHERE ((alpsteinObjects like '%,234335,%') AND object_localized_80_de.o_type IN ('object','folder')) AND object_localized_80_de.o_published = 1
Parameters:
[] |
|
1.22 ms (0.71%) |
2 |
SELECT object_localized_80_de.o_id as o_id, object_localized_80_de.o_type as o_type FROM object_localized_80_de WHERE ((alpsteinObjects like '%,234469,%') AND object_localized_80_de.o_type IN ('object','folder')) AND object_localized_80_de.o_published = 1
Parameters:
[] |
|
1.18 ms (0.69%) |
2 |
SELECT object_localized_80_de.o_id as o_id, object_localized_80_de.o_type as o_type FROM object_localized_80_de WHERE ((alpsteinObjects like '%,232423,%') AND object_localized_80_de.o_type IN ('object','folder')) AND object_localized_80_de.o_published = 1
Parameters:
[] |
|
1.14 ms (0.66%) |
2 |
SELECT object_localized_80_de.o_id as o_id, object_localized_80_de.o_type as o_type FROM object_localized_80_de WHERE ((alpsteinObjects like '%,234383,%') AND object_localized_80_de.o_type IN ('object','folder')) AND object_localized_80_de.o_published = 1
Parameters:
[] |
|
1.00 ms (0.58%) |
1 |
SELECT object_localized_11_de.o_id as o_id, object_localized_11_de.o_type as o_type FROM object_localized_11_de WHERE (o_id in (6052991,6053007,14415457,14624161,14076313,14383210,14383724,14383724,14383724,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,4066038,4065629,4065644,4065894,4065906,11438973,44386516,44386716,2567561,276125,2405566,2405566,43692610,43692610,4066059,5425190,5425190,273571,47650203,41971460,4065169,4065976,11652239,31037686,41970851,31037686,41970851,41971460,41971421) AND object_localized_11_de.o_type IN ('object','folder')) AND object_localized_11_de.o_published = 1 ORDER BY FIELD(o_id, 6052991,6053007,14415457,14624161,14076313,14383210,14383724,14383724,14383724,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,4066038,4065629,4065644,4065894,4065906,11438973,44386516,44386716,2567561,276125,2405566,2405566,43692610,43692610,4066059,5425190,5425190,273571,47650203,41971460,4065169,4065976,11652239,31037686,41970851,31037686,41970851,41971460,41971421) LIMIT 12 OFFSET 12
Parameters:
[] |
|
0.92 ms (0.54%) |
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.88 ms (0.51%) |
4 |
SELECT id FROM sites
Parameters:
[] |
|
0.80 ms (0.47%) |
1 |
SELECT COUNT(*) FROM object_localized_11_de WHERE (o_id in (6052991,6053007,14415457,14624161,14076313,14383210,14383724,14383724,14383724,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,4066038,4065629,4065644,4065894,4065906,11438973,44386516,44386716,2567561,276125,2405566,2405566,43692610,43692610,4066059,5425190,5425190,273571,47650203,41971460,4065169,4065976,11652239,31037686,41970851,31037686,41970851,41971460,41971421) AND object_localized_11_de.o_type IN ('object','folder')) AND object_localized_11_de.o_published = 1
Parameters:
[] |
|
0.77 ms (0.45%) |
2 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,234469,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.75 ms (0.44%) |
2 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,234470,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.68 ms (0.40%) |
2 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (229667,235069,235071,235072,235077,235079,235082,235086,235091,235094,235098,235103,235106,235107,235108,235114,235274,235284,235294,235309,235310,235312,235313,235314,235316,235322,235323,235324,235326,235327,235328,235329,235330,235331,235333,235335,235336,235337,235338,235339,235340,239066,239077,24214605,48520409);
Parameters:
[] |
|
0.68 ms (0.40%) |
2 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,229667,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.68 ms (0.40%) |
1 |
SELECT object_localized_80_de.o_id as o_id, object_localized_80_de.o_type as o_type FROM object_localized_80_de WHERE ((alpsteinObjects like '%,232354,%') AND object_localized_80_de.o_type IN ('object','folder')) AND object_localized_80_de.o_published = 1
Parameters:
[] |
|
0.66 ms (0.39%) |
7 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Schaetze-der-Natur" "path" => "/steiermark.com/de/Steiermark/Aktiv-in-der-Natur/" ] |
|
0.63 ms (0.37%) |
1 |
SELECT object_localized_80_de.o_id as o_id, object_localized_80_de.o_type as o_type FROM object_localized_80_de WHERE ((alpsteinObjects like '%,236751,%') AND object_localized_80_de.o_type IN ('object','folder')) AND object_localized_80_de.o_published = 1
Parameters:
[] |
|
0.62 ms (0.36%) |
2 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,238945,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.60 ms (0.35%) |
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" => "/de/Steiermark/Aktiv-in-der-Natur/Schaetze-der-Natur" "sourcePathQuery" => "/de/Steiermark/Aktiv-in-der-Natur/Schaetze-der-Natur?page=2" "sourceEntireUri" => "https://stage.steiermark.com/de/Steiermark/Aktiv-in-der-Natur/Schaetze-der-Natur?page=2" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.60 ms (0.35%) |
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/%" "/de/Steiermark/Aktiv-in-der-Natur/Schaetze-der-Natur" ] |
|
0.54 ms (0.32%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,2961,4,2,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
27866
]
|
|
0.52 ms (0.31%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,2042,250,4,2,1430) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
2044
]
|
|
0.52 ms (0.30%) |
1 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,234335,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.51 ms (0.30%) |
1 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,232354,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.47 ms (0.28%) |
1 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,232423,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.46 ms (0.27%) |
1 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,236751,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.43 ms (0.25%) |
1 |
SELECT o_id FROM objects WHERE o_id IN (234335,234339,234352,234366,239164)
Parameters:
[] |
|
0.40 ms (0.24%) |
2 |
SELECT o_id FROM objects WHERE o_id IN (234469,239125,239150)
Parameters:
[] |
|
0.40 ms (0.23%) |
1 |
SELECT object_localized_Region_de.o_id as o_id, object_localized_Region_de.o_type as o_type FROM object_localized_Region_de WHERE ((alpsteinRegions like '%,234383,%') AND object_localized_Region_de.o_type IN ('object','folder')) AND object_localized_Region_de.o_published = 1
Parameters:
[] |
|
0.38 ms (0.22%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/de/Steiermark/Aktiv-in-der-Natur/Schaetze-der-Natur" ] |
|
0.35 ms (0.21%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.34 ms (0.20%) |
1 |
SELECT o_id FROM objects WHERE o_id IN (232354,232356,232357,232358,232361,232363,232364,232370,232372,232373,232375,232377,232378,232380,232381,232383,233837,233838,233839,233840,233841,233842,233843,233844,233845,233846,233847,233848,233849,239175)
Parameters:
[] |
|
0.33 ms (0.19%) |
2 |
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:
[
3496318
]
|
|
0.32 ms (0.19%) |
1 |
SELECT o_id FROM objects WHERE o_id IN (234470,234487,234490,234520,238842,238881,238907,238910)
Parameters:
[] |
|
0.32 ms (0.19%) |
1 |
SELECT o_id FROM objects WHERE o_id IN (232423,232398,229662,239077,239066)
Parameters:
[] |
|
0.32 ms (0.18%) |
1 |
SELECT o_id FROM objects WHERE o_id IN (229667,235069,235071,235072,235077,235079,235082,235086,235091,235094,235098,235103,235106,235107,235108,235114,235274,235284,235294,235309,235310,235312,235313,235314,235316,235322,235323,235324,235326,235327,235328,235329,235330,235331,235333,235335,235336,235337,235338,235339,235340,239066,239077,24214605,48520409)
Parameters:
[] |
|
0.30 ms (0.17%) |
1 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (232354,232356,232357,232358,232361,232363,232364,232370,232372,232373,232375,232377,232378,232380,232381,232383,233837,233838,233839,233840,233841,233842,233843,233844,233845,233846,233847,233848,233849,239175);
Parameters:
[] |
|
0.27 ms (0.16%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
99
]
|
|
0.24 ms (0.14%) |
1 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (236751,236752,236754,236755,236756,236757,236758,236759,236760,236761,236762,236763,236764,236765,236766,11173867);
Parameters:
[] |
|
0.23 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/de/Steiermark/Aktiv-in-der-Natur/Schaetze-der-Natur' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.19 ms (0.11%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 99 99 99 ] |
|
0.19 ms (0.11%) |
2 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (234469,239125,239150);
Parameters:
[] |
|
0.19 ms (0.11%) |
2 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
|
0.18 ms (0.11%) |
1 |
SELECT o_id FROM objects WHERE o_id IN (234383,234482,234492,234500,238842,238881,238907,238910)
Parameters:
[] |
|
0.18 ms (0.10%) |
1 |
SELECT o_id FROM objects WHERE o_id IN (236751,236752,236754,236755,236756,236757,236758,236759,236760,236761,236762,236763,236764,236765,236766,11173867)
Parameters:
[] |
|
0.17 ms (0.10%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
|
0.15 ms (0.09%) |
1 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (234470,234487,234490,234520,238842,238881,238907,238910);
Parameters:
[] |
|
0.15 ms (0.09%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.14 ms (0.08%) |
1 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (234335,234339,234352,234366,239164);
Parameters:
[] |
|
0.13 ms (0.08%) |
1 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (232423,232398,229662,239077,239066);
Parameters:
[] |
|
0.12 ms (0.07%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 4676 4676 ] |
|
0.12 ms (0.07%) |
1 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (234383,234482,234492,234500,238842,238881,238907,238910);
Parameters:
[] |
|
0.11 ms (0.06%) |
1 |
SELECT o_id FROM objects WHERE o_id IN (229662,238996,238945)
Parameters:
[] |
|
0.11 ms (0.06%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/de/Steiermark/Aktiv-in-der-Natur/Schaetze-der-Natur' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.09 ms (0.05%) |
1 |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (229662,238996,238945);
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.