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

Total elapsed time: 1.2604434490204

# Query Time
(1) connect 0.0008399486541748
(2) DESCRIBE `cruises` 0.0041229724884033
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75542, 75543, 75544, 75545, 68724, 75546, 68726, 75547, 68727, 75548)) ORDER BY FIND_IN_SET(id, '75542,75543,75544,75545,68724,75546,68726,75547,68727,75548') 0.0024011135101318
(4) DESCRIBE `cruises` 0.0049200057983398
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75542') 0.00011992454528809
(6) DESCRIBE `ships` 0.0040562152862549
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.0011539459228516
(8) DESCRIBE `ships` 0.0040929317474365
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00048112869262695
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033116340637207
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031590461730957
(12) DESCRIBE `itineraries` 0.0019509792327881
(13) DESCRIBE `ports` 0.0016207695007324
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00048995018005371
(15) DESCRIBE `ports` 0.0019831657409668
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0
(17) DESCRIBE `ports` 0.0020060539245605
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00046682357788086
(19) DESCRIBE `sailingdates` 0.0017709732055664
(20) DESCRIBE `ports` 0.0022759437561035
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00056290626525879
(22) DESCRIBE `ports` 0.0021350383758545
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00047898292541504
(24) DESCRIBE `ports` 0.0021111965179443
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00048303604125977
(26) DESCRIBE `ports` 0.0021131038665771
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00075984001159668
(28) DESCRIBE `ports` 0.0021300315856934
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00028800964355469
(30) DESCRIBE `ports` 0.0018601417541504
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00075984001159668
(32) DESCRIBE `ports` 0.0019080638885498
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00071406364440918
(34) DESCRIBE `ports` 0.0019888877868652
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00044512748718262
(36) DESCRIBE `ports` 0.0018949508666992
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 696))) 0.000518798828125
(38) DESCRIBE `ports` 0.0018150806427002
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '696') 0.00039505958557129
(40) DESCRIBE `ports` 0.0021021366119385
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0004570484161377
(42) DESCRIBE `ports` 0.0022680759429932
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00043201446533203
(44) DESCRIBE `ports` 0.0023670196533203
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0011270046234131
(46) DESCRIBE `ports` 0.0033359527587891
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00049400329589844
(48) DESCRIBE `ports` 0.0020039081573486
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00069499015808105
(50) DESCRIBE `ports` 0.0023090839385986
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00058197975158691
(52) DESCRIBE `avid_specials` 0.0021350383758545
(53) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75542 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0024678707122803
(54) DESCRIBE `cruiselines` 0.0040130615234375
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00057792663574219
(56) DESCRIBE `orchid_image` 0.0019471645355225
(57) DESCRIBE `cruiselines` 0.0025589466094971
(58) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00041985511779785
(59) DESCRIBE `cruises` 0.0034070014953613
(60) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75543') 0.00051212310791016
(61) DESCRIBE `ships` 0.0036299228668213
(62) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00061607360839844
(63) DESCRIBE `ships` 0.0036530494689941
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00047898292541504
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031805038452148
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030303001403809
(67) DESCRIBE `itineraries` 0.0017709732055664
(68) DESCRIBE `ports` 0.0018980503082275
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046420097351074
(70) DESCRIBE `ports` 0.0021381378173828
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00049018859863281
(72) DESCRIBE `ports` 0.0017480850219727
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00039410591125488
(74) DESCRIBE `sailingdates` 0.0016689300537109
(75) DESCRIBE `ports` 0.0023250579833984
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046920776367188
(77) DESCRIBE `ports` 0.0020511150360107
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040507316589355
(79) DESCRIBE `ports` 0.0018100738525391
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) 0.0011110305786133
(81) DESCRIBE `ports` 0.0015981197357178
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') 0.00094103813171387
(83) DESCRIBE `ports` 0.0012118816375732
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00041103363037109
(85) DESCRIBE `ports` 0.0018820762634277
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00037789344787598
(87) DESCRIBE `ports` 0.0018911361694336
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00043106079101562
(89) DESCRIBE `ports` 0.0017471313476562
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00058388710021973
(91) DESCRIBE `ports` 0.0025539398193359
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 910))) 0.00042510032653809
(93) DESCRIBE `ports` 0.0018339157104492
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '910') 0.00039100646972656
(95) DESCRIBE `ports` 0.0018448829650879
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00045490264892578
(97) DESCRIBE `ports` 0.001859188079834
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00039315223693848
(99) DESCRIBE `ports` 0.001568078994751
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00036811828613281
(101) DESCRIBE `ports` 0.0017199516296387
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.0002129077911377
(103) DESCRIBE `ports` 0.0013349056243896
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00041317939758301
(105) DESCRIBE `ports` 0.0010969638824463
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0003359317779541
(107) DESCRIBE `ports` 0.0018129348754883
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00045585632324219
(109) DESCRIBE `ports` 0.0019161701202393
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00048685073852539
(111) DESCRIBE `ports` 0.0018730163574219
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00047802925109863
(113) DESCRIBE `ports` 0.0018742084503174
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00043201446533203
(115) DESCRIBE `avid_specials` 0.0016510486602783
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75543 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0013580322265625
(117) DESCRIBE `cruiselines` 0.0026650428771973
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00063896179199219
(119) DESCRIBE `orchid_image` 0.0021650791168213
(120) DESCRIBE `cruiselines` 0.0028259754180908
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00400710105896
(122) DESCRIBE `cruises` 0.0033340454101562
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75544') 0.00046300888061523
(124) DESCRIBE `ships` 0.0035500526428223
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.0005950927734375
(126) DESCRIBE `ships` 0.0038430690765381
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00051116943359375
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032401084899902
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030612945556641
(130) DESCRIBE `itineraries` 0.0017931461334229
(131) DESCRIBE `ports` 0.0019590854644775
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0004730224609375
(133) DESCRIBE `ports` 0.0016579627990723
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00024604797363281
(135) DESCRIBE `ports` 0.0018520355224609
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00077199935913086
(137) DESCRIBE `sailingdates` 0.0015621185302734
(138) DESCRIBE `ports` 0.0013461112976074
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00043988227844238
(140) DESCRIBE `ports` 0.0019118785858154
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00044798851013184
(142) DESCRIBE `ports` 0.0022690296173096
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.0004889965057373
(144) DESCRIBE `ports` 0.0018711090087891
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00038385391235352
(146) DESCRIBE `ports` 0.0024030208587646
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 584))) 0.0004270076751709
(148) DESCRIBE `ports` 0.0015590190887451
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '584') 0.00031113624572754
(150) DESCRIBE `ports` 0.0013058185577393
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00029897689819336
(152) DESCRIBE `ports` 0.0014290809631348
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00032305717468262
(154) DESCRIBE `ports` 0.0014259815216064
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00035881996154785
(156) DESCRIBE `ports` 0.0014140605926514
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00030422210693359
(158) DESCRIBE `ports` 0.0014350414276123
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.0003819465637207
(160) DESCRIBE `ports` 0.0013949871063232
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00033378601074219
(162) DESCRIBE `ports` 0.0016088485717773
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00033807754516602
(164) DESCRIBE `ports` 0.001399040222168
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00034594535827637
(166) DESCRIBE `ports` 0.0014941692352295
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038003921508789
(168) DESCRIBE `ports` 0.0017721652984619
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00044703483581543
(170) DESCRIBE `avid_specials` 0.0016570091247559
(171) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75544 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0013878345489502
(172) DESCRIBE `cruiselines` 0.002924919128418
(173) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00029110908508301
(174) DESCRIBE `orchid_image` 0.0020442008972168
(175) DESCRIBE `cruiselines` 0.0025291442871094
(176) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 8.8214874267578E-6
(177) DESCRIBE `cruises` 0.003795862197876
(178) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75545') 0.00051498413085938
(179) DESCRIBE `ships` 0.0038511753082275
(180) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00070405006408691
(181) DESCRIBE `ships` 0.0038158893585205
(182) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00053000450134277
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033378601074219
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031399726867676
(185) DESCRIBE `itineraries` 0.0018010139465332
(186) DESCRIBE `ports` 0.0018990039825439
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00051116943359375
(188) DESCRIBE `ports` 0.0017151832580566
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045490264892578
(190) DESCRIBE `ports` 0.0019960403442383
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00062894821166992
(192) DESCRIBE `sailingdates` 0.0019180774688721
(193) DESCRIBE `ports` 0.0022990703582764
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00061702728271484
(195) DESCRIBE `ports` 0.0019230842590332
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00059795379638672
(197) DESCRIBE `ports` 0.0019900798797607
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00056195259094238
(199) DESCRIBE `ports` 0.0019838809967041
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00046086311340332
(201) DESCRIBE `ports` 0.001859188079834
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00052905082702637
(203) DESCRIBE `ports` 0.0017321109771729
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0003821849822998
(205) DESCRIBE `ports` 0.0018179416656494
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00038409233093262
(207) DESCRIBE `ports` 0.0016968250274658
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00048303604125977
(209) DESCRIBE `ports` 0.0018658638000488
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00055885314941406
(211) DESCRIBE `ports` 0.0019359588623047
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00048708915710449
(213) DESCRIBE `ports` 0.0019152164459229
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00056195259094238
(215) DESCRIBE `ports` 0.0019659996032715
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00048089027404785
(217) DESCRIBE `ports` 0.0019021034240723
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00053596496582031
(219) DESCRIBE `ports` 0.0019211769104004
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.00043988227844238
(221) DESCRIBE `ports` 0.0018930435180664
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005800724029541
(223) DESCRIBE `ports` 0.0018370151519775
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00063800811767578
(225) DESCRIBE `ports` 0.0020079612731934
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00063395500183105
(227) DESCRIBE `ports` 0.0019340515136719
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00042891502380371
(229) DESCRIBE `avid_specials` 0.0059280395507812
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75545 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0021469593048096
(231) DESCRIBE `cruiselines` 0.0030579566955566
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00058197975158691
(233) DESCRIBE `orchid_image` 0.0021321773529053
(234) DESCRIBE `cruiselines` 0.002769947052002
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00053811073303223
(236) DESCRIBE `cruises` 0.0039792060852051
(237) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68724') 0.00073409080505371
(238) DESCRIBE `ships` 0.0096449851989746
(239) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00079107284545898
(240) DESCRIBE `ships` 0.0055530071258545
(241) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00055718421936035
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0009610652923584
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00057601928710938
(244) DESCRIBE `itineraries` 0.0026528835296631
(245) DESCRIBE `ports` 0.0022070407867432
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00094699859619141
(247) DESCRIBE `ports` 0.0030238628387451
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0005500316619873
(249) DESCRIBE `ports` 0.003338098526001
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00053882598876953
(251) DESCRIBE `sailingdates` 0.0016031265258789
(252) DESCRIBE `ports` 0.0031149387359619
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00058102607727051
(254) DESCRIBE `ports` 0.0026288032531738
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00045680999755859
(256) DESCRIBE `ports` 0.0020031929016113
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.0003960132598877
(258) DESCRIBE `ports` 0.0020921230316162
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.0004889965057373
(260) DESCRIBE `ports` 0.00205397605896
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00048184394836426
(262) DESCRIBE `ports` 0.0026240348815918
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00089406967163086
(264) DESCRIBE `ports` 0.0024998188018799
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.0013561248779297
(266) DESCRIBE `ports` 0.002432107925415
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00085902214050293
(268) DESCRIBE `ports` 0.0026791095733643
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00084495544433594
(270) DESCRIBE `ports` 0.0032651424407959
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00059700012207031
(272) DESCRIBE `ports` 0.0018801689147949
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00057888031005859
(274) DESCRIBE `ports` 0.0026998519897461
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0011458396911621
(276) DESCRIBE `ports` 0.0031280517578125
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0011160373687744
(278) DESCRIBE `ports` 0.0023529529571533
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00035381317138672
(280) DESCRIBE `ports` 0.0018899440765381
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.0030601024627686
(282) DESCRIBE `ports` 0.0023090839385986
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00078701972961426
(284) DESCRIBE `ports` 0.0020890235900879
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00051307678222656
(286) DESCRIBE `ports` 0.0019769668579102
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00050497055053711
(288) DESCRIBE `avid_specials` 0.0018432140350342
(289) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68724 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0018160343170166
(290) DESCRIBE `cruiselines` 0.0028958320617676
(291) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00057077407836914
(292) DESCRIBE `orchid_image` 0.0022430419921875
(293) DESCRIBE `cruiselines` 0.0029981136322021
(294) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00050091743469238
(295) DESCRIBE `cruises` 0.005375862121582
(296) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75546') 0.00068187713623047
(297) DESCRIBE `ships` 0.0040228366851807
(298) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00060081481933594
(299) DESCRIBE `ships` 0.0086169242858887
(300) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00053715705871582
(301) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040197372436523
(302) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033712387084961
(303) DESCRIBE `itineraries` 0.0020101070404053
(304) DESCRIBE `ports` 0.0023250579833984
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00071215629577637
(306) DESCRIBE `ports` 0.0021400451660156
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00058078765869141
(308) DESCRIBE `ports` 0.00295090675354
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0010941028594971
(310) DESCRIBE `sailingdates` 0.0013358592987061
(311) DESCRIBE `ports` 0.0022809505462646
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00049781799316406
(313) DESCRIBE `ports` 0.0019791126251221
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0004730224609375
(315) DESCRIBE `ports` 0.0024409294128418
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00057291984558105
(317) DESCRIBE `ports` 0.0020921230316162
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00047802925109863
(319) DESCRIBE `ports` 0.0019099712371826
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00047397613525391
(321) DESCRIBE `ports` 0.0020179748535156
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00045394897460938
(323) DESCRIBE `ports` 0.0018799304962158
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00056719779968262
(325) DESCRIBE `ports` 0.0039560794830322
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0002899169921875
(327) DESCRIBE `ports` 0.0022919178009033
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0002281665802002
(329) DESCRIBE `ports` 0.0022060871124268
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00066494941711426
(331) DESCRIBE `ports` 0.0041329860687256
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00047492980957031
(333) DESCRIBE `ports` 0.0017058849334717
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00025606155395508
(335) DESCRIBE `ports` 0.0015230178833008
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4120))) 0.00045204162597656
(337) DESCRIBE `ports` 0.0022711753845215
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4120') 0.00030899047851562
(339) DESCRIBE `ports` 0.0045690536499023
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00050187110900879
(341) DESCRIBE `ports` 0.0016520023345947
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0026969909667969
(343) DESCRIBE `ports` 0.0034160614013672
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.0003669261932373
(345) DESCRIBE `ports` 0.0018088817596436
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00033903121948242
(347) DESCRIBE `ports` 0.001323938369751
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032997131347656
(349) DESCRIBE `ports` 0.0015039443969727
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0010099411010742
(351) DESCRIBE `avid_specials` 0.0020151138305664
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75546 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.01811695098877
(353) DESCRIBE `cruiselines` 0.010866165161133
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00070595741271973
(355) DESCRIBE `orchid_image` 0.0024459362030029
(356) DESCRIBE `cruiselines` 0.0094239711761475
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0071020126342773
(358) DESCRIBE `cruises` 0.003262996673584
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68726') 0.0052318572998047
(360) DESCRIBE `ships` 0.0038650035858154
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00075697898864746
(362) DESCRIBE `ships` 0.0040290355682373
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00045895576477051
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033807754516602
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032591819763184
(366) DESCRIBE `itineraries` 0.0020420551300049
(367) DESCRIBE `ports` 0.0021741390228271
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00053000450134277
(369) DESCRIBE `ports` 0.0019881725311279
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00053191184997559
(371) DESCRIBE `ports` 0.0024561882019043
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00054693222045898
(373) DESCRIBE `sailingdates` 0.0017778873443604
(374) DESCRIBE `ports` 0.0022509098052979
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0010819435119629
(376) DESCRIBE `ports` 0.008141040802002
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044584274291992
(378) DESCRIBE `ports` 0.001863956451416
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00055694580078125
(380) DESCRIBE `ports` 0.0020160675048828
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00054121017456055
(382) DESCRIBE `ports` 0.0019848346710205
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00049901008605957
(384) DESCRIBE `ports` 0.0018019676208496
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0076930522918701
(386) DESCRIBE `ports` 0.0017988681793213
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00050902366638184
(388) DESCRIBE `ports` 0.0015981197357178
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.0004580020904541
(390) DESCRIBE `ports` 0.0019140243530273
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00046515464782715
(392) DESCRIBE `ports` 0.0015480518341064
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0020110607147217
(394) DESCRIBE `ports` 0.0018339157104492
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.0064899921417236
(396) DESCRIBE `ports` 0.0018620491027832
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00044512748718262
(398) DESCRIBE `ports` 0.0028200149536133
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00053787231445312
(400) DESCRIBE `ports` 0.0017788410186768
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.012534141540527
(402) DESCRIBE `ports` 0.002918004989624
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0072438716888428
(404) DESCRIBE `ports` 0.002997875213623
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0011000633239746
(406) DESCRIBE `avid_specials` 0.0020530223846436
(407) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68726 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0084869861602783
(408) DESCRIBE `cruiselines` 0.0038461685180664
(409) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00056004524230957
(410) DESCRIBE `orchid_image` 0.01107120513916
(411) DESCRIBE `cruiselines` 0.0027189254760742
(412) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00054001808166504
(413) DESCRIBE `cruises` 0.0046689510345459
(414) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75547') 0.0026021003723145
(415) DESCRIBE `ships` 0.0059189796447754
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.0034749507904053
(417) DESCRIBE `ships` 0.0049951076507568
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.024787902832031
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003209114074707
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035691261291504
(421) DESCRIBE `itineraries` 0.0028889179229736
(422) DESCRIBE `ports` 0.0024149417877197
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0071430206298828
(424) DESCRIBE `ports` 0.0021178722381592
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00054097175598145
(426) DESCRIBE `ports` 0.0020439624786377
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00047397613525391
(428) DESCRIBE `sailingdates` 0.0017850399017334
(429) DESCRIBE `ports` 0.008469820022583
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00051188468933105
(431) DESCRIBE `ports` 0.0017390251159668
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00039100646972656
(433) DESCRIBE `ports` 0.0017311573028564
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0022761821746826
(435) DESCRIBE `ports` 0.0019350051879883
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0015130043029785
(437) DESCRIBE `ports` 0.0055670738220215
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0025899410247803
(439) DESCRIBE `ports` 0.014633893966675
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00054097175598145
(441) DESCRIBE `ports` 0.0031988620758057
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00060701370239258
(443) DESCRIBE `ports` 0.0023469924926758
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.0098540782928467
(445) DESCRIBE `ports` 0.0023238658905029
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.0086040496826172
(447) DESCRIBE `ports` 0.0026340484619141
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0005040168762207
(449) DESCRIBE `ports` 0.0020451545715332
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00054097175598145
(451) DESCRIBE `ports` 0.0019838809967041
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0059010982513428
(453) DESCRIBE `ports` 0.0019209384918213
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0074172019958496
(455) DESCRIBE `ports` 0.0028641223907471
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0064289569854736
(457) DESCRIBE `ports` 0.0016441345214844
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0009760856628418
(459) DESCRIBE `ports` 0.0092599391937256
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00045490264892578
(461) DESCRIBE `ports` 0.0018539428710938
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00050020217895508
(463) DESCRIBE `ports` 0.0019629001617432
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00040912628173828
(465) DESCRIBE `avid_specials` 0.011816024780273
(466) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75547 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0019049644470215
(467) DESCRIBE `cruiselines` 0.0028929710388184
(468) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00061988830566406
(469) DESCRIBE `orchid_image` 0.002269983291626
(470) DESCRIBE `cruiselines` 0.0089819431304932
(471) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00052714347839355
(472) DESCRIBE `cruises` 0.0041821002960205
(473) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68727') 0.00052189826965332
(474) DESCRIBE `ships` 0.0041990280151367
(475) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.003040075302124
(476) DESCRIBE `ships` 0.004647970199585
(477) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.011667013168335
(478) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003659725189209
(479) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032997131347656
(480) DESCRIBE `itineraries` 0.0020442008972168
(481) DESCRIBE `ports` 0.0019099712371826
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049209594726562
(483) DESCRIBE `ports` 0.0019350051879883
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00047898292541504
(485) DESCRIBE `ports` 0.0020020008087158
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0063049793243408
(487) DESCRIBE `sailingdates` 0.0016629695892334
(488) DESCRIBE `ports` 0.0018858909606934
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00053095817565918
(490) DESCRIBE `ports` 0.0018148422241211
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0098519325256348
(492) DESCRIBE `ports` 0.0018839836120605
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00051498413085938
(494) DESCRIBE `ports` 0.0016341209411621
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00046801567077637
(496) DESCRIBE `ports` 0.0019299983978271
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00049686431884766
(498) DESCRIBE `ports` 0.0019049644470215
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.010092973709106
(500) DESCRIBE `ports` 0.0021631717681885
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00053501129150391
(502) DESCRIBE `ports` 0.0019559860229492
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00076389312744141
(504) DESCRIBE `ports` 0.0018420219421387
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00053191184997559
(506) DESCRIBE `ports` 0.002856969833374
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0076520442962646
(508) DESCRIBE `ports` 0.0019931793212891
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00087690353393555
(510) DESCRIBE `ports` 0.0019421577453613
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0059399604797363
(512) DESCRIBE `ports` 0.00205397605896
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00050187110900879
(514) DESCRIBE `ports` 0.0020120143890381
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.0018119812011719
(516) DESCRIBE `ports` 0.0020968914031982
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.006126880645752
(518) DESCRIBE `ports` 0.00325608253479
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0004889965057373
(520) DESCRIBE `ports` 0.0013759136199951
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0041689872741699
(522) DESCRIBE `ports` 0.0025279521942139
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0005190372467041
(524) DESCRIBE `ports` 0.0028970241546631
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0066359043121338
(526) DESCRIBE `ports` 0.0029590129852295
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00048184394836426
(528) DESCRIBE `ports` 0.0062499046325684
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00084495544433594
(530) DESCRIBE `ports` 0.0038840770721436
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0031859874725342
(532) DESCRIBE `avid_specials` 0.0013949871063232
(533) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68727 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0019521713256836
(534) DESCRIBE `cruiselines` 0.0028040409088135
(535) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00055480003356934
(536) DESCRIBE `orchid_image` 0.0023031234741211
(537) DESCRIBE `cruiselines` 0.0056459903717041
(538) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00075221061706543
(539) DESCRIBE `cruises` 0.0071671009063721
(540) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75548') 0.0006258487701416
(541) DESCRIBE `ships` 0.0054781436920166
(542) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00068092346191406
(543) DESCRIBE `ships` 0.0045080184936523
(544) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00059986114501953
(545) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037598609924316
(546) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032997131347656
(547) DESCRIBE `itineraries` 0.002655029296875
(548) DESCRIBE `ports` 0.0021700859069824
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00055289268493652
(550) DESCRIBE `ports` 0.0019350051879883
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00056195259094238
(552) DESCRIBE `ports` 0.0022270679473877
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00047183036804199
(554) DESCRIBE `sailingdates` 0.0015738010406494
(555) DESCRIBE `ports` 0.0021309852600098
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00060105323791504
(557) DESCRIBE `ports` 0.0020241737365723
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00047397613525391
(559) DESCRIBE `ports` 0.0019350051879883
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00063991546630859
(561) DESCRIBE `ports` 0.0021591186523438
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00055909156799316
(563) DESCRIBE `ports` 0.0022709369659424
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.0015490055084229
(565) DESCRIBE `ports` 0.0025200843811035
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.0004880428314209
(567) DESCRIBE `ports` 0.0017960071563721
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00060701370239258
(569) DESCRIBE `ports` 0.0026299953460693
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.0014410018920898
(571) DESCRIBE `ports` 0.0027449131011963
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2171))) 0.0006110668182373
(573) DESCRIBE `ports` 0.0022621154785156
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2171') 0.00067901611328125
(575) DESCRIBE `ports` 0.0018880367279053
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00058913230895996
(577) DESCRIBE `ports` 0.0020201206207275
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00052714347839355
(579) DESCRIBE `avid_specials` 0.0017650127410889
(580) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75548 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.002068042755127
(581) DESCRIBE `cruiselines` 0.0030128955841064
(582) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00062799453735352
(583) DESCRIBE `orchid_image` 0.0022239685058594
(584) DESCRIBE `cruiselines` 0.0028419494628906
(585) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00049495697021484
(586) DESCRIBE `ships` 0.004429817199707
(587) SELECT `ships`.* FROM `ships` WHERE (id IN ('1672', '616', '652')) ORDER BY FIND_IN_SET(id, '1672,616,652') 0.00072598457336426
(588) DESCRIBE `cruisetypes` 0.0025680065155029
(589) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '22') AND (cruises_and_specials.cruiseline_id = '151') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.044858932495117
(590) DESCRIBE `cruiselines` 0.0039548873901367
(591) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00056004524230957
(592) DESCRIBE `destinations` 0.0025808811187744
(593) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00065994262695312
(594) DESCRIBE `destinations` 0.0028610229492188
(595) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.0011129379272461
(596) DESCRIBE `cruiselines` 0.0033340454101562
(597) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0011370182037354