or, enquire about your chosen options

  1. Ovation of the Seas coming to Australia & New Zealand
  2. Heritage Expeditions: Secrets of Melanesia Cruise
  3. Vietnam Cruise a ‘must do’
  4. Explorer of the Seas to visit New Zealand
  5. Panama Canal – Norwegian Star

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

Total elapsed time: 0.39738154411316

# Query Time
(1) connect 0.00045514106750488
(2) DESCRIBE `cruises` 0.0017240047454834
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62216, 56813, 44079, 62015, 58506, 60480, 62215, 62015, 60479, 44079)) ORDER BY FIND_IN_SET(id, '62216,56813,44079,62015,58506,60480,62215,62015,60479,44079') 0.0010771751403809
(4) DESCRIBE `specials` 0.0020489692687988
(5) DESCRIBE `specials` 0.0018630027770996
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1224249') 0.00021100044250488
(7) DESCRIBE `ships` 0.0013089179992676
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1460))) 0.00025486946105957
(9) DESCRIBE `ships` 0.001291036605835
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1460') 0.00017690658569336
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017285346984863
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022220611572266
(13) DESCRIBE `itineraries` 0.00068497657775879
(14) DESCRIBE `ports` 0.00067806243896484
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020194053649902
(16) DESCRIBE `ports` 0.00069212913513184
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018620491027832
(18) DESCRIBE `ports` 0.00066709518432617
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00016903877258301
(20) DESCRIBE `specialsailingdates` 0.00056195259094238
(21) DESCRIBE `sailingdates` 0.00060200691223145
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390874))) 0.00031399726867676
(23) DESCRIBE `sailingdates` 0.00063896179199219
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390875))) 0.00020408630371094
(25) DESCRIBE `sailingdates` 0.00062394142150879
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390876))) 0.00018191337585449
(27) DESCRIBE `sailingdates` 0.00061297416687012
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390877))) 0.00018095970153809
(29) DESCRIBE `sailingdates` 0.00059413909912109
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390878))) 0.00018501281738281
(31) DESCRIBE `ports` 0.0006859302520752
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00021004676818848
(33) DESCRIBE `ports` 0.00073909759521484
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00016903877258301
(35) DESCRIBE `ports` 0.00065898895263672
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00018692016601562
(37) DESCRIBE `ports` 0.00065398216247559
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00018501281738281
(39) DESCRIBE `ports` 0.00084900856018066
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00020289421081543
(41) DESCRIBE `ports` 0.0006861686706543
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00018715858459473
(43) DESCRIBE `ports` 0.00068497657775879
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00020289421081543
(45) DESCRIBE `ports` 0.00091695785522461
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00022578239440918
(47) DESCRIBE `ports` 0.0009310245513916
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00024819374084473
(49) DESCRIBE `ports` 0.00093293190002441
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00021219253540039
(51) DESCRIBE `ports` 0.00079488754272461
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00019097328186035
(53) DESCRIBE `ports` 0.00068998336791992
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00016903877258301
(55) DESCRIBE `ports` 0.0006718635559082
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00028181076049805
(57) DESCRIBE `ports` 0.00097179412841797
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00023603439331055
(59) DESCRIBE `ports` 0.00093412399291992
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00026512145996094
(61) DESCRIBE `ports` 0.00097012519836426
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00022506713867188
(63) DESCRIBE `ports` 0.0009760856628418
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00026082992553711
(65) DESCRIBE `ports` 0.00099301338195801
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.0002291202545166
(67) DESCRIBE `ports` 0.00097894668579102
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00024914741516113
(69) DESCRIBE `ports` 0.00097894668579102
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00021886825561523
(71) DESCRIBE `ports` 0.0010321140289307
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00020289421081543
(73) DESCRIBE `ports` 0.0006868839263916
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00016999244689941
(75) DESCRIBE `ports` 0.0006709098815918
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00022482872009277
(77) DESCRIBE `ports` 0.0006868839263916
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00019693374633789
(79) DESCRIBE `cruises` 0.001317024230957
(80) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62216))) 0.00028300285339355
(81) DESCRIBE `avid_specials` 0.00062704086303711
(82) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1224249 and class = 'Special') OR (item_id = 62216 and class = 'Cruise') OR (item_id = 1460 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 54 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.00075483322143555
(83) DESCRIBE `cruiselines` 0.00096893310546875
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.0002131462097168
(85) DESCRIBE `orchid_image` 0.00079107284545898
(86) DESCRIBE `specials` 0.0020298957824707
(87) DESCRIBE `specials` 0.0018980503082275
(88) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1196553') 0.0001990795135498
(89) DESCRIBE `ships` 0.0012869834899902
(90) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1151))) 0.00024890899658203
(91) DESCRIBE `ships` 0.0012638568878174
(92) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1151') 0.00017905235290527
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016999244689941
(94) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017786026000977
(95) DESCRIBE `itineraries` 0.0006558895111084
(96) DESCRIBE `ports` 0.00068306922912598
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0001990795135498
(98) DESCRIBE `ports` 0.00070405006408691
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00023198127746582
(100) DESCRIBE `ports` 0.00066685676574707
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00016999244689941
(102) DESCRIBE `specialsailingdates` 0.00056195259094238
(103) DESCRIBE `sailingdates` 0.00062179565429688
(104) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 356631))) 0.00031304359436035
(105) DESCRIBE `sailingdates` 0.00059294700622559
(106) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 356632))) 0.00018692016601562
(107) DESCRIBE `ports` 0.0006859302520752
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00019097328186035
(109) DESCRIBE `ports` 0.00068783760070801
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00017404556274414
(111) DESCRIBE `ports` 0.00067400932312012
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00019001960754395
(113) DESCRIBE `ports` 0.0007169246673584
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00017213821411133
(115) DESCRIBE `ports` 0.00069212913513184
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1578))) 0.00021505355834961
(117) DESCRIBE `ports` 0.00066709518432617
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1578') 0.0001680850982666
(119) DESCRIBE `ports` 0.00069713592529297
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019216537475586
(121) DESCRIBE `ports` 0.00066995620727539
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00017499923706055
(123) DESCRIBE `ports` 0.0006871223449707
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019598007202148
(125) DESCRIBE `ports` 0.00068807601928711
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00017595291137695
(127) DESCRIBE `ports` 0.00068998336791992
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00019097328186035
(129) DESCRIBE `ports` 0.00069403648376465
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00021219253540039
(131) DESCRIBE `ports` 0.00066399574279785
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00019001960754395
(133) DESCRIBE `ports` 0.00068807601928711
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00017309188842773
(135) DESCRIBE `ports` 0.00070500373840332
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00019121170043945
(137) DESCRIBE `ports` 0.00068497657775879
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.0001678466796875
(139) DESCRIBE `ports` 0.00066399574279785
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00019502639770508
(141) DESCRIBE `ports` 0.00069999694824219
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00017499923706055
(143) DESCRIBE `ports` 0.00068187713623047
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00021004676818848
(145) DESCRIBE `ports` 0.00066995620727539
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0001671314239502
(147) DESCRIBE `cruises` 0.0013439655303955
(148) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 56813))) 0.00029206275939941
(149) DESCRIBE `avid_specials` 0.00060701370239258
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1196553 and class = 'Special') OR (item_id = 56813 and class = 'Cruise') OR (item_id = 1151 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.00083613395690918
(151) DESCRIBE `cruiselines` 0.00094199180603027
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00021696090698242
(153) DESCRIBE `orchid_image` 0.00077509880065918
(154) DESCRIBE `cruiselines` 0.00096392631530762
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00017094612121582
(156) DESCRIBE `specials` 0.0020570755004883
(157) DESCRIBE `specials` 0.0019159317016602
(158) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1213812') 0.00021195411682129
(159) DESCRIBE `ships` 0.0012900829315186
(160) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.0002589225769043
(161) DESCRIBE `ships` 0.0012381076812744
(162) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00018310546875
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018000602722168
(165) DESCRIBE `itineraries` 0.00066900253295898
(166) DESCRIBE `ports` 0.00066709518432617
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0001978874206543
(168) DESCRIBE `ports` 0.00066518783569336
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019383430480957
(170) DESCRIBE `ports` 0.00067591667175293
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017619132995605
(172) DESCRIBE `specialsailingdates` 0.00056290626525879
(173) DESCRIBE `sailingdates` 0.00061798095703125
(174) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 344594))) 0.00032305717468262
(175) DESCRIBE `sailingdates` 0.00059199333190918
(176) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 344596))) 0.0001990795135498
(177) DESCRIBE `sailingdates` 0.00060009956359863
(178) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 344598))) 0.00021195411682129
(179) DESCRIBE `sailingdates` 0.00063490867614746
(180) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379632))) 0.00027203559875488
(181) DESCRIBE `sailingdates` 0.00062298774719238
(182) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379633))) 0.00019502639770508
(183) DESCRIBE `sailingdates` 0.00060296058654785
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379634))) 0.00018692016601562
(185) DESCRIBE `sailingdates` 0.00061202049255371
(186) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379635))) 0.00018501281738281
(187) DESCRIBE `sailingdates` 0.00060200691223145
(188) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379636))) 0.00019311904907227
(189) DESCRIBE `sailingdates` 0.00061488151550293
(190) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379637))) 0.00018596649169922
(191) DESCRIBE `sailingdates` 0.00060915946960449
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379638))) 0.00019288063049316
(193) DESCRIBE `sailingdates` 0.00060510635375977
(194) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379639))) 0.00019192695617676
(195) DESCRIBE `ports` 0.0006861686706543
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0001990795135498
(197) DESCRIBE `ports` 0.00067591667175293
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017595291137695
(199) DESCRIBE `ports` 0.00068211555480957
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00020003318786621
(201) DESCRIBE `ports` 0.00069189071655273
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00018692016601562
(203) DESCRIBE `ports` 0.00066995620727539
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00020909309387207
(205) DESCRIBE `ports` 0.00068998336791992
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00018095970153809
(207) DESCRIBE `ports` 0.00070285797119141
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00019693374633789
(209) DESCRIBE `ports` 0.00066995620727539
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00017595291137695
(211) DESCRIBE `ports` 0.00068807601928711
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00019717216491699
(213) DESCRIBE `ports` 0.0006718635559082
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00018095970153809
(215) DESCRIBE `ports` 0.00066900253295898
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00022101402282715
(217) DESCRIBE `ports` 0.00067996978759766
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017905235290527
(219) DESCRIBE `ports` 0.00067281723022461
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020003318786621
(221) DESCRIBE `ports` 0.00067806243896484
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00019407272338867
(223) DESCRIBE `ports` 0.00065422058105469
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00020098686218262
(225) DESCRIBE `ports` 0.00067782402038574
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00017714500427246
(227) DESCRIBE `ports` 0.00066590309143066
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0001988410949707
(229) DESCRIBE `ports` 0.00069093704223633
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018811225891113
(231) DESCRIBE `cruises` 0.0012478828430176
(232) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 44079))) 0.00025796890258789
(233) DESCRIBE `avid_specials` 0.00061392784118652
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1213812 and class = 'Special') OR (item_id = 44079 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 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.00074386596679688
(235) DESCRIBE `cruiselines` 0.0009300708770752
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00020909309387207
(237) DESCRIBE `orchid_image` 0.00078606605529785
(238) DESCRIBE `cruiselines` 0.00093603134155273
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00017499923706055
(240) DESCRIBE `specials` 0.0033400058746338
(241) DESCRIBE `specials` 0.0020480155944824
(242) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1177302') 0.00025701522827148
(243) DESCRIBE `ships` 0.0013148784637451
(244) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1456))) 0.00027298927307129
(245) DESCRIBE `ships` 0.0012719631195068
(246) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1456') 0.00017714500427246
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016617774963379
(249) DESCRIBE `itineraries` 0.00066709518432617
(250) DESCRIBE `ports` 0.00068092346191406
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00019192695617676
(252) DESCRIBE `ports` 0.00066590309143066
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018191337585449
(254) DESCRIBE `ports` 0.00066280364990234
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0001828670501709
(256) DESCRIBE `specialsailingdates` 0.00056099891662598
(257) DESCRIBE `sailingdates` 0.00059390068054199
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390377))) 0.00021600723266602
(259) DESCRIBE `ports` 0.00070500373840332
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018906593322754
(261) DESCRIBE `ports` 0.00068497657775879
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00016903877258301
(263) DESCRIBE `ports` 0.00067305564880371
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018692016601562
(265) DESCRIBE `ports` 0.00069499015808105
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00017499923706055
(267) DESCRIBE `ports` 0.00066900253295898
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0001990795135498
(269) DESCRIBE `ports` 0.00067496299743652
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0001671314239502
(271) DESCRIBE `ports` 0.00069999694824219
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00019502639770508
(273) DESCRIBE `ports` 0.00070500373840332
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.0001671314239502
(275) DESCRIBE `ports` 0.00066518783569336
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00022697448730469
(277) DESCRIBE `ports` 0.0006718635559082
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.0001680850982666
(279) DESCRIBE `ports` 0.00066399574279785
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018692016601562
(281) DESCRIBE `ports` 0.00067687034606934
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00016689300537109
(283) DESCRIBE `ports` 0.00068092346191406
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018501281738281
(285) DESCRIBE `ports` 0.00066685676574707
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00016689300537109
(287) DESCRIBE `ports` 0.0006859302520752
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00019502639770508
(289) DESCRIBE `ports` 0.00072383880615234
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.0001680850982666
(291) DESCRIBE `ports` 0.00067615509033203
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00020098686218262
(293) DESCRIBE `ports` 0.00068998336791992
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00017189979553223
(295) DESCRIBE `ports` 0.0006709098815918
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020289421081543
(297) DESCRIBE `ports` 0.00066685676574707
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0001680850982666
(299) DESCRIBE `ports` 0.00068902969360352
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00019311904907227
(301) DESCRIBE `ports` 0.00071501731872559
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00018501281738281
(303) DESCRIBE `ports` 0.00067806243896484
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00019383430480957
(305) DESCRIBE `ports` 0.00066304206848145
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00017189979553223
(307) DESCRIBE `cruises` 0.0013349056243896
(308) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62015))) 0.0003359317779541
(309) DESCRIBE `avid_specials` 0.00065994262695312
(310) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1177302 and class = 'Special') OR (item_id = 62015 and class = 'Cruise') OR (item_id = 1456 AND class = 'Ship') OR (item_id = 263 AND class = 'CruiseLine') OR (item_id = 54 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.00076103210449219
(311) DESCRIBE `cruiselines` 0.00097799301147461
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00020503997802734
(313) DESCRIBE `orchid_image` 0.0008080005645752
(314) DESCRIBE `cruiselines` 0.00097179412841797
(315) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '263') 0.00017690658569336
(316) DESCRIBE `specials` 0.0022041797637939
(317) DESCRIBE `specials` 0.0019710063934326
(318) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1143213') 0.0002140998840332
(319) DESCRIBE `ships` 0.0012950897216797
(320) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 650))) 0.00026702880859375
(321) DESCRIBE `ships` 0.0012538433074951
(322) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '650') 0.00017595291137695
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018596649169922
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00015997886657715
(325) DESCRIBE `itineraries` 0.0006558895111084
(326) DESCRIBE `ports` 0.0006871223449707
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00022101402282715
(328) DESCRIBE `ports` 0.00066494941711426
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020098686218262
(330) DESCRIBE `ports` 0.00066089630126953
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00020003318786621
(332) DESCRIBE `specialsailingdates` 0.0005640983581543
(333) DESCRIBE `sailingdates` 0.00060796737670898
(334) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 368707))) 0.00018906593322754
(335) DESCRIBE `sailingdates` 0.00059413909912109
(336) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 368708))) 0.00018405914306641
(337) DESCRIBE `sailingdates` 0.00061488151550293
(338) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 368709))) 0.00018215179443359
(339) DESCRIBE `sailingdates` 0.00059390068054199
(340) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 368710))) 0.00017714500427246
(341) DESCRIBE `sailingdates` 0.0006110668182373
(342) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 368711))) 0.00018310546875
(343) DESCRIBE `sailingdates` 0.00059103965759277
(344) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 368712))) 0.00018191337585449
(345) DESCRIBE `ports` 0.00068092346191406
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020503997802734
(347) DESCRIBE `ports` 0.00067901611328125
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017380714416504
(349) DESCRIBE `ports` 0.00067591667175293
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.0001990795135498
(351) DESCRIBE `ports` 0.00067901611328125
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00018596649169922
(353) DESCRIBE `ports` 0.00067687034606934
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5158))) 0.00019407272338867
(355) DESCRIBE `ports` 0.00066208839416504
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5158') 0.00018215179443359
(357) DESCRIBE `ports` 0.00068402290344238
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00019693374633789
(359) DESCRIBE `ports` 0.00070500373840332
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00017690658569336
(361) DESCRIBE `ports` 0.00067710876464844
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00019407272338867
(363) DESCRIBE `ports` 0.00070500373840332
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00018405914306641
(365) DESCRIBE `ports` 0.00070309638977051
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00019311904907227
(367) DESCRIBE `ports` 0.00069379806518555
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017714500427246
(369) DESCRIBE `ports` 0.0006711483001709
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00024294853210449
(371) DESCRIBE `ports` 0.0006709098815918
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017404556274414
(373) DESCRIBE `ports` 0.00068092346191406
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020384788513184
(375) DESCRIBE `ports` 0.00067687034606934
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017809867858887
(377) DESCRIBE `cruises` 0.0013020038604736
(378) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58506))) 0.00029993057250977
(379) DESCRIBE `avid_specials` 0.00061392784118652
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1143213 and class = 'Special') OR (item_id = 58506 and class = 'Cruise') OR (item_id = 650 AND class = 'Ship') OR (item_id = 147 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.00075101852416992
(381) DESCRIBE `cruiselines` 0.00092196464538574
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 147))) 0.00021815299987793
(383) DESCRIBE `orchid_image` 0.00076103210449219
(384) DESCRIBE `cruiselines` 0.00094795227050781
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '147') 0.00017714500427246
(386) DESCRIBE `specials` 0.0020341873168945
(387) DESCRIBE `specials` 0.0018870830535889
(388) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1210323') 0.0001988410949707
(389) DESCRIBE `ships` 0.0013229846954346
(390) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00025200843811035
(391) DESCRIBE `ships` 0.0012640953063965
(392) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.0002288818359375
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023198127746582
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019407272338867
(395) DESCRIBE `itineraries` 0.00089097023010254
(396) DESCRIBE `ports` 0.00069999694824219
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020503997802734
(398) DESCRIBE `ports` 0.00066208839416504
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019311904907227
(400) DESCRIBE `ports` 0.00067806243896484
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00020408630371094
(402) DESCRIBE `specialsailingdates` 0.00058293342590332
(403) DESCRIBE `sailingdates` 0.00060701370239258
(404) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383264))) 0.0003199577331543
(405) DESCRIBE `ports` 0.00068211555480957
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019311904907227
(407) DESCRIBE `ports` 0.00070309638977051
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018405914306641
(409) DESCRIBE `ports` 0.00066804885864258
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5008))) 0.00020313262939453
(411) DESCRIBE `ports` 0.00068807601928711
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5008') 0.00020599365234375
(413) DESCRIBE `ports` 0.00066089630126953
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00019693374633789
(415) DESCRIBE `ports` 0.00068402290344238
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00016903877258301
(417) DESCRIBE `ports` 0.00068306922912598
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00019598007202148
(419) DESCRIBE `ports` 0.00066995620727539
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00019097328186035
(421) DESCRIBE `ports` 0.00066184997558594
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00022101402282715
(423) DESCRIBE `ports` 0.0007021427154541
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00019407272338867
(425) DESCRIBE `ports` 0.00081706047058105
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00020718574523926
(427) DESCRIBE `ports` 0.00066804885864258
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.0001828670501709
(429) DESCRIBE `ports` 0.00075984001159668
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019311904907227
(431) DESCRIBE `ports` 0.00066590309143066
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00016903877258301
(433) DESCRIBE `cruises` 0.0013389587402344
(434) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 60480))) 0.00031113624572754
(435) DESCRIBE `avid_specials` 0.00062394142150879
(436) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1210323 and class = 'Special') OR (item_id = 60480 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 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.00076007843017578
(437) DESCRIBE `cruiselines` 0.00098204612731934
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00023293495178223
(439) DESCRIBE `orchid_image` 0.00076985359191895
(440) DESCRIBE `cruiselines` 0.0010151863098145
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00020813941955566
(442) DESCRIBE `specials` 0.0020380020141602
(443) DESCRIBE `specials` 0.0019099712371826
(444) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1224246') 0.00020098686218262
(445) DESCRIBE `ships` 0.0012650489807129
(446) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1460))) 0.00023913383483887
(447) DESCRIBE `ships` 0.0012609958648682
(448) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1460') 0.00017404556274414
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018119812011719
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(451) DESCRIBE `itineraries` 0.00065803527832031
(452) DESCRIBE `ports` 0.00067901611328125
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00022292137145996
(454) DESCRIBE `ports` 0.00068378448486328
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.0002129077911377
(456) DESCRIBE `ports` 0.00066900253295898
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00019192695617676
(458) DESCRIBE `specialsailingdates` 0.00056982040405273
(459) DESCRIBE `sailingdates` 0.00060009956359863
(460) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390840))) 0.00022292137145996
(461) DESCRIBE `sailingdates` 0.00059199333190918
(462) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390841))) 0.00018501281738281
(463) DESCRIBE `sailingdates` 0.00060200691223145
(464) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390842))) 0.000244140625
(465) DESCRIBE `sailingdates` 0.0005950927734375
(466) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390843))) 0.00019598007202148
(467) DESCRIBE `ports` 0.0006868839263916
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00022101402282715
(469) DESCRIBE `ports` 0.00068211555480957
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00021004676818848
(471) DESCRIBE `ports` 0.00070595741271973
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00019407272338867
(473) DESCRIBE `ports` 0.00067281723022461
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00016689300537109
(475) DESCRIBE `ports` 0.00068211555480957
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00019097328186035
(477) DESCRIBE `ports` 0.00087714195251465
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00023317337036133
(479) DESCRIBE `ports` 0.0010690689086914
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00020289421081543
(481) DESCRIBE `ports` 0.00075101852416992
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00017189979553223
(483) DESCRIBE `ports` 0.00067305564880371
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00019598007202148
(485) DESCRIBE `ports` 0.0006718635559082
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00018501281738281
(487) DESCRIBE `ports` 0.00074195861816406
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018906593322754
(489) DESCRIBE `ports` 0.00067996978759766
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00016689300537109
(491) DESCRIBE `ports` 0.00066995620727539
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018692016601562
(493) DESCRIBE `ports` 0.0006721019744873
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0001680850982666
(495) DESCRIBE `ports` 0.0006718635559082
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00020909309387207
(497) DESCRIBE `ports` 0.0006871223449707
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00017404556274414
(499) DESCRIBE `ports` 0.00068998336791992
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00020098686218262
(501) DESCRIBE `ports` 0.00081110000610352
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.0003960132598877
(503) DESCRIBE `ports` 0.0011918544769287
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00021910667419434
(505) DESCRIBE `ports` 0.00068807601928711
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00017213821411133
(507) DESCRIBE `ports` 0.0006721019744873
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018906593322754
(509) DESCRIBE `ports` 0.00068092346191406
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0001671314239502
(511) DESCRIBE `cruises` 0.0013229846954346
(512) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62215))) 0.00028395652770996
(513) DESCRIBE `avid_specials` 0.00069403648376465
(514) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1224246 and class = 'Special') OR (item_id = 62215 and class = 'Cruise') OR (item_id = 1460 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 54 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.00075292587280273
(515) DESCRIBE `cruiselines` 0.00098586082458496
(516) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.0002129077911377
(517) DESCRIBE `orchid_image` 0.00077199935913086
(518) DESCRIBE `specials` 0.0020351409912109
(519) DESCRIBE `specials` 0.0019102096557617
(520) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1177300') 0.00019693374633789
(521) DESCRIBE `ships` 0.0013110637664795
(522) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1456))) 0.00024199485778809
(523) DESCRIBE `ships` 0.0012969970703125
(524) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1456') 0.00019598007202148
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018787384033203
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016498565673828
(527) DESCRIBE `itineraries` 0.00070977210998535
(528) DESCRIBE `ports` 0.00071001052856445
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020289421081543
(530) DESCRIBE `ports` 0.00069308280944824
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00022697448730469
(532) DESCRIBE `ports` 0.00068306922912598
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00017499923706055
(534) DESCRIBE `specialsailingdates` 0.00057291984558105
(535) DESCRIBE `sailingdates` 0.00060892105102539
(536) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390378))) 0.00021815299987793
(537) DESCRIBE `sailingdates` 0.00060701370239258
(538) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390379))) 0.00017881393432617
(539) DESCRIBE `ports` 0.00068497657775879
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018811225891113
(541) DESCRIBE `ports` 0.00071287155151367
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00017905235290527
(543) DESCRIBE `ports` 0.00068283081054688
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018692016601562
(545) DESCRIBE `ports` 0.00068998336791992
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00016617774963379
(547) DESCRIBE `ports` 0.00070500373840332
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0001990795135498
(549) DESCRIBE `ports` 0.00073409080505371
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00017309188842773
(551) DESCRIBE `ports` 0.00067806243896484
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.0002131462097168
(553) DESCRIBE `ports` 0.00067496299743652
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.0001671314239502
(555) DESCRIBE `ports` 0.00066900253295898
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00019693374633789
(557) DESCRIBE `ports` 0.00069499015808105
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00018501281738281
(559) DESCRIBE `ports` 0.0007011890411377
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018596649169922
(561) DESCRIBE `ports` 0.00067305564880371
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00016498565673828
(563) DESCRIBE `ports` 0.00072789192199707
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018715858459473
(565) DESCRIBE `ports` 0.00068497657775879
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017714500427246
(567) DESCRIBE `ports` 0.00069189071655273
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00018787384033203
(569) DESCRIBE `ports` 0.00072288513183594
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00017285346984863
(571) DESCRIBE `ports` 0.00068497657775879
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00018191337585449
(573) DESCRIBE `ports` 0.00067400932312012
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.0001680850982666
(575) DESCRIBE `ports` 0.00066900253295898
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020098686218262
(577) DESCRIBE `ports` 0.00070405006408691
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0001671314239502
(579) DESCRIBE `ports` 0.00066900253295898
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020289421081543
(581) DESCRIBE `ports` 0.00066590309143066
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0001678466796875
(583) DESCRIBE `ports` 0.00069689750671387
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020098686218262
(585) DESCRIBE `ports` 0.00069212913513184
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00016617774963379
(587) DESCRIBE `cruises` 0.0013048648834229
(588) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62015))) 0.00028800964355469
(589) DESCRIBE `avid_specials` 0.00063014030456543
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1177300 and class = 'Special') OR (item_id = 62015 and class = 'Cruise') OR (item_id = 1456 AND class = 'Ship') OR (item_id = 263 AND class = 'CruiseLine') OR (item_id = 54 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.00073885917663574
(591) DESCRIBE `cruiselines` 0.00095701217651367
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00020503997802734
(593) DESCRIBE `orchid_image` 0.00078916549682617
(594) DESCRIBE `cruiselines` 0.00095391273498535
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '263') 0.0001680850982666
(596) DESCRIBE `specials` 0.0020618438720703
(597) DESCRIBE `specials` 0.0019168853759766
(598) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1210343') 0.00019097328186035
(599) DESCRIBE `ships` 0.0012800693511963
(600) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1159))) 0.00023102760314941
(601) DESCRIBE `ships` 0.0012648105621338
(602) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1159') 0.00016999244689941
(603) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017619132995605
(604) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018405914306641
(605) DESCRIBE `itineraries` 0.00069594383239746
(606) DESCRIBE `ports` 0.0006718635559082
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019502639770508
(608) DESCRIBE `ports` 0.00072002410888672
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019001960754395
(610) DESCRIBE `ports` 0.00067806243896484
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017809867858887
(612) DESCRIBE `specialsailingdates` 0.00055909156799316
(613) DESCRIBE `sailingdates` 0.00061392784118652
(614) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383265))) 0.00019598007202148
(615) DESCRIBE `ports` 0.00068497657775879
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022983551025391
(617) DESCRIBE `ports` 0.0007481575012207
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0001680850982666
(619) DESCRIBE `ports` 0.00068211555480957
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5008))) 0.00020289421081543
(621) DESCRIBE `ports` 0.00068306922912598
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5008') 0.00018000602722168
(623) DESCRIBE `ports` 0.00068902969360352
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 699))) 0.00019288063049316
(625) DESCRIBE `ports` 0.00069093704223633
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '699') 0.00017309188842773
(627) DESCRIBE `ports` 0.00073814392089844
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0001988410949707
(629) DESCRIBE `ports` 0.00068998336791992
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00016617774963379
(631) DESCRIBE `ports` 0.00067591667175293
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00019407272338867
(633) DESCRIBE `ports` 0.00067400932312012
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018310546875
(635) DESCRIBE `ports` 0.00069808959960938
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00019001960754395
(637) DESCRIBE `ports` 0.00068116188049316
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017690658569336
(639) DESCRIBE `ports` 0.00067400932312012
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00018882751464844
(641) DESCRIBE `ports` 0.00068807601928711
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00022506713867188
(643) DESCRIBE `ports` 0.0007472038269043
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00019001960754395
(645) DESCRIBE `ports` 0.00073599815368652
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.0001678466796875
(647) DESCRIBE `ports` 0.00068211555480957
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019598007202148
(649) DESCRIBE `ports` 0.00068306922912598
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017309188842773
(651) DESCRIBE `ports` 0.00069904327392578
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040507316589355
(653) DESCRIBE `ports` 0.00089001655578613
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018310546875
(655) DESCRIBE `cruises` 0.0014209747314453
(656) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 60479))) 0.00030708312988281
(657) DESCRIBE `avid_specials` 0.00061511993408203
(658) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1210343 and class = 'Special') OR (item_id = 60479 and class = 'Cruise') OR (item_id = 1159 AND class = 'Ship') OR (item_id = 33 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.00075197219848633
(659) DESCRIBE `cruiselines` 0.00099492073059082
(660) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00023198127746582
(661) DESCRIBE `orchid_image` 0.00078201293945312
(662) DESCRIBE `cruiselines` 0.0010421276092529
(663) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00017905235290527
(664) DESCRIBE `specials` 0.0021021366119385
(665) DESCRIBE `specials` 0.0018868446350098
(666) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1213906') 0.00019097328186035
(667) DESCRIBE `ships` 0.0013070106506348
(668) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00026583671569824
(669) DESCRIBE `ships` 0.001331090927124
(670) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00018405914306641
(671) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017189979553223
(672) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(673) DESCRIBE `itineraries` 0.00065898895263672
(674) DESCRIBE `ports` 0.0006859302520752
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019598007202148
(676) DESCRIBE `ports` 0.00066709518432617
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019598007202148
(678) DESCRIBE `ports` 0.00071811676025391
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00016999244689941
(680) DESCRIBE `specialsailingdates` 0.00057506561279297
(681) DESCRIBE `sailingdates` 0.00064301490783691
(682) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 344598))) 0.00031495094299316
(683) DESCRIBE `ports` 0.00085878372192383
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020599365234375
(685) DESCRIBE `ports` 0.00074005126953125
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018095970153809
(687) DESCRIBE `ports` 0.00068807601928711
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.0001990795135498
(689) DESCRIBE `ports` 0.0007169246673584
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00018000602722168
(691) DESCRIBE `ports` 0.00072288513183594
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00019693374633789
(693) DESCRIBE `ports` 0.00068497657775879
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00017189979553223
(695) DESCRIBE `ports` 0.00068402290344238
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00020503997802734
(697) DESCRIBE `ports` 0.00069808959960938
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00016903877258301
(699) DESCRIBE `ports` 0.00067591667175293
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00018882751464844
(701) DESCRIBE `ports` 0.00069785118103027
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.0001828670501709
(703) DESCRIBE `ports` 0.00068306922912598
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00021219253540039
(705) DESCRIBE `ports` 0.00066995620727539
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017905235290527
(707) DESCRIBE `ports` 0.00066900253295898
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.0001981258392334
(709) DESCRIBE `ports` 0.00068283081054688
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017499923706055
(711) DESCRIBE `ports` 0.00068807601928711
(712) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00018906593322754
(713) DESCRIBE `ports` 0.00067901611328125
(714) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00017404556274414
(715) DESCRIBE `ports` 0.00067996978759766
(716) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00018882751464844
(717) DESCRIBE `ports` 0.00071001052856445
(718) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017905235290527
(719) DESCRIBE `cruises` 0.0015439987182617
(720) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 44079))) 0.00027585029602051
(721) DESCRIBE `avid_specials` 0.0006101131439209
(722) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1213906 and class = 'Special') OR (item_id = 44079 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 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.00076007843017578
(723) DESCRIBE `cruiselines` 0.0010240077972412
(724) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00023102760314941
(725) DESCRIBE `orchid_image` 0.00076198577880859
(726) DESCRIBE `cruiselines` 0.00095915794372559
(727) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00018811225891113
(728) DESCRIBE `cruiselines` 0.0018291473388672
(729) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('144', '23', '101', '24', '77', '263', '153', '33', '151', '18', '187', '20', '57', '171', '212', '19', '7', '92', '110', '147', '157', '8', '96', '4', '105', '114', '262', '91')) ORDER BY FIND_IN_SET(id, '144,23,101,24,77,263,153,33,151,18,187,20,57,171,212,19,7,92,110,147,157,8,96,4,105,114,262,91') 0.0015859603881836
(730) DESCRIBE `ships` 0.0013880729675293
(731) SELECT `ships`.* FROM `ships` WHERE (id IN ('1060', '485', '1026', '163', '616', '225', '1457', '1454', '1456', '1460', '671', '1013', '108', '253', '375', '650', '688', '1006', '1137', '1168', '1352', '111', '338', '652', '818', '973', '1052', '1159', '1318', '487', '580', '1154', '1256', '75', '313', '451', '547', '683', '1409', '97', '288', '349', '406', '419', '488', '506', '726', '727', '786', '796', '888', '972', '1021', '1135', '1151', '4', '45', '93', '105', '335', '340', '341', '394', '422', '423', '434', '452', '610', '657', '674', '766', '785', '792', '977', '1039', '1043', '1139', '1148', '1208', '1223', '1224', '1259', '1302', '1321', '1341', '1464', '1482')) ORDER BY FIND_IN_SET(id, '1060,485,1026,163,616,225,1457,1454,1456,1460,671,1013,108,253,375,650,688,1006,1137,1168,1352,111,338,652,818,973,1052,1159,1318,487,580,1154,1256,75,313,451,547,683,1409,97,288,349,406,419,488,506,726,727,786,796,888,972,1021,1135,1151,4,45,93,105,335,340,341,394,422,423,434,452,610,657,674,766,785,792,977,1039,1043,1139,1148,1208,1223,1224,1259,1302,1321,1341,1464,1482') 0.002979040145874
(732) DESCRIBE `cruisetypes` 0.00061798095703125
(733) DESCRIBE `destinations` 0.00090193748474121
(734) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '43', '22', '54', '35', '8', '49', '12', '39', '25', '2', '7', '21', '53', '26', '28', '40', '37', '30', '38', '48', '45')) ORDER BY FIND_IN_SET(id, '50,43,22,54,35,8,49,12,39,25,2,7,21,53,26,28,40,37,30,38,48,45') 0.00072979927062988