Query Metrics

95 Database Queries
26 Different statements
452.05 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
52.33 ms
(11.58%)
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:
[]
39.12 ms
(8.65%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.08 ms
(0.90%)
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.17 ms
(0.48%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.61 ms
(0.36%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.73 ms
(0.16%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.66 ms
(0.15%)
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.59 ms
(0.13%)
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=324736&nearbySearchLat=47.08792&nearbySearchLong=13.98544&sorting=nearbySearchAsc&page=2&randSeed=677"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324736&nearbySearchLat=47.08792&nearbySearchLong=13.98544&page=2&randSeed=677&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.48 ms
(0.11%)
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.42 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.38 ms
(0.08%)
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.32 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.28 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.26 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.19 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.19 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.16 ms
(0.04%)
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.16 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.14 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
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.13 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 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.09 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.07 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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