Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
45.80 ms
(10.48%)
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:
[]
28.96 ms
(6.63%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.69 ms
(0.84%)
14
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
Parameters:
[
  11462
]
1.95 ms
(0.45%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.46 ms
(0.33%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.54 ms
(0.12%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.46 ms
(0.11%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.44 ms
(0.10%)
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.37 ms
(0.08%)
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.35 ms
(0.08%)
4
SELECT id FROM sites
Parameters:
[]
0.31 ms
(0.07%)
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?randSeed=12&nearbySearchId=1430478&nearbySearchLat=47.80861&nearbySearchLong=15.36529&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1430478&nearbySearchLat=47.80861&nearbySearchLong=15.36529&randSeed=12&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.29 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.24 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.17 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.14 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.14 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.14 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.12 ms
(0.03%)
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.11 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.09 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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