Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
54.73 ms
(12.92%)
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:
[]
28.65 ms
(6.76%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
2.91 ms
(0.69%)
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.23 ms
(0.53%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.18 ms
(0.28%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.86 ms
(0.20%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.69 ms
(0.16%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.62 ms
(0.15%)
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.53 ms
(0.12%)
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.52 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=1430859&nearbySearchLat=47.4077&nearbySearchLong=13.63811&sorting=nearbySearchAsc&page=2&randSeed=890"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1430859&nearbySearchLat=47.4077&nearbySearchLong=13.63811&page=2&randSeed=890&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.37 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 ms
(0.08%)
4
SELECT id FROM sites
Parameters:
[]
0.26 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.20 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.19 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.18 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.16 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.16 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.16 ms
(0.04%)
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 id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.12 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
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:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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