Query Metrics

92 Database Queries
25 Different statements
388.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
36.28 ms
(9.33%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.29 ms
(1.36%)
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
]
3.19 ms
(0.82%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.00 ms
(0.26%)
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.98 ms
(0.25%)
7
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.88 ms
(0.23%)
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.65 ms
(0.17%)
4
SELECT id FROM sites
Parameters:
[]
0.63 ms
(0.16%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.62 ms
(0.16%)
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.55 ms
(0.14%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.47 ms
(0.12%)
2
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.47 ms
(0.12%)
2
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.38 ms
(0.10%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.37 ms
(0.10%)
2
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.30 ms
(0.08%)
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"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.27 ms
(0.07%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.26 ms
(0.07%)
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.21 ms
(0.06%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.16 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.16 ms
(0.04%)
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.14 ms
(0.04%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.13 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.13 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]

demi_vacancies connection

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