or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  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: 710

Total elapsed time: 0.40035438537598

# Query Time
(1) connect 0.00051689147949219
(2) DESCRIBE `cruises` 0.0021309852600098
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (64887, 64886, 69937, 64445, 69923, 65069, 65067, 66954, 65047, 64895)) ORDER BY FIND_IN_SET(id, '64887,64886,69937,64445,69923,65069,65067,66954,65047,64895') 0.0014798641204834
(4) DESCRIBE `cruises` 0.0021469593048096
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64887') 0.00032496452331543
(6) DESCRIBE `ships` 0.0020208358764648
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00035405158996582
(8) DESCRIBE `ships` 0.0017819404602051
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00026392936706543
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018501281738281
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018000602722168
(12) DESCRIBE `itineraries` 0.00094103813171387
(13) DESCRIBE `ports` 0.0011551380157471
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030207633972168
(15) DESCRIBE `ports` 0.00089907646179199
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024795532226562
(17) DESCRIBE `ports` 0.00090813636779785
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024795532226562
(19) DESCRIBE `sailingdates` 0.00084710121154785
(20) DESCRIBE `ports` 0.0010411739349365
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00029897689819336
(22) DESCRIBE `ports` 0.0009150505065918
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023102760314941
(24) DESCRIBE `ports` 0.00087714195251465
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00025296211242676
(26) DESCRIBE `ports` 0.0008690357208252
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00022196769714355
(28) DESCRIBE `ports` 0.00085806846618652
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00024914741516113
(30) DESCRIBE `ports` 0.00087690353393555
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00021195411682129
(32) DESCRIBE `ports` 0.00085902214050293
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00024199485778809
(34) DESCRIBE `ports` 0.00089883804321289
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00021100044250488
(36) DESCRIBE `ports` 0.00088596343994141
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00026702880859375
(38) DESCRIBE `ports` 0.0012431144714355
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00027585029602051
(40) DESCRIBE `ports` 0.00087213516235352
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020194053649902
(42) DESCRIBE `ports` 0.00060701370239258
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017094612121582
(44) DESCRIBE `ports` 0.00066280364990234
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00018310546875
(46) DESCRIBE `ports` 0.00059008598327637
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00016617774963379
(48) DESCRIBE `ports` 0.00060200691223145
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00018310546875
(50) DESCRIBE `ports` 0.00058794021606445
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00016212463378906
(52) DESCRIBE `ports` 0.00057601928710938
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00017786026000977
(54) DESCRIBE `ports` 0.00060796737670898
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00016212463378906
(56) DESCRIBE `ports` 0.00058293342590332
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00018095970153809
(58) DESCRIBE `ports` 0.00058197975158691
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00016093254089355
(60) DESCRIBE `ports` 0.00060296058654785
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018095970153809
(62) DESCRIBE `ports` 0.00058913230895996
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016283988952637
(64) DESCRIBE `avid_specials` 0.00059604644775391
(65) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64887 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010490417480469
(66) DESCRIBE `cruiselines` 0.00098609924316406
(67) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021505355834961
(68) DESCRIBE `orchid_image` 0.00069785118103027
(69) DESCRIBE `cruiselines` 0.00084400177001953
(70) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020313262939453
(71) DESCRIBE `cruises` 0.0016589164733887
(72) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64886') 0.0002741813659668
(73) DESCRIBE `ships` 0.0014238357543945
(74) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00024008750915527
(75) DESCRIBE `ships` 0.0012321472167969
(76) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00017499923706055
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020194053649902
(78) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001518726348877
(79) DESCRIBE `itineraries` 0.00071001052856445
(80) DESCRIBE `ports` 0.00062990188598633
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020813941955566
(82) DESCRIBE `ports` 0.00062298774719238
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00017905235290527
(84) DESCRIBE `ports` 0.00058984756469727
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0001680850982666
(86) DESCRIBE `sailingdates` 0.00052499771118164
(87) DESCRIBE `ports` 0.00069904327392578
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019288063049316
(89) DESCRIBE `ports` 0.00065112113952637
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016999244689941
(91) DESCRIBE `ports` 0.00072884559631348
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0002281665802002
(93) DESCRIBE `ports` 0.00058317184448242
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00017714500427246
(95) DESCRIBE `ports` 0.00063180923461914
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00019097328186035
(97) DESCRIBE `ports` 0.00058698654174805
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00016403198242188
(99) DESCRIBE `ports` 0.00069808959960938
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00019502639770508
(101) DESCRIBE `ports` 0.00060391426086426
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00016307830810547
(103) DESCRIBE `ports` 0.00058197975158691
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00020194053649902
(105) DESCRIBE `ports` 0.00058078765869141
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.0001671314239502
(107) DESCRIBE `ports` 0.00058102607727051
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018882751464844
(109) DESCRIBE `ports` 0.00061917304992676
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016403198242188
(111) DESCRIBE `avid_specials` 0.00052905082702637
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64886 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013110637664795
(113) DESCRIBE `cruiselines` 0.0012691020965576
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00026798248291016
(115) DESCRIBE `orchid_image` 0.0012829303741455
(116) DESCRIBE `cruiselines` 0.0014939308166504
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00025296211242676
(118) DESCRIBE `cruises` 0.0017809867858887
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69937') 0.00029206275939941
(120) DESCRIBE `ships` 0.0017931461334229
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00034689903259277
(122) DESCRIBE `ships` 0.0019509792327881
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00027799606323242
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020384788513184
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019383430480957
(126) DESCRIBE `itineraries` 0.00087285041809082
(127) DESCRIBE `ports` 0.00092697143554688
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026607513427734
(129) DESCRIBE `ports` 0.00084114074707031
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024318695068359
(131) DESCRIBE `ports` 0.00090289115905762
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022602081298828
(133) DESCRIBE `sailingdates` 0.00075197219848633
(134) DESCRIBE `ports` 0.00093817710876465
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026917457580566
(136) DESCRIBE `ports` 0.00086092948913574
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023984909057617
(138) DESCRIBE `ports` 0.0010530948638916
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00023603439331055
(140) DESCRIBE `ports` 0.00065088272094727
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00017094612121582
(142) DESCRIBE `ports` 0.00062704086303711
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00020885467529297
(144) DESCRIBE `ports` 0.0018749237060547
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00020980834960938
(146) DESCRIBE `ports` 0.00068283081054688
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00021505355834961
(148) DESCRIBE `ports` 0.00059008598327637
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00016903877258301
(150) DESCRIBE `ports` 0.00060796737670898
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00018095970153809
(152) DESCRIBE `ports` 0.00060296058654785
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00019288063049316
(154) DESCRIBE `ports` 0.00067305564880371
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00020194053649902
(156) DESCRIBE `ports` 0.00065302848815918
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00016593933105469
(158) DESCRIBE `ports` 0.00058698654174805
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018692016601562
(160) DESCRIBE `ports` 0.00061798095703125
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016903877258301
(162) DESCRIBE `ports` 0.00060200691223145
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00020790100097656
(164) DESCRIBE `ports` 0.00062799453735352
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00017499923706055
(166) DESCRIBE `ports` 0.00062108039855957
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0001828670501709
(168) DESCRIBE `ports` 0.0007631778717041
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00016903877258301
(170) DESCRIBE `ports` 0.00065898895263672
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00020885467529297
(172) DESCRIBE `ports` 0.00059700012207031
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00016403198242188
(174) DESCRIBE `ports` 0.00061917304992676
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00018501281738281
(176) DESCRIBE `ports` 0.00060486793518066
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00016283988952637
(178) DESCRIBE `ports` 0.00057506561279297
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022101402282715
(180) DESCRIBE `ports` 0.00060606002807617
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019097328186035
(182) DESCRIBE `avid_specials` 0.00055098533630371
(183) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69937 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.000885009765625
(184) DESCRIBE `cruiselines` 0.0009150505065918
(185) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00020885467529297
(186) DESCRIBE `orchid_image` 0.00068306922912598
(187) DESCRIBE `cruiselines` 0.00096297264099121
(188) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00019097328186035
(189) DESCRIBE `cruises` 0.0014071464538574
(190) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64445') 0.00026988983154297
(191) DESCRIBE `ships` 0.0013689994812012
(192) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1302))) 0.00025582313537598
(193) DESCRIBE `ships` 0.0012860298156738
(194) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1302') 0.00022196769714355
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00015902519226074
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00014901161193848
(197) DESCRIBE `itineraries` 0.00067400932312012
(198) DESCRIBE `ports` 0.00077605247497559
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023198127746582
(200) DESCRIBE `ports` 0.00059294700622559
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00017905235290527
(202) DESCRIBE `ports` 0.00063490867614746
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017285346984863
(204) DESCRIBE `sailingdates` 0.00055193901062012
(205) DESCRIBE `ports` 0.00061511993408203
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019693374633789
(207) DESCRIBE `ports` 0.00060200691223145
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016999244689941
(209) DESCRIBE `ports` 0.00061702728271484
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00019216537475586
(211) DESCRIBE `ports` 0.00059103965759277
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00016498565673828
(213) DESCRIBE `ports` 0.00058794021606445
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00018787384033203
(215) DESCRIBE `ports` 0.00069308280944824
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0001680850982666
(217) DESCRIBE `ports` 0.00058698654174805
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00021004676818848
(219) DESCRIBE `ports` 0.00066113471984863
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00017189979553223
(221) DESCRIBE `ports` 0.00063896179199219
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00019311904907227
(223) DESCRIBE `ports` 0.00065207481384277
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00018692016601562
(225) DESCRIBE `ports` 0.00063800811767578
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00019693374633789
(227) DESCRIBE `ports` 0.00059413909912109
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00016999244689941
(229) DESCRIBE `ports` 0.00059890747070312
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00020003318786621
(231) DESCRIBE `ports` 0.00066089630126953
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00017595291137695
(233) DESCRIBE `ports` 0.00059318542480469
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4467))) 0.00021600723266602
(235) DESCRIBE `ports` 0.00061202049255371
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4467') 0.00017595291137695
(237) DESCRIBE `ports` 0.00065302848815918
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00021696090698242
(239) DESCRIBE `ports` 0.00060105323791504
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00017905235290527
(241) DESCRIBE `ports` 0.00063490867614746
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019192695617676
(243) DESCRIBE `ports` 0.00066709518432617
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00016999244689941
(245) DESCRIBE `avid_specials` 0.00053811073303223
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64445 and class = 'Cruise') OR (item_id = 1302 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00086498260498047
(247) DESCRIBE `cruiselines` 0.0009770393371582
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021815299987793
(249) DESCRIBE `orchid_image` 0.00069713592529297
(250) DESCRIBE `cruiselines` 0.00086283683776855
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00028681755065918
(252) DESCRIBE `cruises` 0.0013089179992676
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69923') 0.00023388862609863
(254) DESCRIBE `ships` 0.0012819766998291
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00027084350585938
(256) DESCRIBE `ships` 0.0018281936645508
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00028514862060547
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017380714416504
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016999244689941
(260) DESCRIBE `itineraries` 0.00084209442138672
(261) DESCRIBE `ports` 0.00076580047607422
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022411346435547
(263) DESCRIBE `ports` 0.00059795379638672
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022006034851074
(265) DESCRIBE `ports` 0.00067710876464844
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021195411682129
(267) DESCRIBE `sailingdates` 0.00054788589477539
(268) DESCRIBE `ports` 0.0006251335144043
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002288818359375
(270) DESCRIBE `ports` 0.00063514709472656
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021696090698242
(272) DESCRIBE `ports` 0.00069189071655273
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.0001990795135498
(274) DESCRIBE `ports` 0.00070405006408691
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.0001988410949707
(276) DESCRIBE `ports` 0.00068879127502441
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00020384788513184
(278) DESCRIBE `ports` 0.00067782402038574
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00018811225891113
(280) DESCRIBE `ports` 0.00070595741271973
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00022697448730469
(282) DESCRIBE `ports` 0.00072216987609863
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00021004676818848
(284) DESCRIBE `ports` 0.00069904327392578
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00024509429931641
(286) DESCRIBE `ports` 0.00067996978759766
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018215179443359
(288) DESCRIBE `ports` 0.00068998336791992
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00021100044250488
(290) DESCRIBE `ports` 0.00061988830566406
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018787384033203
(292) DESCRIBE `ports` 0.0006251335144043
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018811225891113
(294) DESCRIBE `ports` 0.00059795379638672
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0001678466796875
(296) DESCRIBE `avid_specials` 0.00069117546081543
(297) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69923 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00089907646179199
(298) DESCRIBE `cruiselines` 0.00090694427490234
(299) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021100044250488
(300) DESCRIBE `orchid_image` 0.00075078010559082
(301) DESCRIBE `cruiselines` 0.00095701217651367
(302) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00020194053649902
(303) DESCRIBE `cruises` 0.0012390613555908
(304) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65069') 0.00023293495178223
(305) DESCRIBE `ships` 0.0012938976287842
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.0002601146697998
(307) DESCRIBE `ships` 0.001291036605835
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00021100044250488
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016093254089355
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014996528625488
(311) DESCRIBE `itineraries` 0.00065708160400391
(312) DESCRIBE `ports` 0.00070095062255859
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022482872009277
(314) DESCRIBE `ports` 0.00062704086303711
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0001838207244873
(316) DESCRIBE `ports` 0.00059294700622559
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017786026000977
(318) DESCRIBE `sailingdates` 0.00054693222045898
(319) DESCRIBE `ports` 0.0006561279296875
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021696090698242
(321) DESCRIBE `ports` 0.00059914588928223
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0001978874206543
(323) DESCRIBE `ports` 0.00059795379638672
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00023388862609863
(325) DESCRIBE `ports` 0.00070309638977051
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00019097328186035
(327) DESCRIBE `ports` 0.00070691108703613
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00018715858459473
(329) DESCRIBE `ports` 0.00063300132751465
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00020313262939453
(331) DESCRIBE `ports` 0.00059413909912109
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00018596649169922
(333) DESCRIBE `ports` 0.00059604644775391
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00016903877258301
(335) DESCRIBE `ports` 0.00058603286743164
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00019001960754395
(337) DESCRIBE `ports` 0.00062108039855957
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00017690658569336
(339) DESCRIBE `ports` 0.00067996978759766
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027608871459961
(341) DESCRIBE `ports` 0.0007929801940918
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022411346435547
(343) DESCRIBE `ports` 0.00069308280944824
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00020003318786621
(345) DESCRIBE `ports` 0.00067901611328125
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00016903877258301
(347) DESCRIBE `ports` 0.00060200691223145
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0001990795135498
(349) DESCRIBE `ports` 0.00060510635375977
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00017309188842773
(351) DESCRIBE `ports` 0.00059390068054199
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00018310546875
(353) DESCRIBE `ports` 0.00060892105102539
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00017309188842773
(355) DESCRIBE `ports` 0.00059700012207031
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00019001960754395
(357) DESCRIBE `ports` 0.00059390068054199
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00020098686218262
(359) DESCRIBE `ports` 0.00061607360839844
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019598007202148
(361) DESCRIBE `ports` 0.00060701370239258
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017404556274414
(363) DESCRIBE `ports` 0.00063014030456543
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00018692016601562
(365) DESCRIBE `ports` 0.00070095062255859
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00037813186645508
(367) DESCRIBE `ports` 0.0010819435119629
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00026702880859375
(369) DESCRIBE `ports` 0.00086593627929688
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.0002591609954834
(371) DESCRIBE `ports` 0.00089597702026367
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00030398368835449
(373) DESCRIBE `ports` 0.00097990036010742
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00025010108947754
(375) DESCRIBE `ports` 0.00085091590881348
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00024890899658203
(377) DESCRIBE `ports` 0.00084114074707031
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.0002281665802002
(379) DESCRIBE `ports` 0.00091004371643066
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023102760314941
(381) DESCRIBE `ports` 0.00085091590881348
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021195411682129
(383) DESCRIBE `avid_specials` 0.00082707405090332
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65069 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015659332275391
(385) DESCRIBE `cruiselines` 0.0014638900756836
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00033092498779297
(387) DESCRIBE `orchid_image` 0.0011031627655029
(388) DESCRIBE `cruiselines` 0.0012879371643066
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00028300285339355
(390) DESCRIBE `cruises` 0.0017321109771729
(391) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65067') 0.00026988983154297
(392) DESCRIBE `ships` 0.0017049312591553
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00036907196044922
(394) DESCRIBE `ships` 0.0018000602722168
(395) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00025081634521484
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019192695617676
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019502639770508
(398) DESCRIBE `itineraries` 0.00085210800170898
(399) DESCRIBE `ports` 0.00088620185852051
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003058910369873
(401) DESCRIBE `ports` 0.00086188316345215
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002591609954834
(403) DESCRIBE `ports` 0.0008690357208252
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023388862609863
(405) DESCRIBE `sailingdates` 0.00070381164550781
(406) DESCRIBE `ports` 0.00088906288146973
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026702880859375
(408) DESCRIBE `ports` 0.0007929801940918
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002140998840332
(410) DESCRIBE `ports` 0.00078010559082031
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00023889541625977
(412) DESCRIBE `ports` 0.00083589553833008
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00021886825561523
(414) DESCRIBE `ports` 0.00080108642578125
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00023317337036133
(416) DESCRIBE `ports` 0.00077390670776367
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00021004676818848
(418) DESCRIBE `ports` 0.0007929801940918
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0002589225769043
(420) DESCRIBE `ports` 0.00084805488586426
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00022792816162109
(422) DESCRIBE `ports` 0.00081110000610352
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.0002439022064209
(424) DESCRIBE `ports` 0.00076198577880859
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00020503997802734
(426) DESCRIBE `ports` 0.00075292587280273
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022101402282715
(428) DESCRIBE `ports` 0.00077509880065918
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00020194053649902
(430) DESCRIBE `ports` 0.00077414512634277
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00024008750915527
(432) DESCRIBE `ports` 0.00085306167602539
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00024700164794922
(434) DESCRIBE `ports` 0.00084209442138672
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00024604797363281
(436) DESCRIBE `ports` 0.00086092948913574
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00022387504577637
(438) DESCRIBE `ports` 0.000823974609375
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00023984909057617
(440) DESCRIBE `ports` 0.00081610679626465
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00020408630371094
(442) DESCRIBE `ports` 0.00076103210449219
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00022578239440918
(444) DESCRIBE `ports` 0.00076484680175781
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00021815299987793
(446) DESCRIBE `ports` 0.00077295303344727
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023102760314941
(448) DESCRIBE `ports` 0.00078105926513672
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021100044250488
(450) DESCRIBE `avid_specials` 0.00070691108703613
(451) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65067 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014641284942627
(452) DESCRIBE `cruiselines` 0.0012650489807129
(453) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00028109550476074
(454) DESCRIBE `orchid_image` 0.0009150505065918
(455) DESCRIBE `cruiselines` 0.0011441707611084
(456) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00024819374084473
(457) DESCRIBE `cruises` 0.0017681121826172
(458) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66954') 0.00031399726867676
(459) DESCRIBE `ships` 0.0020339488983154
(460) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00038981437683105
(461) DESCRIBE `ships` 0.0019049644470215
(462) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.00029516220092773
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001988410949707
(464) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018596649169922
(465) DESCRIBE `itineraries` 0.00090503692626953
(466) DESCRIBE `ports` 0.00093698501586914
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030398368835449
(468) DESCRIBE `ports` 0.00082087516784668
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024914741516113
(470) DESCRIBE `ports` 0.00081706047058105
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002129077911377
(472) DESCRIBE `sailingdates` 0.00069999694824219
(473) DESCRIBE `ports` 0.00097489356994629
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027990341186523
(475) DESCRIBE `ports` 0.0007929801940918
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002129077911377
(477) DESCRIBE `ports` 0.0007929801940918
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00023698806762695
(479) DESCRIBE `ports` 0.00081992149353027
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00022292137145996
(481) DESCRIBE `ports` 0.00079584121704102
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00025606155395508
(483) DESCRIBE `ports` 0.00078582763671875
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00023794174194336
(485) DESCRIBE `ports` 0.00078392028808594
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.0002439022064209
(487) DESCRIBE `ports` 0.00081801414489746
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00024008750915527
(489) DESCRIBE `ports` 0.00084805488586426
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00025606155395508
(491) DESCRIBE `ports` 0.00090813636779785
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00024890899658203
(493) DESCRIBE `ports` 0.00088191032409668
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00026512145996094
(495) DESCRIBE `ports` 0.00086808204650879
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00020718574523926
(497) DESCRIBE `ports` 0.0007939338684082
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2089))) 0.00024795532226562
(499) DESCRIBE `ports` 0.00083494186401367
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2089') 0.00020813941955566
(501) DESCRIBE `ports` 0.000762939453125
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00023102760314941
(503) DESCRIBE `ports` 0.00078105926513672
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00020909309387207
(505) DESCRIBE `ports` 0.00078821182250977
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00024294853210449
(507) DESCRIBE `ports` 0.00083303451538086
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.0002601146697998
(509) DESCRIBE `ports` 0.00081396102905273
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024294853210449
(511) DESCRIBE `ports` 0.00082015991210938
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00028300285339355
(513) DESCRIBE `avid_specials` 0.00074505805969238
(514) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66954 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 48 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.0014889240264893
(515) DESCRIBE `cruiselines` 0.0013301372528076
(516) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00029397010803223
(517) DESCRIBE `orchid_image` 0.0009620189666748
(518) DESCRIBE `cruiselines` 0.001147985458374
(519) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00025296211242676
(520) DESCRIBE `cruises` 0.0016939640045166
(521) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65047') 0.0002899169921875
(522) DESCRIBE `ships` 0.0016450881958008
(523) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00030803680419922
(524) DESCRIBE `ships` 0.0016210079193115
(525) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00024318695068359
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019407272338867
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018310546875
(528) DESCRIBE `itineraries` 0.0008549690246582
(529) DESCRIBE `ports` 0.00090408325195312
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00028085708618164
(531) DESCRIBE `ports` 0.000823974609375
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024199485778809
(533) DESCRIBE `ports` 0.00087213516235352
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023913383483887
(535) DESCRIBE `sailingdates` 0.00074505805969238
(536) DESCRIBE `ports` 0.0010471343994141
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00028109550476074
(538) DESCRIBE `ports` 0.0009310245513916
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024890899658203
(540) DESCRIBE `ports` 0.000823974609375
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00024008750915527
(542) DESCRIBE `ports` 0.00077605247497559
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00020790100097656
(544) DESCRIBE `ports` 0.00090384483337402
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00026917457580566
(546) DESCRIBE `ports` 0.00082802772521973
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00022101402282715
(548) DESCRIBE `ports` 0.00081610679626465
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00025701522827148
(550) DESCRIBE `ports` 0.00081992149353027
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00025582313537598
(552) DESCRIBE `ports` 0.00080990791320801
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00025510787963867
(554) DESCRIBE `ports` 0.00085020065307617
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00025606155395508
(556) DESCRIBE `ports` 0.00089097023010254
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003969669342041
(558) DESCRIBE `ports` 0.0010690689086914
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024199485778809
(560) DESCRIBE `avid_specials` 0.00057792663574219
(561) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65047 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013110637664795
(562) DESCRIBE `cruiselines` 0.00098490715026855
(563) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0002288818359375
(564) DESCRIBE `orchid_image` 0.00073099136352539
(565) DESCRIBE `cruiselines` 0.00091195106506348
(566) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0001990795135498
(567) DESCRIBE `cruises` 0.0019798278808594
(568) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64895') 0.00030303001403809
(569) DESCRIBE `ships` 0.0018711090087891
(570) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84))) 0.00043392181396484
(571) DESCRIBE `ships` 0.0019850730895996
(572) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '84') 0.00032997131347656
(573) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001990795135498
(574) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018596649169922
(575) DESCRIBE `itineraries` 0.0010008811950684
(576) DESCRIBE `ports` 0.0011920928955078
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00028514862060547
(578) DESCRIBE `ports` 0.00087809562683105
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00025701522827148
(580) DESCRIBE `ports` 0.00085806846618652
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00023913383483887
(582) DESCRIBE `sailingdates` 0.00078701972961426
(583) DESCRIBE `ports` 0.00087380409240723
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00027012825012207
(585) DESCRIBE `ports` 0.00081491470336914
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00021815299987793
(587) DESCRIBE `ports` 0.00076985359191895
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00023198127746582
(589) DESCRIBE `ports` 0.0008080005645752
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00022101402282715
(591) DESCRIBE `ports` 0.00080704689025879
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 882))) 0.00024890899658203
(593) DESCRIBE `ports` 0.00092005729675293
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '882') 0.00024795532226562
(595) DESCRIBE `ports` 0.00086498260498047
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 325))) 0.00026702880859375
(597) DESCRIBE `ports` 0.0009150505065918
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '325') 0.00022411346435547
(599) DESCRIBE `ports` 0.00076794624328613
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00024580955505371
(601) DESCRIBE `ports` 0.00086283683776855
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00022697448730469
(603) DESCRIBE `ports` 0.00079107284545898
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495))) 0.00025320053100586
(605) DESCRIBE `ports` 0.00079703330993652
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1495') 0.00021004676818848
(607) DESCRIBE `ports` 0.0008089542388916
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00025200843811035
(609) DESCRIBE `ports` 0.00084590911865234
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00022602081298828
(611) DESCRIBE `ports` 0.00082015991210938
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00024700164794922
(613) DESCRIBE `ports` 0.00083112716674805
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00023293495178223
(615) DESCRIBE `ports` 0.00084114074707031
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00024890899658203
(617) DESCRIBE `ports` 0.0008537769317627
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00022077560424805
(619) DESCRIBE `ports` 0.00081014633178711
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00025296211242676
(621) DESCRIBE `ports` 0.00086188316345215
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00026392936706543
(623) DESCRIBE `ports` 0.0008699893951416
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00027108192443848
(625) DESCRIBE `ports` 0.00095796585083008
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00028705596923828
(627) DESCRIBE `ports` 0.00090599060058594
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00027084350585938
(629) DESCRIBE `ports` 0.00087690353393555
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00021791458129883
(631) DESCRIBE `ports` 0.00081205368041992
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00025200843811035
(633) DESCRIBE `ports` 0.00084781646728516
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00021100044250488
(635) DESCRIBE `ports` 0.0008089542388916
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00024890899658203
(637) DESCRIBE `ports` 0.0009009838104248
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00021600723266602
(639) DESCRIBE `ports` 0.00077104568481445
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00022411346435547
(641) DESCRIBE `ports` 0.00076889991760254
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00020909309387207
(643) DESCRIBE `ports` 0.00077581405639648
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00024199485778809
(645) DESCRIBE `ports` 0.00078892707824707
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.00023102760314941
(647) DESCRIBE `ports` 0.0007779598236084
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00023698806762695
(649) DESCRIBE `ports` 0.00079798698425293
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00020694732666016
(651) DESCRIBE `ports` 0.00082802772521973
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00023889541625977
(653) DESCRIBE `ports` 0.00089406967163086
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00024700164794922
(655) DESCRIBE `ports` 0.00085806846618652
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00024914741516113
(657) DESCRIBE `ports` 0.00080108642578125
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00022792816162109
(659) DESCRIBE `ports` 0.00083494186401367
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00024199485778809
(661) DESCRIBE `ports` 0.00083303451538086
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00021791458129883
(663) DESCRIBE `ports` 0.00089311599731445
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00023198127746582
(665) DESCRIBE `ports` 0.00076079368591309
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00021004676818848
(667) DESCRIBE `ports` 0.00074601173400879
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00023913383483887
(669) DESCRIBE `ports` 0.00087094306945801
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00023722648620605
(671) DESCRIBE `ports` 0.00066900253295898
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3959))) 0.00020384788513184
(673) DESCRIBE `ports` 0.00058794021606445
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3959') 0.00015878677368164
(675) DESCRIBE `ports` 0.00058603286743164
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00018620491027832
(677) DESCRIBE `ports` 0.00059294700622559
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00017094612121582
(679) DESCRIBE `ports` 0.00060200691223145
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00018405914306641
(681) DESCRIBE `ports` 0.00061488151550293
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.0001680850982666
(683) DESCRIBE `ports` 0.00058412551879883
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1696))) 0.00021815299987793
(685) DESCRIBE `ports` 0.00087285041809082
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1696') 0.00023317337036133
(687) DESCRIBE `ports` 0.00088000297546387
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00027108192443848
(689) DESCRIBE `ports` 0.00093293190002441
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00021100044250488
(691) DESCRIBE `ports` 0.00090408325195312
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00027894973754883
(693) DESCRIBE `ports` 0.00072407722473145
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018596649169922
(695) DESCRIBE `avid_specials` 0.00056004524230957
(696) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64895 and class = 'Cruise') OR (item_id = 84 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 37 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.00088596343994141
(697) DESCRIBE `cruiselines` 0.00091195106506348
(698) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021195411682129
(699) DESCRIBE `orchid_image` 0.00072312355041504
(700) DESCRIBE `cruiselines` 0.00090503692626953
(701) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00021696090698242
(702) DESCRIBE `ships` 0.0017971992492676
(703) SELECT `ships`.* FROM `ships` WHERE (id IN ('792', '340', '78', '657', '82', '84', '547', '81', '401', '1302', '1607', '75', '313', '74', '335')) ORDER BY FIND_IN_SET(id, '792,340,78,657,82,84,547,81,401,1302,1607,75,313,74,335') 0.00077390670776367
(704) DESCRIBE `cruisetypes` 0.00083208084106445
(705) DESCRIBE `destinations` 0.00086188316345215
(706) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '12', '11', '25', '48', '35', '22', '43', '26', '37', '38', '40', '53', '49', '21', '34', '28', '29', '10', '8', '9', '30')) ORDER BY FIND_IN_SET(id, '2,12,11,25,48,35,22,43,26,37,38,40,53,49,21,34,28,29,10,8,9,30') 0.00077700614929199
(707) DESCRIBE `cruiselines` 0.0013740062713623
(708) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00024700164794922
(709) DESCRIBE `cruiselines` 0.0013031959533691
(710) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00026106834411621