Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
47.18 ms
(9.50%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
38.95 ms
(7.85%)
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:
[]
7.06 ms
(1.42%)
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.72 ms
(0.55%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.92 ms
(0.39%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.95 ms
(0.19%)
4
SELECT id FROM sites
Parameters:
[]
0.85 ms
(0.17%)
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.76 ms
(0.15%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.72 ms
(0.14%)
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.58 ms
(0.12%)
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=11723910&nearbySearchLat=47.27901&nearbySearchLong=14.08038&page=8&randSeed=674&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=11723910&nearbySearchLat=47.27901&nearbySearchLong=14.08038&page=8&randSeed=674&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.44 ms
(0.09%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.37 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.35 ms
(0.07%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.31 ms
(0.06%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.29 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.27 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.24 ms
(0.05%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.22 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.20 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.19 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.12 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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