Query Metrics

35 Database Queries
13 Different statements
475.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
4.49 ms
(0.95%)
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
]
0.65 ms
(0.14%)
6
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.61 ms
(0.13%)
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.52 ms
(0.11%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/en/Plan-your-holiday/Search-book-accommodation/map-poi-json"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation/map-poi-json?randSeed=815&showMap=1&nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&page=240&sorting=nearbySearchAsc&_locale=en&&_=1731523111145"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation/map-poi-json?_=1731523111145&_locale=en&nearbySearchId=29110223&nearbySearchLat=47.53528&nearbySearchLong=15.51769&page=240&randSeed=815&showMap=1&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.31 ms
(0.06%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.28 ms
(0.06%)
2
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "map-poi-json"
  "path" => "/steiermark.com/en/Plan-your-holiday/Search-book-accommodation/"
]
0.24 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.23 ms
(0.05%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.18 ms
(0.04%)
1
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/map-poi-json"
]
0.18 ms
(0.04%)
1
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.11 ms
(0.02%)
1
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/steiermark.com/en/Plan-your-holiday/Search-book-accommodation/map-poi-json"
]

demi_vacancies connection

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