Query Metrics

127 Database Queries
36 Different statements
472.87 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
46.58 ms
(9.85%)
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:
[]
28.58 ms
(6.04%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.87 ms
(0.82%)
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.08 ms
(0.44%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.37 ms
(0.29%)
3
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  74757
]
1.36 ms
(0.29%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.32 ms
(0.28%)
3
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  74757
  "facilities"
]
0.96 ms
(0.20%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.85 ms
(0.18%)
3
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  74757
]
0.65 ms
(0.14%)
3
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  74757
]
0.59 ms
(0.12%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.54 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.52 ms
(0.11%)
3
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  74757
]
0.50 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.47 ms
(0.10%)
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=324894&nearbySearchLat=47.39311&nearbySearchLong=13.69057&page=4&randSeed=515&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324894&nearbySearchLat=47.39311&nearbySearchLong=13.69057&page=4&randSeed=515&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.38 ms
(0.08%)
3
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  74757
]
0.36 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.31 ms
(0.06%)
4
SELECT id FROM sites
Parameters:
[]
0.27 ms
(0.06%)
3
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  74757
  "demiExtension"
]
0.20 ms
(0.04%)
3
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  74757
  "demiExtension"
]
0.19 ms
(0.04%)
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.18 ms
(0.04%)
3
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  74757
  "demiExtension"
]
0.17 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.17 ms
(0.04%)
3
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  74757
  "demiExtension"
]
0.16 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.15 ms
(0.03%)
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.12 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.12 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.11 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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