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	22	Viking Sun, From Miami to South America ex Miami to Buenos Aires
24 February 2019	66	Quest, Antarctica, Amazon & Atlantic ex San Antonio to Lisbon
24 February 2019	42	Quest, Antarctica & Amazon Exploration ex San Antonio to Manaus
17 March 2019	45	Quest, Route of the Explorers ex Buenos Aires to Lisbon
17 March 2019	21	Quest, Beauties of Brazil ex Buenos Aires to Manaus
5 January 2020	77	Volendam, Grand South America & Antarctica ex Ft Lauderdale Return
9 January 2020	58	Island, Circle South America ex Ft Lauderdale Return
3 February 2020	33	Island, Cape Horn & Brazilian Grand Adventure ex San Antonio to Ft Lauderdale
15 February 2020	36	Volendam, Grand South America & Antarctica ex Buenos Aires to Ft Lauderdale

Page Navigation: 1 2 Next »

Items 1 - 10 of 16

#	Query	Time
(1)	connect	0.00091290473937988
(2)	DESCRIBE `ports`	0.0021359920501709
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'armacao-dos-buzio-brazil') AND (orchid_available = 1) LIMIT 1	0.027029037475586
(4)	DESCRIBE `cruises`	0.0040199756622314
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (71855, 78027, 72199, 72203, 72210, 72206, 79302, 76878, 76979, 79304)) ORDER BY FIND_IN_SET(id, '71855,78027,72199,72203,72210,72206,79302,76878,76979,79304')	0.0018939971923828
(6)	DESCRIBE `cruises`	0.0034890174865723
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71855')	0.00026512145996094
(8)	DESCRIBE `cruises`	0.0032989978790283
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78027')	0.00041007995605469
(10)	DESCRIBE `cruises`	0.0030679702758789
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72199')	0.00040197372436523
(12)	DESCRIBE `cruises`	0.0029568672180176
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72203')	0.00047802925109863
(14)	DESCRIBE `cruises`	0.0033230781555176
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72210')	0.00049400329589844
(16)	DESCRIBE `cruises`	0.003371000289917
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72206')	0.00046706199645996
(18)	DESCRIBE `cruises`	0.0033299922943115
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79302')	0.0005030632019043
(20)	DESCRIBE `cruises`	0.0034689903259277
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76878')	0.00047492980957031
(22)	DESCRIBE `cruises`	0.0032739639282227
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76979')	0.00064396858215332
(24)	DESCRIBE `cruises`	0.0031790733337402
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79304')	0.00044083595275879
(26)	DESCRIBE `cruisetypes`	0.0016520023345947
(27)	DESCRIBE `destinations`	0.0024149417877197
(28)	DESCRIBE `cruiselines`	0.0028440952301025
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00044512748718262
(30)	DESCRIBE `ships`	0.0026309490203857
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00035619735717773
(32)	DESCRIBE `cruiselines`	0.0020480155944824
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00036501884460449
(34)	DESCRIBE `ships`	0.0026130676269531
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.0006709098815918
(36)	DESCRIBE `ports`	0.0014040470123291
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3959)))	0.00028395652770996

Query

Time

(1)

connect

0.00091290473937988

(2)

DESCRIBE `ports`

0.0021359920501709

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'armacao-dos-buzio-brazil') AND (orchid_available = 1) LIMIT 1

0.027029037475586

(4)

DESCRIBE `cruises`

0.0040199756622314

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (71855, 78027, 72199, 72203, 72210, 72206, 79302, 76878, 76979, 79304)) ORDER BY FIND_IN_SET(id, '71855,78027,72199,72203,72210,72206,79302,76878,76979,79304')

0.0018939971923828

(6)

DESCRIBE `cruises`

0.0034890174865723

(7)

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

0.00026512145996094

(8)

DESCRIBE `cruises`

0.0032989978790283

(9)

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

0.00041007995605469

(10)

DESCRIBE `cruises`

0.0030679702758789

(11)

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

0.00040197372436523

(12)

DESCRIBE `cruises`

0.0029568672180176

(13)

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

0.00047802925109863

(14)

DESCRIBE `cruises`

0.0033230781555176

(15)

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

0.00049400329589844

(16)

DESCRIBE `cruises`

0.003371000289917

(17)

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

0.00046706199645996

(18)

DESCRIBE `cruises`

0.0033299922943115

(19)

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

0.0005030632019043

(20)

DESCRIBE `cruises`

0.0034689903259277

(21)

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

0.00047492980957031

(22)

DESCRIBE `cruises`

0.0032739639282227

(23)

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

0.00064396858215332

(24)

DESCRIBE `cruises`

0.0031790733337402

(25)

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

0.00044083595275879

(26)

DESCRIBE `cruisetypes`

0.0016520023345947

(27)

DESCRIBE `destinations`

0.0024149417877197

(28)

DESCRIBE `cruiselines`

0.0028440952301025

(29)

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

0.00044512748718262

(30)

DESCRIBE `ships`

0.0026309490203857

(31)

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

0.00035619735717773

(32)

DESCRIBE `cruiselines`

0.0020480155944824

(33)

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

0.00036501884460449

(34)

DESCRIBE `ships`

0.0026130676269531

(35)

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

0.0006709098815918

(36)

DESCRIBE `ports`

0.0014040470123291

(37)

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

0.00028395652770996

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report