or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 1.0293188095093

# Query Time
(1) connect 0.00099420547485352
(2) DESCRIBE `cruises` 0.0038318634033203
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45260, 45259, 71399, 71400, 11517, 67266, 67378, 67915, 72728, 79178)) ORDER BY FIND_IN_SET(id, '45260,45259,71399,71400,11517,67266,67378,67915,72728,79178') 0.0023131370544434
(4) DESCRIBE `specials` 0.0061230659484863
(5) DESCRIBE `specials` 0.0056190490722656
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1550256') 0.00048208236694336
(7) DESCRIBE `ships` 0.003957986831665
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00084209442138672
(9) DESCRIBE `ships` 0.004021167755127
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00047993659973145
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00038695335388184
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028395652770996
(13) DESCRIBE `itineraries` 0.0020599365234375
(14) DESCRIBE `ports` 0.002155065536499
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004889965057373
(16) DESCRIBE `ports` 0.0023949146270752
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0005500316619873
(18) DESCRIBE `ports` 0.0018389225006104
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041007995605469
(20) DESCRIBE `specialsailingdates` 0.0015401840209961
(21) DESCRIBE `sailingdates` 0.0016639232635498
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504230))) 0.00059199333190918
(23) DESCRIBE `sailingdates` 0.001568078994751
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504231))) 0.00043892860412598
(25) DESCRIBE `sailingdates` 0.0017440319061279
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504230))) 0.00041699409484863
(27) DESCRIBE `sailingdates` 0.0014128684997559
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504236))) 0.00037407875061035
(29) DESCRIBE `sailingdates` 0.0015809535980225
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504237))) 0.00040698051452637
(31) DESCRIBE `sailingdates` 0.0015051364898682
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504240))) 0.0002598762512207
(33) DESCRIBE `sailingdates` 0.00154709815979
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504241))) 0.0004420280456543
(35) DESCRIBE `sailingdates` 0.0015289783477783
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504242))) 0.0003199577331543
(37) DESCRIBE `sailingdates` 0.0016369819641113
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504243))) 0.00041604042053223
(39) DESCRIBE `sailingdates` 0.0016779899597168
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504244))) 0.00045204162597656
(41) DESCRIBE `sailingdates` 0.0016958713531494
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504246))) 0.0005030632019043
(43) DESCRIBE `sailingdates` 0.0016019344329834
(44) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504250))) 0.00041604042053223
(45) DESCRIBE `sailingdates` 0.0014278888702393
(46) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504251))) 0.00059700012207031
(47) DESCRIBE `sailingdates` 0.0015630722045898
(48) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504252))) 0.00032401084899902
(49) DESCRIBE `sailingdates` 0.001384973526001
(50) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504253))) 0.00038003921508789
(51) DESCRIBE `sailingdates` 0.001539945602417
(52) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504255))) 0.00044512748718262
(53) DESCRIBE `sailingdates` 0.0015499591827393
(54) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504256))) 0.00042104721069336
(55) DESCRIBE `ports` 0.0018589496612549
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00071907043457031
(57) DESCRIBE `ports` 0.0020759105682373
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00039911270141602
(59) DESCRIBE `ports` 0.0016260147094727
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00037097930908203
(61) DESCRIBE `ports` 0.0016241073608398
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00037813186645508
(63) DESCRIBE `ports` 0.0018908977508545
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044798851013184
(65) DESCRIBE `ports` 0.001594066619873
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00043892860412598
(67) DESCRIBE `ports` 0.0018341541290283
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0004279613494873
(69) DESCRIBE `ports` 0.0017590522766113
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038313865661621
(71) DESCRIBE `ports` 0.0017969608306885
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00042915344238281
(73) DESCRIBE `ports` 0.0022580623626709
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00041890144348145
(75) DESCRIBE `ports` 0.0019810199737549
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00052595138549805
(77) DESCRIBE `ports` 0.0023050308227539
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00048398971557617
(79) DESCRIBE `cruises` 0.0041038990020752
(80) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45260))) 0.00061607360839844
(81) DESCRIBE `avid_specials` 0.0018649101257324
(82) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1550256 and class = 'Special') OR (item_id = 45260 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 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.0013949871063232
(83) DESCRIBE `cruiselines` 0.0027849674224854
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00049996376037598
(85) DESCRIBE `orchid_image` 0.0021660327911377
(86) DESCRIBE `cruiselines` 0.0028049945831299
(87) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00042510032653809
(88) DESCRIBE `specials` 0.0073139667510986
(89) DESCRIBE `specials` 0.0074470043182373
(90) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1550505') 0.00058603286743164
(91) DESCRIBE `ships` 0.0049300193786621
(92) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00067901611328125
(93) DESCRIBE `ships` 0.0045089721679688
(94) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.0005648136138916
(95) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033807754516602
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00061321258544922
(97) DESCRIBE `itineraries` 0.0018980503082275
(98) DESCRIBE `ports` 0.0017609596252441
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004429817199707
(100) DESCRIBE `ports` 0.0018360614776611
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00047802925109863
(102) DESCRIBE `ports` 0.0019829273223877
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00043916702270508
(104) DESCRIBE `specialsailingdates` 0.0016441345214844
(105) DESCRIBE `sailingdates` 0.0019028186798096
(106) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504315))) 0.0004580020904541
(107) DESCRIBE `sailingdates` 0.0017080307006836
(108) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504316))) 0.0004429817199707
(109) DESCRIBE `sailingdates` 0.0018658638000488
(110) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504315))) 0.00032401084899902
(111) DESCRIBE `sailingdates` 0.0019979476928711
(112) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504319))) 0.00062990188598633
(113) DESCRIBE `sailingdates` 0.0017659664154053
(114) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504320))) 0.00050902366638184
(115) DESCRIBE `sailingdates` 0.0017309188842773
(116) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504324))) 0.00046801567077637
(117) DESCRIBE `sailingdates` 0.0017049312591553
(118) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504328))) 0.00046205520629883
(119) DESCRIBE `sailingdates` 0.0016920566558838
(120) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504331))) 0.00045394897460938
(121) DESCRIBE `sailingdates` 0.0017800331115723
(122) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504334))) 0.00047707557678223
(123) DESCRIBE `sailingdates` 0.0018711090087891
(124) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504335))) 0.00049209594726562
(125) DESCRIBE `sailingdates` 0.0014679431915283
(126) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504336))) 0.00031614303588867
(127) DESCRIBE `sailingdates` 0.001262903213501
(128) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504337))) 0.00038790702819824
(129) DESCRIBE `sailingdates` 0.0012919902801514
(130) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504338))) 0.00052285194396973
(131) DESCRIBE `ports` 0.002190113067627
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00051999092102051
(133) DESCRIBE `ports` 0.0020289421081543
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00042891502380371
(135) DESCRIBE `ports` 0.0019009113311768
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00044703483581543
(137) DESCRIBE `ports` 0.0020818710327148
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00041580200195312
(139) DESCRIBE `ports` 0.0018560886383057
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044107437133789
(141) DESCRIBE `ports` 0.0018529891967773
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00042104721069336
(143) DESCRIBE `ports` 0.0017130374908447
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00042319297790527
(145) DESCRIBE `ports` 0.001704216003418
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00038290023803711
(147) DESCRIBE `ports` 0.0016570091247559
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00040197372436523
(149) DESCRIBE `ports` 0.0016579627990723
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038003921508789
(151) DESCRIBE `ports` 0.0017218589782715
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045418739318848
(153) DESCRIBE `ports` 0.0019500255584717
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041103363037109
(155) DESCRIBE `cruises` 0.0040018558502197
(156) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.0011599063873291
(157) DESCRIBE `avid_specials` 0.002112865447998
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1550505 and class = 'Special') OR (item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 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.0021159648895264
(159) DESCRIBE `cruiselines` 0.0037209987640381
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00055813789367676
(161) DESCRIBE `orchid_image` 0.0018517971038818
(162) DESCRIBE `cruiselines` 0.0023021697998047
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00037217140197754
(164) DESCRIBE `specials` 0.0046899318695068
(165) DESCRIBE `specials` 0.0060420036315918
(166) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541086') 0.0006098747253418
(167) DESCRIBE `ships` 0.0049989223480225
(168) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.0029299259185791
(169) DESCRIBE `ships` 0.0052430629730225
(170) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00065398216247559
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034618377685547
(172) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00026702880859375
(173) DESCRIBE `itineraries` 0.0021510124206543
(174) DESCRIBE `ports` 0.0024459362030029
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00068998336791992
(176) DESCRIBE `ports` 0.0022480487823486
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00063395500183105
(178) DESCRIBE `ports` 0.0023791790008545
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00052309036254883
(180) DESCRIBE `specialsailingdates` 0.0016279220581055
(181) DESCRIBE `sailingdates` 0.0020229816436768
(182) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453273))) 0.0005800724029541
(183) DESCRIBE `ports` 0.0032861232757568
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00049209594726562
(185) DESCRIBE `ports` 0.0020561218261719
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00043106079101562
(187) DESCRIBE `ports` 0.002108097076416
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00049996376037598
(189) DESCRIBE `ports` 0.0023159980773926
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00049400329589844
(191) DESCRIBE `ports` 0.0025010108947754
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0010089874267578
(193) DESCRIBE `ports` 0.0024039745330811
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0006110668182373
(195) DESCRIBE `ports` 0.0021190643310547
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00053000450134277
(197) DESCRIBE `ports` 0.0020439624786377
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00042605400085449
(199) DESCRIBE `ports` 0.0019688606262207
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00055313110351562
(201) DESCRIBE `ports` 0.0019640922546387
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00063800811767578
(203) DESCRIBE `ports` 0.0023410320281982
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00070405006408691
(205) DESCRIBE `ports` 0.0019738674163818
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00045108795166016
(207) DESCRIBE `ports` 0.0019159317016602
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00051307678222656
(209) DESCRIBE `ports` 0.0020668506622314
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00055503845214844
(211) DESCRIBE `cruises` 0.0037879943847656
(212) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71399))) 0.00091385841369629
(213) DESCRIBE `avid_specials` 0.002018928527832
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541086 and class = 'Special') OR (item_id = 71399 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022270679473877
(215) DESCRIBE `cruiselines` 0.0029280185699463
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00073409080505371
(217) DESCRIBE `orchid_image` 0.0023231506347656
(218) DESCRIBE `cruiselines` 0.0028409957885742
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00049495697021484
(220) DESCRIBE `specials` 0.0058519840240479
(221) DESCRIBE `specials` 0.0062921047210693
(222) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541088') 0.00074291229248047
(223) DESCRIBE `ships` 0.0042541027069092
(224) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.0048489570617676
(225) DESCRIBE `ships` 0.0062777996063232
(226) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.0013890266418457
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0013899803161621
(228) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00033187866210938
(229) DESCRIBE `itineraries` 0.0018150806427002
(230) DESCRIBE `ports` 0.00187087059021
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00048398971557617
(232) DESCRIBE `ports` 0.0016849040985107
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00038003921508789
(234) DESCRIBE `ports` 0.0016379356384277
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00043892860412598
(236) DESCRIBE `specialsailingdates` 0.0020110607147217
(237) DESCRIBE `sailingdates` 0.0023150444030762
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453274))) 0.00061297416687012
(239) DESCRIBE `ports` 0.0020878314971924
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00055193901062012
(241) DESCRIBE `ports` 0.0020310878753662
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00049614906311035
(243) DESCRIBE `ports` 0.0019559860229492
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00054812431335449
(245) DESCRIBE `ports` 0.0022168159484863
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00046300888061523
(247) DESCRIBE `ports` 0.002140998840332
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00056982040405273
(249) DESCRIBE `ports` 0.0021970272064209
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00046300888061523
(251) DESCRIBE `ports` 0.0019330978393555
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00046992301940918
(253) DESCRIBE `ports` 0.0019779205322266
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00043201446533203
(255) DESCRIBE `ports` 0.001971960067749
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00087094306945801
(257) DESCRIBE `ports` 0.0020701885223389
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00044679641723633
(259) DESCRIBE `ports` 0.0019030570983887
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00050902366638184
(261) DESCRIBE `ports` 0.001751184463501
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00041985511779785
(263) DESCRIBE `ports` 0.0023219585418701
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00092720985412598
(265) DESCRIBE `ports` 0.0026628971099854
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00074100494384766
(267) DESCRIBE `ports` 0.0020439624786377
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00053191184997559
(269) DESCRIBE `ports` 0.0020961761474609
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00041484832763672
(271) DESCRIBE `ports` 0.0020298957824707
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00055313110351562
(273) DESCRIBE `ports` 0.0019900798797607
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00040292739868164
(275) DESCRIBE `ports` 0.0018401145935059
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00046706199645996
(277) DESCRIBE `ports` 0.003715991973877
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00045108795166016
(279) DESCRIBE `cruises` 0.005795955657959
(280) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71400))) 0.00090384483337402
(281) DESCRIBE `avid_specials` 0.0018219947814941
(282) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541088 and class = 'Special') OR (item_id = 71400 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.010108947753906
(283) DESCRIBE `cruiselines` 0.0054459571838379
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00065493583679199
(285) DESCRIBE `orchid_image` 0.0025482177734375
(286) DESCRIBE `cruiselines` 0.0022249221801758
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00038504600524902
(288) DESCRIBE `specials` 0.0050621032714844
(289) DESCRIBE `specials` 0.0071370601654053
(290) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541784') 0.00052690505981445
(291) DESCRIBE `ships` 0.0041611194610596
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00063395500183105
(293) DESCRIBE `ships` 0.0039761066436768
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00045514106750488
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030088424682617
(297) DESCRIBE `itineraries` 0.0019171237945557
(298) DESCRIBE `ports` 0.0019040107727051
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00050592422485352
(300) DESCRIBE `ports` 0.0017948150634766
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00043296813964844
(302) DESCRIBE `ports` 0.0024459362030029
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00055193901062012
(304) DESCRIBE `specialsailingdates` 0.0017819404602051
(305) DESCRIBE `sailingdates` 0.0019588470458984
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518739))) 0.00047492980957031
(307) DESCRIBE `sailingdates` 0.0016250610351562
(308) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518740))) 0.00037598609924316
(309) DESCRIBE `sailingdates` 0.0015811920166016
(310) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518741))) 0.00052785873413086
(311) DESCRIBE `sailingdates` 0.0016541481018066
(312) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518742))) 0.00043392181396484
(313) DESCRIBE `sailingdates` 0.0016560554504395
(314) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518743))) 0.0002589225769043
(315) DESCRIBE `sailingdates` 0.0016591548919678
(316) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518744))) 0.00040411949157715
(317) DESCRIBE `sailingdates` 0.0016028881072998
(318) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518746))) 0.00036287307739258
(319) DESCRIBE `sailingdates` 0.00154709815979
(320) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518749))) 0.00040197372436523
(321) DESCRIBE `sailingdates` 0.0015380382537842
(322) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518750))) 0.00043797492980957
(323) DESCRIBE `sailingdates` 0.0015988349914551
(324) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518751))) 0.00036907196044922
(325) DESCRIBE `sailingdates` 0.0015170574188232
(326) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518754))) 0.00039005279541016
(327) DESCRIBE `sailingdates` 0.0015759468078613
(328) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518755))) 0.00039100646972656
(329) DESCRIBE `sailingdates` 0.0015969276428223
(330) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518756))) 0.00043392181396484
(331) DESCRIBE `sailingdates` 0.0015990734100342
(332) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518757))) 0.00039005279541016
(333) DESCRIBE `sailingdates` 0.0016229152679443
(334) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518758))) 0.00037407875061035
(335) DESCRIBE `sailingdates` 0.0015819072723389
(336) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518759))) 0.00041794776916504
(337) DESCRIBE `sailingdates` 0.0016191005706787
(338) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518760))) 0.00036191940307617
(339) DESCRIBE `sailingdates` 0.0016839504241943
(340) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518761))) 0.0004420280456543
(341) DESCRIBE `sailingdates` 0.0016040802001953
(342) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518762))) 0.00041508674621582
(343) DESCRIBE `sailingdates` 0.0016169548034668
(344) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518763))) 0.00041103363037109
(345) DESCRIBE `sailingdates` 0.0015850067138672
(346) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518764))) 0.00047612190246582
(347) DESCRIBE `sailingdates` 0.0016880035400391
(348) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518765))) 0.00044393539428711
(349) DESCRIBE `sailingdates` 0.0015740394592285
(350) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518766))) 0.0004429817199707
(351) DESCRIBE `sailingdates` 0.0018501281738281
(352) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518767))) 0.0004730224609375
(353) DESCRIBE `sailingdates` 0.0017988681793213
(354) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518770))) 0.0005040168762207
(355) DESCRIBE `sailingdates` 0.0019369125366211
(356) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518772))) 0.00087285041809082
(357) DESCRIBE `sailingdates` 0.0019979476928711
(358) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518773))) 0.00061798095703125
(359) DESCRIBE `sailingdates` 0.0016529560089111
(360) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518774))) 0.00039291381835938
(361) DESCRIBE `sailingdates` 0.0015950202941895
(362) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518776))) 0.00040102005004883
(363) DESCRIBE `sailingdates` 0.0015430450439453
(364) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518777))) 0.00040602684020996
(365) DESCRIBE `sailingdates` 0.0016050338745117
(366) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518778))) 0.00044608116149902
(367) DESCRIBE `sailingdates` 0.0015220642089844
(368) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518779))) 0.00041079521179199
(369) DESCRIBE `sailingdates` 0.001596212387085
(370) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518780))) 0.00053191184997559
(371) DESCRIBE `ports` 0.0022439956665039
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00048089027404785
(373) DESCRIBE `ports` 0.0017049312591553
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00047111511230469
(375) DESCRIBE `ports` 0.0017139911651611
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00030398368835449
(377) DESCRIBE `ports` 0.0018019676208496
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00040602684020996
(379) DESCRIBE `ports` 0.0018560886383057
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00049090385437012
(381) DESCRIBE `ports` 0.0025651454925537
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00071310997009277
(383) DESCRIBE `ports` 0.0022680759429932
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00055909156799316
(385) DESCRIBE `ports` 0.0019619464874268
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00042891502380371
(387) DESCRIBE `ports` 0.0019290447235107
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.0004580020904541
(389) DESCRIBE `ports` 0.0018441677093506
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.0003960132598877
(391) DESCRIBE `ports` 0.0021228790283203
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00044798851013184
(393) DESCRIBE `ports` 0.0021088123321533
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00095605850219727
(395) DESCRIBE `ports` 0.0023531913757324
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00048995018005371
(397) DESCRIBE `ports` 0.001884937286377
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.0029139518737793
(399) DESCRIBE `ports` 0.0028679370880127
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00051712989807129
(401) DESCRIBE `ports` 0.0018198490142822
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00043487548828125
(403) DESCRIBE `cruises` 0.0037460327148438
(404) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.0007319450378418
(405) DESCRIBE `avid_specials` 0.0020349025726318
(406) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541784 and class = 'Special') OR (item_id = 11517 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0017969608306885
(407) DESCRIBE `cruiselines` 0.0029690265655518
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.000579833984375
(409) DESCRIBE `orchid_image` 0.0021789073944092
(410) DESCRIBE `cruiselines` 0.0061380863189697
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00052595138549805
(412) DESCRIBE `specials` 0.006371021270752
(413) DESCRIBE `specials` 0.0059640407562256
(414) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1553579') 0.00062990188598633
(415) DESCRIBE `ships` 0.0042169094085693
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 970))) 0.00073003768920898
(417) DESCRIBE `ships` 0.0041060447692871
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '970') 0.00055694580078125
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036311149597168
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033783912658691
(421) DESCRIBE `itineraries` 0.0019509792327881
(422) DESCRIBE `ports` 0.002065896987915
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00052690505981445
(424) DESCRIBE `ports` 0.0019018650054932
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00049519538879395
(426) DESCRIBE `ports` 0.001924991607666
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00044894218444824
(428) DESCRIBE `specialsailingdates` 0.0015900135040283
(429) DESCRIBE `sailingdates` 0.0018150806427002
(430) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 464130))) 0.0012450218200684
(431) DESCRIBE `ports` 0.0020110607147217
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00051593780517578
(433) DESCRIBE `ports` 0.0019960403442383
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00044798851013184
(435) DESCRIBE `ports` 0.0020749568939209
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0005490779876709
(437) DESCRIBE `ports` 0.0019371509552002
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.0004880428314209
(439) DESCRIBE `ports` 0.0020051002502441
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0005190372467041
(441) DESCRIBE `ports` 0.001896858215332
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00044989585876465
(443) DESCRIBE `ports` 0.001924991607666
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00046491622924805
(445) DESCRIBE `ports` 0.0019600391387939
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00044798851013184
(447) DESCRIBE `ports` 0.0019948482513428
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.0004889965057373
(449) DESCRIBE `ports` 0.0019018650054932
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00044798851013184
(451) DESCRIBE `ports` 0.0018770694732666
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00045394897460938
(453) DESCRIBE `ports` 0.0018501281738281
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00042200088500977
(455) DESCRIBE `cruises` 0.0038521289825439
(456) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67266))) 0.00067496299743652
(457) DESCRIBE `avid_specials` 0.0019052028656006
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1553579 and class = 'Special') OR (item_id = 67266 and class = 'Cruise') OR (item_id = 970 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0028238296508789
(459) DESCRIBE `cruiselines` 0.0033149719238281
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00056600570678711
(461) DESCRIBE `orchid_image` 0.0020298957824707
(462) DESCRIBE `cruiselines` 0.0027830600738525
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00058197975158691
(464) DESCRIBE `specials` 0.006087064743042
(465) DESCRIBE `specials` 0.0058910846710205
(466) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1553816') 0.00052499771118164
(467) DESCRIBE `ships` 0.0041189193725586
(468) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1320))) 0.00063490867614746
(469) DESCRIBE `ships` 0.0042262077331543
(470) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1320') 0.00054597854614258
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038886070251465
(472) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033688545227051
(473) DESCRIBE `itineraries` 0.0018770694732666
(474) DESCRIBE `ports` 0.0020179748535156
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00044679641723633
(476) DESCRIBE `ports` 0.0023579597473145
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00079488754272461
(478) DESCRIBE `ports` 0.0020360946655273
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00042819976806641
(480) DESCRIBE `specialsailingdates` 0.0014560222625732
(481) DESCRIBE `sailingdates` 0.0017290115356445
(482) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 475591))) 0.00044512748718262
(483) DESCRIBE `ports` 0.001755952835083
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00044679641723633
(485) DESCRIBE `ports` 0.0019841194152832
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00062799453735352
(487) DESCRIBE `ports` 0.002068042755127
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00048494338989258
(489) DESCRIBE `ports` 0.0019428730010986
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00044608116149902
(491) DESCRIBE `ports` 0.0016448497772217
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00055694580078125
(493) DESCRIBE `ports` 0.0015501976013184
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00034904479980469
(495) DESCRIBE `ports` 0.0016870498657227
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00041007995605469
(497) DESCRIBE `ports` 0.0016219615936279
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00037813186645508
(499) DESCRIBE `ports` 0.001460075378418
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00045895576477051
(501) DESCRIBE `ports` 0.0017910003662109
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00042891502380371
(503) DESCRIBE `cruises` 0.00301194190979
(504) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67378))) 0.00063920021057129
(505) DESCRIBE `avid_specials` 0.0014581680297852
(506) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1553816 and class = 'Special') OR (item_id = 67378 and class = 'Cruise') OR (item_id = 1320 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0013680458068848
(507) DESCRIBE `cruiselines` 0.0021181106567383
(508) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00042891502380371
(509) DESCRIBE `orchid_image` 0.0018889904022217
(510) DESCRIBE `cruiselines` 0.0020809173583984
(511) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0004880428314209
(512) DESCRIBE `specials` 0.0055577754974365
(513) DESCRIBE `specials` 0.0055968761444092
(514) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1553483') 0.00055694580078125
(515) DESCRIBE `ships` 0.0031871795654297
(516) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) 0.00061893463134766
(517) DESCRIBE `ships` 0.0034768581390381
(518) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') 0.00077295303344727
(519) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038504600524902
(520) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(521) DESCRIBE `itineraries` 0.0015408992767334
(522) DESCRIBE `ports` 0.0015249252319336
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00041294097900391
(524) DESCRIBE `ports` 0.0017890930175781
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00057291984558105
(526) DESCRIBE `ports` 0.0016520023345947
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00035500526428223
(528) DESCRIBE `specialsailingdates` 0.0012722015380859
(529) DESCRIBE `sailingdates` 0.0021421909332275
(530) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 475298))) 0.00052285194396973
(531) DESCRIBE `ports` 0.0021162033081055
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00052094459533691
(533) DESCRIBE `ports` 0.0019650459289551
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00048494338989258
(535) DESCRIBE `ports` 0.0020020008087158
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00045204162597656
(537) DESCRIBE `ports` 0.0019781589508057
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00041794776916504
(539) DESCRIBE `ports` 0.0023519992828369
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00055909156799316
(541) DESCRIBE `ports` 0.0020339488983154
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00046706199645996
(543) DESCRIBE `ports` 0.0020730495452881
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00045895576477051
(545) DESCRIBE `ports` 0.0017938613891602
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00040912628173828
(547) DESCRIBE `ports` 0.0018601417541504
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00048995018005371
(549) DESCRIBE `ports` 0.0020639896392822
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00044703483581543
(551) DESCRIBE `cruises` 0.0038149356842041
(552) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67915))) 0.00068306922912598
(553) DESCRIBE `avid_specials` 0.0016508102416992
(554) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1553483 and class = 'Special') OR (item_id = 67915 and class = 'Cruise') OR (item_id = 669 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.001716136932373
(555) DESCRIBE `cruiselines` 0.0026350021362305
(556) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00042390823364258
(557) DESCRIBE `orchid_image` 0.0017421245574951
(558) DESCRIBE `cruiselines` 0.0021991729736328
(559) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00042986869812012
(560) DESCRIBE `specials` 0.0057201385498047
(561) DESCRIBE `specials` 0.0055418014526367
(562) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1553595') 0.00059103965759277
(563) DESCRIBE `ships` 0.0043010711669922
(564) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 333))) 0.00063610076904297
(565) DESCRIBE `ships` 0.0040349960327148
(566) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '333') 0.00051784515380859
(567) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00011515617370605
(568) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(569) DESCRIBE `itineraries` 0.0018129348754883
(570) DESCRIBE `ports` 0.001500129699707
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041890144348145
(572) DESCRIBE `ports` 0.0015439987182617
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034689903259277
(574) DESCRIBE `ports` 0.0016438961029053
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00034308433532715
(576) DESCRIBE `specialsailingdates` 0.0012578964233398
(577) DESCRIBE `sailingdates` 0.0012638568878174
(578) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 464185))) 0.00040698051452637
(579) DESCRIBE `ports` 0.0015709400177002
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041794776916504
(581) DESCRIBE `ports` 0.001845121383667
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041723251342773
(583) DESCRIBE `ports` 0.0017099380493164
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00037693977355957
(585) DESCRIBE `ports` 0.0014140605926514
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00035786628723145
(587) DESCRIBE `ports` 0.0015418529510498
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00037097930908203
(589) DESCRIBE `ports` 0.0014290809631348
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00031399726867676
(591) DESCRIBE `ports` 0.0013549327850342
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0003509521484375
(593) DESCRIBE `ports` 0.0014848709106445
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.0003659725189209
(595) DESCRIBE `ports` 0.0016348361968994
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00053596496582031
(597) DESCRIBE `ports` 0.0012760162353516
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00028610229492188
(599) DESCRIBE `ports` 0.0013651847839355
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00033283233642578
(601) DESCRIBE `ports` 0.0015900135040283
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00036501884460449
(603) DESCRIBE `cruises` 0.0028290748596191
(604) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 72728))) 0.00044488906860352
(605) DESCRIBE `avid_specials` 0.0011851787567139
(606) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1553595 and class = 'Special') OR (item_id = 72728 and class = 'Cruise') OR (item_id = 333 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0011148452758789
(607) DESCRIBE `cruiselines` 0.0019440650939941
(608) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00039410591125488
(609) DESCRIBE `orchid_image` 0.0016269683837891
(610) DESCRIBE `cruiselines` 0.0020699501037598
(611) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00033903121948242
(612) DESCRIBE `specials` 0.0056889057159424
(613) DESCRIBE `specials` 0.0046229362487793
(614) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554052') 0.00049591064453125
(615) DESCRIBE `ships` 0.0036799907684326
(616) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00054812431335449
(617) DESCRIBE `ships` 0.0034229755401611
(618) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.00038003921508789
(619) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034809112548828
(620) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004279613494873
(621) DESCRIBE `itineraries` 0.0015149116516113
(622) DESCRIBE `ports` 0.0019550323486328
(623) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00053286552429199
(624) DESCRIBE `ports` 0.0019869804382324
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00056219100952148
(626) DESCRIBE `ports` 0.0019080638885498
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00050497055053711
(628) DESCRIBE `specialsailingdates` 0.001352071762085
(629) DESCRIBE `sailingdates` 0.0017921924591064
(630) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 492112))) 0.00072693824768066
(631) DESCRIBE `ports` 0.0030331611633301
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00055980682373047
(633) DESCRIBE `ports` 0.0018138885498047
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00043702125549316
(635) DESCRIBE `ports` 0.001957893371582
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.0005040168762207
(637) DESCRIBE `ports` 0.0019760131835938
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.0003960132598877
(639) DESCRIBE `ports` 0.0017728805541992
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00039482116699219
(641) DESCRIBE `ports` 0.0016288757324219
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.0003509521484375
(643) DESCRIBE `ports` 0.0014879703521729
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0004420280456543
(645) DESCRIBE `ports` 0.0018770694732666
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00038695335388184
(647) DESCRIBE `ports` 0.0018069744110107
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00050711631774902
(649) DESCRIBE `ports` 0.0019621849060059
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00045990943908691
(651) DESCRIBE `ports` 0.0022079944610596
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00051021575927734
(653) DESCRIBE `ports` 0.0018241405487061
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00040698051452637
(655) DESCRIBE `ports` 0.0019528865814209
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00047397613525391
(657) DESCRIBE `ports` 0.0018298625946045
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00043988227844238
(659) DESCRIBE `cruises` 0.0038340091705322
(660) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79178))) 0.00061321258544922
(661) DESCRIBE `avid_specials` 0.0023539066314697
(662) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554052 and class = 'Special') OR (item_id = 79178 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 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.0019140243530273
(663) DESCRIBE `cruiselines` 0.0027129650115967
(664) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00079798698425293
(665) DESCRIBE `orchid_image` 0.0017879009246826
(666) DESCRIBE `cruiselines` 0.0027530193328857
(667) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00062394142150879
(668) DESCRIBE `cruiselines` 0.0033168792724609
(669) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '212', '218', '47', '264', '33', '191', '18', '14', '20', '23', '29', '24', '114', '8', '213', '4')) ORDER BY FIND_IN_SET(id, '120,212,218,47,264,33,191,18,14,20,23,29,24,114,8,213,4') 0.0019409656524658
(670) DESCRIBE `ships` 0.0043120384216309
(671) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '1163', '627', '1526', '517', '1767', '1013', '701', '441', '163', '1032', '1205', '401', '1168', '1398', '1788', '66', '390', '451', '461', '683', '1303', '9', '10', '21', '22', '24', '25', '27', '105', '404', '439', '547', '582', '970', '1008', '1320', '1372', '1579', '1749', '1773', '1791', '3', '4', '11', '28', '74', '148', '160', '327', '332', '333', '335', '340', '626', '669', '678', '739', '792', '1073', '1243', '1262', '1302', '1347', '1385', '1539', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '521,520,1163,627,1526,517,1767,1013,701,441,163,1032,1205,401,1168,1398,1788,66,390,451,461,683,1303,9,10,21,22,24,25,27,105,404,439,547,582,970,1008,1320,1372,1579,1749,1773,1791,3,4,11,28,74,148,160,327,332,333,335,340,626,669,678,739,792,1073,1243,1262,1302,1347,1385,1539,1540,1569,1711') 0.010164976119995
(672) DESCRIBE `cruisetypes` 0.0017600059509277
(673) DESCRIBE `destinations` 0.0023930072784424
(674) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '39', '43', '12', '8', '2', '53', '35', '9', '29', '40', '48', '55', '22', '26', '34', '7', '25', '30', '49', '56')) ORDER BY FIND_IN_SET(id, '54,39,43,12,8,2,53,35,9,29,40,48,55,22,26,34,7,25,30,49,56') 0.0020179748535156