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

Total elapsed time: 1.1448605060577

# Query Time
(1) connect 0.0012331008911133
(2) DESCRIBE `cruises` 0.0046830177307129
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80086, 80134, 80135, 80087, 80136, 80088, 79997, 80137, 80138, 80139)) ORDER BY FIND_IN_SET(id, '80086,80134,80135,80087,80136,80088,79997,80137,80138,80139') 0.0019791126251221
(4) DESCRIBE `cruises` 0.0037431716918945
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80086') 0.00057697296142578
(6) DESCRIBE `ships` 0.0050311088562012
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00065994262695312
(8) DESCRIBE `ships` 0.0050718784332275
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00060009956359863
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052905082702637
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005640983581543
(12) DESCRIBE `itineraries` 0.002601146697998
(13) DESCRIBE `ports` 0.0025069713592529
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00047206878662109
(15) DESCRIBE `ports` 0.002234935760498
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00060296058654785
(17) DESCRIBE `ports` 0.0018699169158936
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00042891502380371
(19) DESCRIBE `sailingdates` 0.0016360282897949
(20) DESCRIBE `ports` 0.0020909309387207
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00047183036804199
(22) DESCRIBE `ports` 0.0019049644470215
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00038409233093262
(24) DESCRIBE `ports` 0.0020771026611328
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00043296813964844
(26) DESCRIBE `ports` 0.001798152923584
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00038504600524902
(28) DESCRIBE `ports` 0.00199294090271
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041103363037109
(30) DESCRIBE `ports` 0.0019688606262207
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039315223693848
(32) DESCRIBE `ports` 0.00199294090271
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00046300888061523
(34) DESCRIBE `ports` 0.0021448135375977
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00040483474731445
(36) DESCRIBE `ports` 0.0019469261169434
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2062))) 0.0003960132598877
(38) DESCRIBE `ports` 0.0018661022186279
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2062') 0.0003659725189209
(40) DESCRIBE `ports` 0.002068042755127
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00055384635925293
(42) DESCRIBE `ports` 0.0019469261169434
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00051712989807129
(44) DESCRIBE `ports` 0.0019650459289551
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00051999092102051
(46) DESCRIBE `ports` 0.0023670196533203
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00047492980957031
(48) DESCRIBE `ports` 0.0020790100097656
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00049304962158203
(50) DESCRIBE `ports` 0.0019049644470215
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.0006561279296875
(52) DESCRIBE `ports` 0.0027239322662354
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00062298774719238
(54) DESCRIBE `ports` 0.0025961399078369
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00056695938110352
(56) DESCRIBE `ports` 0.0025861263275146
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00058698654174805
(58) DESCRIBE `ports` 0.0025620460510254
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0005490779876709
(60) DESCRIBE `ports` 0.0025150775909424
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00060582160949707
(62) DESCRIBE `ports` 0.0025160312652588
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043511390686035
(64) DESCRIBE `avid_specials` 0.0017659664154053
(65) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80086 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0024380683898926
(66) DESCRIBE `cruiselines` 0.0033020973205566
(67) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00046610832214355
(68) DESCRIBE `orchid_image` 0.0026190280914307
(69) DESCRIBE `cruiselines` 0.0031259059906006
(70) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00050997734069824
(71) DESCRIBE `cruises` 0.0043830871582031
(72) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80134') 0.00071978569030762
(73) DESCRIBE `ships` 0.0049948692321777
(74) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00087189674377441
(75) DESCRIBE `ships` 0.0040040016174316
(76) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.0005500316619873
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035595893859863
(78) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034689903259277
(79) DESCRIBE `itineraries` 0.0023701190948486
(80) DESCRIBE `ports` 0.0029220581054688
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0006101131439209
(82) DESCRIBE `ports` 0.0024850368499756
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00048494338989258
(84) DESCRIBE `ports` 0.0025680065155029
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043702125549316
(86) DESCRIBE `sailingdates` 0.0016870498657227
(87) DESCRIBE `ports` 0.0018718242645264
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00044894218444824
(89) DESCRIBE `ports` 0.0017690658569336
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043392181396484
(91) DESCRIBE `ports` 0.0017480850219727
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00040221214294434
(93) DESCRIBE `ports` 0.0020210742950439
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.0004429817199707
(95) DESCRIBE `ports` 0.0020411014556885
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00059294700622559
(97) DESCRIBE `ports` 0.0022318363189697
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00049090385437012
(99) DESCRIBE `ports` 0.002377986907959
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3561))) 0.00041818618774414
(101) DESCRIBE `ports` 0.0022010803222656
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00058293342590332
(103) DESCRIBE `ports` 0.0022659301757812
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00055384635925293
(105) DESCRIBE `ports` 0.0024609565734863
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00054001808166504
(107) DESCRIBE `ports` 0.0018360614776611
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00058197975158691
(109) DESCRIBE `ports` 0.0020949840545654
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00071811676025391
(111) DESCRIBE `ports` 0.0020649433135986
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0007011890411377
(113) DESCRIBE `ports` 0.002100944519043
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00060486793518066
(115) DESCRIBE `ports` 0.0023651123046875
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00051593780517578
(117) DESCRIBE `ports` 0.001849889755249
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00041413307189941
(119) DESCRIBE `ports` 0.0019979476928711
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00039005279541016
(121) DESCRIBE `ports` 0.0018839836120605
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00048303604125977
(123) DESCRIBE `ports` 0.0020430088043213
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00043392181396484
(125) DESCRIBE `ports` 0.0020461082458496
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042200088500977
(127) DESCRIBE `ports` 0.0023901462554932
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040507316589355
(129) DESCRIBE `ports` 0.0019571781158447
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2511))) 0.00046706199645996
(131) DESCRIBE `ports` 0.0018599033355713
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2511') 0.00043201446533203
(133) DESCRIBE `ports` 0.0019021034240723
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2419))) 0.00040602684020996
(135) DESCRIBE `ports` 0.0018508434295654
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2419') 0.00041389465332031
(137) DESCRIBE `ports` 0.0020289421081543
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00051307678222656
(139) DESCRIBE `ports` 0.002126932144165
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00052404403686523
(141) DESCRIBE `ports` 0.0020198822021484
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00043892860412598
(143) DESCRIBE `ports` 0.0018749237060547
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00043487548828125
(145) DESCRIBE `ports` 0.0018351078033447
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00043702125549316
(147) DESCRIBE `ports` 0.002173900604248
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00046205520629883
(149) DESCRIBE `ports` 0.0019237995147705
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00041604042053223
(151) DESCRIBE `ports` 0.0019638538360596
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00042295455932617
(153) DESCRIBE `ports` 0.0020890235900879
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3747))) 0.00077486038208008
(155) DESCRIBE `ports` 0.0028557777404785
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3747') 0.00058913230895996
(157) DESCRIBE `ports` 0.0019590854644775
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3718))) 0.00049805641174316
(159) DESCRIBE `ports` 0.0020720958709717
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3718') 0.00048184394836426
(161) DESCRIBE `ports` 0.0019359588623047
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00044488906860352
(163) DESCRIBE `ports` 0.0018069744110107
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00054812431335449
(165) DESCRIBE `avid_specials` 0.0019450187683105
(166) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80134 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021400451660156
(167) DESCRIBE `cruiselines` 0.0037150382995605
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00056195259094238
(169) DESCRIBE `orchid_image` 0.0025088787078857
(170) DESCRIBE `cruiselines` 0.0026979446411133
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0005180835723877
(172) DESCRIBE `cruises` 0.0046470165252686
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80135') 0.00071191787719727
(174) DESCRIBE `ships` 0.004148006439209
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00060701370239258
(176) DESCRIBE `ships` 0.0039288997650146
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00068402290344238
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041103363037109
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051498413085938
(180) DESCRIBE `itineraries` 0.0020830631256104
(181) DESCRIBE `ports` 0.0023250579833984
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00064897537231445
(183) DESCRIBE `ports` 0.0021522045135498
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00049805641174316
(185) DESCRIBE `ports` 0.001884937286377
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0004570484161377
(187) DESCRIBE `sailingdates` 0.0021870136260986
(188) DESCRIBE `ports` 0.002241849899292
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046396255493164
(190) DESCRIBE `ports` 0.0019261837005615
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00047397613525391
(192) DESCRIBE `ports` 0.0025129318237305
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00081610679626465
(194) DESCRIBE `ports` 0.0019168853759766
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00042986869812012
(196) DESCRIBE `ports` 0.0025088787078857
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00053596496582031
(198) DESCRIBE `ports` 0.0020570755004883
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00055098533630371
(200) DESCRIBE `ports` 0.0023701190948486
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3561))) 0.00036501884460449
(202) DESCRIBE `ports` 0.0024328231811523
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00054597854614258
(204) DESCRIBE `ports` 0.0022249221801758
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00048685073852539
(206) DESCRIBE `ports` 0.0023970603942871
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00042605400085449
(208) DESCRIBE `ports` 0.0022130012512207
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00040721893310547
(210) DESCRIBE `ports` 0.0020790100097656
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00045895576477051
(212) DESCRIBE `ports` 0.0022339820861816
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00060415267944336
(214) DESCRIBE `ports` 0.0021998882293701
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00077390670776367
(216) DESCRIBE `ports` 0.0027618408203125
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00055098533630371
(218) DESCRIBE `ports` 0.002575159072876
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00057506561279297
(220) DESCRIBE `ports` 0.0026600360870361
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0005500316619873
(222) DESCRIBE `ports` 0.0026500225067139
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00059318542480469
(224) DESCRIBE `ports` 0.0027990341186523
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.0006110668182373
(226) DESCRIBE `ports` 0.0026381015777588
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00059199333190918
(228) DESCRIBE `ports` 0.0025489330291748
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00063490867614746
(230) DESCRIBE `avid_specials` 0.0025210380554199
(231) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80135 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019841194152832
(232) DESCRIBE `cruiselines` 0.0034520626068115
(233) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00064516067504883
(234) DESCRIBE `orchid_image` 0.0032029151916504
(235) DESCRIBE `cruiselines` 0.0041890144348145
(236) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00077104568481445
(237) DESCRIBE `cruises` 0.0054299831390381
(238) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80087') 0.00067806243896484
(239) DESCRIBE `ships` 0.0054659843444824
(240) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.0007171630859375
(241) DESCRIBE `ships` 0.0055239200592041
(242) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00062394142150879
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052905082702637
(244) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051999092102051
(245) DESCRIBE `itineraries` 0.0022010803222656
(246) DESCRIBE `ports` 0.002896785736084
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00068902969360352
(248) DESCRIBE `ports` 0.0019841194152832
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00050592422485352
(250) DESCRIBE `ports` 0.0023179054260254
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00047588348388672
(252) DESCRIBE `sailingdates` 0.0019989013671875
(253) DESCRIBE `ports` 0.002500057220459
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004889965057373
(255) DESCRIBE `ports` 0.0019309520721436
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00039386749267578
(257) DESCRIBE `ports` 0.0019011497497559
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00043320655822754
(259) DESCRIBE `ports` 0.0022480487823486
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.00048494338989258
(261) DESCRIBE `ports` 0.002065896987915
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00046920776367188
(263) DESCRIBE `ports` 0.0018520355224609
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00044512748718262
(265) DESCRIBE `ports` 0.0018959045410156
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00050806999206543
(267) DESCRIBE `ports` 0.0019850730895996
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00045204162597656
(269) DESCRIBE `ports` 0.0019309520721436
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00042915344238281
(271) DESCRIBE `ports` 0.0019681453704834
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00038695335388184
(273) DESCRIBE `ports` 0.0019681453704834
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00045609474182129
(275) DESCRIBE `ports` 0.0022320747375488
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00041913986206055
(277) DESCRIBE `ports` 0.0018179416656494
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00043392181396484
(279) DESCRIBE `ports` 0.0019049644470215
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00052905082702637
(281) DESCRIBE `ports` 0.0020148754119873
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00045680999755859
(283) DESCRIBE `ports` 0.0018198490142822
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00040602684020996
(285) DESCRIBE `ports` 0.0021500587463379
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00042200088500977
(287) DESCRIBE `ports` 0.0018730163574219
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00046801567077637
(289) DESCRIBE `ports` 0.0020689964294434
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00059199333190918
(291) DESCRIBE `ports` 0.0019309520721436
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00057721138000488
(293) DESCRIBE `avid_specials` 0.0018110275268555
(294) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80087 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011351108551025
(295) DESCRIBE `cruiselines` 0.0027978420257568
(296) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00047397613525391
(297) DESCRIBE `orchid_image` 0.002065896987915
(298) DESCRIBE `cruiselines` 0.0027410984039307
(299) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00039792060852051
(300) DESCRIBE `cruises` 0.0036160945892334
(301) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80136') 0.00055289268493652
(302) DESCRIBE `ships` 0.0042178630828857
(303) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00063514709472656
(304) DESCRIBE `ships` 0.0039939880371094
(305) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.0007169246673584
(306) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053787231445312
(307) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047588348388672
(308) DESCRIBE `itineraries` 0.0024118423461914
(309) DESCRIBE `ports` 0.0026328563690186
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00060796737670898
(311) DESCRIBE `ports` 0.0026919841766357
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00062799453735352
(313) DESCRIBE `ports` 0.0023930072784424
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00055289268493652
(315) DESCRIBE `sailingdates` 0.0021669864654541
(316) DESCRIBE `ports` 0.0018260478973389
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044488906860352
(318) DESCRIBE `ports` 0.0019721984863281
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038409233093262
(320) DESCRIBE `ports` 0.0017440319061279
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2511))) 0.00045585632324219
(322) DESCRIBE `ports` 0.00189208984375
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2511') 0.00043821334838867
(324) DESCRIBE `ports` 0.0018880367279053
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2419))) 0.0004279613494873
(326) DESCRIBE `ports` 0.0019741058349609
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2419') 0.00053596496582031
(328) DESCRIBE `ports` 0.0024690628051758
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00051283836364746
(330) DESCRIBE `ports` 0.002310037612915
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00041508674621582
(332) DESCRIBE `ports` 0.0023021697998047
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00041890144348145
(334) DESCRIBE `ports` 0.0018360614776611
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00046396255493164
(336) DESCRIBE `ports` 0.0017588138580322
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00040793418884277
(338) DESCRIBE `ports` 0.0019748210906982
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00038504600524902
(340) DESCRIBE `ports` 0.0019590854644775
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00056886672973633
(342) DESCRIBE `ports` 0.0022099018096924
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.0005030632019043
(344) DESCRIBE `ports` 0.00199294090271
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3747))) 0.0005030632019043
(346) DESCRIBE `ports` 0.0024540424346924
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3747') 0.00056195259094238
(348) DESCRIBE `ports` 0.0027451515197754
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3718))) 0.00070285797119141
(350) DESCRIBE `ports` 0.0025999546051025
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3718') 0.00054121017456055
(352) DESCRIBE `ports` 0.0025200843811035
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00062894821166992
(354) DESCRIBE `ports` 0.002701997756958
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00059604644775391
(356) DESCRIBE `avid_specials` 0.0025289058685303
(357) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80136 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015199184417725
(358) DESCRIBE `cruiselines` 0.0026590824127197
(359) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00043106079101562
(360) DESCRIBE `orchid_image` 0.0024681091308594
(361) DESCRIBE `cruiselines` 0.0037128925323486
(362) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00043702125549316
(363) DESCRIBE `cruises` 0.004115104675293
(364) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80088') 0.00065279006958008
(365) DESCRIBE `ships` 0.0045580863952637
(366) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00076103210449219
(367) DESCRIBE `ships` 0.0056281089782715
(368) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00066900253295898
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051498413085938
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049114227294922
(371) DESCRIBE `itineraries` 0.0028700828552246
(372) DESCRIBE `ports` 0.0026969909667969
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00059413909912109
(374) DESCRIBE `ports` 0.0022192001342773
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045013427734375
(376) DESCRIBE `ports` 0.0017509460449219
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00044488906860352
(378) DESCRIBE `sailingdates` 0.0018599033355713
(379) DESCRIBE `ports` 0.0019590854644775
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00070810317993164
(381) DESCRIBE `ports` 0.0028750896453857
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00063395500183105
(383) DESCRIBE `ports` 0.0027148723602295
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00060677528381348
(385) DESCRIBE `ports` 0.0023159980773926
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00040912628173828
(387) DESCRIBE `ports` 0.0017910003662109
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 756))) 0.00041818618774414
(389) DESCRIBE `ports` 0.0017552375793457
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '756') 0.00041103363037109
(391) DESCRIBE `ports` 0.0017938613891602
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 694))) 0.00046300888061523
(393) DESCRIBE `ports` 0.0019948482513428
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '694') 0.00039196014404297
(395) DESCRIBE `ports` 0.0018200874328613
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00044512748718262
(397) DESCRIBE `ports` 0.0021700859069824
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00051093101501465
(399) DESCRIBE `ports` 0.0019841194152832
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00050687789916992
(401) DESCRIBE `ports` 0.0019540786743164
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00043201446533203
(403) DESCRIBE `ports` 0.0020010471343994
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042986869812012
(405) DESCRIBE `ports` 0.0019209384918213
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00046014785766602
(407) DESCRIBE `ports` 0.002310037612915
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00057387351989746
(409) DESCRIBE `ports` 0.0022377967834473
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00067305564880371
(411) DESCRIBE `ports` 0.0021340847015381
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00042009353637695
(413) DESCRIBE `ports` 0.0018529891967773
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00038003921508789
(415) DESCRIBE `ports` 0.0017828941345215
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00042295455932617
(417) DESCRIBE `ports` 0.0019688606262207
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00039792060852051
(419) DESCRIBE `ports` 0.0020039081573486
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00045895576477051
(421) DESCRIBE `ports` 0.0019378662109375
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00044989585876465
(423) DESCRIBE `ports` 0.002284049987793
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00060200691223145
(425) DESCRIBE `ports` 0.0025248527526855
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00055313110351562
(427) DESCRIBE `avid_specials` 0.0022718906402588
(428) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80088 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011870861053467
(429) DESCRIBE `cruiselines` 0.0036449432373047
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00065207481384277
(431) DESCRIBE `orchid_image` 0.0024900436401367
(432) DESCRIBE `cruiselines` 0.0037260055541992
(433) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00056695938110352
(434) DESCRIBE `cruises` 0.0047008991241455
(435) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79997') 0.00055408477783203
(436) DESCRIBE `ships` 0.0038599967956543
(437) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00052905082702637
(438) DESCRIBE `ships` 0.0054140090942383
(439) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00048589706420898
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039815902709961
(441) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004119873046875
(442) DESCRIBE `itineraries` 0.0023579597473145
(443) DESCRIBE `ports` 0.0020780563354492
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047588348388672
(445) DESCRIBE `ports` 0.0020060539245605
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046920776367188
(447) DESCRIBE `ports` 0.0019409656524658
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00049805641174316
(449) DESCRIBE `sailingdates` 0.0019338130950928
(450) DESCRIBE `ports` 0.0024020671844482
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00052499771118164
(452) DESCRIBE `ports` 0.0019638538360596
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00051188468933105
(454) DESCRIBE `ports` 0.0025908946990967
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00049209594726562
(456) DESCRIBE `ports` 0.00211501121521
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00060510635375977
(458) DESCRIBE `ports` 0.0028939247131348
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00074195861816406
(460) DESCRIBE `ports` 0.0021851062774658
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00055694580078125
(462) DESCRIBE `ports` 0.0023910999298096
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00058603286743164
(464) DESCRIBE `ports` 0.0022718906402588
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0004270076751709
(466) DESCRIBE `ports` 0.0019149780273438
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00062298774719238
(468) DESCRIBE `ports` 0.002424955368042
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00041508674621582
(470) DESCRIBE `ports` 0.0023550987243652
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 569))) 0.00065517425537109
(472) DESCRIBE `ports` 0.0026538372039795
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '569') 0.00059294700622559
(474) DESCRIBE `ports` 0.0025119781494141
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1870))) 0.00074601173400879
(476) DESCRIBE `ports` 0.0026750564575195
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1870') 0.00073981285095215
(478) DESCRIBE `ports` 0.0029351711273193
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00059413909912109
(480) DESCRIBE `ports` 0.0024008750915527
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00058197975158691
(482) DESCRIBE `ports` 0.0028030872344971
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00052404403686523
(484) DESCRIBE `ports` 0.0020210742950439
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00038814544677734
(486) DESCRIBE `ports` 0.0020740032196045
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00057792663574219
(488) DESCRIBE `ports` 0.0027480125427246
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00072693824768066
(490) DESCRIBE `ports` 0.0028278827667236
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0004730224609375
(492) DESCRIBE `ports` 0.0020210742950439
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00062394142150879
(494) DESCRIBE `avid_specials` 0.0021388530731201
(495) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79997 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012068748474121
(496) DESCRIBE `cruiselines` 0.0027880668640137
(497) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00057411193847656
(498) DESCRIBE `orchid_image` 0.002269983291626
(499) DESCRIBE `cruiselines` 0.0030970573425293
(500) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00042295455932617
(501) DESCRIBE `cruises` 0.0035779476165771
(502) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80137') 0.00045418739318848
(503) DESCRIBE `ships` 0.0037350654602051
(504) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00059604644775391
(505) DESCRIBE `ships` 0.0052950382232666
(506) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00081086158752441
(507) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049805641174316
(508) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005030632019043
(509) DESCRIBE `itineraries` 0.0025341510772705
(510) DESCRIBE `ports` 0.0022721290588379
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00070595741271973
(512) DESCRIBE `ports` 0.0022518634796143
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00052094459533691
(514) DESCRIBE `ports` 0.0025579929351807
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00059914588928223
(516) DESCRIBE `sailingdates` 0.0024571418762207
(517) DESCRIBE `ports` 0.0025031566619873
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00055694580078125
(519) DESCRIBE `ports` 0.0027430057525635
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00062203407287598
(521) DESCRIBE `ports` 0.0023319721221924
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 730))) 0.00043606758117676
(523) DESCRIBE `ports` 0.0023250579833984
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '730') 0.00051498413085938
(525) DESCRIBE `ports` 0.0027639865875244
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1217))) 0.00062417984008789
(527) DESCRIBE `ports` 0.002734899520874
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1217') 0.0005950927734375
(529) DESCRIBE `ports` 0.0026390552520752
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 241))) 0.00060796737670898
(531) DESCRIBE `ports` 0.0020170211791992
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '241') 0.00041389465332031
(533) DESCRIBE `ports` 0.0019030570983887
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 241))) 0.00042510032653809
(535) DESCRIBE `ports` 0.0021770000457764
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '241') 0.00043988227844238
(537) DESCRIBE `ports` 0.0019931793212891
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00050806999206543
(539) DESCRIBE `ports` 0.0022680759429932
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00073790550231934
(541) DESCRIBE `ports` 0.0028810501098633
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00071620941162109
(543) DESCRIBE `ports` 0.00211501121521
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00040888786315918
(545) DESCRIBE `ports` 0.0018630027770996
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00044894218444824
(547) DESCRIBE `ports` 0.0019562244415283
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00041890144348145
(549) DESCRIBE `ports` 0.001884937286377
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00043582916259766
(551) DESCRIBE `ports` 0.0022408962249756
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00058889389038086
(553) DESCRIBE `ports` 0.0026700496673584
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00064682960510254
(555) DESCRIBE `ports` 0.0025460720062256
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00072407722473145
(557) DESCRIBE `avid_specials` 0.0023689270019531
(558) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80137 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.002086877822876
(559) DESCRIBE `cruiselines` 0.0035598278045654
(560) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0006101131439209
(561) DESCRIBE `orchid_image` 0.002892017364502
(562) DESCRIBE `cruiselines` 0.0036959648132324
(563) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00063109397888184
(564) DESCRIBE `cruises` 0.0049750804901123
(565) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80138') 0.00055789947509766
(566) DESCRIBE `ships` 0.0052070617675781
(567) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.0009310245513916
(568) DESCRIBE `ships` 0.0051491260528564
(569) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00076913833618164
(570) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005037784576416
(571) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048303604125977
(572) DESCRIBE `itineraries` 0.0025789737701416
(573) DESCRIBE `ports` 0.0019431114196777
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0005488395690918
(575) DESCRIBE `ports` 0.0018470287322998
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00042080879211426
(577) DESCRIBE `ports` 0.0018539428710938
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00053596496582031
(579) DESCRIBE `sailingdates` 0.0015959739685059
(580) DESCRIBE `ports` 0.0019910335540771
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00062417984008789
(582) DESCRIBE `ports` 0.0018150806427002
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00039100646972656
(584) DESCRIBE `ports` 0.0021119117736816
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0005030632019043
(586) DESCRIBE `ports` 0.0020899772644043
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00051403045654297
(588) DESCRIBE `ports` 0.0025811195373535
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00054502487182617
(590) DESCRIBE `ports` 0.0022521018981934
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00064206123352051
(592) DESCRIBE `ports` 0.002964973449707
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3305))) 0.00070786476135254
(594) DESCRIBE `ports` 0.0023391246795654
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3305') 0.00054693222045898
(596) DESCRIBE `ports` 0.0020551681518555
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00047516822814941
(598) DESCRIBE `ports` 0.0019750595092773
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00041103363037109
(600) DESCRIBE `ports` 0.0019598007202148
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00048494338989258
(602) DESCRIBE `ports` 0.0019078254699707
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00050210952758789
(604) DESCRIBE `ports` 0.0019650459289551
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00042891502380371
(606) DESCRIBE `ports` 0.0020918846130371
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00045514106750488
(608) DESCRIBE `ports` 0.0024509429931641
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00055980682373047
(610) DESCRIBE `ports` 0.0027561187744141
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00085306167602539
(612) DESCRIBE `ports` 0.0030448436737061
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 694))) 0.00061392784118652
(614) DESCRIBE `ports` 0.0028660297393799
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '694') 0.00067901611328125
(616) DESCRIBE `ports` 0.0024800300598145
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00056695938110352
(618) DESCRIBE `ports` 0.0024049282073975
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00043606758117676
(620) DESCRIBE `ports` 0.0019979476928711
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00051712989807129
(622) DESCRIBE `ports` 0.0020978450775146
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040197372436523
(624) DESCRIBE `ports` 0.0021071434020996
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1213))) 0.00061702728271484
(626) DESCRIBE `ports` 0.0027148723602295
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1213') 0.00061702728271484
(628) DESCRIBE `ports` 0.0026459693908691
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00051593780517578
(630) DESCRIBE `ports` 0.0020179748535156
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.00047492980957031
(632) DESCRIBE `ports` 0.0022048950195312
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00056695938110352
(634) DESCRIBE `ports` 0.0020267963409424
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00045609474182129
(636) DESCRIBE `ports` 0.0020720958709717
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3561))) 0.00050187110900879
(638) DESCRIBE `ports` 0.0020971298217773
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00046586990356445
(640) DESCRIBE `ports` 0.0020608901977539
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00042009353637695
(642) DESCRIBE `ports` 0.0021519660949707
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00057196617126465
(644) DESCRIBE `ports` 0.0021610260009766
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00043201446533203
(646) DESCRIBE `ports` 0.0020701885223389
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3014))) 0.00047516822814941
(648) DESCRIBE `ports` 0.0018789768218994
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3014') 0.00048089027404785
(650) DESCRIBE `ports` 0.0018701553344727
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00046110153198242
(652) DESCRIBE `ports` 0.0018348693847656
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00050711631774902
(654) DESCRIBE `ports` 0.00205397605896
(655) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00051617622375488
(656) DESCRIBE `ports` 0.0027439594268799
(657) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00065803527832031
(658) DESCRIBE `ports` 0.0024847984313965
(659) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00048708915710449
(660) DESCRIBE `ports` 0.0019111633300781
(661) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00039815902709961
(662) DESCRIBE `ports` 0.0018999576568604
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3657))) 0.00050210952758789
(664) DESCRIBE `ports` 0.0020709037780762
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3657') 0.00050187110900879
(666) DESCRIBE `ports` 0.0022749900817871
(667) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00056004524230957
(668) DESCRIBE `ports` 0.0020010471343994
(669) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044798851013184
(670) DESCRIBE `avid_specials` 0.0017049312591553
(671) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80138 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011539459228516
(672) DESCRIBE `cruiselines` 0.0029361248016357
(673) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00051999092102051
(674) DESCRIBE `orchid_image` 0.0023891925811768
(675) DESCRIBE `cruiselines` 0.0026869773864746
(676) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00054192543029785
(677) DESCRIBE `cruises` 0.0036170482635498
(678) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80139') 0.00043010711669922
(679) DESCRIBE `ships` 0.0037980079650879
(680) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00063610076904297
(681) DESCRIBE `ships` 0.0039870738983154
(682) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00052189826965332
(683) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004429817199707
(684) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034999847412109
(685) DESCRIBE `itineraries` 0.0019919872283936
(686) DESCRIBE `ports` 0.0022110939025879
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00053906440734863
(688) DESCRIBE `ports` 0.0018649101257324
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00044798851013184
(690) DESCRIBE `ports` 0.0018877983093262
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00040602684020996
(692) DESCRIBE `sailingdates` 0.0016930103302002
(693) DESCRIBE `ports` 0.0019259452819824
(694) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00047492980957031
(695) DESCRIBE `ports` 0.0017919540405273
(696) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00046610832214355
(697) DESCRIBE `ports` 0.0019600391387939
(698) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00040292739868164
(699) DESCRIBE `ports` 0.00205397605896
(700) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00053501129150391
(701) DESCRIBE `ports` 0.0028450489044189
(702) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00062179565429688
(703) DESCRIBE `ports` 0.0026929378509521
(704) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.0008540153503418
(705) DESCRIBE `ports` 0.0027611255645752
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3305))) 0.00047087669372559
(707) DESCRIBE `ports` 0.0027709007263184
(708) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3305') 0.00058889389038086
(709) DESCRIBE `ports` 0.0026931762695312
(710) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00058102607727051
(711) DESCRIBE `ports` 0.0025031566619873
(712) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00050091743469238
(713) DESCRIBE `ports` 0.0023939609527588
(714) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00056290626525879
(715) DESCRIBE `ports` 0.0027458667755127
(716) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00063204765319824
(717) DESCRIBE `ports` 0.0018990039825439
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00049304962158203
(719) DESCRIBE `ports` 0.0019910335540771
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00050997734069824
(721) DESCRIBE `ports` 0.0022170543670654
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00051403045654297
(723) DESCRIBE `ports` 0.0019040107727051
(724) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00063300132751465
(725) DESCRIBE `ports` 0.0022039413452148
(726) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 694))) 0.00049400329589844
(727) DESCRIBE `ports` 0.0024409294128418
(728) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '694') 0.00044798851013184
(729) DESCRIBE `ports` 0.0019290447235107
(730) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00043606758117676
(731) DESCRIBE `ports` 0.0020530223846436
(732) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00047397613525391
(733) DESCRIBE `ports` 0.0019519329071045
(734) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0004270076751709
(735) DESCRIBE `ports` 0.0019049644470215
(736) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00038886070251465
(737) DESCRIBE `avid_specials` 0.0017609596252441
(738) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80139 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011849403381348
(739) DESCRIBE `cruiselines` 0.0028080940246582
(740) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0004420280456543
(741) DESCRIBE `orchid_image` 0.0022361278533936
(742) DESCRIBE `cruiselines` 0.0029399394989014
(743) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0005030632019043
(744) DESCRIBE `ships` 0.0041029453277588
(745) SELECT `ships`.* FROM `ships` WHERE (id IN ('966', '1319', '508', '850', '1108')) ORDER BY FIND_IN_SET(id, '966,1319,508,850,1108') 0.0011229515075684
(746) DESCRIBE `cruisetypes` 0.0015251636505127
(747) DESCRIBE `cruiselines` 0.0027461051940918
(748) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00047421455383301
(749) DESCRIBE `destinations` 0.002392053604126
(750) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00041604042053223
(751) DESCRIBE `destinations` 0.002324104309082
(752) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00043296813964844
(753) DESCRIBE `cruiselines` 0.0028009414672852
(754) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00042104721069336