Query Metrics

101 Database Queries
26 Different statements
433.19 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
46.39 ms
(10.71%)
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.87 ms
(6.66%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.15 ms
(1.19%)
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.26 ms
(0.52%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.48 ms
(0.34%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.22 ms
(0.28%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.73 ms
(0.17%)
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.61 ms
(0.14%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.54 ms
(0.12%)
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=1100&nearbySearchLat=47.06676&nearbySearchLong=14.43012&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=1100&nearbySearchLat=47.06676&nearbySearchLong=14.43012&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.50 ms
(0.12%)
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.45 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.39 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.33 ms
(0.08%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.32 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.24 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.20 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.16 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.15 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.14 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.13 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.13 ms
(0.03%)
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.12 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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