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

Total elapsed time: 1.0204267501831

# Query Time
(1) connect 0.0015420913696289
(2) DESCRIBE `cruises` 0.0032539367675781
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68564, 68473, 68565, 68474, 68462, 68465, 62062, 68475, 62066, 68466)) ORDER BY FIND_IN_SET(id, '68564,68473,68565,68474,68462,68465,62062,68475,62066,68466') 0.0019099712371826
(4) DESCRIBE `cruises` 0.0037200450897217
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68564') 0.00059199333190918
(6) DESCRIBE `ships` 0.0035581588745117
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00061297416687012
(8) DESCRIBE `ships` 0.002547025680542
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00037503242492676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037789344787598
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026178359985352
(12) DESCRIBE `itineraries` 0.0013480186462402
(13) DESCRIBE `ports` 0.0015919208526611
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 3.9100646972656E-5
(15) DESCRIBE `ports` 0.0016739368438721
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00032520294189453
(17) DESCRIBE `ports` 0.0015048980712891
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00033283233642578
(19) DESCRIBE `sailingdates` 0.0011911392211914
(20) DESCRIBE `ports` 0.0015449523925781
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00035500526428223
(22) DESCRIBE `ports` 0.001446008682251
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00040197372436523
(24) DESCRIBE `ports` 0.0018200874328613
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00043892860412598
(26) DESCRIBE `ports` 0.0019028186798096
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00039792060852051
(28) DESCRIBE `ports` 0.0021579265594482
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00047707557678223
(30) DESCRIBE `ports` 0.0016961097717285
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0003669261932373
(32) DESCRIBE `ports` 0.0016710758209229
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00034809112548828
(34) DESCRIBE `ports` 0.0021209716796875
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00043892860412598
(36) DESCRIBE `ports` 0.0017499923706055
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00038409233093262
(38) DESCRIBE `ports` 0.0017220973968506
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00031900405883789
(40) DESCRIBE `ports` 0.001352071762085
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00040793418884277
(42) DESCRIBE `ports` 0.0016050338745117
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.0003359317779541
(44) DESCRIBE `ports` 0.0014948844909668
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00032806396484375
(46) DESCRIBE `ports` 0.0014889240264893
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00039410591125488
(48) DESCRIBE `ports` 0.0015180110931396
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00037384033203125
(50) DESCRIBE `ports` 0.0016348361968994
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00031304359436035
(52) DESCRIBE `ports` 0.0018479824066162
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00043487548828125
(54) DESCRIBE `ports` 0.0014019012451172
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00046992301940918
(56) DESCRIBE `ports` 0.0015521049499512
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034904479980469
(58) DESCRIBE `ports` 0.0015230178833008
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00034809112548828
(60) DESCRIBE `avid_specials` 0.0016059875488281
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68564 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0015459060668945
(62) DESCRIBE `cruiselines` 0.0027728080749512
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00063204765319824
(64) DESCRIBE `orchid_image` 0.0023009777069092
(65) DESCRIBE `cruiselines` 0.0030539035797119
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00049304962158203
(67) DESCRIBE `cruises` 0.0037310123443604
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68473') 0.0005180835723877
(69) DESCRIBE `ships` 0.0041141510009766
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00055789947509766
(71) DESCRIBE `ships` 0.003687858581543
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.0004580020904541
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034499168395996
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033998489379883
(75) DESCRIBE `itineraries` 0.001953125
(76) DESCRIBE `ports` 0.0022671222686768
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00051283836364746
(78) DESCRIBE `ports` 0.0019559860229492
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040817260742188
(80) DESCRIBE `ports` 0.0018701553344727
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00039505958557129
(82) DESCRIBE `sailingdates` 0.0015151500701904
(83) DESCRIBE `ports` 0.0018961429595947
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00043201446533203
(85) DESCRIBE `ports` 0.0018060207366943
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00037908554077148
(87) DESCRIBE `ports` 0.0018939971923828
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 7.2956085205078E-5
(89) DESCRIBE `ports` 0.0019199848175049
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.0008549690246582
(91) DESCRIBE `ports` 0.0017130374908447
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00042986869812012
(93) DESCRIBE `ports` 0.0017948150634766
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00041389465332031
(95) DESCRIBE `ports` 0.0017681121826172
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.0004420280456543
(97) DESCRIBE `ports` 0.0018730163574219
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00046610832214355
(99) DESCRIBE `ports` 0.0017919540405273
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00042295455932617
(101) DESCRIBE `ports` 0.0019869804382324
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00040698051452637
(103) DESCRIBE `ports` 0.0018868446350098
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00048398971557617
(105) DESCRIBE `ports` 0.0019428730010986
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00041508674621582
(107) DESCRIBE `ports` 0.0017111301422119
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00036811828613281
(109) DESCRIBE `ports` 0.0017509460449219
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00031495094299316
(111) DESCRIBE `ports` 0.0018999576568604
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.00046300888061523
(113) DESCRIBE `ports` 0.0018978118896484
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00040006637573242
(115) DESCRIBE `ports` 0.0019311904907227
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0004880428314209
(117) DESCRIBE `ports` 0.00199294090271
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00049614906311035
(119) DESCRIBE `ports` 0.0019180774688721
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00044798851013184
(121) DESCRIBE `ports` 0.0019328594207764
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00042986869812012
(123) DESCRIBE `ports` 0.001823902130127
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00050592422485352
(125) DESCRIBE `ports` 0.0019118785858154
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0003969669342041
(127) DESCRIBE `avid_specials` 0.0014619827270508
(128) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68473 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0020318031311035
(129) DESCRIBE `cruiselines` 0.0025250911712646
(130) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00043916702270508
(131) DESCRIBE `orchid_image` 0.0027799606323242
(132) DESCRIBE `cruiselines` 0.0025510787963867
(133) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00045180320739746
(134) DESCRIBE `cruises` 0.0034670829772949
(135) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68565') 0.00047898292541504
(136) DESCRIBE `ships` 0.0034158229827881
(137) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00053000450134277
(138) DESCRIBE `ships` 0.0030660629272461
(139) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00043797492980957
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 2.0027160644531E-5
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(142) DESCRIBE `itineraries` 0.0016429424285889
(143) DESCRIBE `ports` 0.0017409324645996
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00047898292541504
(145) DESCRIBE `ports` 0.0016779899597168
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00042200088500977
(147) DESCRIBE `ports` 0.0017249584197998
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00034904479980469
(149) DESCRIBE `sailingdates` 0.0014190673828125
(150) DESCRIBE `ports` 0.0017220973968506
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 2.7179718017578E-5
(152) DESCRIBE `ports` 0.001507043838501
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00037217140197754
(154) DESCRIBE `ports` 0.0018057823181152
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00045299530029297
(156) DESCRIBE `ports` 0.0018999576568604
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00040888786315918
(158) DESCRIBE `ports` 0.0017049312591553
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0004570484161377
(160) DESCRIBE `ports` 0.0014700889587402
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00049304962158203
(162) DESCRIBE `ports` 0.0017797946929932
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00044584274291992
(164) DESCRIBE `ports` 0.0018990039825439
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.0004119873046875
(166) DESCRIBE `ports` 0.0018510818481445
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00046801567077637
(168) DESCRIBE `ports` 0.0017709732055664
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00040006637573242
(170) DESCRIBE `ports` 0.0021440982818604
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00048279762268066
(172) DESCRIBE `ports` 0.0016529560089111
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00052094459533691
(174) DESCRIBE `ports` 0.0017518997192383
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00049591064453125
(176) DESCRIBE `ports` 0.0017411708831787
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00041794776916504
(178) DESCRIBE `ports` 0.0023279190063477
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00047492980957031
(180) DESCRIBE `ports` 0.0020191669464111
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00045204162597656
(182) DESCRIBE `ports` 0.002007007598877
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00052905082702637
(184) DESCRIBE `ports` 0.0020978450775146
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00045299530029297
(186) DESCRIBE `ports` 0.0020091533660889
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00054788589477539
(188) DESCRIBE `ports` 0.0019450187683105
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00042605400085449
(190) DESCRIBE `ports` 0.0019199848175049
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00051498413085938
(192) DESCRIBE `ports` 0.0019600391387939
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00052380561828613
(194) DESCRIBE `avid_specials` 0.0018379688262939
(195) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68565 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0017971992492676
(196) DESCRIBE `cruiselines` 0.0025858879089355
(197) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 9.7990036010742E-5
(198) DESCRIBE `orchid_image` 0.0025479793548584
(199) DESCRIBE `cruiselines` 0.003014087677002
(200) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00051999092102051
(201) DESCRIBE `cruises` 0.0038461685180664
(202) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68474') 0.0005800724029541
(203) DESCRIBE `ships` 0.0042009353637695
(204) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00064992904663086
(205) DESCRIBE `ships` 0.0036659240722656
(206) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00058317184448242
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027608871459961
(208) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030708312988281
(209) DESCRIBE `itineraries` 0.0014951229095459
(210) DESCRIBE `ports` 0.0026130676269531
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00047397613525391
(212) DESCRIBE `ports` 0.0020370483398438
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00048708915710449
(214) DESCRIBE `ports` 0.0019400119781494
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0004580020904541
(216) DESCRIBE `sailingdates` 0.0017271041870117
(217) DESCRIBE `ports` 0.0020511150360107
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00064396858215332
(219) DESCRIBE `ports` 0.001945972442627
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00042581558227539
(221) DESCRIBE `ports` 0.0018398761749268
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0005040168762207
(223) DESCRIBE `ports` 0.0021429061889648
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00043082237243652
(225) DESCRIBE `ports` 0.0019090175628662
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00041699409484863
(227) DESCRIBE `ports` 0.0016739368438721
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00034499168395996
(229) DESCRIBE `ports` 0.0014629364013672
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00046992301940918
(231) DESCRIBE `ports` 0.0016968250274658
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00052595138549805
(233) DESCRIBE `ports` 0.0018999576568604
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00047707557678223
(235) DESCRIBE `ports` 0.001716136932373
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00040578842163086
(237) DESCRIBE `ports` 0.0014419555664062
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00065302848815918
(239) DESCRIBE `ports` 0.0015909671783447
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00097203254699707
(241) DESCRIBE `ports` 0.0014519691467285
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.0003809928894043
(243) DESCRIBE `ports` 0.0014569759368896
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00032615661621094
(245) DESCRIBE `ports` 0.0014629364013672
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00055885314941406
(247) DESCRIBE `ports` 0.0019171237945557
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00052618980407715
(249) DESCRIBE `ports` 0.001784086227417
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00046491622924805
(251) DESCRIBE `ports` 0.0018229484558105
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0003809928894043
(253) DESCRIBE `ports` 0.0018589496612549
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040984153747559
(255) DESCRIBE `ports` 0.0015718936920166
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00038695335388184
(257) DESCRIBE `avid_specials` 0.0013899803161621
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68474 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0012409687042236
(259) DESCRIBE `cruiselines` 0.0022270679473877
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00044703483581543
(261) DESCRIBE `orchid_image` 0.0018548965454102
(262) DESCRIBE `cruiselines` 0.0021469593048096
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00038814544677734
(264) DESCRIBE `cruises` 0.0030379295349121
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68462') 0.00077700614929199
(266) DESCRIBE `ships` 0.00350022315979
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.00068497657775879
(268) DESCRIBE `ships` 0.0040810108184814
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.00051403045654297
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037193298339844
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028014183044434
(272) DESCRIBE `itineraries` 0.0016720294952393
(273) DESCRIBE `ports` 0.0015740394592285
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0004429817199707
(275) DESCRIBE `ports` 0.0014998912811279
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040793418884277
(277) DESCRIBE `ports` 0.0017249584197998
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00034594535827637
(279) DESCRIBE `sailingdates` 0.0016448497772217
(280) DESCRIBE `ports` 0.0020568370819092
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00013899803161621
(282) DESCRIBE `ports` 0.001884937286377
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0002739429473877
(284) DESCRIBE `ports` 0.0018990039825439
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00060582160949707
(286) DESCRIBE `ports` 0.0017209053039551
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00071978569030762
(288) DESCRIBE `ports` 0.0016109943389893
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00047683715820312
(290) DESCRIBE `ports` 0.0021820068359375
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00045990943908691
(292) DESCRIBE `ports` 0.0017530918121338
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00042390823364258
(294) DESCRIBE `ports` 0.001755952835083
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00038385391235352
(296) DESCRIBE `ports` 0.0013430118560791
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00039386749267578
(298) DESCRIBE `ports` 0.0016529560089111
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00039386749267578
(300) DESCRIBE `ports` 0.0018250942230225
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.0004270076751709
(302) DESCRIBE `ports` 0.0019509792327881
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.0006110668182373
(304) DESCRIBE `ports` 0.0028390884399414
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00061893463134766
(306) DESCRIBE `ports` 0.0022330284118652
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00055694580078125
(308) DESCRIBE `ports` 0.0019309520721436
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00052094459533691
(310) DESCRIBE `ports` 0.0018408298492432
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00045394897460938
(312) DESCRIBE `ports` 0.0018489360809326
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00047707557678223
(314) DESCRIBE `ports` 0.0018379688262939
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00044393539428711
(316) DESCRIBE `ports` 0.011919975280762
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00060296058654785
(318) DESCRIBE `ports` 0.0058310031890869
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00058507919311523
(320) DESCRIBE `ports` 0.001849889755249
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00047993659973145
(322) DESCRIBE `ports` 0.001939058303833
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00048112869262695
(324) DESCRIBE `avid_specials` 0.0016980171203613
(325) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68462 and class = 'Cruise') OR (item_id = 796 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0019600391387939
(326) DESCRIBE `cruiselines` 0.0025959014892578
(327) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00052213668823242
(328) DESCRIBE `orchid_image` 0.0018389225006104
(329) DESCRIBE `cruiselines` 0.0027401447296143
(330) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00058102607727051
(331) DESCRIBE `cruises` 0.0077099800109863
(332) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68465') 0.00055122375488281
(333) DESCRIBE `ships` 0.0041191577911377
(334) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.00067400932312012
(335) DESCRIBE `ships` 0.0037691593170166
(336) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.00053596496582031
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(338) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029110908508301
(339) DESCRIBE `itineraries` 0.0017590522766113
(340) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68465') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010659694671631
(341) DESCRIBE `ports` 0.0023128986358643
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0014989376068115
(343) DESCRIBE `ports` 0.0022170543670654
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00051403045654297
(345) DESCRIBE `ports` 0.0026531219482422
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0010321140289307
(347) DESCRIBE `sailingdates` 0.0015769004821777
(348) DESCRIBE `ports` 0.002464771270752
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00019502639770508
(350) DESCRIBE `ports` 0.0021159648895264
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 3.504753112793E-5
(352) DESCRIBE `ports` 0.001917839050293
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00049114227294922
(354) DESCRIBE `ports` 0.0020029544830322
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00052809715270996
(356) DESCRIBE `ports` 0.0020880699157715
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00056600570678711
(358) DESCRIBE `ports` 0.0034339427947998
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00055193901062012
(360) DESCRIBE `ports` 0.0026431083679199
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00060486793518066
(362) DESCRIBE `ports` 0.0027589797973633
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00136399269104
(364) DESCRIBE `ports` 0.0030431747436523
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00055098533630371
(366) DESCRIBE `ports` 0.0020899772644043
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.0005040168762207
(368) DESCRIBE `ports` 0.0020201206207275
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.0005500316619873
(370) DESCRIBE `ports` 0.0039219856262207
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00084400177001953
(372) DESCRIBE `ports` 0.002295970916748
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.0005650520324707
(374) DESCRIBE `ports` 0.0027689933776855
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00054788589477539
(376) DESCRIBE `ports` 0.0021429061889648
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00067305564880371
(378) DESCRIBE `ports` 0.0031368732452393
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0005180835723877
(380) DESCRIBE `ports` 0.0023090839385986
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00047111511230469
(382) DESCRIBE `ports` 0.0030639171600342
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00069999694824219
(384) DESCRIBE `ports` 0.0030441284179688
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00061511993408203
(386) DESCRIBE `ports` 0.00164794921875
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00045204162597656
(388) DESCRIBE `avid_specials` 0.0016229152679443
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68465 and class = 'Cruise') OR (item_id = 796 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0026099681854248
(390) DESCRIBE `cruiselines` 0.0030460357666016
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00054192543029785
(392) DESCRIBE `orchid_image` 0.002432107925415
(393) DESCRIBE `cruiselines` 0.002877950668335
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00052905082702637
(395) DESCRIBE `cruises` 0.0039138793945312
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62062') 0.00035595893859863
(397) DESCRIBE `ships` 0.0033941268920898
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.0013680458068848
(399) DESCRIBE `ships` 0.0042569637298584
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00052213668823242
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033092498779297
(403) DESCRIBE `itineraries` 0.0020809173583984
(404) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62062') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011367797851562
(405) DESCRIBE `ports` 0.0023698806762695
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0015740394592285
(407) DESCRIBE `ports` 0.0018279552459717
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 8.7976455688477E-5
(409) DESCRIBE `ports` 0.0019650459289551
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00052905082702637
(411) DESCRIBE `sailingdates` 0.0020520687103271
(412) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62062') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012378692626953
(413) DESCRIBE `ports` 0.0019960403442383
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00054001808166504
(415) DESCRIBE `ports` 0.0013220310211182
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0004580020904541
(417) DESCRIBE `ports` 0.0017368793487549
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00042104721069336
(419) DESCRIBE `ports` 0.0017800331115723
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00036215782165527
(421) DESCRIBE `ports` 0.0018060207366943
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031208992004395
(423) DESCRIBE `ports` 0.0018539428710938
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00039410591125488
(425) DESCRIBE `ports` 0.0018129348754883
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.0004279613494873
(427) DESCRIBE `ports` 0.0016951560974121
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00040984153747559
(429) DESCRIBE `ports` 0.0018570423126221
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00073719024658203
(431) DESCRIBE `ports` 0.0052649974822998
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00062012672424316
(433) DESCRIBE `ports` 0.0019490718841553
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00051093101501465
(435) DESCRIBE `ports` 0.0018508434295654
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00044822692871094
(437) DESCRIBE `ports` 0.0019638538360596
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00046491622924805
(439) DESCRIBE `ports` 0.0019299983978271
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00038313865661621
(441) DESCRIBE `ports` 0.0018970966339111
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00046801567077637
(443) DESCRIBE `ports` 0.0020589828491211
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00050592422485352
(445) DESCRIBE `ports` 0.0021138191223145
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0006258487701416
(447) DESCRIBE `ports` 0.0029580593109131
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00052404403686523
(449) DESCRIBE `ports` 0.0021209716796875
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00049304962158203
(451) DESCRIBE `ports` 0.0019638538360596
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00060796737670898
(453) DESCRIBE `avid_specials` 0.0018401145935059
(454) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62062 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0028729438781738
(455) DESCRIBE `cruiselines` 0.0032680034637451
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00050210952758789
(457) DESCRIBE `orchid_image` 0.0030181407928467
(458) DESCRIBE `cruiselines` 0.0029399394989014
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00055718421936035
(460) DESCRIBE `cruises` 0.0049600601196289
(461) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68475') 0.00075602531433105
(462) DESCRIBE `ships` 0.0039260387420654
(463) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00059294700622559
(464) DESCRIBE `ships` 0.0045738220214844
(465) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00057792663574219
(466) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037789344787598
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0008549690246582
(468) DESCRIBE `itineraries` 0.0017821788787842
(469) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68475') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00093889236450195
(470) DESCRIBE `ports` 0.0018908977508545
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00064587593078613
(472) DESCRIBE `ports` 0.002122163772583
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00069999694824219
(474) DESCRIBE `ports` 0.0030591487884521
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00049996376037598
(476) DESCRIBE `sailingdates` 0.0018749237060547
(477) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68475') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00097298622131348
(478) DESCRIBE `ports` 0.0030379295349121
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00053000450134277
(480) DESCRIBE `ports` 0.0020480155944824
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00045490264892578
(482) DESCRIBE `ports` 0.0021018981933594
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00054097175598145
(484) DESCRIBE `ports` 0.0022368431091309
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00052595138549805
(486) DESCRIBE `ports` 0.0021851062774658
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00060009956359863
(488) DESCRIBE `ports` 0.0019481182098389
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00052285194396973
(490) DESCRIBE `ports` 0.002946138381958
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00055408477783203
(492) DESCRIBE `ports` 0.0020029544830322
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0037760734558105
(494) DESCRIBE `ports` 0.0020451545715332
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00048398971557617
(496) DESCRIBE `ports` 0.0020201206207275
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00056099891662598
(498) DESCRIBE `ports` 0.0017881393432617
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00044584274291992
(500) DESCRIBE `ports` 0.0017790794372559
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0004279613494873
(502) DESCRIBE `ports` 0.0015280246734619
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.0006260871887207
(504) DESCRIBE `ports` 0.0023210048675537
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00043106079101562
(506) DESCRIBE `ports` 0.0018839836120605
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00051093101501465
(508) DESCRIBE `ports` 0.0018949508666992
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00053000450134277
(510) DESCRIBE `ports` 0.0019888877868652
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1030))) 0.00049805641174316
(512) DESCRIBE `ports` 0.0019769668579102
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1030') 0.00047802925109863
(514) DESCRIBE `ports` 0.0017309188842773
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00038695335388184
(516) DESCRIBE `ports` 0.001708984375
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00040197372436523
(518) DESCRIBE `ports` 0.0016980171203613
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00045299530029297
(520) DESCRIBE `ports` 0.0014679431915283
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00045990943908691
(522) DESCRIBE `ports` 0.001917839050293
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00010800361633301
(524) DESCRIBE `ports` 0.0019421577453613
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0004727840423584
(526) DESCRIBE `ports` 0.0022139549255371
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00055193901062012
(528) DESCRIBE `ports` 0.0021259784698486
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00048494338989258
(530) DESCRIBE `avid_specials` 0.0017201900482178
(531) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68475 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0017538070678711
(532) DESCRIBE `cruiselines` 0.0030078887939453
(533) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00056004524230957
(534) DESCRIBE `orchid_image` 0.0022258758544922
(535) DESCRIBE `cruiselines` 0.0027868747711182
(536) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00048494338989258
(537) DESCRIBE `cruises` 0.0036718845367432
(538) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62066') 0.00089001655578613
(539) DESCRIBE `ships` 0.0050101280212402
(540) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00087714195251465
(541) DESCRIBE `ships` 0.0038549900054932
(542) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00057315826416016
(543) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037717819213867
(544) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00013208389282227
(545) DESCRIBE `itineraries` 0.002108097076416
(546) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62066') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00075697898864746
(547) DESCRIBE `ports` 0.0020768642425537
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00045895576477051
(549) DESCRIBE `ports` 0.0019040107727051
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00048494338989258
(551) DESCRIBE `ports` 0.0020220279693604
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00048613548278809
(553) DESCRIBE `sailingdates` 0.0016119480133057
(554) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62066') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00087690353393555
(555) DESCRIBE `ports` 0.0021679401397705
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00091290473937988
(557) DESCRIBE `ports` 0.0019199848175049
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00044584274291992
(559) DESCRIBE `ports` 0.0018069744110107
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00024700164794922
(561) DESCRIBE `ports` 0.0019609928131104
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00060796737670898
(563) DESCRIBE `ports` 0.0018320083618164
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00052285194396973
(565) DESCRIBE `ports` 0.0019309520721436
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00058293342590332
(567) DESCRIBE `ports` 0.0019609928131104
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00049805641174316
(569) DESCRIBE `ports` 0.0019271373748779
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.0004279613494873
(571) DESCRIBE `ports` 0.0019600391387939
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00051307678222656
(573) DESCRIBE `ports` 0.001924991607666
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00046396255493164
(575) DESCRIBE `ports` 0.0020110607147217
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00043010711669922
(577) DESCRIBE `ports` 0.0019690990447998
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00040793418884277
(579) DESCRIBE `ports` 0.0016977787017822
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00039196014404297
(581) DESCRIBE `ports` 0.0016558170318604
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00037884712219238
(583) DESCRIBE `ports` 0.0016319751739502
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0004420280456543
(585) DESCRIBE `ports` 0.0017659664154053
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00040984153747559
(587) DESCRIBE `ports` 0.0017008781433105
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00049901008605957
(589) DESCRIBE `ports` 0.0019669532775879
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00046396255493164
(591) DESCRIBE `ports` 0.0022749900817871
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00078797340393066
(593) DESCRIBE `ports` 0.0022668838500977
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0004270076751709
(595) DESCRIBE `avid_specials` 0.0017189979553223
(596) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62066 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0018508434295654
(597) DESCRIBE `cruiselines` 0.0028228759765625
(598) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00057601928710938
(599) DESCRIBE `orchid_image` 0.0025570392608643
(600) DESCRIBE `cruiselines` 0.0038189888000488
(601) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00057816505432129
(602) DESCRIBE `cruises` 0.0044379234313965
(603) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68466') 0.00065803527832031
(604) DESCRIBE `ships` 0.0037679672241211
(605) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.0011329650878906
(606) DESCRIBE `ships` 0.004939079284668
(607) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 6.4849853515625E-5
(608) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033092498779297
(609) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030803680419922
(610) DESCRIBE `itineraries` 0.0018579959869385
(611) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68466') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012860298156738
(612) DESCRIBE `ports` 0.0022120475769043
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00049209594726562
(614) DESCRIBE `ports` 0.0024900436401367
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00051498413085938
(616) DESCRIBE `ports` 0.0021162033081055
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00044989585876465
(618) DESCRIBE `sailingdates` 0.0017430782318115
(619) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68466') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077700614929199
(620) DESCRIBE `ports` 0.0020589828491211
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00047993659973145
(622) DESCRIBE `ports` 0.0021979808807373
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00048995018005371
(624) DESCRIBE `ports` 0.0028431415557861
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00053501129150391
(626) DESCRIBE `ports` 0.001662015914917
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00043106079101562
(628) DESCRIBE `ports` 0.0014610290527344
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0005338191986084
(630) DESCRIBE `ports` 0.0020809173583984
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00042295455932617
(632) DESCRIBE `ports` 0.001755952835083
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00046396255493164
(634) DESCRIBE `ports` 0.0017399787902832
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00042200088500977
(636) DESCRIBE `ports` 0.0017721652984619
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00052309036254883
(638) DESCRIBE `ports` 0.00180983543396
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.0004270076751709
(640) DESCRIBE `ports` 0.0029571056365967
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00052905082702637
(642) DESCRIBE `ports` 0.0018119812011719
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00040912628173828
(644) DESCRIBE `ports` 0.0029189586639404
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0012829303741455
(646) DESCRIBE `ports` 0.0030009746551514
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00056314468383789
(648) DESCRIBE `ports` 0.0021729469299316
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00073814392089844
(650) DESCRIBE `ports` 0.0022509098052979
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00049090385437012
(652) DESCRIBE `ports` 0.0018000602722168
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00046610832214355
(654) DESCRIBE `ports` 0.002877950668335
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0019738674163818
(656) DESCRIBE `ports` 0.0023200511932373
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00052404403686523
(658) DESCRIBE `ports` 0.0033929347991943
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.0010049343109131
(660) DESCRIBE `avid_specials` 0.0018548965454102
(661) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68466 and class = 'Cruise') OR (item_id = 796 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.001741886138916
(662) DESCRIBE `cruiselines` 0.0031931400299072
(663) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00061202049255371
(664) DESCRIBE `orchid_image` 0.002957820892334
(665) DESCRIBE `cruiselines` 0.0073840618133545
(666) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00056910514831543
(667) DESCRIBE `ships` 0.004162073135376
(668) SELECT `ships`.* FROM `ships` WHERE (id IN ('796', '795', '1073', '1262')) ORDER BY FIND_IN_SET(id, '796,795,1073,1262') 0.0010459423065186
(669) DESCRIBE `cruisetypes` 0.0017459392547607
(670) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '7') AND (cruises_and_specials.cruiseline_id = '114') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.05466103553772
(671) DESCRIBE `cruiselines` 0.0027480125427246
(672) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00060105323791504
(673) DESCRIBE `destinations` 0.0031569004058838
(674) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.0010900497436523
(675) DESCRIBE `destinations` 0.0036959648132324
(676) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00043606758117676
(677) DESCRIBE `cruiselines` 0.0029230117797852
(678) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00053095817565918