Query Metrics

97 Database Queries
26 Different statements
463.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
47.90 ms
(10.34%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
32.58 ms
(7.03%)
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.38 ms
(1.16%)
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.77 ms
(0.60%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.42 ms
(0.31%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.74 ms
(0.16%)
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.70 ms
(0.15%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.67 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.54 ms
(0.12%)
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.48 ms
(0.10%)
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=2607942&nearbySearchLat=47.27381&nearbySearchLong=14.78594&page=7&randSeed=94&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=2607942&nearbySearchLat=47.27381&nearbySearchLong=14.78594&page=7&randSeed=94&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.46 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.41 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.37 ms
(0.08%)
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.24 ms
(0.05%)
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.21 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.19 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 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 object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.13 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.02%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.11 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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