Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
52.65 ms
(9.76%)
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:
[]
47.42 ms
(8.79%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
7.63 ms
(1.41%)
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
]
1.94 ms
(0.36%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.75 ms
(0.32%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.10 ms
(0.20%)
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?randSeed=271&nearbySearchId=1580191&nearbySearchLat=47.34805&nearbySearchLong=15.84196&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1580191&nearbySearchLat=47.34805&nearbySearchLong=15.84196&randSeed=271&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
1.03 ms
(0.19%)
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.90 ms
(0.17%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.65 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.58 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.45 ms
(0.08%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.28 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.22 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.18 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.18 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.17 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.16 ms
(0.03%)
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.16 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.16 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.02%)
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.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.07 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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