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
4 January 2019	80	Prinsendam, Grand South America & Antarctica ex Ft Lauderdale Return
4 January 2019	45	Prinsendam, Grand South America & Antarctica ex Ft Lauderdale to Buenos Aires
6 January 2019	19	Europa, Expedition Across Pacific ex Valparaiso to Papeete
12 February 2019	31	Viking Sun, Islands of the South Pacific ex Santiago to Sydney
7 March 2019	9	Silver Explorer, Voyage 7905 ex Valpariso to Easter Island
16 March 2019	18	Bremen, South & Central America & Panama Canal ex Valparaiso to Colon
5 January 2020	77	Volendam, Grand South America & Antarctica ex Ft Lauderdale Return
5 January 2020	41	Volendam, Grand South America & Antarctica ex Ft Lauderdale to Buenos Aires

Page Navigation: 1 2 Next »

Items 1 - 10 of 14

#	Query	Time
(1)	connect	0.00074195861816406
(2)	DESCRIBE `ports`	0.0018930435180664
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'robinson-crusoe-island-chile') AND (orchid_available = 1) LIMIT 1	0.011763095855713
(4)	DESCRIBE `cruises`	0.0032279491424561
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (71855, 69137, 71113, 71140, 73820, 78125, 71122, 72811, 79302, 79303)) ORDER BY FIND_IN_SET(id, '71855,69137,71113,71140,73820,78125,71122,72811,79302,79303')	0.0032179355621338
(6)	DESCRIBE `cruises`	0.0037820339202881
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71855')	0.00048184394836426
(8)	DESCRIBE `cruises`	0.0034658908843994
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69137')	0.00041294097900391
(10)	DESCRIBE `cruises`	0.0036008358001709
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71113')	0.00047206878662109
(12)	DESCRIBE `cruises`	0.0035851001739502
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71140')	0.00043582916259766
(14)	DESCRIBE `cruises`	0.0035278797149658
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73820')	0.00040578842163086
(16)	DESCRIBE `cruises`	0.0035049915313721
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78125')	0.00063085556030273
(18)	DESCRIBE `cruises`	0.0036091804504395
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71122')	0.00048613548278809
(20)	DESCRIBE `cruises`	0.0038530826568604
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72811')	0.0005040168762207
(22)	DESCRIBE `cruises`	0.0036811828613281
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79302')	0.0004570484161377
(24)	DESCRIBE `cruises`	0.0033230781555176
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79303')	0.00044393539428711
(26)	DESCRIBE `cruisetypes`	0.0015699863433838
(27)	DESCRIBE `destinations`	0.0019149780273438
(28)	DESCRIBE `cruiselines`	0.0019040107727051
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.0003659725189209
(30)	DESCRIBE `ships`	0.0030879974365234
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.0003969669342041
(32)	DESCRIBE `cruiselines`	0.0024240016937256
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.0003809928894043
(34)	DESCRIBE `ships`	0.0031239986419678
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00044417381286621
(36)	DESCRIBE `ports`	0.0014791488647461
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2024)))	0.00034999847412109

Query

Time

(1)

connect

0.00074195861816406

(2)

DESCRIBE `ports`

0.0018930435180664

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'robinson-crusoe-island-chile') AND (orchid_available = 1) LIMIT 1

0.011763095855713

(4)

DESCRIBE `cruises`

0.0032279491424561

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (71855, 69137, 71113, 71140, 73820, 78125, 71122, 72811, 79302, 79303)) ORDER BY FIND_IN_SET(id, '71855,69137,71113,71140,73820,78125,71122,72811,79302,79303')

0.0032179355621338

(6)

DESCRIBE `cruises`

0.0037820339202881

(7)

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

0.00048184394836426

(8)

DESCRIBE `cruises`

0.0034658908843994

(9)

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

0.00041294097900391

(10)

DESCRIBE `cruises`

0.0036008358001709

(11)

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

0.00047206878662109

(12)

DESCRIBE `cruises`

0.0035851001739502

(13)

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

0.00043582916259766

(14)

DESCRIBE `cruises`

0.0035278797149658

(15)

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

0.00040578842163086

(16)

DESCRIBE `cruises`

0.0035049915313721

(17)

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

0.00063085556030273

(18)

DESCRIBE `cruises`

0.0036091804504395

(19)

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

0.00048613548278809

(20)

DESCRIBE `cruises`

0.0038530826568604

(21)

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

0.0005040168762207

(22)

DESCRIBE `cruises`

0.0036811828613281

(23)

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

0.0004570484161377

(24)

DESCRIBE `cruises`

0.0033230781555176

(25)

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

0.00044393539428711

(26)

DESCRIBE `cruisetypes`

0.0015699863433838

(27)

DESCRIBE `destinations`

0.0019149780273438

(28)

DESCRIBE `cruiselines`

0.0019040107727051

(29)

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

0.0003659725189209

(30)

DESCRIBE `ships`

0.0030879974365234

(31)

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

0.0003969669342041

(32)

DESCRIBE `cruiselines`

0.0024240016937256

(33)

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

0.0003809928894043

(34)

DESCRIBE `ships`

0.0031239986419678

(35)

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

0.00044417381286621

(36)

DESCRIBE `ports`

0.0014791488647461

(37)

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

0.00034999847412109

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report