Query Metrics

98 Database Queries
26 Different statements
467.58 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
50.06 ms
(10.71%)
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.84 ms
(7.88%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.89 ms
(1.47%)
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.71 ms
(0.58%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.08 ms
(0.44%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.84 ms
(0.18%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
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.73 ms
(0.16%)
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" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324726&nearbySearchLat=47.2438&nearbySearchLong=15.80037&sorting=nearbySearchAsc&page=3&randSeed=302"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324726&nearbySearchLat=47.2438&nearbySearchLong=15.80037&page=3&randSeed=302&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.58 ms
(0.12%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.49 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/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.40 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.32 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.20 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.20 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
  115
  115
]
0.19 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.19 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.16 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.16 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.16 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC 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,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.11 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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