Query Metrics

96 Database Queries
26 Different statements
537.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
47.19 ms
(8.78%)
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:
[]
43.74 ms
(8.14%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.51 ms
(1.03%)
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.90 ms
(0.54%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.90 ms
(0.35%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.13 ms
(0.21%)
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.79 ms
(0.15%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.69 ms
(0.13%)
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.64 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?nearbySearchId=35363053&nearbySearchLat=47.44176&nearbySearchLong=16.05768&sorting=nearbySearchAsc&page=3&randSeed=767"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=35363053&nearbySearchLat=47.44176&nearbySearchLong=16.05768&page=3&randSeed=767&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.63 ms
(0.12%)
4
SELECT id FROM sites
Parameters:
[]
0.49 ms
(0.09%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 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.32 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.28 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.28 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.28 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.27 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.21 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.21 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
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.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.13 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.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.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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