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

Total elapsed time: 1.1315369606018

# Query Time
(1) connect 0.0012290477752686
(2) DESCRIBE `cruises` 0.0046520233154297
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72682, 70988, 67335, 74700, 48376, 72680, 72280, 67376, 67336, 78113)) ORDER BY FIND_IN_SET(id, '72682,70988,67335,74700,48376,72680,72280,67376,67336,78113') 0.0022611618041992
(4) DESCRIBE `cruises` 0.0045390129089355
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72682') 0.00059890747070312
(6) DESCRIBE `ships` 0.0040450096130371
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1474))) 0.00077104568481445
(8) DESCRIBE `ships` 0.0043728351593018
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1474') 0.00063991546630859
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00043082237243652
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00040698051452637
(12) DESCRIBE `itineraries` 0.0024809837341309
(13) DESCRIBE `ports` 0.0025289058685303
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0004880428314209
(15) DESCRIBE `ports` 0.0023400783538818
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00061511993408203
(17) DESCRIBE `ports` 0.0026109218597412
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00056815147399902
(19) DESCRIBE `sailingdates` 0.0022029876708984
(20) DESCRIBE `ports` 0.0018370151519775
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00044608116149902
(22) DESCRIBE `ports` 0.0018019676208496
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00038290023803711
(24) DESCRIBE `ports` 0.0018420219421387
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00042295455932617
(26) DESCRIBE `ports` 0.0017910003662109
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00038599967956543
(28) DESCRIBE `ports` 0.001802921295166
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00059413909912109
(30) DESCRIBE `ports` 0.0023910999298096
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00069212913513184
(32) DESCRIBE `ports` 0.0024070739746094
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.0007328987121582
(34) DESCRIBE `ports` 0.0023081302642822
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00046801567077637
(36) DESCRIBE `ports` 0.0028069019317627
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00049614906311035
(38) DESCRIBE `ports` 0.0019710063934326
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00042986869812012
(40) DESCRIBE `ports` 0.0018701553344727
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00040388107299805
(42) DESCRIBE `ports` 0.0020618438720703
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.0004119873046875
(44) DESCRIBE `ports` 0.0019388198852539
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4763))) 0.00042986869812012
(46) DESCRIBE `ports` 0.0017790794372559
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4763') 0.00047087669372559
(48) DESCRIBE `ports` 0.0019068717956543
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00040888786315918
(50) DESCRIBE `ports` 0.0056700706481934
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00042605400085449
(52) DESCRIBE `ports` 0.0018980503082275
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00046110153198242
(54) DESCRIBE `ports` 0.001917839050293
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00040078163146973
(56) DESCRIBE `ports` 0.0018570423126221
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.0005650520324707
(58) DESCRIBE `ports` 0.0022828578948975
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00045394897460938
(60) DESCRIBE `ports` 0.0018811225891113
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.0004429817199707
(62) DESCRIBE `ports` 0.0019268989562988
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00038409233093262
(64) DESCRIBE `ports` 0.0018949508666992
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00046491622924805
(66) DESCRIBE `ports` 0.0019049644470215
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00058102607727051
(68) DESCRIBE `avid_specials` 0.001723051071167
(69) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72682 and class = 'Cruise') OR (item_id = 1474 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 25 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.0029962062835693
(70) DESCRIBE `cruiselines` 0.0029170513153076
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00045609474182129
(72) DESCRIBE `orchid_image` 0.0025260448455811
(73) DESCRIBE `cruiselines` 0.0032060146331787
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.0010640621185303
(75) DESCRIBE `cruises` 0.0038609504699707
(76) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70988') 0.00044822692871094
(77) DESCRIBE `ships` 0.0034739971160889
(78) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1260))) 0.00051784515380859
(79) DESCRIBE `ships` 0.0035829544067383
(80) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1260') 0.00051999092102051
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036501884460449
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003511905670166
(83) DESCRIBE `itineraries` 0.001802921295166
(84) DESCRIBE `ports` 0.0023849010467529
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00072598457336426
(86) DESCRIBE `ports` 0.0020649433135986
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00072002410888672
(88) DESCRIBE `ports` 0.0029089450836182
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00093984603881836
(90) DESCRIBE `sailingdates` 0.0025830268859863
(91) DESCRIBE `ports` 0.0030698776245117
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00070691108703613
(93) DESCRIBE `ports` 0.0031001567840576
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0007321834564209
(95) DESCRIBE `ports` 0.0030770301818848
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00081610679626465
(97) DESCRIBE `ports` 0.0030858516693115
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0007178783416748
(99) DESCRIBE `ports` 0.0028719902038574
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0007178783416748
(101) DESCRIBE `ports` 0.0026459693908691
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00066590309143066
(103) DESCRIBE `ports` 0.0030038356781006
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2079))) 0.00076198577880859
(105) DESCRIBE `ports` 0.0029690265655518
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2079') 0.00076103210449219
(107) DESCRIBE `ports` 0.0030131340026855
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.00072097778320312
(109) DESCRIBE `ports` 0.0027999877929688
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.00057196617126465
(111) DESCRIBE `ports` 0.0026700496673584
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00065493583679199
(113) DESCRIBE `ports` 0.0029759407043457
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00061416625976562
(115) DESCRIBE `ports` 0.0028800964355469
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00072503089904785
(117) DESCRIBE `ports` 0.0028901100158691
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00062704086303711
(119) DESCRIBE `ports` 0.0029950141906738
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00064587593078613
(121) DESCRIBE `ports` 0.0028719902038574
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00058484077453613
(123) DESCRIBE `ports` 0.0029828548431396
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0006568431854248
(125) DESCRIBE `ports` 0.0028269290924072
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00058579444885254
(127) DESCRIBE `ports` 0.0025680065155029
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00059700012207031
(129) DESCRIBE `ports` 0.0028958320617676
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00059294700622559
(131) DESCRIBE `ports` 0.0029571056365967
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0006561279296875
(133) DESCRIBE `ports` 0.0027461051940918
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00047588348388672
(135) DESCRIBE `ports` 0.0022430419921875
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00050902366638184
(137) DESCRIBE `ports` 0.0019669532775879
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00053787231445312
(139) DESCRIBE `avid_specials` 0.0019290447235107
(140) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70988 and class = 'Cruise') OR (item_id = 1260 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 25 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.0016989707946777
(141) DESCRIBE `cruiselines` 0.0036921501159668
(142) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00070905685424805
(143) DESCRIBE `orchid_image` 0.0030269622802734
(144) DESCRIBE `cruiselines` 0.0038819313049316
(145) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00063300132751465
(146) DESCRIBE `cruises` 0.0047857761383057
(147) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67335') 0.00052905082702637
(148) DESCRIBE `ships` 0.0036940574645996
(149) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492))) 0.00053000450134277
(150) DESCRIBE `ships` 0.0038352012634277
(151) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1492') 0.00046086311340332
(152) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00041413307189941
(153) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00047111511230469
(154) DESCRIBE `itineraries` 0.002687931060791
(155) DESCRIBE `ports` 0.0022268295288086
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047183036804199
(157) DESCRIBE `ports` 0.0023469924926758
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00064206123352051
(159) DESCRIBE `ports` 0.002208948135376
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0005640983581543
(161) DESCRIBE `sailingdates` 0.0025160312652588
(162) DESCRIBE `ports` 0.0023629665374756
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00052595138549805
(164) DESCRIBE `ports` 0.0021748542785645
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00041794776916504
(166) DESCRIBE `ports` 0.0020930767059326
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00043392181396484
(168) DESCRIBE `ports` 0.0022218227386475
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00050497055053711
(170) DESCRIBE `ports` 0.0028438568115234
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00064301490783691
(172) DESCRIBE `ports` 0.0022149085998535
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00041317939758301
(174) DESCRIBE `ports` 0.0019598007202148
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00058984756469727
(176) DESCRIBE `ports` 0.0024299621582031
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00060415267944336
(178) DESCRIBE `ports` 0.0024278163909912
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00042819976806641
(180) DESCRIBE `ports` 0.0021231174468994
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00052690505981445
(182) DESCRIBE `ports` 0.0018150806427002
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00041317939758301
(184) DESCRIBE `ports` 0.0023939609527588
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00049710273742676
(186) DESCRIBE `ports` 0.0023601055145264
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.0005800724029541
(188) DESCRIBE `ports` 0.0021049976348877
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00040316581726074
(190) DESCRIBE `ports` 0.0023210048675537
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3802))) 0.0005030632019043
(192) DESCRIBE `ports` 0.002662181854248
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3802') 0.00037002563476562
(194) DESCRIBE `ports` 0.0024118423461914
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 294))) 0.00043892860412598
(196) DESCRIBE `ports` 0.001990795135498
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '294') 0.00040912628173828
(198) DESCRIBE `ports` 0.0021429061889648
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.0006568431854248
(200) DESCRIBE `ports` 0.0019149780273438
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00047707557678223
(202) DESCRIBE `ports` 0.001878023147583
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00049614906311035
(204) DESCRIBE `ports` 0.0024337768554688
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00045108795166016
(206) DESCRIBE `avid_specials` 0.002241849899292
(207) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67335 and class = 'Cruise') OR (item_id = 1492 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014481544494629
(208) DESCRIBE `cruiselines` 0.0030159950256348
(209) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00063395500183105
(210) DESCRIBE `orchid_image` 0.0027539730072021
(211) DESCRIBE `cruiselines` 0.0030019283294678
(212) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00044798851013184
(213) DESCRIBE `cruises` 0.004490852355957
(214) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74700') 0.00059080123901367
(215) DESCRIBE `ships` 0.0038039684295654
(216) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1704))) 0.00054597854614258
(217) DESCRIBE `ships` 0.0040218830108643
(218) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1704') 0.00048995018005371
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036501884460449
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034713745117188
(221) DESCRIBE `itineraries` 0.001823902130127
(222) DESCRIBE `ports` 0.0025689601898193
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00059199333190918
(224) DESCRIBE `ports` 0.0019640922546387
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00040292739868164
(226) DESCRIBE `ports` 0.002418041229248
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00055384635925293
(228) DESCRIBE `sailingdates` 0.0017440319061279
(229) DESCRIBE `ports` 0.0021040439605713
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00049114227294922
(231) DESCRIBE `ports` 0.0019690990447998
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00039815902709961
(233) DESCRIBE `ports` 0.001910924911499
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00043797492980957
(235) DESCRIBE `ports` 0.0018570423126221
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00038313865661621
(237) DESCRIBE `ports` 0.0019161701202393
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.0004880428314209
(239) DESCRIBE `ports` 0.0027740001678467
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00057601928710938
(241) DESCRIBE `ports` 0.0025601387023926
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00064611434936523
(243) DESCRIBE `ports` 0.0023801326751709
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00046205520629883
(245) DESCRIBE `ports` 0.0026381015777588
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) 0.00046300888061523
(247) DESCRIBE `ports` 0.0018858909606934
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') 0.00039005279541016
(249) DESCRIBE `ports` 0.0020248889923096
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00040793418884277
(251) DESCRIBE `ports` 0.0018517971038818
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00038695335388184
(253) DESCRIBE `ports` 0.0018138885498047
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00042200088500977
(255) DESCRIBE `ports` 0.0018501281738281
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00046014785766602
(257) DESCRIBE `ports` 0.0020549297332764
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2361))) 0.00040888786315918
(259) DESCRIBE `ports` 0.0018181800842285
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2361') 0.0003960132598877
(261) DESCRIBE `ports` 0.0021939277648926
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00042414665222168
(263) DESCRIBE `ports` 0.0019941329956055
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00045490264892578
(265) DESCRIBE `ports` 0.002039909362793
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00040507316589355
(267) DESCRIBE `ports` 0.0024681091308594
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00048613548278809
(269) DESCRIBE `ports` 0.0024120807647705
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00057005882263184
(271) DESCRIBE `ports` 0.002155065536499
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00050520896911621
(273) DESCRIBE `ports` 0.002957820892334
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00057101249694824
(275) DESCRIBE `ports` 0.0021190643310547
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00040292739868164
(277) DESCRIBE `ports` 0.0018270015716553
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00042295455932617
(279) DESCRIBE `ports` 0.0020298957824707
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00041007995605469
(281) DESCRIBE `ports` 0.0019259452819824
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00051784515380859
(283) DESCRIBE `ports` 0.0025110244750977
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00054597854614258
(285) DESCRIBE `avid_specials` 0.0024969577789307
(286) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74700 and class = 'Cruise') OR (item_id = 1704 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 21 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.0024020671844482
(287) DESCRIBE `cruiselines` 0.0037240982055664
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00068497657775879
(289) DESCRIBE `orchid_image` 0.0029520988464355
(290) DESCRIBE `cruiselines` 0.0036680698394775
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00057601928710938
(292) DESCRIBE `cruises` 0.0051419734954834
(293) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48376') 0.00058293342590332
(294) DESCRIBE `ships` 0.0050418376922607
(295) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1208))) 0.00069689750671387
(296) DESCRIBE `ships` 0.0050928592681885
(297) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1208') 0.00058484077453613
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00049304962158203
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00047183036804199
(300) DESCRIBE `itineraries` 0.0025138854980469
(301) DESCRIBE `ports` 0.0026421546936035
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00066184997558594
(303) DESCRIBE `ports` 0.0026779174804688
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0006110668182373
(305) DESCRIBE `ports` 0.0027198791503906
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00052213668823242
(307) DESCRIBE `sailingdates` 0.0023238658905029
(308) DESCRIBE `ports` 0.0027461051940918
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00061607360839844
(310) DESCRIBE `ports` 0.0027329921722412
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00058603286743164
(312) DESCRIBE `ports` 0.0025861263275146
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.0006110668182373
(314) DESCRIBE `ports` 0.0026509761810303
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00054001808166504
(316) DESCRIBE `ports` 0.0026609897613525
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00060009956359863
(318) DESCRIBE `ports` 0.003079891204834
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.0006561279296875
(320) DESCRIBE `ports` 0.0022339820861816
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00044989585876465
(322) DESCRIBE `ports` 0.0020580291748047
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00039815902709961
(324) DESCRIBE `ports` 0.0018329620361328
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00050497055053711
(326) DESCRIBE `ports` 0.0018458366394043
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00044894218444824
(328) DESCRIBE `ports` 0.001945972442627
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00051093101501465
(330) DESCRIBE `ports` 0.0019969940185547
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00040602684020996
(332) DESCRIBE `ports` 0.0017991065979004
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00044989585876465
(334) DESCRIBE `ports` 0.0019690990447998
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00055909156799316
(336) DESCRIBE `ports` 0.0020639896392822
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00045895576477051
(338) DESCRIBE `ports` 0.0019478797912598
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00039100646972656
(340) DESCRIBE `ports` 0.0027110576629639
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00050091743469238
(342) DESCRIBE `ports` 0.0019710063934326
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00043392181396484
(344) DESCRIBE `ports` 0.0020630359649658
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00046300888061523
(346) DESCRIBE `ports` 0.0019400119781494
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00051498413085938
(348) DESCRIBE `avid_specials` 0.0017099380493164
(349) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 48376 and class = 'Cruise') OR (item_id = 1208 AND class = 'Ship') OR (item_id = 262 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.0015230178833008
(350) DESCRIBE `cruiselines` 0.0028419494628906
(351) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00058197975158691
(352) DESCRIBE `orchid_image` 0.0022261142730713
(353) DESCRIBE `cruiselines` 0.0037031173706055
(354) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.0006721019744873
(355) DESCRIBE `cruises` 0.0046250820159912
(356) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72680') 0.00052690505981445
(357) DESCRIBE `ships` 0.003777027130127
(358) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1259))) 0.00064587593078613
(359) DESCRIBE `ships` 0.003593921661377
(360) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1259') 0.00047898292541504
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036501884460449
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035214424133301
(363) DESCRIBE `itineraries` 0.0023360252380371
(364) DESCRIBE `ports` 0.0020389556884766
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00061297416687012
(366) DESCRIBE `ports` 0.0018649101257324
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00043797492980957
(368) DESCRIBE `ports` 0.0024220943450928
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00045204162597656
(370) DESCRIBE `sailingdates` 0.0018279552459717
(371) DESCRIBE `ports` 0.0018858909606934
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00046896934509277
(373) DESCRIBE `ports` 0.0018119812011719
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00046515464782715
(375) DESCRIBE `ports` 0.0018579959869385
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00048303604125977
(377) DESCRIBE `ports` 0.0021770000457764
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00042414665222168
(379) DESCRIBE `ports` 0.0021059513092041
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.0004429817199707
(381) DESCRIBE `ports` 0.0019629001617432
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00041580200195312
(383) DESCRIBE `ports` 0.0018219947814941
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00044012069702148
(385) DESCRIBE `ports` 0.0018250942230225
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00040221214294434
(387) DESCRIBE `ports` 0.0018908977508545
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) 0.00041890144348145
(389) DESCRIBE `ports` 0.0020740032196045
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') 0.00038909912109375
(391) DESCRIBE `ports` 0.0019419193267822
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.0004270076751709
(393) DESCRIBE `ports` 0.002112865447998
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.0003819465637207
(395) DESCRIBE `ports` 0.0018579959869385
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00044012069702148
(397) DESCRIBE `ports` 0.0020029544830322
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00038504600524902
(399) DESCRIBE `ports` 0.0019381046295166
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2361))) 0.00041985511779785
(401) DESCRIBE `ports` 0.0017859935760498
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2361') 0.00038290023803711
(403) DESCRIBE `ports` 0.0018908977508545
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00053620338439941
(405) DESCRIBE `ports` 0.0019629001617432
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00039291381835938
(407) DESCRIBE `ports` 0.0020010471343994
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00041294097900391
(409) DESCRIBE `ports` 0.0019030570983887
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00037717819213867
(411) DESCRIBE `ports` 0.0020351409912109
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00045108795166016
(413) DESCRIBE `ports` 0.0025629997253418
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00059199333190918
(415) DESCRIBE `ports` 0.0020420551300049
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.0004580020904541
(417) DESCRIBE `ports` 0.0021979808807373
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00048494338989258
(419) DESCRIBE `ports` 0.0023078918457031
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00061798095703125
(421) DESCRIBE `ports` 0.0018351078033447
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00041007995605469
(423) DESCRIBE `ports` 0.0020308494567871
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00043416023254395
(425) DESCRIBE `ports` 0.0019919872283936
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0003960132598877
(427) DESCRIBE `avid_specials` 0.0018799304962158
(428) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72680 and class = 'Cruise') OR (item_id = 1259 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 21 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.0018370151519775
(429) DESCRIBE `cruiselines` 0.0037939548492432
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00069403648376465
(431) DESCRIBE `orchid_image` 0.0022621154785156
(432) DESCRIBE `cruiselines` 0.0027329921722412
(433) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00051593780517578
(434) DESCRIBE `cruises` 0.0040559768676758
(435) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72280') 0.00049018859863281
(436) DESCRIBE `ships` 0.0040910243988037
(437) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1260))) 0.00060081481933594
(438) DESCRIBE `ships` 0.0037200450897217
(439) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1260') 0.00049304962158203
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00037193298339844
(441) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035309791564941
(442) DESCRIBE `itineraries` 0.0019240379333496
(443) DESCRIBE `ports` 0.0020389556884766
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00046896934509277
(445) DESCRIBE `ports` 0.0018651485443115
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00041604042053223
(447) DESCRIBE `ports` 0.0019350051879883
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00040388107299805
(449) DESCRIBE `sailingdates` 0.0015971660614014
(450) DESCRIBE `ports` 0.0019199848175049
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0006101131439209
(452) DESCRIBE `ports` 0.0020129680633545
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00044107437133789
(454) DESCRIBE `ports` 0.0019760131835938
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00042891502380371
(456) DESCRIBE `ports` 0.0022530555725098
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00040912628173828
(458) DESCRIBE `ports` 0.0021560192108154
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00075793266296387
(460) DESCRIBE `ports` 0.0022320747375488
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00040698051452637
(462) DESCRIBE `ports` 0.0018489360809326
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00045394897460938
(464) DESCRIBE `ports` 0.0020809173583984
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00048112869262695
(466) DESCRIBE `ports` 0.0018219947814941
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00042486190795898
(468) DESCRIBE `ports` 0.001884937286377
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00041890144348145
(470) DESCRIBE `ports` 0.0018179416656494
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00050806999206543
(472) DESCRIBE `ports` 0.002147912979126
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00037503242492676
(474) DESCRIBE `ports` 0.0019059181213379
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00046491622924805
(476) DESCRIBE `ports` 0.0019590854644775
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00041604042053223
(478) DESCRIBE `ports` 0.0020179748535156
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00041890144348145
(480) DESCRIBE `ports` 0.0019161701202393
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00049090385437012
(482) DESCRIBE `ports` 0.0021469593048096
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00046992301940918
(484) DESCRIBE `ports` 0.0020790100097656
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.0003809928894043
(486) DESCRIBE `ports` 0.0020389556884766
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00041890144348145
(488) DESCRIBE `ports` 0.0019931793212891
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00042104721069336
(490) DESCRIBE `ports` 0.002161979675293
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00051689147949219
(492) DESCRIBE `ports` 0.0018360614776611
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.0004580020904541
(494) DESCRIBE `avid_specials` 0.0015668869018555
(495) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72280 and class = 'Cruise') OR (item_id = 1260 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 49 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012600421905518
(496) DESCRIBE `cruiselines` 0.0025670528411865
(497) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00045394897460938
(498) DESCRIBE `orchid_image` 0.0021438598632812
(499) DESCRIBE `cruiselines` 0.0031280517578125
(500) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00051188468933105
(501) DESCRIBE `cruises` 0.0037479400634766
(502) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67376') 0.00047087669372559
(503) DESCRIBE `ships` 0.0035641193389893
(504) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1474))) 0.00072717666625977
(505) DESCRIBE `ships` 0.0039980411529541
(506) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1474') 0.00044584274291992
(507) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003669261932373
(508) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00038886070251465
(509) DESCRIBE `itineraries` 0.0019509792327881
(510) DESCRIBE `ports` 0.0019240379333496
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00056886672973633
(512) DESCRIBE `ports` 0.0018880367279053
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00039792060852051
(514) DESCRIBE `ports` 0.0022039413452148
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00048708915710449
(516) DESCRIBE `sailingdates` 0.0021088123321533
(517) DESCRIBE `ports` 0.0023341178894043
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00046610832214355
(519) DESCRIBE `ports` 0.0018470287322998
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00041890144348145
(521) DESCRIBE `ports` 0.0020320415496826
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.0004429817199707
(523) DESCRIBE `ports` 0.0020301342010498
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00061678886413574
(525) DESCRIBE `ports` 0.0021438598632812
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.00050783157348633
(527) DESCRIBE `ports` 0.001971960067749
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00039100646972656
(529) DESCRIBE `ports` 0.0018022060394287
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00043082237243652
(531) DESCRIBE `ports` 0.0018880367279053
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00043201446533203
(533) DESCRIBE `ports` 0.0018930435180664
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) 0.00042104721069336
(535) DESCRIBE `ports` 0.0019361972808838
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') 0.00050210952758789
(537) DESCRIBE `ports` 0.0021431446075439
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) 0.00045013427734375
(539) DESCRIBE `ports` 0.0021529197692871
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') 0.00064206123352051
(541) DESCRIBE `ports` 0.0018417835235596
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00051403045654297
(543) DESCRIBE `ports` 0.0020928382873535
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00040102005004883
(545) DESCRIBE `ports` 0.0018310546875
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2361))) 0.00045490264892578
(547) DESCRIBE `ports` 0.0021429061889648
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2361') 0.00042891502380371
(549) DESCRIBE `ports` 0.002100944519043
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00044393539428711
(551) DESCRIBE `ports` 0.0018939971923828
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00039291381835938
(553) DESCRIBE `ports` 0.0017969608306885
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00044918060302734
(555) DESCRIBE `ports` 0.0019412040710449
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00038695335388184
(557) DESCRIBE `ports` 0.0025320053100586
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00062894821166992
(559) DESCRIBE `ports` 0.0026688575744629
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00061297416687012
(561) DESCRIBE `ports` 0.0028479099273682
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00063681602478027
(563) DESCRIBE `ports` 0.0028610229492188
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00062012672424316
(565) DESCRIBE `ports` 0.00276780128479
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0006411075592041
(567) DESCRIBE `ports` 0.002816915512085
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00060009956359863
(569) DESCRIBE `ports` 0.0028262138366699
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00073790550231934
(571) DESCRIBE `ports` 0.0026259422302246
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00041604042053223
(573) DESCRIBE `avid_specials` 0.0017039775848389
(574) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67376 and class = 'Cruise') OR (item_id = 1474 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 21 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.0013670921325684
(575) DESCRIBE `cruiselines` 0.0026040077209473
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00046491622924805
(577) DESCRIBE `orchid_image` 0.002000093460083
(578) DESCRIBE `cruiselines` 0.0027420520782471
(579) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00043392181396484
(580) DESCRIBE `cruises` 0.0038139820098877
(581) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67336') 0.0004429817199707
(582) DESCRIBE `ships` 0.0035269260406494
(583) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492))) 0.00053787231445312
(584) DESCRIBE `ships` 0.0042600631713867
(585) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1492') 0.00073695182800293
(586) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00050210952758789
(587) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00065183639526367
(588) DESCRIBE `itineraries` 0.0024039745330811
(589) DESCRIBE `ports` 0.0019159317016602
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00044798851013184
(591) DESCRIBE `ports` 0.0019071102142334
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00041604042053223
(593) DESCRIBE `ports` 0.0020449161529541
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00048303604125977
(595) DESCRIBE `sailingdates` 0.0017490386962891
(596) DESCRIBE `ports` 0.0019488334655762
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00044488906860352
(598) DESCRIBE `ports` 0.0019838809967041
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00038290023803711
(600) DESCRIBE `ports` 0.0019149780273438
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00050592422485352
(602) DESCRIBE `ports` 0.001939058303833
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.0004889965057373
(604) DESCRIBE `ports` 0.0019071102142334
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 294))) 0.00042486190795898
(606) DESCRIBE `ports` 0.0018899440765381
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '294') 0.00046300888061523
(608) DESCRIBE `ports` 0.0019350051879883
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3802))) 0.00038695335388184
(610) DESCRIBE `ports` 0.0019609928131104
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3802') 0.00037002563476562
(612) DESCRIBE `ports` 0.0020308494567871
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00053286552429199
(614) DESCRIBE `ports` 0.0018570423126221
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00041794776916504
(616) DESCRIBE `ports` 0.0018939971923828
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00041508674621582
(618) DESCRIBE `ports` 0.0019478797912598
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00039410591125488
(620) DESCRIBE `ports` 0.0018999576568604
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0004420280456543
(622) DESCRIBE `ports` 0.0023269653320312
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00041794776916504
(624) DESCRIBE `ports` 0.0018329620361328
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00046992301940918
(626) DESCRIBE `ports` 0.001924991607666
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00038409233093262
(628) DESCRIBE `ports` 0.0019330978393555
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00046300888061523
(630) DESCRIBE `ports` 0.0019731521606445
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00037479400634766
(632) DESCRIBE `ports` 0.0019450187683105
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00045990943908691
(634) DESCRIBE `ports` 0.0018839836120605
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00046396255493164
(636) DESCRIBE `ports` 0.0017769336700439
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5201))) 0.00046396255493164
(638) DESCRIBE `ports` 0.0020010471343994
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5201') 0.00047206878662109
(640) DESCRIBE `avid_specials` 0.0018999576568604
(641) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67336 and class = 'Cruise') OR (item_id = 1492 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011858940124512
(642) DESCRIBE `cruiselines` 0.00301194190979
(643) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00057506561279297
(644) DESCRIBE `orchid_image` 0.0021259784698486
(645) DESCRIBE `cruiselines` 0.0026528835296631
(646) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00039911270141602
(647) DESCRIBE `cruises` 0.0036709308624268
(648) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78113') 0.00041413307189941
(649) DESCRIBE `ships` 0.0035109519958496
(650) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1208))) 0.00049901008605957
(651) DESCRIBE `ships` 0.0035469532012939
(652) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1208') 0.00040602684020996
(653) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035977363586426
(654) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034904479980469
(655) DESCRIBE `itineraries` 0.0024449825286865
(656) DESCRIBE `ports` 0.0021469593048096
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00067496299743652
(658) DESCRIBE `ports` 0.0019960403442383
(659) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0004570484161377
(660) DESCRIBE `ports` 0.0021228790283203
(661) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042390823364258
(662) DESCRIBE `sailingdates` 0.0018560886383057
(663) DESCRIBE `ports` 0.0020151138305664
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00060081481933594
(665) DESCRIBE `ports` 0.0019040107727051
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00038981437683105
(667) DESCRIBE `ports` 0.0019359588623047
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00045585632324219
(669) DESCRIBE `ports` 0.0019669532775879
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00039792060852051
(671) DESCRIBE `ports` 0.0019040107727051
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00043416023254395
(673) DESCRIBE `ports` 0.0021660327911377
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00037980079650879
(675) DESCRIBE `ports` 0.0018720626831055
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00041794776916504
(677) DESCRIBE `ports` 0.0017950534820557
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00039815902709961
(679) DESCRIBE `ports` 0.0018401145935059
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00042104721069336
(681) DESCRIBE `ports` 0.0018680095672607
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00040912628173828
(683) DESCRIBE `ports` 0.0021500587463379
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00049209594726562
(685) DESCRIBE `ports` 0.0018680095672607
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.0004889965057373
(687) DESCRIBE `ports` 0.0018460750579834
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041794776916504
(689) DESCRIBE `ports` 0.0017850399017334
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038599967956543
(691) DESCRIBE `ports` 0.0019359588623047
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048184394836426
(693) DESCRIBE `ports` 0.0024099349975586
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038886070251465
(695) DESCRIBE `ports` 0.0024259090423584
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00056910514831543
(697) DESCRIBE `ports` 0.0025031566619873
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0004270076751709
(699) DESCRIBE `ports` 0.0017740726470947
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00041294097900391
(701) DESCRIBE `ports` 0.0018877983093262
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.00046801567077637
(703) DESCRIBE `ports` 0.0018210411071777
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00043511390686035
(705) DESCRIBE `ports` 0.0019221305847168
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00048518180847168
(707) DESCRIBE `ports` 0.0019149780273438
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3293))) 0.00045418739318848
(709) DESCRIBE `ports` 0.0019099712371826
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3293') 0.00039196014404297
(711) DESCRIBE `ports` 0.0019321441650391
(712) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00049591064453125
(713) DESCRIBE `ports` 0.0021741390228271
(714) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00038313865661621
(715) DESCRIBE `ports` 0.0024988651275635
(716) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00058317184448242
(717) DESCRIBE `ports` 0.0023369789123535
(718) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00046491622924805
(719) DESCRIBE `ports` 0.002288818359375
(720) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042200088500977
(721) DESCRIBE `ports` 0.0018100738525391
(722) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039505958557129
(723) DESCRIBE `ports` 0.0020740032196045
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00054001808166504
(725) DESCRIBE `ports` 0.0017769336700439
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00039911270141602
(727) DESCRIBE `ports` 0.0020151138305664
(728) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00040984153747559
(729) DESCRIBE `ports` 0.0019888877868652
(730) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00037717819213867
(731) DESCRIBE `ports` 0.0017940998077393
(732) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0004119873046875
(733) DESCRIBE `ports` 0.0017819404602051
(734) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00075411796569824
(735) DESCRIBE `ports` 0.0029559135437012
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00068306922912598
(737) DESCRIBE `ports` 0.002086877822876
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00040411949157715
(739) DESCRIBE `ports` 0.0020790100097656
(740) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00043916702270508
(741) DESCRIBE `ports` 0.0018441677093506
(742) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.0005040168762207
(743) DESCRIBE `ports` 0.001971960067749
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043797492980957
(745) DESCRIBE `ports` 0.0020902156829834
(746) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00038814544677734
(747) DESCRIBE `ports` 0.0019428730010986
(748) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043010711669922
(749) DESCRIBE `ports` 0.0020570755004883
(750) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043702125549316
(751) DESCRIBE `avid_specials` 0.001716136932373
(752) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78113 and class = 'Cruise') OR (item_id = 1208 AND class = 'Ship') OR (item_id = 262 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.0014081001281738
(753) DESCRIBE `cruiselines` 0.0032708644866943
(754) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00052380561828613
(755) DESCRIBE `orchid_image` 0.0023469924926758
(756) DESCRIBE `cruiselines` 0.0031499862670898
(757) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00065898895263672
(758) DESCRIBE `ships` 0.0040621757507324
(759) SELECT `ships`.* FROM `ships` WHERE (id IN ('1260', '1259', '1208', '1492', '1704', '1474')) ORDER BY FIND_IN_SET(id, '1260,1259,1208,1492,1704,1474') 0.0015780925750732
(760) DESCRIBE `cruisetypes` 0.0021510124206543
(761) DESCRIBE `destinations` 0.003277063369751
(762) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '26', '35', '25', '2', '37', '38', '12', '40', '43', '49', '21', '28', '8', '11', '48')) ORDER BY FIND_IN_SET(id, '22,26,35,25,2,37,38,12,40,43,49,21,28,8,11,48') 0.0020771026611328
(763) DESCRIBE `cruiselines` 0.003615140914917
(764) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00064206123352051
(765) DESCRIBE `cruiselines` 0.0035648345947266
(766) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00069212913513184