Query Metrics

97 Database Queries
26 Different statements
433.84 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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