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: 373

Total elapsed time: 0.53222227096558

# Query Time
(1) connect 0.001237154006958
(2) DESCRIBE `cruises` 0.0040938854217529
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75386, 75429, 75430, 75431, 75431, 81579, 81579, 81583, 81582, 81580)) ORDER BY FIND_IN_SET(id, '75386,75429,75430,75431,75431,81579,81579,81583,81582,81580') 0.0020029544830322
(4) DESCRIBE `specials` 0.0054118633270264
(5) DESCRIBE `specials` 0.0050971508026123
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1622026') 0.00076603889465332
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id != '1622026') 0.007814884185791
(8) UPDATE `specials` SET `orchid_slug` = ? WHERE (id = '1622026') 0.00042986869812012
(9) DESCRIBE `ships` 0.0036978721618652
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00048398971557617
(11) DESCRIBE `ships` 0.0037679672241211
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.0004119873046875
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034689903259277
(15) DESCRIBE `itineraries` 0.0018470287322998
(16) DESCRIBE `ports` 0.0018699169158936
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00043106079101562
(18) DESCRIBE `ports` 0.0018510818481445
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00043916702270508
(20) DESCRIBE `ports` 0.0018620491027832
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00040888786315918
(22) DESCRIBE `specialsailingdates` 0.0015020370483398
(23) DESCRIBE `sailingdates` 0.0018060207366943
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 513463))) 0.00080084800720215
(25) DESCRIBE `ports` 0.0025429725646973
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00084495544433594
(27) DESCRIBE `ports` 0.0028109550476074
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00061511993408203
(29) DESCRIBE `ports` 0.0026612281799316
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00046610832214355
(31) DESCRIBE `ports` 0.0018260478973389
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00039505958557129
(33) DESCRIBE `ports` 0.0018579959869385
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00045418739318848
(35) DESCRIBE `ports` 0.0018138885498047
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00038409233093262
(37) DESCRIBE `ports` 0.0021450519561768
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00047206878662109
(39) DESCRIBE `ports` 0.0019171237945557
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00045204162597656
(41) DESCRIBE `ports` 0.0017411708831787
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00038981437683105
(43) DESCRIBE `ports` 0.001939058303833
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.0006568431854248
(45) DESCRIBE `ports` 0.002795934677124
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00063395500183105
(47) DESCRIBE `ports` 0.0023479461669922
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00045299530029297
(49) DESCRIBE `ports` 0.0018739700317383
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00047183036804199
(51) DESCRIBE `ports` 0.0020020008087158
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.0004119873046875
(53) DESCRIBE `ports` 0.0018069744110107
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1262))) 0.00041985511779785
(55) DESCRIBE `ports` 0.0018079280853271
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1262') 0.00046181678771973
(57) DESCRIBE `ports` 0.0018751621246338
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00041508674621582
(59) DESCRIBE `ports` 0.0019102096557617
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00040102005004883
(61) DESCRIBE `ports` 0.0017690658569336
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00043082237243652
(63) DESCRIBE `ports` 0.0025269985198975
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00045990943908691
(65) DESCRIBE `cruises` 0.0036900043487549
(66) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 81579))) 0.00062108039855957
(67) DESCRIBE `avid_specials` 0.0017762184143066
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1622026 and class = 'Special') OR (item_id = 81579 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 2 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.002269983291626
(69) DESCRIBE `cruiselines` 0.0026979446411133
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00043320655822754
(71) DESCRIBE `orchid_image` 0.0020360946655273
(72) DESCRIBE `cruiselines` 0.0026421546936035
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00051093101501465
(74) DESCRIBE `cruises` 0.0037779808044434
(75) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81579') 0.00049209594726562
(76) DESCRIBE `ships` 0.0041069984436035
(77) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.0005791187286377
(78) DESCRIBE `ships` 0.0035419464111328
(79) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00054693222045898
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034999847412109
(82) DESCRIBE `itineraries` 0.0019240379333496
(83) DESCRIBE `ports` 0.0019290447235107
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047397613525391
(85) DESCRIBE `ports` 0.0017619132995605
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00041890144348145
(87) DESCRIBE `ports` 0.0019879341125488
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0004119873046875
(89) DESCRIBE `sailingdates` 0.0015819072723389
(90) DESCRIBE `ports` 0.0020318031311035
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00051116943359375
(92) DESCRIBE `ports` 0.0018370151519775
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00056195259094238
(94) DESCRIBE `ports` 0.0018370151519775
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00040388107299805
(96) DESCRIBE `ports` 0.0019769668579102
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00041508674621582
(98) DESCRIBE `ports` 0.0018420219421387
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00052809715270996
(100) DESCRIBE `ports` 0.0027220249176025
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00055384635925293
(102) DESCRIBE `ports` 0.0022060871124268
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00040102005004883
(104) DESCRIBE `ports` 0.0017569065093994
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00038003921508789
(106) DESCRIBE `ports` 0.0018460750579834
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00041890144348145
(108) DESCRIBE `ports` 0.0018808841705322
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00039792060852051
(110) DESCRIBE `ports` 0.0017361640930176
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.0004580020904541
(112) DESCRIBE `ports` 0.0017631053924561
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00037717819213867
(114) DESCRIBE `ports` 0.0018301010131836
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00040721893310547
(116) DESCRIBE `ports` 0.001737117767334
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00038409233093262
(118) DESCRIBE `ports` 0.0017409324645996
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1262))) 0.00040006637573242
(120) DESCRIBE `ports` 0.0018391609191895
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1262') 0.00037693977355957
(122) DESCRIBE `ports` 0.0017709732055664
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00040316581726074
(124) DESCRIBE `ports` 0.0017290115356445
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00037407875061035
(126) DESCRIBE `ports` 0.001816987991333
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00041103363037109
(128) DESCRIBE `ports` 0.0017781257629395
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00039196014404297
(130) DESCRIBE `avid_specials` 0.0015571117401123
(131) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81579 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 2 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.0012221336364746
(132) DESCRIBE `cruiselines` 0.0027320384979248
(133) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00045514106750488
(134) DESCRIBE `orchid_image` 0.0019950866699219
(135) DESCRIBE `cruiselines` 0.003925085067749
(136) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00057315826416016
(137) DESCRIBE `cruises` 0.0046770572662354
(138) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81583') 0.0005950927734375
(139) DESCRIBE `ships` 0.0047659873962402
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.0006868839263916
(141) DESCRIBE `ships` 0.0048859119415283
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00057482719421387
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047802925109863
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051999092102051
(145) DESCRIBE `itineraries` 0.002385139465332
(146) DESCRIBE `ports` 0.0025689601898193
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00061297416687012
(148) DESCRIBE `ports` 0.0024049282073975
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00056910514831543
(150) DESCRIBE `ports` 0.002424955368042
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00054812431335449
(152) DESCRIBE `sailingdates` 0.0024230480194092
(153) DESCRIBE `ports` 0.0023398399353027
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00059318542480469
(155) DESCRIBE `ports` 0.002216100692749
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0006098747253418
(157) DESCRIBE `ports` 0.0023548603057861
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00049114227294922
(159) DESCRIBE `ports` 0.0019099712371826
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00044107437133789
(161) DESCRIBE `ports` 0.0020558834075928
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00043797492980957
(163) DESCRIBE `ports` 0.002269983291626
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00057005882263184
(165) DESCRIBE `ports` 0.002575159072876
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00042891502380371
(167) DESCRIBE `ports` 0.0017609596252441
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00038599967956543
(169) DESCRIBE `ports` 0.0017929077148438
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00041604042053223
(171) DESCRIBE `ports` 0.0020289421081543
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00049185752868652
(173) DESCRIBE `ports` 0.001802921295166
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00040507316589355
(175) DESCRIBE `ports` 0.0018119812011719
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00038790702819824
(177) DESCRIBE `ports` 0.0017402172088623
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00042200088500977
(179) DESCRIBE `ports` 0.0017940998077393
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00041890144348145
(181) DESCRIBE `ports` 0.0018651485443115
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00063800811767578
(183) DESCRIBE `ports` 0.0021190643310547
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00048303604125977
(185) DESCRIBE `ports` 0.0018088817596436
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00047397613525391
(187) DESCRIBE `ports` 0.0020420551300049
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00044584274291992
(189) DESCRIBE `ports` 0.0019440650939941
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00045299530029297
(191) DESCRIBE `ports` 0.0018649101257324
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00059103965759277
(193) DESCRIBE `avid_specials` 0.0017890930175781
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81583 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 2 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.0012128353118896
(195) DESCRIBE `cruiselines` 0.0027589797973633
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00045990943908691
(197) DESCRIBE `orchid_image` 0.0020339488983154
(198) DESCRIBE `cruiselines` 0.0027611255645752
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00054311752319336
(200) DESCRIBE `cruises` 0.0045537948608398
(201) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81582') 0.0004880428314209
(202) DESCRIBE `ships` 0.0037720203399658
(203) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00052213668823242
(204) DESCRIBE `ships` 0.003680944442749
(205) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00044703483581543
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035881996154785
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040602684020996
(208) DESCRIBE `itineraries` 0.0017650127410889
(209) DESCRIBE `ports` 0.0018501281738281
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00044393539428711
(211) DESCRIBE `ports` 0.0019049644470215
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00041294097900391
(213) DESCRIBE `ports` 0.0019900798797607
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00043487548828125
(215) DESCRIBE `sailingdates` 0.0016820430755615
(216) DESCRIBE `ports` 0.0019431114196777
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047612190246582
(218) DESCRIBE `ports` 0.0018520355224609
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00041317939758301
(220) DESCRIBE `ports` 0.001816987991333
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00040698051452637
(222) DESCRIBE `ports` 0.0017449855804443
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00042080879211426
(224) DESCRIBE `ports` 0.0017940998077393
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00043392181396484
(226) DESCRIBE `ports` 0.0018970966339111
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00039100646972656
(228) DESCRIBE `ports` 0.0018889904022217
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00039911270141602
(230) DESCRIBE `ports` 0.0017390251159668
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00037503242492676
(232) DESCRIBE `ports` 0.0023360252380371
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00054001808166504
(234) DESCRIBE `ports` 0.0023200511932373
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00044393539428711
(236) DESCRIBE `ports` 0.0018901824951172
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.000518798828125
(238) DESCRIBE `ports` 0.0017919540405273
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00038504600524902
(240) DESCRIBE `ports` 0.0018589496612549
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00047516822814941
(242) DESCRIBE `ports` 0.0017509460449219
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00038385391235352
(244) DESCRIBE `ports` 0.0018389225006104
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00043320655822754
(246) DESCRIBE `ports` 0.0017499923706055
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00039100646972656
(248) DESCRIBE `ports` 0.0017471313476562
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00040793418884277
(250) DESCRIBE `ports` 0.0017831325531006
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00039505958557129
(252) DESCRIBE `ports` 0.0019268989562988
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00043797492980957
(254) DESCRIBE `ports` 0.0017759799957275
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00040698051452637
(256) DESCRIBE `ports` 0.0017530918121338
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00040292739868164
(258) DESCRIBE `ports` 0.0018939971923828
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00038313865661621
(260) DESCRIBE `ports` 0.0018010139465332
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00041604042053223
(262) DESCRIBE `ports` 0.0017788410186768
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00045990943908691
(264) DESCRIBE `ports` 0.0018589496612549
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00045990943908691
(266) DESCRIBE `ports` 0.002161979675293
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00045299530029297
(268) DESCRIBE `ports` 0.0023999214172363
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1796))) 0.00041413307189941
(270) DESCRIBE `ports` 0.0018541812896729
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1796') 0.00039196014404297
(272) DESCRIBE `ports` 0.0018370151519775
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00052499771118164
(274) DESCRIBE `ports` 0.0018889904022217
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00040602684020996
(276) DESCRIBE `avid_specials` 0.0017478466033936
(277) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81582 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 2 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.0011389255523682
(278) DESCRIBE `cruiselines` 0.0025579929351807
(279) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00055289268493652
(280) DESCRIBE `orchid_image` 0.0019760131835938
(281) DESCRIBE `cruiselines` 0.0029728412628174
(282) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00054192543029785
(283) DESCRIBE `specials` 0.0055809020996094
(284) DESCRIBE `specials` 0.006540060043335
(285) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1620596') 0.00056695938110352
(286) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id != '1620596') 0.001554012298584
(287) UPDATE `specials` SET `orchid_slug` = ? WHERE (id = '1620596') 0.0003809928894043
(288) DESCRIBE `ships` 0.0038249492645264
(289) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00047111511230469
(290) DESCRIBE `ships` 0.0033810138702393
(291) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00038719177246094
(292) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035619735717773
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034689903259277
(294) DESCRIBE `itineraries` 0.0017998218536377
(295) DESCRIBE `ports` 0.0018110275268555
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0004580020904541
(297) DESCRIBE `ports` 0.0018699169158936
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00049209594726562
(299) DESCRIBE `ports` 0.002155065536499
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00043702125549316
(301) DESCRIBE `specialsailingdates` 0.0014500617980957
(302) DESCRIBE `sailingdates` 0.0016279220581055
(303) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 513464))) 0.00046801567077637
(304) DESCRIBE `ports` 0.0021431446075439
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047111511230469
(306) DESCRIBE `ports` 0.0022039413452148
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00043296813964844
(308) DESCRIBE `ports` 0.0017349720001221
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0004279613494873
(310) DESCRIBE `ports` 0.0019528865814209
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00038790702819824
(312) DESCRIBE `ports` 0.0021438598632812
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00042390823364258
(314) DESCRIBE `ports` 0.0025508403778076
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00055789947509766
(316) DESCRIBE `ports` 0.0027511119842529
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00044012069702148
(318) DESCRIBE `ports` 0.0018270015716553
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.0004417896270752
(320) DESCRIBE `ports` 0.0019230842590332
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00048494338989258
(322) DESCRIBE `ports` 0.0018229484558105
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.0003819465637207
(324) DESCRIBE `ports` 0.0017821788787842
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00042200088500977
(326) DESCRIBE `ports` 0.0018329620361328
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00037908554077148
(328) DESCRIBE `ports` 0.0020670890808105
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.0004580020904541
(330) DESCRIBE `ports` 0.0017650127410889
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00038003921508789
(332) DESCRIBE `ports` 0.00205397605896
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00041818618774414
(334) DESCRIBE `ports` 0.0017669200897217
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00042414665222168
(336) DESCRIBE `ports` 0.0017549991607666
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00039911270141602
(338) DESCRIBE `ports` 0.0017759799957275
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00049018859863281
(340) DESCRIBE `ports` 0.0018448829650879
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00044798851013184
(342) DESCRIBE `ports` 0.0018129348754883
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00041890144348145
(344) DESCRIBE `ports` 0.0017321109771729
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0004119873046875
(346) DESCRIBE `ports` 0.0019230842590332
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00041985511779785
(348) DESCRIBE `ports` 0.0018198490142822
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00039291381835938
(350) DESCRIBE `ports` 0.0018479824066162
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00037598609924316
(352) DESCRIBE `cruises` 0.0035459995269775
(353) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 81580))) 0.00049304962158203
(354) DESCRIBE `avid_specials` 0.0016500949859619
(355) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1620596 and class = 'Special') OR (item_id = 81580 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 2 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.0012309551239014
(356) DESCRIBE `cruiselines` 0.0026669502258301
(357) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00040888786315918
(358) DESCRIBE `orchid_image` 0.0020918846130371
(359) DESCRIBE `cruiselines` 0.00282883644104
(360) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00044512748718262
(361) DESCRIBE `cruisetypes` 0.0014941692352295
(362) DESCRIBE `cruiselines` 0.0026030540466309
(363) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00043106079101562
(364) DESCRIBE `ships` 0.0035760402679443
(365) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00049185752868652
(366) DESCRIBE `destinations` 0.0022120475769043
(367) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 2))) 0.00041317939758301
(368) DESCRIBE `destinations` 0.0032930374145508
(369) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 2))) 0.00063395500183105
(370) DESCRIBE `cruiselines` 0.0038149356842041
(371) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00056815147399902
(372) DESCRIBE `ships` 0.0054712295532227
(373) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00067591667175293