or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 0.75780940055847

# Query Time
(1) connect 0.0014779567718506
(2) DESCRIBE `cruises` 0.0039329528808594
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67820, 69695, 69340, 69467, 69694, 72570, 63244, 69311, 69468, 63243)) ORDER BY FIND_IN_SET(id, '67820,69695,69340,69467,69694,72570,63244,69311,69468,63243') 0.0061120986938477
(4) DESCRIBE `cruises` 0.01765513420105
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67820') 0.00049495697021484
(6) DESCRIBE `ships` 0.0041408538818359
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00070500373840332
(8) DESCRIBE `ships` 0.0035879611968994
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00049614906311035
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033116340637207
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00059199333190918
(12) DESCRIBE `itineraries` 0.0018210411071777
(13) DESCRIBE `ports` 0.0020830631256104
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00048017501831055
(15) DESCRIBE `ports` 0.001924991607666
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00041508674621582
(17) DESCRIBE `ports` 0.0018439292907715
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00038409233093262
(19) DESCRIBE `sailingdates` 0.0015530586242676
(20) DESCRIBE `ports` 0.0022058486938477
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00041913986206055
(22) DESCRIBE `ports` 0.0020110607147217
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00038599967956543
(24) DESCRIBE `ports` 0.001755952835083
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00040793418884277
(26) DESCRIBE `ports` 0.001755952835083
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00036096572875977
(28) DESCRIBE `ports` 0.0017349720001221
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00040698051452637
(30) DESCRIBE `ports` 0.0023059844970703
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00060391426086426
(32) DESCRIBE `ports` 0.0027542114257812
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.0005030632019043
(34) DESCRIBE `ports` 0.0017569065093994
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00046396255493164
(36) DESCRIBE `ports` 0.0015048980712891
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00048995018005371
(38) DESCRIBE `ports` 0.0023281574249268
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00063300132751465
(40) DESCRIBE `ports` 0.0022659301757812
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00058603286743164
(42) DESCRIBE `ports` 0.0022728443145752
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00048494338989258
(44) DESCRIBE `avid_specials` 0.0017869472503662
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67820 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 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.0015239715576172
(46) DESCRIBE `cruiselines` 0.0028350353240967
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00058293342590332
(48) DESCRIBE `orchid_image` 0.00242018699646
(49) DESCRIBE `cruiselines` 0.0031769275665283
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00050997734069824
(51) DESCRIBE `cruises` 0.0041978359222412
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69695') 0.00076389312744141
(53) DESCRIBE `ships` 0.0048410892486572
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00059199333190918
(55) DESCRIBE `ships` 0.0040261745452881
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00083398818969727
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00077605247497559
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034713745117188
(59) DESCRIBE `itineraries` 0.0019369125366211
(60) DESCRIBE `ports` 0.0019760131835938
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00057005882263184
(62) DESCRIBE `ports` 0.0019879341125488
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00053000450134277
(64) DESCRIBE `ports` 0.0019450187683105
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00052404403686523
(66) DESCRIBE `sailingdates` 0.0017240047454834
(67) DESCRIBE `ports` 0.002295970916748
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00051784515380859
(69) DESCRIBE `ports` 0.0025968551635742
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00056695938110352
(71) DESCRIBE `ports` 0.0023298263549805
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00051498413085938
(73) DESCRIBE `ports` 0.0019640922546387
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00049495697021484
(75) DESCRIBE `ports` 0.0019938945770264
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0006721019744873
(77) DESCRIBE `ports` 0.0027410984039307
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.0020899772644043
(79) DESCRIBE `ports` 0.0033571720123291
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00058197975158691
(81) DESCRIBE `ports` 0.0026679039001465
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00078797340393066
(83) DESCRIBE `ports` 0.0024409294128418
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00057792663574219
(85) DESCRIBE `ports` 0.0026638507843018
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00060510635375977
(87) DESCRIBE `ports` 0.0021049976348877
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00054597854614258
(89) DESCRIBE `ports` 0.0019919872283936
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00041604042053223
(91) DESCRIBE `ports` 0.0018360614776611
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00049090385437012
(93) DESCRIBE `ports` 0.0018758773803711
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00046706199645996
(95) DESCRIBE `ports` 0.0019519329071045
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00050187110900879
(97) DESCRIBE `ports` 0.0019209384918213
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.0004730224609375
(99) DESCRIBE `ports` 0.0020120143890381
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00053000450134277
(101) DESCRIBE `ports` 0.0024049282073975
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00048208236694336
(103) DESCRIBE `ports` 0.001835823059082
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00064611434936523
(105) DESCRIBE `ports` 0.0022470951080322
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00048494338989258
(107) DESCRIBE `avid_specials` 0.0019888877868652
(108) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69695 and class = 'Cruise') OR (item_id = 434 AND class = 'Ship') OR (item_id = 23 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.0017580986022949
(109) DESCRIBE `cruiselines` 0.0028190612792969
(110) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00062084197998047
(111) DESCRIBE `orchid_image` 0.0022640228271484
(112) DESCRIBE `cruiselines` 0.0030529499053955
(113) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00052404403686523
(114) DESCRIBE `cruises` 0.0030150413513184
(115) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69340') 0.00049304962158203
(116) DESCRIBE `ships` 0.0030062198638916
(117) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00046992301940918
(118) DESCRIBE `ships` 0.0041079521179199
(119) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00056791305541992
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003361701965332
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(122) DESCRIBE `itineraries` 0.0018858909606934
(123) DESCRIBE `ports` 0.0018491744995117
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043797492980957
(125) DESCRIBE `ports` 0.0019261837005615
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043296813964844
(127) DESCRIBE `ports` 0.0017478466033936
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039291381835938
(129) DESCRIBE `sailingdates` 0.0015289783477783
(130) DESCRIBE `ports` 0.0019781589508057
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047206878662109
(132) DESCRIBE `ports` 0.0018448829650879
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041985511779785
(134) DESCRIBE `ports` 0.0018620491027832
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044703483581543
(136) DESCRIBE `ports` 0.0017008781433105
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00031590461730957
(138) DESCRIBE `ports` 0.0018470287322998
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00044012069702148
(140) DESCRIBE `ports` 0.0018649101257324
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00041913986206055
(142) DESCRIBE `ports` 0.0016160011291504
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00043678283691406
(144) DESCRIBE `ports` 0.0016269683837891
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00038313865661621
(146) DESCRIBE `ports` 0.0015878677368164
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00041484832763672
(148) DESCRIBE `ports` 0.0018420219421387
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00039505958557129
(150) DESCRIBE `ports` 0.0017848014831543
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00049901008605957
(152) DESCRIBE `ports` 0.0018668174743652
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00040197372436523
(154) DESCRIBE `ports` 0.0013689994812012
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003659725189209
(156) DESCRIBE `ports` 0.0017030239105225
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034308433532715
(158) DESCRIBE `avid_specials` 0.0013549327850342
(159) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69340 and class = 'Cruise') OR (item_id = 105 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 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.0013549327850342
(160) DESCRIBE `cruiselines` 0.0022950172424316
(161) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0004429817199707
(162) DESCRIBE `orchid_image` 0.0018529891967773
(163) DESCRIBE `cruiselines` 0.0025999546051025
(164) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00061702728271484
(165) DESCRIBE `cruises` 0.0037310123443604
(166) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69467') 0.00049281120300293
(167) DESCRIBE `ships` 0.0039260387420654
(168) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00046992301940918
(169) DESCRIBE `ships` 0.04106616973877
(170) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00058102607727051
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037097930908203
(172) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(173) DESCRIBE `itineraries` 0.0020039081573486
(174) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69467') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010020732879639
(175) DESCRIBE `ports` 0.002133846282959
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.0004889965057373
(177) DESCRIBE `ports` 0.0018119812011719
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00043582916259766
(179) DESCRIBE `ports` 0.0019199848175049
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00046205520629883
(181) DESCRIBE `sailingdates` 0.0016341209411621
(182) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69467') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010108947753906
(183) DESCRIBE `ports` 0.00199294090271
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00047588348388672
(185) DESCRIBE `ports` 0.0019528865814209
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00034117698669434
(187) DESCRIBE `ports` 0.0015878677368164
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00038409233093262
(189) DESCRIBE `ports` 0.0015161037445068
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00035285949707031
(191) DESCRIBE `ports` 0.0019421577453613
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00048398971557617
(193) DESCRIBE `ports` 0.0017578601837158
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00048208236694336
(195) DESCRIBE `ports` 0.0017189979553223
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00042510032653809
(197) DESCRIBE `ports` 0.0016458034515381
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00043392181396484
(199) DESCRIBE `ports` 0.0014989376068115
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00046992301940918
(201) DESCRIBE `ports` 0.0016529560089111
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00040912628173828
(203) DESCRIBE `ports` 0.0015518665313721
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00043201446533203
(205) DESCRIBE `ports` 0.0017290115356445
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00050806999206543
(207) DESCRIBE `avid_specials` 0.0017590522766113
(208) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69467 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 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.0015480518341064
(209) DESCRIBE `cruiselines` 0.0029621124267578
(210) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00055289268493652
(211) DESCRIBE `orchid_image` 0.0019938945770264
(212) DESCRIBE `cruiselines` 0.0025219917297363
(213) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00048017501831055
(214) DESCRIBE `cruises` 0.0036470890045166
(215) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69694') 0.00057005882263184
(216) DESCRIBE `ships` 0.0041189193725586
(217) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00055909156799316
(218) DESCRIBE `ships` 0.0034949779510498
(219) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00046801567077637
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(221) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037813186645508
(222) DESCRIBE `itineraries` 0.0020549297332764
(223) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69694') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010299682617188
(224) DESCRIBE `ports` 0.0023341178894043
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00057721138000488
(226) DESCRIBE `ports` 0.0021300315856934
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00067615509033203
(228) DESCRIBE `ports` 0.002208948135376
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00049304962158203
(230) DESCRIBE `sailingdates` 0.0017259120941162
(231) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69694') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011439323425293
(232) DESCRIBE `ports` 0.0024120807647705
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00056910514831543
(234) DESCRIBE `ports` 0.002126932144165
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00044608116149902
(236) DESCRIBE `ports` 0.0020620822906494
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00048589706420898
(238) DESCRIBE `ports` 0.0020780563354492
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.0003821849822998
(240) DESCRIBE `ports` 0.0019149780273438
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00037312507629395
(242) DESCRIBE `ports` 0.0016508102416992
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00039100646972656
(244) DESCRIBE `ports` 0.0016980171203613
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00043201446533203
(246) DESCRIBE `ports` 0.0017900466918945
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00035214424133301
(248) DESCRIBE `ports` 0.0013699531555176
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037789344787598
(250) DESCRIBE `ports` 0.0017609596252441
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00041794776916504
(252) DESCRIBE `avid_specials` 0.0012240409851074
(253) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69694 and class = 'Cruise') OR (item_id = 434 AND class = 'Ship') OR (item_id = 23 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.0011289119720459
(254) DESCRIBE `cruiselines` 0.0021231174468994
(255) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00048708915710449
(256) DESCRIBE `orchid_image` 0.0018260478973389
(257) DESCRIBE `cruiselines` 0.0021970272064209
(258) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0004580020904541
(259) DESCRIBE `cruises` 0.002964973449707
(260) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72570') 0.00059700012207031
(261) DESCRIBE `ships` 0.003169059753418
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 580))) 0.00043821334838867
(263) DESCRIBE `ships` 0.002918004989624
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '580') 0.00035405158996582
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(267) DESCRIBE `itineraries` 0.0013489723205566
(268) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72570') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066113471984863
(269) DESCRIBE `ports` 0.0014760494232178
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00035715103149414
(271) DESCRIBE `ports` 0.0014040470123291
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00049304962158203
(273) DESCRIBE `ports` 0.002018928527832
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00049805641174316
(275) DESCRIBE `sailingdates` 0.0014290809631348
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72570') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.000885009765625
(277) DESCRIBE `ports` 0.0022149085998535
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00048708915710449
(279) DESCRIBE `ports` 0.0019679069519043
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0004570484161377
(281) DESCRIBE `ports` 0.0021929740905762
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00050497055053711
(283) DESCRIBE `ports` 0.0015339851379395
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00033211708068848
(285) DESCRIBE `ports` 0.0013799667358398
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00040602684020996
(287) DESCRIBE `ports` 0.0016119480133057
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0003209114074707
(289) DESCRIBE `ports` 0.0013890266418457
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00040888786315918
(291) DESCRIBE `ports` 0.0016481876373291
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00039482116699219
(293) DESCRIBE `ports` 0.0015640258789062
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00034689903259277
(295) DESCRIBE `ports` 0.0016729831695557
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00040602684020996
(297) DESCRIBE `ports` 0.0015890598297119
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00034189224243164
(299) DESCRIBE `ports` 0.0017809867858887
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00051593780517578
(301) DESCRIBE `ports` 0.0019111633300781
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00059199333190918
(303) DESCRIBE `ports` 0.001755952835083
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00039100646972656
(305) DESCRIBE `avid_specials` 0.0013480186462402
(306) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72570 and class = 'Cruise') OR (item_id = 580 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 29 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.0012128353118896
(307) DESCRIBE `cruiselines` 0.0022327899932861
(308) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00040793418884277
(309) DESCRIBE `orchid_image` 0.0015580654144287
(310) DESCRIBE `cruiselines` 0.0018351078033447
(311) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00036406517028809
(312) DESCRIBE `cruises` 0.0029659271240234
(313) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63244') 0.0005040168762207
(314) DESCRIBE `ships` 0.0038249492645264
(315) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00063920021057129
(316) DESCRIBE `ships` 0.0038909912109375
(317) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00055313110351562
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029301643371582
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027704238891602
(320) DESCRIBE `itineraries` 0.0015568733215332
(321) DESCRIBE `ports` 0.001410961151123
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00040793418884277
(323) DESCRIBE `ports` 0.0015459060668945
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00031900405883789
(325) DESCRIBE `ports` 0.0014159679412842
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00035905838012695
(327) DESCRIBE `sailingdates` 0.001270055770874
(328) DESCRIBE `ports` 0.0016670227050781
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044894218444824
(330) DESCRIBE `ports` 0.0016541481018066
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00030279159545898
(332) DESCRIBE `ports` 0.0014560222625732
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00032305717468262
(334) DESCRIBE `ports` 0.0013527870178223
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00030398368835449
(336) DESCRIBE `ports` 0.0015909671783447
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00029611587524414
(338) DESCRIBE `ports` 0.0013558864593506
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00031399726867676
(340) DESCRIBE `ports` 0.0014369487762451
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00035691261291504
(342) DESCRIBE `ports` 0.001533031463623
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00031208992004395
(344) DESCRIBE `ports` 0.001352071762085
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00038409233093262
(346) DESCRIBE `ports` 0.0014660358428955
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00036096572875977
(348) DESCRIBE `ports` 0.0013160705566406
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030899047851562
(350) DESCRIBE `ports` 0.0013308525085449
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00029683113098145
(352) DESCRIBE `ports` 0.0013279914855957
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00032210350036621
(354) DESCRIBE `ports` 0.0013720989227295
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00029897689819336
(356) DESCRIBE `ports` 0.0012960433959961
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00030994415283203
(358) DESCRIBE `ports` 0.0013749599456787
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00029587745666504
(360) DESCRIBE `ports` 0.0021939277648926
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.0005030632019043
(362) DESCRIBE `ports` 0.0019588470458984
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00039315223693848
(364) DESCRIBE `ports` 0.0018491744995117
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00049805641174316
(366) DESCRIBE `ports` 0.0018990039825439
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043606758117676
(368) DESCRIBE `avid_specials` 0.0016500949859619
(369) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63244 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 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.0017070770263672
(370) DESCRIBE `cruiselines` 0.0026538372039795
(371) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00050210952758789
(372) DESCRIBE `orchid_image` 0.0023128986358643
(373) DESCRIBE `cruiselines` 0.0023849010467529
(374) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00038409233093262
(375) DESCRIBE `cruises` 0.0029730796813965
(376) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69311') 0.00054597854614258
(377) DESCRIBE `ships` 0.0032768249511719
(378) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.0004889965057373
(379) DESCRIBE `ships` 0.00331711769104
(380) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00042414665222168
(381) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026082992553711
(383) DESCRIBE `itineraries` 0.0016701221466064
(384) DESCRIBE `ports` 0.0017848014831543
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00039505958557129
(386) DESCRIBE `ports` 0.0016791820526123
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047206878662109
(388) DESCRIBE `ports` 0.0014770030975342
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00034403800964355
(390) DESCRIBE `sailingdates` 0.0012879371643066
(391) DESCRIBE `ports` 0.0017950534820557
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00037288665771484
(393) DESCRIBE `ports` 0.0015430450439453
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037097930908203
(395) DESCRIBE `ports` 0.0013771057128906
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00034689903259277
(397) DESCRIBE `ports` 0.0015521049499512
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00038599967956543
(399) DESCRIBE `ports` 0.0018188953399658
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0004570484161377
(401) DESCRIBE `ports` 0.0018389225006104
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00042200088500977
(403) DESCRIBE `ports` 0.0018739700317383
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00051403045654297
(405) DESCRIBE `ports` 0.0019268989562988
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00045514106750488
(407) DESCRIBE `ports` 0.0019469261169434
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0004878044128418
(409) DESCRIBE `ports` 0.0019059181213379
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00049304962158203
(411) DESCRIBE `ports` 0.0021629333496094
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00051999092102051
(413) DESCRIBE `ports` 0.0019829273223877
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00050711631774902
(415) DESCRIBE `ports` 0.0017988681793213
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00044918060302734
(417) DESCRIBE `ports` 0.0015039443969727
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00036096572875977
(419) DESCRIBE `ports` 0.0014491081237793
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00039410591125488
(421) DESCRIBE `ports` 0.0017390251159668
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034189224243164
(423) DESCRIBE `ports` 0.0014059543609619
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041484832763672
(425) DESCRIBE `ports` 0.0016579627990723
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00046300888061523
(427) DESCRIBE `avid_specials` 0.0014970302581787
(428) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69311 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 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.0014369487762451
(429) DESCRIBE `cruiselines` 0.0024800300598145
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00052595138549805
(431) DESCRIBE `orchid_image` 0.0017051696777344
(432) DESCRIBE `cruiselines` 0.0024209022521973
(433) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00050187110900879
(434) DESCRIBE `cruises` 0.0034360885620117
(435) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69468') 0.00051188468933105
(436) DESCRIBE `ships` 0.0032880306243896
(437) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00055694580078125
(438) DESCRIBE `ships` 0.0032329559326172
(439) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00049495697021484
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031685829162598
(441) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002601146697998
(442) DESCRIBE `itineraries` 0.0017299652099609
(443) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69468') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063586235046387
(444) DESCRIBE `ports` 0.0023031234741211
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00050806999206543
(446) DESCRIBE `ports` 0.0023770332336426
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00059819221496582
(448) DESCRIBE `ports` 0.0021209716796875
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.0007321834564209
(450) DESCRIBE `sailingdates` 0.0017960071563721
(451) DESCRIBE `ports` 0.0020041465759277
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00049686431884766
(453) DESCRIBE `ports` 0.0018520355224609
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00053095817565918
(455) DESCRIBE `ports` 0.0017740726470947
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00052499771118164
(457) DESCRIBE `ports` 0.0017950534820557
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00042295455932617
(459) DESCRIBE `ports` 0.00177001953125
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00048112869262695
(461) DESCRIBE `ports` 0.0018320083618164
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00041079521179199
(463) DESCRIBE `ports` 0.0017678737640381
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00040888786315918
(465) DESCRIBE `ports` 0.0017220973968506
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.0003969669342041
(467) DESCRIBE `ports` 0.0016498565673828
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00047993659973145
(469) DESCRIBE `ports` 0.0019330978393555
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00043106079101562
(471) DESCRIBE `ports` 0.0019469261169434
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00050497055053711
(473) DESCRIBE `ports` 0.0019259452819824
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00043702125549316
(475) DESCRIBE `avid_specials` 0.0016870498657227
(476) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69468 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 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.0018930435180664
(477) DESCRIBE `cruiselines` 0.0028290748596191
(478) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00063800811767578
(479) DESCRIBE `orchid_image` 0.0022749900817871
(480) DESCRIBE `cruiselines` 0.0028300285339355
(481) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0004119873046875
(482) DESCRIBE `cruises` 0.0042128562927246
(483) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63243') 0.00051212310791016
(484) DESCRIBE `ships` 0.0039079189300537
(485) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00063896179199219
(486) DESCRIBE `ships` 0.0039279460906982
(487) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.0005650520324707
(488) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034403800964355
(489) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(490) DESCRIBE `itineraries` 0.0018990039825439
(491) DESCRIBE `ports` 0.0019898414611816
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00053787231445312
(493) DESCRIBE `ports` 0.0020029544830322
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00062012672424316
(495) DESCRIBE `ports` 0.0018789768218994
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00035619735717773
(497) DESCRIBE `sailingdates` 0.0012550354003906
(498) DESCRIBE `ports` 0.0017201900482178
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00036191940307617
(500) DESCRIBE `ports` 0.0014300346374512
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00030899047851562
(502) DESCRIBE `ports` 0.0013139247894287
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0004270076751709
(504) DESCRIBE `ports` 0.0014290809631348
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00030016899108887
(506) DESCRIBE `ports` 0.0015168190002441
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00036001205444336
(508) DESCRIBE `ports` 0.0018432140350342
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00030183792114258
(510) DESCRIBE `ports` 0.0013000965118408
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00035715103149414
(512) DESCRIBE `ports` 0.0015509128570557
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00039410591125488
(514) DESCRIBE `ports` 0.0015280246734619
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00033402442932129
(516) DESCRIBE `ports` 0.0015509128570557
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00032591819763184
(518) DESCRIBE `ports` 0.0017368793487549
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030016899108887
(520) DESCRIBE `ports` 0.0012807846069336
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002751350402832
(522) DESCRIBE `avid_specials` 0.0011360645294189
(523) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63243 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 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.0011441707611084
(524) DESCRIBE `cruiselines` 0.0020139217376709
(525) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00051593780517578
(526) DESCRIBE `orchid_image` 0.0021710395812988
(527) DESCRIBE `cruiselines` 0.0028960704803467
(528) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00049209594726562
(529) DESCRIBE `ships` 0.0035419464111328
(530) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '1135', '542', '580', '1682', '434', '1021', '678', '253', '348', '451', '291', '98', '290', '406', '341', '105', '1766', '1409')) ORDER BY FIND_IN_SET(id, '349,1135,542,580,1682,434,1021,678,253,348,451,291,98,290,406,341,105,1766,1409') 0.0020170211791992
(531) DESCRIBE `cruisetypes` 0.0016069412231445
(532) DESCRIBE `destinations` 0.0018599033355713
(533) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '35', '12', '22', '26', '43', '40', '21', '8', '48', '34', '53', '38', '11', '29', '37', '25', '28', '49', '7', '30', '45')) ORDER BY FIND_IN_SET(id, '2,35,12,22,26,43,40,21,8,48,34,53,38,11,29,37,25,28,49,7,30,45') 0.0018808841705322
(534) DESCRIBE `cruiselines` 0.0029590129852295
(535) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0004880428314209
(536) DESCRIBE `cruiselines` 0.002161979675293
(537) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037693977355957