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

Total elapsed time: 1.5386228561401

# Query Time
(1) connect 0.0019161701202393
(2) DESCRIBE `cruises` 0.0062320232391357
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80003, 80006, 80007, 80009, 80008, 80053, 80053, 80016, 80018, 80019)) ORDER BY FIND_IN_SET(id, '80003,80006,80007,80009,80008,80053,80053,80016,80018,80019') 0.0037739276885986
(4) DESCRIBE `cruises` 0.013276100158691
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80003') 0.0009150505065918
(6) DESCRIBE `ships` 0.0057029724121094
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0013339519500732
(8) DESCRIBE `ships` 0.0056028366088867
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00068187713623047
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00074601173400879
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050997734069824
(12) DESCRIBE `itineraries` 0.0029120445251465
(13) DESCRIBE `ports` 0.0031411647796631
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0011270046234131
(15) DESCRIBE `ports` 0.0036020278930664
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00074195861816406
(17) DESCRIBE `ports` 0.0029058456420898
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00084209442138672
(19) DESCRIBE `sailingdates` 0.0029809474945068
(20) DESCRIBE `ports` 0.0033769607543945
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00085306167602539
(22) DESCRIBE `ports` 0.0032711029052734
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0012807846069336
(24) DESCRIBE `ports` 0.0030641555786133
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2157))) 0.00069808959960938
(26) DESCRIBE `ports` 0.0029489994049072
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2157') 0.00071096420288086
(28) DESCRIBE `ports` 0.0036771297454834
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00069594383239746
(30) DESCRIBE `ports` 0.0032050609588623
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00064897537231445
(32) DESCRIBE `ports` 0.0033271312713623
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00088691711425781
(34) DESCRIBE `ports` 0.0033159255981445
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00073599815368652
(36) DESCRIBE `ports` 0.0029261112213135
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00096297264099121
(38) DESCRIBE `ports` 0.0048599243164062
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00074219703674316
(40) DESCRIBE `ports` 0.0047290325164795
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00080609321594238
(42) DESCRIBE `ports` 0.0035150051116943
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00071811676025391
(44) DESCRIBE `ports` 0.0029919147491455
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00077009201049805
(46) DESCRIBE `ports` 0.0024018287658691
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00053215026855469
(48) DESCRIBE `ports` 0.0027530193328857
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00066995620727539
(50) DESCRIBE `ports` 0.0029101371765137
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00054001808166504
(52) DESCRIBE `ports` 0.0025439262390137
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00061798095703125
(54) DESCRIBE `ports` 0.0025339126586914
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00054287910461426
(56) DESCRIBE `ports` 0.002748966217041
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0007178783416748
(58) DESCRIBE `ports` 0.0027210712432861
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00061511993408203
(60) DESCRIBE `ports` 0.0025429725646973
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00063610076904297
(62) DESCRIBE `ports` 0.00282883644104
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0006110668182373
(64) DESCRIBE `avid_specials` 0.002485990524292
(65) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80003 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.0026979446411133
(66) DESCRIBE `cruiselines` 0.0043840408325195
(67) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00078296661376953
(68) DESCRIBE `orchid_image` 0.003565788269043
(69) DESCRIBE `cruiselines` 0.0039241313934326
(70) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00063300132751465
(71) DESCRIBE `cruises` 0.0056672096252441
(72) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80006') 0.00072503089904785
(73) DESCRIBE `ships` 0.0058140754699707
(74) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00070691108703613
(75) DESCRIBE `ships` 0.0047240257263184
(76) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.0006260871887207
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00045204162597656
(78) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043797492980957
(79) DESCRIBE `itineraries` 0.002547025680542
(80) DESCRIBE `ports` 0.00301194190979
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00074982643127441
(82) DESCRIBE `ports` 0.0028030872344971
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00064396858215332
(84) DESCRIBE `ports` 0.0029089450836182
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00061416625976562
(86) DESCRIBE `sailingdates` 0.0024070739746094
(87) DESCRIBE `ports` 0.0028109550476074
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00073599815368652
(89) DESCRIBE `ports` 0.0029928684234619
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00065898895263672
(91) DESCRIBE `ports` 0.0028741359710693
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00068306922912598
(93) DESCRIBE `ports` 0.0029430389404297
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00070500373840332
(95) DESCRIBE `ports` 0.0028588771820068
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00076818466186523
(97) DESCRIBE `ports` 0.0026540756225586
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00061416625976562
(99) DESCRIBE `ports` 0.0027081966400146
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00059390068054199
(101) DESCRIBE `ports` 0.0029218196868896
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0006401538848877
(103) DESCRIBE `ports` 0.0029118061065674
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00083708763122559
(105) DESCRIBE `ports` 0.0028340816497803
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00067520141601562
(107) DESCRIBE `ports` 0.0028030872344971
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00059700012207031
(109) DESCRIBE `ports` 0.0027980804443359
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00099802017211914
(111) DESCRIBE `ports` 0.0029950141906738
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00069308280944824
(113) DESCRIBE `ports` 0.0029208660125732
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00065803527832031
(115) DESCRIBE `ports` 0.0029110908508301
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00062203407287598
(117) DESCRIBE `ports` 0.002720832824707
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00060796737670898
(119) DESCRIBE `ports` 0.0028688907623291
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 645))) 0.0015189647674561
(121) DESCRIBE `ports` 0.0038740634918213
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '645') 0.0007331371307373
(123) DESCRIBE `ports` 0.0031828880310059
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.000885009765625
(125) DESCRIBE `ports` 0.0033590793609619
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00069284439086914
(127) DESCRIBE `ports` 0.0035710334777832
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00094795227050781
(129) DESCRIBE `ports` 0.0040760040283203
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0011320114135742
(131) DESCRIBE `avid_specials` 0.019695997238159
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80006 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.0042610168457031
(133) DESCRIBE `cruiselines` 0.0060210227966309
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0018720626831055
(135) DESCRIBE `orchid_image` 0.0046310424804688
(136) DESCRIBE `cruiselines` 0.0052428245544434
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00074601173400879
(138) DESCRIBE `cruises` 0.0046730041503906
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80007') 0.00060606002807617
(140) DESCRIBE `ships` 0.0052671432495117
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00078606605529785
(142) DESCRIBE `ships` 0.0064082145690918
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00073409080505371
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00065898895263672
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051307678222656
(146) DESCRIBE `itineraries` 0.0031709671020508
(147) DESCRIBE `ports` 0.0031919479370117
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00078701972961426
(149) DESCRIBE `ports` 0.0032401084899902
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00077199935913086
(151) DESCRIBE `ports` 0.0030679702758789
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00070881843566895
(153) DESCRIBE `sailingdates` 0.002734899520874
(154) DESCRIBE `ports` 0.0034670829772949
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00079607963562012
(156) DESCRIBE `ports` 0.0032341480255127
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00072193145751953
(158) DESCRIBE `ports` 0.0028860569000244
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00067496299743652
(160) DESCRIBE `ports` 0.0027251243591309
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00073599815368652
(162) DESCRIBE `ports` 0.0032379627227783
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 645))) 0.00083804130554199
(164) DESCRIBE `ports` 0.0045759677886963
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '645') 0.00069999694824219
(166) DESCRIBE `ports` 0.0027570724487305
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00071811676025391
(168) DESCRIBE `ports` 0.0028269290924072
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00080990791320801
(170) DESCRIBE `ports` 0.0028030872344971
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00073003768920898
(172) DESCRIBE `ports` 0.0026969909667969
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00065398216247559
(174) DESCRIBE `ports` 0.002899169921875
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00070810317993164
(176) DESCRIBE `ports` 0.0028440952301025
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00067615509033203
(178) DESCRIBE `ports` 0.0035688877105713
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00061893463134766
(180) DESCRIBE `ports` 0.0030348300933838
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00065922737121582
(182) DESCRIBE `ports` 0.0027120113372803
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00068306922912598
(184) DESCRIBE `ports` 0.0030670166015625
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00063705444335938
(186) DESCRIBE `ports` 0.0033738613128662
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00071597099304199
(188) DESCRIBE `ports` 0.0033268928527832
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00070500373840332
(190) DESCRIBE `ports` 0.0030720233917236
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00089311599731445
(192) DESCRIBE `ports` 0.0029239654541016
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00066685676574707
(194) DESCRIBE `ports` 0.0026419162750244
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00060200691223145
(196) DESCRIBE `ports` 0.0030879974365234
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00062108039855957
(198) DESCRIBE `avid_specials` 0.002514123916626
(199) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80007 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.002234935760498
(200) DESCRIBE `cruiselines` 0.0041751861572266
(201) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00075793266296387
(202) DESCRIBE `orchid_image` 0.0032320022583008
(203) DESCRIBE `cruiselines` 0.0037910938262939
(204) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00071501731872559
(205) DESCRIBE `cruises` 0.0052409172058105
(206) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80009') 0.00083804130554199
(207) DESCRIBE `ships` 0.0055029392242432
(208) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0008389949798584
(209) DESCRIBE `ships` 0.0053730010986328
(210) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00050783157348633
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042295455932617
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034999847412109
(213) DESCRIBE `itineraries` 0.0024948120117188
(214) DESCRIBE `ports` 0.0025739669799805
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00069594383239746
(216) DESCRIBE `ports` 0.0027651786804199
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00064897537231445
(218) DESCRIBE `ports` 0.0029830932617188
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00065016746520996
(220) DESCRIBE `sailingdates` 0.0025851726531982
(221) DESCRIBE `ports` 0.0028829574584961
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00076889991760254
(223) DESCRIBE `ports` 0.0029311180114746
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00076913833618164
(225) DESCRIBE `ports` 0.0034651756286621
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0007779598236084
(227) DESCRIBE `ports` 0.0024290084838867
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00061321258544922
(229) DESCRIBE `ports` 0.0023970603942871
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00074195861816406
(231) DESCRIBE `ports` 0.002593994140625
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0005340576171875
(233) DESCRIBE `ports` 0.0027880668640137
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00059294700622559
(235) DESCRIBE `ports` 0.0025680065155029
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00052595138549805
(237) DESCRIBE `ports` 0.0024929046630859
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00061607360839844
(239) DESCRIBE `ports` 0.0024909973144531
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00055909156799316
(241) DESCRIBE `ports` 0.0025479793548584
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00060701370239258
(243) DESCRIBE `ports` 0.0026900768280029
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00062203407287598
(245) DESCRIBE `ports` 0.0026450157165527
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00093889236450195
(247) DESCRIBE `ports` 0.0030341148376465
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.0006721019744873
(249) DESCRIBE `ports` 0.0030660629272461
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.0006558895111084
(251) DESCRIBE `ports` 0.0030210018157959
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00063896179199219
(253) DESCRIBE `ports` 0.0027849674224854
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0007929801940918
(255) DESCRIBE `ports` 0.0026381015777588
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00062179565429688
(257) DESCRIBE `ports` 0.0027561187744141
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.00060582160949707
(259) DESCRIBE `ports` 0.0035078525543213
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.000762939453125
(261) DESCRIBE `ports` 0.0029950141906738
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00068306922912598
(263) DESCRIBE `ports` 0.0066919326782227
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00089192390441895
(265) DESCRIBE `ports` 0.0062799453735352
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2157))) 0.00070905685424805
(267) DESCRIBE `ports` 0.0026710033416748
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2157') 0.0010647773742676
(269) DESCRIBE `ports` 0.0030272006988525
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 876))) 0.00097298622131348
(271) DESCRIBE `ports` 0.0032429695129395
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '876') 0.00065183639526367
(273) DESCRIBE `ports` 0.0027339458465576
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00064802169799805
(275) DESCRIBE `ports` 0.0024781227111816
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00056290626525879
(277) DESCRIBE `ports` 0.0024759769439697
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00063395500183105
(279) DESCRIBE `ports` 0.0059609413146973
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00073695182800293
(281) DESCRIBE `ports` 0.0026488304138184
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.000823974609375
(283) DESCRIBE `ports` 0.0028059482574463
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00062203407287598
(285) DESCRIBE `ports` 0.003244161605835
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00094294548034668
(287) DESCRIBE `ports` 0.0029399394989014
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00070691108703613
(289) DESCRIBE `ports` 0.003399133682251
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00078105926513672
(291) DESCRIBE `ports` 0.0030040740966797
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00067806243896484
(293) DESCRIBE `ports` 0.0062458515167236
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00072693824768066
(295) DESCRIBE `ports` 0.0049200057983398
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00074195861816406
(297) DESCRIBE `ports` 0.0051310062408447
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00082087516784668
(299) DESCRIBE `ports` 0.0036830902099609
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00069093704223633
(301) DESCRIBE `ports` 0.0029640197753906
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00073504447937012
(303) DESCRIBE `ports` 0.0028450489044189
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00063896179199219
(305) DESCRIBE `ports` 0.0028510093688965
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00066590309143066
(307) DESCRIBE `ports` 0.0027990341186523
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00059700012207031
(309) DESCRIBE `avid_specials` 0.0021390914916992
(310) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80009 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.0022618770599365
(311) DESCRIBE `cruiselines` 0.0038800239562988
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00078582763671875
(313) DESCRIBE `orchid_image` 0.0039019584655762
(314) DESCRIBE `cruiselines` 0.0048511028289795
(315) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00062298774719238
(316) DESCRIBE `cruises` 0.0050699710845947
(317) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80008') 0.00075101852416992
(318) DESCRIBE `ships` 0.005742073059082
(319) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0007929801940918
(320) DESCRIBE `ships` 0.0054190158843994
(321) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00075197219848633
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005340576171875
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00062417984008789
(324) DESCRIBE `itineraries` 0.0034058094024658
(325) DESCRIBE `ports` 0.0034449100494385
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00097203254699707
(327) DESCRIBE `ports` 0.0033690929412842
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00069403648376465
(329) DESCRIBE `ports` 0.003040075302124
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00075411796569824
(331) DESCRIBE `sailingdates` 0.0025951862335205
(332) DESCRIBE `ports` 0.0035781860351562
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0006709098815918
(334) DESCRIBE `ports` 0.0027790069580078
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00064706802368164
(336) DESCRIBE `ports` 0.0028409957885742
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00064897537231445
(338) DESCRIBE `ports` 0.0029549598693848
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00065803527832031
(340) DESCRIBE `ports` 0.0029089450836182
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00069403648376465
(342) DESCRIBE `ports` 0.0026648044586182
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00061297416687012
(344) DESCRIBE `ports` 0.0027239322662354
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00064611434936523
(346) DESCRIBE `ports` 0.0028190612792969
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00062108039855957
(348) DESCRIBE `ports` 0.0029251575469971
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00076508522033691
(350) DESCRIBE `ports` 0.002979040145874
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00077080726623535
(352) DESCRIBE `ports` 0.0031158924102783
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00069999694824219
(354) DESCRIBE `ports` 0.0030269622802734
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00066590309143066
(356) DESCRIBE `ports` 0.0029771327972412
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00073695182800293
(358) DESCRIBE `ports` 0.0028929710388184
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00063490867614746
(360) DESCRIBE `ports` 0.0029468536376953
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00075912475585938
(362) DESCRIBE `ports` 0.0027971267700195
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00052809715270996
(364) DESCRIBE `ports` 0.0026109218597412
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00065088272094727
(366) DESCRIBE `ports` 0.0026209354400635
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0006260871887207
(368) DESCRIBE `ports` 0.0027439594268799
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.0006709098815918
(370) DESCRIBE `ports` 0.0028378963470459
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.00059199333190918
(372) DESCRIBE `ports` 0.002223014831543
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00059795379638672
(374) DESCRIBE `ports` 0.0022540092468262
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00045990943908691
(376) DESCRIBE `avid_specials` 0.0019278526306152
(377) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80008 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.0018069744110107
(378) DESCRIBE `cruiselines` 0.0033631324768066
(379) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00056600570678711
(380) DESCRIBE `orchid_image` 0.0026750564575195
(381) DESCRIBE `cruiselines` 0.0034811496734619
(382) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00066208839416504
(383) DESCRIBE `specials` 0.0081171989440918
(384) DESCRIBE `specials` 0.0082840919494629
(385) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1624582') 0.00087285041809082
(386) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id != '1624582') 0.001288890838623
(387) UPDATE `specials` SET `orchid_slug` = ? WHERE (id = '1624582') 0.000762939453125
(388) DESCRIBE `ships` 0.0055079460144043
(389) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.0008399486541748
(390) DESCRIBE `ships` 0.0051300525665283
(391) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00070595741271973
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004880428314209
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051784515380859
(394) DESCRIBE `itineraries` 0.0033178329467773
(395) DESCRIBE `ports` 0.0031170845031738
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00087594985961914
(397) DESCRIBE `ports` 0.0029699802398682
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00070285797119141
(399) DESCRIBE `ports` 0.0025849342346191
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00069284439086914
(401) DESCRIBE `specialsailingdates` 0.0022501945495605
(402) DESCRIBE `sailingdates` 0.002255916595459
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 494455))) 0.00079202651977539
(404) DESCRIBE `ports` 0.002877950668335
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00067782402038574
(406) DESCRIBE `ports` 0.0026040077209473
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00058698654174805
(408) DESCRIBE `ports` 0.0026321411132812
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00064420700073242
(410) DESCRIBE `ports` 0.0028140544891357
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00073981285095215
(412) DESCRIBE `ports` 0.0029549598693848
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00068402290344238
(414) DESCRIBE `ports` 0.0033700466156006
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00080585479736328
(416) DESCRIBE `ports` 0.0029549598693848
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00074410438537598
(418) DESCRIBE `ports` 0.0027508735656738
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00057601928710938
(420) DESCRIBE `ports` 0.0028679370880127
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 642))) 0.00076699256896973
(422) DESCRIBE `ports` 0.0023980140686035
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '642') 0.00057816505432129
(424) DESCRIBE `ports` 0.0025458335876465
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2372))) 0.00074195861816406
(426) DESCRIBE `ports` 0.0031211376190186
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2372') 0.00067305564880371
(428) DESCRIBE `ports` 0.0029819011688232
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00072193145751953
(430) DESCRIBE `ports` 0.0029969215393066
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00067400932312012
(432) DESCRIBE `ports` 0.002953052520752
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00074601173400879
(434) DESCRIBE `ports` 0.0030760765075684
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00068187713623047
(436) DESCRIBE `ports` 0.0027501583099365
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00072503089904785
(438) DESCRIBE `ports` 0.0028960704803467
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00065803527832031
(440) DESCRIBE `ports` 0.0030241012573242
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00074410438537598
(442) DESCRIBE `ports` 0.003007173538208
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00068521499633789
(444) DESCRIBE `ports` 0.0029358863830566
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00078511238098145
(446) DESCRIBE `ports` 0.0029151439666748
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00063705444335938
(448) DESCRIBE `ports` 0.0028390884399414
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00073122978210449
(450) DESCRIBE `ports` 0.0029149055480957
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00066804885864258
(452) DESCRIBE `cruises` 0.0054299831390381
(453) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80053))) 0.00096797943115234
(454) DESCRIBE `avid_specials` 0.0026619434356689
(455) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1624582 and class = 'Special') OR (item_id = 80053 and class = 'Cruise') OR (item_id = 508 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.0021860599517822
(456) DESCRIBE `cruiselines` 0.0041069984436035
(457) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00071191787719727
(458) DESCRIBE `orchid_image` 0.0027170181274414
(459) DESCRIBE `cruiselines` 0.0028791427612305
(460) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0005948543548584
(461) DESCRIBE `cruises` 0.004770040512085
(462) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80053') 0.00063610076904297
(463) DESCRIBE `ships` 0.0049388408660889
(464) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.00081086158752441
(465) DESCRIBE `ships` 0.0051529407501221
(466) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00055813789367676
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048708915710449
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054001808166504
(469) DESCRIBE `itineraries` 0.0029349327087402
(470) DESCRIBE `ports` 0.0026590824127197
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00065898895263672
(472) DESCRIBE `ports` 0.0024199485778809
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00056099891662598
(474) DESCRIBE `ports` 0.0023331642150879
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.0005180835723877
(476) DESCRIBE `sailingdates` 0.0020451545715332
(477) DESCRIBE `ports` 0.0024158954620361
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00063395500183105
(479) DESCRIBE `ports` 0.002410888671875
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00055813789367676
(481) DESCRIBE `ports` 0.002371072769165
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00072407722473145
(483) DESCRIBE `ports` 0.0025520324707031
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00056099891662598
(485) DESCRIBE `ports` 0.002349853515625
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00060606002807617
(487) DESCRIBE `ports` 0.0023150444030762
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00052404403686523
(489) DESCRIBE `ports` 0.0023331642150879
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00055193901062012
(491) DESCRIBE `ports` 0.0023000240325928
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00050711631774902
(493) DESCRIBE `ports` 0.0023548603057861
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 642))) 0.00062704086303711
(495) DESCRIBE `ports` 0.0022940635681152
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '642') 0.0005028247833252
(497) DESCRIBE `ports` 0.0023379325866699
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2372))) 0.00054311752319336
(499) DESCRIBE `ports` 0.0023150444030762
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2372') 0.00055122375488281
(501) DESCRIBE `ports` 0.0023691654205322
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00058507919311523
(503) DESCRIBE `ports` 0.0023448467254639
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00052094459533691
(505) DESCRIBE `ports` 0.0023410320281982
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00056314468383789
(507) DESCRIBE `ports` 0.0024220943450928
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00053095817565918
(509) DESCRIBE `ports` 0.0024669170379639
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00064611434936523
(511) DESCRIBE `ports` 0.0023379325866699
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00053119659423828
(513) DESCRIBE `ports` 0.0023009777069092
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00060486793518066
(515) DESCRIBE `ports` 0.0023257732391357
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00063395500183105
(517) DESCRIBE `ports` 0.0023400783538818
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0008699893951416
(519) DESCRIBE `ports` 0.0023751258850098
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00056695938110352
(521) DESCRIBE `ports` 0.0023009777069092
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00061798095703125
(523) DESCRIBE `ports` 0.0023040771484375
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0005500316619873
(525) DESCRIBE `avid_specials` 0.0021178722381592
(526) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80053 and class = 'Cruise') OR (item_id = 508 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.0017569065093994
(527) DESCRIBE `cruiselines` 0.0032901763916016
(528) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0006709098815918
(529) DESCRIBE `orchid_image` 0.0027589797973633
(530) DESCRIBE `cruiselines` 0.003364086151123
(531) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00054001808166504
(532) DESCRIBE `cruises` 0.0044457912445068
(533) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80016') 0.00056695938110352
(534) DESCRIBE `ships` 0.004655122756958
(535) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0006859302520752
(536) DESCRIBE `ships` 0.0045850276947021
(537) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00053215026855469
(538) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043797492980957
(539) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042605400085449
(540) DESCRIBE `itineraries` 0.0023288726806641
(541) DESCRIBE `ports` 0.0024769306182861
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00051403045654297
(543) DESCRIBE `ports` 0.0022499561309814
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00048708915710449
(545) DESCRIBE `ports` 0.0022518634796143
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00059890747070312
(547) DESCRIBE `sailingdates` 0.0026051998138428
(548) DESCRIBE `ports` 0.0032210350036621
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00078082084655762
(550) DESCRIBE `ports` 0.0026590824127197
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00056290626525879
(552) DESCRIBE `ports` 0.0027990341186523
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00078892707824707
(554) DESCRIBE `ports` 0.0028181076049805
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00052595138549805
(556) DESCRIBE `ports` 0.0023751258850098
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1140))) 0.00063991546630859
(558) DESCRIBE `ports` 0.002655029296875
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1140') 0.00067496299743652
(560) DESCRIBE `ports` 0.0027358531951904
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00071310997009277
(562) DESCRIBE `ports` 0.0027759075164795
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00081014633178711
(564) DESCRIBE `ports` 0.003180980682373
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0009300708770752
(566) DESCRIBE `ports` 0.0025198459625244
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00053286552429199
(568) DESCRIBE `ports` 0.0022938251495361
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00065398216247559
(570) DESCRIBE `ports` 0.0028319358825684
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00062799453735352
(572) DESCRIBE `ports` 0.0025310516357422
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0006558895111084
(574) DESCRIBE `ports` 0.0026640892028809
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00057697296142578
(576) DESCRIBE `ports` 0.0028669834136963
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00059223175048828
(578) DESCRIBE `ports` 0.0027308464050293
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00055599212646484
(580) DESCRIBE `ports` 0.0025410652160645
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00064206123352051
(582) DESCRIBE `ports` 0.0027871131896973
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00067615509033203
(584) DESCRIBE `ports` 0.0028350353240967
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00072383880615234
(586) DESCRIBE `ports` 0.0029129981994629
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00053310394287109
(588) DESCRIBE `ports` 0.0028610229492188
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0007328987121582
(590) DESCRIBE `ports` 0.0029568672180176
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00071001052856445
(592) DESCRIBE `avid_specials` 0.0025060176849365
(593) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80016 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.002187967300415
(594) DESCRIBE `cruiselines` 0.0041329860687256
(595) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00087380409240723
(596) DESCRIBE `orchid_image` 0.0034911632537842
(597) DESCRIBE `cruiselines` 0.0043270587921143
(598) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00088095664978027
(599) DESCRIBE `cruises` 0.0053789615631104
(600) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80018') 0.0007328987121582
(601) DESCRIBE `ships` 0.0056748390197754
(602) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00098681449890137
(603) DESCRIBE `ships` 0.0056250095367432
(604) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00070095062255859
(605) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047111511230469
(606) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044703483581543
(607) DESCRIBE `itineraries` 0.0026209354400635
(608) DESCRIBE `ports` 0.0027649402618408
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00081801414489746
(610) DESCRIBE `ports` 0.0026888847351074
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00073599815368652
(612) DESCRIBE `ports` 0.002655029296875
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0006558895111084
(614) DESCRIBE `sailingdates` 0.0023939609527588
(615) DESCRIBE `ports` 0.0027210712432861
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00075411796569824
(617) DESCRIBE `ports` 0.0027468204498291
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00070691108703613
(619) DESCRIBE `ports` 0.0025670528411865
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00064992904663086
(621) DESCRIBE `ports` 0.0025649070739746
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00062012672424316
(623) DESCRIBE `ports` 0.0028939247131348
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 645))) 0.000701904296875
(625) DESCRIBE `ports` 0.0027189254760742
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '645') 0.00069808959960938
(627) DESCRIBE `ports` 0.0028829574584961
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00072288513183594
(629) DESCRIBE `ports` 0.0032229423522949
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00068998336791992
(631) DESCRIBE `ports` 0.002830982208252
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00091981887817383
(633) DESCRIBE `ports` 0.0028500556945801
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.0012068748474121
(635) DESCRIBE `ports` 0.0035369396209717
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00081706047058105
(637) DESCRIBE `ports` 0.0031960010528564
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00070619583129883
(639) DESCRIBE `ports` 0.0029370784759521
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00085592269897461
(641) DESCRIBE `ports` 0.0031678676605225
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0009610652923584
(643) DESCRIBE `ports` 0.0031709671020508
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00077009201049805
(645) DESCRIBE `ports` 0.0032618045806885
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00072908401489258
(647) DESCRIBE `ports` 0.0030050277709961
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00085997581481934
(649) DESCRIBE `ports` 0.0030770301818848
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00079107284545898
(651) DESCRIBE `ports` 0.002938985824585
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00070595741271973
(653) DESCRIBE `ports` 0.0029740333557129
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0006718635559082
(655) DESCRIBE `avid_specials` 0.0027830600738525
(656) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80018 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.0023739337921143
(657) DESCRIBE `cruiselines` 0.0039498805999756
(658) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00086498260498047
(659) DESCRIBE `orchid_image` 0.0032110214233398
(660) DESCRIBE `cruiselines` 0.0044169425964355
(661) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00067782402038574
(662) DESCRIBE `cruises` 0.0053348541259766
(663) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80019') 0.00075483322143555
(664) DESCRIBE `ships` 0.0059828758239746
(665) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0009310245513916
(666) DESCRIBE `ships` 0.0064270496368408
(667) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00071907043457031
(668) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049400329589844
(669) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046014785766602
(670) DESCRIBE `itineraries` 0.0030717849731445
(671) DESCRIBE `ports` 0.003162145614624
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00069499015808105
(673) DESCRIBE `ports` 0.0030100345611572
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00066900253295898
(675) DESCRIBE `ports` 0.003471851348877
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00070714950561523
(677) DESCRIBE `sailingdates` 0.0028409957885742
(678) DESCRIBE `ports` 0.0035099983215332
(679) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00074100494384766
(680) DESCRIBE `ports` 0.0029101371765137
(681) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00068902969360352
(682) DESCRIBE `ports` 0.0032260417938232
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00082707405090332
(684) DESCRIBE `ports` 0.0027749538421631
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00062298774719238
(686) DESCRIBE `ports` 0.0028300285339355
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00072193145751953
(688) DESCRIBE `ports` 0.0029919147491455
(689) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00069594383239746
(690) DESCRIBE `ports` 0.0027649402618408
(691) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.001331090927124
(692) DESCRIBE `ports` 0.0036180019378662
(693) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0011172294616699
(694) DESCRIBE `ports` 0.0033309459686279
(695) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00082993507385254
(696) DESCRIBE `ports` 0.0029070377349854
(697) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00064802169799805
(698) DESCRIBE `ports` 0.0025949478149414
(699) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00069808959960938
(700) DESCRIBE `ports` 0.0027890205383301
(701) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00063705444335938
(702) DESCRIBE `ports` 0.0029349327087402
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00061702728271484
(704) DESCRIBE `ports` 0.0027120113372803
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00059294700622559
(706) DESCRIBE `ports` 0.0033321380615234
(707) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00088286399841309
(708) DESCRIBE `ports` 0.0030899047851562
(709) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00076889991760254
(710) DESCRIBE `ports` 0.0032351016998291
(711) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.0007939338684082
(712) DESCRIBE `ports` 0.003087043762207
(713) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00086498260498047
(714) DESCRIBE `ports` 0.0029458999633789
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 645))) 0.00076389312744141
(716) DESCRIBE `ports` 0.0032670497894287
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '645') 0.00064182281494141
(718) DESCRIBE `ports` 0.0030710697174072
(719) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00067591667175293
(720) DESCRIBE `ports` 0.002877950668335
(721) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00072002410888672
(722) DESCRIBE `ports` 0.0029160976409912
(723) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0008089542388916
(724) DESCRIBE `ports` 0.0032100677490234
(725) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00061702728271484
(726) DESCRIBE `ports` 0.0024690628051758
(727) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.0016000270843506
(728) DESCRIBE `ports` 0.0029318332672119
(729) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00062990188598633
(730) DESCRIBE `ports` 0.0029821395874023
(731) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00071501731872559
(732) DESCRIBE `ports` 0.0030350685119629
(733) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00065398216247559
(734) DESCRIBE `avid_specials` 0.0026130676269531
(735) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80019 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.0021679401397705
(736) DESCRIBE `cruiselines` 0.0039818286895752
(737) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00072598457336426
(738) DESCRIBE `orchid_image` 0.0026988983154297
(739) DESCRIBE `cruiselines` 0.0038409233093262
(740) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00063610076904297
(741) DESCRIBE `ships` 0.0053079128265381
(742) SELECT `ships`.* FROM `ships` WHERE (id IN ('850', '1319', '508', '1108')) ORDER BY FIND_IN_SET(id, '850,1319,508,1108') 0.0014839172363281
(743) DESCRIBE `cruisetypes` 0.0026459693908691
(744) DESCRIBE `cruiselines` 0.0042028427124023
(745) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00084495544433594
(746) DESCRIBE `destinations` 0.0040030479431152
(747) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 26))) 0.0007331371307373
(748) DESCRIBE `destinations` 0.0041120052337646
(749) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 26))) 0.00082302093505859
(750) DESCRIBE `cruiselines` 0.0043940544128418
(751) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00072097778320312