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

Total elapsed time: 0.97185635566711

# Query Time
(1) connect 0.0013308525085449
(2) DESCRIBE `cruises` 0.0053977966308594
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73888, 73886, 73887, 73896, 81179, 83126, 83127, 81180, 81183, 81181)) ORDER BY FIND_IN_SET(id, '73888,73886,73887,73896,81179,83126,83127,81180,81183,81181') 0.0029451847076416
(4) DESCRIBE `cruises` 0.00478196144104
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73888') 0.00054693222045898
(6) DESCRIBE `ships` 0.0048470497131348
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00068521499633789
(8) DESCRIBE `ships` 0.0049118995666504
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00058913230895996
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044417381286621
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043082237243652
(12) DESCRIBE `itineraries` 0.0024480819702148
(13) DESCRIBE `ports` 0.002471923828125
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00058293342590332
(15) DESCRIBE `ports` 0.0024509429931641
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00052404403686523
(17) DESCRIBE `ports` 0.0024430751800537
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00048708915710449
(19) DESCRIBE `sailingdates` 0.0021989345550537
(20) DESCRIBE `ports` 0.0025029182434082
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00054693222045898
(22) DESCRIBE `ports` 0.0023431777954102
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00048708915710449
(24) DESCRIBE `ports` 0.002371072769165
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00055217742919922
(26) DESCRIBE `ports` 0.0023539066314697
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00049209594726562
(28) DESCRIBE `ports` 0.0023319721221924
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00052285194396973
(30) DESCRIBE `ports` 0.0024759769439697
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00048589706420898
(32) DESCRIBE `ports` 0.0023257732391357
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00051498413085938
(34) DESCRIBE `ports` 0.0023820400238037
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.0005040168762207
(36) DESCRIBE `ports` 0.0023667812347412
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00062990188598633
(38) DESCRIBE `ports` 0.0023238658905029
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00052905082702637
(40) DESCRIBE `ports` 0.0023429393768311
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 400))) 0.00055789947509766
(42) DESCRIBE `ports` 0.0023319721221924
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '400') 0.00046205520629883
(44) DESCRIBE `ports` 0.0023598670959473
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 481))) 0.00051212310791016
(46) DESCRIBE `ports` 0.0023870468139648
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '481') 0.00048708915710449
(48) DESCRIBE `ports` 0.0023329257965088
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00051116943359375
(50) DESCRIBE `ports` 0.0023539066314697
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00052404403686523
(52) DESCRIBE `ports` 0.0024111270904541
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00060296058654785
(54) DESCRIBE `ports` 0.0025169849395752
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00054216384887695
(56) DESCRIBE `ports` 0.0023682117462158
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00062394142150879
(58) DESCRIBE `ports` 0.0023422241210938
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00056695938110352
(60) DESCRIBE `avid_specials` 0.0021212100982666
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73888 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 30 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.0035500526428223
(62) DESCRIBE `cruiselines` 0.003525972366333
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00055599212646484
(64) DESCRIBE `orchid_image` 0.0026941299438477
(65) DESCRIBE `cruiselines` 0.0033388137817383
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00051188468933105
(67) DESCRIBE `cruises` 0.0047061443328857
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73886') 0.00055193901062012
(69) DESCRIBE `ships` 0.0048549175262451
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00065088272094727
(71) DESCRIBE `ships` 0.0048880577087402
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00057196617126465
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004730224609375
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053191184997559
(75) DESCRIBE `itineraries` 0.0024421215057373
(76) DESCRIBE `ports` 0.0025720596313477
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00057005882263184
(78) DESCRIBE `ports` 0.0024819374084473
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00052809715270996
(80) DESCRIBE `ports` 0.0025920867919922
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00050783157348633
(82) DESCRIBE `sailingdates` 0.0020678043365479
(83) DESCRIBE `ports` 0.0018908977508545
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00043010711669922
(85) DESCRIBE `ports` 0.0017998218536377
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00053882598876953
(87) DESCRIBE `ports` 0.0022730827331543
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00057291984558105
(89) DESCRIBE `ports` 0.0018229484558105
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00037097930908203
(91) DESCRIBE `ports` 0.0017890930175781
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00040507316589355
(93) DESCRIBE `ports` 0.0021529197692871
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00038909912109375
(95) DESCRIBE `ports` 0.0017800331115723
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 481))) 0.00054001808166504
(97) DESCRIBE `ports` 0.0019221305847168
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '481') 0.0004420280456543
(99) DESCRIBE `ports` 0.0019001960754395
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 400))) 0.00040006637573242
(101) DESCRIBE `ports` 0.0020499229431152
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '400') 0.0003821849822998
(103) DESCRIBE `ports` 0.0024089813232422
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00041604042053223
(105) DESCRIBE `ports` 0.0018429756164551
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00050997734069824
(107) DESCRIBE `ports` 0.0020029544830322
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00050616264343262
(109) DESCRIBE `ports` 0.00177001953125
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00039005279541016
(111) DESCRIBE `ports` 0.001802921295166
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00053882598876953
(113) DESCRIBE `ports` 0.0018818378448486
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00037097930908203
(115) DESCRIBE `ports` 0.0018041133880615
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00045895576477051
(117) DESCRIBE `ports` 0.0018410682678223
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00038814544677734
(119) DESCRIBE `ports` 0.0017650127410889
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00040197372436523
(121) DESCRIBE `ports` 0.0018999576568604
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00036501884460449
(123) DESCRIBE `avid_specials` 0.0015320777893066
(124) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73886 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 30 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.0011680126190186
(125) DESCRIBE `cruiselines` 0.0029659271240234
(126) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00055909156799316
(127) DESCRIBE `orchid_image` 0.0022690296173096
(128) DESCRIBE `cruiselines` 0.0029971599578857
(129) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00051784515380859
(130) DESCRIBE `cruises` 0.0039241313934326
(131) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73887') 0.00050210952758789
(132) DESCRIBE `ships` 0.004382848739624
(133) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00058889389038086
(134) DESCRIBE `ships` 0.0038950443267822
(135) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00055098533630371
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044083595275879
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043702125549316
(138) DESCRIBE `itineraries` 0.002479076385498
(139) DESCRIBE `ports` 0.0020458698272705
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00052499771118164
(141) DESCRIBE `ports` 0.0017778873443604
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00040602684020996
(143) DESCRIBE `ports` 0.0017850399017334
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00049090385437012
(145) DESCRIBE `sailingdates` 0.0021200180053711
(146) DESCRIBE `ports` 0.0024600028991699
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00057506561279297
(148) DESCRIBE `ports` 0.0020101070404053
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00048685073852539
(150) DESCRIBE `ports` 0.002446174621582
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00054001808166504
(152) DESCRIBE `ports` 0.0024120807647705
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00047206878662109
(154) DESCRIBE `ports` 0.0018181800842285
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00039482116699219
(156) DESCRIBE `ports` 0.00189208984375
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00037193298339844
(158) DESCRIBE `ports` 0.0017578601837158
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 481))) 0.00038695335388184
(160) DESCRIBE `ports` 0.0020689964294434
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '481') 0.00052809715270996
(162) DESCRIBE `ports` 0.002601146697998
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 400))) 0.00054001808166504
(164) DESCRIBE `ports` 0.0025398731231689
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '400') 0.00057387351989746
(166) DESCRIBE `ports` 0.0025238990783691
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00066590309143066
(168) DESCRIBE `ports` 0.0025439262390137
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00051093101501465
(170) DESCRIBE `ports` 0.001802921295166
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00038695335388184
(172) DESCRIBE `ports` 0.0018260478973389
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00044083595275879
(174) DESCRIBE `ports` 0.0018129348754883
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00039315223693848
(176) DESCRIBE `ports` 0.0017259120941162
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00045299530029297
(178) DESCRIBE `ports` 0.0022339820861816
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00058698654174805
(180) DESCRIBE `ports` 0.0024738311767578
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00050783157348633
(182) DESCRIBE `ports` 0.0023589134216309
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00052094459533691
(184) DESCRIBE `ports` 0.0017659664154053
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0004570484161377
(186) DESCRIBE `avid_specials` 0.0016930103302002
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73887 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 30 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.0014288425445557
(188) DESCRIBE `cruiselines` 0.0029151439666748
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00050091743469238
(190) DESCRIBE `orchid_image` 0.0021281242370605
(191) DESCRIBE `cruiselines` 0.0032949447631836
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00047111511230469
(193) DESCRIBE `cruises` 0.0042209625244141
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73896') 0.00045394897460938
(195) DESCRIBE `ships` 0.0048120021820068
(196) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00069308280944824
(197) DESCRIBE `ships` 0.0042431354522705
(198) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00049781799316406
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041103363037109
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047588348388672
(201) DESCRIBE `itineraries` 0.0024318695068359
(202) DESCRIBE `ports` 0.0022280216217041
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00046205520629883
(204) DESCRIBE `ports` 0.0018889904022217
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00041890144348145
(206) DESCRIBE `ports` 0.0018830299377441
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0005638599395752
(208) DESCRIBE `sailingdates` 0.0021021366119385
(209) DESCRIBE `ports` 0.0023629665374756
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00059294700622559
(211) DESCRIBE `ports` 0.0023031234741211
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00050091743469238
(213) DESCRIBE `ports` 0.0022261142730713
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00050687789916992
(215) DESCRIBE `ports` 0.0023458003997803
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00049710273742676
(217) DESCRIBE `ports` 0.0029740333557129
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00064778327941895
(219) DESCRIBE `ports` 0.0028219223022461
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.0005950927734375
(221) DESCRIBE `ports` 0.0020480155944824
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00041818618774414
(223) DESCRIBE `ports` 0.0023069381713867
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00041007995605469
(225) DESCRIBE `ports` 0.0022549629211426
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00047516822814941
(227) DESCRIBE `ports` 0.0022737979888916
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00059103965759277
(229) DESCRIBE `ports` 0.0027499198913574
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00054097175598145
(231) DESCRIBE `ports` 0.002208948135376
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00055503845214844
(233) DESCRIBE `ports` 0.0017750263214111
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00041794776916504
(235) DESCRIBE `ports` 0.0019478797912598
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00039100646972656
(237) DESCRIBE `ports` 0.0022530555725098
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00049686431884766
(239) DESCRIBE `ports` 0.0024139881134033
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0005338191986084
(241) DESCRIBE `ports` 0.0021240711212158
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00055408477783203
(243) DESCRIBE `ports` 0.0022790431976318
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0005490779876709
(245) DESCRIBE `avid_specials` 0.002025842666626
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73896 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 45 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.0021779537200928
(247) DESCRIBE `cruiselines` 0.0036690235137939
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00062894821166992
(249) DESCRIBE `orchid_image` 0.0029628276824951
(250) DESCRIBE `cruiselines` 0.0037410259246826
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00070500373840332
(252) DESCRIBE `cruises` 0.0048391819000244
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81179') 0.00075602531433105
(254) DESCRIBE `ships` 0.0067238807678223
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00084209442138672
(256) DESCRIBE `ships` 0.0048139095306396
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00076603889465332
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00059700012207031
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054192543029785
(260) DESCRIBE `itineraries` 0.0026850700378418
(261) DESCRIBE `ports` 0.0031068325042725
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00073695182800293
(263) DESCRIBE `ports` 0.0029580593109131
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00079798698425293
(265) DESCRIBE `ports` 0.0027279853820801
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00065803527832031
(267) DESCRIBE `sailingdates` 0.0021858215332031
(268) DESCRIBE `ports` 0.0026979446411133
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00059103965759277
(270) DESCRIBE `ports` 0.0029170513153076
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00065803527832031
(272) DESCRIBE `ports` 0.0028469562530518
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00065016746520996
(274) DESCRIBE `ports` 0.0025539398193359
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0006871223449707
(276) DESCRIBE `ports` 0.0030019283294678
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00069212913513184
(278) DESCRIBE `ports` 0.0028150081634521
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00056982040405273
(280) DESCRIBE `ports` 0.0027580261230469
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.000701904296875
(282) DESCRIBE `ports` 0.002957820892334
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0007169246673584
(284) DESCRIBE `ports` 0.0031909942626953
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00060486793518066
(286) DESCRIBE `ports` 0.002269983291626
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00050902366638184
(288) DESCRIBE `ports` 0.0024080276489258
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0004880428314209
(290) DESCRIBE `ports` 0.0026400089263916
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00043106079101562
(292) DESCRIBE `ports` 0.0025579929351807
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00070500373840332
(294) DESCRIBE `ports` 0.0026500225067139
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00053501129150391
(296) DESCRIBE `ports` 0.002169132232666
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00048613548278809
(298) DESCRIBE `ports` 0.0025920867919922
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00059294700622559
(300) DESCRIBE `ports` 0.0025770664215088
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00070405006408691
(302) DESCRIBE `ports` 0.002993106842041
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00066590309143066
(304) DESCRIBE `avid_specials` 0.0026679039001465
(305) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81179 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 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.0022099018096924
(306) DESCRIBE `cruiselines` 0.0041680335998535
(307) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00073099136352539
(308) DESCRIBE `orchid_image` 0.0030820369720459
(309) DESCRIBE `cruiselines` 0.0038061141967773
(310) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00057196617126465
(311) DESCRIBE `cruises` 0.0044419765472412
(312) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '83126') 0.00067782402038574
(313) DESCRIBE `ships` 0.0055029392242432
(314) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00084495544433594
(315) DESCRIBE `ships` 0.0053339004516602
(316) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00066399574279785
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052094459533691
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049686431884766
(319) DESCRIBE `itineraries` 0.0024290084838867
(320) DESCRIBE `ports` 0.0018990039825439
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045204162597656
(322) DESCRIBE `ports` 0.0020298957824707
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00046205520629883
(324) DESCRIBE `ports` 0.0020010471343994
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003969669342041
(326) DESCRIBE `sailingdates` 0.0018379688262939
(327) DESCRIBE `ports` 0.0020220279693604
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045895576477051
(329) DESCRIBE `ports` 0.0018858909606934
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0005028247833252
(331) DESCRIBE `ports` 0.002464771270752
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00057196617126465
(333) DESCRIBE `ports` 0.0026628971099854
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00060820579528809
(335) DESCRIBE `ports` 0.0021178722381592
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00055909156799316
(337) DESCRIBE `ports` 0.0025849342346191
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00057506561279297
(339) DESCRIBE `ports` 0.0025680065155029
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00060892105102539
(341) DESCRIBE `ports` 0.0025439262390137
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00053501129150391
(343) DESCRIBE `ports` 0.0023910999298096
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00060009956359863
(345) DESCRIBE `ports` 0.0025689601898193
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00050091743469238
(347) DESCRIBE `ports` 0.0025539398193359
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00055789947509766
(349) DESCRIBE `ports` 0.0026528835296631
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.0005040168762207
(351) DESCRIBE `ports` 0.0025029182434082
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0005180835723877
(353) DESCRIBE `ports` 0.0018250942230225
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0004580020904541
(355) DESCRIBE `avid_specials` 0.0017869472503662
(356) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 83126 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 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.0013258457183838
(357) DESCRIBE `cruiselines` 0.002708911895752
(358) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00046300888061523
(359) DESCRIBE `orchid_image` 0.002683162689209
(360) DESCRIBE `cruiselines` 0.0027549266815186
(361) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00052690505981445
(362) DESCRIBE `cruises` 0.0049159526824951
(363) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '83127') 0.00049805641174316
(364) DESCRIBE `ships` 0.0046648979187012
(365) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00055217742919922
(366) DESCRIBE `ships` 0.00370192527771
(367) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00069904327392578
(368) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053191184997559
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051617622375488
(370) DESCRIBE `itineraries` 0.0027298927307129
(371) DESCRIBE `ports` 0.0026760101318359
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00066494941711426
(373) DESCRIBE `ports` 0.0028378963470459
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00063991546630859
(375) DESCRIBE `ports` 0.0027189254760742
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00060200691223145
(377) DESCRIBE `sailingdates` 0.0024769306182861
(378) DESCRIBE `ports` 0.0027539730072021
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00073599815368652
(380) DESCRIBE `ports` 0.0026447772979736
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00059700012207031
(382) DESCRIBE `ports` 0.0027830600738525
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00060009956359863
(384) DESCRIBE `ports` 0.0026838779449463
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00052881240844727
(386) DESCRIBE `ports` 0.0027239322662354
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00066423416137695
(388) DESCRIBE `ports` 0.0029959678649902
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00068998336791992
(390) DESCRIBE `ports` 0.0029239654541016
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00071406364440918
(392) DESCRIBE `ports` 0.0029129981994629
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00062203407287598
(394) DESCRIBE `ports` 0.0032148361206055
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00072383880615234
(396) DESCRIBE `ports` 0.0028688907623291
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00063705444335938
(398) DESCRIBE `ports` 0.0029199123382568
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00063800811767578
(400) DESCRIBE `ports` 0.0026779174804688
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00068497657775879
(402) DESCRIBE `ports` 0.0027661323547363
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00068998336791992
(404) DESCRIBE `ports` 0.0028297901153564
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00058388710021973
(406) DESCRIBE `ports` 0.0028629302978516
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00065302848815918
(408) DESCRIBE `ports` 0.0027830600738525
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00060701370239258
(410) DESCRIBE `ports` 0.002730131149292
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00076913833618164
(412) DESCRIBE `ports` 0.0028188228607178
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00061583518981934
(414) DESCRIBE `avid_specials` 0.0024750232696533
(415) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 83127 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 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.0022480487823486
(416) DESCRIBE `cruiselines` 0.0039839744567871
(417) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00063681602478027
(418) DESCRIBE `orchid_image` 0.003173828125
(419) DESCRIBE `cruiselines` 0.0039739608764648
(420) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00059986114501953
(421) DESCRIBE `cruises` 0.0045959949493408
(422) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81180') 0.00051093101501465
(423) DESCRIBE `ships` 0.0043020248413086
(424) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.0005791187286377
(425) DESCRIBE `ships` 0.0038690567016602
(426) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00047802925109863
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043296813964844
(428) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(429) DESCRIBE `itineraries` 0.0017738342285156
(430) DESCRIBE `ports` 0.0018429756164551
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044798851013184
(432) DESCRIBE `ports` 0.001878023147583
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041913986206055
(434) DESCRIBE `ports` 0.0020749568939209
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038504600524902
(436) DESCRIBE `sailingdates` 0.0016918182373047
(437) DESCRIBE `ports` 0.0023839473724365
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00051116943359375
(439) DESCRIBE `ports` 0.002187967300415
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00043106079101562
(441) DESCRIBE `ports` 0.0018880367279053
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00046706199645996
(443) DESCRIBE `ports` 0.0021600723266602
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00061798095703125
(445) DESCRIBE `ports` 0.0024378299713135
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00048494338989258
(447) DESCRIBE `ports` 0.0026261806488037
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00052809715270996
(449) DESCRIBE `ports` 0.0018620491027832
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00041699409484863
(451) DESCRIBE `ports` 0.0018229484558105
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00036096572875977
(453) DESCRIBE `ports` 0.0018990039825439
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00043988227844238
(455) DESCRIBE `ports` 0.0017950534820557
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00047111511230469
(457) DESCRIBE `ports` 0.0018877983093262
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0004580020904541
(459) DESCRIBE `ports` 0.0018479824066162
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00044798851013184
(461) DESCRIBE `ports` 0.0020520687103271
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00046706199645996
(463) DESCRIBE `ports` 0.0022101402282715
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00049209594726562
(465) DESCRIBE `ports` 0.0019290447235107
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00051283836364746
(467) DESCRIBE `ports` 0.0018129348754883
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00049805641174316
(469) DESCRIBE `ports` 0.001939058303833
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0007939338684082
(471) DESCRIBE `ports` 0.0029761791229248
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0006709098815918
(473) DESCRIBE `avid_specials` 0.0024600028991699
(474) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81180 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 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.0012838840484619
(475) DESCRIBE `cruiselines` 0.0031490325927734
(476) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00073695182800293
(477) DESCRIBE `orchid_image` 0.0030741691589355
(478) DESCRIBE `cruiselines` 0.0039598941802979
(479) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00057888031005859
(480) DESCRIBE `cruises` 0.0038139820098877
(481) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81183') 0.00043511390686035
(482) DESCRIBE `ships` 0.0050458908081055
(483) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00075411796569824
(484) DESCRIBE `ships` 0.0052170753479004
(485) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.0005648136138916
(486) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049996376037598
(487) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050115585327148
(488) DESCRIBE `itineraries` 0.0018520355224609
(489) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '81183') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010900497436523
(490) DESCRIBE `ports` 0.0027799606323242
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00062108039855957
(492) DESCRIBE `ports` 0.0027070045471191
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00058817863464355
(494) DESCRIBE `ports` 0.0027990341186523
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00057888031005859
(496) DESCRIBE `sailingdates` 0.0023500919342041
(497) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '81183') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011539459228516
(498) DESCRIBE `ports` 0.0019910335540771
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00061917304992676
(500) DESCRIBE `ports` 0.0027050971984863
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00053596496582031
(502) DESCRIBE `ports` 0.0025849342346191
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00042605400085449
(504) DESCRIBE `ports` 0.0018799304962158
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00058388710021973
(506) DESCRIBE `ports` 0.0028190612792969
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00044798851013184
(508) DESCRIBE `ports` 0.0018959045410156
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00046515464782715
(510) DESCRIBE `ports` 0.0019280910491943
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00043320655822754
(512) DESCRIBE `ports` 0.0018951892852783
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00046610832214355
(514) DESCRIBE `ports` 0.0028209686279297
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0006411075592041
(516) DESCRIBE `ports` 0.0027010440826416
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00065112113952637
(518) DESCRIBE `ports` 0.0024409294128418
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00056576728820801
(520) DESCRIBE `ports` 0.0019872188568115
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00055313110351562
(522) DESCRIBE `ports` 0.0026509761810303
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00055599212646484
(524) DESCRIBE `ports` 0.0019381046295166
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00042605400085449
(526) DESCRIBE `ports` 0.0018460750579834
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00041604042053223
(528) DESCRIBE `ports` 0.0018301010131836
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00037407875061035
(530) DESCRIBE `ports` 0.0019230842590332
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041413307189941
(532) DESCRIBE `ports` 0.0018482208251953
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037598609924316
(534) DESCRIBE `avid_specials` 0.0017859935760498
(535) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81183 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 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.0011579990386963
(536) DESCRIBE `cruiselines` 0.0024819374084473
(537) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00049805641174316
(538) DESCRIBE `orchid_image` 0.0019598007202148
(539) DESCRIBE `cruiselines` 0.0024590492248535
(540) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00037598609924316
(541) DESCRIBE `cruises` 0.0035049915313721
(542) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81181') 0.00040817260742188
(543) DESCRIBE `ships` 0.0035660266876221
(544) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.0004889965057373
(545) DESCRIBE `ships` 0.003648042678833
(546) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00046491622924805
(547) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036191940307617
(548) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034809112548828
(549) DESCRIBE `itineraries` 0.0018680095672607
(550) DESCRIBE `ports` 0.0018990039825439
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045299530029297
(552) DESCRIBE `ports` 0.0018050670623779
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040483474731445
(554) DESCRIBE `ports` 0.0019340515136719
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038003921508789
(556) DESCRIBE `sailingdates` 0.0015559196472168
(557) DESCRIBE `ports` 0.0021641254425049
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042605400085449
(559) DESCRIBE `ports` 0.0018000602722168
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039291381835938
(561) DESCRIBE `ports` 0.0018641948699951
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043821334838867
(563) DESCRIBE `ports` 0.0019810199737549
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00045204162597656
(565) DESCRIBE `ports` 0.0017969608306885
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00045990943908691
(567) DESCRIBE `ports` 0.0018010139465332
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00037503242492676
(569) DESCRIBE `ports` 0.0018789768218994
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00043010711669922
(571) DESCRIBE `ports` 0.0018401145935059
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00042605400085449
(573) DESCRIBE `ports` 0.0017518997192383
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00046706199645996
(575) DESCRIBE `ports` 0.0018281936645508
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00037097930908203
(577) DESCRIBE `ports` 0.0021231174468994
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00052523612976074
(579) DESCRIBE `ports` 0.002187967300415
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00039887428283691
(581) DESCRIBE `ports` 0.0019831657409668
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00047802925109863
(583) DESCRIBE `ports` 0.003032922744751
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00042295455932617
(585) DESCRIBE `ports` 0.0017988681793213
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046992301940918
(587) DESCRIBE `ports` 0.0018959045410156
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00043392181396484
(589) DESCRIBE `avid_specials` 0.0015969276428223
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81181 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 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.0011188983917236
(591) DESCRIBE `cruiselines` 0.0026569366455078
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00044488906860352
(593) DESCRIBE `orchid_image` 0.0024769306182861
(594) DESCRIBE `cruiselines` 0.0024580955505371
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.0003809928894043
(596) DESCRIBE `cruisetypes` 0.001741886138916
(597) DESCRIBE `destinations` 0.0025098323822021
(598) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '30', '48', '45')) ORDER BY FIND_IN_SET(id, '22,12,30,48,45') 0.0011398792266846
(599) DESCRIBE `cruiselines` 0.0027060508728027
(600) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00049805641174316
(601) DESCRIBE `ships` 0.0038278102874756
(602) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00051403045654297
(603) DESCRIBE `cruiselines` 0.0026700496673584
(604) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00044107437133789
(605) DESCRIBE `ships` 0.0035209655761719
(606) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00061798095703125