or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

Total elapsed time: 0.98666167259216

# Query Time
(1) connect 0.00082802772521973
(2) DESCRIBE `cruises` 0.0033290386199951
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66569, 66559, 69468, 69331, 69290, 69732, 73063, 49460, 63245, 69311)) ORDER BY FIND_IN_SET(id, '66569,66559,69468,69331,69290,69732,73063,49460,63245,69311') 0.0034539699554443
(4) DESCRIBE `cruises` 0.0032768249511719
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66569') 0.00044703483581543
(6) DESCRIBE `ships` 0.0030360221862793
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 341))) 0.00063800811767578
(8) DESCRIBE `ships` 0.0037147998809814
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '341') 0.00054597854614258
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002899169921875
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(12) DESCRIBE `itineraries` 0.0020549297332764
(13) DESCRIBE `ports` 0.0017158985137939
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00039005279541016
(15) DESCRIBE `ports` 0.0036289691925049
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048112869262695
(17) DESCRIBE `ports` 0.0089480876922607
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041794776916504
(19) DESCRIBE `sailingdates` 0.0084459781646729
(20) DESCRIBE `ports` 0.0058979988098145
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00053286552429199
(22) DESCRIBE `ports` 0.0016388893127441
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00035285949707031
(24) DESCRIBE `ports` 0.0015270709991455
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00037908554077148
(26) DESCRIBE `ports` 0.0015299320220947
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0088188648223877
(28) DESCRIBE `ports` 0.0017070770263672
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00039792060852051
(30) DESCRIBE `ports` 0.0015139579772949
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.00032591819763184
(32) DESCRIBE `ports` 0.0015678405761719
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00037312507629395
(34) DESCRIBE `ports` 0.0015339851379395
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00034880638122559
(36) DESCRIBE `ports` 0.0015280246734619
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0037040710449219
(38) DESCRIBE `ports` 0.0017220973968506
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0011959075927734
(40) DESCRIBE `ports` 0.0018079280853271
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00048708915710449
(42) DESCRIBE `ports` 0.0094530582427979
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00040006637573242
(44) DESCRIBE `ports` 0.00154709815979
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00043296813964844
(46) DESCRIBE `ports` 0.0014948844909668
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00032496452331543
(48) DESCRIBE `ports` 0.0015218257904053
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00042295455932617
(50) DESCRIBE `ports` 0.001521110534668
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00033998489379883
(52) DESCRIBE `ports` 0.0015039443969727
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 581))) 0.00036406517028809
(54) DESCRIBE `ports` 0.0014939308166504
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '581') 0.00033807754516602
(56) DESCRIBE `ports` 0.0015580654144287
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00040078163146973
(58) DESCRIBE `ports` 0.0015020370483398
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00036716461181641
(60) DESCRIBE `ports` 0.0014991760253906
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037002563476562
(62) DESCRIBE `ports` 0.0015628337860107
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00033783912658691
(64) DESCRIBE `ports` 0.0014948844909668
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00037884712219238
(66) DESCRIBE `ports` 0.0014891624450684
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00032210350036621
(68) DESCRIBE `ports` 0.0015459060668945
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00038814544677734
(70) DESCRIBE `ports` 0.00148606300354
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00034999847412109
(72) DESCRIBE `ports` 0.0018630027770996
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.0010218620300293
(74) DESCRIBE `ports` 0.0015869140625
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 7.2956085205078E-5
(76) DESCRIBE `ports` 0.0016088485717773
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00037598609924316
(78) DESCRIBE `ports` 0.0015270709991455
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00010991096496582
(80) DESCRIBE `ports` 0.0015249252319336
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00040698051452637
(82) DESCRIBE `ports` 0.0017130374908447
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00041294097900391
(84) DESCRIBE `ports` 0.0019669532775879
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0064911842346191
(86) DESCRIBE `ports` 0.0017509460449219
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0014338493347168
(88) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66569') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.029473066329956
(89) DESCRIBE `avid_specials` 0.0018739700317383
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66569 and class = 'Cruise') OR (item_id = 341 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021278858184814
(91) DESCRIBE `cruiselines` 0.0061831474304199
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0014519691467285
(93) DESCRIBE `orchid_image` 0.0028560161590576
(94) DESCRIBE `cruiselines` 0.0039241313934326
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0014328956604004
(96) DESCRIBE `cruises` 0.0092141628265381
(97) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66559') 0.0172438621521
(98) DESCRIBE `ships` 0.0035800933837891
(99) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 341))) 0.0005040168762207
(100) DESCRIBE `ships` 0.003338098526001
(101) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '341') 0.0086507797241211
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(103) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037193298339844
(104) DESCRIBE `itineraries` 0.0018990039825439
(105) DESCRIBE `ports` 0.0019280910491943
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044107437133789
(107) DESCRIBE `ports` 0.001784086227417
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00039291381835938
(109) DESCRIBE `ports` 0.0016250610351562
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0012497901916504
(111) DESCRIBE `sailingdates` 0.0035760402679443
(112) DESCRIBE `ports` 0.002443790435791
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0005340576171875
(114) DESCRIBE `ports` 0.0025300979614258
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.002194881439209
(116) DESCRIBE `ports` 0.0090420246124268
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0067770481109619
(118) DESCRIBE `ports` 0.0016629695892334
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00035405158996582
(120) DESCRIBE `ports` 0.0016138553619385
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.0036609172821045
(122) DESCRIBE `ports` 0.0018539428710938
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.0060970783233643
(124) DESCRIBE `ports` 0.0017409324645996
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00042200088500977
(126) DESCRIBE `ports` 0.0016651153564453
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00035405158996582
(128) DESCRIBE `ports` 0.0070979595184326
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00042605400085449
(130) DESCRIBE `ports` 0.0016341209411621
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00034403800964355
(132) DESCRIBE `ports` 0.0081360340118408
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00056314468383789
(134) DESCRIBE `ports` 0.0090630054473877
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00037097930908203
(136) DESCRIBE `ports` 0.0013937950134277
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00033092498779297
(138) DESCRIBE `ports` 0.0013689994812012
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0003211498260498
(140) DESCRIBE `ports` 0.0014050006866455
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0065059661865234
(142) DESCRIBE `ports` 0.0019841194152832
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00043392181396484
(144) DESCRIBE `ports` 0.0016391277313232
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 581))) 0.00039982795715332
(146) DESCRIBE `ports` 0.0017149448394775
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '581') 0.006458044052124
(148) DESCRIBE `ports` 0.001849889755249
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00045394897460938
(150) DESCRIBE `ports` 0.0016880035400391
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00039196014404297
(152) DESCRIBE `ports` 0.0017800331115723
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0024940967559814
(154) DESCRIBE `ports` 0.0018761157989502
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.007735013961792
(156) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66559') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0055129528045654
(157) DESCRIBE `avid_specials` 0.019165992736816
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66559 and class = 'Cruise') OR (item_id = 341 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017518997192383
(159) DESCRIBE `cruiselines` 0.0025668144226074
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00048112869262695
(161) DESCRIBE `orchid_image` 0.0019571781158447
(162) DESCRIBE `cruiselines` 0.0025680065155029
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0094230175018311
(164) DESCRIBE `cruises` 0.0027999877929688
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69468') 0.00041818618774414
(166) DESCRIBE `ships` 0.0034260749816895
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.0016388893127441
(168) DESCRIBE `ships` 0.0050079822540283
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.0049910545349121
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036883354187012
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00088906288146973
(172) DESCRIBE `itineraries` 0.0019218921661377
(173) DESCRIBE `ports` 0.0047240257263184
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0019149780273438
(175) DESCRIBE `ports` 0.0023889541625977
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0029041767120361
(177) DESCRIBE `ports` 0.002187967300415
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.0019850730895996
(179) DESCRIBE `sailingdates` 0.0016419887542725
(180) DESCRIBE `ports` 0.0021970272064209
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00045680999755859
(182) DESCRIBE `ports` 0.0018670558929443
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00040507316589355
(184) DESCRIBE `ports` 0.0018038749694824
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00039410591125488
(186) DESCRIBE `ports` 0.0017008781433105
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00033307075500488
(188) DESCRIBE `ports` 0.0016810894012451
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00037598609924316
(190) DESCRIBE `ports` 0.0016388893127441
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00029897689819336
(192) DESCRIBE `ports` 0.0013630390167236
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00039315223693848
(194) DESCRIBE `ports` 0.0016350746154785
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00034999847412109
(196) DESCRIBE `ports` 0.0015549659729004
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00036287307739258
(198) DESCRIBE `ports` 0.0015261173248291
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00039982795715332
(200) DESCRIBE `ports` 0.0014550685882568
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00031113624572754
(202) DESCRIBE `ports` 0.0015850067138672
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00037693977355957
(204) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69468') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0098330974578857
(205) DESCRIBE `avid_specials` 0.0018661022186279
(206) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69468 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 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.0027139186859131
(207) DESCRIBE `cruiselines` 0.0029900074005127
(208) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00028705596923828
(209) DESCRIBE `orchid_image` 0.0022468566894531
(210) DESCRIBE `cruiselines` 0.0028541088104248
(211) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00041294097900391
(212) DESCRIBE `cruises` 0.0033020973205566
(213) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69331') 0.00045108795166016
(214) DESCRIBE `ships` 0.0031869411468506
(215) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00034999847412109
(216) DESCRIBE `ships` 0.0031030178070068
(217) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00041103363037109
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029706954956055
(220) DESCRIBE `itineraries` 0.0016429424285889
(221) DESCRIBE `ports` 0.0017879009246826
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004119873046875
(223) DESCRIBE `ports` 0.001533031463623
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043487548828125
(225) DESCRIBE `ports` 0.0015377998352051
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034689903259277
(227) DESCRIBE `sailingdates` 0.0013670921325684
(228) DESCRIBE `ports` 0.0015790462493896
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041508674621582
(230) DESCRIBE `ports` 0.0015521049499512
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040102005004883
(232) DESCRIBE `ports` 0.0015828609466553
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00038886070251465
(234) DESCRIBE `ports` 0.0016460418701172
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00038981437683105
(236) DESCRIBE `ports` 0.0017070770263672
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00038695335388184
(238) DESCRIBE `ports` 0.0015959739685059
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00045514106750488
(240) DESCRIBE `ports` 0.001511812210083
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00045514106750488
(242) DESCRIBE `ports` 0.0017948150634766
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037217140197754
(244) DESCRIBE `ports` 0.0015900135040283
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00047683715820312
(246) DESCRIBE `ports` 0.0020401477813721
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00045299530029297
(248) DESCRIBE `ports` 0.0016269683837891
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00041699409484863
(250) DESCRIBE `ports` 0.0014641284942627
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00032901763916016
(252) DESCRIBE `ports` 0.001500129699707
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00041818618774414
(254) DESCRIBE `ports` 0.0013649463653564
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00032520294189453
(256) DESCRIBE `ports` 0.0014088153839111
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040411949157715
(258) DESCRIBE `ports` 0.0016560554504395
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033116340637207
(260) DESCRIBE `ports` 0.0014498233795166
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00037693977355957
(262) DESCRIBE `ports` 0.0014190673828125
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00042390823364258
(264) DESCRIBE `ports` 0.0016241073608398
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036287307739258
(266) DESCRIBE `ports` 0.0016939640045166
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037002563476562
(268) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69331') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0072178840637207
(269) DESCRIBE `avid_specials` 0.0017039775848389
(270) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69331 and class = 'Cruise') OR (item_id = 105 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.0017759799957275
(271) DESCRIBE `cruiselines` 0.0025701522827148
(272) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00052881240844727
(273) DESCRIBE `orchid_image` 0.002094030380249
(274) DESCRIBE `cruiselines` 0.002316951751709
(275) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00046682357788086
(276) DESCRIBE `cruises` 0.0037257671356201
(277) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69290') 0.00052809715270996
(278) DESCRIBE `ships` 0.0037190914154053
(279) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00064301490783691
(280) DESCRIBE `ships` 0.0034570693969727
(281) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00045585632324219
(282) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031018257141113
(283) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027680397033691
(284) DESCRIBE `itineraries` 0.0014798641204834
(285) DESCRIBE `ports` 0.0014889240264893
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041985511779785
(287) DESCRIBE `ports` 0.0014510154724121
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049018859863281
(289) DESCRIBE `ports` 0.0015120506286621
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030708312988281
(291) DESCRIBE `sailingdates` 0.0014081001281738
(292) DESCRIBE `ports` 0.001446008682251
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037312507629395
(294) DESCRIBE `ports` 0.0014610290527344
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035810470581055
(296) DESCRIBE `ports` 0.0015029907226562
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040912628173828
(298) DESCRIBE `ports` 0.0014801025390625
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00035190582275391
(300) DESCRIBE `ports` 0.0013980865478516
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0003349781036377
(302) DESCRIBE `ports` 0.0014398097991943
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00037097930908203
(304) DESCRIBE `ports` 0.0013740062713623
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0003359317779541
(306) DESCRIBE `ports` 0.0014150142669678
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00031614303588867
(308) DESCRIBE `ports` 0.0014889240264893
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00034213066101074
(310) DESCRIBE `ports` 0.0014209747314453
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00036191940307617
(312) DESCRIBE `ports` 0.0013489723205566
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00037384033203125
(314) DESCRIBE `ports` 0.0013818740844727
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00030112266540527
(316) DESCRIBE `ports` 0.0013020038604736
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00032877922058105
(318) DESCRIBE `ports` 0.0020020008087158
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00042295455932617
(320) DESCRIBE `ports` 0.0016360282897949
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003969669342041
(322) DESCRIBE `ports` 0.0015449523925781
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040197372436523
(324) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69290') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0096099376678467
(325) DESCRIBE `avid_specials` 0.0019280910491943
(326) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69290 and class = 'Cruise') OR (item_id = 1409 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.0013110637664795
(327) DESCRIBE `cruiselines` 0.0022470951080322
(328) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00056600570678711
(329) DESCRIBE `orchid_image` 0.0018570423126221
(330) DESCRIBE `cruiselines` 0.0022110939025879
(331) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0005950927734375
(332) DESCRIBE `cruises` 0.0035631656646729
(333) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69732') 0.00043702125549316
(334) DESCRIBE `ships` 0.0031030178070068
(335) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1021))) 0.0005340576171875
(336) DESCRIBE `ships` 0.0030169486999512
(337) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1021') 0.00036311149597168
(338) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026988983154297
(339) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025582313537598
(340) DESCRIBE `itineraries` 0.0013761520385742
(341) DESCRIBE `ports` 0.0013749599456787
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00040102005004883
(343) DESCRIBE `ports` 0.0017480850219727
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00031304359436035
(345) DESCRIBE `ports` 0.0024030208587646
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00042104721069336
(347) DESCRIBE `sailingdates` 0.0017049312591553
(348) DESCRIBE `ports` 0.001863956451416
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00046586990356445
(350) DESCRIBE `ports` 0.0018157958984375
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00035190582275391
(352) DESCRIBE `ports` 0.0017452239990234
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00034499168395996
(354) DESCRIBE `ports` 0.0014169216156006
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00029897689819336
(356) DESCRIBE `ports` 0.001392126083374
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0003361701965332
(358) DESCRIBE `ports` 0.0015439987182617
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00034999847412109
(360) DESCRIBE `ports` 0.0014538764953613
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00039911270141602
(362) DESCRIBE `ports` 0.0013580322265625
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00027894973754883
(364) DESCRIBE `ports` 0.0013668537139893
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00036811828613281
(366) DESCRIBE `ports` 0.0013000965118408
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00028896331787109
(368) DESCRIBE `ports` 0.001662015914917
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00039005279541016
(370) DESCRIBE `ports` 0.001323938369751
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00029301643371582
(372) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69732') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0060498714447021
(373) DESCRIBE `avid_specials` 0.0014328956604004
(374) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69732 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.0011880397796631
(375) DESCRIBE `cruiselines` 0.0020499229431152
(376) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00035595893859863
(377) DESCRIBE `orchid_image` 0.0016357898712158
(378) DESCRIBE `cruiselines` 0.002730131149292
(379) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00043392181396484
(380) DESCRIBE `cruises` 0.0033118724822998
(381) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73063') 0.00052404403686523
(382) DESCRIBE `ships` 0.0031719207763672
(383) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00056695938110352
(384) DESCRIBE `ships` 0.0029990673065186
(385) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00047087669372559
(386) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005028247833252
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029897689819336
(388) DESCRIBE `itineraries` 0.0014641284942627
(389) DESCRIBE `ports` 0.0014960765838623
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00037693977355957
(391) DESCRIBE `ports` 0.0014429092407227
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033092498779297
(393) DESCRIBE `ports` 0.0013930797576904
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034308433532715
(395) DESCRIBE `sailingdates` 0.0011930465698242
(396) DESCRIBE `ports` 0.0014820098876953
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00037908554077148
(398) DESCRIBE `ports` 0.0013689994812012
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00033187866210938
(400) DESCRIBE `ports` 0.0012989044189453
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00029897689819336
(402) DESCRIBE `ports` 0.0013599395751953
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00027704238891602
(404) DESCRIBE `ports` 0.0013830661773682
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00033211708068848
(406) DESCRIBE `ports` 0.0016131401062012
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00030088424682617
(408) DESCRIBE `ports` 0.0013611316680908
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0
(410) DESCRIBE `ports` 0.0012660026550293
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00029611587524414
(412) DESCRIBE `ports` 0.0012838840484619
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00032496452331543
(414) DESCRIBE `ports` 0.0013840198516846
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00072097778320312
(416) 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.0057079792022705
(417) DESCRIBE `avid_specials` 0.0015881061553955
(418) 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.00099897384643555
(419) DESCRIBE `cruiselines` 0.002039909362793
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00044798851013184
(421) DESCRIBE `orchid_image` 0.0015819072723389
(422) DESCRIBE `cruiselines` 0.0018379688262939
(423) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00031208992004395
(424) DESCRIBE `cruises` 0.0037720203399658
(425) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49460') 0.0004880428314209
(426) DESCRIBE `ships` 0.0028619766235352
(427) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00041007995605469
(428) DESCRIBE `ships` 0.0031089782714844
(429) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00044608116149902
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035691261291504
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(432) DESCRIBE `itineraries` 0.0017919540405273
(433) DESCRIBE `ports` 0.0019850730895996
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00050806999206543
(435) DESCRIBE `ports` 0.0018038749694824
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00046706199645996
(437) DESCRIBE `ports` 0.0017390251159668
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00045990943908691
(439) DESCRIBE `sailingdates` 0.001521110534668
(440) DESCRIBE `ports` 0.0016109943389893
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003809928894043
(442) DESCRIBE `ports` 0.0017321109771729
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00076007843017578
(444) DESCRIBE `ports` 0.0015609264373779
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00040578842163086
(446) DESCRIBE `ports` 0.0020949840545654
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00048184394836426
(448) DESCRIBE `ports` 0.0026209354400635
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00055217742919922
(450) DESCRIBE `ports` 0.0021328926086426
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00045895576477051
(452) DESCRIBE `ports` 0.0018351078033447
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00051593780517578
(454) DESCRIBE `ports` 0.0019412040710449
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00051593780517578
(456) DESCRIBE `ports` 0.0020098686218262
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00053095817565918
(458) DESCRIBE `ports` 0.0025298595428467
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00041699409484863
(460) DESCRIBE `ports` 0.0016260147094727
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00048398971557617
(462) DESCRIBE `ports` 0.0014920234680176
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00036501884460449
(464) DESCRIBE `ports` 0.0016169548034668
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.0003969669342041
(466) DESCRIBE `ports` 0.0015771389007568
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00031113624572754
(468) DESCRIBE `ports` 0.0015139579772949
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 407))) 0.00035786628723145
(470) DESCRIBE `ports` 0.0014219284057617
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '407') 0.00032901763916016
(472) DESCRIBE `ports` 0.0017669200897217
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2519))) 0.00036191940307617
(474) DESCRIBE `ports` 0.00164794921875
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2519') 0.00037789344787598
(476) DESCRIBE `ports` 0.0014510154724121
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00034999847412109
(478) DESCRIBE `ports` 0.0016410350799561
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 7.6055526733398E-5
(480) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '49460') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0062310695648193
(481) DESCRIBE `avid_specials` 0.00177001953125
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49460 and class = 'Cruise') OR (item_id = 434 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.001568078994751
(483) DESCRIBE `cruiselines` 0.002418041229248
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00047016143798828
(485) DESCRIBE `orchid_image` 0.0018889904022217
(486) DESCRIBE `cruiselines` 0.0021481513977051
(487) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00041103363037109
(488) DESCRIBE `cruises` 0.0030398368835449
(489) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63245') 0.00036978721618652
(490) DESCRIBE `ships` 0.0030179023742676
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.0005948543548584
(492) DESCRIBE `ships` 0.0026068687438965
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00021100044250488
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029897689819336
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(496) DESCRIBE `itineraries` 0.0014519691467285
(497) DESCRIBE `ports` 0.0014889240264893
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037097930908203
(499) DESCRIBE `ports` 0.0013840198516846
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030112266540527
(501) DESCRIBE `ports` 0.0012531280517578
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00031709671020508
(503) DESCRIBE `sailingdates` 0.0011990070343018
(504) DESCRIBE `ports` 0.0016758441925049
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003819465637207
(506) DESCRIBE `ports` 0.0012919902801514
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002901554107666
(508) DESCRIBE `ports` 0.0013878345489502
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0003349781036377
(510) DESCRIBE `ports` 0.0013129711151123
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.0004270076751709
(512) DESCRIBE `ports` 0.0013260841369629
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00034999847412109
(514) DESCRIBE `ports` 0.0013630390167236
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00029492378234863
(516) DESCRIBE `ports` 0.0012788772583008
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00029587745666504
(518) DESCRIBE `ports` 0.0013270378112793
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00029897689819336
(520) DESCRIBE `ports` 0.001276969909668
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00036883354187012
(522) DESCRIBE `ports` 0.0015859603881836
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00032687187194824
(524) DESCRIBE `ports` 0.0012829303741455
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0003199577331543
(526) DESCRIBE `ports` 0.0013828277587891
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.0002751350402832
(528) DESCRIBE `ports` 0.0013298988342285
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00029516220092773
(530) DESCRIBE `ports` 0.0013160705566406
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00029897689819336
(532) DESCRIBE `ports` 0.0013790130615234
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00044703483581543
(534) DESCRIBE `ports` 0.0015690326690674
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00030303001403809
(536) DESCRIBE `ports` 0.001370906829834
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00041007995605469
(538) DESCRIBE `ports` 0.0016770362854004
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00034809112548828
(540) DESCRIBE `ports` 0.0016629695892334
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0004279613494873
(542) DESCRIBE `ports` 0.0018179416656494
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00038504600524902
(544) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63245') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0065348148345947
(545) DESCRIBE `avid_specials` 0.0015020370483398
(546) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63245 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.0010559558868408
(547) DESCRIBE `cruiselines` 0.0020320415496826
(548) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00045299530029297
(549) DESCRIBE `orchid_image` 0.0017440319061279
(550) DESCRIBE `cruiselines` 0.0019149780273438
(551) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00033998489379883
(552) DESCRIBE `cruises` 0.002532958984375
(553) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69311') 0.00048303604125977
(554) DESCRIBE `ships` 0.0032141208648682
(555) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00043988227844238
(556) DESCRIBE `ships` 0.0030970573425293
(557) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00035381317138672
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028800964355469
(559) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(560) DESCRIBE `itineraries` 0.0015549659729004
(561) DESCRIBE `ports` 0.001823902130127
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047397613525391
(563) DESCRIBE `ports` 0.0017969608306885
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041103363037109
(565) DESCRIBE `ports` 0.0018439292907715
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00031805038452148
(567) DESCRIBE `sailingdates` 0.0011489391326904
(568) DESCRIBE `ports` 0.0013978481292725
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00040793418884277
(570) DESCRIBE `ports` 0.0016288757324219
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00038981437683105
(572) DESCRIBE `ports` 0.0018219947814941
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00035691261291504
(574) DESCRIBE `ports` 0.0012800693511963
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00028514862060547
(576) DESCRIBE `ports` 0.0013041496276855
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00036716461181641
(578) DESCRIBE `ports` 0.0013198852539062
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028204917907715
(580) DESCRIBE `ports` 0.0012900829315186
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0003058910369873
(582) DESCRIBE `ports` 0.0012800693511963
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00027990341186523
(584) DESCRIBE `ports` 0.0012838840484619
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00041103363037109
(586) DESCRIBE `ports` 0.0012869834899902
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028896331787109
(588) DESCRIBE `ports` 0.0013530254364014
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00029397010803223
(590) DESCRIBE `ports` 0.0012621879577637
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00031399726867676
(592) DESCRIBE `ports` 0.0016331672668457
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00036406517028809
(594) DESCRIBE `ports` 0.0013818740844727
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00031304359436035
(596) DESCRIBE `ports` 0.0012590885162354
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031805038452148
(598) DESCRIBE `ports` 0.0014729499816895
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00033307075500488
(600) DESCRIBE `ports` 0.0013880729675293
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030207633972168
(602) DESCRIBE `ports` 0.0015029907226562
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027799606323242
(604) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69311') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0061430931091309
(605) DESCRIBE `avid_specials` 0.0014498233795166
(606) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69311 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.001147985458374
(607) DESCRIBE `cruiselines` 0.0018761157989502
(608) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00035810470581055
(609) DESCRIBE `orchid_image` 0.0014441013336182
(610) DESCRIBE `cruiselines` 0.0019779205322266
(611) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00031518936157227
(612) DESCRIBE `ships` 0.0029659271240234
(613) SELECT `ships`.* FROM `ships` WHERE (id IN ('1135', '349', '542', '406', '434', '1021', '253', '678', '451', '105', '348', '1409', '341', '580', '98', '290', '291')) ORDER BY FIND_IN_SET(id, '1135,349,542,406,434,1021,253,678,451,105,348,1409,341,580,98,290,291') 0.0013480186462402
(614) DESCRIBE `cruisetypes` 0.0012578964233398
(615) DESCRIBE `destinations` 0.0017440319061279
(616) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '43', '53', '48', '8', '37', '29', '40', '38', '34', '22', '28', '30')) ORDER BY FIND_IN_SET(id, '12,35,43,53,48,8,37,29,40,38,34,22,28,30') 0.0013859272003174
(617) DESCRIBE `cruiselines` 0.0019068717956543
(618) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034785270690918
(619) DESCRIBE `cruiselines` 0.0021140575408936
(620) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0003809928894043