Query Metrics

131 Database Queries
36 Different statements
423.59 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
39.36 ms
(9.29%)
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:
[]
30.48 ms
(7.20%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.76 ms
(0.89%)
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.12 ms
(0.50%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.20 ms
(0.28%)
3
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  7452995
]
1.02 ms
(0.24%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.87 ms
(0.21%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.68 ms
(0.16%)
3
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  7452995
]
0.62 ms
(0.15%)
3
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  7452995
  "facilities"
]
0.59 ms
(0.14%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
0.58 ms
(0.14%)
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/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.56 ms
(0.13%)
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.44 ms
(0.10%)
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" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=324409&nearbySearchLat=47.54951&nearbySearchLong=13.97046&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=324409&nearbySearchLat=47.54951&nearbySearchLong=13.97046&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.42 ms
(0.10%)
3
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:
[
  7452995
]
0.41 ms
(0.10%)
3
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  7452995
]
0.36 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.32 ms
(0.08%)
4
SELECT id FROM sites
Parameters:
[]
0.32 ms
(0.07%)
3
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  7452995
]
0.31 ms
(0.07%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.28 ms
(0.07%)
3
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  7452995
  "demiExtension"
]
0.23 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.22 ms
(0.05%)
3
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  7452995
  "demiExtension"
]
0.21 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.21 ms
(0.05%)
3
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  7452995
  "demiExtension"
]
0.20 ms
(0.05%)
3
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  7452995
  "demiExtension"
]
0.18 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.13 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
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.12 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.10 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.09 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]

demi_vacancies connection

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