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

Total elapsed time: 2.085636138916

# Query Time
(1) connect 0.0011918544769287
(2) DESCRIBE `cruises` 0.0055441856384277
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76344, 75337, 76951, 79265, 75336, 76959, 61417, 75340, 76841, 79998)) ORDER BY FIND_IN_SET(id, '76344,75337,76951,79265,75336,76959,61417,75340,76841,79998') 0.0036931037902832
(4) DESCRIBE `cruises` 0.0048539638519287
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76344') 0.00056600570678711
(6) DESCRIBE `ships` 0.0063040256500244
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00069212913513184
(8) DESCRIBE `ships` 0.0054969787597656
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00058484077453613
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052595138549805
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00058102607727051
(12) DESCRIBE `itineraries` 0.0026700496673584
(13) DESCRIBE `ports` 0.0037229061126709
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00059390068054199
(15) DESCRIBE `ports` 0.0041379928588867
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00071406364440918
(17) DESCRIBE `ports` 0.0041711330413818
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00059199333190918
(19) DESCRIBE `sailingdates` 0.0025680065155029
(20) DESCRIBE `ports` 0.0027821063995361
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00064802169799805
(22) DESCRIBE `ports` 0.0028619766235352
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00059294700622559
(24) DESCRIBE `ports` 0.0029399394989014
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00071287155151367
(26) DESCRIBE `ports` 0.0030288696289062
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00067901611328125
(28) DESCRIBE `ports` 0.0028009414672852
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00068306922912598
(30) DESCRIBE `ports` 0.0025739669799805
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.0005338191986084
(32) DESCRIBE `ports` 0.0021309852600098
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00051116943359375
(34) DESCRIBE `ports` 0.0034351348876953
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00059103965759277
(36) DESCRIBE `ports` 0.0032041072845459
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2143))) 0.00058078765869141
(38) DESCRIBE `ports` 0.0036318302154541
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2143') 0.00056910514831543
(40) DESCRIBE `ports` 0.0036098957061768
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00087690353393555
(42) DESCRIBE `ports` 0.004223108291626
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00077199935913086
(44) DESCRIBE `ports` 0.0037558078765869
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3022))) 0.00071287155151367
(46) DESCRIBE `ports` 0.0030348300933838
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3022') 0.00060701370239258
(48) DESCRIBE `ports` 0.0029759407043457
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00060796737670898
(50) DESCRIBE `ports` 0.0036611557006836
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00059103965759277
(52) DESCRIBE `ports` 0.0037078857421875
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2864))) 0.00046801567077637
(54) DESCRIBE `ports` 0.0031390190124512
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2864') 0.00062012672424316
(56) DESCRIBE `ports` 0.0030369758605957
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 689))) 0.00058507919311523
(58) DESCRIBE `ports` 0.0035970211029053
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '689') 0.00064396858215332
(60) DESCRIBE `ports` 0.0024101734161377
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1097))) 0.00044989585876465
(62) DESCRIBE `ports` 0.0020251274108887
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1097') 0.00042486190795898
(64) DESCRIBE `ports` 0.0024950504302979
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00044798851013184
(66) DESCRIBE `ports` 0.0020380020141602
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00040197372436523
(68) DESCRIBE `ports` 0.0034809112548828
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 880))) 0.00060701370239258
(70) DESCRIBE `ports` 0.0032901763916016
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '880') 0.00049400329589844
(72) DESCRIBE `ports` 0.002795934677124
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 335))) 0.00043416023254395
(74) DESCRIBE `ports` 0.0020108222961426
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '335') 0.0007011890411377
(76) DESCRIBE `ports` 0.0025360584259033
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00061511993408203
(78) DESCRIBE `ports` 0.0027220249176025
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00065302848815918
(80) DESCRIBE `avid_specials` 0.0017070770263672
(81) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76344 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 40 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.0023221969604492
(82) DESCRIBE `cruiselines` 0.0028390884399414
(83) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00058889389038086
(84) DESCRIBE `orchid_image` 0.0028209686279297
(85) DESCRIBE `cruiselines` 0.0037169456481934
(86) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00054407119750977
(87) DESCRIBE `cruises` 0.005483865737915
(88) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75337') 0.00068116188049316
(89) DESCRIBE `ships` 0.005295991897583
(90) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00053691864013672
(91) DESCRIBE `ships` 0.0040600299835205
(92) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00053596496582031
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046801567077637
(94) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047492980957031
(95) DESCRIBE `itineraries` 0.0031559467315674
(96) DESCRIBE `ports` 0.0033609867095947
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00053501129150391
(98) DESCRIBE `ports` 0.0026600360870361
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00044107437133789
(100) DESCRIBE `ports` 0.0019309520721436
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039505958557129
(102) DESCRIBE `sailingdates` 0.0017049312591553
(103) DESCRIBE `ports` 0.0027561187744141
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00049901008605957
(105) DESCRIBE `ports` 0.0024809837341309
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040793418884277
(107) DESCRIBE `ports` 0.0017778873443604
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00042891502380371
(109) DESCRIBE `ports` 0.0019130706787109
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00040006637573242
(111) DESCRIBE `ports` 0.0020041465759277
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00041413307189941
(113) DESCRIBE `ports` 0.0017740726470947
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00052499771118164
(115) DESCRIBE `ports` 0.0029759407043457
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00063896179199219
(117) DESCRIBE `ports` 0.0031280517578125
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00062298774719238
(119) DESCRIBE `ports` 0.0033118724822998
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0004570484161377
(121) DESCRIBE `ports` 0.0020911693572998
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040197372436523
(123) DESCRIBE `ports` 0.0018420219421387
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0005190372467041
(125) DESCRIBE `ports` 0.0033431053161621
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00057601928710938
(127) DESCRIBE `ports` 0.0026261806488037
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00052404403686523
(129) DESCRIBE `ports` 0.0026099681854248
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0005340576171875
(131) DESCRIBE `ports` 0.0025920867919922
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00056099891662598
(133) DESCRIBE `ports` 0.0024688243865967
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00052809715270996
(135) DESCRIBE `ports` 0.0027379989624023
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00058794021606445
(137) DESCRIBE `ports` 0.0026290416717529
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00090193748474121
(139) DESCRIBE `ports` 0.003425121307373
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00076889991760254
(141) DESCRIBE `ports` 0.003187894821167
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00063419342041016
(143) DESCRIBE `ports` 0.002918004989624
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00072383880615234
(145) DESCRIBE `ports` 0.003277063369751
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00069284439086914
(147) DESCRIBE `ports` 0.0029120445251465
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00045108795166016
(149) DESCRIBE `ports` 0.0026211738586426
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003969669342041
(151) DESCRIBE `avid_specials` 0.0027768611907959
(152) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75337 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017008781433105
(153) DESCRIBE `cruiselines` 0.0036978721618652
(154) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00044703483581543
(155) DESCRIBE `orchid_image` 0.0032138824462891
(156) DESCRIBE `cruiselines` 0.0039360523223877
(157) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00052499771118164
(158) DESCRIBE `cruises` 0.005033016204834
(159) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76951') 0.00058388710021973
(160) DESCRIBE `ships` 0.0055181980133057
(161) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00071406364440918
(162) DESCRIBE `ships` 0.005702018737793
(163) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00053906440734863
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036978721618652
(165) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(166) DESCRIBE `itineraries` 0.0021860599517822
(167) DESCRIBE `ports` 0.0024399757385254
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00047802925109863
(169) DESCRIBE `ports` 0.0023958683013916
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0068509578704834
(171) DESCRIBE `ports` 0.0083520412445068
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00047612190246582
(173) DESCRIBE `sailingdates` 0.0018889904022217
(174) DESCRIBE `ports` 0.0086269378662109
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00081491470336914
(176) DESCRIBE `ports` 0.0079460144042969
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00065493583679199
(178) DESCRIBE `ports` 0.0029809474945068
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00060582160949707
(180) DESCRIBE `ports` 0.002683162689209
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.0056939125061035
(182) DESCRIBE `ports` 0.0024299621582031
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00055289268493652
(184) DESCRIBE `ports` 0.0022118091583252
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00056290626525879
(186) DESCRIBE `ports` 0.003119945526123
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0021989345550537
(188) DESCRIBE `ports` 0.0021011829376221
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00052809715270996
(190) DESCRIBE `ports` 0.0027439594268799
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00046396255493164
(192) DESCRIBE `ports` 0.0028250217437744
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00040698051452637
(194) DESCRIBE `ports` 0.0024020671844482
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00047779083251953
(196) DESCRIBE `ports` 0.0074470043182373
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.0063920021057129
(198) DESCRIBE `ports` 0.00235915184021
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00059199333190918
(200) DESCRIBE `ports` 0.008897066116333
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00043106079101562
(202) DESCRIBE `ports` 0.0022950172424316
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00058507919311523
(204) DESCRIBE `ports` 0.0026161670684814
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0005340576171875
(206) DESCRIBE `ports` 0.011074066162109
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 407))) 0.00061511993408203
(208) DESCRIBE `ports` 0.0023679733276367
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '407') 0.00043916702270508
(210) DESCRIBE `ports` 0.0084459781646729
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1494))) 0.00061511993408203
(212) DESCRIBE `ports` 0.0021262168884277
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1494') 0.00049209594726562
(214) DESCRIBE `ports` 0.0023601055145264
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 765))) 0.00062203407287598
(216) DESCRIBE `ports` 0.0093939304351807
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '765') 0.00068998336791992
(218) DESCRIBE `ports` 0.002953052520752
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 409))) 0.00069284439086914
(220) DESCRIBE `ports` 0.0030748844146729
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '409') 0.0084559917449951
(222) DESCRIBE `ports` 0.0031909942626953
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00069904327392578
(224) DESCRIBE `ports` 0.0028769969940186
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.0060608386993408
(226) DESCRIBE `ports` 0.0030269622802734
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00070405006408691
(228) DESCRIBE `ports` 0.008404016494751
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00065994262695312
(230) DESCRIBE `ports` 0.0030348300933838
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0073578357696533
(232) DESCRIBE `ports` 0.0029659271240234
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00054001808166504
(234) DESCRIBE `avid_specials` 0.0021610260009766
(235) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76951 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0085530281066895
(236) DESCRIBE `cruiselines` 0.004194974899292
(237) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00066804885864258
(238) DESCRIBE `orchid_image` 0.003262996673584
(239) DESCRIBE `cruiselines` 0.0071680545806885
(240) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0090899467468262
(241) DESCRIBE `cruises` 0.014517068862915
(242) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79265') 0.00056099891662598
(243) DESCRIBE `ships` 0.004317045211792
(244) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1607))) 0.00073099136352539
(245) DESCRIBE `ships` 0.0039451122283936
(246) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1607') 0.0052170753479004
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00039005279541016
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00043106079101562
(249) DESCRIBE `itineraries` 0.0020711421966553
(250) DESCRIBE `ports` 0.011231899261475
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00091385841369629
(252) DESCRIBE `ports` 0.0027580261230469
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00063395500183105
(254) DESCRIBE `ports` 0.0078878402709961
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00060391426086426
(256) DESCRIBE `sailingdates` 0.002392053604126
(257) DESCRIBE `ports` 0.0030710697174072
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0059340000152588
(259) DESCRIBE `ports` 0.0026688575744629
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00074911117553711
(261) DESCRIBE `ports` 0.0054268836975098
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.0096828937530518
(263) DESCRIBE `ports` 0.0031049251556396
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00066900253295898
(265) DESCRIBE `ports` 0.0026760101318359
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00064897537231445
(267) DESCRIBE `ports` 0.0028181076049805
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.009498119354248
(269) DESCRIBE `ports` 0.0029730796813965
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0008399486541748
(271) DESCRIBE `ports` 0.0028700828552246
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.0006251335144043
(273) DESCRIBE `ports` 0.011600971221924
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00072216987609863
(275) DESCRIBE `ports` 0.0028979778289795
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00061702728271484
(277) DESCRIBE `ports` 0.0028440952301025
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0064060688018799
(279) DESCRIBE `ports` 0.002863883972168
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0005028247833252
(281) DESCRIBE `ports` 0.002708911895752
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0028119087219238
(283) DESCRIBE `ports` 0.0019760131835938
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.004194974899292
(285) DESCRIBE `ports` 0.0019590854644775
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0057828426361084
(287) DESCRIBE `ports` 0.0023438930511475
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0011579990386963
(289) DESCRIBE `ports` 0.0025861263275146
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0071661472320557
(291) DESCRIBE `ports` 0.0023889541625977
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00051617622375488
(293) DESCRIBE `ports` 0.0022530555725098
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00057101249694824
(295) DESCRIBE `ports` 0.0019698143005371
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.0082838535308838
(297) DESCRIBE `ports` 0.002371072769165
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00063705444335938
(299) DESCRIBE `ports` 0.0019471645355225
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00059914588928223
(301) DESCRIBE `avid_specials` 0.002202033996582
(302) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79265 and class = 'Cruise') OR (item_id = 1607 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.010659217834473
(303) DESCRIBE `cruiselines` 0.0039908885955811
(304) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00062298774719238
(305) DESCRIBE `orchid_image` 0.0022258758544922
(306) DESCRIBE `cruiselines` 0.010488986968994
(307) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00054192543029785
(308) DESCRIBE `cruises` 0.0038900375366211
(309) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75336') 0.0017280578613281
(310) DESCRIBE `ships` 0.012310981750488
(311) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.001025915145874
(312) DESCRIBE `ships` 0.012219190597534
(313) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00049805641174316
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043582916259766
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036311149597168
(316) DESCRIBE `itineraries` 0.0022528171539307
(317) DESCRIBE `ports` 0.0024220943450928
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0075180530548096
(319) DESCRIBE `ports` 0.002249002456665
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00048184394836426
(321) DESCRIBE `ports` 0.0018939971923828
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00042510032653809
(323) DESCRIBE `sailingdates` 0.0021469593048096
(324) DESCRIBE `ports` 0.0094928741455078
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0005340576171875
(326) DESCRIBE `ports` 0.0019588470458984
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00042295455932617
(328) DESCRIBE `ports` 0.0022239685058594
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00050878524780273
(330) DESCRIBE `ports` 0.0075609683990479
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00049710273742676
(332) DESCRIBE `ports` 0.0023038387298584
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0090498924255371
(334) DESCRIBE `ports` 0.0027141571044922
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00057005882263184
(336) DESCRIBE `ports` 0.002540111541748
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0007941722869873
(338) DESCRIBE `ports` 0.0027539730072021
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.0062901973724365
(340) DESCRIBE `ports` 0.0029330253601074
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00066995620727539
(342) DESCRIBE `ports` 0.0028848648071289
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0063221454620361
(344) DESCRIBE `ports` 0.0029218196868896
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00068783760070801
(346) DESCRIBE `ports` 0.0086870193481445
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00064301490783691
(348) DESCRIBE `avid_specials` 0.0019910335540771
(349) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75336 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012009143829346
(350) DESCRIBE `cruiselines` 0.0091278553009033
(351) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00057601928710938
(352) DESCRIBE `orchid_image` 0.0027189254760742
(353) DESCRIBE `cruiselines` 0.0086658000946045
(354) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00045990943908691
(355) DESCRIBE `cruises` 0.0038330554962158
(356) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76959') 0.005889892578125
(357) DESCRIBE `ships` 0.012176036834717
(358) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.0009620189666748
(359) DESCRIBE `ships` 0.0070099830627441
(360) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.0058889389038086
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053811073303223
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053191184997559
(363) DESCRIBE `itineraries` 0.0029561519622803
(364) DESCRIBE `ports` 0.0028820037841797
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0098378658294678
(366) DESCRIBE `ports` 0.0021770000457764
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00049614906311035
(368) DESCRIBE `ports` 0.0026149749755859
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00077605247497559
(370) DESCRIBE `sailingdates` 0.0027210712432861
(371) DESCRIBE `ports` 0.0087099075317383
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00058388710021973
(373) DESCRIBE `ports` 0.0026099681854248
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0081889629364014
(375) DESCRIBE `ports` 0.0031468868255615
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.000885009765625
(377) DESCRIBE `ports` 0.0023632049560547
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.0032861232757568
(379) DESCRIBE `ports` 0.0021450519561768
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00050091743469238
(381) DESCRIBE `ports` 0.0093851089477539
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00068521499633789
(383) DESCRIBE `ports` 0.0026609897613525
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5609))) 0.00065517425537109
(385) DESCRIBE `ports` 0.0077688694000244
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5609') 0.00063490867614746
(387) DESCRIBE `ports` 0.0024662017822266
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.0007178783416748
(389) DESCRIBE `ports` 0.0097529888153076
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00068092346191406
(391) DESCRIBE `ports` 0.0027458667755127
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00081610679626465
(393) DESCRIBE `ports` 0.0029060840606689
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.0069441795349121
(395) DESCRIBE `ports` 0.0028560161590576
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00060391426086426
(397) DESCRIBE `ports` 0.0026490688323975
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.0065910816192627
(399) DESCRIBE `ports` 0.0023689270019531
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00068402290344238
(401) DESCRIBE `ports` 0.0021600723266602
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0081400871276855
(403) DESCRIBE `avid_specials` 0.0024600028991699
(404) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76959 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.002223014831543
(405) DESCRIBE `cruiselines` 0.0039029121398926
(406) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0075690746307373
(407) DESCRIBE `orchid_image` 0.0031888484954834
(408) DESCRIBE `cruiselines` 0.003795862197876
(409) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0082390308380127
(410) DESCRIBE `cruises` 0.0041890144348145
(411) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61417') 0.00052714347839355
(412) DESCRIBE `ships` 0.0096569061279297
(413) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00084304809570312
(414) DESCRIBE `ships` 0.013852834701538
(415) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.0007178783416748
(416) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054502487182617
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052094459533691
(418) DESCRIBE `itineraries` 0.0030031204223633
(419) DESCRIBE `ports` 0.010754108428955
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00070714950561523
(421) DESCRIBE `ports` 0.0028960704803467
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00073695182800293
(423) DESCRIBE `ports` 0.011914014816284
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00070786476135254
(425) DESCRIBE `sailingdates` 0.0025990009307861
(426) DESCRIBE `ports` 0.0029311180114746
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00072503089904785
(428) DESCRIBE `ports` 0.011248111724854
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00069093704223633
(430) DESCRIBE `ports` 0.0028660297393799
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00045895576477051
(432) DESCRIBE `ports` 0.0018000602722168
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.0059418678283691
(434) DESCRIBE `ports` 0.0022180080413818
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00056600570678711
(436) DESCRIBE `ports` 0.0031380653381348
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00056600570678711
(438) DESCRIBE `ports` 0.010848999023438
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00047802925109863
(440) DESCRIBE `ports` 0.0018458366394043
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0004570484161377
(442) DESCRIBE `ports` 0.0019528865814209
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0.00051403045654297
(444) DESCRIBE `ports` 0.0023238658905029
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.00058317184448242
(446) DESCRIBE `ports` 0.0088999271392822
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00072884559631348
(448) DESCRIBE `ports` 0.0020809173583984
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00061511993408203
(450) DESCRIBE `ports` 0.004223108291626
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0058720111846924
(452) DESCRIBE `ports` 0.0021932125091553
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00056099891662598
(454) DESCRIBE `ports` 0.0023019313812256
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0083980560302734
(456) DESCRIBE `ports` 0.0022890567779541
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044918060302734
(458) DESCRIBE `avid_specials` 0.0017819404602051
(459) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61417 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012900829315186
(460) DESCRIBE `cruiselines` 0.0030350685119629
(461) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0074930191040039
(462) DESCRIBE `orchid_image` 0.0025098323822021
(463) DESCRIBE `cruiselines` 0.0032000541687012
(464) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00055217742919922
(465) DESCRIBE `cruises` 0.012312173843384
(466) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75340') 0.00048208236694336
(467) DESCRIBE `ships` 0.0040011405944824
(468) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00066304206848145
(469) DESCRIBE `ships` 0.0042018890380859
(470) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.0064361095428467
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039005279541016
(472) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(473) DESCRIBE `itineraries` 0.0021660327911377
(474) DESCRIBE `ports` 0.0085968971252441
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0006260871887207
(476) DESCRIBE `ports` 0.0020849704742432
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0095758438110352
(478) DESCRIBE `ports` 0.0029060840606689
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00064897537231445
(480) DESCRIBE `sailingdates` 0.0025300979614258
(481) DESCRIBE `ports` 0.0029878616333008
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0090670585632324
(483) DESCRIBE `ports` 0.0032968521118164
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00065994262695312
(485) DESCRIBE `ports` 0.0028400421142578
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00082182884216309
(487) DESCRIBE `ports` 0.0028228759765625
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.012280941009521
(489) DESCRIBE `ports` 0.0032238960266113
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00065994262695312
(491) DESCRIBE `ports` 0.0022850036621094
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00057697296142578
(493) DESCRIBE `ports` 0.0019490718841553
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0077269077301025
(495) DESCRIBE `ports` 0.0024170875549316
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00047898292541504
(497) DESCRIBE `ports` 0.0027320384979248
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00054097175598145
(499) DESCRIBE `ports` 0.0019760131835938
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0083379745483398
(501) DESCRIBE `avid_specials` 0.0019841194152832
(502) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75340 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022749900817871
(503) DESCRIBE `cruiselines` 0.0038321018218994
(504) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0088868141174316
(505) DESCRIBE `orchid_image` 0.0030200481414795
(506) DESCRIBE `cruiselines` 0.0038788318634033
(507) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0084919929504395
(508) DESCRIBE `cruises` 0.0038690567016602
(509) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76841') 0.0005948543548584
(510) DESCRIBE `ships` 0.012788057327271
(511) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00059103965759277
(512) DESCRIBE `ships` 0.0037910938262939
(513) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00051188468933105
(514) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(515) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034904479980469
(516) DESCRIBE `itineraries` 0.0020959377288818
(517) DESCRIBE `ports` 0.010655879974365
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00047588348388672
(519) DESCRIBE `ports` 0.0020251274108887
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046205520629883
(521) DESCRIBE `ports` 0.0021791458129883
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00048303604125977
(523) DESCRIBE `sailingdates` 0.0017979145050049
(524) DESCRIBE `ports` 0.0074009895324707
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00047206878662109
(526) DESCRIBE `ports` 0.0021870136260986
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00049400329589844
(528) DESCRIBE `ports` 0.0023648738861084
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.0064079761505127
(530) DESCRIBE `ports` 0.0023460388183594
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00053906440734863
(532) DESCRIBE `ports` 0.002593994140625
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.007735013961792
(534) DESCRIBE `ports` 0.0020089149475098
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.0004570484161377
(536) DESCRIBE `ports` 0.0021371841430664
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00043392181396484
(538) DESCRIBE `ports` 0.010146141052246
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00047183036804199
(540) DESCRIBE `ports` 0.0024590492248535
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0004889965057373
(542) DESCRIBE `ports` 0.0022668838500977
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0004119873046875
(544) DESCRIBE `avid_specials` 0.00199294090271
(545) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76841 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0076050758361816
(546) DESCRIBE `cruiselines` 0.0031008720397949
(547) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00052118301391602
(548) DESCRIBE `orchid_image` 0.0023019313812256
(549) DESCRIBE `cruiselines` 0.01820707321167
(550) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0059211254119873
(551) DESCRIBE `cruises` 0.0055568218231201
(552) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79998') 0.0077888965606689
(553) DESCRIBE `ships` 0.011502027511597
(554) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 70))) 0.00050210952758789
(555) DESCRIBE `ships` 0.0082740783691406
(556) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '70') 0.0033249855041504
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00094890594482422
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0035700798034668
(559) DESCRIBE `itineraries` 0.0054550170898438
(560) DESCRIBE `ports` 0.0025510787963867
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0021278858184814
(562) DESCRIBE `ports` 0.0035860538482666
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0044150352478027
(564) DESCRIBE `ports` 0.0075321197509766
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0015771389007568
(566) DESCRIBE `sailingdates` 0.0070149898529053
(567) DESCRIBE `ports` 0.0032877922058105
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0060770511627197
(569) DESCRIBE `ports` 0.0021059513092041
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0065641403198242
(571) DESCRIBE `ports` 0.0020449161529541
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00050115585327148
(573) DESCRIBE `ports` 0.0036079883575439
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.0054619312286377
(575) DESCRIBE `ports` 0.0018811225891113
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.001568078994751
(577) DESCRIBE `ports` 0.002047061920166
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0070841312408447
(579) DESCRIBE `ports` 0.0021700859069824
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00045680999755859
(581) DESCRIBE `ports` 0.0020148754119873
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.004619836807251
(583) DESCRIBE `ports` 0.0021779537200928
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0057568550109863
(585) DESCRIBE `ports` 0.0021438598632812
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.0037128925323486
(587) DESCRIBE `ports` 0.0019278526306152
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00045013427734375
(589) DESCRIBE `ports` 0.0018119812011719
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.0049309730529785
(591) DESCRIBE `ports` 0.0025689601898193
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0043301582336426
(593) DESCRIBE `ports` 0.0055620670318604
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0033619403839111
(595) DESCRIBE `avid_specials` 0.0017189979553223
(596) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79998 and class = 'Cruise') OR (item_id = 70 AND class = 'Ship') OR (item_id = 16 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014519691467285
(597) DESCRIBE `cruiselines` 0.0067310333251953
(598) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.0026497840881348
(599) DESCRIBE `orchid_image` 0.0022580623626709
(600) DESCRIBE `cruiselines` 0.0055510997772217
(601) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.0036249160766602
(602) DESCRIBE `cruiselines` 0.0048301219940186
(603) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '171', '23', '144', '20', '12', '7', '18', '183', '101', '8', '31', '120', '131', '29', '96', '103', '15', '206', '91', '262', '33', '114', '24', '170', '14', '28', '156', '258', '191', '50', '195', '37', '153', '208', '16', '49', '187', '36', '88', '251', '47', '151', '216', '212', '141', '181', '118', '4', '110', '59', '140', '147', '30', '261', '48', '73', '213', '211', '276', '209', '159', '115', '264', '108', '82', '113', '57', '95', '90', '184', '244', '52', '180', '38', '64', '35', '105', '134', '257', '245')) ORDER BY FIND_IN_SET(id, '77,218,19,26,171,23,144,20,12,7,18,183,101,8,31,120,131,29,96,103,15,206,91,262,33,114,24,170,14,28,156,258,191,50,195,37,153,208,16,49,187,36,88,251,47,151,216,212,141,181,118,4,110,59,140,147,30,261,48,73,213,211,276,209,159,115,264,108,82,113,57,95,90,184,244,52,180,38,64,35,105,134,257,245') 0.022051095962524
(604) DESCRIBE `ships` 0.029106855392456
(605) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '726', '258', '1324', '517', '780', '737', '1417', '1588', '1717', '855', '871', '207', '1766', '1794', '1291', '977', '1572', '874', '1594', '454', '404', '1359', '770', '1272', '1199', '66', '22', '21', '330', '461', '738', '393', '1032', '1134', '1424', '434', '716', '265', '553', '974', '28', '332', '1237', '1292', '333', '1682', '1768', '797', '521', '1348', '349', '1260', '1419', '1423', '1422', '1418', '1420', '1421', '766', '1415', '711', '715', '163', '792', '9', '455', '1678', '11', '25', '407', '10', '439', '585', '674', '739', '857', '858', '1677', '1132', '1501', '657', '542', '3', '24', '1460', '31', '34', '36', '39', '378', '520', '1008', '1721', '1852', '966', '1569', '1141', '1233', '1607', '1742', '1822', '385', '1505', '1811', '386', '1168', '1676', '1302', '1372', '1402', '35', '1012', '1455', '626', '768', '837', '850', '1373', '1773', '98', '986', '113', '817', '1205', '1319', '338', '451', '1282', '1413', '1602', '882', '1135', '573', '1410', '1782', '160', '352', '1021', '1067', '1259', '1411', '1574', '1733', '547', '610', '1284', '1454', '37', '285', '1398', '30', '148', '314', '375', '1063', '1437', '63', '111', '198', '508', '1145', '1722', '108', '883', '1088', '1193', '1308', '286', '627', '748', '1149', '1808', '38', '340', '406', '526', '1323', '43', '970', '1028', '1320', '1579', '1711', '124', '327', '485', '1108', '1325', '394', '854', '1068', '1586', '348', '390', '582', '1810', '116', '590', '1157', '1321', '1412', '1492', '1571', '1724', '1461', '1738', '1809', '223', '616', '1208', '1575', '1672', '1801', '82', '119', '462', '652', '1853', '351', '791', '944', '1027', '1587', '114', '147', '678', '704', '884', '1318', '1408', '1820', '70', '75', '1266', '1552', '4', '78', '503', '545', '658', '683', '1139', '1486', '201', '325', '335', '401', '441', '958', '1188', '1289', '81', '149', '291', '601', '722', '988', '1330', '1772', '162', '403', '790', '1326', '1327', '1771', '287', '580', '776', '1073', '1367', '105', '389', '423', '651', '1037', '1043', '1151', '1236', '1757', '69', '818', '1040', '1303', '1704', '341', '1013', '1019', '1539', '123', '262', '266', '1172', '290', '405', '483', '796', '1223', '1526', '45', '480', '639', '673', '1474', '1740', '84', '751', '1029', '1159', '1338', '1540', '1715', '1743', '1758', '795', '852', '1035', '1160', '1163', '1206', '1344', '1426', '968', '972', '1146', '1150', '1217', '1226', '1229', '1452', '1453', '1573', '1604', '1681', '1716', '324', '417', '635', '643', '717', '1143', '1144', '1245', '1283', '1343', '1358', '1483', '1807', '1833', '574', '709', '775', '851', '905', '1048', '1136', '1262', '1293', '1448', '1746', '1042', '1045', '1230', '1231', '1663', '1787', '467', '885', '1026', '1051', '1095', '1137', '1749', '1791', '1140', '1154', '1340', '1351', '1409', '1458', '1723', '1730', '1759', '1806', '663', '954', '1224', '1366', '1368', '1459', '1463', '1609', '1632', '1673', '1751', '559', '665', '920', '973', '996', '1049', '1050', '1148', '1274', '1354', '1360', '1361', '1362', '1647', '1708', '1713', '1805', '151', '448', '666', '914', '921', '923', '927', '1025', '1044', '1055', '1072', '1090', '1196', '1339', '1601', '1714', '1788', '1823', '212', '453', '886', '915', '916', '926', '930', '931', '1109', '1152', '1322', '1449', '1649', '1750', '1854', '208', '703', '769', '924', '1047', '1052', '1596', '1650', '1816', '299', '300', '422', '740', '1004', '1020', '1036', '1039', '1054', '1225', '1352', '1451', '1519', '1580', '150', '937', '1294', '479', '487', '672', '707', '888', '1071', '1256', '1301', '1329', '1389', '93', '205', '671', '821', '1232', '1445', '1664', '516', '644', '1005', '1060', '1350', '1405', '1626', '1792', '1821', '420')) ORDER BY FIND_IN_SET(id, '1761,732,1744,726,258,1324,517,780,737,1417,1588,1717,855,871,207,1766,1794,1291,977,1572,874,1594,454,404,1359,770,1272,1199,66,22,21,330,461,738,393,1032,1134,1424,434,716,265,553,974,28,332,1237,1292,333,1682,1768,797,521,1348,349,1260,1419,1423,1422,1418,1420,1421,766,1415,711,715,163,792,9,455,1678,11,25,407,10,439,585,674,739,857,858,1677,1132,1501,657,542,3,24,1460,31,34,36,39,378,520,1008,1721,1852,966,1569,1141,1233,1607,1742,1822,385,1505,1811,386,1168,1676,1302,1372,1402,35,1012,1455,626,768,837,850,1373,1773,98,986,113,817,1205,1319,338,451,1282,1413,1602,882,1135,573,1410,1782,160,352,1021,1067,1259,1411,1574,1733,547,610,1284,1454,37,285,1398,30,148,314,375,1063,1437,63,111,198,508,1145,1722,108,883,1088,1193,1308,286,627,748,1149,1808,38,340,406,526,1323,43,970,1028,1320,1579,1711,124,327,485,1108,1325,394,854,1068,1586,348,390,582,1810,116,590,1157,1321,1412,1492,1571,1724,1461,1738,1809,223,616,1208,1575,1672,1801,82,119,462,652,1853,351,791,944,1027,1587,114,147,678,704,884,1318,1408,1820,70,75,1266,1552,4,78,503,545,658,683,1139,1486,201,325,335,401,441,958,1188,1289,81,149,291,601,722,988,1330,1772,162,403,790,1326,1327,1771,287,580,776,1073,1367,105,389,423,651,1037,1043,1151,1236,1757,69,818,1040,1303,1704,341,1013,1019,1539,123,262,266,1172,290,405,483,796,1223,1526,45,480,639,673,1474,1740,84,751,1029,1159,1338,1540,1715,1743,1758,795,852,1035,1160,1163,1206,1344,1426,968,972,1146,1150,1217,1226,1229,1452,1453,1573,1604,1681,1716,324,417,635,643,717,1143,1144,1245,1283,1343,1358,1483,1807,1833,574,709,775,851,905,1048,1136,1262,1293,1448,1746,1042,1045,1230,1231,1663,1787,467,885,1026,1051,1095,1137,1749,1791,1140,1154,1340,1351,1409,1458,1723,1730,1759,1806,663,954,1224,1366,1368,1459,1463,1609,1632,1673,1751,559,665,920,973,996,1049,1050,1148,1274,1354,1360,1361,1362,1647,1708,1713,1805,151,448,666,914,921,923,927,1025,1044,1055,1072,1090,1196,1339,1601,1714,1788,1823,212,453,886,915,916,926,930,931,1109,1152,1322,1449,1649,1750,1854,208,703,769,924,1047,1052,1596,1650,1816,299,300,422,740,1004,1020,1036,1039,1054,1225,1352,1451,1519,1580,150,937,1294,479,487,672,707,888,1071,1256,1301,1329,1389,93,205,671,821,1232,1445,1664,516,644,1005,1060,1350,1405,1626,1792,1821,420') 0.22735095024109
(606) DESCRIBE `cruisetypes` 0.0023760795593262
(607) DESCRIBE `destinations` 0.0035419464111328
(608) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '37', '2', '9', '8', '44', '55', '39', '53', '26', '38', '28', '40', '30', '49', '11', '21', '7', '45', '29', '48', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,37,2,9,8,44,55,39,53,26,38,28,40,30,49,11,21,7,45,29,48,52,34,10,46,56,32') 0.0040922164916992