Query Metrics

102 Database Queries
27 Different statements
446.82 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
55.70 ms
(12.47%)
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:
[]
29.68 ms
(6.64%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.72 ms
(1.28%)
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.75 ms
(0.62%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.49 ms
(0.56%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.50 ms
(0.34%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.94 ms
(0.21%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
0.94 ms
(0.21%)
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.80 ms
(0.18%)
4
SELECT id FROM sites
Parameters:
[]
0.64 ms
(0.14%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=4643094&nearbySearchLat=46.814&nearbySearchLong=15.4024&sorting=nearbySearchAsc&page=2&randSeed=972"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=4643094&nearbySearchLat=46.814&nearbySearchLong=15.4024&page=2&randSeed=972&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.51 ms
(0.11%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.44 ms
(0.10%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.40 ms
(0.09%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.35 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.34 ms
(0.08%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.30 ms
(0.07%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.26 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.25 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.23 ms
(0.05%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.20 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.17 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.16 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 ms
(0.03%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]

demi_vacancies connection

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