or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 310

Total elapsed time: 0.42427206039429

# Query Time
(1) connect 0.0012738704681396
(2) DESCRIBE `cruises` 0.0048320293426514
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45258, 45260, 45259)) ORDER BY FIND_IN_SET(id, '45258,45260,45259') 0.0021669864654541
(4) DESCRIBE `specials` 0.0063059329986572
(5) DESCRIBE `specials` 0.0053579807281494
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1610802') 0.0004730224609375
(7) DESCRIBE `ships` 0.0041539669036865
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00056314468383789
(9) DESCRIBE `ships` 0.0038008689880371
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00046610832214355
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037884712219238
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034499168395996
(13) DESCRIBE `itineraries` 0.0018260478973389
(14) DESCRIBE `ports` 0.0019090175628662
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004730224609375
(16) DESCRIBE `ports` 0.0018129348754883
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004429817199707
(18) DESCRIBE `ports` 0.0018401145935059
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00046586990356445
(20) DESCRIBE `specialsailingdates` 0.0016648769378662
(21) DESCRIBE `sailingdates` 0.00164794921875
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504422))) 0.00040507316589355
(23) DESCRIBE `sailingdates` 0.0017650127410889
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504423))) 0.00035500526428223
(25) DESCRIBE `sailingdates` 0.0015690326690674
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504424))) 0.00038814544677734
(27) DESCRIBE `sailingdates` 0.0016021728515625
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504425))) 0.00042414665222168
(29) DESCRIBE `sailingdates` 0.0016789436340332
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504426))) 0.00036215782165527
(31) DESCRIBE `sailingdates` 0.0015251636505127
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504427))) 0.00035691261291504
(33) DESCRIBE `sailingdates` 0.0015320777893066
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504428))) 0.00039386749267578
(35) DESCRIBE `sailingdates` 0.0019159317016602
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504429))) 0.00037503242492676
(37) DESCRIBE `sailingdates` 0.0017869472503662
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504430))) 0.00041604042053223
(39) DESCRIBE `sailingdates` 0.0019681453704834
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504431))) 0.00047898292541504
(41) DESCRIBE `sailingdates` 0.0020430088043213
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504432))) 0.00046396255493164
(43) DESCRIBE `sailingdates` 0.0017898082733154
(44) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504433))) 0.00039505958557129
(45) DESCRIBE `sailingdates` 0.0015850067138672
(46) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504434))) 0.00035381317138672
(47) DESCRIBE `sailingdates` 0.0015559196472168
(48) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504435))) 0.0003669261932373
(49) DESCRIBE `sailingdates` 0.0015249252319336
(50) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504436))) 0.00035500526428223
(51) DESCRIBE `sailingdates` 0.0018529891967773
(52) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504437))) 0.00035691261291504
(53) DESCRIBE `sailingdates` 0.0016059875488281
(54) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504438))) 0.00038409233093262
(55) DESCRIBE `sailingdates` 0.0015769004821777
(56) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504439))) 0.00035214424133301
(57) DESCRIBE `sailingdates` 0.002094030380249
(58) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504440))) 0.00041604042053223
(59) DESCRIBE `sailingdates` 0.0016970634460449
(60) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504441))) 0.00042605400085449
(61) DESCRIBE `sailingdates` 0.0021171569824219
(62) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504442))) 0.00037693977355957
(63) DESCRIBE `sailingdates` 0.0016989707946777
(64) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504443))) 0.00049304962158203
(65) DESCRIBE `sailingdates` 0.0017280578613281
(66) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504444))) 0.00036406517028809
(67) DESCRIBE `ports` 0.0018088817596436
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00043702125549316
(69) DESCRIBE `ports` 0.0018739700317383
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00047492980957031
(71) DESCRIBE `ports` 0.0018699169158936
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00038790702819824
(73) DESCRIBE `ports` 0.0017268657684326
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00035285949707031
(75) DESCRIBE `ports` 0.00193190574646
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00041317939758301
(77) DESCRIBE `ports` 0.0018858909606934
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00037193298339844
(79) DESCRIBE `ports` 0.001737117767334
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00048518180847168
(81) DESCRIBE `ports` 0.0018739700317383
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00037693977355957
(83) DESCRIBE `ports` 0.0018460750579834
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00041985511779785
(85) DESCRIBE `ports` 0.0019001960754395
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00037193298339844
(87) DESCRIBE `ports` 0.001823902130127
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0004270076751709
(89) DESCRIBE `ports` 0.0017268657684326
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00036907196044922
(91) DESCRIBE `ports` 0.0019409656524658
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00045299530029297
(93) DESCRIBE `ports` 0.0018949508666992
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.0004570484161377
(95) DESCRIBE `ports` 0.0017440319061279
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00040698051452637
(97) DESCRIBE `ports` 0.0018370151519775
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00036907196044922
(99) DESCRIBE `ports` 0.0018789768218994
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00041103363037109
(101) DESCRIBE `ports` 0.0017781257629395
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0005800724029541
(103) DESCRIBE `cruises` 0.0033700466156006
(104) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45258))) 0.00050497055053711
(105) DESCRIBE `avid_specials` 0.0017790794372559
(106) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1610802 and class = 'Special') OR (item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012640953063965
(107) DESCRIBE `cruiselines` 0.0037591457366943
(108) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00067520141601562
(109) DESCRIBE `orchid_image` 0.0022659301757812
(110) DESCRIBE `cruiselines` 0.0026528835296631
(111) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00041294097900391
(112) DESCRIBE `specials` 0.0050299167633057
(113) DESCRIBE `specials` 0.0052700042724609
(114) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1610776') 0.0004580020904541
(115) DESCRIBE `ships` 0.0038151741027832
(116) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00060296058654785
(117) DESCRIBE `ships` 0.0036110877990723
(118) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.0004580020904541
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036382675170898
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00043010711669922
(121) DESCRIBE `itineraries` 0.0020630359649658
(122) DESCRIBE `ports` 0.0022680759429932
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045990943908691
(124) DESCRIBE `ports` 0.0019960403442383
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00048303604125977
(126) DESCRIBE `ports` 0.0019140243530273
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00039196014404297
(128) DESCRIBE `specialsailingdates` 0.0016989707946777
(129) DESCRIBE `sailingdates` 0.0019919872283936
(130) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504254))) 0.00052404403686523
(131) DESCRIBE `sailingdates` 0.0021219253540039
(132) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504255))) 0.00052618980407715
(133) DESCRIBE `sailingdates` 0.0017080307006836
(134) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504256))) 0.00041794776916504
(135) DESCRIBE `sailingdates` 0.0016770362854004
(136) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504257))) 0.00037980079650879
(137) DESCRIBE `sailingdates` 0.0018861293792725
(138) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504258))) 0.00038599967956543
(139) DESCRIBE `sailingdates` 0.0016598701477051
(140) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504259))) 0.0021021366119385
(141) DESCRIBE `sailingdates` 0.0018949508666992
(142) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504260))) 0.00039792060852051
(143) DESCRIBE `sailingdates` 0.0021390914916992
(144) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504261))) 0.00037884712219238
(145) DESCRIBE `sailingdates` 0.0022001266479492
(146) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504262))) 0.00040483474731445
(147) DESCRIBE `sailingdates` 0.002039909362793
(148) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504263))) 0.00037503242492676
(149) DESCRIBE `sailingdates` 0.0023698806762695
(150) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504264))) 0.00051593780517578
(151) DESCRIBE `sailingdates` 0.0019381046295166
(152) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504265))) 0.0005338191986084
(153) DESCRIBE `sailingdates` 0.0018930435180664
(154) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504266))) 0.0003972053527832
(155) DESCRIBE `sailingdates` 0.0017120838165283
(156) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504267))) 0.00059604644775391
(157) DESCRIBE `sailingdates` 0.0024158954620361
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504268))) 0.0005500316619873
(159) DESCRIBE `sailingdates` 0.0024709701538086
(160) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504269))) 0.00042390823364258
(161) DESCRIBE `sailingdates` 0.0019979476928711
(162) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504270))) 0.00053811073303223
(163) DESCRIBE `sailingdates` 0.0019738674163818
(164) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504271))) 0.00038814544677734
(165) DESCRIBE `sailingdates` 0.0015711784362793
(166) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504272))) 0.0004420280456543
(167) DESCRIBE `sailingdates` 0.0020298957824707
(168) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504273))) 0.00052499771118164
(169) DESCRIBE `sailingdates` 0.00205397605896
(170) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504274))) 0.00041604042053223
(171) DESCRIBE `sailingdates` 0.001629114151001
(172) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504275))) 0.00038599967956543
(173) DESCRIBE `sailingdates` 0.0017619132995605
(174) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504276))) 0.00041508674621582
(175) DESCRIBE `ports` 0.0022201538085938
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00071406364440918
(177) DESCRIBE `ports` 0.0022661685943604
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00046706199645996
(179) DESCRIBE `ports` 0.0019690990447998
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00054287910461426
(181) DESCRIBE `ports` 0.0018751621246338
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00046801567077637
(183) DESCRIBE `ports` 0.0019690990447998
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00041794776916504
(185) DESCRIBE `ports` 0.0018758773803711
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00039792060852051
(187) DESCRIBE `ports` 0.0018010139465332
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00043320655822754
(189) DESCRIBE `ports` 0.0018558502197266
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038599967956543
(191) DESCRIBE `ports` 0.0018479824066162
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00048613548278809
(193) DESCRIBE `ports` 0.0019161701202393
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00040197372436523
(195) DESCRIBE `ports` 0.0020527839660645
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004570484161377
(197) DESCRIBE `ports` 0.0020549297332764
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00038313865661621
(199) DESCRIBE `cruises` 0.0034019947052002
(200) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45260))) 0.00049901008605957
(201) DESCRIBE `avid_specials` 0.0016570091247559
(202) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1610776 and class = 'Special') OR (item_id = 45260 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017490386962891
(203) DESCRIBE `cruiselines` 0.0035910606384277
(204) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0005638599395752
(205) DESCRIBE `orchid_image` 0.0020129680633545
(206) DESCRIBE `cruiselines` 0.0026631355285645
(207) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00049090385437012
(208) DESCRIBE `specials` 0.0061769485473633
(209) DESCRIBE `specials` 0.0056130886077881
(210) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1610789') 0.00046205520629883
(211) DESCRIBE `ships` 0.0035021305084229
(212) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00057792663574219
(213) DESCRIBE `ships` 0.0038020610809326
(214) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00056099891662598
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039911270141602
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034999847412109
(217) DESCRIBE `itineraries` 0.0019850730895996
(218) DESCRIBE `ports` 0.0019240379333496
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045299530029297
(220) DESCRIBE `ports` 0.0018579959869385
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004279613494873
(222) DESCRIBE `ports` 0.0018241405487061
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00050902366638184
(224) DESCRIBE `specialsailingdates` 0.0014729499816895
(225) DESCRIBE `sailingdates` 0.0017449855804443
(226) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504338))) 0.00046396255493164
(227) DESCRIBE `sailingdates` 0.0015630722045898
(228) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504340))) 0.0004279613494873
(229) DESCRIBE `sailingdates` 0.0018081665039062
(230) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504341))) 0.00040197372436523
(231) DESCRIBE `sailingdates` 0.0016860961914062
(232) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504342))) 0.00039196014404297
(233) DESCRIBE `sailingdates` 0.0017869472503662
(234) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504343))) 0.00040102005004883
(235) DESCRIBE `sailingdates` 0.0017800331115723
(236) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504344))) 0.0004570484161377
(237) DESCRIBE `sailingdates` 0.0021061897277832
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504345))) 0.00041317939758301
(239) DESCRIBE `sailingdates` 0.0018661022186279
(240) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504346))) 0.00038599967956543
(241) DESCRIBE `sailingdates` 0.0016109943389893
(242) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504347))) 0.00037503242492676
(243) DESCRIBE `sailingdates` 0.0015499591827393
(244) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504348))) 0.00036382675170898
(245) DESCRIBE `sailingdates` 0.0016520023345947
(246) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504349))) 0.00036311149597168
(247) DESCRIBE `sailingdates` 0.0017108917236328
(248) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504350))) 0.00039911270141602
(249) DESCRIBE `sailingdates` 0.0015649795532227
(250) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504351))) 0.00042295455932617
(251) DESCRIBE `sailingdates` 0.0015687942504883
(252) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504352))) 0.0003669261932373
(253) DESCRIBE `sailingdates` 0.0019252300262451
(254) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504353))) 0.00037884712219238
(255) DESCRIBE `sailingdates` 0.0023350715637207
(256) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504354))) 0.00039100646972656
(257) DESCRIBE `sailingdates` 0.0017330646514893
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504355))) 0.00045394897460938
(259) DESCRIBE `sailingdates` 0.0016329288482666
(260) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504356))) 0.00041294097900391
(261) DESCRIBE `sailingdates` 0.001708984375
(262) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504357))) 0.00039100646972656
(263) DESCRIBE `sailingdates` 0.0017471313476562
(264) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504358))) 0.00044608116149902
(265) DESCRIBE `sailingdates` 0.0018038749694824
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504359))) 0.00051522254943848
(267) DESCRIBE `sailingdates` 0.0021641254425049
(268) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504360))) 0.00042414665222168
(269) DESCRIBE `ports` 0.0019469261169434
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00050997734069824
(271) DESCRIBE `ports` 0.0018229484558105
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0003969669342041
(273) DESCRIBE `ports` 0.0018038749694824
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00060391426086426
(275) DESCRIBE `ports` 0.0018877983093262
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00039410591125488
(277) DESCRIBE `ports` 0.0018651485443115
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044393539428711
(279) DESCRIBE `ports` 0.001910924911499
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00048494338989258
(281) DESCRIBE `ports` 0.0018508434295654
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00060081481933594
(283) DESCRIBE `ports` 0.0017828941345215
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00049996376037598
(285) DESCRIBE `ports` 0.0021059513092041
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00045514106750488
(287) DESCRIBE `ports` 0.0017850399017334
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00040102005004883
(289) DESCRIBE `ports` 0.0026910305023193
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00053191184997559
(291) DESCRIBE `ports` 0.0018990039825439
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00051498413085938
(293) DESCRIBE `cruises` 0.0043160915374756
(294) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00072598457336426
(295) DESCRIBE `avid_specials` 0.0018148422241211
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1610789 and class = 'Special') OR (item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013079643249512
(297) DESCRIBE `cruiselines` 0.0028009414672852
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00046205520629883
(299) DESCRIBE `orchid_image` 0.002432107925415
(300) DESCRIBE `cruiselines` 0.0031530857086182
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00041794776916504
(302) DESCRIBE `ships` 0.0044031143188477
(303) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.00065207481384277
(304) DESCRIBE `cruisetypes` 0.0017099380493164
(305) DESCRIBE `destinations` 0.002532958984375
(306) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.00051188468933105
(307) DESCRIBE `cruiselines` 0.0025458335876465
(308) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00044393539428711
(309) DESCRIBE `cruiselines` 0.0030829906463623
(310) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0006108283996582