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

Total elapsed time: 0.67636299133301

# Query Time
(1) connect 0.00053811073303223
(2) DESCRIBE `cruises` 0.003892183303833
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (38689, 25176, 38690, 67001, 67000, 67002, 77636, 74236, 74237, 67256)) ORDER BY FIND_IN_SET(id, '38689,25176,38690,67001,67000,67002,77636,74236,74237,67256') 0.001939058303833
(4) DESCRIBE `cruises` 0.00341796875
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38689') 0.00047016143798828
(6) DESCRIBE `ships` 0.003093957901001
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00046396255493164
(8) DESCRIBE `ships` 0.0028269290924072
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00045490264892578
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033807754516602
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027990341186523
(12) DESCRIBE `itineraries` 0.0016598701477051
(13) DESCRIBE `ports` 0.0018439292907715
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041794776916504
(15) DESCRIBE `ports` 0.0018999576568604
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041699409484863
(17) DESCRIBE `ports` 0.0016880035400391
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038790702819824
(19) DESCRIBE `sailingdates` 0.0018138885498047
(20) DESCRIBE `ports` 0.0020818710327148
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051307678222656
(22) DESCRIBE `ports` 0.001924991607666
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042891502380371
(24) DESCRIBE `ports` 0.0018148422241211
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00043797492980957
(26) DESCRIBE `ports` 0.0017762184143066
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00039792060852051
(28) DESCRIBE `ports` 0.0017831325531006
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00043916702270508
(30) DESCRIBE `ports` 0.0019159317016602
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00061297416687012
(32) DESCRIBE `ports` 0.0019829273223877
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00045299530029297
(34) DESCRIBE `ports` 0.0019679069519043
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00044012069702148
(36) DESCRIBE `ports` 0.0020601749420166
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00046181678771973
(38) DESCRIBE `ports` 0.0019559860229492
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00045084953308105
(40) DESCRIBE `ports` 0.0020439624786377
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00045895576477051
(42) DESCRIBE `ports` 0.001978874206543
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00042390823364258
(44) DESCRIBE `ports` 0.0018069744110107
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00043702125549316
(46) DESCRIBE `ports` 0.0018539428710938
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00049495697021484
(48) DESCRIBE `ports` 0.0018670558929443
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00044703483581543
(50) DESCRIBE `ports` 0.0019409656524658
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00039482116699219
(52) DESCRIBE `ports` 0.0015778541564941
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0004730224609375
(54) DESCRIBE `ports` 0.0018730163574219
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00043511390686035
(56) DESCRIBE `avid_specials` 0.001755952835083
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38689 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013999938964844
(58) DESCRIBE `cruiselines` 0.002208948135376
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00033807754516602
(60) DESCRIBE `orchid_image` 0.002000093460083
(61) DESCRIBE `cruiselines` 0.0016849040985107
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00032711029052734
(63) DESCRIBE `cruises` 0.0026130676269531
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '25176') 0.0003669261932373
(65) DESCRIBE `ships` 0.0027108192443848
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00020408630371094
(67) DESCRIBE `ships` 0.0027401447296143
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00032711029052734
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025105476379395
(71) DESCRIBE `itineraries` 0.0014019012451172
(72) DESCRIBE `ports` 0.0014300346374512
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00034308433532715
(74) DESCRIBE `ports` 0.0012640953063965
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0003511905670166
(76) DESCRIBE `ports` 0.0013198852539062
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0003669261932373
(78) DESCRIBE `sailingdates` 0.0012590885162354
(79) DESCRIBE `ports` 0.0013949871063232
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00037002563476562
(81) DESCRIBE `ports` 0.001262903213501
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00028491020202637
(83) DESCRIBE `ports` 0.001309871673584
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00030994415283203
(85) DESCRIBE `ports` 0.0012791156768799
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00030684471130371
(87) DESCRIBE `ports` 0.0013279914855957
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00029897689819336
(89) DESCRIBE `ports` 0.0013329982757568
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00040698051452637
(91) DESCRIBE `ports` 0.0016751289367676
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00047993659973145
(93) DESCRIBE `ports` 0.0015950202941895
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00071811676025391
(95) DESCRIBE `ports` 0.0014259815216064
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0003359317779541
(97) DESCRIBE `ports` 0.0018720626831055
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00043392181396484
(99) DESCRIBE `avid_specials` 0.0015308856964111
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 25176 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0010840892791748
(101) DESCRIBE `cruiselines` 0.0021939277648926
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00037193298339844
(103) DESCRIBE `orchid_image` 0.0017950534820557
(104) DESCRIBE `cruiselines` 0.0024938583374023
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00042605400085449
(106) DESCRIBE `cruises` 0.0034768581390381
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38690') 0.00045919418334961
(108) DESCRIBE `ships` 0.0036439895629883
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00073409080505371
(110) DESCRIBE `ships` 0.0039808750152588
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00062298774719238
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040006637573242
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(114) DESCRIBE `itineraries` 0.0018911361694336
(115) DESCRIBE `ports` 0.0019369125366211
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00052881240844727
(117) DESCRIBE `ports` 0.0017669200897217
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00042009353637695
(119) DESCRIBE `ports` 0.0018289089202881
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00044798851013184
(121) DESCRIBE `sailingdates` 0.0017688274383545
(122) DESCRIBE `ports` 0.0017149448394775
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00042009353637695
(124) DESCRIBE `ports` 0.0017039775848389
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00042819976806641
(126) DESCRIBE `ports` 0.0019500255584717
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00050902366638184
(128) DESCRIBE `ports` 0.0019841194152832
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00052404403686523
(130) DESCRIBE `ports` 0.0017831325531006
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.0005180835723877
(132) DESCRIBE `ports` 0.0017440319061279
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00043988227844238
(134) DESCRIBE `ports` 0.0019879341125488
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00049591064453125
(136) DESCRIBE `ports` 0.0019128322601318
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00045204162597656
(138) DESCRIBE `ports` 0.0019028186798096
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00054597854614258
(140) DESCRIBE `ports` 0.0018870830535889
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00038313865661621
(142) DESCRIBE `ports` 0.0020442008972168
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.0005040168762207
(144) DESCRIBE `ports` 0.0018770694732666
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00038909912109375
(146) DESCRIBE `ports` 0.0015451908111572
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00046396255493164
(148) DESCRIBE `ports` 0.0016729831695557
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00033283233642578
(150) DESCRIBE `ports` 0.0014979839324951
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00037693977355957
(152) DESCRIBE `ports` 0.0016598701477051
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00037097930908203
(154) DESCRIBE `ports` 0.0015599727630615
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035595893859863
(156) DESCRIBE `ports` 0.0014998912811279
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044012069702148
(158) DESCRIBE `avid_specials` 0.0015850067138672
(159) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38690 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.001986026763916
(160) DESCRIBE `cruiselines` 0.002683162689209
(161) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00069999694824219
(162) DESCRIBE `orchid_image` 0.0024118423461914
(163) DESCRIBE `cruiselines` 0.003242015838623
(164) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00047898292541504
(165) DESCRIBE `cruises` 0.0038280487060547
(166) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67001') 0.00058412551879883
(167) DESCRIBE `ships` 0.0040159225463867
(168) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00064611434936523
(169) DESCRIBE `ships` 0.0038390159606934
(170) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00046086311340332
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034904479980469
(172) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031805038452148
(173) DESCRIBE `itineraries` 0.0016660690307617
(174) DESCRIBE `ports` 0.0016758441925049
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00038504600524902
(176) DESCRIBE `ports` 0.0016798973083496
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00036001205444336
(178) DESCRIBE `ports` 0.0014770030975342
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00031113624572754
(180) DESCRIBE `sailingdates` 0.0013070106506348
(181) DESCRIBE `ports` 0.001582145690918
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00035405158996582
(183) DESCRIBE `ports` 0.0017201900482178
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00038886070251465
(185) DESCRIBE `ports` 0.0019469261169434
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00040388107299805
(187) DESCRIBE `ports` 0.0017399787902832
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00038886070251465
(189) DESCRIBE `ports` 0.0019049644470215
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.0004878044128418
(191) DESCRIBE `ports` 0.0018949508666992
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.0004279613494873
(193) DESCRIBE `ports` 0.0018579959869385
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00047898292541504
(195) DESCRIBE `ports` 0.0019071102142334
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.0004429817199707
(197) DESCRIBE `ports` 0.0019769668579102
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00044083595275879
(199) DESCRIBE `ports` 0.0014839172363281
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00031781196594238
(201) DESCRIBE `ports` 0.0012922286987305
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033712387084961
(203) DESCRIBE `ports` 0.0015020370483398
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00036811828613281
(205) DESCRIBE `avid_specials` 0.0016670227050781
(206) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67001 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0018510818481445
(207) DESCRIBE `cruiselines` 0.0026919841766357
(208) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00055789947509766
(209) DESCRIBE `orchid_image` 0.0021719932556152
(210) DESCRIBE `cruiselines` 0.0027790069580078
(211) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00049495697021484
(212) DESCRIBE `cruises` 0.0030560493469238
(213) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67000') 0.00052285194396973
(214) DESCRIBE `ships` 0.0035312175750732
(215) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00067591667175293
(216) DESCRIBE `ships` 0.004115104675293
(217) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00052213668823242
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031113624572754
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029993057250977
(220) DESCRIBE `itineraries` 0.0018718242645264
(221) DESCRIBE `ports` 0.0019059181213379
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045490264892578
(223) DESCRIBE `ports` 0.0015349388122559
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048112869262695
(225) DESCRIBE `ports` 0.0020480155944824
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044608116149902
(227) DESCRIBE `sailingdates` 0.0017149448394775
(228) DESCRIBE `ports` 0.001572847366333
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051498413085938
(230) DESCRIBE `ports` 0.002187967300415
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00078105926513672
(232) DESCRIBE `ports` 0.0016360282897949
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00054097175598145
(234) DESCRIBE `ports` 0.001716136932373
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00042104721069336
(236) DESCRIBE `ports` 0.001741886138916
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00045394897460938
(238) DESCRIBE `ports` 0.0017948150634766
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00040507316589355
(240) DESCRIBE `ports` 0.0017039775848389
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00059103965759277
(242) DESCRIBE `ports` 0.0016300678253174
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00038886070251465
(244) DESCRIBE `ports` 0.0012969970703125
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00036907196044922
(246) DESCRIBE `ports` 0.0016520023345947
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00039005279541016
(248) DESCRIBE `ports` 0.0015380382537842
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050687789916992
(250) DESCRIBE `ports` 0.0020051002502441
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00055217742919922
(252) DESCRIBE `avid_specials` 0.0017218589782715
(253) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67000 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022130012512207
(254) DESCRIBE `cruiselines` 0.0028009414672852
(255) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00046014785766602
(256) DESCRIBE `orchid_image` 0.0016920566558838
(257) DESCRIBE `cruiselines` 0.0023410320281982
(258) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0004429817199707
(259) DESCRIBE `cruises` 0.0033919811248779
(260) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67002') 0.00048303604125977
(261) DESCRIBE `ships` 0.0029900074005127
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00045895576477051
(263) DESCRIBE `ships` 0.0038077831268311
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00061798095703125
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035691261291504
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(267) DESCRIBE `itineraries` 0.0019140243530273
(268) DESCRIBE `ports` 0.0019490718841553
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046491622924805
(270) DESCRIBE `ports` 0.0016438961029053
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046491622924805
(272) DESCRIBE `ports` 0.0018470287322998
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00021100044250488
(274) DESCRIBE `sailingdates` 0.0012729167938232
(275) DESCRIBE `ports` 0.0012860298156738
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047397613525391
(277) DESCRIBE `ports` 0.0015327930450439
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00030303001403809
(279) DESCRIBE `ports` 0.0011570453643799
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00030422210693359
(281) DESCRIBE `ports` 0.0013089179992676
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.0002739429473877
(283) DESCRIBE `ports` 0.0012929439544678
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00030303001403809
(285) DESCRIBE `ports` 0.0013718605041504
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00027990341186523
(287) DESCRIBE `ports` 0.001284122467041
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00031590461730957
(289) DESCRIBE `ports` 0.0010089874267578
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00026988983154297
(291) DESCRIBE `ports` 0.0012400150299072
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041413307189941
(293) DESCRIBE `ports` 0.001338005065918
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028204917907715
(295) DESCRIBE `avid_specials` 0.001101016998291
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67002 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010480880737305
(297) DESCRIBE `cruiselines` 0.001939058303833
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00037503242492676
(299) DESCRIBE `orchid_image` 0.001662015914917
(300) DESCRIBE `cruiselines` 0.0020182132720947
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00028705596923828
(302) DESCRIBE `cruises` 0.0026199817657471
(303) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77636') 0.0004878044128418
(304) DESCRIBE `ships` 0.0040740966796875
(305) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00065493583679199
(306) DESCRIBE `ships` 0.003849983215332
(307) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00047802925109863
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034785270690918
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(310) DESCRIBE `itineraries` 0.0018630027770996
(311) DESCRIBE `ports` 0.0015549659729004
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043416023254395
(313) DESCRIBE `ports` 0.0016160011291504
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032901763916016
(315) DESCRIBE `ports` 0.0014119148254395
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0003349781036377
(317) DESCRIBE `sailingdates` 0.0012509822845459
(318) DESCRIBE `ports` 0.0013449192047119
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00036907196044922
(320) DESCRIBE `ports` 0.0017650127410889
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0003960132598877
(322) DESCRIBE `ports` 0.0017199516296387
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1135))) 0.00057506561279297
(324) DESCRIBE `ports` 0.0015368461608887
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1135') 0.00031590461730957
(326) DESCRIBE `ports` 0.0016129016876221
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00045585632324219
(328) DESCRIBE `ports` 0.0019159317016602
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00043797492980957
(330) DESCRIBE `ports` 0.0016751289367676
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00034213066101074
(332) DESCRIBE `ports` 0.0013821125030518
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00030612945556641
(334) DESCRIBE `ports` 0.0013411045074463
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00036191940307617
(336) DESCRIBE `ports` 0.00136399269104
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00030207633972168
(338) DESCRIBE `ports` 0.0014297962188721
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00034499168395996
(340) DESCRIBE `ports` 0.001331090927124
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00032186508178711
(342) DESCRIBE `ports` 0.0013930797576904
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00033402442932129
(344) DESCRIBE `ports` 0.0013689994812012
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00029110908508301
(346) DESCRIBE `ports` 0.0012650489807129
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032997131347656
(348) DESCRIBE `ports` 0.0017471313476562
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00032687187194824
(350) DESCRIBE `avid_specials` 0.0015370845794678
(351) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77636 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 38 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.0017929077148438
(352) DESCRIBE `cruiselines` 0.0027039051055908
(353) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00053715705871582
(354) DESCRIBE `orchid_image` 0.0016639232635498
(355) DESCRIBE `cruiselines` 0.0022058486938477
(356) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00043916702270508
(357) DESCRIBE `cruises` 0.003140926361084
(358) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74236') 0.00041389465332031
(359) DESCRIBE `ships` 0.0027108192443848
(360) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00043892860412598
(361) DESCRIBE `ships` 0.0033290386199951
(362) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00045204162597656
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(365) DESCRIBE `itineraries` 0.0014069080352783
(366) DESCRIBE `ports` 0.0016350746154785
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042390823364258
(368) DESCRIBE `ports` 0.0018541812896729
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00044608116149902
(370) DESCRIBE `ports` 0.0016021728515625
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035786628723145
(372) DESCRIBE `sailingdates` 0.0011529922485352
(373) DESCRIBE `ports` 0.001427173614502
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00037884712219238
(375) DESCRIBE `ports` 0.0014100074768066
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00034403800964355
(377) DESCRIBE `ports` 0.0017058849334717
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00034880638122559
(379) DESCRIBE `ports` 0.0016989707946777
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00033998489379883
(381) DESCRIBE `ports` 0.0016858577728271
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00062799453735352
(383) DESCRIBE `ports` 0.001845121383667
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00037598609924316
(385) DESCRIBE `ports` 0.0013689994812012
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041389465332031
(387) DESCRIBE `ports` 0.0014300346374512
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00031185150146484
(389) DESCRIBE `ports` 0.0014858245849609
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00058698654174805
(391) DESCRIBE `ports` 0.0017809867858887
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00036191940307617
(393) DESCRIBE `ports` 0.0019230842590332
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00070405006408691
(395) DESCRIBE `ports` 0.0019400119781494
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00045895576477051
(397) DESCRIBE `ports` 0.0016858577728271
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00035500526428223
(399) DESCRIBE `ports` 0.0017809867858887
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0003819465637207
(401) DESCRIBE `ports` 0.0014090538024902
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00035500526428223
(403) DESCRIBE `ports` 0.0013439655303955
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00033903121948242
(405) DESCRIBE `ports` 0.001554012298584
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00043797492980957
(407) DESCRIBE `ports` 0.0014622211456299
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00030088424682617
(409) DESCRIBE `ports` 0.0013320446014404
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00035381317138672
(411) DESCRIBE `ports` 0.0015509128570557
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0003821849822998
(413) DESCRIBE `ports` 0.0013358592987061
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00041794776916504
(415) DESCRIBE `ports` 0.0017580986022949
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00042605400085449
(417) DESCRIBE `ports` 0.0015521049499512
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041413307189941
(419) DESCRIBE `ports` 0.0019910335540771
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00034189224243164
(421) DESCRIBE `avid_specials` 0.0013020038604736
(422) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74236 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0015280246734619
(423) DESCRIBE `cruiselines` 0.0029401779174805
(424) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00067400932312012
(425) DESCRIBE `orchid_image` 0.0020980834960938
(426) DESCRIBE `cruiselines` 0.0025448799133301
(427) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00043797492980957
(428) DESCRIBE `cruises` 0.0033719539642334
(429) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74237') 0.00046205520629883
(430) DESCRIBE `ships` 0.0034921169281006
(431) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00058078765869141
(432) DESCRIBE `ships` 0.0034298896789551
(433) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00042819976806641
(434) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003211498260498
(435) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038814544677734
(436) DESCRIBE `itineraries` 0.0016889572143555
(437) DESCRIBE `ports` 0.0016670227050781
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00056314468383789
(439) DESCRIBE `ports` 0.0017910003662109
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041890144348145
(441) DESCRIBE `ports` 0.0018022060394287
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003511905670166
(443) DESCRIBE `sailingdates` 0.0014359951019287
(444) DESCRIBE `ports` 0.0016701221466064
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042104721069336
(446) DESCRIBE `ports` 0.0014350414276123
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00030708312988281
(448) DESCRIBE `ports` 0.0016281604766846
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00042104721069336
(450) DESCRIBE `ports` 0.001507043838501
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00029587745666504
(452) DESCRIBE `ports` 0.0013928413391113
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00036883354187012
(454) DESCRIBE `ports` 0.0016200542449951
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00039410591125488
(456) DESCRIBE `ports` 0.0017940998077393
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00043201446533203
(458) DESCRIBE `ports` 0.0016639232635498
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00037407875061035
(460) DESCRIBE `ports` 0.0018510818481445
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00043296813964844
(462) DESCRIBE `ports` 0.0016891956329346
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00038504600524902
(464) DESCRIBE `ports` 0.0018110275268555
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00044798851013184
(466) DESCRIBE `ports` 0.0019412040710449
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00038409233093262
(468) DESCRIBE `ports` 0.0017070770263672
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00045204162597656
(470) DESCRIBE `ports` 0.0017411708831787
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00040102005004883
(472) DESCRIBE `ports` 0.0017209053039551
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00042104721069336
(474) DESCRIBE `ports` 0.0017402172088623
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00039505958557129
(476) DESCRIBE `ports` 0.001755952835083
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00045895576477051
(478) DESCRIBE `ports` 0.0018248558044434
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0003819465637207
(480) DESCRIBE `ports` 0.0017108917236328
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042414665222168
(482) DESCRIBE `ports` 0.0016739368438721
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00035405158996582
(484) DESCRIBE `avid_specials` 0.0014560222625732
(485) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74237 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0017549991607666
(486) DESCRIBE `cruiselines` 0.0023660659790039
(487) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00043606758117676
(488) DESCRIBE `orchid_image` 0.0019068717956543
(489) DESCRIBE `cruiselines` 0.0018808841705322
(490) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00041794776916504
(491) DESCRIBE `cruises` 0.0034060478210449
(492) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67256') 0.00067996978759766
(493) DESCRIBE `ships` 0.0039730072021484
(494) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00070714950561523
(495) DESCRIBE `ships` 0.0037930011749268
(496) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00052094459533691
(497) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(498) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029706954956055
(499) DESCRIBE `itineraries` 0.0019690990447998
(500) DESCRIBE `ports` 0.0019569396972656
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048112869262695
(502) DESCRIBE `ports` 0.0018339157104492
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00051498413085938
(504) DESCRIBE `ports` 0.0019280910491943
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00051021575927734
(506) DESCRIBE `sailingdates` 0.0016591548919678
(507) DESCRIBE `ports` 0.0019290447235107
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044608116149902
(509) DESCRIBE `ports` 0.0017738342285156
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041699409484863
(511) DESCRIBE `ports` 0.0016238689422607
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00042581558227539
(513) DESCRIBE `ports` 0.0021660327911377
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00044703483581543
(515) DESCRIBE `ports` 0.0020461082458496
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0004580020904541
(517) DESCRIBE `ports` 0.0016930103302002
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00038790702819824
(519) DESCRIBE `ports` 0.0017280578613281
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00051712989807129
(521) DESCRIBE `ports` 0.0026588439941406
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00036096572875977
(523) DESCRIBE `ports` 0.0014300346374512
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0003960132598877
(525) DESCRIBE `ports` 0.0018010139465332
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00032591819763184
(527) DESCRIBE `ports` 0.0016119480133057
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.0003352165222168
(529) DESCRIBE `ports` 0.0015170574188232
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00032997131347656
(531) DESCRIBE `ports` 0.0014040470123291
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00039100646972656
(533) DESCRIBE `ports` 0.0010321140289307
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00034403800964355
(535) DESCRIBE `ports` 0.0015919208526611
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00036001205444336
(537) DESCRIBE `ports` 0.0021319389343262
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00031900405883789
(539) DESCRIBE `avid_specials` 0.0012710094451904
(540) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67256 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0012459754943848
(541) DESCRIBE `cruiselines` 0.0019509792327881
(542) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00060606002807617
(543) DESCRIBE `orchid_image` 0.0015869140625
(544) DESCRIBE `cruiselines` 0.0025370121002197
(545) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00045895576477051
(546) DESCRIBE `cruisetypes` 0.0014710426330566
(547) DESCRIBE `destinations` 0.0021800994873047
(548) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '53', '37', '48', '12', '38')) ORDER BY FIND_IN_SET(id, '22,53,37,48,12,38') 0.001727819442749
(549) DESCRIBE `cruiselines` 0.0025820732116699
(550) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00071978569030762
(551) DESCRIBE `ships` 0.0034389495849609
(552) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00055217742919922
(553) DESCRIBE `cruiselines` 0.0027868747711182
(554) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00040316581726074
(555) DESCRIBE `ships` 0.0030090808868408
(556) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00060391426086426