or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. REVIEW: P & O Australia’s Pacific Aria
  3. Catch Up on Cruising: Latest News in bite size!
  4. Asian Adventures with Zuleika from the Cruise Factor Team
  5. A short cruise is a good cruise!!

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

Total elapsed time: 0.44636058807373

# Query Time
(1) connect 0.00058484077453613
(2) DESCRIBE `cruises` 0.0025248527526855
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70720, 70721, 73029, 73030, 73032, 72992, 72993, 72994, 72995, 72996)) ORDER BY FIND_IN_SET(id, '70720,70721,73029,73030,73032,72992,72993,72994,72995,72996') 0.0018539428710938
(4) DESCRIBE `cruises` 0.0025100708007812
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70720') 0.00036096572875977
(6) DESCRIBE `ships` 0.0022380352020264
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00047206878662109
(8) DESCRIBE `ships` 0.0022001266479492
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00035810470581055
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024294853210449
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023198127746582
(12) DESCRIBE `itineraries` 0.0012269020080566
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70720') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0016360282897949
(14) DESCRIBE `ports` 0.0011348724365234
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00032496452331543
(16) DESCRIBE `ports` 0.00091195106506348
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022101402282715
(18) DESCRIBE `ports` 0.0010678768157959
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00029301643371582
(20) DESCRIBE `sailingdates` 0.00095510482788086
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70720') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0014212131500244
(22) DESCRIBE `ports` 0.0014579296112061
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00035619735717773
(24) DESCRIBE `ports` 0.001025915145874
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00025796890258789
(26) DESCRIBE `ports` 0.00098490715026855
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00029397010803223
(28) DESCRIBE `ports` 0.0010299682617188
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.0002751350402832
(30) DESCRIBE `ports` 0.0010750293731689
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00029897689819336
(32) DESCRIBE `ports` 0.0010511875152588
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00026893615722656
(34) DESCRIBE `ports` 0.0010199546813965
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00046586990356445
(36) DESCRIBE `ports` 0.0012059211730957
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00031089782714844
(38) DESCRIBE `ports` 0.00075411796569824
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00025796890258789
(40) DESCRIBE `ports` 0.00081515312194824
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00022983551025391
(42) DESCRIBE `ports` 0.00081491470336914
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00022101402282715
(44) DESCRIBE `ports` 0.00077605247497559
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0001978874206543
(46) DESCRIBE `ports` 0.00080990791320801
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00022101402282715
(48) DESCRIBE `ports` 0.00083279609680176
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00021100044250488
(50) DESCRIBE `ports` 0.00078606605529785
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00027704238891602
(52) DESCRIBE `ports` 0.00069189071655273
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00019502639770508
(54) DESCRIBE `avid_specials` 0.00065183639526367
(55) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70720 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 2 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.0013329982757568
(56) DESCRIBE `cruiselines` 0.0011630058288574
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024819374084473
(58) DESCRIBE `orchid_image` 0.00086188316345215
(59) DESCRIBE `cruiselines` 0.0010340213775635
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00031518936157227
(61) DESCRIBE `cruises` 0.0016529560089111
(62) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70721') 0.0002748966217041
(63) DESCRIBE `ships` 0.0014090538024902
(64) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00032305717468262
(65) DESCRIBE `ships` 0.0014469623565674
(66) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00023508071899414
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018787384033203
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020885467529297
(69) DESCRIBE `itineraries` 0.00085806846618652
(70) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70721') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061202049255371
(71) DESCRIBE `ports` 0.001262903213501
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00036096572875977
(73) DESCRIBE `ports` 0.0011210441589355
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00031113624572754
(75) DESCRIBE `ports` 0.0010359287261963
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.0002751350402832
(77) DESCRIBE `sailingdates` 0.00087690353393555
(78) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70721') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058197975158691
(79) DESCRIBE `ports` 0.0013911724090576
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00034594535827637
(81) DESCRIBE `ports` 0.0010628700256348
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.0002748966217041
(83) DESCRIBE `ports` 0.0010490417480469
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00030994415283203
(85) DESCRIBE `ports` 0.0010340213775635
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00026512145996094
(87) DESCRIBE `ports` 0.00095486640930176
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00028395652770996
(89) DESCRIBE `ports` 0.0009310245513916
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00026106834411621
(91) DESCRIBE `ports` 0.0010330677032471
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00026202201843262
(93) DESCRIBE `ports` 0.00080180168151855
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00020909309387207
(95) DESCRIBE `ports` 0.00072097778320312
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3629))) 0.00020289421081543
(97) DESCRIBE `ports` 0.00067996978759766
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3629') 0.00017809867858887
(99) DESCRIBE `ports` 0.00072717666625977
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00023508071899414
(101) DESCRIBE `ports` 0.00069594383239746
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.0001988410949707
(103) DESCRIBE `ports` 0.00086212158203125
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00027894973754883
(105) DESCRIBE `ports` 0.00079798698425293
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018787384033203
(107) DESCRIBE `ports` 0.00069499015808105
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00022196769714355
(109) DESCRIBE `ports` 0.00067496299743652
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00018405914306641
(111) DESCRIBE `ports` 0.00075817108154297
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022292137145996
(113) DESCRIBE `ports` 0.00078892707824707
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00022721290588379
(115) DESCRIBE `avid_specials` 0.00073409080505371
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70721 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 2 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.0011389255523682
(117) DESCRIBE `cruiselines` 0.0010230541229248
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00025391578674316
(119) DESCRIBE `orchid_image` 0.00079703330993652
(120) DESCRIBE `cruiselines` 0.0011281967163086
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00028491020202637
(122) DESCRIBE `cruises` 0.0020570755004883
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73029') 0.0003662109375
(124) DESCRIBE `ships` 0.0021538734436035
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00042486190795898
(126) DESCRIBE `ships` 0.0023660659790039
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00035619735717773
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023388862609863
(130) DESCRIBE `itineraries` 0.0011088848114014
(131) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73029') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012400150299072
(132) DESCRIBE `ports` 0.0012490749359131
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00034189224243164
(134) DESCRIBE `ports` 0.0010418891906738
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00029301643371582
(136) DESCRIBE `ports` 0.0010349750518799
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00026512145996094
(138) DESCRIBE `sailingdates` 0.00090408325195312
(139) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73029') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007469654083252
(140) DESCRIBE `ports` 0.0012309551239014
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00031018257141113
(142) DESCRIBE `ports` 0.00073409080505371
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00022506713867188
(144) DESCRIBE `ports` 0.00072383880615234
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00023508071899414
(146) DESCRIBE `ports` 0.00074505805969238
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.0002448558807373
(148) DESCRIBE `ports` 0.00069808959960938
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00021481513977051
(150) DESCRIBE `ports` 0.00067901611328125
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00023818016052246
(152) DESCRIBE `ports` 0.00092506408691406
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3629))) 0.00023198127746582
(154) DESCRIBE `ports` 0.00071883201599121
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3629') 0.00021100044250488
(156) DESCRIBE `ports` 0.00092911720275879
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00029110908508301
(158) DESCRIBE `ports` 0.00097393989562988
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00021100044250488
(160) DESCRIBE `ports` 0.00078010559082031
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1280))) 0.00024795532226562
(162) DESCRIBE `ports` 0.00094389915466309
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1280') 0.00024986267089844
(164) DESCRIBE `ports` 0.00086307525634766
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 538))) 0.00026988983154297
(166) DESCRIBE `ports` 0.00083303451538086
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '538') 0.00018811225891113
(168) DESCRIBE `ports` 0.00072288513183594
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00021195411682129
(170) DESCRIBE `ports` 0.00067806243896484
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00020909309387207
(172) DESCRIBE `ports` 0.00076198577880859
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2354))) 0.00023579597473145
(174) DESCRIBE `ports` 0.00069499015808105
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2354') 0.00018882751464844
(176) DESCRIBE `ports` 0.00071883201599121
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021004676818848
(178) DESCRIBE `ports` 0.00073599815368652
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00019001960754395
(180) DESCRIBE `avid_specials` 0.00079107284545898
(181) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73029 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 2 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.0010020732879639
(182) DESCRIBE `cruiselines` 0.0010559558868408
(183) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00029087066650391
(184) DESCRIBE `orchid_image` 0.0011889934539795
(185) DESCRIBE `cruiselines` 0.0016369819641113
(186) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00032305717468262
(187) DESCRIBE `cruises` 0.0025548934936523
(188) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73030') 0.00039792060852051
(189) DESCRIBE `ships` 0.002255916595459
(190) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00051093101501465
(191) DESCRIBE `ships` 0.0021929740905762
(192) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.0004429817199707
(193) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023794174194336
(195) DESCRIBE `itineraries` 0.0011768341064453
(196) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73030') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063896179199219
(197) DESCRIBE `ports` 0.0011920928955078
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00038695335388184
(199) DESCRIBE `ports` 0.0015790462493896
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00039911270141602
(201) DESCRIBE `ports` 0.0010859966278076
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00028109550476074
(203) DESCRIBE `sailingdates` 0.00091290473937988
(204) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73030') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053000450134277
(205) DESCRIBE `ports` 0.0011329650878906
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00029301643371582
(207) DESCRIBE `ports` 0.00069808959960938
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00020289421081543
(209) DESCRIBE `ports` 0.00067782402038574
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00034904479980469
(211) DESCRIBE `ports` 0.0007469654083252
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00019693374633789
(213) DESCRIBE `ports` 0.00071191787719727
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4363))) 0.00020480155944824
(215) DESCRIBE `ports` 0.00072503089904785
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4363') 0.00018405914306641
(217) DESCRIBE `ports` 0.00074386596679688
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00025200843811035
(219) DESCRIBE `ports` 0.00084400177001953
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00023317337036133
(221) DESCRIBE `ports` 0.00089693069458008
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0002589225769043
(223) DESCRIBE `ports` 0.00070095062255859
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00019598007202148
(225) DESCRIBE `ports` 0.0006859302520752
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020790100097656
(227) DESCRIBE `ports` 0.00068116188049316
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00018787384033203
(229) DESCRIBE `ports` 0.00072407722473145
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00028300285339355
(231) DESCRIBE `ports` 0.0013391971588135
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00030398368835449
(233) DESCRIBE `ports` 0.0010240077972412
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00028109550476074
(235) DESCRIBE `ports` 0.0009760856628418
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00025415420532227
(237) DESCRIBE `ports` 0.00098800659179688
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00027990341186523
(239) DESCRIBE `ports` 0.00080299377441406
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00021982192993164
(241) DESCRIBE `ports` 0.00072884559631348
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00022315979003906
(243) DESCRIBE `ports` 0.00067996978759766
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00019097328186035
(245) DESCRIBE `ports` 0.00072121620178223
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00020694732666016
(247) DESCRIBE `ports` 0.00067687034606934
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00023484230041504
(249) DESCRIBE `ports` 0.00080084800720215
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00025820732116699
(251) DESCRIBE `ports` 0.00068306922912598
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00018692016601562
(253) DESCRIBE `ports` 0.00067400932312012
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022697448730469
(255) DESCRIBE `ports` 0.00079607963562012
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019192695617676
(257) DESCRIBE `avid_specials` 0.00069808959960938
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73030 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 35 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.0011951923370361
(259) DESCRIBE `cruiselines` 0.0009911060333252
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023293495178223
(261) DESCRIBE `orchid_image` 0.00076913833618164
(262) DESCRIBE `cruiselines` 0.0012669563293457
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0001990795135498
(264) DESCRIBE `cruises` 0.0015780925750732
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73032') 0.00039887428283691
(266) DESCRIBE `ships` 0.0013260841369629
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.0002899169921875
(268) DESCRIBE `ships` 0.0015461444854736
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00024986267089844
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(272) DESCRIBE `itineraries` 0.000701904296875
(273) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73032') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00037193298339844
(274) DESCRIBE `ports` 0.0011401176452637
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00025391578674316
(276) DESCRIBE `ports` 0.00098705291748047
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023603439331055
(278) DESCRIBE `ports` 0.00089406967163086
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00021219253540039
(280) DESCRIBE `sailingdates` 0.00063991546630859
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73032') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042510032653809
(282) DESCRIBE `ports` 0.0010421276092529
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023984909057617
(284) DESCRIBE `ports` 0.00071096420288086
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018906593322754
(286) DESCRIBE `ports` 0.000946044921875
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00025582313537598
(288) DESCRIBE `ports` 0.00090789794921875
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00022792816162109
(290) DESCRIBE `ports` 0.00098800659179688
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00027084350585938
(292) DESCRIBE `ports` 0.00095081329345703
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00023698806762695
(294) DESCRIBE `ports` 0.0011570453643799
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00027298927307129
(296) DESCRIBE `ports` 0.00074505805969238
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00019097328186035
(298) DESCRIBE `ports` 0.00081086158752441
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00020503997802734
(300) DESCRIBE `ports` 0.00077199935913086
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00021815299987793
(302) DESCRIBE `ports` 0.00090694427490234
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00021100044250488
(304) DESCRIBE `ports` 0.00067996978759766
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00022506713867188
(306) DESCRIBE `ports` 0.00067591667175293
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00024294853210449
(308) DESCRIBE `ports` 0.00074601173400879
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0001990795135498
(310) DESCRIBE `avid_specials` 0.00061583518981934
(311) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73032 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 35 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.0011069774627686
(312) DESCRIBE `cruiselines` 0.0010600090026855
(313) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022697448730469
(314) DESCRIBE `orchid_image` 0.00080990791320801
(315) DESCRIBE `cruiselines` 0.00097084045410156
(316) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00022006034851074
(317) DESCRIBE `cruises` 0.0016391277313232
(318) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72992') 0.00024318695068359
(319) DESCRIBE `ships` 0.0013360977172852
(320) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.0003199577331543
(321) DESCRIBE `ships` 0.0013260841369629
(322) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00020408630371094
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(325) DESCRIBE `itineraries` 0.0067229270935059
(326) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72992') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064897537231445
(327) DESCRIBE `ports` 0.0079591274261475
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00045609474182129
(329) DESCRIBE `ports` 0.0011389255523682
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00026202201843262
(331) DESCRIBE `ports` 0.00095701217651367
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00021100044250488
(333) DESCRIBE `sailingdates` 0.00062799453735352
(334) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72992') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0003969669342041
(335) DESCRIBE `ports` 0.00078892707824707
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022697448730469
(337) DESCRIBE `ports` 0.0006859302520752
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018787384033203
(339) DESCRIBE `ports` 0.00071191787719727
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 417))) 0.00022292137145996
(341) DESCRIBE `ports` 0.00068211555480957
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '417') 0.00026082992553711
(343) DESCRIBE `ports` 0.00069093704223633
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00020790100097656
(345) DESCRIBE `ports` 0.00069499015808105
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00018501281738281
(347) DESCRIBE `ports` 0.0006718635559082
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.0001981258392334
(349) DESCRIBE `ports` 0.0007939338684082
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.0001981258392334
(351) DESCRIBE `ports` 0.00068092346191406
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00022196769714355
(353) DESCRIBE `ports` 0.00074386596679688
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00019502639770508
(355) DESCRIBE `ports` 0.00073814392089844
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00025486946105957
(357) DESCRIBE `ports` 0.00083303451538086
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00019407272338867
(359) DESCRIBE `ports` 0.00068998336791992
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00021982192993164
(361) DESCRIBE `ports` 0.000762939453125
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00020098686218262
(363) DESCRIBE `ports` 0.00070405006408691
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00022506713867188
(365) DESCRIBE `ports` 0.00070095062255859
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00018620491027832
(367) DESCRIBE `ports` 0.00072598457336426
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00021505355834961
(369) DESCRIBE `ports` 0.0010628700256348
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00026106834411621
(371) DESCRIBE `ports` 0.0010740756988525
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00032401084899902
(373) DESCRIBE `ports` 0.0010378360748291
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00026583671569824
(375) DESCRIBE `ports` 0.0009911060333252
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030088424682617
(377) DESCRIBE `ports` 0.001011848449707
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00025486946105957
(379) DESCRIBE `ports` 0.00099086761474609
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00027799606323242
(381) DESCRIBE `ports` 0.00099015235900879
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.0002439022064209
(383) DESCRIBE `ports` 0.00090599060058594
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023579597473145
(385) DESCRIBE `ports` 0.00088691711425781
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019288063049316
(387) DESCRIBE `avid_specials` 0.00066804885864258
(388) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72992 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 8 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.0012409687042236
(389) DESCRIBE `cruiselines` 0.0010011196136475
(390) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00028109550476074
(391) DESCRIBE `orchid_image` 0.00082492828369141
(392) DESCRIBE `cruiselines` 0.000946044921875
(393) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00023293495178223
(394) DESCRIBE `cruises` 0.001345157623291
(395) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72993') 0.00028705596923828
(396) DESCRIBE `ships` 0.0013158321380615
(397) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00030112266540527
(398) DESCRIBE `ships` 0.001410961151123
(399) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00020885467529297
(400) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(402) DESCRIBE `itineraries` 0.00069403648376465
(403) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72993') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00044608116149902
(404) DESCRIBE `ports` 0.00072717666625977
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026798248291016
(406) DESCRIBE `ports` 0.00067901611328125
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027799606323242
(408) DESCRIBE `ports` 0.00096583366394043
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019598007202148
(410) DESCRIBE `sailingdates` 0.00063610076904297
(411) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72993') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043797492980957
(412) DESCRIBE `ports` 0.0011200904846191
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030612945556641
(414) DESCRIBE `ports` 0.0010278224945068
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002591609954834
(416) DESCRIBE `ports` 0.00099706649780273
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00026297569274902
(418) DESCRIBE `ports` 0.00096702575683594
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00020217895507812
(420) DESCRIBE `ports` 0.00075316429138184
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00024008750915527
(422) DESCRIBE `ports` 0.00071191787719727
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00018596649169922
(424) DESCRIBE `ports` 0.00073814392089844
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0001988410949707
(426) DESCRIBE `ports` 0.00067400932312012
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00018095970153809
(428) DESCRIBE `ports` 0.00067305564880371
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00024700164794922
(430) DESCRIBE `ports` 0.00067496299743652
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00018405914306641
(432) DESCRIBE `ports` 0.00068902969360352
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00020289421081543
(434) DESCRIBE `ports` 0.00068902969360352
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00018501281738281
(436) DESCRIBE `ports` 0.00082898139953613
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00024914741516113
(438) DESCRIBE `ports` 0.00068783760070801
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00019311904907227
(440) DESCRIBE `ports` 0.00068211555480957
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00027894973754883
(442) DESCRIBE `ports` 0.0011119842529297
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00026607513427734
(444) DESCRIBE `ports` 0.00099086761474609
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00027680397033691
(446) DESCRIBE `ports` 0.00069212913513184
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00019979476928711
(448) DESCRIBE `ports` 0.00067400932312012
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00020384788513184
(450) DESCRIBE `ports` 0.00069808959960938
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00018310546875
(452) DESCRIBE `ports` 0.0007011890411377
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021791458129883
(454) DESCRIBE `ports` 0.00067019462585449
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018310546875
(456) DESCRIBE `avid_specials` 0.00060701370239258
(457) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72993 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099611282348633
(458) DESCRIBE `cruiselines` 0.0012149810791016
(459) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024700164794922
(460) DESCRIBE `orchid_image` 0.00078892707824707
(461) DESCRIBE `cruiselines` 0.0010249614715576
(462) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0002138614654541
(463) DESCRIBE `cruises` 0.0015048980712891
(464) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72994') 0.00025701522827148
(465) DESCRIBE `ships` 0.0013668537139893
(466) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.0003199577331543
(467) DESCRIBE `ships` 0.0016410350799561
(468) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.0002291202545166
(469) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022315979003906
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(471) DESCRIBE `itineraries` 0.00077414512634277
(472) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72994') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00035619735717773
(473) DESCRIBE `ports` 0.00070810317993164
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025510787963867
(475) DESCRIBE `ports` 0.00084304809570312
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021505355834961
(477) DESCRIBE `ports` 0.0033540725708008
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022387504577637
(479) DESCRIBE `sailingdates` 0.00066113471984863
(480) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72994') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0003809928894043
(481) DESCRIBE `ports` 0.0007169246673584
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024604797363281
(483) DESCRIBE `ports` 0.00073099136352539
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019121170043945
(485) DESCRIBE `ports` 0.00068211555480957
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00020718574523926
(487) DESCRIBE `ports` 0.00070810317993164
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00018811225891113
(489) DESCRIBE `ports` 0.00067591667175293
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00020503997802734
(491) DESCRIBE `ports` 0.00074195861816406
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00020503997802734
(493) DESCRIBE `ports` 0.00077605247497559
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002140998840332
(495) DESCRIBE `ports` 0.00070500373840332
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018811225891113
(497) DESCRIBE `ports` 0.00071191787719727
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020503997802734
(499) DESCRIBE `ports` 0.00088810920715332
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024604797363281
(501) DESCRIBE `avid_specials` 0.00066590309143066
(502) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72994 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 8 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.0010268688201904
(503) DESCRIBE `cruiselines` 0.00099706649780273
(504) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024509429931641
(505) DESCRIBE `orchid_image` 0.00075888633728027
(506) DESCRIBE `cruiselines` 0.00092887878417969
(507) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019407272338867
(508) DESCRIBE `cruises` 0.0013320446014404
(509) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72995') 0.00022697448730469
(510) DESCRIBE `ships` 0.0012989044189453
(511) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00027108192443848
(512) DESCRIBE `ships` 0.0012619495391846
(513) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00020194053649902
(514) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(515) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(516) DESCRIBE `itineraries` 0.00066709518432617
(517) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72995') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00047206878662109
(518) DESCRIBE `ports` 0.00076198577880859
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023102760314941
(520) DESCRIBE `ports` 0.0006871223449707
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020289421081543
(522) DESCRIBE `ports` 0.00067710876464844
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019192695617676
(524) DESCRIBE `sailingdates` 0.00060606002807617
(525) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72995') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046801567077637
(526) DESCRIBE `ports` 0.00083684921264648
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023818016052246
(528) DESCRIBE `ports` 0.00094413757324219
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022101402282715
(530) DESCRIBE `ports` 0.00074887275695801
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00022792816162109
(532) DESCRIBE `ports` 0.00069689750671387
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00022792816162109
(534) DESCRIBE `ports` 0.00073099136352539
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00020813941955566
(536) DESCRIBE `ports` 0.00070381164550781
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00018906593322754
(538) DESCRIBE `ports` 0.00069308280944824
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002129077911377
(540) DESCRIBE `ports` 0.00078105926513672
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018906593322754
(542) DESCRIBE `ports` 0.00072717666625977
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030803680419922
(544) DESCRIBE `ports` 0.00084090232849121
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00021100044250488
(546) DESCRIBE `ports` 0.00083589553833008
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00022196769714355
(548) DESCRIBE `ports` 0.00074100494384766
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00023794174194336
(550) DESCRIBE `ports` 0.00077104568481445
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.0002281665802002
(552) DESCRIBE `ports` 0.00075888633728027
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00025510787963867
(554) DESCRIBE `ports` 0.00078296661376953
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00025486946105957
(556) DESCRIBE `ports` 0.00078797340393066
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00023698806762695
(558) DESCRIBE `ports` 0.00072693824768066
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00021719932556152
(560) DESCRIBE `ports` 0.0010790824890137
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00024509429931641
(562) DESCRIBE `ports` 0.00081992149353027
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00021505355834961
(564) DESCRIBE `ports` 0.00069594383239746
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00018906593322754
(566) DESCRIBE `ports` 0.00067996978759766
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00023293495178223
(568) DESCRIBE `ports` 0.0007169246673584
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00019097328186035
(570) DESCRIBE `ports` 0.00072789192199707
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00030803680419922
(572) DESCRIBE `ports` 0.00087594985961914
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00023698806762695
(574) DESCRIBE `ports` 0.00073003768920898
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00022387504577637
(576) DESCRIBE `ports` 0.00086593627929688
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00019598007202148
(578) DESCRIBE `ports` 0.00089502334594727
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00026416778564453
(580) DESCRIBE `ports` 0.001072883605957
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026321411132812
(582) DESCRIBE `ports` 0.00098800659179688
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035285949707031
(584) DESCRIBE `ports` 0.00081014633178711
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022792816162109
(586) DESCRIBE `avid_specials` 0.00069308280944824
(587) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72995 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010159015655518
(588) DESCRIBE `cruiselines` 0.0011308193206787
(589) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00027608871459961
(590) DESCRIBE `orchid_image` 0.00076889991760254
(591) DESCRIBE `cruiselines` 0.0010318756103516
(592) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00022506713867188
(593) DESCRIBE `cruises` 0.0014598369598389
(594) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72996') 0.00033807754516602
(595) DESCRIBE `ships` 0.00142502784729
(596) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00030899047851562
(597) DESCRIBE `ships` 0.0013189315795898
(598) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00021910667419434
(599) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(600) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(601) DESCRIBE `itineraries` 0.00072097778320312
(602) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72996') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00038599967956543
(603) DESCRIBE `ports` 0.00093603134155273
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037884712219238
(605) DESCRIBE `ports` 0.0010199546813965
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029611587524414
(607) DESCRIBE `ports` 0.00092792510986328
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020503997802734
(609) DESCRIBE `sailingdates` 0.00063705444335938
(610) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72996') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00037598609924316
(611) DESCRIBE `ports` 0.00074601173400879
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002140998840332
(613) DESCRIBE `ports` 0.00074386596679688
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018882751464844
(615) DESCRIBE `ports` 0.00071501731872559
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024819374084473
(617) DESCRIBE `ports` 0.00068020820617676
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019311904907227
(619) DESCRIBE `ports` 0.00067710876464844
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020909309387207
(621) DESCRIBE `ports` 0.00069308280944824
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00020003318786621
(623) DESCRIBE `ports` 0.00068807601928711
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00021600723266602
(625) DESCRIBE `ports` 0.00075578689575195
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00026988983154297
(627) DESCRIBE `ports` 0.00073409080505371
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00022006034851074
(629) DESCRIBE `ports` 0.00070381164550781
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00027298927307129
(631) DESCRIBE `ports` 0.00073385238647461
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00021219253540039
(633) DESCRIBE `ports` 0.00071883201599121
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00019097328186035
(635) DESCRIBE `ports` 0.00069594383239746
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020313262939453
(637) DESCRIBE `ports` 0.0006721019744873
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00019097328186035
(639) DESCRIBE `ports` 0.00066995620727539
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022292137145996
(641) DESCRIBE `ports` 0.00068783760070801
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018692016601562
(643) DESCRIBE `avid_specials` 0.0006718635559082
(644) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72996 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099778175354004
(645) DESCRIBE `cruiselines` 0.0010759830474854
(646) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023198127746582
(647) DESCRIBE `orchid_image` 0.00075197219848633
(648) DESCRIBE `cruiselines` 0.00094485282897949
(649) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018882751464844
(650) DESCRIBE `cruisetypes` 0.0009620189666748
(651) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '20') AND (cruises_and_specials.ship_id = '485') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.026565074920654
(652) DESCRIBE `destinations` 0.0011751651763916
(653) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '43', '8', '35')) ORDER BY FIND_IN_SET(id, '2,43,8,35') 0.00047802925109863
(654) DESCRIBE `cruiselines` 0.0010230541229248
(655) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0002601146697998
(656) DESCRIBE `ships` 0.0013740062713623
(657) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00027179718017578
(658) DESCRIBE `cruiselines` 0.0011799335479736
(659) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00026392936706543
(660) DESCRIBE `ships` 0.0015590190887451
(661) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00031185150146484