Query Metrics

96 Database Queries
26 Different statements
421.56 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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