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

Total elapsed time: 0.94067931175232

# Query Time
(1) connect 0.0013680458068848
(2) DESCRIBE `cruises` 0.0044867992401123
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (79893, 72935, 72914, 72806, 72913, 72868, 72884, 72867, 72937, 85104)) ORDER BY FIND_IN_SET(id, '79893,72935,72914,72806,72913,72868,72884,72867,72937,85104') 0.0025749206542969
(4) DESCRIBE `cruises` 0.004127025604248
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79893') 0.0004570484161377
(6) DESCRIBE `ships` 0.0039098262786865
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.0006709098815918
(8) DESCRIBE `ships` 0.0041260719299316
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.0004420280456543
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00045895576477051
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(12) DESCRIBE `itineraries` 0.0019049644470215
(13) DESCRIBE `ports` 0.0019090175628662
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00044894218444824
(15) DESCRIBE `ports` 0.0019659996032715
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00041699409484863
(17) DESCRIBE `ports` 0.0020499229431152
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00043511390686035
(19) DESCRIBE `sailingdates` 0.0016989707946777
(20) DESCRIBE `ports` 0.0018160343170166
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00042510032653809
(22) DESCRIBE `ports` 0.0017468929290771
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00038313865661621
(24) DESCRIBE `ports` 0.0017540454864502
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00041699409484863
(26) DESCRIBE `ports` 0.0018529891967773
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00060796737670898
(28) DESCRIBE `ports` 0.0022990703582764
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00052118301391602
(30) DESCRIBE `ports` 0.0024828910827637
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00048208236694336
(32) DESCRIBE `ports` 0.0019481182098389
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049710273742676
(34) DESCRIBE `ports` 0.0018119812011719
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039005279541016
(36) DESCRIBE `ports` 0.0018799304962158
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00060701370239258
(38) DESCRIBE `ports` 0.0023410320281982
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00059318542480469
(40) DESCRIBE `ports` 0.0027050971984863
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00064396858215332
(42) DESCRIBE `ports` 0.0027439594268799
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00057601928710938
(44) DESCRIBE `ports` 0.0026800632476807
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00065183639526367
(46) DESCRIBE `ports` 0.0027182102203369
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00056195259094238
(48) DESCRIBE `ports` 0.0026350021362305
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00058388710021973
(50) DESCRIBE `ports` 0.0026240348815918
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00066804885864258
(52) DESCRIBE `ports` 0.0026130676269531
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00056695938110352
(54) DESCRIBE `ports` 0.0025861263275146
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00055909156799316
(56) DESCRIBE `ports` 0.0026760101318359
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00060796737670898
(58) DESCRIBE `ports` 0.0028629302978516
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.000579833984375
(60) DESCRIBE `avid_specials` 0.0026030540466309
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79893 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022389888763428
(62) DESCRIBE `cruiselines` 0.0039761066436768
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00065088272094727
(64) DESCRIBE `orchid_image` 0.003058910369873
(65) DESCRIBE `cruiselines` 0.0037150382995605
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00056791305541992
(67) DESCRIBE `cruises` 0.0049810409545898
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72935') 0.00059604644775391
(69) DESCRIBE `ships` 0.0053501129150391
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00073790550231934
(71) DESCRIBE `ships` 0.0054450035095215
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.0006401538848877
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00059199333190918
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050187110900879
(75) DESCRIBE `itineraries` 0.0026891231536865
(76) DESCRIBE `ports` 0.0029380321502686
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00070500373840332
(78) DESCRIBE `ports` 0.0028278827667236
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00066590309143066
(80) DESCRIBE `ports` 0.0027341842651367
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00059795379638672
(82) DESCRIBE `sailingdates` 0.0023369789123535
(83) DESCRIBE `ports` 0.0028858184814453
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00063300132751465
(85) DESCRIBE `ports` 0.0027849674224854
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00056600570678711
(87) DESCRIBE `ports` 0.0027720928192139
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.0006558895111084
(89) DESCRIBE `ports` 0.002673864364624
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00062108039855957
(91) DESCRIBE `ports` 0.0027101039886475
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00063204765319824
(93) DESCRIBE `ports` 0.0025498867034912
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00056314468383789
(95) DESCRIBE `ports` 0.0026631355285645
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00054502487182617
(97) DESCRIBE `ports` 0.002810001373291
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00065112113952637
(99) DESCRIBE `ports` 0.0026850700378418
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00058102607727051
(101) DESCRIBE `ports` 0.0026869773864746
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.0005190372467041
(103) DESCRIBE `ports` 0.0026509761810303
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00065898895263672
(105) DESCRIBE `ports` 0.002586841583252
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00043392181396484
(107) DESCRIBE `ports` 0.00193190574646
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00042605400085449
(109) DESCRIBE `ports` 0.0020501613616943
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.0003821849822998
(111) DESCRIBE `ports` 0.0017399787902832
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00048685073852539
(113) DESCRIBE `ports` 0.00174880027771
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0003819465637207
(115) DESCRIBE `ports` 0.0019490718841553
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00045394897460938
(117) DESCRIBE `ports` 0.0018200874328613
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00041317939758301
(119) DESCRIBE `ports` 0.0019180774688721
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00042915344238281
(121) DESCRIBE `ports` 0.0018260478973389
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00046014785766602
(123) DESCRIBE `ports` 0.0019800662994385
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0004119873046875
(125) DESCRIBE `ports` 0.001924991607666
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0003819465637207
(127) DESCRIBE `ports` 0.0018048286437988
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00043296813964844
(129) DESCRIBE `ports` 0.0017449855804443
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.0003960132598877
(131) DESCRIBE `avid_specials` 0.0015769004821777
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72935 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012679100036621
(133) DESCRIBE `cruiselines` 0.0025529861450195
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0004119873046875
(135) DESCRIBE `orchid_image` 0.0019941329956055
(136) DESCRIBE `cruiselines` 0.0039269924163818
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00043106079101562
(138) DESCRIBE `cruises` 0.0036909580230713
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72914') 0.0004270076751709
(140) DESCRIBE `ships` 0.0048918724060059
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00069785118103027
(142) DESCRIBE `ships` 0.0038712024688721
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00058102607727051
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042581558227539
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040507316589355
(146) DESCRIBE `itineraries` 0.0020260810852051
(147) DESCRIBE `ports` 0.0018620491027832
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043606758117676
(149) DESCRIBE `ports` 0.001971960067749
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00059199333190918
(151) DESCRIBE `ports` 0.0018520355224609
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039100646972656
(153) DESCRIBE `sailingdates` 0.0016410350799561
(154) DESCRIBE `ports` 0.0023748874664307
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043010711669922
(156) DESCRIBE `ports` 0.0019428730010986
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00047802925109863
(158) DESCRIBE `ports` 0.0024709701538086
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00058817863464355
(160) DESCRIBE `ports` 0.0022339820861816
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00038003921508789
(162) DESCRIBE `ports` 0.0023868083953857
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00042414665222168
(164) DESCRIBE `ports` 0.0018680095672607
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0003819465637207
(166) DESCRIBE `ports` 0.0018301010131836
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2419))) 0.0003969669342041
(168) DESCRIBE `ports` 0.0017421245574951
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2419') 0.00037693977355957
(170) DESCRIBE `ports` 0.0021538734436035
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00040316581726074
(172) DESCRIBE `ports` 0.0018298625946045
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00037884712219238
(174) DESCRIBE `ports` 0.002255916595459
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00058889389038086
(176) DESCRIBE `ports` 0.0028650760650635
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.0005640983581543
(178) DESCRIBE `ports` 0.0025269985198975
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00056195259094238
(180) DESCRIBE `ports` 0.0019700527191162
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00041413307189941
(182) DESCRIBE `ports` 0.0017881393432617
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042486190795898
(184) DESCRIBE `ports` 0.0018219947814941
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00046396255493164
(186) DESCRIBE `ports` 0.0020620822906494
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00043892860412598
(188) DESCRIBE `ports` 0.0020391941070557
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00046110153198242
(190) DESCRIBE `ports` 0.0020880699157715
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00042510032653809
(192) DESCRIBE `ports` 0.0020270347595215
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00042915344238281
(194) DESCRIBE `ports` 0.0018560886383057
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3014))) 0.00045514106750488
(196) DESCRIBE `ports` 0.0021231174468994
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3014') 0.00052499771118164
(198) DESCRIBE `ports` 0.0022120475769043
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0004570484161377
(200) DESCRIBE `ports` 0.0020930767059326
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00043392181396484
(202) DESCRIBE `ports` 0.0018479824066162
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00049185752868652
(204) DESCRIBE `ports` 0.0018339157104492
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0003809928894043
(206) DESCRIBE `ports` 0.0018470287322998
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00042009353637695
(208) DESCRIBE `ports` 0.0018720626831055
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00042486190795898
(210) DESCRIBE `ports` 0.0018370151519775
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00044107437133789
(212) DESCRIBE `ports` 0.0017688274383545
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037884712219238
(214) DESCRIBE `avid_specials` 0.0016460418701172
(215) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72914 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001183032989502
(216) DESCRIBE `cruiselines` 0.0026729106903076
(217) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00050997734069824
(218) DESCRIBE `orchid_image` 0.002007007598877
(219) DESCRIBE `cruiselines` 0.0026290416717529
(220) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00037407875061035
(221) DESCRIBE `cruises` 0.0033509731292725
(222) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72806') 0.00038909912109375
(223) DESCRIBE `ships` 0.0034980773925781
(224) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00058412551879883
(225) DESCRIBE `ships` 0.0037682056427002
(226) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00042986869812012
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(228) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047802925109863
(229) DESCRIBE `itineraries` 0.0022470951080322
(230) DESCRIBE `ports` 0.0019059181213379
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005948543548584
(232) DESCRIBE `ports` 0.0019400119781494
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045680999755859
(234) DESCRIBE `ports` 0.0017681121826172
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041484832763672
(236) DESCRIBE `sailingdates` 0.0018041133880615
(237) DESCRIBE `ports` 0.0019910335540771
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047206878662109
(239) DESCRIBE `ports` 0.0018761157989502
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044488906860352
(241) DESCRIBE `ports` 0.0020661354064941
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.0004420280456543
(243) DESCRIBE `ports` 0.0018720626831055
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.0004420280456543
(245) DESCRIBE `ports` 0.0018661022186279
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00042009353637695
(247) DESCRIBE `ports` 0.001917839050293
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00040102005004883
(249) DESCRIBE `ports` 0.0017819404602051
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00040698051452637
(251) DESCRIBE `ports` 0.0019741058349609
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00046300888061523
(253) DESCRIBE `ports` 0.0021779537200928
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00042200088500977
(255) DESCRIBE `ports` 0.0018670558929443
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00037002563476562
(257) DESCRIBE `ports` 0.0019760131835938
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00053095817565918
(259) DESCRIBE `ports` 0.0017569065093994
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040197372436523
(261) DESCRIBE `avid_specials` 0.0015771389007568
(262) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72806 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 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.001309871673584
(263) DESCRIBE `cruiselines` 0.0025238990783691
(264) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00047898292541504
(265) DESCRIBE `orchid_image` 0.0020229816436768
(266) DESCRIBE `cruiselines` 0.0024359226226807
(267) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00037288665771484
(268) DESCRIBE `cruises` 0.003248929977417
(269) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72913') 0.00038409233093262
(270) DESCRIBE `ships` 0.0036289691925049
(271) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00068092346191406
(272) DESCRIBE `ships` 0.0039660930633545
(273) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00061511993408203
(274) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042009353637695
(276) DESCRIBE `itineraries` 0.001884937286377
(277) DESCRIBE `ports` 0.0026309490203857
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0006110668182373
(279) DESCRIBE `ports` 0.0026907920837402
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00060391426086426
(281) DESCRIBE `ports` 0.0025501251220703
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0005340576171875
(283) DESCRIBE `sailingdates` 0.0022900104522705
(284) DESCRIBE `ports` 0.0023579597473145
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00065398216247559
(286) DESCRIBE `ports` 0.0021359920501709
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00049400329589844
(288) DESCRIBE `ports` 0.0018589496612549
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00047898292541504
(290) DESCRIBE `ports` 0.0024099349975586
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00056099891662598
(292) DESCRIBE `ports` 0.0020289421081543
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00043201446533203
(294) DESCRIBE `ports` 0.0017671585083008
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00039076805114746
(296) DESCRIBE `ports` 0.0018689632415771
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2419))) 0.00041913986206055
(298) DESCRIBE `ports` 0.0017728805541992
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2419') 0.00037407875061035
(300) DESCRIBE `ports` 0.0017991065979004
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00039887428283691
(302) DESCRIBE `ports` 0.0017449855804443
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00047898292541504
(304) DESCRIBE `ports` 0.0020959377288818
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00049805641174316
(306) DESCRIBE `ports` 0.0021038055419922
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00039315223693848
(308) DESCRIBE `ports` 0.0020179748535156
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00052189826965332
(310) DESCRIBE `ports` 0.0018208026885986
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00038385391235352
(312) DESCRIBE `ports` 0.0020051002502441
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043296813964844
(314) DESCRIBE `ports` 0.0019428730010986
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00038290023803711
(316) DESCRIBE `avid_specials` 0.0016729831695557
(317) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72913 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011360645294189
(318) DESCRIBE `cruiselines` 0.0025670528411865
(319) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0003969669342041
(320) DESCRIBE `orchid_image` 0.0019400119781494
(321) DESCRIBE `cruiselines` 0.0032591819763184
(322) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00039815902709961
(323) DESCRIBE `cruises` 0.00388503074646
(324) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72868') 0.00057697296142578
(325) DESCRIBE `ships` 0.0036020278930664
(326) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0004429817199707
(327) DESCRIBE `ships` 0.0049550533294678
(328) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.0006110668182373
(329) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052094459533691
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051116943359375
(331) DESCRIBE `itineraries` 0.0026140213012695
(332) DESCRIBE `ports` 0.0025990009307861
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005650520324707
(334) DESCRIBE `ports` 0.0025620460510254
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00071501731872559
(336) DESCRIBE `ports` 0.0030620098114014
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0006110668182373
(338) DESCRIBE `sailingdates` 0.0022449493408203
(339) DESCRIBE `ports` 0.0024151802062988
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005040168762207
(341) DESCRIBE `ports` 0.0017819404602051
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0004279613494873
(343) DESCRIBE `ports` 0.0018599033355713
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00040698051452637
(345) DESCRIBE `ports` 0.002007007598877
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0003809928894043
(347) DESCRIBE `ports` 0.0017437934875488
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00041985511779785
(349) DESCRIBE `ports` 0.0017359256744385
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00042390823364258
(351) DESCRIBE `ports` 0.0017869472503662
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00047206878662109
(353) DESCRIBE `ports` 0.0019018650054932
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00039815902709961
(355) DESCRIBE `ports` 0.0017540454864502
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00040316581726074
(357) DESCRIBE `ports` 0.0017850399017334
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0003809928894043
(359) DESCRIBE `ports` 0.001910924911499
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00052309036254883
(361) DESCRIBE `ports` 0.0018291473388672
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00039482116699219
(363) DESCRIBE `ports` 0.00177001953125
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040292739868164
(365) DESCRIBE `ports` 0.001945972442627
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00045299530029297
(367) DESCRIBE `ports` 0.0018680095672607
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00039815902709961
(369) DESCRIBE `ports` 0.0019130706787109
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00037503242492676
(371) DESCRIBE `ports` 0.0018939971923828
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00041389465332031
(373) DESCRIBE `ports` 0.0017669200897217
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00045180320739746
(375) DESCRIBE `ports` 0.001971960067749
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00039792060852051
(377) DESCRIBE `ports` 0.0017271041870117
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00039482116699219
(379) DESCRIBE `ports` 0.00199294090271
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00055909156799316
(381) DESCRIBE `ports` 0.0018110275268555
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00038814544677734
(383) DESCRIBE `ports` 0.0020360946655273
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043892860412598
(385) DESCRIBE `ports` 0.0018610954284668
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00041985511779785
(387) DESCRIBE `ports` 0.0021591186523438
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00043988227844238
(389) DESCRIBE `ports` 0.0019369125366211
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0003960132598877
(391) DESCRIBE `ports` 0.0023469924926758
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.000579833984375
(393) DESCRIBE `ports` 0.0020580291748047
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00049805641174316
(395) DESCRIBE `avid_specials` 0.0016648769378662
(396) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72868 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012199878692627
(397) DESCRIBE `cruiselines` 0.0026710033416748
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00050497055053711
(399) DESCRIBE `orchid_image` 0.0019469261169434
(400) DESCRIBE `cruiselines` 0.0024969577789307
(401) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00039792060852051
(402) DESCRIBE `cruises` 0.0032958984375
(403) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72884') 0.0003960132598877
(404) DESCRIBE `ships` 0.0040309429168701
(405) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.0005030632019043
(406) DESCRIBE `ships` 0.0087950229644775
(407) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00051593780517578
(408) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036215782165527
(409) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036907196044922
(410) DESCRIBE `itineraries` 0.002000093460083
(411) DESCRIBE `ports` 0.002079963684082
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00049614906311035
(413) DESCRIBE `ports` 0.0019288063049316
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043988227844238
(415) DESCRIBE `ports` 0.0018758773803711
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0004119873046875
(417) DESCRIBE `sailingdates` 0.0017678737640381
(418) DESCRIBE `ports` 0.0017650127410889
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00048613548278809
(420) DESCRIBE `ports` 0.0017781257629395
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00049281120300293
(422) DESCRIBE `ports` 0.0017960071563721
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00042009353637695
(424) DESCRIBE `ports` 0.0020599365234375
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00040602684020996
(426) DESCRIBE `ports` 0.0017890930175781
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00044083595275879
(428) DESCRIBE `ports` 0.0018560886383057
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00049495697021484
(430) DESCRIBE `ports` 0.0019159317016602
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042104721069336
(432) DESCRIBE `ports` 0.0021240711212158
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00043201446533203
(434) DESCRIBE `ports` 0.0019760131835938
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00043511390686035
(436) DESCRIBE `ports` 0.0017709732055664
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00045919418334961
(438) DESCRIBE `ports` 0.0018148422241211
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00062203407287598
(440) DESCRIBE `ports` 0.0017728805541992
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00038480758666992
(442) DESCRIBE `ports` 0.0021989345550537
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.0004889965057373
(444) DESCRIBE `ports` 0.0018548965454102
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00037097930908203
(446) DESCRIBE `ports` 0.0018138885498047
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00045299530029297
(448) DESCRIBE `ports` 0.0020310878753662
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00046300888061523
(450) DESCRIBE `ports` 0.0019600391387939
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042915344238281
(452) DESCRIBE `ports` 0.0018479824066162
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038599967956543
(454) DESCRIBE `ports` 0.0018248558044434
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005030632019043
(456) DESCRIBE `ports` 0.0018308162689209
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038599967956543
(458) DESCRIBE `avid_specials` 0.0015509128570557
(459) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72884 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015261173248291
(460) DESCRIBE `cruiselines` 0.0026388168334961
(461) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00043487548828125
(462) DESCRIBE `orchid_image` 0.0019979476928711
(463) DESCRIBE `cruiselines` 0.0031599998474121
(464) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00043416023254395
(465) DESCRIBE `cruises` 0.0035099983215332
(466) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72867') 0.00041699409484863
(467) DESCRIBE `ships` 0.0036511421203613
(468) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00049686431884766
(469) DESCRIBE `ships` 0.0038449764251709
(470) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.0004570484161377
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036811828613281
(472) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042200088500977
(473) DESCRIBE `itineraries` 0.0017869472503662
(474) DESCRIBE `ports` 0.0019471645355225
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005340576171875
(476) DESCRIBE `ports` 0.0017769336700439
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004279613494873
(478) DESCRIBE `ports` 0.0020020008087158
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037908554077148
(480) DESCRIBE `sailingdates` 0.0017328262329102
(481) DESCRIBE `ports` 0.0027499198913574
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044894218444824
(483) DESCRIBE `ports` 0.0017621517181396
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039410591125488
(485) DESCRIBE `ports` 0.0018808841705322
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00042295455932617
(487) DESCRIBE `ports` 0.0018939971923828
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00042390823364258
(489) DESCRIBE `ports` 0.0019400119781494
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00060200691223145
(491) DESCRIBE `ports` 0.0018470287322998
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00044608116149902
(493) DESCRIBE `ports` 0.0019841194152832
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00049710273742676
(495) DESCRIBE `ports` 0.0018041133880615
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00052404403686523
(497) DESCRIBE `ports` 0.0018579959869385
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00043010711669922
(499) DESCRIBE `ports` 0.00205397605896
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00046300888061523
(501) DESCRIBE `ports` 0.0019180774688721
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00052618980407715
(503) DESCRIBE `ports` 0.0018289089202881
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00042104721069336
(505) DESCRIBE `ports` 0.001924991607666
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046086311340332
(507) DESCRIBE `ports` 0.0018351078033447
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040102005004883
(509) DESCRIBE `avid_specials` 0.0017409324645996
(510) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72867 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011389255523682
(511) DESCRIBE `cruiselines` 0.0025770664215088
(512) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00047707557678223
(513) DESCRIBE `orchid_image` 0.0021038055419922
(514) DESCRIBE `cruiselines` 0.0027990341186523
(515) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00053906440734863
(516) DESCRIBE `cruises` 0.0034570693969727
(517) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72937') 0.0005340576171875
(518) DESCRIBE `ships` 0.0035507678985596
(519) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00052309036254883
(520) DESCRIBE `ships` 0.0035250186920166
(521) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00039196014404297
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041103363037109
(524) DESCRIBE `itineraries` 0.0027570724487305
(525) DESCRIBE `ports` 0.0024068355560303
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00059199333190918
(527) DESCRIBE `ports` 0.0018579959869385
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00042986869812012
(529) DESCRIBE `ports` 0.0020661354064941
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00046992301940918
(531) DESCRIBE `sailingdates` 0.001615047454834
(532) DESCRIBE `ports` 0.0023000240325928
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00047421455383301
(534) DESCRIBE `ports` 0.0018100738525391
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00041580200195312
(536) DESCRIBE `ports` 0.0017569065093994
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00043988227844238
(538) DESCRIBE `ports` 0.0019049644470215
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00038290023803711
(540) DESCRIBE `ports` 0.0018010139465332
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00047683715820312
(542) DESCRIBE `ports` 0.0020110607147217
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00039386749267578
(544) DESCRIBE `ports` 0.0019688606262207
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.00048995018005371
(546) DESCRIBE `ports` 0.0019378662109375
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.00047802925109863
(548) DESCRIBE `ports` 0.001967191696167
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00041484832763672
(550) DESCRIBE `ports` 0.0018229484558105
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00047421455383301
(552) DESCRIBE `ports` 0.0018711090087891
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00048398971557617
(554) DESCRIBE `ports` 0.0022509098052979
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00040316581726074
(556) DESCRIBE `ports` 0.0018839836120605
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.0005638599395752
(558) DESCRIBE `ports` 0.001823902130127
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00042200088500977
(560) DESCRIBE `ports` 0.0018720626831055
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 126))) 0.00047087669372559
(562) DESCRIBE `ports` 0.0019569396972656
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '126') 0.00049805641174316
(564) DESCRIBE `ports` 0.0018341541290283
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00047087669372559
(566) DESCRIBE `ports` 0.0018188953399658
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.0003969669342041
(568) DESCRIBE `ports` 0.0023849010467529
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00047397613525391
(570) DESCRIBE `ports` 0.0018570423126221
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00039482116699219
(572) DESCRIBE `ports` 0.0020408630371094
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00041699409484863
(574) DESCRIBE `ports` 0.0018880367279053
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00039911270141602
(576) DESCRIBE `ports` 0.0021350383758545
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00050902366638184
(578) DESCRIBE `ports` 0.0019040107727051
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00042605400085449
(580) DESCRIBE `ports` 0.0018458366394043
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00042104721069336
(582) DESCRIBE `ports` 0.0023138523101807
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00041103363037109
(584) DESCRIBE `ports` 0.0019798278808594
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044512748718262
(586) DESCRIBE `ports` 0.0020530223846436
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043606758117676
(588) DESCRIBE `avid_specials` 0.0016758441925049
(589) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72937 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012340545654297
(590) DESCRIBE `cruiselines` 0.0025899410247803
(591) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00046801567077637
(592) DESCRIBE `orchid_image` 0.0020442008972168
(593) DESCRIBE `cruiselines` 0.0028269290924072
(594) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00053215026855469
(595) DESCRIBE `cruises` 0.0044369697570801
(596) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85104') 0.00046491622924805
(597) DESCRIBE `ships` 0.0038318634033203
(598) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00073099136352539
(599) DESCRIBE `ships` 0.0037598609924316
(600) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00047683715820312
(601) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035905838012695
(602) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034904479980469
(603) DESCRIBE `itineraries` 0.0018470287322998
(604) DESCRIBE `ports` 0.0021469593048096
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047802925109863
(606) DESCRIBE `ports` 0.0018599033355713
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043988227844238
(608) DESCRIBE `ports` 0.0020871162414551
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042319297790527
(610) DESCRIBE `sailingdates` 0.0022439956665039
(611) DESCRIBE `ports` 0.0020511150360107
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0006098747253418
(613) DESCRIBE `ports` 0.0023179054260254
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042104721069336
(615) DESCRIBE `ports` 0.00187087059021
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00055599212646484
(617) DESCRIBE `ports` 0.0023820400238037
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00061607360839844
(619) DESCRIBE `ports` 0.0028159618377686
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00068283081054688
(621) DESCRIBE `ports` 0.0027480125427246
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00065517425537109
(623) DESCRIBE `ports` 0.0020978450775146
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00044918060302734
(625) DESCRIBE `ports` 0.001863956451416
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00040411949157715
(627) DESCRIBE `ports` 0.001939058303833
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00045895576477051
(629) DESCRIBE `ports` 0.0018830299377441
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00044798851013184
(631) DESCRIBE `ports` 0.0018088817596436
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00041985511779785
(633) DESCRIBE `ports` 0.0021510124206543
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00039505958557129
(635) DESCRIBE `ports` 0.0018868446350098
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00041294097900391
(637) DESCRIBE `ports` 0.0018870830535889
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00040888786315918
(639) DESCRIBE `ports` 0.0017850399017334
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052213668823242
(641) DESCRIBE `ports` 0.0018610954284668
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040006637573242
(643) DESCRIBE `avid_specials` 0.0016350746154785
(644) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 85104 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 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.0013320446014404
(645) DESCRIBE `cruiselines` 0.0026679039001465
(646) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00061798095703125
(647) DESCRIBE `orchid_image` 0.0025999546051025
(648) DESCRIBE `cruiselines` 0.0029220581054688
(649) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00053191184997559
(650) DESCRIBE `ships` 0.0041379928588867
(651) SELECT `ships`.* FROM `ships` WHERE (id IN ('850', '966', '1319', '508', '1108', '394')) ORDER BY FIND_IN_SET(id, '850,966,1319,508,1108,394') 0.0014450550079346
(652) DESCRIBE `cruisetypes` 0.0017812252044678
(653) DESCRIBE `destinations` 0.0024359226226807
(654) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '26', '38', '37', '2', '43', '35', '28', '21', '11', '45', '48', '49', '8', '30', '10', '52', '25', '34', '32', '55')) ORDER BY FIND_IN_SET(id, '22,12,40,26,38,37,2,43,35,28,21,11,45,48,49,8,30,10,52,25,34,32,55') 0.0023360252380371
(655) DESCRIBE `cruiselines` 0.003403902053833
(656) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00057196617126465
(657) DESCRIBE `cruiselines` 0.0033891201019287
(658) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00044608116149902