Query Metrics

115 Database Queries
41 Different statements
460.37 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
54.75 ms
(11.89%)
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:
[]
44.98 ms
(9.77%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
5.66 ms
(1.23%)
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.48%)
29
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.72 ms
(0.37%)
14
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
0.84 ms
(0.18%)
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.79 ms
(0.17%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  115
]
0.73 ms
(0.16%)
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=1430703&nearbySearchLat=47.21501&nearbySearchLong=14.83023&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Urlaub-planen/Unterkuenfte-suchen-buchen?nearbySearchId=1430703&nearbySearchLat=47.21501&nearbySearchLong=14.83023&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.68 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.59 ms
(0.13%)
4
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/steiermark.com/%"
  "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.48 ms
(0.10%)
1
SELECT * FROM object_collection_demiFacilityRelation_8 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  1749431
  "facilities"
]
0.43 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.35 ms
(0.08%)
4
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Urlaub-planen/Unterkuenfte-suchen-buchen"
]
0.33 ms
(0.07%)
1
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
  1749431
]
0.31 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.31 ms
(0.07%)
2
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
  1430703
]
0.30 ms
(0.06%)
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:
[
  1430703
]
0.29 ms
(0.06%)
1
SELECT * FROM object_localized_data_AlpsteinTour WHERE ooo_id = ? AND language IN ('de','en','hu','cs','pl','nl','it','sk')
Parameters:
[
  1430703
]
0.23 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:
[
  1749431
]
0.22 ms
(0.05%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.21 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.21 ms
(0.05%)
1
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  115
  115
  115
]
0.20 ms
(0.04%)
1
SELECT * FROM object_relations_AlpsteinTour WHERE src_id = ?
Parameters:
[
  1430703
]
0.18 ms
(0.04%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3189171
]
0.17 ms
(0.04%)
1
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:
[
  5188664
]
0.15 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.15 ms
(0.03%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.15 ms
(0.03%)
1
SELECT * FROM object_store_AlpsteinTour WHERE oo_id = ?
Parameters:
[
  1430703
]
0.14 ms
(0.03%)
1
SELECT * FROM object_store_8 WHERE oo_id = ?
Parameters:
[
  1749431
]
0.14 ms
(0.03%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  115
]
0.14 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  6804
  "datepickerInfoTexts"
]
0.13 ms
(0.03%)
1
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
  5188664
]
0.12 ms
(0.03%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/Urlaub-planen/Unterkuenfte-suchen-buchen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.11 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiAccessibilityCategories_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  1749431
  "demiExtension"
]
0.10 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:
[
  1749431
  "demiExtension"
]
0.07 ms
(0.02%)
1
SELECT * FROM object_brick_store_demiCanonicalRegion_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  1749431
  "demiExtension"
]
0.07 ms
(0.01%)
1
SELECT * FROM object_brick_store_demiYoungStyria_8 WHERE o_id = ? AND fieldname = ?
Parameters:
[
  1749431
  "demiExtension"
]

demi_vacancies connection

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