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

Total elapsed time: 0.34168291091919

# Query Time
(1) connect 0.0005190372467041
(2) DESCRIBE `cruises` 0.0017409324645996
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (56794, 57168, 57253, 57630, 57978, 57980, 58409, 59126, 59127, 59347)) ORDER BY FIND_IN_SET(id, '56794,57168,57253,57630,57978,57980,58409,59126,59127,59347') 0.00086212158203125
(4) DESCRIBE `cruises` 0.0016200542449951
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56794') 0.00025200843811035
(6) DESCRIBE `ships` 0.0013070106506348
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 854))) 0.00026798248291016
(8) DESCRIBE `ships` 0.0012350082397461
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '854') 0.00018405914306641
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(12) DESCRIBE `itineraries` 0.00066614151000977
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56794') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053215026855469
(14) DESCRIBE `ports` 0.0014500617980957
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0003049373626709
(16) DESCRIBE `ports` 0.00098204612731934
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00021982192993164
(18) DESCRIBE `ports` 0.00090193748474121
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00024199485778809
(20) DESCRIBE `sailingdates` 0.00086617469787598
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56794') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063395500183105
(22) DESCRIBE `ports` 0.00073790550231934
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00022387504577637
(24) DESCRIBE `ports` 0.00067305564880371
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00018596649169922
(26) DESCRIBE `ports` 0.00077009201049805
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00024104118347168
(28) DESCRIBE `ports` 0.00070500373840332
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00019097328186035
(30) DESCRIBE `ports` 0.00066018104553223
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00021100044250488
(32) DESCRIBE `ports` 0.00068211555480957
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00019288063049316
(34) DESCRIBE `ports` 0.00066614151000977
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00022196769714355
(36) DESCRIBE `ports` 0.00067901611328125
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00019001960754395
(38) DESCRIBE `ports` 0.00069189071655273
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00021100044250488
(40) DESCRIBE `ports` 0.0006568431854248
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00018906593322754
(42) DESCRIBE `ports` 0.00074410438537598
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00021004676818848
(44) DESCRIBE `ports` 0.00070405006408691
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00017905235290527
(46) DESCRIBE `avid_specials` 0.00061702728271484
(47) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56794 and class = 'Cruise') OR (item_id = 854 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00096988677978516
(48) DESCRIBE `cruiselines` 0.0010080337524414
(49) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00026106834411621
(50) DESCRIBE `orchid_image` 0.00078606605529785
(51) DESCRIBE `cruiselines` 0.00094199180603027
(52) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00021815299987793
(53) DESCRIBE `cruises` 0.0013399124145508
(54) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57168') 0.0002439022064209
(55) DESCRIBE `ships` 0.0012619495391846
(56) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00036382675170898
(57) DESCRIBE `ships` 0.0016529560089111
(58) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00023818016052246
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018692016601562
(60) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(61) DESCRIBE `itineraries` 0.000701904296875
(62) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57168') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053906440734863
(63) DESCRIBE `ports` 0.00077009201049805
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.000244140625
(65) DESCRIBE `ports` 0.00088787078857422
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00022602081298828
(67) DESCRIBE `ports` 0.00085210800170898
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00019598007202148
(69) DESCRIBE `sailingdates` 0.00082898139953613
(70) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57168') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0014688968658447
(71) DESCRIBE `ports` 0.00081110000610352
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00022792816162109
(73) DESCRIBE `ports` 0.00067901611328125
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00020790100097656
(75) DESCRIBE `ports` 0.00071501731872559
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00021600723266602
(77) DESCRIBE `ports` 0.00069499015808105
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00023698806762695
(79) DESCRIBE `ports` 0.00073790550231934
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00020599365234375
(81) DESCRIBE `ports` 0.00074100494384766
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00018501281738281
(83) DESCRIBE `ports` 0.00066685676574707
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00022602081298828
(85) DESCRIBE `ports` 0.00082898139953613
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00021195411682129
(87) DESCRIBE `ports` 0.00068402290344238
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00020599365234375
(89) DESCRIBE `ports` 0.00070691108703613
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00022792816162109
(91) DESCRIBE `ports` 0.00077509880065918
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0002439022064209
(93) DESCRIBE `ports` 0.00074005126953125
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00022602081298828
(95) DESCRIBE `ports` 0.00079703330993652
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.0002288818359375
(97) DESCRIBE `ports` 0.00074005126953125
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00018596649169922
(99) DESCRIBE `ports` 0.00067496299743652
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00020909309387207
(101) DESCRIBE `ports` 0.0006709098815918
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00018715858459473
(103) DESCRIBE `avid_specials` 0.00067901611328125
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57168 and class = 'Cruise') OR (item_id = 81 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.00097990036010742
(105) DESCRIBE `cruiselines` 0.00098609924316406
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00023102760314941
(107) DESCRIBE `orchid_image` 0.00078701972961426
(108) DESCRIBE `cruiselines` 0.0012240409851074
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00023698806762695
(110) DESCRIBE `cruises` 0.0018739700317383
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57253') 0.00028300285339355
(112) DESCRIBE `ships` 0.0013940334320068
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00029683113098145
(114) DESCRIBE `ships` 0.0014550685882568
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00021696090698242
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(118) DESCRIBE `itineraries` 0.00074100494384766
(119) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57253') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010790824890137
(120) DESCRIBE `ports` 0.00073099136352539
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025296211242676
(122) DESCRIBE `ports` 0.00068497657775879
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020098686218262
(124) DESCRIBE `ports` 0.00067901611328125
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018906593322754
(126) DESCRIBE `sailingdates` 0.0006411075592041
(127) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57253') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049209594726562
(128) DESCRIBE `ports` 0.0011131763458252
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026512145996094
(130) DESCRIBE `ports` 0.00070714950561523
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019598007202148
(132) DESCRIBE `ports` 0.00066900253295898
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0002129077911377
(134) DESCRIBE `ports` 0.00072813034057617
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.0001828670501709
(136) DESCRIBE `ports` 0.00070691108703613
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020289421081543
(138) DESCRIBE `ports` 0.00071096420288086
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018405914306641
(140) DESCRIBE `ports` 0.00066995620727539
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020194053649902
(142) DESCRIBE `ports` 0.00066900253295898
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00021004676818848
(144) DESCRIBE `ports` 0.00067496299743652
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020813941955566
(146) DESCRIBE `ports` 0.0006711483001709
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00018215179443359
(148) DESCRIBE `ports` 0.0006868839263916
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020384788513184
(150) DESCRIBE `ports` 0.00074410438537598
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00020909309387207
(152) DESCRIBE `ports` 0.00079703330993652
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00023794174194336
(154) DESCRIBE `ports` 0.00068402290344238
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.0001990795135498
(156) DESCRIBE `ports` 0.00071310997009277
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020599365234375
(158) DESCRIBE `ports` 0.0006859302520752
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018715858459473
(160) DESCRIBE `avid_specials` 0.00065779685974121
(161) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57253 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009620189666748
(162) DESCRIBE `cruiselines` 0.0010919570922852
(163) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0002288818359375
(164) DESCRIBE `orchid_image` 0.00075793266296387
(165) DESCRIBE `cruiselines` 0.0009458065032959
(166) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019288063049316
(167) DESCRIBE `cruises` 0.0016560554504395
(168) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57630') 0.0002748966217041
(169) DESCRIBE `ships` 0.0013260841369629
(170) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1373))) 0.00026702880859375
(171) DESCRIBE `ships` 0.0013110637664795
(172) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1373') 0.00019598007202148
(173) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(175) DESCRIBE `itineraries` 0.00066709518432617
(176) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57630') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046896934509277
(177) DESCRIBE `ports` 0.00075912475585938
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00025486946105957
(179) DESCRIBE `ports` 0.00068211555480957
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020384788513184
(181) DESCRIBE `ports` 0.00069189071655273
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00020003318786621
(183) DESCRIBE `sailingdates` 0.00060796737670898
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57630') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011439323425293
(185) DESCRIBE `ports` 0.00074601173400879
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00022220611572266
(187) DESCRIBE `ports` 0.0007169246673584
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00020503997802734
(189) DESCRIBE `ports` 0.00071310997009277
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1350))) 0.00021100044250488
(191) DESCRIBE `ports` 0.00067281723022461
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1350') 0.00021004676818848
(193) DESCRIBE `ports` 0.00067496299743652
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00020384788513184
(195) DESCRIBE `ports` 0.00069403648376465
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00019001960754395
(197) DESCRIBE `ports` 0.00069403648376465
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00020194053649902
(199) DESCRIBE `ports` 0.00068783760070801
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00018405914306641
(201) DESCRIBE `ports` 0.00068116188049316
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00020408630371094
(203) DESCRIBE `ports` 0.00068998336791992
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00018501281738281
(205) DESCRIBE `ports` 0.0006711483001709
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00020599365234375
(207) DESCRIBE `ports` 0.00066804885864258
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00018811225891113
(209) DESCRIBE `ports` 0.00070905685424805
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1351))) 0.00020194053649902
(211) DESCRIBE `ports` 0.0006709098815918
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1351') 0.00018501281738281
(213) DESCRIBE `ports` 0.0006709098815918
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020194053649902
(215) DESCRIBE `ports` 0.0006711483001709
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0001838207244873
(217) DESCRIBE `avid_specials` 0.00064301490783691
(218) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57630 and class = 'Cruise') OR (item_id = 1373 AND class = 'Ship') OR (item_id = 103 AND class = 'CruiseLine') OR (item_id = 39 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.0011470317840576
(219) DESCRIBE `cruiselines` 0.0010030269622803
(220) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00023293495178223
(221) DESCRIBE `orchid_image` 0.00075793266296387
(222) DESCRIBE `cruiselines` 0.00098109245300293
(223) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00019502639770508
(224) DESCRIBE `cruises` 0.0013120174407959
(225) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57978') 0.00021696090698242
(226) DESCRIBE `ships` 0.0013358592987061
(227) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1184))) 0.00031495094299316
(228) DESCRIBE `ships` 0.0012519359588623
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1184') 0.00019097328186035
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018405914306641
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017380714416504
(232) DESCRIBE `itineraries` 0.00069904327392578
(233) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57978') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071501731872559
(234) DESCRIBE `ports` 0.00072288513183594
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00022006034851074
(236) DESCRIBE `ports` 0.00068306922912598
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00020003318786621
(238) DESCRIBE `ports` 0.0006871223449707
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00018715858459473
(240) DESCRIBE `sailingdates` 0.00061392784118652
(241) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57978') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049090385437012
(242) DESCRIBE `ports` 0.00076818466186523
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00021696090698242
(244) DESCRIBE `ports` 0.00069499015808105
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00018978118896484
(246) DESCRIBE `ports` 0.00067496299743652
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4209))) 0.00020289421081543
(248) DESCRIBE `ports` 0.00075197219848633
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4209') 0.00023722648620605
(250) DESCRIBE `ports` 0.00069689750671387
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2599))) 0.00020694732666016
(252) DESCRIBE `ports` 0.00068807601928711
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2599') 0.00020599365234375
(254) DESCRIBE `ports` 0.0006718635559082
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1649))) 0.00020194053649902
(256) DESCRIBE `ports` 0.0006718635559082
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1649') 0.00018405914306641
(258) DESCRIBE `ports` 0.00067782402038574
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1650))) 0.00020098686218262
(260) DESCRIBE `ports` 0.00072312355041504
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1650') 0.00018596649169922
(262) DESCRIBE `ports` 0.00067687034606934
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00020790100097656
(264) DESCRIBE `ports` 0.00067281723022461
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00018405914306641
(266) DESCRIBE `ports` 0.0008540153503418
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2527))) 0.00022482872009277
(268) DESCRIBE `ports` 0.00070309638977051
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2527') 0.00021696090698242
(270) DESCRIBE `ports` 0.00067710876464844
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2662))) 0.00021791458129883
(272) DESCRIBE `ports` 0.00067687034606934
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2662') 0.00019311904907227
(274) DESCRIBE `ports` 0.00066995620727539
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00020003318786621
(276) DESCRIBE `ports` 0.000701904296875
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00021195411682129
(278) DESCRIBE `ports` 0.00080204010009766
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2878))) 0.00020909309387207
(280) DESCRIBE `ports` 0.00067400932312012
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2878') 0.00018405914306641
(282) DESCRIBE `ports` 0.00066590309143066
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00020003318786621
(284) DESCRIBE `ports` 0.00067710876464844
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00018501281738281
(286) DESCRIBE `avid_specials` 0.00064611434936523
(287) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57978 and class = 'Cruise') OR (item_id = 1184 AND class = 'Ship') OR (item_id = 229 AND class = 'CruiseLine') OR (item_id = 37 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.0011558532714844
(288) DESCRIBE `cruiselines` 0.0010430812835693
(289) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 229))) 0.00024986267089844
(290) DESCRIBE `orchid_image` 0.00076818466186523
(291) DESCRIBE `cruiselines` 0.000946044921875
(292) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '229') 0.00020384788513184
(293) DESCRIBE `cruises` 0.0012989044189453
(294) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57980') 0.00022292137145996
(295) DESCRIBE `ships` 0.0013208389282227
(296) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1183))) 0.0002598762512207
(297) DESCRIBE `ships` 0.0012648105621338
(298) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1183') 0.00019288063049316
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018405914306641
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019216537475586
(301) DESCRIBE `itineraries` 0.00067901611328125
(302) DESCRIBE `ports` 0.00069618225097656
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00021600723266602
(304) DESCRIBE `ports` 0.00069999694824219
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00021100044250488
(306) DESCRIBE `ports` 0.00079989433288574
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00024700164794922
(308) DESCRIBE `sailingdates` 0.00063896179199219
(309) DESCRIBE `ports` 0.00073695182800293
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00021886825561523
(311) DESCRIBE `ports` 0.00068402290344238
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00019001960754395
(313) DESCRIBE `ports` 0.0007319450378418
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4209))) 0.00020813941955566
(315) DESCRIBE `ports` 0.00068902969360352
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4209') 0.00021505355834961
(317) DESCRIBE `ports` 0.00069117546081543
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2883))) 0.00024604797363281
(319) DESCRIBE `ports` 0.00087094306945801
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2883') 0.00023889541625977
(321) DESCRIBE `ports` 0.0010519027709961
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2882))) 0.00022697448730469
(323) DESCRIBE `ports` 0.00070500373840332
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2882') 0.0001990795135498
(325) DESCRIBE `ports` 0.00068092346191406
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2600))) 0.00020718574523926
(327) DESCRIBE `ports` 0.00067591667175293
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2600') 0.00018811225891113
(329) DESCRIBE `ports` 0.00088310241699219
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1649))) 0.00029492378234863
(331) DESCRIBE `ports` 0.0011961460113525
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1649') 0.0003349781036377
(333) DESCRIBE `ports` 0.00068902969360352
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4182))) 0.00024294853210449
(335) DESCRIBE `ports` 0.00071597099304199
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4182') 0.00024914741516113
(337) DESCRIBE `ports` 0.0010459423065186
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2599))) 0.0002739429473877
(339) DESCRIBE `ports` 0.0010311603546143
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2599') 0.00024604797363281
(341) DESCRIBE `ports` 0.0010089874267578
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00020599365234375
(343) DESCRIBE `ports` 0.00069999694824219
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00018501281738281
(345) DESCRIBE `ports` 0.00068306922912598
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00020194053649902
(347) DESCRIBE `ports` 0.00068521499633789
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00018692016601562
(349) DESCRIBE `ports` 0.00067901611328125
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.0002129077911377
(351) DESCRIBE `ports` 0.00074577331542969
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00018787384033203
(353) DESCRIBE `avid_specials` 0.00063586235046387
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57980 and class = 'Cruise') OR (item_id = 1183 AND class = 'Ship') OR (item_id = 229 AND class = 'CruiseLine') OR (item_id = 37 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.0010509490966797
(355) DESCRIBE `cruiselines` 0.00098896026611328
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 229))) 0.0002751350402832
(357) DESCRIBE `orchid_image` 0.0010039806365967
(358) DESCRIBE `cruiselines` 0.0009911060333252
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '229') 0.00021886825561523
(360) DESCRIBE `cruises` 0.0014750957489014
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58409') 0.00024318695068359
(362) DESCRIBE `ships` 0.0013358592987061
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1301))) 0.00029182434082031
(364) DESCRIBE `ships` 0.0013978481292725
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1301') 0.00020098686218262
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018477439880371
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(368) DESCRIBE `itineraries` 0.00069499015808105
(369) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58409') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00047421455383301
(370) DESCRIBE `ports` 0.00072312355041504
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00021696090698242
(372) DESCRIBE `ports` 0.00069499015808105
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00020003318786621
(374) DESCRIBE `ports` 0.0006871223449707
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00018811225891113
(376) DESCRIBE `sailingdates` 0.00064802169799805
(377) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58409') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00082898139953613
(378) DESCRIBE `ports` 0.0007941722869873
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00022792816162109
(380) DESCRIBE `ports` 0.00069999694824219
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00018978118896484
(382) DESCRIBE `ports` 0.0006859302520752
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00020194053649902
(384) DESCRIBE `ports` 0.00074601173400879
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00018405914306641
(386) DESCRIBE `ports` 0.00068998336791992
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00021910667419434
(388) DESCRIBE `ports` 0.00070810317993164
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00020503997802734
(390) DESCRIBE `ports` 0.00069308280944824
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00021719932556152
(392) DESCRIBE `ports` 0.00068306922912598
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00020909309387207
(394) DESCRIBE `ports` 0.00067687034606934
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00020599365234375
(396) DESCRIBE `ports` 0.00069499015808105
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00018501281738281
(398) DESCRIBE `ports` 0.00080704689025879
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00020098686218262
(400) DESCRIBE `ports` 0.00071406364440918
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00018596649169922
(402) DESCRIBE `ports` 0.0007178783416748
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1350))) 0.00020194053649902
(404) DESCRIBE `ports` 0.00067615509033203
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1350') 0.00018405914306641
(406) DESCRIBE `ports` 0.0006718635559082
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020098686218262
(408) DESCRIBE `ports` 0.00067400932312012
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0001828670501709
(410) DESCRIBE `avid_specials` 0.00062918663024902
(411) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58409 and class = 'Cruise') OR (item_id = 1301 AND class = 'Ship') OR (item_id = 103 AND class = 'CruiseLine') OR (item_id = 39 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.00099682807922363
(412) DESCRIBE `cruiselines` 0.0010349750518799
(413) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00022482872009277
(414) DESCRIBE `orchid_image` 0.00076985359191895
(415) DESCRIBE `cruiselines` 0.00093698501586914
(416) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00018501281738281
(417) DESCRIBE `cruises` 0.0013160705566406
(418) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59126') 0.00020980834960938
(419) DESCRIBE `ships` 0.0013511180877686
(420) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1134))) 0.00027990341186523
(421) DESCRIBE `ships` 0.0014011859893799
(422) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1134') 0.00019407272338867
(423) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001838207244873
(424) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017499923706055
(425) DESCRIBE `itineraries` 0.00068306922912598
(426) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59126') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054192543029785
(427) DESCRIBE `ports` 0.00074195861816406
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00022101402282715
(429) DESCRIBE `ports` 0.00076508522033691
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020408630371094
(431) DESCRIBE `ports` 0.00068402290344238
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00019192695617676
(433) DESCRIBE `sailingdates` 0.00062704086303711
(434) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59126') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00071406364440918
(435) DESCRIBE `ports` 0.00096988677978516
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00024104118347168
(437) DESCRIBE `ports` 0.00069284439086914
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00019383430480957
(439) DESCRIBE `ports` 0.00067496299743652
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2456))) 0.00025010108947754
(441) DESCRIBE `ports` 0.0007021427154541
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2456') 0.00018811225891113
(443) DESCRIBE `ports` 0.00069499015808105
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00020194053649902
(445) DESCRIBE `ports` 0.00066995620727539
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00021481513977051
(447) DESCRIBE `ports` 0.00072002410888672
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00020289421081543
(449) DESCRIBE `ports` 0.00073003768920898
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00023794174194336
(451) DESCRIBE `ports` 0.00075793266296387
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3401))) 0.00022387504577637
(453) DESCRIBE `ports` 0.00075507164001465
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3401') 0.0001828670501709
(455) DESCRIBE `ports` 0.00066995620727539
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0002140998840332
(457) DESCRIBE `ports` 0.0006709098815918
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018405914306641
(459) DESCRIBE `ports` 0.00067019462585449
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00020003318786621
(461) DESCRIBE `ports` 0.00070500373840332
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018596649169922
(463) DESCRIBE `avid_specials` 0.00063085556030273
(464) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59126 and class = 'Cruise') OR (item_id = 1134 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010309219360352
(465) DESCRIBE `cruiselines` 0.00099587440490723
(466) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00022482872009277
(467) DESCRIBE `orchid_image` 0.00076889991760254
(468) DESCRIBE `cruises` 0.0013730525970459
(469) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59127') 0.00023698806762695
(470) DESCRIBE `ships` 0.0013079643249512
(471) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1134))) 0.00028491020202637
(472) DESCRIBE `ships` 0.0012471675872803
(473) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1134') 0.00019407272338867
(474) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018405914306641
(475) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017595291137695
(476) DESCRIBE `itineraries` 0.00067615509033203
(477) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59127') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048494338989258
(478) DESCRIBE `ports` 0.000762939453125
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00022196769714355
(480) DESCRIBE `ports` 0.00067281723022461
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00020909309387207
(482) DESCRIBE `ports` 0.00069999694824219
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00019097328186035
(484) DESCRIBE `sailingdates` 0.00061202049255371
(485) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59127') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044393539428711
(486) DESCRIBE `ports` 0.00093507766723633
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00025296211242676
(488) DESCRIBE `ports` 0.00074601173400879
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00023984909057617
(490) DESCRIBE `ports` 0.00088381767272949
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3401))) 0.00025105476379395
(492) DESCRIBE `ports` 0.00090408325195312
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3401') 0.00025105476379395
(494) DESCRIBE `ports` 0.00072693824768066
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00024294853210449
(496) DESCRIBE `ports` 0.00068187713623047
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00018811225891113
(498) DESCRIBE `ports` 0.00070381164550781
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00020289421081543
(500) DESCRIBE `ports` 0.0006868839263916
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00018596649169922
(502) DESCRIBE `ports` 0.00087714195251465
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2456))) 0.00022387504577637
(504) DESCRIBE `ports` 0.00077295303344727
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2456') 0.00040793418884277
(506) DESCRIBE `ports` 0.00087094306945801
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00021600723266602
(508) DESCRIBE `ports` 0.00071597099304199
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018882751464844
(510) DESCRIBE `ports` 0.00067996978759766
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020694732666016
(512) DESCRIBE `ports` 0.00067806243896484
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018501281738281
(514) DESCRIBE `avid_specials` 0.00062084197998047
(515) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59127 and class = 'Cruise') OR (item_id = 1134 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009620189666748
(516) DESCRIBE `cruiselines` 0.00098204612731934
(517) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.0002288818359375
(518) DESCRIBE `orchid_image` 0.00075197219848633
(519) DESCRIBE `cruises` 0.0013458728790283
(520) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59347') 0.00025296211242676
(521) DESCRIBE `ships` 0.0013110637664795
(522) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00025796890258789
(523) DESCRIBE `ships` 0.0012562274932861
(524) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00018501281738281
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018906593322754
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(527) DESCRIBE `itineraries` 0.00067901611328125
(528) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59347') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052499771118164
(529) DESCRIBE `ports` 0.00072407722473145
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0002448558807373
(531) DESCRIBE `ports` 0.00076103210449219
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00022482872009277
(533) DESCRIBE `ports` 0.0007781982421875
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00020098686218262
(535) DESCRIBE `sailingdates` 0.00063204765319824
(536) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59347') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00082993507385254
(537) DESCRIBE `ports` 0.00087594985961914
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00026512145996094
(539) DESCRIBE `ports` 0.00070619583129883
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00019598007202148
(541) DESCRIBE `ports` 0.00067591667175293
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020599365234375
(543) DESCRIBE `ports` 0.00067710876464844
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00021696090698242
(545) DESCRIBE `ports` 0.00072097778320312
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00023698806762695
(547) DESCRIBE `ports` 0.00071001052856445
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018596649169922
(549) DESCRIBE `ports` 0.00069093704223633
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020694732666016
(551) DESCRIBE `ports` 0.00068116188049316
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00019216537475586
(553) DESCRIBE `ports` 0.00073003768920898
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00027608871459961
(555) DESCRIBE `ports` 0.00069594383239746
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018715858459473
(557) DESCRIBE `ports` 0.00075101852416992
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00024890899658203
(559) DESCRIBE `ports` 0.00077009201049805
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00019097328186035
(561) DESCRIBE `ports` 0.00067806243896484
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00021600723266602
(563) DESCRIBE `ports` 0.00070405006408691
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018882751464844
(565) DESCRIBE `avid_specials` 0.0006248950958252
(566) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59347 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 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.001007080078125
(567) DESCRIBE `cruiselines` 0.0010180473327637
(568) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00024795532226562
(569) DESCRIBE `orchid_image` 0.00079202651977539
(570) DESCRIBE `cruiselines` 0.0012528896331787
(571) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00027704238891602
(572) DESCRIBE `cruiselines` 0.0011739730834961
(573) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '171', '31', '18', '101', '183', '20', '7', '8', '144', '96', '12', '120', '221', '103', '50', '268', '15', '29', '37', '91', '110', '232', '208', '28', '206', '33', '131', '156', '49', '220', '118', '24', '114', '262', '204', '181', '187', '258', '256', '47', '36', '212', '30', '16', '151', '191', '14', '249', '153', '211', '195', '238', '141', '174', '216', '35', '239', '4', '213', '113', '159', '168', '196', '188', '146', '136', '90', '237', '209', '73', '180', '229', '170', '59', '115', '225', '140', '95', '219', '57', '269', '108', '231', '52', '184', '132', '276', '248', '38', '88', '275', '182', '261', '264', '244', '82', '230', '105', '266', '116', '39', '64', '48', '119', '240', '224', '245', '210', '134', '251')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,171,31,18,101,183,20,7,8,144,96,12,120,221,103,50,268,15,29,37,91,110,232,208,28,206,33,131,156,49,220,118,24,114,262,204,181,187,258,256,47,36,212,30,16,151,191,14,249,153,211,195,238,141,174,216,35,239,4,213,113,159,168,196,188,146,136,90,237,209,73,180,229,170,59,115,225,140,95,219,57,269,108,231,52,184,132,276,248,38,88,275,182,261,264,244,82,230,105,266,116,39,64,48,119,240,224,245,210,134,251') 0.0029218196868896
(574) DESCRIBE `ships` 0.0017979145050049
(575) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '977', '1199', '1291', '1588', '407', '517', '726', '258', '1237', '27', '1424', '22', '461', '28', '1599', '21', '1422', '817', '1423', '1594', '393', '1419', '1420', '1421', '1418', '1135', '349', '1359', '452', '780', '113', '766', '265', '24', '11', '1574', '439', '542', '9', '10', '207', '1245', '585', '770', '330', '404', '1272', '455', '974', '124', '1067', '1455', '792', '1460', '553', '871', '1215', '797', '5', '739', '674', '573', '25', '1572', '3', '520', '855', '1193', '1607', '14', '78', '434', '711', '340', '1021', '253', '1302', '1402', '1586', '390', '559', '748', '1284', '43', '580', '1172', '1581', '462', '765', '791', '1320', '1323', '285', '874', '658', '405', '590', '678', '1139', '582', '286', '327', '526', '883', '970', '731', '859', '454', '854', '81', '406', '823', '722', '1236', '1614', '850', '1027', '1415', '1569', '31', '114', '993', '1348', '37', '1319', '30', '34', '35', '36', '38', '39', '82', '378', '403', '547', '1008', '1012', '1326', '1327', '1330', '1678', '160', '163', '333', '351', '451', '784', '1205', '1325', '348', '657', '966', '1454', '1575', '338', '84', '262', '325', '701', '1143', '521', '683', '352', '508', '732', '287', '1088', '1134', '1151', '1157', '1318', '4', '111', '610', '1075', '1108', '1367', '1471', '1579', '290', '1032', '1345', '314', '751', '1214', '1223', '1233', '1308', '119', '335', '1013', '1145', '1321', '93', '162', '1405', '651', '673', '1137', '1144', '1344', '1376', '1615', '291', '394', '483', '852', '988', '1149', '1343', '1587', '45', '116', '1452', '1453', '1604', '152', '401', '545', '1095', '98', '441', '1025', '1090', '1136', '1283', '1373', '1724', '626', '716', '882', '968', '1163', '1168', '1243', '1301', '1413', '59', '75', '150', '768', '769', '986', '1292', '1398', '1526', '148', '149', '151', '669', '905', '1382', '1417', '1448', '1492', '639', '1150', '1176', '1226', '1449', '201', '996', '324', '601', '776', '973', '1647', '223', '417', '616', '837', '1026', '1241', '1411', '1458', '1552', '1602', '108', '313', '389', '467', '1231', '1489', '266', '341', '857', '74', '851', '954', '1029', '1034', '1285', '1366', '1496', '1609', '1711', '421', '666', '704', '885', '1055', '1152', '1230', '1260', '1362', '1368', '1372', '480', '574', '888', '1383', '1384', '1470', '1516', '1628', '105', '147', '1224', '1408', '1717', '503', '749', '790', '1054', '1154', '1208', '1505', '1518', '1571', '1611', '208', '1672', '205', '332', '494', '652', '796', '818', '884', '1068', '1253', '1501', '1521', '1612', '123', '422', '618', '836', '985', '1148', '1486', '493', '937', '938', '1517', '1522', '1632', '204', '212', '423', '448', '485', '1409', '1682', '1138', '1410', '1593', '1639', '66', '375', '994', '995', '1141', '972', '1017', '1303', '1461', '1539', '1627', '1064', '1514', '1601', '1613', '420', '1073', '1254', '1437', '453', '1028', '1229', '1481', '1515', '1716', '487', '665', '1175', '1259', '1412', '1684', '958', '1189', '1262', '1619', '70', '717', '775', '795', '1159', '1713', '1715', '715', '1053', '1266', '1439', '1714', '738', '1011', '1240', '1704', '69', '944', '1274', '1385', '1606', '419', '1106', '1110', '1183', '1184', '1192', '1347', '1360', '1361', '1459', '808', '1058', '1089', '1160', '1195', '1338', '1339', '1342', '1474', '1543', '1545', '62', '488', '1322', '1708', '798', '886', '1071', '1087', '1158', '1298', '1311', '1404', '1645', '1649', '1723', '225', '1132', '1310', '1697', '1729', '17', '299', '300', '555', '997', '1023', '1043', '1355', '1358', '1451', '1629', '479', '672', '821', '1047', '1063', '1217', '1257', '1312', '1540', '288', '692', '707', '1109', '1140', '1167', '1282', '1350', '1426', '1546', '1558')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,977,1199,1291,1588,407,517,726,258,1237,27,1424,22,461,28,1599,21,1422,817,1423,1594,393,1419,1420,1421,1418,1135,349,1359,452,780,113,766,265,24,11,1574,439,542,9,10,207,1245,585,770,330,404,1272,455,974,124,1067,1455,792,1460,553,871,1215,797,5,739,674,573,25,1572,3,520,855,1193,1607,14,78,434,711,340,1021,253,1302,1402,1586,390,559,748,1284,43,580,1172,1581,462,765,791,1320,1323,285,874,658,405,590,678,1139,582,286,327,526,883,970,731,859,454,854,81,406,823,722,1236,1614,850,1027,1415,1569,31,114,993,1348,37,1319,30,34,35,36,38,39,82,378,403,547,1008,1012,1326,1327,1330,1678,160,163,333,351,451,784,1205,1325,348,657,966,1454,1575,338,84,262,325,701,1143,521,683,352,508,732,287,1088,1134,1151,1157,1318,4,111,610,1075,1108,1367,1471,1579,290,1032,1345,314,751,1214,1223,1233,1308,119,335,1013,1145,1321,93,162,1405,651,673,1137,1144,1344,1376,1615,291,394,483,852,988,1149,1343,1587,45,116,1452,1453,1604,152,401,545,1095,98,441,1025,1090,1136,1283,1373,1724,626,716,882,968,1163,1168,1243,1301,1413,59,75,150,768,769,986,1292,1398,1526,148,149,151,669,905,1382,1417,1448,1492,639,1150,1176,1226,1449,201,996,324,601,776,973,1647,223,417,616,837,1026,1241,1411,1458,1552,1602,108,313,389,467,1231,1489,266,341,857,74,851,954,1029,1034,1285,1366,1496,1609,1711,421,666,704,885,1055,1152,1230,1260,1362,1368,1372,480,574,888,1383,1384,1470,1516,1628,105,147,1224,1408,1717,503,749,790,1054,1154,1208,1505,1518,1571,1611,208,1672,205,332,494,652,796,818,884,1068,1253,1501,1521,1612,123,422,618,836,985,1148,1486,493,937,938,1517,1522,1632,204,212,423,448,485,1409,1682,1138,1410,1593,1639,66,375,994,995,1141,972,1017,1303,1461,1539,1627,1064,1514,1601,1613,420,1073,1254,1437,453,1028,1229,1481,1515,1716,487,665,1175,1259,1412,1684,958,1189,1262,1619,70,717,775,795,1159,1713,1715,715,1053,1266,1439,1714,738,1011,1240,1704,69,944,1274,1385,1606,419,1106,1110,1183,1184,1192,1347,1360,1361,1459,808,1058,1089,1160,1195,1338,1339,1342,1474,1543,1545,62,488,1322,1708,798,886,1071,1087,1158,1298,1311,1404,1645,1649,1723,225,1132,1310,1697,1729,17,299,300,555,997,1023,1043,1355,1358,1451,1629,479,672,821,1047,1063,1217,1257,1312,1540,288,692,707,1109,1140,1167,1282,1350,1426,1546,1558') 0.022311210632324
(576) DESCRIBE `cruisetypes` 0.00099301338195801
(577) DESCRIBE `destinations` 0.00096011161804199
(578) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '26', '28', '55', '11', '21', '38', '40', '49', '7', '48', '44', '30', '29', '10', '34', '45', '56', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,26,28,55,11,21,38,40,49,7,48,44,30,29,10,34,45,56,52,46,32') 0.0011770725250244