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

Total elapsed time: 0.47757625579834

# Query Time
(1) connect 0.00070691108703613
(2) DESCRIBE `cruises` 0.0021049976348877
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (60180, 58853, 60181, 60199, 58858, 60235, 58859, 60236, 75541, 60237)) ORDER BY FIND_IN_SET(id, '60180,58853,60181,60199,58858,60235,58859,60236,75541,60237') 0.0013070106506348
(4) DESCRIBE `cruises` 0.0017821788787842
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60180') 0.00029706954956055
(6) DESCRIBE `ships` 0.0014979839324951
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00028705596923828
(8) DESCRIBE `ships` 0.0014009475708008
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00023794174194336
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018715858459473
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017714500427246
(12) DESCRIBE `itineraries` 0.0008389949798584
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60180') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048112869262695
(14) DESCRIBE `ports` 0.00096893310546875
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00026297569274902
(16) DESCRIBE `ports` 0.00076699256896973
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00022506713867188
(18) DESCRIBE `ports` 0.00074911117553711
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00022006034851074
(20) DESCRIBE `sailingdates` 0.0006718635559082
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60180') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052309036254883
(22) DESCRIBE `ports` 0.00081801414489746
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00024509429931641
(24) DESCRIBE `ports` 0.00071001052856445
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0001988410949707
(26) DESCRIBE `ports` 0.0006859302520752
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0002129077911377
(28) DESCRIBE `ports` 0.00069999694824219
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0001981258392334
(30) DESCRIBE `ports` 0.00069308280944824
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0002131462097168
(32) DESCRIBE `ports` 0.00084996223449707
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00023603439331055
(34) DESCRIBE `ports` 0.0007939338684082
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00022292137145996
(36) DESCRIBE `ports` 0.00069499015808105
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00019407272338867
(38) DESCRIBE `ports` 0.00073504447937012
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00021886825561523
(40) DESCRIBE `ports` 0.00069403648376465
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.00019502639770508
(42) DESCRIBE `ports` 0.00094389915466309
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4794))) 0.00024199485778809
(44) DESCRIBE `ports` 0.00072503089904785
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4794') 0.00020599365234375
(46) DESCRIBE `ports` 0.00069594383239746
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00022006034851074
(48) DESCRIBE `ports` 0.00069093704223633
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00019192695617676
(50) DESCRIBE `ports` 0.00068497657775879
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002131462097168
(52) DESCRIBE `ports` 0.00075507164001465
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0001978874206543
(54) DESCRIBE `ports` 0.00068378448486328
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020694732666016
(56) DESCRIBE `ports` 0.00066995620727539
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018095970153809
(58) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60180') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0057339668273926
(59) DESCRIBE `avid_specials` 0.00072789192199707
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60180 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00095510482788086
(61) DESCRIBE `cruiselines` 0.0010149478912354
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023484230041504
(63) DESCRIBE `orchid_image` 0.0010149478912354
(64) DESCRIBE `cruiselines` 0.0010490417480469
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00021600723266602
(66) DESCRIBE `cruises` 0.0014951229095459
(67) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58853') 0.00025200843811035
(68) DESCRIBE `ships` 0.0016789436340332
(69) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00029611587524414
(70) DESCRIBE `ships` 0.0015749931335449
(71) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00021600723266602
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017809867858887
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019097328186035
(74) DESCRIBE `itineraries` 0.00076389312744141
(75) DESCRIBE `ports` 0.00071501731872559
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00022411346435547
(77) DESCRIBE `ports` 0.00066995620727539
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00019001960754395
(79) DESCRIBE `ports` 0.00069499015808105
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00018596649169922
(81) DESCRIBE `sailingdates` 0.00060105323791504
(82) DESCRIBE `ports` 0.0008080005645752
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00026297569274902
(84) DESCRIBE `ports` 0.00069999694824219
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00018715858459473
(86) DESCRIBE `ports` 0.00071287155151367
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00019288063049316
(88) DESCRIBE `ports` 0.00068807601928711
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00017309188842773
(90) DESCRIBE `ports` 0.00066089630126953
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00020599365234375
(92) DESCRIBE `ports` 0.00072503089904785
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00021600723266602
(94) DESCRIBE `ports` 0.00066590309143066
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00019311904907227
(96) DESCRIBE `ports` 0.00080299377441406
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00019097328186035
(98) DESCRIBE `ports` 0.00074410438537598
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00019717216491699
(100) DESCRIBE `ports` 0.00074386596679688
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018596649169922
(102) DESCRIBE `ports` 0.00066304206848145
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00019001960754395
(104) DESCRIBE `ports` 0.00069594383239746
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018715858459473
(106) DESCRIBE `ports` 0.00077104568481445
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00020694732666016
(108) DESCRIBE `ports` 0.00066208839416504
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00017690658569336
(110) DESCRIBE `ports` 0.0007939338684082
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00021886825561523
(112) DESCRIBE `ports` 0.00066304206848145
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018095970153809
(114) DESCRIBE `ports` 0.00066494941711426
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 642))) 0.00021886825561523
(116) DESCRIBE `ports` 0.00066804885864258
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '642') 0.00017285346984863
(118) DESCRIBE `ports` 0.00065803527832031
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00019621849060059
(120) DESCRIBE `ports` 0.00065898895263672
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00020599365234375
(122) DESCRIBE `ports` 0.00077509880065918
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00020098686218262
(124) DESCRIBE `ports` 0.00069999694824219
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00017905235290527
(126) DESCRIBE `ports` 0.00069284439086914
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020313262939453
(128) DESCRIBE `ports` 0.00066494941711426
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018692016601562
(130) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58853') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0053999423980713
(131) DESCRIBE `avid_specials` 0.00063800811767578
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58853 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.00090718269348145
(133) DESCRIBE `cruiselines` 0.00096297264099121
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022506713867188
(135) DESCRIBE `orchid_image` 0.00076007843017578
(136) DESCRIBE `cruiselines` 0.00095486640930176
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00018787384033203
(138) DESCRIBE `cruises` 0.00130295753479
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60181') 0.00020813941955566
(140) DESCRIBE `ships` 0.0013198852539062
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00025105476379395
(142) DESCRIBE `ships` 0.0013511180877686
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00054407119750977
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028705596923828
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023293495178223
(146) DESCRIBE `itineraries` 0.0011169910430908
(147) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60181') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045895576477051
(148) DESCRIBE `ports` 0.0010840892791748
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028705596923828
(150) DESCRIBE `ports` 0.0010068416595459
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00026607513427734
(152) DESCRIBE `ports` 0.0010030269622803
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025105476379395
(154) DESCRIBE `sailingdates` 0.0008399486541748
(155) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60181') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045990943908691
(156) DESCRIBE `ports` 0.0010828971862793
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033187866210938
(158) DESCRIBE `ports` 0.00072693824768066
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021696090698242
(160) DESCRIBE `ports` 0.00099682807922363
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.0001978874206543
(162) DESCRIBE `ports` 0.0009300708770752
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00020503997802734
(164) DESCRIBE `ports` 0.0006718635559082
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00019192695617676
(166) DESCRIBE `ports` 0.00094699859619141
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00019097328186035
(168) DESCRIBE `ports` 0.00066304206848145
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00019502639770508
(170) DESCRIBE `ports` 0.0006709098815918
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018620491027832
(172) DESCRIBE `ports` 0.00066184997558594
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.0001990795135498
(174) DESCRIBE `ports` 0.00067687034606934
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.0001838207244873
(176) DESCRIBE `ports` 0.00065803527832031
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00019001960754395
(178) DESCRIBE `ports` 0.00066018104553223
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00018596649169922
(180) DESCRIBE `ports` 0.00070381164550781
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00019693374633789
(182) DESCRIBE `ports` 0.00067305564880371
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00018692016601562
(184) DESCRIBE `ports` 0.00066900253295898
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00019598007202148
(186) DESCRIBE `ports` 0.00070786476135254
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00023603439331055
(188) DESCRIBE `ports` 0.00069999694824219
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022292137145996
(190) DESCRIBE `ports` 0.00066494941711426
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018095970153809
(192) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60181') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0055339336395264
(193) DESCRIBE `avid_specials` 0.000701904296875
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60181 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00093793869018555
(195) DESCRIBE `cruiselines` 0.0010280609130859
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00021982192993164
(197) DESCRIBE `orchid_image` 0.00082302093505859
(198) DESCRIBE `cruiselines` 0.00093412399291992
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00018978118896484
(200) DESCRIBE `cruises` 0.0017838478088379
(201) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60199') 0.00027799606323242
(202) DESCRIBE `ships` 0.0014550685882568
(203) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00026392936706543
(204) DESCRIBE `ships` 0.0016419887542725
(205) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00018596649169922
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018000602722168
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020503997802734
(208) DESCRIBE `itineraries` 0.0010249614715576
(209) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60199') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.011460065841675
(210) DESCRIBE `ports` 0.0011801719665527
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002901554107666
(212) DESCRIBE `ports` 0.0006868839263916
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020313262939453
(214) DESCRIBE `ports` 0.00068187713623047
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019693374633789
(216) DESCRIBE `sailingdates` 0.00067996978759766
(217) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60199') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046396255493164
(218) DESCRIBE `ports` 0.00077986717224121
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022602081298828
(220) DESCRIBE `ports` 0.00066995620727539
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0016219615936279
(222) DESCRIBE `ports` 0.0014908313751221
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00032687187194824
(224) DESCRIBE `ports` 0.0010099411010742
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00026702880859375
(226) DESCRIBE `ports` 0.0011069774627686
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00028395652770996
(228) DESCRIBE `ports` 0.0010738372802734
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00018787384033203
(230) DESCRIBE `ports` 0.00073719024658203
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020098686218262
(232) DESCRIBE `ports` 0.00074887275695801
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00019001960754395
(234) DESCRIBE `ports` 0.00076794624328613
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00022482872009277
(236) DESCRIBE `ports` 0.00072097778320312
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.00018787384033203
(238) DESCRIBE `ports` 0.00083613395690918
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1106))) 0.00020599365234375
(240) DESCRIBE `ports` 0.0008399486541748
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1106') 0.00022602081298828
(242) DESCRIBE `ports` 0.0007781982421875
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021600723266602
(244) DESCRIBE `ports` 0.00073003768920898
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001838207244873
(246) DESCRIBE `ports` 0.00073885917663574
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020003318786621
(248) DESCRIBE `ports` 0.00075006484985352
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001828670501709
(250) DESCRIBE `ports` 0.00073981285095215
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021791458129883
(252) DESCRIBE `ports` 0.00077009201049805
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001828670501709
(254) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60199') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0058860778808594
(255) DESCRIBE `avid_specials` 0.00068402290344238
(256) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60199 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014870166778564
(257) DESCRIBE `cruiselines` 0.0010819435119629
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022006034851074
(259) DESCRIBE `orchid_image` 0.00082302093505859
(260) DESCRIBE `cruiselines` 0.0012891292572021
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0003359317779541
(262) DESCRIBE `cruises` 0.001777172088623
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58858') 0.00027990341186523
(264) DESCRIBE `ships` 0.0018210411071777
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00027918815612793
(266) DESCRIBE `ships` 0.0014748573303223
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00020098686218262
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023698806762695
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(270) DESCRIBE `itineraries` 0.00079202651977539
(271) DESCRIBE `ports` 0.001338005065918
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00028204917907715
(273) DESCRIBE `ports` 0.00091099739074707
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020408630371094
(275) DESCRIBE `ports` 0.00075006484985352
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00019598007202148
(277) DESCRIBE `sailingdates` 0.00087285041809082
(278) DESCRIBE `ports` 0.0012609958648682
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00024294853210449
(280) DESCRIBE `ports` 0.0010039806365967
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0002448558807373
(282) DESCRIBE `ports` 0.0011279582977295
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00028800964355469
(284) DESCRIBE `ports` 0.00092482566833496
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00018405914306641
(286) DESCRIBE `ports` 0.00092506408691406
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.000244140625
(288) DESCRIBE `ports` 0.00097298622131348
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00018596649169922
(290) DESCRIBE `ports` 0.0010321140289307
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00020408630371094
(292) DESCRIBE `ports` 0.00074100494384766
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.0002439022064209
(294) DESCRIBE `ports` 0.0011000633239746
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1136))) 0.00026893615722656
(296) DESCRIBE `ports` 0.0010960102081299
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1136') 0.00018620491027832
(298) DESCRIBE `ports` 0.0010139942169189
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00020980834960938
(300) DESCRIBE `ports` 0.0011370182037354
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00021195411682129
(302) DESCRIBE `ports` 0.0011239051818848
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 782))) 0.00027608871459961
(304) DESCRIBE `ports` 0.00096607208251953
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '782') 0.00018692016601562
(306) DESCRIBE `ports` 0.00095891952514648
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00027894973754883
(308) DESCRIBE `ports` 0.00075912475585938
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00025105476379395
(310) DESCRIBE `ports` 0.00086212158203125
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00020194053649902
(312) DESCRIBE `ports` 0.0010440349578857
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00022196769714355
(314) DESCRIBE `ports` 0.00095200538635254
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2363))) 0.00027704238891602
(316) DESCRIBE `ports` 0.0011000633239746
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2363') 0.00018405914306641
(318) DESCRIBE `ports` 0.00094699859619141
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2363))) 0.00021100044250488
(320) DESCRIBE `ports` 0.0010268688201904
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2363') 0.00021719932556152
(322) DESCRIBE `ports` 0.00089502334594727
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 890))) 0.00028109550476074
(324) DESCRIBE `ports` 0.00087094306945801
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '890') 0.00025200843811035
(326) DESCRIBE `ports` 0.00077009201049805
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 890))) 0.00027704238891602
(328) DESCRIBE `ports` 0.00076103210449219
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '890') 0.00018501281738281
(330) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58858') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.016511917114258
(331) DESCRIBE `avid_specials` 0.00093603134155273
(332) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58858 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 21 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.0010528564453125
(333) DESCRIBE `cruiselines` 0.0010330677032471
(334) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023388862609863
(335) DESCRIBE `orchid_image` 0.00080490112304688
(336) DESCRIBE `cruiselines` 0.00098609924316406
(337) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0002439022064209
(338) DESCRIBE `cruises` 0.0015931129455566
(339) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60235') 0.00025200843811035
(340) DESCRIBE `ships` 0.001331090927124
(341) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00029397010803223
(342) DESCRIBE `ships` 0.0013220310211182
(343) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00018906593322754
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019121170043945
(345) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018095970153809
(346) DESCRIBE `itineraries` 0.000762939453125
(347) DESCRIBE `ports` 0.00073099136352539
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022292137145996
(349) DESCRIBE `ports` 0.00077605247497559
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020289421081543
(351) DESCRIBE `ports` 0.0006709098815918
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018596649169922
(353) DESCRIBE `sailingdates` 0.00064206123352051
(354) DESCRIBE `ports` 0.00067615509033203
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020813941955566
(356) DESCRIBE `ports` 0.00069713592529297
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018501281738281
(358) DESCRIBE `ports` 0.00070691108703613
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00020098686218262
(360) DESCRIBE `ports` 0.00069713592529297
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00018000602722168
(362) DESCRIBE `ports` 0.00079083442687988
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00021100044250488
(364) DESCRIBE `ports` 0.00073504447937012
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00018405914306641
(366) DESCRIBE `ports` 0.00073790550231934
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020003318786621
(368) DESCRIBE `ports` 0.00066304206848145
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018405914306641
(370) DESCRIBE `ports` 0.00067710876464844
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0002131462097168
(372) DESCRIBE `ports` 0.00066709518432617
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018000602722168
(374) DESCRIBE `ports` 0.00066089630126953
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00023221969604492
(376) DESCRIBE `ports` 0.00069403648376465
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00018095970153809
(378) DESCRIBE `ports` 0.00070309638977051
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021100044250488
(380) DESCRIBE `ports` 0.00066494941711426
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023102760314941
(382) DESCRIBE `ports` 0.00095105171203613
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00021195411682129
(384) DESCRIBE `ports` 0.00067496299743652
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018787384033203
(386) DESCRIBE `ports` 0.00070881843566895
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00020384788513184
(388) DESCRIBE `ports` 0.00066900253295898
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00018191337585449
(390) DESCRIBE `ports` 0.00066614151000977
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00022411346435547
(392) DESCRIBE `ports` 0.00071096420288086
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00023603439331055
(394) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60235') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0060520172119141
(395) DESCRIBE `avid_specials` 0.0008690357208252
(396) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60235 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00094890594482422
(397) DESCRIBE `cruiselines` 0.0010240077972412
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022482872009277
(399) DESCRIBE `orchid_image` 0.00083684921264648
(400) DESCRIBE `cruiselines` 0.00095009803771973
(401) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00020503997802734
(402) DESCRIBE `cruises` 0.0014340877532959
(403) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58859') 0.00023794174194336
(404) DESCRIBE `ships` 0.0025460720062256
(405) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00085091590881348
(406) DESCRIBE `ships` 0.0054681301116943
(407) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.0012528896331787
(408) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019001960754395
(409) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017809867858887
(410) DESCRIBE `itineraries` 0.00068092346191406
(411) DESCRIBE `ports` 0.00078487396240234
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 890))) 0.00022006034851074
(413) DESCRIBE `ports` 0.00067901611328125
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 890))) 0.00019598007202148
(415) DESCRIBE `ports` 0.00068306922912598
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '890') 0.0001828670501709
(417) DESCRIBE `sailingdates` 0.00060415267944336
(418) DESCRIBE `ports` 0.0006721019744873
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 890))) 0.00019502639770508
(420) DESCRIBE `ports` 0.00067281723022461
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '890') 0.00017595291137695
(422) DESCRIBE `ports` 0.00069618225097656
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 890))) 0.0001981258392334
(424) DESCRIBE `ports` 0.00066113471984863
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '890') 0.00017404556274414
(426) DESCRIBE `ports` 0.00066208839416504
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00021696090698242
(428) DESCRIBE `ports` 0.00066208839416504
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018000602722168
(430) DESCRIBE `ports` 0.00077104568481445
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.0002129077911377
(432) DESCRIBE `ports` 0.00081992149353027
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00023293495178223
(434) DESCRIBE `ports` 0.00078701972961426
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 656))) 0.00022387504577637
(436) DESCRIBE `ports` 0.0010280609130859
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '656') 0.00019001960754395
(438) DESCRIBE `ports` 0.0006721019744873
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00020194053649902
(440) DESCRIBE `ports` 0.00066614151000977
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00020503997802734
(442) DESCRIBE `ports` 0.00071191787719727
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4763))) 0.0001988410949707
(444) DESCRIBE `ports` 0.00067996978759766
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4763') 0.00017499923706055
(446) DESCRIBE `ports` 0.00068116188049316
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00023889541625977
(448) DESCRIBE `ports` 0.00067400932312012
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00017619132995605
(450) DESCRIBE `ports` 0.0007481575012207
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00020313262939453
(452) DESCRIBE `ports` 0.0006709098815918
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00017809867858887
(454) DESCRIBE `ports` 0.00067496299743652
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00020813941955566
(456) DESCRIBE `ports` 0.00068402290344238
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00018095970153809
(458) DESCRIBE `ports` 0.00082898139953613
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 876))) 0.00020194053649902
(460) DESCRIBE `ports` 0.00067305564880371
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '876') 0.00018310546875
(462) DESCRIBE `ports` 0.00071001052856445
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2157))) 0.00020003318786621
(464) DESCRIBE `ports` 0.00081300735473633
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2157') 0.00018095970153809
(466) DESCRIBE `ports` 0.00072407722473145
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0002140998840332
(468) DESCRIBE `ports` 0.00067305564880371
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00021195411682129
(470) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58859') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0057389736175537
(471) DESCRIBE `avid_specials` 0.0010080337524414
(472) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58859 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.00098681449890137
(473) DESCRIBE `cruiselines` 0.0010080337524414
(474) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022697448730469
(475) DESCRIBE `orchid_image` 0.00080108642578125
(476) DESCRIBE `cruiselines` 0.001384973526001
(477) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00020599365234375
(478) DESCRIBE `cruises` 0.0013360977172852
(479) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60236') 0.00022482872009277
(480) DESCRIBE `ships` 0.0017409324645996
(481) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00031304359436035
(482) DESCRIBE `ships` 0.0016858577728271
(483) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00020289421081543
(484) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025200843811035
(485) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022697448730469
(486) DESCRIBE `itineraries` 0.00091099739074707
(487) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60236') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069403648376465
(488) DESCRIBE `ports` 0.00077986717224121
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00023102760314941
(490) DESCRIBE `ports` 0.00067496299743652
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00021505355834961
(492) DESCRIBE `ports` 0.00092315673828125
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00021004676818848
(494) DESCRIBE `sailingdates` 0.00071382522583008
(495) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60236') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040507316589355
(496) DESCRIBE `ports` 0.00088882446289062
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00022602081298828
(498) DESCRIBE `ports` 0.00069713592529297
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00020599365234375
(500) DESCRIBE `ports` 0.00067710876464844
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00026082992553711
(502) DESCRIBE `ports` 0.00074195861816406
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00019598007202148
(504) DESCRIBE `ports` 0.00068902969360352
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00020194053649902
(506) DESCRIBE `ports` 0.00068902969360352
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.00020813941955566
(508) DESCRIBE `ports` 0.00070285797119141
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.0001990795135498
(510) DESCRIBE `ports` 0.00067496299743652
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00021696090698242
(512) DESCRIBE `ports` 0.00071501731872559
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020003318786621
(514) DESCRIBE `ports` 0.00091314315795898
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00024914741516113
(516) DESCRIBE `ports` 0.00096321105957031
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00023603439331055
(518) DESCRIBE `ports` 0.0007939338684082
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.00019478797912598
(520) DESCRIBE `ports` 0.00070786476135254
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4794))) 0.00027108192443848
(522) DESCRIBE `ports` 0.00076603889465332
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4794') 0.00018310546875
(524) DESCRIBE `ports` 0.00079202651977539
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00021719932556152
(526) DESCRIBE `ports` 0.00072097778320312
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0001828670501709
(528) DESCRIBE `ports` 0.00089478492736816
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00026082992553711
(530) DESCRIBE `ports` 0.00098109245300293
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022411346435547
(532) DESCRIBE `ports` 0.00089597702026367
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00025701522827148
(534) DESCRIBE `ports` 0.0009918212890625
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00024294853210449
(536) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60236') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0082540512084961
(537) DESCRIBE `avid_specials` 0.0012290477752686
(538) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60236 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012691020965576
(539) DESCRIBE `cruiselines` 0.0012290477752686
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023698806762695
(541) DESCRIBE `orchid_image` 0.00077414512634277
(542) DESCRIBE `cruiselines` 0.0010361671447754
(543) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0001981258392334
(544) DESCRIBE `cruises` 0.0018000602722168
(545) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75541') 0.00044894218444824
(546) DESCRIBE `ships` 0.0020029544830322
(547) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00043511390686035
(548) DESCRIBE `ships` 0.0021588802337646
(549) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00028300285339355
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019621849060059
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019001960754395
(552) DESCRIBE `itineraries` 0.0010981559753418
(553) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75541') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007331371307373
(554) DESCRIBE `ports` 0.0011680126190186
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00027298927307129
(556) DESCRIBE `ports` 0.00070905685424805
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020694732666016
(558) DESCRIBE `ports` 0.00084996223449707
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00028491020202637
(560) DESCRIBE `sailingdates` 0.00071883201599121
(561) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75541') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006711483001709
(562) DESCRIBE `ports` 0.0010321140289307
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00027799606323242
(564) DESCRIBE `ports` 0.00089788436889648
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00019097328186035
(566) DESCRIBE `ports` 0.00071907043457031
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00020503997802734
(568) DESCRIBE `ports` 0.00068211555480957
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018191337585449
(570) DESCRIBE `ports` 0.00067615509033203
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00021719932556152
(572) DESCRIBE `ports` 0.00067710876464844
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018501281738281
(574) DESCRIBE `ports` 0.00067591667175293
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00020694732666016
(576) DESCRIBE `ports` 0.00070905685424805
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00018405914306641
(578) DESCRIBE `ports` 0.0006711483001709
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 876))) 0.00020885467529297
(580) DESCRIBE `ports` 0.00072813034057617
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '876') 0.00020194053649902
(582) DESCRIBE `ports` 0.00069594383239746
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3277))) 0.00021004676818848
(584) DESCRIBE `ports` 0.0006718635559082
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3277') 0.0001828670501709
(586) DESCRIBE `ports` 0.0007169246673584
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00023698806762695
(588) DESCRIBE `ports` 0.00071310997009277
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00018501281738281
(590) DESCRIBE `ports` 0.0006718635559082
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00020813941955566
(592) DESCRIBE `ports` 0.00072884559631348
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018501281738281
(594) DESCRIBE `ports` 0.00067281723022461
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00020813941955566
(596) DESCRIBE `ports` 0.0006861686706543
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018501281738281
(598) DESCRIBE `ports` 0.00070595741271973
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00020790100097656
(600) DESCRIBE `ports` 0.00067591667175293
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00018715858459473
(602) DESCRIBE `ports` 0.00070595741271973
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00024986267089844
(604) DESCRIBE `ports` 0.00077605247497559
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00018405914306641
(606) DESCRIBE `ports` 0.00095915794372559
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00029897689819336
(608) DESCRIBE `ports` 0.00096511840820312
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00023913383483887
(610) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75541') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0087499618530273
(611) DESCRIBE `avid_specials` 0.0010511875152588
(612) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75541 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0010459423065186
(613) DESCRIBE `cruiselines` 0.0010769367218018
(614) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023603439331055
(615) DESCRIBE `orchid_image` 0.00080108642578125
(616) DESCRIBE `cruiselines` 0.0010008811950684
(617) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00019502639770508
(618) DESCRIBE `cruises` 0.0017659664154053
(619) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60237') 0.0016660690307617
(620) DESCRIBE `ships` 0.0015499591827393
(621) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.0003359317779541
(622) DESCRIBE `ships` 0.0013880729675293
(623) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00019407272338867
(624) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018095970153809
(625) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016999244689941
(626) DESCRIBE `itineraries` 0.0006859302520752
(627) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60237') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00037908554077148
(628) DESCRIBE `ports` 0.00096702575683594
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029611587524414
(630) DESCRIBE `ports` 0.00097393989562988
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020408630371094
(632) DESCRIBE `ports` 0.0007319450378418
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019598007202148
(634) DESCRIBE `sailingdates` 0.00071096420288086
(635) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60237') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038385391235352
(636) DESCRIBE `ports` 0.00080704689025879
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002288818359375
(638) DESCRIBE `ports` 0.00076603889465332
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023603439331055
(640) DESCRIBE `ports` 0.00088906288146973
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00022482872009277
(642) DESCRIBE `ports` 0.00068306922912598
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00018215179443359
(644) DESCRIBE `ports` 0.00066995620727539
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00025105476379395
(646) DESCRIBE `ports` 0.00068521499633789
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00018501281738281
(648) DESCRIBE `ports` 0.00076007843017578
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00021600723266602
(650) DESCRIBE `ports` 0.00076508522033691
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00018692016601562
(652) DESCRIBE `ports` 0.00073385238647461
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020003318786621
(654) DESCRIBE `ports` 0.00066995620727539
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0001828670501709
(656) DESCRIBE `ports` 0.00083398818969727
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 584))) 0.00021100044250488
(658) DESCRIBE `ports` 0.00069499015808105
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '584') 0.00017905235290527
(660) DESCRIBE `ports` 0.00079607963562012
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00019693374633789
(662) DESCRIBE `ports` 0.00066590309143066
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0002131462097168
(664) DESCRIBE `ports` 0.00068187713623047
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0001978874206543
(666) DESCRIBE `ports` 0.00067400932312012
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017714500427246
(668) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60237') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.005486011505127
(669) DESCRIBE `avid_specials` 0.00064301490783691
(670) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60237 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00090599060058594
(671) DESCRIBE `cruiselines` 0.00099015235900879
(672) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00021982192993164
(673) DESCRIBE `orchid_image` 0.00090193748474121
(674) DESCRIBE `cruiselines` 0.0009760856628418
(675) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00020003318786621
(676) DESCRIBE `ships` 0.0015280246734619
(677) SELECT `ships`.* FROM `ships` WHERE (id IN ('652', '616', '1672')) ORDER BY FIND_IN_SET(id, '652,616,1672') 0.00044417381286621
(678) DESCRIBE `cruisetypes` 0.00060009956359863
(679) DESCRIBE `destinations` 0.00090503692626953
(680) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '26', '28', '25', '21', '45', '49')) ORDER BY FIND_IN_SET(id, '22,26,28,25,21,45,49') 0.00051403045654297
(681) DESCRIBE `cruiselines` 0.00099515914916992
(682) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022387504577637
(683) DESCRIBE `cruiselines` 0.00098013877868652
(684) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0002138614654541