Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
47.49 ms
(11.46%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
31.82 ms
(7.68%)
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:
[]
4.74 ms
(1.14%)
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
]
1.61 ms
(0.39%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.42 ms
(0.34%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
0.56 ms
(0.14%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.55 ms
(0.13%)
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.54 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=41575848&nearbySearchLat=47.39889&nearbySearchLong=14.57172&sorting=nearbySearchAsc&page=12&randSeed=37"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=41575848&nearbySearchLat=47.39889&nearbySearchLong=14.57172&page=12&randSeed=37&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.53 ms
(0.13%)
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.39 ms
(0.10%)
4
SELECT id FROM sites
Parameters:
[]
0.34 ms
(0.08%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.27 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.22 ms
(0.05%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.21 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
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.17 ms
(0.04%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.15 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.13 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.12 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.10 ms
(0.02%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.09 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.09 ms
(0.02%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.08 ms
(0.02%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.06 ms
(0.01%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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