Query Metrics

95 Database Queries
26 Different statements
557.11 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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