Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
56.53 ms
(12.85%)
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:
[]
47.02 ms
(10.69%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
3.68 ms
(0.84%)
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.02 ms
(0.46%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.69 ms
(0.38%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.81 ms
(0.18%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.56 ms
(0.13%)
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.52 ms
(0.12%)
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.48 ms
(0.11%)
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.41 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.31 ms
(0.07%)
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=854435&nearbySearchLat=47.07247&nearbySearchLong=14.42621&page=2&randSeed=812&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854435&nearbySearchLat=47.07247&nearbySearchLong=14.42621&page=2&randSeed=812&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.29 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.26 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.21 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.20 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.18 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.16 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.15 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
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.13 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.10 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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