Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
45.56 ms
(10.04%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
33.34 ms
(7.35%)
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:
[]
5.04 ms
(1.11%)
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.78 ms
(0.61%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.27 ms
(0.50%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.82 ms
(0.18%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.72 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.65 ms
(0.14%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.60 ms
(0.13%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324359&nearbySearchLat=47.40431&nearbySearchLong=13.65178&sorting=nearbySearchAsc&page=241&randSeed=687"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324359&nearbySearchLat=47.40431&nearbySearchLong=13.65178&page=241&randSeed=687&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.50 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.48 ms
(0.11%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.35 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.34 ms
(0.07%)
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.31 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.23 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.19 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.15 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.12 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.12 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
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:
[]

demi_vacancies connection

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