Query Metrics

122 Database Queries
36 Different statements
432.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
49.22 ms
(11.39%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
32.46 ms
(7.51%)
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:
[]
5.16 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
]
1.47 ms
(0.34%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.42 ms
(0.33%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.98 ms
(0.23%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.77 ms
(0.18%)
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.75 ms
(0.17%)
2
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  191428
  "facilities"
]
0.55 ms
(0.13%)
2
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  191428
]
0.52 ms
(0.12%)
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.49 ms
(0.11%)
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=1430590&nearbySearchLat=47.5189&nearbySearchLong=14.14233&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=1430590&nearbySearchLat=47.5189&nearbySearchLong=14.14233&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.45 ms
(0.10%)
2
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  191428
]
0.36 ms
(0.08%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.27 ms
(0.06%)
2
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  191428
]
0.27 ms
(0.06%)
2
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  191428
]
0.24 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.21 ms
(0.05%)
4
SELECT id FROM sites
Parameters:
[]
0.21 ms
(0.05%)
2
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  191428
]
0.20 ms
(0.05%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.20 ms
(0.05%)
2
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  191428
  "demiExtension"
]
0.19 ms
(0.04%)
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.17 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.16 ms
(0.04%)
2
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  191428
  "demiExtension"
]
0.15 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.15 ms
(0.04%)
2
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  191428
  "demiExtension"
]
0.13 ms
(0.03%)
2
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  191428
  "demiExtension"
]
0.13 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
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 * FROM translations_messages LIMIT 1;
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.06 ms
(0.01%)
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.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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