Query Metrics

104 Database Queries
32 Different statements
492.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
56.75 ms
(11.51%)
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:
[]
48.87 ms
(9.92%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
7.17 ms
(1.45%)
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
]
3.29 ms
(0.67%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.27 ms
(0.46%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.08 ms
(0.22%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
1.06 ms
(0.21%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.97 ms
(0.20%)
4
SELECT id FROM sites
Parameters:
[]
0.84 ms
(0.17%)
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.79 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.69 ms
(0.14%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1580444&nearbySearchLat=47.37167&nearbySearchLong=14.46126&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1580444&nearbySearchLat=47.37167&nearbySearchLong=14.46126&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.47 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.41 ms
(0.08%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.41 ms
(0.08%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.40 ms
(0.08%)
1
SELECT * FROM object_relations_AlpsteinTour WHERE src_id = ?
Parameters:
[
  1580444
]
0.40 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.37 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.32 ms
(0.07%)
1
SELECT * FROM object_localized_data_AlpsteinTour WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk','es')
Parameters:
[
  1580444
]
0.31 ms
(0.06%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.28 ms
(0.06%)
1
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  1580444
]
0.27 ms
(0.05%)
1
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  1580444
]
0.25 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.20 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.19 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.18 ms
(0.04%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.17 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.15 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.15 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.15 ms
(0.03%)
1
SELECT * FROM object_store_AlpsteinTour WHERE oo_id = ?
Parameters:
[
  1580444
]
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
]

demi_vacancies connection

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