Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
49.27 ms
(11.89%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
33.35 ms
(8.05%)
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.92 ms
(1.19%)
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
]
1.46 ms
(0.35%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.46 ms
(0.35%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.91 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.48 ms
(0.12%)
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.46 ms
(0.11%)
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=1430400&nearbySearchLat=47.38426&nearbySearchLong=14.11693&page=242&randSeed=987&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1430400&nearbySearchLat=47.38426&nearbySearchLong=14.11693&page=242&randSeed=987&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.39 ms
(0.09%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.35 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.35 ms
(0.08%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.25 ms
(0.06%)
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.24 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.21 ms
(0.05%)
4
SELECT id FROM sites
Parameters:
[]
0.20 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.15 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.15 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.12 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.12 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.11 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.10 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.07 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.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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