Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
29 December 2019	7	Allure, Western Caribbean Holiday ex Ft Lauderdale Return
5 January 2020	7	Allure, Eastern Caribbean ex Ft Lauderdale Roundtrip
12 January 2020	7	Allure, Western Caribbean ex Ft Lauderdale Roundtrip
19 January 2020	7	Allure, Eastern Caribbean ex Ft Lauderdale Roundtrip
2 February 2020	7	Allure, An Eastern Caribbean & Perfect Day ex Ft Lauderdale
16 February 2020	7	Allure, Eastern Caribbean & Perfect Day ex Ft Lauderdale
1 March 2020	12	Allure, Spanish Transatlantic Cruise ex Ft Lauderdale to Barcelona
24 May 2020	7	SPECIAL!!Allure, Western Mediterranean ex Barcelona Return
1 November 2020	14	Allure, Spain & Perfect Day Transatlantic ex Barcelona to Miami
15 November 2020	7	Allure, Western Caribbean Cruise ex Miami Return

Page Navigation: 1 2 Next »

Items 1 - 10 of 13

#	Query	Time
(1)	connect	0.0010490417480469
(2)	DESCRIBE `ships`	0.0054001808166504
(3)	SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'allure-of-the-seas') LIMIT 1	0.0082249641418457
(4)	DESCRIBE `cruises`	0.0043261051177979
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (73459, 73454, 73455, 73457, 81223, 81222, 48589, 48586, 81462, 55109)) ORDER BY FIND_IN_SET(id, '73459,73454,73455,73457,81223,81222,48589,48586,81462,55109')	0.0025339126586914
(6)	DESCRIBE `cruises`	0.0040788650512695
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73459')	0.00075888633728027
(8)	DESCRIBE `cruises`	0.0044209957122803
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73454')	0.00063014030456543
(10)	DESCRIBE `cruises`	0.0047869682312012
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73455')	0.00051116943359375
(12)	DESCRIBE `cruises`	0.0036001205444336
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73457')	0.00049400329589844
(14)	DESCRIBE `cruises`	0.0039761066436768
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81223')	0.00040006637573242
(16)	DESCRIBE `cruises`	0.0033071041107178
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81222')	0.00042915344238281
(18)	DESCRIBE `cruises`	0.0037238597869873
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48589')	0.00048995018005371
(20)	DESCRIBE `cruises`	0.0035078525543213
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48586')	0.00037097930908203
(22)	DESCRIBE `cruises`	0.0035240650177002
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81462')	0.0005040168762207
(24)	DESCRIBE `cruises`	0.0034208297729492
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55109')	0.00053000450134277
(26)	DESCRIBE `cruisetypes`	0.0018329620361328
(27)	DESCRIBE `destinations`	0.0025730133056641
(28)	DESCRIBE `cruiselines`	0.0026710033416748
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 105)))	0.00052309036254883
(30)	DESCRIBE `ships`	0.0037040710449219
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 791)))	0.0004880428314209
(32)	DESCRIBE `cruiselines`	0.0042829513549805
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 105)))	0.00069904327392578
(34)	DESCRIBE `ships`	0.0036931037902832
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 791)))	0.00047779083251953

Query

Time

(1)

connect

0.0010490417480469

(2)

DESCRIBE `ships`

0.0054001808166504

(3)

SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'allure-of-the-seas') LIMIT 1

0.0082249641418457

(4)

DESCRIBE `cruises`

0.0043261051177979

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (73459, 73454, 73455, 73457, 81223, 81222, 48589, 48586, 81462, 55109)) ORDER BY FIND_IN_SET(id, '73459,73454,73455,73457,81223,81222,48589,48586,81462,55109')

0.0025339126586914

(6)

DESCRIBE `cruises`

0.0040788650512695

(7)

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

0.00075888633728027

(8)

DESCRIBE `cruises`

0.0044209957122803

(9)

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

0.00063014030456543

(10)

DESCRIBE `cruises`

0.0047869682312012

(11)

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

0.00051116943359375

(12)

DESCRIBE `cruises`

0.0036001205444336

(13)

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

0.00049400329589844

(14)

DESCRIBE `cruises`

0.0039761066436768

(15)

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

0.00040006637573242

(16)

DESCRIBE `cruises`

0.0033071041107178

(17)

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

0.00042915344238281

(18)

DESCRIBE `cruises`

0.0037238597869873

(19)

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

0.00048995018005371

(20)

DESCRIBE `cruises`

0.0035078525543213

(21)

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

0.00037097930908203

(22)

DESCRIBE `cruises`

0.0035240650177002

(23)

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

0.0005040168762207

(24)

DESCRIBE `cruises`

0.0034208297729492

(25)

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

0.00053000450134277

(26)

DESCRIBE `cruisetypes`

0.0018329620361328

(27)

DESCRIBE `destinations`

0.0025730133056641

(28)

DESCRIBE `cruiselines`

0.0026710033416748

(29)

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

0.00052309036254883

(30)

DESCRIBE `ships`

0.0037040710449219

(31)

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

0.0004880428314209

(32)

DESCRIBE `cruiselines`

0.0042829513549805

(33)

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

0.00069904327392578

(34)

DESCRIBE `ships`

0.0036931037902832

(35)

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

0.00047779083251953

Find Your Cruise

Upcoming Sailings

Database Profiling Report