Query Metrics

98 Database Queries
26 Different statements
462.11 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
49.43 ms
(10.70%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
43.73 ms
(9.46%)
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:
[]
8.36 ms
(1.81%)
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.28 ms
(0.49%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.88 ms
(0.41%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.94 ms
(0.20%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.77 ms
(0.17%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.61 ms
(0.13%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.49 ms
(0.11%)
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=324735&nearbySearchLat=46.81442&nearbySearchLong=15.21234&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324735&nearbySearchLat=46.81442&nearbySearchLong=15.21234&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.45 ms
(0.10%)
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.39 ms
(0.08%)
4
SELECT id FROM sites
Parameters:
[]
0.35 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.34 ms
(0.07%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.28 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.24 ms
(0.05%)
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.23 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.20 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.17 ms
(0.04%)
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.17 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.14 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.12 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.09 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.07 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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