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

Total elapsed time: 1.086489200592

# Query Time
(1) connect 0.0011801719665527
(2) DESCRIBE `cruises` 0.0052838325500488
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73903, 73904, 73905, 73906, 73907, 73908, 73909, 80370, 73899, 80371)) ORDER BY FIND_IN_SET(id, '73903,73904,73905,73906,73907,73908,73909,80370,73899,80371') 0.002133846282959
(4) DESCRIBE `cruises` 0.0050530433654785
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73903') 0.00067496299743652
(6) DESCRIBE `ships` 0.0041110515594482
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00048303604125977
(8) DESCRIBE `ships` 0.0039918422698975
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00042414665222168
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034284591674805
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039792060852051
(12) DESCRIBE `itineraries` 0.0019919872283936
(13) DESCRIBE `ports` 0.0018689632415771
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00043106079101562
(15) DESCRIBE `ports` 0.0017659664154053
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00044822692871094
(17) DESCRIBE `ports` 0.0017318725585938
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00043106079101562
(19) DESCRIBE `sailingdates` 0.0018000602722168
(20) DESCRIBE `ports` 0.001849889755249
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0004580020904541
(22) DESCRIBE `ports` 0.0018999576568604
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00037097930908203
(24) DESCRIBE `ports` 0.0018539428710938
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00052499771118164
(26) DESCRIBE `ports` 0.0018210411071777
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.0003809928894043
(28) DESCRIBE `ports` 0.0019040107727051
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00042915344238281
(30) DESCRIBE `ports` 0.0018348693847656
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00039100646972656
(32) DESCRIBE `ports` 0.0017759799957275
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00041413307189941
(34) DESCRIBE `ports` 0.0018160343170166
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.0005490779876709
(36) DESCRIBE `ports` 0.0019710063934326
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4363))) 0.00042986869812012
(38) DESCRIBE `ports` 0.0026779174804688
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4363') 0.00047612190246582
(40) DESCRIBE `ports` 0.0018470287322998
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00052094459533691
(42) DESCRIBE `ports` 0.0025031566619873
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00052189826965332
(44) DESCRIBE `ports` 0.0023980140686035
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.0005638599395752
(46) DESCRIBE `ports` 0.0017931461334229
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.0003809928894043
(48) DESCRIBE `ports` 0.0018699169158936
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1253))) 0.00042605400085449
(50) DESCRIBE `ports` 0.0017540454864502
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1253') 0.00038695335388184
(52) DESCRIBE `ports` 0.0018339157104492
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00037908554077148
(54) DESCRIBE `ports` 0.0019640922546387
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.0003662109375
(56) DESCRIBE `ports` 0.0018842220306396
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.00045013427734375
(58) DESCRIBE `ports` 0.0017659664154053
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00043988227844238
(60) DESCRIBE `ports` 0.0018019676208496
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00039196014404297
(62) DESCRIBE `ports` 0.0018010139465332
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00042295455932617
(64) DESCRIBE `ports` 0.001903772354126
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0003969669342041
(66) DESCRIBE `ports` 0.0017449855804443
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00040912628173828
(68) DESCRIBE `avid_specials` 0.0015571117401123
(69) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73903 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.0023171901702881
(70) DESCRIBE `cruiselines` 0.0027461051940918
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00057315826416016
(72) DESCRIBE `orchid_image` 0.002932071685791
(73) DESCRIBE `cruiselines` 0.0027151107788086
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00040888786315918
(75) DESCRIBE `cruises` 0.0038599967956543
(76) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73904') 0.00043201446533203
(77) DESCRIBE `ships` 0.0037379264831543
(78) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00049996376037598
(79) DESCRIBE `ships` 0.0034940242767334
(80) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00043821334838867
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035595893859863
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034093856811523
(83) DESCRIBE `itineraries` 0.0020120143890381
(84) DESCRIBE `ports` 0.0020699501037598
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00069499015808105
(86) DESCRIBE `ports` 0.0024950504302979
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00059199333190918
(88) DESCRIBE `ports` 0.0018951892852783
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00057506561279297
(90) DESCRIBE `sailingdates` 0.0023188591003418
(91) DESCRIBE `ports` 0.002979040145874
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00069713592529297
(93) DESCRIBE `ports` 0.0028400421142578
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00062298774719238
(95) DESCRIBE `ports` 0.0027110576629639
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00057601928710938
(97) DESCRIBE `ports` 0.0019681453704834
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00040411949157715
(99) DESCRIBE `ports` 0.0018289089202881
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00040602684020996
(101) DESCRIBE `ports` 0.0018210411071777
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00045299530029297
(103) DESCRIBE `ports` 0.0017471313476562
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.0003960132598877
(105) DESCRIBE `ports` 0.0021400451660156
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00039505958557129
(107) DESCRIBE `ports` 0.0018229484558105
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00039315223693848
(109) DESCRIBE `ports` 0.0018391609191895
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00037288665771484
(111) DESCRIBE `ports` 0.0017788410186768
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00039887428283691
(113) DESCRIBE `ports` 0.0018649101257324
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00036001205444336
(115) DESCRIBE `ports` 0.0018599033355713
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00039100646972656
(117) DESCRIBE `ports` 0.0017659664154053
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00054502487182617
(119) DESCRIBE `ports` 0.0019569396972656
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00072908401489258
(121) DESCRIBE `ports` 0.0024008750915527
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00050497055053711
(123) DESCRIBE `ports` 0.0022289752960205
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0005190372467041
(125) DESCRIBE `ports` 0.0020730495452881
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00045990943908691
(127) DESCRIBE `ports` 0.0017600059509277
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00044608116149902
(129) DESCRIBE `ports` 0.0018160343170166
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00037193298339844
(131) DESCRIBE `avid_specials` 0.0017311573028564
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73904 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.0011260509490967
(133) DESCRIBE `cruiselines` 0.002532958984375
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00052690505981445
(135) DESCRIBE `orchid_image` 0.00217604637146
(136) DESCRIBE `cruiselines` 0.002593994140625
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00050806999206543
(138) DESCRIBE `cruises` 0.0039899349212646
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73905') 0.00046110153198242
(140) DESCRIBE `ships` 0.0034739971160889
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00050997734069824
(142) DESCRIBE `ships` 0.0041890144348145
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.000640869140625
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053501129150391
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051999092102051
(146) DESCRIBE `itineraries` 0.0028111934661865
(147) DESCRIBE `ports` 0.0024628639221191
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00059199333190918
(149) DESCRIBE `ports` 0.0023019313812256
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00056219100952148
(151) DESCRIBE `ports` 0.0023870468139648
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00051689147949219
(153) DESCRIBE `sailingdates` 0.0019850730895996
(154) DESCRIBE `ports` 0.0023500919342041
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00059795379638672
(156) DESCRIBE `ports` 0.0022509098052979
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00050115585327148
(158) DESCRIBE `ports` 0.0050549507141113
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0010941028594971
(160) DESCRIBE `ports` 0.0077610015869141
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00068521499633789
(162) DESCRIBE `ports` 0.0034451484680176
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.0007171630859375
(164) DESCRIBE `ports` 0.0026819705963135
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00055909156799316
(166) DESCRIBE `ports` 0.0022861957550049
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00058388710021973
(168) DESCRIBE `ports` 0.0024828910827637
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00053286552429199
(170) DESCRIBE `ports` 0.0018961429595947
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00064301490783691
(172) DESCRIBE `ports` 0.0019872188568115
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00040483474731445
(174) DESCRIBE `ports` 0.002457857131958
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.0005648136138916
(176) DESCRIBE `ports` 0.0019619464874268
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00051116943359375
(178) DESCRIBE `ports` 0.0019509792327881
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00054812431335449
(180) DESCRIBE `ports` 0.0024681091308594
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00059604644775391
(182) DESCRIBE `ports` 0.0021090507507324
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00048589706420898
(184) DESCRIBE `ports` 0.0022938251495361
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00041794776916504
(186) DESCRIBE `ports` 0.0020751953125
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00060510635375977
(188) DESCRIBE `ports` 0.0021920204162598
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00042605400085449
(190) DESCRIBE `ports` 0.0019090175628662
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0004270076751709
(192) DESCRIBE `ports` 0.0018670558929443
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00040006637573242
(194) DESCRIBE `avid_specials` 0.0018808841705322
(195) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73905 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.0012400150299072
(196) DESCRIBE `cruiselines` 0.0031490325927734
(197) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00060701370239258
(198) DESCRIBE `orchid_image` 0.0021328926086426
(199) DESCRIBE `cruiselines` 0.0032119750976562
(200) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00045204162597656
(201) DESCRIBE `cruises` 0.0040891170501709
(202) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73906') 0.00067806243896484
(203) DESCRIBE `ships` 0.0057609081268311
(204) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00086593627929688
(205) DESCRIBE `ships` 0.0045859813690186
(206) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00068402290344238
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054097175598145
(208) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036501884460449
(209) DESCRIBE `itineraries` 0.0023181438446045
(210) DESCRIBE `ports` 0.0021190643310547
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00059890747070312
(212) DESCRIBE `ports` 0.0019910335540771
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00044393539428711
(214) DESCRIBE `ports` 0.0018959045410156
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00066709518432617
(216) DESCRIBE `sailingdates` 0.0023088455200195
(217) DESCRIBE `ports` 0.0026669502258301
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00048613548278809
(219) DESCRIBE `ports` 0.0019650459289551
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00042819976806641
(221) DESCRIBE `ports` 0.0017690658569336
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00054597854614258
(223) DESCRIBE `ports` 0.0018990039825439
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0004429817199707
(225) DESCRIBE `ports` 0.0027520656585693
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 444))) 0.00063204765319824
(227) DESCRIBE `ports` 0.0024402141571045
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '444') 0.00062298774719238
(229) DESCRIBE `ports` 0.0023219585418701
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3529))) 0.00048708915710449
(231) DESCRIBE `ports` 0.0025858879089355
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3529') 0.00051498413085938
(233) DESCRIBE `ports` 0.0024681091308594
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00044083595275879
(235) DESCRIBE `ports` 0.0018939971923828
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00049304962158203
(237) DESCRIBE `ports` 0.0018699169158936
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00045990943908691
(239) DESCRIBE `ports` 0.0020980834960938
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00040507316589355
(241) DESCRIBE `ports` 0.0020310878753662
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00041985511779785
(243) DESCRIBE `ports` 0.0020699501037598
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00042915344238281
(245) DESCRIBE `ports` 0.0019018650054932
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00049901008605957
(247) DESCRIBE `ports` 0.0019979476928711
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00042200088500977
(249) DESCRIBE `ports` 0.0019791126251221
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00039315223693848
(251) DESCRIBE `ports` 0.0020380020141602
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00036787986755371
(253) DESCRIBE `ports` 0.0018770694732666
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00040698051452637
(255) DESCRIBE `ports` 0.0023119449615479
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00080204010009766
(257) DESCRIBE `avid_specials` 0.0027461051940918
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73906 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.0022830963134766
(259) DESCRIBE `cruiselines` 0.0040860176086426
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00075387954711914
(261) DESCRIBE `orchid_image` 0.0032799243927002
(262) DESCRIBE `cruiselines` 0.0040950775146484
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00068879127502441
(264) DESCRIBE `cruises` 0.0053150653839111
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73907') 0.00066113471984863
(266) DESCRIBE `ships` 0.0055830478668213
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00080299377441406
(268) DESCRIBE `ships` 0.0050280094146729
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00063014030456543
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048589706420898
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00045108795166016
(272) DESCRIBE `itineraries` 0.0026340484619141
(273) DESCRIBE `ports` 0.0026340484619141
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00063109397888184
(275) DESCRIBE `ports` 0.0025448799133301
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00059008598327637
(277) DESCRIBE `ports` 0.0025820732116699
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00057792663574219
(279) DESCRIBE `sailingdates` 0.0022141933441162
(280) DESCRIBE `ports` 0.0027141571044922
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00064206123352051
(282) DESCRIBE `ports` 0.002824068069458
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00060009956359863
(284) DESCRIBE `ports` 0.0028698444366455
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00079011917114258
(286) DESCRIBE `ports` 0.0027720928192139
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.0006561279296875
(288) DESCRIBE `ports` 0.0026199817657471
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00070500373840332
(290) DESCRIBE `ports` 0.0032289028167725
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00065708160400391
(292) DESCRIBE `ports` 0.0029349327087402
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00066494941711426
(294) DESCRIBE `ports` 0.002856969833374
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00061607360839844
(296) DESCRIBE `ports` 0.0028560161590576
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00063204765319824
(298) DESCRIBE `ports` 0.0028750896453857
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.0005950927734375
(300) DESCRIBE `ports` 0.0029501914978027
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.0006718635559082
(302) DESCRIBE `ports` 0.0026118755340576
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00044608116149902
(304) DESCRIBE `ports` 0.0019328594207764
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00044703483581543
(306) DESCRIBE `ports` 0.0020730495452881
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00047898292541504
(308) DESCRIBE `ports` 0.0026068687438965
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00063085556030273
(310) DESCRIBE `ports` 0.0027370452880859
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00057005882263184
(312) DESCRIBE `ports` 0.0027670860290527
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00080394744873047
(314) DESCRIBE `ports` 0.0023708343505859
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00047421455383301
(316) DESCRIBE `ports` 0.0020830631256104
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00045084953308105
(318) DESCRIBE `ports` 0.0019760131835938
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00043821334838867
(320) DESCRIBE `avid_specials` 0.0017440319061279
(321) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73907 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.0011470317840576
(322) DESCRIBE `cruiselines` 0.003169059753418
(323) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00076007843017578
(324) DESCRIBE `orchid_image` 0.0029730796813965
(325) DESCRIBE `cruiselines` 0.0039730072021484
(326) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00065302848815918
(327) DESCRIBE `cruises` 0.0049121379852295
(328) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73908') 0.00057482719421387
(329) DESCRIBE `ships` 0.0042028427124023
(330) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00055193901062012
(331) DESCRIBE `ships` 0.00419020652771
(332) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00054216384887695
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041890144348145
(334) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037884712219238
(335) DESCRIBE `itineraries` 0.0020360946655273
(336) DESCRIBE `ports` 0.0020718574523926
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00049400329589844
(338) DESCRIBE `ports` 0.0022790431976318
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00062084197998047
(340) DESCRIBE `ports` 0.002094030380249
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0004580020904541
(342) DESCRIBE `sailingdates` 0.0016610622406006
(343) DESCRIBE `ports` 0.0022170543670654
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00062894821166992
(345) DESCRIBE `ports` 0.0021529197692871
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00046491622924805
(347) DESCRIBE `ports` 0.0021569728851318
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00044584274291992
(349) DESCRIBE `ports` 0.0022521018981934
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00056099891662598
(351) DESCRIBE `ports` 0.0029001235961914
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.0007779598236084
(353) DESCRIBE `ports` 0.0029690265655518
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00048685073852539
(355) DESCRIBE `ports` 0.002129077911377
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00043892860412598
(357) DESCRIBE `ports` 0.002147912979126
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00045299530029297
(359) DESCRIBE `ports` 0.001816987991333
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00041890144348145
(361) DESCRIBE `ports` 0.0023910999298096
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00057077407836914
(363) DESCRIBE `ports` 0.0028917789459229
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00065302848815918
(365) DESCRIBE `ports` 0.0029089450836182
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00065302848815918
(367) DESCRIBE `ports` 0.0029921531677246
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00076389312744141
(369) DESCRIBE `ports` 0.0028610229492188
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0006258487701416
(371) DESCRIBE `ports` 0.0028450489044189
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00058794021606445
(373) DESCRIBE `ports` 0.0030457973480225
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00053501129150391
(375) DESCRIBE `ports` 0.0021278858184814
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00064992904663086
(377) DESCRIBE `ports` 0.0020217895507812
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00046896934509277
(379) DESCRIBE `ports` 0.0025389194488525
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00053906440734863
(381) DESCRIBE `ports` 0.0022110939025879
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00040888786315918
(383) DESCRIBE `avid_specials` 0.0020380020141602
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73908 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.001349925994873
(385) DESCRIBE `cruiselines` 0.0029311180114746
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00064706802368164
(387) DESCRIBE `orchid_image` 0.0023560523986816
(388) DESCRIBE `cruiselines` 0.004270076751709
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00046610832214355
(390) DESCRIBE `cruises` 0.0046160221099854
(391) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73909') 0.00059008598327637
(392) DESCRIBE `ships` 0.0046448707580566
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.0005500316619873
(394) DESCRIBE `ships` 0.0040230751037598
(395) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00044989585876465
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041890144348145
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003662109375
(398) DESCRIBE `itineraries` 0.0021450519561768
(399) DESCRIBE `ports` 0.0022571086883545
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00054097175598145
(401) DESCRIBE `ports` 0.0021021366119385
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00051712989807129
(403) DESCRIBE `ports` 0.0019569396972656
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00043010711669922
(405) DESCRIBE `sailingdates` 0.0018699169158936
(406) DESCRIBE `ports` 0.002335786819458
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00052404403686523
(408) DESCRIBE `ports` 0.0023608207702637
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0004580020904541
(410) DESCRIBE `ports` 0.0019958019256592
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00047397613525391
(412) DESCRIBE `ports` 0.0019340515136719
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00041484832763672
(414) DESCRIBE `ports` 0.001910924911499
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00043201446533203
(416) DESCRIBE `ports` 0.0020208358764648
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00041604042053223
(418) DESCRIBE `ports` 0.0019359588623047
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00087785720825195
(420) DESCRIBE `ports` 0.0030338764190674
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00071883201599121
(422) DESCRIBE `ports` 0.0030829906463623
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1253))) 0.00086092948913574
(424) DESCRIBE `ports` 0.0029780864715576
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1253') 0.00046491622924805
(426) DESCRIBE `ports` 0.0017797946929932
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00054383277893066
(428) DESCRIBE `ports` 0.0021779537200928
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00072216987609863
(430) DESCRIBE `ports` 0.0025129318237305
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00046086311340332
(432) DESCRIBE `ports` 0.0018949508666992
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00040411949157715
(434) DESCRIBE `ports` 0.0018730163574219
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.0004570484161377
(436) DESCRIBE `ports` 0.0022940635681152
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00052189826965332
(438) DESCRIBE `ports` 0.0027329921722412
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3927))) 0.0006098747253418
(440) DESCRIBE `ports` 0.0020620822906494
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3927') 0.00046801567077637
(442) DESCRIBE `ports` 0.0020449161529541
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00062799453735352
(444) DESCRIBE `ports` 0.0020418167114258
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00043010711669922
(446) DESCRIBE `avid_specials` 0.0022590160369873
(447) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73909 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.0014219284057617
(448) DESCRIBE `cruiselines` 0.0030531883239746
(449) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0005180835723877
(450) DESCRIBE `orchid_image` 0.0027370452880859
(451) DESCRIBE `cruiselines` 0.0036900043487549
(452) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00057792663574219
(453) DESCRIBE `cruises` 0.0037789344787598
(454) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80370') 0.00051093101501465
(455) DESCRIBE `ships` 0.0041091442108154
(456) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.000701904296875
(457) DESCRIBE `ships` 0.0037848949432373
(458) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00047802925109863
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035715103149414
(460) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034809112548828
(461) DESCRIBE `itineraries` 0.0021071434020996
(462) DESCRIBE `ports` 0.0024600028991699
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.0007331371307373
(464) DESCRIBE `ports` 0.0027179718017578
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.0006721019744873
(466) DESCRIBE `ports` 0.0022509098052979
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00057721138000488
(468) DESCRIBE `sailingdates` 0.0021278858184814
(469) DESCRIBE `ports` 0.0022768974304199
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00066304206848145
(471) DESCRIBE `ports` 0.0021729469299316
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.0005030632019043
(473) DESCRIBE `ports` 0.0020220279693604
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3927))) 0.00048708915710449
(475) DESCRIBE `ports` 0.0021259784698486
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3927') 0.00052499771118164
(477) DESCRIBE `ports` 0.0020570755004883
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00044798851013184
(479) DESCRIBE `ports` 0.0025599002838135
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00054097175598145
(481) DESCRIBE `ports` 0.0027039051055908
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00060200691223145
(483) DESCRIBE `ports` 0.00276780128479
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00059604644775391
(485) DESCRIBE `ports` 0.0026991367340088
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00072312355041504
(487) DESCRIBE `ports` 0.0024120807647705
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00059199333190918
(489) DESCRIBE `ports` 0.0020699501037598
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1253))) 0.00045394897460938
(491) DESCRIBE `ports` 0.0019338130950928
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1253') 0.00043392181396484
(493) DESCRIBE `ports` 0.0019690990447998
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1673))) 0.00043082237243652
(495) DESCRIBE `ports` 0.0020310878753662
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1673') 0.00043010711669922
(497) DESCRIBE `ports` 0.0018930435180664
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1673))) 0.00041413307189941
(499) DESCRIBE `ports` 0.0018439292907715
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1673') 0.00044703483581543
(501) DESCRIBE `ports` 0.0017788410186768
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00045585632324219
(503) DESCRIBE `ports` 0.0018618106842041
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00038886070251465
(505) DESCRIBE `ports` 0.0019068717956543
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00052714347839355
(507) DESCRIBE `ports` 0.0020051002502441
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00041389465332031
(509) DESCRIBE `ports` 0.0020418167114258
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00055098533630371
(511) DESCRIBE `ports` 0.0021858215332031
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00047898292541504
(513) DESCRIBE `avid_specials` 0.0018899440765381
(514) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80370 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.001338005065918
(515) DESCRIBE `cruiselines` 0.0028362274169922
(516) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00069093704223633
(517) DESCRIBE `orchid_image` 0.0021810531616211
(518) DESCRIBE `cruiselines` 0.0026288032531738
(519) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00051307678222656
(520) DESCRIBE `cruises` 0.0050148963928223
(521) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73899') 0.00052094459533691
(522) DESCRIBE `ships` 0.0042109489440918
(523) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00091695785522461
(524) DESCRIBE `ships` 0.0052058696746826
(525) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00069999694824219
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004880428314209
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004580020904541
(528) DESCRIBE `itineraries` 0.0034968852996826
(529) DESCRIBE `ports` 0.0031499862670898
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00070500373840332
(531) DESCRIBE `ports` 0.0020620822906494
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00043606758117676
(533) DESCRIBE `ports` 0.00193190574646
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00044012069702148
(535) DESCRIBE `sailingdates` 0.0020098686218262
(536) DESCRIBE `ports` 0.0021519660949707
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00049209594726562
(538) DESCRIBE `ports` 0.0022029876708984
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00043892860412598
(540) DESCRIBE `ports` 0.0020768642425537
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00046801567077637
(542) DESCRIBE `ports` 0.0026590824127197
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00060009956359863
(544) DESCRIBE `ports` 0.0025389194488525
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00047111511230469
(546) DESCRIBE `ports` 0.0022921562194824
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00045299530029297
(548) DESCRIBE `ports` 0.002295970916748
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00049090385437012
(550) DESCRIBE `ports` 0.0020210742950439
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00041580200195312
(552) DESCRIBE `ports` 0.00205397605896
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00050497055053711
(554) DESCRIBE `ports` 0.0024509429931641
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00049495697021484
(556) DESCRIBE `ports` 0.0025079250335693
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4363))) 0.00047612190246582
(558) DESCRIBE `ports` 0.0019800662994385
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4363') 0.00047802925109863
(560) DESCRIBE `ports` 0.001859188079834
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00043988227844238
(562) DESCRIBE `ports` 0.0023210048675537
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.0005180835723877
(564) DESCRIBE `ports` 0.0025699138641357
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00050210952758789
(566) DESCRIBE `ports` 0.0022759437561035
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00049901008605957
(568) DESCRIBE `ports` 0.0023429393768311
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2354))) 0.00046300888061523
(570) DESCRIBE `ports` 0.001910924911499
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2354') 0.00057077407836914
(572) DESCRIBE `ports` 0.0029401779174805
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00046396255493164
(574) DESCRIBE `ports` 0.0023300647735596
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00057387351989746
(576) DESCRIBE `ports` 0.0026180744171143
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00066494941711426
(578) DESCRIBE `ports` 0.0024721622467041
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00049400329589844
(580) DESCRIBE `avid_specials` 0.0018908977508545
(581) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73899 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.0013411045074463
(582) DESCRIBE `cruiselines` 0.0028929710388184
(583) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00053882598876953
(584) DESCRIBE `orchid_image` 0.0021851062774658
(585) DESCRIBE `cruiselines` 0.0028870105743408
(586) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00053596496582031
(587) DESCRIBE `cruises` 0.0044689178466797
(588) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80371') 0.00060486793518066
(589) DESCRIBE `ships` 0.0047619342803955
(590) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00085806846618652
(591) DESCRIBE `ships` 0.0051660537719727
(592) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00068187713623047
(593) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052499771118164
(594) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036311149597168
(595) DESCRIBE `itineraries` 0.0029349327087402
(596) DESCRIBE `ports` 0.0031509399414062
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00067591667175293
(598) DESCRIBE `ports` 0.0026700496673584
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00062394142150879
(600) DESCRIBE `ports` 0.0025520324707031
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00064802169799805
(602) DESCRIBE `sailingdates` 0.0022408962249756
(603) DESCRIBE `ports` 0.0026750564575195
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00075793266296387
(605) DESCRIBE `ports` 0.0025229454040527
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00051593780517578
(607) DESCRIBE `ports` 0.0022971630096436
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00053000450134277
(609) DESCRIBE `ports` 0.0023469924926758
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.0005490779876709
(611) DESCRIBE `ports` 0.0024869441986084
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00060105323791504
(613) DESCRIBE `ports` 0.0023858547210693
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00049495697021484
(615) DESCRIBE `ports` 0.0022950172424316
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00054502487182617
(617) DESCRIBE `ports` 0.002547025680542
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00052499771118164
(619) DESCRIBE `ports` 0.0023558139801025
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00053310394287109
(621) DESCRIBE `ports` 0.0023438930511475
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00049996376037598
(623) DESCRIBE `ports` 0.0023648738861084
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4363))) 0.00056290626525879
(625) DESCRIBE `ports` 0.0023300647735596
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4363') 0.00048303604125977
(627) DESCRIBE `ports` 0.0023539066314697
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00055503845214844
(629) DESCRIBE `ports` 0.002547025680542
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00050592422485352
(631) DESCRIBE `ports` 0.0023360252380371
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00056791305541992
(633) DESCRIBE `ports` 0.0023429393768311
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00048685073852539
(635) DESCRIBE `ports` 0.002377986907959
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2354))) 0.00057697296142578
(637) DESCRIBE `ports` 0.0023589134216309
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2354') 0.00051712989807129
(639) DESCRIBE `ports` 0.0023531913757324
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00053310394287109
(641) DESCRIBE `ports` 0.0023388862609863
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00057315826416016
(643) DESCRIBE `ports` 0.0023610591888428
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00057005882263184
(645) DESCRIBE `ports` 0.0023720264434814
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00050687789916992
(647) DESCRIBE `avid_specials` 0.0021181106567383
(648) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80371 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.0017530918121338
(649) DESCRIBE `cruiselines` 0.0033090114593506
(650) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0005791187286377
(651) DESCRIBE `orchid_image` 0.0026118755340576
(652) DESCRIBE `cruiselines` 0.0033979415893555
(653) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00053501129150391
(654) DESCRIBE `cruisetypes` 0.0021910667419434
(655) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '8') AND (cruises_and_specials.ship_id = '45') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.036881923675537
(656) DESCRIBE `destinations` 0.0037450790405273
(657) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('35', '2')) ORDER BY FIND_IN_SET(id, '35,2') 0.00096702575683594
(658) DESCRIBE `cruiselines` 0.0028460025787354
(659) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0005030632019043
(660) DESCRIBE `ships` 0.0042650699615479
(661) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00055885314941406
(662) DESCRIBE `cruiselines` 0.0034959316253662
(663) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00047802925109863
(664) DESCRIBE `ships` 0.0036990642547607
(665) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00048184394836426