Query Metrics
85
Database Queries
27
Different statements
189.15 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
50.70 ms (26.80%) |
1 |
select o_id,contentScore,priority,bookable from object_8 where o_published = 1
Parameters:
[] |
|
43.27 ms (22.88%) |
1 |
select o_id as id, position__longitude as lon, position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[] |
|
2.05 ms (1.08%) |
11 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
|
1.78 ms (0.94%) |
28 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
0.82 ms (0.43%) |
7 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Accomodations-search-book" "path" => "/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/" ] |
|
0.76 ms (0.40%) |
4 |
SELECT id FROM sites
Parameters:
[] |
|
0.73 ms (0.38%) |
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.69 ms (0.37%) |
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/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book" "sourcePathQuery" => "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book?nearbySearchId=853512&nearbySearchLat=47.16&nearbySearchLong=15.29105&sorting=nearbySearchAsc&page=3&randSeed=504" "sourceEntireUri" => "https://stage.steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book?nearbySearchId=853512&nearbySearchLat=47.16&nearbySearchLong=15.29105&page=3&randSeed=504&sorting=nearbySearchAsc" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.62 ms (0.33%) |
2 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
9975
]
|
|
0.57 ms (0.30%) |
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/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book" ] |
|
0.45 ms (0.24%) |
1 |
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
]
|
|
0.44 ms (0.23%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
|
0.36 ms (0.19%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book" ] |
|
0.36 ms (0.19%) |
1 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 1024237 ] |
|
0.29 ms (0.16%) |
1 |
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 5882747 "datepickerInfoTexts" ] |
|
0.29 ms (0.15%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.29 ms (0.15%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.27 ms (0.14%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
|
0.26 ms (0.14%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.23 ms (0.12%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 9975 9975 ] |
|
0.19 ms (0.10%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 9667 9975 9975 ] |
|
0.18 ms (0.09%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.16 ms (0.09%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
9975
]
|
|
0.10 ms (0.05%) |
1 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
|
0.09 ms (0.05%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
demi_vacancies connection
| Time▼ | Count | Info |
|---|---|---|
|
75.04 ms (39.67%) |
1 |
SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights FROM `steiermark_vacancies`.price_template pt INNER JOIN `steiermark_vacancies`.price_template_base_prices bp ON bp.price_template_id = pt.id WHERE pt.acco_id IN (1821737,1906621,2454764,1615731,2458159,1906249,18776428,1907420,2104688,1612675,27961048,46904062,1612993,7453107,2455815,1615773,50660470,3259747,2104791,7453197,1615738,50330123,2529880,2455301,46648161,2457417,4063767,1615997,32662482,1906916,2456271,9238291,17197373,1906788,2458151,1612780,1906838,6342567,2457804,1905888,1616087,1616351,2459044,1930118,2310269,1906305,1612635,1615580,1615509,40480657,2458275,2457214,2457393,1612855,9735393,1821635,2457745,1615680,1821723,1906719,1906802,1821740,27090024,23827352,1615272,2458128,19763617,1821807,1615619,7453225,11993543,7162763,2457632,6208703,46703369,2457171,1613013,1821580,1612792,1612687,2457383,2529883,1616053,1615743,18861848,22968535,51238225,2458026,12076227,2194142,7453204,2458255,18776567,13734739,1616423,13468069,2458331,2194020,40649956,1906766,1616313,2309376,2457692,42339673,1616507,2530028,1906209,6342564,1906432,4063709,2458035,1615202,11106490,1930324,1616081,2457118,1615547,42085312,50062229,27961045,7452946,2530025,2454119,2454904,7452918,1615178,1907413,18777699,41643929,2458228,1616459,31116045,26147003,21285943,2309544,32043299,2458389,7452932,49289508,2104811,1906066,7453058,1616483,2457665,1703035,1616336,1612628,11993576,1613214,2530031,2459142,1930304,1821814,51735516,1615279,7453030,1906601,7453065,1905966,18777644,12212021,1613190,2458552,2310457,1822005,2458372,1614871,15028571,18743458,9566396,2368235,1616064,1615533,1612615,1906002,27998615,6995557,18777710,7453079,38973570,2458220,1616142,1822011,1905920,1614785,1821680,1821698,1616367,50330126,9684290,43139185,2458533,1822022,6775712,1615503,13205136,1821772,2454173,2455032,1616259,1614854,2457650,1905927,1821899,1616374,4063718,1702966,4704521,39249742,1614616,1906157,1821979,39976679,41643953,7452869,2457195,7453114,46837228,1614903,1907362,2455321,1907329,1616323,18777655,7452876,1930161,1612986,7453190,9108294,1906171,50062232,45886154,7453218,10990613,48753192,1616498,2458566,47698731,7452939,4062128,2455852,2453840,2456436,2454161,1613127,18721781,2456321,1906859,29699643,2454264,1616440,32996115,30806616,32203081,1906635,7453009,2458339,1821779,32043296,34043087,7452960,2458180,48320437,1612655,1616601,1821748,2456775,2104401,2458503,50330129,2458056,1612861,1906079,2104858,1906073,2309712,1615234,7453016,6645739,15154165,1821868,2457241,3213244,2458073,1612819,2453876,1614918,1615080,1930330,1615966,1703009,34613539,34595469,7449751,2310556,1616235,1821836,9490392,1616414,1906546,2456747,15115425,2459254,1615196,1613038,4062019,2458323,1906901,2457931,1821963,51333826,18777978,1930168,45167318,2529886,1905954,30192336,7452890,1616047,2458788,13415036,18777967,16552093,16993556,31116306,7453037,19739002,12141191,15136578,1612807,45582974,16463906,47698722,2104798,1614803,1616447,2458107,1614830,3032193,2456739,14055216,2454738,1907049,15221891,1615749,2458357,11644081,1612739,1906508,30629016,2458981,44735018,2458008,2459391,46121793,2457353,1615208,7453002,16192461,19763596,1616159,45911208,44760927,1616557,2457556,2453987,31439157,1821641,32396816,1907143,2530046,2458412,49758724,2456978,2194032,7453072,1616249,2456108,24109335,2458065,2455620,12665315,2309430,2453569,2457844,1614767,7453169,1930130,4062193,1616225,1821692,2104833,39621948,1907427,7453211,7452925,2456969,2404275,1616477,9159056,48319918,2104726,1906044,2456579,2455138,1615308,1702924,18743480,38702048,7452967,44781292,2455688,1821716,1907111,1906418,1613197,1615991,2104865,31116650,7453044,2457782,7453051,29850681,18776639,1821596,1612876,4062035,4820748,32356610,18776659,27167031,2457950,2104901,1616614,7576136,2194164,1612928,2059036,25076569,2458404,1821955,50613474,9651389,1821629,20926241,2457179,2104824,2455657,1907399,2530034,2456727,11993564,24874128,2530049,1906328,4149203,2454859,1616174,2457450,1822030,18776417,1930243,1821730,38954139,1612831,18743469,1612667,12578470,2829775,49522274,1616381,7453135,1616514,2454032,1821849,6645761,22817521,1905939,4090781,1615721,2458315,18743311,18776174,2404244,2458424,1612937,1821623,7452883,7452995,48208705,1821762,1905902,1612964,2456405,1615522,1616360,7453176,1615872,11993553,34613565,1906561,1906035,1821791,4062032,1906873,1906852,29827678,1906052,47840451,8924349,4062044,2418919,2455960,1612882,1612643,2457960,2308773,2457621,12771836,2456499,15187823,1906119,18776406,2456765,1616197,1906021,37260090,40480654,1615674,18777721,8924340,2454461,2456895,18777677,7452974,1614843,1616205,2104878,2310359,1612870,4062067,1930310,1612661,12076233,9566387,41003922,8776246,15136325,1907248,2457980,13169002,2454629,1616585,3121111,1906189,2457291,7452953,40935234,1615695,2458381,1906112,1905995,40066871,2457968,1616296,1612889,2453808,2457275,1612895,2194150,45468398,2454613,1930178,31116285,2104851,1702930,21905908,47650472,2310272,1614837,12176479,1821823,1615125,40066879,2308760,1616103,31569228,2310347,2454097,32356605,18743300,18743289,49723102,24629767,9490401,2457187,1906696,2457590,1702984,18777989,31116629,1615295,27858937,31116495,1906795,35677466,18743447,1906196,1612786,1613053,1612950,1906816,7453128,1615601,4062325,49619462,2529904,1613183,1906059,1615663,1821686,2453674,1614910,1906747,42766841,2457544,31116608,7453121,18755389,1612971,2458171,18777688,2459068,7453183,7453023,44079175,2457137,2458494,1615159,1614713,1821893,4062249,30192347,1906009,18778000,1616532,2457048,1906297,2529898,2368223,18411811,1821861,39952681,12736708,2458779,1907004,11993491,25114536,4062000,2104698,1906263,31159117,12785402,14957863,10223870,1615005,18777956,1616284,25851748,4062004,11825924,1906202,2453896,12141175,18777666,2455156,11993589,1616117,2457153,1612798,2456226,1906356,2457536,18541017,18778011,1615985,2457774,2454928,12578480,4442120,1615164,2454304,2104885,1614778,2457105,1615228,1906343,47650481,2457463,2458294,2457442,19763638,27858940,1906028,18094541,1906454,7452988,1613120,1702996,35259362,1612621,1615190) AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id) order by minPrice
Parameters:
[] |
|
8.17 ms (4.32%) |
1 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.o_published = 1 AND (dacco.town__id IN (11465, 11466, 11464, 11463, 1612603)) GROUP BY dacco.oo_id ORDER BY RAND(504)
Parameters:
[] |
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.