Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
30 December 2018	7	Viking Sky, Southern Mediterranean Discovery ex Rome to Barcelona
24 January 2019	92	Aegean Odyssey, Grand Asia South Africa & Mediterranean ex Singapore to Athens
11 February 2019	74	Aegean Odyssey, Grand Indian Ocean & South Africa & Med ex Colombo to Athens
23 February 2019	14	Jupiter, Mediterranean Explorations ex Rome Return
23 February 2019	7	Jupiter, Southern Mediterranean Discovery ex Rome to Barcelona
2 March 2019	14	Jupiter, Majestic Mediterranean ex Barcelona Return
13 March 2019	44	Aegean Odyssey, Grand Voyage from South Africa to the Med ex Cape Town to Athens
9 April 2019	39	Nautica, Pathway of History ex Singapore to Barcelona
13 April 2019	13	Aegean Odyssey, Classical Civilisations of Southern Med ex Malaga to Athens
25 April 2019	7	Spirit, Voyage 5912 ex Barcelona to Rome

Page Navigation: 1 2 3 4 5 Next »

Items 1 - 10 of 45

#	Query	Time
(1)	connect	0.00089287757873535
(2)	DESCRIBE `ports`	0.0024271011352539
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'trapani-italy') AND (orchid_available = 1) LIMIT 1	0.0068020820617676
(4)	DESCRIBE `cruises`	0.0035688877105713
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (71082, 73327, 73342, 74671, 74669, 74675, 73343, 69154, 73312, 72609)) ORDER BY FIND_IN_SET(id, '71082,73327,73342,74671,74669,74675,73343,69154,73312,72609')	0.0025241374969482
(6)	DESCRIBE `cruises`	0.0039541721343994
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71082')	0.00053000450134277
(8)	DESCRIBE `cruises`	0.0035731792449951
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73327')	0.00049495697021484
(10)	DESCRIBE `cruises`	0.0038142204284668
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73342')	0.00042009353637695
(12)	DESCRIBE `cruises`	0.0029799938201904
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74671')	0.00048303604125977
(14)	DESCRIBE `cruises`	0.003450870513916
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74669')	0.00049304962158203
(16)	DESCRIBE `cruises`	0.0034120082855225
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74675')	0.00045609474182129
(18)	DESCRIBE `cruises`	0.003342866897583
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73343')	0.00046896934509277
(20)	DESCRIBE `cruises`	0.0032808780670166
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69154')	0.00047397613525391
(22)	DESCRIBE `cruises`	0.0032889842987061
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73312')	0.00059413909912109
(24)	DESCRIBE `cruises`	0.0033390522003174
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72609')	0.00049591064453125
(26)	DESCRIBE `cruisetypes`	0.0015618801116943
(27)	DESCRIBE `destinations`	0.0016829967498779
(28)	DESCRIBE `cruiselines`	0.0014829635620117
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.0006711483001709
(30)	DESCRIBE `ships`	0.0026381015777588
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00041890144348145
(32)	DESCRIBE `cruiselines`	0.0020701885223389
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00034785270690918
(34)	DESCRIBE `ships`	0.0028319358825684
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00038003921508789
(36)	DESCRIBE `ports`	0.0013530254364014
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1623)))	0.00038313865661621

Query

Time

(1)

connect

0.00089287757873535

(2)

DESCRIBE `ports`

0.0024271011352539

(3)

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

0.0068020820617676

(4)

DESCRIBE `cruises`

0.0035688877105713

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (71082, 73327, 73342, 74671, 74669, 74675, 73343, 69154, 73312, 72609)) ORDER BY FIND_IN_SET(id, '71082,73327,73342,74671,74669,74675,73343,69154,73312,72609')

0.0025241374969482

(6)

DESCRIBE `cruises`

0.0039541721343994

(7)

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

0.00053000450134277

(8)

DESCRIBE `cruises`

0.0035731792449951

(9)

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

0.00049495697021484

(10)

DESCRIBE `cruises`

0.0038142204284668

(11)

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

0.00042009353637695

(12)

DESCRIBE `cruises`

0.0029799938201904

(13)

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

0.00048303604125977

(14)

DESCRIBE `cruises`

0.003450870513916

(15)

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

0.00049304962158203

(16)

DESCRIBE `cruises`

0.0034120082855225

(17)

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

0.00045609474182129

(18)

DESCRIBE `cruises`

0.003342866897583

(19)

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

0.00046896934509277

(20)

DESCRIBE `cruises`

0.0032808780670166

(21)

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

0.00047397613525391

(22)

DESCRIBE `cruises`

0.0032889842987061

(23)

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

0.00059413909912109

(24)

DESCRIBE `cruises`

0.0033390522003174

(25)

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

0.00049591064453125

(26)

DESCRIBE `cruisetypes`

0.0015618801116943

(27)

DESCRIBE `destinations`

0.0016829967498779

(28)

DESCRIBE `cruiselines`

0.0014829635620117

(29)

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

0.0006711483001709

(30)

DESCRIBE `ships`

0.0026381015777588

(31)

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

0.00041890144348145

(32)

DESCRIBE `cruiselines`

0.0020701885223389

(33)

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

0.00034785270690918

(34)

DESCRIBE `ships`

0.0028319358825684

(35)

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

0.00038003921508789

(36)

DESCRIBE `ports`

0.0013530254364014

(37)

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

0.00038313865661621

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report