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

Total elapsed time: 1.5988063812256

# Query Time
(1) connect 0.0011298656463623
(2) DESCRIBE `cruises` 0.0044291019439697
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72812, 72887, 72903, 72876, 72837, 72900, 72933, 72859, 66202, 72898)) ORDER BY FIND_IN_SET(id, '72812,72887,72903,72876,72837,72900,72933,72859,66202,72898') 0.002471923828125
(4) DESCRIBE `cruises` 0.0042731761932373
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72812') 0.00040316581726074
(6) DESCRIBE `ships` 0.0042710304260254
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.0016968250274658
(8) DESCRIBE `ships` 0.004065990447998
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.0007169246673584
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052118301391602
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005030632019043
(12) DESCRIBE `itineraries` 0.0023410320281982
(13) DESCRIBE `ports` 0.001924991607666
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00056791305541992
(15) DESCRIBE `ports` 0.0017910003662109
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00040602684020996
(17) DESCRIBE `ports` 0.0023488998413086
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0003969669342041
(19) DESCRIBE `sailingdates` 0.0020320415496826
(20) DESCRIBE `ports` 0.0020270347595215
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00044608116149902
(22) DESCRIBE `ports` 0.0020110607147217
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00046205520629883
(24) DESCRIBE `ports` 0.0019650459289551
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.00043106079101562
(26) DESCRIBE `ports` 0.0024499893188477
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.00044488906860352
(28) DESCRIBE `ports` 0.0026650428771973
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.00044798851013184
(30) DESCRIBE `ports` 0.0023729801177979
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.00037693977355957
(32) DESCRIBE `ports` 0.0023682117462158
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.00039291381835938
(34) DESCRIBE `ports` 0.0027718544006348
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.00048398971557617
(36) DESCRIBE `ports` 0.0026619434356689
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.00041794776916504
(38) DESCRIBE `ports` 0.0021669864654541
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.0004279613494873
(40) DESCRIBE `ports` 0.0020101070404053
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.00045895576477051
(42) DESCRIBE `ports` 0.0021369457244873
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.00059199333190918
(44) DESCRIBE `ports` 0.0034189224243164
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00058817863464355
(46) DESCRIBE `ports` 0.0027749538421631
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00057506561279297
(48) DESCRIBE `avid_specials` 0.0030138492584229
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72812 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 10 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.0023388862609863
(50) DESCRIBE `cruiselines` 0.0029408931732178
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00043511390686035
(52) DESCRIBE `orchid_image` 0.0022830963134766
(53) DESCRIBE `cruiselines` 0.003568172454834
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00046682357788086
(55) DESCRIBE `cruises` 0.0038080215454102
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72887') 0.00039505958557129
(57) DESCRIBE `ships` 0.0035479068756104
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00046706199645996
(59) DESCRIBE `ships` 0.0038521289825439
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00039887428283691
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003809928894043
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0064139366149902
(63) DESCRIBE `itineraries` 0.0061249732971191
(64) DESCRIBE `ports` 0.0022361278533936
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00046205520629883
(66) DESCRIBE `ports` 0.0026731491088867
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00043201446533203
(68) DESCRIBE `ports` 0.0024411678314209
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00040411949157715
(70) DESCRIBE `sailingdates` 0.002701997756958
(71) DESCRIBE `ports` 0.0025749206542969
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00046300888061523
(73) DESCRIBE `ports` 0.002586841583252
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00050997734069824
(75) DESCRIBE `ports` 0.0028109550476074
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00043916702270508
(77) DESCRIBE `ports` 0.0023961067199707
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00039196014404297
(79) DESCRIBE `ports` 0.0027611255645752
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00045919418334961
(81) DESCRIBE `ports` 0.0025041103363037
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00042486190795898
(83) DESCRIBE `ports` 0.0025279521942139
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00043511390686035
(85) DESCRIBE `ports` 0.0026741027832031
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00040197372436523
(87) DESCRIBE `ports` 0.0019340515136719
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0004889965057373
(89) DESCRIBE `ports` 0.0021109580993652
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.0005500316619873
(91) DESCRIBE `ports` 0.0026109218597412
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1262))) 0.00043082237243652
(93) DESCRIBE `ports` 0.0020699501037598
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1262') 0.00039792060852051
(95) DESCRIBE `ports` 0.002514123916626
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00041913986206055
(97) DESCRIBE `ports` 0.0022878646850586
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0003819465637207
(99) DESCRIBE `avid_specials` 0.0018291473388672
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72887 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001194953918457
(101) DESCRIBE `cruiselines` 0.003108024597168
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00056600570678711
(103) DESCRIBE `orchid_image` 0.0025691986083984
(104) DESCRIBE `cruiselines` 0.0055868625640869
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00038290023803711
(106) DESCRIBE `cruises` 0.0041649341583252
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72903') 0.00053501129150391
(108) DESCRIBE `ships` 0.0034208297729492
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00062417984008789
(110) DESCRIBE `ships` 0.003662109375
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.0004730224609375
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003960132598877
(114) DESCRIBE `itineraries` 0.0017158985137939
(115) DESCRIBE `ports` 0.001990795135498
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041604042053223
(117) DESCRIBE `ports` 0.002079963684082
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042581558227539
(119) DESCRIBE `ports` 0.00217604637146
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039792060852051
(121) DESCRIBE `sailingdates` 0.0019469261169434
(122) DESCRIBE `ports` 0.0036478042602539
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00068116188049316
(124) DESCRIBE `ports` 0.0027239322662354
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00057721138000488
(126) DESCRIBE `ports` 0.0028290748596191
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00047397613525391
(128) DESCRIBE `ports` 0.0028069019317627
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00058197975158691
(130) DESCRIBE `ports` 0.0026488304138184
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00043010711669922
(132) DESCRIBE `ports` 0.0025708675384521
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.0004119873046875
(134) DESCRIBE `ports` 0.0021131038665771
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00046086311340332
(136) DESCRIBE `ports` 0.0019841194152832
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00042080879211426
(138) DESCRIBE `ports` 0.0018529891967773
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1198))) 0.00066900253295898
(140) DESCRIBE `ports` 0.0030620098114014
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1198') 0.00048494338989258
(142) DESCRIBE `ports` 0.0027918815612793
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0006411075592041
(144) DESCRIBE `ports` 0.0031158924102783
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00048303604125977
(146) DESCRIBE `ports` 0.0057699680328369
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00067520141601562
(148) DESCRIBE `ports` 0.0028960704803467
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00053787231445312
(150) DESCRIBE `ports` 0.0025219917297363
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00070500373840332
(152) DESCRIBE `ports` 0.003248929977417
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00052499771118164
(154) DESCRIBE `ports` 0.002810001373291
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00063586235046387
(156) DESCRIBE `ports` 0.0032191276550293
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00060701370239258
(158) DESCRIBE `ports` 0.002892017364502
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00060200691223145
(160) DESCRIBE `ports` 0.0028290748596191
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00055193901062012
(162) DESCRIBE `avid_specials` 0.0025160312652588
(163) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72903 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 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.0022687911987305
(164) DESCRIBE `cruiselines` 0.0035510063171387
(165) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00073885917663574
(166) DESCRIBE `orchid_image` 0.0029139518737793
(167) DESCRIBE `cruiselines` 0.0036602020263672
(168) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00064802169799805
(169) DESCRIBE `cruises` 0.005728006362915
(170) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72876') 0.00059008598327637
(171) DESCRIBE `ships` 0.0051770210266113
(172) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.00058412551879883
(173) DESCRIBE `ships` 0.00357985496521
(174) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00038886070251465
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044798851013184
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035285949707031
(177) DESCRIBE `itineraries` 0.0022869110107422
(178) DESCRIBE `ports` 0.0020918846130371
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00042200088500977
(180) DESCRIBE `ports` 0.002072811126709
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00041103363037109
(182) DESCRIBE `ports` 0.0024590492248535
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00044393539428711
(184) DESCRIBE `sailingdates` 0.0020380020141602
(185) DESCRIBE `ports` 0.0023970603942871
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00043797492980957
(187) DESCRIBE `ports` 0.0021328926086426
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0003960132598877
(189) DESCRIBE `ports` 0.0024740695953369
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00041604042053223
(191) DESCRIBE `ports` 0.0025079250335693
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00037598609924316
(193) DESCRIBE `ports` 0.0023889541625977
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 642))) 0.00047087669372559
(195) DESCRIBE `ports` 0.0020489692687988
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '642') 0.0004420280456543
(197) DESCRIBE `ports` 0.0024161338806152
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00048708915710449
(199) DESCRIBE `ports` 0.0022299289703369
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00037598609924316
(201) DESCRIBE `ports` 0.0026450157165527
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00051689147949219
(203) DESCRIBE `ports` 0.0024409294128418
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00056004524230957
(205) DESCRIBE `ports` 0.0025501251220703
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00061583518981934
(207) DESCRIBE `ports` 0.0021369457244873
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00042414665222168
(209) DESCRIBE `ports` 0.0024330615997314
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00049996376037598
(211) DESCRIBE `ports` 0.0021770000457764
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00055694580078125
(213) DESCRIBE `ports` 0.0022308826446533
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00056099891662598
(215) DESCRIBE `ports` 0.0020689964294434
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00042200088500977
(217) DESCRIBE `ports` 0.0020289421081543
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00055384635925293
(219) DESCRIBE `ports` 0.0023660659790039
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00040102005004883
(221) DESCRIBE `ports` 0.0019559860229492
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00041604042053223
(223) DESCRIBE `ports` 0.0024068355560303
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00043416023254395
(225) DESCRIBE `ports` 0.0049259662628174
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00047516822814941
(227) DESCRIBE `ports` 0.0022480487823486
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00045204162597656
(229) DESCRIBE `avid_specials` 0.0016369819641113
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72876 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 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.0013408660888672
(231) DESCRIBE `cruiselines` 0.0026252269744873
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00042486190795898
(233) DESCRIBE `orchid_image` 0.0021319389343262
(234) DESCRIBE `cruiselines` 0.0031380653381348
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00045299530029297
(236) DESCRIBE `cruises` 0.0043570995330811
(237) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72837') 0.00043702125549316
(238) DESCRIBE `ships` 0.0038340091705322
(239) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0004420280456543
(240) DESCRIBE `ships` 0.0036001205444336
(241) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00041484832763672
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038385391235352
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036907196044922
(244) DESCRIBE `itineraries` 0.0028319358825684
(245) DESCRIBE `ports` 0.002140998840332
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0004727840423584
(247) DESCRIBE `ports` 0.0027880668640137
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0004119873046875
(249) DESCRIBE `ports` 0.0020711421966553
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00049996376037598
(251) DESCRIBE `sailingdates` 0.0016381740570068
(252) DESCRIBE `ports` 0.0019609928131104
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00055599212646484
(254) DESCRIBE `ports` 0.0020320415496826
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00050711631774902
(256) DESCRIBE `ports` 0.0022170543670654
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00045490264892578
(258) DESCRIBE `ports` 0.0019738674163818
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00042200088500977
(260) DESCRIBE `ports` 0.0020699501037598
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00044894218444824
(262) DESCRIBE `ports` 0.0026340484619141
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0004878044128418
(264) DESCRIBE `ports` 0.0026500225067139
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00059103965759277
(266) DESCRIBE `ports` 0.003032922744751
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00058317184448242
(268) DESCRIBE `ports` 0.0025498867034912
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00064301490783691
(270) DESCRIBE `ports` 0.0024199485778809
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00057291984558105
(272) DESCRIBE `ports` 0.0021178722381592
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00052690505981445
(274) DESCRIBE `ports` 0.002363920211792
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00046586990356445
(276) DESCRIBE `ports` 0.0030028820037842
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00065994262695312
(278) DESCRIBE `ports` 0.0037140846252441
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.0006709098815918
(280) DESCRIBE `ports` 0.0032150745391846
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00073099136352539
(282) DESCRIBE `ports` 0.0030019283294678
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00062012672424316
(284) DESCRIBE `ports` 0.0021359920501709
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00046086311340332
(286) DESCRIBE `ports` 0.0034070014953613
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00058603286743164
(288) DESCRIBE `ports` 0.0035240650177002
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00070619583129883
(290) DESCRIBE `ports` 0.0027720928192139
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00072002410888672
(292) DESCRIBE `avid_specials` 0.0031728744506836
(293) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72837 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 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.0021920204162598
(294) DESCRIBE `cruiselines` 0.0037820339202881
(295) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00057411193847656
(296) DESCRIBE `orchid_image` 0.0030899047851562
(297) DESCRIBE `cruiselines` 0.002953052520752
(298) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00050902366638184
(299) DESCRIBE `cruises` 0.0039999485015869
(300) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72900') 0.00046491622924805
(301) DESCRIBE `ships` 0.0052878856658936
(302) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00072097778320312
(303) DESCRIBE `ships` 0.0056638717651367
(304) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00055599212646484
(305) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049591064453125
(306) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053310394287109
(307) DESCRIBE `itineraries` 0.0025839805603027
(308) DESCRIBE `ports` 0.0026559829711914
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00059103965759277
(310) DESCRIBE `ports` 0.0027079582214355
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00056099891662598
(312) DESCRIBE `ports` 0.0028209686279297
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0005500316619873
(314) DESCRIBE `sailingdates` 0.002316951751709
(315) DESCRIBE `ports` 0.0018610954284668
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00040698051452637
(317) DESCRIBE `ports` 0.0030109882354736
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00042295455932617
(319) DESCRIBE `ports` 0.0021481513977051
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00052309036254883
(321) DESCRIBE `ports` 0.0023369789123535
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00056195259094238
(323) DESCRIBE `ports` 0.0030889511108398
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00071501731872559
(325) DESCRIBE `ports` 0.0024409294128418
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00057506561279297
(327) DESCRIBE `ports` 0.0019259452819824
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00042510032653809
(329) DESCRIBE `ports` 0.0021729469299316
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00040507316589355
(331) DESCRIBE `ports` 0.0023171901702881
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.0004878044128418
(333) DESCRIBE `ports` 0.002249002456665
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00042295455932617
(335) DESCRIBE `ports` 0.0019078254699707
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.0004279613494873
(337) DESCRIBE `ports` 0.0018348693847656
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00040197372436523
(339) DESCRIBE `ports` 0.00177001953125
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00044894218444824
(341) DESCRIBE `ports` 0.0027570724487305
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00055408477783203
(343) DESCRIBE `ports` 0.00217604637146
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00065803527832031
(345) DESCRIBE `ports` 0.0022430419921875
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00044012069702148
(347) DESCRIBE `ports` 0.0021982192993164
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00044083595275879
(349) DESCRIBE `ports` 0.0023338794708252
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00038695335388184
(351) DESCRIBE `ports` 0.0020139217376709
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00043582916259766
(353) DESCRIBE `ports` 0.0025398731231689
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00057101249694824
(355) DESCRIBE `avid_specials` 0.0025601387023926
(356) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72900 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013389587402344
(357) DESCRIBE `cruiselines` 0.0027561187744141
(358) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00048303604125977
(359) DESCRIBE `orchid_image` 0.0020840167999268
(360) DESCRIBE `cruiselines` 0.0027191638946533
(361) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00047421455383301
(362) DESCRIBE `cruises` 0.0036649703979492
(363) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72933') 0.0004119873046875
(364) DESCRIBE `ships` 0.0039858818054199
(365) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.0005040168762207
(366) DESCRIBE `ships` 0.004561185836792
(367) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00042009353637695
(368) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038814544677734
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039100646972656
(370) DESCRIBE `itineraries` 0.0035088062286377
(371) DESCRIBE `ports` 0.0034627914428711
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00064492225646973
(373) DESCRIBE `ports` 0.0032908916473389
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00072908401489258
(375) DESCRIBE `ports` 0.0028810501098633
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00056290626525879
(377) DESCRIBE `sailingdates` 0.0019299983978271
(378) DESCRIBE `ports` 0.0019381046295166
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00052618980407715
(380) DESCRIBE `ports` 0.0020639896392822
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00065398216247559
(382) DESCRIBE `ports` 0.0030019283294678
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00063991546630859
(384) DESCRIBE `ports` 0.0028400421142578
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00046491622924805
(386) DESCRIBE `ports` 0.0022420883178711
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0004429817199707
(388) DESCRIBE `ports` 0.002126932144165
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00045895576477051
(390) DESCRIBE `ports` 0.0021750926971436
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00051498413085938
(392) DESCRIBE `ports` 0.003119945526123
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00063991546630859
(394) DESCRIBE `ports` 0.0033509731292725
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.0005180835723877
(396) DESCRIBE `ports` 0.0030300617218018
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.00057697296142578
(398) DESCRIBE `ports` 0.003262996673584
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00059890747070312
(400) DESCRIBE `ports` 0.0031859874725342
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00059199333190918
(402) DESCRIBE `ports` 0.0026459693908691
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00054788589477539
(404) DESCRIBE `ports` 0.0033318996429443
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0006248950958252
(406) DESCRIBE `ports` 0.0025730133056641
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00065398216247559
(408) DESCRIBE `ports` 0.0026099681854248
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00060486793518066
(410) DESCRIBE `ports` 0.0020480155944824
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00061702728271484
(412) DESCRIBE `ports` 0.0024919509887695
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00059914588928223
(414) DESCRIBE `ports` 0.0024950504302979
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.0006098747253418
(416) DESCRIBE `ports` 0.0024399757385254
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00045585632324219
(418) DESCRIBE `ports` 0.0021359920501709
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00060200691223145
(420) DESCRIBE `ports` 0.0019290447235107
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00051188468933105
(422) DESCRIBE `ports` 0.0021598339080811
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.0006721019744873
(424) DESCRIBE `ports` 0.0029129981994629
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00058293342590332
(426) DESCRIBE `ports` 0.0029408931732178
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.000579833984375
(428) DESCRIBE `ports` 0.0022549629211426
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00063800811767578
(430) DESCRIBE `ports` 0.0025308132171631
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00065493583679199
(432) DESCRIBE `ports` 0.0026040077209473
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00042605400085449
(434) DESCRIBE `ports` 0.0020971298217773
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00046110153198242
(436) DESCRIBE `ports` 0.0020132064819336
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00050210952758789
(438) DESCRIBE `ports` 0.0020570755004883
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2108))) 0.00044393539428711
(440) DESCRIBE `ports` 0.0020661354064941
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2108') 0.00051593780517578
(442) DESCRIBE `ports` 0.0027928352355957
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.00054597854614258
(444) DESCRIBE `ports` 0.0029010772705078
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') 0.00042200088500977
(446) DESCRIBE `ports` 0.0023889541625977
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1936))) 0.00049304962158203
(448) DESCRIBE `ports` 0.0022530555725098
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1936') 0.00039505958557129
(450) DESCRIBE `ports` 0.0018949508666992
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00054097175598145
(452) DESCRIBE `ports` 0.0019841194152832
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') 0.00039911270141602
(454) DESCRIBE `ports` 0.002910852432251
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00079584121704102
(456) DESCRIBE `ports` 0.0034530162811279
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00053906440734863
(458) DESCRIBE `ports` 0.0042250156402588
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00051498413085938
(460) DESCRIBE `ports` 0.0022652149200439
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00040888786315918
(462) DESCRIBE `ports` 0.0022249221801758
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00055885314941406
(464) DESCRIBE `ports` 0.0027189254760742
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00062417984008789
(466) DESCRIBE `ports` 0.011076927185059
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00081992149353027
(468) DESCRIBE `ports` 0.0028529167175293
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00193190574646
(470) DESCRIBE `ports` 0.0024361610412598
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00051712989807129
(472) DESCRIBE `ports` 0.0042080879211426
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00044703483581543
(474) DESCRIBE `ports` 0.0045020580291748
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0089399814605713
(476) DESCRIBE `ports` 0.002094030380249
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00047588348388672
(478) DESCRIBE `avid_specials` 0.0041611194610596
(479) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72933 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 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.008418083190918
(480) DESCRIBE `cruiselines` 0.0043730735778809
(481) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0061049461364746
(482) DESCRIBE `orchid_image` 0.0031180381774902
(483) DESCRIBE `cruiselines` 0.0048298835754395
(484) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0069429874420166
(485) DESCRIBE `cruises` 0.0038290023803711
(486) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72859') 0.0092520713806152
(487) DESCRIBE `ships` 0.00531005859375
(488) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.0070340633392334
(489) DESCRIBE `ships` 0.01203989982605
(490) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00062894821166992
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047802925109863
(492) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047087669372559
(493) DESCRIBE `itineraries` 0.0025968551635742
(494) DESCRIBE `ports` 0.0084729194641113
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0019288063049316
(496) DESCRIBE `ports` 0.0073800086975098
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00078797340393066
(498) DESCRIBE `ports` 0.0093619823455811
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00061488151550293
(500) DESCRIBE `sailingdates` 0.0046031475067139
(501) DESCRIBE `ports` 0.0025699138641357
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0092160701751709
(503) DESCRIBE `ports` 0.0020740032196045
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00045299530029297
(505) DESCRIBE `ports` 0.0018818378448486
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.0095782279968262
(507) DESCRIBE `ports` 0.0062668323516846
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00058698654174805
(509) DESCRIBE `ports` 0.0083928108215332
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00073599815368652
(511) DESCRIBE `ports` 0.0029339790344238
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.007418155670166
(513) DESCRIBE `ports` 0.0029010772705078
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0064599514007568
(515) DESCRIBE `ports` 0.0045139789581299
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0079548358917236
(517) DESCRIBE `ports` 0.0030500888824463
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.00077700614929199
(519) DESCRIBE `ports` 0.0029420852661133
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.0090539455413818
(521) DESCRIBE `ports` 0.0029971599578857
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00066590309143066
(523) DESCRIBE `ports` 0.002964973449707
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.018007040023804
(525) DESCRIBE `ports` 0.0034379959106445
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0042059421539307
(527) DESCRIBE `ports` 0.0072669982910156
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0085549354553223
(529) DESCRIBE `ports` 0.0037989616394043
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00083088874816895
(531) DESCRIBE `ports` 0.0032021999359131
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0078291893005371
(533) DESCRIBE `ports` 0.0030829906463623
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.0062530040740967
(535) DESCRIBE `ports` 0.011174917221069
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00063085556030273
(537) DESCRIBE `ports` 0.0026700496673584
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00066399574279785
(539) DESCRIBE `ports` 0.0051319599151611
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.0074560642242432
(541) DESCRIBE `ports` 0.002777099609375
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00072002410888672
(543) DESCRIBE `ports` 0.0066850185394287
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00060296058654785
(545) DESCRIBE `ports` 0.0053889751434326
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00092506408691406
(547) DESCRIBE `ports` 0.0055341720581055
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.0005190372467041
(549) DESCRIBE `ports` 0.0021648406982422
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.0024430751800537
(551) DESCRIBE `ports` 0.0021929740905762
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00047397613525391
(553) DESCRIBE `avid_specials` 0.0022759437561035
(554) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72859 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 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.0013089179992676
(555) DESCRIBE `cruiselines` 0.0027790069580078
(556) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0088050365447998
(557) DESCRIBE `orchid_image` 0.0022819042205811
(558) DESCRIBE `cruiselines` 0.003230094909668
(559) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00039100646972656
(560) DESCRIBE `cruises` 0.0036041736602783
(561) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66202') 0.0050520896911621
(562) DESCRIBE `ships` 0.012092113494873
(563) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00064897537231445
(564) DESCRIBE `ships` 0.0049281120300293
(565) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00041985511779785
(566) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036787986755371
(567) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035595893859863
(568) DESCRIBE `itineraries` 0.001945972442627
(569) DESCRIBE `ports` 0.010691165924072
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00063586235046387
(571) DESCRIBE `ports` 0.0026190280914307
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00055408477783203
(573) DESCRIBE `ports` 0.0089821815490723
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00054407119750977
(575) DESCRIBE `sailingdates` 0.0029239654541016
(576) DESCRIBE `ports` 0.0024569034576416
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0088658332824707
(578) DESCRIBE `ports` 0.0019941329956055
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00048398971557617
(580) DESCRIBE `ports` 0.002051830291748
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00075411796569824
(582) DESCRIBE `ports` 0.002763032913208
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00055503845214844
(584) DESCRIBE `ports` 0.0085930824279785
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00049686431884766
(586) DESCRIBE `ports` 0.014317989349365
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.000518798828125
(588) DESCRIBE `ports` 0.0019481182098389
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.0014729499816895
(590) DESCRIBE `ports` 0.0084738731384277
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00046992301940918
(592) DESCRIBE `ports` 0.0020220279693604
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.008944034576416
(594) DESCRIBE `ports` 0.0032198429107666
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00073790550231934
(596) DESCRIBE `ports` 0.0026569366455078
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.0078279972076416
(598) DESCRIBE `ports` 0.0023040771484375
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00059318542480469
(600) DESCRIBE `ports` 0.002133846282959
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3558))) 0.0035161972045898
(602) DESCRIBE `ports` 0.0053398609161377
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3558') 0.0014870166778564
(604) DESCRIBE `ports` 0.0059809684753418
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.00075888633728027
(606) DESCRIBE `ports` 0.006443977355957
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.00053000450134277
(608) DESCRIBE `ports` 0.0026140213012695
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.013854026794434
(610) DESCRIBE `ports` 0.0093111991882324
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00050783157348633
(612) DESCRIBE `ports` 0.0023069381713867
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00051307678222656
(614) DESCRIBE `ports` 0.0020499229431152
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.0061650276184082
(616) DESCRIBE `avid_specials` 0.0027210712432861
(617) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66202 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 11 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.0022578239440918
(618) DESCRIBE `cruiselines` 0.0051460266113281
(619) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0092751979827881
(620) DESCRIBE `orchid_image` 0.010280847549438
(621) DESCRIBE `cruiselines` 0.0031468868255615
(622) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00062108039855957
(623) DESCRIBE `cruises` 0.01269793510437
(624) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72898') 0.00047516822814941
(625) DESCRIBE `ships` 0.0038189888000488
(626) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00062990188598633
(627) DESCRIBE `ships` 0.0044939517974854
(628) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.0038080215454102
(629) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.017158031463623
(630) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054597854614258
(631) DESCRIBE `itineraries` 0.0024821758270264
(632) DESCRIBE `ports` 0.0027589797973633
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0083520412445068
(634) DESCRIBE `ports` 0.0020949840545654
(635) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004119873046875
(636) DESCRIBE `ports` 0.002032995223999
(637) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0004270076751709
(638) DESCRIBE `sailingdates` 0.0016682147979736
(639) DESCRIBE `ports` 0.0076591968536377
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005190372467041
(641) DESCRIBE `ports` 0.001878023147583
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041794776916504
(643) DESCRIBE `ports` 0.0018799304962158
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0043549537658691
(645) DESCRIBE `ports` 0.0023760795593262
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040006637573242
(647) DESCRIBE `ports` 0.0021398067474365
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2511))) 0.0014090538024902
(649) DESCRIBE `ports` 0.003917932510376
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2511') 0.00044584274291992
(651) DESCRIBE `ports` 0.020941972732544
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00061702728271484
(653) DESCRIBE `ports` 0.0033760070800781
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00043392181396484
(655) DESCRIBE `ports` 0.0020370483398438
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3293))) 0.00044989585876465
(657) DESCRIBE `ports` 0.0019450187683105
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3293') 0.00042891502380371
(659) DESCRIBE `ports` 0.0021719932556152
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.0004730224609375
(661) DESCRIBE `ports` 0.0024449825286865
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.0004880428314209
(663) DESCRIBE `ports` 0.0031888484954834
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2062))) 0.00044989585876465
(665) DESCRIBE `ports` 0.0019609928131104
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2062') 0.00040388107299805
(667) DESCRIBE `ports` 0.0018730163574219
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00059890747070312
(669) DESCRIBE `ports` 0.0025579929351807
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00050902366638184
(671) DESCRIBE `ports` 0.0044870376586914
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00062012672424316
(673) DESCRIBE `ports` 0.0023119449615479
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00051593780517578
(675) DESCRIBE `ports` 0.0021040439605713
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00050497055053711
(677) DESCRIBE `ports` 0.0020508766174316
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00047087669372559
(679) DESCRIBE `ports` 0.0028848648071289
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00066709518432617
(681) DESCRIBE `ports` 0.0026230812072754
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0005190372467041
(683) DESCRIBE `avid_specials` 0.0023870468139648
(684) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72898 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 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.00124192237854
(685) DESCRIBE `cruiselines` 0.0026149749755859
(686) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00040888786315918
(687) DESCRIBE `orchid_image` 0.002824068069458
(688) DESCRIBE `cruiselines` 0.0027730464935303
(689) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00052404403686523
(690) DESCRIBE `ships` 0.0040860176086426
(691) SELECT `ships`.* FROM `ships` WHERE (id IN ('850', '1319', '1108', '966', '394', '508')) ORDER BY FIND_IN_SET(id, '850,1319,1108,966,394,508') 0.001594066619873
(692) DESCRIBE `cruisetypes` 0.001884937286377
(693) DESCRIBE `destinations` 0.002669095993042
(694) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '37', '43', '35', '38', '2', '26', '28', '48', '11', '21', '45', '8', '30', '49', '10', '52', '25', '34', '32', '55')) ORDER BY FIND_IN_SET(id, '22,12,40,37,43,35,38,2,26,28,48,11,21,45,8,30,49,10,52,25,34,32,55') 0.0025041103363037
(695) DESCRIBE `cruiselines` 0.00307297706604
(696) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00056815147399902
(697) DESCRIBE `cruiselines` 0.0031819343566895
(698) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0006718635559082