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

Total elapsed time: 0.71476697921753

# Query Time
(1) connect 0.0010221004486084
(2) DESCRIBE `cruises` 0.0034151077270508
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69783, 72006, 72066, 78624, 38185, 48660, 59150, 62664, 69430, 72481)) ORDER BY FIND_IN_SET(id, '69783,72006,72066,78624,38185,48660,59150,62664,69430,72481') 0.0020031929016113
(4) DESCRIBE `cruises` 0.0030331611633301
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69783') 0.00046396255493164
(6) DESCRIBE `ships` 0.0027179718017578
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 98))) 0.00041699409484863
(8) DESCRIBE `ships` 0.0028369426727295
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '98') 0.00036907196044922
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002598762512207
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(12) DESCRIBE `itineraries` 0.0019211769104004
(13) DESCRIBE `ports` 0.0022680759429932
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00069594383239746
(15) DESCRIBE `ports` 0.0018851757049561
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00046014785766602
(17) DESCRIBE `ports` 0.0017020702362061
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00038504600524902
(19) DESCRIBE `sailingdates` 0.0015361309051514
(20) DESCRIBE `ports` 0.001596212387085
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00041699409484863
(22) DESCRIBE `ports` 0.001431941986084
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00029397010803223
(24) DESCRIBE `ports` 0.0013370513916016
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00031399726867676
(26) DESCRIBE `ports` 0.0013489723205566
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00031089782714844
(28) DESCRIBE `ports` 0.0014541149139404
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2147))) 0.00030398368835449
(30) DESCRIBE `ports` 0.0013530254364014
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2147') 0.00030088424682617
(32) DESCRIBE `ports` 0.0014028549194336
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00033402442932129
(34) DESCRIBE `ports` 0.0015621185302734
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00058794021606445
(36) DESCRIBE `ports` 0.0014350414276123
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00047206878662109
(38) DESCRIBE `ports` 0.0014669895172119
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00040102005004883
(40) DESCRIBE `ports` 0.0015578269958496
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00037407875061035
(42) DESCRIBE `ports` 0.0017600059509277
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00039815902709961
(44) DESCRIBE `avid_specials` 0.0016400814056396
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69783 and class = 'Cruise') OR (item_id = 98 AND class = 'Ship') OR (item_id = 23 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.0016200542449951
(46) DESCRIBE `cruiselines` 0.0028319358825684
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0005040168762207
(48) DESCRIBE `orchid_image` 0.0020971298217773
(49) DESCRIBE `cruiselines` 0.0022249221801758
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00033783912658691
(51) DESCRIBE `cruises` 0.0025560855865479
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72006') 0.00032901763916016
(53) DESCRIBE `ships` 0.0031039714813232
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1350))) 0.00041604042053223
(55) DESCRIBE `ships` 0.0029339790344238
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1350') 0.00048685073852539
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044512748718262
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(59) DESCRIBE `itineraries` 0.0014419555664062
(60) DESCRIBE `ports` 0.0016779899597168
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00051689147949219
(62) DESCRIBE `ports` 0.0014591217041016
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00039505958557129
(64) DESCRIBE `ports` 0.001417875289917
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00035309791564941
(66) DESCRIBE `sailingdates` 0.0012109279632568
(67) DESCRIBE `ports` 0.001694917678833
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0005040168762207
(69) DESCRIBE `ports` 0.0016031265258789
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00035691261291504
(71) DESCRIBE `ports` 0.0012879371643066
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00029993057250977
(73) DESCRIBE `ports` 0.0013699531555176
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00029587745666504
(75) DESCRIBE `ports` 0.0013160705566406
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00047397613525391
(77) DESCRIBE `ports` 0.001288890838623
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00034093856811523
(79) DESCRIBE `ports` 0.0014610290527344
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00030899047851562
(81) DESCRIBE `ports` 0.0012748241424561
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00030612945556641
(83) DESCRIBE `ports` 0.001305103302002
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3164))) 0.0003199577331543
(85) DESCRIBE `ports` 0.0014908313751221
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3164') 0.00030279159545898
(87) DESCRIBE `ports` 0.0014591217041016
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5444))) 0.00044918060302734
(89) DESCRIBE `ports` 0.0019018650054932
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5444') 0.00045895576477051
(91) DESCRIBE `ports` 0.0018489360809326
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.0003359317779541
(93) DESCRIBE `ports` 0.0012989044189453
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00027704238891602
(95) DESCRIBE `ports` 0.0012421607971191
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00038313865661621
(97) DESCRIBE `ports` 0.0012979507446289
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00035595893859863
(99) DESCRIBE `ports` 0.0012660026550293
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00029301643371582
(101) DESCRIBE `ports` 0.001291036605835
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.0002741813659668
(103) DESCRIBE `ports` 0.0013449192047119
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3160))) 0.00045895576477051
(105) DESCRIBE `ports` 0.0014369487762451
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3160') 0.00036001205444336
(107) DESCRIBE `ports` 0.001431941986084
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3516))) 0.00034308433532715
(109) DESCRIBE `ports` 0.0015501976013184
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3516') 0.00043201446533203
(111) DESCRIBE `ports` 0.011952877044678
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3157))) 0.00055599212646484
(113) DESCRIBE `ports` 0.0017669200897217
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3157') 0.00058293342590332
(115) DESCRIBE `ports` 0.0016279220581055
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3157))) 0.00046110153198242
(117) DESCRIBE `ports` 0.0014281272888184
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3157') 0.00039482116699219
(119) DESCRIBE `avid_specials` 0.0012860298156738
(120) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72006 and class = 'Cruise') OR (item_id = 1350 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 54 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.0011229515075684
(121) DESCRIBE `cruiselines` 0.0020151138305664
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00036215782165527
(123) DESCRIBE `orchid_image` 0.0014510154724121
(124) DESCRIBE `cruiselines` 0.0019598007202148
(125) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00040602684020996
(126) DESCRIBE `cruises` 0.0036969184875488
(127) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72066') 0.00047016143798828
(128) DESCRIBE `ships` 0.0034840106964111
(129) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00050592422485352
(130) DESCRIBE `ships` 0.0035378932952881
(131) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00042295455932617
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033378601074219
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036096572875977
(134) DESCRIBE `itineraries` 0.001708984375
(135) DESCRIBE `ports` 0.0018281936645508
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00044608116149902
(137) DESCRIBE `ports` 0.0017030239105225
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00040006637573242
(139) DESCRIBE `ports` 0.0017209053039551
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00037884712219238
(141) DESCRIBE `sailingdates` 0.0015158653259277
(142) DESCRIBE `ports` 0.0018241405487061
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00043797492980957
(144) DESCRIBE `ports` 0.0017659664154053
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00049495697021484
(146) DESCRIBE `ports` 0.001737117767334
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00039076805114746
(148) DESCRIBE `ports` 0.0017340183258057
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00036907196044922
(150) DESCRIBE `ports` 0.0017919540405273
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00041699409484863
(152) DESCRIBE `ports` 0.0017368793487549
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00043201446533203
(154) DESCRIBE `ports` 0.0018129348754883
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00049400329589844
(156) DESCRIBE `ports` 0.00177001953125
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00041317939758301
(158) DESCRIBE `ports` 0.0017669200897217
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00042891502380371
(160) DESCRIBE `ports` 0.0018019676208496
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00036907196044922
(162) DESCRIBE `ports` 0.0016729831695557
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00038790702819824
(164) DESCRIBE `ports` 0.0016548633575439
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00034594535827637
(166) DESCRIBE `ports` 0.001662015914917
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037622451782227
(168) DESCRIBE `ports` 0.0016889572143555
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00035500526428223
(170) DESCRIBE `ports` 0.0016689300537109
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0003972053527832
(172) DESCRIBE `ports` 0.0016529560089111
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00034999847412109
(174) DESCRIBE `ports` 0.0017070770263672
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00037479400634766
(176) DESCRIBE `ports` 0.0017340183258057
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00034999847412109
(178) DESCRIBE `ports` 0.0016751289367676
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00040888786315918
(180) DESCRIBE `ports` 0.0017280578613281
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00038409233093262
(182) DESCRIBE `avid_specials` 0.0015730857849121
(183) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72066 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001708984375
(184) DESCRIBE `cruiselines` 0.0025119781494141
(185) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00047016143798828
(186) DESCRIBE `orchid_image` 0.0019400119781494
(187) DESCRIBE `cruiselines` 0.0022671222686768
(188) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00040197372436523
(189) DESCRIBE `cruises` 0.0026681423187256
(190) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78624') 0.00043416023254395
(191) DESCRIBE `ships` 0.0028581619262695
(192) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 775))) 0.00037312507629395
(193) DESCRIBE `ships` 0.0025668144226074
(194) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '775') 0.00029492378234863
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028204917907715
(197) DESCRIBE `itineraries` 0.0013558864593506
(198) DESCRIBE `ports` 0.0014569759368896
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00040793418884277
(200) DESCRIBE `ports` 0.0012879371643066
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00040102005004883
(202) DESCRIBE `ports` 0.0017421245574951
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00031089782714844
(204) DESCRIBE `sailingdates` 0.001183032989502
(205) DESCRIBE `ports` 0.0015740394592285
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0004429817199707
(207) DESCRIBE `ports` 0.0014619827270508
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00038981437683105
(209) DESCRIBE `ports` 0.0014429092407227
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032997131347656
(211) DESCRIBE `ports` 0.0012969970703125
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041985511779785
(213) DESCRIBE `ports` 0.0018889904022217
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0005030632019043
(215) DESCRIBE `ports` 0.0016992092132568
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00032901763916016
(217) DESCRIBE `ports` 0.0013549327850342
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00032997131347656
(219) DESCRIBE `ports` 0.0013589859008789
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00035810470581055
(221) DESCRIBE `ports` 0.0013711452484131
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00035285949707031
(223) DESCRIBE `ports` 0.0014188289642334
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00033998489379883
(225) DESCRIBE `ports` 0.0013132095336914
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00034213066101074
(227) DESCRIBE `ports` 0.0015110969543457
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00027799606323242
(229) DESCRIBE `ports` 0.0015568733215332
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00040102005004883
(231) DESCRIBE `ports` 0.0014431476593018
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00028514862060547
(233) DESCRIBE `ports` 0.0012660026550293
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030708312988281
(235) DESCRIBE `ports` 0.0013649463653564
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00034594535827637
(237) DESCRIBE `avid_specials` 0.0011398792266846
(238) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78624 and class = 'Cruise') OR (item_id = 775 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011370182037354
(239) DESCRIBE `cruiselines` 0.0018658638000488
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00040006637573242
(241) DESCRIBE `orchid_image` 0.0014419555664062
(242) DESCRIBE `cruiselines` 0.0018558502197266
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00030803680419922
(244) DESCRIBE `cruises` 0.0029361248016357
(245) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38185') 0.00042605400085449
(246) DESCRIBE `ships` 0.0026528835296631
(247) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 643))) 0.00037288665771484
(248) DESCRIBE `ships` 0.0028910636901855
(249) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '643') 0.00044703483581543
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028204917907715
(252) DESCRIBE `itineraries` 0.0014078617095947
(253) DESCRIBE `ports` 0.0013718605041504
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00040912628173828
(255) DESCRIBE `ports` 0.0013830661773682
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00031185150146484
(257) DESCRIBE `ports` 0.0012640953063965
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00029087066650391
(259) DESCRIBE `sailingdates` 0.0011041164398193
(260) DESCRIBE `ports` 0.0012791156768799
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00031208992004395
(262) DESCRIBE `ports` 0.0012497901916504
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00027990341186523
(264) DESCRIBE `ports` 0.0012919902801514
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00040292739868164
(266) DESCRIBE `ports` 0.0015778541564941
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00028419494628906
(268) DESCRIBE `ports` 0.0013549327850342
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00029397010803223
(270) DESCRIBE `ports` 0.0012600421905518
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00027799606323242
(272) DESCRIBE `ports` 0.0012710094451904
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00031685829162598
(274) DESCRIBE `ports` 0.0012409687042236
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.0002739429473877
(276) DESCRIBE `ports` 0.0012919902801514
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4321))) 0.00033307075500488
(278) DESCRIBE `ports` 0.00124192237854
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4321') 0.00029301643371582
(280) DESCRIBE `ports` 0.0013439655303955
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4321))) 0.00030303001403809
(282) DESCRIBE `ports` 0.0012490749359131
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4321') 0.00029206275939941
(284) DESCRIBE `ports` 0.0015799999237061
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00031495094299316
(286) DESCRIBE `ports` 0.0012829303741455
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00028395652770996
(288) DESCRIBE `ports` 0.0012540817260742
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00030398368835449
(290) DESCRIBE `ports` 0.0013718605041504
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00045204162597656
(292) DESCRIBE `ports` 0.0012831687927246
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00028896331787109
(294) DESCRIBE `ports` 0.0013308525085449
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00027585029602051
(296) DESCRIBE `avid_specials` 0.0012600421905518
(297) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38185 and class = 'Cruise') OR (item_id = 643 AND class = 'Ship') OR (item_id = 144 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.0016510486602783
(298) DESCRIBE `cruiselines` 0.0020828247070312
(299) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00046706199645996
(300) DESCRIBE `orchid_image` 0.0018019676208496
(301) DESCRIBE `cruiselines` 0.0022509098052979
(302) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00034594535827637
(303) DESCRIBE `cruises` 0.0024590492248535
(304) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48660') 0.00034618377685547
(305) DESCRIBE `ships` 0.0026350021362305
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1213))) 0.00039005279541016
(307) DESCRIBE `ships` 0.0025451183319092
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1213') 0.00041294097900391
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027298927307129
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(311) DESCRIBE `itineraries` 0.0012660026550293
(312) DESCRIBE `ports` 0.0013489723205566
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3610))) 0.0003359317779541
(314) DESCRIBE `ports` 0.0013909339904785
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3610))) 0.00029492378234863
(316) DESCRIBE `ports` 0.0013449192047119
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3610') 0.00033116340637207
(318) DESCRIBE `sailingdates` 0.0013060569763184
(319) DESCRIBE `ports` 0.0018110275268555
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3610))) 0.00043010711669922
(321) DESCRIBE `ports` 0.0014700889587402
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3610') 0.00032210350036621
(323) DESCRIBE `ports` 0.0012991428375244
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3619))) 0.00039100646972656
(325) DESCRIBE `ports` 0.0014851093292236
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3619') 0.00031208992004395
(327) DESCRIBE `ports` 0.0017530918121338
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4703))) 0.00040078163146973
(329) DESCRIBE `ports` 0.0013899803161621
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4703') 0.00039196014404297
(331) DESCRIBE `ports` 0.0012688636779785
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5255))) 0.00034403800964355
(333) DESCRIBE `ports` 0.0013370513916016
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5255') 0.00030612945556641
(335) DESCRIBE `ports` 0.0013110637664795
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5658))) 0.0003201961517334
(337) DESCRIBE `ports` 0.0014348030090332
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5658') 0.00028395652770996
(339) DESCRIBE `ports` 0.0013339519500732
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4874))) 0.00037097930908203
(341) DESCRIBE `ports` 0.001276969909668
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4874') 0.00032711029052734
(343) DESCRIBE `ports` 0.0014059543609619
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3615))) 0.00034523010253906
(345) DESCRIBE `ports` 0.0016729831695557
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3615') 0.00032401084899902
(347) DESCRIBE `ports` 0.0014369487762451
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3613))) 0.00038409233093262
(349) DESCRIBE `ports` 0.0015048980712891
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3613') 0.00042295455932617
(351) DESCRIBE `ports` 0.0014369487762451
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3610))) 0.00041699409484863
(353) DESCRIBE `ports` 0.0019221305847168
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3610') 0.00039792060852051
(355) DESCRIBE `avid_specials` 0.0013060569763184
(356) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 48660 and class = 'Cruise') OR (item_id = 1213 AND class = 'Ship') OR (item_id = 236 AND class = 'CruiseLine') OR (item_id = 56 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.0012569427490234
(357) DESCRIBE `cruiselines` 0.002277135848999
(358) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00051188468933105
(359) DESCRIBE `orchid_image` 0.0020670890808105
(360) DESCRIBE `cruiselines` 0.0023910999298096
(361) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00037693977355957
(362) DESCRIBE `cruises` 0.0029020309448242
(363) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59150') 0.00047802925109863
(364) DESCRIBE `ships` 0.0034110546112061
(365) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 731))) 0.00051999092102051
(366) DESCRIBE `ships` 0.0038430690765381
(367) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '731') 0.00052905082702637
(368) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035905838012695
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041103363037109
(370) DESCRIBE `itineraries` 0.0019981861114502
(371) DESCRIBE `ports` 0.0021469593048096
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00050210952758789
(373) DESCRIBE `ports` 0.00166916847229
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00033187866210938
(375) DESCRIBE `ports` 0.0018901824951172
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00047111511230469
(377) DESCRIBE `sailingdates` 0.0012779235839844
(378) DESCRIBE `ports` 0.0016629695892334
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00047206878662109
(380) DESCRIBE `ports` 0.0013811588287354
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00031805038452148
(382) DESCRIBE `ports` 0.0017569065093994
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1690))) 0.00034403800964355
(384) DESCRIBE `ports` 0.0013349056243896
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1690') 0.00042390823364258
(386) DESCRIBE `ports` 0.0018219947814941
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.00047397613525391
(388) DESCRIBE `ports` 0.0018799304962158
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.00059294700622559
(390) DESCRIBE `ports` 0.0018420219421387
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 104))) 0.00036215782165527
(392) DESCRIBE `ports` 0.001539945602417
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '104') 0.00029301643371582
(394) DESCRIBE `ports` 0.0014009475708008
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00040984153747559
(396) DESCRIBE `ports` 0.0014669895172119
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00033903121948242
(398) DESCRIBE `ports` 0.0013868808746338
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00030398368835449
(400) DESCRIBE `ports` 0.0013489723205566
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00028491020202637
(402) DESCRIBE `ports` 0.0013539791107178
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00037693977355957
(404) DESCRIBE `ports` 0.0015649795532227
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00047206878662109
(406) DESCRIBE `ports` 0.0017850399017334
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 104))) 0.00042891502380371
(408) DESCRIBE `ports` 0.0014581680297852
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '104') 0.00029182434082031
(410) DESCRIBE `ports` 0.0016071796417236
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.00048995018005371
(412) DESCRIBE `ports` 0.0016858577728271
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.00031113624572754
(414) DESCRIBE `ports` 0.0015370845794678
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00032711029052734
(416) DESCRIBE `ports` 0.0015571117401123
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00031113624572754
(418) DESCRIBE `ports` 0.0014228820800781
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00033998489379883
(420) DESCRIBE `ports` 0.0015089511871338
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00031805038452148
(422) DESCRIBE `ports` 0.0014631748199463
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.0003819465637207
(424) DESCRIBE `ports` 0.0013298988342285
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00038599967956543
(426) DESCRIBE `avid_specials` 0.0013489723205566
(427) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59150 and class = 'Cruise') OR (item_id = 731 AND class = 'Ship') OR (item_id = 168 AND class = 'CruiseLine') OR (item_id = 44 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.0016641616821289
(428) DESCRIBE `cruiselines` 0.0024888515472412
(429) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 168))) 0.00038290023803711
(430) DESCRIBE `orchid_image` 0.0019571781158447
(431) DESCRIBE `cruiselines` 0.0022540092468262
(432) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '168') 0.0004279613494873
(433) DESCRIBE `cruises` 0.003896951675415
(434) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62664') 0.00049901008605957
(435) DESCRIBE `ships` 0.0031559467315674
(436) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00040411949157715
(437) DESCRIBE `ships` 0.0029478073120117
(438) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00033283233642578
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027990341186523
(441) DESCRIBE `itineraries` 0.0013191699981689
(442) DESCRIBE `ports` 0.0014770030975342
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033307075500488
(444) DESCRIBE `ports` 0.0015990734100342
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035786628723145
(446) DESCRIBE `ports` 0.0013899803161621
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00032687187194824
(448) DESCRIBE `sailingdates` 0.0012791156768799
(449) DESCRIBE `ports` 0.0018949508666992
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046801567077637
(451) DESCRIBE `ports` 0.0017499923706055
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00036382675170898
(453) DESCRIBE `ports` 0.0016679763793945
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00038790702819824
(455) DESCRIBE `ports` 0.0016829967498779
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00037097930908203
(457) DESCRIBE `ports` 0.0017631053924561
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00039315223693848
(459) DESCRIBE `ports` 0.0016689300537109
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00034499168395996
(461) DESCRIBE `ports` 0.0016429424285889
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043416023254395
(463) DESCRIBE `ports` 0.001633882522583
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00038290023803711
(465) DESCRIBE `ports` 0.0018119812011719
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00044107437133789
(467) DESCRIBE `ports` 0.0017249584197998
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00037598609924316
(469) DESCRIBE `ports` 0.0017421245574951
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0003960132598877
(471) DESCRIBE `ports` 0.0017468929290771
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00040698051452637
(473) DESCRIBE `ports` 0.0016298294067383
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040102005004883
(475) DESCRIBE `ports` 0.0017290115356445
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00036191940307617
(477) DESCRIBE `avid_specials` 0.0015740394592285
(478) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62664 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016591548919678
(479) DESCRIBE `cruiselines` 0.0024209022521973
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00041389465332031
(481) DESCRIBE `orchid_image` 0.0018949508666992
(482) DESCRIBE `cruiselines` 0.0024099349975586
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00037503242492676
(484) DESCRIBE `cruises` 0.0035109519958496
(485) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69430') 0.00043988227844238
(486) DESCRIBE `ships` 0.0034420490264893
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1272))) 0.00049614906311035
(488) DESCRIBE `ships` 0.0034348964691162
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1272') 0.00039410591125488
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032496452331543
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(492) DESCRIBE `itineraries` 0.0016500949859619
(493) DESCRIBE `ports` 0.0016920566558838
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049901008605957
(495) DESCRIBE `ports` 0.0016181468963623
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035810470581055
(497) DESCRIBE `ports` 0.0016119480133057
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00033903121948242
(499) DESCRIBE `sailingdates` 0.0015199184417725
(500) DESCRIBE `ports` 0.001680850982666
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040388107299805
(502) DESCRIBE `ports` 0.0016229152679443
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041103363037109
(504) DESCRIBE `ports` 0.0016391277313232
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00034999847412109
(506) DESCRIBE `ports` 0.0016798973083496
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00034308433532715
(508) DESCRIBE `ports` 0.0017099380493164
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00037884712219238
(510) DESCRIBE `ports` 0.0016789436340332
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00039505958557129
(512) DESCRIBE `ports` 0.0017249584197998
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00030708312988281
(514) DESCRIBE `ports` 0.0016379356384277
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00033783912658691
(516) DESCRIBE `ports` 0.0013811588287354
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031304359436035
(518) DESCRIBE `ports` 0.001305103302002
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00048184394836426
(520) DESCRIBE `ports` 0.0015420913696289
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00040888786315918
(522) DESCRIBE `ports` 0.0015890598297119
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00033092498779297
(524) DESCRIBE `ports` 0.0017058849334717
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031805038452148
(526) DESCRIBE `ports` 0.0013151168823242
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028300285339355
(528) DESCRIBE `avid_specials` 0.0012879371643066
(529) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69430 and class = 'Cruise') OR (item_id = 1272 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012311935424805
(530) DESCRIBE `cruiselines` 0.0020108222961426
(531) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00035309791564941
(532) DESCRIBE `orchid_image` 0.0015368461608887
(533) DESCRIBE `cruiselines` 0.0020630359649658
(534) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00032782554626465
(535) DESCRIBE `cruises` 0.0025739669799805
(536) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72481') 0.00034093856811523
(537) DESCRIBE `ships` 0.0026218891143799
(538) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1106))) 0.00046801567077637
(539) DESCRIBE `ships` 0.0027799606323242
(540) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1106') 0.00037717819213867
(541) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034999847412109
(542) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00030899047851562
(543) DESCRIBE `itineraries` 0.0016720294952393
(544) DESCRIBE `ports` 0.0015981197357178
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00040888786315918
(546) DESCRIBE `ports` 0.0014040470123291
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00031614303588867
(548) DESCRIBE `ports` 0.0015079975128174
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00029778480529785
(550) DESCRIBE `sailingdates` 0.0011930465698242
(551) DESCRIBE `ports` 0.00142502784729
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00050210952758789
(553) DESCRIBE `ports` 0.001863956451416
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00039505958557129
(555) DESCRIBE `ports` 0.0017328262329102
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00040602684020996
(557) DESCRIBE `ports` 0.0017061233520508
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00038790702819824
(559) DESCRIBE `ports` 0.0014979839324951
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00032591819763184
(561) DESCRIBE `ports` 0.0014140605926514
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00031399726867676
(563) DESCRIBE `ports` 0.0015699863433838
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00037002563476562
(565) DESCRIBE `ports` 0.0015389919281006
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00036287307739258
(567) DESCRIBE `ports` 0.0014801025390625
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00045084953308105
(569) DESCRIBE `ports` 0.0014729499816895
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00034594535827637
(571) DESCRIBE `avid_specials` 0.0012049674987793
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72481 and class = 'Cruise') OR (item_id = 1106 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001291036605835
(573) DESCRIBE `cruiselines` 0.0026290416717529
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00046086311340332
(575) DESCRIBE `orchid_image` 0.0021488666534424
(576) DESCRIBE `cruiselines` 0.0025830268859863
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00037598609924316
(578) DESCRIBE `cruiselines` 0.0029060840606689
(579) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '26', '19', '77', '23', '7', '20', '131', '12', '8', '171', '18', '144', '221', '31', '103', '101', '232', '156', '96', '239', '50', '258', '33', '29', '251', '15', '206', '191', '91', '114', '212', '14', '268', '24', '37', '170', '16', '187', '262', '256', '36', '28', '110', '195', '47', '240', '208', '146', '204', '220', '181', '174', '153', '118', '120', '229', '141', '49', '108', '151', '128', '38', '35', '159', '30', '216', '168', '196', '236', '88', '4', '200', '264', '90', '225', '238', '211', '73', '140', '39', '147', '184', '249', '57', '59', '48', '275', '132', '213', '257', '276', '219', '64', '261', '113', '182', '115', '230', '237', '188', '95', '180', '248', '231', '52', '209', '116', '266', '235', '62', '105', '82', '134', '177', '244', '119', '210', '224', '245', '263')) ORDER BY FIND_IN_SET(id, '218,183,26,19,77,23,7,20,131,12,8,171,18,144,221,31,103,101,232,156,96,239,50,258,33,29,251,15,206,191,91,114,212,14,268,24,37,170,16,187,262,256,36,28,110,195,47,240,208,146,204,220,181,174,153,118,120,229,141,49,108,151,128,38,35,159,30,216,168,196,236,88,4,200,264,90,225,238,211,73,140,39,147,184,249,57,59,48,275,132,213,257,276,219,64,261,113,182,115,230,237,188,95,180,248,231,52,209,116,266,235,62,105,82,134,177,244,119,210,224,245,263') 0.0075168609619141
(580) DESCRIBE `ships` 0.0030441284179688
(581) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1761', '1247', '1554', '1555', '1324', '517', '974', '1032', '1794', '1292', '797', '22', '461', '21', '393', '28', '977', '330', '207', '258', '1205', '1599', '480', '349', '1291', '737', '1010', '11', '10', '1199', '439', '404', '333', '1417', '780', '986', '9', '739', '1135', '1588', '14', '726', '265', '1272', '454', '855', '1677', '24', '817', '25', '1359', '770', '731', '1067', '859', '1607', '1237', '3', '113', '1481', '38', '34', '837', '31', '37', '378', '1372', '985', '1594', '1239', '542', '1163', '1744', '1768', '748', '66', '390', '1320', '1526', '1579', '43', '573', '1323', '1422', '1424', '526', '970', '1402', '1413', '39', '1420', '30', '36', '327', '407', '854', '882', '1012', '1411', '1419', '1423', '332', '1418', '1421', '582', '1410', '27', '1454', '160', '590', '1013', '1586', '1773', '791', '792', '674', '958', '1552', '1245', '1284', '580', '35', '114', '441', '1183', '1308', '455', '1184', '1348', '1587', '585', '1193', '1303', '1376', '162', '1415', '1236', '1682', '434', '1159', '1742', '325', '722', '857', '1382', '1461', '1501', '639', '644', '858', '1176', '711', '1215', '1405', '1574', '163', '452', '852', '1412', '462', '658', '683', '1289', '1408', '1678', '78', '81', '119', '285', '338', '1021', '1008', '1172', '673', '1168', '1019', '1373', '69', '1095', '1141', '211', '1160', '111', '610', '678', '776', '850', '1217', '286', '335', '1319', '1383', '1426', '1628', '1782', '1384', '1743', '1711', '45', '253', '1572', '1630', '314', '1569', '348', '403', '451', '851', '869', '1259', '1358', '405', '766', '818', '1302', '1760', '553', '626', '651', '749', '968', '4', '508', '1068', '1266', '1455', '70', '116', '966', '1108', '124', '148', '386', '467', '944', '1082', '1330', '1632', '63', '324', '385', '389', '616', '768', '1260', '1301', '1562', '84', '262', '340', '375', '485', '885', '1195', '1672', '108', '123', '291', '1325', '198', '421', '635', '663', '1639', '1751', '287', '784', '1064', '1088', '483', '1212', '1322', '1575', '98', '1614', '1721', '290', '1208', '1580', '1581', '1781', '652', '703', '883', '954', '1492', '1020', '394', '401', '1321', '1724', '147', '657', '1139', '1398', '1486', '1611', '1722', '1750', '406', '716', '1269', '1601', '1717', '547', '1268', '1539', '1615', '223', '1557', '1738', '149', '150', '152', '341', '516', '1143', '1282', '1326', '1327', '1437', '1445', '1571', '1645', '151', '559', '704', '775', '796', '1771', '717', '1040', '1075', '1704', '105', '545', '886', '1262', '1270', '1444', '1679', '1681', '503', '790', '1151', '1673', '1684', '75', '656', '982', '1254', '1367', '1389', '1063', '1318', '1676', '1740', '205', '351', '574', '761', '1561', '1766', '1043', '1213', '1218', '1471', '1540', '1566', '868', '1144', '1157', '93', '701', '751', '1137', '1223', '1226', '1344', '82', '212', '479', '715', '874', '1027', '1029', '1214', '1229', '1343', '1716', '1767', '665', '808', '823', '884', '1158', '1283', '1452', '1453', '1604', '1772', '687', '1025', '1073', '1090', '1612', '1613', '1706', '201', '266', '795', '988', '1055', '1136', '1216', '1409', '1448', '1713', '1715', '1788', '417', '601', '905', '996', '1026', '1145', '1233', '1458', '1496', '1714', '1791', '695', '767', '1188', '1297', '1602', '1783', '643', '669', '707', '769', '888', '973', '1034', '1149', '1156', '1351', '1366', '1404', '1516', '1609', '448', '743', '979', '1049', '1150', '1155', '1196', '1222', '1231', '1345', '1360', '1361', '1362', '1368', '1414', '1459', '1522', '1647', '1730', '666', '685', '692', '920', '921', '927', '931', '1047', '1230', '1296', '1354', '1474', '1517', '1627', '1729', '74', '423', '914', '923', '997', '1004', '1110', '1253', '1295', '1518', '1567', '618', '915', '916')) ORDER BY FIND_IN_SET(id, '1127,1761,1247,1554,1555,1324,517,974,1032,1794,1292,797,22,461,21,393,28,977,330,207,258,1205,1599,480,349,1291,737,1010,11,10,1199,439,404,333,1417,780,986,9,739,1135,1588,14,726,265,1272,454,855,1677,24,817,25,1359,770,731,1067,859,1607,1237,3,113,1481,38,34,837,31,37,378,1372,985,1594,1239,542,1163,1744,1768,748,66,390,1320,1526,1579,43,573,1323,1422,1424,526,970,1402,1413,39,1420,30,36,327,407,854,882,1012,1411,1419,1423,332,1418,1421,582,1410,27,1454,160,590,1013,1586,1773,791,792,674,958,1552,1245,1284,580,35,114,441,1183,1308,455,1184,1348,1587,585,1193,1303,1376,162,1415,1236,1682,434,1159,1742,325,722,857,1382,1461,1501,639,644,858,1176,711,1215,1405,1574,163,452,852,1412,462,658,683,1289,1408,1678,78,81,119,285,338,1021,1008,1172,673,1168,1019,1373,69,1095,1141,211,1160,111,610,678,776,850,1217,286,335,1319,1383,1426,1628,1782,1384,1743,1711,45,253,1572,1630,314,1569,348,403,451,851,869,1259,1358,405,766,818,1302,1760,553,626,651,749,968,4,508,1068,1266,1455,70,116,966,1108,124,148,386,467,944,1082,1330,1632,63,324,385,389,616,768,1260,1301,1562,84,262,340,375,485,885,1195,1672,108,123,291,1325,198,421,635,663,1639,1751,287,784,1064,1088,483,1212,1322,1575,98,1614,1721,290,1208,1580,1581,1781,652,703,883,954,1492,1020,394,401,1321,1724,147,657,1139,1398,1486,1611,1722,1750,406,716,1269,1601,1717,547,1268,1539,1615,223,1557,1738,149,150,152,341,516,1143,1282,1326,1327,1437,1445,1571,1645,151,559,704,775,796,1771,717,1040,1075,1704,105,545,886,1262,1270,1444,1679,1681,503,790,1151,1673,1684,75,656,982,1254,1367,1389,1063,1318,1676,1740,205,351,574,761,1561,1766,1043,1213,1218,1471,1540,1566,868,1144,1157,93,701,751,1137,1223,1226,1344,82,212,479,715,874,1027,1029,1214,1229,1343,1716,1767,665,808,823,884,1158,1283,1452,1453,1604,1772,687,1025,1073,1090,1612,1613,1706,201,266,795,988,1055,1136,1216,1409,1448,1713,1715,1788,417,601,905,996,1026,1145,1233,1458,1496,1714,1791,695,767,1188,1297,1602,1783,643,669,707,769,888,973,1034,1149,1156,1351,1366,1404,1516,1609,448,743,979,1049,1150,1155,1196,1222,1231,1345,1360,1361,1362,1368,1414,1459,1522,1647,1730,666,685,692,920,921,927,931,1047,1230,1296,1354,1474,1517,1627,1729,74,423,914,923,997,1004,1110,1253,1295,1518,1567,618,915,916') 0.054254055023193
(582) DESCRIBE `cruisetypes` 0.0014791488647461
(583) DESCRIBE `destinations` 0.0019669532775879
(584) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '39', '44', '55', '53', '26', '28', '38', '49', '11', '21', '40', '7', '56', '30', '48', '46', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,39,44,55,53,26,28,38,49,11,21,40,7,56,30,48,46,29,45,34,10,52,32') 0.0024569034576416