Query Metrics

127 Database Queries
39 Different statements
462.62 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
55.28 ms
(11.95%)
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:
[]
44.93 ms
(9.71%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
4.57 ms
(0.99%)
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.31 ms
(0.50%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
2.23 ms
(0.48%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.26 ms
(0.27%)
6
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  4084
]
0.92 ms
(0.20%)
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.80 ms
(0.17%)
1
SELECT * FROM object_localized_data_AlpsteinTour WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  325052
]
0.68 ms
(0.15%)
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=325052&nearbySearchLat=47.0762&nearbySearchLong=15.36188&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Plan-your-holiday/Search-book-accommodation?nearbySearchId=325052&nearbySearchLat=47.0762&nearbySearchLong=15.36188&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.64 ms
(0.14%)
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.58 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/%"
  "/en/Plan-your-holiday/Search-book-accommodation"
]
0.50 ms
(0.11%)
2
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  42682891
]
0.46 ms
(0.10%)
1
SELECT * FROM object_store_AlpsteinTour WHERE oo_id = ?
Parameters:
[
  325052
]
0.46 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.42 ms
(0.09%)
2
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  42682891
]
0.41 ms
(0.09%)
3
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  325052
]
0.41 ms
(0.09%)
3
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  325052
]
0.39 ms
(0.08%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.36 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Plan-your-holiday/Search-book-accommodation"
]
0.33 ms
(0.07%)
2
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  42682891
  "facilities"
]
0.32 ms
(0.07%)
2
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.29 ms
(0.06%)
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.25 ms
(0.05%)
1
SELECT * FROM object_relations_AlpsteinTour WHERE src_id = ?
Parameters:
[
  325052
]
0.25 ms
(0.05%)
2
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  42682891
]
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
  4084
  4084
]
0.21 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  4084
]
0.21 ms
(0.04%)
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.20 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.19 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.17 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.16 ms
(0.03%)
2
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  42682891
  "demiExtension"
]
0.15 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
2
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  42682891
  "demiExtension"
]
0.12 ms
(0.03%)
2
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  42682891
  "demiExtension"
]
0.11 ms
(0.02%)
2
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  42682891
  "demiExtension"
]
0.11 ms
(0.02%)
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.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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