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

Total elapsed time: 0.67182564735413

# Query Time
(1) connect 0.001594066619873
(2) DESCRIBE `cruises` 0.0027780532836914
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (74614, 74861, 75020, 75062, 75068, 75158, 75783, 76052, 76765, 76801)) ORDER BY FIND_IN_SET(id, '74614,74861,75020,75062,75068,75158,75783,76052,76765,76801') 0.0021471977233887
(4) DESCRIBE `cruises` 0.0037529468536377
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74614') 0.00057601928710938
(6) DESCRIBE `ships` 0.003230094909668
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00066399574279785
(8) DESCRIBE `ships` 0.0027859210968018
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00048208236694336
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036215782165527
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030708312988281
(12) DESCRIBE `itineraries` 0.0015308856964111
(13) DESCRIBE `ports` 0.0013470649719238
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00034379959106445
(15) DESCRIBE `ports` 0.0012450218200684
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00031018257141113
(17) DESCRIBE `ports` 0.0013449192047119
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00033688545227051
(19) DESCRIBE `sailingdates` 0.001115083694458
(20) DESCRIBE `ports` 0.0020959377288818
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047111511230469
(22) DESCRIBE `ports` 0.0019030570983887
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00041007995605469
(24) DESCRIBE `ports` 0.0017340183258057
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00043201446533203
(26) DESCRIBE `ports` 0.0017788410186768
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00037002563476562
(28) DESCRIBE `ports` 0.0018711090087891
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00039792060852051
(30) DESCRIBE `ports` 0.0018279552459717
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.0003969669342041
(32) DESCRIBE `ports` 0.001823902130127
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00041890144348145
(34) DESCRIBE `ports` 0.0016970634460449
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00037002563476562
(36) DESCRIBE `ports` 0.0015661716461182
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00031399726867676
(38) DESCRIBE `ports` 0.0013749599456787
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00027918815612793
(40) DESCRIBE `ports` 0.0015020370483398
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00039291381835938
(42) DESCRIBE `ports` 0.0018448829650879
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00036501884460449
(44) DESCRIBE `ports` 0.0018022060394287
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.0003960132598877
(46) DESCRIBE `ports` 0.001849889755249
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00037097930908203
(48) DESCRIBE `ports` 0.0017111301422119
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.0004570484161377
(50) DESCRIBE `ports` 0.0016429424285889
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00034499168395996
(52) DESCRIBE `avid_specials` 0.0014700889587402
(53) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74614 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018529891967773
(54) DESCRIBE `cruiselines` 0.002622127532959
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00044393539428711
(56) DESCRIBE `orchid_image` 0.0021798610687256
(57) DESCRIBE `cruiselines` 0.0027039051055908
(58) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00041317939758301
(59) DESCRIBE `cruises` 0.0026810169219971
(60) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74861') 0
(61) DESCRIBE `ships` 0.0026099681854248
(62) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1344))) 3.0994415283203E-5
(63) DESCRIBE `ships` 0.0034239292144775
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1344') 0.00035715103149414
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032997131347656
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025320053100586
(67) DESCRIBE `itineraries` 0.0020670890808105
(68) DESCRIBE `ports` 0.0014078617095947
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.0011308193206787
(70) DESCRIBE `ports` 0.001352071762085
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00042295455932617
(72) DESCRIBE `ports` 0.0015048980712891
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0003509521484375
(74) DESCRIBE `sailingdates` 0.0015280246734619
(75) DESCRIBE `ports` 0.0021538734436035
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00041699409484863
(77) DESCRIBE `ports` 0.0014781951904297
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00028300285339355
(79) DESCRIBE `ports` 0.0012671947479248
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00029206275939941
(81) DESCRIBE `ports` 0.0013351440429688
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00032901763916016
(83) DESCRIBE `ports` 0.001349925994873
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00033092498779297
(85) DESCRIBE `ports` 0.0013489723205566
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00027704238891602
(87) DESCRIBE `ports` 0.0013680458068848
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00032591819763184
(89) DESCRIBE `ports` 0.0013251304626465
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00031685829162598
(91) DESCRIBE `ports` 0.0013151168823242
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00031018257141113
(93) DESCRIBE `ports` 0.0012490749359131
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00026798248291016
(95) DESCRIBE `ports` 0.0012660026550293
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00030398368835449
(97) DESCRIBE `ports` 0.0012569427490234
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.00026988983154297
(99) DESCRIBE `ports` 0.0014488697052002
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00029397010803223
(101) DESCRIBE `ports` 0.0012929439544678
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.00026893615722656
(103) DESCRIBE `ports` 0.0012259483337402
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0002899169921875
(105) DESCRIBE `ports` 0.0013449192047119
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.0008540153503418
(107) DESCRIBE `ports` 0.00082588195800781
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00028705596923828
(109) DESCRIBE `ports` 0.0015530586242676
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00026702880859375
(111) DESCRIBE `ports` 0.001230001449585
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00028204917907715
(113) DESCRIBE `ports` 0.0012879371643066
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00026583671569824
(115) DESCRIBE `avid_specials` 0.001162052154541
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74861 and class = 'Cruise') OR (item_id = 1344 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.0013961791992188
(117) DESCRIBE `cruiselines` 0.0017609596252441
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00029897689819336
(119) DESCRIBE `orchid_image` 0.0017449855804443
(120) DESCRIBE `cruiselines` 0.0018930435180664
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00030183792114258
(122) DESCRIBE `cruises` 0.0025520324707031
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75020') 0.00031805038452148
(124) DESCRIBE `ships` 0.0026910305023193
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1343))) 0.00040197372436523
(126) DESCRIBE `ships` 0.0027430057525635
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1343') 0.00036191940307617
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002589225769043
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(130) DESCRIBE `itineraries` 0.0012900829315186
(131) DESCRIBE `ports` 0.0012869834899902
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00033402442932129
(133) DESCRIBE `ports` 0.0012431144714355
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00028896331787109
(135) DESCRIBE `ports` 0.001291036605835
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00043201446533203
(137) DESCRIBE `sailingdates` 0.0011770725250244
(138) DESCRIBE `ports` 0.001317024230957
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00033712387084961
(140) DESCRIBE `ports` 0.0014870166778564
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00027990341186523
(142) DESCRIBE `ports` 0.001410961151123
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00033783912658691
(144) DESCRIBE `ports` 0.0012481212615967
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00027799606323242
(146) DESCRIBE `ports` 0.0014121532440186
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00030612945556641
(148) DESCRIBE `ports` 0.0014040470123291
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00040793418884277
(150) DESCRIBE `ports` 0.0017960071563721
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00038480758666992
(152) DESCRIBE `ports` 0.001384973526001
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.00028800964355469
(154) DESCRIBE `ports` 0.0012550354003906
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00039100646972656
(156) DESCRIBE `ports` 0.00067806243896484
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00028681755065918
(158) DESCRIBE `ports` 0.0013678073883057
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00029802322387695
(160) DESCRIBE `ports` 0.001309871673584
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00029206275939941
(162) DESCRIBE `ports` 0.0013148784637451
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00038504600524902
(164) DESCRIBE `ports` 0.0012490749359131
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00040388107299805
(166) DESCRIBE `ports` 0.0012710094451904
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00029897689819336
(168) DESCRIBE `ports` 0.00063395500183105
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00027704238891602
(170) DESCRIBE `ports` 0.0019030570983887
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00022697448730469
(172) DESCRIBE `ports` 0.0015439987182617
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00027608871459961
(174) DESCRIBE `avid_specials` 0.0012459754943848
(175) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75020 and class = 'Cruise') OR (item_id = 1343 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.001082181930542
(176) DESCRIBE `cruiselines` 0.0023620128631592
(177) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031590461730957
(178) DESCRIBE `orchid_image` 0.0014290809631348
(179) DESCRIBE `cruiselines` 0.0017380714416504
(180) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00030088424682617
(181) DESCRIBE `cruises` 0.0025739669799805
(182) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75062') 0.00031900405883789
(183) DESCRIBE `ships` 0.0027260780334473
(184) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1090))) 0.00038909912109375
(185) DESCRIBE `ships` 0.0026841163635254
(186) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1090') 0.00038886070251465
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029087066650391
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00054311752319336
(189) DESCRIBE `itineraries` 0.001737117767334
(190) DESCRIBE `ports` 0.0016260147094727
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00034904479980469
(192) DESCRIBE `ports` 0.0017740726470947
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00034117698669434
(194) DESCRIBE `ports` 0.0014071464538574
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0003960132598877
(196) DESCRIBE `sailingdates` 0.0015699863433838
(197) DESCRIBE `ports` 0.0016751289367676
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00037407875061035
(199) DESCRIBE `ports` 0.0013167858123779
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00031399726867676
(201) DESCRIBE `ports` 0.0014321804046631
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00033783912658691
(203) DESCRIBE `ports` 0.001331090927124
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00029087066650391
(205) DESCRIBE `ports` 0.0012669563293457
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0003209114074707
(207) DESCRIBE `ports` 0.0013439655303955
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00037908554077148
(209) DESCRIBE `ports` 0.0016360282897949
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00051283836364746
(211) DESCRIBE `ports` 0.001352071762085
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.0002899169921875
(213) DESCRIBE `ports` 0.0014371871948242
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.0003359317779541
(215) DESCRIBE `ports` 0.0013430118560791
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00029897689819336
(217) DESCRIBE `ports` 0.0014820098876953
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00040888786315918
(219) DESCRIBE `ports` 0.0018670558929443
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00045180320739746
(221) DESCRIBE `ports` 0.0015239715576172
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2186))) 0.0003199577331543
(223) DESCRIBE `ports` 0.0013089179992676
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2186') 0.00031208992004395
(225) DESCRIBE `ports` 0.0013148784637451
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.0003049373626709
(227) DESCRIBE `ports` 0.0018429756164551
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00036215782165527
(229) DESCRIBE `ports` 0.0014190673828125
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00030517578125
(231) DESCRIBE `ports` 0.0013439655303955
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00034713745117188
(233) DESCRIBE `avid_specials` 0.0011210441589355
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75062 and class = 'Cruise') OR (item_id = 1090 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.0011529922485352
(235) DESCRIBE `cruiselines` 0.0018680095672607
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00033402442932129
(237) DESCRIBE `orchid_image` 0.0014159679412842
(238) DESCRIBE `cruiselines` 0.0019440650939941
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00029611587524414
(240) DESCRIBE `cruises` 0.0027909278869629
(241) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75068') 0.00034499168395996
(242) DESCRIBE `ships` 0.0026931762695312
(243) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1025))) 0.00039911270141602
(244) DESCRIBE `ships` 0.0028719902038574
(245) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1025') 0.00029802322387695
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027012825012207
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025105476379395
(248) DESCRIBE `itineraries` 0.0014181137084961
(249) DESCRIBE `ports` 0.0014009475708008
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00033116340637207
(251) DESCRIBE `ports` 0.0012898445129395
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00033116340637207
(253) DESCRIBE `ports` 0.0012991428375244
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00028395652770996
(255) DESCRIBE `sailingdates` 0.0012481212615967
(256) DESCRIBE `ports` 0.0015819072723389
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00037598609924316
(258) DESCRIBE `ports` 0.0014450550079346
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00037598609924316
(260) DESCRIBE `ports` 0.0017378330230713
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2186))) 0.00046896934509277
(262) DESCRIBE `ports` 0.0018749237060547
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2186') 0.00035500526428223
(264) DESCRIBE `ports` 0.0013649463653564
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00033688545227051
(266) DESCRIBE `ports` 0.0012691020965576
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00044989585876465
(268) DESCRIBE `ports` 0.0012829303741455
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1573))) 0.00032186508178711
(270) DESCRIBE `ports` 0.0013570785522461
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1573') 0.00027298927307129
(272) DESCRIBE `ports` 0.0014579296112061
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00029993057250977
(274) DESCRIBE `ports` 0.0012569427490234
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00027108192443848
(276) DESCRIBE `ports` 0.00076913833618164
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00031709671020508
(278) DESCRIBE `ports` 0.0013291835784912
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00027894973754883
(280) DESCRIBE `ports` 0.0014598369598389
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00038599967956543
(282) DESCRIBE `ports` 0.0018579959869385
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00030112266540527
(284) DESCRIBE `ports` 0.0020058155059814
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0
(286) DESCRIBE `ports` 0.0010502338409424
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00047087669372559
(288) DESCRIBE `ports` 0.001823902130127
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00041103363037109
(290) DESCRIBE `ports` 0.0016729831695557
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00030207633972168
(292) DESCRIBE `ports` 0.0013139247894287
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00033187866210938
(294) DESCRIBE `ports` 0.0013267993927002
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00037407875061035
(296) DESCRIBE `avid_specials` 0.0012869834899902
(297) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75068 and class = 'Cruise') OR (item_id = 1025 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.0010828971862793
(298) DESCRIBE `cruiselines` 0.0019700527191162
(299) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031614303588867
(300) DESCRIBE `orchid_image` 0.00142502784729
(301) DESCRIBE `cruiselines` 0.0018291473388672
(302) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00028586387634277
(303) DESCRIBE `cruises` 0.0029280185699463
(304) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75158') 0
(305) DESCRIBE `ships` 0.0037720203399658
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 28))) 0.00046205520629883
(307) DESCRIBE `ships` 0.0024449825286865
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '28') 0
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026512145996094
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026416778564453
(311) DESCRIBE `itineraries` 0.0014910697937012
(312) DESCRIBE `ports` 0.0014169216156006
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0.00039196014404297
(314) DESCRIBE `ports` 0.001291036605835
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0.00028109550476074
(316) DESCRIBE `ports` 0.0013489723205566
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5609') 0.00086808204650879
(318) DESCRIBE `sailingdates` 0.0011827945709229
(319) DESCRIBE `ports` 0.0018219947814941
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0.0013141632080078
(321) DESCRIBE `ports` 0.0015220642089844
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5609') 0.00031304359436035
(323) DESCRIBE `ports` 0.0015289783477783
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00041699409484863
(325) DESCRIBE `ports` 0.0014710426330566
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00040292739868164
(327) DESCRIBE `ports` 0.0012600421905518
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00032901763916016
(329) DESCRIBE `ports` 0.0014009475708008
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00032997131347656
(331) DESCRIBE `ports` 0.0016899108886719
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00042200088500977
(333) DESCRIBE `ports` 0.0017359256744385
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00069785118103027
(335) DESCRIBE `ports` 0.0016000270843506
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00036287307739258
(337) DESCRIBE `ports` 0.0014059543609619
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00028896331787109
(339) DESCRIBE `ports` 0.0012500286102295
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00032806396484375
(341) DESCRIBE `ports` 0.0012640953063965
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00027704238891602
(343) DESCRIBE `ports` 0.0017828941345215
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0.00038409233093262
(345) DESCRIBE `ports` 0.0014657974243164
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5609') 0.00026512145996094
(347) DESCRIBE `avid_specials` 0.0011229515075684
(348) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75158 and class = 'Cruise') OR (item_id = 28 AND class = 'Ship') OR (item_id = 218 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.0010409355163574
(349) DESCRIBE `cruiselines` 0.0027239322662354
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00048494338989258
(351) DESCRIBE `orchid_image` 0.0015130043029785
(352) DESCRIBE `cruiselines` 0.0018610954284668
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00030303001403809
(354) DESCRIBE `cruises` 0.0026590824127197
(355) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75783') 0.00032711029052734
(356) DESCRIBE `ships` 0.0027329921722412
(357) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1389))) 0.0004429817199707
(358) DESCRIBE `ships` 0.0026419162750244
(359) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1389') 0.00036191940307617
(360) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003809928894043
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028491020202637
(362) DESCRIBE `itineraries` 0.0013048648834229
(363) DESCRIBE `ports` 0.0015058517456055
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00040984153747559
(365) DESCRIBE `ports` 0.00130295753479
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00032401084899902
(367) DESCRIBE `ports` 0.0014331340789795
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00037097930908203
(369) DESCRIBE `sailingdates` 0.0015461444854736
(370) DESCRIBE `ports` 0.0018601417541504
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0004429817199707
(372) DESCRIBE `ports` 0.0018081665039062
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0004119873046875
(374) DESCRIBE `ports` 0.0018558502197266
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00040197372436523
(376) DESCRIBE `ports` 0.0022389888763428
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00037503242492676
(378) DESCRIBE `ports` 0.0019021034240723
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5419))) 2.8610229492188E-6
(380) DESCRIBE `ports` 0.0017600059509277
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5419') 0.0010080337524414
(382) DESCRIBE `ports` 0.0014090538024902
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2944))) 0.00041484832763672
(384) DESCRIBE `ports` 0.0025570392608643
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2944') 0.00034594535827637
(386) DESCRIBE `ports` 0.00164794921875
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00039100646972656
(388) DESCRIBE `ports` 0.0012600421905518
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00026988983154297
(390) DESCRIBE `ports` 0.0013599395751953
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00042295455932617
(392) DESCRIBE `ports` 0.0017349720001221
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.0003669261932373
(394) DESCRIBE `ports` 0.0013110637664795
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00032305717468262
(396) DESCRIBE `ports` 0.001615047454834
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00028705596923828
(398) DESCRIBE `ports` 0.0013418197631836
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0003209114074707
(400) DESCRIBE `ports` 0.0013120174407959
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027704238891602
(402) DESCRIBE `avid_specials` 0.0011758804321289
(403) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75783 and class = 'Cruise') OR (item_id = 1389 AND class = 'Ship') OR (item_id = 141 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.0012209415435791
(404) DESCRIBE `cruiselines` 0.0019299983978271
(405) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.00034594535827637
(406) DESCRIBE `orchid_image` 0.0015380382537842
(407) DESCRIBE `cruiselines` 0.00180983543396
(408) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00029492378234863
(409) DESCRIBE `cruises` 0.0035679340362549
(410) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76052') 0.00034880638122559
(411) DESCRIBE `ships` 0.002734899520874
(412) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 420))) 0.00049209594726562
(413) DESCRIBE `ships` 0.0031859874725342
(414) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '420') 0.00096583366394043
(415) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 9.5129013061523E-5
(416) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002601146697998
(417) DESCRIBE `itineraries` 0.0014729499816895
(418) DESCRIBE `ports` 0.0017020702362061
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00044703483581543
(420) DESCRIBE `ports` 0.00074291229248047
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00031280517578125
(422) DESCRIBE `ports` 0.0015139579772949
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00037503242492676
(424) DESCRIBE `sailingdates` 0.0015029907226562
(425) DESCRIBE `ports` 0.0016210079193115
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00099396705627441
(427) DESCRIBE `ports` 0.00094509124755859
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00029182434082031
(429) DESCRIBE `ports` 0.0021049976348877
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00037407875061035
(431) DESCRIBE `ports` 0.0015690326690674
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00037217140197754
(433) DESCRIBE `ports` 0.0015220642089844
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00038504600524902
(435) DESCRIBE `ports` 0.0015740394592285
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00033998489379883
(437) DESCRIBE `ports` 0.0015580654144287
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00032305717468262
(439) DESCRIBE `ports` 0.0015029907226562
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0
(441) DESCRIBE `ports` 0.001162052154541
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00039410591125488
(443) DESCRIBE `ports` 0.0018951892852783
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00011396408081055
(445) DESCRIBE `ports` 0.0013968944549561
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1591))) 0.00040602684020996
(447) DESCRIBE `ports` 0.0010561943054199
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1591') 0.00033998489379883
(449) DESCRIBE `ports` 0.001676082611084
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00034594535827637
(451) DESCRIBE `ports` 0.0012800693511963
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00027990341186523
(453) DESCRIBE `ports` 0.0013020038604736
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0003058910369873
(455) DESCRIBE `ports` 0.0012691020965576
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00029897689819336
(457) DESCRIBE `ports` 0.0016021728515625
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00035381317138672
(459) DESCRIBE `ports` 0.0015208721160889
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00032496452331543
(461) DESCRIBE `avid_specials` 0.001147985458374
(462) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76052 and class = 'Cruise') OR (item_id = 420 AND class = 'Ship') OR (item_id = 96 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.0010871887207031
(463) DESCRIBE `cruiselines` 0.0019350051879883
(464) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00035905838012695
(465) DESCRIBE `orchid_image` 0.0015468597412109
(466) DESCRIBE `cruiselines` 0.0018570423126221
(467) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00036191940307617
(468) DESCRIBE `cruises` 0.0026290416717529
(469) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76765') 0.00033307075500488
(470) DESCRIBE `ships` 0.0026659965515137
(471) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00037193298339844
(472) DESCRIBE `ships` 0.002694845199585
(473) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00028395652770996
(474) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00099396705627441
(475) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(476) DESCRIBE `itineraries` 0.0011589527130127
(477) DESCRIBE `ports` 0.0013129711151123
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00030708312988281
(479) DESCRIBE `ports` 0.0012469291687012
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00033903121948242
(481) DESCRIBE `ports` 0.00065803527832031
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00028586387634277
(483) DESCRIBE `sailingdates` 0.0011329650878906
(484) DESCRIBE `ports` 0.0015528202056885
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00034499168395996
(486) DESCRIBE `ports` 0.0012989044189453
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00030398368835449
(488) DESCRIBE `ports` 0.0012469291687012
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0003199577331543
(490) DESCRIBE `ports` 0.0012860298156738
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00026416778564453
(492) DESCRIBE `ports` 0.0012850761413574
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034999847412109
(494) DESCRIBE `ports` 0.0013699531555176
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027894973754883
(496) DESCRIBE `ports` 0.001378059387207
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00031208992004395
(498) DESCRIBE `ports` 0.0014328956604004
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0003359317779541
(500) DESCRIBE `ports` 0.0023908615112305
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00031590461730957
(502) DESCRIBE `ports` 0.0013940334320068
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00027108192443848
(504) DESCRIBE `ports` 0.0012800693511963
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00029706954956055
(506) DESCRIBE `ports` 0.0013689994812012
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00026798248291016
(508) DESCRIBE `ports` 0.001255989074707
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00032591819763184
(510) DESCRIBE `ports` 0.0013668537139893
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00027608871459961
(512) DESCRIBE `ports` 0.001262903213501
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00028705596923828
(514) DESCRIBE `ports` 0.0013620853424072
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027704238891602
(516) DESCRIBE `avid_specials` 0.0012252330780029
(517) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76765 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 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.001054048538208
(518) DESCRIBE `cruiselines` 0.0018248558044434
(519) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034022331237793
(520) DESCRIBE `orchid_image` 0.0014050006866455
(521) DESCRIBE `cruiselines` 0.0018420219421387
(522) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 9.8943710327148E-5
(523) DESCRIBE `cruises` 0.0028378963470459
(524) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76801') 0.00032901763916016
(525) DESCRIBE `ships` 0.0026528835296631
(526) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00037789344787598
(527) DESCRIBE `ships` 0.0026459693908691
(528) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00027680397033691
(529) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(530) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029897689819336
(531) DESCRIBE `itineraries` 0.0016529560089111
(532) DESCRIBE `ports` 0.001488208770752
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00038695335388184
(534) DESCRIBE `ports` 0.0016460418701172
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00038790702819824
(536) DESCRIBE `ports` 0.0016298294067383
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00035595893859863
(538) DESCRIBE `sailingdates` 0.0015280246734619
(539) DESCRIBE `ports` 0.0019729137420654
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00046396255493164
(541) DESCRIBE `ports` 0.0019130706787109
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0003669261932373
(543) DESCRIBE `ports` 0.0018389225006104
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00039911270141602
(545) DESCRIBE `ports` 0.0018100738525391
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00037002563476562
(547) DESCRIBE `ports` 0.0018160343170166
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00042009353637695
(549) DESCRIBE `ports` 0.0017960071563721
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00036406517028809
(551) DESCRIBE `ports` 0.001788854598999
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00039100646972656
(553) DESCRIBE `ports` 0.0017209053039551
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00034284591674805
(555) DESCRIBE `ports` 0.0018131732940674
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00040292739868164
(557) DESCRIBE `ports` 0.0016419887542725
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00034904479980469
(559) DESCRIBE `ports` 0.001762866973877
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00060415267944336
(561) DESCRIBE `ports` 0.0018301010131836
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00035786628723145
(563) DESCRIBE `ports` 0.0017199516296387
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00041794776916504
(565) DESCRIBE `ports` 0.0017039775848389
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0003659725189209
(567) DESCRIBE `ports` 0.0017790794372559
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00045609474182129
(569) DESCRIBE `ports` 0.0018439292907715
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00034809112548828
(571) DESCRIBE `avid_specials` 0.0015408992767334
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76801 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 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.00177001953125
(573) DESCRIBE `cruiselines` 0.0024359226226807
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00044608116149902
(575) DESCRIBE `orchid_image` 0.0021791458129883
(576) DESCRIBE `cruiselines` 0.0025680065155029
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00044488906860352
(578) DESCRIBE `cruiselines` 0.0028889179229736
(579) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '144', '183', '12', '23', '20', '101', '18', '7', '8', '131', '96', '171', '103', '156', '33', '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,7,8,131,96,171,103,156,33,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.0062050819396973
(580) DESCRIBE `ships` 0.0039980411529541
(581) 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', '439', '739', '1067', '9', '521', '715', '25', '24', '163', '480', '738', '882', '3', '1135', '1599', '1607', '455', '1260', '1678', '407', '553', '113', '1141', '1008', '434', '1455', '160', '766', '1773', '1682', '265', '792', '1768', '610', '817', '1569', '1742', '711', '332', '520', '1454', '352', '63', '66', '1372', '737', '1291', '626', '462', '542', '657', '1021', '1199', '585', '1308', '1721', '1738', '1068', '285', '1163', '1410', '14', '1302', '1411', '1413', '1526', '748', '314', '526', '1320', '1323', '1579', '855', '286', '390', '405', '573', '970', '1063', '1417', '31', '34', '38', '43', '327', '582', '854', '1259', '37', '590', '837', '1402', '378', '1463', '1088', '124', '1321', '1586', '580', '791', '958', '1013', '1208', '1552', '1284', '1811', '119', '162', '441', '1159', '1193', '1266', '678', '1139', '1157', '114', '1492', '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', '1424', '1740', '1743', '338', '776', '1019', '1319', '1344', '1419', '1420', '1422', '1423', '262', '485', '751', '775', '1325', '1715', '1716', '123', '290', '673', '1029', '1160', '1217', '1343', '1418', '1421', '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', '1282', '69', '341', '574', '709', '851', '968', '98', '151', '651', '973', '1409', '324', '643', '1055', '1724', '1808', '108', '150', '857', '1230', '1231', '1458', '1474', '1501', '1713', '1730', '1767', '82', '663', '858', '954', '996', '1714', '75', '769', '885', '1035', '1042', '1154', '1206', '1368', '1609', '1632', '1751', '467', '666', '884', '1360', '1361', '1362', '1459', '1574', '1708', '1723', '1750', '1049', '1772', '1148', '1322', '1483', '1771', '665', '888', '944', '375', '423', '703', '790', '1051', '1681', '147', '717', '784', '1020', '1071', '1188', '1293', '1301', '1580', '70', '1054', '1601', '152', '422', '483', '516', '707', '1075', '1224', '1445', '1486', '81', '1047', '1052', '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', '656', '1039', '1050', '1143', '1196', '1232', '1350', '205', '419', '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', '671', '1053', '1158', '1241', '1626', '1709', '883', '1156', '1195', '1316', '1571', '240', '767', '1025', '1090', '1144', '1340', '1342', '1647', '635', '695', '733', '979', '1027', '1113', '1341', '1663', '1089', '1155', '1256', '1295', '1024', '1038', '1296', '1471', '1710', '1792', '299', '300', '685', '692', '1451')) 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,439,739,1067,9,521,715,25,24,163,480,738,882,3,1135,1599,1607,455,1260,1678,407,553,113,1141,1008,434,1455,160,766,1773,1682,265,792,1768,610,817,1569,1742,711,332,520,1454,352,63,66,1372,737,1291,626,462,542,657,1021,1199,585,1308,1721,1738,1068,285,1163,1410,14,1302,1411,1413,1526,748,314,526,1320,1323,1579,855,286,390,405,573,970,1063,1417,31,34,38,43,327,582,854,1259,37,590,837,1402,378,1463,1088,124,1321,1586,580,791,958,1013,1208,1552,1284,1811,119,162,441,1159,1193,1266,678,1139,1157,114,1492,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,1424,1740,1743,338,776,1019,1319,1344,1419,1420,1422,1423,262,485,751,775,1325,1715,1716,123,290,673,1029,1160,1217,1343,1418,1421,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,1282,69,341,574,709,851,968,98,151,651,973,1409,324,643,1055,1724,1808,108,150,857,1230,1231,1458,1474,1501,1713,1730,1767,82,663,858,954,996,1714,75,769,885,1035,1042,1154,1206,1368,1609,1632,1751,467,666,884,1360,1361,1362,1459,1574,1708,1723,1750,1049,1772,1148,1322,1483,1771,665,888,944,375,423,703,790,1051,1681,147,717,784,1020,1071,1188,1293,1301,1580,70,1054,1601,152,422,483,516,707,1075,1224,1445,1486,81,1047,1052,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,656,1039,1050,1143,1196,1232,1350,205,419,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,671,1053,1158,1241,1626,1709,883,1156,1195,1316,1571,240,767,1025,1090,1144,1340,1342,1647,635,695,733,979,1027,1113,1341,1663,1089,1155,1256,1295,1024,1038,1296,1471,1710,1792,299,300,685,692,1451') 0.048474073410034
(582) DESCRIBE `cruisetypes` 0.0015528202056885
(583) DESCRIBE `destinations` 0.003075122833252
(584) 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.0035789012908936