or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World
  6. Frequently Asked Questions

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

Sign Up Now
Highlights of Eastern Europe - Savings - Cruise Deal » Uniworld Boutique River Cruises - Itineraries » Cruise Factor - Find Your Perfect Cruise » Croatia & Greece - Fly Free to Europe - Cruise Deal » 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: 620

Total elapsed time: 0.96536946296692

# Query Time
(1) connect 0.0019259452819824
(2) DESCRIBE `cruises` 0.0042691230773926
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65919, 65921, 65920, 71154, 80327, 75752, 75753, 75747, 75749, 41693)) ORDER BY FIND_IN_SET(id, '65919,65921,65920,71154,80327,75752,75753,75747,75749,41693') 0.0022869110107422
(4) DESCRIBE `cruises` 0.0055828094482422
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 0.00055789947509766
(6) DESCRIBE `ships` 0.005424976348877
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00066494941711426
(8) DESCRIBE `ships` 0.0039839744567871
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00044107437133789
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036883354187012
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041413307189941
(12) DESCRIBE `itineraries` 0.0018930435180664
(13) DESCRIBE `ports` 0.0018458366394043
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00051593780517578
(15) DESCRIBE `ports` 0.002295970916748
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00042009353637695
(17) DESCRIBE `ports` 0.0018339157104492
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0005180835723877
(19) DESCRIBE `sailingdates` 0.0016131401062012
(20) DESCRIBE `ports` 0.0024740695953369
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00044798851013184
(22) DESCRIBE `ports` 0.0020031929016113
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00043487548828125
(24) DESCRIBE `ports` 0.0019822120666504
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00062990188598633
(26) DESCRIBE `ports` 0.0024490356445312
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00038003921508789
(28) DESCRIBE `ports` 0.0020449161529541
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043988227844238
(30) DESCRIBE `ports` 0.0019497871398926
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00037693977355957
(32) DESCRIBE `avid_specials` 0.0017588138580322
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65919 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 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.0012650489807129
(34) DESCRIBE `cruiselines` 0.0026941299438477
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00047898292541504
(36) DESCRIBE `orchid_image` 0.0027620792388916
(37) DESCRIBE `cruiselines` 0.0027937889099121
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.0004270076751709
(39) DESCRIBE `cruises` 0.0047252178192139
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921') 0.00055193901062012
(41) DESCRIBE `ships` 0.0051670074462891
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00083494186401367
(43) DESCRIBE `ships` 0.0052242279052734
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00060510635375977
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039196014404297
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034403800964355
(47) DESCRIBE `itineraries` 0.0020031929016113
(48) DESCRIBE `ports` 0.0021247863769531
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043892860412598
(50) DESCRIBE `ports` 0.0019781589508057
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00042414665222168
(52) DESCRIBE `ports` 0.0020010471343994
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039505958557129
(54) DESCRIBE `sailingdates` 0.0016160011291504
(55) DESCRIBE `ports` 0.0022859573364258
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049901008605957
(57) DESCRIBE `ports` 0.0018069744110107
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00043010711669922
(59) DESCRIBE `ports` 0.0018529891967773
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043606758117676
(61) DESCRIBE `ports` 0.0020790100097656
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0003969669342041
(63) DESCRIBE `ports` 0.0018560886383057
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00063395500183105
(65) DESCRIBE `ports` 0.0018091201782227
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00050902366638184
(67) DESCRIBE `avid_specials` 0.0015578269958496
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65921 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 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.0011730194091797
(69) DESCRIBE `cruiselines` 0.0029199123382568
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00046420097351074
(71) DESCRIBE `orchid_image` 0.0020458698272705
(72) DESCRIBE `cruiselines` 0.0026800632476807
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00060510635375977
(74) DESCRIBE `cruises` 0.0042939186096191
(75) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65920') 0.00053095817565918
(76) DESCRIBE `ships` 0.0037169456481934
(77) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00054097175598145
(78) DESCRIBE `ships` 0.0036230087280273
(79) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00053310394287109
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036001205444336
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040006637573242
(82) DESCRIBE `itineraries` 0.0018589496612549
(83) DESCRIBE `ports` 0.0020508766174316
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00046896934509277
(85) DESCRIBE `ports` 0.0019819736480713
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00053000450134277
(87) DESCRIBE `ports` 0.0022649765014648
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00041007995605469
(89) DESCRIBE `sailingdates` 0.0017409324645996
(90) DESCRIBE `ports` 0.0026760101318359
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00066113471984863
(92) DESCRIBE `ports` 0.0028009414672852
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0005950927734375
(94) DESCRIBE `ports` 0.0023849010467529
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00062894821166992
(96) DESCRIBE `ports` 0.0028278827667236
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00063395500183105
(98) DESCRIBE `avid_specials` 0.0024559497833252
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65920 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 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.0022530555725098
(100) DESCRIBE `cruiselines` 0.0040731430053711
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00070095062255859
(102) DESCRIBE `orchid_image` 0.0022239685058594
(103) DESCRIBE `cruiselines` 0.0028700828552246
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00057697296142578
(105) DESCRIBE `cruises` 0.0042519569396973
(106) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154') 0.00059700012207031
(107) DESCRIBE `ships` 0.0038869380950928
(108) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00070405006408691
(109) DESCRIBE `ships` 0.0045380592346191
(110) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00049781799316406
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035786628723145
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035285949707031
(113) DESCRIBE `itineraries` 0.0021719932556152
(114) DESCRIBE `ports` 0.0022280216217041
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049304962158203
(116) DESCRIBE `ports` 0.0020558834075928
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047206878662109
(118) DESCRIBE `ports` 0.0020520687103271
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00048184394836426
(120) DESCRIBE `sailingdates` 0.0016400814056396
(121) DESCRIBE `ports` 0.0021378993988037
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00088191032409668
(123) DESCRIBE `ports` 0.0020160675048828
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040602684020996
(125) DESCRIBE `ports` 0.0019822120666504
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0004420280456543
(127) DESCRIBE `ports` 0.0022280216217041
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0004730224609375
(129) DESCRIBE `avid_specials` 0.0018000602722168
(130) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71154 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 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.0013399124145508
(131) DESCRIBE `cruiselines` 0.0028231143951416
(132) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00060105323791504
(133) DESCRIBE `orchid_image` 0.002277135848999
(134) DESCRIBE `cruiselines` 0.0031509399414062
(135) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00042510032653809
(136) DESCRIBE `cruises` 0.0047800540924072
(137) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80327') 0.00062990188598633
(138) DESCRIBE `ships` 0.0040068626403809
(139) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) 0.00055193901062012
(140) DESCRIBE `ships` 0.0037498474121094
(141) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1761') 0.00042200088500977
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035500526428223
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036907196044922
(144) DESCRIBE `itineraries` 0.0018000602722168
(145) DESCRIBE `ports` 0.0021679401397705
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00044894218444824
(147) DESCRIBE `ports` 0.0018939971923828
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00040388107299805
(149) DESCRIBE `ports` 0.0019500255584717
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00054693222045898
(151) DESCRIBE `sailingdates` 0.0020909309387207
(152) DESCRIBE `ports` 0.0022141933441162
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.0004420280456543
(154) DESCRIBE `ports` 0.0019559860229492
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00042200088500977
(156) DESCRIBE `ports` 0.0018558502197266
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00054097175598145
(158) DESCRIBE `ports` 0.0026509761810303
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.0005500316619873
(160) DESCRIBE `avid_specials` 0.0025169849395752
(161) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80327 and class = 'Cruise') OR (item_id = 1761 AND class = 'Ship') OR (item_id = 183 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.0013070106506348
(162) DESCRIBE `cruiselines` 0.0026419162750244
(163) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00048613548278809
(164) DESCRIBE `orchid_image` 0.0026450157165527
(165) DESCRIBE `cruiselines` 0.0031671524047852
(166) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00064897537231445
(167) DESCRIBE `cruises` 0.0053458213806152
(168) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75752') 0.00064802169799805
(169) DESCRIBE `ships` 0.0057308673858643
(170) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1594))) 0.00079488754272461
(171) DESCRIBE `ships` 0.0056579113006592
(172) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1594') 0.00081110000610352
(173) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050997734069824
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004580020904541
(175) DESCRIBE `itineraries` 0.0025351047515869
(176) DESCRIBE `ports` 0.0026438236236572
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00042891502380371
(178) DESCRIBE `ports` 0.0026218891143799
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00055098533630371
(180) DESCRIBE `ports` 0.0028500556945801
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00049996376037598
(182) DESCRIBE `sailingdates` 0.0024449825286865
(183) DESCRIBE `ports` 0.0020620822906494
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00053191184997559
(185) DESCRIBE `ports` 0.0019021034240723
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00037693977355957
(187) DESCRIBE `ports` 0.0018720626831055
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00041103363037109
(189) DESCRIBE `ports` 0.0017578601837158
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00038695335388184
(191) DESCRIBE `ports` 0.0017499923706055
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00039100646972656
(193) DESCRIBE `ports` 0.0021719932556152
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00040602684020996
(195) DESCRIBE `ports` 0.0019598007202148
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00044107437133789
(197) DESCRIBE `ports` 0.0020298957824707
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00053906440734863
(199) DESCRIBE `ports` 0.0020968914031982
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00049996376037598
(201) DESCRIBE `ports` 0.0018470287322998
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00040006637573242
(203) DESCRIBE `ports` 0.0017881393432617
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00048613548278809
(205) DESCRIBE `ports` 0.0017940998077393
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00040197372436523
(207) DESCRIBE `ports` 0.0018758773803711
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.0004270076751709
(209) DESCRIBE `ports` 0.0018489360809326
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00038886070251465
(211) DESCRIBE `ports` 0.0024199485778809
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00050616264343262
(213) DESCRIBE `ports` 0.0018539428710938
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00050806999206543
(215) DESCRIBE `ports` 0.0019721984863281
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00038886070251465
(217) DESCRIBE `ports` 0.0019910335540771
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.0004730224609375
(219) DESCRIBE `ports` 0.001953125
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00043392181396484
(221) DESCRIBE `ports` 0.0018448829650879
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00041103363037109
(223) DESCRIBE `ports` 0.0019910335540771
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00063586235046387
(225) DESCRIBE `ports` 0.0020608901977539
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00052809715270996
(227) DESCRIBE `ports` 0.0018899440765381
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00054597854614258
(229) DESCRIBE `ports` 0.0019371509552002
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0004119873046875
(231) DESCRIBE `ports` 0.0018889904022217
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00043511390686035
(233) DESCRIBE `ports` 0.0020291805267334
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00043702125549316
(235) DESCRIBE `ports` 0.0023009777069092
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00045299530029297
(237) DESCRIBE `ports` 0.0025119781494141
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00060415267944336
(239) DESCRIBE `ports` 0.002593994140625
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.0006561279296875
(241) DESCRIBE `ports` 0.0026991367340088
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00063586235046387
(243) DESCRIBE `ports` 0.0029850006103516
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00047683715820312
(245) DESCRIBE `ports` 0.0021510124206543
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00039219856262207
(247) DESCRIBE `ports` 0.0019130706787109
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00041699409484863
(249) DESCRIBE `ports` 0.0019559860229492
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00044798851013184
(251) DESCRIBE `ports` 0.0017879009246826
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045299530029297
(253) DESCRIBE `ports` 0.0020349025726318
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00042891502380371
(255) DESCRIBE `ports` 0.0019669532775879
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00042390823364258
(257) DESCRIBE `ports` 0.0018799304962158
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039291381835938
(259) DESCRIBE `ports` 0.001802921295166
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047922134399414
(261) DESCRIBE `ports` 0.0017960071563721
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00044512748718262
(263) DESCRIBE `ports` 0.0019381046295166
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00058102607727051
(265) DESCRIBE `ports` 0.0020198822021484
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00038385391235352
(267) DESCRIBE `ports` 0.0019757747650146
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00061893463134766
(269) DESCRIBE `ports` 0.0023601055145264
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.0004570484161377
(271) DESCRIBE `avid_specials` 0.0016138553619385
(272) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75752 and class = 'Cruise') OR (item_id = 1594 AND class = 'Ship') OR (item_id = 101 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.00211501121521
(273) DESCRIBE `cruiselines` 0.0036489963531494
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00081801414489746
(275) DESCRIBE `orchid_image` 0.0023980140686035
(276) DESCRIBE `cruiselines` 0.0025010108947754
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00057697296142578
(278) DESCRIBE `cruises` 0.0054731369018555
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75753') 0.00071811676025391
(280) DESCRIBE `ships` 0.0055639743804932
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1237))) 0.0009307861328125
(282) DESCRIBE `ships` 0.0054900646209717
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1237') 0.00075602531433105
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051498413085938
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049901008605957
(286) DESCRIBE `itineraries` 0.0027508735656738
(287) DESCRIBE `ports` 0.0029611587524414
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00075507164001465
(289) DESCRIBE `ports` 0.0028829574584961
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00066804885864258
(291) DESCRIBE `ports` 0.001910924911499
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00044488906860352
(293) DESCRIBE `sailingdates` 0.0015771389007568
(294) DESCRIBE `ports` 0.0018529891967773
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00051593780517578
(296) DESCRIBE `ports` 0.0017430782318115
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00041413307189941
(298) DESCRIBE `ports` 0.0018160343170166
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00042319297790527
(300) DESCRIBE `ports` 0.0017759799957275
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00040388107299805
(302) DESCRIBE `ports` 0.001741886138916
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00042510032653809
(304) DESCRIBE `ports` 0.001774787902832
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00040388107299805
(306) DESCRIBE `ports` 0.0018301010131836
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00047612190246582
(308) DESCRIBE `ports` 0.0019009113311768
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00040888786315918
(310) DESCRIBE `ports` 0.0017900466918945
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00049614906311035
(312) DESCRIBE `ports` 0.0018689632415771
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00039005279541016
(314) DESCRIBE `ports` 0.0018641948699951
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00039982795715332
(316) DESCRIBE `ports` 0.0019071102142334
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00045394897460938
(318) DESCRIBE `ports` 0.0018348693847656
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00061798095703125
(320) DESCRIBE `ports` 0.0020420551300049
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00041508674621582
(322) DESCRIBE `ports` 0.0017948150634766
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00042319297790527
(324) DESCRIBE `ports` 0.001878023147583
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00041413307189941
(326) DESCRIBE `ports` 0.0018088817596436
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00041007995605469
(328) DESCRIBE `ports` 0.0017521381378174
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00041389465332031
(330) DESCRIBE `ports` 0.0017478466033936
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00043106079101562
(332) DESCRIBE `ports` 0.0017950534820557
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00039100646972656
(334) DESCRIBE `ports` 0.0019989013671875
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0004279613494873
(336) DESCRIBE `ports` 0.0017390251159668
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00043487548828125
(338) DESCRIBE `ports` 0.0017631053924561
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0003969669342041
(340) DESCRIBE `ports` 0.0018551349639893
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00035810470581055
(342) DESCRIBE `ports` 0.00187087059021
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00039005279541016
(344) DESCRIBE `ports` 0.002202033996582
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00047707557678223
(346) DESCRIBE `ports` 0.0018329620361328
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00055289268493652
(348) DESCRIBE `ports` 0.0020480155944824
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00066399574279785
(350) DESCRIBE `ports` 0.0021309852600098
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00044417381286621
(352) DESCRIBE `ports` 0.0018038749694824
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00037980079650879
(354) DESCRIBE `ports` 0.0017669200897217
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00040984153747559
(356) DESCRIBE `ports` 0.0017409324645996
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00037312507629395
(358) DESCRIBE `ports` 0.0017721652984619
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00040698051452637
(360) DESCRIBE `ports` 0.0018301010131836
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00037908554077148
(362) DESCRIBE `ports` 0.001741886138916
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049686431884766
(364) DESCRIBE `ports` 0.0017509460449219
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00053596496582031
(366) DESCRIBE `ports` 0.0026638507843018
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00041604042053223
(368) DESCRIBE `ports` 0.0017869472503662
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039410591125488
(370) DESCRIBE `ports` 0.001788854598999
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00042486190795898
(372) DESCRIBE `ports` 0.0020020008087158
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040006637573242
(374) DESCRIBE `ports` 0.0017800331115723
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00048303604125977
(376) DESCRIBE `ports` 0.0018219947814941
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00062394142150879
(378) DESCRIBE `ports` 0.0026531219482422
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00050711631774902
(380) DESCRIBE `ports` 0.0020179748535156
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.0003819465637207
(382) DESCRIBE `avid_specials` 0.0016911029815674
(383) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75753 and class = 'Cruise') OR (item_id = 1237 AND class = 'Ship') OR (item_id = 101 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.0011081695556641
(384) DESCRIBE `cruiselines` 0.0027351379394531
(385) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00041913986206055
(386) DESCRIBE `orchid_image` 0.002129077911377
(387) DESCRIBE `cruiselines` 0.0026001930236816
(388) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00044798851013184
(389) DESCRIBE `cruises` 0.0035510063171387
(390) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75747') 0.00045394897460938
(391) DESCRIBE `ships` 0.0036139488220215
(392) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1237))) 0.00055789947509766
(393) DESCRIBE `ships` 0.0037260055541992
(394) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1237') 0.00045895576477051
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035905838012695
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034594535827637
(397) DESCRIBE `itineraries` 0.0018279552459717
(398) DESCRIBE `ports` 0.0018589496612549
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00043106079101562
(400) DESCRIBE `ports` 0.0018808841705322
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00042510032653809
(402) DESCRIBE `ports` 0.0018188953399658
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0006251335144043
(404) DESCRIBE `sailingdates` 0.0016140937805176
(405) DESCRIBE `ports` 0.0017850399017334
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00048494338989258
(407) DESCRIBE `ports` 0.0018320083618164
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00040984153747559
(409) DESCRIBE `ports` 0.0018730163574219
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00043702125549316
(411) DESCRIBE `ports` 0.0019371509552002
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0004730224609375
(413) DESCRIBE `ports` 0.0023939609527588
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00043606758117676
(415) DESCRIBE `ports` 0.0017659664154053
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00038790702819824
(417) DESCRIBE `ports` 0.0019221305847168
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00041890144348145
(419) DESCRIBE `ports` 0.0023691654205322
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0004730224609375
(421) DESCRIBE `ports` 0.0021719932556152
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00075006484985352
(423) DESCRIBE `ports` 0.0019960403442383
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00050592422485352
(425) DESCRIBE `ports` 0.0018348693847656
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00047397613525391
(427) DESCRIBE `ports` 0.0018079280853271
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00044393539428711
(429) DESCRIBE `ports` 0.0017979145050049
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00037622451782227
(431) DESCRIBE `ports` 0.0017380714416504
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00039100646972656
(433) DESCRIBE `ports` 0.0018270015716553
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00041007995605469
(435) DESCRIBE `ports` 0.0018289089202881
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00039505958557129
(437) DESCRIBE `ports` 0.0017712116241455
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00044083595275879
(439) DESCRIBE `ports` 0.0018310546875
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00041604042053223
(441) DESCRIBE `ports` 0.0025749206542969
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00041103363037109
(443) DESCRIBE `ports` 0.001845121383667
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00037312507629395
(445) DESCRIBE `ports` 0.0017578601837158
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00040507316589355
(447) DESCRIBE `ports` 0.0017440319061279
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00038003921508789
(449) DESCRIBE `ports` 0.0018830299377441
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00041604042053223
(451) DESCRIBE `ports` 0.0021829605102539
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00039815902709961
(453) DESCRIBE `ports` 0.0017769336700439
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00041508674621582
(455) DESCRIBE `ports` 0.0021579265594482
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00037288665771484
(457) DESCRIBE `ports` 0.0023250579833984
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00042200088500977
(459) DESCRIBE `ports` 0.0018689632415771
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00043201446533203
(461) DESCRIBE `ports` 0.0021028518676758
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00041508674621582
(463) DESCRIBE `ports` 0.0020630359649658
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00042200088500977
(465) DESCRIBE `avid_specials` 0.0015690326690674
(466) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75747 and class = 'Cruise') OR (item_id = 1237 AND class = 'Ship') OR (item_id = 101 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.0011630058288574
(467) DESCRIBE `cruiselines` 0.0025789737701416
(468) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00040817260742188
(469) DESCRIBE `orchid_image` 0.0021719932556152
(470) DESCRIBE `cruiselines` 0.0027542114257812
(471) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00059103965759277
(472) DESCRIBE `cruises` 0.0034849643707275
(473) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75749') 0.00048398971557617
(474) DESCRIBE `ships` 0.003803014755249
(475) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1594))) 0.00054001808166504
(476) DESCRIBE `ships` 0.0036840438842773
(477) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1594') 0.00052618980407715
(478) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035810470581055
(479) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037598609924316
(480) DESCRIBE `itineraries` 0.0018980503082275
(481) DESCRIBE `ports` 0.0019528865814209
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00044894218444824
(483) DESCRIBE `ports` 0.0017359256744385
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0003669261932373
(485) DESCRIBE `ports` 0.0018270015716553
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00035500526428223
(487) DESCRIBE `sailingdates` 0.0015368461608887
(488) DESCRIBE `ports` 0.0018248558044434
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00041604042053223
(490) DESCRIBE `ports` 0.0018570423126221
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00038599967956543
(492) DESCRIBE `ports` 0.0018599033355713
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0003659725189209
(494) DESCRIBE `ports` 0.0018539428710938
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00040698051452637
(496) DESCRIBE `ports` 0.0017349720001221
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00053191184997559
(498) DESCRIBE `ports` 0.0022761821746826
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00037312507629395
(500) DESCRIBE `ports` 0.0021059513092041
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00037717819213867
(502) DESCRIBE `ports` 0.0022149085998535
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00035619735717773
(504) DESCRIBE `ports` 0.0017788410186768
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0004119873046875
(506) DESCRIBE `ports` 0.0017650127410889
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00053811073303223
(508) DESCRIBE `ports` 0.0018398761749268
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00040388107299805
(510) DESCRIBE `ports` 0.0019938945770264
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00037693977355957
(512) DESCRIBE `ports` 0.0019512176513672
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00038886070251465
(514) DESCRIBE `ports` 0.0018420219421387
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00038480758666992
(516) DESCRIBE `ports` 0.0020699501037598
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00040507316589355
(518) DESCRIBE `ports` 0.0018990039825439
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00038409233093262
(520) DESCRIBE `ports` 0.0018241405487061
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.0003669261932373
(522) DESCRIBE `ports` 0.0022928714752197
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00051593780517578
(524) DESCRIBE `ports` 0.0019168853759766
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00039410591125488
(526) DESCRIBE `ports` 0.0017361640930176
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00036811828613281
(528) DESCRIBE `ports` 0.0018479824066162
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00039315223693848
(530) DESCRIBE `ports` 0.0021510124206543
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00057101249694824
(532) DESCRIBE `ports` 0.0021240711212158
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00042819976806641
(534) DESCRIBE `ports` 0.0017809867858887
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00051403045654297
(536) DESCRIBE `ports` 0.0017809867858887
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0004429817199707
(538) DESCRIBE `ports` 0.0020029544830322
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00047707557678223
(540) DESCRIBE `ports` 0.0018129348754883
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00040507316589355
(542) DESCRIBE `ports` 0.0018181800842285
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0003809928894043
(544) DESCRIBE `avid_specials` 0.0015430450439453
(545) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75749 and class = 'Cruise') OR (item_id = 1594 AND class = 'Ship') OR (item_id = 101 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.0012800693511963
(546) DESCRIBE `cruiselines` 0.0027291774749756
(547) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00058603286743164
(548) DESCRIBE `orchid_image` 0.0021209716796875
(549) DESCRIBE `cruiselines` 0.0025720596313477
(550) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00039887428283691
(551) DESCRIBE `cruises` 0.0034379959106445
(552) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41693') 0.00045514106750488
(553) DESCRIBE `ships` 0.0036940574645996
(554) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00064682960510254
(555) DESCRIBE `ships` 0.0038061141967773
(556) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00047993659973145
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039982795715332
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035190582275391
(559) DESCRIBE `itineraries` 0.0019309520721436
(560) DESCRIBE `ports` 0.0027410984039307
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00076889991760254
(562) DESCRIBE `ports` 0.0032658576965332
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00075697898864746
(564) DESCRIBE `ports` 0.0025100708007812
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00040197372436523
(566) DESCRIBE `sailingdates` 0.0018401145935059
(567) DESCRIBE `ports` 0.0021069049835205
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00045204162597656
(569) DESCRIBE `ports` 0.0017719268798828
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00039410591125488
(571) DESCRIBE `ports` 0.0018279552459717
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00049495697021484
(573) DESCRIBE `ports` 0.0024549961090088
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.00054502487182617
(575) DESCRIBE `ports` 0.0020999908447266
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00057601928710938
(577) DESCRIBE `ports` 0.0021390914916992
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00039982795715332
(579) DESCRIBE `ports` 0.0020439624786377
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00047898292541504
(581) DESCRIBE `ports` 0.0023739337921143
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00054788589477539
(583) DESCRIBE `ports` 0.0021860599517822
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00044012069702148
(585) DESCRIBE `ports` 0.0018069744110107
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00054192543029785
(587) DESCRIBE `ports` 0.001945972442627
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00056290626525879
(589) DESCRIBE `ports` 0.002316951751709
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.00056004524230957
(591) DESCRIBE `ports` 0.0019419193267822
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00044012069702148
(593) DESCRIBE `ports` 0.0020689964294434
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00043082237243652
(595) DESCRIBE `ports` 0.0018999576568604
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6058))) 0.00043487548828125
(597) DESCRIBE `ports` 0.0021719932556152
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6058') 0.00041103363037109
(599) DESCRIBE `ports` 0.0018060207366943
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00053191184997559
(601) DESCRIBE `ports` 0.0018908977508545
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00042486190795898
(603) DESCRIBE `ports` 0.0019659996032715
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00042009353637695
(605) DESCRIBE `ports` 0.0019979476928711
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00039005279541016
(607) DESCRIBE `avid_specials` 0.0019941329956055
(608) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41693 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 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.0012679100036621
(609) DESCRIBE `cruiselines` 0.0027692317962646
(610) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00050806999206543
(611) DESCRIBE `orchid_image` 0.0022940635681152
(612) DESCRIBE `cruiselines` 0.0028069019317627
(613) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00043606758117676
(614) DESCRIBE `cruiselines` 0.0030272006988525
(615) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '262', '170', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '208', '16', '187', '36', '49', '47', '88', '251', '216', '151', '141', '212', '181', '4', '118', '110', '59', '30', '140', '73', '147', '261', '115', '48', '213', '159', '264', '211', '276', '209', '108', '113', '57', '90', '82', '95', '184', '38', '180', '52', '244', '105', '35', '64', '134', '257', '245', '172')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,262,170,114,24,28,14,156,191,50,258,195,37,153,208,16,187,36,49,47,88,251,216,151,141,212,181,4,118,110,59,30,140,73,147,261,115,48,213,159,264,211,276,209,108,113,57,90,82,95,184,38,180,52,244,105,35,64,134,257,245,172') 0.0058639049530029
(616) DESCRIBE `ships` 0.0043289661407471
(617) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '1417', '780', '1324', '855', '1588', '1717', '207', '1794', '871', '1291', '874', '1594', '977', '1572', '454', '1199', '1766', '404', '1359', '1272', '770', '22', '330', '461', '21', '393', '1032', '974', '66', '716', '1237', '28', '738', '1292', '1424', '434', '797', '1134', '553', '1682', '265', '332', '521', '333', '1348', '766', '1768', '349', '711', '1415', '1260', '1419', '1423', '1422', '585', '1418', '1420', '1421', '9', '11', '715', '857', '10', '858', '1501', '1677', '163', '739', '792', '407', '439', '455', '25', '1132', '1678', '378', '3', '31', '34', '36', '39', '674', '24', '542', '657', '1460', '520', '1008', '1721', '1141', '1205', '837', '1569', '1607', '385', '1742', '1852', '1402', '1773', '386', '966', '1302', '1067', '1168', '1233', '1372', '113', '882', '1822', '850', '1012', '1505', '1811', '160', '1676', '35', '98', '338', '626', '768', '1454', '1455', '1574', '573', '1602', '37', '1135', '1319', '1373', '285', '451', '30', '610', '986', '1021', '63', '817', '1284', '1733', '352', '1282', '1413', '1259', '1411', '547', '1410', '1782', '38', '111', '148', '1398', '108', '314', '375', '1193', '1722', '406', '1088', '1437', '43', '286', '503', '508', '627', '1108', '198', '748', '1063', '1308', '1808', '340', '526', '1145', '1320', '1323', '1579', '1711', '883', '970', '116', '124', '327', '485', '854', '1149', '1325', '1586', '348', '390', '582', '1571', '1738', '394', '590', '1028', '1492', '119', '1068', '1208', '1266', '1575', '1724', '1810', '223', '335', '616', '944', '1157', '1321', '1412', '1552', '1672', '75', '82', '652', '791', '1461', '1587', '1809', '114', '704', '1801', '70', '351', '462', '4', '147', '441', '480', '545', '658', '678', '1027', '1853', '683', '1289', '884', '988', '78', '162', '325', '403', '1318', '1330', '1408', '1820', '69', '105', '201', '401', '601', '722', '790', '291', '405', '958', '1139', '1486', '149', '341', '1188', '1303', '81', '287', '389', '580', '776', '1073', '1236', '1245', '1772', '123', '262', '483', '651', '1326', '1327', '1539', '1771', '818', '1037', '1367', '1704', '423', '1043', '1151', '1159', '1526', '1757', '266', '673', '1013', '1040', '1172', '1540', '290', '796', '1019', '45', '1474', '639', '968', '1223', '1573', '84', '574', '635', '795', '1426', '1463', '1681', '1730', '1740', '1743', '751', '775', '852', '1029', '1035', '1160', '1338', '1715', '1758', '324', '717', '1163', '1206', '1217', '1344', '972', '1146', '1150', '1226', '1229', '1283', '1409', '1452', '1453', '1604', '1716', '417', '643', '709', '1095', '1143', '1144', '1343', '1358', '1483', '1663', '1807', '1833', '851', '905', '1048', '1136', '1262', '1293', '1448', '1673', '1746', '151', '665', '1042', '1045', '1230', '1231', '1787', '212', '467', '885', '1026', '1051', '1137', '1152', '1351', '1449', '1749', '1791', '644', '1140', '1154', '1340', '1458', '1647', '1723', '1759', '1806', '663', '769', '954', '1109', '1224', '1366', '1368', '1405', '1459', '1609', '1632', '1751', '1816', '150', '208', '453', '559', '920', '973', '996', '1025', '1049', '1050', '1090', '1148', '1274', '1329', '1354', '1360', '1361', '1362', '1519', '1601', '1708', '1713', '1805', '448', '666', '914', '921', '923', '927', '1044', '1055', '1072', '1196', '1322', '1339', '1649', '1714', '1750', '1788', '1823', '701', '707', '740', '886', '915', '916', '926', '930', '931', '1071', '1294', '1854', '703', '924', '1047', '1052', '1389', '1580', '1596', '1650', '299', '300', '422', '1004', '1020', '1036', '1039', '1054', '1225', '1350', '1352', '1451', '93', '479', '784', '937', '1664', '205', '253', '487', '672', '888', '1256', '1301', '1599', '1626', '1674', '671', '821', '965', '999', '1232')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,1417,780,1324,855,1588,1717,207,1794,871,1291,874,1594,977,1572,454,1199,1766,404,1359,1272,770,22,330,461,21,393,1032,974,66,716,1237,28,738,1292,1424,434,797,1134,553,1682,265,332,521,333,1348,766,1768,349,711,1415,1260,1419,1423,1422,585,1418,1420,1421,9,11,715,857,10,858,1501,1677,163,739,792,407,439,455,25,1132,1678,378,3,31,34,36,39,674,24,542,657,1460,520,1008,1721,1141,1205,837,1569,1607,385,1742,1852,1402,1773,386,966,1302,1067,1168,1233,1372,113,882,1822,850,1012,1505,1811,160,1676,35,98,338,626,768,1454,1455,1574,573,1602,37,1135,1319,1373,285,451,30,610,986,1021,63,817,1284,1733,352,1282,1413,1259,1411,547,1410,1782,38,111,148,1398,108,314,375,1193,1722,406,1088,1437,43,286,503,508,627,1108,198,748,1063,1308,1808,340,526,1145,1320,1323,1579,1711,883,970,116,124,327,485,854,1149,1325,1586,348,390,582,1571,1738,394,590,1028,1492,119,1068,1208,1266,1575,1724,1810,223,335,616,944,1157,1321,1412,1552,1672,75,82,652,791,1461,1587,1809,114,704,1801,70,351,462,4,147,441,480,545,658,678,1027,1853,683,1289,884,988,78,162,325,403,1318,1330,1408,1820,69,105,201,401,601,722,790,291,405,958,1139,1486,149,341,1188,1303,81,287,389,580,776,1073,1236,1245,1772,123,262,483,651,1326,1327,1539,1771,818,1037,1367,1704,423,1043,1151,1159,1526,1757,266,673,1013,1040,1172,1540,290,796,1019,45,1474,639,968,1223,1573,84,574,635,795,1426,1463,1681,1730,1740,1743,751,775,852,1029,1035,1160,1338,1715,1758,324,717,1163,1206,1217,1344,972,1146,1150,1226,1229,1283,1409,1452,1453,1604,1716,417,643,709,1095,1143,1144,1343,1358,1483,1663,1807,1833,851,905,1048,1136,1262,1293,1448,1673,1746,151,665,1042,1045,1230,1231,1787,212,467,885,1026,1051,1137,1152,1351,1449,1749,1791,644,1140,1154,1340,1458,1647,1723,1759,1806,663,769,954,1109,1224,1366,1368,1405,1459,1609,1632,1751,1816,150,208,453,559,920,973,996,1025,1049,1050,1090,1148,1274,1329,1354,1360,1361,1362,1519,1601,1708,1713,1805,448,666,914,921,923,927,1044,1055,1072,1196,1322,1339,1649,1714,1750,1788,1823,701,707,740,886,915,916,926,930,931,1071,1294,1854,703,924,1047,1052,1389,1580,1596,1650,299,300,422,1004,1020,1036,1039,1054,1225,1350,1352,1451,93,479,784,937,1664,205,253,487,672,888,1256,1301,1599,1626,1674,671,821,965,999,1232') 0.066740989685059
(618) DESCRIBE `cruisetypes` 0.0044739246368408
(619) DESCRIBE `destinations` 0.0031049251556396
(620) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '49', '7', '11', '45', '21', '48', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,37,9,2,8,44,55,53,39,40,26,38,28,30,49,7,11,45,21,48,29,52,34,10,46,56,32') 0.0025241374969482