Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
49.07 ms
(11.41%)
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:
[]
29.81 ms
(6.93%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.84 ms
(0.89%)
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.01 ms
(0.47%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.23 ms
(0.29%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.58 ms
(0.13%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.56 ms
(0.13%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.49 ms
(0.11%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.48 ms
(0.11%)
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.42 ms
(0.10%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=853452&nearbySearchLat=47.22258&nearbySearchLong=15.42002&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=853452&nearbySearchLat=47.22258&nearbySearchLong=15.42002&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.35 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.32 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.19 ms
(0.04%)
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.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 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.15 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.12 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.11 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT * FROM translations_messages 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.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.09 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]

demi_vacancies connection

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