Query Metrics

98 Database Queries
26 Different statements
417.49 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
39.15 ms
(9.38%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
33.33 ms
(7.98%)
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:
[]
6.75 ms
(1.62%)
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.49 ms
(0.60%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.27 ms
(0.54%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.05 ms
(0.25%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.86 ms
(0.21%)
4
SELECT id FROM sites
Parameters:
[]
0.74 ms
(0.18%)
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.59 ms
(0.14%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.49 ms
(0.12%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1418879&nearbySearchLat=47.46354&nearbySearchLong=14.13019&page=3&randSeed=792&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1418879&nearbySearchLat=47.46354&nearbySearchLong=14.13019&page=3&randSeed=792&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.46 ms
(0.11%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.28 ms
(0.07%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.27 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.25 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.24 ms
(0.06%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.21 ms
(0.05%)
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.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
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
  115
  115
]
0.13 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.12 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 id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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