or, enquire about your chosen options

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

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

 
 

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

Database Profiling Report

Total queries executed: 619

Total elapsed time: 0.72673439979553

# Query Time
(1) connect 0.00038504600524902
(2) DESCRIBE `cruises` 0.0037639141082764
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (81860, 62833, 72552, 73707, 75012, 75834, 73772, 76174, 78311, 38149)) ORDER BY FIND_IN_SET(id, '81860,62833,72552,73707,75012,75834,73772,76174,78311,38149') 0.0033211708068848
(4) DESCRIBE `cruises` 0.0036017894744873
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81860') 4.6014785766602E-5
(6) DESCRIBE `ships` 0.0030460357666016
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1706))) 0.0003809928894043
(8) DESCRIBE `ships` 0.002720832824707
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1706') 0.00029206275939941
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026082992553711
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(12) DESCRIBE `itineraries` 0.0012528896331787
(13) DESCRIBE `ports` 0.00070786476135254
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00032520294189453
(15) DESCRIBE `ports` 0.0022680759429932
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00033283233642578
(17) DESCRIBE `ports` 0.0012660026550293
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00028204917907715
(19) DESCRIBE `sailingdates` 0.0010969638824463
(20) DESCRIBE `ports` 0.0013048648834229
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00029897689819336
(22) DESCRIBE `ports` 0.0012428760528564
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00027894973754883
(24) DESCRIBE `ports` 0.0014388561248779
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1182))) 0.00031399726867676
(26) DESCRIBE `ports` 0.0012340545654297
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1182') 0.00026893615722656
(28) DESCRIBE `ports` 0.0015058517456055
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 660))) 0.00039196014404297
(30) DESCRIBE `ports` 0.0018939971923828
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '660') 0.00028896331787109
(32) DESCRIBE `ports` 0.0013248920440674
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1182))) 0.00039315223693848
(34) DESCRIBE `ports` 0.0012879371643066
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1182') 0.00031709671020508
(36) DESCRIBE `ports` 0.0017011165618896
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1971))) 0.00034308433532715
(38) DESCRIBE `ports` 0.0013089179992676
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1971') 0.0003209114074707
(40) DESCRIBE `ports` 0.0015110969543457
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2991))) 0.00036287307739258
(42) DESCRIBE `ports` 0.0016040802001953
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2991') 0.00032210350036621
(44) DESCRIBE `ports` 0.0014019012451172
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1182))) 0.0003049373626709
(46) DESCRIBE `ports` 0.0013649463653564
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1182') 0.00030398368835449
(48) DESCRIBE `ports` 0.0013730525970459
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1182))) 0.00034689903259277
(50) DESCRIBE `ports` 0.0012969970703125
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1182') 0.00031781196594238
(52) DESCRIBE `ports` 0.0012319087982178
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1182))) 0.00030016899108887
(54) DESCRIBE `ports` 0.0013840198516846
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1182') 0.00028705596923828
(56) DESCRIBE `ports` 0.0013270378112793
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00034499168395996
(58) DESCRIBE `ports` 0.0013730525970459
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00030112266540527
(60) DESCRIBE `avid_specials` 0.001121997833252
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81860 and class = 'Cruise') OR (item_id = 1706 AND class = 'Ship') OR (item_id = 159 AND class = 'CruiseLine') OR (item_id = 49 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.0010929107666016
(62) DESCRIBE `cruiselines` 0.002129077911377
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 159))) 0.00034618377685547
(64) DESCRIBE `orchid_image` 0.0016889572143555
(65) DESCRIBE `cruiselines` 0.0020320415496826
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '159') 0.00030303001403809
(67) DESCRIBE `cruises` 0.0024828910827637
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62833') 0.00030994415283203
(69) DESCRIBE `ships` 0.0026600360870361
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1471))) 0.00053000450134277
(71) DESCRIBE `ships` 0.0030009746551514
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1471') 0.00034999847412109
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026297569274902
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034594535827637
(75) DESCRIBE `itineraries` 0.00136399269104
(76) DESCRIBE `ports` 0.0013210773468018
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.0003819465637207
(78) DESCRIBE `ports` 0.0012919902801514
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.0003359317779541
(80) DESCRIBE `ports` 0.0012481212615967
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00031590461730957
(82) DESCRIBE `sailingdates` 0.001107931137085
(83) DESCRIBE `ports` 0.0014688968658447
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00032806396484375
(85) DESCRIBE `ports` 0.0012779235839844
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00031805038452148
(87) DESCRIBE `ports` 0.0012528896331787
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 99))) 0.00030803680419922
(89) DESCRIBE `ports` 0.0013048648834229
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '99') 0.00030803680419922
(91) DESCRIBE `ports` 0.0014770030975342
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00031304359436035
(93) DESCRIBE `ports` 0.0014839172363281
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00038504600524902
(95) DESCRIBE `ports` 0.001352071762085
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00032496452331543
(97) DESCRIBE `ports` 0.0013439655303955
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00029706954956055
(99) DESCRIBE `ports` 0.001431941986084
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1650))) 0.00030612945556641
(101) DESCRIBE `ports` 0.0013740062713623
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1650') 0.00030517578125
(103) DESCRIBE `ports` 0.0017240047454834
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2528))) 0.00042295455932617
(105) DESCRIBE `ports` 0.0019221305847168
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2528') 0.00035405158996582
(107) DESCRIBE `ports` 0.0013999938964844
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4454))) 0.00035977363586426
(109) DESCRIBE `ports` 0.0015220642089844
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4454') 0.00029778480529785
(111) DESCRIBE `ports` 0.0015308856964111
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1652))) 0.00034499168395996
(113) DESCRIBE `ports` 0.0014381408691406
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1652') 0.00035190582275391
(115) DESCRIBE `ports` 0.0013339519500732
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 99))) 0.00029182434082031
(117) DESCRIBE `ports` 0.0015239715576172
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '99') 0.00030899047851562
(119) DESCRIBE `ports` 0.0012481212615967
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00029087066650391
(121) DESCRIBE `ports` 0.0013091564178467
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00027012825012207
(123) DESCRIBE `ports` 0.0014090538024902
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00029706954956055
(125) DESCRIBE `ports` 0.0014181137084961
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00028610229492188
(127) DESCRIBE `avid_specials` 0.0012202262878418
(128) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62833 and class = 'Cruise') OR (item_id = 1471 AND class = 'Ship') OR (item_id = 110 AND class = 'CruiseLine') OR (item_id = 37 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.0013570785522461
(129) DESCRIBE `cruiselines` 0.0019779205322266
(130) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 110))) 0.00037288665771484
(131) DESCRIBE `orchid_image` 0.0018360614776611
(132) DESCRIBE `cruiselines` 0.0026280879974365
(133) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '110') 0.00035190582275391
(134) DESCRIBE `cruises` 0.0034379959106445
(135) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72552') 0.00044512748718262
(136) DESCRIBE `ships` 0.003774881362915
(137) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 148))) 0.00052905082702637
(138) DESCRIBE `ships` 0.0038888454437256
(139) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '148') 0.00039100646972656
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034093856811523
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00033307075500488
(142) DESCRIBE `itineraries` 0.0016460418701172
(143) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72552') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00091791152954102
(144) DESCRIBE `ports` 0.0014410018920898
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032806396484375
(146) DESCRIBE `ports` 0.0012459754943848
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029301643371582
(148) DESCRIBE `ports` 0.0012390613555908
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037002563476562
(150) DESCRIBE `sailingdates` 0.0014159679412842
(151) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72552') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00081777572631836
(152) DESCRIBE `ports` 0.0014610290527344
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003359317779541
(154) DESCRIBE `ports` 0.0013079643249512
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027990341186523
(156) DESCRIBE `ports` 0.0012679100036621
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1775))) 0.00041007995605469
(158) DESCRIBE `ports` 0.0016942024230957
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1775') 0.00029802322387695
(160) DESCRIBE `ports` 0.0013020038604736
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00034284591674805
(162) DESCRIBE `ports` 0.0014450550079346
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027799606323242
(164) DESCRIBE `ports` 0.001338005065918
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00032591819763184
(166) DESCRIBE `ports` 0.0013730525970459
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00038790702819824
(168) DESCRIBE `ports` 0.0016717910766602
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00030088424682617
(170) DESCRIBE `ports` 0.0016880035400391
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.0003349781036377
(172) DESCRIBE `ports` 0.0013258457183838
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.0003211498260498
(174) DESCRIBE `ports` 0.0013389587402344
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00027799606323242
(176) DESCRIBE `ports` 0.0012519359588623
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00030207633972168
(178) DESCRIBE `ports` 0.0012891292572021
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00027203559875488
(180) DESCRIBE `ports` 0.0012750625610352
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00081300735473633
(182) DESCRIBE `ports` 0.0007319450378418
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027298927307129
(184) DESCRIBE `avid_specials` 0.0011918544769287
(185) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72552 and class = 'Cruise') OR (item_id = 148 AND class = 'Ship') OR (item_id = 29 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.0003809928894043
(186) DESCRIBE `cruiselines` 0.0019989013671875
(187) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00037288665771484
(188) DESCRIBE `orchid_image` 0.0014469623565674
(189) DESCRIBE `cruises` 0.0024280548095703
(190) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73707') 0.00040197372436523
(191) DESCRIBE `ships` 0.0026581287384033
(192) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1400))) 0.00054097175598145
(193) DESCRIBE `ships` 0.0025978088378906
(194) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1400') 0.00034308433532715
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026488304138184
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025200843811035
(197) DESCRIBE `itineraries` 0.0013349056243896
(198) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73707') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011911392211914
(199) DESCRIBE `ports` 0.0014481544494629
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1972))) 0.00037097930908203
(201) DESCRIBE `ports` 0.0013458728790283
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1972))) 0.00033187866210938
(203) DESCRIBE `ports` 0.0017800331115723
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1972') 0.00031113624572754
(205) DESCRIBE `sailingdates` 0.0011579990386963
(206) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73707') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00073099136352539
(207) DESCRIBE `ports` 0.0013220310211182
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1972))) 0.00030016899108887
(209) DESCRIBE `ports` 0.0014121532440186
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1972') 0.00030398368835449
(211) DESCRIBE `ports` 0.0013370513916016
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1060))) 0.00034809112548828
(213) DESCRIBE `ports` 0.0013351440429688
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1060') 0.0002739429473877
(215) DESCRIBE `ports` 0.0012741088867188
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2214))) 0.00032496452331543
(217) DESCRIBE `ports` 0.0012731552124023
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2214') 0.00032401084899902
(219) DESCRIBE `ports` 0.0014128684997559
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5043))) 0.00030303001403809
(221) DESCRIBE `ports` 0.0018279552459717
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5043') 0.00032806396484375
(223) DESCRIBE `ports` 0.0015108585357666
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4140))) 0.00037503242492676
(225) DESCRIBE `ports` 0.0013220310211182
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4140') 0.00035500526428223
(227) DESCRIBE `ports` 0.0014970302581787
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2833))) 0.00030517578125
(229) DESCRIBE `ports` 0.001399040222168
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2833') 0.00035881996154785
(231) DESCRIBE `ports` 0.0012500286102295
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1659))) 0.00030207633972168
(233) DESCRIBE `ports` 0.001378059387207
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1659') 0.00029802322387695
(235) DESCRIBE `ports` 0.00057506561279297
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2435))) 0.00029993057250977
(237) DESCRIBE `ports` 0.0017969608306885
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2435') 0.00028204917907715
(239) DESCRIBE `ports` 0.0013790130615234
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5052))) 0.00049901008605957
(241) DESCRIBE `ports` 0.0014059543609619
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5052') 0.00029587745666504
(243) DESCRIBE `ports` 0.0015280246734619
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.0003349781036377
(245) DESCRIBE `ports` 0.0013320446014404
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00028300285339355
(247) DESCRIBE `ports` 0.001471996307373
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1866))) 0.0003058910369873
(249) DESCRIBE `ports` 0.0013248920440674
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1866') 0.0002748966217041
(251) DESCRIBE `ports` 0.0012729167938232
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2037))) 0.00033187866210938
(253) DESCRIBE `ports` 0.0014400482177734
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2037') 0.00073504447937012
(255) DESCRIBE `avid_specials` 0.0011119842529297
(256) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73707 and class = 'Cruise') OR (item_id = 1400 AND class = 'Ship') OR (item_id = 209 AND class = 'CruiseLine') OR (item_id = 21 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.0011539459228516
(257) DESCRIBE `cruiselines` 0.0018939971923828
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 209))) 0.00031018257141113
(259) DESCRIBE `orchid_image` 0.0014619827270508
(260) DESCRIBE `cruiselines` 0.0018579959869385
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '209') 0.00033092498779297
(262) DESCRIBE `cruises` 0.0033400058746338
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75012') 0.00029492378234863
(264) DESCRIBE `ships` 0.0032320022583008
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1136))) 0.00049710273742676
(266) DESCRIBE `ships` 0.0038559436798096
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1136') 0.00034499168395996
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026893615722656
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027084350585938
(270) DESCRIBE `itineraries` 0.0015490055084229
(271) DESCRIBE `ports` 0.0012679100036621
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00046396255493164
(273) DESCRIBE `ports` 0.0014309883117676
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0004119873046875
(275) DESCRIBE `ports` 0.0017650127410889
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00031304359436035
(277) DESCRIBE `sailingdates` 0.0020439624786377
(278) DESCRIBE `ports` 0.0027270317077637
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00053596496582031
(280) DESCRIBE `ports` 0.0026681423187256
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 3.3855438232422E-5
(282) DESCRIBE `ports` 0.0018332004547119
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0011558532714844
(284) DESCRIBE `ports` 0.0024511814117432
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00039815902709961
(286) DESCRIBE `ports` 0.0014200210571289
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00030708312988281
(288) DESCRIBE `ports` 0.0013210773468018
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00021982192993164
(290) DESCRIBE `ports` 0.001291036605835
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00030112266540527
(292) DESCRIBE `ports` 0.0012688636779785
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00038290023803711
(294) DESCRIBE `ports` 0.0013840198516846
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00096702575683594
(296) DESCRIBE `ports` 0.00091099739074707
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00031304359436035
(298) DESCRIBE `ports` 0.0013241767883301
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0
(300) DESCRIBE `ports` 0.001288890838623
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00028705596923828
(302) DESCRIBE `ports` 0.0017569065093994
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00031208992004395
(304) DESCRIBE `ports` 0.001568078994751
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.0011320114135742
(306) DESCRIBE `ports` 0.00060415267944336
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00035881996154785
(308) DESCRIBE `ports` 0.0021870136260986
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0
(310) DESCRIBE `ports` 0.0015900135040283
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00039291381835938
(312) DESCRIBE `ports` 0.0013530254364014
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00032901763916016
(314) DESCRIBE `ports` 0.0014657974243164
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00031495094299316
(316) DESCRIBE `ports` 0.0012781620025635
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00031399726867676
(318) DESCRIBE `ports` 0.0013079643249512
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00033998489379883
(320) DESCRIBE `ports` 0.0012800693511963
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00027894973754883
(322) DESCRIBE `ports` 0.0012950897216797
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00033712387084961
(324) DESCRIBE `ports` 0.0013070106506348
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00029301643371582
(326) DESCRIBE `ports` 0.0015759468078613
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00038695335388184
(328) DESCRIBE `ports` 0.0016880035400391
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0004270076751709
(330) DESCRIBE `avid_specials` 0.0016429424285889
(331) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75012 and class = 'Cruise') OR (item_id = 1136 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0012168884277344
(332) DESCRIBE `cruiselines` 0.0026559829711914
(333) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00041389465332031
(334) DESCRIBE `orchid_image` 0.001615047454834
(335) DESCRIBE `cruiselines` 0.0022521018981934
(336) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00039410591125488
(337) DESCRIBE `cruises` 0.0029528141021729
(338) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75834') 0.00042295455932617
(339) DESCRIBE `ships` 0.0029571056365967
(340) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 201))) 0.0006110668182373
(341) DESCRIBE `ships` 0.0029518604278564
(342) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '201') 0.00033307075500488
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00059008598327637
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0
(345) DESCRIBE `itineraries` 0.0019121170043945
(346) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75834') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00029897689819336
(347) DESCRIBE `ports` 0.0018901824951172
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00050711631774902
(349) DESCRIBE `ports` 0.0018179416656494
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.0004420280456543
(351) DESCRIBE `ports` 0.0017080307006836
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00034999847412109
(353) DESCRIBE `sailingdates` 0.0015480518341064
(354) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75834') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00084400177001953
(355) DESCRIBE `ports` 0.0017919540405273
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.0001981258392334
(357) DESCRIBE `ports` 0.0017318725585938
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.0010218620300293
(359) DESCRIBE `ports` 0.0012810230255127
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00038719177246094
(361) DESCRIBE `ports` 0.0016849040985107
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00035405158996582
(363) DESCRIBE `ports` 0.0023159980773926
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00039100646972656
(365) DESCRIBE `ports` 0.0017290115356445
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00090384483337402
(367) DESCRIBE `ports` 0.001561164855957
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00043606758117676
(369) DESCRIBE `ports` 0.0020079612731934
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00042414665222168
(371) DESCRIBE `ports` 0.0017919540405273
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00042009353637695
(373) DESCRIBE `ports` 0.0018839836120605
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00034213066101074
(375) DESCRIBE `ports` 0.0013771057128906
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00099611282348633
(377) DESCRIBE `ports` 0.001446008682251
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.0003509521484375
(379) DESCRIBE `avid_specials` 0.001209020614624
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75834 and class = 'Cruise') OR (item_id = 201 AND class = 'Ship') OR (item_id = 49 AND class = 'CruiseLine') OR (item_id = 49 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.0014100074768066
(381) DESCRIBE `cruiselines` 0.0024528503417969
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 49))) 0.00042486190795898
(383) DESCRIBE `orchid_image` 0.0015568733215332
(384) DESCRIBE `cruiselines` 0.0024909973144531
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '49') 0.00053191184997559
(386) DESCRIBE `cruises` 0.0030388832092285
(387) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73772') 0.00037384033203125
(388) DESCRIBE `ships` 0.0027589797973633
(389) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 286))) 0.00045084953308105
(390) DESCRIBE `ships` 0.0028760433197021
(391) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286') 0
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021100044250488
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(394) DESCRIBE `itineraries` 0.0014309883117676
(395) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73772') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00096702575683594
(396) DESCRIBE `ports` 0.001737117767334
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00036501884460449
(398) DESCRIBE `ports` 0.0013940334320068
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00032806396484375
(400) DESCRIBE `ports` 0.0018258094787598
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00028705596923828
(402) DESCRIBE `sailingdates` 0.0012068748474121
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73772') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00037598609924316
(404) DESCRIBE `ports` 0.0019309520721436
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00024104118347168
(406) DESCRIBE `ports` 0.0014867782592773
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00028896331787109
(408) DESCRIBE `ports` 0.0014197826385498
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00033307075500488
(410) DESCRIBE `ports` 0.0013129711151123
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00080609321594238
(412) DESCRIBE `ports` 0.0011401176452637
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00031781196594238
(414) DESCRIBE `ports` 0.0017759799957275
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00032806396484375
(416) DESCRIBE `ports` 0.0017409324645996
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 9.2983245849609E-5
(418) DESCRIBE `ports` 0.0018539428710938
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00087881088256836
(420) DESCRIBE `ports` 0.0018661022186279
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00038003921508789
(422) DESCRIBE `ports` 0.0014610290527344
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.0003049373626709
(424) DESCRIBE `avid_specials` 0.0014948844909668
(425) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73772 and class = 'Cruise') OR (item_id = 286 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.00148606300354
(426) DESCRIBE `cruiselines` 0.0023930072784424
(427) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00053882598876953
(428) DESCRIBE `orchid_image` 0.0018320083618164
(429) DESCRIBE `cruiselines` 0.0024120807647705
(430) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00042295455932617
(431) DESCRIBE `cruises` 0.0035419464111328
(432) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76174') 0.00047993659973145
(433) DESCRIBE `ships` 0.0035171508789062
(434) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1673))) 0.00057196617126465
(435) DESCRIBE `ships` 0.0036361217498779
(436) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1673') 0.00051403045654297
(437) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033688545227051
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035595893859863
(439) DESCRIBE `itineraries` 0.0017619132995605
(440) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '76174') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090813636779785
(441) DESCRIBE `ports` 0.00189208984375
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00034403800964355
(443) DESCRIBE `ports` 0.0014519691467285
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00037002563476562
(445) DESCRIBE `ports` 0.0018601417541504
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00039410591125488
(447) DESCRIBE `sailingdates` 0.0016059875488281
(448) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '76174') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064611434936523
(449) DESCRIBE `ports` 0.0013949871063232
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00032210350036621
(451) DESCRIBE `ports` 0.0017991065979004
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00035881996154785
(453) DESCRIBE `ports` 0.0014960765838623
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1057))) 0.00041103363037109
(455) DESCRIBE `ports` 0.0018541812896729
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1057') 0.00032496452331543
(457) DESCRIBE `ports` 0.0016298294067383
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1623))) 0.00037980079650879
(459) DESCRIBE `ports` 0.0017631053924561
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1623') 0.00039911270141602
(461) DESCRIBE `ports` 0.0016579627990723
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00040793418884277
(463) DESCRIBE `ports` 0.0017960071563721
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00038599967956543
(465) DESCRIBE `ports` 0.0018091201782227
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00040292739868164
(467) DESCRIBE `ports` 0.0016059875488281
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00039315223693848
(469) DESCRIBE `ports` 0.001762866973877
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00045585632324219
(471) DESCRIBE `ports` 0.0018260478973389
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00038790702819824
(473) DESCRIBE `ports` 0.0018889904022217
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1832))) 0.00040912628173828
(475) DESCRIBE `ports` 0.0018429756164551
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1832') 0.00037503242492676
(477) DESCRIBE `ports` 0.0018441677093506
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2930))) 0.00040006637573242
(479) DESCRIBE `ports` 0.0019121170043945
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2930') 0.00040411949157715
(481) DESCRIBE `ports` 0.0018148422241211
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00048184394836426
(483) DESCRIBE `ports` 0.0018069744110107
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00037598609924316
(485) DESCRIBE `ports` 0.0018141269683838
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00040793418884277
(487) DESCRIBE `ports` 0.0018727779388428
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00037693977355957
(489) DESCRIBE `avid_specials` 0.0015890598297119
(490) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76174 and class = 'Cruise') OR (item_id = 1673 AND class = 'Ship') OR (item_id = 114 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.0017080307006836
(491) DESCRIBE `cruiselines` 0.0026538372039795
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00046801567077637
(493) DESCRIBE `orchid_image` 0.0021860599517822
(494) DESCRIBE `cruiselines` 0.0023260116577148
(495) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00032496452331543
(496) DESCRIBE `cruises` 0.0024070739746094
(497) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78311') 0.00049400329589844
(498) DESCRIBE `ships` 0.0024621486663818
(499) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00038313865661621
(500) DESCRIBE `ships` 0.0025820732116699
(501) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.00030803680419922
(502) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026607513427734
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026106834411621
(504) DESCRIBE `itineraries` 0.0012879371643066
(505) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '78311') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00073719024658203
(506) DESCRIBE `ports` 0.0013079643249512
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00032901763916016
(508) DESCRIBE `ports` 0.0012428760528564
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00029397010803223
(510) DESCRIBE `ports` 0.0013670921325684
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00028204917907715
(512) DESCRIBE `sailingdates` 0.0011069774627686
(513) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '78311') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010941028594971
(514) DESCRIBE `ports` 0.0021920204162598
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00047087669372559
(516) DESCRIBE `ports` 0.0022950172424316
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00044512748718262
(518) DESCRIBE `ports` 0.0020129680633545
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0004580020904541
(520) DESCRIBE `ports` 0.0019509792327881
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00041985511779785
(522) DESCRIBE `ports` 0.0019810199737549
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00044894218444824
(524) DESCRIBE `ports` 0.0018749237060547
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00037312507629395
(526) DESCRIBE `ports` 0.0018508434295654
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00053787231445312
(528) DESCRIBE `ports` 0.0018630027770996
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00040578842163086
(530) DESCRIBE `ports` 0.0018048286437988
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00041913986206055
(532) DESCRIBE `ports` 0.0018289089202881
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00038695335388184
(534) DESCRIBE `ports` 0.0018279552459717
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00044012069702148
(536) DESCRIBE `ports` 0.001978874206543
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0004270076751709
(538) DESCRIBE `ports` 0.0018069744110107
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00047492980957031
(540) DESCRIBE `ports` 0.001884937286377
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00046586990356445
(542) DESCRIBE `avid_specials` 0.0015568733215332
(543) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78311 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 25 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.0017831325531006
(544) DESCRIBE `cruiselines` 0.0026929378509521
(545) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00051212310791016
(546) DESCRIBE `orchid_image` 0.0020821094512939
(547) DESCRIBE `cruiselines` 0.002734899520874
(548) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00052690505981445
(549) DESCRIBE `cruises` 0.0028328895568848
(550) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38149') 0.00034904479980469
(551) DESCRIBE `ships` 0.0027759075164795
(552) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00045108795166016
(553) DESCRIBE `ships` 0.0028460025787354
(554) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00045180320739746
(555) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00029611587524414
(556) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026893615722656
(557) DESCRIBE `itineraries` 0.0013608932495117
(558) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '38149') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00072789192199707
(559) DESCRIBE `ports` 0.0013251304626465
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00031685829162598
(561) DESCRIBE `ports` 0.0013680458068848
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00029516220092773
(563) DESCRIBE `ports` 0.0014548301696777
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00029206275939941
(565) DESCRIBE `sailingdates` 0.0011670589447021
(566) DESCRIBE `ports` 0.0018348693847656
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0003809928894043
(568) DESCRIBE `ports` 0.0012798309326172
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00031614303588867
(570) DESCRIBE `ports` 0.001439094543457
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00035500526428223
(572) DESCRIBE `ports` 0.0014359951019287
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.00035500526428223
(574) DESCRIBE `ports` 0.0012719631195068
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00029206275939941
(576) DESCRIBE `ports` 0.0013101100921631
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00026702880859375
(578) DESCRIBE `ports` 0.0014309883117676
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6058))) 0.00029301643371582
(580) DESCRIBE `ports` 0.0012459754943848
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6058') 0.00027799606323242
(582) DESCRIBE `ports` 0.0014059543609619
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00029206275939941
(584) DESCRIBE `ports` 0.0013480186462402
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00027298927307129
(586) DESCRIBE `ports` 0.001317024230957
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00033283233642578
(588) DESCRIBE `ports` 0.0014867782592773
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0003199577331543
(590) DESCRIBE `ports` 0.0013070106506348
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00031399726867676
(592) DESCRIBE `ports` 0.0016689300537109
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.00036406517028809
(594) DESCRIBE `ports` 0.00097298622131348
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0
(596) DESCRIBE `ports` 0.0014910697937012
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00028800964355469
(598) DESCRIBE `ports` 0.0013110637664795
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00045108795166016
(600) DESCRIBE `ports` 0.0014119148254395
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0
(602) DESCRIBE `ports` 0.001317024230957
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00034308433532715
(604) DESCRIBE `ports` 0.001492977142334
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00030803680419922
(606) DESCRIBE `avid_specials` 0.0012519359588623
(607) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38149 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 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.0010819435119629
(608) DESCRIBE `cruiselines` 0.0020339488983154
(609) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00093293190002441
(610) DESCRIBE `orchid_image` 0.0013680458068848
(611) DESCRIBE `cruiselines` 0.0019850730895996
(612) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00035500526428223
(613) DESCRIBE `cruiselines` 0.0023360252380371
(614) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '144', '183', '12', '23', '20', '101', '18', '8', '7', '131', '96', '171', '103', '33', '156', '120', '15', '262', '191', '29', '31', '258', '91', '208', '50', '28', '14', '187', '251', '114', '49', '212', '24', '47', '37', '206', '16', '153', '151', '36', '170', '110', '118', '181', '264', '195', '4', '30', '88', '59', '108', '159', '141', '140', '73', '35', '216', '90', '147', '211', '113', '57', '180', '64', '257', '261', '38', '48', '115', '276', '213', '184', '95', '105', '52', '82', '244', '209', '177', '134', '245')) ORDER BY FIND_IN_SET(id, '218,19,77,26,144,183,12,23,20,101,18,8,7,131,96,171,103,33,156,120,15,262,191,29,31,258,91,208,50,28,14,187,251,114,49,212,24,47,37,206,16,153,151,36,170,110,118,181,264,195,4,30,88,59,108,159,141,140,73,35,216,90,147,211,113,57,180,64,257,261,38,48,115,276,213,184,95,105,52,82,244,209,177,134,245') 0.0068421363830566
(615) DESCRIBE `ships` 0.0031518936157227
(616) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '726', '1744', '1588', '977', '517', '1594', '1555', '454', '1794', '1237', '780', '1272', '974', '1717', '1032', '1359', '258', '797', '1292', '22', '461', '21', '330', '770', '393', '404', '28', '1677', '986', '1348', '1205', '716', '1415', '349', '674', '333', '11', '10', '207', '739', '1067', '439', '521', '9', '715', '25', '24', '163', '738', '882', '3', '480', '1135', '1599', '1607', '455', '1260', '1678', '407', '553', '113', '1141', '1008', '434', '1455', '160', '766', '1773', '1682', '792', '1768', '265', '610', '817', '1569', '1742', '711', '332', '520', '1454', '352', '63', '66', '1372', '737', '1291', '626', '462', '542', '657', '1021', '1199', '585', '1308', '1721', '1738', '285', '1163', '1410', '14', '1068', '1302', '1411', '1413', '1526', '314', '526', '748', '1320', '1323', '1579', '855', '286', '390', '405', '573', '970', '1417', '34', '38', '43', '327', '582', '854', '1063', '1259', '31', '37', '590', '837', '1402', '378', '1463', '1088', '124', '1321', '1586', '580', '791', '958', '1013', '1552', '1284', '1811', '119', '162', '441', '1159', '1193', '1208', '1266', '678', '1139', '1157', '1492', '114', '1587', '1766', '401', '406', '850', '1245', '1318', '4', '335', '351', '451', '545', '616', '1028', '1412', '1672', '386', '704', '1461', '212', '547', '658', '1722', '39', '84', '722', '1236', '1326', '1327', '1782', '30', '35', '36', '148', '340', '403', '1012', '1040', '1289', '385', '988', '1330', '1398', '1408', '325', '601', '1108', '1303', '1575', '1711', '27', '287', '683', '966', '291', '652', '1043', '1172', '105', '201', '389', '508', '627', '639', '78', '818', '1168', '394', '1223', '111', '852', '1743', '338', '776', '1019', '1319', '1344', '1419', '1420', '1422', '1423', '262', '485', '751', '775', '1325', '1715', '1716', '1740', '123', '290', '673', '1029', '1160', '1217', '1282', '1343', '1418', '1421', '1424', '1452', '1453', '1801', '1037', '1229', '1426', '1604', '266', '1373', '1405', '45', '348', '701', '1095', '1226', '1704', '559', '768', '905', '1137', '1283', '1358', '1809', '253', '972', '1136', '1448', '223', '1150', '69', '341', '574', '851', '968', '98', '151', '651', '709', '973', '1409', '324', '1055', '1724', '1808', '108', '150', '643', '1230', '1231', '1458', '1474', '1501', '1713', '1730', '1767', '82', '857', '858', '954', '996', '1714', '75', '663', '769', '885', '1035', '1042', '1206', '1632', '1751', '467', '884', '1154', '1360', '1361', '1368', '1459', '1574', '1609', '1708', '1723', '1750', '666', '1049', '1362', '1772', '1148', '1322', '1483', '1771', '665', '888', '944', '423', '790', '1051', '1681', '147', '703', '717', '784', '1020', '1071', '1188', '1293', '1301', '1580', '70', '375', '1054', '152', '422', '483', '516', '707', '1075', '1224', '1486', '1601', '81', '1047', '1052', '1445', '1676', '796', '886', '937', '1036', '1572', '1679', '93', '116', '1048', '1138', '1262', '1351', '1437', '1465', '1781', '1045', '1329', '1539', '1673', '74', '149', '420', '1519', '1807', '644', '1060', '1109', '1146', '1444', '1468', '198', '503', '1039', '1050', '1143', '1196', '1232', '1350', '205', '419', '656', '1073', '1151', '1254', '1389', '1581', '1749', '1791', '795', '982', '1294', '1367', '1540', '1645', '1684', '1806', '452', '1064', '1800', '1816', '421', '761', '808', '1044', '1805', '493', '965', '1788', '479', '494', '687', '1297', '1624', '1674', '1706', '1053', '1158', '1241', '1626', '671', '883', '1156', '1195', '1316', '1571', '1709', '240', '767', '1025', '1090', '1144', '1340', '1342', '1647', '635', '695', '733', '979', '1027', '1113', '1341', '1663', '1089', '1155', '1256', '1295', '1024', '1038', '1296', '1471', '1792', '299', '300', '685', '692', '1451', '1710')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,1744,1588,977,517,1594,1555,454,1794,1237,780,1272,974,1717,1032,1359,258,797,1292,22,461,21,330,770,393,404,28,1677,986,1348,1205,716,1415,349,674,333,11,10,207,739,1067,439,521,9,715,25,24,163,738,882,3,480,1135,1599,1607,455,1260,1678,407,553,113,1141,1008,434,1455,160,766,1773,1682,792,1768,265,610,817,1569,1742,711,332,520,1454,352,63,66,1372,737,1291,626,462,542,657,1021,1199,585,1308,1721,1738,285,1163,1410,14,1068,1302,1411,1413,1526,314,526,748,1320,1323,1579,855,286,390,405,573,970,1417,34,38,43,327,582,854,1063,1259,31,37,590,837,1402,378,1463,1088,124,1321,1586,580,791,958,1013,1552,1284,1811,119,162,441,1159,1193,1208,1266,678,1139,1157,1492,114,1587,1766,401,406,850,1245,1318,4,335,351,451,545,616,1028,1412,1672,386,704,1461,212,547,658,1722,39,84,722,1236,1326,1327,1782,30,35,36,148,340,403,1012,1040,1289,385,988,1330,1398,1408,325,601,1108,1303,1575,1711,27,287,683,966,291,652,1043,1172,105,201,389,508,627,639,78,818,1168,394,1223,111,852,1743,338,776,1019,1319,1344,1419,1420,1422,1423,262,485,751,775,1325,1715,1716,1740,123,290,673,1029,1160,1217,1282,1343,1418,1421,1424,1452,1453,1801,1037,1229,1426,1604,266,1373,1405,45,348,701,1095,1226,1704,559,768,905,1137,1283,1358,1809,253,972,1136,1448,223,1150,69,341,574,851,968,98,151,651,709,973,1409,324,1055,1724,1808,108,150,643,1230,1231,1458,1474,1501,1713,1730,1767,82,857,858,954,996,1714,75,663,769,885,1035,1042,1206,1632,1751,467,884,1154,1360,1361,1368,1459,1574,1609,1708,1723,1750,666,1049,1362,1772,1148,1322,1483,1771,665,888,944,423,790,1051,1681,147,703,717,784,1020,1071,1188,1293,1301,1580,70,375,1054,152,422,483,516,707,1075,1224,1486,1601,81,1047,1052,1445,1676,796,886,937,1036,1572,1679,93,116,1048,1138,1262,1351,1437,1465,1781,1045,1329,1539,1673,74,149,420,1519,1807,644,1060,1109,1146,1444,1468,198,503,1039,1050,1143,1196,1232,1350,205,419,656,1073,1151,1254,1389,1581,1749,1791,795,982,1294,1367,1540,1645,1684,1806,452,1064,1800,1816,421,761,808,1044,1805,493,965,1788,479,494,687,1297,1624,1674,1706,1053,1158,1241,1626,671,883,1156,1195,1316,1571,1709,240,767,1025,1090,1144,1340,1342,1647,635,695,733,979,1027,1113,1341,1663,1089,1155,1256,1295,1024,1038,1296,1471,1792,299,300,685,692,1451,1710') 0.053605079650879
(617) DESCRIBE `cruisetypes` 0.0016858577728271
(618) DESCRIBE `destinations` 0.0033679008483887
(619) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '2', '37', '8', '39', '53', '26', '28', '38', '49', '55', '11', '40', '48', '7', '29', '21', '45', '44', '30', '34', '10', '52', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,2,37,8,39,53,26,28,38,49,55,11,40,48,7,29,21,45,44,30,34,10,52,46,56,32') 0.0027039051055908