Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
28 December 2018	1	Astor, In Port Celebration ex Perth Return
29 December 2018	4	Astor, New Year Celebration ex Perth Return
2 January 2019	4	Astor, Coastal Adventure ex Perth Return
3 January 2019	128	Viking Sun, World Cruise 2019 ex Miami to London (Greenwich)
3 January 2019	38	QE, Cruise Q902C ex Southampton to Melbourne
3 January 2019	36	QE, Cruise Q902B ex Southampton to Adelaide
3 January 2019	32	QE, Cruise Q902A ex Southampton to Fremantle
4 January 2019	130	Magnifica, 2019 World Cruise ex Rome to Hamburg
4 January 2019	127	Magnifica, 2019 World Cruise ex Rome to Southampton
4 January 2019	118	Magnifica, 2019 World Cruise ex Rome Return

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

Items 1 - 10 of 145

#	Query	Time
(1)	connect	0.00095200538635254
(2)	DESCRIBE `ports`	0.0022609233856201
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'perth-fremantle-western-australia') AND (orchid_available = 1) LIMIT 1	0.00090384483337402
(4)	DESCRIBE `cruises`	0.0035400390625
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (68017, 72473, 72474, 71855, 68771, 68772, 68774, 66227, 66250, 66225)) ORDER BY FIND_IN_SET(id, '68017,72473,72474,71855,68771,68772,68774,66227,66250,66225')	0.0013320446014404
(6)	DESCRIBE `cruises`	0.0028440952301025
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68017')	0.0003659725189209
(8)	DESCRIBE `cruises`	0.0025019645690918
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72473')	0.00027918815612793
(10)	DESCRIBE `cruises`	0.0027718544006348
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72474')	0.00027990341186523
(12)	DESCRIBE `cruises`	0.0029351711273193
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71855')	0.00036501884460449
(14)	DESCRIBE `cruises`	0.0029017925262451
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68771')	0.00031399726867676
(16)	DESCRIBE `cruises`	0.0024118423461914
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68772')	0.00027585029602051
(18)	DESCRIBE `cruises`	0.0025889873504639
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68774')	0.00037908554077148
(20)	DESCRIBE `cruises`	0.0034060478210449
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66227')	0.00040388107299805
(22)	DESCRIBE `cruises`	0.0034689903259277
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66250')	0.00063991546630859
(24)	DESCRIBE `cruises`	0.003432035446167
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66225')	0.00039410591125488
(26)	DESCRIBE `cruisetypes`	0.0018529891967773
(27)	DESCRIBE `destinations`	0.0025730133056641
(28)	DESCRIBE `cruiselines`	0.0018260478973389
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.0007469654083252
(30)	DESCRIBE `ships`	0.0041821002960205
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00068092346191406
(32)	DESCRIBE `cruiselines`	0.0028479099273682
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0
(34)	DESCRIBE `ships`	0.0045099258422852
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00078105926513672
(36)	DESCRIBE `ports`	0.001971960067749
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))	0.0009620189666748

Query

Time

(1)

connect

0.00095200538635254

(2)

DESCRIBE `ports`

0.0022609233856201

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'perth-fremantle-western-australia') AND (orchid_available = 1) LIMIT 1

0.00090384483337402

(4)

DESCRIBE `cruises`

0.0035400390625

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (68017, 72473, 72474, 71855, 68771, 68772, 68774, 66227, 66250, 66225)) ORDER BY FIND_IN_SET(id, '68017,72473,72474,71855,68771,68772,68774,66227,66250,66225')

0.0013320446014404

(6)

DESCRIBE `cruises`

0.0028440952301025

(7)

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

0.0003659725189209

(8)

DESCRIBE `cruises`

0.0025019645690918

(9)

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

0.00027918815612793

(10)

DESCRIBE `cruises`

0.0027718544006348

(11)

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

0.00027990341186523

(12)

DESCRIBE `cruises`

0.0029351711273193

(13)

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

0.00036501884460449

(14)

DESCRIBE `cruises`

0.0029017925262451

(15)

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

0.00031399726867676

(16)

DESCRIBE `cruises`

0.0024118423461914

(17)

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

0.00027585029602051

(18)

DESCRIBE `cruises`

0.0025889873504639

(19)

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

0.00037908554077148

(20)

DESCRIBE `cruises`

0.0034060478210449

(21)

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

0.00040388107299805

(22)

DESCRIBE `cruises`

0.0034689903259277

(23)

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

0.00063991546630859

(24)

DESCRIBE `cruises`

0.003432035446167

(25)

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

0.00039410591125488

(26)

DESCRIBE `cruisetypes`

0.0018529891967773

(27)

DESCRIBE `destinations`

0.0025730133056641

(28)

DESCRIBE `cruiselines`

0.0018260478973389

(29)

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

0.0007469654083252

(30)

DESCRIBE `ships`

0.0041821002960205

(31)

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

0.00068092346191406

(32)

DESCRIBE `cruiselines`

0.0028479099273682

(33)

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

(34)

DESCRIBE `ships`

0.0045099258422852

(35)

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

0.00078105926513672

(36)

DESCRIBE `ports`

0.001971960067749

(37)

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

0.0009620189666748

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report