Query Metrics

96 Database Queries
26 Different statements
431.02 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
53.81 ms
(12.48%)
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:
[]
37.96 ms
(8.81%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.63 ms
(1.31%)
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.31 ms
(0.54%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.06 ms
(0.48%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.83 ms
(0.19%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.65 ms
(0.15%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.60 ms
(0.14%)
4
SELECT id FROM sites
Parameters:
[]
0.58 ms
(0.13%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.53 ms
(0.12%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.46 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" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=36478133&nearbySearchLat=47.23229&nearbySearchLong=14.17395&sorting=nearbySearchAsc&page=4&randSeed=670"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=36478133&nearbySearchLat=47.23229&nearbySearchLong=14.17395&page=4&randSeed=670&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.36 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.35 ms
(0.08%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.27 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.25 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.22 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
  115
  115
]
0.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.17 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.16 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.13 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.12 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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