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

Total elapsed time: 1.3255228996277

# Query Time
(1) connect 0.0014851093292236
(2) DESCRIBE `cruises` 0.0063598155975342
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (36197, 80797, 78314, 77649, 78188, 78187, 78295, 78315, 73726, 78190)) ORDER BY FIND_IN_SET(id, '36197,80797,78314,77649,78188,78187,78295,78315,73726,78190') 0.0027520656585693
(4) DESCRIBE `cruises` 0.0055727958679199
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '36197') 0.00066018104553223
(6) DESCRIBE `ships` 0.0054640769958496
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 162))) 0.00091981887817383
(8) DESCRIBE `ships` 0.0055098533630371
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '162') 0.0010459423065186
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004730224609375
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044894218444824
(12) DESCRIBE `itineraries` 0.0025410652160645
(13) DESCRIBE `ports` 0.0027048587799072
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00067019462585449
(15) DESCRIBE `ports` 0.0024800300598145
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00059604644775391
(17) DESCRIBE `ports` 0.0026540756225586
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00064802169799805
(19) DESCRIBE `sailingdates` 0.0025978088378906
(20) DESCRIBE `ports` 0.0032789707183838
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00082206726074219
(22) DESCRIBE `ports` 0.0027079582214355
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00060701370239258
(24) DESCRIBE `ports` 0.0025379657745361
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00055813789367676
(26) DESCRIBE `ports` 0.0023980140686035
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00055098533630371
(28) DESCRIBE `ports` 0.0026249885559082
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5008))) 0.00074076652526855
(30) DESCRIBE `ports` 0.0027320384979248
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5008') 0.00055980682373047
(32) DESCRIBE `ports` 0.0027599334716797
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00062990188598633
(34) DESCRIBE `ports` 0.0027520656585693
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00062203407287598
(36) DESCRIBE `ports` 0.0030591487884521
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00064396858215332
(38) DESCRIBE `ports` 0.0030009746551514
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00063109397888184
(40) DESCRIBE `ports` 0.003058910369873
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00063800811767578
(42) DESCRIBE `ports` 0.0027730464935303
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0006871223449707
(44) DESCRIBE `ports` 0.0030291080474854
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00093293190002441
(46) DESCRIBE `ports` 0.0032801628112793
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00060606002807617
(48) DESCRIBE `ports` 0.0025660991668701
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.0005500316619873
(50) DESCRIBE `ports` 0.0025999546051025
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00059890747070312
(52) DESCRIBE `ports` 0.0025308132171631
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 859))) 0.0005640983581543
(54) DESCRIBE `ports` 0.0025360584259033
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '859') 0.00053906440734863
(56) DESCRIBE `ports` 0.0028059482574463
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00060391426086426
(58) DESCRIBE `ports` 0.003180980682373
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00060105323791504
(60) DESCRIBE `ports` 0.0027318000793457
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00067710876464844
(62) DESCRIBE `ports` 0.002763032913208
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00082778930664062
(64) DESCRIBE `ports` 0.0033080577850342
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00074100494384766
(66) DESCRIBE `ports` 0.0031149387359619
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0007319450378418
(68) DESCRIBE `ports` 0.0031728744506836
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00074887275695801
(70) DESCRIBE `ports` 0.0027430057525635
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00060915946960449
(72) DESCRIBE `ports` 0.0025880336761475
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 241))) 0.00058317184448242
(74) DESCRIBE `ports` 0.0026719570159912
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '241') 0.00059103965759277
(76) DESCRIBE `ports` 0.0023322105407715
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00063490867614746
(78) DESCRIBE `ports` 0.0025229454040527
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0006260871887207
(80) DESCRIBE `avid_specials` 0.0028688907623291
(81) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 36197 and class = 'Cruise') OR (item_id = 162 AND class = 'Ship') OR (item_id = 33 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.0017709732055664
(82) DESCRIBE `cruiselines` 0.0038731098175049
(83) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00082206726074219
(84) DESCRIBE `orchid_image` 0.0035560131072998
(85) DESCRIBE `cruiselines` 0.0045568943023682
(86) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00068306922912598
(87) DESCRIBE `cruises` 0.0052249431610107
(88) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80797') 0.00062704086303711
(89) DESCRIBE `ships` 0.0068471431732178
(90) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00080299377441406
(91) DESCRIBE `ships` 0.0056109428405762
(92) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.00066184997558594
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054192543029785
(94) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048279762268066
(95) DESCRIBE `itineraries` 0.0025720596313477
(96) DESCRIBE `ports` 0.0026998519897461
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00061321258544922
(98) DESCRIBE `ports` 0.0024759769439697
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00063991546630859
(100) DESCRIBE `ports` 0.0026280879974365
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00066113471984863
(102) DESCRIBE `sailingdates` 0.0026249885559082
(103) DESCRIBE `ports` 0.0035281181335449
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00062704086303711
(105) DESCRIBE `ports` 0.003338098526001
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00075197219848633
(107) DESCRIBE `ports` 0.0028049945831299
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00066709518432617
(109) DESCRIBE `ports` 0.0026500225067139
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00052905082702637
(111) DESCRIBE `ports` 0.0032730102539062
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.0007328987121582
(113) DESCRIBE `ports` 0.0026669502258301
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00059819221496582
(115) DESCRIBE `ports` 0.002608060836792
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00045013427734375
(117) DESCRIBE `ports` 0.0023319721221924
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00053215026855469
(119) DESCRIBE `ports` 0.0024170875549316
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00058412551879883
(121) DESCRIBE `ports` 0.0022120475769043
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00041079521179199
(123) DESCRIBE `ports` 0.002396821975708
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00051593780517578
(125) DESCRIBE `ports` 0.0019271373748779
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00040483474731445
(127) DESCRIBE `ports` 0.0026769638061523
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00094199180603027
(129) DESCRIBE `ports` 0.0031788349151611
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00080704689025879
(131) DESCRIBE `ports` 0.0029220581054688
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1841))) 0.0015630722045898
(133) DESCRIBE `ports` 0.0041890144348145
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1841') 0.00068402290344238
(135) DESCRIBE `ports` 0.0039448738098145
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00071597099304199
(137) DESCRIBE `ports` 0.0023860931396484
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00062394142150879
(139) DESCRIBE `ports` 0.0022199153900146
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.0006709098815918
(141) DESCRIBE `ports` 0.0022919178009033
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.0004880428314209
(143) DESCRIBE `ports` 0.0020110607147217
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00063896179199219
(145) DESCRIBE `ports` 0.0028769969940186
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00069904327392578
(147) DESCRIBE `ports` 0.0030999183654785
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00068306922912598
(149) DESCRIBE `ports` 0.0030941963195801
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00067591667175293
(151) DESCRIBE `ports` 0.0029850006103516
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00084495544433594
(153) DESCRIBE `ports` 0.003183126449585
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00067877769470215
(155) DESCRIBE `ports` 0.0031058788299561
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00066399574279785
(157) DESCRIBE `ports` 0.002938985824585
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00071001052856445
(159) DESCRIBE `ports` 0.0029361248016357
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 632))) 0.00081610679626465
(161) DESCRIBE `ports` 0.0030109882354736
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '632') 0.00064897537231445
(163) DESCRIBE `ports` 0.0029580593109131
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00060200691223145
(165) DESCRIBE `ports` 0.0028300285339355
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00071597099304199
(167) DESCRIBE `avid_specials` 0.0024731159210205
(168) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80797 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 25 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0023789405822754
(169) DESCRIBE `cruiselines` 0.004256010055542
(170) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0008699893951416
(171) DESCRIBE `orchid_image` 0.0033259391784668
(172) DESCRIBE `cruiselines` 0.0041561126708984
(173) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.0006711483001709
(174) DESCRIBE `cruises` 0.0055429935455322
(175) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78314') 0.00061392784118652
(176) DESCRIBE `ships` 0.0054330825805664
(177) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00073099136352539
(178) DESCRIBE `ships` 0.0053648948669434
(179) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.00058388710021973
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036501884460449
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039887428283691
(182) DESCRIBE `itineraries` 0.0026168823242188
(183) DESCRIBE `ports` 0.0022599697113037
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0006260871887207
(185) DESCRIBE `ports` 0.0024831295013428
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00058412551879883
(187) DESCRIBE `ports` 0.0024559497833252
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00057411193847656
(189) DESCRIBE `sailingdates` 0.002331018447876
(190) DESCRIBE `ports` 0.0026381015777588
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00061893463134766
(192) DESCRIBE `ports` 0.0024118423461914
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00066304206848145
(194) DESCRIBE `ports` 0.0023880004882812
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00060486793518066
(196) DESCRIBE `ports` 0.0024571418762207
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00053095817565918
(198) DESCRIBE `ports` 0.0024130344390869
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00056219100952148
(200) DESCRIBE `ports` 0.0024099349975586
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00041294097900391
(202) DESCRIBE `ports` 0.0023210048675537
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00076889991760254
(204) DESCRIBE `ports` 0.0023841857910156
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00058197975158691
(206) DESCRIBE `ports` 0.002392053604126
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00049686431884766
(208) DESCRIBE `ports` 0.002126932144165
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00052809715270996
(210) DESCRIBE `ports` 0.0019268989562988
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00065803527832031
(212) DESCRIBE `ports` 0.0026710033416748
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00051617622375488
(214) DESCRIBE `ports` 0.0025820732116699
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00055193901062012
(216) DESCRIBE `ports` 0.0023641586303711
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00060486793518066
(218) DESCRIBE `avid_specials` 0.002241849899292
(219) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78314 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 25 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012381076812744
(220) DESCRIBE `cruiselines` 0.0027918815612793
(221) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00044798851013184
(222) DESCRIBE `orchid_image` 0.0022830963134766
(223) DESCRIBE `cruiselines` 0.0033178329467773
(224) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00072407722473145
(225) DESCRIBE `cruises` 0.0057291984558105
(226) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77649') 0.00068092346191406
(227) DESCRIBE `ships` 0.006382942199707
(228) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1282))) 0.00089812278747559
(229) DESCRIBE `ships` 0.0057449340820312
(230) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1282') 0.001093864440918
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00054407119750977
(232) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00050711631774902
(233) DESCRIBE `itineraries` 0.0028131008148193
(234) DESCRIBE `ports` 0.0028820037841797
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00081205368041992
(236) DESCRIBE `ports` 0.0028879642486572
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00066900253295898
(238) DESCRIBE `ports` 0.0023431777954102
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00058388710021973
(240) DESCRIBE `sailingdates` 0.003046989440918
(241) DESCRIBE `ports` 0.0029909610748291
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.000579833984375
(243) DESCRIBE `ports` 0.0029690265655518
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.0008549690246582
(245) DESCRIBE `ports` 0.0024240016937256
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.00058507919311523
(247) DESCRIBE `ports` 0.0023338794708252
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.00059795379638672
(249) DESCRIBE `ports` 0.0023839473724365
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00053596496582031
(251) DESCRIBE `ports` 0.0026400089263916
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00051307678222656
(253) DESCRIBE `ports` 0.002161979675293
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00049090385437012
(255) DESCRIBE `ports` 0.0025639533996582
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00043797492980957
(257) DESCRIBE `ports` 0.0026018619537354
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.0007479190826416
(259) DESCRIBE `ports` 0.002514123916626
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00092601776123047
(261) DESCRIBE `ports` 0.0029280185699463
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00049686431884766
(263) DESCRIBE `ports` 0.0030450820922852
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00063490867614746
(265) DESCRIBE `ports` 0.0027270317077637
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2684))) 0.00043892860412598
(267) DESCRIBE `ports` 0.002068042755127
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2684') 0.00045490264892578
(269) DESCRIBE `ports` 0.0023949146270752
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00057315826416016
(271) DESCRIBE `ports` 0.0021350383758545
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00051784515380859
(273) DESCRIBE `avid_specials` 0.0024299621582031
(274) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77649 and class = 'Cruise') OR (item_id = 1282 AND class = 'Ship') OR (item_id = 33 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.0024781227111816
(275) DESCRIBE `cruiselines` 0.0045061111450195
(276) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00082993507385254
(277) DESCRIBE `orchid_image` 0.0041308403015137
(278) DESCRIBE `cruiselines` 0.0040299892425537
(279) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00066399574279785
(280) DESCRIBE `cruises` 0.0043919086456299
(281) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78188') 0.00055599212646484
(282) DESCRIBE `ships` 0.0047581195831299
(283) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00076413154602051
(284) DESCRIBE `ships` 0.0055141448974609
(285) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00071883201599121
(286) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051307678222656
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049495697021484
(288) DESCRIBE `itineraries` 0.0028588771820068
(289) DESCRIBE `ports` 0.0030410289764404
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00065708160400391
(291) DESCRIBE `ports` 0.0025539398193359
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00069403648376465
(293) DESCRIBE `ports` 0.0028140544891357
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00053501129150391
(295) DESCRIBE `sailingdates` 0.001784086227417
(296) DESCRIBE `ports` 0.0026581287384033
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00059819221496582
(298) DESCRIBE `ports` 0.0023679733276367
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00060606002807617
(300) DESCRIBE `ports` 0.0034980773925781
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00069689750671387
(302) DESCRIBE `ports` 0.0027852058410645
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00061607360839844
(304) DESCRIBE `ports` 0.0027639865875244
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00078296661376953
(306) DESCRIBE `ports` 0.0028560161590576
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0006251335144043
(308) DESCRIBE `ports` 0.002687931060791
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00066113471984863
(310) DESCRIBE `ports` 0.0025689601898193
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00094985961914062
(312) DESCRIBE `ports` 0.0030930042266846
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3747))) 0.0006558895111084
(314) DESCRIBE `ports` 0.0026440620422363
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3747') 0.00060009956359863
(316) DESCRIBE `ports` 0.0025100708007812
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.0006868839263916
(318) DESCRIBE `ports` 0.0029048919677734
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00067901611328125
(320) DESCRIBE `ports` 0.0028719902038574
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00054502487182617
(322) DESCRIBE `ports` 0.0026059150695801
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00058484077453613
(324) DESCRIBE `ports` 0.0024240016937256
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00053691864013672
(326) DESCRIBE `ports` 0.0025019645690918
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00046586990356445
(328) DESCRIBE `ports` 0.0023601055145264
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 727))) 0.00055098533630371
(330) DESCRIBE `ports` 0.002720832824707
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '727') 0.0005338191986084
(332) DESCRIBE `ports` 0.0023250579833984
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00074982643127441
(334) DESCRIBE `ports` 0.0025091171264648
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00059390068054199
(336) DESCRIBE `ports` 0.0028262138366699
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00064921379089355
(338) DESCRIBE `ports` 0.0028119087219238
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00057291984558105
(340) DESCRIBE `ports` 0.0030269622802734
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00063204765319824
(342) DESCRIBE `ports` 0.0028882026672363
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00061416625976562
(344) DESCRIBE `ports` 0.0021030902862549
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00059008598327637
(346) DESCRIBE `ports` 0.0027668476104736
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00058698654174805
(348) DESCRIBE `ports` 0.00276780128479
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00069189071655273
(350) DESCRIBE `ports` 0.0028297901153564
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00061297416687012
(352) DESCRIBE `ports` 0.002763032913208
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3093))) 0.00061798095703125
(354) DESCRIBE `ports` 0.0031042098999023
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3093') 0.00059413909912109
(356) DESCRIBE `ports` 0.0031089782714844
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00071501731872559
(358) DESCRIBE `ports` 0.0029418468475342
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00048708915710449
(360) DESCRIBE `ports` 0.0019309520721436
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3266))) 0.00051093101501465
(362) DESCRIBE `ports` 0.0023989677429199
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3266') 0.00054097175598145
(364) DESCRIBE `ports` 0.0020811557769775
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00046610832214355
(366) DESCRIBE `ports` 0.0024349689483643
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00049686431884766
(368) DESCRIBE `ports` 0.002396821975708
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00059604644775391
(370) DESCRIBE `ports` 0.0023159980773926
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00053596496582031
(372) DESCRIBE `avid_specials` 0.0020139217376709
(373) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78188 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.0020160675048828
(374) DESCRIBE `cruiselines` 0.0033199787139893
(375) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00060701370239258
(376) DESCRIBE `orchid_image` 0.0033738613128662
(377) DESCRIBE `cruiselines` 0.0036251544952393
(378) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00057196617126465
(379) DESCRIBE `cruises` 0.0052268505096436
(380) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78187') 0.0005648136138916
(381) DESCRIBE `ships` 0.0048279762268066
(382) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00066804885864258
(383) DESCRIBE `ships` 0.0049009323120117
(384) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00060296058654785
(385) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043296813964844
(386) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047087669372559
(387) DESCRIBE `itineraries` 0.0024340152740479
(388) DESCRIBE `ports` 0.0022668838500977
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0006108283996582
(390) DESCRIBE `ports` 0.0024271011352539
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00057697296142578
(392) DESCRIBE `ports` 0.0025341510772705
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0005948543548584
(394) DESCRIBE `sailingdates` 0.0021870136260986
(395) DESCRIBE `ports` 0.0030720233917236
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0011310577392578
(397) DESCRIBE `ports` 0.0030069351196289
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00066399574279785
(399) DESCRIBE `ports` 0.0028889179229736
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00066089630126953
(401) DESCRIBE `ports` 0.0027070045471191
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00061988830566406
(403) DESCRIBE `ports` 0.0026230812072754
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0007178783416748
(405) DESCRIBE `ports` 0.00223708152771
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00055503845214844
(407) DESCRIBE `ports` 0.0024099349975586
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00056886672973633
(409) DESCRIBE `ports` 0.0021350383758545
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00054097175598145
(411) DESCRIBE `ports` 0.0021800994873047
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3747))) 0.00044894218444824
(413) DESCRIBE `ports` 0.0018491744995117
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3747') 0.00043487548828125
(415) DESCRIBE `ports` 0.0020949840545654
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00041699409484863
(417) DESCRIBE `ports` 0.0022990703582764
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00058507919311523
(419) DESCRIBE `ports` 0.0021870136260986
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00064420700073242
(421) DESCRIBE `ports` 0.0031309127807617
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00063514709472656
(423) DESCRIBE `ports` 0.0027790069580078
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00063300132751465
(425) DESCRIBE `ports` 0.0022580623626709
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.0005500316619873
(427) DESCRIBE `ports` 0.0018260478973389
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 727))) 0.00061702728271484
(429) DESCRIBE `ports` 0.002918004989624
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '727') 0.00061511993408203
(431) DESCRIBE `ports` 0.002471923828125
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00052905082702637
(433) DESCRIBE `ports` 0.0026619434356689
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00058484077453613
(435) DESCRIBE `ports` 0.0026021003723145
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00067901611328125
(437) DESCRIBE `ports` 0.0026810169219971
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00067996978759766
(439) DESCRIBE `ports` 0.0028018951416016
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00061607360839844
(441) DESCRIBE `ports` 0.002683162689209
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0006709098815918
(443) DESCRIBE `avid_specials` 0.0024168491363525
(444) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78187 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.002129077911377
(445) DESCRIBE `cruiselines` 0.0038881301879883
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00068020820617676
(447) DESCRIBE `orchid_image` 0.003119945526123
(448) DESCRIBE `cruiselines` 0.0039598941802979
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00072717666625977
(450) DESCRIBE `cruises` 0.0047531127929688
(451) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78295') 0.00064492225646973
(452) DESCRIBE `ships` 0.0049409866333008
(453) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.0010378360748291
(454) DESCRIBE `ships` 0.0053207874298096
(455) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.00080299377441406
(456) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048613548278809
(457) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047111511230469
(458) DESCRIBE `itineraries` 0.0026118755340576
(459) DESCRIBE `ports` 0.0027339458465576
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00072598457336426
(461) DESCRIBE `ports` 0.0032999515533447
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.001230001449585
(463) DESCRIBE `ports` 0.0030398368835449
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00067901611328125
(465) DESCRIBE `sailingdates` 0.0021610260009766
(466) DESCRIBE `ports` 0.0027308464050293
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00071811676025391
(468) DESCRIBE `ports` 0.0032188892364502
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00054788589477539
(470) DESCRIBE `ports` 0.0023009777069092
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1905))) 0.00055813789367676
(472) DESCRIBE `ports` 0.0026171207427979
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1905') 0.00064992904663086
(474) DESCRIBE `ports` 0.0024449825286865
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0013980865478516
(476) DESCRIBE `ports` 0.0029950141906738
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.0006861686706543
(478) DESCRIBE `ports` 0.0033910274505615
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00080704689025879
(480) DESCRIBE `ports` 0.0030679702758789
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00090193748474121
(482) DESCRIBE `ports` 0.0031120777130127
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 30))) 0.00076198577880859
(484) DESCRIBE `ports` 0.0028550624847412
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '30') 0.00047802925109863
(486) DESCRIBE `ports` 0.0019490718841553
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00067710876464844
(488) DESCRIBE `ports` 0.0021059513092041
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00047183036804199
(490) DESCRIBE `ports` 0.0020251274108887
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 34))) 0.00043010711669922
(492) DESCRIBE `ports` 0.0021638870239258
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '34') 0.00039005279541016
(494) DESCRIBE `ports` 0.002018928527832
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 855))) 0.00078082084655762
(496) DESCRIBE `ports` 0.0029120445251465
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '855') 0.00065994262695312
(498) DESCRIBE `ports` 0.0030789375305176
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1262))) 0.0010709762573242
(500) DESCRIBE `ports` 0.0031750202178955
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1262') 0.0007479190826416
(502) DESCRIBE `ports` 0.0031518936157227
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00092601776123047
(504) DESCRIBE `ports` 0.0030679702758789
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00065898895263672
(506) DESCRIBE `ports` 0.0029962062835693
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0009300708770752
(508) DESCRIBE `ports` 0.0035240650177002
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00084495544433594
(510) DESCRIBE `avid_specials` 0.0027318000793457
(511) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78295 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 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.0021500587463379
(512) DESCRIBE `cruiselines` 0.0037829875946045
(513) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00072979927062988
(514) DESCRIBE `orchid_image` 0.0032470226287842
(515) DESCRIBE `cruiselines` 0.0039839744567871
(516) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00065398216247559
(517) DESCRIBE `cruises` 0.0063531398773193
(518) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78315') 0.00073790550231934
(519) DESCRIBE `ships` 0.0055549144744873
(520) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00085020065307617
(521) DESCRIBE `ships` 0.0054328441619873
(522) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.00066494941711426
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050592422485352
(524) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048398971557617
(525) DESCRIBE `itineraries` 0.0023441314697266
(526) DESCRIBE `ports` 0.0024828910827637
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00059700012207031
(528) DESCRIBE `ports` 0.0023880004882812
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00050902366638184
(530) DESCRIBE `ports` 0.0023190975189209
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00045490264892578
(532) DESCRIBE `sailingdates` 0.0020291805267334
(533) DESCRIBE `ports` 0.0029230117797852
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0007319450378418
(535) DESCRIBE `ports` 0.0027389526367188
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00075197219848633
(537) DESCRIBE `ports` 0.0026509761810303
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1841))) 0.00080108642578125
(539) DESCRIBE `ports` 0.0032541751861572
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1841') 0.00077414512634277
(541) DESCRIBE `ports` 0.0025579929351807
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00058388710021973
(543) DESCRIBE `ports` 0.0025441646575928
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00067901611328125
(545) DESCRIBE `ports` 0.0027642250061035
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00063896179199219
(547) DESCRIBE `ports` 0.0024759769439697
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00063300132751465
(549) DESCRIBE `ports` 0.0028998851776123
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00065398216247559
(551) DESCRIBE `ports` 0.0021820068359375
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00039911270141602
(553) DESCRIBE `ports` 0.0020899772644043
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00056815147399902
(555) DESCRIBE `ports` 0.0034449100494385
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00056695938110352
(557) DESCRIBE `ports` 0.0028398036956787
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00054502487182617
(559) DESCRIBE `ports` 0.0020248889923096
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00062990188598633
(561) DESCRIBE `ports` 0.0024290084838867
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00053501129150391
(563) DESCRIBE `ports` 0.0019450187683105
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00045084953308105
(565) DESCRIBE `ports` 0.0020821094512939
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 632))) 0.00046896934509277
(567) DESCRIBE `ports` 0.0018260478973389
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '632') 0.00044107437133789
(569) DESCRIBE `ports` 0.0018930435180664
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00041794776916504
(571) DESCRIBE `ports` 0.0020158290863037
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00053715705871582
(573) DESCRIBE `avid_specials` 0.0022239685058594
(574) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78315 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 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.0021688938140869
(575) DESCRIBE `cruiselines` 0.0039081573486328
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00068521499633789
(577) DESCRIBE `orchid_image` 0.0024650096893311
(578) DESCRIBE `cruiselines` 0.0028738975524902
(579) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00044012069702148
(580) DESCRIBE `cruises` 0.0062339305877686
(581) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73726') 0.00072407722473145
(582) DESCRIBE `ships` 0.0053980350494385
(583) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00086092948913574
(584) DESCRIBE `ships` 0.0057430267333984
(585) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00064992904663086
(586) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039505958557129
(587) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040602684020996
(588) DESCRIBE `itineraries` 0.002763032913208
(589) DESCRIBE `ports` 0.0029358863830566
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00067996978759766
(591) DESCRIBE `ports` 0.0028238296508789
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00069904327392578
(593) DESCRIBE `ports` 0.0026822090148926
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00073599815368652
(595) DESCRIBE `sailingdates` 0.0024659633636475
(596) DESCRIBE `ports` 0.003014087677002
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00072717666625977
(598) DESCRIBE `ports` 0.0021607875823975
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00047993659973145
(600) DESCRIBE `ports` 0.0021548271179199
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00062108039855957
(602) DESCRIBE `ports` 0.0031588077545166
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00065112113952637
(604) DESCRIBE `ports` 0.0028340816497803
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00063705444335938
(606) DESCRIBE `ports` 0.0027000904083252
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00059795379638672
(608) DESCRIBE `ports` 0.0026659965515137
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00066494941711426
(610) DESCRIBE `ports` 0.0025358200073242
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00064182281494141
(612) DESCRIBE `ports` 0.0024900436401367
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00053501129150391
(614) DESCRIBE `ports` 0.0020811557769775
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00047397613525391
(616) DESCRIBE `ports` 0.0021271705627441
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.0005488395690918
(618) DESCRIBE `ports` 0.0022408962249756
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00042414665222168
(620) DESCRIBE `ports` 0.0020861625671387
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.0004570484161377
(622) DESCRIBE `ports` 0.002392053604126
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.0005040168762207
(624) DESCRIBE `ports` 0.0025200843811035
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00066399574279785
(626) DESCRIBE `ports` 0.00235915184021
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00049614906311035
(628) DESCRIBE `ports` 0.0022070407867432
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00055313110351562
(630) DESCRIBE `ports` 0.002269983291626
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0005640983581543
(632) DESCRIBE `avid_specials` 0.0023229122161865
(633) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73726 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020210742950439
(634) DESCRIBE `cruiselines` 0.0036299228668213
(635) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00070500373840332
(636) DESCRIBE `orchid_image` 0.0029661655426025
(637) DESCRIBE `cruiselines` 0.0035989284515381
(638) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00046205520629883
(639) DESCRIBE `cruises` 0.0051751136779785
(640) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78190') 0.00066995620727539
(641) DESCRIBE `ships` 0.0056569576263428
(642) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00084400177001953
(643) DESCRIBE `ships` 0.0049309730529785
(644) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00046014785766602
(645) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049400329589844
(646) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034403800964355
(647) DESCRIBE `itineraries` 0.0025620460510254
(648) DESCRIBE `ports` 0.0029089450836182
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00060892105102539
(650) DESCRIBE `ports` 0.0022521018981934
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00046706199645996
(652) DESCRIBE `ports` 0.0021708011627197
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00054192543029785
(654) DESCRIBE `sailingdates` 0.0021648406982422
(655) DESCRIBE `ports` 0.0029129981994629
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00095105171203613
(657) DESCRIBE `ports` 0.0026378631591797
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00057888031005859
(659) DESCRIBE `ports` 0.002601146697998
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00058984756469727
(661) DESCRIBE `ports` 0.0026371479034424
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00056791305541992
(663) DESCRIBE `ports` 0.0025169849395752
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00060081481933594
(665) DESCRIBE `ports` 0.0029537677764893
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00059604644775391
(667) DESCRIBE `ports` 0.002377986907959
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3093))) 0.00061392784118652
(669) DESCRIBE `ports` 0.0026619434356689
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3093') 0.00052905082702637
(671) DESCRIBE `ports` 0.0024991035461426
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00062990188598633
(673) DESCRIBE `ports` 0.0025560855865479
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00057792663574219
(675) DESCRIBE `ports` 0.0025351047515869
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3266))) 0.00062394142150879
(677) DESCRIBE `ports` 0.0024750232696533
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3266') 0.00060009956359863
(679) DESCRIBE `ports` 0.0021669864654541
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00042510032653809
(681) DESCRIBE `ports` 0.0020349025726318
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00037789344787598
(683) DESCRIBE `ports` 0.0019159317016602
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00065302848815918
(685) DESCRIBE `ports` 0.0029609203338623
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0006258487701416
(687) DESCRIBE `ports` 0.0023469924926758
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2394))) 0.00047612190246582
(689) DESCRIBE `ports` 0.0026569366455078
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2394') 0.00061297416687012
(691) DESCRIBE `ports` 0.0026929378509521
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00049209594726562
(693) DESCRIBE `ports` 0.0023281574249268
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00045108795166016
(695) DESCRIBE `ports` 0.0023801326751709
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00048589706420898
(697) DESCRIBE `ports` 0.0021121501922607
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0004119873046875
(699) DESCRIBE `ports` 0.0023288726806641
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00051093101501465
(701) DESCRIBE `ports` 0.0021750926971436
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00049591064453125
(703) DESCRIBE `ports` 0.0022549629211426
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00063490867614746
(705) DESCRIBE `ports` 0.0023608207702637
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00055813789367676
(707) DESCRIBE `ports` 0.0024850368499756
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00076198577880859
(709) DESCRIBE `ports` 0.0028350353240967
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0005800724029541
(711) DESCRIBE `ports` 0.0027740001678467
(712) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00077104568481445
(713) DESCRIBE `ports` 0.0018990039825439
(714) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00066995620727539
(715) DESCRIBE `avid_specials` 0.0022649765014648
(716) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78190 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.0016839504241943
(717) DESCRIBE `cruiselines` 0.0025269985198975
(718) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00048208236694336
(719) DESCRIBE `orchid_image` 0.0020179748535156
(720) DESCRIBE `cruiselines` 0.0027220249176025
(721) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00042200088500977
(722) DESCRIBE `ships` 0.0044260025024414
(723) SELECT `ships`.* FROM `ships` WHERE (id IN ('163', '160', '1266', '162', '1159', '1282')) ORDER BY FIND_IN_SET(id, '163,160,1266,162,1159,1282') 0.0017008781433105
(724) DESCRIBE `cruisetypes` 0.0016729831695557
(725) DESCRIBE `destinations` 0.0023210048675537
(726) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '12', '48', '35', '38', '2', '49', '28', '21', '26', '8', '34', '11', '25', '53', '40')) ORDER BY FIND_IN_SET(id, '43,22,12,48,35,38,2,49,28,21,26,8,34,11,25,53,40') 0.0023047924041748
(727) DESCRIBE `cruiselines` 0.0030097961425781
(728) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00064396858215332
(729) DESCRIBE `cruiselines` 0.0031239986419678
(730) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00067496299743652