Query Metrics

112 Database Queries
36 Different statements
489.39 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
58.66 ms
(11.99%)
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:
[]
37.34 ms
(7.63%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
7.15 ms
(1.46%)
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.68 ms
(0.55%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.54 ms
(0.52%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
2.17 ms
(0.44%)
1
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  7599407
  "facilities"
]
1.44 ms
(0.29%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
1.11 ms
(0.23%)
1
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  7599407
]
0.88 ms
(0.18%)
4
SELECT id FROM sites
Parameters:
[]
0.85 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.84 ms
(0.17%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Search-book-accommodation"
  "path" => "/steiermark.com/en/Plan-your-holiday/"
]
0.61 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" => "/en/Plan-your-holiday/Search-book-accommodation"
  "sourcePathQuery" => "/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=18267231&nearbySearchLat=47.4193&nearbySearchLong=13.65354&sorting=nearbySearchAsc&page=2&randSeed=218"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=18267231&nearbySearchLat=47.4193&nearbySearchLong=13.65354&page=2&randSeed=218&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.60 ms
(0.12%)
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/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.54 ms
(0.11%)
2
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  18267231
]
0.47 ms
(0.10%)
1
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  7599407
]
0.40 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.37 ms
(0.08%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.32 ms
(0.06%)
1
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  7599407
]
0.31 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.26 ms
(0.05%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.25 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.23 ms
(0.05%)
1
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  7599407
  "demiExtension"
]
0.21 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.21 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
  4084
  4084
]
0.17 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.17 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.03%)
1
SELECT 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:
[
  7599407
]
0.13 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/en/Plan-your-holiday/Search-book-accommodation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.13 ms
(0.03%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.12 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:
[
  7599407
  "demiExtension"
]
0.07 ms
(0.01%)
1
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  7599407
  "demiExtension"
]
0.07 ms
(0.01%)
1
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  7599407
  "demiExtension"
]

demi_vacancies connection

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