or, enquire about your chosen options

  1. Royal Caribbean Launch “Royal Up”
  2. Catch Up on Cruising: Latest News in bite size!
  3. Drinks Package Comparison
  4. Regal Princess heads down under!
  5. Catch Up on Cruising: Latest News in bite size!

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

Total elapsed time: 1.7638251781464

# Query Time
(1) connect 0.0015428066253662
(2) DESCRIBE `cruises` 0.0044929981231689
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (74763, 62663, 73135, 82096, 69257, 73136, 72065, 62689, 71829, 69090)) ORDER BY FIND_IN_SET(id, '74763,62663,73135,82096,69257,73136,72065,62689,71829,69090') 0.0030910968780518
(4) DESCRIBE `cruises` 0.0040521621704102
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74763') 0.00056099891662598
(6) DESCRIBE `ships` 0.0039150714874268
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 352))) 0.00057411193847656
(8) DESCRIBE `ships` 0.0039808750152588
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '352') 0.00054407119750977
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030899047851562
(12) DESCRIBE `itineraries` 0.001978874206543
(13) DESCRIBE `ports` 0.0023288726806641
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00053501129150391
(15) DESCRIBE `ports` 0.0021672248840332
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00054597854614258
(17) DESCRIBE `ports` 0.0019469261169434
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00045585632324219
(19) DESCRIBE `sailingdates` 0.0017459392547607
(20) DESCRIBE `ports` 0.002086877822876
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0005180835723877
(22) DESCRIBE `ports` 0.0018448829650879
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00042104721069336
(24) DESCRIBE `ports` 0.0019669532775879
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00049591064453125
(26) DESCRIBE `ports` 0.001863956451416
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00051093101501465
(28) DESCRIBE `ports` 0.0019609928131104
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00054287910461426
(30) DESCRIBE `ports` 0.0019991397857666
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0005190372467041
(32) DESCRIBE `ports` 0.0019958019256592
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00051784515380859
(34) DESCRIBE `ports` 0.0018630027770996
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00047683715820312
(36) DESCRIBE `ports` 0.0019941329956055
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00049686431884766
(38) DESCRIBE `ports` 0.0019469261169434
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00046300888061523
(40) DESCRIBE `ports` 0.0033490657806396
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00051403045654297
(42) DESCRIBE `ports` 0.0018911361694336
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00042295455932617
(44) DESCRIBE `ports` 0.0019619464874268
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2939))) 0.0004878044128418
(46) DESCRIBE `ports` 0.0019800662994385
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2939') 0.00049805641174316
(48) DESCRIBE `ports` 0.0023210048675537
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 816))) 0.00052404403686523
(50) DESCRIBE `ports` 0.0021040439605713
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '816') 0.00043606758117676
(52) DESCRIBE `ports` 0.002061128616333
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00048303604125977
(54) DESCRIBE `ports` 0.0020499229431152
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00051307678222656
(56) DESCRIBE `ports` 0.0023391246795654
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00058913230895996
(58) DESCRIBE `ports` 0.0022590160369873
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00053095817565918
(60) DESCRIBE `avid_specials` 0.0019738674163818
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74763 and class = 'Cruise') OR (item_id = 352 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0029120445251465
(62) DESCRIBE `cruiselines` 0.0033679008483887
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00081992149353027
(64) DESCRIBE `orchid_image` 0.0025260448455811
(65) DESCRIBE `cruiselines` 0.0030279159545898
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0005030632019043
(67) DESCRIBE `cruises` 0.0044550895690918
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62663') 0.00081205368041992
(69) DESCRIBE `ships` 0.0053420066833496
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00064301490783691
(71) DESCRIBE `ships` 0.0056648254394531
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00066208839416504
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046014785766602
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034213066101074
(75) DESCRIBE `itineraries` 0.0031280517578125
(76) DESCRIBE `ports` 0.0023770332336426
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00054597854614258
(78) DESCRIBE `ports` 0.0019228458404541
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00051712989807129
(80) DESCRIBE `ports` 0.002065896987915
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00052905082702637
(82) DESCRIBE `sailingdates` 0.0018839836120605
(83) DESCRIBE `ports` 0.0020959377288818
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00055813789367676
(85) DESCRIBE `ports` 0.0026309490203857
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00054597854614258
(87) DESCRIBE `ports` 0.0043449401855469
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00052809715270996
(89) DESCRIBE `ports` 0.0027749538421631
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00045013427734375
(91) DESCRIBE `ports` 0.0024609565734863
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00092220306396484
(93) DESCRIBE `ports` 0.0029489994049072
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00054192543029785
(95) DESCRIBE `ports` 0.0026459693908691
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00075006484985352
(97) DESCRIBE `ports` 0.0020549297332764
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00048303604125977
(99) DESCRIBE `ports` 0.0067870616912842
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00052499771118164
(101) DESCRIBE `ports` 0.0033528804779053
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00045490264892578
(103) DESCRIBE `ports` 0.0026969909667969
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049209594726562
(105) DESCRIBE `ports` 0.0020849704742432
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00045108795166016
(107) DESCRIBE `ports` 0.0022439956665039
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00058984756469727
(109) DESCRIBE `ports` 0.0028760433197021
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00040316581726074
(111) DESCRIBE `avid_specials` 0.0054030418395996
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62663 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0058591365814209
(113) DESCRIBE `cruiselines` 0.0029819011688232
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0012068748474121
(115) DESCRIBE `orchid_image` 0.0040819644927979
(116) DESCRIBE `cruiselines` 0.003046989440918
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00038290023803711
(118) DESCRIBE `cruises` 0.010066986083984
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73135') 0.00053501129150391
(120) DESCRIBE `ships` 0.0075559616088867
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.0027599334716797
(122) DESCRIBE `ships` 0.0071909427642822
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.0005488395690918
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042986869812012
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034403800964355
(126) DESCRIBE `itineraries` 0.0035369396209717
(127) DESCRIBE `ports` 0.0065181255340576
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00054502487182617
(129) DESCRIBE `ports` 0.0067601203918457
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00045204162597656
(131) DESCRIBE `ports` 0.0029380321502686
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00070309638977051
(133) DESCRIBE `sailingdates` 0.0017170906066895
(134) DESCRIBE `ports` 0.0021939277648926
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00048112869262695
(136) DESCRIBE `ports` 0.0019791126251221
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00055289268493652
(138) DESCRIBE `ports` 0.0020298957824707
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00063300132751465
(140) DESCRIBE `ports` 0.003446102142334
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00053215026855469
(142) DESCRIBE `ports` 0.0028879642486572
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0011987686157227
(144) DESCRIBE `ports` 0.0021471977233887
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00037193298339844
(146) DESCRIBE `ports` 0.0030641555786133
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00051593780517578
(148) DESCRIBE `ports` 0.0019710063934326
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00042295455932617
(150) DESCRIBE `ports` 0.0019090175628662
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00047588348388672
(152) DESCRIBE `ports` 0.0027761459350586
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00053691864013672
(154) DESCRIBE `ports` 0.0020511150360107
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00053215026855469
(156) DESCRIBE `ports` 0.0019168853759766
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00064778327941895
(158) DESCRIBE `ports` 0.0022280216217041
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00048494338989258
(160) DESCRIBE `ports` 0.0040500164031982
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00047016143798828
(162) DESCRIBE `avid_specials` 0.0025029182434082
(163) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73135 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 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.0019888877868652
(164) DESCRIBE `cruiselines` 0.0032958984375
(165) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00057101249694824
(166) DESCRIBE `orchid_image` 0.0023200511932373
(167) DESCRIBE `cruiselines` 0.0030169486999512
(168) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00049901008605957
(169) DESCRIBE `cruises` 0.0038399696350098
(170) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82096') 0.00057721138000488
(171) DESCRIBE `ships` 0.0040891170501709
(172) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00069904327392578
(173) DESCRIBE `ships` 0.0044541358947754
(174) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.0006110668182373
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00063395500183105
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034809112548828
(177) DESCRIBE `itineraries` 0.0021100044250488
(178) DESCRIBE `ports` 0.002129077911377
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052380561828613
(180) DESCRIBE `ports` 0.001910924911499
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00057697296142578
(182) DESCRIBE `ports` 0.0020780563354492
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00051188468933105
(184) DESCRIBE `sailingdates` 0.0018501281738281
(185) DESCRIBE `ports` 0.0023188591003418
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00057196617126465
(187) DESCRIBE `ports` 0.0051839351654053
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.01842212677002
(189) DESCRIBE `ports` 0.0041959285736084
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00058603286743164
(191) DESCRIBE `ports` 0.0033769607543945
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.0072741508483887
(193) DESCRIBE `ports` 0.0081930160522461
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00055193901062012
(195) DESCRIBE `ports` 0.002140998840332
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.004396915435791
(197) DESCRIBE `ports` 0.0022940635681152
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0073108673095703
(199) DESCRIBE `ports` 0.0019810199737549
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0035669803619385
(201) DESCRIBE `ports` 0.023617029190063
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00041103363037109
(203) DESCRIBE `ports` 0.0029652118682861
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00050091743469238
(205) DESCRIBE `ports` 0.0020260810852051
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0086150169372559
(207) DESCRIBE `ports` 0.0021708011627197
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00046610832214355
(209) DESCRIBE `ports` 0.0020339488983154
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00057601928710938
(211) DESCRIBE `ports` 0.0020630359649658
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00052094459533691
(213) DESCRIBE `avid_specials` 0.0029048919677734
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82096 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.0063471794128418
(215) DESCRIBE `cruiselines` 0.015453100204468
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.010737895965576
(217) DESCRIBE `orchid_image` 0.0052900314331055
(218) DESCRIBE `cruiselines` 0.0040688514709473
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00040698051452637
(220) DESCRIBE `cruises` 0.0053069591522217
(221) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69257') 0.00055384635925293
(222) DESCRIBE `ships` 0.0069758892059326
(223) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.0047271251678467
(224) DESCRIBE `ships` 0.015607833862305
(225) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00058603286743164
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(228) DESCRIBE `itineraries` 0.0068328380584717
(229) DESCRIBE `ports` 0.0046799182891846
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00080704689025879
(231) DESCRIBE `ports` 0.0046489238739014
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00051712989807129
(233) DESCRIBE `ports` 0.0065789222717285
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00046896934509277
(235) DESCRIBE `sailingdates` 0.0015380382537842
(236) DESCRIBE `ports` 0.0040509700775146
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.0047390460968018
(238) DESCRIBE `ports` 0.0021669864654541
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.0045361518859863
(240) DESCRIBE `ports` 0.0020430088043213
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.0042879581451416
(242) DESCRIBE `ports` 0.0022640228271484
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.0060210227966309
(244) DESCRIBE `ports` 0.0020208358764648
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.005620002746582
(246) DESCRIBE `ports` 0.0073220729827881
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.0066139698028564
(248) DESCRIBE `avid_specials` 0.0019559860229492
(249) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69257 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.0020239353179932
(250) DESCRIBE `cruiselines` 0.003079891204834
(251) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0061280727386475
(252) DESCRIBE `orchid_image` 0.0024919509887695
(253) DESCRIBE `cruiselines` 0.0070300102233887
(254) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0053761005401611
(255) DESCRIBE `cruises` 0.0044541358947754
(256) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73136') 0.011638164520264
(257) DESCRIBE `ships` 0.0071611404418945
(258) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.0098879337310791
(259) DESCRIBE `ships` 0.0043919086456299
(260) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.0048730373382568
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0043699741363525
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040483474731445
(263) DESCRIBE `itineraries` 0.0036690235137939
(264) DESCRIBE `ports` 0.0093870162963867
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0012989044189453
(266) DESCRIBE `ports` 0.0049948692321777
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0006411075592041
(268) DESCRIBE `ports` 0.0047001838684082
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00038003921508789
(270) DESCRIBE `sailingdates` 0.003201961517334
(271) DESCRIBE `ports` 0.0080571174621582
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0033009052276611
(273) DESCRIBE `ports` 0.0020809173583984
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.001399040222168
(275) DESCRIBE `ports` 0.0047390460968018
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0015678405761719
(277) DESCRIBE `ports` 0.0047597885131836
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00041699409484863
(279) DESCRIBE `ports` 0.0030839443206787
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0041701793670654
(281) DESCRIBE `ports` 0.0071070194244385
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0094521045684814
(283) DESCRIBE `ports` 0.016319036483765
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00083112716674805
(285) DESCRIBE `ports` 0.0022330284118652
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00043010711669922
(287) DESCRIBE `ports` 0.0017359256744385
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0021810531616211
(289) DESCRIBE `ports` 0.0024158954620361
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.011150121688843
(291) DESCRIBE `ports` 0.002094030380249
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00053095817565918
(293) DESCRIBE `ports` 0.0068140029907227
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00045108795166016
(295) DESCRIBE `ports` 0.0018470287322998
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0048041343688965
(297) DESCRIBE `ports` 0.015298128128052
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0048189163208008
(299) DESCRIBE `ports` 0.0029318332672119
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.006688117980957
(301) DESCRIBE `ports` 0.0078868865966797
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00070309638977051
(303) DESCRIBE `ports` 0.0053360462188721
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.003727912902832
(305) DESCRIBE `ports` 0.0032689571380615
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.0038459300994873
(307) DESCRIBE `ports` 0.0079259872436523
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0061988830566406
(309) DESCRIBE `ports` 0.0025780200958252
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0068321228027344
(311) DESCRIBE `ports` 0.0026810169219971
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0047900676727295
(313) DESCRIBE `ports` 0.0027709007263184
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.0048549175262451
(315) DESCRIBE `ports` 0.0021159648895264
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0049669742584229
(317) DESCRIBE `ports` 0.0021660327911377
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0047781467437744
(319) DESCRIBE `ports` 0.0024290084838867
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0048460960388184
(321) DESCRIBE `ports` 0.0060999393463135
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0004889965057373
(323) DESCRIBE `avid_specials` 0.0032072067260742
(324) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73136 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 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.015516042709351
(325) DESCRIBE `cruiselines` 0.0088191032409668
(326) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00061607360839844
(327) DESCRIBE `orchid_image` 0.010325193405151
(328) DESCRIBE `cruiselines` 0.0039651393890381
(329) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0074019432067871
(330) DESCRIBE `cruises` 0.003856897354126
(331) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72065') 0.0049760341644287
(332) DESCRIBE `ships` 0.0069200992584229
(333) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.0052289962768555
(334) DESCRIBE `ships` 0.0039768218994141
(335) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.0078518390655518
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032496452331543
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030112266540527
(338) DESCRIBE `itineraries` 0.001863956451416
(339) DESCRIBE `ports` 0.0071380138397217
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0039961338043213
(341) DESCRIBE `ports` 0.0019090175628662
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0043349266052246
(343) DESCRIBE `ports` 0.003450870513916
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.004957914352417
(345) DESCRIBE `sailingdates` 0.0018768310546875
(346) DESCRIBE `ports` 0.0049610137939453
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0041508674621582
(348) DESCRIBE `ports` 0.0019080638885498
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0038008689880371
(350) DESCRIBE `ports` 0.0019350051879883
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.004525899887085
(352) DESCRIBE `ports` 0.0021920204162598
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.003892183303833
(354) DESCRIBE `ports` 0.0033011436462402
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0064210891723633
(356) DESCRIBE `ports` 0.0023801326751709
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0054399967193604
(358) DESCRIBE `ports` 0.0022101402282715
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0047838687896729
(360) DESCRIBE `ports` 0.0023179054260254
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0055530071258545
(362) DESCRIBE `ports` 0.0020809173583984
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0026729106903076
(364) DESCRIBE `ports` 0.0019059181213379
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.005885124206543
(366) DESCRIBE `ports` 0.0020370483398438
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0043339729309082
(368) DESCRIBE `ports` 0.0019948482513428
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0041279792785645
(370) DESCRIBE `ports` 0.0019919872283936
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0041470527648926
(372) DESCRIBE `ports` 0.0014309883117676
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0012450218200684
(374) DESCRIBE `ports` 0.0035710334777832
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0036320686340332
(376) DESCRIBE `ports` 0.0015280246734619
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.001183032989502
(378) DESCRIBE `ports` 0.0040481090545654
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046396255493164
(380) DESCRIBE `ports` 0.0047907829284668
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0016028881072998
(382) DESCRIBE `avid_specials` 0.0018060207366943
(383) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72065 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 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.0048401355743408
(384) DESCRIBE `cruiselines` 0.0074560642242432
(385) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.008430004119873
(386) DESCRIBE `orchid_image` 0.0021851062774658
(387) DESCRIBE `cruiselines` 0.0055160522460938
(388) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0088720321655273
(389) DESCRIBE `cruises` 0.0042650699615479
(390) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62689') 0.0093200206756592
(391) DESCRIBE `ships` 0.004004955291748
(392) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.0013320446014404
(393) DESCRIBE `ships` 0.0068209171295166
(394) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.0083551406860352
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0018079280853271
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037693977355957
(397) DESCRIBE `itineraries` 0.0021500587463379
(398) DESCRIBE `ports` 0.008944034576416
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0081231594085693
(400) DESCRIBE `ports` 0.0025010108947754
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0046429634094238
(402) DESCRIBE `ports` 0.0020430088043213
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00043606758117676
(404) DESCRIBE `sailingdates` 0.003061056137085
(405) DESCRIBE `ports` 0.0059990882873535
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0073981285095215
(407) DESCRIBE `ports` 0.0024139881134033
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00059700012207031
(409) DESCRIBE `ports` 0.0021798610687256
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0033490657806396
(411) DESCRIBE `ports` 0.010013103485107
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00046205520629883
(413) DESCRIBE `ports` 0.0031061172485352
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0033390522003174
(415) DESCRIBE `ports` 0.0026190280914307
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0039591789245605
(417) DESCRIBE `ports` 0.0019311904907227
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.0040721893310547
(419) DESCRIBE `ports` 0.0018360614776611
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.0041611194610596
(421) DESCRIBE `ports` 0.0020160675048828
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0037801265716553
(423) DESCRIBE `ports` 0.0050020217895508
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0040550231933594
(425) DESCRIBE `ports` 0.0018630027770996
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0046150684356689
(427) DESCRIBE `ports` 0.0021440982818604
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0046079158782959
(429) DESCRIBE `ports` 0.0027210712432861
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0032820701599121
(431) DESCRIBE `ports` 0.0036690235137939
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0031909942626953
(433) DESCRIBE `avid_specials` 0.002626895904541
(434) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62689 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 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.0070919990539551
(435) DESCRIBE `cruiselines` 0.0077059268951416
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0096108913421631
(437) DESCRIBE `orchid_image` 0.0022940635681152
(438) DESCRIBE `cruiselines` 0.0074429512023926
(439) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0023970603942871
(440) DESCRIBE `cruises` 0.0071780681610107
(441) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71829') 0.0059449672698975
(442) DESCRIBE `ships` 0.0073909759521484
(443) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.0050289630889893
(444) DESCRIBE `ships` 0.0039908885955811
(445) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.0079360008239746
(446) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037503242492676
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0035359859466553
(448) DESCRIBE `itineraries` 0.0020151138305664
(449) DESCRIBE `ports` 0.0029737949371338
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0051009654998779
(451) DESCRIBE `ports` 0.0024740695953369
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0038487911224365
(453) DESCRIBE `ports` 0.0024499893188477
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0005028247833252
(455) DESCRIBE `sailingdates` 0.002856969833374
(456) DESCRIBE `ports` 0.0028891563415527
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00058984756469727
(458) DESCRIBE `ports` 0.0028579235076904
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00081515312194824
(460) DESCRIBE `ports` 0.0021369457244873
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00051188468933105
(462) DESCRIBE `ports` 0.0019857883453369
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00051188468933105
(464) DESCRIBE `ports` 0.0019969940185547
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00054311752319336
(466) DESCRIBE `ports` 0.0019748210906982
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044012069702148
(468) DESCRIBE `ports` 0.0019800662994385
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00049304962158203
(470) DESCRIBE `ports` 0.0020852088928223
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00045084953308105
(472) DESCRIBE `ports` 0.0020110607147217
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00052404403686523
(474) DESCRIBE `ports` 0.0029110908508301
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00050497055053711
(476) DESCRIBE `ports` 0.0020849704742432
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00048303604125977
(478) DESCRIBE `ports` 0.0028431415557861
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00053191184997559
(480) DESCRIBE `ports` 0.0026710033416748
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0005650520324707
(482) DESCRIBE `ports` 0.0035390853881836
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00051212310791016
(484) DESCRIBE `ports` 0.0023620128631592
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00065898895263672
(486) DESCRIBE `ports` 0.002694845199585
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040888786315918
(488) DESCRIBE `ports` 0.0020909309387207
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00049614906311035
(490) DESCRIBE `ports` 0.0029919147491455
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00049018859863281
(492) DESCRIBE `ports` 0.0022299289703369
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00055599212646484
(494) DESCRIBE `ports` 0.0022671222686768
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00055789947509766
(496) DESCRIBE `avid_specials` 0.004302978515625
(497) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71829 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 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.0026881694793701
(498) DESCRIBE `cruiselines` 0.0027878284454346
(499) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0088088512420654
(500) DESCRIBE `orchid_image` 0.0026681423187256
(501) DESCRIBE `cruiselines` 0.0038111209869385
(502) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0092489719390869
(503) DESCRIBE `cruises` 0.0058908462524414
(504) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69090') 0.00053596496582031
(505) DESCRIBE `ships` 0.015412092208862
(506) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.0011670589447021
(507) DESCRIBE `ships` 0.0041470527648926
(508) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.0071749687194824
(509) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00057101249694824
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038480758666992
(511) DESCRIBE `itineraries` 0.0056900978088379
(512) DESCRIBE `ports` 0.002924919128418
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047397613525391
(514) DESCRIBE `ports` 0.0085179805755615
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00063896179199219
(516) DESCRIBE `ports` 0.0088119506835938
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0026271343231201
(518) DESCRIBE `sailingdates` 0.0025341510772705
(519) DESCRIBE `ports` 0.0044288635253906
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00039291381835938
(521) DESCRIBE `ports` 0.0023341178894043
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0019431114196777
(523) DESCRIBE `ports` 0.0040161609649658
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00050115585327148
(525) DESCRIBE `ports` 0.0024750232696533
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00047993659973145
(527) DESCRIBE `ports` 0.0023980140686035
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00052094459533691
(529) DESCRIBE `ports` 0.0024008750915527
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.0005950927734375
(531) DESCRIBE `ports` 0.0028700828552246
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.0012750625610352
(533) DESCRIBE `ports` 0.0026118755340576
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00050806999206543
(535) DESCRIBE `ports` 0.0019960403442383
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00043702125549316
(537) DESCRIBE `ports` 0.0019588470458984
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00036406517028809
(539) DESCRIBE `ports` 0.0026271343231201
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0004580020904541
(541) DESCRIBE `ports` 0.0021688938140869
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0004889965057373
(543) DESCRIBE `ports` 0.0025579929351807
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054192543029785
(545) DESCRIBE `ports` 0.002769947052002
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00061893463134766
(547) DESCRIBE `ports` 0.0025269985198975
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00052595138549805
(549) DESCRIBE `ports` 0.0028650760650635
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00054502487182617
(551) DESCRIBE `ports` 0.0029058456420898
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00053787231445312
(553) DESCRIBE `ports` 0.0030920505523682
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00059795379638672
(555) DESCRIBE `ports` 0.0021579265594482
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00046086311340332
(557) DESCRIBE `ports` 0.0022339820861816
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.0007178783416748
(559) DESCRIBE `ports` 0.0030667781829834
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00055623054504395
(561) DESCRIBE `ports` 0.0022830963134766
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00040197372436523
(563) DESCRIBE `ports` 0.002979040145874
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00060415267944336
(565) DESCRIBE `ports` 0.0022051334381104
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00037598609924316
(567) DESCRIBE `ports` 0.001986026763916
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00049495697021484
(569) DESCRIBE `ports` 0.0020959377288818
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00046205520629883
(571) DESCRIBE `ports` 0.0020890235900879
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054407119750977
(573) DESCRIBE `ports` 0.0025250911712646
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046801567077637
(575) DESCRIBE `avid_specials` 0.0020580291748047
(576) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69090 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 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.0013110637664795
(577) DESCRIBE `cruiselines` 0.0023250579833984
(578) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00047588348388672
(579) DESCRIBE `orchid_image` 0.0024478435516357
(580) DESCRIBE `cruiselines` 0.0031790733337402
(581) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00029897689819336
(582) DESCRIBE `ships` 0.0035231113433838
(583) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1599', '1588', '726', '1359', '1067', '1768', '407', '674', '1415', '452', '462', '610', '553', '766', '1717', '352', '738')) ORDER BY FIND_IN_SET(id, '977,1599,1588,726,1359,1067,1768,407,674,1415,452,462,610,553,766,1717,352,738') 0.0024998188018799
(584) DESCRIBE `cruisetypes` 0.0016438961029053
(585) DESCRIBE `destinations` 0.002551794052124
(586) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '37', '26', '25', '52', '45', '38', '28', '40', '9', '49', '11', '21', '35')) ORDER BY FIND_IN_SET(id, '22,12,37,26,25,52,45,38,28,40,9,49,11,21,35') 0.0017690658569336
(587) DESCRIBE `cruiselines` 0.0029928684234619
(588) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00051593780517578
(589) DESCRIBE `cruiselines` 0.0030999183654785
(590) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00071096420288086