Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
56.65 ms
(12.73%)
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:
[]
46.43 ms
(10.43%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.75 ms
(1.52%)
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.06 ms
(0.46%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.61 ms
(0.36%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.94 ms
(0.21%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.63 ms
(0.14%)
1
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "sourcePath" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
  "sourcePathQuery" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=32148397&nearbySearchLat=47.5319&nearbySearchLong=14.06544&sorting=nearbySearchAsc&page=2&randSeed=243"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=32148397&nearbySearchLat=47.5319&nearbySearchLong=14.06544&page=2&randSeed=243&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.62 ms
(0.14%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.48 ms
(0.11%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.44 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.35 ms
(0.08%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.34 ms
(0.08%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.31 ms
(0.07%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.26 ms
(0.06%)
1
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  196171
  "facilities"
]
0.24 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.22 ms
(0.05%)
1
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  196171
]
0.22 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.18 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.17 ms
(0.04%)
1
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  196171
]
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 * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  196171
]
0.14 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.14 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.10 ms
(0.02%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.10 ms
(0.02%)
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:
[
  196171
]
0.10 ms
(0.02%)
1
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  196171
]
0.09 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.08 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.07 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  196171
  "demiExtension"
]
0.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.05 ms
(0.01%)
1
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  196171
  "demiExtension"
]
0.05 ms
(0.01%)
1
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  196171
  "demiExtension"
]
0.04 ms
(0.01%)
1
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  196171
  "demiExtension"
]

demi_vacancies connection

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