Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
55.56 ms
(12.24%)
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:
[]
32.10 ms
(7.07%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.76 ms
(1.05%)
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.55 ms
(0.56%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.64 ms
(0.36%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.79 ms
(0.17%)
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.76 ms
(0.17%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.76 ms
(0.17%)
4
SELECT id FROM sites
Parameters:
[]
0.73 ms
(0.16%)
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.52 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=1163&nearbySearchLat=47.35047&nearbySearchLong=15.45993&sorting=nearbySearchAsc&page=2&randSeed=647"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1163&nearbySearchLat=47.35047&nearbySearchLong=15.45993&page=2&randSeed=647&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.35 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.30 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.29 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.25 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.25 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.24 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.21 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.20 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
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 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.11 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.07 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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