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

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

Total elapsed time: 0.86171865463257

# Query Time
(1) connect 0.00071597099304199
(2) DESCRIBE `cruises` 0.0041210651397705
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67032, 66904, 59676, 60875, 47190, 56532, 52575, 52606, 66085, 67919)) ORDER BY FIND_IN_SET(id, '67032,66904,59676,60875,47190,56532,52575,52606,66085,67919') 0.0017750263214111
(4) DESCRIBE `specials` 0.0045719146728516
(5) DESCRIBE `specials` 0.0043811798095703
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1457650') 0.00040793418884277
(7) DESCRIBE `ships` 0.0034441947937012
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84))) 0.00060296058654785
(9) DESCRIBE `ships` 0.002985954284668
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '84') 0.00047898292541504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030088424682617
(13) DESCRIBE `itineraries` 0.0017759799957275
(14) DESCRIBE `ports` 0.0017709732055664
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00045418739318848
(16) DESCRIBE `ports` 0.001478910446167
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00030303001403809
(18) DESCRIBE `ports` 0.0013620853424072
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00028109550476074
(20) DESCRIBE `specialsailingdates` 0.0014090538024902
(21) DESCRIBE `sailingdates` 0.0012581348419189
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 420553))) 0.00044894218444824
(23) DESCRIBE `ports` 0.0015349388122559
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00036501884460449
(25) DESCRIBE `ports` 0.0012938976287842
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00034785270690918
(27) DESCRIBE `ports` 0.0014019012451172
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5201))) 0.00035405158996582
(29) DESCRIBE `ports` 0.0016629695892334
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5201') 0.00034403800964355
(31) DESCRIBE `ports` 0.0012879371643066
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00033807754516602
(33) DESCRIBE `ports` 0.0013210773468018
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00029802322387695
(35) DESCRIBE `ports` 0.0013289451599121
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00032401084899902
(37) DESCRIBE `ports` 0.001291036605835
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00026798248291016
(39) DESCRIBE `ports` 0.0013408660888672
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00032901763916016
(41) DESCRIBE `ports` 0.0012490749359131
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00027108192443848
(43) DESCRIBE `ports` 0.001331090927124
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00038814544677734
(45) DESCRIBE `ports` 0.0017910003662109
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.0003509521484375
(47) DESCRIBE `ports` 0.0016508102416992
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 31))) 0.00040411949157715
(49) DESCRIBE `ports` 0.0016410350799561
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '31') 0.00039887428283691
(51) DESCRIBE `ports` 0.0017290115356445
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1904))) 0.00050711631774902
(53) DESCRIBE `ports` 0.0017189979553223
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1904') 0.00037002563476562
(55) DESCRIBE `ports` 0.0014760494232178
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.0003809928894043
(57) DESCRIBE `ports` 0.0017631053924561
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00036096572875977
(59) DESCRIBE `ports` 0.0017490386962891
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00041794776916504
(61) DESCRIBE `ports` 0.00177001953125
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00036096572875977
(63) DESCRIBE `ports` 0.0018298625946045
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00040316581726074
(65) DESCRIBE `ports` 0.00130295753479
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00035190582275391
(67) DESCRIBE `ports` 0.0015761852264404
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00049710273742676
(69) DESCRIBE `ports` 0.0017180442810059
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00034999847412109
(71) DESCRIBE `ports` 0.0015029907226562
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00034093856811523
(73) DESCRIBE `ports` 0.0014510154724121
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00030183792114258
(75) DESCRIBE `cruises` 0.0024850368499756
(76) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67032))) 0.0007328987121582
(77) DESCRIBE `avid_specials` 0.0016732215881348
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1457650 and class = 'Special') OR (item_id = 67032 and class = 'Cruise') OR (item_id = 84 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 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.0018389225006104
(79) DESCRIBE `cruiselines` 0.0026328563690186
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00047492980957031
(81) DESCRIBE `orchid_image` 0.0022220611572266
(82) DESCRIBE `cruiselines` 0.0024030208587646
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00080013275146484
(84) DESCRIBE `specials` 0.005263090133667
(85) DESCRIBE `specials` 0.0046861171722412
(86) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1457674') 0.00041699409484863
(87) DESCRIBE `ships` 0.0037410259246826
(88) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00056791305541992
(89) DESCRIBE `ships` 0.0034899711608887
(90) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030899047851562
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029516220092773
(93) DESCRIBE `itineraries` 0.0015888214111328
(94) DESCRIBE `ports` 0.0023131370544434
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00048089027404785
(96) DESCRIBE `ports` 0.0025229454040527
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00039291381835938
(98) DESCRIBE `ports` 0.0013689994812012
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00029110908508301
(100) DESCRIBE `specialsailingdates` 0.0012969970703125
(101) DESCRIBE `sailingdates` 0.0015721321105957
(102) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419894))) 0.00039815902709961
(103) DESCRIBE `ports` 0.0016310214996338
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00034308433532715
(105) DESCRIBE `ports` 0.0013649463653564
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00028586387634277
(107) DESCRIBE `ports` 0.0016598701477051
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0004279613494873
(109) DESCRIBE `ports` 0.0017290115356445
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00036501884460449
(111) DESCRIBE `ports` 0.0016560554504395
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00032901763916016
(113) DESCRIBE `ports` 0.0013289451599121
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00038719177246094
(115) DESCRIBE `ports` 0.0014910697937012
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00042390823364258
(117) DESCRIBE `ports` 0.0013890266418457
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00034904479980469
(119) DESCRIBE `ports` 0.001762866973877
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00039291381835938
(121) DESCRIBE `ports` 0.0018219947814941
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.0003809928894043
(123) DESCRIBE `ports` 0.0030059814453125
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00046205520629883
(125) DESCRIBE `ports` 0.0019049644470215
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00074195861816406
(127) DESCRIBE `ports` 0.0018351078033447
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00042605400085449
(129) DESCRIBE `ports` 0.0018470287322998
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00066590309143066
(131) DESCRIBE `cruises` 0.0035340785980225
(132) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66904))) 0.00043892860412598
(133) DESCRIBE `avid_specials` 0.0017249584197998
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1457674 and class = 'Special') OR (item_id = 66904 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 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.001755952835083
(135) DESCRIBE `cruiselines` 0.0027549266815186
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00051116943359375
(137) DESCRIBE `orchid_image` 0.002108097076416
(138) DESCRIBE `cruiselines` 0.0027978420257568
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00046610832214355
(140) DESCRIBE `specials` 0.0056641101837158
(141) DESCRIBE `specials` 0.0057058334350586
(142) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1457698') 0.00053119659423828
(143) DESCRIBE `ships` 0.0037870407104492
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 74))) 0.00051093101501465
(145) DESCRIBE `ships` 0.0034668445587158
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '74') 0.00037503242492676
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033903121948242
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032687187194824
(149) DESCRIBE `itineraries` 0.0017569065093994
(150) DESCRIBE `ports` 0.0017740726470947
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00041508674621582
(152) DESCRIBE `ports` 0.0017998218536377
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00037884712219238
(154) DESCRIBE `ports` 0.0017380714416504
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00038599967956543
(156) DESCRIBE `specialsailingdates` 0.00142502784729
(157) DESCRIBE `sailingdates` 0.0016310214996338
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419875))) 0.0004279613494873
(159) DESCRIBE `ports` 0.0017170906066895
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00033688545227051
(161) DESCRIBE `ports` 0.001500129699707
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00051999092102051
(163) DESCRIBE `ports` 0.0019831657409668
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4153))) 0
(165) DESCRIBE `ports` 0.0016279220581055
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4153') 0.00045013427734375
(167) DESCRIBE `ports` 0.0016689300537109
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5200))) 0.00048089027404785
(169) DESCRIBE `ports` 0.0017080307006836
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5200') 0.0004420280456543
(171) DESCRIBE `ports` 0.0016119480133057
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00036907196044922
(173) DESCRIBE `ports` 0.0014338493347168
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00039887428283691
(175) DESCRIBE `ports` 0.0017569065093994
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00034999847412109
(177) DESCRIBE `ports` 0.0014090538024902
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00037503242492676
(179) DESCRIBE `ports` 0.0014081001281738
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00038599967956543
(181) DESCRIBE `ports` 0.0013220310211182
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.0003049373626709
(183) DESCRIBE `ports` 0.0013611316680908
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0003199577331543
(185) DESCRIBE `ports` 0.0014119148254395
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00028896331787109
(187) DESCRIBE `ports` 0.0014181137084961
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00033998489379883
(189) DESCRIBE `ports` 0.0013711452484131
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00032997131347656
(191) DESCRIBE `ports` 0.0013768672943115
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00036883354187012
(193) DESCRIBE `ports` 0.0016288757324219
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00031113624572754
(195) DESCRIBE `cruises` 0.0032529830932617
(196) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 59676))) 0.00053596496582031
(197) DESCRIBE `avid_specials` 0.001270055770874
(198) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1457698 and class = 'Special') OR (item_id = 59676 and class = 'Cruise') OR (item_id = 74 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 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.0010838508605957
(199) DESCRIBE `cruiselines` 0.0020301342010498
(200) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00060200691223145
(201) DESCRIBE `orchid_image` 0.0020420551300049
(202) DESCRIBE `cruiselines` 0.003277063369751
(203) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00060296058654785
(204) DESCRIBE `specials` 0.0050499439239502
(205) DESCRIBE `specials` 0.0050899982452393
(206) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1454236') 0.00065112113952637
(207) DESCRIBE `ships` 0.0043838024139404
(208) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 790))) 0.0012478828430176
(209) DESCRIBE `ships` 0.0029299259185791
(210) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '790') 0.000946044921875
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00073385238647461
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00014901161193848
(213) DESCRIBE `itineraries` 0.0019190311431885
(214) DESCRIBE `ports` 0.0021328926086426
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047707557678223
(216) DESCRIBE `ports` 0.0018980503082275
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00038790702819824
(218) DESCRIBE `ports` 0.0017778873443604
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00038290023803711
(220) DESCRIBE `specialsailingdates` 0.0014419555664062
(221) DESCRIBE `sailingdates` 0.0015349388122559
(222) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 433087))) 0.00045299530029297
(223) DESCRIBE `ports` 0.0019588470458984
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00044798851013184
(225) DESCRIBE `ports` 0.0019199848175049
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00041294097900391
(227) DESCRIBE `ports` 0.0018470287322998
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1480))) 0.00044512748718262
(229) DESCRIBE `ports` 0.0018908977508545
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1480') 2.5033950805664E-5
(231) DESCRIBE `ports` 0.0018010139465332
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00063681602478027
(233) DESCRIBE `ports` 0.0018370151519775
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00046491622924805
(235) DESCRIBE `ports` 0.0018398761749268
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00043606758117676
(237) DESCRIBE `ports` 0.0019199848175049
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00040698051452637
(239) DESCRIBE `ports` 0.0019369125366211
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.0012490749359131
(241) DESCRIBE `ports` 0.0019102096557617
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00064301490783691
(243) DESCRIBE `ports` 0.0023849010467529
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00060200691223145
(245) DESCRIBE `ports` 0.0020771026611328
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00052785873413086
(247) DESCRIBE `ports` 0.0029189586639404
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00052714347839355
(249) DESCRIBE `ports` 0.0021209716796875
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00046801567077637
(251) DESCRIBE `ports` 0.0017249584197998
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 34))) 0
(253) DESCRIBE `ports` 0.0017988681793213
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '34') 0
(255) DESCRIBE `ports` 0.0018959045410156
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 855))) 0.00044918060302734
(257) DESCRIBE `ports` 0.0019118785858154
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '855') 0.00034189224243164
(259) DESCRIBE `ports` 0.0017778873443604
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1262))) 0.00042390823364258
(261) DESCRIBE `ports` 0.0017929077148438
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1262') 0.0004429817199707
(263) DESCRIBE `ports` 0.0020110607147217
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5279))) 0.00059390068054199
(265) DESCRIBE `ports` 0.0019919872283936
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5279') 0.00045204162597656
(267) DESCRIBE `ports` 0.0018560886383057
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2534))) 0.00045394897460938
(269) DESCRIBE `ports` 0.0023009777069092
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2534') 0.00042891502380371
(271) DESCRIBE `ports` 0.0014431476593018
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00030303001403809
(273) DESCRIBE `ports` 0.0019040107727051
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00071001052856445
(275) DESCRIBE `cruises` 0.003777027130127
(276) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 60875))) 0.00076198577880859
(277) DESCRIBE `avid_specials` 0.0014050006866455
(278) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1454236 and class = 'Special') OR (item_id = 60875 and class = 'Cruise') OR (item_id = 790 AND class = 'Ship') OR (item_id = 28 AND class = 'CruiseLine') OR (item_id = 2 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.0017900466918945
(279) DESCRIBE `cruiselines` 0.0025200843811035
(280) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00010204315185547
(281) DESCRIBE `orchid_image` 0.0017380714416504
(282) DESCRIBE `specials` 0.0051929950714111
(283) DESCRIBE `specials` 0.0057189464569092
(284) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1454741') 0.00058984756469727
(285) DESCRIBE `ships` 0.0040810108184814
(286) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 333))) 0.00071310997009277
(287) DESCRIBE `ships` 0.0038690567016602
(288) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '333') 0.00052905082702637
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032496452331543
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(291) DESCRIBE `itineraries` 0.0018670558929443
(292) DESCRIBE `ports` 0.0019948482513428
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0011341571807861
(294) DESCRIBE `ports` 0.0019350051879883
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00038909912109375
(296) DESCRIBE `ports` 0.0017149448394775
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00035214424133301
(298) DESCRIBE `specialsailingdates` 0.0012338161468506
(299) DESCRIBE `sailingdates` 0.0013561248779297
(300) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423908))) 0.00037908554077148
(301) DESCRIBE `ports` 0.0016450881958008
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00040006637573242
(303) DESCRIBE `ports` 0.0016350746154785
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00039410591125488
(305) DESCRIBE `ports` 0.0016889572143555
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00039005279541016
(307) DESCRIBE `ports` 0.001751184463501
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00035595893859863
(309) DESCRIBE `ports` 0.0015630722045898
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00038385391235352
(311) DESCRIBE `ports` 0.0018949508666992
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.0003669261932373
(313) DESCRIBE `ports` 0.0017681121826172
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00041103363037109
(315) DESCRIBE `ports` 0.0018131732940674
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00037908554077148
(317) DESCRIBE `ports` 0.0016610622406006
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.0003209114074707
(319) DESCRIBE `ports` 0.001723051071167
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00037002563476562
(321) DESCRIBE `ports` 0.0015549659729004
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00035190582275391
(323) DESCRIBE `ports` 0.0016350746154785
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0003509521484375
(325) DESCRIBE `cruises` 0.0035049915313721
(326) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 47190))) 0.0005648136138916
(327) DESCRIBE `avid_specials` 0.0018839836120605
(328) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1454741 and class = 'Special') OR (item_id = 47190 and class = 'Cruise') OR (item_id = 333 AND class = 'Ship') OR (item_id = 218 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.0021870136260986
(329) DESCRIBE `cruiselines` 0.0027289390563965
(330) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00051999092102051
(331) DESCRIBE `orchid_image` 0.0024840831756592
(332) DESCRIBE `cruiselines` 0.0029220581054688
(333) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00045394897460938
(334) DESCRIBE `specials` 0.005640983581543
(335) DESCRIBE `specials` 0.0049560070037842
(336) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1454757') 0.00057888031005859
(337) DESCRIBE `ships` 0.003925085067749
(338) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 3))) 0.0009300708770752
(339) DESCRIBE `ships` 0.003849983215332
(340) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '3') 0.0005650520324707
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00076794624328613
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032901763916016
(343) DESCRIBE `itineraries` 0.0019328594207764
(344) DESCRIBE `ports` 0.0024318695068359
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0005340576171875
(346) DESCRIBE `ports` 0.0016770362854004
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00091981887817383
(348) DESCRIBE `ports` 0.001906156539917
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00042819976806641
(350) DESCRIBE `specialsailingdates` 0.0013260841369629
(351) DESCRIBE `sailingdates` 0.0012040138244629
(352) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 425696))) 0.00047683715820312
(353) DESCRIBE `ports` 0.0022859573364258
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00049090385437012
(355) DESCRIBE `ports` 0.0018630027770996
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00042414665222168
(357) DESCRIBE `ports` 0.0020508766174316
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00048303604125977
(359) DESCRIBE `ports` 0.0018649101257324
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00049400329589844
(361) DESCRIBE `ports` 0.0018467903137207
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00044393539428711
(363) DESCRIBE `ports` 0.0028059482574463
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00053811073303223
(365) DESCRIBE `ports` 0.0018739700317383
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00048685073852539
(367) DESCRIBE `ports` 0.001816987991333
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00040793418884277
(369) DESCRIBE `ports` 0.0018551349639893
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00052881240844727
(371) DESCRIBE `ports` 0.0019240379333496
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00064897537231445
(373) DESCRIBE `ports` 0.0019321441650391
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00084781646728516
(375) DESCRIBE `ports` 0.002697229385376
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00052595138549805
(377) DESCRIBE `cruises` 0.0034968852996826
(378) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 56532))) 0.00028610229492188
(379) DESCRIBE `avid_specials` 0.0018911361694336
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1454757 and class = 'Special') OR (item_id = 56532 and class = 'Cruise') OR (item_id = 3 AND class = 'Ship') OR (item_id = 218 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.0020871162414551
(381) DESCRIBE `cruiselines` 0.0028741359710693
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00060486793518066
(383) DESCRIBE `orchid_image` 0.0020251274108887
(384) DESCRIBE `cruiselines` 0.0030050277709961
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00066208839416504
(386) DESCRIBE `specials` 0.0054881572723389
(387) DESCRIBE `specials` 0.0055899620056152
(388) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1455188') 0.00052785873413086
(389) DESCRIBE `ships` 0.0036351680755615
(390) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 582))) 0.00072193145751953
(391) DESCRIBE `ships` 0.0035250186920166
(392) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '582') 0.00048685073852539
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031590461730957
(395) DESCRIBE `itineraries` 0.0017809867858887
(396) DESCRIBE `ports` 0.0018739700317383
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00054693222045898
(398) DESCRIBE `ports` 0.002108097076416
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00050902366638184
(400) DESCRIBE `ports` 0.0020987987518311
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0005490779876709
(402) DESCRIBE `specialsailingdates` 0.0018241405487061
(403) DESCRIBE `sailingdates` 0.0015230178833008
(404) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424863))) 0.00064897537231445
(405) DESCRIBE `ports` 0.0024240016937256
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00059819221496582
(407) DESCRIBE `ports` 0.0021488666534424
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00055599212646484
(409) DESCRIBE `ports` 0.0021979808807373
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00059795379638672
(411) DESCRIBE `ports` 0.0022659301757812
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00075387954711914
(413) DESCRIBE `ports` 0.0020029544830322
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00045919418334961
(415) DESCRIBE `ports` 0.0017900466918945
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0003819465637207
(417) DESCRIBE `ports` 0.0018310546875
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00042414665222168
(419) DESCRIBE `ports` 0.0017118453979492
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00013399124145508
(421) DESCRIBE `ports` 0.0016319751739502
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00041794776916504
(423) DESCRIBE `ports` 0.0013940334320068
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00029110908508301
(425) DESCRIBE `cruises` 0.0035901069641113
(426) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52575))) 0.00062918663024902
(427) DESCRIBE `avid_specials` 0.001723051071167
(428) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1455188 and class = 'Special') OR (item_id = 52575 and class = 'Cruise') OR (item_id = 582 AND class = 'Ship') OR (item_id = 218 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.0014851093292236
(429) DESCRIBE `cruiselines` 0.0022890567779541
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00044488906860352
(431) DESCRIBE `orchid_image` 0.0017690658569336
(432) DESCRIBE `cruiselines` 0.0023200511932373
(433) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00041294097900391
(434) DESCRIBE `specials` 0.0043699741363525
(435) DESCRIBE `specials` 0.0047540664672852
(436) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1454725') 0.0005180835723877
(437) DESCRIBE `ships` 0.0036671161651611
(438) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 390))) 0.00058913230895996
(439) DESCRIBE `ships` 0.0033509731292725
(440) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '390') 0.0004730224609375
(441) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031590461730957
(442) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034785270690918
(443) DESCRIBE `itineraries` 0.0016670227050781
(444) DESCRIBE `ports` 0.0018188953399658
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047087669372559
(446) DESCRIBE `ports` 0.0018951892852783
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044393539428711
(448) DESCRIBE `ports` 0.0016560554504395
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00036787986755371
(450) DESCRIBE `specialsailingdates` 0.0012681484222412
(451) DESCRIBE `sailingdates` 0.0013589859008789
(452) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 414457))) 0.00038814544677734
(453) DESCRIBE `ports` 0.0015990734100342
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044703483581543
(455) DESCRIBE `ports` 0.0019190311431885
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0010190010070801
(457) DESCRIBE `ports` 0.0021889209747314
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00049614906311035
(459) DESCRIBE `ports` 0.0022859573364258
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00041723251342773
(461) DESCRIBE `ports` 0.0020449161529541
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00067305564880371
(463) DESCRIBE `ports` 0.0024340152740479
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00055599212646484
(465) DESCRIBE `ports` 0.0021159648895264
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00071215629577637
(467) DESCRIBE `ports` 0.0021429061889648
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00058603286743164
(469) DESCRIBE `ports` 0.0020458698272705
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00073504447937012
(471) DESCRIBE `ports` 0.0020308494567871
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.0005040168762207
(473) DESCRIBE `ports` 0.0019819736480713
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00058698654174805
(475) DESCRIBE `ports` 0.0021390914916992
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00066494941711426
(477) DESCRIBE `cruises` 0.0035560131072998
(478) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52606))) 0.00066113471984863
(479) DESCRIBE `avid_specials` 0.0018980503082275
(480) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1454725 and class = 'Special') OR (item_id = 52606 and class = 'Cruise') OR (item_id = 390 AND class = 'Ship') OR (item_id = 218 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.0017051696777344
(481) DESCRIBE `cruiselines` 0.0029001235961914
(482) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00061702728271484
(483) DESCRIBE `orchid_image` 0.0023791790008545
(484) DESCRIBE `cruiselines` 0.0027627944946289
(485) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00040197372436523
(486) DESCRIBE `specials` 0.0056378841400146
(487) DESCRIBE `specials` 0.0060811042785645
(488) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1455899') 0.00065994262695312
(489) DESCRIBE `ships` 0.004086971282959
(490) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 732))) 0.00067305564880371
(491) DESCRIBE `ships` 0.004241943359375
(492) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '732') 0.00054693222045898
(493) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033187866210938
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(495) DESCRIBE `itineraries` 0.0018830299377441
(496) DESCRIBE `ports` 0.0018949508666992
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00048995018005371
(498) DESCRIBE `ports` 0.0016829967498779
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00052404403686523
(500) DESCRIBE `ports` 0.0017430782318115
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00042104721069336
(502) DESCRIBE `specialsailingdates` 0.0013530254364014
(503) DESCRIBE `sailingdates` 0.0014009475708008
(504) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 422466))) 0.00048494338989258
(505) DESCRIBE `ports` 0.0015900135040283
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00035285949707031
(507) DESCRIBE `ports` 0.0015771389007568
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00041294097900391
(509) DESCRIBE `ports` 0.0017740726470947
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00039911270141602
(511) DESCRIBE `ports` 0.0014090538024902
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00032901763916016
(513) DESCRIBE `ports` 0.0013830661773682
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00031900405883789
(515) DESCRIBE `ports` 0.0018761157989502
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00038504600524902
(517) DESCRIBE `ports` 0.0020542144775391
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00030708312988281
(519) DESCRIBE `ports` 0.0018949508666992
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 1.4066696166992E-5
(521) DESCRIBE `ports` 0.0021171569824219
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00085186958312988
(523) DESCRIBE `ports` 0.0019040107727051
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00053310394287109
(525) DESCRIBE `ports` 0.0015509128570557
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00058579444885254
(527) DESCRIBE `ports` 0.0016341209411621
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00054216384887695
(529) DESCRIBE `ports` 0.0016779899597168
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00047111511230469
(531) DESCRIBE `ports` 0.0016491413116455
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00039482116699219
(533) DESCRIBE `ports` 0.0013959407806396
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00043702125549316
(535) DESCRIBE `ports` 0.0015339851379395
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00045108795166016
(537) DESCRIBE `cruises` 0.002852201461792
(538) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66085))) 0.00062990188598633
(539) DESCRIBE `avid_specials` 0.0014369487762451
(540) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1455899 and class = 'Special') OR (item_id = 66085 and class = 'Cruise') OR (item_id = 732 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012130737304688
(541) DESCRIBE `cruiselines` 0.0022280216217041
(542) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00059103965759277
(543) DESCRIBE `orchid_image` 0.0021581649780273
(544) DESCRIBE `cruiselines` 0.0026719570159912
(545) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00076794624328613
(546) DESCRIBE `specials` 0.0045700073242188
(547) DESCRIBE `specials` 0.004831075668335
(548) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1454905') 0.0011119842529297
(549) DESCRIBE `ships` 0.0042798519134521
(550) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) 0.00087785720825195
(551) DESCRIBE `ships` 0.0039830207824707
(552) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') 0.00064182281494141
(553) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 3.3140182495117E-5
(554) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(555) DESCRIBE `itineraries` 0.0019550323486328
(556) DESCRIBE `ports` 0.0018711090087891
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00050592422485352
(558) DESCRIBE `ports` 0.0015189647674561
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00043988227844238
(560) DESCRIBE `ports` 0.0015871524810791
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00043201446533203
(562) DESCRIBE `specialsailingdates` 0.0016908645629883
(563) DESCRIBE `sailingdates` 0.0018730163574219
(564) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428538))) 0.00059819221496582
(565) DESCRIBE `ports` 0.0021390914916992
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00057697296142578
(567) DESCRIBE `ports` 0.002051830291748
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00048089027404785
(569) DESCRIBE `ports` 0.002007007598877
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00058507919311523
(571) DESCRIBE `ports` 0.0020971298217773
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00053191184997559
(573) DESCRIBE `ports` 0.0020830631256104
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00060606002807617
(575) DESCRIBE `ports` 0.0020198822021484
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00054192543029785
(577) DESCRIBE `ports` 0.0022091865539551
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00060701370239258
(579) DESCRIBE `ports` 0.0018501281738281
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00056695938110352
(581) DESCRIBE `ports` 0.002230167388916
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00064897537231445
(583) DESCRIBE `ports` 0.0022048950195312
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00050687789916992
(585) DESCRIBE `cruises` 0.0035848617553711
(586) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67919))) 0.00082802772521973
(587) DESCRIBE `avid_specials` 0.0019469261169434
(588) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1454905 and class = 'Special') OR (item_id = 67919 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.0021989345550537
(589) DESCRIBE `cruiselines` 0.0029840469360352
(590) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00062394142150879
(591) DESCRIBE `orchid_image` 0.0020389556884766
(592) DESCRIBE `cruiselines` 0.0029439926147461
(593) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 6.1988830566406E-5
(594) DESCRIBE `cruiselines` 0.0028789043426514
(595) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '101', '110', '18', '33', '212', '23', '191', '171', '114', '24', '29', '19', '26', '188', '91', '28', '37', '120', '8', '20', '151')) ORDER BY FIND_IN_SET(id, '218,101,110,18,33,212,23,191,171,114,24,29,19,26,188,91,28,37,120,8,20,151') 0.0021469593048096
(596) DESCRIBE `ships` 0.003882884979248
(597) SELECT `ships`.* FROM `ships` WHERE (id IN ('1471', '1138', '1237', '1139', '1163', '1292', '1745', '888', '1224', '547', '582', '669', '1223', '1594', '5', '75', '162', '823', '1032', '1205', '1266', '1303', '1359', '21', '22', '24', '27', '111', '441', '1330', '1607', '10', '25', '28', '81', '82', '108', '148', '163', '327', '333', '390', '406', '439', '461', '580', '1013', '1262', '1282', '1318', '1320', '1539', '1682', '3', '11', '74', '78', '84', '98', '335', '394', '404', '455', '520', '573', '616', '657', '732', '739', '768', '790', '792', '795', '796', '854', '966', '970', '1095', '1135', '1159', '1302', '1319', '1325', '1398', '1402', '1579', '1738')) ORDER BY FIND_IN_SET(id, '1471,1138,1237,1139,1163,1292,1745,888,1224,547,582,669,1223,1594,5,75,162,823,1032,1205,1266,1303,1359,21,22,24,27,111,441,1330,1607,10,25,28,81,82,108,148,163,327,333,390,406,439,461,580,1013,1262,1282,1318,1320,1539,1682,3,11,74,78,84,98,335,394,404,455,520,573,616,657,732,739,768,790,792,795,796,854,966,970,1095,1135,1159,1302,1319,1325,1398,1402,1579,1738') 0.010987997055054
(598) DESCRIBE `cruisetypes` 0.0018489360809326
(599) DESCRIBE `destinations` 0.0023701190948486
(600) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('37', '12', '50', '22', '43', '54', '35', '53', '39', '2', '48', '56', '9', '26', '29', '55', '8', '11', '40', '7', '25', '28')) ORDER BY FIND_IN_SET(id, '37,12,50,22,43,54,35,53,39,2,48,56,9,26,29,55,8,11,40,7,25,28') 0.0019130706787109