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

Total elapsed time: 0.36148405075073

# Query Time
(1) connect 0.00045204162597656
(2) DESCRIBE `cruises` 0.0016980171203613
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71234, 59951, 73201, 61428, 73198, 59772, 61427, 66904, 40396, 67056)) ORDER BY FIND_IN_SET(id, '71234,59951,73201,61428,73198,59772,61427,66904,40396,67056') 0.0011191368103027
(4) DESCRIBE `cruises` 0.0015358924865723
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71234') 0.00022387504577637
(6) DESCRIBE `ships` 0.0014610290527344
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00025796890258789
(8) DESCRIBE `ships` 0.0012860298156738
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00021195411682129
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020408630371094
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018811225891113
(12) DESCRIBE `itineraries` 0.00070309638977051
(13) DESCRIBE `ports` 0.00069093704223633
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020813941955566
(15) DESCRIBE `ports` 0.00070500373840332
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019192695617676
(17) DESCRIBE `ports` 0.00066614151000977
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018692016601562
(19) DESCRIBE `sailingdates` 0.00062203407287598
(20) DESCRIBE `ports` 0.00069785118103027
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020003318786621
(22) DESCRIBE `ports` 0.00091099739074707
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00020790100097656
(24) DESCRIBE `ports` 0.0007631778717041
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00021004676818848
(26) DESCRIBE `ports` 0.00068497657775879
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00020217895507812
(28) DESCRIBE `ports` 0.0006721019744873
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0001981258392334
(30) DESCRIBE `ports` 0.0006711483001709
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00019001960754395
(32) DESCRIBE `ports` 0.00066804885864258
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0001988410949707
(34) DESCRIBE `ports` 0.00067710876464844
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00017976760864258
(36) DESCRIBE `ports` 0.00066590309143066
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020408630371094
(38) DESCRIBE `ports` 0.0006871223449707
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018596649169922
(40) DESCRIBE `avid_specials` 0.00060796737670898
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71234 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00093603134155273
(42) DESCRIBE `cruiselines` 0.0010881423950195
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00023198127746582
(44) DESCRIBE `orchid_image` 0.00077700614929199
(45) DESCRIBE `cruiselines` 0.00093817710876465
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00019097328186035
(47) DESCRIBE `cruises` 0.0013561248779297
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59951') 0.00022387504577637
(49) DESCRIBE `ships` 0.001288890838623
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 82))) 0.00025486946105957
(51) DESCRIBE `ships` 0.0012519359588623
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '82') 0.00018000602722168
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017619132995605
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(55) DESCRIBE `itineraries` 0.00065779685974121
(56) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59951') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011551380157471
(57) DESCRIBE `ports` 0.00076889991760254
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021600723266602
(59) DESCRIBE `ports` 0.00068092346191406
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020194053649902
(61) DESCRIBE `ports` 0.0007169246673584
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018596649169922
(63) DESCRIBE `sailingdates` 0.00062799453735352
(64) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59951') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058293342590332
(65) DESCRIBE `ports` 0.00072312355041504
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021195411682129
(67) DESCRIBE `ports` 0.00067305564880371
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018811225891113
(69) DESCRIBE `ports` 0.00067400932312012
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00020194053649902
(71) DESCRIBE `ports` 0.00069308280944824
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00018095970153809
(73) DESCRIBE `ports` 0.0006721019744873
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.0001978874206543
(75) DESCRIBE `ports` 0.00068092346191406
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00018095970153809
(77) DESCRIBE `ports` 0.00073981285095215
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020003318786621
(79) DESCRIBE `ports` 0.00066804885864258
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017905235290527
(81) DESCRIBE `ports` 0.00069499015808105
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019717216491699
(83) DESCRIBE `ports` 0.000701904296875
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018191337585449
(85) DESCRIBE `ports` 0.00066494941711426
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020313262939453
(87) DESCRIBE `ports` 0.00069499015808105
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0002140998840332
(89) DESCRIBE `ports` 0.00091981887817383
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020599365234375
(91) DESCRIBE `ports` 0.00067615509033203
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018000602722168
(93) DESCRIBE `ports` 0.00078010559082031
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00035309791564941
(95) DESCRIBE `ports` 0.00086283683776855
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00019097328186035
(97) DESCRIBE `ports` 0.00068092346191406
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020694732666016
(99) DESCRIBE `ports` 0.00068092346191406
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018405914306641
(101) DESCRIBE `avid_specials` 0.00066900253295898
(102) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59951 and class = 'Cruise') OR (item_id = 82 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099706649780273
(103) DESCRIBE `cruiselines` 0.0009620189666748
(104) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022602081298828
(105) DESCRIBE `orchid_image` 0.00076103210449219
(106) DESCRIBE `cruiselines` 0.00091910362243652
(107) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00018692016601562
(108) DESCRIBE `cruises` 0.0012590885162354
(109) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73201') 0.00020289421081543
(110) DESCRIBE `ships` 0.0013160705566406
(111) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00025486946105957
(112) DESCRIBE `ships` 0.0013449192047119
(113) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00018215179443359
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018310546875
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016999244689941
(116) DESCRIBE `itineraries` 0.00064992904663086
(117) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73201') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011510848999023
(118) DESCRIBE `ports` 0.00086522102355957
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00023508071899414
(120) DESCRIBE `ports` 0.00067400932312012
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00020313262939453
(122) DESCRIBE `ports` 0.00067687034606934
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00020408630371094
(124) DESCRIBE `sailingdates` 0.00061416625976562
(125) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73201') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00083088874816895
(126) DESCRIBE `ports` 0.00070714950561523
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0001990795135498
(128) DESCRIBE `ports` 0.00067591667175293
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.0001828670501709
(130) DESCRIBE `ports` 0.0006709098815918
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00022411346435547
(132) DESCRIBE `ports` 0.00069212913513184
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00018095970153809
(134) DESCRIBE `ports` 0.00080299377441406
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020289421081543
(136) DESCRIBE `ports` 0.0006718635559082
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00017714500427246
(138) DESCRIBE `ports` 0.00066494941711426
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020384788513184
(140) DESCRIBE `ports` 0.00067687034606934
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00017595291137695
(142) DESCRIBE `ports` 0.00066208839416504
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00023102760314941
(144) DESCRIBE `ports` 0.00069308280944824
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00018191337585449
(146) DESCRIBE `ports` 0.00069499015808105
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00020313262939453
(148) DESCRIBE `ports` 0.00066709518432617
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018906593322754
(150) DESCRIBE `ports` 0.00078606605529785
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00020503997802734
(152) DESCRIBE `ports` 0.00066685676574707
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00019598007202148
(154) DESCRIBE `ports` 0.00083112716674805
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00021505355834961
(156) DESCRIBE `ports` 0.00068092346191406
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00018596649169922
(158) DESCRIBE `ports` 0.00067901611328125
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00020289421081543
(160) DESCRIBE `ports` 0.00066685676574707
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00018501281738281
(162) DESCRIBE `ports` 0.00066399574279785
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00020313262939453
(164) DESCRIBE `ports` 0.00066804885864258
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00021004676818848
(166) DESCRIBE `ports` 0.00065398216247559
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00020599365234375
(168) DESCRIBE `ports` 0.0006859302520752
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00018715858459473
(170) DESCRIBE `ports` 0.00067996978759766
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00020313262939453
(172) DESCRIBE `ports` 0.00068807601928711
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00017595291137695
(174) DESCRIBE `ports` 0.0007169246673584
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00019979476928711
(176) DESCRIBE `ports` 0.00069522857666016
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.0001838207244873
(178) DESCRIBE `ports` 0.00066709518432617
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00019407272338867
(180) DESCRIBE `ports` 0.00065803527832031
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00017380714416504
(182) DESCRIBE `ports` 0.00069117546081543
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00019288063049316
(184) DESCRIBE `ports` 0.00066590309143066
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00017285346984863
(186) DESCRIBE `ports` 0.00066590309143066
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00020289421081543
(188) DESCRIBE `ports` 0.00069594383239746
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00017905235290527
(190) DESCRIBE `ports` 0.00066494941711426
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0001978874206543
(192) DESCRIBE `ports` 0.00065708160400391
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00019001960754395
(194) DESCRIBE `avid_specials` 0.00065994262695312
(195) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73201 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 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.00095295906066895
(196) DESCRIBE `cruiselines` 0.0009768009185791
(197) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021600723266602
(198) DESCRIBE `orchid_image` 0.00076699256896973
(199) DESCRIBE `cruiselines` 0.00091195106506348
(200) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00018215179443359
(201) DESCRIBE `cruises` 0.0012991428375244
(202) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61428') 0.00021505355834961
(203) DESCRIBE `ships` 0.0012900829315186
(204) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00023102760314941
(205) DESCRIBE `ships` 0.0014040470123291
(206) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00017905235290527
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023007392883301
(208) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016379356384277
(209) DESCRIBE `itineraries` 0.00071811676025391
(210) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61428') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00092887878417969
(211) DESCRIBE `ports` 0.00072097778320312
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00021505355834961
(213) DESCRIBE `ports` 0.00067496299743652
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00019598007202148
(215) DESCRIBE `ports` 0.00067400932312012
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.0001828670501709
(217) DESCRIBE `sailingdates` 0.00059604644775391
(218) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61428') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050616264343262
(219) DESCRIBE `ports` 0.00074601173400879
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00019693374633789
(221) DESCRIBE `ports` 0.00066900253295898
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00018191337585449
(223) DESCRIBE `ports` 0.00069284439086914
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.0002129077911377
(225) DESCRIBE `ports` 0.00066900253295898
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00017499923706055
(227) DESCRIBE `ports` 0.0006568431854248
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00019097328186035
(229) DESCRIBE `ports` 0.0007011890411377
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00021004676818848
(231) DESCRIBE `ports` 0.00066900253295898
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00019288063049316
(233) DESCRIBE `ports` 0.00066113471984863
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00017309188842773
(235) DESCRIBE `ports` 0.00067687034606934
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00025606155395508
(237) DESCRIBE `ports` 0.00071001052856445
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00017499923706055
(239) DESCRIBE `ports` 0.0008389949798584
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00026202201843262
(241) DESCRIBE `ports` 0.00094389915466309
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00018477439880371
(243) DESCRIBE `ports` 0.00069499015808105
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00022506713867188
(245) DESCRIBE `ports` 0.00075006484985352
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00018095970153809
(247) DESCRIBE `ports` 0.0006711483001709
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00019502639770508
(249) DESCRIBE `ports` 0.00071310997009277
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00017309188842773
(251) DESCRIBE `ports` 0.00066208839416504
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00019001960754395
(253) DESCRIBE `ports` 0.0006561279296875
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00017309188842773
(255) DESCRIBE `ports` 0.00067615509033203
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00019693374633789
(257) DESCRIBE `ports` 0.00066781044006348
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00017094612121582
(259) DESCRIBE `ports` 0.00065994262695312
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00021696090698242
(261) DESCRIBE `ports` 0.00069308280944824
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00018501281738281
(263) DESCRIBE `ports` 0.00066804885864258
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00019407272338867
(265) DESCRIBE `ports` 0.00065898895263672
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00020384788513184
(267) DESCRIBE `ports` 0.0006568431854248
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00020599365234375
(269) DESCRIBE `ports` 0.00065708160400391
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00017189979553223
(271) DESCRIBE `ports` 0.00069308280944824
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00023221969604492
(273) DESCRIBE `ports` 0.00066304206848145
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00017309188842773
(275) DESCRIBE `ports` 0.00082087516784668
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00025796890258789
(277) DESCRIBE `ports` 0.00092887878417969
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00020503997802734
(279) DESCRIBE `avid_specials` 0.00065088272094727
(280) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61428 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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.0010969638824463
(281) DESCRIBE `cruiselines` 0.0010700225830078
(282) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022006034851074
(283) DESCRIBE `orchid_image` 0.00094914436340332
(284) DESCRIBE `cruiselines` 0.0011968612670898
(285) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00023508071899414
(286) DESCRIBE `cruises` 0.0013198852539062
(287) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73198') 0.00020503997802734
(288) DESCRIBE `ships` 0.0015709400177002
(289) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00030112266540527
(290) DESCRIBE `ships` 0.0012569427490234
(291) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00019001960754395
(292) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001680850982666
(294) DESCRIBE `itineraries` 0.00086307525634766
(295) DESCRIBE `ports` 0.00096607208251953
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00027585029602051
(297) DESCRIBE `ports` 0.00095009803771973
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00024914741516113
(299) DESCRIBE `ports` 0.00098705291748047
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00022292137145996
(301) DESCRIBE `sailingdates` 0.0007939338684082
(302) DESCRIBE `ports` 0.00090289115905762
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00026392936706543
(304) DESCRIBE `ports` 0.00067400932312012
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00018882751464844
(306) DESCRIBE `ports` 0.00066304206848145
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00023007392883301
(308) DESCRIBE `ports` 0.00066900253295898
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00018501281738281
(310) DESCRIBE `ports` 0.00070285797119141
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00019192695617676
(312) DESCRIBE `ports` 0.00067901611328125
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00017309188842773
(314) DESCRIBE `ports` 0.00069808959960938
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00019192695617676
(316) DESCRIBE `ports` 0.00068807601928711
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018882751464844
(318) DESCRIBE `ports` 0.00089716911315918
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00027203559875488
(320) DESCRIBE `ports` 0.00094079971313477
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00020790100097656
(322) DESCRIBE `ports` 0.00069999694824219
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00020599365234375
(324) DESCRIBE `ports` 0.00067591667175293
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018310546875
(326) DESCRIBE `ports` 0.00067019462585449
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00020098686218262
(328) DESCRIBE `ports` 0.000701904296875
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00017881393432617
(330) DESCRIBE `ports` 0.00066208839416504
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00022387504577637
(332) DESCRIBE `ports` 0.00075006484985352
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00023102760314941
(334) DESCRIBE `ports` 0.00095820426940918
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00025105476379395
(336) DESCRIBE `ports` 0.00094699859619141
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00019311904907227
(338) DESCRIBE `avid_specials` 0.00063109397888184
(339) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73198 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 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.00094699859619141
(340) DESCRIBE `cruiselines` 0.0012249946594238
(341) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00024008750915527
(342) DESCRIBE `orchid_image` 0.00076198577880859
(343) DESCRIBE `cruiselines` 0.0010311603546143
(344) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020408630371094
(345) DESCRIBE `cruises` 0.001399040222168
(346) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59772') 0.00023293495178223
(347) DESCRIBE `ships` 0.00130295753479
(348) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00025177001953125
(349) DESCRIBE `ships` 0.0018310546875
(350) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.0002448558807373
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022196769714355
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021696090698242
(353) DESCRIBE `itineraries` 0.00096702575683594
(354) DESCRIBE `ports` 0.0010411739349365
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00029206275939941
(356) DESCRIBE `ports` 0.00090289115905762
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00025510787963867
(358) DESCRIBE `ports` 0.00091981887817383
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00026392936706543
(360) DESCRIBE `sailingdates` 0.00077104568481445
(361) DESCRIBE `ports` 0.00079798698425293
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00026392936706543
(363) DESCRIBE `ports` 0.00070309638977051
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00022101402282715
(365) DESCRIBE `ports` 0.00078392028808594
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00021982192993164
(367) DESCRIBE `ports` 0.00068402290344238
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00018191337585449
(369) DESCRIBE `ports` 0.00067901611328125
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00020003318786621
(371) DESCRIBE `ports` 0.0006721019744873
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00019097328186035
(373) DESCRIBE `ports` 0.0007169246673584
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020098686218262
(375) DESCRIBE `ports` 0.00066208839416504
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018191337585449
(377) DESCRIBE `ports` 0.0006859302520752
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020408630371094
(379) DESCRIBE `ports` 0.00072002410888672
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.0001838207244873
(381) DESCRIBE `ports` 0.00070500373840332
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00021100044250488
(383) DESCRIBE `ports` 0.00069499015808105
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00047516822814941
(385) DESCRIBE `ports` 0.00087594985961914
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00022387504577637
(387) DESCRIBE `ports` 0.00067710876464844
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00019192695617676
(389) DESCRIBE `ports` 0.00066709518432617
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00021195411682129
(391) DESCRIBE `ports` 0.00066399574279785
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00017595291137695
(393) DESCRIBE `ports` 0.00066804885864258
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021886825561523
(395) DESCRIBE `ports` 0.00066804885864258
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018596649169922
(397) DESCRIBE `avid_specials` 0.00061893463134766
(398) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59772 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010190010070801
(399) DESCRIBE `cruiselines` 0.0010240077972412
(400) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022387504577637
(401) DESCRIBE `orchid_image` 0.00081586837768555
(402) DESCRIBE `cruiselines` 0.0011670589447021
(403) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00021195411682129
(404) DESCRIBE `cruises` 0.002032995223999
(405) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61427') 0.00030612945556641
(406) DESCRIBE `ships` 0.0020449161529541
(407) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00026988983154297
(408) DESCRIBE `ships` 0.0013511180877686
(409) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00020003318786621
(410) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021195411682129
(411) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022006034851074
(412) DESCRIBE `itineraries` 0.00098299980163574
(413) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61427') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057196617126465
(414) DESCRIBE `ports` 0.00073504447937012
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00022387504577637
(416) DESCRIBE `ports` 0.00076413154602051
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00020313262939453
(418) DESCRIBE `ports` 0.00068283081054688
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00018692016601562
(420) DESCRIBE `sailingdates` 0.00065517425537109
(421) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61427') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043678283691406
(422) DESCRIBE `ports` 0.0010921955108643
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00028204917907715
(424) DESCRIBE `ports` 0.00067400932312012
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00020098686218262
(426) DESCRIBE `ports` 0.00068211555480957
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00020503997802734
(428) DESCRIBE `ports` 0.00066995620727539
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00018310546875
(430) DESCRIBE `ports` 0.00066494941711426
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00020098686218262
(432) DESCRIBE `ports` 0.00068378448486328
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00018191337585449
(434) DESCRIBE `ports` 0.00066304206848145
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00020003318786621
(436) DESCRIBE `ports` 0.00068807601928711
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00018095970153809
(438) DESCRIBE `ports` 0.00073003768920898
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00020194053649902
(440) DESCRIBE `ports` 0.00066590309143066
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00018095970153809
(442) DESCRIBE `ports` 0.00066590309143066
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00022315979003906
(444) DESCRIBE `ports` 0.00067591667175293
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00018215179443359
(446) DESCRIBE `ports` 0.00066399574279785
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.0001978874206543
(448) DESCRIBE `ports` 0.00066709518432617
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00018095970153809
(450) DESCRIBE `ports` 0.00066709518432617
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00020289421081543
(452) DESCRIBE `ports` 0.00066399574279785
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00018215179443359
(454) DESCRIBE `avid_specials` 0.00062799453735352
(455) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61427 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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
(456) DESCRIBE `cruiselines` 0.00097107887268066
(457) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022411346435547
(458) DESCRIBE `orchid_image` 0.00076413154602051
(459) DESCRIBE `cruiselines` 0.0009150505065918
(460) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00018501281738281
(461) DESCRIBE `cruises` 0.0012660026550293
(462) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66904') 0.00019979476928711
(463) DESCRIBE `ships` 0.0016078948974609
(464) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00044798851013184
(465) DESCRIBE `ships` 0.0013508796691895
(466) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00020098686218262
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018477439880371
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(469) DESCRIBE `itineraries` 0.00066900253295898
(470) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66904') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001007080078125
(471) DESCRIBE `ports` 0.00071811676025391
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020980834960938
(473) DESCRIBE `ports` 0.00074291229248047
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0002129077911377
(475) DESCRIBE `ports` 0.00067996978759766
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018596649169922
(477) DESCRIBE `sailingdates` 0.00060415267944336
(478) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66904') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047492980957031
(479) DESCRIBE `ports` 0.0010769367218018
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0003511905670166
(481) DESCRIBE `ports` 0.00098609924316406
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00023794174194336
(483) DESCRIBE `ports` 0.00078201293945312
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00022196769714355
(485) DESCRIBE `ports` 0.00091099739074707
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00023698806762695
(487) DESCRIBE `ports` 0.00074601173400879
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00028896331787109
(489) DESCRIBE `ports` 0.00082302093505859
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00022292137145996
(491) DESCRIBE `ports` 0.00072407722473145
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00021195411682129
(493) DESCRIBE `ports` 0.00075221061706543
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00020599365234375
(495) DESCRIBE `ports` 0.00073814392089844
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00021886825561523
(497) DESCRIBE `ports` 0.00092291831970215
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00023508071899414
(499) DESCRIBE `ports` 0.00078701972961426
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00026512145996094
(501) DESCRIBE `ports` 0.00089287757873535
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00019288063049316
(503) DESCRIBE `ports` 0.00072002410888672
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020503997802734
(505) DESCRIBE `ports` 0.00067901611328125
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018501281738281
(507) DESCRIBE `avid_specials` 0.00059890747070312
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66904 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009770393371582
(509) DESCRIBE `cruiselines` 0.0010621547698975
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00025200843811035
(511) DESCRIBE `orchid_image` 0.00076794624328613
(512) DESCRIBE `cruiselines` 0.00097107887268066
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00019097328186035
(514) DESCRIBE `cruises` 0.0027279853820801
(515) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40396') 0.00047802925109863
(516) DESCRIBE `ships` 0.0023579597473145
(517) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 82))) 0.00048112869262695
(518) DESCRIBE `ships` 0.0022640228271484
(519) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '82') 0.00033402442932129
(520) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035905838012695
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(522) DESCRIBE `itineraries` 0.0012681484222412
(523) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40396') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014748573303223
(524) DESCRIBE `ports` 0.0012941360473633
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00044608116149902
(526) DESCRIBE `ports` 0.0014469623565674
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00039911270141602
(528) DESCRIBE `ports` 0.0014710426330566
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00039291381835938
(530) DESCRIBE `sailingdates` 0.0012178421020508
(531) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '40396') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00083494186401367
(532) DESCRIBE `ports` 0.0007331371307373
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0002138614654541
(534) DESCRIBE `ports` 0.00071310997009277
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018692016601562
(536) DESCRIBE `ports` 0.00071811676025391
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00021004676818848
(538) DESCRIBE `ports` 0.00124192237854
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00031399726867676
(540) DESCRIBE `ports` 0.001338005065918
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00055503845214844
(542) DESCRIBE `ports` 0.0013470649719238
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00041508674621582
(544) DESCRIBE `ports` 0.0011849403381348
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00035595893859863
(546) DESCRIBE `ports` 0.00111985206604
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00018405914306641
(548) DESCRIBE `ports` 0.00069189071655273
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022006034851074
(550) DESCRIBE `ports` 0.00069999694824219
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00020003318786621
(552) DESCRIBE `avid_specials` 0.00062704086303711
(553) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40396 and class = 'Cruise') OR (item_id = 82 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011448860168457
(554) DESCRIBE `cruiselines` 0.0011341571807861
(555) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.000244140625
(556) DESCRIBE `orchid_image` 0.00077700614929199
(557) DESCRIBE `cruiselines` 0.0010042190551758
(558) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020194053649902
(559) DESCRIBE `cruises` 0.0015339851379395
(560) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67056') 0.00021886825561523
(561) DESCRIBE `ships` 0.001291036605835
(562) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1302))) 0.00033092498779297
(563) DESCRIBE `ships` 0.0012819766998291
(564) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1302') 0.0001978874206543
(565) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00018596649169922
(566) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017404556274414
(567) DESCRIBE `itineraries` 0.00070500373840332
(568) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67056') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061607360839844
(569) DESCRIBE `ports` 0.00073409080505371
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00022006034851074
(571) DESCRIBE `ports` 0.00068092346191406
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0002129077911377
(573) DESCRIBE `ports` 0.00069594383239746
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00019001960754395
(575) DESCRIBE `sailingdates` 0.00061583518981934
(576) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67056') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00034594535827637
(577) DESCRIBE `ports` 0.00069785118103027
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00026416778564453
(579) DESCRIBE `ports` 0.0009758472442627
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00023984909057617
(581) DESCRIBE `ports` 0.00099396705627441
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00022602081298828
(583) DESCRIBE `ports` 0.00070500373840332
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018811225891113
(585) DESCRIBE `ports` 0.00071811676025391
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00020599365234375
(587) DESCRIBE `ports` 0.00068902969360352
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00018596649169922
(589) DESCRIBE `ports` 0.00071191787719727
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00021505355834961
(591) DESCRIBE `ports` 0.00072717666625977
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00019311904907227
(593) DESCRIBE `ports` 0.00070595741271973
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00020813941955566
(595) DESCRIBE `ports` 0.00072693824768066
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00019001960754395
(597) DESCRIBE `ports` 0.00068497657775879
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1187))) 0.00021481513977051
(599) DESCRIBE `ports` 0.0006868839263916
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1187') 0.00021600723266602
(601) DESCRIBE `ports` 0.00073099136352539
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0002140998840332
(603) DESCRIBE `ports` 0.00070285797119141
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00019216537475586
(605) DESCRIBE `ports` 0.00071406364440918
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00020909309387207
(607) DESCRIBE `ports` 0.00070905685424805
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00018692016601562
(609) DESCRIBE `ports` 0.00069284439086914
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 829))) 0.00020885467529297
(611) DESCRIBE `ports` 0.00070285797119141
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '829') 0.00018501281738281
(613) DESCRIBE `ports` 0.0007481575012207
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.0002140998840332
(615) DESCRIBE `ports` 0.00073003768920898
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00019216537475586
(617) DESCRIBE `ports` 0.00069403648376465
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00021195411682129
(619) DESCRIBE `ports` 0.00069689750671387
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00019693374633789
(621) DESCRIBE `ports` 0.00076603889465332
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 828))) 0.00021195411682129
(623) DESCRIBE `ports` 0.00069379806518555
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '828') 0.00019407272338867
(625) DESCRIBE `ports` 0.00068783760070801
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00021886825561523
(627) DESCRIBE `ports` 0.00073504447937012
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018906593322754
(629) DESCRIBE `ports` 0.00070095062255859
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00021195411682129
(631) DESCRIBE `ports` 0.00072598457336426
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00022697448730469
(633) DESCRIBE `avid_specials` 0.00075793266296387
(634) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67056 and class = 'Cruise') OR (item_id = 1302 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 25 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012338161468506
(635) DESCRIBE `cruiselines` 0.0010519027709961
(636) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00025296211242676
(637) DESCRIBE `orchid_image` 0.00088119506835938
(638) DESCRIBE `cruiselines` 0.0011210441589355
(639) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00023603439331055
(640) DESCRIBE `ships` 0.0015459060668945
(641) SELECT `ships`.* FROM `ships` WHERE (id IN ('792', '1607', '78', '340', '1302', '81', '547', '82', '84', '657', '335', '401', '313', '74', '75')) ORDER BY FIND_IN_SET(id, '792,1607,78,340,1302,81,547,82,84,657,335,401,313,74,75') 0.00079703330993652
(642) DESCRIBE `cruisetypes` 0.00070691108703613
(643) DESCRIBE `destinations` 0.0011301040649414
(644) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '2', '11', '48', '22', '25', '43', '35', '53', '37', '38', '26', '40', '49', '29', '34', '21', '28', '8', '9', '30')) ORDER BY FIND_IN_SET(id, '12,2,11,48,22,25,43,35,53,37,38,26,40,49,29,34,21,28,8,9,30') 0.00077700614929199
(645) DESCRIBE `cruiselines` 0.0010490417480469
(646) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00023198127746582
(647) DESCRIBE `cruiselines` 0.00098299980163574
(648) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00024890899658203