Belmond River Cruises

Your 'Cruise Line' has been chosenClear this filter or visit another page to change

Belmond River Cruises

Few places on earth remain untouched in their natural beauty and charm from one century to the next. The ancient land of Burma, now known... ... Read More »

Star Rating River

Star Rating	River

#	Query	Time
(1)	connect	0.001331090927124
(2)	DESCRIBE `cruiselines`	0.0047359466552734
(3)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'orient-express-cruises') AND (orchid_available = 1) LIMIT 1	0.0017261505126953
(4)	DESCRIBE `avid_specials`	0.0027499198913574
(5)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '115' AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))	0.0022099018096924
(6)	DESCRIBE `orchid_image`	0.0021898746490479
(7)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '115')	0.00040197372436523
(8)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14')	0.00034403800964355
(9)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14')	0.00033211708068848
(10)	DESCRIBE `cruisetypes`	0.0018510818481445
(11)	SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '115') AND (cruises_and_specials.ship_id = '503') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC	0.030375003814697
(12)	DESCRIBE `destinations`	0.0026099681854248
(13)	SELECT DISTINCT `destinations`.* FROM `destinations` LEFT JOIN `cruises_and_specials` ON destinations.id = cruises_and_specials.destination_id LEFT JOIN `ports` ON ports.destination_id = destinations.id WHERE (destinations.id = cruises_and_specials.destination_id) AND (cruises_and_specials.cruiseline_id = '115') AND (cruises_and_specials.ship_id = '503') AND (ports.id = '3632') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC	0.030270099639893
(14)	DESCRIBE `cruiselines`	0.012015104293823
(15)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115)))	0.00056195259094238
(16)	DESCRIBE `ships`	0.0037400722503662
(17)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503)))	0.00072693824768066
(18)	DESCRIBE `cruiselines`	0.0031819343566895
(19)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115)))	0.0004880428314209
(20)	DESCRIBE `ships`	0.0037069320678711
(21)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503)))	0.00077605247497559
(22)	DESCRIBE `ports`	0.0020380020141602
(23)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632)))	0.00043702125549316

Query

Time

(1)

connect

0.001331090927124

(2)

DESCRIBE `cruiselines`

0.0047359466552734

(3)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'orient-express-cruises') AND (orchid_available = 1) LIMIT 1

0.0017261505126953

(4)

DESCRIBE `avid_specials`

0.0027499198913574

(5)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '115' AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))

0.0022099018096924

(6)

DESCRIBE `orchid_image`

0.0021898746490479

(7)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '115')

0.00040197372436523

(8)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14')

0.00034403800964355

(9)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14')

0.00033211708068848

(10)

DESCRIBE `cruisetypes`

0.0018510818481445

(11)

SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '115') AND (cruises_and_specials.ship_id = '503') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC

0.030375003814697

(12)

DESCRIBE `destinations`

0.0026099681854248

(13)

SELECT DISTINCT `destinations`.* FROM `destinations` LEFT JOIN `cruises_and_specials` ON destinations.id = cruises_and_specials.destination_id LEFT JOIN `ports` ON ports.destination_id = destinations.id WHERE (destinations.id = cruises_and_specials.destination_id) AND (cruises_and_specials.cruiseline_id = '115') AND (cruises_and_specials.ship_id = '503') AND (ports.id = '3632') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC

0.030270099639893

(14)

DESCRIBE `cruiselines`

0.012015104293823

(15)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115)))

0.00056195259094238

(16)

DESCRIBE `ships`

0.0037400722503662

(17)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503)))

0.00072693824768066

(18)

DESCRIBE `cruiselines`

0.0031819343566895

(19)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115)))

0.0004880428314209

(20)

DESCRIBE `ships`

0.0037069320678711

(21)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503)))

0.00077605247497559

(22)

DESCRIBE `ports`

0.0020380020141602

(23)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632)))

0.00043702125549316

My Favourite Cruises