Query Metrics

106 Database Queries
36 Different statements
490.85 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
59.94 ms
(12.21%)
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:
[]
52.77 ms
(10.75%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.55 ms
(1.33%)
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.46 ms
(0.50%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.67 ms
(0.34%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.91 ms
(0.19%)
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.91 ms
(0.19%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.78 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=854133&nearbySearchLat=46.8938&nearbySearchLong=15.26357&page=4&randSeed=119&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854133&nearbySearchLat=46.8938&nearbySearchLong=15.26357&page=4&randSeed=119&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.57 ms
(0.12%)
1
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  4063277
  "facilities"
]
0.51 ms
(0.10%)
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.38 ms
(0.08%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.36 ms
(0.07%)
1
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  4063277
]
0.32 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
0.29 ms
(0.06%)
1
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  4063277
]
0.28 ms
(0.06%)
1
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  4063277
]
0.26 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.23 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.19 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.14 ms
(0.03%)
1
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  4063277
]
0.14 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.14 ms
(0.03%)
1
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  4063277
]
0.14 ms
(0.03%)
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.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.13 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  4063277
  "demiExtension"
]
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
]
0.09 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.08 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.08 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  4063277
  "demiExtension"
]
0.08 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  4063277
  "demiExtension"
]
0.08 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  4063277
  "demiExtension"
]
0.07 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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