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

Total elapsed time: 0.84489679336548

# Query Time
(1) connect 0.0017149448394775
(2) DESCRIBE `cruises` 0.0046939849853516
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (60251, 68749, 68750, 68751, 68752)) ORDER BY FIND_IN_SET(id, '60251,68749,68750,68751,68752') 0.0035629272460938
(4) DESCRIBE `cruises` 0.0053060054779053
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60251') 0.00054192543029785
(6) DESCRIBE `ships` 0.0034399032592773
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00049996376037598
(8) DESCRIBE `ships` 0.003774881362915
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.0004580020904541
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033402442932129
(12) DESCRIBE `itineraries` 0.0020802021026611
(13) DESCRIBE `ports` 0.0020580291748047
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00045895576477051
(15) DESCRIBE `ports` 0.0023729801177979
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00046420097351074
(17) DESCRIBE `ports` 0.0021519660949707
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00047707557678223
(19) DESCRIBE `sailingdates` 0.0016100406646729
(20) DESCRIBE `ports` 0.0016939640045166
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00037908554077148
(22) DESCRIBE `ports` 0.00205397605896
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00055480003356934
(24) DESCRIBE `ports` 0.002357006072998
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 793))) 0.00048112869262695
(26) DESCRIBE `ports` 0.0020110607147217
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '793') 0.00042510032653809
(28) DESCRIBE `ports` 0.002061128616333
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00044989585876465
(30) DESCRIBE `ports` 0.0028350353240967
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00072717666625977
(32) DESCRIBE `ports` 0.0030879974365234
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.0031960010528564
(34) DESCRIBE `ports` 0.0026898384094238
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00044703483581543
(36) DESCRIBE `ports` 0.0019237995147705
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067019462585449
(38) DESCRIBE `ports` 0.0015249252319336
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.007267951965332
(40) DESCRIBE `ports` 0.0040199756622314
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063395500183105
(42) DESCRIBE `ports` 0.0026669502258301
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00058507919311523
(44) DESCRIBE `ports` 0.001802921295166
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057315826416016
(46) DESCRIBE `ports` 0.0019299983978271
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00049209594726562
(48) DESCRIBE `ports` 0.0026800632476807
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00091814994812012
(50) DESCRIBE `ports` 0.0026118755340576
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00057697296142578
(52) DESCRIBE `ports` 0.0031280517578125
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046491622924805
(54) DESCRIBE `ports` 0.0017590522766113
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040698051452637
(56) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60251') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.011505126953125
(57) DESCRIBE `avid_specials` 0.0018329620361328
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60251 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0019450187683105
(59) DESCRIBE `cruiselines` 0.002838134765625
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00056290626525879
(61) DESCRIBE `orchid_image` 0.0025129318237305
(62) DESCRIBE `cruiselines` 0.0029489994049072
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0018441677093506
(64) DESCRIBE `cruises` 0.0037441253662109
(65) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68749') 0.0005791187286377
(66) DESCRIBE `ships` 0.0053908824920654
(67) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00073814392089844
(68) DESCRIBE `ships` 0.006209135055542
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00058794021606445
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034308433532715
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032687187194824
(72) DESCRIBE `itineraries` 0.0057339668273926
(73) DESCRIBE `ports` 0.0024349689483643
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0031979084014893
(75) DESCRIBE `ports` 0.0023701190948486
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00052690505981445
(77) DESCRIBE `ports` 0.0021250247955322
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00042486190795898
(79) DESCRIBE `sailingdates` 0.0025391578674316
(80) DESCRIBE `ports` 0.0038769245147705
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0011870861053467
(82) DESCRIBE `ports` 0.0026280879974365
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00044608116149902
(84) DESCRIBE `ports` 0.0019001960754395
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.0020020008087158
(86) DESCRIBE `ports` 0.0034339427947998
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.0005190372467041
(88) DESCRIBE `ports` 0.0018260478973389
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00041985511779785
(90) DESCRIBE `ports` 0.0018479824066162
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00041818618774414
(92) DESCRIBE `ports` 0.0019099712371826
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00046205520629883
(94) DESCRIBE `ports` 0.0018770694732666
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00041294097900391
(96) DESCRIBE `ports` 0.002147912979126
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 3.4093856811523E-5
(98) DESCRIBE `ports` 0.0023231506347656
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00045490264892578
(100) DESCRIBE `ports` 0.0020301342010498
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00031805038452148
(102) DESCRIBE `ports` 0.0024189949035645
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00044107437133789
(104) DESCRIBE `ports` 0.0020179748535156
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0003359317779541
(106) DESCRIBE `ports` 0.0020480155944824
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00047206878662109
(108) DESCRIBE `ports` 0.0019409656524658
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00060915946960449
(110) DESCRIBE `ports` 0.002065896987915
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00067806243896484
(112) DESCRIBE `ports` 0.0019428730010986
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1921))) 0.00055694580078125
(114) DESCRIBE `ports` 0.0023400783538818
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1921') 0.00051093101501465
(116) DESCRIBE `ports` 0.0018911361694336
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0005190372467041
(118) DESCRIBE `ports` 0.0020830631256104
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00047397613525391
(120) DESCRIBE `ports` 0.0018851757049561
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00015592575073242
(122) DESCRIBE `ports` 0.002223014831543
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00043988227844238
(124) DESCRIBE `ports` 0.0024228096008301
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0019981861114502
(126) DESCRIBE `ports` 0.0019891262054443
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00051999092102051
(128) DESCRIBE `ports` 0.0017960071563721
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00049996376037598
(130) DESCRIBE `ports` 0.0018210411071777
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00047588348388672
(132) DESCRIBE `ports` 0.0064878463745117
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0040509700775146
(134) DESCRIBE `ports` 0.0040609836578369
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00057005882263184
(136) DESCRIBE `ports` 0.0020499229431152
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049281120300293
(138) DESCRIBE `ports` 0.0020678043365479
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00043797492980957
(140) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68749') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.0093429088592529
(141) DESCRIBE `avid_specials` 0.0018360614776611
(142) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68749 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.001964807510376
(143) DESCRIBE `cruiselines` 0.0026841163635254
(144) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0005488395690918
(145) DESCRIBE `orchid_image` 0.0027871131896973
(146) DESCRIBE `cruiselines` 0.003046989440918
(147) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00056695938110352
(148) DESCRIBE `cruises` 0.0082011222839355
(149) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68750') 0.00058698654174805
(150) DESCRIBE `ships` 0.0037569999694824
(151) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00065803527832031
(152) DESCRIBE `ships` 0.0039298534393311
(153) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00052595138549805
(154) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038504600524902
(155) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036501884460449
(156) DESCRIBE `itineraries` 0.0020098686218262
(157) DESCRIBE `ports` 0.0018830299377441
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00047588348388672
(159) DESCRIBE `ports` 0.0017518997192383
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049185752868652
(161) DESCRIBE `ports` 0.013897895812988
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00064611434936523
(163) DESCRIBE `sailingdates` 0.0079829692840576
(164) DESCRIBE `ports` 0.0023801326751709
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0009911060333252
(166) DESCRIBE `ports` 0.0023190975189209
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00051307678222656
(168) DESCRIBE `ports` 0.0019741058349609
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00054311752319336
(170) DESCRIBE `ports` 0.005605936050415
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00058889389038086
(172) DESCRIBE `ports` 0.0025370121002197
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00059413909912109
(174) DESCRIBE `ports` 0.0020499229431152
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00058293342590332
(176) DESCRIBE `ports` 0.0028350353240967
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00059914588928223
(178) DESCRIBE `ports` 0.0029890537261963
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00052809715270996
(180) DESCRIBE `ports` 0.0020279884338379
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0012140274047852
(182) DESCRIBE `ports` 0.0032539367675781
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00050210952758789
(184) DESCRIBE `ports` 0.0017068386077881
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0012309551239014
(186) DESCRIBE `ports` 0.002202033996582
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00059008598327637
(188) DESCRIBE `ports` 0.0060739517211914
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00055503845214844
(190) DESCRIBE `ports` 0.0049889087677002
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00041699409484863
(192) DESCRIBE `ports` 0.0018060207366943
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1921))) 0.00054597854614258
(194) DESCRIBE `ports` 0.0020308494567871
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1921') 0.00064206123352051
(196) DESCRIBE `ports` 0.0020310878753662
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00055289268493652
(198) DESCRIBE `ports` 0.0019969940185547
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00055599212646484
(200) DESCRIBE `ports` 0.0020859241485596
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00052905082702637
(202) DESCRIBE `ports` 0.02226185798645
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00061416625976562
(204) DESCRIBE `ports` 0.011433124542236
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00067305564880371
(206) DESCRIBE `ports` 0.0021741390228271
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00051498413085938
(208) DESCRIBE `ports` 0.0020449161529541
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1919))) 0.00062799453735352
(210) DESCRIBE `ports` 0.002129077911377
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1919') 0.00050592422485352
(212) DESCRIBE `ports` 0.0020592212677002
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00058388710021973
(214) DESCRIBE `ports` 0.0021319389343262
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00050806999206543
(216) DESCRIBE `ports` 0.0020639896392822
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00049400329589844
(218) DESCRIBE `ports` 0.0019800662994385
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00046896934509277
(220) DESCRIBE `ports` 0.002018928527832
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053596496582031
(222) DESCRIBE `ports` 0.0067968368530273
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053787231445312
(224) DESCRIBE `ports` 0.0019960403442383
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059890747070312
(226) DESCRIBE `ports` 0.0027949810028076
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0016639232635498
(228) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68750') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.049990892410278
(229) DESCRIBE `avid_specials` 0.00199294090271
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68750 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0024919509887695
(231) DESCRIBE `cruiselines` 0.0050091743469238
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.010265827178955
(233) DESCRIBE `orchid_image` 0.0033228397369385
(234) DESCRIBE `cruiselines` 0.0049371719360352
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00029897689819336
(236) DESCRIBE `cruises` 0.0070819854736328
(237) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68751') 0.00057101249694824
(238) DESCRIBE `ships` 0.0036029815673828
(239) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.0005948543548584
(240) DESCRIBE `ships` 0.004486083984375
(241) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00048208236694336
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035905838012695
(244) DESCRIBE `itineraries` 0.0051419734954834
(245) DESCRIBE `ports` 0.0016248226165771
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052094459533691
(247) DESCRIBE `ports` 0.0021028518676758
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057482719421387
(249) DESCRIBE `ports` 0.0027949810028076
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00069999694824219
(251) DESCRIBE `sailingdates` 0.0030169486999512
(252) DESCRIBE `ports` 0.0056400299072266
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067305564880371
(254) DESCRIBE `ports` 0.0024490356445312
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045394897460938
(256) DESCRIBE `ports` 0.002108097076416
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00062298774719238
(258) DESCRIBE `ports` 0.0025050640106201
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0005190372467041
(260) DESCRIBE `ports` 0.0019030570983887
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00071191787719727
(262) DESCRIBE `ports` 0.0019149780273438
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0004420280456543
(264) DESCRIBE `ports` 0.0018789768218994
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00097012519836426
(266) DESCRIBE `ports` 0.0020761489868164
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00056099891662598
(268) DESCRIBE `ports` 0.0021250247955322
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00062394142150879
(270) DESCRIBE `ports` 0.0068130493164062
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00063490867614746
(272) DESCRIBE `ports` 0.010090827941895
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00058388710021973
(274) DESCRIBE `ports` 0.0022318363189697
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00063610076904297
(276) DESCRIBE `ports` 0.0020198822021484
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1472))) 0.00053620338439941
(278) DESCRIBE `ports` 0.0099458694458008
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1472') 0.00058984756469727
(280) DESCRIBE `ports` 0.0052549839019775
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00081181526184082
(282) DESCRIBE `ports` 0.0032329559326172
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00059890747070312
(284) DESCRIBE `ports` 0.003087043762207
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00056886672973633
(286) DESCRIBE `ports` 0.0029549598693848
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0004270076751709
(288) DESCRIBE `ports` 0.0056748390197754
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00050711631774902
(290) DESCRIBE `ports` 0.0019738674163818
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00048589706420898
(292) DESCRIBE `ports` 0.0023579597473145
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00053191184997559
(294) DESCRIBE `ports` 0.0018517971038818
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046706199645996
(296) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68751') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.017606019973755
(297) DESCRIBE `avid_specials` 0.0046660900115967
(298) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68751 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0025629997253418
(299) DESCRIBE `cruiselines` 0.0030560493469238
(300) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0015780925750732
(301) DESCRIBE `orchid_image` 0.0021460056304932
(302) DESCRIBE `cruiselines` 0.0057380199432373
(303) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00066304206848145
(304) DESCRIBE `cruises` 0.0057442188262939
(305) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68752') 0.00080513954162598
(306) DESCRIBE `ships` 0.0040230751037598
(307) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.0014700889587402
(308) DESCRIBE `ships` 0.0050320625305176
(309) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00065302848815918
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037217140197754
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 4.887580871582E-5
(312) DESCRIBE `itineraries` 0.0020880699157715
(313) DESCRIBE `ports` 0.0040369033813477
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00094914436340332
(315) DESCRIBE `ports` 0.002068042755127
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00053906440734863
(317) DESCRIBE `ports` 0.0022070407867432
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00047779083251953
(319) DESCRIBE `sailingdates` 0.0016729831695557
(320) DESCRIBE `ports` 0.0025460720062256
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00057005882263184
(322) DESCRIBE `ports` 0.0058848857879639
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0060660839080811
(324) DESCRIBE `ports` 0.0038049221038818
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00069594383239746
(326) DESCRIBE `ports` 0.002223014831543
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00045299530029297
(328) DESCRIBE `ports` 0.0023829936981201
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00055599212646484
(330) DESCRIBE `ports` 0.002406120300293
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0005190372467041
(332) DESCRIBE `ports` 0.0022408962249756
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00052094459533691
(334) DESCRIBE `ports` 0.0018601417541504
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00043296813964844
(336) DESCRIBE `ports` 0.0020210742950439
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00047993659973145
(338) DESCRIBE `ports` 0.0019359588623047
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0004429817199707
(340) DESCRIBE `ports` 0.001971960067749
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 3.8862228393555E-5
(342) DESCRIBE `ports` 0.0020580291748047
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055193901062012
(344) DESCRIBE `ports` 0.0020110607147217
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00052404403686523
(346) DESCRIBE `ports` 0.002000093460083
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00050210952758789
(348) DESCRIBE `ports` 0.0015561580657959
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.0010030269622803
(350) DESCRIBE `ports` 0.0018229484558105
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00049710273742676
(352) DESCRIBE `ports` 0.0018019676208496
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00047397613525391
(354) DESCRIBE `ports` 0.0019640922546387
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00046396255493164
(356) DESCRIBE `ports` 0.0019218921661377
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00049400329589844
(358) DESCRIBE `ports` 0.0019149780273438
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00047588348388672
(360) DESCRIBE `ports` 0.0019199848175049
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00067591667175293
(362) DESCRIBE `ports` 0.0021569728851318
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00055193901062012
(364) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68752') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.0095419883728027
(365) DESCRIBE `avid_specials` 0.0016510486602783
(366) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68752 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0018689632415771
(367) DESCRIBE `cruiselines` 0.0026991367340088
(368) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0010359287261963
(369) DESCRIBE `orchid_image` 0.002032995223999
(370) DESCRIBE `cruiselines` 0.0020179748535156
(371) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0
(372) DESCRIBE `cruisetypes` 0.0017790794372559
(373) DESCRIBE `destinations` 0.0024218559265137
(374) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00084900856018066
(375) DESCRIBE `cruiselines` 0.0029451847076416
(376) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00018715858459473
(377) DESCRIBE `ships` 0.0039899349212646
(378) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00075697898864746
(379) DESCRIBE `cruiselines` 0.0034089088439941
(380) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00062203407287598
(381) DESCRIBE `ships` 0.0039949417114258
(382) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00079894065856934