or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

Total elapsed time: 0.61579442024231

# Query Time
(1) connect 0.0015048980712891
(2) DESCRIBE `cruises` 0.0042600631713867
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72065, 62654, 62662, 69279, 70379, 76805, 69258, 71829, 75673, 62663)) ORDER BY FIND_IN_SET(id, '72065,62654,62662,69279,70379,76805,69258,71829,75673,62663') 0.0022649765014648
(4) DESCRIBE `cruises` 0.0039808750152588
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72065') 0.0010218620300293
(6) DESCRIBE `ships` 0.0038130283355713
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.0010862350463867
(8) DESCRIBE `ships` 0.0031020641326904
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00034499168395996
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026106834411621
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030016899108887
(12) DESCRIBE `itineraries` 0.0013329982757568
(13) DESCRIBE `ports` 0.001755952835083
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034904479980469
(15) DESCRIBE `ports` 0.0012590885162354
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031208992004395
(17) DESCRIBE `ports` 0.0016109943389893
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041604042053223
(19) DESCRIBE `sailingdates` 0.001568078994751
(20) DESCRIBE `ports` 0.0013139247894287
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033402442932129
(22) DESCRIBE `ports` 0.0012948513031006
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027704238891602
(24) DESCRIBE `ports` 0.0013589859008789
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029087066650391
(26) DESCRIBE `ports` 0.0018870830535889
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0004119873046875
(28) DESCRIBE `ports` 0.0011191368103027
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031709671020508
(30) DESCRIBE `ports` 0.0016791820526123
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0003969669342041
(32) DESCRIBE `ports` 0.0014009475708008
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035881996154785
(34) DESCRIBE `ports` 0.0016629695892334
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030684471130371
(36) DESCRIBE `ports` 0.001133918762207
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0003669261932373
(38) DESCRIBE `ports` 0.0013329982757568
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00028705596923828
(40) DESCRIBE `ports` 0.0013899803161621
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00029611587524414
(42) DESCRIBE `ports` 0.0018489360809326
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00023102760314941
(44) DESCRIBE `ports` 0.0014059543609619
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00029897689819336
(46) DESCRIBE `ports` 0.0012319087982178
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00029611587524414
(48) DESCRIBE `ports` 0.0017831325531006
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00026893615722656
(50) DESCRIBE `ports` 0.0017831325531006
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00028896331787109
(52) DESCRIBE `ports` 0.0013959407806396
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003049373626709
(54) DESCRIBE `ports` 0.0012590885162354
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00066614151000977
(56) DESCRIBE `avid_specials` 0.0014209747314453
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72065 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 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.0013139247894287
(58) DESCRIBE `cruiselines` 0.0020468235015869
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00031805038452148
(60) DESCRIBE `orchid_image` 0.0015320777893066
(61) DESCRIBE `cruiselines` 0.0019500255584717
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00039792060852051
(63) DESCRIBE `cruises` 0.0032360553741455
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62654') 0.00035405158996582
(65) DESCRIBE `ships` 0.0029611587524414
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.00049304962158203
(67) DESCRIBE `ships` 0.0025339126586914
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.00028896331787109
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026416778564453
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(71) DESCRIBE `itineraries` 0.0012619495391846
(72) DESCRIBE `ports` 0.0012979507446289
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00031185150146484
(74) DESCRIBE `ports` 0.0015048980712891
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00029683113098145
(76) DESCRIBE `ports` 0.0013670921325684
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00029802322387695
(78) DESCRIBE `sailingdates` 0.0011720657348633
(79) DESCRIBE `ports` 0.0015468597412109
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00050497055053711
(81) DESCRIBE `ports` 0.0017819404602051
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00030994415283203
(83) DESCRIBE `ports` 0.0014269351959229
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00030398368835449
(85) DESCRIBE `ports` 0.0013039112091064
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00027799606323242
(87) DESCRIBE `ports` 0.0012729167938232
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00029492378234863
(89) DESCRIBE `ports` 0.0013139247894287
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00030684471130371
(91) DESCRIBE `ports` 0.0012838840484619
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00032305717468262
(93) DESCRIBE `ports` 0.0013201236724854
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00027108192443848
(95) DESCRIBE `ports` 0.0011739730834961
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00041294097900391
(97) DESCRIBE `ports` 0.0012950897216797
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00029706954956055
(99) DESCRIBE `ports` 0.00124192237854
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00024008750915527
(101) DESCRIBE `ports` 0.00142502784729
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00032281875610352
(103) DESCRIBE `ports` 0.0012569427490234
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00032615661621094
(105) DESCRIBE `ports` 0.0013818740844727
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.0002748966217041
(107) DESCRIBE `avid_specials` 0.0011489391326904
(108) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62654 and class = 'Cruise') OR (item_id = 738 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.0009920597076416
(109) DESCRIBE `cruiselines` 0.0018501281738281
(110) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00052690505981445
(111) DESCRIBE `orchid_image` 0.0017719268798828
(112) DESCRIBE `cruiselines` 0.0027720928192139
(113) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00044488906860352
(114) DESCRIBE `cruises` 0.0036008358001709
(115) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62662') 0.00049400329589844
(116) DESCRIBE `ships` 0.0035741329193115
(117) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00058102607727051
(118) DESCRIBE `ships` 0.0031368732452393
(119) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00033688545227051
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026512145996094
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(122) DESCRIBE `itineraries` 0.0012609958648682
(123) DESCRIBE `ports` 0.0014309883117676
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00098800659179688
(125) DESCRIBE `ports` 0.001317024230957
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003199577331543
(127) DESCRIBE `ports` 0.0012710094451904
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037503242492676
(129) DESCRIBE `sailingdates` 0.0011539459228516
(130) DESCRIBE `ports` 0.0013039112091064
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029492378234863
(132) DESCRIBE `ports` 0.0012998580932617
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027799606323242
(134) DESCRIBE `ports` 0.0012459754943848
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00030803680419922
(136) DESCRIBE `ports` 0.0012779235839844
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00027799606323242
(138) DESCRIBE `ports` 0.0012619495391846
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00030803680419922
(140) DESCRIBE `ports` 0.0014040470123291
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00027203559875488
(142) DESCRIBE `ports` 0.0015320777893066
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035381317138672
(144) DESCRIBE `ports` 0.0013370513916016
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027704238891602
(146) DESCRIBE `ports` 0.0013289451599121
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00032615661621094
(148) DESCRIBE `ports` 0.0013141632080078
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00028800964355469
(150) DESCRIBE `ports` 0.0012838840484619
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030303001403809
(152) DESCRIBE `ports` 0.0014009475708008
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0002748966217041
(154) DESCRIBE `ports` 0.0016589164733887
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038981437683105
(156) DESCRIBE `ports` 0.0012760162353516
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00066900253295898
(158) DESCRIBE `avid_specials` 0.0013458728790283
(159) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62662 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0015990734100342
(160) DESCRIBE `cruiselines` 0.0019900798797607
(161) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036001205444336
(162) DESCRIBE `orchid_image` 0.0008690357208252
(163) DESCRIBE `cruiselines` 0.0021131038665771
(164) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00031805038452148
(165) DESCRIBE `cruises` 0.0026519298553467
(166) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69279') 0.0004279613494873
(167) DESCRIBE `ships` 0.0026428699493408
(168) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00047802925109863
(169) DESCRIBE `ships` 0.0024631023406982
(170) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.0003669261932373
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028705596923828
(172) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002589225769043
(173) DESCRIBE `itineraries` 0.0021660327911377
(174) DESCRIBE `ports` 0.0013258457183838
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00034618377685547
(176) DESCRIBE `ports` 0.0012519359588623
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00030016899108887
(178) DESCRIBE `ports` 0.0012691020965576
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00082111358642578
(180) DESCRIBE `sailingdates` 0.00086402893066406
(181) DESCRIBE `ports` 0.0012550354003906
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00032305717468262
(183) DESCRIBE `ports` 0.001640796661377
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00028181076049805
(185) DESCRIBE `ports` 0.0012819766998291
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00031399726867676
(187) DESCRIBE `ports` 0.0013420581817627
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00027298927307129
(189) DESCRIBE `ports` 0.0016050338745117
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00032401084899902
(191) DESCRIBE `ports` 0.0012218952178955
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00028610229492188
(193) DESCRIBE `ports` 0.0013210773468018
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00024819374084473
(195) DESCRIBE `ports` 0.0012519359588623
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00029206275939941
(197) DESCRIBE `ports` 0.0014810562133789
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00037503242492676
(199) DESCRIBE `ports` 0.0015730857849121
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00032210350036621
(201) DESCRIBE `ports` 0.0014338493347168
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00031709671020508
(203) DESCRIBE `ports` 0.0013899803161621
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00032711029052734
(205) DESCRIBE `avid_specials` 0.0012388229370117
(206) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69279 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 37 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.0010669231414795
(207) DESCRIBE `cruiselines` 0.0030820369720459
(208) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00052404403686523
(209) DESCRIBE `orchid_image` 0.002129077911377
(210) DESCRIBE `cruiselines` 0.0027461051940918
(211) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0004570484161377
(212) DESCRIBE `cruises` 0.0035481452941895
(213) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70379') 0.0006110668182373
(214) DESCRIBE `ships` 0.0029089450836182
(215) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00046086311340332
(216) DESCRIBE `ships` 0.0026860237121582
(217) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00053095817565918
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(220) DESCRIBE `itineraries` 0.0015161037445068
(221) DESCRIBE `ports` 0.0017321109771729
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.0004580020904541
(223) DESCRIBE `ports` 0.0016520023345947
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00043487548828125
(225) DESCRIBE `ports` 0.0016329288482666
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00043296813964844
(227) DESCRIBE `sailingdates` 0.0017080307006836
(228) DESCRIBE `ports` 0.0019679069519043
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00043392181396484
(230) DESCRIBE `ports` 0.00160813331604
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00036191940307617
(232) DESCRIBE `ports` 0.0013179779052734
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00031089782714844
(234) DESCRIBE `ports` 0.0016379356384277
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00037503242492676
(236) DESCRIBE `ports` 0.0015721321105957
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00036907196044922
(238) DESCRIBE `ports` 0.0011038780212402
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00028491020202637
(240) DESCRIBE `ports` 0.0018141269683838
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00040292739868164
(242) DESCRIBE `ports` 0.0018599033355713
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00035309791564941
(244) DESCRIBE `ports` 0.001471996307373
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00035786628723145
(246) DESCRIBE `ports` 0.0016601085662842
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00041794776916504
(248) DESCRIBE `ports` 0.0018019676208496
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00040388107299805
(250) DESCRIBE `ports` 0.0019490718841553
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00038409233093262
(252) DESCRIBE `ports` 0.002208948135376
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00043511390686035
(254) DESCRIBE `ports` 0.0019299983978271
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00029301643371582
(256) DESCRIBE `ports` 0.0014548301696777
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00038909912109375
(258) DESCRIBE `ports` 0.0014448165893555
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00039410591125488
(260) DESCRIBE `avid_specials` 0.0015828609466553
(261) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70379 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 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.0016961097717285
(262) DESCRIBE `cruiselines` 0.0023870468139648
(263) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00045108795166016
(264) DESCRIBE `orchid_image` 0.0019268989562988
(265) DESCRIBE `cruiselines` 0.0025629997253418
(266) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00040698051452637
(267) DESCRIBE `cruises` 0.0031888484954834
(268) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76805') 0.0003361701965332
(269) DESCRIBE `ships` 0.0025839805603027
(270) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00041389465332031
(271) DESCRIBE `ships` 0.0030961036682129
(272) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00037002563476562
(273) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032591819763184
(274) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(275) DESCRIBE `itineraries` 0.00142502784729
(276) DESCRIBE `ports` 0.0016329288482666
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.0003819465637207
(278) DESCRIBE `ports` 0.0014631748199463
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00032806396484375
(280) DESCRIBE `ports` 0.0012669563293457
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00028204917907715
(282) DESCRIBE `sailingdates` 0.0011091232299805
(283) DESCRIBE `ports` 0.0019941329956055
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.011806964874268
(285) DESCRIBE `ports` 0.0015208721160889
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00031709671020508
(287) DESCRIBE `ports` 0.001619815826416
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00034308433532715
(289) DESCRIBE `ports` 0.0013241767883301
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00027799606323242
(291) DESCRIBE `ports` 0.0015311241149902
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 470))) 0.00038599967956543
(293) DESCRIBE `ports` 0.0019941329956055
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '470') 0.00036501884460449
(295) DESCRIBE `ports` 0.0014450550079346
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 769))) 0.00031805038452148
(297) DESCRIBE `ports` 0.0013940334320068
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '769') 0.00027585029602051
(299) DESCRIBE `ports` 0.0017361640930176
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00061202049255371
(301) DESCRIBE `ports` 0.0020389556884766
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00051403045654297
(303) DESCRIBE `avid_specials` 0.0013678073883057
(304) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76805 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 37 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.0024039745330811
(305) DESCRIBE `cruiselines` 0.0023510456085205
(306) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036215782165527
(307) DESCRIBE `orchid_image` 0.0016310214996338
(308) DESCRIBE `cruiselines` 0.0021200180053711
(309) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00039982795715332
(310) DESCRIBE `cruises` 0.0033888816833496
(311) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69258') 0.00035691261291504
(312) DESCRIBE `ships` 0.0030190944671631
(313) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00043702125549316
(314) DESCRIBE `ships` 0.0031378269195557
(315) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00045490264892578
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028085708618164
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(318) DESCRIBE `itineraries` 0.0015799999237061
(319) DESCRIBE `ports` 0.0013501644134521
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00035190582275391
(321) DESCRIBE `ports` 0.0014019012451172
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00034499168395996
(323) DESCRIBE `ports` 0.0013501644134521
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00029587745666504
(325) DESCRIBE `sailingdates` 0.0014951229095459
(326) DESCRIBE `ports` 0.0015578269958496
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00034999847412109
(328) DESCRIBE `ports` 0.0012588500976562
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00028586387634277
(330) DESCRIBE `ports` 0.0012738704681396
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.0003211498260498
(332) DESCRIBE `ports` 0.00136399269104
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00029611587524414
(334) DESCRIBE `ports` 0.0015490055084229
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00031900405883789
(336) DESCRIBE `ports` 0.0020301342010498
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00034809112548828
(338) DESCRIBE `ports` 0.0019519329071045
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00039100646972656
(340) DESCRIBE `ports` 0.0016880035400391
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00035285949707031
(342) DESCRIBE `avid_specials` 0.0028250217437744
(343) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69258 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.0021538734436035
(344) DESCRIBE `cruiselines` 0.0026450157165527
(345) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00044894218444824
(346) DESCRIBE `orchid_image` 0.0022339820861816
(347) DESCRIBE `cruiselines` 0.0023980140686035
(348) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00028014183044434
(349) DESCRIBE `cruises` 0.0028290748596191
(350) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71829') 0.00041699409484863
(351) DESCRIBE `ships` 0.0028550624847412
(352) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00034213066101074
(353) DESCRIBE `ships` 0.0026788711547852
(354) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00031495094299316
(355) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028395652770996
(356) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027894973754883
(357) DESCRIBE `itineraries` 0.0017118453979492
(358) DESCRIBE `ports` 0.0018749237060547
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00033402442932129
(360) DESCRIBE `ports` 0.0016598701477051
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00034189224243164
(362) DESCRIBE `ports` 0.0015659332275391
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00036501884460449
(364) DESCRIBE `sailingdates` 0.0013728141784668
(365) DESCRIBE `ports` 0.0017681121826172
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00041103363037109
(367) DESCRIBE `ports` 0.0014381408691406
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029897689819336
(369) DESCRIBE `ports` 0.0014231204986572
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00032305717468262
(371) DESCRIBE `ports` 0.0014159679412842
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027894973754883
(373) DESCRIBE `ports` 0.0013930797576904
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031781196594238
(375) DESCRIBE `ports` 0.0014448165893555
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027799606323242
(377) DESCRIBE `ports` 0.0015068054199219
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00031089782714844
(379) DESCRIBE `ports` 0.0014259815216064
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00028395652770996
(381) DESCRIBE `ports` 0.0014450550079346
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00032305717468262
(383) DESCRIBE `ports` 0.0015830993652344
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00038409233093262
(385) DESCRIBE `ports` 0.0018279552459717
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00032615661621094
(387) DESCRIBE `ports` 0.0014891624450684
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00027894973754883
(389) DESCRIBE `ports` 0.0013909339904785
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00030803680419922
(391) DESCRIBE `ports` 0.0015361309051514
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00033187866210938
(393) DESCRIBE `ports` 0.0014410018920898
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035691261291504
(395) DESCRIBE `ports` 0.0016310214996338
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00034499168395996
(397) DESCRIBE `ports` 0.0016260147094727
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00038886070251465
(399) DESCRIBE `ports` 0.0016229152679443
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00032401084899902
(401) DESCRIBE `ports` 0.00142502784729
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00043106079101562
(403) DESCRIBE `ports` 0.0025410652160645
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0003669261932373
(405) DESCRIBE `avid_specials` 0.0018889904022217
(406) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71829 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 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.0018389225006104
(407) DESCRIBE `cruiselines` 0.0028200149536133
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00043010711669922
(409) DESCRIBE `orchid_image` 0.0020768642425537
(410) DESCRIBE `cruiselines` 0.0020749568939209
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00031590461730957
(412) DESCRIBE `cruises` 0.0025269985198975
(413) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75673') 0.00047087669372559
(414) DESCRIBE `ships` 0.0025341510772705
(415) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00039291381835938
(416) DESCRIBE `ships` 0.0029079914093018
(417) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00034809112548828
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031018257141113
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029492378234863
(420) DESCRIBE `itineraries` 0.0014841556549072
(421) DESCRIBE `ports` 0.0012750625610352
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032997131347656
(423) DESCRIBE `ports` 0.0013339519500732
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034689903259277
(425) DESCRIBE `ports` 0.001460075378418
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029516220092773
(427) DESCRIBE `sailingdates` 0.0012249946594238
(428) DESCRIBE `ports` 0.002687931060791
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049901008605957
(430) DESCRIBE `ports` 0.0019359588623047
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004270076751709
(432) DESCRIBE `ports` 0.0019650459289551
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.0002901554107666
(434) DESCRIBE `ports` 0.0017030239105225
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00043296813964844
(436) DESCRIBE `ports` 0.0019338130950928
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00039291381835938
(438) DESCRIBE `ports` 0.0016279220581055
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00036716461181641
(440) DESCRIBE `ports` 0.0014979839324951
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00031900405883789
(442) DESCRIBE `ports` 0.002316951751709
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00032401084899902
(444) DESCRIBE `ports` 0.0021069049835205
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00081086158752441
(446) DESCRIBE `ports` 0.0013148784637451
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0002748966217041
(448) DESCRIBE `ports` 0.0012490749359131
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00026679039001465
(450) DESCRIBE `ports` 0.0013139247894287
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00027704238891602
(452) DESCRIBE `ports` 0.0013067722320557
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00060606002807617
(454) DESCRIBE `ports` 0.0020890235900879
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00036501884460449
(456) DESCRIBE `avid_specials` 0.0016210079193115
(457) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75673 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.0015580654144287
(458) DESCRIBE `cruiselines` 0.0028500556945801
(459) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00045609474182129
(460) DESCRIBE `orchid_image` 0.0020210742950439
(461) DESCRIBE `cruiselines` 0.0027370452880859
(462) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00045990943908691
(463) DESCRIBE `cruises` 0.0040011405944824
(464) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62663') 0.00033187866210938
(465) DESCRIBE `ships` 0.0040581226348877
(466) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.0004279613494873
(467) DESCRIBE `ships` 0.0033199787139893
(468) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00035786628723145
(469) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030303001403809
(471) DESCRIBE `itineraries` 0.0016019344329834
(472) DESCRIBE `ports` 0.0021638870239258
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0003960132598877
(474) DESCRIBE `ports` 0.0022079944610596
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00034284591674805
(476) DESCRIBE `ports` 0.0013070106506348
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00028800964355469
(478) DESCRIBE `sailingdates` 0.0012240409851074
(479) DESCRIBE `ports` 0.0018181800842285
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00043678283691406
(481) DESCRIBE `ports` 0.0018279552459717
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00035905838012695
(483) DESCRIBE `ports` 0.0018119812011719
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00040292739868164
(485) DESCRIBE `ports` 0.0020709037780762
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00036311149597168
(487) DESCRIBE `ports` 0.0028140544891357
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00050091743469238
(489) DESCRIBE `ports` 0.0021049976348877
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00039792060852051
(491) DESCRIBE `ports` 0.0021119117736816
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00045108795166016
(493) DESCRIBE `ports` 0.0020380020141602
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00041294097900391
(495) DESCRIBE `ports` 0.0020840167999268
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00053000450134277
(497) DESCRIBE `ports` 0.0020830631256104
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00047397613525391
(499) DESCRIBE `ports` 0.00193190574646
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046992301940918
(501) DESCRIBE `ports` 0.002432107925415
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00055885314941406
(503) DESCRIBE `ports` 0.0021369457244873
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00048303604125977
(505) DESCRIBE `ports` 0.0020709037780762
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00045394897460938
(507) DESCRIBE `avid_specials` 0.001924991607666
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62663 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0019478797912598
(509) DESCRIBE `cruiselines` 0.003216028213501
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00053811073303223
(511) DESCRIBE `orchid_image` 0.0024559497833252
(512) DESCRIBE `cruiselines` 0.0035669803619385
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00044608116149902
(514) DESCRIBE `ships` 0.0044910907745361
(515) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1599', '1359', '1067', '1588', '407', '726', '1768', '1415', '462', '766', '452', '674', '553', '1717', '738', '610', '352')) ORDER BY FIND_IN_SET(id, '977,1599,1359,1067,1588,407,726,1768,1415,462,766,452,674,553,1717,738,610,352') 0.0016310214996338
(516) DESCRIBE `cruisetypes` 0.0020890235900879
(517) DESCRIBE `destinations` 0.0023040771484375
(518) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '45', '26', '25', '37', '28', '52', '40', '38', '9', '49', '11', '21', '35')) ORDER BY FIND_IN_SET(id, '22,12,45,26,25,37,28,52,40,38,9,49,11,21,35') 0.00090503692626953
(519) DESCRIBE `cruiselines` 0.0020689964294434
(520) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003349781036377
(521) DESCRIBE `cruiselines` 0.0019540786743164
(522) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00063204765319824