Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
53.94 ms
(11.98%)
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:
[]
47.87 ms
(10.63%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.69 ms
(1.26%)
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.15 ms
(0.48%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.91 ms
(0.42%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.65 ms
(0.14%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854147&nearbySearchLat=47.54524&nearbySearchLong=15.55998&page=9&randSeed=47&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854147&nearbySearchLat=47.54524&nearbySearchLong=15.55998&page=9&randSeed=47&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.64 ms
(0.14%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.62 ms
(0.14%)
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.61 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/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.60 ms
(0.13%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.37 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.34 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
0.33 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.23 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.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
  115
  115
]
0.20 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.19 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.17 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.16 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.11 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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