Query Metrics

102 Database Queries
26 Different statements
456.06 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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