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

Total elapsed time: 2.2247071266174

# Query Time
(1) connect 0.010031938552856
(2) DESCRIBE `cruises` 0.0047729015350342
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72903, 72876, 72837, 72812, 72900, 72933, 72859, 66202, 72898, 72853)) ORDER BY FIND_IN_SET(id, '72903,72876,72837,72812,72900,72933,72859,66202,72898,72853') 0.0035970211029053
(4) DESCRIBE `cruises` 0.01163911819458
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72903') 0.01301383972168
(6) DESCRIBE `ships` 0.0053479671478271
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.010793924331665
(8) DESCRIBE `ships` 0.0054399967193604
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00074505805969238
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0067968368530273
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048708915710449
(12) DESCRIBE `itineraries` 0.0027000904083252
(13) DESCRIBE `ports` 0.0089311599731445
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0064940452575684
(15) DESCRIBE `ports` 0.0028369426727295
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00062298774719238
(17) DESCRIBE `ports` 0.0026199817657471
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0055429935455322
(19) DESCRIBE `sailingdates` 0.004680871963501
(20) DESCRIBE `ports` 0.002345085144043
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0014898777008057
(22) DESCRIBE `ports` 0.0037999153137207
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0041069984436035
(24) DESCRIBE `ports` 0.0037441253662109
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.014971017837524
(26) DESCRIBE `ports` 0.0099029541015625
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00046491622924805
(28) DESCRIBE `ports` 0.0028171539306641
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00068998336791992
(30) DESCRIBE `ports` 0.0023291110992432
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.0081980228424072
(32) DESCRIBE `ports` 0.0030269622802734
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00065493583679199
(34) DESCRIBE `ports` 0.0030009746551514
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0057070255279541
(36) DESCRIBE `ports` 0.0034759044647217
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1198))) 0.0018770694732666
(38) DESCRIBE `ports` 0.0050139427185059
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1198') 0.023319959640503
(40) DESCRIBE `ports` 0.0092098712921143
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0045099258422852
(42) DESCRIBE `ports` 0.0023009777069092
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00058197975158691
(44) DESCRIBE `ports` 0.010565042495728
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00067615509033203
(46) DESCRIBE `ports` 0.0069739818572998
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00071191787719727
(48) DESCRIBE `ports` 0.0034339427947998
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00062298774719238
(50) DESCRIBE `ports` 0.010890960693359
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00055503845214844
(52) DESCRIBE `ports` 0.002547025680542
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0035610198974609
(54) DESCRIBE `ports` 0.002769947052002
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0051870346069336
(56) DESCRIBE `ports` 0.0029070377349854
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0086078643798828
(58) DESCRIBE `ports` 0.0028049945831299
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0140221118927
(60) DESCRIBE `avid_specials` 0.0024690628051758
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72903 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 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.008512020111084
(62) DESCRIBE `cruiselines` 0.0055580139160156
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0011909008026123
(64) DESCRIBE `orchid_image` 0.014334917068481
(65) DESCRIBE `cruiselines` 0.004011869430542
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0022151470184326
(67) DESCRIBE `cruises` 0.017621994018555
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72876') 0.00069594383239746
(69) DESCRIBE `ships` 0.0045981407165527
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.0062849521636963
(71) DESCRIBE `ships` 0.0052909851074219
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.016488075256348
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00056099891662598
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049781799316406
(75) DESCRIBE `itineraries` 0.0028171539306641
(76) DESCRIBE `ports` 0.0031139850616455
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.000762939453125
(78) DESCRIBE `ports` 0.01009202003479
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00071907043457031
(80) DESCRIBE `ports` 0.0028209686279297
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0006871223449707
(82) DESCRIBE `sailingdates` 0.0022151470184326
(83) DESCRIBE `ports` 0.010174989700317
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00065302848815918
(85) DESCRIBE `ports` 0.0032501220703125
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00055217742919922
(87) DESCRIBE `ports` 0.0021219253540039
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.0027561187744141
(89) DESCRIBE `ports` 0.0032768249511719
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.0030641555786133
(91) DESCRIBE `ports` 0.0036189556121826
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 642))) 0.0039339065551758
(93) DESCRIBE `ports` 0.0025358200073242
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '642') 0.0021941661834717
(95) DESCRIBE `ports` 0.0033130645751953
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0028820037841797
(97) DESCRIBE `ports` 0.0037841796875
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0015928745269775
(99) DESCRIBE `ports` 0.0025119781494141
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0025310516357422
(101) DESCRIBE `ports` 0.0025491714477539
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.0025639533996582
(103) DESCRIBE `ports` 0.0044369697570801
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0033450126647949
(105) DESCRIBE `ports` 0.0031900405883789
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0020468235015869
(107) DESCRIBE `ports` 0.0031230449676514
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0031778812408447
(109) DESCRIBE `ports` 0.0038590431213379
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00301194190979
(111) DESCRIBE `ports` 0.0037169456481934
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0038931369781494
(113) DESCRIBE `ports` 0.0032241344451904
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.0026428699493408
(115) DESCRIBE `ports` 0.0032880306243896
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.0026788711547852
(117) DESCRIBE `ports` 0.0043208599090576
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.0091190338134766
(119) DESCRIBE `ports` 0.0035638809204102
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.0095610618591309
(121) DESCRIBE `ports` 0.0030760765075684
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00070309638977051
(123) DESCRIBE `ports` 0.0028910636901855
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0021398067474365
(125) DESCRIBE `ports` 0.0023620128631592
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0083999633789062
(127) DESCRIBE `avid_specials` 0.0028660297393799
(128) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72876 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.002579927444458
(129) DESCRIBE `cruiselines` 0.010081052780151
(130) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00085115432739258
(131) DESCRIBE `orchid_image` 0.0042638778686523
(132) DESCRIBE `cruiselines` 0.012161016464233
(133) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00063991546630859
(134) DESCRIBE `cruises` 0.013063907623291
(135) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72837') 0.00063395500183105
(136) DESCRIBE `ships` 0.0041000843048096
(137) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00070595741271973
(138) DESCRIBE `ships` 0.015599012374878
(139) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.0006561279296875
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00061511993408203
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005190372467041
(142) DESCRIBE `itineraries` 0.0027668476104736
(143) DESCRIBE `ports` 0.009922981262207
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00072598457336426
(145) DESCRIBE `ports` 0.0028481483459473
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00065708160400391
(147) DESCRIBE `ports` 0.0027799606323242
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0071520805358887
(149) DESCRIBE `sailingdates` 0.0028231143951416
(150) DESCRIBE `ports` 0.002957820892334
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0062570571899414
(152) DESCRIBE `ports` 0.0033681392669678
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00065803527832031
(154) DESCRIBE `ports` 0.0078580379486084
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00075197219848633
(156) DESCRIBE `ports` 0.0031380653381348
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.0049021244049072
(158) DESCRIBE `ports` 0.0030031204223633
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0094389915466309
(160) DESCRIBE `ports` 0.002439022064209
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00054717063903809
(162) DESCRIBE `ports` 0.0020220279693604
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00060415267944336
(164) DESCRIBE `ports` 0.0024158954620361
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00063920021057129
(166) DESCRIBE `ports` 0.0095248222351074
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00082802772521973
(168) DESCRIBE `ports` 0.0028059482574463
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00062298774719238
(170) DESCRIBE `ports` 0.002946138381958
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.011748075485229
(172) DESCRIBE `ports` 0.00319504737854
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.010808944702148
(174) DESCRIBE `ports` 0.0088238716125488
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00068497657775879
(176) DESCRIBE `ports` 0.0024378299713135
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.0053808689117432
(178) DESCRIBE `ports` 0.0025079250335693
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.0083279609680176
(180) DESCRIBE `ports` 0.002169132232666
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.0005950927734375
(182) DESCRIBE `ports` 0.0023059844970703
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0094990730285645
(184) DESCRIBE `ports` 0.0024240016937256
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0011970996856689
(186) DESCRIBE `ports` 0.0026350021362305
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0065469741821289
(188) DESCRIBE `ports` 0.0096888542175293
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0043690204620361
(190) DESCRIBE `avid_specials` 0.0019659996032715
(191) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72837 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.010809898376465
(192) DESCRIBE `cruiselines` 0.0038349628448486
(193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0089919567108154
(194) DESCRIBE `orchid_image` 0.0023539066314697
(195) DESCRIBE `cruiselines` 0.015774011611938
(196) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0015020370483398
(197) DESCRIBE `cruises` 0.0042510032653809
(198) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72812') 0.013520002365112
(199) DESCRIBE `ships` 0.011613130569458
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00065302848815918
(201) DESCRIBE `ships` 0.014166116714478
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.0054960250854492
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0069911479949951
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038313865661621
(205) DESCRIBE `itineraries` 0.0024518966674805
(206) DESCRIBE `ports` 0.0040068626403809
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0053107738494873
(208) DESCRIBE `ports` 0.002565860748291
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0024690628051758
(210) DESCRIBE `ports` 0.0033059120178223
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0058498382568359
(212) DESCRIBE `sailingdates` 0.0022339820861816
(213) DESCRIBE `ports` 0.012069940567017
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00074481964111328
(215) DESCRIBE `ports` 0.0028879642486572
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00062298774719238
(217) DESCRIBE `ports` 0.012549877166748
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.004547119140625
(219) DESCRIBE `ports` 0.0028531551361084
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.011665105819702
(221) DESCRIBE `ports` 0.0022540092468262
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.0046730041503906
(223) DESCRIBE `ports` 0.0021939277648926
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.0045599937438965
(225) DESCRIBE `ports` 0.0025820732116699
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.0043430328369141
(227) DESCRIBE `ports` 0.0022978782653809
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.0066170692443848
(229) DESCRIBE `ports` 0.0023360252380371
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.0057570934295654
(231) DESCRIBE `ports` 0.012247085571289
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.0049941539764404
(233) DESCRIBE `ports` 0.0027048587799072
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.0097301006317139
(235) DESCRIBE `ports` 0.0020718574523926
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.00042104721069336
(237) DESCRIBE `ports` 0.0024240016937256
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00063109397888184
(239) DESCRIBE `ports` 0.0098650455474854
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0016579627990723
(241) DESCRIBE `avid_specials` 0.0070281028747559
(242) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72812 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 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.0022649765014648
(243) DESCRIBE `cruiselines` 0.0094799995422363
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00062012672424316
(245) DESCRIBE `orchid_image` 0.0030300617218018
(246) DESCRIBE `cruiselines` 0.0088980197906494
(247) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00058794021606445
(248) DESCRIBE `cruises` 0.0044949054718018
(249) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72900') 0.0035719871520996
(250) DESCRIBE `ships` 0.010535001754761
(251) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.015293836593628
(252) DESCRIBE `ships` 0.0056920051574707
(253) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00090718269348145
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00060081481933594
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052809715270996
(256) DESCRIBE `itineraries` 0.0021049976348877
(257) DESCRIBE `ports` 0.0026540756225586
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00051498413085938
(259) DESCRIBE `ports` 0.0029301643371582
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00068497657775879
(261) DESCRIBE `ports` 0.0030720233917236
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0006098747253418
(263) DESCRIBE `sailingdates` 0.0024111270904541
(264) DESCRIBE `ports` 0.0028250217437744
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00070500373840332
(266) DESCRIBE `ports` 0.0024940967559814
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00053095817565918
(268) DESCRIBE `ports` 0.0021672248840332
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0005340576171875
(270) DESCRIBE `ports` 0.0026168823242188
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00069403648376465
(272) DESCRIBE `ports` 0.0029900074005127
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00069379806518555
(274) DESCRIBE `ports` 0.0029599666595459
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00066590309143066
(276) DESCRIBE `ports` 0.0028700828552246
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00071501731872559
(278) DESCRIBE `ports` 0.0029289722442627
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00064992904663086
(280) DESCRIBE `ports` 0.0028719902038574
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00068116188049316
(282) DESCRIBE `ports` 0.0028970241546631
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00065398216247559
(284) DESCRIBE `ports` 0.0030448436737061
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00080490112304688
(286) DESCRIBE `ports` 0.0028629302978516
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00077509880065918
(288) DESCRIBE `ports` 0.0032370090484619
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00079083442687988
(290) DESCRIBE `ports` 0.0029680728912354
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00075483322143555
(292) DESCRIBE `ports` 0.0028350353240967
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00067996978759766
(294) DESCRIBE `ports` 0.0028409957885742
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00062799453735352
(296) DESCRIBE `ports` 0.002791166305542
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00069594383239746
(298) DESCRIBE `ports` 0.0028839111328125
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.0006110668182373
(300) DESCRIBE `ports` 0.0030200481414795
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00070309638977051
(302) DESCRIBE `ports` 0.0019919872283936
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00089478492736816
(304) DESCRIBE `avid_specials` 0.0017821788787842
(305) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72900 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 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.0014200210571289
(306) DESCRIBE `cruiselines` 0.0027980804443359
(307) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00054788589477539
(308) DESCRIBE `orchid_image` 0.0025060176849365
(309) DESCRIBE `cruiselines` 0.011069059371948
(310) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00048208236694336
(311) DESCRIBE `cruises` 0.0038020610809326
(312) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72933') 0.00050592422485352
(313) DESCRIBE `ships` 0.010212182998657
(314) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00062990188598633
(315) DESCRIBE `ships` 0.0040419101715088
(316) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.0048568248748779
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037407875061035
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034809112548828
(319) DESCRIBE `itineraries` 0.0037310123443604
(320) DESCRIBE `ports` 0.01040506362915
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0090279579162598
(322) DESCRIBE `ports` 0.0021011829376221
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00079703330993652
(324) DESCRIBE `ports` 0.0021898746490479
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00044918060302734
(326) DESCRIBE `sailingdates` 0.0016920566558838
(327) DESCRIBE `ports` 0.0018091201782227
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0032780170440674
(329) DESCRIBE `ports` 0.0018348693847656
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0084679126739502
(331) DESCRIBE `ports` 0.0023281574249268
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.0062270164489746
(333) DESCRIBE `ports` 0.0020279884338379
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.0048220157623291
(335) DESCRIBE `ports` 0.0058300495147705
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.002094030380249
(337) DESCRIBE `ports` 0.00242018699646
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00531005859375
(339) DESCRIBE `ports` 0.0022869110107422
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0055978298187256
(341) DESCRIBE `ports` 0.0029399394989014
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0075790882110596
(343) DESCRIBE `ports` 0.011028051376343
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.00054502487182617
(345) DESCRIBE `ports` 0.0083470344543457
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.0046639442443848
(347) DESCRIBE `ports` 0.0025360584259033
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.0062458515167236
(349) DESCRIBE `ports` 0.0054941177368164
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.0010659694671631
(351) DESCRIBE `ports` 0.0018320083618164
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0043420791625977
(353) DESCRIBE `ports` 0.0019018650054932
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0037648677825928
(355) DESCRIBE `ports` 0.0018651485443115
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0044400691986084
(357) DESCRIBE `ports` 0.0024890899658203
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0053989887237549
(359) DESCRIBE `ports` 0.002331018447876
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.0040371417999268
(361) DESCRIBE `ports` 0.0031530857086182
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00039887428283691
(363) DESCRIBE `ports` 0.0023691654205322
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.0004279613494873
(365) DESCRIBE `ports` 0.0022931098937988
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00043797492980957
(367) DESCRIBE `ports` 0.0019919872283936
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00049901008605957
(369) DESCRIBE `ports` 0.0023679733276367
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00056195259094238
(371) DESCRIBE `ports` 0.0026040077209473
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00057506561279297
(373) DESCRIBE `ports` 0.0030510425567627
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00063395500183105
(375) DESCRIBE `ports` 0.003108024597168
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00052213668823242
(377) DESCRIBE `ports` 0.0028541088104248
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00053787231445312
(379) DESCRIBE `ports` 0.0039350986480713
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00068497657775879
(381) DESCRIBE `ports` 0.0024089813232422
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00043082237243652
(383) DESCRIBE `ports` 0.0026171207427979
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00057005882263184
(385) DESCRIBE `ports` 0.0029699802398682
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00051307678222656
(387) DESCRIBE `ports` 0.0026581287384033
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2108))) 0.00043606758117676
(389) DESCRIBE `ports` 0.0030310153961182
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2108') 0.00065708160400391
(391) DESCRIBE `ports` 0.0024008750915527
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.00061798095703125
(393) DESCRIBE `ports` 0.0022940635681152
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') 0.00057291984558105
(395) DESCRIBE `ports` 0.0024769306182861
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1936))) 0.00048494338989258
(397) DESCRIBE `ports` 0.0033290386199951
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1936') 0.00055384635925293
(399) DESCRIBE `ports` 0.0033340454101562
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00057482719421387
(401) DESCRIBE `ports` 0.0027310848236084
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') 0.00046205520629883
(403) DESCRIBE `ports` 0.0030899047851562
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00061702728271484
(405) DESCRIBE `ports` 0.0025827884674072
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00054097175598145
(407) DESCRIBE `ports` 0.0024509429931641
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00067400932312012
(409) DESCRIBE `ports` 0.0026190280914307
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00057315826416016
(411) DESCRIBE `ports` 0.003446102142334
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00055813789367676
(413) DESCRIBE `ports` 0.0027718544006348
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00049209594726562
(415) DESCRIBE `ports` 0.0025148391723633
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00050687789916992
(417) DESCRIBE `ports` 0.0026340484619141
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00049114227294922
(419) DESCRIBE `ports` 0.0018439292907715
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00040698051452637
(421) DESCRIBE `ports` 0.0018410682678223
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00042414665222168
(423) DESCRIBE `ports` 0.0025179386138916
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0004420280456543
(425) DESCRIBE `ports` 0.0019869804382324
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00059294700622559
(427) DESCRIBE `avid_specials` 0.0031049251556396
(428) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72933 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019600391387939
(429) DESCRIBE `cruiselines` 0.0037620067596436
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00052905082702637
(431) DESCRIBE `orchid_image` 0.0024750232696533
(432) DESCRIBE `cruiselines` 0.0031700134277344
(433) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00049591064453125
(434) DESCRIBE `cruises` 0.0049879550933838
(435) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72859') 0.00072407722473145
(436) DESCRIBE `ships` 0.0058019161224365
(437) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.0011599063873291
(438) DESCRIBE `ships` 0.0051069259643555
(439) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00046086311340332
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036978721618652
(441) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052595138549805
(442) DESCRIBE `itineraries` 0.0021109580993652
(443) DESCRIBE `ports` 0.0031330585479736
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00068092346191406
(445) DESCRIBE `ports` 0.0030591487884521
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00045394897460938
(447) DESCRIBE `ports` 0.0018801689147949
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0005030632019043
(449) DESCRIBE `sailingdates` 0.0021741390228271
(450) DESCRIBE `ports` 0.0026719570159912
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00066113471984863
(452) DESCRIBE `ports` 0.0025150775909424
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00056600570678711
(454) DESCRIBE `ports` 0.0023820400238037
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00044989585876465
(456) DESCRIBE `ports` 0.0024089813232422
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00040793418884277
(458) DESCRIBE `ports` 0.0021300315856934
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00044107437133789
(460) DESCRIBE `ports` 0.0019729137420654
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00050616264343262
(462) DESCRIBE `ports` 0.002112865447998
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00048518180847168
(464) DESCRIBE `ports` 0.0032889842987061
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00079488754272461
(466) DESCRIBE `ports` 0.0032451152801514
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.00067687034606934
(468) DESCRIBE `ports` 0.0027379989624023
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.00062322616577148
(470) DESCRIBE `ports` 0.0025639533996582
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00060009956359863
(472) DESCRIBE `ports` 0.0028541088104248
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00055503845214844
(474) DESCRIBE `ports` 0.0025320053100586
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0005950927734375
(476) DESCRIBE `ports` 0.0025391578674316
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0004279613494873
(478) DESCRIBE `ports` 0.0023391246795654
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00045585632324219
(480) DESCRIBE `ports` 0.0022890567779541
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00050616264343262
(482) DESCRIBE `ports` 0.0026028156280518
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00044703483581543
(484) DESCRIBE `ports` 0.0027310848236084
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00040602684020996
(486) DESCRIBE `ports` 0.0030508041381836
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00051689147949219
(488) DESCRIBE `ports` 0.0027170181274414
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00041103363037109
(490) DESCRIBE `ports` 0.0021111965179443
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00046682357788086
(492) DESCRIBE `ports` 0.0024929046630859
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00044512748718262
(494) DESCRIBE `ports` 0.0019569396972656
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00046586990356445
(496) DESCRIBE `ports` 0.0019149780273438
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.0005950927734375
(498) DESCRIBE `ports` 0.0027310848236084
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00059294700622559
(500) DESCRIBE `ports` 0.0029258728027344
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00056695938110352
(502) DESCRIBE `avid_specials` 0.0025389194488525
(503) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72859 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021829605102539
(504) DESCRIBE `cruiselines` 0.0041568279266357
(505) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00048089027404785
(506) DESCRIBE `orchid_image` 0.0034821033477783
(507) DESCRIBE `cruiselines` 0.00370192527771
(508) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00051999092102051
(509) DESCRIBE `cruises` 0.0048339366912842
(510) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66202') 0.00059008598327637
(511) DESCRIBE `ships` 0.0054531097412109
(512) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00068783760070801
(513) DESCRIBE `ships` 0.0045561790466309
(514) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00051593780517578
(515) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00045394897460938
(516) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003669261932373
(517) DESCRIBE `itineraries` 0.002310037612915
(518) DESCRIBE `ports` 0.0029749870300293
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00066304206848145
(520) DESCRIBE `ports` 0.0027987957000732
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00050806999206543
(522) DESCRIBE `ports` 0.0019230842590332
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00042390823364258
(524) DESCRIBE `sailingdates` 0.0023808479309082
(525) DESCRIBE `ports` 0.0020999908447266
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0004580020904541
(527) DESCRIBE `ports` 0.0022411346435547
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00056099891662598
(529) DESCRIBE `ports` 0.0031580924987793
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00062394142150879
(531) DESCRIBE `ports` 0.0026609897613525
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00062084197998047
(533) DESCRIBE `ports` 0.0036280155181885
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00072383880615234
(535) DESCRIBE `ports` 0.0035159587860107
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00064802169799805
(537) DESCRIBE `ports` 0.0023729801177979
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00057888031005859
(539) DESCRIBE `ports` 0.0023958683013916
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00040698051452637
(541) DESCRIBE `ports` 0.0018448829650879
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00042104721069336
(543) DESCRIBE `ports` 0.0018470287322998
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00053310394287109
(545) DESCRIBE `ports` 0.0021569728851318
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00066614151000977
(547) DESCRIBE `ports` 0.0023238658905029
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00061297416687012
(549) DESCRIBE `ports` 0.0024070739746094
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3558))) 0.00050592422485352
(551) DESCRIBE `ports` 0.0024509429931641
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3558') 0.00053310394287109
(553) DESCRIBE `ports` 0.0022389888763428
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.00054097175598145
(555) DESCRIBE `ports` 0.0022950172424316
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.00043106079101562
(557) DESCRIBE `ports` 0.0025238990783691
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00050997734069824
(559) DESCRIBE `ports` 0.0024361610412598
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00040912628173828
(561) DESCRIBE `ports` 0.002763032913208
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0004889965057373
(563) DESCRIBE `ports` 0.0023272037506104
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00041604042053223
(565) DESCRIBE `avid_specials` 0.0019052028656006
(566) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66202 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014669895172119
(567) DESCRIBE `cruiselines` 0.0037147998809814
(568) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00064301490783691
(569) DESCRIBE `orchid_image` 0.0020148754119873
(570) DESCRIBE `cruiselines` 0.0037648677825928
(571) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00051712989807129
(572) DESCRIBE `cruises` 0.0045628547668457
(573) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72898') 0.0005190372467041
(574) DESCRIBE `ships` 0.0056369304656982
(575) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00086092948913574
(576) DESCRIBE `ships` 0.0053179264068604
(577) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.0007169246673584
(578) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048708915710449
(579) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051593780517578
(580) DESCRIBE `itineraries` 0.0031630992889404
(581) DESCRIBE `ports` 0.0026001930236816
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005650520324707
(583) DESCRIBE `ports` 0.0028419494628906
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00055789947509766
(585) DESCRIBE `ports` 0.0026299953460693
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00063395500183105
(587) DESCRIBE `sailingdates` 0.0024538040161133
(588) DESCRIBE `ports` 0.002636194229126
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00072503089904785
(590) DESCRIBE `ports` 0.002586841583252
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00058293342590332
(592) DESCRIBE `ports` 0.002669095993042
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00058794021606445
(594) DESCRIBE `ports` 0.0040059089660645
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00058794021606445
(596) DESCRIBE `ports` 0.0024650096893311
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2511))) 0.00065898895263672
(598) DESCRIBE `ports` 0.0023729801177979
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2511') 0.0006561279296875
(600) DESCRIBE `ports` 0.0024209022521973
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.0006251335144043
(602) DESCRIBE `ports` 0.0030031204223633
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00051593780517578
(604) DESCRIBE `ports` 0.0029799938201904
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3293))) 0.00051689147949219
(606) DESCRIBE `ports` 0.002748966217041
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3293') 0.00047492980957031
(608) DESCRIBE `ports` 0.0032269954681396
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00049519538879395
(610) DESCRIBE `ports` 0.0030210018157959
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00046992301940918
(612) DESCRIBE `ports` 0.0027899742126465
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2062))) 0.00056195259094238
(614) DESCRIBE `ports` 0.003087043762207
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2062') 0.00058293342590332
(616) DESCRIBE `ports` 0.0030989646911621
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00055289268493652
(618) DESCRIBE `ports` 0.0023379325866699
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00050497055053711
(620) DESCRIBE `ports` 0.0028781890869141
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00055289268493652
(622) DESCRIBE `ports` 0.002439022064209
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00050783157348633
(624) DESCRIBE `ports` 0.002824068069458
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00050687789916992
(626) DESCRIBE `ports` 0.0022778511047363
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00048398971557617
(628) DESCRIBE `ports` 0.0028238296508789
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00050997734069824
(630) DESCRIBE `ports` 0.0022988319396973
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00048685073852539
(632) DESCRIBE `avid_specials` 0.0021491050720215
(633) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72898 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 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.001863956451416
(634) DESCRIBE `cruiselines` 0.0047900676727295
(635) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00061798095703125
(636) DESCRIBE `orchid_image` 0.0028541088104248
(637) DESCRIBE `cruiselines` 0.0033650398254395
(638) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00044798851013184
(639) DESCRIBE `cruises` 0.0057840347290039
(640) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72853') 0.00062990188598633
(641) DESCRIBE `ships` 0.0054380893707275
(642) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00071310997009277
(643) DESCRIBE `ships` 0.0056490898132324
(644) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00052118301391602
(645) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048398971557617
(646) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00056004524230957
(647) DESCRIBE `itineraries` 0.0024189949035645
(648) DESCRIBE `ports` 0.002338171005249
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00060200691223145
(650) DESCRIBE `ports` 0.0030910968780518
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0006098747253418
(652) DESCRIBE `ports` 0.0030660629272461
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00063300132751465
(654) DESCRIBE `sailingdates` 0.002453088760376
(655) DESCRIBE `ports` 0.0028560161590576
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0006108283996582
(657) DESCRIBE `ports` 0.0021810531616211
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00053501129150391
(659) DESCRIBE `ports` 0.0023818016052246
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0004880428314209
(661) DESCRIBE `ports` 0.0025088787078857
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00041389465332031
(663) DESCRIBE `ports` 0.0022561550140381
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00046706199645996
(665) DESCRIBE `ports` 0.002795934677124
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00043702125549316
(667) DESCRIBE `ports` 0.0024580955505371
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00057101249694824
(669) DESCRIBE `ports` 0.0019500255584717
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00056099891662598
(671) DESCRIBE `ports` 0.0029020309448242
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00053191184997559
(673) DESCRIBE `ports` 0.0032329559326172
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00044107437133789
(675) DESCRIBE `ports` 0.0023307800292969
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00067782402038574
(677) DESCRIBE `ports` 0.0030159950256348
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00066208839416504
(679) DESCRIBE `ports` 0.0021021366119385
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00056600570678711
(681) DESCRIBE `ports` 0.0024509429931641
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00046396255493164
(683) DESCRIBE `ports` 0.035439014434814
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00080490112304688
(685) DESCRIBE `ports` 0.0029609203338623
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00046586990356445
(687) DESCRIBE `ports` 0.0026741027832031
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00058388710021973
(689) DESCRIBE `ports` 0.012511968612671
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.0005030632019043
(691) DESCRIBE `ports` 0.0025119781494141
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00045204162597656
(693) DESCRIBE `ports` 0.0034639835357666
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00068807601928711
(695) DESCRIBE `ports` 0.0032851696014404
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.0006868839263916
(697) DESCRIBE `ports` 0.002802848815918
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.0004580020904541
(699) DESCRIBE `ports` 0.0026450157165527
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.0005950927734375
(701) DESCRIBE `ports` 0.0034809112548828
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00079703330993652
(703) DESCRIBE `ports` 0.0036599636077881
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00062417984008789
(705) DESCRIBE `ports` 0.0024628639221191
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00052189826965332
(707) DESCRIBE `ports` 0.0025739669799805
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.00044703483581543
(709) DESCRIBE `ports` 0.0024080276489258
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00044703483581543
(711) DESCRIBE `ports` 0.0027601718902588
(712) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00046801567077637
(713) DESCRIBE `ports` 0.0026299953460693
(714) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0005030632019043
(715) DESCRIBE `ports` 0.0027279853820801
(716) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00055789947509766
(717) DESCRIBE `ports` 0.002418041229248
(718) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00046801567077637
(719) DESCRIBE `ports` 0.0029129981994629
(720) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 568))) 0.00067305564880371
(721) DESCRIBE `ports` 0.0023820400238037
(722) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '568') 0.00048995018005371
(723) DESCRIBE `ports` 0.0028219223022461
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 567))) 0.00049591064453125
(725) DESCRIBE `ports` 0.0021600723266602
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '567') 0.0004279613494873
(727) DESCRIBE `ports` 0.0029098987579346
(728) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00055408477783203
(729) DESCRIBE `ports` 0.0023260116577148
(730) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00047707557678223
(731) DESCRIBE `ports` 0.0023119449615479
(732) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00059604644775391
(733) DESCRIBE `ports` 0.0023870468139648
(734) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00068211555480957
(735) DESCRIBE `ports` 0.0027639865875244
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1870))) 0.00076413154602051
(737) DESCRIBE `ports` 0.0029191970825195
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1870') 0.00079202651977539
(739) DESCRIBE `ports` 0.0034539699554443
(740) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00052189826965332
(741) DESCRIBE `ports` 0.0029737949371338
(742) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.00062894821166992
(743) DESCRIBE `ports` 0.0032000541687012
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2987))) 0.00067615509033203
(745) DESCRIBE `ports` 0.0033271312713623
(746) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2987') 0.00053977966308594
(747) DESCRIBE `ports` 0.0031051635742188
(748) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00062918663024902
(749) DESCRIBE `ports` 0.0031139850616455
(750) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00051212310791016
(751) DESCRIBE `ports` 0.0032398700714111
(752) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00053906440734863
(753) DESCRIBE `ports` 0.002669095993042
(754) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00058197975158691
(755) DESCRIBE `avid_specials` 0.0023589134216309
(756) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72853 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019919872283936
(757) DESCRIBE `cruiselines` 0.0040600299835205
(758) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00070619583129883
(759) DESCRIBE `orchid_image` 0.0030288696289062
(760) DESCRIBE `cruiselines` 0.0039589405059814
(761) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00052690505981445
(762) DESCRIBE `ships` 0.0047731399536133
(763) SELECT `ships`.* FROM `ships` WHERE (id IN ('850', '1319', '1108', '966', '508', '394')) ORDER BY FIND_IN_SET(id, '850,1319,1108,966,508,394') 0.0015060901641846
(764) DESCRIBE `cruisetypes` 0.0018701553344727
(765) DESCRIBE `destinations` 0.0028958320617676
(766) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '37', '43', '35', '38', '2', '26', '28', '48', '11', '21', '45', '8', '30', '49', '52', '10', '25', '34', '32', '55')) ORDER BY FIND_IN_SET(id, '22,12,40,37,43,35,38,2,26,28,48,11,21,45,8,30,49,52,10,25,34,32,55') 0.002708911895752
(767) DESCRIBE `cruiselines` 0.0037541389465332
(768) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00058889389038086
(769) DESCRIBE `cruiselines` 0.0032839775085449
(770) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00075912475585938