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

Total elapsed time: 0.84001874923706

# Query Time
(1) connect 0.00090599060058594
(2) DESCRIBE `cruises` 0.0038368701934814
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63782, 66413, 66418, 69368, 69426, 69605, 72893, 74260, 74429, 74576)) ORDER BY FIND_IN_SET(id, '63782,66413,66418,69368,69426,69605,72893,74260,74429,74576') 0.0012638568878174
(4) DESCRIBE `cruises` 0.002979040145874
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63782') 0.00038695335388184
(6) DESCRIBE `ships` 0.0029292106628418
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 743))) 0.00042104721069336
(8) DESCRIBE `ships` 0.0029199123382568
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '743') 0.00037503242492676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033998489379883
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002598762512207
(12) DESCRIBE `itineraries` 0.0014088153839111
(13) DESCRIBE `ports` 0.0019519329071045
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0.00013589859008789
(15) DESCRIBE `ports` 0.0021867752075195
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0
(17) DESCRIBE `ports` 0.0010409355163574
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4401') 0.00025415420532227
(19) DESCRIBE `sailingdates` 0.0011260509490967
(20) DESCRIBE `ports` 0.0023899078369141
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0.00063014030456543
(22) DESCRIBE `ports` 0.0021510124206543
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4401') 0.00049996376037598
(24) DESCRIBE `ports` 0.0018250942230225
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 373))) 0.00043487548828125
(26) DESCRIBE `ports` 0.001741886138916
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '373') 0.00044798851013184
(28) DESCRIBE `ports` 0.0018281936645508
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00048708915710449
(30) DESCRIBE `ports` 0.0021378993988037
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00045919418334961
(32) DESCRIBE `ports` 0.0019009113311768
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0003969669342041
(34) DESCRIBE `ports` 0.0015308856964111
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00032305717468262
(36) DESCRIBE `ports` 0.0020930767059326
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1626))) 0.0004580020904541
(38) DESCRIBE `ports` 0.0013430118560791
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1626') 0.00037503242492676
(40) DESCRIBE `ports` 0.0015799999237061
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1942))) 0.00041103363037109
(42) DESCRIBE `ports` 0.0017220973968506
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1942') 0.00045490264892578
(44) DESCRIBE `ports` 0.0024640560150146
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00049901008605957
(46) DESCRIBE `ports` 0.0018742084503174
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00044393539428711
(48) DESCRIBE `ports` 0.0020089149475098
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00048208236694336
(50) DESCRIBE `ports` 0.0019009113311768
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00046896934509277
(52) DESCRIBE `ports` 0.0017869472503662
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 925))) 0.00042915344238281
(54) DESCRIBE `ports` 0.0019400119781494
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '925') 0.0004420280456543
(56) DESCRIBE `ports` 0.0018899440765381
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0.00046515464782715
(58) DESCRIBE `ports` 0.0018870830535889
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4401') 0.00034379959106445
(60) DESCRIBE `avid_specials` 0.0017950534820557
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63782 and class = 'Cruise') OR (item_id = 743 AND class = 'Ship') OR (item_id = 141 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.004539966583252
(62) DESCRIBE `cruiselines` 0.0026001930236816
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.00041484832763672
(64) DESCRIBE `orchid_image` 0.007094144821167
(65) DESCRIBE `cruiselines` 0.011629104614258
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00042104721069336
(67) DESCRIBE `cruises` 0.003450870513916
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66413') 0.00084614753723145
(69) DESCRIBE `ships` 0.0034260749816895
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00047707557678223
(71) DESCRIBE `ships` 0.0027358531951904
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00034904479980469
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026392936706543
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(75) DESCRIBE `itineraries` 0.001288890838623
(76) DESCRIBE `ports` 0.0017309188842773
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00035905838012695
(78) DESCRIBE `ports` 0.012402772903442
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00047588348388672
(80) DESCRIBE `ports` 0.0014920234680176
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.0003049373626709
(82) DESCRIBE `sailingdates` 0.0011780261993408
(83) DESCRIBE `ports` 0.0015199184417725
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00069594383239746
(85) DESCRIBE `ports` 0.0014290809631348
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00046110153198242
(87) DESCRIBE `ports` 0.0022580623626709
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.0060811042785645
(89) DESCRIBE `ports` 0.0015461444854736
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00034308433532715
(91) DESCRIBE `ports` 0.0014209747314453
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00028896331787109
(93) DESCRIBE `ports` 0.0013477802276611
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00030207633972168
(95) DESCRIBE `ports` 0.0013449192047119
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0069730281829834
(97) DESCRIBE `ports` 0.0015511512756348
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00030207633972168
(99) DESCRIBE `ports` 0.0013129711151123
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00031495094299316
(101) DESCRIBE `ports` 0.001331090927124
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.0003349781036377
(103) DESCRIBE `ports` 0.0013442039489746
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00029516220092773
(105) DESCRIBE `ports` 0.0013389587402344
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.0097968578338623
(107) DESCRIBE `ports` 0.0020987987518311
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0004570484161377
(109) DESCRIBE `ports` 0.0016059875488281
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00037097930908203
(111) DESCRIBE `ports` 0.0013701915740967
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00038385391235352
(113) DESCRIBE `ports` 0.0014839172363281
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00040507316589355
(115) DESCRIBE `avid_specials` 0.001352071762085
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66413 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0092709064483643
(117) DESCRIBE `cruiselines` 0.0025100708007812
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0004429817199707
(119) DESCRIBE `orchid_image` 0.0017111301422119
(120) DESCRIBE `cruiselines` 0.0020928382873535
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.0087080001831055
(122) DESCRIBE `cruises` 0.0034041404724121
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66418') 0.00038790702819824
(124) DESCRIBE `ships` 0.0037229061126709
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00049805641174316
(126) DESCRIBE `ships` 0.0028271675109863
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.00032401084899902
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032305717468262
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027179718017578
(130) DESCRIBE `itineraries` 0.0015490055084229
(131) DESCRIBE `ports` 0.0014898777008057
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00045490264892578
(133) DESCRIBE `ports` 0.0013899803161621
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00030708312988281
(135) DESCRIBE `ports` 0.001370906829834
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00028800964355469
(137) DESCRIBE `sailingdates` 0.0011160373687744
(138) DESCRIBE `ports` 0.0016472339630127
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00038480758666992
(140) DESCRIBE `ports` 0.0015509128570557
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00030303001403809
(142) DESCRIBE `ports` 0.0013740062713623
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00034689903259277
(144) DESCRIBE `ports` 0.0013339519500732
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.0003199577331543
(146) DESCRIBE `ports` 0.0017569065093994
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4104))) 0.00031304359436035
(148) DESCRIBE `ports` 0.0015389919281006
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4104') 0.00029397010803223
(150) DESCRIBE `ports` 0.0012660026550293
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00038599967956543
(152) DESCRIBE `ports` 0.0012640953063965
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00031399726867676
(154) DESCRIBE `ports` 0.0014779567718506
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00031900405883789
(156) DESCRIBE `ports` 0.0015778541564941
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00027608871459961
(158) DESCRIBE `ports` 0.0014059543609619
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00043797492980957
(160) DESCRIBE `ports` 0.0020108222961426
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00041604042053223
(162) DESCRIBE `ports` 0.0018370151519775
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00043702125549316
(164) DESCRIBE `ports` 0.0017468929290771
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00038909912109375
(166) DESCRIBE `ports` 0.0017030239105225
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00039887428283691
(168) DESCRIBE `ports` 0.0013821125030518
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00030612945556641
(170) DESCRIBE `avid_specials` 0.0012149810791016
(171) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66418 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010731220245361
(172) DESCRIBE `cruiselines` 0.0021219253540039
(173) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00047183036804199
(174) DESCRIBE `orchid_image` 0.0019090175628662
(175) DESCRIBE `cruiselines` 0.0022900104522705
(176) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00036382675170898
(177) DESCRIBE `cruises` 0.0032780170440674
(178) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69368') 0.00047802925109863
(179) DESCRIBE `ships` 0.0033900737762451
(180) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1599))) 0.0088629722595215
(181) DESCRIBE `ships` 0.0040981769561768
(182) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1599') 0.00051188468933105
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00038599967956543
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00033283233642578
(185) DESCRIBE `itineraries` 0.0018441677093506
(186) DESCRIBE `ports` 0.009354829788208
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003669261932373
(188) DESCRIBE `ports` 0.0019168853759766
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031304359436035
(190) DESCRIBE `ports` 0.0012581348419189
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028300285339355
(192) DESCRIBE `sailingdates` 0.0011980533599854
(193) DESCRIBE `ports` 0.0017600059509277
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032997131347656
(195) DESCRIBE `ports` 0.0012838840484619
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027704238891602
(197) DESCRIBE `ports` 0.0012969970703125
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031399726867676
(199) DESCRIBE `ports` 0.0013329982757568
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026178359985352
(201) DESCRIBE `ports` 0.0013329982757568
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00035786628723145
(203) DESCRIBE `ports` 0.001439094543457
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00037884712219238
(205) DESCRIBE `ports` 0.001924991607666
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00049090385437012
(207) DESCRIBE `ports` 0.0017468929290771
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00031685829162598
(209) DESCRIBE `ports` 0.0017769336700439
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00041413307189941
(211) DESCRIBE `ports` 0.0015079975128174
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00039315223693848
(213) DESCRIBE `ports` 0.0016911029815674
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00031781196594238
(215) DESCRIBE `ports` 0.0016191005706787
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00039196014404297
(217) DESCRIBE `ports` 0.0015430450439453
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042486190795898
(219) DESCRIBE `ports` 0.002004861831665
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042200088500977
(221) DESCRIBE `avid_specials` 0.0018870830535889
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69368 and class = 'Cruise') OR (item_id = 1599 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015799999237061
(223) DESCRIBE `cruiselines` 0.0027060508728027
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00066018104553223
(225) DESCRIBE `orchid_image` 0.0023200511932373
(226) DESCRIBE `cruiselines` 0.002838134765625
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00063991546630859
(228) DESCRIBE `cruises` 0.0099749565124512
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69426') 0.00047898292541504
(230) DESCRIBE `ships` 0.0032439231872559
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1272))) 0.00045609474182129
(232) DESCRIBE `ships` 0.0028469562530518
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1272') 0.00033712387084961
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028491020202637
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026917457580566
(236) DESCRIBE `itineraries` 0.0015439987182617
(237) DESCRIBE `ports` 0.001309871673584
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037503242492676
(239) DESCRIBE `ports` 0.0014259815216064
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030088424682617
(241) DESCRIBE `ports` 0.0013020038604736
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028896331787109
(243) DESCRIBE `sailingdates` 0.0012540817260742
(244) DESCRIBE `ports` 0.0014421939849854
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00036191940307617
(246) DESCRIBE `ports` 0.001410961151123
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00031709671020508
(248) DESCRIBE `ports` 0.0015201568603516
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00049686431884766
(250) DESCRIBE `ports` 0.0017111301422119
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00030398368835449
(252) DESCRIBE `ports` 0.0016560554504395
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00044012069702148
(254) DESCRIBE `ports` 0.0018889904022217
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00036501884460449
(256) DESCRIBE `ports` 0.0016870498657227
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00050902366638184
(258) DESCRIBE `ports` 0.001594066619873
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026798248291016
(260) DESCRIBE `ports` 0.0017471313476562
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00030899047851562
(262) DESCRIBE `ports` 0.0019290447235107
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00033879280090332
(264) DESCRIBE `ports` 0.0022141933441162
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00042009353637695
(266) DESCRIBE `ports` 0.0011970996856689
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00026988983154297
(268) DESCRIBE `ports` 0.001492977142334
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00023913383483887
(270) DESCRIBE `ports` 0.0014619827270508
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00028014183044434
(272) DESCRIBE `ports` 0.0011551380157471
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030112266540527
(274) DESCRIBE `ports` 0.0012729167938232
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028419494628906
(276) DESCRIBE `avid_specials` 0.0012350082397461
(277) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69426 and class = 'Cruise') OR (item_id = 1272 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016429424285889
(278) DESCRIBE `cruiselines` 0.0020010471343994
(279) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00039887428283691
(280) DESCRIBE `orchid_image` 0.0015511512756348
(281) DESCRIBE `cruiselines` 0.0018689632415771
(282) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00027704238891602
(283) DESCRIBE `cruises` 0.0035791397094727
(284) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69605') 0.00054097175598145
(285) DESCRIBE `ships` 0.0033600330352783
(286) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 704))) 0.0004270076751709
(287) DESCRIBE `ships` 0.002863883972168
(288) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '704') 0.00031781196594238
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039887428283691
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021982192993164
(291) DESCRIBE `itineraries` 0.00136399269104
(292) DESCRIBE `ports` 0.002208948135376
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00032687187194824
(294) DESCRIBE `ports` 0.0014009475708008
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00031709671020508
(296) DESCRIBE `ports` 0.0013101100921631
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.0003349781036377
(298) DESCRIBE `sailingdates` 0.0011489391326904
(299) DESCRIBE `ports` 0.0014681816101074
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00030899047851562
(301) DESCRIBE `ports` 0.0013539791107178
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00030207633972168
(303) DESCRIBE `ports` 0.0013890266418457
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00031614303588867
(305) DESCRIBE `ports` 0.0013959407806396
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00030112266540527
(307) DESCRIBE `ports` 0.0013260841369629
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.0003209114074707
(309) DESCRIBE `ports` 0.001244068145752
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00032997131347656
(311) DESCRIBE `ports` 0.0015268325805664
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1967))) 0.0004889965057373
(313) DESCRIBE `ports` 0.0014181137084961
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1967') 0.00028109550476074
(315) DESCRIBE `ports` 0.0013961791992188
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4944))) 0.00038290023803711
(317) DESCRIBE `ports` 0.0013580322265625
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4944') 0.00031399726867676
(319) DESCRIBE `ports` 0.0012528896331787
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2175))) 0.00018095970153809
(321) DESCRIBE `ports` 0.0014619827270508
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2175') 0.00031900405883789
(323) DESCRIBE `ports` 0.0013167858123779
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4104))) 0.00046610832214355
(325) DESCRIBE `ports` 0.0013718605041504
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4104') 0.00023293495178223
(327) DESCRIBE `ports` 0.0012798309326172
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0004270076751709
(329) DESCRIBE `ports` 0.0014050006866455
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00022792816162109
(331) DESCRIBE `avid_specials` 0.0011439323425293
(332) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69605 and class = 'Cruise') OR (item_id = 704 AND class = 'Ship') OR (item_id = 208 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012619495391846
(333) DESCRIBE `cruiselines` 0.0018899440765381
(334) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.00030207633972168
(335) DESCRIBE `orchid_image` 0.0015089511871338
(336) DESCRIBE `cruiselines` 0.0019528865814209
(337) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.00023007392883301
(338) DESCRIBE `cruises` 0.0026121139526367
(339) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72893') 0.00030994415283203
(340) DESCRIBE `ships` 0.0025970935821533
(341) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00044608116149902
(342) DESCRIBE `ships` 0.0029029846191406
(343) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00038599967956543
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037598609924316
(345) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030088424682617
(346) DESCRIBE `itineraries` 0.0013818740844727
(347) DESCRIBE `ports` 0.0014388561248779
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031208992004395
(349) DESCRIBE `ports` 0.0014588832855225
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030112266540527
(351) DESCRIBE `ports` 0.0013000965118408
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030303001403809
(353) DESCRIBE `sailingdates` 0.0012059211730957
(354) DESCRIBE `ports` 0.0012650489807129
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00052404403686523
(356) DESCRIBE `ports` 0.0014309883117676
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00036716461181641
(358) DESCRIBE `ports` 0.0011909008026123
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00032496452331543
(360) DESCRIBE `ports` 0.0012619495391846
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00039196014404297
(362) DESCRIBE `ports` 0.0014419555664062
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00033092498779297
(364) DESCRIBE `ports` 0.0014398097991943
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00027799606323242
(366) DESCRIBE `ports` 0.0012829303741455
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00033807754516602
(368) DESCRIBE `ports` 0.0012679100036621
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00027990341186523
(370) DESCRIBE `ports` 0.0013389587402344
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00036883354187012
(372) DESCRIBE `ports` 0.0013318061828613
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00029110908508301
(374) DESCRIBE `ports` 0.001370906829834
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 379))) 0.0003049373626709
(376) DESCRIBE `ports` 0.0014839172363281
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '379') 0.00033307075500488
(378) DESCRIBE `ports` 0.0012540817260742
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.0003211498260498
(380) DESCRIBE `ports` 0.0012772083282471
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00027298927307129
(382) DESCRIBE `ports` 0.001270055770874
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0003058910369873
(384) DESCRIBE `ports` 0.0015969276428223
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0003209114074707
(386) DESCRIBE `avid_specials` 0.0012149810791016
(387) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72893 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 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.001284122467041
(388) DESCRIBE `cruiselines` 0.0018689632415771
(389) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00034880638122559
(390) DESCRIBE `orchid_image` 0.0014770030975342
(391) DESCRIBE `cruiselines` 0.0018680095672607
(392) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00032186508178711
(393) DESCRIBE `cruises` 0.0025861263275146
(394) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74260') 0.00030684471130371
(395) DESCRIBE `ships` 0.0027341842651367
(396) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 204))) 0.00037288665771484
(397) DESCRIBE `ships` 0.0026988983154297
(398) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '204') 0.00028014183044434
(399) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(400) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(401) DESCRIBE `itineraries` 0.0012149810791016
(402) DESCRIBE `ports` 0.001349925994873
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00042390823364258
(404) DESCRIBE `ports` 0.00067400932312012
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00023293495178223
(406) DESCRIBE `ports` 0.0013952255249023
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00031900405883789
(408) DESCRIBE `sailingdates` 0.0010929107666016
(409) DESCRIBE `ports` 0.0013949871063232
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00031304359436035
(411) DESCRIBE `ports` 0.0015449523925781
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00030708312988281
(413) DESCRIBE `ports` 0.0013160705566406
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 567))) 0.0001990795135498
(415) DESCRIBE `ports` 0.0016350746154785
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '567') 0.00050783157348633
(417) DESCRIBE `ports` 0.0019087791442871
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 885))) 0.0034611225128174
(419) DESCRIBE `ports` 0.001676082611084
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '885') 0.0011341571807861
(421) DESCRIBE `ports` 0.0015649795532227
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2987))) 0.0001220703125
(423) DESCRIBE `ports` 0.0024278163909912
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2987') 0.00021600723266602
(425) DESCRIBE `ports` 0.0015690326690674
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 9.9897384643555E-5
(427) DESCRIBE `ports` 0.0015349388122559
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00040292739868164
(429) DESCRIBE `ports` 0.0017337799072266
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0
(431) DESCRIBE `ports` 0.0021331310272217
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0007929801940918
(433) DESCRIBE `avid_specials` 0.0015139579772949
(434) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74260 and class = 'Cruise') OR (item_id = 204 AND class = 'Ship') OR (item_id = 50 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.0082898139953613
(435) DESCRIBE `cruiselines` 0.002636194229126
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00050115585327148
(437) DESCRIBE `orchid_image` 0.0018560886383057
(438) DESCRIBE `cruiselines` 0.0026109218597412
(439) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.010607004165649
(440) DESCRIBE `cruises` 0.0028707981109619
(441) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74429') 0.0004889965057373
(442) DESCRIBE `ships` 0.0031108856201172
(443) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 626))) 0.0091750621795654
(444) DESCRIBE `ships` 0.0036909580230713
(445) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '626') 0.00030398368835449
(446) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026822090148926
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040411949157715
(448) DESCRIBE `itineraries` 0.0082221031188965
(449) DESCRIBE `ports` 0.0015478134155273
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00035190582275391
(451) DESCRIBE `ports` 0.0013000965118408
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00031805038452148
(453) DESCRIBE `ports` 0.0014510154724121
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00032281875610352
(455) DESCRIBE `sailingdates` 0.0011968612670898
(456) DESCRIBE `ports` 0.0060789585113525
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0038471221923828
(458) DESCRIBE `ports` 0.0021889209747314
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.002406120300293
(460) DESCRIBE `ports` 0.0016560554504395
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00388503074646
(462) DESCRIBE `ports` 0.0018839836120605
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.0004420280456543
(464) DESCRIBE `ports` 0.0030159950256348
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00030899047851562
(466) DESCRIBE `ports` 0.0024759769439697
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.0022358894348145
(468) DESCRIBE `ports` 0.0013411045074463
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00041079521179199
(470) DESCRIBE `ports` 0.0013339519500732
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00028109550476074
(472) DESCRIBE `ports` 0.0016400814056396
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00030279159545898
(474) DESCRIBE `ports` 0.0013918876647949
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00039386749267578
(476) DESCRIBE `avid_specials` 0.0040569305419922
(477) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74429 and class = 'Cruise') OR (item_id = 626 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 10 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.001086950302124
(478) DESCRIBE `cruiselines` 0.0043878555297852
(479) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0032751560211182
(480) DESCRIBE `orchid_image` 0.0016160011291504
(481) DESCRIBE `cruiselines` 0.0044200420379639
(482) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0019559860229492
(483) DESCRIBE `cruises` 0.0026059150695801
(484) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74576') 5.6028366088867E-5
(485) DESCRIBE `ships` 0.003242015838623
(486) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00066900253295898
(487) DESCRIBE `ships` 0.0034141540527344
(488) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 2.8133392333984E-5
(489) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00090813636779785
(491) DESCRIBE `itineraries` 0.0013241767883301
(492) DESCRIBE `ports` 0.00118088722229
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0
(494) DESCRIBE `ports` 0.0025269985198975
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00064396858215332
(496) DESCRIBE `ports` 0.0016028881072998
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 7.0810317993164E-5
(498) DESCRIBE `sailingdates` 0.0014948844909668
(499) DESCRIBE `ports` 0.0019612312316895
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00038504600524902
(501) DESCRIBE `ports` 0.0016090869903564
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00038886070251465
(503) DESCRIBE `ports` 0.0016310214996338
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00040292739868164
(505) DESCRIBE `ports` 0.0015389919281006
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00015616416931152
(507) DESCRIBE `ports` 0.0017669200897217
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0006561279296875
(509) DESCRIBE `ports` 0.00083589553833008
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00066900253295898
(511) DESCRIBE `ports` 0.001741886138916
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 6.1988830566406E-5
(513) DESCRIBE `ports` 0.0017528533935547
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00058412551879883
(515) DESCRIBE `ports` 0.0018508434295654
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4104))) 0.00037312507629395
(517) DESCRIBE `ports` 0.0011429786682129
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4104') 0.00067687034606934
(519) DESCRIBE `ports` 0.0017910003662109
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00095915794372559
(521) DESCRIBE `ports` 0.0011730194091797
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00016593933105469
(523) DESCRIBE `ports` 0.0020890235900879
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00086593627929688
(525) DESCRIBE `ports` 0.0010221004486084
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0010740756988525
(527) DESCRIBE `avid_specials` 0.0016000270843506
(528) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74576 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00091409683227539
(529) DESCRIBE `cruiselines` 0.0014150142669678
(530) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00032711029052734
(531) DESCRIBE `orchid_image` 0.0015950202941895
(532) DESCRIBE `cruiselines` 0.0027079582214355
(533) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00012588500976562
(534) DESCRIBE `cruiselines` 0.0029678344726562
(535) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '144', '183', '12', '23', '20', '101', '18', '7', '8', '131', '96', '171', '103', '156', '33', '120', '15', '262', '191', '29', '31', '258', '91', '208', '50', '28', '14', '187', '251', '114', '49', '212', '24', '47', '37', '206', '16', '153', '151', '36', '170', '110', '118', '181', '264', '195', '4', '30', '88', '59', '108', '159', '141', '140', '73', '35', '216', '90', '147', '211', '113', '57', '180', '64', '257', '261', '38', '48', '115', '276', '213', '184', '95', '105', '52', '82', '244', '209', '177', '134', '245')) ORDER BY FIND_IN_SET(id, '218,19,77,26,144,183,12,23,20,101,18,7,8,131,96,171,103,156,33,120,15,262,191,29,31,258,91,208,50,28,14,187,251,114,49,212,24,47,37,206,16,153,151,36,170,110,118,181,264,195,4,30,88,59,108,159,141,140,73,35,216,90,147,211,113,57,180,64,257,261,38,48,115,276,213,184,95,105,52,82,244,209,177,134,245') 0.02274489402771
(536) DESCRIBE `ships` 0.0042309761047363
(537) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '726', '1744', '1588', '977', '517', '1594', '1555', '454', '1794', '1237', '780', '1272', '974', '1717', '1032', '1359', '258', '797', '1292', '22', '461', '21', '330', '770', '393', '404', '28', '1677', '986', '1348', '1205', '716', '1415', '349', '674', '333', '11', '10', '207', '439', '739', '1067', '9', '521', '715', '25', '24', '163', '480', '738', '882', '3', '1135', '1599', '1607', '455', '1260', '1678', '407', '553', '113', '1141', '1008', '434', '1455', '160', '766', '1773', '1682', '265', '792', '1768', '610', '817', '1569', '1742', '711', '332', '520', '1454', '352', '63', '66', '1372', '737', '1291', '626', '462', '542', '657', '1021', '1199', '585', '1308', '1721', '1738', '1068', '285', '1163', '1410', '14', '1302', '1411', '1413', '1526', '748', '314', '526', '1320', '1323', '1579', '855', '286', '390', '405', '573', '970', '1063', '1417', '31', '34', '38', '43', '327', '582', '854', '1259', '37', '590', '837', '1402', '378', '1463', '1088', '124', '1321', '1586', '580', '791', '958', '1013', '1208', '1552', '1284', '1811', '119', '162', '441', '1159', '1193', '1266', '678', '1139', '1157', '114', '1492', '1587', '1766', '401', '406', '850', '1245', '1318', '4', '335', '351', '451', '545', '616', '1028', '1412', '1672', '386', '704', '1461', '212', '547', '658', '1722', '39', '84', '722', '1236', '1326', '1327', '1782', '30', '35', '36', '148', '340', '403', '1012', '1040', '1289', '385', '988', '1330', '1398', '1408', '325', '601', '1108', '1303', '1575', '1711', '27', '287', '683', '966', '291', '652', '1043', '1172', '105', '201', '389', '508', '627', '639', '78', '818', '1168', '394', '1223', '111', '852', '1424', '1740', '1743', '338', '776', '1019', '1319', '1344', '1419', '1420', '1422', '1423', '262', '485', '751', '775', '1325', '1715', '1716', '123', '290', '673', '1029', '1160', '1217', '1343', '1418', '1421', '1452', '1453', '1801', '1037', '1229', '1426', '1604', '266', '1373', '1405', '45', '348', '701', '1095', '1226', '1704', '559', '768', '905', '1137', '1283', '1358', '1809', '253', '972', '1136', '1448', '223', '1150', '1282', '69', '341', '574', '709', '851', '968', '98', '151', '651', '973', '1409', '324', '643', '1055', '1724', '1808', '108', '150', '857', '1230', '1231', '1458', '1474', '1501', '1713', '1730', '1767', '82', '663', '858', '954', '996', '1714', '75', '769', '885', '1035', '1042', '1154', '1206', '1368', '1609', '1632', '1751', '467', '666', '884', '1360', '1361', '1362', '1459', '1574', '1708', '1723', '1750', '1049', '1772', '1148', '1322', '1483', '1771', '665', '888', '944', '375', '423', '703', '790', '1051', '1681', '147', '717', '784', '1020', '1071', '1188', '1293', '1301', '1580', '70', '1054', '1601', '152', '422', '483', '516', '707', '1075', '1224', '1445', '1486', '81', '1047', '1052', '1676', '796', '886', '937', '1036', '1572', '1679', '93', '116', '1048', '1138', '1262', '1351', '1437', '1465', '1781', '1045', '1329', '1539', '1673', '74', '149', '420', '1519', '1807', '644', '1060', '1109', '1146', '1444', '1468', '198', '503', '656', '1039', '1050', '1143', '1196', '1232', '1350', '205', '419', '1073', '1151', '1254', '1389', '1581', '1749', '1791', '795', '982', '1294', '1367', '1540', '1645', '1684', '1806', '452', '1064', '1800', '1816', '421', '761', '808', '1044', '1805', '493', '965', '1788', '479', '494', '687', '1297', '1624', '1674', '1706', '671', '1053', '1158', '1241', '1626', '1709', '883', '1156', '1195', '1316', '1571', '240', '767', '1025', '1090', '1144', '1340', '1342', '1647', '635', '695', '733', '979', '1027', '1113', '1341', '1663', '1089', '1155', '1256', '1295', '1024', '1038', '1296', '1471', '1710', '1792', '299', '300', '685', '692', '1451')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,1744,1588,977,517,1594,1555,454,1794,1237,780,1272,974,1717,1032,1359,258,797,1292,22,461,21,330,770,393,404,28,1677,986,1348,1205,716,1415,349,674,333,11,10,207,439,739,1067,9,521,715,25,24,163,480,738,882,3,1135,1599,1607,455,1260,1678,407,553,113,1141,1008,434,1455,160,766,1773,1682,265,792,1768,610,817,1569,1742,711,332,520,1454,352,63,66,1372,737,1291,626,462,542,657,1021,1199,585,1308,1721,1738,1068,285,1163,1410,14,1302,1411,1413,1526,748,314,526,1320,1323,1579,855,286,390,405,573,970,1063,1417,31,34,38,43,327,582,854,1259,37,590,837,1402,378,1463,1088,124,1321,1586,580,791,958,1013,1208,1552,1284,1811,119,162,441,1159,1193,1266,678,1139,1157,114,1492,1587,1766,401,406,850,1245,1318,4,335,351,451,545,616,1028,1412,1672,386,704,1461,212,547,658,1722,39,84,722,1236,1326,1327,1782,30,35,36,148,340,403,1012,1040,1289,385,988,1330,1398,1408,325,601,1108,1303,1575,1711,27,287,683,966,291,652,1043,1172,105,201,389,508,627,639,78,818,1168,394,1223,111,852,1424,1740,1743,338,776,1019,1319,1344,1419,1420,1422,1423,262,485,751,775,1325,1715,1716,123,290,673,1029,1160,1217,1343,1418,1421,1452,1453,1801,1037,1229,1426,1604,266,1373,1405,45,348,701,1095,1226,1704,559,768,905,1137,1283,1358,1809,253,972,1136,1448,223,1150,1282,69,341,574,709,851,968,98,151,651,973,1409,324,643,1055,1724,1808,108,150,857,1230,1231,1458,1474,1501,1713,1730,1767,82,663,858,954,996,1714,75,769,885,1035,1042,1154,1206,1368,1609,1632,1751,467,666,884,1360,1361,1362,1459,1574,1708,1723,1750,1049,1772,1148,1322,1483,1771,665,888,944,375,423,703,790,1051,1681,147,717,784,1020,1071,1188,1293,1301,1580,70,1054,1601,152,422,483,516,707,1075,1224,1445,1486,81,1047,1052,1676,796,886,937,1036,1572,1679,93,116,1048,1138,1262,1351,1437,1465,1781,1045,1329,1539,1673,74,149,420,1519,1807,644,1060,1109,1146,1444,1468,198,503,656,1039,1050,1143,1196,1232,1350,205,419,1073,1151,1254,1389,1581,1749,1791,795,982,1294,1367,1540,1645,1684,1806,452,1064,1800,1816,421,761,808,1044,1805,493,965,1788,479,494,687,1297,1624,1674,1706,671,1053,1158,1241,1626,1709,883,1156,1195,1316,1571,240,767,1025,1090,1144,1340,1342,1647,635,695,733,979,1027,1113,1341,1663,1089,1155,1256,1295,1024,1038,1296,1471,1710,1792,299,300,685,692,1451') 0.059503078460693
(538) DESCRIBE `cruisetypes` 0.0019230842590332
(539) DESCRIBE `destinations` 0.0021271705627441
(540) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '2', '37', '8', '39', '53', '26', '28', '38', '49', '55', '11', '40', '48', '7', '29', '21', '45', '44', '30', '34', '10', '52', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,2,37,8,39,53,26,28,38,49,55,11,40,48,7,29,21,45,44,30,34,10,52,46,56,32') 0.0022380352020264