Query Metrics

96 Database Queries
27 Different statements
427.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
53.58 ms
(12.53%)
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.43 ms
(6.65%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.70 ms
(1.33%)
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.13 ms
(0.50%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.54 ms
(0.36%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.71 ms
(0.17%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.61 ms
(0.14%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.56 ms
(0.13%)
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%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.45 ms
(0.11%)
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=854312&nearbySearchLat=47.01954&nearbySearchLong=14.95798&sorting=nearbySearchAsc&page=3&randSeed=470"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854312&nearbySearchLat=47.01954&nearbySearchLong=14.95798&page=3&randSeed=470&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.34 ms
(0.08%)
4
SELECT id FROM sites
Parameters:
[]
0.27 ms
(0.06%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.22 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.21 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
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%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
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.12 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.12 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.11 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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