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

Total elapsed time: 2.1066112518311

# Query Time
(1) connect 0.0043649673461914
(2) DESCRIBE `cruises` 0.0083208084106445
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (11517, 6056, 4425, 4424, 65943, 65945, 76299, 49093, 37235, 45258)) ORDER BY FIND_IN_SET(id, '11517,6056,4425,4424,65943,65945,76299,49093,37235,45258') 0.003741979598999
(4) DESCRIBE `specials` 0.0059459209442139
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1541784') AND (specials.orchid_available = 1) LIMIT 1 0.0010490417480469
(6) DESCRIBE `specials` 0.0069730281829834
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541784') 0.0005638599395752
(8) DESCRIBE `ships` 0.0051288604736328
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00073480606079102
(10) DESCRIBE `ships` 0.010100841522217
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.0043718814849854
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00056600570678711
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00080490112304688
(14) DESCRIBE `itineraries` 0.0030128955841064
(15) DESCRIBE `ports` 0.0051560401916504
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00073504447937012
(17) DESCRIBE `ports` 0.0028262138366699
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00075697898864746
(19) DESCRIBE `ports` 0.0030159950256348
(20) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00071001052856445
(21) DESCRIBE `specialsailingdates` 0.0025100708007812
(22) DESCRIBE `sailingdates` 0.0027949810028076
(23) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518743))) 0.0009620189666748
(24) DESCRIBE `sailingdates` 0.0026009082794189
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518744))) 0.00068402290344238
(26) DESCRIBE `sailingdates` 0.0021519660949707
(27) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518746))) 0.00063085556030273
(28) DESCRIBE `sailingdates` 0.0023188591003418
(29) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518749))) 0.0005500316619873
(30) DESCRIBE `sailingdates` 0.0030021667480469
(31) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518750))) 0.00064301490783691
(32) DESCRIBE `sailingdates` 0.0027360916137695
(33) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518751))) 0.00065779685974121
(34) DESCRIBE `sailingdates` 0.002903938293457
(35) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518754))) 0.00066494941711426
(36) DESCRIBE `sailingdates` 0.0027611255645752
(37) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518755))) 0.00068998336791992
(38) DESCRIBE `sailingdates` 0.0027601718902588
(39) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518756))) 0.00063896179199219
(40) DESCRIBE `sailingdates` 0.0023598670959473
(41) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518757))) 0.00060606002807617
(42) DESCRIBE `sailingdates` 0.0031719207763672
(43) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518758))) 0.00064992904663086
(44) DESCRIBE `sailingdates` 0.002673864364624
(45) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518759))) 0.00070714950561523
(46) DESCRIBE `sailingdates` 0.0024490356445312
(47) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518760))) 0.0012071132659912
(48) DESCRIBE `sailingdates` 0.0032100677490234
(49) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518761))) 0.00047087669372559
(50) DESCRIBE `sailingdates` 0.0023820400238037
(51) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518762))) 0.00057601928710938
(52) DESCRIBE `sailingdates` 0.002791166305542
(53) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518763))) 0.00064897537231445
(54) DESCRIBE `sailingdates` 0.0025479793548584
(55) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518764))) 0.00060105323791504
(56) DESCRIBE `sailingdates` 0.0028760433197021
(57) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518765))) 0.00089907646179199
(58) DESCRIBE `sailingdates` 0.0029740333557129
(59) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518766))) 0.00072407722473145
(60) DESCRIBE `sailingdates` 0.0030088424682617
(61) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518767))) 0.00069880485534668
(62) DESCRIBE `sailingdates` 0.0028860569000244
(63) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518770))) 0.0010218620300293
(64) DESCRIBE `sailingdates` 0.0027270317077637
(65) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518772))) 0.00061821937561035
(66) DESCRIBE `sailingdates` 0.0026302337646484
(67) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518773))) 0.0006859302520752
(68) DESCRIBE `sailingdates` 0.0043849945068359
(69) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518774))) 0.00063705444335938
(70) DESCRIBE `sailingdates` 0.0024969577789307
(71) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518776))) 0.00059795379638672
(72) DESCRIBE `sailingdates` 0.0031650066375732
(73) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518777))) 0.00084400177001953
(74) DESCRIBE `sailingdates` 0.0026431083679199
(75) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518778))) 0.00079107284545898
(76) DESCRIBE `sailingdates` 0.0030040740966797
(77) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518779))) 0.00082111358642578
(78) DESCRIBE `ports` 0.0032510757446289
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00073909759521484
(80) DESCRIBE `ports` 0.0038120746612549
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.001133918762207
(82) DESCRIBE `ports` 0.0035820007324219
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00089097023010254
(84) DESCRIBE `ports` 0.0033848285675049
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00092601776123047
(86) DESCRIBE `ports` 0.0061981678009033
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00069284439086914
(88) DESCRIBE `ports` 0.002701997756958
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00061202049255371
(90) DESCRIBE `ports` 0.0050990581512451
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.0010659694671631
(92) DESCRIBE `ports` 0.0034098625183105
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00076198577880859
(94) DESCRIBE `ports` 0.003648042678833
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.0010671615600586
(96) DESCRIBE `ports` 0.0030660629272461
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00063514709472656
(98) DESCRIBE `ports` 0.0027651786804199
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.0006721019744873
(100) DESCRIBE `ports` 0.0028810501098633
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00061917304992676
(102) DESCRIBE `ports` 0.0037648677825928
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00078701972961426
(104) DESCRIBE `ports` 0.0034170150756836
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00055789947509766
(106) DESCRIBE `ports` 0.0030369758605957
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00082802772521973
(108) DESCRIBE `ports` 0.0028440952301025
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00066304206848145
(110) DESCRIBE `ports` 0.0029659271240234
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00066304206848145
(112) DESCRIBE `ports` 0.0024929046630859
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00063514709472656
(114) DESCRIBE `ports` 0.0024840831756592
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00061511993408203
(116) DESCRIBE `ports` 0.0024840831756592
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00058102607727051
(118) DESCRIBE `ports` 0.0027561187744141
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00065088272094727
(120) DESCRIBE `ports` 0.0027759075164795
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00058412551879883
(122) DESCRIBE `ports` 0.0026540756225586
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00060009956359863
(124) DESCRIBE `ports` 0.0027229785919189
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00057697296142578
(126) DESCRIBE `ports` 0.002669095993042
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00074601173400879
(128) DESCRIBE `ports` 0.0026321411132812
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00059103965759277
(130) DESCRIBE `ports` 0.0025789737701416
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00060796737670898
(132) DESCRIBE `ports` 0.0027980804443359
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00065898895263672
(134) DESCRIBE `ports` 0.0029051303863525
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00080704689025879
(136) DESCRIBE `ports` 0.0028340816497803
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00069904327392578
(138) DESCRIBE `ports` 0.002708911895752
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00064301490783691
(140) DESCRIBE `ports` 0.0028278827667236
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00058102607727051
(142) DESCRIBE `ports` 0.0028889179229736
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0005800724029541
(144) DESCRIBE `ports` 0.0029470920562744
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00075912475585938
(146) DESCRIBE `ports` 0.0066239833831787
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0013751983642578
(148) DESCRIBE `ports` 0.003403902053833
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00088691711425781
(150) DESCRIBE `cruises` 0.0056190490722656
(151) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00074410438537598
(152) DESCRIBE `avid_specials` 0.0026440620422363
(153) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541784 and class = 'Special') OR (item_id = 11517 and class = 'Cruise') OR (item_id = 521 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.0024800300598145
(154) DESCRIBE `cruiselines` 0.0042448043823242
(155) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00078105926513672
(156) DESCRIBE `orchid_image` 0.0029799938201904
(157) DESCRIBE `cruiselines` 0.0046870708465576
(158) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00066089630126953
(159) DESCRIBE `specials` 0.007072925567627
(160) SELECT `specials`.* FROM `specials` WHERE (id = '1607893') AND (specials.orchid_available = 1) LIMIT 1 0.0009760856628418
(161) DESCRIBE `specials` 0.0079050064086914
(162) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1607893') 0.00090408325195312
(163) DESCRIBE `ships` 0.0058829784393311
(164) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.00091290473937988
(165) DESCRIBE `ships` 0.0053369998931885
(166) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.0006709098815918
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00049495697021484
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00055789947509766
(169) DESCRIBE `itineraries` 0.0029730796813965
(170) DESCRIBE `ports` 0.0030090808868408
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0007631778717041
(172) DESCRIBE `ports` 0.0030078887939453
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00066184997558594
(174) DESCRIBE `ports` 0.0029430389404297
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00050902366638184
(176) DESCRIBE `specialsailingdates` 0.0020899772644043
(177) DESCRIBE `sailingdates` 0.0023629665374756
(178) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490536))) 0.00060296058654785
(179) DESCRIBE `sailingdates` 0.0020451545715332
(180) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490537))) 0.0005800724029541
(181) DESCRIBE `sailingdates` 0.0025599002838135
(182) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490538))) 0.00066804885864258
(183) DESCRIBE `sailingdates` 0.0027260780334473
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490539))) 0.00056791305541992
(185) DESCRIBE `sailingdates` 0.0020918846130371
(186) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490540))) 0.0005791187286377
(187) DESCRIBE `sailingdates` 0.0018270015716553
(188) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490541))) 0.00057601928710938
(189) DESCRIBE `sailingdates` 0.0022079944610596
(190) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490542))) 0.00077486038208008
(191) DESCRIBE `sailingdates` 0.0027890205383301
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490543))) 0.00071001052856445
(193) DESCRIBE `sailingdates` 0.0027070045471191
(194) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490544))) 0.00064396858215332
(195) DESCRIBE `sailingdates` 0.0022449493408203
(196) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490545))) 0.00068998336791992
(197) DESCRIBE `sailingdates` 0.0024490356445312
(198) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490546))) 0.00071001052856445
(199) DESCRIBE `sailingdates` 0.002755880355835
(200) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490547))) 0.00065016746520996
(201) DESCRIBE `sailingdates` 0.002443790435791
(202) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490548))) 0.00059986114501953
(203) DESCRIBE `sailingdates` 0.0026488304138184
(204) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490549))) 0.00085306167602539
(205) DESCRIBE `sailingdates` 0.0048677921295166
(206) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490550))) 0.00067496299743652
(207) DESCRIBE `sailingdates` 0.0030410289764404
(208) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490551))) 0.00079703330993652
(209) DESCRIBE `sailingdates` 0.0024778842926025
(210) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490552))) 0.0010778903961182
(211) DESCRIBE `ports` 0.0031619071960449
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00075006484985352
(213) DESCRIBE `ports` 0.002871036529541
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00067782402038574
(215) DESCRIBE `ports` 0.0030190944671631
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00071001052856445
(217) DESCRIBE `ports` 0.0029299259185791
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00072789192199707
(219) DESCRIBE `ports` 0.0035948753356934
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00099396705627441
(221) DESCRIBE `ports` 0.0030999183654785
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00066900253295898
(223) DESCRIBE `ports` 0.0073909759521484
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00067806243896484
(225) DESCRIBE `ports` 0.0027778148651123
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00078201293945312
(227) DESCRIBE `ports` 0.0026180744171143
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00058698654174805
(229) DESCRIBE `ports` 0.0024070739746094
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00067806243896484
(231) DESCRIBE `ports` 0.0027790069580078
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00071001052856445
(233) DESCRIBE `ports` 0.0027999877929688
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00083494186401367
(235) DESCRIBE `ports` 0.0029919147491455
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00066518783569336
(237) DESCRIBE `ports` 0.017058134078979
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00067496299743652
(239) DESCRIBE `ports` 0.0030369758605957
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00078892707824707
(241) DESCRIBE `ports` 0.0030241012573242
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00071310997009277
(243) DESCRIBE `cruises` 0.0070178508758545
(244) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 6056))) 0.00078082084655762
(245) DESCRIBE `avid_specials` 0.0033230781555176
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1607893 and class = 'Special') OR (item_id = 6056 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0031270980834961
(247) DESCRIBE `cruiselines` 0.0052061080932617
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.00076985359191895
(249) DESCRIBE `orchid_image` 0.0036759376525879
(250) DESCRIBE `cruiselines` 0.0053179264068604
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.00081992149353027
(252) DESCRIBE `specials` 0.010274887084961
(253) SELECT `specials`.* FROM `specials` WHERE (id = '1607903') AND (specials.orchid_available = 1) LIMIT 1 0.0013370513916016
(254) DESCRIBE `specials` 0.014573097229004
(255) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1607903') 0.00071287155151367
(256) DESCRIBE `ships` 0.0058879852294922
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.00080108642578125
(258) DESCRIBE `ships` 0.0071709156036377
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.00063395500183105
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00047421455383301
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00079107284545898
(262) DESCRIBE `itineraries` 0.0042181015014648
(263) DESCRIBE `ports` 0.0036890506744385
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00091314315795898
(265) DESCRIBE `ports` 0.0037338733673096
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00098705291748047
(267) DESCRIBE `ports` 0.0024459362030029
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0018818378448486
(269) DESCRIBE `specialsailingdates` 0.0027108192443848
(270) DESCRIBE `sailingdates` 0.0027480125427246
(271) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490503))) 0.0006561279296875
(272) DESCRIBE `sailingdates` 0.0027260780334473
(273) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490504))) 0.00059008598327637
(274) DESCRIBE `sailingdates` 0.0058181285858154
(275) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490505))) 0.00076198577880859
(276) DESCRIBE `sailingdates` 0.0031299591064453
(277) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490506))) 0.00068402290344238
(278) DESCRIBE `sailingdates` 0.0050139427185059
(279) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490507))) 0.00097107887268066
(280) DESCRIBE `sailingdates` 0.002155065536499
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490508))) 0.00052094459533691
(282) DESCRIBE `sailingdates` 0.0022480487823486
(283) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490509))) 0.00062394142150879
(284) DESCRIBE `sailingdates` 0.0025749206542969
(285) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490510))) 0.00057888031005859
(286) DESCRIBE `sailingdates` 0.0024158954620361
(287) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490511))) 0.00061678886413574
(288) DESCRIBE `sailingdates` 0.0032539367675781
(289) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490512))) 0.00082612037658691
(290) DESCRIBE `sailingdates` 0.0024981498718262
(291) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490513))) 0.00069594383239746
(292) DESCRIBE `sailingdates` 0.0047399997711182
(293) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490514))) 0.00071501731872559
(294) DESCRIBE `sailingdates` 0.0051131248474121
(295) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490515))) 0.00074386596679688
(296) DESCRIBE `sailingdates` 0.0050249099731445
(297) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490516))) 0.00057888031005859
(298) DESCRIBE `sailingdates` 0.0032999515533447
(299) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490517))) 0.00082182884216309
(300) DESCRIBE `sailingdates` 0.0026569366455078
(301) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490518))) 0.00060200691223145
(302) DESCRIBE `sailingdates` 0.0046188831329346
(303) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490519))) 0.0006110668182373
(304) DESCRIBE `ports` 0.0028870105743408
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00066423416137695
(306) DESCRIBE `ports` 0.0037250518798828
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00065088272094727
(308) DESCRIBE `ports` 0.0028390884399414
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00061988830566406
(310) DESCRIBE `ports` 0.0034339427947998
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0014159679412842
(312) DESCRIBE `ports` 0.0036458969116211
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00078010559082031
(314) DESCRIBE `ports` 0.0033249855041504
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00083208084106445
(316) DESCRIBE `ports` 0.0039780139923096
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00088000297546387
(318) DESCRIBE `ports` 0.0041530132293701
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00065183639526367
(320) DESCRIBE `ports` 0.002871036529541
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00070381164550781
(322) DESCRIBE `ports` 0.0029928684234619
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00075721740722656
(324) DESCRIBE `cruises` 0.0047450065612793
(325) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 4425))) 0.0010168552398682
(326) DESCRIBE `avid_specials` 0.0025908946990967
(327) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1607903 and class = 'Special') OR (item_id = 4425 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022931098937988
(328) DESCRIBE `cruiselines` 0.0037670135498047
(329) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.00083613395690918
(330) DESCRIBE `orchid_image` 0.0033540725708008
(331) DESCRIBE `cruiselines` 0.0040519237518311
(332) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.00066304206848145
(333) DESCRIBE `specials` 0.0071818828582764
(334) SELECT `specials`.* FROM `specials` WHERE (id = '1607913') AND (specials.orchid_available = 1) LIMIT 1 0.00099897384643555
(335) DESCRIBE `specials` 0.0072958469390869
(336) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1607913') 0.00075721740722656
(337) DESCRIBE `ships` 0.0055389404296875
(338) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.0015699863433838
(339) DESCRIBE `ships` 0.0055959224700928
(340) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.0007319450378418
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00066494941711426
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0005488395690918
(343) DESCRIBE `itineraries` 0.003058910369873
(344) DESCRIBE `ports` 0.0027539730072021
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00075507164001465
(346) DESCRIBE `ports` 0.0056331157684326
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0007779598236084
(348) DESCRIBE `ports` 0.00311279296875
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0006718635559082
(350) DESCRIBE `specialsailingdates` 0.0021319389343262
(351) DESCRIBE `sailingdates` 0.0023000240325928
(352) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490469))) 0.0006110668182373
(353) DESCRIBE `sailingdates` 0.0025339126586914
(354) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490470))) 0.00057792663574219
(355) DESCRIBE `sailingdates` 0.0023360252380371
(356) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490471))) 0.00071597099304199
(357) DESCRIBE `sailingdates` 0.0023648738861084
(358) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490475))) 0.00065898895263672
(359) DESCRIBE `sailingdates` 0.0026721954345703
(360) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490472))) 0.00065398216247559
(361) DESCRIBE `sailingdates` 0.0026199817657471
(362) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490476))) 0.00064706802368164
(363) DESCRIBE `sailingdates` 0.0027120113372803
(364) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490473))) 0.00064301490783691
(365) DESCRIBE `sailingdates` 0.0023150444030762
(366) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490474))) 0.00064897537231445
(367) DESCRIBE `sailingdates` 0.0024211406707764
(368) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490477))) 0.0019698143005371
(369) DESCRIBE `sailingdates` 0.0028719902038574
(370) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490478))) 0.00094985961914062
(371) DESCRIBE `sailingdates` 0.0024151802062988
(372) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490479))) 0.00046205520629883
(373) DESCRIBE `sailingdates` 0.0023190975189209
(374) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490480))) 0.0005638599395752
(375) DESCRIBE `sailingdates` 0.0019230842590332
(376) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490481))) 0.00043582916259766
(377) DESCRIBE `sailingdates` 0.0020458698272705
(378) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490482))) 0.00064897537231445
(379) DESCRIBE `sailingdates` 0.0022990703582764
(380) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490483))) 0.00051999092102051
(381) DESCRIBE `sailingdates` 0.0018501281738281
(382) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490484))) 0.00045084953308105
(383) DESCRIBE `sailingdates` 0.0018270015716553
(384) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490485))) 0.00053906440734863
(385) DESCRIBE `sailingdates` 0.002194881439209
(386) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490486))) 0.00067901611328125
(387) DESCRIBE `ports` 0.0032510757446289
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00081014633178711
(389) DESCRIBE `ports` 0.0030951499938965
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00068306922912598
(391) DESCRIBE `ports` 0.002655029296875
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00066113471984863
(393) DESCRIBE `ports` 0.0024690628051758
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00055694580078125
(395) DESCRIBE `ports` 0.0028748512268066
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00064897537231445
(397) DESCRIBE `ports` 0.0029399394989014
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00077199935913086
(399) DESCRIBE `ports` 0.0029511451721191
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00086402893066406
(401) DESCRIBE `ports` 0.0035560131072998
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00068998336791992
(403) DESCRIBE `cruises` 0.0080418586730957
(404) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 4424))) 0.0011980533599854
(405) DESCRIBE `avid_specials` 0.0027420520782471
(406) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1607913 and class = 'Special') OR (item_id = 4424 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021710395812988
(407) DESCRIBE `cruiselines` 0.0038039684295654
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.00078892707824707
(409) DESCRIBE `orchid_image` 0.0029430389404297
(410) DESCRIBE `cruiselines` 0.0039279460906982
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.00069093704223633
(412) DESCRIBE `specials` 0.007598876953125
(413) SELECT `specials`.* FROM `specials` WHERE (id = '1541766') AND (specials.orchid_available = 1) LIMIT 1 0.0010559558868408
(414) DESCRIBE `specials` 0.0079119205474854
(415) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541766') 0.00070405006408691
(416) DESCRIBE `ships` 0.0053331851959229
(417) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 520))) 0.00094985961914062
(418) DESCRIBE `ships` 0.0047581195831299
(419) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '520') 0.00072288513183594
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050210952758789
(421) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051093101501465
(422) DESCRIBE `itineraries` 0.0026450157165527
(423) DESCRIBE `ports` 0.0028989315032959
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00098299980163574
(425) DESCRIBE `ports` 0.0027139186859131
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00074291229248047
(427) DESCRIBE `ports` 0.0026841163635254
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00068783760070801
(429) DESCRIBE `specialsailingdates` 0.0020649433135986
(430) DESCRIBE `sailingdates` 0.0036780834197998
(431) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518703))) 0.00094819068908691
(432) DESCRIBE `sailingdates` 0.0026559829711914
(433) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518707))) 0.00065994262695312
(434) DESCRIBE `sailingdates` 0.0023670196533203
(435) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518708))) 0.00062704086303711
(436) DESCRIBE `sailingdates` 0.0030920505523682
(437) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518710))) 0.00073409080505371
(438) DESCRIBE `sailingdates` 0.0021569728851318
(439) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518711))) 0.00059103965759277
(440) DESCRIBE `sailingdates` 0.0021059513092041
(441) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518713))) 0.00064516067504883
(442) DESCRIBE `sailingdates` 0.0017428398132324
(443) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518715))) 0.00046610832214355
(444) DESCRIBE `sailingdates` 0.0017151832580566
(445) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518716))) 0.00065493583679199
(446) DESCRIBE `sailingdates` 0.0025138854980469
(447) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518718))) 0.00065302848815918
(448) DESCRIBE `sailingdates` 0.0025789737701416
(449) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518721))) 0.00069499015808105
(450) DESCRIBE `sailingdates` 0.0024769306182861
(451) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518722))) 0.00063419342041016
(452) DESCRIBE `sailingdates` 0.002418041229248
(453) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518723))) 0.00061202049255371
(454) DESCRIBE `sailingdates` 0.0026731491088867
(455) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518724))) 0.00066685676574707
(456) DESCRIBE `sailingdates` 0.0021810531616211
(457) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518725))) 0.00056695938110352
(458) DESCRIBE `sailingdates` 0.002540111541748
(459) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518726))) 0.00066304206848145
(460) DESCRIBE `sailingdates` 0.0024409294128418
(461) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518727))) 0.00069713592529297
(462) DESCRIBE `sailingdates` 0.0025272369384766
(463) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518728))) 0.00077199935913086
(464) DESCRIBE `sailingdates` 0.002730131149292
(465) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518729))) 0.00069189071655273
(466) DESCRIBE `sailingdates` 0.0027201175689697
(467) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518730))) 0.00069999694824219
(468) DESCRIBE `sailingdates` 0.0028030872344971
(469) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518731))) 0.00066399574279785
(470) DESCRIBE `sailingdates` 0.0023260116577148
(471) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518732))) 0.00047111511230469
(472) DESCRIBE `sailingdates` 0.0022351741790771
(473) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518733))) 0.00044393539428711
(474) DESCRIBE `sailingdates` 0.0024900436401367
(475) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518734))) 0.00078606605529785
(476) DESCRIBE `sailingdates` 0.0021770000457764
(477) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518735))) 0.00058412551879883
(478) DESCRIBE `sailingdates` 0.002129077911377
(479) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518736))) 0.00060415267944336
(480) DESCRIBE `sailingdates` 0.0019600391387939
(481) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518737))) 0.00064992904663086
(482) DESCRIBE `ports` 0.0022039413452148
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00066113471984863
(484) DESCRIBE `ports` 0.0024240016937256
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.0005190372467041
(486) DESCRIBE `ports` 0.0019369125366211
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00061583518981934
(488) DESCRIBE `ports` 0.002453088760376
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00063514709472656
(490) DESCRIBE `ports` 0.0025870800018311
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00047111511230469
(492) DESCRIBE `ports` 0.002377986907959
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00045609474182129
(494) DESCRIBE `ports` 0.002683162689209
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00057291984558105
(496) DESCRIBE `ports` 0.0026040077209473
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00064301490783691
(498) DESCRIBE `ports` 0.0024650096893311
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00058603286743164
(500) DESCRIBE `ports` 0.0023269653320312
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00053191184997559
(502) DESCRIBE `ports` 0.0022938251495361
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00045108795166016
(504) DESCRIBE `ports` 0.0019030570983887
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00039410591125488
(506) DESCRIBE `ports` 0.0022192001342773
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00081205368041992
(508) DESCRIBE `ports` 0.0024778842926025
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00045299530029297
(510) DESCRIBE `ports` 0.0022828578948975
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00044393539428711
(512) DESCRIBE `ports` 0.0019919872283936
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00050997734069824
(514) DESCRIBE `cruises` 0.003633975982666
(515) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65943))) 0.00059795379638672
(516) DESCRIBE `avid_specials` 0.0018138885498047
(517) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541766 and class = 'Special') OR (item_id = 65943 and class = 'Cruise') OR (item_id = 520 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.0017659664154053
(518) DESCRIBE `cruiselines` 0.0028448104858398
(519) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00055408477783203
(520) DESCRIBE `orchid_image` 0.0026171207427979
(521) DESCRIBE `cruiselines` 0.0035271644592285
(522) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00055599212646484
(523) DESCRIBE `specials` 0.0066349506378174
(524) SELECT `specials`.* FROM `specials` WHERE (id = '1541775') AND (specials.orchid_available = 1) LIMIT 1 0.00075578689575195
(525) DESCRIBE `specials` 0.0076260566711426
(526) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541775') 0.00073909759521484
(527) DESCRIBE `ships` 0.0047359466552734
(528) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 520))) 0.00068306922912598
(529) DESCRIBE `ships` 0.0051910877227783
(530) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '520') 0.00070285797119141
(531) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051403045654297
(532) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00061798095703125
(533) DESCRIBE `itineraries` 0.002903938293457
(534) DESCRIBE `ports` 0.00337815284729
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0008540153503418
(536) DESCRIBE `ports` 0.0093390941619873
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00073099136352539
(538) DESCRIBE `ports` 0.0031130313873291
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00069499015808105
(540) DESCRIBE `specialsailingdates` 0.0023801326751709
(541) DESCRIBE `sailingdates` 0.0025210380554199
(542) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518664))) 0.00057196617126465
(543) DESCRIBE `sailingdates` 0.0022730827331543
(544) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518668))) 0.00053882598876953
(545) DESCRIBE `sailingdates` 0.002061128616333
(546) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518669))) 0.00054216384887695
(547) DESCRIBE `sailingdates` 0.0020999908447266
(548) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518671))) 0.00074100494384766
(549) DESCRIBE `sailingdates` 0.0023961067199707
(550) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518672))) 0.00066614151000977
(551) DESCRIBE `sailingdates` 0.0023589134216309
(552) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518673))) 0.00063300132751465
(553) DESCRIBE `sailingdates` 0.0024139881134033
(554) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518674))) 0.00063490867614746
(555) DESCRIBE `sailingdates` 0.0024600028991699
(556) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518676))) 0.00062298774719238
(557) DESCRIBE `sailingdates` 0.0029408931732178
(558) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518677))) 0.0006110668182373
(559) DESCRIBE `sailingdates` 0.0020411014556885
(560) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518678))) 0.00053501129150391
(561) DESCRIBE `sailingdates` 0.0020008087158203
(562) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518679))) 0.00058603286743164
(563) DESCRIBE `sailingdates` 0.001978874206543
(564) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518680))) 0.00046110153198242
(565) DESCRIBE `sailingdates` 0.0020289421081543
(566) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518681))) 0.00053596496582031
(567) DESCRIBE `sailingdates` 0.002047061920166
(568) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518682))) 0.00052690505981445
(569) DESCRIBE `sailingdates` 0.0020229816436768
(570) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518683))) 0.00052380561828613
(571) DESCRIBE `sailingdates` 0.0020358562469482
(572) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518686))) 0.00051689147949219
(573) DESCRIBE `sailingdates` 0.0025680065155029
(574) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518687))) 0.00070881843566895
(575) DESCRIBE `sailingdates` 0.0021791458129883
(576) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518688))) 0.00078797340393066
(577) DESCRIBE `sailingdates` 0.0032010078430176
(578) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518696))) 0.00096893310546875
(579) DESCRIBE `sailingdates` 0.0031900405883789
(580) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518697))) 0.00073695182800293
(581) DESCRIBE `sailingdates` 0.0027480125427246
(582) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518698))) 0.00067615509033203
(583) DESCRIBE `sailingdates` 0.0024080276489258
(584) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518699))) 0.00069904327392578
(585) DESCRIBE `sailingdates` 0.0023341178894043
(586) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518700))) 0.00052499771118164
(587) DESCRIBE `ports` 0.0023910999298096
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00045299530029297
(589) DESCRIBE `ports` 0.0021049976348877
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00047802925109863
(591) DESCRIBE `ports` 0.0024988651275635
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00056910514831543
(593) DESCRIBE `ports` 0.002518892288208
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00056195259094238
(595) DESCRIBE `ports` 0.0030369758605957
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0006721019744873
(597) DESCRIBE `ports` 0.0024430751800537
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00051188468933105
(599) DESCRIBE `ports` 0.0023620128631592
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00047707557678223
(601) DESCRIBE `ports` 0.0025589466094971
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.0005500316619873
(603) DESCRIBE `ports` 0.0027999877929688
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00075793266296387
(605) DESCRIBE `ports` 0.0031468868255615
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00076198577880859
(607) DESCRIBE `ports` 0.0029900074005127
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00074386596679688
(609) DESCRIBE `ports` 0.0030741691589355
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00069093704223633
(611) DESCRIBE `ports` 0.0030219554901123
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00078392028808594
(613) DESCRIBE `ports` 0.0034170150756836
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.0006248950958252
(615) DESCRIBE `ports` 0.0026659965515137
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00052881240844727
(617) DESCRIBE `ports` 0.0033349990844727
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.0007328987121582
(619) DESCRIBE `ports` 0.0028471946716309
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00070595741271973
(621) DESCRIBE `ports` 0.002683162689209
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00060391426086426
(623) DESCRIBE `ports` 0.0028131008148193
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00065708160400391
(625) DESCRIBE `ports` 0.0026180744171143
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00069904327392578
(627) DESCRIBE `ports` 0.0025918483734131
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00071883201599121
(629) DESCRIBE `ports` 0.0029458999633789
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00078296661376953
(631) DESCRIBE `ports` 0.0032930374145508
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00087809562683105
(633) DESCRIBE `ports` 0.0025761127471924
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00061988830566406
(635) DESCRIBE `ports` 0.0022878646850586
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.0006411075592041
(637) DESCRIBE `ports` 0.0024948120117188
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00064587593078613
(639) DESCRIBE `ports` 0.0034079551696777
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00078082084655762
(641) DESCRIBE `ports` 0.002791166305542
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00057792663574219
(643) DESCRIBE `ports` 0.0025770664215088
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00055193901062012
(645) DESCRIBE `ports` 0.002223014831543
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00062203407287598
(647) DESCRIBE `ports` 0.0025730133056641
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00065898895263672
(649) DESCRIBE `ports` 0.0025069713592529
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.0006411075592041
(651) DESCRIBE `ports` 0.0029430389404297
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00087094306945801
(653) DESCRIBE `ports` 0.0031609535217285
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00075602531433105
(655) DESCRIBE `ports` 0.0029089450836182
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.0009009838104248
(657) DESCRIBE `ports` 0.0032351016998291
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00091195106506348
(659) DESCRIBE `ports` 0.0028460025787354
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00069808959960938
(661) DESCRIBE `ports` 0.0051538944244385
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00072002410888672
(663) DESCRIBE `cruises` 0.0052599906921387
(664) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65945))) 0.00090408325195312
(665) DESCRIBE `avid_specials` 0.0025038719177246
(666) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541775 and class = 'Special') OR (item_id = 65945 and class = 'Cruise') OR (item_id = 520 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.0021109580993652
(667) DESCRIBE `cruiselines` 0.0039348602294922
(668) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00085783004760742
(669) DESCRIBE `orchid_image` 0.0026218891143799
(670) DESCRIBE `cruiselines` 0.0036499500274658
(671) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00056099891662598
(672) DESCRIBE `specials` 0.0068271160125732
(673) SELECT `specials`.* FROM `specials` WHERE (id = '1589174') AND (specials.orchid_available = 1) LIMIT 1 0.0011491775512695
(674) DESCRIBE `specials` 0.0081429481506348
(675) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1589174') 0.00070309638977051
(676) DESCRIBE `ships` 0.0058279037475586
(677) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.00058317184448242
(678) DESCRIBE `ships` 0.0093679428100586
(679) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.00073885917663574
(680) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052404403686523
(681) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053811073303223
(682) DESCRIBE `itineraries` 0.0028400421142578
(683) DESCRIBE `ports` 0.0024809837341309
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00066423416137695
(685) DESCRIBE `ports` 0.0028378963470459
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00069189071655273
(687) DESCRIBE `ports` 0.0027530193328857
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00064802169799805
(689) DESCRIBE `specialsailingdates` 0.0022220611572266
(690) DESCRIBE `sailingdates` 0.0026869773864746
(691) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 478581))) 0.00079798698425293
(692) DESCRIBE `ports` 0.0025100708007812
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00073099136352539
(694) DESCRIBE `ports` 0.0024740695953369
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00063586235046387
(696) DESCRIBE `ports` 0.0027639865875244
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.0006718635559082
(698) DESCRIBE `ports` 0.0027980804443359
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00059390068054199
(700) DESCRIBE `ports` 0.0025439262390137
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00053000450134277
(702) DESCRIBE `ports` 0.0024688243865967
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00053310394287109
(704) DESCRIBE `ports` 0.0037169456481934
(705) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00069785118103027
(706) DESCRIBE `ports` 0.0023331642150879
(707) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00052499771118164
(708) DESCRIBE `ports` 0.0025079250335693
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00056910514831543
(710) DESCRIBE `ports` 0.0023269653320312
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00053310394287109
(712) DESCRIBE `ports` 0.0022878646850586
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.0005791187286377
(714) DESCRIBE `ports` 0.0023798942565918
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.0005340576171875
(716) DESCRIBE `ports` 0.0026230812072754
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.0006859302520752
(718) DESCRIBE `ports` 0.0029962062835693
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00076198577880859
(720) DESCRIBE `ports` 0.0032789707183838
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00073099136352539
(722) DESCRIBE `ports` 0.0025651454925537
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00065088272094727
(724) DESCRIBE `cruises` 0.0047290325164795
(725) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 76299))) 0.00084519386291504
(726) DESCRIBE `avid_specials` 0.0026299953460693
(727) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1589174 and class = 'Special') OR (item_id = 76299 and class = 'Cruise') OR (item_id = 253 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0024039745330811
(728) DESCRIBE `cruiselines` 0.0036299228668213
(729) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0008540153503418
(730) DESCRIBE `orchid_image` 0.0028090476989746
(731) DESCRIBE `cruiselines` 0.0034761428833008
(732) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00059294700622559
(733) DESCRIBE `specials` 0.0065410137176514
(734) SELECT `specials`.* FROM `specials` WHERE (id = '1541844') AND (specials.orchid_available = 1) LIMIT 1 0.0010089874267578
(735) DESCRIBE `specials` 0.0072641372680664
(736) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541844') 0.00070905685424805
(737) DESCRIBE `ships` 0.0051178932189941
(738) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 701))) 0.00078392028808594
(739) DESCRIBE `ships` 0.0051078796386719
(740) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0.0006260871887207
(741) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047707557678223
(742) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00054383277893066
(743) DESCRIBE `itineraries` 0.0029659271240234
(744) DESCRIBE `ports` 0.0028550624847412
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00076913833618164
(746) DESCRIBE `ports` 0.00288987159729
(747) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00063204765319824
(748) DESCRIBE `ports` 0.0025758743286133
(749) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00065302848815918
(750) DESCRIBE `specialsailingdates` 0.0023789405822754
(751) DESCRIBE `sailingdates` 0.002694845199585
(752) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518782))) 0.00060296058654785
(753) DESCRIBE `sailingdates` 0.0023691654205322
(754) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518785))) 0.00094294548034668
(755) DESCRIBE `sailingdates` 0.0042190551757812
(756) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518786))) 0.0012860298156738
(757) DESCRIBE `sailingdates` 0.0082929134368896
(758) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518787))) 0.0011398792266846
(759) DESCRIBE `sailingdates` 0.0028519630432129
(760) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518788))) 0.00069379806518555
(761) DESCRIBE `sailingdates` 0.0026350021362305
(762) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518789))) 0.00068902969360352
(763) DESCRIBE `ports` 0.0029399394989014
(764) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00075387954711914
(765) DESCRIBE `ports` 0.0030930042266846
(766) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00078010559082031
(767) DESCRIBE `ports` 0.0030951499938965
(768) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00063490867614746
(769) DESCRIBE `ports` 0.0028860569000244
(770) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00068998336791992
(771) DESCRIBE `ports` 0.0026721954345703
(772) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00061511993408203
(773) DESCRIBE `ports` 0.003040075302124
(774) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00069808959960938
(775) DESCRIBE `ports` 0.0030090808868408
(776) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.0008080005645752
(777) DESCRIBE `ports` 0.0031208992004395
(778) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00069618225097656
(779) DESCRIBE `ports` 0.0028550624847412
(780) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00061607360839844
(781) DESCRIBE `ports` 0.0028140544891357
(782) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00064992904663086
(783) DESCRIBE `ports` 0.0039298534393311
(784) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00083184242248535
(785) DESCRIBE `ports` 0.0026600360870361
(786) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.003093957901001
(787) DESCRIBE `ports` 0.0061850547790527
(788) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00099897384643555
(789) DESCRIBE `ports` 0.010910987854004
(790) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00084400177001953
(791) DESCRIBE `ports` 0.002748966217041
(792) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0007779598236084
(793) DESCRIBE `ports` 0.0029840469360352
(794) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00069212913513184
(795) DESCRIBE `cruises` 0.005126953125
(796) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 49093))) 0.0010950565338135
(797) DESCRIBE `avid_specials` 0.0025851726531982
(798) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541844 and class = 'Special') OR (item_id = 49093 and class = 'Cruise') OR (item_id = 701 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.0022819042205811
(799) DESCRIBE `cruiselines` 0.0044858455657959
(800) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0006871223449707
(801) DESCRIBE `orchid_image` 0.0043220520019531
(802) DESCRIBE `cruiselines` 0.0053830146789551
(803) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00066518783569336
(804) DESCRIBE `specials` 0.0081579685211182
(805) SELECT `specials`.* FROM `specials` WHERE (id = '1607873') AND (specials.orchid_available = 1) LIMIT 1 0.0011560916900635
(806) DESCRIBE `specials` 0.0079610347747803
(807) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1607873') 0.00079917907714844
(808) DESCRIBE `ships` 0.0067589282989502
(809) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.0010139942169189
(810) DESCRIBE `ships` 0.0054929256439209
(811) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.00061702728271484
(812) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00054001808166504
(813) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00057101249694824
(814) DESCRIBE `itineraries` 0.0030531883239746
(815) DESCRIBE `ports` 0.0028760433197021
(816) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00050997734069824
(817) DESCRIBE `ports` 0.0029520988464355
(818) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00060510635375977
(819) DESCRIBE `ports` 0.0025668144226074
(820) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00065898895263672
(821) DESCRIBE `specialsailingdates` 0.0022149085998535
(822) DESCRIBE `sailingdates` 0.0036189556121826
(823) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490582))) 0.0010030269622803
(824) DESCRIBE `sailingdates` 0.0021700859069824
(825) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 490583))) 0.00055503845214844
(826) DESCRIBE `ports` 0.0032250881195068
(827) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00077295303344727
(828) DESCRIBE `ports` 0.0026848316192627
(829) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00070881843566895
(830) DESCRIBE `ports` 0.0026280879974365
(831) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00075721740722656
(832) DESCRIBE `ports` 0.0030570030212402
(833) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0007631778717041
(834) DESCRIBE `ports` 0.0030629634857178
(835) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 835))) 0.00076007843017578
(836) DESCRIBE `ports` 0.0030441284179688
(837) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '835') 0.00067305564880371
(838) DESCRIBE `ports` 0.0025339126586914
(839) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 835))) 0.00073099136352539
(840) DESCRIBE `ports` 0.0027570724487305
(841) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '835') 0.00060391426086426
(842) DESCRIBE `ports` 0.0029010772705078
(843) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 461))) 0.00074195861816406
(844) DESCRIBE `ports` 0.0027551651000977
(845) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '461') 0.00057005882263184
(846) DESCRIBE `ports` 0.002547025680542
(847) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2953))) 0.00075483322143555
(848) DESCRIBE `ports` 0.0027961730957031
(849) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2953') 0.00066494941711426
(850) DESCRIBE `ports` 0.0026118755340576
(851) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5085))) 0.00085806846618652
(852) DESCRIBE `ports` 0.0030322074890137
(853) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5085') 0.00078010559082031
(854) DESCRIBE `ports` 0.0030479431152344
(855) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 461))) 0.00084996223449707
(856) DESCRIBE `ports` 0.0027971267700195
(857) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '461') 0.00054097175598145
(858) DESCRIBE `ports` 0.0022861957550049
(859) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00063204765319824
(860) DESCRIBE `ports` 0.0024311542510986
(861) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00054788589477539
(862) DESCRIBE `ports` 0.0023479461669922
(863) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00058579444885254
(864) DESCRIBE `ports` 0.0024340152740479
(865) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00054097175598145
(866) DESCRIBE `ports` 0.0024051666259766
(867) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2954))) 0.00072193145751953
(868) DESCRIBE `ports` 0.0025539398193359
(869) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2954') 0.00054311752319336
(870) DESCRIBE `ports` 0.0025520324707031
(871) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2954))) 0.00081896781921387
(872) DESCRIBE `ports` 0.0031101703643799
(873) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2954') 0.00070405006408691
(874) DESCRIBE `ports` 0.0028808116912842
(875) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2954))) 0.00073695182800293
(876) DESCRIBE `ports` 0.002838134765625
(877) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2954') 0.00069904327392578
(878) DESCRIBE `ports` 0.0029518604278564
(879) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4301))) 0.00068998336791992
(880) DESCRIBE `ports` 0.003000020980835
(881) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4301') 0.00072503089904785
(882) DESCRIBE `ports` 0.0023279190063477
(883) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2956))) 0.00064396858215332
(884) DESCRIBE `ports` 0.003201961517334
(885) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2953))) 0.00082111358642578
(886) DESCRIBE `ports` 0.0032448768615723
(887) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2953') 0.00063800811767578
(888) DESCRIBE `ports` 0.0029959678649902
(889) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 282))) 0.00088000297546387
(890) DESCRIBE `ports` 0.0034871101379395
(891) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00094413757324219
(892) DESCRIBE `ports` 0.0036132335662842
(893) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00060606002807617
(894) DESCRIBE `cruises` 0.0076160430908203
(895) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 37235))) 0.0018880367279053
(896) DESCRIBE `avid_specials` 0.0035090446472168
(897) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1607873 and class = 'Special') OR (item_id = 37235 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022931098937988
(898) DESCRIBE `cruiselines` 0.0041141510009766
(899) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.00081205368041992
(900) DESCRIBE `orchid_image` 0.0033080577850342
(901) DESCRIBE `cruiselines` 0.0040509700775146
(902) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.0006871223449707
(903) DESCRIBE `specials` 0.0072910785675049
(904) SELECT `specials`.* FROM `specials` WHERE (id = '1610802') AND (specials.orchid_available = 1) LIMIT 1 0.0010559558868408
(905) DESCRIBE `specials` 0.0072839260101318
(906) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1610802') 0.00079011917114258
(907) DESCRIBE `ships` 0.0050249099731445
(908) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00097203254699707
(909) DESCRIBE `ships` 0.0051469802856445
(910) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00082206726074219
(911) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00042486190795898
(912) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037193298339844
(913) DESCRIBE `itineraries` 0.0021469593048096
(914) DESCRIBE `ports` 0.0023548603057861
(915) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00060796737670898
(916) DESCRIBE `ports` 0.0025601387023926
(917) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00060796737670898
(918) DESCRIBE `ports` 0.0025060176849365
(919) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00046992301940918
(920) DESCRIBE `specialsailingdates` 0.0024759769439697
(921) DESCRIBE `sailingdates` 0.0026850700378418
(922) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504422))) 0.0007779598236084
(923) DESCRIBE `sailingdates` 0.0022969245910645
(924) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504423))) 0.0006101131439209
(925) DESCRIBE `sailingdates` 0.0020949840545654
(926) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504424))) 0.00064206123352051
(927) DESCRIBE `sailingdates` 0.0021021366119385
(928) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504425))) 0.0005190372467041
(929) DESCRIBE `sailingdates` 0.0017058849334717
(930) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504426))) 0.00044798851013184
(931) DESCRIBE `sailingdates` 0.0025088787078857
(932) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504427))) 0.00071382522583008
(933) DESCRIBE `sailingdates` 0.0024199485778809
(934) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504428))) 0.0005948543548584
(935) DESCRIBE `sailingdates` 0.0026941299438477
(936) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504429))) 0.00080299377441406
(937) DESCRIBE `sailingdates` 0.0025651454925537
(938) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504430))) 0.00053811073303223
(939) DESCRIBE `sailingdates` 0.0018990039825439
(940) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504431))) 0.00058388710021973
(941) DESCRIBE `sailingdates` 0.0018939971923828
(942) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504432))) 0.00041794776916504
(943) DESCRIBE `sailingdates` 0.0020699501037598
(944) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504433))) 0.0004880428314209
(945) DESCRIBE `sailingdates` 0.0022170543670654
(946) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504434))) 0.00048112869262695
(947) DESCRIBE `sailingdates` 0.0028049945831299
(948) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504435))) 0.00073599815368652
(949) DESCRIBE `sailingdates` 0.0023961067199707
(950) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504436))) 0.00064301490783691
(951) DESCRIBE `sailingdates` 0.002140998840332
(952) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504437))) 0.00066781044006348
(953) DESCRIBE `sailingdates` 0.0027320384979248
(954) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504438))) 0.00066113471984863
(955) DESCRIBE `sailingdates` 0.0026829242706299
(956) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504439))) 0.00069403648376465
(957) DESCRIBE `sailingdates` 0.0023720264434814
(958) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504440))) 0.00068902969360352
(959) DESCRIBE `sailingdates` 0.0020389556884766
(960) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504441))) 0.00052905082702637
(961) DESCRIBE `sailingdates` 0.0020201206207275
(962) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504442))) 0.00058317184448242
(963) DESCRIBE `sailingdates` 0.0020599365234375
(964) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504443))) 0.00046992301940918
(965) DESCRIBE `sailingdates` 0.0020129680633545
(966) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504444))) 0.00066685676574707
(967) DESCRIBE `ports` 0.0024449825286865
(968) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0006248950958252
(969) DESCRIBE `ports` 0.0021378993988037
(970) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00049400329589844
(971) DESCRIBE `ports` 0.0025680065155029
(972) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.0005791187286377
(973) DESCRIBE `ports` 0.002068042755127
(974) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00047993659973145
(975) DESCRIBE `ports` 0.0024709701538086
(976) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00057387351989746
(977) DESCRIBE `ports` 0.0025711059570312
(978) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00066685676574707
(979) DESCRIBE `ports` 0.0028219223022461
(980) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00077104568481445
(981) DESCRIBE `ports` 0.0029001235961914
(982) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00066304206848145
(983) DESCRIBE `ports` 0.002687931060791
(984) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00063991546630859
(985) DESCRIBE `ports` 0.0024189949035645
(986) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.000762939453125
(987) DESCRIBE `ports` 0.0025699138641357
(988) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0006110668182373
(989) DESCRIBE `ports` 0.0022459030151367
(990) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00060415267944336
(991) DESCRIBE `ports` 0.0030438899993896
(992) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.0007481575012207
(993) DESCRIBE `ports` 0.0023808479309082
(994) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00055408477783203
(995) DESCRIBE `ports` 0.0027368068695068
(996) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0006709098815918
(997) DESCRIBE `ports` 0.0026700496673584
(998) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00062298774719238
(999) DESCRIBE `ports` 0.0029318332672119
(1000) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00072813034057617
(1001) DESCRIBE `ports` 0.0028328895568848
(1002) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00067996978759766
(1003) DESCRIBE `cruises` 0.0052978992462158
(1004) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45258))) 0.00088691711425781
(1005) DESCRIBE `avid_specials` 0.0026528835296631
(1006) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1610802 and class = 'Special') OR (item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0023188591003418
(1007) DESCRIBE `cruiselines` 0.0040440559387207
(1008) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00080299377441406
(1009) DESCRIBE `orchid_image` 0.0030379295349121
(1010) DESCRIBE `cruiselines` 0.0041868686676025
(1011) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00076603889465332
(1012) DESCRIBE `cruiselines` 0.004101037979126
(1013) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '47', '216', '23', '218', '8', '33', '26', '114', '20', '37', '151', '91', '96', '19', '101', '212', '15', '140', '180', '18', '191', '14', '29')) ORDER BY FIND_IN_SET(id, '120,47,216,23,218,8,33,26,114,20,37,151,91,96,19,101,212,15,140,180,18,191,14,29') 0.0032877922058105
(1014) DESCRIBE `ships` 0.0048692226409912
(1015) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '855', '521', '520', '627', '701', '124', '441', '163', '341', '1282', '1303', '45', '573', '616', '678', '769', '780', '1409', '683', '776', '1402', '1587', '1682', '1772', '1788', '1819', '82', '105', '287', '349', '394', '404', '407', '422', '485', '652', '966', '1013', '1021', '1073', '1262', '1284', '1321', '1330', '1491', '1526', '1672', '1678', '1711', '1746', '1766', '1791', '1808', '66', '253', '290', '325', '332', '352', '406', '420', '451', '508', '542', '585', '665', '674', '770', '795', '907', '933', '1008', '1028', '1029', '1088', '1108', '1157', '1193', '1205', '1283', '1302', '1318', '1319', '1328', '1359', '1398', '1415', '1455', '1539', '1723', '1821')) ORDER BY FIND_IN_SET(id, '517,855,521,520,627,701,124,441,163,341,1282,1303,45,573,616,678,769,780,1409,683,776,1402,1587,1682,1772,1788,1819,82,105,287,349,394,404,407,422,485,652,966,1013,1021,1073,1262,1284,1321,1330,1491,1526,1672,1678,1711,1746,1766,1791,1808,66,253,290,325,332,352,406,420,451,508,542,585,665,674,770,795,907,933,1008,1028,1029,1088,1108,1157,1193,1205,1283,1302,1318,1319,1328,1359,1398,1415,1455,1539,1723,1821') 0.017701864242554
(1016) DESCRIBE `cruisetypes` 0.002540111541748
(1017) DESCRIBE `destinations` 0.0033919811248779
(1018) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '54', '22', '50', '35', '2', '8', '12', '53', '39', '49', '26', '29', '34', '37', '7', '38', '40', '25', '45')) ORDER BY FIND_IN_SET(id, '43,54,22,50,35,2,8,12,53,39,49,26,29,34,37,7,38,40,25,45') 0.0028791427612305