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

Total elapsed time: 0.47951984405518

# Query Time
(1) connect 0.00085091590881348
(2) DESCRIBE `cruises` 0.0028479099273682
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41778, 70930, 63401, 70892, 63374, 70895, 63373, 70897, 55703, 70932)) ORDER BY FIND_IN_SET(id, '41778,70930,63401,70892,63374,70895,63373,70897,55703,70932') 0.00071120262145996
(4) DESCRIBE `cruises` 0.003087043762207
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00028109550476074
(6) DESCRIBE `ships` 0.002561092376709
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00037097930908203
(8) DESCRIBE `ships` 0.0026371479034424
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0011560916900635
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028586387634277
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002591609954834
(12) DESCRIBE `itineraries` 0.0013859272003174
(13) DESCRIBE `ports` 0.0013461112976074
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036501884460449
(15) DESCRIBE `ports` 0.0014951229095459
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029516220092773
(17) DESCRIBE `ports` 0.0012319087982178
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041294097900391
(19) DESCRIBE `sailingdates` 0.0011699199676514
(20) DESCRIBE `ports` 0.001471996307373
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036716461181641
(22) DESCRIBE `ports` 0.0016679763793945
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036978721618652
(24) DESCRIBE `ports` 0.0013539791107178
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033783912658691
(26) DESCRIBE `ports` 0.0012729167938232
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(28) DESCRIBE `avid_specials` 0.0012271404266357
(29) 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.0010180473327637
(30) DESCRIBE `cruiselines` 0.0018329620361328
(31) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030994415283203
(32) DESCRIBE `orchid_image` 0.0014009475708008
(33) DESCRIBE `cruiselines` 0.0018961429595947
(34) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029897689819336
(35) DESCRIBE `cruises` 0.0029709339141846
(36) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70930') 0.00034499168395996
(37) DESCRIBE `ships` 0.002561092376709
(38) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00037598609924316
(39) DESCRIBE `ships` 0.002856969833374
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00032305717468262
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002601146697998
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024890899658203
(43) DESCRIBE `itineraries` 0.0012650489807129
(44) DESCRIBE `ports` 0.0014948844909668
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(46) DESCRIBE `ports` 0.0013179779052734
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028181076049805
(48) DESCRIBE `ports` 0.0016820430755615
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029587745666504
(50) DESCRIBE `sailingdates` 0.0012590885162354
(51) DESCRIBE `ports` 0.0012600421905518
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030207633972168
(53) DESCRIBE `ports` 0.0012400150299072
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00097012519836426
(55) DESCRIBE `ports` 0.00073385238647461
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00030994415283203
(57) DESCRIBE `ports` 0.0016040802001953
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 2.6941299438477E-5
(59) DESCRIBE `ports` 0.0012691020965576
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00031399726867676
(61) DESCRIBE `ports` 0.0014898777008057
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027990341186523
(63) DESCRIBE `ports` 0.0012719631195068
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00027799606323242
(65) DESCRIBE `ports` 0.0013120174407959
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00026202201843262
(67) DESCRIBE `ports` 0.001305103302002
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00030398368835449
(69) DESCRIBE `ports` 0.001255989074707
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00027608871459961
(71) DESCRIBE `ports` 0.0012969970703125
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002899169921875
(73) DESCRIBE `ports` 0.0013020038604736
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026798248291016
(75) DESCRIBE `avid_specials` 0.0011739730834961
(76) 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.0010859966278076
(77) DESCRIBE `cruiselines` 0.0021200180053711
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00033807754516602
(79) DESCRIBE `orchid_image` 0.0015649795532227
(80) DESCRIBE `cruiselines` 0.0021071434020996
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032806396484375
(82) DESCRIBE `cruises` 0.0029668807983398
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63401') 0.00034117698669434
(84) DESCRIBE `ships` 0.0026040077209473
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00036001205444336
(86) DESCRIBE `ships` 0.002471923828125
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00059199333190918
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032782554626465
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(90) DESCRIBE `itineraries` 0.0018808841705322
(91) DESCRIBE `ports` 0.0015771389007568
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003819465637207
(93) DESCRIBE `ports` 0.0013689994812012
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031399726867676
(95) DESCRIBE `ports` 0.0013389587402344
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029516220092773
(97) DESCRIBE `sailingdates` 0.0012180805206299
(98) DESCRIBE `ports` 0.0014281272888184
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046706199645996
(100) DESCRIBE `ports` 0.0018739700317383
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00036907196044922
(102) DESCRIBE `ports` 0.0013267993927002
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00037097930908203
(104) DESCRIBE `ports` 0.0013530254364014
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00035500526428223
(106) DESCRIBE `ports` 0.0014429092407227
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00082302093505859
(108) DESCRIBE `ports` 0.0011839866638184
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027894973754883
(110) DESCRIBE `avid_specials` 0.0012099742889404
(111) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63401 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012929439544678
(112) DESCRIBE `cruiselines` 0.0022869110107422
(113) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037193298339844
(114) DESCRIBE `orchid_image` 0.0018010139465332
(115) DESCRIBE `cruiselines` 0.0020132064819336
(116) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00035285949707031
(117) DESCRIBE `cruises` 0.0030698776245117
(118) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70892') 0.00049090385437012
(119) DESCRIBE `ships` 0.0033609867095947
(120) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00042510032653809
(121) DESCRIBE `ships` 0.0029299259185791
(122) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00037312507629395
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(125) DESCRIBE `itineraries` 0.0013659000396729
(126) DESCRIBE `ports` 0.0014541149139404
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00034379959106445
(128) DESCRIBE `ports` 0.0013630390167236
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031709671020508
(130) DESCRIBE `ports` 0.0013840198516846
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029993057250977
(132) DESCRIBE `sailingdates` 0.0011718273162842
(133) DESCRIBE `ports` 0.0016510486602783
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0004880428314209
(135) DESCRIBE `ports` 0.0018899440765381
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004270076751709
(137) DESCRIBE `ports` 0.0017910003662109
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041699409484863
(139) DESCRIBE `ports` 0.0018861293792725
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040698051452637
(141) DESCRIBE `ports` 0.0018470287322998
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00043392181396484
(143) DESCRIBE `ports` 0.0017919540405273
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00038409233093262
(145) DESCRIBE `ports` 0.0017781257629395
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00048398971557617
(147) DESCRIBE `ports` 0.0018939971923828
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004878044128418
(149) DESCRIBE `avid_specials` 0.001633882522583
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70892 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.0016789436340332
(151) DESCRIBE `cruiselines` 0.0026049613952637
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00046396255493164
(153) DESCRIBE `orchid_image` 0.0019259452819824
(154) DESCRIBE `cruiselines` 0.002471923828125
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032305717468262
(156) DESCRIBE `cruises` 0.0030689239501953
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63374') 0.00036716461181641
(158) DESCRIBE `ships` 0.0027539730072021
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0003809928894043
(160) DESCRIBE `ships` 0.0033221244812012
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0008389949798584
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015807151794434
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002598762512207
(164) DESCRIBE `itineraries` 0.001460075378418
(165) DESCRIBE `ports` 0.0015039443969727
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040912628173828
(167) DESCRIBE `ports` 0.0016200542449951
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031495094299316
(169) DESCRIBE `ports` 0.0013599395751953
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029802322387695
(171) DESCRIBE `sailingdates` 0.0012271404266357
(172) DESCRIBE `ports` 0.0014472007751465
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037908554077148
(174) DESCRIBE `ports` 0.0014529228210449
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042009353637695
(176) DESCRIBE `ports` 0.001471996307373
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00032401084899902
(178) DESCRIBE `ports` 0.0014419555664062
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00027799606323242
(180) DESCRIBE `ports` 0.0012738704681396
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00029706954956055
(182) DESCRIBE `ports` 0.0013217926025391
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00028014183044434
(184) DESCRIBE `ports` 0.001284122467041
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033402442932129
(186) DESCRIBE `ports` 0.0013878345489502
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00030612945556641
(188) DESCRIBE `ports` 0.001417875289917
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0011179447174072
(190) DESCRIBE `ports` 0.0016980171203613
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00036120414733887
(192) DESCRIBE `ports` 0.0015089511871338
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058698654174805
(194) DESCRIBE `ports` 0.0014100074768066
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031018257141113
(196) DESCRIBE `avid_specials` 0.0018978118896484
(197) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63374 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.00073504447937012
(198) DESCRIBE `cruiselines` 0.0023581981658936
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0002748966217041
(200) DESCRIBE `orchid_image` 0.0014359951019287
(201) DESCRIBE `cruiselines` 0.0017609596252441
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027608871459961
(203) DESCRIBE `cruises` 0.0023801326751709
(204) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70895') 0.00030708312988281
(205) DESCRIBE `ships` 0.0026230812072754
(206) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00039911270141602
(207) DESCRIBE `ships` 0.002795934677124
(208) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00040602684020996
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036096572875977
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033688545227051
(211) DESCRIBE `itineraries` 0.0016980171203613
(212) DESCRIBE `ports` 0.0013611316680908
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00035500526428223
(214) DESCRIBE `ports` 0.0012638568878174
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043201446533203
(216) DESCRIBE `ports` 0.0015249252319336
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00034999847412109
(218) DESCRIBE `sailingdates` 0.0014472007751465
(219) DESCRIBE `ports` 0.0019299983978271
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00045514106750488
(221) DESCRIBE `ports` 0.0018131732940674
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0
(223) DESCRIBE `ports` 0.0016570091247559
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0
(225) DESCRIBE `ports` 0.001917839050293
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0012381076812744
(227) DESCRIBE `ports` 0.0014290809631348
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00044417381286621
(229) DESCRIBE `ports` 0.001716136932373
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00029397010803223
(231) DESCRIBE `ports` 0.0012948513031006
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00034284591674805
(233) DESCRIBE `ports` 0.0013110637664795
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00030207633972168
(235) DESCRIBE `ports` 0.0012829303741455
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00032806396484375
(237) DESCRIBE `ports` 0.0012979507446289
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00032186508178711
(239) DESCRIBE `ports` 0.0012879371643066
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0003349781036377
(241) DESCRIBE `ports` 0.0015711784362793
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00039792060852051
(243) DESCRIBE `ports` 0.0013048648834229
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00034499168395996
(245) DESCRIBE `ports` 0.0014240741729736
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029897689819336
(247) DESCRIBE `avid_specials` 0.0011222362518311
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70895 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.0012040138244629
(249) DESCRIBE `cruiselines` 0.0021741390228271
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003969669342041
(251) DESCRIBE `orchid_image` 0.001615047454834
(252) DESCRIBE `cruiselines` 0.0020620822906494
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00033092498779297
(254) DESCRIBE `cruises` 0.0025179386138916
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63373') 0.00030803680419922
(256) DESCRIBE `ships` 0.0028839111328125
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00056719779968262
(258) DESCRIBE `ships` 0.0031628608703613
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00034689903259277
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029706954956055
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(262) DESCRIBE `itineraries` 0.0013270378112793
(263) DESCRIBE `ports` 0.0013358592987061
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033187866210938
(265) DESCRIBE `ports` 0.0012979507446289
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029492378234863
(267) DESCRIBE `ports` 0.0012960433959961
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029897689819336
(269) DESCRIBE `sailingdates` 0.0011460781097412
(270) DESCRIBE `ports` 0.0013141632080078
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(272) DESCRIBE `ports` 0.0013060569763184
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(274) DESCRIBE `ports` 0.001276969909668
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00030803680419922
(276) DESCRIBE `ports` 0.0013320446014404
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00031805038452148
(278) DESCRIBE `ports` 0.0012810230255127
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00030899047851562
(280) DESCRIBE `ports` 0.001431941986084
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00028419494628906
(282) DESCRIBE `ports` 0.001338005065918
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00030994415283203
(284) DESCRIBE `ports` 0.0012500286102295
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0002739429473877
(286) DESCRIBE `ports` 0.0013608932495117
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00031495094299316
(288) DESCRIBE `ports` 0.0015609264373779
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00034499168395996
(290) DESCRIBE `ports` 0.0014300346374512
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00041699409484863
(292) DESCRIBE `ports` 0.0016930103302002
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035381317138672
(294) DESCRIBE `ports` 0.0018460750579834
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044393539428711
(296) DESCRIBE `ports` 0.0010249614715576
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037097930908203
(298) DESCRIBE `avid_specials` 0.0014140605926514
(299) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63373 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.00160813331604
(300) DESCRIBE `cruiselines` 0.0023698806762695
(301) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00045299530029297
(302) DESCRIBE `orchid_image` 0.0018160343170166
(303) DESCRIBE `cruiselines` 0.0034329891204834
(304) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00046610832214355
(305) DESCRIBE `cruises` 0.0033609867095947
(306) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70897') 0.00051999092102051
(307) DESCRIBE `ships` 0.0030510425567627
(308) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0005638599395752
(309) DESCRIBE `ships` 0.0041570663452148
(310) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00045609474182129
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028896331787109
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002899169921875
(313) DESCRIBE `itineraries` 0.0015659332275391
(314) DESCRIBE `ports` 0.0015668869018555
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036191940307617
(316) DESCRIBE `ports` 0.0014309883117676
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033187866210938
(318) DESCRIBE `ports` 0.0013749599456787
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031614303588867
(320) DESCRIBE `sailingdates` 0.001349925994873
(321) DESCRIBE `ports` 0.0013899803161621
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033998489379883
(323) DESCRIBE `ports` 0.0012791156768799
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030994415283203
(325) DESCRIBE `ports` 0.0013620853424072
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00035405158996582
(327) DESCRIBE `ports` 0.0015189647674561
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0003209114074707
(329) DESCRIBE `ports` 0.0015230178833008
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00033998489379883
(331) DESCRIBE `ports` 0.0013141632080078
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00032687187194824
(333) DESCRIBE `ports` 0.0013179779052734
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00030994415283203
(335) DESCRIBE `ports` 0.0014050006866455
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00029897689819336
(337) DESCRIBE `ports` 0.0014450550079346
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0003659725189209
(339) DESCRIBE `ports` 0.0016839504241943
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00033283233642578
(341) DESCRIBE `ports` 0.0013229846954346
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037002563476562
(343) DESCRIBE `ports` 0.0014691352844238
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029587745666504
(345) DESCRIBE `avid_specials` 0.0012280941009521
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70897 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.0022330284118652
(347) DESCRIBE `cruiselines` 0.0018370151519775
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0
(349) DESCRIBE `orchid_image` 0.0014598369598389
(350) DESCRIBE `cruiselines` 0.0021700859069824
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00037407875061035
(352) DESCRIBE `cruises` 0.003558874130249
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00041794776916504
(354) DESCRIBE `ships` 0.003403902053833
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00086617469787598
(356) DESCRIBE `ships` 0.0031580924987793
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00037097930908203
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032210350036621
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038981437683105
(360) DESCRIBE `itineraries` 0.0014550685882568
(361) DESCRIBE `ports` 0.0018150806427002
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046396255493164
(363) DESCRIBE `ports` 0.0015280246734619
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(365) DESCRIBE `ports` 0.0017039775848389
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(367) DESCRIBE `sailingdates` 0.0012209415435791
(368) DESCRIBE `ports` 0.0013570785522461
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002131462097168
(370) DESCRIBE `ports` 0.0018501281738281
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038290023803711
(372) DESCRIBE `ports` 0.0012249946594238
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00039196014404297
(374) DESCRIBE `ports` 0.0016000270843506
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00041580200195312
(376) DESCRIBE `ports` 0.0015311241149902
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(378) DESCRIBE `ports` 0.0016059875488281
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002899169921875
(380) DESCRIBE `avid_specials` 0.0014259815216064
(381) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016250610351562
(382) DESCRIBE `cruiselines` 0.0022909641265869
(383) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043201446533203
(384) DESCRIBE `orchid_image` 0.0018520355224609
(385) DESCRIBE `cruiselines` 0.0023448467254639
(386) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00034809112548828
(387) DESCRIBE `cruises` 0.0041790008544922
(388) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70932') 0.00048089027404785
(389) DESCRIBE `ships` 0.0030598640441895
(390) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00042200088500977
(391) DESCRIBE `ships` 0.0025839805603027
(392) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029206275939941
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032687187194824
(395) DESCRIBE `itineraries` 0.0014410018920898
(396) DESCRIBE `ports` 0.0014240741729736
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037097930908203
(398) DESCRIBE `ports` 0.001471996307373
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042104721069336
(400) DESCRIBE `ports` 0.0013799667358398
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018811225891113
(402) DESCRIBE `sailingdates` 0.0016169548034668
(403) DESCRIBE `ports` 0.0019359588623047
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038814544677734
(405) DESCRIBE `ports` 0.00067305564880371
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029897689819336
(407) DESCRIBE `ports` 0.0012719631195068
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0
(409) DESCRIBE `ports` 0.0013680458068848
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028800964355469
(411) DESCRIBE `ports` 0.0016450881958008
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032210350036621
(413) DESCRIBE `ports` 0.0013270378112793
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00028800964355469
(415) DESCRIBE `ports` 0.0012547969818115
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031208992004395
(417) DESCRIBE `ports` 0.0021979808807373
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00053310394287109
(419) DESCRIBE `ports` 0.0008399486541748
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003659725189209
(421) DESCRIBE `ports` 0.0014369487762451
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030112266540527
(423) DESCRIBE `avid_specials` 0.0011749267578125
(424) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70932 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014150142669678
(425) DESCRIBE `cruiselines` 0.001971960067749
(426) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00075197219848633
(427) DESCRIBE `orchid_image` 0.0014481544494629
(428) DESCRIBE `cruiselines` 0.0018661022186279
(429) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00036811828613281
(430) DESCRIBE `ships` 0.003262996673584
(431) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722', '288')) ORDER BY FIND_IN_SET(id, '4,1722,288') 0.0007941722869873
(432) DESCRIBE `cruisetypes` 0.0011229515075684
(433) DESCRIBE `destinations` 0.0018041133880615
(434) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00052285194396973
(435) DESCRIBE `cruiselines` 0.0018579959869385
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037693977355957
(437) DESCRIBE `cruiselines` 0.0022819042205811
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00039291381835938