Query Metrics

95 Database Queries
26 Different statements
407.81 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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