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

Total elapsed time: 0.35904002189636

# Query Time
(1) connect 0.00065708160400391
(2) DESCRIBE `cruises` 0.0023279190063477
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66955, 66996, 66997, 60589, 66998, 74236, 74237, 67256, 74238, 74239)) ORDER BY FIND_IN_SET(id, '66955,66996,66997,60589,66998,74236,74237,67256,74238,74239') 0.0015029907226562
(4) DESCRIBE `cruises` 0.0016939640045166
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.00026488304138184
(6) DESCRIBE `ships` 0.0012691020965576
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026988983154297
(8) DESCRIBE `ships` 0.0016071796417236
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00021600723266602
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(12) DESCRIBE `itineraries` 0.00071406364440918
(13) DESCRIBE `ports` 0.00068998336791992
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025606155395508
(15) DESCRIBE `ports` 0.00079703330993652
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024104118347168
(17) DESCRIBE `ports` 0.0007779598236084
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018906593322754
(19) DESCRIBE `sailingdates` 0.00060105323791504
(20) DESCRIBE `ports` 0.00067710876464844
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020408630371094
(22) DESCRIBE `ports` 0.00065779685974121
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018215179443359
(24) DESCRIBE `ports` 0.00083494186401367
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00024199485778809
(26) DESCRIBE `ports` 0.00076603889465332
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018405914306641
(28) DESCRIBE `ports` 0.00065517425537109
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020194053649902
(30) DESCRIBE `ports` 0.00065207481384277
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018191337585449
(32) DESCRIBE `ports` 0.00065803527832031
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0001978874206543
(34) DESCRIBE `ports` 0.000701904296875
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0002129077911377
(36) DESCRIBE `ports` 0.00076198577880859
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022602081298828
(38) DESCRIBE `ports` 0.00072193145751953
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0002129077911377
(40) DESCRIBE `ports` 0.00079584121704102
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00026106834411621
(42) DESCRIBE `ports` 0.00093317031860352
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00023698806762695
(44) DESCRIBE `ports` 0.00089502334594727
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026297569274902
(46) DESCRIBE `ports` 0.0010120868682861
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00024604797363281
(48) DESCRIBE `avid_specials` 0.00085806846618652
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66955 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017359256744385
(50) DESCRIBE `cruiselines` 0.0013918876647949
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030779838562012
(52) DESCRIBE `orchid_image` 0.0011279582977295
(53) DESCRIBE `cruiselines` 0.0015108585357666
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00029587745666504
(55) DESCRIBE `cruises` 0.0018892288208008
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00031900405883789
(57) DESCRIBE `ships` 0.0018677711486816
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00035190582275391
(59) DESCRIBE `ships` 0.0018339157104492
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.0002598762512207
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023198127746582
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022196769714355
(63) DESCRIBE `itineraries` 0.00096392631530762
(64) DESCRIBE `ports` 0.00096321105957031
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028705596923828
(66) DESCRIBE `ports` 0.00095105171203613
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00035810470581055
(68) DESCRIBE `ports` 0.00094890594482422
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028300285339355
(70) DESCRIBE `sailingdates` 0.00085616111755371
(71) DESCRIBE `ports` 0.0010688304901123
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030899047851562
(73) DESCRIBE `ports` 0.0009758472442627
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00024914741516113
(75) DESCRIBE `ports` 0.00094413757324219
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00028300285339355
(77) DESCRIBE `ports` 0.00093793869018555
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00023913383483887
(79) DESCRIBE `ports` 0.00092387199401855
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0002739429473877
(81) DESCRIBE `ports` 0.0009160041809082
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00025081634521484
(83) DESCRIBE `ports` 0.0010321140289307
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00027894973754883
(85) DESCRIBE `ports` 0.00098490715026855
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018620491027832
(87) DESCRIBE `ports` 0.00066494941711426
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00021004676818848
(89) DESCRIBE `ports` 0.0006568431854248
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00018501281738281
(91) DESCRIBE `ports` 0.00065779685974121
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020194053649902
(93) DESCRIBE `ports` 0.00065898895263672
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018405914306641
(95) DESCRIBE `ports` 0.00066304206848145
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021886825561523
(97) DESCRIBE `ports` 0.00069093704223633
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018215179443359
(99) DESCRIBE `avid_specials` 0.0006248950958252
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66996 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013191699981689
(101) DESCRIBE `cruiselines` 0.00099992752075195
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024104118347168
(103) DESCRIBE `orchid_image` 0.00075197219848633
(104) DESCRIBE `cruiselines` 0.00094199180603027
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00022101402282715
(106) DESCRIBE `cruises` 0.0012731552124023
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66997') 0.00023913383483887
(108) DESCRIBE `ships` 0.0013179779052734
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026988983154297
(110) DESCRIBE `ships` 0.001615047454834
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00020503997802734
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(114) DESCRIBE `itineraries` 0.00066494941711426
(115) DESCRIBE `ports` 0.00066804885864258
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023698806762695
(117) DESCRIBE `ports` 0.0007021427154541
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028705596923828
(119) DESCRIBE `ports` 0.00065398216247559
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018715858459473
(121) DESCRIBE `sailingdates` 0.00063419342041016
(122) DESCRIBE `ports` 0.00068402290344238
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021100044250488
(124) DESCRIBE `ports` 0.00069594383239746
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018501281738281
(126) DESCRIBE `ports` 0.0007469654083252
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020503997802734
(128) DESCRIBE `ports` 0.00067806243896484
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0001981258392334
(130) DESCRIBE `ports` 0.00065112113952637
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020885467529297
(132) DESCRIBE `ports` 0.00065398216247559
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018405914306641
(134) DESCRIBE `ports` 0.0006871223449707
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00024700164794922
(136) DESCRIBE `ports` 0.00082111358642578
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00018715858459473
(138) DESCRIBE `ports` 0.00066494941711426
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020384788513184
(140) DESCRIBE `ports` 0.00071501731872559
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018715858459473
(142) DESCRIBE `ports` 0.000701904296875
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00025081634521484
(144) DESCRIBE `ports` 0.00075006484985352
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00022196769714355
(146) DESCRIBE `ports` 0.00071310997009277
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00021505355834961
(148) DESCRIBE `ports` 0.00069308280944824
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00024795532226562
(150) DESCRIBE `ports` 0.00076603889465332
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002288818359375
(152) DESCRIBE `ports` 0.00070381164550781
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018882751464844
(154) DESCRIBE `avid_specials` 0.00069713592529297
(155) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66997 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010049343109131
(156) DESCRIBE `cruiselines` 0.0014050006866455
(157) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00026082992553711
(158) DESCRIBE `orchid_image` 0.00085783004760742
(159) DESCRIBE `cruiselines` 0.00099802017211914
(160) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00024580955505371
(161) DESCRIBE `cruises` 0.0012938976287842
(162) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60589') 0.00024199485778809
(163) DESCRIBE `ships` 0.0012991428375244
(164) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00029802322387695
(165) DESCRIBE `ships` 0.0012710094451904
(166) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00021600723266602
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(169) DESCRIBE `itineraries` 0.0006709098815918
(170) DESCRIBE `ports` 0.0008540153503418
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024700164794922
(172) DESCRIBE `ports` 0.00067305564880371
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019407272338867
(174) DESCRIBE `ports` 0.00069713592529297
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018501281738281
(176) DESCRIBE `sailingdates` 0.00060701370239258
(177) DESCRIBE `ports` 0.00065207481384277
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020503997802734
(179) DESCRIBE `ports` 0.00073409080505371
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018811225891113
(181) DESCRIBE `ports` 0.00065183639526367
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00022506713867188
(183) DESCRIBE `ports` 0.00074601173400879
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017690658569336
(185) DESCRIBE `ports` 0.00068807601928711
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00022006034851074
(187) DESCRIBE `ports` 0.00065422058105469
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00020003318786621
(189) DESCRIBE `ports` 0.00064992904663086
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00019693374633789
(191) DESCRIBE `ports` 0.0006868839263916
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00017714500427246
(193) DESCRIBE `ports` 0.00069403648376465
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1106))) 0.00021004676818848
(195) DESCRIBE `ports` 0.00065493583679199
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1106') 0.00018000602722168
(197) DESCRIBE `ports` 0.00070095062255859
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020503997802734
(199) DESCRIBE `ports` 0.00071597099304199
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018811225891113
(201) DESCRIBE `avid_specials` 0.00060415267944336
(202) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60589 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00095200538635254
(203) DESCRIBE `cruiselines` 0.00095391273498535
(204) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022006034851074
(205) DESCRIBE `orchid_image` 0.00077605247497559
(206) DESCRIBE `cruiselines` 0.00093483924865723
(207) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020313262939453
(208) DESCRIBE `cruises` 0.0013589859008789
(209) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66998') 0.00022387504577637
(210) DESCRIBE `ships` 0.0013039112091064
(211) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00029397010803223
(212) DESCRIBE `ships` 0.001209020614624
(213) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018405914306641
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(216) DESCRIBE `itineraries` 0.00082087516784668
(217) DESCRIBE `ports` 0.00067591667175293
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021195411682129
(219) DESCRIBE `ports` 0.00068998336791992
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019693374633789
(221) DESCRIBE `ports` 0.00067806243896484
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002288818359375
(223) DESCRIBE `sailingdates` 0.00078797340393066
(224) DESCRIBE `ports` 0.00084805488586426
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021815299987793
(226) DESCRIBE `ports` 0.00065898895263672
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018715858459473
(228) DESCRIBE `ports` 0.00077486038208008
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020313262939453
(230) DESCRIBE `ports` 0.00064897537231445
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017499923706055
(232) DESCRIBE `ports` 0.00064682960510254
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021100044250488
(234) DESCRIBE `ports` 0.00067996978759766
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017619132995605
(236) DESCRIBE `ports` 0.00064516067504883
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020098686218262
(238) DESCRIBE `ports` 0.00071287155151367
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017499923706055
(240) DESCRIBE `ports` 0.00065493583679199
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019383430480957
(242) DESCRIBE `ports` 0.00069689750671387
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017905235290527
(244) DESCRIBE `ports` 0.00064516067504883
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020503997802734
(246) DESCRIBE `ports` 0.00067996978759766
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00019097328186035
(248) DESCRIBE `ports` 0.00067996978759766
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020098686218262
(250) DESCRIBE `ports` 0.00064706802368164
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017690658569336
(252) DESCRIBE `avid_specials` 0.00059390068054199
(253) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66998 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00094795227050781
(254) DESCRIBE `cruiselines` 0.0011160373687744
(255) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00027108192443848
(256) DESCRIBE `orchid_image` 0.00083494186401367
(257) DESCRIBE `cruiselines` 0.0009617805480957
(258) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019192695617676
(259) DESCRIBE `cruises` 0.0012540817260742
(260) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74236') 0.00024104118347168
(261) DESCRIBE `ships` 0.0013489723205566
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00032997131347656
(263) DESCRIBE `ships` 0.0016720294952393
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00020194053649902
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(267) DESCRIBE `itineraries` 0.00068497657775879
(268) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74236') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0027480125427246
(269) DESCRIBE `ports` 0.00086688995361328
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00025081634521484
(271) DESCRIBE `ports` 0.00067496299743652
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021600723266602
(273) DESCRIBE `ports` 0.00068187713623047
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00020503997802734
(275) DESCRIBE `sailingdates` 0.00064802169799805
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74236') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00083279609680176
(277) DESCRIBE `ports` 0.00090384483337402
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00026798248291016
(279) DESCRIBE `ports` 0.00088906288146973
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019097328186035
(281) DESCRIBE `ports` 0.00069403648376465
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020289421081543
(283) DESCRIBE `ports` 0.0007929801940918
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00026392936706543
(285) DESCRIBE `ports` 0.00096511840820312
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00027704238891602
(287) DESCRIBE `ports` 0.00094294548034668
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00045490264892578
(289) DESCRIBE `ports` 0.0010139942169189
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021696090698242
(291) DESCRIBE `ports` 0.0006718635559082
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018692016601562
(293) DESCRIBE `ports` 0.00075793266296387
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00022792816162109
(295) DESCRIBE `ports` 0.00066208839416504
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018215179443359
(297) DESCRIBE `ports` 0.00064611434936523
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001978874206543
(299) DESCRIBE `ports` 0.00074195861816406
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00019502639770508
(301) DESCRIBE `ports` 0.00071597099304199
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00026202201843262
(303) DESCRIBE `ports` 0.00088095664978027
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00022292137145996
(305) DESCRIBE `ports` 0.00095200538635254
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00028395652770996
(307) DESCRIBE `ports` 0.00085997581481934
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00020694732666016
(309) DESCRIBE `ports` 0.00088787078857422
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00023412704467773
(311) DESCRIBE `ports` 0.00074005126953125
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00017905235290527
(313) DESCRIBE `ports` 0.00066399574279785
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020599365234375
(315) DESCRIBE `ports` 0.00064611434936523
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017595291137695
(317) DESCRIBE `ports` 0.00065302848815918
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019502639770508
(319) DESCRIBE `ports` 0.00064921379089355
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017714500427246
(321) DESCRIBE `ports` 0.00065398216247559
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002138614654541
(323) DESCRIBE `ports` 0.00065708160400391
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018906593322754
(325) DESCRIBE `avid_specials` 0.00060009956359863
(326) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74236 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00098109245300293
(327) DESCRIBE `cruiselines` 0.00096392631530762
(328) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023102760314941
(329) DESCRIBE `orchid_image` 0.00073099136352539
(330) DESCRIBE `cruiselines` 0.0011138916015625
(331) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019693374633789
(332) DESCRIBE `cruises` 0.0012879371643066
(333) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74237') 0.00021600723266602
(334) DESCRIBE `ships` 0.0012381076812744
(335) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00025606155395508
(336) DESCRIBE `ships` 0.0012469291687012
(337) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.0001828670501709
(338) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(339) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(340) DESCRIBE `itineraries` 0.00064301490783691
(341) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74237') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041985511779785
(342) DESCRIBE `ports` 0.00070095062255859
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002129077911377
(344) DESCRIBE `ports` 0.00066804885864258
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019192695617676
(346) DESCRIBE `ports` 0.00065112113952637
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018811225891113
(348) DESCRIBE `sailingdates` 0.00059103965759277
(349) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74237') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00032806396484375
(350) DESCRIBE `ports` 0.00069594383239746
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020408630371094
(352) DESCRIBE `ports` 0.00065398216247559
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018596649169922
(354) DESCRIBE `ports` 0.00070905685424805
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020885467529297
(356) DESCRIBE `ports` 0.00068402290344238
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018906593322754
(358) DESCRIBE `ports` 0.00065493583679199
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0002288818359375
(360) DESCRIBE `ports` 0.00065922737121582
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018715858459473
(362) DESCRIBE `ports` 0.00066709518432617
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0002140998840332
(364) DESCRIBE `ports` 0.00067400932312012
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017595291137695
(366) DESCRIBE `ports` 0.00070905685424805
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020813941955566
(368) DESCRIBE `ports` 0.0006561279296875
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017714500427246
(370) DESCRIBE `ports` 0.00067901611328125
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00021219253540039
(372) DESCRIBE `ports` 0.00065803527832031
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00017595291137695
(374) DESCRIBE `ports` 0.00067019462585449
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0002138614654541
(376) DESCRIBE `ports` 0.00066900253295898
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00018811225891113
(378) DESCRIBE `ports` 0.00065398216247559
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00019383430480957
(380) DESCRIBE `ports` 0.00066804885864258
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00017499923706055
(382) DESCRIBE `ports` 0.0006871223449707
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0001988410949707
(384) DESCRIBE `ports` 0.00066113471984863
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017714500427246
(386) DESCRIBE `ports` 0.0006709098815918
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021100044250488
(388) DESCRIBE `ports` 0.00066590309143066
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017595291137695
(390) DESCRIBE `avid_specials` 0.0005948543548584
(391) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74237 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009770393371582
(392) DESCRIBE `cruiselines` 0.00098514556884766
(393) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00042510032653809
(394) DESCRIBE `orchid_image` 0.0010089874267578
(395) DESCRIBE `cruiselines` 0.0010139942169189
(396) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018692016601562
(397) DESCRIBE `cruises` 0.0014240741729736
(398) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67256') 0.00021004676818848
(399) DESCRIBE `ships` 0.0012860298156738
(400) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026512145996094
(401) DESCRIBE `ships` 0.0012948513031006
(402) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018501281738281
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(404) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(405) DESCRIBE `itineraries` 0.00065398216247559
(406) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67256') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090503692626953
(407) DESCRIBE `ports` 0.00076413154602051
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(409) DESCRIBE `ports` 0.00066900253295898
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019288063049316
(411) DESCRIBE `ports` 0.00068902969360352
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018095970153809
(413) DESCRIBE `sailingdates` 0.00060415267944336
(414) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67256') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052905082702637
(415) DESCRIBE `ports` 0.00073099136352539
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021696090698242
(417) DESCRIBE `ports` 0.00071001052856445
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018596649169922
(419) DESCRIBE `ports` 0.0007021427154541
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021791458129883
(421) DESCRIBE `ports` 0.00067496299743652
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018501281738281
(423) DESCRIBE `ports` 0.00067400932312012
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020384788513184
(425) DESCRIBE `ports` 0.00065994262695312
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00017380714416504
(427) DESCRIBE `ports` 0.00066804885864258
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019407272338867
(429) DESCRIBE `ports` 0.00066399574279785
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017499923706055
(431) DESCRIBE `ports` 0.00066804885864258
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020408630371094
(433) DESCRIBE `ports` 0.00068902969360352
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00021910667419434
(435) DESCRIBE `ports` 0.00069999694824219
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.0001990795135498
(437) DESCRIBE `ports` 0.00068402290344238
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00022101402282715
(439) DESCRIBE `ports` 0.00094103813171387
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00026512145996094
(441) DESCRIBE `ports` 0.0010209083557129
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00025081634521484
(443) DESCRIBE `ports` 0.00096797943115234
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025486946105957
(445) DESCRIBE `ports` 0.00072216987609863
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019407272338867
(447) DESCRIBE `avid_specials` 0.00062203407287598
(448) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67256 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00095891952514648
(449) DESCRIBE `cruiselines` 0.0010030269622803
(450) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021100044250488
(451) DESCRIBE `orchid_image` 0.00077104568481445
(452) DESCRIBE `cruiselines` 0.00091814994812012
(453) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017905235290527
(454) DESCRIBE `cruises` 0.0012509822845459
(455) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74238') 0.00020289421081543
(456) DESCRIBE `ships` 0.0012710094451904
(457) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00024700164794922
(458) DESCRIBE `ships` 0.0015709400177002
(459) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00021886825561523
(460) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(461) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(462) DESCRIBE `itineraries` 0.00066614151000977
(463) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74238') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00039291381835938
(464) DESCRIBE `ports` 0.00074887275695801
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(466) DESCRIBE `ports` 0.00066685676574707
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0001978874206543
(468) DESCRIBE `ports` 0.00066399574279785
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021505355834961
(470) DESCRIBE `sailingdates` 0.00072503089904785
(471) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74238') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00033998489379883
(472) DESCRIBE `ports` 0.00074982643127441
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021505355834961
(474) DESCRIBE `ports` 0.00065898895263672
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018692016601562
(476) DESCRIBE `ports` 0.0006709098815918
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00021505355834961
(478) DESCRIBE `ports` 0.00065994262695312
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00017499923706055
(480) DESCRIBE `ports` 0.0006568431854248
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019502639770508
(482) DESCRIBE `ports` 0.00069093704223633
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017499923706055
(484) DESCRIBE `ports` 0.00065493583679199
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00019097328186035
(486) DESCRIBE `ports` 0.00065493583679199
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018787384033203
(488) DESCRIBE `ports` 0.0006718635559082
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020599365234375
(490) DESCRIBE `ports` 0.0006561279296875
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018405914306641
(492) DESCRIBE `ports` 0.00067996978759766
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019407272338867
(494) DESCRIBE `ports` 0.0006568431854248
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017595291137695
(496) DESCRIBE `ports` 0.00065803527832031
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.0001978874206543
(498) DESCRIBE `ports` 0.00067901611328125
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00018811225891113
(500) DESCRIBE `ports` 0.00073099136352539
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00021719932556152
(502) DESCRIBE `ports` 0.00066399574279785
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00017595291137695
(504) DESCRIBE `ports` 0.00065803527832031
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00019621849060059
(506) DESCRIBE `ports` 0.00069618225097656
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00017619132995605
(508) DESCRIBE `ports` 0.00065994262695312
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020694732666016
(510) DESCRIBE `ports` 0.00071001052856445
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017595291137695
(512) DESCRIBE `ports` 0.00067591667175293
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019216537475586
(514) DESCRIBE `ports` 0.00067901611328125
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017380714416504
(516) DESCRIBE `ports` 0.00078582763671875
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022387504577637
(518) DESCRIBE `ports` 0.00067615509033203
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017809867858887
(520) DESCRIBE `avid_specials` 0.00060796737670898
(521) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74238 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010201930999756
(522) DESCRIBE `cruiselines` 0.0010108947753906
(523) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023102760314941
(524) DESCRIBE `orchid_image` 0.00086712837219238
(525) DESCRIBE `cruiselines` 0.00090479850769043
(526) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018501281738281
(527) DESCRIBE `cruises` 0.0013120174407959
(528) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74239') 0.00021195411682129
(529) DESCRIBE `ships` 0.0012669563293457
(530) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00027894973754883
(531) DESCRIBE `ships` 0.0012679100036621
(532) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018215179443359
(533) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(534) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(535) DESCRIBE `itineraries` 0.0006871223449707
(536) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74239') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00034880638122559
(537) DESCRIBE `ports` 0.0008699893951416
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024199485778809
(539) DESCRIBE `ports` 0.00066804885864258
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019311904907227
(541) DESCRIBE `ports` 0.00066709518432617
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017595291137695
(543) DESCRIBE `sailingdates` 0.00060796737670898
(544) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74239') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00031805038452148
(545) DESCRIBE `ports` 0.00075197219848633
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020098686218262
(547) DESCRIBE `ports` 0.00069284439086914
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018119812011719
(549) DESCRIBE `ports` 0.00066614151000977
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019192695617676
(551) DESCRIBE `ports` 0.00069403648376465
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017499923706055
(553) DESCRIBE `ports` 0.00067996978759766
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0001981258392334
(555) DESCRIBE `ports` 0.00065803527832031
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00017404556274414
(557) DESCRIBE `ports` 0.0006561279296875
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020217895507812
(559) DESCRIBE `ports` 0.00071096420288086
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017499923706055
(561) DESCRIBE `ports` 0.00065493583679199
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00019502639770508
(563) DESCRIBE `ports` 0.00071096420288086
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00017499923706055
(565) DESCRIBE `ports` 0.00066804885864258
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001978874206543
(567) DESCRIBE `ports` 0.00065898895263672
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018596649169922
(569) DESCRIBE `ports` 0.00065302848815918
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019192695617676
(571) DESCRIBE `ports` 0.00065994262695312
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018095970153809
(573) DESCRIBE `ports` 0.00066804885864258
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020503997802734
(575) DESCRIBE `ports` 0.00065708160400391
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00020480155944824
(577) DESCRIBE `ports` 0.00066399574279785
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00021982192993164
(579) DESCRIBE `ports` 0.0006558895111084
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00017404556274414
(581) DESCRIBE `ports` 0.00076580047607422
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020503997802734
(583) DESCRIBE `ports` 0.00078082084655762
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017595291137695
(585) DESCRIBE `ports` 0.00074505805969238
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0001978874206543
(587) DESCRIBE `ports` 0.00070285797119141
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017285346984863
(589) DESCRIBE `avid_specials` 0.00072002410888672
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74239 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00096487998962402
(591) DESCRIBE `cruiselines` 0.0010929107666016
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022292137145996
(593) DESCRIBE `orchid_image` 0.00075697898864746
(594) DESCRIBE `cruiselines` 0.00094795227050781
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017499923706055
(596) DESCRIBE `cruisetypes` 0.00065183639526367
(597) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '22') AND (cruises_and_specials.cruiseline_id = '20') AND (cruises_and_specials.ship_id = '93') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.02783203125
(598) DESCRIBE `cruiselines` 0.0013580322265625
(599) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00026988983154297
(600) DESCRIBE `ships` 0.0016298294067383
(601) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026106834411621
(602) DESCRIBE `destinations` 0.00091004371643066
(603) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00021982192993164
(604) DESCRIBE `destinations` 0.0008549690246582
(605) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00019979476928711
(606) DESCRIBE `cruiselines` 0.00093793869018555
(607) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020599365234375
(608) DESCRIBE `ships` 0.0012469291687012
(609) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00023698806762695