Kotohira

Aujourd'hui
14°C

Hôtels de Kotohira

À propos de Kotohira

Meilleurs hôtels en Kotohira

Kotohira Kadan Kotohira 42 chambres à partir de €236

Voir plus de photos

Séjours spa  -  Les hôtes peuvent profiter des eaux apaisantes de la source thermale Konpira Onsen à l'onsen de Kotohira Kadan.
Escapade à la campagne  -  Une oasis de tranquillité à l'écart de l'agitation de Kotohira et Takamatsu.
Onsen privé
Restaurant  -  Attendez-vous à une cuisine locale délectable, agrémentée du tendre bœuf nourri aux olives de Sunaki.

Situé dans de magnifiques jardins au pied du mont Kotohira, ce ryokan propose un éventail de logements dans des cottages traditionnels et des chambres plus modernes de style japonais et occidental, dont la plupart sont dotées de bains privés en plein air et de vues imprenables. Le restaurant propose une délicieuse cuisine kaiseki locale. Un joyau caché. Voir plus d'informations

Vérifier la disponibilité

Init : 2.0027160644531E-5
Dispatch : 0.36255311965942
Output : 0.00089812278747559
Total : 0.36347126960754
Peak memory: 1.4640121459961mb
Server name: Linux ip-172-26-7-178 5.4.0-1030-aws #31-Ubuntu SMP Fri Nov 13 11:40:37 UTC 2020 x86_64

