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

Total elapsed time: 0.42169833183289

# Query Time
(1) connect 0.0004420280456543
(2) DESCRIBE `cruises` 0.0018670558929443
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69896, 69878, 69863, 69879, 69892, 69864, 69881, 69893, 69893, 69861)) ORDER BY FIND_IN_SET(id, '69896,69878,69863,69879,69892,69864,69881,69893,69893,69861') 0.00091195106506348
(4) DESCRIBE `cruises` 0.0015099048614502
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69896') 0.00024986267089844
(6) DESCRIBE `ships` 0.0013270378112793
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00051116943359375
(8) DESCRIBE `ships` 0.0015511512756348
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00018692016601562
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(12) DESCRIBE `itineraries` 0.00073814392089844
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69896') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011250972747803
(14) DESCRIBE `ports` 0.00072789192199707
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022196769714355
(16) DESCRIBE `ports` 0.00069499015808105
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021195411682129
(18) DESCRIBE `ports` 0.00066494941711426
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017809867858887
(20) DESCRIBE `sailingdates` 0.00060105323791504
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69896') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001032829284668
(22) DESCRIBE `ports` 0.0010330677032471
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(24) DESCRIBE `ports` 0.00098991394042969
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023102760314941
(26) DESCRIBE `ports` 0.00085806846618652
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00024700164794922
(28) DESCRIBE `ports` 0.00092720985412598
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00024890899658203
(30) DESCRIBE `ports` 0.00096487998962402
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00026893615722656
(32) DESCRIBE `ports` 0.00097489356994629
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00024199485778809
(34) DESCRIBE `ports` 0.00097894668579102
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00029182434082031
(36) DESCRIBE `ports` 0.00098204612731934
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00024986267089844
(38) DESCRIBE `ports` 0.00098109245300293
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0002751350402832
(40) DESCRIBE `ports` 0.00096702575683594
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00024795532226562
(42) DESCRIBE `ports` 0.00093507766723633
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0002748966217041
(44) DESCRIBE `ports` 0.00092697143554688
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00025510787963867
(46) DESCRIBE `ports` 0.00099802017211914
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00021100044250488
(48) DESCRIBE `ports` 0.00069999694824219
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00018906593322754
(50) DESCRIBE `ports` 0.00071096420288086
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031614303588867
(52) DESCRIBE `ports` 0.00096607208251953
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024199485778809
(54) DESCRIBE `ports` 0.00091290473937988
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00029397010803223
(56) DESCRIBE `ports` 0.00088405609130859
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00025391578674316
(58) DESCRIBE `ports` 0.00098586082458496
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028300285339355
(60) DESCRIBE `ports` 0.00084209442138672
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002129077911377
(62) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69896') AND (sailingdate >= '2019-01-01') 0.014837026596069
(63) DESCRIBE `avid_specials` 0.0010759830474854
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69896 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013999938964844
(65) DESCRIBE `cruiselines` 0.001317024230957
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00046801567077637
(67) DESCRIBE `orchid_image` 0.0010318756103516
(68) DESCRIBE `cruiselines` 0.0012490749359131
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018501281738281
(70) DESCRIBE `cruises` 0.001305103302002
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69878') 0.00019288063049316
(72) DESCRIBE `ships` 0.0012738704681396
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00025105476379395
(74) DESCRIBE `ships` 0.0012319087982178
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00019121170043945
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017714500427246
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(78) DESCRIBE `itineraries` 0.00066494941711426
(79) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69878') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043797492980957
(80) DESCRIBE `ports` 0.00075912475585938
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023293495178223
(82) DESCRIBE `ports` 0.00071001052856445
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019598007202148
(84) DESCRIBE `ports` 0.00066304206848145
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017905235290527
(86) DESCRIBE `sailingdates` 0.00060105323791504
(87) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69878') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00033712387084961
(88) DESCRIBE `ports` 0.00069713592529297
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001978874206543
(90) DESCRIBE `ports` 0.00066494941711426
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017881393432617
(92) DESCRIBE `ports` 0.00068998336791992
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00020408630371094
(94) DESCRIBE `ports` 0.00066685676574707
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00017619132995605
(96) DESCRIBE `ports` 0.00066590309143066
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00019598007202148
(98) DESCRIBE `ports` 0.00066304206848145
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00017905235290527
(100) DESCRIBE `ports` 0.00066781044006348
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00020003318786621
(102) DESCRIBE `ports` 0.00075006484985352
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028514862060547
(104) DESCRIBE `ports` 0.00067710876464844
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0001990795135498
(106) DESCRIBE `ports` 0.00066995620727539
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00018095970153809
(108) DESCRIBE `ports` 0.00068306922912598
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00020503997802734
(110) DESCRIBE `ports` 0.00066304206848145
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00020289421081543
(112) DESCRIBE `ports` 0.00066590309143066
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00019598007202148
(114) DESCRIBE `ports` 0.00069308280944824
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00017809867858887
(116) DESCRIBE `ports` 0.00066399574279785
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00020003318786621
(118) DESCRIBE `ports` 0.00067591667175293
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00017595291137695
(120) DESCRIBE `ports` 0.0006859302520752
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020313262939453
(122) DESCRIBE `ports` 0.00067687034606934
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017786026000977
(124) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69878') AND (sailingdate >= '2019-01-01') 0.0055902004241943
(125) DESCRIBE `avid_specials` 0.00068902969360352
(126) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69878 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00094103813171387
(127) DESCRIBE `cruiselines` 0.00097799301147461
(128) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00021696090698242
(129) DESCRIBE `orchid_image` 0.00076103210449219
(130) DESCRIBE `cruiselines` 0.00098490715026855
(131) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018191337585449
(132) DESCRIBE `cruises` 0.0013160705566406
(133) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69863') 0.00023698806762695
(134) DESCRIBE `ships` 0.0013449192047119
(135) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00025105476379395
(136) DESCRIBE `ships` 0.0012540817260742
(137) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00019001960754395
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016689300537109
(140) DESCRIBE `itineraries` 0.00066494941711426
(141) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69863') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00037407875061035
(142) DESCRIBE `ports` 0.00068783760070801
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021004676818848
(144) DESCRIBE `ports` 0.00067305564880371
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001988410949707
(146) DESCRIBE `ports` 0.00066804885864258
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018191337585449
(148) DESCRIBE `sailingdates` 0.00060296058654785
(149) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69863') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00030183792114258
(150) DESCRIBE `ports` 0.00070381164550781
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022506713867188
(152) DESCRIBE `ports` 0.00067591667175293
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018191337585449
(154) DESCRIBE `ports` 0.00066900253295898
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0001988410949707
(156) DESCRIBE `ports` 0.00067687034606934
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0001828670501709
(158) DESCRIBE `ports` 0.00067496299743652
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00019979476928711
(160) DESCRIBE `ports` 0.00066995620727539
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00017786026000977
(162) DESCRIBE `ports` 0.00066494941711426
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00022196769714355
(164) DESCRIBE `ports` 0.00066709518432617
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00018000602722168
(166) DESCRIBE `ports` 0.0007328987121582
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00019717216491699
(168) DESCRIBE `ports` 0.00068497657775879
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018000602722168
(170) DESCRIBE `ports` 0.00066804885864258
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(172) DESCRIBE `ports` 0.00066518783569336
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017809867858887
(174) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69863') AND (sailingdate >= '2019-01-01') 0.0054020881652832
(175) DESCRIBE `avid_specials` 0.00062680244445801
(176) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69863 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00098896026611328
(177) DESCRIBE `cruiselines` 0.0009920597076416
(178) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00021719932556152
(179) DESCRIBE `orchid_image` 0.00076389312744141
(180) DESCRIBE `cruiselines` 0.00093913078308105
(181) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018215179443359
(182) DESCRIBE `cruises` 0.0012681484222412
(183) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69879') 0.0001990795135498
(184) DESCRIBE `ships` 0.0013117790222168
(185) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00025415420532227
(186) DESCRIBE `ships` 0.0012660026550293
(187) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00019311904907227
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020003318786621
(189) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(190) DESCRIBE `itineraries` 0.00066804885864258
(191) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69879') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00030708312988281
(192) DESCRIBE `ports` 0.00068306922912598
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020599365234375
(194) DESCRIBE `ports` 0.00067496299743652
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019693374633789
(196) DESCRIBE `ports` 0.00066685676574707
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018095970153809
(198) DESCRIBE `sailingdates` 0.00060319900512695
(199) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69879') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00031185150146484
(200) DESCRIBE `ports` 0.00071501731872559
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020623207092285
(202) DESCRIBE `ports` 0.00074005126953125
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018095970153809
(204) DESCRIBE `ports` 0.00066995620727539
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0001990795135498
(206) DESCRIBE `ports` 0.00066995620727539
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018095970153809
(208) DESCRIBE `ports` 0.00070905685424805
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00023102760314941
(210) DESCRIBE `ports` 0.00066900253295898
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018000602722168
(212) DESCRIBE `ports` 0.00066399574279785
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020003318786621
(214) DESCRIBE `ports` 0.00069189071655273
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017881393432617
(216) DESCRIBE `ports` 0.00068402290344238
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001981258392334
(218) DESCRIBE `ports` 0.00066709518432617
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018000602722168
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69879') AND (sailingdate >= '2019-01-01') 0.0058870315551758
(221) DESCRIBE `avid_specials` 0.00072693824768066
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69879 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099611282348633
(223) DESCRIBE `cruiselines` 0.00097894668579102
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00023794174194336
(225) DESCRIBE `orchid_image` 0.00076007843017578
(226) DESCRIBE `cruiselines` 0.00094485282897949
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0001828670501709
(228) DESCRIBE `cruises` 0.0012979507446289
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69892') 0.00019001960754395
(230) DESCRIBE `ships` 0.0012898445129395
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00028705596923828
(232) DESCRIBE `ships` 0.001349925994873
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00020813941955566
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018215179443359
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016880035400391
(236) DESCRIBE `itineraries` 0.00068092346191406
(237) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69892') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048017501831055
(238) DESCRIBE `ports` 0.00071382522583008
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021100044250488
(240) DESCRIBE `ports` 0.00077915191650391
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004417896270752
(242) DESCRIBE `ports` 0.0009150505065918
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019717216491699
(244) DESCRIBE `sailingdates` 0.00064897537231445
(245) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69892') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00039315223693848
(246) DESCRIBE `ports` 0.00072312355041504
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020790100097656
(248) DESCRIBE `ports` 0.00069308280944824
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020384788513184
(250) DESCRIBE `ports` 0.00067305564880371
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0001988410949707
(252) DESCRIBE `ports` 0.00069594383239746
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00018119812011719
(254) DESCRIBE `ports` 0.0006721019744873
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.0001978874206543
(256) DESCRIBE `ports` 0.00067901611328125
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00017905235290527
(258) DESCRIBE `ports` 0.00067305564880371
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00023221969604492
(260) DESCRIBE `ports` 0.00094199180603027
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00021886825561523
(262) DESCRIBE `ports` 0.00089001655578613
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00025701522827148
(264) DESCRIBE `ports` 0.00092196464538574
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00019693374633789
(266) DESCRIBE `ports` 0.00087499618530273
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00021100044250488
(268) DESCRIBE `ports` 0.0009610652923584
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00022387504577637
(270) DESCRIBE `ports` 0.00088095664978027
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0002448558807373
(272) DESCRIBE `ports` 0.00089693069458008
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00020503997802734
(274) DESCRIBE `ports` 0.00085997581481934
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00025296211242676
(276) DESCRIBE `ports` 0.00086808204650879
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00023794174194336
(278) DESCRIBE `ports` 0.00087904930114746
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00025796890258789
(280) DESCRIBE `ports` 0.00086498260498047
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0001990795135498
(282) DESCRIBE `ports` 0.00087308883666992
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00024008750915527
(284) DESCRIBE `ports` 0.00068092346191406
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018310546875
(286) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69892') AND (sailingdate >= '2019-01-01') 0.0054340362548828
(287) DESCRIBE `avid_specials` 0.00071907043457031
(288) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69892 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00093603134155273
(289) DESCRIBE `cruiselines` 0.0010409355163574
(290) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00021910667419434
(291) DESCRIBE `orchid_image` 0.00077199935913086
(292) DESCRIBE `cruiselines` 0.00096607208251953
(293) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00017905235290527
(294) DESCRIBE `cruises` 0.0018770694732666
(295) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69864') 0.00026297569274902
(296) DESCRIBE `ships` 0.0013589859008789
(297) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00026297569274902
(298) DESCRIBE `ships` 0.0012948513031006
(299) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.0002129077911377
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(301) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017118453979492
(302) DESCRIBE `itineraries` 0.00067591667175293
(303) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69864') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00033998489379883
(304) DESCRIBE `ports` 0.00071501731872559
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022697448730469
(306) DESCRIBE `ports` 0.00082683563232422
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002129077911377
(308) DESCRIBE `ports` 0.00068306922912598
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018405914306641
(310) DESCRIBE `sailingdates` 0.00063896179199219
(311) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69864') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00033092498779297
(312) DESCRIBE `ports` 0.00070405006408691
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020194053649902
(314) DESCRIBE `ports` 0.00070691108703613
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018095970153809
(316) DESCRIBE `ports` 0.00068187713623047
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020289421081543
(318) DESCRIBE `ports` 0.00067806243896484
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00020790100097656
(320) DESCRIBE `ports` 0.00091695785522461
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020480155944824
(322) DESCRIBE `ports` 0.00068807601928711
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018906593322754
(324) DESCRIBE `ports` 0.00067806243896484
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0001988410949707
(326) DESCRIBE `ports` 0.00069594383239746
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00018095970153809
(328) DESCRIBE `ports` 0.00068402290344238
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020885467529297
(330) DESCRIBE `ports` 0.00070691108703613
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019693374633789
(332) DESCRIBE `ports` 0.00068879127502441
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001981258392334
(334) DESCRIBE `ports` 0.00067782402038574
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018095970153809
(336) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69864') AND (sailingdate >= '2019-01-01') 0.0052270889282227
(337) DESCRIBE `avid_specials` 0.00063204765319824
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69864 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00092291831970215
(339) DESCRIBE `cruiselines` 0.0010068416595459
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00021719932556152
(341) DESCRIBE `orchid_image` 0.0007631778717041
(342) DESCRIBE `cruiselines` 0.00092005729675293
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00017881393432617
(344) DESCRIBE `cruises` 0.0013260841369629
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69881') 0.0003659725189209
(346) DESCRIBE `ships` 0.0012969970703125
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00025796890258789
(348) DESCRIBE `ships` 0.0013911724090576
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00021815299987793
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(352) DESCRIBE `itineraries` 0.00067901611328125
(353) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69881') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00039505958557129
(354) DESCRIBE `ports` 0.00073885917663574
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026106834411621
(356) DESCRIBE `ports` 0.00089311599731445
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026178359985352
(358) DESCRIBE `ports` 0.00068306922912598
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019097328186035
(360) DESCRIBE `sailingdates` 0.00061392784118652
(361) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69881') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038385391235352
(362) DESCRIBE `ports` 0.00070595741271973
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023198127746582
(364) DESCRIBE `ports` 0.00079894065856934
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018501281738281
(366) DESCRIBE `ports` 0.00067305564880371
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0002140998840332
(368) DESCRIBE `ports` 0.0006711483001709
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00018095970153809
(370) DESCRIBE `ports` 0.00066804885864258
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00020503997802734
(372) DESCRIBE `ports` 0.0006709098815918
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00018095970153809
(374) DESCRIBE `ports` 0.00066900253295898
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0001990795135498
(376) DESCRIBE `ports` 0.00070309638977051
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0001828670501709
(378) DESCRIBE `ports` 0.0006721019744873
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00020503997802734
(380) DESCRIBE `ports` 0.00066590309143066
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00018000602722168
(382) DESCRIBE `ports` 0.00069689750671387
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0001978874206543
(384) DESCRIBE `ports` 0.00067710876464844
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00017881393432617
(386) DESCRIBE `ports` 0.00067901611328125
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00021100044250488
(388) DESCRIBE `ports` 0.00068902969360352
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00017881393432617
(390) DESCRIBE `ports` 0.00066709518432617
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020194053649902
(392) DESCRIBE `ports` 0.00067710876464844
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018000602722168
(394) DESCRIBE `ports` 0.00067281723022461
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0002140998840332
(396) DESCRIBE `ports` 0.0006709098815918
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00018191337585449
(398) DESCRIBE `ports` 0.00076508522033691
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022578239440918
(400) DESCRIBE `ports` 0.00079703330993652
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022792816162109
(402) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69881') AND (sailingdate >= '2019-01-01') 0.005666971206665
(403) DESCRIBE `avid_specials` 0.00092482566833496
(404) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69881 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010120868682861
(405) DESCRIBE `cruiselines` 0.0010309219360352
(406) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0002291202545166
(407) DESCRIBE `orchid_image` 0.00077104568481445
(408) DESCRIBE `cruiselines` 0.00094699859619141
(409) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018596649169922
(410) DESCRIBE `cruises` 0.001295804977417
(411) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69893') 0.00021696090698242
(412) DESCRIBE `ships` 0.0012929439544678
(413) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00024199485778809
(414) DESCRIBE `ships` 0.0012807846069336
(415) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00018119812011719
(416) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001678466796875
(418) DESCRIBE `itineraries` 0.0006709098815918
(419) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69893') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041604042053223
(420) DESCRIBE `ports` 0.00070500373840332
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002140998840332
(422) DESCRIBE `ports` 0.00068020820617676
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0001981258392334
(424) DESCRIBE `ports` 0.00069785118103027
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00017404556274414
(426) DESCRIBE `sailingdates` 0.0006110668182373
(427) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69893') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00031805038452148
(428) DESCRIBE `ports` 0.00070309638977051
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020790100097656
(430) DESCRIBE `ports` 0.00068211555480957
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018310546875
(432) DESCRIBE `ports` 0.00083708763122559
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0002739429473877
(434) DESCRIBE `ports` 0.00067901611328125
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00019001960754395
(436) DESCRIBE `ports` 0.000701904296875
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00020503997802734
(438) DESCRIBE `ports` 0.00067901611328125
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0001828670501709
(440) DESCRIBE `ports` 0.00066900253295898
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00019311904907227
(442) DESCRIBE `ports` 0.00066804885864258
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00020098686218262
(444) DESCRIBE `ports` 0.00095105171203613
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00018811225891113
(446) DESCRIBE `ports` 0.00076007843017578
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00018405914306641
(448) DESCRIBE `ports` 0.00069689750671387
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00020098686218262
(450) DESCRIBE `ports` 0.00070309638977051
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0001828670501709
(452) DESCRIBE `ports` 0.00066709518432617
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00020694732666016
(454) DESCRIBE `ports` 0.00068211555480957
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00018000602722168
(456) DESCRIBE `ports` 0.00069594383239746
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00020003318786621
(458) DESCRIBE `ports` 0.00070500373840332
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00018882751464844
(460) DESCRIBE `ports` 0.00066995620727539
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.0001978874206543
(462) DESCRIBE `ports` 0.00068497657775879
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00017905235290527
(464) DESCRIBE `ports` 0.00068092346191406
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00020217895507812
(466) DESCRIBE `ports` 0.00067496299743652
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00018310546875
(468) DESCRIBE `ports` 0.00068998336791992
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021100044250488
(470) DESCRIBE `ports` 0.00068378448486328
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017905235290527
(472) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69893') AND (sailingdate >= '2019-01-01') 0.005669116973877
(473) DESCRIBE `avid_specials` 0.00078701972961426
(474) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69893 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016329288482666
(475) DESCRIBE `cruiselines` 0.00099015235900879
(476) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00022792816162109
(477) DESCRIBE `orchid_image` 0.0007472038269043
(478) DESCRIBE `cruiselines` 0.00094103813171387
(479) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00017809867858887
(480) DESCRIBE `specials` 0.0018031597137451
(481) SELECT `specials`.* FROM `specials` WHERE (id = '1427776') AND (specials.orchid_available = 1) LIMIT 1 0.00034308433532715
(482) DESCRIBE `specials` 0.0017549991607666
(483) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1427776') 0.00026917457580566
(484) DESCRIBE `ships` 0.0012710094451904
(485) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00025701522827148
(486) DESCRIBE `ships` 0.0013270378112793
(487) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00018191337585449
(488) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(489) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016880035400391
(490) DESCRIBE `itineraries` 0.0006871223449707
(491) DESCRIBE `ports` 0.00070095062255859
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021481513977051
(493) DESCRIBE `ports` 0.00067305564880371
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0001981258392334
(495) DESCRIBE `ports` 0.00067520141601562
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018811225891113
(497) DESCRIBE `specialsailingdates` 0.00058102607727051
(498) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1427776') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00045084953308105
(499) DESCRIBE `sailingdates` 0.0006251335144043
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 438777))) 0.00019288063049316
(501) DESCRIBE `ports` 0.00069212913513184
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020909309387207
(503) DESCRIBE `ports` 0.00072002410888672
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018692016601562
(505) DESCRIBE `ports` 0.00066995620727539
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00022506713867188
(507) DESCRIBE `ports` 0.00067305564880371
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0001828670501709
(509) DESCRIBE `ports` 0.00068283081054688
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00023698806762695
(511) DESCRIBE `ports` 0.00070595741271973
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00018405914306641
(513) DESCRIBE `ports` 0.00076389312744141
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00019502639770508
(515) DESCRIBE `ports` 0.00091886520385742
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00017595291137695
(517) DESCRIBE `ports` 0.00066900253295898
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0001990795135498
(519) DESCRIBE `ports` 0.00070285797119141
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00019407272338867
(521) DESCRIBE `ports` 0.00069713592529297
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00020098686218262
(523) DESCRIBE `ports` 0.00073409080505371
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00019693374633789
(525) DESCRIBE `ports` 0.00069904327392578
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0001981258392334
(527) DESCRIBE `ports` 0.00076484680175781
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00023102760314941
(529) DESCRIBE `ports` 0.00066900253295898
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0001988410949707
(531) DESCRIBE `ports` 0.00067400932312012
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00018000602722168
(533) DESCRIBE `ports` 0.00066494941711426
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00019598007202148
(535) DESCRIBE `ports` 0.00072884559631348
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00023102760314941
(537) DESCRIBE `ports` 0.00068879127502441
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00019407272338867
(539) DESCRIBE `ports` 0.0006721019744873
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00017786026000977
(541) DESCRIBE `ports` 0.00070905685424805
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021100044250488
(543) DESCRIBE `ports` 0.00084710121154785
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019407272338867
(545) DESCRIBE `cruises` 0.0014290809631348
(546) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69893))) 0.00028705596923828
(547) DESCRIBE `avid_specials` 0.00062322616577148
(548) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1427776 and class = 'Special') OR (item_id = 69893 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011019706726074
(549) DESCRIBE `cruiselines` 0.0013108253479004
(550) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00036382675170898
(551) DESCRIBE `orchid_image` 0.0013601779937744
(552) DESCRIBE `cruiselines` 0.0016191005706787
(553) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00039386749267578
(554) DESCRIBE `cruises` 0.0023460388183594
(555) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69861') 0.00029587745666504
(556) DESCRIBE `ships` 0.0018630027770996
(557) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00035595893859863
(558) DESCRIBE `ships` 0.0018551349639893
(559) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00031900405883789
(560) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003049373626709
(561) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029301643371582
(562) DESCRIBE `itineraries` 0.00097012519836426
(563) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69861') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058889389038086
(564) DESCRIBE `ports` 0.0010530948638916
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030803680419922
(566) DESCRIBE `ports` 0.00098705291748047
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027894973754883
(568) DESCRIBE `ports` 0.00088095664978027
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018501281738281
(570) DESCRIBE `sailingdates` 0.00063204765319824
(571) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69861') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00035214424133301
(572) DESCRIBE `ports` 0.00095391273498535
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026822090148926
(574) DESCRIBE `ports` 0.0010230541229248
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022602081298828
(576) DESCRIBE `ports` 0.00094413757324219
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00025796890258789
(578) DESCRIBE `ports` 0.0009160041809082
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00026297569274902
(580) DESCRIBE `ports` 0.00095009803771973
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00024604797363281
(582) DESCRIBE `ports` 0.00095295906066895
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00023984909057617
(584) DESCRIBE `ports` 0.00093507766723633
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00024199485778809
(586) DESCRIBE `ports` 0.00087690353393555
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00024294853210449
(588) DESCRIBE `ports` 0.00081086158752441
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025200843811035
(590) DESCRIBE `ports` 0.00094985961914062
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024104118347168
(592) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69861') AND (sailingdate >= '2019-01-01') 0.0081808567047119
(593) DESCRIBE `avid_specials` 0.00069808959960938
(594) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69861 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009150505065918
(595) DESCRIBE `cruiselines` 0.0010008811950684
(596) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00021696090698242
(597) DESCRIBE `orchid_image` 0.00078201293945312
(598) DESCRIBE `cruiselines` 0.00094294548034668
(599) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018405914306641
(600) DESCRIBE `ships` 0.0013961791992188
(601) SELECT `ships`.* FROM `ships` WHERE (id IN ('1330', '287', '124', '262')) ORDER BY FIND_IN_SET(id, '1330,287,124,262') 0.00045108795166016
(602) DESCRIBE `cruisetypes` 0.00059294700622559
(603) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '43') AND (cruises_and_specials.cruiseline_id = '26') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.02733302116394
(604) DESCRIBE `cruiselines` 0.0012497901916504
(605) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00027298927307129
(606) DESCRIBE `destinations` 0.00087690353393555
(607) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00024604797363281
(608) DESCRIBE `destinations` 0.00099396705627441
(609) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00026416778564453
(610) DESCRIBE `cruiselines` 0.000946044921875
(611) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00021004676818848