Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
54.17 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:
[]
43.47 ms
(9.80%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.49 ms
(1.01%)
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.50 ms
(0.56%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.96 ms
(0.44%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.72 ms
(0.16%)
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.70 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.60 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%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.57 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?nearbySearchId=16392238&nearbySearchLat=47.41707&nearbySearchLong=16.0199&sorting=nearbySearchAsc&page=11&randSeed=426"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=16392238&nearbySearchLat=47.41707&nearbySearchLong=16.0199&page=11&randSeed=426&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.37 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.34 ms
(0.08%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.33 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
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.24 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.19 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.19 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.16 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.14 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.12 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.11 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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