0.00126 : SELECT string_id, value FROM `strings_french` WHERE 0 OR `string_id` LIKE('tabs.%')
0.00065 : SELECT string_id, value FROM `strings_french` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.00092 : SELECT * FROM `location` WHERE `handle`='japan/kotohira' ORDER BY path LIMIT 0, 1
0.00505 : SELECT * FROM `location_french` WHERE `handle`='japan/kotohira' LIMIT 0, 1
0.00393 : SELECT * FROM `location` WHERE `location_id`='32865' ORDER BY path LIMIT 0, 1
0.00365 : SELECT * FROM `location` WHERE `handle`='japan/kotohira' ORDER BY path LIMIT 0, 1
0.00062 : SELECT * FROM `location_french` WHERE `handle`='japan/kotohira' LIMIT 0, 1
0.00371 : SELECT * FROM `location` WHERE `location_id`='32865' ORDER BY path LIMIT 0, 1
0.00167 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00199 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00109 : SELECT * FROM `location_french` WHERE `location_id`='21693' LIMIT 0, 1
0.00050 : SELECT handle FROM `location_german` WHERE `location_id`='32865'
0.00070 : SELECT handle FROM `location_french` WHERE `location_id`='32865'
0.00061 : SELECT handle FROM `where_to_stay` WHERE `is_published`='1' AND `location1_id`='32865' ORDER BY title LIMIT 0, 1
0.00524 : SELECT * FROM `location` WHERE `location_id`='21693'
0.04349 : SELECT hotel_id, locations FROM `_index` WHERE `locations` LIKE('%,32865,%') AND `is_published`='1'
0.00532 : SELECT location_id FROM `location` WHERE `parent_id`='32865' OR `parent2_id`='32865'
0.00210 : SELECT * FROM `location_french` WHERE `location_id`='32865' LIMIT 0, 1
0.00235 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00077 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00076 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00333 : SELECT * FROM `location` WHERE `location_id`='32865' ORDER BY path LIMIT 0, 1
0.00074 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00336 : SELECT * FROM `location_french` WHERE `location_id`='21693' LIMIT 0, 1
0.00101 : SELECT * FROM `location` WHERE `location_id`='32865' ORDER BY path LIMIT 0, 1
0.00279 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00202 : SELECT * FROM `location_french` WHERE `location_id`='21693' LIMIT 0, 1
0.05130 : SELECT hotel_id FROM `_index` WHERE `locations` LIKE('%,32865,%') AND `is_published`='1' ORDER BY is_paid DESC, rate ASC LIMIT 0, 100
0.00663 : SELECT * FROM `hotel` WHERE `hotel_id` IN ('158622') ORDER BY is_paid DESC,IF(rate_min IS NULL,0,1) DESC, rate_min ASC LIMIT 0, 100
0.00383 : SELECT CONCAT(`from`, ":", `to`), rate FROM `currency_conversion` WHERE 1
0.00253 : SELECT * FROM `location` WHERE `location_id`='32865'
0.00278 : SELECT * FROM `location_french` WHERE `location_id`='32865' LIMIT 0, 1
0.00527 : SELECT tag_id, strap,score, tag.title AS title, tag.default_strap AS default_strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158622' AND (hotel_tag.score>1 OR tag.is_featured_list=1) and collection <> 7 ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC LIMIT 0, 4
0.00424 : SELECT tag_id,strap FROM `hotel_tag_french` WHERE `hotel_id`='158622'
0.00405 : SELECT tag_french.tag_id, title,default_strap FROM `tag_french` WHERE 1
0.00224 : SELECT tag_id,title,handle FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158622' AND tag_id in (3,33,423,303,593,1703,123,1193,853,1353,63) ORDER BY hotel_tag.tag_id
0.00110 : SELECT tag.tag_id,tag_french.title,tag.handle FROM `hotel_tag` JOIN tag_french USING(tag_id) JOIN tag USING(tag_id) WHERE `hotel_id`='158622' AND tag_id in (3,33,423,303,593,1703,123,1193,853,1353,63) ORDER BY hotel_tag.tag_id
0.00250 : SELECT * FROM `hotel_french` WHERE `hotel_id`='158622' LIMIT 0, 1
0.00134 : SELECT * FROM `attraction` WHERE `location_id`='32865' ORDER BY title LIMIT 0, 50
0.00356 : SELECT * FROM `location_french` WHERE `location_id`='32865' LIMIT 0, 1
0.00522 : SELECT * FROM `article` WHERE (is_published=1 AND (location1_id=32865 OR location2_id=32865 OR location3_id=32865)) ORDER BY datetime_published DESC LIMIT 0, 1000
0.01894 : SELECT * FROM `imagestore` WHERE `global_id`='137438986305' ORDER BY image_id = "3d186306c8cb7e66fc3e85f0d58afce1" DESC, position ASC
0.00322 : SELECT * FROM `imagestore` WHERE `image_id`='3d186306c8cb7e66fc3e85f0d58afce1'
0.00369 : SELECT * FROM `imagestore` WHERE `image_id`='37e5c858fc36f24e62591392c1137421'
0.00242 : SELECT * FROM `imagestore` WHERE `image_id`='37e5c858fc36f24e62591392c1137421'
0.00536 : SELECT * FROM `imagestore` WHERE `image_id`='0f79240e97b4909d12c650641d1b0bb1'
0.00299 : SELECT * FROM `imagestore` WHERE `image_id`='0f79240e97b4909d12c650641d1b0bb1'
0.00110 : SELECT * FROM `imagestore` WHERE `image_id`='ebc9dc163776191ed1bbb2c23806a6d1'
0.00084 : SELECT * FROM `imagestore` WHERE `image_id`='ebc9dc163776191ed1bbb2c23806a6d1'
0.00074 : SELECT * FROM `imagestore` WHERE `image_id`='3d186306c8cb7e66fc3e85f0d58afce1'
0.00264 : SELECT * FROM `imagestore` WHERE `image_id`='3d186306c8cb7e66fc3e85f0d58afce1'
0.00115 : SELECT * FROM `imagestore` WHERE `global_id`='137438986305' ORDER BY image_id = "3d186306c8cb7e66fc3e85f0d58afce1" DESC, position ASC
0.00201 : SELECT * FROM `imagestore` WHERE `image_id`='3d186306c8cb7e66fc3e85f0d58afce1'
0.00063 : SELECT * FROM `imagestore` WHERE `image_id`='37e5c858fc36f24e62591392c1137421'
0.00343 : SELECT * FROM `imagestore` WHERE `image_id`='37e5c858fc36f24e62591392c1137421'
0.00069 : SELECT * FROM `imagestore` WHERE `image_id`='0f79240e97b4909d12c650641d1b0bb1'
0.00061 : SELECT * FROM `imagestore` WHERE `image_id`='0f79240e97b4909d12c650641d1b0bb1'
0.00231 : SELECT * FROM `imagestore` WHERE `image_id`='ebc9dc163776191ed1bbb2c23806a6d1'
0.00069 : SELECT * FROM `imagestore` WHERE `image_id`='ebc9dc163776191ed1bbb2c23806a6d1'
0.00380 : SELECT * FROM `imagestore` WHERE `image_id`='3d186306c8cb7e66fc3e85f0d58afce1'
0.00270 : SELECT * FROM `imagestore` WHERE `image_id`='3d186306c8cb7e66fc3e85f0d58afce1'

Kotohira

Recherchez les meilleurs hôtels de Kotohira

À propos de Kotohira

Meilleurs hôtels en Kotohira

Kotohira Kadan Kotohira 42 chambres à partir de €236