Query Metrics

95 Database Queries
26 Different statements
469.64 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
56.15 ms
(11.96%)
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:
[]
40.22 ms
(8.56%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
6.61 ms
(1.41%)
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.46%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
2.04 ms
(0.43%)
13
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.82 ms
(0.17%)
4
SELECT id FROM sites
Parameters:
[]
0.81 ms
(0.17%)
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.69 ms
(0.15%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.66 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.61 ms
(0.13%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.61 ms
(0.13%)
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=324743&nearbySearchLat=46.86932&nearbySearchLong=15.22211&page=2&randSeed=906&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=324743&nearbySearchLat=46.86932&nearbySearchLong=15.22211&page=2&randSeed=906&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.37 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.29 ms
(0.06%)
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.28 ms
(0.06%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.24 ms
(0.05%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.22 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.19 ms
(0.04%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.18 ms
(0.04%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.17 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.17 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.17 ms
(0.04%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.13 ms
(0.03%)
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.12 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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