Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
50.90 ms
(10.28%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
34.97 ms
(7.06%)
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:
[]
4.94 ms
(1.00%)
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.82 ms
(0.57%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.83 ms
(0.37%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.03 ms
(0.21%)
4
SELECT id FROM sites
Parameters:
[]
0.92 ms
(0.19%)
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.89 ms
(0.18%)
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.83 ms
(0.17%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.71 ms
(0.14%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854053&nearbySearchLat=46.68084&nearbySearchLong=15.07537&page=3&randSeed=746&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854053&nearbySearchLat=46.68084&nearbySearchLong=15.07537&page=3&randSeed=746&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.47 ms
(0.09%)
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.30 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.30 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.27 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.25 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.20 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.17 ms
(0.04%)
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.14 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.12 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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