Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
56.62 ms
(12.72%)
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:
[]
37.74 ms
(8.48%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.24 ms
(0.73%)
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.93 ms
(0.66%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.75 ms
(0.39%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.83 ms
(0.19%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.70 ms
(0.16%)
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.66 ms
(0.15%)
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.62 ms
(0.14%)
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=324945&nearbySearchLat=47.35649&nearbySearchLong=13.70159&page=2&randSeed=688&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324945&nearbySearchLat=47.35649&nearbySearchLong=13.70159&page=2&randSeed=688&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.55 ms
(0.12%)
4
SELECT id FROM sites
Parameters:
[]
0.49 ms
(0.11%)
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.48 ms
(0.11%)
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.35 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.29 ms
(0.07%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.21 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.19 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
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.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.17 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.16 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.12 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.12 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.10 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:
[]

demi_vacancies connection

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