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

Total elapsed time: 0.59743642807007

# Query Time
(1) connect 0.00040411949157715
(2) DESCRIBE `cruises` 0.0039598941802979
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70944, 74740, 34155, 41320, 73587, 41316, 46506, 57671, 59237, 59427)) ORDER BY FIND_IN_SET(id, '70944,74740,34155,41320,73587,41316,46506,57671,59237,59427') 0.0021178722381592
(4) DESCRIBE `cruises` 0.0033371448516846
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70944') 9.8943710327148E-5
(6) DESCRIBE `ships` 0.0035769939422607
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1055))) 0.00045490264892578
(8) DESCRIBE `ships` 0.0029630661010742
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1055') 0.00030899047851562
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033807754516602
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032520294189453
(12) DESCRIBE `itineraries` 0.0018320083618164
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70944') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009770393371582
(14) DESCRIBE `ports` 0.0020210742950439
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00039100646972656
(16) DESCRIBE `ports` 0.0018739700317383
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00039196014404297
(18) DESCRIBE `ports` 0.0017268657684326
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00036501884460449
(20) DESCRIBE `sailingdates` 0.0015928745269775
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70944') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00054001808166504
(22) DESCRIBE `ports` 0.0015091896057129
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00032496452331543
(24) DESCRIBE `ports` 0.0014591217041016
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00074481964111328
(26) DESCRIBE `ports` 0.001378059387207
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00043797492980957
(28) DESCRIBE `ports` 0.001971960067749
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00041818618774414
(30) DESCRIBE `ports` 0.001774787902832
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1555))) 0.00043296813964844
(32) DESCRIBE `ports` 0.001701831817627
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1555') 0.00032496452331543
(34) DESCRIBE `ports` 0.0013129711151123
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00029706954956055
(36) DESCRIBE `ports` 0.0014939308166504
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00030088424682617
(38) DESCRIBE `ports` 0.001276969909668
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.0002899169921875
(40) DESCRIBE `ports` 0.0013720989227295
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00027108192443848
(42) DESCRIBE `ports` 0.0013909339904785
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5090))) 0.00033998489379883
(44) DESCRIBE `ports` 0.0013370513916016
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5090') 0.00028395652770996
(46) DESCRIBE `ports` 0.0012478828430176
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.0002892017364502
(48) DESCRIBE `ports` 0.0016570091247559
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00034189224243164
(50) DESCRIBE `ports` 0.0014328956604004
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00034379959106445
(52) DESCRIBE `ports` 0.0014781951904297
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00037288665771484
(54) DESCRIBE `ports` 0.0014069080352783
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00037193298339844
(56) DESCRIBE `ports` 0.0016450881958008
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00027799606323242
(58) DESCRIBE `avid_specials` 0.001129150390625
(59) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70944 and class = 'Cruise') OR (item_id = 1055 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.001215934753418
(60) DESCRIBE `cruiselines` 0.0019240379333496
(61) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0003359317779541
(62) DESCRIBE `orchid_image` 0.0014119148254395
(63) DESCRIBE `cruiselines` 0.0018360614776611
(64) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0003049373626709
(65) DESCRIBE `cruises` 0.0025830268859863
(66) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74740') 0.00035595893859863
(67) DESCRIBE `ships` 0.0027389526367188
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 968))) 0.00042104721069336
(69) DESCRIBE `ships` 0.0030121803283691
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '968') 0.00044393539428711
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026106834411621
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024914741516113
(73) DESCRIBE `itineraries` 0.0012919902801514
(74) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74740') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069308280944824
(75) DESCRIBE `ports` 0.0013160705566406
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030708312988281
(77) DESCRIBE `ports` 0.001500129699707
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00028586387634277
(79) DESCRIBE `ports` 0.0012319087982178
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027298927307129
(81) DESCRIBE `sailingdates` 0.001101016998291
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74740') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00072407722473145
(83) DESCRIBE `ports` 0.00130295753479
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031495094299316
(85) DESCRIBE `ports` 0.0012640953063965
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028419494628906
(87) DESCRIBE `ports` 0.0012259483337402
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.0002741813659668
(89) DESCRIBE `ports` 0.0013020038604736
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00025796890258789
(91) DESCRIBE `ports` 0.0012280941009521
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 583))) 0.00029778480529785
(93) DESCRIBE `ports` 0.0012838840484619
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '583') 0.00026607513427734
(95) DESCRIBE `ports` 0.0012221336364746
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00028514862060547
(97) DESCRIBE `ports` 0.0013198852539062
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00032806396484375
(99) DESCRIBE `ports` 0.0017149448394775
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00040197372436523
(101) DESCRIBE `ports` 0.0017390251159668
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00035500526428223
(103) DESCRIBE `ports` 0.0017690658569336
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00038719177246094
(105) DESCRIBE `ports` 0.0013620853424072
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002748966217041
(107) DESCRIBE `ports` 0.0012369155883789
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031208992004395
(109) DESCRIBE `ports` 0.001323938369751
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027179718017578
(111) DESCRIBE `avid_specials` 0.001183032989502
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74740 and class = 'Cruise') OR (item_id = 968 AND class = 'Ship') OR (item_id = 8 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.0011589527130127
(113) DESCRIBE `cruiselines` 0.0019381046295166
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00032210350036621
(115) DESCRIBE `orchid_image` 0.0014791488647461
(116) DESCRIBE `cruiselines` 0.0019688606262207
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00028610229492188
(118) DESCRIBE `cruises` 0.0024821758270264
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34155') 0.00029993057250977
(120) DESCRIBE `ships` 0.0024640560150146
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 378))) 0.00032711029052734
(122) DESCRIBE `ships` 0.0024039745330811
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '378') 0.00026607513427734
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031089782714844
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025010108947754
(126) DESCRIBE `itineraries` 0.0012078285217285
(127) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34155') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069999694824219
(128) DESCRIBE `ports` 0.0012750625610352
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00029993057250977
(130) DESCRIBE `ports` 0.0012421607971191
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00033688545227051
(132) DESCRIBE `ports` 0.001317024230957
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00027298927307129
(134) DESCRIBE `sailingdates` 0.0010948181152344
(135) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34155') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00096797943115234
(136) DESCRIBE `ports` 0.0015771389007568
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00052595138549805
(138) DESCRIBE `ports` 0.0015158653259277
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00030398368835449
(140) DESCRIBE `ports` 0.0014231204986572
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00035500526428223
(142) DESCRIBE `ports` 0.0015769004821777
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00035786628723145
(144) DESCRIBE `ports` 0.0013411045074463
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00030088424682617
(146) DESCRIBE `ports` 0.0013699531555176
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00034999847412109
(148) DESCRIBE `ports` 0.0016689300537109
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00030684471130371
(150) DESCRIBE `ports` 0.0012760162353516
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00027704238891602
(152) DESCRIBE `ports` 0.0015008449554443
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00032901763916016
(154) DESCRIBE `ports` 0.001284122467041
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00027585029602051
(156) DESCRIBE `ports` 0.0012991428375244
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 4.1007995605469E-5
(158) DESCRIBE `ports` 0.0013689994812012
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.0005638599395752
(160) DESCRIBE `ports` 0.0013041496276855
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00030899047851562
(162) DESCRIBE `ports` 0.0015969276428223
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.0002739429473877
(164) DESCRIBE `ports` 0.0015499591827393
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00031018257141113
(166) DESCRIBE `ports` 0.0012788772583008
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00030398368835449
(168) DESCRIBE `ports` 0.0015568733215332
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00033116340637207
(170) DESCRIBE `ports` 0.0017440319061279
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00031304359436035
(172) DESCRIBE `ports` 0.0013289451599121
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00040006637573242
(174) DESCRIBE `ports` 0.0013039112091064
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00028491020202637
(176) DESCRIBE `ports` 0.0013060569763184
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00030207633972168
(178) DESCRIBE `ports` 0.0013000965118408
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00028800964355469
(180) DESCRIBE `avid_specials` 0.0012140274047852
(181) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34155 and class = 'Cruise') OR (item_id = 378 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 25 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.0010859966278076
(182) DESCRIBE `cruiselines` 0.0021429061889648
(183) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00043892860412598
(184) DESCRIBE `orchid_image` 0.0018818378448486
(185) DESCRIBE `cruiselines` 0.0027000904083252
(186) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00040984153747559
(187) DESCRIBE `cruises` 0.0035707950592041
(188) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41320') 0.00048613548278809
(189) DESCRIBE `ships` 0.003882884979248
(190) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1068))) 0.0005028247833252
(191) DESCRIBE `ships` 0.0036849975585938
(192) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1068') 0.00038003921508789
(193) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034499168395996
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(195) DESCRIBE `itineraries` 0.0017440319061279
(196) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41320') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00082492828369141
(197) DESCRIBE `ports` 0.0018289089202881
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00041508674621582
(199) DESCRIBE `ports` 0.0017828941345215
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00045394897460938
(201) DESCRIBE `ports` 0.001755952835083
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00039982795715332
(203) DESCRIBE `sailingdates` 0.0015430450439453
(204) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41320') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010480880737305
(205) DESCRIBE `ports` 0.0019750595092773
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00041604042053223
(207) DESCRIBE `ports` 0.0017020702362061
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00034594535827637
(209) DESCRIBE `ports` 0.0016980171203613
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00039792060852051
(211) DESCRIBE `ports` 0.0016639232635498
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 4.6014785766602E-5
(213) DESCRIBE `ports` 0.0014388561248779
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00039100646972656
(215) DESCRIBE `ports` 0.0017881393432617
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00034999847412109
(217) DESCRIBE `ports` 0.0018789768218994
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00030708312988281
(219) DESCRIBE `ports` 0.0013580322265625
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00030899047851562
(221) DESCRIBE `ports` 0.0012850761413574
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00032305717468262
(223) DESCRIBE `ports` 0.0012459754943848
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00027108192443848
(225) DESCRIBE `ports` 0.001366138458252
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00030088424682617
(227) DESCRIBE `ports` 0.0014739036560059
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00031805038452148
(229) DESCRIBE `avid_specials` 0.0012099742889404
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41320 and class = 'Cruise') OR (item_id = 1068 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0013139247894287
(231) DESCRIBE `cruiselines` 0.0021378993988037
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00034594535827637
(233) DESCRIBE `orchid_image` 0.0014050006866455
(234) DESCRIBE `cruiselines` 0.0018680095672607
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00030803680419922
(236) DESCRIBE `cruises` 0.0025260448455811
(237) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73587') 0.00031495094299316
(238) DESCRIBE `ships` 0.0026130676269531
(239) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 116))) 0.00039887428283691
(240) DESCRIBE `ships` 0.0025689601898193
(241) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '116') 0.00030899047851562
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028395652770996
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(244) DESCRIBE `itineraries` 0.0012228488922119
(245) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73587') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006248950958252
(246) DESCRIBE `ports` 0.0013329982757568
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00033402442932129
(248) DESCRIBE `ports` 0.0014030933380127
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00029492378234863
(250) DESCRIBE `ports` 0.0012428760528564
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00026893615722656
(252) DESCRIBE `sailingdates` 0.0014128684997559
(253) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73587') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005180835723877
(254) DESCRIBE `ports` 0.0014021396636963
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 4.0054321289062E-5
(256) DESCRIBE `ports` 0.0013620853424072
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00035905838012695
(258) DESCRIBE `ports` 0.0013279914855957
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00036311149597168
(260) DESCRIBE `ports` 0.0013041496276855
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00050497055053711
(262) DESCRIBE `ports` 0.0018999576568604
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00032401084899902
(264) DESCRIBE `ports` 0.001338005065918
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00027585029602051
(266) DESCRIBE `ports` 0.0012500286102295
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00035190582275391
(268) DESCRIBE `ports` 0.0013248920440674
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00028085708618164
(270) DESCRIBE `ports` 0.0012829303741455
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00031518936157227
(272) DESCRIBE `ports` 0.0012500286102295
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00026607513427734
(274) DESCRIBE `avid_specials` 0.0010981559753418
(275) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73587 and class = 'Cruise') OR (item_id = 116 AND class = 'Ship') OR (item_id = 26 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.0010330677032471
(276) DESCRIBE `cruiselines` 0.002234935760498
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00053095817565918
(278) DESCRIBE `orchid_image` 0.0018649101257324
(279) DESCRIBE `cruiselines` 0.001910924911499
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00032401084899902
(281) DESCRIBE `cruises` 0.0024712085723877
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41316') 9.7990036010742E-5
(283) DESCRIBE `ships` 0.0027201175689697
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1068))) 0.00037693977355957
(285) DESCRIBE `ships` 0.0028700828552246
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1068') 0.00031781196594238
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027894973754883
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030684471130371
(289) DESCRIBE `itineraries` 0.0013208389282227
(290) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41316') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055980682373047
(291) DESCRIBE `ports` 0.0017459392547607
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0004429817199707
(293) DESCRIBE `ports` 0.0018470287322998
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00032520294189453
(295) DESCRIBE `ports` 0.0015521049499512
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00029587745666504
(297) DESCRIBE `sailingdates` 0.0011179447174072
(298) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41316') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011579990386963
(299) DESCRIBE `ports` 0.0018758773803711
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00033116340637207
(301) DESCRIBE `ports` 0.0012500286102295
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00032496452331543
(303) DESCRIBE `ports` 0.001338005065918
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00030088424682617
(305) DESCRIBE `ports` 0.0012531280517578
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00026917457580566
(307) DESCRIBE `ports` 0.0012249946594238
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00037193298339844
(309) DESCRIBE `ports` 0.0012881755828857
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00027704238891602
(311) DESCRIBE `ports` 0.0012519359588623
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.0002751350402832
(313) DESCRIBE `ports` 0.001384973526001
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.0002598762512207
(315) DESCRIBE `ports` 0.001244068145752
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00029897689819336
(317) DESCRIBE `ports` 0.0012409687042236
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00026798248291016
(319) DESCRIBE `avid_specials` 0.001101016998291
(320) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41316 and class = 'Cruise') OR (item_id = 1068 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0010991096496582
(321) DESCRIBE `cruiselines` 0.0017061233520508
(322) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00035500526428223
(323) DESCRIBE `orchid_image` 0.0014541149139404
(324) DESCRIBE `cruiselines` 0.0021240711212158
(325) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00033020973205566
(326) DESCRIBE `cruises` 0.0027318000793457
(327) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46506') 0.00030088424682617
(328) DESCRIBE `ships` 0.0025148391723633
(329) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1176))) 0.00041794776916504
(330) DESCRIBE `ships` 0.0026190280914307
(331) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1176') 0.00026583671569824
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033903121948242
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(334) DESCRIBE `itineraries` 0.001262903213501
(335) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '46506') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059700012207031
(336) DESCRIBE `ports` 0.0012710094451904
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4532))) 0.00028491020202637
(338) DESCRIBE `ports` 0.0013000965118408
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4532))) 0.00028610229492188
(340) DESCRIBE `ports` 0.0012490749359131
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4532') 0.00028800964355469
(342) DESCRIBE `sailingdates` 0.0011639595031738
(343) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '46506') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00024890899658203
(344) DESCRIBE `ports` 0.0018351078033447
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4532))) 0.0003669261932373
(346) DESCRIBE `ports` 0.0017399787902832
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4532') 0.00044894218444824
(348) DESCRIBE `ports` 0.001615047454834
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00031280517578125
(350) DESCRIBE `ports` 0.0016458034515381
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00037908554077148
(352) DESCRIBE `ports` 0.0015208721160889
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00046682357788086
(354) DESCRIBE `ports` 0.0017290115356445
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00032997131347656
(356) DESCRIBE `ports` 0.0017149448394775
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00040221214294434
(358) DESCRIBE `ports` 0.0016891956329346
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00035905838012695
(360) DESCRIBE `ports` 0.0016059875488281
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4532))) 0
(362) DESCRIBE `ports` 0.0017271041870117
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4532') 0.00035810470581055
(364) DESCRIBE `avid_specials` 0.00105881690979
(365) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46506 and class = 'Cruise') OR (item_id = 1176 AND class = 'Ship') OR (item_id = 225 AND class = 'CruiseLine') OR (item_id = 55 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017719268798828
(366) DESCRIBE `cruiselines` 0.0022428035736084
(367) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 225))) 0.00052785873413086
(368) DESCRIBE `orchid_image` 0.0020179748535156
(369) DESCRIBE `cruiselines` 0.0024089813232422
(370) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '225') 0.00035500526428223
(371) DESCRIBE `cruises` 0.0033798217773438
(372) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57671') 0.00044703483581543
(373) DESCRIBE `ships` 0.0027420520782471
(374) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 858))) 0.00043392181396484
(375) DESCRIBE `ships` 0.0030109882354736
(376) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '858') 0.00040102005004883
(377) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033903121948242
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032186508178711
(379) DESCRIBE `itineraries` 0.0017769336700439
(380) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57671') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00068998336791992
(381) DESCRIBE `ports` 0.0018420219421387
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00038909912109375
(383) DESCRIBE `ports` 0.0017158985137939
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00038003921508789
(385) DESCRIBE `ports` 0.0017790794372559
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00036716461181641
(387) DESCRIBE `sailingdates` 0.0015101432800293
(388) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57671') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058817863464355
(389) DESCRIBE `ports` 0.0017521381378174
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00035905838012695
(391) DESCRIBE `ports` 0.0012850761413574
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00039911270141602
(393) DESCRIBE `ports` 0.0013408660888672
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00030303001403809
(395) DESCRIBE `ports` 0.0018339157104492
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00053596496582031
(397) DESCRIBE `ports` 0.001971960067749
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00039219856262207
(399) DESCRIBE `ports` 0.0016939640045166
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00034093856811523
(401) DESCRIBE `ports` 0.0016870498657227
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00038504600524902
(403) DESCRIBE `ports` 0.0017681121826172
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00033688545227051
(405) DESCRIBE `ports` 0.0014870166778564
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00036001205444336
(407) DESCRIBE `ports` 0.0016660690307617
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00034403800964355
(409) DESCRIBE `avid_specials` 0.0015170574188232
(410) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57671 and class = 'Cruise') OR (item_id = 858 AND class = 'Ship') OR (item_id = 195 AND class = 'CruiseLine') OR (item_id = 55 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016250610351562
(411) DESCRIBE `cruiselines` 0.0024218559265137
(412) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) 0.00040411949157715
(413) DESCRIBE `orchid_image` 0.0019161701202393
(414) DESCRIBE `cruiselines` 0.0024399757385254
(415) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') 0.00036907196044922
(416) DESCRIBE `cruises` 0.003364086151123
(417) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59237') 0.0003819465637207
(418) DESCRIBE `ships` 0.0035510063171387
(419) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00049805641174316
(420) DESCRIBE `ships` 0.0035629272460938
(421) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00035595893859863
(422) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003659725189209
(423) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032210350036621
(424) DESCRIBE `itineraries` 0.0016739368438721
(425) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59237') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063419342041016
(426) DESCRIBE `ports` 0.0017721652984619
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00038790702819824
(428) DESCRIBE `ports` 0.001716136932373
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00037503242492676
(430) DESCRIBE `ports` 0.0017819404602051
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00035285949707031
(432) DESCRIBE `sailingdates` 0.0015609264373779
(433) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59237') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060701370239258
(434) DESCRIBE `ports` 0.0018050670623779
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00037407875061035
(436) DESCRIBE `ports` 0.0017430782318115
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00036501884460449
(438) DESCRIBE `ports` 0.0015339851379395
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00044608116149902
(440) DESCRIBE `ports` 0.0017092227935791
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00029778480529785
(442) DESCRIBE `ports` 0.0017781257629395
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0003821849822998
(444) DESCRIBE `ports` 0.0017940998077393
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00035405158996582
(446) DESCRIBE `avid_specials` 0.0015099048614502
(447) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59237 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015420913696289
(448) DESCRIBE `cruiselines` 0.0026109218597412
(449) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00040316581726074
(450) DESCRIBE `orchid_image` 0.0019469261169434
(451) DESCRIBE `cruiselines` 0.0024549961090088
(452) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00034904479980469
(453) DESCRIBE `cruises` 0.003324031829834
(454) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59427') 0.00036096572875977
(455) DESCRIBE `ships` 0.0034098625183105
(456) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1422))) 0.00048685073852539
(457) DESCRIBE `ships` 0.0034117698669434
(458) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1422') 0.00038599967956543
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034117698669434
(460) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032806396484375
(461) DESCRIBE `itineraries` 0.0016510486602783
(462) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59427') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071382522583008
(463) DESCRIBE `ports` 0.0016958713531494
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.0003809928894043
(465) DESCRIBE `ports` 0.0017168521881104
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00043797492980957
(467) DESCRIBE `ports` 0.0017399787902832
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00035810470581055
(469) DESCRIBE `sailingdates` 0.0015401840209961
(470) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59427') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010130405426025
(471) DESCRIBE `ports` 0.0019040107727051
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00041103363037109
(473) DESCRIBE `ports` 0.0017199516296387
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00038313865661621
(475) DESCRIBE `ports` 0.0017120838165283
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00039219856262207
(477) DESCRIBE `ports` 0.0017259120941162
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00033998489379883
(479) DESCRIBE `ports` 0.0017149448394775
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00037503242492676
(481) DESCRIBE `ports` 0.0016741752624512
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00041699409484863
(483) DESCRIBE `ports` 0.0017271041870117
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00035691261291504
(485) DESCRIBE `ports` 0.0017719268798828
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00033402442932129
(487) DESCRIBE `ports` 0.001802921295166
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00037789344787598
(489) DESCRIBE `ports` 0.001741886138916
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00035405158996582
(491) DESCRIBE `ports` 0.0017228126525879
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00035715103149414
(493) DESCRIBE `ports` 0.0016891956329346
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00032806396484375
(495) DESCRIBE `ports` 0.0018410682678223
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00014495849609375
(497) DESCRIBE `ports` 0.0018081665039062
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00037002563476562
(499) DESCRIBE `avid_specials` 0.0015199184417725
(500) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59427 and class = 'Cruise') OR (item_id = 1422 AND class = 'Ship') OR (item_id = 31 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015850067138672
(501) DESCRIBE `cruiselines` 0.0025601387023926
(502) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00041890144348145
(503) DESCRIBE `orchid_image` 0.0015921592712402
(504) DESCRIBE `cruiselines` 0.0020339488983154
(505) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00032496452331543
(506) DESCRIBE `cruiselines` 0.0017731189727783
(507) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '171', '23', '144', '18', '31', '20', '101', '8', '183', '96', '12', '120', '191', '50', '103', '221', '29', '15', '33', '268', '37', '156', '28', '91', '262', '114', '110', '141', '131', '208', '153', '187', '14', '232', '24', '118', '49', '181', '258', '151', '36', '212', '30', '206', '140', '204', '4', '256', '238', '249', '220', '16', '239', '47', '174', '113', '35', '264', '90', '195', '216', '188', '182', '261', '136', '146', '159', '213', '237', '211', '115', '168', '196', '180', '73', '209', '57', '95', '248', '59', '219', '52', '184', '231', '170', '225', '229', '108', '88', '230', '276', '82', '244', '132', '269', '105', '275', '48', '119', '240', '116', '64', '266', '38', '134', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,171,23,144,18,31,20,101,8,183,96,12,120,191,50,103,221,29,15,33,268,37,156,28,91,262,114,110,141,131,208,153,187,14,232,24,118,49,181,258,151,36,212,30,206,140,204,4,256,238,249,220,16,239,47,174,113,35,264,90,195,216,188,182,261,136,146,159,213,237,211,115,168,196,180,73,209,57,95,248,59,219,52,184,231,170,225,229,108,88,230,276,82,244,132,269,105,275,48,119,240,116,64,266,38,134,224,210') 0.0061259269714355
(508) DESCRIBE `ships` 0.002971887588501
(509) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '977', '1199', '1247', '1554', '1555', '1291', '1359', '1272', '1588', '1067', '1237', '1599', '407', '258', '1594', '27', '22', '21', '461', '28', '37', '38', '34', '378', '31', '393', '726', '817', '1424', '349', '1135', '30', '1012', '36', '39', '1422', '780', '1419', '1423', '1420', '1421', '1418', '35', '1415', '462', '113', '404', '452', '1677', '24', '766', '265', '1405', '11', '439', '1245', '711', '10', '330', '1215', '1574', '9', '585', '455', '542', '1141', '674', '124', '739', '770', '635', '1572', '1607', '5', '792', '797', '207', '1460', '3', '573', '974', '116', '340', '520', '553', '1454', '25', '1372', '1455', '160', '1193', '874', '517', '580', '1021', '1284', '1302', '390', '1095', '1325', '1402', '253', '285', '4', '332', '748', '43', '66', '1172', '1320', '658', '765', '791', '1068', '582', '1323', '434', '1260', '421', '559', '993', '1259', '1575', '327', '590', '883', '1586', '81', '286', '970', '1678', '119', '406', '526', '678', '78', '854', '1571', '375', '616', '14', '454', '722', '850', '855', '1236', '1492', '547', '823', '1266', '1569', '114', '405', '1008', '1064', '1139', '1208', '1308', '84', '441', '403', '784', '732', '1319', '1330', '1348', '1437', '348', '657', '966', '1088', '1108', '1282', '1587', '1672', '111', '163', '652', '1321', '262', '325', '338', '1326', '1327', '333', '451', '1143', '1389', '123', '508', '521', '1579', '1724', '389', '1027', '1159', '1243', '1376', '148', '351', '683', '1151', '1471', '1526', '314', '483', '1013', '1214', '1367', '162', '290', '75', '93', '287', '394', '626', '1163', '1318', '1398', '545', '651', '731', '859', '751', '1075', '1344', '1602', '291', '673', '768', '1040', '1137', '1144', '1157', '1343', '98', '149', '335', '716', '743', '852', '968', '1063', '1168', '1233', '1413', '1604', '152', '610', '818', '884', '1223', '1303', '1345', '1452', '1453', '1581', '1711', '82', '401', '669', '769', '1025', '1043', '1090', '1136', '1145', '1283', '1301', '1373', '1552', '45', '150', '151', '352', '790', '796', '1241', '201', '223', '485', '776', '882', '1160', '1717', '59', '108', '467', '503', '1152', '1226', '1539', '1738', '324', '341', '639', '905', '988', '1149', '1150', '1448', '1463', '266', '1409', '1449', '1540', '417', '871', '885', '1253', '1411', '1647', '105', '601', '811', '1055', '1458', '1682', '1704', '74', '1026', '1029', '1073', '1188', '1351', '1632', '448', '701', '973', '1231', '1489', '1505', '954', '986', '1034', '1047', '1366', '1408', '1496', '1609', '1742', '494', '666', '704', '795', '851', '1049', '1230', '1362', '1368', '1516', '1740', '205', '208', '738', '888', '996', '1154', '1285', '147', '493', '1037', '1470', '1474', '1580', '1627', '618', '836', '1224', '1444', '1518', '423', '837', '1176', '1382', '1417', '1521', '1229', '1404', '1407', '1410', '1716', '204', '422', '643', '985', '1138', '1196', '1262', '1593', '672', '709', '857', '1054', '1148', '1445', '1486', '1517', '1522', '1619', '671', '717', '972', '1017', '1042', '1051', '1352', '1713', '1715', '781', '994', '1175', '1714', '479', '480', '938', '1106', '1240', '1254', '1412', '1673', '665', '995', '1514', '1606', '1614', '1684', '17', '499', '574', '821', '1045', '1360', '1361', '1459', '1601', '1011', '1053', '1134', '1384', '1481', '1628', '313', '420', '982', '1028', '1322', '1358', '1383', '1501', '1515', '1676', '453', '749', '937', '958', '1439', '1461', '1645', '1708', '1743', '775', '999', '1052', '1071', '1206', '1256', '1615', '1722', '1723', '419', '744', '798', '808', '1631', '1729', '487', '687', '969', '1189', '1232', '1274', '1293', '1297', '1338', '1355', '1035', '1048', '1679', '1681', '1697', '70', '212', '288', '1060', '1089')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,977,1199,1247,1554,1555,1291,1359,1272,1588,1067,1237,1599,407,258,1594,27,22,21,461,28,37,38,34,378,31,393,726,817,1424,349,1135,30,1012,36,39,1422,780,1419,1423,1420,1421,1418,35,1415,462,113,404,452,1677,24,766,265,1405,11,439,1245,711,10,330,1215,1574,9,585,455,542,1141,674,124,739,770,635,1572,1607,5,792,797,207,1460,3,573,974,116,340,520,553,1454,25,1372,1455,160,1193,874,517,580,1021,1284,1302,390,1095,1325,1402,253,285,4,332,748,43,66,1172,1320,658,765,791,1068,582,1323,434,1260,421,559,993,1259,1575,327,590,883,1586,81,286,970,1678,119,406,526,678,78,854,1571,375,616,14,454,722,850,855,1236,1492,547,823,1266,1569,114,405,1008,1064,1139,1208,1308,84,441,403,784,732,1319,1330,1348,1437,348,657,966,1088,1108,1282,1587,1672,111,163,652,1321,262,325,338,1326,1327,333,451,1143,1389,123,508,521,1579,1724,389,1027,1159,1243,1376,148,351,683,1151,1471,1526,314,483,1013,1214,1367,162,290,75,93,287,394,626,1163,1318,1398,545,651,731,859,751,1075,1344,1602,291,673,768,1040,1137,1144,1157,1343,98,149,335,716,743,852,968,1063,1168,1233,1413,1604,152,610,818,884,1223,1303,1345,1452,1453,1581,1711,82,401,669,769,1025,1043,1090,1136,1145,1283,1301,1373,1552,45,150,151,352,790,796,1241,201,223,485,776,882,1160,1717,59,108,467,503,1152,1226,1539,1738,324,341,639,905,988,1149,1150,1448,1463,266,1409,1449,1540,417,871,885,1253,1411,1647,105,601,811,1055,1458,1682,1704,74,1026,1029,1073,1188,1351,1632,448,701,973,1231,1489,1505,954,986,1034,1047,1366,1408,1496,1609,1742,494,666,704,795,851,1049,1230,1362,1368,1516,1740,205,208,738,888,996,1154,1285,147,493,1037,1470,1474,1580,1627,618,836,1224,1444,1518,423,837,1176,1382,1417,1521,1229,1404,1407,1410,1716,204,422,643,985,1138,1196,1262,1593,672,709,857,1054,1148,1445,1486,1517,1522,1619,671,717,972,1017,1042,1051,1352,1713,1715,781,994,1175,1714,479,480,938,1106,1240,1254,1412,1673,665,995,1514,1606,1614,1684,17,499,574,821,1045,1360,1361,1459,1601,1011,1053,1134,1384,1481,1628,313,420,982,1028,1322,1358,1383,1501,1515,1676,453,749,937,958,1439,1461,1645,1708,1743,775,999,1052,1071,1206,1256,1615,1722,1723,419,744,798,808,1631,1729,487,687,969,1189,1232,1274,1293,1297,1338,1355,1035,1048,1679,1681,1697,70,212,288,1060,1089') 0.037477970123291
(510) DESCRIBE `cruisetypes` 0.0018870830535889
(511) DESCRIBE `destinations` 0.0023560523986816
(512) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '40', '26', '38', '11', '7', '30', '48', '21', '49', '45', '44', '56', '29', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,39,55,28,40,26,38,11,7,30,48,21,49,45,44,56,29,34,10,52,46,32') 0.0022449493408203