Query Metrics

98 Database Queries
26 Different statements
461.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
54.99 ms
(11.92%)
1
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[]
42.07 ms
(9.12%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
7.85 ms
(1.70%)
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.05 ms
(0.44%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.64 ms
(0.36%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.98 ms
(0.21%)
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.95 ms
(0.21%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.62 ms
(0.13%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?randSeed=788&nearbySearchId=42267906&nearbySearchLat=47.5453&nearbySearchLong=14.03938&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=42267906&nearbySearchLat=47.5453&nearbySearchLong=14.03938&randSeed=788&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.47 ms
(0.10%)
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.46 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.35 ms
(0.08%)
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.26 ms
(0.06%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.26 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.23 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.21 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.20 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.17 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.16 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.15 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.09 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.07 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.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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