Query Metrics

168 Database Queries
36 Different statements
434.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
45.08 ms
(10.38%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
30.70 ms
(7.07%)
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:
[]
5.68 ms
(1.31%)
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.40 ms
(0.55%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
2.00 ms
(0.46%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.32 ms
(0.30%)
7
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  221173
]
1.25 ms
(0.29%)
7
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  221173
  "facilities"
]
1.22 ms
(0.28%)
7
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  221173
]
1.11 ms
(0.25%)
7
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  221173
]
0.92 ms
(0.21%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.85 ms
(0.20%)
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.73 ms
(0.17%)
7
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  221173
]
0.73 ms
(0.17%)
7
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  221173
]
0.66 ms
(0.15%)
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=840&showMap=1&zoom=8&bounds[south]=45.97660038964017&bounds[west]=12.736327421874995&bounds[north]=48.798416445466465&bounds[east]=14.516112578124995&nearbySearchId=1430804&nearbySearchLat=47.4064&nearbySearchLong=13.62622&page=9&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?bounds[south]=45.97660038964017&bounds[west]=12.736327421874995&bounds[north]=48.798416445466465&bounds[east]=14.516112578124995&nearbySearchId=1430804&nearbySearchLat=47.4064&nearbySearchLong=13.62622&page=9&randSeed=840&showMap=1&sorting=nearbySearchAsc&zoom=8"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.64 ms
(0.15%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.48 ms
(0.11%)
7
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  221173
  "demiExtension"
]
0.44 ms
(0.10%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.38 ms
(0.09%)
7
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  221173
  "demiExtension"
]
0.36 ms
(0.08%)
7
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  221173
  "demiExtension"
]
0.35 ms
(0.08%)
7
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  221173
  "demiExtension"
]
0.32 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.31 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
0.31 ms
(0.07%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.30 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.26 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.19 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.15 ms
(0.03%)
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.13 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.11 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.11 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.10 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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