Cruise Factor - Find Your Perfect Cruise

My Favourite Cruises

Upcoming Sailings

Sailing Date	Nights	Cruise
23 December 2019	10	Pandaw II, Golden Land (Downstream) ex Mandalay to Yangon
28 December 2019	7	Orient Pandaw, Mandalay Pagan Packet Downstream ex Mandalay to Pagan
28 December 2019	7	Orient Pandaw, Mandalay Pagan Packet Downstream ex Mandalay to Pagan
28 December 2019	4	Anawrahta, Ancient Capitals ex Mandalay to Bagan
29 December 2019	4	Orient Pandaw, Downstream Cruise ex Mandalay to Pagan
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
4 January 2020	7	Orient Pandaw, Mandalay Pagan Packet Upstream ex Pagan to Mandalay
4 January 2020	7	Orient Pandaw, Mandalay Pagan Packet Upstream ex Pagan to Mandalay
5 January 2020	14	Pandaw II, The Irrawaddy (Upstream) ex Rangoon to Mandalay

Page Navigation: 1 2 3 Next »

Items 1 - 10 of 21

#	Query	Time
(1)	connect	0.0010910034179688
(2)	DESCRIBE `ports`	0.0025620460510254
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'yandabo-burma') AND (orchid_available = 1) LIMIT 1	0.028503894805908
(4)	DESCRIBE `cruises`	0.0056190490722656
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (37682, 56009, 82951, 65901, 66089, 65902, 68093, 49093, 82950, 28927)) ORDER BY FIND_IN_SET(id, '37682,56009,82951,65901,66089,65902,68093,49093,82950,28927')	0.0028729438781738
(6)	DESCRIBE `cruises`	0.0042831897735596
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '37682')	0.0006871223449707
(8)	DESCRIBE `cruises`	0.0043230056762695
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56009')	0.0005490779876709
(10)	DESCRIBE `cruises`	0.0035860538482666
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82951')	0.00056195259094238
(12)	DESCRIBE `cruises`	0.0044291019439697
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65901')	0.00043201446533203
(14)	DESCRIBE `cruises`	0.0039870738983154
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66089')	0.00054001808166504
(16)	DESCRIBE `cruises`	0.0041592121124268
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65902')	0.00042104721069336
(18)	DESCRIBE `cruises`	0.0035350322723389
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68093')	0.0004270076751709
(20)	DESCRIBE `cruises`	0.0033738613128662
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49093')	0.0003969669342041
(22)	DESCRIBE `cruises`	0.0035970211029053
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82950')	0.00040316581726074
(24)	DESCRIBE `cruises`	0.0033068656921387
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '28927')	0.0003969669342041
(26)	DESCRIBE `cruisetypes`	0.0028679370880127
(27)	DESCRIBE `destinations`	0.0039558410644531
(28)	DESCRIBE `cruiselines`	0.0027050971984863
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195)))	0.00048613548278809
(30)	DESCRIBE `ships`	0.004990816116333
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1552)))	0.00073695182800293
(32)	DESCRIBE `cruiselines`	0.0029559135437012
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195)))	0.00071096420288086
(34)	DESCRIBE `ships`	0.0057690143585205
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1552)))	0.00081491470336914
(36)	DESCRIBE `ports`	0.0029468536376953
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163)))	0.00065803527832031

Query

Time

(1)

connect

0.0010910034179688

(2)

DESCRIBE `ports`

0.0025620460510254

(3)

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

0.028503894805908

(4)

DESCRIBE `cruises`

0.0056190490722656

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (37682, 56009, 82951, 65901, 66089, 65902, 68093, 49093, 82950, 28927)) ORDER BY FIND_IN_SET(id, '37682,56009,82951,65901,66089,65902,68093,49093,82950,28927')

0.0028729438781738

(6)

DESCRIBE `cruises`

0.0042831897735596

(7)

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

0.0006871223449707

(8)

DESCRIBE `cruises`

0.0043230056762695

(9)

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

0.0005490779876709

(10)

DESCRIBE `cruises`

0.0035860538482666

(11)

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

0.00056195259094238

(12)

DESCRIBE `cruises`

0.0044291019439697

(13)

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

0.00043201446533203

(14)

DESCRIBE `cruises`

0.0039870738983154

(15)

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

0.00054001808166504

(16)

DESCRIBE `cruises`

0.0041592121124268

(17)

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

0.00042104721069336

(18)

DESCRIBE `cruises`

0.0035350322723389

(19)

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

0.0004270076751709

(20)

DESCRIBE `cruises`

0.0033738613128662

(21)

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

0.0003969669342041

(22)

DESCRIBE `cruises`

0.0035970211029053

(23)

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

0.00040316581726074

(24)

DESCRIBE `cruises`

0.0033068656921387

(25)

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

0.0003969669342041

(26)

DESCRIBE `cruisetypes`

0.0028679370880127

(27)

DESCRIBE `destinations`

0.0039558410644531

(28)

DESCRIBE `cruiselines`

0.0027050971984863

(29)

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

0.00048613548278809

(30)

DESCRIBE `ships`

0.004990816116333

(31)

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

0.00073695182800293

(32)

DESCRIBE `cruiselines`

0.0029559135437012

(33)

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

0.00071096420288086

(34)

DESCRIBE `ships`

0.0057690143585205

(35)

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

0.00081491470336914

(36)

DESCRIBE `ports`

0.0029468536376953

(37)

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

0.00065803527832031

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report