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

Total elapsed time: 1.0899522304535

# Query Time
(1) connect 0.0016329288482666
(2) DESCRIBE `cruises` 0.0059230327606201
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41693, 8256, 38149, 38147, 73645, 71103, 73646, 73649, 68052, 81163)) ORDER BY FIND_IN_SET(id, '41693,8256,38149,38147,73645,71103,73646,73649,68052,81163') 0.0034749507904053
(4) DESCRIBE `cruises` 0.0045421123504639
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41693') 0.00047206878662109
(6) DESCRIBE `ships` 0.0052940845489502
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00085997581481934
(8) DESCRIBE `ships` 0.0045311450958252
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00051999092102051
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035619735717773
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034403800964355
(12) DESCRIBE `itineraries` 0.0020718574523926
(13) DESCRIBE `ports` 0.002007007598877
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00067305564880371
(15) DESCRIBE `ports` 0.0020167827606201
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00044012069702148
(17) DESCRIBE `ports` 0.0019159317016602
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00059103965759277
(19) DESCRIBE `sailingdates` 0.0024840831756592
(20) DESCRIBE `ports` 0.0032041072845459
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00073504447937012
(22) DESCRIBE `ports` 0.002755880355835
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00059080123901367
(24) DESCRIBE `ports` 0.0027761459350586
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00059700012207031
(26) DESCRIBE `ports` 0.0028829574584961
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.00060701370239258
(28) DESCRIBE `ports` 0.0027170181274414
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00062394142150879
(30) DESCRIBE `ports` 0.0029349327087402
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00057482719421387
(32) DESCRIBE `ports` 0.0027909278869629
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00061702728271484
(34) DESCRIBE `ports` 0.0029029846191406
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00061798095703125
(36) DESCRIBE `ports` 0.0029458999633789
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00069189071655273
(38) DESCRIBE `ports` 0.0030031204223633
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00060820579528809
(40) DESCRIBE `ports` 0.0027618408203125
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00077414512634277
(42) DESCRIBE `ports` 0.002802848815918
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.00076389312744141
(44) DESCRIBE `ports` 0.0028250217437744
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00060796737670898
(46) DESCRIBE `ports` 0.0040528774261475
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00064587593078613
(48) DESCRIBE `ports` 0.003136157989502
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6058))) 0.00064587593078613
(50) DESCRIBE `ports` 0.0026490688323975
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6058') 0.00056695938110352
(52) DESCRIBE `ports` 0.0038559436798096
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00067400932312012
(54) DESCRIBE `ports` 0.0036280155181885
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00041389465332031
(56) DESCRIBE `ports` 0.0018801689147949
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00040912628173828
(58) DESCRIBE `ports` 0.0017509460449219
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00051403045654297
(60) DESCRIBE `avid_specials` 0.0015759468078613
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41693 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012648105621338
(62) DESCRIBE `cruiselines` 0.0026669502258301
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00048995018005371
(64) DESCRIBE `orchid_image` 0.002000093460083
(65) DESCRIBE `cruiselines` 0.0026018619537354
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00043606758117676
(67) DESCRIBE `cruises` 0.0043191909790039
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '8256') 0.00059986114501953
(69) DESCRIBE `ships` 0.0039639472961426
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00051307678222656
(71) DESCRIBE `ships` 0.0038270950317383
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00055313110351562
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035190582275391
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033998489379883
(75) DESCRIBE `itineraries` 0.0018351078033447
(76) DESCRIBE `ports` 0.0017600059509277
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00047397613525391
(78) DESCRIBE `ports` 0.001802921295166
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00039100646972656
(80) DESCRIBE `ports` 0.0018458366394043
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00053501129150391
(82) DESCRIBE `sailingdates` 0.0015981197357178
(83) DESCRIBE `ports` 0.0020787715911865
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00045490264892578
(85) DESCRIBE `ports` 0.0018241405487061
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0003819465637207
(87) DESCRIBE `ports` 0.0018088817596436
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00044584274291992
(89) DESCRIBE `ports` 0.0018420219421387
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.00037193298339844
(91) DESCRIBE `ports` 0.0021319389343262
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00059199333190918
(93) DESCRIBE `ports` 0.0024318695068359
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00055313110351562
(95) DESCRIBE `ports` 0.0019261837005615
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00049901008605957
(97) DESCRIBE `ports` 0.0020191669464111
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00040102005004883
(99) DESCRIBE `ports` 0.0020990371704102
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00054001808166504
(101) DESCRIBE `ports` 0.0018420219421387
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00038480758666992
(103) DESCRIBE `avid_specials` 0.0016181468963623
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 8256 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011169910430908
(105) DESCRIBE `cruiselines` 0.002816915512085
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00045394897460938
(107) DESCRIBE `orchid_image` 0.0020740032196045
(108) DESCRIBE `cruiselines` 0.0026791095733643
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00043797492980957
(110) DESCRIBE `cruises` 0.0037989616394043
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38149') 0.00044703483581543
(112) DESCRIBE `ships` 0.0036609172821045
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00053310394287109
(114) DESCRIBE `ships` 0.0042839050292969
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00076007843017578
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00051689147949219
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00046801567077637
(118) DESCRIBE `itineraries` 0.0020890235900879
(119) DESCRIBE `ports` 0.0028798580169678
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00051593780517578
(121) DESCRIBE `ports` 0.0035479068756104
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00054001808166504
(123) DESCRIBE `ports` 0.0025839805603027
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00055694580078125
(125) DESCRIBE `sailingdates` 0.0024819374084473
(126) DESCRIBE `ports` 0.0027549266815186
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00062203407287598
(128) DESCRIBE `ports` 0.0024261474609375
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00055217742919922
(130) DESCRIBE `ports` 0.0024590492248535
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00071287155151367
(132) DESCRIBE `ports` 0.001878023147583
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.00048017501831055
(134) DESCRIBE `ports` 0.0018079280853271
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00040102005004883
(136) DESCRIBE `ports` 0.0017960071563721
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.0004727840423584
(138) DESCRIBE `ports` 0.0018620491027832
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6058))) 0.00040698051452637
(140) DESCRIBE `ports` 0.0020821094512939
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6058') 0.00047898292541504
(142) DESCRIBE `ports` 0.0022931098937988
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00052690505981445
(144) DESCRIBE `ports` 0.0030250549316406
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.0006098747253418
(146) DESCRIBE `ports` 0.0028808116912842
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00078606605529785
(148) DESCRIBE `ports` 0.0031709671020508
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00067877769470215
(150) DESCRIBE `ports` 0.0026199817657471
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00058603286743164
(152) DESCRIBE `ports` 0.002655029296875
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.00057888031005859
(154) DESCRIBE `ports` 0.002547025680542
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00062990188598633
(156) DESCRIBE `ports` 0.0027148723602295
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00055789947509766
(158) DESCRIBE `ports` 0.0026149749755859
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00055909156799316
(160) DESCRIBE `ports` 0.0025811195373535
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.000518798828125
(162) DESCRIBE `ports` 0.0026390552520752
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00059294700622559
(164) DESCRIBE `ports` 0.0026438236236572
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00055789947509766
(166) DESCRIBE `avid_specials` 0.0023648738861084
(167) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38149 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021471977233887
(168) DESCRIBE `cruiselines` 0.0038180351257324
(169) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00071907043457031
(170) DESCRIBE `orchid_image` 0.0029990673065186
(171) DESCRIBE `cruiselines` 0.0037429332733154
(172) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00063800811767578
(173) DESCRIBE `cruises` 0.0037291049957275
(174) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38147') 0.00044512748718262
(175) DESCRIBE `ships` 0.0036170482635498
(176) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.0005950927734375
(177) DESCRIBE `ships` 0.0046489238739014
(178) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.0011558532714844
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00059390068054199
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0024411678314209
(181) DESCRIBE `itineraries` 0.0026118755340576
(182) DESCRIBE `ports` 0.0021498203277588
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00046300888061523
(184) DESCRIBE `ports` 0.0022101402282715
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0005190372467041
(186) DESCRIBE `ports` 0.0019710063934326
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00045204162597656
(188) DESCRIBE `sailingdates` 0.0016191005706787
(189) DESCRIBE `ports` 0.0022451877593994
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00082612037658691
(191) DESCRIBE `ports` 0.0025641918182373
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00048613548278809
(193) DESCRIBE `ports` 0.0023720264434814
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00072884559631348
(195) DESCRIBE `ports` 0.0019290447235107
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.00051403045654297
(197) DESCRIBE `ports` 0.0017499923706055
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00040006637573242
(199) DESCRIBE `ports` 0.0018219947814941
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00037813186645508
(201) DESCRIBE `ports` 0.0019209384918213
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6058))) 0.00039505958557129
(203) DESCRIBE `ports` 0.0017330646514893
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6058') 0.00051498413085938
(205) DESCRIBE `ports` 0.0020990371704102
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00047922134399414
(207) DESCRIBE `ports` 0.0022339820861816
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00039005279541016
(209) DESCRIBE `ports` 0.0017979145050049
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00039386749267578
(211) DESCRIBE `ports` 0.0017988681793213
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00036811828613281
(213) DESCRIBE `avid_specials` 0.0015270709991455
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38147 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012350082397461
(215) DESCRIBE `cruiselines` 0.0027129650115967
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00063800811767578
(217) DESCRIBE `orchid_image` 0.0028719902038574
(218) DESCRIBE `cruiselines` 0.003568172454834
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00047421455383301
(220) DESCRIBE `cruises` 0.0038080215454102
(221) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73645') 0.00042295455932617
(222) DESCRIBE `ships` 0.003849983215332
(223) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1679))) 0.00068116188049316
(224) DESCRIBE `ships` 0.004288911819458
(225) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1679') 0.00063180923461914
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00047898292541504
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00052118301391602
(228) DESCRIBE `itineraries` 0.002418041229248
(229) DESCRIBE `ports` 0.0026822090148926
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00052118301391602
(231) DESCRIBE `ports` 0.0018379688262939
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.0004279613494873
(233) DESCRIBE `ports` 0.0018367767333984
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00039887428283691
(235) DESCRIBE `sailingdates` 0.0016429424285889
(236) DESCRIBE `ports` 0.0020339488983154
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00045299530029297
(238) DESCRIBE `ports` 0.0018200874328613
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00050806999206543
(240) DESCRIBE `ports` 0.0027761459350586
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4407))) 0.00070691108703613
(242) DESCRIBE `ports` 0.0027389526367188
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4407') 0.00060510635375977
(244) DESCRIBE `ports` 0.0023648738861084
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4407))) 0.00060009956359863
(246) DESCRIBE `ports` 0.0025110244750977
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4407') 0.00064587593078613
(248) DESCRIBE `ports` 0.0025980472564697
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4409))) 0.00043797492980957
(250) DESCRIBE `ports` 0.0022599697113037
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4409') 0.00061511993408203
(252) DESCRIBE `ports` 0.0028610229492188
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5847))) 0.00063204765319824
(254) DESCRIBE `ports` 0.0028262138366699
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5847') 0.00060796737670898
(256) DESCRIBE `ports` 0.0028121471405029
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5845))) 0.00066804885864258
(258) DESCRIBE `ports` 0.0027329921722412
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5845') 0.00059914588928223
(260) DESCRIBE `ports` 0.0027830600738525
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5264))) 0.00066113471984863
(262) DESCRIBE `ports` 0.0028228759765625
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5264') 0.00061392784118652
(264) DESCRIBE `ports` 0.0027379989624023
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4410))) 0.00066709518432617
(266) DESCRIBE `ports` 0.0028219223022461
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4410') 0.00063395500183105
(268) DESCRIBE `ports` 0.0027098655700684
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5627))) 0.00085616111755371
(270) DESCRIBE `ports` 0.0028259754180908
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5627') 0.00069880485534668
(272) DESCRIBE `ports` 0.0027279853820801
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5627))) 0.00072503089904785
(274) DESCRIBE `ports` 0.002748966217041
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5627') 0.00072503089904785
(276) DESCRIBE `ports` 0.0028040409088135
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4504))) 0.00062298774719238
(278) DESCRIBE `ports` 0.0027010440826416
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4504') 0.00065183639526367
(280) DESCRIBE `avid_specials` 0.0023868083953857
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73645 and class = 'Cruise') OR (item_id = 1679 AND class = 'Ship') OR (item_id = 36 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.0020720958709717
(282) DESCRIBE `cruiselines` 0.003972053527832
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00079607963562012
(284) DESCRIBE `orchid_image` 0.0033049583435059
(285) DESCRIBE `cruiselines` 0.003917932510376
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00075292587280273
(287) DESCRIBE `cruises` 0.0055210590362549
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71103') 0.00064396858215332
(289) DESCRIBE `ships` 0.0056920051574707
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 479))) 0.00092077255249023
(291) DESCRIBE `ships` 0.004889965057373
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '479') 0.0006110668182373
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041913986206055
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00043988227844238
(295) DESCRIBE `itineraries` 0.0018990039825439
(296) DESCRIBE `ports` 0.0024218559265137
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050091743469238
(298) DESCRIBE `ports` 0.0019359588623047
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052285194396973
(300) DESCRIBE `ports` 0.0020010471343994
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043106079101562
(302) DESCRIBE `sailingdates` 0.00199294090271
(303) DESCRIBE `ports` 0.0020987987518311
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00077986717224121
(305) DESCRIBE `ports` 0.0023760795593262
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042200088500977
(307) DESCRIBE `ports` 0.0019299983978271
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5730))) 0.00056290626525879
(309) DESCRIBE `ports` 0.0021910667419434
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5730') 0.00049304962158203
(311) DESCRIBE `ports` 0.0026071071624756
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5268))) 0.00071001052856445
(313) DESCRIBE `ports` 0.0024030208587646
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5268') 0.00049209594726562
(315) DESCRIBE `ports` 0.0021369457244873
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1684))) 0.00051188468933105
(317) DESCRIBE `ports` 0.0018758773803711
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1684') 0.00044512748718262
(319) DESCRIBE `ports` 0.0020918846130371
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00044608116149902
(321) DESCRIBE `ports` 0.0022721290588379
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00044584274291992
(323) DESCRIBE `ports` 0.0024631023406982
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0015349388122559
(325) DESCRIBE `ports` 0.0018789768218994
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00055694580078125
(327) DESCRIBE `avid_specials` 0.0018951892852783
(328) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71103 and class = 'Cruise') OR (item_id = 479 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011770725250244
(329) DESCRIBE `cruiselines` 0.002903938293457
(330) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00070691108703613
(331) DESCRIBE `orchid_image` 0.0021169185638428
(332) DESCRIBE `cruiselines` 0.0030710697174072
(333) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00046300888061523
(334) DESCRIBE `cruises` 0.0055689811706543
(335) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73646') 0.00067400932312012
(336) DESCRIBE `ships` 0.0050499439239502
(337) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1679))) 0.00096487998962402
(338) DESCRIBE `ships` 0.0037150382995605
(339) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1679') 0.0007171630859375
(340) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037002563476562
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035881996154785
(342) DESCRIBE `itineraries` 0.0018398761749268
(343) DESCRIBE `ports` 0.0019519329071045
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00047612190246582
(345) DESCRIBE `ports` 0.0019450187683105
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.000579833984375
(347) DESCRIBE `ports` 0.0019938945770264
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00046896934509277
(349) DESCRIBE `sailingdates` 0.0016739368438721
(350) DESCRIBE `ports` 0.0020091533660889
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00049614906311035
(352) DESCRIBE `ports` 0.001971960067749
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00046181678771973
(354) DESCRIBE `ports` 0.0022311210632324
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4504))) 0.00077319145202637
(356) DESCRIBE `ports` 0.0028610229492188
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4504') 0.00069403648376465
(358) DESCRIBE `ports` 0.0029189586639404
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5627))) 0.00074982643127441
(360) DESCRIBE `ports` 0.0027649402618408
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5627') 0.00073099136352539
(362) DESCRIBE `ports` 0.0020370483398438
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5627))) 0.00062704086303711
(364) DESCRIBE `ports` 0.0026810169219971
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5627') 0.00072002410888672
(366) DESCRIBE `ports` 0.0021989345550537
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4410))) 0.00045299530029297
(368) DESCRIBE `ports` 0.0020530223846436
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4410') 0.00041604042053223
(370) DESCRIBE `ports` 0.0019910335540771
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5264))) 0.00051093101501465
(372) DESCRIBE `ports` 0.0022130012512207
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5264') 0.00044798851013184
(374) DESCRIBE `ports` 0.0019481182098389
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5845))) 0.00043702125549316
(376) DESCRIBE `ports` 0.0021851062774658
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5845') 0.00055408477783203
(378) DESCRIBE `ports` 0.0020468235015869
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5264))) 0.00060200691223145
(380) DESCRIBE `ports` 0.0024409294128418
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5264') 0.0004119873046875
(382) DESCRIBE `ports` 0.0018050670623779
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4409))) 0.00046610832214355
(384) DESCRIBE `ports` 0.0018939971923828
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4409') 0.00062990188598633
(386) DESCRIBE `ports` 0.002655029296875
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5675))) 0.00060486793518066
(388) DESCRIBE `ports` 0.0019040107727051
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5675') 0.00044989585876465
(390) DESCRIBE `ports` 0.0024230480194092
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5847))) 0.00057101249694824
(392) DESCRIBE `ports` 0.002424955368042
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5847') 0.00058412551879883
(394) DESCRIBE `ports` 0.002377986907959
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5139))) 0.00058889389038086
(396) DESCRIBE `ports` 0.0027730464935303
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5139') 0.00065994262695312
(398) DESCRIBE `ports` 0.002985954284668
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5139))) 0.00061988830566406
(400) DESCRIBE `ports` 0.002810001373291
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5139') 0.00084900856018066
(402) DESCRIBE `ports` 0.0027589797973633
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00076103210449219
(404) DESCRIBE `ports` 0.0021209716796875
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00041794776916504
(406) DESCRIBE `avid_specials` 0.0019180774688721
(407) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73646 and class = 'Cruise') OR (item_id = 1679 AND class = 'Ship') OR (item_id = 36 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.0012140274047852
(408) DESCRIBE `cruiselines` 0.0026400089263916
(409) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00050687789916992
(410) DESCRIBE `orchid_image` 0.0022830963134766
(411) DESCRIBE `cruiselines` 0.0027620792388916
(412) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00046682357788086
(413) DESCRIBE `cruises` 0.0038390159606934
(414) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73649') 0.00058889389038086
(415) DESCRIBE `ships` 0.0041911602020264
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1679))) 0.00084209442138672
(417) DESCRIBE `ships` 0.0038261413574219
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1679') 0.00060510635375977
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039196014404297
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040006637573242
(421) DESCRIBE `itineraries` 0.0018160343170166
(422) DESCRIBE `ports` 0.0021100044250488
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00058484077453613
(424) DESCRIBE `ports` 0.0020389556884766
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.0004429817199707
(426) DESCRIBE `ports` 0.0020370483398438
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00065994262695312
(428) DESCRIBE `sailingdates` 0.0019900798797607
(429) DESCRIBE `ports` 0.0018410682678223
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00049805641174316
(431) DESCRIBE `ports` 0.002701997756958
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00041484832763672
(433) DESCRIBE `ports` 0.0024659633636475
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2993))) 0.00061798095703125
(435) DESCRIBE `ports` 0.0023491382598877
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2993') 0.00046920776367188
(437) DESCRIBE `ports` 0.0019268989562988
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3428))) 0.00042295455932617
(439) DESCRIBE `ports` 0.0018770694732666
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3428') 0.00039911270141602
(441) DESCRIBE `ports` 0.0017678737640381
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5273))) 0.00047898292541504
(443) DESCRIBE `ports` 0.0018761157989502
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5273') 0.00041604042053223
(445) DESCRIBE `ports` 0.0019290447235107
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00042295455932617
(447) DESCRIBE `ports` 0.0019559860229492
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00043916702270508
(449) DESCRIBE `ports` 0.0018951892852783
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3652))) 0.00046300888061523
(451) DESCRIBE `ports` 0.0023360252380371
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3652') 0.00040984153747559
(453) DESCRIBE `ports` 0.0025451183319092
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3119))) 0.00058102607727051
(455) DESCRIBE `ports` 0.0019299983978271
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3119') 0.00042390823364258
(457) DESCRIBE `ports` 0.00177001953125
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1048))) 0.00049090385437012
(459) DESCRIBE `ports` 0.001878023147583
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1048') 0.0003809928894043
(461) DESCRIBE `ports` 0.0019989013671875
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4852))) 0.00041294097900391
(463) DESCRIBE `ports` 0.0019102096557617
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4852') 0.00041007995605469
(465) DESCRIBE `ports` 0.0025839805603027
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5838))) 0.00057506561279297
(467) DESCRIBE `ports` 0.0027170181274414
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5838') 0.00053191184997559
(469) DESCRIBE `ports` 0.0025761127471924
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2789))) 0.00057601928710938
(471) DESCRIBE `ports` 0.0027849674224854
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2789') 0.00060296058654785
(473) DESCRIBE `ports` 0.002673864364624
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3394))) 0.00091409683227539
(475) DESCRIBE `ports` 0.0029568672180176
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3394') 0.00063800811767578
(477) DESCRIBE `ports` 0.0027668476104736
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3118))) 0.00062990188598633
(479) DESCRIBE `ports` 0.0026519298553467
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3118') 0.00069379806518555
(481) DESCRIBE `ports` 0.0019969940185547
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5852))) 0.00043201446533203
(483) DESCRIBE `ports` 0.002795934677124
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5852') 0.0005640983581543
(485) DESCRIBE `ports` 0.0027091503143311
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5141))) 0.00062394142150879
(487) DESCRIBE `ports` 0.0027790069580078
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5141') 0.00061297416687012
(489) DESCRIBE `ports` 0.0026211738586426
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5271))) 0.00069999694824219
(491) DESCRIBE `ports` 0.002863883972168
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5271') 0.00076413154602051
(493) DESCRIBE `ports` 0.0027370452880859
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00065398216247559
(495) DESCRIBE `ports` 0.0028088092803955
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00060606002807617
(497) DESCRIBE `avid_specials` 0.0025579929351807
(498) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73649 and class = 'Cruise') OR (item_id = 1679 AND class = 'Ship') OR (item_id = 36 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.0022380352020264
(499) DESCRIBE `cruiselines` 0.0064079761505127
(500) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00061607360839844
(501) DESCRIBE `orchid_image` 0.0023880004882812
(502) DESCRIBE `cruiselines` 0.003046989440918
(503) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00053501129150391
(504) DESCRIBE `cruises` 0.0038509368896484
(505) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68052') 0.00053882598876953
(506) DESCRIBE `ships` 0.0038511753082275
(507) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 479))) 0.00067305564880371
(508) DESCRIBE `ships` 0.003978967666626
(509) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '479') 0.00048589706420898
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036406517028809
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00053596496582031
(512) DESCRIBE `itineraries` 0.0028021335601807
(513) DESCRIBE `ports` 0.0019891262054443
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00052595138549805
(515) DESCRIBE `ports` 0.0018830299377441
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00045895576477051
(517) DESCRIBE `ports` 0.0024588108062744
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00065493583679199
(519) DESCRIBE `sailingdates` 0.0026431083679199
(520) DESCRIBE `ports` 0.0032241344451904
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00080204010009766
(522) DESCRIBE `ports` 0.003065824508667
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00066304206848145
(524) DESCRIBE `ports` 0.0029788017272949
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2169))) 0.00079798698425293
(526) DESCRIBE `ports` 0.0030210018157959
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2169') 0.00081086158752441
(528) DESCRIBE `ports` 0.0029909610748291
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2169))) 0.00070881843566895
(530) DESCRIBE `ports` 0.0029170513153076
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2169') 0.00065112113952637
(532) DESCRIBE `ports` 0.0028839111328125
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2767))) 0.00071215629577637
(534) DESCRIBE `ports` 0.0028290748596191
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2767') 0.00066018104553223
(536) DESCRIBE `ports` 0.0028090476989746
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5268))) 0.00069808959960938
(538) DESCRIBE `ports` 0.0028531551361084
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5268') 0.00064396858215332
(540) DESCRIBE `ports` 0.0028450489044189
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1683))) 0.00071096420288086
(542) DESCRIBE `ports` 0.0024640560150146
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1683') 0.00050711631774902
(544) DESCRIBE `ports` 0.0020051002502441
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1684))) 0.00049400329589844
(546) DESCRIBE `ports` 0.0019581317901611
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1684') 0.00041294097900391
(548) DESCRIBE `ports` 0.0020971298217773
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.0005030632019043
(550) DESCRIBE `ports` 0.002140998840332
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00043797492980957
(552) DESCRIBE `ports` 0.0020840167999268
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00046515464782715
(554) DESCRIBE `ports` 0.0021481513977051
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00057101249694824
(556) DESCRIBE `avid_specials` 0.002147912979126
(557) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68052 and class = 'Cruise') OR (item_id = 479 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020930767059326
(558) DESCRIBE `cruiselines` 0.0040068626403809
(559) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00065898895263672
(560) DESCRIBE `orchid_image` 0.0024371147155762
(561) DESCRIBE `cruiselines` 0.0039598941802979
(562) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.0006721019744873
(563) DESCRIBE `cruises` 0.0044021606445312
(564) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81163') 0.00047993659973145
(565) DESCRIBE `ships` 0.0039210319519043
(566) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1679))) 0.0010790824890137
(567) DESCRIBE `ships` 0.0055580139160156
(568) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1679') 0.00072717666625977
(569) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00046205520629883
(570) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036096572875977
(571) DESCRIBE `itineraries` 0.0021200180053711
(572) DESCRIBE `ports` 0.0025129318237305
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00054788589477539
(574) DESCRIBE `ports` 0.001910924911499
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00048995018005371
(576) DESCRIBE `ports` 0.0020980834960938
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00048303604125977
(578) DESCRIBE `sailingdates` 0.001600980758667
(579) DESCRIBE `ports` 0.0019798278808594
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00045108795166016
(581) DESCRIBE `ports` 0.00189208984375
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00040602684020996
(583) DESCRIBE `ports` 0.0018019676208496
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5141))) 0.00043487548828125
(585) DESCRIBE `ports` 0.0017521381378174
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5141') 0.00048303604125977
(587) DESCRIBE `ports` 0.0019211769104004
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3394))) 0.00062108039855957
(589) DESCRIBE `ports` 0.002230167388916
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3394') 0.00067996978759766
(591) DESCRIBE `ports` 0.002357006072998
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3394))) 0.00063705444335938
(593) DESCRIBE `ports` 0.002830982208252
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3394') 0.0007929801940918
(595) DESCRIBE `ports` 0.0026230812072754
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3118))) 0.00088119506835938
(597) DESCRIBE `ports` 0.0028238296508789
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3118') 0.00093698501586914
(599) DESCRIBE `ports` 0.0030100345611572
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4199))) 0.00071096420288086
(601) DESCRIBE `ports` 0.0030181407928467
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4199') 0.0006718635559082
(603) DESCRIBE `ports` 0.003715991973877
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4199))) 0.0007171630859375
(605) DESCRIBE `ports` 0.0026209354400635
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4199') 0.00060606002807617
(607) DESCRIBE `ports` 0.0024869441986084
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4202))) 0.00057482719421387
(609) DESCRIBE `ports` 0.0023729801177979
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4202') 0.0005638599395752
(611) DESCRIBE `ports` 0.0022711753845215
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4202))) 0.00058412551879883
(613) DESCRIBE `ports` 0.0026869773864746
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4202') 0.00063586235046387
(615) DESCRIBE `ports` 0.002612829208374
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4852))) 0.00066518783569336
(617) DESCRIBE `ports` 0.0026900768280029
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4852') 0.00059103965759277
(619) DESCRIBE `ports` 0.0024039745330811
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3119))) 0.00058603286743164
(621) DESCRIBE `ports` 0.0025968551635742
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3119') 0.00070309638977051
(623) DESCRIBE `ports` 0.0024211406707764
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00060200691223145
(625) DESCRIBE `ports` 0.0029571056365967
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00064897537231445
(627) DESCRIBE `ports` 0.0029289722442627
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3652))) 0.00064802169799805
(629) DESCRIBE `ports` 0.0028219223022461
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3652') 0.00056719779968262
(631) DESCRIBE `ports` 0.0028040409088135
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4084))) 0.00069785118103027
(633) DESCRIBE `ports` 0.0027008056640625
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4084') 0.00057291984558105
(635) DESCRIBE `ports` 0.0027759075164795
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2536))) 0.00061917304992676
(637) DESCRIBE `ports` 0.0027740001678467
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2536') 0.00058412551879883
(639) DESCRIBE `ports` 0.0024979114532471
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00043010711669922
(641) DESCRIBE `ports` 0.0027811527252197
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00058388710021973
(643) DESCRIBE `avid_specials` 0.0023350715637207
(644) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81163 and class = 'Cruise') OR (item_id = 1679 AND class = 'Ship') OR (item_id = 36 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.002288818359375
(645) DESCRIBE `cruiselines` 0.0035741329193115
(646) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00066781044006348
(647) DESCRIBE `orchid_image` 0.0028209686279297
(648) DESCRIBE `cruiselines` 0.0036211013793945
(649) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00054502487182617
(650) DESCRIBE `ships` 0.004317045211792
(651) SELECT `ships`.* FROM `ships` WHERE (id IN ('207', '479', '1679', '1832')) ORDER BY FIND_IN_SET(id, '207,479,1679,1832') 0.002234935760498
(652) DESCRIBE `cruisetypes` 0.0022599697113037
(653) DESCRIBE `destinations` 0.0034990310668945
(654) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '35', '43', '30')) ORDER BY FIND_IN_SET(id, '8,35,43,30') 0.00093698501586914
(655) DESCRIBE `cruiselines` 0.0040881633758545
(656) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00091385841369629
(657) DESCRIBE `cruiselines` 0.0037848949432373
(658) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00069093704223633