Query Metrics

128 Database Queries
36 Different statements
447.57 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
44.95 ms
(10.04%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
35.90 ms
(8.02%)
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.10 ms
(1.14%)
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
]
1.96 ms
(0.44%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.88 ms
(0.42%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.48 ms
(0.33%)
3
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  1944971
]
1.20 ms
(0.27%)
3
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  1944971
  "facilities"
]
0.83 ms
(0.19%)
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.73 ms
(0.16%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.68 ms
(0.15%)
3
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  1944971
]
0.64 ms
(0.14%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.54 ms
(0.12%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?randSeed=259&nearbySearchId=2537549&nearbySearchLat=47.30253&nearbySearchLong=15.83208&page=245&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=2537549&nearbySearchLat=47.30253&nearbySearchLong=15.83208&page=245&randSeed=259&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.46 ms
(0.10%)
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.42 ms
(0.09%)
3
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:
[
  1944971
]
0.40 ms
(0.09%)
3
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  1944971
]
0.38 ms
(0.08%)
3
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  1944971
]
0.33 ms
(0.07%)
4
SELECT id FROM sites
Parameters:
[]
0.29 ms
(0.07%)
3
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  1944971
  "demiExtension"
]
0.29 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.27 ms
(0.06%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.27 ms
(0.06%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.24 ms
(0.05%)
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.22 ms
(0.05%)
3
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  1944971
  "demiExtension"
]
0.21 ms
(0.05%)
3
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  1944971
  "demiExtension"
]
0.20 ms
(0.04%)
3
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  1944971
  "demiExtension"
]
0.18 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.16 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.15 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.14 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.12 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.11 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.10 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
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.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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