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

Total elapsed time: 1.0496661663055

# Query Time
(1) connect 0.0021278858184814
(2) DESCRIBE `cruises` 0.0061259269714355
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76690, 52456, 78243, 78226, 79312, 63785, 79246, 79311, 63893, 76590)) ORDER BY FIND_IN_SET(id, '76690,52456,78243,78226,79312,63785,79246,79311,63893,76590') 0.0043678283691406
(4) DESCRIBE `cruises` 0.0051329135894775
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76690') 0.00063490867614746
(6) DESCRIBE `ships` 0.0054938793182373
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84))) 0.00064778327941895
(8) DESCRIBE `ships` 0.0053369998931885
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '84') 0.00068092346191406
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00055909156799316
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047802925109863
(12) DESCRIBE `itineraries` 0.0028691291809082
(13) DESCRIBE `ports` 0.0025930404663086
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00058197975158691
(15) DESCRIBE `ports` 0.0025520324707031
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.0005648136138916
(17) DESCRIBE `ports` 0.0025942325592041
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.0005190372467041
(19) DESCRIBE `sailingdates` 0.0022590160369873
(20) DESCRIBE `ports` 0.0025589466094971
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00053501129150391
(22) DESCRIBE `ports` 0.0026481151580811
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00058507919311523
(24) DESCRIBE `ports` 0.00323486328125
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00065207481384277
(26) DESCRIBE `ports` 0.0029399394989014
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00045204162597656
(28) DESCRIBE `ports` 0.0020861625671387
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00048995018005371
(30) DESCRIBE `ports` 0.0018830299377441
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00042605400085449
(32) DESCRIBE `ports` 0.0019159317016602
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00051689147949219
(34) DESCRIBE `ports` 0.0029799938201904
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00044417381286621
(36) DESCRIBE `ports` 0.0025191307067871
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00055408477783203
(38) DESCRIBE `ports` 0.002795934677124
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00045084953308105
(40) DESCRIBE `ports` 0.002554178237915
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00058388710021973
(42) DESCRIBE `ports` 0.0031628608703613
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00040984153747559
(44) DESCRIBE `ports` 0.0020859241485596
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00045585632324219
(46) DESCRIBE `ports` 0.0023579597473145
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00037908554077148
(48) DESCRIBE `ports` 0.0020802021026611
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00048398971557617
(50) DESCRIBE `ports` 0.0020778179168701
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00049400329589844
(52) DESCRIBE `ports` 0.003154993057251
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00044798851013184
(54) DESCRIBE `ports` 0.0033969879150391
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00057506561279297
(56) DESCRIBE `ports` 0.0020029544830322
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495))) 0.00053811073303223
(58) DESCRIBE `ports` 0.0019099712371826
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1495') 0.00046801567077637
(60) DESCRIBE `ports` 0.0021030902862549
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3264))) 0.00045895576477051
(62) DESCRIBE `ports` 0.0095930099487305
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3264') 0.00054788589477539
(64) DESCRIBE `ports` 0.0026319026947021
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00049400329589844
(66) DESCRIBE `ports` 0.0019469261169434
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00041103363037109
(68) DESCRIBE `ports` 0.0022428035736084
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.0004279613494873
(70) DESCRIBE `ports` 0.0022730827331543
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00040793418884277
(72) DESCRIBE `ports` 0.0021319389343262
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00052404403686523
(74) DESCRIBE `ports` 0.0018301010131836
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00050210952758789
(76) DESCRIBE `avid_specials` 0.0015759468078613
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76690 and class = 'Cruise') OR (item_id = 84 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 37 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.0013430118560791
(78) DESCRIBE `cruiselines` 0.0026900768280029
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00050091743469238
(80) DESCRIBE `orchid_image` 0.0020561218261719
(81) DESCRIBE `cruiselines` 0.0027661323547363
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00051498413085938
(83) DESCRIBE `cruises` 0.0092198848724365
(84) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52456') 0.0088279247283936
(85) DESCRIBE `ships` 0.0037698745727539
(86) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00044608116149902
(87) DESCRIBE `ships` 0.0034048557281494
(88) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.0027778148651123
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0031518936157227
(91) DESCRIBE `itineraries` 0.0025479793548584
(92) DESCRIBE `ports` 0.0024189949035645
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00057101249694824
(94) DESCRIBE `ports` 0.0021259784698486
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0004279613494873
(96) DESCRIBE `ports` 0.0020091533660889
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00050091743469238
(98) DESCRIBE `sailingdates` 0.0016219615936279
(99) DESCRIBE `ports` 0.0023210048675537
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00059080123901367
(101) DESCRIBE `ports` 0.0018060207366943
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00039505958557129
(103) DESCRIBE `ports` 0.0018408298492432
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00052595138549805
(105) DESCRIBE `ports` 0.0024218559265137
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00051212310791016
(107) DESCRIBE `ports` 0.0023050308227539
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00056600570678711
(109) DESCRIBE `ports` 0.0023970603942871
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00050187110900879
(111) DESCRIBE `ports` 0.0024030208587646
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00060200691223145
(113) DESCRIBE `ports` 0.0030639171600342
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00060391426086426
(115) DESCRIBE `ports` 0.0030379295349121
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00063991546630859
(117) DESCRIBE `ports` 0.0027470588684082
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00055718421936035
(119) DESCRIBE `ports` 0.0028700828552246
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2089))) 0.00068807601928711
(121) DESCRIBE `ports` 0.0028560161590576
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2089') 0.00058102607727051
(123) DESCRIBE `ports` 0.0028300285339355
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00069808959960938
(125) DESCRIBE `ports` 0.002769947052002
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00059199333190918
(127) DESCRIBE `ports` 0.0026459693908691
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00067281723022461
(129) DESCRIBE `ports` 0.0027902126312256
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.00045990943908691
(131) DESCRIBE `ports` 0.0018479824066162
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00048017501831055
(133) DESCRIBE `ports` 0.0018110275268555
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00046205520629883
(135) DESCRIBE `avid_specials` 0.0017788410186768
(136) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52456 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 48 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.0017931461334229
(137) DESCRIBE `cruiselines` 0.0030221939086914
(138) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00069499015808105
(139) DESCRIBE `orchid_image` 0.0021378993988037
(140) DESCRIBE `cruiselines` 0.0038471221923828
(141) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00058698654174805
(142) DESCRIBE `cruises` 0.0043148994445801
(143) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78243') 0.00061798095703125
(144) DESCRIBE `ships` 0.0049328804016113
(145) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 82))) 0.00071477890014648
(146) DESCRIBE `ships` 0.0049419403076172
(147) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '82') 0.00069403648376465
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046300888061523
(149) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004730224609375
(150) DESCRIBE `itineraries` 0.0024490356445312
(151) DESCRIBE `ports` 0.0026319026947021
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00062704086303711
(153) DESCRIBE `ports` 0.0022299289703369
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044083595275879
(155) DESCRIBE `ports` 0.0022768974304199
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0004429817199707
(157) DESCRIBE `sailingdates` 0.00168776512146
(158) DESCRIBE `ports` 0.0020840167999268
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045990943908691
(160) DESCRIBE `ports` 0.0019519329071045
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00042295455932617
(162) DESCRIBE `ports` 0.001986026763916
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00043916702270508
(164) DESCRIBE `ports` 0.0020430088043213
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00043892860412598
(166) DESCRIBE `ports` 0.0019769668579102
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00049710273742676
(168) DESCRIBE `ports` 0.0018951892852783
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00041723251342773
(170) DESCRIBE `ports` 0.0023019313812256
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2286))) 0.00056314468383789
(172) DESCRIBE `ports` 0.0022749900817871
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2286') 0.00046086311340332
(174) DESCRIBE `ports` 0.0017960071563721
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00047683715820312
(176) DESCRIBE `ports` 0.0021679401397705
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.0003819465637207
(178) DESCRIBE `ports` 0.0022151470184326
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2274))) 0.00046205520629883
(180) DESCRIBE `ports` 0.0020408630371094
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2274') 0.00039005279541016
(182) DESCRIBE `ports` 0.0018470287322998
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 310))) 0.00056290626525879
(184) DESCRIBE `ports` 0.0019021034240723
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '310') 0.00054788589477539
(186) DESCRIBE `ports` 0.0025029182434082
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 311))) 0.00060892105102539
(188) DESCRIBE `ports` 0.0020930767059326
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '311') 0.0004279613494873
(190) DESCRIBE `ports` 0.0023620128631592
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00069713592529297
(192) DESCRIBE `ports` 0.0021309852600098
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00056815147399902
(194) DESCRIBE `ports` 0.0020830631256104
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00068187713623047
(196) DESCRIBE `ports` 0.0025420188903809
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00051689147949219
(198) DESCRIBE `ports` 0.0027680397033691
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3686))) 0.00044798851013184
(200) DESCRIBE `ports` 0.0026240348815918
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3686') 0.00061297416687012
(202) DESCRIBE `ports` 0.0024628639221191
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 672))) 0.00050806999206543
(204) DESCRIBE `ports` 0.0019528865814209
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '672') 0.00050997734069824
(206) DESCRIBE `ports` 0.0020978450775146
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00046110153198242
(208) DESCRIBE `ports` 0.0018908977508545
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.0005030632019043
(210) DESCRIBE `ports` 0.0020430088043213
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1149))) 0.00048398971557617
(212) DESCRIBE `ports` 0.0019018650054932
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1149') 0.00043416023254395
(214) DESCRIBE `ports` 0.0019171237945557
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00057411193847656
(216) DESCRIBE `ports` 0.0023488998413086
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00041604042053223
(218) DESCRIBE `ports` 0.0020711421966553
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00051212310791016
(220) DESCRIBE `ports` 0.0018489360809326
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00040006637573242
(222) DESCRIBE `ports` 0.0020079612731934
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00045204162597656
(224) DESCRIBE `ports` 0.0019590854644775
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00040197372436523
(226) DESCRIBE `ports` 0.002485990524292
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00042104721069336
(228) DESCRIBE `ports` 0.0018939971923828
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00044488906860352
(230) DESCRIBE `ports` 0.0021529197692871
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00053191184997559
(232) DESCRIBE `ports` 0.0019807815551758
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00058817863464355
(234) DESCRIBE `ports` 0.0018792152404785
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00042915344238281
(236) DESCRIBE `ports` 0.0018599033355713
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00040197372436523
(238) DESCRIBE `ports` 0.0019090175628662
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045180320739746
(240) DESCRIBE `ports` 0.0017631053924561
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00038003921508789
(242) DESCRIBE `avid_specials` 0.0019028186798096
(243) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78243 and class = 'Cruise') OR (item_id = 82 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 37 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.0014100074768066
(244) DESCRIBE `cruiselines` 0.0032978057861328
(245) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00057315826416016
(246) DESCRIBE `orchid_image` 0.0029489994049072
(247) DESCRIBE `cruiselines` 0.0029120445251465
(248) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0005190372467041
(249) DESCRIBE `cruises` 0.0033631324768066
(250) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78226') 0.00042200088500977
(251) DESCRIBE `ships` 0.003525972366333
(252) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 78))) 0.00048518180847168
(253) DESCRIBE `ships` 0.0035190582275391
(254) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '78') 0.0003819465637207
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035810470581055
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037598609924316
(257) DESCRIBE `itineraries` 0.002094030380249
(258) DESCRIBE `ports` 0.0021629333496094
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045514106750488
(260) DESCRIBE `ports` 0.0019280910491943
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043487548828125
(262) DESCRIBE `ports` 0.0017790794372559
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00038695335388184
(264) DESCRIBE `sailingdates` 0.001676082611084
(265) DESCRIBE `ports` 0.0019590854644775
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044989585876465
(267) DESCRIBE `ports` 0.0018558502197266
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00038719177246094
(269) DESCRIBE `ports` 0.0018038749694824
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00040102005004883
(271) DESCRIBE `ports` 0.0019299983978271
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00038504600524902
(273) DESCRIBE `ports` 0.0017499923706055
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00041699409484863
(275) DESCRIBE `ports` 0.0017950534820557
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00037693977355957
(277) DESCRIBE `ports` 0.001878023147583
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00042986869812012
(279) DESCRIBE `ports` 0.0025210380554199
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00055193901062012
(281) DESCRIBE `ports` 0.0018720626831055
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00045394897460938
(283) DESCRIBE `ports` 0.0022759437561035
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00049114227294922
(285) DESCRIBE `ports` 0.0021917819976807
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00055408477783203
(287) DESCRIBE `ports` 0.002331018447876
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00047206878662109
(289) DESCRIBE `ports` 0.002072811126709
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00043797492980957
(291) DESCRIBE `ports` 0.0018160343170166
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.0004889965057373
(293) DESCRIBE `ports` 0.0020129680633545
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2142))) 0.0005488395690918
(295) DESCRIBE `ports` 0.001849889755249
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2142') 0.00040578842163086
(297) DESCRIBE `ports` 0.0018439292907715
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00054502487182617
(299) DESCRIBE `ports` 0.0019028186798096
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00039792060852051
(301) DESCRIBE `ports` 0.0020649433135986
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00042486190795898
(303) DESCRIBE `ports` 0.0018329620361328
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00041890144348145
(305) DESCRIBE `avid_specials` 0.0016491413116455
(306) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78226 and class = 'Cruise') OR (item_id = 78 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 48 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.0011200904846191
(307) DESCRIBE `cruiselines` 0.003061056137085
(308) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00049591064453125
(309) DESCRIBE `orchid_image` 0.0020370483398438
(310) DESCRIBE `cruiselines` 0.0027258396148682
(311) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00042605400085449
(312) DESCRIBE `cruises` 0.0042109489440918
(313) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79312') 0.00046992301940918
(314) DESCRIBE `ships` 0.0038821697235107
(315) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 401))) 0.00064301490783691
(316) DESCRIBE `ships` 0.004209041595459
(317) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '401') 0.00048398971557617
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047492980957031
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047111511230469
(320) DESCRIBE `itineraries` 0.0019588470458984
(321) DESCRIBE `ports` 0.0018839836120605
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0004580020904541
(323) DESCRIBE `ports` 0.0019540786743164
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00051593780517578
(325) DESCRIBE `ports` 0.002202033996582
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00041890144348145
(327) DESCRIBE `sailingdates` 0.0018570423126221
(328) DESCRIBE `ports` 0.0020101070404053
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00053691864013672
(330) DESCRIBE `ports` 0.0019099712371826
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00053215026855469
(332) DESCRIBE `ports` 0.0018301010131836
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00047802925109863
(334) DESCRIBE `ports` 0.0020420551300049
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00042486190795898
(336) DESCRIBE `ports` 0.0020968914031982
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00055885314941406
(338) DESCRIBE `ports` 0.0020661354064941
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00041699409484863
(340) DESCRIBE `ports` 0.0019259452819824
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00041794776916504
(342) DESCRIBE `ports` 0.0018579959869385
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.0004420280456543
(344) DESCRIBE `ports` 0.001903772354126
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00047898292541504
(346) DESCRIBE `ports` 0.0020179748535156
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00038909912109375
(348) DESCRIBE `ports` 0.0019500255584717
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00041508674621582
(350) DESCRIBE `ports` 0.001856803894043
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00049400329589844
(352) DESCRIBE `ports` 0.0020821094512939
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00051999092102051
(354) DESCRIBE `ports` 0.0019159317016602
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00056600570678711
(356) DESCRIBE `ports` 0.0020608901977539
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00051498413085938
(358) DESCRIBE `ports` 0.001910924911499
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00039911270141602
(360) DESCRIBE `ports` 0.0018260478973389
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00042819976806641
(362) DESCRIBE `ports` 0.0018270015716553
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00045108795166016
(364) DESCRIBE `ports` 0.0017988681793213
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00041103363037109
(366) DESCRIBE `ports` 0.0019028186798096
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039911270141602
(368) DESCRIBE `ports` 0.0017518997192383
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00044107437133789
(370) DESCRIBE `ports` 0.0019490718841553
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00037813186645508
(372) DESCRIBE `ports` 0.0024909973144531
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 180))) 0.00063395500183105
(374) DESCRIBE `ports` 0.0019979476928711
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '180') 0.00037908554077148
(376) DESCRIBE `ports` 0.0018479824066162
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00039911270141602
(378) DESCRIBE `ports` 0.0017669200897217
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00038790702819824
(380) DESCRIBE `ports` 0.0019500255584717
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00039982795715332
(382) DESCRIBE `ports` 0.0018219947814941
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00035810470581055
(384) DESCRIBE `ports` 0.0017580986022949
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00045299530029297
(386) DESCRIBE `ports` 0.0024018287658691
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.00044703483581543
(388) DESCRIBE `ports` 0.0018401145935059
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 188))) 0.00043201446533203
(390) DESCRIBE `ports` 0.0018730163574219
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '188') 0.00047183036804199
(392) DESCRIBE `ports` 0.0018670558929443
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00043392181396484
(394) DESCRIBE `ports` 0.0020921230316162
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00038790702819824
(396) DESCRIBE `ports` 0.0018379688262939
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.00062108039855957
(398) DESCRIBE `ports` 0.002122163772583
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00065398216247559
(400) DESCRIBE `ports` 0.0024929046630859
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00051307678222656
(402) DESCRIBE `ports` 0.0018808841705322
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00052809715270996
(404) DESCRIBE `ports` 0.001849889755249
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0004420280456543
(406) DESCRIBE `ports` 0.0020079612731934
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00038599967956543
(408) DESCRIBE `avid_specials` 0.0016810894012451
(409) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79312 and class = 'Cruise') OR (item_id = 401 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012729167938232
(410) DESCRIBE `cruiselines` 0.0029680728912354
(411) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00048398971557617
(412) DESCRIBE `orchid_image` 0.0020520687103271
(413) DESCRIBE `cruiselines` 0.0026640892028809
(414) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00043296813964844
(415) DESCRIBE `cruises` 0.0040280818939209
(416) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63785') 0.00063896179199219
(417) DESCRIBE `ships` 0.0038270950317383
(418) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00056314468383789
(419) DESCRIBE `ships` 0.0036249160766602
(420) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.0004580020904541
(421) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00045299530029297
(422) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040984153747559
(423) DESCRIBE `itineraries` 0.0022730827331543
(424) DESCRIBE `ports` 0.0021040439605713
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004580020904541
(426) DESCRIBE `ports` 0.0018949508666992
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041508674621582
(428) DESCRIBE `ports` 0.0018899440765381
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00038814544677734
(430) DESCRIBE `sailingdates` 0.001554012298584
(431) DESCRIBE `ports` 0.0024349689483643
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00060296058654785
(433) DESCRIBE `ports` 0.0024099349975586
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00059199333190918
(435) DESCRIBE `ports` 0.0020389556884766
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00041890144348145
(437) DESCRIBE `ports` 0.0018789768218994
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00039410591125488
(439) DESCRIBE `ports` 0.0021381378173828
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00042009353637695
(441) DESCRIBE `ports` 0.0017809867858887
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0003809928894043
(443) DESCRIBE `ports` 0.0017421245574951
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00046896934509277
(445) DESCRIBE `ports` 0.002039909362793
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0003969669342041
(447) DESCRIBE `ports` 0.0018930435180664
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00041794776916504
(449) DESCRIBE `ports` 0.0017929077148438
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00042390823364258
(451) DESCRIBE `ports` 0.0017750263214111
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0005180835723877
(453) DESCRIBE `ports` 0.0018689632415771
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00039100646972656
(455) DESCRIBE `ports` 0.0021750926971436
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00053286552429199
(457) DESCRIBE `ports` 0.0019810199737549
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00041699409484863
(459) DESCRIBE `ports` 0.0018141269683838
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00043487548828125
(461) DESCRIBE `ports` 0.0019619464874268
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00038790702819824
(463) DESCRIBE `ports` 0.0018079280853271
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0004270076751709
(465) DESCRIBE `ports` 0.0017631053924561
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00038504600524902
(467) DESCRIBE `ports` 0.0018839836120605
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00041484832763672
(469) DESCRIBE `ports` 0.0018601417541504
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004429817199707
(471) DESCRIBE `ports` 0.0017669200897217
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004119873046875
(473) DESCRIBE `ports` 0.0017468929290771
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039005279541016
(475) DESCRIBE `avid_specials` 0.001676082611084
(476) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63785 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 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.0011181831359863
(477) DESCRIBE `cruiselines` 0.0025830268859863
(478) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00054597854614258
(479) DESCRIBE `orchid_image` 0.0021681785583496
(480) DESCRIBE `cruiselines` 0.0031681060791016
(481) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00050497055053711
(482) DESCRIBE `cruises` 0.0050280094146729
(483) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79246') 0.00060391426086426
(484) DESCRIBE `ships` 0.0052270889282227
(485) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00068306922912598
(486) DESCRIBE `ships` 0.0051009654998779
(487) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00069499015808105
(488) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053906440734863
(489) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00075984001159668
(490) DESCRIBE `itineraries` 0.0023629665374756
(491) DESCRIBE `ports` 0.0018711090087891
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00064897537231445
(493) DESCRIBE `ports` 0.0022470951080322
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00051593780517578
(495) DESCRIBE `ports` 0.0018529891967773
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00039386749267578
(497) DESCRIBE `sailingdates` 0.0017168521881104
(498) DESCRIBE `ports` 0.0018770694732666
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043296813964844
(500) DESCRIBE `ports` 0.0019130706787109
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0003819465637207
(502) DESCRIBE `ports` 0.0021040439605713
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00042080879211426
(504) DESCRIBE `ports` 0.0018510818481445
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.0003819465637207
(506) DESCRIBE `ports` 0.0017580986022949
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00043511390686035
(508) DESCRIBE `ports` 0.0018610954284668
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.0003960132598877
(510) DESCRIBE `ports` 0.0018250942230225
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00046491622924805
(512) DESCRIBE `ports` 0.0017521381378174
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.0005650520324707
(514) DESCRIBE `ports` 0.0018339157104492
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00041103363037109
(516) DESCRIBE `ports` 0.0018579959869385
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.0003809928894043
(518) DESCRIBE `ports` 0.0018839836120605
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00065302848815918
(520) DESCRIBE `ports` 0.0020489692687988
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00047802925109863
(522) DESCRIBE `ports` 0.0018091201782227
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00046706199645996
(524) DESCRIBE `ports` 0.0018751621246338
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00039887428283691
(526) DESCRIBE `ports` 0.0018680095672607
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00040793418884277
(528) DESCRIBE `ports` 0.0020370483398438
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.0003969669342041
(530) DESCRIBE `ports` 0.0017819404602051
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00043916702270508
(532) DESCRIBE `ports` 0.0017778873443604
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0003960132598877
(534) DESCRIBE `ports` 0.0018019676208496
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00042390823364258
(536) DESCRIBE `ports` 0.0018770694732666
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00039505958557129
(538) DESCRIBE `ports` 0.0017490386962891
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00056600570678711
(540) DESCRIBE `ports` 0.0019650459289551
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00042986869812012
(542) DESCRIBE `avid_specials` 0.0024149417877197
(543) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79246 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020079612731934
(544) DESCRIBE `cruiselines` 0.0038449764251709
(545) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00049304962158203
(546) DESCRIBE `orchid_image` 0.002039909362793
(547) DESCRIBE `cruiselines` 0.0034241676330566
(548) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00062298774719238
(549) DESCRIBE `cruises` 0.0035359859466553
(550) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79311') 0.00047993659973145
(551) DESCRIBE `ships` 0.0035521984100342
(552) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 401))) 0.0005650520324707
(553) DESCRIBE `ships` 0.003680944442749
(554) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '401') 0.00039196014404297
(555) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(556) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034999847412109
(557) DESCRIBE `itineraries` 0.001816987991333
(558) DESCRIBE `ports` 0.0018100738525391
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0004570484161377
(560) DESCRIBE `ports` 0.0018260478973389
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00044083595275879
(562) DESCRIBE `ports` 0.0018188953399658
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00040292739868164
(564) DESCRIBE `sailingdates` 0.0016019344329834
(565) DESCRIBE `ports` 0.0024631023406982
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00044989585876465
(567) DESCRIBE `ports` 0.0020411014556885
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00039482116699219
(569) DESCRIBE `ports` 0.0018811225891113
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00047183036804199
(571) DESCRIBE `ports` 0.0018050670623779
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00037884712219238
(573) DESCRIBE `ports` 0.0019900798797607
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00042104721069336
(575) DESCRIBE `ports` 0.0018560886383057
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00040411949157715
(577) DESCRIBE `ports` 0.0019550323486328
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00042891502380371
(579) DESCRIBE `ports` 0.0018658638000488
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00038385391235352
(581) DESCRIBE `ports` 0.0017881393432617
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00045299530029297
(583) DESCRIBE `ports` 0.0017831325531006
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.0003809928894043
(585) DESCRIBE `ports` 0.0022690296173096
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.0005640983581543
(587) DESCRIBE `ports` 0.0018670558929443
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00051093101501465
(589) DESCRIBE `ports` 0.0020139217376709
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00043106079101562
(591) DESCRIBE `ports` 0.0021400451660156
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.0003969669342041
(593) DESCRIBE `ports` 0.0018379688262939
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00051307678222656
(595) DESCRIBE `ports` 0.0019509792327881
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00038504600524902
(597) DESCRIBE `ports` 0.0019280910491943
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00041580200195312
(599) DESCRIBE `ports` 0.0019841194152832
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00038599967956543
(601) DESCRIBE `ports` 0.0018250942230225
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0004417896270752
(603) DESCRIBE `ports` 0.001924991607666
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00067305564880371
(605) DESCRIBE `ports` 0.0024850368499756
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00046801567077637
(607) DESCRIBE `ports` 0.002108097076416
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00049591064453125
(609) DESCRIBE `avid_specials` 0.0019059181213379
(610) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79311 and class = 'Cruise') OR (item_id = 401 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013120174407959
(611) DESCRIBE `cruiselines` 0.0025339126586914
(612) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00043702125549316
(613) DESCRIBE `orchid_image` 0.002061128616333
(614) DESCRIBE `cruiselines` 0.0026898384094238
(615) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00042414665222168
(616) DESCRIBE `cruises` 0.0033459663391113
(617) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63893') 0.00040316581726074
(618) DESCRIBE `ships` 0.0041849613189697
(619) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.0005800724029541
(620) DESCRIBE `ships` 0.0046050548553467
(621) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.0005488395690918
(622) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037002563476562
(623) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(624) DESCRIBE `itineraries` 0.0021488666534424
(625) DESCRIBE `ports` 0.0020170211791992
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00043797492980957
(627) DESCRIBE `ports` 0.0019130706787109
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00041294097900391
(629) DESCRIBE `ports` 0.0018010139465332
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00040817260742188
(631) DESCRIBE `sailingdates` 0.0016250610351562
(632) DESCRIBE `ports` 0.0019230842590332
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00049710273742676
(634) DESCRIBE `ports` 0.0017950534820557
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00046300888061523
(636) DESCRIBE `ports` 0.0018210411071777
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00043201446533203
(638) DESCRIBE `ports` 0.0019309520721436
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00037693977355957
(640) DESCRIBE `ports` 0.0021522045135498
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00042605400085449
(642) DESCRIBE `ports` 0.0021219253540039
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00045609474182129
(644) DESCRIBE `ports` 0.0018110275268555
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.0005500316619873
(646) DESCRIBE `ports` 0.0019810199737549
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00039505958557129
(648) DESCRIBE `ports` 0.0019588470458984
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.0004119873046875
(650) DESCRIBE `ports` 0.0019128322601318
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00039410591125488
(652) DESCRIBE `avid_specials` 0.0016131401062012
(653) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63893 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 53 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012109279632568
(654) DESCRIBE `cruiselines` 0.0029940605163574
(655) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0004730224609375
(656) DESCRIBE `orchid_image` 0.0020110607147217
(657) DESCRIBE `cruiselines` 0.0026698112487793
(658) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00045108795166016
(659) DESCRIBE `cruises` 0.0036060810089111
(660) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76590') 0.00045204162597656
(661) DESCRIBE `ships` 0.0033879280090332
(662) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00060105323791504
(663) DESCRIBE `ships` 0.0036308765411377
(664) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00038599967956543
(665) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035691261291504
(666) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004880428314209
(667) DESCRIBE `itineraries` 0.0022690296173096
(668) DESCRIBE `ports` 0.0021090507507324
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00052905082702637
(670) DESCRIBE `ports` 0.0017728805541992
(671) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045013427734375
(672) DESCRIBE `ports` 0.0018241405487061
(673) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00040102005004883
(674) DESCRIBE `sailingdates` 0.0016109943389893
(675) DESCRIBE `ports` 0.0018231868743896
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00040888786315918
(677) DESCRIBE `ports` 0.0019428730010986
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00038504600524902
(679) DESCRIBE `ports` 0.0018301010131836
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00058102607727051
(681) DESCRIBE `ports` 0.0017750263214111
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00043392181396484
(683) DESCRIBE `ports` 0.0018520355224609
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.0004119873046875
(685) DESCRIBE `ports` 0.0020430088043213
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00039100646972656
(687) DESCRIBE `ports` 0.0017490386962891
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00045299530029297
(689) DESCRIBE `ports` 0.0017340183258057
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00039386749267578
(691) DESCRIBE `ports` 0.0025389194488525
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00041294097900391
(693) DESCRIBE `ports` 0.0018417835235596
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00037312507629395
(695) DESCRIBE `ports` 0.0018360614776611
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043106079101562
(697) DESCRIBE `ports` 0.0018050670623779
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00050711631774902
(699) DESCRIBE `avid_specials` 0.0021820068359375
(700) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76590 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016829967498779
(701) DESCRIBE `cruiselines` 0.0035059452056885
(702) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00064182281494141
(703) DESCRIBE `orchid_image` 0.0020639896392822
(704) DESCRIBE `cruiselines` 0.0031001567840576
(705) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00044107437133789
(706) DESCRIBE `ships` 0.0040619373321533
(707) SELECT `ships`.* FROM `ships` WHERE (id IN ('792', '657', '1607', '1302', '547', '340', '335', '75', '82', '401', '78', '81', '84', '74')) ORDER BY FIND_IN_SET(id, '792,657,1607,1302,547,340,335,75,82,401,78,81,84,74') 0.0018279552459717
(708) DESCRIBE `cruisetypes` 0.0024571418762207
(709) DESCRIBE `destinations` 0.0025730133056641
(710) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '12', '48', '22', '43', '25', '11', '37', '35', '53', '34', '38', '26', '49', '29', '21', '8', '28', '40', '52')) ORDER BY FIND_IN_SET(id, '2,12,48,22,43,25,11,37,35,53,34,38,26,49,29,21,8,28,40,52') 0.0021200180053711
(711) DESCRIBE `cruiselines` 0.0040450096130371
(712) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00059294700622559
(713) DESCRIBE `cruiselines` 0.0031280517578125
(714) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00091195106506348