or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 1.1197171211243

# Query Time
(1) connect 0.0012240409851074
(2) DESCRIBE `cruises` 0.0040738582611084
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67820, 69695, 69340, 69467, 69694, 72570, 63244, 69311, 69468, 63243)) ORDER BY FIND_IN_SET(id, '67820,69695,69340,69467,69694,72570,63244,69311,69468,63243') 0.0025060176849365
(4) DESCRIBE `cruises` 0.0066788196563721
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67820') 0.00052380561828613
(6) DESCRIBE `ships` 0.0036048889160156
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00064492225646973
(8) DESCRIBE `ships` 0.0038847923278809
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.000518798828125
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00058102607727051
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(12) DESCRIBE `itineraries` 0.0017640590667725
(13) DESCRIBE `ports` 0.002100944519043
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0007331371307373
(15) DESCRIBE `ports` 0.0032110214233398
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00047802925109863
(17) DESCRIBE `ports` 0.0019528865814209
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00040411949157715
(19) DESCRIBE `sailingdates` 0.0016970634460449
(20) DESCRIBE `ports` 0.0024020671844482
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00069999694824219
(22) DESCRIBE `ports` 0.0021450519561768
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.0004730224609375
(24) DESCRIBE `ports` 0.0020458698272705
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00050520896911621
(26) DESCRIBE `ports` 0.0020170211791992
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00040602684020996
(28) DESCRIBE `ports` 0.0021049976348877
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00052809715270996
(30) DESCRIBE `ports` 0.0019102096557617
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00041794776916504
(32) DESCRIBE `ports` 0.0018630027770996
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00048279762268066
(34) DESCRIBE `ports` 0.0023849010467529
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00060892105102539
(36) DESCRIBE `ports` 0.0024769306182861
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00052595138549805
(38) DESCRIBE `ports` 0.0020260810852051
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.0004429817199707
(40) DESCRIBE `ports` 0.0019199848175049
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00050497055053711
(42) DESCRIBE `ports` 0.0025701522827148
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.0005640983581543
(44) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67820') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.013914823532104
(45) DESCRIBE `avid_specials` 0.0020408630371094
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67820 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.0025560855865479
(47) DESCRIBE `cruiselines` 0.0028350353240967
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00048089027404785
(49) DESCRIBE `orchid_image` 0.0022819042205811
(50) DESCRIBE `cruiselines` 0.00335693359375
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00058698654174805
(52) DESCRIBE `cruises` 0.0038681030273438
(53) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69695') 0.00053095817565918
(54) DESCRIBE `ships` 0.0040910243988037
(55) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00060391426086426
(56) DESCRIBE `ships` 0.0045390129089355
(57) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00051498413085938
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036787986755371
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(60) DESCRIBE `itineraries` 0.00201416015625
(61) DESCRIBE `ports` 0.0027270317077637
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00057005882263184
(63) DESCRIBE `ports` 0.0024290084838867
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00050806999206543
(65) DESCRIBE `ports` 0.003629207611084
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0005037784576416
(67) DESCRIBE `sailingdates` 0.0020279884338379
(68) DESCRIBE `ports` 0.0025219917297363
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00074982643127441
(70) DESCRIBE `ports` 0.0042910575866699
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00056600570678711
(72) DESCRIBE `ports` 0.002903938293457
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0005040168762207
(74) DESCRIBE `ports` 0.0019168853759766
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00039815902709961
(76) DESCRIBE `ports` 0.0018620491027832
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00045013427734375
(78) DESCRIBE `ports` 0.0022239685058594
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00058293342590332
(80) DESCRIBE `ports` 0.0018670558929443
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00046801567077637
(82) DESCRIBE `ports` 0.0017528533935547
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00044703483581543
(84) DESCRIBE `ports` 0.0018229484558105
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043988227844238
(86) DESCRIBE `ports` 0.0016889572143555
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0003809928894043
(88) DESCRIBE `ports` 0.0016860961914062
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00041604042053223
(90) DESCRIBE `ports` 0.0017819404602051
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00040888786315918
(92) DESCRIBE `ports` 0.0017240047454834
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00046777725219727
(94) DESCRIBE `ports` 0.0017240047454834
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00042009353637695
(96) DESCRIBE `ports` 0.0017521381378174
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00047397613525391
(98) DESCRIBE `ports` 0.0017571449279785
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00040602684020996
(100) DESCRIBE `ports` 0.0017879009246826
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00043702125549316
(102) DESCRIBE `ports` 0.0018341541290283
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00038504600524902
(104) DESCRIBE `ports` 0.0016841888427734
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044894218444824
(106) DESCRIBE `ports` 0.0016798973083496
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00037288665771484
(108) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69695') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0082058906555176
(109) DESCRIBE `avid_specials` 0.0017869472503662
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69695 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.0015568733215332
(111) DESCRIBE `cruiselines` 0.0032951831817627
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00054192543029785
(113) DESCRIBE `orchid_image` 0.0021450519561768
(114) DESCRIBE `cruiselines` 0.0028660297393799
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00047993659973145
(116) DESCRIBE `cruises` 0.0038571357727051
(117) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69340') 0.00051712989807129
(118) DESCRIBE `ships` 0.0039331912994385
(119) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.0008389949798584
(120) DESCRIBE `ships` 0.0064990520477295
(121) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00061297416687012
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00070691108703613
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034403800964355
(124) DESCRIBE `itineraries` 0.0030829906463623
(125) DESCRIBE `ports` 0.0028378963470459
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057888031005859
(127) DESCRIBE `ports` 0.0021421909332275
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004570484161377
(129) DESCRIBE `ports` 0.001910924911499
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042891502380371
(131) DESCRIBE `sailingdates` 0.0016829967498779
(132) DESCRIBE `ports` 0.0021159648895264
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047111511230469
(134) DESCRIBE `ports` 0.0019330978393555
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043201446533203
(136) DESCRIBE `ports` 0.0019619464874268
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044417381286621
(138) DESCRIBE `ports` 0.00193190574646
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040793418884277
(140) DESCRIBE `ports` 0.0019700527191162
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00047707557678223
(142) DESCRIBE `ports` 0.0019629001617432
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.0004880428314209
(144) DESCRIBE `ports` 0.0025370121002197
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0011999607086182
(146) DESCRIBE `ports` 0.0022931098937988
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00044012069702148
(148) DESCRIBE `ports` 0.0019900798797607
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.0010230541229248
(150) DESCRIBE `ports` 0.0024330615997314
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00042295455932617
(152) DESCRIBE `ports` 0.0019369125366211
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00048613548278809
(154) DESCRIBE `ports` 0.0018651485443115
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00043821334838867
(156) DESCRIBE `ports` 0.0019729137420654
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059890747070312
(158) DESCRIBE `ports` 0.002561092376709
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043797492980957
(160) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69340') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.010457038879395
(161) DESCRIBE `avid_specials` 0.0037379264831543
(162) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69340 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.002741813659668
(163) DESCRIBE `cruiselines` 0.0070641040802002
(164) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00073599815368652
(165) DESCRIBE `orchid_image` 0.0035929679870605
(166) DESCRIBE `cruiselines` 0.0036709308624268
(167) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00064897537231445
(168) DESCRIBE `cruises` 0.0098681449890137
(169) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69467') 0.00074195861816406
(170) DESCRIBE `ships` 0.053303003311157
(171) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00075197219848633
(172) DESCRIBE `ships` 0.0050358772277832
(173) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.0034821033477783
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048708915710449
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0013158321380615
(176) DESCRIBE `itineraries` 0.002039909362793
(177) DESCRIBE `ports` 0.0030479431152344
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.0011289119720459
(179) DESCRIBE `ports` 0.002147912979126
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00060105323791504
(181) DESCRIBE `ports` 0.0024669170379639
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00044083595275879
(183) DESCRIBE `sailingdates` 0.0019021034240723
(184) DESCRIBE `ports` 0.0021820068359375
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00090384483337402
(186) DESCRIBE `ports` 0.0042200088500977
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00045490264892578
(188) DESCRIBE `ports` 0.0023350715637207
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00052094459533691
(190) DESCRIBE `ports` 0.002051830291748
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00046205520629883
(192) DESCRIBE `ports` 0.002424955368042
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00047898292541504
(194) DESCRIBE `ports` 0.0019350051879883
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00043106079101562
(196) DESCRIBE `ports` 0.0019071102142334
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.0011839866638184
(198) DESCRIBE `ports` 0.0029680728912354
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00055289268493652
(200) DESCRIBE `ports` 0.0020449161529541
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00071597099304199
(202) DESCRIBE `ports` 0.0025060176849365
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00052189826965332
(204) DESCRIBE `ports` 0.0037558078765869
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00054597854614258
(206) DESCRIBE `ports` 0.001945972442627
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00043201446533203
(208) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69467') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0097541809082031
(209) DESCRIBE `avid_specials` 0.0019259452819824
(210) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69467 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.0024211406707764
(211) DESCRIBE `cruiselines` 0.0028181076049805
(212) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0005640983581543
(213) DESCRIBE `orchid_image` 0.002068042755127
(214) DESCRIBE `cruiselines` 0.0029919147491455
(215) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00054311752319336
(216) DESCRIBE `cruises` 0.0037529468536377
(217) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69694') 0.00058507919311523
(218) DESCRIBE `ships` 0.0040550231933594
(219) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00066590309143066
(220) DESCRIBE `ships` 0.0041778087615967
(221) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00063395500183105
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00060701370239258
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0014340877532959
(224) DESCRIBE `itineraries` 0.0022308826446533
(225) DESCRIBE `ports` 0.0022752285003662
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00077199935913086
(227) DESCRIBE `ports` 0.0018630027770996
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00046515464782715
(229) DESCRIBE `ports` 0.0017020702362061
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043106079101562
(231) DESCRIBE `sailingdates` 0.001662015914917
(232) DESCRIBE `ports` 0.0023291110992432
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00053906440734863
(234) DESCRIBE `ports` 0.0020298957824707
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00066614151000977
(236) DESCRIBE `ports` 0.0022530555725098
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00049495697021484
(238) DESCRIBE `ports` 0.0022649765014648
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00045084953308105
(240) DESCRIBE `ports` 0.0015900135040283
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00039815902709961
(242) DESCRIBE `ports` 0.0016460418701172
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00043010711669922
(244) DESCRIBE `ports` 0.00177001953125
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00059890747070312
(246) DESCRIBE `ports` 0.0021450519561768
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00072288513183594
(248) DESCRIBE `ports` 0.0025498867034912
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0006110668182373
(250) DESCRIBE `ports` 0.0021309852600098
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00050711631774902
(252) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69694') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0099620819091797
(253) DESCRIBE `avid_specials` 0.017618894577026
(254) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69694 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.0026638507843018
(255) DESCRIBE `cruiselines` 0.003903865814209
(256) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0010731220245361
(257) DESCRIBE `orchid_image` 0.0022799968719482
(258) DESCRIBE `cruiselines` 0.0030291080474854
(259) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00059080123901367
(260) DESCRIBE `cruises` 0.0041601657867432
(261) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72570') 0.00058388710021973
(262) DESCRIBE `ships` 0.0077788829803467
(263) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 580))) 0.00076389312744141
(264) DESCRIBE `ships` 0.0040481090545654
(265) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '580') 0.00078797340393066
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0006098747253418
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003809928894043
(268) DESCRIBE `itineraries` 0.0030310153961182
(269) DESCRIBE `ports` 0.0043559074401855
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0006859302520752
(271) DESCRIBE `ports` 0.00217604637146
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00051403045654297
(273) DESCRIBE `ports` 0.0022060871124268
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0005190372467041
(275) DESCRIBE `sailingdates` 0.0023860931396484
(276) DESCRIBE `ports` 0.002223014831543
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00059914588928223
(278) DESCRIBE `ports` 0.0025019645690918
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00087285041809082
(280) DESCRIBE `ports` 0.0031571388244629
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00062012672424316
(282) DESCRIBE `ports` 0.0020630359649658
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00048685073852539
(284) DESCRIBE `ports` 0.0045108795166016
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00061416625976562
(286) DESCRIBE `ports` 0.0020720958709717
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00045394897460938
(288) DESCRIBE `ports` 0.0017099380493164
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00047397613525391
(290) DESCRIBE `ports` 0.001986026763916
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00046205520629883
(292) DESCRIBE `ports` 0.0032789707183838
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.0007929801940918
(294) DESCRIBE `ports` 0.0029540061950684
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00054478645324707
(296) DESCRIBE `ports` 0.0021519660949707
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00051617622375488
(298) DESCRIBE `ports` 0.0019168853759766
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00046491622924805
(300) DESCRIBE `ports` 0.0019950866699219
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00053501129150391
(302) DESCRIBE `ports` 0.0020968914031982
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00050497055053711
(304) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72570') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0094830989837646
(305) DESCRIBE `avid_specials` 0.0044059753417969
(306) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72570 and class = 'Cruise') OR (item_id = 580 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 29 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.0029599666595459
(307) DESCRIBE `cruiselines` 0.0029089450836182
(308) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00065517425537109
(309) DESCRIBE `orchid_image` 0.0021989345550537
(310) DESCRIBE `cruiselines` 0.0091660022735596
(311) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00060486793518066
(312) DESCRIBE `cruises` 0.006950855255127
(313) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63244') 0.00059008598327637
(314) DESCRIBE `ships` 0.0077741146087646
(315) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.0020220279693604
(316) DESCRIBE `ships` 0.0044960975646973
(317) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00054717063903809
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032591819763184
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(320) DESCRIBE `itineraries` 0.0029668807983398
(321) DESCRIBE `ports` 0.0036458969116211
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00084900856018066
(323) DESCRIBE `ports` 0.0022211074829102
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00049996376037598
(325) DESCRIBE `ports` 0.016146898269653
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00082683563232422
(327) DESCRIBE `sailingdates` 0.0029430389404297
(328) DESCRIBE `ports` 0.0040428638458252
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00066781044006348
(330) DESCRIBE `ports` 0.0023040771484375
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00044393539428711
(332) DESCRIBE `ports` 0.0018119812011719
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00045490264892578
(334) DESCRIBE `ports` 0.0023150444030762
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00049781799316406
(336) DESCRIBE `ports` 0.002514123916626
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.0008690357208252
(338) DESCRIBE `ports` 0.0022649765014648
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.0005190372467041
(340) DESCRIBE `ports` 0.0029149055480957
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0011110305786133
(342) DESCRIBE `ports` 0.0027430057525635
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00042009353637695
(344) DESCRIBE `ports` 0.0026581287384033
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0014548301696777
(346) DESCRIBE `ports` 0.0052030086517334
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00063300132751465
(348) DESCRIBE `ports` 0.0026040077209473
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00081801414489746
(350) DESCRIBE `ports` 0.0043020248413086
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00047206878662109
(352) DESCRIBE `ports` 0.0019378662109375
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00054693222045898
(354) DESCRIBE `ports` 0.0021219253540039
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00046300888061523
(356) DESCRIBE `ports` 0.0020091533660889
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00050592422485352
(358) DESCRIBE `ports` 0.0020139217376709
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00057697296142578
(360) DESCRIBE `ports` 0.0021429061889648
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00054407119750977
(362) DESCRIBE `ports` 0.0025022029876709
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00045490264892578
(364) DESCRIBE `ports` 0.0024650096893311
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00061893463134766
(366) DESCRIBE `ports` 0.0019898414611816
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00048303604125977
(368) 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.010324954986572
(369) DESCRIBE `avid_specials` 0.0018329620361328
(370) 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.0018420219421387
(371) DESCRIBE `cruiselines` 0.0035820007324219
(372) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00057220458984375
(373) DESCRIBE `orchid_image` 0.0022919178009033
(374) DESCRIBE `cruiselines` 0.0030148029327393
(375) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00050497055053711
(376) DESCRIBE `cruises` 0.0037989616394043
(377) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69311') 0.00056791305541992
(378) DESCRIBE `ships` 0.0037600994110107
(379) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00060892105102539
(380) DESCRIBE `ships` 0.003687858581543
(381) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00053596496582031
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029897689819336
(384) DESCRIBE `itineraries` 0.0018630027770996
(385) DESCRIBE `ports` 0.0019900798797607
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047183036804199
(387) DESCRIBE `ports` 0.001971960067749
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047087669372559
(389) DESCRIBE `ports` 0.001945972442627
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0004279613494873
(391) DESCRIBE `sailingdates` 0.0015721321105957
(392) DESCRIBE `ports` 0.0021748542785645
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00051283836364746
(394) DESCRIBE `ports` 0.0028200149536133
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00082206726074219
(396) DESCRIBE `ports` 0.0026180744171143
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0010759830474854
(398) DESCRIBE `ports` 0.0028879642486572
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00051093101501465
(400) DESCRIBE `ports` 0.0021660327911377
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00073814392089844
(402) DESCRIBE `ports` 0.002640962600708
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00061488151550293
(404) DESCRIBE `ports` 0.002453088760376
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00062799453735352
(406) DESCRIBE `ports` 0.002216100692749
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00050091743469238
(408) DESCRIBE `ports` 0.0019757747650146
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0006251335144043
(410) DESCRIBE `ports` 0.0020709037780762
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00045084953308105
(412) DESCRIBE `ports` 0.0019488334655762
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00046896934509277
(414) DESCRIBE `ports` 0.0021800994873047
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00042295455932617
(416) DESCRIBE `ports` 0.0023601055145264
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00099492073059082
(418) DESCRIBE `ports` 0.0028269290924072
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0013558864593506
(420) DESCRIBE `ports` 0.0034699440002441
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00053977966308594
(422) DESCRIBE `ports` 0.002312183380127
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00062704086303711
(424) DESCRIBE `ports` 0.0024549961090088
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00057101249694824
(426) DESCRIBE `ports` 0.0022869110107422
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00060796737670898
(428) 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.0091540813446045
(429) DESCRIBE `avid_specials` 0.0020391941070557
(430) 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.0019488334655762
(431) DESCRIBE `cruiselines` 0.0029239654541016
(432) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00059199333190918
(433) DESCRIBE `orchid_image` 0.0043818950653076
(434) DESCRIBE `cruiselines` 0.0037450790405273
(435) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0013108253479004
(436) DESCRIBE `cruises` 0.0068199634552002
(437) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69468') 0.00069403648376465
(438) DESCRIBE `ships` 0.0078129768371582
(439) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00080490112304688
(440) DESCRIBE `ships` 0.0049591064453125
(441) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00060486793518066
(442) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(443) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030684471130371
(444) DESCRIBE `itineraries` 0.0017499923706055
(445) DESCRIBE `ports` 0.0049901008605957
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00066208839416504
(447) DESCRIBE `ports` 0.0019621849060059
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00056314468383789
(449) DESCRIBE `ports` 0.0020520687103271
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00057601928710938
(451) DESCRIBE `sailingdates` 0.0019099712371826
(452) DESCRIBE `ports` 0.0024111270904541
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00080990791320801
(454) DESCRIBE `ports` 0.0021510124206543
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00049996376037598
(456) DESCRIBE `ports` 0.0020232200622559
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.00050902366638184
(458) DESCRIBE `ports` 0.0019381046295166
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00043606758117676
(460) DESCRIBE `ports` 0.0019819736480713
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00049996376037598
(462) DESCRIBE `ports` 0.0019819736480713
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00047492980957031
(464) DESCRIBE `ports` 0.0021569728851318
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00055122375488281
(466) DESCRIBE `ports` 0.0020580291748047
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00058507919311523
(468) DESCRIBE `ports` 0.002295970916748
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1431))) 0.00064611434936523
(470) DESCRIBE `ports` 0.0022211074829102
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1431') 0.00053000450134277
(472) DESCRIBE `ports` 0.0021631717681885
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00058603286743164
(474) DESCRIBE `ports` 0.002155065536499
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00054693222045898
(476) 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.0092458724975586
(477) DESCRIBE `avid_specials` 0.0022549629211426
(478) 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.0020601749420166
(479) DESCRIBE `cruiselines` 0.0040838718414307
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00072288513183594
(481) DESCRIBE `orchid_image` 0.0059990882873535
(482) DESCRIBE `cruiselines` 0.004396915435791
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00084495544433594
(484) DESCRIBE `cruises` 0.0041148662567139
(485) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63243') 0.00061583518981934
(486) DESCRIBE `ships` 0.0041530132293701
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00065803527832031
(488) DESCRIBE `ships` 0.0044770240783691
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00059294700622559
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037693977355957
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.000518798828125
(492) DESCRIBE `itineraries` 0.0023198127746582
(493) DESCRIBE `ports` 0.0023901462554932
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00060296058654785
(495) DESCRIBE `ports` 0.0038189888000488
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00068879127502441
(497) DESCRIBE `ports` 0.002018928527832
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00055694580078125
(499) DESCRIBE `sailingdates` 0.0017790794372559
(500) DESCRIBE `ports` 0.0021820068359375
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00060892105102539
(502) DESCRIBE `ports` 0.0031669139862061
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00057411193847656
(504) DESCRIBE `ports` 0.0023949146270752
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00061297416687012
(506) DESCRIBE `ports` 0.0029120445251465
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00052595138549805
(508) DESCRIBE `ports` 0.0020289421081543
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00052189826965332
(510) DESCRIBE `ports` 0.0020630359649658
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00041508674621582
(512) DESCRIBE `ports` 0.0018959045410156
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00053000450134277
(514) DESCRIBE `ports` 0.0021419525146484
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00057411193847656
(516) DESCRIBE `ports` 0.0020160675048828
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00060391426086426
(518) DESCRIBE `ports` 0.0027000904083252
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00064301490783691
(520) DESCRIBE `ports` 0.0028128623962402
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00058603286743164
(522) DESCRIBE `ports` 0.0027759075164795
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00072288513183594
(524) 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.011516094207764
(525) DESCRIBE `avid_specials` 0.0023128986358643
(526) 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.0039908885955811
(527) DESCRIBE `cruiselines` 0.0036840438842773
(528) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0017199516296387
(529) DESCRIBE `orchid_image` 0.0033318996429443
(530) DESCRIBE `cruiselines` 0.0046968460083008
(531) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0013949871063232
(532) DESCRIBE `ships` 0.0043520927429199
(533) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '1135', '434', '542', '451', '253', '406', '348', '678', '1409', '580', '1021', '105', '290', '98', '291', '341')) ORDER BY FIND_IN_SET(id, '349,1135,434,542,451,253,406,348,678,1409,580,1021,105,290,98,291,341') 0.0020210742950439
(534) DESCRIBE `cruisetypes` 0.0039470195770264
(535) DESCRIBE `destinations` 0.0028641223907471
(536) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '43', '8', '48', '38', '53', '29', '34', '37', '40', '22', '28', '30')) ORDER BY FIND_IN_SET(id, '12,35,43,8,48,38,53,29,34,37,40,22,28,30') 0.0022070407867432
(537) DESCRIBE `cruiselines` 0.0033829212188721
(538) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00065994262695312
(539) DESCRIBE `cruiselines` 0.0030779838562012
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00064802169799805