or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 1.4151549339294

# Query Time
(1) connect 0.0012249946594238
(2) DESCRIBE `cruises` 0.0045530796051025
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80652, 80655, 80656, 80657, 82416, 80651, 80658, 80659, 80660, 80661)) ORDER BY FIND_IN_SET(id, '80652,80655,80656,80657,82416,80651,80658,80659,80660,80661') 0.0023880004882812
(4) DESCRIBE `cruises` 0.013329982757568
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80652') 0.00054097175598145
(6) DESCRIBE `ships` 0.0039780139923096
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0093669891357422
(8) DESCRIBE `ships` 0.03955602645874
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.0010230541229248
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00059103965759277
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036787986755371
(12) DESCRIBE `itineraries` 0.023648977279663
(13) DESCRIBE `ports` 0.0082662105560303
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0013508796691895
(15) DESCRIBE `ports` 0.0028400421142578
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0017988681793213
(17) DESCRIBE `ports` 0.012047052383423
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00049495697021484
(19) DESCRIBE `sailingdates` 0.0077028274536133
(20) DESCRIBE `ports` 0.002371072769165
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00055408477783203
(22) DESCRIBE `ports` 0.0019261837005615
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040698051452637
(24) DESCRIBE `ports` 0.0032110214233398
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00059914588928223
(26) DESCRIBE `ports` 0.0020530223846436
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00053596496582031
(28) DESCRIBE `ports` 0.0020191669464111
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00055313110351562
(30) DESCRIBE `ports` 0.0021259784698486
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00051212310791016
(32) DESCRIBE `ports` 0.012363910675049
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00068283081054688
(34) DESCRIBE `ports` 0.0026490688323975
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00052094459533691
(36) DESCRIBE `ports` 0.0020990371704102
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00054001808166504
(38) DESCRIBE `ports` 0.0021169185638428
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00048518180847168
(40) DESCRIBE `ports` 0.0020380020141602
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00047206878662109
(42) DESCRIBE `ports` 0.0020198822021484
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00039911270141602
(44) DESCRIBE `ports` 0.0018401145935059
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00046205520629883
(46) DESCRIBE `ports` 0.001849889755249
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00039196014404297
(48) DESCRIBE `ports` 0.018993854522705
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00054311752319336
(50) DESCRIBE `ports` 0.0024709701538086
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00065898895263672
(52) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80652') AND (sailingdate >= '2019-12-15') 0.022423982620239
(53) DESCRIBE `avid_specials` 0.0021300315856934
(54) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80652 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.014358043670654
(55) DESCRIBE `cruiselines` 0.0032718181610107
(56) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00098991394042969
(57) DESCRIBE `orchid_image` 0.025768041610718
(58) DESCRIBE `cruiselines` 0.0030360221862793
(59) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00056600570678711
(60) DESCRIBE `cruises` 0.0041670799255371
(61) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80655') 0.00058102607727051
(62) DESCRIBE `ships` 0.0042629241943359
(63) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0006411075592041
(64) DESCRIBE `ships` 0.0041890144348145
(65) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00054192543029785
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034117698669434
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032496452331543
(68) DESCRIBE `itineraries` 0.0020880699157715
(69) DESCRIBE `ports` 0.0023350715637207
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00059604644775391
(71) DESCRIBE `ports` 0.0020639896392822
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00058197975158691
(73) DESCRIBE `ports` 0.002047061920166
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00052094459533691
(75) DESCRIBE `sailingdates` 0.0018918514251709
(76) DESCRIBE `ports` 0.016170978546143
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00075697898864746
(78) DESCRIBE `ports` 0.022658109664917
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00087285041809082
(80) DESCRIBE `ports` 0.0020861625671387
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00092983245849609
(82) DESCRIBE `ports` 0.0026400089263916
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00058603286743164
(84) DESCRIBE `ports` 0.0022759437561035
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00056886672973633
(86) DESCRIBE `ports` 0.0022530555725098
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00054097175598145
(88) DESCRIBE `ports` 0.0023269653320312
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00070309638977051
(90) DESCRIBE `ports` 0.002626895904541
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00075078010559082
(92) DESCRIBE `ports` 0.0024900436401367
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00054097175598145
(94) DESCRIBE `ports` 0.010308027267456
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0035738945007324
(96) DESCRIBE `ports` 0.0022821426391602
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0019118785858154
(98) DESCRIBE `ports` 0.02366304397583
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00058984756469727
(100) DESCRIBE `ports` 0.0066430568695068
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00076818466186523
(102) DESCRIBE `ports` 0.0022320747375488
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00060296058654785
(104) DESCRIBE `ports` 0.0023040771484375
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0005650520324707
(106) DESCRIBE `ports` 0.0020220279693604
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0004420280456543
(108) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80655') AND (sailingdate >= '2019-12-15') 0.0089049339294434
(109) DESCRIBE `avid_specials` 0.002079963684082
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80655 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0017659664154053
(111) DESCRIBE `cruiselines` 0.0032558441162109
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00076889991760254
(113) DESCRIBE `orchid_image` 0.0022759437561035
(114) DESCRIBE `cruiselines` 0.0031490325927734
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00061297416687012
(116) DESCRIBE `cruises` 0.0040819644927979
(117) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80656') 0.00055503845214844
(118) DESCRIBE `ships` 0.0041420459747314
(119) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00060606002807617
(120) DESCRIBE `ships` 0.0041251182556152
(121) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00054693222045898
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00037598609924316
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00035500526428223
(124) DESCRIBE `itineraries` 0.014757871627808
(125) DESCRIBE `ports` 0.0052840709686279
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050592422485352
(127) DESCRIBE `ports` 0.0021178722381592
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00084996223449707
(129) DESCRIBE `ports` 0.0020790100097656
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046896934509277
(131) DESCRIBE `sailingdates` 0.0017919540405273
(132) DESCRIBE `ports` 0.0018410682678223
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049686431884766
(134) DESCRIBE `ports` 0.0030529499053955
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00047707557678223
(136) DESCRIBE `ports` 0.0017979145050049
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00055193901062012
(138) DESCRIBE `ports` 0.0023620128631592
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00049591064453125
(140) DESCRIBE `ports` 0.0020909309387207
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00076103210449219
(142) DESCRIBE `ports` 0.0022070407867432
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00097203254699707
(144) DESCRIBE `ports` 0.0021638870239258
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00067996978759766
(146) DESCRIBE `ports` 0.0023300647735596
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00051212310791016
(148) DESCRIBE `ports` 0.0022318363189697
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00057506561279297
(150) DESCRIBE `ports` 0.0024850368499756
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00057005882263184
(152) DESCRIBE `ports` 0.002216100692749
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00053691864013672
(154) DESCRIBE `ports` 0.0023050308227539
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00047707557678223
(156) DESCRIBE `ports` 0.0020930767059326
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00043296813964844
(158) DESCRIBE `ports` 0.0019960403442383
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00050997734069824
(160) DESCRIBE `ports` 0.0020449161529541
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049710273742676
(162) DESCRIBE `ports` 0.0019400119781494
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00073885917663574
(164) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80656') AND (sailingdate >= '2019-12-15') 0.010475873947144
(165) DESCRIBE `avid_specials` 0.001971960067749
(166) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80656 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.032193899154663
(167) DESCRIBE `cruiselines` 0.016752004623413
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00088095664978027
(169) DESCRIBE `orchid_image` 0.0025749206542969
(170) DESCRIBE `cruiselines` 0.0030651092529297
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00066113471984863
(172) DESCRIBE `cruises` 0.0041170120239258
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80657') 0.00066208839416504
(174) DESCRIBE `ships` 0.0043380260467529
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0008089542388916
(176) DESCRIBE `ships` 0.0057320594787598
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00061583518981934
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00037479400634766
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036096572875977
(180) DESCRIBE `itineraries` 0.0020709037780762
(181) DESCRIBE `ports` 0.0057260990142822
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00063014030456543
(183) DESCRIBE `ports` 0.0020561218261719
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00059103965759277
(185) DESCRIBE `ports` 0.0040910243988037
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.001115083694458
(187) DESCRIBE `sailingdates` 0.002547025680542
(188) DESCRIBE `ports` 0.0022308826446533
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00072503089904785
(190) DESCRIBE `ports` 0.0021989345550537
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00056290626525879
(192) DESCRIBE `ports` 0.0021820068359375
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00049901008605957
(194) DESCRIBE `ports` 0.0028059482574463
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00068902969360352
(196) DESCRIBE `ports` 0.0023961067199707
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00055694580078125
(198) DESCRIBE `ports` 0.0020849704742432
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00049400329589844
(200) DESCRIBE `ports` 0.0022749900817871
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00050497055053711
(202) DESCRIBE `ports` 0.0020129680633545
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00038790702819824
(204) DESCRIBE `ports` 0.0020020008087158
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00054812431335449
(206) DESCRIBE `ports` 0.001878023147583
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00043416023254395
(208) DESCRIBE `ports` 0.0019710063934326
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0007479190826416
(210) DESCRIBE `ports` 0.0022609233856201
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00052809715270996
(212) DESCRIBE `ports` 0.0021471977233887
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00053811073303223
(214) DESCRIBE `ports` 0.0021100044250488
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00052809715270996
(216) DESCRIBE `ports` 0.0019938945770264
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00054192543029785
(218) DESCRIBE `ports` 0.0025200843811035
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00053191184997559
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80657') AND (sailingdate >= '2019-12-15') 0.0092148780822754
(221) DESCRIBE `avid_specials` 0.0020101070404053
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80657 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0020089149475098
(223) DESCRIBE `cruiselines` 0.0030448436737061
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00069999694824219
(225) DESCRIBE `orchid_image` 0.0025360584259033
(226) DESCRIBE `cruiselines` 0.0030901432037354
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00067591667175293
(228) DESCRIBE `cruises` 0.004572868347168
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82416') 0.00066304206848145
(230) DESCRIBE `ships` 0.0060889720916748
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00065207481384277
(232) DESCRIBE `ships` 0.0041041374206543
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00052404403686523
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00037097930908203
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003659725189209
(236) DESCRIBE `itineraries` 0.0021681785583496
(237) DESCRIBE `ports` 0.002453088760376
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00068497657775879
(239) DESCRIBE `ports` 0.0023188591003418
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00059604644775391
(241) DESCRIBE `ports` 0.0023400783538818
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00055909156799316
(243) DESCRIBE `sailingdates` 0.0021018981933594
(244) DESCRIBE `ports` 0.0024609565734863
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00059318542480469
(246) DESCRIBE `ports` 0.0026800632476807
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00062799453735352
(248) DESCRIBE `ports` 0.0023689270019531
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00063395500183105
(250) DESCRIBE `ports` 0.024832010269165
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00054597854614258
(252) DESCRIBE `ports` 0.0023999214172363
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00054287910461426
(254) DESCRIBE `ports` 0.0021049976348877
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00043106079101562
(256) DESCRIBE `ports` 0.0021300315856934
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.0013110637664795
(258) DESCRIBE `ports` 0.0022158622741699
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00048995018005371
(260) DESCRIBE `ports` 0.0020880699157715
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00049996376037598
(262) DESCRIBE `ports` 0.0024919509887695
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00051212310791016
(264) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82416') AND (sailingdate >= '2019-12-15') 0.018204927444458
(265) DESCRIBE `avid_specials` 0.0030150413513184
(266) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82416 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0018599033355713
(267) DESCRIBE `cruiselines` 0.0029609203338623
(268) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00058698654174805
(269) DESCRIBE `orchid_image` 0.0026168823242188
(270) DESCRIBE `cruiselines` 0.0030910968780518
(271) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00049901008605957
(272) DESCRIBE `cruises` 0.0038039684295654
(273) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80651') 0.00053787231445312
(274) DESCRIBE `ships` 0.0041441917419434
(275) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00092887878417969
(276) DESCRIBE `ships` 0.0043919086456299
(277) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00064897537231445
(278) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00038003921508789
(279) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00037288665771484
(280) DESCRIBE `itineraries` 0.0022091865539551
(281) DESCRIBE `ports` 0.0024161338806152
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00053811073303223
(283) DESCRIBE `ports` 0.002025842666626
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00052809715270996
(285) DESCRIBE `ports` 0.0020620822906494
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00056600570678711
(287) DESCRIBE `sailingdates` 0.0054399967193604
(288) DESCRIBE `ports` 0.002202033996582
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00053501129150391
(290) DESCRIBE `ports` 0.0022029876708984
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00052499771118164
(292) DESCRIBE `ports` 0.002122163772583
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00055885314941406
(294) DESCRIBE `ports` 0.002100944519043
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00049591064453125
(296) DESCRIBE `ports` 0.0021109580993652
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00053906440734863
(298) DESCRIBE `ports` 0.0020480155944824
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0008080005645752
(300) DESCRIBE `ports` 0.002284049987793
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00066089630126953
(302) DESCRIBE `ports` 0.0023090839385986
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0005030632019043
(304) DESCRIBE `ports` 0.0022590160369873
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00071001052856445
(306) DESCRIBE `ports` 0.0024089813232422
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.0005948543548584
(308) DESCRIBE `ports` 0.0080959796905518
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054287910461426
(310) DESCRIBE `ports` 0.0021541118621826
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00072908401489258
(312) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80651') AND (sailingdate >= '2019-12-15') 0.0098130702972412
(313) DESCRIBE `avid_specials` 0.0018858909606934
(314) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80651 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.002007007598877
(315) DESCRIBE `cruiselines` 0.0033619403839111
(316) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00064802169799805
(317) DESCRIBE `orchid_image` 0.0030310153961182
(318) DESCRIBE `cruiselines` 0.0035619735717773
(319) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00070095062255859
(320) DESCRIBE `cruises` 0.0044751167297363
(321) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80658') 0.00060105323791504
(322) DESCRIBE `ships` 0.0044949054718018
(323) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00069904327392578
(324) DESCRIBE `ships` 0.0042829513549805
(325) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00057291984558105
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00038909912109375
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00041294097900391
(328) DESCRIBE `itineraries` 0.0020759105682373
(329) DESCRIBE `ports` 0.0024330615997314
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00064706802368164
(331) DESCRIBE `ports` 0.0022060871124268
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057005882263184
(333) DESCRIBE `ports` 0.0022048950195312
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056099891662598
(335) DESCRIBE `sailingdates` 0.001945972442627
(336) DESCRIBE `ports` 0.0024030208587646
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071215629577637
(338) DESCRIBE `ports` 0.0024480819702148
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00058913230895996
(340) DESCRIBE `ports` 0.0020508766174316
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00052404403686523
(342) DESCRIBE `ports` 0.0021538734436035
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00049710273742676
(344) DESCRIBE `ports` 0.0030019283294678
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00057005882263184
(346) DESCRIBE `ports` 0.0020618438720703
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00063419342041016
(348) DESCRIBE `ports` 0.0023090839385986
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00079584121704102
(350) DESCRIBE `ports` 0.0022740364074707
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00058102607727051
(352) DESCRIBE `ports` 0.0022029876708984
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00057482719421387
(354) DESCRIBE `ports` 0.0022380352020264
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00048089027404785
(356) DESCRIBE `ports` 0.0021350383758545
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061202049255371
(358) DESCRIBE `ports` 0.0022540092468262
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00049209594726562
(360) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80658') AND (sailingdate >= '2019-12-15') 0.011804103851318
(361) DESCRIBE `avid_specials` 0.0021190643310547
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80658 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0023069381713867
(363) DESCRIBE `cruiselines` 0.0037200450897217
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00080585479736328
(365) DESCRIBE `orchid_image` 0.0028040409088135
(366) DESCRIBE `cruiselines` 0.0033118724822998
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.0006401538848877
(368) DESCRIBE `cruises` 0.0044510364532471
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80659') 0.00063705444335938
(370) DESCRIBE `ships` 0.0050618648529053
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00078296661376953
(372) DESCRIBE `ships` 0.019029140472412
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00060915946960449
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00042414665222168
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036478042602539
(376) DESCRIBE `itineraries` 0.0021240711212158
(377) DESCRIBE `ports` 0.0024230480194092
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006251335144043
(379) DESCRIBE `ports` 0.0024039745330811
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053811073303223
(381) DESCRIBE `ports` 0.0023150444030762
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046396255493164
(383) DESCRIBE `sailingdates` 0.0018479824066162
(384) DESCRIBE `ports` 0.002892017364502
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00078392028808594
(386) DESCRIBE `ports` 0.0043809413909912
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052309036254883
(388) DESCRIBE `ports` 0.0020360946655273
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00053095817565918
(390) DESCRIBE `ports` 0.025239944458008
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00069999694824219
(392) DESCRIBE `ports` 0.0027339458465576
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00072813034057617
(394) DESCRIBE `ports` 0.0024480819702148
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00053095817565918
(396) DESCRIBE `ports` 0.0033490657806396
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0012989044189453
(398) DESCRIBE `ports` 0.002439022064209
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.0022799968719482
(400) DESCRIBE `ports` 0.0021810531616211
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00053095817565918
(402) DESCRIBE `ports` 0.0020289421081543
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00043511390686035
(404) DESCRIBE `ports` 0.0021011829376221
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0007481575012207
(406) DESCRIBE `ports` 0.0023410320281982
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006248950958252
(408) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80659') AND (sailingdate >= '2019-12-15') 0.0093870162963867
(409) DESCRIBE `avid_specials` 0.0022218227386475
(410) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80659 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0019159317016602
(411) DESCRIBE `cruiselines` 0.0031619071960449
(412) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.0008089542388916
(413) DESCRIBE `orchid_image` 0.0027790069580078
(414) DESCRIBE `cruiselines` 0.0036880970001221
(415) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00096011161804199
(416) DESCRIBE `cruises` 0.0050251483917236
(417) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80660') 0.000701904296875
(418) DESCRIBE `ships` 0.012547016143799
(419) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00072288513183594
(420) DESCRIBE `ships` 0.0047149658203125
(421) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.0020768642425537
(422) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0057840347290039
(423) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0044047832489014
(424) DESCRIBE `itineraries` 0.010277032852173
(425) DESCRIBE `ports` 0.0038778781890869
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056195259094238
(427) DESCRIBE `ports` 0.0020749568939209
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042819976806641
(429) DESCRIBE `ports` 0.0020370483398438
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041079521179199
(431) DESCRIBE `sailingdates` 0.0016739368438721
(432) DESCRIBE `ports` 0.0020320415496826
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052213668823242
(434) DESCRIBE `ports` 0.0021059513092041
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043320655822754
(436) DESCRIBE `ports` 0.0024738311767578
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0006411075592041
(438) DESCRIBE `ports` 0.0024721622467041
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00056695938110352
(440) DESCRIBE `ports` 0.0022549629211426
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00058507919311523
(442) DESCRIBE `ports` 0.0022327899932861
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00054311752319336
(444) DESCRIBE `ports` 0.0022320747375488
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00055503845214844
(446) DESCRIBE `ports` 0.0021119117736816
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00048589706420898
(448) DESCRIBE `ports` 0.0020167827606201
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2472))) 0.000946044921875
(450) DESCRIBE `ports` 0.0021450519561768
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2472') 0.0011560916900635
(452) DESCRIBE `ports` 0.0022168159484863
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055384635925293
(454) DESCRIBE `ports` 0.0021378993988037
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051712989807129
(456) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80660') AND (sailingdate >= '2019-12-15') 0.0091450214385986
(457) DESCRIBE `avid_specials` 0.0020639896392822
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80660 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0020298957824707
(459) DESCRIBE `cruiselines` 0.003040075302124
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.0006558895111084
(461) DESCRIBE `orchid_image` 0.0023581981658936
(462) DESCRIBE `cruiselines` 0.0031170845031738
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00059604644775391
(464) DESCRIBE `cruises` 0.004127025604248
(465) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80661') 0.00057005882263184
(466) DESCRIBE `ships` 0.0044100284576416
(467) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00069093704223633
(468) DESCRIBE `ships` 0.0044560432434082
(469) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00063204765319824
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003812313079834
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036811828613281
(472) DESCRIBE `itineraries` 0.0021989345550537
(473) DESCRIBE `ports` 0.0023360252380371
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060009956359863
(475) DESCRIBE `ports` 0.0020987987518311
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053095817565918
(477) DESCRIBE `ports` 0.0022308826446533
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047206878662109
(479) DESCRIBE `sailingdates` 0.0019080638885498
(480) DESCRIBE `ports` 0.0024690628051758
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058889389038086
(482) DESCRIBE `ports` 0.0022590160369873
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00079488754272461
(484) DESCRIBE `ports` 0.0022189617156982
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00057506561279297
(486) DESCRIBE `ports` 0.0021991729736328
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00046801567077637
(488) DESCRIBE `ports` 0.0021979808807373
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00052404403686523
(490) DESCRIBE `ports` 0.0024898052215576
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00055098533630371
(492) DESCRIBE `ports` 0.0021998882293701
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00062203407287598
(494) DESCRIBE `ports` 0.0025501251220703
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00067591667175293
(496) DESCRIBE `ports` 0.0022799968719482
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00054478645324707
(498) DESCRIBE `ports` 0.0020551681518555
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00055503845214844
(500) DESCRIBE `ports` 0.01139497756958
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00078701972961426
(502) DESCRIBE `ports` 0.0083551406860352
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0028588771820068
(504) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80661') AND (sailingdate >= '2019-12-15') 0.01311182975769
(505) DESCRIBE `avid_specials` 0.0023760795593262
(506) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80661 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0068330764770508
(507) DESCRIBE `cruiselines` 0.004288911819458
(508) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00077390670776367
(509) DESCRIBE `orchid_image` 0.0024008750915527
(510) DESCRIBE `cruiselines` 0.0034542083740234
(511) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00073504447937012
(512) DESCRIBE `cruiselines` 0.0044329166412354
(513) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('264')) ORDER BY FIND_IN_SET(id, '264') 0.00090312957763672
(514) DESCRIBE `cruisetypes` 0.0096199512481689
(515) DESCRIBE `destinations` 0.0032198429107666
(516) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00080084800720215
(517) DESCRIBE `ships` 0.015230894088745
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0064308643341064
(519) DESCRIBE `ships` 0.0045130252838135
(520) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00066089630126953