or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Total elapsed time: 0.85416793823242

# Query Time
(1) connect 0.00064182281494141
(2) DESCRIBE `cruises` 0.0030269622802734
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (11517, 11516, 65943, 65945, 49093, 56009, 65739, 82484, 82483)) ORDER BY FIND_IN_SET(id, '11517,11516,65943,65945,49093,56009,65739,82484,82483') 0.0014710426330566
(4) DESCRIBE `specials` 0.0051488876342773
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1541784') AND (specials.orchid_available = 1) LIMIT 1 0.00096487998962402
(6) DESCRIBE `specials` 0.0042080879211426
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541784') 0
(8) DESCRIBE `ships` 0.0026450157165527
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00041103363037109
(10) DESCRIBE `ships` 0.0032200813293457
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.0003349781036377
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026392936706543
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(14) DESCRIBE `itineraries` 0.0014500617980957
(15) DESCRIBE `ports` 0.0025629997253418
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00034499168395996
(17) DESCRIBE `ports` 0.0012428760528564
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00033903121948242
(19) DESCRIBE `ports` 0.0012450218200684
(20) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00028181076049805
(21) DESCRIBE `specialsailingdates` 0.0010409355163574
(22) DESCRIBE `sailingdates` 0.0011179447174072
(23) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518739))) 0.00045204162597656
(24) DESCRIBE `sailingdates` 0.0011670589447021
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518740))) 0.00026607513427734
(26) DESCRIBE `sailingdates` 0.0013160705566406
(27) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518741))) 0.00027084350585938
(28) DESCRIBE `sailingdates` 0.0010831356048584
(29) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518742))) 0.00031518936157227
(30) DESCRIBE `sailingdates` 0.0011098384857178
(31) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518743))) 0.00026106834411621
(32) DESCRIBE `sailingdates` 0.0010840892791748
(33) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518744))) 0.00023698806762695
(34) DESCRIBE `sailingdates` 0.0012359619140625
(35) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518746))) 0.00031399726867676
(36) DESCRIBE `sailingdates` 0.0012331008911133
(37) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518749))) 0.00027203559875488
(38) DESCRIBE `sailingdates` 0.0011138916015625
(39) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518750))) 0.00026893615722656
(40) DESCRIBE `sailingdates` 0.0010879039764404
(41) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518751))) 0.00032496452331543
(42) DESCRIBE `sailingdates` 0.0011870861053467
(43) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518754))) 0.00033998489379883
(44) DESCRIBE `sailingdates` 0.0014209747314453
(45) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518755))) 0.00038409233093262
(46) DESCRIBE `sailingdates` 0.0012400150299072
(47) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518756))) 0.0002751350402832
(48) DESCRIBE `sailingdates` 0.0011229515075684
(49) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518757))) 0.00032186508178711
(50) DESCRIBE `sailingdates` 0.0013930797576904
(51) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518758))) 0.00029611587524414
(52) DESCRIBE `sailingdates` 0.0012221336364746
(53) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518759))) 0.00026488304138184
(54) DESCRIBE `sailingdates` 0.0012509822845459
(55) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518760))) 0.00030183792114258
(56) DESCRIBE `sailingdates` 0.0012180805206299
(57) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518761))) 9.2983245849609E-5
(58) DESCRIBE `sailingdates` 0.0012109279632568
(59) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518762))) 0.00035619735717773
(60) DESCRIBE `sailingdates` 0.0013680458068848
(61) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518763))) 0.00027203559875488
(62) DESCRIBE `sailingdates` 0.001453161239624
(63) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518764))) 0.0004429817199707
(64) DESCRIBE `sailingdates` 0.0011270046234131
(65) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518765))) 0.00030398368835449
(66) DESCRIBE `sailingdates` 0.0014030933380127
(67) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518766))) 0.00026702880859375
(68) DESCRIBE `sailingdates` 0.0010879039764404
(69) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518767))) 0.00026297569274902
(70) DESCRIBE `sailingdates` 0.0011701583862305
(71) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518770))) 0.00026392936706543
(72) DESCRIBE `sailingdates` 0.0010879039764404
(73) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518772))) 0.00026297569274902
(74) DESCRIBE `sailingdates` 0.0010921955108643
(75) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518773))) 0.00026607513427734
(76) DESCRIBE `sailingdates` 0.0011038780212402
(77) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518774))) 0.00040793418884277
(78) DESCRIBE `sailingdates` 0.0011730194091797
(79) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518776))) 0.00027298927307129
(80) DESCRIBE `sailingdates` 0.0014009475708008
(81) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518777))) 0.00059890747070312
(82) DESCRIBE `sailingdates` 0.0017430782318115
(83) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518778))) 0.0003209114074707
(84) DESCRIBE `sailingdates` 0.002122163772583
(85) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518779))) 0.00034999847412109
(86) DESCRIBE `sailingdates` 0.0014598369598389
(87) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518780))) 0.0010159015655518
(88) DESCRIBE `ports` 0.0017859935760498
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00035500526428223
(90) DESCRIBE `ports` 0.0017158985137939
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00032401084899902
(92) DESCRIBE `ports` 0.0021781921386719
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00036811828613281
(94) DESCRIBE `ports` 0.001845121383667
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00035881996154785
(96) DESCRIBE `ports` 0.0013651847839355
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00038003921508789
(98) DESCRIBE `ports` 0.0015180110931396
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00033211708068848
(100) DESCRIBE `ports` 0.0022399425506592
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0003058910369873
(102) DESCRIBE `ports` 0.0012798309326172
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00028014183044434
(104) DESCRIBE `ports` 0.0013279914855957
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00033402442932129
(106) DESCRIBE `ports` 0.001323938369751
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00026988983154297
(108) DESCRIBE `ports` 0.0012719631195068
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.0002901554107666
(110) DESCRIBE `ports` 0.0012331008911133
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00026583671569824
(112) DESCRIBE `ports` 0.001331090927124
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00034403800964355
(114) DESCRIBE `ports` 0.001323938369751
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00027298927307129
(116) DESCRIBE `ports` 0.0014731884002686
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00036096572875977
(118) DESCRIBE `ports` 0.0012550354003906
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00030207633972168
(120) DESCRIBE `cruises` 0.002701997756958
(121) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00042200088500977
(122) DESCRIBE `avid_specials` 0.001317024230957
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541784 and class = 'Special') OR (item_id = 11517 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011260509490967
(124) DESCRIBE `cruiselines` 0.0018558502197266
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00031590461730957
(126) DESCRIBE `orchid_image` 0.0013828277587891
(127) DESCRIBE `cruiselines` 0.0018360614776611
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00027918815612793
(129) DESCRIBE `specials` 0.0055160522460938
(130) DESCRIBE `specials` 0.0041079521179199
(131) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541793') 0.00038003921508789
(132) DESCRIBE `ships` 0.0025520324707031
(133) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00036287307739258
(134) DESCRIBE `ships` 0.0026569366455078
(135) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00027799606323242
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026893615722656
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025415420532227
(138) DESCRIBE `itineraries` 0.0012340545654297
(139) DESCRIBE `ports` 0.0012969970703125
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00031304359436035
(141) DESCRIBE `ports` 0.0013160705566406
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00027704238891602
(143) DESCRIBE `ports` 0.0013101100921631
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.0003509521484375
(145) DESCRIBE `specialsailingdates` 0.0013778209686279
(146) DESCRIBE `sailingdates` 0.0011699199676514
(147) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518625))) 0.00032210350036621
(148) DESCRIBE `sailingdates` 0.0011508464813232
(149) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518626))) 0.00034594535827637
(150) DESCRIBE `sailingdates` 0.0013480186462402
(151) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518627))) 0.00034213066101074
(152) DESCRIBE `sailingdates` 0.001410961151123
(153) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518631))) 0.00036096572875977
(154) DESCRIBE `sailingdates` 0.0011839866638184
(155) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518634))) 0.0002748966217041
(156) DESCRIBE `sailingdates` 0.0010759830474854
(157) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518635))) 0.00036287307739258
(158) DESCRIBE `sailingdates` 0.0015041828155518
(159) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518637))) 0.00038504600524902
(160) DESCRIBE `sailingdates` 0.0014829635620117
(161) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518639))) 0.00031590461730957
(162) DESCRIBE `sailingdates` 0.0014479160308838
(163) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518640))) 0.00027203559875488
(164) DESCRIBE `sailingdates` 0.0011589527130127
(165) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518641))) 0.00030994415283203
(166) DESCRIBE `sailingdates` 0.00052189826965332
(167) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518642))) 0.00031399726867676
(168) DESCRIBE `sailingdates` 0.001209020614624
(169) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518643))) 0
(170) DESCRIBE `sailingdates` 0.0010340213775635
(171) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518644))) 0.0002601146697998
(172) DESCRIBE `sailingdates` 0.001168966293335
(173) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518645))) 0
(174) DESCRIBE `sailingdates` 0.0013351440429688
(175) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518646))) 0.00028705596923828
(176) DESCRIBE `sailingdates` 0.0012412071228027
(177) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518647))) 0.00026202201843262
(178) DESCRIBE `sailingdates` 0.0011799335479736
(179) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518648))) 0.00030994415283203
(180) DESCRIBE `sailingdates` 0.00062298774719238
(181) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518649))) 0.00028800964355469
(182) DESCRIBE `sailingdates` 0.0018160343170166
(183) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518650))) 0.00015687942504883
(184) DESCRIBE `sailingdates` 0.001115083694458
(185) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518651))) 0.00026202201843262
(186) DESCRIBE `sailingdates` 0.0013699531555176
(187) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518652))) 0.00028300285339355
(188) DESCRIBE `sailingdates` 0.0011379718780518
(189) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518653))) 0.00026178359985352
(190) DESCRIBE `sailingdates` 0.001176118850708
(191) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518655))) 0.00026512145996094
(192) DESCRIBE `sailingdates` 0.0011000633239746
(193) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518656))) 0.0003359317779541
(194) DESCRIBE `sailingdates` 0.0010910034179688
(195) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518657))) 0.0002598762512207
(196) DESCRIBE `sailingdates` 0.0010960102081299
(197) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518658))) 0.00026607513427734
(198) DESCRIBE `sailingdates` 0.0011029243469238
(199) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518659))) 0.00034809112548828
(200) DESCRIBE `sailingdates` 0.0011498928070068
(201) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518660))) 4.5061111450195E-5
(202) DESCRIBE `sailingdates` 0.0011329650878906
(203) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518661))) 0.00026798248291016
(204) DESCRIBE `sailingdates` 0.0011270046234131
(205) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518662))) 6.9141387939453E-6
(206) DESCRIBE `sailingdates` 0.0011398792266846
(207) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518663))) 0.00028204917907715
(208) DESCRIBE `ports` 0.0013470649719238
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00028896331787109
(210) DESCRIBE `ports` 0.0012781620025635
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00029587745666504
(212) DESCRIBE `ports` 0.0012450218200684
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00028085708618164
(214) DESCRIBE `ports` 0.001284122467041
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.0007939338684082
(216) DESCRIBE `ports` 0.00082993507385254
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00028085708618164
(218) DESCRIBE `ports` 0.0012578964233398
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0
(220) DESCRIBE `ports` 0.0011990070343018
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00028014183044434
(222) DESCRIBE `ports` 0.0017809867858887
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00018692016601562
(224) DESCRIBE `ports` 0.0012249946594238
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00028586387634277
(226) DESCRIBE `ports` 0.0014171600341797
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00035309791564941
(228) DESCRIBE `ports` 0.001276969909668
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0003659725189209
(230) DESCRIBE `ports` 0.0016109943389893
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00032997131347656
(232) DESCRIBE `ports` 0.00130295753479
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00031900405883789
(234) DESCRIBE `ports` 0.0012378692626953
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00026798248291016
(236) DESCRIBE `ports` 0.0013041496276855
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00029587745666504
(238) DESCRIBE `ports` 0.0012869834899902
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00033116340637207
(240) DESCRIBE `ports` 0.0016260147094727
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00030279159545898
(242) DESCRIBE `ports` 0.0015017986297607
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00034093856811523
(244) DESCRIBE `cruises` 0.0024380683898926
(245) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11516))) 0.00061202049255371
(246) DESCRIBE `avid_specials` 0.0014350414276123
(247) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541793 and class = 'Special') OR (item_id = 11516 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011389255523682
(248) DESCRIBE `cruiselines` 0.0017900466918945
(249) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00030899047851562
(250) DESCRIBE `orchid_image` 0.0013852119445801
(251) DESCRIBE `cruiselines` 0.0017919540405273
(252) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00027298927307129
(253) DESCRIBE `specials` 0.0040261745452881
(254) SELECT `specials`.* FROM `specials` WHERE (id = '1541766') AND (specials.orchid_available = 1) LIMIT 1 0.00044703483581543
(255) DESCRIBE `specials` 0.0038528442382812
(256) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541766') 0.00034904479980469
(257) DESCRIBE `ships` 0.0026090145111084
(258) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 520))) 0.00038695335388184
(259) DESCRIBE `ships` 0.0024020671844482
(260) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '520') 0.00036501884460449
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028491020202637
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(263) DESCRIBE `itineraries` 0.0012350082397461
(264) DESCRIBE `ports` 0.0012609958648682
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00031208992004395
(266) DESCRIBE `ports` 0.0013360977172852
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.0003049373626709
(268) DESCRIBE `ports` 0.0012710094451904
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00033092498779297
(270) DESCRIBE `specialsailingdates` 0.0011379718780518
(271) DESCRIBE `sailingdates` 0.00066709518432617
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518703))) 0.00036001205444336
(273) DESCRIBE `sailingdates` 0.0011839866638184
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518707))) 0.00091195106506348
(275) DESCRIBE `sailingdates` 0.00082802772521973
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518708))) 0.00026893615722656
(277) DESCRIBE `sailingdates` 0.0010948181152344
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518710))) 0
(279) DESCRIBE `sailingdates` 0.0010910034179688
(280) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518711))) 0.00026297569274902
(281) DESCRIBE `sailingdates` 0.0018379688262939
(282) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518713))) 0
(283) DESCRIBE `sailingdates` 0.0011148452758789
(284) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518715))) 0.00027585029602051
(285) DESCRIBE `sailingdates` 0.0015277862548828
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518716))) 0.00026392936706543
(287) DESCRIBE `sailingdates` 0.0011520385742188
(288) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518718))) 0.00026583671569824
(289) DESCRIBE `sailingdates` 0.0011470317840576
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518721))) 0.00026702880859375
(291) DESCRIBE `sailingdates` 0.0010900497436523
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518722))) 0.00027179718017578
(293) DESCRIBE `sailingdates` 0.0010950565338135
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518723))) 0.00030207633972168
(295) DESCRIBE `sailingdates` 0.0011041164398193
(296) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518724))) 0.00029492378234863
(297) DESCRIBE `sailingdates` 0.0015549659729004
(298) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518725))) 0.00034284591674805
(299) DESCRIBE `sailingdates` 0.0011799335479736
(300) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518726))) 0.00035881996154785
(301) DESCRIBE `sailingdates` 0.001492977142334
(302) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518727))) 0.00036907196044922
(303) DESCRIBE `sailingdates` 0.0015461444854736
(304) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518728))) 0.00035595893859863
(305) DESCRIBE `sailingdates` 0.002249002456665
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518729))) 0.00029182434082031
(307) DESCRIBE `sailingdates` 0.0011498928070068
(308) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518730))) 0.0003209114074707
(309) DESCRIBE `sailingdates` 0.0012321472167969
(310) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518731))) 0.00027704238891602
(311) DESCRIBE `sailingdates` 0.0011138916015625
(312) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518732))) 0.00030207633972168
(313) DESCRIBE `sailingdates` 0.0011060237884521
(314) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518733))) 0.00027084350585938
(315) DESCRIBE `sailingdates` 0.0011379718780518
(316) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518734))) 0.00026988983154297
(317) DESCRIBE `sailingdates` 0.0010921955108643
(318) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518735))) 0.00027298927307129
(319) DESCRIBE `sailingdates` 0.0012929439544678
(320) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518736))) 0.00035309791564941
(321) DESCRIBE `sailingdates` 0.001154899597168
(322) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518737))) 0.00028610229492188
(323) DESCRIBE `sailingdates` 0.0012030601501465
(324) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518738))) 0.00027108192443848
(325) DESCRIBE `ports` 0.0013270378112793
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00032210350036621
(327) DESCRIBE `ports` 0.0012850761413574
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00029802322387695
(329) DESCRIBE `ports` 0.0013949871063232
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00029397010803223
(331) DESCRIBE `ports` 0.0012481212615967
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.0002751350402832
(333) DESCRIBE `ports` 0.0012929439544678
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00028800964355469
(335) DESCRIBE `ports` 0.0016050338745117
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00037789344787598
(337) DESCRIBE `ports` 0.001378059387207
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00033783912658691
(339) DESCRIBE `ports` 0.0014259815216064
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00037312507629395
(341) DESCRIBE `ports` 0.001284122467041
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00032401084899902
(343) DESCRIBE `ports` 0.0013289451599121
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00028109550476074
(345) DESCRIBE `ports` 0.0013358592987061
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00038695335388184
(347) DESCRIBE `ports` 0.0010490417480469
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00030207633972168
(349) DESCRIBE `ports` 0.0013101100921631
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00029397010803223
(351) DESCRIBE `ports` 0.0013308525085449
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00053310394287109
(353) DESCRIBE `ports` 0.0015978813171387
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0003359317779541
(355) DESCRIBE `ports` 0.0014388561248779
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00029516220092773
(357) DESCRIBE `cruises` 0.0027539730072021
(358) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65943))) 0.00039386749267578
(359) DESCRIBE `avid_specials` 0.0012791156768799
(360) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541766 and class = 'Special') OR (item_id = 65943 and class = 'Cruise') OR (item_id = 520 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015552043914795
(361) DESCRIBE `cruiselines` 0.0020298957824707
(362) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00034785270690918
(363) DESCRIBE `orchid_image` 0.0014350414276123
(364) DESCRIBE `cruiselines` 0.0017549991607666
(365) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00029087066650391
(366) DESCRIBE `specials` 0.0041489601135254
(367) SELECT `specials`.* FROM `specials` WHERE (id = '1541775') AND (specials.orchid_available = 1) LIMIT 1 0.00058388710021973
(368) DESCRIBE `specials` 0.0039181709289551
(369) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541775') 0.00032401084899902
(370) DESCRIBE `ships` 0.0026860237121582
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 520))) 0.00036787986755371
(372) DESCRIBE `ships` 0.0025320053100586
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '520') 0.00028300285339355
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027012825012207
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029897689819336
(376) DESCRIBE `itineraries` 0.001338005065918
(377) DESCRIBE `ports` 0.0014898777008057
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0003669261932373
(379) DESCRIBE `ports` 0.0014898777008057
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00033998489379883
(381) DESCRIBE `ports` 0.00142502784729
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00029587745666504
(383) DESCRIBE `specialsailingdates` 0.0011839866638184
(384) DESCRIBE `sailingdates` 0.001352071762085
(385) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518664))) 0.00036501884460449
(386) DESCRIBE `sailingdates` 0.0012459754943848
(387) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518668))) 0.00028204917907715
(388) DESCRIBE `sailingdates` 0.0016169548034668
(389) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518669))) 0.0003819465637207
(390) DESCRIBE `sailingdates` 0.0015590190887451
(391) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518671))) 0.00037598609924316
(392) DESCRIBE `sailingdates` 0.001460075378418
(393) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518672))) 0.00033092498779297
(394) DESCRIBE `sailingdates` 0.0011050701141357
(395) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518673))) 0.00027298927307129
(396) DESCRIBE `sailingdates` 0.0010988712310791
(397) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518674))) 0.00029897689819336
(398) DESCRIBE `sailingdates` 0.0010988712310791
(399) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518676))) 0.00026988983154297
(400) DESCRIBE `sailingdates` 0.0011279582977295
(401) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518677))) 0.00027012825012207
(402) DESCRIBE `sailingdates` 0.0010988712310791
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518678))) 0.00028705596923828
(404) DESCRIBE `sailingdates` 0.0011749267578125
(405) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518679))) 0.00027012825012207
(406) DESCRIBE `sailingdates` 0.0010960102081299
(407) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518680))) 0.00032305717468262
(408) DESCRIBE `sailingdates` 0.0012130737304688
(409) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518681))) 0.00026893615722656
(410) DESCRIBE `sailingdates` 0.001471996307373
(411) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518682))) 0.00029683113098145
(412) DESCRIBE `sailingdates` 0.0014340877532959
(413) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518683))) 0.00027918815612793
(414) DESCRIBE `sailingdates` 0.0011439323425293
(415) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518686))) 0.00027203559875488
(416) DESCRIBE `sailingdates` 0.0012049674987793
(417) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518687))) 0.00032997131347656
(418) DESCRIBE `sailingdates` 0.00025105476379395
(419) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518688))) 0.00028014183044434
(420) DESCRIBE `sailingdates` 0.0011060237884521
(421) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518696))) 0.00027203559875488
(422) DESCRIBE `sailingdates` 0.00037598609924316
(423) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518697))) 0.00031208992004395
(424) DESCRIBE `sailingdates` 0.0012071132659912
(425) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518698))) 0.0008699893951416
(426) DESCRIBE `sailingdates` 0.00085806846618652
(427) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518699))) 0.00027084350585938
(428) DESCRIBE `sailingdates` 0.0011019706726074
(429) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518700))) 0
(430) DESCRIBE `sailingdates` 0.0011708736419678
(431) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518701))) 0.00030398368835449
(432) DESCRIBE `ports` 0.0013659000396729
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00029683113098145
(434) DESCRIBE `ports` 0.0012948513031006
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00027704238891602
(436) DESCRIBE `ports` 0.0016889572143555
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00034093856811523
(438) DESCRIBE `ports` 0.0012810230255127
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00029611587524414
(440) DESCRIBE `ports` 0.0013298988342285
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00028681755065918
(442) DESCRIBE `ports` 0.0013601779937744
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00031900405883789
(444) DESCRIBE `ports` 0.0012779235839844
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.0002901554107666
(446) DESCRIBE `ports` 0.0015239715576172
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.0002901554107666
(448) DESCRIBE `ports` 0.0013232231140137
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00031590461730957
(450) DESCRIBE `ports` 0.0013129711151123
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00027990341186523
(452) DESCRIBE `ports` 0.001288890838623
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00032496452331543
(454) DESCRIBE `ports` 0.0012619495391846
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00028586387634277
(456) DESCRIBE `ports` 0.0013868808746338
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.0002901554107666
(458) DESCRIBE `ports` 0.00124192237854
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.0002739429473877
(460) DESCRIBE `ports` 0.0012581348419189
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.0003659725189209
(462) DESCRIBE `ports` 0.0013279914855957
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00031590461730957
(464) DESCRIBE `ports` 0.0014841556549072
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00031399726867676
(466) DESCRIBE `ports` 0.0015850067138672
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00029993057250977
(468) DESCRIBE `cruises` 0.0030481815338135
(469) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65945))) 0.00045919418334961
(470) DESCRIBE `avid_specials` 0.0012059211730957
(471) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541775 and class = 'Special') OR (item_id = 65945 and class = 'Cruise') OR (item_id = 520 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010361671447754
(472) DESCRIBE `cruiselines` 0.0019040107727051
(473) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00039005279541016
(474) DESCRIBE `orchid_image` 0.0014019012451172
(475) DESCRIBE `cruiselines` 0.0018401145935059
(476) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00035190582275391
(477) DESCRIBE `specials` 0.0046701431274414
(478) SELECT `specials`.* FROM `specials` WHERE (id = '1541844') AND (specials.orchid_available = 1) LIMIT 1 0.00062108039855957
(479) DESCRIBE `specials` 0.0043540000915527
(480) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541844') 0.00031304359436035
(481) DESCRIBE `ships` 0.0025980472564697
(482) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 701))) 0.00034093856811523
(483) DESCRIBE `ships` 0.0024888515472412
(484) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0.00028705596923828
(485) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(486) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(487) DESCRIBE `itineraries` 0.0014889240264893
(488) DESCRIBE `ports` 0.0016689300537109
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00032210350036621
(490) DESCRIBE `ports` 0.0013079643249512
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.0002901554107666
(492) DESCRIBE `ports` 0.0012547969818115
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00028014183044434
(494) DESCRIBE `specialsailingdates` 0.0010850429534912
(495) DESCRIBE `sailingdates` 0.001105785369873
(496) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518782))) 0.00030803680419922
(497) DESCRIBE `sailingdates` 0.0011301040649414
(498) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518785))) 0.00027179718017578
(499) DESCRIBE `sailingdates` 0.0011019706726074
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518786))) 0.00027608871459961
(501) DESCRIBE `sailingdates` 0.0010941028594971
(502) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518787))) 0.00026893615722656
(503) DESCRIBE `sailingdates` 0.0011200904846191
(504) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518788))) 0.00026917457580566
(505) DESCRIBE `sailingdates` 0.0011060237884521
(506) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518789))) 0.00028204917907715
(507) DESCRIBE `sailingdates` 0.0012049674987793
(508) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518791))) 0.00026917457580566
(509) DESCRIBE `sailingdates` 0.0011551380157471
(510) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518792))) 0.00027990341186523
(511) DESCRIBE `ports` 0.001291036605835
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00030303001403809
(513) DESCRIBE `ports` 0.0012669563293457
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.0002899169921875
(515) DESCRIBE `ports` 0.0013508796691895
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00028800964355469
(517) DESCRIBE `ports` 0.0012660026550293
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00027298927307129
(519) DESCRIBE `ports` 0.0012571811676025
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00030803680419922
(521) DESCRIBE `ports` 0.0013530254364014
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00027298927307129
(523) DESCRIBE `ports` 0.0013439655303955
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00030207633972168
(525) DESCRIBE `ports` 0.0013132095336914
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00032305717468262
(527) DESCRIBE `ports` 0.0012798309326172
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00028705596923828
(529) DESCRIBE `ports` 0.0012421607971191
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00028395652770996
(531) DESCRIBE `ports` 0.0013120174407959
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00029110908508301
(533) DESCRIBE `ports` 0.0015089511871338
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.0002739429473877
(535) DESCRIBE `ports` 0.0013039112091064
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.0003058910369873
(537) DESCRIBE `ports` 0.0012669563293457
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00027203559875488
(539) DESCRIBE `ports` 0.0012328624725342
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0003669261932373
(541) DESCRIBE `ports` 0.0014021396636963
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00032997131347656
(543) DESCRIBE `cruises` 0.0041029453277588
(544) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 49093))) 0.00053501129150391
(545) DESCRIBE `avid_specials` 0.0019218921661377
(546) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541844 and class = 'Special') OR (item_id = 49093 and class = 'Cruise') OR (item_id = 701 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011210441589355
(547) DESCRIBE `cruiselines` 0.0020380020141602
(548) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00045895576477051
(549) DESCRIBE `orchid_image` 0.0015041828155518
(550) DESCRIBE `cruiselines` 0.0018370151519775
(551) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0002901554107666
(552) DESCRIBE `specials` 0.0039470195770264
(553) SELECT `specials`.* FROM `specials` WHERE (id = '1541854') AND (specials.orchid_available = 1) LIMIT 1 0.00055193901062012
(554) DESCRIBE `specials` 0.003838062286377
(555) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541854') 0.00029110908508301
(556) DESCRIBE `ships` 0.0025088787078857
(557) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 701))) 0.00034499168395996
(558) DESCRIBE `ships` 0.0029540061950684
(559) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0
(560) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032806396484375
(561) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0
(562) DESCRIBE `itineraries` 0.0012609958648682
(563) DESCRIBE `ports` 0.0012991428375244
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0
(565) DESCRIBE `ports` 0.001255989074707
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00036406517028809
(567) DESCRIBE `ports` 0.0016119480133057
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00034213066101074
(569) DESCRIBE `specialsailingdates` 0.0011138916015625
(570) DESCRIBE `sailingdates` 0.0011157989501953
(571) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518818))) 0.00030684471130371
(572) DESCRIBE `sailingdates` 0.0011658668518066
(573) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518819))) 0.0010921955108643
(574) DESCRIBE `sailingdates` 0.00073599815368652
(575) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518820))) 0.00026798248291016
(576) DESCRIBE `sailingdates` 0.0010991096496582
(577) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518821))) 0
(578) DESCRIBE `sailingdates` 0.0010340213775635
(579) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518822))) 0.00026392936706543
(580) DESCRIBE `sailingdates` 0.0019779205322266
(581) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518823))) 0
(582) DESCRIBE `sailingdates` 0.0017299652099609
(583) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518825))) 0.0001990795135498
(584) DESCRIBE `sailingdates` 0.0016388893127441
(585) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518826))) 9.1075897216797E-5
(586) DESCRIBE `ports` 0.0013148784637451
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00035810470581055
(588) DESCRIBE `ports` 0.0012338161468506
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.0003361701965332
(590) DESCRIBE `ports` 0.00045108795166016
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.0010972023010254
(592) DESCRIBE `ports` 0.00066399574279785
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00026607513427734
(594) DESCRIBE `ports` 0.0012369155883789
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0
(596) DESCRIBE `ports` 0.001701831817627
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00027298927307129
(598) DESCRIBE `ports` 0.0013611316680908
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00035190582275391
(600) DESCRIBE `ports` 0.0012869834899902
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0
(602) DESCRIBE `ports` 0.00087785720825195
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00029802322387695
(604) DESCRIBE `ports` 0.0019488334655762
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 6.7949295043945E-5
(606) DESCRIBE `ports` 0.0013511180877686
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00029706954956055
(608) DESCRIBE `ports` 0.0013320446014404
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00034403800964355
(610) DESCRIBE `ports` 0.0023279190063477
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00032591819763184
(612) DESCRIBE `ports` 0.0013191699981689
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00027608871459961
(614) DESCRIBE `ports` 0.0015218257904053
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00029706954956055
(616) DESCRIBE `ports` 0.0013041496276855
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.0002748966217041
(618) DESCRIBE `ports` 0.0013420581817627
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00028491020202637
(620) DESCRIBE `ports` 0.0012950897216797
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00029301643371582
(622) DESCRIBE `cruises` 0.0025238990783691
(623) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 56009))) 0.00039792060852051
(624) DESCRIBE `avid_specials` 0.00055813789367676
(625) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541854 and class = 'Special') OR (item_id = 56009 and class = 'Cruise') OR (item_id = 701 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001690149307251
(626) DESCRIBE `cruiselines` 0.0014638900756836
(627) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00030279159545898
(628) DESCRIBE `orchid_image` 0.0015108585357666
(629) DESCRIBE `cruiselines` 0.0020699501037598
(630) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0002899169921875
(631) DESCRIBE `specials` 0.0045487880706787
(632) SELECT `specials`.* FROM `specials` WHERE (id = '1586138') AND (specials.orchid_available = 1) LIMIT 1 0.00031805038452148
(633) DESCRIBE `specials` 0.0040929317474365
(634) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1586138') 0.00036501884460449
(635) DESCRIBE `ships` 0.0027010440826416
(636) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1519))) 0.00052499771118164
(637) DESCRIBE `ships` 0.0029599666595459
(638) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1519') 0.00032401084899902
(639) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00099515914916992
(640) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0
(641) DESCRIBE `itineraries` 0.0012929439544678
(642) DESCRIBE `ports` 0.00046396255493164
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4805))) 0.00029802322387695
(644) DESCRIBE `ports` 0.0014309883117676
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4805))) 0
(646) DESCRIBE `ports` 0.0020051002502441
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4805') 8.8930130004883E-5
(648) DESCRIBE `specialsailingdates` 0.0012269020080566
(649) DESCRIBE `sailingdates` 0.0015139579772949
(650) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 529823))) 0.00055313110351562
(651) DESCRIBE `ports` 0.0017158985137939
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4805))) 0.00038695335388184
(653) DESCRIBE `ports` 0.0017411708831787
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4805') 0.00034999847412109
(655) DESCRIBE `ports` 0.001629114151001
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00035691261291504
(657) DESCRIBE `ports` 0.0015830993652344
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00034904479980469
(659) DESCRIBE `ports` 0.0016169548034668
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4808))) 0.00042200088500977
(661) DESCRIBE `ports` 0.0013740062713623
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4808') 0.00027108192443848
(663) DESCRIBE `ports` 0.0013070106506348
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5539))) 0.00035405158996582
(665) DESCRIBE `ports` 0.0016889572143555
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5539') 0.00027585029602051
(667) DESCRIBE `ports` 0.0013461112976074
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5540))) 0.00029301643371582
(669) DESCRIBE `ports` 0.001378059387207
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5540') 0.00028085708618164
(671) DESCRIBE `ports` 0.0014989376068115
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00041699409484863
(673) DESCRIBE `ports` 0.0015888214111328
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.0002739429473877
(675) DESCRIBE `ports` 0.0013251304626465
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4811))) 0.00032305717468262
(677) DESCRIBE `ports` 0.0015621185302734
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4811') 0.00033307075500488
(679) DESCRIBE `ports` 0.001352071762085
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4812))) 0.00028395652770996
(681) DESCRIBE `ports` 0.0014121532440186
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4812') 0.00031495094299316
(683) DESCRIBE `ports` 0.00069904327392578
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6191))) 0
(685) DESCRIBE `ports` 0.0012719631195068
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6191') 0.00026702880859375
(687) DESCRIBE `ports` 0.0017051696777344
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4911))) 0.00029087066650391
(689) DESCRIBE `ports` 0.0012979507446289
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4911') 0.00033187866210938
(691) DESCRIBE `ports` 0.0013120174407959
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4911))) 0.00035500526428223
(693) DESCRIBE `ports` 0.0012621879577637
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4911') 0
(695) DESCRIBE `cruises` 0.0021100044250488
(696) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65739))) 0
(697) DESCRIBE `avid_specials` 0.001237154006958
(698) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1586138 and class = 'Special') OR (item_id = 65739 and class = 'Cruise') OR (item_id = 1519 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022320747375488
(699) DESCRIBE `cruiselines` 0.0010271072387695
(700) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00034999847412109
(701) DESCRIBE `orchid_image` 0.0027711391448975
(702) DESCRIBE `cruiselines` 0.0019040107727051
(703) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00038886070251465
(704) DESCRIBE `specials` 0.0039701461791992
(705) SELECT `specials`.* FROM `specials` WHERE (id = '1541872') AND (specials.orchid_available = 1) LIMIT 1 0.00050592422485352
(706) DESCRIBE `specials` 0.0040340423583984
(707) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541872') 0.00035595893859863
(708) DESCRIBE `ships` 0.0023431777954102
(709) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 627))) 0.0003960132598877
(710) DESCRIBE `ships` 0.0026040077209473
(711) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '627') 0.00028300285339355
(712) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(713) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025582313537598
(714) DESCRIBE `itineraries` 0.0015878677368164
(715) DESCRIBE `ports` 0.0020289421081543
(716) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0002129077911377
(717) DESCRIBE `ports` 0.0013151168823242
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00035214424133301
(719) DESCRIBE `ports` 0.0013010501861572
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00034403800964355
(721) DESCRIBE `specialsailingdates` 0.0010480880737305
(722) DESCRIBE `sailingdates` 0.001176118850708
(723) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518831))) 0.0003199577331543
(724) DESCRIBE `sailingdates` 0.0014591217041016
(725) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518833))) 0.00028395652770996
(726) DESCRIBE `sailingdates` 0.001183032989502
(727) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518834))) 0.00027084350585938
(728) DESCRIBE `sailingdates` 0.0011100769042969
(729) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518835))) 0.00026798248291016
(730) DESCRIBE `sailingdates` 0.0011169910430908
(731) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518836))) 0.0011801719665527
(732) DESCRIBE `sailingdates` 0.00065708160400391
(733) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518837))) 0.00033998489379883
(734) DESCRIBE `sailingdates` 0.0018448829650879
(735) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518838))) 0.00018715858459473
(736) DESCRIBE `sailingdates` 0.0011899471282959
(737) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518841))) 0.00028204917907715
(738) DESCRIBE `sailingdates` 0.0011470317840576
(739) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518842))) 0.00026893615722656
(740) DESCRIBE `sailingdates` 0.0011129379272461
(741) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518843))) 0.0010819435119629
(742) DESCRIBE `sailingdates` 0.00085210800170898
(743) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518844))) 0.00027108192443848
(744) DESCRIBE `sailingdates` 0.0011610984802246
(745) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518845))) 0
(746) DESCRIBE `sailingdates` 0.001162052154541
(747) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518846))) 0.00027799606323242
(748) DESCRIBE `sailingdates` 0.0014779567718506
(749) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518847))) 0.00027990341186523
(750) DESCRIBE `sailingdates` 0.0011489391326904
(751) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518848))) 0.00028014183044434
(752) DESCRIBE `ports` 0.00072312355041504
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00039196014404297
(754) DESCRIBE `ports` 0.0020020008087158
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00014305114746094
(756) DESCRIBE `ports` 0.00130295753479
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00030708312988281
(758) DESCRIBE `ports` 0.001309871673584
(759) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.0002748966217041
(760) DESCRIBE `ports` 0.0012710094451904
(761) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00032496452331543
(762) DESCRIBE `ports` 0.00055193901062012
(763) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00027990341186523
(764) DESCRIBE `ports` 0.0012500286102295
(765) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0
(766) DESCRIBE `ports` 0.0010509490966797
(767) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00027203559875488
(768) DESCRIBE `ports` 0.0019748210906982
(769) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.0001990795135498
(770) DESCRIBE `ports` 0.0014040470123291
(771) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00030398368835449
(772) DESCRIBE `ports` 0.0013549327850342
(773) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00032401084899902
(774) DESCRIBE `ports` 0.0012590885162354
(775) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00028705596923828
(776) DESCRIBE `ports` 0.0013530254364014
(777) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00029206275939941
(778) DESCRIBE `ports` 0.001298189163208
(779) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00027990341186523
(780) DESCRIBE `ports` 0.0012571811676025
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00035691261291504
(782) DESCRIBE `ports` 0.0014028549194336
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.0003199577331543
(784) DESCRIBE `ports` 0.0013408660888672
(785) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00033283233642578
(786) DESCRIBE `ports` 0.0014438629150391
(787) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00034689903259277
(788) DESCRIBE `cruises` 0.0025238990783691
(789) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82484))) 0.00042200088500977
(790) DESCRIBE `avid_specials` 0.0011870861053467
(791) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541872 and class = 'Special') OR (item_id = 82484 and class = 'Cruise') OR (item_id = 627 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011229515075684
(792) DESCRIBE `cruiselines` 0.0019140243530273
(793) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00033307075500488
(794) DESCRIBE `orchid_image` 0.0015430450439453
(795) DESCRIBE `cruiselines` 0.0026230812072754
(796) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0004279613494873
(797) DESCRIBE `specials` 0.0047481060028076
(798) SELECT `specials`.* FROM `specials` WHERE (id = '1541863') AND (specials.orchid_available = 1) LIMIT 1 0.00075984001159668
(799) DESCRIBE `specials` 0.0044519901275635
(800) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541863') 0.00040698051452637
(801) DESCRIBE `ships` 0.0027539730072021
(802) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 627))) 0.00038504600524902
(803) DESCRIBE `ships` 0.0026340484619141
(804) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '627') 0.00032901763916016
(805) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030708312988281
(806) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002591609954834
(807) DESCRIBE `itineraries` 0.0014219284057617
(808) DESCRIBE `ports` 0.0014979839324951
(809) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00032496452331543
(810) DESCRIBE `ports` 0.0012528896331787
(811) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00028896331787109
(812) DESCRIBE `ports` 0.0013439655303955
(813) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00029397010803223
(814) DESCRIBE `specialsailingdates` 0.0011329650878906
(815) DESCRIBE `sailingdates` 0.0011940002441406
(816) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518796))) 0.00031614303588867
(817) DESCRIBE `sailingdates` 0.0011060237884521
(818) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518797))) 0.00034093856811523
(819) DESCRIBE `sailingdates` 0.0011148452758789
(820) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518798))) 0.00028181076049805
(821) DESCRIBE `sailingdates` 0.0011370182037354
(822) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518799))) 0.00027894973754883
(823) DESCRIBE `sailingdates` 0.0011091232299805
(824) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518800))) 0.00028014183044434
(825) DESCRIBE `sailingdates` 0.0012319087982178
(826) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518801))) 0.00026822090148926
(827) DESCRIBE `sailingdates` 0.0011329650878906
(828) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518802))) 0.00027894973754883
(829) DESCRIBE `sailingdates` 0.0012028217315674
(830) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518803))) 0.00029516220092773
(831) DESCRIBE `sailingdates` 0.001115083694458
(832) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518804))) 0.00026988983154297
(833) DESCRIBE `sailingdates` 0.0011129379272461
(834) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518806))) 0.00029301643371582
(835) DESCRIBE `sailingdates` 0.0011780261993408
(836) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518807))) 0.00098204612731934
(837) DESCRIBE `sailingdates` 0.00071191787719727
(838) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518808))) 0.00026893615722656
(839) DESCRIBE `sailingdates` 0.0013899803161621
(840) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518809))) 0.00027799606323242
(841) DESCRIBE `sailingdates` 0.0011510848999023
(842) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518810))) 0.00026893615722656
(843) DESCRIBE `sailingdates` 0.0011241436004639
(844) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518811))) 0.00027990341186523
(845) DESCRIBE `sailingdates` 0.0011639595031738
(846) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518812))) 0.00090885162353516
(847) DESCRIBE `sailingdates` 0.00093722343444824
(848) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518813))) 0.00028204917907715
(849) DESCRIBE `sailingdates` 0.0011391639709473
(850) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518814))) 0.0005948543548584
(851) DESCRIBE `ports` 0.0015900135040283
(852) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00019693374633789
(853) DESCRIBE `ports` 0.00187087059021
(854) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 2.2172927856445E-5
(855) DESCRIBE `ports` 0.0015878677368164
(856) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00039410591125488
(857) DESCRIBE `ports` 0.0010538101196289
(858) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.0002739429473877
(859) DESCRIBE `ports` 0.002047061920166
(860) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 1.6927719116211E-5
(861) DESCRIBE `ports` 0.00180983543396
(862) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00027704238891602
(863) DESCRIBE `ports` 0.0012950897216797
(864) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00031590461730957
(865) DESCRIBE `ports` 0.0012898445129395
(866) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00085186958312988
(867) DESCRIBE `ports` 0.00097107887268066
(868) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00028681755065918
(869) DESCRIBE `ports` 0.0019559860229492
(870) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 6.9141387939453E-6
(871) DESCRIBE `ports` 0.0012660026550293
(872) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00028610229492188
(873) DESCRIBE `ports` 0.0014188289642334
(874) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00027108192443848
(875) DESCRIBE `ports` 0.0012660026550293
(876) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00029492378234863
(877) DESCRIBE `ports` 0.0012588500976562
(878) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00027084350585938
(879) DESCRIBE `ports` 0.0012679100036621
(880) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00036716461181641
(881) DESCRIBE `ports` 0.0012531280517578
(882) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00032496452331543
(883) DESCRIBE `cruises` 0.0025501251220703
(884) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82483))) 0.00053596496582031
(885) DESCRIBE `avid_specials` 0.0012350082397461
(886) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541863 and class = 'Special') OR (item_id = 82483 and class = 'Cruise') OR (item_id = 627 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016269683837891
(887) DESCRIBE `cruiselines` 0.0026068687438965
(888) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0005950927734375
(889) DESCRIBE `orchid_image` 0.0016460418701172
(890) DESCRIBE `cruiselines` 0.0017788410186768
(891) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00028800964355469
(892) DESCRIBE `ships` 0.0026178359985352
(893) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '627', '701', '1519')) ORDER BY FIND_IN_SET(id, '521,520,627,701,1519') 0.0010499954223633
(894) DESCRIBE `cruisetypes` 0.0012640953063965
(895) DESCRIBE `destinations` 0.0021638870239258
(896) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54')) ORDER BY FIND_IN_SET(id, '54') 0.00038886070251465
(897) DESCRIBE `cruiselines` 0.0019571781158447
(898) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00032711029052734
(899) DESCRIBE `cruiselines` 0.0027499198913574
(900) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00018882751464844