Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
27 December 2018	17	Roald Amundsen, Antarctica Falklands & Chilean Fjords ex Santiago Return
3 January 2019	128	Viking Sun, World Cruise 2019 ex Miami to London (Greenwich)
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
5 January 2019	14	Sun, South America Westbound ex Buenos Aires to San Antonio
6 January 2019	14	Eclipse, Chile & Argentina ex San Antonio to Buenos Aires
8 January 2019	22	Zaandam, South America & Antarctica Holiday ex Buenos Aires to San Antonio
12 January 2019	19	Roald Amundsen, Antarctica Polar Circle & Beyond ex Santiago Return
13 January 2019	21	Quest, Ultimate Antarctica & Patagonia ex San Antonio to Buenos Aires
19 January 2019	14	Sun, South America Eastbound ex San Antonio to Buenos Aires

Page Navigation: 1 2 3 4 5 6 Next »

Items 1 - 10 of 53

#	Query	Time
(1)	connect	0.00092792510986328
(2)	DESCRIBE `ports`	0.0017681121826172
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'straits-of-magellan-chile') AND (orchid_available = 1) LIMIT 1	0.0095169544219971
(4)	DESCRIBE `cruises`	0.0030200481414795
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (69671, 71855, 71113, 71140, 66245, 66851, 63704, 69670, 72175, 66950)) ORDER BY FIND_IN_SET(id, '69671,71855,71113,71140,66245,66851,63704,69670,72175,66950')	0.0017569065093994
(6)	DESCRIBE `cruises`	0.0030510425567627
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69671')	0.00038909912109375
(8)	DESCRIBE `cruises`	0.002741813659668
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71855')	0.00040602684020996
(10)	DESCRIBE `cruises`	0.0025579929351807
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71113')	0.00036501884460449
(12)	DESCRIBE `cruises`	0.0025510787963867
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71140')	0.00036787986755371
(14)	DESCRIBE `cruises`	0.0030601024627686
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66245')	0.00035810470581055
(16)	DESCRIBE `cruises`	0.0027031898498535
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66851')	0.00030398368835449
(18)	DESCRIBE `cruises`	0.0025079250335693
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63704')	0.00027608871459961
(20)	DESCRIBE `cruises`	0.0024681091308594
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69670')	0.00031781196594238
(22)	DESCRIBE `cruises`	0.0025629997253418
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72175')	0.00040507316589355
(24)	DESCRIBE `cruises`	0.00313401222229
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66950')	0.00040602684020996
(26)	DESCRIBE `cruisetypes`	0.0013799667358398
(27)	DESCRIBE `destinations`	0.002302885055542
(28)	DESCRIBE `cruiselines`	0.0025100708007812
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.0004119873046875
(30)	DESCRIBE `ships`	0.0034418106079102
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00051498413085938
(32)	DESCRIBE `cruiselines`	0.0028648376464844
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00056099891662598
(34)	DESCRIBE `ships`	0.0033199787139893
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00049805641174316
(36)	DESCRIBE `ports`	0.0014059543609619
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495)))	0.00034785270690918

Query

Time

(1)

connect

0.00092792510986328

(2)

DESCRIBE `ports`

0.0017681121826172

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'straits-of-magellan-chile') AND (orchid_available = 1) LIMIT 1

0.0095169544219971

(4)

DESCRIBE `cruises`

0.0030200481414795

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (69671, 71855, 71113, 71140, 66245, 66851, 63704, 69670, 72175, 66950)) ORDER BY FIND_IN_SET(id, '69671,71855,71113,71140,66245,66851,63704,69670,72175,66950')

0.0017569065093994

(6)

DESCRIBE `cruises`

0.0030510425567627

(7)

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

0.00038909912109375

(8)

DESCRIBE `cruises`

0.002741813659668

(9)

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

0.00040602684020996

(10)

DESCRIBE `cruises`

0.0025579929351807

(11)

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

0.00036501884460449

(12)

DESCRIBE `cruises`

0.0025510787963867

(13)

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

0.00036787986755371

(14)

DESCRIBE `cruises`

0.0030601024627686

(15)

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

0.00035810470581055

(16)

DESCRIBE `cruises`

0.0027031898498535

(17)

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

0.00030398368835449

(18)

DESCRIBE `cruises`

0.0025079250335693

(19)

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

0.00027608871459961

(20)

DESCRIBE `cruises`

0.0024681091308594

(21)

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

0.00031781196594238

(22)

DESCRIBE `cruises`

0.0025629997253418

(23)

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

0.00040507316589355

(24)

DESCRIBE `cruises`

0.00313401222229

(25)

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

0.00040602684020996

(26)

DESCRIBE `cruisetypes`

0.0013799667358398

(27)

DESCRIBE `destinations`

0.002302885055542

(28)

DESCRIBE `cruiselines`

0.0025100708007812

(29)

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

0.0004119873046875

(30)

DESCRIBE `ships`

0.0034418106079102

(31)

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

0.00051498413085938

(32)

DESCRIBE `cruiselines`

0.0028648376464844

(33)

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

0.00056099891662598

(34)

DESCRIBE `ships`

0.0033199787139893

(35)

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

0.00049805641174316

(36)

DESCRIBE `ports`

0.0014059543609619

(37)

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

0.00034785270690918

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report