Query Metrics

95 Database Queries
26 Different statements
413.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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