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

Total elapsed time: 0.67966914176941

# Query Time
(1) connect 0.0011959075927734
(2) DESCRIBE `cruises` 0.0040638446807861
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (38689, 25176, 38690, 67001, 67000, 67002, 77636, 74236, 74237, 67256)) ORDER BY FIND_IN_SET(id, '38689,25176,38690,67001,67000,67002,77636,74236,74237,67256') 0.0024728775024414
(4) DESCRIBE `cruises` 0.0029349327087402
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38689') 0.00031399726867676
(6) DESCRIBE `ships` 0.0031261444091797
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00050616264343262
(8) DESCRIBE `ships` 0.002938985824585
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00041294097900391
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002589225769043
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024509429931641
(12) DESCRIBE `itineraries` 0.0012609958648682
(13) DESCRIBE `ports` 0.0015861988067627
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031805038452148
(15) DESCRIBE `ports` 0.0014119148254395
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00029897689819336
(17) DESCRIBE `ports` 0.0012578964233398
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029706954956055
(19) DESCRIBE `sailingdates` 0.0012199878692627
(20) DESCRIBE `ports` 0.0014259815216064
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034809112548828
(22) DESCRIBE `ports` 0.001708984375
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00033998489379883
(24) DESCRIBE `ports` 0.0015969276428223
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00029206275939941
(26) DESCRIBE `ports` 0.0018260478973389
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00027298927307129
(28) DESCRIBE `ports` 0.0015048980712891
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00027799606323242
(30) DESCRIBE `ports` 0.0013909339904785
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00025796890258789
(32) DESCRIBE `ports` 0.0013349056243896
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00041604042053223
(34) DESCRIBE `ports` 0.0016191005706787
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00037288665771484
(36) DESCRIBE `ports` 0.0013749599456787
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00029683113098145
(38) DESCRIBE `ports` 0.0012691020965576
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00027108192443848
(40) DESCRIBE `ports` 0.0012750625610352
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00030779838562012
(42) DESCRIBE `ports` 0.0017209053039551
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00037097930908203
(44) DESCRIBE `ports` 0.0017259120941162
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00037097930908203
(46) DESCRIBE `ports` 0.0018270015716553
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00036096572875977
(48) DESCRIBE `ports` 0.0013859272003174
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0003049373626709
(50) DESCRIBE `ports` 0.0012891292572021
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00028014183044434
(52) DESCRIBE `ports` 0.0015690326690674
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00032591819763184
(54) DESCRIBE `ports` 0.0017480850219727
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00030207633972168
(56) DESCRIBE `avid_specials` 0.0016779899597168
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38689 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.0025780200958252
(58) DESCRIBE `cruiselines` 0.0025248527526855
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030899047851562
(60) DESCRIBE `orchid_image` 0.0015888214111328
(61) DESCRIBE `cruiselines` 0.0021681785583496
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00029587745666504
(63) DESCRIBE `cruises` 0.0032229423522949
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '25176') 0.0003669261932373
(65) DESCRIBE `ships` 0.0030710697174072
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00038886070251465
(67) DESCRIBE `ships` 0.0030460357666016
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00036096572875977
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(71) DESCRIBE `itineraries` 0.0015559196472168
(72) DESCRIBE `ports` 0.0016260147094727
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030612945556641
(74) DESCRIBE `ports` 0.0016582012176514
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030279159545898
(76) DESCRIBE `ports` 0.0016670227050781
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00028395652770996
(78) DESCRIBE `sailingdates` 0.0014369487762451
(79) DESCRIBE `ports` 0.0013260841369629
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030899047851562
(81) DESCRIBE `ports` 0.001338005065918
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00032210350036621
(83) DESCRIBE `ports` 0.0014650821685791
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00036191940307617
(85) DESCRIBE `ports` 0.0015959739685059
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00033283233642578
(87) DESCRIBE `ports` 0.0015358924865723
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00039505958557129
(89) DESCRIBE `ports` 0.0015170574188232
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00031709671020508
(91) DESCRIBE `ports` 0.0017480850219727
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00031185150146484
(93) DESCRIBE `ports` 0.0013899803161621
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00027203559875488
(95) DESCRIBE `ports` 0.0013210773468018
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00031590461730957
(97) DESCRIBE `ports` 0.0012609958648682
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0003209114074707
(99) DESCRIBE `avid_specials` 0.0015048980712891
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 25176 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 53 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.0010559558868408
(101) DESCRIBE `cruiselines` 0.0018649101257324
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0003349781036377
(103) DESCRIBE `orchid_image` 0.0014598369598389
(104) DESCRIBE `cruiselines` 0.0017819404602051
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027608871459961
(106) DESCRIBE `cruises` 0.0028090476989746
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38690') 0.00032210350036621
(108) DESCRIBE `ships` 0.003248929977417
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00040698051452637
(110) DESCRIBE `ships` 0.002997875213623
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00032687187194824
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029492378234863
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025510787963867
(114) DESCRIBE `itineraries` 0.0014920234680176
(115) DESCRIBE `ports` 0.0013720989227295
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030398368835449
(117) DESCRIBE `ports` 0.001488208770752
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00029706954956055
(119) DESCRIBE `ports` 0.0012919902801514
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00028514862060547
(121) DESCRIBE `sailingdates` 0.0010900497436523
(122) DESCRIBE `ports` 0.0012640953063965
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0003659725189209
(124) DESCRIBE `ports` 0.0016348361968994
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00033307075500488
(126) DESCRIBE `ports` 0.0014469623565674
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00030398368835449
(128) DESCRIBE `ports` 0.0015060901641846
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00030803680419922
(130) DESCRIBE `ports` 0.0014200210571289
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00029993057250977
(132) DESCRIBE `ports` 0.0015780925750732
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.0002748966217041
(134) DESCRIBE `ports` 0.0015959739685059
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00033903121948242
(136) DESCRIBE `ports` 0.0017631053924561
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00032615661621094
(138) DESCRIBE `ports` 0.0015978813171387
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00030803680419922
(140) DESCRIBE `ports` 0.0019068717956543
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00027894973754883
(142) DESCRIBE `ports` 0.0018119812011719
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00031590461730957
(144) DESCRIBE `ports` 0.0016720294952393
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00027799606323242
(146) DESCRIBE `ports` 0.0016829967498779
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00062108039855957
(148) DESCRIBE `ports` 0.0014331340789795
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.0004570484161377
(150) DESCRIBE `ports` 0.0015869140625
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00049400329589844
(152) DESCRIBE `ports` 0.0017571449279785
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00052690505981445
(154) DESCRIBE `ports` 0.0019469261169434
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0006859302520752
(156) DESCRIBE `ports` 0.0016269683837891
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00030684471130371
(158) DESCRIBE `avid_specials` 0.00084209442138672
(159) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38690 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.0010650157928467
(160) DESCRIBE `cruiselines` 0.0018749237060547
(161) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00063800811767578
(162) DESCRIBE `orchid_image` 0.0022311210632324
(163) DESCRIBE `cruiselines` 0.0019521713256836
(164) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018095970153809
(165) DESCRIBE `cruises` 0.0031118392944336
(166) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67001') 0.0004429817199707
(167) DESCRIBE `ships` 0.0032920837402344
(168) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 9.0122222900391E-5
(169) DESCRIBE `ships` 0.0029740333557129
(170) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00041604042053223
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00067305564880371
(172) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00066781044006348
(173) DESCRIBE `itineraries` 0.0017669200897217
(174) DESCRIBE `ports` 0.0018889904022217
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00015401840209961
(176) DESCRIBE `ports` 0.0020649433135986
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00049996376037598
(178) DESCRIBE `ports` 0.0020418167114258
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00054597854614258
(180) DESCRIBE `sailingdates` 0.001762866973877
(181) DESCRIBE `ports` 0.0018517971038818
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0005180835723877
(183) DESCRIBE `ports` 0.0016269683837891
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00042295455932617
(185) DESCRIBE `ports` 0.0016229152679443
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00015592575073242
(187) DESCRIBE `ports` 0.0019960403442383
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 9.9897384643555E-5
(189) DESCRIBE `ports` 0.001823902130127
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00051617622375488
(191) DESCRIBE `ports` 0.0017290115356445
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00041103363037109
(193) DESCRIBE `ports` 0.0016829967498779
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00044584274291992
(195) DESCRIBE `ports` 0.001600980758667
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00073504447937012
(197) DESCRIBE `ports` 0.0016629695892334
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 8.2969665527344E-5
(199) DESCRIBE `ports` 0.0020699501037598
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00034999847412109
(201) DESCRIBE `ports` 0.0015010833740234
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00045299530029297
(203) DESCRIBE `ports` 0.0016319751739502
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 9.0599060058594E-6
(205) DESCRIBE `avid_specials` 0.0015268325805664
(206) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67001 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 53 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.0015461444854736
(207) DESCRIBE `cruiselines` 0.0026650428771973
(208) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00045180320739746
(209) DESCRIBE `orchid_image` 0.0020010471343994
(210) DESCRIBE `cruiselines` 0.0022470951080322
(211) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00022292137145996
(212) DESCRIBE `cruises` 0.0034050941467285
(213) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67000') 7.0095062255859E-5
(214) DESCRIBE `ships` 0.0028700828552246
(215) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.0004580020904541
(216) DESCRIBE `ships` 0.0032808780670166
(217) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00041317939758301
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00059294700622559
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00065088272094727
(220) DESCRIBE `itineraries` 0.001971960067749
(221) DESCRIBE `ports` 0.0015609264373779
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 9.0837478637695E-5
(223) DESCRIBE `ports` 0.0022118091583252
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00015091896057129
(225) DESCRIBE `ports` 0.0018410682678223
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00050783157348633
(227) DESCRIBE `sailingdates` 0.0014698505401611
(228) DESCRIBE `ports` 0.0018610954284668
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042581558227539
(230) DESCRIBE `ports` 0.0017859935760498
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00037193298339844
(232) DESCRIBE `ports` 0.0018370151519775
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00044417381286621
(234) DESCRIBE `ports` 0.0020318031311035
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00046396255493164
(236) DESCRIBE `ports` 0.0020370483398438
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00047492980957031
(238) DESCRIBE `ports` 0.0021500587463379
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00040602684020996
(240) DESCRIBE `ports` 0.0021500587463379
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00043010711669922
(242) DESCRIBE `ports` 0.0019679069519043
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00050091743469238
(244) DESCRIBE `ports` 0.0021891593933105
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00046300888061523
(246) DESCRIBE `ports` 0.0022308826446533
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00037193298339844
(248) DESCRIBE `ports` 0.0017509460449219
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00040984153747559
(250) DESCRIBE `ports` 0.0019140243530273
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00035214424133301
(252) DESCRIBE `avid_specials` 0.0014510154724121
(253) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67000 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 12 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.0016798973083496
(254) DESCRIBE `cruiselines` 0.0030410289764404
(255) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00047397613525391
(256) DESCRIBE `orchid_image` 0.002202033996582
(257) DESCRIBE `cruiselines` 0.0023939609527588
(258) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00041007995605469
(259) DESCRIBE `cruises` 0.0032670497894287
(260) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67002') 0.00047588348388672
(261) DESCRIBE `ships` 0.0033631324768066
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00052404403686523
(263) DESCRIBE `ships` 0.0036919116973877
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00038504600524902
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003211498260498
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(267) DESCRIBE `itineraries` 0.0020558834075928
(268) DESCRIBE `ports` 0.0023179054260254
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043177604675293
(270) DESCRIBE `ports` 0.0017960071563721
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00064516067504883
(272) DESCRIBE `ports` 0.0020711421966553
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040698051452637
(274) DESCRIBE `sailingdates` 0.0016999244689941
(275) DESCRIBE `ports` 0.0015840530395508
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051403045654297
(277) DESCRIBE `ports` 0.0012788772583008
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00069904327392578
(279) DESCRIBE `ports` 0.0016798973083496
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00027799606323242
(281) DESCRIBE `ports` 0.0013418197631836
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00018596649169922
(283) DESCRIBE `ports` 0.0020899772644043
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00078392028808594
(285) DESCRIBE `ports` 0.00235915184021
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00036907196044922
(287) DESCRIBE `ports` 0.0018281936645508
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00043010711669922
(289) DESCRIBE `ports` 0.0021870136260986
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00038599967956543
(291) DESCRIBE `ports` 0.0017189979553223
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003969669342041
(293) DESCRIBE `ports` 0.0016460418701172
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00035691261291504
(295) DESCRIBE `avid_specials` 0.0019409656524658
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67002 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 12 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.0018379688262939
(297) DESCRIBE `cruiselines` 0.0018811225891113
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00031685829162598
(299) DESCRIBE `orchid_image` 0.0016958713531494
(300) DESCRIBE `cruiselines` 0.0019409656524658
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00028800964355469
(302) DESCRIBE `cruises` 0.0033450126647949
(303) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77636') 1.6927719116211E-5
(304) DESCRIBE `ships` 0.0031311511993408
(305) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00067901611328125
(306) DESCRIBE `ships` 0.0031559467315674
(307) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00021004676818848
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 6.3180923461914E-5
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 6.5088272094727E-5
(310) DESCRIBE `itineraries` 0.0012059211730957
(311) DESCRIBE `ports` 0.001878023147583
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00059080123901367
(313) DESCRIBE `ports` 0.0015289783477783
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00037693977355957
(315) DESCRIBE `ports` 0.0013649463653564
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00047087669372559
(317) DESCRIBE `sailingdates` 0.0014078617095947
(318) DESCRIBE `ports` 0.0019080638885498
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00014400482177734
(320) DESCRIBE `ports` 0.0018081665039062
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042986869812012
(322) DESCRIBE `ports` 0.0017931461334229
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1135))) 0.00049805641174316
(324) DESCRIBE `ports` 0.0022280216217041
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1135') 0
(326) DESCRIBE `ports` 0.0019888877868652
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00051093101501465
(328) DESCRIBE `ports` 0.0019829273223877
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00054693222045898
(330) DESCRIBE `ports` 0.0018999576568604
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0
(332) DESCRIBE `ports` 0.0018150806427002
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00064182281494141
(334) DESCRIBE `ports` 0.0024120807647705
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 7.3909759521484E-5
(336) DESCRIBE `ports` 0.0017709732055664
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 5.0783157348633E-5
(338) DESCRIBE `ports` 0.0020520687103271
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00056815147399902
(340) DESCRIBE `ports` 0.0016860961914062
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00060510635375977
(342) DESCRIBE `ports` 0.0018398761749268
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00047683715820312
(344) DESCRIBE `ports` 0.0022709369659424
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00044989585876465
(346) DESCRIBE `ports` 0.0019271373748779
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004119873046875
(348) DESCRIBE `ports` 0.0017030239105225
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00036096572875977
(350) DESCRIBE `avid_specials` 0.0015408992767334
(351) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77636 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 38 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.0012328624725342
(352) DESCRIBE `cruiselines` 0.0021510124206543
(353) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00044608116149902
(354) DESCRIBE `orchid_image` 0.0017609596252441
(355) DESCRIBE `cruiselines` 0.0021328926086426
(356) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00054621696472168
(357) DESCRIBE `cruises` 0.0038518905639648
(358) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74236') 0.00056886672973633
(359) DESCRIBE `ships` 0.0033760070800781
(360) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00046086311340332
(361) DESCRIBE `ships` 0.0033299922943115
(362) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00041317939758301
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037217140197754
(365) DESCRIBE `itineraries` 0.0015501976013184
(366) DESCRIBE `ports` 0.0015969276428223
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036501884460449
(368) DESCRIBE `ports` 0.0019290447235107
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043296813964844
(370) DESCRIBE `ports` 0.0019419193267822
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00041007995605469
(372) DESCRIBE `sailingdates` 0.0024359226226807
(373) DESCRIBE `ports` 0.001798152923584
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043392181396484
(375) DESCRIBE `ports` 0.0022990703582764
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00045990943908691
(377) DESCRIBE `ports` 0.0016050338745117
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00038599967956543
(379) DESCRIBE `ports` 0.0013320446014404
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00042080879211426
(381) DESCRIBE `ports` 0.0014510154724121
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00033712387084961
(383) DESCRIBE `ports` 0.0016238689422607
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00032591819763184
(385) DESCRIBE `ports` 0.0019819736480713
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037002563476562
(387) DESCRIBE `ports` 0.0020279884338379
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00045013427734375
(389) DESCRIBE `ports` 0.0020098686218262
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00044894218444824
(391) DESCRIBE `ports` 0.0021069049835205
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00043511390686035
(393) DESCRIBE `ports` 0.0021951198577881
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00049901008605957
(395) DESCRIBE `ports` 0.002094030380249
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00051307678222656
(397) DESCRIBE `ports` 0.0018310546875
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00047898292541504
(399) DESCRIBE `ports` 0.0022997856140137
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0005040168762207
(401) DESCRIBE `ports` 0.0023281574249268
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00042486190795898
(403) DESCRIBE `ports` 0.0022470951080322
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00043106079101562
(405) DESCRIBE `ports` 0.0026278495788574
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00045895576477051
(407) DESCRIBE `ports` 0.0020439624786377
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00049400329589844
(409) DESCRIBE `ports` 0.0021100044250488
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 7.2956085205078E-5
(411) DESCRIBE `ports` 0.0020761489868164
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00061297416687012
(413) DESCRIBE `ports` 0.0023062229156494
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00081896781921387
(415) DESCRIBE `ports` 0.001816987991333
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00043392181396484
(417) DESCRIBE `ports` 0.0018489360809326
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003969669342041
(419) DESCRIBE `ports` 0.0024271011352539
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027203559875488
(421) DESCRIBE `avid_specials` 0.0013539791107178
(422) 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.0013508796691895
(423) DESCRIBE `cruiselines` 0.0027298927307129
(424) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00060105323791504
(425) DESCRIBE `orchid_image` 0.0023760795593262
(426) DESCRIBE `cruiselines` 0.0027101039886475
(427) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00047802925109863
(428) DESCRIBE `cruises` 0.003493070602417
(429) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74237') 0.00040507316589355
(430) DESCRIBE `ships` 0.002824068069458
(431) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00047683715820312
(432) DESCRIBE `ships` 0.0036089420318604
(433) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00039100646972656
(434) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022602081298828
(435) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003969669342041
(436) DESCRIBE `itineraries` 0.0019490718841553
(437) DESCRIBE `ports` 0.0017769336700439
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004889965057373
(439) DESCRIBE `ports` 0.0016999244689941
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034403800964355
(441) DESCRIBE `ports` 0.00152587890625
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00026202201843262
(443) DESCRIBE `sailingdates` 0.00177001953125
(444) DESCRIBE `ports` 0.0025179386138916
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00049901008605957
(446) DESCRIBE `ports` 0.0019919872283936
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029683113098145
(448) DESCRIBE `ports` 0.0019729137420654
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00039291381835938
(450) DESCRIBE `ports` 0.001859188079834
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00032305717468262
(452) DESCRIBE `ports` 0.0013749599456787
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00028395652770996
(454) DESCRIBE `ports` 0.0014381408691406
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00028419494628906
(456) DESCRIBE `ports` 0.0014481544494629
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00033211708068848
(458) DESCRIBE `ports` 0.0021800994873047
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00037598609924316
(460) DESCRIBE `ports` 0.0013539791107178
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00034880638122559
(462) DESCRIBE `ports` 0.0017259120941162
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00031805038452148
(464) DESCRIBE `ports` 0.00142502784729
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00060200691223145
(466) DESCRIBE `ports` 0.0020089149475098
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00018095970153809
(468) DESCRIBE `ports` 0.0019068717956543
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00079202651977539
(470) DESCRIBE `ports` 0.002223014831543
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00034189224243164
(472) DESCRIBE `ports` 0.0016398429870605
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00041508674621582
(474) DESCRIBE `ports` 0.0017740726470947
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00045895576477051
(476) DESCRIBE `ports` 0.0021460056304932
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0004730224609375
(478) DESCRIBE `ports` 0.0016999244689941
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00054287910461426
(480) DESCRIBE `ports` 0.0017831325531006
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005800724029541
(482) DESCRIBE `ports` 0.0021159648895264
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00048708915710449
(484) DESCRIBE `avid_specials` 0.0017900466918945
(485) 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.0021920204162598
(486) DESCRIBE `cruiselines` 0.002485990524292
(487) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00018191337585449
(488) DESCRIBE `orchid_image` 0.0022900104522705
(489) DESCRIBE `cruiselines` 0.0026891231536865
(490) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0003669261932373
(491) DESCRIBE `cruises` 0.003493070602417
(492) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67256') 0.00041294097900391
(493) DESCRIBE `ships` 0.0034499168395996
(494) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00054001808166504
(495) DESCRIBE `ships` 0.0035321712493896
(496) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00037980079650879
(497) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037789344787598
(498) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(499) DESCRIBE `itineraries` 0.0020811557769775
(500) DESCRIBE `ports` 0.0020201206207275
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00037288665771484
(502) DESCRIBE `ports` 0.0019638538360596
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00036096572875977
(504) DESCRIBE `ports` 0.0020031929016113
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003669261932373
(506) DESCRIBE `sailingdates` 0.0017940998077393
(507) DESCRIBE `ports` 0.001784086227417
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041007995605469
(509) DESCRIBE `ports` 0.0017950534820557
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00035905838012695
(511) DESCRIBE `ports` 0.0017781257629395
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00039410591125488
(513) DESCRIBE `ports` 0.0017249584197998
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00034594535827637
(515) DESCRIBE `ports` 0.0017218589782715
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00044798851013184
(517) DESCRIBE `ports` 0.0017180442810059
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00035905838012695
(519) DESCRIBE `ports` 0.0017170906066895
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00038599967956543
(521) DESCRIBE `ports` 0.0016381740570068
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00034809112548828
(523) DESCRIBE `ports` 0.0015819072723389
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0004420280456543
(525) DESCRIBE `ports` 0.0016379356384277
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00035905838012695
(527) DESCRIBE `ports` 0.0016920566558838
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00042200088500977
(529) DESCRIBE `ports` 0.0016858577728271
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00037407875061035
(531) DESCRIBE `ports` 0.0016610622406006
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00040316581726074
(533) DESCRIBE `ports` 0.0016260147094727
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00040793418884277
(535) DESCRIBE `ports` 0.0016250610351562
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00039386749267578
(537) DESCRIBE `ports` 0.0018291473388672
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003669261932373
(539) DESCRIBE `avid_specials` 0.0015220642089844
(540) 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.0016639232635498
(541) DESCRIBE `cruiselines` 0.0026021003723145
(542) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00051712989807129
(543) DESCRIBE `orchid_image` 0.0020449161529541
(544) DESCRIBE `cruiselines` 0.0026929378509521
(545) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00046920776367188
(546) DESCRIBE `cruisetypes` 0.0019869804382324
(547) DESCRIBE `destinations` 0.0021638870239258
(548) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '53', '37', '48', '12', '38')) ORDER BY FIND_IN_SET(id, '22,53,37,48,12,38') 0.00051093101501465
(549) DESCRIBE `cruiselines` 0.0017249584197998
(550) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00035190582275391
(551) DESCRIBE `ships` 0.0028610229492188
(552) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00065183639526367
(553) DESCRIBE `cruiselines` 0.0021741390228271
(554) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00076103210449219
(555) DESCRIBE `ships` 0.0032141208648682
(556) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00052690505981445