Query Metrics

99 Database Queries
26 Different statements
462.35 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
58.42 ms
(12.64%)
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:
[]
46.25 ms
(10.00%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.58 ms
(0.99%)
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.48 ms
(0.54%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.41 ms
(0.52%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.21 ms
(0.26%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.94 ms
(0.20%)
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.86 ms
(0.19%)
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.62 ms
(0.13%)
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=3762699&nearbySearchLat=47.40142&nearbySearchLong=15.88446&page=4&randSeed=372&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=3762699&nearbySearchLat=47.40142&nearbySearchLong=15.88446&page=4&randSeed=372&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.59 ms
(0.13%)
4
SELECT id FROM sites
Parameters:
[]
0.53 ms
(0.11%)
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.34 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.31 ms
(0.07%)
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.30 ms
(0.07%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.27 ms
(0.06%)
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.26 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.25 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.24 ms
(0.05%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.24 ms
(0.05%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.23 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.21 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
  4084
  4084
]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
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:
[]

demi_vacancies connection

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