Query Metrics

99 Database Queries
26 Different statements
455.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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