Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
51.17 ms
(11.06%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
47.50 ms
(10.27%)
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:
[]
6.71 ms
(1.45%)
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.73 ms
(0.59%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.47 ms
(0.53%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.16 ms
(0.25%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.72 ms
(0.16%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.68 ms
(0.15%)
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.60 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=857&nearbySearchId=18818072&nearbySearchLat=47.56398&nearbySearchLong=16.10002&page=239&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=18818072&nearbySearchLat=47.56398&nearbySearchLong=16.10002&page=239&randSeed=857&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.54 ms
(0.12%)
4
SELECT id FROM sites
Parameters:
[]
0.51 ms
(0.11%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.27 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.27 ms
(0.06%)
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.26 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.21 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.21 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
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%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.15 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.09 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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