or, enquire about your chosen options

  1. Ovation of the Seas coming to Australia & New Zealand
  2. Heritage Expeditions: Secrets of Melanesia Cruise
  3. Vietnam Cruise a ‘must do’
  4. Explorer of the Seas to visit New Zealand
  5. Panama Canal – Norwegian Star

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

Total elapsed time: 0.38676023483276

# Query Time
(1) connect 0.0008080005645752
(2) DESCRIBE `cruises` 0.0012059211730957
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (24930, 58441, 60787, 58138, 46002, 53020, 53022, 52114, 52119, 58794)) ORDER BY FIND_IN_SET(id, '24930,58441,60787,58138,46002,53020,53022,52114,52119,58794') 0.001101016998291
(4) DESCRIBE `specials` 0.0013139247894287
(5) DESCRIBE `specials` 0.0011041164398193
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1173907') 0.00022602081298828
(7) DESCRIBE `ships` 0.00080204010009766
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 769))) 0.00025486946105957
(9) DESCRIBE `ships` 0.00080108642578125
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '769') 0.00019192695617676
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017118453979492
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017213821411133
(13) DESCRIBE `itineraries` 0.00052809715270996
(14) DESCRIBE `ports` 0.00053000450134277
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020980834960938
(16) DESCRIBE `ports` 0.00049614906311035
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0001990795135498
(18) DESCRIBE `ports` 0.00051784515380859
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017809867858887
(20) DESCRIBE `specialsailingdates` 0.00044584274291992
(21) DESCRIBE `sailingdates` 0.00048017501831055
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347309))) 0.00023007392883301
(23) DESCRIBE `sailingdates` 0.00044822692871094
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347310))) 0.00018596649169922
(25) DESCRIBE `sailingdates` 0.00044798851013184
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347311))) 0.00021600723266602
(27) DESCRIBE `sailingdates` 0.00044894218444824
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347312))) 0.00018501281738281
(29) DESCRIBE `sailingdates` 0.00044107437133789
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347313))) 0.00019001960754395
(31) DESCRIBE `sailingdates` 0.00044012069702148
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347314))) 0.00018906593322754
(33) DESCRIBE `sailingdates` 0.00046396255493164
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347316))) 0.00018501281738281
(35) DESCRIBE `sailingdates` 0.00043892860412598
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347315))) 0.00018906593322754
(37) DESCRIBE `sailingdates` 0.00044012069702148
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347317))) 0.00019001960754395
(39) DESCRIBE `sailingdates` 0.0004420280456543
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347318))) 0.00018906593322754
(41) DESCRIBE `sailingdates` 0.00044083595275879
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347319))) 0.00018882751464844
(43) DESCRIBE `sailingdates` 0.0004420280456543
(44) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347321))) 0.00018310546875
(45) DESCRIBE `sailingdates` 0.00046491622924805
(46) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347322))) 0.00019097328186035
(47) DESCRIBE `sailingdates` 0.00045514106750488
(48) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347323))) 0.00021219253540039
(49) DESCRIBE `sailingdates` 0.00049495697021484
(50) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347324))) 0.00024318695068359
(51) DESCRIBE `sailingdates` 0.00055599212646484
(52) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347325))) 0.00024199485778809
(53) DESCRIBE `sailingdates` 0.00056910514831543
(54) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 347326))) 0.00023293495178223
(55) DESCRIBE `sailingdates` 0.00058984756469727
(56) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380267))) 0.00024008750915527
(57) DESCRIBE `sailingdates` 0.00051784515380859
(58) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380268))) 0.00023293495178223
(59) DESCRIBE `sailingdates` 0.0004580020904541
(60) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380269))) 0.00025796890258789
(61) DESCRIBE `sailingdates` 0.00044894218444824
(62) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380270))) 0.00020217895507812
(63) DESCRIBE `sailingdates` 0.00047397613525391
(64) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380271))) 0.00019311904907227
(65) DESCRIBE `sailingdates` 0.00045108795166016
(66) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380272))) 0.00020289421081543
(67) DESCRIBE `sailingdates` 0.00044989585876465
(68) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380273))) 0.00020694732666016
(69) DESCRIBE `sailingdates` 0.0004429817199707
(70) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380274))) 0.00018978118896484
(71) DESCRIBE `sailingdates` 0.00044107437133789
(72) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380275))) 0.00021100044250488
(73) DESCRIBE `sailingdates` 0.00044703483581543
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380276))) 0.00018906593322754
(75) DESCRIBE `sailingdates` 0.00048995018005371
(76) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380277))) 0.00023412704467773
(77) DESCRIBE `sailingdates` 0.00048613548278809
(78) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380278))) 0.00020909309387207
(79) DESCRIBE `sailingdates` 0.0004730224609375
(80) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380279))) 0.00021219253540039
(81) DESCRIBE `sailingdates` 0.00044393539428711
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380280))) 0.00020194053649902
(83) DESCRIBE `sailingdates` 0.00045013427734375
(84) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380281))) 0.00023388862609863
(85) DESCRIBE `ports` 0.00054502487182617
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0002129077911377
(87) DESCRIBE `ports` 0.00049185752868652
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018906593322754
(89) DESCRIBE `ports` 0.00048613548278809
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00025296211242676
(91) DESCRIBE `ports` 0.00067400932312012
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00022506713867188
(93) DESCRIBE `ports` 0.00069999694824219
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00025105476379395
(95) DESCRIBE `ports` 0.00052714347839355
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00019097328186035
(97) DESCRIBE `ports` 0.0004889965057373
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.0001990795135498
(99) DESCRIBE `ports` 0.00049996376037598
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00018191337585449
(101) DESCRIBE `ports` 0.00048494338989258
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00020384788513184
(103) DESCRIBE `ports` 0.00048685073852539
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00018000602722168
(105) DESCRIBE `ports` 0.00047993659973145
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00020599365234375
(107) DESCRIBE `ports` 0.00054407119750977
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00017881393432617
(109) DESCRIBE `ports` 0.00049710273742676
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00019383430480957
(111) DESCRIBE `ports` 0.00050115585327148
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00018405914306641
(113) DESCRIBE `ports` 0.00049591064453125
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00023102760314941
(115) DESCRIBE `ports` 0.00048494338989258
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017881393432617
(117) DESCRIBE `ports` 0.00047898292541504
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.0001988410949707
(119) DESCRIBE `ports` 0.0004878044128418
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00018405914306641
(121) DESCRIBE `ports` 0.00048089027404785
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00019979476928711
(123) DESCRIBE `ports` 0.00048398971557617
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017786026000977
(125) DESCRIBE `ports` 0.00048494338989258
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00019502639770508
(127) DESCRIBE `ports` 0.00047588348388672
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00017404556274414
(129) DESCRIBE `ports` 0.00050997734069824
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00019502639770508
(131) DESCRIBE `ports` 0.00052189826965332
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00021004676818848
(133) DESCRIBE `ports` 0.00048208236694336
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00020503997802734
(135) DESCRIBE `ports` 0.00049090385437012
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00017881393432617
(137) DESCRIBE `ports` 0.00047898292541504
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00019717216491699
(139) DESCRIBE `ports` 0.00052785873413086
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00018095970153809
(141) DESCRIBE `ports` 0.00048184394836426
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00022101402282715
(143) DESCRIBE `ports` 0.00048708915710449
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017499923706055
(145) DESCRIBE `ports` 0.00051116943359375
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00022602081298828
(147) DESCRIBE `ports` 0.00049185752868652
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017404556274414
(149) DESCRIBE `ports` 0.00048279762268066
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019717216491699
(151) DESCRIBE `ports` 0.00050210952758789
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018095970153809
(153) DESCRIBE `ports` 0.00047779083251953
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019717216491699
(155) DESCRIBE `ports` 0.00047993659973145
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017380714416504
(157) DESCRIBE `cruises` 0.00090694427490234
(158) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 24930))) 0.0003049373626709
(159) DESCRIBE `avid_specials` 0.00045919418334961
(160) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1173907 and class = 'Special') OR (item_id = 24930 and class = 'Cruise') OR (item_id = 769 AND class = 'Ship') OR (item_id = 180 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.00066685676574707
(161) DESCRIBE `cruiselines` 0.00068998336791992
(162) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 180))) 0.00022387504577637
(163) DESCRIBE `orchid_image` 0.00055408477783203
(164) DESCRIBE `cruiselines` 0.00068879127502441
(165) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '180') 0.0001828670501709
(166) DESCRIBE `specials` 0.0013399124145508
(167) DESCRIBE `specials` 0.0012538433074951
(168) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1172149') 0.0001990795135498
(169) DESCRIBE `ships` 0.00081205368041992
(170) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1393))) 0.00024700164794922
(171) DESCRIBE `ships` 0.00080084800720215
(172) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1393') 0.0001838207244873
(173) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018095970153809
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(175) DESCRIBE `itineraries` 0.00048494338989258
(176) DESCRIBE `ports` 0.0004889965057373
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020194053649902
(178) DESCRIBE `ports` 0.0005340576171875
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00019216537475586
(180) DESCRIBE `ports` 0.00048995018005371
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018405914306641
(182) DESCRIBE `specialsailingdates` 0.00042414665222168
(183) DESCRIBE `sailingdates` 0.00044393539428711
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 368556))) 0.00034117698669434
(185) DESCRIBE `ports` 0.00050592422485352
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00019717216491699
(187) DESCRIBE `ports` 0.00050115585327148
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00017499923706055
(189) DESCRIBE `ports` 0.00047993659973145
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00022101402282715
(191) DESCRIBE `ports` 0.00049495697021484
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00017786026000977
(193) DESCRIBE `ports` 0.0004889965057373
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1516))) 0.00019693374633789
(195) DESCRIBE `ports` 0.00048303604125977
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1516') 0.00017690658569336
(197) DESCRIBE `ports` 0.00050497055053711
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1520))) 0.00020289421081543
(199) DESCRIBE `ports` 0.00048303604125977
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1520') 0.00017595291137695
(201) DESCRIBE `ports` 0.00049114227294922
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1201))) 0.00019693374633789
(203) DESCRIBE `ports` 0.00051593780517578
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1201') 0.00018191337585449
(205) DESCRIBE `ports` 0.00048089027404785
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1528))) 0.00022411346435547
(207) DESCRIBE `ports` 0.00075507164001465
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1528') 0.00036096572875977
(209) DESCRIBE `ports` 0.00074291229248047
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00025701522827148
(211) DESCRIBE `ports` 0.0006411075592041
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00020790100097656
(213) DESCRIBE `ports` 0.00061798095703125
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00024104118347168
(215) DESCRIBE `ports` 0.00060415267944336
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00020790100097656
(217) DESCRIBE `ports` 0.00060892105102539
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2634))) 0.00023913383483887
(219) DESCRIBE `ports` 0.00061917304992676
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2634') 0.0002129077911377
(221) DESCRIBE `ports` 0.00063586235046387
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00023603439331055
(223) DESCRIBE `ports` 0.00060701370239258
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00020694732666016
(225) DESCRIBE `ports` 0.00062108039855957
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00023984909057617
(227) DESCRIBE `ports` 0.00061678886413574
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00020599365234375
(229) DESCRIBE `cruises` 0.0010919570922852
(230) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58441))) 0.00034022331237793
(231) DESCRIBE `avid_specials` 0.00055503845214844
(232) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1172149 and class = 'Special') OR (item_id = 58441 and class = 'Cruise') OR (item_id = 1393 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00087904930114746
(233) DESCRIBE `cruiselines` 0.00084209442138672
(234) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00027298927307129
(235) DESCRIBE `orchid_image` 0.00065302848815918
(236) DESCRIBE `cruiselines` 0.00080490112304688
(237) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00026106834411621
(238) DESCRIBE `specials` 0.0017199516296387
(239) DESCRIBE `specials` 0.0014278888702393
(240) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1172032') 0.00020599365234375
(241) DESCRIBE `ships` 0.00079989433288574
(242) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00026488304138184
(243) DESCRIBE `ships` 0.00077104568481445
(244) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.00018095970153809
(245) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(247) DESCRIBE `itineraries` 0.0004730224609375
(248) DESCRIBE `ports` 0.00049018859863281
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020503997802734
(250) DESCRIBE `ports` 0.00049996376037598
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0001990795135498
(252) DESCRIBE `ports` 0.0004889965057373
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0001828670501709
(254) DESCRIBE `specialsailingdates` 0.00050497055053711
(255) DESCRIBE `sailingdates` 0.00045299530029297
(256) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385228))) 0.00031399726867676
(257) DESCRIBE `sailingdates` 0.00044894218444824
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385229))) 0.00019693374633789
(259) DESCRIBE `sailingdates` 0.0004429817199707
(260) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385230))) 0.00019383430480957
(261) DESCRIBE `sailingdates` 0.00049805641174316
(262) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385231))) 0.00019693374633789
(263) DESCRIBE `sailingdates` 0.00049090385437012
(264) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385232))) 0.0001978874206543
(265) DESCRIBE `sailingdates` 0.00044417381286621
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385233))) 0.00019407272338867
(267) DESCRIBE `sailingdates` 0.00043988227844238
(268) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385234))) 0.00020408630371094
(269) DESCRIBE `sailingdates` 0.00046896934509277
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385235))) 0.00019383430480957
(271) DESCRIBE `sailingdates` 0.0004429817199707
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385236))) 0.0001978874206543
(273) DESCRIBE `sailingdates` 0.00045013427734375
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385237))) 0.00019288063049316
(275) DESCRIBE `sailingdates` 0.00044703483581543
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385238))) 0.00022196769714355
(277) DESCRIBE `sailingdates` 0.00044417381286621
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385239))) 0.0001988410949707
(279) DESCRIBE `sailingdates` 0.0004429817199707
(280) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385240))) 0.00018692016601562
(281) DESCRIBE `sailingdates` 0.00044798851013184
(282) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385241))) 0.00022411346435547
(283) DESCRIBE `sailingdates` 0.00044083595275879
(284) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385242))) 0.00019311904907227
(285) DESCRIBE `sailingdates` 0.00044107437133789
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385243))) 0.00019407272338867
(287) DESCRIBE `sailingdates` 0.00044894218444824
(288) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385244))) 0.00019383430480957
(289) DESCRIBE `sailingdates` 0.00044488906860352
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385245))) 0.00019192695617676
(291) DESCRIBE `sailingdates` 0.00044393539428711
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385246))) 0.00019288063049316
(293) DESCRIBE `sailingdates` 0.00044107437133789
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385247))) 0.00024604797363281
(295) DESCRIBE `sailingdates` 0.00044894218444824
(296) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385248))) 0.0002140998840332
(297) DESCRIBE `ports` 0.0005030632019043
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020599365234375
(299) DESCRIBE `ports` 0.00049090385437012
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00018095970153809
(301) DESCRIBE `ports` 0.00048708915710449
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00023102760314941
(303) DESCRIBE `ports` 0.00051784515380859
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00019192695617676
(305) DESCRIBE `ports` 0.00048494338989258
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.0002291202545166
(307) DESCRIBE `ports` 0.00065302848815918
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.0001990795135498
(309) DESCRIBE `ports` 0.00052714347839355
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 189))) 0.00020885467529297
(311) DESCRIBE `ports` 0.00049400329589844
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '189') 0.00043106079101562
(313) DESCRIBE `ports` 0.00049901008605957
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00026702880859375
(315) DESCRIBE `ports` 0.00049495697021484
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00023007392883301
(317) DESCRIBE `ports` 0.00055813789367676
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0001988410949707
(319) DESCRIBE `ports` 0.00049495697021484
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017595291137695
(321) DESCRIBE `cruises` 0.00093197822570801
(322) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 60787))) 0.00033783912658691
(323) DESCRIBE `avid_specials` 0.00045394897460938
(324) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1172032 and class = 'Special') OR (item_id = 60787 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00060796737670898
(325) DESCRIBE `cruiselines` 0.00064706802368164
(326) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00021600723266602
(327) DESCRIBE `orchid_image` 0.00055313110351562
(328) DESCRIBE `cruiselines` 0.00064516067504883
(329) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00017905235290527
(330) DESCRIBE `specials` 0.0013680458068848
(331) DESCRIBE `specials` 0.0011749267578125
(332) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1172177') 0.00020909309387207
(333) DESCRIBE `ships` 0.00078487396240234
(334) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1328))) 0.00025486946105957
(335) DESCRIBE `ships` 0.00077104568481445
(336) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1328') 0.00019407272338867
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018095970153809
(338) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(339) DESCRIBE `itineraries` 0.00047492980957031
(340) DESCRIBE `ports` 0.00058913230895996
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00021600723266602
(342) DESCRIBE `ports` 0.00048303604125977
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.0001981258392334
(344) DESCRIBE `ports` 0.00048303604125977
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00021600723266602
(346) DESCRIBE `specialsailingdates` 0.00043010711669922
(347) DESCRIBE `sailingdates` 0.00045394897460938
(348) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 367772))) 0.00033807754516602
(349) DESCRIBE `ports` 0.0005030632019043
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00022482872009277
(351) DESCRIBE `ports` 0.0004889965057373
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018405914306641
(353) DESCRIBE `ports` 0.00057005882263184
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020790100097656
(355) DESCRIBE `ports` 0.00052118301391602
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00021100044250488
(357) DESCRIBE `ports` 0.0004880428314209
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2634))) 0.00020790100097656
(359) DESCRIBE `ports` 0.00058889389038086
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2634') 0.00018191337585449
(361) DESCRIBE `ports` 0.00049781799316406
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020694732666016
(363) DESCRIBE `ports` 0.0004889965057373
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018501281738281
(365) DESCRIBE `ports` 0.00048708915710449
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00020790100097656
(367) DESCRIBE `ports` 0.00049400329589844
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00028705596923828
(369) DESCRIBE `ports` 0.00066208839416504
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00026082992553711
(371) DESCRIBE `ports` 0.00065183639526367
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00023698806762695
(373) DESCRIBE `ports` 0.00062799453735352
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.0002439022064209
(375) DESCRIBE `ports` 0.00061202049255371
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00022506713867188
(377) DESCRIBE `ports` 0.0006401538848877
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1567))) 0.00025510787963867
(379) DESCRIBE `ports` 0.00061678886413574
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1567') 0.00019216537475586
(381) DESCRIBE `ports` 0.0004878044128418
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00020480155944824
(383) DESCRIBE `ports` 0.00050115585327148
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00020098686218262
(385) DESCRIBE `ports` 0.00048613548278809
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00020813941955566
(387) DESCRIBE `ports` 0.00048589706420898
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00017595291137695
(389) DESCRIBE `ports` 0.00050091743469238
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00020194053649902
(391) DESCRIBE `ports` 0.00050902366638184
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00018620491027832
(393) DESCRIBE `ports` 0.00048303604125977
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1573))) 0.00019693374633789
(395) DESCRIBE `ports` 0.00050115585327148
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1573') 0.00018215179443359
(397) DESCRIBE `ports` 0.00054311752319336
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00020599365234375
(399) DESCRIBE `ports` 0.00052285194396973
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00017595291137695
(401) DESCRIBE `ports` 0.00048089027404785
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00019717216491699
(403) DESCRIBE `ports` 0.00049495697021484
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00017499923706055
(405) DESCRIBE `ports` 0.00048494338989258
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00019693374633789
(407) DESCRIBE `ports` 0.00048303604125977
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00017404556274414
(409) DESCRIBE `ports` 0.00050210952758789
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00019598007202148
(411) DESCRIBE `ports` 0.00048995018005371
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00018692016601562
(413) DESCRIBE `ports` 0.00052094459533691
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.0001988410949707
(415) DESCRIBE `ports` 0.0004880428314209
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00022220611572266
(417) DESCRIBE `ports` 0.00048398971557617
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020694732666016
(419) DESCRIBE `ports` 0.00049185752868652
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00017499923706055
(421) DESCRIBE `ports` 0.00048017501831055
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.0001978874206543
(423) DESCRIBE `ports` 0.00049090385437012
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00018095970153809
(425) DESCRIBE `ports` 0.00048112869262695
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0001990795135498
(427) DESCRIBE `ports` 0.00049495697021484
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018405914306641
(429) DESCRIBE `ports` 0.00055694580078125
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0001978874206543
(431) DESCRIBE `ports` 0.00048208236694336
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00017714500427246
(433) DESCRIBE `cruises` 0.00088405609130859
(434) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58138))) 0.00030708312988281
(435) DESCRIBE `avid_specials` 0.00046396255493164
(436) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1172177 and class = 'Special') OR (item_id = 58138 and class = 'Cruise') OR (item_id = 1328 AND class = 'Ship') OR (item_id = 140 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00062203407287598
(437) DESCRIBE `cruiselines` 0.00064802169799805
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 140))) 0.00023698806762695
(439) DESCRIBE `orchid_image` 0.00053095817565918
(440) DESCRIBE `cruiselines` 0.00069880485534668
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '140') 0.00017786026000977
(442) DESCRIBE `specials` 0.0013229846954346
(443) DESCRIBE `specials` 0.0011658668518066
(444) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1179880') 0.00020194053649902
(445) DESCRIBE `ships` 0.00080108642578125
(446) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 791))) 0.00023889541625977
(447) DESCRIBE `ships` 0.00083589553833008
(448) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '791') 0.00018000602722168
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(451) DESCRIBE `itineraries` 0.00054097175598145
(452) DESCRIBE `ports` 0.00050497055053711
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020599365234375
(454) DESCRIBE `ports` 0.00047707557678223
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0001978874206543
(456) DESCRIBE `ports` 0.00047993659973145
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00020408630371094
(458) DESCRIBE `specialsailingdates` 0.00058507919311523
(459) DESCRIBE `sailingdates` 0.00047206878662109
(460) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 322440))) 0.00024294853210449
(461) DESCRIBE `ports` 0.00051593780517578
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023102760314941
(463) DESCRIBE `ports` 0.00050997734069824
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018215179443359
(465) DESCRIBE `ports` 0.00052905082702637
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00020194053649902
(467) DESCRIBE `ports` 0.000518798828125
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00017905235290527
(469) DESCRIBE `ports` 0.00052809715270996
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00022411346435547
(471) DESCRIBE `ports` 0.00053000450134277
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00018405914306641
(473) DESCRIBE `ports` 0.00050187110900879
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020790100097656
(475) DESCRIBE `ports` 0.00057601928710938
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00023913383483887
(477) DESCRIBE `ports` 0.00066018104553223
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020980834960938
(479) DESCRIBE `ports` 0.00049209594726562
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002138614654541
(481) DESCRIBE `cruises` 0.00084590911865234
(482) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 46002))) 0.00026917457580566
(483) DESCRIBE `avid_specials` 0.00046801567077637
(484) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1179880 and class = 'Special') OR (item_id = 46002 and class = 'Cruise') OR (item_id = 791 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00063896179199219
(485) DESCRIBE `cruiselines` 0.00066614151000977
(486) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00024199485778809
(487) DESCRIBE `orchid_image` 0.00053906440734863
(488) DESCRIBE `cruiselines` 0.00065994262695312
(489) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018095970153809
(490) DESCRIBE `specials` 0.0016040802001953
(491) DESCRIBE `specials` 0.0015041828155518
(492) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1171997') 0.00023007392883301
(493) DESCRIBE `ships` 0.0008552074432373
(494) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00025391578674316
(495) DESCRIBE `ships` 0.00087404251098633
(496) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00021100044250488
(497) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018310546875
(498) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017404556274414
(499) DESCRIBE `itineraries` 0.00049996376037598
(500) DESCRIBE `ports` 0.00049901008605957
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023388862609863
(502) DESCRIBE `ports` 0.00060296058654785
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020718574523926
(504) DESCRIBE `ports` 0.00068902969360352
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018715858459473
(506) DESCRIBE `specialsailingdates` 0.00056099891662598
(507) DESCRIBE `sailingdates` 0.00049519538879395
(508) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369639))) 0.00034189224243164
(509) DESCRIBE `sailingdates` 0.0005180835723877
(510) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369640))) 0.00019192695617676
(511) DESCRIBE `sailingdates` 0.00044989585876465
(512) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369641))) 0.00019502639770508
(513) DESCRIBE `sailingdates` 0.00053691864013672
(514) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369642))) 0.00019502639770508
(515) DESCRIBE `sailingdates` 0.00044608116149902
(516) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369643))) 0.00019097328186035
(517) DESCRIBE `sailingdates` 0.00056099891662598
(518) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369644))) 0.00019001960754395
(519) DESCRIBE `sailingdates` 0.00045895576477051
(520) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369645))) 0.00019502639770508
(521) DESCRIBE `sailingdates` 0.00044703483581543
(522) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369646))) 0.00018692016601562
(523) DESCRIBE `sailingdates` 0.00045204162597656
(524) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369647))) 0.00022196769714355
(525) DESCRIBE `sailingdates` 0.00056815147399902
(526) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369648))) 0.00019717216491699
(527) DESCRIBE `sailingdates` 0.00050210952758789
(528) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369649))) 0.00019502639770508
(529) DESCRIBE `sailingdates` 0.00061893463134766
(530) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369650))) 0.00020980834960938
(531) DESCRIBE `sailingdates` 0.00051021575927734
(532) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369651))) 0.00020194053649902
(533) DESCRIBE `ports` 0.00059103965759277
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021195411682129
(535) DESCRIBE `ports` 0.00053596496582031
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018882751464844
(537) DESCRIBE `ports` 0.0005040168762207
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020194053649902
(539) DESCRIBE `ports` 0.00072383880615234
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00019502639770508
(541) DESCRIBE `ports` 0.00051498413085938
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00022697448730469
(543) DESCRIBE `ports` 0.00054597854614258
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00018191337585449
(545) DESCRIBE `ports` 0.00054097175598145
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020194053649902
(547) DESCRIBE `ports` 0.0006401538848877
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020718574523926
(549) DESCRIBE `ports` 0.00050091743469238
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2752))) 0.00026893615722656
(551) DESCRIBE `ports` 0.00070405006408691
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2752') 0.00019407272338867
(553) DESCRIBE `ports` 0.00054001808166504
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020217895507812
(555) DESCRIBE `ports` 0.00058388710021973
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00023984909057617
(557) DESCRIBE `cruises` 0.00096893310546875
(558) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 53020))) 0.00029087066650391
(559) DESCRIBE `avid_specials` 0.00047993659973145
(560) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1171997 and class = 'Special') OR (item_id = 53020 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00062894821166992
(561) DESCRIBE `cruiselines` 0.00079607963562012
(562) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00029683113098145
(563) DESCRIBE `orchid_image` 0.00055789947509766
(564) DESCRIBE `cruiselines` 0.00080180168151855
(565) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00020003318786621
(566) DESCRIBE `specials` 0.0015068054199219
(567) DESCRIBE `specials` 0.0012669563293457
(568) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1172027') 0.00023293495178223
(569) DESCRIBE `ships` 0.00092411041259766
(570) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.0002751350402832
(571) DESCRIBE `ships` 0.00078511238098145
(572) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00024104118347168
(573) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020599365234375
(574) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017499923706055
(575) DESCRIBE `itineraries` 0.0005640983581543
(576) DESCRIBE `ports` 0.00068402290344238
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002598762512207
(578) DESCRIBE `ports` 0.00050997734069824
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020790100097656
(580) DESCRIBE `ports` 0.00053596496582031
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022697448730469
(582) DESCRIBE `specialsailingdates` 0.00051212310791016
(583) DESCRIBE `sailingdates` 0.00081896781921387
(584) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369657))) 0.00028896331787109
(585) DESCRIBE `sailingdates` 0.00048685073852539
(586) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369658))) 0.00022602081298828
(587) DESCRIBE `sailingdates` 0.00048398971557617
(588) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369659))) 0.00018906593322754
(589) DESCRIBE `sailingdates` 0.00053215026855469
(590) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369660))) 0.00023508071899414
(591) DESCRIBE `sailingdates` 0.00047016143798828
(592) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369661))) 0.00020599365234375
(593) DESCRIBE `sailingdates` 0.00047492980957031
(594) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369662))) 0.0001981258392334
(595) DESCRIBE `sailingdates` 0.00047898292541504
(596) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369663))) 0.00020098686218262
(597) DESCRIBE `sailingdates` 0.00045990943908691
(598) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369664))) 0.00023603439331055
(599) DESCRIBE `sailingdates` 0.0006861686706543
(600) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369665))) 0.00026392936706543
(601) DESCRIBE `sailingdates` 0.00064706802368164
(602) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369666))) 0.00025606155395508
(603) DESCRIBE `sailingdates` 0.00058484077453613
(604) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369667))) 0.00031208992004395
(605) DESCRIBE `sailingdates` 0.00063109397888184
(606) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369668))) 0.00036907196044922
(607) DESCRIBE `ports` 0.00068092346191406
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00027108192443848
(609) DESCRIBE `ports` 0.00080299377441406
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022602081298828
(611) DESCRIBE `ports` 0.0007932186126709
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00026702880859375
(613) DESCRIBE `ports` 0.00068092346191406
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00040006637573242
(615) DESCRIBE `ports` 0.00083780288696289
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00029897689819336
(617) DESCRIBE `ports` 0.00076103210449219
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00024008750915527
(619) DESCRIBE `ports` 0.00075197219848633
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00026893615722656
(621) DESCRIBE `ports` 0.00082707405090332
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00025486946105957
(623) DESCRIBE `cruises` 0.0012481212615967
(624) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 53022))) 0.00039505958557129
(625) DESCRIBE `avid_specials` 0.00066614151000977
(626) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1172027 and class = 'Special') OR (item_id = 53022 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001082181930542
(627) DESCRIBE `cruiselines` 0.001060962677002
(628) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00031185150146484
(629) DESCRIBE `orchid_image` 0.00086116790771484
(630) DESCRIBE `cruiselines` 0.00095987319946289
(631) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00026488304138184
(632) DESCRIBE `specials` 0.0021469593048096
(633) DESCRIBE `specials` 0.0021851062774658
(634) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1173623') 0.0003199577331543
(635) DESCRIBE `ships` 0.0012660026550293
(636) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.00036406517028809
(637) DESCRIBE `ships` 0.0012359619140625
(638) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00024509429931641
(639) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024008750915527
(640) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023508071899414
(641) DESCRIBE `itineraries` 0.00072693824768066
(642) DESCRIBE `ports` 0.00073409080505371
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00028610229492188
(644) DESCRIBE `ports` 0.00077104568481445
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002739429473877
(646) DESCRIBE `ports` 0.00073695182800293
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00025796890258789
(648) DESCRIBE `specialsailingdates` 0.00065898895263672
(649) DESCRIBE `sailingdates` 0.00051999092102051
(650) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 330512))) 0.00024914741516113
(651) DESCRIBE `ports` 0.00061607360839844
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002131462097168
(653) DESCRIBE `ports` 0.00055789947509766
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018501281738281
(655) DESCRIBE `ports` 0.00059390068054199
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020790100097656
(657) DESCRIBE `ports` 0.00052404403686523
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00026702880859375
(659) DESCRIBE `ports` 0.00080704689025879
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 865))) 0.0003211498260498
(661) DESCRIBE `ports` 0.00059294700622559
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '865') 0.00020885467529297
(663) DESCRIBE `ports` 0.00076603889465332
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.0002739429473877
(665) DESCRIBE `ports` 0.00090694427490234
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00023889541625977
(667) DESCRIBE `ports` 0.00071406364440918
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00028800964355469
(669) DESCRIBE `ports` 0.00069594383239746
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018191337585449
(671) DESCRIBE `ports` 0.00061583518981934
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3014))) 0.00028300285339355
(673) DESCRIBE `ports` 0.00083398818969727
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3014') 0.00023484230041504
(675) DESCRIBE `ports` 0.00078892707824707
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0003199577331543
(677) DESCRIBE `ports` 0.00051593780517578
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00021696090698242
(679) DESCRIBE `ports` 0.00070691108703613
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00028204917907715
(681) DESCRIBE `ports` 0.00071597099304199
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.00023698806762695
(683) DESCRIBE `ports` 0.0007939338684082
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00026512145996094
(685) DESCRIBE `ports` 0.00052905082702637
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.0001838207244873
(687) DESCRIBE `ports` 0.00050902366638184
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00027012825012207
(689) DESCRIBE `ports` 0.00081896781921387
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00019288063049316
(691) DESCRIBE `ports` 0.00066900253295898
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021505355834961
(693) DESCRIBE `ports` 0.00061202049255371
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021505355834961
(695) DESCRIBE `cruises` 0.00089788436889648
(696) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52114))) 0.00030708312988281
(697) DESCRIBE `avid_specials` 0.00051307678222656
(698) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1173623 and class = 'Special') OR (item_id = 52114 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 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.00072979927062988
(699) DESCRIBE `cruiselines` 0.00073385238647461
(700) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00029182434082031
(701) DESCRIBE `orchid_image` 0.00085282325744629
(702) DESCRIBE `cruiselines` 0.00099802017211914
(703) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0002589225769043
(704) DESCRIBE `specials` 0.0019869804382324
(705) DESCRIBE `specials` 0.0016109943389893
(706) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1173536') 0.00024700164794922
(707) DESCRIBE `ships` 0.0010471343994141
(708) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00033903121948242
(709) DESCRIBE `ships` 0.00086402893066406
(710) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00023102760314941
(711) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019097328186035
(712) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017094612121582
(713) DESCRIBE `itineraries` 0.00049304962158203
(714) DESCRIBE `ports` 0.00056910514831543
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00023913383483887
(716) DESCRIBE `ports` 0.00063300132751465
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00020003318786621
(718) DESCRIBE `ports` 0.00049114227294922
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00021004676818848
(720) DESCRIBE `specialsailingdates` 0.00062894821166992
(721) DESCRIBE `sailingdates` 0.00046706199645996
(722) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 330511))) 0.0002138614654541
(723) DESCRIBE `ports` 0.0006108283996582
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00022411346435547
(725) DESCRIBE `ports` 0.00054001808166504
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0001981258392334
(727) DESCRIBE `ports` 0.0005180835723877
(728) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00020599365234375
(729) DESCRIBE `ports` 0.0005040168762207
(730) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00022196769714355
(731) DESCRIBE `ports` 0.00070595741271973
(732) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00023198127746582
(733) DESCRIBE `ports` 0.00051021575927734
(734) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00019001960754395
(735) DESCRIBE `ports` 0.0005030632019043
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00020194053649902
(737) DESCRIBE `ports` 0.00057578086853027
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00018405914306641
(739) DESCRIBE `ports` 0.0005030632019043
(740) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020599365234375
(741) DESCRIBE `ports` 0.00068187713623047
(742) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00020313262939453
(743) DESCRIBE `ports` 0.00078606605529785
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 34))) 0.00028610229492188
(745) DESCRIBE `ports` 0.00077700614929199
(746) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '34') 0.0002140998840332
(747) DESCRIBE `ports` 0.00063109397888184
(748) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0002129077911377
(749) DESCRIBE `ports` 0.00070905685424805
(750) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018787384033203
(751) DESCRIBE `ports` 0.00056600570678711
(752) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0003049373626709
(753) DESCRIBE `ports` 0.00088191032409668
(754) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00025010108947754
(755) DESCRIBE `ports` 0.00071811676025391
(756) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00031495094299316
(757) DESCRIBE `ports` 0.00085091590881348
(758) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00024700164794922
(759) DESCRIBE `cruises` 0.0013649463653564
(760) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52119))) 0.00039005279541016
(761) DESCRIBE `avid_specials` 0.00064992904663086
(762) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1173536 and class = 'Special') OR (item_id = 52119 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 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.00082492828369141
(763) DESCRIBE `cruiselines` 0.00071907043457031
(764) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00023007392883301
(765) DESCRIBE `orchid_image` 0.00054693222045898
(766) DESCRIBE `cruiselines` 0.00068783760070801
(767) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00018596649169922
(768) DESCRIBE `specials` 0.0015249252319336
(769) DESCRIBE `specials` 0.001349925994873
(770) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1172030') 0.00027298927307129
(771) DESCRIBE `ships` 0.001230001449585
(772) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00040197372436523
(773) DESCRIBE `ships` 0.0011968612670898
(774) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00025200843811035
(775) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022602081298828
(776) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017905235290527
(777) DESCRIBE `itineraries` 0.00051999092102051
(778) DESCRIBE `ports` 0.00051307678222656
(779) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002129077911377
(780) DESCRIBE `ports` 0.00071096420288086
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022101402282715
(782) DESCRIBE `ports` 0.00049090385437012
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020194053649902
(784) DESCRIBE `specialsailingdates` 0.0005340576171875
(785) DESCRIBE `sailingdates` 0.00067877769470215
(786) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369683))) 0.00027012825012207
(787) DESCRIBE `sailingdates` 0.000701904296875
(788) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369684))) 0.000244140625
(789) DESCRIBE `sailingdates` 0.00058293342590332
(790) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369685))) 0.00023293495178223
(791) DESCRIBE `sailingdates` 0.00058603286743164
(792) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369686))) 0.00023102760314941
(793) DESCRIBE `sailingdates` 0.00053310394287109
(794) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369687))) 0.0002291202545166
(795) DESCRIBE `sailingdates` 0.00050902366638184
(796) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369688))) 0.0001990795135498
(797) DESCRIBE `sailingdates` 0.00045895576477051
(798) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369689))) 0.00019598007202148
(799) DESCRIBE `sailingdates` 0.0005180835723877
(800) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369690))) 0.00018715858459473
(801) DESCRIBE `sailingdates` 0.00054597854614258
(802) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369691))) 0.00019598007202148
(803) DESCRIBE `sailingdates` 0.00045299530029297
(804) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369692))) 0.00018692016601562
(805) DESCRIBE `sailingdates` 0.00051999092102051
(806) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369693))) 0.00019407272338867
(807) DESCRIBE `ports` 0.00061798095703125
(808) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00025105476379395
(809) DESCRIBE `ports` 0.00057601928710938
(810) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022077560424805
(811) DESCRIBE `ports` 0.00058817863464355
(812) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00020194053649902
(813) DESCRIBE `ports` 0.00051307678222656
(814) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00019693374633789
(815) DESCRIBE `ports` 0.00051379203796387
(816) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020098686218262
(817) DESCRIBE `ports` 0.00059199333190918
(818) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020098686218262
(819) DESCRIBE `cruises` 0.00088596343994141
(820) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58794))) 0.00028491020202637
(821) DESCRIBE `avid_specials` 0.00051999092102051
(822) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1172030 and class = 'Special') OR (item_id = 58794 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00065398216247559
(823) DESCRIBE `cruiselines` 0.00067496299743652
(824) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00044083595275879
(825) DESCRIBE `orchid_image` 0.00070810317993164
(826) DESCRIBE `cruiselines` 0.00066304206848145
(827) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00019216537475586
(828) DESCRIBE `cruiselines` 0.0062711238861084
(829) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('101', '38', '263', '91', '33', '223', '180', '144', '208', '24', '26', '23', '151', '147', '37', '28', '188', '29', '77', '114', '140', '212', '8', '15', '4', '20', '50', '96', '18', '19', '59')) ORDER BY FIND_IN_SET(id, '101,38,263,91,33,223,180,144,208,24,26,23,151,147,37,28,188,29,77,114,140,212,8,15,4,20,50,96,18,19,59') 0.010641098022461
(830) DESCRIBE `ships` 0.0011880397796631
(831) SELECT `ships`.* FROM `ships` WHERE (id IN ('1082', '684', '769', '727', '189', '1456', '163', '966', '1321', '1457', '1223', '1224', '616', '1159', '1237', '1063', '650', '1355', '1054', '394', '988', '1154', '108', '823', '338', '790', '1013', '451', '508', '783', '796', '1108', '1318', '4', '105', '147', '748', '850', '262', '791', '1037', '1051', '1075', '1319', '43', '111', '115', '124', '205', '258', '287', '349', '483', '573', '580', '704', '780', '937', '938', '1078', '1109', '1168', '45', '82', '84', '93', '97', '149', '212', '253', '299', '448', '585', '626', '683', '722', '726', '733', '741', '765', '768', '835', '905', '907', '963', '977', '996', '1034', '1055', '1073', '1138', '1148', '1233', '1325', '1328', '1393', '1453', '1459', '1464')) ORDER BY FIND_IN_SET(id, '1082,684,769,727,189,1456,163,966,1321,1457,1223,1224,616,1159,1237,1063,650,1355,1054,394,988,1154,108,823,338,790,1013,451,508,783,796,1108,1318,4,105,147,748,850,262,791,1037,1051,1075,1319,43,111,115,124,205,258,287,349,483,573,580,704,780,937,938,1078,1109,1168,45,82,84,93,97,149,212,253,299,448,585,626,683,722,726,733,741,765,768,835,905,907,963,977,996,1034,1055,1073,1138,1148,1233,1325,1328,1393,1453,1459,1464') 0.0037550926208496
(832) DESCRIBE `cruisetypes` 0.00080418586730957
(833) DESCRIBE `destinations` 0.00065803527832031
(834) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '35', '43', '54', '22', '12', '2', '8', '40', '39', '48', '53', '26', '52', '30', '37', '45', '25', '28', '29', '7', '11')) ORDER BY FIND_IN_SET(id, '50,35,43,54,22,12,2,8,40,39,48,53,26,52,30,37,45,25,28,29,7,11') 0.000946044921875