Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
45.12 ms
(8.43%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
39.11 ms
(7.31%)
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:
[]
7.32 ms
(1.37%)
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.71 ms
(0.51%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
2.05 ms
(0.38%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.25 ms
(0.23%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.79 ms
(0.15%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
0.75 ms
(0.14%)
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.65 ms
(0.12%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.63 ms
(0.12%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=5947654&nearbySearchLat=47.16888&nearbySearchLong=15.41695&sorting=nearbySearchAsc&page=1&randSeed=156"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=5947654&nearbySearchLat=47.16888&nearbySearchLong=15.41695&page=1&randSeed=156&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.58 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.44 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.32 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.31 ms
(0.06%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.25 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.24 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.24 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.23 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.22 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.19 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.16 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.13 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.12 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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