Query Metrics

96 Database Queries
26 Different statements
427.31 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
54.15 ms
(12.67%)
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:
[]
45.12 ms
(10.56%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.93 ms
(1.15%)
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.91 ms
(0.68%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
2.61 ms
(0.61%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.95 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/"
]
0.94 ms
(0.22%)
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.78 ms
(0.18%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?randSeed=727&nearbySearchId=1580190&nearbySearchLat=46.75746&nearbySearchLong=15.24996&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1580190&nearbySearchLat=46.75746&nearbySearchLong=15.24996&randSeed=727&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.78 ms
(0.18%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.71 ms
(0.17%)
4
SELECT id FROM sites
Parameters:
[]
0.67 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.44 ms
(0.10%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 ms
(0.08%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.29 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.28 ms
(0.06%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.27 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.22 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
  115
  115
]
0.20 ms
(0.05%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.19 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.18 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.15 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.14 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.11 ms
(0.03%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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