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

Total elapsed time: 1.0793783664703

# Query Time
(1) connect 0.0019190311431885
(2) DESCRIBE `cruises` 0.0044949054718018
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82150, 55527, 75801, 78578, 76281, 81916, 52232, 54751, 62216, 65945)) ORDER BY FIND_IN_SET(id, '82150,55527,75801,78578,76281,81916,52232,54751,62216,65945') 0.0032360553741455
(4) DESCRIBE `cruises` 0.005263090133667
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82150') 0.00065398216247559
(6) DESCRIBE `ships` 0.0050878524780273
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1794))) 0.0010318756103516
(8) DESCRIBE `ships` 0.0051589012145996
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1794') 0.0007929801940918
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035905838012695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039291381835938
(12) DESCRIBE `itineraries` 0.0019638538360596
(13) DESCRIBE `ports` 0.0019340515136719
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00043678283691406
(15) DESCRIBE `ports` 0.0019519329071045
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00050687789916992
(17) DESCRIBE `ports` 0.0022308826446533
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00050711631774902
(19) DESCRIBE `sailingdates` 0.0015900135040283
(20) DESCRIBE `ports` 0.0023641586303711
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00050497055053711
(22) DESCRIBE `ports` 0.0021188259124756
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00051999092102051
(24) DESCRIBE `ports` 0.0018880367279053
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00048112869262695
(26) DESCRIBE `ports` 0.0026891231536865
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00084590911865234
(28) DESCRIBE `ports` 0.0029590129852295
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00068306922912598
(30) DESCRIBE `ports` 0.0023689270019531
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00055503845214844
(32) DESCRIBE `avid_specials` 0.0019681453704834
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82150 and class = 'Cruise') OR (item_id = 1794 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 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.0013430118560791
(34) DESCRIBE `cruiselines` 0.003803014755249
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00074505805969238
(36) DESCRIBE `orchid_image` 0.0020949840545654
(37) DESCRIBE `cruiselines` 0.0034620761871338
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00064396858215332
(39) DESCRIBE `cruises` 0.0057899951934814
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55527') 0.00069785118103027
(41) DESCRIBE `ships` 0.0057411193847656
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1236))) 0.00052499771118164
(43) DESCRIBE `ships` 0.0036649703979492
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1236') 0.00051784515380859
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039291381835938
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046491622924805
(47) DESCRIBE `itineraries` 0.0019409656524658
(48) DESCRIBE `ports` 0.0018939971923828
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00046396255493164
(50) DESCRIBE `ports` 0.0017969608306885
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00040507316589355
(52) DESCRIBE `ports` 0.0018610954284668
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00038981437683105
(54) DESCRIBE `sailingdates` 0.0016241073608398
(55) DESCRIBE `ports` 0.002284049987793
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00056004524230957
(57) DESCRIBE `ports` 0.0024759769439697
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00065517425537109
(59) DESCRIBE `ports` 0.0027198791503906
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00065302848815918
(61) DESCRIBE `ports` 0.0027530193328857
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00057888031005859
(63) DESCRIBE `ports` 0.0027520656585693
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00064396858215332
(65) DESCRIBE `ports` 0.0026581287384033
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00056719779968262
(67) DESCRIBE `ports` 0.0026938915252686
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00062084197998047
(69) DESCRIBE `ports` 0.0027270317077637
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00053095817565918
(71) DESCRIBE `ports` 0.0025069713592529
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00061297416687012
(73) DESCRIBE `ports` 0.0025839805603027
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00055193901062012
(75) DESCRIBE `avid_specials` 0.0025219917297363
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55527 and class = 'Cruise') OR (item_id = 1236 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.002194881439209
(77) DESCRIBE `cruiselines` 0.0037269592285156
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00047588348388672
(79) DESCRIBE `orchid_image` 0.0025010108947754
(80) DESCRIBE `cruiselines` 0.0030670166015625
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00047206878662109
(82) DESCRIBE `cruises` 0.0040438175201416
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75801') 0.00059103965759277
(84) DESCRIBE `ships` 0.0036630630493164
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1724))) 0.00056600570678711
(86) DESCRIBE `ships` 0.0041399002075195
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1724') 0.00056791305541992
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039410591125488
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039100646972656
(90) DESCRIBE `itineraries` 0.0020010471343994
(91) DESCRIBE `ports` 0.0021510124206543
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00053787231445312
(93) DESCRIBE `ports` 0.0021719932556152
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00051188468933105
(95) DESCRIBE `ports` 0.002357006072998
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0004880428314209
(97) DESCRIBE `sailingdates` 0.0019481182098389
(98) DESCRIBE `ports` 0.0023510456085205
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047802925109863
(100) DESCRIBE `ports` 0.00205397605896
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00043392181396484
(102) DESCRIBE `ports` 0.0019710063934326
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1350))) 0.00046706199645996
(104) DESCRIBE `ports` 0.0019938945770264
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1350') 0.0004889965057373
(106) DESCRIBE `ports` 0.002331018447876
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00052881240844727
(108) DESCRIBE `ports` 0.0020039081573486
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00046205520629883
(110) DESCRIBE `ports` 0.0027880668640137
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00065398216247559
(112) DESCRIBE `ports` 0.0026869773864746
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00060892105102539
(114) DESCRIBE `ports` 0.0027391910552979
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00062298774719238
(116) DESCRIBE `ports` 0.0027201175689697
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.000579833984375
(118) DESCRIBE `ports` 0.0026230812072754
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00060606002807617
(120) DESCRIBE `ports` 0.0027141571044922
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00061488151550293
(122) DESCRIBE `ports` 0.0026261806488037
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00062990188598633
(124) DESCRIBE `ports` 0.0025718212127686
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00053906440734863
(126) DESCRIBE `ports` 0.0025410652160645
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00056314468383789
(128) DESCRIBE `ports` 0.0061538219451904
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00062704086303711
(130) DESCRIBE `avid_specials` 0.0025269985198975
(131) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75801 and class = 'Cruise') OR (item_id = 1724 AND class = 'Ship') OR (item_id = 103 AND class = 'CruiseLine') OR (item_id = 39 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.0020339488983154
(132) DESCRIBE `cruiselines` 0.0036280155181885
(133) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00063705444335938
(134) DESCRIBE `orchid_image` 0.0031139850616455
(135) DESCRIBE `cruiselines` 0.0038118362426758
(136) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00060296058654785
(137) DESCRIBE `cruises` 0.004335880279541
(138) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78578') 0.00052118301391602
(139) DESCRIBE `ships` 0.0038201808929443
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1292))) 0.00088596343994141
(141) DESCRIBE `ships` 0.0037879943847656
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1292') 0.0006248950958252
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035381317138672
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034093856811523
(145) DESCRIBE `itineraries` 0.0018899440765381
(146) DESCRIBE `ports` 0.0018718242645264
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00047898292541504
(148) DESCRIBE `ports` 0.0018579959869385
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00039196014404297
(150) DESCRIBE `ports` 0.0018069744110107
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00038599967956543
(152) DESCRIBE `sailingdates` 0.0016679763793945
(153) DESCRIBE `ports` 0.0028829574584961
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00063300132751465
(155) DESCRIBE `ports` 0.0024559497833252
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00054621696472168
(157) DESCRIBE `ports` 0.0024819374084473
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.0006101131439209
(159) DESCRIBE `ports` 0.0031700134277344
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00069022178649902
(161) DESCRIBE `ports` 0.0027871131896973
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00065994262695312
(163) DESCRIBE `ports` 0.0029070377349854
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00061607360839844
(165) DESCRIBE `ports` 0.0029480457305908
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2662))) 0.00063800811767578
(167) DESCRIBE `ports` 0.0028719902038574
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2662') 0.00056099891662598
(169) DESCRIBE `ports` 0.002000093460083
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.0005030632019043
(171) DESCRIBE `ports` 0.0017931461334229
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00041508674621582
(173) DESCRIBE `ports` 0.0020160675048828
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2665))) 0.00041890144348145
(175) DESCRIBE `ports` 0.0020871162414551
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2665') 0.00039196014404297
(177) DESCRIBE `ports` 0.0017640590667725
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2528))) 0.00042200088500977
(179) DESCRIBE `ports` 0.002399206161499
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2528') 0.00048708915710449
(181) DESCRIBE `ports` 0.0024120807647705
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1650))) 0.0005190372467041
(183) DESCRIBE `ports` 0.0021929740905762
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1650') 0.0004580020904541
(185) DESCRIBE `ports` 0.0018107891082764
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4211))) 0.00040006637573242
(187) DESCRIBE `ports` 0.0018258094787598
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4211') 0.00036716461181641
(189) DESCRIBE `ports` 0.0018448829650879
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1650))) 0.00041508674621582
(191) DESCRIBE `ports` 0.0017290115356445
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1650') 0.00046586990356445
(193) DESCRIBE `ports` 0.0017750263214111
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00040602684020996
(195) DESCRIBE `ports` 0.0019588470458984
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00042319297790527
(197) DESCRIBE `ports` 0.0018410682678223
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00045919418334961
(199) DESCRIBE `ports` 0.00189208984375
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00040698051452637
(201) DESCRIBE `ports` 0.0018289089202881
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00039482116699219
(203) DESCRIBE `ports` 0.0019509792327881
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00037193298339844
(205) DESCRIBE `ports` 0.0018689632415771
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00038909912109375
(207) DESCRIBE `ports` 0.0018749237060547
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00048589706420898
(209) DESCRIBE `ports` 0.0018060207366943
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1652))) 0.00044417381286621
(211) DESCRIBE `ports` 0.0019991397857666
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1652') 0.00045990943908691
(213) DESCRIBE `ports` 0.0022480487823486
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1652))) 0.00049519538879395
(215) DESCRIBE `ports` 0.00193190574646
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1652') 0.00037002563476562
(217) DESCRIBE `ports` 0.0019121170043945
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2663))) 0.00061202049255371
(219) DESCRIBE `ports` 0.0020320415496826
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2663') 0.0003809928894043
(221) DESCRIBE `ports` 0.0019428730010986
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2523))) 0.00057601928710938
(223) DESCRIBE `ports` 0.0020730495452881
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2523') 0.00045895576477051
(225) DESCRIBE `ports` 0.0018820762634277
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00062394142150879
(227) DESCRIBE `ports` 0.0019080638885498
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00039792060852051
(229) DESCRIBE `ports` 0.0017571449279785
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2600))) 0.00040507316589355
(231) DESCRIBE `ports` 0.0019421577453613
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2600') 0.00037789344787598
(233) DESCRIBE `ports` 0.0018279552459717
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00041007995605469
(235) DESCRIBE `ports` 0.0019559860229492
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00045490264892578
(237) DESCRIBE `ports` 0.0018310546875
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2883))) 0.00047707557678223
(239) DESCRIBE `ports` 0.0018889904022217
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2883') 0.00038385391235352
(241) DESCRIBE `ports` 0.0018370151519775
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00046110153198242
(243) DESCRIBE `ports` 0.0024149417877197
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.0004417896270752
(245) DESCRIBE `ports` 0.0019009113311768
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00044989585876465
(247) DESCRIBE `ports` 0.0018429756164551
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00052094459533691
(249) DESCRIBE `ports` 0.0018711090087891
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00042390823364258
(251) DESCRIBE `ports` 0.0018770694732666
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00042009353637695
(253) DESCRIBE `ports` 0.0022509098052979
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00047492980957031
(255) DESCRIBE `ports` 0.0018789768218994
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00043106079101562
(257) DESCRIBE `avid_specials` 0.0021131038665771
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78578 and class = 'Cruise') OR (item_id = 1292 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012590885162354
(259) DESCRIBE `cruiselines` 0.0027320384979248
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00059914588928223
(261) DESCRIBE `orchid_image` 0.0023429393768311
(262) DESCRIBE `cruises` 0.0036849975585938
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76281') 0.00044512748718262
(264) DESCRIBE `ships` 0.0039229393005371
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00073099136352539
(266) DESCRIBE `ships` 0.005263090133667
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.0004570484161377
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040698051452637
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050806999206543
(270) DESCRIBE `itineraries` 0.0020301342010498
(271) DESCRIBE `ports` 0.0020520687103271
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047492980957031
(273) DESCRIBE `ports` 0.0018410682678223
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042891502380371
(275) DESCRIBE `ports` 0.0019760131835938
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00043892860412598
(277) DESCRIBE `sailingdates` 0.0018138885498047
(278) DESCRIBE `ports` 0.0024189949035645
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00046300888061523
(280) DESCRIBE `ports` 0.0019638538360596
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0004880428314209
(282) DESCRIBE `ports` 0.0021119117736816
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00046205520629883
(284) DESCRIBE `ports` 0.00187087059021
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00040316581726074
(286) DESCRIBE `ports` 0.0022151470184326
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00047492980957031
(288) DESCRIBE `ports` 0.0018517971038818
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00053906440734863
(290) DESCRIBE `ports` 0.0075199604034424
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00072693824768066
(292) DESCRIBE `ports` 0.0038111209869385
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00048303604125977
(294) DESCRIBE `ports` 0.0020730495452881
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00050497055053711
(296) DESCRIBE `ports` 0.0021820068359375
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00049495697021484
(298) DESCRIBE `ports` 0.0018608570098877
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00041103363037109
(300) DESCRIBE `ports` 0.0018291473388672
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00039291381835938
(302) DESCRIBE `ports` 0.0021262168884277
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00045680999755859
(304) DESCRIBE `ports` 0.0018329620361328
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00047111511230469
(306) DESCRIBE `ports` 0.0017871856689453
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043201446533203
(308) DESCRIBE `ports` 0.0021419525146484
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041294097900391
(310) DESCRIBE `ports` 0.0018951892852783
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048279762268066
(312) DESCRIBE `ports` 0.0017960071563721
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00041389465332031
(314) DESCRIBE `avid_specials` 0.0015780925750732
(315) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76281 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012459754943848
(316) DESCRIBE `cruiselines` 0.0026898384094238
(317) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00051498413085938
(318) DESCRIBE `orchid_image` 0.0020599365234375
(319) DESCRIBE `cruiselines` 0.0025219917297363
(320) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00059700012207031
(321) DESCRIBE `cruises` 0.0036311149597168
(322) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81916') 0.00054097175598145
(323) DESCRIBE `ships` 0.0037040710449219
(324) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1348))) 0.00055813789367676
(325) DESCRIBE `ships` 0.0036559104919434
(326) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1348') 0.00049209594726562
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00045514106750488
(328) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034904479980469
(329) DESCRIBE `itineraries` 0.0020639896392822
(330) DESCRIBE `sailingdates` 0.0017349720001221
(331) DESCRIBE `itineraries` 0.0019850730895996
(332) DESCRIBE `itineraries` 0.0022640228271484
(333) DESCRIBE `avid_specials` 0.0023150444030762
(334) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81916 and class = 'Cruise') OR (item_id = 1348 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 54 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.0013940334320068
(335) DESCRIBE `cruiselines` 0.0028450489044189
(336) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00064492225646973
(337) DESCRIBE `orchid_image` 0.0025429725646973
(338) DESCRIBE `cruiselines` 0.0031020641326904
(339) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.0004429817199707
(340) DESCRIBE `cruises` 0.0038630962371826
(341) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52232') 0.00063800811767578
(342) DESCRIBE `ships` 0.0040090084075928
(343) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1292))) 0.00071597099304199
(344) DESCRIBE `ships` 0.0042169094085693
(345) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1292') 0.0006561279296875
(346) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00047397613525391
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0004880428314209
(348) DESCRIBE `itineraries` 0.00199294090271
(349) DESCRIBE `ports` 0.0021069049835205
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00050711631774902
(351) DESCRIBE `ports` 0.0021729469299316
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00048208236694336
(353) DESCRIBE `ports` 0.0018761157989502
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00043392181396484
(355) DESCRIBE `sailingdates` 0.0023488998413086
(356) DESCRIBE `ports` 0.0026919841766357
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00055313110351562
(358) DESCRIBE `ports` 0.001939058303833
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00043201446533203
(360) DESCRIBE `ports` 0.001939058303833
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00042009353637695
(362) DESCRIBE `ports` 0.0020811557769775
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.0005028247833252
(364) DESCRIBE `ports` 0.0018188953399658
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00041913986206055
(366) DESCRIBE `ports` 0.0021049976348877
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00049209594726562
(368) DESCRIBE `ports` 0.0018930435180664
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2662))) 0.00047993659973145
(370) DESCRIBE `ports` 0.0018999576568604
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2662') 0.00062417984008789
(372) DESCRIBE `ports` 0.002842903137207
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00053215026855469
(374) DESCRIBE `ports` 0.0022280216217041
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00042104721069336
(376) DESCRIBE `ports` 0.0017709732055664
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2665))) 0.00044393539428711
(378) DESCRIBE `ports` 0.0024948120117188
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2665') 0.00044798851013184
(380) DESCRIBE `ports` 0.0019879341125488
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2528))) 0.0006260871887207
(382) DESCRIBE `ports` 0.0023219585418701
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2528') 0.00047993659973145
(384) DESCRIBE `ports` 0.0022308826446533
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1650))) 0.00052309036254883
(386) DESCRIBE `ports` 0.0022249221801758
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1650') 0.00048208236694336
(388) DESCRIBE `ports` 0.0021581649780273
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4211))) 0.00048708915710449
(390) DESCRIBE `ports` 0.0021471977233887
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4211') 0.00044894218444824
(392) DESCRIBE `ports` 0.0018939971923828
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1650))) 0.00049614906311035
(394) DESCRIBE `ports` 0.0019099712371826
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1650') 0.00043010711669922
(396) DESCRIBE `ports` 0.0018589496612549
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.0004570484161377
(398) DESCRIBE `ports` 0.0022459030151367
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00042510032653809
(400) DESCRIBE `ports` 0.0022420883178711
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00043296813964844
(402) DESCRIBE `ports` 0.002100944519043
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00045013427734375
(404) DESCRIBE `ports` 0.0022270679473877
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00043082237243652
(406) DESCRIBE `ports` 0.0017910003662109
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00050616264343262
(408) DESCRIBE `ports` 0.0018048286437988
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00046110153198242
(410) DESCRIBE `ports` 0.0019431114196777
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00039792060852051
(412) DESCRIBE `ports` 0.0018799304962158
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00043296813964844
(414) DESCRIBE `ports` 0.0019149780273438
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00039005279541016
(416) DESCRIBE `avid_specials` 0.0019099712371826
(417) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52232 and class = 'Cruise') OR (item_id = 1292 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014410018920898
(418) DESCRIBE `cruiselines` 0.0029850006103516
(419) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00042986869812012
(420) DESCRIBE `orchid_image` 0.002561092376709
(421) DESCRIBE `cruises` 0.0041418075561523
(422) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54751') 0.00046992301940918
(423) DESCRIBE `ships` 0.0048801898956299
(424) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 590))) 0.0010020732879639
(425) DESCRIBE `ships` 0.0041289329528809
(426) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '590') 0.00060200691223145
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055384635925293
(428) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046610832214355
(429) DESCRIBE `itineraries` 0.0026330947875977
(430) DESCRIBE `ports` 0.0024900436401367
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00061893463134766
(432) DESCRIBE `ports` 0.0025880336761475
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00053501129150391
(434) DESCRIBE `ports` 0.0022740364074707
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0005500316619873
(436) DESCRIBE `sailingdates` 0.0022850036621094
(437) DESCRIBE `ports` 0.0021109580993652
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00048303604125977
(439) DESCRIBE `ports` 0.0018420219421387
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00044584274291992
(441) DESCRIBE `ports` 0.0019991397857666
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0004580020904541
(443) DESCRIBE `ports` 0.0019040107727051
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00043702125549316
(445) DESCRIBE `ports` 0.0018200874328613
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00051403045654297
(447) DESCRIBE `ports` 0.0017979145050049
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00043892860412598
(449) DESCRIBE `ports` 0.0020310878753662
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00039792060852051
(451) DESCRIBE `ports` 0.0018539428710938
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00035810470581055
(453) DESCRIBE `ports` 0.0019898414611816
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00043797492980957
(455) DESCRIBE `ports` 0.001967191696167
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00037908554077148
(457) DESCRIBE `avid_specials` 0.0017709732055664
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54751 and class = 'Cruise') OR (item_id = 590 AND class = 'Ship') OR (item_id = 26 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.0011608600616455
(459) DESCRIBE `cruiselines` 0.0029687881469727
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00046801567077637
(461) DESCRIBE `orchid_image` 0.0020809173583984
(462) DESCRIBE `cruiselines` 0.0027480125427246
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00040507316589355
(464) DESCRIBE `cruises` 0.0049479007720947
(465) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62216') 0.00049901008605957
(466) DESCRIBE `ships` 0.0038337707519531
(467) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1460))) 0.00056099891662598
(468) DESCRIBE `ships` 0.004885196685791
(469) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1460') 0.00053596496582031
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038909912109375
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(472) DESCRIBE `itineraries` 0.0019900798797607
(473) DESCRIBE `ports` 0.016803026199341
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00062704086303711
(475) DESCRIBE `ports` 0.0024769306182861
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00061202049255371
(477) DESCRIBE `ports` 0.0028388500213623
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00064611434936523
(479) DESCRIBE `sailingdates` 0.0024027824401855
(480) DESCRIBE `ports` 0.003277063369751
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00061297416687012
(482) DESCRIBE `ports` 0.0025880336761475
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00046706199645996
(484) DESCRIBE `ports` 0.0018489360809326
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00060701370239258
(486) DESCRIBE `ports` 0.0027010440826416
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00055503845214844
(488) DESCRIBE `ports` 0.0025880336761475
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00047397613525391
(490) DESCRIBE `ports` 0.0024001598358154
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00053095817565918
(492) DESCRIBE `ports` 0.0021529197692871
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00066304206848145
(494) DESCRIBE `ports` 0.0027740001678467
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00060391426086426
(496) DESCRIBE `ports` 0.0023918151855469
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0005490779876709
(498) DESCRIBE `ports` 0.0018360614776611
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00048303604125977
(500) DESCRIBE `ports` 0.0019040107727051
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00043702125549316
(502) DESCRIBE `ports` 0.0020108222961426
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00038790702819824
(504) DESCRIBE `ports` 0.0018889904022217
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00041508674621582
(506) DESCRIBE `ports` 0.0018179416656494
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00062203407287598
(508) DESCRIBE `ports` 0.0019271373748779
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.0004420280456543
(510) DESCRIBE `ports` 0.0019700527191162
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00038313865661621
(512) DESCRIBE `ports` 0.0022420883178711
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00047683715820312
(514) DESCRIBE `ports` 0.002208948135376
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00063681602478027
(516) DESCRIBE `ports` 0.0019550323486328
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00045108795166016
(518) DESCRIBE `ports` 0.0023269653320312
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00046086311340332
(520) DESCRIBE `ports` 0.0019838809967041
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00051999092102051
(522) DESCRIBE `ports` 0.0020561218261719
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00055098533630371
(524) DESCRIBE `ports` 0.0019869804382324
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00054383277893066
(526) DESCRIBE `ports` 0.0020520687103271
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00064992904663086
(528) DESCRIBE `avid_specials` 0.0017797946929932
(529) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62216 and class = 'Cruise') OR (item_id = 1460 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 54 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.0013191699981689
(530) DESCRIBE `cruiselines` 0.0026481151580811
(531) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00050806999206543
(532) DESCRIBE `orchid_image` 0.0020289421081543
(533) DESCRIBE `cruises` 0.0038161277770996
(534) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65945') 0.00043892860412598
(535) DESCRIBE `ships` 0.0036740303039551
(536) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 520))) 0.00047898292541504
(537) DESCRIBE `ships` 0.0038490295410156
(538) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '520') 0.00046586990356445
(539) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035905838012695
(540) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003809928894043
(541) DESCRIBE `itineraries` 0.0017640590667725
(542) DESCRIBE `ports` 0.0023760795593262
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0005950927734375
(544) DESCRIBE `ports` 0.0019960403442383
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00042486190795898
(546) DESCRIBE `ports` 0.0019829273223877
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00038313865661621
(548) DESCRIBE `sailingdates` 0.0015890598297119
(549) DESCRIBE `ports` 0.0021979808807373
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00047898292541504
(551) DESCRIBE `ports` 0.0019028186798096
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00044393539428711
(553) DESCRIBE `ports` 0.0020620822906494
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00054216384887695
(555) DESCRIBE `ports` 0.0020890235900879
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0004570484161377
(557) DESCRIBE `ports` 0.0025260448455811
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00068378448486328
(559) DESCRIBE `ports` 0.0026180744171143
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00041699409484863
(561) DESCRIBE `ports` 0.0018079280853271
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00048089027404785
(563) DESCRIBE `ports` 0.0025949478149414
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.0005800724029541
(565) DESCRIBE `ports` 0.0024969577789307
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00048303604125977
(567) DESCRIBE `ports` 0.0023689270019531
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.0005500316619873
(569) DESCRIBE `ports` 0.002561092376709
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.0004580020904541
(571) DESCRIBE `ports` 0.0018730163574219
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00039505958557129
(573) DESCRIBE `ports` 0.0022149085998535
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00042510032653809
(575) DESCRIBE `ports` 0.001906156539917
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00049400329589844
(577) DESCRIBE `ports` 0.0023410320281982
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00047111511230469
(579) DESCRIBE `ports` 0.0018749237060547
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.0003819465637207
(581) DESCRIBE `ports` 0.0019299983978271
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00053620338439941
(583) DESCRIBE `ports` 0.0022499561309814
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00047016143798828
(585) DESCRIBE `ports` 0.0019431114196777
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00055909156799316
(587) DESCRIBE `ports` 0.0017940998077393
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00038695335388184
(589) DESCRIBE `ports` 0.0024271011352539
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00067806243896484
(591) DESCRIBE `ports` 0.0021429061889648
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00046491622924805
(593) DESCRIBE `ports` 0.0019350051879883
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00047683715820312
(595) DESCRIBE `ports` 0.0018339157104492
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00041794776916504
(597) DESCRIBE `ports` 0.0020778179168701
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00044584274291992
(599) DESCRIBE `ports` 0.002622127532959
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00053882598876953
(601) DESCRIBE `ports` 0.002716064453125
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00058698654174805
(603) DESCRIBE `ports` 0.0027451515197754
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00058293342590332
(605) DESCRIBE `ports` 0.0026900768280029
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00067520141601562
(607) DESCRIBE `ports` 0.0028040409088135
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00064516067504883
(609) DESCRIBE `ports` 0.002763032913208
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00067806243896484
(611) DESCRIBE `ports` 0.0028119087219238
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00059199333190918
(613) DESCRIBE `ports` 0.0027379989624023
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00069594383239746
(615) DESCRIBE `ports` 0.0027840137481689
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00061202049255371
(617) DESCRIBE `ports` 0.0028650760650635
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00065994262695312
(619) DESCRIBE `ports` 0.002769947052002
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00060200691223145
(621) DESCRIBE `ports` 0.0028069019317627
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00065898895263672
(623) DESCRIBE `ports` 0.0026609897613525
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00064301490783691
(625) DESCRIBE `avid_specials` 0.0028579235076904
(626) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65945 and class = 'Cruise') OR (item_id = 520 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.002345085144043
(627) DESCRIBE `cruiselines` 0.0042769908905029
(628) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00077986717224121
(629) DESCRIBE `orchid_image` 0.0033309459686279
(630) DESCRIBE `cruiselines` 0.0059299468994141
(631) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00066018104553223
(632) DESCRIBE `cruiselines` 0.0036799907684326
(633) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '171', '23', '144', '20', '12', '7', '18', '101', '31', '183', '8', '120', '131', '96', '29', '103', '206', '15', '91', '262', '24', '114', '33', '14', '156', '170', '28', '258', '191', '50', '153', '195', '37', '208', '49', '187', '16', '251', '36', '88', '47', '151', '216', '212', '141', '181', '118', '4', '110', '140', '59', '147', '261', '213', '48', '30', '211', '73', '276', '209', '159', '82', '95', '113', '57', '115', '90', '184', '244', '264', '108', '52', '180', '64', '105', '35', '38', '134', '245', '257')) ORDER BY FIND_IN_SET(id, '77,218,19,26,171,23,144,20,12,7,18,101,31,183,8,120,131,96,29,103,206,15,91,262,24,114,33,14,156,170,28,258,191,50,153,195,37,208,49,187,16,251,36,88,47,151,216,212,141,181,118,4,110,140,59,147,261,213,48,30,211,73,276,209,159,82,95,113,57,115,90,184,244,264,108,52,180,64,105,35,38,134,245,257') 0.0090079307556152
(634) DESCRIBE `ships` 0.0047140121459961
(635) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '726', '1324', '258', '517', '1588', '780', '737', '1417', '871', '1717', '207', '855', '1766', '1572', '404', '1794', '454', '977', '770', '874', '1291', '1594', '1359', '1272', '1134', '66', '738', '1424', '22', '434', '1199', '21', '265', '330', '461', '393', '553', '1032', '332', '1768', '28', '716', '333', '974', '1260', '1419', '1423', '1422', '1292', '1418', '1420', '1421', '1682', '766', '1237', '521', '1348', '1415', '797', '715', '349', '585', '711', '455', '1678', '9', '674', '1132', '407', '792', '25', '439', '657', '11', '163', '739', '10', '1852', '857', '858', '1460', '1677', '542', '1501', '3', '24', '520', '1008', '1233', '1721', '1569', '1822', '34', '39', '966', '1505', '1811', '31', '36', '378', '1742', '1676', '35', '385', '1012', '1141', '1402', '1455', '626', '1168', '386', '768', '850', '986', '1302', '1372', '1373', '817', '1607', '98', '1413', '1282', '338', '451', '1319', '1410', '1773', '1782', '1411', '837', '1602', '113', '352', '547', '1259', '1733', '148', '573', '1021', '1145', '111', '160', '314', '508', '882', '883', '1398', '1437', '1454', '1574', '108', '285', '375', '1063', '1135', '1205', '1284', '627', '1149', '1308', '198', '610', '1722', '37', '1028', '1088', '1193', '340', '286', '748', '1067', '1068', '1808', '30', '63', '485', '526', '1323', '1810', '970', '1157', '1320', '1321', '1325', '1412', '1579', '1711', '327', '406', '1461', '1586', '1809', '43', '124', '348', '390', '394', '582', '854', '1492', '1724', '1801', '38', '462', '616', '82', '116', '223', '590', '1208', '1571', '1672', '1853', '1027', '1108', '1575', '652', '119', '351', '1318', '1408', '1738', '1820', '884', '114', '147', '944', '1139', '1266', '1486', '1587', '78', '678', '958', '1188', '75', '81', '149', '441', '683', '704', '791', '1772', '1326', '1327', '1771', '4', '70', '201', '291', '325', '545', '1367', '105', '287', '401', '423', '580', '601', '1037', '1043', '1151', '1289', '1330', '1757', '335', '658', '722', '776', '790', '818', '988', '1040', '1073', '1552', '162', '403', '651', '1019', '1704', '341', '389', '1013', '1172', '1236', '1539', '1223', '1303', '266', '1740', '290', '639', '751', '796', '1029', '1715', '1743', '1758', '45', '69', '123', '262', '852', '1035', '1160', '1163', '1206', '1344', '1426', '1474', '1526', '84', '972', '1146', '1150', '1217', '1226', '1229', '1338', '1452', '1453', '1540', '1604', '1716', '417', '673', '795', '1143', '1144', '1283', '1343', '1358', '1483', '1807', '1833', '405', '643', '775', '851', '905', '1048', '1136', '1293', '1448', '1681', '1746', '503', '574', '717', '968', '1042', '1045', '1159', '1230', '1231', '1262', '1787', '324', '467', '1026', '1051', '1137', '1573', '1749', '1791', '483', '635', '885', '1140', '1154', '1340', '1351', '1458', '1663', '1723', '1759', '1806', '663', '709', '954', '1224', '1366', '1368', '1459', '1609', '1632', '1751', '559', '920', '973', '996', '1049', '1050', '1148', '1274', '1354', '1360', '1361', '1362', '1647', '1708', '1713', '1805', '666', '914', '921', '923', '927', '1025', '1044', '1072', '1090', '1095', '1196', '1339', '1601', '1673', '1714', '1788', '1823', '448', '480', '886', '915', '916', '926', '930', '931', '1055', '1322', '1649', '1750', '1854', '208', '665', '703', '924', '1047', '1052', '1596', '1650', '299', '300', '422', '1004', '1020', '1036', '1039', '1054', '1225', '1245', '1352', '1451', '1580', '1730', '151', '453', '937', '1109', '487', '672', '740', '888', '1152', '1256', '1301', '1409', '1449', '1519', '205', '671', '769', '821', '1232', '1294', '1445', '1816', '212', '516', '707', '1005', '1060', '1463', '1792', '1821', '93', '150', '420', '761', '932', '969', '1038', '1071', '1075', '1664', '74', '419')) ORDER BY FIND_IN_SET(id, '1761,732,1744,726,1324,258,517,1588,780,737,1417,871,1717,207,855,1766,1572,404,1794,454,977,770,874,1291,1594,1359,1272,1134,66,738,1424,22,434,1199,21,265,330,461,393,553,1032,332,1768,28,716,333,974,1260,1419,1423,1422,1292,1418,1420,1421,1682,766,1237,521,1348,1415,797,715,349,585,711,455,1678,9,674,1132,407,792,25,439,657,11,163,739,10,1852,857,858,1460,1677,542,1501,3,24,520,1008,1233,1721,1569,1822,34,39,966,1505,1811,31,36,378,1742,1676,35,385,1012,1141,1402,1455,626,1168,386,768,850,986,1302,1372,1373,817,1607,98,1413,1282,338,451,1319,1410,1773,1782,1411,837,1602,113,352,547,1259,1733,148,573,1021,1145,111,160,314,508,882,883,1398,1437,1454,1574,108,285,375,1063,1135,1205,1284,627,1149,1308,198,610,1722,37,1028,1088,1193,340,286,748,1067,1068,1808,30,63,485,526,1323,1810,970,1157,1320,1321,1325,1412,1579,1711,327,406,1461,1586,1809,43,124,348,390,394,582,854,1492,1724,1801,38,462,616,82,116,223,590,1208,1571,1672,1853,1027,1108,1575,652,119,351,1318,1408,1738,1820,884,114,147,944,1139,1266,1486,1587,78,678,958,1188,75,81,149,441,683,704,791,1772,1326,1327,1771,4,70,201,291,325,545,1367,105,287,401,423,580,601,1037,1043,1151,1289,1330,1757,335,658,722,776,790,818,988,1040,1073,1552,162,403,651,1019,1704,341,389,1013,1172,1236,1539,1223,1303,266,1740,290,639,751,796,1029,1715,1743,1758,45,69,123,262,852,1035,1160,1163,1206,1344,1426,1474,1526,84,972,1146,1150,1217,1226,1229,1338,1452,1453,1540,1604,1716,417,673,795,1143,1144,1283,1343,1358,1483,1807,1833,405,643,775,851,905,1048,1136,1293,1448,1681,1746,503,574,717,968,1042,1045,1159,1230,1231,1262,1787,324,467,1026,1051,1137,1573,1749,1791,483,635,885,1140,1154,1340,1351,1458,1663,1723,1759,1806,663,709,954,1224,1366,1368,1459,1609,1632,1751,559,920,973,996,1049,1050,1148,1274,1354,1360,1361,1362,1647,1708,1713,1805,666,914,921,923,927,1025,1044,1072,1090,1095,1196,1339,1601,1673,1714,1788,1823,448,480,886,915,916,926,930,931,1055,1322,1649,1750,1854,208,665,703,924,1047,1052,1596,1650,299,300,422,1004,1020,1036,1039,1054,1225,1245,1352,1451,1580,1730,151,453,937,1109,487,672,740,888,1152,1256,1301,1409,1449,1519,205,671,769,821,1232,1294,1445,1816,212,516,707,1005,1060,1463,1792,1821,93,150,420,761,932,969,1038,1071,1075,1664,74,419') 0.071447849273682
(636) DESCRIBE `cruisetypes` 0.0015270709991455
(637) DESCRIBE `destinations` 0.0026049613952637
(638) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '2', '37', '9', '8', '44', '39', '55', '53', '26', '38', '28', '49', '40', '30', '11', '21', '45', '29', '7', '48', '34', '52', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,2,37,9,8,44,39,55,53,26,38,28,49,40,30,11,21,45,29,7,48,34,52,10,46,56,32') 0.0027170181274414