Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
3 January 2019	128	Viking Sun, World Cruise 2019 ex Miami to London (Greenwich)
3 January 2019	18	Marina, Pacific Serenade ex Valparaiso to Papeete
6 January 2019	70	Marco Polo, Grand Circle South America ex Bristol Return
6 January 2019	19	Europa, Expedition Across Pacific ex Valparaiso to Papeete
20 January 2019	28	Explorer, South American Sojourn ex Rio de Janeiro to Valparaiso
25 January 2019	18	Viking Sun, South America & Cape Horn ex Buenos Aires to Valparaiso
1 February 2019	36	Explorer, Radiant Discoveries ex Buenos Aires to Los Angeles
1 February 2019	16	Explorer, Islands & Fjords of South America ex Bueons Aires to Valparaiso
3 February 2019	16	Symphony, Tierra Del Fuego Passage ex Buenos Aires to Valparaiso
11 February 2019	33	Sirena, Mystical Patagonia ex Rio de Janeiro to Lima

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

Items 1 - 10 of 71

#	Query	Time
(1)	connect	0.0015099048614502
(2)	DESCRIBE `ports`	0.0022788047790527
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'valparaiso-santiago-chile') AND (orchid_available = 1) LIMIT 1	0.0036120414733887
(4)	DESCRIBE `cruises`	0.0044031143188477
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (71855, 69137, 71896, 73820, 67610, 78028, 67612, 67611, 67578, 69125)) ORDER BY FIND_IN_SET(id, '71855,69137,71896,73820,67610,78028,67612,67611,67578,69125')	0.0018930435180664
(6)	DESCRIBE `cruises`	0.0046699047088623
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71855')	0.00057101249694824
(8)	DESCRIBE `cruises`	0.0039710998535156
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69137')	0.00048184394836426
(10)	DESCRIBE `cruises`	0.003525972366333
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71896')	0.0004730224609375
(12)	DESCRIBE `cruises`	0.0033020973205566
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73820')	0.0004730224609375
(14)	DESCRIBE `cruises`	0.0036990642547607
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67610')	0.00097799301147461
(16)	DESCRIBE `cruises`	0.0040810108184814
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78028')	0.00066018104553223
(18)	DESCRIBE `cruises`	0.0032031536102295
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67612')	0.00055599212646484
(20)	DESCRIBE `cruises`	0.0036859512329102
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67611')	0.0004880428314209
(22)	DESCRIBE `cruises`	0.0035631656646729
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67578')	0.00097393989562988
(24)	DESCRIBE `cruises`	0.0034661293029785
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69125')	0.00049400329589844
(26)	DESCRIBE `cruisetypes`	0.0016460418701172
(27)	DESCRIBE `destinations`	0.0023870468139648
(28)	DESCRIBE `cruiselines`	0.0027041435241699
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00054097175598145
(30)	DESCRIBE `ships`	0.0035059452056885
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00057697296142578
(32)	DESCRIBE `cruiselines`	0.0030229091644287
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00053286552429199
(34)	DESCRIBE `ships`	0.0031261444091797
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.0005180835723877
(36)	DESCRIBE `ports`	0.0014898777008057
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324)))	0.00033283233642578

Query

Time

(1)

connect

0.0015099048614502

(2)

DESCRIBE `ports`

0.0022788047790527

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'valparaiso-santiago-chile') AND (orchid_available = 1) LIMIT 1

0.0036120414733887

(4)

DESCRIBE `cruises`

0.0044031143188477

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (71855, 69137, 71896, 73820, 67610, 78028, 67612, 67611, 67578, 69125)) ORDER BY FIND_IN_SET(id, '71855,69137,71896,73820,67610,78028,67612,67611,67578,69125')

0.0018930435180664

(6)

DESCRIBE `cruises`

0.0046699047088623

(7)

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

0.00057101249694824

(8)

DESCRIBE `cruises`

0.0039710998535156

(9)

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

0.00048184394836426

(10)

DESCRIBE `cruises`

0.003525972366333

(11)

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

0.0004730224609375

(12)

DESCRIBE `cruises`

0.0033020973205566

(13)

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

0.0004730224609375

(14)

DESCRIBE `cruises`

0.0036990642547607

(15)

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

0.00097799301147461

(16)

DESCRIBE `cruises`

0.0040810108184814

(17)

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

0.00066018104553223

(18)

DESCRIBE `cruises`

0.0032031536102295

(19)

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

0.00055599212646484

(20)

DESCRIBE `cruises`

0.0036859512329102

(21)

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

0.0004880428314209

(22)

DESCRIBE `cruises`

0.0035631656646729

(23)

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

0.00097393989562988

(24)

DESCRIBE `cruises`

0.0034661293029785

(25)

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

0.00049400329589844

(26)

DESCRIBE `cruisetypes`

0.0016460418701172

(27)

DESCRIBE `destinations`

0.0023870468139648

(28)

DESCRIBE `cruiselines`

0.0027041435241699

(29)

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

0.00054097175598145

(30)

DESCRIBE `ships`

0.0035059452056885

(31)

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

0.00057697296142578

(32)

DESCRIBE `cruiselines`

0.0030229091644287

(33)

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

0.00053286552429199

(34)

DESCRIBE `ships`

0.0031261444091797

(35)

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

0.0005180835723877

(36)

DESCRIBE `ports`

0.0014898777008057

(37)

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

0.00033283233642578

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report