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

Total elapsed time: 0.66678309440613

# Query Time
(1) connect 0.0013458728790283
(2) DESCRIBE `cruises` 0.0029959678649902
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75068, 75158, 75783, 76052, 76765, 76801, 77033, 77284, 78576, 78581)) ORDER BY FIND_IN_SET(id, '75068,75158,75783,76052,76765,76801,77033,77284,78576,78581') 0.0029489994049072
(4) DESCRIBE `cruises` 0.0025599002838135
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75068') 0.00037980079650879
(6) DESCRIBE `ships` 0.0025639533996582
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1025))) 0.00035691261291504
(8) DESCRIBE `ships` 0.0030539035797119
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1025') 0.00032687187194824
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026392936706543
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(12) DESCRIBE `itineraries` 0.0010759830474854
(13) DESCRIBE `ports` 0.00130295753479
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00034785270690918
(15) DESCRIBE `ports` 0.0012590885162354
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00088191032409668
(17) DESCRIBE `ports` 0.00096797943115234
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00027585029602051
(19) DESCRIBE `sailingdates` 0.0011320114135742
(20) DESCRIBE `ports` 0.0018761157989502
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 2.3126602172852E-5
(22) DESCRIBE `ports` 0.002453088760376
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0003199577331543
(24) DESCRIBE `ports` 0.0018730163574219
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2186))) 0.00040388107299805
(26) DESCRIBE `ports` 0.0018241405487061
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2186') 0.00034809112548828
(28) DESCRIBE `ports` 0.0017471313476562
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00038313865661621
(30) DESCRIBE `ports` 0.0017378330230713
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.0003349781036377
(32) DESCRIBE `ports` 0.0017759799957275
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1573))) 0.00038385391235352
(34) DESCRIBE `ports` 0.0017838478088379
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1573') 0.00034999847412109
(36) DESCRIBE `ports` 0.0017340183258057
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00037813186645508
(38) DESCRIBE `ports` 0.0017268657684326
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00037598609924316
(40) DESCRIBE `ports` 0.0017979145050049
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00039887428283691
(42) DESCRIBE `ports` 0.0018069744110107
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00035285949707031
(44) DESCRIBE `ports` 0.0017328262329102
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0003819465637207
(46) DESCRIBE `ports` 0.001723051071167
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00034999847412109
(48) DESCRIBE `ports` 0.0018091201782227
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0003809928894043
(50) DESCRIBE `ports` 0.0017859935760498
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00036096572875977
(52) DESCRIBE `ports` 0.0016341209411621
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00037097930908203
(54) DESCRIBE `ports` 0.0015110969543457
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00031805038452148
(56) DESCRIBE `ports` 0.0015320777893066
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00034713745117188
(58) DESCRIBE `ports` 0.0017721652984619
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00035810470581055
(60) DESCRIBE `avid_specials` 0.0015420913696289
(61) 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.0016889572143555
(62) DESCRIBE `cruiselines` 0.0026450157165527
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.0004270076751709
(64) DESCRIBE `orchid_image` 0.0019888877868652
(65) DESCRIBE `cruiselines` 0.0025441646575928
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00037503242492676
(67) DESCRIBE `cruises` 0.0034339427947998
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75158') 0.00042295455932617
(69) DESCRIBE `ships` 0.0035679340362549
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 28))) 0.00051999092102051
(71) DESCRIBE `ships` 0.0035569667816162
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '28') 0.00040912628173828
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034213066101074
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033116340637207
(75) DESCRIBE `itineraries` 0.0018770694732666
(76) DESCRIBE `ports` 0.0019190311431885
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0.00043201446533203
(78) DESCRIBE `ports` 0.0018360614776611
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0.00036883354187012
(80) DESCRIBE `ports` 0.001755952835083
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5609') 0.00035285949707031
(82) DESCRIBE `sailingdates` 0.00154709815979
(83) DESCRIBE `ports` 0.0021858215332031
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0.00041294097900391
(85) DESCRIBE `ports` 0.001716136932373
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5609') 0.00033998489379883
(87) DESCRIBE `ports` 0.0017309188842773
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0003821849822998
(89) DESCRIBE `ports` 0.0017299652099609
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00034999847412109
(91) DESCRIBE `ports` 0.0017201900482178
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00039792060852051
(93) DESCRIBE `ports` 0.0018229484558105
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00036096572875977
(95) DESCRIBE `ports` 0.0017809867858887
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00043797492980957
(97) DESCRIBE `ports` 0.0014541149139404
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00026392936706543
(99) DESCRIBE `ports` 0.00037693977355957
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00034284591674805
(101) DESCRIBE `ports` 0.0012259483337402
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.0011270046234131
(103) DESCRIBE `ports` 0.00074410438537598
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.0002899169921875
(105) DESCRIBE `ports` 0.0022389888763428
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00037503242492676
(107) DESCRIBE `ports` 0.001835823059082
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0
(109) DESCRIBE `ports` 0.0018241405487061
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5609') 0.00045609474182129
(111) DESCRIBE `avid_specials` 0.0011301040649414
(112) 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.0023910999298096
(113) DESCRIBE `cruiselines` 0.0021519660949707
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0
(115) DESCRIBE `orchid_image` 0.0018930435180664
(116) DESCRIBE `cruiselines` 0.0019979476928711
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0015320777893066
(118) DESCRIBE `cruises` 0.0028550624847412
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75783') 0.00031113624572754
(120) DESCRIBE `ships` 0.002586841583252
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1389))) 0.00042104721069336
(122) DESCRIBE `ships` 0.0027329921722412
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1389') 0.00043797492980957
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031018257141113
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025081634521484
(126) DESCRIBE `itineraries` 0.0014100074768066
(127) DESCRIBE `ports` 0.0014300346374512
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00032401084899902
(129) DESCRIBE `ports` 0.0013201236724854
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00029301643371582
(131) DESCRIBE `ports` 0.0013620853424072
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00028395652770996
(133) DESCRIBE `sailingdates` 0.0011038780212402
(134) DESCRIBE `ports` 0.0014021396636963
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00041484832763672
(136) DESCRIBE `ports` 0.0014171600341797
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00028204917907715
(138) DESCRIBE `ports` 0.0012350082397461
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00029897689819336
(140) DESCRIBE `ports` 0.001317024230957
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00027894973754883
(142) DESCRIBE `ports` 0.0012331008911133
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5419))) 0.00028800964355469
(144) DESCRIBE `ports` 0.0012550354003906
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5419') 0.00026798248291016
(146) DESCRIBE `ports` 0.0012381076812744
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2944))) 0.00026297569274902
(148) DESCRIBE `ports` 0.0018758773803711
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2944') 0.00040912628173828
(150) DESCRIBE `ports` 0.0011749267578125
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0004429817199707
(152) DESCRIBE `ports` 0.0016651153564453
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00028514862060547
(154) DESCRIBE `ports` 0.0012409687042236
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00090408325195312
(156) DESCRIBE `ports` 0.0009009838104248
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.0002751350402832
(158) DESCRIBE `ports` 0.0012409687042236
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0
(160) DESCRIBE `ports` 0.0012609958648682
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0002748966217041
(162) DESCRIBE `ports` 0.0019481182098389
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 5.793571472168E-5
(164) DESCRIBE `ports` 0.0012600421905518
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027298927307129
(166) DESCRIBE `avid_specials` 0.0015008449554443
(167) 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.0010600090026855
(168) DESCRIBE `cruiselines` 0.0025830268859863
(169) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 8.4161758422852E-5
(170) DESCRIBE `orchid_image` 0.0013818740844727
(171) DESCRIBE `cruiselines` 0.0017819404602051
(172) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00027298927307129
(173) DESCRIBE `cruises` 0.0024209022521973
(174) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76052') 0.00034689903259277
(175) DESCRIBE `ships` 0.0025629997253418
(176) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 420))) 0.00033903121948242
(177) DESCRIBE `ships` 0.0024919509887695
(178) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '420') 0.00027704238891602
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026583671569824
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032687187194824
(181) DESCRIBE `itineraries` 0.0013980865478516
(182) DESCRIBE `ports` 0.0012919902801514
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00030708312988281
(184) DESCRIBE `ports` 0.0012409687042236
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00028800964355469
(186) DESCRIBE `ports` 0.001345157623291
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00029897689819336
(188) DESCRIBE `sailingdates` 0.0011491775512695
(189) DESCRIBE `ports` 0.0013360977172852
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00030803680419922
(191) DESCRIBE `ports` 0.0012650489807129
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00027704238891602
(193) DESCRIBE `ports` 0.0012428760528564
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.0002899169921875
(195) DESCRIBE `ports` 0.0014050006866455
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00028705596923828
(197) DESCRIBE `ports` 0.00085806846618652
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00032210350036621
(199) DESCRIBE `ports` 0.0014851093292236
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00028014183044434
(201) DESCRIBE `ports` 0.0015518665313721
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00092911720275879
(203) DESCRIBE `ports` 0.00089001655578613
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.00030207633972168
(205) DESCRIBE `ports` 0.0013468265533447
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0
(207) DESCRIBE `ports` 0.0012590885162354
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00028491020202637
(209) DESCRIBE `ports` 0.0018811225891113
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1591))) 8.082389831543E-5
(211) DESCRIBE `ports` 0.0012869834899902
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1591') 0.0002739429473877
(213) DESCRIBE `ports` 0.0015108585357666
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00029802322387695
(215) DESCRIBE `ports` 0.0012829303741455
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00032711029052734
(217) DESCRIBE `ports` 0.001255989074707
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00029206275939941
(219) DESCRIBE `ports` 0.001230001449585
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00026893615722656
(221) DESCRIBE `ports` 0.0012979507446289
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00031423568725586
(223) DESCRIBE `ports` 0.0012829303741455
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00028109550476074
(225) DESCRIBE `avid_specials` 0.0011370182037354
(226) 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.0010309219360352
(227) DESCRIBE `cruiselines` 0.001953125
(228) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00032615661621094
(229) DESCRIBE `orchid_image` 0.0013930797576904
(230) DESCRIBE `cruiselines` 0.0017900466918945
(231) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00028896331787109
(232) DESCRIBE `cruises` 0.0025618076324463
(233) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76765') 0.0003058910369873
(234) DESCRIBE `ships` 0.0025250911712646
(235) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00034403800964355
(236) DESCRIBE `ships` 0.002479076385498
(237) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00028085708618164
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029087066650391
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(240) DESCRIBE `itineraries` 0.001237154006958
(241) DESCRIBE `ports` 0.0013589859008789
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031208992004395
(243) DESCRIBE `ports` 0.0012781620025635
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029897689819336
(245) DESCRIBE `ports` 0.0013711452484131
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0002739429473877
(247) DESCRIBE `sailingdates` 0.0011351108551025
(248) DESCRIBE `ports` 0.0013549327850342
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031089782714844
(250) DESCRIBE `ports` 0.0014011859893799
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027894973754883
(252) DESCRIBE `ports` 0.0013220310211182
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00031590461730957
(254) DESCRIBE `ports` 0.0016839504241943
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00030303001403809
(256) DESCRIBE `ports` 0.0013020038604736
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030398368835449
(258) DESCRIBE `ports` 0.0013902187347412
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028395652770996
(260) DESCRIBE `ports` 0.0012531280517578
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00031304359436035
(262) DESCRIBE `ports` 0.0012660026550293
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00029087066650391
(264) DESCRIBE `ports` 0.0012528896331787
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.0003049373626709
(266) DESCRIBE `ports` 0.0013318061828613
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00028300285339355
(268) DESCRIBE `ports` 0.0013439655303955
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00038695335388184
(270) DESCRIBE `ports` 0.0013439655303955
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00028300285339355
(272) DESCRIBE `ports` 0.0015208721160889
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00034189224243164
(274) DESCRIBE `ports` 0.0014579296112061
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00032782554626465
(276) DESCRIBE `ports` 0.0013291835784912
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00035190582275391
(278) DESCRIBE `ports` 0.0013899803161621
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00030303001403809
(280) DESCRIBE `avid_specials` 0.0009758472442627
(281) 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.0016069412231445
(282) DESCRIBE `cruiselines` 0.0018501281738281
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.001168966293335
(284) DESCRIBE `orchid_image` 0.0013411045074463
(285) DESCRIBE `cruiselines` 0.0019030570983887
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00038695335388184
(287) DESCRIBE `cruises` 0.0025131702423096
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76801') 0.00043010711669922
(289) DESCRIBE `ships` 0.0025320053100586
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00038909912109375
(291) DESCRIBE `ships` 0.0024130344390869
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00028109550476074
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00090408325195312
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(295) DESCRIBE `itineraries` 0.0012221336364746
(296) DESCRIBE `ports` 0.0014321804046631
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00032186508178711
(298) DESCRIBE `ports` 0.0016071796417236
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 4.0054321289062E-5
(300) DESCRIBE `ports` 0.0013229846954346
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00028586387634277
(302) DESCRIBE `sailingdates` 0.0013570785522461
(303) DESCRIBE `ports` 0.00069212913513184
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00034213066101074
(305) DESCRIBE `ports` 0.0021629333496094
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0
(307) DESCRIBE `ports` 0.001284122467041
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00028800964355469
(309) DESCRIBE `ports` 0.0014181137084961
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00027203559875488
(311) DESCRIBE `ports` 0.0014030933380127
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00038695335388184
(313) DESCRIBE `ports` 0.00072979927062988
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027799606323242
(315) DESCRIBE `ports` 0.0012471675872803
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0
(317) DESCRIBE `ports` 0.001291036605835
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00026178359985352
(319) DESCRIBE `ports` 0.0019059181213379
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00019717216491699
(321) DESCRIBE `ports` 0.0014519691467285
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00026988983154297
(323) DESCRIBE `ports` 0.0012979507446289
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.0003349781036377
(325) DESCRIBE `ports` 0.0012819766998291
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00034809112548828
(327) DESCRIBE `ports` 0.002263069152832
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031280517578125
(329) DESCRIBE `ports` 0.0014541149139404
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00027918815612793
(331) DESCRIBE `ports` 0.001291036605835
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031399726867676
(333) DESCRIBE `ports` 0.0012421607971191
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027799606323242
(335) DESCRIBE `avid_specials` 0.0011780261993408
(336) 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.0010168552398682
(337) DESCRIBE `cruiselines` 0.0021708011627197
(338) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034999847412109
(339) DESCRIBE `orchid_image` 0.0014960765838623
(340) DESCRIBE `cruiselines` 0.0023829936981201
(341) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00050997734069824
(342) DESCRIBE `cruises` 0.0034689903259277
(343) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77033') 0.00038385391235352
(344) DESCRIBE `ships` 0.0030241012573242
(345) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1731))) 0.00043797492980957
(346) DESCRIBE `ships` 0.0024929046630859
(347) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1731') 0.0003058910369873
(348) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002589225769043
(349) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025105476379395
(350) DESCRIBE `itineraries` 0.001276969909668
(351) DESCRIBE `ports` 0.0013179779052734
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00031399726867676
(353) DESCRIBE `ports` 0.0012891292572021
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00029087066650391
(355) DESCRIBE `ports` 0.0012459754943848
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00028610229492188
(357) DESCRIBE `sailingdates` 0.0011239051818848
(358) DESCRIBE `ports` 0.0012738704681396
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030303001403809
(360) DESCRIBE `ports` 0.0012807846069336
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00028300285339355
(362) DESCRIBE `ports` 0.0012691020965576
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.0003199577331543
(364) DESCRIBE `ports` 0.0013291835784912
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00027894973754883
(366) DESCRIBE `ports` 0.0013060569763184
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5419))) 0.00029301643371582
(368) DESCRIBE `ports` 0.0012390613555908
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5419') 0.00026488304138184
(370) DESCRIBE `ports` 0.0012829303741455
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5099))) 0.0003209114074707
(372) DESCRIBE `ports` 0.0012648105621338
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5099') 0.00036382675170898
(374) DESCRIBE `ports` 0.0012588500976562
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2944))) 0.00030303001403809
(376) DESCRIBE `ports` 0.0013129711151123
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2944') 0.00028300285339355
(378) DESCRIBE `ports` 0.0014700889587402
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00039505958557129
(380) DESCRIBE `ports` 0.0016820430755615
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00047612190246582
(382) DESCRIBE `ports` 0.0016160011291504
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00040507316589355
(384) DESCRIBE `ports` 0.0013198852539062
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00041508674621582
(386) DESCRIBE `ports` 0.0013191699981689
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00030708312988281
(388) DESCRIBE `ports` 0.0014228820800781
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00031781196594238
(390) DESCRIBE `ports` 0.0014388561248779
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00039291381835938
(392) DESCRIBE `ports` 0.0012919902801514
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00036191940307617
(394) DESCRIBE `avid_specials` 0.0015518665313721
(395) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77033 and class = 'Cruise') OR (item_id = 1731 AND class = 'Ship') OR (item_id = 90 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.0012102127075195
(396) DESCRIBE `cruiselines` 0.0020360946655273
(397) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 90))) 0.00045490264892578
(398) DESCRIBE `orchid_image` 0.0019381046295166
(399) DESCRIBE `cruiselines` 0.0018820762634277
(400) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '90') 0.00043201446533203
(401) DESCRIBE `cruises` 0.0029408931732178
(402) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77284') 0.0003819465637207
(403) DESCRIBE `ships` 0.0039699077606201
(404) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00064921379089355
(405) DESCRIBE `ships` 0.004080057144165
(406) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00048995018005371
(407) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(408) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003359317779541
(409) DESCRIBE `itineraries` 0.0019979476928711
(410) DESCRIBE `ports` 0.0020949840545654
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00047397613525391
(412) DESCRIBE `ports` 0.0018990039825439
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00050783157348633
(414) DESCRIBE `ports` 0.0013439655303955
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00031304359436035
(416) DESCRIBE `sailingdates` 0.0012021064758301
(417) DESCRIBE `ports` 0.0016500949859619
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00037908554077148
(419) DESCRIBE `ports` 0.0014569759368896
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.0003201961517334
(421) DESCRIBE `ports` 0.0014021396636963
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00035881996154785
(423) DESCRIBE `ports` 0.001492977142334
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041508674621582
(425) DESCRIBE `ports` 0.0016670227050781
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00034713745117188
(427) DESCRIBE `ports` 0.0013840198516846
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00035905838012695
(429) DESCRIBE `ports` 0.0013480186462402
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00034499168395996
(431) DESCRIBE `ports` 0.0012848377227783
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00030112266540527
(433) DESCRIBE `ports` 0.0013139247894287
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00036406517028809
(435) DESCRIBE `ports` 0.0013558864593506
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00036883354187012
(437) DESCRIBE `ports` 0.0014998912811279
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00032782554626465
(439) DESCRIBE `ports` 0.0013039112091064
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00030398368835449
(441) DESCRIBE `ports` 0.0013728141784668
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00037097930908203
(443) DESCRIBE `ports` 0.0014441013336182
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00034618377685547
(445) DESCRIBE `ports` 0.0013659000396729
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00038695335388184
(447) DESCRIBE `ports` 0.0013570785522461
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.00033712387084961
(449) DESCRIBE `avid_specials` 0.001291036605835
(450) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77284 and class = 'Cruise') OR (item_id = 462 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.0012280941009521
(451) DESCRIBE `cruiselines` 0.00205397605896
(452) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00048398971557617
(453) DESCRIBE `orchid_image` 0.0019299983978271
(454) DESCRIBE `cruiselines` 0.0023729801177979
(455) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00047612190246582
(456) DESCRIBE `cruises` 0.0027711391448975
(457) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78576') 0.00057506561279297
(458) DESCRIBE `ships` 0.0032570362091064
(459) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1677))) 0.00046801567077637
(460) DESCRIBE `ships` 0.002636194229126
(461) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1677') 0.0003819465637207
(462) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026702880859375
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00025486946105957
(464) DESCRIBE `itineraries` 0.0015239715576172
(465) DESCRIBE `ports` 0.0014820098876953
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00036501884460449
(467) DESCRIBE `ports` 0.0013668537139893
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00032401084899902
(469) DESCRIBE `ports` 0.0014369487762451
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00033688545227051
(471) DESCRIBE `sailingdates` 0.0013008117675781
(472) DESCRIBE `ports` 0.0015480518341064
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0003972053527832
(474) DESCRIBE `ports` 0.0012850761413574
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00033402442932129
(476) DESCRIBE `ports` 0.0013439655303955
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00036191940307617
(478) DESCRIBE `ports` 0.001471996307373
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00030398368835449
(480) DESCRIBE `ports` 0.00130295753479
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1111))) 0.00030708312988281
(482) DESCRIBE `ports` 0.001270055770874
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1111') 0.00028610229492188
(484) DESCRIBE `ports` 0.0012528896331787
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00033211708068848
(486) DESCRIBE `ports` 0.0012791156768799
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00027704238891602
(488) DESCRIBE `ports` 0.0013020038604736
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00029993057250977
(490) DESCRIBE `ports` 0.0014369487762451
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00038003921508789
(492) DESCRIBE `ports` 0.00078916549682617
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00038003921508789
(494) DESCRIBE `ports` 0.0013420581817627
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00031185150146484
(496) DESCRIBE `ports` 0.0014450550079346
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1213))) 0.00040507316589355
(498) DESCRIBE `ports` 0.0017130374908447
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1213') 0.00035810470581055
(500) DESCRIBE `ports` 0.0017108917236328
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00045108795166016
(502) DESCRIBE `ports` 0.0015749931335449
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0003349781036377
(504) DESCRIBE `avid_specials` 0.0012130737304688
(505) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78576 and class = 'Cruise') OR (item_id = 1677 AND class = 'Ship') OR (item_id = 12 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.0011489391326904
(506) DESCRIBE `cruiselines` 0.0023279190063477
(507) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00046801567077637
(508) DESCRIBE `orchid_image` 0.0016119480133057
(509) DESCRIBE `cruiselines` 0.0020420551300049
(510) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.0004429817199707
(511) DESCRIBE `cruises` 0.0031750202178955
(512) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78581') 0.00034308433532715
(513) DESCRIBE `ships` 0.0028340816497803
(514) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1160))) 0.00043511390686035
(515) DESCRIBE `ships` 0.0029120445251465
(516) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1160') 0.00036406517028809
(517) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033307075500488
(518) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(519) DESCRIBE `itineraries` 0.001349925994873
(520) DESCRIBE `ports` 0.0020220279693604
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00040006637573242
(522) DESCRIBE `ports` 0.0014870166778564
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00032711029052734
(524) DESCRIBE `ports` 0.0013549327850342
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00034689903259277
(526) DESCRIBE `sailingdates` 0.0012772083282471
(527) DESCRIBE `ports` 0.0023410320281982
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0010478496551514
(529) DESCRIBE `ports` 0.0012881755828857
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00034689903259277
(531) DESCRIBE `ports` 0.0014808177947998
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00045180320739746
(533) DESCRIBE `ports` 0.0016071796417236
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00032901763916016
(535) DESCRIBE `ports` 0.0014188289642334
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00046181678771973
(537) DESCRIBE `ports` 0.0019550323486328
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00040888786315918
(539) DESCRIBE `ports` 0.0016868114471436
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00034117698669434
(541) DESCRIBE `ports` 0.0015609264373779
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00036001205444336
(543) DESCRIBE `ports` 0.0021560192108154
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3643))) 0.00046300888061523
(545) DESCRIBE `ports` 0.0018351078033447
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3643') 0.00040793418884277
(547) DESCRIBE `ports` 0.0018610954284668
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 938))) 0.0003960132598877
(549) DESCRIBE `ports` 0.0018069744110107
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '938') 0.00040698051452637
(551) DESCRIBE `ports` 0.0017659664154053
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00041699409484863
(553) DESCRIBE `ports` 0.0017108917236328
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00053691864013672
(555) DESCRIBE `ports` 0.0023868083953857
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00041103363037109
(557) DESCRIBE `ports` 0.0017409324645996
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0
(559) DESCRIBE `ports` 0.0018749237060547
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2916))) 0.00040602684020996
(561) DESCRIBE `ports` 0.0013070106506348
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2916') 0.00038814544677734
(563) DESCRIBE `ports` 0.0016839504241943
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2916))) 0.00041294097900391
(565) DESCRIBE `ports` 0.0019268989562988
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2916') 0.00044894218444824
(567) DESCRIBE `avid_specials` 0.0015199184417725
(568) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78581 and class = 'Cruise') OR (item_id = 1160 AND class = 'Ship') OR (item_id = 131 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.0017781257629395
(569) DESCRIBE `cruiselines` 0.0032591819763184
(570) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.0005638599395752
(571) DESCRIBE `orchid_image` 0.0022480487823486
(572) DESCRIBE `cruiselines` 0.0027270317077637
(573) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.0005190372467041
(574) DESCRIBE `cruiselines` 0.002791166305542
(575) 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', '113', '147', '211', '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,113,147,211,57,180,64,257,261,38,48,115,276,213,184,95,105,52,82,244,209,177,134,245') 0.0051050186157227
(576) DESCRIBE `ships` 0.0032129287719727
(577) 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', '1140', '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')) 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,1140,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') 0.046690940856934
(578) DESCRIBE `cruisetypes` 0.0023939609527588
(579) DESCRIBE `destinations` 0.0030689239501953
(580) 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.0022320747375488