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

Total elapsed time: 0.35753178596497

# Query Time
(1) connect 0.00051712989807129
(2) DESCRIBE `cruises` 0.0022299289703369
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65761, 65874, 66028, 66474, 66503, 66516, 66567, 66904, 67412, 67662)) ORDER BY FIND_IN_SET(id, '65761,65874,66028,66474,66503,66516,66567,66904,67412,67662') 0.000885009765625
(4) DESCRIBE `cruises` 0.00211501121521
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65761') 0.00025796890258789
(6) DESCRIBE `ships` 0.0012941360473633
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1542))) 0.00026798248291016
(8) DESCRIBE `ships` 0.0012569427490234
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1542') 0.00019097328186035
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020384788513184
(12) DESCRIBE `itineraries` 0.00066709518432617
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65761') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010550022125244
(14) DESCRIBE `ports` 0.00074100494384766
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00022697448730469
(16) DESCRIBE `ports` 0.00069189071655273
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020194053649902
(18) DESCRIBE `ports` 0.00067615509033203
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018596649169922
(20) DESCRIBE `sailingdates` 0.00060796737670898
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65761') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052905082702637
(22) DESCRIBE `ports` 0.0007021427154541
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020384788513184
(24) DESCRIBE `ports` 0.00067281723022461
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018405914306641
(26) DESCRIBE `ports` 0.00066804885864258
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00020003318786621
(28) DESCRIBE `ports` 0.00066804885864258
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00018405914306641
(30) DESCRIBE `ports` 0.00066494941711426
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00020289421081543
(32) DESCRIBE `ports` 0.00066900253295898
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00018310546875
(34) DESCRIBE `ports` 0.00068092346191406
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.0001988410949707
(36) DESCRIBE `ports` 0.00066494941711426
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00018215179443359
(38) DESCRIBE `ports` 0.00066900253295898
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00020694732666016
(40) DESCRIBE `ports` 0.00069594383239746
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.0001828670501709
(42) DESCRIBE `ports` 0.00066900253295898
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00022101402282715
(44) DESCRIBE `ports` 0.00066900253295898
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00023317337036133
(46) DESCRIBE `ports` 0.0009000301361084
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00020289421081543
(48) DESCRIBE `ports` 0.00090479850769043
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.0002281665802002
(50) DESCRIBE `ports` 0.00071001052856445
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020694732666016
(52) DESCRIBE `ports` 0.00066900253295898
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018692016601562
(54) DESCRIBE `ports` 0.00066494941711426
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0001988410949707
(56) DESCRIBE `ports` 0.00068998336791992
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018310546875
(58) DESCRIBE `avid_specials` 0.00060796737670898
(59) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65761 and class = 'Cruise') OR (item_id = 1542 AND class = 'Ship') OR (item_id = 204 AND class = 'CruiseLine') OR (item_id = 50 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.00095915794372559
(60) DESCRIBE `cruiselines` 0.0010149478912354
(61) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.00021791458129883
(62) DESCRIBE `orchid_image` 0.00075006484985352
(63) DESCRIBE `cruiselines` 0.00093722343444824
(64) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.00018501281738281
(65) DESCRIBE `cruises` 0.001338005065918
(66) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65874') 0.00019598007202148
(67) DESCRIBE `ships` 0.0012431144714355
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1534))) 0.00024199485778809
(69) DESCRIBE `ships` 0.0012991428375244
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1534') 0.0001828670501709
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018095970153809
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017094612121582
(73) DESCRIBE `itineraries` 0.00066089630126953
(74) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65874') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063109397888184
(75) DESCRIBE `ports` 0.00069594383239746
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.0002140998840332
(77) DESCRIBE `ports` 0.00066900253295898
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.0001981258392334
(79) DESCRIBE `ports` 0.00066590309143066
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00020289421081543
(81) DESCRIBE `sailingdates` 0.00060486793518066
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65874') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00039196014404297
(83) DESCRIBE `ports` 0.00069189071655273
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020313262939453
(85) DESCRIBE `ports` 0.00066685676574707
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.0001828670501709
(87) DESCRIBE `ports` 0.00067901611328125
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020503997802734
(89) DESCRIBE `ports` 0.00066399574279785
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00018191337585449
(91) DESCRIBE `ports` 0.00066685676574707
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2851))) 0.00020289421081543
(93) DESCRIBE `ports` 0.00069403648376465
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2851') 0.00018095970153809
(95) DESCRIBE `ports` 0.00066685676574707
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2851))) 0.0001978874206543
(97) DESCRIBE `ports` 0.00066208839416504
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2851') 0.00018095970153809
(99) DESCRIBE `ports` 0.00077009201049805
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00020217895507812
(101) DESCRIBE `ports` 0.00066304206848145
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00018095970153809
(103) DESCRIBE `ports` 0.00066494941711426
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00020408630371094
(105) DESCRIBE `ports` 0.00066995620727539
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00018095970153809
(107) DESCRIBE `ports` 0.00066089630126953
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00020098686218262
(109) DESCRIBE `ports` 0.00065898895263672
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00019502639770508
(111) DESCRIBE `ports` 0.00067591667175293
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 958))) 0.00022006034851074
(113) DESCRIBE `ports` 0.00066804885864258
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '958') 0.00019192695617676
(115) DESCRIBE `ports` 0.00066208839416504
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 958))) 0.0002288818359375
(117) DESCRIBE `ports` 0.00065898895263672
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '958') 0.00019001960754395
(119) DESCRIBE `ports` 0.00066089630126953
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1536))) 0.00020599365234375
(121) DESCRIBE `ports` 0.00066590309143066
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1536') 0.00018000602722168
(123) DESCRIBE `ports` 0.00066089630126953
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1534))) 0.00020003318786621
(125) DESCRIBE `ports` 0.00066685676574707
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1534') 0.00018119812011719
(127) DESCRIBE `ports` 0.00066304206848145
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1533))) 0.00020599365234375
(129) DESCRIBE `ports` 0.00066518783569336
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1533') 0.00018095970153809
(131) DESCRIBE `avid_specials` 0.00064897537231445
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65874 and class = 'Cruise') OR (item_id = 1534 AND class = 'Ship') OR (item_id = 204 AND class = 'CruiseLine') OR (item_id = 50 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.00097107887268066
(133) DESCRIBE `cruiselines` 0.00097417831420898
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.00021195411682129
(135) DESCRIBE `orchid_image` 0.00098180770874023
(136) DESCRIBE `cruiselines` 0.00092101097106934
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.00018310546875
(138) DESCRIBE `cruises` 0.0012669563293457
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66028') 0.0001990795135498
(140) DESCRIBE `ships` 0.0015430450439453
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 390))) 0.00027894973754883
(142) DESCRIBE `ships` 0.0020098686218262
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '390') 0.0002739429473877
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032687187194824
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029206275939941
(146) DESCRIBE `itineraries` 0.0013320446014404
(147) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66028') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00075697898864746
(148) DESCRIBE `ports` 0.00068497657775879
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020813941955566
(150) DESCRIBE `ports` 0.00071001052856445
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020694732666016
(152) DESCRIBE `ports` 0.00069499015808105
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018095970153809
(154) DESCRIBE `sailingdates` 0.0005948543548584
(155) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66028') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00084590911865234
(156) DESCRIBE `ports` 0.00070905685424805
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020599365234375
(158) DESCRIBE `ports` 0.00069785118103027
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019621849060059
(160) DESCRIBE `ports` 0.00066804885864258
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00021195411682129
(162) DESCRIBE `ports` 0.00066685676574707
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00018095970153809
(164) DESCRIBE `ports` 0.00066494941711426
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020599365234375
(166) DESCRIBE `ports` 0.00066590309143066
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018095970153809
(168) DESCRIBE `ports` 0.00072598457336426
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00021505355834961
(170) DESCRIBE `ports` 0.00072383880615234
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00018000602722168
(172) DESCRIBE `ports` 0.00065398216247559
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00020885467529297
(174) DESCRIBE `ports` 0.00088286399841309
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00020098686218262
(176) DESCRIBE `ports` 0.00068211555480957
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020098686218262
(178) DESCRIBE `ports` 0.00065898895263672
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017905235290527
(180) DESCRIBE `avid_specials` 0.00059914588928223
(181) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66028 and class = 'Cruise') OR (item_id = 390 AND class = 'Ship') OR (item_id = 218 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.00094914436340332
(182) DESCRIBE `cruiselines` 0.0010249614715576
(183) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00021791458129883
(184) DESCRIBE `orchid_image` 0.00080609321594238
(185) DESCRIBE `cruiselines` 0.00090599060058594
(186) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00018000602722168
(187) DESCRIBE `cruises` 0.0012929439544678
(188) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66474') 0.00019383430480957
(189) DESCRIBE `ships` 0.0012519359588623
(190) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00025105476379395
(191) DESCRIBE `ships` 0.0014171600341797
(192) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00020909309387207
(193) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001988410949707
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023007392883301
(195) DESCRIBE `itineraries` 0.00088000297546387
(196) DESCRIBE `ports` 0.00091099739074707
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.000244140625
(198) DESCRIBE `ports` 0.00085806846618652
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020599365234375
(200) DESCRIBE `ports` 0.00070691108703613
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00017809867858887
(202) DESCRIBE `sailingdates` 0.00060391426086426
(203) DESCRIBE `ports` 0.00068092346191406
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020098686218262
(205) DESCRIBE `ports` 0.00068020820617676
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00017595291137695
(207) DESCRIBE `ports` 0.00065898895263672
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00020217895507812
(209) DESCRIBE `ports` 0.00066494941711426
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00017499923706055
(211) DESCRIBE `ports` 0.0006721019744873
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00020313262939453
(213) DESCRIBE `ports` 0.00065708160400391
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00020503997802734
(215) DESCRIBE `ports` 0.0006709098815918
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0002601146697998
(217) DESCRIBE `ports` 0.0006721019744873
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00017905235290527
(219) DESCRIBE `ports` 0.00065994262695312
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 646))) 0.00019598007202148
(221) DESCRIBE `ports` 0.0007011890411377
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '646') 0.00020718574523926
(223) DESCRIBE `ports` 0.00066709518432617
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00019502639770508
(225) DESCRIBE `ports` 0.00066804885864258
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00017309188842773
(227) DESCRIBE `ports` 0.00065994262695312
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020003318786621
(229) DESCRIBE `ports` 0.00066399574279785
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00017189979553223
(231) DESCRIBE `avid_specials` 0.00066804885864258
(232) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66474 and class = 'Cruise') OR (item_id = 406 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.0016899108886719
(233) DESCRIBE `cruiselines` 0.0014410018920898
(234) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00029993057250977
(235) DESCRIBE `orchid_image` 0.00079011917114258
(236) DESCRIBE `cruiselines` 0.0010011196136475
(237) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020503997802734
(238) DESCRIBE `cruises` 0.0012948513031006
(239) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66503') 0.00031495094299316
(240) DESCRIBE `ships` 0.0020699501037598
(241) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.00032806396484375
(242) DESCRIBE `ships` 0.0020060539245605
(243) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.0002439022064209
(244) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027990341186523
(245) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002288818359375
(246) DESCRIBE `itineraries` 0.0010969638824463
(247) DESCRIBE `ports` 0.0010249614715576
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00029110908508301
(249) DESCRIBE `ports` 0.0010108947753906
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00028586387634277
(251) DESCRIBE `ports` 0.00099706649780273
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00023698806762695
(253) DESCRIBE `sailingdates` 0.00060915946960449
(254) DESCRIBE `ports` 0.00069999694824219
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020503997802734
(256) DESCRIBE `ports` 0.0006868839263916
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.0001828670501709
(258) DESCRIBE `ports` 0.0006711483001709
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00020813941955566
(260) DESCRIBE `ports` 0.00067806243896484
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00018191337585449
(262) DESCRIBE `ports` 0.00069594383239746
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020408630371094
(264) DESCRIBE `ports` 0.00066900253295898
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0001828670501709
(266) DESCRIBE `ports` 0.00072598457336426
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020289421081543
(268) DESCRIBE `ports` 0.00070691108703613
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018000602722168
(270) DESCRIBE `ports` 0.00067996978759766
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0001978874206543
(272) DESCRIBE `ports` 0.00071096420288086
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00025200843811035
(274) DESCRIBE `ports` 0.00095319747924805
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0002129077911377
(276) DESCRIBE `ports` 0.00070095062255859
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00020384788513184
(278) DESCRIBE `ports` 0.00069308280944824
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020408630371094
(280) DESCRIBE `ports` 0.0006711483001709
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00020217895507812
(282) DESCRIBE `avid_specials` 0.00061297416687012
(283) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66503 and class = 'Cruise') OR (item_id = 253 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.0010249614715576
(284) DESCRIBE `cruiselines` 0.00099420547485352
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00020885467529297
(286) DESCRIBE `orchid_image` 0.00076079368591309
(287) DESCRIBE `cruiselines` 0.00095605850219727
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018787384033203
(289) DESCRIBE `cruises` 0.0012669563293457
(290) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66516') 0.00019001960754395
(291) DESCRIBE `ships` 0.0012540817260742
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.0002291202545166
(293) DESCRIBE `ships` 0.0012340545654297
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00017499923706055
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016212463378906
(297) DESCRIBE `itineraries` 0.00065398216247559
(298) DESCRIBE `ports` 0.00067782402038574
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022006034851074
(300) DESCRIBE `ports` 0.00066685676574707
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019001960754395
(302) DESCRIBE `ports` 0.00068306922912598
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017404556274414
(304) DESCRIBE `sailingdates` 0.00060892105102539
(305) DESCRIBE `ports` 0.00067782402038574
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020408630371094
(307) DESCRIBE `ports` 0.00068092346191406
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019097328186035
(309) DESCRIBE `ports` 0.0006721019744873
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020194053649902
(311) DESCRIBE `ports` 0.00066900253295898
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00019383430480957
(313) DESCRIBE `ports` 0.00066900253295898
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021100044250488
(315) DESCRIBE `ports` 0.00070595741271973
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017404556274414
(317) DESCRIBE `ports` 0.00068902969360352
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00019311904907227
(319) DESCRIBE `ports` 0.00066494941711426
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00017309188842773
(321) DESCRIBE `ports` 0.00066113471984863
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00023007392883301
(323) DESCRIBE `ports` 0.00067806243896484
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00017499923706055
(325) DESCRIBE `ports` 0.00068092346191406
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021004676818848
(327) DESCRIBE `ports` 0.00066280364990234
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017404556274414
(329) DESCRIBE `avid_specials` 0.00059914588928223
(330) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66516 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.00096607208251953
(331) DESCRIBE `cruiselines` 0.00096392631530762
(332) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00020909309387207
(333) DESCRIBE `orchid_image` 0.0007481575012207
(334) DESCRIBE `cruiselines` 0.00091791152954102
(335) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00017404556274414
(336) DESCRIBE `cruises` 0.0012979507446289
(337) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66567') 0.00018215179443359
(338) DESCRIBE `ships` 0.001338005065918
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1505))) 0.00023698806762695
(340) DESCRIBE `ships` 0.0012779235839844
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1505') 0.00023198127746582
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022602081298828
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023818016052246
(344) DESCRIBE `itineraries` 0.00088310241699219
(345) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66567') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014259815216064
(346) DESCRIBE `ports` 0.00087499618530273
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00021791458129883
(348) DESCRIBE `ports` 0.00067496299743652
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00023698806762695
(350) DESCRIBE `ports` 0.0006868839263916
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00017905235290527
(352) DESCRIBE `sailingdates` 0.0006718635559082
(353) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66567') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068497657775879
(354) DESCRIBE `ports` 0.00075316429138184
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00021815299987793
(356) DESCRIBE `ports` 0.00067996978759766
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00018501281738281
(358) DESCRIBE `ports` 0.00068998336791992
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5376))) 0.00020408630371094
(360) DESCRIBE `ports` 0.0007789134979248
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5376') 0.00018906593322754
(362) DESCRIBE `ports` 0.00067305564880371
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00020408630371094
(364) DESCRIBE `ports` 0.00070405006408691
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00018191337585449
(366) DESCRIBE `ports` 0.00073981285095215
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.0001990795135498
(368) DESCRIBE `ports` 0.0006718635559082
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00018596649169922
(370) DESCRIBE `ports` 0.00067687034606934
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4212))) 0.00022101402282715
(372) DESCRIBE `ports` 0.00077414512634277
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4212') 0.00018501281738281
(374) DESCRIBE `ports` 0.00068187713623047
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4452))) 0.00020194053649902
(376) DESCRIBE `ports` 0.00070905685424805
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4452') 0.0001828670501709
(378) DESCRIBE `ports` 0.00066781044006348
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4182))) 0.00056886672973633
(380) DESCRIBE `ports` 0.0014650821685791
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4182') 0.00026607513427734
(382) DESCRIBE `ports` 0.0010018348693848
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2599))) 0.00029516220092773
(384) DESCRIBE `ports` 0.0014281272888184
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2599') 0.00025200843811035
(386) DESCRIBE `ports` 0.0010018348693848
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2665))) 0.00026392936706543
(388) DESCRIBE `ports` 0.00097107887268066
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2665') 0.00023698806762695
(390) DESCRIBE `ports` 0.00093579292297363
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00027203559875488
(392) DESCRIBE `ports` 0.0009620189666748
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00027608871459961
(394) DESCRIBE `ports` 0.00096893310546875
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00026583671569824
(396) DESCRIBE `ports` 0.0009620189666748
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00023889541625977
(398) DESCRIBE `ports` 0.00095605850219727
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2600))) 0.00025701522827148
(400) DESCRIBE `ports` 0.00096988677978516
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2600') 0.00023603439331055
(402) DESCRIBE `ports` 0.00098991394042969
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5372))) 0.00028181076049805
(404) DESCRIBE `ports` 0.00099611282348633
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5372') 0.00024604797363281
(406) DESCRIBE `ports` 0.00095391273498535
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2523))) 0.00026512145996094
(408) DESCRIBE `ports` 0.00098609924316406
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2523') 0.00023412704467773
(410) DESCRIBE `ports` 0.00097203254699707
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00028109550476074
(412) DESCRIBE `ports` 0.0010488033294678
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00023198127746582
(414) DESCRIBE `avid_specials` 0.00093603134155273
(415) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66567 and class = 'Cruise') OR (item_id = 1505 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 37 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.0011370182037354
(416) DESCRIBE `cruiselines` 0.0018219947814941
(417) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00034213066101074
(418) DESCRIBE `orchid_image` 0.00076699256896973
(419) DESCRIBE `cruiselines` 0.001338005065918
(420) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00019192695617676
(421) DESCRIBE `cruises` 0.0015218257904053
(422) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66904') 0.00023984909057617
(423) DESCRIBE `ships` 0.0012450218200684
(424) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00025701522827148
(425) DESCRIBE `ships` 0.0012550354003906
(426) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00018095970153809
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018191337585449
(428) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022196769714355
(429) DESCRIBE `itineraries` 0.00068902969360352
(430) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66904') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051593780517578
(431) DESCRIBE `ports` 0.00072216987609863
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00030803680419922
(433) DESCRIBE `ports` 0.00084209442138672
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00021004676818848
(435) DESCRIBE `ports` 0.00067710876464844
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00020098686218262
(437) DESCRIBE `sailingdates` 0.0006248950958252
(438) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66904') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069189071655273
(439) DESCRIBE `ports` 0.00081491470336914
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00022792816162109
(441) DESCRIBE `ports` 0.00075888633728027
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00019097328186035
(443) DESCRIBE `ports` 0.00095009803771973
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00023293495178223
(445) DESCRIBE `ports` 0.0007479190826416
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00019097328186035
(447) DESCRIBE `ports` 0.00069713592529297
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00030398368835449
(449) DESCRIBE `ports` 0.00076794624328613
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00018882751464844
(451) DESCRIBE `ports` 0.00066995620727539
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00021004676818848
(453) DESCRIBE `ports` 0.00068497657775879
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00018310546875
(455) DESCRIBE `ports` 0.00068497657775879
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020003318786621
(457) DESCRIBE `ports` 0.0006718635559082
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018215179443359
(459) DESCRIBE `ports` 0.00070595741271973
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00020790100097656
(461) DESCRIBE `ports` 0.00068998336791992
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00018191337585449
(463) DESCRIBE `ports` 0.00066781044006348
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0001990795135498
(465) DESCRIBE `ports` 0.00066709518432617
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018191337585449
(467) DESCRIBE `avid_specials` 0.00061202049255371
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66904 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 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.0009760856628418
(469) DESCRIBE `cruiselines` 0.0010309219360352
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022101402282715
(471) DESCRIBE `orchid_image` 0.00074911117553711
(472) DESCRIBE `cruiselines` 0.0010330677032471
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020289421081543
(474) DESCRIBE `cruises` 0.0012569427490234
(475) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67412') 0.00022792816162109
(476) DESCRIBE `ships` 0.0012729167938232
(477) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 958))) 0.00024199485778809
(478) DESCRIBE `ships` 0.0012788772583008
(479) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '958') 0.00018000602722168
(480) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018310546875
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016999244689941
(482) DESCRIBE `itineraries` 0.00066208839416504
(483) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67412') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00080084800720215
(484) DESCRIBE `ports` 0.00069499015808105
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00021696090698242
(486) DESCRIBE `ports` 0.00067496299743652
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020599365234375
(488) DESCRIBE `ports` 0.00066900253295898
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018405914306641
(490) DESCRIBE `sailingdates` 0.00060296058654785
(491) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67412') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047898292541504
(492) DESCRIBE `ports` 0.00069117546081543
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020408630371094
(494) DESCRIBE `ports` 0.0006711483001709
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018310546875
(496) DESCRIBE `ports` 0.00067996978759766
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00020909309387207
(498) DESCRIBE `ports` 0.0006721019744873
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00018191337585449
(500) DESCRIBE `ports` 0.00066280364990234
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00022792816162109
(502) DESCRIBE `ports` 0.00076699256896973
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00038290023803711
(504) DESCRIBE `ports` 0.00088095664978027
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00023293495178223
(506) DESCRIBE `ports` 0.00073909759521484
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00018787384033203
(508) DESCRIBE `ports` 0.00067591667175293
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00020384788513184
(510) DESCRIBE `ports` 0.00080204010009766
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00019311904907227
(512) DESCRIBE `ports` 0.00073003768920898
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00023508071899414
(514) DESCRIBE `ports` 0.00071287155151367
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00019097328186035
(516) DESCRIBE `ports` 0.00067400932312012
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00024795532226562
(518) DESCRIBE `ports` 0.00069618225097656
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00019288063049316
(520) DESCRIBE `ports` 0.00066900253295898
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00020384788513184
(522) DESCRIBE `ports` 0.0006709098815918
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00018596649169922
(524) DESCRIBE `ports` 0.0007169246673584
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00020503997802734
(526) DESCRIBE `ports` 0.00067591667175293
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00018811225891113
(528) DESCRIBE `ports` 0.00069499015808105
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.0001990795135498
(530) DESCRIBE `ports` 0.0006721019744873
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00018310546875
(532) DESCRIBE `avid_specials` 0.00061297416687012
(533) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67412 and class = 'Cruise') OR (item_id = 958 AND class = 'Ship') OR (item_id = 131 AND class = 'CruiseLine') OR (item_id = 50 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.0010747909545898
(534) DESCRIBE `cruiselines` 0.0029478073120117
(535) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00032687187194824
(536) DESCRIBE `orchid_image` 0.00090789794921875
(537) DESCRIBE `cruiselines` 0.00095295906066895
(538) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00019216537475586
(539) DESCRIBE `cruises` 0.0013461112976074
(540) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67662') 0.00021600723266602
(541) DESCRIBE `ships` 0.0012648105621338
(542) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1223))) 0.00025796890258789
(543) DESCRIBE `ships` 0.0012319087982178
(544) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1223') 0.00020003318786621
(545) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(546) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018000602722168
(547) DESCRIBE `itineraries` 0.00068998336791992
(548) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67662') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052380561828613
(549) DESCRIBE `ports` 0.00069308280944824
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00023293495178223
(551) DESCRIBE `ports` 0.00067281723022461
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0001990795135498
(553) DESCRIBE `ports` 0.000701904296875
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018477439880371
(555) DESCRIBE `sailingdates` 0.00060200691223145
(556) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67662') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050687789916992
(557) DESCRIBE `ports` 0.00073409080505371
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00021696090698242
(559) DESCRIBE `ports` 0.00068283081054688
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00019192695617676
(561) DESCRIBE `ports` 0.00066709518432617
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00020194053649902
(563) DESCRIBE `ports` 0.0006709098815918
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00018405914306641
(565) DESCRIBE `ports` 0.00066494941711426
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00020694732666016
(567) DESCRIBE `ports` 0.00066208839416504
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00020003318786621
(569) DESCRIBE `ports` 0.00066280364990234
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00020194053649902
(571) DESCRIBE `ports` 0.00066304206848145
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00018119812011719
(573) DESCRIBE `ports` 0.00066304206848145
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.0001981258392334
(575) DESCRIBE `ports` 0.00069785118103027
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00018215179443359
(577) DESCRIBE `ports` 0.00066399574279785
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00020098686218262
(579) DESCRIBE `ports` 0.00086402893066406
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00018811225891113
(581) DESCRIBE `ports` 0.00067305564880371
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2966))) 0.00020217895507812
(583) DESCRIBE `ports` 0.00066399574279785
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2966') 0.00018191337585449
(585) DESCRIBE `ports` 0.00072193145751953
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00027704238891602
(587) DESCRIBE `ports` 0.00097298622131348
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00023293495178223
(589) DESCRIBE `ports` 0.00067496299743652
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00021100044250488
(591) DESCRIBE `ports` 0.00069308280944824
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018405914306641
(593) DESCRIBE `avid_specials` 0.0006108283996582
(594) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67662 and class = 'Cruise') OR (item_id = 1223 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 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.0009610652923584
(595) DESCRIBE `cruiselines` 0.00098800659179688
(596) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00021600723266602
(597) DESCRIBE `orchid_image` 0.00073909759521484
(598) DESCRIBE `cruiselines` 0.00095987319946289
(599) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00018811225891113
(600) DESCRIBE `cruiselines` 0.0011570453643799
(601) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '171', '31', '18', '101', '183', '20', '7', '8', '144', '96', '12', '120', '221', '103', '50', '268', '15', '29', '37', '91', '110', '232', '208', '28', '206', '33', '131', '156', '49', '220', '118', '24', '114', '262', '204', '181', '187', '258', '256', '47', '36', '212', '30', '16', '151', '191', '14', '249', '153', '211', '195', '238', '141', '174', '216', '35', '239', '4', '213', '113', '159', '168', '196', '188', '146', '136', '90', '237', '209', '73', '180', '229', '170', '59', '115', '225', '140', '95', '219', '57', '269', '108', '231', '52', '184', '132', '276', '248', '38', '88', '275', '182', '261', '264', '244', '82', '230', '105', '266', '116', '39', '64', '48', '119', '240', '224', '245', '210', '134', '251')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,171,31,18,101,183,20,7,8,144,96,12,120,221,103,50,268,15,29,37,91,110,232,208,28,206,33,131,156,49,220,118,24,114,262,204,181,187,258,256,47,36,212,30,16,151,191,14,249,153,211,195,238,141,174,216,35,239,4,213,113,159,168,196,188,146,136,90,237,209,73,180,229,170,59,115,225,140,95,219,57,269,108,231,52,184,132,276,248,38,88,275,182,261,264,244,82,230,105,266,116,39,64,48,119,240,224,245,210,134,251') 0.0029258728027344
(602) DESCRIBE `ships` 0.0017478466033936
(603) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '977', '1199', '1291', '1588', '407', '517', '726', '258', '1237', '27', '1424', '22', '461', '28', '1599', '21', '1422', '817', '1423', '1594', '393', '1419', '1420', '1421', '1418', '1135', '349', '1359', '452', '780', '113', '766', '265', '24', '11', '1574', '439', '542', '9', '10', '207', '1245', '585', '770', '330', '404', '1272', '455', '974', '124', '1067', '1455', '792', '1460', '553', '871', '1215', '797', '5', '739', '674', '573', '25', '1572', '3', '520', '855', '1193', '1607', '14', '78', '434', '711', '340', '1021', '253', '1302', '1402', '1586', '390', '559', '748', '1284', '43', '580', '1172', '1581', '462', '765', '791', '1320', '1323', '285', '874', '658', '405', '590', '678', '1139', '582', '286', '327', '526', '883', '970', '731', '859', '454', '854', '81', '406', '823', '722', '1236', '1614', '850', '1027', '1415', '1569', '31', '114', '993', '1348', '37', '1319', '30', '34', '35', '36', '38', '39', '82', '378', '403', '547', '1008', '1012', '1326', '1327', '1330', '1678', '160', '163', '333', '351', '451', '784', '1205', '1325', '348', '657', '966', '1454', '1575', '338', '84', '262', '325', '701', '1143', '521', '683', '352', '508', '732', '287', '1088', '1134', '1151', '1157', '1318', '4', '111', '610', '1075', '1108', '1367', '1471', '1579', '290', '1032', '1345', '314', '751', '1214', '1223', '1233', '1308', '119', '335', '1013', '1145', '1321', '93', '162', '1405', '651', '673', '1137', '1144', '1344', '1376', '1615', '291', '394', '483', '852', '988', '1149', '1343', '1587', '45', '116', '1452', '1453', '1604', '152', '401', '545', '1095', '98', '441', '1025', '1090', '1136', '1283', '1373', '1724', '626', '716', '882', '968', '1163', '1168', '1243', '1301', '1413', '59', '75', '150', '768', '769', '986', '1292', '1398', '1526', '148', '149', '151', '669', '905', '1382', '1417', '1448', '1492', '639', '1150', '1176', '1226', '1449', '201', '996', '324', '601', '776', '973', '1647', '223', '417', '616', '837', '1026', '1241', '1411', '1458', '1552', '1602', '108', '313', '389', '467', '1231', '1489', '266', '341', '857', '74', '851', '954', '1029', '1034', '1285', '1366', '1496', '1609', '1711', '421', '666', '704', '885', '1055', '1152', '1230', '1260', '1362', '1368', '1372', '480', '574', '888', '1383', '1384', '1470', '1516', '1628', '105', '147', '1224', '1408', '1717', '503', '749', '790', '1054', '1154', '1208', '1505', '1518', '1571', '1611', '208', '1672', '205', '332', '494', '652', '796', '818', '884', '1068', '1253', '1501', '1521', '1612', '123', '422', '618', '836', '985', '1148', '1486', '493', '937', '938', '1517', '1522', '1632', '204', '212', '423', '448', '485', '1409', '1682', '1138', '1410', '1593', '1639', '66', '375', '994', '995', '1141', '972', '1017', '1303', '1461', '1539', '1627', '1064', '1514', '1601', '1613', '420', '1073', '1254', '1437', '453', '1028', '1229', '1481', '1515', '1716', '487', '665', '1175', '1259', '1412', '1684', '958', '1189', '1262', '1619', '70', '717', '775', '795', '1159', '1713', '1715', '715', '1053', '1266', '1439', '1714', '738', '1011', '1240', '1704', '69', '944', '1274', '1385', '1606', '419', '1106', '1110', '1183', '1184', '1192', '1347', '1360', '1361', '1459', '808', '1058', '1089', '1160', '1195', '1338', '1339', '1342', '1474', '1543', '1545', '62', '488', '1322', '1708', '798', '886', '1071', '1087', '1158', '1298', '1311', '1404', '1645', '1649', '1723', '225', '1132', '1310', '1697', '1729', '17', '299', '300', '555', '997', '1023', '1043', '1355', '1358', '1451', '1629', '479', '672', '821', '1047', '1063', '1217', '1257', '1312', '1540', '288', '692', '707', '1109', '1140', '1167', '1282', '1350', '1426', '1546', '1558')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,977,1199,1291,1588,407,517,726,258,1237,27,1424,22,461,28,1599,21,1422,817,1423,1594,393,1419,1420,1421,1418,1135,349,1359,452,780,113,766,265,24,11,1574,439,542,9,10,207,1245,585,770,330,404,1272,455,974,124,1067,1455,792,1460,553,871,1215,797,5,739,674,573,25,1572,3,520,855,1193,1607,14,78,434,711,340,1021,253,1302,1402,1586,390,559,748,1284,43,580,1172,1581,462,765,791,1320,1323,285,874,658,405,590,678,1139,582,286,327,526,883,970,731,859,454,854,81,406,823,722,1236,1614,850,1027,1415,1569,31,114,993,1348,37,1319,30,34,35,36,38,39,82,378,403,547,1008,1012,1326,1327,1330,1678,160,163,333,351,451,784,1205,1325,348,657,966,1454,1575,338,84,262,325,701,1143,521,683,352,508,732,287,1088,1134,1151,1157,1318,4,111,610,1075,1108,1367,1471,1579,290,1032,1345,314,751,1214,1223,1233,1308,119,335,1013,1145,1321,93,162,1405,651,673,1137,1144,1344,1376,1615,291,394,483,852,988,1149,1343,1587,45,116,1452,1453,1604,152,401,545,1095,98,441,1025,1090,1136,1283,1373,1724,626,716,882,968,1163,1168,1243,1301,1413,59,75,150,768,769,986,1292,1398,1526,148,149,151,669,905,1382,1417,1448,1492,639,1150,1176,1226,1449,201,996,324,601,776,973,1647,223,417,616,837,1026,1241,1411,1458,1552,1602,108,313,389,467,1231,1489,266,341,857,74,851,954,1029,1034,1285,1366,1496,1609,1711,421,666,704,885,1055,1152,1230,1260,1362,1368,1372,480,574,888,1383,1384,1470,1516,1628,105,147,1224,1408,1717,503,749,790,1054,1154,1208,1505,1518,1571,1611,208,1672,205,332,494,652,796,818,884,1068,1253,1501,1521,1612,123,422,618,836,985,1148,1486,493,937,938,1517,1522,1632,204,212,423,448,485,1409,1682,1138,1410,1593,1639,66,375,994,995,1141,972,1017,1303,1461,1539,1627,1064,1514,1601,1613,420,1073,1254,1437,453,1028,1229,1481,1515,1716,487,665,1175,1259,1412,1684,958,1189,1262,1619,70,717,775,795,1159,1713,1715,715,1053,1266,1439,1714,738,1011,1240,1704,69,944,1274,1385,1606,419,1106,1110,1183,1184,1192,1347,1360,1361,1459,808,1058,1089,1160,1195,1338,1339,1342,1474,1543,1545,62,488,1322,1708,798,886,1071,1087,1158,1298,1311,1404,1645,1649,1723,225,1132,1310,1697,1729,17,299,300,555,997,1023,1043,1355,1358,1451,1629,479,672,821,1047,1063,1217,1257,1312,1540,288,692,707,1109,1140,1167,1282,1350,1426,1546,1558') 0.021052837371826
(604) DESCRIBE `cruisetypes` 0.0010428428649902
(605) DESCRIBE `destinations` 0.0010380744934082
(606) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '26', '28', '55', '11', '21', '38', '40', '49', '7', '48', '44', '30', '29', '10', '34', '45', '56', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,26,28,55,11,21,38,40,49,7,48,44,30,29,10,34,45,56,52,46,32') 0.0011029243469238