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

Total elapsed time: 1.0454466342926

# Query Time
(1) connect 0.0012269020080566
(2) DESCRIBE `cruises` 0.0039129257202148
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72994, 72995, 72996, 73034, 72998, 72999, 73033, 78355, 78356, 78354)) ORDER BY FIND_IN_SET(id, '72994,72995,72996,73034,72998,72999,73033,78355,78356,78354') 0.0022258758544922
(4) DESCRIBE `cruises` 0.0038928985595703
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72994') 0.00057101249694824
(6) DESCRIBE `ships` 0.004019021987915
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00069999694824219
(8) DESCRIBE `ships` 0.0038769245147705
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00052285194396973
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032520294189453
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031208992004395
(12) DESCRIBE `itineraries` 0.0018939971923828
(13) DESCRIBE `ports` 0.002230167388916
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045895576477051
(15) DESCRIBE `ports` 0.0016520023345947
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003819465637207
(17) DESCRIBE `ports` 0.0017290115356445
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033903121948242
(19) DESCRIBE `sailingdates` 0.0014328956604004
(20) DESCRIBE `ports` 0.0018091201782227
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065016746520996
(22) DESCRIBE `ports` 0.001723051071167
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036907196044922
(24) DESCRIBE `ports` 0.0016129016876221
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00036883354187012
(26) DESCRIBE `ports` 0.0015969276428223
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00077509880065918
(28) DESCRIBE `ports` 0.0017330646514893
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0005190372467041
(30) DESCRIBE `ports` 0.0017650127410889
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00039291381835938
(32) DESCRIBE `ports` 0.0015959739685059
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00044679641723633
(34) DESCRIBE `ports` 0.00177001953125
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0
(36) DESCRIBE `ports` 0.0014190673828125
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031518936157227
(38) DESCRIBE `ports` 0.0014331340789795
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046086311340332
(40) DESCRIBE `avid_specials` 0.0014870166778564
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72994 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.001115083694458
(42) DESCRIBE `cruiselines` 0.0021259784698486
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00043106079101562
(44) DESCRIBE `orchid_image` 0.0021309852600098
(45) DESCRIBE `cruiselines` 0.0019869804382324
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0
(47) DESCRIBE `cruises` 0.0026481151580811
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72995') 0.00033688545227051
(49) DESCRIBE `ships` 0.0032670497894287
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00040698051452637
(51) DESCRIBE `ships` 0.0027379989624023
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00047183036804199
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028586387634277
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(55) DESCRIBE `itineraries` 0.0013618469238281
(56) DESCRIBE `ports` 0.0013179779052734
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040388107299805
(58) DESCRIBE `ports` 0.0015740394592285
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034594535827637
(60) DESCRIBE `ports` 0.0014889240264893
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032687187194824
(62) DESCRIBE `sailingdates` 0.0013320446014404
(63) DESCRIBE `ports` 0.0015449523925781
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036501884460449
(65) DESCRIBE `ports` 0.0013949871063232
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030112266540527
(67) DESCRIBE `ports` 0.0013439655303955
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00034999847412109
(69) DESCRIBE `ports` 0.0012750625610352
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00027585029602051
(71) DESCRIBE `ports` 0.0016360282897949
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00041484832763672
(73) DESCRIBE `ports` 0.0018589496612549
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00033807754516602
(75) DESCRIBE `ports` 0.0016989707946777
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0004420280456543
(77) DESCRIBE `ports` 0.0018880367279053
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00041079521179199
(79) DESCRIBE `ports` 0.0016770362854004
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039505958557129
(81) DESCRIBE `ports` 0.0016388893127441
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031495094299316
(83) DESCRIBE `ports` 0.0013549327850342
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00035715103149414
(85) DESCRIBE `ports` 0.001305103302002
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00029611587524414
(87) DESCRIBE `ports` 0.0012891292572021
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00029397010803223
(89) DESCRIBE `ports` 0.0014431476593018
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00028610229492188
(91) DESCRIBE `ports` 0.0013060569763184
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00029802322387695
(93) DESCRIBE `ports` 0.0013628005981445
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00031089782714844
(95) DESCRIBE `ports` 0.0014100074768066
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00040507316589355
(97) DESCRIBE `ports` 0.0016729831695557
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00032782554626465
(99) DESCRIBE `ports` 0.0015208721160889
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0003361701965332
(101) DESCRIBE `ports` 0.0021121501922607
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00030612945556641
(103) DESCRIBE `ports` 0.0013341903686523
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00031709671020508
(105) DESCRIBE `ports` 0.0013668537139893
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00030303001403809
(107) DESCRIBE `ports` 0.0013749599456787
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00031208992004395
(109) DESCRIBE `ports` 0.0012609958648682
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026297569274902
(111) DESCRIBE `ports` 0.0013580322265625
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00030422210693359
(113) DESCRIBE `ports` 0.00124192237854
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00031900405883789
(115) DESCRIBE `ports` 0.0016970634460449
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036406517028809
(117) DESCRIBE `ports` 0.0017991065979004
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037789344787598
(119) DESCRIBE `ports` 0.0017619132995605
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049996376037598
(121) DESCRIBE `ports` 0.0018339157104492
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037097930908203
(123) DESCRIBE `avid_specials` 0.0014359951019287
(124) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72995 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0012428760528564
(125) DESCRIBE `cruiselines` 0.0021169185638428
(126) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00038695335388184
(127) DESCRIBE `orchid_image` 0.0016582012176514
(128) DESCRIBE `cruiselines` 0.00205397605896
(129) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00039410591125488
(130) DESCRIBE `cruises` 0.0030970573425293
(131) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72996') 0.00039505958557129
(132) DESCRIBE `ships` 0.0025029182434082
(133) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00064301490783691
(134) DESCRIBE `ships` 0.00335693359375
(135) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00032997131347656
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029897689819336
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028586387634277
(138) DESCRIBE `itineraries` 0.0013899803161621
(139) DESCRIBE `ports` 0.0014939308166504
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038790702819824
(141) DESCRIBE `ports` 0.0013959407806396
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035691261291504
(143) DESCRIBE `ports` 0.0013620853424072
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029301643371582
(145) DESCRIBE `sailingdates` 0.0015761852264404
(146) DESCRIBE `ports` 0.0015890598297119
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043892860412598
(148) DESCRIBE `ports` 0.001539945602417
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031304359436035
(150) DESCRIBE `ports` 0.0013220310211182
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0
(152) DESCRIBE `ports` 0.0014450550079346
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028395652770996
(154) DESCRIBE `ports` 0.0015249252319336
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031590461730957
(156) DESCRIBE `ports` 0.0013039112091064
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028300285339355
(158) DESCRIBE `ports` 0.0012550354003906
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00029683113098145
(160) DESCRIBE `ports` 0.0012860298156738
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00031399726867676
(162) DESCRIBE `ports` 0.001727819442749
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00044798851013184
(164) DESCRIBE `ports` 0.0014278888702393
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00030684471130371
(166) DESCRIBE `ports` 0.0015981197357178
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00037813186645508
(168) DESCRIBE `ports` 0.0017340183258057
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00031304359436035
(170) DESCRIBE `ports` 0.0013110637664795
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031399726867676
(172) DESCRIBE `ports` 0.0012500286102295
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027704238891602
(174) DESCRIBE `ports` 0.001349925994873
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031304359436035
(176) DESCRIBE `ports` 0.0012869834899902
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027990341186523
(178) DESCRIBE `avid_specials` 0.0012598037719727
(179) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72996 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0010058879852295
(180) DESCRIBE `cruiselines` 0.0018270015716553
(181) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00034880638122559
(182) DESCRIBE `orchid_image` 0.0014290809631348
(183) DESCRIBE `cruiselines` 0.0018360614776611
(184) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00034093856811523
(185) DESCRIBE `cruises` 0.0030641555786133
(186) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73034') 0.00035715103149414
(187) DESCRIBE `ships` 0.0025680065155029
(188) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00042605400085449
(189) DESCRIBE `ships` 0.0025839805603027
(190) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00034689903259277
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(192) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026512145996094
(193) DESCRIBE `itineraries` 0.0014750957489014
(194) DESCRIBE `ports` 0.0014212131500244
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036382675170898
(196) DESCRIBE `ports` 0.001288890838623
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034594535827637
(198) DESCRIBE `ports` 0.0015139579772949
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030207633972168
(200) DESCRIBE `sailingdates` 0.0011560916900635
(201) DESCRIBE `ports` 0.0013649463653564
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034403800964355
(203) DESCRIBE `ports` 0.0013329982757568
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028491020202637
(205) DESCRIBE `ports` 0.0013339519500732
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00034594535827637
(207) DESCRIBE `ports` 0.0013020038604736
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027918815612793
(209) DESCRIBE `ports` 0.0013329982757568
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00032711029052734
(211) DESCRIBE `ports` 0.0013649463653564
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00029110908508301
(213) DESCRIBE `ports` 0.0012760162353516
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00029301643371582
(215) DESCRIBE `ports` 0.0012590885162354
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00029492378234863
(217) DESCRIBE `ports` 0.0013329982757568
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0003049373626709
(219) DESCRIBE `ports` 0.0013790130615234
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037693977355957
(221) DESCRIBE `ports` 0.0014348030090332
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0003209114074707
(223) DESCRIBE `ports` 0.001352071762085
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00029397010803223
(225) DESCRIBE `ports` 0.0013039112091064
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00031304359436035
(227) DESCRIBE `ports` 0.0013129711151123
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028300285339355
(229) DESCRIBE `ports` 0.0012581348419189
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00032305717468262
(231) DESCRIBE `ports` 0.001492977142334
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0003511905670166
(233) DESCRIBE `ports` 0.0014050006866455
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00034809112548828
(235) DESCRIBE `ports` 0.0014288425445557
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00032210350036621
(237) DESCRIBE `ports` 0.001539945602417
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00035285949707031
(239) DESCRIBE `ports` 0.0015130043029785
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00029206275939941
(241) DESCRIBE `ports` 0.0014998912811279
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035214424133301
(243) DESCRIBE `ports` 0.0012989044189453
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029301643371582
(245) DESCRIBE `avid_specials` 0.0011591911315918
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73034 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0010371208190918
(247) DESCRIBE `cruiselines` 0.0018389225006104
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00033187866210938
(249) DESCRIBE `orchid_image` 0.0015621185302734
(250) DESCRIBE `cruiselines` 0.0026090145111084
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00045609474182129
(252) DESCRIBE `cruises` 0.0030620098114014
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72998') 0.0003669261932373
(254) DESCRIBE `ships` 0.0028159618377686
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00044679641723633
(256) DESCRIBE `ships` 0.002324104309082
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00057601928710938
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035405158996582
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(260) DESCRIBE `itineraries` 0.0017759799957275
(261) DESCRIBE `ports` 0.0018370151519775
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045990943908691
(263) DESCRIBE `ports` 0.0017209053039551
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045490264892578
(265) DESCRIBE `ports` 0.0022997856140137
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046205520629883
(267) DESCRIBE `sailingdates` 0.0022270679473877
(268) DESCRIBE `ports` 0.0017919540405273
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001060962677002
(270) DESCRIBE `ports` 0.0019030570983887
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0010058879852295
(272) DESCRIBE `ports` 0.0014641284942627
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00040507316589355
(274) DESCRIBE `ports` 0.0019199848175049
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00039196014404297
(276) DESCRIBE `ports` 0.0017240047454834
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00045013427734375
(278) DESCRIBE `ports` 0.0018610954284668
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00057506561279297
(280) DESCRIBE `ports` 0.0019910335540771
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00050497055053711
(282) DESCRIBE `ports` 0.0018720626831055
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00041103363037109
(284) DESCRIBE `ports` 0.0018019676208496
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00047898292541504
(286) DESCRIBE `ports` 0.0015730857849121
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00035595893859863
(288) DESCRIBE `ports` 0.0014629364013672
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0
(290) DESCRIBE `ports` 0.0015609264373779
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00034785270690918
(292) DESCRIBE `ports` 0.0016238689422607
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00036907196044922
(294) DESCRIBE `ports` 0.0014879703521729
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00021791458129883
(296) DESCRIBE `ports` 0.0015678405761719
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00046086311340332
(298) DESCRIBE `ports` 0.0011429786682129
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00031304359436035
(300) DESCRIBE `ports` 0.0013968944549561
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0003209114074707
(302) DESCRIBE `ports` 0.0015900135040283
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00036787986755371
(304) DESCRIBE `ports` 0.0012831687927246
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00032877922058105
(306) DESCRIBE `ports` 0.0014450550079346
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00035309791564941
(308) DESCRIBE `ports` 0.0013527870178223
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00042915344238281
(310) DESCRIBE `ports` 0.0018210411071777
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00043487548828125
(312) DESCRIBE `ports` 0.001971960067749
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049304962158203
(314) DESCRIBE `ports` 0.0020749568939209
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046801567077637
(316) DESCRIBE `ports` 0.0019030570983887
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050687789916992
(318) DESCRIBE `ports` 0.002485990524292
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047707557678223
(320) DESCRIBE `avid_specials` 0.0019941329956055
(321) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72998 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0012328624725342
(322) DESCRIBE `cruiselines` 0.0024690628051758
(323) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00043797492980957
(324) DESCRIBE `orchid_image` 0.0018851757049561
(325) DESCRIBE `cruiselines` 0.0030198097229004
(326) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00047707557678223
(327) DESCRIBE `cruises` 0.00388503074646
(328) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72999') 0.00052499771118164
(329) DESCRIBE `ships` 0.0037450790405273
(330) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00075197219848633
(331) DESCRIBE `ships` 0.0031001567840576
(332) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00042200088500977
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030803680419922
(334) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(335) DESCRIBE `itineraries` 0.0012950897216797
(336) DESCRIBE `ports` 0.0014410018920898
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035691261291504
(338) DESCRIBE `ports` 0.0013508796691895
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00075387954711914
(340) DESCRIBE `ports` 0.0017287731170654
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040102005004883
(342) DESCRIBE `sailingdates` 0.0015089511871338
(343) DESCRIBE `ports` 0.0018880367279053
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045084953308105
(345) DESCRIBE `ports` 0.0016438961029053
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035405158996582
(347) DESCRIBE `ports` 0.001554012298584
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00041604042053223
(349) DESCRIBE `ports` 0.0022151470184326
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00049185752868652
(351) DESCRIBE `ports` 0.0015449523925781
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044703483581543
(353) DESCRIBE `ports` 0.002202033996582
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00045204162597656
(355) DESCRIBE `ports` 0.0017349720001221
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00049901008605957
(357) DESCRIBE `ports` 0.0018680095672607
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00056195259094238
(359) DESCRIBE `ports` 0.0019540786743164
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00050210952758789
(361) DESCRIBE `ports` 0.0021328926086426
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00048708915710449
(363) DESCRIBE `ports` 0.0021169185638428
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00059795379638672
(365) DESCRIBE `ports` 0.0021729469299316
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00046300888061523
(367) DESCRIBE `ports` 0.0019299983978271
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00050091743469238
(369) DESCRIBE `ports` 0.0020489692687988
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00049996376037598
(371) DESCRIBE `ports` 0.0020129680633545
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00052905082702637
(373) DESCRIBE `ports` 0.0018939971923828
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00042414665222168
(375) DESCRIBE `ports` 0.001762866973877
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00056695938110352
(377) DESCRIBE `ports` 0.0021259784698486
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00054001808166504
(379) DESCRIBE `ports` 0.0019829273223877
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00056219100952148
(381) DESCRIBE `ports` 0.0022289752960205
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00055193901062012
(383) DESCRIBE `ports` 0.0025370121002197
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00086593627929688
(385) DESCRIBE `ports` 0.0020790100097656
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00046086311340332
(387) DESCRIBE `ports` 0.001953125
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 417))) 0.00052595138549805
(389) DESCRIBE `ports` 0.0016911029815674
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '417') 0.00038719177246094
(391) DESCRIBE `ports` 0.0016310214996338
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046896934509277
(393) DESCRIBE `ports` 0.0020060539245605
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00049018859863281
(395) DESCRIBE `avid_specials` 0.0020849704742432
(396) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72999 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.001863956451416
(397) DESCRIBE `cruiselines` 0.0027182102203369
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00062298774719238
(399) DESCRIBE `orchid_image` 0.0023839473724365
(400) DESCRIBE `cruiselines` 0.0029032230377197
(401) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00049901008605957
(402) DESCRIBE `cruises` 0.005620002746582
(403) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73033') 0.0011050701141357
(404) DESCRIBE `ships` 0.0037868022918701
(405) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00080084800720215
(406) DESCRIBE `ships` 0.0042588710784912
(407) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00059795379638672
(408) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00070619583129883
(409) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003049373626709
(410) DESCRIBE `itineraries` 0.0019760131835938
(411) DESCRIBE `ports` 0.0023219585418701
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00055313110351562
(413) DESCRIBE `ports` 0.0021841526031494
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00052380561828613
(415) DESCRIBE `ports` 0.0019829273223877
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00045394897460938
(417) DESCRIBE `sailingdates` 0.0043787956237793
(418) DESCRIBE `ports` 0.0040199756622314
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00063300132751465
(420) DESCRIBE `ports` 0.0063400268554688
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00069403648376465
(422) DESCRIBE `ports` 0.0020580291748047
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00054192543029785
(424) DESCRIBE `ports` 0.0024120807647705
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00057792663574219
(426) DESCRIBE `ports` 0.0020749568939209
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00082302093505859
(428) DESCRIBE `ports` 0.0026798248291016
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00026702880859375
(430) DESCRIBE `ports` 0.0020849704742432
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00053286552429199
(432) DESCRIBE `ports` 0.0018570423126221
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00072002410888672
(434) DESCRIBE `ports` 0.0022950172424316
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00059294700622559
(436) DESCRIBE `ports` 0.00217604637146
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00048494338989258
(438) DESCRIBE `ports` 0.0020310878753662
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00048208236694336
(440) DESCRIBE `ports` 0.0020768642425537
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00046706199645996
(442) DESCRIBE `ports` 0.0023660659790039
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2932))) 0.00054693222045898
(444) DESCRIBE `ports` 0.0021810531616211
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2932') 0.00046300888061523
(446) DESCRIBE `ports` 0.0020320415496826
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00054001808166504
(448) DESCRIBE `ports` 0.0021419525146484
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00049519538879395
(450) DESCRIBE `ports` 0.0017502307891846
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00053715705871582
(452) DESCRIBE `ports` 0.0021610260009766
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00044989585876465
(454) DESCRIBE `avid_specials` 0.0017468929290771
(455) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73033 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 35 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.0027239322662354
(456) DESCRIBE `cruiselines` 0.0024929046630859
(457) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.001162052154541
(458) DESCRIBE `orchid_image` 0.0023198127746582
(459) DESCRIBE `cruiselines` 0.0029058456420898
(460) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0007319450378418
(461) DESCRIBE `cruises` 0.004594087600708
(462) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78355') 0.00058794021606445
(463) DESCRIBE `ships` 0.0043001174926758
(464) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.0013370513916016
(465) DESCRIBE `ships` 0.0043787956237793
(466) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00057888031005859
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034785270690918
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033283233642578
(469) DESCRIBE `itineraries` 0.0021061897277832
(470) DESCRIBE `ports` 0.0022518634796143
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00057411193847656
(472) DESCRIBE `ports` 0.0020730495452881
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00063300132751465
(474) DESCRIBE `ports` 0.0030949115753174
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00051784515380859
(476) DESCRIBE `sailingdates` 0.0017390251159668
(477) DESCRIBE `ports` 0.0050129890441895
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00035500526428223
(479) DESCRIBE `ports` 0.0021419525146484
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00049495697021484
(481) DESCRIBE `ports` 0.0020599365234375
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00055408477783203
(483) DESCRIBE `ports` 0.0020608901977539
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00049710273742676
(485) DESCRIBE `ports` 0.0018739700317383
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2932))) 0.00097513198852539
(487) DESCRIBE `ports` 0.0018930435180664
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2932') 0.00070691108703613
(489) DESCRIBE `ports` 0.0020060539245605
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00049400329589844
(491) DESCRIBE `ports` 0.0020241737365723
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00047993659973145
(493) DESCRIBE `ports` 0.0020301342010498
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00051712989807129
(495) DESCRIBE `ports` 0.0021159648895264
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00045299530029297
(497) DESCRIBE `ports` 0.0018808841705322
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00047397613525391
(499) DESCRIBE `ports` 0.0018730163574219
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00040888786315918
(501) DESCRIBE `ports` 0.0019102096557617
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00047993659973145
(503) DESCRIBE `ports` 0.0023930072784424
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00045108795166016
(505) DESCRIBE `ports` 0.0022249221801758
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00053715705871582
(507) DESCRIBE `ports` 0.0023398399353027
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00066089630126953
(509) DESCRIBE `ports` 0.0023770332336426
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00053906440734863
(511) DESCRIBE `ports` 0.0018899440765381
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00064992904663086
(513) DESCRIBE `ports` 0.0031850337982178
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00066709518432617
(515) DESCRIBE `ports` 0.0059459209442139
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00048613548278809
(517) DESCRIBE `avid_specials` 0.0017421245574951
(518) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78355 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 35 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.0025429725646973
(519) DESCRIBE `cruiselines` 0.0027198791503906
(520) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00052404403686523
(521) DESCRIBE `orchid_image` 0.0095129013061523
(522) DESCRIBE `cruiselines` 0.003774881362915
(523) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00055909156799316
(524) DESCRIBE `cruises` 0.0093441009521484
(525) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78356') 0.00054717063903809
(526) DESCRIBE `ships` 0.004321813583374
(527) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00211501121521
(528) DESCRIBE `ships` 0.0091869831085205
(529) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00058579444885254
(530) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045204162597656
(531) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035381317138672
(532) DESCRIBE `itineraries` 0.0022199153900146
(533) DESCRIBE `ports` 0.0022659301757812
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00048208236694336
(535) DESCRIBE `ports` 0.0019528865814209
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0080549716949463
(537) DESCRIBE `ports` 0.0039269924163818
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0036201477050781
(539) DESCRIBE `sailingdates` 0.0020580291748047
(540) DESCRIBE `ports` 0.0025341510772705
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0012140274047852
(542) DESCRIBE `ports` 0.0021250247955322
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00044417381286621
(544) DESCRIBE `ports` 0.003331184387207
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00055384635925293
(546) DESCRIBE `ports` 0.0028259754180908
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.0026881694793701
(548) DESCRIBE `ports` 0.043529987335205
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.0028378963470459
(550) DESCRIBE `ports` 0.0024781227111816
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00065112113952637
(552) DESCRIBE `ports` 0.0021500587463379
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00058698654174805
(554) DESCRIBE `ports` 0.002051830291748
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00045180320739746
(556) DESCRIBE `ports` 0.00177001953125
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00044989585876465
(558) DESCRIBE `ports` 0.032641887664795
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00060296058654785
(560) DESCRIBE `ports` 0.0021920204162598
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00051498413085938
(562) DESCRIBE `ports` 0.0019991397857666
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00043296813964844
(564) DESCRIBE `ports` 0.0019021034240723
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00047612190246582
(566) DESCRIBE `ports` 0.0019299983978271
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00044798851013184
(568) DESCRIBE `avid_specials` 0.0017490386962891
(569) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78356 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 35 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.0017731189727783
(570) DESCRIBE `cruiselines` 0.0030100345611572
(571) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00053000450134277
(572) DESCRIBE `orchid_image` 0.00972580909729
(573) DESCRIBE `cruiselines` 0.036834955215454
(574) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00060796737670898
(575) DESCRIBE `cruises` 0.0064389705657959
(576) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78354') 0.00054502487182617
(577) DESCRIBE `ships` 0.0038900375366211
(578) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.014853954315186
(579) DESCRIBE `ships` 0.0155029296875
(580) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00067305564880371
(581) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(582) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034213066101074
(583) DESCRIBE `itineraries` 0.031737804412842
(584) DESCRIBE `ports` 0.0019299983978271
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0004580020904541
(586) DESCRIBE `ports` 0.0016019344329834
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00043416023254395
(588) DESCRIBE `ports` 0.001655101776123
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00037813186645508
(590) DESCRIBE `sailingdates` 0.0014359951019287
(591) DESCRIBE `ports` 0.0027379989624023
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00073504447937012
(593) DESCRIBE `ports` 0.0061919689178467
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00049400329589844
(595) DESCRIBE `ports` 0.0016238689422607
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00064897537231445
(597) DESCRIBE `ports` 0.0021970272064209
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00045609474182129
(599) DESCRIBE `ports` 0.0024650096893311
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.0010519027709961
(601) DESCRIBE `ports` 0.0030410289764404
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.000518798828125
(603) DESCRIBE `ports` 0.0027890205383301
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 188))) 0.00063395500183105
(605) DESCRIBE `ports` 0.0028040409088135
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '188') 0.00075197219848633
(607) DESCRIBE `ports` 0.0034828186035156
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00056886672973633
(609) DESCRIBE `ports` 0.002659797668457
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00066304206848145
(611) DESCRIBE `ports` 0.0025260448455811
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00068187713623047
(613) DESCRIBE `ports` 0.001431941986084
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00097799301147461
(615) DESCRIBE `avid_specials` 0.0024950504302979
(616) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78354 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 35 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.0016920566558838
(617) DESCRIBE `cruiselines` 0.0031931400299072
(618) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00061607360839844
(619) DESCRIBE `orchid_image` 0.0023150444030762
(620) DESCRIBE `cruiselines` 0.0027778148651123
(621) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00046706199645996
(622) DESCRIBE `cruisetypes` 0.0017120838165283
(623) DESCRIBE `destinations` 0.0028529167175293
(624) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '43', '35', '8', '29', '34')) ORDER BY FIND_IN_SET(id, '2,43,35,8,29,34') 0.0013880729675293
(625) DESCRIBE `cruiselines` 0.003486156463623
(626) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0010149478912354
(627) DESCRIBE `ships` 0.0040969848632812
(628) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00065088272094727
(629) DESCRIBE `cruiselines` 0.0030839443206787
(630) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0005650520324707
(631) DESCRIBE `ships` 0.0041561126708984
(632) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00075197219848633