Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
59.92 ms
(12.25%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
56.92 ms
(11.64%)
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:
[]
6.36 ms
(1.30%)
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.11 ms
(0.43%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.52 ms
(0.31%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.77 ms
(0.16%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.63 ms
(0.13%)
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.60 ms
(0.12%)
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.56 ms
(0.11%)
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.53 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=1162&nearbySearchLat=47.34981&nearbySearchLong=15.46462&sorting=nearbySearchAsc&page=6&randSeed=835"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1162&nearbySearchLat=47.34981&nearbySearchLong=15.46462&page=6&randSeed=835&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.37 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.32 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
0.27 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.21 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.20 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.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.16 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.16 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.12 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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