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

Total elapsed time: 0.79423642158508

# Query Time
(1) connect 0.001816987991333
(2) DESCRIBE `cruises` 0.0038690567016602
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80643, 80644, 80576, 61570, 80577, 57752, 56235, 80578, 77978, 77979)) ORDER BY FIND_IN_SET(id, '80643,80644,80576,61570,80577,57752,56235,80578,77978,77979') 0.0030901432037354
(4) DESCRIBE `cruises` 0.0032370090484619
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80643') 0.00061297416687012
(6) DESCRIBE `ships` 0.0043950080871582
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.0094649791717529
(8) DESCRIBE `ships` 0.004058837890625
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00034093856811523
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003349781036377
(12) DESCRIBE `itineraries` 0.00099301338195801
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80643') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0097320079803467
(14) DESCRIBE `ports` 0.0022740364074707
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00016188621520996
(16) DESCRIBE `ports` 0.0013091564178467
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00096011161804199
(18) DESCRIBE `ports` 0.0018589496612549
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0074858665466309
(20) DESCRIBE `sailingdates` 0.0014829635620117
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80643') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011968612670898
(22) DESCRIBE `ports` 0.0025019645690918
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00017786026000977
(24) DESCRIBE `ports` 0.0012619495391846
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0058839321136475
(26) DESCRIBE `ports` 0.0018999576568604
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004878044128418
(28) DESCRIBE `ports` 0.001896858215332
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039219856262207
(30) DESCRIBE `ports` 0.010192155838013
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00057506561279297
(32) DESCRIBE `ports` 0.002007007598877
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00042200088500977
(34) DESCRIBE `ports` 0.001957893371582
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029993057250977
(36) DESCRIBE `ports` 0.001741886138916
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029206275939941
(38) DESCRIBE `ports` 0.0050299167633057
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00065207481384277
(40) DESCRIBE `ports` 0.0015678405761719
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0020039081573486
(42) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80643') AND (sailingdate >= '2019-11-27') 0.024003028869629
(43) DESCRIBE `avid_specials` 0.0026969909667969
(44) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80643 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0035660266876221
(45) DESCRIBE `cruiselines` 0.0032651424407959
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00044512748718262
(47) DESCRIBE `orchid_image` 0.0020380020141602
(48) DESCRIBE `cruiselines` 0.0026018619537354
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00042486190795898
(50) DESCRIBE `cruises` 0.0036590099334717
(51) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80644') 0.00041913986206055
(52) DESCRIBE `ships` 0.0045270919799805
(53) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00047707557678223
(54) DESCRIBE `ships` 0.003788948059082
(55) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00044417381286621
(56) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00029897689819336
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023794174194336
(58) DESCRIBE `itineraries` 0.0021069049835205
(59) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80644') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006709098815918
(60) DESCRIBE `ports` 0.0019090175628662
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00053310394287109
(62) DESCRIBE `ports` 0.0018341541290283
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046420097351074
(64) DESCRIBE `ports` 0.0018560886383057
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00039196014404297
(66) DESCRIBE `sailingdates` 0.0017459392547607
(67) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80644') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00091695785522461
(68) DESCRIBE `ports` 0.0022568702697754
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00058484077453613
(70) DESCRIBE `ports` 0.0018589496612549
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0008389949798584
(72) DESCRIBE `ports` 0.0018541812896729
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005497932434082
(74) DESCRIBE `ports` 0.0017330646514893
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040411949157715
(76) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80644') AND (sailingdate >= '2019-11-27') 0.0098600387573242
(77) DESCRIBE `avid_specials` 0.0018959045410156
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80644 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0018370151519775
(79) DESCRIBE `cruiselines` 0.0030720233917236
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00032496452331543
(81) DESCRIBE `orchid_image` 0.0020411014556885
(82) DESCRIBE `cruiselines` 0.0019659996032715
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00026893615722656
(84) DESCRIBE `cruises` 0.0031979084014893
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80576') 0.00026702880859375
(86) DESCRIBE `ships` 0.0029139518737793
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00052404403686523
(88) DESCRIBE `ships` 0.0030629634857178
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00033903121948242
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034999847412109
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00041699409484863
(92) DESCRIBE `itineraries` 0.0019948482513428
(93) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80576') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00086712837219238
(94) DESCRIBE `ports` 0.001514196395874
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042605400085449
(96) DESCRIBE `ports` 0.0012669563293457
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036311149597168
(98) DESCRIBE `ports` 0.0013160705566406
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0080001354217529
(100) DESCRIBE `sailingdates` 0.0015251636505127
(101) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80576') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067782402038574
(102) DESCRIBE `ports` 0.0018360614776611
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004420280456543
(104) DESCRIBE `ports` 0.0017020702362061
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002291202545166
(106) DESCRIBE `ports` 0.001539945602417
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.006187915802002
(108) DESCRIBE `ports` 0.0017149448394775
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00030899047851562
(110) DESCRIBE `ports` 0.0014529228210449
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031208992004395
(112) DESCRIBE `ports` 0.0013749599456787
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0083389282226562
(114) DESCRIBE `ports` 0.0015690326690674
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00035691261291504
(116) DESCRIBE `ports` 0.00173020362854
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0004580020904541
(118) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80576') AND (sailingdate >= '2019-11-27') 0.014219045639038
(119) DESCRIBE `avid_specials` 0.0017189979553223
(120) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80576 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0016579627990723
(121) DESCRIBE `cruiselines` 0.0025131702423096
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0073020458221436
(123) DESCRIBE `orchid_image` 0.0018520355224609
(124) DESCRIBE `cruiselines` 0.0018980503082275
(125) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.0003209114074707
(126) DESCRIBE `cruises` 0.0026609897613525
(127) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61570') 0.00032806396484375
(128) DESCRIBE `ships` 0.002680778503418
(129) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.0077741146087646
(130) DESCRIBE `ships` 0.0039150714874268
(131) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.0004580020904541
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026893615722656
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032210350036621
(134) DESCRIBE `itineraries` 0.0015311241149902
(135) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61570') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0061800479888916
(136) DESCRIBE `ports` 0.0015609264373779
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00036501884460449
(138) DESCRIBE `ports` 0.0015919208526611
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.008887767791748
(140) DESCRIBE `ports` 0.001723051071167
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00038003921508789
(142) DESCRIBE `sailingdates` 0.0013980865478516
(143) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61570') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00099086761474609
(144) DESCRIBE `ports` 0.0017659664154053
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0005030632019043
(146) DESCRIBE `ports` 0.0015919208526611
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00033879280090332
(148) DESCRIBE `ports` 0.0014898777008057
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00037789344787598
(150) DESCRIBE `ports` 0.0018820762634277
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00038313865661621
(152) DESCRIBE `ports` 0.0019290447235107
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00047612190246582
(154) DESCRIBE `ports` 0.0018298625946045
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00039291381835938
(156) DESCRIBE `ports` 0.0018539428710938
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00040006637573242
(158) DESCRIBE `ports` 0.0016510486602783
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00039196014404297
(160) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '61570') AND (sailingdate >= '2019-11-27') 0.0089068412780762
(161) DESCRIBE `avid_specials` 0.0019280910491943
(162) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61570 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0014028549194336
(163) DESCRIBE `cruiselines` 0.0033669471740723
(164) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0005340576171875
(165) DESCRIBE `orchid_image` 0.0019381046295166
(166) DESCRIBE `cruiselines` 0.0019609928131104
(167) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00034284591674805
(168) DESCRIBE `cruises` 0.0028369426727295
(169) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80577') 0.0069990158081055
(170) DESCRIBE `ships` 0.0038650035858154
(171) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00055599212646484
(172) DESCRIBE `ships` 0.0033621788024902
(173) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.0040338039398193
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035905838012695
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0065650939941406
(176) DESCRIBE `itineraries` 0.0016639232635498
(177) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80577') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00076913833618164
(178) DESCRIBE `ports` 0.0016391277313232
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00038909912109375
(180) DESCRIBE `ports` 0.0014729499816895
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00037097930908203
(182) DESCRIBE `ports` 0.010503053665161
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00042915344238281
(184) DESCRIBE `sailingdates` 0.0014870166778564
(185) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80577') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005791187286377
(186) DESCRIBE `ports` 0.001896858215332
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00043582916259766
(188) DESCRIBE `ports` 0.0017011165618896
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00036382675170898
(190) DESCRIBE `ports` 0.0017039775848389
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6035))) 0.0083720684051514
(192) DESCRIBE `ports` 0.0018970966339111
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6035') 0.00045394897460938
(194) DESCRIBE `ports` 0.0016741752624512
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3395))) 0.00039792060852051
(196) DESCRIBE `ports` 0.0014779567718506
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3395') 0.00034403800964355
(198) DESCRIBE `ports` 0.0017361640930176
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0080540180206299
(200) DESCRIBE `ports` 0.0018479824066162
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00038790702819824
(202) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80577') AND (sailingdate >= '2019-11-27') 0.0082669258117676
(203) DESCRIBE `avid_specials` 0.0065760612487793
(204) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80577 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0029969215393066
(205) DESCRIBE `cruiselines` 0.010729074478149
(206) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00055694580078125
(207) DESCRIBE `orchid_image` 0.0019559860229492
(208) DESCRIBE `cruiselines` 0.002493143081665
(209) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.0093669891357422
(210) DESCRIBE `cruises` 0.0033760070800781
(211) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57752') 0.00046300888061523
(212) DESCRIBE `ships` 0.0035488605499268
(213) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 818))) 0.00056600570678711
(214) DESCRIBE `ships` 0.0030860900878906
(215) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '818') 0.00050902366638184
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00028300285339355
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003359317779541
(218) DESCRIBE `itineraries` 0.0019509792327881
(219) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57752') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00086188316345215
(220) DESCRIBE `ports` 0.0016250610351562
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00033998489379883
(222) DESCRIBE `ports` 0.0013799667358398
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00037407875061035
(224) DESCRIBE `ports` 0.0023360252380371
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00045013427734375
(226) DESCRIBE `sailingdates` 0.0016429424285889
(227) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57752') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010161399841309
(228) DESCRIBE `ports` 0.0025200843811035
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00017595291137695
(230) DESCRIBE `ports` 0.0016999244689941
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00038695335388184
(232) DESCRIBE `ports` 0.0018150806427002
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00041604042053223
(234) DESCRIBE `ports` 0.0018789768218994
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0
(236) DESCRIBE `ports` 0.0022661685943604
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00020694732666016
(238) DESCRIBE `ports` 0.0017249584197998
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00092005729675293
(240) DESCRIBE `ports` 0.0022420883178711
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00053310394287109
(242) DESCRIBE `ports` 0.0016200542449951
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00037693977355957
(244) DESCRIBE `ports` 0.0015308856964111
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00037693977355957
(246) DESCRIBE `ports` 0.0016269683837891
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00037288665771484
(248) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '57752') AND (sailingdate >= '2019-11-27') 0.0088269710540771
(249) DESCRIBE `avid_specials` 0.0015277862548828
(250) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57752 and class = 'Cruise') OR (item_id = 818 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.001121997833252
(251) DESCRIBE `cruiselines` 0.0020880699157715
(252) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00041007995605469
(253) DESCRIBE `orchid_image` 0.0016400814056396
(254) DESCRIBE `cruiselines` 0.0027639865875244
(255) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00051093101501465
(256) DESCRIBE `cruises` 0.0037310123443604
(257) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56235') 0.00049209594726562
(258) DESCRIBE `ships` 0.0036637783050537
(259) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00055289268493652
(260) DESCRIBE `ships` 0.0035719871520996
(261) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00042605400085449
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00037908554077148
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003349781036377
(264) DESCRIBE `itineraries` 0.0017590522766113
(265) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56235') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085783004760742
(266) DESCRIBE `ports` 0.0020139217376709
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00046801567077637
(268) DESCRIBE `ports` 0.0018179416656494
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00039815902709961
(270) DESCRIBE `ports` 0.001755952835083
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00038790702819824
(272) DESCRIBE `sailingdates` 0.0015652179718018
(273) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56235') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00093412399291992
(274) DESCRIBE `ports` 0.0019521713256836
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0004429817199707
(276) DESCRIBE `ports` 0.0017750263214111
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00039505958557129
(278) DESCRIBE `ports` 0.0018060207366943
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00046110153198242
(280) DESCRIBE `ports` 0.0026860237121582
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00049591064453125
(282) DESCRIBE `ports` 0.0044758319854736
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00041294097900391
(284) DESCRIBE `ports` 0.0017280578613281
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00042009353637695
(286) DESCRIBE `ports` 0.0019130706787109
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00045990943908691
(288) DESCRIBE `ports` 0.0018360614776611
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00041699409484863
(290) DESCRIBE `ports` 0.0017969608306885
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00043082237243652
(292) DESCRIBE `ports` 0.0020549297332764
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00042319297790527
(294) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '56235') AND (sailingdate >= '2019-11-27') 0.0092868804931641
(295) DESCRIBE `avid_specials` 0.001920223236084
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56235 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0017099380493164
(297) DESCRIBE `cruiselines` 0.0026741027832031
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00052404403686523
(299) DESCRIBE `orchid_image` 0.0020921230316162
(300) DESCRIBE `cruiselines` 0.0025861263275146
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00042986869812012
(302) DESCRIBE `cruises` 0.00360107421875
(303) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80578') 0.00045585632324219
(304) DESCRIBE `ships` 0.003654956817627
(305) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00053596496582031
(306) DESCRIBE `ships` 0.0036599636077881
(307) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00045299530029297
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00039100646972656
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032997131347656
(310) DESCRIBE `itineraries` 0.0017788410186768
(311) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80578') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061392784118652
(312) DESCRIBE `ports` 0.001910924911499
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00046086311340332
(314) DESCRIBE `ports` 0.0018970966339111
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00042986869812012
(316) DESCRIBE `ports` 0.0017311573028564
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00037097930908203
(318) DESCRIBE `sailingdates` 0.0015730857849121
(319) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80578') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070381164550781
(320) DESCRIBE `ports` 0.0025720596313477
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00045204162597656
(322) DESCRIBE `ports` 0.0013809204101562
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00031399726867676
(324) DESCRIBE `ports` 0.0013089179992676
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 5.3882598876953E-5
(326) DESCRIBE `ports` 0.0015759468078613
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030088424682617
(328) DESCRIBE `ports` 0.0012989044189453
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00032591819763184
(330) DESCRIBE `ports` 0.0013828277587891
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00031399726867676
(332) DESCRIBE `ports` 0.0014581680297852
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00036096572875977
(334) DESCRIBE `ports` 0.0013229846954346
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00030207633972168
(336) DESCRIBE `ports` 0.0013179779052734
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00029206275939941
(338) DESCRIBE `ports` 0.0012350082397461
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0002739429473877
(340) DESCRIBE `ports` 0.0012829303741455
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00036215782165527
(342) DESCRIBE `ports` 0.0014579296112061
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00035786628723145
(344) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80578') AND (sailingdate >= '2019-11-27') 0.0058350563049316
(345) DESCRIBE `avid_specials` 0.0013439655303955
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80578 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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
(347) DESCRIBE `cruiselines` 0.0018148422241211
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00035595893859863
(349) DESCRIBE `orchid_image` 0.0014610290527344
(350) DESCRIBE `cruiselines` 0.0020158290863037
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00030303001403809
(352) DESCRIBE `cruises` 0.0026679039001465
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77978') 0.0003209114074707
(354) DESCRIBE `ships` 0.0024549961090088
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.0003960132598877
(356) DESCRIBE `ships` 0.0025901794433594
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00034403800964355
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026702880859375
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025510787963867
(360) DESCRIBE `itineraries` 0.0014419555664062
(361) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77978') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066685676574707
(362) DESCRIBE `ports` 0.0013940334320068
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00031495094299316
(364) DESCRIBE `ports` 0.0012938976287842
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00030112266540527
(366) DESCRIBE `ports` 0.0012681484222412
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00028896331787109
(368) DESCRIBE `sailingdates` 0.0010972023010254
(369) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77978') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062799453735352
(370) DESCRIBE `ports` 0.0013220310211182
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00030899047851562
(372) DESCRIBE `ports` 0.0012509822845459
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00034093856811523
(374) DESCRIBE `ports` 0.0013530254364014
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00029993057250977
(376) DESCRIBE `ports` 0.0015950202941895
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.0003509521484375
(378) DESCRIBE `ports` 0.0016920566558838
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00030398368835449
(380) DESCRIBE `ports` 0.0012738704681396
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0002748966217041
(382) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '77978') AND (sailingdate >= '2019-11-27') 0.0054612159729004
(383) DESCRIBE `avid_specials` 0.0015020370483398
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77978 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0011918544769287
(385) DESCRIBE `cruiselines` 0.0019850730895996
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00040388107299805
(387) DESCRIBE `orchid_image` 0.001507043838501
(388) DESCRIBE `cruiselines` 0.0024991035461426
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00046992301940918
(390) DESCRIBE `cruises` 0.0033421516418457
(391) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77979') 0.00035691261291504
(392) DESCRIBE `ships` 0.0025458335876465
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.0003960132598877
(394) DESCRIBE `ships` 0.0024688243865967
(395) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00029301643371582
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026297569274902
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025391578674316
(398) DESCRIBE `itineraries` 0.0012950897216797
(399) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77979') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0004878044128418
(400) DESCRIBE `ports` 0.0013189315795898
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0003199577331543
(402) DESCRIBE `ports` 0.0014438629150391
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00040411949157715
(404) DESCRIBE `ports` 0.001378059387207
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00039100646972656
(406) DESCRIBE `sailingdates` 0.0013539791107178
(407) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77979') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005650520324707
(408) DESCRIBE `ports` 0.0015828609466553
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00034689903259277
(410) DESCRIBE `ports` 0.0013020038604736
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00028610229492188
(412) DESCRIBE `ports` 0.001305103302002
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00032520294189453
(414) DESCRIBE `ports` 0.0012719631195068
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00032401084899902
(416) DESCRIBE `ports` 0.0012669563293457
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00029397010803223
(418) DESCRIBE `ports` 0.0013089179992676
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.0003211498260498
(420) DESCRIBE `ports` 0.0015029907226562
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00042080879211426
(422) DESCRIBE `ports` 0.0017499923706055
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00037598609924316
(424) DESCRIBE `ports` 0.0018060207366943
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00031304359436035
(426) DESCRIBE `ports` 0.0013329982757568
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00028014183044434
(428) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '77979') AND (sailingdate >= '2019-11-27') 0.0051219463348389
(429) DESCRIBE `avid_specials` 0.0011701583862305
(430) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77979 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.00097298622131348
(431) DESCRIBE `cruiselines` 0.0018961429595947
(432) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0003819465637207
(433) DESCRIBE `orchid_image` 0.0014159679412842
(434) DESCRIBE `cruiselines` 0.0019729137420654
(435) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00029993057250977
(436) DESCRIBE `ships` 0.0028529167175293
(437) SELECT `ships`.* FROM `ships` WHERE (id IN ('1454', '1730', '818', '1308')) ORDER BY FIND_IN_SET(id, '1454,1730,818,1308') 0.0007789134979248
(438) DESCRIBE `cruisetypes` 0.0010700225830078
(439) DESCRIBE `destinations` 0.0016639232635498
(440) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '8', '21', '28', '48', '35', '12', '30', '38')) ORDER BY FIND_IN_SET(id, '40,8,21,28,48,35,12,30,38') 0.00098896026611328
(441) DESCRIBE `cruiselines` 0.0018420219421387
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00033092498779297
(443) DESCRIBE `cruiselines` 0.0018379688262939
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00035691261291504