Query Metrics

88 Database Queries
25 Different statements
439.08 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
33.47 ms
(7.62%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.37 ms
(1.45%)
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
]
1.78 ms
(0.41%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.94 ms
(0.21%)
7
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.83 ms
(0.19%)
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.83 ms
(0.19%)
4
SELECT id FROM sites
Parameters:
[]
0.68 ms
(0.16%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.54 ms
(0.12%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?page=186&randSeed=162"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?page=186&randSeed=162"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.53 ms
(0.12%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.45 ms
(0.10%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.29 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.27 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.27 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.24 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.19 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.17 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.16 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.12 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.12 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.11 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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