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

Total elapsed time: 0.57428359985352

# Query Time
(1) connect 0.0011289119720459
(2) DESCRIBE `cruises` 0.0033810138702393
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (52894, 67295, 66008, 65888, 50857, 56045, 70891, 41778, 70930, 63401)) ORDER BY FIND_IN_SET(id, '52894,67295,66008,65888,50857,56045,70891,41778,70930,63401') 0.0019400119781494
(4) DESCRIBE `cruises` 0.0035550594329834
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52894') 0.00052309036254883
(6) DESCRIBE `ships` 0.0035579204559326
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00061297416687012
(8) DESCRIBE `ships` 0.0035860538482666
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00052094459533691
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(12) DESCRIBE `itineraries` 0.0015661716461182
(13) DESCRIBE `ports` 0.00211501121521
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045084953308105
(15) DESCRIBE `ports` 0.0016331672668457
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041508674621582
(17) DESCRIBE `ports` 0.0016510486602783
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054812431335449
(19) DESCRIBE `sailingdates` 0.0016088485717773
(20) DESCRIBE `ports` 0.0018091201782227
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046801567077637
(22) DESCRIBE `ports` 0.0015840530395508
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042486190795898
(24) DESCRIBE `ports` 0.0019059181213379
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041604042053223
(26) DESCRIBE `ports` 0.0017590522766113
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019311904907227
(28) DESCRIBE `ports` 0.0018501281738281
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00078892707824707
(30) DESCRIBE `ports` 0.0015988349914551
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00041580200195312
(32) DESCRIBE `ports` 0.0016701221466064
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0004417896270752
(34) DESCRIBE `ports` 0.0017240047454834
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00034999847412109
(36) DESCRIBE `ports` 0.0018389225006104
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00043082237243652
(38) DESCRIBE `ports` 0.001446008682251
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00041985511779785
(40) DESCRIBE `ports` 0.001568078994751
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045204162597656
(42) DESCRIBE `ports` 0.0019121170043945
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044584274291992
(44) DESCRIBE `avid_specials` 0.001788854598999
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52894 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018408298492432
(46) DESCRIBE `cruiselines` 0.0029470920562744
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00050997734069824
(48) DESCRIBE `orchid_image` 0.0020499229431152
(49) DESCRIBE `cruiselines` 0.0024669170379639
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040793418884277
(51) DESCRIBE `cruises` 0.0027961730957031
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67295') 0.00051712989807129
(53) DESCRIBE `ships` 0.003838062286377
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00055313110351562
(55) DESCRIBE `ships` 0.0029771327972412
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046801567077637
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(59) DESCRIBE `itineraries` 0.001986026763916
(60) DESCRIBE `ports` 0.0021860599517822
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053501129150391
(62) DESCRIBE `ports` 0.0021109580993652
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057697296142578
(64) DESCRIBE `ports` 0.0020449161529541
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044703483581543
(66) DESCRIBE `sailingdates` 0.0015950202941895
(67) DESCRIBE `ports` 0.0021040439605713
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044083595275879
(69) DESCRIBE `ports` 0.0016891956329346
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041508674621582
(71) DESCRIBE `ports` 0.001488208770752
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00037693977355957
(73) DESCRIBE `ports` 0.0014181137084961
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00030994415283203
(75) DESCRIBE `ports` 0.0013320446014404
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00031495094299316
(77) DESCRIBE `ports` 0.0013790130615234
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00048685073852539
(79) DESCRIBE `ports` 0.0021200180053711
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0005180835723877
(81) DESCRIBE `ports` 0.0019741058349609
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0009009838104248
(83) DESCRIBE `ports` 0.0016188621520996
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034403800964355
(85) DESCRIBE `ports` 0.0017199516296387
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041604042053223
(87) DESCRIBE `avid_specials` 0.0015840530395508
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67295 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015239715576172
(89) DESCRIBE `cruiselines` 0.002575159072876
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00050783157348633
(91) DESCRIBE `orchid_image` 0.0022029876708984
(92) DESCRIBE `cruiselines` 0.003061056137085
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00090909004211426
(94) DESCRIBE `cruises` 0.0040230751037598
(95) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66008') 0.00061511993408203
(96) DESCRIBE `ships` 0.0040009021759033
(97) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00060701370239258
(98) DESCRIBE `ships` 0.0032551288604736
(99) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00052785873413086
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(102) DESCRIBE `itineraries` 0.0015888214111328
(103) DESCRIBE `ports` 0.001640796661377
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037813186645508
(105) DESCRIBE `ports` 0.0015640258789062
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(107) DESCRIBE `ports` 0.0015430450439453
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030708312988281
(109) DESCRIBE `sailingdates` 0.0013129711151123
(110) DESCRIBE `ports` 0.0015170574188232
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044488906860352
(112) DESCRIBE `ports` 0.0019001960754395
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043892860412598
(114) DESCRIBE `ports` 0.0017688274383545
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044894218444824
(116) DESCRIBE `ports` 0.0018668174743652
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040698051452637
(118) DESCRIBE `ports` 0.0016560554504395
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00068998336791992
(120) DESCRIBE `ports` 0.0025880336761475
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.0004580020904541
(122) DESCRIBE `ports` 0.0017991065979004
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00052309036254883
(124) DESCRIBE `ports` 0.0016088485717773
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00020480155944824
(126) DESCRIBE `ports` 0.0021970272064209
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00054502487182617
(128) DESCRIBE `ports` 0.0019631385803223
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00089097023010254
(130) DESCRIBE `ports` 0.0019819736480713
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00042104721069336
(132) DESCRIBE `ports` 0.0018398761749268
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00039196014404297
(134) DESCRIBE `ports` 0.0016450881958008
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052189826965332
(136) DESCRIBE `ports` 0.0020511150360107
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00069904327392578
(138) DESCRIBE `avid_specials` 0.0012519359588623
(139) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66008 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011909008026123
(140) DESCRIBE `cruiselines` 0.0031309127807617
(141) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0
(142) DESCRIBE `orchid_image` 0.0025129318237305
(143) DESCRIBE `cruiselines` 0.0028460025787354
(144) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032305717468262
(145) DESCRIBE `cruises` 0.0040872097015381
(146) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65888') 0.0002131462097168
(147) DESCRIBE `ships` 0.0039260387420654
(148) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00077486038208008
(149) DESCRIBE `ships` 0.0035319328308105
(150) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00012588500976562
(151) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 6.6041946411133E-5
(152) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032305717468262
(153) DESCRIBE `itineraries` 0.0013399124145508
(154) DESCRIBE `ports` 0.0019969940185547
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004429817199707
(156) DESCRIBE `ports` 0.0018460750579834
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041389465332031
(158) DESCRIBE `ports` 0.0020568370819092
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036191940307617
(160) DESCRIBE `sailingdates` 0.0016350746154785
(161) DESCRIBE `ports` 0.0021300315856934
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(163) DESCRIBE `ports` 0.0017609596252441
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032496452331543
(165) DESCRIBE `ports` 0.0015699863433838
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00041413307189941
(167) DESCRIBE `ports` 0.0018658638000488
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00049901008605957
(169) DESCRIBE `ports` 0.0027861595153809
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00050997734069824
(171) DESCRIBE `ports` 0.0018610954284668
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00031018257141113
(173) DESCRIBE `ports` 0.0013940334320068
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032305717468262
(175) DESCRIBE `ports` 0.002777099609375
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00047183036804199
(177) DESCRIBE `ports` 0.0020110607147217
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044608116149902
(179) DESCRIBE `ports` 0.0018539428710938
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040197372436523
(181) DESCRIBE `ports` 0.0017931461334229
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040602684020996
(183) DESCRIBE `ports` 0.0015969276428223
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037312507629395
(185) DESCRIBE `avid_specials` 0.0019991397857666
(186) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65888 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017960071563721
(187) DESCRIBE `cruiselines` 0.0030031204223633
(188) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00047802925109863
(189) DESCRIBE `orchid_image` 0.001945972442627
(190) DESCRIBE `cruiselines` 0.002227783203125
(191) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00033903121948242
(192) DESCRIBE `cruises` 0.0031471252441406
(193) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00041604042053223
(194) DESCRIBE `ships` 0.0032238960266113
(195) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00043988227844238
(196) DESCRIBE `ships` 0.0033841133117676
(197) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00050711631774902
(198) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038003921508789
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028896331787109
(200) DESCRIBE `itineraries` 0.0015530586242676
(201) DESCRIBE `ports` 0.0021600723266602
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039815902709961
(203) DESCRIBE `ports` 0.0019798278808594
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046896934509277
(205) DESCRIBE `ports` 0.0020220279693604
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041294097900391
(207) DESCRIBE `sailingdates` 0.0016348361968994
(208) DESCRIBE `ports` 0.0029809474945068
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047397613525391
(210) DESCRIBE `ports` 0.001615047454834
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032901763916016
(212) DESCRIBE `ports` 0.0025160312652588
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044083595275879
(214) DESCRIBE `ports` 0.0018410682678223
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0003812313079834
(216) DESCRIBE `ports` 0.0016820430755615
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00046181678771973
(218) DESCRIBE `ports` 0.0024068355560303
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00047206878662109
(220) DESCRIBE `ports` 0.0015249252319336
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00032305717468262
(222) DESCRIBE `ports` 0.0014410018920898
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028085708618164
(224) DESCRIBE `ports` 0.0016298294067383
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032687187194824
(226) DESCRIBE `ports` 0.0015690326690674
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00038695335388184
(228) DESCRIBE `ports` 0.0015490055084229
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043988227844238
(230) DESCRIBE `ports` 0.0016989707946777
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031304359436035
(232) DESCRIBE `avid_specials` 0.0013060569763184
(233) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011789798736572
(234) DESCRIBE `cruiselines` 0.0024170875549316
(235) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00050115585327148
(236) DESCRIBE `orchid_image` 0.0026819705963135
(237) DESCRIBE `cruiselines` 0.0021240711212158
(238) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00039315223693848
(239) DESCRIBE `cruises` 0.0034658908843994
(240) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56045') 0.00040793418884277
(241) DESCRIBE `ships` 0.0036048889160156
(242) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00048685073852539
(243) DESCRIBE `ships` 0.013730049133301
(244) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00050902366638184
(245) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028800964355469
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029301643371582
(247) DESCRIBE `itineraries` 0.001471996307373
(248) DESCRIBE `ports` 0.0014979839324951
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036787986755371
(250) DESCRIBE `ports` 0.0018160343170166
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041389465332031
(252) DESCRIBE `ports` 0.0016379356384277
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034999847412109
(254) DESCRIBE `sailingdates` 0.0012969970703125
(255) DESCRIBE `ports` 0.0016548633575439
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038504600524902
(257) DESCRIBE `ports` 0.0018188953399658
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003669261932373
(259) DESCRIBE `ports` 0.0018200874328613
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00048208236694336
(261) DESCRIBE `ports` 0.0017030239105225
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00037598609924316
(263) DESCRIBE `ports` 0.0014119148254395
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00046205520629883
(265) DESCRIBE `ports` 0.0018880367279053
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00043582916259766
(267) DESCRIBE `ports` 0.0019550323486328
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00052213668823242
(269) DESCRIBE `ports` 0.0016200542449951
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.000518798828125
(271) DESCRIBE `ports` 0.0018470287322998
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048398971557617
(273) DESCRIBE `ports` 0.0019519329071045
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044894218444824
(275) DESCRIBE `avid_specials` 0.0016927719116211
(276) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56045 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018041133880615
(277) DESCRIBE `cruiselines` 0.0027909278869629
(278) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00052404403686523
(279) DESCRIBE `orchid_image` 0.0021560192108154
(280) DESCRIBE `cruiselines` 0.0027980804443359
(281) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00048589706420898
(282) DESCRIBE `cruises` 0.0037140846252441
(283) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70891') 0.00053095817565918
(284) DESCRIBE `ships` 0.0037481784820557
(285) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00058317184448242
(286) DESCRIBE `ships` 0.0038330554962158
(287) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00046801567077637
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044608116149902
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033092498779297
(290) DESCRIBE `itineraries` 0.0018250942230225
(291) DESCRIBE `ports` 0.0019369125366211
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058603286743164
(293) DESCRIBE `ports` 0.0019559860229492
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047683715820312
(295) DESCRIBE `ports` 0.0018839836120605
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044417381286621
(297) DESCRIBE `sailingdates` 0.0015921592712402
(298) DESCRIBE `ports` 0.0019829273223877
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055098533630371
(300) DESCRIBE `ports` 0.0019669532775879
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042986869812012
(302) DESCRIBE `ports` 0.0019869804382324
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00038695335388184
(304) DESCRIBE `ports` 0.0018889904022217
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00041294097900391
(306) DESCRIBE `ports` 0.0018131732940674
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0004420280456543
(308) DESCRIBE `ports` 0.0017991065979004
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00042319297790527
(310) DESCRIBE `ports` 0.0017800331115723
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00044107437133789
(312) DESCRIBE `ports` 0.0018720626831055
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00043201446533203
(314) DESCRIBE `avid_specials` 0.0017020702362061
(315) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70891 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018789768218994
(316) DESCRIBE `cruiselines` 0.0026431083679199
(317) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00051307678222656
(318) DESCRIBE `orchid_image` 0.0020239353179932
(319) DESCRIBE `cruiselines` 0.0027229785919189
(320) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00044608116149902
(321) DESCRIBE `cruises` 0.003511905670166
(322) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00043201446533203
(323) DESCRIBE `ships` 0.0035440921783447
(324) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00052809715270996
(325) DESCRIBE `ships` 0.0034871101379395
(326) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00041890144348145
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003058910369873
(328) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(329) DESCRIBE `itineraries` 0.0016839504241943
(330) DESCRIBE `ports` 0.0016591548919678
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039315223693848
(332) DESCRIBE `ports` 0.0016739368438721
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037693977355957
(334) DESCRIBE `ports` 0.0017309188842773
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037884712219238
(336) DESCRIBE `sailingdates` 0.0015699863433838
(337) DESCRIBE `ports` 0.0018270015716553
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004878044128418
(339) DESCRIBE `ports` 0.0014491081237793
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029802322387695
(341) DESCRIBE `ports` 0.0012569427490234
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036406517028809
(343) DESCRIBE `ports` 0.0013198852539062
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031495094299316
(345) DESCRIBE `avid_specials` 0.0012178421020508
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010390281677246
(347) DESCRIBE `cruiselines` 0.0019798278808594
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034999847412109
(349) DESCRIBE `orchid_image` 0.0018692016601562
(350) DESCRIBE `cruiselines` 0.0024349689483643
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00038695335388184
(352) DESCRIBE `cruises` 0.0031781196594238
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70930') 0.00039505958557129
(354) DESCRIBE `ships` 0.0028228759765625
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00052690505981445
(356) DESCRIBE `ships` 0.0035970211029053
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00053501129150391
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(360) DESCRIBE `itineraries` 0.0017478466033936
(361) DESCRIBE `ports` 0.0015568733215332
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036191940307617
(363) DESCRIBE `ports` 0.001676082611084
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003511905670166
(365) DESCRIBE `ports` 0.0014538764953613
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031495094299316
(367) DESCRIBE `sailingdates` 0.001183032989502
(368) DESCRIBE `ports` 0.0018839836120605
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037407875061035
(370) DESCRIBE `ports` 0.0015978813171387
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032186508178711
(372) DESCRIBE `ports` 0.0012850761413574
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00034189224243164
(374) DESCRIBE `ports` 0.001270055770874
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028491020202637
(376) DESCRIBE `ports` 0.0014231204986572
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00030899047851562
(378) DESCRIBE `ports` 0.0012650489807129
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0003049373626709
(380) DESCRIBE `ports` 0.0013360977172852
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00035381317138672
(382) DESCRIBE `ports` 0.0012569427490234
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028085708618164
(384) DESCRIBE `ports` 0.0013518333435059
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031185150146484
(386) DESCRIBE `ports` 0.0013301372528076
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00029897689819336
(388) DESCRIBE `ports` 0.0012989044189453
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003509521484375
(390) DESCRIBE `ports` 0.0015771389007568
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030303001403809
(392) DESCRIBE `avid_specials` 0.0011289119720459
(393) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70930 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011248588562012
(394) DESCRIBE `cruiselines` 0.002223014831543
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00041985511779785
(396) DESCRIBE `orchid_image` 0.0015640258789062
(397) DESCRIBE `cruiselines` 0.0019669532775879
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032901763916016
(399) DESCRIBE `cruises` 0.0025110244750977
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63401') 0.00045895576477051
(401) DESCRIBE `ships` 0.0026230812072754
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00036096572875977
(403) DESCRIBE `ships` 0.002532958984375
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00030994415283203
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(407) DESCRIBE `itineraries` 0.0015490055084229
(408) DESCRIBE `ports` 0.0016148090362549
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037288665771484
(410) DESCRIBE `ports` 0.0016789436340332
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046682357788086
(412) DESCRIBE `ports` 0.0014610290527344
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030684471130371
(414) DESCRIBE `sailingdates` 0.0013399124145508
(415) DESCRIBE `ports` 0.0016310214996338
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00042319297790527
(417) DESCRIBE `ports` 0.001568078994751
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031304359436035
(419) DESCRIBE `ports` 0.0013189315795898
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00036287307739258
(421) DESCRIBE `ports` 0.0014441013336182
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0003209114074707
(423) DESCRIBE `ports` 0.0012609958648682
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00042104721069336
(425) DESCRIBE `ports` 0.0017030239105225
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033807754516602
(427) DESCRIBE `avid_specials` 0.0011670589447021
(428) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63401 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010969638824463
(429) DESCRIBE `cruiselines` 0.0019609928131104
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00041604042053223
(431) DESCRIBE `orchid_image` 0.0015189647674561
(432) DESCRIBE `cruiselines` 0.001924991607666
(433) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00039505958557129
(434) DESCRIBE `ships` 0.0030069351196289
(435) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722', '288')) ORDER BY FIND_IN_SET(id, '4,1722,288') 0.00087213516235352
(436) DESCRIBE `cruisetypes` 0.0013120174407959
(437) DESCRIBE `destinations` 0.0017387866973877
(438) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.0005948543548584
(439) DESCRIBE `cruiselines` 0.0019638538360596
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036001205444336
(441) DESCRIBE `cruiselines` 0.0021579265594482
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00038695335388184