Query Metrics

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

Grouped Statements

Show all queries

default connection

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