Query Metrics

108 Database Queries
36 Different statements
462.63 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
51.50 ms
(11.13%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
39.67 ms
(8.57%)
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:
[]
5.87 ms
(1.27%)
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.14 ms
(0.46%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.68 ms
(0.36%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.92 ms
(0.20%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.74 ms
(0.16%)
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.73 ms
(0.16%)
1
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  161142
  "facilities"
]
0.60 ms
(0.13%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1430747&nearbySearchLat=47.42017&nearbySearchLong=13.82044&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1430747&nearbySearchLat=47.42017&nearbySearchLong=13.82044&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.57 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.56 ms
(0.12%)
1
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  161142
]
0.55 ms
(0.12%)
4
SELECT id FROM sites
Parameters:
[]
0.44 ms
(0.10%)
1
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  161142
]
0.35 ms
(0.08%)
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.25 ms
(0.05%)
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.24 ms
(0.05%)
1
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  161142
]
0.23 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.23 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.22 ms
(0.05%)
1
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  161142
]
0.20 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.20 ms
(0.04%)
1
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  161142
  "demiExtension"
]
0.16 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.15 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.14 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.14 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 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.12 ms
(0.03%)
1
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  161142
]
0.11 ms
(0.02%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
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.08 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.08 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  161142
  "demiExtension"
]
0.07 ms
(0.01%)
1
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  161142
  "demiExtension"
]
0.06 ms
(0.01%)
1
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  161142
  "demiExtension"
]
0.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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