Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
32.55 ms
(7.37%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
31.70 ms
(7.17%)
1
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[]
6.14 ms
(1.39%)
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.42 ms
(0.55%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.35 ms
(0.53%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.99 ms
(0.22%)
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.76 ms
(0.17%)
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.63 ms
(0.14%)
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%)
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=1087&nearbySearchLat=47.08757&nearbySearchLong=14.42261&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1087&nearbySearchLat=47.08757&nearbySearchLong=14.42261&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.59 ms
(0.13%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.49 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.38 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.32 ms
(0.07%)
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 * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.21 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.19 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.19 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.16 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
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.16 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.16 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.13 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.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.10 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]

demi_vacancies connection

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