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

Total elapsed time: 0.76865148544312

# Query Time
(1) connect 0.0010859966278076
(2) DESCRIBE `cruises` 0.0041210651397705
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65896, 41776, 41778, 63370, 67295, 65888, 50857, 70930, 63374, 63373)) ORDER BY FIND_IN_SET(id, '65896,41776,41778,63370,67295,65888,50857,70930,63374,63373') 0.0027530193328857
(4) DESCRIBE `cruises` 0.0036578178405762
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65896') 0.00044488906860352
(6) DESCRIBE `ships` 0.0033581256866455
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00043892860412598
(8) DESCRIBE `ships` 0.0030310153961182
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00044488906860352
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032782554626465
(12) DESCRIBE `itineraries` 0.0016958713531494
(13) DESCRIBE `ports` 0.0013978481292725
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033903121948242
(15) DESCRIBE `ports` 0.0012848377227783
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030684471130371
(17) DESCRIBE `ports` 0.001317024230957
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028800964355469
(19) DESCRIBE `sailingdates` 0.0011358261108398
(20) DESCRIBE `ports` 0.0012760162353516
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003211498260498
(22) DESCRIBE `ports` 0.0015969276428223
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031900405883789
(24) DESCRIBE `ports` 0.001244068145752
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00037288665771484
(26) DESCRIBE `ports` 0.0013020038604736
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027585029602051
(28) DESCRIBE `ports` 0.0012350082397461
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00029587745666504
(30) DESCRIBE `ports` 0.0013508796691895
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00029921531677246
(32) DESCRIBE `ports` 0.0012459754943848
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00045108795166016
(34) DESCRIBE `ports` 0.0012819766998291
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00028800964355469
(36) DESCRIBE `ports` 0.0013160705566406
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00030899047851562
(38) DESCRIBE `ports` 0.0015931129455566
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00033211708068848
(40) DESCRIBE `ports` 0.0040209293365479
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0064578056335449
(42) DESCRIBE `ports` 0.0015988349914551
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0018799304962158
(44) DESCRIBE `ports` 0.001492977142334
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004279613494873
(46) DESCRIBE `ports` 0.0012819766998291
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032591819763184
(48) DESCRIBE `avid_specials` 0.0016279220581055
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65896 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0015439987182617
(50) DESCRIBE `cruiselines` 0.001943826675415
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00045490264892578
(52) DESCRIBE `orchid_image` 0.0020029544830322
(53) DESCRIBE `cruiselines` 0.0016880035400391
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031614303588867
(55) DESCRIBE `cruises` 0.002504825592041
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00034213066101074
(57) DESCRIBE `ships` 0.0025198459625244
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00050592422485352
(59) DESCRIBE `ships` 0.0025670528411865
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00035309791564941
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026106834411621
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024890899658203
(63) DESCRIBE `itineraries` 0.0015418529510498
(64) DESCRIBE `ports` 0.0013220310211182
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035595893859863
(66) DESCRIBE `ports` 0.0014359951019287
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003349781036377
(68) DESCRIBE `ports` 0.0012679100036621
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003349781036377
(70) DESCRIBE `sailingdates` 0.0011270046234131
(71) DESCRIBE `ports` 0.0013699531555176
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(73) DESCRIBE `ports` 0.0012900829315186
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002901554107666
(75) DESCRIBE `ports` 0.001317024230957
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00032210350036621
(77) DESCRIBE `ports` 0.0012879371643066
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00030398368835449
(79) DESCRIBE `ports` 0.0013217926025391
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00030207633972168
(81) DESCRIBE `ports` 0.0012891292572021
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00027084350585938
(83) DESCRIBE `ports` 0.0012660026550293
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031781196594238
(85) DESCRIBE `ports` 0.0017900466918945
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00034809112548828
(87) DESCRIBE `ports` 0.0013279914855957
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003209114074707
(89) DESCRIBE `ports` 0.001309871673584
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028204917907715
(91) DESCRIBE `avid_specials` 0.0012321472167969
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.001007080078125
(93) DESCRIBE `cruiselines` 0.0019581317901611
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034499168395996
(95) DESCRIBE `orchid_image` 0.0014598369598389
(96) DESCRIBE `cruiselines` 0.0022552013397217
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00049519538879395
(98) DESCRIBE `cruises` 0.0027761459350586
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00032901763916016
(100) DESCRIBE `ships` 0.0027778148651123
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00056290626525879
(102) DESCRIBE `ships` 0.0036680698394775
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00032687187194824
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029087066650391
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00011587142944336
(106) DESCRIBE `itineraries` 0.0013308525085449
(107) DESCRIBE `ports` 0.0013189315795898
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032687187194824
(109) DESCRIBE `ports` 0.0013260841369629
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(111) DESCRIBE `ports` 0.0012710094451904
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031399726867676
(113) DESCRIBE `sailingdates` 0.0011351108551025
(114) DESCRIBE `ports` 0.0013880729675293
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003509521484375
(116) DESCRIBE `ports` 0.0013470649719238
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061798095703125
(118) DESCRIBE `ports` 0.001410961151123
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00092506408691406
(120) DESCRIBE `ports` 0.0029489994049072
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034809112548828
(122) DESCRIBE `avid_specials` 0.001147985458374
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.0016329288482666
(124) DESCRIBE `cruiselines` 0.0017910003662109
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032806396484375
(126) DESCRIBE `orchid_image` 0.001488208770752
(127) DESCRIBE `cruiselines` 0.0025849342346191
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00043892860412598
(129) DESCRIBE `cruises` 0.0033729076385498
(130) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63370') 0.00043702125549316
(131) DESCRIBE `ships` 0.0031619071960449
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00054717063903809
(133) DESCRIBE `ships` 0.0032849311828613
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00039505958557129
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031590461730957
(137) DESCRIBE `itineraries` 0.0016930103302002
(138) DESCRIBE `ports` 0.0016400814056396
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041508674621582
(140) DESCRIBE `ports` 0.0016779899597168
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003809928894043
(142) DESCRIBE `ports` 0.0018119812011719
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038504600524902
(144) DESCRIBE `sailingdates` 0.0014450550079346
(145) DESCRIBE `ports` 0.0016849040985107
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041890144348145
(147) DESCRIBE `ports` 0.001492977142334
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036406517028809
(149) DESCRIBE `ports` 0.0016500949859619
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00038385391235352
(151) DESCRIBE `ports` 0.0017340183258057
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00043082237243652
(153) DESCRIBE `ports` 0.0015618801116943
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00037479400634766
(155) DESCRIBE `ports` 0.00164794921875
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00033402442932129
(157) DESCRIBE `ports` 0.0016181468963623
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00036001205444336
(159) DESCRIBE `ports` 0.0015699863433838
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00038599967956543
(161) DESCRIBE `ports` 0.0016090869903564
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00036311149597168
(163) DESCRIBE `ports` 0.0016191005706787
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00034809112548828
(165) DESCRIBE `ports` 0.0016279220581055
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037097930908203
(167) DESCRIBE `ports` 0.0022909641265869
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003509521484375
(169) DESCRIBE `avid_specials` 0.0015690326690674
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63370 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0017919540405273
(171) DESCRIBE `cruiselines` 0.0025060176849365
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043797492980957
(173) DESCRIBE `orchid_image` 0.0023250579833984
(174) DESCRIBE `cruiselines` 0.0031359195709229
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00034999847412109
(176) DESCRIBE `cruises` 0.0031828880310059
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67295') 0.00038909912109375
(178) DESCRIBE `ships` 0.0031270980834961
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00075912475585938
(180) DESCRIBE `ships` 0.0034880638122559
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00043988227844238
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031113624572754
(184) DESCRIBE `itineraries` 0.001690149307251
(185) DESCRIBE `ports` 0.0015439987182617
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041413307189941
(187) DESCRIBE `ports` 0.0016448497772217
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003669261932373
(189) DESCRIBE `ports` 0.0016388893127441
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034689903259277
(191) DESCRIBE `sailingdates` 0.0015590190887451
(192) DESCRIBE `ports` 0.0015239715576172
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038909912109375
(194) DESCRIBE `ports` 0.0016288757324219
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032711029052734
(196) DESCRIBE `ports` 0.0015499591827393
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00037407875061035
(198) DESCRIBE `ports` 0.0016131401062012
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00034880638122559
(200) DESCRIBE `ports` 0.0014979839324951
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00035285949707031
(202) DESCRIBE `ports` 0.0016579627990723
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00033307075500488
(204) DESCRIBE `ports` 0.0016028881072998
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00039982795715332
(206) DESCRIBE `ports` 0.0015509128570557
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00041604042053223
(208) DESCRIBE `ports` 0.0017008781433105
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037097930908203
(210) DESCRIBE `ports` 0.0016088485717773
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034284591674805
(212) DESCRIBE `avid_specials` 0.0014150142669678
(213) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67295 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.001694917678833
(214) DESCRIBE `cruiselines` 0.0036208629608154
(215) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00057291984558105
(216) DESCRIBE `orchid_image` 0.0018990039825439
(217) DESCRIBE `cruiselines` 0.0022361278533936
(218) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00035810470581055
(219) DESCRIBE `cruises` 0.0032260417938232
(220) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65888') 0.00051403045654297
(221) DESCRIBE `ships` 0.0039081573486328
(222) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00047111511230469
(223) DESCRIBE `ships` 0.0034990310668945
(224) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00041484832763672
(225) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003049373626709
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029301643371582
(227) DESCRIBE `itineraries` 0.0016639232635498
(228) DESCRIBE `ports` 0.0017008781433105
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040006637573242
(230) DESCRIBE `ports` 0.0016520023345947
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00069284439086914
(232) DESCRIBE `ports` 0.0023350715637207
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040006637573242
(234) DESCRIBE `sailingdates` 0.0015430450439453
(235) DESCRIBE `ports` 0.0017778873443604
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041890144348145
(237) DESCRIBE `ports` 0.0019979476928711
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037002563476562
(239) DESCRIBE `ports` 0.0016710758209229
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00039911270141602
(241) DESCRIBE `ports` 0.0017218589782715
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.0003659725189209
(243) DESCRIBE `ports` 0.0018229484558105
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.0003509521484375
(245) DESCRIBE `ports` 0.0018219947814941
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00064897537231445
(247) DESCRIBE `ports` 0.0013809204101562
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00034308433532715
(249) DESCRIBE `ports` 0.0015299320220947
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 6.6995620727539E-5
(251) DESCRIBE `ports` 0.0015220642089844
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00033187866210938
(253) DESCRIBE `ports` 0.0015838146209717
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00021004676818848
(255) DESCRIBE `ports` 0.0016131401062012
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018405914306641
(257) DESCRIBE `ports` 0.0016980171203613
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005638599395752
(259) DESCRIBE `avid_specials` 0.01121997833252
(260) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65888 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0014469623565674
(261) DESCRIBE `cruiselines` 0.001878023147583
(262) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00044918060302734
(263) DESCRIBE `orchid_image` 0.0013768672943115
(264) DESCRIBE `cruiselines` 0.0098628997802734
(265) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0014221668243408
(266) DESCRIBE `cruises` 0.0074131488800049
(267) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00030803680419922
(268) DESCRIBE `ships` 0.0027039051055908
(269) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00042891502380371
(270) DESCRIBE `ships` 0.0028941631317139
(271) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00036406517028809
(272) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030899047851562
(273) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(274) DESCRIBE `itineraries` 0.0015220642089844
(275) DESCRIBE `ports` 0.0017359256744385
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036406517028809
(277) DESCRIBE `ports` 0.0021591186523438
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037407875061035
(279) DESCRIBE `ports` 0.0012779235839844
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036716461181641
(281) DESCRIBE `sailingdates` 0.0011959075927734
(282) DESCRIBE `ports` 0.0015280246734619
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003509521484375
(284) DESCRIBE `ports` 0.0012938976287842
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00075292587280273
(286) DESCRIBE `ports` 0.0017189979553223
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00030994415283203
(288) DESCRIBE `ports` 0.0085430145263672
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0003209114074707
(290) DESCRIBE `ports` 0.0013701915740967
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0045440196990967
(292) DESCRIBE `ports` 0.0014371871948242
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00034809112548828
(294) DESCRIBE `ports` 0.0014190673828125
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0044028759002686
(296) DESCRIBE `ports` 0.0020370483398438
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0046460628509521
(298) DESCRIBE `ports` 0.0013809204101562
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0027861595153809
(300) DESCRIBE `ports` 0.0012898445129395
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00029206275939941
(302) DESCRIBE `ports` 0.0048398971557617
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 3.4093856811523E-5
(304) DESCRIBE `ports` 0.0013561248779297
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043296813964844
(306) DESCRIBE `avid_specials` 0.0074188709259033
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0010390281677246
(308) DESCRIBE `cruiselines` 0.0022060871124268
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0044698715209961
(310) DESCRIBE `orchid_image` 0.0015490055084229
(311) DESCRIBE `cruiselines` 0.0058591365814209
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 3.1948089599609E-5
(313) DESCRIBE `cruises` 0.0024628639221191
(314) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70930') 0.0078620910644531
(315) DESCRIBE `ships` 0.0039830207824707
(316) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0051710605621338
(317) DESCRIBE `ships` 0.0036890506744385
(318) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00030708312988281
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(321) DESCRIBE `itineraries` 0.0014050006866455
(322) DESCRIBE `ports` 0.0021309852600098
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037813186645508
(324) DESCRIBE `ports` 0.0016391277313232
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035715103149414
(326) DESCRIBE `ports` 0.0013821125030518
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018596649169922
(328) DESCRIBE `sailingdates` 0.0018360614776611
(329) DESCRIBE `ports` 0.0015161037445068
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048303604125977
(331) DESCRIBE `ports` 0.0014419555664062
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0026991367340088
(333) DESCRIBE `ports` 0.0059700012207031
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0014278888702393
(335) DESCRIBE `ports` 0.0072100162506104
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00035214424133301
(337) DESCRIBE `ports` 0.0014450550079346
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0077052116394043
(339) DESCRIBE `ports` 0.001478910446167
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00035715103149414
(341) DESCRIBE `ports` 0.0020170211791992
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00034499168395996
(343) DESCRIBE `ports` 0.0016200542449951
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00027799606323242
(345) DESCRIBE `ports` 0.0015280246734619
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031304359436035
(347) DESCRIBE `ports` 0.0014059543609619
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00029706954956055
(349) DESCRIBE `ports` 0.0016381740570068
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034213066101074
(351) DESCRIBE `ports` 0.0049221515655518
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0098040103912354
(353) DESCRIBE `avid_specials` 0.0014369487762451
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70930 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0011579990386963
(355) DESCRIBE `cruiselines` 0.0020921230316162
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0049920082092285
(357) DESCRIBE `orchid_image` 0.0015819072723389
(358) DESCRIBE `cruiselines` 0.0018301010131836
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.006375789642334
(360) DESCRIBE `cruises` 0.0030848979949951
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63374') 0.00034284591674805
(362) DESCRIBE `ships` 0.0026669502258301
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.001338005065918
(364) DESCRIBE `ships` 0.0037190914154053
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0042970180511475
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00062298774719238
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048184394836426
(368) DESCRIBE `itineraries` 0.0014979839324951
(369) DESCRIBE `ports` 0.0033168792724609
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0018768310546875
(371) DESCRIBE `ports` 0.0020408630371094
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0021460056304932
(373) DESCRIBE `ports` 0.0016849040985107
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0016570091247559
(375) DESCRIBE `sailingdates` 0.0016641616821289
(376) DESCRIBE `ports` 0.0027439594268799
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0033631324768066
(378) DESCRIBE `ports` 0.0019948482513428
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0019910335540771
(380) DESCRIBE `ports` 0.0017151832580566
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0018432140350342
(382) DESCRIBE `ports` 0.0014419555664062
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0018341541290283
(384) DESCRIBE `ports` 0.0018751621246338
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0022389888763428
(386) DESCRIBE `ports` 0.0072669982910156
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0061569213867188
(388) DESCRIBE `ports` 0.001370906829834
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0003211498260498
(390) DESCRIBE `ports` 0.0013008117675781
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00034308433532715
(392) DESCRIBE `ports` 0.0013320446014404
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00030207633972168
(394) DESCRIBE `ports` 0.0095219612121582
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00029587745666504
(396) DESCRIBE `ports` 0.0013408660888672
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038790702819824
(398) DESCRIBE `ports` 0.0013530254364014
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025200843811035
(400) DESCRIBE `avid_specials` 0.0013368129730225
(401) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63374 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.001676082611084
(402) DESCRIBE `cruiselines` 0.0020501613616943
(403) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0065369606018066
(404) DESCRIBE `orchid_image` 0.0021171569824219
(405) DESCRIBE `cruiselines` 0.0024199485778809
(406) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0003969669342041
(407) DESCRIBE `cruises` 0.008342981338501
(408) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63373') 0.0004279613494873
(409) DESCRIBE `ships` 0.0026209354400635
(410) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00038790702819824
(411) DESCRIBE `ships` 0.010018110275269
(412) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00040602684020996
(413) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031685829162598
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(415) DESCRIBE `itineraries` 0.0014140605926514
(416) DESCRIBE `ports` 0.0013680458068848
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033402442932129
(418) DESCRIBE `ports` 0.0013620853424072
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0066208839416504
(420) DESCRIBE `ports` 0.0015881061553955
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032711029052734
(422) DESCRIBE `sailingdates` 0.0012381076812744
(423) DESCRIBE `ports` 0.0014021396636963
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037193298339844
(425) DESCRIBE `ports` 0.0012969970703125
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0056769847869873
(427) DESCRIBE `ports` 0.0015420913696289
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00037217140197754
(429) DESCRIBE `ports` 0.0013539791107178
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028109550476074
(431) DESCRIBE `ports` 0.0012750625610352
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0087840557098389
(433) DESCRIBE `ports` 0.0016398429870605
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00029492378234863
(435) DESCRIBE `ports` 0.0013699531555176
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00031614303588867
(437) DESCRIBE `ports` 0.0013449192047119
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00030398368835449
(439) DESCRIBE `ports` 0.0015718936920166
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00030803680419922
(441) DESCRIBE `ports` 0.001568078994751
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0002899169921875
(443) DESCRIBE `ports` 0.0082278251647949
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0004270076751709
(445) DESCRIBE `ports` 0.0013608932495117
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028395652770996
(447) DESCRIBE `ports` 0.0012829303741455
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033092498779297
(449) DESCRIBE `ports` 0.0013718605041504
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029802322387695
(451) DESCRIBE `avid_specials` 0.0011460781097412
(452) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63373 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0095129013061523
(453) DESCRIBE `cruiselines` 0.0020558834075928
(454) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003509521484375
(455) DESCRIBE `orchid_image` 0.0014879703521729
(456) DESCRIBE `cruiselines` 0.001896858215332
(457) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00030803680419922
(458) DESCRIBE `cruisetypes` 0.0013031959533691
(459) DESCRIBE `destinations` 0.0085859298706055
(460) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.0005340576171875
(461) DESCRIBE `cruiselines` 0.0020780563354492
(462) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034499168395996
(463) DESCRIBE `ships` 0.0030150413513184
(464) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0072391033172607
(465) DESCRIBE `cruiselines` 0.0021600723266602
(466) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034904479980469
(467) DESCRIBE `ships` 0.0028970241546631
(468) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00040197372436523