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

Total elapsed time: 1.66273188591

# Query Time
(1) connect 0.0033369064331055
(2) DESCRIBE `cruises` 0.013334035873413
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (81857, 49747, 57725, 59443, 61442, 64035, 69593, 69909, 70068, 70981)) ORDER BY FIND_IN_SET(id, '81857,49747,57725,59443,61442,64035,69593,69909,70068,70981') 0.0042791366577148
(4) DESCRIBE `cruises` 0.0050110816955566
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81857') 0.00066018104553223
(6) DESCRIBE `ships` 0.005558967590332
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1581))) 0.0007479190826416
(8) DESCRIBE `ships` 0.010103940963745
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1581') 0.00086307525634766
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0028460025787354
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051403045654297
(12) DESCRIBE `itineraries` 0.010087013244629
(13) DESCRIBE `ports` 0.0050311088562012
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.0019991397857666
(15) DESCRIBE `ports` 0.0045158863067627
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.0007469654083252
(17) DESCRIBE `ports` 0.0036559104919434
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.00068306922912598
(19) DESCRIBE `sailingdates` 0.0036931037902832
(20) DESCRIBE `ports` 0.0048367977142334
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.001093864440918
(22) DESCRIBE `ports` 0.0035150051116943
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.00065898895263672
(24) DESCRIBE `ports` 0.0026869773864746
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.00070619583129883
(26) DESCRIBE `ports` 0.0027520656585693
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.00069713592529297
(28) DESCRIBE `ports` 0.0031628608703613
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5646))) 0.00065016746520996
(30) DESCRIBE `ports` 0.0028541088104248
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5646') 0.0006101131439209
(32) DESCRIBE `ports` 0.0025959014892578
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5647))) 0.00081801414489746
(34) DESCRIBE `ports` 0.0027539730072021
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5647') 0.00063109397888184
(36) DESCRIBE `ports` 0.0027849674224854
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5648))) 0.00061202049255371
(38) DESCRIBE `ports` 0.0026769638061523
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5648') 0.00069713592529297
(40) DESCRIBE `ports` 0.0034358501434326
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5648))) 0.00094699859619141
(42) DESCRIBE `ports` 0.0049300193786621
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5648') 0.0006110668182373
(44) DESCRIBE `ports` 0.0028269290924072
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5646))) 0.00077199935913086
(46) DESCRIBE `ports` 0.0053141117095947
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5646') 0.0017549991607666
(48) DESCRIBE `ports` 0.0039908885955811
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6126))) 0.00061297416687012
(50) DESCRIBE `ports` 0.0036849975585938
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6126') 0.0014619827270508
(52) DESCRIBE `ports` 0.003032922744751
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6125))) 0.00076794624328613
(54) DESCRIBE `ports` 0.0034928321838379
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6125') 0.00060892105102539
(56) DESCRIBE `ports` 0.0025341510772705
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6125))) 0.0015270709991455
(58) DESCRIBE `ports` 0.0039889812469482
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6125') 0.0010941028594971
(60) DESCRIBE `ports` 0.0058250427246094
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6126))) 0.0011050701141357
(62) DESCRIBE `ports` 0.0050179958343506
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6126') 0.00065493583679199
(64) DESCRIBE `ports` 0.0041968822479248
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5649))) 0.00080585479736328
(66) DESCRIBE `ports` 0.002877950668335
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5649') 0.0012791156768799
(68) DESCRIBE `ports` 0.0063581466674805
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5649))) 0.0014750957489014
(70) DESCRIBE `ports` 0.0053927898406982
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5649') 0.0017650127410889
(72) DESCRIBE `avid_specials` 0.0069081783294678
(73) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81857 and class = 'Cruise') OR (item_id = 1581 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 52 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.0026068687438965
(74) DESCRIBE `cruiselines` 0.0038599967956543
(75) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00081801414489746
(76) DESCRIBE `orchid_image` 0.0032010078430176
(77) DESCRIBE `cruiselines` 0.006417989730835
(78) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0016791820526123
(79) DESCRIBE `cruises` 0.0070779323577881
(80) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49747') 0.0011529922485352
(81) DESCRIBE `ships` 0.0046041011810303
(82) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1038))) 0.00065398216247559
(83) DESCRIBE `ships` 0.0047981739044189
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1038') 0.00075697898864746
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00045490264892578
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004570484161377
(87) DESCRIBE `itineraries` 0.0025930404663086
(88) DESCRIBE `ports` 0.0030229091644287
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00079488754272461
(90) DESCRIBE `ports` 0.0033328533172607
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0010349750518799
(92) DESCRIBE `ports` 0.0030059814453125
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00075793266296387
(94) DESCRIBE `sailingdates` 0.003101110458374
(95) DESCRIBE `ports` 0.0029149055480957
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0011560916900635
(97) DESCRIBE `ports` 0.0033149719238281
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00092196464538574
(99) DESCRIBE `ports` 0.0027420520782471
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 967))) 0.00088381767272949
(101) DESCRIBE `ports` 0.0027990341186523
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '967') 0.00063395500183105
(103) DESCRIBE `ports` 0.0026199817657471
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2588))) 0.00069904327392578
(105) DESCRIBE `ports` 0.002892017364502
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2588') 0.0006108283996582
(107) DESCRIBE `ports` 0.0027930736541748
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 973))) 0.00067496299743652
(109) DESCRIBE `ports` 0.0027320384979248
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '973') 0.00067305564880371
(111) DESCRIBE `ports` 0.0027780532836914
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 975))) 0.00097298622131348
(113) DESCRIBE `ports` 0.0033559799194336
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '975') 0.00065779685974121
(115) DESCRIBE `ports` 0.0028960704803467
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2017))) 0.0013101100921631
(117) DESCRIBE `ports` 0.0031228065490723
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2017') 0.00058102607727051
(119) DESCRIBE `ports` 0.0027689933776855
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2016))) 0.00059700012207031
(121) DESCRIBE `ports` 0.0028891563415527
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2016') 0.00059986114501953
(123) DESCRIBE `ports` 0.0029029846191406
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 981))) 0.00083422660827637
(125) DESCRIBE `ports` 0.0027990341186523
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '981') 0.00063109397888184
(127) DESCRIBE `ports` 0.0028338432312012
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 981))) 0.0022189617156982
(129) DESCRIBE `ports` 0.0032250881195068
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '981') 0.0007481575012207
(131) DESCRIBE `avid_specials` 0.0027580261230469
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49747 and class = 'Cruise') OR (item_id = 1038 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00223708152771
(133) DESCRIBE `cruiselines` 0.0038518905639648
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0008540153503418
(135) DESCRIBE `orchid_image` 0.003187894821167
(136) DESCRIBE `cruiselines` 0.0040550231933594
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00078797340393066
(138) DESCRIBE `cruises` 0.0051219463348389
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57725') 0.00061583518981934
(140) DESCRIBE `ships` 0.0056090354919434
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1324))) 0.00075602531433105
(142) DESCRIBE `ships` 0.0043449401855469
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1324') 0.00077700614929199
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050783157348633
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005340576171875
(146) DESCRIBE `itineraries` 0.0025019645690918
(147) DESCRIBE `ports` 0.0021369457244873
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5081))) 0.00057315826416016
(149) DESCRIBE `ports` 0.0020451545715332
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5081))) 0.00053906440734863
(151) DESCRIBE `ports` 0.002338171005249
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5081') 0.00069713592529297
(153) DESCRIBE `sailingdates` 0.0072147846221924
(154) DESCRIBE `ports` 0.0028870105743408
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5081))) 0.00070095062255859
(156) DESCRIBE `ports` 0.0030739307403564
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5081') 0.00068092346191406
(158) DESCRIBE `ports` 0.0026171207427979
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00073695182800293
(160) DESCRIBE `ports` 0.002791166305542
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00057196617126465
(162) DESCRIBE `ports` 0.0026791095733643
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5082))) 0.00068116188049316
(164) DESCRIBE `ports` 0.003680944442749
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5082') 0.00080204010009766
(166) DESCRIBE `ports` 0.0033152103424072
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00069499015808105
(168) DESCRIBE `ports` 0.0027759075164795
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00065398216247559
(170) DESCRIBE `ports` 0.0028588771820068
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5083))) 0.00081300735473633
(172) DESCRIBE `ports` 0.0027320384979248
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5083') 0.00065183639526367
(174) DESCRIBE `ports` 0.0035600662231445
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00086307525634766
(176) DESCRIBE `ports` 0.0030231475830078
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00073003768920898
(178) DESCRIBE `ports` 0.0036110877990723
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5084))) 0.00088214874267578
(180) DESCRIBE `ports` 0.0030460357666016
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5084') 0.0012950897216797
(182) DESCRIBE `ports` 0.0031628608703613
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5081))) 0.00076198577880859
(184) DESCRIBE `ports` 0.0031759738922119
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5081') 0.00066709518432617
(186) DESCRIBE `avid_specials` 0.0022339820861816
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57725 and class = 'Cruise') OR (item_id = 1324 AND class = 'Ship') OR (item_id = 251 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021049976348877
(188) DESCRIBE `cruiselines` 0.0046942234039307
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 251))) 0.00074195861816406
(190) DESCRIBE `orchid_image` 0.0030579566955566
(191) DESCRIBE `cruiselines` 0.0032980442047119
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '251') 0.00053286552429199
(193) DESCRIBE `cruises` 0.0047521591186523
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59443') 0.00077605247497559
(195) DESCRIBE `ships` 0.0048699378967285
(196) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1424))) 0.00077986717224121
(197) DESCRIBE `ships` 0.0048179626464844
(198) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1424') 0.00064587593078613
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047206878662109
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046896934509277
(201) DESCRIBE `itineraries` 0.0024600028991699
(202) DESCRIBE `ports` 0.0025830268859863
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.0011730194091797
(204) DESCRIBE `ports` 0.0033509731292725
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00087213516235352
(206) DESCRIBE `ports` 0.0031380653381348
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00092005729675293
(208) DESCRIBE `sailingdates` 0.0027840137481689
(209) DESCRIBE `ports` 0.002938985824585
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00069499015808105
(211) DESCRIBE `ports` 0.0020110607147217
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00060701370239258
(213) DESCRIBE `ports` 0.017388105392456
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00072884559631348
(215) DESCRIBE `ports` 0.0029540061950684
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00070095062255859
(217) DESCRIBE `ports` 0.0026969909667969
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00069785118103027
(219) DESCRIBE `ports` 0.002791166305542
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.0006718635559082
(221) DESCRIBE `ports` 0.0025660991668701
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00062799453735352
(223) DESCRIBE `ports` 0.0025589466094971
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00058388710021973
(225) DESCRIBE `ports` 0.0026741027832031
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00065898895263672
(227) DESCRIBE `ports` 0.026012897491455
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00066590309143066
(229) DESCRIBE `ports` 0.01206111907959
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00081610679626465
(231) DESCRIBE `ports` 0.003187894821167
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00066399574279785
(233) DESCRIBE `ports` 0.0024929046630859
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00062179565429688
(235) DESCRIBE `ports` 0.0024228096008301
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00054693222045898
(237) DESCRIBE `ports` 0.0024130344390869
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00057101249694824
(239) DESCRIBE `ports` 0.0023279190063477
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00052499771118164
(241) DESCRIBE `ports` 0.0025649070739746
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.0031161308288574
(243) DESCRIBE `ports` 0.0032510757446289
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.0006871223449707
(245) DESCRIBE `ports` 0.002918004989624
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00064516067504883
(247) DESCRIBE `ports` 0.002769947052002
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.0011348724365234
(249) DESCRIBE `avid_specials` 0.0029380321502686
(250) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59443 and class = 'Cruise') OR (item_id = 1424 AND class = 'Ship') OR (item_id = 31 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022330284118652
(251) DESCRIBE `cruiselines` 0.0035920143127441
(252) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00069618225097656
(253) DESCRIBE `orchid_image` 0.0034759044647217
(254) DESCRIBE `cruiselines` 0.0033490657806396
(255) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00089502334594727
(256) DESCRIBE `cruises` 0.0049898624420166
(257) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61442') 0.00085902214050293
(258) DESCRIBE `ships` 0.0051178932189941
(259) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1366))) 0.0008389949798584
(260) DESCRIBE `ships` 0.0050079822540283
(261) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1366') 0.00074195861816406
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003960132598877
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047588348388672
(264) DESCRIBE `itineraries` 0.0026750564575195
(265) DESCRIBE `ports` 0.0029420852661133
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00066089630126953
(267) DESCRIBE `ports` 0.0031349658966064
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.0010228157043457
(269) DESCRIBE `ports` 0.0034370422363281
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00076007843017578
(271) DESCRIBE `sailingdates` 0.0036718845367432
(272) DESCRIBE `ports` 0.0033140182495117
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00062108039855957
(274) DESCRIBE `ports` 0.0026528835296631
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.0005791187286377
(276) DESCRIBE `ports` 0.0029630661010742
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00059795379638672
(278) DESCRIBE `ports` 0.0026440620422363
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00071310997009277
(280) DESCRIBE `ports` 0.0033509731292725
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00073695182800293
(282) DESCRIBE `ports` 0.003201961517334
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00066304206848145
(284) DESCRIBE `ports` 0.0030930042266846
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00066995620727539
(286) DESCRIBE `ports` 0.0026390552520752
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00061607360839844
(288) DESCRIBE `ports` 0.0025088787078857
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4236))) 0.00070810317993164
(290) DESCRIBE `ports` 0.002687931060791
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4236') 0.0007328987121582
(292) DESCRIBE `ports` 0.002892017364502
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00083708763122559
(294) DESCRIBE `ports` 0.0026280879974365
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00066804885864258
(296) DESCRIBE `ports` 0.0030620098114014
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00063014030456543
(298) DESCRIBE `ports` 0.002418041229248
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00043511390686035
(300) DESCRIBE `ports` 0.0026779174804688
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00065398216247559
(302) DESCRIBE `ports` 0.0023918151855469
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.0008080005645752
(304) DESCRIBE `avid_specials` 0.0023670196533203
(305) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61442 and class = 'Cruise') OR (item_id = 1366 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0023910999298096
(306) DESCRIBE `cruiselines` 0.004241943359375
(307) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00065708160400391
(308) DESCRIBE `orchid_image` 0.0027420520782471
(309) DESCRIBE `cruiselines` 0.0034289360046387
(310) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00054502487182617
(311) DESCRIBE `cruises` 0.0050849914550781
(312) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64035') 0.00057196617126465
(313) DESCRIBE `ships` 0.0044751167297363
(314) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1208))) 0.00069403648376465
(315) DESCRIBE `ships` 0.0040621757507324
(316) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1208') 0.00071287155151367
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00050187110900879
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00049901008605957
(319) DESCRIBE `itineraries` 0.0024590492248535
(320) DESCRIBE `ports` 0.0026061534881592
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00058603286743164
(322) DESCRIBE `ports` 0.0024678707122803
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00079202651977539
(324) DESCRIBE `ports` 0.0026640892028809
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00055098533630371
(326) DESCRIBE `sailingdates` 0.0021119117736816
(327) DESCRIBE `ports` 0.003115177154541
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00077605247497559
(329) DESCRIBE `ports` 0.0060989856719971
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0035610198974609
(331) DESCRIBE `ports` 0.0027830600738525
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0072908401489258
(333) DESCRIBE `ports` 0.003093957901001
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0006859302520752
(335) DESCRIBE `ports` 0.0036499500274658
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00072002410888672
(337) DESCRIBE `ports` 0.0028269290924072
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00059080123901367
(339) DESCRIBE `ports` 0.0030350685119629
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0010080337524414
(341) DESCRIBE `ports` 0.0030908584594727
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00076699256896973
(343) DESCRIBE `ports` 0.0028119087219238
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00054597854614258
(345) DESCRIBE `ports` 0.0024368762969971
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00063109397888184
(347) DESCRIBE `ports` 0.0024740695953369
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00070500373840332
(349) DESCRIBE `ports` 0.0031089782714844
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.00070381164550781
(351) DESCRIBE `ports` 0.0030980110168457
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00075197219848633
(353) DESCRIBE `ports` 0.0030279159545898
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00067496299743652
(355) DESCRIBE `ports` 0.0027420520782471
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00059700012207031
(357) DESCRIBE `ports` 0.0025360584259033
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00059986114501953
(359) DESCRIBE `avid_specials` 0.0024280548095703
(360) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64035 and class = 'Cruise') OR (item_id = 1208 AND class = 'Ship') OR (item_id = 262 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.0021958351135254
(361) DESCRIBE `cruiselines` 0.0035378932952881
(362) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.0010108947753906
(363) DESCRIBE `orchid_image` 0.0053598880767822
(364) DESCRIBE `cruiselines` 0.0034730434417725
(365) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.0006260871887207
(366) DESCRIBE `cruises` 0.0044839382171631
(367) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69593') 0.00069713592529297
(368) DESCRIBE `ships` 0.0046210289001465
(369) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 666))) 0.00073480606079102
(370) DESCRIBE `ships` 0.004662036895752
(371) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '666') 0.00058484077453613
(372) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050687789916992
(373) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043392181396484
(374) DESCRIBE `itineraries` 0.0026769638061523
(375) DESCRIBE `ports` 0.0025949478149414
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 33))) 0.00062394142150879
(377) DESCRIBE `ports` 0.0024220943450928
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 33))) 0.00056982040405273
(379) DESCRIBE `ports` 0.0024039745330811
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '33') 0.00053596496582031
(381) DESCRIBE `sailingdates` 0.0021300315856934
(382) DESCRIBE `ports` 0.002655029296875
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 33))) 0.0007469654083252
(384) DESCRIBE `ports` 0.0023579597473145
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '33') 0.00052595138549805
(386) DESCRIBE `ports` 0.0023419857025146
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 549))) 0.00055098533630371
(388) DESCRIBE `ports` 0.0066609382629395
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '549') 0.00073003768920898
(390) DESCRIBE `ports` 0.0024840831756592
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4944))) 0.00056886672973633
(392) DESCRIBE `ports` 0.0028128623962402
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4944') 0.00060677528381348
(394) DESCRIBE `ports` 0.0030651092529297
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4940))) 0.0009160041809082
(396) DESCRIBE `ports` 0.0027759075164795
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4940') 0.00062894821166992
(398) DESCRIBE `ports` 0.0028700828552246
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1967))) 0.00069594383239746
(400) DESCRIBE `ports` 0.0028691291809082
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1967') 0.00060009956359863
(402) DESCRIBE `ports` 0.0026600360870361
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 552))) 0.0007178783416748
(404) DESCRIBE `ports` 0.0027291774749756
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '552') 0.00066280364990234
(406) DESCRIBE `ports` 0.002392053604126
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4098))) 0.00062704086303711
(408) DESCRIBE `ports` 0.0027661323547363
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4098') 0.00055599212646484
(410) DESCRIBE `ports` 0.0023360252380371
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 33))) 0.00065302848815918
(412) DESCRIBE `ports` 0.0030868053436279
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '33') 0.00072503089904785
(414) DESCRIBE `avid_specials` 0.0029599666595459
(415) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69593 and class = 'Cruise') OR (item_id = 666 AND class = 'Ship') OR (item_id = 208 AND class = 'CruiseLine') OR (item_id = 2 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.0027458667755127
(416) DESCRIBE `cruiselines` 0.0033121109008789
(417) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.00066304206848145
(418) DESCRIBE `orchid_image` 0.0030860900878906
(419) DESCRIBE `cruiselines` 0.0030639171600342
(420) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.00058197975158691
(421) DESCRIBE `cruises` 0.0042049884796143
(422) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69909') 0.00072312355041504
(423) DESCRIBE `ships` 0.0048110485076904
(424) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1609))) 0.00068902969360352
(425) DESCRIBE `ships` 0.0045700073242188
(426) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1609') 0.00050902366638184
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003809928894043
(428) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037097930908203
(429) DESCRIBE `itineraries` 0.0022759437561035
(430) DESCRIBE `ports` 0.002230167388916
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00047612190246582
(432) DESCRIBE `ports` 0.0020768642425537
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00061392784118652
(434) DESCRIBE `ports` 0.0024111270904541
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00053715705871582
(436) DESCRIBE `sailingdates` 0.0021319389343262
(437) DESCRIBE `ports` 0.0028791427612305
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.0011789798736572
(439) DESCRIBE `ports` 0.0029380321502686
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0007481575012207
(441) DESCRIBE `ports` 0.0029938220977783
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.0006721019744873
(443) DESCRIBE `ports` 0.0028760433197021
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.0069129467010498
(445) DESCRIBE `ports` 0.0030570030212402
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00065708160400391
(447) DESCRIBE `ports` 0.0026979446411133
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.019302129745483
(449) DESCRIBE `ports` 0.0031640529632568
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00059103965759277
(451) DESCRIBE `ports` 0.0031239986419678
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.011870861053467
(453) DESCRIBE `ports` 0.0030248165130615
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3154))) 0.0088968276977539
(455) DESCRIBE `ports` 0.0028350353240967
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3154') 0.0077500343322754
(457) DESCRIBE `ports` 0.0095539093017578
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00071287155151367
(459) DESCRIBE `ports` 0.0028319358825684
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.0012598037719727
(461) DESCRIBE `ports` 0.002777099609375
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.0039219856262207
(463) DESCRIBE `ports` 0.0027689933776855
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.0059289932250977
(465) DESCRIBE `ports` 0.0027039051055908
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5687))) 0.00079202651977539
(467) DESCRIBE `ports` 0.0024490356445312
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5687') 0.0091550350189209
(469) DESCRIBE `ports` 0.0030229091644287
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.013253927230835
(471) DESCRIBE `ports` 0.0042409896850586
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00061488151550293
(473) DESCRIBE `ports` 0.0051369667053223
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.01296591758728
(475) DESCRIBE `ports` 0.0037591457366943
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00059604644775391
(477) DESCRIBE `ports` 0.0032460689544678
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.010278940200806
(479) DESCRIBE `ports` 0.0025758743286133
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0031960010528564
(481) DESCRIBE `avid_specials` 0.0061590671539307
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69909 and class = 'Cruise') OR (item_id = 1609 AND class = 'Ship') OR (item_id = 49 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0068330764770508
(483) DESCRIBE `cruiselines` 0.0035529136657715
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 49))) 0.0081908702850342
(485) DESCRIBE `orchid_image` 0.0027890205383301
(486) DESCRIBE `cruiselines` 0.0095059871673584
(487) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '49') 0.0076138973236084
(488) DESCRIBE `cruises` 0.0083601474761963
(489) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70068') 0.0043008327484131
(490) DESCRIBE `ships` 0.0080480575561523
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1445))) 0.007519006729126
(492) DESCRIBE `ships` 0.0045409202575684
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1445') 0.010396957397461
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004279613494873
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044393539428711
(496) DESCRIBE `itineraries` 0.0053470134735107
(497) DESCRIBE `ports` 0.011425971984863
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.0010850429534912
(499) DESCRIBE `ports` 0.0033597946166992
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00071310997009277
(501) DESCRIBE `ports` 0.0029110908508301
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00058293342590332
(503) DESCRIBE `sailingdates` 0.002504825592041
(504) DESCRIBE `ports` 0.0033109188079834
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00077414512634277
(506) DESCRIBE `ports` 0.0027728080749512
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00062394142150879
(508) DESCRIBE `ports` 0.0042450428009033
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00079703330993652
(510) DESCRIBE `ports` 0.003061056137085
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0019969940185547
(512) DESCRIBE `ports` 0.0040290355682373
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00084805488586426
(514) DESCRIBE `ports` 0.0044059753417969
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00083208084106445
(516) DESCRIBE `ports` 0.0025129318237305
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00052809715270996
(518) DESCRIBE `ports` 0.0022900104522705
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00053501129150391
(520) DESCRIBE `ports` 0.0021538734436035
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.0005638599395752
(522) DESCRIBE `ports` 0.0027470588684082
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00053787231445312
(524) DESCRIBE `ports` 0.002479076385498
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00072908401489258
(526) DESCRIBE `ports` 0.0028088092803955
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00056195259094238
(528) DESCRIBE `ports` 0.0024480819702148
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00063300132751465
(530) DESCRIBE `ports` 0.0027439594268799
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00047206878662109
(532) DESCRIBE `ports` 0.0023560523986816
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00062084197998047
(534) DESCRIBE `ports` 0.0026559829711914
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0013110637664795
(536) DESCRIBE `ports` 0.0031869411468506
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00059819221496582
(538) DESCRIBE `ports` 0.0032191276550293
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00061202049255371
(540) DESCRIBE `ports` 0.0026929378509521
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00062203407287598
(542) DESCRIBE `ports` 0.0028560161590576
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00053095817565918
(544) DESCRIBE `avid_specials` 0.0031800270080566
(545) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70068 and class = 'Cruise') OR (item_id = 1445 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0025579929351807
(546) DESCRIBE `cruiselines` 0.0061190128326416
(547) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00067281723022461
(548) DESCRIBE `orchid_image` 0.002964973449707
(549) DESCRIBE `cruiselines` 0.0042598247528076
(550) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00055885314941406
(551) DESCRIBE `cruises` 0.0051188468933105
(552) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70981') 0.0034480094909668
(553) DESCRIBE `ships` 0.004979133605957
(554) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 643))) 0.00076889991760254
(555) DESCRIBE `ships` 0.0051360130310059
(556) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '643') 0.00072193145751953
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00060796737670898
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00056099891662598
(559) DESCRIBE `itineraries` 0.0026710033416748
(560) DESCRIBE `ports` 0.0028040409088135
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00064992904663086
(562) DESCRIBE `ports` 0.0028929710388184
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00067687034606934
(564) DESCRIBE `ports` 0.0035800933837891
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00050806999206543
(566) DESCRIBE `sailingdates` 0.0029799938201904
(567) DESCRIBE `ports` 0.0030229091644287
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00057291984558105
(569) DESCRIBE `ports` 0.0024127960205078
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00048613548278809
(571) DESCRIBE `ports` 0.0024290084838867
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00053215026855469
(573) DESCRIBE `ports` 0.0026309490203857
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00063705444335938
(575) DESCRIBE `ports` 0.0029749870300293
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00061798095703125
(577) DESCRIBE `ports` 0.0025110244750977
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00050187110900879
(579) DESCRIBE `ports` 0.0025448799133301
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00066614151000977
(581) DESCRIBE `ports` 0.0033068656921387
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00049805641174316
(583) DESCRIBE `ports` 0.0025279521942139
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00053000450134277
(585) DESCRIBE `ports` 0.0023510456085205
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00048995018005371
(587) DESCRIBE `ports` 0.0039749145507812
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4321))) 0.00081706047058105
(589) DESCRIBE `ports` 0.0053629875183105
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4321') 0.00077509880065918
(591) DESCRIBE `ports` 0.0024890899658203
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4321))) 0.00064802169799805
(593) DESCRIBE `ports` 0.0031661987304688
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4321') 0.00061202049255371
(595) DESCRIBE `ports` 0.0032849311828613
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5742))) 0.0012149810791016
(597) DESCRIBE `ports` 0.0026659965515137
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5742') 0.00061702728271484
(599) DESCRIBE `ports` 0.0034160614013672
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00062704086303711
(601) DESCRIBE `ports` 0.0027539730072021
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.0006098747253418
(603) DESCRIBE `ports` 0.0025119781494141
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00074195861816406
(605) DESCRIBE `ports` 0.0028820037841797
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00058794021606445
(607) DESCRIBE `ports` 0.0025069713592529
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00057697296142578
(609) DESCRIBE `ports` 0.0023880004882812
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00051689147949219
(611) DESCRIBE `avid_specials` 0.0034871101379395
(612) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70981 and class = 'Cruise') OR (item_id = 643 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0028970241546631
(613) DESCRIBE `cruiselines` 0.0043740272521973
(614) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00062704086303711
(615) DESCRIBE `orchid_image` 0.0029621124267578
(616) DESCRIBE `cruiselines` 0.0042800903320312
(617) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00068306922912598
(618) DESCRIBE `cruiselines` 0.0041100978851318
(619) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '144', '12', '23', '183', '20', '101', '120', '31', '18', '8', '131', '7', '96', '171', '170', '103', '206', '33', '156', '15', '50', '262', '191', '29', '195', '258', '91', '16', '37', '153', '14', '28', '24', '208', '187', '36', '114', '47', '49', '251', '141', '88', '212', '151', '181', '110', '118', '4', '264', '30', '216', '59', '140', '108', '115', '73', '159', '48', '211', '213', '147', '35', '38', '113', '276', '90', '95', '180', '57', '52', '244', '64', '172', '257', '261', '184', '82', '134', '245', '105', '177', '209')) ORDER BY FIND_IN_SET(id, '77,218,19,26,144,12,23,183,20,101,120,31,18,8,131,7,96,171,170,103,206,33,156,15,50,262,191,29,195,258,91,16,37,153,14,28,24,208,187,36,114,47,49,251,141,88,212,151,181,110,118,4,264,30,216,59,140,108,115,73,159,48,211,213,147,35,38,113,276,90,95,180,57,52,244,64,172,257,261,184,82,134,245,105,177,209') 0.0078890323638916
(620) DESCRIBE `ships` 0.00506591796875
(621) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '517', '1744', '732', '737', '1417', '726', '1324', '1554', '1588', '207', '1555', '1794', '1594', '454', '977', '1717', '521', '780', '1237', '1272', '974', '871', '258', '1032', '1359', '1424', '797', '265', '22', '404', '461', '21', '330', '770', '1292', '393', '28', '716', '1766', '1348', '1677', '1419', '1423', '520', '1420', '1422', '1418', '1421', '349', '857', '1205', '858', '1415', '1501', '333', '11', '986', '1682', '715', '738', '1067', '439', '739', '9', '10', '674', '25', '24', '855', '163', '837', '542', '1260', '1678', '455', '3', '1607', '882', '1768', '1008', '113', '407', '1402', '434', '1141', '610', '1135', '1773', '553', '480', '627', '332', '503', '792', '1742', '573', '1569', '160', '352', '386', '766', '817', '1454', '63', '1455', '66', '1721', '711', '1168', '1233', '1372', '1602', '198', '626', '657', '883', '1021', '1284', '285', '385', '585', '1413', '1410', '1599', '1302', '1411', '462', '1193', '1308', '1738', '111', '124', '526', '1259', '1266', '1320', '1323', '1579', '314', '1822', '286', '970', '1811', '43', '854', '1088', '327', '390', '582', '590', '1063', '1552', '1733', '485', '1145', '1586', '441', '748', '1068', '405', '944', '1321', '34', '38', '791', '1149', '31', '37', '119', '1492', '1722', '70', '678', '958', '1208', '1245', '1291', '1463', '1587', '1782', '14', '114', '162', '378', '406', '545', '616', '1028', '1711', '4', '351', '644', '658', '1027', '1412', '69', '335', '635', '850', '1157', '1672', '451', '1289', '1318', '1139', '1199', '1303', '1319', '401', '704', '1461', '341', '547', '722', '1108', '340', '580', '701', '1236', '1398', '105', '325', '403', '683', '1330', '601', '652', '966', '1013', '1408', '98', '148', '508', '1159', '1188', '1326', '1327', '1367', '1526', '201', '394', '651', '1151', '1575', '287', '348', '389', '818', '1172', '78', '291', '639', '1040', '39', '212', '338', '776', '1019', '1801', '30', '35', '36', '84', '123', '262', '988', '1012', '1037', '1043', '1743', '1809', '852', '1223', '1344', '1426', '1715', '27', '45', '266', '290', '673', '775', '1160', '1217', '1405', '1704', '1716', '1808', '483', '751', '1029', '1143', '1144', '1163', '1343', '1452', '1453', '1226', '1229', '1282', '1325', '1373', '1604', '574', '1358', '1724', '1730', '768', '968', '1095', '1283', '1409', '1740', '1772', '82', '905', '1035', '1137', '1152', '417', '769', '972', '1136', '1448', '108', '223', '253', '709', '1025', '1045', '1055', '1090', '1150', '1474', '151', '324', '851', '885', '1026', '1206', '1351', '150', '643', '663', '973', '1681', '1771', '116', '559', '884', '1230', '1231', '1458', '1713', '1750', '954', '1048', '1154', '1366', '1676', '1714', '1751', '1042', '1071', '1368', '1632', '1723', '208', '467', '665', '666', '924', '1049', '1196', '1322', '1360', '1361', '1362', '1459', '1708', '93', '784', '790', '920', '1051', '1052', '1140', '1148', '1483', '1609', '1649', '423', '921', '923', '996', '1293', '1301', '1580', '703', '888', '915', '1072', '1352', '1758', '147', '453', '916', '926', '930', '931', '1020', '1146', '1274', '1329', '75', '707', '1047', '1224', '1340', '1596', '1601', '1679', '1807', '1833', '205', '796', '886', '1004', '1039', '1073', '1109', '1241', '1262', '1389', '1445', '1468', '1519', '1539', '1571', '1791', '152', '422', '717', '1036', '1050', '1339', '1350', '516', '1054', '1075', '1486', '1574', '1749', '149', '730', '1044', '1294', '1759', '1767', '1788', '1806', '74', '81', '300', '656', '671', '672', '1232', '1256', '1572', '1664', '1673', '1816', '299', '1005', '1060', '1138', '1437', '1451', '1540', '1781', '1805', '420', '795', '821', '1225', '1254', '1444', '1823', '375', '448', '487', '743', '761', '982', '1011', '1663', '419', '493')) ORDER BY FIND_IN_SET(id, '1761,517,1744,732,737,1417,726,1324,1554,1588,207,1555,1794,1594,454,977,1717,521,780,1237,1272,974,871,258,1032,1359,1424,797,265,22,404,461,21,330,770,1292,393,28,716,1766,1348,1677,1419,1423,520,1420,1422,1418,1421,349,857,1205,858,1415,1501,333,11,986,1682,715,738,1067,439,739,9,10,674,25,24,855,163,837,542,1260,1678,455,3,1607,882,1768,1008,113,407,1402,434,1141,610,1135,1773,553,480,627,332,503,792,1742,573,1569,160,352,386,766,817,1454,63,1455,66,1721,711,1168,1233,1372,1602,198,626,657,883,1021,1284,285,385,585,1413,1410,1599,1302,1411,462,1193,1308,1738,111,124,526,1259,1266,1320,1323,1579,314,1822,286,970,1811,43,854,1088,327,390,582,590,1063,1552,1733,485,1145,1586,441,748,1068,405,944,1321,34,38,791,1149,31,37,119,1492,1722,70,678,958,1208,1245,1291,1463,1587,1782,14,114,162,378,406,545,616,1028,1711,4,351,644,658,1027,1412,69,335,635,850,1157,1672,451,1289,1318,1139,1199,1303,1319,401,704,1461,341,547,722,1108,340,580,701,1236,1398,105,325,403,683,1330,601,652,966,1013,1408,98,148,508,1159,1188,1326,1327,1367,1526,201,394,651,1151,1575,287,348,389,818,1172,78,291,639,1040,39,212,338,776,1019,1801,30,35,36,84,123,262,988,1012,1037,1043,1743,1809,852,1223,1344,1426,1715,27,45,266,290,673,775,1160,1217,1405,1704,1716,1808,483,751,1029,1143,1144,1163,1343,1452,1453,1226,1229,1282,1325,1373,1604,574,1358,1724,1730,768,968,1095,1283,1409,1740,1772,82,905,1035,1137,1152,417,769,972,1136,1448,108,223,253,709,1025,1045,1055,1090,1150,1474,151,324,851,885,1026,1206,1351,150,643,663,973,1681,1771,116,559,884,1230,1231,1458,1713,1750,954,1048,1154,1366,1676,1714,1751,1042,1071,1368,1632,1723,208,467,665,666,924,1049,1196,1322,1360,1361,1362,1459,1708,93,784,790,920,1051,1052,1140,1148,1483,1609,1649,423,921,923,996,1293,1301,1580,703,888,915,1072,1352,1758,147,453,916,926,930,931,1020,1146,1274,1329,75,707,1047,1224,1340,1596,1601,1679,1807,1833,205,796,886,1004,1039,1073,1109,1241,1262,1389,1445,1468,1519,1539,1571,1791,152,422,717,1036,1050,1339,1350,516,1054,1075,1486,1574,1749,149,730,1044,1294,1759,1767,1788,1806,74,81,300,656,671,672,1232,1256,1572,1664,1673,1816,299,1005,1060,1138,1437,1451,1540,1781,1805,420,795,821,1225,1254,1444,1823,375,448,487,743,761,982,1011,1663,419,493') 0.097702026367188
(622) DESCRIBE `cruisetypes` 0.0040779113769531
(623) DESCRIBE `destinations` 0.004061222076416
(624) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '37', '2', '8', '44', '53', '55', '39', '28', '38', '26', '11', '40', '48', '7', '45', '21', '29', '49', '30', '34', '52', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,37,2,8,44,53,55,39,28,38,26,11,40,48,7,45,21,29,49,30,34,52,10,46,56,32') 0.0040979385375977