Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
44.84 ms
(9.54%)
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:
[]
29.62 ms
(6.30%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.20 ms
(0.68%)
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.75 ms
(0.37%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.74 ms
(0.37%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.60 ms
(0.34%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.87 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.64 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=854271&nearbySearchLat=47.40543&nearbySearchLong=15.27464&page=8&randSeed=924&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=854271&nearbySearchLat=47.40543&nearbySearchLong=15.27464&page=8&randSeed=924&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.63 ms
(0.13%)
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.39 ms
(0.08%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.36 ms
(0.08%)
4
SELECT id FROM sites
Parameters:
[]
0.33 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.25 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.22 ms
(0.05%)
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.19 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.19 ms
(0.04%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.18 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
  4084
  4084
]
0.16 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.13 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.12 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.08 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.07 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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