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

Total elapsed time: 0.86999344825745

# Query Time
(1) connect 0.0010061264038086
(2) DESCRIBE `cruises` 0.0040230751037598
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (55703, 70932, 63401, 70899, 70901, 70931, 70933, 70902, 70916, 70917)) ORDER BY FIND_IN_SET(id, '55703,70932,63401,70899,70901,70931,70933,70902,70916,70917') 0.0022680759429932
(4) DESCRIBE `cruises` 0.0049238204956055
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00048494338989258
(6) DESCRIBE `ships` 0.0041191577911377
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00051498413085938
(8) DESCRIBE `ships` 0.0037670135498047
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00047206878662109
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034785270690918
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(12) DESCRIBE `itineraries` 0.0019879341125488
(13) DESCRIBE `ports` 0.0040631294250488
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00091409683227539
(15) DESCRIBE `ports` 0.0024559497833252
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050997734069824
(17) DESCRIBE `ports` 0.0023009777069092
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045394897460938
(19) DESCRIBE `sailingdates` 0.0023629665374756
(20) DESCRIBE `ports` 0.001701831817627
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043106079101562
(22) DESCRIBE `ports` 0.0021359920501709
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00067710876464844
(24) DESCRIBE `ports` 0.002028226852417
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00058889389038086
(26) DESCRIBE `ports` 0.0020771026611328
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00047087669372559
(28) DESCRIBE `ports` 0.0024871826171875
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049209594726562
(30) DESCRIBE `ports` 0.0020670890808105
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004570484161377
(32) DESCRIBE `avid_specials` 0.0021238327026367
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0018260478973389
(34) DESCRIBE `cruiselines` 0.0026371479034424
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00045490264892578
(36) DESCRIBE `orchid_image` 0.0033361911773682
(37) DESCRIBE `cruiselines` 0.0049648284912109
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0011541843414307
(39) DESCRIBE `cruises` 0.0038881301879883
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70932') 0.00046515464782715
(41) DESCRIBE `ships` 0.0063199996948242
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00058388710021973
(43) DESCRIBE `ships` 0.0044870376586914
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0006568431854248
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0010809898376465
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00076508522033691
(47) DESCRIBE `itineraries` 0.0029230117797852
(48) DESCRIBE `ports` 0.0025131702423096
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044512748718262
(50) DESCRIBE `ports` 0.0020318031311035
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055193901062012
(52) DESCRIBE `ports` 0.0025649070739746
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046300888061523
(54) DESCRIBE `sailingdates` 0.0021860599517822
(55) DESCRIBE `ports` 0.0023770332336426
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058698654174805
(57) DESCRIBE `ports` 0.0021569728851318
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00060701370239258
(59) DESCRIBE `ports` 0.0026919841766357
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00050783157348633
(61) DESCRIBE `ports` 0.0027859210968018
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00043201446533203
(63) DESCRIBE `ports` 0.0019760131835938
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00046515464782715
(65) DESCRIBE `ports` 0.0024800300598145
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00037598609924316
(67) DESCRIBE `ports` 0.0016360282897949
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00058603286743164
(69) DESCRIBE `ports` 0.0028588771820068
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00048279762268066
(71) DESCRIBE `ports` 0.002892017364502
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005648136138916
(73) DESCRIBE `ports` 0.0025289058685303
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043082237243652
(75) DESCRIBE `avid_specials` 0.0017180442810059
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70932 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0013301372528076
(77) DESCRIBE `cruiselines` 0.0024309158325195
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043487548828125
(79) DESCRIBE `orchid_image` 0.0023829936981201
(80) DESCRIBE `cruiselines` 0.0025599002838135
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00042414665222168
(82) DESCRIBE `cruises` 0.0037310123443604
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63401') 0.00042104721069336
(84) DESCRIBE `ships` 0.0041790008544922
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00053286552429199
(86) DESCRIBE `ships` 0.0041451454162598
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00047802925109863
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046801567077637
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034213066101074
(90) DESCRIBE `itineraries` 0.0023519992828369
(91) DESCRIBE `ports` 0.0028390884399414
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00057291984558105
(93) DESCRIBE `ports` 0.0025849342346191
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043320655822754
(95) DESCRIBE `ports` 0.0019519329071045
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039100646972656
(97) DESCRIBE `sailingdates` 0.0014729499816895
(98) DESCRIBE `ports` 0.0020270347595215
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0005040168762207
(100) DESCRIBE `ports` 0.0017480850219727
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004279613494873
(102) DESCRIBE `ports` 0.0020041465759277
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00044012069702148
(104) DESCRIBE `ports` 0.0029518604278564
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00049686431884766
(106) DESCRIBE `ports` 0.0021109580993652
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00051403045654297
(108) DESCRIBE `ports` 0.002112865447998
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038909912109375
(110) DESCRIBE `avid_specials` 0.0025820732116699
(111) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63401 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0021190643310547
(112) DESCRIBE `cruiselines` 0.0033750534057617
(113) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00058484077453613
(114) DESCRIBE `orchid_image` 0.0029809474945068
(115) DESCRIBE `cruiselines` 0.0047628879547119
(116) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00051212310791016
(117) DESCRIBE `cruises` 0.0039920806884766
(118) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70899') 0.00047492980957031
(119) DESCRIBE `ships` 0.0045561790466309
(120) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00051689147949219
(121) DESCRIBE `ships` 0.0033869743347168
(122) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00040698051452637
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(125) DESCRIBE `itineraries` 0.0019137859344482
(126) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70899') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00098896026611328
(127) DESCRIBE `ports` 0.0020389556884766
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00055909156799316
(129) DESCRIBE `ports` 0.0028491020202637
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038504600524902
(131) DESCRIBE `ports` 0.0030090808868408
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0065979957580566
(133) DESCRIBE `sailingdates` 0.0018310546875
(134) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70899') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0046958923339844
(135) DESCRIBE `ports` 0.0021469593048096
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0064761638641357
(137) DESCRIBE `ports` 0.018643140792847
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00075984001159668
(139) DESCRIBE `ports` 0.0029499530792236
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0014629364013672
(141) DESCRIBE `ports` 0.0018970966339111
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044393539428711
(143) DESCRIBE `avid_specials` 0.0018541812896729
(144) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70899 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0020270347595215
(145) DESCRIBE `cruiselines` 0.011677026748657
(146) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00052309036254883
(147) DESCRIBE `orchid_image` 0.002100944519043
(148) DESCRIBE `cruiselines` 0.0037589073181152
(149) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00050902366638184
(150) DESCRIBE `cruises` 0.0039358139038086
(151) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70901') 0.00049901008605957
(152) DESCRIBE `ships` 0.0099129676818848
(153) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00058794021606445
(154) DESCRIBE `ships` 0.004127025604248
(155) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.011063098907471
(156) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036382675170898
(157) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(158) DESCRIBE `itineraries` 0.0019698143005371
(159) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70901') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084590911865234
(160) DESCRIBE `ports` 0.0021572113037109
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054287910461426
(162) DESCRIBE `ports` 0.0019669532775879
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052118301391602
(164) DESCRIBE `ports` 0.0021510124206543
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056004524230957
(166) DESCRIBE `sailingdates` 0.0023119449615479
(167) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70901') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079798698425293
(168) DESCRIBE `ports` 0.0020039081573486
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0022451877593994
(170) DESCRIBE `ports` 0.0021770000457764
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004880428314209
(172) DESCRIBE `ports` 0.002249002456665
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00064492225646973
(174) DESCRIBE `ports` 0.0017740726470947
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00055503845214844
(176) DESCRIBE `ports` 0.0020167827606201
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00050783157348633
(178) DESCRIBE `ports` 0.022448062896729
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00037908554077148
(180) DESCRIBE `ports` 0.0015101432800293
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00076985359191895
(182) DESCRIBE `ports` 0.002140998840332
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00047707557678223
(184) DESCRIBE `ports` 0.002316951751709
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046610832214355
(186) DESCRIBE `ports` 0.0037398338317871
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005030632019043
(188) DESCRIBE `avid_specials` 0.0046558380126953
(189) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70901 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.001723051071167
(190) DESCRIBE `cruiselines` 0.0041639804840088
(191) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.010807037353516
(192) DESCRIBE `orchid_image` 0.0024058818817139
(193) DESCRIBE `cruiselines` 0.0029640197753906
(194) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0037519931793213
(195) DESCRIBE `cruises` 0.0031998157501221
(196) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70931') 0.0085880756378174
(197) DESCRIBE `ships` 0.0036730766296387
(198) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0015909671783447
(199) DESCRIBE `ships` 0.0067539215087891
(200) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0010859966278076
(201) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044918060302734
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(203) DESCRIBE `itineraries` 0.0038049221038818
(204) DESCRIBE `ports` 0.0046820640563965
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0047919750213623
(206) DESCRIBE `ports` 0.0021049976348877
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066113471984863
(208) DESCRIBE `ports` 0.0026609897613525
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042295455932617
(210) DESCRIBE `sailingdates` 0.0040309429168701
(211) DESCRIBE `ports` 0.0026209354400635
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004429817199707
(213) DESCRIBE `ports` 0.002190113067627
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041389465332031
(215) DESCRIBE `ports` 0.0022058486938477
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00047898292541504
(217) DESCRIBE `ports` 0.0018489360809326
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00037407875061035
(219) DESCRIBE `ports` 0.0016348361968994
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0010390281677246
(221) DESCRIBE `ports` 0.0018489360809326
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00042295455932617
(223) DESCRIBE `ports` 0.0018770694732666
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046110153198242
(225) DESCRIBE `ports` 0.006627082824707
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045299530029297
(227) DESCRIBE `avid_specials` 0.0014920234680176
(228) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70931 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0031778812408447
(229) DESCRIBE `cruiselines` 0.0026168823242188
(230) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0004119873046875
(231) DESCRIBE `orchid_image` 0.0020380020141602
(232) DESCRIBE `cruiselines` 0.0031468868255615
(233) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00071501731872559
(234) DESCRIBE `cruises` 0.0045721530914307
(235) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70933') 0.00056099891662598
(236) DESCRIBE `ships` 0.004148006439209
(237) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00051999092102051
(238) DESCRIBE `ships` 0.0081508159637451
(239) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0004889965057373
(240) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003809928894043
(242) DESCRIBE `itineraries` 0.003619909286499
(243) DESCRIBE `ports` 0.0020270347595215
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050902366638184
(245) DESCRIBE `ports` 0.0018398761749268
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048518180847168
(247) DESCRIBE `ports` 0.0020639896392822
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042080879211426
(249) DESCRIBE `sailingdates` 0.0017061233520508
(250) DESCRIBE `ports` 0.0019421577453613
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042581558227539
(252) DESCRIBE `ports` 0.0021481513977051
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041818618774414
(254) DESCRIBE `ports` 0.0024569034576416
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044798851013184
(256) DESCRIBE `ports` 0.002392053604126
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0004279613494873
(258) DESCRIBE `ports` 0.0023360252380371
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00046801567077637
(260) DESCRIBE `ports` 0.0019528865814209
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00040602684020996
(262) DESCRIBE `ports` 0.0019519329071045
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0004420280456543
(264) DESCRIBE `ports` 0.0018019676208496
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00040006637573242
(266) DESCRIBE `ports` 0.0018229484558105
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00039315223693848
(268) DESCRIBE `ports` 0.0036599636077881
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00048208236694336
(270) DESCRIBE `ports` 0.0030379295349121
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0042049884796143
(272) DESCRIBE `ports` 0.0050950050354004
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052213668823242
(274) DESCRIBE `avid_specials` 0.0027990341186523
(275) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70933 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0046188831329346
(276) DESCRIBE `cruiselines` 0.0063850879669189
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0044231414794922
(278) DESCRIBE `orchid_image` 0.0032608509063721
(279) DESCRIBE `cruiselines` 0.0064921379089355
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0094349384307861
(281) DESCRIBE `cruises` 0.0035400390625
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70902') 0.01355504989624
(283) DESCRIBE `ships` 0.0037519931793213
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0061230659484863
(285) DESCRIBE `ships` 0.0035140514373779
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00068187713623047
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030612945556641
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(289) DESCRIBE `itineraries` 0.0019629001617432
(290) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70902') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0081081390380859
(291) DESCRIBE `ports` 0.0022151470184326
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049495697021484
(293) DESCRIBE `ports` 0.0018651485443115
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003960132598877
(295) DESCRIBE `ports` 0.0019979476928711
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040793418884277
(297) DESCRIBE `sailingdates` 0.0016329288482666
(298) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70902') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00090599060058594
(299) DESCRIBE `ports` 0.0030219554901123
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041484832763672
(301) DESCRIBE `ports` 0.0016329288482666
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041103363037109
(303) DESCRIBE `ports` 0.001802921295166
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00089907646179199
(305) DESCRIBE `ports` 0.0048022270202637
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00062918663024902
(307) DESCRIBE `ports` 0.001978874206543
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051999092102051
(309) DESCRIBE `ports` 0.0075719356536865
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042200088500977
(311) DESCRIBE `avid_specials` 0.0014190673828125
(312) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70902 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0012619495391846
(313) DESCRIBE `cruiselines` 0.0022239685058594
(314) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00044417381286621
(315) DESCRIBE `orchid_image` 0.0018148422241211
(316) DESCRIBE `cruiselines` 0.0022430419921875
(317) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0004880428314209
(318) DESCRIBE `cruises` 0.0029950141906738
(319) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70916') 0.00041580200195312
(320) DESCRIBE `ships` 0.0039210319519043
(321) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00068902969360352
(322) DESCRIBE `ships` 0.0040059089660645
(323) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00053906440734863
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035691261291504
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034713745117188
(326) DESCRIBE `itineraries` 0.0020508766174316
(327) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70916') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063991546630859
(328) DESCRIBE `ports` 0.0018711090087891
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051307678222656
(330) DESCRIBE `ports` 0.0024700164794922
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056314468383789
(332) DESCRIBE `ports` 0.0021450519561768
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051188468933105
(334) DESCRIBE `sailingdates` 0.0050168037414551
(335) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70916') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0014219284057617
(336) DESCRIBE `ports` 0.0016920566558838
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037002563476562
(338) DESCRIBE `ports` 0.0013430118560791
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035500526428223
(340) DESCRIBE `ports` 0.001554012298584
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041913986206055
(342) DESCRIBE `ports` 0.0016012191772461
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00036096572875977
(344) DESCRIBE `ports` 0.0017721652984619
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00032186508178711
(346) DESCRIBE `ports` 0.0016119480133057
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00031805038452148
(348) DESCRIBE `ports` 0.0014739036560059
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030207633972168
(350) DESCRIBE `ports` 0.0014870166778564
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037503242492676
(352) DESCRIBE `avid_specials` 0.0014419555664062
(353) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70916 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0011768341064453
(354) DESCRIBE `cruiselines` 0.001924991607666
(355) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030899047851562
(356) DESCRIBE `orchid_image` 0.0017108917236328
(357) DESCRIBE `cruiselines` 0.0025801658630371
(358) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00045514106750488
(359) DESCRIBE `cruises` 0.003957986831665
(360) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70917') 0.00046896934509277
(361) DESCRIBE `ships` 0.0050740242004395
(362) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00058984756469727
(363) DESCRIBE `ships` 0.0040068626403809
(364) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00048184394836426
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035810470581055
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033092498779297
(367) DESCRIBE `itineraries` 0.0020990371704102
(368) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70917') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.000823974609375
(369) DESCRIBE `ports` 0.0020880699157715
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044393539428711
(371) DESCRIBE `ports` 0.0021991729736328
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044417381286621
(373) DESCRIBE `ports` 0.0022518634796143
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039219856262207
(375) DESCRIBE `sailingdates` 0.0018081665039062
(376) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70917') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00076389312744141
(377) DESCRIBE `ports` 0.0023589134216309
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(379) DESCRIBE `ports` 0.0019598007202148
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040102005004883
(381) DESCRIBE `ports` 0.0016989707946777
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00045180320739746
(383) DESCRIBE `ports` 0.0016860961914062
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00036311149597168
(385) DESCRIBE `ports` 0.0018110275268555
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00037097930908203
(387) DESCRIBE `ports` 0.0017719268798828
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00032711029052734
(389) DESCRIBE `ports` 0.0022971630096436
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00039386749267578
(391) DESCRIBE `ports` 0.0018680095672607
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00034904479980469
(393) DESCRIBE `ports` 0.0021741390228271
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004570484161377
(395) DESCRIBE `ports` 0.0025229454040527
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042104721069336
(397) DESCRIBE `avid_specials` 0.0021929740905762
(398) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70917 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0017390251159668
(399) DESCRIBE `cruiselines` 0.0025098323822021
(400) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00039219856262207
(401) DESCRIBE `orchid_image` 0.0019140243530273
(402) DESCRIBE `cruiselines` 0.0026829242706299
(403) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00037598609924316
(404) DESCRIBE `ships` 0.0028951168060303
(405) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722', '288')) ORDER BY FIND_IN_SET(id, '4,1722,288') 0.00073909759521484
(406) DESCRIBE `cruisetypes` 0.0017170906066895
(407) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '4') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.032983064651489
(408) DESCRIBE `destinations` 0.0018930435180664
(409) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00046896934509277
(410) DESCRIBE `cruiselines` 0.0019659996032715
(411) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030899047851562
(412) DESCRIBE `cruiselines` 0.0025031566619873
(413) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035619735717773