Query Metrics

99 Database Queries
27 Different statements
474.55 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
57.67 ms
(12.15%)
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:
[]
49.52 ms
(10.43%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.13 ms
(1.29%)
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.19 ms
(0.46%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
2.16 ms
(0.46%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.26 ms
(0.27%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.80 ms
(0.17%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
0.63 ms
(0.13%)
4
SELECT id FROM sites
Parameters:
[]
0.61 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/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.58 ms
(0.12%)
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.46 ms
(0.10%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=52062846&nearbySearchLat=47.22606&nearbySearchLong=15.23443&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=52062846&nearbySearchLat=47.22606&nearbySearchLong=15.23443&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.37 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.31 ms
(0.07%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.30 ms
(0.06%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.29 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.27 ms
(0.06%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.26 ms
(0.06%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.25 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.23 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.17 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.15 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.12 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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