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

Total elapsed time: 0.40083813667297

# Query Time
(1) connect 0.00087714195251465
(2) DESCRIBE `cruises` 0.0025889873504639
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (57373, 43646, 71097, 60002, 67120, 77398, 46637, 66788, 66973, 66996)) ORDER BY FIND_IN_SET(id, '57373,43646,71097,60002,67120,77398,46637,66788,66973,66996') 0.001511812210083
(4) DESCRIBE `cruises` 0.0025181770324707
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57373') 0.00037097930908203
(6) DESCRIBE `ships` 0.0022308826446533
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 314))) 0.00042605400085449
(8) DESCRIBE `ships` 0.0021829605102539
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '314') 0.00042390823364258
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022411346435547
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(12) DESCRIBE `itineraries` 0.001060962677002
(13) DESCRIBE `ports` 0.0010719299316406
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00032711029052734
(15) DESCRIBE `ports` 0.00091981887817383
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00027203559875488
(17) DESCRIBE `ports` 0.00094008445739746
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00022602081298828
(19) DESCRIBE `sailingdates` 0.00084996223449707
(20) DESCRIBE `ports` 0.001176118850708
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0003209114074707
(22) DESCRIBE `ports` 0.0010309219360352
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00030899047851562
(24) DESCRIBE `ports` 0.0010190010070801
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00027585029602051
(26) DESCRIBE `ports` 0.0009160041809082
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00023102760314941
(28) DESCRIBE `ports` 0.00089907646179199
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00028014183044434
(30) DESCRIBE `ports` 0.00098085403442383
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00027203559875488
(32) DESCRIBE `ports` 0.00089097023010254
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00023889541625977
(34) DESCRIBE `ports` 0.00069904327392578
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00019192695617676
(36) DESCRIBE `ports` 0.00071597099304199
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00027894973754883
(38) DESCRIBE `ports` 0.000823974609375
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00023603439331055
(40) DESCRIBE `avid_specials` 0.0010631084442139
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57373 and class = 'Cruise') OR (item_id = 314 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 10 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.0016939640045166
(42) DESCRIBE `cruiselines` 0.0012788772583008
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0002739429473877
(44) DESCRIBE `orchid_image` 0.00088095664978027
(45) DESCRIBE `cruiselines` 0.0010280609130859
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00029516220092773
(47) DESCRIBE `cruises` 0.0014798641204834
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43646') 0.00024795532226562
(49) DESCRIBE `ships` 0.0014009475708008
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 405))) 0.00040006637573242
(51) DESCRIBE `ships` 0.0019888877868652
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '405') 0.00032496452331543
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021696090698242
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(55) DESCRIBE `itineraries` 0.0011019706726074
(56) DESCRIBE `ports` 0.00098419189453125
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00026178359985352
(58) DESCRIBE `ports` 0.00074100494384766
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002448558807373
(60) DESCRIBE `ports` 0.00066995620727539
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020194053649902
(62) DESCRIBE `sailingdates` 0.00078916549682617
(63) DESCRIBE `ports` 0.0012750625610352
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003349781036377
(65) DESCRIBE `ports` 0.00067996978759766
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00025582313537598
(67) DESCRIBE `ports` 0.00090289115905762
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0002751350402832
(69) DESCRIBE `ports` 0.0010578632354736
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00026988983154297
(71) DESCRIBE `ports` 0.00078392028808594
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00025701522827148
(73) DESCRIBE `ports` 0.00091409683227539
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00022792816162109
(75) DESCRIBE `ports` 0.0009920597076416
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035595893859863
(77) DESCRIBE `ports` 0.0010321140289307
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00030088424682617
(79) DESCRIBE `avid_specials` 0.00086116790771484
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43646 and class = 'Cruise') OR (item_id = 405 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015988349914551
(81) DESCRIBE `cruiselines` 0.001431941986084
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00035881996154785
(83) DESCRIBE `orchid_image` 0.001230001449585
(84) DESCRIBE `cruiselines` 0.0013809204101562
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0003049373626709
(86) DESCRIBE `cruises` 0.0027060508728027
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71097') 0.00043010711669922
(88) DESCRIBE `ships` 0.0024111270904541
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 212))) 0.00046396255493164
(90) DESCRIBE `ships` 0.0024268627166748
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '212') 0.00035905838012695
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024890899658203
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002739429473877
(94) DESCRIBE `itineraries` 0.0012030601501465
(95) DESCRIBE `ports` 0.0014472007751465
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00033807754516602
(97) DESCRIBE `ports` 0.001046895980835
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0004279613494873
(99) DESCRIBE `ports` 0.0011961460113525
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0003809928894043
(101) DESCRIBE `sailingdates` 0.0012738704681396
(102) DESCRIBE `ports` 0.0014510154724121
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00057101249694824
(104) DESCRIBE `ports` 0.001378059387207
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0003511905670166
(106) DESCRIBE `ports` 0.0012660026550293
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00034117698669434
(108) DESCRIBE `ports` 0.0011389255523682
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00029110908508301
(110) DESCRIBE `ports` 0.0014190673828125
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00038003921508789
(112) DESCRIBE `ports` 0.0012321472167969
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0003199577331543
(114) DESCRIBE `ports` 0.0016119480133057
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00048017501831055
(116) DESCRIBE `ports` 0.0014228820800781
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00034308433532715
(118) DESCRIBE `avid_specials` 0.0010230541229248
(119) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71097 and class = 'Cruise') OR (item_id = 212 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016300678253174
(120) DESCRIBE `cruiselines` 0.00164794921875
(121) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00040602684020996
(122) DESCRIBE `orchid_image` 0.0012350082397461
(123) DESCRIBE `cruiselines` 0.001471996307373
(124) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00030899047851562
(125) DESCRIBE `cruises` 0.0021660327911377
(126) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60002') 0.0003669261932373
(127) DESCRIBE `ships` 0.0018792152404785
(128) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 626))) 0.00044512748718262
(129) DESCRIBE `ships` 0.002086877822876
(130) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '626') 0.00034189224243164
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002129077911377
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019717216491699
(133) DESCRIBE `itineraries` 0.0010831356048584
(134) DESCRIBE `ports` 0.001121997833252
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00035595893859863
(136) DESCRIBE `ports` 0.00095796585083008
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00027298927307129
(138) DESCRIBE `ports` 0.0009310245513916
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00026607513427734
(140) DESCRIBE `sailingdates` 0.00084805488586426
(141) DESCRIBE `ports` 0.00096416473388672
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00030303001403809
(143) DESCRIBE `ports` 0.00095486640930176
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00029182434082031
(145) DESCRIBE `ports` 0.00097393989562988
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00028896331787109
(147) DESCRIBE `ports` 0.00089812278747559
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00024199485778809
(149) DESCRIBE `ports` 0.00090503692626953
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00027012825012207
(151) DESCRIBE `ports` 0.00088620185852051
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00025010108947754
(153) DESCRIBE `ports` 0.00096797943115234
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00029611587524414
(155) DESCRIBE `ports` 0.00089001655578613
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00023889541625977
(157) DESCRIBE `ports` 0.00087094306945801
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 126))) 0.00027799606323242
(159) DESCRIBE `ports` 0.00094699859619141
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '126') 0.00027990341186523
(161) DESCRIBE `ports` 0.00088596343994141
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00027585029602051
(163) DESCRIBE `ports` 0.00093793869018555
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00024008750915527
(165) DESCRIBE `avid_specials` 0.00080704689025879
(166) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60002 and class = 'Cruise') OR (item_id = 626 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 11 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.0015151500701904
(167) DESCRIBE `cruiselines` 0.0014269351959229
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00035595893859863
(169) DESCRIBE `orchid_image` 0.0012879371643066
(170) DESCRIBE `cruiselines` 0.0013220310211182
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00049614906311035
(172) DESCRIBE `cruises` 0.0024280548095703
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67120') 0.00033688545227051
(174) DESCRIBE `ships` 0.0016801357269287
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1569))) 0.0003209114074707
(176) DESCRIBE `ships` 0.0015320777893066
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1569') 0.00023508071899414
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00018310546875
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00022792816162109
(180) DESCRIBE `itineraries` 0.0010809898376465
(181) DESCRIBE `ports` 0.00093293190002441
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00031018257141113
(183) DESCRIBE `ports` 0.0011160373687744
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00022292137145996
(185) DESCRIBE `ports` 0.00082111358642578
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00021886825561523
(187) DESCRIBE `sailingdates` 0.00074386596679688
(188) DESCRIBE `ports` 0.0014669895172119
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00030303001403809
(190) DESCRIBE `ports` 0.00093793869018555
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0002448558807373
(192) DESCRIBE `ports` 0.0018050670623779
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00030398368835449
(194) DESCRIBE `ports` 0.0010890960693359
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00026297569274902
(196) DESCRIBE `ports` 0.0010011196136475
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00029993057250977
(198) DESCRIBE `ports` 0.0010559558868408
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.0002739429473877
(200) DESCRIBE `ports` 0.001209020614624
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3629))) 0.00031900405883789
(202) DESCRIBE `ports` 0.0010488033294678
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3629') 0.00026607513427734
(204) DESCRIBE `ports` 0.00076508522033691
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00025415420532227
(206) DESCRIBE `ports` 0.00079894065856934
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00020408630371094
(208) DESCRIBE `ports` 0.00089406967163086
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00033903121948242
(210) DESCRIBE `ports` 0.00092387199401855
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00026297569274902
(212) DESCRIBE `ports` 0.00078392028808594
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00023698806762695
(214) DESCRIBE `ports` 0.00085997581481934
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00022697448730469
(216) DESCRIBE `avid_specials` 0.0010831356048584
(217) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67120 and class = 'Cruise') OR (item_id = 1569 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.001910924911499
(218) DESCRIBE `cruiselines` 0.0017678737640381
(219) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00040817260742188
(220) DESCRIBE `orchid_image` 0.0013940334320068
(221) DESCRIBE `cruiselines` 0.0017008781433105
(222) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00032401084899902
(223) DESCRIBE `cruises` 0.0019447803497314
(224) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77398') 0.00038695335388184
(225) DESCRIBE `ships` 0.0014522075653076
(226) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) 0.00037002563476562
(227) DESCRIBE `ships` 0.002202033996582
(228) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '404') 0.00042510032653809
(229) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002901554107666
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(231) DESCRIBE `itineraries` 0.0011870861053467
(232) DESCRIBE `ports` 0.001215934753418
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00034308433532715
(234) DESCRIBE `ports` 0.00080013275146484
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00021481513977051
(236) DESCRIBE `ports` 0.00075507164001465
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00020003318786621
(238) DESCRIBE `sailingdates` 0.0006098747253418
(239) DESCRIBE `ports` 0.00086092948913574
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00031304359436035
(241) DESCRIBE `ports` 0.00099492073059082
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00024318695068359
(243) DESCRIBE `ports` 0.00095915794372559
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00024604797363281
(245) DESCRIBE `ports` 0.0010480880737305
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00027704238891602
(247) DESCRIBE `ports` 0.0010290145874023
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00033402442932129
(249) DESCRIBE `ports` 0.0011579990386963
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00030088424682617
(251) DESCRIBE `ports` 0.0010650157928467
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.0003359317779541
(253) DESCRIBE `ports` 0.0012049674987793
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00031399726867676
(255) DESCRIBE `ports` 0.0011529922485352
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00036787986755371
(257) DESCRIBE `ports` 0.00118088722229
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00029110908508301
(259) DESCRIBE `ports` 0.0010781288146973
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00030422210693359
(261) DESCRIBE `ports` 0.0010850429534912
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00025796890258789
(263) DESCRIBE `ports` 0.0010190010070801
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00029993057250977
(265) DESCRIBE `ports` 0.0010371208190918
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00025701522827148
(267) DESCRIBE `ports` 0.0010519027709961
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00029802322387695
(269) DESCRIBE `ports` 0.0010268688201904
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00025796890258789
(271) DESCRIBE `avid_specials` 0.00096392631530762
(272) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77398 and class = 'Cruise') OR (item_id = 404 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 29 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.001863956451416
(273) DESCRIBE `cruiselines` 0.0015571117401123
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00033998489379883
(275) DESCRIBE `orchid_image` 0.0012381076812744
(276) DESCRIBE `cruiselines` 0.0014510154724121
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00030994415283203
(278) DESCRIBE `cruises` 0.0021488666534424
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46637') 0.00033402442932129
(280) DESCRIBE `ships` 0.0020339488983154
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00038480758666992
(282) DESCRIBE `ships` 0.002079963684082
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00031495094299316
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022292137145996
(286) DESCRIBE `itineraries` 0.0010461807250977
(287) DESCRIBE `ports` 0.00087404251098633
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024986267089844
(289) DESCRIBE `ports` 0.00069713592529297
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024986267089844
(291) DESCRIBE `ports` 0.00084090232849121
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021004676818848
(293) DESCRIBE `sailingdates` 0.00066208839416504
(294) DESCRIBE `ports` 0.0013508796691895
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042891502380371
(296) DESCRIBE `ports` 0.0011899471282959
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026988983154297
(298) DESCRIBE `ports` 0.0010461807250977
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030303001403809
(300) DESCRIBE `ports` 0.0010550022125244
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00026488304138184
(302) DESCRIBE `ports` 0.0010578632354736
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030517578125
(304) DESCRIBE `ports` 0.0010569095611572
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026106834411621
(306) DESCRIBE `ports` 0.0010159015655518
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00029683113098145
(308) DESCRIBE `ports` 0.0010840892791748
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027585029602051
(310) DESCRIBE `ports` 0.0010459423065186
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00030303001403809
(312) DESCRIBE `ports` 0.0010628700256348
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00026106834411621
(314) DESCRIBE `ports` 0.0010190010070801
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00032901763916016
(316) DESCRIBE `ports` 0.0010290145874023
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00025296211242676
(318) DESCRIBE `ports` 0.0010159015655518
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031113624572754
(320) DESCRIBE `ports` 0.0010340213775635
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025200843811035
(322) DESCRIBE `avid_specials` 0.00095510482788086
(323) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46637 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.0017290115356445
(324) DESCRIBE `cruiselines` 0.0016489028930664
(325) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00038385391235352
(326) DESCRIBE `orchid_image` 0.0013091564178467
(327) DESCRIBE `cruiselines` 0.0014920234680176
(328) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00030994415283203
(329) DESCRIBE `cruises` 0.0021390914916992
(330) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66788') 0.00035190582275391
(331) DESCRIBE `ships` 0.002155065536499
(332) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1193))) 0.00040411949157715
(333) DESCRIBE `ships` 0.0021610260009766
(334) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1193') 0.00034785270690918
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002439022064209
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023007392883301
(337) DESCRIBE `itineraries` 0.0011119842529297
(338) DESCRIBE `ports` 0.0011529922485352
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00033187866210938
(340) DESCRIBE `ports` 0.0010511875152588
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00028610229492188
(342) DESCRIBE `ports` 0.0010390281677246
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00026917457580566
(344) DESCRIBE `sailingdates` 0.00092196464538574
(345) DESCRIBE `ports` 0.0014321804046631
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00035405158996582
(347) DESCRIBE `ports` 0.0022997856140137
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00036287307739258
(349) DESCRIBE `ports` 0.0012109279632568
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00030708312988281
(351) DESCRIBE `ports` 0.001121997833252
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00029301643371582
(353) DESCRIBE `ports` 0.0011060237884521
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00032305717468262
(355) DESCRIBE `ports` 0.0011129379272461
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.0003049373626709
(357) DESCRIBE `ports` 0.0011329650878906
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00034999847412109
(359) DESCRIBE `ports` 0.0012001991271973
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00031590461730957
(361) DESCRIBE `ports` 0.0011579990386963
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00034213066101074
(363) DESCRIBE `ports` 0.0011658668518066
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00030803680419922
(365) DESCRIBE `avid_specials` 0.0010750293731689
(366) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66788 and class = 'Cruise') OR (item_id = 1193 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 10 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.0019369125366211
(367) DESCRIBE `cruiselines` 0.0017609596252441
(368) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00045299530029297
(369) DESCRIBE `orchid_image` 0.0013840198516846
(370) DESCRIBE `cruiselines` 0.0017778873443604
(371) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00031113624572754
(372) DESCRIBE `cruises` 0.0015320777893066
(373) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66973') 0.00030303001403809
(374) DESCRIBE `ships` 0.0014429092407227
(375) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 574))) 0.0003211498260498
(376) DESCRIBE `ships` 0.002051830291748
(377) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '574') 0.00034999847412109
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024199485778809
(379) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023293495178223
(380) DESCRIBE `itineraries` 0.0012030601501465
(381) DESCRIBE `ports` 0.0014147758483887
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00032806396484375
(383) DESCRIBE `ports` 0.0011417865753174
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00034499168395996
(385) DESCRIBE `ports` 0.0011839866638184
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00029802322387695
(387) DESCRIBE `sailingdates` 0.00078916549682617
(388) DESCRIBE `ports` 0.0013000965118408
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00038695335388184
(390) DESCRIBE `ports` 0.0012059211730957
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00030899047851562
(392) DESCRIBE `ports` 0.0011181831359863
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0003209114074707
(394) DESCRIBE `ports` 0.0011019706726074
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00028014183044434
(396) DESCRIBE `ports` 0.0010838508605957
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00032305717468262
(398) DESCRIBE `ports` 0.0012528896331787
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00030612945556641
(400) DESCRIBE `ports` 0.0012099742889404
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00035786628723145
(402) DESCRIBE `ports` 0.0010960102081299
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00026798248291016
(404) DESCRIBE `ports` 0.0010960102081299
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0003361701965332
(406) DESCRIBE `ports` 0.0010831356048584
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00027680397033691
(408) DESCRIBE `ports` 0.0011260509490967
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00032901763916016
(410) DESCRIBE `ports` 0.0011708736419678
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00036501884460449
(412) DESCRIBE `ports` 0.0011389255523682
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00034093856811523
(414) DESCRIBE `ports` 0.0012459754943848
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0003349781036377
(416) DESCRIBE `avid_specials` 0.0010929107666016
(417) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66973 and class = 'Cruise') OR (item_id = 574 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.0018880367279053
(418) DESCRIBE `cruiselines` 0.0017259120941162
(419) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00063300132751465
(420) DESCRIBE `orchid_image` 0.0014920234680176
(421) DESCRIBE `cruiselines` 0.002439022064209
(422) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00041794776916504
(423) DESCRIBE `cruises` 0.002938985824585
(424) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00040698051452637
(425) DESCRIBE `ships` 0.0024099349975586
(426) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00050902366638184
(427) DESCRIBE `ships` 0.0024709701538086
(428) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00035405158996582
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026202201843262
(431) DESCRIBE `itineraries` 0.0011610984802246
(432) DESCRIBE `ports` 0.0012280941009521
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003049373626709
(434) DESCRIBE `ports` 0.00092697143554688
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023913383483887
(436) DESCRIBE `ports` 0.00094294548034668
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027298927307129
(438) DESCRIBE `sailingdates` 0.00093793869018555
(439) DESCRIBE `ports` 0.0009610652923584
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003669261932373
(441) DESCRIBE `ports` 0.0010750293731689
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00025415420532227
(443) DESCRIBE `ports` 0.00095105171203613
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00028610229492188
(445) DESCRIBE `ports` 0.0010612010955811
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00024914741516113
(447) DESCRIBE `ports` 0.0011229515075684
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00033211708068848
(449) DESCRIBE `ports` 0.0011332035064697
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00032496452331543
(451) DESCRIBE `ports` 0.0010957717895508
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00031805038452148
(453) DESCRIBE `ports` 0.001154899597168
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00028705596923828
(455) DESCRIBE `ports` 0.0010461807250977
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00031280517578125
(457) DESCRIBE `ports` 0.001032829284668
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00026988983154297
(459) DESCRIBE `ports` 0.00093603134155273
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00033807754516602
(461) DESCRIBE `ports` 0.001039981842041
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027799606323242
(463) DESCRIBE `ports` 0.0010418891906738
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029397010803223
(465) DESCRIBE `ports` 0.00095200538635254
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002589225769043
(467) DESCRIBE `avid_specials` 0.0010910034179688
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66996 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.001708984375
(469) DESCRIBE `cruiselines` 0.0015900135040283
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00034403800964355
(471) DESCRIBE `orchid_image` 0.0011990070343018
(472) DESCRIBE `cruiselines` 0.001575231552124
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00031495094299316
(474) DESCRIBE `ships` 0.002269983291626
(475) SELECT `ships`.* FROM `ships` WHERE (id IN ('404', '770', '1193', '405', '1569', '1008', '1088', '314', '626', '93', '574', '448', '485', '212', '665', '1721')) ORDER BY FIND_IN_SET(id, '404,770,1193,405,1569,1008,1088,314,626,93,574,448,485,212,665,1721') 0.0013010501861572
(476) DESCRIBE `cruisetypes` 0.0012311935424805
(477) DESCRIBE `destinations` 0.0047030448913574
(478) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '22', '29', '9', '2', '10', '26', '11', '48', '53', '28', '37', '38', '25', '43', '21', '49', '8', '35', '34')) ORDER BY FIND_IN_SET(id, '12,22,29,9,2,10,26,11,48,53,28,37,38,25,43,21,49,8,35,34') 0.0013909339904785
(479) DESCRIBE `cruiselines` 0.001945972442627
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00049400329589844
(481) DESCRIBE `cruiselines` 0.0018739700317383
(482) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00039386749267578