or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 582

Total elapsed time: 1.3528537750244

# Query Time
(1) connect 0.0016648769378662
(2) DESCRIBE `cruises` 0.0059008598327637
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71033, 72529, 74139, 74854, 74869, 75049, 75743, 75745, 76772, 77090)) ORDER BY FIND_IN_SET(id, '71033,72529,74139,74854,74869,75049,75743,75745,76772,77090') 0.0042860507965088
(4) DESCRIBE `cruises` 0.0052139759063721
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71033') 0.00069499015808105
(6) DESCRIBE `ships` 0.0050549507141113
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1540))) 0.00080490112304688
(8) DESCRIBE `ships` 0.0059828758239746
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1540') 0.00076699256896973
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050497055053711
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053000450134277
(12) DESCRIBE `itineraries` 0.003108024597168
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0017368793487549
(14) DESCRIBE `ports` 0.0034859180450439
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00079011917114258
(16) DESCRIBE `ports` 0.0029788017272949
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.0007469654083252
(18) DESCRIBE `ports` 0.0033960342407227
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00089502334594727
(20) DESCRIBE `sailingdates` 0.0024681091308594
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0025920867919922
(22) DESCRIBE `ports` 0.002622127532959
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00059700012207031
(24) DESCRIBE `ports` 0.0037469863891602
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00074100494384766
(26) DESCRIBE `ports` 0.0040318965911865
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00062203407287598
(28) DESCRIBE `ports` 0.0036001205444336
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00056219100952148
(30) DESCRIBE `ports` 0.0026309490203857
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4177))) 0.00061392784118652
(32) DESCRIBE `ports` 0.0034720897674561
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4177') 0.000762939453125
(34) DESCRIBE `ports` 0.00323486328125
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1863))) 0.00071811676025391
(36) DESCRIBE `ports` 0.0040161609649658
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1863') 0.0006871223449707
(38) DESCRIBE `ports` 0.0029060840606689
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00068807601928711
(40) DESCRIBE `ports` 0.0027780532836914
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00066804885864258
(42) DESCRIBE `ports` 0.00270676612854
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00067710876464844
(44) DESCRIBE `ports` 0.0025529861450195
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00056719779968262
(46) DESCRIBE `ports` 0.0025429725646973
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2122))) 0.00064992904663086
(48) DESCRIBE `ports` 0.002716064453125
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2122') 0.00068092346191406
(50) DESCRIBE `ports` 0.0027608871459961
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00066804885864258
(52) DESCRIBE `ports` 0.0026841163635254
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00062799453735352
(54) DESCRIBE `ports` 0.0031008720397949
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00061511993408203
(56) DESCRIBE `ports` 0.0024058818817139
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00050806999206543
(58) DESCRIBE `avid_specials` 0.0020711421966553
(59) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71033 and class = 'Cruise') OR (item_id = 1540 AND class = 'Ship') OR (item_id = 114 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.0021591186523438
(60) DESCRIBE `cruiselines` 0.0042119026184082
(61) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.0007331371307373
(62) DESCRIBE `orchid_image` 0.0036489963531494
(63) DESCRIBE `cruiselines` 0.0044100284576416
(64) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00070095062255859
(65) DESCRIBE `cruises` 0.0046331882476807
(66) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72529') 0.00074219703674316
(67) DESCRIBE `ships` 0.0054299831390381
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) 0.00092887878417969
(69) DESCRIBE `ships` 0.0051920413970947
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') 0.00070595741271973
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0005340576171875
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00046896934509277
(73) DESCRIBE `itineraries` 0.0029950141906738
(74) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72529') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0022900104522705
(75) DESCRIBE `ports` 0.0032801628112793
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00077986717224121
(77) DESCRIBE `ports` 0.0028889179229736
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00070595741271973
(79) DESCRIBE `ports` 0.0027570724487305
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00064802169799805
(81) DESCRIBE `sailingdates` 0.0023751258850098
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72529') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012741088867188
(83) DESCRIBE `ports` 0.0026509761810303
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0006561279296875
(85) DESCRIBE `ports` 0.0026919841766357
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00057506561279297
(87) DESCRIBE `ports` 0.0026559829711914
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00068116188049316
(89) DESCRIBE `ports` 0.0024800300598145
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00052905082702637
(91) DESCRIBE `ports` 0.0024518966674805
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00070309638977051
(93) DESCRIBE `ports` 0.0029668807983398
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00070905685424805
(95) DESCRIBE `ports` 0.0028948783874512
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00064992904663086
(97) DESCRIBE `ports` 0.0028178691864014
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00061488151550293
(99) DESCRIBE `ports` 0.0028421878814697
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00062990188598633
(101) DESCRIBE `ports` 0.0026190280914307
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00066018104553223
(103) DESCRIBE `ports` 0.003572940826416
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0007171630859375
(105) DESCRIBE `ports` 0.0029430389404297
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00062894821166992
(107) DESCRIBE `ports` 0.0025489330291748
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.0007779598236084
(109) DESCRIBE `ports` 0.0030679702758789
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00067400932312012
(111) DESCRIBE `ports` 0.0030519962310791
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00075101852416992
(113) DESCRIBE `ports` 0.0029199123382568
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00067305564880371
(115) DESCRIBE `avid_specials` 0.0026960372924805
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72529 and class = 'Cruise') OR (item_id = 1398 AND class = 'Ship') OR (item_id = 29 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.0024101734161377
(117) DESCRIBE `cruiselines` 0.0040149688720703
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.0006709098815918
(119) DESCRIBE `orchid_image` 0.0028071403503418
(120) DESCRIBE `cruises` 0.0056209564208984
(121) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74139') 0.00069499015808105
(122) DESCRIBE `ships` 0.0053138732910156
(123) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 265))) 0.0007939338684082
(124) DESCRIBE `ships` 0.0050539970397949
(125) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '265') 0.00069904327392578
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00072908401489258
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051403045654297
(128) DESCRIBE `itineraries` 0.0034902095794678
(129) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74139') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0026209354400635
(130) DESCRIBE `ports` 0.0029211044311523
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00069999694824219
(132) DESCRIBE `ports` 0.0028610229492188
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00069403648376465
(134) DESCRIBE `ports` 0.003230094909668
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00066208839416504
(136) DESCRIBE `sailingdates` 0.0026180744171143
(137) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74139') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0040919780731201
(138) DESCRIBE `ports` 0.0026350021362305
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00072693824768066
(140) DESCRIBE `ports` 0.0021500587463379
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00051021575927734
(142) DESCRIBE `ports` 0.0022201538085938
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00054192543029785
(144) DESCRIBE `ports` 0.0023469924926758
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00057697296142578
(146) DESCRIBE `ports` 0.0030288696289062
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 718))) 0.00078177452087402
(148) DESCRIBE `ports` 0.002716064453125
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '718') 0.00059795379638672
(150) DESCRIBE `ports` 0.0029058456420898
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00058507919311523
(152) DESCRIBE `ports` 0.0027098655700684
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00064492225646973
(154) DESCRIBE `ports` 0.0027520656585693
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00069284439086914
(156) DESCRIBE `ports` 0.0030598640441895
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00064992904663086
(158) DESCRIBE `ports` 0.0029311180114746
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00072479248046875
(160) DESCRIBE `ports` 0.003180980682373
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00076413154602051
(162) DESCRIBE `avid_specials` 0.0027589797973633
(163) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74139 and class = 'Cruise') OR (item_id = 265 AND class = 'Ship') OR (item_id = 50 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.002363920211792
(164) DESCRIBE `cruiselines` 0.0033409595489502
(165) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00070691108703613
(166) DESCRIBE `orchid_image` 0.0037569999694824
(167) DESCRIBE `cruiselines` 0.0039198398590088
(168) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00071096420288086
(169) DESCRIBE `cruises` 0.0053150653839111
(170) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74854') 0.00084495544433594
(171) DESCRIBE `ships` 0.0061888694763184
(172) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1325))) 0.00095486640930176
(173) DESCRIBE `ships` 0.005608081817627
(174) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1325') 0.0010230541229248
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00055694580078125
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0005190372467041
(177) DESCRIBE `itineraries` 0.0026562213897705
(178) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74854') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.002288818359375
(179) DESCRIBE `ports` 0.0025839805603027
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0010149478912354
(181) DESCRIBE `ports` 0.0030970573425293
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00071883201599121
(183) DESCRIBE `ports` 0.0025780200958252
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00056886672973633
(185) DESCRIBE `sailingdates` 0.0023880004882812
(186) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74854') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016500949859619
(187) DESCRIBE `ports` 0.0029678344726562
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0009160041809082
(189) DESCRIBE `ports` 0.0028259754180908
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00072789192199707
(191) DESCRIBE `ports` 0.0031850337982178
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.000762939453125
(193) DESCRIBE `ports` 0.0027978420257568
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00069785118103027
(195) DESCRIBE `ports` 0.0028738975524902
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00069808959960938
(197) DESCRIBE `ports` 0.0028679370880127
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00063896179199219
(199) DESCRIBE `ports` 0.0027179718017578
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3014))) 0.00070595741271973
(201) DESCRIBE `ports` 0.0029079914093018
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3014') 0.00063705444335938
(203) DESCRIBE `ports` 0.0028491020202637
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2846))) 0.00077199935913086
(205) DESCRIBE `ports` 0.0031321048736572
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2846') 0.00073003768920898
(207) DESCRIBE `ports` 0.0027859210968018
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00074481964111328
(209) DESCRIBE `ports` 0.0029869079589844
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.0006871223449707
(211) DESCRIBE `ports` 0.0028209686279297
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00070810317993164
(213) DESCRIBE `ports` 0.0027799606323242
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.0015389919281006
(215) DESCRIBE `ports` 0.0028190612792969
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00075292587280273
(217) DESCRIBE `ports` 0.0028131008148193
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0006101131439209
(219) DESCRIBE `avid_specials` 0.002284049987793
(220) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74854 and class = 'Cruise') OR (item_id = 1325 AND class = 'Ship') OR (item_id = 28 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.0021259784698486
(221) DESCRIBE `cruiselines` 0.0040690898895264
(222) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00072383880615234
(223) DESCRIBE `orchid_image` 0.0030961036682129
(224) DESCRIBE `cruises` 0.0055980682373047
(225) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74869') 0.00077986717224121
(226) DESCRIBE `ships` 0.0057950019836426
(227) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1368))) 0.00089693069458008
(228) DESCRIBE `ships` 0.0056030750274658
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1368') 0.0023069381713867
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00064992904663086
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00045609474182129
(232) DESCRIBE `itineraries` 0.0029230117797852
(233) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74869') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011379718780518
(234) DESCRIBE `ports` 0.0028970241546631
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00097298622131348
(236) DESCRIBE `ports` 0.0025100708007812
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00058603286743164
(238) DESCRIBE `ports` 0.0022721290588379
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00060606002807617
(240) DESCRIBE `sailingdates` 0.0027091503143311
(241) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74869') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010309219360352
(242) DESCRIBE `ports` 0.0032508373260498
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00067496299743652
(244) DESCRIBE `ports` 0.0032401084899902
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0008089542388916
(246) DESCRIBE `ports` 0.0030920505523682
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00060892105102539
(248) DESCRIBE `ports` 0.0029218196868896
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00060296058654785
(250) DESCRIBE `ports` 0.0029139518737793
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00070810317993164
(252) DESCRIBE `ports` 0.0030369758605957
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00079989433288574
(254) DESCRIBE `ports` 0.0069580078125
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00098800659179688
(256) DESCRIBE `ports` 0.0041348934173584
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00065994262695312
(258) DESCRIBE `ports` 0.0029299259185791
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.0005948543548584
(260) DESCRIBE `ports` 0.0027391910552979
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00065898895263672
(262) DESCRIBE `ports` 0.0028190612792969
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00068283081054688
(264) DESCRIBE `ports` 0.0039808750152588
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.0007622241973877
(266) DESCRIBE `ports` 0.0057480335235596
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00086617469787598
(268) DESCRIBE `ports` 0.0037188529968262
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.0009770393371582
(270) DESCRIBE `ports` 0.0038948059082031
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0030069351196289
(272) DESCRIBE `ports` 0.0028128623962402
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00068783760070801
(274) DESCRIBE `ports` 0.0029048919677734
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00066184997558594
(276) DESCRIBE `ports` 0.0027320384979248
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00067591667175293
(278) DESCRIBE `ports` 0.0049190521240234
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.0007941722869873
(280) DESCRIBE `ports` 0.0032899379730225
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.0006558895111084
(282) DESCRIBE `avid_specials` 0.0036749839782715
(283) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74869 and class = 'Cruise') OR (item_id = 1368 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0035281181335449
(284) DESCRIBE `cruiselines` 0.0044910907745361
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.0008389949798584
(286) DESCRIBE `orchid_image` 0.0045781135559082
(287) DESCRIBE `cruiselines` 0.0082461833953857
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00079202651977539
(289) DESCRIBE `cruises` 0.010046005249023
(290) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75049') 0.0035209655761719
(291) DESCRIBE `ships` 0.012680053710938
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1362))) 0.0034060478210449
(293) DESCRIBE `ships` 0.0053141117095947
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1362') 0.0011160373687744
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00070309638977051
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049781799316406
(297) DESCRIBE `itineraries` 0.0026421546936035
(298) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75049') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0031819343566895
(299) DESCRIBE `ports` 0.0028858184814453
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00066709518432617
(301) DESCRIBE `ports` 0.002647876739502
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00060391426086426
(303) DESCRIBE `ports` 0.0027248859405518
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00077009201049805
(305) DESCRIBE `sailingdates` 0.0026140213012695
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75049') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0015408992767334
(307) DESCRIBE `ports` 0.0032279491424561
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00068902969360352
(309) DESCRIBE `ports` 0.0030279159545898
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00068402290344238
(311) DESCRIBE `ports` 0.0027179718017578
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00070786476135254
(313) DESCRIBE `ports` 0.0027530193328857
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00068283081054688
(315) DESCRIBE `ports` 0.0027680397033691
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00064206123352051
(317) DESCRIBE `ports` 0.0034620761871338
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.0005638599395752
(319) DESCRIBE `ports` 0.002647876739502
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00068807601928711
(321) DESCRIBE `ports` 0.0030500888824463
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.001133918762207
(323) DESCRIBE `ports` 0.0036730766296387
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00081396102905273
(325) DESCRIBE `ports` 0.0054199695587158
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.0010700225830078
(327) DESCRIBE `ports` 0.0057110786437988
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00082612037658691
(329) DESCRIBE `ports` 0.0036020278930664
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.0028250217437744
(331) DESCRIBE `ports` 0.004796028137207
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00099396705627441
(333) DESCRIBE `ports` 0.007688045501709
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.0009458065032959
(335) DESCRIBE `ports` 0.003324031829834
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.0020301342010498
(337) DESCRIBE `ports` 0.0035049915313721
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00075793266296387
(339) DESCRIBE `ports` 0.0039370059967041
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00078105926513672
(341) DESCRIBE `ports` 0.0027358531951904
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0006558895111084
(343) DESCRIBE `avid_specials` 0.0030028820037842
(344) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75049 and class = 'Cruise') OR (item_id = 1362 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0023000240325928
(345) DESCRIBE `cruiselines` 0.0039689540863037
(346) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00075292587280273
(347) DESCRIBE `orchid_image` 0.0033919811248779
(348) DESCRIBE `cruiselines` 0.0042450428009033
(349) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0006561279296875
(350) DESCRIBE `cruises` 0.0064749717712402
(351) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75743') 0.00072884559631348
(352) DESCRIBE `ships` 0.0068259239196777
(353) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1237))) 0.0010578632354736
(354) DESCRIBE `ships` 0.0056068897247314
(355) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1237') 0.00090789794921875
(356) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00055599212646484
(357) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052809715270996
(358) DESCRIBE `itineraries` 0.0030717849731445
(359) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75743') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0045249462127686
(360) DESCRIBE `ports` 0.0030500888824463
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00083589553833008
(362) DESCRIBE `ports` 0.0033538341522217
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00075316429138184
(364) DESCRIBE `ports` 0.0027749538421631
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00069713592529297
(366) DESCRIBE `sailingdates` 0.0023279190063477
(367) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75743') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012569427490234
(368) DESCRIBE `ports` 0.0030620098114014
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00071811676025391
(370) DESCRIBE `ports` 0.0029571056365967
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00067710876464844
(372) DESCRIBE `ports` 0.0028641223907471
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00071382522583008
(374) DESCRIBE `ports` 0.0030879974365234
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00069785118103027
(376) DESCRIBE `ports` 0.0027210712432861
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00063610076904297
(378) DESCRIBE `ports` 0.0028719902038574
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00066518783569336
(380) DESCRIBE `ports` 0.0028882026672363
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00073909759521484
(382) DESCRIBE `ports` 0.0022139549255371
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00064516067504883
(384) DESCRIBE `ports` 0.0020999908447266
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00051617622375488
(386) DESCRIBE `ports` 0.0027568340301514
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00052094459533691
(388) DESCRIBE `ports` 0.0021340847015381
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00063991546630859
(390) DESCRIBE `ports` 0.0023348331451416
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.0005640983581543
(392) DESCRIBE `ports` 0.0034339427947998
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.0017509460449219
(394) DESCRIBE `ports` 0.0054960250854492
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.0010428428649902
(396) DESCRIBE `ports` 0.0039260387420654
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0010051727294922
(398) DESCRIBE `ports` 0.0061039924621582
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00069284439086914
(400) DESCRIBE `avid_specials` 0.0026900768280029
(401) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75743 and class = 'Cruise') OR (item_id = 1237 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0023841857910156
(402) DESCRIBE `cruiselines` 0.003680944442749
(403) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00064420700073242
(404) DESCRIBE `orchid_image` 0.0031130313873291
(405) DESCRIBE `cruiselines` 0.0037660598754883
(406) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00071811676025391
(407) DESCRIBE `cruises` 0.0056118965148926
(408) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75745') 0.00079894065856934
(409) DESCRIBE `ships` 0.0050051212310791
(410) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1594))) 0.00060296058654785
(411) DESCRIBE `ships` 0.003896951675415
(412) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1594') 0.00065398216247559
(413) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004889965057373
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047993659973145
(415) DESCRIBE `itineraries` 0.0019769668579102
(416) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75745') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084495544433594
(417) DESCRIBE `ports` 0.002748966217041
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00080609321594238
(419) DESCRIBE `ports` 0.0026049613952637
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00066304206848145
(421) DESCRIBE `ports` 0.0024189949035645
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00066399574279785
(423) DESCRIBE `sailingdates` 0.002612829208374
(424) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75745') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011229515075684
(425) DESCRIBE `ports` 0.0029032230377197
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00081491470336914
(427) DESCRIBE `ports` 0.0025508403778076
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00056910514831543
(429) DESCRIBE `ports` 0.002565860748291
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00056099891662598
(431) DESCRIBE `ports` 0.0024609565734863
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00058507919311523
(433) DESCRIBE `ports` 0.0025210380554199
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00060296058654785
(435) DESCRIBE `ports` 0.0032730102539062
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00072312355041504
(437) DESCRIBE `ports` 0.0032651424407959
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00067901611328125
(439) DESCRIBE `ports` 0.0031149387359619
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00063490867614746
(441) DESCRIBE `ports` 0.002769947052002
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00066709518432617
(443) DESCRIBE `ports` 0.0027859210968018
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.000579833984375
(445) DESCRIBE `ports` 0.0019021034240723
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.0004429817199707
(447) DESCRIBE `ports` 0.0025870800018311
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00042390823364258
(449) DESCRIBE `ports` 0.0020120143890381
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00047111511230469
(451) DESCRIBE `ports` 0.0022039413452148
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00057697296142578
(453) DESCRIBE `ports` 0.0022101402282715
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0011529922485352
(455) DESCRIBE `ports` 0.0023829936981201
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0006260871887207
(457) DESCRIBE `avid_specials` 0.0024430751800537
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75745 and class = 'Cruise') OR (item_id = 1594 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021860599517822
(459) DESCRIBE `cruiselines` 0.0049281120300293
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00090980529785156
(461) DESCRIBE `orchid_image` 0.0066418647766113
(462) DESCRIBE `cruiselines` 0.0060629844665527
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.0012900829315186
(464) DESCRIBE `cruises` 0.0074210166931152
(465) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76772') 0.00095200538635254
(466) DESCRIBE `ships` 0.0059370994567871
(467) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.0011188983917236
(468) DESCRIBE `ships` 0.0062501430511475
(469) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00066900253295898
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005190372467041
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00059199333190918
(472) DESCRIBE `itineraries` 0.0033531188964844
(473) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '76772') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0084919929504395
(474) DESCRIBE `ports` 0.003216028213501
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00083208084106445
(476) DESCRIBE `ports` 0.0029380321502686
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0007331371307373
(478) DESCRIBE `ports` 0.0027480125427246
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00061798095703125
(480) DESCRIBE `sailingdates` 0.0023648738861084
(481) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '76772') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013868808746338
(482) DESCRIBE `ports` 0.0031909942626953
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00087404251098633
(484) DESCRIBE `ports` 0.0034010410308838
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00076913833618164
(486) DESCRIBE `ports` 0.0046679973602295
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00070905685424805
(488) DESCRIBE `ports` 0.0029468536376953
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00073099136352539
(490) DESCRIBE `ports` 0.0029759407043457
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0010309219360352
(492) DESCRIBE `ports` 0.0032520294189453
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00071001052856445
(494) DESCRIBE `ports` 0.0038950443267822
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00082898139953613
(496) DESCRIBE `ports` 0.0036399364471436
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00069618225097656
(498) DESCRIBE `ports` 0.0033748149871826
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0008702278137207
(500) DESCRIBE `ports` 0.0037729740142822
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00085306167602539
(502) DESCRIBE `ports` 0.0033419132232666
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.0009458065032959
(504) DESCRIBE `ports` 0.0031518936157227
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00077414512634277
(506) DESCRIBE `ports` 0.0026099681854248
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00088810920715332
(508) DESCRIBE `ports` 0.0028290748596191
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00072598457336426
(510) DESCRIBE `ports` 0.0029289722442627
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00065302848815918
(512) DESCRIBE `ports` 0.0020408630371094
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00060796737670898
(514) DESCRIBE `avid_specials` 0.0024778842926025
(515) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76772 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018739700317383
(516) DESCRIBE `cruiselines` 0.0038092136383057
(517) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00073695182800293
(518) DESCRIBE `orchid_image` 0.0031869411468506
(519) DESCRIBE `cruiselines` 0.0040600299835205
(520) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00085186958312988
(521) DESCRIBE `cruises` 0.0058219432830811
(522) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77090') 0.00097203254699707
(523) DESCRIBE `ships` 0.0052568912506104
(524) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.0011191368103027
(525) DESCRIBE `ships` 0.0051970481872559
(526) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00076699256896973
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004889965057373
(528) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004889965057373
(529) DESCRIBE `itineraries` 0.0027239322662354
(530) DESCRIBE `ports` 0.0031099319458008
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0006859302520752
(532) DESCRIBE `ports` 0.0030379295349121
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00063300132751465
(534) DESCRIBE `ports` 0.0027861595153809
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00066184997558594
(536) DESCRIBE `sailingdates` 0.0024728775024414
(537) DESCRIBE `ports` 0.003026008605957
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00066685676574707
(539) DESCRIBE `ports` 0.002363920211792
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0005040168762207
(541) DESCRIBE `ports` 0.002295970916748
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00051498413085938
(543) DESCRIBE `ports` 0.0026390552520752
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00062298774719238
(545) DESCRIBE `ports` 0.0027050971984863
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0005800724029541
(547) DESCRIBE `ports` 0.0026481151580811
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00058603286743164
(549) DESCRIBE `ports` 0.0024838447570801
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00059294700622559
(551) DESCRIBE `ports` 0.0024960041046143
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.0006251335144043
(553) DESCRIBE `ports` 0.002432107925415
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00053715705871582
(555) DESCRIBE `ports` 0.0023598670959473
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00072002410888672
(557) DESCRIBE `ports` 0.0025579929351807
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00046491622924805
(559) DESCRIBE `ports` 0.002100944519043
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00057792663574219
(561) DESCRIBE `ports` 0.0021700859069824
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0006411075592041
(563) DESCRIBE `ports` 0.002406120300293
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00058293342590332
(565) DESCRIBE `ports` 0.0022830963134766
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0006108283996582
(567) DESCRIBE `ports` 0.0023128986358643
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00058984756469727
(569) DESCRIBE `avid_specials` 0.0026102066040039
(570) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77090 and class = 'Cruise') OR (item_id = 1588 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013320446014404
(571) DESCRIBE `cruiselines` 0.0035290718078613
(572) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0005640983581543
(573) DESCRIBE `orchid_image` 0.0020949840545654
(574) DESCRIBE `cruiselines` 0.0036048889160156
(575) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00064802169799805
(576) DESCRIBE `cruiselines` 0.0040290355682373
(577) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '144', '12', '23', '183', '20', '101', '120', '31', '18', '8', '131', '7', '96', '171', '170', '103', '206', '33', '156', '15', '50', '262', '191', '29', '195', '258', '91', '16', '37', '153', '14', '28', '24', '208', '187', '36', '114', '47', '49', '251', '141', '88', '212', '151', '181', '110', '118', '4', '264', '30', '216', '59', '140', '108', '115', '73', '159', '48', '211', '213', '147', '35', '38', '113', '276', '90', '95', '180', '57', '52', '244', '64', '172', '257', '261', '184', '82', '134', '245', '105', '177', '209')) ORDER BY FIND_IN_SET(id, '77,218,19,26,144,12,23,183,20,101,120,31,18,8,131,7,96,171,170,103,206,33,156,15,50,262,191,29,195,258,91,16,37,153,14,28,24,208,187,36,114,47,49,251,141,88,212,151,181,110,118,4,264,30,216,59,140,108,115,73,159,48,211,213,147,35,38,113,276,90,95,180,57,52,244,64,172,257,261,184,82,134,245,105,177,209') 0.0085129737854004
(578) DESCRIBE `ships` 0.004040002822876
(579) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '517', '1744', '732', '737', '1417', '726', '1324', '1554', '1588', '207', '1555', '1794', '1594', '454', '977', '1717', '521', '780', '1237', '1272', '974', '871', '258', '1032', '1359', '1424', '797', '265', '22', '404', '461', '21', '330', '770', '1292', '393', '28', '716', '1766', '1348', '1677', '1419', '1423', '520', '1420', '1422', '1418', '1421', '349', '857', '1205', '858', '1415', '1501', '333', '11', '986', '1682', '715', '738', '1067', '439', '739', '9', '10', '674', '25', '24', '855', '163', '837', '542', '1260', '1678', '455', '3', '1607', '882', '1768', '1008', '113', '407', '1402', '434', '1141', '610', '1135', '1773', '553', '480', '627', '332', '503', '792', '1742', '573', '1569', '160', '352', '386', '766', '817', '1454', '63', '1455', '66', '1721', '711', '1168', '1233', '1372', '1602', '198', '626', '657', '883', '1021', '1284', '285', '385', '585', '1413', '1410', '1599', '1302', '1411', '462', '1193', '1308', '1738', '111', '124', '526', '1259', '1266', '1320', '1323', '1579', '314', '1822', '286', '970', '1811', '43', '854', '1088', '327', '390', '582', '590', '1063', '1552', '1733', '485', '1145', '1586', '441', '748', '1068', '405', '944', '1321', '34', '38', '791', '1149', '31', '37', '119', '1492', '1722', '70', '678', '958', '1208', '1245', '1291', '1463', '1587', '1782', '14', '114', '162', '378', '406', '545', '616', '1028', '1711', '4', '351', '644', '658', '1027', '1412', '69', '335', '635', '850', '1157', '1672', '451', '1289', '1318', '1139', '1199', '1303', '1319', '401', '704', '1461', '341', '547', '722', '1108', '340', '580', '701', '1236', '1398', '105', '325', '403', '683', '1330', '601', '652', '966', '1013', '1408', '98', '148', '508', '1159', '1188', '1326', '1327', '1367', '1526', '201', '394', '651', '1151', '1575', '287', '348', '389', '818', '1172', '78', '291', '639', '1040', '39', '212', '338', '776', '1019', '1801', '30', '35', '36', '84', '123', '262', '988', '1012', '1037', '1043', '1743', '1809', '852', '1223', '1344', '1426', '1715', '27', '45', '266', '290', '673', '775', '1160', '1217', '1405', '1704', '1716', '1808', '483', '751', '1029', '1143', '1144', '1163', '1343', '1452', '1453', '1226', '1229', '1282', '1325', '1373', '1604', '574', '1358', '1724', '1730', '768', '968', '1095', '1283', '1409', '1740', '1772', '82', '905', '1035', '1137', '1152', '417', '769', '972', '1136', '1448', '108', '223', '253', '709', '1025', '1045', '1055', '1090', '1150', '1474', '151', '324', '851', '885', '1026', '1206', '1351', '150', '643', '663', '973', '1681', '1771', '116', '559', '884', '1230', '1231', '1458', '1713', '1750', '954', '1048', '1154', '1366', '1676', '1714', '1751', '1042', '1071', '1368', '1632', '1723', '208', '467', '665', '666', '924', '1049', '1196', '1322', '1360', '1361', '1362', '1459', '1708', '93', '784', '790', '920', '1051', '1052', '1140', '1148', '1483', '1609', '1649', '423', '921', '923', '996', '1293', '1301', '1580', '703', '888', '915', '1072', '1352', '1758', '147', '453', '916', '926', '930', '931', '1020', '1146', '1274', '1329', '75', '707', '1047', '1224', '1340', '1596', '1601', '1679', '1807', '1833', '205', '796', '886', '1004', '1039', '1073', '1109', '1241', '1262', '1389', '1445', '1468', '1519', '1539', '1571', '1791', '152', '422', '717', '1036', '1050', '1339', '1350', '516', '1054', '1075', '1486', '1574', '1749', '149', '730', '1044', '1294', '1759', '1767', '1788', '1806', '74', '81', '300', '656', '671', '672', '1232', '1256', '1572', '1664', '1673', '1816', '299', '1005', '1060', '1138', '1437', '1451', '1540', '1781', '1805', '420', '795', '821', '1225', '1254', '1444', '1823', '375', '448', '487', '743', '761', '982', '1011', '1663', '419', '493')) ORDER BY FIND_IN_SET(id, '1761,517,1744,732,737,1417,726,1324,1554,1588,207,1555,1794,1594,454,977,1717,521,780,1237,1272,974,871,258,1032,1359,1424,797,265,22,404,461,21,330,770,1292,393,28,716,1766,1348,1677,1419,1423,520,1420,1422,1418,1421,349,857,1205,858,1415,1501,333,11,986,1682,715,738,1067,439,739,9,10,674,25,24,855,163,837,542,1260,1678,455,3,1607,882,1768,1008,113,407,1402,434,1141,610,1135,1773,553,480,627,332,503,792,1742,573,1569,160,352,386,766,817,1454,63,1455,66,1721,711,1168,1233,1372,1602,198,626,657,883,1021,1284,285,385,585,1413,1410,1599,1302,1411,462,1193,1308,1738,111,124,526,1259,1266,1320,1323,1579,314,1822,286,970,1811,43,854,1088,327,390,582,590,1063,1552,1733,485,1145,1586,441,748,1068,405,944,1321,34,38,791,1149,31,37,119,1492,1722,70,678,958,1208,1245,1291,1463,1587,1782,14,114,162,378,406,545,616,1028,1711,4,351,644,658,1027,1412,69,335,635,850,1157,1672,451,1289,1318,1139,1199,1303,1319,401,704,1461,341,547,722,1108,340,580,701,1236,1398,105,325,403,683,1330,601,652,966,1013,1408,98,148,508,1159,1188,1326,1327,1367,1526,201,394,651,1151,1575,287,348,389,818,1172,78,291,639,1040,39,212,338,776,1019,1801,30,35,36,84,123,262,988,1012,1037,1043,1743,1809,852,1223,1344,1426,1715,27,45,266,290,673,775,1160,1217,1405,1704,1716,1808,483,751,1029,1143,1144,1163,1343,1452,1453,1226,1229,1282,1325,1373,1604,574,1358,1724,1730,768,968,1095,1283,1409,1740,1772,82,905,1035,1137,1152,417,769,972,1136,1448,108,223,253,709,1025,1045,1055,1090,1150,1474,151,324,851,885,1026,1206,1351,150,643,663,973,1681,1771,116,559,884,1230,1231,1458,1713,1750,954,1048,1154,1366,1676,1714,1751,1042,1071,1368,1632,1723,208,467,665,666,924,1049,1196,1322,1360,1361,1362,1459,1708,93,784,790,920,1051,1052,1140,1148,1483,1609,1649,423,921,923,996,1293,1301,1580,703,888,915,1072,1352,1758,147,453,916,926,930,931,1020,1146,1274,1329,75,707,1047,1224,1340,1596,1601,1679,1807,1833,205,796,886,1004,1039,1073,1109,1241,1262,1389,1445,1468,1519,1539,1571,1791,152,422,717,1036,1050,1339,1350,516,1054,1075,1486,1574,1749,149,730,1044,1294,1759,1767,1788,1806,74,81,300,656,671,672,1232,1256,1572,1664,1673,1816,299,1005,1060,1138,1437,1451,1540,1781,1805,420,795,821,1225,1254,1444,1823,375,448,487,743,761,982,1011,1663,419,493') 0.086848974227905
(580) DESCRIBE `cruisetypes` 0.0021510124206543
(581) DESCRIBE `destinations` 0.0030579566955566
(582) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '37', '2', '8', '44', '53', '55', '39', '28', '38', '26', '11', '40', '48', '7', '45', '21', '29', '49', '30', '34', '52', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,37,2,8,44,53,55,39,28,38,26,11,40,48,7,45,21,29,49,30,34,52,10,46,56,32') 0.003917932510376