or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

Total elapsed time: 0.51804685592651

# Query Time
(1) connect 0.0010149478912354
(2) DESCRIBE `cruises` 0.0034170150756836
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (74236, 74237, 67256, 74238, 74239, 74240)) ORDER BY FIND_IN_SET(id, '74236,74237,67256,74238,74239,74240') 0.0019221305847168
(4) DESCRIBE `cruises` 0.0028209686279297
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74236') 0.00046896934509277
(6) DESCRIBE `ships` 0.0031840801239014
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.0008080005645752
(8) DESCRIBE `ships` 0.0038189888000488
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00045108795166016
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032877922058105
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(12) DESCRIBE `itineraries` 0.0015280246734619
(13) DESCRIBE `ports` 0.0019080638885498
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00049400329589844
(15) DESCRIBE `ports` 0.0013148784637451
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040316581726074
(17) DESCRIBE `ports` 0.001594066619873
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044894218444824
(19) DESCRIBE `sailingdates` 0.0016131401062012
(20) DESCRIBE `ports` 0.0018889904022217
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004580020904541
(22) DESCRIBE `ports` 0.0018761157989502
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040411949157715
(24) DESCRIBE `ports` 0.0019340515136719
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00061416625976562
(26) DESCRIBE `ports` 0.001863956451416
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00036311149597168
(28) DESCRIBE `ports` 0.0013558864593506
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00036001205444336
(30) DESCRIBE `ports` 0.0012650489807129
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00028395652770996
(32) DESCRIBE `ports` 0.0013518333435059
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003662109375
(34) DESCRIBE `ports` 0.0017530918121338
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00046205520629883
(36) DESCRIBE `ports` 0.0017721652984619
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00043892860412598
(38) DESCRIBE `ports` 0.0017490386962891
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00036787986755371
(40) DESCRIBE `ports` 0.0019018650054932
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00041389465332031
(42) DESCRIBE `ports` 0.0017948150634766
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00039887428283691
(44) DESCRIBE `ports` 0.0021162033081055
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00052404403686523
(46) DESCRIBE `ports` 0.002140998840332
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042200088500977
(48) DESCRIBE `ports` 0.0018448829650879
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 8.2969665527344E-5
(50) DESCRIBE `ports` 0.001600980758667
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00040507316589355
(52) DESCRIBE `ports` 0.0018370151519775
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00046300888061523
(54) DESCRIBE `ports` 0.0018980503082275
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00044107437133789
(56) DESCRIBE `ports` 0.0017850399017334
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00048518180847168
(58) DESCRIBE `ports` 0.0017900466918945
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00037813186645508
(60) DESCRIBE `ports` 0.001680850982666
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00045394897460938
(62) DESCRIBE `ports` 0.0016710758209229
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00034379959106445
(64) DESCRIBE `ports` 0.001629114151001
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004119873046875
(66) DESCRIBE `ports` 0.0015270709991455
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041007995605469
(68) DESCRIBE `avid_specials` 0.0015871524810791
(69) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74236 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 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.0019690990447998
(70) DESCRIBE `cruiselines` 0.0025408267974854
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00049304962158203
(72) DESCRIBE `orchid_image` 0.0018291473388672
(73) DESCRIBE `cruiselines` 0.0022900104522705
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00042510032653809
(75) DESCRIBE `cruises` 0.0034241676330566
(76) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74237') 0.00040984153747559
(77) DESCRIBE `ships` 0.002810001373291
(78) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00041699409484863
(79) DESCRIBE `ships` 0.002852201461792
(80) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00041604042053223
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033187866210938
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028610229492188
(83) DESCRIBE `itineraries` 0.0018250942230225
(84) DESCRIBE `ports` 0.0019569396972656
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044894218444824
(86) DESCRIBE `ports` 0.0016031265258789
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041604042053223
(88) DESCRIBE `ports` 0.0016269683837891
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003662109375
(90) DESCRIBE `sailingdates` 0.0013539791107178
(91) DESCRIBE `ports` 0.0019228458404541
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00057387351989746
(93) DESCRIBE `ports` 0.0019071102142334
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00035905838012695
(95) DESCRIBE `ports` 0.0017709732055664
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00037503242492676
(97) DESCRIBE `ports` 0.0019559860229492
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00042510032653809
(99) DESCRIBE `ports` 0.0017209053039551
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00050592422485352
(101) DESCRIBE `ports` 0.00177001953125
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00041985511779785
(103) DESCRIBE `ports` 0.0016908645629883
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00050091743469238
(105) DESCRIBE `ports` 0.0014209747314453
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00064921379089355
(107) DESCRIBE `ports` 0.0016789436340332
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00041413307189941
(109) DESCRIBE `ports` 0.0017039775848389
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0003349781036377
(111) DESCRIBE `ports` 0.0017428398132324
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00037789344787598
(113) DESCRIBE `ports` 0.0017499923706055
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00041699409484863
(115) DESCRIBE `ports` 0.0018630027770996
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00043511390686035
(117) DESCRIBE `ports` 0.0018877983093262
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00037598609924316
(119) DESCRIBE `ports` 0.0016398429870605
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00040292739868164
(121) DESCRIBE `ports` 0.0015079975128174
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00042200088500977
(123) DESCRIBE `ports` 0.0018119812011719
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00051283836364746
(125) DESCRIBE `ports` 0.0019180774688721
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00044894218444824
(127) DESCRIBE `ports` 0.0020639896392822
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048613548278809
(129) DESCRIBE `ports` 0.0022718906402588
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00049209594726562
(131) DESCRIBE `avid_specials` 0.0017468929290771
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74237 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 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.0018799304962158
(133) DESCRIBE `cruiselines` 0.0026891231536865
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00051593780517578
(135) DESCRIBE `orchid_image` 0.0020229816436768
(136) DESCRIBE `cruiselines` 0.0025858879089355
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00050115585327148
(138) DESCRIBE `cruises` 0.0034959316253662
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67256') 0.00044989585876465
(140) DESCRIBE `ships` 0.0038189888000488
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00058102607727051
(142) DESCRIBE `ships` 0.0038609504699707
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00056982040405273
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036382675170898
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(146) DESCRIBE `itineraries` 0.0018010139465332
(147) DESCRIBE `ports` 0.0017910003662109
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00046992301940918
(149) DESCRIBE `ports` 0.0016839504241943
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004570484161377
(151) DESCRIBE `ports` 0.0017509460449219
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00043702125549316
(153) DESCRIBE `sailingdates` 0.0015261173248291
(154) DESCRIBE `ports` 0.0020790100097656
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004730224609375
(156) DESCRIBE `ports` 0.0017929077148438
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039887428283691
(158) DESCRIBE `ports` 0.0017299652099609
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00036096572875977
(160) DESCRIBE `ports` 0.0014779567718506
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00035786628723145
(162) DESCRIBE `ports` 0.0016818046569824
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00065398216247559
(164) DESCRIBE `ports` 0.0019831657409668
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00044608116149902
(166) DESCRIBE `ports` 0.00189208984375
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00051188468933105
(168) DESCRIBE `ports` 0.0019180774688721
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00041699409484863
(170) DESCRIBE `ports` 0.0017828941345215
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00041294097900391
(172) DESCRIBE `ports` 0.0016930103302002
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00039005279541016
(174) DESCRIBE `ports` 0.0016570091247559
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.0004420280456543
(176) DESCRIBE `ports` 0.0018651485443115
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00040721893310547
(178) DESCRIBE `ports` 0.0016891956329346
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00054717063903809
(180) DESCRIBE `ports` 0.0019800662994385
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00046300888061523
(182) DESCRIBE `ports` 0.0018658638000488
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043582916259766
(184) DESCRIBE `ports` 0.0018329620361328
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003960132598877
(186) DESCRIBE `avid_specials` 0.0012950897216797
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67256 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 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.0015971660614014
(188) DESCRIBE `cruiselines` 0.0023989677429199
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00044107437133789
(190) DESCRIBE `orchid_image` 0.0019979476928711
(191) DESCRIBE `cruiselines` 0.0025298595428467
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0004119873046875
(193) DESCRIBE `cruises` 0.0040419101715088
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74238') 0.00053596496582031
(195) DESCRIBE `ships` 0.0033278465270996
(196) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00049090385437012
(197) DESCRIBE `ships` 0.0031368732452393
(198) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00049495697021484
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028610229492188
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029397010803223
(201) DESCRIBE `itineraries` 0.0015759468078613
(202) DESCRIBE `ports` 0.002047061920166
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00050711631774902
(204) DESCRIBE `ports` 0.0018758773803711
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00051593780517578
(206) DESCRIBE `ports` 0.001849889755249
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00045394897460938
(208) DESCRIBE `sailingdates` 0.0016500949859619
(209) DESCRIBE `ports` 0.0020620822906494
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00054407119750977
(211) DESCRIBE `ports` 0.0019099712371826
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00051283836364746
(213) DESCRIBE `ports` 0.0018830299377441
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00050902366638184
(215) DESCRIBE `ports` 0.0019149780273438
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.0004429817199707
(217) DESCRIBE `ports` 0.0019989013671875
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00046205520629883
(219) DESCRIBE `ports` 0.0019259452819824
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00042486190795898
(221) DESCRIBE `ports` 0.0019278526306152
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00048089027404785
(223) DESCRIBE `ports` 0.0015881061553955
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00040197372436523
(225) DESCRIBE `ports` 0.0017480850219727
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00042200088500977
(227) DESCRIBE `ports` 0.0017900466918945
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00040602684020996
(229) DESCRIBE `ports` 0.0018241405487061
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00052499771118164
(231) DESCRIBE `ports` 0.0018808841705322
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042200088500977
(233) DESCRIBE `ports` 0.0019369125366211
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00045895576477051
(235) DESCRIBE `ports` 0.0019669532775879
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00051712989807129
(237) DESCRIBE `ports` 0.0017960071563721
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00085186958312988
(239) DESCRIBE `ports` 0.0019931793212891
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00049710273742676
(241) DESCRIBE `ports` 0.0016751289367676
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00046086311340332
(243) DESCRIBE `ports` 0.0018129348754883
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00040984153747559
(245) DESCRIBE `ports` 0.0019321441650391
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00059103965759277
(247) DESCRIBE `ports` 0.0019350051879883
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00035500526428223
(249) DESCRIBE `ports` 0.0012800693511963
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030708312988281
(251) DESCRIBE `ports` 0.0014848709106445
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028800964355469
(253) DESCRIBE `ports` 0.0013790130615234
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031495094299316
(255) DESCRIBE `ports` 0.0013449192047119
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027799606323242
(257) DESCRIBE `avid_specials` 0.0013129711151123
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74238 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 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.0011780261993408
(259) DESCRIBE `cruiselines` 0.0025570392608643
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00040006637573242
(261) DESCRIBE `orchid_image` 0.001500129699707
(262) DESCRIBE `cruiselines` 0.0019700527191162
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00038504600524902
(264) DESCRIBE `cruises` 0.0033001899719238
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74239') 0.0004580020904541
(266) DESCRIBE `ships` 0.0033340454101562
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00061202049255371
(268) DESCRIBE `ships` 0.0034539699554443
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00046300888061523
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029993057250977
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(272) DESCRIBE `itineraries` 0.0017001628875732
(273) DESCRIBE `ports` 0.0020132064819336
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00051689147949219
(275) DESCRIBE `ports` 0.0018370151519775
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045013427734375
(277) DESCRIBE `ports` 0.0014920234680176
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0004420280456543
(279) DESCRIBE `sailingdates` 0.0014359951019287
(280) DESCRIBE `ports` 0.0020771026611328
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005500316619873
(282) DESCRIBE `ports` 0.0018818378448486
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00046801567077637
(284) DESCRIBE `ports` 0.0015659332275391
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043082237243652
(286) DESCRIBE `ports` 0.00164794921875
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039386749267578
(288) DESCRIBE `ports` 0.0015628337860107
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00047588348388672
(290) DESCRIBE `ports` 0.0018088817596436
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00042486190795898
(292) DESCRIBE `ports` 0.0019240379333496
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00051498413085938
(294) DESCRIBE `ports` 0.0018939971923828
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00057315826416016
(296) DESCRIBE `ports` 0.0017809867858887
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00045084953308105
(298) DESCRIBE `ports` 0.0017518997192383
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00042581558227539
(300) DESCRIBE `ports` 0.0018889904022217
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00051617622375488
(302) DESCRIBE `ports` 0.0018038749694824
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00044822692871094
(304) DESCRIBE `ports` 0.0015411376953125
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00051307678222656
(306) DESCRIBE `ports` 0.0017650127410889
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00041007995605469
(308) DESCRIBE `ports` 0.0015828609466553
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00043606758117676
(310) DESCRIBE `ports` 0.0017459392547607
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00042009353637695
(312) DESCRIBE `ports` 0.0017580986022949
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00047111511230469
(314) DESCRIBE `ports` 0.0018100738525391
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00042200088500977
(316) DESCRIBE `ports` 0.0017621517181396
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00047898292541504
(318) DESCRIBE `ports` 0.0019440650939941
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0005030632019043
(320) DESCRIBE `ports` 0.0015678405761719
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044488906860352
(322) DESCRIBE `ports` 0.0017180442810059
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00047993659973145
(324) DESCRIBE `avid_specials` 0.0016050338745117
(325) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74239 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 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.0018408298492432
(326) DESCRIBE `cruiselines` 0.0028440952301025
(327) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00054192543029785
(328) DESCRIBE `orchid_image` 0.0022299289703369
(329) DESCRIBE `cruiselines` 0.0029489994049072
(330) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00047397613525391
(331) DESCRIBE `cruises` 0.0033471584320068
(332) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74240') 0.00042390823364258
(333) DESCRIBE `ships` 0.0032570362091064
(334) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00055384635925293
(335) DESCRIBE `ships` 0.0036940574645996
(336) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00058412551879883
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027799606323242
(338) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034713745117188
(339) DESCRIBE `itineraries` 0.0017869472503662
(340) DESCRIBE `ports` 0.0018348693847656
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00050806999206543
(342) DESCRIBE `ports` 0.0016908645629883
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043511390686035
(344) DESCRIBE `ports` 0.001878023147583
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00048303604125977
(346) DESCRIBE `sailingdates` 0.0013668537139893
(347) DESCRIBE `ports` 0.0018551349639893
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00050091743469238
(349) DESCRIBE `ports` 0.0016369819641113
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0004580020904541
(351) DESCRIBE `ports` 0.0018200874328613
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00054097175598145
(353) DESCRIBE `ports` 0.0017340183258057
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00032806396484375
(355) DESCRIBE `ports` 0.0022571086883545
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00051498413085938
(357) DESCRIBE `ports` 0.0018720626831055
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00043702125549316
(359) DESCRIBE `ports` 0.0018990039825439
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00043892860412598
(361) DESCRIBE `ports` 0.0025107860565186
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00038290023803711
(363) DESCRIBE `ports` 0.0017468929290771
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00050783157348633
(365) DESCRIBE `ports` 0.0020618438720703
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0006721019744873
(367) DESCRIBE `ports` 0.0022120475769043
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00054788589477539
(369) DESCRIBE `ports` 0.0017411708831787
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00037789344787598
(371) DESCRIBE `ports` 0.0015900135040283
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00051498413085938
(373) DESCRIBE `ports` 0.001798152923584
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00039196014404297
(375) DESCRIBE `ports` 0.0015060901641846
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00038504600524902
(377) DESCRIBE `ports` 0.0017678737640381
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0003809928894043
(379) DESCRIBE `ports` 0.0015380382537842
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049805641174316
(381) DESCRIBE `ports` 0.0018289089202881
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036001205444336
(383) DESCRIBE `ports` 0.00164794921875
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00044107437133789
(385) DESCRIBE `ports` 0.0018279552459717
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00045418739318848
(387) DESCRIBE `ports` 0.0020480155944824
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1509))) 0.00048589706420898
(389) DESCRIBE `ports` 0.0017969608306885
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1509') 0.00035786628723145
(391) DESCRIBE `ports` 0.0015630722045898
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042414665222168
(393) DESCRIBE `ports` 0.0016548633575439
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042986869812012
(395) DESCRIBE `avid_specials` 0.0014500617980957
(396) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74240 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 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.0013749599456787
(397) DESCRIBE `cruiselines` 0.0025200843811035
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00054383277893066
(399) DESCRIBE `orchid_image` 0.0018041133880615
(400) DESCRIBE `cruiselines` 0.0022141933441162
(401) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00065398216247559
(402) DESCRIBE `cruisetypes` 0.0018191337585449
(403) DESCRIBE `cruiselines` 0.0024518966674805
(404) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00057601928710938
(405) DESCRIBE `ships` 0.0037519931793213
(406) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00054001808166504
(407) DESCRIBE `destinations` 0.0022969245910645
(408) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.0005340576171875
(409) DESCRIBE `destinations` 0.0026531219482422
(410) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.0005490779876709
(411) DESCRIBE `cruiselines` 0.0025579929351807
(412) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00052690505981445
(413) DESCRIBE `ships` 0.0032970905303955
(414) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00057697296142578