Hotels in Khanh Hoa

View Detail

From:

200 USD

Six Senses Ninh Van Bay

Ninh Van, Ninh Hoa, Khanh Hoa, Vietnam

A-Z Hotels of Other Destinations

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='hotel'	0.0016829967498779
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00064897537231445
3	SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0045390129089355
4	SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 AND country_id IN (SELECT country_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no asc	0.013834953308105
5	SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc	0.0068399906158447
6	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00032591819763184
7	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='2' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0055620670318604
8	SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1	0.00035595893859863
9	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='4' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0042240619659424
10	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.00036191940307617
11	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='3' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0043778419494629
12	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00045084953308105
13	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='1' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0052478313446045
14	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no ASC	0.0084278583526611
15	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0064489841461182
16	SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0048937797546387
17	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3	0.004403829574585
18	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00063300132751465
19	SELECT guidecat_id,title,slug FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0072338581085205
20	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and slug = 'khanh-hoa' limit 0,1	0.0098471641540527
21	SELECT title,slug,intro,content,intro_hotel,image_hotel FROM default_city WHERE city_id='620'	0.00050997734069824
22	SELECT distinct country_id FROM default_city where city_id=620 LIMIT 0,1	0.00031208992004395
23	SELECT country_id FROM default_city WHERE city_id='620'	0.00058507919311523
24	SELECT slug FROM default_city WHERE city_id='620'	0.00040602684020996
25	SELECT region_id,title FROM default_region WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' order by order_no ASC	0.0084080696105957
26	SELECT city_id,title FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and region_id=0 and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0084960460662842
27	SELECT hotel_id FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and city_id='620'	0.012408971786499
28	SELECT hotel_id,star_id,slug,title,address,intro,image FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and city_id='620' order by order_no ASC LIMIT 0,12	0.012495040893555
29	SELECT blog_id FROM default_blog WHERE lang_id='' and is_trash=0 and is_online=1 and blog_id IN (SELECT blog_id FROM default_blog_destination WHERE country_id='' and city_id='620')	0.0086100101470947
30	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'a%' or slug like 'A%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.01728081703186
31	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'b%' or slug like 'B%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0099949836730957
32	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'c%' or slug like 'C%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.012513160705566
33	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'd%' or slug like 'D%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.012691020965576
34	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'e%' or slug like 'E%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.010082006454468
35	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'f%' or slug like 'F%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.010478019714355
36	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'g%' or slug like 'G%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.011666059494019
37	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'h%' or slug like 'H%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.012202024459839
38	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'i%' or slug like 'I%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.012413024902344
39	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'j%' or slug like 'J%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.017720937728882
40	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'k%' or slug like 'K%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0072369575500488
41	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'l%' or slug like 'L%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0073449611663818
42	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'm%' or slug like 'M%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.007436990737915
43	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'n%' or slug like 'N%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0074501037597656
44	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'o%' or slug like 'O%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0074679851531982
45	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'p%' or slug like 'P%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.007559061050415
46	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'q%' or slug like 'Q%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0078809261322021
47	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'r%' or slug like 'R%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0069088935852051
48	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 's%' or slug like 'S%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0079870223999023
49	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 't%' or slug like 'T%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0093369483947754
50	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'u%' or slug like 'U%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0086460113525391
51	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'v%' or slug like 'V%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0068001747131348
52	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'w%' or slug like 'W%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0085279941558838
53	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'x%' or slug like 'X%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0093791484832764
54	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'y%' or slug like 'Y%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0066380500793457
55	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and city_id<>'620' and (slug like 'z%' or slug like 'Z%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0085980892181396
56	SELECT intro FROM default_city WHERE city_id='620'	0.00033783912658691
57	SELECT page_id,title,slug FROM default_page WHERE lang_id='' and is_trash=0 and is_online=1 and page_id <>'1' order by order_no asc	0.0039799213409424
58	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/en/hotels/vietnam/khanh-hoa' or config_link='/en/hotels/vietnam/khanh-hoa') limit 1	0.0063049793243408
59	SELECT slug FROM default_country WHERE country_id='7'	0.0003809928894043
60	SELECT slug FROM default_country WHERE country_id='1'	0.00024700164794922
61	SELECT slug FROM default_country WHERE country_id='37'	0.00026893615722656
62	SELECT slug FROM default_country WHERE country_id='52'	0.00029802322387695
63	SELECT slug FROM default_country WHERE country_id='3'	0.00031709671020508
64	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.00029492378234863
65	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.00031614303588867
66	SELECT title FROM default_tour_category WHERE tourcat_id='412'	0.00027203559875488
67	SELECT slug FROM default_tour_category WHERE tourcat_id='412'	0.00022006034851074
68	SELECT title FROM default_tour_category WHERE tourcat_id='410'	0.0002748966217041
69	SELECT slug FROM default_tour_category WHERE tourcat_id='410'	0.0003211498260498
70	SELECT title FROM default_tour_category WHERE tourcat_id='403'	0.00027108192443848
71	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.00022387504577637
72	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00026798248291016
73	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.00034594535827637
74	SELECT title FROM default_tour_category WHERE tourcat_id='402'	0.00019693374633789
75	SELECT slug FROM default_tour_category WHERE tourcat_id='402'	0.00023698806762695
76	SELECT title FROM default_tour_category WHERE tourcat_id='3'	0.00023102760314941
77	SELECT slug FROM default_tour_category WHERE tourcat_id='3'	0.00028085708618164
78	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='49' and is_trash=0 and is_online=1 order by order_no ASC	0.002838134765625
79	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='6' and is_trash=0 and is_online=1 order by order_no ASC	0.0042359828948975
80	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='7' and is_trash=0 and is_online=1 order by order_no ASC	0.0027961730957031
81	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='47'	0.00027012825012207
82	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='47' and is_trash=0 and is_online=1 order by order_no ASC	0.0024828910827637
83	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='47' and is_trash=0 and is_online=1 order by order_no ASC	0.0058600902557373
84	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='2' and is_trash=0 and is_online=1 order by order_no ASC	0.0025639533996582
85	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='4' and is_trash=0 and is_online=1 order by order_no ASC	0.0036211013793945
86	SELECT hotel_price_range_id,title FROM default_hotel_price_range WHERE lang_id='' and 1=1 and is_trash=0 order by order_no asc	0.0031349658966064
87	SELECT country_id,title FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0028700828552246
88	SELECT hotel_room_id,price,number_adult FROM default_hotel_room WHERE is_trash=0 and hotel_id='381' and price >0 order by price ASC	0.0016560554504395
89	SELECT distinct property_code FROM default_property where property_id=951 LIMIT 0,1	0.0003199577331543
90	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '23'	0.006335973739624
91	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '15'	0.0083379745483398
92	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '13'	0.0090961456298828
93	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '1'	0.0097370147705078
94	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '16'	0.0083379745483398
95	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '9'	0.0052690505981445
96	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '2'	0.0048520565032959
97	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '12'	0.0071070194244385
98	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and city_id = '620' and cat_id = '14'	0.0097510814666748

Hotels in Khanh Hoa

Six Senses Ninh Van Bay

A-Z Hotels of Other Destinations

VietISO Company

About isoCMS

Travel Styles

Other

Follow Us

Payment Channel