Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
56.70 ms
(11.88%)
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:
[]
50.96 ms
(10.68%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
7.26 ms
(1.52%)
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.99 ms
(0.63%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.09 ms
(0.44%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.12 ms
(0.23%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.95 ms
(0.20%)
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.77 ms
(0.16%)
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.75 ms
(0.16%)
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=1430469&nearbySearchLat=47.56827&nearbySearchLong=15.62011&sorting=nearbySearchAsc&page=6&randSeed=983"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1430469&nearbySearchLat=47.56827&nearbySearchLong=15.62011&page=6&randSeed=983&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.68 ms
(0.14%)
4
SELECT id FROM sites
Parameters:
[]
0.50 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.33 ms
(0.07%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.32 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.28 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.28 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.26 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.23 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.22 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.22 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.19 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.18 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.13 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.11 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]

demi_vacancies connection

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