Your 'Cruise Ship' has been chosenClear this filter or visit another page to change

Affinity

Discover the wonders of these areas aboard our comfy vessel where we offer you a personalised nautical experience in a relaxed atmosphere that you only get with ‘Smaller Ship Cruising’.

Enquire about this cruise ship »

#	Query	Time
(1)	connect	0.0010571479797363
(2)	DESCRIBE `ships`	0.0047681331634521
(3)	SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'affinity') LIMIT 1	0.0067059993743896
(4)	DESCRIBE `avid_specials`	0.0028479099273682
(5)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 568 AND class = 'Ship') OR (item_id = 134 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))	0.0013918876647949
(6)	DESCRIBE `cruiselines`	0.0030150413513184
(7)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 134)))	0.00052905082702637
(8)	DESCRIBE `orchid_image`	0.0021209716796875
(9)	DESCRIBE `cruiselines`	0.0026099681854248
(10)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '134')	0.0004119873046875
(11)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '568')	0.00042891502380371
(12)	DESCRIBE `deckplans`	0.002047061920166
(13)	DESCRIBE `cabins`	0.0019750595092773
(14)	DESCRIBE `shipphotos`	0.0024669170379639
(15)	DESCRIBE `cruisetypes`	0.0018389225006104
(16)	DESCRIBE `destinations`	0.0034019947052002
(17)	DESCRIBE `cruiselines`	0.0042109489440918
(18)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))	0.00057506561279297
(19)	DESCRIBE `ships`	0.0038490295410156
(20)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 568)))	0.00051712989807129
(21)	DESCRIBE `cruiselines`	0.0037140846252441
(22)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))	0.00060009956359863
(23)	DESCRIBE `ships`	0.0039248466491699
(24)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 568)))	0.00048303604125977

Query

Time

(1)

connect

0.0010571479797363

(2)

DESCRIBE `ships`

0.0047681331634521

(3)

SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'affinity') LIMIT 1

0.0067059993743896

(4)

DESCRIBE `avid_specials`

0.0028479099273682

(5)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 568 AND class = 'Ship') OR (item_id = 134 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))

0.0013918876647949

(6)

DESCRIBE `cruiselines`

0.0030150413513184

(7)

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

0.00052905082702637

(8)

DESCRIBE `orchid_image`

0.0021209716796875

(9)

DESCRIBE `cruiselines`

0.0026099681854248

(10)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '134')

0.0004119873046875

(11)

SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '568')

0.00042891502380371

(12)

DESCRIBE `deckplans`

0.002047061920166

(13)

DESCRIBE `cabins`

0.0019750595092773

(14)

DESCRIBE `shipphotos`

0.0024669170379639

(15)

DESCRIBE `cruisetypes`

0.0018389225006104

(16)

DESCRIBE `destinations`

0.0034019947052002

(17)

DESCRIBE `cruiselines`

0.0042109489440918

(18)

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

0.00057506561279297

(19)

DESCRIBE `ships`

0.0038490295410156

(20)

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

0.00051712989807129

(21)

DESCRIBE `cruiselines`

0.0037140846252441

(22)

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

0.00060009956359863

(23)

DESCRIBE `ships`

0.0039248466491699

(24)

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

0.00048303604125977

Find Your Cruise

Affinity

Database Profiling Report