or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 1.125467300415

# Query Time
(1) connect 0.00070810317993164
(2) DESCRIBE `cruises` 0.0035140514373779
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62062, 68466, 82242, 75704, 75710, 75711, 75716, 75705, 75714, 75717)) ORDER BY FIND_IN_SET(id, '62062,68466,82242,75704,75710,75711,75716,75705,75714,75717') 0.0021400451660156
(4) DESCRIBE `cruises` 0.0037999153137207
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62062') 0.00051498413085938
(6) DESCRIBE `ships` 0.0037660598754883
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00062108039855957
(8) DESCRIBE `ships` 0.0038111209869385
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00049304962158203
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030112266540527
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029921531677246
(12) DESCRIBE `itineraries` 0.0015101432800293
(13) DESCRIBE `ports` 0.0019338130950928
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00048708915710449
(15) DESCRIBE `ports` 0.0018579959869385
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00041508674621582
(17) DESCRIBE `ports` 0.0018911361694336
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00040602684020996
(19) DESCRIBE `sailingdates` 0.0017199516296387
(20) DESCRIBE `ports` 0.0020980834960938
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00050997734069824
(22) DESCRIBE `ports` 0.0022180080413818
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00049018859863281
(24) DESCRIBE `ports` 0.0017969608306885
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00049209594726562
(26) DESCRIBE `ports` 0.0018019676208496
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00037407875061035
(28) DESCRIBE `ports` 0.0017178058624268
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00045013427734375
(30) DESCRIBE `ports` 0.0018370151519775
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00047206878662109
(32) DESCRIBE `ports` 0.0018200874328613
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00049185752868652
(34) DESCRIBE `ports` 0.0019559860229492
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00056791305541992
(36) DESCRIBE `ports` 0.0019361972808838
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00045204162597656
(38) DESCRIBE `ports` 0.0017960071563721
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00040912628173828
(40) DESCRIBE `ports` 0.0018007755279541
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00045204162597656
(42) DESCRIBE `ports` 0.0018701553344727
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.0003969669342041
(44) DESCRIBE `ports` 0.0019161701202393
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00045108795166016
(46) DESCRIBE `ports` 0.0016281604766846
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00031614303588867
(48) DESCRIBE `ports` 0.0013349056243896
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00029802322387695
(50) DESCRIBE `ports` 0.0014519691467285
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00037193298339844
(52) DESCRIBE `ports` 0.0018131732940674
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00074291229248047
(54) DESCRIBE `ports` 0.0018570423126221
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00040197372436523
(56) DESCRIBE `ports` 0.0016798973083496
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040793418884277
(58) DESCRIBE `ports` 0.0018160343170166
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00038409233093262
(60) DESCRIBE `avid_specials` 0.0017681121826172
(61) 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.0016539096832275
(62) DESCRIBE `cruiselines` 0.0025200843811035
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00055813789367676
(64) DESCRIBE `orchid_image` 0.0016529560089111
(65) DESCRIBE `cruiselines` 0.0019881725311279
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00036382675170898
(67) DESCRIBE `cruises` 0.0039420127868652
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68466') 0.0004889965057373
(69) DESCRIBE `ships` 0.0038659572601318
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.00060200691223145
(71) DESCRIBE `ships` 0.0036849975585938
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.00048208236694336
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033998489379883
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032210350036621
(75) DESCRIBE `itineraries` 0.0018510818481445
(76) DESCRIBE `ports` 0.0020639896392822
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00042605400085449
(78) DESCRIBE `ports` 0.0019500255584717
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040388107299805
(80) DESCRIBE `ports` 0.0023620128631592
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00047516822814941
(82) DESCRIBE `sailingdates` 0.0014801025390625
(83) DESCRIBE `ports` 0.0016129016876221
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00039100646972656
(85) DESCRIBE `ports` 0.0018320083618164
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00043201446533203
(87) DESCRIBE `ports` 0.0019102096557617
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00049090385437012
(89) DESCRIBE `ports` 0.0020639896392822
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0004570484161377
(91) DESCRIBE `ports` 0.0020461082458496
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00049591064453125
(93) DESCRIBE `ports` 0.0020818710327148
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0004429817199707
(95) DESCRIBE `ports` 0.0020830631256104
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00050210952758789
(97) DESCRIBE `ports` 0.0021350383758545
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00046205520629883
(99) DESCRIBE `ports` 0.0020790100097656
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00050020217895508
(101) DESCRIBE `ports` 0.0020952224731445
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.0004730224609375
(103) DESCRIBE `ports` 0.0020368099212646
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00046396255493164
(105) DESCRIBE `ports` 0.0020720958709717
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00047898292541504
(107) DESCRIBE `ports` 0.0020899772644043
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00050902366638184
(109) DESCRIBE `ports` 0.0020530223846436
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00044393539428711
(111) DESCRIBE `ports` 0.0019841194152832
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.0004429817199707
(113) DESCRIBE `ports` 0.0020461082458496
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00044798851013184
(115) DESCRIBE `ports` 0.0020008087158203
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00049400329589844
(117) DESCRIBE `ports` 0.0020608901977539
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00053095817565918
(119) DESCRIBE `ports` 0.0020828247070312
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00052094459533691
(121) DESCRIBE `ports` 0.0021378993988037
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00046706199645996
(123) DESCRIBE `avid_specials` 0.0017530918121338
(124) 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.0012779235839844
(125) DESCRIBE `cruiselines` 0.0022659301757812
(126) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00044679641723633
(127) DESCRIBE `orchid_image` 0.0018219947814941
(128) DESCRIBE `cruiselines` 0.0025539398193359
(129) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00042414665222168
(130) DESCRIBE `cruises` 0.0037569999694824
(131) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82242') 0.00060606002807617
(132) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82242') 0.00041413307189941
(133) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id != '82242') 0.24754595756531
(134) UPDATE `cruises` SET `orchid_slug` = ? WHERE (id = '82242') 0.023548126220703
(135) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id != '82242') 0.049961805343628
(136) UPDATE `cruises` SET `orchid_slug` = ? WHERE (id = '82242') 0.0012218952178955
(137) DESCRIBE `ships` 0.0031468868255615
(138) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00039911270141602
(139) DESCRIBE `ships` 0.0025269985198975
(140) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00037407875061035
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030088424682617
(143) DESCRIBE `itineraries` 0.0014519691467285
(144) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82242') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00072503089904785
(145) DESCRIBE `ports` 0.00142502784729
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00033688545227051
(147) DESCRIBE `ports` 0.001288890838623
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0002748966217041
(149) DESCRIBE `ports` 0.001291036605835
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00030183792114258
(151) DESCRIBE `sailingdates` 0.001288890838623
(152) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82242') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068306922912598
(153) DESCRIBE `ports` 0.001378059387207
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00032496452331543
(155) DESCRIBE `ports` 0.0014820098876953
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00036096572875977
(157) DESCRIBE `ports` 0.0016200542449951
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00073695182800293
(159) DESCRIBE `ports` 0.0020880699157715
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00044512748718262
(161) DESCRIBE `ports` 0.002018928527832
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00048995018005371
(163) DESCRIBE `ports` 0.0013618469238281
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00031495094299316
(165) DESCRIBE `ports` 0.0013229846954346
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00037908554077148
(167) DESCRIBE `ports` 0.0016918182373047
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0003809928894043
(169) DESCRIBE `ports` 0.0014240741729736
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00037503242492676
(171) DESCRIBE `ports` 0.001309871673584
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029802322387695
(173) DESCRIBE `ports` 0.0013489723205566
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031685829162598
(175) DESCRIBE `ports` 0.0012710094451904
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00030207633972168
(177) DESCRIBE `ports` 0.0013248920440674
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031900405883789
(179) DESCRIBE `ports` 0.0013179779052734
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0003199577331543
(181) DESCRIBE `ports` 0.0012819766998291
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0004119873046875
(183) DESCRIBE `ports` 0.0017609596252441
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00040078163146973
(185) DESCRIBE `ports` 0.0018248558044434
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0003960132598877
(187) DESCRIBE `ports` 0.0013449192047119
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00033378601074219
(189) DESCRIBE `ports` 0.0012719631195068
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031685829162598
(191) DESCRIBE `ports` 0.0013349056243896
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00030899047851562
(193) DESCRIBE `ports` 0.0012891292572021
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00033092498779297
(195) DESCRIBE `ports` 0.0013530254364014
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00029206275939941
(197) DESCRIBE `avid_specials` 0.0014481544494629
(198) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82242 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.0011708736419678
(199) DESCRIBE `cruiselines` 0.0022780895233154
(200) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00042605400085449
(201) DESCRIBE `orchid_image` 0.0014998912811279
(202) DESCRIBE `cruiselines` 0.0021560192108154
(203) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00034189224243164
(204) DESCRIBE `cruises` 0.0045650005340576
(205) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75704') 0.00068092346191406
(206) DESCRIBE `ships` 0.0042111873626709
(207) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.00091004371643066
(208) DESCRIBE `ships` 0.0041530132293701
(209) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.0006098747253418
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041484832763672
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037789344787598
(212) DESCRIBE `itineraries` 0.0019741058349609
(213) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75704') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014698505401611
(214) DESCRIBE `ports` 0.0023031234741211
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00054597854614258
(216) DESCRIBE `ports` 0.0016510486602783
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034999847412109
(218) DESCRIBE `ports` 0.0013790130615234
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00035214424133301
(220) DESCRIBE `sailingdates` 0.0011670589447021
(221) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75704') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067901611328125
(222) DESCRIBE `ports` 0.001488208770752
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00032901763916016
(224) DESCRIBE `ports` 0.0013399124145508
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027298927307129
(226) DESCRIBE `ports` 0.0017240047454834
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00042104721069336
(228) DESCRIBE `ports` 0.001788854598999
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00031805038452148
(230) DESCRIBE `ports` 0.0016040802001953
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2483))) 0.00037717819213867
(232) DESCRIBE `ports` 0.0016179084777832
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2483') 0.00037407875061035
(234) DESCRIBE `ports` 0.0017931461334229
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00043511390686035
(236) DESCRIBE `ports` 0.0018999576568604
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0004119873046875
(238) DESCRIBE `ports` 0.0017809867858887
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00043201446533203
(240) DESCRIBE `ports` 0.0018589496612549
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00041413307189941
(242) DESCRIBE `ports` 0.0015809535980225
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031900405883789
(244) DESCRIBE `ports` 0.0012459754943848
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029182434082031
(246) DESCRIBE `ports` 0.0012810230255127
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031089782714844
(248) DESCRIBE `ports` 0.0012350082397461
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028514862060547
(250) DESCRIBE `ports` 0.0012879371643066
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00028896331787109
(252) DESCRIBE `ports` 0.0012359619140625
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00026893615722656
(254) DESCRIBE `ports` 0.0013020038604736
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031495094299316
(256) DESCRIBE `ports` 0.0013279914855957
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00029706954956055
(258) DESCRIBE `ports` 0.0012919902801514
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031185150146484
(260) DESCRIBE `ports` 0.0013980865478516
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028896331787109
(262) DESCRIBE `ports` 0.0012807846069336
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00033903121948242
(264) DESCRIBE `ports` 0.0014369487762451
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028896331787109
(266) DESCRIBE `ports` 0.0013730525970459
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00033402442932129
(268) DESCRIBE `ports` 0.0014371871948242
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00040411949157715
(270) DESCRIBE `avid_specials` 0.0011470317840576
(271) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75704 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.001068115234375
(272) DESCRIBE `cruiselines` 0.0022749900817871
(273) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00046396255493164
(274) DESCRIBE `orchid_image` 0.0020148754119873
(275) DESCRIBE `cruiselines` 0.0019209384918213
(276) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00031781196594238
(277) DESCRIBE `cruises` 0.0026161670684814
(278) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75710') 0.00031781196594238
(279) DESCRIBE `ships` 0.0034279823303223
(280) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00050902366638184
(281) DESCRIBE `ships` 0.0029239654541016
(282) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00029897689819336
(283) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031304359436035
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036001205444336
(285) DESCRIBE `itineraries` 0.0016398429870605
(286) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75710') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009009838104248
(287) DESCRIBE `ports` 0.001971960067749
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.0004420280456543
(289) DESCRIBE `ports` 0.0014610290527344
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00028300285339355
(291) DESCRIBE `ports` 0.0012679100036621
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00028800964355469
(293) DESCRIBE `sailingdates` 0.0013070106506348
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75710') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045490264892578
(295) DESCRIBE `ports` 0.0013430118560791
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00038695335388184
(297) DESCRIBE `ports` 0.0012931823730469
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00027585029602051
(299) DESCRIBE `ports` 0.001431941986084
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2483))) 0.00029897689819336
(301) DESCRIBE `ports` 0.0015099048614502
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2483') 0.00028491020202637
(303) DESCRIBE `ports` 0.0014369487762451
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3134))) 0.00030899047851562
(305) DESCRIBE `ports` 0.0013949871063232
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3134') 0.00028204917907715
(307) DESCRIBE `ports` 0.0013689994812012
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0003058910369873
(309) DESCRIBE `ports` 0.0014071464538574
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00031208992004395
(311) DESCRIBE `ports` 0.0014150142669678
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00029778480529785
(313) DESCRIBE `ports` 0.0012578964233398
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00027990341186523
(315) DESCRIBE `ports` 0.0012969970703125
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00030994415283203
(317) DESCRIBE `ports` 0.0013749599456787
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00033712387084961
(319) DESCRIBE `ports` 0.0015900135040283
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1483))) 0.00039291381835938
(321) DESCRIBE `ports` 0.0013711452484131
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1483') 0.00034904479980469
(323) DESCRIBE `ports` 0.0016088485717773
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1483))) 0.00046992301940918
(325) DESCRIBE `ports` 0.0014948844909668
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1483') 0.00028896331787109
(327) DESCRIBE `ports` 0.0013899803161621
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031304359436035
(329) DESCRIBE `ports` 0.0012619495391846
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00032806396484375
(331) DESCRIBE `ports` 0.00146484375
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029182434082031
(333) DESCRIBE `ports` 0.0012640953063965
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028300285339355
(335) DESCRIBE `ports` 0.0012619495391846
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029110908508301
(337) DESCRIBE `ports` 0.001323938369751
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027799606323242
(339) DESCRIBE `ports` 0.0012779235839844
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00033307075500488
(341) DESCRIBE `ports` 0.001323938369751
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00026917457580566
(343) DESCRIBE `ports` 0.0012660026550293
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00041317939758301
(345) DESCRIBE `ports` 0.0013711452484131
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028181076049805
(347) DESCRIBE `ports` 0.0015058517456055
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030016899108887
(349) DESCRIBE `ports` 0.0018620491027832
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0003659725189209
(351) DESCRIBE `avid_specials` 0.0016460418701172
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75710 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.0020570755004883
(353) DESCRIBE `cruiselines` 0.0029549598693848
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00048518180847168
(355) DESCRIBE `orchid_image` 0.001701831817627
(356) DESCRIBE `cruiselines` 0.0019409656524658
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00036883354187012
(358) DESCRIBE `cruises` 0.0025379657745361
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75711') 0.0003659725189209
(360) DESCRIBE `ships` 0.0025448799133301
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.0003659725189209
(362) DESCRIBE `ships` 0.0033180713653564
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00034880638122559
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002741813659668
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026488304138184
(366) DESCRIBE `itineraries` 0.0013411045074463
(367) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75711') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051689147949219
(368) DESCRIBE `ports` 0.0018250942230225
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00036501884460449
(370) DESCRIBE `ports` 0.0013830661773682
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00032997131347656
(372) DESCRIBE `ports` 0.0014529228210449
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028705596923828
(374) DESCRIBE `sailingdates` 0.001201868057251
(375) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75711') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063490867614746
(376) DESCRIBE `ports` 0.0015580654144287
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031185150146484
(378) DESCRIBE `ports` 0.0012991428375244
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00030517578125
(380) DESCRIBE `ports` 0.0013899803161621
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031304359436035
(382) DESCRIBE `ports` 0.0013959407806396
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032305717468262
(384) DESCRIBE `ports` 0.00136399269104
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030708312988281
(386) DESCRIBE `ports` 0.0014541149139404
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00031900405883789
(388) DESCRIBE `ports` 0.0013751983642578
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00034594535827637
(390) DESCRIBE `ports` 0.0013608932495117
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00036811828613281
(392) DESCRIBE `ports` 0.0018091201782227
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00047016143798828
(394) DESCRIBE `ports` 0.0016210079193115
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00035595893859863
(396) DESCRIBE `ports` 0.0013508796691895
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00034594535827637
(398) DESCRIBE `ports` 0.0013630390167236
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00029397010803223
(400) DESCRIBE `ports` 0.0015048980712891
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00039005279541016
(402) DESCRIBE `ports` 0.00136399269104
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00029206275939941
(404) DESCRIBE `ports` 0.0012969970703125
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030684471130371
(406) DESCRIBE `ports` 0.0013201236724854
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00035691261291504
(408) DESCRIBE `ports` 0.0017368793487549
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00034499168395996
(410) DESCRIBE `ports` 0.0014088153839111
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00029492378234863
(412) DESCRIBE `ports` 0.0013930797576904
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031208992004395
(414) DESCRIBE `ports` 0.0014040470123291
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00044488906860352
(416) DESCRIBE `ports` 0.0014100074768066
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031304359436035
(418) DESCRIBE `ports` 0.001568078994751
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00030112266540527
(420) DESCRIBE `avid_specials` 0.0013968944549561
(421) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75711 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.0010471343994141
(422) DESCRIBE `cruiselines` 0.0020380020141602
(423) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00033187866210938
(424) DESCRIBE `orchid_image` 0.0015130043029785
(425) DESCRIBE `cruiselines` 0.0018310546875
(426) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00031399726867676
(427) DESCRIBE `cruises` 0.0025591850280762
(428) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75716') 0.00032305717468262
(429) DESCRIBE `ships` 0.0026209354400635
(430) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00037193298339844
(431) DESCRIBE `ships` 0.003079891204834
(432) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00035786628723145
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027084350585938
(434) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(435) DESCRIBE `itineraries` 0.0013959407806396
(436) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75716') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062203407287598
(437) DESCRIBE `ports` 0.0014798641204834
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00036001205444336
(439) DESCRIBE `ports` 0.0013360977172852
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028491020202637
(441) DESCRIBE `ports` 0.0012979507446289
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00031685829162598
(443) DESCRIBE `sailingdates` 0.0011379718780518
(444) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75716') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00078988075256348
(445) DESCRIBE `ports` 0.0016529560089111
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00042295455932617
(447) DESCRIBE `ports` 0.0013570785522461
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028800964355469
(449) DESCRIBE `ports` 0.0014309883117676
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031900405883789
(451) DESCRIBE `ports` 0.0014581680297852
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032687187194824
(453) DESCRIBE `ports` 0.0013799667358398
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030398368835449
(455) DESCRIBE `ports` 0.0015089511871338
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00033211708068848
(457) DESCRIBE `ports` 0.0013549327850342
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031900405883789
(459) DESCRIBE `ports` 0.0013389587402344
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028491020202637
(461) DESCRIBE `ports` 0.0012810230255127
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030183792114258
(463) DESCRIBE `ports` 0.0013949871063232
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028800964355469
(465) DESCRIBE `ports` 0.0013289451599121
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030112266540527
(467) DESCRIBE `ports` 0.0013580322265625
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0003049373626709
(469) DESCRIBE `ports` 0.0013468265533447
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031685829162598
(471) DESCRIBE `ports` 0.0016310214996338
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00037908554077148
(473) DESCRIBE `ports` 0.0012989044189453
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00033307075500488
(475) DESCRIBE `ports` 0.0014970302581787
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00036501884460449
(477) DESCRIBE `ports` 0.0015168190002441
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00041913986206055
(479) DESCRIBE `ports` 0.0013668537139893
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032591819763184
(481) DESCRIBE `ports` 0.0013840198516846
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031876564025879
(483) DESCRIBE `ports` 0.0016801357269287
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00041389465332031
(485) DESCRIBE `ports` 0.001439094543457
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031900405883789
(487) DESCRIBE `ports` 0.0015711784362793
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00034499168395996
(489) DESCRIBE `avid_specials` 0.0015039443969727
(490) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75716 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.00164794921875
(491) DESCRIBE `cruiselines` 0.0024359226226807
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00037884712219238
(493) DESCRIBE `orchid_image` 0.0016160011291504
(494) DESCRIBE `cruiselines` 0.0018880367279053
(495) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00035500526428223
(496) DESCRIBE `cruises` 0.003061056137085
(497) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75705') 0.00052309036254883
(498) DESCRIBE `ships` 0.0042951107025146
(499) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.0006868839263916
(500) DESCRIBE `ships` 0.0030350685119629
(501) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.00040507316589355
(502) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043201446533203
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034880638122559
(504) DESCRIBE `itineraries` 0.001655101776123
(505) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75705') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052309036254883
(506) DESCRIBE `ports` 0.0015530586242676
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040102005004883
(508) DESCRIBE `ports` 0.0014729499816895
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030899047851562
(510) DESCRIBE `ports` 0.0014810562133789
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00033283233642578
(512) DESCRIBE `sailingdates` 0.001317024230957
(513) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75705') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053286552429199
(514) DESCRIBE `ports` 0.0017330646514893
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040292739868164
(516) DESCRIBE `ports` 0.0016441345214844
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00031805038452148
(518) DESCRIBE `ports` 0.0012831687927246
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030398368835449
(520) DESCRIBE `ports` 0.0013508796691895
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027894973754883
(522) DESCRIBE `ports` 0.0013480186462402
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00052714347839355
(524) DESCRIBE `ports` 0.0013799667358398
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00035905838012695
(526) DESCRIBE `ports` 0.001600980758667
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00040507316589355
(528) DESCRIBE `ports` 0.0013749599456787
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00034904479980469
(530) DESCRIBE `ports` 0.0013480186462402
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00041007995605469
(532) DESCRIBE `ports` 0.0014350414276123
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00030183792114258
(534) DESCRIBE `ports` 0.0017590522766113
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00047087669372559
(536) DESCRIBE `ports` 0.0020170211791992
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00044584274291992
(538) DESCRIBE `ports` 0.0020008087158203
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0005638599395752
(540) DESCRIBE `ports` 0.0017869472503662
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00039911270141602
(542) DESCRIBE `ports` 0.0014760494232178
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00037503242492676
(544) DESCRIBE `ports` 0.0016410350799561
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00034403800964355
(546) DESCRIBE `ports` 0.0015738010406494
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0004432201385498
(548) DESCRIBE `ports` 0.0018868446350098
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00042200088500977
(550) DESCRIBE `ports` 0.0017988681793213
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00046706199645996
(552) DESCRIBE `ports` 0.0015509128570557
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00031805038452148
(554) DESCRIBE `ports` 0.0014829635620117
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00036811828613281
(556) DESCRIBE `ports` 0.0014381408691406
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00031018257141113
(558) DESCRIBE `avid_specials` 0.0013828277587891
(559) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75705 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.00118088722229
(560) DESCRIBE `cruiselines` 0.0020549297332764
(561) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00036191940307617
(562) DESCRIBE `orchid_image` 0.0020198822021484
(563) DESCRIBE `cruiselines` 0.0022649765014648
(564) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00033998489379883
(565) DESCRIBE `cruises` 0.0027670860290527
(566) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75714') 0.00035905838012695
(567) DESCRIBE `ships` 0.0026979446411133
(568) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.0004429817199707
(569) DESCRIBE `ships` 0.0040841102600098
(570) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00049614906311035
(571) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037002563476562
(572) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035691261291504
(573) DESCRIBE `itineraries` 0.0020589828491211
(574) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75714') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00086116790771484
(575) DESCRIBE `ports` 0.0015830993652344
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00037193298339844
(577) DESCRIBE `ports` 0.0014009475708008
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00033307075500488
(579) DESCRIBE `ports` 0.0013041496276855
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028014183044434
(581) DESCRIBE `sailingdates` 0.0012340545654297
(582) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75714') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045490264892578
(583) DESCRIBE `ports` 0.0014069080352783
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00037813186645508
(585) DESCRIBE `ports` 0.0013580322265625
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027108192443848
(587) DESCRIBE `ports` 0.0012550354003906
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00031208992004395
(589) DESCRIBE `ports` 0.0013148784637451
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00031900405883789
(591) DESCRIBE `ports` 0.0012810230255127
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0003359317779541
(593) DESCRIBE `ports` 0.0013439655303955
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00027799606323242
(595) DESCRIBE `ports` 0.0013859272003174
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031781196594238
(597) DESCRIBE `ports` 0.0015130043029785
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00047397613525391
(599) DESCRIBE `ports` 0.0018329620361328
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00034809112548828
(601) DESCRIBE `ports` 0.0017061233520508
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00030994415283203
(603) DESCRIBE `ports` 0.0013349056243896
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00030803680419922
(605) DESCRIBE `ports` 0.0013778209686279
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002901554107666
(607) DESCRIBE `ports` 0.001392126083374
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0003199577331543
(609) DESCRIBE `ports` 0.0015738010406494
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002899169921875
(611) DESCRIBE `ports` 0.0015110969543457
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0003211498260498
(613) DESCRIBE `ports` 0.0014510154724121
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002899169921875
(615) DESCRIBE `ports` 0.0014159679412842
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031709671020508
(617) DESCRIBE `ports` 0.0013508796691895
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028109550476074
(619) DESCRIBE `ports` 0.0013442039489746
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0003199577331543
(621) DESCRIBE `ports` 0.0012979507446289
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00033187866210938
(623) DESCRIBE `ports` 0.0012788772583008
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027894973754883
(625) DESCRIBE `ports` 0.001474142074585
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00029516220092773
(627) DESCRIBE `avid_specials` 0.00130295753479
(628) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75714 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.0012929439544678
(629) DESCRIBE `cruiselines` 0.0019619464874268
(630) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00038695335388184
(631) DESCRIBE `orchid_image` 0.0016319751739502
(632) DESCRIBE `cruiselines` 0.0020170211791992
(633) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.0003209114074707
(634) DESCRIBE `cruises` 0.0026040077209473
(635) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75717') 0.00063014030456543
(636) DESCRIBE `ships` 0.003680944442749
(637) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00057792663574219
(638) DESCRIBE `ships` 0.0035619735717773
(639) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00043797492980957
(640) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033307075500488
(641) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031781196594238
(642) DESCRIBE `itineraries` 0.0018808841705322
(643) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75717') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062894821166992
(644) DESCRIBE `ports` 0.0014870166778564
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00035190582275391
(646) DESCRIBE `ports` 0.0012590885162354
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031089782714844
(648) DESCRIBE `ports` 0.0014169216156006
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0003349781036377
(650) DESCRIBE `sailingdates` 0.0014169216156006
(651) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75717') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053501129150391
(652) DESCRIBE `ports` 0.0013408660888672
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00032711029052734
(654) DESCRIBE `ports` 0.001262903213501
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00033783912658691
(656) DESCRIBE `ports` 0.0014638900756836
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00033998489379883
(658) DESCRIBE `ports` 0.0016469955444336
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00040507316589355
(660) DESCRIBE `ports` 0.0013401508331299
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00033688545227051
(662) DESCRIBE `ports` 0.0014951229095459
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029301643371582
(664) DESCRIBE `ports` 0.0013408660888672
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00036501884460449
(666) DESCRIBE `ports` 0.0012788772583008
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00028014183044434
(668) DESCRIBE `ports` 0.0013201236724854
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00039386749267578
(670) DESCRIBE `ports` 0.0012969970703125
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0002899169921875
(672) DESCRIBE `ports` 0.001349925994873
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031208992004395
(674) DESCRIBE `ports` 0.0013070106506348
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00026893615722656
(676) DESCRIBE `ports` 0.0013840198516846
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00035595893859863
(678) DESCRIBE `ports` 0.0013430118560791
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027894973754883
(680) DESCRIBE `ports` 0.0012528896331787
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029897689819336
(682) DESCRIBE `ports` 0.0012509822845459
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00026702880859375
(684) DESCRIBE `ports` 0.0013039112091064
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00028395652770996
(686) DESCRIBE `ports` 0.0012521743774414
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00023984909057617
(688) DESCRIBE `ports` 0.0015249252319336
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00028705596923828
(690) DESCRIBE `ports` 0.00136399269104
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00029993057250977
(692) DESCRIBE `ports` 0.0013840198516846
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00028586387634277
(694) DESCRIBE `ports` 0.0012550354003906
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00035285949707031
(696) DESCRIBE `ports` 0.0014491081237793
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028610229492188
(698) DESCRIBE `ports` 0.0014491081237793
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00030899047851562
(700) DESCRIBE `avid_specials` 0.0013918876647949
(701) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75717 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.0016841888427734
(702) DESCRIBE `cruiselines` 0.0022809505462646
(703) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00036096572875977
(704) DESCRIBE `orchid_image` 0.0015771389007568
(705) DESCRIBE `cruiselines` 0.0020349025726318
(706) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00034189224243164
(707) DESCRIBE `ships` 0.0034489631652832
(708) SELECT `ships`.* FROM `ships` WHERE (id IN ('796', '795', '1073', '1262')) ORDER BY FIND_IN_SET(id, '796,795,1073,1262') 0.00063896179199219
(709) DESCRIBE `cruisetypes` 0.0011880397796631
(710) 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.034892082214355
(711) DESCRIBE `cruiselines` 0.0028808116912842
(712) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.0004420280456543
(713) DESCRIBE `destinations` 0.001823902130127
(714) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00036287307739258
(715) DESCRIBE `destinations` 0.0020501613616943
(716) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00038886070251465
(717) DESCRIBE `cruiselines` 0.00199294090271
(718) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00032591819763184