Query Metrics

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

Grouped Statements

Show all queries

default connection

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