or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises
  6. Frequently Asked Questions

Sign up to our newsletter and become the first to know about our latest deals and promotions

Sign Up Now
Cruise Factor - Find Your Perfect Cruise
 
 
Book Now 0800 60 82 60
  • TIA

Copyright © 2010 Cruise Factor Limited
All rights reserved

PO Box 5081,
Mt Maunganui 3150

 

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

Total elapsed time: 0.80383014678955

# Query Time
(1) connect 0.0004270076751709
(2) DESCRIBE `cruises` 0.004213809967041
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68562, 63785, 62066, 74190, 73063, 62662, 66811, 74647, 68565, 71306)) ORDER BY FIND_IN_SET(id, '68562,63785,62066,74190,73063,62662,66811,74647,68565,71306') 0.0018229484558105
(4) DESCRIBE `specials` 0.0053489208221436
(5) DESCRIBE `specials` 0.00547194480896
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1480605') 0.00056600570678711
(7) DESCRIBE `ships` 0.0041201114654541
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00059700012207031
(9) DESCRIBE `ships` 0.0036649703979492
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00046801567077637
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034499168395996
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033092498779297
(13) DESCRIBE `itineraries` 0.0022101402282715
(14) DESCRIBE `ports` 0.0016560554504395
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00037002563476562
(16) DESCRIBE `ports` 0.0014350414276123
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00028300285339355
(18) DESCRIBE `ports` 0.0012819766998291
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00027680397033691
(20) DESCRIBE `specialsailingdates` 0.0011429786682129
(21) DESCRIBE `sailingdates` 0.0016369819641113
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431868))) 0.00055217742919922
(23) DESCRIBE `ports` 0.0020039081573486
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00034403800964355
(25) DESCRIBE `ports` 0.0013630390167236
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00034213066101074
(27) DESCRIBE `ports` 0.0015439987182617
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00035309791564941
(29) DESCRIBE `ports` 0.0014138221740723
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00031280517578125
(31) DESCRIBE `ports` 0.0012950897216797
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00038313865661621
(33) DESCRIBE `ports` 0.0018110275268555
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00032401084899902
(35) DESCRIBE `ports` 0.0022068023681641
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00025796890258789
(37) DESCRIBE `ports` 0.0017879009246826
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00041913986206055
(39) DESCRIBE `ports` 0.0018730163574219
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00056290626525879
(41) DESCRIBE `ports` 0.0017549991607666
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00033092498779297
(43) DESCRIBE `ports` 0.0017499923706055
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00040197372436523
(45) DESCRIBE `ports` 0.0018119812011719
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00041818618774414
(47) DESCRIBE `ports` 0.0016839504241943
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00041294097900391
(49) DESCRIBE `ports` 0.0010108947753906
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.0003049373626709
(51) DESCRIBE `ports` 0.0017452239990234
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00039982795715332
(53) DESCRIBE `ports` 0.002032995223999
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00040912628173828
(55) DESCRIBE `cruises` 0.0036871433258057
(56) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68562))) 0.0013561248779297
(57) DESCRIBE `avid_specials` 0.0015449523925781
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480605 and class = 'Special') OR (item_id = 68562 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0018050670623779
(59) DESCRIBE `cruiselines` 0.002791166305542
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00049901008605957
(61) DESCRIBE `orchid_image` 0.0022728443145752
(62) DESCRIBE `cruiselines` 0.0027978420257568
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00041413307189941
(64) DESCRIBE `specials` 0.00508713722229
(65) DESCRIBE `specials` 0.0052721500396729
(66) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1475648') 0.00049901008605957
(67) DESCRIBE `ships` 0.0037891864776611
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00017881393432617
(69) DESCRIBE `ships` 0.0039610862731934
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00051617622375488
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034284591674805
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031900405883789
(73) DESCRIBE `itineraries` 0.0018649101257324
(74) DESCRIBE `ports` 0.0020720958709717
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 1.3113021850586E-5
(76) DESCRIBE `ports` 0.0017659664154053
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0
(78) DESCRIBE `ports` 0.0015881061553955
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031900405883789
(80) DESCRIBE `specialsailingdates` 0.0018630027770996
(81) DESCRIBE `sailingdates` 0.0016450881958008
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 449648))) 0.00057315826416016
(83) DESCRIBE `ports` 0.0017740726470947
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0012531280517578
(85) DESCRIBE `ports` 0.002079963684082
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041103363037109
(87) DESCRIBE `ports` 0.0018661022186279
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00044798851013184
(89) DESCRIBE `ports` 0.0019369125366211
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00043511390686035
(91) DESCRIBE `ports` 0.0014700889587402
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00031709671020508
(93) DESCRIBE `ports` 0.0016300678253174
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00028204917907715
(95) DESCRIBE `ports` 0.001967191696167
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0003960132598877
(97) DESCRIBE `ports` 0.0014879703521729
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028300285339355
(99) DESCRIBE `ports` 0.0016100406646729
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00032615661621094
(101) DESCRIBE `ports` 0.0013000965118408
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 5.2928924560547E-5
(103) DESCRIBE `ports` 0.0014519691467285
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00038504600524902
(105) DESCRIBE `ports` 0.0013730525970459
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00029206275939941
(107) DESCRIBE `ports` 0.0013980865478516
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00033712387084961
(109) DESCRIBE `ports` 0.0013740062713623
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00032210350036621
(111) DESCRIBE `ports` 0.0012791156768799
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00035881996154785
(113) DESCRIBE `ports` 0.0013821125030518
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00037288665771484
(115) DESCRIBE `ports` 0.0013840198516846
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00032401084899902
(117) DESCRIBE `ports` 0.001410961151123
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00030303001403809
(119) DESCRIBE `ports` 0.0013000965118408
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038290023803711
(121) DESCRIBE `ports` 0.0013399124145508
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030016899108887
(123) DESCRIBE `ports` 0.0015318393707275
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035500526428223
(125) DESCRIBE `ports` 0.0014839172363281
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003349781036377
(127) DESCRIBE `cruises` 0.0028350353240967
(128) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63785))) 0.00051307678222656
(129) DESCRIBE `avid_specials` 0.0013980865478516
(130) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1475648 and class = 'Special') OR (item_id = 63785 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 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.0010330677032471
(131) DESCRIBE `cruiselines` 0.0019159317016602
(132) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0003809928894043
(133) DESCRIBE `orchid_image` 0.0015602111816406
(134) DESCRIBE `cruiselines` 0.0023739337921143
(135) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00047612190246582
(136) DESCRIBE `specials` 0.0038890838623047
(137) DESCRIBE `specials` 0.0043830871582031
(138) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1480537') 0.00046896934509277
(139) DESCRIBE `ships` 0.0033631324768066
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00044107437133789
(141) DESCRIBE `ships` 0.0030069351196289
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00035905838012695
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027608871459961
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028300285339355
(145) DESCRIBE `itineraries` 0.0014200210571289
(146) DESCRIBE `ports` 0.001737117767334
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00048613548278809
(148) DESCRIBE `ports` 0.0013329982757568
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00043201446533203
(150) DESCRIBE `ports` 0.0012879371643066
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027203559875488
(152) DESCRIBE `specialsailingdates` 0.0010480880737305
(153) DESCRIBE `sailingdates` 0.0012590885162354
(154) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431869))) 0.0003509521484375
(155) DESCRIBE `sailingdates` 0.0012719631195068
(156) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431870))) 0.00049185752868652
(157) DESCRIBE `ports` 0.0015110969543457
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034904479980469
(159) DESCRIBE `ports` 0.0014519691467285
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00033211708068848
(161) DESCRIBE `ports` 0.0015759468078613
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00040483474731445
(163) DESCRIBE `ports` 0.0014748573303223
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00030207633972168
(165) DESCRIBE `ports` 0.0013589859008789
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030398368835449
(167) DESCRIBE `ports` 0.00070095062255859
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00031709671020508
(169) DESCRIBE `ports` 0.0016250610351562
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00032687187194824
(171) DESCRIBE `ports` 0.0015909671783447
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00031208992004395
(173) DESCRIBE `ports` 0.0013880729675293
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00032520294189453
(175) DESCRIBE `ports` 0.001392126083374
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00031900405883789
(177) DESCRIBE `ports` 0.0013880729675293
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00034594535827637
(179) DESCRIBE `ports` 0.0017271041870117
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00030803680419922
(181) DESCRIBE `ports` 0.0017910003662109
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00034689903259277
(183) DESCRIBE `ports` 0.0013740062713623
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00034594535827637
(185) DESCRIBE `ports` 0.0014009475708008
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00033283233642578
(187) DESCRIBE `ports` 0.0013318061828613
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00095391273498535
(189) DESCRIBE `ports` 0.0010020732879639
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031113624572754
(191) DESCRIBE `ports` 0.0013689994812012
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0003960132598877
(193) DESCRIBE `ports` 0.0016529560089111
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040316581726074
(195) DESCRIBE `ports` 0.0018868446350098
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00038599967956543
(197) DESCRIBE `cruises` 0.0035181045532227
(198) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62066))) 0.00054788589477539
(199) DESCRIBE `avid_specials` 0.0017540454864502
(200) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480537 and class = 'Special') OR (item_id = 62066 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0015368461608887
(201) DESCRIBE `cruiselines` 0.0020408630371094
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00025105476379395
(203) DESCRIBE `orchid_image` 0.0014159679412842
(204) DESCRIBE `cruiselines` 0.0017569065093994
(205) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.0002129077911377
(206) DESCRIBE `specials` 0.0037820339202881
(207) DESCRIBE `specials` 0.0039620399475098
(208) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1471453') 0.00043702125549316
(209) DESCRIBE `ships` 0.0026040077209473
(210) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00037908554077148
(211) DESCRIBE `ships` 0.0026969909667969
(212) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00030112266540527
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026392936706543
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027298927307129
(215) DESCRIBE `itineraries` 0.0013351440429688
(216) DESCRIBE `ports` 0.0015168190002441
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003969669342041
(218) DESCRIBE `ports` 0.0013201236724854
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003209114074707
(220) DESCRIBE `ports` 0.0014331340789795
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037193298339844
(222) DESCRIBE `specialsailingdates` 0.0011999607086182
(223) DESCRIBE `sailingdates` 0.0016400814056396
(224) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 466390))) 0.00057697296142578
(225) DESCRIBE `ports` 0.0014550685882568
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(227) DESCRIBE `ports` 0.0015368461608887
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030708312988281
(229) DESCRIBE `ports` 0.0012509822845459
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 4.1961669921875E-5
(231) DESCRIBE `ports` 0.0011520385742188
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00029778480529785
(233) DESCRIBE `ports` 0.0018219947814941
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00023221969604492
(235) DESCRIBE `ports` 0.001317024230957
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00029921531677246
(237) DESCRIBE `ports` 0.0012590885162354
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0
(239) DESCRIBE `ports` 0.001227855682373
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00028204917907715
(241) DESCRIBE `ports` 0.0012719631195068
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00030899047851562
(243) DESCRIBE `ports` 0.0015690326690674
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00028705596923828
(245) DESCRIBE `ports` 0.0015192031860352
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00032496452331543
(247) DESCRIBE `ports` 0.0017697811126709
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00030422210693359
(249) DESCRIBE `ports` 0.0012619495391846
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00084495544433594
(251) DESCRIBE `ports` 0.0012929439544678
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00039315223693848
(253) DESCRIBE `ports` 0.0016200542449951
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3395))) 0.0004580020904541
(255) DESCRIBE `ports` 0.0019969940185547
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3395') 0.00047707557678223
(257) DESCRIBE `ports` 0.0026319026947021
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038719177246094
(259) DESCRIBE `ports` 0.0013399124145508
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029897689819336
(261) DESCRIBE `ports` 0.0013191699981689
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033402442932129
(263) DESCRIBE `ports` 0.0013649463653564
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039196014404297
(265) DESCRIBE `ports` 0.0014607906341553
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00032711029052734
(267) DESCRIBE `ports` 0.0016219615936279
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00033307075500488
(269) DESCRIBE `ports` 0.0017859935760498
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 9.7990036010742E-5
(271) DESCRIBE `ports` 0.0018119812011719
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.0003058910369873
(273) DESCRIBE `ports` 0.0003819465637207
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031495094299316
(275) DESCRIBE `ports` 0.0015270709991455
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0
(277) DESCRIBE `cruises` 0.003000020980835
(278) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74190))) 0.00036978721618652
(279) DESCRIBE `avid_specials` 0.0016841888427734
(280) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1471453 and class = 'Special') OR (item_id = 74190 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 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.0016169548034668
(281) DESCRIBE `cruiselines` 0.0024640560150146
(282) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0004429817199707
(283) DESCRIBE `orchid_image` 0.0018711090087891
(284) DESCRIBE `cruiselines` 0.002514123916626
(285) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00041794776916504
(286) DESCRIBE `specials` 0.0043480396270752
(287) DESCRIBE `specials` 0.0049622058868408
(288) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1480922') 0.00051093101501465
(289) DESCRIBE `ships` 0.004878044128418
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00051283836364746
(291) DESCRIBE `ships` 0.0034921169281006
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00011587142944336
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046801567077637
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034117698669434
(295) DESCRIBE `itineraries` 0.001924991607666
(296) DESCRIBE `ports` 0.00193190574646
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0004270076751709
(298) DESCRIBE `ports` 0.0018479824066162
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00043082237243652
(300) DESCRIBE `ports` 0.0014748573303223
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034308433532715
(302) DESCRIBE `specialsailingdates` 0.0015161037445068
(303) DESCRIBE `sailingdates` 0.0016169548034668
(304) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 460363))) 0.00054502487182617
(305) DESCRIBE `ports` 0.0013790130615234
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00042486190795898
(307) DESCRIBE `ports` 0.0016710758209229
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034785270690918
(309) DESCRIBE `ports` 0.0016000270843506
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00038695335388184
(311) DESCRIBE `ports` 0.0017759799957275
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00034213066101074
(313) DESCRIBE `ports` 0.0016379356384277
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00040793418884277
(315) DESCRIBE `ports` 0.0016360282897949
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00033903121948242
(317) DESCRIBE `ports` 0.0016531944274902
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00031709671020508
(319) DESCRIBE `ports` 0.001323938369751
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00030517578125
(321) DESCRIBE `ports` 0.0012538433074951
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030612945556641
(323) DESCRIBE `ports` 0.001352071762085
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0003199577331543
(325) DESCRIBE `cruises` 0.0027117729187012
(326) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 73063))) 0.00050091743469238
(327) DESCRIBE `avid_specials` 0.0017158985137939
(328) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480922 and class = 'Special') OR (item_id = 73063 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 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.0015938282012939
(329) DESCRIBE `cruiselines` 0.0025548934936523
(330) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00050711631774902
(331) DESCRIBE `orchid_image` 0.0018990039825439
(332) DESCRIBE `cruiselines` 0.0019261837005615
(333) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00031590461730957
(334) DESCRIBE `specials` 0.0035429000854492
(335) DESCRIBE `specials` 0.0036990642547607
(336) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1467751') 0.00039291381835938
(337) DESCRIBE `ships` 0.0027971267700195
(338) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00042486190795898
(339) DESCRIBE `ships` 0.0027589797973633
(340) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00036096572875977
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002748966217041
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(343) DESCRIBE `itineraries` 0.0012481212615967
(344) DESCRIBE `ports` 0.0012679100036621
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042009353637695
(346) DESCRIBE `ports` 0.0018010139465332
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00050806999206543
(348) DESCRIBE `ports` 0.0018470287322998
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037193298339844
(350) DESCRIBE `specialsailingdates` 0.0013871192932129
(351) DESCRIBE `sailingdates` 0.0014579296112061
(352) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424598))) 0.0005190372467041
(353) DESCRIBE `ports` 0.0017769336700439
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039792060852051
(355) DESCRIBE `ports` 0.0016992092132568
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00038504600524902
(357) DESCRIBE `ports` 0.0017750263214111
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00048494338989258
(359) DESCRIBE `ports` 0.0016129016876221
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00037097930908203
(361) DESCRIBE `ports` 0.001331090927124
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00032305717468262
(363) DESCRIBE `ports` 0.0013630390167236
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00028109550476074
(365) DESCRIBE `ports` 0.0012719631195068
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030207633972168
(367) DESCRIBE `ports` 0.0012741088867188
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028395652770996
(369) DESCRIBE `ports` 0.0013067722320557
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031614303588867
(371) DESCRIBE `ports` 0.0018110275268555
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00016498565673828
(373) DESCRIBE `ports` 0.001248836517334
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00089621543884277
(375) DESCRIBE `ports` 0.0010199546813965
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029516220092773
(377) DESCRIBE `ports` 0.0020580291748047
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 9.5129013061523E-5
(379) DESCRIBE `ports` 0.0012719631195068
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027894973754883
(381) DESCRIBE `cruises` 0.0025758743286133
(382) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62662))) 0.0004119873046875
(383) DESCRIBE `avid_specials` 0.00049114227294922
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1467751 and class = 'Special') OR (item_id = 62662 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010271072387695
(385) DESCRIBE `cruiselines` 0.0019409656524658
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038695335388184
(387) DESCRIBE `orchid_image` 0.0015449523925781
(388) DESCRIBE `cruiselines` 0.0019140243530273
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00034093856811523
(390) DESCRIBE `specials` 0.0039448738098145
(391) DESCRIBE `specials` 0.004802942276001
(392) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1481852') 0.00040698051452637
(393) DESCRIBE `ships` 0.003148078918457
(394) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.0004420280456543
(395) DESCRIBE `ships` 0.0026941299438477
(396) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.00029706954956055
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034689903259277
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(399) DESCRIBE `itineraries` 0.0013751983642578
(400) DESCRIBE `ports` 0.0014247894287109
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003359317779541
(402) DESCRIBE `ports` 0.0013399124145508
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030016899108887
(404) DESCRIBE `ports` 0.0013151168823242
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029397010803223
(406) DESCRIBE `specialsailingdates` 0.0011501312255859
(407) DESCRIBE `sailingdates` 0.0023159980773926
(408) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419446))) 0.0004889965057373
(409) DESCRIBE `ports` 0.0014469623565674
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00044989585876465
(411) DESCRIBE `ports` 0.0014848709106445
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00035691261291504
(413) DESCRIBE `ports` 0.0014739036560059
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00032591819763184
(415) DESCRIBE `ports` 0.0014979839324951
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00028896331787109
(417) DESCRIBE `ports` 0.0014491081237793
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00032901763916016
(419) DESCRIBE `ports` 0.0014300346374512
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028204917907715
(421) DESCRIBE `ports` 0.0012590885162354
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00030398368835449
(423) DESCRIBE `ports` 0.0013139247894287
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0002748966217041
(425) DESCRIBE `ports` 0.0012519359588623
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00030183792114258
(427) DESCRIBE `ports` 0.0012550354003906
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0002751350402832
(429) DESCRIBE `ports` 0.0015218257904053
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0003199577331543
(431) DESCRIBE `ports` 0.0013220310211182
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0003659725189209
(433) DESCRIBE `ports` 0.0018210411071777
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00040292739868164
(435) DESCRIBE `ports` 0.0017180442810059
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00036406517028809
(437) DESCRIBE `ports` 0.00071907043457031
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00033783912658691
(439) DESCRIBE `ports` 0.0014650821685791
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00030112266540527
(441) DESCRIBE `ports` 0.0012750625610352
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0003821849822998
(443) DESCRIBE `ports` 0.0012719631195068
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00029206275939941
(445) DESCRIBE `ports` 0.0012669563293457
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033283233642578
(447) DESCRIBE `ports` 0.0015501976013184
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038003921508789
(449) DESCRIBE `cruises` 0.0030431747436523
(450) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66811))) 0
(451) DESCRIBE `avid_specials` 0.0015699863433838
(452) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1481852 and class = 'Special') OR (item_id = 66811 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.0011091232299805
(453) DESCRIBE `cruiselines` 0.0023140907287598
(454) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00049400329589844
(455) DESCRIBE `orchid_image` 0.0019800662994385
(456) DESCRIBE `cruiselines` 0.0019400119781494
(457) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00038480758666992
(458) DESCRIBE `specials` 0.0037260055541992
(459) DESCRIBE `specials` 0.0057289600372314
(460) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1476709') 0.00053095817565918
(461) DESCRIBE `ships` 0.0030949115753174
(462) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.0013048648834229
(463) DESCRIBE `ships` 0.0023190975189209
(464) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.00032901763916016
(465) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026702880859375
(466) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025415420532227
(467) DESCRIBE `itineraries` 0.0012660026550293
(468) DESCRIBE `ports` 0.0014059543609619
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00035786628723145
(470) DESCRIBE `ports` 0.0017490386962891
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00032281875610352
(472) DESCRIBE `ports` 0.0013759136199951
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00031590461730957
(474) DESCRIBE `specialsailingdates` 0.0010778903961182
(475) DESCRIBE `sailingdates` 0.0017540454864502
(476) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471477))) 0.00061202049255371
(477) DESCRIBE `ports` 0.0014450550079346
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00035595893859863
(479) DESCRIBE `ports` 0.0018031597137451
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00038003921508789
(481) DESCRIBE `ports` 0.0013890266418457
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00034308433532715
(483) DESCRIBE `ports` 0.0018718242645264
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00030207633972168
(485) DESCRIBE `ports` 0.0013749599456787
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00025415420532227
(487) DESCRIBE `ports` 0.0016860961914062
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00035595893859863
(489) DESCRIBE `ports` 0.0012650489807129
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.0003058910369873
(491) DESCRIBE `ports` 0.0012829303741455
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00036406517028809
(493) DESCRIBE `ports` 0.0012991428375244
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00035309791564941
(495) DESCRIBE `ports` 0.0014908313751221
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00029802322387695
(497) DESCRIBE `ports` 0.0014188289642334
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2752))) 0.00037884712219238
(499) DESCRIBE `ports` 0.0014560222625732
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2752') 0.00032806396484375
(501) DESCRIBE `ports` 0.0016191005706787
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00037002563476562
(503) DESCRIBE `ports` 0.0016460418701172
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00037097930908203
(505) DESCRIBE `cruises` 0.0029768943786621
(506) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74647))) 0.00044584274291992
(507) DESCRIBE `avid_specials` 0.0011842250823975
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1476709 and class = 'Special') OR (item_id = 74647 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 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.0010747909545898
(509) DESCRIBE `cruiselines` 0.001971960067749
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00042200088500977
(511) DESCRIBE `orchid_image` 0.0017499923706055
(512) DESCRIBE `cruiselines` 0.0020089149475098
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.0003352165222168
(514) DESCRIBE `specials` 0.003572940826416
(515) DESCRIBE `specials` 0.0036110877990723
(516) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1480622') 0.00041317939758301
(517) DESCRIBE `ships` 0.0025780200958252
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00040102005004883
(519) DESCRIBE `ships` 0.0024869441986084
(520) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00036096572875977
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033283233642578
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025796890258789
(523) DESCRIBE `itineraries` 0.0013840198516846
(524) DESCRIBE `ports` 0.0049910545349121
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00049901008605957
(526) DESCRIBE `ports` 0.0019268989562988
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00037908554077148
(528) DESCRIBE `ports` 0.0015320777893066
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00033116340637207
(530) DESCRIBE `specialsailingdates` 0.0012588500976562
(531) DESCRIBE `sailingdates` 0.0018439292907715
(532) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431878))) 0.00042915344238281
(533) DESCRIBE `ports` 0.0018379688262939
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00039815902709961
(535) DESCRIBE `ports` 0.0017969608306885
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00037598609924316
(537) DESCRIBE `ports` 0.0019359588623047
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00046801567077637
(539) DESCRIBE `ports` 0.0018830299377441
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00040006637573242
(541) DESCRIBE `ports` 0.0019290447235107
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00047183036804199
(543) DESCRIBE `ports` 0.0018529891967773
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0003809928894043
(545) DESCRIBE `ports` 0.0020639896392822
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00042915344238281
(547) DESCRIBE `ports` 0.0018961429595947
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.0003960132598877
(549) DESCRIBE `ports` 0.0018739700317383
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00046610832214355
(551) DESCRIBE `ports` 0.0019440650939941
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00042510032653809
(553) DESCRIBE `ports` 0.0022239685058594
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.0004270076751709
(555) DESCRIBE `ports` 0.001823902130127
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00038504600524902
(557) DESCRIBE `ports` 0.0017769336700439
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00041699409484863
(559) DESCRIBE `ports` 0.001798152923584
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00037908554077148
(561) DESCRIBE `ports` 0.0018270015716553
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00042486190795898
(563) DESCRIBE `ports` 0.0018091201782227
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00038003921508789
(565) DESCRIBE `ports` 0.0017399787902832
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00040197372436523
(567) DESCRIBE `ports` 0.00177001953125
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00041794776916504
(569) DESCRIBE `ports` 0.0017879009246826
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00041294097900391
(571) DESCRIBE `ports` 0.0018258094787598
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0003819465637207
(573) DESCRIBE `ports` 0.0018417835235596
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00040388107299805
(575) DESCRIBE `ports` 0.0018730163574219
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00036501884460449
(577) DESCRIBE `cruises` 0.0036840438842773
(578) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68565))) 0.00057601928710938
(579) DESCRIBE `avid_specials` 0.0014629364013672
(580) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480622 and class = 'Special') OR (item_id = 68565 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0020182132720947
(581) DESCRIBE `cruiselines` 0.0047202110290527
(582) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00057411193847656
(583) DESCRIBE `orchid_image` 0.0023558139801025
(584) DESCRIBE `cruiselines` 0.0028359889984131
(585) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00057005882263184
(586) DESCRIBE `specials` 0.0049660205841064
(587) DESCRIBE `specials` 0.0044870376586914
(588) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1474027') 0.00041890144348145
(589) DESCRIBE `ships` 0.0038728713989258
(590) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1393))) 0.00066089630126953
(591) DESCRIBE `ships` 0.0032169818878174
(592) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1393') 0.0005030632019043
(593) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032806396484375
(594) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032997131347656
(595) DESCRIBE `itineraries` 0.0023539066314697
(596) DESCRIBE `ports` 0.0014259815216064
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0
(598) DESCRIBE `ports` 0.0019419193267822
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00038599967956543
(600) DESCRIBE `ports` 0.0016999244689941
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00084996223449707
(602) DESCRIBE `specialsailingdates` 0.0013008117675781
(603) DESCRIBE `sailingdates` 0.0021910667419434
(604) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453019))) 0.0011780261993408
(605) DESCRIBE `ports` 0.0017158985137939
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00043106079101562
(607) DESCRIBE `ports` 0.0011520385742188
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00042605400085449
(609) DESCRIBE `ports` 0.0018758773803711
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00047588348388672
(611) DESCRIBE `ports` 0.0018801689147949
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00040698051452637
(613) DESCRIBE `ports` 0.0023360252380371
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00040388107299805
(615) DESCRIBE `ports` 0.0016868114471436
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0
(617) DESCRIBE `ports` 0.0016210079193115
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.0013191699981689
(619) DESCRIBE `ports` 0.00068092346191406
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00028800964355469
(621) DESCRIBE `ports` 0.001384973526001
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00037407875061035
(623) DESCRIBE `ports` 0.0014808177947998
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00028300285339355
(625) DESCRIBE `ports` 0.0013320446014404
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00034403800964355
(627) DESCRIBE `ports` 0.0014510154724121
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00030016899108887
(629) DESCRIBE `ports` 0.0016241073608398
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00036787986755371
(631) DESCRIBE `ports` 0.0021650791168213
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00032997131347656
(633) DESCRIBE `ports` 0.0016748905181885
(634) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0003352165222168
(635) DESCRIBE `ports` 0.0012588500976562
(636) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00027918815612793
(637) DESCRIBE `ports` 0.001331090927124
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00030803680419922
(639) DESCRIBE `ports` 0.0012729167938232
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00028800964355469
(641) DESCRIBE `ports` 0.0012938976287842
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00030398368835449
(643) DESCRIBE `ports` 0.0012819766998291
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00027704238891602
(645) DESCRIBE `ports` 0.0013740062713623
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00041794776916504
(647) DESCRIBE `ports` 0.0013940334320068
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00028300285339355
(649) DESCRIBE `cruises` 0.0025010108947754
(650) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71306))) 0.00053191184997559
(651) DESCRIBE `avid_specials` 0.0012309551239014
(652) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1474027 and class = 'Special') OR (item_id = 71306 and class = 'Cruise') OR (item_id = 1393 AND class = 'Ship') OR (item_id = 140 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.0011990070343018
(653) DESCRIBE `cruiselines` 0.0019550323486328
(654) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00037193298339844
(655) DESCRIBE `orchid_image` 0.0020380020141602
(656) DESCRIBE `cruiselines` 0.0017950534820557
(657) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00031399726867676
(658) DESCRIBE `cruiselines` 0.0020570755004883
(659) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('101', '140', '110', '23', '114', '18', '33', '8', '171', '19', '24', '29', '188', '212', '20', '91', '218', '14', '37', '191')) ORDER BY FIND_IN_SET(id, '101,140,110,23,114,18,33,8,171,19,24,29,188,212,20,91,218,14,37,191') 0.0014538764953613
(660) DESCRIBE `ships` 0.0037188529968262
(661) SELECT `ships`.* FROM `ships` WHERE (id IN ('1471', '1139', '1237', '1292', '683', '888', '933', '1224', '1631', '1262', '1393', '1491', '1594', '162', '547', '741', '823', '1073', '1266', '1359', '1409', '1739', '108', '580', '796', '835', '1223', '1328', '1539', '1607', '66', '82', '406', '678', '795', '1013', '1029', '1163', '1189', '1318', '1569', '75', '78', '81', '98', '111', '148', '291', '348', '394', '434', '455', '542', '573', '582', '626', '657', '669', '966', '973', '1095', '1135', '1159', '1205', '1282', '1302', '1303', '1319', '1402')) ORDER BY FIND_IN_SET(id, '1471,1139,1237,1292,683,888,933,1224,1631,1262,1393,1491,1594,162,547,741,823,1073,1266,1359,1409,1739,108,580,796,835,1223,1328,1539,1607,66,82,406,678,795,1013,1029,1163,1189,1318,1569,75,78,81,98,111,148,291,348,394,434,455,542,573,582,626,657,669,966,973,1095,1135,1159,1205,1282,1302,1303,1319,1402') 0.0056509971618652
(662) DESCRIBE `cruisetypes` 0.00140380859375
(663) DESCRIBE `destinations` 0.0017781257629395
(664) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '37', '22', '43', '54', '7', '35', '2', '8', '53', '26', '39', '48', '40', '12', '11', '25', '28', '34', '38')) ORDER BY FIND_IN_SET(id, '50,37,22,43,54,7,35,2,8,53,26,39,48,40,12,11,25,28,34,38') 0.0013179779052734