Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
56.24 ms
(12.22%)
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:
[]
44.02 ms
(9.57%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.70 ms
(1.24%)
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.37 ms
(0.52%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.96 ms
(0.43%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.87 ms
(0.19%)
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.75 ms
(0.16%)
4
SELECT id FROM sites
Parameters:
[]
0.72 ms
(0.16%)
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=46460477&nearbySearchLat=47.41136&nearbySearchLong=13.77875&page=9&randSeed=730&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=46460477&nearbySearchLat=47.41136&nearbySearchLong=13.77875&page=9&randSeed=730&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.69 ms
(0.15%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.61 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.59 ms
(0.13%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.37 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.27 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.26 ms
(0.06%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.24 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.21 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.04%)
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.17 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.16 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.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.03%)
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.13 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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