Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
56.97 ms
(12.04%)
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:
[]
28.86 ms
(6.10%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.64 ms
(0.98%)
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.47 ms
(0.52%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.66 ms
(0.35%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.01 ms
(0.21%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.79 ms
(0.17%)
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.65 ms
(0.14%)
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.56 ms
(0.12%)
4
SELECT id FROM sites
Parameters:
[]
0.55 ms
(0.12%)
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.54 ms
(0.11%)
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=324454&nearbySearchLat=47.59554&nearbySearchLong=14.46919&sorting=nearbySearchAsc&page=2&randSeed=492"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=324454&nearbySearchLat=47.59554&nearbySearchLong=14.46919&page=2&randSeed=492&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.42 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.33 ms
(0.07%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.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%)
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.23 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.22 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.20 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.16 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 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.12 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.10 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]

demi_vacancies connection

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