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

Total elapsed time: 0.36946272850037

# Query Time
(1) connect 0.00063180923461914
(2) DESCRIBE `cruises` 0.0017580986022949
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66955, 66996, 66997, 60589, 66998, 66999, 66001, 38689, 25176, 38690)) ORDER BY FIND_IN_SET(id, '66955,66996,66997,60589,66998,66999,66001,38689,25176,38690') 0.00095582008361816
(4) DESCRIBE `cruises` 0.002140998840332
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.00033903121948242
(6) DESCRIBE `ships` 0.002140998840332
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00039982795715332
(8) DESCRIBE `ships` 0.0022149085998535
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00029611587524414
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023293495178223
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021791458129883
(12) DESCRIBE `itineraries` 0.0011429786682129
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66955') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012979507446289
(14) DESCRIBE `ports` 0.0012638568878174
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034117698669434
(16) DESCRIBE `ports` 0.0010199546813965
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028014183044434
(18) DESCRIBE `ports` 0.00089001655578613
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00025606155395508
(20) DESCRIBE `sailingdates` 0.00088906288146973
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66955') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012609958648682
(22) DESCRIBE `ports` 0.0011279582977295
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034904479980469
(24) DESCRIBE `ports` 0.001039981842041
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027203559875488
(26) DESCRIBE `ports` 0.0010240077972412
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00028491020202637
(28) DESCRIBE `ports` 0.0010101795196533
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00024700164794922
(30) DESCRIBE `ports` 0.00072717666625977
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00024294853210449
(32) DESCRIBE `ports` 0.00095891952514648
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00023484230041504
(34) DESCRIBE `ports` 0.00091695785522461
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00024509429931641
(36) DESCRIBE `ports` 0.00082612037658691
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00020599365234375
(38) DESCRIBE `ports` 0.00067806243896484
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021600723266602
(40) DESCRIBE `ports` 0.00066590309143066
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018715858459473
(42) DESCRIBE `ports` 0.00070595741271973
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0002448558807373
(44) DESCRIBE `ports` 0.00095200538635254
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00019097328186035
(46) DESCRIBE `ports` 0.00067400932312012
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002140998840332
(48) DESCRIBE `ports` 0.00067400932312012
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018715858459473
(50) DESCRIBE `avid_specials` 0.00069808959960938
(51) 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.0010290145874023
(52) DESCRIBE `cruiselines` 0.0011460781097412
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024914741516113
(54) DESCRIBE `orchid_image` 0.00081110000610352
(55) DESCRIBE `cruiselines` 0.00092697143554688
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020313262939453
(57) DESCRIBE `cruises` 0.001288890838623
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00023198127746582
(59) DESCRIBE `ships` 0.0012891292572021
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.0002601146697998
(61) DESCRIBE `ships` 0.0012729167938232
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00019097328186035
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021600723266602
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(65) DESCRIBE `itineraries` 0.00067710876464844
(66) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66996') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053691864013672
(67) DESCRIBE `ports` 0.00074505805969238
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023102760314941
(69) DESCRIBE `ports` 0.00068116188049316
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0001981258392334
(71) DESCRIBE `ports` 0.00067305564880371
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021100044250488
(73) DESCRIBE `sailingdates` 0.00060701370239258
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66996') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0004279613494873
(75) DESCRIBE `ports` 0.00095200538635254
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021100044250488
(77) DESCRIBE `ports` 0.00087904930114746
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018310546875
(79) DESCRIBE `ports` 0.00067377090454102
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020813941955566
(81) DESCRIBE `ports` 0.00069284439086914
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018000602722168
(83) DESCRIBE `ports` 0.00070905685424805
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020003318786621
(85) DESCRIBE `ports` 0.0007328987121582
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018000602722168
(87) DESCRIBE `ports` 0.00080013275146484
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020503997802734
(89) DESCRIBE `ports` 0.00066804885864258
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018119812011719
(91) DESCRIBE `ports` 0.00088596343994141
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020599365234375
(93) DESCRIBE `ports` 0.00069093704223633
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00018501281738281
(95) DESCRIBE `ports` 0.00066804885864258
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0001990795135498
(97) DESCRIBE `ports` 0.00070905685424805
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018095970153809
(99) DESCRIBE `ports` 0.0006709098815918
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025606155395508
(101) DESCRIBE `ports` 0.00070500373840332
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021004676818848
(103) DESCRIBE `avid_specials` 0.00066900253295898
(104) 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.00094485282897949
(105) DESCRIBE `cruiselines` 0.01325511932373
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00039887428283691
(107) DESCRIBE `orchid_image` 0.0011029243469238
(108) DESCRIBE `cruiselines` 0.0010030269622803
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020098686218262
(110) DESCRIBE `cruises` 0.0013589859008789
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66997') 0.00044918060302734
(112) DESCRIBE `ships` 0.0013010501861572
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026392936706543
(114) DESCRIBE `ships` 0.0012998580932617
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00019288063049316
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020909309387207
(118) DESCRIBE `itineraries` 0.00088191032409668
(119) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66997') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051712989807129
(120) DESCRIBE `ports` 0.0007479190826416
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022482872009277
(122) DESCRIBE `ports` 0.0007328987121582
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020480155944824
(124) DESCRIBE `ports` 0.0006709098815918
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019097328186035
(126) DESCRIBE `sailingdates` 0.0006110668182373
(127) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66997') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00035595893859863
(128) DESCRIBE `ports` 0.001115083694458
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00039100646972656
(130) DESCRIBE `ports` 0.000762939453125
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020909309387207
(132) DESCRIBE `ports` 0.00090718269348145
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00029897689819336
(134) DESCRIBE `ports` 0.00098896026611328
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00020790100097656
(136) DESCRIBE `ports` 0.00088310241699219
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00024199485778809
(138) DESCRIBE `ports` 0.00072908401489258
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00019478797912598
(140) DESCRIBE `ports` 0.0006709098815918
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00020098686218262
(142) DESCRIBE `ports` 0.00073099136352539
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00018787384033203
(144) DESCRIBE `ports` 0.00066518783569336
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019979476928711
(146) DESCRIBE `ports` 0.00069093704223633
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018405914306641
(148) DESCRIBE `ports` 0.00066804885864258
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019407272338867
(150) DESCRIBE `ports` 0.00066709518432617
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018501281738281
(152) DESCRIBE `ports` 0.00085902214050293
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00020003318786621
(154) DESCRIBE `ports` 0.00066494941711426
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00017714500427246
(156) DESCRIBE `ports` 0.00066494941711426
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021195411682129
(158) DESCRIBE `ports` 0.00066494941711426
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017499923706055
(160) DESCRIBE `avid_specials` 0.00060105323791504
(161) 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.00094699859619141
(162) DESCRIBE `cruiselines` 0.00098490715026855
(163) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021505355834961
(164) DESCRIBE `orchid_image` 0.00082087516784668
(165) DESCRIBE `cruiselines` 0.0010471343994141
(166) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019216537475586
(167) DESCRIBE `cruises` 0.0012891292572021
(168) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60589') 0.0003969669342041
(169) DESCRIBE `ships` 0.0019290447235107
(170) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00044012069702148
(171) DESCRIBE `ships` 0.0019168853759766
(172) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00020122528076172
(173) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016689300537109
(175) DESCRIBE `itineraries` 0.00073695182800293
(176) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60589') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00088882446289062
(177) DESCRIBE `ports` 0.0010581016540527
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024104118347168
(179) DESCRIBE `ports` 0.0006859302520752
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023698806762695
(181) DESCRIBE `ports` 0.00072598457336426
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019717216491699
(183) DESCRIBE `sailingdates` 0.00060296058654785
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60589') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063109397888184
(185) DESCRIBE `ports` 0.00069594383239746
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023508071899414
(187) DESCRIBE `ports` 0.00077700614929199
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00023484230041504
(189) DESCRIBE `ports` 0.00078606605529785
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020599365234375
(191) DESCRIBE `ports` 0.00067996978759766
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018405914306641
(193) DESCRIBE `ports` 0.0006711483001709
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0002138614654541
(195) DESCRIBE `ports` 0.00073599815368652
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0002288818359375
(197) DESCRIBE `ports` 0.00080299377441406
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020122528076172
(199) DESCRIBE `ports` 0.00067710876464844
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00026416778564453
(201) DESCRIBE `ports` 0.00093984603881836
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1106))) 0.00037789344787598
(203) DESCRIBE `ports` 0.00084710121154785
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1106') 0.00031495094299316
(205) DESCRIBE `ports` 0.0011429786682129
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028204917907715
(207) DESCRIBE `ports` 0.00089311599731445
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027918815612793
(209) DESCRIBE `avid_specials` 0.00086593627929688
(210) 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.0014870166778564
(211) DESCRIBE `cruiselines` 0.0015130043029785
(212) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022292137145996
(213) DESCRIBE `orchid_image` 0.00077009201049805
(214) DESCRIBE `cruiselines` 0.0013899803161621
(215) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00023508071899414
(216) DESCRIBE `cruises` 0.0019190311431885
(217) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66998') 0.00027298927307129
(218) DESCRIBE `ships` 0.0014541149139404
(219) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026106834411621
(220) DESCRIBE `ships` 0.0013260841369629
(221) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018906593322754
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(224) DESCRIBE `itineraries` 0.00082707405090332
(225) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66998') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045394897460938
(226) DESCRIBE `ports` 0.00072884559631348
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027608871459961
(228) DESCRIBE `ports` 0.00077700614929199
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002439022064209
(230) DESCRIBE `ports` 0.00069999694824219
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019598007202148
(232) DESCRIBE `sailingdates` 0.00066900253295898
(233) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66998') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036287307739258
(234) DESCRIBE `ports` 0.00080585479736328
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025701522827148
(236) DESCRIBE `ports` 0.00081300735473633
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00022101402282715
(238) DESCRIBE `ports` 0.00076913833618164
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020718574523926
(240) DESCRIBE `ports` 0.00068998336791992
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018501281738281
(242) DESCRIBE `ports` 0.00068807601928711
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020503997802734
(244) DESCRIBE `ports` 0.00068020820617676
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00021195411682129
(246) DESCRIBE `ports` 0.00068092346191406
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020503997802734
(248) DESCRIBE `ports` 0.00067782402038574
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018215179443359
(250) DESCRIBE `ports` 0.00066900253295898
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001990795135498
(252) DESCRIBE `ports` 0.00067996978759766
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018692016601562
(254) DESCRIBE `ports` 0.00067806243896484
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020003318786621
(256) DESCRIBE `ports` 0.00070500373840332
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018095970153809
(258) DESCRIBE `ports` 0.00067400932312012
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021696090698242
(260) DESCRIBE `ports` 0.00068187713623047
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020194053649902
(262) DESCRIBE `avid_specials` 0.00062108039855957
(263) 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.00094509124755859
(264) DESCRIBE `cruiselines` 0.0010161399841309
(265) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022292137145996
(266) DESCRIBE `orchid_image` 0.00078296661376953
(267) DESCRIBE `cruiselines` 0.00094819068908691
(268) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019097328186035
(269) DESCRIBE `cruises` 0.0012989044189453
(270) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66999') 0.00023007392883301
(271) DESCRIBE `ships` 0.0012741088867188
(272) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00030994415283203
(273) DESCRIBE `ships` 0.0016870498657227
(274) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00020003318786621
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023388862609863
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(277) DESCRIBE `itineraries` 0.00085902214050293
(278) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66999') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00036907196044922
(279) DESCRIBE `ports` 0.0007319450378418
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021696090698242
(281) DESCRIBE `ports` 0.00089907646179199
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020694732666016
(283) DESCRIBE `ports` 0.00067400932312012
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001828670501709
(285) DESCRIBE `sailingdates` 0.00077700614929199
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66999') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00034999847412109
(287) DESCRIBE `ports` 0.00070691108703613
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020503997802734
(289) DESCRIBE `ports` 0.00068402290344238
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018596649169922
(291) DESCRIBE `ports` 0.00067591667175293
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020384788513184
(293) DESCRIBE `ports` 0.00088310241699219
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018692016601562
(295) DESCRIBE `ports` 0.00067591667175293
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020885467529297
(297) DESCRIBE `ports` 0.00067806243896484
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018501281738281
(299) DESCRIBE `ports` 0.00071215629577637
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00020694732666016
(301) DESCRIBE `ports` 0.00067877769470215
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00018405914306641
(303) DESCRIBE `ports` 0.00066804885864258
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00024294853210449
(305) DESCRIBE `ports` 0.00067400932312012
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00018215179443359
(307) DESCRIBE `ports` 0.00066804885864258
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020885467529297
(309) DESCRIBE `ports` 0.00083303451538086
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00024604797363281
(311) DESCRIBE `avid_specials` 0.00086498260498047
(312) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66999 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 38 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.0012738704681396
(313) DESCRIBE `cruiselines` 0.0010859966278076
(314) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030422210693359
(315) DESCRIBE `orchid_image` 0.0011458396911621
(316) DESCRIBE `cruiselines` 0.00093483924865723
(317) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00025606155395508
(318) DESCRIBE `cruises` 0.0013999938964844
(319) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66001') 0.00036382675170898
(320) DESCRIBE `ships` 0.0021059513092041
(321) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00039005279541016
(322) DESCRIBE `ships` 0.0020489692687988
(323) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00023698806762695
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018215179443359
(326) DESCRIBE `itineraries` 0.00099396705627441
(327) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66001') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00086808204650879
(328) DESCRIBE `ports` 0.00071907043457031
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024509429931641
(330) DESCRIBE `ports` 0.00073480606079102
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002140998840332
(332) DESCRIBE `ports` 0.00068306922912598
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019001960754395
(334) DESCRIBE `sailingdates` 0.00061416625976562
(335) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66001') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040292739868164
(336) DESCRIBE `ports` 0.00069689750671387
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020503997802734
(338) DESCRIBE `ports` 0.00072216987609863
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019216537475586
(340) DESCRIBE `ports` 0.00069713592529297
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.0002899169921875
(342) DESCRIBE `ports` 0.00099802017211914
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00024604797363281
(344) DESCRIBE `ports` 0.0006859302520752
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00022697448730469
(346) DESCRIBE `ports` 0.00069689750671387
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00018692016601562
(348) DESCRIBE `ports` 0.00067496299743652
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00020503997802734
(350) DESCRIBE `ports` 0.00069594383239746
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00018620491027832
(352) DESCRIBE `ports` 0.00067806243896484
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020503997802734
(354) DESCRIBE `ports` 0.00067305564880371
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0001838207244873
(356) DESCRIBE `ports` 0.00072693824768066
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00021195411682129
(358) DESCRIBE `ports` 0.00067782402038574
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00018501281738281
(360) DESCRIBE `ports` 0.00067615509033203
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023102760314941
(362) DESCRIBE `ports` 0.00068807601928711
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018715858459473
(364) DESCRIBE `avid_specials` 0.00061202049255371
(365) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66001 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0010221004486084
(366) DESCRIBE `cruiselines` 0.00099897384643555
(367) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00028514862060547
(368) DESCRIBE `orchid_image` 0.00084996223449707
(369) DESCRIBE `cruiselines` 0.00098896026611328
(370) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020909309387207
(371) DESCRIBE `cruises` 0.0013999938964844
(372) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38689') 0.00023007392883301
(373) DESCRIBE `ships` 0.0014820098876953
(374) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00027990341186523
(375) DESCRIBE `ships` 0.001284122467041
(376) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00019311904907227
(377) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018906593322754
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(379) DESCRIBE `itineraries` 0.00077486038208008
(380) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '38689') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081086158752441
(381) DESCRIBE `ports` 0.00073409080505371
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022482872009277
(383) DESCRIBE `ports` 0.00071287155151367
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020480155944824
(385) DESCRIBE `ports` 0.00069117546081543
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019311904907227
(387) DESCRIBE `sailingdates` 0.0006098747253418
(388) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '38689') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049185752868652
(389) DESCRIBE `ports` 0.00070405006408691
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021100044250488
(391) DESCRIBE `ports` 0.00076794624328613
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019121170043945
(393) DESCRIBE `ports` 0.00067710876464844
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00021004676818848
(395) DESCRIBE `ports` 0.00067877769470215
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.0001828670501709
(397) DESCRIBE `ports` 0.00070309638977051
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.0001990795135498
(399) DESCRIBE `ports` 0.00067496299743652
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00018000602722168
(401) DESCRIBE `ports` 0.00067520141601562
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00023293495178223
(403) DESCRIBE `ports` 0.00069117546081543
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.0001828670501709
(405) DESCRIBE `ports` 0.00069403648376465
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00021910667419434
(407) DESCRIBE `ports` 0.00069189071655273
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.0001978874206543
(409) DESCRIBE `ports` 0.00067710876464844
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00020790100097656
(411) DESCRIBE `ports` 0.00067400932312012
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00020217895507812
(413) DESCRIBE `ports` 0.00071406364440918
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00020098686218262
(415) DESCRIBE `ports` 0.0007328987121582
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.0001838207244873
(417) DESCRIBE `ports` 0.00068211555480957
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0002140998840332
(419) DESCRIBE `ports` 0.00068378448486328
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00018692016601562
(421) DESCRIBE `ports` 0.00071406364440918
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00028204917907715
(423) DESCRIBE `ports` 0.00097393989562988
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00024104118347168
(425) DESCRIBE `avid_specials` 0.00088119506835938
(426) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38689 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.0017719268798828
(427) DESCRIBE `cruiselines` 0.0012111663818359
(428) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023317337036133
(429) DESCRIBE `orchid_image` 0.00078606605529785
(430) DESCRIBE `cruiselines` 0.00097990036010742
(431) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00021004676818848
(432) DESCRIBE `cruises` 0.001276969909668
(433) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '25176') 0.00021600723266602
(434) DESCRIBE `ships` 0.0013320446014404
(435) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026583671569824
(436) DESCRIBE `ships` 0.0013258457183838
(437) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.0001978874206543
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001990795135498
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(440) DESCRIBE `itineraries` 0.00071597099304199
(441) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '25176') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00083804130554199
(442) DESCRIBE `ports` 0.00136399269104
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033187866210938
(444) DESCRIBE `ports` 0.00096797943115234
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00028491020202637
(446) DESCRIBE `ports` 0.00092411041259766
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0002439022064209
(448) DESCRIBE `sailingdates` 0.00084114074707031
(449) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '25176') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00089192390441895
(450) DESCRIBE `ports` 0.0011260509490967
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033092498779297
(452) DESCRIBE `ports` 0.00080990791320801
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00020194053649902
(454) DESCRIBE `ports` 0.0008389949798584
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00020503997802734
(456) DESCRIBE `ports` 0.00068902969360352
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00018405914306641
(458) DESCRIBE `ports` 0.00067901611328125
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00022292137145996
(460) DESCRIBE `ports` 0.00067996978759766
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00018596649169922
(462) DESCRIBE `ports` 0.00067687034606934
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00020384788513184
(464) DESCRIBE `ports` 0.00067996978759766
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00018095970153809
(466) DESCRIBE `ports` 0.00077414512634277
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020599365234375
(468) DESCRIBE `ports` 0.00069808959960938
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00023508071899414
(470) DESCRIBE `avid_specials` 0.00083613395690918
(471) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 25176 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 53 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.0012798309326172
(472) DESCRIBE `cruiselines` 0.0010030269622803
(473) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022315979003906
(474) DESCRIBE `orchid_image` 0.0010368824005127
(475) DESCRIBE `cruiselines` 0.0010199546813965
(476) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020003318786621
(477) DESCRIBE `cruises` 0.0018980503082275
(478) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38690') 0.00029587745666504
(479) DESCRIBE `ships` 0.0015130043029785
(480) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00037312507629395
(481) DESCRIBE `ships` 0.0016288757324219
(482) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00034618377685547
(483) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024795532226562
(484) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023317337036133
(485) DESCRIBE `itineraries` 0.0011909008026123
(486) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '38690') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005040168762207
(487) DESCRIBE `ports` 0.0011861324310303
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00031900405883789
(489) DESCRIBE `ports` 0.0010359287261963
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00027799606323242
(491) DESCRIBE `ports` 0.00096607208251953
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00026106834411621
(493) DESCRIBE `sailingdates` 0.00089597702026367
(494) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '38690') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038599967956543
(495) DESCRIBE `ports` 0.00072789192199707
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00021696090698242
(497) DESCRIBE `ports` 0.00068092346191406
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018906593322754
(499) DESCRIBE `ports` 0.00069713592529297
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00020194053649902
(501) DESCRIBE `ports` 0.00068402290344238
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00018095970153809
(503) DESCRIBE `ports` 0.00067687034606934
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00020599365234375
(505) DESCRIBE `ports` 0.00069904327392578
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00018477439880371
(507) DESCRIBE `ports` 0.00067782402038574
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00020194053649902
(509) DESCRIBE `ports` 0.00067591667175293
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00019717216491699
(511) DESCRIBE `ports` 0.00067615509033203
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00020194053649902
(513) DESCRIBE `ports` 0.00068497657775879
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.0001838207244873
(515) DESCRIBE `ports` 0.00071907043457031
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00020098686218262
(517) DESCRIBE `ports` 0.00067710876464844
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00018787384033203
(519) DESCRIBE `ports` 0.00067710876464844
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00020194053649902
(521) DESCRIBE `ports` 0.00067901611328125
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00018000602722168
(523) DESCRIBE `ports` 0.00067615509033203
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00020408630371094
(525) DESCRIBE `ports` 0.00067305564880371
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00018310546875
(527) DESCRIBE `ports` 0.00067806243896484
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002131462097168
(529) DESCRIBE `ports` 0.0007171630859375
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018692016601562
(531) DESCRIBE `avid_specials` 0.00063204765319824
(532) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38690 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.00095486640930176
(533) DESCRIBE `cruiselines` 0.00098609924316406
(534) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022602081298828
(535) DESCRIBE `orchid_image` 0.00077605247497559
(536) DESCRIBE `cruiselines` 0.00093579292297363
(537) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020217895507812
(538) DESCRIBE `cruisetypes` 0.00066089630126953
(539) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) 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.035346031188965
(540) DESCRIBE `destinations` 0.0011589527130127
(541) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '53', '37', '48', '12', '38')) ORDER BY FIND_IN_SET(id, '22,53,37,48,12,38') 0.00066900253295898
(542) DESCRIBE `cruiselines` 0.0010859966278076
(543) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00028610229492188
(544) DESCRIBE `ships` 0.0013160705566406
(545) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.0002439022064209
(546) DESCRIBE `cruiselines` 0.0012140274047852
(547) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00027108192443848
(548) DESCRIBE `ships` 0.0013830661773682
(549) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026607513427734