Query Metrics

102 Database Queries
26 Different statements
452.94 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
55.74 ms
(12.31%)
1
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[]
28.04 ms
(6.19%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.25 ms
(0.94%)
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.57 ms
(0.57%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.34 ms
(0.52%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.62 ms
(0.36%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.74 ms
(0.16%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
0.69 ms
(0.15%)
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.66 ms
(0.15%)
4
SELECT id FROM sites
Parameters:
[]
0.63 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" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=1580230&nearbySearchLat=47.30437&nearbySearchLong=15.86455&page=4&randSeed=630&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=1580230&nearbySearchLat=47.30437&nearbySearchLong=15.86455&page=4&randSeed=630&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.61 ms
(0.13%)
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/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.38 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.32 ms
(0.07%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.32 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.24 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  4084
  4084
]
0.22 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.20 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.18 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.17 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.14 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
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.11 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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