Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
46.59 ms
(9.87%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
40.45 ms
(8.57%)
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:
[]
4.80 ms
(1.02%)
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.14 ms
(0.45%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.87 ms
(0.40%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.77 ms
(0.16%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.68 ms
(0.14%)
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=324726&nearbySearchLat=47.2438&nearbySearchLong=15.80037&sorting=nearbySearchAsc&page=242&randSeed=251"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324726&nearbySearchLat=47.2438&nearbySearchLong=15.80037&page=242&randSeed=251&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.67 ms
(0.14%)
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.66 ms
(0.14%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.63 ms
(0.13%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.51 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.38 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.25 ms
(0.05%)
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.23 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.22 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.22 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.21 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.16 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.16 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.16 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 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 = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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