Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
52.53 ms
(11.90%)
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:
[]
45.46 ms
(10.30%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.53 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.31 ms
(0.52%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.83 ms
(0.42%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.81 ms
(0.18%)
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.65 ms
(0.15%)
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.60 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.58 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=853964&nearbySearchLat=47.15361&nearbySearchLong=15.66227&sorting=nearbySearchAsc&page=3&randSeed=611"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=853964&nearbySearchLat=47.15361&nearbySearchLong=15.66227&page=3&randSeed=611&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.52 ms
(0.12%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.46 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.39 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.23 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.20 ms
(0.05%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.20 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.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.19 ms
(0.04%)
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.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.16 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.15 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.15 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.13 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.10 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.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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