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

Total elapsed time: 0.7302725315094

# Query Time
(1) connect 0.0047199726104736
(2) DESCRIBE `cruises` 0.003223180770874
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69743, 69731, 73063, 63244, 69322, 63243, 69333, 69718, 79172, 69299)) ORDER BY FIND_IN_SET(id, '69743,69731,73063,63244,69322,63243,69333,69718,79172,69299') 0.0022470951080322
(4) DESCRIBE `cruises` 0.0029091835021973
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69743') 0.00037789344787598
(6) DESCRIBE `ships` 0.0029449462890625
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1021))) 0.00048089027404785
(8) DESCRIBE `ships` 0.0030448436737061
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1021') 0.0003211498260498
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027894973754883
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036501884460449
(12) DESCRIBE `itineraries` 0.0016498565673828
(13) DESCRIBE `ports` 0.001539945602417
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00041317939758301
(15) DESCRIBE `ports` 0.0013008117675781
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024986267089844
(17) DESCRIBE `ports` 0.0015168190002441
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00030994415283203
(19) DESCRIBE `sailingdates` 0.0010850429534912
(20) DESCRIBE `ports` 0.0015859603881836
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044488906860352
(22) DESCRIBE `ports` 0.0013949871063232
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00037193298339844
(24) DESCRIBE `ports` 0.0015020370483398
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00037407875061035
(26) DESCRIBE `ports` 0.0013120174407959
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00032877922058105
(28) DESCRIBE `ports` 0.0015530586242676
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00031208992004395
(30) DESCRIBE `ports` 0.0013959407806396
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00040316581726074
(32) DESCRIBE `ports` 0.0014379024505615
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00030088424682617
(34) DESCRIBE `ports` 0.0014050006866455
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00027585029602051
(36) DESCRIBE `ports` 0.0012578964233398
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00038385391235352
(38) DESCRIBE `ports` 0.0018908977508545
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00041985511779785
(40) DESCRIBE `ports` 0.0019700527191162
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0004570484161377
(42) DESCRIBE `ports` 0.0018749237060547
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00035691261291504
(44) DESCRIBE `ports` 0.0017881393432617
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00040698051452637
(46) DESCRIBE `ports` 0.0012919902801514
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00040602684020996
(48) DESCRIBE `ports` 0.0017890930175781
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2145))) 0.00043606758117676
(50) DESCRIBE `ports` 0.0018060207366943
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2145') 0.00041294097900391
(52) DESCRIBE `ports` 0.0018818378448486
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00034499168395996
(54) DESCRIBE `ports` 0.001349925994873
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00033402442932129
(56) DESCRIBE `ports` 0.0014009475708008
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00031089782714844
(58) DESCRIBE `ports` 0.00142502784729
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0003361701965332
(60) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69743') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0099530220031738
(61) DESCRIBE `avid_specials` 0.001453161239624
(62) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69743 and class = 'Cruise') OR (item_id = 1021 AND class = 'Ship') OR (item_id = 23 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.0010619163513184
(63) DESCRIBE `cruiselines` 0.0019581317901611
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037598609924316
(65) DESCRIBE `orchid_image` 0.0017521381378174
(66) DESCRIBE `cruiselines` 0.013267040252686
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00039196014404297
(68) DESCRIBE `cruises` 0.003079891204834
(69) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69731') 0.00054192543029785
(70) DESCRIBE `ships` 0.0048618316650391
(71) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1021))) 0.0016870498657227
(72) DESCRIBE `ships` 0.0037751197814941
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1021') 0.00036787986755371
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(76) DESCRIBE `itineraries` 0.0014059543609619
(77) DESCRIBE `ports` 0.0013139247894287
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00032591819763184
(79) DESCRIBE `ports` 0.001539945602417
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00031399726867676
(81) DESCRIBE `ports` 0.001288890838623
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0011980533599854
(83) DESCRIBE `sailingdates` 0.0015618801116943
(84) DESCRIBE `ports` 0.0014629364013672
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00042605400085449
(86) DESCRIBE `ports` 0.0074520111083984
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0019288063049316
(88) DESCRIBE `ports` 0.0017039775848389
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0073199272155762
(90) DESCRIBE `ports` 0.0016708374023438
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.0017249584197998
(92) DESCRIBE `ports` 0.0083029270172119
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00036001205444336
(94) DESCRIBE `ports` 0.0013148784637451
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.0002739429473877
(96) DESCRIBE `ports` 0.0013220310211182
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00037980079650879
(98) DESCRIBE `ports` 0.0013759136199951
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00018811225891113
(100) DESCRIBE `ports` 0.0095250606536865
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00073409080505371
(102) DESCRIBE `ports` 0.0015900135040283
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00029301643371582
(104) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69731') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0058929920196533
(105) DESCRIBE `avid_specials` 0.0014650821685791
(106) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69731 and class = 'Cruise') OR (item_id = 1021 AND class = 'Ship') OR (item_id = 23 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.0011279582977295
(107) DESCRIBE `cruiselines` 0.0018801689147949
(108) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00027108192443848
(109) DESCRIBE `orchid_image` 0.0015678405761719
(110) DESCRIBE `cruiselines` 0.0019609928131104
(111) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0001978874206543
(112) DESCRIBE `cruises` 0.0025980472564697
(113) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73063') 0.0003199577331543
(114) DESCRIBE `ships` 0.0027859210968018
(115) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00024509429931641
(116) DESCRIBE `ships` 0.0026419162750244
(117) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00035500526428223
(118) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029206275939941
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029087066650391
(120) DESCRIBE `itineraries` 0.0012550354003906
(121) DESCRIBE `ports` 0.0012669563293457
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00028586387634277
(123) DESCRIBE `ports` 0.0014500617980957
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0002899169921875
(125) DESCRIBE `ports` 0.0086629390716553
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00042009353637695
(127) DESCRIBE `sailingdates` 0.0012049674987793
(128) DESCRIBE `ports` 0.0016429424285889
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00035500526428223
(130) DESCRIBE `ports` 0.0012578964233398
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00033688545227051
(132) DESCRIBE `ports` 0.001521110534668
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00031590461730957
(134) DESCRIBE `ports` 0.0013809204101562
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.0003199577331543
(136) DESCRIBE `ports` 0.0092740058898926
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00035881996154785
(138) DESCRIBE `ports` 0.0015020370483398
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00021100044250488
(140) DESCRIBE `ports` 0.0015029907226562
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00047898292541504
(142) DESCRIBE `ports` 0.002094030380249
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00037312507629395
(144) DESCRIBE `ports` 0.0022637844085693
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00041604042053223
(146) DESCRIBE `ports` 0.0018010139465332
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00036096572875977
(148) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '73063') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0062699317932129
(149) DESCRIBE `avid_specials` 0.0015809535980225
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73063 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 53 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011398792266846
(151) DESCRIBE `cruiselines` 0.0019559860229492
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00039386749267578
(153) DESCRIBE `orchid_image` 0.0016219615936279
(154) DESCRIBE `cruiselines` 0.00189208984375
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00032401084899902
(156) DESCRIBE `cruises` 0.0031251907348633
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63244') 0.00040507316589355
(158) DESCRIBE `ships` 0.0036318302154541
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00046110153198242
(160) DESCRIBE `ships` 0.0025889873504639
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.0002901554107666
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030279159545898
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002598762512207
(164) DESCRIBE `itineraries` 0.0025031566619873
(165) DESCRIBE `ports` 0.0025360584259033
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00042104721069336
(167) DESCRIBE `ports` 0.001298189163208
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00029993057250977
(169) DESCRIBE `ports` 0.0012638568878174
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002899169921875
(171) DESCRIBE `sailingdates` 0.0012309551239014
(172) DESCRIBE `ports` 0.0016720294952393
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003509521484375
(174) DESCRIBE `ports` 0.0015790462493896
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00039005279541016
(176) DESCRIBE `ports` 0.0017330646514893
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00031495094299316
(178) DESCRIBE `ports` 0.0013399124145508
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00028395652770996
(180) DESCRIBE `ports` 0.0012519359588623
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00031089782714844
(182) DESCRIBE `ports` 0.0013980865478516
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00028514862060547
(184) DESCRIBE `ports` 0.0018711090087891
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0004429817199707
(186) DESCRIBE `ports` 0.00152587890625
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00036001205444336
(188) DESCRIBE `ports` 0.0014331340789795
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00032711029052734
(190) DESCRIBE `ports` 0.0017530918121338
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0003969669342041
(192) DESCRIBE `ports` 0.0015101432800293
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026178359985352
(194) DESCRIBE `ports` 0.0012521743774414
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00039887428283691
(196) DESCRIBE `ports` 0.0016438961029053
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00028586387634277
(198) DESCRIBE `ports` 0.0013608932495117
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00037908554077148
(200) DESCRIBE `ports` 0.0012519359588623
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00030398368835449
(202) DESCRIBE `ports` 0.0012960433959961
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00037312507629395
(204) DESCRIBE `ports` 0.0013971328735352
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00028085708618164
(206) DESCRIBE `ports` 0.0015079975128174
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00029516220092773
(208) DESCRIBE `ports` 0.0015289783477783
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027012825012207
(210) DESCRIBE `ports` 0.0012898445129395
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00031399726867676
(212) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63244') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0081460475921631
(213) DESCRIBE `avid_specials` 0.0015039443969727
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63244 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 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.0010709762573242
(215) DESCRIBE `cruiselines` 0.0020570755004883
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00041103363037109
(217) DESCRIBE `orchid_image` 0.0015220642089844
(218) DESCRIBE `cruiselines` 0.0018830299377441
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00036001205444336
(220) DESCRIBE `cruises` 0.0032138824462891
(221) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69322') 0.00042390823364258
(222) DESCRIBE `ships` 0.0025739669799805
(223) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00034403800964355
(224) DESCRIBE `ships` 0.0025911331176758
(225) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00034189224243164
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027585029602051
(228) DESCRIBE `itineraries` 0.0014910697937012
(229) DESCRIBE `ports` 0.0013949871063232
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031590461730957
(231) DESCRIBE `ports` 0.001370906829834
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00037002563476562
(233) DESCRIBE `ports` 0.0014221668243408
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028800964355469
(235) DESCRIBE `sailingdates` 0.001317024230957
(236) DESCRIBE `ports` 0.0015859603881836
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00036787986755371
(238) DESCRIBE `ports` 0.0015270709991455
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0004727840423584
(240) DESCRIBE `ports` 0.0015511512756348
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0004570484161377
(242) DESCRIBE `ports` 0.0015268325805664
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00031208992004395
(244) DESCRIBE `ports` 0.0015230178833008
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.0003352165222168
(246) DESCRIBE `ports` 0.0012819766998291
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00027108192443848
(248) DESCRIBE `ports` 0.0013630390167236
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00039219856262207
(250) DESCRIBE `ports` 0.0016241073608398
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00046610832214355
(252) DESCRIBE `ports` 0.0018420219421387
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00047206878662109
(254) DESCRIBE `ports` 0.0012540817260742
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00033688545227051
(256) DESCRIBE `ports` 0.0015130043029785
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.0003349781036377
(258) DESCRIBE `ports` 0.0014200210571289
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00030303001403809
(260) DESCRIBE `ports` 0.0012891292572021
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2450))) 0.00037693977355957
(262) DESCRIBE `ports` 0.0014779567718506
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2450') 0.00035309791564941
(264) DESCRIBE `ports` 0.0014901161193848
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041007995605469
(266) DESCRIBE `ports` 0.0014729499816895
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0004580020904541
(268) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69322') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0062048435211182
(269) DESCRIBE `avid_specials` 0.0015230178833008
(270) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69322 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011160373687744
(271) DESCRIBE `cruiselines` 0.0021109580993652
(272) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00038814544677734
(273) DESCRIBE `orchid_image` 0.0015389919281006
(274) DESCRIBE `cruiselines` 0.0018749237060547
(275) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00032901763916016
(276) DESCRIBE `cruises` 0.0028760433197021
(277) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63243') 0.00043201446533203
(278) DESCRIBE `ships` 0.0026688575744629
(279) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00049710273742676
(280) DESCRIBE `ships` 0.0028030872344971
(281) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.0003659725189209
(282) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(283) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029397010803223
(284) DESCRIBE `itineraries` 0.00142502784729
(285) DESCRIBE `ports` 0.00146484375
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037693977355957
(287) DESCRIBE `ports` 0.001410961151123
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00036191940307617
(289) DESCRIBE `ports` 0.001431941986084
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00029397010803223
(291) DESCRIBE `sailingdates` 0.0011799335479736
(292) DESCRIBE `ports` 0.0015709400177002
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00041604042053223
(294) DESCRIBE `ports` 0.0013389587402344
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00030398368835449
(296) DESCRIBE `ports` 0.0013630390167236
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00031113624572754
(298) DESCRIBE `ports` 0.0013668537139893
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00029492378234863
(300) DESCRIBE `ports` 0.0013291835784912
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00039291381835938
(302) DESCRIBE `ports` 0.0015239715576172
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00028395652770996
(304) DESCRIBE `ports` 0.0013258457183838
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00034594535827637
(306) DESCRIBE `ports` 0.0013229846954346
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00031208992004395
(308) DESCRIBE `ports` 0.0016310214996338
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00037193298339844
(310) DESCRIBE `ports` 0.0018041133880615
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00035309791564941
(312) DESCRIBE `ports` 0.001453161239624
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037288665771484
(314) DESCRIBE `ports` 0.0012810230255127
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0003349781036377
(316) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63243') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0062170028686523
(317) DESCRIBE `avid_specials` 0.0014829635620117
(318) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63243 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 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.0013039112091064
(319) DESCRIBE `cruiselines` 0.0021588802337646
(320) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00035309791564941
(321) DESCRIBE `orchid_image` 0.0016119480133057
(322) DESCRIBE `cruiselines` 0.0021541118621826
(323) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00037384033203125
(324) DESCRIBE `cruises` 0.0025639533996582
(325) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69333') 0.00034618377685547
(326) DESCRIBE `ships` 0.0025660991668701
(327) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00035786628723145
(328) DESCRIBE `ships` 0.0027210712432861
(329) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00027608871459961
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(332) DESCRIBE `itineraries` 0.001410961151123
(333) DESCRIBE `ports` 0.0012748241424561
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034403800964355
(335) DESCRIBE `ports` 0.0012459754943848
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031304359436035
(337) DESCRIBE `ports` 0.0012540817260742
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028800964355469
(339) DESCRIBE `sailingdates` 0.0015208721160889
(340) DESCRIBE `ports` 0.0017528533935547
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041913986206055
(342) DESCRIBE `ports` 0.0017011165618896
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036096572875977
(344) DESCRIBE `ports` 0.0017678737640381
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00040316581726074
(346) DESCRIBE `ports` 0.0017349720001221
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00041890144348145
(348) DESCRIBE `ports` 0.0016958713531494
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00040102005004883
(350) DESCRIBE `ports` 0.0017979145050049
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00037503242492676
(352) DESCRIBE `ports` 0.0018670558929443
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00041699409484863
(354) DESCRIBE `ports` 0.0019748210906982
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00039005279541016
(356) DESCRIBE `ports` 0.0018079280853271
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00090384483337402
(358) DESCRIBE `ports` 0.0020120143890381
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00037407875061035
(360) DESCRIBE `ports` 0.0018281936645508
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039291381835938
(362) DESCRIBE `ports` 0.0018138885498047
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031089782714844
(364) DESCRIBE `ports` 0.0017848014831543
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039100646972656
(366) DESCRIBE `ports` 0.0016131401062012
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030612945556641
(368) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69333') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.007256031036377
(369) DESCRIBE `avid_specials` 0.0014839172363281
(370) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69333 and class = 'Cruise') OR (item_id = 105 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013279914855957
(371) DESCRIBE `cruiselines` 0.0021021366119385
(372) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00042009353637695
(373) DESCRIBE `orchid_image` 0.0014419555664062
(374) DESCRIBE `cruiselines` 0.0018289089202881
(375) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029611587524414
(376) DESCRIBE `cruises` 0.002892017364502
(377) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69718') 0.00053215026855469
(378) DESCRIBE `ships` 0.0032110214233398
(379) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.0004417896270752
(380) DESCRIBE `ships` 0.0025701522827148
(381) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.0003199577331543
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020408630371094
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002598762512207
(384) DESCRIBE `itineraries` 0.0014159679412842
(385) DESCRIBE `ports` 0.0013680458068848
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00036406517028809
(387) DESCRIBE `ports` 0.0013070106506348
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003349781036377
(389) DESCRIBE `ports` 0.0013399124145508
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00031208992004395
(391) DESCRIBE `sailingdates` 0.0010750293731689
(392) DESCRIBE `ports` 0.0018370151519775
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043702125549316
(394) DESCRIBE `ports` 0.0018248558044434
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00046396255493164
(396) DESCRIBE `ports` 0.0017549991607666
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00039315223693848
(398) DESCRIBE `ports` 0.0016129016876221
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.0003669261932373
(400) DESCRIBE `ports` 0.0018749237060547
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00043606758117676
(402) DESCRIBE `ports` 0.0014688968658447
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00027203559875488
(404) DESCRIBE `ports` 0.0012578964233398
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 409))) 0.00036716461181641
(406) DESCRIBE `ports` 0.0014119148254395
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '409') 0.0002439022064209
(408) DESCRIBE `ports` 0.001737117767334
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 765))) 0.00027704238891602
(410) DESCRIBE `ports` 0.0013020038604736
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '765') 0.00033116340637207
(412) DESCRIBE `ports` 0.0013060569763184
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1494))) 0.00027704238891602
(414) DESCRIBE `ports` 0.0013561248779297
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1494') 0.00025820732116699
(416) DESCRIBE `ports` 0.0013589859008789
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 407))) 0.00054311752319336
(418) DESCRIBE `ports` 0.0014028549194336
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '407') 0.0002899169921875
(420) DESCRIBE `ports` 0.0013060569763184
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00034308433532715
(422) DESCRIBE `ports` 0.001288890838623
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002901554107666
(424) DESCRIBE `ports` 0.0016319751739502
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0003361701965332
(426) DESCRIBE `ports` 0.001474142074585
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00031495094299316
(428) DESCRIBE `ports` 0.0013449192047119
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00034093856811523
(430) DESCRIBE `ports` 0.0012941360473633
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00030899047851562
(432) DESCRIBE `ports` 0.0015568733215332
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00035595893859863
(434) DESCRIBE `ports` 0.0015571117401123
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00032210350036621
(436) DESCRIBE `ports` 0.0015919208526611
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00030899047851562
(438) DESCRIBE `ports` 0.0016739368438721
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00036716461181641
(440) DESCRIBE `ports` 0.0013999938964844
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00029993057250977
(442) DESCRIBE `ports` 0.0014181137084961
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00034689903259277
(444) DESCRIBE `ports` 0.0016229152679443
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.0004580020904541
(446) DESCRIBE `ports` 0.0013530254364014
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00029206275939941
(448) DESCRIBE `ports` 0.0015370845794678
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00031113624572754
(450) DESCRIBE `ports` 0.0013079643249512
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00027680397033691
(452) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69718') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0063648223876953
(453) DESCRIBE `avid_specials` 0.0014300346374512
(454) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69718 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 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.0011391639709473
(455) DESCRIBE `cruiselines` 0.0022192001342773
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00048303604125977
(457) DESCRIBE `orchid_image` 0.0014989376068115
(458) DESCRIBE `cruiselines` 0.0021488666534424
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00036501884460449
(460) DESCRIBE `cruises` 0.0029239654541016
(461) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79172') 0.00035810470581055
(462) DESCRIBE `ships` 0.0031061172485352
(463) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00035905838012695
(464) DESCRIBE `ships` 0.0026700496673584
(465) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00027799606323242
(466) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027179718017578
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(468) DESCRIBE `itineraries` 0.0013179779052734
(469) DESCRIBE `ports` 0.0018100738525391
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037598609924316
(471) DESCRIBE `ports` 0.001751184463501
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00040602684020996
(473) DESCRIBE `ports` 0.0018129348754883
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00041794776916504
(475) DESCRIBE `sailingdates` 0.0012249946594238
(476) DESCRIBE `ports` 0.0015370845794678
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00031399726867676
(478) DESCRIBE `ports` 0.0012772083282471
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00028610229492188
(480) DESCRIBE `ports` 0.0012660026550293
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00030398368835449
(482) DESCRIBE `ports` 0.0013351440429688
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00034713745117188
(484) DESCRIBE `ports` 0.001629114151001
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0005040168762207
(486) DESCRIBE `ports` 0.0020120143890381
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00040912628173828
(488) DESCRIBE `ports` 0.0017280578613281
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 409))) 0.00042200088500977
(490) DESCRIBE `ports` 0.0017180442810059
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '409') 0.00040507316589355
(492) DESCRIBE `ports` 0.0016779899597168
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 765))) 0.00045394897460938
(494) DESCRIBE `ports` 0.0019087791442871
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '765') 0.00043916702270508
(496) DESCRIBE `ports` 0.0018939971923828
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1494))) 0.00043988227844238
(498) DESCRIBE `ports` 0.0018589496612549
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1494') 0.00046896934509277
(500) DESCRIBE `ports` 0.0018308162689209
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 407))) 0.00041794776916504
(502) DESCRIBE `ports` 0.0018260478973389
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '407') 0.0003819465637207
(504) DESCRIBE `ports` 0.001359224319458
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00031208992004395
(506) DESCRIBE `ports` 0.001270055770874
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00028586387634277
(508) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '79172') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0054728984832764
(509) DESCRIBE `avid_specials` 0.0012359619140625
(510) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79172 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 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.0012130737304688
(511) DESCRIBE `cruiselines` 0.0021049976348877
(512) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00036001205444336
(513) DESCRIBE `orchid_image` 0.0016810894012451
(514) DESCRIBE `cruiselines` 0.0020861625671387
(515) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00035500526428223
(516) DESCRIBE `cruises` 0.0028181076049805
(517) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69299') 0.00032806396484375
(518) DESCRIBE `ships` 0.0026488304138184
(519) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.0003659725189209
(520) DESCRIBE `ships` 0.0025951862335205
(521) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.00031900405883789
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(524) DESCRIBE `itineraries` 0.0013618469238281
(525) DESCRIBE `ports` 0.0013020038604736
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00032305717468262
(527) DESCRIBE `ports` 0.0013179779052734
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029921531677246
(529) DESCRIBE `ports` 0.0012509822845459
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00034594535827637
(531) DESCRIBE `sailingdates` 0.0013430118560791
(532) DESCRIBE `ports` 0.0014510154724121
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003211498260498
(534) DESCRIBE `ports` 0.0013449192047119
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028204917907715
(536) DESCRIBE `ports` 0.00160813331604
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3064))) 0.00042414665222168
(538) DESCRIBE `ports` 0.0017778873443604
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3064') 0.00031399726867676
(540) DESCRIBE `ports` 0.0016939640045166
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00038695335388184
(542) DESCRIBE `ports` 0.0015759468078613
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00042581558227539
(544) DESCRIBE `ports` 0.0017199516296387
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.0003809928894043
(546) DESCRIBE `ports` 0.0016839504241943
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00034999847412109
(548) DESCRIBE `ports` 0.0014779567718506
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00034308433532715
(550) DESCRIBE `ports` 0.0014710426330566
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00034403800964355
(552) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69299') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0064067840576172
(553) DESCRIBE `avid_specials` 0.00160813331604
(554) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69299 and class = 'Cruise') OR (item_id = 253 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012450218200684
(555) DESCRIBE `cruiselines` 0.0021529197692871
(556) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034499168395996
(557) DESCRIBE `orchid_image` 0.0014770030975342
(558) DESCRIBE `cruiselines` 0.0018739700317383
(559) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00041794776916504
(560) DESCRIBE `ships` 0.002810001373291
(561) SELECT `ships`.* FROM `ships` WHERE (id IN ('1135', '349', '542', '406', '1021', '434', '253', '451', '678', '348', '1409', '105', '341', '580', '98', '290', '291')) ORDER BY FIND_IN_SET(id, '1135,349,542,406,1021,434,253,451,678,348,1409,105,341,580,98,290,291') 0.0014548301696777
(562) DESCRIBE `cruisetypes` 0.001539945602417
(563) DESCRIBE `destinations` 0.0022270679473877
(564) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '43', '48', '53', '8', '37', '29', '40', '38', '34', '22', '28', '30')) ORDER BY FIND_IN_SET(id, '12,35,43,48,53,8,37,29,40,38,34,22,28,30') 0.0013048648834229
(565) DESCRIBE `cruiselines` 0.0020310878753662
(566) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00044417381286621
(567) DESCRIBE `cruiselines` 0.0020079612731934
(568) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0003972053527832