or, enquire about your chosen options

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

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 714

Total elapsed time: 0.98364019393921

# Query Time
(1) connect 0.0021669864654541
(2) DESCRIBE `cruises` 0.004256010055542
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67108, 67106, 57120, 57176, 57119, 66904, 68476, 73204, 61616, 59773)) ORDER BY FIND_IN_SET(id, '67108,67106,57120,57176,57119,66904,68476,73204,61616,59773') 0.0023441314697266
(4) DESCRIBE `cruises` 0.0035309791564941
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67108') 0.00046205520629883
(6) DESCRIBE `ships` 0.003093957901001
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.00046396255493164
(8) DESCRIBE `ships` 0.0031900405883789
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.00037598609924316
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028395652770996
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031208992004395
(12) DESCRIBE `itineraries` 0.0017218589782715
(13) DESCRIBE `ports` 0.002147912979126
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00046420097351074
(15) DESCRIBE `ports` 0.0017590522766113
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00038695335388184
(17) DESCRIBE `ports` 0.0016510486602783
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037384033203125
(19) DESCRIBE `sailingdates` 0.001453161239624
(20) DESCRIBE `ports` 0.0015850067138672
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042414665222168
(22) DESCRIBE `ports` 0.0018291473388672
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041604042053223
(24) DESCRIBE `ports` 0.0018889904022217
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00050997734069824
(26) DESCRIBE `ports` 0.0018799304962158
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00041103363037109
(28) DESCRIBE `ports` 0.0019321441650391
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00045919418334961
(30) DESCRIBE `ports` 0.0018489360809326
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00038909912109375
(32) DESCRIBE `ports` 0.0016779899597168
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00055599212646484
(34) DESCRIBE `ports` 0.0019950866699219
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00042295455932617
(36) DESCRIBE `ports` 0.0018279552459717
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00050687789916992
(38) DESCRIBE `ports` 0.0018892288208008
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00039410591125488
(40) DESCRIBE `ports` 0.00189208984375
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 718))) 0.00041389465332031
(42) DESCRIBE `ports` 0.0018770694732666
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '718') 0.0003960132598877
(44) DESCRIBE `ports` 0.0019168853759766
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0
(46) DESCRIBE `ports` 0.0028400421142578
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00028896331787109
(48) DESCRIBE `ports` 0.0018699169158936
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0
(50) DESCRIBE `ports` 0.0018539428710938
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0012137889862061
(52) DESCRIBE `ports` 0.00083017349243164
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00041699409484863
(54) DESCRIBE `ports` 0.0019469261169434
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00041890144348145
(56) DESCRIBE `ports` 0.0019969940185547
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3964))) 0.00051498413085938
(58) DESCRIBE `ports` 0.0020930767059326
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3964') 0.00045895576477051
(60) DESCRIBE `ports` 0.0025589466094971
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00047802925109863
(62) DESCRIBE `ports` 0.0023438930511475
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00045895576477051
(64) DESCRIBE `ports` 0.0027720928192139
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00050115585327148
(66) DESCRIBE `ports` 0.0029020309448242
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0003819465637207
(68) DESCRIBE `ports` 0.0018119812011719
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00054407119750977
(70) DESCRIBE `ports` 0.0020668506622314
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0005030632019043
(72) DESCRIBE `ports` 0.0019330978393555
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00046896934509277
(74) DESCRIBE `ports` 0.0018270015716553
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00051307678222656
(76) DESCRIBE `ports` 0.0018000602722168
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00048208236694336
(78) DESCRIBE `ports` 0.0018811225891113
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0004580020904541
(80) DESCRIBE `ports` 0.0021178722381592
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.0004580020904541
(82) DESCRIBE `ports` 0.0017280578613281
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00037479400634766
(84) DESCRIBE `ports` 0.0018928050994873
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 197))) 0.00044679641723633
(86) DESCRIBE `ports` 0.0017678737640381
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '197') 0.0011858940124512
(88) DESCRIBE `ports` 0.0013570785522461
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0012571811676025
(90) DESCRIBE `ports` 0.0015809535980225
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00044107437133789
(92) DESCRIBE `ports` 0.0012331008911133
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00041103363037109
(94) DESCRIBE `ports` 0.0026960372924805
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00032591819763184
(96) DESCRIBE `ports` 0.0019090175628662
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00040698051452637
(98) DESCRIBE `ports` 0.0024101734161377
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00040507316589355
(100) DESCRIBE `ports` 0.001816987991333
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0
(102) DESCRIBE `ports` 0.0018470287322998
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0012369155883789
(104) DESCRIBE `ports` 0.0010230541229248
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00046300888061523
(106) DESCRIBE `ports` 0.0017728805541992
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00037217140197754
(108) DESCRIBE `ports` 0.0019021034240723
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045108795166016
(110) DESCRIBE `ports` 0.0021171569824219
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041413307189941
(112) DESCRIBE `ports` 0.0026760101318359
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004580020904541
(114) DESCRIBE `ports` 0.0019059181213379
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 1.978874206543E-5
(116) DESCRIBE `avid_specials` 0.0017049312591553
(117) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67108 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.004004955291748
(118) DESCRIBE `cruiselines` 0.0022759437561035
(119) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 4.2915344238281E-5
(120) DESCRIBE `orchid_image` 0.0022308826446533
(121) DESCRIBE `cruiselines` 0.0028121471405029
(122) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.001121997833252
(123) DESCRIBE `cruises` 0.0038361549377441
(124) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67106') 0.00053596496582031
(125) DESCRIBE `ships` 0.0037310123443604
(126) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.00060391426086426
(127) DESCRIBE `ships` 0.0036671161651611
(128) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.0010929107666016
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033807754516602
(131) DESCRIBE `itineraries` 0.0019419193267822
(132) DESCRIBE `ports` 0.0019938945770264
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00054693222045898
(134) DESCRIBE `ports` 0.0021328926086426
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005490779876709
(136) DESCRIBE `ports` 0.0019769668579102
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00047993659973145
(138) DESCRIBE `sailingdates` 0.0018000602722168
(139) DESCRIBE `ports` 0.0021200180053711
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00064182281494141
(141) DESCRIBE `ports` 0.003061056137085
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00058388710021973
(143) DESCRIBE `ports` 0.0040919780731201
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0013959407806396
(145) DESCRIBE `ports` 0.0015771389007568
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00040912628173828
(147) DESCRIBE `ports` 0.0010089874267578
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00045299530029297
(149) DESCRIBE `ports` 0.0019497871398926
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00041103363037109
(151) DESCRIBE `ports` 0.0025069713592529
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00044107437133789
(153) DESCRIBE `ports` 0.0024950504302979
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00039005279541016
(155) DESCRIBE `ports` 0.0018510818481445
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0
(157) DESCRIBE `ports` 0.0018980503082275
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0010278224945068
(159) DESCRIBE `ports` 0.00166916847229
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 718))) 0.00043797492980957
(161) DESCRIBE `ports` 0.0024299621582031
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '718') 0.0014898777008057
(163) DESCRIBE `ports` 0.001978874206543
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00047206878662109
(165) DESCRIBE `ports` 0.0015277862548828
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00041508674621582
(167) DESCRIBE `ports` 0.002903938293457
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0013430118560791
(169) DESCRIBE `ports` 0.0018060207366943
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00045585632324219
(171) DESCRIBE `ports` 0.0018320083618164
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0005040168762207
(173) DESCRIBE `ports` 0.001986026763916
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00048017501831055
(175) DESCRIBE `ports` 0.0018811225891113
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3964))) 0.00044798851013184
(177) DESCRIBE `ports` 0.0020120143890381
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3964') 0.00043892860412598
(179) DESCRIBE `ports` 0.0019490718841553
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00047397613525391
(181) DESCRIBE `ports` 0.0018420219421387
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00043010711669922
(183) DESCRIBE `ports` 0.0019059181213379
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0005030632019043
(185) DESCRIBE `ports` 0.0014009475708008
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00042605400085449
(187) DESCRIBE `ports` 0.0017910003662109
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00053906440734863
(189) DESCRIBE `ports` 0.0019080638885498
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040602684020996
(191) DESCRIBE `avid_specials` 0.0015499591827393
(192) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67106 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001859188079834
(193) DESCRIBE `cruiselines` 0.0025289058685303
(194) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00040912628173828
(195) DESCRIBE `orchid_image` 0.0019090175628662
(196) DESCRIBE `cruiselines` 0.0038979053497314
(197) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00058507919311523
(198) DESCRIBE `cruises` 0.0037529468536377
(199) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57120') 0.0005488395690918
(200) DESCRIBE `ships` 0.0031881332397461
(201) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 78))) 0.00057601928710938
(202) DESCRIBE `ships` 0.003101110458374
(203) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '78') 0.00035214424133301
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031495094299316
(205) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028419494628906
(206) DESCRIBE `itineraries` 0.00177001953125
(207) DESCRIBE `ports` 0.0016379356384277
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0016269683837891
(209) DESCRIBE `ports` 0.0021719932556152
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00049400329589844
(211) DESCRIBE `ports` 0.0019159317016602
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00037813186645508
(213) DESCRIBE `sailingdates` 0.001600980758667
(214) DESCRIBE `ports` 0.0017609596252441
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00046205520629883
(216) DESCRIBE `ports` 0.0017800331115723
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00037503242492676
(218) DESCRIBE `ports` 0.0017130374908447
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00043487548828125
(220) DESCRIBE `ports` 0.001413106918335
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00034689903259277
(222) DESCRIBE `ports` 0.0014410018920898
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00032591819763184
(224) DESCRIBE `ports` 0.0013930797576904
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00028300285339355
(226) DESCRIBE `ports` 0.0017189979553223
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00036716461181641
(228) DESCRIBE `ports` 0.0017340183258057
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00038504600524902
(230) DESCRIBE `ports` 0.0016858577728271
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00035381317138672
(232) DESCRIBE `ports` 0.0017800331115723
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00031399726867676
(234) DESCRIBE `ports` 0.0019009113311768
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00055789947509766
(236) DESCRIBE `ports` 0.0020689964294434
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00043797492980957
(238) DESCRIBE `ports` 0.0019309520721436
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00046706199645996
(240) DESCRIBE `ports` 0.0020430088043213
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00040793418884277
(242) DESCRIBE `ports` 0.0019021034240723
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00046491622924805
(244) DESCRIBE `ports` 0.0018510818481445
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00040102005004883
(246) DESCRIBE `ports` 0.0018000602722168
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00047397613525391
(248) DESCRIBE `ports` 0.0018899440765381
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00043201446533203
(250) DESCRIBE `ports` 0.0019500255584717
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00048112869262695
(252) DESCRIBE `ports` 0.0019640922546387
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00044012069702148
(254) DESCRIBE `ports` 0.0019612312316895
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.0004420280456543
(256) DESCRIBE `ports` 0.0019419193267822
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00040602684020996
(258) DESCRIBE `ports` 0.0019240379333496
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00046896934509277
(260) DESCRIBE `ports` 0.0019619464874268
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00038814544677734
(262) DESCRIBE `ports` 0.0018320083618164
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.0004429817199707
(264) DESCRIBE `ports` 0.0018789768218994
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.0005040168762207
(266) DESCRIBE `ports` 0.0018579959869385
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00045514106750488
(268) DESCRIBE `ports` 0.0019569396972656
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.0003969669342041
(270) DESCRIBE `ports` 0.0018541812896729
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0004429817199707
(272) DESCRIBE `ports` 0.0019409656524658
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00039982795715332
(274) DESCRIBE `avid_specials` 0.0016582012176514
(275) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57120 and class = 'Cruise') OR (item_id = 78 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016889572143555
(276) DESCRIBE `cruiselines` 0.0027658939361572
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00053191184997559
(278) DESCRIBE `orchid_image` 0.0034749507904053
(279) DESCRIBE `cruiselines` 0.003328800201416
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0037858486175537
(281) DESCRIBE `cruises` 0.0062410831451416
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57176') 0.00060892105102539
(283) DESCRIBE `ships` 0.0059239864349365
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00075507164001465
(285) DESCRIBE `ships` 0.0037999153137207
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00054097175598145
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032806396484375
(289) DESCRIBE `itineraries` 0.0019328594207764
(290) DESCRIBE `ports` 0.0020999908447266
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00051617622375488
(292) DESCRIBE `ports` 0.0033478736877441
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00022482872009277
(294) DESCRIBE `ports` 0.0037620067596436
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00075483322143555
(296) DESCRIBE `sailingdates` 0.0016789436340332
(297) DESCRIBE `ports` 0.0023820400238037
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00050592422485352
(299) DESCRIBE `ports` 0.0018520355224609
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00043106079101562
(301) DESCRIBE `ports` 0.0018951892852783
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00057792663574219
(303) DESCRIBE `ports` 0.0018599033355713
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00041794776916504
(305) DESCRIBE `ports` 0.0019290447235107
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0006561279296875
(307) DESCRIBE `ports` 0.0033061504364014
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00059890747070312
(309) DESCRIBE `ports` 0.0018959045410156
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00052213668823242
(311) DESCRIBE `ports` 0.0019750595092773
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00045490264892578
(313) DESCRIBE `ports` 0.0019450187683105
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00045990943908691
(315) DESCRIBE `ports` 0.0019478797912598
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00041890144348145
(317) DESCRIBE `ports` 0.0033690929412842
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00082898139953613
(319) DESCRIBE `ports` 0.002086877822876
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00048089027404785
(321) DESCRIBE `ports` 0.0011868476867676
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00043106079101562
(323) DESCRIBE `ports` 0.0018539428710938
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.0054519176483154
(325) DESCRIBE `ports` 0.0096430778503418
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00068306922912598
(327) DESCRIBE `ports` 0.0103919506073
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.0022571086883545
(329) DESCRIBE `ports` 0.00223708152771
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0004880428314209
(331) DESCRIBE `ports` 0.0019290447235107
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00042510032653809
(333) DESCRIBE `ports` 0.0018808841705322
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00044512748718262
(335) DESCRIBE `ports` 0.0018630027770996
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00044989585876465
(337) DESCRIBE `ports` 0.0020301342010498
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00049710273742676
(339) DESCRIBE `ports` 0.0030629634857178
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00044107437133789
(341) DESCRIBE `ports` 0.0032498836517334
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.0005500316619873
(343) DESCRIBE `ports` 0.0019321441650391
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0004580020904541
(345) DESCRIBE `ports` 0.001317024230957
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00053906440734863
(347) DESCRIBE `ports` 0.0024268627166748
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00047397613525391
(349) DESCRIBE `ports` 0.0018901824951172
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00048589706420898
(351) DESCRIBE `ports` 0.001953125
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00041699409484863
(353) DESCRIBE `ports` 0.0019800662994385
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00084996223449707
(355) DESCRIBE `ports` 0.0031740665435791
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00047588348388672
(357) DESCRIBE `ports` 0.0017259120941162
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00051307678222656
(359) DESCRIBE `ports` 0.0018339157104492
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00052499771118164
(361) DESCRIBE `avid_specials` 0.0016729831695557
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57176 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0027949810028076
(363) DESCRIBE `cruiselines` 0.0046801567077637
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00057291984558105
(365) DESCRIBE `orchid_image` 0.002223014831543
(366) DESCRIBE `cruiselines` 0.0027830600738525
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0005500316619873
(368) DESCRIBE `cruises` 0.0039069652557373
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57119') 0.00037097930908203
(370) DESCRIBE `ships` 0.004734992980957
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 78))) 0.00093698501586914
(372) DESCRIBE `ships` 0.0039360523223877
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '78') 0.00065803527832031
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030684471130371
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029206275939941
(376) DESCRIBE `itineraries` 0.0020689964294434
(377) DESCRIBE `ports` 0.0032508373260498
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00049495697021484
(379) DESCRIBE `ports` 0.0022208690643311
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00066399574279785
(381) DESCRIBE `ports` 0.0015740394592285
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.0015640258789062
(383) DESCRIBE `sailingdates` 0.0016448497772217
(384) DESCRIBE `ports` 0.0018038749694824
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00056099891662598
(386) DESCRIBE `ports` 0.0017719268798828
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00039291381835938
(388) DESCRIBE `ports` 0.0018360614776611
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00043106079101562
(390) DESCRIBE `ports` 0.0019440650939941
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00041294097900391
(392) DESCRIBE `ports` 0.0027220249176025
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00083589553833008
(394) DESCRIBE `ports` 0.00189208984375
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.001021146774292
(396) DESCRIBE `ports` 0.0017969608306885
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 2.1457672119141E-6
(398) DESCRIBE `ports` 0.002094030380249
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 4.3153762817383E-5
(400) DESCRIBE `ports` 0.0019469261169434
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0
(402) DESCRIBE `ports` 0.0018370151519775
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00037002563476562
(404) DESCRIBE `ports` 0.0020420551300049
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0004889965057373
(406) DESCRIBE `ports` 0.0018301010131836
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00038480758666992
(408) DESCRIBE `ports` 0.0015900135040283
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00041484832763672
(410) DESCRIBE `ports` 0.0016908645629883
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00031590461730957
(412) DESCRIBE `ports` 0.0016520023345947
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00035595893859863
(414) DESCRIBE `ports` 0.001317024230957
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00032901763916016
(416) DESCRIBE `avid_specials` 0.001410961151123
(417) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57119 and class = 'Cruise') OR (item_id = 78 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014688968658447
(418) DESCRIBE `cruiselines` 0.0022299289703369
(419) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00049996376037598
(420) DESCRIBE `orchid_image` 0.0018899440765381
(421) DESCRIBE `cruiselines` 0.0022158622741699
(422) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00032186508178711
(423) DESCRIBE `cruises` 0.0026438236236572
(424) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66904') 0.0003349781036377
(425) DESCRIBE `ships` 0.0026979446411133
(426) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00048089027404785
(427) DESCRIBE `ships` 0.0036840438842773
(428) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00041890144348145
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034904479980469
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029397010803223
(431) DESCRIBE `itineraries` 0.0014400482177734
(432) DESCRIBE `ports` 0.0016911029815674
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00039100646972656
(434) DESCRIBE `ports` 0.0014071464538574
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00036096572875977
(436) DESCRIBE `ports` 0.0015759468078613
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0003821849822998
(438) DESCRIBE `sailingdates` 0.0015380382537842
(439) DESCRIBE `ports` 0.0014159679412842
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0004889965057373
(441) DESCRIBE `ports` 0.0017569065093994
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00046801567077637
(443) DESCRIBE `ports` 0.0018460750579834
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0014748573303223
(445) DESCRIBE `ports` 0.0018610954284668
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00041794776916504
(447) DESCRIBE `ports` 0.0016400814056396
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00048494338989258
(449) DESCRIBE `ports` 0.0019228458404541
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00042819976806641
(451) DESCRIBE `ports` 0.0016980171203613
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00051498413085938
(453) DESCRIBE `ports` 0.0019469261169434
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00042009353637695
(455) DESCRIBE `ports` 0.0021781921386719
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00047612190246582
(457) DESCRIBE `ports` 0.0024559497833252
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00052213668823242
(459) DESCRIBE `ports` 0.0019619464874268
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00050187110900879
(461) DESCRIBE `ports` 0.0019729137420654
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00041413307189941
(463) DESCRIBE `ports` 0.0018877983093262
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00048613548278809
(465) DESCRIBE `ports` 0.0019469261169434
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00041103363037109
(467) DESCRIBE `avid_specials` 0.0016829967498779
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66904 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021889209747314
(469) DESCRIBE `cruiselines` 0.0027198791503906
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00052094459533691
(471) DESCRIBE `orchid_image` 0.0020730495452881
(472) DESCRIBE `cruiselines` 0.0034511089324951
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00052690505981445
(474) DESCRIBE `cruises` 0.0039238929748535
(475) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68476') 0.0005190372467041
(476) DESCRIBE `ships` 0.0037980079650879
(477) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00074100494384766
(478) DESCRIBE `ships` 0.0039072036743164
(479) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00055193901062012
(480) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040197372436523
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034689903259277
(482) DESCRIBE `itineraries` 0.0019440650939941
(483) DESCRIBE `ports` 0.0019299983978271
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047111511230469
(485) DESCRIBE `ports` 0.0019688606262207
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0011770725250244
(487) DESCRIBE `ports` 0.0019419193267822
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00049281120300293
(489) DESCRIBE `sailingdates` 0.0028431415557861
(490) DESCRIBE `ports` 0.0018329620361328
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00046396255493164
(492) DESCRIBE `ports` 0.0022640228271484
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00051116943359375
(494) DESCRIBE `ports` 0.0017490386962891
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0004279613494873
(496) DESCRIBE `ports` 0.0017189979553223
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00039196014404297
(498) DESCRIBE `ports` 0.0018348693847656
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00043010711669922
(500) DESCRIBE `ports` 0.0016579627990723
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.0003349781036377
(502) DESCRIBE `ports` 0.0015349388122559
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00043988227844238
(504) DESCRIBE `ports` 0.001762866973877
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00038003921508789
(506) DESCRIBE `ports` 0.0017871856689453
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.0004580020904541
(508) DESCRIBE `ports` 0.0018038749694824
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00034189224243164
(510) DESCRIBE `ports` 0.0020251274108887
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00049304962158203
(512) DESCRIBE `ports` 0.0030059814453125
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00042581558227539
(514) DESCRIBE `ports` 0.0025148391723633
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00050210952758789
(516) DESCRIBE `ports` 0.002108097076416
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00043892860412598
(518) DESCRIBE `ports` 0.0020978450775146
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00051593780517578
(520) DESCRIBE `ports` 0.0022728443145752
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00047111511230469
(522) DESCRIBE `avid_specials` 0.0019059181213379
(523) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68476 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020651817321777
(524) DESCRIBE `cruiselines` 0.0029981136322021
(525) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00058102607727051
(526) DESCRIBE `orchid_image` 0.0023438930511475
(527) DESCRIBE `cruiselines` 0.0029900074005127
(528) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00047087669372559
(529) DESCRIBE `cruises` 0.0039010047912598
(530) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73204') 0.00051188468933105
(531) DESCRIBE `ships` 0.0050358772277832
(532) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00068020820617676
(533) DESCRIBE `ships` 0.0031869411468506
(534) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00044894218444824
(535) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031113624572754
(536) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029492378234863
(537) DESCRIBE `itineraries` 0.0016310214996338
(538) DESCRIBE `ports` 0.0018939971923828
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00063490867614746
(540) DESCRIBE `ports` 0.0015900135040283
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00038003921508789
(542) DESCRIBE `ports` 0.0014300346374512
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00039291381835938
(544) DESCRIBE `sailingdates` 0.0014748573303223
(545) DESCRIBE `ports` 0.0015139579772949
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00035500526428223
(547) DESCRIBE `ports` 0.001291036605835
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00032401084899902
(549) DESCRIBE `ports` 0.0014700889587402
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00041007995605469
(551) DESCRIBE `ports` 0.0019519329071045
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00043797492980957
(553) DESCRIBE `ports` 0.0018911361694336
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00040793418884277
(555) DESCRIBE `ports` 0.0015690326690674
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00037693977355957
(557) DESCRIBE `ports` 0.0015320777893066
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.0003969669342041
(559) DESCRIBE `ports` 0.0010688304901123
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00041103363037109
(561) DESCRIBE `ports` 0.0019218921661377
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00044012069702148
(563) DESCRIBE `ports` 0.0018200874328613
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00038599967956543
(565) DESCRIBE `ports` 0.0018270015716553
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00043892860412598
(567) DESCRIBE `ports` 0.0017609596252441
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0003669261932373
(569) DESCRIBE `ports` 0.0018448829650879
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00041794776916504
(571) DESCRIBE `ports` 0.0018799304962158
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00039196014404297
(573) DESCRIBE `ports` 0.0018649101257324
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00045990943908691
(575) DESCRIBE `ports` 0.0019829273223877
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00039100646972656
(577) DESCRIBE `ports` 0.0017549991607666
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00049090385437012
(579) DESCRIBE `ports` 0.0018219947814941
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00041294097900391
(581) DESCRIBE `avid_specials` 0.0016138553619385
(582) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73204 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017831325531006
(583) DESCRIBE `cruiselines` 0.0025691986083984
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00046706199645996
(585) DESCRIBE `orchid_image` 0.0019240379333496
(586) DESCRIBE `cruiselines` 0.0024049282073975
(587) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00037097930908203
(588) DESCRIBE `cruises` 0.0031290054321289
(589) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61616') 0.00042390823364258
(590) DESCRIBE `ships` 0.0032451152801514
(591) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00044488906860352
(592) DESCRIBE `ships` 0.0030210018157959
(593) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.00035786628723145
(594) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030803680419922
(595) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029492378234863
(596) DESCRIBE `itineraries` 0.0015931129455566
(597) DESCRIBE `ports` 0.0017299652099609
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00040912628173828
(599) DESCRIBE `ports` 0.0015220642089844
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00040817260742188
(601) DESCRIBE `ports` 0.0013880729675293
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00032591819763184
(603) DESCRIBE `sailingdates` 0.0012099742889404
(604) DESCRIBE `ports` 0.0015020370483398
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00042605400085449
(606) DESCRIBE `ports` 0.0014350414276123
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00030708312988281
(608) DESCRIBE `ports` 0.0014331340789795
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00033116340637207
(610) DESCRIBE `ports` 0.0013730525970459
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00040197372436523
(612) DESCRIBE `ports` 0.0016820430755615
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00041389465332031
(614) DESCRIBE `ports` 0.0017189979553223
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.0003349781036377
(616) DESCRIBE `ports` 0.0015480518341064
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00046491622924805
(618) DESCRIBE `ports` 0.0019230842590332
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00043416023254395
(620) DESCRIBE `ports` 0.0017709732055664
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00048208236694336
(622) DESCRIBE `ports` 0.0018410682678223
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0003209114074707
(624) DESCRIBE `ports` 0.0017390251159668
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00043511390686035
(626) DESCRIBE `ports` 0.0016448497772217
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00037908554077148
(628) DESCRIBE `ports` 0.0015790462493896
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00041007995605469
(630) DESCRIBE `ports` 0.0016028881072998
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00038313865661621
(632) DESCRIBE `ports` 0.001384973526001
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00032806396484375
(634) DESCRIBE `ports` 0.0016970634460449
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00037598609924316
(636) DESCRIBE `ports` 0.001492977142334
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00040197372436523
(638) DESCRIBE `ports` 0.0018858909606934
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.0004270076751709
(640) DESCRIBE `ports` 0.0018880367279053
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00036215782165527
(642) DESCRIBE `ports` 0.0018448829650879
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00031900405883789
(644) DESCRIBE `avid_specials` 0.0017490386962891
(645) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61616 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019800662994385
(646) DESCRIBE `cruiselines` 0.0026960372924805
(647) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00045108795166016
(648) DESCRIBE `orchid_image` 0.0015618801116943
(649) DESCRIBE `cruiselines` 0.0023717880249023
(650) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00040507316589355
(651) DESCRIBE `cruises` 0.0036239624023438
(652) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59773') 0.00053191184997559
(653) DESCRIBE `ships` 0.0037298202514648
(654) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00062704086303711
(655) DESCRIBE `ships` 0.0029449462890625
(656) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00038504600524902
(657) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027608871459961
(658) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003199577331543
(659) DESCRIBE `itineraries` 0.0017931461334229
(660) DESCRIBE `ports` 0.0020990371704102
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00046491622924805
(662) DESCRIBE `ports` 0.0017099380493164
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0003809928894043
(664) DESCRIBE `ports` 0.0016300678253174
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00031399726867676
(666) DESCRIBE `sailingdates` 0.0011980533599854
(667) DESCRIBE `ports` 0.0016911029815674
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00057506561279297
(669) DESCRIBE `ports` 0.0016329288482666
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00034189224243164
(671) DESCRIBE `ports` 0.0017709732055664
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00045204162597656
(673) DESCRIBE `ports` 0.0016210079193115
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00034785270690918
(675) DESCRIBE `ports` 0.0014410018920898
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00043201446533203
(677) DESCRIBE `ports` 0.0016310214996338
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00037980079650879
(679) DESCRIBE `ports` 0.0016388893127441
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00040316581726074
(681) DESCRIBE `ports` 0.0017411708831787
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00035309791564941
(683) DESCRIBE `ports` 0.0016820430755615
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.0004270076751709
(685) DESCRIBE `ports` 0.0017259120941162
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00044822692871094
(687) DESCRIBE `ports` 0.001835823059082
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00036501884460449
(689) DESCRIBE `ports` 0.0016200542449951
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00035381317138672
(691) DESCRIBE `ports` 0.0016899108886719
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00042986869812012
(693) DESCRIBE `ports` 0.0015878677368164
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00042104721069336
(695) DESCRIBE `ports` 0.0018758773803711
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00042104721069336
(697) DESCRIBE `ports` 0.0019118785858154
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00042414665222168
(699) DESCRIBE `avid_specials` 0.0017068386077881
(700) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59773 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018210411071777
(701) DESCRIBE `cruiselines` 0.002626895904541
(702) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00053310394287109
(703) DESCRIBE `orchid_image` 0.0020461082458496
(704) DESCRIBE `cruiselines` 0.0028131008148193
(705) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00046706199645996
(706) DESCRIBE `ships` 0.0040979385375977
(707) SELECT `ships`.* FROM `ships` WHERE (id IN ('1607', '792', '340', '1302', '81', '78', '401', '657', '547', '84', '335', '75', '82', '74', '313')) ORDER BY FIND_IN_SET(id, '1607,792,340,1302,81,78,401,657,547,84,335,75,82,74,313') 0.0020930767059326
(708) DESCRIBE `cruisetypes` 0.0017318725585938
(709) DESCRIBE `destinations` 0.0031259059906006
(710) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '2', '48', '43', '22', '35', '11', '53', '37', '25', '38', '34', '26', '40', '29', '21', '28', '49', '8', '9', '30')) ORDER BY FIND_IN_SET(id, '12,2,48,43,22,35,11,53,37,25,38,34,26,40,29,21,28,49,8,9,30') 0.0022141933441162
(711) DESCRIBE `cruiselines` 0.0030450820922852
(712) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00049209594726562
(713) DESCRIBE `cruiselines` 0.0023789405822754
(714) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00065898895263672