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

Total elapsed time: 0.39439797401428

# Query Time
(1) connect 0.00052189826965332
(2) DESCRIBE `cruises` 0.0017690658569336
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66422, 66444, 67148, 67923, 70559, 61455, 61458, 66105, 67294, 6056)) ORDER BY FIND_IN_SET(id, '66422,66444,67148,67923,70559,61455,61458,66105,67294,6056') 0.0014021396636963
(4) DESCRIBE `cruises` 0.0016839504241943
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66422') 0.0002589225769043
(6) DESCRIBE `ships` 0.0013151168823242
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 324))) 0.00031590461730957
(8) DESCRIBE `ships` 0.001356840133667
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '324') 0.00020098686218262
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016379356384277
(12) DESCRIBE `itineraries` 0.00072002410888672
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66422') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061392784118652
(14) DESCRIBE `ports` 0.00096297264099121
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026202201843262
(16) DESCRIBE `ports` 0.00076103210449219
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020003318786621
(18) DESCRIBE `ports` 0.00069403648376465
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020194053649902
(20) DESCRIBE `sailingdates` 0.00060701370239258
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66422') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052785873413086
(22) DESCRIBE `ports` 0.00075411796569824
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024294853210449
(24) DESCRIBE `ports` 0.00069999694824219
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018501281738281
(26) DESCRIBE `ports` 0.00069117546081543
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00020408630371094
(28) DESCRIBE `ports` 0.00071001052856445
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.0001838207244873
(30) DESCRIBE `ports` 0.00068306922912598
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00018787384033203
(32) DESCRIBE `ports` 0.00068998336791992
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00017809867858887
(34) DESCRIBE `ports` 0.00082302093505859
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0001978874206543
(36) DESCRIBE `ports` 0.00068211555480957
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017404556274414
(38) DESCRIBE `ports` 0.00065207481384277
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.000244140625
(40) DESCRIBE `ports` 0.00076699256896973
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00020313262939453
(42) DESCRIBE `ports` 0.0008389949798584
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00025606155395508
(44) DESCRIBE `ports` 0.000946044921875
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00021505355834961
(46) DESCRIBE `ports` 0.00081396102905273
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00022697448730469
(48) DESCRIBE `ports` 0.00070905685424805
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00020790100097656
(50) DESCRIBE `ports` 0.00079703330993652
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 581))) 0.00022101402282715
(52) DESCRIBE `ports` 0.00076484680175781
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '581') 0.00017786026000977
(54) DESCRIBE `ports` 0.00066494941711426
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021815299987793
(56) DESCRIBE `ports` 0.00065898895263672
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017499923706055
(58) DESCRIBE `avid_specials` 0.00061702728271484
(59) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66422 and class = 'Cruise') OR (item_id = 324 AND class = 'Ship') OR (item_id = 8 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.00098204612731934
(60) DESCRIBE `cruiselines` 0.0010089874267578
(61) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00020885467529297
(62) DESCRIBE `orchid_image` 0.00076699256896973
(63) DESCRIBE `cruiselines` 0.00094413757324219
(64) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00017786026000977
(65) DESCRIBE `cruises` 0.0012760162353516
(66) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66444') 0.00020003318786621
(67) DESCRIBE `ships` 0.0012750625610352
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 776))) 0.00023007392883301
(69) DESCRIBE `ships` 0.0012960433959961
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '776') 0.00017499923706055
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017404556274414
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016403198242188
(73) DESCRIBE `itineraries` 0.00070595741271973
(74) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66444') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00087499618530273
(75) DESCRIBE `ports` 0.00077009201049805
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00021481513977051
(77) DESCRIBE `ports` 0.00070714950561523
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00019097328186035
(79) DESCRIBE `ports` 0.00070309638977051
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00019621849060059
(81) DESCRIBE `sailingdates` 0.00063705444335938
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66444') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044703483581543
(83) DESCRIBE `ports` 0.00069212913513184
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00020694732666016
(85) DESCRIBE `ports` 0.00067901611328125
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00021505355834961
(87) DESCRIBE `ports` 0.00091004371643066
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00020980834960938
(89) DESCRIBE `ports` 0.00069403648376465
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00020003318786621
(91) DESCRIBE `ports` 0.00073885917663574
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00029182434082031
(93) DESCRIBE `ports` 0.00085091590881348
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00018596649169922
(95) DESCRIBE `ports` 0.00068402290344238
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00020599365234375
(97) DESCRIBE `ports` 0.00073409080505371
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00022196769714355
(99) DESCRIBE `ports` 0.00068092346191406
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00021004676818848
(101) DESCRIBE `ports` 0.0007939338684082
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00021195411682129
(103) DESCRIBE `ports` 0.00076985359191895
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00019407272338867
(105) DESCRIBE `ports` 0.00067710876464844
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00017404556274414
(107) DESCRIBE `ports` 0.0006568431854248
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00019097328186035
(109) DESCRIBE `ports` 0.00065994262695312
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00019693374633789
(111) DESCRIBE `ports` 0.00067901611328125
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00019001960754395
(113) DESCRIBE `ports` 0.00065493583679199
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00017309188842773
(115) DESCRIBE `avid_specials` 0.00063204765319824
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66444 and class = 'Cruise') OR (item_id = 776 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 49 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.00098896026611328
(117) DESCRIBE `cruiselines` 0.0010950565338135
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0002751350402832
(119) DESCRIBE `orchid_image` 0.00082206726074219
(120) DESCRIBE `cruiselines` 0.00096607208251953
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00021004676818848
(122) DESCRIBE `cruises` 0.0012788772583008
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67148') 0.00023388862609863
(124) DESCRIBE `ships` 0.0013089179992676
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00031590461730957
(126) DESCRIBE `ships` 0.0019509792327881
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00030612945556641
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022506713867188
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021004676818848
(130) DESCRIBE `itineraries` 0.00095510482788086
(131) DESCRIBE `ports` 0.00093698501586914
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027084350585938
(133) DESCRIBE `ports` 0.0009150505065918
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00025391578674316
(135) DESCRIBE `ports` 0.00088906288146973
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024795532226562
(137) DESCRIBE `sailingdates` 0.00082898139953613
(138) DESCRIBE `ports` 0.00095891952514648
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028705596923828
(140) DESCRIBE `ports` 0.00093698501586914
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024104118347168
(142) DESCRIBE `ports` 0.00092196464538574
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1901))) 0.00025701522827148
(144) DESCRIBE `ports` 0.00095319747924805
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1901') 0.00023484230041504
(146) DESCRIBE `ports` 0.00092101097106934
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1902))) 0.00026679039001465
(148) DESCRIBE `ports` 0.0009150505065918
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1902') 0.00023603439331055
(150) DESCRIBE `ports` 0.00095796585083008
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00026488304138184
(152) DESCRIBE `ports` 0.00094318389892578
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00025010108947754
(154) DESCRIBE `ports` 0.0010240077972412
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00027894973754883
(156) DESCRIBE `ports` 0.00095105171203613
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00023984909057617
(158) DESCRIBE `ports` 0.00098085403442383
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027894973754883
(160) DESCRIBE `ports` 0.00097990036010742
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024008750915527
(162) DESCRIBE `avid_specials` 0.000885009765625
(163) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67148 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014920234680176
(164) DESCRIBE `cruiselines` 0.0014829635620117
(165) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00046706199645996
(166) DESCRIBE `orchid_image` 0.0013420581817627
(167) DESCRIBE `cruiselines` 0.0013890266418457
(168) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00028204917907715
(169) DESCRIBE `cruises` 0.0019481182098389
(170) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67923') 0.00032901763916016
(171) DESCRIBE `ships` 0.0017349720001221
(172) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 687))) 0.00028705596923828
(173) DESCRIBE `ships` 0.001331090927124
(174) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '687') 0.0004270076751709
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002140998840332
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017595291137695
(177) DESCRIBE `itineraries` 0.00092291831970215
(178) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67923') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014259815216064
(179) DESCRIBE `ports` 0.0010161399841309
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00028014183044434
(181) DESCRIBE `ports` 0.00068402290344238
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020194053649902
(183) DESCRIBE `ports` 0.00067520141601562
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00019693374633789
(185) DESCRIBE `sailingdates` 0.00062298774719238
(186) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67923') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059700012207031
(187) DESCRIBE `ports` 0.00078415870666504
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00025200843811035
(189) DESCRIBE `ports` 0.00068306922912598
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00023603439331055
(191) DESCRIBE `ports` 0.00071096420288086
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020790100097656
(193) DESCRIBE `ports` 0.00071191787719727
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00024199485778809
(195) DESCRIBE `ports` 0.00097298622131348
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.0002129077911377
(197) DESCRIBE `ports` 0.00069093704223633
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00018596649169922
(199) DESCRIBE `ports` 0.00067591667175293
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00020980834960938
(201) DESCRIBE `ports` 0.00072503089904785
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00018501281738281
(203) DESCRIBE `ports` 0.00066995620727539
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00020909309387207
(205) DESCRIBE `ports` 0.00067901611328125
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00018787384033203
(207) DESCRIBE `ports` 0.00071310997009277
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4087))) 0.00020503997802734
(209) DESCRIBE `ports` 0.00066709518432617
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4087') 0.00018501281738281
(211) DESCRIBE `ports` 0.00066518783569336
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4087))) 0.00023007392883301
(213) DESCRIBE `ports` 0.00066709518432617
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4087') 0.00018787384033203
(215) DESCRIBE `ports` 0.00066995620727539
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020408630371094
(217) DESCRIBE `ports` 0.00066685676574707
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00022196769714355
(219) DESCRIBE `ports` 0.00084805488586426
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4943))) 0.00024008750915527
(221) DESCRIBE `ports` 0.00080108642578125
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4943') 0.0001990795135498
(223) DESCRIBE `ports` 0.00068998336791992
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5258))) 0.00020599365234375
(225) DESCRIBE `ports` 0.00069189071655273
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5258') 0.00018405914306641
(227) DESCRIBE `ports` 0.00067806243896484
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00020503997802734
(229) DESCRIBE `ports` 0.00068402290344238
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00018596649169922
(231) DESCRIBE `ports` 0.00066900253295898
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021100044250488
(233) DESCRIBE `ports` 0.00069308280944824
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018310546875
(235) DESCRIBE `ports` 0.00066399574279785
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0001988410949707
(237) DESCRIBE `ports` 0.00081896781921387
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018811225891113
(239) DESCRIBE `avid_specials` 0.00062799453735352
(240) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67923 and class = 'Cruise') OR (item_id = 687 AND class = 'Ship') OR (item_id = 156 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.0010459423065186
(241) DESCRIBE `cruiselines` 0.00097489356994629
(242) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00024986267089844
(243) DESCRIBE `orchid_image` 0.00084495544433594
(244) DESCRIBE `cruiselines` 0.0009620189666748
(245) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00024986267089844
(246) DESCRIBE `cruises` 0.0013229846954346
(247) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70559') 0.00026702880859375
(248) DESCRIBE `ships` 0.0013198852539062
(249) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1444))) 0.00029897689819336
(250) DESCRIBE `ships` 0.0014290809631348
(251) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1444') 0.00022411346435547
(252) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018405914306641
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017094612121582
(254) DESCRIBE `itineraries` 0.0007171630859375
(255) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70559') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013489723205566
(256) DESCRIBE `ports` 0.00088787078857422
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00026416778564453
(258) DESCRIBE `ports` 0.00072407722473145
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021100044250488
(260) DESCRIBE `ports` 0.00067901611328125
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0002138614654541
(262) DESCRIBE `sailingdates` 0.00060915946960449
(263) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70559') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061702728271484
(264) DESCRIBE `ports` 0.00081610679626465
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00023007392883301
(266) DESCRIBE `ports` 0.00067806243896484
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00020599365234375
(268) DESCRIBE `ports` 0.0007481575012207
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020194053649902
(270) DESCRIBE `ports` 0.00072002410888672
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018811225891113
(272) DESCRIBE `ports` 0.0006718635559082
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4685))) 0.00021505355834961
(274) DESCRIBE `ports` 0.00092983245849609
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4685') 0.00024914741516113
(276) DESCRIBE `ports` 0.0010230541229248
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00030994415283203
(278) DESCRIBE `ports` 0.00098705291748047
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00020694732666016
(280) DESCRIBE `ports` 0.0007939338684082
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00028109550476074
(282) DESCRIBE `ports` 0.0007328987121582
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00020909309387207
(284) DESCRIBE `ports` 0.00068807601928711
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00020289421081543
(286) DESCRIBE `ports` 0.000762939453125
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00024795532226562
(288) DESCRIBE `ports` 0.0010178089141846
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5222))) 0.0002899169921875
(290) DESCRIBE `ports` 0.0010159015655518
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5222') 0.00024795532226562
(292) DESCRIBE `ports` 0.00070309638977051
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00020909309387207
(294) DESCRIBE `ports` 0.00067496299743652
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00018501281738281
(296) DESCRIBE `ports` 0.00070881843566895
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020599365234375
(298) DESCRIBE `ports` 0.00067305564880371
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018692016601562
(300) DESCRIBE `ports` 0.00070095062255859
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021505355834961
(302) DESCRIBE `ports` 0.0006871223449707
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00020790100097656
(304) DESCRIBE `ports` 0.00077486038208008
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00023317337036133
(306) DESCRIBE `ports` 0.00078415870666504
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00020790100097656
(308) DESCRIBE `avid_specials` 0.00061893463134766
(309) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70559 and class = 'Cruise') OR (item_id = 1444 AND class = 'Ship') OR (item_id = 156 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.00097298622131348
(310) DESCRIBE `cruiselines` 0.0009920597076416
(311) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00026082992553711
(312) DESCRIBE `orchid_image` 0.00095391273498535
(313) DESCRIBE `cruiselines` 0.0010309219360352
(314) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00021100044250488
(315) DESCRIBE `cruises` 0.0020120143890381
(316) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61455') 0.00034713745117188
(317) DESCRIBE `ships` 0.0020260810852051
(318) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1326))) 0.00038599967956543
(319) DESCRIBE `ships` 0.0019490718841553
(320) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1326') 0.00028800964355469
(321) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023388862609863
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039315223693848
(323) DESCRIBE `itineraries` 0.0010058879852295
(324) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61455') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00078701972961426
(325) DESCRIBE `ports` 0.0011560916900635
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00032210350036621
(327) DESCRIBE `ports` 0.00097393989562988
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00026512145996094
(329) DESCRIBE `ports` 0.0009620189666748
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00025200843811035
(331) DESCRIBE `sailingdates` 0.00083613395690918
(332) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61455') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079989433288574
(333) DESCRIBE `ports` 0.0011022090911865
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00040292739868164
(335) DESCRIBE `ports` 0.00080585479736328
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00021004676818848
(337) DESCRIBE `ports` 0.00067996978759766
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00024104118347168
(339) DESCRIBE `ports` 0.00068092346191406
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00018715858459473
(341) DESCRIBE `ports` 0.00067591667175293
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1536))) 0.00021696090698242
(343) DESCRIBE `ports` 0.00078296661376953
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1536') 0.00019097328186035
(345) DESCRIBE `ports` 0.00072097778320312
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1536))) 0.00020599365234375
(347) DESCRIBE `ports` 0.00067806243896484
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1536') 0.00018715858459473
(349) DESCRIBE `ports` 0.00084519386291504
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1539))) 0.00025296211242676
(351) DESCRIBE `ports` 0.00090599060058594
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1539') 0.00023794174194336
(353) DESCRIBE `ports` 0.00089788436889648
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00030398368835449
(355) DESCRIBE `ports` 0.00088787078857422
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00023007392883301
(357) DESCRIBE `ports` 0.00089001655578613
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 984))) 0.00026488304138184
(359) DESCRIBE `ports` 0.00088691711425781
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '984') 0.00023603439331055
(361) DESCRIBE `ports` 0.0009150505065918
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1603))) 0.00021600723266602
(363) DESCRIBE `ports` 0.0008080005645752
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1603') 0.00018906593322754
(365) DESCRIBE `ports` 0.00066995620727539
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020694732666016
(367) DESCRIBE `ports` 0.00081396102905273
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00019097328186035
(369) DESCRIBE `ports` 0.00067496299743652
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020289421081543
(371) DESCRIBE `ports` 0.00067305564880371
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00021004676818848
(373) DESCRIBE `ports` 0.00067305564880371
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.0001990795135498
(375) DESCRIBE `ports` 0.00066900253295898
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00018620491027832
(377) DESCRIBE `avid_specials` 0.00065898895263672
(378) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61455 and class = 'Cruise') OR (item_id = 1326 AND class = 'Ship') OR (item_id = 77 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.0010027885437012
(379) DESCRIBE `cruiselines` 0.001021146774292
(380) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00028610229492188
(381) DESCRIBE `orchid_image` 0.00085997581481934
(382) DESCRIBE `cruiselines` 0.00098800659179688
(383) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00022411346435547
(384) DESCRIBE `cruises` 0.0014710426330566
(385) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61458') 0.00026583671569824
(386) DESCRIBE `ships` 0.001352071762085
(387) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1327))) 0.00030684471130371
(388) DESCRIBE `ships` 0.0013711452484131
(389) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1327') 0.00022292137145996
(390) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(391) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022315979003906
(392) DESCRIBE `itineraries` 0.00071001052856445
(393) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61458') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00044918060302734
(394) DESCRIBE `ports` 0.0014650821685791
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00037193298339844
(396) DESCRIBE `ports` 0.0011508464813232
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00031900405883789
(398) DESCRIBE `ports` 0.0010800361633301
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00026798248291016
(400) DESCRIBE `sailingdates` 0.00089907646179199
(401) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61458') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007178783416748
(402) DESCRIBE `ports` 0.0013868808746338
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00036001205444336
(404) DESCRIBE `ports` 0.00099802017211914
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.0002598762512207
(406) DESCRIBE `ports` 0.0010619163513184
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00028896331787109
(408) DESCRIBE `ports` 0.0010290145874023
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00026106834411621
(410) DESCRIBE `ports` 0.0010199546813965
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1603))) 0.00028896331787109
(412) DESCRIBE `ports` 0.0010349750518799
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1603') 0.00025701522827148
(414) DESCRIBE `ports` 0.0010240077972412
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 984))) 0.00030994415283203
(416) DESCRIBE `ports` 0.0010688304901123
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '984') 0.00030207633972168
(418) DESCRIBE `ports` 0.0010800361633301
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00037693977355957
(420) DESCRIBE `ports` 0.001147985458374
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00027704238891602
(422) DESCRIBE `ports` 0.0011210441589355
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1539))) 0.00045180320739746
(424) DESCRIBE `ports` 0.001162052154541
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1539') 0.00028085708618164
(426) DESCRIBE `ports` 0.0009760856628418
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1537))) 0.00027799606323242
(428) DESCRIBE `ports` 0.0010139942169189
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1537') 0.000244140625
(430) DESCRIBE `ports` 0.00098896026611328
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1536))) 0.0002739429473877
(432) DESCRIBE `ports` 0.0010039806365967
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1536') 0.0002439022064209
(434) DESCRIBE `ports` 0.00098490715026855
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1536))) 0.00027585029602051
(436) DESCRIBE `ports` 0.00097894668579102
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1536') 0.00021004676818848
(438) DESCRIBE `ports` 0.00092387199401855
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00023794174194336
(440) DESCRIBE `ports` 0.00072312355041504
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00018906593322754
(442) DESCRIBE `ports` 0.00067710876464844
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00020599365234375
(444) DESCRIBE `ports` 0.0008080005645752
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00020098686218262
(446) DESCRIBE `ports` 0.00070095062255859
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00021886825561523
(448) DESCRIBE `ports` 0.0006868839263916
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00021195411682129
(450) DESCRIBE `avid_specials` 0.00063586235046387
(451) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61458 and class = 'Cruise') OR (item_id = 1327 AND class = 'Ship') OR (item_id = 77 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.0012218952178955
(452) DESCRIBE `cruiselines` 0.0012030601501465
(453) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00024914741516113
(454) DESCRIBE `orchid_image` 0.0008080005645752
(455) DESCRIBE `cruiselines` 0.0009760856628418
(456) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00020003318786621
(457) DESCRIBE `cruises` 0.0013279914855957
(458) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66105') 0.00025105476379395
(459) DESCRIBE `ships` 0.0016717910766602
(460) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00047087669372559
(461) DESCRIBE `ships` 0.0019338130950928
(462) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00029802322387695
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023293495178223
(464) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023508071899414
(465) DESCRIBE `itineraries` 0.00081706047058105
(466) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66105') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00068902969360352
(467) DESCRIBE `ports` 0.00083398818969727
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023698806762695
(469) DESCRIBE `ports` 0.0007929801940918
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020790100097656
(471) DESCRIBE `ports` 0.0007939338684082
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020003318786621
(473) DESCRIBE `sailingdates` 0.00063300132751465
(474) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66105') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052690505981445
(475) DESCRIBE `ports` 0.00084805488586426
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00028300285339355
(477) DESCRIBE `ports` 0.00068402290344238
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019407272338867
(479) DESCRIBE `ports` 0.00069785118103027
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00020599365234375
(481) DESCRIBE `ports` 0.00075984001159668
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00018715858459473
(483) DESCRIBE `ports` 0.00067996978759766
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00020503997802734
(485) DESCRIBE `ports` 0.00078606605529785
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00020694732666016
(487) DESCRIBE `ports` 0.00077581405639648
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00024890899658203
(489) DESCRIBE `ports` 0.00068116188049316
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018596649169922
(491) DESCRIBE `ports` 0.00092792510986328
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4467))) 0.00025606155395508
(493) DESCRIBE `ports` 0.00092101097106934
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4467') 0.00027894973754883
(495) DESCRIBE `ports` 0.00072789192199707
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00021696090698242
(497) DESCRIBE `ports` 0.00078487396240234
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00019192695617676
(499) DESCRIBE `ports` 0.0007021427154541
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002140998840332
(501) DESCRIBE `ports` 0.00069189071655273
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019598007202148
(503) DESCRIBE `avid_specials` 0.00088906288146973
(504) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66105 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 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.00096511840820312
(505) DESCRIBE `cruiselines` 0.00098013877868652
(506) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00024914741516113
(507) DESCRIBE `orchid_image` 0.00088286399841309
(508) DESCRIBE `cruiselines` 0.0014340877532959
(509) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00023078918457031
(510) DESCRIBE `cruises` 0.0018100738525391
(511) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67294') 0.00023484230041504
(512) DESCRIBE `ships` 0.0012989044189453
(513) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1579))) 0.00032186508178711
(514) DESCRIBE `ships` 0.0012900829315186
(515) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1579') 0.00021004676818848
(516) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018787384033203
(517) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(518) DESCRIBE `itineraries` 0.00080394744873047
(519) DESCRIBE `ports` 0.00073719024658203
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0002291202545166
(521) DESCRIBE `ports` 0.00068211555480957
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00020980834960938
(523) DESCRIBE `ports` 0.00081801414489746
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00020098686218262
(525) DESCRIBE `sailingdates` 0.000701904296875
(526) DESCRIBE `ports` 0.0007328987121582
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00022411346435547
(528) DESCRIBE `ports` 0.00070500373840332
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00019216537475586
(530) DESCRIBE `ports` 0.00069189071655273
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00022506713867188
(532) DESCRIBE `ports` 0.00067615509033203
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00023603439331055
(534) DESCRIBE `ports` 0.00069403648376465
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020909309387207
(536) DESCRIBE `ports` 0.00068998336791992
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018477439880371
(538) DESCRIBE `ports` 0.00072097778320312
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00022506713867188
(540) DESCRIBE `ports` 0.00081706047058105
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00022196769714355
(542) DESCRIBE `ports` 0.00067305564880371
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00020313262939453
(544) DESCRIBE `ports` 0.00086402893066406
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00024008750915527
(546) DESCRIBE `avid_specials` 0.00088095664978027
(547) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67294 and class = 'Cruise') OR (item_id = 1579 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.0017669200897217
(548) DESCRIBE `cruiselines` 0.0011470317840576
(549) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00026082992553711
(550) DESCRIBE `orchid_image` 0.0008389949798584
(551) DESCRIBE `cruiselines` 0.00094485282897949
(552) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00022983551025391
(553) DESCRIBE `cruises` 0.0013279914855957
(554) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '6056') 0.0002288818359375
(555) DESCRIBE `ships` 0.0013399124145508
(556) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.00026893615722656
(557) DESCRIBE `ships` 0.0013401508331299
(558) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.00021982192993164
(559) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020503997802734
(560) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017499923706055
(561) DESCRIBE `itineraries` 0.00068092346191406
(562) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '6056') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054001808166504
(563) DESCRIBE `ports` 0.00069403648376465
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00022196769714355
(565) DESCRIBE `ports` 0.00067591667175293
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00022506713867188
(567) DESCRIBE `ports` 0.00066900253295898
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018692016601562
(569) DESCRIBE `sailingdates` 0.00061202049255371
(570) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '6056') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0009307861328125
(571) DESCRIBE `ports` 0.00080084800720215
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00022602081298828
(573) DESCRIBE `ports` 0.00068497657775879
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019311904907227
(575) DESCRIBE `ports` 0.0006721019744873
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020909309387207
(577) DESCRIBE `ports` 0.00067496299743652
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018501281738281
(579) DESCRIBE `ports` 0.0007469654083252
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020313262939453
(581) DESCRIBE `ports` 0.00067496299743652
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018596649169922
(583) DESCRIBE `ports` 0.00077199935913086
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020003318786621
(585) DESCRIBE `ports` 0.00066995620727539
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00020384788513184
(587) DESCRIBE `ports` 0.00071382522583008
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0002129077911377
(589) DESCRIBE `ports` 0.00067591667175293
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018501281738281
(591) DESCRIBE `ports` 0.00067400932312012
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00021696090698242
(593) DESCRIBE `ports` 0.0006709098815918
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00019693374633789
(595) DESCRIBE `ports` 0.0007331371307373
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00026512145996094
(597) DESCRIBE `ports` 0.00069308280944824
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018882751464844
(599) DESCRIBE `ports` 0.00066995620727539
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020384788513184
(601) DESCRIBE `ports` 0.00067520141601562
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018787384033203
(603) DESCRIBE `avid_specials` 0.00070285797119141
(604) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 6056 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00095891952514648
(605) DESCRIBE `cruiselines` 0.0009620189666748
(606) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.00022697448730469
(607) DESCRIBE `orchid_image` 0.00079607963562012
(608) DESCRIBE `cruiselines` 0.00099897384643555
(609) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.00021791458129883
(610) DESCRIBE `cruiselines` 0.0015110969543457
(611) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '171', '31', '18', '101', '183', '20', '7', '8', '96', '144', '12', '120', '221', '103', '50', '268', '15', '29', '37', '91', '110', '232', '208', '28', '206', '33', '131', '156', '49', '118', '24', '220', '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', '170', '180', '59', '115', '225', '229', '140', '95', '219', '57', '108', '231', '269', '184', '52', '132', '248', '276', '88', '275', '38', '182', '261', '264', '244', '82', '230', '105', '116', '266', '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,96,144,12,120,221,103,50,268,15,29,37,91,110,232,208,28,206,33,131,156,49,118,24,220,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,170,180,59,115,225,229,140,95,219,57,108,231,269,184,52,132,248,276,88,275,38,182,261,264,244,82,230,105,116,266,39,64,48,119,240,224,245,210,134,251') 0.0036630630493164
(612) DESCRIBE `ships` 0.002187967300415
(613) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '977', '1199', '1291', '1588', '407', '517', '726', '258', '1237', '27', '22', '1424', '461', '1599', '28', '21', '817', '1422', '1594', '393', '1419', '1420', '1423', '1418', '1421', '1135', '349', '1359', '452', '780', '113', '766', '265', '24', '11', '439', '1574', '9', '10', '207', '542', '1067', '1245', '585', '674', '770', '330', '404', '1272', '455', '974', '124', '1455', '1460', '792', '1215', '553', '797', '5', '739', '871', '116', '573', '1572', '25', '3', '520', '855', '1607', '14', '78', '711', '1193', '340', '434', '1021', '1302', '1402', '253', '1586', '390', '1284', '748', '1172', '43', '559', '580', '1581', '462', '765', '285', '791', '1320', '1323', '874', '658', '405', '1139', '590', '678', '286', '582', '883', '119', '327', '526', '731', '859', '970', '454', '854', '406', '81', '823', '610', '722', '850', '1236', '1027', '1569', '114', '993', '1348', '1319', '1415', '1614', '30', '31', '34', '35', '36', '37', '38', '82', '378', '403', '1008', '1012', '1326', '1327', '1678', '39', '160', '333', '547', '1330', '451', '1205', '1325', '163', '348', '351', '784', '966', '1454', '338', '657', '84', '262', '701', '1575', '325', '521', '683', '1143', '732', '287', '352', '1318', '4', '111', '508', '1088', '1108', '1151', '1157', '1471', '1579', '389', '1032', '1075', '1134', '1367', '290', '314', '751', '1214', '1233', '1308', '335', '1145', '1223', '1345', '93', '1013', '1321', '1405', '162', '1137', '1344', '1376', '291', '394', '483', '651', '673', '1144', '1343', '1587', '45', '852', '1604', '545', '988', '1149', '1452', '1453', '1615', '152', '401', '1025', '1090', '1095', '1136', '1283', '1724', '98', '441', '882', '968', '1168', '1243', '1373', '1413', '626', '716', '768', '1163', '1301', '1398', '59', '148', '149', '150', '769', '986', '1382', '1417', '1492', '1526', '75', '151', '639', '669', '905', '1150', '1176', '1226', '1292', '1448', '201', '1449', '324', '776', '973', '1647', '223', '417', '601', '616', '837', '996', '1241', '1458', '1552', '1602', '108', '313', '467', '1026', '1411', '266', '341', '857', '1231', '1489', '954', '1029', '1034', '1285', '1366', '1496', '1609', '1711', '74', '421', '666', '704', '851', '1055', '1152', '1362', '1368', '1372', '480', '885', '1230', '1260', '1384', '1516', '105', '147', '574', '888', '1383', '1408', '1470', '1628', '1717', '503', '790', '1054', '1154', '1208', '1224', '1518', '749', '1505', '1571', '208', '1672', '205', '332', '494', '652', '796', '884', '1253', '1501', '1521', '1611', '422', '618', '811', '818', '836', '985', '1148', '123', '493', '1068', '1486', '1517', '1522', '1632', '204', '212', '423', '937', '938', '1409', '1612', '1682', '448', '485', '1138', '1593', '1639', '994', '995', '1410', '66', '972', '1141', '375', '1017', '1303', '1461', '1539', '1627', '1064', '1601', '420', '1073', '1437', '1514', '1028', '1229', '1254', '1481', '1515', '1613', '1716', '453', '487', '665', '1259', '1412', '1684', '1175', '1189', '1262', '1619', '70', '717', '795', '958', '1159', '1713', '1715', '775', '1053', '1266', '1439', '1714', '715', '738', '1011', '1240', '1704', '1274', '1606', '69', '419', '1106', '1110', '1192', '1360', '1361', '1385', '1459', '944', '1183', '1184', '1347', '808', '1058', '1089', '1338', '1339', '1342', '1474', '1543', '1545', '1160', '1195', '1322', '1708', '62', '488', '798', '886', '1071', '1298', '1311', '1404', '1723', '225', '1158', '1310', '1645', '1649', '1697', '1729', '17', '299', '300', '997', '1043', '1087', '1132', '1355', '1358', '1451', '1629', '479', '672', '821', '1023', '1063', '1217', '1257', '1312', '1540', '288', '555', '692', '707', '1047', '1109', '1140', '1282', '1329', '1350', '1426', '1546')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,977,1199,1291,1588,407,517,726,258,1237,27,22,1424,461,1599,28,21,817,1422,1594,393,1419,1420,1423,1418,1421,1135,349,1359,452,780,113,766,265,24,11,439,1574,9,10,207,542,1067,1245,585,674,770,330,404,1272,455,974,124,1455,1460,792,1215,553,797,5,739,871,116,573,1572,25,3,520,855,1607,14,78,711,1193,340,434,1021,1302,1402,253,1586,390,1284,748,1172,43,559,580,1581,462,765,285,791,1320,1323,874,658,405,1139,590,678,286,582,883,119,327,526,731,859,970,454,854,406,81,823,610,722,850,1236,1027,1569,114,993,1348,1319,1415,1614,30,31,34,35,36,37,38,82,378,403,1008,1012,1326,1327,1678,39,160,333,547,1330,451,1205,1325,163,348,351,784,966,1454,338,657,84,262,701,1575,325,521,683,1143,732,287,352,1318,4,111,508,1088,1108,1151,1157,1471,1579,389,1032,1075,1134,1367,290,314,751,1214,1233,1308,335,1145,1223,1345,93,1013,1321,1405,162,1137,1344,1376,291,394,483,651,673,1144,1343,1587,45,852,1604,545,988,1149,1452,1453,1615,152,401,1025,1090,1095,1136,1283,1724,98,441,882,968,1168,1243,1373,1413,626,716,768,1163,1301,1398,59,148,149,150,769,986,1382,1417,1492,1526,75,151,639,669,905,1150,1176,1226,1292,1448,201,1449,324,776,973,1647,223,417,601,616,837,996,1241,1458,1552,1602,108,313,467,1026,1411,266,341,857,1231,1489,954,1029,1034,1285,1366,1496,1609,1711,74,421,666,704,851,1055,1152,1362,1368,1372,480,885,1230,1260,1384,1516,105,147,574,888,1383,1408,1470,1628,1717,503,790,1054,1154,1208,1224,1518,749,1505,1571,208,1672,205,332,494,652,796,884,1253,1501,1521,1611,422,618,811,818,836,985,1148,123,493,1068,1486,1517,1522,1632,204,212,423,937,938,1409,1612,1682,448,485,1138,1593,1639,994,995,1410,66,972,1141,375,1017,1303,1461,1539,1627,1064,1601,420,1073,1437,1514,1028,1229,1254,1481,1515,1613,1716,453,487,665,1259,1412,1684,1175,1189,1262,1619,70,717,795,958,1159,1713,1715,775,1053,1266,1439,1714,715,738,1011,1240,1704,1274,1606,69,419,1106,1110,1192,1360,1361,1385,1459,944,1183,1184,1347,808,1058,1089,1338,1339,1342,1474,1543,1545,1160,1195,1322,1708,62,488,798,886,1071,1298,1311,1404,1723,225,1158,1310,1645,1649,1697,1729,17,299,300,997,1043,1087,1132,1355,1358,1451,1629,479,672,821,1023,1063,1217,1257,1312,1540,288,555,692,707,1047,1109,1140,1282,1329,1350,1426,1546') 0.026170969009399
(614) DESCRIBE `cruisetypes` 0.0010390281677246
(615) DESCRIBE `destinations` 0.0010590553283691
(616) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '28', '26', '55', '11', '21', '38', '40', '49', '7', '44', '48', '30', '29', '10', '56', '45', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,28,26,55,11,21,38,40,49,7,44,48,30,29,10,56,45,34,52,46,32') 0.001129150390625