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

Total elapsed time: 0.93573546409607

# Query Time
(1) connect 0.0012388229370117
(2) DESCRIBE `cruises` 0.0045490264892578
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (77328, 77388, 69369, 70033, 76573, 76766, 76798, 77007, 77087, 77100)) ORDER BY FIND_IN_SET(id, '77328,77388,69369,70033,76573,76766,76798,77007,77087,77100') 0.0036208629608154
(4) DESCRIBE `cruises` 0.0090670585632324
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77328') 0.00066900253295898
(6) DESCRIBE `ships` 0.0053660869598389
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00068187713623047
(8) DESCRIBE `ships` 0.0059700012207031
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00069403648376465
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048995018005371
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00065398216247559
(12) DESCRIBE `itineraries` 0.0030770301818848
(13) DESCRIBE `ports` 0.0029160976409912
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 869))) 0.000640869140625
(15) DESCRIBE `ports` 0.0026628971099854
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 869))) 0.00071501731872559
(17) DESCRIBE `ports` 0.0026969909667969
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '869') 0.00056695938110352
(19) DESCRIBE `sailingdates` 0.0023419857025146
(20) DESCRIBE `ports` 0.0027399063110352
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 869))) 0.00063204765319824
(22) DESCRIBE `ports` 0.0034561157226562
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '869') 0.0007169246673584
(24) DESCRIBE `ports` 0.0028378963470459
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00063419342041016
(26) DESCRIBE `ports` 0.0027790069580078
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00069308280944824
(28) DESCRIBE `ports` 0.0024561882019043
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00062179565429688
(30) DESCRIBE `ports` 0.002755880355835
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00059914588928223
(32) DESCRIBE `ports` 0.0026669502258301
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00060200691223145
(34) DESCRIBE `ports` 0.0023739337921143
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00042009353637695
(36) DESCRIBE `ports` 0.0022768974304199
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5354))) 0.00053191184997559
(38) DESCRIBE `ports` 0.0026869773864746
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5354') 0.00044417381286621
(40) DESCRIBE `ports` 0.0019090175628662
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 869))) 0.00048398971557617
(42) DESCRIBE `ports` 0.0027270317077637
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '869') 0.00055718421936035
(44) DESCRIBE `ports` 0.0025091171264648
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00046014785766602
(46) DESCRIBE `ports` 0.0019741058349609
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00047993659973145
(48) DESCRIBE `ports` 0.0018517971038818
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) 0.00043201446533203
(50) DESCRIBE `ports` 0.002112865447998
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') 0.00059604644775391
(52) DESCRIBE `ports` 0.0025031566619873
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.000518798828125
(54) DESCRIBE `ports` 0.0019550323486328
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00040984153747559
(56) DESCRIBE `ports` 0.002255916595459
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00042200088500977
(58) DESCRIBE `ports` 0.0026159286499023
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00046515464782715
(60) DESCRIBE `ports` 0.0019280910491943
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00041007995605469
(62) DESCRIBE `ports` 0.0018131732940674
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00038409233093262
(64) DESCRIBE `ports` 0.0017778873443604
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 869))) 0.00041890144348145
(66) DESCRIBE `ports` 0.0020968914031982
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '869') 0.00040102005004883
(68) DESCRIBE `avid_specials` 0.0018210411071777
(69) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77328 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 26 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.0015950202941895
(70) DESCRIBE `cruiselines` 0.0035979747772217
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00061702728271484
(72) DESCRIBE `orchid_image` 0.0031189918518066
(73) DESCRIBE `cruiselines` 0.0038390159606934
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00058913230895996
(75) DESCRIBE `cruises` 0.0041708946228027
(76) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77388') 0.00058197975158691
(77) DESCRIBE `ships` 0.0047879219055176
(78) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00061798095703125
(79) DESCRIBE `ships` 0.0038900375366211
(80) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00053906440734863
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00048089027404785
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00037407875061035
(83) DESCRIBE `itineraries` 0.0023190975189209
(84) DESCRIBE `ports` 0.0028810501098633
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00063705444335938
(86) DESCRIBE `ports` 0.0020251274108887
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044608116149902
(88) DESCRIBE `ports` 0.0026841163635254
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00054001808166504
(90) DESCRIBE `sailingdates` 0.0022380352020264
(91) DESCRIBE `ports` 0.0028440952301025
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00062298774719238
(93) DESCRIBE `ports` 0.0026359558105469
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00063991546630859
(95) DESCRIBE `ports` 0.0026919841766357
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00061988830566406
(97) DESCRIBE `ports` 0.0025260448455811
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00056791305541992
(99) DESCRIBE `ports` 0.0026869773864746
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00062680244445801
(101) DESCRIBE `ports` 0.00229811668396
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00040292739868164
(103) DESCRIBE `ports` 0.0020639896392822
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00047397613525391
(105) DESCRIBE `ports` 0.0018808841705322
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00038695335388184
(107) DESCRIBE `ports` 0.0018110275268555
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00043201446533203
(109) DESCRIBE `ports` 0.0018370151519775
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00036311149597168
(111) DESCRIBE `ports` 0.0020430088043213
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00053119659423828
(113) DESCRIBE `ports` 0.0020442008972168
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0003809928894043
(115) DESCRIBE `ports` 0.0018439292907715
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042009353637695
(117) DESCRIBE `ports` 0.0023350715637207
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00059103965759277
(119) DESCRIBE `ports` 0.0026299953460693
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00063300132751465
(121) DESCRIBE `ports` 0.0023550987243652
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00052285194396973
(123) DESCRIBE `ports` 0.0020861625671387
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00056099891662598
(125) DESCRIBE `ports` 0.0020751953125
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00040102005004883
(127) DESCRIBE `ports` 0.0019311904907227
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00046396255493164
(129) DESCRIBE `ports` 0.0020148754119873
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00038909912109375
(131) DESCRIBE `ports` 0.0020239353179932
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00047111511230469
(133) DESCRIBE `ports` 0.0021460056304932
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00045490264892578
(135) DESCRIBE `ports` 0.0021131038665771
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00060415267944336
(137) DESCRIBE `ports` 0.0021100044250488
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044703483581543
(139) DESCRIBE `avid_specials` 0.0016050338745117
(140) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77388 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.0011870861053467
(141) DESCRIBE `cruiselines` 0.0025680065155029
(142) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0004730224609375
(143) DESCRIBE `orchid_image` 0.0031650066375732
(144) DESCRIBE `cruiselines` 0.0039050579071045
(145) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00061511993408203
(146) DESCRIBE `cruises` 0.0033931732177734
(147) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69369') 0.00040888786315918
(148) DESCRIBE `ships` 0.0035641193389893
(149) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1599))) 0.00047397613525391
(150) DESCRIBE `ships` 0.0038530826568604
(151) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1599') 0.00066709518432617
(152) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00042581558227539
(153) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00035595893859863
(154) DESCRIBE `itineraries` 0.0018329620361328
(155) DESCRIBE `ports` 0.0025379657745361
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00048184394836426
(157) DESCRIBE `ports` 0.0018599033355713
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00048589706420898
(159) DESCRIBE `ports` 0.0020511150360107
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00040006637573242
(161) DESCRIBE `sailingdates` 0.0019690990447998
(162) DESCRIBE `ports` 0.0021631717681885
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00058817863464355
(164) DESCRIBE `ports` 0.0022950172424316
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00043201446533203
(166) DESCRIBE `ports` 0.0019021034240723
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00050592422485352
(168) DESCRIBE `ports` 0.0019378662109375
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00042891502380371
(170) DESCRIBE `ports` 0.0020570755004883
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00054001808166504
(172) DESCRIBE `ports` 0.0022039413452148
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00055193901062012
(174) DESCRIBE `ports` 0.0024240016937256
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00053119659423828
(176) DESCRIBE `ports` 0.0023579597473145
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00046396255493164
(178) DESCRIBE `ports` 0.0019609928131104
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00064492225646973
(180) DESCRIBE `ports` 0.003079891204834
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00067996978759766
(182) DESCRIBE `ports` 0.0040900707244873
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00066494941711426
(184) DESCRIBE `ports` 0.0029981136322021
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00054693222045898
(186) DESCRIBE `ports` 0.0025420188903809
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00055599212646484
(188) DESCRIBE `ports` 0.0019760131835938
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00050902366638184
(190) DESCRIBE `avid_specials` 0.0023369789123535
(191) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69369 and class = 'Cruise') OR (item_id = 1599 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.0017881393432617
(192) DESCRIBE `cruiselines` 0.0039238929748535
(193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00053691864013672
(194) DESCRIBE `orchid_image` 0.0022017955780029
(195) DESCRIBE `cruiselines` 0.0028340816497803
(196) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00042986869812012
(197) DESCRIBE `cruises` 0.0038509368896484
(198) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70033') 0.0005950927734375
(199) DESCRIBE `ships` 0.0040760040283203
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00064396858215332
(201) DESCRIBE `ships` 0.0042660236358643
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00050020217895508
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036406517028809
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034999847412109
(205) DESCRIBE `itineraries` 0.0019738674163818
(206) DESCRIBE `ports` 0.0021119117736816
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048279762268066
(208) DESCRIBE `ports` 0.0020580291748047
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047802925109863
(210) DESCRIBE `ports` 0.0023050308227539
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.002371072769165
(212) DESCRIBE `sailingdates` 0.0022881031036377
(213) DESCRIBE `ports` 0.0020320415496826
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005030632019043
(215) DESCRIBE `ports` 0.0025079250335693
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00055480003356934
(217) DESCRIBE `ports` 0.0024299621582031
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00058102607727051
(219) DESCRIBE `ports` 0.0025289058685303
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00055694580078125
(221) DESCRIBE `ports` 0.0025341510772705
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00060796737670898
(223) DESCRIBE `ports` 0.0028018951416016
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00058889389038086
(225) DESCRIBE `ports` 0.0025629997253418
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00044083595275879
(227) DESCRIBE `ports` 0.0022680759429932
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00056004524230957
(229) DESCRIBE `ports` 0.0022470951080322
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00050997734069824
(231) DESCRIBE `ports` 0.0023860931396484
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00043606758117676
(233) DESCRIBE `ports` 0.0020270347595215
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00044798851013184
(235) DESCRIBE `ports` 0.0018160343170166
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00038695335388184
(237) DESCRIBE `ports` 0.0017750263214111
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041699409484863
(239) DESCRIBE `ports` 0.001971960067749
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041103363037109
(241) DESCRIBE `avid_specials` 0.0016629695892334
(242) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70033 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.0013689994812012
(243) DESCRIBE `cruiselines` 0.0032680034637451
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00045084953308105
(245) DESCRIBE `orchid_image` 0.0027778148651123
(246) DESCRIBE `cruiselines` 0.0032801628112793
(247) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00051116943359375
(248) DESCRIBE `cruises` 0.0035679340362549
(249) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76573') 0.00052213668823242
(250) DESCRIBE `ships` 0.0038399696350098
(251) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00082993507385254
(252) DESCRIBE `ships` 0.0045969486236572
(253) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00061702728271484
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040316581726074
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055313110351562
(256) DESCRIBE `itineraries` 0.0021951198577881
(257) DESCRIBE `ports` 0.0023698806762695
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00062394142150879
(259) DESCRIBE `ports` 0.0026299953460693
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00057005882263184
(261) DESCRIBE `ports` 0.0021219253540039
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00055098533630371
(263) DESCRIBE `sailingdates` 0.0020139217376709
(264) DESCRIBE `ports` 0.0029628276824951
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00068211555480957
(266) DESCRIBE `ports` 0.0026519298553467
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00058197975158691
(268) DESCRIBE `ports` 0.0024259090423584
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00074601173400879
(270) DESCRIBE `ports` 0.0025298595428467
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00039196014404297
(272) DESCRIBE `ports` 0.0018620491027832
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00043892860412598
(274) DESCRIBE `ports` 0.0019669532775879
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00043010711669922
(276) DESCRIBE `ports` 0.002028226852417
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040602684020996
(278) DESCRIBE `ports` 0.002169132232666
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00038790702819824
(280) DESCRIBE `ports` 0.0018038749694824
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040888786315918
(282) DESCRIBE `ports` 0.0020210742950439
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00048589706420898
(284) DESCRIBE `ports` 0.0019330978393555
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00040102005004883
(286) DESCRIBE `ports` 0.0018670558929443
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00037717819213867
(288) DESCRIBE `ports` 0.0017580986022949
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00045990943908691
(290) DESCRIBE `ports` 0.0018270015716553
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00039005279541016
(292) DESCRIBE `ports` 0.0024340152740479
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045490264892578
(294) DESCRIBE `ports` 0.0019230842590332
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00047612190246582
(296) DESCRIBE `avid_specials` 0.0017571449279785
(297) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76573 and class = 'Cruise') OR (item_id = 553 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.0012609958648682
(298) DESCRIBE `cruiselines` 0.0025448799133301
(299) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00070595741271973
(300) DESCRIBE `orchid_image` 0.0026099681854248
(301) DESCRIBE `cruiselines` 0.0026509761810303
(302) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00044703483581543
(303) DESCRIBE `cruises` 0.0034961700439453
(304) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76766') 0.00057506561279297
(305) DESCRIBE `ships` 0.0035319328308105
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00047588348388672
(307) DESCRIBE `ships` 0.0045700073242188
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00068092346191406
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003669261932373
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(311) DESCRIBE `itineraries` 0.002208948135376
(312) DESCRIBE `ports` 0.0018291473388672
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00044488906860352
(314) DESCRIBE `ports` 0.0018048286437988
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00039410591125488
(316) DESCRIBE `ports` 0.0019190311431885
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00039196014404297
(318) DESCRIBE `sailingdates` 0.0019669532775879
(319) DESCRIBE `ports` 0.015621900558472
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0007479190826416
(321) DESCRIBE `ports` 0.0030641555786133
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0010130405426025
(323) DESCRIBE `ports` 0.0031239986419678
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00069189071655273
(325) DESCRIBE `ports` 0.0020740032196045
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00046396255493164
(327) DESCRIBE `ports` 0.0024189949035645
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0005030632019043
(329) DESCRIBE `ports` 0.0023460388183594
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00048089027404785
(331) DESCRIBE `ports` 0.0020651817321777
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00098109245300293
(333) DESCRIBE `ports` 0.0018928050994873
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00047802925109863
(335) DESCRIBE `ports` 0.0020139217376709
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00043177604675293
(337) DESCRIBE `ports` 0.0022468566894531
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00060701370239258
(339) DESCRIBE `ports` 0.0024349689483643
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00046205520629883
(341) DESCRIBE `ports` 0.0021209716796875
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00050187110900879
(343) DESCRIBE `ports` 0.0024068355560303
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00058817863464355
(345) DESCRIBE `ports` 0.0026159286499023
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0004429817199707
(347) DESCRIBE `ports` 0.0018661022186279
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0004429817199707
(349) DESCRIBE `ports` 0.0018010139465332
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0004580020904541
(351) DESCRIBE `avid_specials` 0.0019769668579102
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76766 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.0013659000396729
(353) DESCRIBE `cruiselines` 0.0031001567840576
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00048613548278809
(355) DESCRIBE `orchid_image` 0.0021450519561768
(356) DESCRIBE `cruiselines` 0.0031368732452393
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00063395500183105
(358) DESCRIBE `cruises` 0.0047779083251953
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76798') 0.00058889389038086
(360) DESCRIBE `ships` 0.0038599967956543
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00051593780517578
(362) DESCRIBE `ships` 0.0035629272460938
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00043487548828125
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036311149597168
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(366) DESCRIBE `itineraries` 0.0018620491027832
(367) DESCRIBE `ports` 0.0019400119781494
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0004420280456543
(369) DESCRIBE `ports` 0.0020308494567871
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00053501129150391
(371) DESCRIBE `ports` 0.0019760131835938
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0005180835723877
(373) DESCRIBE `sailingdates` 0.0016889572143555
(374) DESCRIBE `ports` 0.0021088123321533
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0004270076751709
(376) DESCRIBE `ports` 0.0020198822021484
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00038695335388184
(378) DESCRIBE `ports` 0.0020191669464111
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00042295455932617
(380) DESCRIBE `ports` 0.0017900466918945
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00038504600524902
(382) DESCRIBE `ports` 0.0024940967559814
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00050592422485352
(384) DESCRIBE `ports` 0.0023961067199707
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00055193901062012
(386) DESCRIBE `ports` 0.0021169185638428
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00043797492980957
(388) DESCRIBE `ports` 0.0026638507843018
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00062298774719238
(390) DESCRIBE `ports` 0.0023369789123535
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00063014030456543
(392) DESCRIBE `ports` 0.002824068069458
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00055718421936035
(394) DESCRIBE `ports` 0.0022201538085938
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0005490779876709
(396) DESCRIBE `ports` 0.0020928382873535
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0004119873046875
(398) DESCRIBE `ports` 0.0024499893188477
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00078201293945312
(400) DESCRIBE `ports` 0.0027120113372803
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00050806999206543
(402) DESCRIBE `ports` 0.002263069152832
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00054597854614258
(404) DESCRIBE `ports` 0.0020601749420166
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00042080879211426
(406) DESCRIBE `avid_specials` 0.0017118453979492
(407) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76798 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.0012109279632568
(408) DESCRIBE `cruiselines` 0.0028009414672852
(409) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00046396255493164
(410) DESCRIBE `orchid_image` 0.0020489692687988
(411) DESCRIBE `cruiselines` 0.0026209354400635
(412) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0004270076751709
(413) DESCRIBE `cruises` 0.0037360191345215
(414) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77007') 0.00068998336791992
(415) DESCRIBE `ships` 0.0055949687957764
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00076413154602051
(417) DESCRIBE `ships` 0.0037100315093994
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00045895576477051
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035905838012695
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037312507629395
(421) DESCRIBE `itineraries` 0.0018339157104492
(422) DESCRIBE `ports` 0.0022339820861816
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00052404403686523
(424) DESCRIBE `ports` 0.0019328594207764
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00046205520629883
(426) DESCRIBE `ports` 0.0021500587463379
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00057005882263184
(428) DESCRIBE `sailingdates` 0.0024240016937256
(429) DESCRIBE `ports` 0.0019910335540771
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00043797492980957
(431) DESCRIBE `ports` 0.0019941329956055
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00039196014404297
(433) DESCRIBE `ports` 0.0020170211791992
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041413307189941
(435) DESCRIBE `ports` 0.0018930435180664
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041413307189941
(437) DESCRIBE `ports` 0.0018818378448486
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00048518180847168
(439) DESCRIBE `ports` 0.0022389888763428
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00040006637573242
(441) DESCRIBE `ports` 0.00187087059021
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00054311752319336
(443) DESCRIBE `ports` 0.0020430088043213
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00044488906860352
(445) DESCRIBE `ports` 0.0021400451660156
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0005640983581543
(447) DESCRIBE `ports` 0.002291202545166
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0003960132598877
(449) DESCRIBE `ports` 0.0020160675048828
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00041294097900391
(451) DESCRIBE `ports` 0.0019569396972656
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00046515464782715
(453) DESCRIBE `ports` 0.0025219917297363
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00064301490783691
(455) DESCRIBE `ports` 0.0022242069244385
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00062203407287598
(457) DESCRIBE `ports` 0.0025970935821533
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00050806999206543
(459) DESCRIBE `ports` 0.0019650459289551
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00039291381835938
(461) DESCRIBE `avid_specials` 0.0018420219421387
(462) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77007 and class = 'Cruise') OR (item_id = 407 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.0020871162414551
(463) DESCRIBE `cruiselines` 0.0029158592224121
(464) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00063800811767578
(465) DESCRIBE `orchid_image` 0.0021839141845703
(466) DESCRIBE `cruiselines` 0.0040569305419922
(467) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00090408325195312
(468) DESCRIBE `cruises` 0.0039010047912598
(469) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77087') 0.00048398971557617
(470) DESCRIBE `ships` 0.0042831897735596
(471) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00089383125305176
(472) DESCRIBE `ships` 0.0036849975585938
(473) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00051999092102051
(474) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004279613494873
(475) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035309791564941
(476) DESCRIBE `itineraries` 0.0019969940185547
(477) DESCRIBE `ports` 0.0022280216217041
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047206878662109
(479) DESCRIBE `ports` 0.0021648406982422
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00058913230895996
(481) DESCRIBE `ports` 0.0021679401397705
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042605400085449
(483) DESCRIBE `sailingdates` 0.0016529560089111
(484) DESCRIBE `ports` 0.0020480155944824
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047397613525391
(486) DESCRIBE `ports` 0.001910924911499
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040102005004883
(488) DESCRIBE `ports` 0.0018429756164551
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00043511390686035
(490) DESCRIBE `ports` 0.0018429756164551
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.0004889965057373
(492) DESCRIBE `ports` 0.0023229122161865
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00049781799316406
(494) DESCRIBE `ports` 0.0019009113311768
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00039291381835938
(496) DESCRIBE `ports` 0.00187087059021
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00038385391235352
(498) DESCRIBE `ports` 0.0019009113311768
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00043296813964844
(500) DESCRIBE `ports` 0.0018589496612549
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043702125549316
(502) DESCRIBE `ports` 0.0019030570983887
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040221214294434
(504) DESCRIBE `ports` 0.0019299983978271
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00040197372436523
(506) DESCRIBE `ports` 0.0019149780273438
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00057196617126465
(508) DESCRIBE `ports` 0.002683162689209
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00064802169799805
(510) DESCRIBE `ports` 0.0028049945831299
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00061297416687012
(512) DESCRIBE `ports` 0.0028510093688965
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00063920021057129
(514) DESCRIBE `ports` 0.0027759075164795
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00059604644775391
(516) DESCRIBE `avid_specials` 0.0025479793548584
(517) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77087 and class = 'Cruise') OR (item_id = 1588 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.002208948135376
(518) DESCRIBE `cruiselines` 0.0040769577026367
(519) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00071501731872559
(520) DESCRIBE `orchid_image` 0.0021200180053711
(521) DESCRIBE `cruiselines` 0.0024969577789307
(522) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00048494338989258
(523) DESCRIBE `cruises` 0.0047578811645508
(524) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77100') 0.00062179565429688
(525) DESCRIBE `ships` 0.0046379566192627
(526) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00068998336791992
(527) DESCRIBE `ships` 0.0055539608001709
(528) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.00067400932312012
(529) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052094459533691
(530) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005800724029541
(531) DESCRIBE `itineraries` 0.0028090476989746
(532) DESCRIBE `ports` 0.0021350383758545
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00052309036254883
(534) DESCRIBE `ports` 0.0020461082458496
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00050091743469238
(536) DESCRIBE `ports` 0.0019638538360596
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00046920776367188
(538) DESCRIBE `sailingdates` 0.0016679763793945
(539) DESCRIBE `ports` 0.0020418167114258
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00049614906311035
(541) DESCRIBE `ports` 0.0018308162689209
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00041294097900391
(543) DESCRIBE `ports` 0.0019087791442871
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00040483474731445
(545) DESCRIBE `ports` 0.0024268627166748
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0005488395690918
(547) DESCRIBE `ports` 0.0025689601898193
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00060200691223145
(549) DESCRIBE `ports` 0.0026419162750244
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00055599212646484
(551) DESCRIBE `ports` 0.0025839805603027
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.0005800724029541
(553) DESCRIBE `ports` 0.0018231868743896
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00045394897460938
(555) DESCRIBE `ports` 0.0027949810028076
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) 0.00062108039855957
(557) DESCRIBE `ports` 0.0026988983154297
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') 0.00053787231445312
(559) DESCRIBE `ports` 0.0026488304138184
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00060296058654785
(561) DESCRIBE `ports` 0.0026059150695801
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00058507919311523
(563) DESCRIBE `ports` 0.0027229785919189
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0006248950958252
(565) DESCRIBE `ports` 0.002802848815918
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00061202049255371
(567) DESCRIBE `avid_specials` 0.0023140907287598
(568) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77100 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 25 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021891593933105
(569) DESCRIBE `cruiselines` 0.0037281513214111
(570) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00065994262695312
(571) DESCRIBE `orchid_image` 0.002856969833374
(572) DESCRIBE `cruiselines` 0.0035719871520996
(573) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00054192543029785
(574) DESCRIBE `ships` 0.0037610530853271
(575) SELECT `ships`.* FROM `ships` WHERE (id IN ('726', '1588', '977', '1717', '1359', '1415', '674', '1067', '738', '407', '553', '1599', '1768', '766', '610', '352', '462', '1822', '452')) ORDER BY FIND_IN_SET(id, '726,1588,977,1717,1359,1415,674,1067,738,407,553,1599,1768,766,610,352,462,1822,452') 0.0026619434356689
(576) DESCRIBE `cruisetypes` 0.0017719268798828
(577) DESCRIBE `destinations` 0.0023701190948486
(578) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '25', '37', '28', '45', '26', '38', '52', '40', '11', '9', '49', '35', '21')) ORDER BY FIND_IN_SET(id, '22,12,25,37,28,45,26,38,52,40,11,9,49,35,21') 0.0015659332275391
(579) DESCRIBE `cruiselines` 0.0028159618377686
(580) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00047802925109863
(581) DESCRIBE `cruiselines` 0.0026710033416748
(582) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00048089027404785