or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

Total elapsed time: 0.97085523605347

# Query Time
(1) connect 0.00081801414489746
(2) DESCRIBE `cruises` 0.0033471584320068
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67295, 72995, 69895, 80004, 67917, 80005, 78125, 66816, 77957, 75551)) ORDER BY FIND_IN_SET(id, '67295,72995,69895,80004,67917,80005,78125,66816,77957,75551') 0.0019900798797607
(4) DESCRIBE `specials` 0.003709077835083
(5) DESCRIBE `specials` 0.0036249160766602
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1496939') 0.00061202049255371
(7) DESCRIBE `ships` 0.0027709007263184
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00059700012207031
(9) DESCRIBE `ships` 0.0027899742126465
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00041913986206055
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(13) DESCRIBE `itineraries` 0.0014750957489014
(14) DESCRIBE `ports` 0.0014500617980957
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040793418884277
(16) DESCRIBE `ports` 0.0013339519500732
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032186508178711
(18) DESCRIBE `ports` 0.0016231536865234
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033688545227051
(20) DESCRIBE `specialsailingdates` 0.0012052059173584
(21) DESCRIBE `sailingdates` 0.0012040138244629
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424403))) 0.00058293342590332
(23) DESCRIBE `ports` 0.0014121532440186
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003359317779541
(25) DESCRIBE `ports` 0.0013689994812012
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040793418884277
(27) DESCRIBE `ports` 0.0012550354003906
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031495094299316
(29) DESCRIBE `ports` 0.0016210079193115
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0003349781036377
(31) DESCRIBE `ports` 0.0015501976013184
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00044703483581543
(33) DESCRIBE `ports` 0.0015699863433838
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035190582275391
(35) DESCRIBE `ports` 0.0018038749694824
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00042510032653809
(37) DESCRIBE `ports` 0.0019161701202393
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00039410591125488
(39) DESCRIBE `ports` 0.0017778873443604
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004279613494873
(41) DESCRIBE `ports` 0.0018768310546875
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041890144348145
(43) DESCRIBE `cruises` 0.0036990642547607
(44) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67295))) 0.00056886672973633
(45) DESCRIBE `avid_specials` 0.0016930103302002
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1496939 and class = 'Special') OR (item_id = 67295 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0041420459747314
(47) DESCRIBE `cruiselines` 0.0028769969940186
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00053000450134277
(49) DESCRIBE `orchid_image` 0.0021557807922363
(50) DESCRIBE `cruiselines` 0.0024089813232422
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00041294097900391
(52) DESCRIBE `specials` 0.0042529106140137
(53) DESCRIBE `specials` 0.0044970512390137
(54) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1497393') 0.00044393539428711
(55) DESCRIBE `ships` 0.0030860900878906
(56) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00042605400085449
(57) DESCRIBE `ships` 0.0027861595153809
(58) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00037693977355957
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027012825012207
(60) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002598762512207
(61) DESCRIBE `itineraries` 0.0018410682678223
(62) DESCRIBE `ports` 0.0019609928131104
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051498413085938
(64) DESCRIBE `ports` 0.0020480155944824
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047206878662109
(66) DESCRIBE `ports` 0.00189208984375
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038886070251465
(68) DESCRIBE `specialsailingdates` 0.0013201236724854
(69) DESCRIBE `sailingdates` 0.0017719268798828
(70) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 460245))) 0.00059294700622559
(71) DESCRIBE `ports` 0.0019488334655762
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004580020904541
(73) DESCRIBE `ports` 0.0018739700317383
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038886070251465
(75) DESCRIBE `ports` 0.0018899440765381
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00045919418334961
(77) DESCRIBE `ports` 0.0018517971038818
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00041484832763672
(79) DESCRIBE `ports` 0.0016601085662842
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00038385391235352
(81) DESCRIBE `ports` 0.0013768672943115
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.0003809928894043
(83) DESCRIBE `ports` 0.0016579627990723
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00044894218444824
(85) DESCRIBE `ports` 0.0017709732055664
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00042915344238281
(87) DESCRIBE `ports` 0.0017809867858887
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037384033203125
(89) DESCRIBE `ports` 0.0018188953399658
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035595893859863
(91) DESCRIBE `ports` 0.0015029907226562
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00033712387084961
(93) DESCRIBE `ports` 0.0013802051544189
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00036382675170898
(95) DESCRIBE `ports` 0.001323938369751
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00032711029052734
(97) DESCRIBE `ports` 0.0015161037445068
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0028560161590576
(99) DESCRIBE `ports` 0.0014641284942627
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00075006484985352
(101) DESCRIBE `ports` 0.0015871524810791
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00030899047851562
(103) DESCRIBE `ports` 0.0013349056243896
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0003659725189209
(105) DESCRIBE `ports` 0.0014350414276123
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00029802322387695
(107) DESCRIBE `ports` 0.0015280246734619
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00040602684020996
(109) DESCRIBE `ports` 0.0013511180877686
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00028681755065918
(111) DESCRIBE `ports` 0.0013489723205566
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00035810470581055
(113) DESCRIBE `ports` 0.0013670921325684
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00033807754516602
(115) DESCRIBE `ports` 0.0016839504241943
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00037598609924316
(117) DESCRIBE `ports` 0.0013649463653564
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00030899047851562
(119) DESCRIBE `ports` 0.0013799667358398
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00031304359436035
(121) DESCRIBE `ports` 0.0014958381652832
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00030016899108887
(123) DESCRIBE `ports` 0.0012800693511963
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040698051452637
(125) DESCRIBE `ports` 0.001471996307373
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0003349781036377
(127) DESCRIBE `ports` 0.0014641284942627
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034403800964355
(129) DESCRIBE `ports` 0.0014481544494629
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028705596923828
(131) DESCRIBE `cruises` 0.0028390884399414
(132) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 72995))) 0.00046205520629883
(133) DESCRIBE `avid_specials` 0.0014228820800781
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1497393 and class = 'Special') OR (item_id = 72995 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0017139911651611
(135) DESCRIBE `cruiselines` 0.0024600028991699
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00049591064453125
(137) DESCRIBE `orchid_image` 0.0018370151519775
(138) DESCRIBE `cruiselines` 0.0019080638885498
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00040197372436523
(140) DESCRIBE `specials` 0.0047369003295898
(141) DESCRIBE `specials` 0.0054609775543213
(142) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1496799') 0.00052309036254883
(143) DESCRIBE `ships` 0.0034520626068115
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00058889389038086
(145) DESCRIBE `ships` 0.0039131641387939
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00049185752868652
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032186508178711
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(149) DESCRIBE `itineraries` 0.0019481182098389
(150) DESCRIBE `ports` 0.0018651485443115
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048613548278809
(152) DESCRIBE `ports` 0.0019540786743164
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005490779876709
(154) DESCRIBE `ports` 0.0020380020141602
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044107437133789
(156) DESCRIBE `specialsailingdates` 0.0015997886657715
(157) DESCRIBE `sailingdates` 0.0017561912536621
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 438774))) 0.00057315826416016
(159) DESCRIBE `ports` 0.0017919540405273
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044584274291992
(161) DESCRIBE `ports` 0.0017449855804443
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038695335388184
(163) DESCRIBE `ports` 0.0018031597137451
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00042891502380371
(165) DESCRIBE `ports` 0.001945972442627
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00044679641723633
(167) DESCRIBE `ports` 0.0018761157989502
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00038409233093262
(169) DESCRIBE `ports` 0.0018990039825439
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00041103363037109
(171) DESCRIBE `ports` 0.0016908645629883
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00040793418884277
(173) DESCRIBE `ports` 0.0014808177947998
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00031089782714844
(175) DESCRIBE `ports` 0.0014939308166504
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00036406517028809
(177) DESCRIBE `ports` 0.0014560222625732
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00043416023254395
(179) DESCRIBE `ports` 0.0018370151519775
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00042891502380371
(181) DESCRIBE `ports` 0.0015559196472168
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00031495094299316
(183) DESCRIBE `ports` 0.001561164855957
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0003659725189209
(185) DESCRIBE `ports` 0.0014419555664062
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00030088424682617
(187) DESCRIBE `ports` 0.0015838146209717
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034213066101074
(189) DESCRIBE `ports` 0.0016028881072998
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031304359436035
(191) DESCRIBE `cruises` 0.0026900768280029
(192) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69895))) 0.00052094459533691
(193) DESCRIBE `avid_specials` 0.001352071762085
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1496799 and class = 'Special') OR (item_id = 69895 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012521743774414
(195) DESCRIBE `cruiselines` 0.0025339126586914
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00047183036804199
(197) DESCRIBE `orchid_image` 0.0016670227050781
(198) DESCRIBE `cruiselines` 0.0019118785858154
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00039410591125488
(200) DESCRIBE `specials` 0.0049901008605957
(201) DESCRIBE `specials` 0.005328893661499
(202) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1492180') 0.00057101249694824
(203) DESCRIBE `ships` 0.0036330223083496
(204) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00055384635925293
(205) DESCRIBE `ships` 0.0036261081695557
(206) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00046491622924805
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033807754516602
(208) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031781196594238
(209) DESCRIBE `itineraries` 0.0018050670623779
(210) DESCRIBE `ports` 0.0018229484558105
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050592422485352
(212) DESCRIBE `ports` 0.0017318725585938
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00042414665222168
(214) DESCRIBE `ports` 0.0016129016876221
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029587745666504
(216) DESCRIBE `specialsailingdates` 0.0010490417480469
(217) DESCRIBE `sailingdates` 0.0011980533599854
(218) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 494406))) 0.0004880428314209
(219) DESCRIBE `ports` 0.0013799667358398
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033092498779297
(221) DESCRIBE `ports` 0.0013120174407959
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034880638122559
(223) DESCRIBE `ports` 0.0014650821685791
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00044608116149902
(225) DESCRIBE `ports` 0.0018758773803711
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00038719177246094
(227) DESCRIBE `ports` 0.0018110275268555
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004730224609375
(229) DESCRIBE `ports` 0.0019509792327881
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003972053527832
(231) DESCRIBE `cruises` 0.0027949810028076
(232) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80004))) 0.00038790702819824
(233) DESCRIBE `avid_specials` 0.0013527870178223
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1492180 and class = 'Special') OR (item_id = 80004 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 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.0018820762634277
(235) DESCRIBE `cruiselines` 0.0026190280914307
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00046491622924805
(237) DESCRIBE `orchid_image` 0.0020499229431152
(238) DESCRIBE `cruiselines` 0.002551794052124
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00032210350036621
(240) DESCRIBE `specials` 0.0040149688720703
(241) DESCRIBE `specials` 0.0054471492767334
(242) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1488100') 0.00058603286743164
(243) DESCRIBE `ships` 0.0028688907623291
(244) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) 0.00048494338989258
(245) DESCRIBE `ships` 0.0038509368896484
(246) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') 0.00048303604125977
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034809112548828
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043606758117676
(249) DESCRIBE `itineraries` 0.001917839050293
(250) DESCRIBE `ports` 0.0015218257904053
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00036096572875977
(252) DESCRIBE `ports` 0.0014121532440186
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033092498779297
(254) DESCRIBE `ports` 0.0016450881958008
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037121772766113
(256) DESCRIBE `specialsailingdates` 0.00136399269104
(257) DESCRIBE `sailingdates` 0.0014998912811279
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428527))) 0.00046610832214355
(259) DESCRIBE `ports` 0.0017869472503662
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00046586990356445
(261) DESCRIBE `ports` 0.0018100738525391
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00041007995605469
(263) DESCRIBE `ports` 0.0015969276428223
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00036096572875977
(265) DESCRIBE `ports` 0.0013570785522461
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00029993057250977
(267) DESCRIBE `ports` 0.0017960071563721
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00054001808166504
(269) DESCRIBE `ports` 0.0017819404602051
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00038003921508789
(271) DESCRIBE `ports` 0.0014891624450684
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00031495094299316
(273) DESCRIBE `ports` 0.0013461112976074
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00027585029602051
(275) DESCRIBE `ports` 0.0012838840484619
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00036191940307617
(277) DESCRIBE `ports` 0.001662015914917
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0004420280456543
(279) DESCRIBE `cruises` 0.0041100978851318
(280) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67917))) 0.00060796737670898
(281) DESCRIBE `avid_specials` 0.0018219947814941
(282) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1488100 and class = 'Special') OR (item_id = 67917 and class = 'Cruise') OR (item_id = 669 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0014269351959229
(283) DESCRIBE `cruiselines` 0.0023071765899658
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00041913986206055
(285) DESCRIBE `orchid_image` 0.0018670558929443
(286) DESCRIBE `cruiselines` 0.0021989345550537
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00036311149597168
(288) DESCRIBE `specials` 0.0042550563812256
(289) DESCRIBE `specials` 0.0042991638183594
(290) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1492181') 0.00075697898864746
(291) DESCRIBE `ships` 0.0035390853881836
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.0004420280456543
(293) DESCRIBE `ships` 0.0058019161224365
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00043201446533203
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032997131347656
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031399726867676
(297) DESCRIBE `itineraries` 0.0017809867858887
(298) DESCRIBE `ports` 0.0018329620361328
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045895576477051
(300) DESCRIBE `ports` 0.0025410652160645
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042104721069336
(302) DESCRIBE `ports` 0.001708984375
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036501884460449
(304) DESCRIBE `specialsailingdates` 0.0013468265533447
(305) DESCRIBE `sailingdates` 0.0030171871185303
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 494408))) 0.00045895576477051
(307) DESCRIBE `ports` 0.0017838478088379
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042891502380371
(309) DESCRIBE `ports` 0.0017530918121338
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037789344787598
(311) DESCRIBE `ports` 0.0020499229431152
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041294097900391
(313) DESCRIBE `ports` 0.0016739368438721
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035309791564941
(315) DESCRIBE `ports` 0.0017380714416504
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00042295455932617
(317) DESCRIBE `ports` 0.0017318725585938
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00042581558227539
(319) DESCRIBE `ports` 0.0017900466918945
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0006401538848877
(321) DESCRIBE `ports` 0.0018730163574219
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00037622451782227
(323) DESCRIBE `ports` 0.0017211437225342
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0004119873046875
(325) DESCRIBE `ports` 0.0017080307006836
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00038003921508789
(327) DESCRIBE `ports` 0.00180983543396
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00058698654174805
(329) DESCRIBE `ports` 0.0016138553619385
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00036406517028809
(331) DESCRIBE `ports` 0.0016670227050781
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00043416023254395
(333) DESCRIBE `ports` 0.0018188953399658
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00040388107299805
(335) DESCRIBE `ports` 0.0017149448394775
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00043296813964844
(337) DESCRIBE `ports` 0.0018770694732666
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0004570484161377
(339) DESCRIBE `ports` 0.0081949234008789
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00045990943908691
(341) DESCRIBE `ports` 0.0018310546875
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00036907196044922
(343) DESCRIBE `ports` 0.0045289993286133
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00054097175598145
(345) DESCRIBE `ports` 0.0017378330230713
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00037121772766113
(347) DESCRIBE `ports` 0.0019650459289551
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0035991668701172
(349) DESCRIBE `ports` 0.0020239353179932
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0014898777008057
(351) DESCRIBE `cruises` 0.0034010410308838
(352) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80005))) 0.0010011196136475
(353) DESCRIBE `avid_specials` 0.0014920234680176
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1492181 and class = 'Special') OR (item_id = 80005 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 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.013238191604614
(355) DESCRIBE `cruiselines` 0.0021998882293701
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00031495094299316
(357) DESCRIBE `orchid_image` 0.0019850730895996
(358) DESCRIBE `cruiselines` 0.0022969245910645
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0031599998474121
(360) DESCRIBE `specials` 0.0044300556182861
(361) DESCRIBE `specials` 0.014611005783081
(362) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1491947') 0.0038261413574219
(363) DESCRIBE `ships` 0.0041980743408203
(364) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1474))) 0.00038003921508789
(365) DESCRIBE `ships` 0.002586841583252
(366) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1474') 0.00037384033203125
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00040507316589355
(368) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003359317779541
(369) DESCRIBE `itineraries` 0.0018799304962158
(370) DESCRIBE `ports` 0.0019278526306152
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00043201446533203
(372) DESCRIBE `ports` 0.0018379688262939
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00029993057250977
(374) DESCRIBE `ports` 0.0024628639221191
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00037002563476562
(376) DESCRIBE `specialsailingdates` 0.0093908309936523
(377) DESCRIBE `sailingdates` 0.0028891563415527
(378) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 486299))) 0.00050592422485352
(379) DESCRIBE `ports` 0.0016639232635498
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.0003199577331543
(381) DESCRIBE `ports` 0.0015208721160889
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00032401084899902
(383) DESCRIBE `ports` 0.0017650127410889
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2024))) 0.0068080425262451
(385) DESCRIBE `ports` 0.0040388107299805
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2024') 0.0029010772705078
(387) DESCRIBE `ports` 0.0015261173248291
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 786))) 0.0047228336334229
(389) DESCRIBE `ports` 0.0013599395751953
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '786') 0.00028610229492188
(391) DESCRIBE `ports` 0.001147985458374
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0013399124145508
(393) DESCRIBE `ports` 0.0013551712036133
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0069019794464111
(395) DESCRIBE `ports` 0.0020442008972168
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00044488906860352
(397) DESCRIBE `ports` 0.0019500255584717
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.006483793258667
(399) DESCRIBE `ports` 0.0018270015716553
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00037693977355957
(401) DESCRIBE `ports` 0.0016021728515625
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.0019040107727051
(403) DESCRIBE `ports` 0.0050630569458008
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00044393539428711
(405) DESCRIBE `ports` 0.0014948844909668
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.004270076751709
(407) DESCRIBE `ports` 0.0013940334320068
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0041749477386475
(409) DESCRIBE `ports` 0.0018270015716553
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.005842924118042
(411) DESCRIBE `ports` 0.0013258457183838
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020194053649902
(413) DESCRIBE `ports` 0.0013141632080078
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00035786628723145
(415) DESCRIBE `ports` 0.0017800331115723
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0093638896942139
(417) DESCRIBE `ports` 0.0014948844909668
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00030303001403809
(419) DESCRIBE `ports` 0.0012598037719727
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0003972053527832
(421) DESCRIBE `ports` 0.0016889572143555
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.0062789916992188
(423) DESCRIBE `ports` 0.0018138885498047
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017809867858887
(425) DESCRIBE `ports` 0.0018539428710938
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0038189888000488
(427) DESCRIBE `ports` 0.0013320446014404
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0036540031433105
(429) DESCRIBE `ports` 0.0013589859008789
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0027909278869629
(431) DESCRIBE `cruises` 0.0024800300598145
(432) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 78125))) 0.0048279762268066
(433) DESCRIBE `avid_specials` 0.001291036605835
(434) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1491947 and class = 'Special') OR (item_id = 78125 and class = 'Cruise') OR (item_id = 1474 AND class = 'Ship') OR (item_id = 262 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.0010519027709961
(435) DESCRIBE `cruiselines` 0.0083119869232178
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00051522254943848
(437) DESCRIBE `orchid_image` 0.0014989376068115
(438) DESCRIBE `cruiselines` 0.0061781406402588
(439) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00033402442932129
(440) DESCRIBE `specials` 0.007728099822998
(441) DESCRIBE `specials` 0.0096771717071533
(442) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1481854') 0.015400171279907
(443) DESCRIBE `ships` 0.0033450126647949
(444) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00056791305541992
(445) DESCRIBE `ships` 0.0033080577850342
(446) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.008303165435791
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033187866210938
(448) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024986267089844
(449) DESCRIBE `itineraries` 0.0085620880126953
(450) DESCRIBE `ports` 0.0013580322265625
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0067930221557617
(452) DESCRIBE `ports` 0.0013730525970459
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030994415283203
(454) DESCRIBE `ports` 0.0013871192932129
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027894973754883
(456) DESCRIBE `specialsailingdates` 0.0012249946594238
(457) DESCRIBE `sailingdates` 0.0011570453643799
(458) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419451))) 0.0027570724487305
(459) DESCRIBE `ports` 0.0013630390167236
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00099086761474609
(461) DESCRIBE `ports` 0.0013561248779297
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029587745666504
(463) DESCRIBE `ports` 0.0017101764678955
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00032401084899902
(465) DESCRIBE `ports` 0.0016121864318848
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00031805038452148
(467) DESCRIBE `ports` 0.0012671947479248
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0003349781036377
(469) DESCRIBE `ports` 0.0013301372528076
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026583671569824
(471) DESCRIBE `ports` 0.001345157623291
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00029683113098145
(473) DESCRIBE `ports` 0.0012879371643066
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 3.3140182495117E-5
(475) DESCRIBE `ports` 0.001500129699707
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00040197372436523
(477) DESCRIBE `ports` 0.0013608932495117
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0
(479) DESCRIBE `ports` 0.0014030933380127
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043797492980957
(481) DESCRIBE `ports` 0.0010879039764404
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(483) DESCRIBE `ports` 0.0012609958648682
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0003209114074707
(485) DESCRIBE `ports` 0.0014200210571289
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0005338191986084
(487) DESCRIBE `ports` 0.0018548965454102
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0003809928894043
(489) DESCRIBE `ports` 0.00130295753479
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00029277801513672
(491) DESCRIBE `ports` 0.0013151168823242
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.0003211498260498
(493) DESCRIBE `ports` 0.0012619495391846
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00030517578125
(495) DESCRIBE `cruises` 0.0024080276489258
(496) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66816))) 0.00053286552429199
(497) DESCRIBE `avid_specials` 0.0013511180877686
(498) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1481854 and class = 'Special') OR (item_id = 66816 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.0011880397796631
(499) DESCRIBE `cruiselines` 0.0022299289703369
(500) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00046300888061523
(501) DESCRIBE `orchid_image` 0.0016229152679443
(502) DESCRIBE `cruiselines` 0.0020670890808105
(503) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00032186508178711
(504) DESCRIBE `specials` 0.0038859844207764
(505) DESCRIBE `specials` 0.0043399333953857
(506) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1489695') 0.00055408477783203
(507) DESCRIBE `ships` 0.0026659965515137
(508) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00043582916259766
(509) DESCRIBE `ships` 0.002877950668335
(510) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00053095817565918
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00033807754516602
(512) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034809112548828
(513) DESCRIBE `itineraries` 0.0021369457244873
(514) DESCRIBE `ports` 0.0016601085662842
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037503242492676
(516) DESCRIBE `ports` 0.001317024230957
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031805038452148
(518) DESCRIBE `ports` 0.0013258457183838
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031399726867676
(520) DESCRIBE `specialsailingdates` 0.0011360645294189
(521) DESCRIBE `sailingdates` 0.0012929439544678
(522) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485882))) 0.00045990943908691
(523) DESCRIBE `ports` 0.001859188079834
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052404403686523
(525) DESCRIBE `ports` 0.0019669532775879
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044393539428711
(527) DESCRIBE `ports` 0.0019428730010986
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049495697021484
(529) DESCRIBE `ports` 0.0019059181213379
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041890144348145
(531) DESCRIBE `cruises` 0.0035881996154785
(532) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 77957))) 0.00070500373840332
(533) DESCRIBE `avid_specials` 0.0018081665039062
(534) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1489695 and class = 'Special') OR (item_id = 77957 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0013229846954346
(535) DESCRIBE `cruiselines` 0.0029010772705078
(536) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00055599212646484
(537) DESCRIBE `orchid_image` 0.0020821094512939
(538) DESCRIBE `cruiselines` 0.0021288394927979
(539) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00037097930908203
(540) DESCRIBE `specials` 0.0042579174041748
(541) DESCRIBE `specials` 0.005511999130249
(542) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1485102') 0.00059199333190918
(543) DESCRIBE `ships` 0.0036311149597168
(544) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00047087669372559
(545) DESCRIBE `ships` 0.0031440258026123
(546) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00040793418884277
(547) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029492378234863
(548) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030803680419922
(549) DESCRIBE `itineraries` 0.0016539096832275
(550) DESCRIBE `ports` 0.0017330646514893
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043892860412598
(552) DESCRIBE `ports` 0.0017271041870117
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00047183036804199
(554) DESCRIBE `ports` 0.0018949508666992
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00035691261291504
(556) DESCRIBE `specialsailingdates` 0.0013070106506348
(557) DESCRIBE `sailingdates` 0.0012660026550293
(558) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 476173))) 0.00056982040405273
(559) DESCRIBE `ports` 0.0017011165618896
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048494338989258
(561) DESCRIBE `ports` 0.0016779899597168
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039315223693848
(563) DESCRIBE `ports` 0.0016701221466064
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00050687789916992
(565) DESCRIBE `ports` 0.0017430782318115
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041294097900391
(567) DESCRIBE `ports` 0.0017290115356445
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1775))) 0.00048995018005371
(569) DESCRIBE `ports` 0.0019440650939941
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1775') 0.00050497055053711
(571) DESCRIBE `ports` 0.0019659996032715
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00051116943359375
(573) DESCRIBE `ports` 0.0019748210906982
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00047087669372559
(575) DESCRIBE `ports` 0.0018720626831055
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00050783157348633
(577) DESCRIBE `ports` 0.0016229152679443
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00045204162597656
(579) DESCRIBE `ports` 0.0017189979553223
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00057101249694824
(581) DESCRIBE `ports` 0.0018229484558105
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00044417381286621
(583) DESCRIBE `ports` 0.0017869472503662
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00046205520629883
(585) DESCRIBE `ports` 0.001762866973877
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00042390823364258
(587) DESCRIBE `ports` 0.0015521049499512
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00037384033203125
(589) DESCRIBE `ports` 0.0015268325805664
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00035405158996582
(591) DESCRIBE `ports` 0.0017290115356445
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00043582916259766
(593) DESCRIBE `ports` 0.0016300678253174
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00036907196044922
(595) DESCRIBE `cruises` 0.0029158592224121
(596) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75551))) 0.0005488395690918
(597) DESCRIBE `avid_specials` 0.0015230178833008
(598) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1485102 and class = 'Special') OR (item_id = 75551 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.00142502784729
(599) DESCRIBE `cruiselines` 0.0021119117736816
(600) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00050497055053711
(601) DESCRIBE `orchid_image` 0.0021679401397705
(602) DESCRIBE `cruiselines` 0.0031960010528564
(603) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00036311149597168
(604) DESCRIBE `cruiselines` 0.0026190280914307
(605) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('91', '151', '23', '29', '8', '15', '37', '187', '262', '4', '20', '26', '33', '218')) ORDER BY FIND_IN_SET(id, '91,151,23,29,8,15,37,187,262,4,20,26,33,218') 0.0017640590667725
(606) DESCRIBE `ships` 0.0042340755462646
(607) SELECT `ships`.* FROM `ships` WHERE (id IN ('451', '148', '394', '652', '683', '780', '1108', '1454', '1474', '1672', '4', '163', '223', '287', '485', '616', '669', '678', '1284', '1319', '1402')) ORDER BY FIND_IN_SET(id, '451,148,394,652,683,780,1108,1454,1474,1672,4,163,223,287,485,616,669,678,1284,1319,1402') 0.0030748844146729
(608) DESCRIBE `cruisetypes` 0.0023500919342041
(609) DESCRIBE `destinations` 0.0024740695953369
(610) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '40', '22', '8', '2', '25', '26', '35', '53')) ORDER BY FIND_IN_SET(id, '43,40,22,8,2,25,26,35,53') 0.0014169216156006