Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
42.60 ms
(9.01%)
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:
[]
39.61 ms
(8.38%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.58 ms
(1.39%)
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.58 ms
(0.55%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.84 ms
(0.39%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.04 ms
(0.22%)
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.81 ms
(0.17%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.79 ms
(0.17%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.77 ms
(0.16%)
4
SELECT id FROM sites
Parameters:
[]
0.68 ms
(0.14%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?randSeed=606&showMap=1&zoom=8&bounds[south]=45.73217637865304&bounds[west]=15.13818742187499&bounds[north]=48.56671543023416&bounds[east]=16.917972578124992&nearbySearchId=324345&nearbySearchLat=47.16835&nearbySearchLong=16.02808&page=239&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?bounds[south]=45.73217637865304&bounds[west]=15.13818742187499&bounds[north]=48.56671543023416&bounds[east]=16.917972578124992&nearbySearchId=324345&nearbySearchLat=47.16835&nearbySearchLong=16.02808&page=239&randSeed=606&showMap=1&sorting=nearbySearchAsc&zoom=8"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.43 ms
(0.09%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.31 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.29 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.27 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.27 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.23 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.21 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.20 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.11 ms
(0.02%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.09 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.07 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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