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

Total elapsed time: 0.75193881988525

# Query Time
(1) connect 0.00071287155151367
(2) DESCRIBE `cruises` 0.0033252239227295
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69426, 69605, 72893, 74260, 74429, 74576, 74614, 74861, 75020, 75062)) ORDER BY FIND_IN_SET(id, '69426,69605,72893,74260,74429,74576,74614,74861,75020,75062') 0.0018851757049561
(4) DESCRIBE `cruises` 0.0033371448516846
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69426') 0.00018715858459473
(6) DESCRIBE `ships` 0.0032260417938232
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1272))) 0.00045514106750488
(8) DESCRIBE `ships` 0.0047271251678467
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1272') 0.00053119659423828
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032496452331543
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028514862060547
(12) DESCRIBE `itineraries` 0.0019330978393555
(13) DESCRIBE `ports` 0.0019898414611816
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00047802925109863
(15) DESCRIBE `ports` 0.0013070106506348
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034999847412109
(17) DESCRIBE `ports` 0.0012879371643066
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027585029602051
(19) DESCRIBE `sailingdates` 0.0012030601501465
(20) DESCRIBE `ports` 0.0013930797576904
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037097930908203
(22) DESCRIBE `ports` 0.0015718936920166
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028395652770996
(24) DESCRIBE `ports` 0.0012469291687012
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00035905838012695
(26) DESCRIBE `ports` 0.0031750202178955
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00028204917907715
(28) DESCRIBE `ports` 0.0012938976287842
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0021598339080811
(30) DESCRIBE `ports` 0.002528190612793
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0011570453643799
(32) DESCRIBE `ports` 0.00078797340393066
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0016329288482666
(34) DESCRIBE `ports` 0.0031769275665283
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0017960071563721
(36) DESCRIBE `ports` 0.0019679069519043
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00030112266540527
(38) DESCRIBE `ports` 0.0013740062713623
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0015158653259277
(40) DESCRIBE `ports` 0.0013220310211182
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0020401477813721
(42) DESCRIBE `ports` 0.0013048648834229
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00072908401489258
(44) DESCRIBE `ports` 0.0016570091247559
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.0033771991729736
(46) DESCRIBE `ports` 0.0032219886779785
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00037908554077148
(48) DESCRIBE `ports` 0.0022141933441162
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00060510635375977
(50) DESCRIBE `ports` 0.002169132232666
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0016050338745117
(52) DESCRIBE `avid_specials` 0.0015389919281006
(53) 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.002871036529541
(54) DESCRIBE `cruiselines` 0.0050671100616455
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.0038561820983887
(56) DESCRIBE `orchid_image` 0.0027070045471191
(57) DESCRIBE `cruiselines` 0.010900974273682
(58) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.006443977355957
(59) DESCRIBE `cruises` 0.0040328502655029
(60) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69605') 0.0045030117034912
(61) DESCRIBE `ships` 0.0038578510284424
(62) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 704))) 0.0095648765563965
(63) DESCRIBE `ships` 0.003774881362915
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '704') 0
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036001205444336
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034189224243164
(67) DESCRIBE `itineraries` 0.0023400783538818
(68) DESCRIBE `ports` 0.0018270015716553
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00043511390686035
(70) DESCRIBE `ports` 0.0090889930725098
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0
(72) DESCRIBE `ports` 0.001784086227417
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00037002563476562
(74) DESCRIBE `sailingdates` 0.00086307525634766
(75) DESCRIBE `ports` 0.0017189979553223
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00039911270141602
(77) DESCRIBE `ports` 0.0012459754943848
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.0077199935913086
(79) DESCRIBE `ports` 0.0020930767059326
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00046086311340332
(81) DESCRIBE `ports` 0.0018210411071777
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00037097930908203
(83) DESCRIBE `ports` 0.0017740726470947
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00040221214294434
(85) DESCRIBE `ports` 0.0014998912811279
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0061440467834473
(87) DESCRIBE `ports` 0.0017211437225342
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1967))) 0.00032877922058105
(89) DESCRIBE `ports` 0.0014998912811279
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1967') 0.00029706954956055
(91) DESCRIBE `ports` 0.0014090538024902
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4944))) 0.00032281875610352
(93) DESCRIBE `ports` 0.0013279914855957
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4944') 0.00030803680419922
(95) DESCRIBE `ports` 0.0014328956604004
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2175))) 0.0069551467895508
(97) DESCRIBE `ports` 0.0016019344329834
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2175') 0.00029993057250977
(99) DESCRIBE `ports` 0.0012919902801514
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4104))) 0.00030708312988281
(101) DESCRIBE `ports` 0.0012459754943848
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4104') 0.00027298927307129
(103) DESCRIBE `ports` 0.0013082027435303
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0068140029907227
(105) DESCRIBE `ports` 0.0015780925750732
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00033712387084961
(107) DESCRIBE `avid_specials` 0.001237154006958
(108) 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.001035213470459
(109) DESCRIBE `cruiselines` 0.0020771026611328
(110) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.0071871280670166
(111) DESCRIBE `orchid_image` 0.0016989707946777
(112) DESCRIBE `cruiselines` 0.0020320415496826
(113) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.0003819465637207
(114) DESCRIBE `cruises` 0.0025730133056641
(115) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72893') 0.0090010166168213
(116) DESCRIBE `ships` 0.0039699077606201
(117) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00071287155151367
(118) DESCRIBE `ships` 0.0037569999694824
(119) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.0077610015869141
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033307075500488
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032806396484375
(122) DESCRIBE `itineraries` 0.0025961399078369
(123) DESCRIBE `ports` 0.0013358592987061
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040197372436523
(125) DESCRIBE `ports` 0.0014710426330566
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028800964355469
(127) DESCRIBE `ports` 0.0048258304595947
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0003058910369873
(129) DESCRIBE `sailingdates` 0.0011100769042969
(130) DESCRIBE `ports` 0.0015771389007568
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00360107421875
(132) DESCRIBE `ports` 0.0039150714874268
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0062739849090576
(134) DESCRIBE `ports` 0.0015230178833008
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00038886070251465
(136) DESCRIBE `ports` 0.0018711090087891
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00039505958557129
(138) DESCRIBE `ports` 0.0018360614776611
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.0072100162506104
(140) DESCRIBE `ports` 0.0014710426330566
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00029993057250977
(142) DESCRIBE `ports` 0.0014150142669678
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00030016899108887
(144) DESCRIBE `ports` 0.0012929439544678
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00027298927307129
(146) DESCRIBE `ports` 0.0014300346374512
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00032591819763184
(148) DESCRIBE `ports` 0.0073628425598145
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00034999847412109
(150) DESCRIBE `ports` 0.0016038417816162
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 379))) 0.00039505958557129
(152) DESCRIBE `ports` 0.0013611316680908
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '379') 0.00030517578125
(154) DESCRIBE `ports` 0.0013968944549561
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00032186508178711
(156) DESCRIBE `ports` 0.0013699531555176
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.0002739429473877
(158) DESCRIBE `ports` 0.0012829303741455
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00032591819763184
(160) DESCRIBE `ports` 0.0019588470458984
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00072598457336426
(162) DESCRIBE `avid_specials` 0.001741886138916
(163) 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.0017240047454834
(164) DESCRIBE `cruiselines` 0.0018250942230225
(165) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00044798851013184
(166) DESCRIBE `orchid_image` 0.0016288757324219
(167) DESCRIBE `cruiselines` 0.0021810531616211
(168) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00032901763916016
(169) DESCRIBE `cruises` 0.0025200843811035
(170) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74260') 0.00030517578125
(171) DESCRIBE `ships` 0.0024831295013428
(172) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 204))) 0.0011200904846191
(173) DESCRIBE `ships` 0.003187894821167
(174) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '204') 0.00010895729064941
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026106834411621
(177) DESCRIBE `itineraries` 0.0018060207366943
(178) DESCRIBE `ports` 0.0014488697052002
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00057506561279297
(180) DESCRIBE `ports` 0.0012757778167725
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00032711029052734
(182) DESCRIBE `ports` 0.0012848377227783
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00028300285339355
(184) DESCRIBE `sailingdates` 0.0011639595031738
(185) DESCRIBE `ports` 0.0014691352844238
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00039291381835938
(187) DESCRIBE `ports` 0.0015571117401123
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00037717819213867
(189) DESCRIBE `ports` 0.0013570785522461
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 567))) 0.00034499168395996
(191) DESCRIBE `ports` 0.001384973526001
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '567') 0.00032591819763184
(193) DESCRIBE `ports` 0.0013139247894287
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 885))) 0.00030708312988281
(195) DESCRIBE `ports` 0.0015108585357666
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '885') 0.00032210350036621
(197) DESCRIBE `ports` 0.0012738704681396
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2987))) 0.00036120414733887
(199) DESCRIBE `ports` 0.0012540817260742
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2987') 0.00028204917907715
(201) DESCRIBE `ports` 0.0012831687927246
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00031399726867676
(203) DESCRIBE `ports` 0.0012829303741455
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00032210350036621
(205) DESCRIBE `ports` 0.001338005065918
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00030207633972168
(207) DESCRIBE `ports` 0.0012450218200684
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00033998489379883
(209) DESCRIBE `avid_specials` 0.0011060237884521
(210) 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.0010888576507568
(211) DESCRIBE `cruiselines` 0.002223014831543
(212) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00031590461730957
(213) DESCRIBE `orchid_image` 0.0014519691467285
(214) DESCRIBE `cruiselines` 0.0018758773803711
(215) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.0003662109375
(216) DESCRIBE `cruises` 0.0025119781494141
(217) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74429') 0.00032901763916016
(218) DESCRIBE `ships` 0.0028040409088135
(219) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 626))) 0.00043201446533203
(220) DESCRIBE `ships` 0.0034410953521729
(221) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '626') 0.001370906829834
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055098533630371
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(224) DESCRIBE `itineraries` 0.0019559860229492
(225) DESCRIBE `ports` 0.0015220642089844
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00046300888061523
(227) DESCRIBE `ports` 0.0013651847839355
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0003669261932373
(229) DESCRIBE `ports` 0.0014631748199463
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00033783912658691
(231) DESCRIBE `sailingdates` 0.0011940002441406
(232) DESCRIBE `ports` 0.0017240047454834
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00036787986755371
(234) DESCRIBE `ports` 0.001410961151123
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00028514862060547
(236) DESCRIBE `ports` 0.0012869834899902
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00029206275939941
(238) DESCRIBE `ports` 0.001317024230957
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00031185150146484
(240) DESCRIBE `ports` 0.0012960433959961
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00031018257141113
(242) DESCRIBE `ports` 0.0013108253479004
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00028419494628906
(244) DESCRIBE `ports` 0.0012669563293457
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00040292739868164
(246) DESCRIBE `ports` 0.0015320777893066
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.0003361701965332
(248) DESCRIBE `ports` 0.0017309188842773
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 6.3896179199219E-5
(250) DESCRIBE `ports` 0.0020160675048828
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00032591819763184
(252) DESCRIBE `avid_specials` 0.001539945602417
(253) 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.0011460781097412
(254) DESCRIBE `cruiselines` 0.0019240379333496
(255) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00085091590881348
(256) DESCRIBE `orchid_image` 0.00142502784729
(257) DESCRIBE `cruiselines` 0.0019900798797607
(258) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00047802925109863
(259) DESCRIBE `cruises` 0.0025599002838135
(260) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74576') 5.6028366088867E-5
(261) DESCRIBE `ships` 0.002532958984375
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.0003960132598877
(263) DESCRIBE `ships` 0.0026018619537354
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.0003209114074707
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028800964355469
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024795532226562
(267) DESCRIBE `itineraries` 0.001244068145752
(268) DESCRIBE `ports` 0.0014288425445557
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00032496452331543
(270) DESCRIBE `ports` 0.001331090927124
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00033092498779297
(272) DESCRIBE `ports` 0.0012450218200684
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00028610229492188
(274) DESCRIBE `sailingdates` 0.0011138916015625
(275) DESCRIBE `ports` 0.0013599395751953
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00032997131347656
(277) DESCRIBE `ports` 0.0012538433074951
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00027799606323242
(279) DESCRIBE `ports` 0.0013489723205566
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00028896331787109
(281) DESCRIBE `ports` 0.001655101776123
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00029897689819336
(283) DESCRIBE `ports` 0.0020370483398438
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00037598609924316
(285) DESCRIBE `ports` 0.0014450550079346
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00030708312988281
(287) DESCRIBE `ports` 0.0017640590667725
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00032782554626465
(289) DESCRIBE `ports` 0.0013329982757568
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00026798248291016
(291) DESCRIBE `ports` 0.0012829303741455
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4104))) 0.0003049373626709
(293) DESCRIBE `ports` 0.001255989074707
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4104') 0.0010900497436523
(295) DESCRIBE `ports` 0.00073695182800293
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.0003049373626709
(297) DESCRIBE `ports` 0.0012879371643066
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0
(299) DESCRIBE `ports` 0.0012850761413574
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00030779838562012
(301) DESCRIBE `ports` 0.001662015914917
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0002589225769043
(303) DESCRIBE `avid_specials` 0.001168966293335
(304) 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.0014679431915283
(305) DESCRIBE `cruiselines` 0.0018880367279053
(306) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00034594535827637
(307) DESCRIBE `orchid_image` 0.0010638236999512
(308) DESCRIBE `cruiselines` 0.0019969940185547
(309) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00041604042053223
(310) DESCRIBE `cruises` 0.0026159286499023
(311) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74614') 0.00043296813964844
(312) DESCRIBE `ships` 0.0033020973205566
(313) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00042200088500977
(314) DESCRIBE `ships` 0.0024418830871582
(315) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027990341186523
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024914741516113
(318) DESCRIBE `itineraries` 0.0012400150299072
(319) DESCRIBE `ports` 0.001183032989502
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00037193298339844
(321) DESCRIBE `ports` 0.0016379356384277
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00031304359436035
(323) DESCRIBE `ports` 0.001262903213501
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00029277801513672
(325) DESCRIBE `sailingdates` 0.0012080669403076
(326) DESCRIBE `ports` 0.0013649463653564
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00034999847412109
(328) DESCRIBE `ports` 0.0013551712036133
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00028181076049805
(330) DESCRIBE `ports` 0.0013270378112793
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0002901554107666
(332) DESCRIBE `ports` 0.001446008682251
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00026702880859375
(334) DESCRIBE `ports` 0.0014119148254395
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00029802322387695
(336) DESCRIBE `ports` 0.0012860298156738
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00027894973754883
(338) DESCRIBE `ports` 0.0013048648834229
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00038814544677734
(340) DESCRIBE `ports` 0.0013339519500732
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00029897689819336
(342) DESCRIBE `ports` 0.0012528896331787
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00029587745666504
(344) DESCRIBE `ports` 0.0012500286102295
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00026392936706543
(346) DESCRIBE `ports` 0.0013308525085449
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00029397010803223
(348) DESCRIBE `ports` 0.0012397766113281
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00026392936706543
(350) DESCRIBE `ports` 0.001323938369751
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00030803680419922
(352) DESCRIBE `ports` 0.0012500286102295
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0
(354) DESCRIBE `ports` 0.0015180110931396
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00032281875610352
(356) DESCRIBE `ports` 0.0012800693511963
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00027298927307129
(358) DESCRIBE `avid_specials` 0.0015740394592285
(359) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74614 and class = 'Cruise') OR (item_id = 287 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.0013141632080078
(360) DESCRIBE `cruiselines` 0.0019898414611816
(361) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00034117698669434
(362) DESCRIBE `orchid_image` 0.0015320777893066
(363) DESCRIBE `cruiselines` 0.0018279552459717
(364) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0002739429473877
(365) DESCRIBE `cruises` 0.0024030208587646
(366) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74861') 0.00029397010803223
(367) DESCRIBE `ships` 0.0026910305023193
(368) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1344))) 0.00041103363037109
(369) DESCRIBE `ships` 0.0029599666595459
(370) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1344') 0.00033211708068848
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(372) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025486946105957
(373) DESCRIBE `itineraries` 0.0012600421905518
(374) DESCRIBE `ports` 0.0013599395751953
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00032186508178711
(376) DESCRIBE `ports` 0.0013551712036133
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00031208992004395
(378) DESCRIBE `ports` 0.0013089179992676
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00038409233093262
(380) DESCRIBE `sailingdates` 0.0011069774627686
(381) DESCRIBE `ports` 0.0012948513031006
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00031900405883789
(383) DESCRIBE `ports` 0.0015900135040283
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00029587745666504
(385) DESCRIBE `ports` 0.001288890838623
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00029802322387695
(387) DESCRIBE `ports` 0.0013120174407959
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00027799606323242
(389) DESCRIBE `ports` 0.001262903213501
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00030803680419922
(391) DESCRIBE `ports` 0.0012760162353516
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00027298927307129
(393) DESCRIBE `ports` 0.0012760162353516
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00029897689819336
(395) DESCRIBE `ports` 0.0013248920440674
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.0003058910369873
(397) DESCRIBE `ports` 0.0013070106506348
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00029587745666504
(399) DESCRIBE `ports` 0.0013830661773682
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00019502639770508
(401) DESCRIBE `ports` 0.0013270378112793
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00034809112548828
(403) DESCRIBE `ports` 0.0013689994812012
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.00028300285339355
(405) DESCRIBE `ports` 0.0012631416320801
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00031495094299316
(407) DESCRIBE `ports` 0.0013010501861572
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.0002751350402832
(409) DESCRIBE `ports` 0.0013198852539062
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0003209114074707
(411) DESCRIBE `ports` 0.0013689994812012
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00027799606323242
(413) DESCRIBE `ports` 0.001352071762085
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00037884712219238
(415) DESCRIBE `ports` 0.0012490749359131
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00030112266540527
(417) DESCRIBE `ports` 0.0012228488922119
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00031709671020508
(419) DESCRIBE `ports` 0.0012531280517578
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00029397010803223
(421) DESCRIBE `avid_specials` 0.0011930465698242
(422) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74861 and class = 'Cruise') OR (item_id = 1344 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010340213775635
(423) DESCRIBE `cruiselines` 0.00187087059021
(424) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00030994415283203
(425) DESCRIBE `orchid_image` 0.001460075378418
(426) DESCRIBE `cruiselines` 0.0017619132995605
(427) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00027203559875488
(428) DESCRIBE `cruises` 0.0023849010467529
(429) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75020') 0.00031208992004395
(430) DESCRIBE `ships` 0.0024778842926025
(431) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1343))) 0.0004429817199707
(432) DESCRIBE `ships` 0.0028860569000244
(433) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1343') 0.00045299530029297
(434) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003359317779541
(435) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002591609954834
(436) DESCRIBE `itineraries` 0.0013949871063232
(437) DESCRIBE `ports` 0.0014679431915283
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0
(439) DESCRIBE `ports` 0.0015079975128174
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00035881996154785
(441) DESCRIBE `ports` 0.0026950836181641
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00049901008605957
(443) DESCRIBE `sailingdates` 0.0017569065093994
(444) DESCRIBE `ports` 0.0016741752624512
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00037503242492676
(446) DESCRIBE `ports` 0.0013020038604736
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00029706954956055
(448) DESCRIBE `ports` 0.0012519359588623
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00030088424682617
(450) DESCRIBE `ports` 0.0012989044189453
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00027108192443848
(452) DESCRIBE `ports` 0.0013730525970459
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00037503242492676
(454) DESCRIBE `ports` 0.0010249614715576
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00027894973754883
(456) DESCRIBE `ports` 0.001323938369751
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00030398368835449
(458) DESCRIBE `ports` 0.0012781620025635
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.0002739429473877
(460) DESCRIBE `ports` 0.0013408660888672
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00031590461730957
(462) DESCRIBE `ports` 0.0012838840484619
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.0002739429473877
(464) DESCRIBE `ports` 0.0013940334320068
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00034308433532715
(466) DESCRIBE `ports` 0.0015108585357666
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00038599967956543
(468) DESCRIBE `ports` 0.0013821125030518
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00031685829162598
(470) DESCRIBE `ports` 0.0013210773468018
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00029301643371582
(472) DESCRIBE `ports` 0.0013129711151123
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00032401084899902
(474) DESCRIBE `ports` 0.0012612342834473
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00028300285339355
(476) DESCRIBE `ports` 0.0013020038604736
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00030112266540527
(478) DESCRIBE `ports` 0.0012938976287842
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00027298927307129
(480) DESCRIBE `avid_specials` 0.0011959075927734
(481) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75020 and class = 'Cruise') OR (item_id = 1343 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012059211730957
(482) DESCRIBE `cruiselines` 0.0018739700317383
(483) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031113624572754
(484) DESCRIBE `orchid_image` 0.0013949871063232
(485) DESCRIBE `cruiselines` 0.0018768310546875
(486) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00027608871459961
(487) DESCRIBE `cruises` 0.0028009414672852
(488) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75062') 0.00034403800964355
(489) DESCRIBE `ships` 0.0029549598693848
(490) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1090))) 0.00040006637573242
(491) DESCRIBE `ships` 0.0022008419036865
(492) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1090') 0
(493) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014901161193848
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027298927307129
(495) DESCRIBE `itineraries` 0.0012810230255127
(496) DESCRIBE `ports` 0.0010249614715576
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00032305717468262
(498) DESCRIBE `ports` 0.0019290447235107
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020003318786621
(500) DESCRIBE `ports` 0.0013329982757568
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00027894973754883
(502) DESCRIBE `sailingdates` 0.0011699199676514
(503) DESCRIBE `ports` 0.00136399269104
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0003049373626709
(505) DESCRIBE `ports` 0.0012569427490234
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00031185150146484
(507) DESCRIBE `ports` 0.00064897537231445
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00030112266540527
(509) DESCRIBE `ports` 0.0012481212615967
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0
(511) DESCRIBE `ports` 0.0012929439544678
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00034403800964355
(513) DESCRIBE `ports` 0.0014538764953613
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00031089782714844
(515) DESCRIBE `ports` 0.0016820430755615
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00030517578125
(517) DESCRIBE `ports` 0.00044488906860352
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00031113624572754
(519) DESCRIBE `ports` 0.0012729167938232
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00031805038452148
(521) DESCRIBE `ports` 0.0012998580932617
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00029993057250977
(523) DESCRIBE `ports` 0.0015008449554443
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00029397010803223
(525) DESCRIBE `ports` 0.0013349056243896
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00027298927307129
(527) DESCRIBE `ports` 0.0013179779052734
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2186))) 0.0002899169921875
(529) DESCRIBE `ports` 0.001284122467041
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2186') 0.00029492378234863
(531) DESCRIBE `ports` 0.0013267993927002
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00028896331787109
(533) DESCRIBE `ports` 0.0012631416320801
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00030207633972168
(535) DESCRIBE `ports` 0.0012412071228027
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00029706954956055
(537) DESCRIBE `ports` 0.0012691020965576
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00029397010803223
(539) DESCRIBE `avid_specials` 0.0011160373687744
(540) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75062 and class = 'Cruise') OR (item_id = 1090 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010719299316406
(541) DESCRIBE `cruiselines` 0.0018820762634277
(542) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00035214424133301
(543) DESCRIBE `orchid_image` 0.0014469623565674
(544) DESCRIBE `cruiselines` 0.0024020671844482
(545) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0003821849822998
(546) DESCRIBE `cruiselines` 0.001917839050293
(547) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '144', '183', '12', '23', '20', '101', '18', '8', '7', '131', '96', '171', '103', '33', '156', '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', '113', '147', '211', '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,8,7,131,96,171,103,33,156,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,113,147,211,57,180,64,257,261,38,48,115,276,213,184,95,105,52,82,244,209,177,134,245') 0.0040371417999268
(548) DESCRIBE `ships` 0.0031759738922119
(549) 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', '739', '1067', '439', '521', '9', '715', '25', '24', '163', '738', '882', '3', '480', '1135', '1599', '1607', '455', '1260', '1678', '407', '553', '113', '1141', '1008', '434', '1455', '160', '766', '1773', '1682', '792', '1768', '265', '610', '817', '1569', '1742', '711', '332', '520', '1454', '352', '63', '66', '1372', '737', '1291', '626', '462', '542', '657', '1021', '1199', '585', '1308', '1721', '1738', '285', '1163', '1410', '14', '1068', '1302', '1411', '1413', '1526', '314', '526', '748', '1320', '1323', '1579', '855', '286', '390', '405', '573', '970', '1417', '34', '38', '43', '327', '582', '854', '1063', '1259', '31', '37', '590', '837', '1402', '378', '1463', '1088', '124', '1321', '1586', '580', '791', '958', '1013', '1552', '1284', '1811', '119', '162', '441', '1159', '1193', '1208', '1266', '678', '1139', '1157', '1492', '114', '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', '1743', '338', '776', '1019', '1319', '1344', '1419', '1420', '1422', '1423', '262', '485', '751', '775', '1325', '1715', '1716', '1740', '123', '290', '673', '1029', '1160', '1217', '1282', '1343', '1418', '1421', '1424', '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', '69', '341', '574', '851', '968', '98', '151', '651', '709', '973', '1409', '324', '1055', '1724', '1808', '108', '150', '643', '1230', '1231', '1458', '1474', '1501', '1713', '1730', '1767', '82', '857', '858', '954', '996', '1714', '75', '663', '769', '885', '1035', '1042', '1206', '1632', '1751', '467', '884', '1154', '1360', '1361', '1368', '1459', '1574', '1609', '1708', '1723', '1750', '666', '1049', '1362', '1772', '1148', '1322', '1483', '1771', '665', '888', '944', '423', '790', '1051', '1681', '147', '703', '717', '784', '1020', '1071', '1188', '1293', '1301', '1580', '70', '375', '1054', '152', '422', '483', '516', '707', '1075', '1224', '1486', '1601', '81', '1047', '1052', '1445', '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', '1039', '1050', '1143', '1196', '1232', '1350', '205', '419', '656', '1073', '1151', '1254', '1389', '1581', '1749', '1791', '795', '982', '1294', '1367', '1540', '1645', '1684', '1806', '452', '1064', '1140', '1800', '1816', '421', '761', '808', '1044', '1805', '493', '965', '1788', '479', '494', '687', '1297', '1624', '1674', '1706', '1053', '1158', '1241', '1626', '671', '883', '1156', '1195', '1316', '1571', '1709', '240', '767', '1025', '1090', '1144', '1340', '1342', '1647', '635', '695', '733', '979', '1027', '1113', '1341', '1663', '1089', '1155', '1256', '1295', '1024', '1038', '1296', '1471', '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,739,1067,439,521,9,715,25,24,163,738,882,3,480,1135,1599,1607,455,1260,1678,407,553,113,1141,1008,434,1455,160,766,1773,1682,792,1768,265,610,817,1569,1742,711,332,520,1454,352,63,66,1372,737,1291,626,462,542,657,1021,1199,585,1308,1721,1738,285,1163,1410,14,1068,1302,1411,1413,1526,314,526,748,1320,1323,1579,855,286,390,405,573,970,1417,34,38,43,327,582,854,1063,1259,31,37,590,837,1402,378,1463,1088,124,1321,1586,580,791,958,1013,1552,1284,1811,119,162,441,1159,1193,1208,1266,678,1139,1157,1492,114,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,1743,338,776,1019,1319,1344,1419,1420,1422,1423,262,485,751,775,1325,1715,1716,1740,123,290,673,1029,1160,1217,1282,1343,1418,1421,1424,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,69,341,574,851,968,98,151,651,709,973,1409,324,1055,1724,1808,108,150,643,1230,1231,1458,1474,1501,1713,1730,1767,82,857,858,954,996,1714,75,663,769,885,1035,1042,1206,1632,1751,467,884,1154,1360,1361,1368,1459,1574,1609,1708,1723,1750,666,1049,1362,1772,1148,1322,1483,1771,665,888,944,423,790,1051,1681,147,703,717,784,1020,1071,1188,1293,1301,1580,70,375,1054,152,422,483,516,707,1075,1224,1486,1601,81,1047,1052,1445,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,1039,1050,1143,1196,1232,1350,205,419,656,1073,1151,1254,1389,1581,1749,1791,795,982,1294,1367,1540,1645,1684,1806,452,1064,1140,1800,1816,421,761,808,1044,1805,493,965,1788,479,494,687,1297,1624,1674,1706,1053,1158,1241,1626,671,883,1156,1195,1316,1571,1709,240,767,1025,1090,1144,1340,1342,1647,635,695,733,979,1027,1113,1341,1663,1089,1155,1256,1295,1024,1038,1296,1471,1792,299,300,685,692,1451') 0.044023036956787
(550) DESCRIBE `cruisetypes` 0.0015308856964111
(551) DESCRIBE `destinations` 0.0019679069519043
(552) 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.0020599365234375