or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 0.42426872253418

# Query Time
(1) connect 0.00093197822570801
(2) DESCRIBE `cruises` 0.0029830932617188
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62161, 73966, 62158, 67148, 62566, 64368, 62156, 73963, 49919, 62169)) ORDER BY FIND_IN_SET(id, '62161,73966,62158,67148,62566,64368,62156,73963,49919,62169') 0.0012269020080566
(4) DESCRIBE `cruises` 0.0025668144226074
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62161') 0.00029993057250977
(6) DESCRIBE `ships` 0.0025110244750977
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00039100646972656
(8) DESCRIBE `ships` 0.0026328563690186
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00029397010803223
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002601146697998
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00024700164794922
(12) DESCRIBE `itineraries` 0.0012469291687012
(13) DESCRIBE `ports` 0.0013089179992676
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(15) DESCRIBE `ports` 0.00124192237854
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029706954956055
(17) DESCRIBE `ports` 0.0013620853424072
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026893615722656
(19) DESCRIBE `sailingdates` 0.0012030601501465
(20) DESCRIBE `ports` 0.0013089179992676
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(22) DESCRIBE `ports` 0.0012438297271729
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026988983154297
(24) DESCRIBE `ports` 0.0013370513916016
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00028800964355469
(26) DESCRIBE `ports` 0.0013110637664795
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00028419494628906
(28) DESCRIBE `ports` 0.0013670921325684
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034284591674805
(30) DESCRIBE `ports` 0.0015051364898682
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032305717468262
(32) DESCRIBE `avid_specials` 0.0011990070343018
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62161 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0011370182037354
(34) DESCRIBE `cruiselines` 0.0017781257629395
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00031304359436035
(36) DESCRIBE `orchid_image` 0.0014190673828125
(37) DESCRIBE `cruiselines` 0.0019118785858154
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026512145996094
(39) DESCRIBE `cruises` 0.0024030208587646
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73966') 0.0003058910369873
(41) DESCRIBE `ships` 0.0024929046630859
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00033807754516602
(43) DESCRIBE `ships` 0.002593994140625
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00030016899108887
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00030112266540527
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00024986267089844
(47) DESCRIBE `itineraries` 0.00136399269104
(48) DESCRIBE `ports` 0.0013139247894287
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033092498779297
(50) DESCRIBE `ports` 0.0013530254364014
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029683113098145
(52) DESCRIBE `ports` 0.0013928413391113
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0002748966217041
(54) DESCRIBE `sailingdates` 0.0011370182037354
(55) DESCRIBE `ports` 0.0012860298156738
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00038003921508789
(57) DESCRIBE `ports` 0.0020601749420166
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029587745666504
(59) DESCRIBE `ports` 0.0013370513916016
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00034809112548828
(61) DESCRIBE `ports` 0.0012428760528564
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0003058910369873
(63) DESCRIBE `avid_specials` 0.001060962677002
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73966 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0010240077972412
(65) DESCRIBE `cruiselines` 0.0018539428710938
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0003199577331543
(67) DESCRIBE `orchid_image` 0.0013718605041504
(68) DESCRIBE `cruiselines` 0.0017249584197998
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00028300285339355
(70) DESCRIBE `cruises` 0.0025248527526855
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62158') 0.00030899047851562
(72) DESCRIBE `ships` 0.0029618740081787
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00065898895263672
(74) DESCRIBE `ships` 0.0025238990783691
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00041007995605469
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003352165222168
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025486946105957
(78) DESCRIBE `itineraries` 0.0012321472167969
(79) DESCRIBE `ports` 0.0018482208251953
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032305717468262
(81) DESCRIBE `ports` 0.0013351440429688
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029802322387695
(83) DESCRIBE `ports` 0.0012359619140625
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027608871459961
(85) DESCRIBE `sailingdates` 0.0010998249053955
(86) DESCRIBE `ports` 0.0013399124145508
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037908554077148
(88) DESCRIBE `ports` 0.0013189315795898
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034189224243164
(90) DESCRIBE `ports` 0.0016920566558838
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.0004119873046875
(92) DESCRIBE `ports` 0.0017180442810059
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00028300285339355
(94) DESCRIBE `ports` 0.00124192237854
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00031185150146484
(96) DESCRIBE `ports` 0.0012600421905518
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00027894973754883
(98) DESCRIBE `ports` 0.001244068145752
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00029182434082031
(100) DESCRIBE `ports` 0.0012321472167969
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00026893615722656
(102) DESCRIBE `ports` 0.0012578964233398
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032782554626465
(104) DESCRIBE `ports` 0.0012338161468506
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026893615722656
(106) DESCRIBE `avid_specials` 0.0011510848999023
(107) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62158 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0010659694671631
(108) DESCRIBE `cruiselines` 0.0018899440765381
(109) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0003352165222168
(110) DESCRIBE `orchid_image` 0.0014569759368896
(111) DESCRIBE `cruiselines` 0.0018739700317383
(112) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026798248291016
(113) DESCRIBE `cruises` 0.0024769306182861
(114) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67148') 0.0002899169921875
(115) DESCRIBE `ships` 0.0027098655700684
(116) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.0004420280456543
(117) DESCRIBE `ships` 0.0027070045471191
(118) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00030899047851562
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026416778564453
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025200843811035
(121) DESCRIBE `itineraries` 0.0013129711151123
(122) DESCRIBE `ports` 0.0013279914855957
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033903121948242
(124) DESCRIBE `ports` 0.0012669563293457
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030803680419922
(126) DESCRIBE `ports` 0.001255989074707
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027298927307129
(128) DESCRIBE `sailingdates` 0.0011270046234131
(129) DESCRIBE `ports` 0.0012691020965576
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031399726867676
(131) DESCRIBE `ports` 0.0013000965118408
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027203559875488
(133) DESCRIBE `ports` 0.0012631416320801
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1901))) 0.00031399726867676
(135) DESCRIBE `ports` 0.0012969970703125
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1901') 0.00028300285339355
(137) DESCRIBE `ports` 0.0012679100036621
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1902))) 0.00030994415283203
(139) DESCRIBE `ports` 0.001255989074707
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1902') 0.00027108192443848
(141) DESCRIBE `ports` 0.0013079643249512
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00036787986755371
(143) DESCRIBE `ports` 0.0012540817260742
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00026988983154297
(145) DESCRIBE `ports` 0.0012898445129395
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00029802322387695
(147) DESCRIBE `ports` 0.001248836517334
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00028085708618164
(149) DESCRIBE `ports` 0.0013091564178467
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030994415283203
(151) DESCRIBE `ports` 0.001251220703125
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028514862060547
(153) DESCRIBE `avid_specials` 0.001147985458374
(154) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67148 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0010361671447754
(155) DESCRIBE `cruiselines` 0.0018739700317383
(156) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0003199577331543
(157) DESCRIBE `orchid_image` 0.0013890266418457
(158) DESCRIBE `cruiselines` 0.0018160343170166
(159) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00027203559875488
(160) DESCRIBE `cruises` 0.0024771690368652
(161) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62566') 0.00029993057250977
(162) DESCRIBE `ships` 0.0024888515472412
(163) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00040411949157715
(164) DESCRIBE `ships` 0.0025439262390137
(165) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.0002899169921875
(166) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038886070251465
(168) DESCRIBE `itineraries` 0.0014710426330566
(169) DESCRIBE `ports` 0.001270055770874
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00037598609924316
(171) DESCRIBE `ports` 0.0012960433959961
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030994415283203
(173) DESCRIBE `ports` 0.0012960433959961
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027799606323242
(175) DESCRIBE `sailingdates` 0.0011870861053467
(176) DESCRIBE `ports` 0.0013830661773682
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00046706199645996
(178) DESCRIBE `ports` 0.0012719631195068
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00029301643371582
(180) DESCRIBE `ports` 0.0012619495391846
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.0004119873046875
(182) DESCRIBE `ports` 0.0017831325531006
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00041103363037109
(184) DESCRIBE `ports` 0.0014691352844238
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00040197372436523
(186) DESCRIBE `ports` 0.0016570091247559
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00029206275939941
(188) DESCRIBE `avid_specials` 0.0011451244354248
(189) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62566 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0010571479797363
(190) DESCRIBE `cruiselines` 0.0018618106842041
(191) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00033402442932129
(192) DESCRIBE `orchid_image` 0.0014200210571289
(193) DESCRIBE `cruiselines` 0.0019040107727051
(194) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00028300285339355
(195) DESCRIBE `cruises` 0.0026159286499023
(196) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00035810470581055
(197) DESCRIBE `ships` 0.0031681060791016
(198) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00041007995605469
(199) DESCRIBE `ships` 0.0040559768676758
(200) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00041913986206055
(201) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034403800964355
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028204917907715
(203) DESCRIBE `itineraries` 0.0012681484222412
(204) DESCRIBE `ports` 0.0013699531555176
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00033092498779297
(206) DESCRIBE `ports` 0.001439094543457
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043296813964844
(208) DESCRIBE `ports` 0.0012791156768799
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00034403800964355
(210) DESCRIBE `sailingdates` 0.0013628005981445
(211) DESCRIBE `ports` 0.0019049644470215
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043296813964844
(213) DESCRIBE `ports` 0.0016398429870605
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00030303001403809
(215) DESCRIBE `ports` 0.0013260841369629
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031805038452148
(217) DESCRIBE `ports` 0.0013468265533447
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00029397010803223
(219) DESCRIBE `ports` 0.0012750625610352
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00033903121948242
(221) DESCRIBE `ports` 0.00154709815979
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00029802322387695
(223) DESCRIBE `ports` 0.0014228820800781
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 8.6069107055664E-5
(225) DESCRIBE `ports` 0.0012829303741455
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00028800964355469
(227) DESCRIBE `ports` 0.0015230178833008
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030899047851562
(229) DESCRIBE `ports` 0.0012650489807129
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027203559875488
(231) DESCRIBE `avid_specials` 0.0010001659393311
(232) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0010640621185303
(233) DESCRIBE `cruiselines` 0.0020182132720947
(234) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00032901763916016
(235) DESCRIBE `orchid_image` 0.001446008682251
(236) DESCRIBE `cruiselines` 0.0018389225006104
(237) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00037693977355957
(238) DESCRIBE `cruises` 0.0032618045806885
(239) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62156') 0.00035905838012695
(240) DESCRIBE `ships` 0.0026748180389404
(241) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.0004429817199707
(242) DESCRIBE `ships` 0.0029799938201904
(243) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00038504600524902
(244) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00029778480529785
(245) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00029993057250977
(246) DESCRIBE `itineraries` 0.0016441345214844
(247) DESCRIBE `ports` 0.0015380382537842
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032687187194824
(249) DESCRIBE `ports` 0.0014731884002686
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038504600524902
(251) DESCRIBE `ports` 0.0015220642089844
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027799606323242
(253) DESCRIBE `sailingdates` 0.0014679431915283
(254) DESCRIBE `ports` 0.0012919902801514
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033092498779297
(256) DESCRIBE `ports` 0.0015170574188232
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028705596923828
(258) DESCRIBE `ports` 0.0013408660888672
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031113624572754
(260) DESCRIBE `ports` 0.0013141632080078
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027108192443848
(262) DESCRIBE `avid_specials` 0.0011529922485352
(263) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62156 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0010080337524414
(264) DESCRIBE `cruiselines` 0.0018210411071777
(265) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0003211498260498
(266) DESCRIBE `orchid_image` 0.00142502784729
(267) DESCRIBE `cruiselines` 0.0019698143005371
(268) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026798248291016
(269) DESCRIBE `cruises` 0.0026021003723145
(270) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73963') 0.00017714500427246
(271) DESCRIBE `ships` 0.0038909912109375
(272) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00053906440734863
(273) DESCRIBE `ships` 0.0036730766296387
(274) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00030303001403809
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00030517578125
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025296211242676
(277) DESCRIBE `itineraries` 0.0013079643249512
(278) DESCRIBE `ports` 0.0013320446014404
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033092498779297
(280) DESCRIBE `ports` 0.0015850067138672
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00037789344787598
(282) DESCRIBE `ports` 0.0013611316680908
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031900405883789
(284) DESCRIBE `sailingdates` 0.0011780261993408
(285) DESCRIBE `ports` 0.0013620853424072
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032806396484375
(287) DESCRIBE `ports` 0.0013041496276855
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028681755065918
(289) DESCRIBE `ports` 0.0012810230255127
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00029993057250977
(291) DESCRIBE `ports` 0.0017259120941162
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00028300285339355
(293) DESCRIBE `ports` 0.0014410018920898
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00032901763916016
(295) DESCRIBE `ports` 0.0014150142669678
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028181076049805
(297) DESCRIBE `ports` 0.0012471675872803
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00031399726867676
(299) DESCRIBE `ports` 0.0013139247894287
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00027084350585938
(301) DESCRIBE `ports` 0.0016939640045166
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00048184394836426
(303) DESCRIBE `ports` 0.0014848709106445
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028491020202637
(305) DESCRIBE `avid_specials` 0.0011940002441406
(306) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73963 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0010600090026855
(307) DESCRIBE `cruiselines` 0.0019500255584717
(308) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00033807754516602
(309) DESCRIBE `orchid_image` 0.001276969909668
(310) DESCRIBE `cruiselines` 0.0023679733276367
(311) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00029206275939941
(312) DESCRIBE `cruises` 0.0031321048736572
(313) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49919') 0.00040888786315918
(314) DESCRIBE `ships` 0.0037379264831543
(315) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.0005180835723877
(316) DESCRIBE `ships` 0.0033879280090332
(317) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00038313865661621
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(320) DESCRIBE `itineraries` 0.0012631416320801
(321) DESCRIBE `ports` 0.0015981197357178
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041317939758301
(323) DESCRIBE `ports` 0.0017261505126953
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041103363037109
(325) DESCRIBE `ports` 0.001291036605835
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028800964355469
(327) DESCRIBE `sailingdates` 0.0011360645294189
(328) DESCRIBE `ports` 0.0013198852539062
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031590461730957
(330) DESCRIBE `ports` 0.0012581348419189
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027108192443848
(332) DESCRIBE `ports` 0.0012807846069336
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00030899047851562
(334) DESCRIBE `ports` 0.0012509822845459
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027799606323242
(336) DESCRIBE `ports` 0.0013108253479004
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 419))) 0.00034689903259277
(338) DESCRIBE `ports` 0.0012509822845459
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '419') 0.00026893615722656
(340) DESCRIBE `ports` 0.0013217926025391
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1044))) 0.00030207633972168
(342) DESCRIBE `ports` 0.0012471675872803
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1044') 0.0002589225769043
(344) DESCRIBE `ports` 0.0013549327850342
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00030899047851562
(346) DESCRIBE `ports` 0.0012679100036621
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00026798248291016
(348) DESCRIBE `ports` 0.0012540817260742
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00031304359436035
(350) DESCRIBE `ports` 0.0013139247894287
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00031113624572754
(352) DESCRIBE `ports` 0.001270055770874
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00029301643371582
(354) DESCRIBE `ports` 0.001276969909668
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00028800964355469
(356) DESCRIBE `ports` 0.001255989074707
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030803680419922
(358) DESCRIBE `ports` 0.0017299652099609
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028109550476074
(360) DESCRIBE `avid_specials` 0.0011751651763916
(361) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49919 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.001007080078125
(362) DESCRIBE `cruiselines` 0.0019898414611816
(363) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00038003921508789
(364) DESCRIBE `orchid_image` 0.0013940334320068
(365) DESCRIBE `cruiselines` 0.0018088817596436
(366) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026488304138184
(367) DESCRIBE `cruises` 0.0022759437561035
(368) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62169') 0.0002899169921875
(369) DESCRIBE `ships` 0.0027258396148682
(370) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00040698051452637
(371) DESCRIBE `ships` 0.0028290748596191
(372) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00032901763916016
(373) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002751350402832
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002589225769043
(375) DESCRIBE `itineraries` 0.0012221336364746
(376) DESCRIBE `ports` 0.0012950897216797
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036096572875977
(378) DESCRIBE `ports` 0.0014069080352783
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003209114074707
(380) DESCRIBE `ports` 0.0012831687927246
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030207633972168
(382) DESCRIBE `sailingdates` 0.0011780261993408
(383) DESCRIBE `ports` 0.0014369487762451
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033307075500488
(385) DESCRIBE `ports` 0.0012872219085693
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031900405883789
(387) DESCRIBE `ports` 0.0013930797576904
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00031614303588867
(389) DESCRIBE `ports` 0.0013189315795898
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00030112266540527
(391) DESCRIBE `ports` 0.0012838840484619
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00036406517028809
(393) DESCRIBE `ports` 0.0012540817260742
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00039386749267578
(395) DESCRIBE `ports` 0.0014431476593018
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00031185150146484
(397) DESCRIBE `ports` 0.0013391971588135
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00034308433532715
(399) DESCRIBE `ports` 0.001276969909668
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031685829162598
(401) DESCRIBE `ports` 0.0013539791107178
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002739429473877
(403) DESCRIBE `avid_specials` 0.0012199878692627
(404) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62169 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0010430812835693
(405) DESCRIBE `cruiselines` 0.0018799304962158
(406) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00038385391235352
(407) DESCRIBE `orchid_image` 0.0014050006866455
(408) DESCRIBE `cruiselines` 0.0018460750579834
(409) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00027799606323242
(410) DESCRIBE `ships` 0.0026741027832031
(411) SELECT `ships`.* FROM `ships` WHERE (id IN ('573', '1402', '1284', '1758')) ORDER BY FIND_IN_SET(id, '573,1402,1284,1758') 0.00071597099304199
(412) DESCRIBE `cruisetypes` 0.00098991394042969
(413) DESCRIBE `destinations` 0.0023651123046875
(414) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00078892707824707
(415) DESCRIBE `cruiselines` 0.001945972442627
(416) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00034308433532715
(417) DESCRIBE `cruiselines` 0.0018880367279053
(418) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00032496452331543