Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
54.02 ms
(11.62%)
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:
[]
45.11 ms
(9.71%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.33 ms
(1.15%)
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.52 ms
(0.33%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.49 ms
(0.32%)
10
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.79 ms
(0.17%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.56 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.53 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.47 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.44 ms
(0.09%)
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=341&showMap=1&nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&sorting=nearbySearchAsc&page=231"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&page=231&randSeed=341&showMap=1&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.39 ms
(0.08%)
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.30 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.25 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.23 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.23 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.21 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.17 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.17 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.13 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
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 * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.08 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.07 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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