Query Metrics

98 Database Queries
26 Different statements
439.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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