or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 0.96939945220947

# Query Time
(1) connect 0.00095415115356445
(2) DESCRIBE `cruises` 0.0032298564910889
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 71399, 71400, 11517, 71401, 11516, 73726, 36197, 78187, 36197)) ORDER BY FIND_IN_SET(id, '45259,71399,71400,11517,71401,11516,73726,36197,78187,36197') 0.0013720989227295
(4) DESCRIBE `specials` 0.0052061080932617
(5) DESCRIBE `specials` 0.0044269561767578
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1550505') 0.00091791152954102
(7) DESCRIBE `ships` 0.0026750564575195
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00042200088500977
(9) DESCRIBE `ships` 0.0036420822143555
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00048017501831055
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036191940307617
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033783912658691
(13) DESCRIBE `itineraries` 0.0018630027770996
(14) DESCRIBE `ports` 0.0019748210906982
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045990943908691
(16) DESCRIBE `ports` 0.001878023147583
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045394897460938
(18) DESCRIBE `ports` 0.0017960071563721
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00037312507629395
(20) DESCRIBE `specialsailingdates` 0.0015411376953125
(21) DESCRIBE `sailingdates` 0.0017318725585938
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504320))) 0.00057697296142578
(23) DESCRIBE `sailingdates` 0.0017430782318115
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504324))) 0.00040388107299805
(25) DESCRIBE `sailingdates` 0.0015738010406494
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504328))) 0.00036406517028809
(27) DESCRIBE `sailingdates` 0.0015740394592285
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504331))) 0.00035500526428223
(29) DESCRIBE `sailingdates` 0.0015769004821777
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504333))) 0.00036907196044922
(31) DESCRIBE `sailingdates` 0.00160813331604
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504334))) 0.00038695335388184
(33) DESCRIBE `sailingdates` 0.0014910697937012
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504335))) 0.00036191940307617
(35) DESCRIBE `sailingdates` 0.0014998912811279
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504336))) 0.0004279613494873
(37) DESCRIBE `sailingdates` 0.0016219615936279
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504337))) 0.00041389465332031
(39) DESCRIBE `sailingdates` 0.0017061233520508
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504338))) 0.00041985511779785
(41) DESCRIBE `sailingdates` 0.0017068386077881
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504339))) 0.00039887428283691
(43) DESCRIBE `ports` 0.0018908977508545
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00044703483581543
(45) DESCRIBE `ports` 0.0019021034240723
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00039005279541016
(47) DESCRIBE `ports` 0.0018799304962158
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00046420097351074
(49) DESCRIBE `ports` 0.001878023147583
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00040388107299805
(51) DESCRIBE `ports` 0.0018799304962158
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00051689147949219
(53) DESCRIBE `ports` 0.0021519660949707
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00040388107299805
(55) DESCRIBE `ports` 0.001762866973877
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00043296813964844
(57) DESCRIBE `ports` 0.0018360614776611
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.0004270076751709
(59) DESCRIBE `ports` 0.0019879341125488
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044798851013184
(61) DESCRIBE `ports` 0.0019478797912598
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00039505958557129
(63) DESCRIBE `ports` 0.0018610954284668
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00041913986206055
(65) DESCRIBE `ports` 0.0018069744110107
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00046014785766602
(67) DESCRIBE `cruises` 0.0038230419158936
(68) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00066995620727539
(69) DESCRIBE `avid_specials` 0.0017728805541992
(70) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1550505 and class = 'Special') OR (item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018150806427002
(71) DESCRIBE `cruiselines` 0.002924919128418
(72) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00049805641174316
(73) DESCRIBE `orchid_image` 0.0021531581878662
(74) DESCRIBE `cruiselines` 0.0028071403503418
(75) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00043106079101562
(76) DESCRIBE `specials` 0.0052599906921387
(77) SELECT `specials`.* FROM `specials` WHERE (id = '1541086') AND (specials.orchid_available = 1) LIMIT 1 0.00073003768920898
(78) DESCRIBE `specials` 0.0053799152374268
(79) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541086') 0.00054001808166504
(80) DESCRIBE `ships` 0.0038859844207764
(81) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.0005490779876709
(82) DESCRIBE `ships` 0.0030901432037354
(83) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00057291984558105
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035691261291504
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00032997131347656
(86) DESCRIBE `itineraries` 0.0020089149475098
(87) DESCRIBE `ports` 0.0017769336700439
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00036311149597168
(89) DESCRIBE `ports` 0.0012800693511963
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00029706954956055
(91) DESCRIBE `ports` 0.0012381076812744
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00032305717468262
(93) DESCRIBE `specialsailingdates` 0.0011351108551025
(94) DESCRIBE `sailingdates` 0.0013620853424072
(95) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453273))) 0.00043010711669922
(96) DESCRIBE `ports` 0.0013608932495117
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00030684471130371
(98) DESCRIBE `ports` 0.0013828277587891
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.0003211498260498
(100) DESCRIBE `ports` 0.0013670921325684
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00030303001403809
(102) DESCRIBE `ports` 0.001345157623291
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00027108192443848
(104) DESCRIBE `ports` 0.0017108917236328
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00036811828613281
(106) DESCRIBE `ports` 0.0013439655303955
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00027704238891602
(108) DESCRIBE `ports` 0.0013279914855957
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00042390823364258
(110) DESCRIBE `ports` 0.001708984375
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00043010711669922
(112) DESCRIBE `ports` 0.0017571449279785
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00040602684020996
(114) DESCRIBE `ports` 0.0017769336700439
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00030207633972168
(116) DESCRIBE `ports` 0.0016059875488281
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00040888786315918
(118) DESCRIBE `ports` 0.0013508796691895
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00034189224243164
(120) DESCRIBE `ports` 0.0016388893127441
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00046586990356445
(122) DESCRIBE `ports` 0.0019190311431885
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00041103363037109
(124) DESCRIBE `cruises` 0.0032439231872559
(125) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71399))) 0.00052595138549805
(126) DESCRIBE `avid_specials` 0.001561164855957
(127) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541086 and class = 'Special') OR (item_id = 71399 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0017890930175781
(128) DESCRIBE `cruiselines` 0.0023660659790039
(129) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00043511390686035
(130) DESCRIBE `orchid_image` 0.0020720958709717
(131) DESCRIBE `cruiselines` 0.0023469924926758
(132) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 9.0122222900391E-5
(133) DESCRIBE `specials` 0.0044550895690918
(134) SELECT `specials`.* FROM `specials` WHERE (id = '1541088') AND (specials.orchid_available = 1) LIMIT 1 0.00056886672973633
(135) DESCRIBE `specials` 0.0037529468536377
(136) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541088') 0.00032997131347656
(137) DESCRIBE `ships` 0.0026400089263916
(138) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00037908554077148
(139) DESCRIBE `ships` 0.0024840831756592
(140) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00027799606323242
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00028085708618164
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0002598762512207
(143) DESCRIBE `itineraries` 0.0014998912811279
(144) DESCRIBE `ports` 0.0019609928131104
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00050497055053711
(146) DESCRIBE `ports` 0.0017678737640381
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00063300132751465
(148) DESCRIBE `ports` 0.0017950534820557
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00064802169799805
(150) DESCRIBE `specialsailingdates` 0.0011799335479736
(151) DESCRIBE `sailingdates` 0.0015649795532227
(152) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453274))) 0.00035500526428223
(153) DESCRIBE `ports` 0.0012710094451904
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00033807754516602
(155) DESCRIBE `ports` 0.0012838840484619
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00031208992004395
(157) DESCRIBE `ports` 0.0012998580932617
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0003049373626709
(159) DESCRIBE `ports` 0.0013141632080078
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00034809112548828
(161) DESCRIBE `ports` 0.0019168853759766
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.0003509521484375
(163) DESCRIBE `ports` 0.0013909339904785
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00038003921508789
(165) DESCRIBE `ports` 0.0017590522766113
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00044012069702148
(167) DESCRIBE `ports` 0.0016648769378662
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00041508674621582
(169) DESCRIBE `ports` 0.0013821125030518
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00039792060852051
(171) DESCRIBE `ports` 0.001629114151001
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00040793418884277
(173) DESCRIBE `ports` 0.0018019676208496
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00037097930908203
(175) DESCRIBE `ports` 0.0013039112091064
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00030016899108887
(177) DESCRIBE `ports` 0.0014181137084961
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032305717468262
(179) DESCRIBE `ports` 0.0012497901916504
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0002751350402832
(181) DESCRIBE `ports` 0.00142502784729
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032615661621094
(183) DESCRIBE `ports` 0.0014851093292236
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00029492378234863
(185) DESCRIBE `ports` 0.001331090927124
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00030899047851562
(187) DESCRIBE `ports` 0.0012431144714355
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00033211708068848
(189) DESCRIBE `ports` 0.0013680458068848
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00031495094299316
(191) DESCRIBE `ports` 0.0013370513916016
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00029301643371582
(193) DESCRIBE `cruises` 0.0025949478149414
(194) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71400))) 0.00040602684020996
(195) DESCRIBE `avid_specials` 0.0011429786682129
(196) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541088 and class = 'Special') OR (item_id = 71400 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0010077953338623
(197) DESCRIBE `cruiselines` 0.0018038749694824
(198) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00039386749267578
(199) DESCRIBE `orchid_image` 0.0014500617980957
(200) DESCRIBE `cruiselines` 0.0020990371704102
(201) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.0003361701965332
(202) DESCRIBE `specials` 0.0036590099334717
(203) SELECT `specials`.* FROM `specials` WHERE (id = '1541784') AND (specials.orchid_available = 1) LIMIT 1 0.00070810317993164
(204) DESCRIBE `specials` 0.0048749446868896
(205) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541784') 0.00052189826965332
(206) DESCRIBE `ships` 0.0027031898498535
(207) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00041389465332031
(208) DESCRIBE `ships` 0.0029871463775635
(209) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00044894218444824
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033402442932129
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048685073852539
(212) DESCRIBE `itineraries` 0.0016789436340332
(213) DESCRIBE `ports` 0.0018038749694824
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00046896934509277
(215) DESCRIBE `ports` 0.0014550685882568
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00040292739868164
(217) DESCRIBE `ports` 0.0016999244689941
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.0003819465637207
(219) DESCRIBE `specialsailingdates` 0.00142502784729
(220) DESCRIBE `sailingdates` 0.0015790462493896
(221) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518739))) 0.00056600570678711
(222) DESCRIBE `sailingdates` 0.0011579990386963
(223) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518740))) 0.00033307075500488
(224) DESCRIBE `sailingdates` 0.0012028217315674
(225) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518741))) 0.00061297416687012
(226) DESCRIBE `sailingdates` 0.0015277862548828
(227) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518742))) 0.00029897689819336
(228) DESCRIBE `sailingdates` 0.0012710094451904
(229) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518743))) 0.00034213066101074
(230) DESCRIBE `sailingdates` 0.0015358924865723
(231) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518744))) 0.00028610229492188
(232) DESCRIBE `sailingdates` 0.0012068748474121
(233) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518746))) 0.0002751350402832
(234) DESCRIBE `sailingdates` 0.0010950565338135
(235) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518749))) 0.00028896331787109
(236) DESCRIBE `sailingdates` 0.0010910034179688
(237) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518750))) 0.00026202201843262
(238) DESCRIBE `sailingdates` 0.0011241436004639
(239) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518751))) 0.00029182434082031
(240) DESCRIBE `sailingdates` 0.0011491775512695
(241) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518754))) 0.00029516220092773
(242) DESCRIBE `sailingdates` 0.0014791488647461
(243) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518755))) 0.0002901554107666
(244) DESCRIBE `sailingdates` 0.0011999607086182
(245) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518756))) 0.00027918815612793
(246) DESCRIBE `sailingdates` 0.001209020614624
(247) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518757))) 0.00026392936706543
(248) DESCRIBE `sailingdates` 0.0011429786682129
(249) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518758))) 0.0002751350402832
(250) DESCRIBE `sailingdates` 0.0010969638824463
(251) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518759))) 0.00034904479980469
(252) DESCRIBE `sailingdates` 0.0011169910430908
(253) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518760))) 0.00026512145996094
(254) DESCRIBE `sailingdates` 0.0012249946594238
(255) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518761))) 0.00040197372436523
(256) DESCRIBE `sailingdates` 0.001694917678833
(257) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518762))) 0.00035810470581055
(258) DESCRIBE `sailingdates` 0.0014560222625732
(259) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518763))) 0.00029993057250977
(260) DESCRIBE `sailingdates` 0.0014190673828125
(261) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518764))) 0.00034403800964355
(262) DESCRIBE `sailingdates` 0.0012259483337402
(263) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518765))) 0.00027704238891602
(264) DESCRIBE `sailingdates` 0.0011520385742188
(265) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518766))) 0.0002751350402832
(266) DESCRIBE `sailingdates` 0.0012800693511963
(267) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518767))) 0.00035810470581055
(268) DESCRIBE `sailingdates` 0.0014829635620117
(269) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518770))) 0.00027108192443848
(270) DESCRIBE `sailingdates` 0.0013539791107178
(271) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518772))) 0.00028109550476074
(272) DESCRIBE `sailingdates` 0.0011520385742188
(273) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518773))) 0.00027704238891602
(274) DESCRIBE `sailingdates` 0.001215934753418
(275) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518774))) 0.00043511390686035
(276) DESCRIBE `sailingdates` 0.001107931137085
(277) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518776))) 0.00026297569274902
(278) DESCRIBE `sailingdates` 0.0014941692352295
(279) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518777))) 0.0003509521484375
(280) DESCRIBE `sailingdates` 0.0012080669403076
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518778))) 0.00028896331787109
(282) DESCRIBE `sailingdates` 0.0011758804321289
(283) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518779))) 0.00028014183044434
(284) DESCRIBE `sailingdates` 0.0011940002441406
(285) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518780))) 0.00026893615722656
(286) DESCRIBE `ports` 0.0013020038604736
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00044488906860352
(288) DESCRIBE `ports` 0.0015850067138672
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00031185150146484
(290) DESCRIBE `ports` 0.0015029907226562
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.0003349781036377
(292) DESCRIBE `ports` 0.0012650489807129
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00068902969360352
(294) DESCRIBE `ports` 0.0019240379333496
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00040197372436523
(296) DESCRIBE `ports` 0.0017518997192383
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00037980079650879
(298) DESCRIBE `ports` 0.0018410682678223
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0004417896270752
(300) DESCRIBE `ports` 0.0018069744110107
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00037693977355957
(302) DESCRIBE `ports` 0.0017490386962891
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00039887428283691
(304) DESCRIBE `ports` 0.0018668174743652
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00042510032653809
(306) DESCRIBE `ports` 0.0019769668579102
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00049304962158203
(308) DESCRIBE `ports` 0.0017409324645996
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.0003511905670166
(310) DESCRIBE `ports` 0.0017640590667725
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00038409233093262
(312) DESCRIBE `ports` 0.0017900466918945
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00036191940307617
(314) DESCRIBE `ports` 0.0017368793487549
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00043606758117676
(316) DESCRIBE `ports` 0.0017468929290771
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00035595893859863
(318) DESCRIBE `cruises` 0.0033500194549561
(319) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00052309036254883
(320) DESCRIBE `avid_specials` 0.0016109943389893
(321) 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.0016050338745117
(322) DESCRIBE `cruiselines` 0.0025129318237305
(323) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00043010711669922
(324) DESCRIBE `orchid_image` 0.0020339488983154
(325) DESCRIBE `cruiselines` 0.0026350021362305
(326) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0004279613494873
(327) DESCRIBE `specials` 0.0039088726043701
(328) SELECT `specials`.* FROM `specials` WHERE (id = '1541089') AND (specials.orchid_available = 1) LIMIT 1 0.00074410438537598
(329) DESCRIBE `specials` 0.0051729679107666
(330) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541089') 0.00037717819213867
(331) DESCRIBE `ships` 0.0026779174804688
(332) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1168))) 0.00035619735717773
(333) DESCRIBE `ships` 0.0025620460510254
(334) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00041317939758301
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 1.1920928955078E-5
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00013113021850586
(337) DESCRIBE `itineraries` 0.0015158653259277
(338) DESCRIBE `ports` 0.0012118816375732
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00031805038452148
(340) DESCRIBE `ports` 0.001345157623291
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00029301643371582
(342) DESCRIBE `ports` 0.0013291835784912
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00030303001403809
(344) DESCRIBE `specialsailingdates` 0.0011000633239746
(345) DESCRIBE `sailingdates` 0.0015380382537842
(346) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453275))) 0.00033688545227051
(347) DESCRIBE `ports` 0.0013759136199951
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00038814544677734
(349) DESCRIBE `ports` 0.001032829284668
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00037884712219238
(351) DESCRIBE `ports` 0.001338005065918
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 4.1961669921875E-5
(353) DESCRIBE `ports` 0.0015227794647217
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00031614303588867
(355) DESCRIBE `ports` 0.0014438629150391
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00033187866210938
(357) DESCRIBE `ports` 0.0018661022186279
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0005648136138916
(359) DESCRIBE `ports` 0.0016939640045166
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00050592422485352
(361) DESCRIBE `ports` 0.0019528865814209
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0003819465637207
(363) DESCRIBE `ports` 0.0019171237945557
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0004279613494873
(365) DESCRIBE `ports` 0.0019159317016602
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00040602684020996
(367) DESCRIBE `ports` 0.0017387866973877
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00052189826965332
(369) DESCRIBE `ports` 0.0016388893127441
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.0004119873046875
(371) DESCRIBE `ports` 0.0016069412231445
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.0003662109375
(373) DESCRIBE `ports` 0.0012679100036621
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.0002899169921875
(375) DESCRIBE `ports` 0.0012900829315186
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0
(377) DESCRIBE `ports` 0.0014889240264893
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00029587745666504
(379) DESCRIBE `ports` 0.0013771057128906
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00036287307739258
(381) DESCRIBE `ports` 0.0014450550079346
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0
(383) DESCRIBE `ports` 0.0015420913696289
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00037407875061035
(385) DESCRIBE `ports` 0.001417875289917
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00029802322387695
(387) DESCRIBE `cruises` 0.0025839805603027
(388) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71401))) 0.00046610832214355
(389) DESCRIBE `avid_specials` 0.0012860298156738
(390) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1541089 and class = 'Special') OR (item_id = 71401 and class = 'Cruise') OR (item_id = 1168 AND class = 'Ship') OR (item_id = 24 AND class = 'CruiseLine') OR (item_id = 26 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.0012660026550293
(391) DESCRIBE `cruiselines` 0.0022299289703369
(392) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00051093101501465
(393) DESCRIBE `orchid_image` 0.0019161701202393
(394) DESCRIBE `cruiselines` 0.0018680095672607
(395) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0
(396) DESCRIBE `specials` 0.0035021305084229
(397) SELECT `specials`.* FROM `specials` WHERE (id = '1541793') AND (specials.orchid_available = 1) LIMIT 1 0.00069594383239746
(398) DESCRIBE `specials` 0.004472017288208
(399) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1541793') 0.00076794624328613
(400) DESCRIBE `ships` 0.003000020980835
(401) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00042390823364258
(402) DESCRIBE `ships` 0.0026040077209473
(403) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00033807754516602
(404) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027012825012207
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025582313537598
(406) DESCRIBE `itineraries` 0.0014431476593018
(407) DESCRIBE `ports` 0.0017061233520508
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00039100646972656
(409) DESCRIBE `ports` 0.0013160705566406
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00028800964355469
(411) DESCRIBE `ports` 0.0015480518341064
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00033307075500488
(413) DESCRIBE `specialsailingdates` 0.0011589527130127
(414) DESCRIBE `sailingdates` 0.0016129016876221
(415) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518625))) 0.0004570484161377
(416) DESCRIBE `sailingdates` 0.0011210441589355
(417) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518626))) 0.00028514862060547
(418) DESCRIBE `sailingdates` 0.0011320114135742
(419) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518627))) 0.00028395652770996
(420) DESCRIBE `sailingdates` 0.00087213516235352
(421) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518631))) 0.00028896331787109
(422) DESCRIBE `sailingdates` 0.0011680126190186
(423) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518634))) 4.3153762817383E-5
(424) DESCRIBE `sailingdates` 0.0012078285217285
(425) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518635))) 0.0003359317779541
(426) DESCRIBE `sailingdates` 0.0011801719665527
(427) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518637))) 0.00028085708618164
(428) DESCRIBE `sailingdates` 0.0013360977172852
(429) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518639))) 0.0002739429473877
(430) DESCRIBE `sailingdates` 0.0016789436340332
(431) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518640))) 0.00047802925109863
(432) DESCRIBE `sailingdates` 0.001101016998291
(433) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518641))) 0.00043892860412598
(434) DESCRIBE `sailingdates` 0.0011420249938965
(435) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518642))) 0.00066089630126953
(436) DESCRIBE `sailingdates` 0.0012199878692627
(437) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518643))) 0.00032186508178711
(438) DESCRIBE `sailingdates` 0.0011248588562012
(439) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518644))) 0.00027203559875488
(440) DESCRIBE `sailingdates` 0.0011730194091797
(441) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518645))) 0.00037002563476562
(442) DESCRIBE `sailingdates` 0.0011348724365234
(443) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518646))) 0.00029110908508301
(444) DESCRIBE `sailingdates` 0.0012021064758301
(445) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518647))) 0.00029611587524414
(446) DESCRIBE `sailingdates` 0.0012109279632568
(447) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518648))) 0.0004270076751709
(448) DESCRIBE `sailingdates` 0.0016570091247559
(449) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518649))) 0.0004270076751709
(450) DESCRIBE `sailingdates` 0.0015509128570557
(451) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518650))) 0.0003659725189209
(452) DESCRIBE `sailingdates` 0.0012209415435791
(453) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518651))) 0.00031685829162598
(454) DESCRIBE `sailingdates` 0.0011351108551025
(455) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518652))) 0.00030994415283203
(456) DESCRIBE `sailingdates` 0.0012450218200684
(457) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518653))) 0.00028491020202637
(458) DESCRIBE `sailingdates` 0.0011191368103027
(459) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518655))) 0.00028300285339355
(460) DESCRIBE `sailingdates` 0.0011618137359619
(461) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518656))) 0.00027990341186523
(462) DESCRIBE `sailingdates` 0.0011420249938965
(463) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518657))) 0.00027799606323242
(464) DESCRIBE `sailingdates` 0.0011768341064453
(465) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518658))) 0.0002901554107666
(466) DESCRIBE `sailingdates` 0.0012609958648682
(467) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518659))) 0.00035905838012695
(468) DESCRIBE `sailingdates` 0.001101016998291
(469) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518660))) 0.00030803680419922
(470) DESCRIBE `sailingdates` 0.0011360645294189
(471) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518661))) 0.00029587745666504
(472) DESCRIBE `sailingdates` 0.0011310577392578
(473) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518662))) 0.00034594535827637
(474) DESCRIBE `sailingdates` 0.0010979175567627
(475) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518663))) 0.00027608871459961
(476) DESCRIBE `ports` 0.0013480186462402
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00037813186645508
(478) DESCRIBE `ports` 0.001338005065918
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00027799606323242
(480) DESCRIBE `ports` 0.0013110637664795
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00029802322387695
(482) DESCRIBE `ports` 0.0012750625610352
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00027990341186523
(484) DESCRIBE `ports` 0.0012960433959961
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00036001205444336
(486) DESCRIBE `ports` 0.0014119148254395
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00028586387634277
(488) DESCRIBE `ports` 0.0012960433959961
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00030398368835449
(490) DESCRIBE `ports` 0.0014810562133789
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00037288665771484
(492) DESCRIBE `ports` 0.0015699863433838
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00031208992004395
(494) DESCRIBE `ports` 0.0016288757324219
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00038814544677734
(496) DESCRIBE `ports` 0.0013670921325684
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00033998489379883
(498) DESCRIBE `ports` 0.0015809535980225
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00035214424133301
(500) DESCRIBE `ports` 0.0013010501861572
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.0003058910369873
(502) DESCRIBE `ports` 0.0012989044189453
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00028896331787109
(504) DESCRIBE `ports` 0.0013070106506348
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00046300888061523
(506) DESCRIBE `ports` 0.001655101776123
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00034499168395996
(508) DESCRIBE `ports` 0.0016651153564453
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00051403045654297
(510) DESCRIBE `ports` 0.0016188621520996
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.0003969669342041
(512) DESCRIBE `cruises` 0.0026729106903076
(513) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11516))) 0.00049495697021484
(514) DESCRIBE `avid_specials` 0.0014960765838623
(515) 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.0010569095611572
(516) DESCRIBE `cruiselines` 0.0020191669464111
(517) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00039196014404297
(518) DESCRIBE `orchid_image` 0.0016181468963623
(519) DESCRIBE `cruiselines` 0.0018858909606934
(520) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00034308433532715
(521) DESCRIBE `specials` 0.0036859512329102
(522) SELECT `specials`.* FROM `specials` WHERE (id = '1557235') AND (specials.orchid_available = 1) LIMIT 1 0.00060296058654785
(523) DESCRIBE `specials` 0.0035848617553711
(524) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1557235') 0.00029087066650391
(525) DESCRIBE `ships` 0.0025029182434082
(526) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00037407875061035
(527) DESCRIBE `ships` 0.0026819705963135
(528) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00029277801513672
(529) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(530) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025296211242676
(531) DESCRIBE `itineraries` 0.0012497901916504
(532) DESCRIBE `ports` 0.0016520023345947
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00047421455383301
(534) DESCRIBE `ports` 0.0017800331115723
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00031208992004395
(536) DESCRIBE `ports` 0.0024650096893311
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00034093856811523
(538) DESCRIBE `specialsailingdates` 0.0010960102081299
(539) DESCRIBE `sailingdates` 0.0011849403381348
(540) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463936))) 0.00044488906860352
(541) DESCRIBE `sailingdates` 0.0012102127075195
(542) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463937))) 0.00029087066650391
(543) DESCRIBE `sailingdates` 0.0010969638824463
(544) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463938))) 0.00027084350585938
(545) DESCRIBE `sailingdates` 0.0011320114135742
(546) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463943))) 0.00028395652770996
(547) DESCRIBE `sailingdates` 0.0010960102081299
(548) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463944))) 0.00030899047851562
(549) DESCRIBE `sailingdates` 0.0011110305786133
(550) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463945))) 0.00028014183044434
(551) DESCRIBE `sailingdates` 0.0011160373687744
(552) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463946))) 0.00029921531677246
(553) DESCRIBE `sailingdates` 0.0011649131774902
(554) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 463949))) 0.00028109550476074
(555) DESCRIBE `ports` 0.0014588832855225
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00046682357788086
(557) DESCRIBE `ports` 0.0018701553344727
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00046992301940918
(559) DESCRIBE `ports` 0.0014259815216064
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00043106079101562
(561) DESCRIBE `ports` 0.0014169216156006
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00032591819763184
(563) DESCRIBE `ports` 0.0013530254364014
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.0003049373626709
(565) DESCRIBE `ports` 0.0013659000396729
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00028300285339355
(567) DESCRIBE `ports` 0.0013298988342285
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00031399726867676
(569) DESCRIBE `ports` 0.0013601779937744
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.0003669261932373
(571) DESCRIBE `ports` 0.0013551712036133
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00031590461730957
(573) DESCRIBE `ports` 0.0013790130615234
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00032782554626465
(575) DESCRIBE `ports` 0.0013339519500732
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00061607360839844
(577) DESCRIBE `ports` 0.0019688606262207
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00040912628173828
(579) DESCRIBE `ports` 0.0015559196472168
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00031280517578125
(581) DESCRIBE `ports` 0.0013949871063232
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00031614303588867
(583) DESCRIBE `ports` 0.001262903213501
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00032997131347656
(585) DESCRIBE `ports` 0.0013351440429688
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00035405158996582
(587) DESCRIBE `ports` 0.0012779235839844
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00032806396484375
(589) DESCRIBE `ports` 0.0014708042144775
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00030803680419922
(591) DESCRIBE `cruises` 0.0025379657745361
(592) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 73726))) 0.00041699409484863
(593) DESCRIBE `avid_specials` 0.0011470317840576
(594) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1557235 and class = 'Special') OR (item_id = 73726 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010430812835693
(595) DESCRIBE `cruiselines` 0.0018332004547119
(596) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00036907196044922
(597) DESCRIBE `orchid_image` 0.0016930103302002
(598) DESCRIBE `cruiselines` 0.010116100311279
(599) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00065708160400391
(600) DESCRIBE `specials` 0.0047500133514404
(601) SELECT `specials`.* FROM `specials` WHERE (id = '1570935') AND (specials.orchid_available = 1) LIMIT 1 0.00069403648376465
(602) DESCRIBE `specials` 0.004763126373291
(603) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1570935') 0.00041985511779785
(604) DESCRIBE `ships` 0.0033090114593506
(605) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 162))) 0.0005030632019043
(606) DESCRIBE `ships` 0.0033340454101562
(607) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '162') 0.00039291381835938
(608) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034809112548828
(609) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040292739868164
(610) DESCRIBE `itineraries` 0.0017640590667725
(611) DESCRIBE `ports` 0.0017189979553223
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00046992301940918
(613) DESCRIBE `ports` 0.0015227794647217
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0003058910369873
(615) DESCRIBE `ports` 0.001507043838501
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00033712387084961
(617) DESCRIBE `specialsailingdates` 0.001338005065918
(618) DESCRIBE `sailingdates` 0.0014369487762451
(619) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 468414))) 0.00052189826965332
(620) DESCRIBE `ports` 0.0015900135040283
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00040078163146973
(622) DESCRIBE `ports` 0.0016779899597168
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00034689903259277
(624) DESCRIBE `ports` 0.0015621185302734
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00037503242492676
(626) DESCRIBE `ports` 0.0017030239105225
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00036716461181641
(628) DESCRIBE `ports` 0.0016589164733887
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5008))) 0.00041079521179199
(630) DESCRIBE `ports` 0.0016789436340332
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5008') 0.00037503242492676
(632) DESCRIBE `ports` 0.0017318725585938
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040388107299805
(634) DESCRIBE `ports` 0.0016610622406006
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00037217140197754
(636) DESCRIBE `ports` 0.0016539096832275
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0003969669342041
(638) DESCRIBE `ports` 0.0018308162689209
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0002739429473877
(640) DESCRIBE `ports` 0.0012710094451904
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00032806396484375
(642) DESCRIBE `ports` 0.00142502784729
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00037193298339844
(644) DESCRIBE `ports` 0.0018119812011719
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00038814544677734
(646) DESCRIBE `ports` 0.0018138885498047
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00035595893859863
(648) DESCRIBE `ports` 0.0017638206481934
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00042486190795898
(650) DESCRIBE `ports` 0.0017600059509277
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00033998489379883
(652) DESCRIBE `ports` 0.0013060569763184
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 859))) 0.00031709671020508
(654) DESCRIBE `ports` 0.0013360977172852
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '859') 0.00026798248291016
(656) DESCRIBE `ports` 0.0017189979553223
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00038003921508789
(658) DESCRIBE `ports` 0.0018019676208496
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00033998489379883
(660) DESCRIBE `ports` 0.0010888576507568
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00020909309387207
(662) DESCRIBE `ports` 0.0012521743774414
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00025796890258789
(664) DESCRIBE `ports` 0.0013618469238281
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00030899047851562
(666) DESCRIBE `ports` 0.0013608932495117
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00031805038452148
(668) DESCRIBE `ports` 0.001309871673584
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00029277801513672
(670) DESCRIBE `ports` 0.0013151168823242
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00027585029602051
(672) DESCRIBE `ports` 0.001244068145752
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 241))) 0.00029087066650391
(674) DESCRIBE `ports` 0.001284122467041
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '241') 0.00034999847412109
(676) DESCRIBE `ports` 0.0016491413116455
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00035309791564941
(678) DESCRIBE `ports` 0.0013868808746338
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028610229492188
(680) DESCRIBE `cruises` 0.0025749206542969
(681) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 36197))) 0.00041580200195312
(682) DESCRIBE `avid_specials` 0.0013580322265625
(683) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1570935 and class = 'Special') OR (item_id = 36197 and class = 'Cruise') OR (item_id = 162 AND class = 'Ship') OR (item_id = 33 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.0014281272888184
(684) DESCRIBE `cruiselines` 0.0018270015716553
(685) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00037598609924316
(686) DESCRIBE `orchid_image` 0.0015089511871338
(687) DESCRIBE `cruiselines` 0.0018711090087891
(688) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00033307075500488
(689) DESCRIBE `specials` 0.003756046295166
(690) SELECT `specials`.* FROM `specials` WHERE (id = '1570976') AND (specials.orchid_available = 1) LIMIT 1 0.00060319900512695
(691) DESCRIBE `specials` 0.0047011375427246
(692) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1570976') 0.00041699409484863
(693) DESCRIBE `ships` 0.0033459663391113
(694) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00038719177246094
(695) DESCRIBE `ships` 0.0024349689483643
(696) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00027108192443848
(697) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029921531677246
(698) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024986267089844
(699) DESCRIBE `itineraries` 0.0013208389282227
(700) DESCRIBE `ports` 0.001410961151123
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032496452331543
(702) DESCRIBE `ports` 0.001291036605835
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030303001403809
(704) DESCRIBE `ports` 0.0013470649719238
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027704238891602
(706) DESCRIBE `specialsailingdates` 0.0011739730834961
(707) DESCRIBE `sailingdates` 0.0015149116516113
(708) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 486430))) 0.00053787231445312
(709) DESCRIBE `ports` 0.0017910003662109
(710) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00042104721069336
(711) DESCRIBE `ports` 0.0017898082733154
(712) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00039505958557129
(713) DESCRIBE `ports` 0.0017719268798828
(714) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00055599212646484
(715) DESCRIBE `ports` 0.001816987991333
(716) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.0050408840179443
(717) DESCRIBE `ports` 0.0020599365234375
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00049495697021484
(719) DESCRIBE `ports` 0.0018088817596436
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00036811828613281
(721) DESCRIBE `ports` 0.00177001953125
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00031590461730957
(723) DESCRIBE `ports` 0.0016160011291504
(724) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00028300285339355
(725) DESCRIBE `ports` 0.0013999938964844
(726) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3747))) 0.00039815902709961
(727) DESCRIBE `ports` 0.0041661262512207
(728) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3747') 0.00033998489379883
(729) DESCRIBE `ports` 0.0016210079193115
(730) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00037598609924316
(731) DESCRIBE `ports` 0.0015389919281006
(732) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00028610229492188
(733) DESCRIBE `ports` 0.0013630390167236
(734) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00030207633972168
(735) DESCRIBE `ports` 0.0014870166778564
(736) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00028800964355469
(737) DESCRIBE `ports` 0.0015521049499512
(738) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.0003349781036377
(739) DESCRIBE `ports` 0.0012519359588623
(740) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00027799606323242
(741) DESCRIBE `ports` 0.0015218257904053
(742) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 727))) 0.00033307075500488
(743) DESCRIBE `ports` 0.0014638900756836
(744) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '727') 0.00029301643371582
(745) DESCRIBE `ports` 0.0014100074768066
(746) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0003211498260498
(747) DESCRIBE `ports` 0.0012879371643066
(748) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00029206275939941
(749) DESCRIBE `ports` 0.0015079975128174
(750) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00039291381835938
(751) DESCRIBE `ports` 0.0013480186462402
(752) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00028395652770996
(753) DESCRIBE `ports` 0.0016639232635498
(754) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032591819763184
(755) DESCRIBE `ports` 0.0012750625610352
(756) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00031590461730957
(757) DESCRIBE `cruises` 0.0027260780334473
(758) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 78187))) 0.00043511390686035
(759) DESCRIBE `avid_specials` 0.0014121532440186
(760) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1570976 and class = 'Special') OR (item_id = 78187 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.001338005065918
(761) DESCRIBE `cruiselines` 0.0023751258850098
(762) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00037097930908203
(763) DESCRIBE `orchid_image` 0.0015740394592285
(764) DESCRIBE `cruiselines` 0.0022320747375488
(765) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00029706954956055
(766) DESCRIBE `specials` 0.003931999206543
(767) SELECT `specials`.* FROM `specials` WHERE (id = '1570956') AND (specials.orchid_available = 1) LIMIT 1 0.00057411193847656
(768) DESCRIBE `specials` 0.00394606590271
(769) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1570956') 0.00030612945556641
(770) DESCRIBE `ships` 0.0028269290924072
(771) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 162))) 0.00038790702819824
(772) DESCRIBE `ships` 0.0034580230712891
(773) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '162') 0.00036001205444336
(774) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035691261291504
(775) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032496452331543
(776) DESCRIBE `itineraries` 0.0016489028930664
(777) DESCRIBE `ports` 0.0016698837280273
(778) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00045990943908691
(779) DESCRIBE `ports` 0.0017569065093994
(780) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00038409233093262
(781) DESCRIBE `ports` 0.0017349720001221
(782) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00034594535827637
(783) DESCRIBE `specialsailingdates` 0.0014550685882568
(784) DESCRIBE `sailingdates` 0.0015239715576172
(785) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500975))) 0.00050592422485352
(786) DESCRIBE `sailingdates` 0.0015158653259277
(787) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 468415))) 0.00037598609924316
(788) DESCRIBE `sailingdates` 0.0015997886657715
(789) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 468417))) 0.00034594535827637
(790) DESCRIBE `ports` 0.0020711421966553
(791) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00041699409484863
(792) DESCRIBE `ports` 0.001816987991333
(793) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00032997131347656
(794) DESCRIBE `ports` 0.0016939640045166
(795) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00038290023803711
(796) DESCRIBE `ports` 0.0017070770263672
(797) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00037312507629395
(798) DESCRIBE `ports` 0.0018050670623779
(799) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5008))) 0.00039911270141602
(800) DESCRIBE `ports` 0.0016770362854004
(801) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5008') 0.00037384033203125
(802) DESCRIBE `ports` 0.0017058849334717
(803) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040006637573242
(804) DESCRIBE `ports` 0.0016610622406006
(805) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00032305717468262
(806) DESCRIBE `ports` 0.0020511150360107
(807) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040006637573242
(808) DESCRIBE `ports` 0.002068042755127
(809) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00034904479980469
(810) DESCRIBE `ports` 0.0021159648895264
(811) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00038695335388184
(812) DESCRIBE `ports` 0.0016710758209229
(813) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00033903121948242
(814) DESCRIBE `ports` 0.0016999244689941
(815) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00042605400085449
(816) DESCRIBE `ports` 0.0018799304962158
(817) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00028300285339355
(818) DESCRIBE `ports` 0.0011019706726074
(819) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.0003049373626709
(820) DESCRIBE `ports` 0.0014309883117676
(821) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00027012825012207
(822) DESCRIBE `ports` 0.0014638900756836
(823) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 859))) 0.0001990795135498
(824) DESCRIBE `ports` 0.00173020362854
(825) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '859') 0.00043511390686035
(826) DESCRIBE `ports` 0.00199294090271
(827) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00039410591125488
(828) DESCRIBE `ports` 0.0022990703582764
(829) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00034713745117188
(830) DESCRIBE `ports` 0.0014739036560059
(831) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00055599212646484
(832) DESCRIBE `ports` 0.001784086227417
(833) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.0004119873046875
(834) DESCRIBE `ports` 0.0018360614776611
(835) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0003969669342041
(836) DESCRIBE `ports` 0.0019841194152832
(837) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00029683113098145
(838) DESCRIBE `ports` 0.0012500286102295
(839) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00028491020202637
(840) DESCRIBE `ports` 0.0014801025390625
(841) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00026583671569824
(842) DESCRIBE `ports` 0.0012619495391846
(843) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 241))) 0.00029516220092773
(844) DESCRIBE `ports` 0.0015718936920166
(845) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '241') 0.00026297569274902
(846) DESCRIBE `ports` 0.0015110969543457
(847) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030088424682617
(848) DESCRIBE `ports` 0.0017828941345215
(849) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00029492378234863
(850) DESCRIBE `cruises` 0.0025789737701416
(851) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 36197))) 0.00039410591125488
(852) DESCRIBE `avid_specials` 0.0012149810791016
(853) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1570956 and class = 'Special') OR (item_id = 36197 and class = 'Cruise') OR (item_id = 162 AND class = 'Ship') OR (item_id = 33 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.0013959407806396
(854) DESCRIBE `cruiselines` 0.0027680397033691
(855) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0003960132598877
(856) DESCRIBE `orchid_image` 0.0018100738525391
(857) DESCRIBE `cruiselines` 0.0018701553344727
(858) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00050497055053711
(859) DESCRIBE `cruiselines` 0.0021090507507324
(860) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '212', '33', '264', '140', '23', '47', '19', '26', '37', '101', '114', '151', '24', '29', '258', '14', '4', '8', '18', '96', '218')) ORDER BY FIND_IN_SET(id, '120,212,33,264,140,23,47,19,26,37,101,114,151,24,29,258,14,4,8,18,96,218') 0.0018560886383057
(861) DESCRIBE `ships` 0.0027909278869629
(862) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '1163', '627', '1526', '1767', '1013', '163', '701', '517', '407', '162', '573', '652', '1168', '1328', '1398', '124', '1073', '1631', '1804', '66', '451', '678', '933', '1402', '1412', '1539', '4', '74', '98', '105', '160', '253', '286', '287', '291', '332', '553', '580', '590', '616', '741', '972', '973', '1021', '1028', '1135', '1139', '1159', '1223', '1236', '1262', '1266', '1282', '1284', '1318', '1321', '1409', '1410', '1411', '1571', '1587', '1711', '1732')) ORDER BY FIND_IN_SET(id, '521,520,1163,627,1526,1767,1013,163,701,517,407,162,573,652,1168,1328,1398,124,1073,1631,1804,66,451,678,933,1402,1412,1539,4,74,98,105,160,253,286,287,291,332,553,580,590,616,741,972,973,1021,1028,1135,1139,1159,1223,1236,1262,1266,1282,1284,1318,1321,1409,1410,1411,1571,1587,1711,1732') 0.0054428577423096
(863) DESCRIBE `cruisetypes` 0.0016360282897949
(864) DESCRIBE `destinations` 0.0019440650939941
(865) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '39', '43', '50', '8', '12', '22', '35', '34', '26', '53', '2', '7', '28', '37', '40', '48', '52')) ORDER BY FIND_IN_SET(id, '54,39,43,50,8,12,22,35,34,26,53,2,7,28,37,40,48,52') 0.0014770030975342