or, enquire about your chosen options

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

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

Total elapsed time: 0.32993292808533

# Query Time
(1) connect 0.00086307525634766
(2) DESCRIBE `cruises` 0.002190113067627
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62516, 67864, 15922, 27131, 67875, 66480, 66526, 70581, 66663, 54648)) ORDER BY FIND_IN_SET(id, '62516,67864,15922,27131,67875,66480,66526,70581,66663,54648') 0.0014309883117676
(4) DESCRIBE `cruises` 0.0015120506286621
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62516') 0.00024080276489258
(6) DESCRIBE `ships` 0.0013120174407959
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00024890899658203
(8) DESCRIBE `ships` 0.0012779235839844
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00052809715270996
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031018257141113
(12) DESCRIBE `itineraries` 0.0013730525970459
(13) DESCRIBE `ports` 0.0012688636779785
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00046300888061523
(15) DESCRIBE `ports` 0.0016500949859619
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00035500526428223
(17) DESCRIBE `ports` 0.0012109279632568
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00032711029052734
(19) DESCRIBE `sailingdates` 0.0010569095611572
(20) DESCRIBE `ports` 0.0012199878692627
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020694732666016
(22) DESCRIBE `ports` 0.00069284439086914
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018405914306641
(24) DESCRIBE `ports` 0.00067400932312012
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00020003318786621
(26) DESCRIBE `ports` 0.00066900253295898
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00018119812011719
(28) DESCRIBE `ports` 0.00068402290344238
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00019598007202148
(30) DESCRIBE `ports` 0.00068807601928711
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00018000602722168
(32) DESCRIBE `ports` 0.00066995620727539
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00020980834960938
(34) DESCRIBE `ports` 0.0006859302520752
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00019192695617676
(36) DESCRIBE `ports` 0.00069713592529297
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00020289421081543
(38) DESCRIBE `ports` 0.00066685676574707
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018882751464844
(40) DESCRIBE `ports` 0.00066900253295898
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00020098686218262
(42) DESCRIBE `ports` 0.00066399574279785
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00018191337585449
(44) DESCRIBE `ports` 0.00067615509033203
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00021004676818848
(46) DESCRIBE `ports` 0.00067615509033203
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00018405914306641
(48) DESCRIBE `ports` 0.0008080005645752
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020408630371094
(50) DESCRIBE `ports` 0.00070595741271973
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018095970153809
(52) DESCRIBE `avid_specials` 0.00064897537231445
(53) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62516 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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.00094294548034668
(54) DESCRIBE `cruiselines` 0.0010130405426025
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022006034851074
(56) DESCRIBE `orchid_image` 0.00076699256896973
(57) DESCRIBE `cruiselines` 0.00098586082458496
(58) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019311904907227
(59) DESCRIBE `cruises` 0.0012850761413574
(60) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67864') 0.00020480155944824
(61) DESCRIBE `ships` 0.0013120174407959
(62) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00024294853210449
(63) DESCRIBE `ships` 0.0012569427490234
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.0001990795135498
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(67) DESCRIBE `itineraries` 0.00070500373840332
(68) DESCRIBE `ports` 0.00077605247497559
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021505355834961
(70) DESCRIBE `ports` 0.0006859302520752
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00020098686218262
(72) DESCRIBE `ports` 0.0006709098815918
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018191337585449
(74) DESCRIBE `sailingdates` 0.00062394142150879
(75) DESCRIBE `ports` 0.00078892707824707
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021696090698242
(77) DESCRIBE `ports` 0.00078701972961426
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00022506713867188
(79) DESCRIBE `ports` 0.00072884559631348
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.0002140998840332
(81) DESCRIBE `ports` 0.00067996978759766
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00018191337585449
(83) DESCRIBE `ports` 0.00075793266296387
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5651))) 0.0001988410949707
(85) DESCRIBE `ports` 0.00066804885864258
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5651') 0.00017905235290527
(87) DESCRIBE `ports` 0.00066709518432617
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00020003318786621
(89) DESCRIBE `ports` 0.00069999694824219
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00019192695617676
(91) DESCRIBE `ports` 0.00066304206848145
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4475))) 0.00019407272338867
(93) DESCRIBE `ports` 0.00066518783569336
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4475') 0.0002131462097168
(95) DESCRIBE `ports` 0.00078678131103516
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00023388862609863
(97) DESCRIBE `ports` 0.00072503089904785
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00024199485778809
(99) DESCRIBE `ports` 0.00072097778320312
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1432))) 0.00020098686218262
(101) DESCRIBE `ports` 0.00067400932312012
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1432') 0.0001828670501709
(103) DESCRIBE `ports` 0.00066494941711426
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1433))) 0.00020003318786621
(105) DESCRIBE `ports` 0.00070095062255859
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1433') 0.00018191337585449
(107) DESCRIBE `ports` 0.00067806243896484
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5353))) 0.00023984909057617
(109) DESCRIBE `ports` 0.00066208839416504
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5353') 0.0001828670501709
(111) DESCRIBE `ports` 0.00069904327392578
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00020480155944824
(113) DESCRIBE `ports` 0.00068306922912598
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00017905235290527
(115) DESCRIBE `avid_specials` 0.00060820579528809
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67864 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 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.00094699859619141
(117) DESCRIBE `cruiselines` 0.0010190010070801
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022697448730469
(119) DESCRIBE `orchid_image` 0.00080108642578125
(120) DESCRIBE `cruiselines` 0.00094819068908691
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019288063049316
(122) DESCRIBE `cruises` 0.0012950897216797
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '15922') 0.00021982192993164
(124) DESCRIBE `ships` 0.0013551712036133
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 291))) 0.00027012825012207
(126) DESCRIBE `ships` 0.0012729167938232
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '291') 0.00017881393432617
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(130) DESCRIBE `itineraries` 0.00067687034606934
(131) DESCRIBE `ports` 0.00070691108703613
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022602081298828
(133) DESCRIBE `ports` 0.00073480606079102
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020408630371094
(135) DESCRIBE `ports` 0.00070285797119141
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019693374633789
(137) DESCRIBE `sailingdates` 0.00061511993408203
(138) DESCRIBE `ports` 0.00076818466186523
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00024700164794922
(140) DESCRIBE `ports` 0.00068306922912598
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019407272338867
(142) DESCRIBE `ports` 0.00071191787719727
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00021886825561523
(144) DESCRIBE `ports` 0.00069618225097656
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018882751464844
(146) DESCRIBE `ports` 0.00068402290344238
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020098686218262
(148) DESCRIBE `ports` 0.00066804885864258
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018310546875
(150) DESCRIBE `ports` 0.00078582763671875
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020194053649902
(152) DESCRIBE `ports` 0.00073599815368652
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00020694732666016
(154) DESCRIBE `ports` 0.00080084800720215
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00027894973754883
(156) DESCRIBE `ports` 0.00097894668579102
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00026702880859375
(158) DESCRIBE `ports` 0.00087904930114746
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00025510787963867
(160) DESCRIBE `ports` 0.00095510482788086
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00023603439331055
(162) DESCRIBE `ports` 0.00080513954162598
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00022292137145996
(164) DESCRIBE `ports` 0.00070285797119141
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00024294853210449
(166) DESCRIBE `avid_specials` 0.00079989433288574
(167) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 15922 and class = 'Cruise') OR (item_id = 291 AND class = 'Ship') OR (item_id = 23 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.0012290477752686
(168) DESCRIBE `cruiselines` 0.001209020614624
(169) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00026106834411621
(170) DESCRIBE `orchid_image` 0.00090909004211426
(171) DESCRIBE `cruiselines` 0.0011429786682129
(172) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020909309387207
(173) DESCRIBE `cruises` 0.0016019344329834
(174) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '27131') 0.00023388862609863
(175) DESCRIBE `ships` 0.0015730857849121
(176) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 348))) 0.00030112266540527
(177) DESCRIBE `ships` 0.0013871192932129
(178) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '348') 0.00017714500427246
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023007392883301
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(181) DESCRIBE `itineraries` 0.00066590309143066
(182) DESCRIBE `ports` 0.00070905685424805
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00022292137145996
(184) DESCRIBE `ports` 0.00084018707275391
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00024104118347168
(186) DESCRIBE `ports` 0.00075984001159668
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00019407272338867
(188) DESCRIBE `sailingdates` 0.00081396102905273
(189) DESCRIBE `ports` 0.000762939453125
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00022697448730469
(191) DESCRIBE `ports` 0.00073003768920898
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00019001960754395
(193) DESCRIBE `ports` 0.00076889991760254
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00020599365234375
(195) DESCRIBE `ports` 0.00084805488586426
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00018715858459473
(197) DESCRIBE `ports` 0.00076985359191895
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00022697448730469
(199) DESCRIBE `ports` 0.00083613395690918
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00025391578674316
(201) DESCRIBE `ports` 0.00082612037658691
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020599365234375
(203) DESCRIBE `ports` 0.00084900856018066
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.0002281665802002
(205) DESCRIBE `ports` 0.00091695785522461
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020813941955566
(207) DESCRIBE `ports` 0.00068902969360352
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018715858459473
(209) DESCRIBE `ports` 0.00081300735473633
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00021100044250488
(211) DESCRIBE `ports` 0.00079703330993652
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00023388862609863
(213) DESCRIBE `ports` 0.00073981285095215
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022602081298828
(215) DESCRIBE `ports` 0.0006709098815918
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019192695617676
(217) DESCRIBE `avid_specials` 0.00063490867614746
(218) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 27131 and class = 'Cruise') OR (item_id = 348 AND class = 'Ship') OR (item_id = 23 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.00098395347595215
(219) DESCRIBE `cruiselines` 0.00098299980163574
(220) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022220611572266
(221) DESCRIBE `orchid_image` 0.00075507164001465
(222) DESCRIBE `cruiselines` 0.0009310245513916
(223) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019598007202148
(224) DESCRIBE `cruises` 0.0012891292572021
(225) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67875') 0.00020980834960938
(226) DESCRIBE `ships` 0.0013518333435059
(227) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00037193298339844
(228) DESCRIBE `ships` 0.0020368099212646
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00025105476379395
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018811225891113
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022006034851074
(232) DESCRIBE `itineraries` 0.00087380409240723
(233) DESCRIBE `ports` 0.00070309638977051
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00025606155395508
(235) DESCRIBE `ports` 0.00070905685424805
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00026392936706543
(237) DESCRIBE `ports` 0.0007331371307373
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00023603439331055
(239) DESCRIBE `sailingdates` 0.00067615509033203
(240) DESCRIBE `ports` 0.00068998336791992
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0002129077911377
(242) DESCRIBE `ports` 0.00070095062255859
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018596649169922
(244) DESCRIBE `ports` 0.0006709098815918
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00020790100097656
(246) DESCRIBE `ports` 0.00067305564880371
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.0001828670501709
(248) DESCRIBE `ports` 0.00068902969360352
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5651))) 0.00020909309387207
(250) DESCRIBE `ports` 0.00067400932312012
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5651') 0.00018095970153809
(252) DESCRIBE `ports` 0.00067996978759766
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00020122528076172
(254) DESCRIBE `ports` 0.00067305564880371
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00019717216491699
(256) DESCRIBE `avid_specials` 0.00062012672424316
(257) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67875 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 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.00096797943115234
(258) DESCRIBE `cruiselines` 0.00098490715026855
(259) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022721290588379
(260) DESCRIBE `orchid_image` 0.00076603889465332
(261) DESCRIBE `cruiselines` 0.0010621547698975
(262) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00024795532226562
(263) DESCRIBE `cruises` 0.0020511150360107
(264) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66480') 0.00027608871459961
(265) DESCRIBE `ships` 0.0019979476928711
(266) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00032496452331543
(267) DESCRIBE `ships` 0.0019068717956543
(268) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00019001960754395
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(271) DESCRIBE `itineraries` 0.00067996978759766
(272) DESCRIBE `ports` 0.00069499015808105
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00022602081298828
(274) DESCRIBE `ports` 0.00068783760070801
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020098686218262
(276) DESCRIBE `ports` 0.00072002410888672
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018405914306641
(278) DESCRIBE `sailingdates` 0.00061202049255371
(279) DESCRIBE `ports` 0.00068402290344238
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00024008750915527
(281) DESCRIBE `ports` 0.00079488754272461
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018906593322754
(283) DESCRIBE `ports` 0.00067710876464844
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00020503997802734
(285) DESCRIBE `ports` 0.0007169246673584
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00018191337585449
(287) DESCRIBE `ports` 0.00069093704223633
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3149))) 0.00020194053649902
(289) DESCRIBE `ports` 0.00067710876464844
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3149') 0.00018191337585449
(291) DESCRIBE `ports` 0.00074005126953125
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) 0.00020289421081543
(293) DESCRIBE `ports` 0.00069117546081543
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') 0.00018095970153809
(295) DESCRIBE `ports` 0.00067877769470215
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00020694732666016
(297) DESCRIBE `ports` 0.00073695182800293
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00018501281738281
(299) DESCRIBE `ports` 0.00067400932312012
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00020503997802734
(301) DESCRIBE `ports` 0.0006721019744873
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00021100044250488
(303) DESCRIBE `ports` 0.00067305564880371
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00020003318786621
(305) DESCRIBE `ports` 0.00068998336791992
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00018000602722168
(307) DESCRIBE `ports` 0.00068402290344238
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00020003318786621
(309) DESCRIBE `ports` 0.00067400932312012
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00018191337585449
(311) DESCRIBE `ports` 0.0006718635559082
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 800))) 0.00020194053649902
(313) DESCRIBE `ports` 0.00070595741271973
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '800') 0.00018119812011719
(315) DESCRIBE `ports` 0.00067496299743652
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00021600723266602
(317) DESCRIBE `ports` 0.00067996978759766
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00018501281738281
(319) DESCRIBE `ports` 0.00069904327392578
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00020003318786621
(321) DESCRIBE `ports` 0.00067877769470215
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018000602722168
(323) DESCRIBE `ports` 0.00083494186401367
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020718574523926
(325) DESCRIBE `ports` 0.00075912475585938
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00020313262939453
(327) DESCRIBE `avid_specials` 0.0009160041809082
(328) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66480 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 25 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.0010271072387695
(329) DESCRIBE `cruiselines` 0.0010340213775635
(330) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022792816162109
(331) DESCRIBE `orchid_image` 0.000762939453125
(332) DESCRIBE `cruiselines` 0.00095105171203613
(333) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019288063049316
(334) DESCRIBE `cruises` 0.0014090538024902
(335) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66526') 0.00022006034851074
(336) DESCRIBE `ships` 0.0013198852539062
(337) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00023698806762695
(338) DESCRIBE `ships` 0.0012869834899902
(339) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00021100044250488
(340) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(342) DESCRIBE `itineraries` 0.00073695182800293
(343) DESCRIBE `ports` 0.00072598457336426
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002291202545166
(345) DESCRIBE `ports` 0.00074410438537598
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019383430480957
(347) DESCRIBE `ports` 0.00075387954711914
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019621849060059
(349) DESCRIBE `sailingdates` 0.00061798095703125
(350) DESCRIBE `ports` 0.00072479248046875
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002140998840332
(352) DESCRIBE `ports` 0.00069499015808105
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019383430480957
(354) DESCRIBE `ports` 0.00069403648376465
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00021004676818848
(356) DESCRIBE `ports` 0.00066399574279785
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00018787384033203
(358) DESCRIBE `ports` 0.0007011890411377
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020313262939453
(360) DESCRIBE `ports` 0.00069117546081543
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00017881393432617
(362) DESCRIBE `ports` 0.00071382522583008
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020003318786621
(364) DESCRIBE `ports` 0.00067520141601562
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017619132995605
(366) DESCRIBE `ports` 0.00073480606079102
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00022482872009277
(368) DESCRIBE `ports` 0.00067710876464844
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00017881393432617
(370) DESCRIBE `ports` 0.00067400932312012
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022196769714355
(372) DESCRIBE `ports` 0.00068211555480957
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017690658569336
(374) DESCRIBE `ports` 0.00066399574279785
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00019693374633789
(376) DESCRIBE `ports` 0.00068807601928711
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00023221969604492
(378) DESCRIBE `ports` 0.00068807601928711
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00023603439331055
(380) DESCRIBE `ports` 0.00067687034606934
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017404556274414
(382) DESCRIBE `ports` 0.00069594383239746
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00019598007202148
(384) DESCRIBE `ports` 0.00065803527832031
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018596649169922
(386) DESCRIBE `ports` 0.00074195861816406
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3719))) 0.00019598007202148
(388) DESCRIBE `ports` 0.00071597099304199
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3719') 0.00020217895507812
(390) DESCRIBE `ports` 0.00089192390441895
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020408630371094
(392) DESCRIBE `ports` 0.00065803527832031
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00017309188842773
(394) DESCRIBE `ports` 0.00096297264099121
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019407272338867
(396) DESCRIBE `ports` 0.00066184997558594
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017189979553223
(398) DESCRIBE `avid_specials` 0.00085282325744629
(399) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66526 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 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.00090479850769043
(400) DESCRIBE `cruiselines` 0.00099802017211914
(401) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021600723266602
(402) DESCRIBE `orchid_image` 0.00092887878417969
(403) DESCRIBE `cruiselines` 0.00097417831420898
(404) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018000602722168
(405) DESCRIBE `cruises` 0.0013389587402344
(406) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70581') 0.0002140998840332
(407) DESCRIBE `ships` 0.0013480186462402
(408) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00022602081298828
(409) DESCRIBE `ships` 0.0012679100036621
(410) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00016999244689941
(411) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019407272338867
(412) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(413) DESCRIBE `itineraries` 0.00080490112304688
(414) DESCRIBE `ports` 0.00070691108703613
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020480155944824
(416) DESCRIBE `ports` 0.00083613395690918
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019383430480957
(418) DESCRIBE `ports` 0.00085997581481934
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017499923706055
(420) DESCRIBE `sailingdates` 0.00063896179199219
(421) DESCRIBE `ports` 0.00067901611328125
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019001960754395
(423) DESCRIBE `ports` 0.00070285797119141
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017309188842773
(425) DESCRIBE `ports` 0.0006711483001709
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00023818016052246
(427) DESCRIBE `ports` 0.00070595741271973
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00017499923706055
(429) DESCRIBE `ports` 0.00069403648376465
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00023508071899414
(431) DESCRIBE `ports` 0.00082206726074219
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00017714500427246
(433) DESCRIBE `ports` 0.00069904327392578
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00019001960754395
(435) DESCRIBE `ports` 0.00069689750671387
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00019097328186035
(437) DESCRIBE `ports` 0.00069594383239746
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0001990795135498
(439) DESCRIBE `ports` 0.0008690357208252
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017499923706055
(441) DESCRIBE `ports` 0.00066018104553223
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00020003318786621
(443) DESCRIBE `ports` 0.00069594383239746
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00026202201843262
(445) DESCRIBE `ports` 0.0010240077972412
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00026392936706543
(447) DESCRIBE `ports` 0.0011749267578125
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00029206275939941
(449) DESCRIBE `ports` 0.00090694427490234
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00025701522827148
(451) DESCRIBE `ports` 0.0011270046234131
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00023198127746582
(453) DESCRIBE `ports` 0.0010099411010742
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020694732666016
(455) DESCRIBE `ports` 0.00072598457336426
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00017905235290527
(457) DESCRIBE `ports` 0.00069618225097656
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021100044250488
(459) DESCRIBE `ports` 0.00066614151000977
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017714500427246
(461) DESCRIBE `avid_specials` 0.00060796737670898
(462) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70581 and class = 'Cruise') OR (item_id = 434 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001032829284668
(463) DESCRIBE `cruiselines` 0.0010249614715576
(464) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00024199485778809
(465) DESCRIBE `orchid_image` 0.00077199935913086
(466) DESCRIBE `cruiselines` 0.00094294548034668
(467) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00017714500427246
(468) DESCRIBE `cruises` 0.0013091564178467
(469) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66663') 0.00019097328186035
(470) DESCRIBE `ships` 0.00130295753479
(471) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00023198127746582
(472) DESCRIBE `ships` 0.00136399269104
(473) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00017499923706055
(474) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(475) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(476) DESCRIBE `itineraries` 0.00083017349243164
(477) DESCRIBE `ports` 0.00069284439086914
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00020384788513184
(479) DESCRIBE `ports` 0.00067901611328125
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00021910667419434
(481) DESCRIBE `ports` 0.00067710876464844
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00023007392883301
(483) DESCRIBE `sailingdates` 0.00060606002807617
(484) DESCRIBE `ports` 0.00069999694824219
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00023508071899414
(486) DESCRIBE `ports` 0.0006709098815918
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00029611587524414
(488) DESCRIBE `ports` 0.0049369335174561
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00030207633972168
(490) DESCRIBE `ports` 0.00070595741271973
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00019407272338867
(492) DESCRIBE `ports` 0.00084686279296875
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00023293495178223
(494) DESCRIBE `ports` 0.00087308883666992
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00023889541625977
(496) DESCRIBE `ports` 0.0007469654083252
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00022506713867188
(498) DESCRIBE `ports` 0.00067496299743652
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00018191337585449
(500) DESCRIBE `ports` 0.00075387954711914
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020217895507812
(502) DESCRIBE `ports` 0.00068807601928711
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00017499923706055
(504) DESCRIBE `ports` 0.00066399574279785
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0002131462097168
(506) DESCRIBE `ports` 0.00067710876464844
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00019502639770508
(508) DESCRIBE `ports` 0.00088286399841309
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00020313262939453
(510) DESCRIBE `ports` 0.00091195106506348
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00019216537475586
(512) DESCRIBE `ports` 0.00073790550231934
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0002138614654541
(514) DESCRIBE `ports` 0.00068998336791992
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00018811225891113
(516) DESCRIBE `ports` 0.00067400932312012
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0002140998840332
(518) DESCRIBE `ports` 0.00070309638977051
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018906593322754
(520) DESCRIBE `avid_specials` 0.00061702728271484
(521) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66663 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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
(522) DESCRIBE `cruiselines` 0.0009918212890625
(523) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022411346435547
(524) DESCRIBE `orchid_image` 0.00078606605529785
(525) DESCRIBE `cruiselines` 0.00092411041259766
(526) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019001960754395
(527) DESCRIBE `cruises` 0.001305103302002
(528) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54648') 0.00022482872009277
(529) DESCRIBE `ships` 0.0014541149139404
(530) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.0002741813659668
(531) DESCRIBE `ships` 0.0020651817321777
(532) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.00029706954956055
(533) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027704238891602
(534) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021696090698242
(535) DESCRIBE `itineraries` 0.0010530948638916
(536) DESCRIBE `ports` 0.00075912475585938
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00023698806762695
(538) DESCRIBE `ports` 0.00074481964111328
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020217895507812
(540) DESCRIBE `ports` 0.00069904327392578
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019311904907227
(542) DESCRIBE `sailingdates` 0.00061392784118652
(543) DESCRIBE `ports` 0.00087285041809082
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00029301643371582
(545) DESCRIBE `ports` 0.00070691108703613
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019383430480957
(547) DESCRIBE `ports` 0.00067710876464844
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020194053649902
(549) DESCRIBE `ports` 0.00070309638977051
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00021219253540039
(551) DESCRIBE `ports` 0.00075292587280273
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020289421081543
(553) DESCRIBE `ports` 0.00066614151000977
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017786026000977
(555) DESCRIBE `ports` 0.00067901611328125
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00021505355834961
(557) DESCRIBE `ports` 0.00065994262695312
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018501281738281
(559) DESCRIBE `ports` 0.00066089630126953
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020003318786621
(561) DESCRIBE `ports` 0.00065994262695312
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00018000602722168
(563) DESCRIBE `ports` 0.0019540786743164
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00020790100097656
(565) DESCRIBE `ports` 0.00072503089904785
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00020885467529297
(567) DESCRIBE `ports` 0.00067687034606934
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020098686218262
(569) DESCRIBE `ports` 0.00067496299743652
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00018715858459473
(571) DESCRIBE `avid_specials` 0.00085592269897461
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54648 and class = 'Cruise') OR (item_id = 290 AND class = 'Ship') OR (item_id = 23 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.0014908313751221
(573) DESCRIBE `cruiselines` 0.0009758472442627
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021815299987793
(575) DESCRIBE `orchid_image` 0.0009000301361084
(576) DESCRIBE `cruiselines` 0.0010850429534912
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018906593322754
(578) DESCRIBE `ships` 0.0013718605041504
(579) SELECT `ships`.* FROM `ships` WHERE (id IN ('1135', '349', '542', '1021', '434', '253', '580', '678', '406', '348', '451', '290', '291', '98', '341', '105', '1682', '1409')) ORDER BY FIND_IN_SET(id, '1135,349,542,1021,434,253,580,678,406,348,451,290,291,98,341,105,1682,1409') 0.00075197219848633
(580) DESCRIBE `cruisetypes` 0.0007021427154541
(581) DESCRIBE `destinations` 0.00089192390441895
(582) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '2', '43', '22', '8', '26', '48', '53', '34', '21', '40', '29', '38', '37', '11', '25', '28', '49', '7', '30')) ORDER BY FIND_IN_SET(id, '12,35,2,43,22,8,26,48,53,34,21,40,29,38,37,11,25,28,49,7,30') 0.00078892707824707
(583) DESCRIBE `cruiselines` 0.0010650157928467
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00024104118347168
(585) DESCRIBE `cruiselines` 0.0011467933654785
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023508071899414