Query Metrics

99 Database Queries
26 Different statements
498.94 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
46.40 ms
(9.30%)
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:
[]
41.22 ms
(8.26%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.43 ms
(1.09%)
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
]
1.95 ms
(0.39%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.40 ms
(0.28%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.80 ms
(0.16%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.61 ms
(0.12%)
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.54 ms
(0.11%)
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.47 ms
(0.09%)
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?nearbySearchId=853815&nearbySearchLat=46.89382&nearbySearchLong=15.26385&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=853815&nearbySearchLat=46.89382&nearbySearchLong=15.26385&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.46 ms
(0.09%)
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.41 ms
(0.08%)
4
SELECT id FROM sites
Parameters:
[]
0.31 ms
(0.06%)
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.29 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.23 ms
(0.05%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.20 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.19 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
  4084
  4084
]
0.17 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.16 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.16 ms
(0.03%)
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.13 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.09 ms
(0.02%)
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.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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