Query Metrics

92 Database Queries
25 Different statements
383.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
42.40 ms
(11.06%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.71 ms
(1.23%)
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
]
1.69 ms
(0.44%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.91 ms
(0.24%)
7
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.69 ms
(0.18%)
4
SELECT id FROM sites
Parameters:
[]
0.54 ms
(0.14%)
2
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.54 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.51 ms
(0.13%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.49 ms
(0.13%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.45 ms
(0.12%)
2
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.42 ms
(0.11%)
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"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.41 ms
(0.11%)
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.38 ms
(0.10%)
2
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.27 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.27 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.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.12 ms
(0.03%)
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.10 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.07 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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