or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Cruise Ship Lingo? Look like a cruise expert before you get on the ship
  3. BREAKING NEWS FOR PRINCESS FANS: Register your interest now!!!
  4. Catch Up on Cruising: Latest News in bite size!
  5. Review: China – Part Two

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

Total elapsed time: 0.57160258293152

# Query Time
(1) connect 0.00065779685974121
(2) DESCRIBE `cruises` 0.0030100345611572
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (56593, 66672, 66485, 66484, 69702, 72786, 73062, 55692, 69769, 66654)) ORDER BY FIND_IN_SET(id, '56593,66672,66485,66484,69702,72786,73062,55692,69769,66654') 0.0015628337860107
(4) DESCRIBE `cruises` 0.0027859210968018
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56593') 0.00038290023803711
(6) DESCRIBE `ships` 0.0026640892028809
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.00047612190246582
(8) DESCRIBE `ships` 0.0030691623687744
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.00035691261291504
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036120414733887
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031495094299316
(12) DESCRIBE `itineraries` 0.0015029907226562
(13) DESCRIBE `ports` 0.0013070106506348
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00031495094299316
(15) DESCRIBE `ports` 0.0012669563293457
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030183792114258
(17) DESCRIBE `ports` 0.0013439655303955
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0002748966217041
(19) DESCRIBE `sailingdates` 0.0011019706726074
(20) DESCRIBE `ports` 0.0013420581817627
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0003209114074707
(22) DESCRIBE `ports` 0.001323938369751
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00028395652770996
(24) DESCRIBE `ports` 0.0012390613555908
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00030303001403809
(26) DESCRIBE `ports` 0.0012590885162354
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00027179718017578
(28) DESCRIBE `ports` 0.0013301372528076
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00029897689819336
(30) DESCRIBE `ports` 0.0012772083282471
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00031089782714844
(32) DESCRIBE `ports` 0.0012311935424805
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00030207633972168
(34) DESCRIBE `ports` 0.0012509822845459
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.0002601146697998
(36) DESCRIBE `ports` 0.0012340545654297
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00030016899108887
(38) DESCRIBE `ports` 0.0012519359588623
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00030899047851562
(40) DESCRIBE `ports` 0.00130295753479
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00035619735717773
(42) DESCRIBE `ports` 0.0012378692626953
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00026893615722656
(44) DESCRIBE `ports` 0.0012969970703125
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030994415283203
(46) DESCRIBE `ports` 0.0012350082397461
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00026798248291016
(48) DESCRIBE `avid_specials` 0.0011470317840576
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56593 and class = 'Cruise') OR (item_id = 290 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 29 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.00099897384643555
(50) DESCRIBE `cruiselines` 0.0019040107727051
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00032615661621094
(52) DESCRIBE `orchid_image` 0.0014009475708008
(53) DESCRIBE `cruiselines` 0.0017910003662109
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00033020973205566
(55) DESCRIBE `cruises` 0.0024678707122803
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66672') 0.00035190582275391
(57) DESCRIBE `ships` 0.0026600360870361
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00045490264892578
(59) DESCRIBE `ships` 0.0027780532836914
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.0002901554107666
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(63) DESCRIBE `itineraries` 0.001331090927124
(64) DESCRIBE `ports` 0.0013649463653564
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0003211498260498
(66) DESCRIBE `ports` 0.0014519691467285
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00032496452331543
(68) DESCRIBE `ports` 0.0013861656188965
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0003049373626709
(70) DESCRIBE `sailingdates` 0.0012011528015137
(71) DESCRIBE `ports` 0.0014710426330566
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00036382675170898
(73) DESCRIBE `ports` 0.0013461112976074
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00031399726867676
(75) DESCRIBE `ports` 0.0014340877532959
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00031399726867676
(77) DESCRIBE `ports` 0.0013289451599121
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00034999847412109
(79) DESCRIBE `ports` 0.0015268325805664
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00036191940307617
(81) DESCRIBE `ports` 0.0013599395751953
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00034713745117188
(83) DESCRIBE `ports` 0.0012400150299072
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 126))) 0.00029397010803223
(85) DESCRIBE `ports` 0.0012791156768799
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '126') 0.0002748966217041
(87) DESCRIBE `ports` 0.0013759136199951
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00038599967956543
(89) DESCRIBE `ports` 0.0013160705566406
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.0002748966217041
(91) DESCRIBE `ports` 0.0012500286102295
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00030684471130371
(93) DESCRIBE `ports` 0.0012679100036621
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00027298927307129
(95) DESCRIBE `ports` 0.0012369155883789
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00029110908508301
(97) DESCRIBE `ports` 0.0013649463653564
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00027918815612793
(99) DESCRIBE `avid_specials` 0.0011179447174072
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66672 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010321140289307
(101) DESCRIBE `cruiselines` 0.0017929077148438
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034093856811523
(103) DESCRIBE `orchid_image` 0.0014510154724121
(104) DESCRIBE `cruiselines` 0.0018870830535889
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028204917907715
(106) DESCRIBE `cruises` 0.0024318695068359
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66485') 0.00029301643371582
(108) DESCRIBE `ships` 0.002528190612793
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.0003819465637207
(110) DESCRIBE `ships` 0.0026669502258301
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00032782554626465
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026988983154297
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031709671020508
(114) DESCRIBE `itineraries` 0.0017039775848389
(115) DESCRIBE `ports` 0.0014359951019287
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00034594535827637
(117) DESCRIBE `ports` 0.0012760162353516
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00032401084899902
(119) DESCRIBE `ports` 0.0012600421905518
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00028896331787109
(121) DESCRIBE `sailingdates` 0.0011160373687744
(122) DESCRIBE `ports` 0.00160813331604
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00033283233642578
(124) DESCRIBE `ports` 0.0014848709106445
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00033879280090332
(126) DESCRIBE `ports` 0.0013759136199951
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00037503242492676
(128) DESCRIBE `ports` 0.0012669563293457
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00028610229492188
(130) DESCRIBE `ports` 0.0014259815216064
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00040006637573242
(132) DESCRIBE `ports` 0.001431941986084
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00028109550476074
(134) DESCRIBE `ports` 0.0012631416320801
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00030016899108887
(136) DESCRIBE `ports` 0.0012481212615967
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00027799606323242
(138) DESCRIBE `ports` 0.0012469291687012
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030088424682617
(140) DESCRIBE `ports` 0.0012481212615967
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027704238891602
(142) DESCRIBE `ports` 0.001317024230957
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00030803680419922
(144) DESCRIBE `ports` 0.0012679100036621
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.0002751350402832
(146) DESCRIBE `ports` 0.0012359619140625
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0003209114074707
(148) DESCRIBE `ports` 0.0013689994812012
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00029802322387695
(150) DESCRIBE `ports` 0.0012500286102295
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029611587524414
(152) DESCRIBE `ports` 0.0013289451599121
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027608871459961
(154) DESCRIBE `ports` 0.0012378692626953
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00029301643371582
(156) DESCRIBE `ports` 0.001356840133667
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00030398368835449
(158) DESCRIBE `ports` 0.0014300346374512
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00031614303588867
(160) DESCRIBE `ports` 0.0013291835784912
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00033903121948242
(162) DESCRIBE `ports` 0.0015828609466553
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032806396484375
(164) DESCRIBE `ports` 0.0012729167938232
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00032997131347656
(166) DESCRIBE `ports` 0.0013928413391113
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00037717819213867
(168) DESCRIBE `ports` 0.0015490055084229
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00028514862060547
(170) DESCRIBE `ports` 0.0012469291687012
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00028419494628906
(172) DESCRIBE `ports` 0.0012941360473633
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00028800964355469
(174) DESCRIBE `ports` 0.0012619495391846
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00028109550476074
(176) DESCRIBE `ports` 0.0013248920440674
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00026702880859375
(178) DESCRIBE `ports` 0.00124192237854
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00030517578125
(180) DESCRIBE `ports` 0.0014519691467285
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00033211708068848
(182) DESCRIBE `ports` 0.0013101100921631
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0003509521484375
(184) DESCRIBE `ports` 0.0012860298156738
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0002899169921875
(186) DESCRIBE `ports` 0.0012938976287842
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 481))) 0.00029492378234863
(188) DESCRIBE `ports` 0.0012850761413574
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '481') 0.00030899047851562
(190) DESCRIBE `ports` 0.001488208770752
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00034499168395996
(192) DESCRIBE `ports` 0.0013179779052734
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.0003969669342041
(194) DESCRIBE `ports` 0.0013430118560791
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00032997131347656
(196) DESCRIBE `ports` 0.0014729499816895
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00028800964355469
(198) DESCRIBE `ports` 0.0014100074768066
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00037384033203125
(200) DESCRIBE `ports` 0.0013477802276611
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00027990341186523
(202) DESCRIBE `avid_specials` 0.0011119842529297
(203) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66485 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 40 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.0012080669403076
(204) DESCRIBE `cruiselines` 0.001964807510376
(205) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00038480758666992
(206) DESCRIBE `orchid_image` 0.0017039775848389
(207) DESCRIBE `cruiselines` 0.0019340515136719
(208) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00040078163146973
(209) DESCRIBE `cruises` 0.0033929347991943
(210) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66484') 0.00041007995605469
(211) DESCRIBE `ships` 0.0036599636077881
(212) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.0004420280456543
(213) DESCRIBE `ships` 0.0027470588684082
(214) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00047707557678223
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027799606323242
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(217) DESCRIBE `itineraries` 0.0014820098876953
(218) DESCRIBE `ports` 0.001291036605835
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00032496452331543
(220) DESCRIBE `ports` 0.0012879371643066
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00029897689819336
(222) DESCRIBE `ports` 0.001309871673584
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00032591819763184
(224) DESCRIBE `sailingdates` 0.0011501312255859
(225) DESCRIBE `ports` 0.0013039112091064
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00034189224243164
(227) DESCRIBE `ports` 0.0015449523925781
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00029301643371582
(229) DESCRIBE `ports` 0.00130295753479
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00030994415283203
(231) DESCRIBE `ports` 0.0012509822845459
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00030016899108887
(233) DESCRIBE `ports` 0.0013320446014404
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0003049373626709
(235) DESCRIBE `ports` 0.0012521743774414
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00033998489379883
(237) DESCRIBE `ports` 0.0012500286102295
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00030994415283203
(239) DESCRIBE `ports` 0.0012519359588623
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00026988983154297
(241) DESCRIBE `ports` 0.0013039112091064
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035691261291504
(243) DESCRIBE `ports` 0.0015699863433838
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030088424682617
(245) DESCRIBE `ports` 0.0013570785522461
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00030708312988281
(247) DESCRIBE `ports` 0.0013720989227295
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00033307075500488
(249) DESCRIBE `ports` 0.0016369819641113
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00030183792114258
(251) DESCRIBE `ports` 0.0013430118560791
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00034618377685547
(253) DESCRIBE `ports` 0.0012819766998291
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031900405883789
(255) DESCRIBE `ports` 0.0012960433959961
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029587745666504
(257) DESCRIBE `avid_specials` 0.0011751651763916
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66484 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 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.0010199546813965
(259) DESCRIBE `cruiselines` 0.0019528865814209
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00031709671020508
(261) DESCRIBE `orchid_image` 0.0013999938964844
(262) DESCRIBE `cruiselines` 0.0018210411071777
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00037884712219238
(264) DESCRIBE `cruises` 0.0026671886444092
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69702') 0.00030279159545898
(266) DESCRIBE `ships` 0.0025100708007812
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 348))) 0.00035405158996582
(268) DESCRIBE `ships` 0.0025560855865479
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '348') 0.00026798248291016
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031113624572754
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025582313537598
(272) DESCRIBE `itineraries` 0.0012941360473633
(273) DESCRIBE `ports` 0.0012729167938232
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00031304359436035
(275) DESCRIBE `ports` 0.0013260841369629
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003659725189209
(277) DESCRIBE `ports` 0.0015120506286621
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00035905838012695
(279) DESCRIBE `sailingdates` 0.001352071762085
(280) DESCRIBE `ports` 0.0012998580932617
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003509521484375
(282) DESCRIBE `ports` 0.0012781620025635
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00034499168395996
(284) DESCRIBE `ports` 0.0012719631195068
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00028800964355469
(286) DESCRIBE `ports` 0.0012979507446289
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00026106834411621
(288) DESCRIBE `ports` 0.0012469291687012
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00029802322387695
(290) DESCRIBE `ports` 0.0012671947479248
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00027608871459961
(292) DESCRIBE `ports` 0.0012621879577637
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00034499168395996
(294) DESCRIBE `ports` 0.0012550354003906
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.0002598762512207
(296) DESCRIBE `ports` 0.0012438297271729
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00029778480529785
(298) DESCRIBE `ports` 0.0012500286102295
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00026988983154297
(300) DESCRIBE `ports` 0.0014398097991943
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00031590461730957
(302) DESCRIBE `ports` 0.0013267993927002
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.00028610229492188
(304) DESCRIBE `ports` 0.0012979507446289
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00031304359436035
(306) DESCRIBE `ports` 0.0012671947479248
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00028395652770996
(308) DESCRIBE `ports` 0.0012490749359131
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030207633972168
(310) DESCRIBE `ports` 0.0013461112976074
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00034880638122559
(312) DESCRIBE `avid_specials` 0.00111985206604
(313) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69702 and class = 'Cruise') OR (item_id = 348 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 48 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010859966278076
(314) DESCRIBE `cruiselines` 0.0019190311431885
(315) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00032401084899902
(316) DESCRIBE `orchid_image` 0.0014300346374512
(317) DESCRIBE `cruiselines` 0.0018749237060547
(318) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029516220092773
(319) DESCRIBE `cruises` 0.0025260448455811
(320) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72786') 0.00029110908508301
(321) DESCRIBE `ships` 0.0027170181274414
(322) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.0003659725189209
(323) DESCRIBE `ships` 0.002565860748291
(324) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.0002741813659668
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026583671569824
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(327) DESCRIBE `itineraries` 0.0012938976287842
(328) DESCRIBE `ports` 0.0012669563293457
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00031805038452148
(330) DESCRIBE `ports` 0.0012791156768799
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00029778480529785
(332) DESCRIBE `ports` 0.001366138458252
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00034403800964355
(334) DESCRIBE `sailingdates` 0.0011391639709473
(335) DESCRIBE `ports` 0.0012779235839844
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00031113624572754
(337) DESCRIBE `ports` 0.0015721321105957
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00029301643371582
(339) DESCRIBE `ports` 0.0013079643249512
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2480))) 0.0003058910369873
(341) DESCRIBE `ports` 0.0013241767883301
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2480') 0.0002739429473877
(343) DESCRIBE `ports` 0.0013530254364014
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 24))) 0.00030398368835449
(345) DESCRIBE `ports` 0.0012829303741455
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '24') 0.00027179718017578
(347) DESCRIBE `ports` 0.0012481212615967
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2059))) 0.00031113624572754
(349) DESCRIBE `ports` 0.001392126083374
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2059') 0.00028300285339355
(351) DESCRIBE `ports` 0.0012390613555908
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00029897689819336
(353) DESCRIBE `ports` 0.0013041496276855
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00027298927307129
(355) DESCRIBE `avid_specials` 0.0011370182037354
(356) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72786 and class = 'Cruise') OR (item_id = 105 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 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.0010249614715576
(357) DESCRIBE `cruiselines` 0.0018179416656494
(358) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0003819465637207
(359) DESCRIBE `orchid_image` 0.0016839504241943
(360) DESCRIBE `cruiselines` 0.001878023147583
(361) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029993057250977
(362) DESCRIBE `cruises` 0.0025331974029541
(363) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73062') 0.00029516220092773
(364) DESCRIBE `ships` 0.0026049613952637
(365) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00042510032653809
(366) DESCRIBE `ships` 0.0026431083679199
(367) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00027298927307129
(368) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(370) DESCRIBE `itineraries` 0.0015048980712891
(371) DESCRIBE `ports` 0.0013289451599121
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00034284591674805
(373) DESCRIBE `ports` 0.0014281272888184
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00029897689819336
(375) DESCRIBE `ports` 0.0012819766998291
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00028300285339355
(377) DESCRIBE `sailingdates` 0.0012290477752686
(378) DESCRIBE `ports` 0.0013148784637451
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00032281875610352
(380) DESCRIBE `ports` 0.0012609958648682
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00029110908508301
(382) DESCRIBE `ports` 0.0014529228210449
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00030779838562012
(384) DESCRIBE `ports` 0.0014119148254395
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00028395652770996
(386) DESCRIBE `ports` 0.0013000965118408
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00030708312988281
(388) DESCRIBE `ports` 0.0013020038604736
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00031089782714844
(390) DESCRIBE `ports` 0.0013179779052734
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030303001403809
(392) DESCRIBE `ports` 0.0014989376068115
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00027704238891602
(394) DESCRIBE `avid_specials` 0.0011451244354248
(395) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73062 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 53 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.0011780261993408
(396) DESCRIBE `cruiselines` 0.0019080638885498
(397) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00029301643371582
(398) DESCRIBE `orchid_image` 0.0014791488647461
(399) DESCRIBE `cruiselines` 0.0017991065979004
(400) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029301643371582
(401) DESCRIBE `cruises` 0.0025269985198975
(402) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55692') 0.00029897689819336
(403) DESCRIBE `ships` 0.0025279521942139
(404) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.00035214424133301
(405) DESCRIBE `ships` 0.002514123916626
(406) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.0002739429473877
(407) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027585029602051
(408) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029706954956055
(409) DESCRIBE `itineraries` 0.0012490749359131
(410) DESCRIBE `ports` 0.0012681484222412
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034809112548828
(412) DESCRIBE `ports` 0.0012421607971191
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(414) DESCRIBE `ports` 0.0013511180877686
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027990341186523
(416) DESCRIBE `sailingdates` 0.0011188983917236
(417) DESCRIBE `ports` 0.0013248920440674
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033688545227051
(419) DESCRIBE `ports` 0.0012681484222412
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031399726867676
(421) DESCRIBE `ports` 0.0013139247894287
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038790702819824
(423) DESCRIBE `ports` 0.001338005065918
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002748966217041
(425) DESCRIBE `avid_specials` 0.0011320114135742
(426) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55692 and class = 'Cruise') OR (item_id = 253 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 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.00099897384643555
(427) DESCRIBE `cruiselines` 0.0018508434295654
(428) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00040197372436523
(429) DESCRIBE `orchid_image` 0.0015189647674561
(430) DESCRIBE `cruiselines` 0.0017828941345215
(431) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028204917907715
(432) DESCRIBE `cruises` 0.0025269985198975
(433) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69769') 0.00029611587524414
(434) DESCRIBE `ships` 0.0025660991668701
(435) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 580))) 0.00034213066101074
(436) DESCRIBE `ships` 0.0027339458465576
(437) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '580') 0.00028395652770996
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(440) DESCRIBE `itineraries` 0.001262903213501
(441) DESCRIBE `ports` 0.001288890838623
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00035595893859863
(443) DESCRIBE `ports` 0.0015048980712891
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00031113624572754
(445) DESCRIBE `ports` 0.0012881755828857
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00028705596923828
(447) DESCRIBE `sailingdates` 0.0011880397796631
(448) DESCRIBE `ports` 0.0014259815216064
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00032496452331543
(450) DESCRIBE `ports` 0.0012919902801514
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00031185150146484
(452) DESCRIBE `ports` 0.0012590885162354
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00029897689819336
(454) DESCRIBE `ports` 0.0012691020965576
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00028014183044434
(456) DESCRIBE `ports` 0.0012669563293457
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00029611587524414
(458) DESCRIBE `ports` 0.0012969970703125
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00027108192443848
(460) DESCRIBE `ports` 0.0012350082397461
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00028491020202637
(462) DESCRIBE `ports` 0.0013010501861572
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00032591819763184
(464) DESCRIBE `ports` 0.0012540817260742
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00029993057250977
(466) DESCRIBE `ports` 0.0012731552124023
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00027990341186523
(468) DESCRIBE `ports` 0.001446008682251
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00039386749267578
(470) DESCRIBE `ports` 0.0013761520385742
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.0002748966217041
(472) DESCRIBE `ports` 0.0013208389282227
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00028800964355469
(474) DESCRIBE `ports` 0.0013840198516846
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00027179718017578
(476) DESCRIBE `ports` 0.0013339519500732
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 511))) 0.00031089782714844
(478) DESCRIBE `ports` 0.001255989074707
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '511') 0.00028300285339355
(480) DESCRIBE `ports` 0.0012750625610352
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00031709671020508
(482) DESCRIBE `ports` 0.0013082027435303
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00034809112548828
(484) DESCRIBE `ports` 0.0012538433074951
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00031018257141113
(486) DESCRIBE `ports` 0.0012748241424561
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00028109550476074
(488) DESCRIBE `ports` 0.0013270378112793
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00031113624572754
(490) DESCRIBE `ports` 0.0014610290527344
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00027203559875488
(492) DESCRIBE `ports` 0.0012362003326416
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00028800964355469
(494) DESCRIBE `ports` 0.0038309097290039
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00027608871459961
(496) DESCRIBE `ports` 0.0012531280517578
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00034809112548828
(498) DESCRIBE `ports` 0.0013971328735352
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034499168395996
(500) DESCRIBE `avid_specials` 0.0015020370483398
(501) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69769 and class = 'Cruise') OR (item_id = 580 AND class = 'Ship') OR (item_id = 23 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.0017428398132324
(502) DESCRIBE `cruiselines` 0.0019400119781494
(503) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00033116340637207
(504) DESCRIBE `orchid_image` 0.0014808177947998
(505) DESCRIBE `cruiselines` 0.0018250942230225
(506) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028109550476074
(507) DESCRIBE `cruises` 0.0024800300598145
(508) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66654') 0.00028800964355469
(509) DESCRIBE `ships` 0.002593994140625
(510) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00043106079101562
(511) DESCRIBE `ships` 0.0027148723602295
(512) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00032401084899902
(513) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(514) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025582313537598
(515) DESCRIBE `itineraries` 0.0012319087982178
(516) DESCRIBE `ports` 0.0013470649719238
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003349781036377
(518) DESCRIBE `ports` 0.0012459754943848
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035405158996582
(520) DESCRIBE `ports` 0.001694917678833
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00034499168395996
(522) DESCRIBE `sailingdates` 0.0013902187347412
(523) DESCRIBE `ports` 0.00180983543396
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041007995605469
(525) DESCRIBE `ports` 0.0016279220581055
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037002563476562
(527) DESCRIBE `ports` 0.0017189979553223
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.0003969669342041
(529) DESCRIBE `ports` 0.0016899108886719
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00036907196044922
(531) DESCRIBE `ports` 0.0016930103302002
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00044488906860352
(533) DESCRIBE `ports` 0.0016930103302002
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00035285949707031
(535) DESCRIBE `ports` 0.0015869140625
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00039911270141602
(537) DESCRIBE `ports` 0.0016260147094727
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00037193298339844
(539) DESCRIBE `ports` 0.0018379688262939
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040912628173828
(541) DESCRIBE `ports` 0.0017540454864502
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00035881996154785
(543) DESCRIBE `ports` 0.0016939640045166
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00045204162597656
(545) DESCRIBE `ports` 0.0016658306121826
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00058197975158691
(547) DESCRIBE `ports` 0.001924991607666
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00045895576477051
(549) DESCRIBE `ports` 0.0017468929290771
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00032401084899902
(551) DESCRIBE `ports` 0.0013918876647949
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031900405883789
(553) DESCRIBE `ports` 0.001305103302002
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00032711029052734
(555) DESCRIBE `ports` 0.001288890838623
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035500526428223
(557) DESCRIBE `ports` 0.0013511180877686
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030398368835449
(559) DESCRIBE `ports` 0.0013890266418457
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00033092498779297
(561) DESCRIBE `ports` 0.0016791820526123
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029897689819336
(563) DESCRIBE `ports` 0.0012791156768799
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00031495094299316
(565) DESCRIBE `ports` 0.0012898445129395
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00029206275939941
(567) DESCRIBE `ports` 0.0013680458068848
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031900405883789
(569) DESCRIBE `ports` 0.0012819766998291
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029587745666504
(571) DESCRIBE `ports` 0.0013530254364014
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1135))) 0.00031280517578125
(573) DESCRIBE `ports` 0.0012950897216797
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1135') 0.00028800964355469
(575) DESCRIBE `ports` 0.0012691020965576
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00032496452331543
(577) DESCRIBE `ports` 0.0012650489807129
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00029397010803223
(579) DESCRIBE `avid_specials` 0.0011551380157471
(580) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66654 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 38 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010490417480469
(581) DESCRIBE `cruiselines` 0.0022900104522705
(582) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00038790702819824
(583) DESCRIBE `orchid_image` 0.0016880035400391
(584) DESCRIBE `cruiselines` 0.0021510124206543
(585) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0003361701965332
(586) DESCRIBE `ships` 0.0028901100158691
(587) SELECT `ships`.* FROM `ships` WHERE (id IN ('1135', '349', '542', '580', '1021', '253', '451', '406', '678', '434', '105', '348', '290', '291', '98', '1409', '1682', '341')) ORDER BY FIND_IN_SET(id, '1135,349,542,580,1021,253,451,406,678,434,105,348,290,291,98,1409,1682,341') 0.0013549327850342
(588) DESCRIBE `cruisetypes` 0.0013928413391113
(589) DESCRIBE `destinations` 0.0018520355224609
(590) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '2', '43', '8', '22', '53', '48', '40', '26', '34', '29', '21', '38', '37', '11', '25', '28', '49', '7', '30')) ORDER BY FIND_IN_SET(id, '12,35,2,43,8,22,53,48,40,26,34,29,21,38,37,11,25,28,49,7,30') 0.0015091896057129
(591) DESCRIBE `cruiselines` 0.0020859241485596
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00036787986755371
(593) DESCRIBE `cruiselines` 0.0020959377288818
(594) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00039100646972656