Query Metrics

102 Database Queries
27 Different statements
488.54 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
58.47 ms
(11.97%)
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:
[]
50.47 ms
(10.33%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
7.74 ms
(1.58%)
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
]
2.48 ms
(0.51%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
2.27 ms
(0.46%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.78 ms
(0.36%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.89 ms
(0.18%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
0.75 ms
(0.15%)
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.72 ms
(0.15%)
4
SELECT id FROM sites
Parameters:
[]
0.62 ms
(0.13%)
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/Search-book-accommodation"
]
0.58 ms
(0.12%)
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/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=853497&nearbySearchLat=47.45582&nearbySearchLong=13.81257&sorting=nearbySearchAsc&page=4&randSeed=166"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=853497&nearbySearchLat=47.45582&nearbySearchLong=13.81257&page=4&randSeed=166&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.40 ms
(0.08%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.38 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.34 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.33 ms
(0.07%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.32 ms
(0.07%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.29 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.29 ms
(0.06%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.23 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.21 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.15 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

Time Count Info
326.47 ms
(66.82%)
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 (48662436,1620205,169666,45233699,11281445,31116285,33331,19754,19244,142256,1833139,17058949,54374,49158,244970,147332,2673544,1906028,1821893,125055,129096,2095969,1619783,129533,26431,1975205,48933696,91777,45911208,1968545,1646659,18015,1646625,45479665,1821868,43384756,34719290,33294549,242085,53743,1737234,1965083,1622267,1967421,2099417,23898669,30765443,48365,1949086,1943973,38060,18743458,1730694,1959004,190874,24815862,1735424,1986946,22003,186088,2089707,4063051,1969267,38670305,16648648,2696852,1995103,78974,18810400,1969318,1625875,1972098,1616381,1981033,1612798,1960793,2100495,2063091,1630358,6612349,1633481,40707373,33623770,2458981,1969193,27568,142376,1953052,1943137,43581664,1990954,1954000,101549,269658,150874,26684056,1907413,1906202,227481,11644081,18776428,30765378,7453211,1983915,42829790,382743,211155,2064954,39231,11364731,202099,223510,210612,10004874,1951065,383360,25410808,1622382,2457214,1173251,49276,49723102,4820758,10004877,1615743,179767,18272,81639,1951695,49548934,1940590,41198692,1634459,45375,14012385,22680298,1906002,170491,7512292,1749206,87970,1733775,26739851,47693113,115753,1713950,208831,1599922,3379718,16605043,1941538,188163,118621,2458331,182314,241209,272451,1637581,6645142,7453072,1703035,1960488,1614910,95945,3190492,1969382,105395,214160,263475,1945097,168676,191937,1971344,213132,94129,1823037,119097,117802,266243,35666823,210702,2098488,22680307,1828062,91843,1739008,36022010,6553917,1628719,38928823,212689,48050342,1970683,197250,4061468,2457241,43526,1739520,1955200,49539259,1947036,9054218,1615985,2096996,1713652,21237158,78111,5315084,1615503,1824536,149642,11892410,19475,25215728,31896277,26740121,94738,46206,13400949,2086783,42753173,9684290,122810,1603255,242815,25086439,148899,168744,18520,1648172,2566227,48905589,256865,187883,2194164,2457450,151300,227647,1616498,2104811,1614918,4525581,26306220,30565,1646975,77600,1904712,1742903,173474,114505,168114,8195213,10039806,5367477,8382758,44387,2104791,185439,128141,1568208,114734,2095446,1601300,9495222,73318,1620355,212164,261884,1978232,39270097,1965642,268917,229645,14600421,42358761,139196,46636,205836,29311311,42339673,2661069,145352,16975,2453674,261823,31336,1987270,2102038,1620627,6775934,224332,17526524,111233,1906171,2457665,1993811,1946098,1907329,1952062,33252193,80548,84203,162948,1622066,54695,26740233,9700382,26739531,363436,30192336,255957,1615234,2530028,213869,1977269,76033,1729645,1621941,1615522,1954471,1976977,48417638,30354,1702966,40695402,31474,1953959,1953564,4580718,13235747,7453225,37175,402843,12963484,13104309,1633380,26739837,242919,17904,1955322,12663360,1635520,1616225,1994822,121033,207573,1628086,2079717,1737274,38622028,178962,185795,1949676,2670783,1941470,1624562,1713829,262167,34920688,74297,1627206,193721,32460992,47606,1620881,2098663,33898,1943381,43837572,135125,99420,42682912,1621280,5957905,42144620,36701511,218293,73645,2458797,1603751,48905586,18541017,85117,146486,26740126,2059571,125266,1828716,1949028,2085791,6494431,1612621,33905433,1613197,1984665,45054,2103395,34636746,2087805,81984,383006,154459,1951414,82604,1962257,6173328,219686,172217,9517247,1990285,1616159,1639729,1625909,5367394,2064808,1990539,1612792,1967609,5612896,1736723,35700277,1634217,1615125,33992180,1944896,124237,104583,29850681,19812,1974380,1992224,227892,50388225,41188273,24971,1993878,41458409,2530031,1980321,3379819,1828794,1630959,31820476,149455,2063196,124829,127120,190634,1601806,201802,2457105,26740195,1750211,1615721,6497553,1824363,1984508,16338363,1605354,26477859,233730,259576,1730919,141272,31340,41680612,50718,10672408,383497,7018853,1992394,31419712,1173161,124606,18777666,1826175,156617,249871,245352,24580,1716000,26862862,1990181,2086854,1635281,32341429,1950174,2673689,2073345,111742,2072256,7970607,75853,261943,1612861,1964399,1954995,136036,50062229,1742341,96500,1955197,182441,171431,1742632,265468,17071511,1599977,26739991,1973899,1955705,7453023,42724854,27982954,260943,1747013,1987095,1958857,9490401,1986509,49585241,149007,1640812,51238225,2457536,1966954,26739957,26740294,1633342,7452939,2101243,1634247,2103560,87124,7452946,5367459,16295655,206591,42396774,6497526,32298578,1621080,15692025,43443153,363560,190920,2453896,168086,48897791,17804775,1749264,45797,38621717,18560,29658076,107333,2101221,2104688,17877742,7364158,1961516,110779,2458339,164436,49875366,176727,1946351,2062885,47888734,1604752,139875,2458228,1906747,138703,18332685,7452988,267314,132768,1937824,162100,39685585,1904411,138609,1949915,1984760,87340,1955919,1629739,192120,155492,122307,23106697,1614616,1715372,44587191,25723022,195136,1982666,191428,2098711,1615196,41024653,134439,2066719,1930447,2659058,38480,49345132,160345,42769497,382826,2062410,23500,1637831,42911,228856,1648548,9651389,1906561,2099659,2065496,168884,1968180,1969409,220655,1742553,1742525,15659243,19158,2085525,98021,21577455,15115425,42769488,1978956,4061122,22765980,2070894,209194,53418,1955727,116102,106770,1737589,224525,1951458,117486,31960,235840,244648,248735,1746188,2454613,34636631,77069,101260,1616117,1745754,199572,80940,2457275,28867356,1987680,1984093,1632999,1738986,52801,35259362,2104901,1986015,185864,1945724,1952340,49539249,1987314,2064720,89745,32478,1612786,1714950,32043299,7449751,42724880,36090619,48319456,1712581,1968484,190401,255495,76427,7452974,26739846,263121,1616477,19739002,135730,18743289,7453030,156053,47131,1615005,227732,21032,7452932,9887645,171964,3032193,1568610,91180,26740229,4062193,2086582,2070586,26740087,7364155,1727813,20108,1631662,204855,383118,1822005,39558144,255713,189617,383256,5554780,1954411,147915,4918601,1945182,186109,4062685,2674018,1976775,1989419,2529883,160845,2458073,1735817,44782,208109,89261,2104757,2103381,1931758,1980553,1622610,3406278,149059,1625639,1735575,194917,188242,2456271,1906418,209445,272624,1626078,1173158,33611480,188297,2101162,197648,1734569,383286,1613183,1743243,2094540,1632667,1989306,117877,157149,1744565,266814,2456747,178916,1949477,256553,2457632,2666152,1632008,78602,2080373,1955094,1946429,1956234,6553969,45122,1600895,155228,138437,1744680,256958,194713,103833,84306,1614778,1962416,1623157,36260848,2667581,7452918,42724838,150268,1940920,48897445,2088878,156724,2456895,1730377,1736444,120314,26739910,204827,26740005,21284,3224895,7453197,1567856,2076985,7452995,18776417,75643,2098724,49229,28018930,1736862,189226,102558,4063386,1632452,30465588,156310,27858937,105154,104153,1965236,5367441,23107117,1930481,17115,7599929,20782,47710,2099497,4791435,203147,90285,170902,383826,127993,1934294,21236516,26059963,1568525,52545,7452876,35206874,4062032,1824854,207780,1643032,1715779,2456499,172512,100623,124000,1749936,2087757,244042,1953843,1623749,1931829,139146,34969921,26739546,20972969,238918,151257,32570986,1932702,4063124,1933801,1991966,240534,2697535,35989,1955377,26739408,1974719,2079104,143785,1965688,268384,154226,7969044,50330126,20707,42766841,17208005,1821692,195537,3263475,1625531,1739660,1750679,143202,1626434,16922,34168343,1742817,1622865,2078460,2074707,51833,145494,20962005,227046,1744087,1634940,81217,162969,1628609,26739905,255407,1743804,1728448,2670240,8925967,140245,2075589,2530373,10106915,135953,50660470,1965864,1605052,30629016,1744099,1971191,19029556,2089778,249148,1616414,11510964,383494,106889,26648317,2080986,1625106,36531210,22680295,31729351,27384,1967131,46896212,46733,2058868,193068,34613565,1955415,182129,52190,33321369,25766748,1712145,1739372,1717034,2066578,2082358,1954353,2454764,1947387,46409417,1971852,1617940,55167,34012809,1741900,2101292,26739966,1615749,1962766,2078142,41842,145830,262617,1567618,4791485,43184382,265584,1945937,128526,34831,2079129,1631240,1961566,1973199,154051,1624427,205493,36566491,367295,1969608,1612882,1740988,265930,2853495,38954139,1619082,16993556,2454629,1645656,1612819,242964,2065944,4063201,1974528,202800,1944200,1634918,34219679,7041608,75482,1967229,1736889,1979636,1970512,1945387,1173353,7780777,1949501,4061616,2059447,43125,220914,50205454,73764,76091,1605324,1967087,2075115,174035,363511,30479894,163692,1984997,1729848,11928644,225195,220483,84906,1748053,253165,17593634,2454264,260788,10684637,33519,49534198,1981017,1640572,253709,2077909,1938100,1949966,227403,1733471,2669164,1825179,1624685,2097658,2077282,22204981,262061,11329889,1604712,31117139,148562,1986219,2700465,9455693,1821730,1823552,1971834,44760927,1741776,267530,98143,25500,164627,260291,25942,1828871,1631921,164128,36492,26740224,1947283,1988937,1612655,146259,1981496,1568396,266061,128612,51533229,46250,37942,9629644,1824068,31772,1619845,53010,16943153,3121111,1639682,50975869,2059036,9700358,204161,2083801,36278962,1821823,2453987,1625681,2194020,7452953,27142048,1972504,97116,2103360,252403,1954907,3413534,27820,2102395,106094,138736,2075819,98352,2102326,42841,99114,12141191,1614830,2458128,114320,1993645,1641970,110338,47650481,14669428,2457844,50194,1702984,1828133,40818571,1936326,29829,2308760,42811899,1634574,4442184,2103859,21824738,1958820,2099401,48564332,1968595,1632826,34043087,195918,87856,1979290,45503,1991534,31406343,362302,1727855,1954940,45756971,1744268,1906546,7453065,178677,2091555,1646646,1728976,1960869,26740330,29671,26890,204973,2088417,120483,2529898,72611,1950645,195558,2073960,10680500,2058512,47830,4061338,1173542,10368361,363284,263799,1907399,2458404,1823376,86586,1744000,2075186,19286,1645256,1612661,1713696,84542,44224029,1735710,22892606,1743121,243956,4149206,11861138,1936689,1730858,1944279,1741980,2094828,42682891,7453169,5554733,2087344,1906696,31261223,1823609,8566620,95803,2058626,36716325,1627892,4061812,144517,6614248,18152,161142,1713989,141656,1821772,1981953,44404593,2084064,2102865,1631489,1954644,2102926,1977360,130741,9700322,111003,193204,2459391,1906343,73556,2673648,43751656,1715720,2663894,194960,1637479,1984959,41305644,47601194,1728765,2098097,1955017,1629064,8591193,90325,1951232,3429558,1623363,207430,192306,2674013,144028,130799,50878032,2661877,30359,2085493,1601456,1993438,152590,26740130,54660,80793,32979456,1985415,131135,2530034,1747963,2455032,2454859,36227,1944069,2309430,12216039,1733016,2087656,15399861,1948401,1619833,44050,11367104,1648515,251478,227134,1979772,1972617,12910729,98180,31116608,28492,26739919,1612855,1736624,244956,175232,5160398,106040,49189,1993946,19326229,80345,23435,1981704,211866,44781642,1935804,1974078,19054,10990613,1646511,272389,1750860,252832,266442,363159,1628457,1821807,146983,363263,177391,40473,26739986,4062676,362272,259974,1622470,1716637,48804066,218521,1634602,2655655,8306877,1748239,47614112,1620047,11367489,39225141,111091,40768,115902,187735,17541,175610,34180,1983483,1907427,174338,2453840,78857,260387,2086836,37827,1950333,2456321,9129044,1940778,7453114,2457980,2070247,31789631,2099002,16889,9517217,41643929,2457463,109291,125739,2091589,209921,87314,1641827,383375,27807955,1621992,150070,35330412,25984203,1737436,2084688,2081071,130267,17120,32742951,2082077,32043296,1989465,1733525,1985114,40480654,1746105,267915,18776639,1634280,8776246,33072197,1975374,1821779,1968072,75190,2691122,223395,46529,174680,190546,4062019,164670,7951197,50062232,1948234,180136,48319918,98382,171164,26739388,4063461,51974,1950224,228789,1702924,1974122,263334,1946746,1625429,172317,1642184,170790,165025,1990091,1986681,17804792,1624054,1951927,1939045,1634534,18777956,31077072,1736352,20810,1733826,3402151,18165472,48663405,166076,9159056,1623990,9566387,1824494,1948260,1645676,1634962,91521,1971387,24781077,1616259,26740155,80083,1628483,18776659,160168,1907049,1567091,15419089,1935963,1734130,1729325,26739952,1735857,2091472,210439,29819550,2099837,2098561,1613053,1737654,144248,1622416,1982912,187408,143260,29836686,1635060,28920,2066111,109732,48928,30764006,206894,1612964,2098329,43484376,186795,142573,31422,15419107,1980873,1622536,126702,1992261,1615208,1931251,1743173,41969421,17227,1646152,261224,2087282,38616,29585,2087379,79701,1733811,19208,150724,41935,201319,1618672,17670,173849,1627158,1972586,261090,188477,26739413,246836,1974755,1625755,101745,9886762,1614871,109374,1964309,2664006,42428,26740010,363505,147609,1984347,2095895,1716696,273030,255823,49497910,7738640,1736356,192523,1747444,2076379,14557855,129814,7453190,1631887,208002,77540,2074827,1732862,240386,1968497,39226898,105477,1613120,6497550,26740025,213326,7968981,27961045,1640532,21427,12665315,10223870,1616367,223613,2059361,2418919,1738996,45252,2100430,1973664,2695445,105712,127946,31077191,1931105,2065267,2077625,44080159,1619864,1601151,24874128,27808178,156680,4442302,1612993,26721,35677466,12406905,241670,206854,1622354,28508,31775662,84734,1616483,8537205,1602702,2456978,75009,18777721,1946548,27998615,2102509,177255,11753999,35658710,1618898,383292,1975478,240404,31116306,22968535,165805,1621181,1971885,2088021,6553977,44869050,2103087,1967144,113408,1735734,38008495,1737328,1750146,130455,6553923,221382,4525614,1629466,198498,2458424,166123,2073473,147033,203131,47294199,1960667,2079352,1955738,384186,106287,35206879,154180,1633679,7969782,192497,1940444,2078829,15103887,261973,31115865,1826326,2455688,1976408,1640939,52769,225267,2104885,1985660,36640521,16605339,268827,1822022,2457650,105369,1714298,1988816,44831,2679052,47398,103499,191407,198814,43604597,250387,1961040,1746966,2102674,172278,1930243,203729,1743927,218829,1956154,1961528,162327,1959573,20023418,39995931,1980474,39355239,25766745,43758,122780,254246,115604,2089643,8844791,88772,1568248,189874,2076325,247967,214433,39669088,3238663,108052,11366349,16421480,4791488,15375608,212929,1952501,27090024,144062,12736708,32662482,22680310,38423,2458008,1973992,1624776,104513,26739443,1173742,41003922,1715485,7452869,27808362,2086407,45930227,79343,1729000,1981594,1619305,49874948,32582,2674170,1713909,1602438,2095239,171353,2092638,89456,1984904,1959845,1907111,17015951,122838,42724874,2079623,185598,1950667,1948900,35666828,49502,1972326,16349108,1637797,51151,362414,2073379,31719532,1947615,1906189,43384764,1968062,1965841,15176277,1615738,27419533,199742,1968105,174544,1973018,1975018,25577919,1825612,2455321,1989124,2097271,2459068,1906073,1568590,31843325,196032,1982812,2456436,46461361,1616174,20926241,39976679,27807120,1713325,39007,1627999,2094141,1628181,1715692,115223,1980389,1615164,177439,1736761,222266,1603799,2074900,2458171,223652,50341773,2096844,24523,39312810,257550,1729658,1643418,43139185,2095526,1631825,1633887,21543,9735393,143537,209859,1750909,204342,7453044,4062709,48663426,245784,28470795,2066582,362255,1612687,1715444,1976486,1737173,141729,45548175,2068685,245060,5957902,167903,1623492,41198724,1730727,1736068,1633946,53948,20969330,1173653,1906621,9667712,1616336,1959784,114786,1988385,154873,41704397,179171,1714209,367391,1616740,1944467,170268,1740280,2095828,1744810,27298,42433218,181441,1625983,2097024,2587898,220170,166027,158731,125397,1625836,2104085,38723937,4061376,99228,42724832,1621367,32750792,1970440,111521,147399,32550,26739827,2454161,32996115,40556,99548,1977942,1954524,272908,11862006,1624928,1634078,2078155,2455852,1972642,95383,2085415,1970788,1615190,363337,6356118,31341359,1627052,100207,1976710,33100,9629647,1616614,1739032,190210,26740247,240971,111651,384102,91914,7453037,26739398,1740354,1744231,1603697,88688,108664,3029831,1612937,19763617,39599857,1732394,1953332,158905,203617,2060465,31625,28256420,1821861,79030,1946582,1906112,1745037,22149472,2084188,2853535,85536,1623962,35562327,73395,19928947,1648477,11185192,1932470,2066268,1978568,90081,2068749,265965,1959487,26626,1616087,3224898,222898,203577,31341209,1635377,1621908,174987,113626,1603030,223333,1968789,271807,4062673,1614767,1823239,1994761,1986581,194565,142948,96266,1906916,1568301,132556,180387,22786995,2074772,1173491,4061962,42724862,213358,1972286,42449618,80509,242014,100061,2096933,129897,228125,20203610,1615619,15050850,1743604,1952660,1951622,273143,1983002,1821623,1823715,1991623,1612831,268647,157224,12879307,26570,190150,1736675,1979726,43686,1966865,26740045,1616197,4062830,30101,51301,2080497,1977210,2101927,2457195,30564071,212715,15136578,1745311,1433530,1823597,1625784,204651,21239,256037,2063414,12879304,1628901,18777978,6110063,1637071,1946528,247180,1906356,1977863,2456739,157283,2310457,42442514,30217324,2073691,2084025,94222,2310556,1932213,1906901,1736773,46578,39069619,162361,30764208,180717,9576144,240156,1941076,143448,180504,136555,34716,2084957,1625303,1939806,1821723,183290,90672,7217358,1743364,1620892,1612739,227604,38904,2071163,41655080,24896602,2093780,2095926,1702930,1616081,1616053,49215024,269023,171662,47929048,46409424,40739609,51213710,2458552,15116614,82308,243839,2457804,1616507,1989224,48313371,198592,1945246,2097480,15136325,75959,198994,36619529,1947728,2458566,1614903,1990403,2310359,268951,38050667,181329,9576135,29699643,2100448,1748634,153833,253939,222990,1737555,1717100,1986476,1972521,18680,1567284,205753,162295,1626802,1994732,11508819,6497634,1823467,36640534,1748466,1600028,102508,1748613,246306,1988731,42682885,2082293,2073304,48265993,254301,126983,25667,1993620,1746070,2102419,202690,1905920,1955508,2080795,150197,1735385,1955476,195347,42085312,383027,229144,19852,7678621,272273,46904062,26021709,4608269,1952996,1741616,16648129,27082,47840451,36598477,83792,2075527,1964801,1966779,111071,132606,1942274,1821814,4063570,242786,18810410,1964932,204204,149098,122527,45468398,1600537,260577,2104833,1906009,218032,1978760,26342359,1616440,172344,1946470,46904829,53913,1600797,1906795,37868894,2100932,1615533,1987585,51735516,25423486,171085,86366,1973855,30751,2079798,2457556,25366,75414,2095070,362951,18755389,204745,383672,4062278,2100087,147869,1603875,41752708,1601425,27868,25135852,27066902,138273,1947373,1906196,1750798,35566,2457692,1567017,31291,1970986,217510,1744374,192391,257732,9580541,1626131,12141175,1738037,171586,264308,363139,220348,1622502,1990037,1643921,247473,3259752,1947551,263626,1638661,45539296,22916,77676,1740806,149216,1830603,35070,164198,1627273,15104158,266341,1604964,2098830,50010802,185698,51034,12910566,1930577,367184,1943475,1827779,25763,4062628,200595,24242,185888,1823188,2081770,17208002,12894885,26739942,1930130,55010,1822910,1952204,4791432,36640511,26342382,1626378,1829479,251659,166529,1631899,82805,1930324,257470,1982404,261585,32356605,2082242,17275786,22680313,2454304,246469,43065,263995,1643109,218149,1825793,1729443,1973390,142318,2079240,23184951,54166,6645761,7453002,7967625,130324,146288,1954889,1646258,2086648,173543,1630256,1961622,2309376,22047,76562,106445,2088936,170725,113751,9886077,26739866,2086547,20512295,2090036,2073619,29827678,155523,1731831,1947886,25681111,1627443,2661087,1933417,37868363,22817521,1821641,1969595,26851,2080450,1732918,384050,1568439,26739976,95043,155681,242072,164234,1646822,17770044,1616532,4061766,1749288,1966404,7018201,1600619,3283074,123820,1934252,239049,1824605,2458357,1951675,1930168,6493635,1631084,1990830,4063709,1734240,35522295,26740200,2454928,1962754,49253798,31116495,27066899,251539,2078695,135345,31788832,1829458,2668546,112984,210638,1976273,1821635,13818591,1635930,27128134,26740097,1964283,26739895,208516,43702020,180306,1612889,34372366,1828510,178500,48675,1952101,1626682,1957311,1905902,5949155,4062202,1716944,32353,2099533,145685,134831,26740313,11366305,2458294,32010,7453218,33664677,219299,1630801,1730598,1964869,169035,43804,26739885,173923,26956680,24767422,2433263,1633539,43414,18777967,15730622,1626047,1932966,174941,1947843,1633857,1730657,11213989,50630461,39952681,1825302,1634109,87518,43433,1987706,3118747,17275737,1729762,14623690,94404,1987149,418173,55242,29789564,1941268,199364,210751,6515449,18743447,210768,193028,187911,1638980,2100256,4090781,6771978,4061211,128649,205800,48890,36327,2663172,2103027,17462725,2099474,97682,42060036,176068,1945485,45582974,163235,36160,1740164,9455321,2098133,107859,1827458,1643509,220948,1733314,1616296,11993543,2100055,209213,1734194,1635895,1994889,1633581,135252,107594,35666833,113462,1938764,1969008,1628231,110374,1616284,1955273,50536907,1742419,1616047,1959616,1567748,1631781,148975,1745878,27795127,1629285,17184421,272587,20885,44433919,1953708,95652,1957466,2093671,182728,2662461,1980623,52727,241967,1952166,30576713,1953774,46648161,1630285,2100672,20059276,125661,13026962,40739591,91582,187073,12149352,21193899,131790,1938835,120627,150639,1980402,83429,47921,4063767,48313377,2083262,47158244,2433243,1827613,208746,39338675,199934,1978863,1748874,222748,1615872,37709698,14660255,1737602,34270,4761749,266888,149400,175147,3213244,1632111,44660,2081732,1946327,1748326,191047,10655859,1627127,1619716,219157,218235,27808352,11245625,1626974,146397,1969455,2097551,1741179,8388408,48981909,193372,1936897,1941039,2095560,97583,1907420,3259747,260555,2097436,1931440,1741019,35859506,362238,1986627,109827,2098691,265826,1622327,146150,384128,206964,31665450,2457621,10490264,1982005,101167,35617129,2080289,2059088,1930330,219645,130955,1943815,1619113,177852,39126410,37366700,39621948,29614,179886,101590,1965827,1728156,204528,247088,88890,1741720,189670,8618578,41546,1736996,165965,2454461,163958,2076811,88601,2194254,18943,38373,2076099,2083376,4704486,106657,135012,24793,131774,29754,49169351,1625388,1618699,200435,18375,159639,17574337,1603434,1616360,1629040,2457291,74091,211686,45082,15201310,91679,268711,1733186,1985351,9108294,1730704,99678,1948441,16306657,2099138,42724868,175792,186869,88849,118221,86434,136526,19763638,249413,234239,1960316,26739802,220403,1740843,26506,13440568,49758724,1969075,1567581,30724471,2456226,26739817,5367350,1746508,55108,104781,205724,84605,1959380,1635202,1733895,1960586,1939951,190061,42830442,2670355,1568474,51358271,1714453,1612667,7453176,54118,147969,25806,158481,12785402,1955319,1962451,30482936,226339,46597852,6342564,382988,26740000,39687,1637716,2453808,213047,103526,1643484,18175240,53239,107023,1750841,1989566,171116,2094094,13768757,2082137,26739772,1988269,180460,1824146,166413,85808,203882,1906873,7576136,261287,2085249,1713102,241513,32802,29263800,1612876,52476,122101,18778000,114251,48569875,1934349,186236,15432854,115132,41494,192660,199295,22452518,1949573,2066945,1975952,39083,1712994,1615080,162820,227765,29072957,2060888,17068,1943105,10680394,128992,35740,1616064,1972350,1823959,2095125,1942503,1627828,36095,15118655,27294,1906052,220531,36066,59655,213063,1714377,2310347,114925,46237639,2083636,26740325,170765,129031,1829717,41634802,119809,168606,267851,1703009,7938552,39198,186209,220238,73343,121463,1614837,1973431,1748469,102266,6645739,7571608,4062381,86879,2075240,2674068,1713862,1624179,5367353,201732,36258298,2079301,1946502,1740630,383139,1931733,26342176,1635256,2084861,75680,31543,24448,2077377,1602100,2663247,193952,25724,181278,2542786,225007,211256,124113,48563836,2081298,1957280,42682918,1731339,1632860,11432158,260687,8695297,72773,18290,17593669,7453121,2076905,1989012,149155,1939108,221442,48570,1739422,1930178,161406,1967445,7452925,1967244,1823225,35736,97550,42237,1950988,2078764,27961048,2073500,9798794,5128445,31823031,1615731,266549,265878,18777989,133017,23455826,1625225,170704,1729347,1979549,136181,1950095,2098283,43826963,2103294,26337,157541,12076227,146183,1615295,1621086,1946065,103592,110254,1615202,2061355,201789,4062128,1727824,2077723,1615308,77223,1906249,47202201,164042,2099763,2103076,49790,1976167,1976678,1953156,1603350,250658,5957896,1981054,159538,30838280,79424,8388337,4062044,29619,6995557,143596,4608272,4061075,226977,1967514,1991413,218076,187180,207109,47978187,47463,108003,31159141,161033,4791467,4580781,32658,1942813,1930161,1944324,150701,1644507,160120,47930787,3022806,1961476,1984126,51503593,1737665,1622191,1906035,2433398,35382,84439,47644592,120394,192003,1937544,15176332,23899160,1748796,1173124,1954391,114455,49304666,1934723,28923,1948291,1633762,227558,47781,203901,187757,1944638,129206,7453135,6142093,221173,1964612,1627654,1616585,1975571,42581,5732976,6648868,198380,260613,9665940,9290160,7453079,1955046,40066871,199700,1619289,1906816,45794146,44526349,1614713,11365151,1944838,171549,1956007,1615674,13400708,18230,1946951,5160343,43384770,1972399,2102365,48897409,141995,47698722,2080254,2083662,20847844,50325,12578480,1942441,192033,1737106,183531,35757609,1963035,1628284,2097158,1618763,1622139,49345129,102814,1601128,1715510,202202,225114,1621542,128254,196249,2454738,1173892,26848408,1745913,181569,1621239,2063458,40739599,1603635,1964207,13377190,191815,49681004,182482,1946839,18777644,2457782,2084424,34358,13734739,193149,4062328,1742316,1615991,5315068,207463,2080600,21179,5315087,173082,191210,1146742,1741842,179680,1906454,50593655,134714,1906719,1625496,1968982,1959914,1602028,36531205,1981153,1829617,107555,1743384,98639,1945227,32449058,1980881,8745860,16306542,107672,148211,111341,2456727,197310,6775712,1741295,1991492,1644484,37868209,2662512,2098851,1631532,1630912,33905,202441,2098069,1746888,2063926,1826473,1930778,96619,18411811,41879,18746,1745839,6497583,50963,1626162,2065999,128321,18776204,210522,19558,5418389,1747672,1969057,22149479,42350,26740269,1603143,2674165,10684008,48891238,1602287,2066831,166611,1829408,2458159,2458220,2657360,32396816,257010,105748,1730586,2080414,14913875,108881,18776406,49619462,1954031,195752,28828,11473248,27066893,2103465,1630848,213843,2433378,119029,1821979,1821849,1745175,139824,141472,1974283,7453107,1950811,34595469,1730031,135685,37667633,1615580,25101,16463906,252035,1951116,98451,1612635,384041,1978670,6771981,1625728,26244429,1734343,1972169,29907,1966986,18355899,77134,36935,1628266,2073801,186921,44526346,2100970,1734330,135519,1824754,1728960,11825924,102372,1738785,2101765,34613539,150349,1970810,31116045,1612895,1747203,117916,1717056,2587910,245836,2084613,37217,252859,98309,2458503,1634862,2075421,22882595,42105593,1626620,259830,1825448,1947083,1953230,17253013,2669983,5128432,18094541,1967010,225967,3402215,48716,1612643,1735505,1823127,1957246,6497563,252258,265255,2194150,129501,2098991,34013,1993242,1905995,46968,2458412,41406325,141562,13205136,151676,1739062,1616447,2081964,29658086,2486062,20847987,200772,1938666,2457048,264897,213925,53347,6112301,1714881,2663977,43594,2458056,148779,1628590,49917837,1986433,26739635,12076233,2456775,9872791,206198,26739438,1750182,22892603,245508,28867350,2664864,92184,2457383,1906432,227572,26684353,87071,134133,1600091,1930954,1974937,128777,2368223,35313684,157401,262376,28876,7969785,1613127,1736412,44339,122580,1714423,1627958,1947355,23185284,1729176,7453051,183075,1626894,1949730,18777677,1625179,102697,13415036,1978012,1952359,3259849,16942941,54243,1936218,269445,2083146,1739846,1821791,146129,265768,32979366,74880,1970969,47698731,1976072,53159,89886,1948065,2100270,111370,229040,2673541,9490392,87409,2456765,17517682,7453009,2093030,93903,18129824,2458779,172618,91383,49522274,1747228,2103588,1942686,1744492,30148041,177240,224600,180007,80315,33401,2308773,39297,54763,240436,22621551,3283083,1642524,167765,163837,1633774,145447,26147003,2673903,26740040,21285943,1714772,250060,2455657,1602987,1994545,181966,35322667,1955624,11365272,1943182,3045210,212576,1749431,53293,6797421,4062640,49029361,223466,15221891,48208705,15419098,1905927,2104698,1605293,11106490,2092540,39998,1630519,1821762,130049,2059991,1733965,2088994,27866430,1637922,91812,1964231,22213550,4062921,1825519,1973794,21622,180106,186138,1954696,1962811,91479,1648359,1615601,245240,143736,40425,2062684,39811619,256266,1612928,1620371,110435,1906044,22568743,1950062,170037,1970018,109501,261158,115416,1567972,1750076,4062067,1620967,5612752,1626287,1740105,1975755,1615997,34037741,18743300,141037,82419,1952424,1952040,150008,31159117,1734086,10374087,177333,1966440,87012,2096960,239438,1990469,26739393,2670885,1605263,2454904,2093462,75106,2096778,1931242,2102784,9283115,197565,1942484,31569228,28278,27947163,1821596,1994800,2194142,2100103,24767419,2098651,261338,41064007,22680304,13948636,15498539,29547,19472755,1729870,1987339,1620732,1713460,5315124,44781629,1906059,144860,1635138,205363,15243082,2099178,29658091,1567898,31077769,86746,2066133,47981,42785,89565,241860,192804,15399851,34024549,218423,190383,146703,33077,1965726,189166,89972,120883,178599,183196,44781292,163032,35238,46450,41909293,131179,156225,18250396,174181,1567186,2458381,21489,1639599,2104416,1992841,1965052,1964566,1616103,148602,50135,38549,46316,2081799,1966896,49924348,1617658,14913865,100524,1739806,154608,49580925,162146,13468069,197746,9520223,1935741,9484915,1625771,1971299,1748280,45430771,2060384,1945611,2074396,55324,193518,27700476,74347,129250,1615509,118332,31259,1716290,229095,143682,202332,48863,174091,182335,1982334,227270,2853499,114609,2063745,29658071,260508,2457968,1932526,1976860,1958743,44222,1827876,1750628,1906066,96112,33321359,222689,1737844,21327,7162763,11328801,6262634,1743226,1636646,1731875,101969,1986865,1633182,221094,1971221,1646091,220755,2455815,185961,2097383,191455,46837228,31406340,2404275,42655,1942177,1935486,171766,19725,131018,18328480,87467,262579,2457118,26739782,1731019,1983752,173880,194797,26740304,1906852,231694,2457960,126658,151568,1716720,28875683,9290146,1619797,1969702,200283,50347967,2470567,205199,51021493,1829900,3089986,124869,1614785,41365379,78233,1627570,109234,2853529,1943997,190819,30205115,250318,219804,1952542,1955936,15465861,1711987,19857,2086710,1975247,1963111,1732645,48663392,1906157,128888,1739549,1712819,261487,48804069,1632762,147531,1729604,93789,246876,1742867,140325,1937367,224446,1987293,267623,1822030,1630109,197379,1714248,199975,7186183,1173693,1828318,126485,97332,42769461,1906079,362224,49046532,1712652,2082312,8694081,176897,27808188,1627633,108551,1824952,225374,165005,18776567,6497577,201425,1907004,27740,2087497,2674009,49910,1989189,8142109,1737987,224773,11993589,192842,81753,1906297,26740175,47240616,2080640,103365,88291,2673150,1982238,1633994,51194931,42114,9395965,1613214,26717,19359405,2062975,203636,11993564,1952246,2075683,227190,189123,1743467,1950753,165937,163153,1728547,98441,31613769,2082202,2099252,9491906,18721781,1948166,79212,176200,27224568,72285,186176,1990242,136496,207763,178072,76900,45923,133247,90363,1624458,1736268,265066,10114007,1627739,42551,179242,1821698,108989,1743486,166311,1965803,2310269,32526079,21862384,7542353,1953112,268304,199275,1988015,223447,2100329,1974607,2669356,103348,1745650,362915,2080698,1642449,1948827,90455,212729,1613038,213283,169612,195314,189988,49387,1907362,18813,20188,144556,1944971,117646,138939,1641782,2454032,32305843,2099561,1745241,29341932,1979347,15154165,12771836,1951986,42811906,1750052,1748970,1994480,1745277,73689,1948646,1975511,2074117,32806,1828360,245659,3176489,1633707,2077975,1947435,221512,2458323,2098617,367300,121533,1743705,42753168,1568651,1986758,9258388,199538,1826683,1974414,23077,164711,35908675,2104401,26740165,7452960,19587,262446,1616142,53593,1906859,79494,2073525,35697,15668814,1615279,46874,1942414,1743212,1634090,16854,139639,37911918,1969164,2310476,43155,14659907,2458494,50631523,30852,54523,1995257,245591,171978,256818,81316,1616351,1985174,8722785,26739961,4061779,1823090,2566254,20989,12664872,2064513,1749921,12879310,1948108,1628839,9923960,2087461,26739981,2100307,4062912,1983516,45198113,48625745,27076239,2673915,29649833,1736174,268989,1567825,9580537,4442187,1629078,97423,1965631,2090846,2069310,32689,1946779,20708505,9700388,220200,18891,1567956,36427,157521,1937978,1739830,2081355,15176970,267501,136200,16329832,2097194,36655,1964182,49299937,4062004,1738782,195022,1821740,2310272,44735018,36619704,81094,48368127,18462,194023,94373,2103832,11618312,2104824,2086322,27685,1621646,1616514,42724847,2455156,1613013,1821686,1944590,37308,2092835,1740503,155356,4063277,168651,29104,21821,202554,2087201,2080323,162891,37038521,2104003,243209,1621340,87219,1643222,48496,2655510,250696,18323640,178337,25025,1992182,26740117,209054,41160,2099215,27520,159064,2088269,45756976,1628949,1985246,52980,178433,23827352,1828920,3213231,89549,2193918,26739502,1620709,1742732,1989882,1976365,1641179,18777688,160801,48313374,2096916,1728417,9313566,46152494,1619453,1971267,1980341,1969741,27167031,1985474,122139,18743311,1981834,115353,206641,2084234,18743357,241333,1713366,26739378,2103756,140059,244711,156556,181736,21585,2101006,1971966,21984508,1824347,108780,228572,1749742,160203,181045,28587,170518,2458107,1745085,18777710,1750886,45886154,1735985,2529886,1825713,26739927,29764,1733379,50345014,228288,1638201,190504,142725,1638938,2094594,2457590,1946296,189598,25156,27972191,4149203,2078892,1950128,23055,47487,119873,87899,1994502,44079175,2088142,155598,4063160,1946806,1748682,1567525,18743480,41643953,17364709,13468660,7452890,1640108,200867,144833,1993788,78778,2697866,176296,1630452,4062249,1630992,8484467,268279,1567553,1825677,45112981,1715325,9282725,76116,2059260,179735,2457544,218042,2096901,157359,187460,2530025,2367452,1961503,95872,1624206,4062150,174737,12212021,1906119,75600,1986795,1612971,2081145,1933088,147152,269401,2080196,26739890,2104726,79763,2076223,19612,54464,47257351,1954958,26739861,1905954,197835,266691,43399592,7453183,37746,1643752,2458698,1732231,26740055,1631995,19763596,4062325,110467,84693,1627038,50692778,1827242,29788089,1957403,85437,2099973,267678,26740170,208674,20643,21273299,1620087,18776174,28657,8870626,26739447,263240,1615547,207942,39558266,1976549,114041,267700,211808,114017,21905908,2457179,2456108,1983681,23220930,1995175,2069224,81720,1955577,119054,13723644,219501,1829134,1743691,2077788,1951313,1644056,268018,1745374,2829775,10680223,1972784,1638503,1627793,27187816,1645885,1612870,4062000,1612675,2455960,1976587,26739995,2368235,1829510,1627758,22868106,18743469,212066,32570989,118392,50011,2078747,31967,157428,264448,1743288,4061187,32356610,6342567,1743861,1988347,251865,151492,1627365,39908198,1612628,31215812,108195,1823886,262206,1907143,2977929,1826686,54339,214015,1955956,40661069,1954921,47247472,2067310,1619633,265378,2978039,250174,47158211,26740092,1647275,33072200,42105627,229397,1829934,1604437,269473,1733491,1987442,19115,362789,1968807,36640524,97625,1823821,154116,1620528,2074228,2098385,268424,26739856,150752,2453876,17823,1734285,202896,1947958,254732,29789097,2088680,135403,2530049,223733,21363,22870909,3359223,1968884,83176,145258,1741041,46236871,1968049,218867,2100577,1738871,1744760,2433361,1948321,26899206,1980584,251064,1943586,41793,40066879,1749855,4442181,148376,1749371,2103814,17030,1615228,107364,1979378,18777699,14383937,1643072,4704521,158648,2074958,6208703,30177468,22475,50929981,1948687,2673848,96924,1954287,13770777,31116650,157109,2458788,22166841,1742389,2670158,77403,2458275,2084894,1732456,1616423,1616459,2458372,48563833,1627511,13873463,1620303,4442305,2081584,30525605,1949818,228314,48017,1601222,1739120,1939308,13979961,208902,2458026,50086,2078594,7453016,38973570,2088227,1949004,1619615,1984371,1956116,1730951,2089848,2104878,1636022,1906305,1625285,26739787,46201539,42811912,1944935,21161019,1955685,4062757,170874,46992771,87380,14049003,1638406,2457774,34983,21308116,4553064,1619257,48625751,17001,52068,228944,2074334,44032105,26739971,1616601,2073888,26740299,139042,1947198,175319,208378,1951179,1821680,159735,37365,209807,1737009,1715597,198307,191266,1945531,81527,132281,3263472,1975076,1957306,25522,41108210,1729389,4580806,120959,2065425,1627301,1953538,169525,85349,2458315,48557901,1603557,90791,4061656,1639755,15468314,1987973,1746456,151031,2457745,29195233,176007,1733241,1635495,23106643,29311463,212394,139252,1943508,140362,1746933,193693,26739881,1615773,28138429,176111,1976935,30756,2454097,242260,1976233,1967217,25076569,220693,1945464,83126,4062502,91299,11993553,1343842,1979472,203485,1932817,1742670,9129444,1750660,46703369,33294335,11993491,31341041,1829206,17626,26740150,1730546,39225314,1633155,50850,1735769,29788817,1985962,1957212,144374,7757553,27056,21859,17418,2104851,6553925,269773,2060516,2456579,1731471,133887,40935234,17126,198187,1742891,2059767,1628028,248414,1952711,26970673,1633276,33178,170382,2669496,47247486,100829,2059839,139974,1945680,45143324,1623716,4149175,53474,26898515,2692476,1619043,1635028,160614,1733355,42444600,10261747,197713,1741314,1829164,27858940,12143455,2456405,1742359,208932,241089,1968121,39922,26740020,6497598,38300874,50760,13447471,7453128,29311567,2095022,1632749,2074632,171224,1942882,26739832,31514436,26739452,1742970,160247,1972255,1629150,139584,9919871,2684053,3190322,31439157,5160340,1981655,1624490,1967866,26739871,1988874,223044,176457,226499,30843,194884,50613474,27189478,167986,122718,2459254,1620033,26970115,2458255,1966219,259359,12176479,34887538,42769482,11436541,74030,9556507,41305633,1625132,50189,25089373,1978718,12371222,26740102,46852469,1977743,1702996,115545,2458389,2458533,37484,1739695,245926,220877,15028571,4063373,20926250,45167318,1979421,147191,1824908,26740060,18432,263186,27199439,1845849,1973113,36299,1954604,43641,41239,8924340,1960208,1930118,2079581,1616205,2089077,2102337,1616235,49548929,33059182,96354,1746266,4063525,142776,1970366,1829797,40704,9566396,1823171,1938339,143351,1648428,156464,1614803,26739467,72244,1821836,1906021,24118,1948700,1600513,189271,1948414,113085,211759,2458151,48610530,1933433,38583,131085,15843263,1949421,3379737,1972047,38807,144112,48416900,1824253,1632798,1948710,26740112,4062664,1825011,154821,48265977,26739403,1602235,1173121,1974684,29903,124694,43822465,7452967,53131,1983110,2071323,7452883,90162,2075353,1624901,26578533,208283,1733120,1744741,2104798,1994693,2454173,174583,2075753,51216654,175690,26740205,1953997,1906635,2064618,44780416,1955042,1602560,2066351,143038,48753192,158547,2194032,1733212,1974566,54798,2082700,72528,175902,195113,46284,27471,14055216,1612780,2676863,1968001,30522747,20840,131839,8722782,2078081,23620,1737668,1950873,7351637,1906263,240120,1715129,1728707,188200,2659288,48891241,1826193,1612807,267580,1736830,30448600,51357,77798,11753981,1989517,1604586,198534,226215,18042,1966648,1989268,26739876,1626927,1568361,132704,1173254,116132,1906838,1930310,226395,1630724,209292,29789889,100682,1932776,13418149,98483,201863,2100175,1715186,7738339,1990911,32108,1821737,1963049,2104858,162257,36617,209483,106347,1830380,266661,1636769,1946671,10141050,1612950,2101108,26447592,118447,195386,1958966,1730678,41615,217376,6112501,1615178,28980,223355,2080902,1648586,4062431,1616313,14383638,267023,1906766,32076506,1826136,204776,26739841,1630213,1948486,18861848,28035682,1823539,39575,138331,1632225,142528,27370998,1625445,210887,53817,22612,124337,90830,1612615,45830452,203308,132156,45916289,43472,44172,1731437,79610,1970828,1647500,1951749,1993711,2457950,110677,77357,1907248,1948847,156762,2070983,2078992,229470,194471,199850,2075309,1955349,2065098,164309,111604,1828221,6945367,1989698,1987221,2104865,25414206,34961275,1602156,36985954,2104733,2082637,1948522,209589,1622643,223960,47196,1948303,2529904,1981922,1744618,2655626,155984,221593,2098514,249659,2459044,73900,42811918,26740309,2064168,243765,101403,12578470,4442214,1821716,38702048,9624503,5367405,367388,2103223,202479,1965992,1624588,28091523,1620331,2455138,1632497,35341,20668,203394,6553921,125952,176637,1628215,214424,263716,41198698,1615966,26739383,26739418,55395,2103968,6285088,1974902,1621213,2082220,1625798,2085600,1989832,1739920,30731557,4442120,244217,1635097,2309712,21942,45532997,2097213,97982,1988766,1826626,4525596,33623528,177510,2093101,271832,1964588,26739900,1742580,1988207,2455301,26740070,15862624,1631106,42478172,266360,1994374,11758096,1985522,26740035,1567028,28929422,1947469,2611644,1712193,1742445,8924349,187530,196171,1966052,50929972,1973715,1742539,1986716,2530046,1731048,7453204,23720,96781,41710,1960354,2094928,2104019,2661674,9238291,221136,10664738,1602757,92398,1948505,1621683,141880,48320437,254825,26740160,2081934,200906,11213840,31116629,2457931,2073574,41649,1828194,24629767,147221,241827,1633506,191516,48981906,30806616,1993209,1613190,18778011,74121,2088601,1821629,79926,1750906,2660012,246756,247897,2103875,8695139,1970550,1736055,26739373,1989734,161664,128052,173602,188963,1614843,151636,43384,202588,113160,1612986,1953810,2070746,164573,2670780,1937469,40707377,21211748,101873,3379852,36640514,103317,31747387,1735975,2075049,2087883,40818577,1628124,40818583,101229,74757,265305,1729120,1821963,26740242,4061295,1954488,139070,9284087,212020,26740265,116231,2088558,23945599,2670053,179118,9019876,1733028,2671474,110842,2458180,98121,1989922,156882,89073,43349109,151225,121638,94870,210718,177157,179813,1977077,1947826,1739074,1949614,135829,1601381,251348,225305,192284,154301,21659,27486615,107057,2455620,261005,160274,1615159,2667097,245886,157061,41655076,26740140,1955268,23898867,102868,139730,363102,40649956,1905888,1826556,185045,30841045,1977652,222491,25273,1906328,1972880,26739932,1964833,2309544,1977491,1732250,1905939,1615680,47644595,169959,15187823,1906209,73135,162656,1640841,1971898,21368,32751,1994096,37260090,23991,2097352,228081,23920,26740135,124718,1821580,1615663,226049,14957863,1950703,383021,220546,2457187,3411816,119718,49350028,32938577,7599407,17354,12894895,2078864,211891,1980811,17770,1603081,1938936,1620510,1635360,52516,266112,1633626,1627590,14915031,1735663,1622914,1735488,213537,200126,33768,1737642,1635550,26740015,1953633,46121793,1982263,8728584,1619430,156918,183391,1600709,2453569,12253627,1712703,35829,187810,16110362,168470,75898,2096263,31203,174798,16878138,2072287,1632926,2104304,33363840,135205,145003,45344641,383578,1623305,46933,262837,1712283,1750061,1933727,1743089,1732163,1906601,11993576,179201,40480657,1967192,1736494,108105,48224470,24109335,45756981,36640531,130026,92309,33031,1648391,115484,2100004,1987463,1970266,1736122,102976,36664,4061087,1822011,26647560,32203081,2457171,267186,121323,1906802,1937692,209351,12370461,173273,143950,367148,2079525,362476,31953,189797,2679537,39952619,1713759,50330123,5418347,193837,4580754,4062806,1604920,4063718,89349,249733,1646563,44528295,1948977,103051,260733,188894,42682901,26740210,2456969,45582,178215,1750647,185065,26740030,4062700,1952143,39454,1955952,1821748,362207,12435028,30400,91149,9529160,18777655,2100144,2454119,2081263,1953092,228246,1972735,29502930,17676,1604675,1970644,1981615,20577,1941684,186259,42977,96059,83605,176244,1632429,149700,154758,17197373,12253807,1930304,1616249,176678,2457393,16552093,29109,241752,205897,2660121,2103326,88121,24375268,1624824,24173653,7941416,12948653,7541413,39377,271621,27631,181884,23455755,2100659,25851748,1744654,1601631,101813,145409,7969551,2459142,26739822,51333826,4062845,244552,101798,1827525,219012,4761786,13169002,35324,134210,242703,136417,1632608,1616557,1622686,1634372,1733744,1713138,42448818,199099,1744456,2103431,41278917,12279128,1735334,1623678,1617964,136066,26740079,1645091,115150,1969581,2081691,50330129,2081916,243999,1952871,1823052,28124,223285,2077429,80881,2103495,161875,1732419,9394208,41796413,240646,199831,1905966,26740050,33002564,1955972,7599993,1953506,31820473,29789987,2100549,26739792,132963,30192347,1824745,1615695,117438,1631738,8925508,1826269,1942388,1954551,96544,259743,1630154,41453473,1648697,218375,142897,40646,2457417,1635442,1978070,146572,196083,1146711,2058557,2668273,1989075,1980918,151587,74534,1616374,4062930,27436656,1567369,2696471,25114536,1730342,1628384,9700325,1732017,1906508,1962474,29787925,45319,1615272,35655,81346,17811174,1713496,141808,222458,48625748,1620658,219765,47196812,1627169,1824813,39249742,255905,185208,2081507,16192461,50584316,1933865,1828934,221211,176992,1738191,1943201,1940948,53783,74427,1629269,25052280,28867353,2457153,2529880,27178461,254574,2674021,250829,1647231,1645934,229314,1983086,2458065,1716219,2060738,4791491,52662,178544,1568077,5418662,2083559,2404244,1821955,145614,11687134,1988139,74473,1944389,17469346,8746207,1616323,30763608,1747740,47247,1712323,1960995,22953,2457137,191155,36100,26740257,37859,38290359,30773134,169799,20627345,2458035,2104264,105761,82521,1639192,1604133,1741277,108520,1986914,250245,25413382,41214843,1961578,1990504,50200137,4063327,2062596,1620737,363214,17594470,47650472,212320,2457442,24985,1620998,1827922,1173603,1968641,1972698,49289508,176975,1713553,35994,1983839,1642980,4820748,362821,157466,41366,1906788,2071099,1830434,33267404,33002559,1614854,134322,113819,35456,4062035,1964721,20291,1957805,259918,139671,194307,7016779,1714011,14659516,256504,268162,27825,1732510,22840856,31755375,1746869,113392,7453058,148079,212470,32147,22775,7715980,35241603,33451,31050826,2084127,195225,1821899,2669577,22441,134094,1934672,243243,257803,30980,1823654,4061851,15498026,228197,140833,89709,1950256,156120,2457353,1823444,205629,5612646,1744299)
                  
                   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:
[]
31.77 ms
(6.50%)
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, 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))  GROUP BY dacco.oo_id  ORDER BY  RAND(166)
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.