Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
56.16 ms
(12.31%)
1
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[]
44.47 ms
(9.75%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.38 ms
(1.18%)
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.96 ms
(0.65%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.66 ms
(0.36%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.86 ms
(0.19%)
4
SELECT id FROM sites
Parameters:
[]
0.74 ms
(0.16%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.70 ms
(0.15%)
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.62 ms
(0.14%)
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.62 ms
(0.14%)
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=46460436&nearbySearchLat=47.42131&nearbySearchLong=13.82086&page=5&randSeed=253&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=46460436&nearbySearchLat=47.42131&nearbySearchLong=13.82086&page=5&randSeed=253&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.43 ms
(0.09%)
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.28 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.27 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.26 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.26 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.22 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.22 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
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%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 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.15 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.10 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
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.07 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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