Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
29 December 2018	7	Seaview, Brazil Cruise ex Santos Roundtrip
30 December 2018	7	Fantasia, South America ex Rio de Janeiro Return
3 January 2019	128	Viking Sun, World Cruise 2019 ex Miami to London (Greenwich)
3 January 2019	22	Viking Sun, From Miami to South America ex Miami to Buenos Aires
5 January 2019	19	Symphony, Rio Rendezvous ex New Orleans to Rio de Janeiro
12 January 2019	7	Seaview, Brazil Cruise ex Santos Return
27 January 2019	6	Fantasia, South America Cruise ex Rio de Janeiro Return
2 February 2019	49	Royal, South America Grand Adventure ex Ft Lauderdale to Los Angeles
2 February 2019	33	Royal, Cape Horn & Brazil Grand Adventure ex Ft Lauderdale to Valparaiso
2 February 2019	19	Royal, Brazilian Adventure ex Ft Lauderdale to Buenos Aires

Page Navigation: 1 2 3 4 5 6 7 8 9 10 Next »

Items 1 - 10 of 96

#	Query	Time
(1)	connect	0.00084900856018066
(2)	DESCRIBE `ports`	0.002424955368042
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'salvador-de-bahia-brazil') AND (orchid_available = 1) LIMIT 1	0.0046291351318359
(4)	DESCRIBE `cruises`	0.003087043762207
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (69105, 76807, 71855, 78027, 67576, 69087, 76805, 69984, 69982, 69952)) ORDER BY FIND_IN_SET(id, '69105,76807,71855,78027,67576,69087,76805,69984,69982,69952')	0.0015690326690674
(6)	DESCRIBE `cruises`	0.0032289028167725
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69105')	0.00040698051452637
(8)	DESCRIBE `cruises`	0.0025491714477539
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76807')	0.00038814544677734
(10)	DESCRIBE `cruises`	0.0026810169219971
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71855')	0.00034713745117188
(12)	DESCRIBE `cruises`	0.0029919147491455
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78027')	0.00054311752319336
(14)	DESCRIBE `cruises`	0.0032310485839844
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67576')	0.00015521049499512
(16)	DESCRIBE `cruises`	0.0026910305023193
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69087')	0.00029492378234863
(18)	DESCRIBE `cruises`	0.0023360252380371
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76805')	0.00027585029602051
(20)	DESCRIBE `cruises`	0.0031070709228516
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69984')	0.00030303001403809
(22)	DESCRIBE `cruises`	0.0031330585479736
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69982')	0.00034499168395996
(24)	DESCRIBE `cruises`	0.0039498805999756
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69952')	0.00037384033203125
(26)	DESCRIBE `cruisetypes`	0.0010631084442139
(27)	DESCRIBE `destinations`	0.0015578269958496
(28)	DESCRIBE `cruiselines`	0.0016450881958008
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00040078163146973
(30)	DESCRIBE `ships`	0.0021991729736328
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00040698051452637
(32)	DESCRIBE `cruiselines`	0.002593994140625
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00047683715820312
(34)	DESCRIBE `ships`	0.002730131149292
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00040817260742188
(36)	DESCRIBE `ports`	0.001317024230957
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 470)))	0.00031495094299316

Query

Time

(1)

connect

0.00084900856018066

(2)

DESCRIBE `ports`

0.002424955368042

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'salvador-de-bahia-brazil') AND (orchid_available = 1) LIMIT 1

0.0046291351318359

(4)

DESCRIBE `cruises`

0.003087043762207

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (69105, 76807, 71855, 78027, 67576, 69087, 76805, 69984, 69982, 69952)) ORDER BY FIND_IN_SET(id, '69105,76807,71855,78027,67576,69087,76805,69984,69982,69952')

0.0015690326690674

(6)

DESCRIBE `cruises`

0.0032289028167725

(7)

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

0.00040698051452637

(8)

DESCRIBE `cruises`

0.0025491714477539

(9)

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

0.00038814544677734

(10)

DESCRIBE `cruises`

0.0026810169219971

(11)

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

0.00034713745117188

(12)

DESCRIBE `cruises`

0.0029919147491455

(13)

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

0.00054311752319336

(14)

DESCRIBE `cruises`

0.0032310485839844

(15)

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

0.00015521049499512

(16)

DESCRIBE `cruises`

0.0026910305023193

(17)

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

0.00029492378234863

(18)

DESCRIBE `cruises`

0.0023360252380371

(19)

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

0.00027585029602051

(20)

DESCRIBE `cruises`

0.0031070709228516

(21)

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

0.00030303001403809

(22)

DESCRIBE `cruises`

0.0031330585479736

(23)

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

0.00034499168395996

(24)

DESCRIBE `cruises`

0.0039498805999756

(25)

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

0.00037384033203125

(26)

DESCRIBE `cruisetypes`

0.0010631084442139

(27)

DESCRIBE `destinations`

0.0015578269958496

(28)

DESCRIBE `cruiselines`

0.0016450881958008

(29)

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

0.00040078163146973

(30)

DESCRIBE `ships`

0.0021991729736328

(31)

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

0.00040698051452637

(32)

DESCRIBE `cruiselines`

0.002593994140625

(33)

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

0.00047683715820312

(34)

DESCRIBE `ships`

0.002730131149292

(35)

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

0.00040817260742188

(36)

DESCRIBE `ports`

0.001317024230957

(37)

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

0.00031495094299316

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report