or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Total elapsed time: 1.2690451145172

# Query Time
(1) connect 0.0010709762573242
(2) DESCRIBE `cruises` 0.0054140090942383
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76701, 79319, 76624, 76857, 79318, 57063, 57063, 76623, 76856, 76562)) ORDER BY FIND_IN_SET(id, '76701,79319,76624,76857,79318,57063,57063,76623,76856,76562') 0.0042259693145752
(4) DESCRIBE `cruises` 0.0060570240020752
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76701') 0.00071001052856445
(6) DESCRIBE `ships` 0.0059080123901367
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84))) 0.00089502334594727
(8) DESCRIBE `ships` 0.0058200359344482
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '84') 0.00080585479736328
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054502487182617
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052881240844727
(12) DESCRIBE `itineraries` 0.002953052520752
(13) DESCRIBE `ports` 0.0034010410308838
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00063204765319824
(15) DESCRIBE `ports` 0.0025520324707031
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00045204162597656
(17) DESCRIBE `ports` 0.0028371810913086
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00060009956359863
(19) DESCRIBE `sailingdates` 0.0025241374969482
(20) DESCRIBE `ports` 0.0028619766235352
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00045394897460938
(22) DESCRIBE `ports` 0.0019810199737549
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00038790702819824
(24) DESCRIBE `ports` 0.0019090175628662
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00075793266296387
(26) DESCRIBE `ports` 0.0026710033416748
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00057601928710938
(28) DESCRIBE `ports` 0.0027058124542236
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00060296058654785
(30) DESCRIBE `ports` 0.0027511119842529
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00057816505432129
(32) DESCRIBE `ports` 0.0029540061950684
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00050687789916992
(34) DESCRIBE `ports` 0.0019631385803223
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.0004580020904541
(36) DESCRIBE `ports` 0.002249002456665
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00046992301940918
(38) DESCRIBE `ports` 0.0023980140686035
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00043988227844238
(40) DESCRIBE `ports` 0.0028378963470459
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00084304809570312
(42) DESCRIBE `ports` 0.0032930374145508
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00066304206848145
(44) DESCRIBE `ports` 0.0026719570159912
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0005650520324707
(46) DESCRIBE `ports` 0.0020589828491211
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0006561279296875
(48) DESCRIBE `ports` 0.002763032913208
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0006411075592041
(50) DESCRIBE `ports` 0.0024919509887695
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00053596496582031
(52) DESCRIBE `ports` 0.002532958984375
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00065517425537109
(54) DESCRIBE `ports` 0.0027351379394531
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0005638599395752
(56) DESCRIBE `ports` 0.003046989440918
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00069117546081543
(58) DESCRIBE `ports` 0.0027110576629639
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00073409080505371
(60) DESCRIBE `ports` 0.003281831741333
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00075006484985352
(62) DESCRIBE `ports` 0.0030159950256348
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00069308280944824
(64) DESCRIBE `ports` 0.0028080940246582
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0007328987121582
(66) DESCRIBE `ports` 0.0027151107788086
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00063490867614746
(68) DESCRIBE `ports` 0.0029709339141846
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00067591667175293
(70) DESCRIBE `ports` 0.0019149780273438
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.0004420280456543
(72) DESCRIBE `ports` 0.0018370151519775
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00044393539428711
(74) DESCRIBE `ports` 0.0018820762634277
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00047206878662109
(76) DESCRIBE `ports` 0.0019030570983887
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495))) 0.0004580020904541
(78) DESCRIBE `ports` 0.002094030380249
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1495') 0.0003960132598877
(80) DESCRIBE `ports` 0.0019099712371826
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3264))) 0.00040698051452637
(82) DESCRIBE `ports` 0.00211501121521
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3264') 0.00047206878662109
(84) DESCRIBE `ports` 0.002932071685791
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00073099136352539
(86) DESCRIBE `ports` 0.0024659633636475
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00055098533630371
(88) DESCRIBE `ports` 0.0028600692749023
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 325))) 0.00061798095703125
(90) DESCRIBE `ports` 0.0024459362030029
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '325') 0.0005500316619873
(92) DESCRIBE `ports` 0.0022170543670654
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 882))) 0.00057291984558105
(94) DESCRIBE `ports` 0.0023880004882812
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '882') 0.00040602684020996
(96) DESCRIBE `ports` 0.0020098686218262
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00056982040405273
(98) DESCRIBE `ports` 0.0025119781494141
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00041294097900391
(100) DESCRIBE `ports` 0.0020670890808105
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00044608116149902
(102) DESCRIBE `ports` 0.0022890567779541
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00065183639526367
(104) DESCRIBE `avid_specials` 0.0018429756164551
(105) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76701 and class = 'Cruise') OR (item_id = 84 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013830661773682
(106) DESCRIBE `cruiselines` 0.0038180351257324
(107) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00074315071105957
(108) DESCRIBE `orchid_image` 0.0026898384094238
(109) DESCRIBE `cruiselines` 0.0029950141906738
(110) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00047492980957031
(111) DESCRIBE `cruises` 0.004086971282959
(112) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79319') 0.00056099891662598
(113) DESCRIBE `ships` 0.0048990249633789
(114) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 401))) 0.00055599212646484
(115) DESCRIBE `ships` 0.0038890838623047
(116) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '401') 0.00060486793518066
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049304962158203
(118) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041699409484863
(119) DESCRIBE `itineraries` 0.0024080276489258
(120) DESCRIBE `ports` 0.0023641586303711
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00055098533630371
(122) DESCRIBE `ports` 0.002406120300293
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00059795379638672
(124) DESCRIBE `ports` 0.0022249221801758
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00059795379638672
(126) DESCRIBE `sailingdates` 0.0024189949035645
(127) DESCRIBE `ports` 0.0027780532836914
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00077581405639648
(129) DESCRIBE `ports` 0.0025930404663086
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00054407119750977
(131) DESCRIBE `ports` 0.0020918846130371
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00066804885864258
(133) DESCRIBE `ports` 0.0024070739746094
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00060009956359863
(135) DESCRIBE `ports` 0.0027840137481689
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.00054311752319336
(137) DESCRIBE `ports` 0.002079963684082
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00052404403686523
(139) DESCRIBE `ports` 0.0021100044250488
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00057411193847656
(141) DESCRIBE `ports` 0.002655029296875
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00051188468933105
(143) DESCRIBE `ports` 0.0023441314697266
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00053906440734863
(145) DESCRIBE `ports` 0.0022118091583252
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.00060319900512695
(147) DESCRIBE `ports` 0.0028281211853027
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 188))) 0.00052094459533691
(149) DESCRIBE `ports` 0.0026671886444092
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '188') 0.00045895576477051
(151) DESCRIBE `ports` 0.0025570392608643
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00066018104553223
(153) DESCRIBE `ports` 0.0027649402618408
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00062417984008789
(155) DESCRIBE `ports` 0.0024371147155762
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00045013427734375
(157) DESCRIBE `ports` 0.0026941299438477
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.0006098747253418
(159) DESCRIBE `ports` 0.0024690628051758
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5290))) 0.0004270076751709
(161) DESCRIBE `ports` 0.0020279884338379
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5290') 0.00039505958557129
(163) DESCRIBE `ports` 0.0019121170043945
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00041007995605469
(165) DESCRIBE `ports` 0.0018739700317383
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00050711631774902
(167) DESCRIBE `ports` 0.0018460750579834
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00054097175598145
(169) DESCRIBE `ports` 0.0019431114196777
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00037312507629395
(171) DESCRIBE `ports` 0.0021538734436035
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1429))) 0.00041389465332031
(173) DESCRIBE `ports` 0.0021529197692871
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1429') 0.00050878524780273
(175) DESCRIBE `ports` 0.0021519660949707
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00043082237243652
(177) DESCRIBE `ports` 0.002100944519043
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00056314468383789
(179) DESCRIBE `ports` 0.0025160312652588
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00052618980407715
(181) DESCRIBE `ports` 0.0025150775909424
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00059890747070312
(183) DESCRIBE `ports` 0.0028378963470459
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 795))) 0.00062680244445801
(185) DESCRIBE `ports` 0.0027740001678467
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '795') 0.00059795379638672
(187) DESCRIBE `ports` 0.0021529197692871
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5290))) 0.00042986869812012
(189) DESCRIBE `ports` 0.0018091201782227
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5290') 0.0003969669342041
(191) DESCRIBE `ports` 0.0017879009246826
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00051307678222656
(193) DESCRIBE `ports` 0.0024840831756592
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00058412551879883
(195) DESCRIBE `ports` 0.0026731491088867
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1253))) 0.00061607360839844
(197) DESCRIBE `ports` 0.0023198127746582
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1253') 0.00046801567077637
(199) DESCRIBE `ports` 0.0021250247955322
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00050187110900879
(201) DESCRIBE `ports` 0.0022740364074707
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00048398971557617
(203) DESCRIBE `ports` 0.0024399757385254
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00062108039855957
(205) DESCRIBE `ports` 0.0024659633636475
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00043082237243652
(207) DESCRIBE `avid_specials` 0.0017030239105225
(208) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79319 and class = 'Cruise') OR (item_id = 401 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013542175292969
(209) DESCRIBE `cruiselines` 0.0029771327972412
(210) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00049805641174316
(211) DESCRIBE `orchid_image` 0.002140998840332
(212) DESCRIBE `cruiselines` 0.0030448436737061
(213) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00056695938110352
(214) DESCRIBE `cruises` 0.003870964050293
(215) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76624') 0.0005640983581543
(216) DESCRIBE `ships` 0.0038409233093262
(217) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00078797340393066
(218) DESCRIBE `ships` 0.0043540000915527
(219) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00057601928710938
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004270076751709
(221) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040912628173828
(222) DESCRIBE `itineraries` 0.0024831295013428
(223) DESCRIBE `ports` 0.0030820369720459
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00056695938110352
(225) DESCRIBE `ports` 0.0030999183654785
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00076413154602051
(227) DESCRIBE `ports` 0.002892017364502
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00064802169799805
(229) DESCRIBE `sailingdates` 0.0025718212127686
(230) DESCRIBE `ports` 0.0029239654541016
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00067591667175293
(232) DESCRIBE `ports` 0.0028970241546631
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00067901611328125
(234) DESCRIBE `ports` 0.0027999877929688
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00076198577880859
(236) DESCRIBE `ports` 0.0029029846191406
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00061607360839844
(238) DESCRIBE `ports` 0.0028719902038574
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.000701904296875
(240) DESCRIBE `ports` 0.0030021667480469
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00065183639526367
(242) DESCRIBE `ports` 0.0027868747711182
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00063300132751465
(244) DESCRIBE `ports` 0.0028049945831299
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00063991546630859
(246) DESCRIBE `ports` 0.0028901100158691
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00069689750671387
(248) DESCRIBE `ports` 0.0030720233917236
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00066590309143066
(250) DESCRIBE `ports` 0.0028660297393799
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0007779598236084
(252) DESCRIBE `ports` 0.0029079914093018
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00064396858215332
(254) DESCRIBE `ports` 0.0030651092529297
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00086498260498047
(256) DESCRIBE `ports` 0.0029540061950684
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00075817108154297
(258) DESCRIBE `ports` 0.00288987159729
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00071406364440918
(260) DESCRIBE `ports` 0.0029640197753906
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00069904327392578
(262) DESCRIBE `ports` 0.0030710697174072
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00073885917663574
(264) DESCRIBE `ports` 0.0029299259185791
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00065207481384277
(266) DESCRIBE `ports` 0.0030369758605957
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00070095062255859
(268) DESCRIBE `ports` 0.0027949810028076
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00051403045654297
(270) DESCRIBE `ports` 0.0022192001342773
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00058817863464355
(272) DESCRIBE `ports` 0.0022149085998535
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00055599212646484
(274) DESCRIBE `avid_specials` 0.0018620491027832
(275) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76624 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 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.0017011165618896
(276) DESCRIBE `cruiselines` 0.0035429000854492
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00091099739074707
(278) DESCRIBE `orchid_image` 0.0034050941467285
(279) DESCRIBE `cruiselines` 0.0042288303375244
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00053000450134277
(281) DESCRIBE `cruises` 0.004755973815918
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76857') 0.00066208839416504
(283) DESCRIBE `ships` 0.0054090023040771
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00064802169799805
(285) DESCRIBE `ships` 0.0052168369293213
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.00063300132751465
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005028247833252
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00056695938110352
(289) DESCRIBE `itineraries` 0.0019819736480713
(290) DESCRIBE `ports` 0.0025749206542969
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00072693824768066
(292) DESCRIBE `ports` 0.0026669502258301
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00063300132751465
(294) DESCRIBE `ports` 0.0025508403778076
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00062108039855957
(296) DESCRIBE `sailingdates` 0.0022940635681152
(297) DESCRIBE `ports` 0.0029988288879395
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0006718635559082
(299) DESCRIBE `ports` 0.0026099681854248
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00057411193847656
(301) DESCRIBE `ports` 0.0025770664215088
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00065302848815918
(303) DESCRIBE `ports` 0.0027270317077637
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00052499771118164
(305) DESCRIBE `ports` 0.0019528865814209
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00041413307189941
(307) DESCRIBE `ports` 0.0020678043365479
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00052404403686523
(309) DESCRIBE `ports` 0.0026781558990479
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00058698654174805
(311) DESCRIBE `ports` 0.0025639533996582
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00056099891662598
(313) DESCRIBE `ports` 0.0024349689483643
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00045013427734375
(315) DESCRIBE `ports` 0.0024499893188477
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00053000450134277
(317) DESCRIBE `ports` 0.0023109912872314
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0006251335144043
(319) DESCRIBE `ports` 0.0026578903198242
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00046610832214355
(321) DESCRIBE `ports` 0.0023360252380371
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00053310394287109
(323) DESCRIBE `ports` 0.0023620128631592
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.0005640983581543
(325) DESCRIBE `ports` 0.0030059814453125
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00065779685974121
(327) DESCRIBE `ports` 0.0026271343231201
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00067400932312012
(329) DESCRIBE `ports` 0.0025308132171631
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0006859302520752
(331) DESCRIBE `ports` 0.0025620460510254
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00062298774719238
(333) DESCRIBE `ports` 0.0024950504302979
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00061607360839844
(335) DESCRIBE `ports` 0.0023849010467529
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00043892860412598
(337) DESCRIBE `ports` 0.0018429756164551
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00048589706420898
(339) DESCRIBE `ports` 0.0019149780273438
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043606758117676
(341) DESCRIBE `avid_specials` 0.0018918514251709
(342) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76857 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 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.0013508796691895
(343) DESCRIBE `cruiselines` 0.0027999877929688
(344) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00060701370239258
(345) DESCRIBE `orchid_image` 0.0027511119842529
(346) DESCRIBE `cruiselines` 0.0027410984039307
(347) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0004889965057373
(348) DESCRIBE `cruises` 0.0039839744567871
(349) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79318') 0.00057601928710938
(350) DESCRIBE `ships` 0.0052070617675781
(351) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 401))) 0.00087094306945801
(352) DESCRIBE `ships` 0.0053231716156006
(353) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '401') 0.00062108039855957
(354) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039887428283691
(355) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(356) DESCRIBE `itineraries` 0.0018179416656494
(357) DESCRIBE `ports` 0.0020830631256104
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00046801567077637
(359) DESCRIBE `ports` 0.0019371509552002
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00089287757873535
(361) DESCRIBE `ports` 0.002932071685791
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00057005882263184
(363) DESCRIBE `sailingdates` 0.0018720626831055
(364) DESCRIBE `ports` 0.0020210742950439
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00053906440734863
(366) DESCRIBE `ports` 0.0020091533660889
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0005338191986084
(368) DESCRIBE `ports` 0.002190113067627
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00066590309143066
(370) DESCRIBE `ports` 0.0025949478149414
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00060606002807617
(372) DESCRIBE `ports` 0.0025951862335205
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.00064802169799805
(374) DESCRIBE `ports` 0.0023198127746582
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00059700012207031
(376) DESCRIBE `ports` 0.0022211074829102
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.0004889965057373
(378) DESCRIBE `ports` 0.0020239353179932
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00055289268493652
(380) DESCRIBE `ports` 0.0019099712371826
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00064492225646973
(382) DESCRIBE `ports` 0.0028769969940186
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.0007481575012207
(384) DESCRIBE `ports` 0.0030250549316406
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 188))) 0.00071001052856445
(386) DESCRIBE `ports` 0.0026271343231201
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '188') 0.00058293342590332
(388) DESCRIBE `ports` 0.002244234085083
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00073599815368652
(390) DESCRIBE `ports` 0.0028648376464844
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00078320503234863
(392) DESCRIBE `ports` 0.0030109882354736
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00072789192199707
(394) DESCRIBE `ports` 0.0028951168060303
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00064492225646973
(396) DESCRIBE `ports` 0.0028769969940186
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5290))) 0.00071501731872559
(398) DESCRIBE `ports` 0.0029201507568359
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5290') 0.00084710121154785
(400) DESCRIBE `ports` 0.0030651092529297
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00069379806518555
(402) DESCRIBE `ports` 0.0028491020202637
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00056004524230957
(404) DESCRIBE `avid_specials` 0.0021369457244873
(405) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79318 and class = 'Cruise') OR (item_id = 401 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0025241374969482
(406) DESCRIBE `cruiselines` 0.0043389797210693
(407) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00085306167602539
(408) DESCRIBE `orchid_image` 0.0035920143127441
(409) DESCRIBE `cruiselines` 0.0033979415893555
(410) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00048184394836426
(411) DESCRIBE `specials` 0.0058560371398926
(412) DESCRIBE `specials` 0.0060927867889404
(413) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1626445') 0.00049209594726562
(414) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id != '1626445') 0.001230001449585
(415) UPDATE `specials` SET `orchid_slug` = ? WHERE (id = '1626445') 0.00039386749267578
(416) DESCRIBE `ships` 0.0048911571502686
(417) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00086712837219238
(418) DESCRIBE `ships` 0.0055410861968994
(419) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00074005126953125
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00063395500183105
(421) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00055909156799316
(422) DESCRIBE `itineraries` 0.0029971599578857
(423) DESCRIBE `ports` 0.0025448799133301
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056290626525879
(425) DESCRIBE `ports` 0.0018959045410156
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00074601173400879
(427) DESCRIBE `ports` 0.0029821395874023
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00066685676574707
(429) DESCRIBE `specialsailingdates` 0.0026161670684814
(430) DESCRIBE `sailingdates` 0.0026819705963135
(431) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 480654))) 0.00068092346191406
(432) DESCRIBE `ports` 0.003065824508667
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072097778320312
(434) DESCRIBE `ports` 0.0026798248291016
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061511993408203
(436) DESCRIBE `ports` 0.0028209686279297
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00083088874816895
(438) DESCRIBE `ports` 0.0031218528747559
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00074100494384766
(440) DESCRIBE `ports` 0.0029442310333252
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0007169246673584
(442) DESCRIBE `ports` 0.0021381378173828
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00046110153198242
(444) DESCRIBE `ports` 0.0022299289703369
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0006110668182373
(446) DESCRIBE `ports` 0.0018579959869385
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.0006568431854248
(448) DESCRIBE `ports` 0.0018579959869385
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00045609474182129
(450) DESCRIBE `ports` 0.0020368099212646
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00051784515380859
(452) DESCRIBE `ports` 0.0019619464874268
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00042510032653809
(454) DESCRIBE `ports` 0.0018458366394043
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00041103363037109
(456) DESCRIBE `ports` 0.0018010139465332
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00046801567077637
(458) DESCRIBE `ports` 0.0024080276489258
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00069403648376465
(460) DESCRIBE `ports` 0.0028331279754639
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00075316429138184
(462) DESCRIBE `ports` 0.0024628639221191
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00044703483581543
(464) DESCRIBE `ports` 0.0018689632415771
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00047898292541504
(466) DESCRIBE `ports` 0.0017831325531006
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00041913986206055
(468) DESCRIBE `ports` 0.0018720626831055
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00058507919311523
(470) DESCRIBE `ports` 0.0025990009307861
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00055694580078125
(472) DESCRIBE `ports` 0.0024640560150146
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2757))) 0.00062799453735352
(474) DESCRIBE `ports` 0.0020751953125
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2757') 0.00041794776916504
(476) DESCRIBE `ports` 0.0021049976348877
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050997734069824
(478) DESCRIBE `ports` 0.002208948135376
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00052690505981445
(480) DESCRIBE `ports` 0.0021951198577881
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00062298774719238
(482) DESCRIBE `ports` 0.0024070739746094
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00057816505432129
(484) DESCRIBE `cruises` 0.0037169456481934
(485) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57063))) 0.00058197975158691
(486) DESCRIBE `avid_specials` 0.001784086227417
(487) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1626445 and class = 'Special') OR (item_id = 57063 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012059211730957
(488) DESCRIBE `cruiselines` 0.0031778812408447
(489) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00066709518432617
(490) DESCRIBE `orchid_image` 0.0026009082794189
(491) DESCRIBE `cruiselines` 0.0034289360046387
(492) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00055599212646484
(493) DESCRIBE `cruises` 0.0045690536499023
(494) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57063') 0.00059199333190918
(495) DESCRIBE `ships` 0.0048110485076904
(496) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00081706047058105
(497) DESCRIBE `ships` 0.0049979686737061
(498) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00069403648376465
(499) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051999092102051
(500) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053596496582031
(501) DESCRIBE `itineraries` 0.0027329921722412
(502) DESCRIBE `ports` 0.002875804901123
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0007479190826416
(504) DESCRIBE `ports` 0.0027010440826416
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00080013275146484
(506) DESCRIBE `ports` 0.0027480125427246
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00062799453735352
(508) DESCRIBE `sailingdates` 0.0024991035461426
(509) DESCRIBE `ports` 0.0030360221862793
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072216987609863
(511) DESCRIBE `ports` 0.0026900768280029
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00085091590881348
(513) DESCRIBE `ports` 0.0026090145111084
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00069713592529297
(515) DESCRIBE `ports` 0.0026288032531738
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00057792663574219
(517) DESCRIBE `ports` 0.0026860237121582
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0006258487701416
(519) DESCRIBE `ports` 0.0027141571044922
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00058484077453613
(521) DESCRIBE `ports` 0.0027189254760742
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0006709098815918
(523) DESCRIBE `ports` 0.0027658939361572
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00065708160400391
(525) DESCRIBE `ports` 0.0026929378509521
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00067782402038574
(527) DESCRIBE `ports` 0.0027060508728027
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00059294700622559
(529) DESCRIBE `ports` 0.0028030872344971
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00066494941711426
(531) DESCRIBE `ports` 0.0027639865875244
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00067901611328125
(533) DESCRIBE `ports` 0.0028040409088135
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00048089027404785
(535) DESCRIBE `ports` 0.0021848678588867
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0007021427154541
(537) DESCRIBE `ports` 0.0029199123382568
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00098109245300293
(539) DESCRIBE `ports` 0.0029599666595459
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00056886672973633
(541) DESCRIBE `ports` 0.0028829574584961
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00058794021606445
(543) DESCRIBE `ports` 0.0025410652160645
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00055980682373047
(545) DESCRIBE `ports` 0.002079963684082
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0004889965057373
(547) DESCRIBE `ports` 0.0021748542785645
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00048422813415527
(549) DESCRIBE `ports` 0.0018930435180664
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2757))) 0.00078606605529785
(551) DESCRIBE `ports` 0.0032429695129395
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2757') 0.00052690505981445
(553) DESCRIBE `ports` 0.00205397605896
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00058102607727051
(555) DESCRIBE `ports` 0.0032060146331787
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00077509880065918
(557) DESCRIBE `ports` 0.0031750202178955
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00077199935913086
(559) DESCRIBE `ports` 0.0031170845031738
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00049495697021484
(561) DESCRIBE `avid_specials` 0.0021519660949707
(562) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57063 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017740726470947
(563) DESCRIBE `cruiselines` 0.0035779476165771
(564) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00067591667175293
(565) DESCRIBE `orchid_image` 0.002849817276001
(566) DESCRIBE `cruiselines` 0.0035381317138672
(567) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0012850761413574
(568) DESCRIBE `cruises` 0.0045740604400635
(569) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76623') 0.001007080078125
(570) DESCRIBE `ships` 0.0055561065673828
(571) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00079083442687988
(572) DESCRIBE `ships` 0.0054051876068115
(573) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00075793266296387
(574) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005958080291748
(575) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038504600524902
(576) DESCRIBE `itineraries` 0.0025379657745361
(577) DESCRIBE `ports` 0.0021200180053711
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00048208236694336
(579) DESCRIBE `ports` 0.0021359920501709
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00052881240844727
(581) DESCRIBE `ports` 0.0019509792327881
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00067400932312012
(583) DESCRIBE `sailingdates` 0.0028839111328125
(584) DESCRIBE `ports` 0.0033481121063232
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00082302093505859
(586) DESCRIBE `ports` 0.003154993057251
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00069999694824219
(588) DESCRIBE `ports` 0.0032730102539062
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00074577331542969
(590) DESCRIBE `ports` 0.0030629634857178
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00071406364440918
(592) DESCRIBE `ports` 0.0031049251556396
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00075912475585938
(594) DESCRIBE `ports` 0.003054141998291
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00076508522033691
(596) DESCRIBE `ports` 0.0029890537261963
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00075316429138184
(598) DESCRIBE `ports` 0.0029020309448242
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00067591667175293
(600) DESCRIBE `ports` 0.0024130344390869
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00056815147399902
(602) DESCRIBE `ports` 0.0024638175964355
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00054717063903809
(604) DESCRIBE `ports` 0.0025660991668701
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00062108039855957
(606) DESCRIBE `ports` 0.0024769306182861
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00065493583679199
(608) DESCRIBE `avid_specials` 0.002202033996582
(609) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76623 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 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.001986026763916
(610) DESCRIBE `cruiselines` 0.0035240650177002
(611) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00071811676025391
(612) DESCRIBE `orchid_image` 0.0028691291809082
(613) DESCRIBE `cruiselines` 0.0040078163146973
(614) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00075006484985352
(615) DESCRIBE `cruises` 0.0047857761383057
(616) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76856') 0.00063896179199219
(617) DESCRIBE `ships` 0.0049309730529785
(618) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00071001052856445
(619) DESCRIBE `ships` 0.0049419403076172
(620) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.00061321258544922
(621) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047206878662109
(622) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049018859863281
(623) DESCRIBE `itineraries` 0.0025601387023926
(624) DESCRIBE `ports` 0.0024659633636475
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00062417984008789
(626) DESCRIBE `ports` 0.0024921894073486
(627) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00059390068054199
(628) DESCRIBE `ports` 0.0025410652160645
(629) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00055503845214844
(630) DESCRIBE `sailingdates` 0.0023059844970703
(631) DESCRIBE `ports` 0.0026090145111084
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00062298774719238
(633) DESCRIBE `ports` 0.0025589466094971
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00055599212646484
(635) DESCRIBE `ports` 0.0025260448455811
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00060105323791504
(637) DESCRIBE `ports` 0.0026140213012695
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00062084197998047
(639) DESCRIBE `ports` 0.0027279853820801
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00065898895263672
(641) DESCRIBE `ports` 0.0029020309448242
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.0006098747253418
(643) DESCRIBE `ports` 0.0028600692749023
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00068497657775879
(645) DESCRIBE `ports` 0.002863883972168
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00076198577880859
(647) DESCRIBE `ports` 0.0028808116912842
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00076103210449219
(649) DESCRIBE `ports` 0.0029420852661133
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00064802169799805
(651) DESCRIBE `ports` 0.0031688213348389
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00095701217651367
(653) DESCRIBE `ports` 0.0032088756561279
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00056695938110352
(655) DESCRIBE `avid_specials` 0.0022552013397217
(656) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76856 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 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.0015571117401123
(657) DESCRIBE `cruiselines` 0.0034301280975342
(658) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00081896781921387
(659) DESCRIBE `orchid_image` 0.0034289360046387
(660) DESCRIBE `cruiselines` 0.0041530132293701
(661) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00064611434936523
(662) DESCRIBE `cruises` 0.0048868656158447
(663) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76562') 0.00055885314941406
(664) DESCRIBE `ships` 0.0042791366577148
(665) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1302))) 0.00064611434936523
(666) DESCRIBE `ships` 0.003993034362793
(667) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1302') 0.00067305564880371
(668) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00047087669372559
(669) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00046896934509277
(670) DESCRIBE `itineraries` 0.0023348331451416
(671) DESCRIBE `ports` 0.0025238990783691
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00073480606079102
(673) DESCRIBE `ports` 0.0025880336761475
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00063681602478027
(675) DESCRIBE `ports` 0.0024869441986084
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0006110668182373
(677) DESCRIBE `sailingdates` 0.0023529529571533
(678) DESCRIBE `ports` 0.0028071403503418
(679) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00075602531433105
(680) DESCRIBE `ports` 0.0028600692749023
(681) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00067305564880371
(682) DESCRIBE `ports` 0.0026209354400635
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00065493583679199
(684) DESCRIBE `ports` 0.0024898052215576
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00055503845214844
(686) DESCRIBE `ports` 0.0024409294128418
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00051999092102051
(688) DESCRIBE `ports` 0.0026829242706299
(689) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00057411193847656
(690) DESCRIBE `ports` 0.0024819374084473
(691) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00059390068054199
(692) DESCRIBE `ports` 0.0024731159210205
(693) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00049209594726562
(694) DESCRIBE `ports` 0.0026760101318359
(695) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00065493583679199
(696) DESCRIBE `ports` 0.0026419162750244
(697) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00065803527832031
(698) DESCRIBE `ports` 0.0023698806762695
(699) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00052499771118164
(700) DESCRIBE `ports` 0.0021860599517822
(701) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00047802925109863
(702) DESCRIBE `ports` 0.002357006072998
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00065779685974121
(704) DESCRIBE `ports` 0.0019550323486328
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00043797492980957
(706) DESCRIBE `ports` 0.0020289421081543
(707) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00057005882263184
(708) DESCRIBE `ports` 0.0019159317016602
(709) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043606758117676
(710) DESCRIBE `avid_specials` 0.0023090839385986
(711) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76562 and class = 'Cruise') OR (item_id = 1302 AND class = 'Ship') OR (item_id = 18 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.001741886138916
(712) DESCRIBE `cruiselines` 0.0033011436462402
(713) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0007631778717041
(714) DESCRIBE `orchid_image` 0.0030419826507568
(715) DESCRIBE `cruiselines` 0.0036330223083496
(716) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00062680244445801
(717) DESCRIBE `ships` 0.0042860507965088
(718) SELECT `ships`.* FROM `ships` WHERE (id IN ('792', '657', '1607', '1302', '547', '340', '82', '75', '78', '335', '401', '81', '84', '74')) ORDER BY FIND_IN_SET(id, '792,657,1607,1302,547,340,82,75,78,335,401,81,84,74') 0.0027670860290527
(719) DESCRIBE `cruisetypes` 0.0025711059570312
(720) DESCRIBE `destinations` 0.0036671161651611
(721) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '12', '22', '48', '25', '11', '43', '37', '35', '53', '34', '38', '26', '49', '29', '21', '8', '28', '52', '40')) ORDER BY FIND_IN_SET(id, '2,12,22,48,25,11,43,37,35,53,34,38,26,49,29,21,8,28,52,40') 0.0028948783874512
(722) DESCRIBE `cruiselines` 0.0041849613189697
(723) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00061392784118652
(724) DESCRIBE `cruiselines` 0.0040519237518311
(725) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00067806243896484