Query Metrics

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

Grouped Statements

Show all queries

default connection

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