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

Total elapsed time: 1.005580663681

# Query Time
(1) connect 0.0011429786682129
(2) DESCRIBE `cruises` 0.0046601295471191
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75239, 75201, 75240, 75279, 75241, 75280, 75242, 75362, 75243, 75244)) ORDER BY FIND_IN_SET(id, '75239,75201,75240,75279,75241,75280,75242,75362,75243,75244') 0.0027999877929688
(4) DESCRIBE `cruises` 0.0045149326324463
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75239') 0.00044417381286621
(6) DESCRIBE `ships` 0.005748987197876
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00064206123352051
(8) DESCRIBE `ships` 0.0049641132354736
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00045514106750488
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038003921508789
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00045323371887207
(12) DESCRIBE `itineraries` 0.0022668838500977
(13) DESCRIBE `ports` 0.0020830631256104
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00041890144348145
(15) DESCRIBE `ports` 0.0021791458129883
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00043201446533203
(17) DESCRIBE `ports` 0.0019299983978271
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.0003819465637207
(19) DESCRIBE `sailingdates` 0.0019080638885498
(20) DESCRIBE `ports` 0.0024399757385254
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00043916702270508
(22) DESCRIBE `ports` 0.0026919841766357
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00041389465332031
(24) DESCRIBE `ports` 0.0018699169158936
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00047492980957031
(26) DESCRIBE `ports` 0.0020480155944824
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00040912628173828
(28) DESCRIBE `ports` 0.0021431446075439
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2110))) 0.00039196014404297
(30) DESCRIBE `ports` 0.0019290447235107
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2110') 0.0003669261932373
(32) DESCRIBE `ports` 0.0024960041046143
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00044703483581543
(34) DESCRIBE `ports` 0.0028860569000244
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00058698654174805
(36) DESCRIBE `ports` 0.0033209323883057
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00058102607727051
(38) DESCRIBE `ports` 0.0032141208648682
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.0005340576171875
(40) DESCRIBE `ports` 0.0031890869140625
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.0006251335144043
(42) DESCRIBE `ports` 0.0029199123382568
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00055885314941406
(44) DESCRIBE `ports` 0.0018630027770996
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00044393539428711
(46) DESCRIBE `ports` 0.0024261474609375
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00052690505981445
(48) DESCRIBE `avid_specials` 0.0025041103363037
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75239 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0015771389007568
(50) DESCRIBE `cruiselines` 0.0032877922058105
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00045990943908691
(52) DESCRIBE `orchid_image` 0.0023741722106934
(53) DESCRIBE `cruiselines` 0.0029430389404297
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00039410591125488
(55) DESCRIBE `cruises` 0.0037281513214111
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75201') 0.00038599967956543
(57) DESCRIBE `ships` 0.0039050579071045
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 818))) 0.00043201446533203
(59) DESCRIBE `ships` 0.0035281181335449
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '818') 0.00037908554077148
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003960132598877
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034093856811523
(63) DESCRIBE `itineraries` 0.0021860599517822
(64) DESCRIBE `ports` 0.0021579265594482
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00044798851013184
(66) DESCRIBE `ports` 0.0023798942565918
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00064492225646973
(68) DESCRIBE `ports` 0.0027198791503906
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00047707557678223
(70) DESCRIBE `sailingdates` 0.0019779205322266
(71) DESCRIBE `ports` 0.0020029544830322
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00046396255493164
(73) DESCRIBE `ports` 0.0022120475769043
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00038814544677734
(75) DESCRIBE `ports` 0.0022149085998535
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00042390823364258
(77) DESCRIBE `ports` 0.0029811859130859
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00063490867614746
(79) DESCRIBE `ports` 0.0031061172485352
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3588))) 0.0006411075592041
(81) DESCRIBE `ports` 0.0021998882293701
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3588') 0.00043106079101562
(83) DESCRIBE `ports` 0.0019848346710205
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.00044608116149902
(85) DESCRIBE `ports` 0.0019280910491943
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') 0.00043702125549316
(87) DESCRIBE `ports` 0.0024669170379639
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2109))) 0.00055694580078125
(89) DESCRIBE `ports` 0.0029370784759521
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2109') 0.00040507316589355
(91) DESCRIBE `ports` 0.0018529891967773
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2416))) 0.00042414665222168
(93) DESCRIBE `ports` 0.0019171237945557
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2416') 0.00037908554077148
(95) DESCRIBE `ports` 0.0019619464874268
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2654))) 0.0003969669342041
(97) DESCRIBE `ports` 0.001939058303833
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2654') 0.00037598609924316
(99) DESCRIBE `ports` 0.001939058303833
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00039291381835938
(101) DESCRIBE `ports` 0.0026290416717529
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00044012069702148
(103) DESCRIBE `ports` 0.0024490356445312
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00047206878662109
(105) DESCRIBE `ports` 0.0030579566955566
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.0005500316619873
(107) DESCRIBE `ports` 0.0031759738922119
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2660))) 0.00041508674621582
(109) DESCRIBE `ports` 0.0020182132720947
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2660') 0.00059390068054199
(111) DESCRIBE `ports` 0.0031988620758057
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1176))) 0.00069594383239746
(113) DESCRIBE `ports` 0.0032539367675781
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1176') 0.00063800811767578
(115) DESCRIBE `ports` 0.0034570693969727
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00059294700622559
(117) DESCRIBE `ports` 0.0033910274505615
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00045299530029297
(119) DESCRIBE `ports` 0.003403902053833
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00063586235046387
(121) DESCRIBE `ports` 0.002763032913208
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00054121017456055
(123) DESCRIBE `avid_specials` 0.0028300285339355
(124) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75201 and class = 'Cruise') OR (item_id = 818 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 49 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.0012750625610352
(125) DESCRIBE `cruiselines` 0.0025990009307861
(126) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00044488906860352
(127) DESCRIBE `orchid_image` 0.002608060836792
(128) DESCRIBE `cruiselines` 0.0029540061950684
(129) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00037908554077148
(130) DESCRIBE `cruises` 0.0042071342468262
(131) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75240') 0.0004730224609375
(132) DESCRIBE `ships` 0.0037760734558105
(133) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00046396255493164
(134) DESCRIBE `ships` 0.0036799907684326
(135) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00046396255493164
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00037288665771484
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036191940307617
(138) DESCRIBE `itineraries` 0.0021259784698486
(139) DESCRIBE `ports` 0.0021650791168213
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.0004570484161377
(141) DESCRIBE `ports` 0.0019931793212891
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00041007995605469
(143) DESCRIBE `ports` 0.00217604637146
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00050997734069824
(145) DESCRIBE `sailingdates` 0.0018739700317383
(146) DESCRIBE `ports` 0.0024821758270264
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00043702125549316
(148) DESCRIBE `ports` 0.002316951751709
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00055813789367676
(150) DESCRIBE `ports` 0.0027790069580078
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2110))) 0.0005180835723877
(152) DESCRIBE `ports` 0.0026400089263916
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2110') 0.00042104721069336
(154) DESCRIBE `ports` 0.0026810169219971
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00047898292541504
(156) DESCRIBE `ports` 0.0033218860626221
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00050783157348633
(158) DESCRIBE `ports` 0.0028419494628906
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00058507919311523
(160) DESCRIBE `ports` 0.0026249885559082
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00065898895263672
(162) DESCRIBE `ports` 0.0023128986358643
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.0004270076751709
(164) DESCRIBE `ports` 0.0026538372039795
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00045204162597656
(166) DESCRIBE `ports` 0.0026118755340576
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00046491622924805
(168) DESCRIBE `ports` 0.0035171508789062
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00041413307189941
(170) DESCRIBE `ports` 0.0020608901977539
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00042104721069336
(172) DESCRIBE `ports` 0.002345085144043
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00044608116149902
(174) DESCRIBE `avid_specials` 0.0028848648071289
(175) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75240 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0013618469238281
(176) DESCRIBE `cruiselines` 0.0026960372924805
(177) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00056290626525879
(178) DESCRIBE `orchid_image` 0.002626895904541
(179) DESCRIBE `cruiselines` 0.0046520233154297
(180) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00059795379638672
(181) DESCRIBE `cruises` 0.005774974822998
(182) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75279') 0.0006401538848877
(183) DESCRIBE `ships` 0.0060429573059082
(184) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00055909156799316
(185) DESCRIBE `ships` 0.0044519901275635
(186) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00045990943908691
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00042295455932617
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036787986755371
(189) DESCRIBE `itineraries` 0.0024368762969971
(190) DESCRIBE `ports` 0.0019528865814209
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00042891502380371
(192) DESCRIBE `ports` 0.0018470287322998
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00040602684020996
(194) DESCRIBE `ports` 0.0020921230316162
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00040698051452637
(196) DESCRIBE `sailingdates` 0.0023901462554932
(197) DESCRIBE `ports` 0.0028090476989746
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00053787231445312
(199) DESCRIBE `ports` 0.0027048587799072
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00042295455932617
(201) DESCRIBE `ports` 0.0026800632476807
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00042510032653809
(203) DESCRIBE `ports` 0.0027110576629639
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00039887428283691
(205) DESCRIBE `ports` 0.0027360916137695
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 829))) 0.00043797492980957
(207) DESCRIBE `ports` 0.0025920867919922
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '829') 0.00048184394836426
(209) DESCRIBE `ports` 0.0028481483459473
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00051999092102051
(211) DESCRIBE `ports` 0.0022518634796143
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00042104721069336
(213) DESCRIBE `ports` 0.0020828247070312
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1187))) 0.00050806999206543
(215) DESCRIBE `ports` 0.0022070407867432
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1187') 0.00045013427734375
(217) DESCRIBE `ports` 0.0029761791229248
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.000640869140625
(219) DESCRIBE `ports` 0.0026669502258301
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00057411193847656
(221) DESCRIBE `ports` 0.0025780200958252
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00061202049255371
(223) DESCRIBE `ports` 0.0026700496673584
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0084140300750732
(225) DESCRIBE `avid_specials` 0.0018689632415771
(226) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75279 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 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.0013399124145508
(227) DESCRIBE `cruiselines` 0.0032930374145508
(228) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00055789947509766
(229) DESCRIBE `orchid_image` 0.0025010108947754
(230) DESCRIBE `cruiselines` 0.0066409111022949
(231) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00052785873413086
(232) DESCRIBE `cruises` 0.0044798851013184
(233) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75241') 0.0004880428314209
(234) DESCRIBE `ships` 0.003896951675415
(235) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00051212310791016
(236) DESCRIBE `ships` 0.0037069320678711
(237) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00057697296142578
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00041389465332031
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035691261291504
(240) DESCRIBE `itineraries` 0.0020220279693604
(241) DESCRIBE `ports` 0.0020978450775146
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.0004730224609375
(243) DESCRIBE `ports` 0.0019099712371826
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00039887428283691
(245) DESCRIBE `ports` 0.0018279552459717
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00044798851013184
(247) DESCRIBE `sailingdates` 0.0016450881958008
(248) DESCRIBE `ports` 0.002025842666626
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00043296813964844
(250) DESCRIBE `ports` 0.0020260810852051
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.0004889965057373
(252) DESCRIBE `ports` 0.0019080638885498
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00043797492980957
(254) DESCRIBE `ports` 0.0018770694732666
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00038981437683105
(256) DESCRIBE `ports` 0.0020411014556885
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00052404403686523
(258) DESCRIBE `ports` 0.0021669864654541
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00041699409484863
(260) DESCRIBE `ports` 0.0020229816436768
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00048089027404785
(262) DESCRIBE `ports` 0.0018720626831055
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00045013427734375
(264) DESCRIBE `ports` 0.0018770694732666
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.0003960132598877
(266) DESCRIBE `ports` 0.0018861293792725
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00037312507629395
(268) DESCRIBE `ports` 0.0019090175628662
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00045490264892578
(270) DESCRIBE `ports` 0.0018110275268555
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00039100646972656
(272) DESCRIBE `ports` 0.0018761157989502
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00040411949157715
(274) DESCRIBE `ports` 0.0019099712371826
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00038599967956543
(276) DESCRIBE `ports` 0.0019161701202393
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00050210952758789
(278) DESCRIBE `ports` 0.0020959377288818
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00045084953308105
(280) DESCRIBE `ports` 0.0020358562469482
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00041484832763672
(282) DESCRIBE `ports` 0.0018370151519775
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00040793418884277
(284) DESCRIBE `ports` 0.0021090507507324
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00045990943908691
(286) DESCRIBE `ports` 0.0020201206207275
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00041818618774414
(288) DESCRIBE `ports` 0.0018548965454102
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00045919418334961
(290) DESCRIBE `ports` 0.0018160343170166
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00042390823364258
(292) DESCRIBE `avid_specials` 0.0017209053039551
(293) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75241 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 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.0012321472167969
(294) DESCRIBE `cruiselines` 0.0053088665008545
(295) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00069999694824219
(296) DESCRIBE `orchid_image` 0.0029759407043457
(297) DESCRIBE `cruiselines` 0.0037729740142822
(298) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.0005950927734375
(299) DESCRIBE `cruises` 0.0048990249633789
(300) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75280') 0.00048303604125977
(301) DESCRIBE `ships` 0.0041720867156982
(302) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00053882598876953
(303) DESCRIBE `ships` 0.0036699771881104
(304) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00054001808166504
(305) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00063490867614746
(306) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00045514106750488
(307) DESCRIBE `itineraries` 0.0026290416717529
(308) DESCRIBE `ports` 0.0024650096893311
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00058293342590332
(310) DESCRIBE `ports` 0.003140926361084
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00041103363037109
(312) DESCRIBE `ports` 0.0029549598693848
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00046706199645996
(314) DESCRIBE `sailingdates` 0.0019848346710205
(315) DESCRIBE `ports` 0.011867046356201
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00051283836364746
(317) DESCRIBE `ports` 0.0021960735321045
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00042390823364258
(319) DESCRIBE `ports` 0.0020589828491211
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00047707557678223
(321) DESCRIBE `ports` 0.0021669864654541
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00041508674621582
(323) DESCRIBE `ports` 0.0021340847015381
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00069117546081543
(325) DESCRIBE `ports` 0.0021250247955322
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00052499771118164
(327) DESCRIBE `ports` 0.0019748210906982
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00055694580078125
(329) DESCRIBE `ports` 0.0019769668579102
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00040602684020996
(331) DESCRIBE `ports` 0.0019710063934326
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0004429817199707
(333) DESCRIBE `ports` 0.0019440650939941
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00042986869812012
(335) DESCRIBE `ports` 0.001971960067749
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00058984756469727
(337) DESCRIBE `ports` 0.0029251575469971
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00056290626525879
(339) DESCRIBE `ports` 0.002500057220459
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0005490779876709
(341) DESCRIBE `ports` 0.0025999546051025
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0005650520324707
(343) DESCRIBE `ports` 0.0026230812072754
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00064206123352051
(345) DESCRIBE `ports` 0.0027971267700195
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00054407119750977
(347) DESCRIBE `ports` 0.0024638175964355
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00061202049255371
(349) DESCRIBE `ports` 0.0028700828552246
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00063800811767578
(351) DESCRIBE `ports` 0.0026330947875977
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 520))) 0.00061607360839844
(353) DESCRIBE `ports` 0.0026719570159912
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '520') 0.0005500316619873
(355) DESCRIBE `ports` 0.0025949478149414
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00060415267944336
(357) DESCRIBE `ports` 0.0027589797973633
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00052094459533691
(359) DESCRIBE `avid_specials` 0.0022809505462646
(360) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75280 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 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.0020580291748047
(361) DESCRIBE `cruiselines` 0.0034689903259277
(362) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00053095817565918
(363) DESCRIBE `orchid_image` 0.0029659271240234
(364) DESCRIBE `cruiselines` 0.0034408569335938
(365) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00054311752319336
(366) DESCRIBE `cruises` 0.0049259662628174
(367) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75242') 0.00060796737670898
(368) DESCRIBE `ships` 0.0059311389923096
(369) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00081205368041992
(370) DESCRIBE `ships` 0.018073081970215
(371) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00088882446289062
(372) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00055789947509766
(373) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00057601928710938
(374) DESCRIBE `itineraries` 0.0031869411468506
(375) DESCRIBE `ports` 0.0032529830932617
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00065708160400391
(377) DESCRIBE `ports` 0.0027589797973633
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00062203407287598
(379) DESCRIBE `ports` 0.0027449131011963
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00055909156799316
(381) DESCRIBE `sailingdates` 0.0022790431976318
(382) DESCRIBE `ports` 0.0028080940246582
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00067806243896484
(384) DESCRIBE `ports` 0.00242018699646
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00046491622924805
(386) DESCRIBE `ports` 0.0025529861450195
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00049805641174316
(388) DESCRIBE `ports` 0.0019772052764893
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00041580200195312
(390) DESCRIBE `ports` 0.0018188953399658
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00048613548278809
(392) DESCRIBE `ports` 0.001816987991333
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00037097930908203
(394) DESCRIBE `ports` 0.0022711753845215
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.0005950927734375
(396) DESCRIBE `ports` 0.0027811527252197
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.0005340576171875
(398) DESCRIBE `ports` 0.0021398067474365
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00043988227844238
(400) DESCRIBE `ports` 0.0018508434295654
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00038409233093262
(402) DESCRIBE `ports` 0.0017588138580322
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00046110153198242
(404) DESCRIBE `ports` 0.0018529891967773
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00038290023803711
(406) DESCRIBE `ports` 0.0020449161529541
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00039386749267578
(408) DESCRIBE `ports` 0.0019309520721436
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00036811828613281
(410) DESCRIBE `ports` 0.0017879009246826
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00051188468933105
(412) DESCRIBE `ports` 0.0018391609191895
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00036978721618652
(414) DESCRIBE `ports` 0.0021371841430664
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00051093101501465
(416) DESCRIBE `ports` 0.0021681785583496
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00044798851013184
(418) DESCRIBE `ports` 0.0020480155944824
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00040411949157715
(420) DESCRIBE `ports` 0.002025842666626
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00045680999755859
(422) DESCRIBE `ports` 0.0019960403442383
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00044798851013184
(424) DESCRIBE `ports` 0.0018188953399658
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00037002563476562
(426) DESCRIBE `avid_specials` 0.0019180774688721
(427) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75242 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 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.0012941360473633
(428) DESCRIBE `cruiselines` 0.0026741027832031
(429) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00047087669372559
(430) DESCRIBE `orchid_image` 0.0022780895233154
(431) DESCRIBE `cruiselines` 0.0033278465270996
(432) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00050902366638184
(433) DESCRIBE `cruises` 0.0035300254821777
(434) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75362') 0.00041294097900391
(435) DESCRIBE `ships` 0.003842830657959
(436) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00048613548278809
(437) DESCRIBE `ships` 0.0036690235137939
(438) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00041890144348145
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00043392181396484
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038313865661621
(441) DESCRIBE `itineraries` 0.0018057823181152
(442) DESCRIBE `ports` 0.0019621849060059
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.0004270076751709
(444) DESCRIBE `ports` 0.0018770694732666
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00038695335388184
(446) DESCRIBE `ports` 0.0018610954284668
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00038886070251465
(448) DESCRIBE `sailingdates` 0.0023519992828369
(449) DESCRIBE `ports` 0.0022621154785156
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00048708915710449
(451) DESCRIBE `ports` 0.0029470920562744
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00047492980957031
(453) DESCRIBE `ports` 0.0060019493103027
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00062894821166992
(455) DESCRIBE `ports` 0.0022289752960205
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00049400329589844
(457) DESCRIBE `ports` 0.0023300647735596
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00051593780517578
(459) DESCRIBE `ports` 0.0024979114532471
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00049495697021484
(461) DESCRIBE `ports` 0.0020520687103271
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0005180835723877
(463) DESCRIBE `ports` 0.0025711059570312
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00066494941711426
(465) DESCRIBE `ports` 0.0031628608703613
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00080490112304688
(467) DESCRIBE `ports` 0.002500057220459
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00052094459533691
(469) DESCRIBE `ports` 0.0021939277648926
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00054383277893066
(471) DESCRIBE `ports` 0.0020251274108887
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0004270076751709
(473) DESCRIBE `ports` 0.0019071102142334
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0004119873046875
(475) DESCRIBE `ports` 0.0021920204162598
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00040984153747559
(477) DESCRIBE `ports` 0.0018620491027832
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0004730224609375
(479) DESCRIBE `ports` 0.0020980834960938
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00037288665771484
(481) DESCRIBE `ports` 0.0018050670623779
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 520))) 0.00049901008605957
(483) DESCRIBE `ports` 0.0020430088043213
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '520') 0.00064897537231445
(485) DESCRIBE `ports` 0.0027830600738525
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00066590309143066
(487) DESCRIBE `ports` 0.0020720958709717
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00050687789916992
(489) DESCRIBE `ports` 0.0018219947814941
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00060915946960449
(491) DESCRIBE `ports` 0.0027079582214355
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00059103965759277
(493) DESCRIBE `avid_specials` 0.001708984375
(494) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75362 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 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.0012619495391846
(495) DESCRIBE `cruiselines` 0.002856969833374
(496) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0004880428314209
(497) DESCRIBE `orchid_image` 0.0023820400238037
(498) DESCRIBE `cruiselines` 0.0025639533996582
(499) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00048017501831055
(500) DESCRIBE `cruises` 0.0037391185760498
(501) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75243') 0.00043392181396484
(502) DESCRIBE `ships` 0.0043158531188965
(503) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00079989433288574
(504) DESCRIBE `ships` 0.0053131580352783
(505) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00061416625976562
(506) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00052309036254883
(507) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00051188468933105
(508) DESCRIBE `itineraries` 0.002730131149292
(509) DESCRIBE `ports` 0.0021309852600098
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00054407119750977
(511) DESCRIBE `ports` 0.00201416015625
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00054407119750977
(513) DESCRIBE `ports` 0.0018050670623779
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00045108795166016
(515) DESCRIBE `sailingdates` 0.0016710758209229
(516) DESCRIBE `ports` 0.0023469924926758
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00045609474182129
(518) DESCRIBE `ports` 0.0020301342010498
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00040817260742188
(520) DESCRIBE `ports` 0.001971960067749
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00044012069702148
(522) DESCRIBE `ports` 0.0018720626831055
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.0003819465637207
(524) DESCRIBE `ports` 0.0019690990447998
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00039815902709961
(526) DESCRIBE `ports` 0.0019569396972656
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00036716461181641
(528) DESCRIBE `ports` 0.0018458366394043
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00048494338989258
(530) DESCRIBE `ports` 0.0017881393432617
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00049185752868652
(532) DESCRIBE `ports` 0.0017910003662109
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00043892860412598
(534) DESCRIBE `ports` 0.0020279884338379
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00039291381835938
(536) DESCRIBE `ports` 0.0021321773529053
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00059103965759277
(538) DESCRIBE `ports` 0.0021178722381592
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00048303604125977
(540) DESCRIBE `ports` 0.0018489360809326
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00044798851013184
(542) DESCRIBE `ports` 0.002194881439209
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00044512748718262
(544) DESCRIBE `avid_specials` 0.0017139911651611
(545) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75243 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 28 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.0013699531555176
(546) DESCRIBE `cruiselines` 0.0025660991668701
(547) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00049996376037598
(548) DESCRIBE `orchid_image` 0.0021650791168213
(549) DESCRIBE `cruiselines` 0.0027520656585693
(550) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00041389465332031
(551) DESCRIBE `cruises` 0.0044240951538086
(552) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75244') 0.00047516822814941
(553) DESCRIBE `ships` 0.003695011138916
(554) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00050115585327148
(555) DESCRIBE `ships` 0.0039410591125488
(556) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00056314468383789
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036406517028809
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034904479980469
(559) DESCRIBE `itineraries` 0.0024149417877197
(560) DESCRIBE `ports` 0.0035810470581055
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00076198577880859
(562) DESCRIBE `ports` 0.0024991035461426
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.0004270076751709
(564) DESCRIBE `ports` 0.0020148754119873
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00042605400085449
(566) DESCRIBE `sailingdates` 0.0016961097717285
(567) DESCRIBE `ports` 0.0022017955780029
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00045514106750488
(569) DESCRIBE `ports` 0.0019199848175049
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00045180320739746
(571) DESCRIBE `ports` 0.0020308494567871
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00053501129150391
(573) DESCRIBE `ports` 0.0022978782653809
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.0004119873046875
(575) DESCRIBE `ports` 0.0020079612731934
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00057482719421387
(577) DESCRIBE `ports` 0.002636194229126
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00054001808166504
(579) DESCRIBE `ports` 0.0027470588684082
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.0004730224609375
(581) DESCRIBE `ports` 0.0020120143890381
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00045394897460938
(583) DESCRIBE `ports` 0.002964973449707
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00063610076904297
(585) DESCRIBE `ports` 0.0026350021362305
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00058913230895996
(587) DESCRIBE `ports` 0.0026199817657471
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00064992904663086
(589) DESCRIBE `ports` 0.0026369094848633
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00053191184997559
(591) DESCRIBE `ports` 0.0026810169219971
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00063419342041016
(593) DESCRIBE `ports` 0.0027480125427246
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.0005488395690918
(595) DESCRIBE `avid_specials` 0.0024960041046143
(596) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75244 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 28 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.0021631717681885
(597) DESCRIBE `cruiselines` 0.0040130615234375
(598) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00068306922912598
(599) DESCRIBE `orchid_image` 0.002971887588501
(600) DESCRIBE `cruiselines` 0.0040888786315918
(601) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00066709518432617
(602) DESCRIBE `ships` 0.0039999485015869
(603) SELECT `ships`.* FROM `ships` WHERE (id IN ('1454', '1308', '818', '1730', '1479')) ORDER BY FIND_IN_SET(id, '1454,1308,818,1730,1479') 0.001194953918457
(604) DESCRIBE `cruisetypes` 0.0016129016876221
(605) DESCRIBE `destinations` 0.0023801326751709
(606) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('21', '40', '25', '28', '26', '8', '49', '11', '35', '30', '55')) ORDER BY FIND_IN_SET(id, '21,40,25,28,26,8,49,11,35,30,55') 0.0020568370819092
(607) DESCRIBE `cruiselines` 0.0027031898498535
(608) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00057101249694824
(609) DESCRIBE `cruiselines` 0.0027730464935303
(610) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00043892860412598