Query Metrics

97 Database Queries
26 Different statements
469.02 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
41.49 ms
(8.85%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
34.44 ms
(7.34%)
1
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[]
6.12 ms
(1.31%)
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.54 ms
(0.54%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
2.35 ms
(0.50%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.10 ms
(0.23%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.89 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.77 ms
(0.16%)
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.63 ms
(0.13%)
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.62 ms
(0.13%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324202&nearbySearchLat=47.24373&nearbySearchLong=15.80048&page=5&randSeed=962&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324202&nearbySearchLat=47.24373&nearbySearchLong=15.80048&page=5&randSeed=962&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.44 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.38 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.36 ms
(0.08%)
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.22 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.22 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.21 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.20 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.18 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.12 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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