Query Metrics

92 Database Queries
26 Different statements
499.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
48.72 ms
(9.75%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
36.16 ms
(7.23%)
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:
[]
5.97 ms
(1.19%)
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
]
1.48 ms
(0.30%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.37 ms
(0.27%)
10
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.68 ms
(0.14%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.61 ms
(0.12%)
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=1580442&nearbySearchLat=47.41362&nearbySearchLong=15.27803&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1580442&nearbySearchLat=47.41362&nearbySearchLong=15.27803&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.54 ms
(0.11%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.48 ms
(0.10%)
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.37 ms
(0.07%)
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.31 ms
(0.06%)
4
SELECT id FROM sites
Parameters:
[]
0.25 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.23 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.19 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.18 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.16 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.16 ms
(0.03%)
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.15 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.12 ms
(0.02%)
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 sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.07 ms
(0.01%)
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.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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