Query Metrics

95 Database Queries
26 Different statements
449.26 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
55.74 ms
(12.41%)
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:
[]
27.07 ms
(6.03%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.34 ms
(1.19%)
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
]
1.79 ms
(0.40%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.76 ms
(0.39%)
10
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.88 ms
(0.20%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.53 ms
(0.12%)
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.52 ms
(0.12%)
4
SELECT id FROM sites
Parameters:
[]
0.48 ms
(0.11%)
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.47 ms
(0.11%)
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.31 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
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.28 ms
(0.06%)
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?randSeed=79&showMap=1&nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&randSeed=79&showMap=1&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.25 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.23 ms
(0.05%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.20 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.19 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.19 ms
(0.04%)
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.16 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.14 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
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.11 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
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.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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