Query Metrics

96 Database Queries
26 Different statements
452.96 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
53.56 ms
(11.82%)
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:
[]
39.65 ms
(8.75%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.02 ms
(1.11%)
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.75 ms
(0.61%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.79 ms
(0.39%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.66 ms
(0.15%)
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.64 ms
(0.14%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.62 ms
(0.14%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.58 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" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=853835&nearbySearchLat=47.18538&nearbySearchLong=14.06644&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=853835&nearbySearchLat=47.18538&nearbySearchLong=14.06644&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.56 ms
(0.12%)
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.50 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.40 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.30 ms
(0.07%)
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.25 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.20 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.20 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.18 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.15 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.14 ms
(0.03%)
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.13 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
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.10 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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