Query Metrics

95 Database Queries
26 Different statements
406.73 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

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