Query Metrics

99 Database Queries
27 Different statements
565.41 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
45.10 ms
(7.98%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
36.69 ms
(6.49%)
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:
[]
9.44 ms
(1.67%)
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
]
4.21 ms
(0.74%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.49 ms
(0.44%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.39 ms
(0.25%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
1.18 ms
(0.21%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
1.10 ms
(0.19%)
4
SELECT id FROM sites
Parameters:
[]
0.95 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.93 ms
(0.16%)
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=854001&nearbySearchLat=46.71856&nearbySearchLong=15.27055&sorting=nearbySearchAsc&page=1&randSeed=465"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854001&nearbySearchLat=46.71856&nearbySearchLong=15.27055&page=1&randSeed=465&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.55 ms
(0.10%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.51 ms
(0.09%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.45 ms
(0.08%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.41 ms
(0.07%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.40 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.33 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.30 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.28 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.21 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.21 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.20 ms
(0.04%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.20 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.19 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.12 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.11 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:
[]

demi_vacancies connection

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