Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
53.61 ms
(12.83%)
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:
[]
25.78 ms
(6.17%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
2.94 ms
(0.70%)
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.30 ms
(0.55%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.38 ms
(0.33%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.95 ms
(0.23%)
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.86 ms
(0.21%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.70 ms
(0.17%)
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=4578877&nearbySearchLat=47.67237&nearbySearchLong=15.54071&sorting=nearbySearchAsc&page=2&randSeed=682"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=4578877&nearbySearchLat=47.67237&nearbySearchLong=15.54071&page=2&randSeed=682&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.68 ms
(0.16%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.61 ms
(0.14%)
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.42 ms
(0.10%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.36 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.27 ms
(0.06%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.25 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.21 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.17 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.16 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.15 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.12 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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