Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
23 December 2019	10	Kalay Pandaw, Pagan & Upper Irrawaddy (Downstream) ex Mandalay to Pagan
28 December 2019	4	Anawrahta, Ancient Capitals ex Mandalay to Bagan
1 January 2020	4	Anawrahta, Golden Land ex Bagan to Mandalay
2 January 2020	10	Kalay Pandaw, Pagan & Upper Irrawaddy (Upstream) ex Pagan to Mandalay
22 January 2020	10	Kha Byoo Pandaw, Pagan & Upper Irrawaddy (Downstream) ex Mandalay to Pagan
11 February 2020	10	Kha Byoo Pandaw, Pagan & Upper Irrawaddy (Upstream) ex Pagan to Mandalay
24 September 2020	10	Zawgyi, Pagan & Upper Irrawaddy (Upstream) ex Pagan to Mandalay

Page Navigation: 1

Items 1 - 7 of 7

#	Query	Time
(1)	connect	0.0011310577392578
(2)	DESCRIBE `ports`	0.0036900043487549
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'ava-burma') AND (orchid_available = 1) LIMIT 1	0.023410081863403
(4)	DESCRIBE `cruises`	0.0039489269256592
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (68092, 65901, 65902, 68093, 59699, 59698, 55986)) ORDER BY FIND_IN_SET(id, '68092,65901,65902,68093,59699,59698,55986')	0.0013720989227295
(6)	DESCRIBE `cruises`	0.0036759376525879
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68092')	0.00051522254943848
(8)	DESCRIBE `cruises`	0.0039830207824707
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65901')	0.00049710273742676
(10)	DESCRIBE `cruises`	0.0037028789520264
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65902')	0.0005500316619873
(12)	DESCRIBE `cruises`	0.0040340423583984
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68093')	0.0005650520324707
(14)	DESCRIBE `cruises`	0.0037238597869873
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59699')	0.00052690505981445
(16)	DESCRIBE `cruises`	0.0035450458526611
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59698')	0.00044918060302734
(18)	DESCRIBE `cruises`	0.0033760070800781
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55986')	0.00045895576477051
(20)	DESCRIBE `cruisetypes`	0.0017309188842773
(21)	DESCRIBE `destinations`	0.0025238990783691
(22)	DESCRIBE `cruiselines`	0.0032088756561279
(23)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183)))	0.00050687789916992
(24)	DESCRIBE `ships`	0.0036759376525879
(25)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503)))	0.00065708160400391
(26)	DESCRIBE `cruiselines`	0.0030820369720459
(27)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183)))	0.00045895576477051
(28)	DESCRIBE `ships`	0.0036799907684326
(29)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503)))	0.0006718635559082
(30)	DESCRIBE `ports`	0.0024261474609375
(31)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3164)))	0.00042104721069336

Query

Time

(1)

connect

0.0011310577392578

(2)

DESCRIBE `ports`

0.0036900043487549

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'ava-burma') AND (orchid_available = 1) LIMIT 1

0.023410081863403

(4)

DESCRIBE `cruises`

0.0039489269256592

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (68092, 65901, 65902, 68093, 59699, 59698, 55986)) ORDER BY FIND_IN_SET(id, '68092,65901,65902,68093,59699,59698,55986')

0.0013720989227295

(6)

DESCRIBE `cruises`

0.0036759376525879

(7)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68092')

0.00051522254943848

(8)

DESCRIBE `cruises`

0.0039830207824707

(9)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65901')

0.00049710273742676

(10)

DESCRIBE `cruises`

0.0037028789520264

(11)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65902')

0.0005500316619873

(12)

DESCRIBE `cruises`

0.0040340423583984

(13)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68093')

0.0005650520324707

(14)

DESCRIBE `cruises`

0.0037238597869873

(15)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59699')

0.00052690505981445

(16)

DESCRIBE `cruises`

0.0035450458526611

(17)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59698')

0.00044918060302734

(18)

DESCRIBE `cruises`

0.0033760070800781

(19)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55986')

0.00045895576477051

(20)

DESCRIBE `cruisetypes`

0.0017309188842773

(21)

DESCRIBE `destinations`

0.0025238990783691

(22)

DESCRIBE `cruiselines`

0.0032088756561279

(23)

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

0.00050687789916992

(24)

DESCRIBE `ships`

0.0036759376525879

(25)

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

0.00065708160400391

(26)

DESCRIBE `cruiselines`

0.0030820369720459

(27)

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

0.00045895576477051

(28)

DESCRIBE `ships`

0.0036799907684326

(29)

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

0.0006718635559082

(30)

DESCRIBE `ports`

0.0024261474609375

(31)

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

0.00042104721069336

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report