or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 1.0971462726593

# Query Time
(1) connect 0.00090193748474121
(2) DESCRIBE `cruises` 0.0044968128204346
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (11517, 11516, 65943, 65945, 49093, 56009, 82484, 82464, 82483)) ORDER BY FIND_IN_SET(id, '11517,11516,65943,65945,49093,56009,82484,82464,82483') 0.0024819374084473
(4) DESCRIBE `specials` 0.0063071250915527
(5) DESCRIBE `specials` 0.0051231384277344
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541784') 0.00053501129150391
(7) DESCRIBE `ships` 0.0040650367736816
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.0006260871887207
(9) DESCRIBE `ships` 0.0038812160491943
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00048398971557617
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032401084899902
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028491020202637
(13) DESCRIBE `itineraries` 0.0015931129455566
(14) DESCRIBE `ports` 0.002528190612793
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00062990188598633
(16) DESCRIBE `ports` 0.0020098686218262
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00052499771118164
(18) DESCRIBE `ports` 0.0019211769104004
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00044393539428711
(20) DESCRIBE `specialsailingdates` 0.0016179084777832
(21) DESCRIBE `sailingdates` 0.0019271373748779
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518739))) 0.00049304962158203
(23) DESCRIBE `sailingdates` 0.0016889572143555
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518740))) 0.00039815902709961
(25) DESCRIBE `sailingdates` 0.0014548301696777
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518741))) 0.0004429817199707
(27) DESCRIBE `sailingdates` 0.0017118453979492
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518742))) 0.00047516822814941
(29) DESCRIBE `sailingdates` 0.0017769336700439
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518743))) 0.00051784515380859
(31) DESCRIBE `sailingdates` 0.00177001953125
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518744))) 0.00041794776916504
(33) DESCRIBE `sailingdates` 0.0017199516296387
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518746))) 0.00048613548278809
(35) DESCRIBE `sailingdates` 0.0016818046569824
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518749))) 0.0005800724029541
(37) DESCRIBE `sailingdates` 0.0015919208526611
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518750))) 0.00046515464782715
(39) DESCRIBE `sailingdates` 0.0017650127410889
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518751))) 0.00040817260742188
(41) DESCRIBE `sailingdates` 0.0017490386962891
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518754))) 0.0004730224609375
(43) DESCRIBE `sailingdates` 0.0016891956329346
(44) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518755))) 0.00042009353637695
(45) DESCRIBE `sailingdates` 0.0014488697052002
(46) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518756))) 0.00037407875061035
(47) DESCRIBE `sailingdates` 0.0013208389282227
(48) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518757))) 0.00031590461730957
(49) DESCRIBE `sailingdates` 0.0013539791107178
(50) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518758))) 0.00035500526428223
(51) DESCRIBE `sailingdates` 0.0017738342285156
(52) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518759))) 0.00040698051452637
(53) DESCRIBE `sailingdates` 0.0015189647674561
(54) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518760))) 0.00037312507629395
(55) DESCRIBE `sailingdates` 0.0016579627990723
(56) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518761))) 0.00049686431884766
(57) DESCRIBE `sailingdates` 0.0017261505126953
(58) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518762))) 0.0004420280456543
(59) DESCRIBE `sailingdates` 0.0016698837280273
(60) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518763))) 0.00040411949157715
(61) DESCRIBE `sailingdates` 0.0016281604766846
(62) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518764))) 0.00038599967956543
(63) DESCRIBE `sailingdates` 0.0015339851379395
(64) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518765))) 0.00035405158996582
(65) DESCRIBE `sailingdates` 0.0016801357269287
(66) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518766))) 0.00041484832763672
(67) DESCRIBE `sailingdates` 0.0016698837280273
(68) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518767))) 0.00038886070251465
(69) DESCRIBE `sailingdates` 0.0018129348754883
(70) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518770))) 0.00037097930908203
(71) DESCRIBE `sailingdates` 0.0014870166778564
(72) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518772))) 0.0004279613494873
(73) DESCRIBE `sailingdates` 0.0013101100921631
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518773))) 0.00028181076049805
(75) DESCRIBE `sailingdates` 0.0012650489807129
(76) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518774))) 0.00037503242492676
(77) DESCRIBE `sailingdates` 0.0013141632080078
(78) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518776))) 0.00030803680419922
(79) DESCRIBE `sailingdates` 0.0014209747314453
(80) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518777))) 0.00028181076049805
(81) DESCRIBE `sailingdates` 0.0013010501861572
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518778))) 0.00035595893859863
(83) DESCRIBE `sailingdates` 0.0014829635620117
(84) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518779))) 0.00039005279541016
(85) DESCRIBE `sailingdates` 0.001533031463623
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518780))) 0.00042414665222168
(87) DESCRIBE `ports` 0.0016238689422607
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00034403800964355
(89) DESCRIBE `ports` 0.001356840133667
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00035691261291504
(91) DESCRIBE `ports` 0.0015850067138672
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00035309791564941
(93) DESCRIBE `ports` 0.0015778541564941
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00029897689819336
(95) DESCRIBE `ports` 0.00142502784729
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00037503242492676
(97) DESCRIBE `ports` 0.0012729167938232
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00027990341186523
(99) DESCRIBE `ports` 0.0012848377227783
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00032591819763184
(101) DESCRIBE `ports` 0.0016579627990723
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017595291137695
(103) DESCRIBE `ports` 0.0013928413391113
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00044107437133789
(105) DESCRIBE `ports` 0.001439094543457
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00034904479980469
(107) DESCRIBE `ports` 0.0014090538024902
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00019001960754395
(109) DESCRIBE `ports` 0.0013160705566406
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00034594535827637
(111) DESCRIBE `ports` 0.0014700889587402
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00030088424682617
(113) DESCRIBE `ports` 0.0014331340789795
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00028586387634277
(115) DESCRIBE `ports` 0.0014700889587402
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00038003921508789
(117) DESCRIBE `ports` 0.0017311573028564
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00028800964355469
(119) DESCRIBE `cruises` 0.0027749538421631
(120) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00042486190795898
(121) DESCRIBE `avid_specials` 0.0014758110046387
(122) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541784 and class = 'Special') OR (item_id = 11517 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 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.0010390281677246
(123) DESCRIBE `cruiselines` 0.0022540092468262
(124) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0003659725189209
(125) DESCRIBE `orchid_image` 0.001762866973877
(126) DESCRIBE `cruiselines` 0.0025348663330078
(127) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00037288665771484
(128) DESCRIBE `specials` 0.0050158500671387
(129) DESCRIBE `specials` 0.0050599575042725
(130) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541793') 0.00043010711669922
(131) DESCRIBE `ships` 0.0028619766235352
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00040507316589355
(133) DESCRIBE `ships` 0.0029900074005127
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00030899047851562
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029301643371582
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025391578674316
(137) DESCRIBE `itineraries` 0.0013730525970459
(138) DESCRIBE `ports` 0.0015029907226562
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00033903121948242
(140) DESCRIBE `ports` 0.0016269683837891
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0006558895111084
(142) DESCRIBE `ports` 0.0021510124206543
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00046014785766602
(144) DESCRIBE `specialsailingdates` 0.0016169548034668
(145) DESCRIBE `sailingdates` 0.0019009113311768
(146) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518625))) 0.00046586990356445
(147) DESCRIBE `sailingdates` 0.001884937286377
(148) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518626))) 0.00046801567077637
(149) DESCRIBE `sailingdates` 0.0018320083618164
(150) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518627))) 0.00045084953308105
(151) DESCRIBE `sailingdates` 0.0017440319061279
(152) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518631))) 0.00044393539428711
(153) DESCRIBE `sailingdates` 0.0016360282897949
(154) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518634))) 0.00042891502380371
(155) DESCRIBE `sailingdates` 0.0017321109771729
(156) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518635))) 0.00048995018005371
(157) DESCRIBE `sailingdates` 0.001716136932373
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518637))) 0.00048303604125977
(159) DESCRIBE `sailingdates` 0.0018060207366943
(160) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518639))) 0.00059294700622559
(161) DESCRIBE `sailingdates` 0.0019769668579102
(162) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518640))) 0.00045990943908691
(163) DESCRIBE `sailingdates` 0.0016560554504395
(164) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518641))) 0.00038290023803711
(165) DESCRIBE `sailingdates` 0.0016210079193115
(166) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518642))) 0.00064206123352051
(167) DESCRIBE `sailingdates` 0.0017099380493164
(168) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518643))) 0.00040888786315918
(169) DESCRIBE `sailingdates` 0.0015060901641846
(170) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518644))) 0.00034689903259277
(171) DESCRIBE `sailingdates` 0.0015218257904053
(172) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518645))) 0.00037693977355957
(173) DESCRIBE `sailingdates` 0.0015721321105957
(174) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518646))) 0.00036883354187012
(175) DESCRIBE `sailingdates` 0.0015778541564941
(176) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518647))) 0.00037598609924316
(177) DESCRIBE `sailingdates` 0.0016391277313232
(178) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518648))) 0.00040102005004883
(179) DESCRIBE `sailingdates` 0.0016179084777832
(180) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518649))) 0.00037908554077148
(181) DESCRIBE `sailingdates` 0.001568078994751
(182) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518650))) 0.00039196014404297
(183) DESCRIBE `sailingdates` 0.0016090869903564
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518651))) 0.00040102005004883
(185) DESCRIBE `sailingdates` 0.0016219615936279
(186) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518652))) 0.00038385391235352
(187) DESCRIBE `sailingdates` 0.0016300678253174
(188) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518653))) 0.00039505958557129
(189) DESCRIBE `sailingdates` 0.0016419887542725
(190) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518655))) 0.0004580020904541
(191) DESCRIBE `sailingdates` 0.0016529560089111
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518656))) 0.00038385391235352
(193) DESCRIBE `sailingdates` 0.0016419887542725
(194) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518657))) 0.00039005279541016
(195) DESCRIBE `sailingdates` 0.0016059875488281
(196) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518658))) 0.00039505958557129
(197) DESCRIBE `sailingdates` 0.0015850067138672
(198) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518659))) 0.00039196014404297
(199) DESCRIBE `sailingdates` 0.0017189979553223
(200) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518660))) 0.00043821334838867
(201) DESCRIBE `sailingdates` 0.0015990734100342
(202) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518661))) 0.00044798851013184
(203) DESCRIBE `sailingdates` 0.0017950534820557
(204) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518662))) 0.00042986869812012
(205) DESCRIBE `sailingdates` 0.0016410350799561
(206) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518663))) 0.0004119873046875
(207) DESCRIBE `ports` 0.0022051334381104
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00049901008605957
(209) DESCRIBE `ports` 0.0021929740905762
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00046300888061523
(211) DESCRIBE `ports` 0.0019271373748779
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00047683715820312
(213) DESCRIBE `ports` 0.001896858215332
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00040388107299805
(215) DESCRIBE `ports` 0.0018749237060547
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.0004889965057373
(217) DESCRIBE `ports` 0.0018508434295654
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00040102005004883
(219) DESCRIBE `ports` 0.0019400119781494
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00029182434082031
(221) DESCRIBE `ports` 0.0020401477813721
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00041890144348145
(223) DESCRIBE `ports` 0.0019011497497559
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00043797492980957
(225) DESCRIBE `ports` 0.0019950866699219
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00046396255493164
(227) DESCRIBE `ports` 0.0020029544830322
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0004730224609375
(229) DESCRIBE `ports` 0.0019931793212891
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00044488906860352
(231) DESCRIBE `ports` 0.0019309520721436
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00046610832214355
(233) DESCRIBE `ports` 0.0019080638885498
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00043892860412598
(235) DESCRIBE `ports` 0.0018479824066162
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00050210952758789
(237) DESCRIBE `ports` 0.0018749237060547
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00079703330993652
(239) DESCRIBE `ports` 0.0030810832977295
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00056004524230957
(241) DESCRIBE `ports` 0.0024030208587646
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.001011848449707
(243) DESCRIBE `cruises` 0.0044829845428467
(244) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11516))) 0.00076198577880859
(245) DESCRIBE `avid_specials` 0.0017240047454834
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541793 and class = 'Special') OR (item_id = 11516 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 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.0021429061889648
(247) DESCRIBE `cruiselines` 0.0030570030212402
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00057792663574219
(249) DESCRIBE `orchid_image` 0.0022659301757812
(250) DESCRIBE `cruiselines` 0.0028538703918457
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00047588348388672
(252) DESCRIBE `specials` 0.0063290596008301
(253) DESCRIBE `specials` 0.0059220790863037
(254) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541766') 0.00064206123352051
(255) DESCRIBE `ships` 0.0043878555297852
(256) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 520))) 0.00051593780517578
(257) DESCRIBE `ships` 0.0035109519958496
(258) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '520') 0.00041604042053223
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028419494628906
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030684471130371
(261) DESCRIBE `itineraries` 0.0018088817596436
(262) DESCRIBE `ports` 0.001680850982666
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00041699409484863
(264) DESCRIBE `ports` 0.0014889240264893
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00035214424133301
(266) DESCRIBE `ports` 0.0017330646514893
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00037097930908203
(268) DESCRIBE `specialsailingdates` 0.0012619495391846
(269) DESCRIBE `sailingdates` 0.0015120506286621
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518703))) 0.00034999847412109
(271) DESCRIBE `sailingdates` 0.0015060901641846
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518707))) 0.00039291381835938
(273) DESCRIBE `sailingdates` 0.0015201568603516
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518708))) 0.00040197372436523
(275) DESCRIBE `sailingdates` 0.0014891624450684
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518710))) 0.00035715103149414
(277) DESCRIBE `sailingdates` 0.0014259815216064
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518711))) 0.00037598609924316
(279) DESCRIBE `sailingdates` 0.0016160011291504
(280) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518713))) 0.00040316581726074
(281) DESCRIBE `sailingdates` 0.0014619827270508
(282) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518715))) 0.00032496452331543
(283) DESCRIBE `sailingdates` 0.0013430118560791
(284) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518716))) 0.00039196014404297
(285) DESCRIBE `sailingdates` 0.0016529560089111
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518718))) 0.00032305717468262
(287) DESCRIBE `sailingdates` 0.0011751651763916
(288) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518721))) 0.00035595893859863
(289) DESCRIBE `sailingdates` 0.0012478828430176
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518722))) 0.00032901763916016
(291) DESCRIBE `sailingdates` 0.0016241073608398
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518723))) 0.00033378601074219
(293) DESCRIBE `sailingdates` 0.0015709400177002
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518724))) 0.00030398368835449
(295) DESCRIBE `sailingdates` 0.0012340545654297
(296) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518725))) 0.0003058910369873
(297) DESCRIBE `sailingdates` 0.0012249946594238
(298) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518726))) 0.00032401084899902
(299) DESCRIBE `sailingdates` 0.0013418197631836
(300) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518727))) 0.00043487548828125
(301) DESCRIBE `sailingdates` 0.0014419555664062
(302) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518728))) 0.0003819465637207
(303) DESCRIBE `sailingdates` 0.0014550685882568
(304) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518729))) 0.00038385391235352
(305) DESCRIBE `sailingdates` 0.0014069080352783
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518730))) 0.00034999847412109
(307) DESCRIBE `sailingdates` 0.001251220703125
(308) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518731))) 0.00028705596923828
(309) DESCRIBE `sailingdates` 0.0013430118560791
(310) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518732))) 0.0002892017364502
(311) DESCRIBE `sailingdates` 0.0011799335479736
(312) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518733))) 0.00044512748718262
(313) DESCRIBE `sailingdates` 0.0012879371643066
(314) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518734))) 0.00033092498779297
(315) DESCRIBE `sailingdates` 0.0016088485717773
(316) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518735))) 0.00032687187194824
(317) DESCRIBE `sailingdates` 0.0016391277313232
(318) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518736))) 0.00051617622375488
(319) DESCRIBE `sailingdates` 0.0014891624450684
(320) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518737))) 0.00039887428283691
(321) DESCRIBE `sailingdates` 0.0014050006866455
(322) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518738))) 0.0003349781036377
(323) DESCRIBE `ports` 0.0017390251159668
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00041699409484863
(325) DESCRIBE `ports` 0.0014889240264893
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00044798851013184
(327) DESCRIBE `ports` 0.0018398761749268
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00048708915710449
(329) DESCRIBE `ports` 0.001535177230835
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.0003049373626709
(331) DESCRIBE `ports` 0.0013668537139893
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.0003049373626709
(333) DESCRIBE `ports` 0.0012640953063965
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00032401084899902
(335) DESCRIBE `ports` 0.0015509128570557
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00036191940307617
(337) DESCRIBE `ports` 0.0016040802001953
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00036311149597168
(339) DESCRIBE `ports` 0.0015890598297119
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00040698051452637
(341) DESCRIBE `ports` 0.0015299320220947
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00040793418884277
(343) DESCRIBE `ports` 0.0017049312591553
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00043988227844238
(345) DESCRIBE `ports` 0.001784086227417
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00036907196044922
(347) DESCRIBE `ports` 0.0014369487762451
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00035786628723145
(349) DESCRIBE `ports` 0.001478910446167
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.0004119873046875
(351) DESCRIBE `ports` 0.0016889572143555
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00050187110900879
(353) DESCRIBE `ports` 0.0019409656524658
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00043702125549316
(355) DESCRIBE `cruises` 0.0029411315917969
(356) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65943))) 0.00055098533630371
(357) DESCRIBE `avid_specials` 0.0014371871948242
(358) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541766 and class = 'Special') OR (item_id = 65943 and class = 'Cruise') OR (item_id = 520 AND class = 'Ship') OR (item_id = 120 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.0011639595031738
(359) DESCRIBE `cruiselines` 0.0022571086883545
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00049090385437012
(361) DESCRIBE `orchid_image` 0.0019428730010986
(362) DESCRIBE `cruiselines` 0.0023641586303711
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00033307075500488
(364) DESCRIBE `specials` 0.0051960945129395
(365) DESCRIBE `specials` 0.0058979988098145
(366) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541775') 0.00058913230895996
(367) DESCRIBE `ships` 0.0043518543243408
(368) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 520))) 0.0021750926971436
(369) DESCRIBE `ships` 0.0042228698730469
(370) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '520') 0.0005180835723877
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033211708068848
(372) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003359317779541
(373) DESCRIBE `itineraries` 0.0019700527191162
(374) DESCRIBE `ports` 0.0021021366119385
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00050711631774902
(376) DESCRIBE `ports` 0.0018699169158936
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00044679641723633
(378) DESCRIBE `ports` 0.0019679069519043
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00044417381286621
(380) DESCRIBE `specialsailingdates` 0.0015871524810791
(381) DESCRIBE `sailingdates` 0.0020029544830322
(382) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518664))) 0.00046396255493164
(383) DESCRIBE `sailingdates` 0.0017349720001221
(384) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518668))) 0.00046896934509277
(385) DESCRIBE `sailingdates` 0.0016779899597168
(386) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518669))) 0.00059795379638672
(387) DESCRIBE `sailingdates` 0.0016169548034668
(388) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518671))) 0.00044083595275879
(389) DESCRIBE `sailingdates` 0.0016410350799561
(390) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518672))) 0.00044488906860352
(391) DESCRIBE `sailingdates` 0.0016610622406006
(392) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518673))) 0.00038385391235352
(393) DESCRIBE `sailingdates` 0.0016348361968994
(394) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518674))) 0.00043392181396484
(395) DESCRIBE `sailingdates` 0.0016460418701172
(396) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518676))) 0.00036501884460449
(397) DESCRIBE `sailingdates` 0.0012290477752686
(398) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518677))) 0.00039815902709961
(399) DESCRIBE `sailingdates` 0.00148606300354
(400) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518678))) 0.00037002563476562
(401) DESCRIBE `sailingdates` 0.0012648105621338
(402) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518679))) 0.00029611587524414
(403) DESCRIBE `sailingdates` 0.0011940002441406
(404) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518680))) 0.00030899047851562
(405) DESCRIBE `sailingdates` 0.0012249946594238
(406) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518681))) 0.0003361701965332
(407) DESCRIBE `sailingdates` 0.0013511180877686
(408) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518682))) 0.00034689903259277
(409) DESCRIBE `sailingdates` 0.0012249946594238
(410) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518683))) 0.00029301643371582
(411) DESCRIBE `sailingdates` 0.0012359619140625
(412) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518686))) 0.00029611587524414
(413) DESCRIBE `sailingdates` 0.0013198852539062
(414) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518687))) 0.0003199577331543
(415) DESCRIBE `sailingdates` 0.0012710094451904
(416) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518688))) 0.0003509521484375
(417) DESCRIBE `sailingdates` 0.001492977142334
(418) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518696))) 0.00037097930908203
(419) DESCRIBE `sailingdates` 0.0016188621520996
(420) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518697))) 0.00034999847412109
(421) DESCRIBE `sailingdates` 0.0016398429870605
(422) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518698))) 0.00038981437683105
(423) DESCRIBE `sailingdates` 0.0014801025390625
(424) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518699))) 0.00034689903259277
(425) DESCRIBE `sailingdates` 0.0012280941009521
(426) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518700))) 0.00030994415283203
(427) DESCRIBE `sailingdates` 0.0013480186462402
(428) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518701))) 0.00028300285339355
(429) DESCRIBE `ports` 0.0016520023345947
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00042414665222168
(431) DESCRIBE `ports` 0.0014159679412842
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00033712387084961
(433) DESCRIBE `ports` 0.0013918876647949
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00032210350036621
(435) DESCRIBE `ports` 0.0012810230255127
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00034904479980469
(437) DESCRIBE `ports` 0.0017530918121338
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00040197372436523
(439) DESCRIBE `ports` 0.0014369487762451
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00039887428283691
(441) DESCRIBE `ports` 0.001812219619751
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00042295455932617
(443) DESCRIBE `ports` 0.0017750263214111
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00035381317138672
(445) DESCRIBE `ports` 0.0017578601837158
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00032711029052734
(447) DESCRIBE `ports` 0.0013680458068848
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00028896331787109
(449) DESCRIBE `ports` 0.001446008682251
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00039196014404297
(451) DESCRIBE `ports` 0.0014119148254395
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00042104721069336
(453) DESCRIBE `ports` 0.0015909671783447
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00042295455932617
(455) DESCRIBE `ports` 0.0016360282897949
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00037407875061035
(457) DESCRIBE `ports` 0.001863956451416
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00041794776916504
(459) DESCRIBE `ports` 0.0019040107727051
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00044703483581543
(461) DESCRIBE `ports` 0.0016410350799561
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00043487548828125
(463) DESCRIBE `ports` 0.0015439987182617
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00041794776916504
(465) DESCRIBE `cruises` 0.0033679008483887
(466) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65945))) 0.00049996376037598
(467) DESCRIBE `avid_specials` 0.0012919902801514
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541775 and class = 'Special') OR (item_id = 65945 and class = 'Cruise') OR (item_id = 520 AND class = 'Ship') OR (item_id = 120 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.0013091564178467
(469) DESCRIBE `cruiselines` 0.0023009777069092
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0003969669342041
(471) DESCRIBE `orchid_image` 0.0018270015716553
(472) DESCRIBE `cruiselines` 0.00205397605896
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0003199577331543
(474) DESCRIBE `specials` 0.0050687789916992
(475) DESCRIBE `specials` 0.0048520565032959
(476) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541844') 0.00055813789367676
(477) DESCRIBE `ships` 0.0037169456481934
(478) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 701))) 0.00056886672973633
(479) DESCRIBE `ships` 0.003525972366333
(480) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0.00048398971557617
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036191940307617
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033783912658691
(483) DESCRIBE `itineraries` 0.0019938945770264
(484) DESCRIBE `ports` 0.002079963684082
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00043511390686035
(486) DESCRIBE `ports` 0.0014688968658447
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00029587745666504
(488) DESCRIBE `ports` 0.0013539791107178
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00042200088500977
(490) DESCRIBE `specialsailingdates` 0.0012130737304688
(491) DESCRIBE `sailingdates` 0.0013468265533447
(492) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518782))) 0.00032711029052734
(493) DESCRIBE `sailingdates` 0.0013720989227295
(494) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518785))) 0.00059795379638672
(495) DESCRIBE `sailingdates` 0.0017950534820557
(496) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518786))) 0.00045204162597656
(497) DESCRIBE `sailingdates` 0.0018429756164551
(498) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518787))) 0.00048184394836426
(499) DESCRIBE `sailingdates` 0.0016019344329834
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518788))) 0.00037384033203125
(501) DESCRIBE `sailingdates` 0.0016381740570068
(502) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518789))) 0.00044083595275879
(503) DESCRIBE `sailingdates` 0.0016520023345947
(504) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518791))) 0.00040984153747559
(505) DESCRIBE `sailingdates` 0.0018281936645508
(506) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518792))) 0.00044393539428711
(507) DESCRIBE `ports` 0.0018930435180664
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00050497055053711
(509) DESCRIBE `ports` 0.0018990039825439
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00041604042053223
(511) DESCRIBE `ports` 0.0018050670623779
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00047802925109863
(513) DESCRIBE `ports` 0.0017659664154053
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00063180923461914
(515) DESCRIBE `ports` 0.0020301342010498
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00057792663574219
(517) DESCRIBE `ports` 0.002094030380249
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00049114227294922
(519) DESCRIBE `ports` 0.0023109912872314
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00051712989807129
(521) DESCRIBE `ports` 0.0021030902862549
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00058603286743164
(523) DESCRIBE `ports` 0.0021660327911377
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.0005640983581543
(525) DESCRIBE `ports` 0.0024631023406982
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.0013599395751953
(527) DESCRIBE `ports` 0.0024659633636475
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00045990943908691
(529) DESCRIBE `ports` 0.0022671222686768
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00069284439086914
(531) DESCRIBE `ports` 0.0024712085723877
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00052213668823242
(533) DESCRIBE `ports` 0.0019729137420654
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00046300888061523
(535) DESCRIBE `ports` 0.0017268657684326
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0005190372467041
(537) DESCRIBE `ports` 0.0016350746154785
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00046896934509277
(539) DESCRIBE `cruises` 0.0034580230712891
(540) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 49093))) 0.00071001052856445
(541) DESCRIBE `avid_specials` 0.0015401840209961
(542) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541844 and class = 'Special') OR (item_id = 49093 and class = 'Cruise') OR (item_id = 701 AND class = 'Ship') OR (item_id = 120 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.0018110275268555
(543) DESCRIBE `cruiselines` 0.0030968189239502
(544) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0005028247833252
(545) DESCRIBE `orchid_image` 0.0018918514251709
(546) DESCRIBE `cruiselines` 0.0024130344390869
(547) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00055098533630371
(548) DESCRIBE `specials` 0.0061049461364746
(549) DESCRIBE `specials` 0.0061900615692139
(550) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541854') 0.0005950927734375
(551) DESCRIBE `ships` 0.0045499801635742
(552) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 701))) 0.00071001052856445
(553) DESCRIBE `ships` 0.0038740634918213
(554) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0.00045514106750488
(555) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031900405883789
(556) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(557) DESCRIBE `itineraries` 0.001655101776123
(558) DESCRIBE `ports` 0.0017850399017334
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00054001808166504
(560) DESCRIBE `ports` 0.0018138885498047
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00052189826965332
(562) DESCRIBE `ports` 0.0020577907562256
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00065183639526367
(564) DESCRIBE `specialsailingdates` 0.0016720294952393
(565) DESCRIBE `sailingdates` 0.0014820098876953
(566) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518818))) 0.00036406517028809
(567) DESCRIBE `sailingdates` 0.001478910446167
(568) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518819))) 0.00041389465332031
(569) DESCRIBE `sailingdates` 0.0014870166778564
(570) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518820))) 0.00034403800964355
(571) DESCRIBE `sailingdates` 0.0011429786682129
(572) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518821))) 0.00028610229492188
(573) DESCRIBE `sailingdates` 0.0012679100036621
(574) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518822))) 0.00030112266540527
(575) DESCRIBE `sailingdates` 0.0011439323425293
(576) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518823))) 0.00034117698669434
(577) DESCRIBE `sailingdates` 0.0012459754943848
(578) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518825))) 0.00030398368835449
(579) DESCRIBE `sailingdates` 0.0014090538024902
(580) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518826))) 0.00028705596923828
(581) DESCRIBE `ports` 0.001410961151123
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0003819465637207
(583) DESCRIBE `ports` 0.0014469623565674
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00036311149597168
(585) DESCRIBE `ports` 0.0013489723205566
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00038504600524902
(587) DESCRIBE `ports` 0.0015208721160889
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00034594535827637
(589) DESCRIBE `ports` 0.0019941329956055
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00042915344238281
(591) DESCRIBE `ports` 0.0016942024230957
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00037503242492676
(593) DESCRIBE `ports` 0.0015599727630615
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00029397010803223
(595) DESCRIBE `ports` 0.001291036605835
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00028204917907715
(597) DESCRIBE `ports` 0.00130295753479
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00031518936157227
(599) DESCRIBE `ports` 0.0013082027435303
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00010085105895996
(601) DESCRIBE `ports` 0.0012519359588623
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00030303001403809
(603) DESCRIBE `ports` 0.0013458728790283
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00028681755065918
(605) DESCRIBE `ports` 0.0013160705566406
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00043201446533203
(607) DESCRIBE `ports` 0.0016071796417236
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00039315223693848
(609) DESCRIBE `ports` 0.0020248889923096
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00037789344787598
(611) DESCRIBE `ports` 0.0016841888427734
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00033307075500488
(613) DESCRIBE `ports` 0.001439094543457
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00042986869812012
(615) DESCRIBE `ports` 0.0016841888427734
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00040292739868164
(617) DESCRIBE `cruises` 0.0031099319458008
(618) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 56009))) 0.00057005882263184
(619) DESCRIBE `avid_specials` 0.0015377998352051
(620) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541854 and class = 'Special') OR (item_id = 56009 and class = 'Cruise') OR (item_id = 701 AND class = 'Ship') OR (item_id = 120 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.0013809204101562
(621) DESCRIBE `cruiselines` 0.002126932144165
(622) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00035500526428223
(623) DESCRIBE `orchid_image` 0.0015280246734619
(624) DESCRIBE `cruiselines` 0.0018661022186279
(625) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0003349781036377
(626) DESCRIBE `specials` 0.005579948425293
(627) DESCRIBE `specials` 0.0048940181732178
(628) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541872') 0.00045585632324219
(629) DESCRIBE `ships` 0.0030150413513184
(630) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 627))) 0.00048398971557617
(631) DESCRIBE `ships` 0.003262996673584
(632) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '627') 0.00036907196044922
(633) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028204917907715
(634) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(635) DESCRIBE `itineraries` 0.0016820430755615
(636) DESCRIBE `ports` 0.001863956451416
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00062394142150879
(638) DESCRIBE `ports` 0.0019741058349609
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00044107437133789
(640) DESCRIBE `ports` 0.0016310214996338
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00045084953308105
(642) DESCRIBE `specialsailingdates` 0.001305103302002
(643) DESCRIBE `sailingdates` 0.0013771057128906
(644) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518831))) 0.00045013427734375
(645) DESCRIBE `sailingdates` 0.0013329982757568
(646) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518833))) 0.00056695938110352
(647) DESCRIBE `sailingdates` 0.0022358894348145
(648) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518834))) 0.00047397613525391
(649) DESCRIBE `sailingdates` 0.0015621185302734
(650) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518835))) 0.00037479400634766
(651) DESCRIBE `sailingdates` 0.0015788078308105
(652) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518836))) 0.00043010711669922
(653) DESCRIBE `sailingdates` 0.0013301372528076
(654) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518837))) 0.00042605400085449
(655) DESCRIBE `sailingdates` 0.0015139579772949
(656) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518838))) 0.00041580200195312
(657) DESCRIBE `sailingdates` 0.0014529228210449
(658) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518841))) 0.00032305717468262
(659) DESCRIBE `sailingdates` 0.0013439655303955
(660) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518842))) 0.00037288665771484
(661) DESCRIBE `sailingdates` 0.0013091564178467
(662) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518843))) 0.00038695335388184
(663) DESCRIBE `sailingdates` 0.0016119480133057
(664) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518844))) 0.00039100646972656
(665) DESCRIBE `sailingdates` 0.0013871192932129
(666) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518845))) 0.00029301643371582
(667) DESCRIBE `sailingdates` 0.0011749267578125
(668) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518846))) 0.00029087066650391
(669) DESCRIBE `sailingdates` 0.0015058517456055
(670) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518847))) 0.00042486190795898
(671) DESCRIBE `sailingdates` 0.0016870498657227
(672) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518848))) 0.00040197372436523
(673) DESCRIBE `ports` 0.0019030570983887
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00049805641174316
(675) DESCRIBE `ports` 0.001478910446167
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00044798851013184
(677) DESCRIBE `ports` 0.0014541149139404
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00035309791564941
(679) DESCRIBE `ports` 0.0016589164733887
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00040507316589355
(681) DESCRIBE `ports` 0.0018770694732666
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00054097175598145
(683) DESCRIBE `ports` 0.0019278526306152
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00032901763916016
(685) DESCRIBE `ports` 0.0014770030975342
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.0004889965057373
(687) DESCRIBE `ports` 0.0017170906066895
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.0004570484161377
(689) DESCRIBE `ports` 0.0014111995697021
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00035786628723145
(691) DESCRIBE `ports` 0.0016038417816162
(692) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00032615661621094
(693) DESCRIBE `ports` 0.0017108917236328
(694) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00033712387084961
(695) DESCRIBE `ports` 0.0013840198516846
(696) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00031399726867676
(697) DESCRIBE `ports` 0.0014889240264893
(698) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00031399726867676
(699) DESCRIBE `ports` 0.0012719631195068
(700) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.0002739429473877
(701) DESCRIBE `ports` 0.0013020038604736
(702) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00031495094299316
(703) DESCRIBE `ports` 0.0014970302581787
(704) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00032806396484375
(705) DESCRIBE `ports` 0.0015511512756348
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00031304359436035
(707) DESCRIBE `ports` 0.0014939308166504
(708) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00034499168395996
(709) DESCRIBE `cruises` 0.0032320022583008
(710) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82484))) 0.00056695938110352
(711) DESCRIBE `avid_specials` 0.0015790462493896
(712) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541872 and class = 'Special') OR (item_id = 82484 and class = 'Cruise') OR (item_id = 627 AND class = 'Ship') OR (item_id = 120 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.0011160373687744
(713) DESCRIBE `cruiselines` 0.0025119781494141
(714) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00057721138000488
(715) DESCRIBE `orchid_image` 0.0021829605102539
(716) DESCRIBE `cruiselines` 0.0029079914093018
(717) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00050187110900879
(718) DESCRIBE `specials` 0.0049779415130615
(719) DESCRIBE `specials` 0.0059709548950195
(720) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541534') 0.0006859302520752
(721) DESCRIBE `ships` 0.0034751892089844
(722) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1243))) 0.0010230541229248
(723) DESCRIBE `ships` 0.0043609142303467
(724) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1243') 0.0009300708770752
(725) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037002563476562
(726) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048184394836426
(727) DESCRIBE `itineraries` 0.001615047454834
(728) DESCRIBE `ports` 0.0021500587463379
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00052189826965332
(730) DESCRIBE `ports` 0.0019960403442383
(731) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00047397613525391
(732) DESCRIBE `ports` 0.0019981861114502
(733) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.0004727840423584
(734) DESCRIBE `specialsailingdates` 0.0014681816101074
(735) DESCRIBE `sailingdates` 0.0015919208526611
(736) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518570))) 0.00037908554077148
(737) DESCRIBE `ports` 0.0014569759368896
(738) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00034189224243164
(739) DESCRIBE `ports` 0.0013720989227295
(740) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.0003659725189209
(741) DESCRIBE `ports` 0.0014500617980957
(742) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3613))) 0.00043296813964844
(743) DESCRIBE `ports` 0.0020298957824707
(744) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3613') 0.00045895576477051
(745) DESCRIBE `ports` 0.0015609264373779
(746) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4719))) 0.00036787986755371
(747) DESCRIBE `ports` 0.0016930103302002
(748) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4719') 0.00037693977355957
(749) DESCRIBE `ports` 0.0016670227050781
(750) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4720))) 0.00038385391235352
(751) DESCRIBE `ports` 0.0013611316680908
(752) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4720') 0.00032496452331543
(753) DESCRIBE `ports` 0.0012929439544678
(754) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4721))) 0.00033307075500488
(755) DESCRIBE `ports` 0.001431941986084
(756) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4721') 0.00033283233642578
(757) DESCRIBE `ports` 0.0016529560089111
(758) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4722))) 0.00043511390686035
(759) DESCRIBE `ports` 0.0016191005706787
(760) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4722') 0.00042605400085449
(761) DESCRIBE `ports` 0.0017669200897217
(762) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4724))) 0.00057196617126465
(763) DESCRIBE `ports` 0.0020139217376709
(764) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4724') 0.00048303604125977
(765) DESCRIBE `ports` 0.001446008682251
(766) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4725))) 0.00044798851013184
(767) DESCRIBE `ports` 0.0016341209411621
(768) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4725') 0.00032401084899902
(769) DESCRIBE `ports` 0.0013668537139893
(770) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3620))) 0.00033903121948242
(771) DESCRIBE `ports` 0.0016579627990723
(772) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3620') 0.0002899169921875
(773) DESCRIBE `ports` 0.001812219619751
(774) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5250))) 0.00036382675170898
(775) DESCRIBE `ports` 0.0013060569763184
(776) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5250') 0.0004119873046875
(777) DESCRIBE `ports` 0.0020020008087158
(778) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3623))) 0.00041508674621582
(779) DESCRIBE `ports` 0.0016939640045166
(780) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3623') 0.00046491622924805
(781) DESCRIBE `ports` 0.0014078617095947
(782) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6148))) 0.00035715103149414
(783) DESCRIBE `ports` 0.0015900135040283
(784) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6148') 0.00037312507629395
(785) DESCRIBE `ports` 0.0015220642089844
(786) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6149))) 0.00033307075500488
(787) DESCRIBE `ports` 0.0014297962188721
(788) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6149') 0.00027203559875488
(789) DESCRIBE `ports` 0.0020661354064941
(790) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3778))) 0.00043702125549316
(791) DESCRIBE `ports` 0.0018608570098877
(792) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3778') 0.00039005279541016
(793) DESCRIBE `ports` 0.0018281936645508
(794) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.00045895576477051
(795) DESCRIBE `ports` 0.0014679431915283
(796) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4729') 0.00036501884460449
(797) DESCRIBE `ports` 0.0017411708831787
(798) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.00041818618774414
(799) DESCRIBE `ports` 0.0017340183258057
(800) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4729') 0.00038313865661621
(801) DESCRIBE `ports` 0.0017068386077881
(802) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.0003960132598877
(803) DESCRIBE `ports` 0.0016529560089111
(804) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4729') 0.0003359317779541
(805) DESCRIBE `cruises` 0.0036349296569824
(806) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82464))) 0.00051593780517578
(807) DESCRIBE `avid_specials` 0.0016939640045166
(808) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541534 and class = 'Special') OR (item_id = 82464 and class = 'Cruise') OR (item_id = 1243 AND class = 'Ship') OR (item_id = 120 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.0010509490966797
(809) DESCRIBE `cruiselines` 0.0021560192108154
(810) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00040388107299805
(811) DESCRIBE `orchid_image` 0.0019228458404541
(812) DESCRIBE `cruiselines` 0.0022730827331543
(813) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00037193298339844
(814) DESCRIBE `specials` 0.0042660236358643
(815) DESCRIBE `specials` 0.0046179294586182
(816) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541863') 0.00056195259094238
(817) DESCRIBE `ships` 0.0029599666595459
(818) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 627))) 0.00042390823364258
(819) DESCRIBE `ships` 0.0030319690704346
(820) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '627') 0.00038719177246094
(821) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002739429473877
(822) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028204917907715
(823) DESCRIBE `itineraries` 0.0017309188842773
(824) DESCRIBE `ports` 0.0015151500701904
(825) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00041413307189941
(826) DESCRIBE `ports` 0.0013201236724854
(827) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00032496452331543
(828) DESCRIBE `ports` 0.0012998580932617
(829) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00028085708618164
(830) DESCRIBE `specialsailingdates` 0.0012350082397461
(831) DESCRIBE `sailingdates` 0.0014798641204834
(832) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518796))) 0.00037002563476562
(833) DESCRIBE `sailingdates` 0.0013868808746338
(834) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518797))) 0.00069689750671387
(835) DESCRIBE `sailingdates` 0.0017321109771729
(836) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518798))) 0.00044989585876465
(837) DESCRIBE `sailingdates` 0.0016469955444336
(838) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518799))) 0.00040292739868164
(839) DESCRIBE `sailingdates` 0.0016319751739502
(840) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518800))) 0.00060009956359863
(841) DESCRIBE `sailingdates` 0.0017049312591553
(842) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518801))) 0.00038003921508789
(843) DESCRIBE `sailingdates` 0.0014450550079346
(844) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518802))) 0.00040698051452637
(845) DESCRIBE `sailingdates` 0.0013060569763184
(846) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518803))) 0.00027203559875488
(847) DESCRIBE `sailingdates` 0.0013868808746338
(848) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518804))) 0.00031113624572754
(849) DESCRIBE `sailingdates` 0.0015869140625
(850) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518806))) 0.00033807754516602
(851) DESCRIBE `sailingdates` 0.0012869834899902
(852) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518807))) 0.00027704238891602
(853) DESCRIBE `sailingdates` 0.0014948844909668
(854) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518808))) 0.0003049373626709
(855) DESCRIBE `sailingdates` 0.0011589527130127
(856) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518809))) 0.00032615661621094
(857) DESCRIBE `sailingdates` 0.0011508464813232
(858) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518810))) 0.00027108192443848
(859) DESCRIBE `sailingdates` 0.0011510848999023
(860) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518811))) 0.00034213066101074
(861) DESCRIBE `sailingdates` 0.0012431144714355
(862) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518812))) 0.00043988227844238
(863) DESCRIBE `sailingdates` 0.0012588500976562
(864) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518813))) 9.608268737793E-5
(865) DESCRIBE `sailingdates` 0.001230001449585
(866) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518814))) 0.00030994415283203
(867) DESCRIBE `ports` 0.0014350414276123
(868) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00037789344787598
(869) DESCRIBE `ports` 0.0018010139465332
(870) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00032401084899902
(871) DESCRIBE `ports` 0.0014681816101074
(872) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.0003509521484375
(873) DESCRIBE `ports` 0.0012471675872803
(874) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00028491020202637
(875) DESCRIBE `ports` 0.001460075378418
(876) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00030279159545898
(877) DESCRIBE `ports` 0.0013060569763184
(878) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00081586837768555
(879) DESCRIBE `ports` 0.0014669895172119
(880) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00052809715270996
(881) DESCRIBE `ports` 0.0019779205322266
(882) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00048398971557617
(883) DESCRIBE `ports` 0.0020639896392822
(884) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00042104721069336
(885) DESCRIBE `ports` 0.0018398761749268
(886) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00039410591125488
(887) DESCRIBE `ports` 0.0017850399017334
(888) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00037407875061035
(889) DESCRIBE `ports` 0.0014419555664062
(890) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00041007995605469
(891) DESCRIBE `ports` 0.0013599395751953
(892) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00031208992004395
(893) DESCRIBE `ports` 0.0013329982757568
(894) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00061416625976562
(895) DESCRIBE `ports` 0.0020511150360107
(896) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00056290626525879
(897) DESCRIBE `ports` 0.0018799304962158
(898) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00052595138549805
(899) DESCRIBE `cruises` 0.0037829875946045
(900) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82483))) 0.00075101852416992
(901) DESCRIBE `avid_specials` 0.0017199516296387
(902) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541863 and class = 'Special') OR (item_id = 82483 and class = 'Cruise') OR (item_id = 627 AND class = 'Ship') OR (item_id = 120 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.0011129379272461
(903) DESCRIBE `cruiselines` 0.0021829605102539
(904) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00039505958557129
(905) DESCRIBE `orchid_image` 0.0017719268798828
(906) DESCRIBE `cruiselines` 0.002284049987793
(907) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00038814544677734
(908) DESCRIBE `ships` 0.0034878253936768
(909) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '627', '701', '1243')) ORDER BY FIND_IN_SET(id, '521,520,627,701,1243') 0.00090312957763672
(910) DESCRIBE `cruisetypes` 0.0013329982757568
(911) DESCRIBE `destinations` 0.0018341541290283
(912) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '56')) ORDER BY FIND_IN_SET(id, '54,56') 0.00053310394287109
(913) DESCRIBE `cruiselines` 0.0022480487823486
(914) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00040197372436523
(915) DESCRIBE `cruiselines` 0.0022988319396973
(916) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0004429817199707