Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
37.86 ms
(8.87%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
31.37 ms
(7.35%)
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:
[]
7.55 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.72 ms
(0.64%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.55 ms
(0.60%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.86 ms
(0.20%)
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.77 ms
(0.18%)
4
SELECT id FROM sites
Parameters:
[]
0.66 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.66 ms
(0.15%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.60 ms
(0.14%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.47 ms
(0.11%)
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=46460770&nearbySearchLat=47.41589&nearbySearchLong=13.67537&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=46460770&nearbySearchLat=47.41589&nearbySearchLong=13.67537&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.40 ms
(0.09%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 ms
(0.08%)
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.29 ms
(0.07%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.27 ms
(0.06%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.24 ms
(0.06%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.22 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.22 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.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%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.16 ms
(0.04%)
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.13 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.12 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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