Query Metrics

98 Database Queries
26 Different statements
485.71 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
59.68 ms
(12.29%)
1
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[]
42.18 ms
(8.68%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.72 ms
(1.38%)
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
]
3.09 ms
(0.64%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.31 ms
(0.48%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.18 ms
(0.24%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.92 ms
(0.19%)
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.83 ms
(0.17%)
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.80 ms
(0.17%)
4
SELECT id FROM sites
Parameters:
[]
0.73 ms
(0.15%)
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=1208&nearbySearchLat=47.50213&nearbySearchLong=15.63392&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1208&nearbySearchLat=47.50213&nearbySearchLong=15.63392&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.53 ms
(0.11%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.36 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.31 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.22 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.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.20 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.20 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.18 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.17 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.03%)
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 id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.13 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules 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.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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