Query Metrics

96 Database Queries
26 Different statements
495.59 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
59.42 ms
(11.99%)
1
select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[]
37.03 ms
(7.47%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
7.21 ms
(1.46%)
14
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
Parameters:
[
  11462
]
2.16 ms
(0.44%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.73 ms
(0.35%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.83 ms
(0.17%)
2
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[
  "defaultSiteConfig"
  null
  null
]
0.77 ms
(0.15%)
4
SELECT id FROM sites
Parameters:
[]
0.72 ms
(0.14%)
6
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte-suchen-buchen"
  "path" => "/steiermark.com/de/Urlaub-planen/"
]
0.70 ms
(0.14%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.69 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=1687817&nearbySearchLat=47.30197&nearbySearchLong=15.83368&page=3&randSeed=740&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1687817&nearbySearchLat=47.30197&nearbySearchLong=15.83368&page=3&randSeed=740&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.44 ms
(0.09%)
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.35 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.32 ms
(0.06%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.22 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.22 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.19 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.19 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.17 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.16 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 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.13 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.10 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.09 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
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:
[]

demi_vacancies connection

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