Query Metrics

91 Database Queries
25 Different statements
416.37 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
37.97 ms
(9.12%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.97 ms
(1.19%)
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.47 ms
(0.59%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.42 ms
(0.34%)
10
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.65 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.63 ms
(0.15%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.58 ms
(0.14%)
4
SELECT id FROM sites
Parameters:
[]
0.52 ms
(0.13%)
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.44 ms
(0.10%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.39 ms
(0.09%)
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.37 ms
(0.09%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.34 ms
(0.08%)
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?page=9&randSeed=255"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?page=9&randSeed=255"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.34 ms
(0.08%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.26 ms
(0.06%)
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.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.19 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.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.17 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.15 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 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.11 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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