Query Metrics

91 Database Queries
25 Different statements
426.39 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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