or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

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

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 690

Total elapsed time: 0.4031834602356

# Query Time
(1) connect 0.00067901611328125
(2) DESCRIBE `cruises` 0.0021591186523438
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63786, 63787, 40596, 40591, 68831, 40593, 57675, 57673, 57674, 66748)) ORDER BY FIND_IN_SET(id, '63786,63787,40596,40591,68831,40593,57675,57673,57674,66748') 0.0015079975128174
(4) DESCRIBE `specials` 0.0020339488983154
(5) DESCRIBE `specials` 0.0017130374908447
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1393342') 0.00042390823364258
(7) DESCRIBE `ships` 0.0021519660949707
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00037002563476562
(9) DESCRIBE `ships` 0.0019071102142334
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00029587745666504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020599365234375
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001528263092041
(13) DESCRIBE `itineraries` 0.00077390670776367
(14) DESCRIBE `ports` 0.00088596343994141
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023818016052246
(16) DESCRIBE `ports` 0.00070309638977051
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017714500427246
(18) DESCRIBE `ports` 0.00059700012207031
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018000602722168
(20) DESCRIBE `specialsailingdates` 0.00052499771118164
(21) DESCRIBE `sailingdates` 0.00069499015808105
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 401051))) 0.00036287307739258
(23) DESCRIBE `ports` 0.00087118148803711
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025582313537598
(25) DESCRIBE `ports` 0.00069808959960938
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019001960754395
(27) DESCRIBE `ports` 0.00074601173400879
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00020909309387207
(29) DESCRIBE `ports` 0.00070309638977051
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00018596649169922
(31) DESCRIBE `ports` 0.00069904327392578
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00020885467529297
(33) DESCRIBE `ports` 0.00081706047058105
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00023102760314941
(35) DESCRIBE `ports` 0.00067901611328125
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00021004676818848
(37) DESCRIBE `ports` 0.00068497657775879
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00019001960754395
(39) DESCRIBE `ports` 0.00074005126953125
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00021195411682129
(41) DESCRIBE `ports` 0.00085711479187012
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00024294853210449
(43) DESCRIBE `ports` 0.00077986717224121
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00025296211242676
(45) DESCRIBE `ports` 0.00085783004760742
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00022602081298828
(47) DESCRIBE `ports` 0.00090384483337402
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00025796890258789
(49) DESCRIBE `ports` 0.00090217590332031
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00023007392883301
(51) DESCRIBE `ports` 0.00083804130554199
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00023484230041504
(53) DESCRIBE `ports` 0.00066995620727539
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00016689300537109
(55) DESCRIBE `ports` 0.00059199333190918
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00019192695617676
(57) DESCRIBE `ports` 0.00072598457336426
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00016880035400391
(59) DESCRIBE `ports` 0.00059199333190918
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00018596649169922
(61) DESCRIBE `ports` 0.00059199333190918
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00017404556274414
(63) DESCRIBE `ports` 0.00082182884216309
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00023698806762695
(65) DESCRIBE `ports` 0.00088596343994141
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00023412704467773
(67) DESCRIBE `ports` 0.00092291831970215
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027012825012207
(69) DESCRIBE `ports` 0.00084304809570312
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022506713867188
(71) DESCRIBE `ports` 0.0009150505065918
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024604797363281
(73) DESCRIBE `ports` 0.00082206726074219
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00025010108947754
(75) DESCRIBE `ports` 0.0011651515960693
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00030684471130371
(77) DESCRIBE `ports` 0.0010190010070801
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00024080276489258
(79) DESCRIBE `ports` 0.00090408325195312
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00026798248291016
(81) DESCRIBE `ports` 0.0008540153503418
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00021886825561523
(83) DESCRIBE `ports` 0.00075387954711914
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00020003318786621
(85) DESCRIBE `ports` 0.00059390068054199
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00016593933105469
(87) DESCRIBE `ports` 0.00060105323791504
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00018405914306641
(89) DESCRIBE `ports` 0.00063014030456543
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00023007392883301
(91) DESCRIBE `ports` 0.00070905685424805
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0001978874206543
(93) DESCRIBE `ports` 0.000762939453125
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017309188842773
(95) DESCRIBE `ports` 0.00060701370239258
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019288063049316
(97) DESCRIBE `ports` 0.00066089630126953
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016212463378906
(99) DESCRIBE `cruises` 0.0011639595031738
(100) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63786))) 0.00034499168395996
(101) DESCRIBE `avid_specials` 0.00060200691223145
(102) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1393342 and class = 'Special') OR (item_id = 63786 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00084304809570312
(103) DESCRIBE `cruiselines` 0.00097107887268066
(104) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00024890899658203
(105) DESCRIBE `orchid_image` 0.00087285041809082
(106) DESCRIBE `cruiselines` 0.00093412399291992
(107) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00023102760314941
(108) DESCRIBE `specials` 0.0016770362854004
(109) DESCRIBE `specials` 0.0016891956329346
(110) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1393320') 0.00025606155395508
(111) DESCRIBE `ships` 0.0019991397857666
(112) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00029397010803223
(113) DESCRIBE `ships` 0.0013668537139893
(114) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00023198127746582
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016403198242188
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014996528625488
(117) DESCRIBE `itineraries` 0.00068092346191406
(118) DESCRIBE `ports` 0.00067496299743652
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021505355834961
(120) DESCRIBE `ports` 0.00063204765319824
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017714500427246
(122) DESCRIBE `ports` 0.00063681602478027
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019598007202148
(124) DESCRIBE `specialsailingdates` 0.0005340576171875
(125) DESCRIBE `sailingdates` 0.00062680244445801
(126) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 401052))) 0.00028896331787109
(127) DESCRIBE `ports` 0.00098514556884766
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026106834411621
(129) DESCRIBE `ports` 0.00084590911865234
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023603439331055
(131) DESCRIBE `ports` 0.00080108642578125
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00023722648620605
(133) DESCRIBE `ports` 0.00086593627929688
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00030088424682617
(135) DESCRIBE `ports` 0.00085997581481934
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0002598762512207
(137) DESCRIBE `ports` 0.00090289115905762
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00023889541625977
(139) DESCRIBE `ports` 0.00084209442138672
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00025415420532227
(141) DESCRIBE `ports` 0.00086498260498047
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028586387634277
(143) DESCRIBE `ports` 0.00085306167602539
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00024604797363281
(145) DESCRIBE `ports` 0.00092577934265137
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00025200843811035
(147) DESCRIBE `ports` 0.00084877014160156
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00024914741516113
(149) DESCRIBE `ports` 0.00099611282348633
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00023818016052246
(151) DESCRIBE `ports` 0.000885009765625
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00024986267089844
(153) DESCRIBE `ports` 0.00089693069458008
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00025701522827148
(155) DESCRIBE `ports` 0.00099301338195801
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00028514862060547
(157) DESCRIBE `ports` 0.0010302066802979
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00028395652770996
(159) DESCRIBE `ports` 0.0009148120880127
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00029110908508301
(161) DESCRIBE `ports` 0.0010538101196289
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00026392936706543
(163) DESCRIBE `ports` 0.00097203254699707
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030207633972168
(165) DESCRIBE `ports` 0.00095796585083008
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024890899658203
(167) DESCRIBE `ports` 0.00096583366394043
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00026702880859375
(169) DESCRIBE `ports` 0.00084495544433594
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00023603439331055
(171) DESCRIBE `ports` 0.00088906288146973
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026392936706543
(173) DESCRIBE `ports` 0.00085902214050293
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022697448730469
(175) DESCRIBE `cruises` 0.0015559196472168
(176) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63787))) 0.00045895576477051
(177) DESCRIBE `avid_specials` 0.00095295906066895
(178) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1393320 and class = 'Special') OR (item_id = 63787 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016701221466064
(179) DESCRIBE `cruiselines` 0.001255989074707
(180) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00031685829162598
(181) DESCRIBE `orchid_image` 0.0010168552398682
(182) DESCRIBE `cruiselines` 0.0013251304626465
(183) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00026512145996094
(184) DESCRIBE `specials` 0.0018508434295654
(185) DESCRIBE `specials` 0.0016129016876221
(186) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396706') 0.00025606155395508
(187) DESCRIBE `ships` 0.0012350082397461
(188) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00023984909057617
(189) DESCRIBE `ships` 0.0011332035064697
(190) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00021600723266602
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001981258392334
(192) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001521110534668
(193) DESCRIBE `itineraries` 0.00061798095703125
(194) DESCRIBE `ports` 0.00060892105102539
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00022315979003906
(196) DESCRIBE `ports` 0.00059986114501953
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00017690658569336
(198) DESCRIBE `ports` 0.00060606002807617
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016903877258301
(200) DESCRIBE `specialsailingdates` 0.00051212310791016
(201) DESCRIBE `sailingdates` 0.0006258487701416
(202) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423580))) 0.00031900405883789
(203) DESCRIBE `sailingdates` 0.00054192543029785
(204) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423585))) 0.00017881393432617
(205) DESCRIBE `sailingdates` 0.00054001808166504
(206) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423586))) 0.00017380714416504
(207) DESCRIBE `ports` 0.00073099136352539
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00022506713867188
(209) DESCRIBE `ports` 0.00060105323791504
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016999244689941
(211) DESCRIBE `ports` 0.00060701370239258
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00018501281738281
(213) DESCRIBE `ports` 0.00059390068054199
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00016307830810547
(215) DESCRIBE `ports` 0.00061297416687012
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00018095970153809
(217) DESCRIBE `ports` 0.00066399574279785
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00020503997802734
(219) DESCRIBE `ports` 0.00073981285095215
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00018906593322754
(221) DESCRIBE `ports` 0.000701904296875
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00017189979553223
(223) DESCRIBE `ports` 0.00071287155151367
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00019192695617676
(225) DESCRIBE `ports` 0.00063705444335938
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00018215179443359
(227) DESCRIBE `ports` 0.00063300132751465
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00018405914306641
(229) DESCRIBE `ports` 0.00063204765319824
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00016307830810547
(231) DESCRIBE `ports` 0.00061798095703125
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017809867858887
(233) DESCRIBE `ports` 0.00065016746520996
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00016403198242188
(235) DESCRIBE `ports` 0.00065493583679199
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00018310546875
(237) DESCRIBE `ports` 0.00060701370239258
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016593933105469
(239) DESCRIBE `cruises` 0.0011820793151855
(240) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40596))) 0.00030708312988281
(241) DESCRIBE `avid_specials` 0.00065803527832031
(242) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396706 and class = 'Special') OR (item_id = 40596 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 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.0016040802001953
(243) DESCRIBE `cruiselines` 0.00097179412841797
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00020503997802734
(245) DESCRIBE `orchid_image` 0.00069785118103027
(246) DESCRIBE `cruiselines` 0.00089192390441895
(247) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00019598007202148
(248) DESCRIBE `specials` 0.0018270015716553
(249) DESCRIBE `specials` 0.002223014831543
(250) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396701') 0.0003359317779541
(251) DESCRIBE `ships` 0.0015661716461182
(252) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00030684471130371
(253) DESCRIBE `ships` 0.0014698505401611
(254) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00025796890258789
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016498565673828
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001518726348877
(257) DESCRIBE `itineraries` 0.00089693069458008
(258) DESCRIBE `ports` 0.00092506408691406
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00024580955505371
(260) DESCRIBE `ports` 0.00067806243896484
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00021696090698242
(262) DESCRIBE `ports` 0.00060701370239258
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.0001978874206543
(264) DESCRIBE `specialsailingdates` 0.00056695938110352
(265) DESCRIBE `sailingdates` 0.0005650520324707
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423482))) 0.0002138614654541
(267) DESCRIBE `sailingdates` 0.00058817863464355
(268) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463858))) 0.00026822090148926
(269) DESCRIBE `sailingdates` 0.00055813789367676
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423484))) 0.00017309188842773
(271) DESCRIBE `sailingdates` 0.00053596496582031
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423487))) 0.00017595291137695
(273) DESCRIBE `sailingdates` 0.00054383277893066
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423488))) 0.00016403198242188
(275) DESCRIBE `sailingdates` 0.00052905082702637
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463859))) 0.0001671314239502
(277) DESCRIBE `ports` 0.00072193145751953
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00020194053649902
(279) DESCRIBE `ports` 0.00061392784118652
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016498565673828
(281) DESCRIBE `ports` 0.00060701370239258
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017809867858887
(283) DESCRIBE `ports` 0.00064611434936523
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00016999244689941
(285) DESCRIBE `ports` 0.00064301490783691
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017499923706055
(287) DESCRIBE `ports` 0.00062680244445801
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00015997886657715
(289) DESCRIBE `ports` 0.00060486793518066
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00019097328186035
(291) DESCRIBE `ports` 0.00062012672424316
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00017499923706055
(293) DESCRIBE `cruises` 0.0012028217315674
(294) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40591))) 0.00034999847412109
(295) DESCRIBE `avid_specials` 0.00072717666625977
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396701 and class = 'Special') OR (item_id = 40591 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 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.0010499954223633
(297) DESCRIBE `cruiselines` 0.00097107887268066
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00020194053649902
(299) DESCRIBE `orchid_image` 0.00070595741271973
(300) DESCRIBE `cruiselines` 0.00092887878417969
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00017595291137695
(302) DESCRIBE `specials` 0.0017328262329102
(303) DESCRIBE `specials` 0.0020110607147217
(304) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1394193') 0.0002899169921875
(305) DESCRIBE `ships` 0.0012140274047852
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00022697448730469
(307) DESCRIBE `ships` 0.0011281967163086
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00016093254089355
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001678466796875
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014281272888184
(311) DESCRIBE `itineraries` 0.00063395500183105
(312) DESCRIBE `ports` 0.00061988830566406
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00019693374633789
(314) DESCRIBE `ports` 0.0006558895111084
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0002140998840332
(316) DESCRIBE `ports` 0.00060200691223145
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00016522407531738
(318) DESCRIBE `specialsailingdates` 0.00050902366638184
(319) DESCRIBE `sailingdates` 0.0005791187286377
(320) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 432462))) 0.00021600723266602
(321) DESCRIBE `sailingdates` 0.00059008598327637
(322) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 432463))) 0.00016498565673828
(323) DESCRIBE `ports` 0.0007929801940918
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00025415420532227
(325) DESCRIBE `ports` 0.00071907043457031
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00020503997802734
(327) DESCRIBE `ports` 0.0006558895111084
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0001838207244873
(329) DESCRIBE `ports` 0.00062704086303711
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00015807151794434
(331) DESCRIBE `ports` 0.0005950927734375
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00017189979553223
(333) DESCRIBE `ports` 0.00063109397888184
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0002739429473877
(335) DESCRIBE `ports` 0.00089788436889648
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00023913383483887
(337) DESCRIBE `ports` 0.00085806846618652
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00021791458129883
(339) DESCRIBE `ports` 0.00086092948913574
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00024199485778809
(341) DESCRIBE `ports` 0.00073504447937012
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00017285346984863
(343) DESCRIBE `ports` 0.00061702728271484
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00017809867858887
(345) DESCRIBE `ports` 0.00059318542480469
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00016283988952637
(347) DESCRIBE `ports` 0.00059604644775391
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00018000602722168
(349) DESCRIBE `ports` 0.00058507919311523
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00016093254089355
(351) DESCRIBE `ports` 0.00059294700622559
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00022387504577637
(353) DESCRIBE `ports` 0.00060510635375977
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00016403198242188
(355) DESCRIBE `ports` 0.00061297416687012
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00018000602722168
(357) DESCRIBE `ports` 0.00063705444335938
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00019598007202148
(359) DESCRIBE `cruises` 0.0011601448059082
(360) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68831))) 0.00035381317138672
(361) DESCRIBE `avid_specials` 0.00060701370239258
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1394193 and class = 'Special') OR (item_id = 68831 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.00088000297546387
(363) DESCRIBE `cruiselines` 0.00095796585083008
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00020503997802734
(365) DESCRIBE `orchid_image` 0.00068020820617676
(366) DESCRIBE `cruiselines` 0.00082993507385254
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00023412704467773
(368) DESCRIBE `specials` 0.0017499923706055
(369) DESCRIBE `specials` 0.0016868114471436
(370) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396711') 0.00025391578674316
(371) DESCRIBE `ships` 0.0011730194091797
(372) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00023913383483887
(373) DESCRIBE `ships` 0.0012001991271973
(374) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00021505355834961
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020790100097656
(376) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018310546875
(377) DESCRIBE `itineraries` 0.00091290473937988
(378) DESCRIBE `ports` 0.00085711479187012
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00026893615722656
(380) DESCRIBE `ports` 0.00091385841369629
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00023508071899414
(382) DESCRIBE `ports` 0.00081896781921387
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00020885467529297
(384) DESCRIBE `specialsailingdates` 0.00072002410888672
(385) DESCRIBE `sailingdates` 0.00072383880615234
(386) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423520))) 0.00025296211242676
(387) DESCRIBE `sailingdates` 0.00073885917663574
(388) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423522))) 0.00020694732666016
(389) DESCRIBE `sailingdates` 0.00070405006408691
(390) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423523))) 0.00022578239440918
(391) DESCRIBE `sailingdates` 0.00074982643127441
(392) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423524))) 0.00021100044250488
(393) DESCRIBE `sailingdates` 0.00070905685424805
(394) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423526))) 0.00021195411682129
(395) DESCRIBE `sailingdates` 0.00071501731872559
(396) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423527))) 0.00022006034851074
(397) DESCRIBE `ports` 0.00086212158203125
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00025701522827148
(399) DESCRIBE `ports` 0.00084400177001953
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00021100044250488
(401) DESCRIBE `ports` 0.00079178810119629
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00024604797363281
(403) DESCRIBE `ports` 0.00083303451538086
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00021100044250488
(405) DESCRIBE `ports` 0.00078701972961426
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00023198127746582
(407) DESCRIBE `ports` 0.00080084800720215
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00020813941955566
(409) DESCRIBE `ports` 0.0008080005645752
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00023293495178223
(411) DESCRIBE `ports` 0.00082898139953613
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00023198127746582
(413) DESCRIBE `ports` 0.00078701972961426
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00024700164794922
(415) DESCRIBE `ports` 0.00087594985961914
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00037097930908203
(417) DESCRIBE `cruises` 0.0019268989562988
(418) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40593))) 0.00038790702819824
(419) DESCRIBE `avid_specials` 0.00087785720825195
(420) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396711 and class = 'Special') OR (item_id = 40593 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 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.0015499591827393
(421) DESCRIBE `cruiselines` 0.0010769367218018
(422) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00029492378234863
(423) DESCRIBE `orchid_image` 0.0010509490966797
(424) DESCRIBE `cruiselines` 0.0012798309326172
(425) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00025296211242676
(426) DESCRIBE `specials` 0.0020670890808105
(427) DESCRIBE `specials` 0.0016629695892334
(428) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396515') 0.00029516220092773
(429) DESCRIBE `ships` 0.0018320083618164
(430) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00054311752319336
(431) DESCRIBE `ships` 0.001338005065918
(432) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00019311904907227
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001671314239502
(434) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014996528625488
(435) DESCRIBE `itineraries` 0.00064206123352051
(436) DESCRIBE `ports` 0.00063109397888184
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00021696090698242
(438) DESCRIBE `ports` 0.00060415267944336
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018191337585449
(440) DESCRIBE `ports` 0.00060105323791504
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017380714416504
(442) DESCRIBE `specialsailingdates` 0.00050592422485352
(443) DESCRIBE `sailingdates` 0.00056195259094238
(444) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423707))) 0.00032496452331543
(445) DESCRIBE `sailingdates` 0.00054216384887695
(446) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423708))) 0.00017094612121582
(447) DESCRIBE `sailingdates` 0.0005490779876709
(448) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423709))) 0.00017404556274414
(449) DESCRIBE `ports` 0.00062799453735352
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019598007202148
(451) DESCRIBE `ports` 0.00059604644775391
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017619132995605
(453) DESCRIBE `ports` 0.00059103965759277
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00018000602722168
(455) DESCRIBE `ports` 0.00059700012207031
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00017094612121582
(457) DESCRIBE `ports` 0.00061297416687012
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00017905235290527
(459) DESCRIBE `ports` 0.00058698654174805
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00016117095947266
(461) DESCRIBE `ports` 0.00058507919311523
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.0002140998840332
(463) DESCRIBE `ports` 0.0005950927734375
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00016617774963379
(465) DESCRIBE `ports` 0.00059199333190918
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00019001960754395
(467) DESCRIBE `ports` 0.00060081481933594
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00019311904907227
(469) DESCRIBE `ports` 0.00060486793518066
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019097328186035
(471) DESCRIBE `ports` 0.0006101131439209
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017881393432617
(473) DESCRIBE `cruises` 0.0012378692626953
(474) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57675))) 0.00029706954956055
(475) DESCRIBE `avid_specials` 0.00074601173400879
(476) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396515 and class = 'Special') OR (item_id = 57675 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.0010948181152344
(477) DESCRIBE `cruiselines` 0.0009160041809082
(478) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00022101402282715
(479) DESCRIBE `orchid_image` 0.00071501731872559
(480) DESCRIBE `cruiselines` 0.00090408325195312
(481) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00020384788513184
(482) DESCRIBE `specials` 0.0019259452819824
(483) DESCRIBE `specials` 0.0018420219421387
(484) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396505') 0.00029301643371582
(485) DESCRIBE `ships` 0.0012340545654297
(486) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00027322769165039
(487) DESCRIBE `ships` 0.0012331008911133
(488) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00020003318786621
(489) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016212463378906
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014996528625488
(491) DESCRIBE `itineraries` 0.00062990188598633
(492) DESCRIBE `ports` 0.00064802169799805
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00021696090698242
(494) DESCRIBE `ports` 0.00061798095703125
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00024890899658203
(496) DESCRIBE `ports` 0.00067901611328125
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018477439880371
(498) DESCRIBE `specialsailingdates` 0.00052404403686523
(499) DESCRIBE `sailingdates` 0.0005640983581543
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423855))) 0.00026583671569824
(501) DESCRIBE `sailingdates` 0.00070595741271973
(502) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423857))) 0.00018000602722168
(503) DESCRIBE `sailingdates` 0.00060510635375977
(504) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423858))) 0.0001838207244873
(505) DESCRIBE `ports` 0.0006561279296875
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0002739429473877
(507) DESCRIBE `ports` 0.0012009143829346
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00027108192443848
(509) DESCRIBE `ports` 0.00088310241699219
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00025296211242676
(511) DESCRIBE `ports` 0.00090384483337402
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0002448558807373
(513) DESCRIBE `ports` 0.00093603134155273
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00020503997802734
(515) DESCRIBE `ports` 0.00061821937561035
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00016903877258301
(517) DESCRIBE `ports` 0.00061511993408203
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00018596649169922
(519) DESCRIBE `ports` 0.00060009956359863
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00016093254089355
(521) DESCRIBE `ports` 0.00059795379638672
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00023794174194336
(523) DESCRIBE `ports` 0.00088620185852051
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00022506713867188
(525) DESCRIBE `ports` 0.00089216232299805
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00027012825012207
(527) DESCRIBE `ports` 0.00092983245849609
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00024986267089844
(529) DESCRIBE `ports` 0.00092792510986328
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00025701522827148
(531) DESCRIBE `ports` 0.0006260871887207
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00016617774963379
(533) DESCRIBE `ports` 0.00060892105102539
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00017786026000977
(535) DESCRIBE `ports` 0.00060105323791504
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00016593933105469
(537) DESCRIBE `ports` 0.00061297416687012
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00022101402282715
(539) DESCRIBE `ports` 0.00087690353393555
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00022792816162109
(541) DESCRIBE `ports` 0.00087308883666992
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.0002598762512207
(543) DESCRIBE `ports` 0.00088787078857422
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00021100044250488
(545) DESCRIBE `ports` 0.00085806846618652
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00024199485778809
(547) DESCRIBE `ports` 0.00085806846618652
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00015997886657715
(549) DESCRIBE `ports` 0.00066208839416504
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00018978118896484
(551) DESCRIBE `ports` 0.00060105323791504
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00016307830810547
(553) DESCRIBE `cruises` 0.001168966293335
(554) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57673))) 0.0003960132598877
(555) DESCRIBE `avid_specials` 0.00083017349243164
(556) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396505 and class = 'Special') OR (item_id = 57673 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.0015020370483398
(557) DESCRIBE `cruiselines` 0.0013179779052734
(558) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.0002739429473877
(559) DESCRIBE `orchid_image` 0.00099492073059082
(560) DESCRIBE `cruiselines` 0.00088095664978027
(561) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00017690658569336
(562) DESCRIBE `specials` 0.0016489028930664
(563) DESCRIBE `specials` 0.0024850368499756
(564) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1396495') 0.0003209114074707
(565) DESCRIBE `ships` 0.0018141269683838
(566) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00029611587524414
(567) DESCRIBE `ships` 0.0012609958648682
(568) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00036406517028809
(569) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018882751464844
(570) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(571) DESCRIBE `itineraries` 0.00076007843017578
(572) DESCRIBE `ports` 0.00081086158752441
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0002439022064209
(574) DESCRIBE `ports` 0.00063204765319824
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019311904907227
(576) DESCRIBE `ports` 0.00066709518432617
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00019693374633789
(578) DESCRIBE `specialsailingdates` 0.00054311752319336
(579) DESCRIBE `sailingdates` 0.00055193901062012
(580) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423781))) 0.00024700164794922
(581) DESCRIBE `sailingdates` 0.00056290626525879
(582) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423783))) 0.00019693374633789
(583) DESCRIBE `sailingdates` 0.00055694580078125
(584) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423784))) 0.00018596649169922
(585) DESCRIBE `ports` 0.0006871223449707
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00021004676818848
(587) DESCRIBE `ports` 0.00070691108703613
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00021004676818848
(589) DESCRIBE `ports` 0.00061583518981934
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00019097328186035
(591) DESCRIBE `ports` 0.00062990188598633
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00016903877258301
(593) DESCRIBE `ports` 0.00062108039855957
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00019502639770508
(595) DESCRIBE `ports` 0.00062012672424316
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00017404556274414
(597) DESCRIBE `ports` 0.0006110668182373
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00022196769714355
(599) DESCRIBE `ports` 0.00064396858215332
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00017404556274414
(601) DESCRIBE `ports` 0.00059700012207031
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00018882751464844
(603) DESCRIBE `ports` 0.00064992904663086
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00017905235290527
(605) DESCRIBE `ports` 0.00063300132751465
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019598007202148
(607) DESCRIBE `ports` 0.00065517425537109
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018000602722168
(609) DESCRIBE `cruises` 0.0012650489807129
(610) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57674))) 0.00029110908508301
(611) DESCRIBE `avid_specials` 0.00061798095703125
(612) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1396495 and class = 'Special') OR (item_id = 57674 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.00097513198852539
(613) DESCRIBE `cruiselines` 0.00096607208251953
(614) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00023579597473145
(615) DESCRIBE `orchid_image` 0.00069808959960938
(616) DESCRIBE `cruiselines` 0.00095105171203613
(617) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00022602081298828
(618) DESCRIBE `specials` 0.0024340152740479
(619) DESCRIBE `specials` 0.0021529197692871
(620) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1394201') 0.00031399726867676
(621) DESCRIBE `ships` 0.0014572143554688
(622) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00028300285339355
(623) DESCRIBE `ships` 0.0012309551239014
(624) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00023603439331055
(625) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(626) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001521110534668
(627) DESCRIBE `itineraries` 0.00074005126953125
(628) DESCRIBE `ports` 0.00080609321594238
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00028800964355469
(630) DESCRIBE `ports` 0.00084280967712402
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00023698806762695
(632) DESCRIBE `ports` 0.0007328987121582
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00022101402282715
(634) DESCRIBE `specialsailingdates` 0.00063800811767578
(635) DESCRIBE `sailingdates` 0.00066518783569336
(636) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 457860))) 0.00024104118347168
(637) DESCRIBE `sailingdates` 0.00060009956359863
(638) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 432259))) 0.00029897689819336
(639) DESCRIBE `ports` 0.00072002410888672
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020599365234375
(641) DESCRIBE `ports` 0.00066995620727539
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00017786026000977
(643) DESCRIBE `ports` 0.00072193145751953
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00024008750915527
(645) DESCRIBE `ports` 0.00078082084655762
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00020599365234375
(647) DESCRIBE `ports` 0.00063705444335938
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00022101402282715
(649) DESCRIBE `ports` 0.0006859302520752
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00022602081298828
(651) DESCRIBE `ports` 0.0006718635559082
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0001990795135498
(653) DESCRIBE `ports` 0.00072908401489258
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00017285346984863
(655) DESCRIBE `ports` 0.00065708160400391
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00020909309387207
(657) DESCRIBE `ports` 0.00079798698425293
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00025010108947754
(659) DESCRIBE `ports` 0.00094699859619141
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00028586387634277
(661) DESCRIBE `ports` 0.00098586082458496
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00027084350585938
(663) DESCRIBE `ports` 0.00093293190002441
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00030517578125
(665) DESCRIBE `ports` 0.001021146774292
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00028514862060547
(667) DESCRIBE `ports` 0.00099015235900879
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00027585029602051
(669) DESCRIBE `ports` 0.00092101097106934
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00022411346435547
(671) DESCRIBE `ports` 0.00094199180603027
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00027799606323242
(673) DESCRIBE `ports` 0.00092887878417969
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00024104118347168
(675) DESCRIBE `cruises` 0.0018308162689209
(676) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66748))) 0.00052690505981445
(677) DESCRIBE `avid_specials` 0.0010290145874023
(678) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1394201 and class = 'Special') OR (item_id = 66748 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0013830661773682
(679) DESCRIBE `cruiselines` 0.0013678073883057
(680) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00030994415283203
(681) DESCRIBE `orchid_image` 0.0010371208190918
(682) DESCRIBE `cruiselines` 0.0011200904846191
(683) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0002131462097168
(684) DESCRIBE `cruiselines` 0.0011529922485352
(685) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('213', '191', '23', '33', '18', '26', '114', '15', '212', '216', '8', '101', '151', '91', '218', '28', '37', '14', '20', '29', '19', '24', '187', '258')) ORDER BY FIND_IN_SET(id, '213,191,23,33,18,26,114,15,212,216,8,101,151,91,218,28,37,14,20,29,19,24,187,258') 0.00095510482788086
(686) DESCRIBE `ships` 0.0015058517456055
(687) SELECT `ships`.* FROM `ships` WHERE (id IN ('1205', '1347', '1032', '1023', '163', '547', '1266', '1385', '1539', '855', '78', '780', '262', '451', '1013', '1282', '1526', '1579', '542', '616', '1154', '1672', '75', '82', '98', '258', '287', '290', '332', '341', '406', '580', '585', '678', '683', '790', '850', '968', '1022', '1029', '1135', '1402', '43', '74', '84', '105', '111', '223', '253', '286', '291', '335', '348', '349', '352', '389', '403', '404', '508', '573', '582', '652', '657', '711', '722', '748', '770', '776', '884', '888', '966', '1108', '1163', '1189', '1223', '1285', '1302', '1308', '1319', '1320', '1323', '1325', '1409', '1413', '1571')) ORDER BY FIND_IN_SET(id, '1205,1347,1032,1023,163,547,1266,1385,1539,855,78,780,262,451,1013,1282,1526,1579,542,616,1154,1672,75,82,98,258,287,290,332,341,406,580,585,678,683,790,850,968,1022,1029,1135,1402,43,74,84,105,111,223,253,286,291,335,348,349,352,389,403,404,508,573,582,652,657,711,722,748,770,776,884,888,966,1108,1163,1189,1223,1285,1302,1308,1319,1320,1323,1325,1409,1413,1571') 0.0029480457305908
(688) DESCRIBE `cruisetypes` 0.0009009838104248
(689) DESCRIBE `destinations` 0.00083708763122559
(690) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '43', '22', '54', '55', '8', '35', '12', '39', '50', '11', '21', '26', '40', '48', '25', '37', '49', '29', '53')) ORDER BY FIND_IN_SET(id, '2,43,22,54,55,8,35,12,39,50,11,21,26,40,48,25,37,49,29,53') 0.00082302093505859