Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
54.48 ms
(12.53%)
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:
[]
46.80 ms
(10.77%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.66 ms
(1.07%)
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.10 ms
(0.48%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.94 ms
(0.45%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.74 ms
(0.17%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.64 ms
(0.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.60 ms
(0.14%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.60 ms
(0.14%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.50 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.44 ms
(0.10%)
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=9810670&nearbySearchLat=47.46612&nearbySearchLong=15.78749&sorting=nearbySearchAsc&page=5&randSeed=617"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=9810670&nearbySearchLat=47.46612&nearbySearchLong=15.78749&page=5&randSeed=617&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.39 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 ms
(0.08%)
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.20 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.20 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.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 sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.16 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
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.16 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.16 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.13 ms
(0.03%)
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 settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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