Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
32.80 ms
(8.05%)
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.06 ms
(6.89%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
2.84 ms
(0.70%)
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.42 ms
(0.35%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.38 ms
(0.34%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.73 ms
(0.18%)
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.60 ms
(0.15%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=853533&nearbySearchLat=47.67557&nearbySearchLong=15.49194&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=853533&nearbySearchLat=47.67557&nearbySearchLong=15.49194&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.47 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.44 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.38 ms
(0.09%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.37 ms
(0.09%)
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.24 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.24 ms
(0.06%)
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.20 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.17 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.14 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.13 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.11 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.11 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.09 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
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.06 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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