Query Metrics

97 Database Queries
26 Different statements
449.05 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
42.18 ms
(9.39%)
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.05 ms
(8.70%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.50 ms
(1.22%)
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.26 ms
(0.50%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.91 ms
(0.43%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.77 ms
(0.17%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.63 ms
(0.14%)
4
SELECT id FROM sites
Parameters:
[]
0.57 ms
(0.13%)
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.55 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.52 ms
(0.12%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.35 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.34 ms
(0.08%)
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=1580661&nearbySearchLat=46.66412&nearbySearchLong=15.47049&sorting=nearbySearchAsc&page=2&randSeed=511"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1580661&nearbySearchLat=46.66412&nearbySearchLong=15.47049&page=2&randSeed=511&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.29 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.28 ms
(0.06%)
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.27 ms
(0.06%)
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.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.20 ms
(0.05%)
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.14 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.12 ms
(0.03%)
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.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 FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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