Query Metrics

102 Database Queries
26 Different statements
760.82 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
66.09 ms
(8.69%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
62.49 ms
(8.21%)
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:
[]
12.52 ms
(1.65%)
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
]
4.61 ms
(0.61%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
3.75 ms
(0.49%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
3.70 ms
(0.49%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
1.77 ms
(0.23%)
4
SELECT id FROM sites
Parameters:
[]
1.59 ms
(0.21%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
1.39 ms
(0.18%)
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" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=854230&nearbySearchLat=47.44446&nearbySearchLong=13.90184&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=854230&nearbySearchLat=47.44446&nearbySearchLong=13.90184&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
1.28 ms
(0.17%)
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.89 ms
(0.12%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.75 ms
(0.10%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.71 ms
(0.09%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.68 ms
(0.09%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.66 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/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.48 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.40 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.35 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
  4084
  4084
]
0.31 ms
(0.04%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.22 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.21 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.19 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.12 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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