Query Metrics

98 Database Queries
26 Different statements
548.39 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
43.37 ms
(7.91%)
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:
[]
34.06 ms
(6.21%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.21 ms
(0.95%)
14
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
Parameters:
[
  11462
]
2.23 ms
(0.41%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.83 ms
(0.33%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.01 ms
(0.18%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.79 ms
(0.14%)
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.69 ms
(0.13%)
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=854036&nearbySearchLat=46.9835&nearbySearchLong=16.10909&sorting=nearbySearchAsc&page=7&randSeed=478"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854036&nearbySearchLat=46.9835&nearbySearchLong=16.10909&page=7&randSeed=478&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.61 ms
(0.11%)
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.49 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.47 ms
(0.09%)
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.45 ms
(0.08%)
4
SELECT id FROM sites
Parameters:
[]
0.33 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.32 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.21 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.19 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.19 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.17 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.16 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.16 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.02%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.12 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.12 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.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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