Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
53.72 ms
(11.68%)
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:
[]
46.44 ms
(10.10%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.10 ms
(1.33%)
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.30 ms
(0.50%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.67 ms
(0.36%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.35 ms
(0.29%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.93 ms
(0.20%)
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.68 ms
(0.15%)
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.60 ms
(0.13%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=908272&nearbySearchLat=47.41002&nearbySearchLong=15.26877&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=908272&nearbySearchLat=47.41002&nearbySearchLong=15.26877&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
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/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.36 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.33 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
0.30 ms
(0.07%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.30 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.29 ms
(0.06%)
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.25 ms
(0.06%)
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.21 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.18 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.12 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.11 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.10 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.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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