Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
13 January 2019	11	Spirit, Canary Islands Spain & Morocco ex Barcelona Return
25 December 2018	13	Sinfonia, Italy France Spain Portugal Morocco ex Rome Roundtrip
27 December 2018	12	Sinfonia, Italy France Spain Portugal Morocco ex Genoa Roundtrip
28 December 2018	12	Sinfonia, Italy France Spain Portugal Morocco ex Marseilles Roundtrip
29 December 2018	12	Sinfonia, Italy France Spain Portugal Morocco ex Barcelona Roundtrip
3 January 2019	128	Viking Sun, World Cruise 2019 ex Miami to London (Greenwich)
3 January 2019	10	Spirit, Canary Islands & Morocco ex Barcelona Return
4 January 2019	14	Saga Pearl II, Canary Island Delights ex Portsmouth Return
5 January 2019	112	Luminosa, World Voyage 2019 ex Venice Return
5 January 2019	80	Luminosa, World Voyage 2019 ex Venice to Singapore

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

Items 1 - 10 of 234

#	Query	Time
(1)	connect	0.00092601776123047
(2)	DESCRIBE `ports`	0.0023331642150879
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'santa-cruz-de-tenerife-canary-islands') AND (orchid_available = 1) LIMIT 1	0.0066399574279785
(4)	DESCRIBE `cruises`	0.0032320022583008
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (60524, 72068, 71830, 72069, 72070, 71855, 63431, 73446, 70674, 78933)) ORDER BY FIND_IN_SET(id, '60524,72068,71830,72069,72070,71855,63431,73446,70674,78933')	0.0016450881958008
(6)	DESCRIBE `cruises`	0.0032689571380615
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60524')	0.00049877166748047
(8)	DESCRIBE `cruises`	0.0027289390563965
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72068')	0.00032901763916016
(10)	DESCRIBE `cruises`	0.002802848815918
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71830')	0.00036382675170898
(12)	DESCRIBE `cruises`	0.003493070602417
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72069')	0.00042200088500977
(14)	DESCRIBE `cruises`	0.003593921661377
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72070')	0.00039005279541016
(16)	DESCRIBE `cruises`	0.0026559829711914
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71855')	0.00038504600524902
(18)	DESCRIBE `cruises`	0.0027749538421631
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63431')	0.0003359317779541
(20)	DESCRIBE `cruises`	0.0025579929351807
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73446')	0.00029206275939941
(22)	DESCRIBE `cruises`	0.002439022064209
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70674')	0.00030612945556641
(24)	DESCRIBE `cruises`	0.0027570724487305
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78933')	0.00042200088500977
(26)	DESCRIBE `cruisetypes`	0.0016109943389893
(27)	DESCRIBE `destinations`	0.0020830631256104
(28)	DESCRIBE `cruiselines`	0.002424955368042
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.0010368824005127
(30)	DESCRIBE `ships`	0.0029489994049072
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00045108795166016
(32)	DESCRIBE `cruiselines`	0.002169132232666
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00039410591125488
(34)	DESCRIBE `ships`	0.0035030841827393
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.0005490779876709
(36)	DESCRIBE `ports`	0.0017490386962891
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598)))	0.00037980079650879

Query

Time

(1)

connect

0.00092601776123047

(2)

DESCRIBE `ports`

0.0023331642150879

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'santa-cruz-de-tenerife-canary-islands') AND (orchid_available = 1) LIMIT 1

0.0066399574279785

(4)

DESCRIBE `cruises`

0.0032320022583008

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (60524, 72068, 71830, 72069, 72070, 71855, 63431, 73446, 70674, 78933)) ORDER BY FIND_IN_SET(id, '60524,72068,71830,72069,72070,71855,63431,73446,70674,78933')

0.0016450881958008

(6)

DESCRIBE `cruises`

0.0032689571380615

(7)

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

0.00049877166748047

(8)

DESCRIBE `cruises`

0.0027289390563965

(9)

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

0.00032901763916016

(10)

DESCRIBE `cruises`

0.002802848815918

(11)

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

0.00036382675170898

(12)

DESCRIBE `cruises`

0.003493070602417

(13)

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

0.00042200088500977

(14)

DESCRIBE `cruises`

0.003593921661377

(15)

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

0.00039005279541016

(16)

DESCRIBE `cruises`

0.0026559829711914

(17)

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

0.00038504600524902

(18)

DESCRIBE `cruises`

0.0027749538421631

(19)

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

0.0003359317779541

(20)

DESCRIBE `cruises`

0.0025579929351807

(21)

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

0.00029206275939941

(22)

DESCRIBE `cruises`

0.002439022064209

(23)

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

0.00030612945556641

(24)

DESCRIBE `cruises`

0.0027570724487305

(25)

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

0.00042200088500977

(26)

DESCRIBE `cruisetypes`

0.0016109943389893

(27)

DESCRIBE `destinations`

0.0020830631256104

(28)

DESCRIBE `cruiselines`

0.002424955368042

(29)

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

0.0010368824005127

(30)

DESCRIBE `ships`

0.0029489994049072

(31)

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

0.00045108795166016

(32)

DESCRIBE `cruiselines`

0.002169132232666

(33)

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

0.00039410591125488

(34)

DESCRIBE `ships`

0.0035030841827393

(35)

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

0.0005490779876709

(36)

DESCRIBE `ports`

0.0017490386962891

(37)

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

0.00037980079650879

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report