Query Metrics

95 Database Queries
26 Different statements
435.68 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
34.28 ms
(7.87%)
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:
[]
30.10 ms
(6.91%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.70 ms
(0.85%)
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.52 ms
(0.58%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.31 ms
(0.53%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.88 ms
(0.20%)
4
SELECT id FROM sites
Parameters:
[]
0.67 ms
(0.15%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.59 ms
(0.13%)
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.52 ms
(0.12%)
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.49 ms
(0.11%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.44 ms
(0.10%)
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=324173&nearbySearchLat=47.54656&nearbySearchLong=15.56048&sorting=nearbySearchAsc&page=1&randSeed=848"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324173&nearbySearchLat=47.54656&nearbySearchLong=15.56048&page=1&randSeed=848&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.36 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.29 ms
(0.07%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.28 ms
(0.07%)
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.25 ms
(0.06%)
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,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 object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.16 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.14 ms
(0.03%)
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.13 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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