Query Metrics

94 Database Queries
25 Different statements
400.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
28.34 ms
(7.08%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.24 ms
(1.06%)
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.07 ms
(0.52%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.87 ms
(0.47%)
10
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.98 ms
(0.25%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.64 ms
(0.16%)
4
SELECT id FROM sites
Parameters:
[]
0.63 ms
(0.16%)
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.55 ms
(0.14%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
0.44 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?page=27&randSeed=502"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?page=27&randSeed=502"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.39 ms
(0.10%)
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.30 ms
(0.08%)
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.27 ms
(0.07%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.25 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.21 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.20 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.19 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.13 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.10 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.08 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.07 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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