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

Total elapsed time: 2.1339356899261

# Query Time
(1) connect 0.010838985443115
(2) DESCRIBE `cruises` 0.0045409202575684
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62438, 26401, 72232, 72159, 72157, 72154, 72153, 72247, 26399, 72163)) ORDER BY FIND_IN_SET(id, '62438,26401,72232,72159,72157,72154,72153,72247,26399,72163') 0.0022730827331543
(4) DESCRIBE `cruises` 0.0090188980102539
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62438') 0.00048017501831055
(6) DESCRIBE `ships` 0.0048260688781738
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.0072720050811768
(8) DESCRIBE `ships` 0.0036628246307373
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.00049495697021484
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035405158996582
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003819465637207
(12) DESCRIBE `itineraries` 0.0020420551300049
(13) DESCRIBE `ports` 0.008368968963623
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00056886672973633
(15) DESCRIBE `ports` 0.0020840167999268
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00046706199645996
(17) DESCRIBE `ports` 0.0052731037139893
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.012195110321045
(19) DESCRIBE `sailingdates` 0.0024118423461914
(20) DESCRIBE `ports` 0.0031211376190186
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00048995018005371
(22) DESCRIBE `ports` 0.002410888671875
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0082159042358398
(24) DESCRIBE `ports` 0.0018541812896729
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00041699409484863
(26) DESCRIBE `ports` 0.0016839504241943
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00037288665771484
(28) DESCRIBE `ports` 0.0018489360809326
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00042319297790527
(30) DESCRIBE `ports` 0.0018198490142822
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0078670978546143
(32) DESCRIBE `avid_specials` 0.0018031597137451
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62438 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 38 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.0011780261993408
(34) DESCRIBE `cruiselines` 0.0026848316192627
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00044798851013184
(36) DESCRIBE `orchid_image` 0.012818098068237
(37) DESCRIBE `cruiselines` 0.0025539398193359
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00058388710021973
(39) DESCRIBE `cruises` 0.017294883728027
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '26401') 0.00098800659179688
(41) DESCRIBE `ships` 0.0055129528045654
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.0058648586273193
(43) DESCRIBE `ships` 0.008681058883667
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.000946044921875
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0006101131439209
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00061392784118652
(47) DESCRIBE `itineraries` 0.0030357837677002
(48) DESCRIBE `ports` 0.0081369876861572
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00075292587280273
(50) DESCRIBE `ports` 0.0087471008300781
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0028669834136963
(52) DESCRIBE `ports` 0.0039820671081543
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0073959827423096
(54) DESCRIBE `sailingdates` 0.0025219917297363
(55) DESCRIBE `ports` 0.0029261112213135
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00066804885864258
(57) DESCRIBE `ports` 0.002918004989624
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0052011013031006
(59) DESCRIBE `ports` 0.0028831958770752
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0091629028320312
(61) DESCRIBE `ports` 0.0029129981994629
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00057697296142578
(63) DESCRIBE `avid_specials` 0.0025069713592529
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 26401 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 38 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.010208129882812
(65) DESCRIBE `cruiselines` 0.0040009021759033
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.012168884277344
(67) DESCRIBE `orchid_image` 0.0030732154846191
(68) DESCRIBE `cruiselines` 0.0039842128753662
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0086758136749268
(70) DESCRIBE `cruises` 0.005126953125
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72232') 0.012861013412476
(72) DESCRIBE `ships` 0.0055768489837646
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 585))) 0.0090649127960205
(74) DESCRIBE `ships` 0.0053107738494873
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '585') 0.0083370208740234
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005040168762207
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049400329589844
(78) DESCRIBE `itineraries` 0.0029840469360352
(79) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72232') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0082879066467285
(80) DESCRIBE `ports` 0.0024669170379639
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00047898292541504
(82) DESCRIBE `ports` 0.0018270015716553
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0030689239501953
(84) DESCRIBE `ports` 0.0029480457305908
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0051510334014893
(86) DESCRIBE `sailingdates` 0.0018360614776611
(87) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72232') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.009019136428833
(88) DESCRIBE `ports` 0.0019838809967041
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0006411075592041
(90) DESCRIBE `ports` 0.0021169185638428
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00037884712219238
(92) DESCRIBE `ports` 0.0026929378509521
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00045108795166016
(94) DESCRIBE `ports` 0.0087499618530273
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00038790702819824
(96) DESCRIBE `ports` 0.002068042755127
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00049614906311035
(98) DESCRIBE `ports` 0.0025229454040527
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00046205520629883
(100) DESCRIBE `ports` 0.0020480155944824
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00043892860412598
(102) DESCRIBE `ports` 0.0019237995147705
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00055289268493652
(104) DESCRIBE `ports` 0.001802921295166
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00043010711669922
(106) DESCRIBE `ports` 0.0019888877868652
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00047183036804199
(108) DESCRIBE `ports` 0.001884937286377
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00042390823364258
(110) DESCRIBE `ports` 0.0020420551300049
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0003969669342041
(112) DESCRIBE `ports` 0.0019469261169434
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00054287910461426
(114) DESCRIBE `ports` 0.0019309520721436
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00039887428283691
(116) DESCRIBE `ports` 0.0021119117736816
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 653))) 0.00051689147949219
(118) DESCRIBE `ports` 0.009390115737915
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '653') 0.00039100646972656
(120) DESCRIBE `ports` 0.0018351078033447
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00044512748718262
(122) DESCRIBE `ports` 0.0023739337921143
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0066180229187012
(124) DESCRIBE `avid_specials` 0.0022890567779541
(125) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72232 and class = 'Cruise') OR (item_id = 585 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 26 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.0021939277648926
(126) DESCRIBE `cruiselines` 0.0099658966064453
(127) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00059890747070312
(128) DESCRIBE `orchid_image` 0.0030031204223633
(129) DESCRIBE `cruiselines` 0.0037219524383545
(130) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00053501129150391
(131) DESCRIBE `cruises` 0.010286092758179
(132) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72159') 0.00090384483337402
(133) DESCRIBE `ships` 0.0082581043243408
(134) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.0011501312255859
(135) DESCRIBE `ships` 0.0037851333618164
(136) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.0040090084075928
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036215782165527
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052595138549805
(139) DESCRIBE `itineraries` 0.0018448829650879
(140) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72159') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00091409683227539
(141) DESCRIBE `ports` 0.0020270347595215
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00059413909912109
(143) DESCRIBE `ports` 0.0020649433135986
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00041913986206055
(145) DESCRIBE `ports` 0.0018589496612549
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00050783157348633
(147) DESCRIBE `sailingdates` 0.0017948150634766
(148) DESCRIBE `ports` 0.012335062026978
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00047802925109863
(150) DESCRIBE `ports` 0.0020039081573486
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0044040679931641
(152) DESCRIBE `ports` 0.0026900768280029
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0093510150909424
(154) DESCRIBE `ports` 0.0026538372039795
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00058412551879883
(156) DESCRIBE `ports` 0.0047070980072021
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.0056941509246826
(158) DESCRIBE `ports` 0.002518892288208
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.005932092666626
(160) DESCRIBE `ports` 0.0023269653320312
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2160))) 0.0052399635314941
(162) DESCRIBE `ports` 0.0020310878753662
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2160') 0.00130295753479
(164) DESCRIBE `ports` 0.0072741508483887
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3558))) 0.00056982040405273
(166) DESCRIBE `ports` 0.0017869472503662
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3558') 0.0025050640106201
(168) DESCRIBE `ports` 0.0093619823455811
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00061702728271484
(170) DESCRIBE `ports` 0.0020511150360107
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00042009353637695
(172) DESCRIBE `ports` 0.0021960735321045
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00046396255493164
(174) DESCRIBE `ports` 0.0018911361694336
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00039911270141602
(176) DESCRIBE `ports` 0.002223014831543
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00060105323791504
(178) DESCRIBE `ports` 0.010501146316528
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00041794776916504
(180) DESCRIBE `ports` 0.0021169185638428
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.00055885314941406
(182) DESCRIBE `ports` 0.002100944519043
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.0010769367218018
(184) DESCRIBE `ports` 0.0023970603942871
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00044083595275879
(186) DESCRIBE `ports` 0.0020239353179932
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0081989765167236
(188) DESCRIBE `ports` 0.0020561218261719
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00047993659973145
(190) DESCRIBE `ports` 0.001878023147583
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00043392181396484
(192) DESCRIBE `ports` 0.0020298957824707
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0065348148345947
(194) DESCRIBE `ports` 0.0026440620422363
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00060701370239258
(196) DESCRIBE `ports` 0.0018148422241211
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00046706199645996
(198) DESCRIBE `ports` 0.0019750595092773
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.009443998336792
(200) DESCRIBE `ports` 0.0026469230651855
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00045299530029297
(202) DESCRIBE `ports` 0.002086877822876
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00044798851013184
(204) DESCRIBE `avid_specials` 0.0017640590667725
(205) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72159 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 11 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.0014970302581787
(206) DESCRIBE `cruiselines` 0.0099039077758789
(207) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0005490779876709
(208) DESCRIBE `orchid_image` 0.0019879341125488
(209) DESCRIBE `cruiselines` 0.0027837753295898
(210) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0084218978881836
(211) DESCRIBE `cruises` 0.00384521484375
(212) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72157') 0.00047683715820312
(213) DESCRIBE `ships` 0.0067751407623291
(214) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.0072479248046875
(215) DESCRIBE `ships` 0.0041089057922363
(216) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.00042486190795898
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040006637573242
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035285949707031
(219) DESCRIBE `itineraries` 0.0017910003662109
(220) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72157') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0060319900512695
(221) DESCRIBE `ports` 0.0018949508666992
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00046396255493164
(223) DESCRIBE `ports` 0.0018560886383057
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00043797492980957
(225) DESCRIBE `ports` 0.0020320415496826
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0072901248931885
(227) DESCRIBE `sailingdates` 0.0028440952301025
(228) DESCRIBE `ports` 0.0022451877593994
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0078058242797852
(230) DESCRIBE `ports` 0.0020730495452881
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00048303604125977
(232) DESCRIBE `ports` 0.0024678707122803
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00052309036254883
(234) DESCRIBE `ports` 0.0083639621734619
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00047397613525391
(236) DESCRIBE `ports` 0.0019259452819824
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00051283836364746
(238) DESCRIBE `ports` 0.0018830299377441
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.0086021423339844
(240) DESCRIBE `ports` 0.0024449825286865
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2160))) 0.00059700012207031
(242) DESCRIBE `ports` 0.0019810199737549
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2160') 0.00040888786315918
(244) DESCRIBE `ports` 0.0020670890808105
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3558))) 0.00048494338989258
(246) DESCRIBE `ports` 0.0018398761749268
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3558') 0.0017290115356445
(248) DESCRIBE `ports` 0.0099380016326904
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00055503845214844
(250) DESCRIBE `ports` 0.0020248889923096
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00041484832763672
(252) DESCRIBE `ports` 0.0020420551300049
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00045180320739746
(254) DESCRIBE `ports` 0.0019090175628662
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0072240829467773
(256) DESCRIBE `ports` 0.0020830631256104
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0004730224609375
(258) DESCRIBE `ports` 0.0022001266479492
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00047183036804199
(260) DESCRIBE `ports` 0.0018200874328613
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.0095241069793701
(262) DESCRIBE `ports` 0.0020899772644043
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.00045394897460938
(264) DESCRIBE `ports` 0.0019409656524658
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00044894218444824
(266) DESCRIBE `ports` 0.0021741390228271
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00039196014404297
(268) DESCRIBE `ports` 0.0019900798797607
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.0063159465789795
(270) DESCRIBE `ports` 0.0022928714752197
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00049114227294922
(272) DESCRIBE `ports` 0.0022358894348145
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0058751106262207
(274) DESCRIBE `ports` 0.0023000240325928
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00060200691223145
(276) DESCRIBE `ports` 0.0024750232696533
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0082271099090576
(278) DESCRIBE `ports` 0.0020740032196045
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00044989585876465
(280) DESCRIBE `avid_specials` 0.0017521381378174
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72157 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 11 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.001317024230957
(282) DESCRIBE `cruiselines` 0.0027549266815186
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0082859992980957
(284) DESCRIBE `orchid_image` 0.0024311542510986
(285) DESCRIBE `cruiselines` 0.0027871131896973
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00047516822814941
(287) DESCRIBE `cruises` 0.0039069652557373
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72154') 0.0070929527282715
(289) DESCRIBE `ships` 0.0039031505584717
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.00052118301391602
(291) DESCRIBE `ships` 0.0038199424743652
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.0072340965270996
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040602684020996
(295) DESCRIBE `itineraries` 0.0020549297332764
(296) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72154') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066804885864258
(297) DESCRIBE `ports` 0.0046160221099854
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0005190372467041
(299) DESCRIBE `ports` 0.0021641254425049
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00064301490783691
(301) DESCRIBE `ports` 0.002877950668335
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0069589614868164
(303) DESCRIBE `sailingdates` 0.0026109218597412
(304) DESCRIBE `ports` 0.00211501121521
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00069594383239746
(306) DESCRIBE `ports` 0.0020978450775146
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00046801567077637
(308) DESCRIBE `ports` 0.0019581317901611
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0041649341583252
(310) DESCRIBE `ports` 0.0028591156005859
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0005030632019043
(312) DESCRIBE `ports` 0.0019669532775879
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00047707557678223
(314) DESCRIBE `ports` 0.0026140213012695
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.0088241100311279
(316) DESCRIBE `ports` 0.0028769969940186
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2160))) 0.00060391426086426
(318) DESCRIBE `ports` 0.0028500556945801
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2160') 0.0075218677520752
(320) DESCRIBE `ports` 0.0021500587463379
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3558))) 0.00053811073303223
(322) DESCRIBE `ports` 0.001845121383667
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3558') 0.00038385391235352
(324) DESCRIBE `ports` 0.0019600391387939
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00045084953308105
(326) DESCRIBE `ports` 0.0022208690643311
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0067300796508789
(328) DESCRIBE `ports` 0.0027539730072021
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00062894821166992
(330) DESCRIBE `ports` 0.0026938915252686
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00051593780517578
(332) DESCRIBE `ports` 0.014458894729614
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00078105926513672
(334) DESCRIBE `ports` 0.0029258728027344
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00078606605529785
(336) DESCRIBE `ports` 0.0026957988739014
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.00062680244445801
(338) DESCRIBE `ports` 0.0028190612792969
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.00060796737670898
(340) DESCRIBE `ports` 0.0028150081634521
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00063395500183105
(342) DESCRIBE `ports` 0.0027651786804199
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00054597854614258
(344) DESCRIBE `ports` 0.0027029514312744
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00066208839416504
(346) DESCRIBE `ports` 0.0025908946990967
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00064897537231445
(348) DESCRIBE `ports` 0.0026960372924805
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00062799453735352
(350) DESCRIBE `ports` 0.0027260780334473
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00074195861816406
(352) DESCRIBE `avid_specials` 0.0034430027008057
(353) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72154 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022380352020264
(354) DESCRIBE `cruiselines` 0.0038919448852539
(355) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00054097175598145
(356) DESCRIBE `orchid_image` 0.0027949810028076
(357) DESCRIBE `cruiselines` 0.0027079582214355
(358) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00041794776916504
(359) DESCRIBE `cruises` 0.0034351348876953
(360) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72153') 0.00045990943908691
(361) DESCRIBE `ships` 0.0034780502319336
(362) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.00062394142150879
(363) DESCRIBE `ships` 0.0036070346832275
(364) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.00044894218444824
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047993659973145
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042200088500977
(367) DESCRIBE `itineraries` 0.0018010139465332
(368) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72153') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064182281494141
(369) DESCRIBE `ports` 0.00331711769104
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00050711631774902
(371) DESCRIBE `ports` 0.0020101070404053
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00054097175598145
(373) DESCRIBE `ports` 0.0020551681518555
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0023050308227539
(375) DESCRIBE `sailingdates` 0.0017681121826172
(376) DESCRIBE `ports` 0.0089149475097656
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00046110153198242
(378) DESCRIBE `ports` 0.0019669532775879
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00037288665771484
(380) DESCRIBE `ports` 0.0026578903198242
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0060348510742188
(382) DESCRIBE `ports` 0.0018248558044434
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00037717819213867
(384) DESCRIBE `ports` 0.0018651485443115
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00038313865661621
(386) DESCRIBE `ports` 0.0027320384979248
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.0027351379394531
(388) DESCRIBE `ports` 0.0020568370819092
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2160))) 0.0053470134735107
(390) DESCRIBE `ports` 0.0018041133880615
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2160') 0.00046801567077637
(392) DESCRIBE `ports` 0.0085570812225342
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3558))) 0.00050020217895508
(394) DESCRIBE `ports` 0.0025520324707031
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3558') 0.00043392181396484
(396) DESCRIBE `ports` 0.0019850730895996
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00041794776916504
(398) DESCRIBE `ports` 0.0071167945861816
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00037884712219238
(400) DESCRIBE `ports` 0.0019030570983887
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0005497932434082
(402) DESCRIBE `ports` 0.0019049644470215
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00037121772766113
(404) DESCRIBE `avid_specials` 0.0016269683837891
(405) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72153 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 11 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.008336067199707
(406) DESCRIBE `cruiselines` 0.0082030296325684
(407) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00045299530029297
(408) DESCRIBE `orchid_image` 0.0027401447296143
(409) DESCRIBE `cruiselines` 0.0092918872833252
(410) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0004727840423584
(411) DESCRIBE `cruises` 0.0043721199035645
(412) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72247') 0.0055367946624756
(413) DESCRIBE `ships` 0.0037169456481934
(414) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.003209114074707
(415) DESCRIBE `ships` 0.0090179443359375
(416) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00064802169799805
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00058889389038086
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047898292541504
(419) DESCRIBE `itineraries` 0.0029339790344238
(420) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72247') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0098638534545898
(421) DESCRIBE `ports` 0.0061869621276855
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00043916702270508
(423) DESCRIBE `ports` 0.0024299621582031
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0005028247833252
(425) DESCRIBE `ports` 0.0049560070037842
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0016119480133057
(427) DESCRIBE `sailingdates` 0.0019049644470215
(428) DESCRIBE `ports` 0.0080490112304688
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0011999607086182
(430) DESCRIBE `ports` 0.015775918960571
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.01271390914917
(432) DESCRIBE `ports` 0.0028150081634521
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.013894081115723
(434) DESCRIBE `ports` 0.0039131641387939
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0035579204559326
(436) DESCRIBE `ports` 0.0067028999328613
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.0086119174957275
(438) DESCRIBE `ports` 0.0028970241546631
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.01123309135437
(440) DESCRIBE `ports` 0.0029828548431396
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 638))) 0.0054588317871094
(442) DESCRIBE `ports` 0.019109010696411
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '638') 0.00068092346191406
(444) DESCRIBE `ports` 0.0056300163269043
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.013550043106079
(446) DESCRIBE `ports` 0.0069160461425781
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00045609474182129
(448) DESCRIBE `ports` 0.012643098831177
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00072216987609863
(450) DESCRIBE `ports` 0.0041818618774414
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.012017011642456
(452) DESCRIBE `ports` 0.0064210891723633
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 657))) 0.0015008449554443
(454) DESCRIBE `ports` 0.017340898513794
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '657') 0.004688024520874
(456) DESCRIBE `ports` 0.0099139213562012
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0041329860687256
(458) DESCRIBE `ports` 0.0028650760650635
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0040030479431152
(460) DESCRIBE `ports` 0.013684034347534
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.001755952835083
(462) DESCRIBE `ports` 0.0034279823303223
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0042710304260254
(464) DESCRIBE `avid_specials` 0.0051770210266113
(465) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72247 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 25 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.001957893371582
(466) DESCRIBE `cruiselines` 0.0049209594726562
(467) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0016951560974121
(468) DESCRIBE `orchid_image` 0.0037431716918945
(469) DESCRIBE `cruiselines` 0.0056400299072266
(470) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.004021167755127
(471) DESCRIBE `cruises` 0.0035219192504883
(472) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '26399') 0.0038700103759766
(473) DESCRIBE `ships` 0.011759042739868
(474) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.00052309036254883
(475) DESCRIBE `ships` 0.0051290988922119
(476) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.0030989646911621
(477) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037288665771484
(478) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0037910938262939
(479) DESCRIBE `itineraries` 0.0044679641723633
(480) DESCRIBE `ports` 0.0060429573059082
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.004080057144165
(482) DESCRIBE `ports` 0.0045230388641357
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0031051635742188
(484) DESCRIBE `ports` 0.0022361278533936
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.011569976806641
(486) DESCRIBE `sailingdates` 0.0018360614776611
(487) DESCRIBE `ports` 0.010225772857666
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0086710453033447
(489) DESCRIBE `ports` 0.0072028636932373
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00043106079101562
(491) DESCRIBE `ports` 0.0043208599090576
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0015108585357666
(493) DESCRIBE `ports` 0.010438919067383
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0051929950714111
(495) DESCRIBE `avid_specials` 0.0067009925842285
(496) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 26399 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 38 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.0022671222686768
(497) DESCRIBE `cruiselines` 0.012301206588745
(498) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.01661491394043
(499) DESCRIBE `orchid_image` 0.0031669139862061
(500) DESCRIBE `cruiselines` 0.010499954223633
(501) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.01301908493042
(502) DESCRIBE `cruises` 0.018277168273926
(503) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72163') 0.00086498260498047
(504) DESCRIBE `ships` 0.010770797729492
(505) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.0011270046234131
(506) DESCRIBE `ships` 0.012063026428223
(507) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.013373851776123
(508) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036311149597168
(509) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0013599395751953
(510) DESCRIBE `itineraries` 0.0059568881988525
(511) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72163') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0064289569854736
(512) DESCRIBE `ports` 0.005281925201416
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0054121017456055
(514) DESCRIBE `ports` 0.0048730373382568
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0058610439300537
(516) DESCRIBE `ports` 0.0052108764648438
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0010809898376465
(518) DESCRIBE `sailingdates` 0.0053069591522217
(519) DESCRIBE `ports` 0.0069191455841064
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0040528774261475
(521) DESCRIBE `ports` 0.0020010471343994
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0035009384155273
(523) DESCRIBE `ports` 0.0074958801269531
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.0037751197814941
(525) DESCRIBE `ports` 0.010262966156006
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.0026929378509521
(527) DESCRIBE `ports` 0.0035409927368164
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2160))) 0.0046370029449463
(529) DESCRIBE `ports` 0.0082509517669678
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2160') 0.00039386749267578
(531) DESCRIBE `ports` 0.0020651817321777
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3558))) 0.0038399696350098
(533) DESCRIBE `ports` 0.0028519630432129
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3558') 0.0088820457458496
(535) DESCRIBE `ports` 0.0018489360809326
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0036418437957764
(537) DESCRIBE `ports` 0.0019159317016602
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.010560035705566
(539) DESCRIBE `ports` 0.0019609928131104
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00045514106750488
(541) DESCRIBE `ports` 0.0034239292144775
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0079128742218018
(543) DESCRIBE `ports` 0.010120153427124
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00041604042053223
(545) DESCRIBE `ports` 0.0017910003662109
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.004249095916748
(547) DESCRIBE `ports` 0.0031719207763672
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.0065889358520508
(549) DESCRIBE `ports` 0.003309965133667
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.013744115829468
(551) DESCRIBE `ports` 0.0026500225067139
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.010625839233398
(553) DESCRIBE `ports` 0.0019679069519043
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00039577484130859
(555) DESCRIBE `ports` 0.010944843292236
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.0046150684356689
(557) DESCRIBE `ports` 0.0019619464874268
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.003695011138916
(559) DESCRIBE `ports` 0.0064420700073242
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0049519538879395
(561) DESCRIBE `ports` 0.0067610740661621
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00042200088500977
(563) DESCRIBE `ports` 0.0019428730010986
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0052118301391602
(565) DESCRIBE `ports` 0.0056779384613037
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.001025915145874
(567) DESCRIBE `ports` 0.0044300556182861
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.008404016494751
(569) DESCRIBE `ports` 0.0055141448974609
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00037193298339844
(571) DESCRIBE `avid_specials` 0.00465989112854
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72163 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 11 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.0023300647735596
(573) DESCRIBE `cruiselines` 0.0056910514831543
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0097088813781738
(575) DESCRIBE `orchid_image` 0.0026459693908691
(576) DESCRIBE `cruiselines` 0.0057909488677979
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0093960762023926
(578) DESCRIBE `ships` 0.0043230056762695
(579) SELECT `ships`.* FROM `ships` WHERE (id IN ('780', '258', '585')) ORDER BY FIND_IN_SET(id, '780,258,585') 0.010395050048828
(580) DESCRIBE `cruisetypes` 0.0039961338043213
(581) DESCRIBE `destinations` 0.0063700675964355
(582) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '38', '8', '35', '43', '11', '28', '2', '25', '22', '37', '26', '12', '52', '49', '34', '21')) ORDER BY FIND_IN_SET(id, '40,38,8,35,43,11,28,2,25,22,37,26,12,52,49,34,21') 0.0097849369049072
(583) DESCRIBE `cruiselines` 0.0032598972320557
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00042915344238281
(585) DESCRIBE `cruiselines` 0.005241870880127
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.001755952835083