Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
47.72 ms
(11.06%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
41.99 ms
(9.73%)
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:
[]
6.40 ms
(1.48%)
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
]
1.73 ms
(0.40%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.67 ms
(0.39%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.84 ms
(0.19%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.66 ms
(0.15%)
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.58 ms
(0.13%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=36153897&nearbySearchLat=47.05161&nearbySearchLong=14.53077&page=4&randSeed=676&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=36153897&nearbySearchLat=47.05161&nearbySearchLong=14.53077&page=4&randSeed=676&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.48 ms
(0.11%)
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.36 ms
(0.08%)
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.32 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
0.29 ms
(0.07%)
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.28 ms
(0.07%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.25 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.20 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.20 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.17 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 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.16 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.14 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.10 ms
(0.02%)
1
SELECT id,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 * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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