Query Metrics

107 Database Queries
36 Different statements
449.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
48.32 ms
(10.75%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
33.34 ms
(7.42%)
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:
[]
5.59 ms
(1.24%)
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.38 ms
(0.53%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.43 ms
(0.32%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.79 ms
(0.18%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.70 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.56 ms
(0.12%)
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?randSeed=760&showMap=1&zoom=7&bounds[south]=44.298816656182645&bounds[west]=13.56427484375001&bounds[north]=49.96405468816607&bounds[east]=17.12384515625001&nearbySearchId=1430528&nearbySearchLat=47.207&nearbySearchLong=15.34406&page=224&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?bounds[south]=44.298816656182645&bounds[west]=13.56427484375001&bounds[north]=49.96405468816607&bounds[east]=17.12384515625001&nearbySearchId=1430528&nearbySearchLat=47.207&nearbySearchLong=15.34406&page=224&randSeed=760&showMap=1&sorting=nearbySearchAsc&zoom=7"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.55 ms
(0.12%)
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.47 ms
(0.10%)
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.34 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.26 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.24 ms
(0.05%)
1
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  45503
]
0.21 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.20 ms
(0.04%)
1
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  45503
]
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%)
1
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  45503
]
0.17 ms
(0.04%)
1
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  45503
  "facilities"
]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.17 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.16 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.14 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
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:
[
  45503
]
0.13 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
1
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  45503
]
0.12 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  45503
  "demiExtension"
]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.08 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  45503
  "demiExtension"
]
0.08 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  45503
  "demiExtension"
]
0.07 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  45503
  "demiExtension"
]

demi_vacancies connection

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