Query Metrics

127 Database Queries
40 Different statements
412.40 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
45.87 ms
(11.12%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
32.09 ms
(7.78%)
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:
[]
5.18 ms
(1.26%)
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.20 ms
(0.53%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.87 ms
(0.45%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.55 ms
(0.38%)
16
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  190598
]
0.75 ms
(0.18%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.74 ms
(0.18%)
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=841779&nearbySearchLat=47.384595913746&nearbySearchLong=13.462582932541&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=841779&nearbySearchLat=47.384595913746&nearbySearchLong=13.462582932541&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.68 ms
(0.16%)
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.62 ms
(0.15%)
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.55 ms
(0.13%)
4
SELECT id FROM sites
Parameters:
[]
0.50 ms
(0.12%)
1
SELECT * FROM object_relations_80 WHERE src_id = ?
Parameters:
[
  841779
]
0.47 ms
(0.11%)
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.44 ms
(0.11%)
1
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  79926
]
0.37 ms
(0.09%)
1
SELECT * FROM object_localized_data_80 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  841779
]
0.35 ms
(0.08%)
1
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  79926
  "facilities"
]
0.30 ms
(0.07%)
1
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.30 ms
(0.07%)
2
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  841779
]
0.29 ms
(0.07%)
1
SELECT * FROM object_store_80 WHERE oo_id = ?
Parameters:
[
  841779
]
0.29 ms
(0.07%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.28 ms
(0.07%)
2
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
Parameters:
[
  841779
]
0.23 ms
(0.06%)
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.20 ms
(0.05%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.20 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.19 ms
(0.05%)
1
SELECT * FROM object_localized_data_8 WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  79926
]
0.17 ms
(0.04%)
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.16 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.16 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.13 ms
(0.03%)
1
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  79926
]
0.12 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.12 ms
(0.03%)
1
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  4084
  4084
]
0.10 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.09 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  79926
  "demiExtension"
]
0.08 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.07 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiEnrichAcco_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  79926
  "demiExtension"
]
0.07 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  79926
  "demiExtension"
]
0.07 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  79926
  "demiExtension"
]

demi_vacancies connection

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