Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
47.50 ms
(10.38%)
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:
[]
40.52 ms
(8.85%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.15 ms
(0.91%)
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.95 ms
(0.64%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.88 ms
(0.41%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.83 ms
(0.18%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.71 ms
(0.16%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=325100&nearbySearchLat=47.35719&nearbySearchLong=14.12911&page=2&randSeed=270&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=325100&nearbySearchLat=47.35719&nearbySearchLong=14.12911&page=2&randSeed=270&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.66 ms
(0.14%)
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.64 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.46 ms
(0.10%)
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.45 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.33 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.31 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.28 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.26 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.21 ms
(0.05%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.18 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.16 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.12 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.12 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 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.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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