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

Total elapsed time: 1.4293954372406

# Query Time
(1) connect 0.0014338493347168
(2) DESCRIBE `cruises` 0.0044028759002686
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68107, 75673, 62663, 73135, 69256, 73136, 68108, 74683, 62689, 69086)) ORDER BY FIND_IN_SET(id, '68107,75673,62663,73135,69256,73136,68108,74683,62689,69086') 0.0031759738922119
(4) DESCRIBE `cruises` 0.0039420127868652
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68107') 0.00063586235046387
(6) DESCRIBE `ships` 0.0038540363311768
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00074315071105957
(8) DESCRIBE `ships` 0.0043351650238037
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00060486793518066
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0008699893951416
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0007622241973877
(12) DESCRIBE `itineraries` 0.0025069713592529
(13) DESCRIBE `ports` 0.0024969577789307
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00058388710021973
(15) DESCRIBE `ports` 0.0020751953125
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00054812431335449
(17) DESCRIBE `ports` 0.002065896987915
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00045013427734375
(19) DESCRIBE `sailingdates` 0.0018429756164551
(20) DESCRIBE `ports` 0.0023958683013916
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022101402282715
(22) DESCRIBE `ports` 0.0020790100097656
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00058412551879883
(24) DESCRIBE `ports` 0.0019500255584717
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00054407119750977
(26) DESCRIBE `ports` 0.0019590854644775
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002129077911377
(28) DESCRIBE `ports` 0.001884937286377
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00046610832214355
(30) DESCRIBE `ports` 0.0018320083618164
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0001060962677002
(32) DESCRIBE `ports` 0.0025861263275146
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00058388710021973
(34) DESCRIBE `ports` 0.0021841526031494
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00047802925109863
(36) DESCRIBE `ports` 0.0016419887542725
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00027203559875488
(38) DESCRIBE `ports` 0.0027520656585693
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00052094459533691
(40) DESCRIBE `ports` 0.0024569034576416
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00052905082702637
(42) DESCRIBE `ports` 0.0026600360870361
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00032806396484375
(44) DESCRIBE `ports` 0.0023097991943359
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00094294548034668
(46) DESCRIBE `ports` 0.0028810501098633
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00055217742919922
(48) DESCRIBE `ports` 0.002777099609375
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00068306922912598
(50) DESCRIBE `ports` 0.0030288696289062
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00081396102905273
(52) DESCRIBE `ports` 0.0026609897613525
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00040292739868164
(54) DESCRIBE `ports` 0.0042498111724854
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00045609474182129
(56) DESCRIBE `ports` 0.0028750896453857
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00055098533630371
(58) DESCRIBE `ports` 0.0020060539245605
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0004429817199707
(60) DESCRIBE `avid_specials` 0.0018620491027832
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68107 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0018439292907715
(62) DESCRIBE `cruiselines` 0.0037069320678711
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00096797943115234
(64) DESCRIBE `orchid_image` 0.0031471252441406
(65) DESCRIBE `cruiselines` 0.0044331550598145
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00056982040405273
(67) DESCRIBE `cruises` 0.0060410499572754
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75673') 0.0013868808746338
(69) DESCRIBE `ships` 0.0035660266876221
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00136399269104
(71) DESCRIBE `ships` 0.0052618980407715
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00057601928710938
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049996376037598
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(75) DESCRIBE `itineraries` 0.0017638206481934
(76) DESCRIBE `ports` 0.0020589828491211
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005338191986084
(78) DESCRIBE `ports` 0.0018770694732666
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041699409484863
(80) DESCRIBE `ports` 0.0019779205322266
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00090193748474121
(82) DESCRIBE `sailingdates` 0.0081908702850342
(83) DESCRIBE `ports` 0.0021800994873047
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005040168762207
(85) DESCRIBE `ports` 0.0018701553344727
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044083595275879
(87) DESCRIBE `ports` 0.0017669200897217
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00041103363037109
(89) DESCRIBE `ports` 0.0017991065979004
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0
(91) DESCRIBE `ports` 0.0018939971923828
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0010519027709961
(93) DESCRIBE `ports` 0.0017971992492676
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00044393539428711
(95) DESCRIBE `ports` 0.0014209747314453
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00044798851013184
(97) DESCRIBE `ports` 0.002004861831665
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00049304962158203
(99) DESCRIBE `ports` 0.0044620037078857
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00053715705871582
(101) DESCRIBE `ports` 0.0018980503082275
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00044417381286621
(103) DESCRIBE `ports` 0.0019509792327881
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0021018981933594
(105) DESCRIBE `ports` 0.0021250247955322
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00039505958557129
(107) DESCRIBE `ports` 0.0015861988067627
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00058293342590332
(109) DESCRIBE `ports` 0.0023000240325928
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00054717063903809
(111) DESCRIBE `avid_specials` 0.0019559860229492
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75673 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 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.002032995223999
(113) DESCRIBE `cruiselines` 0.0030689239501953
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0021989345550537
(115) DESCRIBE `orchid_image` 0.0024571418762207
(116) DESCRIBE `cruiselines` 0.0029051303863525
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00050687789916992
(118) DESCRIBE `cruises` 0.0041499137878418
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62663') 0.00055098533630371
(120) DESCRIBE `ships` 0.0042839050292969
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.0010330677032471
(122) DESCRIBE `ships` 0.0046157836914062
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00059795379638672
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033116340637207
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031089782714844
(126) DESCRIBE `itineraries` 0.0019400119781494
(127) DESCRIBE `ports` 0.0021510124206543
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00051593780517578
(129) DESCRIBE `ports` 0.0021200180053711
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00053310394287109
(131) DESCRIBE `ports` 0.003108024597168
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00047779083251953
(133) DESCRIBE `sailingdates` 0.0020589828491211
(134) DESCRIBE `ports` 0.0025479793548584
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00053691864013672
(136) DESCRIBE `ports` 0.0019941329956055
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00029897689819336
(138) DESCRIBE `ports` 0.0020439624786377
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00056815147399902
(140) DESCRIBE `ports` 0.0021100044250488
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00048089027404785
(142) DESCRIBE `ports` 0.0087771415710449
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0020990371704102
(144) DESCRIBE `ports` 0.0029311180114746
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00046396255493164
(146) DESCRIBE `ports` 0.0020148754119873
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00046801567077637
(148) DESCRIBE `ports` 0.001939058303833
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00049996376037598
(150) DESCRIBE `ports` 0.0018539428710938
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0010368824005127
(152) DESCRIBE `ports` 0.0020220279693604
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00048589706420898
(154) DESCRIBE `ports` 0.0019979476928711
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00054597854614258
(156) DESCRIBE `ports` 0.0018308162689209
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0004279613494873
(158) DESCRIBE `ports` 0.0017960071563721
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00048613548278809
(160) DESCRIBE `ports` 0.0023629665374756
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00046110153198242
(162) DESCRIBE `avid_specials` 0.0014770030975342
(163) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62663 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0017149448394775
(164) DESCRIBE `cruiselines` 0.0037150382995605
(165) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00058698654174805
(166) DESCRIBE `orchid_image` 0.0035948753356934
(167) DESCRIBE `cruiselines` 0.0067601203918457
(168) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00060009956359863
(169) DESCRIBE `cruises` 0.0044300556182861
(170) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73135') 0.00063300132751465
(171) DESCRIBE `ships` 0.0038220882415771
(172) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00065302848815918
(173) DESCRIBE `ships` 0.0047159194946289
(174) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.0005650520324707
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034379959106445
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035905838012695
(177) DESCRIBE `itineraries` 0.0019400119781494
(178) DESCRIBE `ports` 0.0021660327911377
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00054001808166504
(180) DESCRIBE `ports` 0.0020198822021484
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0011420249938965
(182) DESCRIBE `ports` 0.0031402111053467
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00045990943908691
(184) DESCRIBE `sailingdates` 0.0011038780212402
(185) DESCRIBE `ports` 0.0024709701538086
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00047612190246582
(187) DESCRIBE `ports` 0.0020730495452881
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00059604644775391
(189) DESCRIBE `ports` 0.0021650791168213
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00066590309143066
(191) DESCRIBE `ports` 0.0028510093688965
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00051188468933105
(193) DESCRIBE `ports` 0.0077900886535645
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0067310333251953
(195) DESCRIBE `ports` 0.0030250549316406
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0043609142303467
(197) DESCRIBE `ports` 0.0023419857025146
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00057005882263184
(199) DESCRIBE `ports` 0.0020508766174316
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00045990943908691
(201) DESCRIBE `ports` 0.0017809867858887
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00055718421936035
(203) DESCRIBE `ports` 0.0019078254699707
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.0006411075592041
(205) DESCRIBE `ports` 0.0030620098114014
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00092697143554688
(207) DESCRIBE `ports` 0.0024149417877197
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00047516822814941
(209) DESCRIBE `ports` 0.0024800300598145
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00072908401489258
(211) DESCRIBE `ports` 0.001910924911499
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00073385238647461
(213) DESCRIBE `avid_specials` 0.0015439987182617
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73135 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 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.001276969909668
(215) DESCRIBE `cruiselines` 0.0031988620758057
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.001812219619751
(217) DESCRIBE `orchid_image` 0.0023679733276367
(218) DESCRIBE `cruiselines` 0.0037329196929932
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00054597854614258
(220) DESCRIBE `cruises` 0.0041677951812744
(221) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69256') 0.00065088272094727
(222) DESCRIBE `ships` 0.0043721199035645
(223) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.0007021427154541
(224) DESCRIBE `ships` 0.0039629936218262
(225) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00061297416687012
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(228) DESCRIBE `itineraries` 0.0030648708343506
(229) DESCRIBE `ports` 0.0023050308227539
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.0005030632019043
(231) DESCRIBE `ports` 0.0027711391448975
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00058293342590332
(233) DESCRIBE `ports` 0.0066139698028564
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00054097175598145
(235) DESCRIBE `sailingdates` 0.0018260478973389
(236) DESCRIBE `ports` 0.0028519630432129
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00056600570678711
(238) DESCRIBE `ports` 0.0026090145111084
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00051498413085938
(240) DESCRIBE `ports` 0.0022690296173096
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00050997734069824
(242) DESCRIBE `ports` 0.0021359920501709
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00055098533630371
(244) DESCRIBE `ports` 0.0018641948699951
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.0004570484161377
(246) DESCRIBE `ports` 0.0018608570098877
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.0004880428314209
(248) DESCRIBE `ports` 0.0027689933776855
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00058913230895996
(250) DESCRIBE `ports` 0.0021448135375977
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00046396255493164
(252) DESCRIBE `avid_specials` 0.0017678737640381
(253) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69256 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.0020091533660889
(254) DESCRIBE `cruiselines` 0.0029768943786621
(255) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0005948543548584
(256) DESCRIBE `orchid_image` 0.0021908283233643
(257) DESCRIBE `cruiselines` 0.0030999183654785
(258) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00050902366638184
(259) DESCRIBE `cruises` 0.004033088684082
(260) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73136') 0
(261) DESCRIBE `ships` 0.004019021987915
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00059795379638672
(263) DESCRIBE `ships` 0.0036029815673828
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00051403045654297
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003960132598877
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042414665222168
(267) DESCRIBE `itineraries` 0.0019071102142334
(268) DESCRIBE `ports` 0.0020079612731934
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00051403045654297
(270) DESCRIBE `ports` 0.0021100044250488
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00054287910461426
(272) DESCRIBE `ports` 0.0019049644470215
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00047898292541504
(274) DESCRIBE `sailingdates` 0.0017359256744385
(275) DESCRIBE `ports` 0.002985954284668
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00066685676574707
(277) DESCRIBE `ports` 0.0021939277648926
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0010559558868408
(279) DESCRIBE `ports` 0.0020880699157715
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00049996376037598
(281) DESCRIBE `ports` 0.0020821094512939
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00051689147949219
(283) DESCRIBE `ports` 0.0041878223419189
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00084185600280762
(285) DESCRIBE `ports` 0.002345085144043
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00051307678222656
(287) DESCRIBE `ports` 0.0023059844970703
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.0028998851776123
(289) DESCRIBE `ports` 0.0022549629211426
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.0014710426330566
(291) DESCRIBE `ports` 0.003309965133667
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00056600570678711
(293) DESCRIBE `ports` 0.0021600723266602
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00048303604125977
(295) DESCRIBE `ports` 0.0017399787902832
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0011811256408691
(297) DESCRIBE `ports` 0.0035707950592041
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00044393539428711
(299) DESCRIBE `ports` 0.0018868446350098
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00043797492980957
(301) DESCRIBE `ports` 0.0019268989562988
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0018398761749268
(303) DESCRIBE `ports` 0.0054240226745605
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0093250274658203
(305) DESCRIBE `ports` 0.0033400058746338
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00054788589477539
(307) DESCRIBE `ports` 0.0019440650939941
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00043892860412598
(309) DESCRIBE `ports` 0.003911018371582
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00050806999206543
(311) DESCRIBE `ports` 0.0019810199737549
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00049495697021484
(313) DESCRIBE `ports` 0.002108097076416
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0011570453643799
(315) DESCRIBE `ports` 0.0020718574523926
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0013461112976074
(317) DESCRIBE `ports` 0.0021469593048096
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00095486640930176
(319) DESCRIBE `ports` 0.006605863571167
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0018069744110107
(321) DESCRIBE `ports` 0.0097160339355469
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00042486190795898
(323) DESCRIBE `ports` 0.037374973297119
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0082259178161621
(325) DESCRIBE `ports` 0.027431964874268
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00047111511230469
(327) DESCRIBE `avid_specials` 0.0018739700317383
(328) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73136 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 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.0021250247955322
(329) DESCRIBE `cruiselines` 0.0029559135437012
(330) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00052380561828613
(331) DESCRIBE `orchid_image` 0.0021028518676758
(332) DESCRIBE `cruiselines` 0.0029351711273193
(333) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00050592422485352
(334) DESCRIBE `cruises` 0.0039150714874268
(335) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68108') 0.0010390281677246
(336) DESCRIBE `ships` 0.0040950775146484
(337) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00078392028808594
(338) DESCRIBE `ships` 0.02052903175354
(339) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00064706802368164
(340) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038814544677734
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035715103149414
(342) DESCRIBE `itineraries` 0.002169132232666
(343) DESCRIBE `ports` 0.0021390914916992
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00050711631774902
(345) DESCRIBE `ports` 0.0019879341125488
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046515464782715
(347) DESCRIBE `ports` 0.0019018650054932
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042200088500977
(349) DESCRIBE `sailingdates` 0.0017440319061279
(350) DESCRIBE `ports` 0.0021598339080811
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00052595138549805
(352) DESCRIBE `ports` 0.005014181137085
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00067520141601562
(354) DESCRIBE `ports` 0.0023729801177979
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00053501129150391
(356) DESCRIBE `ports` 0.0019931793212891
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00047612190246582
(358) DESCRIBE `ports` 0.0019359588623047
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00047397613525391
(360) DESCRIBE `ports` 0.0018999576568604
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00048589706420898
(362) DESCRIBE `ports` 0.002004861831665
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00061607360839844
(364) DESCRIBE `ports` 0.0019888877868652
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.0005340576171875
(366) DESCRIBE `ports` 0.001884937286377
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00053596496582031
(368) DESCRIBE `ports` 0.0019819736480713
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00044989585876465
(370) DESCRIBE `ports` 0.001910924911499
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00047993659973145
(372) DESCRIBE `ports` 0.0017158985137939
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00040698051452637
(374) DESCRIBE `ports` 0.001971960067749
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00055599212646484
(376) DESCRIBE `ports` 0.0021078586578369
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00043797492980957
(378) DESCRIBE `ports` 0.0020289421081543
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00050997734069824
(380) DESCRIBE `ports` 0.0020790100097656
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00043511390686035
(382) DESCRIBE `ports` 0.0019969940185547
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00051498413085938
(384) DESCRIBE `ports` 0.018332958221436
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0006248950958252
(386) DESCRIBE `ports` 0.0021851062774658
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004889965057373
(388) DESCRIBE `ports` 0.0022909641265869
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00050497055053711
(390) DESCRIBE `avid_specials` 0.0018928050994873
(391) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68108 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0017879009246826
(392) DESCRIBE `cruiselines` 0.0029311180114746
(393) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00063586235046387
(394) DESCRIBE `orchid_image` 0.002249002456665
(395) DESCRIBE `cruiselines` 0.0029788017272949
(396) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00049495697021484
(397) DESCRIBE `cruises` 0.0044450759887695
(398) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74683') 0.00065898895263672
(399) DESCRIBE `ships` 0.0038101673126221
(400) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 352))) 0.00055313110351562
(401) DESCRIBE `ships` 0.0039031505584717
(402) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '352') 0.0004880428314209
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(404) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032210350036621
(405) DESCRIBE `itineraries` 0.0019850730895996
(406) DESCRIBE `ports` 0.002133846282959
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0004889965057373
(408) DESCRIBE `ports` 0.08390998840332
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00079607963562012
(410) DESCRIBE `ports` 0.012773990631104
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.001194953918457
(412) DESCRIBE `sailingdates` 0.0017828941345215
(413) DESCRIBE `ports` 0.0023300647735596
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00057506561279297
(415) DESCRIBE `ports` 0.0020201206207275
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00048589706420898
(417) DESCRIBE `ports` 0.0020420551300049
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00052309036254883
(419) DESCRIBE `ports` 0.0024588108062744
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00060486793518066
(421) DESCRIBE `ports` 0.0021758079528809
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.0005958080291748
(423) DESCRIBE `ports` 0.0021069049835205
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00050687789916992
(425) DESCRIBE `ports` 0.0020380020141602
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00055813789367676
(427) DESCRIBE `ports` 0.0020279884338379
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00054407119750977
(429) DESCRIBE `ports` 0.0042779445648193
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.0021548271179199
(431) DESCRIBE `ports` 0.026690006256104
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00055384635925293
(433) DESCRIBE `ports` 0.0019879341125488
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.0060949325561523
(435) DESCRIBE `ports` 0.0024259090423584
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.0025060176849365
(437) DESCRIBE `ports` 0.003108024597168
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00064301490783691
(439) DESCRIBE `ports` 0.029952049255371
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00078701972961426
(441) DESCRIBE `ports` 0.0020771026611328
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2939))) 0.00086092948913574
(443) DESCRIBE `ports` 0.0020909309387207
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2939') 0.00049591064453125
(445) DESCRIBE `ports` 0.0020279884338379
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 816))) 0.00051188468933105
(447) DESCRIBE `ports` 0.0020360946655273
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '816') 0.00047707557678223
(449) DESCRIBE `ports` 0.0020937919616699
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00058889389038086
(451) DESCRIBE `ports` 0.0021040439605713
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00047087669372559
(453) DESCRIBE `ports` 0.0019669532775879
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00051593780517578
(455) DESCRIBE `ports` 0.0019569396972656
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00046801567077637
(457) DESCRIBE `avid_specials` 0.0018479824066162
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74683 and class = 'Cruise') OR (item_id = 352 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.0019879341125488
(459) DESCRIBE `cruiselines` 0.0025961399078369
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00051689147949219
(461) DESCRIBE `orchid_image` 0.0019168853759766
(462) DESCRIBE `cruiselines` 0.0024330615997314
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00042295455932617
(464) DESCRIBE `cruises` 0.00347900390625
(465) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62689') 0.00049304962158203
(466) DESCRIBE `ships` 0.0039501190185547
(467) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00063991546630859
(468) DESCRIBE `ships` 0.040508985519409
(469) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00059795379638672
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036382675170898
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0060229301452637
(472) DESCRIBE `itineraries` 0.010439872741699
(473) DESCRIBE `ports` 0.0074198246002197
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0056390762329102
(475) DESCRIBE `ports` 0.0020949840545654
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00057601928710938
(477) DESCRIBE `ports` 0.0020909309387207
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00048089027404785
(479) DESCRIBE `sailingdates` 0.0018329620361328
(480) DESCRIBE `ports` 0.0024688243865967
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00067901611328125
(482) DESCRIBE `ports` 0.0020110607147217
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00045204162597656
(484) DESCRIBE `ports` 0.0020551681518555
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00053906440734863
(486) DESCRIBE `ports` 0.01065993309021
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00058388710021973
(488) DESCRIBE `ports` 0.0020971298217773
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00059294700622559
(490) DESCRIBE `ports` 0.0020229816436768
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00049614906311035
(492) DESCRIBE `ports` 0.0086860656738281
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00072598457336426
(494) DESCRIBE `ports` 0.020303010940552
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00060796737670898
(496) DESCRIBE `ports` 0.0020298957824707
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00050783157348633
(498) DESCRIBE `ports` 0.021563053131104
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00054478645324707
(500) DESCRIBE `ports` 0.0021488666534424
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00088810920715332
(502) DESCRIBE `ports` 0.0021021366119385
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00012683868408203
(504) DESCRIBE `ports` 0.0020802021026611
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00019001960754395
(506) DESCRIBE `ports` 0.0019598007202148
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00044417381286621
(508) DESCRIBE `avid_specials` 0.001924991607666
(509) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62689 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 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.0019521713256836
(510) DESCRIBE `cruiselines` 0.0029559135437012
(511) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0023128986358643
(512) DESCRIBE `orchid_image` 0.0022661685943604
(513) DESCRIBE `cruiselines` 0.0030319690704346
(514) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0011410713195801
(515) DESCRIBE `cruises` 0.0039370059967041
(516) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69086') 0.00052905082702637
(517) DESCRIBE `ships` 0.0037820339202881
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00067496299743652
(519) DESCRIBE `ships` 0.0041279792785645
(520) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00058817863464355
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035905838012695
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033783912658691
(523) DESCRIBE `itineraries` 0.0020318031311035
(524) DESCRIBE `ports` 0.0023128986358643
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00088691711425781
(526) DESCRIBE `ports` 0.0020990371704102
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00060606002807617
(528) DESCRIBE `ports` 0.0024080276489258
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00052404403686523
(530) DESCRIBE `sailingdates` 0.0020229816436768
(531) DESCRIBE `ports` 0.0020711421966553
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00046491622924805
(533) DESCRIBE `ports` 0.0016560554504395
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00037503242492676
(535) DESCRIBE `ports` 0.0017008781433105
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00049710273742676
(537) DESCRIBE `ports` 0.0017831325531006
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00047016143798828
(539) DESCRIBE `ports` 0.015882015228271
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.0006859302520752
(541) DESCRIBE `ports` 0.03070592880249
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00093793869018555
(543) DESCRIBE `ports` 0.0021069049835205
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00059103965759277
(545) DESCRIBE `ports` 0.0020651817321777
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00059890747070312
(547) DESCRIBE `avid_specials` 0.0018119812011719
(548) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69086 and class = 'Cruise') OR (item_id = 1588 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 37 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.0018179416656494
(549) DESCRIBE `cruiselines` 0.0029900074005127
(550) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00063085556030273
(551) DESCRIBE `orchid_image` 0.0025649070739746
(552) DESCRIBE `cruiselines` 0.0032930374145508
(553) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00067996978759766
(554) DESCRIBE `ships` 0.054169893264771
(555) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1599', '1359', '1067', '1588', '407', '726', '1768', '1415', '462', '766', '452', '674', '553', '1717', '738', '610', '352')) ORDER BY FIND_IN_SET(id, '977,1599,1359,1067,1588,407,726,1768,1415,462,766,452,674,553,1717,738,610,352') 0.0026509761810303
(556) DESCRIBE `cruisetypes` 0.0018479824066162
(557) DESCRIBE `destinations` 0.0027370452880859
(558) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '45', '26', '25', '37', '28', '52', '40', '38', '9', '49', '11', '21', '35')) ORDER BY FIND_IN_SET(id, '22,12,45,26,25,37,28,52,40,38,9,49,11,21,35') 0.0017480850219727
(559) DESCRIBE `cruiselines` 0.0032339096069336
(560) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00061893463134766
(561) DESCRIBE `cruiselines` 0.0065679550170898
(562) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00060105323791504