Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
49.99 ms
(10.80%)
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:
[]
35.56 ms
(7.68%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.66 ms
(1.22%)
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.12 ms
(0.46%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.81 ms
(0.39%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.12 ms
(0.24%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.68 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.66 ms
(0.14%)
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.60 ms
(0.13%)
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=324741&nearbySearchLat=47.57229&nearbySearchLong=15.49919&page=2&randSeed=909&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=324741&nearbySearchLat=47.57229&nearbySearchLong=15.49919&page=2&randSeed=909&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.52 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.43 ms
(0.09%)
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.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.29 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.22 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.19 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.19 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 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%)
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.15 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.12 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.11 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.07 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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