or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

Total elapsed time: 0.66826272010803

# Query Time
(1) connect 0.00076484680175781
(2) DESCRIBE `cruises` 0.0038220882415771
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (57673, 59146, 62665, 65846, 67433, 67434, 68997, 69565, 69653, 70744)) ORDER BY FIND_IN_SET(id, '57673,59146,62665,65846,67433,67434,68997,69565,69653,70744') 0.0020699501037598
(4) DESCRIBE `cruises` 0.0031650066375732
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57673') 0.00038719177246094
(6) DESCRIBE `ships` 0.0026559829711914
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00043606758117676
(8) DESCRIBE `ships` 0.0028471946716309
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00037813186645508
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(12) DESCRIBE `itineraries` 0.0013909339904785
(13) DESCRIBE `ports` 0.0013041496276855
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00032615661621094
(15) DESCRIBE `ports` 0.0013060569763184
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00036191940307617
(17) DESCRIBE `ports` 0.0016450881958008
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00034999847412109
(19) DESCRIBE `sailingdates` 0.0014050006866455
(20) DESCRIBE `ports` 0.0017578601837158
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00040316581726074
(22) DESCRIBE `ports` 0.001446008682251
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00033092498779297
(24) DESCRIBE `ports` 0.0013611316680908
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028300285339355
(26) DESCRIBE `ports` 0.0014190673828125
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00027704238891602
(28) DESCRIBE `ports` 0.0012309551239014
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00029397010803223
(30) DESCRIBE `ports` 0.0015048980712891
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00032305717468262
(32) DESCRIBE `ports` 0.0013442039489746
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00054001808166504
(34) DESCRIBE `ports` 0.0019791126251221
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00037193298339844
(36) DESCRIBE `ports` 0.0017480850219727
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00044488906860352
(38) DESCRIBE `ports` 0.0017709732055664
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00037097930908203
(40) DESCRIBE `ports` 0.0016858577728271
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0004570484161377
(42) DESCRIBE `ports` 0.0018820762634277
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00036406517028809
(44) DESCRIBE `ports` 0.001572847366333
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00066995620727539
(46) DESCRIBE `ports` 0.0018019676208496
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00036001205444336
(48) DESCRIBE `ports` 0.0015518665313721
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.0003809928894043
(50) DESCRIBE `ports` 0.0018007755279541
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00036907196044922
(52) DESCRIBE `ports` 0.0016040802001953
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00038599967956543
(54) DESCRIBE `ports` 0.0016241073608398
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00057005882263184
(56) DESCRIBE `ports` 0.0017440319061279
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.0003809928894043
(58) DESCRIBE `ports` 0.0016088485717773
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00040292739868164
(60) DESCRIBE `ports` 0.0016040802001953
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0003509521484375
(62) DESCRIBE `ports` 0.0017030239105225
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00032210350036621
(64) DESCRIBE `ports` 0.0015408992767334
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00037693977355957
(66) DESCRIBE `ports` 0.0021350383758545
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00033378601074219
(68) DESCRIBE `avid_specials` 0.0013430118560791
(69) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57673 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.0012438297271729
(70) DESCRIBE `cruiselines` 0.0021319389343262
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00037813186645508
(72) DESCRIBE `orchid_image` 0.0016739368438721
(73) DESCRIBE `cruiselines` 0.0017969608306885
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00039505958557129
(75) DESCRIBE `cruises` 0.0025589466094971
(76) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59146') 0.0003669261932373
(77) DESCRIBE `ships` 0.0028040409088135
(78) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 859))) 0.00043106079101562
(79) DESCRIBE `ships` 0.0028278827667236
(80) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '859') 0.00040507316589355
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00078606605529785
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029516220092773
(83) DESCRIBE `itineraries` 0.0015439987182617
(84) DESCRIBE `ports` 0.0014419555664062
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.0003509521484375
(86) DESCRIBE `ports` 0.0015819072723389
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00032186508178711
(88) DESCRIBE `ports` 0.0013890266418457
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0.00028800964355469
(90) DESCRIBE `sailingdates` 0.0012860298156738
(91) DESCRIBE `ports` 0.001305103302002
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00034499168395996
(93) DESCRIBE `ports` 0.0015699863433838
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0.0003359317779541
(95) DESCRIBE `ports` 0.0012819766998291
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5178))) 0.0003209114074707
(97) DESCRIBE `ports` 0.0012631416320801
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5178') 0.00021886825561523
(99) DESCRIBE `ports` 0.0012900829315186
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5178))) 0.00031018257141113
(101) DESCRIBE `ports` 0.0013308525085449
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5178') 0.00041985511779785
(103) DESCRIBE `ports` 0.001676082611084
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00012683868408203
(105) DESCRIBE `ports` 0.0017311573028564
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00035595893859863
(107) DESCRIBE `ports` 0.0016529560089111
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00037312507629395
(109) DESCRIBE `ports` 0.001676082611084
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00035500526428223
(111) DESCRIBE `ports` 0.0016801357269287
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00038290023803711
(113) DESCRIBE `ports` 0.0015730857849121
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00035214424133301
(115) DESCRIBE `ports` 0.001704216003418
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00044679641723633
(117) DESCRIBE `ports` 0.0015850067138672
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00036311149597168
(119) DESCRIBE `ports` 0.0017740726470947
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5178))) 0.00042891502380371
(121) DESCRIBE `ports` 0.0018460750579834
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5178') 0.00042295455932617
(123) DESCRIBE `ports` 0.0018341541290283
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00040984153747559
(125) DESCRIBE `ports` 0.0017938613891602
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0.00040102005004883
(127) DESCRIBE `avid_specials` 0.0016098022460938
(128) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59146 and class = 'Cruise') OR (item_id = 859 AND class = 'Ship') OR (item_id = 196 AND class = 'CruiseLine') OR (item_id = 55 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.0017580986022949
(129) DESCRIBE `cruiselines` 0.0027041435241699
(130) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 196))) 0.00047397613525391
(131) DESCRIBE `orchid_image` 0.0016241073608398
(132) DESCRIBE `cruiselines` 0.0025131702423096
(133) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '196') 0.00039100646972656
(134) DESCRIBE `cruises` 0.0031619071960449
(135) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62665') 0.00044107437133789
(136) DESCRIBE `ships` 0.0035021305084229
(137) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00054311752319336
(138) DESCRIBE `ships` 0.0034420490264893
(139) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00043797492980957
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033092498779297
(142) DESCRIBE `itineraries` 0.0018379688262939
(143) DESCRIBE `ports` 0.0018508434295654
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00044798851013184
(145) DESCRIBE `ports` 0.0017449855804443
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0004279613494873
(147) DESCRIBE `ports` 0.0017402172088623
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00037908554077148
(149) DESCRIBE `sailingdates` 0.0015830993652344
(150) DESCRIBE `ports` 0.0020389556884766
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00047111511230469
(152) DESCRIBE `ports` 0.0018439292907715
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00048995018005371
(154) DESCRIBE `ports` 0.001474142074585
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00040292739868164
(156) DESCRIBE `ports` 0.0012929439544678
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00027704238891602
(158) DESCRIBE `ports` 0.001384973526001
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033688545227051
(160) DESCRIBE `ports` 0.0011520385742188
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00032711029052734
(162) DESCRIBE `ports` 0.0013501644134521
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00035190582275391
(164) DESCRIBE `ports` 0.0012869834899902
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00028300285339355
(166) DESCRIBE `ports` 0.0012779235839844
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00030612945556641
(168) DESCRIBE `ports` 0.0013048648834229
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0
(170) DESCRIBE `ports` 0.0012590885162354
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030207633972168
(172) DESCRIBE `ports` 0.0016670227050781
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028896331787109
(174) DESCRIBE `ports` 0.0012409687042236
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00035190582275391
(176) DESCRIBE `ports` 0.0013258457183838
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026512145996094
(178) DESCRIBE `avid_specials` 0.0011460781097412
(179) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62665 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.00074601173400879
(180) DESCRIBE `cruiselines` 0.001896858215332
(181) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 3.0994415283203E-6
(182) DESCRIBE `orchid_image` 0.0015120506286621
(183) DESCRIBE `cruiselines` 0.0019869804382324
(184) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030899047851562
(185) DESCRIBE `cruises` 0.0024259090423584
(186) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65846') 0.00031399726867676
(187) DESCRIBE `ships` 0.0029909610748291
(188) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 70))) 0.00040984153747559
(189) DESCRIBE `ships` 0.0025739669799805
(190) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '70') 0.00026798248291016
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026917457580566
(192) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(193) DESCRIBE `itineraries` 0.001276969909668
(194) DESCRIBE `ports` 0.0013790130615234
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00033307075500488
(196) DESCRIBE `ports` 0.0012609958648682
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00029397010803223
(198) DESCRIBE `ports` 0.0012779235839844
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0002741813659668
(200) DESCRIBE `sailingdates` 0.0011451244354248
(201) DESCRIBE `ports` 0.0012631416320801
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0003058910369873
(203) DESCRIBE `ports` 0.0012710094451904
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00026798248291016
(205) DESCRIBE `ports` 0.001352071762085
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00035500526428223
(207) DESCRIBE `ports` 0.0012521743774414
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00031304359436035
(209) DESCRIBE `ports` 0.0016040802001953
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1102))) 0.00084018707275391
(211) DESCRIBE `ports` 0.0013391971588135
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1102') 0.00029087066650391
(213) DESCRIBE `ports` 0.0013561248779297
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00030112266540527
(215) DESCRIBE `ports` 0.0012519359588623
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00027108192443848
(217) DESCRIBE `ports` 0.0012631416320801
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00032997131347656
(219) DESCRIBE `ports` 0.0013229846954346
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00036907196044922
(221) DESCRIBE `avid_specials` 0.0016179084777832
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65846 and class = 'Cruise') OR (item_id = 70 AND class = 'Ship') OR (item_id = 16 AND class = 'CruiseLine') OR (item_id = 9 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.0018250942230225
(223) DESCRIBE `cruiselines` 0.0026440620422363
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00040507316589355
(225) DESCRIBE `orchid_image` 0.0015602111816406
(226) DESCRIBE `cruiselines` 0.0018348693847656
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.0003058910369873
(228) DESCRIBE `cruises` 0.0024580955505371
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67433') 0.00033402442932129
(230) DESCRIBE `ships` 0.0024709701538086
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1217))) 0.00038409233093262
(232) DESCRIBE `ships` 0.0025951862335205
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1217') 0.00038480758666992
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002598762512207
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024700164794922
(236) DESCRIBE `itineraries` 0.0012319087982178
(237) DESCRIBE `ports` 0.0013902187347412
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00031685829162598
(239) DESCRIBE `ports` 0.001288890838623
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00031781196594238
(241) DESCRIBE `ports` 0.0013449192047119
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00027608871459961
(243) DESCRIBE `sailingdates` 0.0011270046234131
(244) DESCRIBE `ports` 0.0012621879577637
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00032401084899902
(246) DESCRIBE `ports` 0.0013689994812012
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00031208992004395
(248) DESCRIBE `ports` 0.0014281272888184
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00038385391235352
(250) DESCRIBE `ports` 0.001533031463623
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00036001205444336
(252) DESCRIBE `ports` 0.001600980758667
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00035285949707031
(254) DESCRIBE `ports` 0.0014879703521729
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00032711029052734
(256) DESCRIBE `ports` 0.0014829635620117
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00056004524230957
(258) DESCRIBE `ports` 0.0016720294952393
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00034594535827637
(260) DESCRIBE `ports` 0.0015420913696289
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00036501884460449
(262) DESCRIBE `ports` 0.0016260147094727
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00030088424682617
(264) DESCRIBE `ports` 0.001284122467041
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0004570484161377
(266) DESCRIBE `ports` 0.00130295753479
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00070786476135254
(268) DESCRIBE `ports` 0.0013771057128906
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00038909912109375
(270) DESCRIBE `ports` 0.0013799667358398
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0003662109375
(272) DESCRIBE `ports` 0.001488208770752
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00040316581726074
(274) DESCRIBE `ports` 0.0017881393432617
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00036287307739258
(276) DESCRIBE `ports` 0.0017490386962891
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00042605400085449
(278) DESCRIBE `ports` 0.0014009475708008
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00028681755065918
(280) DESCRIBE `avid_specials` 0.0012199878692627
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67433 and class = 'Cruise') OR (item_id = 1217 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine') OR (item_id = 50 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.0015628337860107
(282) DESCRIBE `cruiselines` 0.0020599365234375
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00037598609924316
(284) DESCRIBE `orchid_image` 0.0014729499816895
(285) DESCRIBE `cruiselines` 0.0022938251495361
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00058507919311523
(287) DESCRIBE `cruises` 0.0033681392669678
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67434') 0.00043201446533203
(289) DESCRIBE `ships` 0.0024089813232422
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1322))) 5.1021575927734E-5
(291) DESCRIBE `ships` 0.0027511119842529
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1322') 0.00072312355041504
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0006871223449707
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019001960754395
(295) DESCRIBE `itineraries` 0.0020210742950439
(296) DESCRIBE `ports` 0.00096487998962402
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00033903121948242
(298) DESCRIBE `ports` 0.0019609928131104
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00063300132751465
(300) DESCRIBE `ports` 0.0012280941009521
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0002288818359375
(302) DESCRIBE `sailingdates` 0.0057899951934814
(303) DESCRIBE `ports` 0.0018651485443115
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00041985511779785
(305) DESCRIBE `ports` 0.0016279220581055
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0003809928894043
(307) DESCRIBE `ports` 0.0016260147094727
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00037884712219238
(309) DESCRIBE `ports` 0.0015718936920166
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00037693977355957
(311) DESCRIBE `ports` 0.0016670227050781
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00040793418884277
(313) DESCRIBE `ports` 0.0016229152679443
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00035691261291504
(315) DESCRIBE `ports` 0.0015511512756348
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00039291381835938
(317) DESCRIBE `ports` 0.0022768974304199
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00038886070251465
(319) DESCRIBE `ports` 0.0014839172363281
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00045180320739746
(321) DESCRIBE `ports` 0.0013229846954346
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00028491020202637
(323) DESCRIBE `ports` 0.001460075378418
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00031208992004395
(325) DESCRIBE `ports` 0.0017750263214111
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00039505958557129
(327) DESCRIBE `ports` 0.0015089511871338
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00033402442932129
(329) DESCRIBE `ports` 0.0022151470184326
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0
(331) DESCRIBE `ports` 0.0016410350799561
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 4.6014785766602E-5
(333) DESCRIBE `ports` 0.0014879703521729
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00020384788513184
(335) DESCRIBE `ports` 0.0014078617095947
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0001518726348877
(337) DESCRIBE `ports` 0.0017099380493164
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 2.9802322387695E-5
(339) DESCRIBE `avid_specials` 0.0018038749694824
(340) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67434 and class = 'Cruise') OR (item_id = 1322 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine') OR (item_id = 50 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.0010480880737305
(341) DESCRIBE `cruiselines` 0.0020449161529541
(342) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00039482116699219
(343) DESCRIBE `orchid_image` 0.0021698474884033
(344) DESCRIBE `cruiselines` 0.0015139579772949
(345) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00032806396484375
(346) DESCRIBE `cruises` 0.0028660297393799
(347) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68997') 0.00048518180847168
(348) DESCRIBE `ships` 0.0031111240386963
(349) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1344))) 0.00051212310791016
(350) DESCRIBE `ships` 0.0030069351196289
(351) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1344') 0.0004429817199707
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027179718017578
(353) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(354) DESCRIBE `itineraries` 0.0014579296112061
(355) DESCRIBE `ports` 0.0011351108551025
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00037217140197754
(357) DESCRIBE `ports` 0.0013000965118408
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00030708312988281
(359) DESCRIBE `ports` 0.0013389587402344
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00032401084899902
(361) DESCRIBE `sailingdates` 0.001194953918457
(362) DESCRIBE `ports` 0.001349925994873
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00049090385437012
(364) DESCRIBE `ports` 0.0014388561248779
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00032711029052734
(366) DESCRIBE `ports` 0.001262903213501
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00030303001403809
(368) DESCRIBE `ports` 0.0012731552124023
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00076794624328613
(370) DESCRIBE `ports` 0.0011420249938965
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00036215782165527
(372) DESCRIBE `ports` 0.0015890598297119
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.0003058910369873
(374) DESCRIBE `ports` 0.0014629364013672
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00084304809570312
(376) DESCRIBE `ports` 0.001201868057251
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00029301643371582
(378) DESCRIBE `ports` 0.001366138458252
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00031113624572754
(380) DESCRIBE `ports` 0.0014009475708008
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00030398368835449
(382) DESCRIBE `ports` 0.0015699863433838
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00043320655822754
(384) DESCRIBE `ports` 0.0014309883117676
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.00016593933105469
(386) DESCRIBE `ports` 0.0013720989227295
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00032806396484375
(388) DESCRIBE `ports` 0.002065896987915
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.0003359317779541
(390) DESCRIBE `ports` 0.0016739368438721
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00030803680419922
(392) DESCRIBE `ports` 0.0014591217041016
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.0003819465637207
(394) DESCRIBE `ports` 0.0013267993927002
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00030684471130371
(396) DESCRIBE `ports` 0.0013430118560791
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00027704238891602
(398) DESCRIBE `ports` 0.0012671947479248
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00030112266540527
(400) DESCRIBE `ports` 0.0013608932495117
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00027585029602051
(402) DESCRIBE `avid_specials` 0.0011260509490967
(403) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68997 and class = 'Cruise') OR (item_id = 1344 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0012490749359131
(404) DESCRIBE `cruiselines` 0.001953125
(405) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00037503242492676
(406) DESCRIBE `orchid_image` 0.001655101776123
(407) DESCRIBE `cruiselines` 0.001884937286377
(408) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00029110908508301
(409) DESCRIBE `cruises` 0.002471923828125
(410) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69565') 0.00030899047851562
(411) DESCRIBE `ships` 0.0026340484619141
(412) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1090))) 0.00037384033203125
(413) DESCRIBE `ships` 0.0032570362091064
(414) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1090') 0.00035786628723145
(415) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028014183044434
(416) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002589225769043
(417) DESCRIBE `itineraries` 0.0013401508331299
(418) DESCRIBE `ports` 0.0013079643249512
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00032687187194824
(420) DESCRIBE `ports` 0.0012779235839844
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00035810470581055
(422) DESCRIBE `ports` 0.0013840198516846
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00037384033203125
(424) DESCRIBE `sailingdates` 0.0012080669403076
(425) DESCRIBE `ports` 0.0016601085662842
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00041508674621582
(427) DESCRIBE `ports` 0.0013179779052734
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00029110908508301
(429) DESCRIBE `ports` 0.0014698505401611
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00034999847412109
(431) DESCRIBE `ports` 0.0012569427490234
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00029397010803223
(433) DESCRIBE `ports` 0.0012698173522949
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00031590461730957
(435) DESCRIBE `ports` 0.0012600421905518
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00034213066101074
(437) DESCRIBE `ports` 0.0012428760528564
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00029993057250977
(439) DESCRIBE `ports` 0.0017061233520508
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00036191940307617
(441) DESCRIBE `ports` 0.0016348361968994
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00048089027404785
(443) DESCRIBE `ports` 0.0016970634460449
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.0003199577331543
(445) DESCRIBE `ports` 0.0016570091247559
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00040912628173828
(447) DESCRIBE `ports` 0.0017149448394775
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00038790702819824
(449) DESCRIBE `ports` 0.0016930103302002
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00032496452331543
(451) DESCRIBE `ports` 0.0014479160308838
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00032401084899902
(453) DESCRIBE `ports` 0.0016028881072998
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00044012069702148
(455) DESCRIBE `ports` 0.0013790130615234
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00030994415283203
(457) DESCRIBE `ports` 0.0012860298156738
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00045394897460938
(459) DESCRIBE `ports` 0.0016541481018066
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00031399726867676
(461) DESCRIBE `ports` 0.0022580623626709
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00035595893859863
(463) DESCRIBE `ports` 0.0014159679412842
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00033688545227051
(465) DESCRIBE `avid_specials` 0.00076508522033691
(466) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69565 and class = 'Cruise') OR (item_id = 1090 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0011990070343018
(467) DESCRIBE `cruiselines` 0.0021319389343262
(468) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00037813186645508
(469) DESCRIBE `orchid_image` 0.0014939308166504
(470) DESCRIBE `cruiselines` 0.0018160343170166
(471) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00030612945556641
(472) DESCRIBE `cruises` 0.0025949478149414
(473) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69653') 0.00035691261291504
(474) DESCRIBE `ships` 0.0026021003723145
(475) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1025))) 0.00040006637573242
(476) DESCRIBE `ships` 0.0030519962310791
(477) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1025') 0.00030207633972168
(478) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(479) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030303001403809
(480) DESCRIBE `itineraries` 0.0015180110931396
(481) DESCRIBE `ports` 0.0018930435180664
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00034999847412109
(483) DESCRIBE `ports` 0.0012500286102295
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00086402893066406
(485) DESCRIBE `ports` 0.0010838508605957
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00028395652770996
(487) DESCRIBE `sailingdates` 0.0013279914855957
(488) DESCRIBE `ports` 0.0014369487762451
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00037789344787598
(490) DESCRIBE `ports` 0.0012598037719727
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00036215782165527
(492) DESCRIBE `ports` 0.0012471675872803
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00030207633972168
(494) DESCRIBE `ports` 0.00142502784729
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00028896331787109
(496) DESCRIBE `ports` 0.00180983543396
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00028419494628906
(498) DESCRIBE `ports` 0.0012528896331787
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00028204917907715
(500) DESCRIBE `ports` 0.0019888877868652
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0
(502) DESCRIBE `ports` 0.0012679100036621
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00028395652770996
(504) DESCRIBE `ports` 0.0013289451599121
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00030112266540527
(506) DESCRIBE `ports` 0.001244068145752
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00083589553833008
(508) DESCRIBE `ports` 0.00091004371643066
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00037288665771484
(510) DESCRIBE `ports` 0.0016810894012451
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00030803680419922
(512) DESCRIBE `ports` 0.0013139247894287
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00035786628723145
(514) DESCRIBE `ports` 0.001255989074707
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00035595893859863
(516) DESCRIBE `ports` 0.0013809204101562
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00031113624572754
(518) DESCRIBE `ports` 0.0013968944549561
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00028896331787109
(520) DESCRIBE `ports` 0.0013689994812012
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0003669261932373
(522) DESCRIBE `ports` 0.0013601779937744
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00030684471130371
(524) DESCRIBE `avid_specials` 0.0011818408966064
(525) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69653 and class = 'Cruise') OR (item_id = 1025 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0010318756103516
(526) DESCRIBE `cruiselines` 0.0018839836120605
(527) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00032210350036621
(528) DESCRIBE `orchid_image` 0.001596212387085
(529) DESCRIBE `cruiselines` 0.0017621517181396
(530) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00031614303588867
(531) DESCRIBE `cruises` 0.0025179386138916
(532) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70744') 0.00030684471130371
(533) DESCRIBE `ships` 0.002708911895752
(534) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 454))) 0.00038719177246094
(535) DESCRIBE `ships` 0.0024869441986084
(536) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '454') 0.00031900405883789
(537) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(538) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(539) DESCRIBE `itineraries` 0.0013258457183838
(540) DESCRIBE `ports` 0.0012791156768799
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00033807754516602
(542) DESCRIBE `ports` 0.0013270378112793
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00029087066650391
(544) DESCRIBE `ports` 0.002025842666626
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00031709671020508
(546) DESCRIBE `sailingdates` 0.0011460781097412
(547) DESCRIBE `ports` 0.0014300346374512
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00030803680419922
(549) DESCRIBE `ports` 0.0013189315795898
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00034618377685547
(551) DESCRIBE `ports` 0.0017578601837158
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00041317939758301
(553) DESCRIBE `ports` 0.0013091564178467
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00029611587524414
(555) DESCRIBE `ports` 0.0013279914855957
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00030183792114258
(557) DESCRIBE `ports` 0.0014209747314453
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00030684471130371
(559) DESCRIBE `ports` 0.0013730525970459
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00031304359436035
(561) DESCRIBE `ports` 0.0012660026550293
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00028586387634277
(563) DESCRIBE `ports` 0.0012609958648682
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.0003058910369873
(565) DESCRIBE `ports` 0.0012969970703125
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00028586387634277
(567) DESCRIBE `ports` 0.0012819766998291
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00030612945556641
(569) DESCRIBE `ports` 0.0013248920440674
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00027799606323242
(571) DESCRIBE `ports` 0.0013191699981689
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.0003960132598877
(573) DESCRIBE `ports` 0.0014369487762451
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00029397010803223
(575) DESCRIBE `avid_specials` 0.0013220310211182
(576) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70744 and class = 'Cruise') OR (item_id = 454 AND class = 'Ship') OR (item_id = 12 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.0010461807250977
(577) DESCRIBE `cruiselines` 0.0019199848175049
(578) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00036406517028809
(579) DESCRIBE `orchid_image` 0.0015971660614014
(580) DESCRIBE `cruiselines` 0.0016160011291504
(581) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.0003349781036377
(582) DESCRIBE `cruiselines` 0.0023870468139648
(583) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '19', '26', '77', '23', '7', '12', '20', '8', '18', '171', '221', '144', '101', '31', '103', '50', '131', '96', '29', '239', '15', '258', '191', '33', '206', '91', '37', '16', '120', '114', '24', '262', '36', '268', '14', '28', '174', '110', '208', '156', '187', '141', '153', '118', '49', '151', '211', '30', '216', '181', '88', '4', '212', '264', '225', '238', '115', '159', '140', '184', '249', '90', '230', '113', '213', '182', '276', '136', '261', '57', '64', '237', '47', '188', '180', '35', '248', '232', '95', '73', '209', '231', '52', '105', '116', '82', '219', '132', '146', '59', '119', '134', '244', '195', '196', '168', '240', '170', '229', '256', '204')) ORDER BY FIND_IN_SET(id, '183,218,19,26,77,23,7,12,20,8,18,171,221,144,101,31,103,50,131,96,29,239,15,258,191,33,206,91,37,16,120,114,24,262,36,268,14,28,174,110,208,156,187,141,153,118,49,151,211,30,216,181,88,4,212,264,225,238,115,159,140,184,249,90,230,113,213,182,276,136,261,57,64,237,47,188,180,35,248,232,95,73,209,231,52,105,116,82,219,132,146,59,119,134,244,195,196,168,240,170,229,256,204') 0.0064358711242676
(584) DESCRIBE `ships` 0.0035150051116943
(585) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1127', '1555', '974', '1032', '797', '207', '1292', '1205', '977', '258', '1291', '1199', '1599', '1359', '349', '454', '439', '1135', '333', '1272', '404', '780', '855', '986', '1677', '1067', '265', '1237', '1594', '1607', '837', '37', '38', '770', '34', '817', '1588', '22', '27', '378', '21', '31', '461', '28', '393', '407', '1376', '542', '39', '1012', '30', '36', '43', '1245', '573', '1320', '970', '726', '1402', '1552', '66', '585', '1424', '35', '1744', '330', '332', '1768', '792', '1284', '1413', '1415', '1422', '882', '1411', '113', '1420', '462', '1419', '1423', '1176', '1410', '1418', '1421', '1587', '711', '24', '1574', '11', '455', '1405', '1773', '9', '10', '580', '722', '1760', '160', '434', '1215', '503', '1021', '1193', '162', '739', '766', '1141', '78', '325', '452', '658', '81', '1682', '69', '1572', '639', '674', '1008', '1372', '1454', '3', '1095', '163', '678', '338', '852', '1168', '1412', '1373', '1319', '1408', '335', '1678', '124', '253', '850', '635', '1172', '1302', '1569', '70', '116', '340', '1159', '111', '285', '1236', '348', '451', '553', '1259', '944', '966', '968', '4', '390', '1108', '1260', '25', '148', '386', '626', '748', '1266', '385', '651', '716', '314', '616', '683', '791', '1330', '63', '324', '389', '768', '784', '851', '1088', '1323', '405', '508', '1195', '1325', '1455', '1562', '286', '406', '590', '749', '874', '1632', '1645', '375', '559', '582', '1068', '1672', '84', '108', '287', '291', '327', '483', '526', '1301', '1575', '119', '467', '1208', '1742', '98', '854', '290', '394', '401', '657', '1398', '45', '421', '1492', '1571', '485', '1064', '1586', '150', '151', '652', '776', '147', '152', '704', '114', '123', '149', '341', '403', '1308', '223', '520', '547', '775', '883', '954', '1268', '1460', '1269', '1289', '1539', '1711', '885', '1321', '1389', '1724', '262', '1139', '1486', '1601', '1722', '105', '715', '958', '1557', '1717', '351', '1471', '75', '717', '1243', '1738', '545', '790', '1143', '1270', '1282', '1303', '1326', '1327', '1437', '441', '1771', '479', '516', '1040', '1075', '1214', '1526', '1579', '1704', '93', '517', '574', '796', '823', '1013', '1151', '1679', '205', '665', '673', '701', '818', '993', '1063', '1367', '1561', '82', '988', '1218', '1540', '212', '1262', '1318', '1676', '1740', '743', '1566', '1602', '1766', '751', '769', '1043', '1344', '201', '266', '884', '1137', '1144', '1157', '1216', '1217', '1343', '1409', '1721', '795', '1160', '1223', '1226', '1283', '1348', '14', '1027', '1029', '1073', '1229', '1452', '1453', '1604', '1716', '448', '669', '738', '1025', '1090', '1136', '1163', '1253', '1426', '601', '732', '811', '1241', '1449', '1619', '610', '905', '1019', '1055', '1247', '1448', '1496', '1673', '1713', '1715', '74', '417', '996', '997', '1026', '1145', '1152', '1188', '1233', '1358', '1458', '1714', '643', '1351', '1743', '836', '888', '973', '1034', '1149', '1150', '1231', '1345', '1366', '1404', '1474', '1516', '1609', '1663', '1772', '618', '1049', '1196', '1222', '1322', '1360', '1361', '1362', '1368', '1459', '1522', '1647', '1730', '423', '453', '494', '666', '709', '920', '921', '927', '931', '1004', '1047', '1230', '1354', '1470', '1508', '1627', '1729', '208', '914', '923', '1017', '1407', '1517', '1518', '1567', '1580', '663', '915', '916', '926', '930', '1003', '1037', '1042', '1072', '1138', '1140', '1489', '1505', '1606', '1649', '1674', '1708', '1751', '352', '499', '695', '703', '924', '972', '1001', '1020', '1187', '1352', '1521', '1593', '1596', '1723', '422', '493', '671', '938', '1005', '1054', '1154', '1175', '1444', '1514', '1767', '781', '937', '1051', '1515', '1650', '1681', '1684', '672', '1092', '1254', '1445', '1463')) ORDER BY FIND_IN_SET(id, '1761,1554,1127,1555,974,1032,797,207,1292,1205,977,258,1291,1199,1599,1359,349,454,439,1135,333,1272,404,780,855,986,1677,1067,265,1237,1594,1607,837,37,38,770,34,817,1588,22,27,378,21,31,461,28,393,407,1376,542,39,1012,30,36,43,1245,573,1320,970,726,1402,1552,66,585,1424,35,1744,330,332,1768,792,1284,1413,1415,1422,882,1411,113,1420,462,1419,1423,1176,1410,1418,1421,1587,711,24,1574,11,455,1405,1773,9,10,580,722,1760,160,434,1215,503,1021,1193,162,739,766,1141,78,325,452,658,81,1682,69,1572,639,674,1008,1372,1454,3,1095,163,678,338,852,1168,1412,1373,1319,1408,335,1678,124,253,850,635,1172,1302,1569,70,116,340,1159,111,285,1236,348,451,553,1259,944,966,968,4,390,1108,1260,25,148,386,626,748,1266,385,651,716,314,616,683,791,1330,63,324,389,768,784,851,1088,1323,405,508,1195,1325,1455,1562,286,406,590,749,874,1632,1645,375,559,582,1068,1672,84,108,287,291,327,483,526,1301,1575,119,467,1208,1742,98,854,290,394,401,657,1398,45,421,1492,1571,485,1064,1586,150,151,652,776,147,152,704,114,123,149,341,403,1308,223,520,547,775,883,954,1268,1460,1269,1289,1539,1711,885,1321,1389,1724,262,1139,1486,1601,1722,105,715,958,1557,1717,351,1471,75,717,1243,1738,545,790,1143,1270,1282,1303,1326,1327,1437,441,1771,479,516,1040,1075,1214,1526,1579,1704,93,517,574,796,823,1013,1151,1679,205,665,673,701,818,993,1063,1367,1561,82,988,1218,1540,212,1262,1318,1676,1740,743,1566,1602,1766,751,769,1043,1344,201,266,884,1137,1144,1157,1216,1217,1343,1409,1721,795,1160,1223,1226,1283,1348,14,1027,1029,1073,1229,1452,1453,1604,1716,448,669,738,1025,1090,1136,1163,1253,1426,601,732,811,1241,1449,1619,610,905,1019,1055,1247,1448,1496,1673,1713,1715,74,417,996,997,1026,1145,1152,1188,1233,1358,1458,1714,643,1351,1743,836,888,973,1034,1149,1150,1231,1345,1366,1404,1474,1516,1609,1663,1772,618,1049,1196,1222,1322,1360,1361,1362,1368,1459,1522,1647,1730,423,453,494,666,709,920,921,927,931,1004,1047,1230,1354,1470,1508,1627,1729,208,914,923,1017,1407,1517,1518,1567,1580,663,915,916,926,930,1003,1037,1042,1072,1138,1140,1489,1505,1606,1649,1674,1708,1751,352,499,695,703,924,972,1001,1020,1187,1352,1521,1593,1596,1723,422,493,671,938,1005,1054,1154,1175,1444,1514,1767,781,937,1051,1515,1650,1681,1684,672,1092,1254,1445,1463') 0.044044971466064
(586) DESCRIBE `cruisetypes` 0.0017540454864502
(587) DESCRIBE `destinations` 0.0021121501922607
(588) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '35', '12', '22', '54', '25', '37', '9', '2', '43', '8', '39', '53', '28', '26', '38', '55', '40', '7', '11', '21', '48', '30', '49', '45', '29', '44', '56', '34', '10', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,35,12,22,54,25,37,9,2,43,8,39,53,28,26,38,55,40,7,11,21,48,30,49,45,29,44,56,34,10,52,32,46') 0.0018310546875