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

Total elapsed time: 1.6519844532013

# Query Time
(1) connect 0.0080420970916748
(2) DESCRIBE `cruises` 0.0032660961151123
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75092, 71061, 56368, 75087, 71423, 63940, 63941, 75085, 43678, 67915)) ORDER BY FIND_IN_SET(id, '75092,71061,56368,75087,71423,63940,63941,75085,43678,67915') 0.0087559223175049
(4) DESCRIBE `specials` 0.0060601234436035
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1535066') AND (specials.orchid_available = 1) LIMIT 1 0.00080108642578125
(6) DESCRIBE `specials` 0.0062639713287354
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1535066') 0.00071382522583008
(8) DESCRIBE `ships` 0.0039689540863037
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.00075197219848633
(10) DESCRIBE `ships` 0.0039420127868652
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.00054597854614258
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032782554626465
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037598609924316
(14) DESCRIBE `itineraries` 0.0018270015716553
(15) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75092') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010209083557129
(16) DESCRIBE `ports` 0.0021719932556152
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.012754917144775
(18) DESCRIBE `ports` 0.0038750171661377
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00376296043396
(20) DESCRIBE `ports` 0.0045220851898193
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00053000450134277
(22) DESCRIBE `specialsailingdates` 0.0036721229553223
(23) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1535066') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0014388561248779
(24) DESCRIBE `sailingdates` 0.0026590824127197
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 474285))) 0.00042414665222168
(26) DESCRIBE `ports` 0.006248950958252
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.0014908313751221
(28) DESCRIBE `ports` 0.0078220367431641
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00050997734069824
(30) DESCRIBE `ports` 0.0021440982818604
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) 0.002918004989624
(32) DESCRIBE `ports` 0.0055999755859375
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') 0.0004570484161377
(34) DESCRIBE `ports` 0.0019299983978271
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00049185752868652
(36) DESCRIBE `ports` 0.0019071102142334
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00045204162597656
(38) DESCRIBE `ports` 0.0020289421081543
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00050497055053711
(40) DESCRIBE `ports` 0.0077781677246094
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00052404403686523
(42) DESCRIBE `ports` 0.0025978088378906
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00056791305541992
(44) DESCRIBE `ports` 0.0023589134216309
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00055694580078125
(46) DESCRIBE `ports` 0.0021038055419922
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5914))) 0.0005650520324707
(48) DESCRIBE `ports` 0.0020999908447266
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5914') 0.00057196617126465
(50) DESCRIBE `ports` 0.0070250034332275
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00057291984558105
(52) DESCRIBE `ports` 0.0069279670715332
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00048494338989258
(54) DESCRIBE `ports` 0.0019538402557373
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.0004580020904541
(56) DESCRIBE `ports` 0.0020301342010498
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00046610832214355
(58) DESCRIBE `ports` 0.0026669502258301
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00050187110900879
(60) DESCRIBE `ports` 0.0019969940185547
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.0003359317779541
(62) DESCRIBE `cruises` 0.0032880306243896
(63) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75092))) 0.00047397613525391
(64) DESCRIBE `avid_specials` 0.0015769004821777
(65) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1535066 and class = 'Special') OR (item_id = 75092 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016789436340332
(66) DESCRIBE `cruiselines` 0.0028340816497803
(67) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00054812431335449
(68) DESCRIBE `orchid_image` 0.0022621154785156
(69) DESCRIBE `cruiselines` 0.0028030872344971
(70) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00046014785766602
(71) DESCRIBE `specials` 0.013910055160522
(72) SELECT `specials`.* FROM `specials` WHERE (id = '1529945') AND (specials.orchid_available = 1) LIMIT 1 0.00092411041259766
(73) DESCRIBE `specials` 0.0066430568695068
(74) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1529945') 0.008591890335083
(75) DESCRIBE `ships` 0.004396915435791
(76) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.0012130737304688
(77) DESCRIBE `ships` 0.0040628910064697
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.0085020065307617
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034284591674805
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031399726867676
(81) DESCRIBE `itineraries` 0.0021231174468994
(82) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71061') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00099802017211914
(83) DESCRIBE `ports` 0.0021250247955322
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00051498413085938
(85) DESCRIBE `ports` 0.0016810894012451
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0081658363342285
(87) DESCRIBE `ports` 0.0019750595092773
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0004420280456543
(89) DESCRIBE `specialsailingdates` 0.0015511512756348
(90) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1529945') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0010030269622803
(91) DESCRIBE `sailingdates` 0.00211501121521
(92) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 445908))) 0.0074460506439209
(93) DESCRIBE `ports` 0.0022430419921875
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00047683715820312
(95) DESCRIBE `ports` 0.0019369125366211
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00039291381835938
(97) DESCRIBE `ports` 0.0015439987182617
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00042295455932617
(99) DESCRIBE `ports` 0.01004695892334
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00046610832214355
(101) DESCRIBE `ports` 0.0019240379333496
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1778))) 0.0004429817199707
(103) DESCRIBE `ports` 0.0018391609191895
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1778') 0.00040102005004883
(105) DESCRIBE `ports` 0.0018930435180664
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1328))) 0.0069649219512939
(107) DESCRIBE `ports` 0.0019798278808594
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1328') 0.00043916702270508
(109) DESCRIBE `ports` 0.0018651485443115
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5361))) 0.00060701370239258
(111) DESCRIBE `ports` 0.0019810199737549
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5361') 0.0093739032745361
(113) DESCRIBE `ports` 0.0020020008087158
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5360))) 0.0004730224609375
(115) DESCRIBE `ports` 0.0020020008087158
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5360') 0.00055885314941406
(117) DESCRIBE `ports` 0.0019409656524658
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 870))) 0.00058698654174805
(119) DESCRIBE `ports` 0.0020668506622314
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '870') 0.00048017501831055
(121) DESCRIBE `ports` 0.0017478466033936
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3631))) 0.00038409233093262
(123) DESCRIBE `ports` 0.0017437934875488
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3631') 0.00039911270141602
(125) DESCRIBE `ports` 0.0020129680633545
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.0043849945068359
(127) DESCRIBE `ports` 0.0021979808807373
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.0004119873046875
(129) DESCRIBE `ports` 0.0019268989562988
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00044608116149902
(131) DESCRIBE `ports` 0.0018360614776611
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00043797492980957
(133) DESCRIBE `ports` 0.0019600391387939
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00045585632324219
(135) DESCRIBE `ports` 0.0019381046295166
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0005040168762207
(137) DESCRIBE `cruises` 0.0037870407104492
(138) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71061))) 0.00071597099304199
(139) DESCRIBE `avid_specials` 0.001945972442627
(140) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1529945 and class = 'Special') OR (item_id = 71061 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018830299377441
(141) DESCRIBE `cruiselines` 0.0028519630432129
(142) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00054597854614258
(143) DESCRIBE `orchid_image` 0.0059070587158203
(144) DESCRIBE `cruiselines` 0.0030081272125244
(145) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00047683715820312
(146) DESCRIBE `specials` 0.017117023468018
(147) SELECT `specials`.* FROM `specials` WHERE (id = '1529878') AND (specials.orchid_available = 1) LIMIT 1 0.00091099739074707
(148) DESCRIBE `specials` 0.0066177845001221
(149) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1529878') 0.0078091621398926
(150) DESCRIBE `ships` 0.0057680606842041
(151) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.011365175247192
(152) DESCRIBE `ships` 0.006479024887085
(153) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00054001808166504
(154) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040102005004883
(155) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052380561828613
(156) DESCRIBE `itineraries` 0.0022368431091309
(157) DESCRIBE `ports` 0.002781867980957
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.0059099197387695
(159) DESCRIBE `ports` 0.0020420551300049
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00049614906311035
(161) DESCRIBE `ports` 0.0019218921661377
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.0059549808502197
(163) DESCRIBE `specialsailingdates` 0.0018608570098877
(164) DESCRIBE `sailingdates` 0.002004861831665
(165) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 445879))) 0.00048089027404785
(166) DESCRIBE `ports` 0.0080509185791016
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00058317184448242
(168) DESCRIBE `ports` 0.0020220279693604
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00048303604125977
(170) DESCRIBE `ports` 0.0024280548095703
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.0087161064147949
(172) DESCRIBE `ports` 0.002079963684082
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00056982040405273
(174) DESCRIBE `ports` 0.0020411014556885
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 802))) 0.00053310394287109
(176) DESCRIBE `ports` 0.0019428730010986
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '802') 0.00043582916259766
(178) DESCRIBE `ports` 0.0042409896850586
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 802))) 0.0032389163970947
(180) DESCRIBE `ports` 0.0021231174468994
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '802') 0.00045490264892578
(182) DESCRIBE `ports` 0.0024199485778809
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 708))) 0.00049591064453125
(184) DESCRIBE `ports` 0.0019159317016602
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '708') 0.00040984153747559
(186) DESCRIBE `ports` 0.0017590522766113
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00045394897460938
(188) DESCRIBE `ports` 0.0017969608306885
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00044703483581543
(190) DESCRIBE `ports` 0.0017921924591064
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00051307678222656
(192) DESCRIBE `ports` 0.0017678737640381
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00035190582275391
(194) DESCRIBE `cruises` 0.0032730102539062
(195) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 56368))) 0.00065207481384277
(196) DESCRIBE `avid_specials` 0.0017359256744385
(197) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1529878 and class = 'Special') OR (item_id = 56368 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 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.0017580986022949
(198) DESCRIBE `cruiselines` 0.0026049613952637
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00050997734069824
(200) DESCRIBE `orchid_image` 0.0021262168884277
(201) DESCRIBE `cruiselines` 0.0027389526367188
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00044584274291992
(203) DESCRIBE `specials` 0.0063281059265137
(204) SELECT `specials`.* FROM `specials` WHERE (id = '1535086') AND (specials.orchid_available = 1) LIMIT 1 0.0010318756103516
(205) DESCRIBE `specials` 0.0055909156799316
(206) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1535086') 0.0023479461669922
(207) DESCRIBE `ships` 0.0050230026245117
(208) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.00069904327392578
(209) DESCRIBE `ships` 0.0044519901275635
(210) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.00058507919311523
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034308433532715
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032901763916016
(213) DESCRIBE `itineraries` 0.0021390914916992
(214) DESCRIBE `ports` 0.0094671249389648
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00048303604125977
(216) DESCRIBE `ports` 0.0018718242645264
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00044894218444824
(218) DESCRIBE `ports` 0.0022029876708984
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.0057461261749268
(220) DESCRIBE `specialsailingdates` 0.0017340183258057
(221) DESCRIBE `sailingdates` 0.001690149307251
(222) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 474261))) 0.00053906440734863
(223) DESCRIBE `ports` 0.005997896194458
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00052785873413086
(225) DESCRIBE `ports` 0.0080080032348633
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00046992301940918
(227) DESCRIBE `ports` 0.0018210411071777
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.0023758411407471
(229) DESCRIBE `ports` 0.0063929557800293
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00041484832763672
(231) DESCRIBE `ports` 0.0017580986022949
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4862))) 0.00041484832763672
(233) DESCRIBE `ports` 0.0016829967498779
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4862') 0.0024631023406982
(235) DESCRIBE `ports` 0.0017220973968506
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00038814544677734
(237) DESCRIBE `ports` 0.0017299652099609
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00034284591674805
(239) DESCRIBE `ports` 0.0015709400177002
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00044918060302734
(241) DESCRIBE `ports` 0.0015771389007568
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00042104721069336
(243) DESCRIBE `ports` 0.0016441345214844
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00041508674621582
(245) DESCRIBE `ports` 0.0016930103302002
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00035881996154785
(247) DESCRIBE `ports` 0.0017580986022949
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) 0.00036907196044922
(249) DESCRIBE `ports` 0.0015420913696289
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') 0.00035500526428223
(251) DESCRIBE `ports` 0.0016169548034668
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00045990943908691
(253) DESCRIBE `ports` 0.0018529891967773
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00041294097900391
(255) DESCRIBE `ports` 0.002349853515625
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2355))) 0.00049591064453125
(257) DESCRIBE `ports` 0.0027720928192139
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2355') 0.00041604042053223
(259) DESCRIBE `ports` 0.0020730495452881
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0009620189666748
(261) DESCRIBE `ports` 0.0018670558929443
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.0075130462646484
(263) DESCRIBE `cruises` 0.0038058757781982
(264) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75087))) 0.0007779598236084
(265) DESCRIBE `avid_specials` 0.0019190311431885
(266) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1535086 and class = 'Special') OR (item_id = 75087 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021340847015381
(267) DESCRIBE `cruiselines` 0.0034480094909668
(268) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00058507919311523
(269) DESCRIBE `orchid_image` 0.0017890930175781
(270) DESCRIBE `cruiselines` 0.0023510456085205
(271) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00045394897460938
(272) DESCRIBE `specials` 0.0056660175323486
(273) DESCRIBE `specials` 0.0063910484313965
(274) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1533273') 0.00053501129150391
(275) DESCRIBE `ships` 0.012773990631104
(276) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.0005950927734375
(277) DESCRIBE `ships` 0.0038518905639648
(278) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.0004279613494873
(279) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026607513427734
(280) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033283233642578
(281) DESCRIBE `itineraries` 0.0018830299377441
(282) DESCRIBE `ports` 0.0020730495452881
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048685073852539
(284) DESCRIBE `ports` 0.0019659996032715
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00045394897460938
(286) DESCRIBE `ports` 0.0018911361694336
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0004429817199707
(288) DESCRIBE `specialsailingdates` 0.0015909671783447
(289) DESCRIBE `sailingdates` 0.0016670227050781
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453298))) 0.00073909759521484
(291) DESCRIBE `ports` 0.0028219223022461
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00050997734069824
(293) DESCRIBE `ports` 0.0019359588623047
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037479400634766
(295) DESCRIBE `ports` 0.0018370151519775
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.001370906829834
(297) DESCRIBE `ports` 0.013614177703857
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00058102607727051
(299) DESCRIBE `ports` 0.0021038055419922
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00045418739318848
(301) DESCRIBE `ports` 0.0018248558044434
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00049281120300293
(303) DESCRIBE `ports` 0.001986026763916
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2066))) 0.00052094459533691
(305) DESCRIBE `ports` 0.0019400119781494
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2066') 0.00046491622924805
(307) DESCRIBE `ports` 0.001816987991333
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00045108795166016
(309) DESCRIBE `ports` 0.001924991607666
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00038909912109375
(311) DESCRIBE `ports` 0.0019259452819824
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00043702125549316
(313) DESCRIBE `ports` 0.0018711090087891
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00039887428283691
(315) DESCRIBE `ports` 0.0019199848175049
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00045394897460938
(317) DESCRIBE `ports` 0.0023291110992432
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.0011110305786133
(319) DESCRIBE `ports` 0.0021660327911377
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00057005882263184
(321) DESCRIBE `ports` 0.002223014831543
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00045895576477051
(323) DESCRIBE `ports` 0.0029070377349854
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.0010509490966797
(325) DESCRIBE `ports` 0.016875982284546
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00066494941711426
(327) DESCRIBE `ports` 0.0024631023406982
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5565))) 0.00065112113952637
(329) DESCRIBE `ports` 0.0020711421966553
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5565') 0.005094051361084
(331) DESCRIBE `ports` 0.0022928714752197
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0073881149291992
(333) DESCRIBE `ports` 0.0041499137878418
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00049614906311035
(335) DESCRIBE `ports` 0.0021059513092041
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050115585327148
(337) DESCRIBE `ports` 0.0085849761962891
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046300888061523
(339) DESCRIBE `cruises` 0.0044000148773193
(340) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71423))) 0.0088591575622559
(341) DESCRIBE `avid_specials` 0.0047972202301025
(342) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1533273 and class = 'Special') OR (item_id = 71423 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0064618587493896
(343) DESCRIBE `cruiselines` 0.0025420188903809
(344) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0071620941162109
(345) DESCRIBE `orchid_image` 0.0020589828491211
(346) DESCRIBE `cruiselines` 0.0024151802062988
(347) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00042009353637695
(348) DESCRIBE `specials` 0.0051910877227783
(349) SELECT `specials`.* FROM `specials` WHERE (id = '1523581') AND (specials.orchid_available = 1) LIMIT 1 0.0066461563110352
(350) DESCRIBE `specials` 0.0052599906921387
(351) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1523581') 0.0055139064788818
(352) DESCRIBE `ships` 0.0029869079589844
(353) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1491))) 0.0092840194702148
(354) DESCRIBE `ships` 0.0027379989624023
(355) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1491') 0.0095300674438477
(356) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032520294189453
(357) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003511905670166
(358) DESCRIBE `itineraries` 0.0020570755004883
(359) DESCRIBE `ports` 0.0070428848266602
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00050902366638184
(361) DESCRIBE `ports` 0.0018661022186279
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0031099319458008
(363) DESCRIBE `ports` 0.0019237995147705
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.007580041885376
(365) DESCRIBE `specialsailingdates` 0.0016448497772217
(366) DESCRIBE `sailingdates` 0.0013408660888672
(367) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 484528))) 0.00040197372436523
(368) DESCRIBE `sailingdates` 0.0028350353240967
(369) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 484530))) 0.00050187110900879
(370) DESCRIBE `ports` 0.0020802021026611
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0050349235534668
(372) DESCRIBE `ports` 0.0016090869903564
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00034308433532715
(374) DESCRIBE `ports` 0.0019371509552002
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1548))) 0.0010080337524414
(376) DESCRIBE `ports` 0.0028181076049805
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1548') 0.002608060836792
(378) DESCRIBE `ports` 0.002507209777832
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1547))) 0.0026969909667969
(380) DESCRIBE `ports` 0.0027041435241699
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1547') 0.0025360584259033
(382) DESCRIBE `ports` 0.0024759769439697
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 947))) 0.0025570392608643
(384) DESCRIBE `ports` 0.0042250156402588
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '947') 0.00084996223449707
(386) DESCRIBE `ports` 0.0025680065155029
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0021209716796875
(388) DESCRIBE `ports` 0.0021860599517822
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0027511119842529
(390) DESCRIBE `ports` 0.0018129348754883
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.0029499530792236
(392) DESCRIBE `ports` 0.0025959014892578
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.0068619251251221
(394) DESCRIBE `ports` 0.0023550987243652
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.002100944519043
(396) DESCRIBE `ports` 0.0023550987243652
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.0039041042327881
(398) DESCRIBE `ports` 0.0024890899658203
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.0035490989685059
(400) DESCRIBE `ports` 0.0023550987243652
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.0076069831848145
(402) DESCRIBE `ports` 0.009005069732666
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5733))) 0.00046706199645996
(404) DESCRIBE `ports` 0.0021240711212158
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5733') 0.00045299530029297
(406) DESCRIBE `ports` 0.0018320083618164
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3213))) 0.00047802925109863
(408) DESCRIBE `ports` 0.001910924911499
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3213') 0.0064690113067627
(410) DESCRIBE `ports` 0.0019991397857666
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00051498413085938
(412) DESCRIBE `ports` 0.0017778873443604
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00041604042053223
(414) DESCRIBE `cruises` 0.0034871101379395
(415) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63940))) 0.011123895645142
(416) DESCRIBE `avid_specials` 0.0015950202941895
(417) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1523581 and class = 'Special') OR (item_id = 63940 and class = 'Cruise') OR (item_id = 1491 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine') OR (item_id = 50 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.0017669200897217
(418) DESCRIBE `cruiselines` 0.0028879642486572
(419) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00042486190795898
(420) DESCRIBE `orchid_image` 0.0019111633300781
(421) DESCRIBE `cruiselines` 0.01400089263916
(422) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00040817260742188
(423) DESCRIBE `specials` 0.0052621364593506
(424) SELECT `specials`.* FROM `specials` WHERE (id = '1523597') AND (specials.orchid_available = 1) LIMIT 1 0.00096893310546875
(425) DESCRIBE `specials` 0.017835855484009
(426) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1523597') 0.00043416023254395
(427) DESCRIBE `ships` 0.0035181045532227
(428) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 741))) 0.00047802925109863
(429) DESCRIBE `ships` 0.0093510150909424
(430) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '741') 0.00047993659973145
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030398368835449
(433) DESCRIBE `itineraries` 0.0096302032470703
(434) DESCRIBE `ports` 0.0018138885498047
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00054001808166504
(436) DESCRIBE `ports` 0.0018620491027832
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00049710273742676
(438) DESCRIBE `ports` 0.0021231174468994
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.0003669261932373
(440) DESCRIBE `specialsailingdates` 0.001446008682251
(441) DESCRIBE `sailingdates` 0.0076267719268799
(442) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 484539))) 0.00052380561828613
(443) DESCRIBE `ports` 0.0019161701202393
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00046992301940918
(445) DESCRIBE `ports` 0.0018370151519775
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00037598609924316
(447) DESCRIBE `ports` 0.0017361640930176
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2966))) 0.0079011917114258
(449) DESCRIBE `ports` 0.0018589496612549
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2966') 0.00044488906860352
(451) DESCRIBE `ports` 0.002161979675293
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00053906440734863
(453) DESCRIBE `ports` 0.0025029182434082
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.0084319114685059
(455) DESCRIBE `ports` 0.0019180774688721
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00049495697021484
(457) DESCRIBE `ports` 0.0019278526306152
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00040483474731445
(459) DESCRIBE `ports` 0.0017931461334229
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00043702125549316
(461) DESCRIBE `ports` 0.0097939968109131
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0004889965057373
(463) DESCRIBE `ports` 0.0022368431091309
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00042510032653809
(465) DESCRIBE `ports` 0.0019500255584717
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00037217140197754
(467) DESCRIBE `ports` 0.0022261142730713
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00044417381286621
(469) DESCRIBE `ports` 0.0017509460449219
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.007688045501709
(471) DESCRIBE `ports` 0.0019700527191162
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00055098533630371
(473) DESCRIBE `ports` 0.0019779205322266
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00037503242492676
(475) DESCRIBE `ports` 0.0016570091247559
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5753))) 0.00040888786315918
(477) DESCRIBE `ports` 0.0018019676208496
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5753') 0.0048999786376953
(479) DESCRIBE `ports` 0.0091278553009033
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00051212310791016
(481) DESCRIBE `ports` 0.0018520355224609
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00038599967956543
(483) DESCRIBE `ports` 0.0016651153564453
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00042891502380371
(485) DESCRIBE `ports` 0.0017411708831787
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00035405158996582
(487) DESCRIBE `cruises` 0.0033721923828125
(488) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63941))) 0.0073380470275879
(489) DESCRIBE `avid_specials` 0.0016970634460449
(490) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1523597 and class = 'Special') OR (item_id = 63941 and class = 'Cruise') OR (item_id = 741 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine') OR (item_id = 50 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.0018548965454102
(491) DESCRIBE `cruiselines` 0.0025601387023926
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.0063850879669189
(493) DESCRIBE `orchid_image` 0.0023901462554932
(494) DESCRIBE `cruiselines` 0.0025680065155029
(495) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.007375955581665
(496) DESCRIBE `specials` 0.005626916885376
(497) SELECT `specials`.* FROM `specials` WHERE (id = '1535106') AND (specials.orchid_available = 1) LIMIT 1 0.00083589553833008
(498) DESCRIBE `specials` 0.012477159500122
(499) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1535106') 0.00053310394287109
(500) DESCRIBE `ships` 0.0097231864929199
(501) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.00057601928710938
(502) DESCRIBE `ships` 0.0036799907684326
(503) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.0093388557434082
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034403800964355
(505) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031685829162598
(506) DESCRIBE `itineraries` 0.0024349689483643
(507) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75085') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00095701217651367
(508) DESCRIBE `ports` 0.002255916595459
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0032150745391846
(510) DESCRIBE `ports` 0.001990795135498
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0006558895111084
(512) DESCRIBE `ports` 0.0016939640045166
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.0013489723205566
(514) DESCRIBE `specialsailingdates` 0.0057871341705322
(515) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1535106') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00084710121154785
(516) DESCRIBE `sailingdates` 0.001640796661377
(517) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 474259))) 0.00037789344787598
(518) DESCRIBE `ports` 0.0069441795349121
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00046396255493164
(520) DESCRIBE `ports` 0.0017931461334229
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00033998489379883
(522) DESCRIBE `ports` 0.0016520023345947
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2355))) 0.00046896934509277
(524) DESCRIBE `ports` 0.0016508102416992
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2355') 0.0055429935455322
(526) DESCRIBE `ports` 0.0018260478973389
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00040221214294434
(528) DESCRIBE `ports` 0.0016970634460449
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.0016589164733887
(530) DESCRIBE `ports` 0.0020229816436768
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5923))) 0.0089099407196045
(532) DESCRIBE `ports` 0.0018458366394043
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5923') 0.00034594535827637
(534) DESCRIBE `ports` 0.0017669200897217
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00035405158996582
(536) DESCRIBE `ports` 0.0021369457244873
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00042891502380371
(538) DESCRIBE `ports` 0.0018439292907715
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.0070710182189941
(540) DESCRIBE `ports` 0.0044238567352295
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00049591064453125
(542) DESCRIBE `ports` 0.0023288726806641
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00051522254943848
(544) DESCRIBE `ports` 0.0093481540679932
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.0004889965057373
(546) DESCRIBE `ports` 0.0015411376953125
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4862))) 0.00038385391235352
(548) DESCRIBE `ports` 0.0015249252319336
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4862') 0.00035214424133301
(550) DESCRIBE `ports` 0.0016829967498779
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00036907196044922
(552) DESCRIBE `ports` 0.010457992553711
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00047516822814941
(554) DESCRIBE `ports` 0.0020198822021484
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00048303604125977
(556) DESCRIBE `ports` 0.0019230842590332
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00036787986755371
(558) DESCRIBE `cruises` 0.003148078918457
(559) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75085))) 0.0092370510101318
(560) DESCRIBE `avid_specials` 0.0018720626831055
(561) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1535106 and class = 'Special') OR (item_id = 75085 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021300315856934
(562) DESCRIBE `cruiselines` 0.0025551319122314
(563) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0006251335144043
(564) DESCRIBE `orchid_image` 0.0022599697113037
(565) DESCRIBE `cruiselines` 0.0093698501586914
(566) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00054311752319336
(567) DESCRIBE `specials` 0.0056149959564209
(568) SELECT `specials`.* FROM `specials` WHERE (id = '1524704') AND (specials.orchid_available = 1) LIMIT 1 0.009537935256958
(569) DESCRIBE `specials` 0.0049729347229004
(570) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1524704') 0.00045895576477051
(571) DESCRIBE `ships` 0.0031349658966064
(572) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) 0.00063085556030273
(573) DESCRIBE `ships` 0.0031571388244629
(574) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '404') 0.00043201446533203
(575) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030899047851562
(576) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028109550476074
(577) DESCRIBE `itineraries` 0.0017218589782715
(578) DESCRIBE `ports` 0.0019388198852539
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00047087669372559
(580) DESCRIBE `ports` 0.0020439624786377
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00046491622924805
(582) DESCRIBE `ports` 0.002007007598877
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00041794776916504
(584) DESCRIBE `specialsailingdates` 0.0016629695892334
(585) DESCRIBE `sailingdates` 0.0020511150360107
(586) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 386454))) 0.00059199333190918
(587) DESCRIBE `ports` 0.0019581317901611
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00046801567077637
(589) DESCRIBE `ports` 0.0018198490142822
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0004420280456543
(591) DESCRIBE `ports` 0.0017518997192383
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.0005650520324707
(593) DESCRIBE `ports` 0.0019810199737549
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00045204162597656
(595) DESCRIBE `ports` 0.0017869472503662
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00060200691223145
(597) DESCRIBE `ports` 0.0021681785583496
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.0005040168762207
(599) DESCRIBE `ports` 0.0014598369598389
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00042915344238281
(601) DESCRIBE `ports` 0.00180983543396
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00037097930908203
(603) DESCRIBE `ports` 0.0017850399017334
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00041103363037109
(605) DESCRIBE `ports` 0.0019848346710205
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00044703483581543
(607) DESCRIBE `ports` 0.0016670227050781
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.0004429817199707
(609) DESCRIBE `ports` 0.0018279552459717
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00042200088500977
(611) DESCRIBE `ports` 0.0016939640045166
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00043201446533203
(613) DESCRIBE `ports` 0.0019690990447998
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.0004570484161377
(615) DESCRIBE `ports` 0.0020451545715332
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00047087669372559
(617) DESCRIBE `ports` 0.0017361640930176
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00038385391235352
(619) DESCRIBE `cruises` 0.0036499500274658
(620) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 43678))) 0.00063490867614746
(621) DESCRIBE `avid_specials` 0.0017809867858887
(622) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1524704 and class = 'Special') OR (item_id = 43678 and class = 'Cruise') OR (item_id = 404 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 29 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.0017848014831543
(623) DESCRIBE `cruiselines` 0.0025041103363037
(624) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00044107437133789
(625) DESCRIBE `orchid_image` 0.0021510124206543
(626) DESCRIBE `cruiselines` 0.0029041767120361
(627) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00049304962158203
(628) DESCRIBE `specials` 0.0059211254119873
(629) DESCRIBE `specials` 0.0056300163269043
(630) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1524717') 0.0004889965057373
(631) DESCRIBE `ships` 0.0038628578186035
(632) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) 0.00064396858215332
(633) DESCRIBE `ships` 0.0038211345672607
(634) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') 0.0005190372467041
(635) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037908554077148
(636) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031709671020508
(637) DESCRIBE `itineraries` 0.0017931461334229
(638) DESCRIBE `ports` 0.0019838809967041
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00043177604675293
(640) DESCRIBE `ports` 0.0019950866699219
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00056600570678711
(642) DESCRIBE `ports` 0.0019540786743164
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00046706199645996
(644) DESCRIBE `specialsailingdates` 0.0013439655303955
(645) DESCRIBE `sailingdates` 0.0016608238220215
(646) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428518))) 0.0004580020904541
(647) DESCRIBE `ports` 0.0017249584197998
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00042605400085449
(649) DESCRIBE `ports` 0.0016629695892334
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00041604042053223
(651) DESCRIBE `ports` 0.0016689300537109
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00042104721069336
(653) DESCRIBE `ports` 0.0017991065979004
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00031590461730957
(655) DESCRIBE `ports` 0.0018701553344727
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.0004889965057373
(657) DESCRIBE `ports` 0.0016310214996338
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00032401084899902
(659) DESCRIBE `ports` 0.0032451152801514
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00058889389038086
(661) DESCRIBE `ports` 0.0020339488983154
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00053095817565918
(663) DESCRIBE `ports` 0.0020120143890381
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00053906440734863
(665) DESCRIBE `ports` 0.00205397605896
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00053310394287109
(667) DESCRIBE `cruises` 0.003715991973877
(668) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67915))) 0.00066614151000977
(669) DESCRIBE `avid_specials` 0.0018610954284668
(670) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1524717 and class = 'Special') OR (item_id = 67915 and class = 'Cruise') OR (item_id = 669 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0018608570098877
(671) DESCRIBE `cruiselines` 0.0029261112213135
(672) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00057506561279297
(673) DESCRIBE `orchid_image` 0.0026800632476807
(674) DESCRIBE `cruiselines` 0.0026028156280518
(675) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00043606758117676
(676) DESCRIBE `cruiselines` 0.002655029296875
(677) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('212', '33', '218', '114', '23', '18', '191', '264', '20', '140', '24', '19', '29', '4', '91', '151')) ORDER BY FIND_IN_SET(id, '212,33,218,114,23,18,191,264,20,140,24,19,29,4,91,151') 0.0014050006866455
(678) DESCRIBE `ships` 0.00357985496521
(679) SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1303', '160', '1282', '163', '1159', '1266', '1767', '1772', '1788', '1032', '338', '451', '547', '1262', '75', '162', '404', '580', '1073', '1205', '1491', '1539', '4', '74', '105', '147', '452', '622', '626', '652', '669', '678', '717', '741', '835', '1108', '1168', '1193', '1415', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1303,160,1282,163,1159,1266,1767,1772,1788,1032,338,451,547,1262,75,162,404,580,1073,1205,1491,1539,4,74,105,147,452,622,626,652,669,678,717,741,835,1108,1168,1193,1415,1540,1569,1711') 0.0045969486236572
(680) DESCRIBE `cruisetypes` 0.0015709400177002
(681) DESCRIBE `destinations` 0.0019581317901611
(682) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '22', '43', '12', '49', '2', '28', '40', '50', '8', '35', '53', '55', '34', '11', '29', '38', '54', '25', '26', '37', '45', '52')) ORDER BY FIND_IN_SET(id, '39,22,43,12,49,2,28,40,50,8,35,53,55,34,11,29,38,54,25,26,37,45,52') 0.0017631053924561