or, enquire about your chosen options

  1. Catch up on Cruising: Latest news in bite size
  2. Catch up on Cruising: Latest news in bite size
  3. Family Cruising – Have you considered it ?
  4. New Azamara Ship to arrive in March 2018
  5. Enhanced amenities for Oceania Cruises

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

Total elapsed time: 0.42495894432068

# Query Time
(1) connect 0.00060391426086426
(2) DESCRIBE `cruises` 0.0017502307891846
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62801, 61397, 41031, 68312, 48869, 63173, 68313, 68314, 62825, 62372)) ORDER BY FIND_IN_SET(id, '62801,61397,41031,68312,48869,63173,68313,68314,62825,62372') 0.0012149810791016
(4) DESCRIBE `specials` 0.0024821758270264
(5) DESCRIBE `specials` 0.002687931060791
(6) DESCRIBE `specials` 0.00189208984375
(7) DESCRIBE `cruises` 0.0014200210571289
(8) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62801') 0.00031304359436035
(9) DESCRIBE `specials` 0.003108024597168
(10) DESCRIBE `ships` 0.0017130374908447
(11) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1468))) 0.00030303001403809
(12) DESCRIBE `ships` 0.0013868808746338
(13) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1468') 0.00021195411682129
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017595291137695
(15) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(16) DESCRIBE `itineraries` 0.00067520141601562
(17) DESCRIBE `ports` 0.00072908401489258
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00022697448730469
(19) DESCRIBE `ports` 0.00066804885864258
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00024199485778809
(21) DESCRIBE `ports` 0.00081896781921387
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00020098686218262
(23) DESCRIBE `specials` 0.0022830963134766
(24) DESCRIBE `sailingdates` 0.00066900253295898
(25) DESCRIBE `ports` 0.00073695182800293
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00027608871459961
(27) DESCRIBE `ports` 0.00067615509033203
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00019097328186035
(29) DESCRIBE `ports` 0.00065898895263672
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00021600723266602
(31) DESCRIBE `ports` 0.00066614151000977
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00017905235290527
(33) DESCRIBE `ports` 0.00067901611328125
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00020480155944824
(35) DESCRIBE `ports` 0.00076389312744141
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.0001988410949707
(37) DESCRIBE `ports` 0.00075984001159668
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.0001978874206543
(39) DESCRIBE `ports` 0.00081801414489746
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00026988983154297
(41) DESCRIBE `ports` 0.00078487396240234
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00022697448730469
(43) DESCRIBE `ports` 0.00087404251098633
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00019502639770508
(45) DESCRIBE `ports` 0.00081300735473633
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00023913383483887
(47) DESCRIBE `ports` 0.00082302093505859
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00020813941955566
(49) DESCRIBE `ports` 0.00081610679626465
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00019311904907227
(51) DESCRIBE `ports` 0.0007481575012207
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00017499923706055
(53) DESCRIBE `ports` 0.0006558895111084
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019407272338867
(55) DESCRIBE `ports` 0.00067400932312012
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018000602722168
(57) DESCRIBE `ports` 0.00065398216247559
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019192695617676
(59) DESCRIBE `ports` 0.00066900253295898
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018596649169922
(61) DESCRIBE `ports` 0.00065493583679199
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00019288063049316
(63) DESCRIBE `ports` 0.00065398216247559
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00020790100097656
(65) DESCRIBE `ports` 0.00065398216247559
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00020289421081543
(67) DESCRIBE `ports` 0.00066518783569336
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00018596649169922
(69) DESCRIBE `ports` 0.00079703330993652
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00024795532226562
(71) DESCRIBE `ports` 0.00069403648376465
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00019097328186035
(73) DESCRIBE `ports` 0.00066494941711426
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00019097328186035
(75) DESCRIBE `ports` 0.0006568431854248
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00017309188842773
(77) DESCRIBE `ports` 0.0006718635559082
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0001978874206543
(79) DESCRIBE `ports` 0.00066494941711426
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00016999244689941
(81) DESCRIBE `ports` 0.00066685676574707
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020194053649902
(83) DESCRIBE `ports` 0.00066518783569336
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00016999244689941
(85) DESCRIBE `ports` 0.00067901611328125
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018906593322754
(87) DESCRIBE `ports` 0.00066804885864258
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00016903877258301
(89) DESCRIBE `specials` 0.0022950172424316
(90) DESCRIBE `specials` 0.0021178722381592
(91) DESCRIBE `avid_specials` 0.000640869140625
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62801 and class = 'Cruise') OR (item_id = 1468 AND class = 'Ship') OR (item_id = 144 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.0011341571807861
(93) DESCRIBE `cruiselines` 0.00099492073059082
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00024509429931641
(95) DESCRIBE `orchid_image` 0.00079202651977539
(96) DESCRIBE `cruiselines` 0.00095510482788086
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00019598007202148
(98) DESCRIBE `specials` 0.0020480155944824
(99) DESCRIBE `specials` 0.0019099712371826
(100) DESCRIBE `specials` 0.0018959045410156
(101) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1343381') 0.00026917457580566
(102) DESCRIBE `ships` 0.0013880729675293
(103) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00027799606323242
(104) DESCRIBE `ships` 0.0013251304626465
(105) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00019693374633789
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016307830810547
(108) DESCRIBE `itineraries` 0.00065493583679199
(109) DESCRIBE `ports` 0.00069618225097656
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024604797363281
(111) DESCRIBE `ports` 0.00065994262695312
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019693374633789
(113) DESCRIBE `ports` 0.0007011890411377
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017595291137695
(115) DESCRIBE `specialsailingdates` 0.00058102607727051
(116) DESCRIBE `sailingdates` 0.00067591667175293
(117) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 389098))) 0.00025200843811035
(118) DESCRIBE `ports` 0.00077605247497559
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021600723266602
(120) DESCRIBE `ports` 0.00069189071655273
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021600723266602
(122) DESCRIBE `ports` 0.00072503089904785
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00020289421081543
(124) DESCRIBE `ports` 0.00066804885864258
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.00017595291137695
(126) DESCRIBE `ports` 0.00070905685424805
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00023102760314941
(128) DESCRIBE `ports` 0.00085282325744629
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00021696090698242
(130) DESCRIBE `ports` 0.00080394744873047
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00022196769714355
(132) DESCRIBE `ports` 0.00077986717224121
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00017714500427246
(134) DESCRIBE `ports` 0.00069999694824219
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020289421081543
(136) DESCRIBE `ports` 0.00069093704223633
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00020480155944824
(138) DESCRIBE `ports` 0.00067687034606934
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020098686218262
(140) DESCRIBE `ports` 0.00068998336791992
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018692016601562
(142) DESCRIBE `ports` 0.00071620941162109
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00021100044250488
(144) DESCRIBE `ports` 0.00071215629577637
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00018095970153809
(146) DESCRIBE `ports` 0.00075483322143555
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020408630371094
(148) DESCRIBE `ports` 0.00069403648376465
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00019121170043945
(150) DESCRIBE `ports` 0.0006868839263916
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020599365234375
(152) DESCRIBE `ports` 0.00070595741271973
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00019097328186035
(154) DESCRIBE `ports` 0.00075507164001465
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.0002129077911377
(156) DESCRIBE `ports` 0.00070810317993164
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00019192695617676
(158) DESCRIBE `ports` 0.00071907043457031
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020194053649902
(160) DESCRIBE `ports` 0.00067400932312012
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018215179443359
(162) DESCRIBE `ports` 0.00069189071655273
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(164) DESCRIBE `ports` 0.00080108642578125
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002129077911377
(166) DESCRIBE `cruises` 0.0015261173248291
(167) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 61397))) 0.00029993057250977
(168) DESCRIBE `avid_specials` 0.00081896781921387
(169) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1343381 and class = 'Special') OR (item_id = 61397 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0011098384857178
(170) DESCRIBE `cruiselines` 0.0010149478912354
(171) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00023412704467773
(172) DESCRIBE `orchid_image` 0.00073599815368652
(173) DESCRIBE `cruiselines` 0.00094294548034668
(174) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00022983551025391
(175) DESCRIBE `specials` 0.0024080276489258
(176) DESCRIBE `specials` 0.0019350051879883
(177) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225970') 0.00024604797363281
(178) DESCRIBE `ships` 0.0013179779052734
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.00028514862060547
(180) DESCRIBE `ships` 0.0012340545654297
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00017404556274414
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017380714416504
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(184) DESCRIBE `itineraries` 0.00065422058105469
(185) DESCRIBE `ports` 0.00068092346191406
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020885467529297
(187) DESCRIBE `ports` 0.00071406364440918
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019598007202148
(189) DESCRIBE `ports` 0.00066399574279785
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001988410949707
(191) DESCRIBE `specialsailingdates` 0.00058412551879883
(192) DESCRIBE `sailingdates` 0.00066494941711426
(193) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396696))) 0.0002131462097168
(194) DESCRIBE `sailingdates` 0.00064492225646973
(195) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396697))) 0.00018787384033203
(196) DESCRIBE `ports` 0.00080490112304688
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00046491622924805
(198) DESCRIBE `ports` 0.0012009143829346
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027704238891602
(200) DESCRIBE `ports` 0.0010218620300293
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028491020202637
(202) DESCRIBE `ports` 0.0010638236999512
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027203559875488
(204) DESCRIBE `ports` 0.0010430812835693
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031900405883789
(206) DESCRIBE `ports` 0.001072883605957
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00025200843811035
(208) DESCRIBE `ports` 0.0010409355163574
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00029611587524414
(210) DESCRIBE `ports` 0.001046895980835
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00024795532226562
(212) DESCRIBE `ports` 0.0010421276092529
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029301643371582
(214) DESCRIBE `ports` 0.0010311603546143
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00026202201843262
(216) DESCRIBE `ports` 0.0010998249053955
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030612945556641
(218) DESCRIBE `ports` 0.0010619163513184
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00026106834411621
(220) DESCRIBE `cruises` 0.0020661354064941
(221) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41031))) 0.00047397613525391
(222) DESCRIBE `avid_specials` 0.0010418891906738
(223) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1225970 and class = 'Special') OR (item_id = 41031 and class = 'Cruise') OR (item_id = 1063 AND class = 'Ship') OR (item_id = 144 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.0019350051879883
(224) DESCRIBE `cruiselines` 0.0015480518341064
(225) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00034809112548828
(226) DESCRIBE `orchid_image` 0.001121997833252
(227) DESCRIBE `cruiselines` 0.0014410018920898
(228) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0003209114074707
(229) DESCRIBE `specials` 0.0033090114593506
(230) DESCRIBE `specials` 0.0030710697174072
(231) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294016') 0.0003211498260498
(232) DESCRIBE `ships` 0.0014441013336182
(233) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00027322769165039
(234) DESCRIBE `ships` 0.0013241767883301
(235) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.00019097328186035
(236) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(237) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017118453979492
(238) DESCRIBE `itineraries` 0.00078892707824707
(239) DESCRIBE `ports` 0.00084090232849121
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00035905838012695
(241) DESCRIBE `ports` 0.0010209083557129
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00032591819763184
(243) DESCRIBE `ports` 0.0010199546813965
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00027680397033691
(245) DESCRIBE `specialsailingdates` 0.00068402290344238
(246) DESCRIBE `sailingdates` 0.00064206123352051
(247) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430734))) 0.00024604797363281
(248) DESCRIBE `sailingdates` 0.00060796737670898
(249) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430735))) 0.00019693374633789
(250) DESCRIBE `sailingdates` 0.00067710876464844
(251) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430736))) 0.00020408630371094
(252) DESCRIBE `sailingdates` 0.00075483322143555
(253) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430737))) 0.00031399726867676
(254) DESCRIBE `sailingdates` 0.00087904930114746
(255) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430738))) 0.00026988983154297
(256) DESCRIBE `ports` 0.00097393989562988
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00027585029602051
(258) DESCRIBE `ports` 0.00089907646179199
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0002140998840332
(260) DESCRIBE `ports` 0.00074195861816406
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00022506713867188
(262) DESCRIBE `ports` 0.00069308280944824
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00018811225891113
(264) DESCRIBE `ports` 0.00068902969360352
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0002140998840332
(266) DESCRIBE `ports` 0.0007469654083252
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.0001981258392334
(268) DESCRIBE `ports` 0.00068092346191406
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00027894973754883
(270) DESCRIBE `ports` 0.00070595741271973
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00018787384033203
(272) DESCRIBE `ports` 0.00068020820617676
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00021195411682129
(274) DESCRIBE `ports` 0.00092005729675293
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00023412704467773
(276) DESCRIBE `ports` 0.00082111358642578
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00028085708618164
(278) DESCRIBE `ports` 0.0008549690246582
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00022697448730469
(280) DESCRIBE `cruises` 0.0015480518341064
(281) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68312))) 0.00035309791564941
(282) DESCRIBE `avid_specials` 0.00082492828369141
(283) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294016 and class = 'Special') OR (item_id = 68312 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 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.0011720657348633
(284) DESCRIBE `cruiselines` 0.0010011196136475
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00023508071899414
(286) DESCRIBE `orchid_image` 0.00077295303344727
(287) DESCRIBE `cruiselines` 0.0010311603546143
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00020790100097656
(289) DESCRIBE `specials` 0.0020310878753662
(290) DESCRIBE `specials` 0.0027859210968018
(291) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1222219') 0.00034213066101074
(292) DESCRIBE `ships` 0.0019059181213379
(293) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1232))) 0.00039196014404297
(294) DESCRIBE `ships` 0.0018270015716553
(295) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1232') 0.00023198127746582
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(297) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017786026000977
(298) DESCRIBE `itineraries` 0.00072813034057617
(299) DESCRIBE `ports` 0.00072503089904785
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00025200843811035
(301) DESCRIBE `ports` 0.00068902969360352
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00023889541625977
(303) DESCRIBE `ports` 0.00070595741271973
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00019288063049316
(305) DESCRIBE `specialsailingdates` 0.00057101249694824
(306) DESCRIBE `sailingdates` 0.00064706802368164
(307) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396406))) 0.00023984909057617
(308) DESCRIBE `ports` 0.00069785118103027
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00022006034851074
(310) DESCRIBE `ports` 0.00067687034606934
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00018811225891113
(312) DESCRIBE `ports` 0.00067305564880371
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00020813941955566
(314) DESCRIBE `ports` 0.00069499015808105
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00018596649169922
(316) DESCRIBE `ports` 0.00069189071655273
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2410))) 0.00020599365234375
(318) DESCRIBE `ports` 0.00069904327392578
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2410') 0.00018596649169922
(320) DESCRIBE `ports` 0.00068783760070801
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4484))) 0.00021791458129883
(322) DESCRIBE `ports` 0.00070714950561523
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4484') 0.00018596649169922
(324) DESCRIBE `ports` 0.00069093704223633
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4485))) 0.00020813941955566
(326) DESCRIBE `ports` 0.00084209442138672
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4485') 0.00026798248291016
(328) DESCRIBE `ports` 0.00094890594482422
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4485))) 0.00028610229492188
(330) DESCRIBE `ports` 0.00080394744873047
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4485') 0.00020599365234375
(332) DESCRIBE `ports` 0.00072598457336426
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4484))) 0.00022292137145996
(334) DESCRIBE `ports` 0.00070309638977051
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4484') 0.00019979476928711
(336) DESCRIBE `ports` 0.00073003768920898
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00021791458129883
(338) DESCRIBE `ports` 0.00069689750671387
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00018501281738281
(340) DESCRIBE `cruises` 0.0013470649719238
(341) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48869))) 0.0003352165222168
(342) DESCRIBE `avid_specials` 0.00067782402038574
(343) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222219 and class = 'Special') OR (item_id = 48869 and class = 'Cruise') OR (item_id = 1232 AND class = 'Ship') OR (item_id = 144 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.0012788772583008
(344) DESCRIBE `cruiselines` 0.0010271072387695
(345) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00026798248291016
(346) DESCRIBE `orchid_image` 0.00078392028808594
(347) DESCRIBE `cruiselines` 0.0010230541229248
(348) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00022506713867188
(349) DESCRIBE `specials` 0.0020670890808105
(350) DESCRIBE `specials` 0.0019130706787109
(351) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230524') 0.00026512145996094
(352) DESCRIBE `ships` 0.0013110637664795
(353) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1062))) 0.00028610229492188
(354) DESCRIBE `ships` 0.0012829303741455
(355) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1062') 0.0001981258392334
(356) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028705596923828
(357) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(358) DESCRIBE `itineraries` 0.0009000301361084
(359) DESCRIBE `ports` 0.00086116790771484
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00026798248291016
(361) DESCRIBE `ports` 0.00082182884216309
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00022792816162109
(363) DESCRIBE `ports` 0.00081801414489746
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00021505355834961
(365) DESCRIBE `specialsailingdates` 0.00071287155151367
(366) DESCRIBE `sailingdates` 0.0007319450378418
(367) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396746))) 0.00024318695068359
(368) DESCRIBE `ports` 0.00081491470336914
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021791458129883
(370) DESCRIBE `ports` 0.00069594383239746
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0002131462097168
(372) DESCRIBE `ports` 0.0007328987121582
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00027680397033691
(374) DESCRIBE `ports` 0.00070309638977051
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00019598007202148
(376) DESCRIBE `ports` 0.00071096420288086
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00020790100097656
(378) DESCRIBE `ports` 0.00068092346191406
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00018906593322754
(380) DESCRIBE `ports` 0.00068807601928711
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00020503997802734
(382) DESCRIBE `ports` 0.00068402290344238
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00021100044250488
(384) DESCRIBE `ports` 0.00068402290344238
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00020384788513184
(386) DESCRIBE `ports` 0.00067305564880371
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00018191337585449
(388) DESCRIBE `ports` 0.00072503089904785
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00023508071899414
(390) DESCRIBE `ports` 0.0007011890411377
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00018882751464844
(392) DESCRIBE `ports` 0.00069999694824219
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4607))) 0.00021815299987793
(394) DESCRIBE `ports` 0.00067996978759766
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4607') 0.00019311904907227
(396) DESCRIBE `ports` 0.00067281723022461
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3207))) 0.00020408630371094
(398) DESCRIBE `ports` 0.00067901611328125
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3207') 0.00019001960754395
(400) DESCRIBE `ports` 0.00067996978759766
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4685))) 0.00021600723266602
(402) DESCRIBE `ports` 0.00066781044006348
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4685') 0.00018787384033203
(404) DESCRIBE `ports` 0.00066518783569336
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021100044250488
(406) DESCRIBE `ports` 0.0006718635559082
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018787384033203
(408) DESCRIBE `ports` 0.00067496299743652
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00023603439331055
(410) DESCRIBE `ports` 0.0008847713470459
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00019192695617676
(412) DESCRIBE `ports` 0.00068283081054688
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020694732666016
(414) DESCRIBE `ports` 0.00082707405090332
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00020194053649902
(416) DESCRIBE `cruises` 0.0013000965118408
(417) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63173))) 0.00034904479980469
(418) DESCRIBE `avid_specials` 0.00062203407287598
(419) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230524 and class = 'Special') OR (item_id = 63173 and class = 'Cruise') OR (item_id = 1062 AND class = 'Ship') OR (item_id = 144 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.0010840892791748
(420) DESCRIBE `cruiselines` 0.0009918212890625
(421) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00024199485778809
(422) DESCRIBE `orchid_image` 0.00084495544433594
(423) DESCRIBE `cruiselines` 0.00094485282897949
(424) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0001978874206543
(425) DESCRIBE `specials` 0.0020499229431152
(426) DESCRIBE `specials` 0.0021710395812988
(427) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294017') 0.00032401084899902
(428) DESCRIBE `ships` 0.0016078948974609
(429) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00040793418884277
(430) DESCRIBE `ships` 0.0016279220581055
(431) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.00032186508178711
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020503997802734
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(434) DESCRIBE `itineraries` 0.00091004371643066
(435) DESCRIBE `ports` 0.00092005729675293
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00026392936706543
(437) DESCRIBE `ports` 0.00076889991760254
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0002138614654541
(439) DESCRIBE `ports` 0.00077390670776367
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00025200843811035
(441) DESCRIBE `specialsailingdates` 0.00061702728271484
(442) DESCRIBE `sailingdates` 0.00063300132751465
(443) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430756))) 0.00027203559875488
(444) DESCRIBE `sailingdates` 0.0006110668182373
(445) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430757))) 0.00019407272338867
(446) DESCRIBE `sailingdates` 0.0006101131439209
(447) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430758))) 0.00019311904907227
(448) DESCRIBE `sailingdates` 0.00062799453735352
(449) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430759))) 0.00018906593322754
(450) DESCRIBE `ports` 0.00070095062255859
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00022792816162109
(452) DESCRIBE `ports` 0.00071001052856445
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00020313262939453
(454) DESCRIBE `ports` 0.00068402290344238
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021195411682129
(456) DESCRIBE `ports` 0.00068187713623047
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00019288063049316
(458) DESCRIBE `ports` 0.00067496299743652
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00020694732666016
(460) DESCRIBE `ports` 0.00073003768920898
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00019001960754395
(462) DESCRIBE `ports` 0.00070810317993164
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00020909309387207
(464) DESCRIBE `ports` 0.00071001052856445
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00018191337585449
(466) DESCRIBE `ports` 0.00069403648376465
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00020098686218262
(468) DESCRIBE `ports` 0.00069785118103027
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00017595291137695
(470) DESCRIBE `ports` 0.00071215629577637
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00024509429931641
(472) DESCRIBE `ports` 0.00090193748474121
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00020194053649902
(474) DESCRIBE `cruises` 0.0013339519500732
(475) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68313))) 0.00029897689819336
(476) DESCRIBE `avid_specials` 0.00063490867614746
(477) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294017 and class = 'Special') OR (item_id = 68313 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 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.001107931137085
(478) DESCRIBE `cruiselines` 0.001039981842041
(479) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.0002129077911377
(480) DESCRIBE `orchid_image` 0.00074887275695801
(481) DESCRIBE `cruiselines` 0.00094699859619141
(482) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018501281738281
(483) DESCRIBE `specials` 0.0020411014556885
(484) DESCRIBE `specials` 0.001978874206543
(485) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294018') 0.00025701522827148
(486) DESCRIBE `ships` 0.0013020038604736
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00026297569274902
(488) DESCRIBE `ships` 0.0012400150299072
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.0001828670501709
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(492) DESCRIBE `itineraries` 0.0006868839263916
(493) DESCRIBE `ports` 0.00071310997009277
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00023984909057617
(495) DESCRIBE `ports` 0.00070905685424805
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021815299987793
(497) DESCRIBE `ports` 0.00068306922912598
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00020813941955566
(499) DESCRIBE `specialsailingdates` 0.00058698654174805
(500) DESCRIBE `sailingdates` 0.00065302848815918
(501) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430776))) 0.00023818016052246
(502) DESCRIBE `sailingdates` 0.00062108039855957
(503) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430777))) 0.00019717216491699
(504) DESCRIBE `sailingdates` 0.00059795379638672
(505) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430778))) 0.00018620491027832
(506) DESCRIBE `sailingdates` 0.00060606002807617
(507) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430779))) 0.00019407272338867
(508) DESCRIBE `ports` 0.0007021427154541
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00023198127746582
(510) DESCRIBE `ports` 0.00070095062255859
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00019502639770508
(512) DESCRIBE `ports` 0.00069403648376465
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00020599365234375
(514) DESCRIBE `ports` 0.00069212913513184
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00019383430480957
(516) DESCRIBE `ports` 0.00069689750671387
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00022292137145996
(518) DESCRIBE `ports` 0.00069594383239746
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00019311904907227
(520) DESCRIBE `ports` 0.00072121620178223
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00021195411682129
(522) DESCRIBE `ports` 0.00069594383239746
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00018787384033203
(524) DESCRIBE `ports` 0.00067305564880371
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00020718574523926
(526) DESCRIBE `ports` 0.0006871223449707
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.0001838207244873
(528) DESCRIBE `ports` 0.00067996978759766
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00026702880859375
(530) DESCRIBE `ports` 0.00093579292297363
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00019693374633789
(532) DESCRIBE `cruises` 0.0013589859008789
(533) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68314))) 0.00031495094299316
(534) DESCRIBE `avid_specials` 0.00069689750671387
(535) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294018 and class = 'Special') OR (item_id = 68314 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 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.0011031627655029
(536) DESCRIBE `cruiselines` 0.0009920597076416
(537) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00023007392883301
(538) DESCRIBE `orchid_image` 0.00076103210449219
(539) DESCRIBE `cruiselines` 0.00095105171203613
(540) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.0002140998840332
(541) DESCRIBE `specials` 0.001986026763916
(542) DESCRIBE `specials` 0.0019428730010986
(543) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1364656') 0.00025796890258789
(544) DESCRIBE `ships` 0.0013141632080078
(545) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00026106834411621
(546) DESCRIBE `ships` 0.0013141632080078
(547) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00018692016601562
(548) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018692016601562
(549) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016999244689941
(550) DESCRIBE `itineraries` 0.00066590309143066
(551) DESCRIBE `ports` 0.00078415870666504
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00041294097900391
(553) DESCRIBE `ports` 0.001025915145874
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00023412704467773
(555) DESCRIBE `ports` 0.00070309638977051
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00020217895507812
(557) DESCRIBE `specialsailingdates` 0.00057411193847656
(558) DESCRIBE `sailingdates` 0.00061511993408203
(559) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393808))) 0.00022697448730469
(560) DESCRIBE `ports` 0.00068902969360352
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00021505355834961
(562) DESCRIBE `ports` 0.00068116188049316
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00019383430480957
(564) DESCRIBE `ports` 0.00068116188049316
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020694732666016
(566) DESCRIBE `ports` 0.0006859302520752
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00018215179443359
(568) DESCRIBE `ports` 0.00066900253295898
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.00020694732666016
(570) DESCRIBE `ports` 0.00068902969360352
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00018095970153809
(572) DESCRIBE `ports` 0.00067400932312012
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00021100044250488
(574) DESCRIBE `ports` 0.00068807601928711
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00020194053649902
(576) DESCRIBE `ports` 0.00065994262695312
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 801))) 0.00020003318786621
(578) DESCRIBE `ports` 0.00066399574279785
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '801') 0.00018095970153809
(580) DESCRIBE `ports` 0.00066089630126953
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00020003318786621
(582) DESCRIBE `ports` 0.00067496299743652
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00018191337585449
(584) DESCRIBE `ports` 0.00066995620727539
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00022006034851074
(586) DESCRIBE `ports` 0.00067400932312012
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00018095970153809
(588) DESCRIBE `ports` 0.00069189071655273
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00020813941955566
(590) DESCRIBE `ports` 0.00066804885864258
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00018095970153809
(592) DESCRIBE `ports` 0.00069308280944824
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 657))) 0.00020909309387207
(594) DESCRIBE `ports` 0.00068402290344238
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '657') 0.00019001960754395
(596) DESCRIBE `ports` 0.00073504447937012
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00020694732666016
(598) DESCRIBE `ports` 0.00067806243896484
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00019288063049316
(600) DESCRIBE `ports` 0.00066709518432617
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020480155944824
(602) DESCRIBE `ports` 0.00067520141601562
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00018095970153809
(604) DESCRIBE `cruises` 0.0013129711151123
(605) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62825))) 0.00029206275939941
(606) DESCRIBE `avid_specials` 0.0006098747253418
(607) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1364656 and class = 'Special') OR (item_id = 62825 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 25 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010888576507568
(608) DESCRIBE `cruiselines` 0.00095105171203613
(609) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00022792816162109
(610) DESCRIBE `orchid_image` 0.00076603889465332
(611) DESCRIBE `cruiselines` 0.0010151863098145
(612) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00019383430480957
(613) DESCRIBE `specials` 0.0019919872283936
(614) DESCRIBE `specials` 0.0019121170043945
(615) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1222459') 0.00023889541625977
(616) DESCRIBE `ships` 0.0013229846954346
(617) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1465))) 0.00028491020202637
(618) DESCRIBE `ships` 0.0012819766998291
(619) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1465') 0.00020503997802734
(620) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(621) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(622) DESCRIBE `itineraries` 0.00065898895263672
(623) DESCRIBE `ports` 0.00069808959960938
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00021100044250488
(625) DESCRIBE `ports` 0.0006709098815918
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020790100097656
(627) DESCRIBE `ports` 0.00070595741271973
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00019407272338867
(629) DESCRIBE `specialsailingdates` 0.00058794021606445
(630) DESCRIBE `sailingdates` 0.00065803527832031
(631) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396536))) 0.00022602081298828
(632) DESCRIBE `ports` 0.0010519027709961
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00026702880859375
(634) DESCRIBE `ports` 0.00089120864868164
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.0001978874206543
(636) DESCRIBE `ports` 0.00073099136352539
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020694732666016
(638) DESCRIBE `ports` 0.0006859302520752
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.0001828670501709
(640) DESCRIBE `ports` 0.00072216987609863
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2851))) 0.00020194053649902
(642) DESCRIBE `ports` 0.00070405006408691
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2851') 0.00018215179443359
(644) DESCRIBE `ports` 0.00068497657775879
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 984))) 0.00021100044250488
(646) DESCRIBE `ports` 0.00069499015808105
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '984') 0.00018692016601562
(648) DESCRIBE `ports` 0.00067591667175293
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00020503997802734
(650) DESCRIBE `ports` 0.00068211555480957
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00018692016601562
(652) DESCRIBE `ports` 0.0007178783416748
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 958))) 0.00021696090698242
(654) DESCRIBE `ports` 0.00068402290344238
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '958') 0.00019097328186035
(656) DESCRIBE `ports` 0.00066709518432617
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1536))) 0.00020408630371094
(658) DESCRIBE `ports` 0.00069713592529297
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1536') 0.00018095970153809
(660) DESCRIBE `ports` 0.00067996978759766
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1534))) 0.00020194053649902
(662) DESCRIBE `ports` 0.00066900253295898
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1534') 0.00018095970153809
(664) DESCRIBE `ports` 0.00077104568481445
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1534))) 0.00021100044250488
(666) DESCRIBE `ports` 0.00073409080505371
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1534') 0.00018906593322754
(668) DESCRIBE `ports` 0.00067305564880371
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00022101402282715
(670) DESCRIBE `ports` 0.00066995620727539
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00018191337585449
(672) DESCRIBE `ports` 0.00078701972961426
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00026607513427734
(674) DESCRIBE `ports` 0.00076007843017578
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00019192695617676
(676) DESCRIBE `ports` 0.00073099136352539
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00021696090698242
(678) DESCRIBE `ports` 0.00068497657775879
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00019192695617676
(680) DESCRIBE `cruises` 0.0013129711151123
(681) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62372))) 0.00031208992004395
(682) DESCRIBE `avid_specials` 0.00062298774719238
(683) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222459 and class = 'Special') OR (item_id = 62372 and class = 'Cruise') OR (item_id = 1465 AND class = 'Ship') OR (item_id = 144 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.0010759830474854
(684) DESCRIBE `cruiselines` 0.0010261535644531
(685) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00023603439331055
(686) DESCRIBE `orchid_image` 0.0008080005645752
(687) DESCRIBE `cruiselines` 0.00095391273498535
(688) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00019979476928711
(689) DESCRIBE `cruiselines` 0.001183032989502
(690) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('140', '33', '28', '191', '18', '23', '30', '29', '38', '91', '26', '8', '144', '15', '24', '151', '57', '218', '37', '101', '20', '110', '262', '263', '19', '187')) ORDER BY FIND_IN_SET(id, '140,33,28,191,18,23,30,29,38,91,26,8,144,15,24,151,57,218,37,101,20,110,262,263,19,187') 0.001492977142334
(691) DESCRIBE `ships` 0.0016570091247559
(692) SELECT `ships`.* FROM `ships` WHERE (id IN ('189', '1205', '1325', '81', '150', '1032', '1282', '741', '162', '163', '933', '225', '394', '585', '790', '884', '1078', '1266', '1328', '148', '151', '160', '683', '768', '1168', '1393', '1579', '1631', '149', '152', '262', '508', '616', '652', '711', '835', '1159', '1468', '84', '253', '291', '451', '453', '542', '966', '968', '1063', '1135', '1302', '1319', '1330', '1398', '1409', '1464', '1575', '43', '82', '98', '105', '111', '119', '124', '258', '287', '324', '338', '340', '349', '404', '406', '407', '547', '624', '669', '765', '780', '791', '973', '1008', '1062', '1154', '1232', '1237', '1260', '1284', '1308', '1402', '1465', '1474')) ORDER BY FIND_IN_SET(id, '189,1205,1325,81,150,1032,1282,741,162,163,933,225,394,585,790,884,1078,1266,1328,148,151,160,683,768,1168,1393,1579,1631,149,152,262,508,616,652,711,835,1159,1468,84,253,291,451,453,542,966,968,1063,1135,1302,1319,1330,1398,1409,1464,1575,43,82,98,105,111,119,124,258,287,324,338,340,349,404,406,407,547,624,669,765,780,791,973,1008,1062,1154,1232,1237,1260,1284,1308,1402,1465,1474') 0.0034971237182617
(693) DESCRIBE `cruisetypes` 0.0009610652923584
(694) DESCRIBE `destinations` 0.0012900829315186
(695) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '50', '35', '43', '12', '54', '2', '8', '11', '55', '48', '26', '7', '40', '25', '28', '49', '29', '38', '53')) ORDER BY FIND_IN_SET(id, '22,50,35,43,12,54,2,8,11,55,48,26,7,40,25,28,49,29,38,53') 0.00090289115905762