or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Cruise Ship Lingo? Look like a cruise expert before you get on the ship
  3. BREAKING NEWS FOR PRINCESS FANS: Register your interest now!!!
  4. Catch Up on Cruising: Latest News in bite size!
  5. Review: China – Part Two

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

Total elapsed time: 0.61995935440063

# Query Time
(1) connect 0.0013020038604736
(2) DESCRIBE `cruises` 0.0041170120239258
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73120, 73122, 75542, 75543, 75544, 75545, 68724, 75546, 68726, 75547)) ORDER BY FIND_IN_SET(id, '73120,73122,75542,75543,75544,75545,68724,75546,68726,75547') 0.0016520023345947
(4) DESCRIBE `cruises` 0.0026540756225586
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73120') 0.00034093856811523
(6) DESCRIBE `ships` 0.0026218891143799
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00035285949707031
(8) DESCRIBE `ships` 0.0029191970825195
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00034284591674805
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052094459533691
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046205520629883
(12) DESCRIBE `itineraries` 0.0019629001617432
(13) DESCRIBE `ports` 0.0015671253204346
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00043416023254395
(15) DESCRIBE `ports` 0.0018038749694824
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00037813186645508
(17) DESCRIBE `ports` 0.0016858577728271
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0003209114074707
(19) DESCRIBE `sailingdates` 0.0011270046234131
(20) DESCRIBE `ports` 0.0016801357269287
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00033402442932129
(22) DESCRIBE `ports` 0.001323938369751
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027704238891602
(24) DESCRIBE `ports` 0.0013089179992676
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00030899047851562
(26) DESCRIBE `ports` 0.0013020038604736
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00027704238891602
(28) DESCRIBE `ports` 0.0012660026550293
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00066804885864258
(30) DESCRIBE `ports` 0.0012760162353516
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00027298927307129
(32) DESCRIBE `ports` 0.0013918876647949
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1832))) 0.00036501884460449
(34) DESCRIBE `ports` 0.0017781257629395
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1832') 0.00043392181396484
(36) DESCRIBE `ports` 0.0018060207366943
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00039291381835938
(38) DESCRIBE `ports` 0.0018570423126221
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00035905838012695
(40) DESCRIBE `ports` 0.0015408992767334
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00035190582275391
(42) DESCRIBE `ports` 0.0014510154724121
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00035190582275391
(44) DESCRIBE `ports` 0.0018379688262939
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00040006637573242
(46) DESCRIBE `ports` 0.0014181137084961
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0003058910369873
(48) DESCRIBE `ports` 0.0012290477752686
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030708312988281
(50) DESCRIBE `ports` 0.0012979507446289
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00034189224243164
(52) DESCRIBE `avid_specials` 0.0011680126190186
(53) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73120 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.0012390613555908
(54) DESCRIBE `cruiselines` 0.0019180774688721
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0003049373626709
(56) DESCRIBE `orchid_image` 0.0014619827270508
(57) DESCRIBE `cruiselines` 0.0018279552459717
(58) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00028681755065918
(59) DESCRIBE `cruises` 0.0025219917297363
(60) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73122') 0.00047111511230469
(61) DESCRIBE `ships` 0.0027849674224854
(62) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.0003960132598877
(63) DESCRIBE `ships` 0.002439022064209
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00026488304138184
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026106834411621
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024819374084473
(67) DESCRIBE `itineraries` 0.0013082027435303
(68) DESCRIBE `ports` 0.0012631416320801
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031709671020508
(70) DESCRIBE `ports` 0.0013518333435059
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029993057250977
(72) DESCRIBE `ports` 0.0013370513916016
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028395652770996
(74) DESCRIBE `sailingdates` 0.0014338493347168
(75) DESCRIBE `ports` 0.0016560554504395
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041389465332031
(77) DESCRIBE `ports` 0.0014340877532959
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027799606323242
(79) DESCRIBE `ports` 0.0012979507446289
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1213))) 0.00028491020202637
(81) DESCRIBE `ports` 0.0012521743774414
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1213') 0.00026702880859375
(83) DESCRIBE `ports` 0.0012829303741455
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2171))) 0.00029993057250977
(85) DESCRIBE `ports` 0.0012290477752686
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2171') 0.00026392936706543
(87) DESCRIBE `ports` 0.0012331008911133
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00029277801513672
(89) DESCRIBE `ports` 0.0012319087982178
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0002901554107666
(91) DESCRIBE `ports` 0.0012331008911133
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0003049373626709
(93) DESCRIBE `ports` 0.0012350082397461
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00026297569274902
(95) DESCRIBE `ports` 0.001230001449585
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00029587745666504
(97) DESCRIBE `ports` 0.0012660026550293
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00026607513427734
(99) DESCRIBE `ports` 0.0012328624725342
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00032615661621094
(101) DESCRIBE `ports` 0.001284122467041
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00026512145996094
(103) DESCRIBE `ports` 0.0013489723205566
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00030684471130371
(105) DESCRIBE `ports` 0.0012609958648682
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00026392936706543
(107) DESCRIBE `ports` 0.0014221668243408
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028491020202637
(109) DESCRIBE `ports` 0.0019478797912598
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00031685829162598
(111) DESCRIBE `avid_specials` 0.0012738704681396
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73122 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.0010700225830078
(113) DESCRIBE `cruiselines` 0.0018749237060547
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00029587745666504
(115) DESCRIBE `orchid_image` 0.0014221668243408
(116) DESCRIBE `cruiselines` 0.0018181800842285
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00026512145996094
(118) DESCRIBE `cruises` 0.0024750232696533
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75542') 0.0002739429473877
(120) DESCRIBE `ships` 0.0024590492248535
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.0003349781036377
(122) DESCRIBE `ships` 0.0025620460510254
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.0002598762512207
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002601146697998
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025510787963867
(126) DESCRIBE `itineraries` 0.0012338161468506
(127) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75542') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071597099304199
(128) DESCRIBE `ports` 0.0013270378112793
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00030803680419922
(130) DESCRIBE `ports` 0.0012819766998291
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00030303001403809
(132) DESCRIBE `ports` 0.0012741088867188
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0002739429473877
(134) DESCRIBE `sailingdates` 0.0011041164398193
(135) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75542') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061702728271484
(136) DESCRIBE `ports` 0.0012631416320801
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00029206275939941
(138) DESCRIBE `ports` 0.001317024230957
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0002748966217041
(140) DESCRIBE `ports` 0.0012581348419189
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00029301643371582
(142) DESCRIBE `ports` 0.001317024230957
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.0002751350402832
(144) DESCRIBE `ports` 0.0013258457183838
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00030398368835449
(146) DESCRIBE `ports` 0.0012710094451904
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00027298927307129
(148) DESCRIBE `ports` 0.0012741088867188
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00030398368835449
(150) DESCRIBE `ports` 0.0012431144714355
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00027179718017578
(152) DESCRIBE `ports` 0.0012671947479248
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 696))) 0.00031590461730957
(154) DESCRIBE `ports` 0.0012381076812744
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '696') 0.00028204917907715
(156) DESCRIBE `ports` 0.0016078948974609
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00036120414733887
(158) DESCRIBE `ports` 0.0014009475708008
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00036907196044922
(160) DESCRIBE `ports` 0.0013070106506348
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00029301643371582
(162) DESCRIBE `ports` 0.0014188289642334
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00028109550476074
(164) DESCRIBE `ports` 0.0012450218200684
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030303001403809
(166) DESCRIBE `ports` 0.0013360977172852
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029802322387695
(168) DESCRIBE `avid_specials` 0.0011498928070068
(169) 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.00099301338195801
(170) DESCRIBE `cruiselines` 0.0018391609191895
(171) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00029897689819336
(172) DESCRIBE `orchid_image` 0.0014009475708008
(173) DESCRIBE `cruiselines` 0.0017669200897217
(174) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00027894973754883
(175) DESCRIBE `cruises` 0.0026388168334961
(176) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75543') 0.00034093856811523
(177) DESCRIBE `ships` 0.0027611255645752
(178) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00039911270141602
(179) DESCRIBE `ships` 0.0028579235076904
(180) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00041699409484863
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027990341186523
(183) DESCRIBE `itineraries` 0.0013940334320068
(184) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75543') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005640983581543
(185) DESCRIBE `ports` 0.0014150142669678
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004119873046875
(187) DESCRIBE `ports` 0.003760814666748
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032210350036621
(189) DESCRIBE `ports` 0.0012838840484619
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030803680419922
(191) DESCRIBE `sailingdates` 0.0011160373687744
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75543') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053310394287109
(193) DESCRIBE `ports` 0.0013279914855957
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030899047851562
(195) DESCRIBE `ports` 0.0012490749359131
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029182434082031
(197) DESCRIBE `ports` 0.0012400150299072
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) 0.00031805038452148
(199) DESCRIBE `ports` 0.0012412071228027
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') 0.00033402442932129
(201) DESCRIBE `ports` 0.001237154006958
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031208992004395
(203) DESCRIBE `ports` 0.0012390613555908
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027203559875488
(205) DESCRIBE `ports` 0.0012481212615967
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00030207633972168
(207) DESCRIBE `ports` 0.0012350082397461
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0002739429473877
(209) DESCRIBE `ports` 0.0012969970703125
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 910))) 0.00028705596923828
(211) DESCRIBE `ports` 0.0013070106506348
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '910') 0.00026106834411621
(213) DESCRIBE `ports` 0.0012378692626953
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00029897689819336
(215) DESCRIBE `ports` 0.0013110637664795
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00027203559875488
(217) DESCRIBE `ports` 0.0012340545654297
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00032806396484375
(219) DESCRIBE `ports` 0.0014569759368896
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.0003049373626709
(221) DESCRIBE `ports` 0.0015170574188232
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00047898292541504
(223) DESCRIBE `ports` 0.0013930797576904
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00030803680419922
(225) DESCRIBE `ports` 0.0014650821685791
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00054287910461426
(227) DESCRIBE `ports` 0.0015571117401123
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00029087066650391
(229) DESCRIBE `ports` 0.0012857913970947
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00030612945556641
(231) DESCRIBE `ports` 0.0012621879577637
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0002739429473877
(233) DESCRIBE `avid_specials` 0.0012879371643066
(234) 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.0010499954223633
(235) DESCRIBE `cruiselines` 0.0018978118896484
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00032591819763184
(237) DESCRIBE `orchid_image` 0.0014059543609619
(238) DESCRIBE `cruiselines` 0.0019829273223877
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00036096572875977
(240) DESCRIBE `cruises` 0.011348009109497
(241) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75544') 0.00053095817565918
(242) DESCRIBE `ships` 0.0038502216339111
(243) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00056695938110352
(244) DESCRIBE `ships` 0.0037200450897217
(245) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.0003509521484375
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025582313537598
(248) DESCRIBE `itineraries` 0.0013771057128906
(249) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75544') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049495697021484
(250) DESCRIBE `ports` 0.0018010139465332
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00034904479980469
(252) DESCRIBE `ports` 0.0012960433959961
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00030207633972168
(254) DESCRIBE `ports` 0.0013329982757568
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00028109550476074
(256) DESCRIBE `sailingdates` 0.0011329650878906
(257) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75544') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00051784515380859
(258) DESCRIBE `ports` 0.0013961791992188
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00057697296142578
(260) DESCRIBE `ports` 0.0016210079193115
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00030207633972168
(262) DESCRIBE `ports` 0.0012819766998291
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.00029897689819336
(264) DESCRIBE `ports` 0.0012550354003906
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00027704238891602
(266) DESCRIBE `ports` 0.0012280941009521
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 584))) 0.0002899169921875
(268) DESCRIBE `ports` 0.0013151168823242
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '584') 0.00031113624572754
(270) DESCRIBE `ports` 0.0012261867523193
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00030612945556641
(272) DESCRIBE `ports` 0.0012259483337402
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00030398368835449
(274) DESCRIBE `ports` 0.0012269020080566
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00028896331787109
(276) DESCRIBE `ports` 0.0014569759368896
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00030303001403809
(278) DESCRIBE `ports` 0.0015950202941895
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00041294097900391
(280) DESCRIBE `ports` 0.0016670227050781
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00036716461181641
(282) DESCRIBE `ports` 0.0017108917236328
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00037598609924316
(284) DESCRIBE `ports` 0.0016858577728271
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00035595893859863
(286) DESCRIBE `ports` 0.0015950202941895
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041389465332031
(288) DESCRIBE `ports` 0.0017969608306885
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036811828613281
(290) DESCRIBE `avid_specials` 0.0015590190887451
(291) 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.00164794921875
(292) DESCRIBE `cruiselines` 0.0026829242706299
(293) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00046110153198242
(294) DESCRIBE `orchid_image` 0.0019879341125488
(295) DESCRIBE `cruiselines` 0.0019080638885498
(296) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00029706954956055
(297) DESCRIBE `cruises` 0.0028929710388184
(298) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75545') 0.00042915344238281
(299) DESCRIBE `ships` 0.0026659965515137
(300) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00054597854614258
(301) DESCRIBE `ships` 0.0028741359710693
(302) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00028204917907715
(303) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030899047851562
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027108192443848
(305) DESCRIBE `itineraries` 0.0013091564178467
(306) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75545') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052213668823242
(307) DESCRIBE `ports` 0.0013399124145508
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031805038452148
(309) DESCRIBE `ports` 0.0014119148254395
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003960132598877
(311) DESCRIBE `ports` 0.0017838478088379
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030088424682617
(313) DESCRIBE `sailingdates` 0.0011990070343018
(314) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75545') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053787231445312
(315) DESCRIBE `ports` 0.0014269351959229
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033688545227051
(317) DESCRIBE `ports` 0.0013649463653564
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028109550476074
(319) DESCRIBE `ports` 0.0018491744995117
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00036191940307617
(321) DESCRIBE `ports` 0.0013668537139893
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00029993057250977
(323) DESCRIBE `ports` 0.0014309883117676
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00031590461730957
(325) DESCRIBE `ports` 0.0013701915740967
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00029897689819336
(327) DESCRIBE `ports` 0.0012969970703125
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00036787986755371
(329) DESCRIBE `ports` 0.0013217926025391
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00027680397033691
(331) DESCRIBE `ports` 0.0014820098876953
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00059604644775391
(333) DESCRIBE `ports` 0.0014059543609619
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00031900405883789
(335) DESCRIBE `ports` 0.001323938369751
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00029420852661133
(337) DESCRIBE `ports` 0.0012469291687012
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00027203559875488
(339) DESCRIBE `ports` 0.001366138458252
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00029110908508301
(341) DESCRIBE `ports` 0.0012280941009521
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.00027108192443848
(343) DESCRIBE `ports` 0.0015788078308105
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031185150146484
(345) DESCRIBE `ports` 0.0013430118560791
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027704238891602
(347) DESCRIBE `ports` 0.0012938976287842
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003349781036377
(349) DESCRIBE `ports` 0.0018060207366943
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037407875061035
(351) DESCRIBE `avid_specials` 0.0014190673828125
(352) 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.001039981842041
(353) DESCRIBE `cruiselines` 0.0018649101257324
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00031280517578125
(355) DESCRIBE `orchid_image` 0.0013890266418457
(356) DESCRIBE `cruiselines` 0.0017490386962891
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00027918815612793
(358) DESCRIBE `cruises` 0.0023927688598633
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68724') 0.00034785270690918
(360) DESCRIBE `ships` 0.0026559829711914
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00038290023803711
(362) DESCRIBE `ships` 0.0024631023406982
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00028896331787109
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025486946105957
(366) DESCRIBE `itineraries` 0.0012459754943848
(367) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68724') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060915946960449
(368) DESCRIBE `ports` 0.0013158321380615
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00030398368835449
(370) DESCRIBE `ports` 0.0012791156768799
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00030207633972168
(372) DESCRIBE `ports` 0.0012340545654297
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00027608871459961
(374) DESCRIBE `sailingdates` 0.0011260509490967
(375) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68724') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048708915710449
(376) DESCRIBE `ports` 0.0017728805541992
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0003809928894043
(378) DESCRIBE `ports` 0.0013470649719238
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0003199577331543
(380) DESCRIBE `ports` 0.0013041496276855
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00029397010803223
(382) DESCRIBE `ports` 0.0014998912811279
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00031089782714844
(384) DESCRIBE `ports` 0.0013918876647949
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00030899047851562
(386) DESCRIBE `ports` 0.0013179779052734
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00029778480529785
(388) DESCRIBE `ports` 0.0012788772583008
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00029897689819336
(390) DESCRIBE `ports` 0.0015628337860107
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00029993057250977
(392) DESCRIBE `ports` 0.0012471675872803
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00030899047851562
(394) DESCRIBE `ports` 0.0012450218200684
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0002748966217041
(396) DESCRIBE `ports` 0.0012979507446289
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00038504600524902
(398) DESCRIBE `ports` 0.0015299320220947
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00027704238891602
(400) DESCRIBE `ports` 0.001356840133667
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00031089782714844
(402) DESCRIBE `ports` 0.0012400150299072
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0002751350402832
(404) DESCRIBE `ports` 0.0013079643249512
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00029611587524414
(406) DESCRIBE `ports` 0.0012409687042236
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00027298927307129
(408) DESCRIBE `ports` 0.0014009475708008
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029492378234863
(410) DESCRIBE `ports` 0.0012669563293457
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00034093856811523
(412) DESCRIBE `avid_specials` 0.0011289119720459
(413) 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.0013048648834229
(414) DESCRIBE `cruiselines` 0.00187087059021
(415) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00039792060852051
(416) DESCRIBE `orchid_image` 0.0016829967498779
(417) DESCRIBE `cruiselines` 0.0018830299377441
(418) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0002899169921875
(419) DESCRIBE `cruises` 0.0024771690368652
(420) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75546') 0.00031018257141113
(421) DESCRIBE `ships` 0.0026140213012695
(422) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00035810470581055
(423) DESCRIBE `ships` 0.002514123916626
(424) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00034904479980469
(425) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003049373626709
(426) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002598762512207
(427) DESCRIBE `itineraries` 0.0012381076812744
(428) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75546') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005040168762207
(429) DESCRIBE `ports` 0.0012869834899902
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032401084899902
(431) DESCRIBE `ports` 0.0012471675872803
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029087066650391
(433) DESCRIBE `ports` 0.0015921592712402
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038003921508789
(435) DESCRIBE `sailingdates` 0.00111985206604
(436) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75546') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058698654174805
(437) DESCRIBE `ports` 0.0013279914855957
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031018257141113
(439) DESCRIBE `ports` 0.0012969970703125
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028014183044434
(441) DESCRIBE `ports` 0.0012400150299072
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030803680419922
(443) DESCRIBE `ports` 0.0012619495391846
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002739429473877
(445) DESCRIBE `ports` 0.001244068145752
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00034189224243164
(447) DESCRIBE `ports` 0.0012390613555908
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.0002751350402832
(449) DESCRIBE `ports` 0.0012969970703125
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00037002563476562
(451) DESCRIBE `ports` 0.0012719631195068
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0002751350402832
(453) DESCRIBE `ports` 0.0015320777893066
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030994415283203
(455) DESCRIBE `ports` 0.0012500286102295
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00035214424133301
(457) DESCRIBE `ports` 0.0013000965118408
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00030899047851562
(459) DESCRIBE `ports` 0.0012369155883789
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00031495094299316
(461) DESCRIBE `ports` 0.0014150142669678
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4120))) 0.00045609474182129
(463) DESCRIBE `ports` 0.0012588500976562
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4120') 0.00028419494628906
(465) DESCRIBE `ports` 0.0013179779052734
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00030803680419922
(467) DESCRIBE `ports` 0.0013091564178467
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00027680397033691
(469) DESCRIBE `ports` 0.0012850761413574
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00028705596923828
(471) DESCRIBE `ports` 0.0013489723205566
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00027704238891602
(473) DESCRIBE `ports` 0.0012369155883789
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032401084899902
(475) DESCRIBE `ports` 0.0012779235839844
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027298927307129
(477) DESCRIBE `avid_specials` 0.001101016998291
(478) 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.0010697841644287
(479) DESCRIBE `cruiselines` 0.0020132064819336
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0003209114074707
(481) DESCRIBE `orchid_image` 0.0014431476593018
(482) DESCRIBE `cruiselines` 0.0017530918121338
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00027894973754883
(484) DESCRIBE `cruises` 0.0028548240661621
(485) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68726') 0.00034093856811523
(486) DESCRIBE `ships` 0.0025680065155029
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00041890144348145
(488) DESCRIBE `ships` 0.0024869441986084
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.0002899169921875
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025486946105957
(492) DESCRIBE `itineraries` 0.0013570785522461
(493) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68726') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051498413085938
(494) DESCRIBE `ports` 0.0013070106506348
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032901763916016
(496) DESCRIBE `ports` 0.00124192237854
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035500526428223
(498) DESCRIBE `ports` 0.0012669563293457
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027585029602051
(500) DESCRIBE `sailingdates` 0.001121997833252
(501) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68726') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053596496582031
(502) DESCRIBE `ports` 0.0013570785522461
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031900405883789
(504) DESCRIBE `ports` 0.0013241767883301
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027680397033691
(506) DESCRIBE `ports` 0.0013189315795898
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031304359436035
(508) DESCRIBE `ports` 0.0012500286102295
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028491020202637
(510) DESCRIBE `ports` 0.0013198852539062
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029492378234863
(512) DESCRIBE `ports` 0.0016131401062012
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027918815612793
(514) DESCRIBE `ports` 0.0012600421905518
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00031495094299316
(516) DESCRIBE `ports` 0.0013370513916016
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.0002748966217041
(518) DESCRIBE `ports` 0.0012459754943848
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00030088424682617
(520) DESCRIBE `ports` 0.0013959407806396
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00027298927307129
(522) DESCRIBE `ports` 0.0013279914855957
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.00031495094299316
(524) DESCRIBE `ports` 0.0012590885162354
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00028204917907715
(526) DESCRIBE `ports` 0.0012500286102295
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00032782554626465
(528) DESCRIBE `ports` 0.0013689994812012
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027704238891602
(530) DESCRIBE `ports` 0.0013139247894287
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029206275939941
(532) DESCRIBE `ports` 0.0012760162353516
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0002751350402832
(534) DESCRIBE `avid_specials` 0.0012190341949463
(535) 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.00099492073059082
(536) DESCRIBE `cruiselines` 0.0022659301757812
(537) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00036382675170898
(538) DESCRIBE `orchid_image` 0.0015389919281006
(539) DESCRIBE `cruiselines` 0.0019021034240723
(540) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00028085708618164
(541) DESCRIBE `cruises` 0.0024478435516357
(542) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75547') 0.00033903121948242
(543) DESCRIBE `ships` 0.002647876739502
(544) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00035190582275391
(545) DESCRIBE `ships` 0.0026099681854248
(546) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00027608871459961
(547) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032305717468262
(548) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025820732116699
(549) DESCRIBE `itineraries` 0.0012338161468506
(550) DESCRIBE `ports` 0.0014498233795166
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00036001205444336
(552) DESCRIBE `ports` 0.0013539791107178
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0003809928894043
(554) DESCRIBE `ports` 0.0013768672943115
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00030207633972168
(556) DESCRIBE `sailingdates` 0.001115083694458
(557) DESCRIBE `ports` 0.0013411045074463
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030398368835449
(559) DESCRIBE `ports` 0.0012950897216797
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028586387634277
(561) DESCRIBE `ports` 0.0012960433959961
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0003201961517334
(563) DESCRIBE `ports` 0.0012960433959961
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00027298927307129
(565) DESCRIBE `ports` 0.0012438297271729
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00029802322387695
(567) DESCRIBE `ports` 0.001317024230957
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0002739429473877
(569) DESCRIBE `ports` 0.0012781620025635
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00030803680419922
(571) DESCRIBE `ports` 0.0012450218200684
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00028395652770996
(573) DESCRIBE `ports` 0.0012791156768799
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00029897689819336
(575) DESCRIBE `ports` 0.0013329982757568
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00028300285339355
(577) DESCRIBE `ports` 0.0013670921325684
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030112266540527
(579) DESCRIBE `ports` 0.0013270378112793
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027322769165039
(581) DESCRIBE `ports` 0.001305103302002
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031304359436035
(583) DESCRIBE `ports` 0.0012428760528564
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027203559875488
(585) DESCRIBE `ports` 0.0013208389282227
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031614303588867
(587) DESCRIBE `ports` 0.0012490749359131
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027608871459961
(589) DESCRIBE `ports` 0.0013039112091064
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00040888786315918
(591) DESCRIBE `ports` 0.0013539791107178
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00028800964355469
(593) DESCRIBE `avid_specials` 0.001168966293335
(594) 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.0010330677032471
(595) DESCRIBE `cruiselines` 0.0018570423126221
(596) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00032496452331543
(597) DESCRIBE `orchid_image` 0.0014081001281738
(598) DESCRIBE `cruiselines` 0.0017828941345215
(599) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00027084350585938
(600) DESCRIBE `ships` 0.0026988983154297
(601) SELECT `ships`.* FROM `ships` WHERE (id IN ('1672', '616', '652')) ORDER BY FIND_IN_SET(id, '1672,616,652') 0.00056576728820801
(602) DESCRIBE `cruisetypes` 0.0010459423065186
(603) 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.026628971099854
(604) DESCRIBE `cruiselines` 0.0021569728851318
(605) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00036191940307617
(606) DESCRIBE `destinations` 0.0018610954284668
(607) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.0003349781036377
(608) DESCRIBE `destinations` 0.0018539428710938
(609) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.0003969669342041
(610) DESCRIBE `cruiselines` 0.0024659633636475
(611) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00037193298339844