or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Total elapsed time: 0.924565076828

# Query Time
(1) connect 0.0007169246673584
(2) DESCRIBE `cruises` 0.0041460990905762
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67108, 67106, 57120, 57176, 57119, 66904, 68476, 73204, 61616, 59773)) ORDER BY FIND_IN_SET(id, '67108,67106,57120,57176,57119,66904,68476,73204,61616,59773') 0.0015859603881836
(4) DESCRIBE `cruises` 0.0028560161590576
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67108') 0.00033998489379883
(6) DESCRIBE `ships` 0.0029671192169189
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.00049996376037598
(8) DESCRIBE `ships` 0.0033459663391113
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.00035595893859863
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030684471130371
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(12) DESCRIBE `itineraries` 0.0014538764953613
(13) DESCRIBE `ports` 0.0020458698272705
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041317939758301
(15) DESCRIBE `ports` 0.0014300346374512
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002899169921875
(17) DESCRIBE `ports` 0.002230167388916
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 8.7976455688477E-5
(19) DESCRIBE `sailingdates` 0.0022950172424316
(20) DESCRIBE `ports` 0.001492977142334
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032520294189453
(22) DESCRIBE `ports` 0.0013070106506348
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00035595893859863
(24) DESCRIBE `ports` 0.0013980865478516
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00038909912109375
(26) DESCRIBE `ports` 0.0014479160308838
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0
(28) DESCRIBE `ports` 0.0018219947814941
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00040698051452637
(30) DESCRIBE `ports` 0.0012412071228027
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0011930465698242
(32) DESCRIBE `ports` 0.0017039775848389
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00046181678771973
(34) DESCRIBE `ports` 0.0017549991607666
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00039505958557129
(36) DESCRIBE `ports` 0.0017600059509277
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00041604042053223
(38) DESCRIBE `ports` 0.0019099712371826
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00039005279541016
(40) DESCRIBE `ports` 0.0015840530395508
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 718))) 0.00033998489379883
(42) DESCRIBE `ports` 0.0017039775848389
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '718') 0.00037980079650879
(44) DESCRIBE `ports` 0.00057816505432129
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00041389465332031
(46) DESCRIBE `ports` 0.001492977142334
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00027799606323242
(48) DESCRIBE `ports` 0.0013289451599121
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00030779838562012
(50) DESCRIBE `ports` 0.0013589859008789
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00027298927307129
(52) DESCRIBE `ports` 0.0013120174407959
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0002901554107666
(54) DESCRIBE `ports` 0.0013241767883301
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0003049373626709
(56) DESCRIBE `ports` 0.0013720989227295
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3964))) 0.00036787986755371
(58) DESCRIBE `ports` 0.0013799667358398
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3964') 0.00028491020202637
(60) DESCRIBE `ports` 0.0015490055084229
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00039982795715332
(62) DESCRIBE `ports` 0.0014998912811279
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00037908554077148
(64) DESCRIBE `ports` 0.0015280246734619
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00036096572875977
(66) DESCRIBE `ports` 0.0015411376953125
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00028896331787109
(68) DESCRIBE `ports` 0.0014729499816895
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040698051452637
(70) DESCRIBE `ports` 0.0014429092407227
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00032210350036621
(72) DESCRIBE `ports` 0.0015149116516113
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00034093856811523
(74) DESCRIBE `ports` 0.0014469623565674
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00031805038452148
(76) DESCRIBE `ports` 0.0015408992767334
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00039792060852051
(78) DESCRIBE `ports` 0.0015609264373779
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00032997131347656
(80) DESCRIBE `ports` 0.0015480518341064
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00044608116149902
(82) DESCRIBE `ports` 0.0015428066253662
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00032711029052734
(84) DESCRIBE `ports` 0.0013878345489502
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 197))) 0.00039100646972656
(86) DESCRIBE `ports` 0.0015349388122559
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '197') 0.0003821849822998
(88) DESCRIBE `ports` 0.0014948844909668
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00037002563476562
(90) DESCRIBE `ports` 0.0014839172363281
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027799606323242
(92) DESCRIBE `ports` 0.0012588500976562
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00028586387634277
(94) DESCRIBE `ports` 0.0013508796691895
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00026583671569824
(96) DESCRIBE `ports` 0.0020451545715332
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00010204315185547
(98) DESCRIBE `ports` 0.0012562274932861
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00027298927307129
(100) DESCRIBE `ports` 0.00050902366638184
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00032496452331543
(102) DESCRIBE `ports` 0.0014848709106445
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0
(104) DESCRIBE `ports` 0.0015749931335449
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00030684471130371
(106) DESCRIBE `ports` 0.00152587890625
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00027203559875488
(108) DESCRIBE `ports` 0.0012879371643066
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002892017364502
(110) DESCRIBE `ports` 0.0012731552124023
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028491020202637
(112) DESCRIBE `ports` 0.0012798309326172
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032901763916016
(114) DESCRIBE `ports` 0.0012760162353516
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00032806396484375
(116) DESCRIBE `avid_specials` 0.0011179447174072
(117) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67108 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 22 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.0010371208190918
(118) DESCRIBE `cruiselines` 0.0018370151519775
(119) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00032997131347656
(120) DESCRIBE `orchid_image` 0.0014770030975342
(121) DESCRIBE `cruiselines` 0.0017879009246826
(122) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0002901554107666
(123) DESCRIBE `cruises` 0.0028400421142578
(124) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67106') 0.00033187866210938
(125) DESCRIBE `ships` 0.0028178691864014
(126) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.00037503242492676
(127) DESCRIBE `ships` 0.0029449462890625
(128) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.0002739429473877
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027012825012207
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(131) DESCRIBE `itineraries` 0.0012381076812744
(132) DESCRIBE `ports` 0.0014851093292236
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00036406517028809
(134) DESCRIBE `ports` 0.0014610290527344
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003349781036377
(136) DESCRIBE `ports` 0.001471996307373
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029397010803223
(138) DESCRIBE `sailingdates` 0.001378059387207
(139) DESCRIBE `ports` 0.0014550685882568
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00035405158996582
(141) DESCRIBE `ports` 0.0014388561248779
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028300285339355
(143) DESCRIBE `ports` 0.0015161037445068
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00039792060852051
(145) DESCRIBE `ports` 0.0014548301696777
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00035595893859863
(147) DESCRIBE `ports` 0.0015149116516113
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00035309791564941
(149) DESCRIBE `ports` 0.0012691020965576
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027799606323242
(151) DESCRIBE `ports` 0.0012240409851074
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00030899047851562
(153) DESCRIBE `ports` 0.00079989433288574
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00031018257141113
(155) DESCRIBE `ports` 0.0014090538024902
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00029993057250977
(157) DESCRIBE `ports` 0.0013208389282227
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00032591819763184
(159) DESCRIBE `ports` 0.0018129348754883
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 718))) 0.00040698051452637
(161) DESCRIBE `ports` 0.0014779567718506
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '718') 0.00028800964355469
(163) DESCRIBE `ports` 0.0014469623565674
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00042200088500977
(165) DESCRIBE `ports` 0.0014500617980957
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00033998489379883
(167) DESCRIBE `ports` 0.0014979839324951
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00029993057250977
(169) DESCRIBE `ports` 0.0014150142669678
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00028491020202637
(171) DESCRIBE `ports` 0.0014569759368896
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00032186508178711
(173) DESCRIBE `ports` 0.0014379024505615
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00030112266540527
(175) DESCRIBE `ports` 0.0013518333435059
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3964))) 0.00031495094299316
(177) DESCRIBE `ports` 0.0014841556549072
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3964') 0.00033187866210938
(179) DESCRIBE `ports` 0.0013699531555176
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00037097930908203
(181) DESCRIBE `ports` 0.0014369487762451
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0003669261932373
(183) DESCRIBE `ports` 0.0014779567718506
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0003969669342041
(185) DESCRIBE `ports` 0.0014791488647461
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00031018257141113
(187) DESCRIBE `ports` 0.0012509822845459
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038504600524902
(189) DESCRIBE `ports` 0.001384973526001
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028014183044434
(191) DESCRIBE `avid_specials` 0.0011489391326904
(192) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67106 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 22 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.0010240077972412
(193) DESCRIBE `cruiselines` 0.0018658638000488
(194) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00040292739868164
(195) DESCRIBE `orchid_image` 0.001655101776123
(196) DESCRIBE `cruiselines` 0.0025749206542969
(197) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00044608116149902
(198) DESCRIBE `cruises` 0.002608060836792
(199) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57120') 0.00037002563476562
(200) DESCRIBE `ships` 0.0025930404663086
(201) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 78))) 0.00036716461181641
(202) DESCRIBE `ships` 0.0025839805603027
(203) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '78') 0.00030994415283203
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026702880859375
(205) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025606155395508
(206) DESCRIBE `itineraries` 0.0012719631195068
(207) DESCRIBE `ports` 0.0013570785522461
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00037121772766113
(209) DESCRIBE `ports` 0.0015208721160889
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00044012069702148
(211) DESCRIBE `ports` 0.0018489360809326
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00040507316589355
(213) DESCRIBE `sailingdates` 0.0015208721160889
(214) DESCRIBE `ports` 0.0020010471343994
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00058603286743164
(216) DESCRIBE `ports` 0.00193190574646
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00046801567077637
(218) DESCRIBE `ports` 0.0023579597473145
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00058197975158691
(220) DESCRIBE `ports` 0.0019359588623047
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00048017501831055
(222) DESCRIBE `ports` 0.0018811225891113
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00047898292541504
(224) DESCRIBE `ports` 0.0017480850219727
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.0001838207244873
(226) DESCRIBE `ports` 0.0015780925750732
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00041103363037109
(228) DESCRIBE `ports` 0.0015301704406738
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00041890144348145
(230) DESCRIBE `ports` 0.0017850399017334
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00043892860412598
(232) DESCRIBE `ports` 0.0015838146209717
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00034499168395996
(234) DESCRIBE `ports` 0.001446008682251
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00040721893310547
(236) DESCRIBE `ports` 0.0015649795532227
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00038790702819824
(238) DESCRIBE `ports` 0.0015568733215332
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00045204162597656
(240) DESCRIBE `ports` 0.001784086227417
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00039911270141602
(242) DESCRIBE `ports` 0.0015099048614502
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00039792060852051
(244) DESCRIBE `ports` 0.0014481544494629
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00031304359436035
(246) DESCRIBE `ports` 0.0014660358428955
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00040197372436523
(248) DESCRIBE `ports` 0.0022311210632324
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.0001218318939209
(250) DESCRIBE `ports` 0.0014650821685791
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00037312507629395
(252) DESCRIBE `ports` 0.0017080307006836
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00036311149597168
(254) DESCRIBE `ports` 0.00142502784729
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.0003509521484375
(256) DESCRIBE `ports` 0.0015408992767334
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00036501884460449
(258) DESCRIBE `ports` 0.0016050338745117
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.0003960132598877
(260) DESCRIBE `ports` 0.001849889755249
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00040888786315918
(262) DESCRIBE `ports` 0.0017402172088623
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00048089027404785
(264) DESCRIBE `ports` 0.0018520355224609
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00043106079101562
(266) DESCRIBE `ports` 0.0024828910827637
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00043392181396484
(268) DESCRIBE `ports` 0.0018379688262939
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00041103363037109
(270) DESCRIBE `ports` 0.0018520355224609
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00045108795166016
(272) DESCRIBE `ports` 0.0017979145050049
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00040698051452637
(274) DESCRIBE `avid_specials` 0.0016739368438721
(275) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57120 and class = 'Cruise') OR (item_id = 78 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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.0017020702362061
(276) DESCRIBE `cruiselines` 0.0026488304138184
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00056099891662598
(278) DESCRIBE `orchid_image` 0.0020990371704102
(279) DESCRIBE `cruiselines` 0.0027918815612793
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00046586990356445
(281) DESCRIBE `cruises` 0.0035581588745117
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57176') 0.00054001808166504
(283) DESCRIBE `ships` 0.0036749839782715
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00059413909912109
(285) DESCRIBE `ships` 0.003715991973877
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.0013358592987061
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 4.6014785766602E-5
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032997131347656
(289) DESCRIBE `itineraries` 0.0020160675048828
(290) DESCRIBE `ports` 0.0014700889587402
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0004730224609375
(292) DESCRIBE `ports` 0.0016610622406006
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0004420280456543
(294) DESCRIBE `ports` 0.0018348693847656
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00035905838012695
(296) DESCRIBE `sailingdates` 0.0014970302581787
(297) DESCRIBE `ports` 0.0014231204986572
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00039196014404297
(299) DESCRIBE `ports` 0.0013420581817627
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00030899047851562
(301) DESCRIBE `ports` 0.0013139247894287
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.0003819465637207
(303) DESCRIBE `ports` 0.0012450218200684
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00028586387634277
(305) DESCRIBE `ports` 0.001270055770874
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00032210350036621
(307) DESCRIBE `ports` 0.0014429092407227
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00029492378234863
(309) DESCRIBE `ports` 0.0014030933380127
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00033998489379883
(311) DESCRIBE `ports` 0.0016989707946777
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00047898292541504
(313) DESCRIBE `ports` 0.0019171237945557
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00049996376037598
(315) DESCRIBE `ports` 0.0019049644470215
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00044608116149902
(317) DESCRIBE `ports` 0.0019001960754395
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00049400329589844
(319) DESCRIBE `ports` 0.001863956451416
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0004889965057373
(321) DESCRIBE `ports` 0.001878023147583
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00046896934509277
(323) DESCRIBE `ports` 0.0014498233795166
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00041007995605469
(325) DESCRIBE `ports` 0.0014491081237793
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00037288665771484
(327) DESCRIBE `ports` 0.0015749931335449
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00044584274291992
(329) DESCRIBE `ports` 0.0016200542449951
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00072002410888672
(331) DESCRIBE `ports` 0.0019581317901611
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00045084953308105
(333) DESCRIBE `ports` 0.0020010471343994
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00050687789916992
(335) DESCRIBE `ports` 0.002234935760498
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00047993659973145
(337) DESCRIBE `ports` 0.0020480155944824
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00063490867614746
(339) DESCRIBE `ports` 0.0019900798797607
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00041508674621582
(341) DESCRIBE `ports` 0.0018160343170166
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00046014785766602
(343) DESCRIBE `ports` 0.0018470287322998
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0003819465637207
(345) DESCRIBE `ports` 0.0014829635620117
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00033187866210938
(347) DESCRIBE `ports` 0.0012779235839844
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00032901763916016
(349) DESCRIBE `ports` 0.0013220310211182
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00033116340637207
(351) DESCRIBE `ports` 0.0014159679412842
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00030088424682617
(353) DESCRIBE `ports` 0.0013101100921631
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00037193298339844
(355) DESCRIBE `ports` 0.0014009475708008
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00028705596923828
(357) DESCRIBE `ports` 0.0015220642089844
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00040602684020996
(359) DESCRIBE `ports` 0.0013959407806396
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00039410591125488
(361) DESCRIBE `avid_specials` 0.00081801414489746
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57176 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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.0024898052215576
(363) DESCRIBE `cruiselines` 0.002047061920166
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0
(365) DESCRIBE `orchid_image` 0.0021669864654541
(366) DESCRIBE `cruiselines` 0.0035378932952881
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00050592422485352
(368) DESCRIBE `cruises` 0.0034189224243164
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57119') 0.00046610832214355
(370) DESCRIBE `ships` 0.0036401748657227
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 78))) 0.00058984756469727
(372) DESCRIBE `ships` 0.0037949085235596
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '78') 0.00039505958557129
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037193298339844
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033688545227051
(376) DESCRIBE `itineraries` 0.0019679069519043
(377) DESCRIBE `ports` 0.0021510124206543
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00049805641174316
(379) DESCRIBE `ports` 0.0019478797912598
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00048995018005371
(381) DESCRIBE `ports` 0.0019731521606445
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00045084953308105
(383) DESCRIBE `sailingdates` 0.0017509460449219
(384) DESCRIBE `ports` 0.0029499530792236
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0004270076751709
(386) DESCRIBE `ports` 0.002249002456665
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00043892860412598
(388) DESCRIBE `ports` 0.0019638538360596
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00047111511230469
(390) DESCRIBE `ports` 0.0018489360809326
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00040698051452637
(392) DESCRIBE `ports` 0.0018060207366943
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00046896934509277
(394) DESCRIBE `ports` 0.0019140243530273
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00059890747070312
(396) DESCRIBE `ports` 0.0015418529510498
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00036907196044922
(398) DESCRIBE `ports` 0.0014579296112061
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00033283233642578
(400) DESCRIBE `ports` 0.0014708042144775
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00035977363586426
(402) DESCRIBE `ports` 0.0014650821685791
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00031185150146484
(404) DESCRIBE `ports` 0.0014059543609619
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00039291381835938
(406) DESCRIBE `ports` 0.0014400482177734
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00031113624572754
(408) DESCRIBE `ports` 0.0013720989227295
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00033020973205566
(410) DESCRIBE `ports` 0.0017478466033936
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00037312507629395
(412) DESCRIBE `ports` 0.0016689300537109
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0010800361633301
(414) DESCRIBE `ports` 0.0017440319061279
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.0004889965057373
(416) DESCRIBE `avid_specials` 0.0019588470458984
(417) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57119 and class = 'Cruise') OR (item_id = 78 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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.0017139911651611
(418) DESCRIBE `cruiselines` 0.0028870105743408
(419) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00056290626525879
(420) DESCRIBE `orchid_image` 0.0023801326751709
(421) DESCRIBE `cruiselines` 0.0026490688323975
(422) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00045394897460938
(423) DESCRIBE `cruises` 0.0033719539642334
(424) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66904') 0.0004730224609375
(425) DESCRIBE `ships` 0.0042338371276855
(426) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00069212913513184
(427) DESCRIBE `ships` 0.0040378570556641
(428) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00054121017456055
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003509521484375
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00056695938110352
(431) DESCRIBE `itineraries` 0.0020978450775146
(432) DESCRIBE `ports` 0.002424955368042
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00060701370239258
(434) DESCRIBE `ports` 0.0020229816436768
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00063896179199219
(436) DESCRIBE `ports` 0.0019619464874268
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00056099891662598
(438) DESCRIBE `sailingdates` 0.0017881393432617
(439) DESCRIBE `ports` 0.0021958351135254
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00058388710021973
(441) DESCRIBE `ports` 0.0020010471343994
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00049495697021484
(443) DESCRIBE `ports` 0.0019588470458984
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00052213668823242
(445) DESCRIBE `ports` 0.0020139217376709
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00046896934509277
(447) DESCRIBE `ports` 0.0021829605102539
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00051617622375488
(449) DESCRIBE `ports` 0.0033020973205566
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00046706199645996
(451) DESCRIBE `ports` 0.0019659996032715
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0006561279296875
(453) DESCRIBE `ports` 0.0019948482513428
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00055599212646484
(455) DESCRIBE `ports` 0.0018892288208008
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00050592422485352
(457) DESCRIBE `ports` 0.0019159317016602
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00059008598327637
(459) DESCRIBE `ports` 0.0019948482513428
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00057196617126465
(461) DESCRIBE `ports` 0.0021860599517822
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00052094459533691
(463) DESCRIBE `ports` 0.001835823059082
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00051212310791016
(465) DESCRIBE `ports` 0.0019080638885498
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00046896934509277
(467) DESCRIBE `avid_specials` 0.0016767978668213
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66904 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021569728851318
(469) DESCRIBE `cruiselines` 0.002716064453125
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00063776969909668
(471) DESCRIBE `orchid_image` 0.0026941299438477
(472) DESCRIBE `cruiselines` 0.0026390552520752
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00040888786315918
(474) DESCRIBE `cruises` 0.0038280487060547
(475) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68476') 0.00056314468383789
(476) DESCRIBE `ships` 0.0040760040283203
(477) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00083112716674805
(478) DESCRIBE `ships` 0.0040240287780762
(479) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00068306922912598
(480) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022101402282715
(482) DESCRIBE `itineraries` 0.0021140575408936
(483) DESCRIBE `ports` 0.0023279190063477
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00057005882263184
(485) DESCRIBE `ports` 0.0031991004943848
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00055813789367676
(487) DESCRIBE `ports` 0.0020289421081543
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00063610076904297
(489) DESCRIBE `sailingdates` 0.0018799304962158
(490) DESCRIBE `ports` 0.0016489028930664
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0005180835723877
(492) DESCRIBE `ports` 0.0018999576568604
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0004270076751709
(494) DESCRIBE `ports` 0.0017809867858887
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00047492980957031
(496) DESCRIBE `ports` 0.0018641948699951
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.0004429817199707
(498) DESCRIBE `ports` 0.002169132232666
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00065493583679199
(500) DESCRIBE `ports` 0.0018868446350098
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00097107887268066
(502) DESCRIBE `ports` 0.0019710063934326
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00049185752868652
(504) DESCRIBE `ports` 0.0018870830535889
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.0004119873046875
(506) DESCRIBE `ports` 0.0031919479370117
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00060105323791504
(508) DESCRIBE `ports` 0.0022201538085938
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00069808959960938
(510) DESCRIBE `ports` 0.002255916595459
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00053191184997559
(512) DESCRIBE `ports` 0.0017800331115723
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00043106079101562
(514) DESCRIBE `ports` 0.0062057971954346
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00058102607727051
(516) DESCRIBE `ports` 0.0020790100097656
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00048685073852539
(518) DESCRIBE `ports` 0.0020349025726318
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0012009143829346
(520) DESCRIBE `ports` 0.0018620491027832
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00050091743469238
(522) DESCRIBE `avid_specials` 0.0017030239105225
(523) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68476 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019569396972656
(524) DESCRIBE `cruiselines` 0.0027921199798584
(525) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0
(526) DESCRIBE `orchid_image` 0.0031650066375732
(527) DESCRIBE `cruiselines` 0.003075122833252
(528) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00054097175598145
(529) DESCRIBE `cruises` 0.003593921661377
(530) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73204') 0.00062084197998047
(531) DESCRIBE `ships` 0.0041952133178711
(532) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00066995620727539
(533) DESCRIBE `ships` 0.0039858818054199
(534) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00099301338195801
(535) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0011169910430908
(536) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(537) DESCRIBE `itineraries` 0.0011119842529297
(538) DESCRIBE `ports` 0.0016908645629883
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00053620338439941
(540) DESCRIBE `ports` 0.0019469261169434
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0004889965057373
(542) DESCRIBE `ports` 0.0019431114196777
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00047802925109863
(544) DESCRIBE `sailingdates` 0.0045130252838135
(545) DESCRIBE `ports` 0.0062000751495361
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.002669095993042
(547) DESCRIBE `ports` 0.0022258758544922
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00055408477783203
(549) DESCRIBE `ports` 0.0019659996032715
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00050806999206543
(551) DESCRIBE `ports` 0.0018391609191895
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00041007995605469
(553) DESCRIBE `ports` 0.0019130706787109
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00043511390686035
(555) DESCRIBE `ports` 0.0019469261169434
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00042319297790527
(557) DESCRIBE `ports` 0.0019519329071045
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00048589706420898
(559) DESCRIBE `ports` 0.0018868446350098
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00042295455932617
(561) DESCRIBE `ports` 0.0024950504302979
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00049400329589844
(563) DESCRIBE `ports` 0.0020098686218262
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00046896934509277
(565) DESCRIBE `ports` 0.0019400119781494
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.0004580020904541
(567) DESCRIBE `ports` 0.0019278526306152
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00053000450134277
(569) DESCRIBE `ports` 0.0028471946716309
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00054693222045898
(571) DESCRIBE `ports` 0.0019729137420654
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.0004580020904541
(573) DESCRIBE `ports` 0.00205397605896
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00050806999206543
(575) DESCRIBE `ports` 0.0020210742950439
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00039219856262207
(577) DESCRIBE `ports` 0.0017189979553223
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00050592422485352
(579) DESCRIBE `ports` 0.0019340515136719
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00048303604125977
(581) DESCRIBE `avid_specials` 0.0017530918121338
(582) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73204 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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.0018379688262939
(583) DESCRIBE `cruiselines` 0.0027589797973633
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00051307678222656
(585) DESCRIBE `orchid_image` 0.0022180080413818
(586) DESCRIBE `cruiselines` 0.0027840137481689
(587) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00047898292541504
(588) DESCRIBE `cruises` 0.0041248798370361
(589) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61616') 0.00076103210449219
(590) DESCRIBE `ships` 0.0052890777587891
(591) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00085306167602539
(592) DESCRIBE `ships` 0.0039691925048828
(593) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.00064492225646973
(594) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037002563476562
(595) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034189224243164
(596) DESCRIBE `itineraries` 0.0022330284118652
(597) DESCRIBE `ports` 0.0024840831756592
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00057721138000488
(599) DESCRIBE `ports` 0.0022540092468262
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00058984756469727
(601) DESCRIBE `ports` 0.0027730464935303
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00063300132751465
(603) DESCRIBE `sailingdates` 0.0018830299377441
(604) DESCRIBE `ports` 0.0027008056640625
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0
(606) DESCRIBE `ports` 0.0032999515533447
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00051999092102051
(608) DESCRIBE `ports` 0.0024387836456299
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00060820579528809
(610) DESCRIBE `ports` 0.0037631988525391
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0006568431854248
(612) DESCRIBE `ports` 0.0029819011688232
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00055289268493652
(614) DESCRIBE `ports` 0.0021641254425049
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00048708915710449
(616) DESCRIBE `ports` 0.0021119117736816
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00054597854614258
(618) DESCRIBE `ports` 0.0034811496734619
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00058293342590332
(620) DESCRIBE `ports` 0.0020830631256104
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00058507919311523
(622) DESCRIBE `ports` 0.0020542144775391
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00048398971557617
(624) DESCRIBE `ports` 0.0018749237060547
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00050187110900879
(626) DESCRIBE `ports` 0.0019669532775879
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00049710273742676
(628) DESCRIBE `ports` 0.0019030570983887
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00053715705871582
(630) DESCRIBE `ports` 0.001906156539917
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00046181678771973
(632) DESCRIBE `ports` 0.0019350051879883
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00051498413085938
(634) DESCRIBE `ports` 0.0018889904022217
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00056600570678711
(636) DESCRIBE `ports` 0.0019669532775879
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00071001052856445
(638) DESCRIBE `ports` 0.0020089149475098
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00054216384887695
(640) DESCRIBE `ports` 0.0012240409851074
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00059795379638672
(642) DESCRIBE `ports` 0.002094030380249
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00041508674621582
(644) DESCRIBE `avid_specials` 0.0026857852935791
(645) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61616 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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.0017750263214111
(646) DESCRIBE `cruiselines` 0.0027940273284912
(647) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00064516067504883
(648) DESCRIBE `orchid_image` 0.0031230449676514
(649) DESCRIBE `cruiselines` 0.0029640197753906
(650) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0
(651) DESCRIBE `cruises` 0.0077641010284424
(652) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59773') 0.00054001808166504
(653) DESCRIBE `ships` 0.0039088726043701
(654) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00072288513183594
(655) DESCRIBE `ships` 0.0039920806884766
(656) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00054383277893066
(657) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041103363037109
(658) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034809112548828
(659) DESCRIBE `itineraries` 0.0019688606262207
(660) DESCRIBE `ports` 0.0023441314697266
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00055599212646484
(662) DESCRIBE `ports` 0.0020198822021484
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00068092346191406
(664) DESCRIBE `ports` 0.0020971298217773
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0010440349578857
(666) DESCRIBE `sailingdates` 0.0066859722137451
(667) DESCRIBE `ports` 0.0033159255981445
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00051999092102051
(669) DESCRIBE `ports` 0.0028591156005859
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00082087516784668
(671) DESCRIBE `ports` 0.0021600723266602
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00025701522827148
(673) DESCRIBE `ports` 0.0016899108886719
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0
(675) DESCRIBE `ports` 0.0016920566558838
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0
(677) DESCRIBE `ports` 0.0016870498657227
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.001291036605835
(679) DESCRIBE `ports` 0.0014688968658447
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00049901008605957
(681) DESCRIBE `ports` 0.0011348724365234
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00046181678771973
(683) DESCRIBE `ports` 0.001884937286377
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.0012848377227783
(685) DESCRIBE `ports` 0.0015659332275391
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00052094459533691
(687) DESCRIBE `ports` 0.0020129680633545
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00058484077453613
(689) DESCRIBE `ports` 0.0020530223846436
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00049996376037598
(691) DESCRIBE `ports` 0.001943826675415
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00058484077453613
(693) DESCRIBE `ports` 0.001474142074585
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00055503845214844
(695) DESCRIBE `ports` 0.0020251274108887
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0006260871887207
(697) DESCRIBE `ports` 0.0015301704406738
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00053906440734863
(699) DESCRIBE `avid_specials` 0.0017991065979004
(700) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59773 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017879009246826
(701) DESCRIBE `cruiselines` 0.0030410289764404
(702) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0006411075592041
(703) DESCRIBE `orchid_image` 0.0022041797637939
(704) DESCRIBE `cruiselines` 0.0030069351196289
(705) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00055098533630371
(706) DESCRIBE `ships` 0.0042359828948975
(707) SELECT `ships`.* FROM `ships` WHERE (id IN ('1607', '792', '340', '1302', '81', '78', '401', '657', '547', '84', '335', '75', '82', '74', '313')) ORDER BY FIND_IN_SET(id, '1607,792,340,1302,81,78,401,657,547,84,335,75,82,74,313') 0.0020592212677002
(708) DESCRIBE `cruisetypes` 0.0019259452819824
(709) DESCRIBE `destinations` 0.0027830600738525
(710) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '2', '48', '43', '22', '35', '11', '53', '37', '25', '38', '34', '26', '40', '29', '21', '28', '49', '8', '9', '30')) ORDER BY FIND_IN_SET(id, '12,2,48,43,22,35,11,53,37,25,38,34,26,40,29,21,28,49,8,9,30') 0.0024220943450928
(711) DESCRIBE `cruiselines` 0.0030219554901123
(712) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00069904327392578
(713) DESCRIBE `cruiselines` 0.0030398368835449
(714) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00059390068054199