Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
56.07 ms
(10.47%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
47.58 ms
(8.88%)
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:
[]
8.92 ms
(1.66%)
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.17 ms
(0.41%)
10
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.16 ms
(0.40%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.14 ms
(0.21%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.99 ms
(0.18%)
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.92 ms
(0.17%)
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.91 ms
(0.17%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?randSeed=754&showMap=1&nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&page=5&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&page=5&randSeed=754&showMap=1&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.55 ms
(0.10%)
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.51 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.40 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.40 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.34 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.28 ms
(0.05%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.27 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.26 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.26 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.24 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.22 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.21 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
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.12 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.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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