Query Metrics

105 Database Queries
36 Different statements
467.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
56.17 ms
(12.01%)
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:
[]
38.23 ms
(8.17%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.79 ms
(1.45%)
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.12 ms
(0.45%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.91 ms
(0.41%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.78 ms
(0.17%)
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.74 ms
(0.16%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.66 ms
(0.14%)
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.60 ms
(0.13%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.56 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?nearbySearchId=854338&nearbySearchLat=47.57465&nearbySearchLong=14.85134&sorting=nearbySearchAsc&page=243&randSeed=107"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=854338&nearbySearchLat=47.57465&nearbySearchLong=14.85134&page=243&randSeed=107&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.53 ms
(0.11%)
4
SELECT id FROM sites
Parameters:
[]
0.42 ms
(0.09%)
1
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  2458323
]
0.37 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 ms
(0.07%)
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.26 ms
(0.06%)
1
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  2458323
]
0.25 ms
(0.05%)
1
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  2458323
]
0.22 ms
(0.05%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.22 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.22 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.21 ms
(0.04%)
1
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  2458323
  "facilities"
]
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.18 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.18 ms
(0.04%)
1
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  2458323
]
0.18 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.16 ms
(0.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:
[
  2458323
]
0.16 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.16 ms
(0.03%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.13 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  2458323
  "demiExtension"
]
0.11 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.08 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  2458323
  "demiExtension"
]
0.07 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  2458323
  "demiExtension"
]
0.07 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  2458323
  "demiExtension"
]

demi_vacancies connection

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