Query Metrics

96 Database Queries
26 Different statements
452.74 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
56.19 ms
(12.41%)
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:
[]
37.59 ms
(8.30%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.76 ms
(0.83%)
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.18 ms
(0.48%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.44 ms
(0.32%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.80 ms
(0.18%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.74 ms
(0.16%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.73 ms
(0.16%)
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.66 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=1580678&nearbySearchLat=47.25917&nearbySearchLong=15.58539&sorting=nearbySearchAsc&page=4&randSeed=344"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1580678&nearbySearchLat=47.25917&nearbySearchLong=15.58539&page=4&randSeed=344&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.60 ms
(0.13%)
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.46 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.37 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.28 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.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.19 ms
(0.04%)
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.16 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 * FROM translations_messages LIMIT 1;
Parameters:
[]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 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.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:
[]
0.10 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.09 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
]

demi_vacancies connection

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