Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
20 December 2019	7	Independence, Historic South & Golden Isles ex Charleston to Jacksonville
20 December 2019	7	American Harmony, Mississippi River ex New Orleans Return
21 December 2019	7	American Star, Great Rivers of Florida ex Jacksonville Return
23 December 2019	10	American Constitution, American Revolution Cruise ex Baltimore Return
28 December 2019	7	Independence, Historic South & Golden Isles ex Jacksonville to Charleston
9 February 2020	7	American Harmony, Lower Mississippi ex New Orleans to Memphis
15 February 2020	7	America, Mississippi River Cruise ex New Orleans Return
16 February 2020	7	American Harmony, Lower Mississippi ex Memphis to New Orleans
22 February 2020	7	American Star, Historic South & Golden Isles ex Jacksonville to Charleston
29 February 2020	7	American Star, Historic South & Golden Isles ex Charleston to Jacksonville

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

Items 1 - 10 of 72

#	Query	Time
(1)	connect	0.0010430812835693
(2)	DESCRIBE `cruiselines`	0.0035691261291504
(3)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'american-cruise-lines') AND (orchid_available = 1) LIMIT 1	0.0011420249938965
(4)	DESCRIBE `cruises`	0.0041358470916748
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (29613, 75798, 66504, 71124, 29614, 75801, 57630, 75803, 47910, 47911)) ORDER BY FIND_IN_SET(id, '29613,75798,66504,71124,29614,75801,57630,75803,47910,47911')	0.001835823059082
(6)	DESCRIBE `cruises`	0.0036211013793945
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '29613')	0.00052404403686523
(8)	DESCRIBE `cruises`	0.0037918090820312
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75798')	0.00050711631774902
(10)	DESCRIBE `cruises`	0.0036389827728271
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66504')	0.00047397613525391
(12)	DESCRIBE `cruises`	0.0047140121459961
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71124')	0.0005030632019043
(14)	DESCRIBE `cruises`	0.0051000118255615
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '29614')	0.0025138854980469
(16)	DESCRIBE `cruises`	0.004382848739624
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75801')	0.0013430118560791
(18)	DESCRIBE `cruises`	0.0044088363647461
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57630')	0.00047898292541504
(20)	DESCRIBE `cruises`	0.0043370723724365
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75803')	0.00054502487182617
(22)	DESCRIBE `cruises`	0.0039989948272705
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47910')	0.00048995018005371
(24)	DESCRIBE `cruises`	0.0035679340362549
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47911')	0.00042080879211426
(26)	DESCRIBE `cruises`	0.0051510334014893
(27)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (29613, 75798, 66504, 71124, 29614, 75801, 57630, 75803, 47910, 47911)) ORDER BY FIND_IN_SET(id, '29613,75798,66504,71124,29614,75801,57630,75803,47910,47911')	0.0019681453704834
(28)	DESCRIBE `ships`	0.0057110786437988
(29)	SELECT `ships`.* FROM `ships` WHERE (id IN ('1373', '1724', '1853', '1486', '639', '852', '851', '467', '954', '1632', '1601', '1301')) ORDER BY FIND_IN_SET(id, '1373,1724,1853,1486,639,852,851,467,954,1632,1601,1301')	0.0024318695068359
(30)	DESCRIBE `cruisetypes`	0.0038528442382812
(31)	DESCRIBE `destinations`	0.0030949115753174
(32)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34', '32', '2', '11')) ORDER BY FIND_IN_SET(id, '39,34,32,2,11')	0.0012938976287842
(33)	DESCRIBE `cruiselines`	0.0031008720397949
(34)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103)))	0.0004889965057373
(35)	DESCRIBE `cruiselines`	0.0031650066375732
(36)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103)))	0.00079703330993652

Query

Time

(1)

connect

0.0010430812835693

(2)

DESCRIBE `cruiselines`

0.0035691261291504

(3)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'american-cruise-lines') AND (orchid_available = 1) LIMIT 1

0.0011420249938965

(4)

DESCRIBE `cruises`

0.0041358470916748

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (29613, 75798, 66504, 71124, 29614, 75801, 57630, 75803, 47910, 47911)) ORDER BY FIND_IN_SET(id, '29613,75798,66504,71124,29614,75801,57630,75803,47910,47911')

0.001835823059082

(6)

DESCRIBE `cruises`

0.0036211013793945

(7)

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

0.00052404403686523

(8)

DESCRIBE `cruises`

0.0037918090820312

(9)

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

0.00050711631774902

(10)

DESCRIBE `cruises`

0.0036389827728271

(11)

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

0.00047397613525391

(12)

DESCRIBE `cruises`

0.0047140121459961

(13)

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

0.0005030632019043

(14)

DESCRIBE `cruises`

0.0051000118255615

(15)

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

0.0025138854980469

(16)

DESCRIBE `cruises`

0.004382848739624

(17)

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

0.0013430118560791

(18)

DESCRIBE `cruises`

0.0044088363647461

(19)

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

0.00047898292541504

(20)

DESCRIBE `cruises`

0.0043370723724365

(21)

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

0.00054502487182617

(22)

DESCRIBE `cruises`

0.0039989948272705

(23)

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

0.00048995018005371

(24)

DESCRIBE `cruises`

0.0035679340362549

(25)

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

0.00042080879211426

(26)

DESCRIBE `cruises`

0.0051510334014893

(27)

0.0019681453704834

(28)

DESCRIBE `ships`

0.0057110786437988

(29)

SELECT `ships`.* FROM `ships` WHERE (id IN ('1373', '1724', '1853', '1486', '639', '852', '851', '467', '954', '1632', '1601', '1301')) ORDER BY FIND_IN_SET(id, '1373,1724,1853,1486,639,852,851,467,954,1632,1601,1301')

0.0024318695068359

(30)

DESCRIBE `cruisetypes`

0.0038528442382812

(31)

DESCRIBE `destinations`

0.0030949115753174

(32)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34', '32', '2', '11')) ORDER BY FIND_IN_SET(id, '39,34,32,2,11')

0.0012938976287842

(33)

DESCRIBE `cruiselines`

0.0031008720397949

(34)

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

0.0004889965057373

(35)

DESCRIBE `cruiselines`

0.0031650066375732

(36)

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

0.00079703330993652

Find Your Cruise

Upcoming Sailings

Database Profiling Report