Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
54.71 ms
(13.15%)
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:
[]
25.92 ms
(6.23%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.59 ms
(1.34%)
14
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
Parameters:
[
  11462
]
2.42 ms
(0.58%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.61 ms
(0.39%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.98 ms
(0.24%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.79 ms
(0.19%)
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.71 ms
(0.17%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.63 ms
(0.15%)
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=1580556&nearbySearchLat=47.42581&nearbySearchLong=15.78613&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1580556&nearbySearchLat=47.42581&nearbySearchLong=15.78613&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.52 ms
(0.12%)
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.36 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.32 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
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.21 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.18 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.04%)
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,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.15 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.12 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.12 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.10 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
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.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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