or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

Total elapsed time: 0.99624085426331

# Query Time
(1) connect 0.00073599815368652
(2) DESCRIBE `cruises` 0.0044159889221191
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80652, 80655, 80656, 80657, 80651, 80658, 80659, 80660, 80661)) ORDER BY FIND_IN_SET(id, '80652,80655,80656,80657,80651,80658,80659,80660,80661') 0.0014941692352295
(4) DESCRIBE `cruises` 0.0037169456481934
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80652') 0.00067019462585449
(6) DESCRIBE `ships` 0.0041980743408203
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0013918876647949
(8) DESCRIBE `ships` 0.0045371055603027
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.0016028881072998
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00041103363037109
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00030207633972168
(12) DESCRIBE `itineraries` 0.0019760131835938
(13) DESCRIBE `ports` 0.0023109912872314
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050902366638184
(15) DESCRIBE `ports` 0.0019049644470215
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00045585632324219
(17) DESCRIBE `ports` 0.0018520355224609
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00039005279541016
(19) DESCRIBE `sailingdates` 0.0016441345214844
(20) DESCRIBE `ports` 0.0020718574523926
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00051498413085938
(22) DESCRIBE `ports` 0.0018489360809326
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00039887428283691
(24) DESCRIBE `ports` 0.00096297264099121
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00065398216247559
(26) DESCRIBE `ports` 0.0031459331512451
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00052499771118164
(28) DESCRIBE `ports` 0.0021750926971436
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00051403045654297
(30) DESCRIBE `ports` 0.0024330615997314
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00052618980407715
(32) DESCRIBE `ports` 0.0018332004547119
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00043511390686035
(34) DESCRIBE `ports` 0.0014858245849609
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00044894218444824
(36) DESCRIBE `ports` 0.0018808841705322
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00045919418334961
(38) DESCRIBE `ports` 0.0016279220581055
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0010008811950684
(40) DESCRIBE `ports` 0.0019891262054443
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00054693222045898
(42) DESCRIBE `ports` 0.0021910667419434
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00045394897460938
(44) DESCRIBE `ports` 0.0028150081634521
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00046300888061523
(46) DESCRIBE `ports` 0.002234935760498
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0005180835723877
(48) DESCRIBE `ports` 0.0019960403442383
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00025415420532227
(50) DESCRIBE `ports` 0.0019731521606445
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041103363037109
(52) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80652') AND (sailingdate >= '2019-12-15') 0.017384052276611
(53) DESCRIBE `avid_specials` 0.0017530918121338
(54) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80652 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.002392053604126
(55) DESCRIBE `cruiselines` 0.0027101039886475
(56) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00052690505981445
(57) DESCRIBE `orchid_image` 0.0018689632415771
(58) DESCRIBE `cruiselines` 0.0030028820037842
(59) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00050497055053711
(60) DESCRIBE `cruises` 0.003741979598999
(61) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80655') 0.00049781799316406
(62) DESCRIBE `ships` 0.0037729740142822
(63) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0005650520324707
(64) DESCRIBE `ships` 0.0039148330688477
(65) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00053501129150391
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036716461181641
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034308433532715
(68) DESCRIBE `itineraries` 0.0020561218261719
(69) DESCRIBE `ports` 0.0023179054260254
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050997734069824
(71) DESCRIBE `ports` 0.0020108222961426
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050806999206543
(73) DESCRIBE `ports` 0.0019838809967041
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040411949157715
(75) DESCRIBE `sailingdates` 0.001471996307373
(76) DESCRIBE `ports` 0.0021431446075439
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00045609474182129
(78) DESCRIBE `ports` 0.0016560554504395
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00030899047851562
(80) DESCRIBE `ports` 0.0016200542449951
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00039911270141602
(82) DESCRIBE `ports` 0.0018899440765381
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00040793418884277
(84) DESCRIBE `ports` 0.001863956451416
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00043702125549316
(86) DESCRIBE `ports` 0.0020749568939209
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00073099136352539
(88) DESCRIBE `ports` 0.0026001930236816
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00052809715270996
(90) DESCRIBE `ports` 0.0027670860290527
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0003960132598877
(92) DESCRIBE `ports` 0.0018899440765381
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00038480758666992
(94) DESCRIBE `ports` 0.0019481182098389
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00044798851013184
(96) DESCRIBE `ports` 0.0019879341125488
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00040602684020996
(98) DESCRIBE `ports` 0.0020921230316162
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0004119873046875
(100) DESCRIBE `ports` 0.0020449161529541
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00043702125549316
(102) DESCRIBE `ports` 0.0018930435180664
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00063109397888184
(104) DESCRIBE `ports` 0.0029268264770508
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00072908401489258
(106) DESCRIBE `ports` 0.0026929378509521
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00052690505981445
(108) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80655') AND (sailingdate >= '2019-12-15') 0.014830112457275
(109) DESCRIBE `avid_specials` 0.0027518272399902
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80655 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0033740997314453
(111) DESCRIBE `cruiselines` 0.0028910636901855
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.0007789134979248
(113) DESCRIBE `orchid_image` 0.0026659965515137
(114) DESCRIBE `cruiselines` 0.0038552284240723
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00063085556030273
(116) DESCRIBE `cruises` 0.0038940906524658
(117) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80656') 0.00045299530029297
(118) DESCRIBE `ships` 0.0040130615234375
(119) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0006248950958252
(120) DESCRIBE `ships` 0.0049560070037842
(121) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00066399574279785
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032591819763184
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026321411132812
(124) DESCRIBE `itineraries` 0.0018250942230225
(125) DESCRIBE `ports` 0.0021810531616211
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043797492980957
(127) DESCRIBE `ports` 0.002155065536499
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00048708915710449
(129) DESCRIBE `ports` 0.0020289421081543
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00039291381835938
(131) DESCRIBE `sailingdates` 0.0015420913696289
(132) DESCRIBE `ports` 0.002140998840332
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00060701370239258
(134) DESCRIBE `ports` 0.0047609806060791
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0
(136) DESCRIBE `ports` 0.0024318695068359
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00055193901062012
(138) DESCRIBE `ports` 0.0022330284118652
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00059700012207031
(140) DESCRIBE `ports` 0.0017969608306885
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00041985511779785
(142) DESCRIBE `ports` 0.0022289752960205
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00051403045654297
(144) DESCRIBE `ports` 0.0028738975524902
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00052690505981445
(146) DESCRIBE `ports` 0.0023159980773926
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00058102607727051
(148) DESCRIBE `ports` 0.0020380020141602
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00047993659973145
(150) DESCRIBE `ports` 0.0020260810852051
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00034499168395996
(152) DESCRIBE `ports` 0.0018899440765381
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.001230001449585
(154) DESCRIBE `ports` 0.0022680759429932
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00042104721069336
(156) DESCRIBE `ports` 0.0019378662109375
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00041389465332031
(158) DESCRIBE `ports` 0.0020008087158203
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00048303604125977
(160) DESCRIBE `ports` 0.0018901824951172
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043988227844238
(162) DESCRIBE `ports` 0.0018458366394043
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00043702125549316
(164) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80656') AND (sailingdate >= '2019-12-15') 0.0076420307159424
(165) DESCRIBE `avid_specials` 0.0020332336425781
(166) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80656 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0020718574523926
(167) DESCRIBE `cruiselines` 0.0026822090148926
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00071001052856445
(169) DESCRIBE `orchid_image` 0.0026319026947021
(170) DESCRIBE `cruiselines` 0.0028798580169678
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.0005340576171875
(172) DESCRIBE `cruises` 0.0040040016174316
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80657') 0.00015091896057129
(174) DESCRIBE `ships` 0.0032191276550293
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00065207481384277
(176) DESCRIBE `ships` 0.0037541389465332
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00046110153198242
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032401084899902
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036883354187012
(180) DESCRIBE `itineraries` 0.0018689632415771
(181) DESCRIBE `ports` 0.0021650791168213
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00051498413085938
(183) DESCRIBE `ports` 0.0020220279693604
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00052595138549805
(185) DESCRIBE `ports` 0.0019509792327881
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0004417896270752
(187) DESCRIBE `sailingdates` 0.0017430782318115
(188) DESCRIBE `ports` 0.0024890899658203
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00061511993408203
(190) DESCRIBE `ports` 0.0027251243591309
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046992301940918
(192) DESCRIBE `ports` 0.0013339519500732
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0
(194) DESCRIBE `ports` 0.001190185546875
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00040698051452637
(196) DESCRIBE `ports` 0.0020780563354492
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0012011528015137
(198) DESCRIBE `ports` 0.0027840137481689
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00043416023254395
(200) DESCRIBE `ports` 0.0019679069519043
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00052905082702637
(202) DESCRIBE `ports` 0.0024080276489258
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00055599212646484
(204) DESCRIBE `ports` 0.0021450519561768
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00042486190795898
(206) DESCRIBE `ports` 0.0018839836120605
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00048089027404785
(208) DESCRIBE `ports` 0.0030460357666016
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00026988983154297
(210) DESCRIBE `ports` 0.0024797916412354
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0007929801940918
(212) DESCRIBE `ports` 0.0012080669403076
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.0004119873046875
(214) DESCRIBE `ports` 0.005932092666626
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.0005800724029541
(216) DESCRIBE `ports` 0.0023488998413086
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00054597854614258
(218) DESCRIBE `ports` 0.0019681453704834
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00053000450134277
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80657') AND (sailingdate >= '2019-12-15') 0.0083608627319336
(221) DESCRIBE `avid_specials` 0.0019462108612061
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80657 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0011940002441406
(223) DESCRIBE `cruiselines` 0.0023870468139648
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00052809715270996
(225) DESCRIBE `orchid_image` 0.002424955368042
(226) DESCRIBE `cruiselines` 0.0036630630493164
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00045990943908691
(228) DESCRIBE `cruises` 0.0049171447753906
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80651') 8.1777572631836E-5
(230) DESCRIBE `ships` 0.0040850639343262
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00052905082702637
(232) DESCRIBE `ships` 0.0050361156463623
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.0064470767974854
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.001863956451416
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0
(236) DESCRIBE `itineraries` 0.0010111331939697
(237) DESCRIBE `ports` 0.0017330646514893
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0039999485015869
(239) DESCRIBE `ports` 0.0018069744110107
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0065100193023682
(241) DESCRIBE `ports` 0.0021829605102539
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00045299530029297
(243) DESCRIBE `sailingdates` 0.0013279914855957
(244) DESCRIBE `ports` 0.0015439987182617
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0018181800842285
(246) DESCRIBE `ports` 0.0020759105682373
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0065419673919678
(248) DESCRIBE `ports` 0.0030691623687744
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.0041279792785645
(250) DESCRIBE `ports` 0.002133846282959
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00042295455932617
(252) DESCRIBE `ports` 0.0077610015869141
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00050091743469238
(254) DESCRIBE `ports` 0.0020201206207275
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00040984153747559
(256) DESCRIBE `ports` 0.010238885879517
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00060892105102539
(258) DESCRIBE `ports` 0.0022139549255371
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00040698051452637
(260) DESCRIBE `ports` 0.0018351078033447
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00042104721069336
(262) DESCRIBE `ports` 0.0015749931335449
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00032591819763184
(264) DESCRIBE `ports` 0.010031938552856
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048494338989258
(266) DESCRIBE `ports` 0.0019869804382324
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043892860412598
(268) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80651') AND (sailingdate >= '2019-12-15') 0.016565799713135
(269) DESCRIBE `avid_specials` 0.0018289089202881
(270) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80651 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0017931461334229
(271) DESCRIBE `cruiselines` 0.0087990760803223
(272) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00052499771118164
(273) DESCRIBE `orchid_image` 0.0021939277648926
(274) DESCRIBE `cruiselines` 0.0097730159759521
(275) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.0005638599395752
(276) DESCRIBE `cruises` 0.0036931037902832
(277) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80658') 0.0057799816131592
(278) DESCRIBE `ships` 0.003964900970459
(279) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00052618980407715
(280) DESCRIBE `ships` 0.0037848949432373
(281) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.011269092559814
(282) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00038003921508789
(283) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003659725189209
(284) DESCRIBE `itineraries` 0.002129077911377
(285) DESCRIBE `ports` 0.0021669864654541
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049996376037598
(287) DESCRIBE `ports` 0.002004861831665
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045990943908691
(289) DESCRIBE `ports` 0.0033080577850342
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0030498504638672
(291) DESCRIBE `sailingdates` 0.0018000602722168
(292) DESCRIBE `ports` 0.0080101490020752
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056290626525879
(294) DESCRIBE `ports` 0.00187087059021
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040316581726074
(296) DESCRIBE `ports` 0.0019998550415039
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00051689147949219
(298) DESCRIBE `ports` 0.0079009532928467
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.0006248950958252
(300) DESCRIBE `ports` 0.0021011829376221
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00051403045654297
(302) DESCRIBE `ports` 0.0018999576568604
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0085110664367676
(304) DESCRIBE `ports` 0.0019130706787109
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00051093101501465
(306) DESCRIBE `ports` 0.0024240016937256
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039887428283691
(308) DESCRIBE `ports` 0.0021481513977051
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0072128772735596
(310) DESCRIBE `ports` 0.0026090145111084
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00045418739318848
(312) DESCRIBE `ports` 0.0025780200958252
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049090385437012
(314) DESCRIBE `ports` 0.0017750263214111
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0067739486694336
(316) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80658') AND (sailingdate >= '2019-12-15') 0.019579887390137
(317) DESCRIBE `avid_specials` 0.001896858215332
(318) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80658 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.009026050567627
(319) DESCRIBE `cruiselines` 0.0021688938140869
(320) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00039100646972656
(321) DESCRIBE `orchid_image` 0.0019888877868652
(322) DESCRIBE `cruiselines` 0.0026271343231201
(323) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.008202075958252
(324) DESCRIBE `cruises` 0.0035691261291504
(325) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80659') 0.00052213668823242
(326) DESCRIBE `ships` 0.0038158893585205
(327) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0071790218353271
(328) DESCRIBE `ships` 0.0037970542907715
(329) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00048494338989258
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032305717468262
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00038886070251465
(332) DESCRIBE `itineraries` 0.003715991973877
(333) DESCRIBE `ports` 0.0024318695068359
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00085997581481934
(335) DESCRIBE `ports` 0.0032081604003906
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00070881843566895
(337) DESCRIBE `ports` 0.0035300254821777
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054001808166504
(339) DESCRIBE `sailingdates` 0.00177001953125
(340) DESCRIBE `ports` 0.0023670196533203
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056886672973633
(342) DESCRIBE `ports` 0.0020148754119873
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0018360614776611
(344) DESCRIBE `ports` 0.0020987987518311
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 3.3855438232422E-5
(346) DESCRIBE `ports` 0.0018999576568604
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00055098533630371
(348) DESCRIBE `ports` 0.002532958984375
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00054192543029785
(350) DESCRIBE `ports` 0.0029749870300293
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00049686431884766
(352) DESCRIBE `ports` 0.002993106842041
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00040578842163086
(354) DESCRIBE `ports` 0.0034170150756836
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00068402290344238
(356) DESCRIBE `ports` 0.002155065536499
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00052094459533691
(358) DESCRIBE `ports` 0.0020220279693604
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00044894218444824
(360) DESCRIBE `ports` 0.0018279552459717
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050806999206543
(362) DESCRIBE `ports` 0.0019018650054932
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0016438961029053
(364) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80659') AND (sailingdate >= '2019-12-15') 0.0084590911865234
(365) DESCRIBE `avid_specials` 0.0018978118896484
(366) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80659 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.001856803894043
(367) DESCRIBE `cruiselines` 0.0027790069580078
(368) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00054097175598145
(369) DESCRIBE `orchid_image` 0.0022060871124268
(370) DESCRIBE `cruiselines` 0.0027091503143311
(371) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.0013208389282227
(372) DESCRIBE `cruises` 0.0030500888824463
(373) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80660') 0.00052189826965332
(374) DESCRIBE `ships` 0.0042760372161865
(375) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00077295303344727
(376) DESCRIBE `ships` 0.0034961700439453
(377) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00048589706420898
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00031089782714844
(379) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00029492378234863
(380) DESCRIBE `itineraries` 0.0020668506622314
(381) DESCRIBE `ports` 0.0019600391387939
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006260871887207
(383) DESCRIBE `ports` 0.0018689632415771
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003659725189209
(385) DESCRIBE `ports` 0.0017499923706055
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045204162597656
(387) DESCRIBE `sailingdates` 0.0015919208526611
(388) DESCRIBE `ports` 0.0022361278533936
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005338191986084
(390) DESCRIBE `ports` 0.002418041229248
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048708915710449
(392) DESCRIBE `ports` 0.0021920204162598
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00058507919311523
(394) DESCRIBE `ports` 0.0021688938140869
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0003359317779541
(396) DESCRIBE `ports` 0.0019569396972656
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00046181678771973
(398) DESCRIBE `ports` 0.0019640922546387
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00052499771118164
(400) DESCRIBE `ports` 0.002234935760498
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00052714347839355
(402) DESCRIBE `ports` 0.0023519992828369
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00046801567077637
(404) DESCRIBE `ports` 0.001939058303833
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2472))) 0.00047612190246582
(406) DESCRIBE `ports` 0.0022220611572266
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2472') 0.00048494338989258
(408) DESCRIBE `ports` 0.0021650791168213
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004889965057373
(410) DESCRIBE `ports` 0.0020880699157715
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004580020904541
(412) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80660') AND (sailingdate >= '2019-12-15') 0.008807897567749
(413) DESCRIBE `avid_specials` 0.00199294090271
(414) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80660 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0021378993988037
(415) DESCRIBE `cruiselines` 0.0025298595428467
(416) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00049901008605957
(417) DESCRIBE `orchid_image` 0.0021171569824219
(418) DESCRIBE `cruiselines` 0.002561092376709
(419) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00046896934509277
(420) DESCRIBE `cruises` 0.0038039684295654
(421) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80661') 0.0005030632019043
(422) DESCRIBE `ships` 0.0039629936218262
(423) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00071597099304199
(424) DESCRIBE `ships` 0.0040960311889648
(425) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00046682357788086
(426) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00041294097900391
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00038290023803711
(428) DESCRIBE `itineraries` 0.0020911693572998
(429) DESCRIBE `ports` 0.0021591186523438
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047183036804199
(431) DESCRIBE `ports` 0.0018448829650879
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055599212646484
(433) DESCRIBE `ports` 0.0019869804382324
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003509521484375
(435) DESCRIBE `sailingdates` 0.0012879371643066
(436) DESCRIBE `ports` 0.0020430088043213
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005500316619873
(438) DESCRIBE `ports` 0.0020198822021484
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00050616264343262
(440) DESCRIBE `ports` 0.0019779205322266
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00048995018005371
(442) DESCRIBE `ports` 0.0019488334655762
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00043392181396484
(444) DESCRIBE `ports` 0.0060257911682129
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00041604042053223
(446) DESCRIBE `ports` 0.0015811920166016
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00036191940307617
(448) DESCRIBE `ports` 0.0079450607299805
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00039911270141602
(450) DESCRIBE `ports` 0.0016720294952393
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.0003659725189209
(452) DESCRIBE `ports` 0.0016238689422607
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039315223693848
(454) DESCRIBE `ports` 0.0053670406341553
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004270076751709
(456) DESCRIBE `ports` 0.0018370151519775
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0057120323181152
(458) DESCRIBE `ports` 0.0020618438720703
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047516822814941
(460) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80661') AND (sailingdate >= '2019-12-15') 0.020747900009155
(461) DESCRIBE `avid_specials` 0.0018250942230225
(462) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80661 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0014140605926514
(463) DESCRIBE `cruiselines` 0.0030100345611572
(464) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.0080630779266357
(465) DESCRIBE `orchid_image` 0.0040481090545654
(466) DESCRIBE `cruiselines` 0.0032849311828613
(467) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00042200088500977
(468) DESCRIBE `cruiselines` 0.0029528141021729
(469) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('264')) ORDER BY FIND_IN_SET(id, '264') 0.00096702575683594
(470) DESCRIBE `cruisetypes` 0.003309965133667
(471) DESCRIBE `destinations` 0.0028200149536133
(472) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43')) ORDER BY FIND_IN_SET(id, '8,43') 0.0007328987121582
(473) DESCRIBE `ships` 0.0043380260467529
(474) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00056910514831543
(475) DESCRIBE `ships` 0.0038731098175049
(476) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00052213668823242